APPS.WMS_RULE_4 dependencies on WMS_RULE_PVT

Line 5: p_cursor IN OUT NOCOPY WMS_RULE_PVT.cv_pick_type,

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

99: ,sub.reservable_type
100: ,nvl(loc.reservable_type,1) locreservable -- Bug 6719290
101: ,nvl(lot.reservable_type,1) lotreservable -- Bug 6719290
102: ,nvl(loc.pick_uom_code, sub.pick_uom_code) uom_code
103: ,WMS_Rule_PVT.GetConversionRate(
104: nvl(loc.pick_uom_code, sub.pick_uom_code)
105: ,msn.current_organization_id
106: ,msn.inventory_item_id) conversion_rate
107: ,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 308: ,WMS_Rule_PVT.GetConversionRate(

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

Line 419: ,WMS_Rule_PVT.GetConversionRate(

415: ,x.reservable_type reservable_type
416: ,x.locreservable locreservable
417: ,x.lotreservable lotreservable
418: ,NVL(loc.pick_uom_code,sub.pick_uom_code) uom_code
419: ,WMS_Rule_PVT.GetConversionRate(
420: NVL(loc.pick_uom_code, sub.pick_uom_code)
421: ,x.organization_id
422: ,x.inventory_item_id) conversion_rate
423: ,NULL locator_inventory_item_id

Line 540: p_cursor IN WMS_RULE_PVT.cv_pick_type,

536:
537: END open_curs;
538:
539: PROCEDURE fetch_one_row(
540: p_cursor IN WMS_RULE_PVT.cv_pick_type,
541: x_revision OUT NOCOPY VARCHAR2,
542: x_lot_number OUT NOCOPY VARCHAR2,
543: x_lot_expiration_date OUT NOCOPY DATE,
544: x_subinventory_code OUT NOCOPY VARCHAR2,

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

584:
585:
586: END fetch_one_row;
587:
588: PROCEDURE close_curs( p_cursor IN WMS_RULE_PVT.cv_pick_type) IS
589: BEGIN
590: if (p_cursor%ISOPEN) THEN
591: CLOSE p_cursor;
592: END IF;

Line 597: p_cursor IN WMS_RULE_PVT.cv_pick_type,

593: END close_curs;
594:
595: -- LG convergence new procedure for the new manual picking select screen
596: PROCEDURE fetch_available_rows(
597: p_cursor IN WMS_RULE_PVT.cv_pick_type,
598: x_return_status OUT NOCOPY NUMBER) IS
599:
600:
601: BEGIN