APPS.WMS_RULE_17 dependencies on WMS_RULE_PVT

Line 5: p_cursor IN OUT NOCOPY WMS_RULE_PVT.cv_pick_type,

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

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

Line 301: ,WMS_Rule_PVT.GetConversionRate(

297: ,sub.reservable_type
298: ,nvl(loc.reservable_type,1) locreservable -- Bug 6719290
299: ,nvl(lot.reservable_type,1) lotreservable -- Bug 6719290
300: ,nvl(loc.pick_uom_code, sub.pick_uom_code) uom_code
301: ,WMS_Rule_PVT.GetConversionRate(
302: nvl(loc.pick_uom_code, sub.pick_uom_code)
303: ,msn.current_organization_id
304: ,msn.inventory_item_id) conversion_rate
305: ,msn.lpn_id lpn_id

Line 408: ,WMS_Rule_PVT.GetConversionRate(

404: ,x.reservable_type reservable_type
405: ,x.locreservable locreservable
406: ,x.lotreservable lotreservable
407: ,NVL(loc.pick_uom_code,sub.pick_uom_code) uom_code
408: ,WMS_Rule_PVT.GetConversionRate(
409: NVL(loc.pick_uom_code, sub.pick_uom_code)
410: ,x.organization_id
411: ,x.inventory_item_id) conversion_rate
412: ,NULL locator_inventory_item_id

Line 525: p_cursor IN WMS_RULE_PVT.cv_pick_type,

521:
522: END open_curs;
523:
524: PROCEDURE fetch_one_row(
525: p_cursor IN WMS_RULE_PVT.cv_pick_type,
526: x_revision OUT NOCOPY VARCHAR2,
527: x_lot_number OUT NOCOPY VARCHAR2,
528: x_lot_expiration_date OUT NOCOPY DATE,
529: x_subinventory_code OUT NOCOPY VARCHAR2,

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

569:
570:
571: END fetch_one_row;
572:
573: PROCEDURE close_curs( p_cursor IN WMS_RULE_PVT.cv_pick_type) IS
574: BEGIN
575: if (p_cursor%ISOPEN) THEN
576: CLOSE p_cursor;
577: END IF;

Line 582: p_cursor IN WMS_RULE_PVT.cv_pick_type,

578: END close_curs;
579:
580: -- LG convergence new procedure for the new manual picking select screen
581: PROCEDURE fetch_available_rows(
582: p_cursor IN WMS_RULE_PVT.cv_pick_type,
583: x_return_status OUT NOCOPY NUMBER) IS
584:
585:
586: BEGIN