APPS.MSC_CL_AHL_ODS_LOAD dependencies on MSC_WO_OPERATION_REL

Line 1105: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_WO_OPERATION_REL',

1101: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR
1102: MSC_CL_COLLECTION.v_is_partial_refresh) THEN
1103: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag =
1104: MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1105: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_WO_OPERATION_REL',
1106: MSC_CL_COLLECTION.v_instance_id,
1107: -1);
1108: ELSE
1109: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

Line 1110: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_WO_OPERATION_REL',

1106: MSC_CL_COLLECTION.v_instance_id,
1107: -1);
1108: ELSE
1109: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1110: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_WO_OPERATION_REL',
1111: MSC_CL_COLLECTION.v_instance_id,
1112: null,
1113: v_sub_str);
1114: END IF;

Line 1123: lv_tbl:= 'MSC_WO_OPERATION_REL';

1119: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN
1120: lv_tbl:= 'WO_OPERATION_REL_'||MSC_CL_COLLECTION.v_instance_code;
1121: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
1122: ELSE
1123: lv_tbl:= 'MSC_WO_OPERATION_REL';
1124: lv_supplies_tbl:= 'MSC_SUPPLIES';
1125: END IF;
1126:
1127: lv_cursor_stmt:=

Line 1204: DELETE MSC_WO_OPERATION_REL

1200: MSC_CL_COLLECTION.v_is_legacy_refresh THEN
1201:
1202: FOR c_rec IN c_del LOOP
1203: BEGIN
1204: DELETE MSC_WO_OPERATION_REL
1205: WHERE SR_INSTANCE_ID= c_rec.sr_instance_id
1206: AND SUPPLY_ID = c_rec.supply_id
1207: AND FROM_OP_SEQ_NUM = c_rec.FROM_OP_SEQ_NUM
1208: AND nvl(FROM_OP_RES_SEQ_NUM,-1) = nvl(c_rec.FROM_OP_RES_SEQ_NUM,-1)

Line 1252: UPDATE MSC_WO_OPERATION_REL

1248: OPEN c_ref_cur FOR lv_cursor_stmt;
1249: LOOP
1250: fetch c_ref_cur into c_rec;
1251: exit when c_ref_cur%notfound;
1252: UPDATE MSC_WO_OPERATION_REL
1253: SET
1254: PRECEDENCE_CONSTRAINT = c_rec.PRECEDENCE_CONSTRAINT,
1255: FROM_OP_DESC = c_rec.FROM_OP_DESC,
1256: TO_OP_DESC = c_rec.TO_OP_DESC,

Line 1350: 'MSC_WO_OPERATION_REL',

1346:
1347: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1348: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
1349: lv_retcode,
1350: 'MSC_WO_OPERATION_REL',
1351: MSC_CL_COLLECTION.v_INSTANCE_CODE,
1352: MSC_UTIL.G_ERROR);
1353:
1354: IF lv_retcode = MSC_UTIL.G_ERROR THEN