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_RELEASE_BATCH_PVT dependencies on GME_MATERIAL_DETAILS

Line 20: FROM gme_material_details

16:
17:
18: CURSOR Cur_batch_ingredients(v_batch_id NUMBER) IS
19: SELECT *
20: FROM gme_material_details
21: WHERE batch_id = v_batch_id
22: AND line_type = gme_common_pvt.g_line_type_ing;
23:
24: CURSOR Cur_associated_step(v_matl_dtl_id NUMBER) IS

Line 34: l_matl_dtl_rec gme_material_details%ROWTYPE;

30: l_api_name CONSTANT VARCHAR2 (30) := 'RELEASE_BATCH';
31:
32: l_step_rec gme_batch_steps%ROWTYPE;
33: l_matl_dtl_tab gme_common_pvt.material_details_tab;
34: l_matl_dtl_rec gme_material_details%ROWTYPE;
35: l_release_type NUMBER;
36: l_phantom_batch_rec gme_batch_header%ROWTYPE;
37: l_item_rec mtl_system_items_b%ROWTYPE;
38: l_consume BOOLEAN;

Line 155: IF NOT gme_material_details_dbl.fetch_row(l_matl_dtl_rec, l_matl_dtl_rec) THEN

151: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
152: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' yielding phantom product');
153: END IF;
154: l_matl_dtl_rec.material_detail_id := p_phantom_product_id;
155: IF NOT gme_material_details_dbl.fetch_row(l_matl_dtl_rec, l_matl_dtl_rec) THEN
156: RAISE error_fetch_material;
157: END IF;
158:
159: -- l_matl_dtl_rec is the phantom product line

Line 211: UPDATE gme_material_details

207:
208: l_matl_dtl_rec.wip_plan_qty := l_matl_dtl_rec.plan_qty;
209:
210: -- Update the phantom product
211: UPDATE gme_material_details
212: SET actual_qty = l_matl_dtl_rec.actual_qty,
213: wip_plan_qty = l_matl_dtl_rec.wip_plan_qty,
214: last_updated_by = gme_common_pvt.g_user_ident,
215: last_update_date = gme_common_pvt.g_timestamp,

Line 221: UPDATE gme_material_details

217: WHERE material_detail_id = l_matl_dtl_rec.material_detail_id;
218:
219: -- Update the phantom ingredient actual_qty and WIP plan qty...
220: -- the transaction would have been taken care of
221: UPDATE gme_material_details
222: SET actual_qty = l_matl_dtl_rec.actual_qty,
223: wip_plan_qty = l_matl_dtl_rec.wip_plan_qty,
224: last_updated_by = gme_common_pvt.g_user_ident,
225: last_update_date = gme_common_pvt.g_timestamp,

Line 231: UPDATE gme_material_details

227: WHERE material_detail_id = l_matl_dtl_rec.phantom_line_id;
228:
229: END IF;
230:
231: UPDATE gme_material_details
232: SET wip_plan_qty = plan_qty
233: WHERE batch_id = p_batch_header_rec.batch_id
234: AND wip_plan_qty is NULL;
235:

Line 293: (p_material_detail_rec IN gme_material_details%ROWTYPE

289: x_return_status := FND_API.g_ret_sts_unexp_error;
290: END release_batch;
291:
292: PROCEDURE process_ingredient
293: (p_material_detail_rec IN gme_material_details%ROWTYPE
294: ,p_consume IN BOOLEAN
295: ,p_trans_date IN DATE
296: ,p_update_inv_ind IN VARCHAR2
297: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab

Line 303: l_matl_dtl_rec gme_material_details%ROWTYPE;

299:
300:
301: l_api_name CONSTANT VARCHAR2 (30) := 'process_ingredient';
302:
303: l_matl_dtl_rec gme_material_details%ROWTYPE;
304: l_in_phantom_batch_rec gme_batch_header%ROWTYPE;
305: l_phantom_batch_rec gme_batch_header%ROWTYPE;
306: l_return_status VARCHAR2(1);
307: l_item_rec mtl_system_items_b%ROWTYPE;

Line 442: IF NOT gme_material_details_dbl.update_row (l_matl_dtl_rec) THEN

438: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' before update_row; actual_qty='||l_matl_dtl_rec.actual_qty);
439: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' before update_row; wip_plan_qty='||l_matl_dtl_rec.wip_plan_qty);
440: END IF;
441:
442: IF NOT gme_material_details_dbl.update_row (l_matl_dtl_rec) THEN
443: RAISE error_update_row;
444: END IF;
445: END IF;
446:

Line 469: PROCEDURE consume_material(p_material_dtl_rec IN gme_material_details%ROWTYPE

465: x_return_status := FND_API.g_ret_sts_unexp_error;
466: END process_ingredient;
467:
468: -- Note: p_consume_qty is the target actual qty; for incr, it's also the target, not the incr
469: PROCEDURE consume_material(p_material_dtl_rec IN gme_material_details%ROWTYPE
470: ,p_consume_qty IN NUMBER := NULL
471: ,p_trans_date IN DATE := NULL
472: ,p_item_rec IN mtl_system_items_b%ROWTYPE
473: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab

Line 1106: ,p_mtl_dtl_rec IN gme_material_details%ROWTYPE

1102: ,p_locator_id IN NUMBER DEFAULT NULL
1103: ,p_att IN NUMBER DEFAULT NULL
1104: ,p_satt IN NUMBER DEFAULT NULL
1105: ,p_primary_uom_code IN VARCHAR2 DEFAULT NULL
1106: ,p_mtl_dtl_rec IN gme_material_details%ROWTYPE
1107: ,p_trans_date IN DATE
1108: ,p_consume_qty IN NUMBER
1109: ,p_called_by IN VARCHAR2 DEFAULT 'REL'
1110: ,p_revision IN VARCHAR2 DEFAULT NULL

Line 1660: (p_mtl_dtl_rec IN gme_material_details%ROWTYPE

1656:
1657: END constr_mmti_from_reservation;
1658:
1659: PROCEDURE constr_mmti_from_qty_tree
1660: (p_mtl_dtl_rec IN gme_material_details%ROWTYPE
1661: ,p_subinv IN VARCHAR2
1662: ,p_locator_id IN NUMBER
1663: ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE
1664: ,x_return_status OUT NOCOPY VARCHAR2) IS

Line 1705: (p_material_dtl_rec IN gme_material_details%ROWTYPE

1701:
1702: END constr_mmti_from_qty_tree;
1703:
1704: PROCEDURE create_batch_exception
1705: (p_material_dtl_rec IN gme_material_details%ROWTYPE
1706: ,p_pending_move_order_ind IN BOOLEAN := NULL
1707: ,p_pending_rsrv_ind IN BOOLEAN := NULL
1708: ,p_transacted_qty IN NUMBER := NULL
1709: ,p_exception_qty IN NUMBER := NULL

Line 1877: FROM gme_material_details

1873: ,x_return_status OUT NOCOPY VARCHAR2) IS
1874:
1875: CURSOR cur_get_phantom_ingred(v_batch_id NUMBER) IS
1876: SELECT *
1877: FROM gme_material_details
1878: WHERE batch_id = v_batch_id
1879: AND line_type = gme_common_pvt.g_line_type_ing
1880: AND phantom_type <> 0;
1881: