APPS.MSC_CL_AHL_ODS_LOAD dependencies on MSC_WO_TASK_HIERARCHY

Line 819: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_WO_TASK_HIERARCHY',

815: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR
816: MSC_CL_COLLECTION.v_is_partial_refresh) THEN
817: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag =
818: MSC_UTIL.G_ALL_ORGANIZATIONS THEN
819: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_WO_TASK_HIERARCHY',
820: MSC_CL_COLLECTION.v_instance_id, -1);
821: ELSE
822: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
823: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_WO_TASK_HIERARCHY',

Line 823: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_WO_TASK_HIERARCHY',

819: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_WO_TASK_HIERARCHY',
820: MSC_CL_COLLECTION.v_instance_id, -1);
821: ELSE
822: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
823: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_WO_TASK_HIERARCHY',
824: MSC_CL_COLLECTION.v_instance_id,
825: null,
826: v_sub_str);
827: END IF;

Line 836: lv_tbl:= 'MSC_WO_TASK_HIERARCHY';

832: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN
833: lv_tbl:= 'WO_TASK_HIERARCHY_'||MSC_CL_COLLECTION.v_instance_code;
834: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
835: ELSE
836: lv_tbl:= 'MSC_WO_TASK_HIERARCHY';
837: lv_supplies_tbl:= 'MSC_SUPPLIES';
838: END IF;
839:
840: lv_cursor_stmt:=

Line 915: DELETE MSC_WO_TASK_HIERARCHY

911: IF (MSC_CL_COLLECTION.v_is_incremental_refresh) OR
912: MSC_CL_COLLECTION.v_is_legacy_refresh THEN
913: FOR c_rec IN c_del LOOP
914: BEGIN
915: DELETE MSC_WO_TASK_HIERARCHY
916: WHERE SR_INSTANCE_ID= c_rec.sr_instance_id
917: AND CURR_SUPPLY_ID = c_rec.curr_supply_id
918: AND NEXT_SUPPLY_ID = c_rec.next_supply_id
919: AND ORGANIZATION_ID = c_rec.organization_id;

Line 963: UPDATE MSC_WO_TASK_HIERARCHY

959: OPEN c_ref_cur FOR lv_cursor_stmt;
960: LOOP
961: fetch c_ref_cur into c_rec;
962: exit when c_ref_cur%notfound;
963: UPDATE MSC_WO_TASK_HIERARCHY
964: SET
965: PRECEDENCE_CONSTRAINT = c_rec.PRECEDENCE_CONSTRAINT,
966: MIN_SEPARATION = c_rec.MIN_SEPARATION,
967: MIN_SEP_TIME_UNIT = c_rec.MIN_SEP_TIME_UNIT,

Line 1046: 'MSC_WO_TASK_HIERARCHY',

1042:
1043: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1044: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
1045: lv_retcode,
1046: 'MSC_WO_TASK_HIERARCHY',
1047: MSC_CL_COLLECTION.v_INSTANCE_CODE,
1048: MSC_UTIL.G_ERROR);
1049:
1050: IF lv_retcode = MSC_UTIL.G_ERROR THEN