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_SCALE_BATCH_PVT dependencies on GME_BATCH_STEPS

Line 56: FROM gme_batch_steps s, gme_batch_step_items i

52:
53: CURSOR cur_get_step_status (v_material_detail_id NUMBER)
54: IS
55: SELECT s.batchstep_no, step_status
56: FROM gme_batch_steps s, gme_batch_step_items i
57: WHERE s.batchstep_id = i.batchstep_id
58: AND i.material_detail_id = v_material_detail_id;
59:
60: CURSOR cur_check_zero_qty_line (v_batch_id NUMBER, v_batch_status NUMBER)

Line 189: l_batch_step gme_batch_steps%ROWTYPE;

185: x_scale_tab gmd_common_scale.scale_tab;
186: l_batch_header gme_batch_header%ROWTYPE;
187: l_resch_batch_header_rec gme_batch_header%ROWTYPE;
188: l_in_batch_header gme_batch_header%ROWTYPE;
189: l_batch_step gme_batch_steps%ROWTYPE;
190: l_in_batch_step gme_batch_steps%ROWTYPE;
191: l_return_status VARCHAR2 (1);
192: l_return_status_1 VARCHAR2 (1);
193: l_return_status_2 VARCHAR2 (1);

Line 190: l_in_batch_step gme_batch_steps%ROWTYPE;

186: l_batch_header gme_batch_header%ROWTYPE;
187: l_resch_batch_header_rec gme_batch_header%ROWTYPE;
188: l_in_batch_header gme_batch_header%ROWTYPE;
189: l_batch_step gme_batch_steps%ROWTYPE;
190: l_in_batch_step gme_batch_steps%ROWTYPE;
191: l_return_status VARCHAR2 (1);
192: l_return_status_1 VARCHAR2 (1);
193: l_return_status_2 VARCHAR2 (1);
194: l_count NUMBER;

Line 686: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step

682: IF l_return_status <> x_return_status THEN
683: RAISE error_updating_steps;
684: END IF;
685:
686: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step
687: ,l_batch_step) ) THEN
688: RAISE batch_step_fetch_err;
689: END IF;
690: END LOOP; /* l_cur_item_step_asso */

Line 991: l_batch_step gme_batch_steps%ROWTYPE;

987: l_batch_header gme_batch_header%ROWTYPE;
988: l_routing_scale_factor NUMBER;
989: before_scale_qty NUMBER;
990: after_scale_qty NUMBER;
991: l_batch_step gme_batch_steps%ROWTYPE;
992: l_in_batch_step gme_batch_steps%ROWTYPE;
993: l_return_status VARCHAR2 (1);
994: l_count NUMBER;
995: l_list VARCHAR2 (2000);

Line 992: l_in_batch_step gme_batch_steps%ROWTYPE;

988: l_routing_scale_factor NUMBER;
989: before_scale_qty NUMBER;
990: after_scale_qty NUMBER;
991: l_batch_step gme_batch_steps%ROWTYPE;
992: l_in_batch_step gme_batch_steps%ROWTYPE;
993: l_return_status VARCHAR2 (1);
994: l_count NUMBER;
995: l_list VARCHAR2 (2000);
996: batch_fetch_error EXCEPTION;

Line 1021: FROM gme_batch_steps

1017:
1018: CURSOR cur_get_all_steps (v_batch_id NUMBER)
1019: IS
1020: SELECT batchstep_id
1021: FROM gme_batch_steps
1022: WHERE batch_id = v_batch_id;
1023:
1024: CURSOR cur_get_step_status (v_material_detail_id NUMBER)
1025: IS

Line 1027: FROM gme_batch_steps s, gme_batch_step_items i

1023:
1024: CURSOR cur_get_step_status (v_material_detail_id NUMBER)
1025: IS
1026: SELECT s.batchstep_no, step_status
1027: FROM gme_batch_steps s, gme_batch_step_items i
1028: WHERE s.batchstep_id = i.batchstep_id
1029: AND i.material_detail_id = v_material_detail_id;
1030:
1031: l_material_details_qty NUMBER;

Line 1190: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step

1186: IF l_return_status <> x_return_status THEN
1187: RAISE error_updating_steps;
1188: END IF;
1189:
1190: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step
1191: ,l_batch_step) ) THEN
1192: RAISE batch_step_fetch_err;
1193: END IF;
1194: END LOOP;

Line 1406: l_batch_step gme_batch_steps%ROWTYPE;

1402: IS
1403: /* Local variables */
1404: l_api_name CONSTANT VARCHAR2 (30) := 'SCALE_STEP_AND_RSRC';
1405: l_auto_step_calc NUMBER (5);
1406: l_batch_step gme_batch_steps%ROWTYPE;
1407: l_in_batch_step gme_batch_steps%ROWTYPE;
1408: l_batchstep_resource_ids gme_common_pvt.number_tab;
1409: l_gme_batchstep_resources gme_batch_step_resources%ROWTYPE;
1410: l_gme_resource_txns_gtmp gme_resource_txns_gtmp%ROWTYPE;

Line 1407: l_in_batch_step gme_batch_steps%ROWTYPE;

1403: /* Local variables */
1404: l_api_name CONSTANT VARCHAR2 (30) := 'SCALE_STEP_AND_RSRC';
1405: l_auto_step_calc NUMBER (5);
1406: l_batch_step gme_batch_steps%ROWTYPE;
1407: l_in_batch_step gme_batch_steps%ROWTYPE;
1408: l_batchstep_resource_ids gme_common_pvt.number_tab;
1409: l_gme_batchstep_resources gme_batch_step_resources%ROWTYPE;
1410: l_gme_resource_txns_gtmp gme_resource_txns_gtmp%ROWTYPE;
1411: l_return_status VARCHAR2 (1);

Line 1435: FROM gme_batch_steps

1431:
1432: CURSOR cur_get_all_steps (v_batch_id NUMBER)
1433: IS
1434: SELECT batchstep_id
1435: FROM gme_batch_steps
1436: WHERE batch_id = v_batch_id;
1437:
1438: CURSOR cur_get_res (v_step_id gme_batch_steps.batchstep_id%TYPE)
1439: IS

Line 1438: CURSOR cur_get_res (v_step_id gme_batch_steps.batchstep_id%TYPE)

1434: SELECT batchstep_id
1435: FROM gme_batch_steps
1436: WHERE batch_id = v_batch_id;
1437:
1438: CURSOR cur_get_res (v_step_id gme_batch_steps.batchstep_id%TYPE)
1439: IS
1440: SELECT batchstep_resource_id
1441: FROM gme_batch_step_resources
1442: WHERE batchstep_id = v_step_id AND scale_type <> 0;

Line 1468: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step, l_batch_step) ) THEN

1464:
1465: FOR l_cur_get_all_steps IN cur_get_all_steps (p_batch_id) LOOP
1466: l_batch_step.batchstep_id := l_cur_get_all_steps.batchstep_id;
1467:
1468: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step, l_batch_step) ) THEN
1469: RAISE batch_step_fetch_err;
1470: END IF;
1471:
1472: -- Round the step qtys to 5 decimal places.

Line 1512: IF NOT (gme_batch_steps_dbl.update_row (l_batch_step) ) THEN

1508: l_batch_step.actual_charges := l_charge;
1509: END IF;
1510: END IF;
1511:
1512: IF NOT (gme_batch_steps_dbl.update_row (l_batch_step) ) THEN
1513: RAISE error_updating_steps;
1514: END IF;
1515:
1516: IF l_batch_step.step_status = 1 THEN