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_MAIN dependencies on GME_BATCH_STEPS

Line 450: l_batch_step_rec gme_batch_steps%ROWTYPE;

446: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE)
447: IS
448: l_api_name CONSTANT VARCHAR2 (30) := 'insert_material_line_form';
449:
450: l_batch_step_rec gme_batch_steps%ROWTYPE;
451: setup_failure EXCEPTION;
452: ins_mtl_line_failure EXCEPTION;
453:
454: -- Bug 5903208

Line 495: IF NOT gme_batch_steps_dbl.fetch_row(l_batch_step_rec, l_batch_step_rec) THEN

491:
492: IF p_batch_step_id IS NOT NULL THEN
493: l_batch_step_rec.batchstep_id := p_batch_step_id;
494:
495: IF NOT gme_batch_steps_dbl.fetch_row(l_batch_step_rec, l_batch_step_rec) THEN
496: RAISE fnd_api.g_exc_error;
497: END IF;
498: END IF;
499:

Line 609: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

605: ,x_message_list OUT NOCOPY VARCHAR2
606: ,x_return_status OUT NOCOPY VARCHAR2
607: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
608: ,p_material_detail_rec IN gme_material_details%ROWTYPE
609: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
610: ,p_trans_id IN NUMBER
611: ,x_transacted OUT NOCOPY VARCHAR2
612: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE)
613: IS

Line 736: l_in_batch_step_rec gme_batch_steps%ROWTYPE;

732: IS
733: l_api_name CONSTANT VARCHAR2 (30) := 'update_material_line_form';
734:
735: l_stored_material_detail_rec gme_material_details%ROWTYPE;
736: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
737: l_batch_step_rec gme_batch_steps%ROWTYPE;
738: upd_mtl_line_failure EXCEPTION;
739: setup_failure EXCEPTION;
740: BEGIN

Line 737: l_batch_step_rec gme_batch_steps%ROWTYPE;

733: l_api_name CONSTANT VARCHAR2 (30) := 'update_material_line_form';
734:
735: l_stored_material_detail_rec gme_material_details%ROWTYPE;
736: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
737: l_batch_step_rec gme_batch_steps%ROWTYPE;
738: upd_mtl_line_failure EXCEPTION;
739: setup_failure EXCEPTION;
740: BEGIN
741:

Line 777: IF NOT gme_batch_steps_dbl.fetch_row(l_batch_step_rec, l_batch_step_rec) THEN

773:
774: IF p_batch_step_id IS NOT NULL THEN
775: l_batch_step_rec.batchstep_id := p_batch_step_id;
776:
777: IF NOT gme_batch_steps_dbl.fetch_row(l_batch_step_rec, l_batch_step_rec) THEN
778: RAISE fnd_api.g_exc_error;
779: END IF;
780: END IF;
781:

Line 886: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

882: ,x_return_status OUT NOCOPY VARCHAR2
883: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
884: ,p_material_detail_rec IN gme_material_details%ROWTYPE
885: ,p_stored_material_detail_rec IN gme_material_details%ROWTYPE
886: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
887: ,p_scale_phantom IN VARCHAR2
888: := fnd_api.g_false
889: ,p_trans_id IN NUMBER
890: ,x_transacted OUT NOCOPY VARCHAR2

Line 1010: l_batch_step_rec gme_batch_steps%ROWTYPE;

1006: ,x_transacted OUT NOCOPY VARCHAR2)
1007: IS
1008: l_api_name CONSTANT VARCHAR2 (30) := 'delete_material_line_form';
1009:
1010: l_batch_step_rec gme_batch_steps%ROWTYPE;
1011:
1012: del_mtl_line_failure EXCEPTION;
1013: setup_failure EXCEPTION;
1014:

Line 1057: IF NOT gme_batch_steps_dbl.fetch_row(l_batch_step_rec, l_batch_step_rec) THEN

1053:
1054: IF p_batch_step_id IS NOT NULL THEN
1055: l_batch_step_rec.batchstep_id := p_batch_step_id;
1056:
1057: IF NOT gme_batch_steps_dbl.fetch_row(l_batch_step_rec, l_batch_step_rec) THEN
1058: RAISE fnd_api.g_exc_error;
1059: END IF;
1060: END IF;
1061:

Line 1170: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

1166: ,x_message_list OUT NOCOPY VARCHAR2
1167: ,x_return_status OUT NOCOPY VARCHAR2
1168: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1169: ,p_material_detail_rec IN gme_material_details%ROWTYPE
1170: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
1171: ,x_transacted OUT NOCOPY VARCHAR2)
1172: IS
1173: l_api_name CONSTANT VARCHAR2 (30) := 'delete_material_line';
1174: del_mtl_line_failure EXCEPTION;

Line 1382: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

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

Line 1390: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)

1386: ,p_contiguity_override IN VARCHAR2
1387: ,x_message_count OUT NOCOPY NUMBER
1388: ,x_message_list OUT NOCOPY VARCHAR2
1389: ,x_return_status OUT NOCOPY VARCHAR2
1390: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)
1391: IS
1392: l_api_name CONSTANT VARCHAR2 (30) := 'RESCHEDULE_STEP';
1393: l_diff NUMBER := 0;
1394: l_diff_cmplt NUMBER := 0;

Line 1395: l_batch_step gme_batch_steps%ROWTYPE;

1391: IS
1392: l_api_name CONSTANT VARCHAR2 (30) := 'RESCHEDULE_STEP';
1393: l_diff NUMBER := 0;
1394: l_diff_cmplt NUMBER := 0;
1395: l_batch_step gme_batch_steps%ROWTYPE;
1396: l_step_tbl gme_reschedule_step_pvt.step_tab;
1397: setup_failure EXCEPTION;
1398: reschedule_step_failed EXCEPTION;
1399: expected_error EXCEPTION;

Line 1856: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

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

Line 1858: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE

1854: ,x_message_list OUT NOCOPY VARCHAR2
1855: ,x_return_status OUT NOCOPY VARCHAR2
1856: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
1857: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1858: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
1859: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
1860: ,p_ignore_exception IN VARCHAR2 := NULL) --Bug#5186328
1861: IS
1862: l_api_name CONSTANT VARCHAR2 (30) := 'RELEASE_STEP';

Line 2085: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

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

Line 2087: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE

2083: ,x_message_list OUT NOCOPY VARCHAR2
2084: ,x_return_status OUT NOCOPY VARCHAR2
2085: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
2086: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2087: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
2088: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
2089: ,p_ignore_exception IN VARCHAR2 := NULL) --Bug#5186328
2090: IS
2091: l_api_name CONSTANT VARCHAR2 (30) := 'COMPLETE_STEP';

Line 2201: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

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

Line 2318: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

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

Line 2319: ,x_batch_step OUT NOCOPY gme_batch_steps%ROWTYPE)

2315: ,x_message_list OUT NOCOPY VARCHAR2
2316: ,x_return_status OUT NOCOPY VARCHAR2
2317: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2318: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
2319: ,x_batch_step OUT NOCOPY gme_batch_steps%ROWTYPE)
2320: IS
2321: l_api_name CONSTANT VARCHAR2 (30) := 'INSERT_STEP';
2322: l_batch_header gme_batch_header%ROWTYPE;
2323: insert_step_failed EXCEPTION;

Line 2578: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

2574: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2575: ,x_message_count OUT NOCOPY NUMBER
2576: ,x_message_list OUT NOCOPY VARCHAR2
2577: ,x_return_status OUT NOCOPY VARCHAR2
2578: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
2579: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2580: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)IS
2581:
2582:

Line 2580: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)IS

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

Line 2816: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

2812: ,x_message_count OUT NOCOPY NUMBER
2813: ,x_message_list OUT NOCOPY VARCHAR2
2814: ,x_return_status OUT NOCOPY VARCHAR2
2815: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2816: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
2817: ,p_delete_pending IN VARCHAR2 := fnd_api.g_false
2818: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)
2819: IS
2820: l_api_name CONSTANT VARCHAR2 (30) := 'CLOSE_STEP';

Line 2818: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)

2814: ,x_return_status OUT NOCOPY VARCHAR2
2815: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2816: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
2817: ,p_delete_pending IN VARCHAR2 := fnd_api.g_false
2818: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)
2819: IS
2820: l_api_name CONSTANT VARCHAR2 (30) := 'CLOSE_STEP';
2821: setup_failure EXCEPTION;
2822: batch_save_failed EXCEPTION;

Line 3050: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

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

Line 3051: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)

3047: ,x_message_list OUT NOCOPY VARCHAR2
3048: ,x_return_status OUT NOCOPY VARCHAR2
3049: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3050: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
3051: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)
3052: IS
3053: l_api_name CONSTANT VARCHAR2 (30) := 'REOPEN_STEP';
3054: setup_failure EXCEPTION;
3055: step_save_failed EXCEPTION;

Line 3920: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

3916: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
3917: ,x_message_count OUT NOCOPY NUMBER
3918: ,x_message_list OUT NOCOPY VARCHAR2
3919: ,x_return_status OUT NOCOPY VARCHAR2
3920: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
3921: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3922: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
3923: ,p_create_resv_pend_lots IN NUMBER)
3924: IS

Line 3922: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE

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