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.AR_AUTOREC_API dependencies on AR_PAYMENT_SCHEDULES

Line 107: update AR_payment_schedules SET

103: IF PG_DEBUG in ('Y','C') THEN
104: arp_debug.debug ( 'NO of Receipts updated CRH = '|| to_char(SQL%ROWCOUNT));
105: END IF;
106:
107: update AR_payment_schedules SET
108: created_by = pg_created_by,
109: last_update_date = sysdate,
110: last_updated_by = pg_created_by,
111: last_update_login = pg_last_update_login,

Line 142: update ar_payment_schedules

138:
139: /* UPDATING INVOICE PS 7271561*/
140: /* Bug 10137089 : Do not update receipt_batch_id
141: if require confirm flag is checked on receipt class */
142: update ar_payment_schedules
143: set selected_for_receipt_batch_id = NULL
144: where payment_schedule_id in
145: ( select /*+ unnest */ r.payment_schedule_id
146: from ar_receipts_gt r,

Line 311: UPDATE ar_payment_schedules

307: p_approval_mode => 'RE-APPROVAL');
308:
309:
310: --nullify the batch_id for closed invoices
311: UPDATE ar_payment_schedules
312: SET selected_for_receipt_batch_id = null
313: WHERE selected_for_receipt_batch_id = p_batch_id
314: AND status = 'CL';
315:

Line 1562: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,

1558: | 16-JUL-2005 bichatte Created |
1559: *=========================================================================*/
1560:
1561: PROCEDURE select_valid_invoices(
1562: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,
1563: p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,
1564: p_due_date_l IN ar_payment_schedules.due_date%TYPE,
1565: p_due_date_h IN ar_payment_schedules.due_date%TYPE,
1566: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,

Line 1563: p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,

1559: *=========================================================================*/
1560:
1561: PROCEDURE select_valid_invoices(
1562: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,
1563: p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,
1564: p_due_date_l IN ar_payment_schedules.due_date%TYPE,
1565: p_due_date_h IN ar_payment_schedules.due_date%TYPE,
1566: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,
1567: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,

Line 1564: p_due_date_l IN ar_payment_schedules.due_date%TYPE,

1560:
1561: PROCEDURE select_valid_invoices(
1562: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,
1563: p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,
1564: p_due_date_l IN ar_payment_schedules.due_date%TYPE,
1565: p_due_date_h IN ar_payment_schedules.due_date%TYPE,
1566: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,
1567: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,
1568: p_doc_num_l IN ra_customer_trx.doc_sequence_value%TYPE,

Line 1565: p_due_date_h IN ar_payment_schedules.due_date%TYPE,

1561: PROCEDURE select_valid_invoices(
1562: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,
1563: p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,
1564: p_due_date_l IN ar_payment_schedules.due_date%TYPE,
1565: p_due_date_h IN ar_payment_schedules.due_date%TYPE,
1566: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,
1567: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,
1568: p_doc_num_l IN ra_customer_trx.doc_sequence_value%TYPE,
1569: p_doc_num_h IN ra_customer_trx.doc_sequence_value%TYPE,

Line 1566: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,

1562: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,
1563: p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,
1564: p_due_date_l IN ar_payment_schedules.due_date%TYPE,
1565: p_due_date_h IN ar_payment_schedules.due_date%TYPE,
1566: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,
1567: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,
1568: p_doc_num_l IN ra_customer_trx.doc_sequence_value%TYPE,
1569: p_doc_num_h IN ra_customer_trx.doc_sequence_value%TYPE,
1570: p_customer_number_l IN hz_cust_accounts.account_number%TYPE, --Bug6734688

Line 1567: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,

1563: p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,
1564: p_due_date_l IN ar_payment_schedules.due_date%TYPE,
1565: p_due_date_h IN ar_payment_schedules.due_date%TYPE,
1566: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,
1567: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,
1568: p_doc_num_l IN ra_customer_trx.doc_sequence_value%TYPE,
1569: p_doc_num_h IN ra_customer_trx.doc_sequence_value%TYPE,
1570: p_customer_number_l IN hz_cust_accounts.account_number%TYPE, --Bug6734688
1571: p_customer_number_h IN hz_cust_accounts.account_number%TYPE, --Bug6734688

Line 1693: ar_payment_schedules ps,

1689: ra_customer_trx ct,
1690: IBY_FNDCPT_TX_EXTENSIONS X,
1691: IBY_PMT_INSTR_USES_ALL U,
1692: IBY_FNDCPT_PMT_CHNNLS_B P,
1693: ar_payment_schedules ps,
1694: ar_payment_schedules_all ps1 ';
1695:
1696: --Bug6734688
1697: IF p_customer_number_l IS NOT NULL OR p_customer_number_h IS NOT NULL

Line 1694: ar_payment_schedules_all ps1 ';

1690: IBY_FNDCPT_TX_EXTENSIONS X,
1691: IBY_PMT_INSTR_USES_ALL U,
1692: IBY_FNDCPT_PMT_CHNNLS_B P,
1693: ar_payment_schedules ps,
1694: ar_payment_schedules_all ps1 ';
1695:
1696: --Bug6734688
1697: IF p_customer_number_l IS NOT NULL OR p_customer_number_h IS NOT NULL
1698: OR p_customer_name_l IS NOT NULL OR p_customer_name_h IS NOT NULL THEN

Line 1903: update ar_payment_schedules

1899: IF p_approve_only_flag = 'N' THEN
1900: IF PG_DEBUG in ('Y', 'C') THEN
1901: arp_debug.debug('Stamping batch_id to PS : '||l_rows_processed);
1902: END IF;
1903: update ar_payment_schedules
1904: set selected_for_receipt_batch_id = p_batch_id
1905: where payment_schedule_id in
1906: ( select /*+ cardinality(a 10) */
1907: payment_schedule_id

Line 2014: from ar_payment_schedules ps,

2010: l_allow_overappln_flag,
2011: l_calc_discount_on_lines_flag,
2012: l_amount_line_items_original,
2013: l_partial_discount_flag
2014: from ar_payment_schedules ps,
2015: ra_cust_trx_types ctt,
2016: ra_terms rt
2017: where ps.payment_schedule_id = l_applied_payment_schedule_id
2018: AND ps.cust_trx_type_id = ctt.cust_trx_type_id

Line 2109: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,

2105: PROCEDURE insert_exceptions(
2106: p_batch_id IN ar_batches.batch_id%TYPE DEFAULT NULL,
2107: p_request_id IN ar_cash_receipts.request_id%TYPE DEFAULT NULL,
2108: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
2109: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
2110: p_paying_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
2111: p_paying_site_use_id IN ar_cash_receipts.customer_site_use_id%TYPE DEFAULT NULL,
2112: p_due_date IN ar_payment_schedules.due_date%TYPE DEFAULT NULL,
2113: p_cust_min_rec_amount IN NUMBER DEFAULT NULL,

Line 2112: p_due_date IN ar_payment_schedules.due_date%TYPE DEFAULT NULL,

2108: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
2109: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
2110: p_paying_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
2111: p_paying_site_use_id IN ar_cash_receipts.customer_site_use_id%TYPE DEFAULT NULL,
2112: p_due_date IN ar_payment_schedules.due_date%TYPE DEFAULT NULL,
2113: p_cust_min_rec_amount IN NUMBER DEFAULT NULL,
2114: p_bank_min_rec_amount IN NUMBER DEFAULT NULL,
2115: p_exception_code IN VARCHAR2,
2116: p_additional_message IN VARCHAR2

Line 2418: from ar_payment_schedules ps,

2414: ps.customer_trx_id trx_id,
2415: r.receipt_number rec_num,
2416: r.cash_receipt_id cash_receipt_id,
2417: ps.org_id org_id
2418: from ar_payment_schedules ps,
2419: ra_customer_trx trx,
2420: ar_receipts_gt r
2421: where trx.customer_trx_id = ps.customer_trx_id
2422: and trx.cc_error_flag = 'Y'

Line 2580: update ar_payment_schedules

2576: END IF;
2577: END;
2578: /* End of delete XLA events code */
2579:
2580: update ar_payment_schedules
2581: set selected_for_receipt_batch_id = null,
2582: gl_date_closed = TO_DATE('4712/12/31', 'YYYY/MM/DD'),
2583: actual_date_closed = TO_DATE('4712/12/31', 'YYYY/MM/DD'),
2584: status = 'OP'

Line 2587: from ar_payment_schedules ps,

2583: actual_date_closed = TO_DATE('4712/12/31', 'YYYY/MM/DD'),
2584: status = 'OP'
2585: where payment_schedule_id in
2586: ( select ps.payment_schedule_id
2587: from ar_payment_schedules ps,
2588: ra_customer_trx trx,
2589: ar_receipts_gt r
2590: where r.gt_id = p_gt_id
2591: AND r.payment_schedule_id = ps.payment_schedule_id

Line 2600: from ar_payment_schedules

2596: arp_debug.debug ( ' rows updated PS = ' || SQL%ROWCOUNT );
2597: END IF;
2598:
2599: delete
2600: from ar_payment_schedules
2601: where cash_receipt_id
2602: in ( select distinct ex.cash_receipt_id
2603: from ar_autorec_exceptions ex,
2604: ar_receipts_gt r

Line 3339: ar_payment_schedules ps,

3335: ps.amount_due_remaining,
3336: -1 gt_id
3337: from ar_cash_receipt_history crh,
3338: ar_cash_receipts cr,
3339: ar_payment_schedules ps,
3340: ra_customer_trx ct,
3341: iby_fndcpt_tx_xe_copies cp
3342: where crh.batch_id = :p_batch_id
3343: and cr.status = ''UNAPP''

Line 3370: ar_payment_schedules ps

3366: null cash_receipt_id
3367: from ar_receipts_gt gt,
3368: iby_fndcpt_tx_extensions ext,
3369: hz_cust_accounts hca,
3370: ar_payment_schedules ps
3371: where ext.trxn_extension_id = gt.payment_trxn_extension_id
3372: and hca.cust_account_id = gt.paying_customer_id
3373: and ps.payment_schedule_id = gt.payment_schedule_id
3374: group by gt.customer_trx_id,

Line 3400: ar_payment_schedules ps,

3396: ps.amount_due_remaining,
3397: -1 gt_id
3398: from ar_cash_receipt_history crh,
3399: ar_cash_receipts cr,
3400: ar_payment_schedules ps,
3401: ra_customer_trx ct
3402: where crh.batch_id = :p_batch_id
3403: and cr.status = ''UNAPP''
3404: and ps.customer_trx_id = ct.customer_trx_id

Line 3454: ar_payment_schedules ps,

3450: ps.amount_due_remaining,
3451: -1 gt_id
3452: from ar_cash_receipt_history crh,
3453: ar_cash_receipts cr,
3454: ar_payment_schedules ps,
3455: ra_customer_trx ct
3456: where crh.batch_id = :p_batch_id
3457: and cr.status = ''UNAPP''
3458: and ps.customer_trx_id = ct.customer_trx_id

Line 3529: FROM ar_payment_schedules ps,

3525: SUM( ps.amount_due_remaining )
3526: OVER( PARTITION BY ct.bill_to_site_use_id,ps.due_date) group_amount,
3527: ct.bill_to_site_use_id,
3528: ps.customer_trx_id
3529: FROM ar_payment_schedules ps,
3530: ra_customer_trx ct
3531: WHERE ps.customer_trx_id = ct.customer_trx_id
3532: AND ps.selected_for_receipt_batch_id = :batch_id
3533: ) ps

Line 3610: FROM ar_payment_schedules ps,

3606: ps.amount_due_remaining,
3607: SUM( ps.amount_due_remaining )
3608: OVER( PARTITION BY ct.bill_to_customer_id,ps.due_date) group_amount,
3609: ps.customer_trx_id
3610: FROM ar_payment_schedules ps,
3611: ra_customer_trx ct
3612: WHERE ps.customer_trx_id = ct.customer_trx_id
3613: AND ps.selected_for_receipt_batch_id = :batch_id
3614: ) ps

Line 3976: SELECT /+INDEX(rgt AR_RECEIPTS_GT_N1) INDEX(inv_ps AR_PAYMENT_SCHEDULES_U1) INDEX(ps AR_PAYMENT_SCHEDULES_U2) /

3972: AND rgt.gt_id = p_gt_id;
3973:
3974:
3975: CURSOR appl_rec_cur( p_gt_id NUMBER) IS
3976: SELECT /*+INDEX(rgt AR_RECEIPTS_GT_N1) INDEX(inv_ps AR_PAYMENT_SCHEDULES_U1) INDEX(ps AR_PAYMENT_SCHEDULES_U2) */
3977: cr.pay_from_customer customer_id,
3978: crh.gl_date cr_gl_date,
3979: cr.amount cr_amount,
3980: cr.customer_site_use_id cust_site_use_id,

Line 4043: ar_payment_schedules ps,

4039: ot.location location,
4040: rgt.amount_due_remaining amount_apply
4041: FROM ar_cash_receipts cr,
4042: ar_cash_receipt_history crh,
4043: ar_payment_schedules ps,
4044: ra_cust_trx_types ctt,
4045: ar_payment_schedules inv_ps,
4046: ar_receipt_method_accounts rma,
4047: ar_receivables_trx ed,

Line 4045: ar_payment_schedules inv_ps,

4041: FROM ar_cash_receipts cr,
4042: ar_cash_receipt_history crh,
4043: ar_payment_schedules ps,
4044: ra_cust_trx_types ctt,
4045: ar_payment_schedules inv_ps,
4046: ar_receipt_method_accounts rma,
4047: ar_receivables_trx ed,
4048: ar_receivables_trx uned,
4049: ar_open_trx_v ot,

Line 4382: from ar_payment_schedules

4378:
4379: IF l_rcpt_info_tab(i).payment_schedule_id IS NOT NULL THEN
4380: select nvl(terms_sequence_number,1)
4381: into l_installment
4382: from ar_payment_schedules
4383: where payment_schedule_id = l_rcpt_info_tab(i).payment_schedule_id;
4384: END IF;
4385:
4386: IF PG_DEBUG in ('Y', 'C') THEN

Line 4526: delete from ar_payment_schedules

4522: IF PG_DEBUG in ('Y','C') THEN
4523: arp_standard.debug('Delete unbalanced receipt with receipt_id : '||l_receipt_id_array(j));
4524: END IF;
4525:
4526: delete from ar_payment_schedules
4527: where cash_receipt_id = l_receipt_id_array(j);
4528:
4529: IF PG_DEBUG in ('Y','C') THEN
4530: arp_standard.debug ( ' rows DELETED PS = ' || SQL%ROWCOUNT );

Line 4680: UPDATE ar_payment_schedules

4676: p_exception_code => l_err_code_array(k),
4677: p_additional_message => l_cc_err_text_array(k) );
4678:
4679: --make the errored receipts avaliable for future runs
4680: UPDATE ar_payment_schedules
4681: SET selected_for_receipt_batch_id = NULL
4682: WHERE payment_schedule_id = rec.payment_schedule_id;
4683:
4684: ELSIF l_err_code_array(k) = 'PROCESS_PAYMENT_FAILED'

Line 4749: FROM ar_payment_schedules

4745: program_id = pg_program_id,
4746: program_update_date = sysdate
4747: WHERE customer_trx_id IN
4748: ( SELECT customer_trx_id
4749: FROM ar_payment_schedules
4750: WHERE payment_schedule_id = l_rcpt_info_tab(i).payment_schedule_id
4751: );
4752: END IF;
4753: END IF;

Line 4859: UPDATE AR_PAYMENT_SCHEDULES PS SET (

4855: arp_standard.debug('Exception: Invoice PS ID: '||unbal_rec_appln.applied_payment_schedule_id);
4856: arp_standard.debug('Exception: CR ID: '||l_unbal_rcpt_tab(i).cash_receipt_id);
4857:
4858: arp_standard.debug('Update Invoice PS Before deleting Application');
4859: UPDATE AR_PAYMENT_SCHEDULES PS SET (
4860: PS.AMOUNT_DUE_REMAINING,
4861: PS.AMOUNT_APPLIED,
4862: PS.AMOUNT_LINE_ITEMS_REMAINING,
4863: PS.RECEIVABLES_CHARGES_REMAINING,

Line 4915: UPDATE AR_PAYMENT_SCHEDULES PS SET (

4911: AND RA1.RECEIVABLE_APPLICATION_ID = unbal_rec_appln.source_id_secondary )
4912: WHERE PS.PAYMENT_SCHEDULE_ID = unbal_rec_appln.applied_payment_schedule_id;
4913:
4914: arp_standard.debug('Update Receipt PS Before deleting Application');
4915: UPDATE AR_PAYMENT_SCHEDULES PS SET (
4916: PS.AMOUNT_DUE_REMAINING,
4917: PS.AMOUNT_APPLIED,
4918: PS.ACCTD_AMOUNT_DUE_REMAINING,
4919: PS.STATUS,

Line 5111: update ar_payment_schedules

5107: AND cr.cash_receipt_id = arg.cash_receipt_id
5108: );
5109: arp_debug.debug ( 'NO of Receipts updated = '|| to_char(SQL%ROWCOUNT));
5110:
5111: update ar_payment_schedules
5112: SET TRX_NUMBER =
5113: NVL(SUBSTR(TRX_NUMBER, 1, INSTR(TRX_NUMBER,'-', -1) -1), TRX_NUMBER)
5114: WHERE cash_receipt_id in
5115: ( select ps.cash_receipt_id

Line 5116: from ar_payment_schedules ps,

5112: SET TRX_NUMBER =
5113: NVL(SUBSTR(TRX_NUMBER, 1, INSTR(TRX_NUMBER,'-', -1) -1), TRX_NUMBER)
5114: WHERE cash_receipt_id in
5115: ( select ps.cash_receipt_id
5116: from ar_payment_schedules ps,
5117: ar_receipts_gt arg
5118: where arg.gt_id = l_gt_id
5119: AND ps.cash_receipt_id = arg.cash_receipt_id
5120: );