APPS.GMI_PICK_RELEASE_PVT dependencies on IC_TRAN_PND

Line 103: FROM ic_tran_pnd

99:
100: CURSOR c_get_trans_for_del(source_line_id NUMBER
101: , delivery_detail_id NUMBER) IS
102: SELECT nvl(sum(abs(trans_qty)), 0), nvl(sum(abs(trans_qty2)),0)
103: FROM ic_tran_pnd
104: WHERE line_id = source_line_id
105: AND line_detail_id = delivery_detail_id
106: AND delete_mark = 0 ;
107:

Line 111: FROM ic_tran_pnd

107:
108:
109: CURSOR c_get_trans_id IS
110: SELECT trans_id, line_id
111: FROM ic_tran_pnd
112: WHERE line_id = p_mo_line_rec.txn_source_line_id
113: AND line_detail_id IN (
114: SELECT delivery_detail_id
115: FROM wsh_delivery_details

Line 132: l_tran_row IC_TRAN_PND%ROWTYPE;

128: l_del_trans_qty NUMBER;
129: l_del_trans_qty2 NUMBER;
130: l_trans_id NUMBER;
131: l_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
132: l_tran_row IC_TRAN_PND%ROWTYPE;
133: l_p_allow_delete VARCHAR2(3);
134:
135: l_IC$DEFAULT_LOCT VARCHAR2(255)DEFAULT NVL(FND_PROFILE.VALUE('IC$DEFAULT_LOCT'),' ') ;
136: l_GML$DEL_ALC_BEFORE_AUTO VARCHAR2(255) DEFAULT NVL(FND_PROFILE.VALUE('GML$DEL_ALC_BEFORE_AUTO'),' ') ;

Line 297: /* find out the corresponding delivery detail id to fill in ic_tran_pnd */

293: FND_MSG_PUB.Add;
294: RAISE FND_API.G_EXC_ERROR;
295: END IF;
296:
297: /* find out the corresponding delivery detail id to fill in ic_tran_pnd */
298: /* this could result more than 1 delivery, need to do a loop for the deliveries */
299:
300: GMI_Reservation_Util.PrintLn('p_mo_line_rec.unit_number is ' || p_mo_line_Rec.unit_number);
301: /* Retrieve reservation information for that demand source */