APPS.WMS_RULE_16 dependencies on WMS_RULE_PVT

Line 5: p_cursor IN OUT NOCOPY WMS_RULE_PVT.cv_pick_type,

1: PACKAGE BODY WMS_RULE_16 AS
2:
3: PROCEDURE open_curs
4: (
5: p_cursor IN OUT NOCOPY WMS_RULE_PVT.cv_pick_type,
6: p_organization_id IN NUMBER,
7: p_inventory_item_id IN NUMBER,
8: p_transaction_type_id IN NUMBER,
9: p_revision IN VARCHAR2,

Line 104: ,WMS_Rule_PVT.GetConversionRate(

100: ,sub.reservable_type
101: ,nvl(loc.reservable_type,1) locreservable -- Bug 6719290
102: ,nvl(lot.reservable_type,1) lotreservable -- Bug 6719290
103: ,nvl(loc.pick_uom_code, sub.pick_uom_code) uom_code
104: ,WMS_Rule_PVT.GetConversionRate(
105: nvl(loc.pick_uom_code, sub.pick_uom_code)
106: ,msn.current_organization_id
107: ,msn.inventory_item_id) conversion_rate
108: ,msn.lpn_id lpn_id

Line 197: ,WMS_Rule_PVT.GetConversionRate(

193: ,sub.reservable_type
194: ,nvl(loc.reservable_type,1) locreservable -- Bug 6719290
195: ,nvl(lot.reservable_type,1) lotreservable -- Bug 6719290
196: ,nvl(loc.pick_uom_code, sub.pick_uom_code) uom_code
197: ,WMS_Rule_PVT.GetConversionRate(
198: nvl(loc.pick_uom_code, sub.pick_uom_code)
199: ,msn.current_organization_id
200: ,msn.inventory_item_id) conversion_rate
201: ,msn.lpn_id lpn_id

Line 306: ,WMS_Rule_PVT.GetConversionRate(

302: ,sub.reservable_type
303: ,nvl(loc.reservable_type,1) locreservable -- Bug 6719290
304: ,nvl(lot.reservable_type,1) lotreservable -- Bug 6719290
305: ,nvl(loc.pick_uom_code, sub.pick_uom_code) uom_code
306: ,WMS_Rule_PVT.GetConversionRate(
307: nvl(loc.pick_uom_code, sub.pick_uom_code)
308: ,msn.current_organization_id
309: ,msn.inventory_item_id) conversion_rate
310: ,msn.lpn_id lpn_id

Line 415: ,WMS_Rule_PVT.GetConversionRate(

411: ,x.reservable_type reservable_type
412: ,x.locreservable locreservable
413: ,x.lotreservable lotreservable
414: ,NVL(loc.pick_uom_code,sub.pick_uom_code) uom_code
415: ,WMS_Rule_PVT.GetConversionRate(
416: NVL(loc.pick_uom_code, sub.pick_uom_code)
417: ,x.organization_id
418: ,x.inventory_item_id) conversion_rate
419: ,NULL locator_inventory_item_id

Line 533: p_cursor IN WMS_RULE_PVT.cv_pick_type,

529:
530: END open_curs;
531:
532: PROCEDURE fetch_one_row(
533: p_cursor IN WMS_RULE_PVT.cv_pick_type,
534: x_revision OUT NOCOPY VARCHAR2,
535: x_lot_number OUT NOCOPY VARCHAR2,
536: x_lot_expiration_date OUT NOCOPY DATE,
537: x_subinventory_code OUT NOCOPY VARCHAR2,

Line 581: PROCEDURE close_curs( p_cursor IN WMS_RULE_PVT.cv_pick_type) IS

577:
578:
579: END fetch_one_row;
580:
581: PROCEDURE close_curs( p_cursor IN WMS_RULE_PVT.cv_pick_type) IS
582: BEGIN
583: if (p_cursor%ISOPEN) THEN
584: CLOSE p_cursor;
585: END IF;

Line 590: p_cursor IN WMS_RULE_PVT.cv_pick_type,

586: END close_curs;
587:
588: -- LG convergence new procedure for the new manual picking select screen
589: PROCEDURE fetch_available_rows(
590: p_cursor IN WMS_RULE_PVT.cv_pick_type,
591: x_return_status OUT NOCOPY NUMBER) IS
592:
593:
594: BEGIN