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.ARRX_RC_UNAPP dependencies on ARRX_RC_UNAPP

Line 1: PACKAGE BODY ARRX_RC_UNAPP AS

1: PACKAGE BODY ARRX_RC_UNAPP AS
2: /* $Header: ARRXUNAB.pls 120.4.12010000.2 2008/11/03 13:20:48 ankuagar ship $ */
3:
4:
5: /*========================================================================+

Line 60: fa_rx_util_pkg.debug('arrx_rc_unapp.ar_unapp_reg()+');

56: l_profile_rsob_id NUMBER := NULL;
57: l_client_info_rsob_id NUMBER := NULL;
58: BEGIN
59:
60: fa_rx_util_pkg.debug('arrx_rc_unapp.ar_unapp_reg()+');
61:
62: /* Assign the parameters to the global variables
63: These will be used in the before_report trigger */
64: var.request_id := request_id ;

Line 127: fa_rx_util_pkg.init_request('arrx_rc_unapp.ar_unapp_reg',request_id, 'AR_RECEIPTS_REP_ITF');

123: END IF;
124:
125: /* Initialize the request */
126: fa_rx_util_pkg.debug('Initializing the request');
127: fa_rx_util_pkg.init_request('arrx_rc_unapp.ar_unapp_reg',request_id, 'AR_RECEIPTS_REP_ITF');
128:
129: /* Assign the report triggers to this report.
130: NOTE:
131: before_report is assigned 'arrx_rc_unapp.before_report;'

Line 131: before_report is assigned 'arrx_rc_unapp.before_report;'

127: fa_rx_util_pkg.init_request('arrx_rc_unapp.ar_unapp_reg',request_id, 'AR_RECEIPTS_REP_ITF');
128:
129: /* Assign the report triggers to this report.
130: NOTE:
131: before_report is assigned 'arrx_rc_unapp.before_report;'
132: bind is assigned 'arrx_rc_unapp.bind(:CURSOR_SELECT);'
133: after_fetch is assigned 'arrx_rc_unapp.after_fetch;'
134: Each trigger event is assigned with the full procedure name (including package name).
135: They end with a ';'.

Line 132: bind is assigned 'arrx_rc_unapp.bind(:CURSOR_SELECT);'

128:
129: /* Assign the report triggers to this report.
130: NOTE:
131: before_report is assigned 'arrx_rc_unapp.before_report;'
132: bind is assigned 'arrx_rc_unapp.bind(:CURSOR_SELECT);'
133: after_fetch is assigned 'arrx_rc_unapp.after_fetch;'
134: Each trigger event is assigned with the full procedure name (including package name).
135: They end with a ';'.
136: The bind trigger requires one host variable ':CURSOR_SELECT'.

Line 133: after_fetch is assigned 'arrx_rc_unapp.after_fetch;'

129: /* Assign the report triggers to this report.
130: NOTE:
131: before_report is assigned 'arrx_rc_unapp.before_report;'
132: bind is assigned 'arrx_rc_unapp.bind(:CURSOR_SELECT);'
133: after_fetch is assigned 'arrx_rc_unapp.after_fetch;'
134: Each trigger event is assigned with the full procedure name (including package name).
135: They end with a ';'.
136: The bind trigger requires one host variable ':CURSOR_SELECT'.
137: */

Line 141: 'arrx_rc_unapp.before_report;',

137: */
138: fa_rx_util_pkg.debug('Assigning the report triggers');
139: fa_rx_util_pkg.assign_report('AR UNAPPLIED',
140: true,
141: 'arrx_rc_unapp.before_report;',
142: 'arrx_rc_unapp.bind(:CURSOR_SELECT);',
143: 'arrx_rc_unapp.after_fetch;',
144: null);
145:

Line 142: 'arrx_rc_unapp.bind(:CURSOR_SELECT);',

138: fa_rx_util_pkg.debug('Assigning the report triggers');
139: fa_rx_util_pkg.assign_report('AR UNAPPLIED',
140: true,
141: 'arrx_rc_unapp.before_report;',
142: 'arrx_rc_unapp.bind(:CURSOR_SELECT);',
143: 'arrx_rc_unapp.after_fetch;',
144: null);
145:
146: /* Run the report */

Line 143: 'arrx_rc_unapp.after_fetch;',

139: fa_rx_util_pkg.assign_report('AR UNAPPLIED',
140: true,
141: 'arrx_rc_unapp.before_report;',
142: 'arrx_rc_unapp.bind(:CURSOR_SELECT);',
143: 'arrx_rc_unapp.after_fetch;',
144: null);
145:
146: /* Run the report */
147: fa_rx_util_pkg.debug('Running the report');

Line 148: fa_rx_util_pkg.run_report('arrx_rc_unapp.ar_unapp_reg',retcode, errbuf);

144: null);
145:
146: /* Run the report */
147: fa_rx_util_pkg.debug('Running the report');
148: fa_rx_util_pkg.run_report('arrx_rc_unapp.ar_unapp_reg',retcode, errbuf);
149:
150: fa_rx_util_pkg.debug('arrx_rc_unapp.ar_unapp_reg()-');
151:
152:

Line 150: fa_rx_util_pkg.debug('arrx_rc_unapp.ar_unapp_reg()-');

146: /* Run the report */
147: fa_rx_util_pkg.debug('Running the report');
148: fa_rx_util_pkg.run_report('arrx_rc_unapp.ar_unapp_reg',retcode, errbuf);
149:
150: fa_rx_util_pkg.debug('arrx_rc_unapp.ar_unapp_reg()-');
151:
152:
153: EXCEPTION
154: WHEN OTHERS THEN

Line 159: fa_rx_util_pkg.debug('arrx_rc_unapp.ar_unapp_reg(EXCEPTION)-');

155: fa_rx_util_pkg.log(sqlcode);
156: fa_rx_util_pkg.log(sqlerrm);
157: fa_rx_util_pkg.debug(sqlcode);
158: fa_rx_util_pkg.debug(sqlerrm);
159: fa_rx_util_pkg.debug('arrx_rc_unapp.ar_unapp_reg(EXCEPTION)-');
160: END ar_unapp_reg;
161:
162: PROCEDURE before_report IS
163: CO_SEG_WHERE VARCHAR2(4000);

Line 190: fa_rx_util_pkg.debug('arrx_rc_unapp.before_report()+');

186: L_RA_ORG_WHERE VARCHAR2(4000);
187: L_PS_ORG_WHERE VARCHAR2(4000);
188: BEGIN
189:
190: fa_rx_util_pkg.debug('arrx_rc_unapp.before_report()+');
191:
192: fa_rx_util_pkg.debug('Set of Books ID : '||var.p_sob_id);
193: fa_rx_util_pkg.debug('Get Chart of Accounts ID ');
194:

Line 382: ,'arrx_rc_unapp.var.organization_name' ,'VARCHAR2', 50);

378: /* Assign the Select List */
379: fa_rx_util_pkg.debug('Assign Select List');
380:
381: fa_rx_util_pkg.assign_column('10',null ,'ORGANIZATION_NAME'
382: ,'arrx_rc_unapp.var.organization_name' ,'VARCHAR2', 50);
383: fa_rx_util_pkg.assign_column('20',null ,'FUNCTIONAL_CURRENCY_CODE'
384: ,'arrx_rc_unapp.var.functional_currency_code' ,'VARCHAR2', 15);
385: fa_rx_util_pkg.assign_column('30','BAT.BATCH_ID' ,'BATCH_ID'
386: ,'arrx_rc_unapp.var.batch_id' ,'NUMBER');

Line 384: ,'arrx_rc_unapp.var.functional_currency_code' ,'VARCHAR2', 15);

380:
381: fa_rx_util_pkg.assign_column('10',null ,'ORGANIZATION_NAME'
382: ,'arrx_rc_unapp.var.organization_name' ,'VARCHAR2', 50);
383: fa_rx_util_pkg.assign_column('20',null ,'FUNCTIONAL_CURRENCY_CODE'
384: ,'arrx_rc_unapp.var.functional_currency_code' ,'VARCHAR2', 15);
385: fa_rx_util_pkg.assign_column('30','BAT.BATCH_ID' ,'BATCH_ID'
386: ,'arrx_rc_unapp.var.batch_id' ,'NUMBER');
387: fa_rx_util_pkg.assign_column('40','BAT.NAME' ,'BATCH_NAME'
388: ,'arrx_rc_unapp.var.batch_name' ,'VARCHAR2', 20);

Line 386: ,'arrx_rc_unapp.var.batch_id' ,'NUMBER');

382: ,'arrx_rc_unapp.var.organization_name' ,'VARCHAR2', 50);
383: fa_rx_util_pkg.assign_column('20',null ,'FUNCTIONAL_CURRENCY_CODE'
384: ,'arrx_rc_unapp.var.functional_currency_code' ,'VARCHAR2', 15);
385: fa_rx_util_pkg.assign_column('30','BAT.BATCH_ID' ,'BATCH_ID'
386: ,'arrx_rc_unapp.var.batch_id' ,'NUMBER');
387: fa_rx_util_pkg.assign_column('40','BAT.NAME' ,'BATCH_NAME'
388: ,'arrx_rc_unapp.var.batch_name' ,'VARCHAR2', 20);
389: fa_rx_util_pkg.assign_column('50 ','CR.CASH_RECEIPT_ID' ,'CASH_RECEIPT_ID'
390: ,'arrx_rc_unapp.var.cash_receipt_id' ,'NUMBER');

Line 388: ,'arrx_rc_unapp.var.batch_name' ,'VARCHAR2', 20);

384: ,'arrx_rc_unapp.var.functional_currency_code' ,'VARCHAR2', 15);
385: fa_rx_util_pkg.assign_column('30','BAT.BATCH_ID' ,'BATCH_ID'
386: ,'arrx_rc_unapp.var.batch_id' ,'NUMBER');
387: fa_rx_util_pkg.assign_column('40','BAT.NAME' ,'BATCH_NAME'
388: ,'arrx_rc_unapp.var.batch_name' ,'VARCHAR2', 20);
389: fa_rx_util_pkg.assign_column('50 ','CR.CASH_RECEIPT_ID' ,'CASH_RECEIPT_ID'
390: ,'arrx_rc_unapp.var.cash_receipt_id' ,'NUMBER');
391: fa_rx_util_pkg.assign_column('60','CR.RECEIPT_NUMBER' ,'RECEIPT_NUMBER'
392: ,'arrx_rc_unapp.var.receipt_number' ,'VARCHAR2', 30);

Line 390: ,'arrx_rc_unapp.var.cash_receipt_id' ,'NUMBER');

386: ,'arrx_rc_unapp.var.batch_id' ,'NUMBER');
387: fa_rx_util_pkg.assign_column('40','BAT.NAME' ,'BATCH_NAME'
388: ,'arrx_rc_unapp.var.batch_name' ,'VARCHAR2', 20);
389: fa_rx_util_pkg.assign_column('50 ','CR.CASH_RECEIPT_ID' ,'CASH_RECEIPT_ID'
390: ,'arrx_rc_unapp.var.cash_receipt_id' ,'NUMBER');
391: fa_rx_util_pkg.assign_column('60','CR.RECEIPT_NUMBER' ,'RECEIPT_NUMBER'
392: ,'arrx_rc_unapp.var.receipt_number' ,'VARCHAR2', 30);
393: fa_rx_util_pkg.assign_column('70','CR.CURRENCY_CODE' ,'RECEIPT_CURRENCY_CODE'
394: ,'arrx_rc_unapp.var.receipt_currency_code' ,'VARCHAR2', 15);

Line 392: ,'arrx_rc_unapp.var.receipt_number' ,'VARCHAR2', 30);

388: ,'arrx_rc_unapp.var.batch_name' ,'VARCHAR2', 20);
389: fa_rx_util_pkg.assign_column('50 ','CR.CASH_RECEIPT_ID' ,'CASH_RECEIPT_ID'
390: ,'arrx_rc_unapp.var.cash_receipt_id' ,'NUMBER');
391: fa_rx_util_pkg.assign_column('60','CR.RECEIPT_NUMBER' ,'RECEIPT_NUMBER'
392: ,'arrx_rc_unapp.var.receipt_number' ,'VARCHAR2', 30);
393: fa_rx_util_pkg.assign_column('70','CR.CURRENCY_CODE' ,'RECEIPT_CURRENCY_CODE'
394: ,'arrx_rc_unapp.var.receipt_currency_code' ,'VARCHAR2', 15);
395: fa_rx_util_pkg.assign_column('80','CR.EXCHANGE_RATE' ,'EXCHANGE_RATE'
396: ,'arrx_rc_unapp.var.exchange_rate' ,'NUMBER');

Line 394: ,'arrx_rc_unapp.var.receipt_currency_code' ,'VARCHAR2', 15);

390: ,'arrx_rc_unapp.var.cash_receipt_id' ,'NUMBER');
391: fa_rx_util_pkg.assign_column('60','CR.RECEIPT_NUMBER' ,'RECEIPT_NUMBER'
392: ,'arrx_rc_unapp.var.receipt_number' ,'VARCHAR2', 30);
393: fa_rx_util_pkg.assign_column('70','CR.CURRENCY_CODE' ,'RECEIPT_CURRENCY_CODE'
394: ,'arrx_rc_unapp.var.receipt_currency_code' ,'VARCHAR2', 15);
395: fa_rx_util_pkg.assign_column('80','CR.EXCHANGE_RATE' ,'EXCHANGE_RATE'
396: ,'arrx_rc_unapp.var.exchange_rate' ,'NUMBER');
397: fa_rx_util_pkg.assign_column('90','CR.EXCHANGE_DATE' ,'EXCHANGE_DATE'
398: ,'arrx_rc_unapp.var.exchange_date' ,'DATE');

Line 396: ,'arrx_rc_unapp.var.exchange_rate' ,'NUMBER');

392: ,'arrx_rc_unapp.var.receipt_number' ,'VARCHAR2', 30);
393: fa_rx_util_pkg.assign_column('70','CR.CURRENCY_CODE' ,'RECEIPT_CURRENCY_CODE'
394: ,'arrx_rc_unapp.var.receipt_currency_code' ,'VARCHAR2', 15);
395: fa_rx_util_pkg.assign_column('80','CR.EXCHANGE_RATE' ,'EXCHANGE_RATE'
396: ,'arrx_rc_unapp.var.exchange_rate' ,'NUMBER');
397: fa_rx_util_pkg.assign_column('90','CR.EXCHANGE_DATE' ,'EXCHANGE_DATE'
398: ,'arrx_rc_unapp.var.exchange_date' ,'DATE');
399: fa_rx_util_pkg.assign_column('100','CR.EXCHANGE_RATE_TYPE' ,'EXCHANGE_TYPE'
400: ,'arrx_rc_unapp.var.exchange_type' ,'VARCHAR2',30);

Line 398: ,'arrx_rc_unapp.var.exchange_date' ,'DATE');

394: ,'arrx_rc_unapp.var.receipt_currency_code' ,'VARCHAR2', 15);
395: fa_rx_util_pkg.assign_column('80','CR.EXCHANGE_RATE' ,'EXCHANGE_RATE'
396: ,'arrx_rc_unapp.var.exchange_rate' ,'NUMBER');
397: fa_rx_util_pkg.assign_column('90','CR.EXCHANGE_DATE' ,'EXCHANGE_DATE'
398: ,'arrx_rc_unapp.var.exchange_date' ,'DATE');
399: fa_rx_util_pkg.assign_column('100','CR.EXCHANGE_RATE_TYPE' ,'EXCHANGE_TYPE'
400: ,'arrx_rc_unapp.var.exchange_type' ,'VARCHAR2',30);
401: fa_rx_util_pkg.assign_column('110','DOCSEQ.NAME' ,'DOC_SEQUENCE_NAME'
402: ,'arrx_rc_unapp.var.doc_sequence_name' ,'VARCHAR2',30);

Line 400: ,'arrx_rc_unapp.var.exchange_type' ,'VARCHAR2',30);

396: ,'arrx_rc_unapp.var.exchange_rate' ,'NUMBER');
397: fa_rx_util_pkg.assign_column('90','CR.EXCHANGE_DATE' ,'EXCHANGE_DATE'
398: ,'arrx_rc_unapp.var.exchange_date' ,'DATE');
399: fa_rx_util_pkg.assign_column('100','CR.EXCHANGE_RATE_TYPE' ,'EXCHANGE_TYPE'
400: ,'arrx_rc_unapp.var.exchange_type' ,'VARCHAR2',30);
401: fa_rx_util_pkg.assign_column('110','DOCSEQ.NAME' ,'DOC_SEQUENCE_NAME'
402: ,'arrx_rc_unapp.var.doc_sequence_name' ,'VARCHAR2',30);
403: fa_rx_util_pkg.assign_column('120','CR.DOC_SEQUENCE_VALUE' ,'DOC_SEQUENCE_VALUE'
404: ,'arrx_rc_unapp.var.doc_sequence_value' ,'NUMBER');

Line 402: ,'arrx_rc_unapp.var.doc_sequence_name' ,'VARCHAR2',30);

398: ,'arrx_rc_unapp.var.exchange_date' ,'DATE');
399: fa_rx_util_pkg.assign_column('100','CR.EXCHANGE_RATE_TYPE' ,'EXCHANGE_TYPE'
400: ,'arrx_rc_unapp.var.exchange_type' ,'VARCHAR2',30);
401: fa_rx_util_pkg.assign_column('110','DOCSEQ.NAME' ,'DOC_SEQUENCE_NAME'
402: ,'arrx_rc_unapp.var.doc_sequence_name' ,'VARCHAR2',30);
403: fa_rx_util_pkg.assign_column('120','CR.DOC_SEQUENCE_VALUE' ,'DOC_SEQUENCE_VALUE'
404: ,'arrx_rc_unapp.var.doc_sequence_value' ,'NUMBER');
405: fa_rx_util_pkg.assign_column('130','CR.DEPOSIT_DATE' ,'DEPOSIT_DATE'
406: ,'arrx_rc_unapp.var.deposit_date' ,'DATE');

Line 404: ,'arrx_rc_unapp.var.doc_sequence_value' ,'NUMBER');

400: ,'arrx_rc_unapp.var.exchange_type' ,'VARCHAR2',30);
401: fa_rx_util_pkg.assign_column('110','DOCSEQ.NAME' ,'DOC_SEQUENCE_NAME'
402: ,'arrx_rc_unapp.var.doc_sequence_name' ,'VARCHAR2',30);
403: fa_rx_util_pkg.assign_column('120','CR.DOC_SEQUENCE_VALUE' ,'DOC_SEQUENCE_VALUE'
404: ,'arrx_rc_unapp.var.doc_sequence_value' ,'NUMBER');
405: fa_rx_util_pkg.assign_column('130','CR.DEPOSIT_DATE' ,'DEPOSIT_DATE'
406: ,'arrx_rc_unapp.var.deposit_date' ,'DATE');
407: fa_rx_util_pkg.assign_column('140','CR.RECEIPT_DATE' ,'RECEIPT_DATE'
408: ,'arrx_rc_unapp.var.receipt_date' ,'DATE');

Line 406: ,'arrx_rc_unapp.var.deposit_date' ,'DATE');

402: ,'arrx_rc_unapp.var.doc_sequence_name' ,'VARCHAR2',30);
403: fa_rx_util_pkg.assign_column('120','CR.DOC_SEQUENCE_VALUE' ,'DOC_SEQUENCE_VALUE'
404: ,'arrx_rc_unapp.var.doc_sequence_value' ,'NUMBER');
405: fa_rx_util_pkg.assign_column('130','CR.DEPOSIT_DATE' ,'DEPOSIT_DATE'
406: ,'arrx_rc_unapp.var.deposit_date' ,'DATE');
407: fa_rx_util_pkg.assign_column('140','CR.RECEIPT_DATE' ,'RECEIPT_DATE'
408: ,'arrx_rc_unapp.var.receipt_date' ,'DATE');
409: fa_rx_util_pkg.assign_column('150',CR_STATUS_DECODE ,'RECEIPT_STATUS'
410: ,'arrx_rc_unapp.var.receipt_status' ,'VARCHAR2',40);

Line 408: ,'arrx_rc_unapp.var.receipt_date' ,'DATE');

404: ,'arrx_rc_unapp.var.doc_sequence_value' ,'NUMBER');
405: fa_rx_util_pkg.assign_column('130','CR.DEPOSIT_DATE' ,'DEPOSIT_DATE'
406: ,'arrx_rc_unapp.var.deposit_date' ,'DATE');
407: fa_rx_util_pkg.assign_column('140','CR.RECEIPT_DATE' ,'RECEIPT_DATE'
408: ,'arrx_rc_unapp.var.receipt_date' ,'DATE');
409: fa_rx_util_pkg.assign_column('150',CR_STATUS_DECODE ,'RECEIPT_STATUS'
410: ,'arrx_rc_unapp.var.receipt_status' ,'VARCHAR2',40);
411: fa_rx_util_pkg.assign_column('160','ABB.BANK_NAME' ,'BANK_NAME'
412: ,'arrx_rc_unapp.var.bank_name' ,'VARCHAR2',60);

Line 410: ,'arrx_rc_unapp.var.receipt_status' ,'VARCHAR2',40);

406: ,'arrx_rc_unapp.var.deposit_date' ,'DATE');
407: fa_rx_util_pkg.assign_column('140','CR.RECEIPT_DATE' ,'RECEIPT_DATE'
408: ,'arrx_rc_unapp.var.receipt_date' ,'DATE');
409: fa_rx_util_pkg.assign_column('150',CR_STATUS_DECODE ,'RECEIPT_STATUS'
410: ,'arrx_rc_unapp.var.receipt_status' ,'VARCHAR2',40);
411: fa_rx_util_pkg.assign_column('160','ABB.BANK_NAME' ,'BANK_NAME'
412: ,'arrx_rc_unapp.var.bank_name' ,'VARCHAR2',60);
413: fa_rx_util_pkg.assign_column('170','ABB.BANK_NAME_ALT' ,'BANK_NAME_ALT'
414: ,'arrx_rc_unapp.var.bank_name_alt' ,'VARCHAR2',320);

Line 412: ,'arrx_rc_unapp.var.bank_name' ,'VARCHAR2',60);

408: ,'arrx_rc_unapp.var.receipt_date' ,'DATE');
409: fa_rx_util_pkg.assign_column('150',CR_STATUS_DECODE ,'RECEIPT_STATUS'
410: ,'arrx_rc_unapp.var.receipt_status' ,'VARCHAR2',40);
411: fa_rx_util_pkg.assign_column('160','ABB.BANK_NAME' ,'BANK_NAME'
412: ,'arrx_rc_unapp.var.bank_name' ,'VARCHAR2',60);
413: fa_rx_util_pkg.assign_column('170','ABB.BANK_NAME_ALT' ,'BANK_NAME_ALT'
414: ,'arrx_rc_unapp.var.bank_name_alt' ,'VARCHAR2',320);
415: fa_rx_util_pkg.assign_column('180','ABB.BANK_BRANCH_NAME' ,'BANK_BRANCH_NAME'
416: ,'arrx_rc_unapp.var.bank_branch_name' ,'VARCHAR2',60);

Line 414: ,'arrx_rc_unapp.var.bank_name_alt' ,'VARCHAR2',320);

410: ,'arrx_rc_unapp.var.receipt_status' ,'VARCHAR2',40);
411: fa_rx_util_pkg.assign_column('160','ABB.BANK_NAME' ,'BANK_NAME'
412: ,'arrx_rc_unapp.var.bank_name' ,'VARCHAR2',60);
413: fa_rx_util_pkg.assign_column('170','ABB.BANK_NAME_ALT' ,'BANK_NAME_ALT'
414: ,'arrx_rc_unapp.var.bank_name_alt' ,'VARCHAR2',320);
415: fa_rx_util_pkg.assign_column('180','ABB.BANK_BRANCH_NAME' ,'BANK_BRANCH_NAME'
416: ,'arrx_rc_unapp.var.bank_branch_name' ,'VARCHAR2',60);
417: fa_rx_util_pkg.assign_column('190','ABB.BANK_BRANCH_NAME_ALT' ,'BANK_BRANCH_NAME_ALT'
418: ,'arrx_rc_unapp.var.bank_name_alt' ,'VARCHAR2',320);

Line 416: ,'arrx_rc_unapp.var.bank_branch_name' ,'VARCHAR2',60);

412: ,'arrx_rc_unapp.var.bank_name' ,'VARCHAR2',60);
413: fa_rx_util_pkg.assign_column('170','ABB.BANK_NAME_ALT' ,'BANK_NAME_ALT'
414: ,'arrx_rc_unapp.var.bank_name_alt' ,'VARCHAR2',320);
415: fa_rx_util_pkg.assign_column('180','ABB.BANK_BRANCH_NAME' ,'BANK_BRANCH_NAME'
416: ,'arrx_rc_unapp.var.bank_branch_name' ,'VARCHAR2',60);
417: fa_rx_util_pkg.assign_column('190','ABB.BANK_BRANCH_NAME_ALT' ,'BANK_BRANCH_NAME_ALT'
418: ,'arrx_rc_unapp.var.bank_name_alt' ,'VARCHAR2',320);
419: fa_rx_util_pkg.assign_column('200','ABB.BANK_NUMBER' ,'BANK_NUMBER'
420: ,'arrx_rc_unapp.var.bank_number' ,'VARCHAR2',30);

Line 418: ,'arrx_rc_unapp.var.bank_name_alt' ,'VARCHAR2',320);

414: ,'arrx_rc_unapp.var.bank_name_alt' ,'VARCHAR2',320);
415: fa_rx_util_pkg.assign_column('180','ABB.BANK_BRANCH_NAME' ,'BANK_BRANCH_NAME'
416: ,'arrx_rc_unapp.var.bank_branch_name' ,'VARCHAR2',60);
417: fa_rx_util_pkg.assign_column('190','ABB.BANK_BRANCH_NAME_ALT' ,'BANK_BRANCH_NAME_ALT'
418: ,'arrx_rc_unapp.var.bank_name_alt' ,'VARCHAR2',320);
419: fa_rx_util_pkg.assign_column('200','ABB.BANK_NUMBER' ,'BANK_NUMBER'
420: ,'arrx_rc_unapp.var.bank_number' ,'VARCHAR2',30);
421: fa_rx_util_pkg.assign_column('210','ABB.BRANCH_NUMBER' ,'BANK_BRANCH_NUMBER'
422: ,'arrx_rc_unapp.var.bank_branch_number' ,'VARCHAR2',25);

Line 420: ,'arrx_rc_unapp.var.bank_number' ,'VARCHAR2',30);

416: ,'arrx_rc_unapp.var.bank_branch_name' ,'VARCHAR2',60);
417: fa_rx_util_pkg.assign_column('190','ABB.BANK_BRANCH_NAME_ALT' ,'BANK_BRANCH_NAME_ALT'
418: ,'arrx_rc_unapp.var.bank_name_alt' ,'VARCHAR2',320);
419: fa_rx_util_pkg.assign_column('200','ABB.BANK_NUMBER' ,'BANK_NUMBER'
420: ,'arrx_rc_unapp.var.bank_number' ,'VARCHAR2',30);
421: fa_rx_util_pkg.assign_column('210','ABB.BRANCH_NUMBER' ,'BANK_BRANCH_NUMBER'
422: ,'arrx_rc_unapp.var.bank_branch_number' ,'VARCHAR2',25);
423: fa_rx_util_pkg.assign_column('220','ABA.BANK_ACCOUNT_NAME' ,'BANK_ACCOUNT_NAME'
424: ,'arrx_rc_unapp.var.bank_account_name' ,'VARCHAR2', 80);

Line 422: ,'arrx_rc_unapp.var.bank_branch_number' ,'VARCHAR2',25);

418: ,'arrx_rc_unapp.var.bank_name_alt' ,'VARCHAR2',320);
419: fa_rx_util_pkg.assign_column('200','ABB.BANK_NUMBER' ,'BANK_NUMBER'
420: ,'arrx_rc_unapp.var.bank_number' ,'VARCHAR2',30);
421: fa_rx_util_pkg.assign_column('210','ABB.BRANCH_NUMBER' ,'BANK_BRANCH_NUMBER'
422: ,'arrx_rc_unapp.var.bank_branch_number' ,'VARCHAR2',25);
423: fa_rx_util_pkg.assign_column('220','ABA.BANK_ACCOUNT_NAME' ,'BANK_ACCOUNT_NAME'
424: ,'arrx_rc_unapp.var.bank_account_name' ,'VARCHAR2', 80);
425: fa_rx_util_pkg.assign_column('230','ABA.BANK_ACCOUNT_NAME_ALT', 'BANK_ACCOUNT_NAME_ALT'
426: ,'arrx_rc_unapp.var.bank_account_name_alt' ,'VARCHAR2', 320);

Line 424: ,'arrx_rc_unapp.var.bank_account_name' ,'VARCHAR2', 80);

420: ,'arrx_rc_unapp.var.bank_number' ,'VARCHAR2',30);
421: fa_rx_util_pkg.assign_column('210','ABB.BRANCH_NUMBER' ,'BANK_BRANCH_NUMBER'
422: ,'arrx_rc_unapp.var.bank_branch_number' ,'VARCHAR2',25);
423: fa_rx_util_pkg.assign_column('220','ABA.BANK_ACCOUNT_NAME' ,'BANK_ACCOUNT_NAME'
424: ,'arrx_rc_unapp.var.bank_account_name' ,'VARCHAR2', 80);
425: fa_rx_util_pkg.assign_column('230','ABA.BANK_ACCOUNT_NAME_ALT', 'BANK_ACCOUNT_NAME_ALT'
426: ,'arrx_rc_unapp.var.bank_account_name_alt' ,'VARCHAR2', 320);
427: fa_rx_util_pkg.assign_column('240','ABA.CURRENCY_CODE' ,'BANK_ACCOUNT_CURRENCY'
428: ,'arrx_rc_unapp.var.bank_account_currency' ,'VARCHAR2',15);

Line 426: ,'arrx_rc_unapp.var.bank_account_name_alt' ,'VARCHAR2', 320);

422: ,'arrx_rc_unapp.var.bank_branch_number' ,'VARCHAR2',25);
423: fa_rx_util_pkg.assign_column('220','ABA.BANK_ACCOUNT_NAME' ,'BANK_ACCOUNT_NAME'
424: ,'arrx_rc_unapp.var.bank_account_name' ,'VARCHAR2', 80);
425: fa_rx_util_pkg.assign_column('230','ABA.BANK_ACCOUNT_NAME_ALT', 'BANK_ACCOUNT_NAME_ALT'
426: ,'arrx_rc_unapp.var.bank_account_name_alt' ,'VARCHAR2', 320);
427: fa_rx_util_pkg.assign_column('240','ABA.CURRENCY_CODE' ,'BANK_ACCOUNT_CURRENCY'
428: ,'arrx_rc_unapp.var.bank_account_currency' ,'VARCHAR2',15);
429: fa_rx_util_pkg.assign_column('250','ARM.NAME' ,'RECEIPT_METHOD'
430: ,'arrx_rc_unapp.var.receipt_method' ,'VARCHAR2',30);

Line 428: ,'arrx_rc_unapp.var.bank_account_currency' ,'VARCHAR2',15);

424: ,'arrx_rc_unapp.var.bank_account_name' ,'VARCHAR2', 80);
425: fa_rx_util_pkg.assign_column('230','ABA.BANK_ACCOUNT_NAME_ALT', 'BANK_ACCOUNT_NAME_ALT'
426: ,'arrx_rc_unapp.var.bank_account_name_alt' ,'VARCHAR2', 320);
427: fa_rx_util_pkg.assign_column('240','ABA.CURRENCY_CODE' ,'BANK_ACCOUNT_CURRENCY'
428: ,'arrx_rc_unapp.var.bank_account_currency' ,'VARCHAR2',15);
429: fa_rx_util_pkg.assign_column('250','ARM.NAME' ,'RECEIPT_METHOD'
430: ,'arrx_rc_unapp.var.receipt_method' ,'VARCHAR2',30);
431: fa_rx_util_pkg.assign_column('260','CRH.CASH_RECEIPT_HISTORY_ID','CASH_RECEIPT_HISTORY_ID'
432: ,'arrx_rc_unapp.var.cash_receipt_history_id' ,'NUMBER');

Line 430: ,'arrx_rc_unapp.var.receipt_method' ,'VARCHAR2',30);

426: ,'arrx_rc_unapp.var.bank_account_name_alt' ,'VARCHAR2', 320);
427: fa_rx_util_pkg.assign_column('240','ABA.CURRENCY_CODE' ,'BANK_ACCOUNT_CURRENCY'
428: ,'arrx_rc_unapp.var.bank_account_currency' ,'VARCHAR2',15);
429: fa_rx_util_pkg.assign_column('250','ARM.NAME' ,'RECEIPT_METHOD'
430: ,'arrx_rc_unapp.var.receipt_method' ,'VARCHAR2',30);
431: fa_rx_util_pkg.assign_column('260','CRH.CASH_RECEIPT_HISTORY_ID','CASH_RECEIPT_HISTORY_ID'
432: ,'arrx_rc_unapp.var.cash_receipt_history_id' ,'NUMBER');
433: fa_rx_util_pkg.assign_column('270','MAX(RA.GL_DATE)' ,'GL_DATE'
434: ,'arrx_rc_unapp.var.gl_date' ,'DATE');

Line 432: ,'arrx_rc_unapp.var.cash_receipt_history_id' ,'NUMBER');

428: ,'arrx_rc_unapp.var.bank_account_currency' ,'VARCHAR2',15);
429: fa_rx_util_pkg.assign_column('250','ARM.NAME' ,'RECEIPT_METHOD'
430: ,'arrx_rc_unapp.var.receipt_method' ,'VARCHAR2',30);
431: fa_rx_util_pkg.assign_column('260','CRH.CASH_RECEIPT_HISTORY_ID','CASH_RECEIPT_HISTORY_ID'
432: ,'arrx_rc_unapp.var.cash_receipt_history_id' ,'NUMBER');
433: fa_rx_util_pkg.assign_column('270','MAX(RA.GL_DATE)' ,'GL_DATE'
434: ,'arrx_rc_unapp.var.gl_date' ,'DATE');
435: fa_rx_util_pkg.assign_column('280','CRH_CURR.AMOUNT' ,'RECEIPT_AMOUNT'
436: ,'arrx_rc_unapp.var.receipt_amount' ,'NUMBER');

Line 434: ,'arrx_rc_unapp.var.gl_date' ,'DATE');

430: ,'arrx_rc_unapp.var.receipt_method' ,'VARCHAR2',30);
431: fa_rx_util_pkg.assign_column('260','CRH.CASH_RECEIPT_HISTORY_ID','CASH_RECEIPT_HISTORY_ID'
432: ,'arrx_rc_unapp.var.cash_receipt_history_id' ,'NUMBER');
433: fa_rx_util_pkg.assign_column('270','MAX(RA.GL_DATE)' ,'GL_DATE'
434: ,'arrx_rc_unapp.var.gl_date' ,'DATE');
435: fa_rx_util_pkg.assign_column('280','CRH_CURR.AMOUNT' ,'RECEIPT_AMOUNT'
436: ,'arrx_rc_unapp.var.receipt_amount' ,'NUMBER');
437: fa_rx_util_pkg.assign_column('290','CRH_CURR.ACCTD_AMOUNT' ,'ACCTD_RECEIPT_AMOUNT'
438: ,'arrx_rc_unapp.var.acctd_receipt_amount' ,'NUMBER');

Line 436: ,'arrx_rc_unapp.var.receipt_amount' ,'NUMBER');

432: ,'arrx_rc_unapp.var.cash_receipt_history_id' ,'NUMBER');
433: fa_rx_util_pkg.assign_column('270','MAX(RA.GL_DATE)' ,'GL_DATE'
434: ,'arrx_rc_unapp.var.gl_date' ,'DATE');
435: fa_rx_util_pkg.assign_column('280','CRH_CURR.AMOUNT' ,'RECEIPT_AMOUNT'
436: ,'arrx_rc_unapp.var.receipt_amount' ,'NUMBER');
437: fa_rx_util_pkg.assign_column('290','CRH_CURR.ACCTD_AMOUNT' ,'ACCTD_RECEIPT_AMOUNT'
438: ,'arrx_rc_unapp.var.acctd_receipt_amount' ,'NUMBER');
439: fa_rx_util_pkg.assign_column('300','CRH_CURR.FACTOR_DISCOUNT_AMOUNT','FACTOR_DISCOUNT_AMOUNT'
440: ,'arrx_rc_unapp.var.factor_discount_amount' ,'NUMBER');

Line 438: ,'arrx_rc_unapp.var.acctd_receipt_amount' ,'NUMBER');

434: ,'arrx_rc_unapp.var.gl_date' ,'DATE');
435: fa_rx_util_pkg.assign_column('280','CRH_CURR.AMOUNT' ,'RECEIPT_AMOUNT'
436: ,'arrx_rc_unapp.var.receipt_amount' ,'NUMBER');
437: fa_rx_util_pkg.assign_column('290','CRH_CURR.ACCTD_AMOUNT' ,'ACCTD_RECEIPT_AMOUNT'
438: ,'arrx_rc_unapp.var.acctd_receipt_amount' ,'NUMBER');
439: fa_rx_util_pkg.assign_column('300','CRH_CURR.FACTOR_DISCOUNT_AMOUNT','FACTOR_DISCOUNT_AMOUNT'
440: ,'arrx_rc_unapp.var.factor_discount_amount' ,'NUMBER');
441: fa_rx_util_pkg.assign_column('310','CRH_CURR.ACCTD_FACTOR_DISCOUNT_AMOUNT','ACCTD_FACTOR_DISCOUNT_AMOUNT'
442: ,'arrx_rc_unapp.var.acctd_factor_discount_amount' ,'NUMBER');

Line 440: ,'arrx_rc_unapp.var.factor_discount_amount' ,'NUMBER');

436: ,'arrx_rc_unapp.var.receipt_amount' ,'NUMBER');
437: fa_rx_util_pkg.assign_column('290','CRH_CURR.ACCTD_AMOUNT' ,'ACCTD_RECEIPT_AMOUNT'
438: ,'arrx_rc_unapp.var.acctd_receipt_amount' ,'NUMBER');
439: fa_rx_util_pkg.assign_column('300','CRH_CURR.FACTOR_DISCOUNT_AMOUNT','FACTOR_DISCOUNT_AMOUNT'
440: ,'arrx_rc_unapp.var.factor_discount_amount' ,'NUMBER');
441: fa_rx_util_pkg.assign_column('310','CRH_CURR.ACCTD_FACTOR_DISCOUNT_AMOUNT','ACCTD_FACTOR_DISCOUNT_AMOUNT'
442: ,'arrx_rc_unapp.var.acctd_factor_discount_amount' ,'NUMBER');
443: fa_rx_util_pkg.assign_column('320',CRH_STATUS_DECODE ,'RECEIPT_HISTORY_STATUS'
444: ,'arrx_rc_unapp.var.receipt_history_status' ,'VARCHAR2', 40);

Line 442: ,'arrx_rc_unapp.var.acctd_factor_discount_amount' ,'NUMBER');

438: ,'arrx_rc_unapp.var.acctd_receipt_amount' ,'NUMBER');
439: fa_rx_util_pkg.assign_column('300','CRH_CURR.FACTOR_DISCOUNT_AMOUNT','FACTOR_DISCOUNT_AMOUNT'
440: ,'arrx_rc_unapp.var.factor_discount_amount' ,'NUMBER');
441: fa_rx_util_pkg.assign_column('310','CRH_CURR.ACCTD_FACTOR_DISCOUNT_AMOUNT','ACCTD_FACTOR_DISCOUNT_AMOUNT'
442: ,'arrx_rc_unapp.var.acctd_factor_discount_amount' ,'NUMBER');
443: fa_rx_util_pkg.assign_column('320',CRH_STATUS_DECODE ,'RECEIPT_HISTORY_STATUS'
444: ,'arrx_rc_unapp.var.receipt_history_status' ,'VARCHAR2', 40);
445: fa_rx_util_pkg.assign_column('330','CUST.CUST_ACCOUNT_ID' ,'CUSTOMER_ID'
446: ,'arrx_rc_unapp.var.customer_id' ,'NUMBER');

Line 444: ,'arrx_rc_unapp.var.receipt_history_status' ,'VARCHAR2', 40);

440: ,'arrx_rc_unapp.var.factor_discount_amount' ,'NUMBER');
441: fa_rx_util_pkg.assign_column('310','CRH_CURR.ACCTD_FACTOR_DISCOUNT_AMOUNT','ACCTD_FACTOR_DISCOUNT_AMOUNT'
442: ,'arrx_rc_unapp.var.acctd_factor_discount_amount' ,'NUMBER');
443: fa_rx_util_pkg.assign_column('320',CRH_STATUS_DECODE ,'RECEIPT_HISTORY_STATUS'
444: ,'arrx_rc_unapp.var.receipt_history_status' ,'VARCHAR2', 40);
445: fa_rx_util_pkg.assign_column('330','CUST.CUST_ACCOUNT_ID' ,'CUSTOMER_ID'
446: ,'arrx_rc_unapp.var.customer_id' ,'NUMBER');
447: fa_rx_util_pkg.assign_column('340','NVL(SUBSTRB(PARTY.PARTY_NAME,1,50),:L_UNID_CUST)', 'CUSTOMER_NAME'
448: ,'arrx_rc_unapp.var.customer_name' ,'VARCHAR2', 50);

Line 446: ,'arrx_rc_unapp.var.customer_id' ,'NUMBER');

442: ,'arrx_rc_unapp.var.acctd_factor_discount_amount' ,'NUMBER');
443: fa_rx_util_pkg.assign_column('320',CRH_STATUS_DECODE ,'RECEIPT_HISTORY_STATUS'
444: ,'arrx_rc_unapp.var.receipt_history_status' ,'VARCHAR2', 40);
445: fa_rx_util_pkg.assign_column('330','CUST.CUST_ACCOUNT_ID' ,'CUSTOMER_ID'
446: ,'arrx_rc_unapp.var.customer_id' ,'NUMBER');
447: fa_rx_util_pkg.assign_column('340','NVL(SUBSTRB(PARTY.PARTY_NAME,1,50),:L_UNID_CUST)', 'CUSTOMER_NAME'
448: ,'arrx_rc_unapp.var.customer_name' ,'VARCHAR2', 50);
449: fa_rx_util_pkg.assign_column('350','DECODE(PARTY.PARTY_TYPE, ''ORGANIZATION'',PARTY.ORGANIZATION_NAME_PHONETIC, NULL)' ,'CUSTOMER_NAME_ALT'
450: ,'arrx_rc_unapp.var.customer_name_alt' ,'VARCHAR2',320);

Line 448: ,'arrx_rc_unapp.var.customer_name' ,'VARCHAR2', 50);

444: ,'arrx_rc_unapp.var.receipt_history_status' ,'VARCHAR2', 40);
445: fa_rx_util_pkg.assign_column('330','CUST.CUST_ACCOUNT_ID' ,'CUSTOMER_ID'
446: ,'arrx_rc_unapp.var.customer_id' ,'NUMBER');
447: fa_rx_util_pkg.assign_column('340','NVL(SUBSTRB(PARTY.PARTY_NAME,1,50),:L_UNID_CUST)', 'CUSTOMER_NAME'
448: ,'arrx_rc_unapp.var.customer_name' ,'VARCHAR2', 50);
449: fa_rx_util_pkg.assign_column('350','DECODE(PARTY.PARTY_TYPE, ''ORGANIZATION'',PARTY.ORGANIZATION_NAME_PHONETIC, NULL)' ,'CUSTOMER_NAME_ALT'
450: ,'arrx_rc_unapp.var.customer_name_alt' ,'VARCHAR2',320);
451: fa_rx_util_pkg.assign_column('360','CUST.ACCOUNT_NUMBER' ,'CUSTOMER_NUMBER'
452: ,'arrx_rc_unapp.var.customer_number' ,'VARCHAR2', 30);

Line 450: ,'arrx_rc_unapp.var.customer_name_alt' ,'VARCHAR2',320);

446: ,'arrx_rc_unapp.var.customer_id' ,'NUMBER');
447: fa_rx_util_pkg.assign_column('340','NVL(SUBSTRB(PARTY.PARTY_NAME,1,50),:L_UNID_CUST)', 'CUSTOMER_NAME'
448: ,'arrx_rc_unapp.var.customer_name' ,'VARCHAR2', 50);
449: fa_rx_util_pkg.assign_column('350','DECODE(PARTY.PARTY_TYPE, ''ORGANIZATION'',PARTY.ORGANIZATION_NAME_PHONETIC, NULL)' ,'CUSTOMER_NAME_ALT'
450: ,'arrx_rc_unapp.var.customer_name_alt' ,'VARCHAR2',320);
451: fa_rx_util_pkg.assign_column('360','CUST.ACCOUNT_NUMBER' ,'CUSTOMER_NUMBER'
452: ,'arrx_rc_unapp.var.customer_number' ,'VARCHAR2', 30);
453: fa_rx_util_pkg.assign_column('370','BS.NAME' ,'BATCH_SOURCE'
454: ,'arrx_rc_unapp.var.batch_source' ,'VARCHAR2',30);

Line 452: ,'arrx_rc_unapp.var.customer_number' ,'VARCHAR2', 30);

448: ,'arrx_rc_unapp.var.customer_name' ,'VARCHAR2', 50);
449: fa_rx_util_pkg.assign_column('350','DECODE(PARTY.PARTY_TYPE, ''ORGANIZATION'',PARTY.ORGANIZATION_NAME_PHONETIC, NULL)' ,'CUSTOMER_NAME_ALT'
450: ,'arrx_rc_unapp.var.customer_name_alt' ,'VARCHAR2',320);
451: fa_rx_util_pkg.assign_column('360','CUST.ACCOUNT_NUMBER' ,'CUSTOMER_NUMBER'
452: ,'arrx_rc_unapp.var.customer_number' ,'VARCHAR2', 30);
453: fa_rx_util_pkg.assign_column('370','BS.NAME' ,'BATCH_SOURCE'
454: ,'arrx_rc_unapp.var.batch_source' ,'VARCHAR2',30);
455: fa_rx_util_pkg.assign_column('380',ON_ACC_AMT_DECODE ,'ON_ACCOUNT_AMOUNT'
456: ,'arrx_rc_unapp.var.on_acc_amount' ,'NUMBER');

Line 454: ,'arrx_rc_unapp.var.batch_source' ,'VARCHAR2',30);

450: ,'arrx_rc_unapp.var.customer_name_alt' ,'VARCHAR2',320);
451: fa_rx_util_pkg.assign_column('360','CUST.ACCOUNT_NUMBER' ,'CUSTOMER_NUMBER'
452: ,'arrx_rc_unapp.var.customer_number' ,'VARCHAR2', 30);
453: fa_rx_util_pkg.assign_column('370','BS.NAME' ,'BATCH_SOURCE'
454: ,'arrx_rc_unapp.var.batch_source' ,'VARCHAR2',30);
455: fa_rx_util_pkg.assign_column('380',ON_ACC_AMT_DECODE ,'ON_ACCOUNT_AMOUNT'
456: ,'arrx_rc_unapp.var.on_acc_amount' ,'NUMBER');
457: fa_rx_util_pkg.assign_column('390',UNAPP_AMT_DECODE ,'UNAPP_AMOUNT'
458: ,'arrx_rc_unapp.var.unapp_amount' ,'NUMBER');

Line 456: ,'arrx_rc_unapp.var.on_acc_amount' ,'NUMBER');

452: ,'arrx_rc_unapp.var.customer_number' ,'VARCHAR2', 30);
453: fa_rx_util_pkg.assign_column('370','BS.NAME' ,'BATCH_SOURCE'
454: ,'arrx_rc_unapp.var.batch_source' ,'VARCHAR2',30);
455: fa_rx_util_pkg.assign_column('380',ON_ACC_AMT_DECODE ,'ON_ACCOUNT_AMOUNT'
456: ,'arrx_rc_unapp.var.on_acc_amount' ,'NUMBER');
457: fa_rx_util_pkg.assign_column('390',UNAPP_AMT_DECODE ,'UNAPP_AMOUNT'
458: ,'arrx_rc_unapp.var.unapp_amount' ,'NUMBER');
459: fa_rx_util_pkg.assign_column('400',CLAIM_AMT_DECODE ,'CLAIM_AMOUNT'
460: ,'arrx_rc_unapp.var.claim_amount' ,'NUMBER');

Line 458: ,'arrx_rc_unapp.var.unapp_amount' ,'NUMBER');

454: ,'arrx_rc_unapp.var.batch_source' ,'VARCHAR2',30);
455: fa_rx_util_pkg.assign_column('380',ON_ACC_AMT_DECODE ,'ON_ACCOUNT_AMOUNT'
456: ,'arrx_rc_unapp.var.on_acc_amount' ,'NUMBER');
457: fa_rx_util_pkg.assign_column('390',UNAPP_AMT_DECODE ,'UNAPP_AMOUNT'
458: ,'arrx_rc_unapp.var.unapp_amount' ,'NUMBER');
459: fa_rx_util_pkg.assign_column('400',CLAIM_AMT_DECODE ,'CLAIM_AMOUNT'
460: ,'arrx_rc_unapp.var.claim_amount' ,'NUMBER');
461: fa_rx_util_pkg.assign_column('410',PREPAY_AMT_DECODE ,'PREPAY_AMOUNT'
462: ,'arrx_rc_unapp.var.prepay_amount' ,'NUMBER');

Line 460: ,'arrx_rc_unapp.var.claim_amount' ,'NUMBER');

456: ,'arrx_rc_unapp.var.on_acc_amount' ,'NUMBER');
457: fa_rx_util_pkg.assign_column('390',UNAPP_AMT_DECODE ,'UNAPP_AMOUNT'
458: ,'arrx_rc_unapp.var.unapp_amount' ,'NUMBER');
459: fa_rx_util_pkg.assign_column('400',CLAIM_AMT_DECODE ,'CLAIM_AMOUNT'
460: ,'arrx_rc_unapp.var.claim_amount' ,'NUMBER');
461: fa_rx_util_pkg.assign_column('410',PREPAY_AMT_DECODE ,'PREPAY_AMOUNT'
462: ,'arrx_rc_unapp.var.prepay_amount' ,'NUMBER');
463: fa_rx_util_pkg.assign_column('420',TOTAL_UNRESOLVED_AMT_DECODE,'TOTAL_UNRESOLVED_AMOUNT'
464: ,'arrx_rc_unapp.var.total_unresolved_amount' ,'NUMBER');

Line 462: ,'arrx_rc_unapp.var.prepay_amount' ,'NUMBER');

458: ,'arrx_rc_unapp.var.unapp_amount' ,'NUMBER');
459: fa_rx_util_pkg.assign_column('400',CLAIM_AMT_DECODE ,'CLAIM_AMOUNT'
460: ,'arrx_rc_unapp.var.claim_amount' ,'NUMBER');
461: fa_rx_util_pkg.assign_column('410',PREPAY_AMT_DECODE ,'PREPAY_AMOUNT'
462: ,'arrx_rc_unapp.var.prepay_amount' ,'NUMBER');
463: fa_rx_util_pkg.assign_column('420',TOTAL_UNRESOLVED_AMT_DECODE,'TOTAL_UNRESOLVED_AMOUNT'
464: ,'arrx_rc_unapp.var.total_unresolved_amount' ,'NUMBER');
465: fa_rx_util_pkg.assign_column('430',FORMAT_CURRENCY_DECODE ,'FORMAT_CURRENCY_CODE'
466: ,'arrx_rc_unapp.var.format_currency_code' ,'VARCHAR2',15);

Line 464: ,'arrx_rc_unapp.var.total_unresolved_amount' ,'NUMBER');

460: ,'arrx_rc_unapp.var.claim_amount' ,'NUMBER');
461: fa_rx_util_pkg.assign_column('410',PREPAY_AMT_DECODE ,'PREPAY_AMOUNT'
462: ,'arrx_rc_unapp.var.prepay_amount' ,'NUMBER');
463: fa_rx_util_pkg.assign_column('420',TOTAL_UNRESOLVED_AMT_DECODE,'TOTAL_UNRESOLVED_AMOUNT'
464: ,'arrx_rc_unapp.var.total_unresolved_amount' ,'NUMBER');
465: fa_rx_util_pkg.assign_column('430',FORMAT_CURRENCY_DECODE ,'FORMAT_CURRENCY_CODE'
466: ,'arrx_rc_unapp.var.format_currency_code' ,'VARCHAR2',15);
467: fa_rx_util_pkg.assign_column('440','GC.CODE_COMBINATION_ID' ,'ACCOUNT_CODE_COMBINATION_ID'
468: ,'arrx_rc_unapp.var.account_code_combination_id' ,'NUMBER');

Line 466: ,'arrx_rc_unapp.var.format_currency_code' ,'VARCHAR2',15);

462: ,'arrx_rc_unapp.var.prepay_amount' ,'NUMBER');
463: fa_rx_util_pkg.assign_column('420',TOTAL_UNRESOLVED_AMT_DECODE,'TOTAL_UNRESOLVED_AMOUNT'
464: ,'arrx_rc_unapp.var.total_unresolved_amount' ,'NUMBER');
465: fa_rx_util_pkg.assign_column('430',FORMAT_CURRENCY_DECODE ,'FORMAT_CURRENCY_CODE'
466: ,'arrx_rc_unapp.var.format_currency_code' ,'VARCHAR2',15);
467: fa_rx_util_pkg.assign_column('440','GC.CODE_COMBINATION_ID' ,'ACCOUNT_CODE_COMBINATION_ID'
468: ,'arrx_rc_unapp.var.account_code_combination_id' ,'NUMBER');
469: fa_rx_util_pkg.assign_column('450',NULL ,'DEBIT_BALANCING'
470: ,'arrx_rc_unapp.var.debit_balancing' ,'VARCHAR2',240);

Line 468: ,'arrx_rc_unapp.var.account_code_combination_id' ,'NUMBER');

464: ,'arrx_rc_unapp.var.total_unresolved_amount' ,'NUMBER');
465: fa_rx_util_pkg.assign_column('430',FORMAT_CURRENCY_DECODE ,'FORMAT_CURRENCY_CODE'
466: ,'arrx_rc_unapp.var.format_currency_code' ,'VARCHAR2',15);
467: fa_rx_util_pkg.assign_column('440','GC.CODE_COMBINATION_ID' ,'ACCOUNT_CODE_COMBINATION_ID'
468: ,'arrx_rc_unapp.var.account_code_combination_id' ,'NUMBER');
469: fa_rx_util_pkg.assign_column('450',NULL ,'DEBIT_BALANCING'
470: ,'arrx_rc_unapp.var.debit_balancing' ,'VARCHAR2',240);
471:
472:

Line 470: ,'arrx_rc_unapp.var.debit_balancing' ,'VARCHAR2',240);

466: ,'arrx_rc_unapp.var.format_currency_code' ,'VARCHAR2',15);
467: fa_rx_util_pkg.assign_column('440','GC.CODE_COMBINATION_ID' ,'ACCOUNT_CODE_COMBINATION_ID'
468: ,'arrx_rc_unapp.var.account_code_combination_id' ,'NUMBER');
469: fa_rx_util_pkg.assign_column('450',NULL ,'DEBIT_BALANCING'
470: ,'arrx_rc_unapp.var.debit_balancing' ,'VARCHAR2',240);
471:
472:
473: /* Assign the From Clause */
474: fa_rx_util_pkg.debug(' Assigning the FROM CLAUSE');

Line 604: fa_rx_util_pkg.debug('arrx_rc_unapp.before_report()-');

600: OR ' || PREPAY_AMT_DECODE||' <> 0 ';
601:
602:
603:
604: fa_rx_util_pkg.debug('arrx_rc_unapp.before_report()-');
605:
606:
607: END before_report;
608:

Line 623: fa_rx_util_pkg.debug('arrx_rc_unapp.bind()+');

619: l_unapp VARCHAR2(80);
620: l_unid VARCHAR2(80);
621: l_unid_cust VARCHAR2(80);
622: begin
623: fa_rx_util_pkg.debug('arrx_rc_unapp.bind()+');
624:
625: IF var.p_gl_date_from IS NOT NULL THEN
626: dbms_sql.bind_variable(c, 'p_gl_date_from', var.p_gl_date_from);
627: END IF;

Line 709: fa_rx_util_pkg.debug('arrx_rc_unapp.bind()-');

705: dbms_sql.bind_variable(c, 'L_CONFIRMED' , L_CONFIRMED);
706: dbms_sql.bind_variable(c, 'L_REMITTED' , L_REMITTED);
707: dbms_sql.bind_variable(c, 'L_REVERSED' , L_REVERSED);
708:
709: fa_rx_util_pkg.debug('arrx_rc_unapp.bind()-');
710:
711: END bind;
712: PROCEDURE after_fetch IS
713: begin

Line 714: fa_rx_util_pkg.debug('arrx_rc_unapp.after_fetch()+');

710:
711: END bind;
712: PROCEDURE after_fetch IS
713: begin
714: fa_rx_util_pkg.debug('arrx_rc_unapp.after_fetch()+');
715:
716: var.debit_balancing := fa_rx_flex_pkg.get_value(
717: p_application_id => 101,
718: p_id_flex_code => 'GL#',

Line 723: fa_rx_util_pkg.debug('arrx_rc_unapp.after_fetch()-');

719: p_id_flex_num => var.p_coa_id,
720: p_qualifier => 'GL_BALANCING',
721: p_ccid => var.account_code_combination_id);
722:
723: fa_rx_util_pkg.debug('arrx_rc_unapp.after_fetch()-');
724: end after_fetch;
725:
726: END ARRX_RC_UNAPP;

Line 726: END ARRX_RC_UNAPP;

722:
723: fa_rx_util_pkg.debug('arrx_rc_unapp.after_fetch()-');
724: end after_fetch;
725:
726: END ARRX_RC_UNAPP;