DBA Data[Home] [Help]

APPS.MSC_CL_OTHER_ODS_LOAD dependencies on MSC_WO_TASK_HIERARCHY

Line 5142: DELETE MSC_WO_TASK_HIERARCHY

5138:
5139: FOR c_rec IN c_del LOOP
5140: BEGIN
5141:
5142: DELETE MSC_WO_TASK_HIERARCHY
5143: WHERE SR_INSTANCE_ID= c_rec.sr_instance_id
5144: AND CURR_SUPPLY_ID = c_rec.curr_supply_id
5145: AND NEXT_SUPPLY_ID = c_rec.next_supply_id
5146: AND ORGANIZATION_ID = c_rec.organization_id;

Line 5164: UPDATE MSC_WO_TASK_HIERARCHY

5160:
5161: BEGIN
5162:
5163: IF MSC_CL_COLLECTION.v_is_legacy_refresh THEN
5164: UPDATE MSC_WO_TASK_HIERARCHY
5165: SET
5166: PRECEDENCE_CONSTRAINT = c_rec.PRECEDENCE_CONSTRAINT,
5167: MIN_SEPARATION = c_rec.MIN_SEPARATION,
5168: MIN_SEP_TIME_UNIT = c_rec.MIN_SEP_TIME_UNIT,

Line 5183: INSERT INTO MSC_WO_TASK_HIERARCHY (

5179: END IF;
5180:
5181: 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
5182:
5183: INSERT INTO MSC_WO_TASK_HIERARCHY (
5184: CURR_SUPPLY_ID,
5185: NEXT_SUPPLY_ID,
5186: PRECEDENCE_CONSTRAINT,
5187: MIN_SEPARATION,