[Home] [Help]
1: PACKAGE BODY ARRX_RC_UNAPP AS
2: /* $Header: ARRXUNAB.pls 120.14 2012/05/18 11:26:20 kgnanase ship $ */
3:
4:
5: /*========================================================================+
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 ;
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;'
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 ';'.
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'.
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: */
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:
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 */
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');
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:
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
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);
187: L_RA_ORG_WHERE VARCHAR2(4000);
188: L_PS_ORG_WHERE VARCHAR2(4000);
189: BEGIN
190:
191: fa_rx_util_pkg.debug('arrx_rc_unapp.before_report()+');
192:
193: fa_rx_util_pkg.debug('Set of Books ID : '||var.p_sob_id);
194: fa_rx_util_pkg.debug('Get Chart of Accounts ID ');
195:
384: /* Assign the Select List */
385: fa_rx_util_pkg.debug('Assign Select List');
386:
387: fa_rx_util_pkg.assign_column('10',null ,'ORGANIZATION_NAME'
388: ,'arrx_rc_unapp.var.organization_name' ,'VARCHAR2', 50);
389: fa_rx_util_pkg.assign_column('20',null ,'FUNCTIONAL_CURRENCY_CODE'
390: ,'arrx_rc_unapp.var.functional_currency_code' ,'VARCHAR2', 15);
391: fa_rx_util_pkg.assign_column('30','BAT.BATCH_ID' ,'BATCH_ID'
392: ,'arrx_rc_unapp.var.batch_id' ,'NUMBER');
386:
387: fa_rx_util_pkg.assign_column('10',null ,'ORGANIZATION_NAME'
388: ,'arrx_rc_unapp.var.organization_name' ,'VARCHAR2', 50);
389: fa_rx_util_pkg.assign_column('20',null ,'FUNCTIONAL_CURRENCY_CODE'
390: ,'arrx_rc_unapp.var.functional_currency_code' ,'VARCHAR2', 15);
391: fa_rx_util_pkg.assign_column('30','BAT.BATCH_ID' ,'BATCH_ID'
392: ,'arrx_rc_unapp.var.batch_id' ,'NUMBER');
393: fa_rx_util_pkg.assign_column('40','BAT.NAME' ,'BATCH_NAME'
394: ,'arrx_rc_unapp.var.batch_name' ,'VARCHAR2', 20);
388: ,'arrx_rc_unapp.var.organization_name' ,'VARCHAR2', 50);
389: fa_rx_util_pkg.assign_column('20',null ,'FUNCTIONAL_CURRENCY_CODE'
390: ,'arrx_rc_unapp.var.functional_currency_code' ,'VARCHAR2', 15);
391: fa_rx_util_pkg.assign_column('30','BAT.BATCH_ID' ,'BATCH_ID'
392: ,'arrx_rc_unapp.var.batch_id' ,'NUMBER');
393: fa_rx_util_pkg.assign_column('40','BAT.NAME' ,'BATCH_NAME'
394: ,'arrx_rc_unapp.var.batch_name' ,'VARCHAR2', 20);
395: fa_rx_util_pkg.assign_column('50 ','CR.CASH_RECEIPT_ID' ,'CASH_RECEIPT_ID'
396: ,'arrx_rc_unapp.var.cash_receipt_id' ,'NUMBER');
390: ,'arrx_rc_unapp.var.functional_currency_code' ,'VARCHAR2', 15);
391: fa_rx_util_pkg.assign_column('30','BAT.BATCH_ID' ,'BATCH_ID'
392: ,'arrx_rc_unapp.var.batch_id' ,'NUMBER');
393: fa_rx_util_pkg.assign_column('40','BAT.NAME' ,'BATCH_NAME'
394: ,'arrx_rc_unapp.var.batch_name' ,'VARCHAR2', 20);
395: fa_rx_util_pkg.assign_column('50 ','CR.CASH_RECEIPT_ID' ,'CASH_RECEIPT_ID'
396: ,'arrx_rc_unapp.var.cash_receipt_id' ,'NUMBER');
397: fa_rx_util_pkg.assign_column('60','CR.RECEIPT_NUMBER' ,'RECEIPT_NUMBER'
398: ,'arrx_rc_unapp.var.receipt_number' ,'VARCHAR2', 30);
392: ,'arrx_rc_unapp.var.batch_id' ,'NUMBER');
393: fa_rx_util_pkg.assign_column('40','BAT.NAME' ,'BATCH_NAME'
394: ,'arrx_rc_unapp.var.batch_name' ,'VARCHAR2', 20);
395: fa_rx_util_pkg.assign_column('50 ','CR.CASH_RECEIPT_ID' ,'CASH_RECEIPT_ID'
396: ,'arrx_rc_unapp.var.cash_receipt_id' ,'NUMBER');
397: fa_rx_util_pkg.assign_column('60','CR.RECEIPT_NUMBER' ,'RECEIPT_NUMBER'
398: ,'arrx_rc_unapp.var.receipt_number' ,'VARCHAR2', 30);
399: fa_rx_util_pkg.assign_column('70','CR.CURRENCY_CODE' ,'RECEIPT_CURRENCY_CODE'
400: ,'arrx_rc_unapp.var.receipt_currency_code' ,'VARCHAR2', 15);
394: ,'arrx_rc_unapp.var.batch_name' ,'VARCHAR2', 20);
395: fa_rx_util_pkg.assign_column('50 ','CR.CASH_RECEIPT_ID' ,'CASH_RECEIPT_ID'
396: ,'arrx_rc_unapp.var.cash_receipt_id' ,'NUMBER');
397: fa_rx_util_pkg.assign_column('60','CR.RECEIPT_NUMBER' ,'RECEIPT_NUMBER'
398: ,'arrx_rc_unapp.var.receipt_number' ,'VARCHAR2', 30);
399: fa_rx_util_pkg.assign_column('70','CR.CURRENCY_CODE' ,'RECEIPT_CURRENCY_CODE'
400: ,'arrx_rc_unapp.var.receipt_currency_code' ,'VARCHAR2', 15);
401: fa_rx_util_pkg.assign_column('80','CR.EXCHANGE_RATE' ,'EXCHANGE_RATE'
402: ,'arrx_rc_unapp.var.exchange_rate' ,'NUMBER');
396: ,'arrx_rc_unapp.var.cash_receipt_id' ,'NUMBER');
397: fa_rx_util_pkg.assign_column('60','CR.RECEIPT_NUMBER' ,'RECEIPT_NUMBER'
398: ,'arrx_rc_unapp.var.receipt_number' ,'VARCHAR2', 30);
399: fa_rx_util_pkg.assign_column('70','CR.CURRENCY_CODE' ,'RECEIPT_CURRENCY_CODE'
400: ,'arrx_rc_unapp.var.receipt_currency_code' ,'VARCHAR2', 15);
401: fa_rx_util_pkg.assign_column('80','CR.EXCHANGE_RATE' ,'EXCHANGE_RATE'
402: ,'arrx_rc_unapp.var.exchange_rate' ,'NUMBER');
403: fa_rx_util_pkg.assign_column('90','CR.EXCHANGE_DATE' ,'EXCHANGE_DATE'
404: ,'arrx_rc_unapp.var.exchange_date' ,'DATE');
398: ,'arrx_rc_unapp.var.receipt_number' ,'VARCHAR2', 30);
399: fa_rx_util_pkg.assign_column('70','CR.CURRENCY_CODE' ,'RECEIPT_CURRENCY_CODE'
400: ,'arrx_rc_unapp.var.receipt_currency_code' ,'VARCHAR2', 15);
401: fa_rx_util_pkg.assign_column('80','CR.EXCHANGE_RATE' ,'EXCHANGE_RATE'
402: ,'arrx_rc_unapp.var.exchange_rate' ,'NUMBER');
403: fa_rx_util_pkg.assign_column('90','CR.EXCHANGE_DATE' ,'EXCHANGE_DATE'
404: ,'arrx_rc_unapp.var.exchange_date' ,'DATE');
405: fa_rx_util_pkg.assign_column('100','CR.EXCHANGE_RATE_TYPE' ,'EXCHANGE_TYPE'
406: ,'arrx_rc_unapp.var.exchange_type' ,'VARCHAR2',30);
400: ,'arrx_rc_unapp.var.receipt_currency_code' ,'VARCHAR2', 15);
401: fa_rx_util_pkg.assign_column('80','CR.EXCHANGE_RATE' ,'EXCHANGE_RATE'
402: ,'arrx_rc_unapp.var.exchange_rate' ,'NUMBER');
403: fa_rx_util_pkg.assign_column('90','CR.EXCHANGE_DATE' ,'EXCHANGE_DATE'
404: ,'arrx_rc_unapp.var.exchange_date' ,'DATE');
405: fa_rx_util_pkg.assign_column('100','CR.EXCHANGE_RATE_TYPE' ,'EXCHANGE_TYPE'
406: ,'arrx_rc_unapp.var.exchange_type' ,'VARCHAR2',30);
407: fa_rx_util_pkg.assign_column('110','DOCSEQ.NAME' ,'DOC_SEQUENCE_NAME'
408: ,'arrx_rc_unapp.var.doc_sequence_name' ,'VARCHAR2',30);
402: ,'arrx_rc_unapp.var.exchange_rate' ,'NUMBER');
403: fa_rx_util_pkg.assign_column('90','CR.EXCHANGE_DATE' ,'EXCHANGE_DATE'
404: ,'arrx_rc_unapp.var.exchange_date' ,'DATE');
405: fa_rx_util_pkg.assign_column('100','CR.EXCHANGE_RATE_TYPE' ,'EXCHANGE_TYPE'
406: ,'arrx_rc_unapp.var.exchange_type' ,'VARCHAR2',30);
407: fa_rx_util_pkg.assign_column('110','DOCSEQ.NAME' ,'DOC_SEQUENCE_NAME'
408: ,'arrx_rc_unapp.var.doc_sequence_name' ,'VARCHAR2',30);
409: fa_rx_util_pkg.assign_column('120','CR.DOC_SEQUENCE_VALUE' ,'DOC_SEQUENCE_VALUE'
410: ,'arrx_rc_unapp.var.doc_sequence_value' ,'NUMBER');
404: ,'arrx_rc_unapp.var.exchange_date' ,'DATE');
405: fa_rx_util_pkg.assign_column('100','CR.EXCHANGE_RATE_TYPE' ,'EXCHANGE_TYPE'
406: ,'arrx_rc_unapp.var.exchange_type' ,'VARCHAR2',30);
407: fa_rx_util_pkg.assign_column('110','DOCSEQ.NAME' ,'DOC_SEQUENCE_NAME'
408: ,'arrx_rc_unapp.var.doc_sequence_name' ,'VARCHAR2',30);
409: fa_rx_util_pkg.assign_column('120','CR.DOC_SEQUENCE_VALUE' ,'DOC_SEQUENCE_VALUE'
410: ,'arrx_rc_unapp.var.doc_sequence_value' ,'NUMBER');
411: fa_rx_util_pkg.assign_column('130','CR.DEPOSIT_DATE' ,'DEPOSIT_DATE'
412: ,'arrx_rc_unapp.var.deposit_date' ,'DATE');
406: ,'arrx_rc_unapp.var.exchange_type' ,'VARCHAR2',30);
407: fa_rx_util_pkg.assign_column('110','DOCSEQ.NAME' ,'DOC_SEQUENCE_NAME'
408: ,'arrx_rc_unapp.var.doc_sequence_name' ,'VARCHAR2',30);
409: fa_rx_util_pkg.assign_column('120','CR.DOC_SEQUENCE_VALUE' ,'DOC_SEQUENCE_VALUE'
410: ,'arrx_rc_unapp.var.doc_sequence_value' ,'NUMBER');
411: fa_rx_util_pkg.assign_column('130','CR.DEPOSIT_DATE' ,'DEPOSIT_DATE'
412: ,'arrx_rc_unapp.var.deposit_date' ,'DATE');
413: fa_rx_util_pkg.assign_column('140','CR.RECEIPT_DATE' ,'RECEIPT_DATE'
414: ,'arrx_rc_unapp.var.receipt_date' ,'DATE');
408: ,'arrx_rc_unapp.var.doc_sequence_name' ,'VARCHAR2',30);
409: fa_rx_util_pkg.assign_column('120','CR.DOC_SEQUENCE_VALUE' ,'DOC_SEQUENCE_VALUE'
410: ,'arrx_rc_unapp.var.doc_sequence_value' ,'NUMBER');
411: fa_rx_util_pkg.assign_column('130','CR.DEPOSIT_DATE' ,'DEPOSIT_DATE'
412: ,'arrx_rc_unapp.var.deposit_date' ,'DATE');
413: fa_rx_util_pkg.assign_column('140','CR.RECEIPT_DATE' ,'RECEIPT_DATE'
414: ,'arrx_rc_unapp.var.receipt_date' ,'DATE');
415: fa_rx_util_pkg.assign_column('150',CR_STATUS_DECODE ,'RECEIPT_STATUS'
416: ,'arrx_rc_unapp.var.receipt_status' ,'VARCHAR2',40);
410: ,'arrx_rc_unapp.var.doc_sequence_value' ,'NUMBER');
411: fa_rx_util_pkg.assign_column('130','CR.DEPOSIT_DATE' ,'DEPOSIT_DATE'
412: ,'arrx_rc_unapp.var.deposit_date' ,'DATE');
413: fa_rx_util_pkg.assign_column('140','CR.RECEIPT_DATE' ,'RECEIPT_DATE'
414: ,'arrx_rc_unapp.var.receipt_date' ,'DATE');
415: fa_rx_util_pkg.assign_column('150',CR_STATUS_DECODE ,'RECEIPT_STATUS'
416: ,'arrx_rc_unapp.var.receipt_status' ,'VARCHAR2',40);
417: fa_rx_util_pkg.assign_column('160','ABB.BANK_NAME' ,'BANK_NAME'
418: ,'arrx_rc_unapp.var.bank_name' ,'VARCHAR2',60);
412: ,'arrx_rc_unapp.var.deposit_date' ,'DATE');
413: fa_rx_util_pkg.assign_column('140','CR.RECEIPT_DATE' ,'RECEIPT_DATE'
414: ,'arrx_rc_unapp.var.receipt_date' ,'DATE');
415: fa_rx_util_pkg.assign_column('150',CR_STATUS_DECODE ,'RECEIPT_STATUS'
416: ,'arrx_rc_unapp.var.receipt_status' ,'VARCHAR2',40);
417: fa_rx_util_pkg.assign_column('160','ABB.BANK_NAME' ,'BANK_NAME'
418: ,'arrx_rc_unapp.var.bank_name' ,'VARCHAR2',60);
419: fa_rx_util_pkg.assign_column('170','ABB.BANK_NAME_ALT' ,'BANK_NAME_ALT'
420: ,'arrx_rc_unapp.var.bank_name_alt' ,'VARCHAR2',320);
414: ,'arrx_rc_unapp.var.receipt_date' ,'DATE');
415: fa_rx_util_pkg.assign_column('150',CR_STATUS_DECODE ,'RECEIPT_STATUS'
416: ,'arrx_rc_unapp.var.receipt_status' ,'VARCHAR2',40);
417: fa_rx_util_pkg.assign_column('160','ABB.BANK_NAME' ,'BANK_NAME'
418: ,'arrx_rc_unapp.var.bank_name' ,'VARCHAR2',60);
419: fa_rx_util_pkg.assign_column('170','ABB.BANK_NAME_ALT' ,'BANK_NAME_ALT'
420: ,'arrx_rc_unapp.var.bank_name_alt' ,'VARCHAR2',320);
421: fa_rx_util_pkg.assign_column('180','ABB.BANK_BRANCH_NAME' ,'BANK_BRANCH_NAME'
422: ,'arrx_rc_unapp.var.bank_branch_name' ,'VARCHAR2',60);
416: ,'arrx_rc_unapp.var.receipt_status' ,'VARCHAR2',40);
417: fa_rx_util_pkg.assign_column('160','ABB.BANK_NAME' ,'BANK_NAME'
418: ,'arrx_rc_unapp.var.bank_name' ,'VARCHAR2',60);
419: fa_rx_util_pkg.assign_column('170','ABB.BANK_NAME_ALT' ,'BANK_NAME_ALT'
420: ,'arrx_rc_unapp.var.bank_name_alt' ,'VARCHAR2',320);
421: fa_rx_util_pkg.assign_column('180','ABB.BANK_BRANCH_NAME' ,'BANK_BRANCH_NAME'
422: ,'arrx_rc_unapp.var.bank_branch_name' ,'VARCHAR2',60);
423: fa_rx_util_pkg.assign_column('190','ABB.BANK_BRANCH_NAME_ALT' ,'BANK_BRANCH_NAME_ALT'
424: ,'arrx_rc_unapp.var.bank_name_alt' ,'VARCHAR2',320);
418: ,'arrx_rc_unapp.var.bank_name' ,'VARCHAR2',60);
419: fa_rx_util_pkg.assign_column('170','ABB.BANK_NAME_ALT' ,'BANK_NAME_ALT'
420: ,'arrx_rc_unapp.var.bank_name_alt' ,'VARCHAR2',320);
421: fa_rx_util_pkg.assign_column('180','ABB.BANK_BRANCH_NAME' ,'BANK_BRANCH_NAME'
422: ,'arrx_rc_unapp.var.bank_branch_name' ,'VARCHAR2',60);
423: fa_rx_util_pkg.assign_column('190','ABB.BANK_BRANCH_NAME_ALT' ,'BANK_BRANCH_NAME_ALT'
424: ,'arrx_rc_unapp.var.bank_name_alt' ,'VARCHAR2',320);
425: fa_rx_util_pkg.assign_column('200','ABB.BANK_NUMBER' ,'BANK_NUMBER'
426: ,'arrx_rc_unapp.var.bank_number' ,'VARCHAR2',30);
420: ,'arrx_rc_unapp.var.bank_name_alt' ,'VARCHAR2',320);
421: fa_rx_util_pkg.assign_column('180','ABB.BANK_BRANCH_NAME' ,'BANK_BRANCH_NAME'
422: ,'arrx_rc_unapp.var.bank_branch_name' ,'VARCHAR2',60);
423: fa_rx_util_pkg.assign_column('190','ABB.BANK_BRANCH_NAME_ALT' ,'BANK_BRANCH_NAME_ALT'
424: ,'arrx_rc_unapp.var.bank_name_alt' ,'VARCHAR2',320);
425: fa_rx_util_pkg.assign_column('200','ABB.BANK_NUMBER' ,'BANK_NUMBER'
426: ,'arrx_rc_unapp.var.bank_number' ,'VARCHAR2',30);
427: fa_rx_util_pkg.assign_column('210','ABB.BRANCH_NUMBER' ,'BANK_BRANCH_NUMBER'
428: ,'arrx_rc_unapp.var.bank_branch_number' ,'VARCHAR2',25);
422: ,'arrx_rc_unapp.var.bank_branch_name' ,'VARCHAR2',60);
423: fa_rx_util_pkg.assign_column('190','ABB.BANK_BRANCH_NAME_ALT' ,'BANK_BRANCH_NAME_ALT'
424: ,'arrx_rc_unapp.var.bank_name_alt' ,'VARCHAR2',320);
425: fa_rx_util_pkg.assign_column('200','ABB.BANK_NUMBER' ,'BANK_NUMBER'
426: ,'arrx_rc_unapp.var.bank_number' ,'VARCHAR2',30);
427: fa_rx_util_pkg.assign_column('210','ABB.BRANCH_NUMBER' ,'BANK_BRANCH_NUMBER'
428: ,'arrx_rc_unapp.var.bank_branch_number' ,'VARCHAR2',25);
429: fa_rx_util_pkg.assign_column('220','ABA.BANK_ACCOUNT_NAME' ,'BANK_ACCOUNT_NAME'
430: ,'arrx_rc_unapp.var.bank_account_name' ,'VARCHAR2', 80);
424: ,'arrx_rc_unapp.var.bank_name_alt' ,'VARCHAR2',320);
425: fa_rx_util_pkg.assign_column('200','ABB.BANK_NUMBER' ,'BANK_NUMBER'
426: ,'arrx_rc_unapp.var.bank_number' ,'VARCHAR2',30);
427: fa_rx_util_pkg.assign_column('210','ABB.BRANCH_NUMBER' ,'BANK_BRANCH_NUMBER'
428: ,'arrx_rc_unapp.var.bank_branch_number' ,'VARCHAR2',25);
429: fa_rx_util_pkg.assign_column('220','ABA.BANK_ACCOUNT_NAME' ,'BANK_ACCOUNT_NAME'
430: ,'arrx_rc_unapp.var.bank_account_name' ,'VARCHAR2', 80);
431: fa_rx_util_pkg.assign_column('230','ABA.BANK_ACCOUNT_NAME_ALT', 'BANK_ACCOUNT_NAME_ALT'
432: ,'arrx_rc_unapp.var.bank_account_name_alt' ,'VARCHAR2', 320);
426: ,'arrx_rc_unapp.var.bank_number' ,'VARCHAR2',30);
427: fa_rx_util_pkg.assign_column('210','ABB.BRANCH_NUMBER' ,'BANK_BRANCH_NUMBER'
428: ,'arrx_rc_unapp.var.bank_branch_number' ,'VARCHAR2',25);
429: fa_rx_util_pkg.assign_column('220','ABA.BANK_ACCOUNT_NAME' ,'BANK_ACCOUNT_NAME'
430: ,'arrx_rc_unapp.var.bank_account_name' ,'VARCHAR2', 80);
431: fa_rx_util_pkg.assign_column('230','ABA.BANK_ACCOUNT_NAME_ALT', 'BANK_ACCOUNT_NAME_ALT'
432: ,'arrx_rc_unapp.var.bank_account_name_alt' ,'VARCHAR2', 320);
433: fa_rx_util_pkg.assign_column('240','ABA.CURRENCY_CODE' ,'BANK_ACCOUNT_CURRENCY'
434: ,'arrx_rc_unapp.var.bank_account_currency' ,'VARCHAR2',15);
428: ,'arrx_rc_unapp.var.bank_branch_number' ,'VARCHAR2',25);
429: fa_rx_util_pkg.assign_column('220','ABA.BANK_ACCOUNT_NAME' ,'BANK_ACCOUNT_NAME'
430: ,'arrx_rc_unapp.var.bank_account_name' ,'VARCHAR2', 80);
431: fa_rx_util_pkg.assign_column('230','ABA.BANK_ACCOUNT_NAME_ALT', 'BANK_ACCOUNT_NAME_ALT'
432: ,'arrx_rc_unapp.var.bank_account_name_alt' ,'VARCHAR2', 320);
433: fa_rx_util_pkg.assign_column('240','ABA.CURRENCY_CODE' ,'BANK_ACCOUNT_CURRENCY'
434: ,'arrx_rc_unapp.var.bank_account_currency' ,'VARCHAR2',15);
435: fa_rx_util_pkg.assign_column('250','ARM.NAME' ,'RECEIPT_METHOD'
436: ,'arrx_rc_unapp.var.receipt_method' ,'VARCHAR2',30);
430: ,'arrx_rc_unapp.var.bank_account_name' ,'VARCHAR2', 80);
431: fa_rx_util_pkg.assign_column('230','ABA.BANK_ACCOUNT_NAME_ALT', 'BANK_ACCOUNT_NAME_ALT'
432: ,'arrx_rc_unapp.var.bank_account_name_alt' ,'VARCHAR2', 320);
433: fa_rx_util_pkg.assign_column('240','ABA.CURRENCY_CODE' ,'BANK_ACCOUNT_CURRENCY'
434: ,'arrx_rc_unapp.var.bank_account_currency' ,'VARCHAR2',15);
435: fa_rx_util_pkg.assign_column('250','ARM.NAME' ,'RECEIPT_METHOD'
436: ,'arrx_rc_unapp.var.receipt_method' ,'VARCHAR2',30);
437: fa_rx_util_pkg.assign_column('260','CRH.CASH_RECEIPT_HISTORY_ID','CASH_RECEIPT_HISTORY_ID'
438: ,'arrx_rc_unapp.var.cash_receipt_history_id' ,'NUMBER');
432: ,'arrx_rc_unapp.var.bank_account_name_alt' ,'VARCHAR2', 320);
433: fa_rx_util_pkg.assign_column('240','ABA.CURRENCY_CODE' ,'BANK_ACCOUNT_CURRENCY'
434: ,'arrx_rc_unapp.var.bank_account_currency' ,'VARCHAR2',15);
435: fa_rx_util_pkg.assign_column('250','ARM.NAME' ,'RECEIPT_METHOD'
436: ,'arrx_rc_unapp.var.receipt_method' ,'VARCHAR2',30);
437: fa_rx_util_pkg.assign_column('260','CRH.CASH_RECEIPT_HISTORY_ID','CASH_RECEIPT_HISTORY_ID'
438: ,'arrx_rc_unapp.var.cash_receipt_history_id' ,'NUMBER');
439: fa_rx_util_pkg.assign_column('270','MAX(RA.GL_DATE)' ,'GL_DATE'
440: ,'arrx_rc_unapp.var.gl_date' ,'DATE');
434: ,'arrx_rc_unapp.var.bank_account_currency' ,'VARCHAR2',15);
435: fa_rx_util_pkg.assign_column('250','ARM.NAME' ,'RECEIPT_METHOD'
436: ,'arrx_rc_unapp.var.receipt_method' ,'VARCHAR2',30);
437: fa_rx_util_pkg.assign_column('260','CRH.CASH_RECEIPT_HISTORY_ID','CASH_RECEIPT_HISTORY_ID'
438: ,'arrx_rc_unapp.var.cash_receipt_history_id' ,'NUMBER');
439: fa_rx_util_pkg.assign_column('270','MAX(RA.GL_DATE)' ,'GL_DATE'
440: ,'arrx_rc_unapp.var.gl_date' ,'DATE');
441: fa_rx_util_pkg.assign_column('280','CRH_CURR.AMOUNT' ,'RECEIPT_AMOUNT'
442: ,'arrx_rc_unapp.var.receipt_amount' ,'NUMBER');
436: ,'arrx_rc_unapp.var.receipt_method' ,'VARCHAR2',30);
437: fa_rx_util_pkg.assign_column('260','CRH.CASH_RECEIPT_HISTORY_ID','CASH_RECEIPT_HISTORY_ID'
438: ,'arrx_rc_unapp.var.cash_receipt_history_id' ,'NUMBER');
439: fa_rx_util_pkg.assign_column('270','MAX(RA.GL_DATE)' ,'GL_DATE'
440: ,'arrx_rc_unapp.var.gl_date' ,'DATE');
441: fa_rx_util_pkg.assign_column('280','CRH_CURR.AMOUNT' ,'RECEIPT_AMOUNT'
442: ,'arrx_rc_unapp.var.receipt_amount' ,'NUMBER');
443: fa_rx_util_pkg.assign_column('290','CRH_CURR.ACCTD_AMOUNT' ,'ACCTD_RECEIPT_AMOUNT'
444: ,'arrx_rc_unapp.var.acctd_receipt_amount' ,'NUMBER');
438: ,'arrx_rc_unapp.var.cash_receipt_history_id' ,'NUMBER');
439: fa_rx_util_pkg.assign_column('270','MAX(RA.GL_DATE)' ,'GL_DATE'
440: ,'arrx_rc_unapp.var.gl_date' ,'DATE');
441: fa_rx_util_pkg.assign_column('280','CRH_CURR.AMOUNT' ,'RECEIPT_AMOUNT'
442: ,'arrx_rc_unapp.var.receipt_amount' ,'NUMBER');
443: fa_rx_util_pkg.assign_column('290','CRH_CURR.ACCTD_AMOUNT' ,'ACCTD_RECEIPT_AMOUNT'
444: ,'arrx_rc_unapp.var.acctd_receipt_amount' ,'NUMBER');
445: fa_rx_util_pkg.assign_column('300','CRH_CURR.FACTOR_DISCOUNT_AMOUNT','FACTOR_DISCOUNT_AMOUNT'
446: ,'arrx_rc_unapp.var.factor_discount_amount' ,'NUMBER');
440: ,'arrx_rc_unapp.var.gl_date' ,'DATE');
441: fa_rx_util_pkg.assign_column('280','CRH_CURR.AMOUNT' ,'RECEIPT_AMOUNT'
442: ,'arrx_rc_unapp.var.receipt_amount' ,'NUMBER');
443: fa_rx_util_pkg.assign_column('290','CRH_CURR.ACCTD_AMOUNT' ,'ACCTD_RECEIPT_AMOUNT'
444: ,'arrx_rc_unapp.var.acctd_receipt_amount' ,'NUMBER');
445: fa_rx_util_pkg.assign_column('300','CRH_CURR.FACTOR_DISCOUNT_AMOUNT','FACTOR_DISCOUNT_AMOUNT'
446: ,'arrx_rc_unapp.var.factor_discount_amount' ,'NUMBER');
447: fa_rx_util_pkg.assign_column('310','CRH_CURR.ACCTD_FACTOR_DISCOUNT_AMOUNT','ACCTD_FACTOR_DISCOUNT_AMOUNT'
448: ,'arrx_rc_unapp.var.acctd_factor_discount_amount' ,'NUMBER');
442: ,'arrx_rc_unapp.var.receipt_amount' ,'NUMBER');
443: fa_rx_util_pkg.assign_column('290','CRH_CURR.ACCTD_AMOUNT' ,'ACCTD_RECEIPT_AMOUNT'
444: ,'arrx_rc_unapp.var.acctd_receipt_amount' ,'NUMBER');
445: fa_rx_util_pkg.assign_column('300','CRH_CURR.FACTOR_DISCOUNT_AMOUNT','FACTOR_DISCOUNT_AMOUNT'
446: ,'arrx_rc_unapp.var.factor_discount_amount' ,'NUMBER');
447: fa_rx_util_pkg.assign_column('310','CRH_CURR.ACCTD_FACTOR_DISCOUNT_AMOUNT','ACCTD_FACTOR_DISCOUNT_AMOUNT'
448: ,'arrx_rc_unapp.var.acctd_factor_discount_amount' ,'NUMBER');
449: fa_rx_util_pkg.assign_column('320',CRH_STATUS_DECODE ,'RECEIPT_HISTORY_STATUS'
450: ,'arrx_rc_unapp.var.receipt_history_status' ,'VARCHAR2', 40);
444: ,'arrx_rc_unapp.var.acctd_receipt_amount' ,'NUMBER');
445: fa_rx_util_pkg.assign_column('300','CRH_CURR.FACTOR_DISCOUNT_AMOUNT','FACTOR_DISCOUNT_AMOUNT'
446: ,'arrx_rc_unapp.var.factor_discount_amount' ,'NUMBER');
447: fa_rx_util_pkg.assign_column('310','CRH_CURR.ACCTD_FACTOR_DISCOUNT_AMOUNT','ACCTD_FACTOR_DISCOUNT_AMOUNT'
448: ,'arrx_rc_unapp.var.acctd_factor_discount_amount' ,'NUMBER');
449: fa_rx_util_pkg.assign_column('320',CRH_STATUS_DECODE ,'RECEIPT_HISTORY_STATUS'
450: ,'arrx_rc_unapp.var.receipt_history_status' ,'VARCHAR2', 40);
451: fa_rx_util_pkg.assign_column('330','CUST.CUST_ACCOUNT_ID' ,'CUSTOMER_ID'
452: ,'arrx_rc_unapp.var.customer_id' ,'NUMBER');
446: ,'arrx_rc_unapp.var.factor_discount_amount' ,'NUMBER');
447: fa_rx_util_pkg.assign_column('310','CRH_CURR.ACCTD_FACTOR_DISCOUNT_AMOUNT','ACCTD_FACTOR_DISCOUNT_AMOUNT'
448: ,'arrx_rc_unapp.var.acctd_factor_discount_amount' ,'NUMBER');
449: fa_rx_util_pkg.assign_column('320',CRH_STATUS_DECODE ,'RECEIPT_HISTORY_STATUS'
450: ,'arrx_rc_unapp.var.receipt_history_status' ,'VARCHAR2', 40);
451: fa_rx_util_pkg.assign_column('330','CUST.CUST_ACCOUNT_ID' ,'CUSTOMER_ID'
452: ,'arrx_rc_unapp.var.customer_id' ,'NUMBER');
453: fa_rx_util_pkg.assign_column('340','NVL(SUBSTRB(PARTY.PARTY_NAME,1,50),:L_UNID_CUST)', 'CUSTOMER_NAME'
454: ,'arrx_rc_unapp.var.customer_name' ,'VARCHAR2', 50);
448: ,'arrx_rc_unapp.var.acctd_factor_discount_amount' ,'NUMBER');
449: fa_rx_util_pkg.assign_column('320',CRH_STATUS_DECODE ,'RECEIPT_HISTORY_STATUS'
450: ,'arrx_rc_unapp.var.receipt_history_status' ,'VARCHAR2', 40);
451: fa_rx_util_pkg.assign_column('330','CUST.CUST_ACCOUNT_ID' ,'CUSTOMER_ID'
452: ,'arrx_rc_unapp.var.customer_id' ,'NUMBER');
453: fa_rx_util_pkg.assign_column('340','NVL(SUBSTRB(PARTY.PARTY_NAME,1,50),:L_UNID_CUST)', 'CUSTOMER_NAME'
454: ,'arrx_rc_unapp.var.customer_name' ,'VARCHAR2', 50);
455: fa_rx_util_pkg.assign_column('350','DECODE(PARTY.PARTY_TYPE, ''ORGANIZATION'',PARTY.ORGANIZATION_NAME_PHONETIC, NULL)' ,'CUSTOMER_NAME_ALT'
456: ,'arrx_rc_unapp.var.customer_name_alt' ,'VARCHAR2',320);
450: ,'arrx_rc_unapp.var.receipt_history_status' ,'VARCHAR2', 40);
451: fa_rx_util_pkg.assign_column('330','CUST.CUST_ACCOUNT_ID' ,'CUSTOMER_ID'
452: ,'arrx_rc_unapp.var.customer_id' ,'NUMBER');
453: fa_rx_util_pkg.assign_column('340','NVL(SUBSTRB(PARTY.PARTY_NAME,1,50),:L_UNID_CUST)', 'CUSTOMER_NAME'
454: ,'arrx_rc_unapp.var.customer_name' ,'VARCHAR2', 50);
455: fa_rx_util_pkg.assign_column('350','DECODE(PARTY.PARTY_TYPE, ''ORGANIZATION'',PARTY.ORGANIZATION_NAME_PHONETIC, NULL)' ,'CUSTOMER_NAME_ALT'
456: ,'arrx_rc_unapp.var.customer_name_alt' ,'VARCHAR2',320);
457: fa_rx_util_pkg.assign_column('360','CUST.ACCOUNT_NUMBER' ,'CUSTOMER_NUMBER'
458: ,'arrx_rc_unapp.var.customer_number' ,'VARCHAR2', 30);
452: ,'arrx_rc_unapp.var.customer_id' ,'NUMBER');
453: fa_rx_util_pkg.assign_column('340','NVL(SUBSTRB(PARTY.PARTY_NAME,1,50),:L_UNID_CUST)', 'CUSTOMER_NAME'
454: ,'arrx_rc_unapp.var.customer_name' ,'VARCHAR2', 50);
455: fa_rx_util_pkg.assign_column('350','DECODE(PARTY.PARTY_TYPE, ''ORGANIZATION'',PARTY.ORGANIZATION_NAME_PHONETIC, NULL)' ,'CUSTOMER_NAME_ALT'
456: ,'arrx_rc_unapp.var.customer_name_alt' ,'VARCHAR2',320);
457: fa_rx_util_pkg.assign_column('360','CUST.ACCOUNT_NUMBER' ,'CUSTOMER_NUMBER'
458: ,'arrx_rc_unapp.var.customer_number' ,'VARCHAR2', 30);
459: fa_rx_util_pkg.assign_column('370','BS.NAME' ,'BATCH_SOURCE'
460: ,'arrx_rc_unapp.var.batch_source' ,'VARCHAR2',30);
454: ,'arrx_rc_unapp.var.customer_name' ,'VARCHAR2', 50);
455: fa_rx_util_pkg.assign_column('350','DECODE(PARTY.PARTY_TYPE, ''ORGANIZATION'',PARTY.ORGANIZATION_NAME_PHONETIC, NULL)' ,'CUSTOMER_NAME_ALT'
456: ,'arrx_rc_unapp.var.customer_name_alt' ,'VARCHAR2',320);
457: fa_rx_util_pkg.assign_column('360','CUST.ACCOUNT_NUMBER' ,'CUSTOMER_NUMBER'
458: ,'arrx_rc_unapp.var.customer_number' ,'VARCHAR2', 30);
459: fa_rx_util_pkg.assign_column('370','BS.NAME' ,'BATCH_SOURCE'
460: ,'arrx_rc_unapp.var.batch_source' ,'VARCHAR2',30);
461: fa_rx_util_pkg.assign_column('380',ON_ACC_AMT_DECODE ,'ON_ACCOUNT_AMOUNT'
462: ,'arrx_rc_unapp.var.on_acc_amount' ,'NUMBER');
456: ,'arrx_rc_unapp.var.customer_name_alt' ,'VARCHAR2',320);
457: fa_rx_util_pkg.assign_column('360','CUST.ACCOUNT_NUMBER' ,'CUSTOMER_NUMBER'
458: ,'arrx_rc_unapp.var.customer_number' ,'VARCHAR2', 30);
459: fa_rx_util_pkg.assign_column('370','BS.NAME' ,'BATCH_SOURCE'
460: ,'arrx_rc_unapp.var.batch_source' ,'VARCHAR2',30);
461: fa_rx_util_pkg.assign_column('380',ON_ACC_AMT_DECODE ,'ON_ACCOUNT_AMOUNT'
462: ,'arrx_rc_unapp.var.on_acc_amount' ,'NUMBER');
463: fa_rx_util_pkg.assign_column('390',UNAPP_AMT_DECODE ,'UNAPP_AMOUNT'
464: ,'arrx_rc_unapp.var.unapp_amount' ,'NUMBER');
458: ,'arrx_rc_unapp.var.customer_number' ,'VARCHAR2', 30);
459: fa_rx_util_pkg.assign_column('370','BS.NAME' ,'BATCH_SOURCE'
460: ,'arrx_rc_unapp.var.batch_source' ,'VARCHAR2',30);
461: fa_rx_util_pkg.assign_column('380',ON_ACC_AMT_DECODE ,'ON_ACCOUNT_AMOUNT'
462: ,'arrx_rc_unapp.var.on_acc_amount' ,'NUMBER');
463: fa_rx_util_pkg.assign_column('390',UNAPP_AMT_DECODE ,'UNAPP_AMOUNT'
464: ,'arrx_rc_unapp.var.unapp_amount' ,'NUMBER');
465: fa_rx_util_pkg.assign_column('400',CLAIM_AMT_DECODE ,'CLAIM_AMOUNT'
466: ,'arrx_rc_unapp.var.claim_amount' ,'NUMBER');
460: ,'arrx_rc_unapp.var.batch_source' ,'VARCHAR2',30);
461: fa_rx_util_pkg.assign_column('380',ON_ACC_AMT_DECODE ,'ON_ACCOUNT_AMOUNT'
462: ,'arrx_rc_unapp.var.on_acc_amount' ,'NUMBER');
463: fa_rx_util_pkg.assign_column('390',UNAPP_AMT_DECODE ,'UNAPP_AMOUNT'
464: ,'arrx_rc_unapp.var.unapp_amount' ,'NUMBER');
465: fa_rx_util_pkg.assign_column('400',CLAIM_AMT_DECODE ,'CLAIM_AMOUNT'
466: ,'arrx_rc_unapp.var.claim_amount' ,'NUMBER');
467: fa_rx_util_pkg.assign_column('410',PREPAY_AMT_DECODE ,'PREPAY_AMOUNT'
468: ,'arrx_rc_unapp.var.prepay_amount' ,'NUMBER');
462: ,'arrx_rc_unapp.var.on_acc_amount' ,'NUMBER');
463: fa_rx_util_pkg.assign_column('390',UNAPP_AMT_DECODE ,'UNAPP_AMOUNT'
464: ,'arrx_rc_unapp.var.unapp_amount' ,'NUMBER');
465: fa_rx_util_pkg.assign_column('400',CLAIM_AMT_DECODE ,'CLAIM_AMOUNT'
466: ,'arrx_rc_unapp.var.claim_amount' ,'NUMBER');
467: fa_rx_util_pkg.assign_column('410',PREPAY_AMT_DECODE ,'PREPAY_AMOUNT'
468: ,'arrx_rc_unapp.var.prepay_amount' ,'NUMBER');
469: fa_rx_util_pkg.assign_column('420',TOTAL_UNRESOLVED_AMT_DECODE,'TOTAL_UNRESOLVED_AMOUNT'
470: ,'arrx_rc_unapp.var.total_unresolved_amount' ,'NUMBER');
464: ,'arrx_rc_unapp.var.unapp_amount' ,'NUMBER');
465: fa_rx_util_pkg.assign_column('400',CLAIM_AMT_DECODE ,'CLAIM_AMOUNT'
466: ,'arrx_rc_unapp.var.claim_amount' ,'NUMBER');
467: fa_rx_util_pkg.assign_column('410',PREPAY_AMT_DECODE ,'PREPAY_AMOUNT'
468: ,'arrx_rc_unapp.var.prepay_amount' ,'NUMBER');
469: fa_rx_util_pkg.assign_column('420',TOTAL_UNRESOLVED_AMT_DECODE,'TOTAL_UNRESOLVED_AMOUNT'
470: ,'arrx_rc_unapp.var.total_unresolved_amount' ,'NUMBER');
471: fa_rx_util_pkg.assign_column('430',FORMAT_CURRENCY_DECODE ,'FORMAT_CURRENCY_CODE'
472: ,'arrx_rc_unapp.var.format_currency_code' ,'VARCHAR2',15);
466: ,'arrx_rc_unapp.var.claim_amount' ,'NUMBER');
467: fa_rx_util_pkg.assign_column('410',PREPAY_AMT_DECODE ,'PREPAY_AMOUNT'
468: ,'arrx_rc_unapp.var.prepay_amount' ,'NUMBER');
469: fa_rx_util_pkg.assign_column('420',TOTAL_UNRESOLVED_AMT_DECODE,'TOTAL_UNRESOLVED_AMOUNT'
470: ,'arrx_rc_unapp.var.total_unresolved_amount' ,'NUMBER');
471: fa_rx_util_pkg.assign_column('430',FORMAT_CURRENCY_DECODE ,'FORMAT_CURRENCY_CODE'
472: ,'arrx_rc_unapp.var.format_currency_code' ,'VARCHAR2',15);
473: fa_rx_util_pkg.assign_column('440','MAX(GC.CODE_COMBINATION_ID)' ,'ACCOUNT_CODE_COMBINATION_ID'
474: ,'arrx_rc_unapp.var.account_code_combination_id' ,'NUMBER');
468: ,'arrx_rc_unapp.var.prepay_amount' ,'NUMBER');
469: fa_rx_util_pkg.assign_column('420',TOTAL_UNRESOLVED_AMT_DECODE,'TOTAL_UNRESOLVED_AMOUNT'
470: ,'arrx_rc_unapp.var.total_unresolved_amount' ,'NUMBER');
471: fa_rx_util_pkg.assign_column('430',FORMAT_CURRENCY_DECODE ,'FORMAT_CURRENCY_CODE'
472: ,'arrx_rc_unapp.var.format_currency_code' ,'VARCHAR2',15);
473: fa_rx_util_pkg.assign_column('440','MAX(GC.CODE_COMBINATION_ID)' ,'ACCOUNT_CODE_COMBINATION_ID'
474: ,'arrx_rc_unapp.var.account_code_combination_id' ,'NUMBER');
475: fa_rx_util_pkg.assign_column('450',NULL ,'DEBIT_BALANCING'
476: ,'arrx_rc_unapp.var.debit_balancing' ,'VARCHAR2',240);
470: ,'arrx_rc_unapp.var.total_unresolved_amount' ,'NUMBER');
471: fa_rx_util_pkg.assign_column('430',FORMAT_CURRENCY_DECODE ,'FORMAT_CURRENCY_CODE'
472: ,'arrx_rc_unapp.var.format_currency_code' ,'VARCHAR2',15);
473: fa_rx_util_pkg.assign_column('440','MAX(GC.CODE_COMBINATION_ID)' ,'ACCOUNT_CODE_COMBINATION_ID'
474: ,'arrx_rc_unapp.var.account_code_combination_id' ,'NUMBER');
475: fa_rx_util_pkg.assign_column('450',NULL ,'DEBIT_BALANCING'
476: ,'arrx_rc_unapp.var.debit_balancing' ,'VARCHAR2',240);
477: fa_rx_util_pkg.assign_column('460',APP_AMT_DECODE,'AMOUNT_APPLIED'
478: ,'arrx_rc_unapp.var.app_amount' ,'NUMBER');
472: ,'arrx_rc_unapp.var.format_currency_code' ,'VARCHAR2',15);
473: fa_rx_util_pkg.assign_column('440','MAX(GC.CODE_COMBINATION_ID)' ,'ACCOUNT_CODE_COMBINATION_ID'
474: ,'arrx_rc_unapp.var.account_code_combination_id' ,'NUMBER');
475: fa_rx_util_pkg.assign_column('450',NULL ,'DEBIT_BALANCING'
476: ,'arrx_rc_unapp.var.debit_balancing' ,'VARCHAR2',240);
477: fa_rx_util_pkg.assign_column('460',APP_AMT_DECODE,'AMOUNT_APPLIED'
478: ,'arrx_rc_unapp.var.app_amount' ,'NUMBER');
479:
480:
474: ,'arrx_rc_unapp.var.account_code_combination_id' ,'NUMBER');
475: fa_rx_util_pkg.assign_column('450',NULL ,'DEBIT_BALANCING'
476: ,'arrx_rc_unapp.var.debit_balancing' ,'VARCHAR2',240);
477: fa_rx_util_pkg.assign_column('460',APP_AMT_DECODE,'AMOUNT_APPLIED'
478: ,'arrx_rc_unapp.var.app_amount' ,'NUMBER');
479:
480:
481: /* Assign the From Clause */
482: fa_rx_util_pkg.debug(' Assigning the FROM CLAUSE');
607: OR ' || PREPAY_AMT_DECODE||' <> 0 ';
608:
609:
610:
611: fa_rx_util_pkg.debug('arrx_rc_unapp.before_report()-');
612:
613:
614: END before_report;
615:
626: l_unapp VARCHAR2(80);
627: l_unid VARCHAR2(80);
628: l_unid_cust VARCHAR2(80);
629: begin
630: fa_rx_util_pkg.debug('arrx_rc_unapp.bind()+');
631:
632: IF var.p_gl_date_from IS NOT NULL THEN
633: dbms_sql.bind_variable(c, 'p_gl_date_from', var.p_gl_date_from);
634: END IF;
712: dbms_sql.bind_variable(c, 'L_CONFIRMED' , L_CONFIRMED);
713: dbms_sql.bind_variable(c, 'L_REMITTED' , L_REMITTED);
714: dbms_sql.bind_variable(c, 'L_REVERSED' , L_REVERSED);
715:
716: fa_rx_util_pkg.debug('arrx_rc_unapp.bind()-');
717:
718: END bind;
719: PROCEDURE after_fetch IS
720: begin
717:
718: END bind;
719: PROCEDURE after_fetch IS
720: begin
721: fa_rx_util_pkg.debug('arrx_rc_unapp.after_fetch()+');
722:
723: var.debit_balancing := fa_rx_flex_pkg.get_value(
724: p_application_id => 101,
725: p_id_flex_code => 'GL#',
728: p_ccid => var.account_code_combination_id);
729:
730:
731:
732: fa_rx_util_pkg.debug('arrx_rc_unapp.after_fetch()-');
733: end after_fetch;
734:
735: END ARRX_RC_UNAPP;
731:
732: fa_rx_util_pkg.debug('arrx_rc_unapp.after_fetch()-');
733: end after_fetch;
734:
735: END ARRX_RC_UNAPP;