eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_CL_ROUTING_ODS_LOAD dependencies on MSC_OPERATION_RESOURCES

Line 1978: lv_tbl:= 'MSC_OPERATION_RESOURCES';

1974:
1975: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1976: lv_tbl:= 'OPERATION_RESOURCES_'||MSC_CL_COLLECTION.v_instance_code;
1977: ELSE
1978: lv_tbl:= 'MSC_OPERATION_RESOURCES';
1979: END IF;
1980:
1981: IF (MSC_CL_COLLECTION.v_is_complete_refresh or MSC_CL_COLLECTION.v_is_partial_refresh) THEN
1982:

Line 1984: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);

1980:
1981: IF (MSC_CL_COLLECTION.v_is_complete_refresh or MSC_CL_COLLECTION.v_is_partial_refresh) THEN
1982:
1983: -- We want to delete all BOM related data and get new stuff.
1984: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);
1985:
1986: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN
1987: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1988: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);

Line 1988: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);

1984: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);
1985:
1986: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN
1987: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1988: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);
1989: ELSE
1990: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1991: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
1992: END IF;

Line 1991: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

1987: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1988: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);
1989: ELSE
1990: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1991: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
1992: END IF;
1993: END IF;
1994:
1995: BEGIN

Line 2068: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCES');

2064: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2065:
2066: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2067: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_RESOURCES');
2068: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCES');
2069: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2070:
2071: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2072: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_SEQ_NUM');

Line 2090: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCES');

2086:
2087: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2088: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2089: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_RESOURCES');
2090: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCES');
2091: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2092:
2093: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2094: RAISE;

Line 2100: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCES');

2096: ELSE
2097: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2098: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2099: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_RESOURCES');
2100: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCES');
2101: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2102:
2103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2104:

Line 2178: lv_sql_stmt1 := ' UPDATE MSC_OPERATION_RESOURCES '

2174: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
2175: FOR c_rec IN c6_d LOOP
2176: ---5470477
2177: lv_delete_flag := FALSE;
2178: lv_sql_stmt1 := ' UPDATE MSC_OPERATION_RESOURCES '
2179: ||' SET RESOURCE_USAGE= 0, '
2180: ||' REFRESH_NUMBER= :v_last_collection_id, '
2181: ||' LAST_UPDATE_DATE= :v_current_date, '
2182: ||' LAST_UPDATED_BY= :v_current_user '

Line 2228: UPDATE MSC_OPERATION_RESOURCES

2224: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '------------------------------');
2225: END;
2226:
2227: /*
2228: UPDATE MSC_OPERATION_RESOURCES
2229: SET RESOURCE_USAGE= 0,
2230: REFRESH_NUMBER= v_last_collection_id,
2231: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
2232: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user

Line 2254: UPDATE MSC_OPERATION_RESOURCES

2250: BEGIN
2251:
2252: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
2253:
2254: UPDATE MSC_OPERATION_RESOURCES
2255: SET
2256: PRINCIPAL_FLAG= c_rec.PRINCIPAL_FLAG,
2257: BASIS_TYPE= c_rec.BASIS_TYPE,
2258: RESOURCE_USAGE= c_rec.RESOURCE_USAGE,

Line 2294: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCES');

2290: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2291:
2292: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2293: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_RESOURCES');
2294: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCES');
2295: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2296:
2297: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2298: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_SEQ_NUM');

Line 2353: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCES');

2349:
2350: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2351: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2352: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_RESOURCES');
2353: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCES');
2354: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2355:
2356: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2357: RAISE;

Line 2365: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCES');

2361:
2362: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2363: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2364: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_RESOURCES');
2365: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCES');
2366: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2367:
2368: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2369: FND_MESSAGE.SET_TOKEN('COLUMN', 'ROUTING_SEQUENCE_ID');

Line 2405: ||' SELECT * from MSC_OPERATION_RESOURCES'

2401: lv_tbl:= 'OPERATION_RESOURCES_'||MSC_CL_COLLECTION.v_instance_code;
2402:
2403: lv_sql_stmt:=
2404: 'INSERT INTO '||lv_tbl
2405: ||' SELECT * from MSC_OPERATION_RESOURCES'
2406: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
2407: ||' AND plan_id = -1 '
2408: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
2409:

Line 2420: 'MSC_OPERATION_RESOURCES',

2416:
2417: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
2418: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
2419: lv_retcode,
2420: 'MSC_OPERATION_RESOURCES',
2421: MSC_CL_COLLECTION.v_instance_code,
2422: MSC_UTIL.G_WARNING
2423: );
2424: