eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GME_COMMON_PVT dependencies on GME_BATCH_STEPS

Line 1387: ,p_batchstep_rec IN gme_batch_steps%ROWTYPE

1383:
1384: PROCEDURE calc_mtl_req_date (
1385: p_batch_header_rec IN gme_batch_header%ROWTYPE
1386: DEFAULT NULL
1387: ,p_batchstep_rec IN gme_batch_steps%ROWTYPE
1388: DEFAULT NULL
1389: ,p_mtl_dtl_rec IN gme_material_details%ROWTYPE
1390: ,x_mtl_req_date OUT NOCOPY DATE
1391: ,x_return_status OUT NOCOPY VARCHAR2)

Line 1409: FROM gme_batch_steps

1405:
1406: CURSOR cur_fetch_step_dates (v_batchstep_id NUMBER)
1407: IS
1408: SELECT plan_start_date, plan_cmplt_date
1409: FROM gme_batch_steps
1410: WHERE batchstep_id = v_batchstep_id;
1411:
1412: CURSOR cur_fetch_batch_dates (v_batch_id NUMBER)
1413: IS

Line 3200: FROM gme_batch_step_items a, gme_batch_steps s

3196:
3197: CURSOR get_assoc_step (v_material_detail_id IN NUMBER)
3198: IS
3199: SELECT a.batchstep_id, s.step_status
3200: FROM gme_batch_step_items a, gme_batch_steps s
3201: WHERE a.material_detail_id = v_material_detail_id
3202: AND a.batchstep_id = s.batchstep_id
3203: AND a.batch_id = s.batch_id;
3204: BEGIN

Line 3340: p_batch_step_rec IN gme_batch_steps%ROWTYPE

3336: RETURN FALSE;
3337: END get_batch_header;
3338:
3339: FUNCTION get_batch_step (
3340: p_batch_step_rec IN gme_batch_steps%ROWTYPE
3341: ,p_org_code IN VARCHAR2
3342: ,p_batch_no IN VARCHAR2
3343: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
3344: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)

Line 3343: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE

3339: FUNCTION get_batch_step (
3340: p_batch_step_rec IN gme_batch_steps%ROWTYPE
3341: ,p_org_code IN VARCHAR2
3342: ,p_batch_no IN VARCHAR2
3343: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
3344: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
3345: RETURN BOOLEAN
3346: IS
3347:

Line 3350: l_batch_step_rec gme_batch_steps%ROWTYPE;

3346: IS
3347:
3348: l_batch_header_rec_in gme_batch_header%ROWTYPE;
3349: l_batch_header_rec gme_batch_header%ROWTYPE;
3350: l_batch_step_rec gme_batch_steps%ROWTYPE;
3351: l_api_name VARCHAR2 (30) := 'GET_BATCH_STEP';
3352:
3353: BEGIN
3354: IF g_debug <= gme_debug.g_log_procedure THEN

Line 3374: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step_rec

3370: l_batch_step_rec.batch_id := l_batch_header_rec.batch_id;
3371: END IF;
3372: END IF;
3373:
3374: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step_rec
3375: ,l_batch_step_rec) ) THEN
3376: RAISE fnd_api.g_exc_error;
3377: END IF;
3378:

Line 3531: FROM gme_batch_steps

3527:
3528: CURSOR get_batchstep_id (l_batch_id IN NUMBER, l_batchstep_no IN NUMBER)
3529: IS
3530: SELECT batchstep_id
3531: FROM gme_batch_steps
3532: WHERE batch_id = l_batch_id AND batchstep_no = l_batchstep_no;
3533:
3534: /* Join of gme_batch_step_resources and
3535: gme_batch_step_activities to get unique BATCHSTEP_RESOURCE_ID */

Line 4064: l_batchstep_rec gme_batch_steps%ROWTYPE;

4060: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
4061: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type; -- 4944024
4062: l_rsv_count NUMBER; -- 4944024
4063: /* Punit Kumar */
4064: l_batchstep_rec gme_batch_steps%ROWTYPE;
4065: BEGIN
4066: IF (NVL (g_debug, 0) IN
4067: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4068: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

Line 4116: IF NOT gme_batch_steps_dbl.fetch_row (l_batchstep_rec

4112:
4113: IF get_assoc_step (p_material_detail_id
4114: ,l_batchstep_rec.batchstep_id
4115: ,l_batchstep_rec.step_status) THEN
4116: IF NOT gme_batch_steps_dbl.fetch_row (l_batchstep_rec
4117: ,l_batchstep_rec) THEN
4118: RAISE fnd_api.g_exc_error;
4119: END IF;
4120: END IF;

Line 4962: p_batch_step_rec IN gme_batch_steps%ROWTYPE

4958: --
4959: --===================================================================== */
4960:
4961: Procedure Validate_batch_step (
4962: p_batch_step_rec IN gme_batch_steps%ROWTYPE
4963: ,p_org_code IN VARCHAR2
4964: ,p_batch_no IN VARCHAR2
4965: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
4966: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

Line 4965: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE

4961: Procedure Validate_batch_step (
4962: p_batch_step_rec IN gme_batch_steps%ROWTYPE
4963: ,p_org_code IN VARCHAR2
4964: ,p_batch_no IN VARCHAR2
4965: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
4966: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
4967: ,x_message_count OUT NOCOPY NUMBER
4968: ,x_message_list OUT NOCOPY VARCHAR2
4969: ,x_return_status OUT NOCOPY VARCHAR2)

Line 4974: l_batch_step_rec gme_batch_steps%ROWTYPE;

4970:
4971: IS
4972: l_api_name VARCHAR2 (100) := 'validate_batch_step';
4973: l_batch_header_rec gme_batch_header%ROWTYPE;
4974: l_batch_step_rec gme_batch_steps%ROWTYPE;
4975: step_header_fetch_error EXCEPTION;
4976: BEGIN
4977: IF g_debug <= gme_debug.g_log_procedure THEN
4978: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

Line 5093: FROM gme_batch_steps

5089:
5090: CURSOR cur_fetch_step_dates (v_batchstep_id NUMBER)
5091: IS
5092: SELECT actual_start_date, actual_cmplt_date
5093: FROM gme_batch_steps
5094: WHERE batchstep_id = v_batchstep_id;
5095: BEGIN
5096: IF g_debug <= gme_debug.g_log_procedure THEN
5097: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'|| l_api_name);