eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMI_PICK_WAVE_CONFIRM_PVT dependencies on IC_ITEM_MST

Line 190: l_ic_item_mst_rec GMI_RESERVATION_UTIL.ic_item_mst_rec;

186: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
187: l_mo_line_rec GMI_MOVE_ORDER_GLOBAL.mo_line_rec;
188: l_mo_line_tbl GMI_MOVE_ORDER_GLOBAL.mo_line_tbl;
189: l_location IC_TRAN_PND.LOCATION%TYPE;
190: l_ic_item_mst_rec GMI_RESERVATION_UTIL.ic_item_mst_rec;
191: l_shipping_attr WSH_INTERFACE.ChangedAttributeTabType;
192: l_trans_qty NUMBER;
193: l_trans_qty2 NUMBER;
194: l_trans_qty_sts NUMBER;

Line 391: From ic_item_mst

387: /* bug 2202841, add status ctl, only the shippable can be transacted */
388: CURSOR get_status_ctl(p_item_id NUMBER)
389: is
390: Select status_ctl
391: From ic_item_mst
392: Where item_id=p_item_id;
393:
394: CURSOR cur_txn_no_dflt_sts( p_line_id NUMBER,
395: p_item_id NUMBER,

Line 600: , x_ic_item_mst_rec => l_ic_item_mst_rec

596: GMI_RESERVATION_UTIL.Get_OPM_item_from_Apps
597: (
598: p_organization_id => l_mo_line_rec.organization_id
599: , p_inventory_item_id => l_mo_line_rec.inventory_item_id
600: , x_ic_item_mst_rec => l_ic_item_mst_rec
601: , x_return_status => x_return_status
602: , x_msg_count => x_msg_count
603: , x_msg_data => x_msg_data);
604:

Line 625: GMI_Reservation_Util.PrintLn('Item : lot_ctl='||l_ic_item_mst_rec.lot_ctl||', loct_ctl='||l_ic_item_mst_rec.loct_ctl);

621: Open get_whse_code;
622: Fetch get_whse_code into l_whse_code, l_whse_ctl;
623: Close get_whse_code;
624:
625: GMI_Reservation_Util.PrintLn('Item : lot_ctl='||l_ic_item_mst_rec.lot_ctl||', loct_ctl='||l_ic_item_mst_rec.loct_ctl);
626: IF ( l_ic_item_mst_rec.lot_ctl <> 0 ) OR ( l_ic_item_mst_rec.loct_ctl * l_whse_ctl<> 0)
627: THEN
628: l_default_transaction :=0; /* Do not Transact default Lot. */
629: /* get status ctl */

Line 626: IF ( l_ic_item_mst_rec.lot_ctl <> 0 ) OR ( l_ic_item_mst_rec.loct_ctl * l_whse_ctl<> 0)

622: Fetch get_whse_code into l_whse_code, l_whse_ctl;
623: Close get_whse_code;
624:
625: GMI_Reservation_Util.PrintLn('Item : lot_ctl='||l_ic_item_mst_rec.lot_ctl||', loct_ctl='||l_ic_item_mst_rec.loct_ctl);
626: IF ( l_ic_item_mst_rec.lot_ctl <> 0 ) OR ( l_ic_item_mst_rec.loct_ctl * l_whse_ctl<> 0)
627: THEN
628: l_default_transaction :=0; /* Do not Transact default Lot. */
629: /* get status ctl */
630: Open get_status_ctl(p_item_id => l_ic_item_mst_rec.item_id);

Line 630: Open get_status_ctl(p_item_id => l_ic_item_mst_rec.item_id);

626: IF ( l_ic_item_mst_rec.lot_ctl <> 0 ) OR ( l_ic_item_mst_rec.loct_ctl * l_whse_ctl<> 0)
627: THEN
628: l_default_transaction :=0; /* Do not Transact default Lot. */
629: /* get status ctl */
630: Open get_status_ctl(p_item_id => l_ic_item_mst_rec.item_id);
631: Fetch get_status_ctl INTO l_status_ctl;
632: Close get_status_ctl;
633: /* Get TXN Quantities */
634: OPEN cur_txn_no_default

Line 637: p_item_id => l_ic_item_mst_rec.item_id

633: /* Get TXN Quantities */
634: OPEN cur_txn_no_default
635: ( p_line_id => l_mo_line_rec.txn_source_line_id,
636: p_location => l_location,
637: p_item_id => l_ic_item_mst_rec.item_id
638: );
639:
640: FETCH cur_txn_no_default INTO l_trans_qty, l_trans_qty2;
641: IF cur_txn_no_default%NOTFOUND THEN

Line 654: p_item_id => l_ic_item_mst_rec.item_id,

650: IF nvl(l_status_ctl, 0) <> 0 THEN -- status ctl
651: GMI_Reservation_Util.PrintLn('status controled');
652: OPEN cur_txn_no_dflt_sts
653: ( p_line_id => l_mo_line_rec.txn_source_line_id,
654: p_item_id => l_ic_item_mst_rec.item_id,
655: p_mo_line_id => l_mo_line_rec.line_id
656: );
657:
658: FETCH cur_txn_no_dflt_sts INTO l_trans_qty, l_trans_qty2; -- this portion would be transacted

Line 672: p_item_id => l_ic_item_mst_rec.item_id

668: l_default_transaction :=1; /* Transact default Lot. */
669: /* Get TXN Quantities */
670: OPEN check_default_lot
671: ( p_line_id => l_mo_line_rec.txn_source_line_id,
672: p_item_id => l_ic_item_mst_rec.item_id
673: );
674: FETCH check_default_lot into l_msg_count;
675: CLOSE check_default_lot;
676: IF l_msg_count = 0 THEN

Line 690: , p_item_id => l_ic_item_mst_rec.item_id

686: GMI_RESERVATION_UTIL.Create_dflt_lot_from_scratch
687: (
688: p_whse_code => l_whse_code
689: , p_line_id => l_mo_line_rec.txn_source_line_id
690: , p_item_id => l_ic_item_mst_rec.item_id
691: , p_qty1 => l_mo_line_rec.quantity
692: , p_qty2 => l_mo_line_rec.secondary_quantity
693: , x_return_status => l_return_status
694: , x_msg_count => x_msg_count

Line 707: p_item_id => l_ic_item_mst_rec.item_id

703: END IF;
704: ELSE
705: OPEN cur_txn_with_default
706: ( p_line_id => l_mo_line_rec.txn_source_line_id,
707: p_item_id => l_ic_item_mst_rec.item_id
708: );
709: FETCH cur_txn_with_default INTO l_trans_qty, l_trans_qty2;
710: CLOSE cur_txn_with_default;
711: END IF;

Line 820: if (l_ic_item_mst_rec.noninv_ind = 1) then

816: ELSE
817: if l_default_transaction = 0 THEN
818: l_action_flag := 'M';
819: else
820: if (l_ic_item_mst_rec.noninv_ind = 1) then
821: l_action_flag := 'U';
822: else
823: if (OM_G_installed is NOT NULL) THEN -- Condition introduced for bug2499153
824: l_action_flag := 'M'; /* Enhancement 2320442 - Changed from U to M */

Line 941: ||', location='||l_location||', item_id='||l_ic_item_mst_rec.item_id);

937: l_shipping_attr(1).action_flag := l_action_flag;
938:
939: IF l_default_transaction = 0 THEN /* lot or loct controled */
940: GMI_Reservation_Util.PrintLn('before getting transaction, line_id='||l_mo_line_rec.txn_source_line_id
941: ||', location='||l_location||', item_id='||l_ic_item_mst_rec.item_id);
942: OPEN mo_line_txn_c ( p_line_id => l_mo_line_rec.txn_source_line_id,
943: p_location => l_location,
944: p_item_id => l_ic_item_mst_rec.item_id,
945: p_delivery_detail_id =>l_delivery_detail_id

Line 944: p_item_id => l_ic_item_mst_rec.item_id,

940: GMI_Reservation_Util.PrintLn('before getting transaction, line_id='||l_mo_line_rec.txn_source_line_id
941: ||', location='||l_location||', item_id='||l_ic_item_mst_rec.item_id);
942: OPEN mo_line_txn_c ( p_line_id => l_mo_line_rec.txn_source_line_id,
943: p_location => l_location,
944: p_item_id => l_ic_item_mst_rec.item_id,
945: p_delivery_detail_id =>l_delivery_detail_id
946: );
947: GMI_Reservation_Util.PrintLn('After Call to mo_line_txn_c');
948:

Line 977: p_item_id => l_ic_item_mst_rec.item_id,

973: l_orderable_ind := 1;
974: l_shipable_ind := 1;
975: IF nvl(l_status_ctl,0) <> 0 THEN
976: Open check_lot_sts(
977: p_item_id => l_ic_item_mst_rec.item_id,
978: p_whse_code => l_whse_code,
979: p_lot_id => l_mo_line_txn_rec.lot_id,
980: p_location => l_mo_line_txn_rec.location
981: );

Line 990: GMI_Reservation_Util.PrintLn(' Lot_ctl '||l_ic_item_mst_rec.lot_ctl);

986: GMI_Reservation_Util.PrintLn('orderable status ind : '||l_orderable_ind);
987: GMI_Reservation_Util.PrintLn('shipable status ind : '||l_shipable_ind);
988:
989: -- Begin Bug 3609713
990: GMI_Reservation_Util.PrintLn(' Lot_ctl '||l_ic_item_mst_rec.lot_ctl);
991: GMI_Reservation_Util.PrintLn(' Allow negative Inventory : '||l_allowneginv);
992:
993: -- Bug 3859774
994: -- If inventory is not allowed to go -ve and the lots are shippable!

Line 998: p_item_id => l_ic_item_mst_rec.item_id,

994: -- If inventory is not allowed to go -ve and the lots are shippable!
995: --
996: IF (l_allowneginv <> 1 AND NVL(l_shipable_ind, 0) <> 0) THEN
997: OPEN check_onhand_qty(
998: p_item_id => l_ic_item_mst_rec.item_id,
999: p_whse_code => l_whse_code,
1000: p_lot_id => l_mo_line_txn_rec.lot_id,
1001: p_location => l_mo_line_txn_rec.location
1002: );

Line 1013: p_item_id => l_ic_item_mst_rec.item_id,

1009: GMI_Reservation_Util.PrintLn('Onhand for lot : '||l_onhand1);
1010: GMI_Reservation_Util.PrintLn('Onhand2 for lot : '||l_onhand2);
1011:
1012: OPEN check_staged(
1013: p_item_id => l_ic_item_mst_rec.item_id,
1014: p_whse_code => l_whse_code,
1015: p_lot_id => l_mo_line_txn_rec.lot_id,
1016: p_location => l_mo_line_txn_rec.location
1017: );

Line 1238: /* IF (l_ic_item_mst_rec.noninv_ind = 1) THEN

1234: -- HAW 3387829 Commented some unnecessary calls and
1235: -- some code is now shared between non-inventory amd
1236: -- non-lot control items
1237:
1238: /* IF (l_ic_item_mst_rec.noninv_ind = 1) THEN
1239: GMI_Reservation_Util.PrintLn('Just Working with noninventory item');
1240: GMI_Reservation_Util.PrintLn('Delivery detail id '||l_shipping_attr(1).delivery_detail_id);
1241: l_return_status := '';
1242: */

Line 1258: p_item_id => l_ic_item_mst_rec.item_id,

1254: GMI_PICK_WAVE_CONFIRM_PVT.BALANCE_NONCTL_INV_TRAN
1255: (
1256: p_mo_line_rec => l_mo_line_rec ,
1257: p_commit => p_commit,
1258: p_item_id => l_ic_item_mst_rec.item_id,
1259: p_whse_code => l_whse_code,
1260: p_requested_qty => l_requested_qty,
1261: p_requested_qty2 => l_requested_qty2,
1262: p_delivery_detail_id => l_delivery_detail_id,

Line 1273: l_ic_item_mst_rec.item_id,l_delivery_detail_id);

1269: );
1270: /* End bug 2901317 */
1271:
1272: OPEN New_txn_nonctl_CUR ( l_mo_line_rec.txn_source_line_id,
1273: l_ic_item_mst_rec.item_id,l_delivery_detail_id);
1274: FETCH New_txn_nonctl_CUR INTO l_trans_id, l_trans_qty, l_trans_qty2;
1275: IF (New_txn_nonctl_CUR%NOTFOUND) THEN
1276: l_trans_qty := 0;
1277: END IF;

Line 1330: IF (l_ic_item_mst_rec.noninv_ind <> 1)THEN

1326: -- HAW 3387829. There is a difference between non-lot and non-inventory
1327: -- Let's keep the original call to find_default_lot for non-lot items
1328:
1329: /* HAW added the if condition to deal with non-lot control items*/
1330: IF (l_ic_item_mst_rec.noninv_ind <> 1)THEN
1331: GMI_Reservation_Util.PrintLn('Working with noncontrolled inventory item - Post G');
1332: GMI_Reservation_Util.PrintLn('Calling GMI_RESERVATION_UTIL.find_default_lot - Post G for l_mo_line_rec.txn_source_line_id'||l_mo_line_rec.txn_source_line_id);
1333: GMI_RESERVATION_UTIL.find_default_lot
1334: ( x_return_status => x_return_status,

Line 1912: l_ic_item_mst_rec GMI_RESERVATION_UTIL.ic_item_mst_rec;

1908: l_apps_uom VARCHAR2(4);
1909: l_opm_uom VARCHAR2(4);
1910: l_apps_uom2 VARCHAR2(4);
1911: l_opm_uom2 VARCHAR2(4);
1912: l_ic_item_mst_rec GMI_RESERVATION_UTIL.ic_item_mst_rec;
1913:
1914:
1915: BEGIN
1916:

Line 2542: from ic_item_mst

2538: -- Removed the cursor since it's not being used in this procedure
2539:
2540: Cursor item_mst_dtl IS
2541: Select noninv_ind
2542: from ic_item_mst
2543: where item_id = p_item_id;
2544:
2545: l_trans_id NUMBER;
2546: l_dflt_nonctl_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;