4
1 PACKAGE AR_RAAPI_UTIL AUTHID CURRENT_USER AS
2 /*$Header: ARXRAAUS.pls 120.11 2011/01/04 21:21:31 mraymond ship $*/
3 g_system_cache_flag VARCHAR2(1) := 'N';
5 g_set_of_books_id NUMBER;
6 g_rev_transfer_clear_ccid NUMBER;
7 g_sales_credit_pct_limit NUMBER;
8 g_ar_app_id NUMBER;
9 g_inv_org_id NUMBER;
10 g_chart_of_accounts_id NUMBER;
11 g_set_of_books_currency VARCHAR2(15);
12 g_set_of_books_precision NUMBER;
13 g_min_acc_unit NUMBER;
14 g_cost_ctr_number NUMBER;
15 g_category_set_id NUMBER;
16 g_category_structure_id NUMBER;
17 g_ea_meaning VARCHAR2(80);
18 g_un_meaning VARCHAR2(80);
19 g_sa_meaning VARCHAR2(80);
20 g_ll_meaning VARCHAR2(80);
21 g_nr_meaning VARCHAR2(80);
22
23 g_customer_trx_id NUMBER;
24 g_last_customer_trx_id NUMBER;
25 g_cust_trx_type_id NUMBER;
26 g_trx_date DATE;
27 g_invoicing_rule_id NUMBER;
28 g_trx_currency VARCHAR2(15);
29 g_trx_curr_format VARCHAR2(30);
30 g_exchange_rate NUMBER;
31 g_trx_precision NUMBER;
32
33 g_from_salesrep_id NUMBER;
34 g_to_salesrep_id NUMBER;
35 g_from_salesgroup_id NUMBER;
36 g_to_salesgroup_id NUMBER;
37 g_from_category_id NUMBER;
38 g_to_category_id NUMBER;
39 g_from_inventory_item_id NUMBER;
40 g_to_inventory_item_id NUMBER;
41 g_from_cust_trx_line_id NUMBER;
42 g_to_cust_trx_line_id NUMBER;
43
44 g_gl_date DATE;
45
46 g_called_from VARCHAR2(30);
47
48 TYPE Segment_Rec_Type IS RECORD
49 ( segment1 VARCHAR2(40)
50 ,segment2 VARCHAR2(40)
51 ,segment3 VARCHAR2(40)
52 ,segment4 VARCHAR2(40)
53 ,segment5 VARCHAR2(40)
54 ,segment6 VARCHAR2(40)
55 ,segment7 VARCHAR2(40)
56 ,segment8 VARCHAR2(40)
57 ,segment9 VARCHAR2(40)
58 ,segment10 VARCHAR2(40)
59 ,segment11 VARCHAR2(40)
60 ,segment12 VARCHAR2(40)
61 ,segment13 VARCHAR2(40)
62 ,segment14 VARCHAR2(40)
63 ,segment15 VARCHAR2(40)
64 ,segment16 VARCHAR2(40)
65 ,segment17 VARCHAR2(40)
66 ,segment18 VARCHAR2(40)
67 ,segment19 VARCHAR2(40)
68 ,segment20 VARCHAR2(40));
72 PROCEDURE Initialize_Globals;
69
70 PROCEDURE Constant_System_Values;
71
73
74 PROCEDURE Constant_Trx_Values
75 (p_customer_trx_id IN NUMBER);
76
77 FUNCTION Get_Salesrep_Cost_Ctr
78 (p_salesrep_id IN NUMBER)
79 RETURN VARCHAR2;
80
81 FUNCTION Get_Cost_Ctr
82 (p_code_combination_id IN NUMBER)
83 RETURN VARCHAR2;
84
85 PROCEDURE Validate_Parameters
86 (p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
87 ,p_rev_adj_rec IN OUT NOCOPY AR_Revenue_Adjustment_PVT.Rev_Adj_Rec_Type
88 ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
89 ,x_return_status IN OUT NOCOPY VARCHAR2
90 ,x_msg_count OUT NOCOPY NUMBER
91 ,x_msg_data OUT NOCOPY VARCHAR2);
92
93 PROCEDURE Validate_Transaction
94 (p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
95 ,p_rev_adj_rec IN AR_Revenue_Adjustment_PVT.Rev_Adj_Rec_Type
96 ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
97 ,x_return_status IN OUT NOCOPY VARCHAR2
98 ,x_msg_count OUT NOCOPY NUMBER
99 ,x_msg_data OUT NOCOPY VARCHAR2);
100
101 PROCEDURE Validate_Salesreps
102 (p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
103 ,p_rev_adj_rec IN AR_Revenue_Adjustment_PVT.Rev_Adj_Rec_Type
104 ,x_return_status IN OUT NOCOPY VARCHAR2
105 ,x_msg_count OUT NOCOPY NUMBER
106 ,x_msg_data OUT NOCOPY VARCHAR2);
107
108 PROCEDURE Validate_Category
109 (p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
110 ,p_rev_adj_rec IN AR_Revenue_Adjustment_PVT.Rev_Adj_Rec_Type
111 ,x_return_status IN OUT NOCOPY VARCHAR2
112 ,x_msg_count OUT NOCOPY NUMBER
113 ,x_msg_data OUT NOCOPY VARCHAR2);
114
115 PROCEDURE Validate_Item
116 (p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
117 ,p_rev_adj_rec IN AR_Revenue_Adjustment_PVT.Rev_Adj_Rec_Type
118 ,x_return_status IN OUT NOCOPY VARCHAR2
119 ,x_msg_count OUT NOCOPY NUMBER
120 ,x_msg_data OUT NOCOPY VARCHAR2);
121
122 PROCEDURE Validate_Line
123 (p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
124 ,p_rev_adj_rec IN AR_Revenue_Adjustment_PVT.Rev_Adj_Rec_Type
125 ,x_return_status IN OUT NOCOPY VARCHAR2
126 ,x_msg_count OUT NOCOPY NUMBER
127 ,x_msg_data OUT NOCOPY VARCHAR2);
128
129 FUNCTION Validate_GL_Date
130 (p_gl_date IN DATE)
131 RETURN DATE;
132
133 FUNCTION bump_gl_date_if_closed
134 (p_gl_date IN DATE)
135 RETURN DATE;
136
137 PROCEDURE Validate_Other
138 (p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
139 ,p_rev_adj_rec IN AR_Revenue_Adjustment_PVT.Rev_Adj_Rec_Type
140 ,x_return_status IN OUT NOCOPY VARCHAR2
141 ,x_msg_count OUT NOCOPY NUMBER
142 ,x_msg_data OUT NOCOPY VARCHAR2);
143
144 PROCEDURE Validate_Sales_Credits
145 (p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
146 ,p_customer_trx_id IN NUMBER
147 ,p_sales_credit_type IN VARCHAR2
148 ,p_salesrep_id IN NUMBER
149 ,p_salesgroup_id IN NUMBER DEFAULT NULL
150 ,p_customer_trx_line_id IN NUMBER
151 ,p_item_id IN NUMBER
152 ,p_category_id IN NUMBER
153 ,x_return_status IN OUT NOCOPY VARCHAR2
154 ,x_msg_count OUT NOCOPY NUMBER
155 ,x_msg_data OUT NOCOPY VARCHAR2);
156
157 FUNCTION Total_Selected_Line_Value
158 (p_customer_trx_line_id IN NUMBER
159 ,p_customer_trx_id IN NUMBER
160 ,p_item_id IN NUMBER
161 ,p_category_id IN NUMBER
162 ,p_salesrep_id IN NUMBER
163 ,p_salesgroup_id IN NUMBER DEFAULT NULL
164 ,p_sales_credit_type IN VARCHAR2)
165 RETURN NUMBER;
166
167 FUNCTION Adjustable_Revenue
168 (p_customer_trx_line_id IN NUMBER
169 ,p_adjustment_type IN VARCHAR2
170 ,p_customer_trx_id IN NUMBER
171 ,p_salesrep_id IN NUMBER
172 ,p_salesgroup_id IN NUMBER DEFAULT NULL
173 ,p_sales_credit_type IN VARCHAR2
174 ,p_item_id IN NUMBER
175 ,p_category_id IN NUMBER
176 ,p_revenue_adjustment_id IN NUMBER := NULL
177 ,p_line_count_out OUT NOCOPY NUMBER
178 ,p_acctd_amount_out OUT NOCOPY NUMBER)
179 RETURN NUMBER;
180
181 FUNCTION Adjustable_Revenue_Total
182 (p_customer_trx_line_id IN NUMBER
183 ,p_customer_trx_id IN NUMBER
184 ,p_adjustment_type IN VARCHAR2
185 ,p_revenue_adjustment_id IN NUMBER DEFAULT NULL)
186 RETURN NUMBER;
187
188
189 PROCEDURE Validate_Amount
190 (p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
191 ,p_customer_trx_line_id IN NUMBER
192 ,p_adjustment_type IN VARCHAR2
193 ,p_amount_mode IN VARCHAR2
194 ,p_customer_trx_id IN NUMBER
195 ,p_salesrep_id IN NUMBER
196 ,p_salesgroup_id IN NUMBER DEFAULT NULL
197 ,p_sales_credit_type IN VARCHAR2
198 ,p_item_id IN NUMBER
199 ,p_category_id IN NUMBER
200 ,p_revenue_amount_in IN NUMBER
201 ,p_revenue_percent IN NUMBER
202 ,p_revenue_adjustment_id IN NUMBER := NULL
203 ,p_revenue_amount_out OUT NOCOPY NUMBER
204 ,p_adjustable_amount_out OUT NOCOPY NUMBER
205 ,p_line_count_out OUT NOCOPY NUMBER
206 ,x_return_status OUT NOCOPY VARCHAR2
207 ,x_msg_count OUT NOCOPY NUMBER
208 ,x_msg_data OUT NOCOPY VARCHAR2);
209
210 FUNCTION Revalidate_GL_Dates
211 (p_customer_trx_id IN NUMBER
212 ,p_revenue_adjustment_id IN NUMBER
213 ,x_msg_count OUT NOCOPY NUMBER
214 ,x_msg_data OUT NOCOPY VARCHAR2)
215 RETURN VARCHAR2;
216
217 FUNCTION Deferred_GL_Date (p_start_date IN DATE,
218 p_period_seq_no IN NUMBER)
219 RETURN DATE;
220
221 /* 7454302 */
222 FUNCTION unearned_zero_lines(p_customer_trx_id IN NUMBER,
223 p_customer_trx_line_id IN NUMBER DEFAULT NULL,
224 p_check_line_amt IN VARCHAR DEFAULT 'Y',
225 p_adjustment_type IN VARCHAR DEFAULT 'EA')
226 RETURN BOOLEAN;
227
228 --
229 -- Read only functions to allow client access to globals
230 --
231 FUNCTION G_RET_STS_SUCCESS
232 RETURN VARCHAR2;
233
234 FUNCTION G_RET_STS_ERROR
235 RETURN VARCHAR2;
236
237 FUNCTION G_TRUE
238 RETURN VARCHAR2;
239
240 FUNCTION G_FALSE
241 RETURN VARCHAR2;
242
243 FUNCTION G_VALID_LEVEL_NONE
244 RETURN VARCHAR2;
245
246 FUNCTION G_VALID_LEVEL_FULL
247 RETURN VARCHAR2;
248
249 FUNCTION chart_of_accounts_id
250 RETURN NUMBER;
251
252 FUNCTION set_of_books_id
253 RETURN NUMBER;
254
255 FUNCTION application_id
256 RETURN NUMBER;
257
258 FUNCTION un_meaning
259 RETURN VARCHAR2;
260
261 FUNCTION ea_meaning
262 RETURN VARCHAR2;
263
264 FUNCTION sa_meaning
265 RETURN VARCHAR2;
266
267 FUNCTION nr_meaning
268 RETURN VARCHAR2;
269
270 FUNCTION ll_meaning
271 RETURN VARCHAR2;
272
273 FUNCTION cost_ctr_number
274 RETURN VARCHAR2;
275
276 FUNCTION category_set_id
277 RETURN VARCHAR2;
278
279 FUNCTION category_structure_id
280 RETURN VARCHAR2;
281
282 FUNCTION inv_org_id
283 RETURN VARCHAR2;
284
285 END AR_RAAPI_UTIL;