1 PACKAGE AR_RAAPI_UTIL AS
2 /*$Header: ARXRAAUS.pls 120.6 2006/04/05 13:16:03 mraymond ship $*/
3 g_system_cache_flag VARCHAR2(1) := 'N';
4
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 TYPE Segment_Rec_Type IS RECORD
47 ( segment1 VARCHAR2(40)
48 ,segment2 VARCHAR2(40)
49 ,segment3 VARCHAR2(40)
50 ,segment4 VARCHAR2(40)
51 ,segment5 VARCHAR2(40)
52 ,segment6 VARCHAR2(40)
53 ,segment7 VARCHAR2(40)
54 ,segment8 VARCHAR2(40)
55 ,segment9 VARCHAR2(40)
56 ,segment10 VARCHAR2(40)
57 ,segment11 VARCHAR2(40)
58 ,segment12 VARCHAR2(40)
59 ,segment13 VARCHAR2(40)
60 ,segment14 VARCHAR2(40)
61 ,segment15 VARCHAR2(40)
62 ,segment16 VARCHAR2(40)
63 ,segment17 VARCHAR2(40)
64 ,segment18 VARCHAR2(40)
65 ,segment19 VARCHAR2(40)
66 ,segment20 VARCHAR2(40));
67
68 PROCEDURE Constant_System_Values;
69
70 PROCEDURE Initialize_Globals;
71
72 PROCEDURE Constant_Trx_Values
73 (p_customer_trx_id IN NUMBER);
74
75 FUNCTION Get_Salesrep_Cost_Ctr
76 (p_salesrep_id IN NUMBER)
77 RETURN VARCHAR2;
78
79 FUNCTION Get_Cost_Ctr
80 (p_code_combination_id IN NUMBER)
81 RETURN VARCHAR2;
82
83 PROCEDURE Validate_Parameters
84 (p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
85 ,p_rev_adj_rec IN OUT NOCOPY AR_Revenue_Adjustment_PVT.Rev_Adj_Rec_Type
86 ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
87 ,x_return_status IN OUT NOCOPY VARCHAR2
88 ,x_msg_count OUT NOCOPY NUMBER
89 ,x_msg_data OUT NOCOPY VARCHAR2);
90
91 PROCEDURE Validate_Transaction
92 (p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
93 ,p_rev_adj_rec IN AR_Revenue_Adjustment_PVT.Rev_Adj_Rec_Type
94 ,p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
95 ,x_return_status IN OUT NOCOPY VARCHAR2
96 ,x_msg_count OUT NOCOPY NUMBER
97 ,x_msg_data OUT NOCOPY VARCHAR2);
98
99 PROCEDURE Validate_Salesreps
100 (p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
101 ,p_rev_adj_rec IN AR_Revenue_Adjustment_PVT.Rev_Adj_Rec_Type
102 ,x_return_status IN OUT NOCOPY VARCHAR2
103 ,x_msg_count OUT NOCOPY NUMBER
104 ,x_msg_data OUT NOCOPY VARCHAR2);
105
106 PROCEDURE Validate_Category
107 (p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
108 ,p_rev_adj_rec IN AR_Revenue_Adjustment_PVT.Rev_Adj_Rec_Type
109 ,x_return_status IN OUT NOCOPY VARCHAR2
110 ,x_msg_count OUT NOCOPY NUMBER
111 ,x_msg_data OUT NOCOPY VARCHAR2);
112
113 PROCEDURE Validate_Item
114 (p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
115 ,p_rev_adj_rec IN AR_Revenue_Adjustment_PVT.Rev_Adj_Rec_Type
116 ,x_return_status IN OUT NOCOPY VARCHAR2
117 ,x_msg_count OUT NOCOPY NUMBER
118 ,x_msg_data OUT NOCOPY VARCHAR2);
119
120 PROCEDURE Validate_Line
121 (p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
122 ,p_rev_adj_rec IN AR_Revenue_Adjustment_PVT.Rev_Adj_Rec_Type
123 ,x_return_status IN OUT NOCOPY VARCHAR2
124 ,x_msg_count OUT NOCOPY NUMBER
125 ,x_msg_data OUT NOCOPY VARCHAR2);
126
127 FUNCTION Validate_GL_Date
128 (p_gl_date IN DATE)
129 RETURN DATE;
130
131 FUNCTION bump_gl_date_if_closed
132 (p_gl_date IN DATE)
133 RETURN DATE;
134
135 PROCEDURE Validate_Other
136 (p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
137 ,p_rev_adj_rec IN AR_Revenue_Adjustment_PVT.Rev_Adj_Rec_Type
138 ,x_return_status IN OUT NOCOPY VARCHAR2
139 ,x_msg_count OUT NOCOPY NUMBER
140 ,x_msg_data OUT NOCOPY VARCHAR2);
141
142 PROCEDURE Validate_Sales_Credits
143 (p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
144 ,p_customer_trx_id IN NUMBER
145 ,p_sales_credit_type IN VARCHAR2
146 ,p_salesrep_id IN NUMBER
147 ,p_salesgroup_id IN NUMBER DEFAULT NULL
148 ,p_customer_trx_line_id IN NUMBER
149 ,p_item_id IN NUMBER
150 ,p_category_id IN NUMBER
151 ,x_return_status IN OUT NOCOPY VARCHAR2
152 ,x_msg_count OUT NOCOPY NUMBER
153 ,x_msg_data OUT NOCOPY VARCHAR2);
154
155 FUNCTION Total_Selected_Line_Value
156 (p_customer_trx_line_id IN NUMBER
157 ,p_customer_trx_id IN NUMBER
158 ,p_item_id IN NUMBER
159 ,p_category_id IN NUMBER
160 ,p_salesrep_id IN NUMBER
161 ,p_salesgroup_id IN NUMBER DEFAULT NULL
162 ,p_sales_credit_type IN VARCHAR2)
163 RETURN NUMBER;
164
165 FUNCTION Adjustable_Revenue
166 (p_customer_trx_line_id IN NUMBER
167 ,p_adjustment_type IN VARCHAR2
168 ,p_customer_trx_id IN NUMBER
169 ,p_salesrep_id IN NUMBER
170 ,p_salesgroup_id IN NUMBER DEFAULT NULL
171 ,p_sales_credit_type IN VARCHAR2
172 ,p_item_id IN NUMBER
173 ,p_category_id IN NUMBER
174 ,p_revenue_adjustment_id IN NUMBER := NULL
175 ,p_line_count_out OUT NOCOPY NUMBER
176 ,p_acctd_amount_out OUT NOCOPY NUMBER)
177 RETURN NUMBER;
178
179 PROCEDURE Validate_Amount
180 (p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
181 ,p_customer_trx_line_id IN NUMBER
182 ,p_adjustment_type IN VARCHAR2
183 ,p_amount_mode IN VARCHAR2
184 ,p_customer_trx_id IN NUMBER
185 ,p_salesrep_id IN NUMBER
186 ,p_salesgroup_id IN NUMBER DEFAULT NULL
187 ,p_sales_credit_type IN VARCHAR2
188 ,p_item_id IN NUMBER
189 ,p_category_id IN NUMBER
190 ,p_revenue_amount_in IN NUMBER
191 ,p_revenue_percent IN NUMBER
192 ,p_revenue_adjustment_id IN NUMBER := NULL
193 ,p_revenue_amount_out OUT NOCOPY NUMBER
194 ,p_adjustable_amount_out OUT NOCOPY NUMBER
195 ,p_line_count_out OUT NOCOPY NUMBER
196 ,x_return_status OUT NOCOPY VARCHAR2
197 ,x_msg_count OUT NOCOPY NUMBER
198 ,x_msg_data OUT NOCOPY VARCHAR2);
199
200 FUNCTION Revalidate_GL_Dates
201 (p_customer_trx_id IN NUMBER
202 ,p_revenue_adjustment_id IN NUMBER
203 ,x_msg_count OUT NOCOPY NUMBER
204 ,x_msg_data OUT NOCOPY VARCHAR2)
205 RETURN VARCHAR2;
206
207 FUNCTION Deferred_GL_Date (p_start_date IN DATE,
208 p_period_seq_no IN NUMBER)
209 RETURN DATE;
210
211 --
212 -- Read only functions to allow client access to globals
213 --
214 FUNCTION G_RET_STS_SUCCESS
215 RETURN VARCHAR2;
216
217 FUNCTION G_RET_STS_ERROR
218 RETURN VARCHAR2;
219
220 FUNCTION G_TRUE
221 RETURN VARCHAR2;
222
223 FUNCTION G_FALSE
224 RETURN VARCHAR2;
225
226 FUNCTION G_VALID_LEVEL_NONE
227 RETURN VARCHAR2;
228
229 FUNCTION G_VALID_LEVEL_FULL
230 RETURN VARCHAR2;
231
232 FUNCTION chart_of_accounts_id
233 RETURN NUMBER;
234
235 FUNCTION set_of_books_id
236 RETURN NUMBER;
237
238 FUNCTION application_id
239 RETURN NUMBER;
240
241 FUNCTION un_meaning
242 RETURN VARCHAR2;
243
244 FUNCTION ea_meaning
245 RETURN VARCHAR2;
246
247 FUNCTION sa_meaning
248 RETURN VARCHAR2;
249
250 FUNCTION nr_meaning
251 RETURN VARCHAR2;
252
253 FUNCTION ll_meaning
254 RETURN VARCHAR2;
255
256 FUNCTION cost_ctr_number
257 RETURN VARCHAR2;
258
259 FUNCTION category_set_id
260 RETURN VARCHAR2;
261
262 FUNCTION category_structure_id
263 RETURN VARCHAR2;
264
265 FUNCTION inv_org_id
266 RETURN VARCHAR2;
267
268 END AR_RAAPI_UTIL;