APPS.GME_COMMON_PVT dependencies on GME_BATCH_STEPS

Line 1484: ,p_batchstep_rec IN gme_batch_steps%ROWTYPE

1480:
1481: PROCEDURE calc_mtl_req_date (
1482: p_batch_header_rec IN gme_batch_header%ROWTYPE
1483: DEFAULT NULL
1484: ,p_batchstep_rec IN gme_batch_steps%ROWTYPE
1485: DEFAULT NULL
1486: ,p_mtl_dtl_rec IN gme_material_details%ROWTYPE
1487: ,x_mtl_req_date OUT NOCOPY DATE
1488: ,x_return_status OUT NOCOPY VARCHAR2)

Line 1506: FROM gme_batch_steps

1502:
1503: CURSOR cur_fetch_step_dates (v_batchstep_id NUMBER)
1504: IS
1505: SELECT plan_start_date, plan_cmplt_date
1506: FROM gme_batch_steps
1507: WHERE batchstep_id = v_batchstep_id;
1508:
1509: CURSOR cur_fetch_batch_dates (v_batch_id NUMBER)
1510: IS

Line 1784: FROM gme_batch_step_resources r, gme_batch_steps s

1780: -- Bug 13946067 - Introduce new table and joins to make use of existing index.
1781: CURSOR cur_get_resources
1782: IS
1783: SELECT batchstep_resource_id
1784: FROM gme_batch_step_resources r, gme_batch_steps s
1785: WHERE r.batch_id = p_batch_id
1786: AND s.batch_id = p_batch_id
1787: AND s.batchstep_id = r.batchstep_id;
1788:

Line 3459: FROM gme_batch_step_items a, gme_batch_steps s

3455:
3456: CURSOR get_assoc_step (v_material_detail_id IN NUMBER)
3457: IS
3458: SELECT a.batchstep_id, s.step_status
3459: FROM gme_batch_step_items a, gme_batch_steps s
3460: WHERE a.material_detail_id = v_material_detail_id
3461: AND a.batchstep_id = s.batchstep_id
3462: AND a.batch_id = s.batch_id;
3463: BEGIN

Line 3599: p_batch_step_rec IN gme_batch_steps%ROWTYPE

3595: RETURN FALSE;
3596: END get_batch_header;
3597:
3598: FUNCTION get_batch_step (
3599: p_batch_step_rec IN gme_batch_steps%ROWTYPE
3600: ,p_org_code IN VARCHAR2
3601: ,p_batch_no IN VARCHAR2
3602: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
3603: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)

Line 3602: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE

3598: FUNCTION get_batch_step (
3599: p_batch_step_rec IN gme_batch_steps%ROWTYPE
3600: ,p_org_code IN VARCHAR2
3601: ,p_batch_no IN VARCHAR2
3602: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
3603: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
3604: RETURN BOOLEAN
3605: IS
3606:

Line 3609: l_batch_step_rec gme_batch_steps%ROWTYPE;

3605: IS
3606:
3607: l_batch_header_rec_in gme_batch_header%ROWTYPE;
3608: l_batch_header_rec gme_batch_header%ROWTYPE;
3609: l_batch_step_rec gme_batch_steps%ROWTYPE;
3610: l_api_name VARCHAR2 (30) := 'GET_BATCH_STEP';
3611:
3612: BEGIN
3613: IF g_debug <= gme_debug.g_log_procedure THEN

Line 3633: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step_rec

3629: l_batch_step_rec.batch_id := l_batch_header_rec.batch_id;
3630: END IF;
3631: END IF;
3632:
3633: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step_rec
3634: ,l_batch_step_rec) ) THEN
3635: RAISE fnd_api.g_exc_error;
3636: END IF;
3637:

Line 3790: FROM gme_batch_steps

3786:
3787: CURSOR get_batchstep_id (l_batch_id IN NUMBER, l_batchstep_no IN NUMBER)
3788: IS
3789: SELECT batchstep_id
3790: FROM gme_batch_steps
3791: WHERE batch_id = l_batch_id AND batchstep_no = l_batchstep_no;
3792:
3793: /* Join of gme_batch_step_resources and
3794: gme_batch_step_activities to get unique BATCHSTEP_RESOURCE_ID */

Line 4323: l_batchstep_rec gme_batch_steps%ROWTYPE;

4319: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
4320: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type; -- 4944024
4321: l_rsv_count NUMBER; -- 4944024
4322: /* Punit Kumar */
4323: l_batchstep_rec gme_batch_steps%ROWTYPE;
4324: BEGIN
4325: IF (NVL (g_debug, 0) IN
4326: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4327: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

Line 4375: IF NOT gme_batch_steps_dbl.fetch_row (l_batchstep_rec

4371:
4372: IF get_assoc_step (p_material_detail_id
4373: ,l_batchstep_rec.batchstep_id
4374: ,l_batchstep_rec.step_status) THEN
4375: IF NOT gme_batch_steps_dbl.fetch_row (l_batchstep_rec
4376: ,l_batchstep_rec) THEN
4377: RAISE fnd_api.g_exc_error;
4378: END IF;
4379: END IF;

Line 5228: p_batch_step_rec IN gme_batch_steps%ROWTYPE

5224: -- 14-NOV-2011 G. Muratore Bug 13356510
5225: -- Commented out validation code that was incorrectly checking for phantom batch.
5226: --===================================================================== */
5227: Procedure Validate_batch_step (
5228: p_batch_step_rec IN gme_batch_steps%ROWTYPE
5229: ,p_org_code IN VARCHAR2
5230: ,p_batch_no IN VARCHAR2
5231: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
5232: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

Line 5231: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE

5227: Procedure Validate_batch_step (
5228: p_batch_step_rec IN gme_batch_steps%ROWTYPE
5229: ,p_org_code IN VARCHAR2
5230: ,p_batch_no IN VARCHAR2
5231: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
5232: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
5233: ,x_message_count OUT NOCOPY NUMBER
5234: ,x_message_list OUT NOCOPY VARCHAR2
5235: ,x_return_status OUT NOCOPY VARCHAR2)

Line 5240: l_batch_step_rec gme_batch_steps%ROWTYPE;

5236:
5237: IS
5238: l_api_name VARCHAR2 (100) := 'validate_batch_step';
5239: l_batch_header_rec gme_batch_header%ROWTYPE;
5240: l_batch_step_rec gme_batch_steps%ROWTYPE;
5241: step_header_fetch_error EXCEPTION;
5242: BEGIN
5243: IF g_debug <= gme_debug.g_log_procedure THEN
5244: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

Line 5361: FROM gme_batch_steps

5357:
5358: CURSOR cur_fetch_step_dates (v_batchstep_id NUMBER)
5359: IS
5360: SELECT actual_start_date, actual_cmplt_date
5361: FROM gme_batch_steps
5362: WHERE batchstep_id = v_batchstep_id;
5363: BEGIN
5364: IF g_debug <= gme_debug.g_log_procedure THEN
5365: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'|| l_api_name);