APPS.GME_COMPLETE_BATCH_PVT dependencies on GME_BATCH_STEPS

Line 20: FROM gme_batch_steps s, gme_batch_step_items item

16:
17:
18: CURSOR Cur_associated_step(v_matl_dtl_id NUMBER) IS
19: SELECT step_status
20: FROM gme_batch_steps s, gme_batch_step_items item
21: WHERE s.batchstep_id = item.batchstep_id
22: AND item.material_detail_id = v_matl_dtl_id;
23:
24: CURSOR Cur_get_step_to_complete(v_batch_id NUMBER) IS

Line 26: FROM gme_batch_steps

22: AND item.material_detail_id = v_matl_dtl_id;
23:
24: CURSOR Cur_get_step_to_complete(v_batch_id NUMBER) IS
25: SELECT *
26: FROM gme_batch_steps
27: WHERE batch_id = v_batch_id
28: AND step_status NOT IN (gme_common_pvt.g_step_completed, gme_common_pvt.g_step_closed);
29:
30: CURSOR Cur_get_phantom_batch(v_batch_id NUMBER) IS

Line 66: l_batch_step_rec gme_batch_steps%ROWTYPE;

62: l_btch_hdr_tab gme_common_pvt.batch_headers_tab;
63: l_matl_dtl gme_material_details%ROWTYPE;
64: l_matl_dtl_rec gme_material_details%ROWTYPE;
65: l_step_tab gme_common_pvt.steps_tab;
66: l_batch_step_rec gme_batch_steps%ROWTYPE;
67: l_yield_type NUMBER;
68: l_phantom_batch gme_batch_header%ROWTYPE;
69: l_phantom_batch_rec gme_batch_header%ROWTYPE;
70: l_item_rec mtl_system_items_b%ROWTYPE;

Line 1164: CURSOR Cur_gme_batch_steps (v_batch_id NUMBER) IS

1160: ,x_return_status OUT NOCOPY VARCHAR2) IS
1161:
1162: l_api_name CONSTANT VARCHAR2 (30) := 'validate_batch_for_complete';
1163:
1164: CURSOR Cur_gme_batch_steps (v_batch_id NUMBER) IS
1165: SELECT count(1)
1166: FROM gme_batch_steps
1167: WHERE step_status NOT IN (gme_common_pvt.g_step_completed, gme_common_pvt.g_step_closed)
1168: AND batch_id = v_batch_id

Line 1166: FROM gme_batch_steps

1162: l_api_name CONSTANT VARCHAR2 (30) := 'validate_batch_for_complete';
1163:
1164: CURSOR Cur_gme_batch_steps (v_batch_id NUMBER) IS
1165: SELECT count(1)
1166: FROM gme_batch_steps
1167: WHERE step_status NOT IN (gme_common_pvt.g_step_completed, gme_common_pvt.g_step_closed)
1168: AND batch_id = v_batch_id
1169: AND rownum = 1;
1170:

Line 1228: OPEN Cur_gme_batch_steps (p_batch_header_rec.batch_id);

1224: END IF;
1225:
1226: -- Bug 11855868 - Check steps only when enforce step dependency is on.
1227: IF p_batch_header_rec.enforce_step_dependency = 1 THEN
1228: OPEN Cur_gme_batch_steps (p_batch_header_rec.batch_id);
1229: FETCH Cur_gme_batch_steps INTO l_is_step;
1230: CLOSE Cur_gme_batch_steps;
1231:
1232: -- Bug 11855868 - Changed condition to compare against zero.

Line 1229: FETCH Cur_gme_batch_steps INTO l_is_step;

1225:
1226: -- Bug 11855868 - Check steps only when enforce step dependency is on.
1227: IF p_batch_header_rec.enforce_step_dependency = 1 THEN
1228: OPEN Cur_gme_batch_steps (p_batch_header_rec.batch_id);
1229: FETCH Cur_gme_batch_steps INTO l_is_step;
1230: CLOSE Cur_gme_batch_steps;
1231:
1232: -- Bug 11855868 - Changed condition to compare against zero.
1233: -- IF l_is_step > 1 THEN

Line 1230: CLOSE Cur_gme_batch_steps;

1226: -- Bug 11855868 - Check steps only when enforce step dependency is on.
1227: IF p_batch_header_rec.enforce_step_dependency = 1 THEN
1228: OPEN Cur_gme_batch_steps (p_batch_header_rec.batch_id);
1229: FETCH Cur_gme_batch_steps INTO l_is_step;
1230: CLOSE Cur_gme_batch_steps;
1231:
1232: -- Bug 11855868 - Changed condition to compare against zero.
1233: -- IF l_is_step > 1 THEN
1234: IF l_is_step > 0 THEN