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_PAYMENT_SCHEDULES

Line 9: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

5:
6: PROCEDURE val_update_rev_actions( p_ps_id IN NUMBER );
7: --
8: PROCEDURE validate_args_upd_rel_cols(
9: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
10: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
11: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
12: p_gl_date IN ar_payment_schedules.gl_date%TYPE );
13: --

Line 10: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,

6: PROCEDURE val_update_rev_actions( p_ps_id IN NUMBER );
7: --
8: PROCEDURE validate_args_upd_rel_cols(
9: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
10: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
11: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
12: p_gl_date IN ar_payment_schedules.gl_date%TYPE );
13: --
14: PROCEDURE validate_args_upd_inv_rel_cols(

Line 11: p_apply_date IN ar_payment_schedules.gl_date%TYPE,

7: --
8: PROCEDURE validate_args_upd_rel_cols(
9: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
10: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
11: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
12: p_gl_date IN ar_payment_schedules.gl_date%TYPE );
13: --
14: PROCEDURE validate_args_upd_inv_rel_cols(
15: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

Line 12: p_gl_date IN ar_payment_schedules.gl_date%TYPE );

8: PROCEDURE validate_args_upd_rel_cols(
9: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
10: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
11: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
12: p_gl_date IN ar_payment_schedules.gl_date%TYPE );
13: --
14: PROCEDURE validate_args_upd_inv_rel_cols(
15: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
16: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,

Line 15: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

11: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
12: p_gl_date IN ar_payment_schedules.gl_date%TYPE );
13: --
14: PROCEDURE validate_args_upd_inv_rel_cols(
15: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
16: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
17: p_earned_discount IN
18: ar_payment_schedules.discount_taken_earned%TYPE,
19: p_unearned_discount IN

Line 16: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,

12: p_gl_date IN ar_payment_schedules.gl_date%TYPE );
13: --
14: PROCEDURE validate_args_upd_inv_rel_cols(
15: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
16: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
17: p_earned_discount IN
18: ar_payment_schedules.discount_taken_earned%TYPE,
19: p_unearned_discount IN
20: ar_payment_schedules.discount_taken_unearned%TYPE,

Line 18: ar_payment_schedules.discount_taken_earned%TYPE,

14: PROCEDURE validate_args_upd_inv_rel_cols(
15: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
16: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
17: p_earned_discount IN
18: ar_payment_schedules.discount_taken_earned%TYPE,
19: p_unearned_discount IN
20: ar_payment_schedules.discount_taken_unearned%TYPE,
21: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
22: p_gl_date IN ar_payment_schedules.gl_date%TYPE );

Line 20: ar_payment_schedules.discount_taken_unearned%TYPE,

16: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
17: p_earned_discount IN
18: ar_payment_schedules.discount_taken_earned%TYPE,
19: p_unearned_discount IN
20: ar_payment_schedules.discount_taken_unearned%TYPE,
21: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
22: p_gl_date IN ar_payment_schedules.gl_date%TYPE );
23: --
24: PROCEDURE validate_args_upd_adj_rel_cols(

Line 21: p_apply_date IN ar_payment_schedules.gl_date%TYPE,

17: p_earned_discount IN
18: ar_payment_schedules.discount_taken_earned%TYPE,
19: p_unearned_discount IN
20: ar_payment_schedules.discount_taken_unearned%TYPE,
21: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
22: p_gl_date IN ar_payment_schedules.gl_date%TYPE );
23: --
24: PROCEDURE validate_args_upd_adj_rel_cols(
25: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

Line 22: p_gl_date IN ar_payment_schedules.gl_date%TYPE );

18: ar_payment_schedules.discount_taken_earned%TYPE,
19: p_unearned_discount IN
20: ar_payment_schedules.discount_taken_unearned%TYPE,
21: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
22: p_gl_date IN ar_payment_schedules.gl_date%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

Line 25: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

21: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
22: p_gl_date IN ar_payment_schedules.gl_date%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,

Line 35: ar_payment_schedules.amount_adjusted_pending%TYPE,

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 );
38: --
39: PROCEDURE validate_args_upd_adj_rel_cols(

Line 36: p_apply_date IN ar_payment_schedules.gl_date%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 );
38: --
39: PROCEDURE validate_args_upd_adj_rel_cols(
40: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

Line 37: p_gl_date IN ar_payment_schedules.gl_date%TYPE );

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 );
38: --
39: PROCEDURE validate_args_upd_adj_rel_cols(
40: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
41: p_apply_date IN ar_payment_schedules.gl_date%TYPE,

Line 40: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

36: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
37: p_gl_date IN ar_payment_schedules.gl_date%TYPE );
38: --
39: PROCEDURE validate_args_upd_adj_rel_cols(
40: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
41: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
42: p_gl_date IN ar_payment_schedules.gl_date%TYPE );
43:
44: -- Bug fix 653643 commented out NOCOPY as this procedure is being declared as PUBLIC

Line 41: p_apply_date IN ar_payment_schedules.gl_date%TYPE,

37: p_gl_date IN ar_payment_schedules.gl_date%TYPE );
38: --
39: PROCEDURE validate_args_upd_adj_rel_cols(
40: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
41: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
42: p_gl_date IN ar_payment_schedules.gl_date%TYPE );
43:
44: -- Bug fix 653643 commented out NOCOPY as this procedure is being declared as PUBLIC
45: --PROCEDURE populate_closed_dates(

Line 42: p_gl_date IN ar_payment_schedules.gl_date%TYPE );

38: --
39: PROCEDURE validate_args_upd_adj_rel_cols(
40: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
41: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
42: p_gl_date IN ar_payment_schedules.gl_date%TYPE );
43:
44: -- Bug fix 653643 commented out NOCOPY as this procedure is being declared as PUBLIC
45: --PROCEDURE populate_closed_dates(
46: -- p_gl_date IN ar_payment_schedules.gl_date%TYPE,

Line 46: -- p_gl_date IN ar_payment_schedules.gl_date%TYPE,

42: p_gl_date IN ar_payment_schedules.gl_date%TYPE );
43:
44: -- Bug fix 653643 commented out NOCOPY as this procedure is being declared as PUBLIC
45: --PROCEDURE populate_closed_dates(
46: -- p_gl_date IN ar_payment_schedules.gl_date%TYPE,
47: -- p_apply_date IN ar_payment_schedules.gl_date%TYPE,
48: -- p_app_type IN VARCHAR2,
49: -- p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE );
50:

Line 47: -- p_apply_date IN ar_payment_schedules.gl_date%TYPE,

43:
44: -- Bug fix 653643 commented out NOCOPY as this procedure is being declared as PUBLIC
45: --PROCEDURE populate_closed_dates(
46: -- p_gl_date IN ar_payment_schedules.gl_date%TYPE,
47: -- p_apply_date IN ar_payment_schedules.gl_date%TYPE,
48: -- p_app_type IN VARCHAR2,
49: -- p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE );
50:
51: /*===========================================================================+

Line 49: -- p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE );

45: --PROCEDURE populate_closed_dates(
46: -- p_gl_date IN ar_payment_schedules.gl_date%TYPE,
47: -- p_apply_date IN ar_payment_schedules.gl_date%TYPE,
48: -- p_app_type IN VARCHAR2,
49: -- p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE );
50:
51: /*===========================================================================+
52: | PROCEDURE |
53: | update_reverse_actions |

Line 63: | arp_ps_pkg.update_p - Update a row in AR_PAYMENT_SCHEDULES table |

59: | |
60: | SCOPE - PUBLIC |
61: | |
62: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - |
63: | arp_ps_pkg.update_p - Update a row in AR_PAYMENT_SCHEDULES table |
64: | arp_ps_pkg.fetch_p - fetch a row in AR_PAYMENT_SCHEDULES table |
65: | |
66: | ARGUMENTS : IN: |
67: | p_app_rec - Application Record structure |

Line 64: | arp_ps_pkg.fetch_p - fetch a row in AR_PAYMENT_SCHEDULES table |

60: | SCOPE - PUBLIC |
61: | |
62: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - |
63: | arp_ps_pkg.update_p - Update a row in AR_PAYMENT_SCHEDULES table |
64: | arp_ps_pkg.fetch_p - fetch a row in AR_PAYMENT_SCHEDULES table |
65: | |
66: | ARGUMENTS : IN: |
67: | p_app_rec - Application Record structure |
68: | p_module_name _ Name of module that called this procedure|

Line 92: l_ps_rec ar_payment_schedules%ROWTYPE;

88: p_app_rec IN arp_global.app_rec_type,
89: p_module_name IN VARCHAR2,
90: p_module_version IN VARCHAR2) IS
91:
92: l_ps_rec ar_payment_schedules%ROWTYPE;
93:
94: BEGIN
95: IF PG_DEBUG in ('Y', 'C') THEN
96: arp_util.debug('val_update_rev_actions: ' || 'arp_ps_util.update_reverse_actions()+' );

Line 344: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

340: | HISTORY - Created By - Ganesh Vaidee - 08/24/1995 |
341: | |
342: +===========================================================================*/
343: PROCEDURE update_receipt_related_columns(
344: p_ps_id IN ar_payment_schedules.payment_schedule_id%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

Line 345: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,

341: | |
342: +===========================================================================*/
343: PROCEDURE update_receipt_related_columns(
344: p_ps_id IN ar_payment_schedules.payment_schedule_id%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,

Line 346: p_apply_date IN ar_payment_schedules.gl_date%TYPE,

342: +===========================================================================*/
343: PROCEDURE update_receipt_related_columns(
344: p_ps_id IN ar_payment_schedules.payment_schedule_id%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

Line 347: p_gl_date IN ar_payment_schedules.gl_date%TYPE,

343: PROCEDURE update_receipt_related_columns(
344: p_ps_id IN ar_payment_schedules.payment_schedule_id%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: --

Line 350: p_ps_rec IN ar_payment_schedules%ROWTYPE ) IS

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: --
354: -- Variable to populate OUT NOCOPY arguments

Line 352: l_ps_rec ar_payment_schedules%ROWTYPE;

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: --
354: -- Variable to populate OUT NOCOPY arguments
355: --
356: l_acctd_amount_applied

Line 363: ar_payment_schedules.amount_due_remaining%TYPE;

359: --Introduced For Bug # 2711860
360: -- ORASHID
361: --
362: l_nocopy_amt_due_remain
363: ar_payment_schedules.amount_due_remaining%TYPE;
364: l_nocopy_acctd_amt_due_remain
365: ar_payment_schedules.acctd_amount_due_remaining%TYPE;
366:
367: BEGIN

Line 365: ar_payment_schedules.acctd_amount_due_remaining%TYPE;

361: --
362: l_nocopy_amt_due_remain
363: ar_payment_schedules.amount_due_remaining%TYPE;
364: l_nocopy_acctd_amt_due_remain
365: ar_payment_schedules.acctd_amount_due_remaining%TYPE;
366:
367: BEGIN
368: arp_util.debug( 'arp_ps_util.update_receipt_related_columns()+' );
369: --

Line 439: UPDATE ar_payment_schedules

435:
436: /* Bug 5569488, do not update payment schedule if the receipt requires
437: confirmation. Added the If condition */
438: IF NVL(l_ps_rec.receipt_confirmed_flag,'Y') <> 'N' THEN
439: UPDATE ar_payment_schedules
440: set acctd_amount_due_remaining = l_ps_rec.acctd_amount_due_remaining,
441: amount_due_remaining = l_ps_rec.amount_due_remaining,
442: amount_applied = l_ps_rec.amount_applied,
443: selected_for_receipt_batch_id = l_ps_rec.selected_for_receipt_batch_id,

Line 494: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

490: | NOTES - |
491: | |
492: +===========================================================================*/
493: PROCEDURE validate_args_upd_rel_cols(
494: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
495: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
496: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
497: p_gl_date IN ar_payment_schedules.gl_date%TYPE ) IS
498: BEGIN

Line 495: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,

491: | |
492: +===========================================================================*/
493: PROCEDURE validate_args_upd_rel_cols(
494: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
495: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
496: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
497: p_gl_date IN ar_payment_schedules.gl_date%TYPE ) IS
498: BEGIN
499: IF PG_DEBUG in ('Y', 'C') THEN

Line 496: p_apply_date IN ar_payment_schedules.gl_date%TYPE,

492: +===========================================================================*/
493: PROCEDURE validate_args_upd_rel_cols(
494: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
495: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
496: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
497: p_gl_date IN ar_payment_schedules.gl_date%TYPE ) IS
498: BEGIN
499: IF PG_DEBUG in ('Y', 'C') THEN
500: arp_util.debug( 'arp_ps_util.validate_args_upd_rel_cols()+' );

Line 497: p_gl_date IN ar_payment_schedules.gl_date%TYPE ) IS

493: PROCEDURE validate_args_upd_rel_cols(
494: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
495: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
496: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
497: p_gl_date IN ar_payment_schedules.gl_date%TYPE ) IS
498: BEGIN
499: IF PG_DEBUG in ('Y', 'C') THEN
500: arp_util.debug( 'arp_ps_util.validate_args_upd_rel_cols()+' );
501: END IF;

Line 599: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

595: | calc_applied_and_remaining
596: +===========================================================================*/
597: PROCEDURE update_invoice_related_columns(
598: p_app_type IN VARCHAR2,
599: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
600: p_amount_applied IN ar_payment_schedules.amount_applied%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,

Line 600: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,

596: +===========================================================================*/
597: PROCEDURE update_invoice_related_columns(
598: p_app_type IN VARCHAR2,
599: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
600: p_amount_applied IN ar_payment_schedules.amount_applied%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,

Line 601: p_discount_taken_earned IN ar_payment_schedules.discount_taken_earned%TYPE,

597: PROCEDURE update_invoice_related_columns(
598: p_app_type IN VARCHAR2,
599: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
600: p_amount_applied IN ar_payment_schedules.amount_applied%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,

Line 602: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,

598: p_app_type IN VARCHAR2,
599: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
600: p_amount_applied IN ar_payment_schedules.amount_applied%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,

Line 603: p_apply_date IN ar_payment_schedules.gl_date%TYPE,

599: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
600: p_amount_applied IN ar_payment_schedules.amount_applied%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,

Line 604: p_gl_date IN ar_payment_schedules.gl_date%TYPE,

600: p_amount_applied IN ar_payment_schedules.amount_applied%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,

Line 621: p_ps_rec IN ar_payment_schedules%ROWTYPE) IS

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;
624: l_gt_id NUMBER;
625:

Line 741: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

737: | calc_applied_and_remaining
738: +===========================================================================*/
739: PROCEDURE update_invoice_related_columns(
740: p_app_type IN VARCHAR2,
741: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
742: p_amount_applied IN ar_payment_schedules.amount_applied%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,

Line 742: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,

738: +===========================================================================*/
739: PROCEDURE update_invoice_related_columns(
740: p_app_type IN VARCHAR2,
741: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
742: p_amount_applied IN ar_payment_schedules.amount_applied%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,

Line 743: p_discount_taken_earned IN ar_payment_schedules.discount_taken_earned%TYPE,

739: PROCEDURE update_invoice_related_columns(
740: p_app_type IN VARCHAR2,
741: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
742: p_amount_applied IN ar_payment_schedules.amount_applied%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,

Line 744: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,

740: p_app_type IN VARCHAR2,
741: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
742: p_amount_applied IN ar_payment_schedules.amount_applied%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,

Line 745: p_apply_date IN ar_payment_schedules.gl_date%TYPE,

741: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
742: p_amount_applied IN ar_payment_schedules.amount_applied%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,

Line 746: p_gl_date IN ar_payment_schedules.gl_date%TYPE,

742: p_amount_applied IN ar_payment_schedules.amount_applied%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,

Line 763: p_ps_rec IN ar_payment_schedules%ROWTYPE,

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,
766: p_gt_id OUT NOCOPY NUMBER) IS
767:

Line 771: l_ps_rec ar_payment_schedules%ROWTYPE;

767:
768: --
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;

Line 772: l_discount_taken_total ar_payment_schedules.amount_applied%TYPE:=0;

768: --
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

Line 778: l_line_remaining ar_payment_schedules.tax_remaining%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;
782: --

Line 779: l_tax_remaining ar_payment_schedules.tax_remaining%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;
782: --
783: -- Variable to populate OUT NOCOPY arguments

Line 780: l_rec_charges_remaining ar_payment_schedules.tax_remaining%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;
782: --
783: -- Variable to populate OUT NOCOPY arguments
784: -- We need these variables, 'cos the remaining LINE, TAX, FREIGHT and CHARGES

Line 781: l_freight_remaining ar_payment_schedules.tax_remaining%TYPE:=0;

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;
782: --
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

Line 814: ar_payment_schedules.amount_due_remaining%TYPE;

810: --Introduced For Bug # 2711860
811: -- ORASHID
812: --
813: l_nocopy_amt_due_remain
814: ar_payment_schedules.amount_due_remaining%TYPE;
815: l_nocopy_acctd_amt_due_remain
816: ar_payment_schedules.acctd_amount_due_remaining%TYPE;
817:
818: -- 5569488

Line 816: ar_payment_schedules.acctd_amount_due_remaining%TYPE;

812: --
813: l_nocopy_amt_due_remain
814: ar_payment_schedules.amount_due_remaining%TYPE;
815: l_nocopy_acctd_amt_due_remain
816: ar_payment_schedules.acctd_amount_due_remaining%TYPE;
817:
818: -- 5569488
819: l_receipt_confirmed_flag ar_payment_schedules.receipt_confirmed_flag%TYPE ;
820:

Line 819: l_receipt_confirmed_flag ar_payment_schedules.receipt_confirmed_flag%TYPE ;

815: l_nocopy_acctd_amt_due_remain
816: ar_payment_schedules.acctd_amount_due_remaining%TYPE;
817:
818: -- 5569488
819: l_receipt_confirmed_flag ar_payment_schedules.receipt_confirmed_flag%TYPE ;
820:
821: /* 5677984 - locals for etax calls */
822: l_ebt_customer_trx_id ar_payment_schedules.customer_trx_id%TYPE;
823: l_ebt_discount_amt NUMBER;

Line 822: l_ebt_customer_trx_id ar_payment_schedules.customer_trx_id%TYPE;

818: -- 5569488
819: l_receipt_confirmed_flag ar_payment_schedules.receipt_confirmed_flag%TYPE ;
820:
821: /* 5677984 - locals for etax calls */
822: l_ebt_customer_trx_id ar_payment_schedules.customer_trx_id%TYPE;
823: l_ebt_discount_amt NUMBER;
824: l_ebt_gt_id NUMBER;
825: l_ebt_prorated_line NUMBER;
826: l_ebt_prorated_tax NUMBER;

Line 896: FROM ar_payment_schedules

892: THEN
893: /* set up local variables for call */
894: SELECT customer_trx_id
895: INTO l_ebt_customer_trx_id
896: FROM ar_payment_schedules
897: WHERE payment_schedule_id = p_ps_id;
898:
899: l_ebt_discount_amt := l_line_ediscounted + l_tax_ediscounted;
900:

Line 960: FROM ar_payment_schedules

956: IF l_ebt_customer_trx_id IS NULL
957: THEN
958: SELECT customer_trx_id
959: INTO l_ebt_customer_trx_id
960: FROM ar_payment_schedules
961: WHERE payment_schedule_id = p_ps_id;
962: END IF;
963:
964: l_ebt_discount_amt := l_line_uediscounted + l_tax_uediscounted;

Line 1192: from ar_payment_schedules_all

1188: confirmation. Added the If condition */
1189: IF p_ps_rec.cash_receipt_id IS NOT NULL THEN
1190: Select receipt_confirmed_flag
1191: into l_receipt_confirmed_flag
1192: from ar_payment_schedules_all
1193: where cash_receipt_id = p_ps_rec.cash_receipt_id ;
1194: END IF ;
1195: IF NVL(l_receipt_confirmed_flag,'Y') <> 'N' THEN
1196: arp_ps_pkg.update_p( l_ps_rec );

Line 1262: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

1258: | NOTES - |
1259: | |
1260: +===========================================================================*/
1261: PROCEDURE validate_args_upd_inv_rel_cols(
1262: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
1263: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
1264: p_earned_discount IN
1265: ar_payment_schedules.discount_taken_earned%TYPE,
1266: p_unearned_discount IN

Line 1263: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,

1259: | |
1260: +===========================================================================*/
1261: PROCEDURE validate_args_upd_inv_rel_cols(
1262: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
1263: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
1264: p_earned_discount IN
1265: ar_payment_schedules.discount_taken_earned%TYPE,
1266: p_unearned_discount IN
1267: ar_payment_schedules.discount_taken_unearned%TYPE,

Line 1265: ar_payment_schedules.discount_taken_earned%TYPE,

1261: PROCEDURE validate_args_upd_inv_rel_cols(
1262: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
1263: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
1264: p_earned_discount IN
1265: ar_payment_schedules.discount_taken_earned%TYPE,
1266: p_unearned_discount IN
1267: ar_payment_schedules.discount_taken_unearned%TYPE,
1268: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
1269: p_gl_date IN ar_payment_schedules.gl_date%TYPE ) IS

Line 1267: ar_payment_schedules.discount_taken_unearned%TYPE,

1263: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
1264: p_earned_discount IN
1265: ar_payment_schedules.discount_taken_earned%TYPE,
1266: p_unearned_discount IN
1267: ar_payment_schedules.discount_taken_unearned%TYPE,
1268: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
1269: p_gl_date IN ar_payment_schedules.gl_date%TYPE ) IS
1270: BEGIN
1271: IF PG_DEBUG in ('Y', 'C') THEN

Line 1268: p_apply_date IN ar_payment_schedules.gl_date%TYPE,

1264: p_earned_discount IN
1265: ar_payment_schedules.discount_taken_earned%TYPE,
1266: p_unearned_discount IN
1267: ar_payment_schedules.discount_taken_unearned%TYPE,
1268: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
1269: p_gl_date IN ar_payment_schedules.gl_date%TYPE ) IS
1270: BEGIN
1271: IF PG_DEBUG in ('Y', 'C') THEN
1272: arp_util.debug( 'arp_ps_util.validate_args_upd_inv_rel_cols()+' );

Line 1269: p_gl_date IN ar_payment_schedules.gl_date%TYPE ) IS

1265: ar_payment_schedules.discount_taken_earned%TYPE,
1266: p_unearned_discount IN
1267: ar_payment_schedules.discount_taken_unearned%TYPE,
1268: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
1269: p_gl_date IN ar_payment_schedules.gl_date%TYPE ) IS
1270: BEGIN
1271: IF PG_DEBUG in ('Y', 'C') THEN
1272: arp_util.debug( 'arp_ps_util.validate_args_upd_inv_rel_cols()+' );
1273: END IF;

Line 1352: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

1348: | HISTORY - Created By - Ganesh Vaidee - 08/24/1995 |
1349: | |
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

Line 1353: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,

1349: | |
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,

Line 1360: p_apply_date IN ar_payment_schedules.gl_date%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,
1364: p_ps_rec IN ar_payment_schedules%ROWTYPE,

Line 1361: p_gl_date IN ar_payment_schedules.gl_date%TYPE,

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,
1364: p_ps_rec IN ar_payment_schedules%ROWTYPE,
1365: p_update_credit_flag IN VARCHAR2 ) IS

Line 1364: p_ps_rec IN ar_payment_schedules%ROWTYPE,

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;
1368: --

Line 1367: l_ps_rec ar_payment_schedules%ROWTYPE;

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;
1368: --
1369: -- Variable to populate OUT NOCOPY arguments
1370: --
1371: l_acctd_amount_applied

Line 1378: ar_payment_schedules.amount_due_remaining%TYPE;

1374: --Introduced For Bug # 2711860
1375: -- ORASHID
1376: --
1377: l_nocopy_amt_due_remain
1378: ar_payment_schedules.amount_due_remaining%TYPE;
1379: l_nocopy_acctd_amt_due_remain
1380: ar_payment_schedules.acctd_amount_due_remaining%TYPE;
1381:
1382: BEGIN

Line 1380: ar_payment_schedules.acctd_amount_due_remaining%TYPE;

1376: --
1377: l_nocopy_amt_due_remain
1378: ar_payment_schedules.amount_due_remaining%TYPE;
1379: l_nocopy_acctd_amt_due_remain
1380: ar_payment_schedules.acctd_amount_due_remaining%TYPE;
1381:
1382: BEGIN
1383: IF PG_DEBUG in ('Y', 'C') THEN
1384: arp_util.debug( 'arp_ps_util.update_cm_related_columns()+' );

Line 1554: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

1550: | inclusive of tax component in case of Activity of type
1551: | Finance Charges having tax code source attached.
1552: +===========================================================================*/
1553: PROCEDURE update_adj_related_columns(
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,

Line 1556: p_amount_adjusted IN ar_payment_schedules.amount_adjusted%TYPE,

1552: +===========================================================================*/
1553: PROCEDURE update_adj_related_columns(
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,

Line 1557: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,

1553: PROCEDURE update_adj_related_columns(
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,

Line 1562: p_apply_date IN ar_payment_schedules.gl_date%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
1566: --

Line 1563: p_gl_date IN ar_payment_schedules.gl_date%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
1566: --
1567: -- deleted 'DEFAULT NULL' for p_ps_rec Rowtype attribute -bug460979 for Oracle8

Line 1565: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE) IS

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:
1569: l_ps_rec ar_payment_schedules%ROWTYPE;

Line 1569: l_ps_rec ar_payment_schedules%ROWTYPE;

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:
1569: l_ps_rec ar_payment_schedules%ROWTYPE;
1570: l_line_adjusted ar_payment_schedules.amount_adjusted%TYPE;
1571: l_tax_adjusted ar_payment_schedules.amount_adjusted%TYPE;
1572: l_freight_adjusted ar_payment_schedules.amount_adjusted%TYPE;
1573: l_charges_adjusted ar_payment_schedules.amount_adjusted%TYPE;

Line 1570: l_line_adjusted ar_payment_schedules.amount_adjusted%TYPE;

1566: --
1567: -- deleted 'DEFAULT NULL' for p_ps_rec Rowtype attribute -bug460979 for Oracle8
1568:
1569: l_ps_rec ar_payment_schedules%ROWTYPE;
1570: l_line_adjusted ar_payment_schedules.amount_adjusted%TYPE;
1571: l_tax_adjusted ar_payment_schedules.amount_adjusted%TYPE;
1572: l_freight_adjusted ar_payment_schedules.amount_adjusted%TYPE;
1573: l_charges_adjusted ar_payment_schedules.amount_adjusted%TYPE;
1574:

Line 1571: l_tax_adjusted ar_payment_schedules.amount_adjusted%TYPE;

1567: -- deleted 'DEFAULT NULL' for p_ps_rec Rowtype attribute -bug460979 for Oracle8
1568:
1569: l_ps_rec ar_payment_schedules%ROWTYPE;
1570: l_line_adjusted ar_payment_schedules.amount_adjusted%TYPE;
1571: l_tax_adjusted ar_payment_schedules.amount_adjusted%TYPE;
1572: l_freight_adjusted ar_payment_schedules.amount_adjusted%TYPE;
1573: l_charges_adjusted ar_payment_schedules.amount_adjusted%TYPE;
1574:
1575: -- Bug 1919595

Line 1572: l_freight_adjusted ar_payment_schedules.amount_adjusted%TYPE;

1568:
1569: l_ps_rec ar_payment_schedules%ROWTYPE;
1570: l_line_adjusted ar_payment_schedules.amount_adjusted%TYPE;
1571: l_tax_adjusted ar_payment_schedules.amount_adjusted%TYPE;
1572: l_freight_adjusted ar_payment_schedules.amount_adjusted%TYPE;
1573: l_charges_adjusted ar_payment_schedules.amount_adjusted%TYPE;
1574:
1575: -- Bug 1919595
1576: -- Define four variables to hold the amounts remaining for line, tax, freight and charges

Line 1573: l_charges_adjusted ar_payment_schedules.amount_adjusted%TYPE;

1569: l_ps_rec ar_payment_schedules%ROWTYPE;
1570: l_line_adjusted ar_payment_schedules.amount_adjusted%TYPE;
1571: l_tax_adjusted ar_payment_schedules.amount_adjusted%TYPE;
1572: l_freight_adjusted ar_payment_schedules.amount_adjusted%TYPE;
1573: l_charges_adjusted ar_payment_schedules.amount_adjusted%TYPE;
1574:
1575: -- Bug 1919595
1576: -- Define four variables to hold the amounts remaining for line, tax, freight and charges
1577: l_line_for_adj ar_payment_schedules.amount_line_items_remaining%TYPE;

Line 1577: l_line_for_adj ar_payment_schedules.amount_line_items_remaining%TYPE;

1573: l_charges_adjusted ar_payment_schedules.amount_adjusted%TYPE;
1574:
1575: -- Bug 1919595
1576: -- Define four variables to hold the amounts remaining for line, tax, freight and charges
1577: l_line_for_adj ar_payment_schedules.amount_line_items_remaining%TYPE;
1578: l_tax_for_adj ar_payment_schedules.tax_remaining%TYPE;
1579: l_freight_for_adj ar_payment_schedules.freight_remaining%TYPE;
1580: l_charges_for_adj ar_payment_schedules.receivables_charges_remaining%TYPE;
1581:

Line 1578: l_tax_for_adj ar_payment_schedules.tax_remaining%TYPE;

1574:
1575: -- Bug 1919595
1576: -- Define four variables to hold the amounts remaining for line, tax, freight and charges
1577: l_line_for_adj ar_payment_schedules.amount_line_items_remaining%TYPE;
1578: l_tax_for_adj ar_payment_schedules.tax_remaining%TYPE;
1579: l_freight_for_adj ar_payment_schedules.freight_remaining%TYPE;
1580: l_charges_for_adj ar_payment_schedules.receivables_charges_remaining%TYPE;
1581:
1582: --

Line 1579: l_freight_for_adj ar_payment_schedules.freight_remaining%TYPE;

1575: -- Bug 1919595
1576: -- Define four variables to hold the amounts remaining for line, tax, freight and charges
1577: l_line_for_adj ar_payment_schedules.amount_line_items_remaining%TYPE;
1578: l_tax_for_adj ar_payment_schedules.tax_remaining%TYPE;
1579: l_freight_for_adj ar_payment_schedules.freight_remaining%TYPE;
1580: l_charges_for_adj ar_payment_schedules.receivables_charges_remaining%TYPE;
1581:
1582: --
1583: -- Variable to populate OUT NOCOPY arguments

Line 1580: l_charges_for_adj ar_payment_schedules.receivables_charges_remaining%TYPE;

1576: -- Define four variables to hold the amounts remaining for line, tax, freight and charges
1577: l_line_for_adj ar_payment_schedules.amount_line_items_remaining%TYPE;
1578: l_tax_for_adj ar_payment_schedules.tax_remaining%TYPE;
1579: l_freight_for_adj ar_payment_schedules.freight_remaining%TYPE;
1580: l_charges_for_adj ar_payment_schedules.receivables_charges_remaining%TYPE;
1581:
1582: --
1583: -- Variable to populate OUT NOCOPY arguments
1584: --

Line 1651: re-default from remaining amount in ar_payment_schedules

1647: +----------------------------------------------------------*/
1648:
1649: /* bug 2389772 : there are cases were amount to adjust is actually
1650: passed in as zero, in those cases we don't want the amount to
1651: re-default from remaining amount in ar_payment_schedules
1652:
1653: Define rem_adj_amt to contain total adjustment amount
1654: passed as parameter, while processing each adjustment type
1655: keep subtracting amount from rem_adj_amt, once rem_adj_amt hits 0

Line 1884: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

1880: | NOTES - At present this is an overloaded procedure |
1881: | |
1882: +===========================================================================*/
1883: PROCEDURE validate_args_upd_adj_rel_cols(
1884: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
1885: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
1886: p_gl_date IN ar_payment_schedules.gl_date%TYPE ) IS
1887: BEGIN
1888: IF PG_DEBUG in ('Y', 'C') THEN

Line 1885: p_apply_date IN ar_payment_schedules.gl_date%TYPE,

1881: | |
1882: +===========================================================================*/
1883: PROCEDURE validate_args_upd_adj_rel_cols(
1884: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
1885: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
1886: p_gl_date IN ar_payment_schedules.gl_date%TYPE ) IS
1887: BEGIN
1888: IF PG_DEBUG in ('Y', 'C') THEN
1889: arp_util.debug('update_adj_related_columns: ' || 'arp_ps_util.validate_args_upd_adj_rel_cols()+' );

Line 1886: p_gl_date IN ar_payment_schedules.gl_date%TYPE ) IS

1882: +===========================================================================*/
1883: PROCEDURE validate_args_upd_adj_rel_cols(
1884: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
1885: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
1886: p_gl_date IN ar_payment_schedules.gl_date%TYPE ) IS
1887: BEGIN
1888: IF PG_DEBUG in ('Y', 'C') THEN
1889: arp_util.debug('update_adj_related_columns: ' || 'arp_ps_util.validate_args_upd_adj_rel_cols()+' );
1890: END IF;

Line 1948: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

1944: |02/13/03 Ajay Pandit Made the p_ps_rec an IN OUT parameter |
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,

Line 1953: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%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,
1957: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE) IS

Line 1954: p_apply_date IN ar_payment_schedules.gl_date%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,
1957: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE) IS
1958: --

Line 1955: p_gl_date IN ar_payment_schedules.gl_date%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,
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

Line 1957: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE) IS

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:
1961: l_ps_rec ar_payment_schedules%ROWTYPE;

Line 1961: l_ps_rec ar_payment_schedules%ROWTYPE;

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:
1961: l_ps_rec ar_payment_schedules%ROWTYPE;
1962: l_amount_adjusted ar_payment_schedules.amount_adjusted%TYPE;
1963:
1964: --
1965: -- Variable to populate OUT NOCOPY arguments

Line 1962: l_amount_adjusted ar_payment_schedules.amount_adjusted%TYPE;

1958: --
1959: -- deleted 'DEFAULT NULL' for p_ps_rec Rowtype attribute -bug460979 for Oracle8
1960:
1961: l_ps_rec ar_payment_schedules%ROWTYPE;
1962: l_amount_adjusted ar_payment_schedules.amount_adjusted%TYPE;
1963:
1964: --
1965: -- Variable to populate OUT NOCOPY arguments
1966: --

Line 1974: ar_payment_schedules.amount_due_remaining%TYPE;

1970: --Introduced For Bug # 2711860
1971: -- ORASHID
1972: --
1973: l_nocopy_amt_due_remain
1974: ar_payment_schedules.amount_due_remaining%TYPE;
1975: l_nocopy_acctd_amt_due_remain
1976: ar_payment_schedules.acctd_amount_due_remaining%TYPE;
1977:
1978: BEGIN

Line 1976: ar_payment_schedules.acctd_amount_due_remaining%TYPE;

1972: --
1973: l_nocopy_amt_due_remain
1974: ar_payment_schedules.amount_due_remaining%TYPE;
1975: l_nocopy_acctd_amt_due_remain
1976: ar_payment_schedules.acctd_amount_due_remaining%TYPE;
1977:
1978: BEGIN
1979: IF PG_DEBUG in ('Y', 'C') THEN
1980: arp_util.debug( 'arp_ps_util.update_adj_related_columns()+' );

Line 2130: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

2126: | NOTES - |
2127: | |
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,

Line 2140: ar_payment_schedules.amount_adjusted_pending%TYPE,

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
2143: BEGIN
2144: IF PG_DEBUG in ('Y', 'C') THEN

Line 2141: p_apply_date IN ar_payment_schedules.gl_date%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
2143: BEGIN
2144: IF PG_DEBUG in ('Y', 'C') THEN
2145: arp_util.debug( 'arp_ps_util.validate_args_upd_adj_rel_cols()+' );

Line 2142: p_gl_date IN ar_payment_schedules.gl_date%TYPE ) IS

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
2143: BEGIN
2144: IF PG_DEBUG in ('Y', 'C') THEN
2145: arp_util.debug( 'arp_ps_util.validate_args_upd_adj_rel_cols()+' );
2146: END IF;

Line 2202: p_gl_date IN ar_payment_schedules.gl_date%TYPE,

2198: | HISTORY - Created By - Ganesh Vaidee - 08/24/1995 |
2199: | 16-APR-98 GJWANG Bug fix #653643 declare this as public procedure |
2200: +===========================================================================*/
2201: PROCEDURE populate_closed_dates(
2202: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
2203: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
2204: p_app_type IN VARCHAR2,
2205: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE ) IS
2206: --

Line 2203: p_apply_date IN ar_payment_schedules.gl_date%TYPE,

2199: | 16-APR-98 GJWANG Bug fix #653643 declare this as public procedure |
2200: +===========================================================================*/
2201: PROCEDURE populate_closed_dates(
2202: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
2203: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
2204: p_app_type IN VARCHAR2,
2205: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE ) IS
2206: --
2207: l_gl_date_closed ar_payment_schedules.gl_date%TYPE;

Line 2205: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE ) IS

2201: PROCEDURE populate_closed_dates(
2202: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
2203: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
2204: p_app_type IN VARCHAR2,
2205: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE ) IS
2206: --
2207: l_gl_date_closed ar_payment_schedules.gl_date%TYPE;
2208: l_actual_date_closed ar_payment_schedules.gl_date%TYPE;
2209: --

Line 2207: l_gl_date_closed ar_payment_schedules.gl_date%TYPE;

2203: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
2204: p_app_type IN VARCHAR2,
2205: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE ) IS
2206: --
2207: l_gl_date_closed ar_payment_schedules.gl_date%TYPE;
2208: l_actual_date_closed ar_payment_schedules.gl_date%TYPE;
2209: --
2210: BEGIN
2211: IF PG_DEBUG in ('Y', 'C') THEN

Line 2208: l_actual_date_closed ar_payment_schedules.gl_date%TYPE;

2204: p_app_type IN VARCHAR2,
2205: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE ) IS
2206: --
2207: l_gl_date_closed ar_payment_schedules.gl_date%TYPE;
2208: l_actual_date_closed ar_payment_schedules.gl_date%TYPE;
2209: --
2210: BEGIN
2211: IF PG_DEBUG in ('Y', 'C') THEN
2212: arp_util.debug( 'arp_util.populate_closed_dates()+' );