eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.ARP_CTLGD_PKG

Source


1 PACKAGE ARP_CTLGD_PKG AS
2 /* $Header: ARTILGDS.pls 120.4 2005/10/30 04:27:22 appldev 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,
73            p_latest_rec_flag                IN
74              ra_cust_trx_line_gl_dist.latest_rec_flag%type,
75            p_ussgl_transaction_code         IN
76              ra_cust_trx_line_gl_dist.ussgl_transaction_code%type,
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 
114 PROCEDURE fetch_p( p_dist_rec         OUT NOCOPY ra_cust_trx_line_gl_dist%rowtype,
115                    p_cust_trx_line_gl_dist_id IN
116                      ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type);
117 
118 procedure delete_p( p_cust_trx_line_gl_dist_id
119                 IN ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type);
120 
121 procedure delete_f_ct_id( p_customer_trx_id
122                          IN ra_customer_trx.customer_trx_id%type,
123                         p_account_set_flag
124                            IN ra_cust_trx_line_gl_dist.account_set_flag%type,
125                         p_account_class
126                            IN ra_cust_trx_line_gl_dist.account_class%type);
127 
128 procedure delete_f_ctl_id( p_customer_trx_line_id
129                          IN ra_customer_trx_lines.customer_trx_line_id%type,
130                         p_account_set_flag
131                            IN ra_cust_trx_line_gl_dist.account_set_flag%type,
132                         p_account_class
133                            IN ra_cust_trx_line_gl_dist.account_class%type);
134 
135 procedure delete_f_ctls_id( p_cust_trx_line_salesrep_id
136                   IN ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
137                             p_account_set_flag
138                              IN ra_cust_trx_line_gl_dist.account_set_flag%type,
139                             p_account_class
140                                IN ra_cust_trx_line_gl_dist.account_class%type);
141 
142 PROCEDURE delete_f_ct_ltctl_id_type(
143              p_customer_trx_id          IN
144                             ra_customer_trx.customer_trx_id%type,
145              p_link_to_cust_trx_line_id IN
146                             ra_customer_trx_lines.link_to_cust_trx_line_id%type,
147              p_line_type                IN
148                             ra_customer_trx_lines.line_type%type,
149              p_account_set_flag         IN
150                             ra_cust_trx_line_gl_dist.account_set_flag%type,
151              p_account_class            IN
152                             ra_cust_trx_line_gl_dist.account_class%type);
153 
154 PROCEDURE update_p( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
155                     p_cust_trx_line_gl_dist_id  IN
156                      ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,
157                     p_exchange_rate IN ra_customer_trx.exchange_rate%type
158                                        DEFAULT 1,
159                     p_currency_code IN fnd_currencies.currency_code%type
160                                        DEFAULT null,
161                     p_precision     IN fnd_currencies.precision%type
162                                        DEFAULT null,
163                     p_mau           IN
164                                  fnd_currencies.minimum_accountable_unit%type
165                                        DEFAULT null);
166 
167 PROCEDURE update_f_ct_id( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
168                     p_customer_trx_id  IN ra_customer_trx.customer_trx_id%type,
169                     p_account_set_flag
170                          IN ra_cust_trx_line_gl_dist.account_set_flag%type,
171                     p_account_class
172                          IN ra_cust_trx_line_gl_dist.account_class%type,
173                     p_exchange_rate IN ra_customer_trx.exchange_rate%type
174      				       DEFAULT 1,
175                     p_currency_code IN fnd_currencies.currency_code%type
176  				       DEFAULT null,
177                     p_precision     IN fnd_currencies.precision%type
178                                        DEFAULT null,
179                     p_mau           IN
180                                  fnd_currencies.minimum_accountable_unit%type
181                                        DEFAULT null);
182 
183 PROCEDURE update_f_ctl_id(
184                          p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
185                          p_customer_trx_line_id  IN
186                                ra_customer_trx_lines.customer_trx_line_id%type,
187                          p_account_set_flag
188                              IN ra_cust_trx_line_gl_dist.account_set_flag%type,
189                          p_account_class
190                               IN ra_cust_trx_line_gl_dist.account_class%type,
191                          p_exchange_rate IN ra_customer_trx.exchange_rate%type
192                                             DEFAULT 1,
193                          p_currency_code IN fnd_currencies.currency_code%type
194                                             DEFAULT null,
195                          p_precision     IN fnd_currencies.precision%type
196                                             DEFAULT null,
197                          p_mau           IN
198                                  fnd_currencies.minimum_accountable_unit%type
199                                             DEFAULT null);
200 
201 PROCEDURE update_f_ctls_id(
202                          p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
203                          p_cust_trx_line_salesrep_id  IN
204                     ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
205                          p_account_set_flag
206                              IN ra_cust_trx_line_gl_dist.account_set_flag%type,
207                          p_account_class
208                                IN ra_cust_trx_line_gl_dist.account_class%type,
209                          p_exchange_rate IN ra_customer_trx.exchange_rate%type
210                                             DEFAULT 1,
211                          p_currency_code IN fnd_currencies.currency_code%type
212                                             DEFAULT null,
213                          p_precision     IN fnd_currencies.precision%type
214                                             DEFAULT null,
215                          p_mau           IN
216                                  fnd_currencies.minimum_accountable_unit%type
217                                             DEFAULT null);
218 
219 PROCEDURE update_acctd_amount(p_customer_trx_id IN number,
220                               p_base_curr_code IN
221                                 fnd_currencies.currency_code%type,
222                               p_exchange_rate IN
223                                 ra_customer_trx.exchange_rate%type,
224                               p_base_precision IN
225                                 fnd_currencies.precision%type
226                                 default null,
227                               p_base_min_acc_unit IN
228                                 fnd_currencies.minimum_accountable_unit%type
229                                 default null);
230 
231 PROCEDURE update_amount_f_ctl_id(p_customer_trx_line_id IN
232                                ra_customer_trx_lines.customer_trx_line_id%type,
233                               p_line_amount IN
234                                 ra_customer_trx_lines.extended_amount%type,
235                               p_foreign_currency_code IN
236 				fnd_currencies.currency_code%type,
237                               p_base_curr_code IN
238                                 fnd_currencies.currency_code%type,
239                               p_exchange_rate IN
240                                 ra_customer_trx.exchange_rate%type,
241                               p_base_precision IN
242                                 fnd_currencies.precision%type
243                                 default null,
244                               p_base_min_acc_unit IN
245                                 fnd_currencies.minimum_accountable_unit%type
246                                 default null);
247 
248 PROCEDURE insert_p(
249              p_dist_rec          IN ra_cust_trx_line_gl_dist%rowtype,
250              p_cust_trx_line_gl_dist_id
251                   OUT NOCOPY ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type,
252              p_exchange_rate IN ra_customer_trx.exchange_rate%type
253                                 DEFAULT 1,
254              p_currency_code IN fnd_currencies.currency_code%type
255                                 DEFAULT null,
256              p_precision     IN fnd_currencies.precision%type
257                                 DEFAULT null,
258              p_mau           IN fnd_currencies.minimum_accountable_unit%type
259                                 DEFAULT null
260                   );
261 
262 PROCEDURE display_dist_rec( p_dist_rec IN ra_cust_trx_line_gl_dist%rowtype);
263 
267 PROCEDURE display_dist_f_ctls_id(  p_cust_trx_line_salesrep_id IN
264 PROCEDURE display_dist_p(  p_cust_trx_line_gl_dist_id IN
265  		   ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type);
266 
268                     ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type);
269 
270 PROCEDURE display_dist_f_ct_id( p_customer_trx_id IN
271                                          ra_customer_trx.customer_trx_id%type);
272 
273 PROCEDURE display_dist_f_ctl_id( p_customer_trx_line_id IN
274                               ra_customer_trx_lines.customer_trx_line_id%type);
275 
276 PROCEDURE merge_dist_recs(
277                          p_old_dist_rec IN ra_cust_trx_line_gl_dist%rowtype,
278                          p_new_dist_rec IN
279                                           ra_cust_trx_line_gl_dist%rowtype,
280                          p_out_dist_rec IN OUT NOCOPY
281                                           ra_cust_trx_line_gl_dist%rowtype
282                          );
283 
284 FUNCTION get_number_dummy(p_null IN NUMBER DEFAULT null) RETURN NUMBER;
285 
286 PROCEDURE select_summary(
287                          p_customer_trx_id             IN      number,
288                          p_customer_trx_line_id        IN      number,
289                          p_cust_trx_line_salesrep_id   IN      number,
290                          p_mode                        IN      varchar2,
291                          p_account_set_flag            IN      varchar2,
292                          p_amt_total                   IN OUT NOCOPY  number,
293                          p_amt_total_rtot_db           IN OUT NOCOPY  number,
294                          p_pct_total                   IN OUT NOCOPY  number,
295                          p_pct_total_rtot_db           IN OUT NOCOPY  number,
296                          p_pct_rev_total               IN OUT NOCOPY  number,
297                          p_pct_rev_total_rtot_db       IN OUT NOCOPY  number,
298                          p_pct_offset_total            IN OUT NOCOPY  number,
299                          p_pct_offset_total_rtot_db    IN OUT NOCOPY  number,
300                          p_pct_suspense_total          IN OUT NOCOPY  number,
301                          p_pct_suspense_total_rtot_db  IN OUT NOCOPY  number );
302 
303 END ARP_CTLGD_PKG;