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 dependencies on ARRX_RC

Line 1: PACKAGE BODY ARRX_RC as

1: PACKAGE BODY ARRX_RC as
2: /* $Header: ARRXRCB.pls 120.44.12020000.2 2012/09/05 06:13:30 riqi ship $ */
3:
4: -- create generic procedure to reset to NULL all var type variables
5: procedure init_var is

Line 135: fa_rx_util_pkg.debug('arrx_rc.before_report()+');

131: tag number; /* bug 5724171*/
132:
133:
134: begin
135: fa_rx_util_pkg.debug('arrx_rc.before_report()+');
136:
137: -- define common lexical params and assign_column
138:
139: fa_rx_util_pkg.debug('Get SOB ID'||var.books_id);

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

378: fa_rx_util_pkg.debug('Start Assign_columns');
379: -- fa_rx_util_pkg.assign_column(unique seq#, select field, field in itf, into variable, type, len);
380:
381: fa_rx_util_pkg.assign_column('10 ',null ,'ORGANIZATION_NAME' ,
382: 'arrx_rc.var.organization_name' ,'VARCHAR2', 50);
383: fa_rx_util_pkg.assign_column('20 ',null ,'FUNCTIONAL_CURRENCY_CODE' ,
384: 'arrx_rc.var.functional_currency_code' ,'VARCHAR2', 15);
385: fa_rx_util_pkg.assign_column('30 ','CR.STATUS' ,null ,
386: 'arrx_rc.var.cr_status' ,'VARCHAR2', 40);

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

380:
381: fa_rx_util_pkg.assign_column('10 ',null ,'ORGANIZATION_NAME' ,
382: 'arrx_rc.var.organization_name' ,'VARCHAR2', 50);
383: fa_rx_util_pkg.assign_column('20 ',null ,'FUNCTIONAL_CURRENCY_CODE' ,
384: 'arrx_rc.var.functional_currency_code' ,'VARCHAR2', 15);
385: fa_rx_util_pkg.assign_column('30 ','CR.STATUS' ,null ,
386: 'arrx_rc.var.cr_status' ,'VARCHAR2', 40);
387: fa_rx_util_pkg.assign_column('40 ','CRH.STATUS' ,null ,
388: 'arrx_rc.var.crh_status' ,'VARCHAR2', 40);

Line 386: 'arrx_rc.var.cr_status' ,'VARCHAR2', 40);

382: 'arrx_rc.var.organization_name' ,'VARCHAR2', 50);
383: fa_rx_util_pkg.assign_column('20 ',null ,'FUNCTIONAL_CURRENCY_CODE' ,
384: 'arrx_rc.var.functional_currency_code' ,'VARCHAR2', 15);
385: fa_rx_util_pkg.assign_column('30 ','CR.STATUS' ,null ,
386: 'arrx_rc.var.cr_status' ,'VARCHAR2', 40);
387: fa_rx_util_pkg.assign_column('40 ','CRH.STATUS' ,null ,
388: 'arrx_rc.var.crh_status' ,'VARCHAR2', 40);
389: fa_rx_util_pkg.assign_column('50 ','DECODE(CRH.STATUS, ''REVERSED'', BATCHFIRST.BATCH_ID, BATCH.BATCH_ID)','BATCH_ID' ,
390: 'arrx_rc.var.batch_id' ,'NUMBER');

Line 388: 'arrx_rc.var.crh_status' ,'VARCHAR2', 40);

384: 'arrx_rc.var.functional_currency_code' ,'VARCHAR2', 15);
385: fa_rx_util_pkg.assign_column('30 ','CR.STATUS' ,null ,
386: 'arrx_rc.var.cr_status' ,'VARCHAR2', 40);
387: fa_rx_util_pkg.assign_column('40 ','CRH.STATUS' ,null ,
388: 'arrx_rc.var.crh_status' ,'VARCHAR2', 40);
389: fa_rx_util_pkg.assign_column('50 ','DECODE(CRH.STATUS, ''REVERSED'', BATCHFIRST.BATCH_ID, BATCH.BATCH_ID)','BATCH_ID' ,
390: 'arrx_rc.var.batch_id' ,'NUMBER');
391: fa_rx_util_pkg.assign_column('60 ','DECODE(CRH.STATUS, ''REVERSED'', BATCHFIRST.NAME, BATCH.NAME)','BATCH_NAME' ,
392: 'arrx_rc.var.batch_name' ,'VARCHAR2', 20);

Line 390: 'arrx_rc.var.batch_id' ,'NUMBER');

386: 'arrx_rc.var.cr_status' ,'VARCHAR2', 40);
387: fa_rx_util_pkg.assign_column('40 ','CRH.STATUS' ,null ,
388: 'arrx_rc.var.crh_status' ,'VARCHAR2', 40);
389: fa_rx_util_pkg.assign_column('50 ','DECODE(CRH.STATUS, ''REVERSED'', BATCHFIRST.BATCH_ID, BATCH.BATCH_ID)','BATCH_ID' ,
390: 'arrx_rc.var.batch_id' ,'NUMBER');
391: fa_rx_util_pkg.assign_column('60 ','DECODE(CRH.STATUS, ''REVERSED'', BATCHFIRST.NAME, BATCH.NAME)','BATCH_NAME' ,
392: 'arrx_rc.var.batch_name' ,'VARCHAR2', 20);
393: fa_rx_util_pkg.assign_column('70 ','CR.CASH_RECEIPT_ID' ,'CASH_RECEIPT_ID' ,
394: 'arrx_rc.var.cash_receipt_id' ,'NUMBER');

Line 392: 'arrx_rc.var.batch_name' ,'VARCHAR2', 20);

388: 'arrx_rc.var.crh_status' ,'VARCHAR2', 40);
389: fa_rx_util_pkg.assign_column('50 ','DECODE(CRH.STATUS, ''REVERSED'', BATCHFIRST.BATCH_ID, BATCH.BATCH_ID)','BATCH_ID' ,
390: 'arrx_rc.var.batch_id' ,'NUMBER');
391: fa_rx_util_pkg.assign_column('60 ','DECODE(CRH.STATUS, ''REVERSED'', BATCHFIRST.NAME, BATCH.NAME)','BATCH_NAME' ,
392: 'arrx_rc.var.batch_name' ,'VARCHAR2', 20);
393: fa_rx_util_pkg.assign_column('70 ','CR.CASH_RECEIPT_ID' ,'CASH_RECEIPT_ID' ,
394: 'arrx_rc.var.cash_receipt_id' ,'NUMBER');
395: fa_rx_util_pkg.assign_column('80 ','CR.RECEIPT_NUMBER' ,'RECEIPT_NUMBER' ,
396: 'arrx_rc.var.receipt_number' ,'VARCHAR2', 30);

Line 394: 'arrx_rc.var.cash_receipt_id' ,'NUMBER');

390: 'arrx_rc.var.batch_id' ,'NUMBER');
391: fa_rx_util_pkg.assign_column('60 ','DECODE(CRH.STATUS, ''REVERSED'', BATCHFIRST.NAME, BATCH.NAME)','BATCH_NAME' ,
392: 'arrx_rc.var.batch_name' ,'VARCHAR2', 20);
393: fa_rx_util_pkg.assign_column('70 ','CR.CASH_RECEIPT_ID' ,'CASH_RECEIPT_ID' ,
394: 'arrx_rc.var.cash_receipt_id' ,'NUMBER');
395: fa_rx_util_pkg.assign_column('80 ','CR.RECEIPT_NUMBER' ,'RECEIPT_NUMBER' ,
396: 'arrx_rc.var.receipt_number' ,'VARCHAR2', 30);
397: fa_rx_util_pkg.assign_column('90 ','CR.CURRENCY_CODE' ,'RECEIPT_CURRENCY_CODE' ,
398: 'arrx_rc.var.receipt_currency_code' ,'VARCHAR2', 15);

Line 396: 'arrx_rc.var.receipt_number' ,'VARCHAR2', 30);

392: 'arrx_rc.var.batch_name' ,'VARCHAR2', 20);
393: fa_rx_util_pkg.assign_column('70 ','CR.CASH_RECEIPT_ID' ,'CASH_RECEIPT_ID' ,
394: 'arrx_rc.var.cash_receipt_id' ,'NUMBER');
395: fa_rx_util_pkg.assign_column('80 ','CR.RECEIPT_NUMBER' ,'RECEIPT_NUMBER' ,
396: 'arrx_rc.var.receipt_number' ,'VARCHAR2', 30);
397: fa_rx_util_pkg.assign_column('90 ','CR.CURRENCY_CODE' ,'RECEIPT_CURRENCY_CODE' ,
398: 'arrx_rc.var.receipt_currency_code' ,'VARCHAR2', 15);
399: fa_rx_util_pkg.assign_column('100','CR.EXCHANGE_RATE' ,'EXCHANGE_RATE' ,
400: 'arrx_rc.var.exchange_rate' ,'NUMBER');

Line 398: 'arrx_rc.var.receipt_currency_code' ,'VARCHAR2', 15);

394: 'arrx_rc.var.cash_receipt_id' ,'NUMBER');
395: fa_rx_util_pkg.assign_column('80 ','CR.RECEIPT_NUMBER' ,'RECEIPT_NUMBER' ,
396: 'arrx_rc.var.receipt_number' ,'VARCHAR2', 30);
397: fa_rx_util_pkg.assign_column('90 ','CR.CURRENCY_CODE' ,'RECEIPT_CURRENCY_CODE' ,
398: 'arrx_rc.var.receipt_currency_code' ,'VARCHAR2', 15);
399: fa_rx_util_pkg.assign_column('100','CR.EXCHANGE_RATE' ,'EXCHANGE_RATE' ,
400: 'arrx_rc.var.exchange_rate' ,'NUMBER');
401: fa_rx_util_pkg.assign_column('110','CR.EXCHANGE_DATE' ,'EXCHANGE_DATE' ,
402: 'arrx_rc.var.exchange_date' ,'DATE');

Line 400: 'arrx_rc.var.exchange_rate' ,'NUMBER');

396: 'arrx_rc.var.receipt_number' ,'VARCHAR2', 30);
397: fa_rx_util_pkg.assign_column('90 ','CR.CURRENCY_CODE' ,'RECEIPT_CURRENCY_CODE' ,
398: 'arrx_rc.var.receipt_currency_code' ,'VARCHAR2', 15);
399: fa_rx_util_pkg.assign_column('100','CR.EXCHANGE_RATE' ,'EXCHANGE_RATE' ,
400: 'arrx_rc.var.exchange_rate' ,'NUMBER');
401: fa_rx_util_pkg.assign_column('110','CR.EXCHANGE_DATE' ,'EXCHANGE_DATE' ,
402: 'arrx_rc.var.exchange_date' ,'DATE');
403: fa_rx_util_pkg.assign_column('120','CR.EXCHANGE_RATE_TYPE' ,'EXCHANGE_TYPE' ,
404: 'arrx_rc.var.exchange_type' ,'VARCHAR2', 30);

Line 402: 'arrx_rc.var.exchange_date' ,'DATE');

398: 'arrx_rc.var.receipt_currency_code' ,'VARCHAR2', 15);
399: fa_rx_util_pkg.assign_column('100','CR.EXCHANGE_RATE' ,'EXCHANGE_RATE' ,
400: 'arrx_rc.var.exchange_rate' ,'NUMBER');
401: fa_rx_util_pkg.assign_column('110','CR.EXCHANGE_DATE' ,'EXCHANGE_DATE' ,
402: 'arrx_rc.var.exchange_date' ,'DATE');
403: fa_rx_util_pkg.assign_column('120','CR.EXCHANGE_RATE_TYPE' ,'EXCHANGE_TYPE' ,
404: 'arrx_rc.var.exchange_type' ,'VARCHAR2', 30);
405: fa_rx_util_pkg.assign_column('130','DOCSEQ.NAME' ,'DOC_SEQUENCE_NAME' ,
406: 'arrx_rc.var.doc_sequence_name' ,'VARCHAR2', 30);

Line 404: 'arrx_rc.var.exchange_type' ,'VARCHAR2', 30);

400: 'arrx_rc.var.exchange_rate' ,'NUMBER');
401: fa_rx_util_pkg.assign_column('110','CR.EXCHANGE_DATE' ,'EXCHANGE_DATE' ,
402: 'arrx_rc.var.exchange_date' ,'DATE');
403: fa_rx_util_pkg.assign_column('120','CR.EXCHANGE_RATE_TYPE' ,'EXCHANGE_TYPE' ,
404: 'arrx_rc.var.exchange_type' ,'VARCHAR2', 30);
405: fa_rx_util_pkg.assign_column('130','DOCSEQ.NAME' ,'DOC_SEQUENCE_NAME' ,
406: 'arrx_rc.var.doc_sequence_name' ,'VARCHAR2', 30);
407: fa_rx_util_pkg.assign_column('140','CR.DOC_SEQUENCE_VALUE' ,'DOC_SEQUENCE_VALUE' ,
408: 'arrx_rc.var.doc_sequence_value' ,'NUMBER');

Line 406: 'arrx_rc.var.doc_sequence_name' ,'VARCHAR2', 30);

402: 'arrx_rc.var.exchange_date' ,'DATE');
403: fa_rx_util_pkg.assign_column('120','CR.EXCHANGE_RATE_TYPE' ,'EXCHANGE_TYPE' ,
404: 'arrx_rc.var.exchange_type' ,'VARCHAR2', 30);
405: fa_rx_util_pkg.assign_column('130','DOCSEQ.NAME' ,'DOC_SEQUENCE_NAME' ,
406: 'arrx_rc.var.doc_sequence_name' ,'VARCHAR2', 30);
407: fa_rx_util_pkg.assign_column('140','CR.DOC_SEQUENCE_VALUE' ,'DOC_SEQUENCE_VALUE' ,
408: 'arrx_rc.var.doc_sequence_value' ,'NUMBER');
409: fa_rx_util_pkg.assign_column('150','CR.DEPOSIT_DATE' ,'DEPOSIT_DATE' ,
410: 'arrx_rc.var.deposit_date' ,'DATE');

Line 408: 'arrx_rc.var.doc_sequence_value' ,'NUMBER');

404: 'arrx_rc.var.exchange_type' ,'VARCHAR2', 30);
405: fa_rx_util_pkg.assign_column('130','DOCSEQ.NAME' ,'DOC_SEQUENCE_NAME' ,
406: 'arrx_rc.var.doc_sequence_name' ,'VARCHAR2', 30);
407: fa_rx_util_pkg.assign_column('140','CR.DOC_SEQUENCE_VALUE' ,'DOC_SEQUENCE_VALUE' ,
408: 'arrx_rc.var.doc_sequence_value' ,'NUMBER');
409: fa_rx_util_pkg.assign_column('150','CR.DEPOSIT_DATE' ,'DEPOSIT_DATE' ,
410: 'arrx_rc.var.deposit_date' ,'DATE');
411: fa_rx_util_pkg.assign_column('160','CR.RECEIPT_DATE' ,'RECEIPT_DATE' ,
412: 'arrx_rc.var.receipt_date' ,'DATE');

Line 410: 'arrx_rc.var.deposit_date' ,'DATE');

406: 'arrx_rc.var.doc_sequence_name' ,'VARCHAR2', 30);
407: fa_rx_util_pkg.assign_column('140','CR.DOC_SEQUENCE_VALUE' ,'DOC_SEQUENCE_VALUE' ,
408: 'arrx_rc.var.doc_sequence_value' ,'NUMBER');
409: fa_rx_util_pkg.assign_column('150','CR.DEPOSIT_DATE' ,'DEPOSIT_DATE' ,
410: 'arrx_rc.var.deposit_date' ,'DATE');
411: fa_rx_util_pkg.assign_column('160','CR.RECEIPT_DATE' ,'RECEIPT_DATE' ,
412: 'arrx_rc.var.receipt_date' ,'DATE');
413: fa_rx_util_pkg.assign_column('170',DECODE_CR_TYPE ,'RECEIPT_TYPE' ,
414: 'arrx_rc.var.receipt_type' ,'VARCHAR2', 30);

Line 412: 'arrx_rc.var.receipt_date' ,'DATE');

408: 'arrx_rc.var.doc_sequence_value' ,'NUMBER');
409: fa_rx_util_pkg.assign_column('150','CR.DEPOSIT_DATE' ,'DEPOSIT_DATE' ,
410: 'arrx_rc.var.deposit_date' ,'DATE');
411: fa_rx_util_pkg.assign_column('160','CR.RECEIPT_DATE' ,'RECEIPT_DATE' ,
412: 'arrx_rc.var.receipt_date' ,'DATE');
413: fa_rx_util_pkg.assign_column('170',DECODE_CR_TYPE ,'RECEIPT_TYPE' ,
414: 'arrx_rc.var.receipt_type' ,'VARCHAR2', 30);
415: fa_rx_util_pkg.assign_column('180',DECODE_CR_STATUS ,'RECEIPT_STATUS' ,
416: 'arrx_rc.var.receipt_status' ,'VARCHAR2', 40);

Line 414: 'arrx_rc.var.receipt_type' ,'VARCHAR2', 30);

410: 'arrx_rc.var.deposit_date' ,'DATE');
411: fa_rx_util_pkg.assign_column('160','CR.RECEIPT_DATE' ,'RECEIPT_DATE' ,
412: 'arrx_rc.var.receipt_date' ,'DATE');
413: fa_rx_util_pkg.assign_column('170',DECODE_CR_TYPE ,'RECEIPT_TYPE' ,
414: 'arrx_rc.var.receipt_type' ,'VARCHAR2', 30);
415: fa_rx_util_pkg.assign_column('180',DECODE_CR_STATUS ,'RECEIPT_STATUS' ,
416: 'arrx_rc.var.receipt_status' ,'VARCHAR2', 40);
417: fa_rx_util_pkg.assign_column('190','CR.MISC_PAYMENT_SOURCE' ,'MISC_PAYMENT_SOURCE' ,
418: 'arrx_rc.var.misc_payment_source' ,'VARCHAR2', 30);

Line 416: 'arrx_rc.var.receipt_status' ,'VARCHAR2', 40);

412: 'arrx_rc.var.receipt_date' ,'DATE');
413: fa_rx_util_pkg.assign_column('170',DECODE_CR_TYPE ,'RECEIPT_TYPE' ,
414: 'arrx_rc.var.receipt_type' ,'VARCHAR2', 30);
415: fa_rx_util_pkg.assign_column('180',DECODE_CR_STATUS ,'RECEIPT_STATUS' ,
416: 'arrx_rc.var.receipt_status' ,'VARCHAR2', 40);
417: fa_rx_util_pkg.assign_column('190','CR.MISC_PAYMENT_SOURCE' ,'MISC_PAYMENT_SOURCE' ,
418: 'arrx_rc.var.misc_payment_source' ,'VARCHAR2', 30);
419: fa_rx_util_pkg.assign_column('200','TAX.TAX_CODE' ,'TAX_CODE' ,
420: 'arrx_rc.var.tax_code' ,'VARCHAR2', 50);

Line 418: 'arrx_rc.var.misc_payment_source' ,'VARCHAR2', 30);

414: 'arrx_rc.var.receipt_type' ,'VARCHAR2', 30);
415: fa_rx_util_pkg.assign_column('180',DECODE_CR_STATUS ,'RECEIPT_STATUS' ,
416: 'arrx_rc.var.receipt_status' ,'VARCHAR2', 40);
417: fa_rx_util_pkg.assign_column('190','CR.MISC_PAYMENT_SOURCE' ,'MISC_PAYMENT_SOURCE' ,
418: 'arrx_rc.var.misc_payment_source' ,'VARCHAR2', 30);
419: fa_rx_util_pkg.assign_column('200','TAX.TAX_CODE' ,'TAX_CODE' ,
420: 'arrx_rc.var.tax_code' ,'VARCHAR2', 50);
421: fa_rx_util_pkg.assign_column('210',DECODE_CR_REFERENCE_TYPE ,'REFERENCE_TYPE' ,
422: 'arrx_rc.var.reference_type' ,'VARCHAR2', 30);

Line 420: 'arrx_rc.var.tax_code' ,'VARCHAR2', 50);

416: 'arrx_rc.var.receipt_status' ,'VARCHAR2', 40);
417: fa_rx_util_pkg.assign_column('190','CR.MISC_PAYMENT_SOURCE' ,'MISC_PAYMENT_SOURCE' ,
418: 'arrx_rc.var.misc_payment_source' ,'VARCHAR2', 30);
419: fa_rx_util_pkg.assign_column('200','TAX.TAX_CODE' ,'TAX_CODE' ,
420: 'arrx_rc.var.tax_code' ,'VARCHAR2', 50);
421: fa_rx_util_pkg.assign_column('210',DECODE_CR_REFERENCE_TYPE ,'REFERENCE_TYPE' ,
422: 'arrx_rc.var.reference_type' ,'VARCHAR2', 30);
423: fa_rx_util_pkg.assign_column('220','CR.ANTICIPATED_CLEARING_DATE' ,'ANTICIPATED_CLEARING_DATE' ,
424: 'arrx_rc.var.anticipated_clearing_date' ,'DATE');

Line 422: 'arrx_rc.var.reference_type' ,'VARCHAR2', 30);

418: 'arrx_rc.var.misc_payment_source' ,'VARCHAR2', 30);
419: fa_rx_util_pkg.assign_column('200','TAX.TAX_CODE' ,'TAX_CODE' ,
420: 'arrx_rc.var.tax_code' ,'VARCHAR2', 50);
421: fa_rx_util_pkg.assign_column('210',DECODE_CR_REFERENCE_TYPE ,'REFERENCE_TYPE' ,
422: 'arrx_rc.var.reference_type' ,'VARCHAR2', 30);
423: fa_rx_util_pkg.assign_column('220','CR.ANTICIPATED_CLEARING_DATE' ,'ANTICIPATED_CLEARING_DATE' ,
424: 'arrx_rc.var.anticipated_clearing_date' ,'DATE');
425: fa_rx_util_pkg.assign_column('230','ABB.BANK_NAME' ,'BANK_NAME' ,
426: 'arrx_rc.var.bank_name' ,'VARCHAR2', 60);

Line 424: 'arrx_rc.var.anticipated_clearing_date' ,'DATE');

420: 'arrx_rc.var.tax_code' ,'VARCHAR2', 50);
421: fa_rx_util_pkg.assign_column('210',DECODE_CR_REFERENCE_TYPE ,'REFERENCE_TYPE' ,
422: 'arrx_rc.var.reference_type' ,'VARCHAR2', 30);
423: fa_rx_util_pkg.assign_column('220','CR.ANTICIPATED_CLEARING_DATE' ,'ANTICIPATED_CLEARING_DATE' ,
424: 'arrx_rc.var.anticipated_clearing_date' ,'DATE');
425: fa_rx_util_pkg.assign_column('230','ABB.BANK_NAME' ,'BANK_NAME' ,
426: 'arrx_rc.var.bank_name' ,'VARCHAR2', 60);
427: fa_rx_util_pkg.assign_column('240','ABB.BANK_NAME_ALT' ,'BANK_NAME_ALT' ,
428: 'arrx_rc.var.bank_name_alt' ,'VARCHAR2',320);

Line 426: 'arrx_rc.var.bank_name' ,'VARCHAR2', 60);

422: 'arrx_rc.var.reference_type' ,'VARCHAR2', 30);
423: fa_rx_util_pkg.assign_column('220','CR.ANTICIPATED_CLEARING_DATE' ,'ANTICIPATED_CLEARING_DATE' ,
424: 'arrx_rc.var.anticipated_clearing_date' ,'DATE');
425: fa_rx_util_pkg.assign_column('230','ABB.BANK_NAME' ,'BANK_NAME' ,
426: 'arrx_rc.var.bank_name' ,'VARCHAR2', 60);
427: fa_rx_util_pkg.assign_column('240','ABB.BANK_NAME_ALT' ,'BANK_NAME_ALT' ,
428: 'arrx_rc.var.bank_name_alt' ,'VARCHAR2',320);
429: fa_rx_util_pkg.assign_column('250','ABB.BANK_BRANCH_NAME' ,'BANK_BRANCH_NAME' ,
430: 'arrx_rc.var.bank_branch_name' ,'VARCHAR2', 60);

Line 428: 'arrx_rc.var.bank_name_alt' ,'VARCHAR2',320);

424: 'arrx_rc.var.anticipated_clearing_date' ,'DATE');
425: fa_rx_util_pkg.assign_column('230','ABB.BANK_NAME' ,'BANK_NAME' ,
426: 'arrx_rc.var.bank_name' ,'VARCHAR2', 60);
427: fa_rx_util_pkg.assign_column('240','ABB.BANK_NAME_ALT' ,'BANK_NAME_ALT' ,
428: 'arrx_rc.var.bank_name_alt' ,'VARCHAR2',320);
429: fa_rx_util_pkg.assign_column('250','ABB.BANK_BRANCH_NAME' ,'BANK_BRANCH_NAME' ,
430: 'arrx_rc.var.bank_branch_name' ,'VARCHAR2', 60);
431: fa_rx_util_pkg.assign_column('260','ABB.BANK_BRANCH_NAME_ALT' ,'BANK_BRANCH_NAME_ALT' ,
432: 'arrx_rc.var.bank_branch_name_alt' ,'VARCHAR2',320);

Line 430: 'arrx_rc.var.bank_branch_name' ,'VARCHAR2', 60);

426: 'arrx_rc.var.bank_name' ,'VARCHAR2', 60);
427: fa_rx_util_pkg.assign_column('240','ABB.BANK_NAME_ALT' ,'BANK_NAME_ALT' ,
428: 'arrx_rc.var.bank_name_alt' ,'VARCHAR2',320);
429: fa_rx_util_pkg.assign_column('250','ABB.BANK_BRANCH_NAME' ,'BANK_BRANCH_NAME' ,
430: 'arrx_rc.var.bank_branch_name' ,'VARCHAR2', 60);
431: fa_rx_util_pkg.assign_column('260','ABB.BANK_BRANCH_NAME_ALT' ,'BANK_BRANCH_NAME_ALT' ,
432: 'arrx_rc.var.bank_branch_name_alt' ,'VARCHAR2',320);
433: fa_rx_util_pkg.assign_column('270','ABB.BANK_NUMBER' ,'BANK_NUMBER' ,
434: 'arrx_rc.var.bank_number' ,'VARCHAR2', 30);

Line 432: 'arrx_rc.var.bank_branch_name_alt' ,'VARCHAR2',320);

428: 'arrx_rc.var.bank_name_alt' ,'VARCHAR2',320);
429: fa_rx_util_pkg.assign_column('250','ABB.BANK_BRANCH_NAME' ,'BANK_BRANCH_NAME' ,
430: 'arrx_rc.var.bank_branch_name' ,'VARCHAR2', 60);
431: fa_rx_util_pkg.assign_column('260','ABB.BANK_BRANCH_NAME_ALT' ,'BANK_BRANCH_NAME_ALT' ,
432: 'arrx_rc.var.bank_branch_name_alt' ,'VARCHAR2',320);
433: fa_rx_util_pkg.assign_column('270','ABB.BANK_NUMBER' ,'BANK_NUMBER' ,
434: 'arrx_rc.var.bank_number' ,'VARCHAR2', 30);
435: fa_rx_util_pkg.assign_column('280','ABB.BRANCH_NUMBER' ,'BANK_BRANCH_NUMBER' ,
436: 'arrx_rc.var.bank_branch_number' ,'VARCHAR2', 25);

Line 434: 'arrx_rc.var.bank_number' ,'VARCHAR2', 30);

430: 'arrx_rc.var.bank_branch_name' ,'VARCHAR2', 60);
431: fa_rx_util_pkg.assign_column('260','ABB.BANK_BRANCH_NAME_ALT' ,'BANK_BRANCH_NAME_ALT' ,
432: 'arrx_rc.var.bank_branch_name_alt' ,'VARCHAR2',320);
433: fa_rx_util_pkg.assign_column('270','ABB.BANK_NUMBER' ,'BANK_NUMBER' ,
434: 'arrx_rc.var.bank_number' ,'VARCHAR2', 30);
435: fa_rx_util_pkg.assign_column('280','ABB.BRANCH_NUMBER' ,'BANK_BRANCH_NUMBER' ,
436: 'arrx_rc.var.bank_branch_number' ,'VARCHAR2', 25);
437: fa_rx_util_pkg.assign_column('290','CBA.BANK_ACCOUNT_NAME' ,'BANK_ACCOUNT_NAME' ,
438: 'arrx_rc.var.bank_account_name' ,'VARCHAR2', 80);

Line 436: 'arrx_rc.var.bank_branch_number' ,'VARCHAR2', 25);

432: 'arrx_rc.var.bank_branch_name_alt' ,'VARCHAR2',320);
433: fa_rx_util_pkg.assign_column('270','ABB.BANK_NUMBER' ,'BANK_NUMBER' ,
434: 'arrx_rc.var.bank_number' ,'VARCHAR2', 30);
435: fa_rx_util_pkg.assign_column('280','ABB.BRANCH_NUMBER' ,'BANK_BRANCH_NUMBER' ,
436: 'arrx_rc.var.bank_branch_number' ,'VARCHAR2', 25);
437: fa_rx_util_pkg.assign_column('290','CBA.BANK_ACCOUNT_NAME' ,'BANK_ACCOUNT_NAME' ,
438: 'arrx_rc.var.bank_account_name' ,'VARCHAR2', 80);
439: fa_rx_util_pkg.assign_column('300','CBA.BANK_ACCOUNT_NAME_ALT' ,'BANK_ACCOUNT_NAME_ALT' ,
440: 'arrx_rc.var.bank_account_name_alt' ,'VARCHAR2',320);

Line 438: 'arrx_rc.var.bank_account_name' ,'VARCHAR2', 80);

434: 'arrx_rc.var.bank_number' ,'VARCHAR2', 30);
435: fa_rx_util_pkg.assign_column('280','ABB.BRANCH_NUMBER' ,'BANK_BRANCH_NUMBER' ,
436: 'arrx_rc.var.bank_branch_number' ,'VARCHAR2', 25);
437: fa_rx_util_pkg.assign_column('290','CBA.BANK_ACCOUNT_NAME' ,'BANK_ACCOUNT_NAME' ,
438: 'arrx_rc.var.bank_account_name' ,'VARCHAR2', 80);
439: fa_rx_util_pkg.assign_column('300','CBA.BANK_ACCOUNT_NAME_ALT' ,'BANK_ACCOUNT_NAME_ALT' ,
440: 'arrx_rc.var.bank_account_name_alt' ,'VARCHAR2',320);
441: fa_rx_util_pkg.assign_column('310','CBA.CURRENCY_CODE' ,'BANK_ACCOUNT_CURRENCY' ,
442: 'arrx_rc.var.bank_account_currency' ,'VARCHAR2', 15);

Line 440: 'arrx_rc.var.bank_account_name_alt' ,'VARCHAR2',320);

436: 'arrx_rc.var.bank_branch_number' ,'VARCHAR2', 25);
437: fa_rx_util_pkg.assign_column('290','CBA.BANK_ACCOUNT_NAME' ,'BANK_ACCOUNT_NAME' ,
438: 'arrx_rc.var.bank_account_name' ,'VARCHAR2', 80);
439: fa_rx_util_pkg.assign_column('300','CBA.BANK_ACCOUNT_NAME_ALT' ,'BANK_ACCOUNT_NAME_ALT' ,
440: 'arrx_rc.var.bank_account_name_alt' ,'VARCHAR2',320);
441: fa_rx_util_pkg.assign_column('310','CBA.CURRENCY_CODE' ,'BANK_ACCOUNT_CURRENCY' ,
442: 'arrx_rc.var.bank_account_currency' ,'VARCHAR2', 15);
443: fa_rx_util_pkg.assign_column('320','ARM.NAME' ,'RECEIPT_METHOD' ,
444: 'arrx_rc.var.receipt_method' ,'VARCHAR2', 30);

Line 442: 'arrx_rc.var.bank_account_currency' ,'VARCHAR2', 15);

438: 'arrx_rc.var.bank_account_name' ,'VARCHAR2', 80);
439: fa_rx_util_pkg.assign_column('300','CBA.BANK_ACCOUNT_NAME_ALT' ,'BANK_ACCOUNT_NAME_ALT' ,
440: 'arrx_rc.var.bank_account_name_alt' ,'VARCHAR2',320);
441: fa_rx_util_pkg.assign_column('310','CBA.CURRENCY_CODE' ,'BANK_ACCOUNT_CURRENCY' ,
442: 'arrx_rc.var.bank_account_currency' ,'VARCHAR2', 15);
443: fa_rx_util_pkg.assign_column('320','ARM.NAME' ,'RECEIPT_METHOD' ,
444: 'arrx_rc.var.receipt_method' ,'VARCHAR2', 30);
445: fa_rx_util_pkg.assign_column('330','CRH.CASH_RECEIPT_HISTORY_ID' ,'CASH_RECEIPT_HISTORY_ID' ,
446: 'arrx_rc.var.cash_receipt_history_id' ,'NUMBER');

Line 444: 'arrx_rc.var.receipt_method' ,'VARCHAR2', 30);

440: 'arrx_rc.var.bank_account_name_alt' ,'VARCHAR2',320);
441: fa_rx_util_pkg.assign_column('310','CBA.CURRENCY_CODE' ,'BANK_ACCOUNT_CURRENCY' ,
442: 'arrx_rc.var.bank_account_currency' ,'VARCHAR2', 15);
443: fa_rx_util_pkg.assign_column('320','ARM.NAME' ,'RECEIPT_METHOD' ,
444: 'arrx_rc.var.receipt_method' ,'VARCHAR2', 30);
445: fa_rx_util_pkg.assign_column('330','CRH.CASH_RECEIPT_HISTORY_ID' ,'CASH_RECEIPT_HISTORY_ID' ,
446: 'arrx_rc.var.cash_receipt_history_id' ,'NUMBER');
447: fa_rx_util_pkg.assign_column('340','CRH.GL_DATE' ,'GL_DATE' ,
448: 'arrx_rc.var.gl_date' ,'DATE');

Line 446: 'arrx_rc.var.cash_receipt_history_id' ,'NUMBER');

442: 'arrx_rc.var.bank_account_currency' ,'VARCHAR2', 15);
443: fa_rx_util_pkg.assign_column('320','ARM.NAME' ,'RECEIPT_METHOD' ,
444: 'arrx_rc.var.receipt_method' ,'VARCHAR2', 30);
445: fa_rx_util_pkg.assign_column('330','CRH.CASH_RECEIPT_HISTORY_ID' ,'CASH_RECEIPT_HISTORY_ID' ,
446: 'arrx_rc.var.cash_receipt_history_id' ,'NUMBER');
447: fa_rx_util_pkg.assign_column('340','CRH.GL_DATE' ,'GL_DATE' ,
448: 'arrx_rc.var.gl_date' ,'DATE');
449: fa_rx_util_pkg.assign_column('350',DECODE_CRH_AMOUNT ,'RECEIPT_AMOUNT' ,
450: 'arrx_rc.var.receipt_amount' ,'NUMBER');

Line 448: 'arrx_rc.var.gl_date' ,'DATE');

444: 'arrx_rc.var.receipt_method' ,'VARCHAR2', 30);
445: fa_rx_util_pkg.assign_column('330','CRH.CASH_RECEIPT_HISTORY_ID' ,'CASH_RECEIPT_HISTORY_ID' ,
446: 'arrx_rc.var.cash_receipt_history_id' ,'NUMBER');
447: fa_rx_util_pkg.assign_column('340','CRH.GL_DATE' ,'GL_DATE' ,
448: 'arrx_rc.var.gl_date' ,'DATE');
449: fa_rx_util_pkg.assign_column('350',DECODE_CRH_AMOUNT ,'RECEIPT_AMOUNT' ,
450: 'arrx_rc.var.receipt_amount' ,'NUMBER');
451: fa_rx_util_pkg.assign_column('360',DECODE_CRH_STATUS ,'RECEIPT_HISTORY_STATUS' ,
452: 'arrx_rc.var.receipt_history_status' ,'VARCHAR2', 40);

Line 450: 'arrx_rc.var.receipt_amount' ,'NUMBER');

446: 'arrx_rc.var.cash_receipt_history_id' ,'NUMBER');
447: fa_rx_util_pkg.assign_column('340','CRH.GL_DATE' ,'GL_DATE' ,
448: 'arrx_rc.var.gl_date' ,'DATE');
449: fa_rx_util_pkg.assign_column('350',DECODE_CRH_AMOUNT ,'RECEIPT_AMOUNT' ,
450: 'arrx_rc.var.receipt_amount' ,'NUMBER');
451: fa_rx_util_pkg.assign_column('360',DECODE_CRH_STATUS ,'RECEIPT_HISTORY_STATUS' ,
452: 'arrx_rc.var.receipt_history_status' ,'VARCHAR2', 40);
453: fa_rx_util_pkg.assign_column('370',DECODE_CRH_ACCTD_AMOUNT ,'ACCTD_RECEIPT_AMOUNT' ,
454: 'arrx_rc.var.acctd_receipt_amount' ,'NUMBER');

Line 452: 'arrx_rc.var.receipt_history_status' ,'VARCHAR2', 40);

448: 'arrx_rc.var.gl_date' ,'DATE');
449: fa_rx_util_pkg.assign_column('350',DECODE_CRH_AMOUNT ,'RECEIPT_AMOUNT' ,
450: 'arrx_rc.var.receipt_amount' ,'NUMBER');
451: fa_rx_util_pkg.assign_column('360',DECODE_CRH_STATUS ,'RECEIPT_HISTORY_STATUS' ,
452: 'arrx_rc.var.receipt_history_status' ,'VARCHAR2', 40);
453: fa_rx_util_pkg.assign_column('370',DECODE_CRH_ACCTD_AMOUNT ,'ACCTD_RECEIPT_AMOUNT' ,
454: 'arrx_rc.var.acctd_receipt_amount' ,'NUMBER');
455: fa_rx_util_pkg.assign_column('380',DECODE_CRH_FD_AMOUNT ,'FACTOR_DISCOUNT_AMOUNT' ,
456: 'arrx_rc.var.factor_discount_amount' ,'NUMBER');

Line 454: 'arrx_rc.var.acctd_receipt_amount' ,'NUMBER');

450: 'arrx_rc.var.receipt_amount' ,'NUMBER');
451: fa_rx_util_pkg.assign_column('360',DECODE_CRH_STATUS ,'RECEIPT_HISTORY_STATUS' ,
452: 'arrx_rc.var.receipt_history_status' ,'VARCHAR2', 40);
453: fa_rx_util_pkg.assign_column('370',DECODE_CRH_ACCTD_AMOUNT ,'ACCTD_RECEIPT_AMOUNT' ,
454: 'arrx_rc.var.acctd_receipt_amount' ,'NUMBER');
455: fa_rx_util_pkg.assign_column('380',DECODE_CRH_FD_AMOUNT ,'FACTOR_DISCOUNT_AMOUNT' ,
456: 'arrx_rc.var.factor_discount_amount' ,'NUMBER');
457: fa_rx_util_pkg.assign_column('390',DECODE_CRH_AFD_AMOUNT ,'ACCTD_FACTOR_DISCOUNT_AMOUNT' ,
458: 'arrx_rc.var.acctd_factor_discount_amount' ,'NUMBER');

Line 456: 'arrx_rc.var.factor_discount_amount' ,'NUMBER');

452: 'arrx_rc.var.receipt_history_status' ,'VARCHAR2', 40);
453: fa_rx_util_pkg.assign_column('370',DECODE_CRH_ACCTD_AMOUNT ,'ACCTD_RECEIPT_AMOUNT' ,
454: 'arrx_rc.var.acctd_receipt_amount' ,'NUMBER');
455: fa_rx_util_pkg.assign_column('380',DECODE_CRH_FD_AMOUNT ,'FACTOR_DISCOUNT_AMOUNT' ,
456: 'arrx_rc.var.factor_discount_amount' ,'NUMBER');
457: fa_rx_util_pkg.assign_column('390',DECODE_CRH_AFD_AMOUNT ,'ACCTD_FACTOR_DISCOUNT_AMOUNT' ,
458: 'arrx_rc.var.acctd_factor_discount_amount' ,'NUMBER');
459: fa_rx_util_pkg.assign_column('400','CC.CODE_COMBINATION_ID' ,'ACCOUNT_CODE_COMBINATION_ID' ,
460: 'arrx_rc.var.account_code_combination_id' ,'NUMBER');

Line 458: 'arrx_rc.var.acctd_factor_discount_amount' ,'NUMBER');

454: 'arrx_rc.var.acctd_receipt_amount' ,'NUMBER');
455: fa_rx_util_pkg.assign_column('380',DECODE_CRH_FD_AMOUNT ,'FACTOR_DISCOUNT_AMOUNT' ,
456: 'arrx_rc.var.factor_discount_amount' ,'NUMBER');
457: fa_rx_util_pkg.assign_column('390',DECODE_CRH_AFD_AMOUNT ,'ACCTD_FACTOR_DISCOUNT_AMOUNT' ,
458: 'arrx_rc.var.acctd_factor_discount_amount' ,'NUMBER');
459: fa_rx_util_pkg.assign_column('400','CC.CODE_COMBINATION_ID' ,'ACCOUNT_CODE_COMBINATION_ID' ,
460: 'arrx_rc.var.account_code_combination_id' ,'NUMBER');
461: fa_rx_util_pkg.assign_column('410',null ,'DEBIT_ACCOUNT' ,
462: 'arrx_rc.var.debit_account' ,'VARCHAR2',240);

Line 460: 'arrx_rc.var.account_code_combination_id' ,'NUMBER');

456: 'arrx_rc.var.factor_discount_amount' ,'NUMBER');
457: fa_rx_util_pkg.assign_column('390',DECODE_CRH_AFD_AMOUNT ,'ACCTD_FACTOR_DISCOUNT_AMOUNT' ,
458: 'arrx_rc.var.acctd_factor_discount_amount' ,'NUMBER');
459: fa_rx_util_pkg.assign_column('400','CC.CODE_COMBINATION_ID' ,'ACCOUNT_CODE_COMBINATION_ID' ,
460: 'arrx_rc.var.account_code_combination_id' ,'NUMBER');
461: fa_rx_util_pkg.assign_column('410',null ,'DEBIT_ACCOUNT' ,
462: 'arrx_rc.var.debit_account' ,'VARCHAR2',240);
463: fa_rx_util_pkg.assign_column('420',null ,'DEBIT_ACCOUNT_DESC' ,
464: 'arrx_rc.var.debit_account_desc' ,'VARCHAR2',240);

Line 462: 'arrx_rc.var.debit_account' ,'VARCHAR2',240);

458: 'arrx_rc.var.acctd_factor_discount_amount' ,'NUMBER');
459: fa_rx_util_pkg.assign_column('400','CC.CODE_COMBINATION_ID' ,'ACCOUNT_CODE_COMBINATION_ID' ,
460: 'arrx_rc.var.account_code_combination_id' ,'NUMBER');
461: fa_rx_util_pkg.assign_column('410',null ,'DEBIT_ACCOUNT' ,
462: 'arrx_rc.var.debit_account' ,'VARCHAR2',240);
463: fa_rx_util_pkg.assign_column('420',null ,'DEBIT_ACCOUNT_DESC' ,
464: 'arrx_rc.var.debit_account_desc' ,'VARCHAR2',240);
465: fa_rx_util_pkg.assign_column('430',null ,'DEBIT_BALANCING' ,
466: 'arrx_rc.var.debit_balancing' ,'VARCHAR2',240);

Line 464: 'arrx_rc.var.debit_account_desc' ,'VARCHAR2',240);

460: 'arrx_rc.var.account_code_combination_id' ,'NUMBER');
461: fa_rx_util_pkg.assign_column('410',null ,'DEBIT_ACCOUNT' ,
462: 'arrx_rc.var.debit_account' ,'VARCHAR2',240);
463: fa_rx_util_pkg.assign_column('420',null ,'DEBIT_ACCOUNT_DESC' ,
464: 'arrx_rc.var.debit_account_desc' ,'VARCHAR2',240);
465: fa_rx_util_pkg.assign_column('430',null ,'DEBIT_BALANCING' ,
466: 'arrx_rc.var.debit_balancing' ,'VARCHAR2',240);
467: fa_rx_util_pkg.assign_column('440',null ,'DEBIT_BALANCING_DESC' ,
468: 'arrx_rc.var.debit_balancing_desc' ,'VARCHAR2',240);

Line 466: 'arrx_rc.var.debit_balancing' ,'VARCHAR2',240);

462: 'arrx_rc.var.debit_account' ,'VARCHAR2',240);
463: fa_rx_util_pkg.assign_column('420',null ,'DEBIT_ACCOUNT_DESC' ,
464: 'arrx_rc.var.debit_account_desc' ,'VARCHAR2',240);
465: fa_rx_util_pkg.assign_column('430',null ,'DEBIT_BALANCING' ,
466: 'arrx_rc.var.debit_balancing' ,'VARCHAR2',240);
467: fa_rx_util_pkg.assign_column('440',null ,'DEBIT_BALANCING_DESC' ,
468: 'arrx_rc.var.debit_balancing_desc' ,'VARCHAR2',240);
469: fa_rx_util_pkg.assign_column('450',null ,'DEBIT_NATACCT' ,
470: 'arrx_rc.var.debit_natacct' ,'VARCHAR2',240);

Line 468: 'arrx_rc.var.debit_balancing_desc' ,'VARCHAR2',240);

464: 'arrx_rc.var.debit_account_desc' ,'VARCHAR2',240);
465: fa_rx_util_pkg.assign_column('430',null ,'DEBIT_BALANCING' ,
466: 'arrx_rc.var.debit_balancing' ,'VARCHAR2',240);
467: fa_rx_util_pkg.assign_column('440',null ,'DEBIT_BALANCING_DESC' ,
468: 'arrx_rc.var.debit_balancing_desc' ,'VARCHAR2',240);
469: fa_rx_util_pkg.assign_column('450',null ,'DEBIT_NATACCT' ,
470: 'arrx_rc.var.debit_natacct' ,'VARCHAR2',240);
471: fa_rx_util_pkg.assign_column('460',null ,'DEBIT_NATACCT_DESC' ,
472: 'arrx_rc.var.debit_natacct_desc' ,'VARCHAR2',240);

Line 470: 'arrx_rc.var.debit_natacct' ,'VARCHAR2',240);

466: 'arrx_rc.var.debit_balancing' ,'VARCHAR2',240);
467: fa_rx_util_pkg.assign_column('440',null ,'DEBIT_BALANCING_DESC' ,
468: 'arrx_rc.var.debit_balancing_desc' ,'VARCHAR2',240);
469: fa_rx_util_pkg.assign_column('450',null ,'DEBIT_NATACCT' ,
470: 'arrx_rc.var.debit_natacct' ,'VARCHAR2',240);
471: fa_rx_util_pkg.assign_column('460',null ,'DEBIT_NATACCT_DESC' ,
472: 'arrx_rc.var.debit_natacct_desc' ,'VARCHAR2',240);
473: fa_rx_util_pkg.assign_column('470','CUST.CUST_ACCOUNT_ID' ,'CUSTOMER_ID' ,
474: 'arrx_rc.var.customer_id' ,'NUMBER');

Line 472: 'arrx_rc.var.debit_natacct_desc' ,'VARCHAR2',240);

468: 'arrx_rc.var.debit_balancing_desc' ,'VARCHAR2',240);
469: fa_rx_util_pkg.assign_column('450',null ,'DEBIT_NATACCT' ,
470: 'arrx_rc.var.debit_natacct' ,'VARCHAR2',240);
471: fa_rx_util_pkg.assign_column('460',null ,'DEBIT_NATACCT_DESC' ,
472: 'arrx_rc.var.debit_natacct_desc' ,'VARCHAR2',240);
473: fa_rx_util_pkg.assign_column('470','CUST.CUST_ACCOUNT_ID' ,'CUSTOMER_ID' ,
474: 'arrx_rc.var.customer_id' ,'NUMBER');
475: /* bug 5724171*/
476: fa_rx_util_pkg.assign_column('480','SUBSTRB(PARTY.PARTY_NAME,1,240)' ,'CUSTOMER_NAME' ,

Line 474: 'arrx_rc.var.customer_id' ,'NUMBER');

470: 'arrx_rc.var.debit_natacct' ,'VARCHAR2',240);
471: fa_rx_util_pkg.assign_column('460',null ,'DEBIT_NATACCT_DESC' ,
472: 'arrx_rc.var.debit_natacct_desc' ,'VARCHAR2',240);
473: fa_rx_util_pkg.assign_column('470','CUST.CUST_ACCOUNT_ID' ,'CUSTOMER_ID' ,
474: 'arrx_rc.var.customer_id' ,'NUMBER');
475: /* bug 5724171*/
476: fa_rx_util_pkg.assign_column('480','SUBSTRB(PARTY.PARTY_NAME,1,240)' ,'CUSTOMER_NAME' ,
477: 'arrx_rc.var.customer_name' ,'VARCHAR2', 240);
478: fa_rx_util_pkg.assign_column('490','DECODE(PARTY.PARTY_TYPE, ''ORGANIZATION'',PARTY.ORGANIZATION_NAME_PHONETIC, NULL)','CUSTOMER_NAME_ALT',

Line 477: 'arrx_rc.var.customer_name' ,'VARCHAR2', 240);

473: fa_rx_util_pkg.assign_column('470','CUST.CUST_ACCOUNT_ID' ,'CUSTOMER_ID' ,
474: 'arrx_rc.var.customer_id' ,'NUMBER');
475: /* bug 5724171*/
476: fa_rx_util_pkg.assign_column('480','SUBSTRB(PARTY.PARTY_NAME,1,240)' ,'CUSTOMER_NAME' ,
477: 'arrx_rc.var.customer_name' ,'VARCHAR2', 240);
478: fa_rx_util_pkg.assign_column('490','DECODE(PARTY.PARTY_TYPE, ''ORGANIZATION'',PARTY.ORGANIZATION_NAME_PHONETIC, NULL)','CUSTOMER_NAME_ALT',
479: 'arrx_rc.var.customer_name_alt' ,'VARCHAR2',320);
480: fa_rx_util_pkg.assign_column('500','CUST.ACCOUNT_NUMBER' ,'CUSTOMER_NUMBER' ,
481: 'arrx_rc.var.customer_number' ,'VARCHAR2', 30);

Line 479: 'arrx_rc.var.customer_name_alt' ,'VARCHAR2',320);

475: /* bug 5724171*/
476: fa_rx_util_pkg.assign_column('480','SUBSTRB(PARTY.PARTY_NAME,1,240)' ,'CUSTOMER_NAME' ,
477: 'arrx_rc.var.customer_name' ,'VARCHAR2', 240);
478: fa_rx_util_pkg.assign_column('490','DECODE(PARTY.PARTY_TYPE, ''ORGANIZATION'',PARTY.ORGANIZATION_NAME_PHONETIC, NULL)','CUSTOMER_NAME_ALT',
479: 'arrx_rc.var.customer_name_alt' ,'VARCHAR2',320);
480: fa_rx_util_pkg.assign_column('500','CUST.ACCOUNT_NUMBER' ,'CUSTOMER_NUMBER' ,
481: 'arrx_rc.var.customer_number' ,'VARCHAR2', 30);
482:
483:

Line 481: 'arrx_rc.var.customer_number' ,'VARCHAR2', 30);

477: 'arrx_rc.var.customer_name' ,'VARCHAR2', 240);
478: fa_rx_util_pkg.assign_column('490','DECODE(PARTY.PARTY_TYPE, ''ORGANIZATION'',PARTY.ORGANIZATION_NAME_PHONETIC, NULL)','CUSTOMER_NAME_ALT',
479: 'arrx_rc.var.customer_name_alt' ,'VARCHAR2',320);
480: fa_rx_util_pkg.assign_column('500','CUST.ACCOUNT_NUMBER' ,'CUSTOMER_NUMBER' ,
481: 'arrx_rc.var.customer_number' ,'VARCHAR2', 30);
482:
483:
484:
485: -- define FROM_CLAUSE

Line 767: 'arrx_rc.var.receivable_application_id' ,'NUMBER');

763:
764: DECODE_RA_STATUS := 'DECODE(RA.STATUS,''ACC'',:L_ACCO,''APP'',:L_APPL,''UNAPP'',:L_UNAPPL,''UNID'',:L_UNIDE)';
765:
766: fa_rx_util_pkg.assign_column('A1 ','RA.RECEIVABLE_APPLICATION_ID' ,'RECEIVABLE_APPLICATION_ID',
767: 'arrx_rc.var.receivable_application_id' ,'NUMBER');
768: fa_rx_util_pkg.assign_column('A2 ','RA.APPLY_DATE','APPLY_DATE',
769: 'arrx_rc.var.apply_date' ,'DATE');
770: fa_rx_util_pkg.assign_column('A3 ',DECODE_RA_STATUS,'APPLICATION_STATUS',
771: 'arrx_rc.var.application_status' ,'VARCHAR2', 20);

Line 769: 'arrx_rc.var.apply_date' ,'DATE');

765:
766: fa_rx_util_pkg.assign_column('A1 ','RA.RECEIVABLE_APPLICATION_ID' ,'RECEIVABLE_APPLICATION_ID',
767: 'arrx_rc.var.receivable_application_id' ,'NUMBER');
768: fa_rx_util_pkg.assign_column('A2 ','RA.APPLY_DATE','APPLY_DATE',
769: 'arrx_rc.var.apply_date' ,'DATE');
770: fa_rx_util_pkg.assign_column('A3 ',DECODE_RA_STATUS,'APPLICATION_STATUS',
771: 'arrx_rc.var.application_status' ,'VARCHAR2', 20);
772: fa_rx_util_pkg.assign_column('A4 ','RA.AMOUNT_APPLIED' ,'AMOUNT_APPLIED_TO',
773: 'arrx_rc.var.amount_applied_to' ,'NUMBER');

Line 771: 'arrx_rc.var.application_status' ,'VARCHAR2', 20);

767: 'arrx_rc.var.receivable_application_id' ,'NUMBER');
768: fa_rx_util_pkg.assign_column('A2 ','RA.APPLY_DATE','APPLY_DATE',
769: 'arrx_rc.var.apply_date' ,'DATE');
770: fa_rx_util_pkg.assign_column('A3 ',DECODE_RA_STATUS,'APPLICATION_STATUS',
771: 'arrx_rc.var.application_status' ,'VARCHAR2', 20);
772: fa_rx_util_pkg.assign_column('A4 ','RA.AMOUNT_APPLIED' ,'AMOUNT_APPLIED_TO',
773: 'arrx_rc.var.amount_applied_to' ,'NUMBER');
774: fa_rx_util_pkg.assign_column('A5 ','NVL(RA.AMOUNT_APPLIED_FROM,RA.AMOUNT_APPLIED)' ,'AMOUNT_APPLIED_FROM',
775: 'arrx_rc.var.amount_applied_from' ,'NUMBER');

Line 773: 'arrx_rc.var.amount_applied_to' ,'NUMBER');

769: 'arrx_rc.var.apply_date' ,'DATE');
770: fa_rx_util_pkg.assign_column('A3 ',DECODE_RA_STATUS,'APPLICATION_STATUS',
771: 'arrx_rc.var.application_status' ,'VARCHAR2', 20);
772: fa_rx_util_pkg.assign_column('A4 ','RA.AMOUNT_APPLIED' ,'AMOUNT_APPLIED_TO',
773: 'arrx_rc.var.amount_applied_to' ,'NUMBER');
774: fa_rx_util_pkg.assign_column('A5 ','NVL(RA.AMOUNT_APPLIED_FROM,RA.AMOUNT_APPLIED)' ,'AMOUNT_APPLIED_FROM',
775: 'arrx_rc.var.amount_applied_from' ,'NUMBER');
776: fa_rx_util_pkg.assign_column('A6 ','NVL(RA.ACCTD_AMOUNT_APPLIED_TO,RA.ACCTD_AMOUNT_APPLIED_FROM)' ,'ACCTD_AMOUNT_APPLIED_TO',
777: 'arrx_rc.var.acctd_amount_applied_to' ,'NUMBER');

Line 775: 'arrx_rc.var.amount_applied_from' ,'NUMBER');

771: 'arrx_rc.var.application_status' ,'VARCHAR2', 20);
772: fa_rx_util_pkg.assign_column('A4 ','RA.AMOUNT_APPLIED' ,'AMOUNT_APPLIED_TO',
773: 'arrx_rc.var.amount_applied_to' ,'NUMBER');
774: fa_rx_util_pkg.assign_column('A5 ','NVL(RA.AMOUNT_APPLIED_FROM,RA.AMOUNT_APPLIED)' ,'AMOUNT_APPLIED_FROM',
775: 'arrx_rc.var.amount_applied_from' ,'NUMBER');
776: fa_rx_util_pkg.assign_column('A6 ','NVL(RA.ACCTD_AMOUNT_APPLIED_TO,RA.ACCTD_AMOUNT_APPLIED_FROM)' ,'ACCTD_AMOUNT_APPLIED_TO',
777: 'arrx_rc.var.acctd_amount_applied_to' ,'NUMBER');
778: fa_rx_util_pkg.assign_column('A7 ','RA.ACCTD_AMOUNT_APPLIED_FROM' ,'ACCTD_AMOUNT_APPLIED_FROM',
779: 'arrx_rc.var.acctd_amount_applied_from' ,'NUMBER');

Line 777: 'arrx_rc.var.acctd_amount_applied_to' ,'NUMBER');

773: 'arrx_rc.var.amount_applied_to' ,'NUMBER');
774: fa_rx_util_pkg.assign_column('A5 ','NVL(RA.AMOUNT_APPLIED_FROM,RA.AMOUNT_APPLIED)' ,'AMOUNT_APPLIED_FROM',
775: 'arrx_rc.var.amount_applied_from' ,'NUMBER');
776: fa_rx_util_pkg.assign_column('A6 ','NVL(RA.ACCTD_AMOUNT_APPLIED_TO,RA.ACCTD_AMOUNT_APPLIED_FROM)' ,'ACCTD_AMOUNT_APPLIED_TO',
777: 'arrx_rc.var.acctd_amount_applied_to' ,'NUMBER');
778: fa_rx_util_pkg.assign_column('A7 ','RA.ACCTD_AMOUNT_APPLIED_FROM' ,'ACCTD_AMOUNT_APPLIED_FROM',
779: 'arrx_rc.var.acctd_amount_applied_from' ,'NUMBER');
780: fa_rx_util_pkg.assign_column('A8 ','RA.EARNED_DISCOUNT_TAKEN' ,'EARNED_DISCOUNT_TAKEN',
781: 'arrx_rc.var.earned_discount_taken' ,'NUMBER');

Line 779: 'arrx_rc.var.acctd_amount_applied_from' ,'NUMBER');

775: 'arrx_rc.var.amount_applied_from' ,'NUMBER');
776: fa_rx_util_pkg.assign_column('A6 ','NVL(RA.ACCTD_AMOUNT_APPLIED_TO,RA.ACCTD_AMOUNT_APPLIED_FROM)' ,'ACCTD_AMOUNT_APPLIED_TO',
777: 'arrx_rc.var.acctd_amount_applied_to' ,'NUMBER');
778: fa_rx_util_pkg.assign_column('A7 ','RA.ACCTD_AMOUNT_APPLIED_FROM' ,'ACCTD_AMOUNT_APPLIED_FROM',
779: 'arrx_rc.var.acctd_amount_applied_from' ,'NUMBER');
780: fa_rx_util_pkg.assign_column('A8 ','RA.EARNED_DISCOUNT_TAKEN' ,'EARNED_DISCOUNT_TAKEN',
781: 'arrx_rc.var.earned_discount_taken' ,'NUMBER');
782: fa_rx_util_pkg.assign_column('A9 ','RA.UNEARNED_DISCOUNT_TAKEN','UNEARNED_DISCOUNT_TAKEN',
783: 'arrx_rc.var.unearned_discount_taken' ,'NUMBER');

Line 781: 'arrx_rc.var.earned_discount_taken' ,'NUMBER');

777: 'arrx_rc.var.acctd_amount_applied_to' ,'NUMBER');
778: fa_rx_util_pkg.assign_column('A7 ','RA.ACCTD_AMOUNT_APPLIED_FROM' ,'ACCTD_AMOUNT_APPLIED_FROM',
779: 'arrx_rc.var.acctd_amount_applied_from' ,'NUMBER');
780: fa_rx_util_pkg.assign_column('A8 ','RA.EARNED_DISCOUNT_TAKEN' ,'EARNED_DISCOUNT_TAKEN',
781: 'arrx_rc.var.earned_discount_taken' ,'NUMBER');
782: fa_rx_util_pkg.assign_column('A9 ','RA.UNEARNED_DISCOUNT_TAKEN','UNEARNED_DISCOUNT_TAKEN',
783: 'arrx_rc.var.unearned_discount_taken' ,'NUMBER');
784: fa_rx_util_pkg.assign_column('A10','RA.ACCTD_EARNED_DISCOUNT_TAKEN' ,'ACCTD_EARNED_DISCOUNT_TAKEN',
785: 'arrx_rc.var.acctd_earned_discount_taken' ,'NUMBER');

Line 783: 'arrx_rc.var.unearned_discount_taken' ,'NUMBER');

779: 'arrx_rc.var.acctd_amount_applied_from' ,'NUMBER');
780: fa_rx_util_pkg.assign_column('A8 ','RA.EARNED_DISCOUNT_TAKEN' ,'EARNED_DISCOUNT_TAKEN',
781: 'arrx_rc.var.earned_discount_taken' ,'NUMBER');
782: fa_rx_util_pkg.assign_column('A9 ','RA.UNEARNED_DISCOUNT_TAKEN','UNEARNED_DISCOUNT_TAKEN',
783: 'arrx_rc.var.unearned_discount_taken' ,'NUMBER');
784: fa_rx_util_pkg.assign_column('A10','RA.ACCTD_EARNED_DISCOUNT_TAKEN' ,'ACCTD_EARNED_DISCOUNT_TAKEN',
785: 'arrx_rc.var.acctd_earned_discount_taken' ,'NUMBER');
786: fa_rx_util_pkg.assign_column('A11','RA.ACCTD_UNEARNED_DISCOUNT_TAKEN' ,'ACCTD_UNEARNED_DISCOUNT_TAKEN',
787: 'arrx_rc.var.acctd_unearned_discount_taken' ,'NUMBER');

Line 785: 'arrx_rc.var.acctd_earned_discount_taken' ,'NUMBER');

781: 'arrx_rc.var.earned_discount_taken' ,'NUMBER');
782: fa_rx_util_pkg.assign_column('A9 ','RA.UNEARNED_DISCOUNT_TAKEN','UNEARNED_DISCOUNT_TAKEN',
783: 'arrx_rc.var.unearned_discount_taken' ,'NUMBER');
784: fa_rx_util_pkg.assign_column('A10','RA.ACCTD_EARNED_DISCOUNT_TAKEN' ,'ACCTD_EARNED_DISCOUNT_TAKEN',
785: 'arrx_rc.var.acctd_earned_discount_taken' ,'NUMBER');
786: fa_rx_util_pkg.assign_column('A11','RA.ACCTD_UNEARNED_DISCOUNT_TAKEN' ,'ACCTD_UNEARNED_DISCOUNT_TAKEN',
787: 'arrx_rc.var.acctd_unearned_discount_taken' ,'NUMBER');
788: fa_rx_util_pkg.assign_column('A12','TRX.CUSTOMER_TRX_ID' ,'APPLIED_CUSTOMER_TRX_ID',
789: 'arrx_rc.var.applied_customer_trx_id' ,'NUMBER');

Line 787: 'arrx_rc.var.acctd_unearned_discount_taken' ,'NUMBER');

783: 'arrx_rc.var.unearned_discount_taken' ,'NUMBER');
784: fa_rx_util_pkg.assign_column('A10','RA.ACCTD_EARNED_DISCOUNT_TAKEN' ,'ACCTD_EARNED_DISCOUNT_TAKEN',
785: 'arrx_rc.var.acctd_earned_discount_taken' ,'NUMBER');
786: fa_rx_util_pkg.assign_column('A11','RA.ACCTD_UNEARNED_DISCOUNT_TAKEN' ,'ACCTD_UNEARNED_DISCOUNT_TAKEN',
787: 'arrx_rc.var.acctd_unearned_discount_taken' ,'NUMBER');
788: fa_rx_util_pkg.assign_column('A12','TRX.CUSTOMER_TRX_ID' ,'APPLIED_CUSTOMER_TRX_ID',
789: 'arrx_rc.var.applied_customer_trx_id' ,'NUMBER');
790: fa_rx_util_pkg.assign_column('A13','DECODE(RA.STATUS, ''ACC'', :l_trx_on_acc, TRX.TRX_NUMBER)','TRX_NUMBER' ,
791: 'arrx_rc.var.trx_number','VARCHAR2', 20);

Line 789: 'arrx_rc.var.applied_customer_trx_id' ,'NUMBER');

785: 'arrx_rc.var.acctd_earned_discount_taken' ,'NUMBER');
786: fa_rx_util_pkg.assign_column('A11','RA.ACCTD_UNEARNED_DISCOUNT_TAKEN' ,'ACCTD_UNEARNED_DISCOUNT_TAKEN',
787: 'arrx_rc.var.acctd_unearned_discount_taken' ,'NUMBER');
788: fa_rx_util_pkg.assign_column('A12','TRX.CUSTOMER_TRX_ID' ,'APPLIED_CUSTOMER_TRX_ID',
789: 'arrx_rc.var.applied_customer_trx_id' ,'NUMBER');
790: fa_rx_util_pkg.assign_column('A13','DECODE(RA.STATUS, ''ACC'', :l_trx_on_acc, TRX.TRX_NUMBER)','TRX_NUMBER' ,
791: 'arrx_rc.var.trx_number','VARCHAR2', 20);
792: fa_rx_util_pkg.assign_column('A14','TRX.INVOICE_CURRENCY_CODE','TRX_CURRENCY_CODE',
793: 'arrx_rc.var.trx_currency_code' ,'VARCHAR2', 15);

Line 791: 'arrx_rc.var.trx_number','VARCHAR2', 20);

787: 'arrx_rc.var.acctd_unearned_discount_taken' ,'NUMBER');
788: fa_rx_util_pkg.assign_column('A12','TRX.CUSTOMER_TRX_ID' ,'APPLIED_CUSTOMER_TRX_ID',
789: 'arrx_rc.var.applied_customer_trx_id' ,'NUMBER');
790: fa_rx_util_pkg.assign_column('A13','DECODE(RA.STATUS, ''ACC'', :l_trx_on_acc, TRX.TRX_NUMBER)','TRX_NUMBER' ,
791: 'arrx_rc.var.trx_number','VARCHAR2', 20);
792: fa_rx_util_pkg.assign_column('A14','TRX.INVOICE_CURRENCY_CODE','TRX_CURRENCY_CODE',
793: 'arrx_rc.var.trx_currency_code' ,'VARCHAR2', 15);
794: fa_rx_util_pkg.assign_column('A15','TRX.TRX_DATE','TRX_DATE',
795: 'arrx_rc.var.trx_date','DATE');

Line 793: 'arrx_rc.var.trx_currency_code' ,'VARCHAR2', 15);

789: 'arrx_rc.var.applied_customer_trx_id' ,'NUMBER');
790: fa_rx_util_pkg.assign_column('A13','DECODE(RA.STATUS, ''ACC'', :l_trx_on_acc, TRX.TRX_NUMBER)','TRX_NUMBER' ,
791: 'arrx_rc.var.trx_number','VARCHAR2', 20);
792: fa_rx_util_pkg.assign_column('A14','TRX.INVOICE_CURRENCY_CODE','TRX_CURRENCY_CODE',
793: 'arrx_rc.var.trx_currency_code' ,'VARCHAR2', 15);
794: fa_rx_util_pkg.assign_column('A15','TRX.TRX_DATE','TRX_DATE',
795: 'arrx_rc.var.trx_date','DATE');
796: fa_rx_util_pkg.assign_column('A16','REC.AMOUNT','TRX_AMOUNT' ,
797: 'arrx_rc.var.trx_amount','NUMBER');

Line 795: 'arrx_rc.var.trx_date','DATE');

791: 'arrx_rc.var.trx_number','VARCHAR2', 20);
792: fa_rx_util_pkg.assign_column('A14','TRX.INVOICE_CURRENCY_CODE','TRX_CURRENCY_CODE',
793: 'arrx_rc.var.trx_currency_code' ,'VARCHAR2', 15);
794: fa_rx_util_pkg.assign_column('A15','TRX.TRX_DATE','TRX_DATE',
795: 'arrx_rc.var.trx_date','DATE');
796: fa_rx_util_pkg.assign_column('A16','REC.AMOUNT','TRX_AMOUNT' ,
797: 'arrx_rc.var.trx_amount','NUMBER');
798: fa_rx_util_pkg.assign_column('A17','REC.ACCTD_AMOUNT' ,'ACCTD_TRX_AMOUNT',
799: 'arrx_rc.var.acctd_trx_amount' ,'NUMBER');

Line 797: 'arrx_rc.var.trx_amount','NUMBER');

793: 'arrx_rc.var.trx_currency_code' ,'VARCHAR2', 15);
794: fa_rx_util_pkg.assign_column('A15','TRX.TRX_DATE','TRX_DATE',
795: 'arrx_rc.var.trx_date','DATE');
796: fa_rx_util_pkg.assign_column('A16','REC.AMOUNT','TRX_AMOUNT' ,
797: 'arrx_rc.var.trx_amount','NUMBER');
798: fa_rx_util_pkg.assign_column('A17','REC.ACCTD_AMOUNT' ,'ACCTD_TRX_AMOUNT',
799: 'arrx_rc.var.acctd_trx_amount' ,'NUMBER');
800:
801: fa_rx_util_pkg.debug('Define additional FROM_CLAUSE for Actual Receipts Register');

Line 799: 'arrx_rc.var.acctd_trx_amount' ,'NUMBER');

795: 'arrx_rc.var.trx_date','DATE');
796: fa_rx_util_pkg.assign_column('A16','REC.AMOUNT','TRX_AMOUNT' ,
797: 'arrx_rc.var.trx_amount','NUMBER');
798: fa_rx_util_pkg.assign_column('A17','REC.ACCTD_AMOUNT' ,'ACCTD_TRX_AMOUNT',
799: 'arrx_rc.var.acctd_trx_amount' ,'NUMBER');
800:
801: fa_rx_util_pkg.debug('Define additional FROM_CLAUSE for Actual Receipts Register');
802:
803: IF NVL(var.ca_sob_type,'P') = 'P' THEN

Line 942: 'arrx_rc.var.receivable_application_id' ,'NUMBER');

938:
939: fa_rx_util_pkg.debug('Define additional ASSIGN_COLUMNS for Applied Receipts Register');
940:
941: fa_rx_util_pkg.assign_column('A1 ','RA.RECEIVABLE_APPLICATION_ID' ,'RECEIVABLE_APPLICATION_ID',
942: 'arrx_rc.var.receivable_application_id' ,'NUMBER');
943: fa_rx_util_pkg.assign_column('A2 ','RA.APPLY_DATE' ,'APPLY_DATE' ,
944: 'arrx_rc.var.apply_date','DATE');
945: fa_rx_util_pkg.assign_column('A3 ','RAC.ACCOUNT_NUMBER' ,'RELATED_CUSTOMER' ,
946: 'arrx_rc.var.related_customer','VARCHAR2', 50);

Line 944: 'arrx_rc.var.apply_date','DATE');

940:
941: fa_rx_util_pkg.assign_column('A1 ','RA.RECEIVABLE_APPLICATION_ID' ,'RECEIVABLE_APPLICATION_ID',
942: 'arrx_rc.var.receivable_application_id' ,'NUMBER');
943: fa_rx_util_pkg.assign_column('A2 ','RA.APPLY_DATE' ,'APPLY_DATE' ,
944: 'arrx_rc.var.apply_date','DATE');
945: fa_rx_util_pkg.assign_column('A3 ','RAC.ACCOUNT_NUMBER' ,'RELATED_CUSTOMER' ,
946: 'arrx_rc.var.related_customer','VARCHAR2', 50);
947: fa_rx_util_pkg.assign_column('A4 ','NVL(RA.AMOUNT_APPLIED,0)','AMOUNT_APPLIED_TO',
948: 'arrx_rc.var.amount_applied_to' ,'NUMBER');

Line 946: 'arrx_rc.var.related_customer','VARCHAR2', 50);

942: 'arrx_rc.var.receivable_application_id' ,'NUMBER');
943: fa_rx_util_pkg.assign_column('A2 ','RA.APPLY_DATE' ,'APPLY_DATE' ,
944: 'arrx_rc.var.apply_date','DATE');
945: fa_rx_util_pkg.assign_column('A3 ','RAC.ACCOUNT_NUMBER' ,'RELATED_CUSTOMER' ,
946: 'arrx_rc.var.related_customer','VARCHAR2', 50);
947: fa_rx_util_pkg.assign_column('A4 ','NVL(RA.AMOUNT_APPLIED,0)','AMOUNT_APPLIED_TO',
948: 'arrx_rc.var.amount_applied_to' ,'NUMBER');
949: fa_rx_util_pkg.assign_column('A5 ','NVL(RA.AMOUNT_APPLIED_FROM,RA.AMOUNT_APPLIED)' ,'AMOUNT_APPLIED_FROM',
950: 'arrx_rc.var.amount_applied_from' ,'NUMBER');

Line 948: 'arrx_rc.var.amount_applied_to' ,'NUMBER');

944: 'arrx_rc.var.apply_date','DATE');
945: fa_rx_util_pkg.assign_column('A3 ','RAC.ACCOUNT_NUMBER' ,'RELATED_CUSTOMER' ,
946: 'arrx_rc.var.related_customer','VARCHAR2', 50);
947: fa_rx_util_pkg.assign_column('A4 ','NVL(RA.AMOUNT_APPLIED,0)','AMOUNT_APPLIED_TO',
948: 'arrx_rc.var.amount_applied_to' ,'NUMBER');
949: fa_rx_util_pkg.assign_column('A5 ','NVL(RA.AMOUNT_APPLIED_FROM,RA.AMOUNT_APPLIED)' ,'AMOUNT_APPLIED_FROM',
950: 'arrx_rc.var.amount_applied_from' ,'NUMBER');
951: fa_rx_util_pkg.assign_column('A6 ',applied_total ,'ACCTD_AMOUNT_APPLIED_TO',
952: 'arrx_rc.var.acctd_amount_applied_to' ,'NUMBER');

Line 950: 'arrx_rc.var.amount_applied_from' ,'NUMBER');

946: 'arrx_rc.var.related_customer','VARCHAR2', 50);
947: fa_rx_util_pkg.assign_column('A4 ','NVL(RA.AMOUNT_APPLIED,0)','AMOUNT_APPLIED_TO',
948: 'arrx_rc.var.amount_applied_to' ,'NUMBER');
949: fa_rx_util_pkg.assign_column('A5 ','NVL(RA.AMOUNT_APPLIED_FROM,RA.AMOUNT_APPLIED)' ,'AMOUNT_APPLIED_FROM',
950: 'arrx_rc.var.amount_applied_from' ,'NUMBER');
951: fa_rx_util_pkg.assign_column('A6 ',applied_total ,'ACCTD_AMOUNT_APPLIED_TO',
952: 'arrx_rc.var.acctd_amount_applied_to' ,'NUMBER');
953: fa_rx_util_pkg.assign_column('A7 ','NVL(RA.ACCTD_AMOUNT_APPLIED_FROM,0)' ,'ACCTD_AMOUNT_APPLIED_FROM',
954: 'arrx_rc.var.acctd_amount_applied_from' ,'NUMBER');

Line 952: 'arrx_rc.var.acctd_amount_applied_to' ,'NUMBER');

948: 'arrx_rc.var.amount_applied_to' ,'NUMBER');
949: fa_rx_util_pkg.assign_column('A5 ','NVL(RA.AMOUNT_APPLIED_FROM,RA.AMOUNT_APPLIED)' ,'AMOUNT_APPLIED_FROM',
950: 'arrx_rc.var.amount_applied_from' ,'NUMBER');
951: fa_rx_util_pkg.assign_column('A6 ',applied_total ,'ACCTD_AMOUNT_APPLIED_TO',
952: 'arrx_rc.var.acctd_amount_applied_to' ,'NUMBER');
953: fa_rx_util_pkg.assign_column('A7 ','NVL(RA.ACCTD_AMOUNT_APPLIED_FROM,0)' ,'ACCTD_AMOUNT_APPLIED_FROM',
954: 'arrx_rc.var.acctd_amount_applied_from' ,'NUMBER');
955: fa_rx_util_pkg.assign_column('A8 ','NVL(RA.EARNED_DISCOUNT_TAKEN,0)' ,'EARNED_DISCOUNT_TAKEN',
956: 'arrx_rc.var.earned_discount_taken' ,'NUMBER');

Line 954: 'arrx_rc.var.acctd_amount_applied_from' ,'NUMBER');

950: 'arrx_rc.var.amount_applied_from' ,'NUMBER');
951: fa_rx_util_pkg.assign_column('A6 ',applied_total ,'ACCTD_AMOUNT_APPLIED_TO',
952: 'arrx_rc.var.acctd_amount_applied_to' ,'NUMBER');
953: fa_rx_util_pkg.assign_column('A7 ','NVL(RA.ACCTD_AMOUNT_APPLIED_FROM,0)' ,'ACCTD_AMOUNT_APPLIED_FROM',
954: 'arrx_rc.var.acctd_amount_applied_from' ,'NUMBER');
955: fa_rx_util_pkg.assign_column('A8 ','NVL(RA.EARNED_DISCOUNT_TAKEN,0)' ,'EARNED_DISCOUNT_TAKEN',
956: 'arrx_rc.var.earned_discount_taken' ,'NUMBER');
957: fa_rx_util_pkg.assign_column('A9 ','NVL(RA.UNEARNED_DISCOUNT_TAKEN,0)' ,'UNEARNED_DISCOUNT_TAKEN',
958: 'arrx_rc.var.unearned_discount_taken' ,'NUMBER');

Line 956: 'arrx_rc.var.earned_discount_taken' ,'NUMBER');

952: 'arrx_rc.var.acctd_amount_applied_to' ,'NUMBER');
953: fa_rx_util_pkg.assign_column('A7 ','NVL(RA.ACCTD_AMOUNT_APPLIED_FROM,0)' ,'ACCTD_AMOUNT_APPLIED_FROM',
954: 'arrx_rc.var.acctd_amount_applied_from' ,'NUMBER');
955: fa_rx_util_pkg.assign_column('A8 ','NVL(RA.EARNED_DISCOUNT_TAKEN,0)' ,'EARNED_DISCOUNT_TAKEN',
956: 'arrx_rc.var.earned_discount_taken' ,'NUMBER');
957: fa_rx_util_pkg.assign_column('A9 ','NVL(RA.UNEARNED_DISCOUNT_TAKEN,0)' ,'UNEARNED_DISCOUNT_TAKEN',
958: 'arrx_rc.var.unearned_discount_taken' ,'NUMBER');
959: fa_rx_util_pkg.assign_column('A10','NVL(RA.ACCTD_EARNED_DISCOUNT_TAKEN,0)' ,'ACCTD_EARNED_DISCOUNT_TAKEN',
960: 'arrx_rc.var.acctd_earned_discount_taken' ,'NUMBER');

Line 958: 'arrx_rc.var.unearned_discount_taken' ,'NUMBER');

954: 'arrx_rc.var.acctd_amount_applied_from' ,'NUMBER');
955: fa_rx_util_pkg.assign_column('A8 ','NVL(RA.EARNED_DISCOUNT_TAKEN,0)' ,'EARNED_DISCOUNT_TAKEN',
956: 'arrx_rc.var.earned_discount_taken' ,'NUMBER');
957: fa_rx_util_pkg.assign_column('A9 ','NVL(RA.UNEARNED_DISCOUNT_TAKEN,0)' ,'UNEARNED_DISCOUNT_TAKEN',
958: 'arrx_rc.var.unearned_discount_taken' ,'NUMBER');
959: fa_rx_util_pkg.assign_column('A10','NVL(RA.ACCTD_EARNED_DISCOUNT_TAKEN,0)' ,'ACCTD_EARNED_DISCOUNT_TAKEN',
960: 'arrx_rc.var.acctd_earned_discount_taken' ,'NUMBER');
961: fa_rx_util_pkg.assign_column('A11','NVL(RA.ACCTD_UNEARNED_DISCOUNT_TAKEN,0)' ,'ACCTD_UNEARNED_DISCOUNT_TAKEN',
962: 'arrx_rc.var.acctd_unearned_discount_taken' ,'NUMBER');

Line 960: 'arrx_rc.var.acctd_earned_discount_taken' ,'NUMBER');

956: 'arrx_rc.var.earned_discount_taken' ,'NUMBER');
957: fa_rx_util_pkg.assign_column('A9 ','NVL(RA.UNEARNED_DISCOUNT_TAKEN,0)' ,'UNEARNED_DISCOUNT_TAKEN',
958: 'arrx_rc.var.unearned_discount_taken' ,'NUMBER');
959: fa_rx_util_pkg.assign_column('A10','NVL(RA.ACCTD_EARNED_DISCOUNT_TAKEN,0)' ,'ACCTD_EARNED_DISCOUNT_TAKEN',
960: 'arrx_rc.var.acctd_earned_discount_taken' ,'NUMBER');
961: fa_rx_util_pkg.assign_column('A11','NVL(RA.ACCTD_UNEARNED_DISCOUNT_TAKEN,0)' ,'ACCTD_UNEARNED_DISCOUNT_TAKEN',
962: 'arrx_rc.var.acctd_unearned_discount_taken' ,'NUMBER');
963: fa_rx_util_pkg.assign_column('A12','TRX.CUSTOMER_TRX_ID' ,'APPLIED_CUSTOMER_TRX_ID',
964: 'arrx_rc.var.applied_customer_trx_id' ,'NUMBER');

Line 962: 'arrx_rc.var.acctd_unearned_discount_taken' ,'NUMBER');

958: 'arrx_rc.var.unearned_discount_taken' ,'NUMBER');
959: fa_rx_util_pkg.assign_column('A10','NVL(RA.ACCTD_EARNED_DISCOUNT_TAKEN,0)' ,'ACCTD_EARNED_DISCOUNT_TAKEN',
960: 'arrx_rc.var.acctd_earned_discount_taken' ,'NUMBER');
961: fa_rx_util_pkg.assign_column('A11','NVL(RA.ACCTD_UNEARNED_DISCOUNT_TAKEN,0)' ,'ACCTD_UNEARNED_DISCOUNT_TAKEN',
962: 'arrx_rc.var.acctd_unearned_discount_taken' ,'NUMBER');
963: fa_rx_util_pkg.assign_column('A12','TRX.CUSTOMER_TRX_ID' ,'APPLIED_CUSTOMER_TRX_ID',
964: 'arrx_rc.var.applied_customer_trx_id' ,'NUMBER');
965:
966: IF (BILL_FLAG = 'Y') THEN

Line 964: 'arrx_rc.var.applied_customer_trx_id' ,'NUMBER');

960: 'arrx_rc.var.acctd_earned_discount_taken' ,'NUMBER');
961: fa_rx_util_pkg.assign_column('A11','NVL(RA.ACCTD_UNEARNED_DISCOUNT_TAKEN,0)' ,'ACCTD_UNEARNED_DISCOUNT_TAKEN',
962: 'arrx_rc.var.acctd_unearned_discount_taken' ,'NUMBER');
963: fa_rx_util_pkg.assign_column('A12','TRX.CUSTOMER_TRX_ID' ,'APPLIED_CUSTOMER_TRX_ID',
964: 'arrx_rc.var.applied_customer_trx_id' ,'NUMBER');
965:
966: IF (BILL_FLAG = 'Y') THEN
967: fa_rx_util_pkg.assign_column('A13','decode(ra.status, ''ACC'', :L_ONACCOUNT
968: , decode(ci.cons_billing_number, null, ps.trx_number

Line 970: 'arrx_rc.var.trx_number' ,'VARCHAR2', 30);-- bug 5767413

966: IF (BILL_FLAG = 'Y') THEN
967: fa_rx_util_pkg.assign_column('A13','decode(ra.status, ''ACC'', :L_ONACCOUNT
968: , decode(ci.cons_billing_number, null, ps.trx_number
969: , substrb(rtrim(ci.cons_billing_number)||''/''||rtrim(to_char(trx.trx_number)),1,30)))' ,'TRX_NUMBER',
970: 'arrx_rc.var.trx_number' ,'VARCHAR2', 30);-- bug 5767413
971: ELSE
972: fa_rx_util_pkg.assign_column('A13','decode(ra.status, ''ACC'', :L_ONACCOUNT, PS.TRX_NUMBER)','TRX_NUMBER' ,
973: 'arrx_rc.var.trx_number','VARCHAR2', 30);--bug 5767413
974: END IF;

Line 973: 'arrx_rc.var.trx_number','VARCHAR2', 30);--bug 5767413

969: , substrb(rtrim(ci.cons_billing_number)||''/''||rtrim(to_char(trx.trx_number)),1,30)))' ,'TRX_NUMBER',
970: 'arrx_rc.var.trx_number' ,'VARCHAR2', 30);-- bug 5767413
971: ELSE
972: fa_rx_util_pkg.assign_column('A13','decode(ra.status, ''ACC'', :L_ONACCOUNT, PS.TRX_NUMBER)','TRX_NUMBER' ,
973: 'arrx_rc.var.trx_number','VARCHAR2', 30);--bug 5767413
974: END IF;
975:
976: fa_rx_util_pkg.assign_column('A14','TRX.INVOICE_CURRENCY_CODE' ,'TRX_CURRENCY_CODE',
977: 'arrx_rc.var.trx_currency_code' ,'VARCHAR2', 15);

Line 977: 'arrx_rc.var.trx_currency_code' ,'VARCHAR2', 15);

973: 'arrx_rc.var.trx_number','VARCHAR2', 30);--bug 5767413
974: END IF;
975:
976: fa_rx_util_pkg.assign_column('A14','TRX.INVOICE_CURRENCY_CODE' ,'TRX_CURRENCY_CODE',
977: 'arrx_rc.var.trx_currency_code' ,'VARCHAR2', 15);
978: fa_rx_util_pkg.assign_column('A15','TRX.TRX_DATE' ,'TRX_DATE' ,
979: 'arrx_rc.var.trx_date','DATE');
980: fa_rx_util_pkg.assign_column('A16','NVL(REC.AMOUNT,0)' ,'TRX_AMOUNT' ,
981: 'arrx_rc.var.trx_amount','NUMBER');

Line 979: 'arrx_rc.var.trx_date','DATE');

975:
976: fa_rx_util_pkg.assign_column('A14','TRX.INVOICE_CURRENCY_CODE' ,'TRX_CURRENCY_CODE',
977: 'arrx_rc.var.trx_currency_code' ,'VARCHAR2', 15);
978: fa_rx_util_pkg.assign_column('A15','TRX.TRX_DATE' ,'TRX_DATE' ,
979: 'arrx_rc.var.trx_date','DATE');
980: fa_rx_util_pkg.assign_column('A16','NVL(REC.AMOUNT,0)' ,'TRX_AMOUNT' ,
981: 'arrx_rc.var.trx_amount','NUMBER');
982: fa_rx_util_pkg.assign_column('A17','NVL(REC.ACCTD_AMOUNT,0)' ,'ACCTD_TRX_AMOUNT',
983: 'arrx_rc.var.acctd_trx_amount' ,'NUMBER');

Line 981: 'arrx_rc.var.trx_amount','NUMBER');

977: 'arrx_rc.var.trx_currency_code' ,'VARCHAR2', 15);
978: fa_rx_util_pkg.assign_column('A15','TRX.TRX_DATE' ,'TRX_DATE' ,
979: 'arrx_rc.var.trx_date','DATE');
980: fa_rx_util_pkg.assign_column('A16','NVL(REC.AMOUNT,0)' ,'TRX_AMOUNT' ,
981: 'arrx_rc.var.trx_amount','NUMBER');
982: fa_rx_util_pkg.assign_column('A17','NVL(REC.ACCTD_AMOUNT,0)' ,'ACCTD_TRX_AMOUNT',
983: 'arrx_rc.var.acctd_trx_amount' ,'NUMBER');
984: fa_rx_util_pkg.assign_column('A18',rec_gain_loss ,'RECEIPT_GAIN_LOSS',
985: 'arrx_rc.var.receipt_gain_loss' ,'NUMBER');

Line 983: 'arrx_rc.var.acctd_trx_amount' ,'NUMBER');

979: 'arrx_rc.var.trx_date','DATE');
980: fa_rx_util_pkg.assign_column('A16','NVL(REC.AMOUNT,0)' ,'TRX_AMOUNT' ,
981: 'arrx_rc.var.trx_amount','NUMBER');
982: fa_rx_util_pkg.assign_column('A17','NVL(REC.ACCTD_AMOUNT,0)' ,'ACCTD_TRX_AMOUNT',
983: 'arrx_rc.var.acctd_trx_amount' ,'NUMBER');
984: fa_rx_util_pkg.assign_column('A18',rec_gain_loss ,'RECEIPT_GAIN_LOSS',
985: 'arrx_rc.var.receipt_gain_loss' ,'NUMBER');
986: -- bug 1821300. Override RR gl_date with ARR gl_date to avoid ora-00957
987: fa_rx_util_pkg.assign_column('340','RA.GL_DATE' ,'GL_DATE' ,

Line 985: 'arrx_rc.var.receipt_gain_loss' ,'NUMBER');

981: 'arrx_rc.var.trx_amount','NUMBER');
982: fa_rx_util_pkg.assign_column('A17','NVL(REC.ACCTD_AMOUNT,0)' ,'ACCTD_TRX_AMOUNT',
983: 'arrx_rc.var.acctd_trx_amount' ,'NUMBER');
984: fa_rx_util_pkg.assign_column('A18',rec_gain_loss ,'RECEIPT_GAIN_LOSS',
985: 'arrx_rc.var.receipt_gain_loss' ,'NUMBER');
986: -- bug 1821300. Override RR gl_date with ARR gl_date to avoid ora-00957
987: fa_rx_util_pkg.assign_column('340','RA.GL_DATE' ,'GL_DATE' ,
988: 'arrx_rc.var.gl_date','DATE');
989: -- bug 2379856. Override CRH.ccid with RA.ccid

Line 988: 'arrx_rc.var.gl_date','DATE');

984: fa_rx_util_pkg.assign_column('A18',rec_gain_loss ,'RECEIPT_GAIN_LOSS',
985: 'arrx_rc.var.receipt_gain_loss' ,'NUMBER');
986: -- bug 1821300. Override RR gl_date with ARR gl_date to avoid ora-00957
987: fa_rx_util_pkg.assign_column('340','RA.GL_DATE' ,'GL_DATE' ,
988: 'arrx_rc.var.gl_date','DATE');
989: -- bug 2379856. Override CRH.ccid with RA.ccid
990: fa_rx_util_pkg.assign_column('400','CC2.CODE_COMBINATION_ID' ,'ACCOUNT_CODE_COMBINATION_ID',
991: 'arrx_rc.var.account_code_combination_id' ,'NUMBER');
992: fa_rx_util_pkg.assign_column('500','BS.NAME' ,'BATCH_SOURCE',

Line 991: 'arrx_rc.var.account_code_combination_id' ,'NUMBER');

987: fa_rx_util_pkg.assign_column('340','RA.GL_DATE' ,'GL_DATE' ,
988: 'arrx_rc.var.gl_date','DATE');
989: -- bug 2379856. Override CRH.ccid with RA.ccid
990: fa_rx_util_pkg.assign_column('400','CC2.CODE_COMBINATION_ID' ,'ACCOUNT_CODE_COMBINATION_ID',
991: 'arrx_rc.var.account_code_combination_id' ,'NUMBER');
992: fa_rx_util_pkg.assign_column('500','BS.NAME' ,'BATCH_SOURCE',
993: 'arrx_rc.var.batch_source' ,'VARCHAR2',50);
994:
995: fa_rx_util_pkg.debug('Define additional FROM_CLAUSE for Applied Receipts Register');

Line 993: 'arrx_rc.var.batch_source' ,'VARCHAR2',50);

989: -- bug 2379856. Override CRH.ccid with RA.ccid
990: fa_rx_util_pkg.assign_column('400','CC2.CODE_COMBINATION_ID' ,'ACCOUNT_CODE_COMBINATION_ID',
991: 'arrx_rc.var.account_code_combination_id' ,'NUMBER');
992: fa_rx_util_pkg.assign_column('500','BS.NAME' ,'BATCH_SOURCE',
993: 'arrx_rc.var.batch_source' ,'VARCHAR2',50);
994:
995: fa_rx_util_pkg.debug('Define additional FROM_CLAUSE for Applied Receipts Register');
996:
997: IF NVL(var.ca_sob_type,'P') = 'P' THEN

Line 1053: 'arrx_rc.var.percent' ,'NUMBER');

1049:
1050: fa_rx_util_pkg.debug('Define additional ASSIGN_COLUMNS for Misc Receipts Register');
1051:
1052: fa_rx_util_pkg.assign_column('A1 ','decode(ARD.SOURCE_TYPE,''TAX'',NULL,MCD.PERCENT)' ,'MISC_PERCENT',
1053: 'arrx_rc.var.percent' ,'NUMBER');
1054: -- bug5444415
1055: IF arp_global.sysparam.accounting_method='ACCRUAL' THEN
1056: fa_rx_util_pkg.assign_column('A2 ','decode(SIGN(MCD.AMOUNT), 1, ARD.AMOUNT_CR,-1, SIGN(MCD.AMOUNT) * ARD.AMOUNT_DR, 0)' ,'MISC_AMOUNT' ,
1057: 'arrx_rc.var.misc_amount' ,'NUMBER');

Line 1057: 'arrx_rc.var.misc_amount' ,'NUMBER');

1053: 'arrx_rc.var.percent' ,'NUMBER');
1054: -- bug5444415
1055: IF arp_global.sysparam.accounting_method='ACCRUAL' THEN
1056: fa_rx_util_pkg.assign_column('A2 ','decode(SIGN(MCD.AMOUNT), 1, ARD.AMOUNT_CR,-1, SIGN(MCD.AMOUNT) * ARD.AMOUNT_DR, 0)' ,'MISC_AMOUNT' ,
1057: 'arrx_rc.var.misc_amount' ,'NUMBER');
1058: ELSE
1059: fa_rx_util_pkg.assign_column('A2 ','MCD.AMOUNT','MISC_AMOUNT' ,'arrx_rc.var.misc_amount' ,'NUMBER');
1060: END IF ;
1061: fa_rx_util_pkg.assign_column('A3 ','BS.NAME' ,'BATCH_SOURCE',

Line 1059: fa_rx_util_pkg.assign_column('A2 ','MCD.AMOUNT','MISC_AMOUNT' ,'arrx_rc.var.misc_amount' ,'NUMBER');

1055: IF arp_global.sysparam.accounting_method='ACCRUAL' THEN
1056: fa_rx_util_pkg.assign_column('A2 ','decode(SIGN(MCD.AMOUNT), 1, ARD.AMOUNT_CR,-1, SIGN(MCD.AMOUNT) * ARD.AMOUNT_DR, 0)' ,'MISC_AMOUNT' ,
1057: 'arrx_rc.var.misc_amount' ,'NUMBER');
1058: ELSE
1059: fa_rx_util_pkg.assign_column('A2 ','MCD.AMOUNT','MISC_AMOUNT' ,'arrx_rc.var.misc_amount' ,'NUMBER');
1060: END IF ;
1061: fa_rx_util_pkg.assign_column('A3 ','BS.NAME' ,'BATCH_SOURCE',
1062: 'arrx_rc.var.batch_source' ,'VARCHAR2',50);
1063: /* Bugfix 2842928. Override CRH.ccid with ARD.ccid */

Line 1062: 'arrx_rc.var.batch_source' ,'VARCHAR2',50);

1058: ELSE
1059: fa_rx_util_pkg.assign_column('A2 ','MCD.AMOUNT','MISC_AMOUNT' ,'arrx_rc.var.misc_amount' ,'NUMBER');
1060: END IF ;
1061: fa_rx_util_pkg.assign_column('A3 ','BS.NAME' ,'BATCH_SOURCE',
1062: 'arrx_rc.var.batch_source' ,'VARCHAR2',50);
1063: /* Bugfix 2842928. Override CRH.ccid with ARD.ccid */
1064: fa_rx_util_pkg.assign_column('400','CC2.CODE_COMBINATION_ID' ,'ACCOUNT_CODE_COMBINATION_ID',
1065: 'arrx_rc.var.account_code_combination_id' ,'NUMBER');
1066: /* Bugfix 2842928. Tax Code should be displayed only for TAX lines. */

Line 1065: 'arrx_rc.var.account_code_combination_id' ,'NUMBER');

1061: fa_rx_util_pkg.assign_column('A3 ','BS.NAME' ,'BATCH_SOURCE',
1062: 'arrx_rc.var.batch_source' ,'VARCHAR2',50);
1063: /* Bugfix 2842928. Override CRH.ccid with ARD.ccid */
1064: fa_rx_util_pkg.assign_column('400','CC2.CODE_COMBINATION_ID' ,'ACCOUNT_CODE_COMBINATION_ID',
1065: 'arrx_rc.var.account_code_combination_id' ,'NUMBER');
1066: /* Bugfix 2842928. Tax Code should be displayed only for TAX lines. */
1067: fa_rx_util_pkg.assign_column('200','decode(ARD.SOURCE_TYPE,''TAX'', TAX.TAX_CODE, NULL)' ,'TAX_CODE',
1068: 'arrx_rc.var.tax_code' ,'VARCHAR2', 50);
1069:

Line 1068: 'arrx_rc.var.tax_code' ,'VARCHAR2', 50);

1064: fa_rx_util_pkg.assign_column('400','CC2.CODE_COMBINATION_ID' ,'ACCOUNT_CODE_COMBINATION_ID',
1065: 'arrx_rc.var.account_code_combination_id' ,'NUMBER');
1066: /* Bugfix 2842928. Tax Code should be displayed only for TAX lines. */
1067: fa_rx_util_pkg.assign_column('200','decode(ARD.SOURCE_TYPE,''TAX'', TAX.TAX_CODE, NULL)' ,'TAX_CODE',
1068: 'arrx_rc.var.tax_code' ,'VARCHAR2', 50);
1069:
1070: fa_rx_util_pkg.debug('Define additional FROM_CLAUSE for Misc Receipts Register');
1071:
1072: /* Bugfix 2842928. Added GL_CODE_COMBINATIONS CC2, AR_DISTRIBUTIONS ARD */

Line 1165: fa_rx_util_pkg.debug('arrx_rc.before_report()-');

1161: MCD_GL_DATE_WHERE || ' ';
1162: END IF;
1163:
1164:
1165: fa_rx_util_pkg.debug('arrx_rc.before_report()-');
1166:
1167: end before_report;
1168:
1169: procedure bind(c in integer)

Line 1482: fa_rx_util_pkg.debug('arrx_rc.arrc_rep()+');

1478: is
1479: l_profile_rsob_id NUMBER := NULL;
1480: l_client_info_rsob_id NUMBER := NULL;
1481: begin
1482: fa_rx_util_pkg.debug('arrx_rc.arrc_rep()+');
1483:
1484: -- initialize all var to null
1485: arrx_rc.init_var;
1486:

Line 1485: arrx_rc.init_var;

1481: begin
1482: fa_rx_util_pkg.debug('arrx_rc.arrc_rep()+');
1483:
1484: -- initialize all var to null
1485: arrx_rc.init_var;
1486:
1487: -- Assign parameters to global variable
1488: -- These values will be used within the arrc_before_report trigger
1489: var.calling_program := 'RECEIPT';

Line 1591: fa_rx_util_pkg.init_request('arrx_rc.arrc_rep',request_id,'AR_RECEIPTS_REP_ITF');

1587: END IF;
1588: --
1589: -- Initialize request
1590: fa_rx_util_pkg.debug('Initializing the request');
1591: fa_rx_util_pkg.init_request('arrx_rc.arrc_rep',request_id,'AR_RECEIPTS_REP_ITF');
1592:
1593: fa_rx_util_pkg.assign_report('AR RECEIPTS',
1594: true,
1595: 'arrx_rc.before_report;',

Line 1595: 'arrx_rc.before_report;',

1591: fa_rx_util_pkg.init_request('arrx_rc.arrc_rep',request_id,'AR_RECEIPTS_REP_ITF');
1592:
1593: fa_rx_util_pkg.assign_report('AR RECEIPTS',
1594: true,
1595: 'arrx_rc.before_report;',
1596: 'arrx_rc.bind(:CURSOR_SELECT);',
1597: 'arrx_rc.after_fetch;',
1598: null);
1599:

Line 1596: 'arrx_rc.bind(:CURSOR_SELECT);',

1592:
1593: fa_rx_util_pkg.assign_report('AR RECEIPTS',
1594: true,
1595: 'arrx_rc.before_report;',
1596: 'arrx_rc.bind(:CURSOR_SELECT);',
1597: 'arrx_rc.after_fetch;',
1598: null);
1599:
1600: --

Line 1597: 'arrx_rc.after_fetch;',

1593: fa_rx_util_pkg.assign_report('AR RECEIPTS',
1594: true,
1595: 'arrx_rc.before_report;',
1596: 'arrx_rc.bind(:CURSOR_SELECT);',
1597: 'arrx_rc.after_fetch;',
1598: null);
1599:
1600: --
1601: -- Run the report.

Line 1602: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_rc.arrc_rep')

1598: null);
1599:
1600: --
1601: -- Run the report.
1602: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_rc.arrc_rep')
1603: fa_rx_util_pkg.run_report('arrx_rc.arrc_rep', retcode, errbuf);
1604:
1605: fa_rx_util_pkg.debug('arrx_rc.arrc_rep()-');
1606:

Line 1603: fa_rx_util_pkg.run_report('arrx_rc.arrc_rep', retcode, errbuf);

1599:
1600: --
1601: -- Run the report.
1602: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_rc.arrc_rep')
1603: fa_rx_util_pkg.run_report('arrx_rc.arrc_rep', retcode, errbuf);
1604:
1605: fa_rx_util_pkg.debug('arrx_rc.arrc_rep()-');
1606:
1607: exception

Line 1605: fa_rx_util_pkg.debug('arrx_rc.arrc_rep()-');

1601: -- Run the report.
1602: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_rc.arrc_rep')
1603: fa_rx_util_pkg.run_report('arrx_rc.arrc_rep', retcode, errbuf);
1604:
1605: fa_rx_util_pkg.debug('arrx_rc.arrc_rep()-');
1606:
1607: exception
1608: when others then
1609: fa_rx_util_pkg.log(sqlcode);

Line 1613: fa_rx_util_pkg.debug('arrx_rc.arrc_rep(EXCEPTION)-');

1609: fa_rx_util_pkg.log(sqlcode);
1610: fa_rx_util_pkg.log(sqlerrm);
1611: fa_rx_util_pkg.debug(sqlcode);
1612: fa_rx_util_pkg.debug(sqlerrm);
1613: fa_rx_util_pkg.debug('arrx_rc.arrc_rep(EXCEPTION)-');
1614: end arrc_rep;
1615:
1616: ------------------
1617: -- Actual Register

Line 1649: fa_rx_util_pkg.debug('arrx_rc.arrc_rep_actual()+');

1645: is
1646: l_profile_rsob_id NUMBER := NULL;
1647: l_client_info_rsob_id NUMBER := NULL;
1648: begin
1649: fa_rx_util_pkg.debug('arrx_rc.arrc_rep_actual()+');
1650:
1651: -- initialize all var to null
1652: arrx_rc.init_var;
1653:

Line 1652: arrx_rc.init_var;

1648: begin
1649: fa_rx_util_pkg.debug('arrx_rc.arrc_rep_actual()+');
1650:
1651: -- initialize all var to null
1652: arrx_rc.init_var;
1653:
1654: --
1655: -- Assign parameters to global variable
1656: -- These values will be used within the before_report trigger

Line 1715: fa_rx_util_pkg.init_request('arrx_rc.arrc_rep_actual',request_id,'AR_RECEIPTS_REP_ITF');

1711: var.ca_sob_type := 'R';
1712: END IF;
1713:
1714: -- Initialize request
1715: fa_rx_util_pkg.init_request('arrx_rc.arrc_rep_actual',request_id,'AR_RECEIPTS_REP_ITF');
1716:
1717: --
1718: -- Assign triggers specific to this report
1719: -- Make sure that you make your assignment to the correct section ('AR RECEIPTS')

Line 1722: 'arrx_rc.before_report;',

1718: -- Assign triggers specific to this report
1719: -- Make sure that you make your assignment to the correct section ('AR RECEIPTS')
1720: fa_rx_util_pkg.assign_report('AR RECEIPTS',
1721: true,
1722: 'arrx_rc.before_report;',
1723: 'arrx_rc.bind(:CURSOR_SELECT);',
1724: 'arrx_rc.after_fetch;',
1725: null);
1726:

Line 1723: 'arrx_rc.bind(:CURSOR_SELECT);',

1719: -- Make sure that you make your assignment to the correct section ('AR RECEIPTS')
1720: fa_rx_util_pkg.assign_report('AR RECEIPTS',
1721: true,
1722: 'arrx_rc.before_report;',
1723: 'arrx_rc.bind(:CURSOR_SELECT);',
1724: 'arrx_rc.after_fetch;',
1725: null);
1726:
1727: --

Line 1724: 'arrx_rc.after_fetch;',

1720: fa_rx_util_pkg.assign_report('AR RECEIPTS',
1721: true,
1722: 'arrx_rc.before_report;',
1723: 'arrx_rc.bind(:CURSOR_SELECT);',
1724: 'arrx_rc.after_fetch;',
1725: null);
1726:
1727: --
1728: -- Run the report.

Line 1729: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_rc.arrc_rep_actual')

1725: null);
1726:
1727: --
1728: -- Run the report.
1729: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_rc.arrc_rep_actual')
1730: fa_rx_util_pkg.run_report('arrx_rc.arrc_rep_actual', retcode, errbuf);
1731:
1732: fa_rx_util_pkg.debug('arrx_rc.arrc_rep_actual()-');
1733:

Line 1730: fa_rx_util_pkg.run_report('arrx_rc.arrc_rep_actual', retcode, errbuf);

1726:
1727: --
1728: -- Run the report.
1729: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_rc.arrc_rep_actual')
1730: fa_rx_util_pkg.run_report('arrx_rc.arrc_rep_actual', retcode, errbuf);
1731:
1732: fa_rx_util_pkg.debug('arrx_rc.arrc_rep_actual()-');
1733:
1734: exception

Line 1732: fa_rx_util_pkg.debug('arrx_rc.arrc_rep_actual()-');

1728: -- Run the report.
1729: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_rc.arrc_rep_actual')
1730: fa_rx_util_pkg.run_report('arrx_rc.arrc_rep_actual', retcode, errbuf);
1731:
1732: fa_rx_util_pkg.debug('arrx_rc.arrc_rep_actual()-');
1733:
1734: exception
1735: when others then
1736: fa_rx_util_pkg.log(sqlcode);

Line 1740: fa_rx_util_pkg.debug('arrx_rc.arrc_rep_actual(EXCEPTION)-');

1736: fa_rx_util_pkg.log(sqlcode);
1737: fa_rx_util_pkg.log(sqlerrm);
1738: fa_rx_util_pkg.debug(sqlcode);
1739: fa_rx_util_pkg.debug(sqlerrm);
1740: fa_rx_util_pkg.debug('arrx_rc.arrc_rep_actual(EXCEPTION)-');
1741: end arrc_rep_actual;
1742:
1743: -------------------
1744: -- Applied Register

Line 1780: fa_rx_util_pkg.debug('arrx_rc.arar_rep()+');

1776:
1777:
1778: begin
1779:
1780: fa_rx_util_pkg.debug('arrx_rc.arar_rep()+');
1781:
1782: -- initialize all var to null
1783: arrx_rc.init_var;
1784:

Line 1783: arrx_rc.init_var;

1779:
1780: fa_rx_util_pkg.debug('arrx_rc.arar_rep()+');
1781:
1782: -- initialize all var to null
1783: arrx_rc.init_var;
1784:
1785: --5255926
1786: if p_reporting_level = 1000 then
1787: var.books_id := p_reporting_entity_id;

Line 1850: fa_rx_util_pkg.init_request('arrx_rc.arar_rep',request_id,'AR_RECEIPTS_REP_ITF');

1846: END IF;
1847:
1848: --
1849: -- Initialize request
1850: fa_rx_util_pkg.init_request('arrx_rc.arar_rep',request_id,'AR_RECEIPTS_REP_ITF');
1851:
1852: -- Assign triggers specific to this report
1853: -- Make sure that you make your assignment to the correct section ('AR RECEIPTS')
1854:

Line 1857: 'arrx_rc.before_report;',

1853: -- Make sure that you make your assignment to the correct section ('AR RECEIPTS')
1854:
1855: fa_rx_util_pkg.assign_report('AR RECEIPTS',
1856: true,
1857: 'arrx_rc.before_report;',
1858: 'arrx_rc.bind(:CURSOR_SELECT);',
1859: 'arrx_rc.after_fetch;',
1860: null);
1861: --

Line 1858: 'arrx_rc.bind(:CURSOR_SELECT);',

1854:
1855: fa_rx_util_pkg.assign_report('AR RECEIPTS',
1856: true,
1857: 'arrx_rc.before_report;',
1858: 'arrx_rc.bind(:CURSOR_SELECT);',
1859: 'arrx_rc.after_fetch;',
1860: null);
1861: --
1862: -- Run the report.

Line 1859: 'arrx_rc.after_fetch;',

1855: fa_rx_util_pkg.assign_report('AR RECEIPTS',
1856: true,
1857: 'arrx_rc.before_report;',
1858: 'arrx_rc.bind(:CURSOR_SELECT);',
1859: 'arrx_rc.after_fetch;',
1860: null);
1861: --
1862: -- Run the report.
1863: -- Make sure to pass the p_calling_proc assigned from within this procedure

Line 1864: fa_rx_util_pkg.run_report('arrx_rc.arar_rep', retcode, errbuf);

1860: null);
1861: --
1862: -- Run the report.
1863: -- Make sure to pass the p_calling_proc assigned from within this procedure
1864: fa_rx_util_pkg.run_report('arrx_rc.arar_rep', retcode, errbuf);
1865:
1866: fa_rx_util_pkg.debug('arrx_rc.arar_rep()-');
1867: exception
1868: when others then

Line 1866: fa_rx_util_pkg.debug('arrx_rc.arar_rep()-');

1862: -- Run the report.
1863: -- Make sure to pass the p_calling_proc assigned from within this procedure
1864: fa_rx_util_pkg.run_report('arrx_rc.arar_rep', retcode, errbuf);
1865:
1866: fa_rx_util_pkg.debug('arrx_rc.arar_rep()-');
1867: exception
1868: when others then
1869: fa_rx_util_pkg.log(sqlcode);
1870: fa_rx_util_pkg.log(sqlerrm);

Line 1903: fa_rx_util_pkg.debug('arrx_rc.arar_rep()+');

1899: errbuf out NOCOPY varchar2)
1900: is
1901: begin
1902:
1903: fa_rx_util_pkg.debug('arrx_rc.arar_rep()+');
1904:
1905: -- initialize all var to null
1906: arrx_rc.init_var;
1907: --

Line 1906: arrx_rc.init_var;

1902:
1903: fa_rx_util_pkg.debug('arrx_rc.arar_rep()+');
1904:
1905: -- initialize all var to null
1906: arrx_rc.init_var;
1907: --
1908: -- Assign parameters to global variable
1909: -- These values will be used within the before_report trigger
1910:

Line 1957: fa_rx_util_pkg.init_request('arrx_rc.armtr_rep',request_id,'AR_RECEIPTS_REP_ITF');

1953: var.ca_sob_type := 'P';
1954:
1955: --
1956: -- Initialize request
1957: fa_rx_util_pkg.init_request('arrx_rc.armtr_rep',request_id,'AR_RECEIPTS_REP_ITF');
1958:
1959: fa_rx_util_pkg.assign_report('AR RECEIPTS',
1960: true,
1961: 'arrx_rc.before_report;',

Line 1961: 'arrx_rc.before_report;',

1957: fa_rx_util_pkg.init_request('arrx_rc.armtr_rep',request_id,'AR_RECEIPTS_REP_ITF');
1958:
1959: fa_rx_util_pkg.assign_report('AR RECEIPTS',
1960: true,
1961: 'arrx_rc.before_report;',
1962: 'arrx_rc.bind(:CURSOR_SELECT);',
1963: 'arrx_rc.after_fetch;',
1964: null);
1965: --

Line 1962: 'arrx_rc.bind(:CURSOR_SELECT);',

1958:
1959: fa_rx_util_pkg.assign_report('AR RECEIPTS',
1960: true,
1961: 'arrx_rc.before_report;',
1962: 'arrx_rc.bind(:CURSOR_SELECT);',
1963: 'arrx_rc.after_fetch;',
1964: null);
1965: --
1966: -- Run the report.

Line 1963: 'arrx_rc.after_fetch;',

1959: fa_rx_util_pkg.assign_report('AR RECEIPTS',
1960: true,
1961: 'arrx_rc.before_report;',
1962: 'arrx_rc.bind(:CURSOR_SELECT);',
1963: 'arrx_rc.after_fetch;',
1964: null);
1965: --
1966: -- Run the report.
1967: -- Make sure to pass the p_calling_proc assigned from within this procedure

Line 1968: fa_rx_util_pkg.run_report('arrx_rc.armtr_rep', retcode, errbuf);

1964: null);
1965: --
1966: -- Run the report.
1967: -- Make sure to pass the p_calling_proc assigned from within this procedure
1968: fa_rx_util_pkg.run_report('arrx_rc.armtr_rep', retcode, errbuf);
1969:
1970: exception
1971: when others then
1972: fa_rx_util_pkg.log(sqlcode);

Line 1978: end ARRX_RC;

1974: fa_rx_util_pkg.debug(sqlcode);
1975: fa_rx_util_pkg.debug(sqlerrm);
1976: end armtr_rep;
1977:
1978: end ARRX_RC;
1979: