PACKAGE: APPS.INV_CACHE

Source

1 PACKAGE inv_cache AS
2 /* $Header: INVCACHS.pls 120.3 2007/12/25 02:15:00 musinha ship $ */
3 
4 org_rec		mtl_parameters%ROWTYPE;
5 tosub_rec	mtl_secondary_inventories%ROWTYPE;
6 fromsub_rec	mtl_secondary_inventories%ROWTYPE;
7 item_rec	mtl_system_items%ROWTYPE;
8 mmtt_rec	mtl_material_transactions_temp%ROWTYPE;
9 mol_rec		mtl_txn_request_lines%ROWTYPE;
10 mtrh_rec	mtl_txn_request_headers%ROWTYPE;
11 wdd_rec		wsh_delivery_details%ROWTYPE;
12 mtt_rec		mtl_transaction_types%ROWTYPE;
13 mso_rec		mtl_sales_orders%ROWTYPE;
14 
15 --Bug 4171297
16 oola_rec        oe_order_lines_all%ROWTYPE;
17 
18 -- Bug# 4258360: Added the following for R12 Crossdock Pegging Project
19 wpb_rec         wsh_picking_batches%ROWTYPE;
20 
21 -- Onhand Material Status Support
22 loc_rec         mtl_item_locations%ROWTYPE;
23 moqd_rec        mtl_onhand_quantities_detail%ROWTYPE;
24 -- Onhand Material Status Support
25 
26 
27 -- Bug# 4951639: Added to set move order transaction date during pick release
28 mo_transaction_date  DATE;
29 
30 wms_installed	BOOLEAN;
31 is_pickrelease	BOOLEAN;
32 oe_header_id	NUMBER;
33 tolocator_id	NUMBER;
34 tosubinventory_code	VARCHAR2(10);
35 
36 FUNCTION set_org_rec
37   (
38    p_organization_id IN NUMBER
39    ) RETURN BOOLEAN;
40 
41 FUNCTION set_org_rec
42   (
43    p_organization_code IN VARCHAR2
44    ) RETURN BOOLEAN;
45 
46 FUNCTION set_item_rec
47   (
48    p_organization_id IN NUMBER,
49    p_item_id IN NUMBER
50    ) RETURN BOOLEAN;
51 
52 FUNCTION set_tosub_rec
53   (
54    p_organization_id IN NUMBER,
55    p_subinventory_code IN VARCHAR2
56    ) RETURN BOOLEAN;
57 
58 FUNCTION set_fromsub_rec
59   (
60    p_organization_id IN NUMBER,
61    p_subinventory_code IN VARCHAR2
62    ) RETURN BOOLEAN;
63 
64 FUNCTION set_mmtt_rec
65   (
66    p_transaction_temp_id IN NUMBER
67    ) RETURN BOOLEAN;
68 
69 FUNCTION set_mol_rec
70   (
71    p_line_id IN NUMBER
72    ) RETURN BOOLEAN;
73 
74 FUNCTION set_mtrh_rec
75   (
76    p_header_id IN NUMBER
77    ) RETURN BOOLEAN;
78 
79 FUNCTION set_wdd_rec
80   (
81    p_move_order_line_id IN NUMBER
82    ) RETURN BOOLEAN;
83 
84 FUNCTION set_mso_rec
85   (
86    p_oe_header_id IN NUMBER
87    ) RETURN BOOLEAN;
88 
89 FUNCTION set_oeh_id
90   (
91    p_salesorder_id IN NUMBER
92    ) RETURN BOOLEAN;
93 
94 FUNCTION set_mtt_rec
95   (
96    p_transaction_type_id IN NUMBER
97    ) RETURN BOOLEAN;
98 
99 FUNCTION set_wms_installed
100   (
101    p_organization_id IN NUMBER
102    ) RETURN BOOLEAN;
103 
104 FUNCTION set_pick_release
105   (
106    p_value IN BOOLEAN
107    ) RETURN BOOLEAN;
108 
109 FUNCTION set_to_locator
110   (
111    p_locator_id IN NUMBER
112    ) RETURN BOOLEAN;
113 
114 FUNCTION set_to_subinventory
115   (
116    p_subinventory_code IN NUMBER
117    ) RETURN BOOLEAN;
118 
119 --4171297
120 FUNCTION set_oola_rec
121   (
122    p_order_line_id IN NUMBER
123    ) RETURN BOOLEAN;
124 
125 -- Bug# 4258360: Added for R12 Crossdock Pegging Project
126 FUNCTION set_wpb_rec
127   (
128    p_batch_id       IN NUMBER,
129    p_request_number IN VARCHAR2
130    ) RETURN BOOLEAN;
131 
132 -- Onhand Material Status Support
133 FUNCTION set_loc_rec
134   (
135    p_organization_id IN NUMBER,
136    p_locator_id IN VARCHAR2
137   ) RETURN BOOLEAN;
138 
139 -- Onhand Material Status Support
140 FUNCTION set_moqd_status_rec
141   (
142    p_organization_id IN NUMBER,
143    p_inventory_item_id IN NUMBER,
144    p_sub_code IN VARCHAR2,
145    p_loc_id IN NUMBER,
146    p_lot_number IN VARCHAR2,
147    p_lpn_id IN NUMBER
148   ) RETURN BOOLEAN;
149 
150 END inv_cache;