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 30: p_batch_header_rec IN gme_batch_header%ROWTYPE

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

Line 40: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

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

Line 53: FROM gme_batch_header

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

Line 171: p_batch_header_rec IN gme_batch_header%ROWTYPE

167: bach_header and material_details table
168: p_batch_header_rec should have all the columns populated
169: */
170: PROCEDURE scale_batch (
171: p_batch_header_rec IN gme_batch_header%ROWTYPE
172: ,p_material_tbl IN gme_common_pvt.material_details_tab
173: ,p_scale_factor IN NUMBER
174: ,p_primaries IN VARCHAR2
175: ,p_qty_type IN NUMBER

Line 182: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

178: ,p_recalc_dates IN VARCHAR2
179: ,p_use_workday_cal IN VARCHAR2
180: ,p_contiguity_override IN VARCHAR2
181: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
182: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
183: ,x_material_tbl OUT NOCOPY gme_common_pvt.material_details_tab
184: ,x_return_status OUT NOCOPY VARCHAR2)
185: IS
186: /* Local variables */

Line 192: l_batch_header gme_batch_header%ROWTYPE;

188: l_row_count NUMBER;
189: l_recipe_validity_rule gmd_recipe_validity_rules%ROWTYPE;
190: l_scale_tab gmd_common_scale.scale_tab;
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;

Line 193: l_resch_batch_header_rec gme_batch_header%ROWTYPE;

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

Line 194: l_in_batch_header gme_batch_header%ROWTYPE;

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

Line 649: IF NOT (gme_batch_header_dbl.fetch_row (p_batch_header_rec

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

Line 746: IF NOT (gme_batch_header_dbl.fetch_row (l_in_batch_header

742:
743: l_in_batch_header.batch_id :=
744: x_material_tbl (line_index).phantom_id;
745:
746: IF NOT (gme_batch_header_dbl.fetch_row (l_in_batch_header
747: ,l_batch_header) ) THEN
748: RAISE batch_fetch_error;
749: END IF;
750:

Line 984: p_batch_header_rec IN gme_batch_header%ROWTYPE

980: x_return_status := fnd_api.g_ret_sts_unexp_error;
981: END scale_batch;
982:
983: PROCEDURE theoretical_yield_batch (
984: p_batch_header_rec IN gme_batch_header%ROWTYPE
985: ,p_scale_factor IN NUMBER
986: ,x_return_status OUT NOCOPY VARCHAR2)
987: IS
988: /* Buffers for database reads/writes */

Line 997: l_batch_header gme_batch_header%ROWTYPE;

993: l_scale_tab gmd_common_scale.scale_tab;
994: l_in_scale_tab gmd_common_scale.scale_tab;
995: l_scale_factor NUMBER;
996: x_material_details gme_common_pvt.material_details_tab;
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;

Line 1056: IF (NOT gme_batch_header_dbl.fetch_row (p_batch_header_rec

1052: -- gme_api_grp.set_timestamp;
1053: l_scale_factor := p_scale_factor;
1054:
1055: /* Set the savepoint before proceeding */
1056: IF (NOT gme_batch_header_dbl.fetch_row (p_batch_header_rec
1057: ,l_batch_header) ) THEN
1058: RAISE batch_fetch_error;
1059: END IF;
1060:

Line 1293: ,p_batch_header_rec IN gme_batch_header%ROWTYPE)

1289: END theoretical_yield_batch;
1290:
1291: FUNCTION get_total_qty (
1292: p_material_tab IN gme_common_pvt.material_details_tab
1293: ,p_batch_header_rec IN gme_batch_header%ROWTYPE)
1294: RETURN NUMBER
1295: IS
1296: CURSOR get_rout_uom (v_batch_id NUMBER)
1297: IS

Line 1301: FROM gme_batch_header

1297: IS
1298: SELECT routing_uom
1299: FROM gmd_routings_b
1300: WHERE routing_id = (SELECT routing_id
1301: FROM gme_batch_header
1302: WHERE batch_id = v_batch_id);
1303:
1304: CURSOR cur_item_no (v_item_id NUMBER, v_org_id NUMBER)
1305: IS

Line 1324: l_batch_header gme_batch_header%ROWTYPE;

1320: l_plan_wipplan_qty NUMBER := 0;
1321: l_temp_qty NUMBER;
1322: l_um_type sy_uoms_typ.um_type%TYPE;
1323: bad_yield_type EXCEPTION;
1324: l_batch_header gme_batch_header%ROWTYPE;
1325: BEGIN
1326: x_return_status := fnd_api.g_ret_sts_success;
1327: --l_um_type := fnd_profile.VALUE ('FM_YIELD_TYPE');
1328: l_batch_header := p_batch_header_rec;

Line 1409: p_batch_id IN gme_batch_header.batch_id%TYPE

1405: x_return_status := 'U';
1406: END get_total_qty;
1407:
1408: PROCEDURE scale_step_and_rsrc (
1409: p_batch_id IN gme_batch_header.batch_id%TYPE
1410: ,p_routing_scale_factor IN NUMBER
1411: ,x_return_status OUT NOCOPY VARCHAR2)
1412: IS
1413: /* Local variables */

Line 1439: FROM gme_batch_header

1435:
1436: CURSOR cur_get_batch_info
1437: IS
1438: SELECT automatic_step_calculation, update_inventory_ind
1439: FROM gme_batch_header
1440: WHERE batch_id = p_batch_id;
1441:
1442: CURSOR cur_get_all_steps (v_batch_id NUMBER)
1443: IS

Line 1455: v_batch_id gme_batch_header.batch_id%TYPE

1451: FROM gme_batch_step_resources
1452: WHERE batchstep_id = v_step_id AND scale_type <> 0;
1453:
1454: CURSOR cur_get_res_txns (
1455: v_batch_id gme_batch_header.batch_id%TYPE
1456: ,v_res_id gme_batch_step_resources.batchstep_resource_id%TYPE)
1457: IS
1458: SELECT poc_trans_id
1459: FROM gme_resource_txns_gtmp