APPS.GME_UNRELEASE_STEP_PVT dependencies on GME_BATCH_HEADER

Line 33: v_batch_id gme_batch_header.batch_id%TYPE

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

Line 45: v_batch_id gme_batch_header.batch_id%TYPE)

41: AND d.release_type = gme_common_pvt.g_mtl_autobystep_release;
42:
43: -- Bug 9478698 - Get enhanced_pi_ind from batch header.
44: CURSOR cur_get_batch_info (
45: v_batch_id gme_batch_header.batch_id%TYPE)
46: IS
47: SELECT NVL(enhanced_pi_ind, 0)
48: FROM gme_batch_header h
49: WHERE batch_id = v_batch_id;

Line 48: FROM gme_batch_header h

44: CURSOR cur_get_batch_info (
45: v_batch_id gme_batch_header.batch_id%TYPE)
46: IS
47: SELECT NVL(enhanced_pi_ind, 0)
48: FROM gme_batch_header h
49: WHERE batch_id = v_batch_id;
50:
51: l_enhanced_pi_ind VARCHAR2(1);
52:

Line 272: (p_batch_hdr_rec IN gme_batch_header%ROWTYPE

268: x_return_status := fnd_api.g_ret_sts_unexp_error;
269: END unrelease_step;
270:
271: PROCEDURE validate_step_for_unrelease
272: (p_batch_hdr_rec IN gme_batch_header%ROWTYPE
273: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
274: ,x_return_status OUT NOCOPY VARCHAR2) IS
275:
276: l_api_name CONSTANT VARCHAR2 (30) := 'validate_step_for_unrelease';