Stored procedures for both OTD level and interface tables level are defined in the utility package.
If it is located at the OTD root level, it copies the data from all Sun Staging Tables to the corresponding Oracle Interface Tables.
If it is located at the Interface Table level, then the data for only that specific Staging Table is copied to its corresponding Open Interface Table.
This procedure acts only on records with the ID values specified.
Depends upon the specific implementation. Typically, it contains at least four input VARCHAR parameters corresponding to:
sb_eway_id
sb_group_id
sb_object_id
sb_pass_or_fail
This parameter accepts the following values:
P– records that have passed
F– for records that have failed
I– all records
The stored procedure name is derived from the Open Interface name or the Staging Table name, according to the following convention:
At the root level:
If the OPEN_INTERFACE tab has a Util_Name attribute, then this value is used: SP_MOV<UTILNAME>. Otherwise, the value of the attribute Name is used: SP_MOV_<Open_Interface_Name>.
For example:
Customer Item: SP_MOV_CUSTITEMS
Item Import: SP_MOV_ITEM_IMPORT
At the staging table level:
If the Interface_Table tag has a Util_Name attribute, then this value is used: SP_MOV_<UTILNAME>. Otherwise, the short name of the Name attribute is used: SP_MOV_<Short_Table_Name>.
For example:
Customer Item: SP_MOV_MTL_CI_INTERFACE_INT
Item Import: SP_MOV_MTL_SYSTEM_ITEMS_INT