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

395: END complete_batch;
396:
397:
398: PROCEDURE process_material
399: (p_material_detail_rec IN gme_material_details%ROWTYPE
400: ,p_yield IN BOOLEAN
401: ,p_trans_date IN DATE
402: ,p_update_inv_ind IN VARCHAR2
403: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab

Line 409: l_matl_dtl_rec gme_material_details%ROWTYPE;

405:
406:
407: l_api_name CONSTANT VARCHAR2 (30) := 'process_material';
408:
409: l_matl_dtl_rec gme_material_details%ROWTYPE;
410: l_in_phantom_batch_rec gme_batch_header%ROWTYPE;
411: l_phantom_batch_rec gme_batch_header%ROWTYPE;
412: l_return_status VARCHAR2(1);
413: l_item_rec mtl_system_items_b%ROWTYPE;

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

593: -- set WIP plan qty
594: -- Commented the below line for Bug 8483455
595: --l_matl_dtl_rec.wip_plan_qty := l_matl_dtl_rec.plan_qty;
596:
597: IF NOT gme_material_details_dbl.update_row (l_matl_dtl_rec) THEN
598: RAISE error_update_row;
599: END IF;
600:
601: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN

Line 621: PROCEDURE yield_material(p_material_dtl_rec IN gme_material_details%ROWTYPE

617: END process_material;
618:
619:
620: -- Note: p_yield_qty is the target actual qty; for incr, it's also the target, not the incr
621: PROCEDURE yield_material(p_material_dtl_rec IN gme_material_details%ROWTYPE
622: ,p_yield_qty IN NUMBER
623: ,p_trans_date IN DATE
624: ,p_item_rec IN mtl_system_items_b%ROWTYPE
625: ,p_force_unconsumed IN VARCHAR2

Line 868: (p_mtl_dtl_rec IN gme_material_details%ROWTYPE

864: x_return_status := FND_API.g_ret_sts_unexp_error;
865: END yield_material;
866:
867: PROCEDURE build_and_create_transaction
868: (p_mtl_dtl_rec IN gme_material_details%ROWTYPE
869: ,p_pp_lot_rec IN gme_pending_product_lots%ROWTYPE
870: ,p_subinv IN VARCHAR2
871: ,p_locator_id IN NUMBER
872: ,p_trans_date IN DATE

Line 1100: (p_mtl_dtl_rec IN gme_material_details%ROWTYPE

1096: x_return_status := FND_API.g_ret_sts_unexp_error;
1097: END build_and_create_transaction;
1098:
1099: PROCEDURE constr_mmti
1100: (p_mtl_dtl_rec IN gme_material_details%ROWTYPE
1101: ,p_yield_qty IN NUMBER
1102: ,p_subinv IN VARCHAR2
1103: ,p_locator_id IN NUMBER
1104: ,p_revision IN VARCHAR2