APPS.GMI_AUTO_ALLOC_BATCH_PKG dependencies on IC_WHSE_MST

Line 113: from ic_whse_mst

109:
110: Cursor get_whse_code_cur(p_organization_id IN NUMBER)
111: IS
112: Select whse_code
113: from ic_whse_mst
114: where mtl_organization_id= p_organization_id;
115:
116: Cursor get_ship_to_org_cur(p_whse_code IN VARCHAR2)
117: IS

Line 119: From ic_whse_mst

115:
116: Cursor get_ship_to_org_cur(p_whse_code IN VARCHAR2)
117: IS
118: Select mtl_organization_id
119: From ic_whse_mst
120: Where whse_code= p_whse_code;
121:
122: Cursor get_inventory_item_id_cur(p_item_id IN VARCHAR2)
123: IS

Line 580: l_ic_whse_mst_rec ic_whse_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;
581: l_total_qty NUMBER;
582: l_total_qty2 NUMBER;
583:
584: l_IC$DEFAULT_LOCT VARCHAR2(255)DEFAULT NVL(FND_PROFILE.VALUE('IC$DEFAULT_LOCT'),' ') ;

Line 590: From ic_whse_mst

586:
587:
588: Cursor get_whse_cur(p_whse_code IN VARCHAR2) IS
589: Select *
590: From ic_whse_mst
591: where whse_code=p_whse_code;
592:
593: Cursor get_item_cur(p_item_id IN NUMBER) IS
594: Select *

Line 602: from ic_whse_mst

598:
599: Cursor get_whse_code_cur(p_organization_id IN NUMBER)
600: IS
601: Select whse_code
602: from ic_whse_mst
603: where mtl_organization_id= p_organization_id;
604:
605: CURSOR cur_txn_no_default ( p_line_id IN NUMBER,
606: p_location IN VARCHAR2,

Line 683: , whse_code IC_WHSE_MST.WHSE_CODE%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
687: , order_qty1 OP_ORDR_DTL.ORDER_QTY1%TYPE

Line 781: FETCH Get_Whse_Cur Into l_ic_whse_mst_rec;

777: GMI_RESERVATION_UTIL.println('Will attempt to allocate '|| l_allocation_rec.order_qty1);
778:
779:
780: OPEN Get_Whse_Cur(l_whse_code);
781: FETCH Get_Whse_Cur Into l_ic_whse_mst_rec;
782: IF(Get_Whse_Cur%NOTFOUND)
783: THEN
784: GMI_RESERVATION_UTIL.println('Get_Whse_Cur%Notfound');
785: CLOSE Get_Whse_Cur;

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 879: , p_ic_whse_mst => l_ic_whse_mst_rec

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
883: , x_allocated_qty2 => x_detailed_qty2

Line 1318: from ic_whse_mst

1314:
1315: Cursor get_whse_code(p_organization_id IN NUMBER)
1316: IS
1317: Select whse_code
1318: from ic_whse_mst
1319: where mtl_organization_id= p_organization_id;
1320: Cursor get_allocated_qty (p_line_id IN NUMBER
1321: , p_line_detail_id IN NUMBER)
1322: IS

Line 1338: ic_whse_mst w,

1334: SELECT w.whse_code,
1335: s.co_code,
1336: s.orgn_code
1337: FROM mtl_parameters p,
1338: ic_whse_mst w,
1339: sy_orgn_mst s
1340: WHERE
1341: w.mtl_organization_id = p.organization_id
1342: AND p.ORGANIZATION_ID = p_organization_id