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 27: ar_receivable_applications.line_applied%TYPE,

23: --
24: PROCEDURE validate_args_upd_adj_rel_cols(
25: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
26: p_line_adjusted IN
27: ar_receivable_applications.line_applied%TYPE,
28: p_tax_adjusted IN
29: ar_receivable_applications.tax_applied%TYPE,
30: p_freight_adjusted IN
31: ar_receivable_applications.freight_applied%TYPE,

Line 29: ar_receivable_applications.tax_applied%TYPE,

25: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
26: p_line_adjusted IN
27: ar_receivable_applications.line_applied%TYPE,
28: p_tax_adjusted IN
29: ar_receivable_applications.tax_applied%TYPE,
30: p_freight_adjusted IN
31: ar_receivable_applications.freight_applied%TYPE,
32: p_charges_adjusted IN
33: ar_receivable_applications.receivables_charges_applied%TYPE,

Line 31: ar_receivable_applications.freight_applied%TYPE,

27: ar_receivable_applications.line_applied%TYPE,
28: p_tax_adjusted IN
29: ar_receivable_applications.tax_applied%TYPE,
30: p_freight_adjusted IN
31: ar_receivable_applications.freight_applied%TYPE,
32: p_charges_adjusted IN
33: ar_receivable_applications.receivables_charges_applied%TYPE,
34: p_amount_adjusted_pending IN
35: ar_payment_schedules.amount_adjusted_pending%TYPE,

Line 33: ar_receivable_applications.receivables_charges_applied%TYPE,

29: ar_receivable_applications.tax_applied%TYPE,
30: p_freight_adjusted IN
31: ar_receivable_applications.freight_applied%TYPE,
32: p_charges_adjusted IN
33: ar_receivable_applications.receivables_charges_applied%TYPE,
34: p_amount_adjusted_pending IN
35: ar_payment_schedules.amount_adjusted_pending%TYPE,
36: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
37: p_gl_date IN ar_payment_schedules.gl_date%TYPE );

Line 349: ar_receivable_applications.acctd_amount_applied_from%TYPE,

345: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
346: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
347: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
348: p_acctd_amount_applied OUT NOCOPY
349: ar_receivable_applications.acctd_amount_applied_from%TYPE,
350: p_ps_rec IN ar_payment_schedules%ROWTYPE,
351: p_maturity_date IN ar_payment_schedules.due_date%TYPE DEFAULT NULL,
352: p_applied_ps_class IN ar_payment_schedules.class%TYPE DEFAULT NULL ) IS -- Bug 6924942
353: --

Line 359: ar_receivable_applications.acctd_amount_applied_from%TYPE;

355: --
356: -- Variable to populate OUT NOCOPY arguments
357: --
358: l_acctd_amount_applied
359: ar_receivable_applications.acctd_amount_applied_from%TYPE;
360:
361: --Introduced For Bug # 2711860
362: -- ORASHID
363: --

Line 415: from ar_receivable_applications ra,ar_payment_schedules ps

411: -- ORASHID
412: --
413: /*Bug 6924942 get all the unapp rows with corresponding APP pair*/
414: select count(*) into l_rows_accumulate_count
415: from ar_receivable_applications ra,ar_payment_schedules ps
416: where ra.cash_receipt_id=l_ps_rec.cash_receipt_id
417: and ra.status='UNAPP'
418: and nvl(ra.include_in_accumulation,'Y')='Y'
419: and ra.payment_schedule_id=p_ps_id

Line 436: from ar_receivable_applications ra,ar_payment_schedules ps

432: IF l_rows_accumulate_count > 0 then
433: /*5473882 as in point 2 above*/
434: select nvl(sum(ra.amount_applied),0),nvl(sum(ra.acctd_amount_applied_from),0) into
435: current_amt_app,Current_acctd_amt_app
436: from ar_receivable_applications ra,ar_payment_schedules ps
437: where ra.cash_receipt_id=l_ps_rec.cash_receipt_id
438: and ra.status='UNAPP'
439: and nvl(ra.include_in_accumulation,'Y')='Y'
440: and ra.payment_schedule_id=p_ps_id

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

706: p_discount_taken_earned IN ar_payment_schedules.discount_taken_earned%TYPE,
707: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
708: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
709: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
710: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
711: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,
712: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,
713: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
714: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,

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

707: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
708: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
709: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
710: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
711: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,
712: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,
713: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
714: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
715: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,

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

708: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
709: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
710: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
711: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,
712: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,
713: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
714: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
715: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
716: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,

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

709: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
710: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
711: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,
712: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,
713: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
714: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
715: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
716: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
717: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,

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

710: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
711: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,
712: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,
713: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
714: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
715: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
716: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
717: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
718: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,

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

711: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,
712: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,
713: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
714: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
715: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
716: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
717: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
718: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
719: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,

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

712: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,
713: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
714: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
715: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
716: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
717: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
718: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
719: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
720: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,

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

713: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
714: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
715: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
716: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
717: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
718: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
719: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
720: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
721: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,

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

714: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
715: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
716: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
717: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
718: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
719: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
720: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
721: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
722: p_tax_uediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,

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

715: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
716: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
717: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
718: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
719: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
720: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
721: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
722: p_tax_uediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
723: p_freight_uediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,

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

716: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
717: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
718: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
719: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
720: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
721: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
722: p_tax_uediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
723: p_freight_uediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
724: p_charges_uediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,

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

717: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
718: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
719: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
720: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
721: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
722: p_tax_uediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
723: p_freight_uediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
724: p_charges_uediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
725: p_rule_set_id OUT NOCOPY number,

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

718: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
719: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
720: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
721: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
722: p_tax_uediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
723: p_freight_uediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
724: p_charges_uediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
725: p_rule_set_id OUT NOCOPY number,
726: p_ps_rec IN ar_payment_schedules%ROWTYPE) IS

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

719: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
720: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
721: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
722: p_tax_uediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
723: p_freight_uediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
724: p_charges_uediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
725: p_rule_set_id OUT NOCOPY number,
726: p_ps_rec IN ar_payment_schedules%ROWTYPE) IS
727:

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

720: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
721: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
722: p_tax_uediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
723: p_freight_uediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
724: p_charges_uediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
725: p_rule_set_id OUT NOCOPY number,
726: p_ps_rec IN ar_payment_schedules%ROWTYPE) IS
727:
728: l_ra_app_id NUMBER;

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

848: p_discount_taken_earned IN ar_payment_schedules.discount_taken_earned%TYPE,
849: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
850: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
851: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
852: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
853: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,
854: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,
855: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
856: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,

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

849: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
850: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
851: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
852: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
853: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,
854: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,
855: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
856: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
857: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,

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

850: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
851: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
852: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
853: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,
854: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,
855: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
856: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
857: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
858: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,

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

851: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
852: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
853: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,
854: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,
855: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
856: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
857: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
858: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
859: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,

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

852: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
853: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,
854: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,
855: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
856: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
857: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
858: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
859: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
860: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,

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

853: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,
854: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,
855: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
856: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
857: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
858: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
859: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
860: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
861: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,

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

854: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,
855: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
856: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
857: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
858: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
859: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
860: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
861: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
862: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,

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

855: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
856: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
857: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
858: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
859: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
860: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
861: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
862: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
863: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,

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

856: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
857: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
858: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
859: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
860: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
861: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
862: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
863: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
864: p_tax_uediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,

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

857: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
858: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
859: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
860: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
861: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
862: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
863: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
864: p_tax_uediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
865: p_freight_uediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,

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

858: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
859: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
860: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
861: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
862: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
863: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
864: p_tax_uediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
865: p_freight_uediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
866: p_charges_uediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,

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

859: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
860: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
861: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
862: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
863: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
864: p_tax_uediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
865: p_freight_uediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
866: p_charges_uediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
867: p_rule_set_id OUT NOCOPY number,

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

860: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
861: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
862: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
863: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
864: p_tax_uediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
865: p_freight_uediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
866: p_charges_uediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
867: p_rule_set_id OUT NOCOPY number,
868: p_ps_rec IN ar_payment_schedules%ROWTYPE,

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

861: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
862: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
863: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
864: p_tax_uediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
865: p_freight_uediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
866: p_charges_uediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
867: p_rule_set_id OUT NOCOPY number,
868: p_ps_rec IN ar_payment_schedules%ROWTYPE,
869: p_cash_receipt_id IN ar_receivable_applications_all.cash_receipt_id%TYPE,

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

862: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
863: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
864: p_tax_uediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
865: p_freight_uediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
866: p_charges_uediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
867: p_rule_set_id OUT NOCOPY number,
868: p_ps_rec IN ar_payment_schedules%ROWTYPE,
869: p_cash_receipt_id IN ar_receivable_applications_all.cash_receipt_id%TYPE,
870: p_ra_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,

Line 869: p_cash_receipt_id IN ar_receivable_applications_all.cash_receipt_id%TYPE,

865: p_freight_uediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
866: p_charges_uediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
867: p_rule_set_id OUT NOCOPY number,
868: p_ps_rec IN ar_payment_schedules%ROWTYPE,
869: p_cash_receipt_id IN ar_receivable_applications_all.cash_receipt_id%TYPE,
870: p_ra_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
871: p_gt_id OUT NOCOPY NUMBER) IS
872:
873: --

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

866: p_charges_uediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
867: p_rule_set_id OUT NOCOPY number,
868: p_ps_rec IN ar_payment_schedules%ROWTYPE,
869: p_cash_receipt_id IN ar_receivable_applications_all.cash_receipt_id%TYPE,
870: p_ra_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
871: p_gt_id OUT NOCOPY NUMBER) IS
872:
873: --
874: -- Temp variables

Line 878: l_tax_discounted ar_receivable_applications.tax_applied%TYPE:=0;

874: -- Temp variables
875: --
876: l_ps_rec ar_payment_schedules%ROWTYPE;
877: l_discount_taken_total ar_payment_schedules.amount_applied%TYPE:=0;
878: l_tax_discounted ar_receivable_applications.tax_applied%TYPE:=0;
879: l_freight_discounted ar_receivable_applications.freight_applied%TYPE:=0;
880: l_line_discounted ar_receivable_applications.line_applied%TYPE:=0;
881: l_charges_discounted
882: ar_receivable_applications.receivables_charges_applied%TYPE:=0;

Line 879: l_freight_discounted ar_receivable_applications.freight_applied%TYPE:=0;

875: --
876: l_ps_rec ar_payment_schedules%ROWTYPE;
877: l_discount_taken_total ar_payment_schedules.amount_applied%TYPE:=0;
878: l_tax_discounted ar_receivable_applications.tax_applied%TYPE:=0;
879: l_freight_discounted ar_receivable_applications.freight_applied%TYPE:=0;
880: l_line_discounted ar_receivable_applications.line_applied%TYPE:=0;
881: l_charges_discounted
882: ar_receivable_applications.receivables_charges_applied%TYPE:=0;
883: l_line_remaining ar_payment_schedules.tax_remaining%TYPE:=0;

Line 880: l_line_discounted ar_receivable_applications.line_applied%TYPE:=0;

876: l_ps_rec ar_payment_schedules%ROWTYPE;
877: l_discount_taken_total ar_payment_schedules.amount_applied%TYPE:=0;
878: l_tax_discounted ar_receivable_applications.tax_applied%TYPE:=0;
879: l_freight_discounted ar_receivable_applications.freight_applied%TYPE:=0;
880: l_line_discounted ar_receivable_applications.line_applied%TYPE:=0;
881: l_charges_discounted
882: ar_receivable_applications.receivables_charges_applied%TYPE:=0;
883: l_line_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
884: l_tax_remaining ar_payment_schedules.tax_remaining%TYPE:=0;

Line 882: ar_receivable_applications.receivables_charges_applied%TYPE:=0;

878: l_tax_discounted ar_receivable_applications.tax_applied%TYPE:=0;
879: l_freight_discounted ar_receivable_applications.freight_applied%TYPE:=0;
880: l_line_discounted ar_receivable_applications.line_applied%TYPE:=0;
881: l_charges_discounted
882: ar_receivable_applications.receivables_charges_applied%TYPE:=0;
883: l_line_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
884: l_tax_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
885: l_rec_charges_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
886: l_freight_remaining ar_payment_schedules.tax_remaining%TYPE:=0;

Line 892: l_tax_applied ar_receivable_applications.tax_applied%TYPE:=0;

888: -- Variable to populate OUT NOCOPY arguments
889: -- We need these variables, 'cos the remaining LINE, TAX, FREIGHT and CHARGES
890: -- amounts are calculated based on the applied amounts and applied discounts
891: --
892: l_tax_applied ar_receivable_applications.tax_applied%TYPE:=0;
893: l_freight_applied ar_receivable_applications.freight_applied%TYPE:=0;
894: l_line_applied ar_receivable_applications.line_applied%TYPE:=0;
895: l_charges_applied ar_receivable_applications.receivables_charges_applied%TYPE:=0;
896: l_tax_ediscounted ar_receivable_applications.tax_applied%TYPE:=0;

Line 893: l_freight_applied ar_receivable_applications.freight_applied%TYPE:=0;

889: -- We need these variables, 'cos the remaining LINE, TAX, FREIGHT and CHARGES
890: -- amounts are calculated based on the applied amounts and applied discounts
891: --
892: l_tax_applied ar_receivable_applications.tax_applied%TYPE:=0;
893: l_freight_applied ar_receivable_applications.freight_applied%TYPE:=0;
894: l_line_applied ar_receivable_applications.line_applied%TYPE:=0;
895: l_charges_applied ar_receivable_applications.receivables_charges_applied%TYPE:=0;
896: l_tax_ediscounted ar_receivable_applications.tax_applied%TYPE:=0;
897: l_freight_ediscounted ar_receivable_applications.freight_applied%TYPE:=0;

Line 894: l_line_applied ar_receivable_applications.line_applied%TYPE:=0;

890: -- amounts are calculated based on the applied amounts and applied discounts
891: --
892: l_tax_applied ar_receivable_applications.tax_applied%TYPE:=0;
893: l_freight_applied ar_receivable_applications.freight_applied%TYPE:=0;
894: l_line_applied ar_receivable_applications.line_applied%TYPE:=0;
895: l_charges_applied ar_receivable_applications.receivables_charges_applied%TYPE:=0;
896: l_tax_ediscounted ar_receivable_applications.tax_applied%TYPE:=0;
897: l_freight_ediscounted ar_receivable_applications.freight_applied%TYPE:=0;
898: l_line_ediscounted ar_receivable_applications.line_applied%TYPE:=0;

Line 895: l_charges_applied ar_receivable_applications.receivables_charges_applied%TYPE:=0;

891: --
892: l_tax_applied ar_receivable_applications.tax_applied%TYPE:=0;
893: l_freight_applied ar_receivable_applications.freight_applied%TYPE:=0;
894: l_line_applied ar_receivable_applications.line_applied%TYPE:=0;
895: l_charges_applied ar_receivable_applications.receivables_charges_applied%TYPE:=0;
896: l_tax_ediscounted ar_receivable_applications.tax_applied%TYPE:=0;
897: l_freight_ediscounted ar_receivable_applications.freight_applied%TYPE:=0;
898: l_line_ediscounted ar_receivable_applications.line_applied%TYPE:=0;
899: l_charges_ediscounted

Line 896: l_tax_ediscounted ar_receivable_applications.tax_applied%TYPE:=0;

892: l_tax_applied ar_receivable_applications.tax_applied%TYPE:=0;
893: l_freight_applied ar_receivable_applications.freight_applied%TYPE:=0;
894: l_line_applied ar_receivable_applications.line_applied%TYPE:=0;
895: l_charges_applied ar_receivable_applications.receivables_charges_applied%TYPE:=0;
896: l_tax_ediscounted ar_receivable_applications.tax_applied%TYPE:=0;
897: l_freight_ediscounted ar_receivable_applications.freight_applied%TYPE:=0;
898: l_line_ediscounted ar_receivable_applications.line_applied%TYPE:=0;
899: l_charges_ediscounted
900: ar_receivable_applications.receivables_charges_applied%TYPE:=0;

Line 897: l_freight_ediscounted ar_receivable_applications.freight_applied%TYPE:=0;

893: l_freight_applied ar_receivable_applications.freight_applied%TYPE:=0;
894: l_line_applied ar_receivable_applications.line_applied%TYPE:=0;
895: l_charges_applied ar_receivable_applications.receivables_charges_applied%TYPE:=0;
896: l_tax_ediscounted ar_receivable_applications.tax_applied%TYPE:=0;
897: l_freight_ediscounted ar_receivable_applications.freight_applied%TYPE:=0;
898: l_line_ediscounted ar_receivable_applications.line_applied%TYPE:=0;
899: l_charges_ediscounted
900: ar_receivable_applications.receivables_charges_applied%TYPE:=0;
901: l_tax_uediscounted ar_receivable_applications.tax_applied%TYPE:=0;

Line 898: l_line_ediscounted ar_receivable_applications.line_applied%TYPE:=0;

894: l_line_applied ar_receivable_applications.line_applied%TYPE:=0;
895: l_charges_applied ar_receivable_applications.receivables_charges_applied%TYPE:=0;
896: l_tax_ediscounted ar_receivable_applications.tax_applied%TYPE:=0;
897: l_freight_ediscounted ar_receivable_applications.freight_applied%TYPE:=0;
898: l_line_ediscounted ar_receivable_applications.line_applied%TYPE:=0;
899: l_charges_ediscounted
900: ar_receivable_applications.receivables_charges_applied%TYPE:=0;
901: l_tax_uediscounted ar_receivable_applications.tax_applied%TYPE:=0;
902: l_freight_uediscounted ar_receivable_applications.freight_applied%TYPE:=0;

Line 900: ar_receivable_applications.receivables_charges_applied%TYPE:=0;

896: l_tax_ediscounted ar_receivable_applications.tax_applied%TYPE:=0;
897: l_freight_ediscounted ar_receivable_applications.freight_applied%TYPE:=0;
898: l_line_ediscounted ar_receivable_applications.line_applied%TYPE:=0;
899: l_charges_ediscounted
900: ar_receivable_applications.receivables_charges_applied%TYPE:=0;
901: l_tax_uediscounted ar_receivable_applications.tax_applied%TYPE:=0;
902: l_freight_uediscounted ar_receivable_applications.freight_applied%TYPE:=0;
903: l_line_uediscounted ar_receivable_applications.line_applied%TYPE:=0;
904: l_charges_uediscounted

Line 901: l_tax_uediscounted ar_receivable_applications.tax_applied%TYPE:=0;

897: l_freight_ediscounted ar_receivable_applications.freight_applied%TYPE:=0;
898: l_line_ediscounted ar_receivable_applications.line_applied%TYPE:=0;
899: l_charges_ediscounted
900: ar_receivable_applications.receivables_charges_applied%TYPE:=0;
901: l_tax_uediscounted ar_receivable_applications.tax_applied%TYPE:=0;
902: l_freight_uediscounted ar_receivable_applications.freight_applied%TYPE:=0;
903: l_line_uediscounted ar_receivable_applications.line_applied%TYPE:=0;
904: l_charges_uediscounted
905: ar_receivable_applications.receivables_charges_applied%TYPE:=0;

Line 902: l_freight_uediscounted ar_receivable_applications.freight_applied%TYPE:=0;

898: l_line_ediscounted ar_receivable_applications.line_applied%TYPE:=0;
899: l_charges_ediscounted
900: ar_receivable_applications.receivables_charges_applied%TYPE:=0;
901: l_tax_uediscounted ar_receivable_applications.tax_applied%TYPE:=0;
902: l_freight_uediscounted ar_receivable_applications.freight_applied%TYPE:=0;
903: l_line_uediscounted ar_receivable_applications.line_applied%TYPE:=0;
904: l_charges_uediscounted
905: ar_receivable_applications.receivables_charges_applied%TYPE:=0;
906: --

Line 903: l_line_uediscounted ar_receivable_applications.line_applied%TYPE:=0;

899: l_charges_ediscounted
900: ar_receivable_applications.receivables_charges_applied%TYPE:=0;
901: l_tax_uediscounted ar_receivable_applications.tax_applied%TYPE:=0;
902: l_freight_uediscounted ar_receivable_applications.freight_applied%TYPE:=0;
903: l_line_uediscounted ar_receivable_applications.line_applied%TYPE:=0;
904: l_charges_uediscounted
905: ar_receivable_applications.receivables_charges_applied%TYPE:=0;
906: --
907: l_acctd_amount_applied

Line 905: ar_receivable_applications.receivables_charges_applied%TYPE:=0;

901: l_tax_uediscounted ar_receivable_applications.tax_applied%TYPE:=0;
902: l_freight_uediscounted ar_receivable_applications.freight_applied%TYPE:=0;
903: l_line_uediscounted ar_receivable_applications.line_applied%TYPE:=0;
904: l_charges_uediscounted
905: ar_receivable_applications.receivables_charges_applied%TYPE:=0;
906: --
907: l_acctd_amount_applied
908: ar_receivable_applications.acctd_amount_applied_from%TYPE:=0;
909: l_acctd_earned_discount_taken

Line 908: ar_receivable_applications.acctd_amount_applied_from%TYPE:=0;

904: l_charges_uediscounted
905: ar_receivable_applications.receivables_charges_applied%TYPE:=0;
906: --
907: l_acctd_amount_applied
908: ar_receivable_applications.acctd_amount_applied_from%TYPE:=0;
909: l_acctd_earned_discount_taken
910: ar_receivable_applications.earned_discount_taken%TYPE:=0;
911: l_acctd_unearned_disc_taken
912: ar_receivable_applications.acctd_unearned_discount_taken%TYPE:=0;

Line 910: ar_receivable_applications.earned_discount_taken%TYPE:=0;

906: --
907: l_acctd_amount_applied
908: ar_receivable_applications.acctd_amount_applied_from%TYPE:=0;
909: l_acctd_earned_discount_taken
910: ar_receivable_applications.earned_discount_taken%TYPE:=0;
911: l_acctd_unearned_disc_taken
912: ar_receivable_applications.acctd_unearned_discount_taken%TYPE:=0;
913: --
914:

Line 912: ar_receivable_applications.acctd_unearned_discount_taken%TYPE:=0;

908: ar_receivable_applications.acctd_amount_applied_from%TYPE:=0;
909: l_acctd_earned_discount_taken
910: ar_receivable_applications.earned_discount_taken%TYPE:=0;
911: l_acctd_unearned_disc_taken
912: ar_receivable_applications.acctd_unearned_discount_taken%TYPE:=0;
913: --
914:
915: --Introduced For Bug # 2711860
916: -- ORASHID

Line 1484: p_line_applied IN ar_receivable_applications.line_applied%TYPE,

1480: +===========================================================================*/
1481: PROCEDURE update_cm_related_columns(
1482: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
1483: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
1484: p_line_applied IN ar_receivable_applications.line_applied%TYPE,
1485: p_tax_applied IN ar_receivable_applications.tax_applied%TYPE,
1486: p_freight_applied IN
1487: ar_receivable_applications.freight_applied%TYPE,
1488: p_charges_applied IN

Line 1485: p_tax_applied IN ar_receivable_applications.tax_applied%TYPE,

1481: PROCEDURE update_cm_related_columns(
1482: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
1483: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
1484: p_line_applied IN ar_receivable_applications.line_applied%TYPE,
1485: p_tax_applied IN ar_receivable_applications.tax_applied%TYPE,
1486: p_freight_applied IN
1487: ar_receivable_applications.freight_applied%TYPE,
1488: p_charges_applied IN
1489: ar_receivable_applications.receivables_charges_applied%TYPE,

Line 1487: ar_receivable_applications.freight_applied%TYPE,

1483: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
1484: p_line_applied IN ar_receivable_applications.line_applied%TYPE,
1485: p_tax_applied IN ar_receivable_applications.tax_applied%TYPE,
1486: p_freight_applied IN
1487: ar_receivable_applications.freight_applied%TYPE,
1488: p_charges_applied IN
1489: ar_receivable_applications.receivables_charges_applied%TYPE,
1490: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
1491: p_gl_date IN ar_payment_schedules.gl_date%TYPE,

Line 1489: ar_receivable_applications.receivables_charges_applied%TYPE,

1485: p_tax_applied IN ar_receivable_applications.tax_applied%TYPE,
1486: p_freight_applied IN
1487: ar_receivable_applications.freight_applied%TYPE,
1488: p_charges_applied IN
1489: ar_receivable_applications.receivables_charges_applied%TYPE,
1490: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
1491: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
1492: p_acctd_amount_applied OUT NOCOPY
1493: ar_receivable_applications.acctd_amount_applied_to%TYPE,

Line 1493: ar_receivable_applications.acctd_amount_applied_to%TYPE,

1489: ar_receivable_applications.receivables_charges_applied%TYPE,
1490: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
1491: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
1492: p_acctd_amount_applied OUT NOCOPY
1493: ar_receivable_applications.acctd_amount_applied_to%TYPE,
1494: p_ps_rec IN ar_payment_schedules%ROWTYPE,
1495: p_update_credit_flag IN VARCHAR2 ) IS
1496: --
1497: l_ps_rec ar_payment_schedules%ROWTYPE;

Line 1502: ar_receivable_applications.acctd_amount_applied_from%TYPE;

1498: --
1499: -- Variable to populate OUT NOCOPY arguments
1500: --
1501: l_acctd_amount_applied
1502: ar_receivable_applications.acctd_amount_applied_from%TYPE;
1503:
1504: --Introduced For Bug # 2711860
1505: -- ORASHID
1506: --

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

1684: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
1685: p_type IN ar_adjustments.type%TYPE,
1686: p_amount_adjusted IN ar_payment_schedules.amount_adjusted%TYPE,
1687: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,
1688: p_line_adjusted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
1689: p_tax_adjusted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
1690: p_freight_adjusted IN OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
1691: p_charges_adjusted IN OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
1692: p_apply_date IN ar_payment_schedules.gl_date%TYPE,

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

1685: p_type IN ar_adjustments.type%TYPE,
1686: p_amount_adjusted IN ar_payment_schedules.amount_adjusted%TYPE,
1687: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,
1688: p_line_adjusted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
1689: p_tax_adjusted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
1690: p_freight_adjusted IN OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
1691: p_charges_adjusted IN OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
1692: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
1693: p_gl_date IN ar_payment_schedules.gl_date%TYPE,

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

1686: p_amount_adjusted IN ar_payment_schedules.amount_adjusted%TYPE,
1687: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,
1688: p_line_adjusted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
1689: p_tax_adjusted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
1690: p_freight_adjusted IN OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
1691: p_charges_adjusted IN OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
1692: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
1693: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
1694: p_acctd_amount_adjusted OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,

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

1687: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,
1688: p_line_adjusted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
1689: p_tax_adjusted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
1690: p_freight_adjusted IN OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
1691: p_charges_adjusted IN OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
1692: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
1693: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
1694: p_acctd_amount_adjusted OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
1695: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE) IS

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

1690: p_freight_adjusted IN OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
1691: p_charges_adjusted IN OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
1692: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
1693: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
1694: p_acctd_amount_adjusted OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
1695: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE) IS
1696: --
1697: -- deleted 'DEFAULT NULL' for p_ps_rec Rowtype attribute -bug460979 for Oracle8
1698:

Line 1716: ar_receivable_applications.acctd_amount_applied_from%TYPE;

1712: --
1713: -- Variable to populate OUT NOCOPY arguments
1714: --
1715: l_acctd_amount_adjusted
1716: ar_receivable_applications.acctd_amount_applied_from%TYPE;
1717:
1718: rem_adj_amt NUMBER;
1719:
1720: BEGIN

Line 2079: p_line_adjusted IN ar_receivable_applications.line_applied%TYPE,

2075: +===========================================================================*/
2076:
2077: PROCEDURE update_adj_related_columns(
2078: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
2079: p_line_adjusted IN ar_receivable_applications.line_applied%TYPE,
2080: p_tax_adjusted IN ar_receivable_applications.tax_applied%TYPE,
2081: p_freight_adjusted IN ar_receivable_applications.freight_applied%TYPE,
2082: p_charges_adjusted IN ar_receivable_applications.receivables_charges_applied%TYPE,
2083: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,

Line 2080: p_tax_adjusted IN ar_receivable_applications.tax_applied%TYPE,

2076:
2077: PROCEDURE update_adj_related_columns(
2078: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
2079: p_line_adjusted IN ar_receivable_applications.line_applied%TYPE,
2080: p_tax_adjusted IN ar_receivable_applications.tax_applied%TYPE,
2081: p_freight_adjusted IN ar_receivable_applications.freight_applied%TYPE,
2082: p_charges_adjusted IN ar_receivable_applications.receivables_charges_applied%TYPE,
2083: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,
2084: p_apply_date IN ar_payment_schedules.gl_date%TYPE,

Line 2081: p_freight_adjusted IN ar_receivable_applications.freight_applied%TYPE,

2077: PROCEDURE update_adj_related_columns(
2078: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
2079: p_line_adjusted IN ar_receivable_applications.line_applied%TYPE,
2080: p_tax_adjusted IN ar_receivable_applications.tax_applied%TYPE,
2081: p_freight_adjusted IN ar_receivable_applications.freight_applied%TYPE,
2082: p_charges_adjusted IN ar_receivable_applications.receivables_charges_applied%TYPE,
2083: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,
2084: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
2085: p_gl_date IN ar_payment_schedules.gl_date%TYPE,

Line 2082: p_charges_adjusted IN ar_receivable_applications.receivables_charges_applied%TYPE,

2078: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
2079: p_line_adjusted IN ar_receivable_applications.line_applied%TYPE,
2080: p_tax_adjusted IN ar_receivable_applications.tax_applied%TYPE,
2081: p_freight_adjusted IN ar_receivable_applications.freight_applied%TYPE,
2082: p_charges_adjusted IN ar_receivable_applications.receivables_charges_applied%TYPE,
2083: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,
2084: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
2085: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
2086: p_acctd_amount_adjusted OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,

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

2082: p_charges_adjusted IN ar_receivable_applications.receivables_charges_applied%TYPE,
2083: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,
2084: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
2085: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
2086: p_acctd_amount_adjusted OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
2087: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE) IS
2088: --
2089: -- deleted 'DEFAULT NULL' for p_ps_rec Rowtype attribute -bug460979 for Oracle8
2090:

Line 2097: l_acctd_amount_adjusted ar_receivable_applications.acctd_amount_applied_from%TYPE;

2093:
2094: --
2095: -- Variable to populate OUT NOCOPY arguments
2096: --
2097: l_acctd_amount_adjusted ar_receivable_applications.acctd_amount_applied_from%TYPE;
2098:
2099:
2100: --Introduced For Bug # 2711860
2101: -- ORASHID

Line 2262: ar_receivable_applications.line_applied%TYPE,

2258: +===========================================================================*/
2259: PROCEDURE validate_args_upd_adj_rel_cols(
2260: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
2261: p_line_adjusted IN
2262: ar_receivable_applications.line_applied%TYPE,
2263: p_tax_adjusted IN
2264: ar_receivable_applications.tax_applied%TYPE,
2265: p_freight_adjusted IN
2266: ar_receivable_applications.freight_applied%TYPE,

Line 2264: ar_receivable_applications.tax_applied%TYPE,

2260: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
2261: p_line_adjusted IN
2262: ar_receivable_applications.line_applied%TYPE,
2263: p_tax_adjusted IN
2264: ar_receivable_applications.tax_applied%TYPE,
2265: p_freight_adjusted IN
2266: ar_receivable_applications.freight_applied%TYPE,
2267: p_charges_adjusted IN
2268: ar_receivable_applications.receivables_charges_applied%TYPE,

Line 2266: ar_receivable_applications.freight_applied%TYPE,

2262: ar_receivable_applications.line_applied%TYPE,
2263: p_tax_adjusted IN
2264: ar_receivable_applications.tax_applied%TYPE,
2265: p_freight_adjusted IN
2266: ar_receivable_applications.freight_applied%TYPE,
2267: p_charges_adjusted IN
2268: ar_receivable_applications.receivables_charges_applied%TYPE,
2269: p_amount_adjusted_pending IN
2270: ar_payment_schedules.amount_adjusted_pending%TYPE,

Line 2268: ar_receivable_applications.receivables_charges_applied%TYPE,

2264: ar_receivable_applications.tax_applied%TYPE,
2265: p_freight_adjusted IN
2266: ar_receivable_applications.freight_applied%TYPE,
2267: p_charges_adjusted IN
2268: ar_receivable_applications.receivables_charges_applied%TYPE,
2269: p_amount_adjusted_pending IN
2270: ar_payment_schedules.amount_adjusted_pending%TYPE,
2271: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
2272: p_gl_date IN ar_payment_schedules.gl_date%TYPE ) IS

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

2391: | |
2392: | DESCRIPTION |
2393: | Determines gl_date_closed and actual_date_closed for a payment |
2394: | schedule. For each of the two, it returns the greatest date from |
2395: | ar_receivable_applications, ar_adjustments, and the input current |
2396: | date. If it finds no values for a date, a null string is returned. |
2397: | |
2398: | NOTE: This function does not correctly handle applications for future|
2399: | items or future cash receipts. If an application or adjustment that |

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

2401: | gl_date/trx_date or the cash receipt's gl_date/deposit_date, then the|
2402: | gl_date_closed/actual_date_closed should be the greatest dates - the |
2403: | ones from the item or cash receipt. The dates returned by armclps |
2404: | will be less than the correct ones because this function selects |
2405: | only from ar_receivable_applications, ar_adjustments and the input |
2406: | "current" dates.
2407: | |
2408: | |
2409: | SCOPE - PUBLIC |

Line 2417: | ar_receivable_applications.gl_date, and |

2413: | p_gl_reversal_date - gl_date of current uncommitted |
2414: | transaction |
2415: | p_reversal_date - apply date of current uncommitted xtion |
2416: | p_gl_date_closed - greatest of ar_adjustments.gl_date, |
2417: | ar_receivable_applications.gl_date, and |
2418: | current_gl_date. |
2419: | p_actual_date_closed - (output) greatest of |
2420: | ar_adjustments.apply_date, |
2421: | ar_receivable_applications.apply_date, |

Line 2421: | ar_receivable_applications.apply_date, |

2417: | ar_receivable_applications.gl_date, and |
2418: | current_gl_date. |
2419: | p_actual_date_closed - (output) greatest of |
2420: | ar_adjustments.apply_date, |
2421: | ar_receivable_applications.apply_date, |
2422: | and current_apply_date. |
2423: | |
2424: | MODIFICATION HISTORY - |
2425: | |

Line 2428: | from ar_receivable_applications. Now check|

2424: | MODIFICATION HISTORY - |
2425: | |
2426: | 08/18/98 Sushama Borde Fixed bug 705906. Modified select statment|
2427: | that gets the max gl_date and apply_date |
2428: | from ar_receivable_applications. Now check|
2429: | s the reversal_gl_date, while selecting |
2430: | apply_date, and excludes applications that|
2431: | have been reversed.
2432: | 07/04/04 S.A.P.N.Sarma The actual_date_closed and gl_date_Closed |

Line 2456: -- Get max dates from ar_receivable_applications

2452: IF PG_DEBUG in ('Y', 'C') THEN
2453: arp_debug.debug( '>>>>>>> arp_util.get_closed_dates' );
2454: END IF;
2455: --
2456: -- Get max dates from ar_receivable_applications
2457: --
2458:
2459: IF PG_DEBUG in ('Y', 'C') THEN
2460: arp_debug.debug('get_closed_dates: ' || '>>>P_PS_ID: ' || p_ps_id );

Line 2471: FROM ar_receivable_applications

2467: -- application reversals while
2468: -- getting the max apply_date.
2469: INTO l_gl_app,
2470: l_act_app
2471: FROM ar_receivable_applications
2472: WHERE ( applied_payment_schedule_id = p_ps_id -- "Trx" that was applied
2473:
2474: or payment_schedule_id = p_ps_id ) -- "Payment" or "Credit Memo" being
2475: -- applied.