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 291: (p_material_detail_rec IN gme_material_details%ROWTYPE

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

Line 301: l_matl_dtl_rec gme_material_details%ROWTYPE;

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

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

434: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' before update_row; actual_qty='||l_matl_dtl_rec.actual_qty);
435: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' before update_row; wip_plan_qty='||l_matl_dtl_rec.wip_plan_qty);
436: END IF;
437:
438: IF NOT gme_material_details_dbl.update_row (l_matl_dtl_rec) THEN
439: RAISE error_update_row;
440: END IF;
441: END IF;
442:

Line 465: PROCEDURE consume_material(p_material_dtl_rec IN gme_material_details%ROWTYPE

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

Line 928: ,p_mtl_dtl_rec IN gme_material_details%ROWTYPE

924: ,p_locator_id IN NUMBER DEFAULT NULL
925: ,p_att IN NUMBER DEFAULT NULL
926: ,p_satt IN NUMBER DEFAULT NULL
927: ,p_primary_uom_code IN VARCHAR2 DEFAULT NULL
928: ,p_mtl_dtl_rec IN gme_material_details%ROWTYPE
929: ,p_trans_date IN DATE
930: ,p_consume_qty IN NUMBER
931: ,p_revision IN VARCHAR2 DEFAULT NULL
932: ,p_secondary_uom_code IN VARCHAR2 DEFAULT NULL

Line 1307: (p_mtl_dtl_rec IN gme_material_details%ROWTYPE

1303:
1304: END constr_mmti_from_reservation;
1305:
1306: PROCEDURE constr_mmti_from_qty_tree
1307: (p_mtl_dtl_rec IN gme_material_details%ROWTYPE
1308: ,p_subinv IN VARCHAR2
1309: ,p_locator_id IN NUMBER
1310: ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE
1311: ,x_return_status OUT NOCOPY VARCHAR2) IS

Line 1352: (p_material_dtl_rec IN gme_material_details%ROWTYPE

1348:
1349: END constr_mmti_from_qty_tree;
1350:
1351: PROCEDURE create_batch_exception
1352: (p_material_dtl_rec IN gme_material_details%ROWTYPE
1353: ,p_pending_move_order_ind IN BOOLEAN := NULL
1354: ,p_pending_rsrv_ind IN BOOLEAN := NULL
1355: ,p_transacted_qty IN NUMBER := NULL
1356: ,p_exception_qty IN NUMBER := NULL

Line 1524: FROM gme_material_details

1520: ,x_return_status OUT NOCOPY VARCHAR2) IS
1521:
1522: CURSOR cur_get_phantom_ingred(v_batch_id NUMBER) IS
1523: SELECT *
1524: FROM gme_material_details
1525: WHERE batch_id = v_batch_id
1526: AND line_type = gme_common_pvt.g_line_type_ing
1527: AND phantom_type <> 0;
1528: