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

Line 32: FROM gme_material_details dtl, gme_batch_header hdr

28: AND step_status NOT IN (gme_common_pvt.g_step_completed, gme_common_pvt.g_step_closed);
29:
30: CURSOR Cur_get_phantom_batch(v_batch_id NUMBER) IS
31: SELECT hdr.*
32: FROM gme_material_details dtl, gme_batch_header hdr
33: WHERE dtl.batch_id = v_batch_id
34: AND dtl.line_type = gme_common_pvt.g_line_type_ing
35: AND dtl.phantom_id IS NOT NULL
36: AND hdr.batch_id = dtl.phantom_id

Line 41: FROM gme_material_details

37: AND hdr.batch_status NOT IN (gme_common_pvt.g_batch_completed, gme_common_pvt.g_batch_closed);
38:
39: CURSOR cur_lock_batch_ingredients (v_batch_id NUMBER) IS
40: SELECT *
41: FROM gme_material_details
42: WHERE batch_id = v_batch_id
43: AND (line_type = gme_common_pvt.g_line_type_ing OR
44: (line_type = gme_common_pvt.g_line_type_prod AND phantom_line_id IS NOT NULL))
45: FOR UPDATE OF actual_qty NOWAIT;

Line 49: FROM gme_material_details

45: FOR UPDATE OF actual_qty NOWAIT;
46:
47: CURSOR Cur_lock_batch_products(v_batch_id NUMBER) IS
48: SELECT *
49: FROM gme_material_details
50: WHERE batch_id = v_batch_id
51: AND line_type IN (gme_common_pvt.g_line_type_prod,gme_common_pvt.g_line_type_byprod)
52: AND phantom_line_id IS NULL -- no phantom products
53: FOR UPDATE OF actual_qty NOWAIT;

Line 56: l_table_name CONSTANT VARCHAR2 (30) := 'gme_material_details';

52: AND phantom_line_id IS NULL -- no phantom products
53: FOR UPDATE OF actual_qty NOWAIT;
54:
55: l_api_name CONSTANT VARCHAR2 (30) := 'COMPLETE_BATCH';
56: l_table_name CONSTANT VARCHAR2 (30) := 'gme_material_details';
57:
58: l_step_status NUMBER;
59: l_matl_dtl_tab_ing gme_common_pvt.material_details_tab;
60: l_matl_dtl_tab gme_common_pvt.material_details_tab;

Line 63: l_matl_dtl gme_material_details%ROWTYPE;

59: l_matl_dtl_tab_ing gme_common_pvt.material_details_tab;
60: l_matl_dtl_tab gme_common_pvt.material_details_tab;
61: l_btch_hdr gme_batch_header%ROWTYPE;
62: l_btch_hdr_tab gme_common_pvt.batch_headers_tab;
63: l_matl_dtl gme_material_details%ROWTYPE;
64: l_matl_dtl_rec gme_material_details%ROWTYPE;
65: l_step_tab gme_common_pvt.steps_tab;
66: l_batch_step_rec gme_batch_steps%ROWTYPE;
67: l_yield_type NUMBER;

Line 64: l_matl_dtl_rec gme_material_details%ROWTYPE;

60: l_matl_dtl_tab gme_common_pvt.material_details_tab;
61: l_btch_hdr gme_batch_header%ROWTYPE;
62: l_btch_hdr_tab gme_common_pvt.batch_headers_tab;
63: l_matl_dtl gme_material_details%ROWTYPE;
64: l_matl_dtl_rec gme_material_details%ROWTYPE;
65: l_step_tab gme_common_pvt.steps_tab;
66: l_batch_step_rec gme_batch_steps%ROWTYPE;
67: l_yield_type NUMBER;
68: l_phantom_batch gme_batch_header%ROWTYPE;

Line 393: (p_material_detail_rec IN gme_material_details%ROWTYPE

389: END complete_batch;
390:
391:
392: PROCEDURE process_material
393: (p_material_detail_rec IN gme_material_details%ROWTYPE
394: ,p_yield IN BOOLEAN
395: ,p_trans_date IN DATE
396: ,p_update_inv_ind IN VARCHAR2
397: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab

Line 403: l_matl_dtl_rec gme_material_details%ROWTYPE;

399:
400:
401: l_api_name CONSTANT VARCHAR2 (30) := 'process_material';
402:
403: l_matl_dtl_rec gme_material_details%ROWTYPE;
404: l_in_phantom_batch_rec gme_batch_header%ROWTYPE;
405: l_phantom_batch_rec gme_batch_header%ROWTYPE;
406: l_return_status VARCHAR2(1);
407: l_item_rec mtl_system_items_b%ROWTYPE;

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

586:
587: -- set WIP plan qty
588: l_matl_dtl_rec.wip_plan_qty := l_matl_dtl_rec.plan_qty;
589:
590: IF NOT gme_material_details_dbl.update_row (l_matl_dtl_rec) THEN
591: RAISE error_update_row;
592: END IF;
593:
594: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN

Line 614: PROCEDURE yield_material(p_material_dtl_rec IN gme_material_details%ROWTYPE

610: END process_material;
611:
612:
613: -- Note: p_yield_qty is the target actual qty; for incr, it's also the target, not the incr
614: PROCEDURE yield_material(p_material_dtl_rec IN gme_material_details%ROWTYPE
615: ,p_yield_qty IN NUMBER
616: ,p_trans_date IN DATE
617: ,p_item_rec IN mtl_system_items_b%ROWTYPE
618: ,p_force_unconsumed IN VARCHAR2

Line 861: (p_mtl_dtl_rec IN gme_material_details%ROWTYPE

857: x_return_status := FND_API.g_ret_sts_unexp_error;
858: END yield_material;
859:
860: PROCEDURE build_and_create_transaction
861: (p_mtl_dtl_rec IN gme_material_details%ROWTYPE
862: ,p_pp_lot_rec IN gme_pending_product_lots%ROWTYPE
863: ,p_subinv IN VARCHAR2
864: ,p_locator_id IN NUMBER
865: ,p_trans_date IN DATE

Line 1024: (p_mtl_dtl_rec IN gme_material_details%ROWTYPE

1020: x_return_status := FND_API.g_ret_sts_unexp_error;
1021: END build_and_create_transaction;
1022:
1023: PROCEDURE constr_mmti
1024: (p_mtl_dtl_rec IN gme_material_details%ROWTYPE
1025: ,p_yield_qty IN NUMBER
1026: ,p_subinv IN VARCHAR2
1027: ,p_locator_id IN NUMBER
1028: ,p_revision IN VARCHAR2