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_RESOURCE_AVAILABILITY dependencies on MSC_NET_RES_INST_AVAIL

Line 1803: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', MSC_CL_COLLECTION.v_instance_id, -1);

1799: IF MSC_CL_COLLECTION.v_instance_type = MSC_UTIL.G_INS_DISCRETE OR MSC_CL_COLLECTION.v_instance_type = MSC_UTIL.G_INS_OTHER THEN
1800: -- log_debug('before delete of MSC_NET_RESOURCE_AVAIL ');
1801: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RESOURCE_AVAIL', MSC_CL_COLLECTION.v_instance_id, -1);
1802: COMMIT;
1803: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', MSC_CL_COLLECTION.v_instance_id, -1);
1804: COMMIT;
1805:
1806: /* call the function to calc. resource avail */
1807: lv_ret_res_ava:=CALC_RESOURCE_AVAILABILITY(lv_start_date-1,MSC_UTIL.G_ALL_ORGANIZATIONS,TRUE);

Line 1825: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', MSC_CL_COLLECTION.v_instance_id, -1,lv_where_clause);

1821: ELSIF MSC_CL_COLLECTION.v_instance_type = MSC_UTIL.G_INS_MIXED THEN
1822: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'debug-07');
1823: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RESOURCE_AVAIL', MSC_CL_COLLECTION.v_instance_id, -1,lv_where_clause);
1824: COMMIT;
1825: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', MSC_CL_COLLECTION.v_instance_id, -1,lv_where_clause);
1826: COMMIT;
1827:
1828:
1829: lv_ret_res_ava:=CALC_RESOURCE_AVAILABILITY(lv_start_date-1,MSC_UTIL.G_ALL_ORGANIZATIONS,TRUE);

Line 2020: MSC_NET_RES_INST_AVAILABILITY.POPULATE_ORG_RES_INSTANCES

2016: -- populate resource instance availability
2017: -----------------------------------------------------
2018: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'CALLING POPULATE_ORG_RES_INSTANCES');
2019:
2020: MSC_NET_RES_INST_AVAILABILITY.POPULATE_ORG_RES_INSTANCES
2021: ( lv_ret_code,
2022: lv_refresh_flag,
2023: MSC_CL_COLLECTION.v_last_collection_id,
2024: c_rec.organization_id,

Line 2123: MSC_NET_RES_INST_AVAILABILITY.POPULATE_ORG_RES_INSTANCES

2119: -- populate resource instance availability
2120: -----------------------------------------------------
2121: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'CALLING POPULATE_ORG_RES_INSTANCES');
2122:
2123: MSC_NET_RES_INST_AVAILABILITY.POPULATE_ORG_RES_INSTANCES
2124: ( lv_ret_code,
2125: lv_refresh_flag,
2126: MSC_CL_COLLECTION.v_last_collection_id,
2127: c_rec.organization_id,

Line 2203: --MSC_NET_RES_INST_AVAIL

2199: --==================================================================
2200:
2201: --=======================================================================
2202: --The following procedure also include the DS change for the
2203: --MSC_NET_RES_INST_AVAIL
2204: --=======================================================================
2205: PROCEDURE LOAD_NET_RESOURCE_AVAIL IS
2206:
2207: -- OPM

Line 2278: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', v_instance_id, -1);

2274: /*IF (v_is_complete_refresh OR (v_is_partial_refresh AND MSC_CL_COLLECTION.v_coll_prec.resource_nra_flag = MSC_CL_COLLECTION.SYS_YES)) THEN
2275: -- We want to delete all NRA related data and get new stuff.
2276:
2277: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RESOURCE_AVAIL', v_instance_id, -1);
2278: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', v_instance_id, -1);
2279:
2280: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_CL_COLLECTION.G_ALL_ORGANIZATIONS THEN
2281: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'debug-00');
2282: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RESOURCE_AVAIL', v_instance_id, -1);

Line 2283: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', v_instance_id, -1);

2279:
2280: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_CL_COLLECTION.G_ALL_ORGANIZATIONS THEN
2281: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'debug-00');
2282: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RESOURCE_AVAIL', v_instance_id, -1);
2283: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', v_instance_id, -1);
2284: ELSE
2285: v_sub_str :=' AND ORGANIZATION_ID '||v_in_org_str;
2286: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'debug-01');
2287: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RESOURCE_AVAIL', v_instance_id, -1,v_sub_str);

Line 2288: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', v_instance_id, -1,v_sub_str);

2284: ELSE
2285: v_sub_str :=' AND ORGANIZATION_ID '||v_in_org_str;
2286: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'debug-01');
2287: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RESOURCE_AVAIL', v_instance_id, -1,v_sub_str);
2288: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', v_instance_id, -1,v_sub_str);
2289: END IF;
2290:
2291: END IF;*/
2292:

Line 2484: -- here is the change for msc_net_res_inst_avail (DS change)

2480: END IF; /* If lv_res_avail:=MSC_CL_COLLECTION.SYS_NO */
2481: END LOOP;
2482:
2483: ------------------------------------------------------------------------
2484: -- here is the change for msc_net_res_inst_avail (DS change)
2485: ------------------------------------------------------------------------
2486: FOR c_rec1 IN c_org_list LOOP
2487: BEGIN
2488:

Line 2494: ' INSERT into MSC_net_res_inst_avail '

2490:
2491: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Loading res instance avail for OPM orgs : ' || c_rec1.organization_id);
2492:
2493: lv_sql_stmt:=
2494: ' INSERT into MSC_net_res_inst_avail '
2495: ||' ( inst_transaction_id,'
2496: ||' plan_id,'
2497: ||' sr_instance_id,'
2498: ||' organization_id,'

Line 2519: ||' msc_net_res_inst_avail_s.NEXTVAL,'

2515: ||' creation_date,'
2516: ||' created_by,'
2517: ||' refresh_number)'
2518: ||' SELECT'
2519: ||' msc_net_res_inst_avail_s.NEXTVAL,'
2520: ||' -1,'
2521: ||' msnria.sr_instance_id,'
2522: ||' msnria.organization_id,'
2523: ||' msnria.department_id,'

Line 2580: INSERT into MSC_net_res_inst_avail(

2576: FOR c_rec_resinst IN c_res_inst(c_rec1.organization_id) LOOP
2577:
2578: BEGIN
2579:
2580: INSERT into MSC_net_res_inst_avail(
2581: inst_transaction_id,
2582: plan_id,
2583: sr_instance_id,
2584: organization_id,

Line 2605: msc_net_res_inst_avail_s.NEXTVAL,

2601: creation_date,
2602: created_by,
2603: refresh_number)
2604: VALUES(
2605: msc_net_res_inst_avail_s.NEXTVAL,
2606: -1,
2607: c_rec_resinst.sr_instance_id,
2608: c_rec_resinst.organization_id,
2609: c_rec_resinst.department_id,

Line 2644: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_NET_RES_INST_AVAIL');

2640:
2641: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2642: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2643: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CALENDAR_DATE');
2644: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_NET_RES_INST_AVAIL');
2645: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2646:
2647: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2648: RAISE;

Line 2657: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_NET_RES_INST_AVAIL');

2653:
2654: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2655: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2656: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CALENDAR_DATE');
2657: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_NET_RES_INST_AVAIL');
2658: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2659:
2660: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2661: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');