APPS.WMS_RULE_6 dependencies on WMS_RULE_PVT

Line 5: p_cursor IN OUT NOCOPY WMS_RULE_PVT.cv_pick_type,

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

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

Line 403: ,WMS_Rule_PVT.GetConversionRate(

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

Line 520: p_cursor IN WMS_RULE_PVT.cv_pick_type,

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

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

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

Line 577: p_cursor IN WMS_RULE_PVT.cv_pick_type,

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