[Home] [Help]
PACKAGE: APPS.ARP_CTLGD_PKG
Source
1 PACKAGE ARP_CTLGD_PKG AUTHID CURRENT_USER AS
2 /* $Header: ARTILGDS.pls 120.4.12010000.2 2009/09/14 11:20:53 rasarasw ship $ */
3
4 PROCEDURE set_to_dummy( p_dist_rec OUT NOCOPY ra_cust_trx_line_gl_dist%rowtype);
5
6
7 PROCEDURE lock_p( p_cust_trx_line_gl_dist_id
8 IN ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type);
9
10 PROCEDURE lock_f_ct_id( p_customer_trx_id
11 IN ra_customer_trx.customer_trx_id%type,
12 p_account_set_flag
13 IN ra_cust_trx_line_gl_dist.account_set_flag%type,
14 p_account_class
15 IN ra_cust_trx_line_gl_dist.account_class%type);
16
17 PROCEDURE lock_f_ctl_id( p_customer_trx_line_id
18 IN ra_customer_trx_lines.customer_trx_line_id%type,
19 p_account_set_flag
20 IN ra_cust_trx_line_gl_dist.account_set_flag%type,
21 p_account_class
22 IN ra_cust_trx_line_gl_dist.account_class%type);
23
24 PROCEDURE lock_f_ctls_id( p_cust_trx_line_salesrep_id
25 IN ra_cust_trx_line_gl_dist.cust_trx_line_salesrep_id%type,
26 p_account_set_flag
27 IN ra_cust_trx_line_gl_dist.account_set_flag%type,
28 p_account_class
29 IN ra_cust_trx_line_gl_dist.account_class%type);
30
31 PROCEDURE lock_fetch_p( p_dist_rec IN OUT NOCOPY ra_cust_trx_line_gl_dist%rowtype,
32 p_cust_trx_line_gl_dist_id IN
33 ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type);
34
35 PROCEDURE lock_compare_p( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
36 p_cust_trx_line_gl_dist_id IN
37 ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,
38 p_ignore_who_flag BOOLEAN DEFAULT FALSE);
39
40 PROCEDURE lock_compare_cover(
41 p_cust_trx_line_gl_dist_id IN
42 ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,
43 p_customer_trx_id IN
44 ra_cust_trx_line_gl_dist.customer_trx_id%type,
45 p_customer_trx_line_id IN
46 ra_cust_trx_line_gl_dist.customer_trx_line_id %type,
47 p_cust_trx_line_salesrep_id IN
48 ra_cust_trx_line_gl_dist.cust_trx_line_salesrep_id%type,
49 p_account_class IN
50 ra_cust_trx_line_gl_dist.account_class%type,
51 p_percent IN
52 ra_cust_trx_line_gl_dist.percent%type,
53 p_amount IN
54 ra_cust_trx_line_gl_dist.amount%type,
55 p_gl_date IN
56 ra_cust_trx_line_gl_dist.gl_date%type,
57 p_original_gl_date IN
58 ra_cust_trx_line_gl_dist.original_gl_date%type,
59 p_gl_posted_date IN
60 ra_cust_trx_line_gl_dist.gl_posted_date%type,
61 p_code_combination_id IN
62 ra_cust_trx_line_gl_dist.code_combination_id%type,
63 p_concatenated_segments IN
64 ra_cust_trx_line_gl_dist.concatenated_segments%type,
65 p_collected_tax_ccid IN
66 ra_cust_trx_line_gl_dist.collected_tax_ccid%type,
67 p_collected_tax_concat_seg IN
68 ra_cust_trx_line_gl_dist.collected_tax_concat_seg%type,
69 p_comments IN
70 ra_cust_trx_line_gl_dist.comments%type,
71 p_account_set_flag IN
72 ra_cust_trx_line_gl_dist.account_set_flag%type,
76 ra_cust_trx_line_gl_dist.ussgl_transaction_code%type,
73 p_latest_rec_flag IN
74 ra_cust_trx_line_gl_dist.latest_rec_flag%type,
75 p_ussgl_transaction_code IN
77 p_ussgl_trx_code_context IN
78 ra_cust_trx_line_gl_dist.ussgl_transaction_code_context%type,
79 p_attribute_category IN
80 ra_cust_trx_line_gl_dist.attribute_category%type,
81 p_attribute1 IN
82 ra_cust_trx_line_gl_dist.attribute1%type,
83 p_attribute2 IN
84 ra_cust_trx_line_gl_dist.attribute2%type,
85 p_attribute3 IN
86 ra_cust_trx_line_gl_dist.attribute3%type,
87 p_attribute4 IN
88 ra_cust_trx_line_gl_dist.attribute4%type,
89 p_attribute5 IN
90 ra_cust_trx_line_gl_dist.attribute5%type,
91 p_attribute6 IN
92 ra_cust_trx_line_gl_dist.attribute6%type,
93 p_attribute7 IN
94 ra_cust_trx_line_gl_dist.attribute7%type,
95 p_attribute8 IN
96 ra_cust_trx_line_gl_dist.attribute8%type,
97 p_attribute9 IN
98 ra_cust_trx_line_gl_dist.attribute9%type,
99 p_attribute10 IN
100 ra_cust_trx_line_gl_dist.attribute10%type,
101 p_attribute11 IN
102 ra_cust_trx_line_gl_dist.attribute11%type,
103 p_attribute12 IN
104 ra_cust_trx_line_gl_dist.attribute12%type,
105 p_attribute13 IN
106 ra_cust_trx_line_gl_dist.attribute13%type,
107 p_attribute14 IN
108 ra_cust_trx_line_gl_dist.attribute14%type,
109 p_attribute15 IN
110 ra_cust_trx_line_gl_dist.attribute15%type,
111 p_posting_control_id IN
112 ra_cust_trx_line_gl_dist.posting_control_id%type,
113 p_ccid_change_flag IN
114 ra_cust_trx_line_gl_dist.ccid_change_flag%type ); /* Bug 8788491 */
115
116 PROCEDURE fetch_p( p_dist_rec OUT NOCOPY ra_cust_trx_line_gl_dist%rowtype,
117 p_cust_trx_line_gl_dist_id IN
118 ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type);
119
120 procedure delete_p( p_cust_trx_line_gl_dist_id
121 IN ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type);
122
123 procedure delete_f_ct_id( p_customer_trx_id
124 IN ra_customer_trx.customer_trx_id%type,
125 p_account_set_flag
126 IN ra_cust_trx_line_gl_dist.account_set_flag%type,
127 p_account_class
128 IN ra_cust_trx_line_gl_dist.account_class%type);
129
130 procedure delete_f_ctl_id( p_customer_trx_line_id
131 IN ra_customer_trx_lines.customer_trx_line_id%type,
132 p_account_set_flag
133 IN ra_cust_trx_line_gl_dist.account_set_flag%type,
134 p_account_class
135 IN ra_cust_trx_line_gl_dist.account_class%type);
136
137 procedure delete_f_ctls_id( p_cust_trx_line_salesrep_id
138 IN ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
139 p_account_set_flag
140 IN ra_cust_trx_line_gl_dist.account_set_flag%type,
141 p_account_class
142 IN ra_cust_trx_line_gl_dist.account_class%type);
143
144 PROCEDURE delete_f_ct_ltctl_id_type(
145 p_customer_trx_id IN
146 ra_customer_trx.customer_trx_id%type,
147 p_link_to_cust_trx_line_id IN
148 ra_customer_trx_lines.link_to_cust_trx_line_id%type,
149 p_line_type IN
150 ra_customer_trx_lines.line_type%type,
151 p_account_set_flag IN
152 ra_cust_trx_line_gl_dist.account_set_flag%type,
153 p_account_class IN
154 ra_cust_trx_line_gl_dist.account_class%type);
155
156 PROCEDURE update_p( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
157 p_cust_trx_line_gl_dist_id IN
158 ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,
159 p_exchange_rate IN ra_customer_trx.exchange_rate%type
160 DEFAULT 1,
161 p_currency_code IN fnd_currencies.currency_code%type
162 DEFAULT null,
163 p_precision IN fnd_currencies.precision%type
164 DEFAULT null,
165 p_mau IN
166 fnd_currencies.minimum_accountable_unit%type
167 DEFAULT null);
168
169 PROCEDURE update_f_ct_id( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
170 p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
171 p_account_set_flag
172 IN ra_cust_trx_line_gl_dist.account_set_flag%type,
173 p_account_class
174 IN ra_cust_trx_line_gl_dist.account_class%type,
175 p_exchange_rate IN ra_customer_trx.exchange_rate%type
176 DEFAULT 1,
177 p_currency_code IN fnd_currencies.currency_code%type
178 DEFAULT null,
179 p_precision IN fnd_currencies.precision%type
183 DEFAULT null);
180 DEFAULT null,
181 p_mau IN
182 fnd_currencies.minimum_accountable_unit%type
184
185 PROCEDURE update_f_ctl_id(
186 p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
187 p_customer_trx_line_id IN
188 ra_customer_trx_lines.customer_trx_line_id%type,
189 p_account_set_flag
190 IN ra_cust_trx_line_gl_dist.account_set_flag%type,
191 p_account_class
192 IN ra_cust_trx_line_gl_dist.account_class%type,
193 p_exchange_rate IN ra_customer_trx.exchange_rate%type
194 DEFAULT 1,
195 p_currency_code IN fnd_currencies.currency_code%type
196 DEFAULT null,
197 p_precision IN fnd_currencies.precision%type
198 DEFAULT null,
199 p_mau IN
200 fnd_currencies.minimum_accountable_unit%type
201 DEFAULT null);
202
203 PROCEDURE update_f_ctls_id(
204 p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
205 p_cust_trx_line_salesrep_id IN
206 ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
207 p_account_set_flag
208 IN ra_cust_trx_line_gl_dist.account_set_flag%type,
209 p_account_class
210 IN ra_cust_trx_line_gl_dist.account_class%type,
211 p_exchange_rate IN ra_customer_trx.exchange_rate%type
212 DEFAULT 1,
213 p_currency_code IN fnd_currencies.currency_code%type
214 DEFAULT null,
215 p_precision IN fnd_currencies.precision%type
216 DEFAULT null,
217 p_mau IN
218 fnd_currencies.minimum_accountable_unit%type
219 DEFAULT null);
220
221 PROCEDURE update_acctd_amount(p_customer_trx_id IN number,
222 p_base_curr_code IN
223 fnd_currencies.currency_code%type,
224 p_exchange_rate IN
225 ra_customer_trx.exchange_rate%type,
226 p_base_precision IN
227 fnd_currencies.precision%type
228 default null,
229 p_base_min_acc_unit IN
230 fnd_currencies.minimum_accountable_unit%type
231 default null);
232
233 PROCEDURE update_amount_f_ctl_id(p_customer_trx_line_id IN
234 ra_customer_trx_lines.customer_trx_line_id%type,
235 p_line_amount IN
236 ra_customer_trx_lines.extended_amount%type,
237 p_foreign_currency_code IN
238 fnd_currencies.currency_code%type,
239 p_base_curr_code IN
240 fnd_currencies.currency_code%type,
241 p_exchange_rate IN
242 ra_customer_trx.exchange_rate%type,
243 p_base_precision IN
244 fnd_currencies.precision%type
245 default null,
246 p_base_min_acc_unit IN
247 fnd_currencies.minimum_accountable_unit%type
248 default null);
249
250 PROCEDURE insert_p(
251 p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
252 p_cust_trx_line_gl_dist_id
253 OUT NOCOPY ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,
254 p_exchange_rate IN ra_customer_trx.exchange_rate%type
255 DEFAULT 1,
256 p_currency_code IN fnd_currencies.currency_code%type
257 DEFAULT null,
258 p_precision IN fnd_currencies.precision%type
259 DEFAULT null,
260 p_mau IN fnd_currencies.minimum_accountable_unit%type
261 DEFAULT null
262 );
263
264 PROCEDURE display_dist_rec( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype);
265
266 PROCEDURE display_dist_p( p_cust_trx_line_gl_dist_id IN
267 ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type);
268
269 PROCEDURE display_dist_f_ctls_id( p_cust_trx_line_salesrep_id IN
270 ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type);
271
272 PROCEDURE display_dist_f_ct_id( p_customer_trx_id IN
273 ra_customer_trx.customer_trx_id%type);
274
275 PROCEDURE display_dist_f_ctl_id( p_customer_trx_line_id IN
276 ra_customer_trx_lines.customer_trx_line_id%type);
277
278 PROCEDURE merge_dist_recs(
279 p_old_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
280 p_new_dist_rec IN
281 ra_cust_trx_line_gl_dist%rowtype,
282 p_out_dist_rec IN OUT NOCOPY
283 ra_cust_trx_line_gl_dist%rowtype
284 );
285
286 FUNCTION get_number_dummy(p_null IN NUMBER DEFAULT null) RETURN NUMBER;
287
288 PROCEDURE select_summary(
289 p_customer_trx_id IN number,
290 p_customer_trx_line_id IN number,
291 p_cust_trx_line_salesrep_id IN number,
292 p_mode IN varchar2,
293 p_account_set_flag IN varchar2,
294 p_amt_total IN OUT NOCOPY number,
295 p_amt_total_rtot_db IN OUT NOCOPY number,
296 p_pct_total IN OUT NOCOPY number,
297 p_pct_total_rtot_db IN OUT NOCOPY number,
298 p_pct_rev_total IN OUT NOCOPY number,
299 p_pct_rev_total_rtot_db IN OUT NOCOPY number,
300 p_pct_offset_total IN OUT NOCOPY number,
301 p_pct_offset_total_rtot_db IN OUT NOCOPY number,
302 p_pct_suspense_total IN OUT NOCOPY number,
303 p_pct_suspense_total_rtot_db IN OUT NOCOPY number );
304
305 END ARP_CTLGD_PKG;