DBA Data[Home] [Help]

APPS.GME_API_MAIN dependencies on GME_BATCH_HEADER

Line 14: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

10: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
11: ,x_message_count OUT NOCOPY NUMBER
12: ,x_message_list OUT NOCOPY VARCHAR2
13: ,x_return_status OUT NOCOPY VARCHAR2
14: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
15: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
16: ,p_batch_size IN NUMBER
17: ,p_batch_size_uom IN VARCHAR2
18: ,p_creation_mode IN VARCHAR2

Line 15: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

11: ,x_message_count OUT NOCOPY NUMBER
12: ,x_message_list OUT NOCOPY VARCHAR2
13: ,x_return_status OUT NOCOPY VARCHAR2
14: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
15: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
16: ,p_batch_size IN NUMBER
17: ,p_batch_size_uom IN VARCHAR2
18: ,p_creation_mode IN VARCHAR2
19: ,p_recipe_id IN NUMBER := NULL

Line 146: ,p_batch_header_rec IN gme_batch_header%ROWTYPE --Bug#6738476

142: ,x_message_count OUT NOCOPY NUMBER
143: ,x_message_list OUT NOCOPY VARCHAR2
144: ,x_return_status OUT NOCOPY VARCHAR2
145: ,p_material_detail_rec IN gme_material_details%ROWTYPE
146: ,p_batch_header_rec IN gme_batch_header%ROWTYPE --Bug#6738476
147: ,p_batch_no IN VARCHAR2 DEFAULT NULL
148: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
149: ,p_validity_rule_id IN NUMBER
150: ,p_use_workday_cal IN VARCHAR2 := fnd_api.g_true

Line 158: l_batch_header gme_batch_header%ROWTYPE;

154: IS
155: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_PHANTOM';
156: setup_failure EXCEPTION;
157: phantom_creation_failure EXCEPTION;
158: l_batch_header gme_batch_header%ROWTYPE;
159: BEGIN
160: /* Set the save point initially */
161: SAVEPOINT create_phantom;
162:

Line 242: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

238:
239: PROCEDURE scale_batch (
240: p_validation_level IN NUMBER
241: ,p_init_msg_list IN VARCHAR2
242: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
243: ,p_scale_factor IN NUMBER
244: ,p_primaries IN VARCHAR2
245: ,p_qty_type IN NUMBER
246: ,p_recalc_dates IN VARCHAR2

Line 250: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

246: ,p_recalc_dates IN VARCHAR2
247: ,p_use_workday_cal IN VARCHAR2
248: ,p_contiguity_override IN VARCHAR2
249: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
250: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
251: ,x_message_count OUT NOCOPY NUMBER
252: ,x_message_list OUT NOCOPY VARCHAR2
253: ,x_return_status OUT NOCOPY VARCHAR2)
254: IS

Line 351: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

347: /*************************************************************************/
348: PROCEDURE theoretical_yield_batch (
349: p_validation_level IN NUMBER
350: ,p_init_msg_list IN VARCHAR2
351: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
352: ,p_scale_factor IN NUMBER
353: ,x_message_count OUT NOCOPY NUMBER
354: ,x_message_list OUT NOCOPY VARCHAR2
355: ,x_return_status OUT NOCOPY VARCHAR2)

Line 441: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

437: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
438: ,x_message_count OUT NOCOPY NUMBER
439: ,x_message_list OUT NOCOPY VARCHAR2
440: ,x_return_status OUT NOCOPY VARCHAR2
441: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
442: ,p_material_detail_rec IN gme_material_details%ROWTYPE
443: ,p_batch_step_id IN NUMBER := NULL
444: ,p_trans_id IN NUMBER
445: ,x_transacted OUT NOCOPY VARCHAR2

Line 607: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

603: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
604: ,x_message_count OUT NOCOPY NUMBER
605: ,x_message_list OUT NOCOPY VARCHAR2
606: ,x_return_status OUT NOCOPY VARCHAR2
607: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
608: ,p_material_detail_rec IN gme_material_details%ROWTYPE
609: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
610: ,p_trans_id IN NUMBER
611: ,x_transacted OUT NOCOPY VARCHAR2

Line 725: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

721: := fnd_api.g_false
722: ,x_message_count OUT NOCOPY NUMBER
723: ,x_message_list OUT NOCOPY VARCHAR2
724: ,x_return_status OUT NOCOPY VARCHAR2
725: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
726: ,p_material_detail_rec IN gme_material_details%ROWTYPE
727: ,p_batch_step_id IN NUMBER := NULL
728: ,p_scale_phantom IN VARCHAR2 := fnd_api.g_false
729: ,p_trans_id IN NUMBER

Line 883: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

879: := fnd_api.g_false
880: ,x_message_count OUT NOCOPY NUMBER
881: ,x_message_list OUT NOCOPY VARCHAR2
882: ,x_return_status OUT NOCOPY VARCHAR2
883: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
884: ,p_material_detail_rec IN gme_material_details%ROWTYPE
885: ,p_stored_material_detail_rec IN gme_material_details%ROWTYPE
886: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
887: ,p_scale_phantom IN VARCHAR2

Line 1003: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

999: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1000: ,x_message_count OUT NOCOPY NUMBER
1001: ,x_message_list OUT NOCOPY VARCHAR2
1002: ,x_return_status OUT NOCOPY VARCHAR2
1003: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1004: ,p_material_detail_rec IN gme_material_details%ROWTYPE
1005: ,p_batch_step_id IN NUMBER := NULL
1006: ,x_transacted OUT NOCOPY VARCHAR2)
1007: IS

Line 1168: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

1164: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1165: ,x_message_count OUT NOCOPY NUMBER
1166: ,x_message_list OUT NOCOPY VARCHAR2
1167: ,x_return_status OUT NOCOPY VARCHAR2
1168: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1169: ,p_material_detail_rec IN gme_material_details%ROWTYPE
1170: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
1171: ,x_transacted OUT NOCOPY VARCHAR2)
1172: IS

Line 1272: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

1268: /*************************************************************************/
1269: PROCEDURE reschedule_batch (
1270: p_validation_level IN NUMBER
1271: ,p_init_msg_list IN VARCHAR2
1272: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1273: ,p_use_workday_cal IN VARCHAR2
1274: ,p_contiguity_override IN VARCHAR2
1275: ,x_message_count OUT NOCOPY NUMBER
1276: ,x_message_list OUT NOCOPY VARCHAR2

Line 1278: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)

1274: ,p_contiguity_override IN VARCHAR2
1275: ,x_message_count OUT NOCOPY NUMBER
1276: ,x_message_list OUT NOCOPY VARCHAR2
1277: ,x_return_status OUT NOCOPY VARCHAR2
1278: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
1279: IS
1280: l_api_name CONSTANT VARCHAR2 (30) := 'RESCHEDULE_BATCH';
1281: reschedule_batch_failed EXCEPTION;
1282: setup_failure EXCEPTION;

Line 1381: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

1377: /*************************************************************************/
1378: PROCEDURE reschedule_step (
1379: p_validation_level IN NUMBER
1380: ,p_init_msg_list IN VARCHAR2
1381: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1382: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
1383: ,p_reschedule_preceding IN VARCHAR2
1384: ,p_reschedule_succeeding IN VARCHAR2
1385: ,p_use_workday_cal IN VARCHAR2

Line 1505: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

1501:
1502: /*************************************************************************/
1503: PROCEDURE create_batch_reservations (
1504: p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1505: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1506: ,x_message_count OUT NOCOPY NUMBER
1507: ,x_message_list OUT NOCOPY VARCHAR2
1508: ,x_return_status OUT NOCOPY VARCHAR2)
1509: IS

Line 1741: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

1737: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1738: ,x_message_count OUT NOCOPY NUMBER
1739: ,x_message_list OUT NOCOPY VARCHAR2
1740: ,x_return_status OUT NOCOPY VARCHAR2
1741: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1742: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
1743: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
1744: ,p_ignore_exception IN VARCHAR2 := NULL) --Bug#5186328
1745: IS

Line 1742: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

1738: ,x_message_count OUT NOCOPY NUMBER
1739: ,x_message_list OUT NOCOPY VARCHAR2
1740: ,x_return_status OUT NOCOPY VARCHAR2
1741: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1742: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
1743: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
1744: ,p_ignore_exception IN VARCHAR2 := NULL) --Bug#5186328
1745: IS
1746: l_api_name CONSTANT VARCHAR2 (30) := 'RELEASE_BATCH';

Line 1857: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

1853: ,x_message_count OUT NOCOPY NUMBER
1854: ,x_message_list OUT NOCOPY VARCHAR2
1855: ,x_return_status OUT NOCOPY VARCHAR2
1856: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
1857: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1858: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
1859: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
1860: ,p_ignore_exception IN VARCHAR2 := NULL) --Bug#5186328
1861: IS

Line 1972: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

1968: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1969: ,x_message_count OUT NOCOPY NUMBER
1970: ,x_message_list OUT NOCOPY VARCHAR2
1971: ,x_return_status OUT NOCOPY VARCHAR2
1972: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1973: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
1974: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
1975: ,p_ignore_exception IN VARCHAR2 := NULL) --Bug#5186328
1976: IS

Line 1973: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

1969: ,x_message_count OUT NOCOPY NUMBER
1970: ,x_message_list OUT NOCOPY VARCHAR2
1971: ,x_return_status OUT NOCOPY VARCHAR2
1972: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1973: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
1974: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
1975: ,p_ignore_exception IN VARCHAR2 := NULL) --Bug#5186328
1976: IS
1977: l_api_name CONSTANT VARCHAR2 (30) := 'COMPLETE_BATCH';

Line 2086: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

2082: ,x_message_count OUT NOCOPY NUMBER
2083: ,x_message_list OUT NOCOPY VARCHAR2
2084: ,x_return_status OUT NOCOPY VARCHAR2
2085: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
2086: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2087: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
2088: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
2089: ,p_ignore_exception IN VARCHAR2 := NULL) --Bug#5186328
2090: IS

Line 2202: ,p_batch_header_rec IN gme_batch_header%ROWTYPE)

2198: ,x_message_count OUT NOCOPY NUMBER
2199: ,x_message_list OUT NOCOPY VARCHAR2
2200: ,x_return_status OUT NOCOPY VARCHAR2
2201: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
2202: ,p_batch_header_rec IN gme_batch_header%ROWTYPE)
2203: IS
2204: l_api_name CONSTANT VARCHAR2 (30) := 'DELETE_STEP';
2205: delete_step_failed EXCEPTION;
2206: batch_save_failed EXCEPTION;

Line 2317: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

2313: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2314: ,x_message_count OUT NOCOPY NUMBER
2315: ,x_message_list OUT NOCOPY VARCHAR2
2316: ,x_return_status OUT NOCOPY VARCHAR2
2317: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2318: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
2319: ,x_batch_step OUT NOCOPY gme_batch_steps%ROWTYPE)
2320: IS
2321: l_api_name CONSTANT VARCHAR2 (30) := 'INSERT_STEP';

Line 2322: l_batch_header gme_batch_header%ROWTYPE;

2318: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
2319: ,x_batch_step OUT NOCOPY gme_batch_steps%ROWTYPE)
2320: IS
2321: l_api_name CONSTANT VARCHAR2 (30) := 'INSERT_STEP';
2322: l_batch_header gme_batch_header%ROWTYPE;
2323: insert_step_failed EXCEPTION;
2324: batch_save_failed EXCEPTION;
2325: setup_failure EXCEPTION;
2326:

Line 2366: (p_gme_batch_header => p_batch_header_rec

2362:
2363: /* Punit Kumar */
2364: gme_common_pvt.set_timestamp;
2365: gme_insert_step_pvt.insert_batch_step
2366: (p_gme_batch_header => p_batch_header_rec
2367: ,p_gme_batch_step => p_batch_step_rec
2368: ,x_gme_batch_step => x_batch_step
2369: ,x_return_status => x_return_status);
2370:

Line 2448: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

2444: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2445: ,x_message_count OUT NOCOPY NUMBER
2446: ,x_message_list OUT NOCOPY VARCHAR2
2447: ,x_return_status OUT NOCOPY VARCHAR2
2448: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2449: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
2450: IS
2451:
2452: l_api_name CONSTANT VARCHAR2 (30) := 'REVERT_BATCH';

Line 2449: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)

2445: ,x_message_count OUT NOCOPY NUMBER
2446: ,x_message_list OUT NOCOPY VARCHAR2
2447: ,x_return_status OUT NOCOPY VARCHAR2
2448: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2449: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
2450: IS
2451:
2452: l_api_name CONSTANT VARCHAR2 (30) := 'REVERT_BATCH';
2453: setup_failure EXCEPTION;

Line 2579: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

2575: ,x_message_count OUT NOCOPY NUMBER
2576: ,x_message_list OUT NOCOPY VARCHAR2
2577: ,x_return_status OUT NOCOPY VARCHAR2
2578: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
2579: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2580: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)IS
2581:
2582:
2583: l_api_name CONSTANT VARCHAR2 (30) := 'REVERT_STEP';

Line 2708: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

2704: ,p_init_msg_list IN VARCHAR2
2705: ,x_message_count OUT NOCOPY NUMBER
2706: ,x_message_list OUT NOCOPY VARCHAR2
2707: ,x_return_status OUT NOCOPY VARCHAR2
2708: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2709: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
2710: IS
2711: l_api_name CONSTANT VARCHAR2 (30) := 'CLOSE_BATCH';
2712: setup_failure EXCEPTION;

Line 2709: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)

2705: ,x_message_count OUT NOCOPY NUMBER
2706: ,x_message_list OUT NOCOPY VARCHAR2
2707: ,x_return_status OUT NOCOPY VARCHAR2
2708: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2709: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
2710: IS
2711: l_api_name CONSTANT VARCHAR2 (30) := 'CLOSE_BATCH';
2712: setup_failure EXCEPTION;
2713: batch_close_failure EXCEPTION;

Line 2815: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

2811: p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2812: ,x_message_count OUT NOCOPY NUMBER
2813: ,x_message_list OUT NOCOPY VARCHAR2
2814: ,x_return_status OUT NOCOPY VARCHAR2
2815: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2816: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
2817: ,p_delete_pending IN VARCHAR2 := fnd_api.g_false
2818: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)
2819: IS

Line 2824: l_batch_hdr gme_batch_header%ROWTYPE;

2820: l_api_name CONSTANT VARCHAR2 (30) := 'CLOSE_STEP';
2821: setup_failure EXCEPTION;
2822: batch_save_failed EXCEPTION;
2823: step_close_failed EXCEPTION;
2824: l_batch_hdr gme_batch_header%ROWTYPE;
2825: BEGIN
2826: /* Set the savepoint before proceeding */
2827: SAVEPOINT close_batch_step;
2828:

Line 2911: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

2907: p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2908: ,x_message_count OUT NOCOPY NUMBER
2909: ,x_message_list OUT NOCOPY VARCHAR2
2910: ,x_return_status OUT NOCOPY VARCHAR2
2911: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2912: ,p_reopen_steps IN VARCHAR2 := fnd_api.g_false
2913: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
2914: IS
2915: l_api_name CONSTANT VARCHAR2 (30) := 'REOPEN_BATCH';

Line 2913: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)

2909: ,x_message_list OUT NOCOPY VARCHAR2
2910: ,x_return_status OUT NOCOPY VARCHAR2
2911: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2912: ,p_reopen_steps IN VARCHAR2 := fnd_api.g_false
2913: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
2914: IS
2915: l_api_name CONSTANT VARCHAR2 (30) := 'REOPEN_BATCH';
2916: setup_failure EXCEPTION;
2917: batch_save_failed EXCEPTION;

Line 3049: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

3045: p_init_msg_list IN VARCHAR2 := fnd_api.g_false
3046: ,x_message_count OUT NOCOPY NUMBER
3047: ,x_message_list OUT NOCOPY VARCHAR2
3048: ,x_return_status OUT NOCOPY VARCHAR2
3049: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3050: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
3051: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)
3052: IS
3053: l_api_name CONSTANT VARCHAR2 (30) := 'REOPEN_STEP';

Line 3057: l_batch_header gme_batch_header%ROWTYPE;

3053: l_api_name CONSTANT VARCHAR2 (30) := 'REOPEN_STEP';
3054: setup_failure EXCEPTION;
3055: step_save_failed EXCEPTION;
3056: step_reopen_failure EXCEPTION;
3057: l_batch_header gme_batch_header%ROWTYPE;
3058: BEGIN
3059: -- Set the save point before proceeding
3060: SAVEPOINT reopen_batch_step;
3061:

Line 3212: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

3208: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
3209: ,x_message_count OUT NOCOPY NUMBER
3210: ,x_message_list OUT NOCOPY VARCHAR2
3211: ,x_return_status OUT NOCOPY VARCHAR2
3212: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3213: ,p_material_detail_rec IN gme_material_details%ROWTYPE
3214: ,p_qty IN NUMBER
3215: ,p_qty_type IN NUMBER
3216: ,p_trans_date IN DATE

Line 3352: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

3348: PROCEDURE reroute_batch (
3349: p_validation_level IN NUMBER
3350: := gme_common_pvt.g_max_errors
3351: ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
3352: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3353: ,p_validity_rule_id IN NUMBER
3354: ,p_use_workday_cal IN VARCHAR2 DEFAULT fnd_api.g_false
3355: ,p_contiguity_override IN VARCHAR2 DEFAULT fnd_api.g_false
3356: ,x_message_count OUT NOCOPY NUMBER

Line 3359: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)

3355: ,p_contiguity_override IN VARCHAR2 DEFAULT fnd_api.g_false
3356: ,x_message_count OUT NOCOPY NUMBER
3357: ,x_message_list OUT NOCOPY VARCHAR2
3358: ,x_return_status OUT NOCOPY VARCHAR2
3359: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
3360: IS
3361: l_api_name CONSTANT VARCHAR2 (30) := 'REROUTE_BATCH';
3362: no_continous_periods EXCEPTION;
3363: setup_failure EXCEPTION;

Line 3515: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

3511: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
3512: ,x_message_count OUT NOCOPY NUMBER
3513: ,x_message_list OUT NOCOPY VARCHAR2
3514: ,x_return_status OUT NOCOPY VARCHAR2
3515: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3516: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
3517: IS
3518: l_api_name CONSTANT VARCHAR2 (30) := 'CANCEL_BATCH';
3519: setup_failure EXCEPTION;

Line 3516: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)

3512: ,x_message_count OUT NOCOPY NUMBER
3513: ,x_message_list OUT NOCOPY VARCHAR2
3514: ,x_return_status OUT NOCOPY VARCHAR2
3515: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3516: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
3517: IS
3518: l_api_name CONSTANT VARCHAR2 (30) := 'CANCEL_BATCH';
3519: setup_failure EXCEPTION;
3520: batch_cancel_failure EXCEPTION;

Line 3665: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

3661: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
3662: ,x_message_count OUT NOCOPY NUMBER
3663: ,x_message_list OUT NOCOPY VARCHAR2
3664: ,x_return_status OUT NOCOPY VARCHAR2
3665: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3666: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
3667: IS
3668: l_api_name CONSTANT VARCHAR2 (30) := 'TERMINATE_BATCH';
3669: setup_failure EXCEPTION;

Line 3666: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)

3662: ,x_message_count OUT NOCOPY NUMBER
3663: ,x_message_list OUT NOCOPY VARCHAR2
3664: ,x_return_status OUT NOCOPY VARCHAR2
3665: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3666: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
3667: IS
3668: l_api_name CONSTANT VARCHAR2 (30) := 'TERMINATE_BATCH';
3669: setup_failure EXCEPTION;
3670: batch_terminate_failure EXCEPTION;

Line 3814: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

3810: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
3811: ,x_message_count OUT NOCOPY NUMBER
3812: ,x_message_list OUT NOCOPY VARCHAR2
3813: ,x_return_status OUT NOCOPY VARCHAR2
3814: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3815: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
3816: ,p_create_resv_pend_lots IN NUMBER)
3817: IS
3818: l_api_name CONSTANT VARCHAR2 (30) := 'UNRELEASE_BATCH';

Line 3815: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

3811: ,x_message_count OUT NOCOPY NUMBER
3812: ,x_message_list OUT NOCOPY VARCHAR2
3813: ,x_return_status OUT NOCOPY VARCHAR2
3814: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3815: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
3816: ,p_create_resv_pend_lots IN NUMBER)
3817: IS
3818: l_api_name CONSTANT VARCHAR2 (30) := 'UNRELEASE_BATCH';
3819: setup_failure EXCEPTION;

Line 3921: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

3917: ,x_message_count OUT NOCOPY NUMBER
3918: ,x_message_list OUT NOCOPY VARCHAR2
3919: ,x_return_status OUT NOCOPY VARCHAR2
3920: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
3921: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3922: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
3923: ,p_create_resv_pend_lots IN NUMBER)
3924: IS
3925: l_api_name CONSTANT VARCHAR2 (30) := 'UNRELEASE_STEP';

Line 4111: p_batch_rec IN gme_batch_header%ROWTYPE) IS

4107: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4108: x_message_count OUT NOCOPY NUMBER,
4109: x_message_list OUT NOCOPY VARCHAR2,
4110: x_return_status OUT NOCOPY VARCHAR2,
4111: p_batch_rec IN gme_batch_header%ROWTYPE) IS
4112:
4113: l_api_name CONSTANT VARCHAR2 (30) := 'AUTO_DETAIL_BATCH';
4114:
4115: