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 14: NULL_VAR ar_payment_schedules%ROWTYPE; /* Added for Bug 460959 for Oracle 8 */

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

Line 24: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

20: --
21: PROCEDURE reverse_action(
22: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,
23: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
24: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
25: p_reversal_gl_date IN DATE
26: , p_reversal_date IN DATE,
27: P_SELECT_FLAG IN BOOLEAN,
28: P_MODULE_NAME IN VARCHAR2,

Line 60: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

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

Line 68: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

64: PROCEDURE validate_args_appdel(
65: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE );
66: --
67: PROCEDURE validate_receipt_appln_args(
68: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
69: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
70: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
71: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE,
72: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE,

Line 69: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

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

Line 73: p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

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

Line 81: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

77: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
78: p_gl_date IN ar_receivable_applications.gl_date%TYPE );
79: --
80: PROCEDURE validate_cm_appln_args(
81: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
82: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
83: p_amount_applied IN
84: ar_receivable_applications.amount_applied%TYPE,
85: p_apply_date IN ar_receivable_applications.apply_date%TYPE,

Line 82: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

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

Line 89: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

85: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
86: p_gl_date IN ar_receivable_applications.gl_date%TYPE );
87: --
88: PROCEDURE validate_on_account_args(
89: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
90: p_amount_applied IN
91: ar_receivable_applications.amount_applied%TYPE,
92: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
93: p_gl_date IN ar_receivable_applications.gl_date%TYPE );

Line 96: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

92: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
93: p_gl_date IN ar_receivable_applications.gl_date%TYPE );
94:
95: PROCEDURE validate_activity_args(
96: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
97: p_application_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
98: p_link_to_customer_trx_id IN ar_receivable_applications.link_to_customer_trx_id%TYPE,
99: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
100: p_apply_date IN ar_receivable_applications.apply_date%TYPE,

Line 207: l_ps_rec ar_payment_schedules%ROWTYPE;

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

Line 209: l_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;

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

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

208: ln_batch_id NUMBER;
209: l_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;
210: l_bal_due_rem NUMBER;
211:
212: l_old_ps_rec ar_payment_schedules%ROWTYPE; /* jrautiai BR implementation */
213: l_rec_app_id NUMBER;
214: --apandit Bug : 2641517
215: l_status VARCHAR2(30);
216: BEGIN

Line 362: from ar_payment_schedules

358:
359: IF (l_payment_schedule_id IS NOT NULL and l_ra_rec.status <> 'ACTIVITY') THEN
360: SELECT amount_due_remaining
361: INTO l_bal_due_rem
362: from ar_payment_schedules
363: where payment_schedule_id = l_payment_schedule_id;
364: END IF;
365:
366: if (l_bal_due_rem IS NOT NULL) THEN

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

546: | The algorithm for reversing an cm application is |
547: 1. Reverse existing application using opposite |
548: amounts. This is done by creating a new row into |
549: AR_RECEIVABLE_APPLICATIONS table. |
550: 2. Update applied transaction row in AR_PAYMENT_SCHEDULES |
551: | |
552: | SCOPE - PUBLIC |
553: | |
554: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |

Line 1998: , ar_payment_schedules ps

1994: , l_amount_due_remaining
1995: , l_amount_due_original
1996: FROM
1997: ar_receipt_method_accounts rma
1998: , ar_payment_schedules ps
1999: , ar_cash_receipts cr
2000: , ar_receivables_trx ed
2001: , ar_receivables_trx uned
2002: WHERE

Line 2294: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;

2290: FUNCTION check_reversable (
2291: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,
2292: p_module_name IN VARCHAR2,
2293: p_module_version IN VARCHAR2 ) RETURN BOOLEAN IS
2294: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
2295: l_ass_cr_id ar_adjustments.associated_cash_receipt_id%TYPE;
2296: l_ct_id ra_customer_trx.customer_trx_id%TYPE;
2297: l_adj_amt NUMBER;
2298: l_pend_amt NUMBER;

Line 2344: ar_payment_schedules ps,

2340: l_status,
2341: l_over_appln_flag,
2342: l_bal_org
2343: FROM ar_receivable_applications ra,
2344: ar_payment_schedules ps,
2345: ra_cust_trx_types ctt
2346: WHERE ra.receivable_application_id = p_ra_id
2347: AND ps.payment_schedule_id(+) = ra.applied_payment_schedule_id
2348: AND ctt.cust_trx_type_id = ps.cust_trx_type_id;

Line 2382: ar_payment_schedules ps,

2378: l_status,
2379: l_over_appln_flag,
2380: l_bal_org
2381: FROM ar_receivable_applications ra,
2382: ar_payment_schedules ps,
2383: ra_cust_trx_types ctt
2384: WHERE ra.receivable_application_id = p_ra_id
2385: AND ps.customer_trx_id(+) = ra.application_ref_id
2386: AND ctt.cust_trx_type_id = ps.cust_trx_type_id

Line 2588: ar_payment_schedules ps

2584: --
2585: /* SELECT adj.adjustment_id,
2586: ps.payment_schedule_id
2587: FROM ar_adjustments adj,
2588: ar_payment_schedules ps
2589: WHERE adj.associated_cash_receipt_id = l_ass_cr_id
2590: AND adj.payment_schedule_id = l_ps_id
2591: AND adj.chargeback_customer_trx_id = ps.customer_trx_id(+)
2592: FOR UPDATE OF ps.last_updated_by,adj.last_updated_by NOWAIT; */

Line 2694: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

2690: +===========================================================================*/
2691: PROCEDURE reverse_action(
2692: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,
2693: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
2694: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
2695: p_reversal_gl_date IN DATE, p_reversal_date IN DATE,
2696: p_select_flag IN BOOLEAN,
2697: p_module_name IN VARCHAR2,
2698: p_module_version IN VARCHAR2 ) IS

Line 2700: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;

2696: p_select_flag IN BOOLEAN,
2697: p_module_name IN VARCHAR2,
2698: p_module_version IN VARCHAR2 ) IS
2699: l_adj_amount NUMBER;
2700: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
2701: l_ass_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
2702: l_app_rec arp_global.app_rec_type;
2703: l_ps_rec ar_payment_schedules%ROWTYPE;
2704:

Line 2703: l_ps_rec ar_payment_schedules%ROWTYPE;

2699: l_adj_amount NUMBER;
2700: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
2701: l_ass_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
2702: l_app_rec arp_global.app_rec_type;
2703: l_ps_rec ar_payment_schedules%ROWTYPE;
2704:
2705: l_count NUMBER DEFAULT 0;
2706: --
2707: CURSOR ar_adjustments_C( l_ps_id ar_payment_schedules.payment_schedule_id%TYPE,

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

2703: l_ps_rec ar_payment_schedules%ROWTYPE;
2704:
2705: l_count NUMBER DEFAULT 0;
2706: --
2707: CURSOR ar_adjustments_C( l_ps_id ar_payment_schedules.payment_schedule_id%TYPE,
2708: l_ass_cr_id ar_cash_receipts.cash_receipt_id%TYPE ) IS
2709: SELECT a.chargeback_customer_trx_id,
2710: a.adjustment_id,
2711: a.status

Line 2722: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE,

2718: AND b.customer_trx_id(+) = a.chargeback_customer_trx_id
2719: AND b.customer_trx_id is null;
2720: --
2721: CURSOR ar_adjustments_radj_C(
2722: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE,
2723: l_ass_cr_id ar_cash_receipts.cash_receipt_id%TYPE ) IS
2724: SELECT adjustment_id,
2725: status
2726: FROM ar_adjustments

Line 2931: FROM ar_payment_schedules

2927: END IF;
2928: SELECT NVL( amount_adjusted_pending, 0 ) -
2929: NVL( l_app_rec.amount_adjusted_pending, 0)
2930: INTO l_app_rec.amount_adjusted_pending
2931: FROM ar_payment_schedules
2932: WHERE payment_schedule_id = l_ps_id;
2933: --
2934: IF PG_DEBUG in ('Y', 'C') THEN
2935: arp_standard.debug( 'before get_closed_dates in app_delete' );

Line 2997: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

2993: +===========================================================================*/
2994: PROCEDURE validate_reverse_action_args(
2995: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,
2996: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
2997: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
2998: p_reversal_gl_date IN DATE, p_reversal_date IN DATE,
2999: p_select_flag IN BOOLEAN ) IS
3000: BEGIN
3001: IF PG_DEBUG in ('Y', 'C') THEN

Line 3148: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

3144: | and moved them inside
3145: | update_invoice_related_columns
3146: +===========================================================================*/
3147: PROCEDURE receipt_application(
3148: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
3149: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
3150: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
3151: p_amount_applied_from IN
3152: ar_receivable_applications.amount_applied_from%TYPE,

Line 3149: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

3145: | update_invoice_related_columns
3146: +===========================================================================*/
3147: PROCEDURE receipt_application(
3148: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
3149: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
3150: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
3151: p_amount_applied_from IN
3152: ar_receivable_applications.amount_applied_from%TYPE,
3153: p_trans_to_receipt_rate IN

Line 3156: ar_payment_schedules.invoice_currency_code%TYPE,

3152: ar_receivable_applications.amount_applied_from%TYPE,
3153: p_trans_to_receipt_rate IN
3154: ar_receivable_applications.trans_to_receipt_rate%TYPE,
3155: p_invoice_currency_code IN
3156: ar_payment_schedules.invoice_currency_code%TYPE,
3157: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,
3158: p_earned_discount_taken IN
3159: ar_receivable_applications.earned_discount_taken%TYPE,
3160: p_unearned_discount_taken IN

Line 3232: ar_payment_schedules.amount_due_remaining%TYPE,

3228: p_called_from IN VARCHAR2, /* jrautiai BR implementation */
3229: p_move_deferred_tax IN VARCHAR2, /* jrautiai BR implementation */
3230: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE, /* jrautiai BR implementation */
3231: p_amount_due_remaining IN
3232: ar_payment_schedules.amount_due_remaining%TYPE,
3233: p_payment_set_id IN ar_receivable_applications.payment_set_id%TYPE,
3234: p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE,
3235: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,
3236: p_customer_reason IN ar_receivable_applications.customer_reason%TYPE,

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

3254:
3255:
3256:
3257:
3258: l_old_ps_rec ar_payment_schedules%ROWTYPE; /* jrautiai BR implementation */
3259: l_new_ps_rec ar_payment_schedules%ROWTYPE; /* jrautiai BR implementation */
3260: l_source_type ar_distributions.source_type%TYPE; /* jrautiai BR implementation */
3261: l_exchange_rate_type ra_customer_trx.exchange_rate_type%TYPE;
3262: l_exchange_rate_date ra_customer_trx.exchange_date%TYPE;

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

3255:
3256:
3257:
3258: l_old_ps_rec ar_payment_schedules%ROWTYPE; /* jrautiai BR implementation */
3259: l_new_ps_rec ar_payment_schedules%ROWTYPE; /* jrautiai BR implementation */
3260: l_source_type ar_distributions.source_type%TYPE; /* jrautiai BR implementation */
3261: l_exchange_rate_type ra_customer_trx.exchange_rate_type%TYPE;
3262: l_exchange_rate_date ra_customer_trx.exchange_date%TYPE;
3263: l_exchange_rate ra_customer_trx.exchange_rate%TYPE;

Line 3313: FROM ar_payment_schedules

3309: WHERE cash_receipt_id = p_receipt_id;
3310:
3311: CURSOR c_trx_amount_due (p_payment_schedule_id NUMBER) IS
3312: SELECT amount_due_remaining
3313: FROM ar_payment_schedules
3314: WHERE payment_schedule_id = p_payment_schedule_id;
3315:
3316: trade_mgt_err EXCEPTION; -- Bug 3773036
3317:

Line 3406: from ra_cust_trx_types ctt, ar_payment_schedules ps

3402: the transaction type does not allow overapplication */
3403:
3404: select ps.amount_due_remaining,ps.amount_due_original,ctt.allow_overapplication_flag
3405: into l_inv_bal_amount, l_inv_orig_amount, l_allow_over_application
3406: from ra_cust_trx_types ctt, ar_payment_schedules ps
3407: where ps.payment_schedule_id = p_invoice_ps_id
3408: and ps.cust_trx_type_id = ctt.cust_trx_type_id;
3409:
3410: l_effective_amount_applied := NVL(p_amount_applied,0) +

Line 3472: , ar_payment_schedules ps

3468: , ar_cash_receipt_history crh
3469: , ar_receipt_methods rm
3470: , ce_bank_acct_uses_ou ba
3471: , ar_receipt_method_accounts rma
3472: , ar_payment_schedules ps
3473: , ar_receivables_trx ed
3474: , ar_receivables_trx uned
3475: WHERE ps.payment_schedule_id = p_receipt_ps_id
3476: AND cr.cash_receipt_id = ps.cash_receipt_id

Line 3490: FROM ar_payment_schedules

3486:
3487: /* 4566510 - get invoice trx_id for use in prorate_recoverable */
3488: SELECT customer_trx_id
3489: INTO l_inv_ra_rec.applied_customer_trx_id
3490: FROM ar_payment_schedules
3491: WHERE payment_schedule_id = p_invoice_ps_id;
3492:
3493: arp_util.debug('trx_id = ' || l_inv_ra_rec.applied_customer_trx_id);
3494:

Line 3799: FROM ar_payment_schedules

3795: --
3796: BEGIN
3797: SELECT payment_schedule_id
3798: INTO l_claim_trx_ps_id
3799: FROM ar_payment_schedules
3800: WHERE customer_trx_id = l_inv_ra_rec.applied_customer_trx_id
3801: AND payment_schedule_id = l_inv_ra_rec.applied_payment_schedule_id
3802: AND NVL(active_claim_flag,'N') <> 'N'
3803: AND ROWNUM = 1;

Line 4223: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

4219: | applied from and trans to receipt rate.
4220: |
4221: +===========================================================================*/
4222: PROCEDURE validate_receipt_appln_args(
4223: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4224: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4225: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
4226: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE,
4227: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE,

Line 4224: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

4220: |
4221: +===========================================================================*/
4222: PROCEDURE validate_receipt_appln_args(
4223: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4224: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4225: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
4226: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE,
4227: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE,
4228: p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

Line 4228: p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,

4224: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4225: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
4226: p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE,
4227: p_trans_to_receipt_rate IN ar_receivable_applications.trans_to_receipt_rate%TYPE,
4228: p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
4229: p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,
4230: p_earned_discount_taken IN ar_receivable_applications.earned_discount_taken%TYPE,
4231: p_unearned_discount_taken IN ar_receivable_applications.unearned_discount_taken%TYPE,
4232: p_apply_date IN ar_receivable_applications.apply_date%TYPE,

Line 4348: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

4344: | are saved |
4345: | 12-Mar-04 Bhushan Dhotkar Bug 2662270: Added a column p_comments
4346: +===========================================================================*/
4347: PROCEDURE cm_application(
4348: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4349: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4350: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
4351: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
4352: p_gl_date IN ar_receivable_applications.gl_date%TYPE,

Line 4349: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

4345: | 12-Mar-04 Bhushan Dhotkar Bug 2662270: Added a column p_comments
4346: +===========================================================================*/
4347: PROCEDURE cm_application(
4348: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4349: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4350: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
4351: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
4352: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
4353: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,

Line 4401: l_cm_ps_rec ar_payment_schedules%ROWTYPE;

4397: p_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
4398: p_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE) IS
4399:
4400: l_inv_ra_rec ar_receivable_applications%ROWTYPE;
4401: l_cm_ps_rec ar_payment_schedules%ROWTYPE;
4402: l_ae_doc_rec ae_doc_rec_type;
4403: l_source_type ar_distributions.source_type%TYPE; /* jrautiai BR implementation */
4404: l_flag char; /* added for bug 2318048 */
4405:

Line 4481: from ra_cust_trx_types ctt, ar_payment_schedules ps

4477: the transaction type does not allow overapplication */
4478:
4479: select ps.amount_due_remaining,ps.amount_due_original,ctt.allow_overapplication_flag
4480: into l_inv_bal_amount, l_inv_orig_amount, l_allow_over_application
4481: from ra_cust_trx_types ctt, ar_payment_schedules ps
4482: where ps.payment_schedule_id = p_invoice_ps_id
4483: and ps.cust_trx_type_id = ctt.cust_trx_type_id;
4484:
4485: l_effective_amount_applied := NVL(p_amount_applied,0) ;

Line 4566: FROM ar_payment_schedules

4562: -- to update_cm_related_columns procedure.
4563: --
4564: SELECT *
4565: INTO l_cm_ps_rec
4566: FROM ar_payment_schedules
4567: WHERE payment_schedule_id = p_cm_ps_id;
4568: --
4569: arp_ps_util.update_cm_related_columns(
4570: p_cm_ps_id,

Line 4586: ar_payment_schedules ps

4582: the APP row postable */
4583:
4584: select NVL(ctt.post_to_gl,'N') into l_flag
4585: from ra_cust_trx_types ctt,
4586: ar_payment_schedules ps
4587: where ctt.cust_trx_type_id = ps.cust_trx_type_id
4588: and ps.payment_schedule_id = p_cm_ps_id;
4589:
4590: If l_flag = 'Y' then

Line 4748: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

4744: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
4745: | |
4746: +===========================================================================*/
4747: PROCEDURE validate_cm_appln_args(
4748: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4749: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4750: p_amount_applied IN
4751: ar_receivable_applications.amount_applied%TYPE,
4752: p_apply_date IN ar_receivable_applications.apply_date%TYPE,

Line 4749: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

4745: | |
4746: +===========================================================================*/
4747: PROCEDURE validate_cm_appln_args(
4748: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4749: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4750: p_amount_applied IN
4751: ar_receivable_applications.amount_applied%TYPE,
4752: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
4753: p_gl_date IN ar_receivable_applications.gl_date%TYPE ) IS

Line 4843: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

4839: | inserts to ar_receivable_applications |
4840: | 28-JUL-2003 Jon Beckett Bug 2821139 - added p_customer_reason. |
4841: +===========================================================================*/
4842: PROCEDURE on_account_receipts(
4843: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
4844: p_amount_applied IN
4845: ar_receivable_applications.amount_applied%TYPE,
4846: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
4847: p_gl_date IN ar_receivable_applications.gl_date%TYPE,

Line 4903: l_ps_rec ar_payment_schedules%ROWTYPE;

4899: ar_receivable_applications.secondary_application_ref_num%TYPE := null
4900: ) IS
4901:
4902: l_ra_rec ar_receivable_applications%ROWTYPE;
4903: l_ps_rec ar_payment_schedules%ROWTYPE;
4904:
4905: l_cr_rec ar_cash_receipts%ROWTYPE;
4906: l_amount_due_remaining NUMBER;
4907: ln_batch_id NUMBER;

Line 4957: FROM ar_payment_schedules ps

4953: l_amount_due_remaining,
4954: l_onacc_cc_id,
4955: l_unapp_cc_id
4956: , ln_batch_id
4957: FROM ar_payment_schedules ps
4958: , ar_cash_receipts cr
4959: , ar_cash_receipt_history crh
4960: , ar_receipt_methods rm
4961: , ce_bank_acct_uses ba

Line 5248: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

5244: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
5245: | |
5246: +===========================================================================*/
5247: PROCEDURE validate_on_account_args(
5248: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
5249: p_amount_applied IN
5250: ar_receivable_applications.amount_applied%TYPE,
5251: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
5252: p_gl_date IN ar_receivable_applications.gl_date%TYPE ) IS

Line 5345: ar_payment_schedules.payment_schedule_id%TYPE,

5341: | 04-Mar-05 Jyoti Pandey Bug: 4166986 CC Chargeback logic
5342: +===========================================================================*/
5343: PROCEDURE activity_application(
5344: p_receipt_ps_id IN
5345: ar_payment_schedules.payment_schedule_id%TYPE,
5346: p_application_ps_id IN
5347: ar_receivable_applications.applied_payment_schedule_id%TYPE,
5348: p_link_to_customer_trx_id IN
5349: ar_receivable_applications.link_to_customer_trx_id%TYPE,

Line 5471: FROM ar_payment_schedules ps,

5467: rma.unapplied_ccid,
5468: crh.batch_id,
5469: rt.code_combination_id activity_ccid,
5470: rt.type activity_type
5471: FROM ar_payment_schedules ps,
5472: ar_cash_receipts cr,
5473: ar_cash_receipt_history crh,
5474: ar_receipt_methods rm,
5475: ce_bank_acct_uses ba,

Line 5491: l_ps_rec ar_payment_schedules%ROWTYPE;

5487:
5488: activity_rec activity_c%ROWTYPE;
5489:
5490: l_ra_rec ar_receivable_applications%ROWTYPE;
5491: l_ps_rec ar_payment_schedules%ROWTYPE;
5492: l_cr_rec ar_cash_receipts%ROWTYPE;
5493: l_crcpt_rec ar_cash_receipts%ROWTYPE;
5494:
5495: l_unapp_ra_rec ar_receivable_applications%ROWTYPE; /* MRC */

Line 5507: l_func_amount_due_remaining ar_payment_schedules.amount_due_remaining%TYPE;

5503: l_invoice_currency_code ra_customer_trx.invoice_currency_code%TYPE;
5504: l_receipt_currency_code ar_cash_receipts.currency_code%TYPE;
5505: l_exchange_rate ra_customer_trx.exchange_rate%TYPE;
5506: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
5507: l_func_amount_due_remaining ar_payment_schedules.amount_due_remaining%TYPE;
5508:
5509: l_fnd_api_constants_rec ar_bills_main.fnd_api_constants_type := ar_bills_main.get_fnd_api_constants_rec;
5510: l_fnd_msg_pub_constants_rec ar_bills_main.fnd_msg_pub_constants_type := ar_bills_main.get_fnd_msg_pub_constants_rec;
5511: l_attribute_rec AR_RECEIPT_API_PUB.attribute_rec_type;

Line 5868: FROM ar_payment_schedules

5864: SELECT invoice_currency_code,
5865: exchange_rate
5866: INTO l_receipt_currency_code,
5867: l_exchange_rate
5868: FROM ar_payment_schedules
5869: WHERE payment_schedule_id = p_application_ps_id;
5870: ELSE
5871: l_exchange_rate := l_ps_rec.exchange_rate;
5872: END IF;

Line 6225: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

6221: | schedule_id of -3 for receipt write-off|
6222: | |
6223: +===========================================================================*/
6224: PROCEDURE validate_activity_args(
6225: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
6226: p_application_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE,
6227: p_link_to_customer_trx_id IN ar_receivable_applications.link_to_customer_trx_id%TYPE,
6228: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
6229: p_apply_date IN ar_receivable_applications.apply_date%TYPE,

Line 6293: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

6289: | MODIFICATION HISTORY - Created by Jani Rautiainen - 14-APR-2000 |
6290: | |
6291: +===========================================================================*/
6292: PROCEDURE fetch_app_ccid(
6293: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
6294: p_applied_customer_trx_id OUT NOCOPY ar_receivable_applications.applied_customer_trx_id%TYPE,
6295: p_code_combination_id OUT NOCOPY ar_receivable_applications.code_combination_id%TYPE,
6296: p_source_type OUT NOCOPY ar_distributions.source_type%TYPE) IS
6297:

Line 6303: FROM ar_payment_schedules ps

6299: CURSOR doc_cur IS
6300: SELECT ps.customer_trx_id,
6301: ps.class,
6302: ps.amount_due_original
6303: FROM ar_payment_schedules ps
6304: WHERE ps.payment_schedule_id = p_invoice_ps_id;
6305:
6306: /* Cursor to fetch normal transaction CCID, the old functionality */
6307: CURSOR trx_dist_cur(l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE) IS

Line 6533: FROM ar_payment_schedules ps

6529: p_applied_ps_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE) RETURN BOOLEAN IS
6530:
6531: CURSOR trx_class_cur IS
6532: SELECT ps.class
6533: FROM ar_payment_schedules ps
6534: WHERE ps.payment_schedule_id = p_applied_ps_id;
6535:
6536: CURSOR current_BR_cur IS
6537: SELECT trh.status, trh.event

Line 6651: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

6647: | and Prepayments. Bug Fix 4025652. |
6648: | 14-OCT-2005 Jon Beckett Bug 4565758 - legal entity passed to TM |
6649: +===========================================================================*/
6650: PROCEDURE other_account_application(
6651: p_receipt_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
6652: p_amount_applied IN
6653: ar_receivable_applications.amount_applied%TYPE,
6654: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
6655: p_gl_date IN ar_receivable_applications.gl_date%TYPE,

Line 6725: l_ps_rec ar_payment_schedules%ROWTYPE;

6721: , x_claim_reason_name OUT NOCOPY VARCHAR2
6722: , p_called_from IN VARCHAR2) IS
6723:
6724: l_ra_rec ar_receivable_applications%ROWTYPE;
6725: l_ps_rec ar_payment_schedules%ROWTYPE;
6726:
6727: l_cr_rec ar_cash_receipts%ROWTYPE;
6728: l_amount_due_remaining NUMBER;
6729: ln_batch_id NUMBER;

Line 6810: FROM ar_payment_schedules ps

6806: , l_customer_id
6807: , l_customer_site_use_id
6808: , l_receipt_number
6809: , l_legal_entity_id
6810: FROM ar_payment_schedules ps
6811: , ar_cash_receipts cr
6812: , ar_cash_receipt_history crh
6813: , ar_receipt_methods rm
6814: , ce_bank_acct_uses ba

Line 7488: l_active_claim_flag ar_payment_schedules.active_claim_flag%TYPE;

7484: l_return_status VARCHAR2(1);
7485: l_object_version_number NUMBER;
7486: l_claim_number VARCHAR2(30);
7487: l_amount_from_dispute NUMBER;
7488: l_active_claim_flag ar_payment_schedules.active_claim_flag%TYPE;
7489: l_amount_due_original NUMBER;
7490:
7491: BEGIN
7492: IF PG_DEBUG in ('Y', 'C') THEN

Line 7526: FROM ar_payment_schedules

7522: l_claim_rec.source_object_id := p_customer_trx_id;
7523: l_claim_rec.source_object_class := 'INVOICE';
7524: SELECT amount_due_original
7525: INTO l_amount_due_original
7526: FROM ar_payment_schedules
7527: WHERE payment_schedule_id = p_invoice_ps_id;
7528: ELSE
7529: l_claim_rec.source_object_id := NULL;
7530: l_claim_rec.source_object_class := NULL;

Line 7730: FROM ar_payment_schedules

7726: customer_site_use_id,
7727: class,
7728: trx_date,
7729: dispute_date
7730: FROM ar_payment_schedules
7731: WHERE payment_schedule_id = p_ps_id;
7732: BEGIN
7733: IF PG_DEBUG in ('Y', 'C') THEN
7734: arp_standard.debug( 'arp_process_application.put_trx_in_dispute()+' );

Line 7787: UPDATE ar_payment_schedules ps

7783: END IF;--if(l_new_dispute_amount <>....
7784: END IF;--IF get_existing_ps%ROWCOUNT>0 THEN
7785: CLOSE get_existing_ps;
7786:
7787: UPDATE ar_payment_schedules ps
7788: SET ps.amount_in_dispute = nvl(ps.amount_in_dispute,0) + p_dispute_amount,
7789: ps.dispute_date = SYSDATE,
7790: last_updated_by = l_user_id,
7791: last_update_login = l_last_update_login,

Line 7833: FROM ar_payment_schedules

7829: SELECT payment_schedule_id,
7830: amount_in_dispute,
7831: amount_due_remaining,
7832: dispute_date
7833: FROM ar_payment_schedules
7834: WHERE payment_schedule_id = p_ps_id;
7835: BEGIN
7836: l_user_id := arp_standard.profile.user_id;
7837: l_last_update_login := arp_standard.profile.last_update_login;

Line 7874: UPDATE ar_payment_schedules ps

7870: p_lastUpdateLogin =>l_last_update_login);
7871: END IF;--if(l_new_dispute_amount <> l_old_dispute_amount)
7872: END IF;--IF get_existing_ps%ROWCOUNT>0 THEN
7873: CLOSE get_existing_ps;
7874: UPDATE ar_payment_schedules ps
7875: SET ps.amount_in_dispute = DECODE(ps.amount_in_dispute, p_amount, NULL,
7876: (ps.amount_in_dispute-p_amount)),
7877: ps.dispute_date = SYSDATE,
7878: last_updated_by = l_user_id,

Line 8190: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

8186: | jbeckett 10-JAN-05 Created for credit memo refunds. |
8187: | |
8188: +===========================================================================*/
8189: PROCEDURE cm_activity_application(
8190: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
8191: p_application_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
8192: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
8193: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
8194: p_gl_date IN ar_receivable_applications.gl_date%TYPE,

Line 8191: p_application_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

8187: | |
8188: +===========================================================================*/
8189: PROCEDURE cm_activity_application(
8190: p_cm_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
8191: p_application_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
8192: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
8193: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
8194: p_gl_date IN ar_receivable_applications.gl_date%TYPE,
8195: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE,

Line 8249: l_cm_ps_rec ar_payment_schedules%ROWTYPE;

8245: x_msg_count OUT NOCOPY NUMBER,
8246: x_msg_data OUT NOCOPY VARCHAR2) IS
8247:
8248: l_inv_ra_rec ar_receivable_applications%ROWTYPE;
8249: l_cm_ps_rec ar_payment_schedules%ROWTYPE;
8250: l_ae_doc_rec ae_doc_rec_type;
8251: l_source_type ar_distributions.source_type%TYPE; /* jrautiai BR implementation */
8252: l_flag char;
8253: l_fnd_api_constants_rec ar_bills_main.fnd_api_constants_type := ar_bills_main.get_fnd_api_constants_rec;

Line 8333: ar_payment_schedules ps

8329: 'Y' );
8330:
8331: select NVL(ctt.post_to_gl,'N') into l_flag
8332: from ra_cust_trx_types ctt,
8333: ar_payment_schedules ps
8334: where ctt.cust_trx_type_id = ps.cust_trx_type_id
8335: and ps.payment_schedule_id = p_cm_ps_id;
8336:
8337: If l_flag = 'Y' then