APPS.MSC_CL_WIP_ODS_LOAD dependencies on MSC_JOB_REQUIREMENT_OPS

Line 1289: lv_tbl:= 'MSC_JOB_REQUIREMENT_OPS';

1285: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1286: lv_tbl:= 'JOB_REQUIREMENT_OPS_'||MSC_CL_COLLECTION.v_instance_code;
1287: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
1288: ELSE
1289: lv_tbl:= 'MSC_JOB_REQUIREMENT_OPS';
1290: lv_supplies_tbl:= 'MSC_SUPPLIES';
1291: END IF;
1292:
1293: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN

Line 1339: DELETE MSC_JOB_REQUIREMENT_OPS

1335: lv_SR_INSTANCE_ID;
1336:
1337: EXIT WHEN cgen%NOTFOUND;
1338:
1339: DELETE MSC_JOB_REQUIREMENT_OPS
1340: WHERE PLAN_ID= -1
1341: AND TRANSACTION_ID = lv_TRANSACTION_ID
1342: AND SR_INSTANCE_ID = lv_SR_INSTANCE_ID
1343: AND OPERATION_SEQ_NUM = nvl(lv_OPERATION_SEQ_NUM,OPERATION_SEQ_NUM)

Line 1512: UPDATE MSC_JOB_REQUIREMENT_OPS

1508: BEGIN
1509:
1510: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
1511:
1512: UPDATE MSC_JOB_REQUIREMENT_OPS
1513: SET
1514: RECOMMENDED = lv_RECOMMENDED,
1515: RECO_DATE_REQUIRED = lv_RECO_DATE_REQUIRED,
1516: COMPONENT_PRIORITY = lv_COMPONENT_PRIORITY,

Line 1590: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_REQUIREMENT_OPS');

1586:
1587: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1588: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1589: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_REQ_OP');
1590: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_REQUIREMENT_OPS');
1591: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1592:
1593: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1594: RAISE;

Line 1603: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_REQUIREMENT_OPS');

1599:
1600: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1601: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1602: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_REQ_OP');
1603: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_REQUIREMENT_OPS');
1604: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1605:
1606: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1607: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

Line 1620: -- log_debug('Total MSC_JOB_REQUIREMENT_OPS = '|| total_count);

1616: END;
1617:
1618: END LOOP;
1619:
1620: -- log_debug('Total MSC_JOB_REQUIREMENT_OPS = '|| total_count);
1621: END IF;
1622:
1623: CLOSE cgen;
1624:

Line 1635: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_JOB_REQUIREMENT_OPS'

1631: lv_tbl:= 'JOB_REQUIREMENT_OPS_'||MSC_CL_COLLECTION.v_instance_code;
1632:
1633: lv_sql_stmt:=
1634: 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_tbl
1635: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_JOB_REQUIREMENT_OPS'
1636: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
1637: ||' AND plan_id = -1 '
1638: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
1639:

Line 1657: 'MSC_JOB_REQUIREMENT_OPS',

1653:
1654: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1655: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
1656: lv_retcode,
1657: 'MSC_JOB_REQUIREMENT_OPS',
1658: MSC_CL_COLLECTION.v_instance_code,
1659: MSC_UTIL.G_WARNING
1660: );
1661: