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 188: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

184: ,x_message_count OUT NOCOPY NUMBER
185: ,x_message_list OUT NOCOPY VARCHAR2
186: ,x_return_status OUT NOCOPY VARCHAR2
187: ,p_org_code IN VARCHAR2 := NULL
188: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
189: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
190: ,p_batch_size IN NUMBER := NULL
191: ,p_batch_size_uom IN VARCHAR2 := NULL
192: ,p_creation_mode IN VARCHAR2

Line 189: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

185: ,x_message_list OUT NOCOPY VARCHAR2
186: ,x_return_status OUT NOCOPY VARCHAR2
187: ,p_org_code IN VARCHAR2 := NULL
188: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
189: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
190: ,p_batch_size IN NUMBER := NULL
191: ,p_batch_size_uom IN VARCHAR2 := NULL
192: ,p_creation_mode IN VARCHAR2
193: ,p_recipe_id IN NUMBER := NULL

Line 207: l_batch_header gme_batch_header%ROWTYPE;

203: ,p_use_least_cost_validity_rule IN VARCHAR2 := fnd_api.g_false
204: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab)
205: IS
206: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_BATCH';
207: l_batch_header gme_batch_header%ROWTYPE;
208: l_return_status VARCHAR2 (1);
209: l_object_type VARCHAR2 (10);
210: l_total_input NUMBER;
211: l_total_output NUMBER;

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

636: ,x_message_count OUT NOCOPY NUMBER
637: ,x_message_list OUT NOCOPY VARCHAR2
638: ,x_return_status OUT NOCOPY VARCHAR2
639: ,p_material_detail_rec IN gme_material_details%ROWTYPE
640: ,p_batch_header_rec IN gme_batch_header%ROWTYPE --Bug#6738476
641: ,p_org_code IN VARCHAR2
642: ,p_batch_no IN VARCHAR2 DEFAULT NULL
643: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
644: ,p_validity_rule_id IN NUMBER

Line 652: l_batch_header gme_batch_header%ROWTYPE;

648: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab)
649: IS
650: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_PHANTOM';
651: phantom_creation_failure EXCEPTION;
652: l_batch_header gme_batch_header%ROWTYPE;
653: l_material_detail gme_material_details%ROWTYPE;
654: BEGIN
655: IF (g_debug <> -1) THEN
656: gme_debug.log_initialize ('CreatePhantom');

Line 771: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

767: p_api_version IN NUMBER
768: ,p_validation_level IN NUMBER
769: ,p_init_msg_list IN VARCHAR2
770: ,p_commit IN VARCHAR2
771: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
772: ,p_org_code IN VARCHAR2
773: ,p_ignore_exception IN VARCHAR2
774: ,p_scale_factor IN NUMBER
775: ,p_primaries IN VARCHAR2

Line 784: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)

780: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
781: ,x_message_count OUT NOCOPY NUMBER
782: ,x_message_list OUT NOCOPY VARCHAR2
783: ,x_return_status OUT NOCOPY VARCHAR2
784: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
785: IS
786: l_api_name CONSTANT VARCHAR2 (30) := 'SCALE_BATCH';
787: scale_batch_failed EXCEPTION;
788: l_batch_header_rec gme_batch_header%ROWTYPE;

Line 788: l_batch_header_rec gme_batch_header%ROWTYPE;

784: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
785: IS
786: l_api_name CONSTANT VARCHAR2 (30) := 'SCALE_BATCH';
787: scale_batch_failed EXCEPTION;
788: l_batch_header_rec gme_batch_header%ROWTYPE;
789: l_return_status VARCHAR2(1);
790:
791: BEGIN
792: IF (g_debug <> -1) THEN

Line 943: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

939: p_api_version IN NUMBER := 2.0
940: ,p_validation_level IN NUMBER
941: ,p_init_msg_list IN VARCHAR2
942: ,p_commit IN VARCHAR2
943: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
944: ,p_org_code IN VARCHAR2
945: ,p_scale_factor IN NUMBER
946: ,x_message_count OUT NOCOPY NUMBER
947: ,x_message_list OUT NOCOPY VARCHAR2

Line 952: l_batch_header_rec gme_batch_header%ROWTYPE;

948: ,x_return_status OUT NOCOPY VARCHAR2)
949: IS
950: l_api_name CONSTANT VARCHAR2 (30) := 'THEORETICAL_YIELD_BATCH';
951: theoretical_yield_failed EXCEPTION;
952: l_batch_header_rec gme_batch_header%ROWTYPE;
953: l_return_status VARCHAR2(1);
954: BEGIN
955: IF (g_debug <> -1) THEN
956: gme_debug.log_initialize ('TheoreticalYieldBatch');

Line 1080: l_batch_header gme_batch_header%ROWTYPE;

1076: ,x_return_status OUT NOCOPY VARCHAR2)
1077: IS
1078: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_ACTUAL_RSRC_USAGE';
1079:
1080: l_batch_header gme_batch_header%ROWTYPE;
1081: l_poc_trans_id NUMBER;
1082: l_line_id NUMBER;
1083: l_inv_trans_count NUMBER;
1084: l_rsrc_trans_count NUMBER;

Line 1186: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header

1182:
1183: /* In order to get the poc_trans_id */
1184: /* Lets now load the transactions associated with the batch into the temporary table */
1185: IF p_commit = fnd_api.g_true THEN
1186: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header
1187: ,l_batch_header) ) THEN
1188: RAISE fnd_api.g_exc_error;
1189: END IF;
1190: gme_trans_engine_util.load_rsrc_trans

Line 1261: l_batch_header gme_batch_header%ROWTYPE;

1257: ,x_message_list OUT NOCOPY VARCHAR2
1258: ,x_return_status OUT NOCOPY VARCHAR2)
1259: IS
1260: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_INCR_ACTUAL_RSRC_TXN';
1261: l_batch_header gme_batch_header%ROWTYPE;
1262: l_rsrc_txn_rec gme_resource_txns%ROWTYPE;
1263: BEGIN
1264: /* Set the savepoint */
1265: SAVEPOINT insert_incr_actual_rsrc_txn;

Line 1400: l_batch_header gme_batch_header%ROWTYPE;

1396: ,x_message_list OUT NOCOPY VARCHAR2
1397: ,x_return_status OUT NOCOPY VARCHAR2)
1398: IS
1399: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_TIMED_ACTUAL_RSRC_TXN';
1400: l_batch_header gme_batch_header%ROWTYPE;
1401: l_rsrc_txn_rec gme_resource_txns%ROWTYPE;
1402:
1403: BEGIN
1404: /* Set the savepoint */

Line 1548: l_batch_header gme_batch_header%ROWTYPE;

1544: ,x_message_list OUT NOCOPY VARCHAR2
1545: ,x_return_status OUT NOCOPY VARCHAR2)
1546: IS
1547: l_api_name CONSTANT VARCHAR2(30) := 'START_CMPLT_ACTUAL_RSRC_TXN';
1548: l_batch_header gme_batch_header%ROWTYPE;
1549: l_rsrc_txn_rec gme_resource_txns%ROWTYPE;
1550:
1551: BEGIN
1552: /* Set the savepoint */

Line 1681: l_batch_header gme_batch_header%ROWTYPE;

1677: ,x_message_list OUT NOCOPY VARCHAR2
1678: ,x_return_status OUT NOCOPY VARCHAR2)
1679: IS
1680: l_api_name CONSTANT VARCHAR2(30) := 'END_CMPLT_ACTUAL_RSRC_TXN';
1681: l_batch_header gme_batch_header%ROWTYPE;
1682: l_rsrc_txn_rec gme_resource_txns%ROWTYPE;
1683: BEGIN
1684: /* Set the savepoint */
1685: SAVEPOINT end_cmplt_actual_rsrc_txn;

Line 1793: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

1789: p_api_version IN NUMBER := 2.0
1790: ,p_validation_level IN NUMBER
1791: ,p_init_msg_list IN VARCHAR2
1792: ,p_commit IN VARCHAR2
1793: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1794: ,p_use_workday_cal IN VARCHAR2
1795: ,p_contiguity_override IN VARCHAR2
1796: ,p_org_code IN VARCHAR2
1797: ,x_message_count OUT NOCOPY NUMBER

Line 1800: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)

1796: ,p_org_code IN VARCHAR2
1797: ,x_message_count OUT NOCOPY NUMBER
1798: ,x_message_list OUT NOCOPY VARCHAR2
1799: ,x_return_status OUT NOCOPY VARCHAR2
1800: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
1801: IS
1802: l_api_name CONSTANT VARCHAR2 (30) := 'RESCHEDULE_BATCH';
1803: reschedule_batch_failed EXCEPTION;
1804: batch_save_failed EXCEPTION;

Line 1807: l_batch_header_rec gme_batch_header%ROWTYPE;

1803: reschedule_batch_failed EXCEPTION;
1804: batch_save_failed EXCEPTION;
1805: l_return_status VARCHAR2 (1);
1806: l_use VARCHAR2 (1);
1807: l_batch_header_rec gme_batch_header%ROWTYPE;
1808: BEGIN
1809: IF g_debug <> -1 THEN
1810: gme_debug.log_initialize ('RescheduleBatch');
1811: END IF;

Line 2106: l_batch_header_rec gme_batch_header%ROWTYPE;

2102: l_api_name CONSTANT VARCHAR2 (30) := 'RESCHEDULE_STEP';
2103: l_diff NUMBER := 0;
2104: l_diff_cmplt NUMBER := 0;
2105: reschedule_step_failed EXCEPTION;
2106: l_batch_header_rec gme_batch_header%ROWTYPE;
2107: l_batch_step_rec gme_batch_steps%ROWTYPE;
2108: l_use VARCHAR2 (1);
2109: l_return_status VARCHAR2 (1);
2110: l_reschedule_preceding VARCHAR2 (1);

Line 2415: ,p_batch_rec IN gme_batch_header%ROWTYPE

2411: ,p_validation_level IN NUMBER
2412: := gme_common_pvt.g_max_errors
2413: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2414: ,p_commit IN VARCHAR2 := fnd_api.g_false
2415: ,p_batch_rec IN gme_batch_header%ROWTYPE
2416: ,p_org_code IN VARCHAR2
2417: ,x_message_count OUT NOCOPY NUMBER
2418: ,x_message_list OUT NOCOPY VARCHAR2
2419: ,x_return_status OUT NOCOPY VARCHAR2)

Line 2422: l_batch_header_rec gme_batch_header%ROWTYPE;

2418: ,x_message_list OUT NOCOPY VARCHAR2
2419: ,x_return_status OUT NOCOPY VARCHAR2)
2420: IS
2421: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_BATCH_RESERVATIONS';
2422: l_batch_header_rec gme_batch_header%ROWTYPE;
2423: BEGIN
2424: IF g_debug <= gme_debug.g_log_procedure THEN
2425: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
2426: || l_api_name);

Line 2540: l_batch_header_rec gme_batch_header%ROWTYPE;

2536: l_api_name CONSTANT VARCHAR2 (30)
2537: := 'CREATE_LINE_RESERVATIONS';
2538: l_material_details_rec gme_material_details%ROWTYPE;
2539: l_material_details_rec_out gme_material_details%ROWTYPE;
2540: l_batch_header_rec gme_batch_header%ROWTYPE;
2541: BEGIN
2542: IF g_debug <= gme_debug.g_log_procedure THEN
2543: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
2544: || l_api_name);

Line 3028: l_batch_header_rec gme_batch_header%rowtype;

3024: ,x_return_status OUT NOCOPY VARCHAR2
3025: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE)
3026: IS
3027: l_api_name CONSTANT VARCHAR2 (30) := 'DELETE_STEP';
3028: l_batch_header_rec gme_batch_header%rowtype;
3029: delete_step_failed EXCEPTION;
3030: BEGIN
3031: /* Set the return status to success initially */
3032: x_return_status := fnd_api.g_ret_sts_success;

Line 3127: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

3123: ,p_org_code IN VARCHAR2
3124: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
3125: ,p_oprn_no IN VARCHAR2
3126: ,p_oprn_vers IN NUMBER
3127: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3128: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
3129: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
3130: ,x_message_count OUT NOCOPY NUMBER
3131: ,x_message_list OUT NOCOPY VARCHAR2

Line 3136: l_batch_header_rec gme_batch_header%ROWTYPE;

3132: ,x_return_status OUT NOCOPY VARCHAR2)
3133: IS
3134: l_api_name CONSTANT VARCHAR2 (30) := 'INSERT_STEP';
3135: insert_step_failed EXCEPTION;
3136: l_batch_header_rec gme_batch_header%ROWTYPE;
3137: l_oprn_no VARCHAR2 (16);
3138: /* The operation number for the step */
3139: l_oprn_vers NUMBER;
3140: /* The operation version for the step */

Line 3195: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec

3191:
3192: IF (p_batch_step_rec.batch_id IS NOT NULL) THEN
3193: l_batch_header_rec.batch_id := p_batch_step_rec.batch_id;
3194:
3195: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec
3196: ,l_batch_header_rec) ) THEN
3197: RAISE fnd_api.g_exc_error;
3198: END IF;
3199: ELSE

Line 3200: IF NOT (gme_batch_header_dbl.fetch_row (p_batch_header_rec

3196: ,l_batch_header_rec) ) THEN
3197: RAISE fnd_api.g_exc_error;
3198: END IF;
3199: ELSE
3200: IF NOT (gme_batch_header_dbl.fetch_row (p_batch_header_rec
3201: ,l_batch_header_rec) ) THEN
3202: RAISE fnd_api.g_exc_error;
3203: END IF;
3204: END IF;

Line 3381: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

3377: p_api_version IN NUMBER := 2.0
3378: ,p_validation_level IN NUMBER := gme_common_pvt.g_max_errors
3379: ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
3380: ,p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
3381: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3382: ,p_material_detail_rec IN gme_material_details%ROWTYPE
3383: ,p_locator_code IN VARCHAR2
3384: ,p_org_code IN VARCHAR2
3385: ,p_batchstep_no IN NUMBER := NULL

Line 3401: l_batch_header_rec gme_batch_header%ROWTYPE;

3397: AND subinventory_code = v_sub_inv
3398: AND concatenated_segments = p_locator_code;
3399:
3400: l_api_name CONSTANT VARCHAR2 (30) := 'INSERT_MATERIAL_LINE';
3401: l_batch_header_rec gme_batch_header%ROWTYPE;
3402: l_return_status VARCHAR2(1);
3403: l_batch_step_rec gme_batch_steps%ROWTYPE;
3404: l_material_detail_rec gme_material_details%ROWTYPE;
3405: p_trans_id NUMBER;

Line 3609: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

3605: p_api_version IN NUMBER := 2.0
3606: ,p_validation_level IN NUMBER := gme_common_pvt.g_max_errors
3607: ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
3608: ,p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
3609: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3610: ,p_material_detail_rec IN gme_material_details%ROWTYPE
3611: ,p_locator_code IN VARCHAR2
3612: ,p_org_code IN VARCHAR2
3613: ,p_scale_phantom IN VARCHAR2 DEFAULT fnd_api.g_false

Line 3634: l_batch_header_rec gme_batch_header%ROWTYPE;

3630: FROM gme_batch_step_items
3631: WHERE material_detail_id = v_mat_id;
3632:
3633: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_MATERIAL_LINE';
3634: l_batch_header_rec gme_batch_header%ROWTYPE;
3635: l_return_status VARCHAR2(1);
3636: l_batch_step_rec gme_batch_steps%ROWTYPE;
3637: l_material_detail_rec gme_material_details%ROWTYPE;
3638: l_stored_material_detail_rec gme_material_details%ROWTYPE;

Line 3645: x_batch_header_rec gme_batch_header%ROWTYPE;

3641: l_locator_id NUMBER;
3642: l_batchstep_id NUMBER;
3643:
3644: x_transacted VARCHAR2(30);
3645: x_batch_header_rec gme_batch_header%ROWTYPE;
3646:
3647:
3648: BEGIN
3649:

Line 3857: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

3853: p_api_version IN NUMBER := 2.0
3854: ,p_validation_level IN NUMBER := gme_common_pvt.g_max_errors
3855: ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
3856: ,p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
3857: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3858: ,p_material_detail_rec IN gme_material_details%ROWTYPE
3859: ,p_org_code IN VARCHAR2
3860: ,x_message_count OUT NOCOPY NUMBER
3861: ,x_message_list OUT NOCOPY VARCHAR2

Line 3870: l_batch_header_rec gme_batch_header%ROWTYPE;

3866: FROM gme_batch_step_items
3867: WHERE material_detail_id = v_mat_id;
3868:
3869: l_api_name CONSTANT VARCHAR2 (30) := 'DELETE_MATERIAL_LINE';
3870: l_batch_header_rec gme_batch_header%ROWTYPE;
3871: l_return_status VARCHAR2(1);
3872: l_batch_step_rec gme_batch_steps%ROWTYPE;
3873: l_material_detail_rec gme_material_details%ROWTYPE;
3874:

Line 3877: x_batch_header_rec gme_batch_header%ROWTYPE;

3873: l_material_detail_rec gme_material_details%ROWTYPE;
3874:
3875: l_batchstep_id NUMBER;
3876: x_transacted VARCHAR2(30);
3877: x_batch_header_rec gme_batch_header%ROWTYPE;
3878:
3879: BEGIN
3880: IF (g_debug <> -1) THEN
3881: gme_debug.log_initialize ('DELETE_MATERIAL_LINE');

Line 4019: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

4015: ,x_message_count OUT NOCOPY NUMBER
4016: ,x_message_list OUT NOCOPY VARCHAR2
4017: ,x_return_status OUT NOCOPY VARCHAR2
4018: ,p_org_code IN VARCHAR2
4019: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
4020: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)IS
4021:
4022: l_api_name CONSTANT VARCHAR2 (30) := 'REVERT_BATCH';
4023: l_batch_header_rec gme_batch_header%ROWTYPE;

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

4016: ,x_message_list OUT NOCOPY VARCHAR2
4017: ,x_return_status OUT NOCOPY VARCHAR2
4018: ,p_org_code IN VARCHAR2
4019: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
4020: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)IS
4021:
4022: l_api_name CONSTANT VARCHAR2 (30) := 'REVERT_BATCH';
4023: l_batch_header_rec gme_batch_header%ROWTYPE;
4024: batch_revert_failure EXCEPTION;

Line 4023: l_batch_header_rec gme_batch_header%ROWTYPE;

4019: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
4020: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)IS
4021:
4022: l_api_name CONSTANT VARCHAR2 (30) := 'REVERT_BATCH';
4023: l_batch_header_rec gme_batch_header%ROWTYPE;
4024: batch_revert_failure EXCEPTION;
4025: -- FP Bug 6437252
4026: x_lpn_txns NUMBER;
4027: l_continue_lpn_txn VARCHAR2(1);

Line 4231: l_batch_header_rec gme_batch_header%rowtype;

4227: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)IS
4228:
4229: l_api_name CONSTANT VARCHAR2 (30) := 'REVERT_STEP';
4230: l_batch_step_rec gme_batch_steps%ROWTYPE;
4231: l_batch_header_rec gme_batch_header%rowtype;
4232:
4233: step_revert_failure EXCEPTION;
4234: BEGIN
4235: IF (g_debug <> -1) THEN

Line 4361: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

4357: ,p_commit IN VARCHAR2
4358: ,x_message_count OUT NOCOPY NUMBER
4359: ,x_message_list OUT NOCOPY VARCHAR2
4360: ,x_return_status OUT NOCOPY VARCHAR2
4361: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
4362: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
4363: ,p_org_code IN VARCHAR2)
4364: IS
4365: l_api_name CONSTANT VARCHAR2 (30) := 'CLOSE_BATCH';

Line 4362: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

4358: ,x_message_count OUT NOCOPY NUMBER
4359: ,x_message_list OUT NOCOPY VARCHAR2
4360: ,x_return_status OUT NOCOPY VARCHAR2
4361: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
4362: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
4363: ,p_org_code IN VARCHAR2)
4364: IS
4365: l_api_name CONSTANT VARCHAR2 (30) := 'CLOSE_BATCH';
4366: l_batch_header_rec gme_batch_header%ROWTYPE;

Line 4366: l_batch_header_rec gme_batch_header%ROWTYPE;

4362: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
4363: ,p_org_code IN VARCHAR2)
4364: IS
4365: l_api_name CONSTANT VARCHAR2 (30) := 'CLOSE_BATCH';
4366: l_batch_header_rec gme_batch_header%ROWTYPE;
4367:
4368: batch_close_failure EXCEPTION;
4369: BEGIN
4370: IF g_debug <= gme_debug.g_log_procedure THEN

Line 4521: l_batch_header_rec gme_batch_header%ROWTYPE;

4517: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)
4518: IS
4519: l_api_name CONSTANT VARCHAR2 (30) := 'CLOSE_STEP';
4520:
4521: l_batch_header_rec gme_batch_header%ROWTYPE;
4522: l_batch_step_rec gme_batch_steps%ROWTYPE;
4523:
4524: step_close_failed EXCEPTION;
4525: BEGIN

Line 4659: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

4655: ,p_commit IN VARCHAR2
4656: ,x_message_count OUT NOCOPY NUMBER
4657: ,x_message_list OUT NOCOPY VARCHAR2
4658: ,x_return_status OUT NOCOPY VARCHAR2
4659: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
4660: ,p_org_code IN VARCHAR2
4661: ,p_reopen_steps IN VARCHAR2 := fnd_api.g_false
4662: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
4663: IS

Line 4662: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)

4658: ,x_return_status OUT NOCOPY VARCHAR2
4659: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
4660: ,p_org_code IN VARCHAR2
4661: ,p_reopen_steps IN VARCHAR2 := fnd_api.g_false
4662: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
4663: IS
4664: l_api_name CONSTANT VARCHAR2 (30) := 'REOPEN_BATCH';
4665: l_batch_header_rec gme_batch_header%ROWTYPE;
4666: batch_reopen_failure EXCEPTION;

Line 4665: l_batch_header_rec gme_batch_header%ROWTYPE;

4661: ,p_reopen_steps IN VARCHAR2 := fnd_api.g_false
4662: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
4663: IS
4664: l_api_name CONSTANT VARCHAR2 (30) := 'REOPEN_BATCH';
4665: l_batch_header_rec gme_batch_header%ROWTYPE;
4666: batch_reopen_failure EXCEPTION;
4667: BEGIN
4668: IF g_debug <= gme_debug.g_log_procedure THEN
4669: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

Line 4765: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

4761: ,x_message_count OUT NOCOPY NUMBER
4762: ,x_message_list OUT NOCOPY VARCHAR2
4763: ,x_return_status OUT NOCOPY VARCHAR2
4764: ,p_org_code IN VARCHAR2
4765: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
4766: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
4767: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)
4768: IS
4769: l_api_name CONSTANT VARCHAR2 (30):= 'REOPEN_STEP';

Line 4770: l_batch_header_rec gme_batch_header%ROWTYPE;

4766: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
4767: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)
4768: IS
4769: l_api_name CONSTANT VARCHAR2 (30):= 'REOPEN_STEP';
4770: l_batch_header_rec gme_batch_header%ROWTYPE;
4771: l_batch_step_rec gme_batch_steps%ROWTYPE;
4772: step_reopen_failure EXCEPTION;
4773: BEGIN
4774: IF g_debug <= gme_debug.g_log_procedure THEN

Line 4870: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

4866: ,p_commit IN VARCHAR2 := fnd_api.g_false
4867: ,x_message_count OUT NOCOPY NUMBER
4868: ,x_message_list OUT NOCOPY VARCHAR2
4869: ,x_return_status OUT NOCOPY VARCHAR2
4870: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
4871: ,p_org_code IN VARCHAR2
4872: ,p_material_detail_rec IN gme_material_details%ROWTYPE
4873: ,p_qty IN NUMBER
4874: ,p_qty_type IN NUMBER

Line 4882: l_batch_header_rec gme_batch_header%ROWTYPE;

4878: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab)
4879: IS
4880: l_api_name CONSTANT VARCHAR2 (30) := 'INCREMENTAL_BACKFLUSH';
4881: l_material_detail_rec gme_material_details%ROWTYPE;
4882: l_batch_header_rec gme_batch_header%ROWTYPE;
4883: l_exception_material_tbl gme_common_pvt.exceptions_tab;
4884:
4885: error_incr_backflush EXCEPTION;
4886: BEGIN

Line 5070: l_batch_header_rec gme_batch_header%ROWTYPE;

5066: l_mmti_rec mtl_transactions_interface%ROWTYPE;
5067: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
5068: l_mat_dtl_rec gme_material_details%ROWTYPE;
5069: l_mat_dtl_rec_out gme_material_details%ROWTYPE;
5070: l_batch_header_rec gme_batch_header%ROWTYPE;
5071: l_item_rec mtl_system_items_b%ROWTYPE;
5072: l_lot_rec mtl_lot_numbers%ROWTYPE;
5073: l_parent_gen_lot VARCHAR2 (2000) DEFAULT NULL;
5074: l_gen_lot VARCHAR2 (80) DEFAULT NULL;

Line 6091: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

6087: ,p_validation_level IN NUMBER
6088: := gme_common_pvt.g_max_errors
6089: ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
6090: ,p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
6091: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
6092: ,p_validity_rule_id IN NUMBER
6093: ,p_org_code IN VARCHAR2
6094: ,p_use_workday_cal IN VARCHAR2 DEFAULT fnd_api.g_false
6095: ,p_contiguity_override IN VARCHAR2 DEFAULT fnd_api.g_false

Line 6099: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)

6095: ,p_contiguity_override IN VARCHAR2 DEFAULT fnd_api.g_false
6096: ,x_message_count OUT NOCOPY NUMBER
6097: ,x_message_list OUT NOCOPY VARCHAR2
6098: ,x_return_status OUT NOCOPY VARCHAR2
6099: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
6100: IS
6101: l_api_name CONSTANT VARCHAR2 (30) := 'REROUTE_BATCH';
6102: l_batch_header_rec gme_batch_header%ROWTYPE;
6103:

Line 6102: l_batch_header_rec gme_batch_header%ROWTYPE;

6098: ,x_return_status OUT NOCOPY VARCHAR2
6099: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
6100: IS
6101: l_api_name CONSTANT VARCHAR2 (30) := 'REROUTE_BATCH';
6102: l_batch_header_rec gme_batch_header%ROWTYPE;
6103:
6104: reroute_batch_failed EXCEPTION;
6105: BEGIN
6106: IF (g_debug <> -1) THEN

Line 6304: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

6300: ,x_message_count OUT NOCOPY NUMBER
6301: ,x_message_list OUT NOCOPY VARCHAR2
6302: ,x_return_status OUT NOCOPY VARCHAR2
6303: ,p_org_code IN VARCHAR2
6304: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
6305: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
6306: IS
6307: l_api_name CONSTANT VARCHAR2 (30) := 'CANCEL_BATCH';
6308: l_batch_header_rec gme_batch_header%ROWTYPE;

Line 6305: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)

6301: ,x_message_list OUT NOCOPY VARCHAR2
6302: ,x_return_status OUT NOCOPY VARCHAR2
6303: ,p_org_code IN VARCHAR2
6304: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
6305: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
6306: IS
6307: l_api_name CONSTANT VARCHAR2 (30) := 'CANCEL_BATCH';
6308: l_batch_header_rec gme_batch_header%ROWTYPE;
6309:

Line 6308: l_batch_header_rec gme_batch_header%ROWTYPE;

6304: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
6305: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
6306: IS
6307: l_api_name CONSTANT VARCHAR2 (30) := 'CANCEL_BATCH';
6308: l_batch_header_rec gme_batch_header%ROWTYPE;
6309:
6310: -- Bug 11846735 - Add variables so we can load resource transactions.
6311: l_rsrc_cnt NUMBER;
6312: l_return_status VARCHAR2(1);

Line 6530: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

6526: ,x_message_list OUT NOCOPY VARCHAR2
6527: ,x_return_status OUT NOCOPY VARCHAR2
6528: ,p_org_code IN VARCHAR2
6529: ,p_reason_name IN VARCHAR2
6530: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
6531: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
6532: IS
6533: CURSOR cur_val_reason_id (v_reason_id NUMBER)
6534: IS

Line 6531: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)

6527: ,x_return_status OUT NOCOPY VARCHAR2
6528: ,p_org_code IN VARCHAR2
6529: ,p_reason_name IN VARCHAR2
6530: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
6531: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
6532: IS
6533: CURSOR cur_val_reason_id (v_reason_id NUMBER)
6534: IS
6535: SELECT 1

Line 6549: l_batch_header_rec gme_batch_header%ROWTYPE;

6545: AND reason_name = v_reason_name;
6546:
6547: i NUMBER;
6548: l_api_name CONSTANT VARCHAR2 (30) := 'TERMINATE_BATCH';
6549: l_batch_header_rec gme_batch_header%ROWTYPE;
6550: l_reason_valid NUMBER;
6551:
6552: batch_terminate_failure EXCEPTION;
6553: BEGIN

Line 6774: l_batch_header_rec gme_batch_header%ROWTYPE; -- Bug 13532998

6770: l_material_details_rec gme_material_details%ROWTYPE;
6771: l_reservation_rec mtl_reservations%ROWTYPE;
6772: l_valid_status VARCHAR2(1);
6773:
6774: l_batch_header_rec gme_batch_header%ROWTYPE; -- Bug 13532998
6775:
6776: detail_reservation_error EXCEPTION;
6777: negative_qty_error EXCEPTION;
6778: bad_trans_date_error EXCEPTION; -- Bug 13532998

Line 6879: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec

6875:
6876: -- Let's fetch the batch header.
6877: l_batch_header_rec.batch_id := l_material_details_rec.batch_id;
6878:
6879: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec
6880: ,l_batch_header_rec) ) THEN
6881: RAISE fnd_api.g_exc_error;
6882: END IF;
6883:

Line 7026: l_batch_header gme_batch_header%ROWTYPE;

7022: ,x_return_status OUT NOCOPY VARCHAR2)
7023: IS
7024: l_api_name CONSTANT VARCHAR2 (30)
7025: := 'INSERT_BATCHSTEP_RESOURCE';
7026: l_batch_header gme_batch_header%ROWTYPE;
7027: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;
7028: l_batchstep_resource_rec_out gme_batch_step_resources%ROWTYPE;
7029: l_table NUMBER;
7030: l_step_status NUMBER;

Line 7057: FROM gme_batch_header a, gme_batch_step_activities b

7053:
7054: CURSOR cur_validate_batch_type (v_activity_id NUMBER)
7055: IS
7056: SELECT 1
7057: FROM gme_batch_header a, gme_batch_step_activities b
7058: WHERE a.batch_id = b.batch_id
7059: AND b.batchstep_activity_id = v_activity_id
7060: AND a.batch_type = 10;
7061:

Line 7475: l_batch_header gme_batch_header%ROWTYPE;

7471: ,x_return_status OUT NOCOPY VARCHAR2)
7472: IS
7473: l_api_name CONSTANT VARCHAR2 (30)
7474: := 'UPDATE_BATCHSTEP_RESOURCE';
7475: l_batch_header gme_batch_header%ROWTYPE;
7476: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;
7477: l_batchstep_resource_rec_out gme_batch_step_resources%ROWTYPE;
7478: l_cons_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;
7479: l_return_status VARCHAR2 (2);

Line 7784: ,gme_batch_header c

7780: SELECT c.organization_id, a.step_status, a.batch_id, a.batchstep_id
7781: ,b.batchstep_activity_id, c.batch_status
7782: FROM gme_batch_steps a
7783: ,gme_batch_step_resources b
7784: ,gme_batch_header c
7785: WHERE a.batch_id = b.batch_id
7786: AND a.batchstep_id = b.batchstep_id
7787: AND b.batchstep_resource_id = v_batchstep_rsrc_id
7788: AND a.batch_id = c.batch_id;

Line 7793: FROM gme_batch_header a, gme_batch_step_resources b

7789:
7790: CURSOR cur_validate_batch_type (v_rsrc_id NUMBER)
7791: IS
7792: SELECT 1
7793: FROM gme_batch_header a, gme_batch_step_resources b
7794: WHERE a.batch_id = b.batch_id
7795: AND b.batchstep_resource_id = v_rsrc_id
7796: AND a.batch_type = 10;
7797:

Line 8102: l_batch_header_rec gme_batch_header%ROWTYPE;

8098: l_api_name CONSTANT VARCHAR2 (30) := 'AUTO_DETAIL_LINE';
8099: l_material_details_rec gme_material_details%ROWTYPE;
8100: l_material_details_rec_out gme_material_details%ROWTYPE;
8101: l_reservation_rec mtl_reservations%ROWTYPE;
8102: l_batch_header_rec gme_batch_header%ROWTYPE;
8103: l_valid_status VARCHAR2(1);
8104:
8105: CURSOR cur_fetch_reservation (v_reservation_id NUMBER)
8106: IS

Line 8278: ,p_batch_rec IN GME_BATCH_HEADER%ROWTYPE) IS

8274: ,x_message_count OUT NOCOPY NUMBER
8275: ,x_message_list OUT NOCOPY VARCHAR2
8276: ,x_return_status OUT NOCOPY VARCHAR2
8277: ,p_org_code IN VARCHAR2
8278: ,p_batch_rec IN GME_BATCH_HEADER%ROWTYPE) IS
8279:
8280: l_api_name CONSTANT VARCHAR2 (30) := 'AUTO_DETAIL_BATCH';
8281: l_batch_rec GME_BATCH_HEADER%ROWTYPE;
8282: l_batch_header_rec GME_BATCH_HEADER%ROWTYPE;

Line 8281: l_batch_rec GME_BATCH_HEADER%ROWTYPE;

8277: ,p_org_code IN VARCHAR2
8278: ,p_batch_rec IN GME_BATCH_HEADER%ROWTYPE) IS
8279:
8280: l_api_name CONSTANT VARCHAR2 (30) := 'AUTO_DETAIL_BATCH';
8281: l_batch_rec GME_BATCH_HEADER%ROWTYPE;
8282: l_batch_header_rec GME_BATCH_HEADER%ROWTYPE;
8283:
8284: auto_detail_error EXCEPTION;
8285: BEGIN

Line 8282: l_batch_header_rec GME_BATCH_HEADER%ROWTYPE;

8278: ,p_batch_rec IN GME_BATCH_HEADER%ROWTYPE) IS
8279:
8280: l_api_name CONSTANT VARCHAR2 (30) := 'AUTO_DETAIL_BATCH';
8281: l_batch_rec GME_BATCH_HEADER%ROWTYPE;
8282: l_batch_header_rec GME_BATCH_HEADER%ROWTYPE;
8283:
8284: auto_detail_error EXCEPTION;
8285: BEGIN
8286: IF (g_debug <> -1) THEN

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

8348: IF l_batch_rec.batch_type is NULL THEN
8349: l_batch_rec.batch_type := gme_common_pvt.g_doc_type_batch;
8350: END IF;
8351:
8352: IF (NOT gme_batch_header_dbl.fetch_row (l_batch_rec,
8353: l_batch_header_rec) ) THEN
8354: RAISE fnd_api.g_exc_error;
8355: END IF;
8356:

Line 8919: p_batch_header IN gme_batch_header%ROWTYPE,

8915: x_message_list OUT NOCOPY VARCHAR2,
8916: p_enforce_vldt_check IN VARCHAR2 := fnd_api.g_true,
8917: x_return_status OUT NOCOPY VARCHAR2,
8918: p_org_code IN VARCHAR2 := NULL,
8919: p_batch_header IN gme_batch_header%ROWTYPE,
8920: x_batch_header OUT NOCOPY gme_batch_header%ROWTYPE,
8921: p_batch_size IN NUMBER,
8922: p_num_batches IN NUMBER,
8923: p_validity_rule_id IN NUMBER,

Line 8920: x_batch_header OUT NOCOPY gme_batch_header%ROWTYPE,

8916: p_enforce_vldt_check IN VARCHAR2 := fnd_api.g_true,
8917: x_return_status OUT NOCOPY VARCHAR2,
8918: p_org_code IN VARCHAR2 := NULL,
8919: p_batch_header IN gme_batch_header%ROWTYPE,
8920: x_batch_header OUT NOCOPY gme_batch_header%ROWTYPE,
8921: p_batch_size IN NUMBER,
8922: p_num_batches IN NUMBER,
8923: p_validity_rule_id IN NUMBER,
8924: p_validity_rule_tab IN gme_common_pvt.recipe_validity_rule_tab,

Line 8928: p_plan_start_date IN gme_batch_header.plan_start_date%TYPE,

8924: p_validity_rule_tab IN gme_common_pvt.recipe_validity_rule_tab,
8925: p_leadtime IN NUMBER DEFAULT 0,
8926: p_batch_offset IN NUMBER DEFAULT 0,
8927: p_offset_type IN NUMBER DEFAULT 0,
8928: p_plan_start_date IN gme_batch_header.plan_start_date%TYPE,
8929: p_plan_cmplt_date IN gme_batch_header.plan_cmplt_date%TYPE,
8930: p_use_shop_cal IN VARCHAR2 := fnd_api.g_false,
8931: p_contiguity_override IN VARCHAR2 := fnd_api.g_true,
8932: p_use_for_all IN VARCHAR2 := fnd_api.g_true

Line 8929: p_plan_cmplt_date IN gme_batch_header.plan_cmplt_date%TYPE,

8925: p_leadtime IN NUMBER DEFAULT 0,
8926: p_batch_offset IN NUMBER DEFAULT 0,
8927: p_offset_type IN NUMBER DEFAULT 0,
8928: p_plan_start_date IN gme_batch_header.plan_start_date%TYPE,
8929: p_plan_cmplt_date IN gme_batch_header.plan_cmplt_date%TYPE,
8930: p_use_shop_cal IN VARCHAR2 := fnd_api.g_false,
8931: p_contiguity_override IN VARCHAR2 := fnd_api.g_true,
8932: p_use_for_all IN VARCHAR2 := fnd_api.g_true
8933: ) IS

Line 8935: l_batch_header gme_batch_header%ROWTYPE;

8931: p_contiguity_override IN VARCHAR2 := fnd_api.g_true,
8932: p_use_for_all IN VARCHAR2 := fnd_api.g_true
8933: ) IS
8934: l_api_name CONSTANT VARCHAR2 (30) := 'CONVERT_FPO';
8935: l_batch_header gme_batch_header%ROWTYPE;
8936:
8937: convert_fpo_failed EXCEPTION;
8938: BEGIN
8939: /* Set the savepoint before proceeding */

Line 9128: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

9124: ,p_commit IN VARCHAR2 := fnd_api.g_false
9125: ,x_message_count OUT NOCOPY NUMBER
9126: ,x_message_list OUT NOCOPY VARCHAR2
9127: ,x_return_status OUT NOCOPY VARCHAR2
9128: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
9129: ,p_org_code IN VARCHAR2
9130: ,p_create_lot IN VARCHAR2 := fnd_api.g_false
9131: ,p_generate_lot IN VARCHAR2 := fnd_api.g_false
9132: ,p_generate_parent_lot IN VARCHAR2 := fnd_api.g_false

Line 9145: l_batch_header_rec gme_batch_header%ROWTYPE;

9141:
9142: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
9143: l_material_detail_rec gme_material_details%ROWTYPE;
9144: l_in_material_detail_rec gme_material_details%ROWTYPE;
9145: l_batch_header_rec gme_batch_header%ROWTYPE;
9146: l_batch_id NUMBER;
9147: l_matl_dtl_id NUMBER;
9148:
9149: error_create_pp_lot EXCEPTION;

Line 9337: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

9333: ,p_commit IN VARCHAR2 := fnd_api.g_false
9334: ,x_message_count OUT NOCOPY NUMBER
9335: ,x_message_list OUT NOCOPY VARCHAR2
9336: ,x_return_status OUT NOCOPY VARCHAR2
9337: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
9338: ,p_org_code IN VARCHAR2
9339: ,p_material_detail_rec IN gme_material_details%ROWTYPE
9340: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
9341: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE)

Line 9348: l_in_batch_header_rec gme_batch_header%ROWTYPE;

9344:
9345: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
9346: l_db_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
9347: l_in_material_detail_rec gme_material_details%ROWTYPE;
9348: l_in_batch_header_rec gme_batch_header%ROWTYPE;
9349: l_material_detail_rec gme_material_details%ROWTYPE;
9350: l_batch_header_rec gme_batch_header%ROWTYPE;
9351: l_batch_id NUMBER;
9352: l_matl_dtl_id NUMBER;

Line 9350: l_batch_header_rec gme_batch_header%ROWTYPE;

9346: l_db_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
9347: l_in_material_detail_rec gme_material_details%ROWTYPE;
9348: l_in_batch_header_rec gme_batch_header%ROWTYPE;
9349: l_material_detail_rec gme_material_details%ROWTYPE;
9350: l_batch_header_rec gme_batch_header%ROWTYPE;
9351: l_batch_id NUMBER;
9352: l_matl_dtl_id NUMBER;
9353:
9354: error_update_pp_lot EXCEPTION;

Line 9575: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

9571: ,p_commit IN VARCHAR2 := fnd_api.g_false
9572: ,x_message_count OUT NOCOPY NUMBER
9573: ,x_message_list OUT NOCOPY VARCHAR2
9574: ,x_return_status OUT NOCOPY VARCHAR2
9575: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
9576: ,p_org_code IN VARCHAR2
9577: ,p_material_detail_rec IN gme_material_details%ROWTYPE
9578: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE)
9579: IS

Line 9585: l_in_batch_header_rec gme_batch_header%ROWTYPE;

9581:
9582: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
9583: l_db_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
9584: l_in_material_detail_rec gme_material_details%ROWTYPE;
9585: l_in_batch_header_rec gme_batch_header%ROWTYPE;
9586: l_material_detail_rec gme_material_details%ROWTYPE;
9587: l_batch_header_rec gme_batch_header%ROWTYPE;
9588: l_batch_id NUMBER;
9589: l_matl_dtl_id NUMBER;

Line 9587: l_batch_header_rec gme_batch_header%ROWTYPE;

9583: l_db_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
9584: l_in_material_detail_rec gme_material_details%ROWTYPE;
9585: l_in_batch_header_rec gme_batch_header%ROWTYPE;
9586: l_material_detail_rec gme_material_details%ROWTYPE;
9587: l_batch_header_rec gme_batch_header%ROWTYPE;
9588: l_batch_id NUMBER;
9589: l_matl_dtl_id NUMBER;
9590:
9591: invalid_version EXCEPTION;

Line 9818: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

9814: ,p_commit IN VARCHAR2 := fnd_api.g_false
9815: ,x_message_count OUT NOCOPY NUMBER
9816: ,x_message_list OUT NOCOPY VARCHAR2
9817: ,x_return_status OUT NOCOPY VARCHAR2
9818: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
9819: ,p_org_code IN VARCHAR2
9820: ,p_create_resv_pend_lots IN NUMBER
9821: ,p_continue_lpn_txn IN VARCHAR2 := 'N'
9822: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)

Line 9822: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)

9818: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
9819: ,p_org_code IN VARCHAR2
9820: ,p_create_resv_pend_lots IN NUMBER
9821: ,p_continue_lpn_txn IN VARCHAR2 := 'N'
9822: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
9823: IS
9824: l_api_name CONSTANT VARCHAR2 (30) := 'UNRELEASE_BATCH';
9825:
9826: l_in_batch_header_rec gme_batch_header%ROWTYPE;

Line 9826: l_in_batch_header_rec gme_batch_header%ROWTYPE;

9822: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
9823: IS
9824: l_api_name CONSTANT VARCHAR2 (30) := 'UNRELEASE_BATCH';
9825:
9826: l_in_batch_header_rec gme_batch_header%ROWTYPE;
9827: l_batch_header_rec gme_batch_header%ROWTYPE;
9828:
9829: error_unrelease_batch EXCEPTION;
9830: -- Bug 6437252

Line 9827: l_batch_header_rec gme_batch_header%ROWTYPE;

9823: IS
9824: l_api_name CONSTANT VARCHAR2 (30) := 'UNRELEASE_BATCH';
9825:
9826: l_in_batch_header_rec gme_batch_header%ROWTYPE;
9827: l_batch_header_rec gme_batch_header%ROWTYPE;
9828:
9829: error_unrelease_batch EXCEPTION;
9830: -- Bug 6437252
9831: x_lpn_txns NUMBER;

Line 10039: l_in_batch_header_rec gme_batch_header%ROWTYPE;

10035: l_api_name CONSTANT VARCHAR2 (30) := 'UNRELEASE_STEP';
10036:
10037: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
10038: l_batch_step_rec gme_batch_steps%ROWTYPE;
10039: l_in_batch_header_rec gme_batch_header%ROWTYPE;
10040: l_batch_header_rec gme_batch_header%ROWTYPE;
10041:
10042: error_unrelease_step EXCEPTION;
10043: BEGIN

Line 10040: l_batch_header_rec gme_batch_header%ROWTYPE;

10036:
10037: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
10038: l_batch_step_rec gme_batch_steps%ROWTYPE;
10039: l_in_batch_header_rec gme_batch_header%ROWTYPE;
10040: l_batch_header_rec gme_batch_header%ROWTYPE;
10041:
10042: error_unrelease_step EXCEPTION;
10043: BEGIN
10044: IF (g_debug <> -1) THEN

Line 10228: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

10224: ,p_commit IN VARCHAR2 := fnd_api.g_false
10225: ,x_message_count OUT NOCOPY NUMBER
10226: ,x_message_list OUT NOCOPY VARCHAR2
10227: ,x_return_status OUT NOCOPY VARCHAR2
10228: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
10229: ,p_org_code IN VARCHAR2
10230: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
10231: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
10232: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

Line 10232: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

10228: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
10229: ,p_org_code IN VARCHAR2
10230: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
10231: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
10232: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
10233: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab)
10234: IS
10235: l_api_name CONSTANT VARCHAR2 (30) := 'COMPLETE_BATCH';
10236:

Line 10237: l_in_batch_header_rec gme_batch_header%ROWTYPE;

10233: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab)
10234: IS
10235: l_api_name CONSTANT VARCHAR2 (30) := 'COMPLETE_BATCH';
10236:
10237: l_in_batch_header_rec gme_batch_header%ROWTYPE;
10238: l_batch_header_rec gme_batch_header%ROWTYPE;
10239: l_exception_material_tbl gme_common_pvt.exceptions_tab;
10240:
10241: error_complete_batch EXCEPTION;

Line 10238: l_batch_header_rec gme_batch_header%ROWTYPE;

10234: IS
10235: l_api_name CONSTANT VARCHAR2 (30) := 'COMPLETE_BATCH';
10236:
10237: l_in_batch_header_rec gme_batch_header%ROWTYPE;
10238: l_batch_header_rec gme_batch_header%ROWTYPE;
10239: l_exception_material_tbl gme_common_pvt.exceptions_tab;
10240:
10241: error_complete_batch EXCEPTION;
10242: purge_exception_err EXCEPTION;

Line 10512: l_in_batch_header_rec gme_batch_header%ROWTYPE;

10508: l_api_name CONSTANT VARCHAR2 (30) := 'COMPLETE_STEP';
10509:
10510: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
10511: l_batch_step_rec gme_batch_steps%ROWTYPE;
10512: l_in_batch_header_rec gme_batch_header%ROWTYPE;
10513: l_batch_header_rec gme_batch_header%ROWTYPE;
10514: l_calc_batch_start_date DATE;
10515:
10516: l_exception_material_tbl gme_common_pvt.exceptions_tab;

Line 10513: l_batch_header_rec gme_batch_header%ROWTYPE;

10509:
10510: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
10511: l_batch_step_rec gme_batch_steps%ROWTYPE;
10512: l_in_batch_header_rec gme_batch_header%ROWTYPE;
10513: l_batch_header_rec gme_batch_header%ROWTYPE;
10514: l_calc_batch_start_date DATE;
10515:
10516: l_exception_material_tbl gme_common_pvt.exceptions_tab;
10517:

Line 10766: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

10762: ,p_commit IN VARCHAR2 := fnd_api.g_false
10763: ,x_message_count OUT NOCOPY NUMBER
10764: ,x_message_list OUT NOCOPY VARCHAR2
10765: ,x_return_status OUT NOCOPY VARCHAR2
10766: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
10767: ,p_org_code IN VARCHAR2
10768: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
10769: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
10770: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

Line 10770: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

10766: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
10767: ,p_org_code IN VARCHAR2
10768: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
10769: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
10770: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
10771: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab)
10772: IS
10773: l_api_name CONSTANT VARCHAR2 (30) := 'RELEASE_BATCH';
10774:

Line 10775: l_in_batch_header_rec gme_batch_header%ROWTYPE;

10771: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab)
10772: IS
10773: l_api_name CONSTANT VARCHAR2 (30) := 'RELEASE_BATCH';
10774:
10775: l_in_batch_header_rec gme_batch_header%ROWTYPE;
10776: l_batch_header_rec gme_batch_header%ROWTYPE;
10777: l_exception_material_tbl gme_common_pvt.exceptions_tab;
10778:
10779: error_release_batch EXCEPTION;

Line 10776: l_batch_header_rec gme_batch_header%ROWTYPE;

10772: IS
10773: l_api_name CONSTANT VARCHAR2 (30) := 'RELEASE_BATCH';
10774:
10775: l_in_batch_header_rec gme_batch_header%ROWTYPE;
10776: l_batch_header_rec gme_batch_header%ROWTYPE;
10777: l_exception_material_tbl gme_common_pvt.exceptions_tab;
10778:
10779: error_release_batch EXCEPTION;
10780: BEGIN

Line 10987: l_in_batch_header_rec gme_batch_header%ROWTYPE;

10983: l_api_name CONSTANT VARCHAR2 (30) := 'RELEASE_STEP';
10984:
10985: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
10986: l_batch_step_rec gme_batch_steps%ROWTYPE;
10987: l_in_batch_header_rec gme_batch_header%ROWTYPE;
10988: l_batch_header_rec gme_batch_header%ROWTYPE;
10989:
10990: l_exception_material_tbl gme_common_pvt.exceptions_tab;
10991:

Line 10988: l_batch_header_rec gme_batch_header%ROWTYPE;

10984:
10985: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
10986: l_batch_step_rec gme_batch_steps%ROWTYPE;
10987: l_in_batch_header_rec gme_batch_header%ROWTYPE;
10988: l_batch_header_rec gme_batch_header%ROWTYPE;
10989:
10990: l_exception_material_tbl gme_common_pvt.exceptions_tab;
10991:
10992: error_release_step EXCEPTION;

Line 11233: l_batch_header_rec gme_batch_header%ROWTYPE;

11229: l_org_id NUMBER;
11230: i NUMBER := 0;
11231: success_count NUMBER := 0;
11232: failed_count NUMBER := 0;
11233: l_batch_header_rec gme_batch_header%ROWTYPE;
11234: l_in_batch_header_rec gme_batch_header%ROWTYPE;
11235: l_exception_material_tbl gme_common_pvt.exceptions_tab;
11236: error_process_group EXCEPTION;
11237:

Line 11234: l_in_batch_header_rec gme_batch_header%ROWTYPE;

11230: i NUMBER := 0;
11231: success_count NUMBER := 0;
11232: failed_count NUMBER := 0;
11233: l_batch_header_rec gme_batch_header%ROWTYPE;
11234: l_in_batch_header_rec gme_batch_header%ROWTYPE;
11235: l_exception_material_tbl gme_common_pvt.exceptions_tab;
11236: error_process_group EXCEPTION;
11237:
11238: CURSOR get_organization (l_org_code IN VARCHAR2)

Line 11266: FROM gme_batch_header

11262:
11263: CURSOR get_batch_status (l_batch_id IN NUMBER, l_org_id IN NUMBER)
11264: IS
11265: SELECT batch_status
11266: FROM gme_batch_header
11267: WHERE batch_id = l_batch_id
11268: and organization_id = l_org_id;
11269:
11270: BEGIN

Line 11617: l_batch_header gme_batch_header%ROWTYPE;

11613:
11614: IS
11615: l_api_name CONSTANT VARCHAR2 (30)
11616: := 'UPDATE_STEP';
11617: l_batch_header gme_batch_header%ROWTYPE;
11618: l_batch_step_rec gme_batch_steps%ROWTYPE;
11619: l_batch_step_rec2 gme_batch_steps%ROWTYPE;
11620: l_return_status VARCHAR2 (2);
11621: l_step_status NUMBER;