DBA Data[Home] [Help]

APPS.INV_QUANTITY_TREE_PUB dependencies on INV_QUANTITY_TREE_PVT

Line 17: g_reservation_mode CONSTANT INTEGER := inv_quantity_tree_pvt.g_reservation_mode;

13: --
14: -- Tree mode constants
15: -- Users can call create_tree() in two mode, reservation mode and
16: -- transaction mode
17: g_reservation_mode CONSTANT INTEGER := inv_quantity_tree_pvt.g_reservation_mode;
18: g_transaction_mode CONSTANT INTEGER := inv_quantity_tree_pvt.g_transaction_mode;
19: g_loose_only_mode CONSTANT INTEGER := inv_quantity_tree_pvt.g_loose_only_mode;
20: g_no_lpn_rsvs_mode CONSTANT INTEGER :=
21: inv_quantity_tree_pvt.g_no_lpn_rsvs_mode;

Line 18: g_transaction_mode CONSTANT INTEGER := inv_quantity_tree_pvt.g_transaction_mode;

14: -- Tree mode constants
15: -- Users can call create_tree() in two mode, reservation mode and
16: -- transaction mode
17: g_reservation_mode CONSTANT INTEGER := inv_quantity_tree_pvt.g_reservation_mode;
18: g_transaction_mode CONSTANT INTEGER := inv_quantity_tree_pvt.g_transaction_mode;
19: g_loose_only_mode CONSTANT INTEGER := inv_quantity_tree_pvt.g_loose_only_mode;
20: g_no_lpn_rsvs_mode CONSTANT INTEGER :=
21: inv_quantity_tree_pvt.g_no_lpn_rsvs_mode;
22: --

Line 19: g_loose_only_mode CONSTANT INTEGER := inv_quantity_tree_pvt.g_loose_only_mode;

15: -- Users can call create_tree() in two mode, reservation mode and
16: -- transaction mode
17: g_reservation_mode CONSTANT INTEGER := inv_quantity_tree_pvt.g_reservation_mode;
18: g_transaction_mode CONSTANT INTEGER := inv_quantity_tree_pvt.g_transaction_mode;
19: g_loose_only_mode CONSTANT INTEGER := inv_quantity_tree_pvt.g_loose_only_mode;
20: g_no_lpn_rsvs_mode CONSTANT INTEGER :=
21: inv_quantity_tree_pvt.g_no_lpn_rsvs_mode;
22: --
23: --

Line 21: inv_quantity_tree_pvt.g_no_lpn_rsvs_mode;

17: g_reservation_mode CONSTANT INTEGER := inv_quantity_tree_pvt.g_reservation_mode;
18: g_transaction_mode CONSTANT INTEGER := inv_quantity_tree_pvt.g_transaction_mode;
19: g_loose_only_mode CONSTANT INTEGER := inv_quantity_tree_pvt.g_loose_only_mode;
20: g_no_lpn_rsvs_mode CONSTANT INTEGER :=
21: inv_quantity_tree_pvt.g_no_lpn_rsvs_mode;
22: --
23: --
24: -- Quantity type constants
25: -- User can call update_quantities to change quantities at a given level.

Line 30: g_qoh CONSTANT INTEGER := inv_quantity_tree_pvt.g_qoh;

26: -- Quantity type constans should be used to specify which quantity the user
27: -- intents to change: quantity onhand, or quantity reserved for the (same) demand
28: -- source that was used to create the tree, and in the future, quantity suggested
29: -- when quantity suggestion is implemented.
30: g_qoh CONSTANT INTEGER := inv_quantity_tree_pvt.g_qoh;
31: -- quantity reserved by same demand source
32: g_qr_same_demand CONSTANT INTEGER := inv_quantity_tree_pvt.g_qr_same_demand;
33: -- quantity for suggested reservation
34: g_qs_rsv CONSTANT INTEGER := inv_quantity_tree_pvt.g_qs_rsv;

Line 32: g_qr_same_demand CONSTANT INTEGER := inv_quantity_tree_pvt.g_qr_same_demand;

28: -- source that was used to create the tree, and in the future, quantity suggested
29: -- when quantity suggestion is implemented.
30: g_qoh CONSTANT INTEGER := inv_quantity_tree_pvt.g_qoh;
31: -- quantity reserved by same demand source
32: g_qr_same_demand CONSTANT INTEGER := inv_quantity_tree_pvt.g_qr_same_demand;
33: -- quantity for suggested reservation
34: g_qs_rsv CONSTANT INTEGER := inv_quantity_tree_pvt.g_qs_rsv;
35: -- quantity for suggested transaction
36: g_qs_txn CONSTANT INTEGER := inv_quantity_tree_pvt.g_qs_txn;

Line 34: g_qs_rsv CONSTANT INTEGER := inv_quantity_tree_pvt.g_qs_rsv;

30: g_qoh CONSTANT INTEGER := inv_quantity_tree_pvt.g_qoh;
31: -- quantity reserved by same demand source
32: g_qr_same_demand CONSTANT INTEGER := inv_quantity_tree_pvt.g_qr_same_demand;
33: -- quantity for suggested reservation
34: g_qs_rsv CONSTANT INTEGER := inv_quantity_tree_pvt.g_qs_rsv;
35: -- quantity for suggested transaction
36: g_qs_txn CONSTANT INTEGER := inv_quantity_tree_pvt.g_qs_txn;
37:
38: -- Procedure

Line 36: g_qs_txn CONSTANT INTEGER := inv_quantity_tree_pvt.g_qs_txn;

32: g_qr_same_demand CONSTANT INTEGER := inv_quantity_tree_pvt.g_qr_same_demand;
33: -- quantity for suggested reservation
34: g_qs_rsv CONSTANT INTEGER := inv_quantity_tree_pvt.g_qs_rsv;
35: -- quantity for suggested transaction
36: g_qs_txn CONSTANT INTEGER := inv_quantity_tree_pvt.g_qs_txn;
37:
38: -- Procedure
39: -- clear_quantity_cache
40: -- Description

Line 72: , p_onhand_source IN NUMBER DEFAULT inv_quantity_tree_pvt.g_all_subs

68: , p_revision IN VARCHAR2
69: , p_lot_number IN VARCHAR2
70: , p_subinventory_code IN VARCHAR2
71: , p_locator_id IN NUMBER
72: , p_onhand_source IN NUMBER DEFAULT inv_quantity_tree_pvt.g_all_subs
73: , x_qoh OUT NOCOPY NUMBER
74: , x_rqoh OUT NOCOPY NUMBER
75: , x_qr OUT NOCOPY NUMBER
76: , x_qs OUT NOCOPY NUMBER

Line 108: , p_onhand_source IN NUMBER DEFAULT inv_quantity_tree_pvt.g_all_subs

104: , p_revision IN VARCHAR2
105: , p_lot_number IN VARCHAR2
106: , p_subinventory_code IN VARCHAR2
107: , p_locator_id IN NUMBER
108: , p_onhand_source IN NUMBER DEFAULT inv_quantity_tree_pvt.g_all_subs
109: , x_qoh OUT NOCOPY NUMBER
110: , x_rqoh OUT NOCOPY NUMBER
111: , x_qr OUT NOCOPY NUMBER
112: , x_qs OUT NOCOPY NUMBER

Line 156: , p_onhand_source IN NUMBER DEFAULT inv_quantity_tree_pvt.g_all_subs

152: , p_subinventory_code IN VARCHAR2 DEFAULT NULL
153: , p_locator_id IN NUMBER DEFAULT NULL
154: , p_primary_quantity IN NUMBER
155: , p_quantity_type IN INTEGER
156: , p_onhand_source IN NUMBER DEFAULT inv_quantity_tree_pvt.g_all_subs
157: , x_qoh OUT NOCOPY NUMBER
158: , x_rqoh OUT NOCOPY NUMBER
159: , x_qr OUT NOCOPY NUMBER
160: , x_qs OUT NOCOPY NUMBER

Line 165: , p_containerized IN NUMBER DEFAULT inv_quantity_tree_pvt.g_containerized_false

161: , x_att OUT NOCOPY NUMBER
162: , x_atr OUT NOCOPY NUMBER
163: , p_transfer_subinventory_code IN VARCHAR2 DEFAULT NULL
164: , p_cost_group_id IN NUMBER DEFAULT NULL
165: , p_containerized IN NUMBER DEFAULT inv_quantity_tree_pvt.g_containerized_false
166: , p_lpn_id IN NUMBER DEFAULT NULL
167: , p_transfer_locator_id IN NUMBER DEFAULT NULL
168: ) ;
169:

Line 196: , p_onhand_source IN NUMBER DEFAULT inv_quantity_tree_pvt.g_all_subs

192: , p_grade_code IN VARCHAR2 DEFAULT NULL -- invConv change
193: , p_primary_quantity IN NUMBER
194: , p_quantity_type IN INTEGER
195: , p_secondary_quantity IN NUMBER -- invConv change
196: , p_onhand_source IN NUMBER DEFAULT inv_quantity_tree_pvt.g_all_subs
197: , x_qoh OUT NOCOPY NUMBER
198: , x_rqoh OUT NOCOPY NUMBER
199: , x_qr OUT NOCOPY NUMBER
200: , x_qs OUT NOCOPY NUMBER

Line 211: , p_containerized IN NUMBER DEFAULT inv_quantity_tree_pvt.g_containerized_false

207: , x_satt OUT NOCOPY NUMBER -- invConv change
208: , x_satr OUT NOCOPY NUMBER -- invConv change
209: , p_transfer_subinventory_code IN VARCHAR2 DEFAULT NULL
210: , p_cost_group_id IN NUMBER DEFAULT NULL
211: , p_containerized IN NUMBER DEFAULT inv_quantity_tree_pvt.g_containerized_false
212: , p_lpn_id IN NUMBER DEFAULT NULL
213: , p_transfer_locator_id IN NUMBER DEFAULT NULL
214: ) ;
215: -- invConv changes end.