[Home] [Help]
PACKAGE: APPS.CSE_ASSET_UTIL_PKG
Source
1 PACKAGE cse_asset_util_pkg AS
2 -- $Header: CSEFAUTS.pls 120.5.12010000.1 2008/07/30 05:17:38 appldev ship $
3
4 G_FIFO_SEARCH CONSTANT VARCHAR2(4) := 'FIFO';
5 G_LIFO_SEARCH CONSTANT VARCHAR2(4) := 'LIFO';
6
7 G_SOURCE_MOVE_TYPE CONSTANT VARCHAR2(15) := 'SOURCE' ;
8 G_DESTINATION_MOVE_TYPE CONSTANT VARCHAR2(15) := 'DESTINATION' ;
9 G_NULL_MOVE_TYPE CONSTANT VARCHAR2(15) := NULL ;
10
11 G_RECEIPT_TXN_CLASS CONSTANT VARCHAR2(20) := 'RECEIPT';
12 G_MOVE_TXN_CLASS CONSTANT VARCHAR2(20) := 'MOVE';
13 G_MISC_MOVE_TXN_CLASS CONSTANT VARCHAR2(20) := 'MISC_MOVE';
14 G_MISC_RECPT_TXN_CLASS CONSTANT VARCHAR2(20) := 'MISC RECEIPT';
15 G_IPV_TXN_CLASS CONSTANT VARCHAR2(20) := 'IPV';
16 G_FA_FEEDER_NAME CONSTANT VARCHAR2(40):= 'ORACLE ENTERPRISE INSTALL BASE';
17 G_ADJUST_TXN_CLASS CONSTANT VARCHAR2(20) := 'ADJUSTMENTS' ;
18 G_SPLIT_MERGE_FA_LINK_CLASS CONSTANT VARCHAR2(20):='SPLIT MERGE'; --bnarayan added for R12
19
20 G_MTL_INDICATOR CONSTANT VARCHAR2(1) := 'Y' ;
21 G_NON_MTL_INDICATOR CONSTANT VARCHAR2(1) := 'N' ;
22
23 TYPE inst_loc_rec IS RECORD
24 (
25 instance_id NUMBER ,
26 transaction_id NUMBER ,
27 transaction_date DATE ,
28 location_type_code VARCHAR2(30) ,
29 inv_organization_id NUMBER ,
30 inv_subinventory_name VARCHAR2(10) ,
31 location_id NUMBER
32 );
33
34 TYPE inst_txn_rec IS RECORD
35 (
36 instance_id NUMBER ,
37 transaction_id NUMBER ,
38 transaction_date DATE ,
39 inv_organization_id NUMBER ,
40 inv_subinventory_name VARCHAR2(10)
41 );
42
43 FUNCTION asset_description(
44 p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
45 x_error_msg OUT NOCOPY VARCHAR2,
46 x_return_status OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
47
48 FUNCTION asset_category(
49 p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
50 x_error_msg OUT NOCOPY VARCHAR2,
51 x_return_status OUT NOCOPY VARCHAR2
52 ) RETURN NUMBER;
53
54 FUNCTION book_type(
55 p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
56 x_error_msg OUT NOCOPY VARCHAR2,
57 x_return_status OUT NOCOPY VARCHAR2
58 ) RETURN VARCHAR2;
59
60 FUNCTION date_place_in_service(
61 p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
62 x_error_msg OUT NOCOPY VARCHAR2,
63 x_return_status OUT NOCOPY VARCHAR2
64 ) RETURN DATE;
65
66 FUNCTION asset_key(
67 p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
68 x_error_msg OUT NOCOPY VARCHAR2,
69 x_return_status OUT NOCOPY VARCHAR2
70 ) RETURN NUMBER;
71
72 /*FUNCTION asset_location(
73 p_transaction_id IN NUMBER,
74 p_instance_id IN NUMBER,
75 p_serial_move_type IN VARCHAR2 DEFAULT NULL,
76 x_error_msg OUT NOCOPY VARCHAR2,
77 x_return_status OUT NOCOPY VARCHAR2
78 ) RETURN NUMBER ;*/
79
80 FUNCTION deprn_expense_ccid(
81 p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
82 x_error_msg OUT NOCOPY VARCHAR2,
83 x_return_status OUT NOCOPY VARCHAR2
84 ) RETURN NUMBER;
85
86 FUNCTION search_method(
87 p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
88 x_error_msg OUT NOCOPY VARCHAR2,
89 x_return_status OUT NOCOPY VARCHAR2
90 ) RETURN VARCHAR2;
91
92 FUNCTION payables_ccid(
93 p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
94 x_error_msg OUT NOCOPY VARCHAR2,
95 x_return_status OUT NOCOPY VARCHAR2
96 ) RETURN NUMBER;
97
98 FUNCTION tag_number(
99 p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
100 x_error_msg OUT NOCOPY VARCHAR2,
101 x_return_status OUT NOCOPY VARCHAR2
102 ) RETURN VARCHAR2;
103
104 FUNCTION model_number(
105 p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
106 x_error_msg OUT NOCOPY VARCHAR2,
107 x_return_status OUT NOCOPY VARCHAR2
108 ) RETURN VARCHAR2;
109
110 FUNCTION manufacturer(
111 p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
112 x_error_msg OUT NOCOPY VARCHAR2,
113 x_return_status OUT NOCOPY VARCHAR2
114 ) RETURN VARCHAR2;
115
116 FUNCTION employee(
117 p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
118 x_error_msg OUT NOCOPY VARCHAR2,
119 x_return_status OUT NOCOPY VARCHAR2
120 ) RETURN NUMBER;
121
122 PROCEDURE is_valid_to_process(
123 p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
124 x_valid_to_process OUT NOCOPY VARCHAR2,
125 x_return_status OUT NOCOPY VARCHAR2,
126 x_error_msg OUT NOCOPY VARCHAR2);
127
128
129 FUNCTION retire_non_mtl(
130 p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
131 p_asset_id IN NUMBER,
132 x_error_msg OUT NOCOPY VARCHAR2,
133 x_return_status OUT NOCOPY VARCHAR2
134 ) RETURN VARCHAR2 ;
135 ---08/03
136 ---This function signature is different from others as there is
137 ---no inventory_item_id attribute on csi_i_asset_txn_temp table
138 ---as this was a desgin change.
139 FUNCTION inventory_item(
140 p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec
141 ) RETURN NUMBER;
142
143 PRAGMA RESTRICT_REFERENCES(inventory_item, WNDS);
144
145 PROCEDURE get_pending_retirements (
146 p_asset_query_rec IN OUT NOCOPY cse_datastructures_pub.asset_query_rec,
147 p_distribution_tbl IN OUT NOCOPY cse_datastructures_pub.distribution_tbl,
148 x_return_status OUT NOCOPY VARCHAR2,
149 x_error_msg OUT NOCOPY VARCHAR2);
150
151 PROCEDURE get_pending_adjustments
152 (p_asset_query_rec IN OUT NOCOPY cse_datastructures_pub.asset_query_rec,
153 x_return_status OUT NOCOPY VARCHAR2,
154 x_error_msg OUT NOCOPY VARCHAR2);
155
156 PROCEDURE insert_mass_add(
157 p_api_version IN NUMBER
158 , p_commit IN VARCHAR2
159 , p_init_msg_list IN VARCHAR2
160 , p_mass_add_rec IN OUT NOCOPY fa_mass_additions%ROWTYPE
161 , x_return_status OUT NOCOPY VARCHAR2
162 , x_msg_count OUT NOCOPY NUMBER
163 , x_msg_data OUT NOCOPY VARCHAR2 );
164
165 FUNCTION get_item_cost
166 ( p_inventory_item_id IN NUMBER,
167 p_organization_id IN NUMBER
168 ) RETURN NUMBER ;
169
170
171
172
173 PROCEDURE get_fa_location(
174 p_inst_loc_rec IN cse_asset_util_pkg.inst_loc_rec
175 , x_asset_location_id OUT NOCOPY NUMBER
176 , x_return_status OUT NOCOPY VARCHAR2
177 , x_error_msg OUT NOCOPY VARCHAR2) ;
178
179 PROCEDURE get_unit_cost(
180 p_source_txn_type IN VARCHAR2
181 , p_source_txn_id IN NUMBER
182 , p_inventory_item_id IN NUMBER
183 , p_organization_id IN NUMBER
184 , x_unit_cost OUT NOCOPY NUMBER
185 , x_error_msg OUT NOCOPY VARCHAR2
186 , x_return_status OUT NOCOPY VARCHAR2) ;
187
188 PROCEDURE is_valid_to_retire (p_asset_id IN NUMBER
189 ,p_book_type_code IN VARCHAR2
190 ,x_valid_to_retire_flag OUT NOCOPY VARCHAR2
191 ,x_error_msg OUT NOCOPY VARCHAR2
192 ,x_return_status OUT NOCOPY VARCHAR2);
193
194 PROCEDURE get_txn_class (p_asset_attrib_rec IN OUT NOCOPY CSE_DATASTRUCTURES_PUB.asset_attrib_rec,
195 x_transaction_class OUT NOCOPY VARCHAR2,
196 x_return_status OUT NOCOPY VARCHAR2,
197 x_error_msg OUT NOCOPY VARCHAR2) ;
198
199 FUNCTION get_rcv_sub_ledger_id( p_rcv_transaction_id IN number) RETURN number;
200
201 FUNCTION get_fa_period_name (
202 p_book_type_code IN varchar2,
203 p_dpis IN date)
204 RETURN varchar2;
205
206 FUNCTION get_ap_sla_acct_id(
207 p_invoice_id IN number,
208 p_invoice_dist_type IN varchar2)
209 RETURN number;
210
211 PROCEDURE validate_ccid_required (x_asset_key_required out nocopy varchar2);
212
213 END cse_asset_util_pkg ;