APPS.GME_REOPEN_STEP_PVT dependencies on GME_BATCH_STEPS

Line 68: IF NOT (gme_batch_steps_dbl.update_row

64: l_batch_steps_tab (i).step_close_date := NULL;
65: l_batch_steps_tab (i).step_status := 3;
66:
67: -- Update Batch Step Record
68: IF NOT (gme_batch_steps_dbl.update_row
69: (p_batch_step => l_batch_steps_tab
70: (i) ) ) THEN
71: RAISE batch_step_upd_err;
72: END IF;

Line 132: p_batch_step_rec IN gme_batch_steps%ROWTYPE

128: E - Error
129: U - Unexpected error
130: ======================================================================================*/
131: PROCEDURE reopen_step (
132: p_batch_step_rec IN gme_batch_steps%ROWTYPE
133: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
134: ,x_return_status OUT NOCOPY VARCHAR2)
135: IS
136: /* Miscellaneous */

Line 133: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE

129: U - Unexpected error
130: ======================================================================================*/
131: PROCEDURE reopen_step (
132: p_batch_step_rec IN gme_batch_steps%ROWTYPE
133: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
134: ,x_return_status OUT NOCOPY VARCHAR2)
135: IS
136: /* Miscellaneous */
137: l_batch_status NUMBER;

Line 162: FROM gme_batch_step_dependencies gbsd, gme_batch_steps gbs

158:
159: CURSOR cur_fetch_dep_steps (l_batchstep_id IN NUMBER, l_batch_id NUMBER)
160: IS
161: SELECT COUNT (*)
162: FROM gme_batch_step_dependencies gbsd, gme_batch_steps gbs
163: WHERE gbs.batchstep_id = gbsd.batchstep_id
164: AND gbsd.dep_step_id = l_batchstep_id
165: AND gbs.batch_id = l_batch_id
166: AND gbsd.batch_id = gbs.batch_id

Line 176: IF NOT (gme_batch_steps_dbl.fetch_row (p_batch_step => p_batch_step_rec

172: BEGIN
173: -- Set the return status to success initially
174: x_return_status := fnd_api.g_ret_sts_success;
175:
176: IF NOT (gme_batch_steps_dbl.fetch_row (p_batch_step => p_batch_step_rec
177: ,x_batch_step => x_batch_step_rec) ) THEN
178: RAISE batch_step_fetch_err;
179: END IF;
180:

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

215: x_batch_step_rec.step_close_date := NULL;
216: x_batch_step_rec.step_status := 3;
217:
218: -- Update Batch Step Record
219: IF NOT (gme_batch_steps_dbl.update_row (p_batch_step => x_batch_step_rec) ) THEN
220: RAISE batch_step_upd_err;
221: END IF;
222:
223: x_batch_step_rec.last_update_date := gme_common_pvt.g_timestamp;