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_PROC_RCT_UTIL

Source


1 PACKAGE ARP_PROC_RCT_UTIL AUTHID CURRENT_USER AS
2 /* $Header: ARRURGWS.pls 120.10 2007/12/21 05:11:00 nproddut ship $ */
3 
4 /* ------------ Private procedures used by the package --------------------- */
5 /* ------------ ARP_PROCESS_RECEIPTS (ARRERGW?.pls)    --------------------- */
6 
7 FUNCTION revision RETURN VARCHAR2;
8 
9 
10 PROCEDURE insert_ps_rec_cash(
11 	p_cr_rec	IN  ar_cash_receipts%ROWTYPE,
12 	p_gl_date	IN  DATE,
13 	p_maturity_date IN  DATE,
14 	p_acctd_amount	IN
15 		ar_payment_schedules.acctd_amount_due_remaining%TYPE,
16         p_ps_id		OUT NOCOPY
17 		ar_payment_schedules.payment_schedule_id%TYPE
18 				);
19 
20 PROCEDURE insert_crh_rec(
21 	p_cr_rec		IN  ar_cash_receipts%ROWTYPE,
22 	p_crh_amount		IN  ar_cash_receipt_history.amount%TYPE,
23 	p_acctd_amount		IN  ar_cash_receipt_history.acctd_amount%TYPE,
24 	p_factor_discount_amount IN
25 		ar_cash_receipt_history.factor_discount_amount%TYPE,
26 	p_acctd_factor_discount_amount IN
27 		ar_cash_receipt_history.acctd_factor_discount_amount%TYPE,
28 	p_gl_date		IN  DATE,
29 	p_creation_status 	IN  VARCHAR2,
30 	p_batch_id		IN  ar_cash_receipt_history.batch_id%TYPE,
31 	p_ccid			IN
32 		ar_cash_receipt_history.account_code_combination_id%TYPE,
33 	p_bank_charges_ccid	IN
34 		ar_cash_receipt_history.bank_charge_account_ccid%TYPE,
35 	p_crh_rec		OUT NOCOPY ar_cash_receipt_history%ROWTYPE,
36         p_called_from      IN  VARCHAR2 DEFAULT NULL -- Bug 66608534
37 				);
38 
39 PROCEDURE insert_ra_rec_cash(
40 	p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
41 	p_amount	IN ar_cash_receipts.amount%TYPE,
42 	p_apply_date	IN DATE,
43 	p_status	IN ar_cash_receipts.status%TYPE,
44 	p_acctd_amount	IN
45 		ar_receivable_applications.acctd_amount_applied_from%TYPE,
46 	p_gl_date  	IN  DATE,
47 	p_ccid		IN
48 		ar_receivable_applications.code_combination_id%TYPE,
49 	p_payment_schedule_id 	IN
50 		ar_payment_schedules.payment_schedule_id%TYPE,
51 	p_application_rule IN ar_receivable_applications.application_rule%TYPE,
52         p_reversal_gl_date IN DATE default null,
53         p_ra_id            OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE ,
54         p_called_from      IN  VARCHAR2 DEFAULT NULL -- Bug 66608534
55 			);
56 
57 PROCEDURE insert_dist_rec(
58 	p_amount		IN ar_cash_receipts.amount%TYPE,
59         p_acctd_amount		IN ar_cash_receipt_history.acctd_amount%TYPE,
60         p_crh_id		IN
61 			ar_cash_receipt_history.cash_receipt_history_id%TYPE,
62 	p_source_type		IN ar_distributions.source_type%TYPE,
63 	p_ccid			IN ar_distributions.code_combination_id%TYPE,
64         p_called_from      IN  VARCHAR2 DEFAULT NULL -- jrautiai BR project
65 			);
66 
67 PROCEDURE round_mcd_recs(
68 	p_cash_receipt_id	IN ar_cash_receipts.cash_receipt_id%TYPE
69 			);
70 
71 
72 PROCEDURE insert_misc_dist(
73 	p_cash_receipt_id	IN ar_cash_receipts.cash_receipt_id%TYPE,
74 	p_gl_date		IN ar_cash_receipt_history.gl_date%TYPE,
75 	p_amount		IN ar_cash_receipts.amount%TYPE,
76 	p_currency_code		IN ar_cash_receipts.currency_code%TYPE,
77 	p_exchange_rate		IN ar_cash_receipts.exchange_rate%TYPE,
78 	p_acctd_amount		IN ar_cash_receipt_history.acctd_amount%TYPE,
79 	p_receipt_date		IN ar_cash_receipts.receipt_date%TYPE,
80 	p_receivables_trx_id	IN ar_cash_receipts.receivables_trx_id%TYPE,
81         p_distribution_set_id   IN ar_cash_receipts.distribution_set_id%TYPE default NULL,
82         p_ussgl_trx_code        IN ar_cash_receipts.ussgl_transaction_code%TYPE default NULL,
83         p_created_from          IN ar_misc_cash_distributions.created_from%TYPE default 'ARRERCT'
84 				);
85 
86 
87 PROCEDURE update_misc_dist(
88 	p_cash_receipt_id	IN ar_cash_receipts.cash_receipt_id%TYPE,
89 	p_amount		IN ar_cash_receipts.amount%TYPE,
90 	p_acctd_amount		IN ar_cash_receipt_history.acctd_amount%TYPE,
91 	p_amount_changed_flag	IN BOOLEAN,
92 	p_distribution_set_id	IN ar_cash_receipts.distribution_set_id%TYPE,
93 	p_receivables_trx_id	IN ar_cash_receipts.receivables_trx_id%TYPE,
94 	p_old_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
95 	p_old_receivables_trx_id  IN ar_cash_receipts.receivables_trx_id%TYPE,
96 	p_gl_date		IN ar_cash_receipt_history.gl_date%TYPE,
97 	p_gl_date_changed_flag  IN BOOLEAN,
98 	p_currency_code		IN ar_cash_receipts.currency_code%TYPE,
99 	p_exchange_rate		IN ar_cash_receipts.exchange_rate%TYPE,
100 	p_receipt_date		IN ar_cash_receipts.receipt_date%TYPE,
101 	p_receipt_date_changed_flag IN BOOLEAN,
102 	p_gl_tax_acct IN ar_distributions.code_combination_id%TYPE
103 				);
104 
105 PROCEDURE create_mcd_recs(
106 	p_cash_receipt_id 	IN ar_cash_receipts.cash_receipt_id%TYPE,
107 	p_amount		IN ar_cash_receipts.amount%TYPE,
108 	p_acctd_amount		IN ar_cash_receipt_history.acctd_amount%TYPE,
109 	p_exchange_rate 	IN ar_cash_receipts.exchange_rate%TYPE,
110 	p_currency_code 	IN ar_cash_receipts.currency_code%TYPE,
111 	p_gl_date		IN ar_cash_receipt_history.gl_date%TYPE,
112 	p_receipt_date		IN ar_cash_receipts.receipt_date%TYPE,
113 	p_distribution_set_id	IN ar_cash_receipts.distribution_set_id%TYPE,
114         p_ussgl_trx_code        IN ar_cash_receipts.ussgl_transaction_code%TYPE
115 			);
116 
117 
118 PROCEDURE update_manual_dist(
119 		p_cash_receipt_id  IN ar_cash_receipts.cash_receipt_id%TYPE,
120 		p_amount	   IN ar_cash_receipts.amount%TYPE,
121 		p_acctd_amount	   IN ar_cash_receipt_history.acctd_amount%TYPE,
122 		p_exchange_rate    IN ar_cash_receipts.exchange_rate%TYPE,
123 		p_currency_code    IN ar_cash_receipts.currency_code%TYPE,
124 		p_gl_date	   IN ar_cash_receipt_history.gl_date%TYPE,
125 		p_receipt_date	   IN ar_cash_receipts.receipt_date%TYPE
126 			);
127 
128 
129 PROCEDURE rate_adjust(
130 	p_cash_receipt_id	      IN ar_cash_receipts.cash_receipt_id%TYPE,
131 	p_rate_adjust_gl_date	      IN DATE,
132 	p_new_exchange_date	      IN DATE,
133 	p_new_exchange_rate	      IN ar_rate_adjustments.new_exchange_rate%TYPE,
134 	p_new_exchange_rate_type      IN ar_rate_adjustments.new_exchange_rate_type%TYPE,
135 	p_old_exchange_date	      IN DATE,
136 	p_old_exchange_rate	      IN ar_rate_adjustments.old_exchange_rate%TYPE,
137 	p_old_exchange_rate_type      IN ar_rate_adjustments.old_exchange_rate_type%TYPE,
138 	p_gain_loss		      IN ar_rate_adjustments.gain_loss%TYPE,
139 	p_exchange_rate_attr_cat      IN ar_rate_adjustments.attribute_category%TYPE,
140  	p_exchange_rate_attr1	      IN ar_rate_adjustments.attribute1%TYPE,
141  	p_exchange_rate_attr2	      IN ar_rate_adjustments.attribute2%TYPE,
142  	p_exchange_rate_attr3	      IN ar_rate_adjustments.attribute3%TYPE,
143  	p_exchange_rate_attr4	      IN ar_rate_adjustments.attribute4%TYPE,
144  	p_exchange_rate_attr5	      IN ar_rate_adjustments.attribute5%TYPE,
145  	p_exchange_rate_attr6	      IN ar_rate_adjustments.attribute6%TYPE,
146  	p_exchange_rate_attr7	      IN ar_rate_adjustments.attribute7%TYPE,
147  	p_exchange_rate_attr8	      IN ar_rate_adjustments.attribute8%TYPE,
148  	p_exchange_rate_attr9	      IN ar_rate_adjustments.attribute9%TYPE,
149  	p_exchange_rate_attr10	      IN ar_rate_adjustments.attribute10%TYPE,
150  	p_exchange_rate_attr11	      IN ar_rate_adjustments.attribute11%TYPE,
151  	p_exchange_rate_attr12	      IN ar_rate_adjustments.attribute12%TYPE,
152  	p_exchange_rate_attr13	      IN ar_rate_adjustments.attribute13%TYPE,
153  	p_exchange_rate_attr14	      IN ar_rate_adjustments.attribute14%TYPE,
154  	p_exchange_rate_attr15	      IN ar_rate_adjustments.attribute15%TYPE);
155 
156 PROCEDURE  get_ccids(
157 	p_receipt_method_id		IN 	NUMBER,
158 	p_remittance_bank_account_id	IN 	NUMBER,
159 	p_unidentified_ccid		OUT NOCOPY	NUMBER,
160 	p_unapplied_ccid		OUT NOCOPY	NUMBER,
161 	p_on_account_ccid		OUT NOCOPY	NUMBER,
162 	p_earned_ccid			OUT NOCOPY	NUMBER,
163 	p_unearned_ccid			OUT NOCOPY	NUMBER,
164 	p_bank_charges_ccid		OUT NOCOPY	NUMBER,
165 	p_factor_ccid			OUT NOCOPY	NUMBER,
166 	p_confirmation_ccid		OUT NOCOPY	NUMBER,
167 	p_remittance_ccid		OUT NOCOPY 	NUMBER,
168 	p_cash_ccid			OUT NOCOPY	NUMBER
169 	);
170 
171 PROCEDURE get_ps_rec(	p_cash_receipt_id 	IN NUMBER,
172 			p_ps_rec		OUT NOCOPY ar_payment_schedules%ROWTYPE);
173 
174 PROCEDURE update_dist_rec( p_crh_id		IN NUMBER,
175 			   p_source_type	IN ar_distributions.source_type%TYPE,
176 			   p_amount		IN NUMBER,
177 			   p_acctd_amount	IN NUMBER);
178 
179 END ARP_PROC_RCT_UTIL;