APPS.GMI_PICK_RELEASE_UTIL dependencies on IC_TRAN_PND

Line 162: FROM ic_tran_pnd

158: /* Cursors : */
159: CURSOR c_mold_crs (mo_source_line_id IN NUMBER)
160: IS
161: SELECT trans_id, whse_code
162: FROM ic_tran_pnd
163: WHERE line_id = mo_source_line_id
164: AND pick_slip_number IS NULL
165: AND (lot_id <> 0 or location <> ic$default_loct); -- added this condition for bug3069040
166:

Line 268: /* Assign the pick slip number to the record in IC_TRAN_PND */

264: END IF;
265:
266:
267:
268: /* Assign the pick slip number to the record in IC_TRAN_PND */
269: GMI_Reservation_Util.PrintLn('In Create_Pick_Slip_and_Print update ic_tran_pnd with pick_slip_number='||l_pick_slip_number);
270: UPDATE ic_tran_pnd
271: SET pick_slip_number = l_pick_slip_number
272: WHERE trans_id = l_trans_id;

Line 269: GMI_Reservation_Util.PrintLn('In Create_Pick_Slip_and_Print update ic_tran_pnd with pick_slip_number='||l_pick_slip_number);

265:
266:
267:
268: /* Assign the pick slip number to the record in IC_TRAN_PND */
269: GMI_Reservation_Util.PrintLn('In Create_Pick_Slip_and_Print update ic_tran_pnd with pick_slip_number='||l_pick_slip_number);
270: UPDATE ic_tran_pnd
271: SET pick_slip_number = l_pick_slip_number
272: WHERE trans_id = l_trans_id;
273:

Line 270: UPDATE ic_tran_pnd

266:
267:
268: /* Assign the pick slip number to the record in IC_TRAN_PND */
269: GMI_Reservation_Util.PrintLn('In Create_Pick_Slip_and_Print update ic_tran_pnd with pick_slip_number='||l_pick_slip_number);
270: UPDATE ic_tran_pnd
271: SET pick_slip_number = l_pick_slip_number
272: WHERE trans_id = l_trans_id;
273:
274: /* If the pick slip is ready to be printed (and partial picking is allowed) commit */

Line 380: FROM ic_tran_pnd

376: ) IS
377:
378: CURSOR pnd_txn_pickslip_CUR (mo_source_line_id IN NUMBER) IS
379: SELECT pick_slip_number
380: FROM ic_tran_pnd
381: WHERE line_id = mo_source_line_id
382: AND pick_slip_number is NOT NULL
383: AND (location <> GMI_Reservation_Util.G_DEFAULT_LOCT OR lot_id <> 0)
384: AND delete_mark = 0

Line 391: FROM ic_tran_pnd

387:
388: --Bug3294071
389: CURSOR pnd_txn_pickslip_noctl_CUR (mo_source_line_id IN NUMBER) IS
390: SELECT pick_slip_number
391: FROM ic_tran_pnd
392: WHERE line_id = mo_source_line_id
393: AND pick_slip_number is NOT NULL
394: AND delete_mark = 0
395: AND completed_ind = 0

Line 412: FROM ic_tran_pnd

408:
409:
410: CURSOR pnd_txn_CUR (mo_source_line_id IN NUMBER) IS
411: SELECT whse_code,item_id
412: FROM ic_tran_pnd
413: WHERE line_id = mo_source_line_id;
414:
415: CURSOR mo_header_CUR (p_header_id NUMBER) IS
416: SELECT grouping_rule_id

Line 628: From ic_tran_pnd

624: l_api_name CONSTANT VARCHAR2(30) := 'Update txn with Pick Slip ';
625:
626: CURSOR allocations_trans_id IS
627: Select trans_id
628: From ic_tran_pnd
629: Where line_id = p_mo_line_rec.txn_source_line_id
630: and doc_type = 'OMSO'
631: and delete_mark = 0
632: and completed_ind = 0

Line 638: FROM ic_tran_pnd

634:
635:
636: CURSOR pnd_txn_CUR (mo_source_line_id IN NUMBER) IS
637: SELECT whse_code, item_id
638: FROM ic_tran_pnd
639: WHERE line_id = mo_source_line_id;
640:
641:
642: CURSOR get_item_ctl (p_item_id IN NUMBER) IS

Line 670: UPDATE ic_tran_pnd

666:
667: IF (l_noninv_ind = 0) THEN
668: IF (l_lot_ctl <> 0 OR (l_item_loct_ctl * l_whse_loct_ctl <> 0) ) THEN
669: FOR transaction_ids IN allocations_trans_id LOOP
670: UPDATE ic_tran_pnd
671: SET pick_slip_number = p_pick_slip_number
672: WHERE trans_id = transaction_ids.trans_id;
673: END LOOP;
674: ELSE

Line 677: FROM ic_tran_pnd

673: END LOOP;
674: ELSE
675: SELECT trans_id
676: INTO l_trans_id
677: FROM ic_tran_pnd
678: WHERE line_id = p_mo_line_rec.txn_source_line_id
679: AND doc_type = 'OMSO'
680: AND delete_mark = 0
681: AND completed_ind = 0

Line 685: UPDATE ic_tran_pnd

681: AND completed_ind = 0
682: AND staged_ind = 0
683: AND (lot_id = 0 and location = ic$default_loct);
684:
685: UPDATE ic_tran_pnd
686: SET pick_slip_number = p_pick_slip_number
687: WHERE trans_id = l_trans_id;
688: END IF;
689: END IF;