APPS.MSC_CL_WIP_ODS_LOAD dependencies on MSC_JOB_REQUIREMENT_OPS

Line 1264: lv_tbl:= 'MSC_JOB_REQUIREMENT_OPS';

1260: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1261: lv_tbl:= 'JOB_REQUIREMENT_OPS_'||MSC_CL_COLLECTION.v_instance_code;
1262: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
1263: ELSE
1264: lv_tbl:= 'MSC_JOB_REQUIREMENT_OPS';
1265: lv_supplies_tbl:= 'MSC_SUPPLIES';
1266: END IF;
1267:
1268: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN

Line 1314: DELETE MSC_JOB_REQUIREMENT_OPS

1310: lv_SR_INSTANCE_ID;
1311:
1312: EXIT WHEN cgen%NOTFOUND;
1313:
1314: DELETE MSC_JOB_REQUIREMENT_OPS
1315: WHERE PLAN_ID= -1
1316: AND TRANSACTION_ID = lv_TRANSACTION_ID
1317: AND SR_INSTANCE_ID = lv_SR_INSTANCE_ID
1318: AND OPERATION_SEQ_NUM = nvl(lv_OPERATION_SEQ_NUM,OPERATION_SEQ_NUM)

Line 1487: UPDATE MSC_JOB_REQUIREMENT_OPS

1483: BEGIN
1484:
1485: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
1486:
1487: UPDATE MSC_JOB_REQUIREMENT_OPS
1488: SET
1489: RECOMMENDED = lv_RECOMMENDED,
1490: RECO_DATE_REQUIRED = lv_RECO_DATE_REQUIRED,
1491: COMPONENT_PRIORITY = lv_COMPONENT_PRIORITY,

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

1561:
1562: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1563: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1564: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_REQ_OP');
1565: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_REQUIREMENT_OPS');
1566: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1567:
1568: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1569: RAISE;

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

1574:
1575: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1576: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1577: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_REQ_OP');
1578: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_REQUIREMENT_OPS');
1579: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1580:
1581: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1582: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

1591: END;
1592:
1593: END LOOP;
1594:
1595: -- log_debug('Total MSC_JOB_REQUIREMENT_OPS = '|| total_count);
1596: END IF;
1597:
1598: CLOSE cgen;
1599:

Line 1610: ||' SELECT * from MSC_JOB_REQUIREMENT_OPS'

1606: lv_tbl:= 'JOB_REQUIREMENT_OPS_'||MSC_CL_COLLECTION.v_instance_code;
1607:
1608: lv_sql_stmt:=
1609: 'INSERT INTO '||lv_tbl
1610: ||' SELECT * from MSC_JOB_REQUIREMENT_OPS'
1611: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
1612: ||' AND plan_id = -1 '
1613: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
1614:

Line 1632: 'MSC_JOB_REQUIREMENT_OPS',

1628:
1629: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1630: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
1631: lv_retcode,
1632: 'MSC_JOB_REQUIREMENT_OPS',
1633: MSC_CL_COLLECTION.v_instance_code,
1634: MSC_UTIL.G_WARNING
1635: );
1636: