DBA Data[Home] [Help]

APPS.MRP_AP_REL_PLAN_PUB dependencies on FND_REQUEST

Line 2090: lv_result := FND_REQUEST.SET_MODE(TRUE);

2086: WHERE GROUP_ID= G_WIP_GROUP_ID
2087: AND ROWNUM=1;
2088:
2089: --set to trigger mode to bypass the 'SAVEPOINT' and 'ROLLBACK' command.
2090: lv_result := FND_REQUEST.SET_MODE(TRUE);
2091:
2092: IF WSMPVERS.get_osfm_release_version >= '110509' then
2093: o_request_id := FND_REQUEST.SUBMIT_REQUEST(
2094: 'WSM', -- application

Line 2093: o_request_id := FND_REQUEST.SUBMIT_REQUEST(

2089: --set to trigger mode to bypass the 'SAVEPOINT' and 'ROLLBACK' command.
2090: lv_result := FND_REQUEST.SET_MODE(TRUE);
2091:
2092: IF WSMPVERS.get_osfm_release_version >= '110509' then
2093: o_request_id := FND_REQUEST.SUBMIT_REQUEST(
2094: 'WSM', -- application
2095: 'WSMPLBJI', -- program
2096: NULL, -- description
2097: NULL, -- start_time

Line 2101: o_request_id := FND_REQUEST.SUBMIT_REQUEST(

2097: NULL, -- start_time
2098: FALSE, -- sub_request
2099: g_wip_group_id); -- group_id
2100: ELSE
2101: o_request_id := FND_REQUEST.SUBMIT_REQUEST(
2102: 'WSM', -- application
2103: 'WSMPLBJI', -- program
2104: NULL, -- description
2105: NULL, -- start_time

Line 2422: lv_result := FND_REQUEST.SET_MODE(TRUE);

2418:
2419: MODIFY_RESOURCE_REQUIREMENT;
2420:
2421: --set to trigger mode to bypass the 'SAVEPOINT' and 'ROLLBACK' command.
2422: lv_result := FND_REQUEST.SET_MODE(TRUE);
2423:
2424:
2425: o_request_id := FND_REQUEST.SUBMIT_REQUEST(
2426: 'WIP', -- application

Line 2425: o_request_id := FND_REQUEST.SUBMIT_REQUEST(

2421: --set to trigger mode to bypass the 'SAVEPOINT' and 'ROLLBACK' command.
2422: lv_result := FND_REQUEST.SET_MODE(TRUE);
2423:
2424:
2425: o_request_id := FND_REQUEST.SUBMIT_REQUEST(
2426: 'WIP', -- application
2427: 'WICMLP', -- program
2428: NULL, -- description
2429: NULL, -- start_time

Line 2452: lv_result := FND_REQUEST.SET_MODE(TRUE);

2448:
2449: SET_OPM_SCHEDULING_METHOD;
2450:
2451: -- set to trigger mode to bypass the 'SAVEPOINT' and 'ROLLBACK' command.
2452: lv_result := FND_REQUEST.SET_MODE(TRUE);
2453:
2454: o_request_id := FND_REQUEST.SUBMIT_REQUEST(
2455: 'GMP', -- application
2456: 'GMPAPSFD', -- program

Line 2454: o_request_id := FND_REQUEST.SUBMIT_REQUEST(

2450:
2451: -- set to trigger mode to bypass the 'SAVEPOINT' and 'ROLLBACK' command.
2452: lv_result := FND_REQUEST.SET_MODE(TRUE);
2453:
2454: o_request_id := FND_REQUEST.SUBMIT_REQUEST(
2455: 'GMP', -- application
2456: 'GMPAPSFD', -- program
2457: NULL, -- description
2458: NULL, -- start_time

Line 2485: lv_result := FND_REQUEST.SET_MODE(TRUE);

2481: EXECUTE IMMEDIATE lv_sqlstmt into lv_dummy USING lv_instance_id,G_WIP_GROUP_ID;
2482:
2483:
2484: -- set to trigger mode to bypass the 'SAVEPOINT' and 'ROLLBACK' command.
2485: lv_result := FND_REQUEST.SET_MODE(TRUE);
2486: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'dblink is '|| lv_dblink);
2487: o_request_id := FND_REQUEST.SUBMIT_REQUEST(
2488: 'MSC', -- application
2489: 'MRPPSRELB', -- program

Line 2487: o_request_id := FND_REQUEST.SUBMIT_REQUEST(

2483:
2484: -- set to trigger mode to bypass the 'SAVEPOINT' and 'ROLLBACK' command.
2485: lv_result := FND_REQUEST.SET_MODE(TRUE);
2486: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'dblink is '|| lv_dblink);
2487: o_request_id := FND_REQUEST.SUBMIT_REQUEST(
2488: 'MSC', -- application
2489: 'MRPPSRELB', -- program
2490: NULL, -- description
2491: NULL, -- start_time

Line 2552: lv_result := FND_REQUEST.SET_MODE(TRUE);

2548: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' lv_sqlstmt is '|| lv_sqlstmt);
2549:
2550: EXECUTE IMMEDIATE lv_sqlstmt into lv_dummy USING lv_instance_id,G_WIP_GROUP_ID;
2551: -- set to trigger mode to bypass the 'SAVEPOINT' and 'ROLLBACK' command.
2552: lv_result := FND_REQUEST.SET_MODE(TRUE);
2553:
2554: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'dblink is '|| lv_dblink);
2555:
2556: o_request_id_eam := FND_REQUEST.SUBMIT_REQUEST(

Line 2556: o_request_id_eam := FND_REQUEST.SUBMIT_REQUEST(

2552: lv_result := FND_REQUEST.SET_MODE(TRUE);
2553:
2554: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'dblink is '|| lv_dblink);
2555:
2556: o_request_id_eam := FND_REQUEST.SUBMIT_REQUEST(
2557: 'MSC', -- application
2558: 'MRPEAMRELB', -- program
2559: NULL, -- description
2560: NULL, -- start_time

Line 2588: lv_result := FND_REQUEST.SET_MODE(TRUE);

2584:
2585: EXECUTE IMMEDIATE lv_sqlstmt into lv_dummy USING
2586: lv_instance_id,G_WIP_GROUP_ID;
2587: -- set to trigger mode to bypass the 'SAVEPOINT' and 'ROLLBACK' command.
2588: lv_result := FND_REQUEST.SET_MODE(TRUE);
2589:
2590: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'dblink is '|| lv_dblink);
2591:
2592: o_request_id_cmro := FND_REQUEST.SUBMIT_REQUEST(

Line 2592: o_request_id_cmro := FND_REQUEST.SUBMIT_REQUEST(

2588: lv_result := FND_REQUEST.SET_MODE(TRUE);
2589:
2590: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'dblink is '|| lv_dblink);
2591:
2592: o_request_id_cmro := FND_REQUEST.SUBMIT_REQUEST(
2593: 'MSC', -- application
2594: 'MRPCMRELB', -- new exe name
2595: --The exe needs to be associated with procedure RELEASE_CMRO_WO in file MRPPSRELB.pls
2596: NULL, -- description

Line 2659: lv_result := FND_REQUEST.SET_MODE(TRUE);

2655: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' lv_sqlstmt is '|| lv_sqlstmt);
2656:
2657: EXECUTE IMMEDIATE lv_sqlstmt into lv_dummy USING lv_instance_id,G_WIP_GROUP_ID;
2658: -- set to trigger mode to bypass the 'SAVEPOINT' and 'ROLLBACK' command.
2659: lv_result := FND_REQUEST.SET_MODE(TRUE);
2660:
2661: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'dblink is '|| lv_dblink);
2662:
2663: o_request_id := FND_REQUEST.SUBMIT_REQUEST(

Line 2663: o_request_id := FND_REQUEST.SUBMIT_REQUEST(

2659: lv_result := FND_REQUEST.SET_MODE(TRUE);
2660:
2661: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'dblink is '|| lv_dblink);
2662:
2663: o_request_id := FND_REQUEST.SUBMIT_REQUEST(
2664: 'MSC', -- application
2665: 'MRPPSRELB', -- program
2666: NULL, -- description
2667: NULL, -- start_time

Line 2730: lv_result := FND_REQUEST.SET_MODE(TRUE);

2726: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' lv_sqlstmt is '|| lv_sqlstmt);
2727:
2728: EXECUTE IMMEDIATE lv_sqlstmt into lv_dummy USING lv_instance_id,G_WIP_GROUP_ID;
2729: -- set to trigger mode to bypass the 'SAVEPOINT' and 'ROLLBACK' command.
2730: lv_result := FND_REQUEST.SET_MODE(TRUE);
2731:
2732: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'dblink is '|| lv_dblink);
2733:
2734: o_request_id := FND_REQUEST.SUBMIT_REQUEST(

Line 2734: o_request_id := FND_REQUEST.SUBMIT_REQUEST(

2730: lv_result := FND_REQUEST.SET_MODE(TRUE);
2731:
2732: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'dblink is '|| lv_dblink);
2733:
2734: o_request_id := FND_REQUEST.SUBMIT_REQUEST(
2735: 'MSC', -- application
2736: 'MRPPSRELB', -- program
2737: NULL, -- description
2738: NULL, -- start_time

Line 3069: FND_REQUEST.SET_ORG_ID (c2.org_id);

3065: FOR C2 IN C1
3066: LOOP
3067:
3068: /*MO_GLOBAL.INIT ('PO'); Bug 8397994 */
3069: FND_REQUEST.SET_ORG_ID (c2.org_id);
3070: -- set to trigger mode to bypass the 'SAVEPOINT' and 'ROLLBACK' command.
3071: lv_result := FND_REQUEST.SET_MODE(TRUE);
3072:
3073: o_request_id := NULL;

Line 3071: lv_result := FND_REQUEST.SET_MODE(TRUE);

3067:
3068: /*MO_GLOBAL.INIT ('PO'); Bug 8397994 */
3069: FND_REQUEST.SET_ORG_ID (c2.org_id);
3070: -- set to trigger mode to bypass the 'SAVEPOINT' and 'ROLLBACK' command.
3071: lv_result := FND_REQUEST.SET_MODE(TRUE);
3072:
3073: o_request_id := NULL;
3074: o_request_id := FND_REQUEST.SUBMIT_REQUEST(
3075: 'PO', -- application

Line 3074: o_request_id := FND_REQUEST.SUBMIT_REQUEST(

3070: -- set to trigger mode to bypass the 'SAVEPOINT' and 'ROLLBACK' command.
3071: lv_result := FND_REQUEST.SET_MODE(TRUE);
3072:
3073: o_request_id := NULL;
3074: o_request_id := FND_REQUEST.SUBMIT_REQUEST(
3075: 'PO', -- application
3076: 'REQIMPORT',-- program
3077: NULL, -- description
3078: NULL, -- start_time

Line 3158: FND_REQUEST.SET_ORG_ID (c2.org_id);

3154: FOR C2 IN C1
3155: LOOP
3156:
3157: /*MO_GLOBAL.INIT ('PO'); Bug 8397994 */
3158: FND_REQUEST.SET_ORG_ID (c2.org_id);
3159: -- set to trigger mode to bypass the 'SAVEPOINT' and 'ROLLBACK' command.
3160: lv_result := FND_REQUEST.SET_MODE(TRUE);
3161:
3162: o_request_id := NULL;

Line 3160: lv_result := FND_REQUEST.SET_MODE(TRUE);

3156:
3157: /*MO_GLOBAL.INIT ('PO'); Bug 8397994 */
3158: FND_REQUEST.SET_ORG_ID (c2.org_id);
3159: -- set to trigger mode to bypass the 'SAVEPOINT' and 'ROLLBACK' command.
3160: lv_result := FND_REQUEST.SET_MODE(TRUE);
3161:
3162: o_request_id := NULL;
3163: o_request_id := FND_REQUEST.SUBMIT_REQUEST(
3164: 'PO', -- application

Line 3163: o_request_id := FND_REQUEST.SUBMIT_REQUEST(

3159: -- set to trigger mode to bypass the 'SAVEPOINT' and 'ROLLBACK' command.
3160: lv_result := FND_REQUEST.SET_MODE(TRUE);
3161:
3162: o_request_id := NULL;
3163: o_request_id := FND_REQUEST.SUBMIT_REQUEST(
3164: 'PO', -- application
3165: 'POXRSR', -- program
3166: NULL, -- description
3167: NULL, -- start_time

Line 4920: lv_result := FND_REQUEST.SET_MODE(TRUE);

4916:
4917: MODIFY_EAM_RES_REQUIREMENT;
4918:
4919: --set to trigger mode to bypass the 'SAVEPOINT' and 'ROLLBACK' command.
4920: lv_result := FND_REQUEST.SET_MODE(TRUE);
4921:
4922:
4923: o_request_id := FND_REQUEST.SUBMIT_REQUEST(
4924: 'EAM', -- application

Line 4923: o_request_id := FND_REQUEST.SUBMIT_REQUEST(

4919: --set to trigger mode to bypass the 'SAVEPOINT' and 'ROLLBACK' command.
4920: lv_result := FND_REQUEST.SET_MODE(TRUE);
4921:
4922:
4923: o_request_id := FND_REQUEST.SUBMIT_REQUEST(
4924: 'EAM', -- application
4925: 'EAMIMPWO', -- program
4926: NULL, -- description
4927: NULL, -- start_time