DBA Data[Home] [Help]

APPS.GMI_ALLOCATE_INVENTORY_PVT dependencies on IC_WHSE_MST

Line 25: | p_ic_whse_mst IN ic_whse_mst%ROWTYPE |

21: | PARAMETERS |
22: | p_line_id IN NUMBER |
23: | p_trans_date IN DATE |
24: | p_ic_item_mst IN ic_item_mst%ROWTYPE |
25: | p_ic_whse_mst IN ic_whse_mst%ROWTYPE |
26: | p_op_alot_prm IN op_alot_prm%ROWTYPE |
27: | x_allocated_qty1 OUT NUMBER |
28: | x_allocated_qty2 OUT NUMBER |
29: | x_return_status OUT VARCHAR2 |

Line 42: , p_ic_whse_mst IN ic_whse_mst%ROWTYPE

38: */
39: PROCEDURE ALLOCATE_LINE
40: ( p_allocation_rec IN GMI_AUTO_ALLOCATE_PUB.gmi_allocation_rec
41: , p_ic_item_mst IN ic_item_mst%ROWTYPE
42: , p_ic_whse_mst IN ic_whse_mst%ROWTYPE
43: , p_op_alot_prm IN op_alot_prm%ROWTYPE
44: , p_batch_id IN NUMBER
45: , x_allocated_qty1 OUT NOCOPY NUMBER
46: , x_allocated_qty2 OUT NOCOPY NUMBER

Line 93: l_whse_code IC_WHSE_MST.WHSE_CODE%TYPE;

89: l_from_creation_date IC_TRAN_PND.TRANS_DATE%TYPE;
90: l_to_creation_date IC_TRAN_PND.TRANS_DATE%TYPE;
91: */
92: l_override_rules NUMBER DEFAULT 0;
93: l_whse_code IC_WHSE_MST.WHSE_CODE%TYPE;
94: l_IC$DEFAULT_LOCT IC_LOCT_MST.LOCATION%TYPE;
95: l_where_clause VARCHAR2(3000):= NULL;
96: l_order_by VARCHAR2(1000):= NULL;
97: l_tran_rec GMI_TRANS_ENGINE_PUB.ictran_rec;

Line 240: l_whse_code := p_ic_whse_mst.whse_code;

236: l_shelf_date := p_allocation_rec.trans_date + p_op_alot_prm.shelf_days;
237: END IF;
238: ll_shelf_date := TO_CHAR(l_shelf_date,'DD-MON-YYYY, HH:MI:SS');
239:
240: l_whse_code := p_ic_whse_mst.whse_code;
241:
242: l_where_clause :=
243: 'item_id = '|| p_ic_item_mst.item_id ;
244: l_where_clause := l_where_clause ||' AND whse_code = ';

Line 272: l_loct_ctl := p_ic_item_mst.loct_ctl * p_ic_whse_mst.loct_ctl;

268: END IF;
269:
270: /*Overall location control is determined by looking at both the item and whse
271: =============================================================================*/
272: l_loct_ctl := p_ic_item_mst.loct_ctl * p_ic_whse_mst.loct_ctl;
273: GMI_RESERVATION_UTIL.PrintLn('loct ctl set to ' || l_loct_ctl || ' from ' || p_ic_item_mst.loct_ctl
274: || ' and ' || p_ic_whse_mst.loct_ctl );
275:
276: IF l_loct_ctl = 0 THEN

Line 274: || ' and ' || p_ic_whse_mst.loct_ctl );

270: /*Overall location control is determined by looking at both the item and whse
271: =============================================================================*/
272: l_loct_ctl := p_ic_item_mst.loct_ctl * p_ic_whse_mst.loct_ctl;
273: GMI_RESERVATION_UTIL.PrintLn('loct ctl set to ' || l_loct_ctl || ' from ' || p_ic_item_mst.loct_ctl
274: || ' and ' || p_ic_whse_mst.loct_ctl );
275:
276: IF l_loct_ctl = 0 THEN
277: l_where_clause := l_where_clause || ' AND location = ';
278: l_where_clause := l_where_clause || '''' ;

Line 353: GMI_RESERVATION_UTIL.PrintLn('WHSE IS '|| p_ic_whse_mst.whse_code);

349: END IF;
350: */
351:
352: GMI_RESERVATION_UTIL.PrintLn('(Auto_Alloc) 1 WHERE clause is now '|| l_where_clause);
353: GMI_RESERVATION_UTIL.PrintLn('WHSE IS '|| p_ic_whse_mst.whse_code);
354: GMI_RESERVATION_UTIL.PrintLn('item_no item_id: ' ||p_ic_item_mst.item_no ||' '|| p_ic_item_mst.item_id);
355: GMI_RESERVATION_UTIL.PrintLn('QC Grade to be used is '|| p_allocation_rec.prefqc_grade);
356:
357: GMI_RESERVATION_UTIL.PrintLn('Using a shelf date of '|| l_shelf_date );

Line 628: find_cust_spec_rec.whse_code := p_ic_whse_mst.whse_code;

624:
625: find_cust_spec_rec.item_id := p_ic_item_mst.item_id;
626: --find_cust_spec_rec.grade := l_allocation_rec.prefqc_grade;
627: find_cust_spec_rec.orgn_code := NULL;
628: find_cust_spec_rec.whse_code := p_ic_whse_mst.whse_code;
629: find_cust_spec_rec.cust_id := l_sold_to_org_id;
630: find_cust_spec_rec.date_effective := l_schedule_ship_date;
631: find_cust_spec_rec.org_id := l_org_id;
632: find_cust_spec_rec.ship_to_site_id := l_ship_to_org_id;

Line 685: result_lot_match_tbl(1).whse_code := p_ic_whse_mst.whse_code;

681: IF ( l_spec_hdr_id >0) THEN
682: /* Commented since these dont exist in 12.0 ; P1 SCM Build bug #4561095
683: result_lot_match_tbl(1).item_id := p_ic_item_mst.item_id;
684: result_lot_match_tbl(1).lot_id := l_lot_id;
685: result_lot_match_tbl(1).whse_code := p_ic_whse_mst.whse_code;
686: result_lot_match_tbl(1).location := l_location;
687: */
688:
689: GMI_Reservation_Util.PrintLn('(Alloc PVT) calling GMD_SPEC_MATCH_GRP.get_spec_match');

Line 712: || p_ic_whse_mst.whse_code || '/' || l_lot_no || '/' ||

708:
709: /*Interpret the rules on spliting the lot
710: ========================================*/
711: GMI_RESERVATION_UTIL.PrintLn('examining whse/lot_no/id/location/grade '
712: || p_ic_whse_mst.whse_code || '/' || l_lot_no || '/' ||
713: l_lot_id || '/' || l_location || '/' || l_qc_grade );
714:
715: gmi_reservation_util.println('examining whse/lot_no/id/location/grade '
716: || p_ic_whse_mst.whse_code || '/' || l_lot_no || '/' ||

Line 716: || p_ic_whse_mst.whse_code || '/' || l_lot_no || '/' ||

712: || p_ic_whse_mst.whse_code || '/' || l_lot_no || '/' ||
713: l_lot_id || '/' || l_location || '/' || l_qc_grade );
714:
715: gmi_reservation_util.println('examining whse/lot_no/id/location/grade '
716: || p_ic_whse_mst.whse_code || '/' || l_lot_no || '/' ||
717: l_lot_id || '/' || l_location || '/' || l_qc_grade );
718:
719: GMI_RESERVATION_UTIL.PrintLn('onhand is ' || l_loct_onhand);
720: GMI_RESERVATION_UTIL.PrintLn('committed is ' || l_commit_qty );

Line 814: l_tran_rec.orgn_code := p_ic_whse_mst.orgn_code;

810: l_tran_rec.trans_id := NULL;
811: l_tran_rec.item_id := p_ic_item_mst.item_id;
812: l_tran_rec.line_id := p_allocation_rec.line_id;
813: l_tran_rec.co_code := p_allocation_rec.co_code;
814: l_tran_rec.orgn_code := p_ic_whse_mst.orgn_code;
815: l_tran_rec.whse_code := p_ic_whse_mst.whse_code;
816: l_tran_rec.lot_id := l_lot_id;
817: l_tran_rec.location := l_location;
818: l_tran_rec.doc_id := p_allocation_rec.doc_id;

Line 815: l_tran_rec.whse_code := p_ic_whse_mst.whse_code;

811: l_tran_rec.item_id := p_ic_item_mst.item_id;
812: l_tran_rec.line_id := p_allocation_rec.line_id;
813: l_tran_rec.co_code := p_allocation_rec.co_code;
814: l_tran_rec.orgn_code := p_ic_whse_mst.orgn_code;
815: l_tran_rec.whse_code := p_ic_whse_mst.whse_code;
816: l_tran_rec.lot_id := l_lot_id;
817: l_tran_rec.location := l_location;
818: l_tran_rec.doc_id := p_allocation_rec.doc_id;
819: l_tran_rec.doc_type := 'OMSO';

Line 954: p_ic_whse_mst => p_ic_whse_mst,

950: (p_default_qty1 => l_unallocated_qty1 * -1,
951: p_default_qty2 => l_unallocated_qty2 * -1,
952: p_allocation_rec => p_allocation_rec,
953: p_ic_item_mst => p_ic_item_mst,
954: p_ic_whse_mst => p_ic_whse_mst,
955: x_return_status => l_return_status,
956: x_msg_count => l_msg_count,
957: x_msg_data => l_msg_data
958: );

Line 1016: , p_ic_whse_mst IN ic_whse_mst%ROWTYPE

1012: ( p_default_qty1 IN NUMBER
1013: , p_default_qty2 IN NUMBER
1014: , p_allocation_rec IN GMI_AUTO_ALLOCATE_PUB.gmi_allocation_rec
1015: , p_ic_item_mst IN ic_item_mst%ROWTYPE
1016: , p_ic_whse_mst IN ic_whse_mst%ROWTYPE
1017: , x_return_status OUT NOCOPY VARCHAR2
1018: , x_msg_count OUT NOCOPY NUMBER
1019: , x_msg_data OUT NOCOPY VARCHAR2
1020: )

Line 1067: l_tran_rec.orgn_code := p_ic_whse_mst.orgn_code;

1063: l_tran_rec.trans_id := NULL;
1064: l_tran_rec.item_id := p_ic_item_mst.item_id;
1065: l_tran_rec.line_id := p_allocation_rec.line_id;
1066: l_tran_rec.co_code := p_allocation_rec.co_code;
1067: l_tran_rec.orgn_code := p_ic_whse_mst.orgn_code;
1068: l_tran_rec.whse_code := p_ic_whse_mst.whse_code;
1069: l_tran_rec.lot_id := 0;
1070: l_tran_rec.location := IC$DEFAULT_LOCT;
1071: l_tran_rec.doc_id := p_allocation_rec.doc_id;

Line 1068: l_tran_rec.whse_code := p_ic_whse_mst.whse_code;

1064: l_tran_rec.item_id := p_ic_item_mst.item_id;
1065: l_tran_rec.line_id := p_allocation_rec.line_id;
1066: l_tran_rec.co_code := p_allocation_rec.co_code;
1067: l_tran_rec.orgn_code := p_ic_whse_mst.orgn_code;
1068: l_tran_rec.whse_code := p_ic_whse_mst.whse_code;
1069: l_tran_rec.lot_id := 0;
1070: l_tran_rec.location := IC$DEFAULT_LOCT;
1071: l_tran_rec.doc_id := p_allocation_rec.doc_id;
1072: l_tran_rec.doc_type := 'OMSO';

Line 1238: , p_whse_loct_ctl IN ic_whse_mst.loct_ctl%TYPE

1234: ( p_doc_id IN ic_tran_pnd.doc_id%TYPE
1235: , p_line_id IN ic_tran_pnd.line_id%TYPE
1236: , p_lot_ctl IN ic_item_mst.lot_ctl%TYPE
1237: , p_item_loct_ctl IN ic_item_mst.loct_ctl%TYPE
1238: , p_whse_loct_ctl IN ic_whse_mst.loct_ctl%TYPE
1239: )
1240: RETURN BOOLEAN
1241: IS
1242: l_api_name CONSTANT VARCHAR2 (30) := 'CHECK_EXISTING_ALLOCATIONS';