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.GME_API_PUB dependencies on GME_BATCH_HEADER

Line 153: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

149: ,x_message_count OUT NOCOPY NUMBER
150: ,x_message_list OUT NOCOPY VARCHAR2
151: ,x_return_status OUT NOCOPY VARCHAR2
152: ,p_org_code IN VARCHAR2 := NULL
153: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
154: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
155: ,p_batch_size IN NUMBER := NULL
156: ,p_batch_size_uom IN VARCHAR2 := NULL
157: ,p_creation_mode IN VARCHAR2

Line 154: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

150: ,x_message_list OUT NOCOPY VARCHAR2
151: ,x_return_status OUT NOCOPY VARCHAR2
152: ,p_org_code IN VARCHAR2 := NULL
153: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
154: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
155: ,p_batch_size IN NUMBER := NULL
156: ,p_batch_size_uom IN VARCHAR2 := NULL
157: ,p_creation_mode IN VARCHAR2
158: ,p_recipe_id IN NUMBER := NULL

Line 171: l_batch_header gme_batch_header%ROWTYPE;

167: ,p_use_least_cost_validity_rule IN VARCHAR2 := fnd_api.g_false
168: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab)
169: IS
170: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_BATCH';
171: l_batch_header gme_batch_header%ROWTYPE;
172: l_return_status VARCHAR2 (1);
173: l_object_type VARCHAR2 (10);
174: l_total_input NUMBER;
175: l_total_output NUMBER;

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

596: ,x_message_count OUT NOCOPY NUMBER
597: ,x_message_list OUT NOCOPY VARCHAR2
598: ,x_return_status OUT NOCOPY VARCHAR2
599: ,p_material_detail_rec IN gme_material_details%ROWTYPE
600: ,p_batch_header_rec IN gme_batch_header%ROWTYPE --Bug#6738476
601: ,p_org_code IN VARCHAR2
602: ,p_batch_no IN VARCHAR2 DEFAULT NULL
603: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
604: ,p_validity_rule_id IN NUMBER

Line 612: l_batch_header gme_batch_header%ROWTYPE;

608: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab)
609: IS
610: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_PHANTOM';
611: phantom_creation_failure EXCEPTION;
612: l_batch_header gme_batch_header%ROWTYPE;
613: l_material_detail gme_material_details%ROWTYPE;
614: BEGIN
615: IF (g_debug <> -1) THEN
616: gme_debug.log_initialize ('CreatePhantom');

Line 731: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

727: p_api_version IN NUMBER
728: ,p_validation_level IN NUMBER
729: ,p_init_msg_list IN VARCHAR2
730: ,p_commit IN VARCHAR2
731: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
732: ,p_org_code IN VARCHAR2
733: ,p_ignore_exception IN VARCHAR2
734: ,p_scale_factor IN NUMBER
735: ,p_primaries IN VARCHAR2

Line 744: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)

740: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
741: ,x_message_count OUT NOCOPY NUMBER
742: ,x_message_list OUT NOCOPY VARCHAR2
743: ,x_return_status OUT NOCOPY VARCHAR2
744: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
745: IS
746: l_api_name CONSTANT VARCHAR2 (30) := 'SCALE_BATCH';
747: scale_batch_failed EXCEPTION;
748: l_batch_header_rec gme_batch_header%ROWTYPE;

Line 748: l_batch_header_rec gme_batch_header%ROWTYPE;

744: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
745: IS
746: l_api_name CONSTANT VARCHAR2 (30) := 'SCALE_BATCH';
747: scale_batch_failed EXCEPTION;
748: l_batch_header_rec gme_batch_header%ROWTYPE;
749: l_return_status VARCHAR2(1);
750:
751: BEGIN
752: IF (g_debug <> -1) THEN

Line 903: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

899: p_api_version IN NUMBER := 2.0
900: ,p_validation_level IN NUMBER
901: ,p_init_msg_list IN VARCHAR2
902: ,p_commit IN VARCHAR2
903: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
904: ,p_org_code IN VARCHAR2
905: ,p_scale_factor IN NUMBER
906: ,x_message_count OUT NOCOPY NUMBER
907: ,x_message_list OUT NOCOPY VARCHAR2

Line 912: l_batch_header_rec gme_batch_header%ROWTYPE;

908: ,x_return_status OUT NOCOPY VARCHAR2)
909: IS
910: l_api_name CONSTANT VARCHAR2 (30) := 'THEORETICAL_YIELD_BATCH';
911: theoretical_yield_failed EXCEPTION;
912: l_batch_header_rec gme_batch_header%ROWTYPE;
913: l_return_status VARCHAR2(1);
914: BEGIN
915: IF (g_debug <> -1) THEN
916: gme_debug.log_initialize ('TheoreticalYieldBatch');

Line 1040: l_batch_header gme_batch_header%ROWTYPE;

1036: ,x_return_status OUT NOCOPY VARCHAR2)
1037: IS
1038: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_ACTUAL_RSRC_USAGE';
1039:
1040: l_batch_header gme_batch_header%ROWTYPE;
1041: l_poc_trans_id NUMBER;
1042: l_line_id NUMBER;
1043: l_inv_trans_count NUMBER;
1044: l_rsrc_trans_count NUMBER;

Line 1146: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header

1142:
1143: /* In order to get the poc_trans_id */
1144: /* Lets now load the transactions associated with the batch into the temporary table */
1145: IF p_commit = fnd_api.g_true THEN
1146: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header
1147: ,l_batch_header) ) THEN
1148: RAISE fnd_api.g_exc_error;
1149: END IF;
1150: gme_trans_engine_util.load_rsrc_trans

Line 1221: l_batch_header gme_batch_header%ROWTYPE;

1217: ,x_message_list OUT NOCOPY VARCHAR2
1218: ,x_return_status OUT NOCOPY VARCHAR2)
1219: IS
1220: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_INCR_ACTUAL_RSRC_TXN';
1221: l_batch_header gme_batch_header%ROWTYPE;
1222: l_rsrc_txn_rec gme_resource_txns%ROWTYPE;
1223: BEGIN
1224: /* Set the savepoint */
1225: SAVEPOINT insert_incr_actual_rsrc_txn;

Line 1360: l_batch_header gme_batch_header%ROWTYPE;

1356: ,x_message_list OUT NOCOPY VARCHAR2
1357: ,x_return_status OUT NOCOPY VARCHAR2)
1358: IS
1359: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_TIMED_ACTUAL_RSRC_TXN';
1360: l_batch_header gme_batch_header%ROWTYPE;
1361: l_rsrc_txn_rec gme_resource_txns%ROWTYPE;
1362:
1363: BEGIN
1364: /* Set the savepoint */

Line 1508: l_batch_header gme_batch_header%ROWTYPE;

1504: ,x_message_list OUT NOCOPY VARCHAR2
1505: ,x_return_status OUT NOCOPY VARCHAR2)
1506: IS
1507: l_api_name CONSTANT VARCHAR2(30) := 'START_CMPLT_ACTUAL_RSRC_TXN';
1508: l_batch_header gme_batch_header%ROWTYPE;
1509: l_rsrc_txn_rec gme_resource_txns%ROWTYPE;
1510:
1511: BEGIN
1512: /* Set the savepoint */

Line 1641: l_batch_header gme_batch_header%ROWTYPE;

1637: ,x_message_list OUT NOCOPY VARCHAR2
1638: ,x_return_status OUT NOCOPY VARCHAR2)
1639: IS
1640: l_api_name CONSTANT VARCHAR2(30) := 'END_CMPLT_ACTUAL_RSRC_TXN';
1641: l_batch_header gme_batch_header%ROWTYPE;
1642: l_rsrc_txn_rec gme_resource_txns%ROWTYPE;
1643: BEGIN
1644: /* Set the savepoint */
1645: SAVEPOINT end_cmplt_actual_rsrc_txn;

Line 1753: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

1749: p_api_version IN NUMBER := 2.0
1750: ,p_validation_level IN NUMBER
1751: ,p_init_msg_list IN VARCHAR2
1752: ,p_commit IN VARCHAR2
1753: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1754: ,p_use_workday_cal IN VARCHAR2
1755: ,p_contiguity_override IN VARCHAR2
1756: ,p_org_code IN VARCHAR2
1757: ,x_message_count OUT NOCOPY NUMBER

Line 1760: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)

1756: ,p_org_code IN VARCHAR2
1757: ,x_message_count OUT NOCOPY NUMBER
1758: ,x_message_list OUT NOCOPY VARCHAR2
1759: ,x_return_status OUT NOCOPY VARCHAR2
1760: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
1761: IS
1762: l_api_name CONSTANT VARCHAR2 (30) := 'RESCHEDULE_BATCH';
1763: reschedule_batch_failed EXCEPTION;
1764: batch_save_failed EXCEPTION;

Line 1767: l_batch_header_rec gme_batch_header%ROWTYPE;

1763: reschedule_batch_failed EXCEPTION;
1764: batch_save_failed EXCEPTION;
1765: l_return_status VARCHAR2 (1);
1766: l_use VARCHAR2 (1);
1767: l_batch_header_rec gme_batch_header%ROWTYPE;
1768: BEGIN
1769: IF g_debug <> -1 THEN
1770: gme_debug.log_initialize ('RescheduleBatch');
1771: END IF;

Line 2037: l_batch_header_rec gme_batch_header%ROWTYPE;

2033: l_api_name CONSTANT VARCHAR2 (30) := 'RESCHEDULE_STEP';
2034: l_diff NUMBER := 0;
2035: l_diff_cmplt NUMBER := 0;
2036: reschedule_step_failed EXCEPTION;
2037: l_batch_header_rec gme_batch_header%ROWTYPE;
2038: l_batch_step_rec gme_batch_steps%ROWTYPE;
2039: l_use VARCHAR2 (1);
2040: l_return_status VARCHAR2 (1);
2041: l_reschedule_preceding VARCHAR2 (1);

Line 2346: ,p_batch_rec IN gme_batch_header%ROWTYPE

2342: ,p_validation_level IN NUMBER
2343: := gme_common_pvt.g_max_errors
2344: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2345: ,p_commit IN VARCHAR2 := fnd_api.g_false
2346: ,p_batch_rec IN gme_batch_header%ROWTYPE
2347: ,p_org_code IN VARCHAR2
2348: ,x_message_count OUT NOCOPY NUMBER
2349: ,x_message_list OUT NOCOPY VARCHAR2
2350: ,x_return_status OUT NOCOPY VARCHAR2)

Line 2353: l_batch_header_rec gme_batch_header%ROWTYPE;

2349: ,x_message_list OUT NOCOPY VARCHAR2
2350: ,x_return_status OUT NOCOPY VARCHAR2)
2351: IS
2352: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_BATCH_RESERVATIONS';
2353: l_batch_header_rec gme_batch_header%ROWTYPE;
2354: BEGIN
2355: IF g_debug <= gme_debug.g_log_procedure THEN
2356: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
2357: || l_api_name);

Line 2471: l_batch_header_rec gme_batch_header%ROWTYPE;

2467: l_api_name CONSTANT VARCHAR2 (30)
2468: := 'CREATE_LINE_RESERVATIONS';
2469: l_material_details_rec gme_material_details%ROWTYPE;
2470: l_material_details_rec_out gme_material_details%ROWTYPE;
2471: l_batch_header_rec gme_batch_header%ROWTYPE;
2472: BEGIN
2473: IF g_debug <= gme_debug.g_log_procedure THEN
2474: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
2475: || l_api_name);

Line 2953: l_batch_header_rec gme_batch_header%rowtype;

2949: ,x_return_status OUT NOCOPY VARCHAR2
2950: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE)
2951: IS
2952: l_api_name CONSTANT VARCHAR2 (30) := 'DELETE_STEP';
2953: l_batch_header_rec gme_batch_header%rowtype;
2954: delete_step_failed EXCEPTION;
2955: BEGIN
2956: /* Set the return status to success initially */
2957: x_return_status := fnd_api.g_ret_sts_success;

Line 3050: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

3046: ,p_org_code IN VARCHAR2
3047: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
3048: ,p_oprn_no IN VARCHAR2
3049: ,p_oprn_vers IN NUMBER
3050: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3051: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
3052: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
3053: ,x_message_count OUT NOCOPY NUMBER
3054: ,x_message_list OUT NOCOPY VARCHAR2

Line 3059: l_batch_header_rec gme_batch_header%ROWTYPE;

3055: ,x_return_status OUT NOCOPY VARCHAR2)
3056: IS
3057: l_api_name CONSTANT VARCHAR2 (30) := 'INSERT_STEP';
3058: insert_step_failed EXCEPTION;
3059: l_batch_header_rec gme_batch_header%ROWTYPE;
3060: l_oprn_no VARCHAR2 (16);
3061: /* The operation number for the step */
3062: l_oprn_vers NUMBER;
3063: /* The operation version for the step */

Line 3118: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec

3114:
3115: IF (p_batch_step_rec.batch_id IS NOT NULL) THEN
3116: l_batch_header_rec.batch_id := p_batch_step_rec.batch_id;
3117:
3118: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec
3119: ,l_batch_header_rec) ) THEN
3120: RAISE fnd_api.g_exc_error;
3121: END IF;
3122: ELSE

Line 3123: IF NOT (gme_batch_header_dbl.fetch_row (p_batch_header_rec

3119: ,l_batch_header_rec) ) THEN
3120: RAISE fnd_api.g_exc_error;
3121: END IF;
3122: ELSE
3123: IF NOT (gme_batch_header_dbl.fetch_row (p_batch_header_rec
3124: ,l_batch_header_rec) ) THEN
3125: RAISE fnd_api.g_exc_error;
3126: END IF;
3127: END IF;

Line 3296: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

3292: p_api_version IN NUMBER := 2.0
3293: ,p_validation_level IN NUMBER := gme_common_pvt.g_max_errors
3294: ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
3295: ,p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
3296: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3297: ,p_material_detail_rec IN gme_material_details%ROWTYPE
3298: ,p_locator_code IN VARCHAR2
3299: ,p_org_code IN VARCHAR2
3300: ,p_batchstep_no IN NUMBER := NULL

Line 3316: l_batch_header_rec gme_batch_header%ROWTYPE;

3312: AND subinventory_code = v_sub_inv
3313: AND concatenated_segments = p_locator_code;
3314:
3315: l_api_name CONSTANT VARCHAR2 (30) := 'INSERT_MATERIAL_LINE';
3316: l_batch_header_rec gme_batch_header%ROWTYPE;
3317: l_return_status VARCHAR2(1);
3318: l_batch_step_rec gme_batch_steps%ROWTYPE;
3319: l_material_detail_rec gme_material_details%ROWTYPE;
3320: p_trans_id NUMBER;

Line 3522: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

3518: p_api_version IN NUMBER := 2.0
3519: ,p_validation_level IN NUMBER := gme_common_pvt.g_max_errors
3520: ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
3521: ,p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
3522: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3523: ,p_material_detail_rec IN gme_material_details%ROWTYPE
3524: ,p_locator_code IN VARCHAR2
3525: ,p_org_code IN VARCHAR2
3526: ,p_scale_phantom IN VARCHAR2 DEFAULT fnd_api.g_false

Line 3547: l_batch_header_rec gme_batch_header%ROWTYPE;

3543: FROM gme_batch_step_items
3544: WHERE material_detail_id = v_mat_id;
3545:
3546: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_MATERIAL_LINE';
3547: l_batch_header_rec gme_batch_header%ROWTYPE;
3548: l_return_status VARCHAR2(1);
3549: l_batch_step_rec gme_batch_steps%ROWTYPE;
3550: l_material_detail_rec gme_material_details%ROWTYPE;
3551: l_stored_material_detail_rec gme_material_details%ROWTYPE;

Line 3558: x_batch_header_rec gme_batch_header%ROWTYPE;

3554: l_locator_id NUMBER;
3555: l_batchstep_id NUMBER;
3556:
3557: x_transacted VARCHAR2(30);
3558: x_batch_header_rec gme_batch_header%ROWTYPE;
3559:
3560:
3561: BEGIN
3562:

Line 3770: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

3766: p_api_version IN NUMBER := 2.0
3767: ,p_validation_level IN NUMBER := gme_common_pvt.g_max_errors
3768: ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
3769: ,p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
3770: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3771: ,p_material_detail_rec IN gme_material_details%ROWTYPE
3772: ,p_org_code IN VARCHAR2
3773: ,x_message_count OUT NOCOPY NUMBER
3774: ,x_message_list OUT NOCOPY VARCHAR2

Line 3783: l_batch_header_rec gme_batch_header%ROWTYPE;

3779: FROM gme_batch_step_items
3780: WHERE material_detail_id = v_mat_id;
3781:
3782: l_api_name CONSTANT VARCHAR2 (30) := 'DELETE_MATERIAL_LINE';
3783: l_batch_header_rec gme_batch_header%ROWTYPE;
3784: l_return_status VARCHAR2(1);
3785: l_batch_step_rec gme_batch_steps%ROWTYPE;
3786: l_material_detail_rec gme_material_details%ROWTYPE;
3787:

Line 3790: x_batch_header_rec gme_batch_header%ROWTYPE;

3786: l_material_detail_rec gme_material_details%ROWTYPE;
3787:
3788: l_batchstep_id NUMBER;
3789: x_transacted VARCHAR2(30);
3790: x_batch_header_rec gme_batch_header%ROWTYPE;
3791:
3792: BEGIN
3793: IF (g_debug <> -1) THEN
3794: gme_debug.log_initialize ('DELETE_MATERIAL_LINE');

Line 3928: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

3924: ,x_message_count OUT NOCOPY NUMBER
3925: ,x_message_list OUT NOCOPY VARCHAR2
3926: ,x_return_status OUT NOCOPY VARCHAR2
3927: ,p_org_code IN VARCHAR2
3928: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3929: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)IS
3930:
3931: l_api_name CONSTANT VARCHAR2 (30) := 'REVERT_BATCH';
3932: l_batch_header_rec gme_batch_header%ROWTYPE;

Line 3929: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)IS

3925: ,x_message_list OUT NOCOPY VARCHAR2
3926: ,x_return_status OUT NOCOPY VARCHAR2
3927: ,p_org_code IN VARCHAR2
3928: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3929: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)IS
3930:
3931: l_api_name CONSTANT VARCHAR2 (30) := 'REVERT_BATCH';
3932: l_batch_header_rec gme_batch_header%ROWTYPE;
3933: batch_revert_failure EXCEPTION;

Line 3932: l_batch_header_rec gme_batch_header%ROWTYPE;

3928: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3929: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)IS
3930:
3931: l_api_name CONSTANT VARCHAR2 (30) := 'REVERT_BATCH';
3932: l_batch_header_rec gme_batch_header%ROWTYPE;
3933: batch_revert_failure EXCEPTION;
3934: BEGIN
3935: IF (g_debug <> -1) THEN
3936: gme_debug.log_initialize('RevertBatch');

Line 4094: l_batch_header_rec gme_batch_header%rowtype;

4090: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)IS
4091:
4092: l_api_name CONSTANT VARCHAR2 (30) := 'REVERT_STEP';
4093: l_batch_step_rec gme_batch_steps%ROWTYPE;
4094: l_batch_header_rec gme_batch_header%rowtype;
4095:
4096: step_revert_failure EXCEPTION;
4097: BEGIN
4098: IF (g_debug <> -1) THEN

Line 4224: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

4220: ,p_commit IN VARCHAR2
4221: ,x_message_count OUT NOCOPY NUMBER
4222: ,x_message_list OUT NOCOPY VARCHAR2
4223: ,x_return_status OUT NOCOPY VARCHAR2
4224: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
4225: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
4226: ,p_org_code IN VARCHAR2)
4227: IS
4228: l_api_name CONSTANT VARCHAR2 (30) := 'CLOSE_BATCH';

Line 4225: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

4221: ,x_message_count OUT NOCOPY NUMBER
4222: ,x_message_list OUT NOCOPY VARCHAR2
4223: ,x_return_status OUT NOCOPY VARCHAR2
4224: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
4225: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
4226: ,p_org_code IN VARCHAR2)
4227: IS
4228: l_api_name CONSTANT VARCHAR2 (30) := 'CLOSE_BATCH';
4229: l_batch_header_rec gme_batch_header%ROWTYPE;

Line 4229: l_batch_header_rec gme_batch_header%ROWTYPE;

4225: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
4226: ,p_org_code IN VARCHAR2)
4227: IS
4228: l_api_name CONSTANT VARCHAR2 (30) := 'CLOSE_BATCH';
4229: l_batch_header_rec gme_batch_header%ROWTYPE;
4230:
4231: batch_close_failure EXCEPTION;
4232: BEGIN
4233: IF g_debug <= gme_debug.g_log_procedure THEN

Line 4384: l_batch_header_rec gme_batch_header%ROWTYPE;

4380: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)
4381: IS
4382: l_api_name CONSTANT VARCHAR2 (30) := 'CLOSE_STEP';
4383:
4384: l_batch_header_rec gme_batch_header%ROWTYPE;
4385: l_batch_step_rec gme_batch_steps%ROWTYPE;
4386:
4387: step_close_failed EXCEPTION;
4388: BEGIN

Line 4522: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

4518: ,p_commit IN VARCHAR2
4519: ,x_message_count OUT NOCOPY NUMBER
4520: ,x_message_list OUT NOCOPY VARCHAR2
4521: ,x_return_status OUT NOCOPY VARCHAR2
4522: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
4523: ,p_org_code IN VARCHAR2
4524: ,p_reopen_steps IN VARCHAR2 := fnd_api.g_false
4525: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
4526: IS

Line 4525: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)

4521: ,x_return_status OUT NOCOPY VARCHAR2
4522: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
4523: ,p_org_code IN VARCHAR2
4524: ,p_reopen_steps IN VARCHAR2 := fnd_api.g_false
4525: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
4526: IS
4527: l_api_name CONSTANT VARCHAR2 (30) := 'REOPEN_BATCH';
4528: l_batch_header_rec gme_batch_header%ROWTYPE;
4529: batch_reopen_failure EXCEPTION;

Line 4528: l_batch_header_rec gme_batch_header%ROWTYPE;

4524: ,p_reopen_steps IN VARCHAR2 := fnd_api.g_false
4525: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
4526: IS
4527: l_api_name CONSTANT VARCHAR2 (30) := 'REOPEN_BATCH';
4528: l_batch_header_rec gme_batch_header%ROWTYPE;
4529: batch_reopen_failure EXCEPTION;
4530: BEGIN
4531: IF g_debug <= gme_debug.g_log_procedure THEN
4532: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

Line 4628: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

4624: ,x_message_count OUT NOCOPY NUMBER
4625: ,x_message_list OUT NOCOPY VARCHAR2
4626: ,x_return_status OUT NOCOPY VARCHAR2
4627: ,p_org_code IN VARCHAR2
4628: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
4629: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
4630: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)
4631: IS
4632: l_api_name CONSTANT VARCHAR2 (30):= 'REOPEN_STEP';

Line 4633: l_batch_header_rec gme_batch_header%ROWTYPE;

4629: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
4630: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)
4631: IS
4632: l_api_name CONSTANT VARCHAR2 (30):= 'REOPEN_STEP';
4633: l_batch_header_rec gme_batch_header%ROWTYPE;
4634: l_batch_step_rec gme_batch_steps%ROWTYPE;
4635: step_reopen_failure EXCEPTION;
4636: BEGIN
4637: IF g_debug <= gme_debug.g_log_procedure THEN

Line 4733: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

4729: ,p_commit IN VARCHAR2 := fnd_api.g_false
4730: ,x_message_count OUT NOCOPY NUMBER
4731: ,x_message_list OUT NOCOPY VARCHAR2
4732: ,x_return_status OUT NOCOPY VARCHAR2
4733: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
4734: ,p_org_code IN VARCHAR2
4735: ,p_material_detail_rec IN gme_material_details%ROWTYPE
4736: ,p_qty IN NUMBER
4737: ,p_qty_type IN NUMBER

Line 4745: l_batch_header_rec gme_batch_header%ROWTYPE;

4741: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab)
4742: IS
4743: l_api_name CONSTANT VARCHAR2 (30) := 'INCREMENTAL_BACKFLUSH';
4744: l_material_detail_rec gme_material_details%ROWTYPE;
4745: l_batch_header_rec gme_batch_header%ROWTYPE;
4746: l_exception_material_tbl gme_common_pvt.exceptions_tab;
4747:
4748: error_incr_backflush EXCEPTION;
4749: BEGIN

Line 4932: l_batch_header_rec gme_batch_header%ROWTYPE;

4928: l_mmti_rec mtl_transactions_interface%ROWTYPE;
4929: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
4930: l_mat_dtl_rec gme_material_details%ROWTYPE;
4931: l_mat_dtl_rec_out gme_material_details%ROWTYPE;
4932: l_batch_header_rec gme_batch_header%ROWTYPE;
4933: l_item_rec mtl_system_items_b%ROWTYPE;
4934: l_lot_rec mtl_lot_numbers%ROWTYPE;
4935: l_parent_gen_lot VARCHAR2 (2000) DEFAULT NULL;
4936: l_gen_lot VARCHAR2 (80) DEFAULT NULL;

Line 5757: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

5753: ,p_validation_level IN NUMBER
5754: := gme_common_pvt.g_max_errors
5755: ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
5756: ,p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
5757: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
5758: ,p_validity_rule_id IN NUMBER
5759: ,p_org_code IN VARCHAR2
5760: ,p_use_workday_cal IN VARCHAR2 DEFAULT fnd_api.g_false
5761: ,p_contiguity_override IN VARCHAR2 DEFAULT fnd_api.g_false

Line 5765: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)

5761: ,p_contiguity_override IN VARCHAR2 DEFAULT fnd_api.g_false
5762: ,x_message_count OUT NOCOPY NUMBER
5763: ,x_message_list OUT NOCOPY VARCHAR2
5764: ,x_return_status OUT NOCOPY VARCHAR2
5765: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
5766: IS
5767: l_api_name CONSTANT VARCHAR2 (30) := 'REROUTE_BATCH';
5768: l_batch_header_rec gme_batch_header%ROWTYPE;
5769:

Line 5768: l_batch_header_rec gme_batch_header%ROWTYPE;

5764: ,x_return_status OUT NOCOPY VARCHAR2
5765: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
5766: IS
5767: l_api_name CONSTANT VARCHAR2 (30) := 'REROUTE_BATCH';
5768: l_batch_header_rec gme_batch_header%ROWTYPE;
5769:
5770: reroute_batch_failed EXCEPTION;
5771: BEGIN
5772: IF (g_debug <> -1) THEN

Line 5955: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

5951: ,x_message_count OUT NOCOPY NUMBER
5952: ,x_message_list OUT NOCOPY VARCHAR2
5953: ,x_return_status OUT NOCOPY VARCHAR2
5954: ,p_org_code IN VARCHAR2
5955: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
5956: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
5957: IS
5958: l_api_name CONSTANT VARCHAR2 (30) := 'CANCEL_BATCH';
5959: l_batch_header_rec gme_batch_header%ROWTYPE;

Line 5956: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)

5952: ,x_message_list OUT NOCOPY VARCHAR2
5953: ,x_return_status OUT NOCOPY VARCHAR2
5954: ,p_org_code IN VARCHAR2
5955: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
5956: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
5957: IS
5958: l_api_name CONSTANT VARCHAR2 (30) := 'CANCEL_BATCH';
5959: l_batch_header_rec gme_batch_header%ROWTYPE;
5960:

Line 5959: l_batch_header_rec gme_batch_header%ROWTYPE;

5955: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
5956: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
5957: IS
5958: l_api_name CONSTANT VARCHAR2 (30) := 'CANCEL_BATCH';
5959: l_batch_header_rec gme_batch_header%ROWTYPE;
5960:
5961: batch_cancel_failure EXCEPTION;
5962: BEGIN
5963: IF (g_debug <> -1) THEN

Line 6120: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

6116: ,x_message_list OUT NOCOPY VARCHAR2
6117: ,x_return_status OUT NOCOPY VARCHAR2
6118: ,p_org_code IN VARCHAR2
6119: ,p_reason_name IN VARCHAR2
6120: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
6121: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
6122: IS
6123: CURSOR cur_val_reason_id (v_reason_id NUMBER)
6124: IS

Line 6121: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)

6117: ,x_return_status OUT NOCOPY VARCHAR2
6118: ,p_org_code IN VARCHAR2
6119: ,p_reason_name IN VARCHAR2
6120: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
6121: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
6122: IS
6123: CURSOR cur_val_reason_id (v_reason_id NUMBER)
6124: IS
6125: SELECT 1

Line 6139: l_batch_header_rec gme_batch_header%ROWTYPE;

6135: AND reason_name = v_reason_name;
6136:
6137: i NUMBER;
6138: l_api_name CONSTANT VARCHAR2 (30) := 'TERMINATE_BATCH';
6139: l_batch_header_rec gme_batch_header%ROWTYPE;
6140: l_reason_valid NUMBER;
6141:
6142: batch_terminate_failure EXCEPTION;
6143: BEGIN

Line 6561: l_batch_header gme_batch_header%ROWTYPE;

6557: ,x_return_status OUT NOCOPY VARCHAR2)
6558: IS
6559: l_api_name CONSTANT VARCHAR2 (30)
6560: := 'INSERT_BATCHSTEP_RESOURCE';
6561: l_batch_header gme_batch_header%ROWTYPE;
6562: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;
6563: l_batchstep_resource_rec_out gme_batch_step_resources%ROWTYPE;
6564: l_table NUMBER;
6565: l_step_status NUMBER;

Line 6592: FROM gme_batch_header a, gme_batch_step_activities b

6588:
6589: CURSOR cur_validate_batch_type (v_activity_id NUMBER)
6590: IS
6591: SELECT 1
6592: FROM gme_batch_header a, gme_batch_step_activities b
6593: WHERE a.batch_id = b.batch_id
6594: AND b.batchstep_activity_id = v_activity_id
6595: AND a.batch_type = 10;
6596:

Line 7007: l_batch_header gme_batch_header%ROWTYPE;

7003: ,x_return_status OUT NOCOPY VARCHAR2)
7004: IS
7005: l_api_name CONSTANT VARCHAR2 (30)
7006: := 'UPDATE_BATCHSTEP_RESOURCE';
7007: l_batch_header gme_batch_header%ROWTYPE;
7008: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;
7009: l_batchstep_resource_rec_out gme_batch_step_resources%ROWTYPE;
7010: l_cons_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;
7011: l_return_status VARCHAR2 (2);

Line 7316: ,gme_batch_header c

7312: SELECT c.organization_id, a.step_status, a.batch_id, a.batchstep_id
7313: ,b.batchstep_activity_id, c.batch_status
7314: FROM gme_batch_steps a
7315: ,gme_batch_step_resources b
7316: ,gme_batch_header c
7317: WHERE a.batch_id = b.batch_id
7318: AND a.batchstep_id = b.batchstep_id
7319: AND b.batchstep_resource_id = v_batchstep_rsrc_id
7320: AND a.batch_id = c.batch_id;

Line 7325: FROM gme_batch_header a, gme_batch_step_resources b

7321:
7322: CURSOR cur_validate_batch_type (v_rsrc_id NUMBER)
7323: IS
7324: SELECT 1
7325: FROM gme_batch_header a, gme_batch_step_resources b
7326: WHERE a.batch_id = b.batch_id
7327: AND b.batchstep_resource_id = v_rsrc_id
7328: AND a.batch_type = 10;
7329:

Line 7623: l_batch_header_rec gme_batch_header%ROWTYPE;

7619: l_api_name CONSTANT VARCHAR2 (30) := 'AUTO_DETAIL_LINE';
7620: l_material_details_rec gme_material_details%ROWTYPE;
7621: l_material_details_rec_out gme_material_details%ROWTYPE;
7622: l_reservation_rec mtl_reservations%ROWTYPE;
7623: l_batch_header_rec gme_batch_header%ROWTYPE;
7624: l_valid_status VARCHAR2(1);
7625:
7626: CURSOR cur_fetch_reservation (v_reservation_id NUMBER)
7627: IS

Line 7799: ,p_batch_rec IN GME_BATCH_HEADER%ROWTYPE) IS

7795: ,x_message_count OUT NOCOPY NUMBER
7796: ,x_message_list OUT NOCOPY VARCHAR2
7797: ,x_return_status OUT NOCOPY VARCHAR2
7798: ,p_org_code IN VARCHAR2
7799: ,p_batch_rec IN GME_BATCH_HEADER%ROWTYPE) IS
7800:
7801: l_api_name CONSTANT VARCHAR2 (30) := 'AUTO_DETAIL_BATCH';
7802: l_batch_rec GME_BATCH_HEADER%ROWTYPE;
7803: l_batch_header_rec GME_BATCH_HEADER%ROWTYPE;

Line 7802: l_batch_rec GME_BATCH_HEADER%ROWTYPE;

7798: ,p_org_code IN VARCHAR2
7799: ,p_batch_rec IN GME_BATCH_HEADER%ROWTYPE) IS
7800:
7801: l_api_name CONSTANT VARCHAR2 (30) := 'AUTO_DETAIL_BATCH';
7802: l_batch_rec GME_BATCH_HEADER%ROWTYPE;
7803: l_batch_header_rec GME_BATCH_HEADER%ROWTYPE;
7804:
7805: auto_detail_error EXCEPTION;
7806: BEGIN

Line 7803: l_batch_header_rec GME_BATCH_HEADER%ROWTYPE;

7799: ,p_batch_rec IN GME_BATCH_HEADER%ROWTYPE) IS
7800:
7801: l_api_name CONSTANT VARCHAR2 (30) := 'AUTO_DETAIL_BATCH';
7802: l_batch_rec GME_BATCH_HEADER%ROWTYPE;
7803: l_batch_header_rec GME_BATCH_HEADER%ROWTYPE;
7804:
7805: auto_detail_error EXCEPTION;
7806: BEGIN
7807: IF (g_debug <> -1) THEN

Line 7873: IF (NOT gme_batch_header_dbl.fetch_row (l_batch_rec,

7869: IF l_batch_rec.batch_type is NULL THEN
7870: l_batch_rec.batch_type := gme_common_pvt.g_doc_type_batch;
7871: END IF;
7872:
7873: IF (NOT gme_batch_header_dbl.fetch_row (l_batch_rec,
7874: l_batch_header_rec) ) THEN
7875: RAISE fnd_api.g_exc_error;
7876: END IF;
7877:

Line 8402: p_batch_header IN gme_batch_header%ROWTYPE,

8398: x_message_list OUT NOCOPY VARCHAR2,
8399: p_enforce_vldt_check IN VARCHAR2 := fnd_api.g_true,
8400: x_return_status OUT NOCOPY VARCHAR2,
8401: p_org_code IN VARCHAR2 := NULL,
8402: p_batch_header IN gme_batch_header%ROWTYPE,
8403: x_batch_header OUT NOCOPY gme_batch_header%ROWTYPE,
8404: p_batch_size IN NUMBER,
8405: p_num_batches IN NUMBER,
8406: p_validity_rule_id IN NUMBER,

Line 8403: x_batch_header OUT NOCOPY gme_batch_header%ROWTYPE,

8399: p_enforce_vldt_check IN VARCHAR2 := fnd_api.g_true,
8400: x_return_status OUT NOCOPY VARCHAR2,
8401: p_org_code IN VARCHAR2 := NULL,
8402: p_batch_header IN gme_batch_header%ROWTYPE,
8403: x_batch_header OUT NOCOPY gme_batch_header%ROWTYPE,
8404: p_batch_size IN NUMBER,
8405: p_num_batches IN NUMBER,
8406: p_validity_rule_id IN NUMBER,
8407: p_validity_rule_tab IN gme_common_pvt.recipe_validity_rule_tab,

Line 8411: p_plan_start_date IN gme_batch_header.plan_start_date%TYPE,

8407: p_validity_rule_tab IN gme_common_pvt.recipe_validity_rule_tab,
8408: p_leadtime IN NUMBER DEFAULT 0,
8409: p_batch_offset IN NUMBER DEFAULT 0,
8410: p_offset_type IN NUMBER DEFAULT 0,
8411: p_plan_start_date IN gme_batch_header.plan_start_date%TYPE,
8412: p_plan_cmplt_date IN gme_batch_header.plan_cmplt_date%TYPE,
8413: p_use_shop_cal IN VARCHAR2 := fnd_api.g_false,
8414: p_contiguity_override IN VARCHAR2 := fnd_api.g_true,
8415: p_use_for_all IN VARCHAR2 := fnd_api.g_true

Line 8412: p_plan_cmplt_date IN gme_batch_header.plan_cmplt_date%TYPE,

8408: p_leadtime IN NUMBER DEFAULT 0,
8409: p_batch_offset IN NUMBER DEFAULT 0,
8410: p_offset_type IN NUMBER DEFAULT 0,
8411: p_plan_start_date IN gme_batch_header.plan_start_date%TYPE,
8412: p_plan_cmplt_date IN gme_batch_header.plan_cmplt_date%TYPE,
8413: p_use_shop_cal IN VARCHAR2 := fnd_api.g_false,
8414: p_contiguity_override IN VARCHAR2 := fnd_api.g_true,
8415: p_use_for_all IN VARCHAR2 := fnd_api.g_true
8416: ) IS

Line 8418: l_batch_header gme_batch_header%ROWTYPE;

8414: p_contiguity_override IN VARCHAR2 := fnd_api.g_true,
8415: p_use_for_all IN VARCHAR2 := fnd_api.g_true
8416: ) IS
8417: l_api_name CONSTANT VARCHAR2 (30) := 'CONVERT_FPO';
8418: l_batch_header gme_batch_header%ROWTYPE;
8419:
8420: convert_fpo_failed EXCEPTION;
8421: BEGIN
8422: /* Set the savepoint before proceeding */

Line 8604: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

8600: ,p_commit IN VARCHAR2 := fnd_api.g_false
8601: ,x_message_count OUT NOCOPY NUMBER
8602: ,x_message_list OUT NOCOPY VARCHAR2
8603: ,x_return_status OUT NOCOPY VARCHAR2
8604: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
8605: ,p_org_code IN VARCHAR2
8606: ,p_create_lot IN VARCHAR2 := fnd_api.g_false
8607: ,p_generate_lot IN VARCHAR2 := fnd_api.g_false
8608: ,p_generate_parent_lot IN VARCHAR2 := fnd_api.g_false

Line 8620: l_batch_header_rec gme_batch_header%ROWTYPE;

8616:
8617: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
8618: l_material_detail_rec gme_material_details%ROWTYPE;
8619: l_in_material_detail_rec gme_material_details%ROWTYPE;
8620: l_batch_header_rec gme_batch_header%ROWTYPE;
8621: l_batch_id NUMBER;
8622: l_matl_dtl_id NUMBER;
8623:
8624: error_create_pp_lot EXCEPTION;

Line 8807: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

8803: ,p_commit IN VARCHAR2 := fnd_api.g_false
8804: ,x_message_count OUT NOCOPY NUMBER
8805: ,x_message_list OUT NOCOPY VARCHAR2
8806: ,x_return_status OUT NOCOPY VARCHAR2
8807: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
8808: ,p_org_code IN VARCHAR2
8809: ,p_material_detail_rec IN gme_material_details%ROWTYPE
8810: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
8811: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE)

Line 8818: l_in_batch_header_rec gme_batch_header%ROWTYPE;

8814:
8815: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
8816: l_db_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
8817: l_in_material_detail_rec gme_material_details%ROWTYPE;
8818: l_in_batch_header_rec gme_batch_header%ROWTYPE;
8819: l_material_detail_rec gme_material_details%ROWTYPE;
8820: l_batch_header_rec gme_batch_header%ROWTYPE;
8821: l_batch_id NUMBER;
8822: l_matl_dtl_id NUMBER;

Line 8820: l_batch_header_rec gme_batch_header%ROWTYPE;

8816: l_db_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
8817: l_in_material_detail_rec gme_material_details%ROWTYPE;
8818: l_in_batch_header_rec gme_batch_header%ROWTYPE;
8819: l_material_detail_rec gme_material_details%ROWTYPE;
8820: l_batch_header_rec gme_batch_header%ROWTYPE;
8821: l_batch_id NUMBER;
8822: l_matl_dtl_id NUMBER;
8823:
8824: error_update_pp_lot EXCEPTION;

Line 9045: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

9041: ,p_commit IN VARCHAR2 := fnd_api.g_false
9042: ,x_message_count OUT NOCOPY NUMBER
9043: ,x_message_list OUT NOCOPY VARCHAR2
9044: ,x_return_status OUT NOCOPY VARCHAR2
9045: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
9046: ,p_org_code IN VARCHAR2
9047: ,p_material_detail_rec IN gme_material_details%ROWTYPE
9048: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE)
9049: IS

Line 9055: l_in_batch_header_rec gme_batch_header%ROWTYPE;

9051:
9052: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
9053: l_db_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
9054: l_in_material_detail_rec gme_material_details%ROWTYPE;
9055: l_in_batch_header_rec gme_batch_header%ROWTYPE;
9056: l_material_detail_rec gme_material_details%ROWTYPE;
9057: l_batch_header_rec gme_batch_header%ROWTYPE;
9058: l_batch_id NUMBER;
9059: l_matl_dtl_id NUMBER;

Line 9057: l_batch_header_rec gme_batch_header%ROWTYPE;

9053: l_db_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
9054: l_in_material_detail_rec gme_material_details%ROWTYPE;
9055: l_in_batch_header_rec gme_batch_header%ROWTYPE;
9056: l_material_detail_rec gme_material_details%ROWTYPE;
9057: l_batch_header_rec gme_batch_header%ROWTYPE;
9058: l_batch_id NUMBER;
9059: l_matl_dtl_id NUMBER;
9060:
9061: invalid_version EXCEPTION;

Line 9282: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

9278: ,p_commit IN VARCHAR2 := fnd_api.g_false
9279: ,x_message_count OUT NOCOPY NUMBER
9280: ,x_message_list OUT NOCOPY VARCHAR2
9281: ,x_return_status OUT NOCOPY VARCHAR2
9282: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
9283: ,p_org_code IN VARCHAR2
9284: ,p_create_resv_pend_lots IN NUMBER
9285: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
9286: IS

Line 9285: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)

9281: ,x_return_status OUT NOCOPY VARCHAR2
9282: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
9283: ,p_org_code IN VARCHAR2
9284: ,p_create_resv_pend_lots IN NUMBER
9285: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
9286: IS
9287: l_api_name CONSTANT VARCHAR2 (30) := 'UNRELEASE_BATCH';
9288:
9289: l_in_batch_header_rec gme_batch_header%ROWTYPE;

Line 9289: l_in_batch_header_rec gme_batch_header%ROWTYPE;

9285: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
9286: IS
9287: l_api_name CONSTANT VARCHAR2 (30) := 'UNRELEASE_BATCH';
9288:
9289: l_in_batch_header_rec gme_batch_header%ROWTYPE;
9290: l_batch_header_rec gme_batch_header%ROWTYPE;
9291:
9292: error_unrelease_batch EXCEPTION;
9293: BEGIN

Line 9290: l_batch_header_rec gme_batch_header%ROWTYPE;

9286: IS
9287: l_api_name CONSTANT VARCHAR2 (30) := 'UNRELEASE_BATCH';
9288:
9289: l_in_batch_header_rec gme_batch_header%ROWTYPE;
9290: l_batch_header_rec gme_batch_header%ROWTYPE;
9291:
9292: error_unrelease_batch EXCEPTION;
9293: BEGIN
9294: IF (g_debug <> -1) THEN

Line 9460: l_in_batch_header_rec gme_batch_header%ROWTYPE;

9456: l_api_name CONSTANT VARCHAR2 (30) := 'UNRELEASE_STEP';
9457:
9458: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
9459: l_batch_step_rec gme_batch_steps%ROWTYPE;
9460: l_in_batch_header_rec gme_batch_header%ROWTYPE;
9461: l_batch_header_rec gme_batch_header%ROWTYPE;
9462:
9463: error_unrelease_step EXCEPTION;
9464: BEGIN

Line 9461: l_batch_header_rec gme_batch_header%ROWTYPE;

9457:
9458: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
9459: l_batch_step_rec gme_batch_steps%ROWTYPE;
9460: l_in_batch_header_rec gme_batch_header%ROWTYPE;
9461: l_batch_header_rec gme_batch_header%ROWTYPE;
9462:
9463: error_unrelease_step EXCEPTION;
9464: BEGIN
9465: IF (g_debug <> -1) THEN

Line 9640: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

9636: ,p_commit IN VARCHAR2 := fnd_api.g_false
9637: ,x_message_count OUT NOCOPY NUMBER
9638: ,x_message_list OUT NOCOPY VARCHAR2
9639: ,x_return_status OUT NOCOPY VARCHAR2
9640: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
9641: ,p_org_code IN VARCHAR2
9642: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
9643: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
9644: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

Line 9644: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

9640: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
9641: ,p_org_code IN VARCHAR2
9642: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
9643: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
9644: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
9645: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab)
9646: IS
9647: l_api_name CONSTANT VARCHAR2 (30) := 'COMPLETE_BATCH';
9648:

Line 9649: l_in_batch_header_rec gme_batch_header%ROWTYPE;

9645: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab)
9646: IS
9647: l_api_name CONSTANT VARCHAR2 (30) := 'COMPLETE_BATCH';
9648:
9649: l_in_batch_header_rec gme_batch_header%ROWTYPE;
9650: l_batch_header_rec gme_batch_header%ROWTYPE;
9651: l_exception_material_tbl gme_common_pvt.exceptions_tab;
9652:
9653: error_complete_batch EXCEPTION;

Line 9650: l_batch_header_rec gme_batch_header%ROWTYPE;

9646: IS
9647: l_api_name CONSTANT VARCHAR2 (30) := 'COMPLETE_BATCH';
9648:
9649: l_in_batch_header_rec gme_batch_header%ROWTYPE;
9650: l_batch_header_rec gme_batch_header%ROWTYPE;
9651: l_exception_material_tbl gme_common_pvt.exceptions_tab;
9652:
9653: error_complete_batch EXCEPTION;
9654: BEGIN

Line 9877: l_in_batch_header_rec gme_batch_header%ROWTYPE;

9873: l_api_name CONSTANT VARCHAR2 (30) := 'COMPLETE_STEP';
9874:
9875: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
9876: l_batch_step_rec gme_batch_steps%ROWTYPE;
9877: l_in_batch_header_rec gme_batch_header%ROWTYPE;
9878: l_batch_header_rec gme_batch_header%ROWTYPE;
9879: l_calc_batch_start_date DATE;
9880:
9881: l_exception_material_tbl gme_common_pvt.exceptions_tab;

Line 9878: l_batch_header_rec gme_batch_header%ROWTYPE;

9874:
9875: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
9876: l_batch_step_rec gme_batch_steps%ROWTYPE;
9877: l_in_batch_header_rec gme_batch_header%ROWTYPE;
9878: l_batch_header_rec gme_batch_header%ROWTYPE;
9879: l_calc_batch_start_date DATE;
9880:
9881: l_exception_material_tbl gme_common_pvt.exceptions_tab;
9882:

Line 10122: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

10118: ,p_commit IN VARCHAR2 := fnd_api.g_false
10119: ,x_message_count OUT NOCOPY NUMBER
10120: ,x_message_list OUT NOCOPY VARCHAR2
10121: ,x_return_status OUT NOCOPY VARCHAR2
10122: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
10123: ,p_org_code IN VARCHAR2
10124: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
10125: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
10126: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

Line 10126: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

10122: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
10123: ,p_org_code IN VARCHAR2
10124: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
10125: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
10126: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
10127: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab)
10128: IS
10129: l_api_name CONSTANT VARCHAR2 (30) := 'RELEASE_BATCH';
10130:

Line 10131: l_in_batch_header_rec gme_batch_header%ROWTYPE;

10127: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab)
10128: IS
10129: l_api_name CONSTANT VARCHAR2 (30) := 'RELEASE_BATCH';
10130:
10131: l_in_batch_header_rec gme_batch_header%ROWTYPE;
10132: l_batch_header_rec gme_batch_header%ROWTYPE;
10133: l_exception_material_tbl gme_common_pvt.exceptions_tab;
10134:
10135: error_release_batch EXCEPTION;

Line 10132: l_batch_header_rec gme_batch_header%ROWTYPE;

10128: IS
10129: l_api_name CONSTANT VARCHAR2 (30) := 'RELEASE_BATCH';
10130:
10131: l_in_batch_header_rec gme_batch_header%ROWTYPE;
10132: l_batch_header_rec gme_batch_header%ROWTYPE;
10133: l_exception_material_tbl gme_common_pvt.exceptions_tab;
10134:
10135: error_release_batch EXCEPTION;
10136: BEGIN

Line 10330: l_in_batch_header_rec gme_batch_header%ROWTYPE;

10326: l_api_name CONSTANT VARCHAR2 (30) := 'RELEASE_STEP';
10327:
10328: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
10329: l_batch_step_rec gme_batch_steps%ROWTYPE;
10330: l_in_batch_header_rec gme_batch_header%ROWTYPE;
10331: l_batch_header_rec gme_batch_header%ROWTYPE;
10332:
10333: l_exception_material_tbl gme_common_pvt.exceptions_tab;
10334:

Line 10331: l_batch_header_rec gme_batch_header%ROWTYPE;

10327:
10328: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
10329: l_batch_step_rec gme_batch_steps%ROWTYPE;
10330: l_in_batch_header_rec gme_batch_header%ROWTYPE;
10331: l_batch_header_rec gme_batch_header%ROWTYPE;
10332:
10333: l_exception_material_tbl gme_common_pvt.exceptions_tab;
10334:
10335: error_release_step EXCEPTION;

Line 10567: l_batch_header_rec gme_batch_header%ROWTYPE;

10563: l_org_id NUMBER;
10564: i NUMBER := 0;
10565: success_count NUMBER := 0;
10566: failed_count NUMBER := 0;
10567: l_batch_header_rec gme_batch_header%ROWTYPE;
10568: l_in_batch_header_rec gme_batch_header%ROWTYPE;
10569: l_exception_material_tbl gme_common_pvt.exceptions_tab;
10570: error_process_group EXCEPTION;
10571:

Line 10568: l_in_batch_header_rec gme_batch_header%ROWTYPE;

10564: i NUMBER := 0;
10565: success_count NUMBER := 0;
10566: failed_count NUMBER := 0;
10567: l_batch_header_rec gme_batch_header%ROWTYPE;
10568: l_in_batch_header_rec gme_batch_header%ROWTYPE;
10569: l_exception_material_tbl gme_common_pvt.exceptions_tab;
10570: error_process_group EXCEPTION;
10571:
10572: CURSOR get_organization (l_org_code IN VARCHAR2)

Line 10600: FROM gme_batch_header

10596:
10597: CURSOR get_batch_status (l_batch_id IN NUMBER, l_org_id IN NUMBER)
10598: IS
10599: SELECT batch_status
10600: FROM gme_batch_header
10601: WHERE batch_id = l_batch_id
10602: and organization_id = l_org_id;
10603:
10604: BEGIN