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 1984: lv_tbl:= 'MSC_OPERATION_RESOURCES';

1980:
1981: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1982: lv_tbl:= 'OPERATION_RESOURCES_'||MSC_CL_COLLECTION.v_instance_code;
1983: ELSE
1984: lv_tbl:= 'MSC_OPERATION_RESOURCES';
1985: END IF;
1986:
1987: IF (MSC_CL_COLLECTION.v_is_complete_refresh or MSC_CL_COLLECTION.v_is_partial_refresh) THEN
1988:

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

1986:
1987: IF (MSC_CL_COLLECTION.v_is_complete_refresh or MSC_CL_COLLECTION.v_is_partial_refresh) THEN
1988:
1989: -- We want to delete all BOM related data and get new stuff.
1990: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);
1991:
1992: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN
1993: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1994: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);

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

1990: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);
1991:
1992: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_NO THEN
1993: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1994: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);
1995: ELSE
1996: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1997: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
1998: END IF;

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

1993: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1994: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);
1995: ELSE
1996: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1997: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
1998: END IF;
1999: END IF;
2000:
2001: BEGIN

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

2070: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2071:
2072: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2073: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_RESOURCES');
2074: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCES');
2075: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2076:
2077: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2078: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_SEQ_NUM');

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

2092:
2093: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2094: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2095: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_RESOURCES');
2096: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCES');
2097: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2098:
2099: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2100: RAISE;

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

2102: ELSE
2103: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2104: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2105: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_RESOURCES');
2106: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCES');
2107: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2108:
2109: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2110:

Line 2184: lv_sql_stmt1 := ' UPDATE MSC_OPERATION_RESOURCES '

2180: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
2181: FOR c_rec IN c6_d LOOP
2182: ---5470477
2183: lv_delete_flag := FALSE;
2184: lv_sql_stmt1 := ' UPDATE MSC_OPERATION_RESOURCES '
2185: ||' SET RESOURCE_USAGE= 0, '
2186: ||' REFRESH_NUMBER= :v_last_collection_id, '
2187: ||' LAST_UPDATE_DATE= :v_current_date, '
2188: ||' LAST_UPDATED_BY= :v_current_user '

Line 2234: UPDATE MSC_OPERATION_RESOURCES

2230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '------------------------------');
2231: END;
2232:
2233: /*
2234: UPDATE MSC_OPERATION_RESOURCES
2235: SET RESOURCE_USAGE= 0,
2236: REFRESH_NUMBER= v_last_collection_id,
2237: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
2238: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user

Line 2260: UPDATE MSC_OPERATION_RESOURCES

2256: BEGIN
2257:
2258: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
2259:
2260: UPDATE MSC_OPERATION_RESOURCES
2261: SET
2262: PRINCIPAL_FLAG= c_rec.PRINCIPAL_FLAG,
2263: BASIS_TYPE= c_rec.BASIS_TYPE,
2264: RESOURCE_USAGE= c_rec.RESOURCE_USAGE,

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

2295: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2296:
2297: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2298: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_RESOURCES');
2299: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCES');
2300: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2301:
2302: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2303: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_SEQ_NUM');

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

2354:
2355: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2356: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2357: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_RESOURCES');
2358: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCES');
2359: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2360:
2361: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2362: RAISE;

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

2366:
2367: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2368: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2369: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_RESOURCES');
2370: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_RESOURCES');
2371: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2372:
2373: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2374: FND_MESSAGE.SET_TOKEN('COLUMN', 'ROUTING_SEQUENCE_ID');

Line 2410: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_OPERATION_RESOURCES'

2406: lv_tbl:= 'OPERATION_RESOURCES_'||MSC_CL_COLLECTION.v_instance_code;
2407:
2408: lv_sql_stmt:=
2409: 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_tbl
2410: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_OPERATION_RESOURCES'
2411: ||' WHERE sr_instance_id = '||MSC_CL_COLLECTION.v_instance_id
2412: ||' AND plan_id = -1 '
2413: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
2414:

Line 2425: 'MSC_OPERATION_RESOURCES',

2421:
2422: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
2423: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
2424: lv_retcode,
2425: 'MSC_OPERATION_RESOURCES',
2426: MSC_CL_COLLECTION.v_instance_code,
2427: MSC_UTIL.G_WARNING
2428: );
2429: