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_HEADER

Line 27: p_batch_header_rec IN gme_batch_header%ROWTYPE

23: /* Global variables */
24: g_pkg_name CONSTANT VARCHAR2 (30) := 'GME_SCALE_BATCH_PVT';
25:
26: PROCEDURE scale_batch (
27: p_batch_header_rec IN gme_batch_header%ROWTYPE
28: ,p_scale_factor IN NUMBER
29: ,p_primaries IN VARCHAR2
30: ,p_qty_type IN NUMBER
31: ,p_validity_rule_id IN NUMBER

Line 37: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

33: ,p_recalc_dates IN VARCHAR2
34: ,p_use_workday_cal IN VARCHAR2
35: ,p_contiguity_override IN VARCHAR2
36: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
37: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
38: ,x_return_status OUT NOCOPY VARCHAR2)
39: IS
40: CURSOR cur_get_matl (v_batch_id NUMBER)
41: IS

Line 50: FROM gme_batch_header

46:
47: CURSOR cur_get_batch_status (v_batch_id NUMBER)
48: IS
49: SELECT batch_status
50: FROM gme_batch_header
51: WHERE batch_id = v_batch_id;
52:
53: CURSOR cur_get_step_status (v_material_detail_id NUMBER)
54: IS

Line 165: p_batch_header_rec IN gme_batch_header%ROWTYPE

161: bach_header and material_details table
162: p_batch_header_rec should have all the columns populated
163: */
164: PROCEDURE scale_batch (
165: p_batch_header_rec IN gme_batch_header%ROWTYPE
166: ,p_material_tbl IN gme_common_pvt.material_details_tab
167: ,p_scale_factor IN NUMBER
168: ,p_primaries IN VARCHAR2
169: ,p_qty_type IN NUMBER

Line 176: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

172: ,p_recalc_dates IN VARCHAR2
173: ,p_use_workday_cal IN VARCHAR2
174: ,p_contiguity_override IN VARCHAR2
175: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
176: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
177: ,x_material_tbl OUT NOCOPY gme_common_pvt.material_details_tab
178: ,x_return_status OUT NOCOPY VARCHAR2)
179: IS
180: /* Local variables */

Line 186: l_batch_header gme_batch_header%ROWTYPE;

182: l_row_count NUMBER;
183: l_recipe_validity_rule gmd_recipe_validity_rules%ROWTYPE;
184: l_scale_tab gmd_common_scale.scale_tab;
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;

Line 187: l_resch_batch_header_rec gme_batch_header%ROWTYPE;

183: l_recipe_validity_rule gmd_recipe_validity_rules%ROWTYPE;
184: l_scale_tab gmd_common_scale.scale_tab;
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);

Line 188: l_in_batch_header gme_batch_header%ROWTYPE;

184: l_scale_tab gmd_common_scale.scale_tab;
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);

Line 643: IF NOT (gme_batch_header_dbl.fetch_row (p_batch_header_rec

639: /* we need not adjust the transactions as the create batch API will */
640: /* be doing the same - The batch id is not assigned to the material */
641: /* detail row when the scale batch is invoked in create batch API */
642: IF l_batch_header.batch_id IS NOT NULL THEN
643: IF NOT (gme_batch_header_dbl.fetch_row (p_batch_header_rec
644: ,l_batch_header) ) THEN
645: RAISE batch_fetch_error;
646: END IF;
647:

Line 740: IF NOT (gme_batch_header_dbl.fetch_row (l_in_batch_header

736:
737: l_in_batch_header.batch_id :=
738: x_material_tbl (line_index).phantom_id;
739:
740: IF NOT (gme_batch_header_dbl.fetch_row (l_in_batch_header
741: ,l_batch_header) ) THEN
742: RAISE batch_fetch_error;
743: END IF;
744:

Line 974: p_batch_header_rec IN gme_batch_header%ROWTYPE

970: x_return_status := fnd_api.g_ret_sts_unexp_error;
971: END scale_batch;
972:
973: PROCEDURE theoretical_yield_batch (
974: p_batch_header_rec IN gme_batch_header%ROWTYPE
975: ,p_scale_factor IN NUMBER
976: ,x_return_status OUT NOCOPY VARCHAR2)
977: IS
978: /* Buffers for database reads/writes */

Line 987: l_batch_header gme_batch_header%ROWTYPE;

983: l_scale_tab gmd_common_scale.scale_tab;
984: l_in_scale_tab gmd_common_scale.scale_tab;
985: l_scale_factor NUMBER;
986: x_material_details gme_common_pvt.material_details_tab;
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;

Line 1046: IF (NOT gme_batch_header_dbl.fetch_row (p_batch_header_rec

1042: -- gme_api_grp.set_timestamp;
1043: l_scale_factor := p_scale_factor;
1044:
1045: /* Set the savepoint before proceeding */
1046: IF (NOT gme_batch_header_dbl.fetch_row (p_batch_header_rec
1047: ,l_batch_header) ) THEN
1048: RAISE batch_fetch_error;
1049: END IF;
1050:

Line 1283: ,p_batch_header_rec IN gme_batch_header%ROWTYPE)

1279: END theoretical_yield_batch;
1280:
1281: FUNCTION get_total_qty (
1282: p_material_tab IN gme_common_pvt.material_details_tab
1283: ,p_batch_header_rec IN gme_batch_header%ROWTYPE)
1284: RETURN NUMBER
1285: IS
1286: CURSOR get_rout_uom (v_batch_id NUMBER)
1287: IS

Line 1291: FROM gme_batch_header

1287: IS
1288: SELECT routing_uom
1289: FROM gmd_routings_b
1290: WHERE routing_id = (SELECT routing_id
1291: FROM gme_batch_header
1292: WHERE batch_id = v_batch_id);
1293:
1294: CURSOR cur_item_no (v_item_id NUMBER, v_org_id NUMBER)
1295: IS

Line 1314: l_batch_header gme_batch_header%ROWTYPE;

1310: l_plan_wipplan_qty NUMBER := 0;
1311: l_temp_qty NUMBER;
1312: l_um_type sy_uoms_typ.um_type%TYPE;
1313: bad_yield_type EXCEPTION;
1314: l_batch_header gme_batch_header%ROWTYPE;
1315: BEGIN
1316: x_return_status := fnd_api.g_ret_sts_success;
1317: --l_um_type := fnd_profile.VALUE ('FM_YIELD_TYPE');
1318: l_batch_header := p_batch_header_rec;

Line 1399: p_batch_id IN gme_batch_header.batch_id%TYPE

1395: x_return_status := 'U';
1396: END get_total_qty;
1397:
1398: PROCEDURE scale_step_and_rsrc (
1399: p_batch_id IN gme_batch_header.batch_id%TYPE
1400: ,p_routing_scale_factor IN NUMBER
1401: ,x_return_status OUT NOCOPY VARCHAR2)
1402: IS
1403: /* Local variables */

Line 1429: FROM gme_batch_header

1425:
1426: CURSOR cur_get_batch_info
1427: IS
1428: SELECT automatic_step_calculation, update_inventory_ind
1429: FROM gme_batch_header
1430: WHERE batch_id = p_batch_id;
1431:
1432: CURSOR cur_get_all_steps (v_batch_id NUMBER)
1433: IS

Line 1445: v_batch_id gme_batch_header.batch_id%TYPE

1441: FROM gme_batch_step_resources
1442: WHERE batchstep_id = v_step_id AND scale_type <> 0;
1443:
1444: CURSOR cur_get_res_txns (
1445: v_batch_id gme_batch_header.batch_id%TYPE
1446: ,v_res_id gme_batch_step_resources.batchstep_resource_id%TYPE)
1447: IS
1448: SELECT poc_trans_id
1449: FROM gme_resource_txns_gtmp