APPS.GME_CLOSE_BATCH_PVT dependencies on GME_BATCH_STEPS

Line 38: l_batch_step gme_batch_steps%ROWTYPE;

34: l_error_count NUMBER;
35: l_row_count NUMBER;
36: l_return_status VARCHAR2 (1);
37: l_ins_history gme_batch_history%ROWTYPE;
38: l_batch_step gme_batch_steps%ROWTYPE;
39: l_batch_steps_tab gme_close_batch_pvt.step_details_tab;
40: l_batch_header gme_batch_header%ROWTYPE;
41: l_in_batch_header gme_batch_header%ROWTYPE;
42: l_material_detail_ids gme_common_pvt.number_tab;

Line 99: CURSOR cur_gme_batch_steps

95: FROM gme_material_details
96: WHERE batch_id = v_batch_id
97: FOR UPDATE OF actual_qty NOWAIT;
98:
99: CURSOR cur_gme_batch_steps
100: IS
101: SELECT COUNT (*)
102: FROM gme_batch_steps
103: WHERE step_status < 4 AND batch_id = x_batch_header_rec.batch_id;

Line 102: FROM gme_batch_steps

98:
99: CURSOR cur_gme_batch_steps
100: IS
101: SELECT COUNT (*)
102: FROM gme_batch_steps
103: WHERE step_status < 4 AND batch_id = x_batch_header_rec.batch_id;
104:
105: /* siva FPbug#4684029 */
106: CURSOR cur_get_prod (v_batch_id NUMBER)

Line 166: OPEN cur_gme_batch_steps;

162:
163: /* Bharati Satpute Bug2395188 Added check for enforce step dependency */
164: IF x_batch_header_rec.poc_ind = 'Y' THEN
165: IF x_batch_header_rec.enforce_step_dependency = 1 THEN
166: OPEN cur_gme_batch_steps;
167:
168: FETCH cur_gme_batch_steps
169: INTO l_step_count;
170:

Line 168: FETCH cur_gme_batch_steps

164: IF x_batch_header_rec.poc_ind = 'Y' THEN
165: IF x_batch_header_rec.enforce_step_dependency = 1 THEN
166: OPEN cur_gme_batch_steps;
167:
168: FETCH cur_gme_batch_steps
169: INTO l_step_count;
170:
171: CLOSE cur_gme_batch_steps;
172:

Line 171: CLOSE cur_gme_batch_steps;

167:
168: FETCH cur_gme_batch_steps
169: INTO l_step_count;
170:
171: CLOSE cur_gme_batch_steps;
172:
173: IF l_step_count > 0 THEN
174: RAISE steps_not_closed;
175: END IF; /*l_step_count > 0*/

Line 463: FROM gme_batch_steps

459: IS
460: CURSOR cur_batch_steps (v_batch_id NUMBER)
461: IS
462: SELECT step_close_date
463: FROM gme_batch_steps
464: WHERE batch_id IN (
465: SELECT DISTINCT batch_id
466: FROM gme_material_details
467: START WITH batch_id =

Line 698: FROM gme_batch_steps

694:
695: CURSOR cur_get_step_rec (v_batch_id NUMBER, v_step_id NUMBER)
696: IS
697: SELECT *
698: FROM gme_batch_steps
699: WHERE batch_id = v_batch_id AND batchstep_id = v_step_id;
700:
701: CURSOR cur_get_final_steps (v_batch_id NUMBER)
702: IS

Line 704: FROM gme_batch_steps s

700:
701: CURSOR cur_get_final_steps (v_batch_id NUMBER)
702: IS
703: SELECT *
704: FROM gme_batch_steps s
705: WHERE s.batch_id = v_batch_id
706: AND s.batchstep_id NOT IN (SELECT dep_step_id
707: FROM gme_batch_step_dependencies
708: WHERE batch_id = v_batch_id)

Line 713: l_step_rec gme_batch_steps%ROWTYPE;

709: ORDER BY batchstep_no;
710:
711: /* Buffer records for database read.
712: ===================================*/
713: l_step_rec gme_batch_steps%ROWTYPE;
714: /* Exceptions.
715: =====================*/
716: no_routing_associated EXCEPTION;
717: step_details_missing EXCEPTION;