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 1815: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', MSC_CL_COLLECTION.v_instance_id, -1);

1811: 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
1812: -- log_debug('before delete of MSC_NET_RESOURCE_AVAIL ');
1813: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RESOURCE_AVAIL', MSC_CL_COLLECTION.v_instance_id, -1);
1814: COMMIT;
1815: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', MSC_CL_COLLECTION.v_instance_id, -1);
1816: COMMIT;
1817:
1818: /* call the function to calc. resource avail */
1819: lv_ret_res_ava:=CALC_RESOURCE_AVAILABILITY(lv_start_date-1,MSC_UTIL.G_ALL_ORGANIZATIONS,TRUE);

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

1833: ELSIF MSC_CL_COLLECTION.v_instance_type = MSC_UTIL.G_INS_MIXED THEN
1834: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'debug-07');
1835: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RESOURCE_AVAIL', MSC_CL_COLLECTION.v_instance_id, -1,lv_where_clause);
1836: COMMIT;
1837: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', MSC_CL_COLLECTION.v_instance_id, -1,lv_where_clause);
1838: COMMIT;
1839:
1840:
1841: lv_ret_res_ava:=CALC_RESOURCE_AVAILABILITY(lv_start_date-1,MSC_UTIL.G_ALL_ORGANIZATIONS,TRUE);

Line 2032: MSC_NET_RES_INST_AVAILABILITY.POPULATE_ORG_RES_INSTANCES

2028: -- populate resource instance availability
2029: -----------------------------------------------------
2030: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'CALLING POPULATE_ORG_RES_INSTANCES');
2031:
2032: MSC_NET_RES_INST_AVAILABILITY.POPULATE_ORG_RES_INSTANCES
2033: ( lv_ret_code,
2034: lv_refresh_flag,
2035: MSC_CL_COLLECTION.v_last_collection_id,
2036: c_rec.organization_id,

Line 2135: MSC_NET_RES_INST_AVAILABILITY.POPULATE_ORG_RES_INSTANCES

2131: -- populate resource instance availability
2132: -----------------------------------------------------
2133: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'CALLING POPULATE_ORG_RES_INSTANCES');
2134:
2135: MSC_NET_RES_INST_AVAILABILITY.POPULATE_ORG_RES_INSTANCES
2136: ( lv_ret_code,
2137: lv_refresh_flag,
2138: MSC_CL_COLLECTION.v_last_collection_id,
2139: c_rec.organization_id,

Line 2215: --MSC_NET_RES_INST_AVAIL

2211: --==================================================================
2212:
2213: --=======================================================================
2214: --The following procedure also include the DS change for the
2215: --MSC_NET_RES_INST_AVAIL
2216: --=======================================================================
2217: PROCEDURE LOAD_NET_RESOURCE_AVAIL IS
2218:
2219: -- OPM

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

2286: /*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
2287: -- We want to delete all NRA related data and get new stuff.
2288:
2289: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RESOURCE_AVAIL', v_instance_id, -1);
2290: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', v_instance_id, -1);
2291:
2292: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_CL_COLLECTION.G_ALL_ORGANIZATIONS THEN
2293: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'debug-00');
2294: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RESOURCE_AVAIL', v_instance_id, -1);

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

2291:
2292: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_CL_COLLECTION.G_ALL_ORGANIZATIONS THEN
2293: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'debug-00');
2294: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RESOURCE_AVAIL', v_instance_id, -1);
2295: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', v_instance_id, -1);
2296: ELSE
2297: v_sub_str :=' AND ORGANIZATION_ID '||v_in_org_str;
2298: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'debug-01');
2299: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RESOURCE_AVAIL', v_instance_id, -1,v_sub_str);

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

2296: ELSE
2297: v_sub_str :=' AND ORGANIZATION_ID '||v_in_org_str;
2298: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'debug-01');
2299: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RESOURCE_AVAIL', v_instance_id, -1,v_sub_str);
2300: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_NET_RES_INST_AVAIL', v_instance_id, -1,v_sub_str);
2301: END IF;
2302:
2303: END IF;*/
2304:

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

2492: END IF; /* If lv_res_avail:=MSC_CL_COLLECTION.SYS_NO */
2493: END LOOP;
2494:
2495: ------------------------------------------------------------------------
2496: -- here is the change for msc_net_res_inst_avail (DS change)
2497: ------------------------------------------------------------------------
2498: FOR c_rec1 IN c_org_list LOOP
2499: BEGIN
2500:

Line 2506: ' INSERT into MSC_net_res_inst_avail '

2502:
2503: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Loading res instance avail for OPM orgs : ' || c_rec1.organization_id);
2504:
2505: lv_sql_stmt:=
2506: ' INSERT into MSC_net_res_inst_avail '
2507: ||' ( inst_transaction_id,'
2508: ||' plan_id,'
2509: ||' sr_instance_id,'
2510: ||' organization_id,'

Line 2531: ||' msc_net_res_inst_avail_s.NEXTVAL,'

2527: ||' creation_date,'
2528: ||' created_by,'
2529: ||' refresh_number)'
2530: ||' SELECT'
2531: ||' msc_net_res_inst_avail_s.NEXTVAL,'
2532: ||' -1,'
2533: ||' msnria.sr_instance_id,'
2534: ||' msnria.organization_id,'
2535: ||' msnria.department_id,'

Line 2592: INSERT into MSC_net_res_inst_avail(

2588: FOR c_rec_resinst IN c_res_inst(c_rec1.organization_id) LOOP
2589:
2590: BEGIN
2591:
2592: INSERT into MSC_net_res_inst_avail(
2593: inst_transaction_id,
2594: plan_id,
2595: sr_instance_id,
2596: organization_id,

Line 2617: msc_net_res_inst_avail_s.NEXTVAL,

2613: creation_date,
2614: created_by,
2615: refresh_number)
2616: VALUES(
2617: msc_net_res_inst_avail_s.NEXTVAL,
2618: -1,
2619: c_rec_resinst.sr_instance_id,
2620: c_rec_resinst.organization_id,
2621: c_rec_resinst.department_id,

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

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

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

2665:
2666: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
2667: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
2668: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CALENDAR_DATE');
2669: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_NET_RES_INST_AVAIL');
2670: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2671:
2672: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
2673: FND_MESSAGE.SET_TOKEN('COLUMN', 'RESOURCE_ID');