APPS.MSC_CL_WIP_ODS_LOAD dependencies on MSC_JOB_OPERATION_NETWORKS

Line 1732: lv_tbl:= 'MSC_JOB_OPERATION_NETWORKS';

1728: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1729: lv_tbl:= 'JOB_OPERATION_NETWORKS_'||MSC_CL_COLLECTION.v_instance_code;
1730: lv_supplies_tbl:= 'SUPPLIES_'||MSC_CL_COLLECTION.v_instance_code;
1731: ELSE
1732: lv_tbl:= 'MSC_JOB_OPERATION_NETWORKS';
1733: lv_supplies_tbl:= 'MSC_SUPPLIES';
1734: END IF;
1735:
1736: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN

Line 1791: DELETE MSC_JOB_OPERATION_NETWORKS

1787:
1788:
1789: EXIT WHEN cgen%NOTFOUND;
1790:
1791: DELETE MSC_JOB_OPERATION_NETWORKS
1792: WHERE PLAN_ID= -1
1793: AND TRANSACTION_ID = lv_TRANSACTION_ID
1794: AND SR_INSTANCE_ID = lv_SR_INSTANCE_ID
1795: AND FROM_OP_SEQ_NUM = nvl(lv_FROM_OP_SEQ_NUM,FROM_OP_SEQ_NUM)

Line 1818: DELETE MSC_JOB_OPERATION_NETWORKS

1814:
1815:
1816: EXIT WHEN cgen%NOTFOUND;
1817:
1818: DELETE MSC_JOB_OPERATION_NETWORKS
1819: WHERE PLAN_ID= -1
1820: AND TRANSACTION_ID = lv_TRANSACTION_ID
1821: AND SR_INSTANCE_ID = lv_SR_INSTANCE_ID
1822: AND TO_TRANSACTION_ID = lv_TO_TRANSACTION_ID ;

Line 1985: UPDATE MSC_JOB_OPERATION_NETWORKS

1981: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
1982: /* opm is full collection. eam when there is change in
1983: relationship, it is deleter then insert */
1984:
1985: UPDATE MSC_JOB_OPERATION_NETWORKS
1986: SET
1987: FROM_OP_SEQ_ID= lv_FROM_OP_SEQ_ID,
1988: TO_OP_SEQ_ID= lv_TO_OP_SEQ_ID,
1989: RECOMMENDED= lv_RECOMMENDED,

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

2039:
2040: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2041: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2042: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_NWK');
2043: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATION_NETWORKS');
2044: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2045:
2046: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2047: RAISE;

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

2052:
2053: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2054: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2055: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_JOB_OP_NWK');
2056: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_JOB_OPERATION_NETWORKS');
2057: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2058:
2059: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2060: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

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

2068:
2069: END;
2070:
2071: END LOOP;
2072: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Total MSC_JOB_OPERATION_NETWORKS = '|| total_count);
2073: END IF;
2074:
2075: CLOSE cgen;
2076:

Line 2086: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_JOB_OPERATION_NETWORKS'

2082: lv_tbl:= 'JOB_OPERATION_NETWORKS_'||MSC_CL_COLLECTION.v_instance_code;
2083:
2084: lv_sql_stmt:=
2085: 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_tbl
2086: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_JOB_OPERATION_NETWORKS'
2087: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
2088: ||' AND plan_id = -1 '
2089: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
2090:

Line 2108: 'MSC_JOB_OPERATION_NETWORKS',

2104:
2105: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
2106: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
2107: lv_retcode,
2108: 'MSC_JOB_OPERATION_NETWORKS',
2109: MSC_CL_COLLECTION.v_instance_code,
2110: MSC_UTIL.G_WARNING
2111: );
2112: