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.

[Home] [Help]

APPS.GME_API_MAIN dependencies on GME_BATCH_STEPS

Line 452: l_batch_step_rec gme_batch_steps%ROWTYPE;

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

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

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

Line 623: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

619: ,x_message_list OUT NOCOPY VARCHAR2
620: ,x_return_status OUT NOCOPY VARCHAR2
621: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
622: ,p_material_detail_rec IN gme_material_details%ROWTYPE
623: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
624: ,p_trans_id IN NUMBER
625: ,x_transacted OUT NOCOPY VARCHAR2
626: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE)
627: IS

Line 750: l_in_batch_step_rec gme_batch_steps%ROWTYPE;

746: IS
747: l_api_name CONSTANT VARCHAR2 (30) := 'update_material_line_form';
748:
749: l_stored_material_detail_rec gme_material_details%ROWTYPE;
750: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
751: l_batch_step_rec gme_batch_steps%ROWTYPE;
752: upd_mtl_line_failure EXCEPTION;
753: setup_failure EXCEPTION;
754:

Line 751: l_batch_step_rec gme_batch_steps%ROWTYPE;

747: l_api_name CONSTANT VARCHAR2 (30) := 'update_material_line_form';
748:
749: l_stored_material_detail_rec gme_material_details%ROWTYPE;
750: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
751: l_batch_step_rec gme_batch_steps%ROWTYPE;
752: upd_mtl_line_failure EXCEPTION;
753: setup_failure EXCEPTION;
754:
755: -- Bug 13070352

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

792:
793: IF p_batch_step_id IS NOT NULL THEN
794: l_batch_step_rec.batchstep_id := p_batch_step_id;
795:
796: IF NOT gme_batch_steps_dbl.fetch_row(l_batch_step_rec, l_batch_step_rec) THEN
797: RAISE fnd_api.g_exc_error;
798: END IF;
799: END IF;
800:

Line 938: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

934: ,x_return_status OUT NOCOPY VARCHAR2
935: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
936: ,p_material_detail_rec IN gme_material_details%ROWTYPE
937: ,p_stored_material_detail_rec IN gme_material_details%ROWTYPE
938: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
939: ,p_scale_phantom IN VARCHAR2
940: := fnd_api.g_false
941: ,p_trans_id IN NUMBER
942: ,x_transacted OUT NOCOPY VARCHAR2

Line 1063: l_batch_step_rec gme_batch_steps%ROWTYPE;

1059: ,x_transacted OUT NOCOPY VARCHAR2)
1060: IS
1061: l_api_name CONSTANT VARCHAR2 (30) := 'delete_material_line_form';
1062:
1063: l_batch_step_rec gme_batch_steps%ROWTYPE;
1064:
1065: del_mtl_line_failure EXCEPTION;
1066: setup_failure EXCEPTION;
1067:

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

1106:
1107: IF p_batch_step_id IS NOT NULL THEN
1108: l_batch_step_rec.batchstep_id := p_batch_step_id;
1109:
1110: IF NOT gme_batch_steps_dbl.fetch_row(l_batch_step_rec, l_batch_step_rec) THEN
1111: RAISE fnd_api.g_exc_error;
1112: END IF;
1113: END IF;
1114:

Line 1228: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

1224: ,x_message_list OUT NOCOPY VARCHAR2
1225: ,x_return_status OUT NOCOPY VARCHAR2
1226: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1227: ,p_material_detail_rec IN gme_material_details%ROWTYPE
1228: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
1229: ,x_transacted OUT NOCOPY VARCHAR2)
1230: IS
1231: l_api_name CONSTANT VARCHAR2 (30) := 'delete_material_line';
1232: del_mtl_line_failure EXCEPTION;

Line 1440: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

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

Line 1448: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)

1444: ,p_contiguity_override IN VARCHAR2
1445: ,x_message_count OUT NOCOPY NUMBER
1446: ,x_message_list OUT NOCOPY VARCHAR2
1447: ,x_return_status OUT NOCOPY VARCHAR2
1448: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)
1449: IS
1450: l_api_name CONSTANT VARCHAR2 (30) := 'RESCHEDULE_STEP';
1451: l_diff NUMBER := 0;
1452: l_diff_cmplt NUMBER := 0;

Line 1453: l_batch_step gme_batch_steps%ROWTYPE;

1449: IS
1450: l_api_name CONSTANT VARCHAR2 (30) := 'RESCHEDULE_STEP';
1451: l_diff NUMBER := 0;
1452: l_diff_cmplt NUMBER := 0;
1453: l_batch_step gme_batch_steps%ROWTYPE;
1454: l_step_tbl gme_reschedule_step_pvt.step_tab;
1455: setup_failure EXCEPTION;
1456: reschedule_step_failed EXCEPTION;
1457: expected_error EXCEPTION;

Line 1917: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

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

Line 1919: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE

1915: ,x_message_list OUT NOCOPY VARCHAR2
1916: ,x_return_status OUT NOCOPY VARCHAR2
1917: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
1918: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1919: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
1920: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
1921: ,p_ignore_exception IN VARCHAR2 := NULL) --Bug#5186328
1922: IS
1923: l_api_name CONSTANT VARCHAR2 (30) := 'RELEASE_STEP';

Line 2146: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

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

Line 2148: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE

2144: ,x_message_list OUT NOCOPY VARCHAR2
2145: ,x_return_status OUT NOCOPY VARCHAR2
2146: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
2147: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2148: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
2149: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
2150: ,p_ignore_exception IN VARCHAR2 := NULL) --Bug#5186328
2151: IS
2152: l_api_name CONSTANT VARCHAR2 (30) := 'COMPLETE_STEP';

Line 2262: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

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

Line 2379: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

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

Line 2380: ,x_batch_step OUT NOCOPY gme_batch_steps%ROWTYPE)

2376: ,x_message_list OUT NOCOPY VARCHAR2
2377: ,x_return_status OUT NOCOPY VARCHAR2
2378: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2379: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
2380: ,x_batch_step OUT NOCOPY gme_batch_steps%ROWTYPE)
2381: IS
2382: l_api_name CONSTANT VARCHAR2 (30) := 'INSERT_STEP';
2383: l_batch_header gme_batch_header%ROWTYPE;
2384: insert_step_failed EXCEPTION;

Line 2639: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

2635: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2636: ,x_message_count OUT NOCOPY NUMBER
2637: ,x_message_list OUT NOCOPY VARCHAR2
2638: ,x_return_status OUT NOCOPY VARCHAR2
2639: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
2640: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2641: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)IS
2642:
2643:

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

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

Line 2877: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

2873: ,x_message_count OUT NOCOPY NUMBER
2874: ,x_message_list OUT NOCOPY VARCHAR2
2875: ,x_return_status OUT NOCOPY VARCHAR2
2876: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2877: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
2878: ,p_delete_pending IN VARCHAR2 := fnd_api.g_false
2879: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)
2880: IS
2881: l_api_name CONSTANT VARCHAR2 (30) := 'CLOSE_STEP';

Line 2879: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)

2875: ,x_return_status OUT NOCOPY VARCHAR2
2876: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2877: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
2878: ,p_delete_pending IN VARCHAR2 := fnd_api.g_false
2879: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)
2880: IS
2881: l_api_name CONSTANT VARCHAR2 (30) := 'CLOSE_STEP';
2882: setup_failure EXCEPTION;
2883: batch_save_failed EXCEPTION;

Line 3111: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

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

Line 3112: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)

3108: ,x_message_list OUT NOCOPY VARCHAR2
3109: ,x_return_status OUT NOCOPY VARCHAR2
3110: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3111: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
3112: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)
3113: IS
3114: l_api_name CONSTANT VARCHAR2 (30) := 'REOPEN_STEP';
3115: setup_failure EXCEPTION;
3116: step_save_failed EXCEPTION;

Line 4020: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

4016: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
4017: ,x_message_count OUT NOCOPY NUMBER
4018: ,x_message_list OUT NOCOPY VARCHAR2
4019: ,x_return_status OUT NOCOPY VARCHAR2
4020: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
4021: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
4022: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
4023: ,p_create_resv_pend_lots IN NUMBER)
4024: IS

Line 4022: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE

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