APPS.MSC_CL_WIP_ODS_LOAD dependencies on MSC_JOB_OPERATION_NETWORKS

Line 1707: lv_tbl:= 'MSC_JOB_OPERATION_NETWORKS';

1703: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1704: lv_tbl:= 'JOB_OPERATION_NETWORKS_'||MSC_CL_COLLECTION.v_instance_code;
1705: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
1706: ELSE
1707: lv_tbl:= 'MSC_JOB_OPERATION_NETWORKS';
1708: lv_supplies_tbl:= 'MSC_SUPPLIES';
1709: END IF;
1710:
1711: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN

Line 1766: DELETE MSC_JOB_OPERATION_NETWORKS

1762:
1763:
1764: EXIT WHEN cgen%NOTFOUND;
1765:
1766: DELETE MSC_JOB_OPERATION_NETWORKS
1767: WHERE PLAN_ID= -1
1768: AND TRANSACTION_ID = lv_TRANSACTION_ID
1769: AND SR_INSTANCE_ID = lv_SR_INSTANCE_ID
1770: AND FROM_OP_SEQ_NUM = nvl(lv_FROM_OP_SEQ_NUM,FROM_OP_SEQ_NUM)

Line 1793: DELETE MSC_JOB_OPERATION_NETWORKS

1789:
1790:
1791: EXIT WHEN cgen%NOTFOUND;
1792:
1793: DELETE MSC_JOB_OPERATION_NETWORKS
1794: WHERE PLAN_ID= -1
1795: AND TRANSACTION_ID = lv_TRANSACTION_ID
1796: AND SR_INSTANCE_ID = lv_SR_INSTANCE_ID
1797: AND TO_TRANSACTION_ID = lv_TO_TRANSACTION_ID ;

Line 1960: UPDATE MSC_JOB_OPERATION_NETWORKS

1956: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
1957: /* opm is full collection. eam when there is change in
1958: relationship, it is deleter then insert */
1959:
1960: UPDATE MSC_JOB_OPERATION_NETWORKS
1961: SET
1962: FROM_OP_SEQ_ID= lv_FROM_OP_SEQ_ID,
1963: TO_OP_SEQ_ID= lv_TO_OP_SEQ_ID,
1964: RECOMMENDED= lv_RECOMMENDED,

Line 2018: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATION_NETWORKS');

2014:
2015: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2016: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2017: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_NWK');
2018: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATION_NETWORKS');
2019: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2020:
2021: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2022: RAISE;

Line 2031: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATION_NETWORKS');

2027:
2028: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2029: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2030: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_NWK');
2031: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATION_NETWORKS');
2032: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2033:
2034: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2035: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

Line 2047: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Total MSC_JOB_OPERATION_NETWORKS = '|| total_count);

2043:
2044: END;
2045:
2046: END LOOP;
2047: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Total MSC_JOB_OPERATION_NETWORKS = '|| total_count);
2048: END IF;
2049:
2050: CLOSE cgen;
2051:

Line 2061: ||' SELECT * from MSC_JOB_OPERATION_NETWORKS'

2057: lv_tbl:= 'JOB_OPERATION_NETWORKS_'||MSC_CL_COLLECTION.v_instance_code;
2058:
2059: lv_sql_stmt:=
2060: 'INSERT INTO '||lv_tbl
2061: ||' SELECT * from MSC_JOB_OPERATION_NETWORKS'
2062: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
2063: ||' AND plan_id = -1 '
2064: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
2065:

Line 2083: 'MSC_JOB_OPERATION_NETWORKS',

2079:
2080: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
2081: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
2082: lv_retcode,
2083: 'MSC_JOB_OPERATION_NETWORKS',
2084: MSC_CL_COLLECTION.v_instance_code,
2085: MSC_UTIL.G_WARNING
2086: );
2087: