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_CASH_RECEIPTS

Line 17: p_receipt_method_id in ar_cash_receipts.receipt_method_id%type default null,

13:
14: PROCEDURE SUBMIT_FORMAT ( p_batch_id ar_batches.batch_id%TYPE);
15:
16: PROCEDURE process_selected_receipts(
17: p_receipt_method_id in ar_cash_receipts.receipt_method_id%type default null,
18: p_batch_id in ar_batches.batch_id%type,
19: p_approval_mode IN VARCHAR2 DEFAULT 'APPROVE'
20: );
21:

Line 27: g_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;

23:
24:
25: g_rcpt_creation_rec rcpt_creation_info;
26:
27: g_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
28: g_format_flag ar_cash_receipts.confirmed_flag%TYPE ;
29: g_create_flag ar_cash_receipts.confirmed_flag%TYPE ;
30:
31: g_party_id NUMBER;

Line 28: g_format_flag ar_cash_receipts.confirmed_flag%TYPE ;

24:
25: g_rcpt_creation_rec rcpt_creation_info;
26:
27: g_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
28: g_format_flag ar_cash_receipts.confirmed_flag%TYPE ;
29: g_create_flag ar_cash_receipts.confirmed_flag%TYPE ;
30:
31: g_party_id NUMBER;
32: g_pmt_channel_code VARCHAR2(30);

Line 29: g_create_flag ar_cash_receipts.confirmed_flag%TYPE ;

25: g_rcpt_creation_rec rcpt_creation_info;
26:
27: g_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
28: g_format_flag ar_cash_receipts.confirmed_flag%TYPE ;
29: g_create_flag ar_cash_receipts.confirmed_flag%TYPE ;
30:
31: g_party_id NUMBER;
32: g_pmt_channel_code VARCHAR2(30);
33: g_assignment_id NUMBER;

Line 69: update ar_cash_receipts

65: IF PG_DEBUG in ('Y', 'C') THEN
66: arp_debug.debug('process_events()+');
67: END IF;
68:
69: update ar_cash_receipts
70: SET creation_date = sysdate,
71: created_by = pg_created_by,
72: last_update_date = sysdate,
73: last_updated_by = pg_created_by,

Line 402: l_request_id ar_cash_receipts.request_id%TYPE;

398: ) IS
399:
400: l_current_worker_number NUMBER;
401: l_total_workers NUMBER;
402: l_request_id ar_cash_receipts.request_id%TYPE;
403: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
404: l_batch_date ar_cash_receipts.receipt_date%TYPE ;
405: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;
406: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;

Line 404: l_batch_date ar_cash_receipts.receipt_date%TYPE ;

400: l_current_worker_number NUMBER;
401: l_total_workers NUMBER;
402: l_request_id ar_cash_receipts.request_id%TYPE;
403: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
404: l_batch_date ar_cash_receipts.receipt_date%TYPE ;
405: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;
406: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;
407: l_currency_code ar_cash_receipts.currency_code%TYPE;
408: l_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;

Line 406: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;

402: l_request_id ar_cash_receipts.request_id%TYPE;
403: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
404: l_batch_date ar_cash_receipts.receipt_date%TYPE ;
405: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;
406: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;
407: l_currency_code ar_cash_receipts.currency_code%TYPE;
408: l_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
409: l_format_flag ar_cash_receipts.confirmed_flag%TYPE ;
410: l_create_flag ar_cash_receipts.confirmed_flag%TYPE ;

Line 407: l_currency_code ar_cash_receipts.currency_code%TYPE;

403: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
404: l_batch_date ar_cash_receipts.receipt_date%TYPE ;
405: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;
406: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;
407: l_currency_code ar_cash_receipts.currency_code%TYPE;
408: l_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
409: l_format_flag ar_cash_receipts.confirmed_flag%TYPE ;
410: l_create_flag ar_cash_receipts.confirmed_flag%TYPE ;
411: o_batch_id NUMBER;

Line 408: l_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;

404: l_batch_date ar_cash_receipts.receipt_date%TYPE ;
405: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;
406: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;
407: l_currency_code ar_cash_receipts.currency_code%TYPE;
408: l_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
409: l_format_flag ar_cash_receipts.confirmed_flag%TYPE ;
410: l_create_flag ar_cash_receipts.confirmed_flag%TYPE ;
411: o_batch_id NUMBER;
412: l_approve_only_flag VARCHAR2(1);

Line 409: l_format_flag ar_cash_receipts.confirmed_flag%TYPE ;

405: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;
406: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;
407: l_currency_code ar_cash_receipts.currency_code%TYPE;
408: l_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
409: l_format_flag ar_cash_receipts.confirmed_flag%TYPE ;
410: l_create_flag ar_cash_receipts.confirmed_flag%TYPE ;
411: o_batch_id NUMBER;
412: l_approve_only_flag VARCHAR2(1);
413: l_batch_app_status VARCHAR2(200);

Line 410: l_create_flag ar_cash_receipts.confirmed_flag%TYPE ;

406: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;
407: l_currency_code ar_cash_receipts.currency_code%TYPE;
408: l_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
409: l_format_flag ar_cash_receipts.confirmed_flag%TYPE ;
410: l_create_flag ar_cash_receipts.confirmed_flag%TYPE ;
411: o_batch_id NUMBER;
412: l_approve_only_flag VARCHAR2(1);
413: l_batch_app_status VARCHAR2(200);
414:

Line 989: l_request_id ar_cash_receipts.request_id%TYPE;

985:
986: l_worker_number NUMBER ;
987: l_complete BOOLEAN := FALSE;
988:
989: l_request_id ar_cash_receipts.request_id%TYPE;
990: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
991: l_batch_date ar_cash_receipts.receipt_date%TYPE ;
992: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;
993: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;

Line 991: l_batch_date ar_cash_receipts.receipt_date%TYPE ;

987: l_complete BOOLEAN := FALSE;
988:
989: l_request_id ar_cash_receipts.request_id%TYPE;
990: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
991: l_batch_date ar_cash_receipts.receipt_date%TYPE ;
992: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;
993: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;
994: l_currency_code ar_cash_receipts.currency_code%TYPE;
995: l_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;

Line 993: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;

989: l_request_id ar_cash_receipts.request_id%TYPE;
990: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
991: l_batch_date ar_cash_receipts.receipt_date%TYPE ;
992: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;
993: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;
994: l_currency_code ar_cash_receipts.currency_code%TYPE;
995: l_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
996: l_format_flag ar_cash_receipts.confirmed_flag%TYPE ;
997: l_create_flag ar_cash_receipts.confirmed_flag%TYPE ;

Line 994: l_currency_code ar_cash_receipts.currency_code%TYPE;

990: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
991: l_batch_date ar_cash_receipts.receipt_date%TYPE ;
992: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;
993: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;
994: l_currency_code ar_cash_receipts.currency_code%TYPE;
995: l_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
996: l_format_flag ar_cash_receipts.confirmed_flag%TYPE ;
997: l_create_flag ar_cash_receipts.confirmed_flag%TYPE ;
998: l_approve_only_flag ar_cash_receipts.confirmed_flag%TYPE;

Line 995: l_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;

991: l_batch_date ar_cash_receipts.receipt_date%TYPE ;
992: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;
993: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;
994: l_currency_code ar_cash_receipts.currency_code%TYPE;
995: l_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
996: l_format_flag ar_cash_receipts.confirmed_flag%TYPE ;
997: l_create_flag ar_cash_receipts.confirmed_flag%TYPE ;
998: l_approve_only_flag ar_cash_receipts.confirmed_flag%TYPE;
999: o_batch_id NUMBER;

Line 996: l_format_flag ar_cash_receipts.confirmed_flag%TYPE ;

992: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;
993: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;
994: l_currency_code ar_cash_receipts.currency_code%TYPE;
995: l_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
996: l_format_flag ar_cash_receipts.confirmed_flag%TYPE ;
997: l_create_flag ar_cash_receipts.confirmed_flag%TYPE ;
998: l_approve_only_flag ar_cash_receipts.confirmed_flag%TYPE;
999: o_batch_id NUMBER;
1000: l_batch_lock_msg VARCHAR2(200);

Line 997: l_create_flag ar_cash_receipts.confirmed_flag%TYPE ;

993: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;
994: l_currency_code ar_cash_receipts.currency_code%TYPE;
995: l_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
996: l_format_flag ar_cash_receipts.confirmed_flag%TYPE ;
997: l_create_flag ar_cash_receipts.confirmed_flag%TYPE ;
998: l_approve_only_flag ar_cash_receipts.confirmed_flag%TYPE;
999: o_batch_id NUMBER;
1000: l_batch_lock_msg VARCHAR2(200);
1001: l_batch_lock_flag BOOLEAN;

Line 998: l_approve_only_flag ar_cash_receipts.confirmed_flag%TYPE;

994: l_currency_code ar_cash_receipts.currency_code%TYPE;
995: l_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
996: l_format_flag ar_cash_receipts.confirmed_flag%TYPE ;
997: l_create_flag ar_cash_receipts.confirmed_flag%TYPE ;
998: l_approve_only_flag ar_cash_receipts.confirmed_flag%TYPE;
999: o_batch_id NUMBER;
1000: l_batch_lock_msg VARCHAR2(200);
1001: l_batch_lock_flag BOOLEAN;
1002: l_batch_lock_excp EXCEPTION;

Line 1373: p_batch_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,

1369:
1370:
1371: PROCEDURE insert_batch(
1372: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
1373: p_batch_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
1374: p_receipt_class_id IN ar_receipt_classes.receipt_class_id%TYPE DEFAULT NULL,
1375: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
1376: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
1377: p_approve_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,

Line 1375: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,

1371: PROCEDURE insert_batch(
1372: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
1373: p_batch_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
1374: p_receipt_class_id IN ar_receipt_classes.receipt_class_id%TYPE DEFAULT NULL,
1375: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
1376: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
1377: p_approve_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
1378: p_format_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
1379: p_create_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,

Line 1376: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,

1372: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
1373: p_batch_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
1374: p_receipt_class_id IN ar_receipt_classes.receipt_class_id%TYPE DEFAULT NULL,
1375: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
1376: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
1377: p_approve_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
1378: p_format_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
1379: p_create_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
1380: p_exchange_date IN ar_batches.exchange_date%TYPE DEFAULT NULL,

Line 1377: p_approve_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,

1373: p_batch_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
1374: p_receipt_class_id IN ar_receipt_classes.receipt_class_id%TYPE DEFAULT NULL,
1375: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
1376: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
1377: p_approve_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
1378: p_format_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
1379: p_create_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
1380: p_exchange_date IN ar_batches.exchange_date%TYPE DEFAULT NULL,
1381: p_exchange_rate IN ar_batches.exchange_rate%TYPE DEFAULT NULL,

Line 1378: p_format_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,

1374: p_receipt_class_id IN ar_receipt_classes.receipt_class_id%TYPE DEFAULT NULL,
1375: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
1376: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
1377: p_approve_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
1378: p_format_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
1379: p_create_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
1380: p_exchange_date IN ar_batches.exchange_date%TYPE DEFAULT NULL,
1381: p_exchange_rate IN ar_batches.exchange_rate%TYPE DEFAULT NULL,
1382: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE DEFAULT NULL,

Line 1379: p_create_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,

1375: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
1376: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
1377: p_approve_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
1378: p_format_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
1379: p_create_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
1380: p_exchange_date IN ar_batches.exchange_date%TYPE DEFAULT NULL,
1381: p_exchange_rate IN ar_batches.exchange_rate%TYPE DEFAULT NULL,
1382: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE DEFAULT NULL,
1383: p_batch_id OUT NOCOPY NUMBER

Line 2107: p_request_id IN ar_cash_receipts.request_id%TYPE DEFAULT NULL,

2103: | 16-JUL-2005 bichatte Created |
2104: *=========================================================================*/
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,

Line 2108: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,

2104: *=========================================================================*/
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,

Line 2110: p_paying_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,

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,
2114: p_bank_min_rec_amount IN NUMBER DEFAULT NULL,

Line 2111: p_paying_site_use_id IN ar_cash_receipts.customer_site_use_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,
2114: p_bank_min_rec_amount IN NUMBER DEFAULT NULL,
2115: p_exception_code IN VARCHAR2,

Line 2145: from ar_cash_receipts

2141: IF l_paying_customer_id is null and
2142: p_cash_receipt_id is not null THEN
2143: select pay_from_customer
2144: into l_paying_customer_id
2145: from ar_cash_receipts
2146: where cash_receipt_id = p_cash_receipt_id;
2147: END IF;
2148:
2149: IF PG_DEBUG in ('Y','C') THEN

Line 2238: p_request_id ar_cash_receipts.request_id%TYPE ) IS

2234: | 16-JUL-2005 bichatte Created |
2235: *=========================================================================*/
2236:
2237: PROCEDURE SUBMIT_REPORT ( p_batch_id ar_batches.batch_id%TYPE,
2238: p_request_id ar_cash_receipts.request_id%TYPE ) IS
2239:
2240: l_reqid NUMBER(15);
2241: l_org_id NUMBER;
2242: l_complete BOOLEAN := FALSE;

Line 2338: ar_cash_receipts cr,

2334: WHERE customer_trx_id in
2335: (
2336: SELECT /*+ LEADING(R) INDEX (R, AR_RECEIPTS_GT_N1) USE_NL(R, CR) */ r.customer_trx_id
2337: FROM ar_receipts_gt r,
2338: ar_cash_receipts cr,
2339: ar_cash_receipt_history crh,
2340: iby_fndcpt_tx_operations op,
2341: iby_trxn_summaries_all summ
2342: WHERE r.gt_id = p_gt_id

Line 2370: ar_cash_receipts cr,

2366: delete from ar_autorec_exceptions
2367: where cash_receipt_id in
2368: ( SELECT /*+ LEADING(R) INDEX (R, AR_RECEIPTS_GT_N1) USE_NL(R, CR) */ cr.cash_receipt_id
2369: FROM ar_receipts_gt r,
2370: ar_cash_receipts cr,
2371: ar_cash_receipt_history crh,
2372: iby_fndcpt_tx_operations op,
2373: iby_trxn_summaries_all summ
2374: WHERE r.gt_id = p_gt_id

Line 2676: delete from ar_cash_receipts

2672: IF PG_DEBUG in ('Y','C') THEN
2673: arp_debug.debug ( ' rows DELETED CRH = ' || SQL%ROWCOUNT );
2674: END IF;
2675:
2676: delete from ar_cash_receipts
2677: where cash_receipt_id in
2678: ( select distinct ex.cash_receipt_id
2679: from ar_autorec_exceptions ex,
2680: ar_receipts_gt r

Line 2768: UPDATE ar_cash_receipts

2764: AND rm.auto_print_program_id = app.program_id;
2765:
2766: IF ( l_program_name = 'ARSEPADNT') THEN
2767: IF l_batch_app_status <> 'COMPLETED_FORMAT' AND l_batch_app_status <> 'STARTED_FORMAT' THEN
2768: UPDATE ar_cash_receipts
2769: SET seq_type_last = 'Y'
2770: WHERE cash_receipt_id IN (
2771: SELECT crh.cash_receipt_id
2772: FROM ar_cash_receipt_history crh,

Line 2858: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,

2854: p_gl_date IN DATE, /*Bug 13146325*/
2855: p_customer_id IN NUMBER,
2856: p_installment IN NUMBER,
2857: p_cust_site_use_id IN NUMBER,
2858: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
2859: p_pmt_trxn_ext_id IN RA_CUSTOMER_TRX.PAYMENT_TRXN_EXTENSION_ID%TYPE,
2860: p_called_from IN VARCHAR2,
2861: p_request_id IN NUMBER,
2862: p_batch_id IN NUMBER,

Line 2868: p_cash_receipt_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,

2864: p_exchange_date IN ar_batches.exchange_date%TYPE,
2865: p_exchange_rate_type IN ar_batches.exchange_rate_type%TYPE,
2866: p_currency_code IN VARCHAR2,
2867: p_remittance_bank_account_id IN ar_receipt_method_accounts_all.remit_bank_acct_use_id%TYPE,
2868: p_cash_receipt_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
2869: p_return_status OUT NOCOPY VARCHAR2,
2870: p_msg_count OUT NOCOPY NUMBER,
2871: p_msg_data OUT NOCOPY VARCHAR2 ) IS
2872:

Line 3070: PROCEDURE process_payments( p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,

3066:
3067: END receipt_application;
3068:
3069:
3070: PROCEDURE process_payments( p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
3071: p_pmt_trxn_id IN RA_CUSTOMER_TRX.PAYMENT_TRXN_EXTENSION_ID%TYPE,
3072: p_request_id IN NUMBER,
3073: p_batch_id IN NUMBER,
3074: p_called_from IN VARCHAR2,

Line 3095: from ar_cash_receipts

3091: END IF;
3092:
3093: select payment_trxn_extension_id
3094: into l_pmt_trxn_id
3095: from ar_cash_receipts
3096: where cash_receipt_id = p_cash_receipt_id;
3097:
3098: IF PG_DEBUG in ('Y', 'C') THEN
3099: arp_debug.debug('l_pmt_trxn_id :'||l_pmt_trxn_id);

Line 3338: ar_cash_receipts cr,

3334: cr.cash_receipt_id,
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

Line 3399: ar_cash_receipts cr,

3395: cr.cash_receipt_id,
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''

Line 3453: ar_cash_receipts cr,

3449: cr.cash_receipt_id,
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''

Line 3520: ar_cash_receipts cr,

3516: ORDER BY ps.customer_trx_id, cr.amount) rct_rank,
3517: RANK( ) OVER (PARTITION BY ps.customer_trx_id
3518: ORDER BY cr.cash_receipt_id, cr.amount) inv_rank
3519: from ar_cash_receipt_history crh,
3520: ar_cash_receipts cr,
3521: ( SELECT ps.payment_schedule_id,
3522: ps.selected_for_receipt_batch_id,
3523: ct.bill_to_customer_id,
3524: ps.amount_due_remaining,

Line 3602: ar_cash_receipts cr,

3598: ORDER BY ps.customer_trx_id, cr.amount) rct_rank,
3599: RANK( ) OVER (PARTITION BY ps.customer_trx_id
3600: ORDER BY cr.cash_receipt_id, cr.amount) inv_rank
3601: from ar_cash_receipt_history crh,
3602: ar_cash_receipts cr,
3603: ( SELECT ps.payment_schedule_id,
3604: ps.selected_for_receipt_batch_id,
3605: ct.bill_to_customer_id,
3606: ps.amount_due_remaining,

Line 3857: PROCEDURE process_selected_receipts( p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,

3853:
3854:
3855:
3856:
3857: PROCEDURE process_selected_receipts( p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
3858: p_batch_id IN ar_batches.batch_id%TYPE,
3859: p_approval_mode IN VARCHAR2 DEFAULT 'APPROVE' ) IS
3860:
3861: l_set_of_books_id ar_batches.set_of_books_id%TYPE;

Line 3867: l_receipt_number ar_cash_receipts.receipt_number%TYPE;

3863: l_batch_date ar_batches.batch_date%TYPE;
3864: l_gl_date ar_batches.gl_date%TYPE;
3865: l_currency_code ar_batches.currency_code%TYPE;
3866: l_rec_creation_rule_code ar_receipt_methods.receipt_creation_rule_code%TYPE;
3867: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
3868: l_called_from VARCHAR2(15);
3869: l_cash_receipt_id NUMBER(15);
3870: l_installment NUMBER;
3871: l_create_stmt VARCHAR2(2000);

Line 3890: l_old_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;

3886: l_min_rec_amount_allowed NUMBER;
3887: l_creation_method_code ar_receipt_classes.creation_method_code%type;
3888: l_remittance_bank_account_id ar_receipt_method_accounts_all.remit_bank_acct_use_id%TYPE;
3889: l_state ar_receipt_classes.creation_status%TYPE;
3890: l_old_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
3891:
3892: l_paying_customer_id_array DBMS_SQL.NUMBER_TABLE;
3893: l_paying_site_use_id_array DBMS_SQL.NUMBER_TABLE;
3894: l_due_date_array DBMS_SQL.DATE_TABLE;

Line 4041: FROM ar_cash_receipts cr,

4037: Null rec_charges_charged,
4038: ot.receivables_charges_remaining rec_charges_remaining,
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,

Line 4569: delete from ar_cash_receipts

4565: IF PG_DEBUG in ('Y','C') THEN
4566: arp_standard.debug ( ' rows DELETED CRH = ' || SQL%ROWCOUNT );
4567: END IF;
4568:
4569: delete from ar_cash_receipts
4570: where cash_receipt_id = l_receipt_id_array(j);
4571:
4572: IF PG_DEBUG in ('Y','C') THEN
4573: arp_standard.debug ( ' rows DELETED CR = ' || SQL%ROWCOUNT );

Line 5099: update ar_cash_receipts cr

5095: sine we considered concatenated string of trx_number and term_sequence as
5096: receipt_number during receipt creation.*/
5097: IF l_rec_creation_rule_code = 'PER_INVOICE' AND
5098: l_rec_inher_inv_num_flag = 'Y' THEN
5099: update ar_cash_receipts cr
5100: SET receipt_number =
5101: NVL(SUBSTR(RECEIPT_NUMBER, 1, INSTR(RECEIPT_NUMBER,'-', -1) -1), RECEIPT_NUMBER)
5102: WHERE cash_receipt_id in
5103: ( select cr.cash_receipt_id

Line 5104: from ar_cash_receipts cr,

5100: SET receipt_number =
5101: NVL(SUBSTR(RECEIPT_NUMBER, 1, INSTR(RECEIPT_NUMBER,'-', -1) -1), RECEIPT_NUMBER)
5102: WHERE cash_receipt_id in
5103: ( select cr.cash_receipt_id
5104: from ar_cash_receipts cr,
5105: ar_receipts_gt arg
5106: where arg.gt_id = l_gt_id
5107: AND cr.cash_receipt_id = arg.cash_receipt_id
5108: );

Line 5194: ar_cash_receipts cr,

5190: WHERE customer_trx_id in
5191: (
5192: SELECT /*+ push_pred(trxn_ext) */ r.customer_trx_id
5193: FROM ar_receipts_gt r,
5194: ar_cash_receipts cr,
5195: ar_cash_receipt_history crh,
5196: (SELECT op.trxn_extension_id, summ.status
5197: FROM iby_trxn_summaries_all summ,
5198: iby_fndcpt_tx_operations op

Line 5254: ar_cash_receipts cr,

5250: pg_program_application_id,
5251: pg_program_id,
5252: sysdate
5253: FROM ar_receipts_gt r,
5254: ar_cash_receipts cr,
5255: ar_cash_receipt_history crh,
5256: (SELECT op.trxn_extension_id, summ.status
5257: FROM iby_trxn_summaries_all summ,
5258: iby_fndcpt_tx_operations op