DBA Data[Home] [Help]

APPS.GME_TRANS_ENGINE_UTIL dependencies on IC_ITEM_MST

Line 859: ,p_item_master IN ic_item_mst%ROWTYPE

855: END set_default_lot_for_batch;
856:
857: PROCEDURE deduce_transaction_warehouse (
858: p_transaction IN ic_tran_pnd%ROWTYPE
859: ,p_item_master IN ic_item_mst%ROWTYPE
860: ,x_whse_code OUT NOCOPY ps_whse_eff.whse_code%TYPE
861: ,x_return_status OUT NOCOPY VARCHAR2)
862: IS
863: CURSOR cur_eff_whse (

Line 906: l_item_mst ic_item_mst%ROWTYPE;

902: ,x_is_plain OUT NOCOPY BOOLEAN
903: ,x_return_status OUT NOCOPY VARCHAR2)
904: IS
905: l_matl_dtl gme_material_details%ROWTYPE;
906: l_item_mst ic_item_mst%ROWTYPE;
907: l_ic_tran_pnd ic_tran_pnd%ROWTYPE;
908: l_whse_loct_ctl ic_whse_mst.whse_code%TYPE;
909: l_def_lot_found BOOLEAN;
910:

Line 963: FROM ic_item_mst

959: WHERE material_detail_id = p_line_id;
960:
961: SELECT *
962: INTO l_item_mst
963: FROM ic_item_mst
964: WHERE item_id = l_matl_dtl.item_id;
965:
966: SELECT batch_type
967: INTO l_batch_type