APPS.GME_REOPEN_STEP_PVT dependencies on GME_BATCH_HEADER

Line 34: p_batch_header_rec IN gme_batch_header%ROWTYPE

30: E - Error
31: U - Unexpected error
32: ======================================================================================*/
33: PROCEDURE reopen_all_steps (
34: p_batch_header_rec IN gme_batch_header%ROWTYPE
35: ,x_return_status OUT NOCOPY VARCHAR2)
36: IS
37: /* Local variables */
38: l_batch_steps_tab gme_close_batch_pvt.step_details_tab;

Line 39: l_batch_header gme_batch_header%ROWTYPE;

35: ,x_return_status OUT NOCOPY VARCHAR2)
36: IS
37: /* Local variables */
38: l_batch_steps_tab gme_close_batch_pvt.step_details_tab;
39: l_batch_header gme_batch_header%ROWTYPE;
40: l_in_batch_header gme_batch_header%ROWTYPE;
41: l_phantom_ids gme_common_pvt.number_tab;
42: l_return_status VARCHAR2 (1);
43: batch_step_fetch_err EXCEPTION;

Line 40: l_in_batch_header gme_batch_header%ROWTYPE;

36: IS
37: /* Local variables */
38: l_batch_steps_tab gme_close_batch_pvt.step_details_tab;
39: l_batch_header gme_batch_header%ROWTYPE;
40: l_in_batch_header gme_batch_header%ROWTYPE;
41: l_phantom_ids gme_common_pvt.number_tab;
42: l_return_status VARCHAR2 (1);
43: batch_step_fetch_err EXCEPTION;
44: batch_step_reopen_err EXCEPTION;

Line 138: l_batch_header gme_batch_header%ROWTYPE;

134: ,x_return_status OUT NOCOPY VARCHAR2)
135: IS
136: /* Miscellaneous */
137: l_batch_status NUMBER;
138: l_batch_header gme_batch_header%ROWTYPE;
139: l_in_batch_header gme_batch_header%ROWTYPE;
140: l_auto NUMBER := 0;
141: l_count NUMBER := 0;
142: l_enforce_step_dep NUMBER := -1;

Line 139: l_in_batch_header gme_batch_header%ROWTYPE;

135: IS
136: /* Miscellaneous */
137: l_batch_status NUMBER;
138: l_batch_header gme_batch_header%ROWTYPE;
139: l_in_batch_header gme_batch_header%ROWTYPE;
140: l_auto NUMBER := 0;
141: l_count NUMBER := 0;
142: l_enforce_step_dep NUMBER := -1;
143: /* Exception definitions */

Line 156: FROM gme_batch_header

152: CURSOR cur_batch_status (l_batch_id IN NUMBER)
153: IS
154: SELECT batch_status, automatic_step_calculation
155: ,enforce_step_dependency
156: FROM gme_batch_header
157: WHERE batch_id = l_batch_id;
158:
159: CURSOR cur_fetch_dep_steps (l_batchstep_id IN NUMBER, l_batch_id NUMBER)
160: IS