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 148: ,p_batch_header_rec IN gme_batch_header%ROWTYPE --Bug#6738476

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

Line 160: l_batch_header gme_batch_header%ROWTYPE;

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

Line 244: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

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

Line 252: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

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

Line 353: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

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

Line 443: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

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

Line 621: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

617: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
618: ,x_message_count OUT NOCOPY NUMBER
619: ,x_message_list OUT NOCOPY VARCHAR2
620: ,x_return_status OUT NOCOPY VARCHAR2
621: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
622: ,p_material_detail_rec IN gme_material_details%ROWTYPE
623: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
624: ,p_trans_id IN NUMBER
625: ,x_transacted OUT NOCOPY VARCHAR2

Line 739: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

735: := fnd_api.g_false
736: ,x_message_count OUT NOCOPY NUMBER
737: ,x_message_list OUT NOCOPY VARCHAR2
738: ,x_return_status OUT NOCOPY VARCHAR2
739: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
740: ,p_material_detail_rec IN gme_material_details%ROWTYPE
741: ,p_batch_step_id IN NUMBER := NULL
742: ,p_scale_phantom IN VARCHAR2 := fnd_api.g_false
743: ,p_trans_id IN NUMBER

Line 935: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

931: := fnd_api.g_false
932: ,x_message_count OUT NOCOPY NUMBER
933: ,x_message_list OUT NOCOPY VARCHAR2
934: ,x_return_status OUT NOCOPY VARCHAR2
935: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
936: ,p_material_detail_rec IN gme_material_details%ROWTYPE
937: ,p_stored_material_detail_rec IN gme_material_details%ROWTYPE
938: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
939: ,p_scale_phantom IN VARCHAR2

Line 1055: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

1051: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1052: ,x_message_count OUT NOCOPY NUMBER
1053: ,x_message_list OUT NOCOPY VARCHAR2
1054: ,x_return_status OUT NOCOPY VARCHAR2
1055: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1056: ,p_material_detail_rec IN gme_material_details%ROWTYPE
1057: ,p_batch_step_id IN NUMBER := NULL
1058: ,p_bypass_gmf IN VARCHAR2 := 'N'
1059: ,x_transacted OUT NOCOPY VARCHAR2)

Line 1226: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

1222: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1223: ,x_message_count OUT NOCOPY NUMBER
1224: ,x_message_list OUT NOCOPY VARCHAR2
1225: ,x_return_status OUT NOCOPY VARCHAR2
1226: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1227: ,p_material_detail_rec IN gme_material_details%ROWTYPE
1228: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
1229: ,x_transacted OUT NOCOPY VARCHAR2)
1230: IS

Line 1330: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

1326: /*************************************************************************/
1327: PROCEDURE reschedule_batch (
1328: p_validation_level IN NUMBER
1329: ,p_init_msg_list IN VARCHAR2
1330: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1331: ,p_use_workday_cal IN VARCHAR2
1332: ,p_contiguity_override IN VARCHAR2
1333: ,x_message_count OUT NOCOPY NUMBER
1334: ,x_message_list OUT NOCOPY VARCHAR2

Line 1336: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)

1332: ,p_contiguity_override IN VARCHAR2
1333: ,x_message_count OUT NOCOPY NUMBER
1334: ,x_message_list OUT NOCOPY VARCHAR2
1335: ,x_return_status OUT NOCOPY VARCHAR2
1336: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
1337: IS
1338: l_api_name CONSTANT VARCHAR2 (30) := 'RESCHEDULE_BATCH';
1339: reschedule_batch_failed EXCEPTION;
1340: setup_failure EXCEPTION;

Line 1439: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

1435: /*************************************************************************/
1436: PROCEDURE reschedule_step (
1437: p_validation_level IN NUMBER
1438: ,p_init_msg_list IN VARCHAR2
1439: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1440: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
1441: ,p_reschedule_preceding IN VARCHAR2
1442: ,p_reschedule_succeeding IN VARCHAR2
1443: ,p_use_workday_cal IN VARCHAR2

Line 1563: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

1559:
1560: /*************************************************************************/
1561: PROCEDURE create_batch_reservations (
1562: p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1563: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1564: ,x_message_count OUT NOCOPY NUMBER
1565: ,x_message_list OUT NOCOPY VARCHAR2
1566: ,x_return_status OUT NOCOPY VARCHAR2)
1567: IS

Line 1802: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

1798: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1799: ,x_message_count OUT NOCOPY NUMBER
1800: ,x_message_list OUT NOCOPY VARCHAR2
1801: ,x_return_status OUT NOCOPY VARCHAR2
1802: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1803: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
1804: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
1805: ,p_ignore_exception IN VARCHAR2 := NULL) --Bug#5186328
1806: IS

Line 1803: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

1799: ,x_message_count OUT NOCOPY NUMBER
1800: ,x_message_list OUT NOCOPY VARCHAR2
1801: ,x_return_status OUT NOCOPY VARCHAR2
1802: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1803: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
1804: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
1805: ,p_ignore_exception IN VARCHAR2 := NULL) --Bug#5186328
1806: IS
1807: l_api_name CONSTANT VARCHAR2 (30) := 'RELEASE_BATCH';

Line 1918: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

1914: ,x_message_count OUT NOCOPY NUMBER
1915: ,x_message_list OUT NOCOPY VARCHAR2
1916: ,x_return_status OUT NOCOPY VARCHAR2
1917: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
1918: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1919: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
1920: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
1921: ,p_ignore_exception IN VARCHAR2 := NULL) --Bug#5186328
1922: IS

Line 2033: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

2029: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2030: ,x_message_count OUT NOCOPY NUMBER
2031: ,x_message_list OUT NOCOPY VARCHAR2
2032: ,x_return_status OUT NOCOPY VARCHAR2
2033: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2034: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
2035: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
2036: ,p_ignore_exception IN VARCHAR2 := NULL) --Bug#5186328
2037: IS

Line 2034: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

2030: ,x_message_count OUT NOCOPY NUMBER
2031: ,x_message_list OUT NOCOPY VARCHAR2
2032: ,x_return_status OUT NOCOPY VARCHAR2
2033: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2034: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
2035: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
2036: ,p_ignore_exception IN VARCHAR2 := NULL) --Bug#5186328
2037: IS
2038: l_api_name CONSTANT VARCHAR2 (30) := 'COMPLETE_BATCH';

Line 2147: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

2143: ,x_message_count OUT NOCOPY NUMBER
2144: ,x_message_list OUT NOCOPY VARCHAR2
2145: ,x_return_status OUT NOCOPY VARCHAR2
2146: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
2147: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2148: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
2149: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
2150: ,p_ignore_exception IN VARCHAR2 := NULL) --Bug#5186328
2151: IS

Line 2263: ,p_batch_header_rec IN gme_batch_header%ROWTYPE)

2259: ,x_message_count OUT NOCOPY NUMBER
2260: ,x_message_list OUT NOCOPY VARCHAR2
2261: ,x_return_status OUT NOCOPY VARCHAR2
2262: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
2263: ,p_batch_header_rec IN gme_batch_header%ROWTYPE)
2264: IS
2265: l_api_name CONSTANT VARCHAR2 (30) := 'DELETE_STEP';
2266: delete_step_failed EXCEPTION;
2267: batch_save_failed EXCEPTION;

Line 2378: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

2374: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2375: ,x_message_count OUT NOCOPY NUMBER
2376: ,x_message_list OUT NOCOPY VARCHAR2
2377: ,x_return_status OUT NOCOPY VARCHAR2
2378: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2379: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
2380: ,x_batch_step OUT NOCOPY gme_batch_steps%ROWTYPE)
2381: IS
2382: l_api_name CONSTANT VARCHAR2 (30) := 'INSERT_STEP';

Line 2383: l_batch_header gme_batch_header%ROWTYPE;

2379: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
2380: ,x_batch_step OUT NOCOPY gme_batch_steps%ROWTYPE)
2381: IS
2382: l_api_name CONSTANT VARCHAR2 (30) := 'INSERT_STEP';
2383: l_batch_header gme_batch_header%ROWTYPE;
2384: insert_step_failed EXCEPTION;
2385: batch_save_failed EXCEPTION;
2386: setup_failure EXCEPTION;
2387:

Line 2427: (p_gme_batch_header => p_batch_header_rec

2423:
2424: /* Punit Kumar */
2425: gme_common_pvt.set_timestamp;
2426: gme_insert_step_pvt.insert_batch_step
2427: (p_gme_batch_header => p_batch_header_rec
2428: ,p_gme_batch_step => p_batch_step_rec
2429: ,x_gme_batch_step => x_batch_step
2430: ,x_return_status => x_return_status);
2431:

Line 2509: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

2505: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2506: ,x_message_count OUT NOCOPY NUMBER
2507: ,x_message_list OUT NOCOPY VARCHAR2
2508: ,x_return_status OUT NOCOPY VARCHAR2
2509: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2510: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
2511: IS
2512:
2513: l_api_name CONSTANT VARCHAR2 (30) := 'REVERT_BATCH';

Line 2510: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)

2506: ,x_message_count OUT NOCOPY NUMBER
2507: ,x_message_list OUT NOCOPY VARCHAR2
2508: ,x_return_status OUT NOCOPY VARCHAR2
2509: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2510: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
2511: IS
2512:
2513: l_api_name CONSTANT VARCHAR2 (30) := 'REVERT_BATCH';
2514: setup_failure EXCEPTION;

Line 2640: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

2636: ,x_message_count OUT NOCOPY NUMBER
2637: ,x_message_list OUT NOCOPY VARCHAR2
2638: ,x_return_status OUT NOCOPY VARCHAR2
2639: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
2640: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2641: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)IS
2642:
2643:
2644: l_api_name CONSTANT VARCHAR2 (30) := 'REVERT_STEP';

Line 2769: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

2765: ,p_init_msg_list IN VARCHAR2
2766: ,x_message_count OUT NOCOPY NUMBER
2767: ,x_message_list OUT NOCOPY VARCHAR2
2768: ,x_return_status OUT NOCOPY VARCHAR2
2769: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2770: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
2771: IS
2772: l_api_name CONSTANT VARCHAR2 (30) := 'CLOSE_BATCH';
2773: setup_failure EXCEPTION;

Line 2770: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)

2766: ,x_message_count OUT NOCOPY NUMBER
2767: ,x_message_list OUT NOCOPY VARCHAR2
2768: ,x_return_status OUT NOCOPY VARCHAR2
2769: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2770: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
2771: IS
2772: l_api_name CONSTANT VARCHAR2 (30) := 'CLOSE_BATCH';
2773: setup_failure EXCEPTION;
2774: batch_close_failure EXCEPTION;

Line 2876: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

2872: p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2873: ,x_message_count OUT NOCOPY NUMBER
2874: ,x_message_list OUT NOCOPY VARCHAR2
2875: ,x_return_status OUT NOCOPY VARCHAR2
2876: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2877: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
2878: ,p_delete_pending IN VARCHAR2 := fnd_api.g_false
2879: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)
2880: IS

Line 2885: l_batch_hdr gme_batch_header%ROWTYPE;

2881: l_api_name CONSTANT VARCHAR2 (30) := 'CLOSE_STEP';
2882: setup_failure EXCEPTION;
2883: batch_save_failed EXCEPTION;
2884: step_close_failed EXCEPTION;
2885: l_batch_hdr gme_batch_header%ROWTYPE;
2886: BEGIN
2887: /* Set the savepoint before proceeding */
2888: SAVEPOINT close_batch_step;
2889:

Line 2972: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

2968: p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2969: ,x_message_count OUT NOCOPY NUMBER
2970: ,x_message_list OUT NOCOPY VARCHAR2
2971: ,x_return_status OUT NOCOPY VARCHAR2
2972: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2973: ,p_reopen_steps IN VARCHAR2 := fnd_api.g_false
2974: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
2975: IS
2976: l_api_name CONSTANT VARCHAR2 (30) := 'REOPEN_BATCH';

Line 2974: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)

2970: ,x_message_list OUT NOCOPY VARCHAR2
2971: ,x_return_status OUT NOCOPY VARCHAR2
2972: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2973: ,p_reopen_steps IN VARCHAR2 := fnd_api.g_false
2974: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
2975: IS
2976: l_api_name CONSTANT VARCHAR2 (30) := 'REOPEN_BATCH';
2977: setup_failure EXCEPTION;
2978: batch_save_failed EXCEPTION;

Line 3110: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

3106: p_init_msg_list IN VARCHAR2 := fnd_api.g_false
3107: ,x_message_count OUT NOCOPY NUMBER
3108: ,x_message_list OUT NOCOPY VARCHAR2
3109: ,x_return_status OUT NOCOPY VARCHAR2
3110: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3111: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
3112: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)
3113: IS
3114: l_api_name CONSTANT VARCHAR2 (30) := 'REOPEN_STEP';

Line 3118: l_batch_header gme_batch_header%ROWTYPE;

3114: l_api_name CONSTANT VARCHAR2 (30) := 'REOPEN_STEP';
3115: setup_failure EXCEPTION;
3116: step_save_failed EXCEPTION;
3117: step_reopen_failure EXCEPTION;
3118: l_batch_header gme_batch_header%ROWTYPE;
3119: BEGIN
3120: -- Set the save point before proceeding
3121: SAVEPOINT reopen_batch_step;
3122:

Line 3285: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

3281: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
3282: ,x_message_count OUT NOCOPY NUMBER
3283: ,x_message_list OUT NOCOPY VARCHAR2
3284: ,x_return_status OUT NOCOPY VARCHAR2
3285: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3286: ,p_material_detail_rec IN gme_material_details%ROWTYPE
3287: ,p_qty IN NUMBER
3288: ,p_qty_type IN NUMBER
3289: ,p_trans_date IN DATE

Line 3452: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

3448: PROCEDURE reroute_batch (
3449: p_validation_level IN NUMBER
3450: := gme_common_pvt.g_max_errors
3451: ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
3452: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3453: ,p_validity_rule_id IN NUMBER
3454: ,p_use_workday_cal IN VARCHAR2 DEFAULT fnd_api.g_false
3455: ,p_contiguity_override IN VARCHAR2 DEFAULT fnd_api.g_false
3456: ,x_message_count OUT NOCOPY NUMBER

Line 3459: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)

3455: ,p_contiguity_override IN VARCHAR2 DEFAULT fnd_api.g_false
3456: ,x_message_count OUT NOCOPY NUMBER
3457: ,x_message_list OUT NOCOPY VARCHAR2
3458: ,x_return_status OUT NOCOPY VARCHAR2
3459: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
3460: IS
3461: l_api_name CONSTANT VARCHAR2 (30) := 'REROUTE_BATCH';
3462: no_continous_periods EXCEPTION;
3463: setup_failure EXCEPTION;

Line 3615: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

3611: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
3612: ,x_message_count OUT NOCOPY NUMBER
3613: ,x_message_list OUT NOCOPY VARCHAR2
3614: ,x_return_status OUT NOCOPY VARCHAR2
3615: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3616: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
3617: IS
3618: l_api_name CONSTANT VARCHAR2 (30) := 'CANCEL_BATCH';
3619: setup_failure EXCEPTION;

Line 3616: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)

3612: ,x_message_count OUT NOCOPY NUMBER
3613: ,x_message_list OUT NOCOPY VARCHAR2
3614: ,x_return_status OUT NOCOPY VARCHAR2
3615: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3616: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
3617: IS
3618: l_api_name CONSTANT VARCHAR2 (30) := 'CANCEL_BATCH';
3619: setup_failure EXCEPTION;
3620: batch_cancel_failure EXCEPTION;

Line 3765: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

3761: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
3762: ,x_message_count OUT NOCOPY NUMBER
3763: ,x_message_list OUT NOCOPY VARCHAR2
3764: ,x_return_status OUT NOCOPY VARCHAR2
3765: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3766: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
3767: IS
3768: l_api_name CONSTANT VARCHAR2 (30) := 'TERMINATE_BATCH';
3769: setup_failure EXCEPTION;

Line 3766: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)

3762: ,x_message_count OUT NOCOPY NUMBER
3763: ,x_message_list OUT NOCOPY VARCHAR2
3764: ,x_return_status OUT NOCOPY VARCHAR2
3765: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3766: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
3767: IS
3768: l_api_name CONSTANT VARCHAR2 (30) := 'TERMINATE_BATCH';
3769: setup_failure EXCEPTION;
3770: batch_terminate_failure EXCEPTION;

Line 3914: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

3910: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
3911: ,x_message_count OUT NOCOPY NUMBER
3912: ,x_message_list OUT NOCOPY VARCHAR2
3913: ,x_return_status OUT NOCOPY VARCHAR2
3914: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3915: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
3916: ,p_create_resv_pend_lots IN NUMBER)
3917: IS
3918: l_api_name CONSTANT VARCHAR2 (30) := 'UNRELEASE_BATCH';

Line 3915: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

3911: ,x_message_count OUT NOCOPY NUMBER
3912: ,x_message_list OUT NOCOPY VARCHAR2
3913: ,x_return_status OUT NOCOPY VARCHAR2
3914: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3915: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
3916: ,p_create_resv_pend_lots IN NUMBER)
3917: IS
3918: l_api_name CONSTANT VARCHAR2 (30) := 'UNRELEASE_BATCH';
3919: setup_failure EXCEPTION;

Line 4021: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

4017: ,x_message_count OUT NOCOPY NUMBER
4018: ,x_message_list OUT NOCOPY VARCHAR2
4019: ,x_return_status OUT NOCOPY VARCHAR2
4020: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
4021: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
4022: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
4023: ,p_create_resv_pend_lots IN NUMBER)
4024: IS
4025: l_api_name CONSTANT VARCHAR2 (30) := 'UNRELEASE_STEP';

Line 4211: p_batch_rec IN gme_batch_header%ROWTYPE) IS

4207: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4208: x_message_count OUT NOCOPY NUMBER,
4209: x_message_list OUT NOCOPY VARCHAR2,
4210: x_return_status OUT NOCOPY VARCHAR2,
4211: p_batch_rec IN gme_batch_header%ROWTYPE) IS
4212:
4213: l_api_name CONSTANT VARCHAR2 (30) := 'AUTO_DETAIL_BATCH';
4214:
4215: