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_CREATE_BATCH_PVT dependencies on GME_BATCH_HEADER

Line 62: p_batch_header_rec IN gme_batch_header%ROWTYPE

58: * CONSTRUCT_BATCH_HEADER *
59: * *
60: ************************************************************/
61: FUNCTION construct_batch_header (
62: p_batch_header_rec IN gme_batch_header%ROWTYPE
63: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
64: RETURN BOOLEAN
65: IS
66: l_count NUMBER;

Line 63: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)

59: * *
60: ************************************************************/
61: FUNCTION construct_batch_header (
62: p_batch_header_rec IN gme_batch_header%ROWTYPE
63: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
64: RETURN BOOLEAN
65: IS
66: l_count NUMBER;
67: l_api_name CONSTANT VARCHAR2 (30) := 'CONSTRUCT_BATCH_HEADER';

Line 166: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

162:
163: PROCEDURE create_batch (
164: p_validation_level IN NUMBER
165: := gme_common_pvt.g_max_errors
166: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
167: ,p_batch_size IN NUMBER
168: ,p_batch_size_uom IN VARCHAR2
169: ,p_creation_mode IN VARCHAR2
170: ,p_ignore_qty_below_cap IN VARCHAR2

Line 176: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

172: ,p_use_workday_cal IN VARCHAR2
173: ,p_contiguity_override IN VARCHAR2
174: ,p_is_phantom IN VARCHAR2 DEFAULT 'N'
175: ,p_use_least_cost_validity_rule IN VARCHAR2 := fnd_api.g_false
176: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
177: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
178: ,x_return_status OUT NOCOPY VARCHAR2)
179: IS
180: l_in_batch_header gme_batch_header%ROWTYPE;

Line 180: l_in_batch_header gme_batch_header%ROWTYPE;

176: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
177: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
178: ,x_return_status OUT NOCOPY VARCHAR2)
179: IS
180: l_in_batch_header gme_batch_header%ROWTYPE;
181: l_formula_master fm_form_mst%ROWTYPE;
182: l_formula_material fm_matl_dtl%ROWTYPE;
183: l_recipe_validity_rule gmd_recipe_validity_rules%ROWTYPE;
184: l_item_master mtl_system_items_kfv%ROWTYPE;

Line 248: l_batch_header_rec gme_batch_header%ROWTYPE;

244: l_exception_material_tbl gme_common_pvt.exceptions_tab;
245: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
246: l_phantom_exc_material_tbl gme_common_pvt.exceptions_tab; -- nsinghi bug#5200395
247: l_phantom_exc_material_tbl_out gme_common_pvt.exceptions_tab; -- nsinghi bug#5200395
248: l_batch_header_rec gme_batch_header%ROWTYPE;
249: l_batchstep_rec gme_batch_steps%ROWTYPE;
250: x_batchstep_rec gme_batch_steps%ROWTYPE;
251: l_in_material_detail gme_material_details%ROWTYPE;
252: l_item_substituted BOOLEAN;

Line 261: l_in_batch_header1 gme_batch_header%ROWTYPE;

257: --FPBug#4351032
258: l_formula_tbl gmdfmval_pub.formula_detail_tbl;
259: l_new_item_rec mtl_system_items_kfv%ROWTYPE;
260: --5698727
261: l_in_batch_header1 gme_batch_header%ROWTYPE;
262: l_doc_timestamp VARCHAR2(50);
263: l_assignment_type NUMBER;
264: l_document_no gme_batch_header.batch_no%TYPE;
265: --5698727

Line 264: l_document_no gme_batch_header.batch_no%TYPE;

260: --5698727
261: l_in_batch_header1 gme_batch_header%ROWTYPE;
262: l_doc_timestamp VARCHAR2(50);
263: l_assignment_type NUMBER;
264: l_document_no gme_batch_header.batch_no%TYPE;
265: --5698727
266: invalid_item_substitute EXCEPTION;
267: l_gme_batch_header GME_BATCH_HEADER%ROWTYPE;
268:

Line 267: l_gme_batch_header GME_BATCH_HEADER%ROWTYPE;

263: l_assignment_type NUMBER;
264: l_document_no gme_batch_header.batch_no%TYPE;
265: --5698727
266: invalid_item_substitute EXCEPTION;
267: l_gme_batch_header GME_BATCH_HEADER%ROWTYPE;
268:
269: CURSOR recipe_validity_rule_cursor (v_recipe_validity_rule_id NUMBER)
270: IS
271: SELECT *

Line 335: FROM gme_batch_header

331: SELECT 1
332: FROM DUAL
333: WHERE EXISTS (
334: SELECT 1
335: FROM gme_batch_header
336: WHERE batch_no = v_batch_no
337: AND organization_id = v_org_id
338: AND batch_type = v_batch_type);
339:

Line 1450: gme_batch_header_dbl.insert_row (x_batch_header_rec

1446:
1447: /* This is not a migrated batch, so let's indicate so. */
1448: x_batch_header_rec.migrated_batch_ind := 'N';
1449: l_return :=
1450: gme_batch_header_dbl.insert_row (x_batch_header_rec
1451: ,x_batch_header_rec);
1452:
1453: -- If header was inserted OK, then insert the material details. As
1454: -- above, if we are copying text, generate and insert the text and codes first

Line 1480: 'gme_batch_header'

1476:
1477: IF l_fm_text_tbl_row.line_no = -1 THEN
1478: -- Start constructing key field for text code.
1479: l_text_table (l_number_of_text_lines).text :=
1480: 'gme_batch_header'
1481: || '|'
1482: || TO_CHAR (x_batch_header_rec.batch_id)
1483: || '|';
1484: ELSE

Line 1695: ,p_gme_batch_header_rec => x_batch_header_rec

1691: ,p_recipe_rout_resc_tbl => gme_common_pvt.resources
1692: ,p_resc_parameters_tbl => gme_common_pvt.process_parameters
1693: ,p_recipe_rout_matl_tbl => gme_common_pvt.routing_materials
1694: ,p_routing_depd_tbl => gme_common_pvt.step_dependencies
1695: ,p_gme_batch_header_rec => x_batch_header_rec
1696: ,p_use_workday_cal => p_use_workday_cal
1697: ,p_contiguity_override => p_contiguity_override
1698: ,p_ignore_qty_below_cap => p_ignore_qty_below_cap
1699: ,x_return_status => x_return_status);

Line 1705: IF NOT (gme_batch_header_dbl.fetch_row (x_batch_header_rec

1701: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1702: RAISE steps_creation_failure;
1703: END IF;
1704:
1705: IF NOT (gme_batch_header_dbl.fetch_row (x_batch_header_rec
1706: ,x_batch_header_rec) ) THEN
1707: RAISE batch_header_fetch_failure;
1708: END IF;
1709: ELSE

Line 1883: UPDATE gme_batch_header

1879: END IF;
1880: END IF;
1881: END IF;
1882:
1883: UPDATE gme_batch_header
1884: SET plan_start_date = x_batch_header_rec.plan_start_date
1885: ,plan_cmplt_date = x_batch_header_rec.plan_cmplt_date
1886: ,due_date =
1887: NVL (x_batch_header_rec.due_date

Line 1907: UPDATE gme_batch_header

1903: RAISE wip_entity_err;
1904: END IF;
1905:
1906: /* update the batch_no with the actual value */
1907: UPDATE gme_batch_header
1908: SET batch_no = x_batch_header_rec.batch_no
1909: WHERE batch_id = x_batch_header_rec.batch_id;
1910:
1911: /*5698727 rework update the wip_entities table with actual batch no*/

Line 1951: UPDATE gme_batch_header

1947: END IF;
1948: -- Routings exists and calculated date is less than date entered,
1949: -- then updates the dates as entered by the user.
1950: ELSE
1951: UPDATE gme_batch_header
1952: SET plan_cmplt_date = p_batch_header_rec.plan_cmplt_date
1953: ,due_date =
1954: NVL (x_batch_header_rec.due_date
1955: ,p_batch_header_rec.plan_cmplt_date)

Line 1963: UPDATE gme_batch_header

1959: WHERE batch_id = x_batch_header_rec.batch_id;
1960: END IF;
1961: END IF; -- End gme_common_pvt.routings.COUNT <> 0
1962:
1963: UPDATE gme_batch_header
1964: SET plan_cmplt_date = p_batch_header_rec.plan_cmplt_date
1965: ,due_date =
1966: NVL (x_batch_header_rec.due_date
1967: ,p_batch_header_rec.plan_cmplt_date)

Line 1974: IF NOT (gme_batch_header_dbl.fetch_row (x_batch_header_rec

1970: ,last_update_login = gme_common_pvt.g_login_id
1971: WHERE batch_id = x_batch_header_rec.batch_id;
1972: END IF; -- End start and completion dates not null.
1973:
1974: IF NOT (gme_batch_header_dbl.fetch_row (x_batch_header_rec
1975: ,x_batch_header_rec) ) THEN
1976: RAISE batch_header_fetch_failure;
1977: END IF;
1978:

Line 2180: UPDATE gme_batch_header

2176: l_in_material_detail.batch_id := x_batch_header_rec.batch_id;
2177: IF NOT gme_material_details_dbl.fetch_tab(l_in_material_detail, l_material_details) THEN
2178: RAISE material_dtl_fetch_failure;
2179: END IF;
2180: UPDATE gme_batch_header
2181: SET due_date =
2182: x_batch_header_rec.plan_cmplt_date
2183: ,last_updated_by = gme_common_pvt.g_user_ident
2184: ,last_update_date = gme_common_pvt.g_timestamp

Line 2316: ,p_batch_header_rec => l_gme_batch_header --would be nul in this case

2312: now get_batch_shortages will do it for phantom batches also */
2313: g_no_phant_short_check := 1;
2314: gme_phantom_pvt.create_phantom
2315: (p_material_detail_rec => l_material_details_in
2316: ,p_batch_header_rec => l_gme_batch_header --would be nul in this case
2317: ,x_material_detail_rec => l_material_details
2318: (l_row_count)
2319: ,p_validity_rule_id => NULL
2320: ,p_use_workday_cal => p_use_workday_cal

Line 2424: UPDATE gme_batch_header

2420: END IF;
2421: END IF;
2422:
2423: /* Update batch header with move_order_header_id */
2424: UPDATE gme_batch_header
2425: SET move_order_header_id = x_batch_header_rec.move_order_header_id
2426: WHERE batch_id = x_batch_header_rec.batch_id;
2427:
2428: /* Update material details table we have computed material requirement date and move_order_line_id */

Line 2617: CURSOR step_mtq_cursor (x_batch_id gme_batch_header.batch_id%TYPE) IS

2613: l_batch_steps gme_batch_steps%ROWTYPE;
2614: l_calculated_mtq gme_batch_steps.minimum_transfer_qty%TYPE;
2615: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_STEP_MTQ';
2616:
2617: CURSOR step_mtq_cursor (x_batch_id gme_batch_header.batch_id%TYPE) IS
2618: SELECT *
2619: FROM gme_batch_steps
2620: WHERE batch_id = x_batch_id ;
2621:

Line 2622: CURSOR calculate_mtq_cursor (x_batch_id gme_batch_header.batch_id%TYPE,

2618: SELECT *
2619: FROM gme_batch_steps
2620: WHERE batch_id = x_batch_id ;
2621:
2622: CURSOR calculate_mtq_cursor (x_batch_id gme_batch_header.batch_id%TYPE,
2623: x_routingstep_id fm_rout_dtl.routingstep_id%TYPE) IS
2624:
2625:
2626: SELECT

Line 2644: gme_batch_header gbh,

2640: fm_matl_dtl fmd,
2641: fm_rout_hdr frh,
2642: fm_rout_dtl frd,
2643: mtl_system_items iim,
2644: gme_batch_header gbh,
2645: gmd_recipe_validity_rules ffe
2646: WHERE gbh.batch_id = x_batch_id
2647: AND ffm.formula_id = gbh.formula_id
2648: AND ffm.formula_id = fmd.formula_id