APPS.GME_CLOSE_STEP_PVT dependencies on GME_BATCH_STEPS

Line 24: p_batch_step_rec IN gme_batch_steps%ROWTYPE

20: E - Error
21: U - Unexpected error
22: ======================================================================================*/
23: PROCEDURE close_step (
24: p_batch_step_rec IN gme_batch_steps%ROWTYPE
25: ,p_delete_pending IN VARCHAR2 DEFAULT fnd_api.g_false
26: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
27: ,x_return_status OUT NOCOPY VARCHAR2)
28: IS

Line 26: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE

22: ======================================================================================*/
23: PROCEDURE close_step (
24: p_batch_step_rec IN gme_batch_steps%ROWTYPE
25: ,p_delete_pending IN VARCHAR2 DEFAULT fnd_api.g_false
26: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
27: ,x_return_status OUT NOCOPY VARCHAR2)
28: IS
29: /* Miscellaneous */
30: l_batch_header gme_batch_header%ROWTYPE;

Line 62: FROM gme_batch_step_dependencies d, gme_batch_steps s

58: is dependent */
59: CURSOR cur_dep_steps
60: IS
61: SELECT d.dep_step_id, s.step_status
62: FROM gme_batch_step_dependencies d, gme_batch_steps s
63: WHERE d.batchstep_id = p_batch_step_rec.batchstep_id
64: AND s.batchstep_id = d.dep_step_id;
65:
66: CURSOR cur_material_ids (v_batchstep_id IN NUMBER)

Line 81: IF NOT (gme_batch_steps_dbl.fetch_row (p_batch_step_rec

77: /* Set the return status to success initially */
78: x_return_status := fnd_api.g_ret_sts_success;
79:
80: /* Initialize output batch step */
81: IF NOT (gme_batch_steps_dbl.fetch_row (p_batch_step_rec
82: ,x_batch_step_rec) ) THEN
83: RAISE batch_step_fetch_error;
84: END IF;
85:

Line 181: IF NOT (gme_batch_steps_dbl.update_row (x_batch_step_rec) ) THEN

177: END IF;
178:
179: /* Update the batch step to the database */
180:
181: IF NOT (gme_batch_steps_dbl.update_row (x_batch_step_rec) ) THEN
182: RAISE batch_step_upd_err;
183: END IF;
184:
185: x_batch_step_rec.last_update_date := gme_common_pvt.g_timestamp;