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_RECEIPT_API_PUB dependencies on DBMS_SQL

Line 10629: cash_receipt_history_id DBMS_SQL.NUMBER_TABLE,

10625: MAX_LIMIT NUMBER := 1000;
10626:
10627: TYPE CRH_UPD_TYPE IS RECORD
10628: (
10629: cash_receipt_history_id DBMS_SQL.NUMBER_TABLE,
10630: cash_receipt_id DBMS_SQL.NUMBER_TABLE,
10631: reversal_gl_date DBMS_SQL.DATE_TABLE,
10632: gl_date DBMS_SQL.DATE_TABLE,
10633: reversal_cash_receipt_hist_id DBMS_SQL.NUMBER_TABLE,

Line 10630: cash_receipt_id DBMS_SQL.NUMBER_TABLE,

10626:
10627: TYPE CRH_UPD_TYPE IS RECORD
10628: (
10629: cash_receipt_history_id DBMS_SQL.NUMBER_TABLE,
10630: cash_receipt_id DBMS_SQL.NUMBER_TABLE,
10631: reversal_gl_date DBMS_SQL.DATE_TABLE,
10632: gl_date DBMS_SQL.DATE_TABLE,
10633: reversal_cash_receipt_hist_id DBMS_SQL.NUMBER_TABLE,
10634: batch_id DBMS_SQL.NUMBER_TABLE,

Line 10631: reversal_gl_date DBMS_SQL.DATE_TABLE,

10627: TYPE CRH_UPD_TYPE IS RECORD
10628: (
10629: cash_receipt_history_id DBMS_SQL.NUMBER_TABLE,
10630: cash_receipt_id DBMS_SQL.NUMBER_TABLE,
10631: reversal_gl_date DBMS_SQL.DATE_TABLE,
10632: gl_date DBMS_SQL.DATE_TABLE,
10633: reversal_cash_receipt_hist_id DBMS_SQL.NUMBER_TABLE,
10634: batch_id DBMS_SQL.NUMBER_TABLE,
10635: amount DBMS_SQL.NUMBER_TABLE,

Line 10632: gl_date DBMS_SQL.DATE_TABLE,

10628: (
10629: cash_receipt_history_id DBMS_SQL.NUMBER_TABLE,
10630: cash_receipt_id DBMS_SQL.NUMBER_TABLE,
10631: reversal_gl_date DBMS_SQL.DATE_TABLE,
10632: gl_date DBMS_SQL.DATE_TABLE,
10633: reversal_cash_receipt_hist_id DBMS_SQL.NUMBER_TABLE,
10634: batch_id DBMS_SQL.NUMBER_TABLE,
10635: amount DBMS_SQL.NUMBER_TABLE,
10636: cc_error_code DBMS_SQL.VARCHAR2_TABLE,

Line 10633: reversal_cash_receipt_hist_id DBMS_SQL.NUMBER_TABLE,

10629: cash_receipt_history_id DBMS_SQL.NUMBER_TABLE,
10630: cash_receipt_id DBMS_SQL.NUMBER_TABLE,
10631: reversal_gl_date DBMS_SQL.DATE_TABLE,
10632: gl_date DBMS_SQL.DATE_TABLE,
10633: reversal_cash_receipt_hist_id DBMS_SQL.NUMBER_TABLE,
10634: batch_id DBMS_SQL.NUMBER_TABLE,
10635: amount DBMS_SQL.NUMBER_TABLE,
10636: cc_error_code DBMS_SQL.VARCHAR2_TABLE,
10637: cc_error_text DBMS_SQL.VARCHAR2_TABLE,

Line 10634: batch_id DBMS_SQL.NUMBER_TABLE,

10630: cash_receipt_id DBMS_SQL.NUMBER_TABLE,
10631: reversal_gl_date DBMS_SQL.DATE_TABLE,
10632: gl_date DBMS_SQL.DATE_TABLE,
10633: reversal_cash_receipt_hist_id DBMS_SQL.NUMBER_TABLE,
10634: batch_id DBMS_SQL.NUMBER_TABLE,
10635: amount DBMS_SQL.NUMBER_TABLE,
10636: cc_error_code DBMS_SQL.VARCHAR2_TABLE,
10637: cc_error_text DBMS_SQL.VARCHAR2_TABLE,
10638: cc_instrtype DBMS_SQL.VARCHAR2_TABLE,

Line 10635: amount DBMS_SQL.NUMBER_TABLE,

10631: reversal_gl_date DBMS_SQL.DATE_TABLE,
10632: gl_date DBMS_SQL.DATE_TABLE,
10633: reversal_cash_receipt_hist_id DBMS_SQL.NUMBER_TABLE,
10634: batch_id DBMS_SQL.NUMBER_TABLE,
10635: amount DBMS_SQL.NUMBER_TABLE,
10636: cc_error_code DBMS_SQL.VARCHAR2_TABLE,
10637: cc_error_text DBMS_SQL.VARCHAR2_TABLE,
10638: cc_instrtype DBMS_SQL.VARCHAR2_TABLE,
10639: rec_status DBMS_SQL.VARCHAR2_TABLE

Line 10636: cc_error_code DBMS_SQL.VARCHAR2_TABLE,

10632: gl_date DBMS_SQL.DATE_TABLE,
10633: reversal_cash_receipt_hist_id DBMS_SQL.NUMBER_TABLE,
10634: batch_id DBMS_SQL.NUMBER_TABLE,
10635: amount DBMS_SQL.NUMBER_TABLE,
10636: cc_error_code DBMS_SQL.VARCHAR2_TABLE,
10637: cc_error_text DBMS_SQL.VARCHAR2_TABLE,
10638: cc_instrtype DBMS_SQL.VARCHAR2_TABLE,
10639: rec_status DBMS_SQL.VARCHAR2_TABLE
10640: );

Line 10637: cc_error_text DBMS_SQL.VARCHAR2_TABLE,

10633: reversal_cash_receipt_hist_id DBMS_SQL.NUMBER_TABLE,
10634: batch_id DBMS_SQL.NUMBER_TABLE,
10635: amount DBMS_SQL.NUMBER_TABLE,
10636: cc_error_code DBMS_SQL.VARCHAR2_TABLE,
10637: cc_error_text DBMS_SQL.VARCHAR2_TABLE,
10638: cc_instrtype DBMS_SQL.VARCHAR2_TABLE,
10639: rec_status DBMS_SQL.VARCHAR2_TABLE
10640: );
10641:

Line 10638: cc_instrtype DBMS_SQL.VARCHAR2_TABLE,

10634: batch_id DBMS_SQL.NUMBER_TABLE,
10635: amount DBMS_SQL.NUMBER_TABLE,
10636: cc_error_code DBMS_SQL.VARCHAR2_TABLE,
10637: cc_error_text DBMS_SQL.VARCHAR2_TABLE,
10638: cc_instrtype DBMS_SQL.VARCHAR2_TABLE,
10639: rec_status DBMS_SQL.VARCHAR2_TABLE
10640: );
10641:
10642: l_api_name CONSTANT VARCHAR2(30) := 'Reverse_Remittances_in_err';

Line 10639: rec_status DBMS_SQL.VARCHAR2_TABLE

10635: amount DBMS_SQL.NUMBER_TABLE,
10636: cc_error_code DBMS_SQL.VARCHAR2_TABLE,
10637: cc_error_text DBMS_SQL.VARCHAR2_TABLE,
10638: cc_instrtype DBMS_SQL.VARCHAR2_TABLE,
10639: rec_status DBMS_SQL.VARCHAR2_TABLE
10640: );
10641:
10642: l_api_name CONSTANT VARCHAR2(30) := 'Reverse_Remittances_in_err';
10643: l_api_version CONSTANT NUMBER := 1.0;

Line 11509: ( cash_receipt_id DBMS_SQL.NUMBER_TABLE ,

11505: l_err_rcpt_index INTEGER;
11506: l_cash_receipt_index INTEGER;
11507:
11508: TYPE cash_receipt_info_rec IS RECORD
11509: ( cash_receipt_id DBMS_SQL.NUMBER_TABLE ,
11510: receipt_number DBMS_SQL.VARCHAR2_TABLE,
11511: receipt_date DBMS_SQL.DATE_TABLE,
11512: gt_id DBMS_SQL.NUMBER_TABLE,
11513: request_id DBMS_SQL.NUMBER_TABLE,

Line 11510: receipt_number DBMS_SQL.VARCHAR2_TABLE,

11506: l_cash_receipt_index INTEGER;
11507:
11508: TYPE cash_receipt_info_rec IS RECORD
11509: ( cash_receipt_id DBMS_SQL.NUMBER_TABLE ,
11510: receipt_number DBMS_SQL.VARCHAR2_TABLE,
11511: receipt_date DBMS_SQL.DATE_TABLE,
11512: gt_id DBMS_SQL.NUMBER_TABLE,
11513: request_id DBMS_SQL.NUMBER_TABLE,
11514: return_error_status DBMS_SQL.VARCHAR2_TABLE,

Line 11511: receipt_date DBMS_SQL.DATE_TABLE,

11507:
11508: TYPE cash_receipt_info_rec IS RECORD
11509: ( cash_receipt_id DBMS_SQL.NUMBER_TABLE ,
11510: receipt_number DBMS_SQL.VARCHAR2_TABLE,
11511: receipt_date DBMS_SQL.DATE_TABLE,
11512: gt_id DBMS_SQL.NUMBER_TABLE,
11513: request_id DBMS_SQL.NUMBER_TABLE,
11514: return_error_status DBMS_SQL.VARCHAR2_TABLE,
11515: org_id DBMS_SQL.NUMBER_TABLE);

Line 11512: gt_id DBMS_SQL.NUMBER_TABLE,

11508: TYPE cash_receipt_info_rec IS RECORD
11509: ( cash_receipt_id DBMS_SQL.NUMBER_TABLE ,
11510: receipt_number DBMS_SQL.VARCHAR2_TABLE,
11511: receipt_date DBMS_SQL.DATE_TABLE,
11512: gt_id DBMS_SQL.NUMBER_TABLE,
11513: request_id DBMS_SQL.NUMBER_TABLE,
11514: return_error_status DBMS_SQL.VARCHAR2_TABLE,
11515: org_id DBMS_SQL.NUMBER_TABLE);
11516:

Line 11513: request_id DBMS_SQL.NUMBER_TABLE,

11509: ( cash_receipt_id DBMS_SQL.NUMBER_TABLE ,
11510: receipt_number DBMS_SQL.VARCHAR2_TABLE,
11511: receipt_date DBMS_SQL.DATE_TABLE,
11512: gt_id DBMS_SQL.NUMBER_TABLE,
11513: request_id DBMS_SQL.NUMBER_TABLE,
11514: return_error_status DBMS_SQL.VARCHAR2_TABLE,
11515: org_id DBMS_SQL.NUMBER_TABLE);
11516:
11517:

Line 11514: return_error_status DBMS_SQL.VARCHAR2_TABLE,

11510: receipt_number DBMS_SQL.VARCHAR2_TABLE,
11511: receipt_date DBMS_SQL.DATE_TABLE,
11512: gt_id DBMS_SQL.NUMBER_TABLE,
11513: request_id DBMS_SQL.NUMBER_TABLE,
11514: return_error_status DBMS_SQL.VARCHAR2_TABLE,
11515: org_id DBMS_SQL.NUMBER_TABLE);
11516:
11517:
11518: l_cash_receipt_info_rec cash_receipt_info_rec;

Line 11515: org_id DBMS_SQL.NUMBER_TABLE);

11511: receipt_date DBMS_SQL.DATE_TABLE,
11512: gt_id DBMS_SQL.NUMBER_TABLE,
11513: request_id DBMS_SQL.NUMBER_TABLE,
11514: return_error_status DBMS_SQL.VARCHAR2_TABLE,
11515: org_id DBMS_SQL.NUMBER_TABLE);
11516:
11517:
11518: l_cash_receipt_info_rec cash_receipt_info_rec;
11519:

Line 11522: ( BATCH_ID DBMS_SQL.NUMBER_TABLE,

11518: l_cash_receipt_info_rec cash_receipt_info_rec;
11519:
11520:
11521: TYPE rcpt_error_info_rec IS RECORD
11522: ( BATCH_ID DBMS_SQL.NUMBER_TABLE,
11523: REQUEST_ID DBMS_SQL.NUMBER_TABLE,
11524: CASH_RECEIPT_ID DBMS_SQL.NUMBER_TABLE,
11525: RECEIPT_NUMBER DBMS_SQL.VARCHAR2_TABLE,
11526: RECEIPT_DATE DBMS_SQL.DATE_TABLE,

Line 11523: REQUEST_ID DBMS_SQL.NUMBER_TABLE,

11519:
11520:
11521: TYPE rcpt_error_info_rec IS RECORD
11522: ( BATCH_ID DBMS_SQL.NUMBER_TABLE,
11523: REQUEST_ID DBMS_SQL.NUMBER_TABLE,
11524: CASH_RECEIPT_ID DBMS_SQL.NUMBER_TABLE,
11525: RECEIPT_NUMBER DBMS_SQL.VARCHAR2_TABLE,
11526: RECEIPT_DATE DBMS_SQL.DATE_TABLE,
11527: CUSTOMER_TRX_ID DBMS_SQL.NUMBER_TABLE,

Line 11524: CASH_RECEIPT_ID DBMS_SQL.NUMBER_TABLE,

11520:
11521: TYPE rcpt_error_info_rec IS RECORD
11522: ( BATCH_ID DBMS_SQL.NUMBER_TABLE,
11523: REQUEST_ID DBMS_SQL.NUMBER_TABLE,
11524: CASH_RECEIPT_ID DBMS_SQL.NUMBER_TABLE,
11525: RECEIPT_NUMBER DBMS_SQL.VARCHAR2_TABLE,
11526: RECEIPT_DATE DBMS_SQL.DATE_TABLE,
11527: CUSTOMER_TRX_ID DBMS_SQL.NUMBER_TABLE,
11528: TRXN_NUMBER DBMS_SQL.VARCHAR2_TABLE,

Line 11525: RECEIPT_NUMBER DBMS_SQL.VARCHAR2_TABLE,

11521: TYPE rcpt_error_info_rec IS RECORD
11522: ( BATCH_ID DBMS_SQL.NUMBER_TABLE,
11523: REQUEST_ID DBMS_SQL.NUMBER_TABLE,
11524: CASH_RECEIPT_ID DBMS_SQL.NUMBER_TABLE,
11525: RECEIPT_NUMBER DBMS_SQL.VARCHAR2_TABLE,
11526: RECEIPT_DATE DBMS_SQL.DATE_TABLE,
11527: CUSTOMER_TRX_ID DBMS_SQL.NUMBER_TABLE,
11528: TRXN_NUMBER DBMS_SQL.VARCHAR2_TABLE,
11529: PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE,

Line 11526: RECEIPT_DATE DBMS_SQL.DATE_TABLE,

11522: ( BATCH_ID DBMS_SQL.NUMBER_TABLE,
11523: REQUEST_ID DBMS_SQL.NUMBER_TABLE,
11524: CASH_RECEIPT_ID DBMS_SQL.NUMBER_TABLE,
11525: RECEIPT_NUMBER DBMS_SQL.VARCHAR2_TABLE,
11526: RECEIPT_DATE DBMS_SQL.DATE_TABLE,
11527: CUSTOMER_TRX_ID DBMS_SQL.NUMBER_TABLE,
11528: TRXN_NUMBER DBMS_SQL.VARCHAR2_TABLE,
11529: PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE,
11530: APPLIED_PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE,

Line 11527: CUSTOMER_TRX_ID DBMS_SQL.NUMBER_TABLE,

11523: REQUEST_ID DBMS_SQL.NUMBER_TABLE,
11524: CASH_RECEIPT_ID DBMS_SQL.NUMBER_TABLE,
11525: RECEIPT_NUMBER DBMS_SQL.VARCHAR2_TABLE,
11526: RECEIPT_DATE DBMS_SQL.DATE_TABLE,
11527: CUSTOMER_TRX_ID DBMS_SQL.NUMBER_TABLE,
11528: TRXN_NUMBER DBMS_SQL.VARCHAR2_TABLE,
11529: PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE,
11530: APPLIED_PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE,
11531: PAYING_CUSTOMER_ID DBMS_SQL.NUMBER_TABLE,

Line 11528: TRXN_NUMBER DBMS_SQL.VARCHAR2_TABLE,

11524: CASH_RECEIPT_ID DBMS_SQL.NUMBER_TABLE,
11525: RECEIPT_NUMBER DBMS_SQL.VARCHAR2_TABLE,
11526: RECEIPT_DATE DBMS_SQL.DATE_TABLE,
11527: CUSTOMER_TRX_ID DBMS_SQL.NUMBER_TABLE,
11528: TRXN_NUMBER DBMS_SQL.VARCHAR2_TABLE,
11529: PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE,
11530: APPLIED_PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE,
11531: PAYING_CUSTOMER_ID DBMS_SQL.NUMBER_TABLE,
11532: PAYING_SITE_USE_ID DBMS_SQL.NUMBER_TABLE,

Line 11529: PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE,

11525: RECEIPT_NUMBER DBMS_SQL.VARCHAR2_TABLE,
11526: RECEIPT_DATE DBMS_SQL.DATE_TABLE,
11527: CUSTOMER_TRX_ID DBMS_SQL.NUMBER_TABLE,
11528: TRXN_NUMBER DBMS_SQL.VARCHAR2_TABLE,
11529: PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE,
11530: APPLIED_PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE,
11531: PAYING_CUSTOMER_ID DBMS_SQL.NUMBER_TABLE,
11532: PAYING_SITE_USE_ID DBMS_SQL.NUMBER_TABLE,
11533: EXCEPTION_CODE DBMS_SQL.VARCHAR2_TABLE,

Line 11530: APPLIED_PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE,

11526: RECEIPT_DATE DBMS_SQL.DATE_TABLE,
11527: CUSTOMER_TRX_ID DBMS_SQL.NUMBER_TABLE,
11528: TRXN_NUMBER DBMS_SQL.VARCHAR2_TABLE,
11529: PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE,
11530: APPLIED_PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE,
11531: PAYING_CUSTOMER_ID DBMS_SQL.NUMBER_TABLE,
11532: PAYING_SITE_USE_ID DBMS_SQL.NUMBER_TABLE,
11533: EXCEPTION_CODE DBMS_SQL.VARCHAR2_TABLE,
11534: ADDITIONAL_MESSAGE DBMS_SQL.VARCHAR2_TABLE,

Line 11531: PAYING_CUSTOMER_ID DBMS_SQL.NUMBER_TABLE,

11527: CUSTOMER_TRX_ID DBMS_SQL.NUMBER_TABLE,
11528: TRXN_NUMBER DBMS_SQL.VARCHAR2_TABLE,
11529: PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE,
11530: APPLIED_PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE,
11531: PAYING_CUSTOMER_ID DBMS_SQL.NUMBER_TABLE,
11532: PAYING_SITE_USE_ID DBMS_SQL.NUMBER_TABLE,
11533: EXCEPTION_CODE DBMS_SQL.VARCHAR2_TABLE,
11534: ADDITIONAL_MESSAGE DBMS_SQL.VARCHAR2_TABLE,
11535: REMIT_BANK_ACCT_USE_ID DBMS_SQL.NUMBER_TABLE,

Line 11532: PAYING_SITE_USE_ID DBMS_SQL.NUMBER_TABLE,

11528: TRXN_NUMBER DBMS_SQL.VARCHAR2_TABLE,
11529: PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE,
11530: APPLIED_PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE,
11531: PAYING_CUSTOMER_ID DBMS_SQL.NUMBER_TABLE,
11532: PAYING_SITE_USE_ID DBMS_SQL.NUMBER_TABLE,
11533: EXCEPTION_CODE DBMS_SQL.VARCHAR2_TABLE,
11534: ADDITIONAL_MESSAGE DBMS_SQL.VARCHAR2_TABLE,
11535: REMIT_BANK_ACCT_USE_ID DBMS_SQL.NUMBER_TABLE,
11536: LAST_UPDATE_DATE DBMS_SQL.DATE_TABLE,

Line 11533: EXCEPTION_CODE DBMS_SQL.VARCHAR2_TABLE,

11529: PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE,
11530: APPLIED_PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE,
11531: PAYING_CUSTOMER_ID DBMS_SQL.NUMBER_TABLE,
11532: PAYING_SITE_USE_ID DBMS_SQL.NUMBER_TABLE,
11533: EXCEPTION_CODE DBMS_SQL.VARCHAR2_TABLE,
11534: ADDITIONAL_MESSAGE DBMS_SQL.VARCHAR2_TABLE,
11535: REMIT_BANK_ACCT_USE_ID DBMS_SQL.NUMBER_TABLE,
11536: LAST_UPDATE_DATE DBMS_SQL.DATE_TABLE,
11537: CREATION_DATE DBMS_SQL.DATE_TABLE,

Line 11534: ADDITIONAL_MESSAGE DBMS_SQL.VARCHAR2_TABLE,

11530: APPLIED_PAYMENT_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE,
11531: PAYING_CUSTOMER_ID DBMS_SQL.NUMBER_TABLE,
11532: PAYING_SITE_USE_ID DBMS_SQL.NUMBER_TABLE,
11533: EXCEPTION_CODE DBMS_SQL.VARCHAR2_TABLE,
11534: ADDITIONAL_MESSAGE DBMS_SQL.VARCHAR2_TABLE,
11535: REMIT_BANK_ACCT_USE_ID DBMS_SQL.NUMBER_TABLE,
11536: LAST_UPDATE_DATE DBMS_SQL.DATE_TABLE,
11537: CREATION_DATE DBMS_SQL.DATE_TABLE,
11538: CREATED_BY DBMS_SQL.NUMBER_TABLE,

Line 11535: REMIT_BANK_ACCT_USE_ID DBMS_SQL.NUMBER_TABLE,

11531: PAYING_CUSTOMER_ID DBMS_SQL.NUMBER_TABLE,
11532: PAYING_SITE_USE_ID DBMS_SQL.NUMBER_TABLE,
11533: EXCEPTION_CODE DBMS_SQL.VARCHAR2_TABLE,
11534: ADDITIONAL_MESSAGE DBMS_SQL.VARCHAR2_TABLE,
11535: REMIT_BANK_ACCT_USE_ID DBMS_SQL.NUMBER_TABLE,
11536: LAST_UPDATE_DATE DBMS_SQL.DATE_TABLE,
11537: CREATION_DATE DBMS_SQL.DATE_TABLE,
11538: CREATED_BY DBMS_SQL.NUMBER_TABLE,
11539: LAST_UPDATE_LOGIN DBMS_SQL.NUMBER_TABLE,

Line 11536: LAST_UPDATE_DATE DBMS_SQL.DATE_TABLE,

11532: PAYING_SITE_USE_ID DBMS_SQL.NUMBER_TABLE,
11533: EXCEPTION_CODE DBMS_SQL.VARCHAR2_TABLE,
11534: ADDITIONAL_MESSAGE DBMS_SQL.VARCHAR2_TABLE,
11535: REMIT_BANK_ACCT_USE_ID DBMS_SQL.NUMBER_TABLE,
11536: LAST_UPDATE_DATE DBMS_SQL.DATE_TABLE,
11537: CREATION_DATE DBMS_SQL.DATE_TABLE,
11538: CREATED_BY DBMS_SQL.NUMBER_TABLE,
11539: LAST_UPDATE_LOGIN DBMS_SQL.NUMBER_TABLE,
11540: PROGRAM_APPLICATION_ID DBMS_SQL.NUMBER_TABLE,

Line 11537: CREATION_DATE DBMS_SQL.DATE_TABLE,

11533: EXCEPTION_CODE DBMS_SQL.VARCHAR2_TABLE,
11534: ADDITIONAL_MESSAGE DBMS_SQL.VARCHAR2_TABLE,
11535: REMIT_BANK_ACCT_USE_ID DBMS_SQL.NUMBER_TABLE,
11536: LAST_UPDATE_DATE DBMS_SQL.DATE_TABLE,
11537: CREATION_DATE DBMS_SQL.DATE_TABLE,
11538: CREATED_BY DBMS_SQL.NUMBER_TABLE,
11539: LAST_UPDATE_LOGIN DBMS_SQL.NUMBER_TABLE,
11540: PROGRAM_APPLICATION_ID DBMS_SQL.NUMBER_TABLE,
11541: PROGRAM_ID DBMS_SQL.NUMBER_TABLE,

Line 11538: CREATED_BY DBMS_SQL.NUMBER_TABLE,

11534: ADDITIONAL_MESSAGE DBMS_SQL.VARCHAR2_TABLE,
11535: REMIT_BANK_ACCT_USE_ID DBMS_SQL.NUMBER_TABLE,
11536: LAST_UPDATE_DATE DBMS_SQL.DATE_TABLE,
11537: CREATION_DATE DBMS_SQL.DATE_TABLE,
11538: CREATED_BY DBMS_SQL.NUMBER_TABLE,
11539: LAST_UPDATE_LOGIN DBMS_SQL.NUMBER_TABLE,
11540: PROGRAM_APPLICATION_ID DBMS_SQL.NUMBER_TABLE,
11541: PROGRAM_ID DBMS_SQL.NUMBER_TABLE,
11542: PROGRAM_UPDATE_DATE DBMS_SQL.DATE_TABLE,

Line 11539: LAST_UPDATE_LOGIN DBMS_SQL.NUMBER_TABLE,

11535: REMIT_BANK_ACCT_USE_ID DBMS_SQL.NUMBER_TABLE,
11536: LAST_UPDATE_DATE DBMS_SQL.DATE_TABLE,
11537: CREATION_DATE DBMS_SQL.DATE_TABLE,
11538: CREATED_BY DBMS_SQL.NUMBER_TABLE,
11539: LAST_UPDATE_LOGIN DBMS_SQL.NUMBER_TABLE,
11540: PROGRAM_APPLICATION_ID DBMS_SQL.NUMBER_TABLE,
11541: PROGRAM_ID DBMS_SQL.NUMBER_TABLE,
11542: PROGRAM_UPDATE_DATE DBMS_SQL.DATE_TABLE,
11543: LAST_UPDATED_BY DBMS_SQL.NUMBER_TABLE );

Line 11540: PROGRAM_APPLICATION_ID DBMS_SQL.NUMBER_TABLE,

11536: LAST_UPDATE_DATE DBMS_SQL.DATE_TABLE,
11537: CREATION_DATE DBMS_SQL.DATE_TABLE,
11538: CREATED_BY DBMS_SQL.NUMBER_TABLE,
11539: LAST_UPDATE_LOGIN DBMS_SQL.NUMBER_TABLE,
11540: PROGRAM_APPLICATION_ID DBMS_SQL.NUMBER_TABLE,
11541: PROGRAM_ID DBMS_SQL.NUMBER_TABLE,
11542: PROGRAM_UPDATE_DATE DBMS_SQL.DATE_TABLE,
11543: LAST_UPDATED_BY DBMS_SQL.NUMBER_TABLE );
11544:

Line 11541: PROGRAM_ID DBMS_SQL.NUMBER_TABLE,

11537: CREATION_DATE DBMS_SQL.DATE_TABLE,
11538: CREATED_BY DBMS_SQL.NUMBER_TABLE,
11539: LAST_UPDATE_LOGIN DBMS_SQL.NUMBER_TABLE,
11540: PROGRAM_APPLICATION_ID DBMS_SQL.NUMBER_TABLE,
11541: PROGRAM_ID DBMS_SQL.NUMBER_TABLE,
11542: PROGRAM_UPDATE_DATE DBMS_SQL.DATE_TABLE,
11543: LAST_UPDATED_BY DBMS_SQL.NUMBER_TABLE );
11544:
11545: l_rcpt_error_info_tab rcpt_error_info_rec;

Line 11542: PROGRAM_UPDATE_DATE DBMS_SQL.DATE_TABLE,

11538: CREATED_BY DBMS_SQL.NUMBER_TABLE,
11539: LAST_UPDATE_LOGIN DBMS_SQL.NUMBER_TABLE,
11540: PROGRAM_APPLICATION_ID DBMS_SQL.NUMBER_TABLE,
11541: PROGRAM_ID DBMS_SQL.NUMBER_TABLE,
11542: PROGRAM_UPDATE_DATE DBMS_SQL.DATE_TABLE,
11543: LAST_UPDATED_BY DBMS_SQL.NUMBER_TABLE );
11544:
11545: l_rcpt_error_info_tab rcpt_error_info_rec;
11546:

Line 11543: LAST_UPDATED_BY DBMS_SQL.NUMBER_TABLE );

11539: LAST_UPDATE_LOGIN DBMS_SQL.NUMBER_TABLE,
11540: PROGRAM_APPLICATION_ID DBMS_SQL.NUMBER_TABLE,
11541: PROGRAM_ID DBMS_SQL.NUMBER_TABLE,
11542: PROGRAM_UPDATE_DATE DBMS_SQL.DATE_TABLE,
11543: LAST_UPDATED_BY DBMS_SQL.NUMBER_TABLE );
11544:
11545: l_rcpt_error_info_tab rcpt_error_info_rec;
11546:
11547: TYPE rcpt_info_rec IS TABLE OF ar_create_receipts_gt%rowtype INDEX BY BINARY_INTEGER;