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_debug.debug( '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,

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,
351: p_maturity_date IN ar_payment_schedules.due_date%TYPE DEFAULT NULL,

Line 350: p_ps_rec IN ar_payment_schedules%ROWTYPE,

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

Line 351: p_maturity_date IN ar_payment_schedules.due_date%TYPE DEFAULT NULL,

347: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
348: p_acctd_amount_applied OUT NOCOPY
349: ar_receivable_applications.acctd_amount_applied_from%TYPE,
350: p_ps_rec IN ar_payment_schedules%ROWTYPE,
351: p_maturity_date IN ar_payment_schedules.due_date%TYPE DEFAULT NULL,
352: p_applied_ps_class IN ar_payment_schedules.class%TYPE DEFAULT NULL ) IS -- Bug 6924942
353: --
354: l_ps_rec ar_payment_schedules%ROWTYPE;
355: --

Line 352: p_applied_ps_class IN ar_payment_schedules.class%TYPE DEFAULT NULL ) IS -- Bug 6924942

348: p_acctd_amount_applied OUT NOCOPY
349: ar_receivable_applications.acctd_amount_applied_from%TYPE,
350: p_ps_rec IN ar_payment_schedules%ROWTYPE,
351: p_maturity_date IN ar_payment_schedules.due_date%TYPE DEFAULT NULL,
352: p_applied_ps_class IN ar_payment_schedules.class%TYPE DEFAULT NULL ) IS -- Bug 6924942
353: --
354: l_ps_rec ar_payment_schedules%ROWTYPE;
355: --
356: -- Variable to populate OUT NOCOPY arguments

Line 354: l_ps_rec ar_payment_schedules%ROWTYPE;

350: p_ps_rec IN ar_payment_schedules%ROWTYPE,
351: p_maturity_date IN ar_payment_schedules.due_date%TYPE DEFAULT NULL,
352: p_applied_ps_class IN ar_payment_schedules.class%TYPE DEFAULT NULL ) IS -- Bug 6924942
353: --
354: l_ps_rec ar_payment_schedules%ROWTYPE;
355: --
356: -- Variable to populate OUT NOCOPY arguments
357: --
358: l_acctd_amount_applied

Line 365: ar_payment_schedules.amount_due_remaining%TYPE;

361: --Introduced For Bug # 2711860
362: -- ORASHID
363: --
364: l_nocopy_amt_due_remain
365: ar_payment_schedules.amount_due_remaining%TYPE;
366: l_nocopy_acctd_amt_due_remain
367: ar_payment_schedules.acctd_amount_due_remaining%TYPE;
368:
369: -- Bug 6924942 - Start

Line 367: ar_payment_schedules.acctd_amount_due_remaining%TYPE;

363: --
364: l_nocopy_amt_due_remain
365: ar_payment_schedules.amount_due_remaining%TYPE;
366: l_nocopy_acctd_amt_due_remain
367: ar_payment_schedules.acctd_amount_due_remaining%TYPE;
368:
369: -- Bug 6924942 - Start
370: l_rows_accumulate_count number;
371: current_amt_app number;

Line 415: from ar_receivable_applications ra,ar_payment_schedules ps

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

Line 436: from ar_receivable_applications ra,ar_payment_schedules ps

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

Line 539: UPDATE ar_payment_schedules

535:
536: /* Bug 5569488, do not update payment schedule if the receipt requires
537: confirmation. Added the If condition */
538: IF NVL(l_ps_rec.receipt_confirmed_flag,'Y') <> 'N' THEN
539: UPDATE ar_payment_schedules
540: set acctd_amount_due_remaining = l_ps_rec.acctd_amount_due_remaining,
541: amount_due_remaining = l_ps_rec.amount_due_remaining,
542: amount_applied = l_ps_rec.amount_applied,
543: selected_for_receipt_batch_id = l_ps_rec.selected_for_receipt_batch_id,

Line 599: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

595: | NOTES - |
596: | |
597: +===========================================================================*/
598: PROCEDURE validate_args_upd_rel_cols(
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_apply_date IN ar_payment_schedules.gl_date%TYPE,
602: p_gl_date IN ar_payment_schedules.gl_date%TYPE ) IS
603: BEGIN

Line 600: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,

596: | |
597: +===========================================================================*/
598: PROCEDURE validate_args_upd_rel_cols(
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_apply_date IN ar_payment_schedules.gl_date%TYPE,
602: p_gl_date IN ar_payment_schedules.gl_date%TYPE ) IS
603: BEGIN
604: IF PG_DEBUG in ('Y', 'C') THEN

Line 601: p_apply_date IN ar_payment_schedules.gl_date%TYPE,

597: +===========================================================================*/
598: PROCEDURE validate_args_upd_rel_cols(
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_apply_date IN ar_payment_schedules.gl_date%TYPE,
602: p_gl_date IN ar_payment_schedules.gl_date%TYPE ) IS
603: BEGIN
604: IF PG_DEBUG in ('Y', 'C') THEN
605: arp_debug.debug( 'arp_ps_util.validate_args_upd_rel_cols()+' );

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

598: PROCEDURE validate_args_upd_rel_cols(
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_apply_date IN ar_payment_schedules.gl_date%TYPE,
602: p_gl_date IN ar_payment_schedules.gl_date%TYPE ) IS
603: BEGIN
604: IF PG_DEBUG in ('Y', 'C') THEN
605: arp_debug.debug( 'arp_ps_util.validate_args_upd_rel_cols()+' );
606: END IF;

Line 704: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

700: | calc_applied_and_remaining
701: +===========================================================================*/
702: PROCEDURE update_invoice_related_columns(
703: p_app_type IN VARCHAR2,
704: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
705: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
706: p_discount_taken_earned IN ar_payment_schedules.discount_taken_earned%TYPE,
707: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
708: p_apply_date IN ar_payment_schedules.gl_date%TYPE,

Line 705: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,

701: +===========================================================================*/
702: PROCEDURE update_invoice_related_columns(
703: p_app_type IN VARCHAR2,
704: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
705: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
706: p_discount_taken_earned IN ar_payment_schedules.discount_taken_earned%TYPE,
707: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
708: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
709: p_gl_date IN ar_payment_schedules.gl_date%TYPE,

Line 706: p_discount_taken_earned IN ar_payment_schedules.discount_taken_earned%TYPE,

702: PROCEDURE update_invoice_related_columns(
703: p_app_type IN VARCHAR2,
704: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
705: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
706: p_discount_taken_earned IN ar_payment_schedules.discount_taken_earned%TYPE,
707: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
708: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
709: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
710: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,

Line 707: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,

703: p_app_type IN VARCHAR2,
704: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
705: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
706: p_discount_taken_earned IN ar_payment_schedules.discount_taken_earned%TYPE,
707: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
708: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
709: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
710: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
711: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,

Line 708: p_apply_date IN ar_payment_schedules.gl_date%TYPE,

704: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
705: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
706: p_discount_taken_earned IN ar_payment_schedules.discount_taken_earned%TYPE,
707: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
708: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
709: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
710: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
711: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,
712: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,

Line 709: p_gl_date IN ar_payment_schedules.gl_date%TYPE,

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

Line 726: p_ps_rec IN ar_payment_schedules%ROWTYPE) IS

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

Line 846: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

842: | calc_applied_and_remaining
843: +===========================================================================*/
844: PROCEDURE update_invoice_related_columns(
845: p_app_type IN VARCHAR2,
846: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
847: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
848: p_discount_taken_earned IN ar_payment_schedules.discount_taken_earned%TYPE,
849: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
850: p_apply_date IN ar_payment_schedules.gl_date%TYPE,

Line 847: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,

843: +===========================================================================*/
844: PROCEDURE update_invoice_related_columns(
845: p_app_type IN VARCHAR2,
846: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
847: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
848: p_discount_taken_earned IN ar_payment_schedules.discount_taken_earned%TYPE,
849: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
850: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
851: p_gl_date IN ar_payment_schedules.gl_date%TYPE,

Line 848: p_discount_taken_earned IN ar_payment_schedules.discount_taken_earned%TYPE,

844: PROCEDURE update_invoice_related_columns(
845: p_app_type IN VARCHAR2,
846: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
847: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
848: p_discount_taken_earned IN ar_payment_schedules.discount_taken_earned%TYPE,
849: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
850: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
851: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
852: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,

Line 849: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,

845: p_app_type IN VARCHAR2,
846: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
847: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
848: p_discount_taken_earned IN ar_payment_schedules.discount_taken_earned%TYPE,
849: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
850: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
851: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
852: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
853: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,

Line 850: p_apply_date IN ar_payment_schedules.gl_date%TYPE,

846: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
847: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
848: p_discount_taken_earned IN ar_payment_schedules.discount_taken_earned%TYPE,
849: p_discount_taken_unearned IN ar_payment_schedules.discount_taken_unearned%TYPE,
850: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
851: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
852: p_acctd_amount_applied OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
853: p_acctd_earned_discount_taken OUT NOCOPY ar_receivable_applications.earned_discount_taken%TYPE,
854: p_acctd_unearned_disc_taken OUT NOCOPY ar_receivable_applications.acctd_unearned_discount_taken%TYPE,

Line 851: p_gl_date IN ar_payment_schedules.gl_date%TYPE,

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

Line 868: p_ps_rec IN ar_payment_schedules%ROWTYPE,

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

Line 876: l_ps_rec ar_payment_schedules%ROWTYPE;

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

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

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

Line 883: l_line_remaining ar_payment_schedules.tax_remaining%TYPE:=0;

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

Line 884: l_tax_remaining ar_payment_schedules.tax_remaining%TYPE:=0;

880: l_line_discounted ar_receivable_applications.line_applied%TYPE:=0;
881: l_charges_discounted
882: ar_receivable_applications.receivables_charges_applied%TYPE:=0;
883: l_line_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
884: l_tax_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
885: l_rec_charges_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
886: l_freight_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
887: --
888: -- Variable to populate OUT NOCOPY arguments

Line 885: l_rec_charges_remaining ar_payment_schedules.tax_remaining%TYPE:=0;

881: l_charges_discounted
882: ar_receivable_applications.receivables_charges_applied%TYPE:=0;
883: l_line_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
884: l_tax_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
885: l_rec_charges_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
886: l_freight_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
887: --
888: -- Variable to populate OUT NOCOPY arguments
889: -- We need these variables, 'cos the remaining LINE, TAX, FREIGHT and CHARGES

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

882: ar_receivable_applications.receivables_charges_applied%TYPE:=0;
883: l_line_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
884: l_tax_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
885: l_rec_charges_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
886: l_freight_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
887: --
888: -- Variable to populate OUT NOCOPY arguments
889: -- We need these variables, 'cos the remaining LINE, TAX, FREIGHT and CHARGES
890: -- amounts are calculated based on the applied amounts and applied discounts

Line 919: ar_payment_schedules.amount_due_remaining%TYPE;

915: --Introduced For Bug # 2711860
916: -- ORASHID
917: --
918: l_nocopy_amt_due_remain
919: ar_payment_schedules.amount_due_remaining%TYPE;
920: l_nocopy_acctd_amt_due_remain
921: ar_payment_schedules.acctd_amount_due_remaining%TYPE;
922:
923: -- 5569488

Line 921: ar_payment_schedules.acctd_amount_due_remaining%TYPE;

917: --
918: l_nocopy_amt_due_remain
919: ar_payment_schedules.amount_due_remaining%TYPE;
920: l_nocopy_acctd_amt_due_remain
921: ar_payment_schedules.acctd_amount_due_remaining%TYPE;
922:
923: -- 5569488
924: l_receipt_confirmed_flag ar_payment_schedules.receipt_confirmed_flag%TYPE ;
925:

Line 924: l_receipt_confirmed_flag ar_payment_schedules.receipt_confirmed_flag%TYPE ;

920: l_nocopy_acctd_amt_due_remain
921: ar_payment_schedules.acctd_amount_due_remaining%TYPE;
922:
923: -- 5569488
924: l_receipt_confirmed_flag ar_payment_schedules.receipt_confirmed_flag%TYPE ;
925:
926: /* 5677984 - locals for etax calls */
927: l_ebt_customer_trx_id ar_payment_schedules.customer_trx_id%TYPE;
928: l_ebt_discount_amt NUMBER;

Line 927: l_ebt_customer_trx_id ar_payment_schedules.customer_trx_id%TYPE;

923: -- 5569488
924: l_receipt_confirmed_flag ar_payment_schedules.receipt_confirmed_flag%TYPE ;
925:
926: /* 5677984 - locals for etax calls */
927: l_ebt_customer_trx_id ar_payment_schedules.customer_trx_id%TYPE;
928: l_ebt_discount_amt NUMBER;
929: l_ebt_gt_id NUMBER;
930: l_ebt_prorated_line NUMBER;
931: l_ebt_prorated_tax NUMBER;

Line 969: AR_PAYMENT_SCHEDULES ps,

965: BEGIN
966: SELECT ctt.allow_overapplication_flag
967: INTO arp_util.PG_OVERAPP_ALLOW_FLAG
968: FROM RA_CUST_TRX_TYPES ctt,
969: AR_PAYMENT_SCHEDULES ps,
970: RA_CUSTOMER_TRX ct
971: WHERE ps.customer_trx_id = ct.customer_trx_id
972: AND ct.cust_trx_type_id = ctt.cust_trx_type_id
973: AND ct.org_id = ctt.org_id

Line 1023: FROM ar_payment_schedules

1019: THEN
1020: /* set up local variables for call */
1021: SELECT customer_trx_id
1022: INTO l_ebt_customer_trx_id
1023: FROM ar_payment_schedules
1024: WHERE payment_schedule_id = p_ps_id;
1025:
1026: l_ebt_discount_amt := l_line_ediscounted + l_tax_ediscounted;
1027:

Line 1087: FROM ar_payment_schedules

1083: IF l_ebt_customer_trx_id IS NULL
1084: THEN
1085: SELECT customer_trx_id
1086: INTO l_ebt_customer_trx_id
1087: FROM ar_payment_schedules
1088: WHERE payment_schedule_id = p_ps_id;
1089: END IF;
1090:
1091: l_ebt_discount_amt := l_line_uediscounted + l_tax_uediscounted;

Line 1319: from ar_payment_schedules_all

1315: confirmation. Added the If condition */
1316: IF p_ps_rec.cash_receipt_id IS NOT NULL THEN
1317: Select receipt_confirmed_flag
1318: into l_receipt_confirmed_flag
1319: from ar_payment_schedules_all
1320: where cash_receipt_id = p_ps_rec.cash_receipt_id ;
1321: END IF ;
1322: IF NVL(l_receipt_confirmed_flag,'Y') <> 'N' THEN
1323: arp_ps_pkg.update_p( l_ps_rec );

Line 1392: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

1388: | NOTES - |
1389: | |
1390: +===========================================================================*/
1391: PROCEDURE validate_args_upd_inv_rel_cols(
1392: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
1393: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
1394: p_earned_discount IN
1395: ar_payment_schedules.discount_taken_earned%TYPE,
1396: p_unearned_discount IN

Line 1393: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,

1389: | |
1390: +===========================================================================*/
1391: PROCEDURE validate_args_upd_inv_rel_cols(
1392: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
1393: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
1394: p_earned_discount IN
1395: ar_payment_schedules.discount_taken_earned%TYPE,
1396: p_unearned_discount IN
1397: ar_payment_schedules.discount_taken_unearned%TYPE,

Line 1395: ar_payment_schedules.discount_taken_earned%TYPE,

1391: PROCEDURE validate_args_upd_inv_rel_cols(
1392: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
1393: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
1394: p_earned_discount IN
1395: ar_payment_schedules.discount_taken_earned%TYPE,
1396: p_unearned_discount IN
1397: ar_payment_schedules.discount_taken_unearned%TYPE,
1398: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
1399: p_gl_date IN ar_payment_schedules.gl_date%TYPE ) IS

Line 1397: ar_payment_schedules.discount_taken_unearned%TYPE,

1393: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
1394: p_earned_discount IN
1395: ar_payment_schedules.discount_taken_earned%TYPE,
1396: p_unearned_discount IN
1397: ar_payment_schedules.discount_taken_unearned%TYPE,
1398: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
1399: p_gl_date IN ar_payment_schedules.gl_date%TYPE ) IS
1400: BEGIN
1401: IF PG_DEBUG in ('Y', 'C') THEN

Line 1398: p_apply_date IN ar_payment_schedules.gl_date%TYPE,

1394: p_earned_discount IN
1395: ar_payment_schedules.discount_taken_earned%TYPE,
1396: p_unearned_discount IN
1397: ar_payment_schedules.discount_taken_unearned%TYPE,
1398: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
1399: p_gl_date IN ar_payment_schedules.gl_date%TYPE ) IS
1400: BEGIN
1401: IF PG_DEBUG in ('Y', 'C') THEN
1402: arp_debug.debug( 'arp_ps_util.validate_args_upd_inv_rel_cols()+' );

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

1395: ar_payment_schedules.discount_taken_earned%TYPE,
1396: p_unearned_discount IN
1397: ar_payment_schedules.discount_taken_unearned%TYPE,
1398: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
1399: p_gl_date IN ar_payment_schedules.gl_date%TYPE ) IS
1400: BEGIN
1401: IF PG_DEBUG in ('Y', 'C') THEN
1402: arp_debug.debug( 'arp_ps_util.validate_args_upd_inv_rel_cols()+' );
1403: END IF;

Line 1482: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

1478: | HISTORY - Created By - Ganesh Vaidee - 08/24/1995 |
1479: | |
1480: +===========================================================================*/
1481: PROCEDURE update_cm_related_columns(
1482: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
1483: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,
1484: p_line_applied IN ar_receivable_applications.line_applied%TYPE,
1485: p_tax_applied IN ar_receivable_applications.tax_applied%TYPE,
1486: p_freight_applied IN

Line 1483: p_amount_applied IN ar_payment_schedules.amount_applied%TYPE,

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

Line 1490: p_apply_date IN ar_payment_schedules.gl_date%TYPE,

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

Line 1491: p_gl_date IN ar_payment_schedules.gl_date%TYPE,

1487: ar_receivable_applications.freight_applied%TYPE,
1488: p_charges_applied IN
1489: ar_receivable_applications.receivables_charges_applied%TYPE,
1490: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
1491: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
1492: p_acctd_amount_applied OUT NOCOPY
1493: ar_receivable_applications.acctd_amount_applied_to%TYPE,
1494: p_ps_rec IN ar_payment_schedules%ROWTYPE,
1495: p_update_credit_flag IN VARCHAR2 ) IS

Line 1494: p_ps_rec IN ar_payment_schedules%ROWTYPE,

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

Line 1497: l_ps_rec ar_payment_schedules%ROWTYPE;

1493: ar_receivable_applications.acctd_amount_applied_to%TYPE,
1494: p_ps_rec IN ar_payment_schedules%ROWTYPE,
1495: p_update_credit_flag IN VARCHAR2 ) IS
1496: --
1497: l_ps_rec ar_payment_schedules%ROWTYPE;
1498: --
1499: -- Variable to populate OUT NOCOPY arguments
1500: --
1501: l_acctd_amount_applied

Line 1508: ar_payment_schedules.amount_due_remaining%TYPE;

1504: --Introduced For Bug # 2711860
1505: -- ORASHID
1506: --
1507: l_nocopy_amt_due_remain
1508: ar_payment_schedules.amount_due_remaining%TYPE;
1509: l_nocopy_acctd_amt_due_remain
1510: ar_payment_schedules.acctd_amount_due_remaining%TYPE;
1511:
1512: BEGIN

Line 1510: ar_payment_schedules.acctd_amount_due_remaining%TYPE;

1506: --
1507: l_nocopy_amt_due_remain
1508: ar_payment_schedules.amount_due_remaining%TYPE;
1509: l_nocopy_acctd_amt_due_remain
1510: ar_payment_schedules.acctd_amount_due_remaining%TYPE;
1511:
1512: BEGIN
1513: IF PG_DEBUG in ('Y', 'C') THEN
1514: arp_debug.debug( 'arp_ps_util.update_cm_related_columns()+' );

Line 1684: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

1680: | inclusive of tax component in case of Activity of type
1681: | Finance Charges having tax code source attached.
1682: +===========================================================================*/
1683: PROCEDURE update_adj_related_columns(
1684: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
1685: p_type IN ar_adjustments.type%TYPE,
1686: p_amount_adjusted IN ar_payment_schedules.amount_adjusted%TYPE,
1687: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,
1688: p_line_adjusted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,

Line 1686: p_amount_adjusted IN ar_payment_schedules.amount_adjusted%TYPE,

1682: +===========================================================================*/
1683: PROCEDURE update_adj_related_columns(
1684: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
1685: p_type IN ar_adjustments.type%TYPE,
1686: p_amount_adjusted IN ar_payment_schedules.amount_adjusted%TYPE,
1687: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,
1688: p_line_adjusted IN OUT NOCOPY ar_receivable_applications.line_applied%TYPE,
1689: p_tax_adjusted IN OUT NOCOPY ar_receivable_applications.tax_applied%TYPE,
1690: p_freight_adjusted IN OUT NOCOPY ar_receivable_applications.freight_applied%TYPE,

Line 1687: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,

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

Line 1692: p_apply_date IN ar_payment_schedules.gl_date%TYPE,

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

Line 1693: p_gl_date IN ar_payment_schedules.gl_date%TYPE,

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

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

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

Line 1699: l_ps_rec ar_payment_schedules%ROWTYPE;

1695: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE) IS
1696: --
1697: -- deleted 'DEFAULT NULL' for p_ps_rec Rowtype attribute -bug460979 for Oracle8
1698:
1699: l_ps_rec ar_payment_schedules%ROWTYPE;
1700: l_line_adjusted ar_payment_schedules.amount_adjusted%TYPE;
1701: l_tax_adjusted ar_payment_schedules.amount_adjusted%TYPE;
1702: l_freight_adjusted ar_payment_schedules.amount_adjusted%TYPE;
1703: l_charges_adjusted ar_payment_schedules.amount_adjusted%TYPE;

Line 1700: l_line_adjusted ar_payment_schedules.amount_adjusted%TYPE;

1696: --
1697: -- deleted 'DEFAULT NULL' for p_ps_rec Rowtype attribute -bug460979 for Oracle8
1698:
1699: l_ps_rec ar_payment_schedules%ROWTYPE;
1700: l_line_adjusted ar_payment_schedules.amount_adjusted%TYPE;
1701: l_tax_adjusted ar_payment_schedules.amount_adjusted%TYPE;
1702: l_freight_adjusted ar_payment_schedules.amount_adjusted%TYPE;
1703: l_charges_adjusted ar_payment_schedules.amount_adjusted%TYPE;
1704:

Line 1701: l_tax_adjusted ar_payment_schedules.amount_adjusted%TYPE;

1697: -- deleted 'DEFAULT NULL' for p_ps_rec Rowtype attribute -bug460979 for Oracle8
1698:
1699: l_ps_rec ar_payment_schedules%ROWTYPE;
1700: l_line_adjusted ar_payment_schedules.amount_adjusted%TYPE;
1701: l_tax_adjusted ar_payment_schedules.amount_adjusted%TYPE;
1702: l_freight_adjusted ar_payment_schedules.amount_adjusted%TYPE;
1703: l_charges_adjusted ar_payment_schedules.amount_adjusted%TYPE;
1704:
1705: -- Bug 1919595

Line 1702: l_freight_adjusted ar_payment_schedules.amount_adjusted%TYPE;

1698:
1699: l_ps_rec ar_payment_schedules%ROWTYPE;
1700: l_line_adjusted ar_payment_schedules.amount_adjusted%TYPE;
1701: l_tax_adjusted ar_payment_schedules.amount_adjusted%TYPE;
1702: l_freight_adjusted ar_payment_schedules.amount_adjusted%TYPE;
1703: l_charges_adjusted ar_payment_schedules.amount_adjusted%TYPE;
1704:
1705: -- Bug 1919595
1706: -- Define four variables to hold the amounts remaining for line, tax, freight and charges

Line 1703: l_charges_adjusted ar_payment_schedules.amount_adjusted%TYPE;

1699: l_ps_rec ar_payment_schedules%ROWTYPE;
1700: l_line_adjusted ar_payment_schedules.amount_adjusted%TYPE;
1701: l_tax_adjusted ar_payment_schedules.amount_adjusted%TYPE;
1702: l_freight_adjusted ar_payment_schedules.amount_adjusted%TYPE;
1703: l_charges_adjusted ar_payment_schedules.amount_adjusted%TYPE;
1704:
1705: -- Bug 1919595
1706: -- Define four variables to hold the amounts remaining for line, tax, freight and charges
1707: l_line_for_adj ar_payment_schedules.amount_line_items_remaining%TYPE;

Line 1707: l_line_for_adj ar_payment_schedules.amount_line_items_remaining%TYPE;

1703: l_charges_adjusted ar_payment_schedules.amount_adjusted%TYPE;
1704:
1705: -- Bug 1919595
1706: -- Define four variables to hold the amounts remaining for line, tax, freight and charges
1707: l_line_for_adj ar_payment_schedules.amount_line_items_remaining%TYPE;
1708: l_tax_for_adj ar_payment_schedules.tax_remaining%TYPE;
1709: l_freight_for_adj ar_payment_schedules.freight_remaining%TYPE;
1710: l_charges_for_adj ar_payment_schedules.receivables_charges_remaining%TYPE;
1711:

Line 1708: l_tax_for_adj ar_payment_schedules.tax_remaining%TYPE;

1704:
1705: -- Bug 1919595
1706: -- Define four variables to hold the amounts remaining for line, tax, freight and charges
1707: l_line_for_adj ar_payment_schedules.amount_line_items_remaining%TYPE;
1708: l_tax_for_adj ar_payment_schedules.tax_remaining%TYPE;
1709: l_freight_for_adj ar_payment_schedules.freight_remaining%TYPE;
1710: l_charges_for_adj ar_payment_schedules.receivables_charges_remaining%TYPE;
1711:
1712: --

Line 1709: l_freight_for_adj ar_payment_schedules.freight_remaining%TYPE;

1705: -- Bug 1919595
1706: -- Define four variables to hold the amounts remaining for line, tax, freight and charges
1707: l_line_for_adj ar_payment_schedules.amount_line_items_remaining%TYPE;
1708: l_tax_for_adj ar_payment_schedules.tax_remaining%TYPE;
1709: l_freight_for_adj ar_payment_schedules.freight_remaining%TYPE;
1710: l_charges_for_adj ar_payment_schedules.receivables_charges_remaining%TYPE;
1711:
1712: --
1713: -- Variable to populate OUT NOCOPY arguments

Line 1710: l_charges_for_adj ar_payment_schedules.receivables_charges_remaining%TYPE;

1706: -- Define four variables to hold the amounts remaining for line, tax, freight and charges
1707: l_line_for_adj ar_payment_schedules.amount_line_items_remaining%TYPE;
1708: l_tax_for_adj ar_payment_schedules.tax_remaining%TYPE;
1709: l_freight_for_adj ar_payment_schedules.freight_remaining%TYPE;
1710: l_charges_for_adj ar_payment_schedules.receivables_charges_remaining%TYPE;
1711:
1712: --
1713: -- Variable to populate OUT NOCOPY arguments
1714: --

Line 1781: re-default from remaining amount in ar_payment_schedules

1777: +----------------------------------------------------------*/
1778:
1779: /* bug 2389772 : there are cases were amount to adjust is actually
1780: passed in as zero, in those cases we don't want the amount to
1781: re-default from remaining amount in ar_payment_schedules
1782:
1783: Define rem_adj_amt to contain total adjustment amount
1784: passed as parameter, while processing each adjustment type
1785: keep subtracting amount from rem_adj_amt, once rem_adj_amt hits 0

Line 2014: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

2010: | NOTES - At present this is an overloaded procedure |
2011: | |
2012: +===========================================================================*/
2013: PROCEDURE validate_args_upd_adj_rel_cols(
2014: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
2015: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
2016: p_gl_date IN ar_payment_schedules.gl_date%TYPE ) IS
2017: BEGIN
2018: IF PG_DEBUG in ('Y', 'C') THEN

Line 2015: p_apply_date IN ar_payment_schedules.gl_date%TYPE,

2011: | |
2012: +===========================================================================*/
2013: PROCEDURE validate_args_upd_adj_rel_cols(
2014: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
2015: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
2016: p_gl_date IN ar_payment_schedules.gl_date%TYPE ) IS
2017: BEGIN
2018: IF PG_DEBUG in ('Y', 'C') THEN
2019: arp_debug.debug( 'arp_ps_util.validate_args_upd_adj_rel_cols()+' );

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

2012: +===========================================================================*/
2013: PROCEDURE validate_args_upd_adj_rel_cols(
2014: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
2015: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
2016: p_gl_date IN ar_payment_schedules.gl_date%TYPE ) IS
2017: BEGIN
2018: IF PG_DEBUG in ('Y', 'C') THEN
2019: arp_debug.debug( 'arp_ps_util.validate_args_upd_adj_rel_cols()+' );
2020: END IF;

Line 2078: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

2074: |02/13/03 Ajay Pandit Made the p_ps_rec an IN OUT parameter |
2075: +===========================================================================*/
2076:
2077: PROCEDURE update_adj_related_columns(
2078: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
2079: p_line_adjusted IN ar_receivable_applications.line_applied%TYPE,
2080: p_tax_adjusted IN ar_receivable_applications.tax_applied%TYPE,
2081: p_freight_adjusted IN ar_receivable_applications.freight_applied%TYPE,
2082: p_charges_adjusted IN ar_receivable_applications.receivables_charges_applied%TYPE,

Line 2083: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,

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

Line 2084: p_apply_date IN ar_payment_schedules.gl_date%TYPE,

2080: p_tax_adjusted IN ar_receivable_applications.tax_applied%TYPE,
2081: p_freight_adjusted IN ar_receivable_applications.freight_applied%TYPE,
2082: p_charges_adjusted IN ar_receivable_applications.receivables_charges_applied%TYPE,
2083: p_amount_adjusted_pending IN ar_payment_schedules.amount_adjusted_pending%TYPE,
2084: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
2085: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
2086: p_acctd_amount_adjusted OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE,
2087: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE) IS
2088: --

Line 2085: p_gl_date IN ar_payment_schedules.gl_date%TYPE,

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

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

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

Line 2091: l_ps_rec ar_payment_schedules%ROWTYPE;

2087: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE) IS
2088: --
2089: -- deleted 'DEFAULT NULL' for p_ps_rec Rowtype attribute -bug460979 for Oracle8
2090:
2091: l_ps_rec ar_payment_schedules%ROWTYPE;
2092: l_amount_adjusted ar_payment_schedules.amount_adjusted%TYPE;
2093:
2094: --
2095: -- Variable to populate OUT NOCOPY arguments

Line 2092: l_amount_adjusted ar_payment_schedules.amount_adjusted%TYPE;

2088: --
2089: -- deleted 'DEFAULT NULL' for p_ps_rec Rowtype attribute -bug460979 for Oracle8
2090:
2091: l_ps_rec ar_payment_schedules%ROWTYPE;
2092: l_amount_adjusted ar_payment_schedules.amount_adjusted%TYPE;
2093:
2094: --
2095: -- Variable to populate OUT NOCOPY arguments
2096: --

Line 2104: ar_payment_schedules.amount_due_remaining%TYPE;

2100: --Introduced For Bug # 2711860
2101: -- ORASHID
2102: --
2103: l_nocopy_amt_due_remain
2104: ar_payment_schedules.amount_due_remaining%TYPE;
2105: l_nocopy_acctd_amt_due_remain
2106: ar_payment_schedules.acctd_amount_due_remaining%TYPE;
2107:
2108: BEGIN

Line 2106: ar_payment_schedules.acctd_amount_due_remaining%TYPE;

2102: --
2103: l_nocopy_amt_due_remain
2104: ar_payment_schedules.amount_due_remaining%TYPE;
2105: l_nocopy_acctd_amt_due_remain
2106: ar_payment_schedules.acctd_amount_due_remaining%TYPE;
2107:
2108: BEGIN
2109: IF PG_DEBUG in ('Y', 'C') THEN
2110: arp_debug.debug( 'arp_ps_util.update_adj_related_columns()+' );

Line 2260: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

2256: | NOTES - |
2257: | |
2258: +===========================================================================*/
2259: PROCEDURE validate_args_upd_adj_rel_cols(
2260: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
2261: p_line_adjusted IN
2262: ar_receivable_applications.line_applied%TYPE,
2263: p_tax_adjusted IN
2264: ar_receivable_applications.tax_applied%TYPE,

Line 2270: ar_payment_schedules.amount_adjusted_pending%TYPE,

2266: ar_receivable_applications.freight_applied%TYPE,
2267: p_charges_adjusted IN
2268: ar_receivable_applications.receivables_charges_applied%TYPE,
2269: p_amount_adjusted_pending IN
2270: ar_payment_schedules.amount_adjusted_pending%TYPE,
2271: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
2272: p_gl_date IN ar_payment_schedules.gl_date%TYPE ) IS
2273: BEGIN
2274: IF PG_DEBUG in ('Y', 'C') THEN

Line 2271: p_apply_date IN ar_payment_schedules.gl_date%TYPE,

2267: p_charges_adjusted IN
2268: ar_receivable_applications.receivables_charges_applied%TYPE,
2269: p_amount_adjusted_pending IN
2270: ar_payment_schedules.amount_adjusted_pending%TYPE,
2271: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
2272: p_gl_date IN ar_payment_schedules.gl_date%TYPE ) IS
2273: BEGIN
2274: IF PG_DEBUG in ('Y', 'C') THEN
2275: arp_debug.debug( 'arp_ps_util.validate_args_upd_adj_rel_cols()+' );

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

2268: ar_receivable_applications.receivables_charges_applied%TYPE,
2269: p_amount_adjusted_pending IN
2270: ar_payment_schedules.amount_adjusted_pending%TYPE,
2271: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
2272: p_gl_date IN ar_payment_schedules.gl_date%TYPE ) IS
2273: BEGIN
2274: IF PG_DEBUG in ('Y', 'C') THEN
2275: arp_debug.debug( 'arp_ps_util.validate_args_upd_adj_rel_cols()+' );
2276: END IF;

Line 2332: p_gl_date IN ar_payment_schedules.gl_date%TYPE,

2328: | HISTORY - Created By - Ganesh Vaidee - 08/24/1995 |
2329: | 16-APR-98 GJWANG Bug fix #653643 declare this as public procedure |
2330: +===========================================================================*/
2331: PROCEDURE populate_closed_dates(
2332: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
2333: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
2334: p_app_type IN VARCHAR2,
2335: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE ) IS
2336: --

Line 2333: p_apply_date IN ar_payment_schedules.gl_date%TYPE,

2329: | 16-APR-98 GJWANG Bug fix #653643 declare this as public procedure |
2330: +===========================================================================*/
2331: PROCEDURE populate_closed_dates(
2332: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
2333: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
2334: p_app_type IN VARCHAR2,
2335: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE ) IS
2336: --
2337: l_gl_date_closed ar_payment_schedules.gl_date%TYPE;

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

2331: PROCEDURE populate_closed_dates(
2332: p_gl_date IN ar_payment_schedules.gl_date%TYPE,
2333: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
2334: p_app_type IN VARCHAR2,
2335: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE ) IS
2336: --
2337: l_gl_date_closed ar_payment_schedules.gl_date%TYPE;
2338: l_actual_date_closed ar_payment_schedules.gl_date%TYPE;
2339: --

Line 2337: l_gl_date_closed ar_payment_schedules.gl_date%TYPE;

2333: p_apply_date IN ar_payment_schedules.gl_date%TYPE,
2334: p_app_type IN VARCHAR2,
2335: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE ) IS
2336: --
2337: l_gl_date_closed ar_payment_schedules.gl_date%TYPE;
2338: l_actual_date_closed ar_payment_schedules.gl_date%TYPE;
2339: --
2340: BEGIN
2341: IF PG_DEBUG in ('Y', 'C') THEN

Line 2338: l_actual_date_closed ar_payment_schedules.gl_date%TYPE;

2334: p_app_type IN VARCHAR2,
2335: p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE ) IS
2336: --
2337: l_gl_date_closed ar_payment_schedules.gl_date%TYPE;
2338: l_actual_date_closed ar_payment_schedules.gl_date%TYPE;
2339: --
2340: BEGIN
2341: IF PG_DEBUG in ('Y', 'C') THEN
2342: arp_debug.debug( 'arp_util.populate_closed_dates()+' );