APPS.WMS_RULE_3 dependencies on WMS_RULE_PVT

Line 5: p_cursor IN OUT NOCOPY WMS_RULE_PVT.cv_pick_type,

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

105: ,sub.reservable_type
106: ,nvl(loc.reservable_type,1) locreservable -- Bug 6719290
107: ,nvl(lot.reservable_type,1) lotreservable -- Bug 6719290
108: ,nvl(loc.pick_uom_code, sub.pick_uom_code) uom_code
109: ,WMS_Rule_PVT.GetConversionRate(
110: nvl(loc.pick_uom_code, sub.pick_uom_code)
111: ,msn.current_organization_id
112: ,msn.inventory_item_id) conversion_rate
113: ,msn.lpn_id lpn_id

Line 216: ,WMS_Rule_PVT.GetConversionRate(

212: ,sub.reservable_type
213: ,nvl(loc.reservable_type,1) locreservable -- Bug 6719290
214: ,nvl(lot.reservable_type,1) lotreservable -- Bug 6719290
215: ,nvl(loc.pick_uom_code, sub.pick_uom_code) uom_code
216: ,WMS_Rule_PVT.GetConversionRate(
217: nvl(loc.pick_uom_code, sub.pick_uom_code)
218: ,msn.current_organization_id
219: ,msn.inventory_item_id) conversion_rate
220: ,msn.lpn_id lpn_id

Line 352: ,WMS_Rule_PVT.GetConversionRate(

348: ,sub.reservable_type
349: ,nvl(loc.reservable_type,1) locreservable -- Bug 6719290
350: ,nvl(lot.reservable_type,1) lotreservable -- Bug 6719290
351: ,nvl(loc.pick_uom_code, sub.pick_uom_code) uom_code
352: ,WMS_Rule_PVT.GetConversionRate(
353: nvl(loc.pick_uom_code, sub.pick_uom_code)
354: ,msn.current_organization_id
355: ,msn.inventory_item_id) conversion_rate
356: ,msn.lpn_id lpn_id

Line 488: ,WMS_Rule_PVT.GetConversionRate(

484: ,x.reservable_type reservable_type
485: ,x.locreservable locreservable
486: ,x.lotreservable lotreservable
487: ,NVL(loc.pick_uom_code,sub.pick_uom_code) uom_code
488: ,WMS_Rule_PVT.GetConversionRate(
489: NVL(loc.pick_uom_code, sub.pick_uom_code)
490: ,x.organization_id
491: ,x.inventory_item_id) conversion_rate
492: ,NULL locator_inventory_item_id

Line 628: p_cursor IN WMS_RULE_PVT.cv_pick_type,

624:
625: END open_curs;
626:
627: PROCEDURE fetch_one_row(
628: p_cursor IN WMS_RULE_PVT.cv_pick_type,
629: x_revision OUT NOCOPY VARCHAR2,
630: x_lot_number OUT NOCOPY VARCHAR2,
631: x_lot_expiration_date OUT NOCOPY DATE,
632: x_subinventory_code OUT NOCOPY VARCHAR2,

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

672:
673:
674: END fetch_one_row;
675:
676: PROCEDURE close_curs( p_cursor IN WMS_RULE_PVT.cv_pick_type) IS
677: BEGIN
678: if (p_cursor%ISOPEN) THEN
679: CLOSE p_cursor;
680: END IF;

Line 685: p_cursor IN WMS_RULE_PVT.cv_pick_type,

681: END close_curs;
682:
683: -- LG convergence new procedure for the new manual picking select screen
684: PROCEDURE fetch_available_rows(
685: p_cursor IN WMS_RULE_PVT.cv_pick_type,
686: x_return_status OUT NOCOPY NUMBER) IS
687:
688:
689: BEGIN