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_STEPS

Line 2020: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

2016: p_api_version IN NUMBER := 2.0
2017: ,p_validation_level IN NUMBER
2018: ,p_init_msg_list IN VARCHAR2
2019: ,p_commit IN VARCHAR2
2020: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
2021: ,p_use_workday_cal IN VARCHAR2
2022: ,p_contiguity_override IN VARCHAR2
2023: ,p_org_code IN VARCHAR2
2024: ,p_batch_no IN VARCHAR2

Line 2031: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)

2027: ,p_reschedule_succeeding IN VARCHAR2
2028: ,x_message_count OUT NOCOPY NUMBER
2029: ,x_message_list OUT NOCOPY VARCHAR2
2030: ,x_return_status OUT NOCOPY VARCHAR2
2031: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)
2032: IS
2033: l_api_name CONSTANT VARCHAR2 (30) := 'RESCHEDULE_STEP';
2034: l_diff NUMBER := 0;
2035: l_diff_cmplt NUMBER := 0;

Line 2038: l_batch_step_rec gme_batch_steps%ROWTYPE;

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);
2042: l_reschedule_succeeding VARCHAR2 (1);

Line 2950: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE)

2946: ,p_batch_no IN VARCHAR2
2947: ,x_message_count OUT NOCOPY NUMBER
2948: ,x_message_list OUT NOCOPY VARCHAR2
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;

Line 3051: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

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
3055: ,x_return_status OUT NOCOPY VARCHAR2)

Line 3052: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE

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
3055: ,x_return_status OUT NOCOPY VARCHAR2)
3056: IS

Line 3318: l_batch_step_rec gme_batch_steps%ROWTYPE;

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;
3321: l_locator_id NUMBER;
3322:

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

3380: IF l_batch_header_rec.poc_ind = 'Y' AND
3381: p_batchstep_no IS NOT NULL THEN
3382: l_batch_step_rec.batch_id := l_batch_header_rec.batch_id;
3383: l_batch_step_rec.batchstep_no := p_batchstep_no;
3384: IF NOT gme_batch_steps_dbl.fetch_row(l_batch_step_rec, l_batch_step_rec) THEN
3385: RAISE fnd_api.g_exc_error;
3386: END IF;
3387: END IF;
3388:

Line 3549: l_batch_step_rec gme_batch_steps%ROWTYPE;

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;
3552: p_trans_id NUMBER;
3553: l_subinventory VARCHAR2(30);

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

3621: FETCH c_get_step_id INTO l_batchstep_id;
3622: IF c_get_step_id%FOUND THEN
3623: l_batch_step_rec.batchstep_id := l_batchstep_id;
3624:
3625: IF NOT gme_batch_steps_dbl.fetch_row(l_batch_step_rec, l_batch_step_rec) THEN
3626: CLOSE c_get_step_id;
3627: RAISE fnd_api.g_exc_error;
3628: END IF;
3629: END IF;

Line 3785: l_batch_step_rec gme_batch_steps%ROWTYPE;

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:
3788: l_batchstep_id NUMBER;
3789: x_transacted VARCHAR2(30);

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

3841: FETCH c_get_step_id INTO l_batchstep_id;
3842: IF c_get_step_id%FOUND THEN
3843: l_batch_step_rec.batchstep_id := l_batchstep_id;
3844:
3845: IF NOT gme_batch_steps_dbl.fetch_row(l_batch_step_rec, l_batch_step_rec) THEN
3846: CLOSE c_get_step_id;
3847: RAISE fnd_api.g_exc_error;
3848: END IF;
3849: END IF;

Line 4089: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

4085: ,x_message_list OUT NOCOPY VARCHAR2
4086: ,x_return_status OUT NOCOPY VARCHAR2
4087: ,p_org_code IN VARCHAR2
4088: ,p_batch_no IN VARCHAR2
4089: ,p_batch_step_rec IN gme_batch_steps%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;

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

4086: ,x_return_status OUT NOCOPY VARCHAR2
4087: ,p_org_code IN VARCHAR2
4088: ,p_batch_no IN VARCHAR2
4089: ,p_batch_step_rec IN gme_batch_steps%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;

Line 4093: l_batch_step_rec gme_batch_steps%ROWTYPE;

4089: ,p_batch_step_rec IN gme_batch_steps%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

Line 4376: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

4372: ,p_commit IN VARCHAR2
4373: ,x_message_count OUT NOCOPY NUMBER
4374: ,x_message_list OUT NOCOPY VARCHAR2
4375: ,x_return_status OUT NOCOPY VARCHAR2
4376: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
4377: ,p_delete_pending IN VARCHAR2 := fnd_api.g_false
4378: ,p_org_code IN VARCHAR2
4379: ,p_batch_no IN VARCHAR2
4380: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)

Line 4380: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)

4376: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
4377: ,p_delete_pending IN VARCHAR2 := fnd_api.g_false
4378: ,p_org_code IN VARCHAR2
4379: ,p_batch_no IN VARCHAR2
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;

Line 4385: l_batch_step_rec 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
4389: IF g_debug <= gme_debug.g_log_procedure THEN

Line 4629: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

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';
4633: l_batch_header_rec gme_batch_header%ROWTYPE;

Line 4630: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)

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';
4633: l_batch_header_rec gme_batch_header%ROWTYPE;
4634: l_batch_step_rec gme_batch_steps%ROWTYPE;

Line 4634: l_batch_step_rec 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
4638: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

Line 6615: FROM gme_batch_steps

6611:
6612: CURSOR cur_get_step_status (v_batch_id NUMBER, v_batchstep_id NUMBER)
6613: IS
6614: SELECT step_status
6615: FROM gme_batch_steps
6616: WHERE batch_id = v_batch_id AND batchstep_id = v_batchstep_id;
6617: BEGIN
6618: IF (g_debug <> -1) THEN
6619: gme_debug.log_initialize ('InsertBatchstepResource');

Line 6840: ,'GME_BATCH_STEPS');

6836: CLOSE cur_get_step_status;
6837:
6838: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
6839: ,'TABLE_NAME'
6840: ,'GME_BATCH_STEPS');
6841: RAISE fnd_api.g_exc_error;
6842: END IF;
6843:
6844: IF g_debug <= gme_debug.g_log_statement THEN

Line 7019: FROM gme_batch_steps

7015: v_batchstep_id NUMBER
7016: ,v_batch_id NUMBER)
7017: IS
7018: SELECT step_status
7019: FROM gme_batch_steps
7020: WHERE batchstep_id = v_batchstep_id AND batch_id = v_batch_id;
7021:
7022: update_rsrc_failed EXCEPTION;
7023: BEGIN

Line 7314: FROM gme_batch_steps a

7310: CURSOR cur_get_step_dtl (v_batchstep_rsrc_id NUMBER)
7311: IS
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

Line 9450: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

9446: ,p_commit IN VARCHAR2 := fnd_api.g_false
9447: ,x_message_count OUT NOCOPY NUMBER
9448: ,x_message_list OUT NOCOPY VARCHAR2
9449: ,x_return_status OUT NOCOPY VARCHAR2
9450: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
9451: ,p_batch_no IN VARCHAR2
9452: ,p_org_code IN VARCHAR2
9453: ,p_create_resv_pend_lots IN NUMBER
9454: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)

Line 9454: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)

9450: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
9451: ,p_batch_no IN VARCHAR2
9452: ,p_org_code IN VARCHAR2
9453: ,p_create_resv_pend_lots IN NUMBER
9454: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)
9455: IS
9456: l_api_name CONSTANT VARCHAR2 (30) := 'UNRELEASE_STEP';
9457:
9458: l_in_batch_step_rec gme_batch_steps%ROWTYPE;

Line 9458: l_in_batch_step_rec gme_batch_steps%ROWTYPE;

9454: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)
9455: IS
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:

Line 9459: l_batch_step_rec gme_batch_steps%ROWTYPE;

9455: IS
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;

Line 9864: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

9860: ,p_commit IN VARCHAR2 := fnd_api.g_false
9861: ,x_message_count OUT NOCOPY NUMBER
9862: ,x_message_list OUT NOCOPY VARCHAR2
9863: ,x_return_status OUT NOCOPY VARCHAR2
9864: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
9865: ,p_batch_no IN VARCHAR2
9866: ,p_org_code IN VARCHAR2
9867: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
9868: ,p_override_quality IN VARCHAR2 := fnd_api.g_false

Line 9870: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE

9866: ,p_org_code IN VARCHAR2
9867: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
9868: ,p_override_quality IN VARCHAR2 := fnd_api.g_false
9869: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
9870: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
9871: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab)
9872: IS
9873: l_api_name CONSTANT VARCHAR2 (30) := 'COMPLETE_STEP';
9874:

Line 9875: l_in_batch_step_rec gme_batch_steps%ROWTYPE;

9871: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab)
9872: IS
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;

Line 9876: l_batch_step_rec gme_batch_steps%ROWTYPE;

9872: IS
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:

Line 10318: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

10314: ,p_commit IN VARCHAR2 := fnd_api.g_false
10315: ,x_message_count OUT NOCOPY NUMBER
10316: ,x_message_list OUT NOCOPY VARCHAR2
10317: ,x_return_status OUT NOCOPY VARCHAR2
10318: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
10319: ,p_batch_no IN VARCHAR2
10320: ,p_org_code IN VARCHAR2
10321: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
10322: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false

Line 10323: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE

10319: ,p_batch_no IN VARCHAR2
10320: ,p_org_code IN VARCHAR2
10321: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
10322: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
10323: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
10324: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab)
10325: IS
10326: l_api_name CONSTANT VARCHAR2 (30) := 'RELEASE_STEP';
10327:

Line 10328: l_in_batch_step_rec gme_batch_steps%ROWTYPE;

10324: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab)
10325: IS
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:

Line 10329: l_batch_step_rec gme_batch_steps%ROWTYPE;

10325: IS
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;