APPS.WMS_RULE_18 dependencies on WMS_RULE_PVT

Line 5: p_cursor IN OUT NOCOPY WMS_RULE_PVT.cv_pick_type,

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

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

Line 191: ,WMS_Rule_PVT.GetConversionRate(

187: ,sub.reservable_type
188: ,nvl(loc.reservable_type,1) locreservable -- Bug 6719290
189: ,nvl(lot.reservable_type,1) lotreservable -- Bug 6719290
190: ,nvl(loc.pick_uom_code, sub.pick_uom_code) uom_code
191: ,WMS_Rule_PVT.GetConversionRate(
192: nvl(loc.pick_uom_code, sub.pick_uom_code)
193: ,msn.current_organization_id
194: ,msn.inventory_item_id) conversion_rate
195: ,msn.lpn_id lpn_id

Line 296: ,WMS_Rule_PVT.GetConversionRate(

292: ,sub.reservable_type
293: ,nvl(loc.reservable_type,1) locreservable -- Bug 6719290
294: ,nvl(lot.reservable_type,1) lotreservable -- Bug 6719290
295: ,nvl(loc.pick_uom_code, sub.pick_uom_code) uom_code
296: ,WMS_Rule_PVT.GetConversionRate(
297: nvl(loc.pick_uom_code, sub.pick_uom_code)
298: ,msn.current_organization_id
299: ,msn.inventory_item_id) conversion_rate
300: ,msn.lpn_id lpn_id

Line 401: ,WMS_Rule_PVT.GetConversionRate(

397: ,x.reservable_type reservable_type
398: ,x.locreservable locreservable
399: ,x.lotreservable lotreservable
400: ,NVL(loc.pick_uom_code,sub.pick_uom_code) uom_code
401: ,WMS_Rule_PVT.GetConversionRate(
402: NVL(loc.pick_uom_code, sub.pick_uom_code)
403: ,x.organization_id
404: ,x.inventory_item_id) conversion_rate
405: ,NULL locator_inventory_item_id

Line 517: p_cursor IN WMS_RULE_PVT.cv_pick_type,

513:
514: END open_curs;
515:
516: PROCEDURE fetch_one_row(
517: p_cursor IN WMS_RULE_PVT.cv_pick_type,
518: x_revision OUT NOCOPY VARCHAR2,
519: x_lot_number OUT NOCOPY VARCHAR2,
520: x_lot_expiration_date OUT NOCOPY DATE,
521: x_subinventory_code OUT NOCOPY VARCHAR2,

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

561:
562:
563: END fetch_one_row;
564:
565: PROCEDURE close_curs( p_cursor IN WMS_RULE_PVT.cv_pick_type) IS
566: BEGIN
567: if (p_cursor%ISOPEN) THEN
568: CLOSE p_cursor;
569: END IF;

Line 574: p_cursor IN WMS_RULE_PVT.cv_pick_type,

570: END close_curs;
571:
572: -- LG convergence new procedure for the new manual picking select screen
573: PROCEDURE fetch_available_rows(
574: p_cursor IN WMS_RULE_PVT.cv_pick_type,
575: x_return_status OUT NOCOPY NUMBER) IS
576:
577:
578: BEGIN