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 9: g_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;

5: G_ERROR varchar2(1) := 'N';
6: PROCEDURE SUBMIT_FORMAT ( p_batch_id ar_batches.batch_id%TYPE);
7: PROCEDURE CONTROL_CHECK ( p_batch_id ar_batches.batch_id%TYPE);
8: g_auth_fail varchar2(1) := 'N';
9: g_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
10: g_format_flag ar_cash_receipts.confirmed_flag%TYPE ;
11: g_create_flag ar_cash_receipts.confirmed_flag%TYPE ;
12:
13: /*========================================================================+

Line 10: g_format_flag ar_cash_receipts.confirmed_flag%TYPE ;

6: PROCEDURE SUBMIT_FORMAT ( p_batch_id ar_batches.batch_id%TYPE);
7: PROCEDURE CONTROL_CHECK ( p_batch_id ar_batches.batch_id%TYPE);
8: g_auth_fail varchar2(1) := 'N';
9: g_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
10: g_format_flag ar_cash_receipts.confirmed_flag%TYPE ;
11: g_create_flag ar_cash_receipts.confirmed_flag%TYPE ;
12:
13: /*========================================================================+
14: | PUBLIC PROCEDURE GET_PARAMETERS |

Line 11: g_create_flag ar_cash_receipts.confirmed_flag%TYPE ;

7: PROCEDURE CONTROL_CHECK ( p_batch_id ar_batches.batch_id%TYPE);
8: g_auth_fail varchar2(1) := 'N';
9: g_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
10: g_format_flag ar_cash_receipts.confirmed_flag%TYPE ;
11: g_create_flag ar_cash_receipts.confirmed_flag%TYPE ;
12:
13: /*========================================================================+
14: | PUBLIC PROCEDURE GET_PARAMETERS |
15: | |

Line 85: l_request_id ar_cash_receipts.request_id%TYPE;

81: p_customer_bank_acc_num_h IN VARCHAR2
82: ) IS
83:
84:
85: l_request_id ar_cash_receipts.request_id%TYPE;
86: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
87: l_batch_date ar_cash_receipts.receipt_date%TYPE ;
88: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;
89: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;

Line 87: l_batch_date ar_cash_receipts.receipt_date%TYPE ;

83:
84:
85: l_request_id ar_cash_receipts.request_id%TYPE;
86: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
87: l_batch_date ar_cash_receipts.receipt_date%TYPE ;
88: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;
89: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;
90: l_currency_code ar_cash_receipts.currency_code%TYPE;
91: l_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;

Line 89: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;

85: l_request_id ar_cash_receipts.request_id%TYPE;
86: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
87: l_batch_date ar_cash_receipts.receipt_date%TYPE ;
88: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;
89: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;
90: l_currency_code ar_cash_receipts.currency_code%TYPE;
91: l_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
92: l_format_flag ar_cash_receipts.confirmed_flag%TYPE ;
93: l_create_flag ar_cash_receipts.confirmed_flag%TYPE ;

Line 90: l_currency_code ar_cash_receipts.currency_code%TYPE;

86: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
87: l_batch_date ar_cash_receipts.receipt_date%TYPE ;
88: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;
89: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;
90: l_currency_code ar_cash_receipts.currency_code%TYPE;
91: l_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
92: l_format_flag ar_cash_receipts.confirmed_flag%TYPE ;
93: l_create_flag ar_cash_receipts.confirmed_flag%TYPE ;
94: o_batch_id NUMBER;

Line 91: l_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;

87: l_batch_date ar_cash_receipts.receipt_date%TYPE ;
88: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;
89: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;
90: l_currency_code ar_cash_receipts.currency_code%TYPE;
91: l_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
92: l_format_flag ar_cash_receipts.confirmed_flag%TYPE ;
93: l_create_flag ar_cash_receipts.confirmed_flag%TYPE ;
94: o_batch_id NUMBER;
95:

Line 92: l_format_flag ar_cash_receipts.confirmed_flag%TYPE ;

88: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;
89: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;
90: l_currency_code ar_cash_receipts.currency_code%TYPE;
91: l_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
92: l_format_flag ar_cash_receipts.confirmed_flag%TYPE ;
93: l_create_flag ar_cash_receipts.confirmed_flag%TYPE ;
94: o_batch_id NUMBER;
95:
96:

Line 93: l_create_flag ar_cash_receipts.confirmed_flag%TYPE ;

89: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;
90: l_currency_code ar_cash_receipts.currency_code%TYPE;
91: l_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
92: l_format_flag ar_cash_receipts.confirmed_flag%TYPE ;
93: l_create_flag ar_cash_receipts.confirmed_flag%TYPE ;
94: o_batch_id NUMBER;
95:
96:
97: /* selinv variables */

Line 648: from ar_cash_receipts cr,

644:
645: CURSOR c3 is
646: select distinct cr.cash_receipt_id cr_id,
647: cr.payment_trxn_extension_id pmt_trxn_id
648: from ar_cash_receipts cr,
649: ar_receipts_gt rec
650: where rec.cash_receipt_id = cr.cash_receipt_id;
651:
652:

Line 730: ar_cash_receipts rec

726: program_id = l_program_id,
727: program_update_date = sysdate
728: WHERE customer_trx_id in (SELECT r.customer_trx_id
729: FROM ar_receipts_gt r,
730: ar_cash_receipts rec
731: WHERE r.receipt_number = rec.receipt_number
732: AND rec.cash_receipt_id = CREC.cr_id);
733:
734: arp_standard.debug ( ' rows updated TRX = ' || SQL%ROWCOUNT );

Line 771: ar_cash_receipts rec

767: program_id = l_program_id,
768: program_update_date = sysdate
769: WHERE customer_trx_id in (SELECT r.customer_trx_id
770: FROM ar_receipts_gt r,
771: ar_cash_receipts rec
772: WHERE r.receipt_number = rec.receipt_number
773: AND rec.cash_receipt_id = CREC.cr_id);
774:
775:

Line 820: update ar_cash_receipts SET

816: batch_applied_status = 'COMPLETED_APPROVAL'
817: where batch_id = o_batch_id;
818:
819:
820: update ar_cash_receipts SET
821: creation_date = sysdate,
822: created_by = l_created_by,
823: last_update_date = sysdate,
824: last_updated_by = l_created_by,

Line 904: update ar_cash_receipts cr SET

900: where payment_schedule_id in (select PAYMENT_SCHEDULE_ID from AR_RECEIPTS_GT);
901:
902: IF l_rec_creation_rule_code = 'PER_INVOICE' AND
903: l_rec_inher_inv_num_flag = 'Y' THEN
904: update ar_cash_receipts cr SET
905: receipt_number = nvl((
906: select ps.trx_number
907: from
908: ar_receivable_applications app,

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

992:
993:
994: PROCEDURE insert_batch(
995: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
996: p_batch_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
997: p_receipt_class_id IN ar_receipt_classes.receipt_class_id%TYPE DEFAULT NULL,
998: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
999: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
1000: p_approve_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,

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

994: PROCEDURE insert_batch(
995: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
996: p_batch_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
997: p_receipt_class_id IN ar_receipt_classes.receipt_class_id%TYPE DEFAULT NULL,
998: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
999: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
1000: p_approve_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
1001: p_format_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
1002: p_create_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,

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

995: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
996: p_batch_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
997: p_receipt_class_id IN ar_receipt_classes.receipt_class_id%TYPE DEFAULT NULL,
998: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
999: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
1000: p_approve_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
1001: p_format_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
1002: p_create_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
1003: p_batch_id OUT NOCOPY NUMBER

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

996: p_batch_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
997: p_receipt_class_id IN ar_receipt_classes.receipt_class_id%TYPE DEFAULT NULL,
998: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
999: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
1000: p_approve_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
1001: p_format_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
1002: p_create_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
1003: p_batch_id OUT NOCOPY NUMBER
1004: ) IS

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

997: p_receipt_class_id IN ar_receipt_classes.receipt_class_id%TYPE DEFAULT NULL,
998: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
999: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
1000: p_approve_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
1001: p_format_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
1002: p_create_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
1003: p_batch_id OUT NOCOPY NUMBER
1004: ) IS
1005: l_batch_rec ar_batches%ROWTYPE;

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

998: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
999: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
1000: p_approve_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
1001: p_format_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
1002: p_create_flag IN ar_cash_receipts.confirmed_flag%TYPE DEFAULT NULL,
1003: p_batch_id OUT NOCOPY NUMBER
1004: ) IS
1005: l_batch_rec ar_batches%ROWTYPE;
1006: l_row_id VARCHAR2(50);

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

1200: p_approve_only_flag IN VARCHAR2 ,--Bug5344405
1201: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
1202: p_payment_schedule_id OUT NOCOPY ar_payment_schedules.payment_schedule_id%TYPE,
1203: p_customer_trx_id OUT NOCOPY ar_payment_schedules.customer_trx_id%TYPE,
1204: p_cash_receipt_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
1205: p_paying_customer_id OUT NOCOPY ar_payment_schedules.customer_id%TYPE,
1206: p_paying_site_use_id OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
1207: p_payment_server_order_num OUT NOCOPY ra_customer_trx.payment_server_order_num%TYPE,
1208: p_due_date OUT NOCOPY ar_payment_schedules.due_date%TYPE,

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

1758: | 16-JUL-2005 bichatte Created |
1759: *=========================================================================*/
1760:
1761: PROCEDURE group_val_create_receipts(
1762: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
1763: p_batch_id IN ar_batches.batch_id%TYPE
1764: ) IS
1765:
1766: p_creation_rule VARCHAR2(40);

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

4133: | 16-JUL-2005 bichatte Created |
4134: *=========================================================================*/
4135: PROCEDURE insert_exceptions(
4136: p_batch_id IN ar_batches.batch_id%TYPE DEFAULT NULL,
4137: p_request_id IN ar_cash_receipts.request_id%TYPE DEFAULT NULL,
4138: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
4139: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
4140: p_paying_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
4141: p_paying_site_use_id IN ar_cash_receipts.customer_site_use_id%TYPE DEFAULT NULL,

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

4134: *=========================================================================*/
4135: PROCEDURE insert_exceptions(
4136: p_batch_id IN ar_batches.batch_id%TYPE DEFAULT NULL,
4137: p_request_id IN ar_cash_receipts.request_id%TYPE DEFAULT NULL,
4138: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
4139: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
4140: p_paying_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
4141: p_paying_site_use_id IN ar_cash_receipts.customer_site_use_id%TYPE DEFAULT NULL,
4142: p_due_date IN ar_payment_schedules.due_date%TYPE DEFAULT NULL,

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

4136: p_batch_id IN ar_batches.batch_id%TYPE DEFAULT NULL,
4137: p_request_id IN ar_cash_receipts.request_id%TYPE DEFAULT NULL,
4138: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
4139: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
4140: p_paying_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
4141: p_paying_site_use_id IN ar_cash_receipts.customer_site_use_id%TYPE DEFAULT NULL,
4142: p_due_date IN ar_payment_schedules.due_date%TYPE DEFAULT NULL,
4143: p_cust_min_rec_amount IN NUMBER DEFAULT NULL,
4144: p_bank_min_rec_amount IN NUMBER DEFAULT NULL,

Line 4141: p_paying_site_use_id IN ar_cash_receipts.customer_site_use_id%TYPE DEFAULT NULL,

4137: p_request_id IN ar_cash_receipts.request_id%TYPE DEFAULT NULL,
4138: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
4139: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
4140: p_paying_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
4141: p_paying_site_use_id IN ar_cash_receipts.customer_site_use_id%TYPE DEFAULT NULL,
4142: p_due_date IN ar_payment_schedules.due_date%TYPE DEFAULT NULL,
4143: p_cust_min_rec_amount IN NUMBER DEFAULT NULL,
4144: p_bank_min_rec_amount IN NUMBER DEFAULT NULL,
4145: p_exception_code IN VARCHAR2,

Line 4194: from ar_cash_receipts

4190: IF l_paying_customer_id is null and p_cash_receipt_id is not null THEN
4191:
4192: select pay_from_customer
4193: into l_paying_customer_id
4194: from ar_cash_receipts
4195: where cash_receipt_id = p_cash_receipt_id;
4196:
4197: END IF;
4198:

Line 4292: p_request_id ar_cash_receipts.request_id%TYPE

4288: *=========================================================================*/
4289:
4290: PROCEDURE SUBMIT_REPORT (
4291: p_batch_id ar_batches.batch_id%TYPE,
4292: p_request_id ar_cash_receipts.request_id%TYPE
4293: ) IS
4294:
4295: l_reqid NUMBER(15);
4296: l_org_id NUMBER;

Line 4386: FROM ar_cash_receipts cr,

4382: program_id = l_program_id,
4383: program_update_date = sysdate
4384: WHERE customer_trx_id in (
4385: SELECT r.customer_trx_id
4386: FROM ar_cash_receipts cr,
4387: ar_receipts_gt r,
4388: ar_cash_receipt_history crh,
4389: iby_trxn_extensions_v trxn_ext
4390: WHERE cr.request_id = l_request_id

Line 4437: FROM ar_cash_receipts cr,

4433: l_last_update_login,
4434: l_program_application_id,
4435: l_program_id,
4436: sysdate
4437: FROM ar_cash_receipts cr,
4438: ar_cash_receipt_history crh,
4439: iby_trxn_extensions_v trxn_ext
4440: WHERE cr.request_id = l_request_id
4441: AND crh.cash_receipt_id = cr.cash_receipt_id

Line 4474: l_request_id ar_cash_receipts.request_id%TYPE;

4470: PROCEDURE rec_reset( p_apply_fail IN VARCHAR2,
4471: p_pay_process_fail IN VARCHAR2
4472: )IS
4473:
4474: l_request_id ar_cash_receipts.request_id%TYPE;
4475:
4476: BEGIN
4477: IF PG_DEBUG in ('Y', 'C') THEN
4478: arp_standard.debug('inside rec reset.');

Line 4495: FROM ar_cash_receipts cr,

4491: cc_error_code = null,
4492: cc_error_text = null
4493: WHERE customer_trx_id in (
4494: SELECT r.customer_trx_id
4495: FROM ar_cash_receipts cr,
4496: ar_receipts_gt r,
4497: ar_cash_receipt_history crh,
4498: iby_trxn_extensions_v trxn_ext
4499: WHERE cr.request_id = l_request_id

Line 4520: FROM ar_cash_receipts cr,

4516: delete from ar_autorec_exceptions
4517: where cash_receipt_id in (
4518: SELECT
4519: cr.cash_receipt_id
4520: FROM ar_cash_receipts cr,
4521: ar_cash_receipt_history crh,
4522: iby_trxn_extensions_v trxn_ext
4523: WHERE cr.request_id = l_request_id
4524: AND crh.cash_receipt_id = cr.cash_receipt_id

Line 4813: delete from ar_cash_receipts

4809: IF PG_DEBUG in ('Y','C') THEN
4810: arp_standard.debug ( ' rows DELETED CRH = ' || SQL%ROWCOUNT );
4811: END IF;
4812:
4813: delete from ar_cash_receipts
4814: where cash_receipt_id in ( select distinct cash_receipt_id
4815: from ar_autorec_exceptions
4816: where request_id = l_request_id);
4817: