APPS.GME_UNRELEASE_STEP_PVT dependencies on GME_BATCH_STEPS

Line 22: p_batch_step_rec IN gme_batch_steps%ROWTYPE

18: E - Error
19: U - Unexpected error
20: =============================================================================*/
21: PROCEDURE unrelease_step (
22: p_batch_step_rec IN gme_batch_steps%ROWTYPE
23: ,p_update_inventory_ind IN VARCHAR2
24: ,p_create_resv_pend_lots IN NUMBER
25: ,p_from_unrelease_batch IN NUMBER
26: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE

Line 26: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE

22: p_batch_step_rec IN gme_batch_steps%ROWTYPE
23: ,p_update_inventory_ind IN VARCHAR2
24: ,p_create_resv_pend_lots IN NUMBER
25: ,p_from_unrelease_batch IN NUMBER
26: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
27: ,x_return_status OUT NOCOPY VARCHAR2)
28: IS
29: CURSOR cur_get_step_materials (
30: v_batch_id gme_batch_header.batch_id%TYPE

Line 31: ,v_batchstep_id gme_batch_steps.batchstep_id%TYPE)

27: ,x_return_status OUT NOCOPY VARCHAR2)
28: IS
29: CURSOR cur_get_step_materials (
30: v_batch_id gme_batch_header.batch_id%TYPE
31: ,v_batchstep_id gme_batch_steps.batchstep_id%TYPE)
32: IS
33: SELECT d.*
34: FROM gme_batch_step_items i, gme_material_details d
35: WHERE d.batch_id = v_batch_id

Line 43: l_in_batch_step_rec gme_batch_steps%ROWTYPE;

39:
40: l_api_name CONSTANT VARCHAR2 (30) := 'unrelease_step';
41: l_material_detail_tbl gme_common_pvt.material_details_tab;
42: l_material_detail_rec gme_material_details%ROWTYPE;
43: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
44: l_msg_count NUMBER;
45: l_msg_stack VARCHAR2 (2000);
46: l_lock_status VARCHAR2(1);
47: l_locked_by_status VARCHAR2(1);

Line 121: IF NOT (gme_batch_steps_dbl.update_row (p_batch_step => x_batch_step_rec) ) THEN

117: x_batch_step_rec.quality_status := 2;
118: END IF;
119:
120: -- Update the step
121: IF NOT (gme_batch_steps_dbl.update_row (p_batch_step => x_batch_step_rec) ) THEN
122: RAISE error_update_row;
123: END IF;
124:
125: -- Update WHO columns for output structure

Line 255: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

251: END unrelease_step;
252:
253: PROCEDURE validate_step_for_unrelease
254: (p_batch_hdr_rec IN gme_batch_header%ROWTYPE
255: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
256: ,x_return_status OUT NOCOPY VARCHAR2) IS
257:
258: l_api_name CONSTANT VARCHAR2 (30) := 'validate_step_for_unrelease';
259:

Line 260: CURSOR cur_dep_step (v_batchstep_id gme_batch_steps.batchstep_id%TYPE, v_batch_id NUMBER) IS

256: ,x_return_status OUT NOCOPY VARCHAR2) IS
257:
258: l_api_name CONSTANT VARCHAR2 (30) := 'validate_step_for_unrelease';
259:
260: CURSOR cur_dep_step (v_batchstep_id gme_batch_steps.batchstep_id%TYPE, v_batch_id NUMBER) IS
261: SELECT 1
262: FROM gme_batch_step_dependencies d, gme_batch_steps s
263: WHERE d.batchstep_id = s.batchstep_id AND
264: d.batch_id = s.batch_id AND

Line 262: FROM gme_batch_step_dependencies d, gme_batch_steps s

258: l_api_name CONSTANT VARCHAR2 (30) := 'validate_step_for_unrelease';
259:
260: CURSOR cur_dep_step (v_batchstep_id gme_batch_steps.batchstep_id%TYPE, v_batch_id NUMBER) IS
261: SELECT 1
262: FROM gme_batch_step_dependencies d, gme_batch_steps s
263: WHERE d.batchstep_id = s.batchstep_id AND
264: d.batch_id = s.batch_id AND
265: d.dep_step_id = v_batchstep_id AND
266: s.batch_id = v_batch_id AND