APPS.GME_REVERT_STEP_PVT dependencies on GME_BATCH_STEPS

Line 28: (p_batch_step_rec IN GME_BATCH_STEPS%ROWTYPE

24: N - Unallocated Items Found
25: =============================================================================================*/
26:
27: PROCEDURE revert_step
28: (p_batch_step_rec IN GME_BATCH_STEPS%ROWTYPE
29: ,p_batch_header_rec IN GME_BATCH_HEADER%ROWTYPE
30: ,x_batch_step_rec OUT NOCOPY GME_BATCH_STEPS%ROWTYPE
31: ,x_return_status OUT NOCOPY VARCHAR2) IS
32:

Line 30: ,x_batch_step_rec OUT NOCOPY GME_BATCH_STEPS%ROWTYPE

26:
27: PROCEDURE revert_step
28: (p_batch_step_rec IN GME_BATCH_STEPS%ROWTYPE
29: ,p_batch_header_rec IN GME_BATCH_HEADER%ROWTYPE
30: ,x_batch_step_rec OUT NOCOPY GME_BATCH_STEPS%ROWTYPE
31: ,x_return_status OUT NOCOPY VARCHAR2) IS
32:
33: /* Buffers for database reads/writes */
34: l_batch_header_rec gme_batch_header%ROWTYPE;

Line 36: x_in_batch_step_rec gme_batch_steps%ROWTYPE;

32:
33: /* Buffers for database reads/writes */
34: l_batch_header_rec gme_batch_header%ROWTYPE;
35: l_in_batch_header_rec gme_batch_header%ROWTYPE;
36: x_in_batch_step_rec gme_batch_steps%ROWTYPE;
37: l_batch_step_rec gme_batch_steps%ROWTYPE;
38: l_material_details_tab gme_common_pvt.material_details_tab ;
39: /* Bug 2685645 added batch_id as parama and used in where clause */
40: CURSOR cur_dep_steps (v_batchstep_id NUMBER,

Line 37: l_batch_step_rec gme_batch_steps%ROWTYPE;

33: /* Buffers for database reads/writes */
34: l_batch_header_rec gme_batch_header%ROWTYPE;
35: l_in_batch_header_rec gme_batch_header%ROWTYPE;
36: x_in_batch_step_rec gme_batch_steps%ROWTYPE;
37: l_batch_step_rec gme_batch_steps%ROWTYPE;
38: l_material_details_tab gme_common_pvt.material_details_tab ;
39: /* Bug 2685645 added batch_id as parama and used in where clause */
40: CURSOR cur_dep_steps (v_batchstep_id NUMBER,
41: v_batch_id NUMBER) IS

Line 43: FROM gme_batch_step_dependencies d, gme_batch_steps s

39: /* Bug 2685645 added batch_id as parama and used in where clause */
40: CURSOR cur_dep_steps (v_batchstep_id NUMBER,
41: v_batch_id NUMBER) IS
42: SELECT batchstep_no, s.step_status,d.dep_type,d.standard_delay, s.steprelease_type
43: FROM gme_batch_step_dependencies d, gme_batch_steps s
44: WHERE d.batchstep_id = s.batchstep_id AND
45: d.dep_step_id = v_batchstep_id AND
46: s.batch_id = v_batch_id AND
47: d.batch_id = s.batch_id;

Line 146: IF NOT (gme_batch_steps_dbl.update_row (l_batch_step_rec)) THEN

142: -- Update step status to WIP
143: l_batch_step_rec.step_status := 2;
144: gme_common_pvt.g_batch_status_check := fnd_api.g_false;
145: -- Update the batch step to the database
146: IF NOT (gme_batch_steps_dbl.update_row (l_batch_step_rec)) THEN
147: RAISE batch_step_upd_err;
148: END IF;
149: IF ( g_debug <= gme_debug.g_log_procedure ) THEN
150: gme_debug.put_line ('batchstep status'||l_batch_step_rec.step_status);