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

128: * CONSTRUCT_BATCH_HEADER *
129: * *
130: ************************************************************/
131: FUNCTION construct_batch_header (
132: p_batch_header_rec IN gme_batch_header%ROWTYPE
133: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
134: RETURN BOOLEAN
135: IS
136: l_count NUMBER;

Line 133: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)

129: * *
130: ************************************************************/
131: FUNCTION construct_batch_header (
132: p_batch_header_rec IN gme_batch_header%ROWTYPE
133: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
134: RETURN BOOLEAN
135: IS
136: l_count NUMBER;
137: l_api_name CONSTANT VARCHAR2 (30) := 'CONSTRUCT_BATCH_HEADER';

Line 236: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

232:
233: PROCEDURE create_batch (
234: p_validation_level IN NUMBER
235: := gme_common_pvt.g_max_errors
236: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
237: ,p_batch_size IN NUMBER
238: ,p_batch_size_uom IN VARCHAR2
239: ,p_creation_mode IN VARCHAR2
240: ,p_ignore_qty_below_cap IN VARCHAR2

Line 247: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

243: ,p_contiguity_override IN VARCHAR2
244: ,p_is_phantom IN VARCHAR2 DEFAULT 'N'
245: ,p_sum_all_prod_lines IN VARCHAR2 DEFAULT 'A'
246: ,p_use_least_cost_validity_rule IN VARCHAR2 := fnd_api.g_false
247: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
248: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
249: ,x_return_status OUT NOCOPY VARCHAR2)
250: IS
251: l_in_batch_header gme_batch_header%ROWTYPE;

Line 251: l_in_batch_header gme_batch_header%ROWTYPE;

247: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
248: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
249: ,x_return_status OUT NOCOPY VARCHAR2)
250: IS
251: l_in_batch_header gme_batch_header%ROWTYPE;
252: l_formula_master fm_form_mst%ROWTYPE;
253: l_formula_material fm_matl_dtl%ROWTYPE;
254: l_recipe_validity_rule gmd_recipe_validity_rules%ROWTYPE;
255: l_item_master mtl_system_items_kfv%ROWTYPE;

Line 321: l_batch_header_rec gme_batch_header%ROWTYPE;

317: l_exception_material_tbl gme_common_pvt.exceptions_tab;
318: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
319: l_phantom_exc_material_tbl gme_common_pvt.exceptions_tab; -- nsinghi bug#5200395
320: l_phantom_exc_material_tbl_out gme_common_pvt.exceptions_tab; -- nsinghi bug#5200395
321: l_batch_header_rec gme_batch_header%ROWTYPE;
322: l_batchstep_rec gme_batch_steps%ROWTYPE;
323: x_batchstep_rec gme_batch_steps%ROWTYPE;
324: l_in_material_detail gme_material_details%ROWTYPE;
325: l_item_substituted BOOLEAN;

Line 334: l_in_batch_header1 gme_batch_header%ROWTYPE;

330: --FPBug#4351032
331: l_formula_tbl gmdfmval_pub.formula_detail_tbl;
332: l_new_item_rec mtl_system_items_kfv%ROWTYPE;
333: --5698727
334: l_in_batch_header1 gme_batch_header%ROWTYPE;
335: l_doc_timestamp VARCHAR2(50);
336: l_assignment_type NUMBER;
337: l_document_no gme_batch_header.batch_no%TYPE;
338: --5698727

Line 337: l_document_no gme_batch_header.batch_no%TYPE;

333: --5698727
334: l_in_batch_header1 gme_batch_header%ROWTYPE;
335: l_doc_timestamp VARCHAR2(50);
336: l_assignment_type NUMBER;
337: l_document_no gme_batch_header.batch_no%TYPE;
338: --5698727
339: invalid_item_substitute EXCEPTION;
340: l_gme_batch_header GME_BATCH_HEADER%ROWTYPE;
341:

Line 340: l_gme_batch_header GME_BATCH_HEADER%ROWTYPE;

336: l_assignment_type NUMBER;
337: l_document_no gme_batch_header.batch_no%TYPE;
338: --5698727
339: invalid_item_substitute EXCEPTION;
340: l_gme_batch_header GME_BATCH_HEADER%ROWTYPE;
341:
342: -- Bug 10624995
343: l_change_made NUMBER;
344: l_scale_rec gmd_common_scale.scale_rec;

Line 444: FROM gme_batch_header

440: SELECT 1
441: FROM DUAL
442: WHERE EXISTS (
443: SELECT 1
444: FROM gme_batch_header
445: WHERE batch_no = v_batch_no
446: AND organization_id = v_org_id
447: AND batch_type = v_batch_type);
448:

Line 1679: gme_batch_header_dbl.insert_row (x_batch_header_rec

1675:
1676: /* This is not a migrated batch, so let's indicate so. */
1677: x_batch_header_rec.migrated_batch_ind := 'N';
1678: l_return :=
1679: gme_batch_header_dbl.insert_row (x_batch_header_rec
1680: ,x_batch_header_rec);
1681:
1682: -- If header was inserted OK, then insert the material details. As
1683: -- above, if we are copying text, generate and insert the text and codes first

Line 1709: 'gme_batch_header'

1705:
1706: IF l_fm_text_tbl_row.line_no = -1 THEN
1707: -- Start constructing key field for text code.
1708: l_text_table (l_number_of_text_lines).text :=
1709: 'gme_batch_header'
1710: || '|'
1711: || TO_CHAR (x_batch_header_rec.batch_id)
1712: || '|';
1713: ELSE

Line 1924: ,p_gme_batch_header_rec => x_batch_header_rec

1920: ,p_recipe_rout_resc_tbl => gme_common_pvt.resources
1921: ,p_resc_parameters_tbl => gme_common_pvt.process_parameters
1922: ,p_recipe_rout_matl_tbl => gme_common_pvt.routing_materials
1923: ,p_routing_depd_tbl => gme_common_pvt.step_dependencies
1924: ,p_gme_batch_header_rec => x_batch_header_rec
1925: ,p_use_workday_cal => p_use_workday_cal
1926: ,p_contiguity_override => p_contiguity_override
1927: ,p_ignore_qty_below_cap => p_ignore_qty_below_cap
1928: ,x_return_status => x_return_status);

Line 1934: IF NOT (gme_batch_header_dbl.fetch_row (x_batch_header_rec

1930: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1931: RAISE steps_creation_failure;
1932: END IF;
1933:
1934: IF NOT (gme_batch_header_dbl.fetch_row (x_batch_header_rec
1935: ,x_batch_header_rec) ) THEN
1936: RAISE batch_header_fetch_failure;
1937: END IF;
1938: ELSE

Line 2112: UPDATE gme_batch_header

2108: END IF;
2109: END IF;
2110: END IF;
2111:
2112: UPDATE gme_batch_header
2113: SET plan_start_date = x_batch_header_rec.plan_start_date
2114: ,plan_cmplt_date = x_batch_header_rec.plan_cmplt_date
2115: ,due_date =
2116: NVL (x_batch_header_rec.due_date

Line 2156: UPDATE gme_batch_header

2152: END IF;
2153: END LOOP;
2154:
2155: /* update the batch_no with the actual value */
2156: UPDATE gme_batch_header
2157: SET batch_no = x_batch_header_rec.batch_no
2158: -- Bug 13256866
2159: ,last_updated_by = gme_common_pvt.g_user_ident
2160: ,last_update_date = gme_common_pvt.g_timestamp

Line 2204: UPDATE gme_batch_header

2200: END IF;
2201: -- Routings exists and calculated date is less than date entered,
2202: -- then updates the dates as entered by the user.
2203: ELSE
2204: UPDATE gme_batch_header
2205: SET plan_cmplt_date = p_batch_header_rec.plan_cmplt_date
2206: ,due_date =
2207: NVL (x_batch_header_rec.due_date
2208: ,p_batch_header_rec.plan_cmplt_date)

Line 2216: UPDATE gme_batch_header

2212: WHERE batch_id = x_batch_header_rec.batch_id;
2213: END IF;
2214: END IF; -- End gme_common_pvt.routings.COUNT <> 0
2215:
2216: UPDATE gme_batch_header
2217: SET plan_cmplt_date = p_batch_header_rec.plan_cmplt_date
2218: ,due_date =
2219: NVL (x_batch_header_rec.due_date
2220: ,p_batch_header_rec.plan_cmplt_date)

Line 2227: IF NOT (gme_batch_header_dbl.fetch_row (x_batch_header_rec

2223: ,last_update_login = gme_common_pvt.g_login_id
2224: WHERE batch_id = x_batch_header_rec.batch_id;
2225: END IF; -- End start and completion dates not null.
2226:
2227: IF NOT (gme_batch_header_dbl.fetch_row (x_batch_header_rec
2228: ,x_batch_header_rec) ) THEN
2229: RAISE batch_header_fetch_failure;
2230: END IF;
2231:

Line 2440: UPDATE gme_batch_header

2436: l_in_material_detail.batch_id := x_batch_header_rec.batch_id;
2437: IF NOT gme_material_details_dbl.fetch_tab(l_in_material_detail, l_material_details) THEN
2438: RAISE material_dtl_fetch_failure;
2439: END IF;
2440: UPDATE gme_batch_header
2441: SET due_date =
2442: x_batch_header_rec.plan_cmplt_date
2443: ,last_updated_by = gme_common_pvt.g_user_ident
2444: ,last_update_date = gme_common_pvt.g_timestamp

Line 2589: l_gme_batch_header.fixed_process_loss_applied := p_batch_header_rec.fixed_process_loss_applied;

2585: g_no_phant_short_check := 1;
2586:
2587: -- Bug 7830838 - Use the same value from the parent batch so that FPL
2588: -- gets properly applied or not applied based on user settings.
2589: l_gme_batch_header.fixed_process_loss_applied := p_batch_header_rec.fixed_process_loss_applied;
2590: gme_phantom_pvt.create_phantom
2591: (p_material_detail_rec => l_material_details_in
2592: ,p_batch_header_rec => l_gme_batch_header --would be nul in this case
2593: ,x_material_detail_rec => l_material_details

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

2588: -- gets properly applied or not applied based on user settings.
2589: l_gme_batch_header.fixed_process_loss_applied := p_batch_header_rec.fixed_process_loss_applied;
2590: gme_phantom_pvt.create_phantom
2591: (p_material_detail_rec => l_material_details_in
2592: ,p_batch_header_rec => l_gme_batch_header --would be nul in this case
2593: ,x_material_detail_rec => l_material_details
2594: (l_row_count)
2595: ,p_validity_rule_id => NULL
2596: ,p_use_workday_cal => p_use_workday_cal

Line 2700: UPDATE gme_batch_header

2696: END IF;
2697: END IF;
2698:
2699: /* Update batch header with move_order_header_id */
2700: UPDATE gme_batch_header
2701: SET move_order_header_id = x_batch_header_rec.move_order_header_id
2702: -- Bug 13256866
2703: ,last_updated_by = gme_common_pvt.g_user_ident
2704: ,last_update_date = gme_common_pvt.g_timestamp

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

2912: l_numerator NUMBER;
2913: l_total_output_qty NUMBER;
2914: l_step_qty NUMBER;
2915:
2916: CURSOR step_mtq_cursor (x_batch_id gme_batch_header.batch_id%TYPE) IS
2917: SELECT *
2918: FROM gme_batch_steps
2919: WHERE batch_id = x_batch_id ;
2920:

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

2917: SELECT *
2918: FROM gme_batch_steps
2919: WHERE batch_id = x_batch_id ;
2920:
2921: CURSOR calculate_mtq_cursor (x_batch_id gme_batch_header.batch_id%TYPE,
2922: x_routingstep_id fm_rout_dtl.routingstep_id%TYPE) IS
2923:
2924: -- Bug 8226667 - Changed select from inline calculation to using variables.
2925: /*

Line 2959: gme_batch_header gbh,

2955: fm_matl_dtl fmd,
2956: fm_rout_hdr frh,
2957: fm_rout_dtl frd,
2958: mtl_system_items iim,
2959: gme_batch_header gbh,
2960: gmd_recipe_validity_rules ffe
2961: WHERE gbh.batch_id = x_batch_id
2962: AND ffm.formula_id = gbh.formula_id
2963: AND ffm.formula_id = fmd.formula_id