APPS.MSC_CL_OTHER_ODS_LOAD dependencies on MSC_WO_ATTRIBUTES

Line 4993: DELETE MSC_WO_ATTRIBUTES

4989: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'IN LOAD WO ATTRIBUTES- Inst :'||MSC_CL_COLLECTION.v_instance_id );
4990: FOR c_rec IN c_del LOOP
4991: BEGIN
4992:
4993: DELETE MSC_WO_ATTRIBUTES
4994: WHERE SR_INSTANCE_ID= c_rec.sr_instance_id
4995: AND VISIT_ID = c_rec.visit_id
4996: AND SUPPLY_ID = c_rec.supply_id
4997: AND ORGANIZATION_ID = c_rec.organization_id;

Line 5015: UPDATE MSC_WO_ATTRIBUTES

5011:
5012: BEGIN
5013:
5014: IF MSC_CL_COLLECTION.v_is_legacy_refresh THEN
5015: UPDATE MSC_WO_ATTRIBUTES
5016: SET
5017: SERIAL_NUM = c_rec.SERIAL_NUM,
5018: PRODUCES_TO_STOCK = c_rec.PRODUCES_TO_STOCK,
5019: VISIT_ID = c_rec.VISIT_ID,

Line 5043: INSERT INTO MSC_WO_ATTRIBUTES (

5039: END IF;
5040:
5041: IF (MSC_CL_COLLECTION.v_is_complete_refresh or MSC_CL_COLLECTION.v_is_partial_refresh) OR (MSC_CL_COLLECTION.v_is_legacy_refresh AND SQL%NOTFOUND) THEN
5042:
5043: INSERT INTO MSC_WO_ATTRIBUTES (
5044: SUPPLY_ID,
5045: PRODUCES_TO_STOCK,
5046: SERIAL_NUM,
5047: VISIT_ID,