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.

[Home] [Help]

APPS.GME_SCALE_BATCH_PVT dependencies on GME_BATCH_STEPS

Line 59: FROM gme_batch_steps s, gme_batch_step_items i

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

Line 195: l_batch_step gme_batch_steps%ROWTYPE;

191: x_scale_tab gmd_common_scale.scale_tab;
192: l_batch_header gme_batch_header%ROWTYPE;
193: l_resch_batch_header_rec gme_batch_header%ROWTYPE;
194: l_in_batch_header gme_batch_header%ROWTYPE;
195: l_batch_step gme_batch_steps%ROWTYPE;
196: l_in_batch_step gme_batch_steps%ROWTYPE;
197: l_return_status VARCHAR2 (1);
198: l_return_status_1 VARCHAR2 (1);
199: l_return_status_2 VARCHAR2 (1);

Line 196: l_in_batch_step gme_batch_steps%ROWTYPE;

192: l_batch_header gme_batch_header%ROWTYPE;
193: l_resch_batch_header_rec gme_batch_header%ROWTYPE;
194: l_in_batch_header gme_batch_header%ROWTYPE;
195: l_batch_step gme_batch_steps%ROWTYPE;
196: l_in_batch_step gme_batch_steps%ROWTYPE;
197: l_return_status VARCHAR2 (1);
198: l_return_status_1 VARCHAR2 (1);
199: l_return_status_2 VARCHAR2 (1);
200: l_count NUMBER;

Line 692: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step

688: IF l_return_status <> x_return_status THEN
689: RAISE error_updating_steps;
690: END IF;
691:
692: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step
693: ,l_batch_step) ) THEN
694: RAISE batch_step_fetch_err;
695: END IF;
696: END LOOP; /* l_cur_item_step_asso */

Line 1001: l_batch_step gme_batch_steps%ROWTYPE;

997: l_batch_header gme_batch_header%ROWTYPE;
998: l_routing_scale_factor NUMBER;
999: before_scale_qty NUMBER;
1000: after_scale_qty NUMBER;
1001: l_batch_step gme_batch_steps%ROWTYPE;
1002: l_in_batch_step gme_batch_steps%ROWTYPE;
1003: l_return_status VARCHAR2 (1);
1004: l_count NUMBER;
1005: l_list VARCHAR2 (2000);

Line 1002: l_in_batch_step gme_batch_steps%ROWTYPE;

998: l_routing_scale_factor NUMBER;
999: before_scale_qty NUMBER;
1000: after_scale_qty NUMBER;
1001: l_batch_step gme_batch_steps%ROWTYPE;
1002: l_in_batch_step gme_batch_steps%ROWTYPE;
1003: l_return_status VARCHAR2 (1);
1004: l_count NUMBER;
1005: l_list VARCHAR2 (2000);
1006: batch_fetch_error EXCEPTION;

Line 1031: FROM gme_batch_steps

1027:
1028: CURSOR cur_get_all_steps (v_batch_id NUMBER)
1029: IS
1030: SELECT batchstep_id
1031: FROM gme_batch_steps
1032: WHERE batch_id = v_batch_id;
1033:
1034: CURSOR cur_get_step_status (v_material_detail_id NUMBER)
1035: IS

Line 1037: FROM gme_batch_steps s, gme_batch_step_items i

1033:
1034: CURSOR cur_get_step_status (v_material_detail_id NUMBER)
1035: IS
1036: SELECT s.batchstep_no, step_status
1037: FROM gme_batch_steps s, gme_batch_step_items i
1038: WHERE s.batchstep_id = i.batchstep_id
1039: AND i.material_detail_id = v_material_detail_id;
1040:
1041: l_material_details_qty NUMBER;

Line 1200: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step

1196: IF l_return_status <> x_return_status THEN
1197: RAISE error_updating_steps;
1198: END IF;
1199:
1200: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step
1201: ,l_batch_step) ) THEN
1202: RAISE batch_step_fetch_err;
1203: END IF;
1204: END LOOP;

Line 1416: l_batch_step gme_batch_steps%ROWTYPE;

1412: IS
1413: /* Local variables */
1414: l_api_name CONSTANT VARCHAR2 (30) := 'SCALE_STEP_AND_RSRC';
1415: l_auto_step_calc NUMBER (5);
1416: l_batch_step gme_batch_steps%ROWTYPE;
1417: l_in_batch_step gme_batch_steps%ROWTYPE;
1418: l_batchstep_resource_ids gme_common_pvt.number_tab;
1419: l_gme_batchstep_resources gme_batch_step_resources%ROWTYPE;
1420: l_gme_resource_txns_gtmp gme_resource_txns_gtmp%ROWTYPE;

Line 1417: l_in_batch_step gme_batch_steps%ROWTYPE;

1413: /* Local variables */
1414: l_api_name CONSTANT VARCHAR2 (30) := 'SCALE_STEP_AND_RSRC';
1415: l_auto_step_calc NUMBER (5);
1416: l_batch_step gme_batch_steps%ROWTYPE;
1417: l_in_batch_step gme_batch_steps%ROWTYPE;
1418: l_batchstep_resource_ids gme_common_pvt.number_tab;
1419: l_gme_batchstep_resources gme_batch_step_resources%ROWTYPE;
1420: l_gme_resource_txns_gtmp gme_resource_txns_gtmp%ROWTYPE;
1421: l_return_status VARCHAR2 (1);

Line 1445: FROM gme_batch_steps

1441:
1442: CURSOR cur_get_all_steps (v_batch_id NUMBER)
1443: IS
1444: SELECT batchstep_id
1445: FROM gme_batch_steps
1446: WHERE batch_id = v_batch_id;
1447:
1448: CURSOR cur_get_res (v_step_id gme_batch_steps.batchstep_id%TYPE)
1449: IS

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

1444: SELECT batchstep_id
1445: FROM gme_batch_steps
1446: WHERE batch_id = v_batch_id;
1447:
1448: CURSOR cur_get_res (v_step_id gme_batch_steps.batchstep_id%TYPE)
1449: IS
1450: SELECT batchstep_resource_id
1451: FROM gme_batch_step_resources
1452: WHERE batchstep_id = v_step_id AND scale_type <> 0;

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

1474:
1475: FOR l_cur_get_all_steps IN cur_get_all_steps (p_batch_id) LOOP
1476: l_batch_step.batchstep_id := l_cur_get_all_steps.batchstep_id;
1477:
1478: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step, l_batch_step) ) THEN
1479: RAISE batch_step_fetch_err;
1480: END IF;
1481:
1482: -- Round the step qtys to 5 decimal places.

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

1518: l_batch_step.actual_charges := l_charge;
1519: END IF;
1520: END IF;
1521:
1522: IF NOT (gme_batch_steps_dbl.update_row (l_batch_step) ) THEN
1523: RAISE error_updating_steps;
1524: END IF;
1525:
1526: IF l_batch_step.step_status = 1 THEN