4 Induction Services

This chapter describes the induction services. The primary role of these services is to create, modify, and delete price changes and clearances.

Price Change Induction Service

This service creates, modifies, or deletes price changes by calling the RPM_PRICE_CHANGE_INDUCTION_SQL package to load input data into staging tables and then calls the core RPM_CORESVC_PRICE_CHANGE_SQL package to validate and insert data to the RPM price change tables.

Service Type

POST

REST URL

/priceChange/induction

Input Parameters

Table 4-1 PriceChangeInductionRDO Input Parameters

Parameter Name	Data Type
action	String
newGroupBatch	Long
priceChangeGroup	Long
priceChangeGroupDesc	String
priceChange	Long
item	String
diff	String
locationType	String
location	Long
effectiveDate	Localdate
updatedEffectiveDate	Localdate
changeType	String
changeValue	BigDecimal
sellingUom	String
roundingRule	String
reason	String
status	String
ignoreConstraints	String

JSON Structure

[
  {
    "action": null,
    "newGroupBatch": null,
    "priceChangeGroup": null,
    "priceChangeGroupDesc": null,
    "priceChange": null,
    "item": null,
    "diff": null,
    "locationType": null,
    "location": null,
    "effectiveDate": null,
    "updatedEffectiveDate": null,
    "changeType": null,
    "changeValue": null,
    "sellingUom": null,
    "roundingRule": null,
    "reason": null,
    "status": null,
    "ignoreConstraints": null
  }
]

Output

The output will contain the status of the request including validation errors, if any.

Table 4-2 PriceChangeStatusRDO Ouput Parameters

Parameter Name	Data Type
statusMsg	String
failPcTable	List<PriceChangeFailRDO>

Table 4-3 PriceChangeFailRDO Ouput Parameters

Parameter Name	Data Type
priceChange	Long
item	String
diff	String
locationType	String
location	Long
effectiveDate	LocalDate
errorMsg	String

JSON Structure

[
  {
    "statusMsg": null,
    "failPcTable": [
      {
        "priceChange": null,
        "item": null,
        "diff": null,
        "locationType": null,
        "location": null,
        "effectiveDate": null,
        "errorMsg": null
      }
    ],
    "links": [],
    "hyperMediaContent": {
      "linkRDO": []
    }
  }
]

Table Impact

Table 4-4 Price Change induction Table Impact

TABLE	SELECT	INSERT	UPDATE	DELETE
SVC_PROCESS_TRACKER	Yes	Yes	Yes	No
RPM_SVC_PRICE_CHANGE	Yes	Yes	Yes	No
RPM_CORESVC_PRICE_CHANGE_ERR	Yes	Yes	No	No
RPM_PRICE_CHANGE	Yes	Yes	Yes	Yes

Clearance Induction Service

This section describes the Clearance Induction service. This service creates, modifies, or deletes clearances by calling the RPM_CLEARANCE_INDUCTION_SQL package to load input data into staging tables and then calls the core RPM_CORESVC_CLEARANCE_SQL package to validate and insert data to the RPM clearance tables.

Service Type

POST

REST URL

/clearance/induction

Input Parameters

Table 4-5 ClearanceInductionRDO Input Parameters

Parameter Name	Data Type
action	String
newGroupBatch	Long
clearanceGroup	Long
clearanceGroupDesc	String
clearance	Long
markdown	String
item	String
diff	String
locationType	String
location	Long
effectiveDate	Localdate
updatedEffectiveDate	Localdate
changeType	String
changeValue	BigDecimal
roundingRule	String
reason	String
status	String

JSON Structure

[
  {
    "action": null,
    "newGroupBatch": null,
    "clearanceGroup": null,
    "clearanceGroupDesc": null,
    "clearance": null,
    "markdown": null,
    "item": null,
    "diff": null,
    "locationType": null,
    "location": null,
    "effectiveDate": null,
    "updatedEffectiveDate": null,
    "changeType": null,
    "changeValue": null,
    "roundingRule": null,
    "reason": null,
    "status": null
  }
]

Output

The output will contain the status of the request including validation errors, if any.

Table 4-6 ClearanceStatusRDO Ouput Parameters

Parameter Name	Data Type
statusMsg	String
failClrTable	List<ClearanceFailRDO>

Table 4-7 ClearanceFailRDO Ouput Parameters

Parameter Name	Data Type
clearance	Long
item	String
diff	String
locationType	String
location	Long
effectiveDate	LocalDate
errorMsg	String

JSON Structure

[
  {
    "statusMsg": null,
    "failClrTable": [
      {
        "clearance": null,
        "item": null,
        "diff": null,
        "locationType": null,
        "location": null,
        "effectiveDate": null,
        "errorMsg": null
      }
    ],
    "links": [],
    "hyperMediaContent": {
      "linkRDO": []
    }
  }
]

Table Impact

Table 4-8 Clearance Induction Table Impact

TABLE	SELECT	INSERT	UPDATE	DELETE
SVC_PROCESS_TRACKER	Yes	Yes	Yes	No
RPM_SVC_CLEARANCE	Yes	Yes	Yes	No
RPM_CORESVC_CLEARANCE_ERR	Yes	Yes	No	No
RPM_CLEARANCE	Yes	Yes	Yes	Yes