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

Line 71: p_cr_id IN ar_payment_schedules.cash_receipt_id%TYPE,

67: FUNCTION check_cb( p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE )
68: RETURN BOOLEAN;
69: --
70: PROCEDURE modify_update_ps_rec(
71: p_cr_id IN ar_payment_schedules.cash_receipt_id%TYPE,
72: p_reversal_gl_date IN DATE,
73: p_reversal_date IN DATE );
74: --
75: PROCEDURE modify_update_bat_rec( p_bat_id IN ar_batches.batch_id%TYPE,

Line 1174: FROM ar_payment_schedules ps,

1170: END IF;
1171: --
1172: SELECT COUNT(*)
1173: INTO l_count
1174: FROM ar_payment_schedules ps,
1175: ra_cust_trx_line_gl_dist ctlg
1176: WHERE ps.associated_cash_receipt_id = p_cr_id
1177: AND ps.class = 'CB'
1178: AND ps.customer_trx_id = ctlg.customer_trx_id

Line 1235: p_cr_id IN ar_payment_schedules.cash_receipt_id%TYPE,

1231: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
1232: | |
1233: +===========================================================================*/
1234: PROCEDURE modify_update_ps_rec(
1235: p_cr_id IN ar_payment_schedules.cash_receipt_id%TYPE,
1236: p_reversal_gl_date IN DATE,
1237: p_reversal_date IN DATE ) IS
1238: l_gl_date_closed DATE;
1239: l_actual_date_closed DATE;

Line 1240: l_ps_rec ar_payment_schedules%ROWTYPE;

1236: p_reversal_gl_date IN DATE,
1237: p_reversal_date IN DATE ) IS
1238: l_gl_date_closed DATE;
1239: l_actual_date_closed DATE;
1240: l_ps_rec ar_payment_schedules%ROWTYPE;
1241: BEGIN
1242: IF PG_DEBUG in ('Y', 'C') THEN
1243: arp_standard.debug( 'arp_reverse_receipt.modify_update_ps_rec() +' );
1244: arp_standard.debug('modify_update_ps_rec: ' || to_char( p_cr_id ) );

Line 1588: p_dm_number OUT NOCOPY ar_payment_schedules.trx_number%TYPE,

1584: p_attribute12 IN ar_cash_receipts.attribute12%TYPE,
1585: p_attribute13 IN ar_cash_receipts.attribute13%TYPE,
1586: p_attribute14 IN ar_cash_receipts.attribute14%TYPE,
1587: p_attribute15 IN ar_cash_receipts.attribute15%TYPE,
1588: p_dm_number OUT NOCOPY ar_payment_schedules.trx_number%TYPE,
1589: p_dm_doc_sequence_value IN ra_customer_trx.doc_sequence_value%TYPE,
1590: p_dm_doc_sequence_id IN ra_customer_trx.doc_sequence_id%TYPE,
1591: p_status IN OUT NOCOPY VARCHAR2,
1592: p_module_name IN VARCHAR2,

Line 1632: l_dm_number ar_payment_schedules.trx_number%TYPE;

1628:
1629: l_commit_cust_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;
1630: l_rowid rowid;
1631:
1632: l_dm_number ar_payment_schedules.trx_number%TYPE;
1633: --l_sequence_name VARCHAR2(500);
1634: --l_sequence_id NUMBER;
1635: --l_sequence_assignment_id NUMBER;
1636: --l_sequence_value NUMBER;

Line 2063: from ar_payment_schedules

2059: TRX_NUMBER),
2060: REVERSED_CASH_RECEIPT_ID=l_cr_id /*3328690 */
2061: WHERE customer_trx_id = (
2062: select customer_trx_id
2063: from ar_payment_schedules
2064: where class = 'DM'
2065: and reversed_cash_receipt_id = l_cr_id
2066: );
2067: UPDATE ar_payment_schedules

Line 2067: UPDATE ar_payment_schedules

2063: from ar_payment_schedules
2064: where class = 'DM'
2065: and reversed_cash_receipt_id = l_cr_id
2066: );
2067: UPDATE ar_payment_schedules
2068: /* Bug3347452 */
2069: /*SET TRX_NUMBER = NVL(p_dm_doc_sequence_value, TRX_NUMBER)*/
2070: SET TRX_NUMBER = NVL(TO_CHAR(p_dm_doc_sequence_value), TRX_NUMBER)
2071: WHERE reversed_cash_receipt_id = l_cr_id;

Line 2080: from ar_payment_schedules

2076: DOC_SEQUENCE_ID = p_dm_doc_sequence_id,
2077: REVERSED_CASH_RECEIPT_ID=l_cr_id /*3328690 */
2078: WHERE customer_trx_id = (
2079: select customer_trx_id
2080: from ar_payment_schedules
2081: where class = 'DM'
2082: and reversed_cash_receipt_id = l_cr_id
2083: );
2084: END IF;

Line 2093: FROM ar_payment_schedules

2089: --
2090:
2091: SELECT trx_number
2092: INTO l_dm_number
2093: FROM ar_payment_schedules
2094: WHERE reversed_cash_receipt_id = l_cr_id;
2095: -- AND class = 'DM';
2096:
2097: p_dm_number := l_dm_number;

Line 2304: l_invoice_ps_id ar_payment_schedules.payment_schedule_id%TYPE;

2300: x_msg_count OUT NOCOPY NUMBER,
2301: x_msg_data OUT NOCOPY VARCHAR2)
2302: IS
2303: l_claim_id NUMBER;
2304: l_invoice_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
2305: l_claim_reason_code_id NUMBER;
2306: l_claim_reason_name VARCHAR2(80);
2307: l_claim_number VARCHAR2(30);
2308: l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE;

Line 2344: FROM ar_payment_schedules

2340: l_claim_id := NULL;
2341: -- Bug 2946734 - invoice claims not zeroized
2342: SELECT amount_due_remaining
2343: INTO l_claim_amount
2344: FROM ar_payment_schedules
2345: WHERE payment_schedule_id = l_invoice_ps_id;
2346: l_claim_amount := l_claim_amount + c1.amount_applied;
2347: END IF;
2348:

Line 2468: ar_payment_schedules ps

2464:
2465: CURSOR c_netted_receipts IS
2466: SELECT ps.cash_receipt_id, app.amount_applied
2467: FROM ar_receivable_applications app,
2468: ar_payment_schedules ps
2469: WHERE app.applied_payment_schedule_id = ps.payment_schedule_id
2470: AND app.cash_receipt_id = p_cr_id
2471: AND app.display = 'Y'
2472: AND app.receivables_trx_id = -16;