55: -- Import source lines where action_flag = 'I'
56: --
57: PROCEDURE Import_Records(
58: p_source_code IN VARCHAR2,
59: p_changed_attributes IN WSH_INTERFACE.ChangedAttributeTabType,
60: x_return_status OUT NOCOPY VARCHAR2);
61:
62:
63: --
76: -- Then split the records accordingly where action_flag = 'S'.
77: --
78: PROCEDURE Split_Records(
79: p_source_code IN VARCHAR2,
80: p_changed_attributes IN WSH_INTERFACE.ChangedAttributeTabType,
81: p_interface_flag IN VARCHAR2,
82: x_return_status OUT NOCOPY VARCHAR2);
83:
84:
99: -- with the new values.
100: --
101: PROCEDURE Update_Records(
102: p_source_code IN VARCHAR2,
103: p_changed_attributes IN WSH_INTERFACE.ChangedAttributeTabType,
104: p_interface_flag IN VARCHAR2,
105: x_return_status OUT NOCOPY VARCHAR2);
106:
107:
116: -- and updates WSH_DELIVERY_DETAILS
117: --
118: PROCEDURE Update_Attributes(
119: p_source_code IN VARCHAR2,
120: p_attributes_rec IN WSH_INTERFACE.ChangedAttributeRecType,
121: p_changed_detail IN WSH_USA_CATEGORIES_PVT.ChangedDetailRec,
122: p_interface_flag IN VARCHAR2 , --bugfix 10175902
123: x_return_status OUT NOCOPY VARCHAR2);
124: