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 ) IS
351: --
352: l_ps_rec ar_payment_schedules%ROWTYPE;
353: --

Line 357: ar_receivable_applications.acctd_amount_applied_from%TYPE;

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

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

601: p_discount_taken_earned IN ar_payment_schedules.discount_taken_earned%TYPE,
602: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
603: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
604: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
605: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
606: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,
607: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,
608: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
609: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,

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

602: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
603: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
604: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
605: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
606: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,
607: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,
608: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
609: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
610: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,

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

603: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
604: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
605: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
606: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,
607: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,
608: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
609: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
610: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
611: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,

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

604: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
605: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
606: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,
607: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,
608: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
609: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
610: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
611: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
612: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,

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

605: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
606: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,
607: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,
608: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
609: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
610: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
611: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
612: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
613: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,

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

606: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,
607: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,
608: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
609: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
610: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
611: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
612: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
613: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
614: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,

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

607: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,
608: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
609: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
610: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
611: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
612: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
613: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
614: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
615: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,

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

608: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
609: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
610: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
611: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
612: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
613: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
614: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
615: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
616: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,

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

609: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
610: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
611: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
612: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
613: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
614: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
615: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
616: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
617: p_tax_uediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,

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

610: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
611: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
612: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
613: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
614: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
615: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
616: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
617: p_tax_uediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
618: p_freight_uediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,

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

611: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
612: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
613: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
614: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
615: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
616: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
617: p_tax_uediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
618: p_freight_uediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
619: p_charges_uediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,

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

612: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
613: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
614: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
615: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
616: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
617: p_tax_uediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
618: p_freight_uediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
619: p_charges_uediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
620: p_rule_set_id OUT NOCOPY number,

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

613: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
614: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
615: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
616: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
617: p_tax_uediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
618: p_freight_uediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
619: p_charges_uediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
620: p_rule_set_id OUT NOCOPY number,
621: p_ps_rec IN ar_payment_schedules%ROWTYPE) IS

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

614: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
615: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
616: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
617: p_tax_uediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
618: p_freight_uediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
619: p_charges_uediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
620: p_rule_set_id OUT NOCOPY number,
621: p_ps_rec IN ar_payment_schedules%ROWTYPE) IS
622:

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

615: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
616: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
617: p_tax_uediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
618: p_freight_uediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
619: p_charges_uediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
620: p_rule_set_id OUT NOCOPY number,
621: p_ps_rec IN ar_payment_schedules%ROWTYPE) IS
622:
623: l_ra_app_id NUMBER;

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

743: p_discount_taken_earned IN ar_payment_schedules.discount_taken_earned%TYPE,
744: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
745: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
746: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
747: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
748: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,
749: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,
750: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
751: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,

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

744: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
745: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
746: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
747: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
748: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,
749: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,
750: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
751: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
752: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,

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

745: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
746: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
747: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
748: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,
749: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,
750: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
751: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
752: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
753: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,

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

746: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
747: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
748: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,
749: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,
750: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
751: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
752: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
753: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
754: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,

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

747: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
748: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,
749: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,
750: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
751: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
752: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
753: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
754: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
755: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,

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

748: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,
749: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,
750: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
751: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
752: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
753: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
754: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
755: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
756: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,

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

749: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,
750: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
751: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
752: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
753: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
754: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
755: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
756: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
757: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,

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

750: p_line_applied OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
751: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
752: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
753: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
754: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
755: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
756: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
757: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
758: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,

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

751: p_tax_applied OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
752: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
753: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
754: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
755: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
756: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
757: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
758: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
759: p_tax_uediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,

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

752: p_freight_applied OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
753: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
754: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
755: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
756: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
757: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
758: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
759: p_tax_uediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
760: p_freight_uediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,

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

753: p_charges_applied OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
754: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
755: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
756: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
757: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
758: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
759: p_tax_uediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
760: p_freight_uediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
761: p_charges_uediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,

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

754: p_line_ediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
755: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
756: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
757: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
758: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
759: p_tax_uediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
760: p_freight_uediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
761: p_charges_uediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
762: p_rule_set_id OUT NOCOPY number,

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

755: p_tax_ediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
756: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
757: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
758: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
759: p_tax_uediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
760: p_freight_uediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
761: p_charges_uediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
762: p_rule_set_id OUT NOCOPY number,
763: p_ps_rec IN ar_payment_schedules%ROWTYPE,

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

756: p_freight_ediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
757: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
758: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
759: p_tax_uediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
760: p_freight_uediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
761: p_charges_uediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
762: p_rule_set_id OUT NOCOPY number,
763: p_ps_rec IN ar_payment_schedules%ROWTYPE,
764: p_cash_receipt_id IN ar_receivable_applications_all.cash_receipt_id%TYPE,

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

757: p_charges_ediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
758: p_line_uediscounted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
759: p_tax_uediscounted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
760: p_freight_uediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
761: p_charges_uediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
762: p_rule_set_id OUT NOCOPY number,
763: p_ps_rec IN ar_payment_schedules%ROWTYPE,
764: p_cash_receipt_id IN ar_receivable_applications_all.cash_receipt_id%TYPE,
765: p_ra_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,

Line 764: p_cash_receipt_id IN ar_receivable_applications_all.cash_receipt_id%TYPE,

760: p_freight_uediscounted OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
761: p_charges_uediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
762: p_rule_set_id OUT NOCOPY number,
763: p_ps_rec IN ar_payment_schedules%ROWTYPE,
764: p_cash_receipt_id IN ar_receivable_applications_all.cash_receipt_id%TYPE,
765: p_ra_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
766: p_gt_id OUT NOCOPY NUMBER) IS
767:
768: --

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

761: p_charges_uediscounted OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
762: p_rule_set_id OUT NOCOPY number,
763: p_ps_rec IN ar_payment_schedules%ROWTYPE,
764: p_cash_receipt_id IN ar_receivable_applications_all.cash_receipt_id%TYPE,
765: p_ra_app_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
766: p_gt_id OUT NOCOPY NUMBER) IS
767:
768: --
769: -- Temp variables

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

769: -- Temp variables
770: --
771: l_ps_rec ar_payment_schedules%ROWTYPE;
772: l_discount_taken_total ar_payment_schedules.amount_applied%TYPE:=0;
773: l_tax_discounted ar_receivable_applications.tax_applied%TYPE:=0;
774: l_freight_discounted ar_receivable_applications.freight_applied%TYPE:=0;
775: l_line_discounted ar_receivable_applications.line_applied%TYPE:=0;
776: l_charges_discounted
777: ar_receivable_applications.receivables_charges_applied%TYPE:=0;

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

770: --
771: l_ps_rec ar_payment_schedules%ROWTYPE;
772: l_discount_taken_total ar_payment_schedules.amount_applied%TYPE:=0;
773: l_tax_discounted ar_receivable_applications.tax_applied%TYPE:=0;
774: l_freight_discounted ar_receivable_applications.freight_applied%TYPE:=0;
775: l_line_discounted ar_receivable_applications.line_applied%TYPE:=0;
776: l_charges_discounted
777: ar_receivable_applications.receivables_charges_applied%TYPE:=0;
778: l_line_remaining ar_payment_schedules.tax_remaining%TYPE:=0;

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

771: l_ps_rec ar_payment_schedules%ROWTYPE;
772: l_discount_taken_total ar_payment_schedules.amount_applied%TYPE:=0;
773: l_tax_discounted ar_receivable_applications.tax_applied%TYPE:=0;
774: l_freight_discounted ar_receivable_applications.freight_applied%TYPE:=0;
775: l_line_discounted ar_receivable_applications.line_applied%TYPE:=0;
776: l_charges_discounted
777: ar_receivable_applications.receivables_charges_applied%TYPE:=0;
778: l_line_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
779: l_tax_remaining ar_payment_schedules.tax_remaining%TYPE:=0;

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

773: l_tax_discounted ar_receivable_applications.tax_applied%TYPE:=0;
774: l_freight_discounted ar_receivable_applications.freight_applied%TYPE:=0;
775: l_line_discounted ar_receivable_applications.line_applied%TYPE:=0;
776: l_charges_discounted
777: ar_receivable_applications.receivables_charges_applied%TYPE:=0;
778: l_line_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
779: l_tax_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
780: l_rec_charges_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
781: l_freight_remaining ar_payment_schedules.tax_remaining%TYPE:=0;

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

783: -- Variable to populate OUT NOCOPY arguments
784: -- We need these variables, 'cos the remaining LINE, TAX, FREIGHT and CHARGES
785: -- amounts are calculated based on the applied amounts and applied discounts
786: --
787: l_tax_applied ar_receivable_applications.tax_applied%TYPE:=0;
788: l_freight_applied ar_receivable_applications.freight_applied%TYPE:=0;
789: l_line_applied ar_receivable_applications.line_applied%TYPE:=0;
790: l_charges_applied ar_receivable_applications.receivables_charges_applied%TYPE:=0;
791: l_tax_ediscounted ar_receivable_applications.tax_applied%TYPE:=0;

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

784: -- We need these variables, 'cos the remaining LINE, TAX, FREIGHT and CHARGES
785: -- amounts are calculated based on the applied amounts and applied discounts
786: --
787: l_tax_applied ar_receivable_applications.tax_applied%TYPE:=0;
788: l_freight_applied ar_receivable_applications.freight_applied%TYPE:=0;
789: l_line_applied ar_receivable_applications.line_applied%TYPE:=0;
790: l_charges_applied ar_receivable_applications.receivables_charges_applied%TYPE:=0;
791: l_tax_ediscounted ar_receivable_applications.tax_applied%TYPE:=0;
792: l_freight_ediscounted ar_receivable_applications.freight_applied%TYPE:=0;

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

785: -- amounts are calculated based on the applied amounts and applied discounts
786: --
787: l_tax_applied ar_receivable_applications.tax_applied%TYPE:=0;
788: l_freight_applied ar_receivable_applications.freight_applied%TYPE:=0;
789: l_line_applied ar_receivable_applications.line_applied%TYPE:=0;
790: l_charges_applied ar_receivable_applications.receivables_charges_applied%TYPE:=0;
791: l_tax_ediscounted ar_receivable_applications.tax_applied%TYPE:=0;
792: l_freight_ediscounted ar_receivable_applications.freight_applied%TYPE:=0;
793: l_line_ediscounted ar_receivable_applications.line_applied%TYPE:=0;

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

786: --
787: l_tax_applied ar_receivable_applications.tax_applied%TYPE:=0;
788: l_freight_applied ar_receivable_applications.freight_applied%TYPE:=0;
789: l_line_applied ar_receivable_applications.line_applied%TYPE:=0;
790: l_charges_applied ar_receivable_applications.receivables_charges_applied%TYPE:=0;
791: l_tax_ediscounted ar_receivable_applications.tax_applied%TYPE:=0;
792: l_freight_ediscounted ar_receivable_applications.freight_applied%TYPE:=0;
793: l_line_ediscounted ar_receivable_applications.line_applied%TYPE:=0;
794: l_charges_ediscounted

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

787: l_tax_applied ar_receivable_applications.tax_applied%TYPE:=0;
788: l_freight_applied ar_receivable_applications.freight_applied%TYPE:=0;
789: l_line_applied ar_receivable_applications.line_applied%TYPE:=0;
790: l_charges_applied ar_receivable_applications.receivables_charges_applied%TYPE:=0;
791: l_tax_ediscounted ar_receivable_applications.tax_applied%TYPE:=0;
792: l_freight_ediscounted ar_receivable_applications.freight_applied%TYPE:=0;
793: l_line_ediscounted ar_receivable_applications.line_applied%TYPE:=0;
794: l_charges_ediscounted
795: ar_receivable_applications.receivables_charges_applied%TYPE:=0;

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

788: l_freight_applied ar_receivable_applications.freight_applied%TYPE:=0;
789: l_line_applied ar_receivable_applications.line_applied%TYPE:=0;
790: l_charges_applied ar_receivable_applications.receivables_charges_applied%TYPE:=0;
791: l_tax_ediscounted ar_receivable_applications.tax_applied%TYPE:=0;
792: l_freight_ediscounted ar_receivable_applications.freight_applied%TYPE:=0;
793: l_line_ediscounted ar_receivable_applications.line_applied%TYPE:=0;
794: l_charges_ediscounted
795: ar_receivable_applications.receivables_charges_applied%TYPE:=0;
796: l_tax_uediscounted ar_receivable_applications.tax_applied%TYPE:=0;

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

789: l_line_applied ar_receivable_applications.line_applied%TYPE:=0;
790: l_charges_applied ar_receivable_applications.receivables_charges_applied%TYPE:=0;
791: l_tax_ediscounted ar_receivable_applications.tax_applied%TYPE:=0;
792: l_freight_ediscounted ar_receivable_applications.freight_applied%TYPE:=0;
793: l_line_ediscounted ar_receivable_applications.line_applied%TYPE:=0;
794: l_charges_ediscounted
795: ar_receivable_applications.receivables_charges_applied%TYPE:=0;
796: l_tax_uediscounted ar_receivable_applications.tax_applied%TYPE:=0;
797: l_freight_uediscounted ar_receivable_applications.freight_applied%TYPE:=0;

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

791: l_tax_ediscounted ar_receivable_applications.tax_applied%TYPE:=0;
792: l_freight_ediscounted ar_receivable_applications.freight_applied%TYPE:=0;
793: l_line_ediscounted ar_receivable_applications.line_applied%TYPE:=0;
794: l_charges_ediscounted
795: ar_receivable_applications.receivables_charges_applied%TYPE:=0;
796: l_tax_uediscounted ar_receivable_applications.tax_applied%TYPE:=0;
797: l_freight_uediscounted ar_receivable_applications.freight_applied%TYPE:=0;
798: l_line_uediscounted ar_receivable_applications.line_applied%TYPE:=0;
799: l_charges_uediscounted

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

792: l_freight_ediscounted ar_receivable_applications.freight_applied%TYPE:=0;
793: l_line_ediscounted ar_receivable_applications.line_applied%TYPE:=0;
794: l_charges_ediscounted
795: ar_receivable_applications.receivables_charges_applied%TYPE:=0;
796: l_tax_uediscounted ar_receivable_applications.tax_applied%TYPE:=0;
797: l_freight_uediscounted ar_receivable_applications.freight_applied%TYPE:=0;
798: l_line_uediscounted ar_receivable_applications.line_applied%TYPE:=0;
799: l_charges_uediscounted
800: ar_receivable_applications.receivables_charges_applied%TYPE:=0;

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

793: l_line_ediscounted ar_receivable_applications.line_applied%TYPE:=0;
794: l_charges_ediscounted
795: ar_receivable_applications.receivables_charges_applied%TYPE:=0;
796: l_tax_uediscounted ar_receivable_applications.tax_applied%TYPE:=0;
797: l_freight_uediscounted ar_receivable_applications.freight_applied%TYPE:=0;
798: l_line_uediscounted ar_receivable_applications.line_applied%TYPE:=0;
799: l_charges_uediscounted
800: ar_receivable_applications.receivables_charges_applied%TYPE:=0;
801: --

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

794: l_charges_ediscounted
795: ar_receivable_applications.receivables_charges_applied%TYPE:=0;
796: l_tax_uediscounted ar_receivable_applications.tax_applied%TYPE:=0;
797: l_freight_uediscounted ar_receivable_applications.freight_applied%TYPE:=0;
798: l_line_uediscounted ar_receivable_applications.line_applied%TYPE:=0;
799: l_charges_uediscounted
800: ar_receivable_applications.receivables_charges_applied%TYPE:=0;
801: --
802: l_acctd_amount_applied

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

796: l_tax_uediscounted ar_receivable_applications.tax_applied%TYPE:=0;
797: l_freight_uediscounted ar_receivable_applications.freight_applied%TYPE:=0;
798: l_line_uediscounted ar_receivable_applications.line_applied%TYPE:=0;
799: l_charges_uediscounted
800: ar_receivable_applications.receivables_charges_applied%TYPE:=0;
801: --
802: l_acctd_amount_applied
803: ar_receivable_applications.acctd_amount_applied_from%TYPE:=0;
804: l_acctd_earned_discount_taken

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

799: l_charges_uediscounted
800: ar_receivable_applications.receivables_charges_applied%TYPE:=0;
801: --
802: l_acctd_amount_applied
803: ar_receivable_applications.acctd_amount_applied_from%TYPE:=0;
804: l_acctd_earned_discount_taken
805: ar_receivable_applications.earned_discount_taken%TYPE:=0;
806: l_acctd_unearned_disc_taken
807: ar_receivable_applications.acctd_unearned_discount_taken%TYPE:=0;

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

801: --
802: l_acctd_amount_applied
803: ar_receivable_applications.acctd_amount_applied_from%TYPE:=0;
804: l_acctd_earned_discount_taken
805: ar_receivable_applications.earned_discount_taken%TYPE:=0;
806: l_acctd_unearned_disc_taken
807: ar_receivable_applications.acctd_unearned_discount_taken%TYPE:=0;
808: --
809:

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

803: ar_receivable_applications.acctd_amount_applied_from%TYPE:=0;
804: l_acctd_earned_discount_taken
805: ar_receivable_applications.earned_discount_taken%TYPE:=0;
806: l_acctd_unearned_disc_taken
807: ar_receivable_applications.acctd_unearned_discount_taken%TYPE:=0;
808: --
809:
810: --Introduced For Bug # 2711860
811: -- ORASHID

Line 1354: p_line_applied IN ar_receivable_applications.line_applied%TYPE,

1350: +===========================================================================*/
1351: PROCEDURE update_cm_related_columns(
1352: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
1353: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
1354: p_line_applied IN ar_receivable_applications.line_applied%TYPE,
1355: p_tax_applied IN ar_receivable_applications.tax_applied%TYPE,
1356: p_freight_applied IN
1357: ar_receivable_applications.freight_applied%TYPE,
1358: p_charges_applied IN

Line 1355: p_tax_applied IN ar_receivable_applications.tax_applied%TYPE,

1351: PROCEDURE update_cm_related_columns(
1352: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
1353: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
1354: p_line_applied IN ar_receivable_applications.line_applied%TYPE,
1355: p_tax_applied IN ar_receivable_applications.tax_applied%TYPE,
1356: p_freight_applied IN
1357: ar_receivable_applications.freight_applied%TYPE,
1358: p_charges_applied IN
1359: ar_receivable_applications.receivables_charges_applied%TYPE,

Line 1357: ar_receivable_applications.freight_applied%TYPE,

1353: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
1354: p_line_applied IN ar_receivable_applications.line_applied%TYPE,
1355: p_tax_applied IN ar_receivable_applications.tax_applied%TYPE,
1356: p_freight_applied IN
1357: ar_receivable_applications.freight_applied%TYPE,
1358: p_charges_applied IN
1359: ar_receivable_applications.receivables_charges_applied%TYPE,
1360: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
1361: p_gl_date IN ar_payment_schedules.gl_date%TYPE,

Line 1359: ar_receivable_applications.receivables_charges_applied%TYPE,

1355: p_tax_applied IN ar_receivable_applications.tax_applied%TYPE,
1356: p_freight_applied IN
1357: ar_receivable_applications.freight_applied%TYPE,
1358: p_charges_applied IN
1359: ar_receivable_applications.receivables_charges_applied%TYPE,
1360: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
1361: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
1362: p_acctd_amount_applied OUT NOCOPY
1363: ar_receivable_applications.acctd_amount_applied_to%TYPE,

Line 1363: ar_receivable_applications.acctd_amount_applied_to%TYPE,

1359: ar_receivable_applications.receivables_charges_applied%TYPE,
1360: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
1361: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
1362: p_acctd_amount_applied OUT NOCOPY
1363: ar_receivable_applications.acctd_amount_applied_to%TYPE,
1364: p_ps_rec IN ar_payment_schedules%ROWTYPE,
1365: p_update_credit_flag IN VARCHAR2 ) IS
1366: --
1367: l_ps_rec ar_payment_schedules%ROWTYPE;

Line 1372: ar_receivable_applications.acctd_amount_applied_from%TYPE;

1368: --
1369: -- Variable to populate OUT NOCOPY arguments
1370: --
1371: l_acctd_amount_applied
1372: ar_receivable_applications.acctd_amount_applied_from%TYPE;
1373:
1374: --Introduced For Bug # 2711860
1375: -- ORASHID
1376: --

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

1554: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
1555: p_type IN ar_adjustments.type%TYPE,
1556: p_amount_adjusted IN ar_payment_schedules.amount_adjusted%TYPE,
1557: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,
1558: p_line_adjusted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
1559: p_tax_adjusted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
1560: p_freight_adjusted IN OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
1561: p_charges_adjusted IN OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
1562: p_apply_date IN ar_payment_schedules.gl_date%TYPE,

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

1555: p_type IN ar_adjustments.type%TYPE,
1556: p_amount_adjusted IN ar_payment_schedules.amount_adjusted%TYPE,
1557: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,
1558: p_line_adjusted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
1559: p_tax_adjusted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
1560: p_freight_adjusted IN OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
1561: p_charges_adjusted IN OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
1562: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
1563: p_gl_date IN ar_payment_schedules.gl_date%TYPE,

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

1556: p_amount_adjusted IN ar_payment_schedules.amount_adjusted%TYPE,
1557: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,
1558: p_line_adjusted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
1559: p_tax_adjusted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
1560: p_freight_adjusted IN OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
1561: p_charges_adjusted IN OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
1562: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
1563: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
1564: p_acctd_amount_adjusted OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,

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

1557: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,
1558: p_line_adjusted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
1559: p_tax_adjusted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
1560: p_freight_adjusted IN OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
1561: p_charges_adjusted IN OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
1562: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
1563: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
1564: p_acctd_amount_adjusted OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
1565: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE) IS

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

1560: p_freight_adjusted IN OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,
1561: p_charges_adjusted IN OUT NOCOPY ar_receivable_applications.receivables_charges_applied%TYPE,
1562: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
1563: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
1564: p_acctd_amount_adjusted OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
1565: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE) IS
1566: --
1567: -- deleted 'DEFAULT NULL' for p_ps_rec Rowtype attribute -bug460979 for Oracle8
1568:

Line 1586: ar_receivable_applications.acctd_amount_applied_from%TYPE;

1582: --
1583: -- Variable to populate OUT NOCOPY arguments
1584: --
1585: l_acctd_amount_adjusted
1586: ar_receivable_applications.acctd_amount_applied_from%TYPE;
1587:
1588: rem_adj_amt NUMBER;
1589:
1590: BEGIN

Line 1949: p_line_adjusted IN ar_receivable_applications.line_applied%TYPE,

1945: +===========================================================================*/
1946:
1947: PROCEDURE update_adj_related_columns(
1948: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
1949: p_line_adjusted IN ar_receivable_applications.line_applied%TYPE,
1950: p_tax_adjusted IN ar_receivable_applications.tax_applied%TYPE,
1951: p_freight_adjusted IN ar_receivable_applications.freight_applied%TYPE,
1952: p_charges_adjusted IN ar_receivable_applications.receivables_charges_applied%TYPE,
1953: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,

Line 1950: p_tax_adjusted IN ar_receivable_applications.tax_applied%TYPE,

1946:
1947: PROCEDURE update_adj_related_columns(
1948: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
1949: p_line_adjusted IN ar_receivable_applications.line_applied%TYPE,
1950: p_tax_adjusted IN ar_receivable_applications.tax_applied%TYPE,
1951: p_freight_adjusted IN ar_receivable_applications.freight_applied%TYPE,
1952: p_charges_adjusted IN ar_receivable_applications.receivables_charges_applied%TYPE,
1953: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,
1954: p_apply_date IN ar_payment_schedules.gl_date%TYPE,

Line 1951: p_freight_adjusted IN ar_receivable_applications.freight_applied%TYPE,

1947: PROCEDURE update_adj_related_columns(
1948: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
1949: p_line_adjusted IN ar_receivable_applications.line_applied%TYPE,
1950: p_tax_adjusted IN ar_receivable_applications.tax_applied%TYPE,
1951: p_freight_adjusted IN ar_receivable_applications.freight_applied%TYPE,
1952: p_charges_adjusted IN ar_receivable_applications.receivables_charges_applied%TYPE,
1953: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,
1954: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
1955: p_gl_date IN ar_payment_schedules.gl_date%TYPE,

Line 1952: p_charges_adjusted IN ar_receivable_applications.receivables_charges_applied%TYPE,

1948: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
1949: p_line_adjusted IN ar_receivable_applications.line_applied%TYPE,
1950: p_tax_adjusted IN ar_receivable_applications.tax_applied%TYPE,
1951: p_freight_adjusted IN ar_receivable_applications.freight_applied%TYPE,
1952: p_charges_adjusted IN ar_receivable_applications.receivables_charges_applied%TYPE,
1953: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,
1954: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
1955: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
1956: p_acctd_amount_adjusted OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,

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

1952: p_charges_adjusted IN ar_receivable_applications.receivables_charges_applied%TYPE,
1953: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,
1954: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
1955: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
1956: p_acctd_amount_adjusted OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
1957: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE) IS
1958: --
1959: -- deleted 'DEFAULT NULL' for p_ps_rec Rowtype attribute -bug460979 for Oracle8
1960:

Line 1967: l_acctd_amount_adjusted ar_receivable_applications.acctd_amount_applied_from%TYPE;

1963:
1964: --
1965: -- Variable to populate OUT NOCOPY arguments
1966: --
1967: l_acctd_amount_adjusted ar_receivable_applications.acctd_amount_applied_from%TYPE;
1968:
1969:
1970: --Introduced For Bug # 2711860
1971: -- ORASHID

Line 2132: ar_receivable_applications.line_applied%TYPE,

2128: +===========================================================================*/
2129: PROCEDURE validate_args_upd_adj_rel_cols(
2130: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
2131: p_line_adjusted IN
2132: ar_receivable_applications.line_applied%TYPE,
2133: p_tax_adjusted IN
2134: ar_receivable_applications.tax_applied%TYPE,
2135: p_freight_adjusted IN
2136: ar_receivable_applications.freight_applied%TYPE,

Line 2134: ar_receivable_applications.tax_applied%TYPE,

2130: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
2131: p_line_adjusted IN
2132: ar_receivable_applications.line_applied%TYPE,
2133: p_tax_adjusted IN
2134: ar_receivable_applications.tax_applied%TYPE,
2135: p_freight_adjusted IN
2136: ar_receivable_applications.freight_applied%TYPE,
2137: p_charges_adjusted IN
2138: ar_receivable_applications.receivables_charges_applied%TYPE,

Line 2136: ar_receivable_applications.freight_applied%TYPE,

2132: ar_receivable_applications.line_applied%TYPE,
2133: p_tax_adjusted IN
2134: ar_receivable_applications.tax_applied%TYPE,
2135: p_freight_adjusted IN
2136: ar_receivable_applications.freight_applied%TYPE,
2137: p_charges_adjusted IN
2138: ar_receivable_applications.receivables_charges_applied%TYPE,
2139: p_amount_adjusted_pending IN
2140: ar_payment_schedules.amount_adjusted_pending%TYPE,

Line 2138: ar_receivable_applications.receivables_charges_applied%TYPE,

2134: ar_receivable_applications.tax_applied%TYPE,
2135: p_freight_adjusted IN
2136: ar_receivable_applications.freight_applied%TYPE,
2137: p_charges_adjusted IN
2138: ar_receivable_applications.receivables_charges_applied%TYPE,
2139: p_amount_adjusted_pending IN
2140: ar_payment_schedules.amount_adjusted_pending%TYPE,
2141: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
2142: p_gl_date IN ar_payment_schedules.gl_date%TYPE ) IS

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

2261: | |
2262: | DESCRIPTION |
2263: | Determines gl_date_closed and actual_date_closed for a payment |
2264: | schedule. For each of the two, it returns the greatest date from |
2265: | ar_receivable_applications, ar_adjustments, and the input current |
2266: | date. If it finds no values for a date, a null string is returned. |
2267: | |
2268: | NOTE: This function does not correctly handle applications for future|
2269: | items or future cash receipts. If an application or adjustment that |

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

2271: | gl_date/trx_date or the cash receipt's gl_date/deposit_date, then the|
2272: | gl_date_closed/actual_date_closed should be the greatest dates - the |
2273: | ones from the item or cash receipt. The dates returned by armclps |
2274: | will be less than the correct ones because this function selects |
2275: | only from ar_receivable_applications, ar_adjustments and the input |
2276: | "current" dates.
2277: | |
2278: | |
2279: | SCOPE - PUBLIC |

Line 2287: | ar_receivable_applications.gl_date, and |

2283: | p_gl_reversal_date - gl_date of current uncommitted |
2284: | transaction |
2285: | p_reversal_date - apply date of current uncommitted xtion |
2286: | p_gl_date_closed - greatest of ar_adjustments.gl_date, |
2287: | ar_receivable_applications.gl_date, and |
2288: | current_gl_date. |
2289: | p_actual_date_closed - (output) greatest of |
2290: | ar_adjustments.apply_date, |
2291: | ar_receivable_applications.apply_date, |

Line 2291: | ar_receivable_applications.apply_date, |

2287: | ar_receivable_applications.gl_date, and |
2288: | current_gl_date. |
2289: | p_actual_date_closed - (output) greatest of |
2290: | ar_adjustments.apply_date, |
2291: | ar_receivable_applications.apply_date, |
2292: | and current_apply_date. |
2293: | |
2294: | MODIFICATION HISTORY - |
2295: | |

Line 2298: | from ar_receivable_applications. Now check|

2294: | MODIFICATION HISTORY - |
2295: | |
2296: | 08/18/98 Sushama Borde Fixed bug 705906. Modified select statment|
2297: | that gets the max gl_date and apply_date |
2298: | from ar_receivable_applications. Now check|
2299: | s the reversal_gl_date, while selecting |
2300: | apply_date, and excludes applications that|
2301: | have been reversed.
2302: | 07/04/04 S.A.P.N.Sarma The actual_date_closed and gl_date_Closed |

Line 2326: -- Get max dates from ar_receivable_applications

2322: IF PG_DEBUG in ('Y', 'C') THEN
2323: arp_util.debug( '>>>>>>> arp_util.get_closed_dates' );
2324: END IF;
2325: --
2326: -- Get max dates from ar_receivable_applications
2327: --
2328:
2329: IF PG_DEBUG in ('Y', 'C') THEN
2330: arp_util.debug('get_closed_dates: ' || '>>>P_PS_ID: ' || p_ps_id );

Line 2341: FROM ar_receivable_applications

2337: -- application reversals while
2338: -- getting the max apply_date.
2339: INTO l_gl_app,
2340: l_act_app
2341: FROM ar_receivable_applications
2342: WHERE ( applied_payment_schedule_id = p_ps_id -- "Trx" that was applied
2343:
2344: or payment_schedule_id = p_ps_id ) -- "Payment" or "Credit Memo" being
2345: -- applied.