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
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
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
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:
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
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
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)
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
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
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
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
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)
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
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
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;
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
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
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
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';
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
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
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';
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
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;
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';
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:
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:
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';
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;
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';
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;
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;
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
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:
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';
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;
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';
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:
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
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
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;
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;
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;
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;
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;
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';
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;
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';
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: