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_PROCESS_APPLICATION dependencies on AR_PAYMENT_SCHEDULES

Line 18: NULL_VAR ar_payment_schedules%ROWTYPE; /* Added for Bug 460959 for Oracle 8 */

14: --
15: -- Private procedures used by the package
16: --
17:
18: NULL_VAR ar_payment_schedules%ROWTYPE; /* Added for Bug 460959 for Oracle 8 */
19: --
20: FUNCTION check_reversable (
21: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,
22: p_module_name IN VARCHAR2,

Line 28: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

24: --
25: PROCEDURE reverse_action(
26: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,
27: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
28: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
29: p_reversal_gl_date IN DATE
30: , p_reversal_date IN DATE,
31: P_SELECT_FLAG IN BOOLEAN,
32: P_MODULE_NAME IN VARCHAR2,

Line 64: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

60: --
61: PROCEDURE validate_reverse_action_args(
62: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,
63: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
64: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
65: p_reversal_gl_date IN DATE, p_reversal_date IN DATE,
66: p_select_flag IN BOOLEAN );
67: --
68: PROCEDURE validate_args_appdel(

Line 72: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

68: PROCEDURE validate_args_appdel(
69: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE );
70: --
71: PROCEDURE validate_receipt_appln_args(
72: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
73: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
74: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
75: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE,
76: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE,

Line 73: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

69: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE );
70: --
71: PROCEDURE validate_receipt_appln_args(
72: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
73: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
74: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
75: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE,
76: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE,
77: p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

Line 77: p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

73: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
74: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
75: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE,
76: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE,
77: p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
78: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,
79: p_earned_discount_taken IN ar_receivable_applications.earned_discount_taken%TYPE,
80: p_unearned_discount_taken IN ar_receivable_applications.unearned_discount_taken%TYPE,
81: p_apply_date IN ar_receivable_applications.apply_date%TYPE,

Line 85: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

81: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
82: p_gl_date IN ar_receivable_applications.gl_date%TYPE );
83: --
84: PROCEDURE validate_cm_appln_args(
85: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
86: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
87: p_amount_applied IN
88: ar_receivable_applications.amount_applied%TYPE,
89: p_apply_date IN ar_receivable_applications.apply_date%TYPE,

Line 86: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

82: p_gl_date IN ar_receivable_applications.gl_date%TYPE );
83: --
84: PROCEDURE validate_cm_appln_args(
85: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
86: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
87: p_amount_applied IN
88: ar_receivable_applications.amount_applied%TYPE,
89: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
90: p_gl_date IN ar_receivable_applications.gl_date%TYPE );

Line 93: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

89: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
90: p_gl_date IN ar_receivable_applications.gl_date%TYPE );
91: --
92: PROCEDURE validate_on_account_args(
93: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
94: p_amount_applied IN
95: ar_receivable_applications.amount_applied%TYPE,
96: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
97: p_gl_date IN ar_receivable_applications.gl_date%TYPE );

Line 100: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

96: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
97: p_gl_date IN ar_receivable_applications.gl_date%TYPE );
98:
99: PROCEDURE validate_activity_args(
100: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
101: p_application_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
102: p_link_to_customer_trx_id IN ar_receivable_applications.link_to_customer_trx_id%TYPE,
103: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
104: p_apply_date IN ar_receivable_applications.apply_date%TYPE,

Line 211: l_ps_rec ar_payment_schedules%ROWTYPE;

207: , p_called_from IN VARCHAR2) IS /* jrautiai BR implementation */
208:
209: l_ra_rec ar_receivable_applications%ROWTYPE;
210: l_return_code VARCHAR2(20);
211: l_ps_rec ar_payment_schedules%ROWTYPE;
212: ln_batch_id NUMBER;
213: l_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;
214: l_bal_due_rem NUMBER;
215:

Line 213: l_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;

209: l_ra_rec ar_receivable_applications%ROWTYPE;
210: l_return_code VARCHAR2(20);
211: l_ps_rec ar_payment_schedules%ROWTYPE;
212: ln_batch_id NUMBER;
213: l_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;
214: l_bal_due_rem NUMBER;
215:
216: l_old_ps_rec ar_payment_schedules%ROWTYPE; /* jrautiai BR implementation */
217: l_rec_app_id NUMBER;

Line 216: l_old_ps_rec ar_payment_schedules%ROWTYPE; /* jrautiai BR implementation */

212: ln_batch_id NUMBER;
213: l_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;
214: l_bal_due_rem NUMBER;
215:
216: l_old_ps_rec ar_payment_schedules%ROWTYPE; /* jrautiai BR implementation */
217: l_rec_app_id NUMBER;
218: --apandit Bug : 2641517
219: l_status VARCHAR2(30);
220: l_called_from VARCHAR2(30); --Bug7194951

Line 380: from ar_payment_schedules

376:
377: IF (l_payment_schedule_id IS NOT NULL and l_ra_rec.status <> 'ACTIVITY') THEN
378: SELECT amount_due_remaining
379: INTO l_bal_due_rem
380: from ar_payment_schedules
381: where payment_schedule_id = l_payment_schedule_id;
382: END IF;
383:
384: if (l_bal_due_rem IS NOT NULL) THEN

Line 581: 2. Update applied transaction row in AR_PAYMENT_SCHEDULES |

577: | The algorithm for reversing an cm application is |
578: 1. Reverse existing application using opposite |
579: amounts. This is done by creating a new row into |
580: AR_RECEIVABLE_APPLICATIONS table. |
581: 2. Update applied transaction row in AR_PAYMENT_SCHEDULES |
582: | |
583: | SCOPE - PUBLIC |
584: | |
585: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |

Line 2081: , ar_payment_schedules ps

2077: , l_amount_due_remaining
2078: , l_amount_due_original
2079: FROM
2080: ar_receipt_method_accounts rma
2081: , ar_payment_schedules ps
2082: , ar_cash_receipts cr
2083: , ar_receivables_trx ed
2084: , ar_receivables_trx uned
2085: WHERE

Line 2380: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;

2376: FUNCTION check_reversable (
2377: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,
2378: p_module_name IN VARCHAR2,
2379: p_module_version IN VARCHAR2 ) RETURN BOOLEAN IS
2380: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
2381: l_ass_cr_id ar_adjustments.associated_cash_receipt_id%TYPE;
2382: l_ct_id ra_customer_trx.customer_trx_id%TYPE;
2383: l_adj_amt NUMBER;
2384: l_pend_amt NUMBER;

Line 2432: ar_payment_schedules ps,

2428: l_status,
2429: l_over_appln_flag,
2430: l_bal_org
2431: FROM ar_receivable_applications ra,
2432: ar_payment_schedules ps,
2433: ra_cust_trx_types ctt
2434: WHERE ra.receivable_application_id = p_ra_id
2435: AND ps.payment_schedule_id(+) = ra.applied_payment_schedule_id
2436: AND ctt.cust_trx_type_id = ps.cust_trx_type_id;

Line 2470: ar_payment_schedules ps,

2466: l_status,
2467: l_over_appln_flag,
2468: l_bal_org
2469: FROM ar_receivable_applications ra,
2470: ar_payment_schedules ps,
2471: ra_cust_trx_types ctt
2472: WHERE ra.receivable_application_id = p_ra_id
2473: AND ps.customer_trx_id(+) = ra.application_ref_id
2474: AND ctt.cust_trx_type_id = ps.cust_trx_type_id

Line 2683: ar_payment_schedules ps

2679: --
2680: /* SELECT adj.adjustment_id,
2681: ps.payment_schedule_id
2682: FROM ar_adjustments adj,
2683: ar_payment_schedules ps
2684: WHERE adj.associated_cash_receipt_id = l_ass_cr_id
2685: AND adj.payment_schedule_id = l_ps_id
2686: AND adj.chargeback_customer_trx_id = ps.customer_trx_id(+)
2687: FOR UPDATE OF ps.last_updated_by,adj.last_updated_by NOWAIT; */

Line 2789: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

2785: +===========================================================================*/
2786: PROCEDURE reverse_action(
2787: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,
2788: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
2789: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
2790: p_reversal_gl_date IN DATE, p_reversal_date IN DATE,
2791: p_select_flag IN BOOLEAN,
2792: p_module_name IN VARCHAR2,
2793: p_module_version IN VARCHAR2 ) IS

Line 2795: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;

2791: p_select_flag IN BOOLEAN,
2792: p_module_name IN VARCHAR2,
2793: p_module_version IN VARCHAR2 ) IS
2794: l_adj_amount NUMBER;
2795: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
2796: l_ass_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
2797: l_app_rec arp_global.app_rec_type;
2798: l_ps_rec ar_payment_schedules%ROWTYPE;
2799:

Line 2798: l_ps_rec ar_payment_schedules%ROWTYPE;

2794: l_adj_amount NUMBER;
2795: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
2796: l_ass_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
2797: l_app_rec arp_global.app_rec_type;
2798: l_ps_rec ar_payment_schedules%ROWTYPE;
2799:
2800: l_count NUMBER DEFAULT 0;
2801: --
2802: CURSOR ar_adjustments_C( l_ps_id ar_payment_schedules.payment_schedule_id%TYPE,

Line 2802: CURSOR ar_adjustments_C( l_ps_id ar_payment_schedules.payment_schedule_id%TYPE,

2798: l_ps_rec ar_payment_schedules%ROWTYPE;
2799:
2800: l_count NUMBER DEFAULT 0;
2801: --
2802: CURSOR ar_adjustments_C( l_ps_id ar_payment_schedules.payment_schedule_id%TYPE,
2803: l_ass_cr_id ar_cash_receipts.cash_receipt_id%TYPE ) IS
2804: SELECT a.chargeback_customer_trx_id,
2805: a.adjustment_id,
2806: a.status

Line 2817: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE,

2813: AND b.customer_trx_id(+) = a.chargeback_customer_trx_id
2814: AND b.customer_trx_id is null;
2815: --
2816: CURSOR ar_adjustments_radj_C(
2817: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE,
2818: l_ass_cr_id ar_cash_receipts.cash_receipt_id%TYPE ) IS
2819: SELECT adjustment_id,
2820: status
2821: FROM ar_adjustments

Line 3035: FROM ar_payment_schedules

3031: END IF;
3032: SELECT NVL( amount_adjusted_pending, 0 ) -
3033: NVL( l_app_rec.amount_adjusted_pending, 0)
3034: INTO l_app_rec.amount_adjusted_pending
3035: FROM ar_payment_schedules
3036: WHERE payment_schedule_id = l_ps_id;
3037: --
3038: IF PG_DEBUG in ('Y', 'C') THEN
3039: arp_debug.debug( 'before get_closed_dates in app_delete' );

Line 3101: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

3097: +===========================================================================*/
3098: PROCEDURE validate_reverse_action_args(
3099: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,
3100: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
3101: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
3102: p_reversal_gl_date IN DATE, p_reversal_date IN DATE,
3103: p_select_flag IN BOOLEAN ) IS
3104: BEGIN
3105: IF PG_DEBUG in ('Y', 'C') THEN

Line 3254: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

3250: | 31-JUL-2009 M Raymond 8620127 - set maturity date correctly
3251: | based on receipt_method rule
3252: +===========================================================================*/
3253: PROCEDURE receipt_application(
3254: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
3255: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
3256: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
3257: p_amount_applied_from IN
3258: ar_receivable_applications.amount_applied_from%TYPE,

Line 3255: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

3251: | based on receipt_method rule
3252: +===========================================================================*/
3253: PROCEDURE receipt_application(
3254: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
3255: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
3256: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
3257: p_amount_applied_from IN
3258: ar_receivable_applications.amount_applied_from%TYPE,
3259: p_trans_to_receipt_rate IN

Line 3262: ar_payment_schedules.invoice_currency_code%TYPE,

3258: ar_receivable_applications.amount_applied_from%TYPE,
3259: p_trans_to_receipt_rate IN
3260: ar_receivable_applications.trans_to_receipt_rate%TYPE,
3261: p_invoice_currency_code IN
3262: ar_payment_schedules.invoice_currency_code%TYPE,
3263: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,
3264: p_earned_discount_taken IN
3265: ar_receivable_applications.earned_discount_taken%TYPE,
3266: p_unearned_discount_taken IN

Line 3338: ar_payment_schedules.amount_due_remaining%TYPE,

3334: p_called_from IN VARCHAR2, /* jrautiai BR implementation */
3335: p_move_deferred_tax IN VARCHAR2, /* jrautiai BR implementation */
3336: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE, /* jrautiai BR implementation */
3337: p_amount_due_remaining IN
3338: ar_payment_schedules.amount_due_remaining%TYPE,
3339: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE,
3340: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE,
3341: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,
3342: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE,

Line 3364: l_old_ps_rec ar_payment_schedules%ROWTYPE; /* jrautiai BR implementation */

3360:
3361:
3362: l_receipt_info_rec AR_AUTOREC_API.receipt_info_rec;
3363:
3364: l_old_ps_rec ar_payment_schedules%ROWTYPE; /* jrautiai BR implementation */
3365: l_new_ps_rec ar_payment_schedules%ROWTYPE; /* jrautiai BR implementation */
3366: l_source_type ar_distributions.source_type%TYPE; /* jrautiai BR implementation */
3367: l_exchange_rate_type ra_customer_trx.exchange_rate_type%TYPE;
3368: l_exchange_rate_date ra_customer_trx.exchange_date%TYPE;

Line 3365: l_new_ps_rec ar_payment_schedules%ROWTYPE; /* jrautiai BR implementation */

3361:
3362: l_receipt_info_rec AR_AUTOREC_API.receipt_info_rec;
3363:
3364: l_old_ps_rec ar_payment_schedules%ROWTYPE; /* jrautiai BR implementation */
3365: l_new_ps_rec ar_payment_schedules%ROWTYPE; /* jrautiai BR implementation */
3366: l_source_type ar_distributions.source_type%TYPE; /* jrautiai BR implementation */
3367: l_exchange_rate_type ra_customer_trx.exchange_rate_type%TYPE;
3368: l_exchange_rate_date ra_customer_trx.exchange_date%TYPE;
3369: l_exchange_rate ra_customer_trx.exchange_rate%TYPE;

Line 3419: FROM ar_payment_schedules

3415: WHERE cash_receipt_id = p_receipt_id;
3416:
3417: CURSOR c_trx_amount_due (p_payment_schedule_id NUMBER) IS
3418: SELECT amount_due_remaining
3419: FROM ar_payment_schedules
3420: WHERE payment_schedule_id = p_payment_schedule_id;
3421:
3422: trade_mgt_err EXCEPTION; -- Bug 3773036
3423:

Line 3431: l_class_var ar_payment_schedules.class%type; -- Bug 6924942

3427: l_due_date DATE;
3428: l_maturity_date_rule VARCHAR2(30);
3429: l_amount_applied NUMBER;
3430: l_first_application BOOLEAN;
3431: l_class_var ar_payment_schedules.class%type; -- Bug 6924942
3432: l_org_id NUMBER := -99;
3433:
3434: BEGIN
3435: IF PG_DEBUG in ('Y', 'C') THEN

Line 3532: from ra_cust_trx_types ctt, ar_payment_schedules ps

3528:
3529: ELSE
3530: select ps.amount_due_remaining,ps.amount_due_original,ctt.allow_overapplication_flag
3531: into l_inv_bal_amount, l_inv_orig_amount, l_allow_over_application
3532: from ra_cust_trx_types ctt, ar_payment_schedules ps
3533: where ps.payment_schedule_id = p_invoice_ps_id
3534: and ps.cust_trx_type_id = ctt.cust_trx_type_id;
3535: END IF;
3536:

Line 3605: ar_payment_schedules ps

3601: INTO l_receipt_date, l_maturity_date_rule, l_maturity_date,
3602: l_amount_applied, l_org_id
3603: FROM ar_cash_receipts cr,
3604: ar_receipt_methods rm,
3605: ar_payment_schedules ps
3606: WHERE cr.cash_receipt_id = l_rec_ra_rec.cash_receipt_id
3607: AND cr.receipt_method_id = rm.receipt_method_id
3608: AND cr.cash_receipt_id = ps.cash_receipt_id;
3609:

Line 3614: FROM ar_payment_schedules

3610: SELECT amount_due_remaining,
3611: due_date
3612: INTO l_amount_due_remaining,
3613: l_due_date
3614: FROM ar_payment_schedules
3615: WHERE payment_schedule_id = p_invoice_ps_id;
3616:
3617: ELSE
3618: SELECT ps.cash_receipt_id

Line 3645: , ar_payment_schedules ps

3641: , ar_cash_receipt_history crh
3642: , ar_receipt_methods rm
3643: , ce_bank_acct_uses_ou ba
3644: , ar_receipt_method_accounts rma
3645: , ar_payment_schedules ps
3646: , ar_receivables_trx ed
3647: , ar_receivables_trx uned
3648: WHERE ps.payment_schedule_id = p_receipt_ps_id
3649: AND cr.cash_receipt_id = ps.cash_receipt_id

Line 3663: FROM ar_payment_schedules

3659: /* 4566510 - get invoice trx_id for use in prorate_recoverable */
3660: SELECT customer_trx_id, due_date
3661: INTO l_inv_ra_rec.applied_customer_trx_id,
3662: l_due_date
3663: FROM ar_payment_schedules
3664: WHERE payment_schedule_id = p_invoice_ps_id;
3665: END IF;
3666:
3667: arp_debug.debug('trx_id = ' || l_inv_ra_rec.applied_customer_trx_id);

Line 3797: FROM ar_payment_schedules ps

3793:
3794: -- Bug 6924942 - Start
3795: SELECT ps.class
3796: INTO l_class_var
3797: FROM ar_payment_schedules ps
3798: WHERE ps.payment_schedule_id = p_invoice_ps_id;
3799: -- Bug 6924942 - End
3800:
3801: arp_ps_util.update_receipt_related_columns(

Line 4076: FROM ar_payment_schedules

4072: --
4073: BEGIN
4074: SELECT payment_schedule_id
4075: INTO l_claim_trx_ps_id
4076: FROM ar_payment_schedules
4077: WHERE customer_trx_id = l_inv_ra_rec.applied_customer_trx_id
4078: AND payment_schedule_id = l_inv_ra_rec.applied_payment_schedule_id
4079: AND NVL(active_claim_flag,'N') <> 'N' /*Bug 11841102*/
4080: /* AND NVL(active_claim_flag,'N') not in ('N','C') Bug 10178153*/

Line 4514: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

4510: | applied from and trans to receipt rate.
4511: |
4512: +===========================================================================*/
4513: PROCEDURE validate_receipt_appln_args(
4514: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4515: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4516: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
4517: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE,
4518: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE,

Line 4515: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

4511: |
4512: +===========================================================================*/
4513: PROCEDURE validate_receipt_appln_args(
4514: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4515: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4516: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
4517: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE,
4518: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE,
4519: p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

Line 4519: p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

4515: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4516: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
4517: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE,
4518: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE,
4519: p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
4520: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,
4521: p_earned_discount_taken IN ar_receivable_applications.earned_discount_taken%TYPE,
4522: p_unearned_discount_taken IN ar_receivable_applications.unearned_discount_taken%TYPE,
4523: p_apply_date IN ar_receivable_applications.apply_date%TYPE,

Line 4639: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

4635: | are saved |
4636: | 12-Mar-04 Bhushan Dhotkar Bug 2662270: Added a column p_comments
4637: +===========================================================================*/
4638: PROCEDURE cm_application(
4639: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4640: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4641: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
4642: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
4643: p_gl_date IN ar_receivable_applications.gl_date%TYPE,

Line 4640: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

4636: | 12-Mar-04 Bhushan Dhotkar Bug 2662270: Added a column p_comments
4637: +===========================================================================*/
4638: PROCEDURE cm_application(
4639: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4640: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4641: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
4642: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
4643: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
4644: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,

Line 4692: l_cm_ps_rec ar_payment_schedules%ROWTYPE;

4688: p_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
4689: p_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE) IS
4690:
4691: l_inv_ra_rec ar_receivable_applications%ROWTYPE;
4692: l_cm_ps_rec ar_payment_schedules%ROWTYPE;
4693: l_ae_doc_rec ae_doc_rec_type;
4694: l_source_type ar_distributions.source_type%TYPE; /* jrautiai BR implementation */
4695: l_flag char; /* added for bug 2318048 */
4696: l_upgrade_flag VARCHAR2(30);

Line 4710: l_nocopy_amt_due_remain ar_payment_schedules.amount_due_remaining%TYPE;

4706: l_xla_ev_rec arp_xla_events.xla_events_type;
4707: l_xla_doc_table VARCHAR2(20);
4708:
4709:
4710: l_nocopy_amt_due_remain ar_payment_schedules.amount_due_remaining%TYPE;
4711: l_nocopy_acctd_amt_due_remain ar_payment_schedules.acctd_amount_due_remaining%TYPE;
4712: l_new_amt_due_rem Number;
4713: l_new_acctd_amt_due_rem Number;
4714:

Line 4711: l_nocopy_acctd_amt_due_remain ar_payment_schedules.acctd_amount_due_remaining%TYPE;

4707: l_xla_doc_table VARCHAR2(20);
4708:
4709:
4710: l_nocopy_amt_due_remain ar_payment_schedules.amount_due_remaining%TYPE;
4711: l_nocopy_acctd_amt_due_remain ar_payment_schedules.acctd_amount_due_remaining%TYPE;
4712: l_new_amt_due_rem Number;
4713: l_new_acctd_amt_due_rem Number;
4714:
4715: BEGIN

Line 4779: from ra_cust_trx_types ctt, ar_payment_schedules ps

4775: the transaction type does not allow overapplication */
4776:
4777: select ps.amount_due_remaining,ps.amount_due_original,ctt.allow_overapplication_flag
4778: into l_inv_bal_amount, l_inv_orig_amount, l_allow_over_application
4779: from ra_cust_trx_types ctt, ar_payment_schedules ps
4780: where ps.payment_schedule_id = p_invoice_ps_id
4781: and ps.cust_trx_type_id = ctt.cust_trx_type_id;
4782:
4783: l_effective_amount_applied := NVL(p_amount_applied,0) ;

Line 4864: FROM ar_payment_schedules

4860: -- to update_cm_related_columns procedure.
4861: --
4862: SELECT *
4863: INTO l_cm_ps_rec
4864: FROM ar_payment_schedules
4865: WHERE payment_schedule_id = p_cm_ps_id;
4866: --
4867: l_nocopy_amt_due_remain := l_cm_ps_rec.amount_due_remaining;
4868: l_nocopy_acctd_amt_due_remain := l_cm_ps_rec.acctd_amount_due_remaining;

Line 4885: ar_payment_schedules ps

4881: the APP row postable */
4882:
4883: select NVL(ctt.post_to_gl,'N') into l_flag
4884: from ra_cust_trx_types ctt,
4885: ar_payment_schedules ps
4886: where ctt.cust_trx_type_id = ps.cust_trx_type_id
4887: and ps.payment_schedule_id = p_cm_ps_id;
4888:
4889: If l_flag = 'Y' then

Line 5088: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

5084: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
5085: | |
5086: +===========================================================================*/
5087: PROCEDURE validate_cm_appln_args(
5088: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
5089: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
5090: p_amount_applied IN
5091: ar_receivable_applications.amount_applied%TYPE,
5092: p_apply_date IN ar_receivable_applications.apply_date%TYPE,

Line 5089: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

5085: | |
5086: +===========================================================================*/
5087: PROCEDURE validate_cm_appln_args(
5088: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
5089: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
5090: p_amount_applied IN
5091: ar_receivable_applications.amount_applied%TYPE,
5092: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
5093: p_gl_date IN ar_receivable_applications.gl_date%TYPE ) IS

Line 5183: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

5179: | inserts to ar_receivable_applications |
5180: | 28-JUL-2003 Jon Beckett Bug 2821139 - added p_customer_reason. |
5181: +===========================================================================*/
5182: PROCEDURE on_account_receipts(
5183: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
5184: p_amount_applied IN
5185: ar_receivable_applications.amount_applied%TYPE,
5186: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
5187: p_gl_date IN ar_receivable_applications.gl_date%TYPE,

Line 5246: l_ps_rec ar_payment_schedules%ROWTYPE;

5242: , p_on_acct_po_num IN ar_receivable_applications.on_acct_po_num%TYPE DEFAULT NULL
5243: ) IS
5244:
5245: l_ra_rec ar_receivable_applications%ROWTYPE;
5246: l_ps_rec ar_payment_schedules%ROWTYPE;
5247:
5248: l_cr_rec ar_cash_receipts%ROWTYPE;
5249: l_amount_due_remaining NUMBER;
5250: ln_batch_id NUMBER;

Line 5300: FROM ar_payment_schedules ps

5296: l_amount_due_remaining,
5297: l_onacc_cc_id,
5298: l_unapp_cc_id
5299: , ln_batch_id
5300: FROM ar_payment_schedules ps
5301: , ar_cash_receipts cr
5302: , ar_cash_receipt_history crh
5303: , ar_receipt_methods rm
5304: , ce_bank_acct_uses ba

Line 5596: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

5592: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
5593: | |
5594: +===========================================================================*/
5595: PROCEDURE validate_on_account_args(
5596: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
5597: p_amount_applied IN
5598: ar_receivable_applications.amount_applied%TYPE,
5599: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
5600: p_gl_date IN ar_receivable_applications.gl_date%TYPE ) IS

Line 5693: ar_payment_schedules.payment_schedule_id%TYPE,

5689: | 04-Mar-05 Jyoti Pandey Bug: 4166986 CC Chargeback logic
5690: +===========================================================================*/
5691: PROCEDURE activity_application(
5692: p_receipt_ps_id IN
5693: ar_payment_schedules.payment_schedule_id%TYPE,
5694: p_application_ps_id IN
5695: ar_receivable_applications.applied_payment_schedule_id%TYPE,
5696: p_link_to_customer_trx_id IN
5697: ar_receivable_applications.link_to_customer_trx_id%TYPE,

Line 5819: FROM ar_payment_schedules ps,

5815: rma.unapplied_ccid,
5816: crh.batch_id,
5817: rt.code_combination_id activity_ccid,
5818: rt.type activity_type
5819: FROM ar_payment_schedules ps,
5820: ar_cash_receipts cr,
5821: ar_cash_receipt_history crh,
5822: ar_receipt_methods rm,
5823: ce_bank_acct_uses ba,

Line 5839: l_ps_rec ar_payment_schedules%ROWTYPE;

5835:
5836: activity_rec activity_c%ROWTYPE;
5837:
5838: l_ra_rec ar_receivable_applications%ROWTYPE;
5839: l_ps_rec ar_payment_schedules%ROWTYPE;
5840: l_cr_rec ar_cash_receipts%ROWTYPE;
5841: l_crcpt_rec ar_cash_receipts%ROWTYPE;
5842:
5843: l_unapp_ra_rec ar_receivable_applications%ROWTYPE; /* MRC */

Line 5855: l_func_amount_due_remaining ar_payment_schedules.amount_due_remaining%TYPE;

5851: l_invoice_currency_code ra_customer_trx.invoice_currency_code%TYPE;
5852: l_receipt_currency_code ar_cash_receipts.currency_code%TYPE;
5853: l_exchange_rate ra_customer_trx.exchange_rate%TYPE;
5854: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
5855: l_func_amount_due_remaining ar_payment_schedules.amount_due_remaining%TYPE;
5856:
5857: l_fnd_api_constants_rec ar_bills_main.fnd_api_constants_type := ar_bills_main.get_fnd_api_constants_rec;
5858: l_fnd_msg_pub_constants_rec ar_bills_main.fnd_msg_pub_constants_type := ar_bills_main.get_fnd_msg_pub_constants_rec;
5859: l_attribute_rec AR_RECEIPT_API_PUB.attribute_rec_type;

Line 6220: FROM ar_payment_schedules

6216: SELECT invoice_currency_code,
6217: exchange_rate
6218: INTO l_receipt_currency_code,
6219: l_exchange_rate
6220: FROM ar_payment_schedules
6221: WHERE payment_schedule_id = p_application_ps_id;
6222: ELSE
6223: l_exchange_rate := l_ps_rec.exchange_rate;
6224: END IF;

Line 6577: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

6573: | schedule_id of -3 for receipt write-off|
6574: | |
6575: +===========================================================================*/
6576: PROCEDURE validate_activity_args(
6577: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
6578: p_application_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
6579: p_link_to_customer_trx_id IN ar_receivable_applications.link_to_customer_trx_id%TYPE,
6580: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
6581: p_apply_date IN ar_receivable_applications.apply_date%TYPE,

Line 6645: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

6641: | MODIFICATION HISTORY - Created by Jani Rautiainen - 14-APR-2000 |
6642: | |
6643: +===========================================================================*/
6644: PROCEDURE fetch_app_ccid(
6645: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
6646: p_applied_customer_trx_id OUT NOCOPY ar_receivable_applications.applied_customer_trx_id%TYPE,
6647: p_code_combination_id OUT NOCOPY ar_receivable_applications.code_combination_id%TYPE,
6648: p_source_type OUT NOCOPY ar_distributions.source_type%TYPE) IS
6649:

Line 6655: FROM ar_payment_schedules ps

6651: CURSOR doc_cur IS
6652: SELECT ps.customer_trx_id,
6653: ps.class,
6654: ps.amount_due_original
6655: FROM ar_payment_schedules ps
6656: WHERE ps.payment_schedule_id = p_invoice_ps_id;
6657:
6658: /* Cursor to fetch normal transaction CCID, the old functionality */
6659: CURSOR trx_dist_cur(l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE) IS

Line 6885: FROM ar_payment_schedules ps

6881: p_applied_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE) RETURN BOOLEAN IS
6882:
6883: CURSOR trx_class_cur IS
6884: SELECT ps.class
6885: FROM ar_payment_schedules ps
6886: WHERE ps.payment_schedule_id = p_applied_ps_id;
6887:
6888: CURSOR current_BR_cur IS
6889: SELECT trh.status, trh.event

Line 7003: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

6999: | and Prepayments. Bug Fix 4025652. |
7000: | 14-OCT-2005 Jon Beckett Bug 4565758 - legal entity passed to TM |
7001: +===========================================================================*/
7002: PROCEDURE other_account_application(
7003: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
7004: p_amount_applied IN
7005: ar_receivable_applications.amount_applied%TYPE,
7006: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
7007: p_gl_date IN ar_receivable_applications.gl_date%TYPE,

Line 7077: l_ps_rec ar_payment_schedules%ROWTYPE;

7073: , x_claim_reason_name OUT NOCOPY VARCHAR2
7074: , p_called_from IN VARCHAR2) IS
7075:
7076: l_ra_rec ar_receivable_applications%ROWTYPE;
7077: l_ps_rec ar_payment_schedules%ROWTYPE;
7078:
7079: l_cr_rec ar_cash_receipts%ROWTYPE;
7080: l_amount_due_remaining NUMBER;
7081: ln_batch_id NUMBER;

Line 7162: FROM ar_payment_schedules ps

7158: , l_customer_id
7159: , l_customer_site_use_id
7160: , l_receipt_number
7161: , l_legal_entity_id
7162: FROM ar_payment_schedules ps
7163: , ar_cash_receipts cr
7164: , ar_cash_receipt_history crh
7165: , ar_receipt_methods rm
7166: , ce_bank_acct_uses ba

Line 7843: l_active_claim_flag ar_payment_schedules.active_claim_flag%TYPE;

7839: l_return_status VARCHAR2(1);
7840: l_object_version_number NUMBER;
7841: l_claim_number VARCHAR2(30);
7842: l_amount_from_dispute NUMBER;
7843: l_active_claim_flag ar_payment_schedules.active_claim_flag%TYPE;
7844: l_amount_due_original NUMBER;
7845:
7846: /*Bug 11841102*/
7847: l_nc_app_amt NUMBER := 0;

Line 7850: l_claim_flag ar_payment_schedules.active_claim_flag%TYPE := 'I';

7846: /*Bug 11841102*/
7847: l_nc_app_amt NUMBER := 0;
7848: l_c_app_amt NUMBER := 0;
7849: l_amt_in_dispute NUMBER := 0;
7850: l_claim_flag ar_payment_schedules.active_claim_flag%TYPE := 'I';
7851: l_amt_applied NUMBER;
7852: l_claim_status ozf_claims.status_code%TYPE; --Add for bug 13464283
7853: cursor c_ra_app_id (p_cust_trx_id varchar2) is
7854: select receivable_application_id ra_app_id,

Line 7898: FROM ar_payment_schedules

7894: l_claim_rec.source_object_id := p_customer_trx_id;
7895: l_claim_rec.source_object_class := 'INVOICE';
7896: SELECT amount_due_original
7897: INTO l_amount_due_original
7898: FROM ar_payment_schedules
7899: WHERE payment_schedule_id = p_invoice_ps_id;
7900: ELSE
7901: l_claim_rec.source_object_id := NULL;
7902: l_claim_rec.source_object_class := NULL;

Line 8181: FROM ar_payment_schedules

8177: customer_site_use_id,
8178: class,
8179: trx_date,
8180: dispute_date
8181: FROM ar_payment_schedules
8182: WHERE payment_schedule_id = p_ps_id;
8183: BEGIN
8184: IF PG_DEBUG in ('Y', 'C') THEN
8185: arp_debug.debug( 'arp_process_application.put_trx_in_dispute()+' );

Line 8238: UPDATE ar_payment_schedules ps

8234: END IF;--if(l_new_dispute_amount <>....
8235: END IF;--IF get_existing_ps%ROWCOUNT>0 THEN
8236: CLOSE get_existing_ps;
8237:
8238: UPDATE ar_payment_schedules ps
8239: SET ps.amount_in_dispute = nvl(ps.amount_in_dispute,0) + p_dispute_amount,
8240: ps.dispute_date = SYSDATE,
8241: last_updated_by = l_user_id,
8242: last_update_login = l_last_update_login,

Line 8284: FROM ar_payment_schedules

8280: SELECT payment_schedule_id,
8281: amount_in_dispute,
8282: amount_due_remaining,
8283: dispute_date
8284: FROM ar_payment_schedules
8285: WHERE payment_schedule_id = p_ps_id;
8286: BEGIN
8287: l_user_id := arp_standard.profile.user_id;
8288: l_last_update_login := arp_standard.profile.last_update_login;

Line 8329: UPDATE ar_payment_schedules ps

8325:
8326:
8327: /*Bug 11841102*/
8328: IF (p_active_claim in ('A','I')) THEN
8329: UPDATE ar_payment_schedules ps
8330: SET ps.amount_in_dispute = p_amount,
8331: ps.dispute_date = DECODE(p_amount,0,null,SYSDATE),
8332: last_updated_by = l_user_id,
8333: last_update_login = l_last_update_login,

Line 8337: UPDATE ar_payment_schedules ps

8333: last_update_login = l_last_update_login,
8334: active_claim_flag = decode(p_active_claim,'A','Y','C')
8335: WHERE ps.payment_schedule_id = p_invoice_ps_id;
8336: ELSE
8337: UPDATE ar_payment_schedules ps
8338: SET ps.amount_in_dispute = DECODE(ps.amount_in_dispute, p_amount, NULL
8339: , (ps.amount_in_dispute-p_amount)),
8340: ps.dispute_date = DECODE(p_amount,0,null,SYSDATE),
8341: last_updated_by = l_user_id,

Line 8657: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

8653: | jbeckett 10-JAN-05 Created for credit memo refunds. |
8654: | |
8655: +===========================================================================*/
8656: PROCEDURE cm_activity_application(
8657: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
8658: p_application_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
8659: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
8660: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
8661: p_gl_date IN ar_receivable_applications.gl_date%TYPE,

Line 8658: p_application_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

8654: | |
8655: +===========================================================================*/
8656: PROCEDURE cm_activity_application(
8657: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
8658: p_application_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
8659: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
8660: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
8661: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
8662: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,

Line 8716: l_cm_ps_rec ar_payment_schedules%ROWTYPE;

8712: x_msg_count OUT NOCOPY NUMBER,
8713: x_msg_data OUT NOCOPY VARCHAR2) IS
8714:
8715: l_inv_ra_rec ar_receivable_applications%ROWTYPE;
8716: l_cm_ps_rec ar_payment_schedules%ROWTYPE;
8717: l_ae_doc_rec ae_doc_rec_type;
8718: l_source_type ar_distributions.source_type%TYPE; /* jrautiai BR implementation */
8719: l_flag char;
8720: l_fnd_api_constants_rec ar_bills_main.fnd_api_constants_type := ar_bills_main.get_fnd_api_constants_rec;

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

8735: l_msg_index NUMBER;
8736: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
8737: functional_curr VARCHAR2(100);
8738:
8739: l_line_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
8740: l_tax_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
8741: l_rec_charges_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
8742: l_freight_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
8743: l_tax_applied ar_receivable_applications.tax_applied%TYPE:=0;

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

8736: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
8737: functional_curr VARCHAR2(100);
8738:
8739: l_line_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
8740: l_tax_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
8741: l_rec_charges_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
8742: l_freight_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
8743: l_tax_applied ar_receivable_applications.tax_applied%TYPE:=0;
8744: l_freight_applied ar_receivable_applications.freight_applied%TYPE:=0;

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

8737: functional_curr VARCHAR2(100);
8738:
8739: l_line_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
8740: l_tax_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
8741: l_rec_charges_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
8742: l_freight_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
8743: l_tax_applied ar_receivable_applications.tax_applied%TYPE:=0;
8744: l_freight_applied ar_receivable_applications.freight_applied%TYPE:=0;
8745: l_line_applied ar_receivable_applications.line_applied%TYPE:=0;

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

8738:
8739: l_line_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
8740: l_tax_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
8741: l_rec_charges_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
8742: l_freight_remaining ar_payment_schedules.tax_remaining%TYPE:=0;
8743: l_tax_applied ar_receivable_applications.tax_applied%TYPE:=0;
8744: l_freight_applied ar_receivable_applications.freight_applied%TYPE:=0;
8745: l_line_applied ar_receivable_applications.line_applied%TYPE:=0;
8746: l_charges_applied ar_receivable_applications.receivables_charges_applied%TYPE:=0;

Line 8844: ar_payment_schedules ps

8840: 'Y' );
8841:
8842: select NVL(ctt.post_to_gl,'N') into l_flag
8843: from ra_cust_trx_types ctt,
8844: ar_payment_schedules ps
8845: where ctt.cust_trx_type_id = ps.cust_trx_type_id
8846: and ps.payment_schedule_id = p_cm_ps_id;
8847:
8848: If l_flag = 'Y' then