APPS.WMS_RULE_2 dependencies on WMS_RULE_PVT

Line 5: p_cursor IN OUT NOCOPY WMS_RULE_PVT.cv_pick_type,

1: PACKAGE BODY WMS_RULE_2 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 101: ,WMS_Rule_PVT.GetConversionRate(

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

Line 185: ,WMS_Rule_PVT.GetConversionRate(

181: ,sub.reservable_type
182: ,nvl(loc.reservable_type,1) locreservable -- Bug 6719290
183: ,nvl(lot.reservable_type,1) lotreservable -- Bug 6719290
184: ,nvl(loc.pick_uom_code, sub.pick_uom_code) uom_code
185: ,WMS_Rule_PVT.GetConversionRate(
186: nvl(loc.pick_uom_code, sub.pick_uom_code)
187: ,msn.current_organization_id
188: ,msn.inventory_item_id) conversion_rate
189: ,msn.lpn_id lpn_id

Line 286: ,WMS_Rule_PVT.GetConversionRate(

282: ,sub.reservable_type
283: ,nvl(loc.reservable_type,1) locreservable -- Bug 6719290
284: ,nvl(lot.reservable_type,1) lotreservable -- Bug 6719290
285: ,nvl(loc.pick_uom_code, sub.pick_uom_code) uom_code
286: ,WMS_Rule_PVT.GetConversionRate(
287: nvl(loc.pick_uom_code, sub.pick_uom_code)
288: ,msn.current_organization_id
289: ,msn.inventory_item_id) conversion_rate
290: ,msn.lpn_id lpn_id

Line 387: ,WMS_Rule_PVT.GetConversionRate(

383: ,x.reservable_type reservable_type
384: ,x.locreservable locreservable
385: ,x.lotreservable lotreservable
386: ,NVL(loc.pick_uom_code,sub.pick_uom_code) uom_code
387: ,WMS_Rule_PVT.GetConversionRate(
388: NVL(loc.pick_uom_code, sub.pick_uom_code)
389: ,x.organization_id
390: ,x.inventory_item_id) conversion_rate
391: ,NULL locator_inventory_item_id

Line 500: p_cursor IN WMS_RULE_PVT.cv_pick_type,

496:
497: END open_curs;
498:
499: PROCEDURE fetch_one_row(
500: p_cursor IN WMS_RULE_PVT.cv_pick_type,
501: x_revision OUT NOCOPY VARCHAR2,
502: x_lot_number OUT NOCOPY VARCHAR2,
503: x_lot_expiration_date OUT NOCOPY DATE,
504: x_subinventory_code OUT NOCOPY VARCHAR2,

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

544:
545:
546: END fetch_one_row;
547:
548: PROCEDURE close_curs( p_cursor IN WMS_RULE_PVT.cv_pick_type) IS
549: BEGIN
550: if (p_cursor%ISOPEN) THEN
551: CLOSE p_cursor;
552: END IF;

Line 557: p_cursor IN WMS_RULE_PVT.cv_pick_type,

553: END close_curs;
554:
555: -- LG convergence new procedure for the new manual picking select screen
556: PROCEDURE fetch_available_rows(
557: p_cursor IN WMS_RULE_PVT.cv_pick_type,
558: x_return_status OUT NOCOPY NUMBER) IS
559:
560:
561: BEGIN