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.

APPS.ARP_PS_UTIL dependencies on AR_RECEIVABLE_APPLICATIONS

Line 63: ar_receivable_applications.acctd_amount_applied_from%TYPE,

59: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
60: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
61: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
62: p_acctd_amount_applied OUT NOCOPY
63: ar_receivable_applications.acctd_amount_applied_from%TYPE,
64: p_ps_rec IN ar_payment_schedules%ROWTYPE);
65: --
66: -- deleted 'DEFAULT NULL' for p_ps_rec Rowtype attribute -bug460979 for Oracle8
67: --

Line 143: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,

139: p_discount_taken_earned IN ar_payment_schedules.discount_taken_earned%TYPE,
140: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
141: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
142: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
143: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
144: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,
145: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,
146: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
147: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,

Line 144: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,

140: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
141: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
142: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
143: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
144: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,
145: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,
146: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
147: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
148: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,

Line 145: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,

141: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
142: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
143: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
144: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,
145: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,
146: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
147: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
148: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
149: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,

Line 146: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,

142: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
143: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
144: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,
145: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,
146: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
147: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
148: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
149: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
150: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,

Line 147: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,

143: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
144: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,
145: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,
146: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
147: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
148: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
149: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
150: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
151: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,

Line 148: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,

144: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,
145: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,
146: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
147: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
148: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
149: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
150: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
151: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
152: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,

Line 149: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,

145: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,
146: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
147: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
148: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
149: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
150: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
151: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
152: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
153: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,

Line 150: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,

146: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
147: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
148: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
149: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
150: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
151: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
152: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
153: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
154: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,

Line 151: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,

147: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
148: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
149: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
150: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
151: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
152: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
153: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
154: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
155: p_tax_uediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,

Line 152: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,

148: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
149: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
150: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
151: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
152: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
153: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
154: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
155: p_tax_uediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
156: p_freight_uediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,

Line 153: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,

149: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
150: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
151: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
152: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
153: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
154: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
155: p_tax_uediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
156: p_freight_uediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
157: p_charges_uediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,

Line 154: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,

150: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
151: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
152: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
153: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
154: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
155: p_tax_uediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
156: p_freight_uediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
157: p_charges_uediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
158: p_rule_set_id OUT NOCOPY number,

Line 155: p_tax_uediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,

151: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
152: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
153: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
154: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
155: p_tax_uediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
156: p_freight_uediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
157: p_charges_uediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
158: p_rule_set_id OUT NOCOPY number,
159: p_ps_rec IN ar_payment_schedules%ROWTYPE);

Line 156: p_freight_uediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,

152: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
153: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
154: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
155: p_tax_uediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
156: p_freight_uediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
157: p_charges_uediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
158: p_rule_set_id OUT NOCOPY number,
159: p_ps_rec IN ar_payment_schedules%ROWTYPE);
160:

Line 157: p_charges_uediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,

153: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
154: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
155: p_tax_uediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
156: p_freight_uediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
157: p_charges_uediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
158: p_rule_set_id OUT NOCOPY number,
159: p_ps_rec IN ar_payment_schedules%ROWTYPE);
160:
161: /*===========================================================================+

Line 233: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,

229: p_discount_taken_earned IN ar_payment_schedules.discount_taken_earned%TYPE,
230: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
231: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
232: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
233: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
234: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,
235: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,
236: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
237: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,

Line 234: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,

230: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
231: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
232: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
233: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
234: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,
235: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,
236: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
237: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
238: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,

Line 235: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,

231: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
232: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
233: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
234: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,
235: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,
236: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
237: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
238: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
239: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,

Line 236: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,

232: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
233: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
234: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,
235: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,
236: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
237: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
238: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
239: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
240: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,

Line 237: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,

233: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
234: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,
235: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,
236: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
237: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
238: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
239: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
240: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
241: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,

Line 238: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,

234: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,
235: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,
236: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
237: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
238: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
239: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
240: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
241: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
242: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,

Line 239: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,

235: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,
236: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
237: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
238: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
239: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
240: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
241: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
242: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
243: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,

Line 240: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,

236: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
237: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
238: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
239: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
240: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
241: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
242: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
243: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
244: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,

Line 241: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,

237: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
238: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
239: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
240: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
241: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
242: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
243: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
244: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
245: p_tax_uediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,

Line 242: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,

238: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
239: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
240: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
241: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
242: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
243: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
244: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
245: p_tax_uediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
246: p_freight_uediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,

Line 243: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,

239: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
240: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
241: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
242: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
243: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
244: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
245: p_tax_uediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
246: p_freight_uediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
247: p_charges_uediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,

Line 244: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,

240: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
241: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
242: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
243: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
244: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
245: p_tax_uediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
246: p_freight_uediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
247: p_charges_uediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
248: p_rule_set_id OUT NOCOPY number,

Line 245: p_tax_uediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,

241: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
242: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
243: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
244: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
245: p_tax_uediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
246: p_freight_uediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
247: p_charges_uediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
248: p_rule_set_id OUT NOCOPY number,
249: p_ps_rec IN ar_payment_schedules%ROWTYPE,

Line 246: p_freight_uediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,

242: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
243: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
244: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
245: p_tax_uediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
246: p_freight_uediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
247: p_charges_uediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
248: p_rule_set_id OUT NOCOPY number,
249: p_ps_rec IN ar_payment_schedules%ROWTYPE,
250: p_cash_receipt_id IN ar_receivable_applications_all.cash_receipt_id%TYPE,

Line 247: p_charges_uediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,

243: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
244: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
245: p_tax_uediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
246: p_freight_uediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
247: p_charges_uediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
248: p_rule_set_id OUT NOCOPY number,
249: p_ps_rec IN ar_payment_schedules%ROWTYPE,
250: p_cash_receipt_id IN ar_receivable_applications_all.cash_receipt_id%TYPE,
251: p_ra_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,

Line 250: p_cash_receipt_id IN ar_receivable_applications_all.cash_receipt_id%TYPE,

246: p_freight_uediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
247: p_charges_uediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
248: p_rule_set_id OUT NOCOPY number,
249: p_ps_rec IN ar_payment_schedules%ROWTYPE,
250: p_cash_receipt_id IN ar_receivable_applications_all.cash_receipt_id%TYPE,
251: p_ra_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
252: p_gt_id OUT NOCOPY NUMBER);
253:
254:

Line 251: p_ra_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,

247: p_charges_uediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
248: p_rule_set_id OUT NOCOPY number,
249: p_ps_rec IN ar_payment_schedules%ROWTYPE,
250: p_cash_receipt_id IN ar_receivable_applications_all.cash_receipt_id%TYPE,
251: p_ra_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
252: p_gt_id OUT NOCOPY NUMBER);
253:
254:
255: --

Line 304: p_line_applied IN ar_receivable_applications.line_applied%TYPE,

300: +===========================================================================*/
301: PROCEDURE update_cm_related_columns(
302: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
303: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
304: p_line_applied IN ar_receivable_applications.line_applied%TYPE,
305: p_tax_applied IN ar_receivable_applications.tax_applied%TYPE,
306: p_freight_applied IN
307: ar_receivable_applications.freight_applied%TYPE,
308: p_charges_applied IN

Line 305: p_tax_applied IN ar_receivable_applications.tax_applied%TYPE,

301: PROCEDURE update_cm_related_columns(
302: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
303: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
304: p_line_applied IN ar_receivable_applications.line_applied%TYPE,
305: p_tax_applied IN ar_receivable_applications.tax_applied%TYPE,
306: p_freight_applied IN
307: ar_receivable_applications.freight_applied%TYPE,
308: p_charges_applied IN
309: ar_receivable_applications.receivables_charges_applied%TYPE,

Line 307: ar_receivable_applications.freight_applied%TYPE,

303: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
304: p_line_applied IN ar_receivable_applications.line_applied%TYPE,
305: p_tax_applied IN ar_receivable_applications.tax_applied%TYPE,
306: p_freight_applied IN
307: ar_receivable_applications.freight_applied%TYPE,
308: p_charges_applied IN
309: ar_receivable_applications.receivables_charges_applied%TYPE,
310: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
311: p_gl_date IN ar_payment_schedules.gl_date%TYPE,

Line 309: ar_receivable_applications.receivables_charges_applied%TYPE,

305: p_tax_applied IN ar_receivable_applications.tax_applied%TYPE,
306: p_freight_applied IN
307: ar_receivable_applications.freight_applied%TYPE,
308: p_charges_applied IN
309: ar_receivable_applications.receivables_charges_applied%TYPE,
310: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
311: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
312: p_acctd_amount_applied OUT NOCOPY
313: ar_receivable_applications.acctd_amount_applied_to%TYPE,

Line 313: ar_receivable_applications.acctd_amount_applied_to%TYPE,

309: ar_receivable_applications.receivables_charges_applied%TYPE,
310: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
311: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
312: p_acctd_amount_applied OUT NOCOPY
313: ar_receivable_applications.acctd_amount_applied_to%TYPE,
314: p_ps_rec IN ar_payment_schedules%ROWTYPE,
315: p_update_credit_flag IN VARCHAR2 DEFAULT NULL );
316: --
317: /*===========================================================================+

Line 349: p_line_adjusted IN ar_receivable_applications.line_applied%TYPE,

345: | |
346: +===========================================================================*/
347: PROCEDURE update_adj_related_columns(
348: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
349: p_line_adjusted IN ar_receivable_applications.line_applied%TYPE,
350: p_tax_adjusted IN ar_receivable_applications.tax_applied%TYPE,
351: p_freight_adjusted IN ar_receivable_applications.freight_applied%TYPE,
352: p_charges_adjusted IN ar_receivable_applications.receivables_charges_applied%TYPE,
353: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,

Line 350: p_tax_adjusted IN ar_receivable_applications.tax_applied%TYPE,

346: +===========================================================================*/
347: PROCEDURE update_adj_related_columns(
348: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
349: p_line_adjusted IN ar_receivable_applications.line_applied%TYPE,
350: p_tax_adjusted IN ar_receivable_applications.tax_applied%TYPE,
351: p_freight_adjusted IN ar_receivable_applications.freight_applied%TYPE,
352: p_charges_adjusted IN ar_receivable_applications.receivables_charges_applied%TYPE,
353: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,
354: p_apply_date IN ar_payment_schedules.gl_date%TYPE,

Line 351: p_freight_adjusted IN ar_receivable_applications.freight_applied%TYPE,

347: PROCEDURE update_adj_related_columns(
348: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
349: p_line_adjusted IN ar_receivable_applications.line_applied%TYPE,
350: p_tax_adjusted IN ar_receivable_applications.tax_applied%TYPE,
351: p_freight_adjusted IN ar_receivable_applications.freight_applied%TYPE,
352: p_charges_adjusted IN ar_receivable_applications.receivables_charges_applied%TYPE,
353: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,
354: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
355: p_gl_date IN ar_payment_schedules.gl_date%TYPE,

Line 352: p_charges_adjusted IN ar_receivable_applications.receivables_charges_applied%TYPE,

348: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
349: p_line_adjusted IN ar_receivable_applications.line_applied%TYPE,
350: p_tax_adjusted IN ar_receivable_applications.tax_applied%TYPE,
351: p_freight_adjusted IN ar_receivable_applications.freight_applied%TYPE,
352: p_charges_adjusted IN ar_receivable_applications.receivables_charges_applied%TYPE,
353: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,
354: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
355: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
356: p_acctd_amount_adjusted OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,

Line 356: p_acctd_amount_adjusted OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,

352: p_charges_adjusted IN ar_receivable_applications.receivables_charges_applied%TYPE,
353: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,
354: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
355: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
356: p_acctd_amount_adjusted OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
357: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE);
358:
359: -- deleted 'DEFAULT NULL' for p_ps_rec Rowtype attribute -bug460979 for Oracle8
360: --

Line 409: p_line_adjusted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,

405: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
406: p_type IN ar_adjustments.type%TYPE,
407: p_amount_adjusted IN ar_payment_schedules.amount_adjusted%TYPE,
408: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,
409: p_line_adjusted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
410: p_tax_adjusted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
411: p_freight_adjusted IN OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
412: p_charges_adjusted IN OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
413: p_apply_date IN ar_payment_schedules.gl_date%TYPE,

Line 410: p_tax_adjusted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,

406: p_type IN ar_adjustments.type%TYPE,
407: p_amount_adjusted IN ar_payment_schedules.amount_adjusted%TYPE,
408: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,
409: p_line_adjusted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
410: p_tax_adjusted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
411: p_freight_adjusted IN OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
412: p_charges_adjusted IN OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
413: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
414: p_gl_date IN ar_payment_schedules.gl_date%TYPE,

Line 411: p_freight_adjusted IN OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,

407: p_amount_adjusted IN ar_payment_schedules.amount_adjusted%TYPE,
408: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,
409: p_line_adjusted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
410: p_tax_adjusted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
411: p_freight_adjusted IN OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
412: p_charges_adjusted IN OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
413: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
414: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
415: p_acctd_amount_adjusted OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,

Line 412: p_charges_adjusted IN OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,

408: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,
409: p_line_adjusted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
410: p_tax_adjusted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
411: p_freight_adjusted IN OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
412: p_charges_adjusted IN OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
413: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
414: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
415: p_acctd_amount_adjusted OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
416: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE);

Line 415: p_acctd_amount_adjusted OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,

411: p_freight_adjusted IN OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
412: p_charges_adjusted IN OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
413: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
414: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
415: p_acctd_amount_adjusted OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
416: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE);
417: --
418: -- deleted 'DEFAULT NULL' for p_ps_rec Rowtype attribute -bug460979 for Oracle8
419:

Line 427: | ar_receivable_applications, ar_adjustments, and the input current |

423: | |
424: | DESCRIPTION |
425: | Determines gl_date_closed and actual_date_closed for a payment |
426: | schedule. For each of the two, it returns the greatest date from |
427: | ar_receivable_applications, ar_adjustments, and the input current |
428: | date. If it finds no values for a date, a null string is returned. |
429: | |
430: | NOTE: This function does not correctly handle applications for future|
431: | items or future cash receipts. If an application or adjustment that |

Line 437: | only from ar_receivable_applications, ar_adjustments and the input |

433: | gl_date/trx_date or the cash receipt's gl_date/deposit_date, then the|
434: | gl_date_closed/actual_date_closed should be the greatest dates - the |
435: | ones from the item or cash receipt. The dates returned by armclps |
436: | will be less than the correct ones because this function selects |
437: | only from ar_receivable_applications, ar_adjustments and the input |
438: | "current" dates.
439: | |
440: | |
441: | SCOPE - PUBLIC |

Line 449: | ar_receivable_applications.gl_date, and |

445: | p_gl_reversal_date - gl_date of current uncommitted |
446: | transaction |
447: | p_reversal_date - apply date of current uncommitted xtion |
448: | p_gl_date_closed - greatest of ar_adjustments.gl_date, |
449: | ar_receivable_applications.gl_date, and |
450: | current_gl_date. |
451: | p_actual_date_closed - (output) greatest of |
452: | ar_adjustments.apply_date, |
453: | ar_receivable_applications.apply_date, |

Line 453: | ar_receivable_applications.apply_date, |

449: | ar_receivable_applications.gl_date, and |
450: | current_gl_date. |
451: | p_actual_date_closed - (output) greatest of |
452: | ar_adjustments.apply_date, |
453: | ar_receivable_applications.apply_date, |
454: | and current_apply_date. |
455: | |
456: +===========================================================================*/
457: PROCEDURE get_closed_dates( p_ps_id IN NUMBER,