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.MRP_CL_REFRESH_SNAPSHOT dependencies on FND_REQUEST

Line 173: lv_request_id_drop := FND_REQUEST.SUBMIT_REQUEST(

169: lv_srp_enabled_flag VARCHAR2(1);
170:
171: BEGIN
172: /* Submit the request to look for changed snapshots and drop these snapshots */
173: lv_request_id_drop := FND_REQUEST.SUBMIT_REQUEST(
174: 'MSC',
175: 'MSCDROPS',
176: NULL,
177: NULL,

Line 206: lv_request_id_wsm := FND_REQUEST.SUBMIT_REQUEST(

202:
203: /* Only if the Drop Snapshot Process is successfull then call the create snapshots */
204:
205: if lv_success THEN --drop snapshots success
206: lv_request_id_wsm := FND_REQUEST.SUBMIT_REQUEST(
207: 'MSC',
208: 'MSCWSMSN',
209: NULL,
210: NULL,

Line 215: lv_request_id_bom := FND_REQUEST.SUBMIT_REQUEST(

211: FALSE); -- sub request
212: commit;
213: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Request : '||lv_request_id_wsm||' :Creates WSM Snapshot Logs and Snapshots');
214:
215: lv_request_id_bom := FND_REQUEST.SUBMIT_REQUEST(
216: 'MSC',
217: 'MSCBOMSN',
218: NULL,
219: NULL,

Line 224: lv_request_id_inv := FND_REQUEST.SUBMIT_REQUEST(

220: FALSE); -- sub request
221: commit;
222: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Request : '||lv_request_id_bom||' :Creates BOM Snapshot Logs and Snapshots');
223:
224: lv_request_id_inv := FND_REQUEST.SUBMIT_REQUEST(
225: 'MSC',
226: 'MSCINVSN',
227: NULL,
228: NULL,

Line 233: lv_request_id_inv := FND_REQUEST.SUBMIT_REQUEST(

229: FALSE); -- sub request
230: commit;
231:
232: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Request : '||lv_request_id_bom||' :Creates CSP Snapshot Logs and Snapshots');
233: lv_request_id_inv := FND_REQUEST.SUBMIT_REQUEST(
234: 'MSC',
235: 'MSCCSPSN',
236: NULL,
237: NULL,

Line 242: lv_request_id_mrp := FND_REQUEST.SUBMIT_REQUEST(

238: FALSE); -- sub request
239: commit;
240: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Request : '||lv_request_id_inv||' :Creates INV Snapshot Logs and Snapshots');
241:
242: lv_request_id_mrp := FND_REQUEST.SUBMIT_REQUEST(
243: 'MSC',
244: 'MSCMRPSN',
245: NULL,
246: NULL,

Line 251: lv_request_id_pox := FND_REQUEST.SUBMIT_REQUEST(

247: FALSE); -- sub request
248: commit;
249: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Request : '||lv_request_id_mrp||' :Creates MRP Snapshot Logs and Snapshots');
250:
251: lv_request_id_pox := FND_REQUEST.SUBMIT_REQUEST(
252: 'MSC',
253: 'MSCPOXSN',
254: NULL,
255: NULL,

Line 260: lv_request_id_ont := FND_REQUEST.SUBMIT_REQUEST(

256: FALSE); -- sub request
257: commit;
258: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Request : '||lv_request_id_pox||' :Creates PO Snapshot Logs and Snapshots');
259:
260: lv_request_id_ont := FND_REQUEST.SUBMIT_REQUEST(
261: 'MSC',
262: 'MSCONTSN',
263: NULL,
264: NULL,

Line 269: lv_request_id_wsh := FND_REQUEST.SUBMIT_REQUEST(

265: FALSE); -- sub request
266: commit;
267: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Request : '||lv_request_id_ont||' :Creates OE Snapshot Logs and Snapshots');
268:
269: lv_request_id_wsh := FND_REQUEST.SUBMIT_REQUEST(
270: 'MSC',
271: 'MSCWSHSN',
272: NULL,
273: NULL,

Line 280: lv_request_id_ahl := FND_REQUEST.SUBMIT_REQUEST(

276: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Request : '||lv_request_id_wsh||' :Creates WSH Snapshot Logs and Snapshots');
277:
278: IF MRP_CL_FUNCTION.CHECK_AHL_VER = 1 THEN
279:
280: lv_request_id_ahl := FND_REQUEST.SUBMIT_REQUEST(
281: 'MSC',
282: 'MSCAHLSN',
283: NULL,
284: NULL,

Line 290: lv_request_id_eam := FND_REQUEST.SUBMIT_REQUEST(

286: commit;
287: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Request : '||lv_request_id_ahl||' :Creates AHL Snapshot Logs and Snapshots');
288:
289: /* ds change: change start */
290: lv_request_id_eam := FND_REQUEST.SUBMIT_REQUEST(
291: 'MSC',
292: 'MSCEAMSN',
293: NULL,
294: NULL,

Line 315: lv_request_id_wip := FND_REQUEST.SUBMIT_REQUEST(

311:
312: wait_for_request(lv_request_id_mrp, 10, lv_out);
313: if lv_success THEN
314:
315: lv_request_id_wip := FND_REQUEST.SUBMIT_REQUEST(
316: 'MSC',
317: 'MSCWIPSN',
318: NULL,
319: NULL,

Line 370: lv_request_id_syn := FND_REQUEST.SUBMIT_REQUEST(

366: end if;
367: /* Only if the Snapshot creation Process is successfull then create trigs, views,synms */
368:
369: if lv_success THEN --create snapshots success
370: lv_request_id_syn := FND_REQUEST.SUBMIT_REQUEST(
371: 'MSC',
372: 'MSCSYNMS',
373: NULL,
374: NULL,

Line 385: lv_request_id_view := FND_REQUEST.SUBMIT_REQUEST(

381: if lv_out = 2 THEN lv_success := FALSE ; end if;
382: end if;
383:
384: IF lv_success THEN -- Only when Synonyms creation succcess
385: lv_request_id_view := FND_REQUEST.SUBMIT_REQUEST(
386: 'MSC',
387: 'MSCVIEWS',
388: NULL,
389: NULL,

Line 394: lv_request_id_trig := FND_REQUEST.SUBMIT_REQUEST(

390: FALSE); -- sub request
391: commit;
392: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Request : '||lv_request_id_view||' :Creates Views used by Collections Process');
393:
394: lv_request_id_trig := FND_REQUEST.SUBMIT_REQUEST(
395: 'MSC',
396: 'MSCTRIGS',
397: NULL,
398: NULL,

Line 623: result := FND_REQUEST.SET_MODE(TRUE);

619:
620: END IF;
621:
622: IF V_REMOTE_CALL THEN
623: result := FND_REQUEST.SET_MODE(TRUE);
624: v_request_id := FND_REQUEST.SUBMIT_REQUEST(
625: 'MRP',
626: 'MSRFWOR',
627: NULL,

Line 624: v_request_id := FND_REQUEST.SUBMIT_REQUEST(

620: END IF;
621:
622: IF V_REMOTE_CALL THEN
623: result := FND_REQUEST.SET_MODE(TRUE);
624: v_request_id := FND_REQUEST.SUBMIT_REQUEST(
625: 'MRP',
626: 'MSRFWOR',
627: NULL,
628: NULL,

Line 641: v_request_id := FND_REQUEST.SUBMIT_REQUEST(

637: pInstance_ID,
638: pInstance_Code,
639: pa2m_dblink);
640: ELSE
641: v_request_id := FND_REQUEST.SUBMIT_REQUEST(
642: 'MRP',
643: 'MSRFWOR',
644: NULL,
645: NULL,

Line 1662: v_request_id := FND_REQUEST.SUBMIT_REQUEST(

1658: lv_refresh_param := lv_refresh_param || '?';
1659: lv_num_of_snap := lv_num_of_snap + 1;
1660:
1661: lv_req_id.EXTEND(1);
1662: v_request_id := FND_REQUEST.SUBMIT_REQUEST(
1663: 'MSC',
1664: 'MSCCLRFS',
1665: NULL,
1666: NULL,

Line 2748: lv_request_id_views(indx) := FND_REQUEST.SUBMIT_REQUEST(

2744: indx number := 0;
2745: BEGIN
2746: -- setup
2747: indx := indx + 1;
2748: lv_request_id_views(indx) := FND_REQUEST.SUBMIT_REQUEST(
2749: 'MSC',
2750: 'MSCVWSTP',
2751: NULL,
2752: NULL,

Line 2759: lv_request_id_views(indx) := FND_REQUEST.SUBMIT_REQUEST(

2755: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Request : '||lv_request_id_views(indx)||' :Creates Setup Views used by Collections Process');
2756: --
2757: -- Item
2758: indx := indx + 1;
2759: lv_request_id_views(indx) := FND_REQUEST.SUBMIT_REQUEST(
2760: 'MSC',
2761: 'MSCVWITM',
2762: NULL,
2763: NULL,

Line 2770: lv_request_id_views(indx) := FND_REQUEST.SUBMIT_REQUEST(

2766: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Request : '||lv_request_id_views(indx)||' :Creates Item Views used by Collections Process');
2767: --
2768: -- BOM
2769: indx := indx + 1;
2770: lv_request_id_views(indx) := FND_REQUEST.SUBMIT_REQUEST(
2771: 'MSC',
2772: 'MSCVWBOM',
2773: NULL,
2774: NULL,

Line 2781: lv_request_id_views(indx) := FND_REQUEST.SUBMIT_REQUEST(

2777: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Request : '||lv_request_id_views(indx)||' :Creates BOM Views used by Collections Process');
2778: --
2779: -- Routing
2780: indx := indx + 1;
2781: lv_request_id_views(indx) := FND_REQUEST.SUBMIT_REQUEST(
2782: 'MSC',
2783: 'MSCVWRTG',
2784: NULL,
2785: NULL,

Line 2792: lv_request_id_views(indx) := FND_REQUEST.SUBMIT_REQUEST(

2788: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Request : '||lv_request_id_views(indx)||' :Creates Routing Views used by Collections Process');
2789: --
2790: -- WIP
2791: indx := indx + 1;
2792: lv_request_id_views(indx) := FND_REQUEST.SUBMIT_REQUEST(
2793: 'MSC',
2794: 'MSCVWWIP',
2795: NULL,
2796: NULL,

Line 2803: lv_request_id_views(indx) := FND_REQUEST.SUBMIT_REQUEST(

2799: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Request : '||lv_request_id_views(indx)||' :Creates WIP Views used by Collections Process');
2800: --
2801: -- Demand
2802: indx := indx + 1;
2803: lv_request_id_views(indx) := FND_REQUEST.SUBMIT_REQUEST(
2804: 'MSC',
2805: 'MSCVWDEM',
2806: NULL,
2807: NULL,

Line 2815: lv_request_id_views(indx) := FND_REQUEST.SUBMIT_REQUEST(

2811: --
2812:
2813: -- Supply
2814: indx := indx + 1;
2815: lv_request_id_views(indx) := FND_REQUEST.SUBMIT_REQUEST(
2816: 'MSC',
2817: 'MSCVWSUP',
2818: NULL,
2819: NULL,

Line 2826: lv_request_id_views(indx) := FND_REQUEST.SUBMIT_REQUEST(

2822: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Request : '||lv_request_id_views(indx)||' :Creates Supply Views used by Collections Process');
2823: --
2824: -- Other
2825: indx := indx + 1;
2826: lv_request_id_views(indx) := FND_REQUEST.SUBMIT_REQUEST(
2827: 'MSC',
2828: 'MSCVWOTH',
2829: NULL,
2830: NULL,

Line 2837: lv_request_id_views(indx) := FND_REQUEST.SUBMIT_REQUEST(

2833: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Request : '||lv_request_id_views(indx)||' :Creates Other Views used by Collections Process');
2834: --
2835: -- Repair Order
2836: indx := indx + 1;
2837: lv_request_id_views(indx) := FND_REQUEST.SUBMIT_REQUEST(
2838: 'MSC',
2839: 'MSCVWRPO',
2840: NULL,
2841: NULL,

Line 2877: lv_request_id_trigs(indx) := FND_REQUEST.SUBMIT_REQUEST(

2873: indx number := 0;
2874: BEGIN
2875: -- Item
2876: indx := indx + 1;
2877: lv_request_id_trigs(indx) := FND_REQUEST.SUBMIT_REQUEST(
2878: 'MSC',
2879: 'MSCTRITM',
2880: NULL,
2881: NULL,

Line 2888: lv_request_id_trigs(indx) := FND_REQUEST.SUBMIT_REQUEST(

2884: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Request : '||lv_request_id_trigs(indx)||' :Creates Item Triggers used by Collections Process');
2885: --
2886: -- BOM
2887: indx := indx + 1;
2888: lv_request_id_trigs(indx) := FND_REQUEST.SUBMIT_REQUEST(
2889: 'MSC',
2890: 'MSCTRBOM',
2891: NULL,
2892: NULL,

Line 2899: lv_request_id_trigs(indx) := FND_REQUEST.SUBMIT_REQUEST(

2895: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Request : '||lv_request_id_trigs(indx)||' :Creates BOM Triggers used by Collections Process');
2896: --
2897: -- Routing
2898: indx := indx + 1;
2899: lv_request_id_trigs(indx) := FND_REQUEST.SUBMIT_REQUEST(
2900: 'MSC',
2901: 'MSCTRRTG',
2902: NULL,
2903: NULL,

Line 2910: lv_request_id_trigs(indx) := FND_REQUEST.SUBMIT_REQUEST(

2906: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Request : '||lv_request_id_trigs(indx)||' :Creates Routing Triggers used by Collections Process');
2907: --
2908: -- WIP
2909: indx := indx + 1;
2910: lv_request_id_trigs(indx) := FND_REQUEST.SUBMIT_REQUEST(
2911: 'MSC',
2912: 'MSCTRWIP',
2913: NULL,
2914: NULL,

Line 2921: lv_request_id_trigs(indx) := FND_REQUEST.SUBMIT_REQUEST(

2917: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Request : '||lv_request_id_trigs(indx)||' :Creates WIP Triggers used by Collections Process');
2918: --
2919: -- Demand
2920: indx := indx + 1;
2921: lv_request_id_trigs(indx) := FND_REQUEST.SUBMIT_REQUEST(
2922: 'MSC',
2923: 'MSCTRDEM',
2924: NULL,
2925: NULL,

Line 2933: lv_request_id_trigs(indx) := FND_REQUEST.SUBMIT_REQUEST(

2929: --
2930:
2931: -- Supply
2932: indx := indx + 1;
2933: lv_request_id_trigs(indx) := FND_REQUEST.SUBMIT_REQUEST(
2934: 'MSC',
2935: 'MSCTRSUP',
2936: NULL,
2937: NULL,

Line 2944: lv_request_id_trigs(indx) := FND_REQUEST.SUBMIT_REQUEST(

2940: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Request : '||lv_request_id_trigs(indx)||' :Creates Supply Triggers used by Collections Process');
2941: --
2942: -- Other
2943: indx := indx + 1;
2944: lv_request_id_trigs(indx) := FND_REQUEST.SUBMIT_REQUEST(
2945: 'MSC',
2946: 'MSCTROTH',
2947: NULL,
2948: NULL,

Line 2955: lv_request_id_trigs(indx) := FND_REQUEST.SUBMIT_REQUEST(

2951: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Request : '||lv_request_id_trigs(indx)||' :Creates Other Triggers used by Collections Process');
2952: --
2953: -- Repair Order
2954: indx := indx + 1;
2955: lv_request_id_trigs(indx) := FND_REQUEST.SUBMIT_REQUEST(
2956: 'MSC',
2957: 'MSCTRRPO',
2958: NULL,
2959: NULL,