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 64: ar_receivable_applications.acctd_amount_applied_from%TYPE,

60: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
61: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
62: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
63: p_acctd_amount_applied OUT NOCOPY
64: ar_receivable_applications.acctd_amount_applied_from%TYPE,
65: p_ps_rec IN ar_payment_schedules%ROWTYPE,
66: p_maturity_date IN ar_payment_schedules.due_date%TYPE DEFAULT NULL,
67: p_applied_ps_class IN ar_payment_schedules.class%TYPE DEFAULT NULL); -- For Bug 6924942
68: --

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 253: p_cash_receipt_id IN ar_receivable_applications_all.cash_receipt_id%TYPE,

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

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

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

Line 307: p_line_applied IN ar_receivable_applications.line_applied%TYPE,

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

Line 308: p_tax_applied IN ar_receivable_applications.tax_applied%TYPE,

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

Line 310: ar_receivable_applications.freight_applied%TYPE,

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

Line 312: ar_receivable_applications.receivables_charges_applied%TYPE,

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

Line 316: ar_receivable_applications.acctd_amount_applied_to%TYPE,

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

Line 352: p_line_adjusted IN ar_receivable_applications.line_applied%TYPE,

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

Line 353: p_tax_adjusted IN ar_receivable_applications.tax_applied%TYPE,

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

Line 354: p_freight_adjusted IN ar_receivable_applications.freight_applied%TYPE,

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

Line 355: p_charges_adjusted IN ar_receivable_applications.receivables_charges_applied%TYPE,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 452: | ar_receivable_applications.gl_date, and |

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

Line 456: | ar_receivable_applications.apply_date, |

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