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_AUTO_ALLOC_BATCH_PKG dependencies on IC_ITEM_MST

Line 125: From ic_item_mst ic,

121:
122: Cursor get_inventory_item_id_cur(p_item_id IN VARCHAR2)
123: IS
124: Select inventory_item_id
125: From ic_item_mst ic,
126: mtl_system_items mtl
127: where ic.item_id = p_item_id
128: AND mtl.segment1 = ic.item_no;
129:

Line 574: l_ic_item_mst_rec GMI_Reservation_Util.ic_item_mst_rec;

570: l_tran_row IC_TRAN_PND%ROWTYPE;
571:
572:
573: l_allocation_rec GMI_Auto_Allocate_PUB.gmi_allocation_rec;
574: l_ic_item_mst_rec GMI_Reservation_Util.ic_item_mst_rec;
575: --l_ic_item_mst_rec ic_item_mst%ROWTYPE;
576: l_ic_item_mst ic_item_mst%ROWTYPE;
577: l_old_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
578: l_op_alot_prm_rec op_alot_prm%rowtype;

Line 575: --l_ic_item_mst_rec ic_item_mst%ROWTYPE;

571:
572:
573: l_allocation_rec GMI_Auto_Allocate_PUB.gmi_allocation_rec;
574: l_ic_item_mst_rec GMI_Reservation_Util.ic_item_mst_rec;
575: --l_ic_item_mst_rec ic_item_mst%ROWTYPE;
576: l_ic_item_mst ic_item_mst%ROWTYPE;
577: l_old_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
578: l_op_alot_prm_rec op_alot_prm%rowtype;
579:

Line 576: l_ic_item_mst ic_item_mst%ROWTYPE;

572:
573: l_allocation_rec GMI_Auto_Allocate_PUB.gmi_allocation_rec;
574: l_ic_item_mst_rec GMI_Reservation_Util.ic_item_mst_rec;
575: --l_ic_item_mst_rec ic_item_mst%ROWTYPE;
576: l_ic_item_mst ic_item_mst%ROWTYPE;
577: l_old_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
578: l_op_alot_prm_rec op_alot_prm%rowtype;
579:
580: l_ic_whse_mst_rec ic_whse_mst%rowtype;

Line 595: From ic_item_mst

591: where whse_code=p_whse_code;
592:
593: Cursor get_item_cur(p_item_id IN NUMBER) IS
594: Select *
595: From ic_item_mst
596: where item_id=p_item_id;
597:
598:
599: Cursor get_whse_code_cur(p_organization_id IN NUMBER)

Line 682: , item_no IC_ITEM_MST.ITEM_NO%TYPE

678: ( doc_id IC_TRAN_PND.DOC_ID%TYPE
679: , line_id IC_TRAN_PND.LINE_ID%TYPE
680: , doc_line IC_TRAN_PND.DOC_LINE%TYPE
681: , line_detail_id IC_TRAN_PND.LINE_DETAIL_ID%TYPE
682: , item_no IC_ITEM_MST.ITEM_NO%TYPE
683: , whse_code IC_WHSE_MST.WHSE_CODE%TYPE
684: , co_code OP_CUST_MST.CO_CODE%TYPE
685: , cust_no OP_CUST_MST.CUST_NO%TYPE
686: , prefqc_grade OP_ORDR_DTL.QC_GRADE_WANTED%TYPE

Line 764: , x_ic_item_mst_rec => l_ic_item_mst_rec

760:
761: Get_Allocation_Record (
762: p_wdd_line => p_wdd_rec
763: , x_allocation_rec => l_allocation_rec
764: , x_ic_item_mst_rec => l_ic_item_mst_rec
765: , x_return_status => x_return_status
766: , x_msg_count => x_msg_count
767: , x_msg_data => x_msg_data
768: );

Line 792: IF (l_ic_item_mst_rec.lot_ctl = 0 and l_ic_item_mst_rec.loct_ctl * l_ic_whse_mst_rec.loct_ctl = 0) THEN

788:
789: CLOSE Get_Whse_Cur;
790:
791:
792: IF (l_ic_item_mst_rec.lot_ctl = 0 and l_ic_item_mst_rec.loct_ctl * l_ic_whse_mst_rec.loct_ctl = 0) THEN
793: GMI_RESERVATION_UTIL.println('NON CONTROL . Auto allocation can not be performed');
794: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
795: END IF;
796:

Line 797: IF (nvl(l_ic_item_mst_rec.alloc_class, '%#S$%') = '%#S$%' ) THEN

793: GMI_RESERVATION_UTIL.println('NON CONTROL . Auto allocation can not be performed');
794: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
795: END IF;
796:
797: IF (nvl(l_ic_item_mst_rec.alloc_class, '%#S$%') = '%#S$%' ) THEN
798: GMI_RESERVATION_UTIL.println('Alloc Class is missing from item set up.');
799: GMI_RESERVATION_UTIL.println('Auto allocation can not be performed');
800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
801: END IF;

Line 826: , p_item_id => l_ic_item_mst_rec.item_id

822: GMI_RESERVATION_UTIL.println('Create default trans ');
823: GMI_RESERVATION_UTIL.create_dflt_lot_from_scratch
824: ( p_whse_code => l_whse_code
825: , p_line_id => p_wdd_rec.source_line_id
826: , p_item_id => l_ic_item_mst_rec.item_id
827: , p_qty1 => p_wdd_rec.requested_quantity
828: , p_qty2 => p_wdd_rec.requested_quantity2
829: , x_return_status => x_return_status
830: , x_msg_count => x_msg_count

Line 842: ( p_alloc_class => l_ic_item_mst_rec.alloc_class,

838:
839: GMI_RESERVATION_UTIL.println('Before Call To get allocation Parms');
840:
841: GMI_ALLOCATION_RULES_PVT.GET_ALLOCATION_PARMS
842: ( p_alloc_class => l_ic_item_mst_rec.alloc_class,
843: p_org_id => l_allocation_rec.org_id,
844: p_of_cust_id => l_allocation_rec.of_cust_id,
845: p_ship_to_org_id=> l_allocation_rec.ship_to_org_id,
846: x_return_status => l_return_status,

Line 862: OPEN get_item_cur(l_ic_item_mst_rec.item_id);

858: END IF;
859:
860: --l_commit := FND_API.G_FALSE;
861:
862: OPEN get_item_cur(l_ic_item_mst_rec.item_id);
863: FETCH get_item_cur INTO l_ic_item_mst;
864:
865: IF (get_item_cur%NOTFOUND)
866: THEN

Line 863: FETCH get_item_cur INTO l_ic_item_mst;

859:
860: --l_commit := FND_API.G_FALSE;
861:
862: OPEN get_item_cur(l_ic_item_mst_rec.item_id);
863: FETCH get_item_cur INTO l_ic_item_mst;
864:
865: IF (get_item_cur%NOTFOUND)
866: THEN
867: GMI_RESERVATION_UTIL.println('Get_Item_Cur%NOTFOUND');

Line 878: , p_ic_item_mst => l_ic_item_mst

874:
875:
876: GMI_ALLOCATE_INVENTORY_PVT.ALLOCATE_LINE
877: ( p_allocation_rec => l_allocation_rec
878: , p_ic_item_mst => l_ic_item_mst
879: , p_ic_whse_mst => l_ic_whse_mst_rec
880: , p_op_alot_prm => l_op_alot_prm_rec
881: , p_batch_id => p_batch_rec.batch_id
882: , x_allocated_qty1 => x_detailed_qty

Line 935: p_item_id => l_ic_item_mst_rec.item_id,

931:
932: OPEN cur_txn_no_default
933: ( p_line_id => p_wdd_rec.source_line_id,
934: p_location => FND_PROFILE.Value('IC$DEFAULT_LOCT'),
935: p_item_id => l_ic_item_mst_rec.item_id,
936: p_mo_line_id => p_wdd_rec.move_order_line_id
937: );
938:
939: FETCH cur_txn_no_default INTO l_total_qty, l_total_qty2;

Line 1279: , x_ic_item_mst_rec OUT NOCOPY GMI_Reservation_Util.ic_item_mst_rec

1275:
1276: PROCEDURE get_allocation_record
1277: ( p_wdd_line IN wsh_delivery_details%rowtype
1278: , x_allocation_rec OUT NOCOPY GMI_Auto_Allocate_PUB.gmi_allocation_rec
1279: , x_ic_item_mst_rec OUT NOCOPY GMI_Reservation_Util.ic_item_mst_rec
1280: , x_return_status OUT NOCOPY VARCHAR2
1281: , x_msg_count OUT NOCOPY NUMBER
1282: , x_msg_data OUT NOCOPY VARCHAR2
1283: ) IS

Line 1469: , x_ic_item_mst_rec => x_ic_item_mst_rec

1465:
1466: GMI_RESERVATION_UTIL.Get_OPM_item_from_Apps(
1467: p_organization_id => p_wdd_line.organization_id
1468: , p_inventory_item_id => p_wdd_line.inventory_item_id
1469: , x_ic_item_mst_rec => x_ic_item_mst_rec
1470: , x_return_status => x_return_status
1471: , x_msg_count => x_msg_count
1472: , x_msg_data => x_msg_data);
1473:

Line 1475: GMI_reservation_Util.PrintLn(' in Util v: item_no='||x_ic_item_mst_rec.item_no);

1471: , x_msg_count => x_msg_count
1472: , x_msg_data => x_msg_data);
1473:
1474:
1475: GMI_reservation_Util.PrintLn(' in Util v: item_no='||x_ic_item_mst_rec.item_no);
1476:
1477: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
1478: THEN
1479: GMI_RESERVATION_UTIL.PrintLn('Status get opm item from apps '|| x_return_status);

Line 1488: x_allocation_rec.item_no := x_ic_item_mst_rec.item_no;

1484: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_wdd_line.inventory_item_id);
1485: FND_MSG_PUB.Add;
1486: RAISE FND_API.G_EXC_ERROR;
1487: ELSE
1488: x_allocation_rec.item_no := x_ic_item_mst_rec.item_no;
1489: END IF;
1490:
1491: /*
1492: IN A NEXT VERSION : CUST_ID is going to be returned

Line 1495: IF (x_ic_item_mst_rec.dualum_ind > 0) THEN

1491: /*
1492: IN A NEXT VERSION : CUST_ID is going to be returned
1493: */
1494:
1495: IF (x_ic_item_mst_rec.dualum_ind > 0) THEN
1496: x_allocation_rec.order_qty2 := p_wdd_line.requested_quantity2 - nvl(l_del_qty2,0);
1497: x_allocation_rec.order_um2 := x_ic_item_mst_rec.item_um2;
1498:
1499: IF x_allocation_rec.order_qty1 <= 0 THEN

Line 1497: x_allocation_rec.order_um2 := x_ic_item_mst_rec.item_um2;

1493: */
1494:
1495: IF (x_ic_item_mst_rec.dualum_ind > 0) THEN
1496: x_allocation_rec.order_qty2 := p_wdd_line.requested_quantity2 - nvl(l_del_qty2,0);
1497: x_allocation_rec.order_um2 := x_ic_item_mst_rec.item_um2;
1498:
1499: IF x_allocation_rec.order_qty1 <= 0 THEN
1500: x_allocation_rec.order_qty2 := 0;
1501: END IF;