APPS.CLN_SYNCITEM_PKG dependencies on CLN_ITEMMST_DELETED_ITEMS

Line 969: -- This procedure archives the deleted items into 'cln_itemmst_deleted_items' table.

965: -- Name
966: -- ARCHIVE_DELETED_ITEMS
967: -- Purpose
968: -- This procedure is called from the 2A12 Workflow.
969: -- This procedure archives the deleted items into 'cln_itemmst_deleted_items' table.
970: --
971: -- Arguments
972: --
973: -- Notes

Line 1021: INSERT INTO cln_itemmst_deleted_items

1017:
1018: FOR del_rec in c_DeletedItems LOOP
1019:
1020: --table to hold the records of the deleted item, index being (inventory_item_id, customer_item_number)
1021: INSERT INTO cln_itemmst_deleted_items
1022: (inventory_item_id, organization_id, concatenated_segments, item_type, primary_uom_code, customer_item_number)
1023: VALUES
1024: (p_inventory_item_id, p_org_id, del_rec.concatenated_segments, del_rec.item_type, del_rec.primary_uom_code, del_rec.customer_item_number);
1025:

Line 1056: -- This procedure deletes the archived items from the 'cln_itemmst_deleted_items'.

1052: -- Name
1053: -- DELETE_ARCHIVED_ITEMS
1054: -- Purpose
1055: -- This procedure is called from the 2A12 Workflow.
1056: -- This procedure deletes the archived items from the 'cln_itemmst_deleted_items'.
1057: --
1058: -- Arguments
1059: --
1060: -- Notes

Line 1089: DELETE FROM cln_itemmst_deleted_items

1085: -- Retrieve Activity Attributes
1086: p_inventory_item_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'INVENTORY_ITEM_ID');
1087: p_org_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'ORGANIZATION_ID');
1088:
1089: DELETE FROM cln_itemmst_deleted_items
1090: WHERE inventory_item_id = p_inventory_item_id AND organization_id = p_org_id;
1091:
1092: -- Reached Here. Successful execution.
1093: x_progress := 'CLN_SYNCITEM_PKG.Delete_Archived_Items : Exiting Procedure';