APPS.GME_TRANS_ENGINE_UTIL dependencies on IC_TRAN_PND

Line 306: FROM ic_tran_pnd i, gme_material_details g

302: ABS (i.trans_qty),
303: i.trans_um,
304: g.item_um,
305: 0) )
306: FROM ic_tran_pnd i, gme_material_details g
307: WHERE doc_id = p_batch_row.batch_id AND
308: doc_type = l_doc_type AND
309: line_id = g.material_detail_id AND
310: -- Bug 3777331 commented next condition since not needed

Line 827: l_def_trans_id ic_tran_pnd.trans_id%TYPE;

823: FROM gme_material_details
824: WHERE batch_id = v_batch_id;
825:
826: get_matl_rec cur_get_matl%ROWTYPE;
827: l_def_trans_id ic_tran_pnd.trans_id%TYPE;
828: l_is_plain BOOLEAN;
829: l_return_status VARCHAR2 (1);
830: l_api_name CONSTANT VARCHAR2 (30) := 'SET_DEFAULT_LOT_FOR_BATCH';
831: error_fetch_def_lot_id EXCEPTION;

Line 858: p_transaction IN ic_tran_pnd%ROWTYPE

854: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
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

Line 901: ,x_def_trans_id OUT NOCOPY ic_tran_pnd.trans_id%TYPE

897: END deduce_transaction_warehouse;
898:
899: PROCEDURE get_default_lot (
900: p_line_id IN gme_material_details.material_detail_id%TYPE
901: ,x_def_trans_id OUT NOCOPY ic_tran_pnd.trans_id%TYPE
902: ,x_is_plain OUT NOCOPY BOOLEAN
903: ,x_return_status OUT NOCOPY VARCHAR2)
904: IS
905: l_matl_dtl gme_material_details%ROWTYPE;

Line 907: l_ic_tran_pnd ic_tran_pnd%ROWTYPE;

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:
911: CURSOR cur_get_def_trans (

Line 1029: INTO l_ic_tran_pnd

1025: IF l_def_lot_found = FALSE THEN
1026: x_is_plain := TRUE;
1027:
1028: SELECT *
1029: INTO l_ic_tran_pnd
1030: FROM ic_tran_pnd
1031: WHERE trans_id = get_rec.trans_id;
1032:
1033: deduce_transaction_warehouse

Line 1030: FROM ic_tran_pnd

1026: x_is_plain := TRUE;
1027:
1028: SELECT *
1029: INTO l_ic_tran_pnd
1030: FROM ic_tran_pnd
1031: WHERE trans_id = get_rec.trans_id;
1032:
1033: deduce_transaction_warehouse
1034: (p_transaction => l_ic_tran_pnd

Line 1034: (p_transaction => l_ic_tran_pnd

1030: FROM ic_tran_pnd
1031: WHERE trans_id = get_rec.trans_id;
1032:
1033: deduce_transaction_warehouse
1034: (p_transaction => l_ic_tran_pnd
1035: ,p_item_master => l_item_mst
1036: ,x_whse_code => l_tran_whse
1037: ,x_return_status => l_return_status);
1038:

Line 1043: IF (l_tran_whse = l_ic_tran_pnd.whse_code) THEN

1039: IF l_return_status <> x_return_status THEN
1040: RAISE error_deduce_trans_whse;
1041: END IF;
1042:
1043: IF (l_tran_whse = l_ic_tran_pnd.whse_code) THEN
1044: x_def_trans_id := get_rec.trans_id;
1045:
1046: IF l_ic_tran_pnd.completed_ind = 0
1047: OR l_ic_tran_pnd.trans_qty = 0 THEN

Line 1046: IF l_ic_tran_pnd.completed_ind = 0

1042:
1043: IF (l_tran_whse = l_ic_tran_pnd.whse_code) THEN
1044: x_def_trans_id := get_rec.trans_id;
1045:
1046: IF l_ic_tran_pnd.completed_ind = 0
1047: OR l_ic_tran_pnd.trans_qty = 0 THEN
1048: l_def_lot_found := TRUE;
1049: END IF;
1050: END IF;

Line 1047: OR l_ic_tran_pnd.trans_qty = 0 THEN

1043: IF (l_tran_whse = l_ic_tran_pnd.whse_code) THEN
1044: x_def_trans_id := get_rec.trans_id;
1045:
1046: IF l_ic_tran_pnd.completed_ind = 0
1047: OR l_ic_tran_pnd.trans_qty = 0 THEN
1048: l_def_lot_found := TRUE;
1049: END IF;
1050: END IF;
1051: END IF;