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_MATERIAL_DETAILS

Line 185: l_gme_material_detail gme_material_details%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;
185: l_gme_material_detail gme_material_details%ROWTYPE;
186: l_text_header gme_text_header%ROWTYPE;
187: l_text_string gme_text_table.text%TYPE;
188: l_material_details gme_common_pvt.material_details_tab;
189: p_material_details gme_common_pvt.material_details_tab;

Line 191: l_material_details_in gme_material_details%ROWTYPE;

187: l_text_string gme_text_table.text%TYPE;
188: l_material_details gme_common_pvt.material_details_tab;
189: p_material_details gme_common_pvt.material_details_tab;
190: l_in_material_details gme_common_pvt.material_details_tab;
191: l_material_details_in gme_material_details%ROWTYPE;
192: l_item_masters gme_common_pvt.item_masters_tab;
193: l_text_table gme_common_pvt.text_tab;
194: l_recipe gmd_recipes%ROWTYPE;
195: l_from_uom mtl_units_of_measure.uom_code%TYPE;

Line 251: l_in_material_detail gme_material_details%ROWTYPE;

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;
253: l_curr_item_substituted BOOLEAN;
254: l_ingred_req_date DATE;
255: material_dtl_fetch_failure EXCEPTION;

Line 343: FROM gme_material_details

339:
340: CURSOR get_prim_prod (v_batch_id NUMBER, v_inventory_item_id NUMBER)
341: IS
342: SELECT plan_qty, dtl_um
343: FROM gme_material_details
344: WHERE batch_id = v_batch_id
345: AND inventory_item_id = v_inventory_item_id
346: AND line_type = gme_common_pvt.g_line_type_prod
347: ORDER BY line_no ASC;

Line 361: FROM gme_material_details

357: ,dtl_um
358: ,p_batch_size_uom
359: ,NULL
360: ,NULL) )
361: FROM gme_material_details
362: WHERE batch_id = v_batch_id
363: AND inventory_item_id = v_inventory_item_id
364: AND line_type = gme_common_pvt.g_line_type_prod;
365: /*CURSOR cur_batch_qty (v_batch_id NUMBER, v_inventory_item_id NUMBER)

Line 368: FROM gme_material_details

364: AND line_type = gme_common_pvt.g_line_type_prod;
365: /*CURSOR cur_batch_qty (v_batch_id NUMBER, v_inventory_item_id NUMBER)
366: IS
367: SELECT SUM (plan_qty )
368: FROM gme_material_details
369: WHERE batch_id = v_batch_id
370: AND inventory_item_id = v_inventory_item_id
371: AND line_type = gme_common_pvt.g_line_type_prod; */
372:

Line 1529: 'gme_material_details'

1525:
1526: IF l_fm_text_tbl_row.line_no = -1 THEN
1527: -- Start constructing key field for text code.
1528: l_text_string :=
1529: 'gme_material_details'
1530: || '|'
1531: || TO_CHAR
1532: (l_material_details (l_row_count).batch_id)
1533: || '|';

Line 1602: gme_material_details_dbl.insert_row

1598: gme_debug.put_line ('MATERTIAL lines to be INSERTED ' || l_row_count);
1599: END IF;
1600:
1601: l_return :=
1602: gme_material_details_dbl.insert_row
1603: (l_material_details (l_row_count)
1604: ,l_material_details (l_row_count) );
1605:
1606: IF (g_debug = gme_debug.g_log_statement) THEN

Line 2103: gme_material_details_dbl.update_row

2099: END IF; /* phantom type and line type check */
2100: --FPBug#4351032 End
2101:
2102: l_return :=
2103: gme_material_details_dbl.update_row
2104: (l_material_details (l_row_count) );
2105: /* FPBug#4351032 Updating original primary qty field manually
2106: as this update is not allowed in above dbl procedure */
2107:

Line 2108: UPDATE gme_material_details

2104: (l_material_details (l_row_count) );
2105: /* FPBug#4351032 Updating original primary qty field manually
2106: as this update is not allowed in above dbl procedure */
2107:
2108: UPDATE gme_material_details
2109: SET original_primary_qty = l_material_details (l_row_count).original_primary_qty
2110: WHERE material_detail_id = l_material_details (l_row_count).material_detail_id;
2111:
2112: -- nsinghi bug#5674398

Line 2177: IF NOT gme_material_details_dbl.fetch_tab(l_in_material_detail, l_material_details) THEN

2173: /* nsinghi bug#5674398 Added the FETCH condition. Reschedule_batch will update the
2174: material_requirement_date, hence requery material detail records */
2175:
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 =

Line 2431: gme_material_details_dbl.update_row (l_material_details (i) );

2427:
2428: /* Update material details table we have computed material requirement date and move_order_line_id */
2429: FOR i IN 1 .. l_material_details.COUNT LOOP
2430: l_return :=
2431: gme_material_details_dbl.update_row (l_material_details (i) );
2432: END LOOP;
2433:
2434: /* Create High Level Reservations */
2435: IF (gme_common_pvt.g_create_high_level_resv_ind = 1) THEN