APPS.GMI_OM_ALLOC_API_PUB dependencies on IC_TRAN_PND

Line 48: | COMMENT : Creates,updates or deletes an opm reservation in ic_tran_pnd

44: | p_tran_rec Input transaction record
45: |
46: | VERSION : current version 1.0
47: | initial version 1.0
48: | COMMENT : Creates,updates or deletes an opm reservation in ic_tran_pnd
49: | table table with information specified in p_tran_rec.
50: |
51: | Notes :
52: | -- The passed qties are positive

Line 206: FROM IC_TRAN_PND a

202:
203: CURSOR get_commited_qty_cur IS
204: SELECT NVL(ABS(SUM(trans_qty)),0)
205: , NVL(ABS(SUM(trans_qty2)),0)
206: FROM IC_TRAN_PND a
207: WHERE a.lot_id = l_ic_lots_mst_rec.lot_id
208: AND a.item_id = l_ic_item_mst_rec.item_id
209: AND a.location = NVL(l_tran_rec.location ,l_default_location)
210: AND a.whse_code = l_ic_whse_mst_rec.whse_code

Line 220: FROM IC_TRAN_PND

216: -- BEGIN - BUG 2789268 Pushkar Upakare - Added p_line_id to following cursor.
217: CURSOR get_alloc_qty_for_ddl_cur(p_line_id IN NUMBER, p_line_detail_id IN NUMBER) IS
218: SELECT NVL(ABS(SUM(trans_qty)),0)
219: ,NVL(ABS(SUM(trans_qty2)),0)
220: FROM IC_TRAN_PND
221: WHERE line_id = p_line_id
222: AND line_detail_id = p_line_detail_id
223: AND doc_type = 'OMSO'
224: AND delete_mark = 0;

Line 230: FROM IC_TRAN_PND

226:
227: CURSOR get_alloc_qty_for_line_cur(p_line_id IN NUMBER) IS
228: SELECT NVL(ABS(SUM(trans_qty)),0)
229: ,NVL(ABS(SUM(trans_qty2)),0)
230: FROM IC_TRAN_PND
231: WHERE line_id = p_line_id
232: AND doc_type = 'OMSO'
233: AND delete_mark = 0;
234:

Line 237: FROM ic_tran_pnd

233: AND delete_mark = 0;
234:
235: CURSOR validate_trans_id_cur(p_trans_id IN NUMBER) IS
236: SELECT delete_mark,completed_ind,staged_ind
237: FROM ic_tran_pnd
238: WHERE trans_id = p_trans_id;
239:
240: CURSOR requested_qty_cur(p_line_detail_id IN NUMBER) IS
241: SELECT requested_quantity,requested_quantity2