APPS.GMI_OM_UTILITIES_PKG dependencies on IC_TRAN_PND

Line 69: FROM ic_tran_pnd

65:
66:
67: CURSOR Get_Trans_Id_Cur(p_delivery_detail_id IN NUMBER) IS
68: SELECT trans_id ,line_id, trans_qty, trans_qty2
69: FROM ic_tran_pnd
70: WHERE line_id = l_txn_source_line_id
71: AND line_detail_id = p_delivery_detail_id
72: AND doc_type = 'OMSO'
73: AND completed_ind = 0

Line 78: CURSOR Get_Default_Trans(p_line_id ic_tran_pnd.line_id%TYPE) IS

74: AND delete_mark = 0
75: AND staged_ind <> 1
76: AND ( lot_id <> 0 OR location <> l_IC$DEFAULT_LOCT);
77:
78: CURSOR Get_Default_Trans(p_line_id ic_tran_pnd.line_id%TYPE) IS
79: SELECT trans_id
80: FROM ic_tran_pnd
81: WHERE line_id = p_line_id
82: AND line_detail_id IS NULL

Line 80: FROM ic_tran_pnd

76: AND ( lot_id <> 0 OR location <> l_IC$DEFAULT_LOCT);
77:
78: CURSOR Get_Default_Trans(p_line_id ic_tran_pnd.line_id%TYPE) IS
79: SELECT trans_id
80: FROM ic_tran_pnd
81: WHERE line_id = p_line_id
82: AND line_detail_id IS NULL
83: AND doc_type = 'OMSO'
84: AND delete_mark = 0

Line 95: l_tran_row IC_TRAN_PND%ROWTYPE;

91: l_default_trans_id NUMBER;
92: wdd_row wdd_cur%ROWTYPE;
93: get_trans_id_row get_trans_id_cur%ROWTYPE;
94: l_return_status VARCHAR2(1);
95: l_tran_row IC_TRAN_PND%ROWTYPE;
96: l_msg_count NUMBER :=0;
97: l_msg_data VARCHAR2(2000) := '';
98: l_mode VARCHAR2(2);
99: l_api_return_status VARCHAR2(10);

Line 217: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND (l_in_tran_rec, l_out_tran_rec) THEN

213:
214: IF NVL(l_default_trans_id,0) <> 0 THEN
215: l_in_tran_rec.trans_id := l_default_trans_id ;
216:
217: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND (l_in_tran_rec, l_out_tran_rec) THEN
218: gmi_reservation_util.println('In Delete_Alloc_BackOrder_MO_Line before call to GMI_Reservation_Util.balance_default_lot');
219: GMI_Reservation_Util.balance_default_lot(
220: p_ic_default_rec => l_out_tran_rec
221: , p_opm_item_id => l_out_tran_rec.item_id