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 1088: CURSOR Cur_gme_batch_steps (v_batch_id NUMBER) IS

1084: ,x_return_status OUT NOCOPY VARCHAR2) IS
1085:
1086: l_api_name CONSTANT VARCHAR2 (30) := 'validate_batch_for_complete';
1087:
1088: CURSOR Cur_gme_batch_steps (v_batch_id NUMBER) IS
1089: SELECT count(1)
1090: FROM gme_batch_steps
1091: WHERE step_status NOT IN (gme_common_pvt.g_step_completed, gme_common_pvt.g_step_closed)
1092: AND batch_id = v_batch_id

Line 1090: FROM gme_batch_steps

1086: l_api_name CONSTANT VARCHAR2 (30) := 'validate_batch_for_complete';
1087:
1088: CURSOR Cur_gme_batch_steps (v_batch_id NUMBER) IS
1089: SELECT count(1)
1090: FROM gme_batch_steps
1091: WHERE step_status NOT IN (gme_common_pvt.g_step_completed, gme_common_pvt.g_step_closed)
1092: AND batch_id = v_batch_id
1093: AND rownum = 1;
1094:

Line 1150: OPEN Cur_gme_batch_steps (p_batch_header_rec.batch_id);

1146: IF p_batch_header_rec.parentline_id IS NOT NULL THEN
1147: RAISE error_phantom;
1148: END IF;
1149:
1150: OPEN Cur_gme_batch_steps (p_batch_header_rec.batch_id);
1151: FETCH Cur_gme_batch_steps INTO l_is_step;
1152: CLOSE Cur_gme_batch_steps;
1153:
1154: IF l_is_step > 1 THEN

Line 1151: FETCH Cur_gme_batch_steps INTO l_is_step;

1147: RAISE error_phantom;
1148: END IF;
1149:
1150: OPEN Cur_gme_batch_steps (p_batch_header_rec.batch_id);
1151: FETCH Cur_gme_batch_steps INTO l_is_step;
1152: CLOSE Cur_gme_batch_steps;
1153:
1154: IF l_is_step > 1 THEN
1155: RAISE error_steps_not_complete;

Line 1152: CLOSE Cur_gme_batch_steps;

1148: END IF;
1149:
1150: OPEN Cur_gme_batch_steps (p_batch_header_rec.batch_id);
1151: FETCH Cur_gme_batch_steps INTO l_is_step;
1152: CLOSE Cur_gme_batch_steps;
1153:
1154: IF l_is_step > 1 THEN
1155: RAISE error_steps_not_complete;
1156: END IF;