1: PACKAGE BODY WMS_RULE_14 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,
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
180: ,sub.reservable_type
181: ,nvl(loc.reservable_type,1) locreservable -- Bug 6719290
182: ,nvl(lot.reservable_type,1) lotreservable -- Bug 6719290
183: ,nvl(loc.pick_uom_code, sub.pick_uom_code) uom_code
184: ,WMS_Rule_PVT.GetConversionRate(
185: nvl(loc.pick_uom_code, sub.pick_uom_code)
186: ,msn.current_organization_id
187: ,msn.inventory_item_id) conversion_rate
188: ,msn.lpn_id lpn_id
279: ,sub.reservable_type
280: ,nvl(loc.reservable_type,1) locreservable -- Bug 6719290
281: ,nvl(lot.reservable_type,1) lotreservable -- Bug 6719290
282: ,nvl(loc.pick_uom_code, sub.pick_uom_code) uom_code
283: ,WMS_Rule_PVT.GetConversionRate(
284: nvl(loc.pick_uom_code, sub.pick_uom_code)
285: ,msn.current_organization_id
286: ,msn.inventory_item_id) conversion_rate
287: ,msn.lpn_id lpn_id
378: ,x.reservable_type reservable_type
379: ,x.locreservable locreservable
380: ,x.lotreservable lotreservable
381: ,NVL(loc.pick_uom_code,sub.pick_uom_code) uom_code
382: ,WMS_Rule_PVT.GetConversionRate(
383: NVL(loc.pick_uom_code, sub.pick_uom_code)
384: ,x.organization_id
385: ,x.inventory_item_id) conversion_rate
386: ,NULL locator_inventory_item_id
489:
490: END open_curs;
491:
492: PROCEDURE fetch_one_row(
493: p_cursor IN WMS_RULE_PVT.cv_pick_type,
494: x_revision OUT NOCOPY VARCHAR2,
495: x_lot_number OUT NOCOPY VARCHAR2,
496: x_lot_expiration_date OUT NOCOPY DATE,
497: x_subinventory_code OUT NOCOPY VARCHAR2,
537:
538:
539: END fetch_one_row;
540:
541: PROCEDURE close_curs( p_cursor IN WMS_RULE_PVT.cv_pick_type) IS
542: BEGIN
543: if (p_cursor%ISOPEN) THEN
544: CLOSE p_cursor;
545: END IF;
546: END close_curs;
547:
548: -- LG convergence new procedure for the new manual picking select screen
549: PROCEDURE fetch_available_rows(
550: p_cursor IN WMS_RULE_PVT.cv_pick_type,
551: x_return_status OUT NOCOPY NUMBER) IS
552:
553:
554: BEGIN