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.33.12010000.2 2008/11/03 12:09:36 dgaurab ship $ */
3:
4: -- create generic procedure to reset to NULL all var type variables
5: procedure init_var is

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

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

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

339: fa_rx_util_pkg.debug('Start Assign_columns');
340: -- fa_rx_util_pkg.assign_column(unique seq#, select field, field in itf, into variable, type, len);
341:
342: fa_rx_util_pkg.assign_column('10 ',null ,'ORGANIZATION_NAME' ,
343: 'arrx_rc.var.organization_name' ,'VARCHAR2', 50);
344: fa_rx_util_pkg.assign_column('20 ',null ,'FUNCTIONAL_CURRENCY_CODE' ,
345: 'arrx_rc.var.functional_currency_code' ,'VARCHAR2', 15);
346: fa_rx_util_pkg.assign_column('30 ','CR.STATUS' ,null ,
347: 'arrx_rc.var.cr_status' ,'VARCHAR2', 40);

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

341:
342: fa_rx_util_pkg.assign_column('10 ',null ,'ORGANIZATION_NAME' ,
343: 'arrx_rc.var.organization_name' ,'VARCHAR2', 50);
344: fa_rx_util_pkg.assign_column('20 ',null ,'FUNCTIONAL_CURRENCY_CODE' ,
345: 'arrx_rc.var.functional_currency_code' ,'VARCHAR2', 15);
346: fa_rx_util_pkg.assign_column('30 ','CR.STATUS' ,null ,
347: 'arrx_rc.var.cr_status' ,'VARCHAR2', 40);
348: fa_rx_util_pkg.assign_column('40 ','CRH.STATUS' ,null ,
349: 'arrx_rc.var.crh_status' ,'VARCHAR2', 40);

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

343: 'arrx_rc.var.organization_name' ,'VARCHAR2', 50);
344: fa_rx_util_pkg.assign_column('20 ',null ,'FUNCTIONAL_CURRENCY_CODE' ,
345: 'arrx_rc.var.functional_currency_code' ,'VARCHAR2', 15);
346: fa_rx_util_pkg.assign_column('30 ','CR.STATUS' ,null ,
347: 'arrx_rc.var.cr_status' ,'VARCHAR2', 40);
348: fa_rx_util_pkg.assign_column('40 ','CRH.STATUS' ,null ,
349: 'arrx_rc.var.crh_status' ,'VARCHAR2', 40);
350: fa_rx_util_pkg.assign_column('50 ','DECODE(CRH.STATUS, ''REVERSED'', BATCHFIRST.BATCH_ID, BATCH.BATCH_ID)','BATCH_ID' ,
351: 'arrx_rc.var.batch_id' ,'NUMBER');

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

345: 'arrx_rc.var.functional_currency_code' ,'VARCHAR2', 15);
346: fa_rx_util_pkg.assign_column('30 ','CR.STATUS' ,null ,
347: 'arrx_rc.var.cr_status' ,'VARCHAR2', 40);
348: fa_rx_util_pkg.assign_column('40 ','CRH.STATUS' ,null ,
349: 'arrx_rc.var.crh_status' ,'VARCHAR2', 40);
350: fa_rx_util_pkg.assign_column('50 ','DECODE(CRH.STATUS, ''REVERSED'', BATCHFIRST.BATCH_ID, BATCH.BATCH_ID)','BATCH_ID' ,
351: 'arrx_rc.var.batch_id' ,'NUMBER');
352: fa_rx_util_pkg.assign_column('60 ','DECODE(CRH.STATUS, ''REVERSED'', BATCHFIRST.NAME, BATCH.NAME)','BATCH_NAME' ,
353: 'arrx_rc.var.batch_name' ,'VARCHAR2', 20);

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

347: 'arrx_rc.var.cr_status' ,'VARCHAR2', 40);
348: fa_rx_util_pkg.assign_column('40 ','CRH.STATUS' ,null ,
349: 'arrx_rc.var.crh_status' ,'VARCHAR2', 40);
350: fa_rx_util_pkg.assign_column('50 ','DECODE(CRH.STATUS, ''REVERSED'', BATCHFIRST.BATCH_ID, BATCH.BATCH_ID)','BATCH_ID' ,
351: 'arrx_rc.var.batch_id' ,'NUMBER');
352: fa_rx_util_pkg.assign_column('60 ','DECODE(CRH.STATUS, ''REVERSED'', BATCHFIRST.NAME, BATCH.NAME)','BATCH_NAME' ,
353: 'arrx_rc.var.batch_name' ,'VARCHAR2', 20);
354: fa_rx_util_pkg.assign_column('70 ','CR.CASH_RECEIPT_ID' ,'CASH_RECEIPT_ID' ,
355: 'arrx_rc.var.cash_receipt_id' ,'NUMBER');

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

349: 'arrx_rc.var.crh_status' ,'VARCHAR2', 40);
350: fa_rx_util_pkg.assign_column('50 ','DECODE(CRH.STATUS, ''REVERSED'', BATCHFIRST.BATCH_ID, BATCH.BATCH_ID)','BATCH_ID' ,
351: 'arrx_rc.var.batch_id' ,'NUMBER');
352: fa_rx_util_pkg.assign_column('60 ','DECODE(CRH.STATUS, ''REVERSED'', BATCHFIRST.NAME, BATCH.NAME)','BATCH_NAME' ,
353: 'arrx_rc.var.batch_name' ,'VARCHAR2', 20);
354: fa_rx_util_pkg.assign_column('70 ','CR.CASH_RECEIPT_ID' ,'CASH_RECEIPT_ID' ,
355: 'arrx_rc.var.cash_receipt_id' ,'NUMBER');
356: fa_rx_util_pkg.assign_column('80 ','CR.RECEIPT_NUMBER' ,'RECEIPT_NUMBER' ,
357: 'arrx_rc.var.receipt_number' ,'VARCHAR2', 30);

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

351: 'arrx_rc.var.batch_id' ,'NUMBER');
352: fa_rx_util_pkg.assign_column('60 ','DECODE(CRH.STATUS, ''REVERSED'', BATCHFIRST.NAME, BATCH.NAME)','BATCH_NAME' ,
353: 'arrx_rc.var.batch_name' ,'VARCHAR2', 20);
354: fa_rx_util_pkg.assign_column('70 ','CR.CASH_RECEIPT_ID' ,'CASH_RECEIPT_ID' ,
355: 'arrx_rc.var.cash_receipt_id' ,'NUMBER');
356: fa_rx_util_pkg.assign_column('80 ','CR.RECEIPT_NUMBER' ,'RECEIPT_NUMBER' ,
357: 'arrx_rc.var.receipt_number' ,'VARCHAR2', 30);
358: fa_rx_util_pkg.assign_column('90 ','CR.CURRENCY_CODE' ,'RECEIPT_CURRENCY_CODE' ,
359: 'arrx_rc.var.receipt_currency_code' ,'VARCHAR2', 15);

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

353: 'arrx_rc.var.batch_name' ,'VARCHAR2', 20);
354: fa_rx_util_pkg.assign_column('70 ','CR.CASH_RECEIPT_ID' ,'CASH_RECEIPT_ID' ,
355: 'arrx_rc.var.cash_receipt_id' ,'NUMBER');
356: fa_rx_util_pkg.assign_column('80 ','CR.RECEIPT_NUMBER' ,'RECEIPT_NUMBER' ,
357: 'arrx_rc.var.receipt_number' ,'VARCHAR2', 30);
358: fa_rx_util_pkg.assign_column('90 ','CR.CURRENCY_CODE' ,'RECEIPT_CURRENCY_CODE' ,
359: 'arrx_rc.var.receipt_currency_code' ,'VARCHAR2', 15);
360: fa_rx_util_pkg.assign_column('100','CR.EXCHANGE_RATE' ,'EXCHANGE_RATE' ,
361: 'arrx_rc.var.exchange_rate' ,'NUMBER');

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

355: 'arrx_rc.var.cash_receipt_id' ,'NUMBER');
356: fa_rx_util_pkg.assign_column('80 ','CR.RECEIPT_NUMBER' ,'RECEIPT_NUMBER' ,
357: 'arrx_rc.var.receipt_number' ,'VARCHAR2', 30);
358: fa_rx_util_pkg.assign_column('90 ','CR.CURRENCY_CODE' ,'RECEIPT_CURRENCY_CODE' ,
359: 'arrx_rc.var.receipt_currency_code' ,'VARCHAR2', 15);
360: fa_rx_util_pkg.assign_column('100','CR.EXCHANGE_RATE' ,'EXCHANGE_RATE' ,
361: 'arrx_rc.var.exchange_rate' ,'NUMBER');
362: fa_rx_util_pkg.assign_column('110','CR.EXCHANGE_DATE' ,'EXCHANGE_DATE' ,
363: 'arrx_rc.var.exchange_date' ,'DATE');

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

357: 'arrx_rc.var.receipt_number' ,'VARCHAR2', 30);
358: fa_rx_util_pkg.assign_column('90 ','CR.CURRENCY_CODE' ,'RECEIPT_CURRENCY_CODE' ,
359: 'arrx_rc.var.receipt_currency_code' ,'VARCHAR2', 15);
360: fa_rx_util_pkg.assign_column('100','CR.EXCHANGE_RATE' ,'EXCHANGE_RATE' ,
361: 'arrx_rc.var.exchange_rate' ,'NUMBER');
362: fa_rx_util_pkg.assign_column('110','CR.EXCHANGE_DATE' ,'EXCHANGE_DATE' ,
363: 'arrx_rc.var.exchange_date' ,'DATE');
364: fa_rx_util_pkg.assign_column('120','CR.EXCHANGE_RATE_TYPE' ,'EXCHANGE_TYPE' ,
365: 'arrx_rc.var.exchange_type' ,'VARCHAR2', 30);

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

359: 'arrx_rc.var.receipt_currency_code' ,'VARCHAR2', 15);
360: fa_rx_util_pkg.assign_column('100','CR.EXCHANGE_RATE' ,'EXCHANGE_RATE' ,
361: 'arrx_rc.var.exchange_rate' ,'NUMBER');
362: fa_rx_util_pkg.assign_column('110','CR.EXCHANGE_DATE' ,'EXCHANGE_DATE' ,
363: 'arrx_rc.var.exchange_date' ,'DATE');
364: fa_rx_util_pkg.assign_column('120','CR.EXCHANGE_RATE_TYPE' ,'EXCHANGE_TYPE' ,
365: 'arrx_rc.var.exchange_type' ,'VARCHAR2', 30);
366: fa_rx_util_pkg.assign_column('130','DOCSEQ.NAME' ,'DOC_SEQUENCE_NAME' ,
367: 'arrx_rc.var.doc_sequence_name' ,'VARCHAR2', 30);

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

361: 'arrx_rc.var.exchange_rate' ,'NUMBER');
362: fa_rx_util_pkg.assign_column('110','CR.EXCHANGE_DATE' ,'EXCHANGE_DATE' ,
363: 'arrx_rc.var.exchange_date' ,'DATE');
364: fa_rx_util_pkg.assign_column('120','CR.EXCHANGE_RATE_TYPE' ,'EXCHANGE_TYPE' ,
365: 'arrx_rc.var.exchange_type' ,'VARCHAR2', 30);
366: fa_rx_util_pkg.assign_column('130','DOCSEQ.NAME' ,'DOC_SEQUENCE_NAME' ,
367: 'arrx_rc.var.doc_sequence_name' ,'VARCHAR2', 30);
368: fa_rx_util_pkg.assign_column('140','CR.DOC_SEQUENCE_VALUE' ,'DOC_SEQUENCE_VALUE' ,
369: 'arrx_rc.var.doc_sequence_value' ,'NUMBER');

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

363: 'arrx_rc.var.exchange_date' ,'DATE');
364: fa_rx_util_pkg.assign_column('120','CR.EXCHANGE_RATE_TYPE' ,'EXCHANGE_TYPE' ,
365: 'arrx_rc.var.exchange_type' ,'VARCHAR2', 30);
366: fa_rx_util_pkg.assign_column('130','DOCSEQ.NAME' ,'DOC_SEQUENCE_NAME' ,
367: 'arrx_rc.var.doc_sequence_name' ,'VARCHAR2', 30);
368: fa_rx_util_pkg.assign_column('140','CR.DOC_SEQUENCE_VALUE' ,'DOC_SEQUENCE_VALUE' ,
369: 'arrx_rc.var.doc_sequence_value' ,'NUMBER');
370: fa_rx_util_pkg.assign_column('150','CR.DEPOSIT_DATE' ,'DEPOSIT_DATE' ,
371: 'arrx_rc.var.deposit_date' ,'DATE');

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

365: 'arrx_rc.var.exchange_type' ,'VARCHAR2', 30);
366: fa_rx_util_pkg.assign_column('130','DOCSEQ.NAME' ,'DOC_SEQUENCE_NAME' ,
367: 'arrx_rc.var.doc_sequence_name' ,'VARCHAR2', 30);
368: fa_rx_util_pkg.assign_column('140','CR.DOC_SEQUENCE_VALUE' ,'DOC_SEQUENCE_VALUE' ,
369: 'arrx_rc.var.doc_sequence_value' ,'NUMBER');
370: fa_rx_util_pkg.assign_column('150','CR.DEPOSIT_DATE' ,'DEPOSIT_DATE' ,
371: 'arrx_rc.var.deposit_date' ,'DATE');
372: fa_rx_util_pkg.assign_column('160','CR.RECEIPT_DATE' ,'RECEIPT_DATE' ,
373: 'arrx_rc.var.receipt_date' ,'DATE');

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

367: 'arrx_rc.var.doc_sequence_name' ,'VARCHAR2', 30);
368: fa_rx_util_pkg.assign_column('140','CR.DOC_SEQUENCE_VALUE' ,'DOC_SEQUENCE_VALUE' ,
369: 'arrx_rc.var.doc_sequence_value' ,'NUMBER');
370: fa_rx_util_pkg.assign_column('150','CR.DEPOSIT_DATE' ,'DEPOSIT_DATE' ,
371: 'arrx_rc.var.deposit_date' ,'DATE');
372: fa_rx_util_pkg.assign_column('160','CR.RECEIPT_DATE' ,'RECEIPT_DATE' ,
373: 'arrx_rc.var.receipt_date' ,'DATE');
374: fa_rx_util_pkg.assign_column('170',DECODE_CR_TYPE ,'RECEIPT_TYPE' ,
375: 'arrx_rc.var.receipt_type' ,'VARCHAR2', 30);

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

369: 'arrx_rc.var.doc_sequence_value' ,'NUMBER');
370: fa_rx_util_pkg.assign_column('150','CR.DEPOSIT_DATE' ,'DEPOSIT_DATE' ,
371: 'arrx_rc.var.deposit_date' ,'DATE');
372: fa_rx_util_pkg.assign_column('160','CR.RECEIPT_DATE' ,'RECEIPT_DATE' ,
373: 'arrx_rc.var.receipt_date' ,'DATE');
374: fa_rx_util_pkg.assign_column('170',DECODE_CR_TYPE ,'RECEIPT_TYPE' ,
375: 'arrx_rc.var.receipt_type' ,'VARCHAR2', 30);
376: fa_rx_util_pkg.assign_column('180',DECODE_CR_STATUS ,'RECEIPT_STATUS' ,
377: 'arrx_rc.var.receipt_status' ,'VARCHAR2', 40);

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

371: 'arrx_rc.var.deposit_date' ,'DATE');
372: fa_rx_util_pkg.assign_column('160','CR.RECEIPT_DATE' ,'RECEIPT_DATE' ,
373: 'arrx_rc.var.receipt_date' ,'DATE');
374: fa_rx_util_pkg.assign_column('170',DECODE_CR_TYPE ,'RECEIPT_TYPE' ,
375: 'arrx_rc.var.receipt_type' ,'VARCHAR2', 30);
376: fa_rx_util_pkg.assign_column('180',DECODE_CR_STATUS ,'RECEIPT_STATUS' ,
377: 'arrx_rc.var.receipt_status' ,'VARCHAR2', 40);
378: fa_rx_util_pkg.assign_column('190','CR.MISC_PAYMENT_SOURCE' ,'MISC_PAYMENT_SOURCE' ,
379: 'arrx_rc.var.misc_payment_source' ,'VARCHAR2', 30);

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

373: 'arrx_rc.var.receipt_date' ,'DATE');
374: fa_rx_util_pkg.assign_column('170',DECODE_CR_TYPE ,'RECEIPT_TYPE' ,
375: 'arrx_rc.var.receipt_type' ,'VARCHAR2', 30);
376: fa_rx_util_pkg.assign_column('180',DECODE_CR_STATUS ,'RECEIPT_STATUS' ,
377: 'arrx_rc.var.receipt_status' ,'VARCHAR2', 40);
378: fa_rx_util_pkg.assign_column('190','CR.MISC_PAYMENT_SOURCE' ,'MISC_PAYMENT_SOURCE' ,
379: 'arrx_rc.var.misc_payment_source' ,'VARCHAR2', 30);
380: fa_rx_util_pkg.assign_column('200','TAX.TAX_CODE' ,'TAX_CODE' ,
381: 'arrx_rc.var.tax_code' ,'VARCHAR2', 50);

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

375: 'arrx_rc.var.receipt_type' ,'VARCHAR2', 30);
376: fa_rx_util_pkg.assign_column('180',DECODE_CR_STATUS ,'RECEIPT_STATUS' ,
377: 'arrx_rc.var.receipt_status' ,'VARCHAR2', 40);
378: fa_rx_util_pkg.assign_column('190','CR.MISC_PAYMENT_SOURCE' ,'MISC_PAYMENT_SOURCE' ,
379: 'arrx_rc.var.misc_payment_source' ,'VARCHAR2', 30);
380: fa_rx_util_pkg.assign_column('200','TAX.TAX_CODE' ,'TAX_CODE' ,
381: 'arrx_rc.var.tax_code' ,'VARCHAR2', 50);
382: fa_rx_util_pkg.assign_column('210',DECODE_CR_REFERENCE_TYPE ,'REFERENCE_TYPE' ,
383: 'arrx_rc.var.reference_type' ,'VARCHAR2', 30);

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

377: 'arrx_rc.var.receipt_status' ,'VARCHAR2', 40);
378: fa_rx_util_pkg.assign_column('190','CR.MISC_PAYMENT_SOURCE' ,'MISC_PAYMENT_SOURCE' ,
379: 'arrx_rc.var.misc_payment_source' ,'VARCHAR2', 30);
380: fa_rx_util_pkg.assign_column('200','TAX.TAX_CODE' ,'TAX_CODE' ,
381: 'arrx_rc.var.tax_code' ,'VARCHAR2', 50);
382: fa_rx_util_pkg.assign_column('210',DECODE_CR_REFERENCE_TYPE ,'REFERENCE_TYPE' ,
383: 'arrx_rc.var.reference_type' ,'VARCHAR2', 30);
384: fa_rx_util_pkg.assign_column('220','CR.ANTICIPATED_CLEARING_DATE' ,'ANTICIPATED_CLEARING_DATE' ,
385: 'arrx_rc.var.anticipated_clearing_date' ,'DATE');

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

379: 'arrx_rc.var.misc_payment_source' ,'VARCHAR2', 30);
380: fa_rx_util_pkg.assign_column('200','TAX.TAX_CODE' ,'TAX_CODE' ,
381: 'arrx_rc.var.tax_code' ,'VARCHAR2', 50);
382: fa_rx_util_pkg.assign_column('210',DECODE_CR_REFERENCE_TYPE ,'REFERENCE_TYPE' ,
383: 'arrx_rc.var.reference_type' ,'VARCHAR2', 30);
384: fa_rx_util_pkg.assign_column('220','CR.ANTICIPATED_CLEARING_DATE' ,'ANTICIPATED_CLEARING_DATE' ,
385: 'arrx_rc.var.anticipated_clearing_date' ,'DATE');
386: fa_rx_util_pkg.assign_column('230','ABB.BANK_NAME' ,'BANK_NAME' ,
387: 'arrx_rc.var.bank_name' ,'VARCHAR2', 60);

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

381: 'arrx_rc.var.tax_code' ,'VARCHAR2', 50);
382: fa_rx_util_pkg.assign_column('210',DECODE_CR_REFERENCE_TYPE ,'REFERENCE_TYPE' ,
383: 'arrx_rc.var.reference_type' ,'VARCHAR2', 30);
384: fa_rx_util_pkg.assign_column('220','CR.ANTICIPATED_CLEARING_DATE' ,'ANTICIPATED_CLEARING_DATE' ,
385: 'arrx_rc.var.anticipated_clearing_date' ,'DATE');
386: fa_rx_util_pkg.assign_column('230','ABB.BANK_NAME' ,'BANK_NAME' ,
387: 'arrx_rc.var.bank_name' ,'VARCHAR2', 60);
388: fa_rx_util_pkg.assign_column('240','ABB.BANK_NAME_ALT' ,'BANK_NAME_ALT' ,
389: 'arrx_rc.var.bank_name_alt' ,'VARCHAR2',320);

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

383: 'arrx_rc.var.reference_type' ,'VARCHAR2', 30);
384: fa_rx_util_pkg.assign_column('220','CR.ANTICIPATED_CLEARING_DATE' ,'ANTICIPATED_CLEARING_DATE' ,
385: 'arrx_rc.var.anticipated_clearing_date' ,'DATE');
386: fa_rx_util_pkg.assign_column('230','ABB.BANK_NAME' ,'BANK_NAME' ,
387: 'arrx_rc.var.bank_name' ,'VARCHAR2', 60);
388: fa_rx_util_pkg.assign_column('240','ABB.BANK_NAME_ALT' ,'BANK_NAME_ALT' ,
389: 'arrx_rc.var.bank_name_alt' ,'VARCHAR2',320);
390: fa_rx_util_pkg.assign_column('250','ABB.BANK_BRANCH_NAME' ,'BANK_BRANCH_NAME' ,
391: 'arrx_rc.var.bank_branch_name' ,'VARCHAR2', 60);

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

385: 'arrx_rc.var.anticipated_clearing_date' ,'DATE');
386: fa_rx_util_pkg.assign_column('230','ABB.BANK_NAME' ,'BANK_NAME' ,
387: 'arrx_rc.var.bank_name' ,'VARCHAR2', 60);
388: fa_rx_util_pkg.assign_column('240','ABB.BANK_NAME_ALT' ,'BANK_NAME_ALT' ,
389: 'arrx_rc.var.bank_name_alt' ,'VARCHAR2',320);
390: fa_rx_util_pkg.assign_column('250','ABB.BANK_BRANCH_NAME' ,'BANK_BRANCH_NAME' ,
391: 'arrx_rc.var.bank_branch_name' ,'VARCHAR2', 60);
392: fa_rx_util_pkg.assign_column('260','ABB.BANK_BRANCH_NAME_ALT' ,'BANK_BRANCH_NAME_ALT' ,
393: 'arrx_rc.var.bank_branch_name_alt' ,'VARCHAR2',320);

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

387: 'arrx_rc.var.bank_name' ,'VARCHAR2', 60);
388: fa_rx_util_pkg.assign_column('240','ABB.BANK_NAME_ALT' ,'BANK_NAME_ALT' ,
389: 'arrx_rc.var.bank_name_alt' ,'VARCHAR2',320);
390: fa_rx_util_pkg.assign_column('250','ABB.BANK_BRANCH_NAME' ,'BANK_BRANCH_NAME' ,
391: 'arrx_rc.var.bank_branch_name' ,'VARCHAR2', 60);
392: fa_rx_util_pkg.assign_column('260','ABB.BANK_BRANCH_NAME_ALT' ,'BANK_BRANCH_NAME_ALT' ,
393: 'arrx_rc.var.bank_branch_name_alt' ,'VARCHAR2',320);
394: fa_rx_util_pkg.assign_column('270','ABB.BANK_NUMBER' ,'BANK_NUMBER' ,
395: 'arrx_rc.var.bank_number' ,'VARCHAR2', 30);

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

389: 'arrx_rc.var.bank_name_alt' ,'VARCHAR2',320);
390: fa_rx_util_pkg.assign_column('250','ABB.BANK_BRANCH_NAME' ,'BANK_BRANCH_NAME' ,
391: 'arrx_rc.var.bank_branch_name' ,'VARCHAR2', 60);
392: fa_rx_util_pkg.assign_column('260','ABB.BANK_BRANCH_NAME_ALT' ,'BANK_BRANCH_NAME_ALT' ,
393: 'arrx_rc.var.bank_branch_name_alt' ,'VARCHAR2',320);
394: fa_rx_util_pkg.assign_column('270','ABB.BANK_NUMBER' ,'BANK_NUMBER' ,
395: 'arrx_rc.var.bank_number' ,'VARCHAR2', 30);
396: fa_rx_util_pkg.assign_column('280','ABB.BRANCH_NUMBER' ,'BANK_BRANCH_NUMBER' ,
397: 'arrx_rc.var.bank_branch_number' ,'VARCHAR2', 25);

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

391: 'arrx_rc.var.bank_branch_name' ,'VARCHAR2', 60);
392: fa_rx_util_pkg.assign_column('260','ABB.BANK_BRANCH_NAME_ALT' ,'BANK_BRANCH_NAME_ALT' ,
393: 'arrx_rc.var.bank_branch_name_alt' ,'VARCHAR2',320);
394: fa_rx_util_pkg.assign_column('270','ABB.BANK_NUMBER' ,'BANK_NUMBER' ,
395: 'arrx_rc.var.bank_number' ,'VARCHAR2', 30);
396: fa_rx_util_pkg.assign_column('280','ABB.BRANCH_NUMBER' ,'BANK_BRANCH_NUMBER' ,
397: 'arrx_rc.var.bank_branch_number' ,'VARCHAR2', 25);
398: fa_rx_util_pkg.assign_column('290','CBA.BANK_ACCOUNT_NAME' ,'BANK_ACCOUNT_NAME' ,
399: 'arrx_rc.var.bank_account_name' ,'VARCHAR2', 80);

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

393: 'arrx_rc.var.bank_branch_name_alt' ,'VARCHAR2',320);
394: fa_rx_util_pkg.assign_column('270','ABB.BANK_NUMBER' ,'BANK_NUMBER' ,
395: 'arrx_rc.var.bank_number' ,'VARCHAR2', 30);
396: fa_rx_util_pkg.assign_column('280','ABB.BRANCH_NUMBER' ,'BANK_BRANCH_NUMBER' ,
397: 'arrx_rc.var.bank_branch_number' ,'VARCHAR2', 25);
398: fa_rx_util_pkg.assign_column('290','CBA.BANK_ACCOUNT_NAME' ,'BANK_ACCOUNT_NAME' ,
399: 'arrx_rc.var.bank_account_name' ,'VARCHAR2', 80);
400: fa_rx_util_pkg.assign_column('300','CBA.BANK_ACCOUNT_NAME_ALT' ,'BANK_ACCOUNT_NAME_ALT' ,
401: 'arrx_rc.var.bank_account_name_alt' ,'VARCHAR2',320);

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

395: 'arrx_rc.var.bank_number' ,'VARCHAR2', 30);
396: fa_rx_util_pkg.assign_column('280','ABB.BRANCH_NUMBER' ,'BANK_BRANCH_NUMBER' ,
397: 'arrx_rc.var.bank_branch_number' ,'VARCHAR2', 25);
398: fa_rx_util_pkg.assign_column('290','CBA.BANK_ACCOUNT_NAME' ,'BANK_ACCOUNT_NAME' ,
399: 'arrx_rc.var.bank_account_name' ,'VARCHAR2', 80);
400: fa_rx_util_pkg.assign_column('300','CBA.BANK_ACCOUNT_NAME_ALT' ,'BANK_ACCOUNT_NAME_ALT' ,
401: 'arrx_rc.var.bank_account_name_alt' ,'VARCHAR2',320);
402: fa_rx_util_pkg.assign_column('310','CBA.CURRENCY_CODE' ,'BANK_ACCOUNT_CURRENCY' ,
403: 'arrx_rc.var.bank_account_currency' ,'VARCHAR2', 15);

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

397: 'arrx_rc.var.bank_branch_number' ,'VARCHAR2', 25);
398: fa_rx_util_pkg.assign_column('290','CBA.BANK_ACCOUNT_NAME' ,'BANK_ACCOUNT_NAME' ,
399: 'arrx_rc.var.bank_account_name' ,'VARCHAR2', 80);
400: fa_rx_util_pkg.assign_column('300','CBA.BANK_ACCOUNT_NAME_ALT' ,'BANK_ACCOUNT_NAME_ALT' ,
401: 'arrx_rc.var.bank_account_name_alt' ,'VARCHAR2',320);
402: fa_rx_util_pkg.assign_column('310','CBA.CURRENCY_CODE' ,'BANK_ACCOUNT_CURRENCY' ,
403: 'arrx_rc.var.bank_account_currency' ,'VARCHAR2', 15);
404: fa_rx_util_pkg.assign_column('320','ARM.NAME' ,'RECEIPT_METHOD' ,
405: 'arrx_rc.var.receipt_method' ,'VARCHAR2', 30);

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

399: 'arrx_rc.var.bank_account_name' ,'VARCHAR2', 80);
400: fa_rx_util_pkg.assign_column('300','CBA.BANK_ACCOUNT_NAME_ALT' ,'BANK_ACCOUNT_NAME_ALT' ,
401: 'arrx_rc.var.bank_account_name_alt' ,'VARCHAR2',320);
402: fa_rx_util_pkg.assign_column('310','CBA.CURRENCY_CODE' ,'BANK_ACCOUNT_CURRENCY' ,
403: 'arrx_rc.var.bank_account_currency' ,'VARCHAR2', 15);
404: fa_rx_util_pkg.assign_column('320','ARM.NAME' ,'RECEIPT_METHOD' ,
405: 'arrx_rc.var.receipt_method' ,'VARCHAR2', 30);
406: fa_rx_util_pkg.assign_column('330','CRH.CASH_RECEIPT_HISTORY_ID' ,'CASH_RECEIPT_HISTORY_ID' ,
407: 'arrx_rc.var.cash_receipt_history_id' ,'NUMBER');

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

401: 'arrx_rc.var.bank_account_name_alt' ,'VARCHAR2',320);
402: fa_rx_util_pkg.assign_column('310','CBA.CURRENCY_CODE' ,'BANK_ACCOUNT_CURRENCY' ,
403: 'arrx_rc.var.bank_account_currency' ,'VARCHAR2', 15);
404: fa_rx_util_pkg.assign_column('320','ARM.NAME' ,'RECEIPT_METHOD' ,
405: 'arrx_rc.var.receipt_method' ,'VARCHAR2', 30);
406: fa_rx_util_pkg.assign_column('330','CRH.CASH_RECEIPT_HISTORY_ID' ,'CASH_RECEIPT_HISTORY_ID' ,
407: 'arrx_rc.var.cash_receipt_history_id' ,'NUMBER');
408: fa_rx_util_pkg.assign_column('340','CRH.GL_DATE' ,'GL_DATE' ,
409: 'arrx_rc.var.gl_date' ,'DATE');

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

403: 'arrx_rc.var.bank_account_currency' ,'VARCHAR2', 15);
404: fa_rx_util_pkg.assign_column('320','ARM.NAME' ,'RECEIPT_METHOD' ,
405: 'arrx_rc.var.receipt_method' ,'VARCHAR2', 30);
406: fa_rx_util_pkg.assign_column('330','CRH.CASH_RECEIPT_HISTORY_ID' ,'CASH_RECEIPT_HISTORY_ID' ,
407: 'arrx_rc.var.cash_receipt_history_id' ,'NUMBER');
408: fa_rx_util_pkg.assign_column('340','CRH.GL_DATE' ,'GL_DATE' ,
409: 'arrx_rc.var.gl_date' ,'DATE');
410: fa_rx_util_pkg.assign_column('350',DECODE_CRH_AMOUNT ,'RECEIPT_AMOUNT' ,
411: 'arrx_rc.var.receipt_amount' ,'NUMBER');

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

405: 'arrx_rc.var.receipt_method' ,'VARCHAR2', 30);
406: fa_rx_util_pkg.assign_column('330','CRH.CASH_RECEIPT_HISTORY_ID' ,'CASH_RECEIPT_HISTORY_ID' ,
407: 'arrx_rc.var.cash_receipt_history_id' ,'NUMBER');
408: fa_rx_util_pkg.assign_column('340','CRH.GL_DATE' ,'GL_DATE' ,
409: 'arrx_rc.var.gl_date' ,'DATE');
410: fa_rx_util_pkg.assign_column('350',DECODE_CRH_AMOUNT ,'RECEIPT_AMOUNT' ,
411: 'arrx_rc.var.receipt_amount' ,'NUMBER');
412: fa_rx_util_pkg.assign_column('360',DECODE_CRH_STATUS ,'RECEIPT_HISTORY_STATUS' ,
413: 'arrx_rc.var.receipt_history_status' ,'VARCHAR2', 40);

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

407: 'arrx_rc.var.cash_receipt_history_id' ,'NUMBER');
408: fa_rx_util_pkg.assign_column('340','CRH.GL_DATE' ,'GL_DATE' ,
409: 'arrx_rc.var.gl_date' ,'DATE');
410: fa_rx_util_pkg.assign_column('350',DECODE_CRH_AMOUNT ,'RECEIPT_AMOUNT' ,
411: 'arrx_rc.var.receipt_amount' ,'NUMBER');
412: fa_rx_util_pkg.assign_column('360',DECODE_CRH_STATUS ,'RECEIPT_HISTORY_STATUS' ,
413: 'arrx_rc.var.receipt_history_status' ,'VARCHAR2', 40);
414: fa_rx_util_pkg.assign_column('370',DECODE_CRH_ACCTD_AMOUNT ,'ACCTD_RECEIPT_AMOUNT' ,
415: 'arrx_rc.var.acctd_receipt_amount' ,'NUMBER');

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

409: 'arrx_rc.var.gl_date' ,'DATE');
410: fa_rx_util_pkg.assign_column('350',DECODE_CRH_AMOUNT ,'RECEIPT_AMOUNT' ,
411: 'arrx_rc.var.receipt_amount' ,'NUMBER');
412: fa_rx_util_pkg.assign_column('360',DECODE_CRH_STATUS ,'RECEIPT_HISTORY_STATUS' ,
413: 'arrx_rc.var.receipt_history_status' ,'VARCHAR2', 40);
414: fa_rx_util_pkg.assign_column('370',DECODE_CRH_ACCTD_AMOUNT ,'ACCTD_RECEIPT_AMOUNT' ,
415: 'arrx_rc.var.acctd_receipt_amount' ,'NUMBER');
416: fa_rx_util_pkg.assign_column('380',DECODE_CRH_FD_AMOUNT ,'FACTOR_DISCOUNT_AMOUNT' ,
417: 'arrx_rc.var.factor_discount_amount' ,'NUMBER');

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

411: 'arrx_rc.var.receipt_amount' ,'NUMBER');
412: fa_rx_util_pkg.assign_column('360',DECODE_CRH_STATUS ,'RECEIPT_HISTORY_STATUS' ,
413: 'arrx_rc.var.receipt_history_status' ,'VARCHAR2', 40);
414: fa_rx_util_pkg.assign_column('370',DECODE_CRH_ACCTD_AMOUNT ,'ACCTD_RECEIPT_AMOUNT' ,
415: 'arrx_rc.var.acctd_receipt_amount' ,'NUMBER');
416: fa_rx_util_pkg.assign_column('380',DECODE_CRH_FD_AMOUNT ,'FACTOR_DISCOUNT_AMOUNT' ,
417: 'arrx_rc.var.factor_discount_amount' ,'NUMBER');
418: fa_rx_util_pkg.assign_column('390',DECODE_CRH_AFD_AMOUNT ,'ACCTD_FACTOR_DISCOUNT_AMOUNT' ,
419: 'arrx_rc.var.acctd_factor_discount_amount' ,'NUMBER');

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

413: 'arrx_rc.var.receipt_history_status' ,'VARCHAR2', 40);
414: fa_rx_util_pkg.assign_column('370',DECODE_CRH_ACCTD_AMOUNT ,'ACCTD_RECEIPT_AMOUNT' ,
415: 'arrx_rc.var.acctd_receipt_amount' ,'NUMBER');
416: fa_rx_util_pkg.assign_column('380',DECODE_CRH_FD_AMOUNT ,'FACTOR_DISCOUNT_AMOUNT' ,
417: 'arrx_rc.var.factor_discount_amount' ,'NUMBER');
418: fa_rx_util_pkg.assign_column('390',DECODE_CRH_AFD_AMOUNT ,'ACCTD_FACTOR_DISCOUNT_AMOUNT' ,
419: 'arrx_rc.var.acctd_factor_discount_amount' ,'NUMBER');
420: fa_rx_util_pkg.assign_column('400','CC.CODE_COMBINATION_ID' ,'ACCOUNT_CODE_COMBINATION_ID' ,
421: 'arrx_rc.var.account_code_combination_id' ,'NUMBER');

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

415: 'arrx_rc.var.acctd_receipt_amount' ,'NUMBER');
416: fa_rx_util_pkg.assign_column('380',DECODE_CRH_FD_AMOUNT ,'FACTOR_DISCOUNT_AMOUNT' ,
417: 'arrx_rc.var.factor_discount_amount' ,'NUMBER');
418: fa_rx_util_pkg.assign_column('390',DECODE_CRH_AFD_AMOUNT ,'ACCTD_FACTOR_DISCOUNT_AMOUNT' ,
419: 'arrx_rc.var.acctd_factor_discount_amount' ,'NUMBER');
420: fa_rx_util_pkg.assign_column('400','CC.CODE_COMBINATION_ID' ,'ACCOUNT_CODE_COMBINATION_ID' ,
421: 'arrx_rc.var.account_code_combination_id' ,'NUMBER');
422: fa_rx_util_pkg.assign_column('410',null ,'DEBIT_ACCOUNT' ,
423: 'arrx_rc.var.debit_account' ,'VARCHAR2',240);

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

417: 'arrx_rc.var.factor_discount_amount' ,'NUMBER');
418: fa_rx_util_pkg.assign_column('390',DECODE_CRH_AFD_AMOUNT ,'ACCTD_FACTOR_DISCOUNT_AMOUNT' ,
419: 'arrx_rc.var.acctd_factor_discount_amount' ,'NUMBER');
420: fa_rx_util_pkg.assign_column('400','CC.CODE_COMBINATION_ID' ,'ACCOUNT_CODE_COMBINATION_ID' ,
421: 'arrx_rc.var.account_code_combination_id' ,'NUMBER');
422: fa_rx_util_pkg.assign_column('410',null ,'DEBIT_ACCOUNT' ,
423: 'arrx_rc.var.debit_account' ,'VARCHAR2',240);
424: fa_rx_util_pkg.assign_column('420',null ,'DEBIT_ACCOUNT_DESC' ,
425: 'arrx_rc.var.debit_account_desc' ,'VARCHAR2',240);

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

419: 'arrx_rc.var.acctd_factor_discount_amount' ,'NUMBER');
420: fa_rx_util_pkg.assign_column('400','CC.CODE_COMBINATION_ID' ,'ACCOUNT_CODE_COMBINATION_ID' ,
421: 'arrx_rc.var.account_code_combination_id' ,'NUMBER');
422: fa_rx_util_pkg.assign_column('410',null ,'DEBIT_ACCOUNT' ,
423: 'arrx_rc.var.debit_account' ,'VARCHAR2',240);
424: fa_rx_util_pkg.assign_column('420',null ,'DEBIT_ACCOUNT_DESC' ,
425: 'arrx_rc.var.debit_account_desc' ,'VARCHAR2',240);
426: fa_rx_util_pkg.assign_column('430',null ,'DEBIT_BALANCING' ,
427: 'arrx_rc.var.debit_balancing' ,'VARCHAR2',240);

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

421: 'arrx_rc.var.account_code_combination_id' ,'NUMBER');
422: fa_rx_util_pkg.assign_column('410',null ,'DEBIT_ACCOUNT' ,
423: 'arrx_rc.var.debit_account' ,'VARCHAR2',240);
424: fa_rx_util_pkg.assign_column('420',null ,'DEBIT_ACCOUNT_DESC' ,
425: 'arrx_rc.var.debit_account_desc' ,'VARCHAR2',240);
426: fa_rx_util_pkg.assign_column('430',null ,'DEBIT_BALANCING' ,
427: 'arrx_rc.var.debit_balancing' ,'VARCHAR2',240);
428: fa_rx_util_pkg.assign_column('440',null ,'DEBIT_BALANCING_DESC' ,
429: 'arrx_rc.var.debit_balancing_desc' ,'VARCHAR2',240);

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

423: 'arrx_rc.var.debit_account' ,'VARCHAR2',240);
424: fa_rx_util_pkg.assign_column('420',null ,'DEBIT_ACCOUNT_DESC' ,
425: 'arrx_rc.var.debit_account_desc' ,'VARCHAR2',240);
426: fa_rx_util_pkg.assign_column('430',null ,'DEBIT_BALANCING' ,
427: 'arrx_rc.var.debit_balancing' ,'VARCHAR2',240);
428: fa_rx_util_pkg.assign_column('440',null ,'DEBIT_BALANCING_DESC' ,
429: 'arrx_rc.var.debit_balancing_desc' ,'VARCHAR2',240);
430: fa_rx_util_pkg.assign_column('450',null ,'DEBIT_NATACCT' ,
431: 'arrx_rc.var.debit_natacct' ,'VARCHAR2',240);

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

425: 'arrx_rc.var.debit_account_desc' ,'VARCHAR2',240);
426: fa_rx_util_pkg.assign_column('430',null ,'DEBIT_BALANCING' ,
427: 'arrx_rc.var.debit_balancing' ,'VARCHAR2',240);
428: fa_rx_util_pkg.assign_column('440',null ,'DEBIT_BALANCING_DESC' ,
429: 'arrx_rc.var.debit_balancing_desc' ,'VARCHAR2',240);
430: fa_rx_util_pkg.assign_column('450',null ,'DEBIT_NATACCT' ,
431: 'arrx_rc.var.debit_natacct' ,'VARCHAR2',240);
432: fa_rx_util_pkg.assign_column('460',null ,'DEBIT_NATACCT_DESC' ,
433: 'arrx_rc.var.debit_natacct_desc' ,'VARCHAR2',240);

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

427: 'arrx_rc.var.debit_balancing' ,'VARCHAR2',240);
428: fa_rx_util_pkg.assign_column('440',null ,'DEBIT_BALANCING_DESC' ,
429: 'arrx_rc.var.debit_balancing_desc' ,'VARCHAR2',240);
430: fa_rx_util_pkg.assign_column('450',null ,'DEBIT_NATACCT' ,
431: 'arrx_rc.var.debit_natacct' ,'VARCHAR2',240);
432: fa_rx_util_pkg.assign_column('460',null ,'DEBIT_NATACCT_DESC' ,
433: 'arrx_rc.var.debit_natacct_desc' ,'VARCHAR2',240);
434: fa_rx_util_pkg.assign_column('470','CUST.CUST_ACCOUNT_ID' ,'CUSTOMER_ID' ,
435: 'arrx_rc.var.customer_id' ,'NUMBER');

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

429: 'arrx_rc.var.debit_balancing_desc' ,'VARCHAR2',240);
430: fa_rx_util_pkg.assign_column('450',null ,'DEBIT_NATACCT' ,
431: 'arrx_rc.var.debit_natacct' ,'VARCHAR2',240);
432: fa_rx_util_pkg.assign_column('460',null ,'DEBIT_NATACCT_DESC' ,
433: 'arrx_rc.var.debit_natacct_desc' ,'VARCHAR2',240);
434: fa_rx_util_pkg.assign_column('470','CUST.CUST_ACCOUNT_ID' ,'CUSTOMER_ID' ,
435: 'arrx_rc.var.customer_id' ,'NUMBER');
436: /* bug 5724171*/
437: fa_rx_util_pkg.assign_column('480','SUBSTRB(PARTY.PARTY_NAME,1,240)' ,'CUSTOMER_NAME' ,

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

431: 'arrx_rc.var.debit_natacct' ,'VARCHAR2',240);
432: fa_rx_util_pkg.assign_column('460',null ,'DEBIT_NATACCT_DESC' ,
433: 'arrx_rc.var.debit_natacct_desc' ,'VARCHAR2',240);
434: fa_rx_util_pkg.assign_column('470','CUST.CUST_ACCOUNT_ID' ,'CUSTOMER_ID' ,
435: 'arrx_rc.var.customer_id' ,'NUMBER');
436: /* bug 5724171*/
437: fa_rx_util_pkg.assign_column('480','SUBSTRB(PARTY.PARTY_NAME,1,240)' ,'CUSTOMER_NAME' ,
438: 'arrx_rc.var.customer_name' ,'VARCHAR2', 240);
439: fa_rx_util_pkg.assign_column('490','DECODE(PARTY.PARTY_TYPE, ''ORGANIZATION'',PARTY.ORGANIZATION_NAME_PHONETIC, NULL)','CUSTOMER_NAME_ALT',

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

434: fa_rx_util_pkg.assign_column('470','CUST.CUST_ACCOUNT_ID' ,'CUSTOMER_ID' ,
435: 'arrx_rc.var.customer_id' ,'NUMBER');
436: /* bug 5724171*/
437: fa_rx_util_pkg.assign_column('480','SUBSTRB(PARTY.PARTY_NAME,1,240)' ,'CUSTOMER_NAME' ,
438: 'arrx_rc.var.customer_name' ,'VARCHAR2', 240);
439: fa_rx_util_pkg.assign_column('490','DECODE(PARTY.PARTY_TYPE, ''ORGANIZATION'',PARTY.ORGANIZATION_NAME_PHONETIC, NULL)','CUSTOMER_NAME_ALT',
440: 'arrx_rc.var.customer_name_alt' ,'VARCHAR2',320);
441: fa_rx_util_pkg.assign_column('500','CUST.ACCOUNT_NUMBER' ,'CUSTOMER_NUMBER' ,
442: 'arrx_rc.var.customer_number' ,'VARCHAR2', 30);

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

436: /* bug 5724171*/
437: fa_rx_util_pkg.assign_column('480','SUBSTRB(PARTY.PARTY_NAME,1,240)' ,'CUSTOMER_NAME' ,
438: 'arrx_rc.var.customer_name' ,'VARCHAR2', 240);
439: fa_rx_util_pkg.assign_column('490','DECODE(PARTY.PARTY_TYPE, ''ORGANIZATION'',PARTY.ORGANIZATION_NAME_PHONETIC, NULL)','CUSTOMER_NAME_ALT',
440: 'arrx_rc.var.customer_name_alt' ,'VARCHAR2',320);
441: fa_rx_util_pkg.assign_column('500','CUST.ACCOUNT_NUMBER' ,'CUSTOMER_NUMBER' ,
442: 'arrx_rc.var.customer_number' ,'VARCHAR2', 30);
443:
444: -- define FROM_CLAUSE

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

438: 'arrx_rc.var.customer_name' ,'VARCHAR2', 240);
439: fa_rx_util_pkg.assign_column('490','DECODE(PARTY.PARTY_TYPE, ''ORGANIZATION'',PARTY.ORGANIZATION_NAME_PHONETIC, NULL)','CUSTOMER_NAME_ALT',
440: 'arrx_rc.var.customer_name_alt' ,'VARCHAR2',320);
441: fa_rx_util_pkg.assign_column('500','CUST.ACCOUNT_NUMBER' ,'CUSTOMER_NUMBER' ,
442: 'arrx_rc.var.customer_number' ,'VARCHAR2', 30);
443:
444: -- define FROM_CLAUSE
445: IF var.calling_program in ('RECEIPT','APPLIED','MISC','ACTUAL') then
446:

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

705:
706: DECODE_RA_STATUS := 'DECODE(RA.STATUS,''ACC'',:L_ACCO,''APP'',:L_APPL,''UNAPP'',:L_UNAPPL,''UNID'',:L_UNIDE)';
707:
708: fa_rx_util_pkg.assign_column('A1 ','RA.RECEIVABLE_APPLICATION_ID' ,'RECEIVABLE_APPLICATION_ID',
709: 'arrx_rc.var.receivable_application_id' ,'NUMBER');
710: fa_rx_util_pkg.assign_column('A2 ','RA.APPLY_DATE','APPLY_DATE',
711: 'arrx_rc.var.apply_date' ,'DATE');
712: fa_rx_util_pkg.assign_column('A3 ',DECODE_RA_STATUS,'APPLICATION_STATUS',
713: 'arrx_rc.var.application_status' ,'VARCHAR2', 20);

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

707:
708: fa_rx_util_pkg.assign_column('A1 ','RA.RECEIVABLE_APPLICATION_ID' ,'RECEIVABLE_APPLICATION_ID',
709: 'arrx_rc.var.receivable_application_id' ,'NUMBER');
710: fa_rx_util_pkg.assign_column('A2 ','RA.APPLY_DATE','APPLY_DATE',
711: 'arrx_rc.var.apply_date' ,'DATE');
712: fa_rx_util_pkg.assign_column('A3 ',DECODE_RA_STATUS,'APPLICATION_STATUS',
713: 'arrx_rc.var.application_status' ,'VARCHAR2', 20);
714: fa_rx_util_pkg.assign_column('A4 ','RA.AMOUNT_APPLIED' ,'AMOUNT_APPLIED_TO',
715: 'arrx_rc.var.amount_applied_to' ,'NUMBER');

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

709: 'arrx_rc.var.receivable_application_id' ,'NUMBER');
710: fa_rx_util_pkg.assign_column('A2 ','RA.APPLY_DATE','APPLY_DATE',
711: 'arrx_rc.var.apply_date' ,'DATE');
712: fa_rx_util_pkg.assign_column('A3 ',DECODE_RA_STATUS,'APPLICATION_STATUS',
713: 'arrx_rc.var.application_status' ,'VARCHAR2', 20);
714: fa_rx_util_pkg.assign_column('A4 ','RA.AMOUNT_APPLIED' ,'AMOUNT_APPLIED_TO',
715: 'arrx_rc.var.amount_applied_to' ,'NUMBER');
716: fa_rx_util_pkg.assign_column('A5 ','NVL(RA.AMOUNT_APPLIED_FROM,RA.AMOUNT_APPLIED)' ,'AMOUNT_APPLIED_FROM',
717: 'arrx_rc.var.amount_applied_from' ,'NUMBER');

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

711: 'arrx_rc.var.apply_date' ,'DATE');
712: fa_rx_util_pkg.assign_column('A3 ',DECODE_RA_STATUS,'APPLICATION_STATUS',
713: 'arrx_rc.var.application_status' ,'VARCHAR2', 20);
714: fa_rx_util_pkg.assign_column('A4 ','RA.AMOUNT_APPLIED' ,'AMOUNT_APPLIED_TO',
715: 'arrx_rc.var.amount_applied_to' ,'NUMBER');
716: fa_rx_util_pkg.assign_column('A5 ','NVL(RA.AMOUNT_APPLIED_FROM,RA.AMOUNT_APPLIED)' ,'AMOUNT_APPLIED_FROM',
717: 'arrx_rc.var.amount_applied_from' ,'NUMBER');
718: fa_rx_util_pkg.assign_column('A6 ','NVL(RA.ACCTD_AMOUNT_APPLIED_TO,RA.ACCTD_AMOUNT_APPLIED_FROM)' ,'ACCTD_AMOUNT_APPLIED_TO',
719: 'arrx_rc.var.acctd_amount_applied_to' ,'NUMBER');

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

713: 'arrx_rc.var.application_status' ,'VARCHAR2', 20);
714: fa_rx_util_pkg.assign_column('A4 ','RA.AMOUNT_APPLIED' ,'AMOUNT_APPLIED_TO',
715: 'arrx_rc.var.amount_applied_to' ,'NUMBER');
716: fa_rx_util_pkg.assign_column('A5 ','NVL(RA.AMOUNT_APPLIED_FROM,RA.AMOUNT_APPLIED)' ,'AMOUNT_APPLIED_FROM',
717: 'arrx_rc.var.amount_applied_from' ,'NUMBER');
718: fa_rx_util_pkg.assign_column('A6 ','NVL(RA.ACCTD_AMOUNT_APPLIED_TO,RA.ACCTD_AMOUNT_APPLIED_FROM)' ,'ACCTD_AMOUNT_APPLIED_TO',
719: 'arrx_rc.var.acctd_amount_applied_to' ,'NUMBER');
720: fa_rx_util_pkg.assign_column('A7 ','RA.ACCTD_AMOUNT_APPLIED_FROM' ,'ACCTD_AMOUNT_APPLIED_FROM',
721: 'arrx_rc.var.acctd_amount_applied_from' ,'NUMBER');

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

715: 'arrx_rc.var.amount_applied_to' ,'NUMBER');
716: fa_rx_util_pkg.assign_column('A5 ','NVL(RA.AMOUNT_APPLIED_FROM,RA.AMOUNT_APPLIED)' ,'AMOUNT_APPLIED_FROM',
717: 'arrx_rc.var.amount_applied_from' ,'NUMBER');
718: fa_rx_util_pkg.assign_column('A6 ','NVL(RA.ACCTD_AMOUNT_APPLIED_TO,RA.ACCTD_AMOUNT_APPLIED_FROM)' ,'ACCTD_AMOUNT_APPLIED_TO',
719: 'arrx_rc.var.acctd_amount_applied_to' ,'NUMBER');
720: fa_rx_util_pkg.assign_column('A7 ','RA.ACCTD_AMOUNT_APPLIED_FROM' ,'ACCTD_AMOUNT_APPLIED_FROM',
721: 'arrx_rc.var.acctd_amount_applied_from' ,'NUMBER');
722: fa_rx_util_pkg.assign_column('A8 ','RA.EARNED_DISCOUNT_TAKEN' ,'EARNED_DISCOUNT_TAKEN',
723: 'arrx_rc.var.earned_discount_taken' ,'NUMBER');

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

717: 'arrx_rc.var.amount_applied_from' ,'NUMBER');
718: fa_rx_util_pkg.assign_column('A6 ','NVL(RA.ACCTD_AMOUNT_APPLIED_TO,RA.ACCTD_AMOUNT_APPLIED_FROM)' ,'ACCTD_AMOUNT_APPLIED_TO',
719: 'arrx_rc.var.acctd_amount_applied_to' ,'NUMBER');
720: fa_rx_util_pkg.assign_column('A7 ','RA.ACCTD_AMOUNT_APPLIED_FROM' ,'ACCTD_AMOUNT_APPLIED_FROM',
721: 'arrx_rc.var.acctd_amount_applied_from' ,'NUMBER');
722: fa_rx_util_pkg.assign_column('A8 ','RA.EARNED_DISCOUNT_TAKEN' ,'EARNED_DISCOUNT_TAKEN',
723: 'arrx_rc.var.earned_discount_taken' ,'NUMBER');
724: fa_rx_util_pkg.assign_column('A9 ','RA.UNEARNED_DISCOUNT_TAKEN','UNEARNED_DISCOUNT_TAKEN',
725: 'arrx_rc.var.unearned_discount_taken' ,'NUMBER');

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

719: 'arrx_rc.var.acctd_amount_applied_to' ,'NUMBER');
720: fa_rx_util_pkg.assign_column('A7 ','RA.ACCTD_AMOUNT_APPLIED_FROM' ,'ACCTD_AMOUNT_APPLIED_FROM',
721: 'arrx_rc.var.acctd_amount_applied_from' ,'NUMBER');
722: fa_rx_util_pkg.assign_column('A8 ','RA.EARNED_DISCOUNT_TAKEN' ,'EARNED_DISCOUNT_TAKEN',
723: 'arrx_rc.var.earned_discount_taken' ,'NUMBER');
724: fa_rx_util_pkg.assign_column('A9 ','RA.UNEARNED_DISCOUNT_TAKEN','UNEARNED_DISCOUNT_TAKEN',
725: 'arrx_rc.var.unearned_discount_taken' ,'NUMBER');
726: fa_rx_util_pkg.assign_column('A10','RA.ACCTD_EARNED_DISCOUNT_TAKEN' ,'ACCTD_EARNED_DISCOUNT_TAKEN',
727: 'arrx_rc.var.acctd_earned_discount_taken' ,'NUMBER');

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

721: 'arrx_rc.var.acctd_amount_applied_from' ,'NUMBER');
722: fa_rx_util_pkg.assign_column('A8 ','RA.EARNED_DISCOUNT_TAKEN' ,'EARNED_DISCOUNT_TAKEN',
723: 'arrx_rc.var.earned_discount_taken' ,'NUMBER');
724: fa_rx_util_pkg.assign_column('A9 ','RA.UNEARNED_DISCOUNT_TAKEN','UNEARNED_DISCOUNT_TAKEN',
725: 'arrx_rc.var.unearned_discount_taken' ,'NUMBER');
726: fa_rx_util_pkg.assign_column('A10','RA.ACCTD_EARNED_DISCOUNT_TAKEN' ,'ACCTD_EARNED_DISCOUNT_TAKEN',
727: 'arrx_rc.var.acctd_earned_discount_taken' ,'NUMBER');
728: fa_rx_util_pkg.assign_column('A11','RA.ACCTD_UNEARNED_DISCOUNT_TAKEN' ,'ACCTD_UNEARNED_DISCOUNT_TAKEN',
729: 'arrx_rc.var.acctd_unearned_discount_taken' ,'NUMBER');

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

723: 'arrx_rc.var.earned_discount_taken' ,'NUMBER');
724: fa_rx_util_pkg.assign_column('A9 ','RA.UNEARNED_DISCOUNT_TAKEN','UNEARNED_DISCOUNT_TAKEN',
725: 'arrx_rc.var.unearned_discount_taken' ,'NUMBER');
726: fa_rx_util_pkg.assign_column('A10','RA.ACCTD_EARNED_DISCOUNT_TAKEN' ,'ACCTD_EARNED_DISCOUNT_TAKEN',
727: 'arrx_rc.var.acctd_earned_discount_taken' ,'NUMBER');
728: fa_rx_util_pkg.assign_column('A11','RA.ACCTD_UNEARNED_DISCOUNT_TAKEN' ,'ACCTD_UNEARNED_DISCOUNT_TAKEN',
729: 'arrx_rc.var.acctd_unearned_discount_taken' ,'NUMBER');
730: fa_rx_util_pkg.assign_column('A12','TRX.CUSTOMER_TRX_ID' ,'APPLIED_CUSTOMER_TRX_ID',
731: 'arrx_rc.var.applied_customer_trx_id' ,'NUMBER');

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

725: 'arrx_rc.var.unearned_discount_taken' ,'NUMBER');
726: fa_rx_util_pkg.assign_column('A10','RA.ACCTD_EARNED_DISCOUNT_TAKEN' ,'ACCTD_EARNED_DISCOUNT_TAKEN',
727: 'arrx_rc.var.acctd_earned_discount_taken' ,'NUMBER');
728: fa_rx_util_pkg.assign_column('A11','RA.ACCTD_UNEARNED_DISCOUNT_TAKEN' ,'ACCTD_UNEARNED_DISCOUNT_TAKEN',
729: 'arrx_rc.var.acctd_unearned_discount_taken' ,'NUMBER');
730: fa_rx_util_pkg.assign_column('A12','TRX.CUSTOMER_TRX_ID' ,'APPLIED_CUSTOMER_TRX_ID',
731: 'arrx_rc.var.applied_customer_trx_id' ,'NUMBER');
732: fa_rx_util_pkg.assign_column('A13','DECODE(RA.STATUS, ''ACC'', :l_trx_on_acc, TRX.TRX_NUMBER)','TRX_NUMBER' ,
733: 'arrx_rc.var.trx_number','VARCHAR2', 20);

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

727: 'arrx_rc.var.acctd_earned_discount_taken' ,'NUMBER');
728: fa_rx_util_pkg.assign_column('A11','RA.ACCTD_UNEARNED_DISCOUNT_TAKEN' ,'ACCTD_UNEARNED_DISCOUNT_TAKEN',
729: 'arrx_rc.var.acctd_unearned_discount_taken' ,'NUMBER');
730: fa_rx_util_pkg.assign_column('A12','TRX.CUSTOMER_TRX_ID' ,'APPLIED_CUSTOMER_TRX_ID',
731: 'arrx_rc.var.applied_customer_trx_id' ,'NUMBER');
732: fa_rx_util_pkg.assign_column('A13','DECODE(RA.STATUS, ''ACC'', :l_trx_on_acc, TRX.TRX_NUMBER)','TRX_NUMBER' ,
733: 'arrx_rc.var.trx_number','VARCHAR2', 20);
734: fa_rx_util_pkg.assign_column('A14','TRX.INVOICE_CURRENCY_CODE','TRX_CURRENCY_CODE',
735: 'arrx_rc.var.trx_currency_code' ,'VARCHAR2', 15);

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

729: 'arrx_rc.var.acctd_unearned_discount_taken' ,'NUMBER');
730: fa_rx_util_pkg.assign_column('A12','TRX.CUSTOMER_TRX_ID' ,'APPLIED_CUSTOMER_TRX_ID',
731: 'arrx_rc.var.applied_customer_trx_id' ,'NUMBER');
732: fa_rx_util_pkg.assign_column('A13','DECODE(RA.STATUS, ''ACC'', :l_trx_on_acc, TRX.TRX_NUMBER)','TRX_NUMBER' ,
733: 'arrx_rc.var.trx_number','VARCHAR2', 20);
734: fa_rx_util_pkg.assign_column('A14','TRX.INVOICE_CURRENCY_CODE','TRX_CURRENCY_CODE',
735: 'arrx_rc.var.trx_currency_code' ,'VARCHAR2', 15);
736: fa_rx_util_pkg.assign_column('A15','TRX.TRX_DATE','TRX_DATE',
737: 'arrx_rc.var.trx_date','DATE');

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

731: 'arrx_rc.var.applied_customer_trx_id' ,'NUMBER');
732: fa_rx_util_pkg.assign_column('A13','DECODE(RA.STATUS, ''ACC'', :l_trx_on_acc, TRX.TRX_NUMBER)','TRX_NUMBER' ,
733: 'arrx_rc.var.trx_number','VARCHAR2', 20);
734: fa_rx_util_pkg.assign_column('A14','TRX.INVOICE_CURRENCY_CODE','TRX_CURRENCY_CODE',
735: 'arrx_rc.var.trx_currency_code' ,'VARCHAR2', 15);
736: fa_rx_util_pkg.assign_column('A15','TRX.TRX_DATE','TRX_DATE',
737: 'arrx_rc.var.trx_date','DATE');
738: fa_rx_util_pkg.assign_column('A16','REC.AMOUNT','TRX_AMOUNT' ,
739: 'arrx_rc.var.trx_amount','NUMBER');

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

733: 'arrx_rc.var.trx_number','VARCHAR2', 20);
734: fa_rx_util_pkg.assign_column('A14','TRX.INVOICE_CURRENCY_CODE','TRX_CURRENCY_CODE',
735: 'arrx_rc.var.trx_currency_code' ,'VARCHAR2', 15);
736: fa_rx_util_pkg.assign_column('A15','TRX.TRX_DATE','TRX_DATE',
737: 'arrx_rc.var.trx_date','DATE');
738: fa_rx_util_pkg.assign_column('A16','REC.AMOUNT','TRX_AMOUNT' ,
739: 'arrx_rc.var.trx_amount','NUMBER');
740: fa_rx_util_pkg.assign_column('A17','REC.ACCTD_AMOUNT' ,'ACCTD_TRX_AMOUNT',
741: 'arrx_rc.var.acctd_trx_amount' ,'NUMBER');

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

735: 'arrx_rc.var.trx_currency_code' ,'VARCHAR2', 15);
736: fa_rx_util_pkg.assign_column('A15','TRX.TRX_DATE','TRX_DATE',
737: 'arrx_rc.var.trx_date','DATE');
738: fa_rx_util_pkg.assign_column('A16','REC.AMOUNT','TRX_AMOUNT' ,
739: 'arrx_rc.var.trx_amount','NUMBER');
740: fa_rx_util_pkg.assign_column('A17','REC.ACCTD_AMOUNT' ,'ACCTD_TRX_AMOUNT',
741: 'arrx_rc.var.acctd_trx_amount' ,'NUMBER');
742:
743: fa_rx_util_pkg.debug('Define additional FROM_CLAUSE for Actual Receipts Register');

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

737: 'arrx_rc.var.trx_date','DATE');
738: fa_rx_util_pkg.assign_column('A16','REC.AMOUNT','TRX_AMOUNT' ,
739: 'arrx_rc.var.trx_amount','NUMBER');
740: fa_rx_util_pkg.assign_column('A17','REC.ACCTD_AMOUNT' ,'ACCTD_TRX_AMOUNT',
741: 'arrx_rc.var.acctd_trx_amount' ,'NUMBER');
742:
743: fa_rx_util_pkg.debug('Define additional FROM_CLAUSE for Actual Receipts Register');
744:
745: IF NVL(var.ca_sob_type,'P') = 'P' THEN

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

880:
881: fa_rx_util_pkg.debug('Define additional ASSIGN_COLUMNS for Applied Receipts Register');
882:
883: fa_rx_util_pkg.assign_column('A1 ','RA.RECEIVABLE_APPLICATION_ID' ,'RECEIVABLE_APPLICATION_ID',
884: 'arrx_rc.var.receivable_application_id' ,'NUMBER');
885: fa_rx_util_pkg.assign_column('A2 ','RA.APPLY_DATE' ,'APPLY_DATE' ,
886: 'arrx_rc.var.apply_date','DATE');
887: fa_rx_util_pkg.assign_column('A3 ','RAC.ACCOUNT_NUMBER' ,'RELATED_CUSTOMER' ,
888: 'arrx_rc.var.related_customer','VARCHAR2', 50);

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

882:
883: fa_rx_util_pkg.assign_column('A1 ','RA.RECEIVABLE_APPLICATION_ID' ,'RECEIVABLE_APPLICATION_ID',
884: 'arrx_rc.var.receivable_application_id' ,'NUMBER');
885: fa_rx_util_pkg.assign_column('A2 ','RA.APPLY_DATE' ,'APPLY_DATE' ,
886: 'arrx_rc.var.apply_date','DATE');
887: fa_rx_util_pkg.assign_column('A3 ','RAC.ACCOUNT_NUMBER' ,'RELATED_CUSTOMER' ,
888: 'arrx_rc.var.related_customer','VARCHAR2', 50);
889: fa_rx_util_pkg.assign_column('A4 ','NVL(RA.AMOUNT_APPLIED,0)','AMOUNT_APPLIED_TO',
890: 'arrx_rc.var.amount_applied_to' ,'NUMBER');

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

884: 'arrx_rc.var.receivable_application_id' ,'NUMBER');
885: fa_rx_util_pkg.assign_column('A2 ','RA.APPLY_DATE' ,'APPLY_DATE' ,
886: 'arrx_rc.var.apply_date','DATE');
887: fa_rx_util_pkg.assign_column('A3 ','RAC.ACCOUNT_NUMBER' ,'RELATED_CUSTOMER' ,
888: 'arrx_rc.var.related_customer','VARCHAR2', 50);
889: fa_rx_util_pkg.assign_column('A4 ','NVL(RA.AMOUNT_APPLIED,0)','AMOUNT_APPLIED_TO',
890: 'arrx_rc.var.amount_applied_to' ,'NUMBER');
891: fa_rx_util_pkg.assign_column('A5 ','NVL(RA.AMOUNT_APPLIED_FROM,RA.AMOUNT_APPLIED)' ,'AMOUNT_APPLIED_FROM',
892: 'arrx_rc.var.amount_applied_from' ,'NUMBER');

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

886: 'arrx_rc.var.apply_date','DATE');
887: fa_rx_util_pkg.assign_column('A3 ','RAC.ACCOUNT_NUMBER' ,'RELATED_CUSTOMER' ,
888: 'arrx_rc.var.related_customer','VARCHAR2', 50);
889: fa_rx_util_pkg.assign_column('A4 ','NVL(RA.AMOUNT_APPLIED,0)','AMOUNT_APPLIED_TO',
890: 'arrx_rc.var.amount_applied_to' ,'NUMBER');
891: fa_rx_util_pkg.assign_column('A5 ','NVL(RA.AMOUNT_APPLIED_FROM,RA.AMOUNT_APPLIED)' ,'AMOUNT_APPLIED_FROM',
892: 'arrx_rc.var.amount_applied_from' ,'NUMBER');
893: fa_rx_util_pkg.assign_column('A6 ',applied_total ,'ACCTD_AMOUNT_APPLIED_TO',
894: 'arrx_rc.var.acctd_amount_applied_to' ,'NUMBER');

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

888: 'arrx_rc.var.related_customer','VARCHAR2', 50);
889: fa_rx_util_pkg.assign_column('A4 ','NVL(RA.AMOUNT_APPLIED,0)','AMOUNT_APPLIED_TO',
890: 'arrx_rc.var.amount_applied_to' ,'NUMBER');
891: fa_rx_util_pkg.assign_column('A5 ','NVL(RA.AMOUNT_APPLIED_FROM,RA.AMOUNT_APPLIED)' ,'AMOUNT_APPLIED_FROM',
892: 'arrx_rc.var.amount_applied_from' ,'NUMBER');
893: fa_rx_util_pkg.assign_column('A6 ',applied_total ,'ACCTD_AMOUNT_APPLIED_TO',
894: 'arrx_rc.var.acctd_amount_applied_to' ,'NUMBER');
895: fa_rx_util_pkg.assign_column('A7 ','NVL(RA.ACCTD_AMOUNT_APPLIED_FROM,0)' ,'ACCTD_AMOUNT_APPLIED_FROM',
896: 'arrx_rc.var.acctd_amount_applied_from' ,'NUMBER');

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

890: 'arrx_rc.var.amount_applied_to' ,'NUMBER');
891: fa_rx_util_pkg.assign_column('A5 ','NVL(RA.AMOUNT_APPLIED_FROM,RA.AMOUNT_APPLIED)' ,'AMOUNT_APPLIED_FROM',
892: 'arrx_rc.var.amount_applied_from' ,'NUMBER');
893: fa_rx_util_pkg.assign_column('A6 ',applied_total ,'ACCTD_AMOUNT_APPLIED_TO',
894: 'arrx_rc.var.acctd_amount_applied_to' ,'NUMBER');
895: fa_rx_util_pkg.assign_column('A7 ','NVL(RA.ACCTD_AMOUNT_APPLIED_FROM,0)' ,'ACCTD_AMOUNT_APPLIED_FROM',
896: 'arrx_rc.var.acctd_amount_applied_from' ,'NUMBER');
897: fa_rx_util_pkg.assign_column('A8 ','NVL(RA.EARNED_DISCOUNT_TAKEN,0)' ,'EARNED_DISCOUNT_TAKEN',
898: 'arrx_rc.var.earned_discount_taken' ,'NUMBER');

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

892: 'arrx_rc.var.amount_applied_from' ,'NUMBER');
893: fa_rx_util_pkg.assign_column('A6 ',applied_total ,'ACCTD_AMOUNT_APPLIED_TO',
894: 'arrx_rc.var.acctd_amount_applied_to' ,'NUMBER');
895: fa_rx_util_pkg.assign_column('A7 ','NVL(RA.ACCTD_AMOUNT_APPLIED_FROM,0)' ,'ACCTD_AMOUNT_APPLIED_FROM',
896: 'arrx_rc.var.acctd_amount_applied_from' ,'NUMBER');
897: fa_rx_util_pkg.assign_column('A8 ','NVL(RA.EARNED_DISCOUNT_TAKEN,0)' ,'EARNED_DISCOUNT_TAKEN',
898: 'arrx_rc.var.earned_discount_taken' ,'NUMBER');
899: fa_rx_util_pkg.assign_column('A9 ','NVL(RA.UNEARNED_DISCOUNT_TAKEN,0)' ,'UNEARNED_DISCOUNT_TAKEN',
900: 'arrx_rc.var.unearned_discount_taken' ,'NUMBER');

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

894: 'arrx_rc.var.acctd_amount_applied_to' ,'NUMBER');
895: fa_rx_util_pkg.assign_column('A7 ','NVL(RA.ACCTD_AMOUNT_APPLIED_FROM,0)' ,'ACCTD_AMOUNT_APPLIED_FROM',
896: 'arrx_rc.var.acctd_amount_applied_from' ,'NUMBER');
897: fa_rx_util_pkg.assign_column('A8 ','NVL(RA.EARNED_DISCOUNT_TAKEN,0)' ,'EARNED_DISCOUNT_TAKEN',
898: 'arrx_rc.var.earned_discount_taken' ,'NUMBER');
899: fa_rx_util_pkg.assign_column('A9 ','NVL(RA.UNEARNED_DISCOUNT_TAKEN,0)' ,'UNEARNED_DISCOUNT_TAKEN',
900: 'arrx_rc.var.unearned_discount_taken' ,'NUMBER');
901: fa_rx_util_pkg.assign_column('A10','NVL(RA.ACCTD_EARNED_DISCOUNT_TAKEN,0)' ,'ACCTD_EARNED_DISCOUNT_TAKEN',
902: 'arrx_rc.var.acctd_earned_discount_taken' ,'NUMBER');

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

896: 'arrx_rc.var.acctd_amount_applied_from' ,'NUMBER');
897: fa_rx_util_pkg.assign_column('A8 ','NVL(RA.EARNED_DISCOUNT_TAKEN,0)' ,'EARNED_DISCOUNT_TAKEN',
898: 'arrx_rc.var.earned_discount_taken' ,'NUMBER');
899: fa_rx_util_pkg.assign_column('A9 ','NVL(RA.UNEARNED_DISCOUNT_TAKEN,0)' ,'UNEARNED_DISCOUNT_TAKEN',
900: 'arrx_rc.var.unearned_discount_taken' ,'NUMBER');
901: fa_rx_util_pkg.assign_column('A10','NVL(RA.ACCTD_EARNED_DISCOUNT_TAKEN,0)' ,'ACCTD_EARNED_DISCOUNT_TAKEN',
902: 'arrx_rc.var.acctd_earned_discount_taken' ,'NUMBER');
903: fa_rx_util_pkg.assign_column('A11','NVL(RA.ACCTD_UNEARNED_DISCOUNT_TAKEN,0)' ,'ACCTD_UNEARNED_DISCOUNT_TAKEN',
904: 'arrx_rc.var.acctd_unearned_discount_taken' ,'NUMBER');

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

898: 'arrx_rc.var.earned_discount_taken' ,'NUMBER');
899: fa_rx_util_pkg.assign_column('A9 ','NVL(RA.UNEARNED_DISCOUNT_TAKEN,0)' ,'UNEARNED_DISCOUNT_TAKEN',
900: 'arrx_rc.var.unearned_discount_taken' ,'NUMBER');
901: fa_rx_util_pkg.assign_column('A10','NVL(RA.ACCTD_EARNED_DISCOUNT_TAKEN,0)' ,'ACCTD_EARNED_DISCOUNT_TAKEN',
902: 'arrx_rc.var.acctd_earned_discount_taken' ,'NUMBER');
903: fa_rx_util_pkg.assign_column('A11','NVL(RA.ACCTD_UNEARNED_DISCOUNT_TAKEN,0)' ,'ACCTD_UNEARNED_DISCOUNT_TAKEN',
904: 'arrx_rc.var.acctd_unearned_discount_taken' ,'NUMBER');
905: fa_rx_util_pkg.assign_column('A12','TRX.CUSTOMER_TRX_ID' ,'APPLIED_CUSTOMER_TRX_ID',
906: 'arrx_rc.var.applied_customer_trx_id' ,'NUMBER');

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

900: 'arrx_rc.var.unearned_discount_taken' ,'NUMBER');
901: fa_rx_util_pkg.assign_column('A10','NVL(RA.ACCTD_EARNED_DISCOUNT_TAKEN,0)' ,'ACCTD_EARNED_DISCOUNT_TAKEN',
902: 'arrx_rc.var.acctd_earned_discount_taken' ,'NUMBER');
903: fa_rx_util_pkg.assign_column('A11','NVL(RA.ACCTD_UNEARNED_DISCOUNT_TAKEN,0)' ,'ACCTD_UNEARNED_DISCOUNT_TAKEN',
904: 'arrx_rc.var.acctd_unearned_discount_taken' ,'NUMBER');
905: fa_rx_util_pkg.assign_column('A12','TRX.CUSTOMER_TRX_ID' ,'APPLIED_CUSTOMER_TRX_ID',
906: 'arrx_rc.var.applied_customer_trx_id' ,'NUMBER');
907:
908: IF (BILL_FLAG = 'Y') THEN

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

902: 'arrx_rc.var.acctd_earned_discount_taken' ,'NUMBER');
903: fa_rx_util_pkg.assign_column('A11','NVL(RA.ACCTD_UNEARNED_DISCOUNT_TAKEN,0)' ,'ACCTD_UNEARNED_DISCOUNT_TAKEN',
904: 'arrx_rc.var.acctd_unearned_discount_taken' ,'NUMBER');
905: fa_rx_util_pkg.assign_column('A12','TRX.CUSTOMER_TRX_ID' ,'APPLIED_CUSTOMER_TRX_ID',
906: 'arrx_rc.var.applied_customer_trx_id' ,'NUMBER');
907:
908: IF (BILL_FLAG = 'Y') THEN
909: fa_rx_util_pkg.assign_column('A13','decode(ra.status, ''ACC'', :L_ONACCOUNT
910: , decode(ci.cons_billing_number, null, ps.trx_number

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

908: IF (BILL_FLAG = 'Y') THEN
909: fa_rx_util_pkg.assign_column('A13','decode(ra.status, ''ACC'', :L_ONACCOUNT
910: , decode(ci.cons_billing_number, null, ps.trx_number
911: , substrb(rtrim(ci.cons_billing_number)||''/''||rtrim(to_char(trx.trx_number)),1,30)))' ,'TRX_NUMBER',
912: 'arrx_rc.var.trx_number' ,'VARCHAR2', 30);-- bug 5767413
913: ELSE
914: fa_rx_util_pkg.assign_column('A13','decode(ra.status, ''ACC'', :L_ONACCOUNT, PS.TRX_NUMBER)','TRX_NUMBER' ,
915: 'arrx_rc.var.trx_number','VARCHAR2', 30);--bug 5767413
916: END IF;

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

911: , substrb(rtrim(ci.cons_billing_number)||''/''||rtrim(to_char(trx.trx_number)),1,30)))' ,'TRX_NUMBER',
912: 'arrx_rc.var.trx_number' ,'VARCHAR2', 30);-- bug 5767413
913: ELSE
914: fa_rx_util_pkg.assign_column('A13','decode(ra.status, ''ACC'', :L_ONACCOUNT, PS.TRX_NUMBER)','TRX_NUMBER' ,
915: 'arrx_rc.var.trx_number','VARCHAR2', 30);--bug 5767413
916: END IF;
917:
918: fa_rx_util_pkg.assign_column('A14','TRX.INVOICE_CURRENCY_CODE' ,'TRX_CURRENCY_CODE',
919: 'arrx_rc.var.trx_currency_code' ,'VARCHAR2', 15);

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

915: 'arrx_rc.var.trx_number','VARCHAR2', 30);--bug 5767413
916: END IF;
917:
918: fa_rx_util_pkg.assign_column('A14','TRX.INVOICE_CURRENCY_CODE' ,'TRX_CURRENCY_CODE',
919: 'arrx_rc.var.trx_currency_code' ,'VARCHAR2', 15);
920: fa_rx_util_pkg.assign_column('A15','TRX.TRX_DATE' ,'TRX_DATE' ,
921: 'arrx_rc.var.trx_date','DATE');
922: fa_rx_util_pkg.assign_column('A16','NVL(REC.AMOUNT,0)' ,'TRX_AMOUNT' ,
923: 'arrx_rc.var.trx_amount','NUMBER');

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

917:
918: fa_rx_util_pkg.assign_column('A14','TRX.INVOICE_CURRENCY_CODE' ,'TRX_CURRENCY_CODE',
919: 'arrx_rc.var.trx_currency_code' ,'VARCHAR2', 15);
920: fa_rx_util_pkg.assign_column('A15','TRX.TRX_DATE' ,'TRX_DATE' ,
921: 'arrx_rc.var.trx_date','DATE');
922: fa_rx_util_pkg.assign_column('A16','NVL(REC.AMOUNT,0)' ,'TRX_AMOUNT' ,
923: 'arrx_rc.var.trx_amount','NUMBER');
924: fa_rx_util_pkg.assign_column('A17','NVL(REC.ACCTD_AMOUNT,0)' ,'ACCTD_TRX_AMOUNT',
925: 'arrx_rc.var.acctd_trx_amount' ,'NUMBER');

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

919: 'arrx_rc.var.trx_currency_code' ,'VARCHAR2', 15);
920: fa_rx_util_pkg.assign_column('A15','TRX.TRX_DATE' ,'TRX_DATE' ,
921: 'arrx_rc.var.trx_date','DATE');
922: fa_rx_util_pkg.assign_column('A16','NVL(REC.AMOUNT,0)' ,'TRX_AMOUNT' ,
923: 'arrx_rc.var.trx_amount','NUMBER');
924: fa_rx_util_pkg.assign_column('A17','NVL(REC.ACCTD_AMOUNT,0)' ,'ACCTD_TRX_AMOUNT',
925: 'arrx_rc.var.acctd_trx_amount' ,'NUMBER');
926: fa_rx_util_pkg.assign_column('A18',rec_gain_loss ,'RECEIPT_GAIN_LOSS',
927: 'arrx_rc.var.receipt_gain_loss' ,'NUMBER');

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

921: 'arrx_rc.var.trx_date','DATE');
922: fa_rx_util_pkg.assign_column('A16','NVL(REC.AMOUNT,0)' ,'TRX_AMOUNT' ,
923: 'arrx_rc.var.trx_amount','NUMBER');
924: fa_rx_util_pkg.assign_column('A17','NVL(REC.ACCTD_AMOUNT,0)' ,'ACCTD_TRX_AMOUNT',
925: 'arrx_rc.var.acctd_trx_amount' ,'NUMBER');
926: fa_rx_util_pkg.assign_column('A18',rec_gain_loss ,'RECEIPT_GAIN_LOSS',
927: 'arrx_rc.var.receipt_gain_loss' ,'NUMBER');
928: -- bug 1821300. Override RR gl_date with ARR gl_date to avoid ora-00957
929: fa_rx_util_pkg.assign_column('340','RA.GL_DATE' ,'GL_DATE' ,

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

923: 'arrx_rc.var.trx_amount','NUMBER');
924: fa_rx_util_pkg.assign_column('A17','NVL(REC.ACCTD_AMOUNT,0)' ,'ACCTD_TRX_AMOUNT',
925: 'arrx_rc.var.acctd_trx_amount' ,'NUMBER');
926: fa_rx_util_pkg.assign_column('A18',rec_gain_loss ,'RECEIPT_GAIN_LOSS',
927: 'arrx_rc.var.receipt_gain_loss' ,'NUMBER');
928: -- bug 1821300. Override RR gl_date with ARR gl_date to avoid ora-00957
929: fa_rx_util_pkg.assign_column('340','RA.GL_DATE' ,'GL_DATE' ,
930: 'arrx_rc.var.gl_date','DATE');
931: -- bug 2379856. Override CRH.ccid with RA.ccid

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

926: fa_rx_util_pkg.assign_column('A18',rec_gain_loss ,'RECEIPT_GAIN_LOSS',
927: 'arrx_rc.var.receipt_gain_loss' ,'NUMBER');
928: -- bug 1821300. Override RR gl_date with ARR gl_date to avoid ora-00957
929: fa_rx_util_pkg.assign_column('340','RA.GL_DATE' ,'GL_DATE' ,
930: 'arrx_rc.var.gl_date','DATE');
931: -- bug 2379856. Override CRH.ccid with RA.ccid
932: fa_rx_util_pkg.assign_column('400','CC2.CODE_COMBINATION_ID' ,'ACCOUNT_CODE_COMBINATION_ID',
933: 'arrx_rc.var.account_code_combination_id' ,'NUMBER');
934:

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

929: fa_rx_util_pkg.assign_column('340','RA.GL_DATE' ,'GL_DATE' ,
930: 'arrx_rc.var.gl_date','DATE');
931: -- bug 2379856. Override CRH.ccid with RA.ccid
932: fa_rx_util_pkg.assign_column('400','CC2.CODE_COMBINATION_ID' ,'ACCOUNT_CODE_COMBINATION_ID',
933: 'arrx_rc.var.account_code_combination_id' ,'NUMBER');
934:
935: fa_rx_util_pkg.debug('Define additional FROM_CLAUSE for Applied Receipts Register');
936:
937: IF NVL(var.ca_sob_type,'P') = 'P' THEN

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

995:
996: fa_rx_util_pkg.debug('Define additional ASSIGN_COLUMNS for Misc Receipts Register');
997:
998: fa_rx_util_pkg.assign_column('A1 ','decode(ARD.SOURCE_TYPE,''TAX'',NULL,MCD.PERCENT)' ,'MISC_PERCENT',
999: 'arrx_rc.var.percent' ,'NUMBER');
1000: -- bug5444415
1001: IF arp_global.sysparam.accounting_method='ACCRUAL' THEN
1002: 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' ,
1003: 'arrx_rc.var.misc_amount' ,'NUMBER');

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

999: 'arrx_rc.var.percent' ,'NUMBER');
1000: -- bug5444415
1001: IF arp_global.sysparam.accounting_method='ACCRUAL' THEN
1002: 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' ,
1003: 'arrx_rc.var.misc_amount' ,'NUMBER');
1004: ELSE
1005: fa_rx_util_pkg.assign_column('A2 ','MCD.AMOUNT','MISC_AMOUNT' ,'arrx_rc.var.misc_amount' ,'NUMBER');
1006: END IF ;
1007: fa_rx_util_pkg.assign_column('A3 ','BS.NAME' ,'BATCH_SOURCE',

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

1001: IF arp_global.sysparam.accounting_method='ACCRUAL' THEN
1002: 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' ,
1003: 'arrx_rc.var.misc_amount' ,'NUMBER');
1004: ELSE
1005: fa_rx_util_pkg.assign_column('A2 ','MCD.AMOUNT','MISC_AMOUNT' ,'arrx_rc.var.misc_amount' ,'NUMBER');
1006: END IF ;
1007: fa_rx_util_pkg.assign_column('A3 ','BS.NAME' ,'BATCH_SOURCE',
1008: 'arrx_rc.var.batch_source' ,'VARCHAR2',50);
1009: /* Bugfix 2842928. Override CRH.ccid with ARD.ccid */

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

1004: ELSE
1005: fa_rx_util_pkg.assign_column('A2 ','MCD.AMOUNT','MISC_AMOUNT' ,'arrx_rc.var.misc_amount' ,'NUMBER');
1006: END IF ;
1007: fa_rx_util_pkg.assign_column('A3 ','BS.NAME' ,'BATCH_SOURCE',
1008: 'arrx_rc.var.batch_source' ,'VARCHAR2',50);
1009: /* Bugfix 2842928. Override CRH.ccid with ARD.ccid */
1010: fa_rx_util_pkg.assign_column('400','CC2.CODE_COMBINATION_ID' ,'ACCOUNT_CODE_COMBINATION_ID',
1011: 'arrx_rc.var.account_code_combination_id' ,'NUMBER');
1012: /* Bugfix 2842928. Tax Code should be displayed only for TAX lines. */

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

1007: fa_rx_util_pkg.assign_column('A3 ','BS.NAME' ,'BATCH_SOURCE',
1008: 'arrx_rc.var.batch_source' ,'VARCHAR2',50);
1009: /* Bugfix 2842928. Override CRH.ccid with ARD.ccid */
1010: fa_rx_util_pkg.assign_column('400','CC2.CODE_COMBINATION_ID' ,'ACCOUNT_CODE_COMBINATION_ID',
1011: 'arrx_rc.var.account_code_combination_id' ,'NUMBER');
1012: /* Bugfix 2842928. Tax Code should be displayed only for TAX lines. */
1013: fa_rx_util_pkg.assign_column('200','decode(ARD.SOURCE_TYPE,''TAX'', TAX.TAX_CODE, NULL)' ,'TAX_CODE',
1014: 'arrx_rc.var.tax_code' ,'VARCHAR2', 50);
1015:

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

1010: fa_rx_util_pkg.assign_column('400','CC2.CODE_COMBINATION_ID' ,'ACCOUNT_CODE_COMBINATION_ID',
1011: 'arrx_rc.var.account_code_combination_id' ,'NUMBER');
1012: /* Bugfix 2842928. Tax Code should be displayed only for TAX lines. */
1013: fa_rx_util_pkg.assign_column('200','decode(ARD.SOURCE_TYPE,''TAX'', TAX.TAX_CODE, NULL)' ,'TAX_CODE',
1014: 'arrx_rc.var.tax_code' ,'VARCHAR2', 50);
1015:
1016: fa_rx_util_pkg.debug('Define additional FROM_CLAUSE for Misc Receipts Register');
1017:
1018: /* Bugfix 2842928. Added GL_CODE_COMBINATIONS CC2, AR_DISTRIBUTIONS ARD */

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

1096: L_BS_ORG_WHERE;
1097: END IF;
1098:
1099:
1100: fa_rx_util_pkg.debug('arrx_rc.before_report()-');
1101:
1102: end before_report;
1103:
1104: procedure bind(c in integer)

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

1405: is
1406: l_profile_rsob_id NUMBER := NULL;
1407: l_client_info_rsob_id NUMBER := NULL;
1408: begin
1409: fa_rx_util_pkg.debug('arrx_rc.arrc_rep()+');
1410:
1411: -- initialize all var to null
1412: arrx_rc.init_var;
1413:

Line 1412: arrx_rc.init_var;

1408: begin
1409: fa_rx_util_pkg.debug('arrx_rc.arrc_rep()+');
1410:
1411: -- initialize all var to null
1412: arrx_rc.init_var;
1413:
1414: -- Assign parameters to global variable
1415: -- These values will be used within the arrc_before_report trigger
1416: var.calling_program := 'RECEIPT';

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

1514: END IF;
1515: --
1516: -- Initialize request
1517: fa_rx_util_pkg.debug('Initializing the request');
1518: fa_rx_util_pkg.init_request('arrx_rc.arrc_rep',request_id,'AR_RECEIPTS_REP_ITF');
1519:
1520: fa_rx_util_pkg.assign_report('AR RECEIPTS',
1521: true,
1522: 'arrx_rc.before_report;',

Line 1522: 'arrx_rc.before_report;',

1518: fa_rx_util_pkg.init_request('arrx_rc.arrc_rep',request_id,'AR_RECEIPTS_REP_ITF');
1519:
1520: fa_rx_util_pkg.assign_report('AR RECEIPTS',
1521: true,
1522: 'arrx_rc.before_report;',
1523: 'arrx_rc.bind(:CURSOR_SELECT);',
1524: 'arrx_rc.after_fetch;',
1525: null);
1526:

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

1519:
1520: fa_rx_util_pkg.assign_report('AR RECEIPTS',
1521: true,
1522: 'arrx_rc.before_report;',
1523: 'arrx_rc.bind(:CURSOR_SELECT);',
1524: 'arrx_rc.after_fetch;',
1525: null);
1526:
1527: --

Line 1524: 'arrx_rc.after_fetch;',

1520: fa_rx_util_pkg.assign_report('AR RECEIPTS',
1521: true,
1522: 'arrx_rc.before_report;',
1523: 'arrx_rc.bind(:CURSOR_SELECT);',
1524: 'arrx_rc.after_fetch;',
1525: null);
1526:
1527: --
1528: -- Run the report.

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

1525: null);
1526:
1527: --
1528: -- Run the report.
1529: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_rc.arrc_rep')
1530: fa_rx_util_pkg.run_report('arrx_rc.arrc_rep', retcode, errbuf);
1531:
1532: fa_rx_util_pkg.debug('arrx_rc.arrc_rep()-');
1533:

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

1526:
1527: --
1528: -- Run the report.
1529: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_rc.arrc_rep')
1530: fa_rx_util_pkg.run_report('arrx_rc.arrc_rep', retcode, errbuf);
1531:
1532: fa_rx_util_pkg.debug('arrx_rc.arrc_rep()-');
1533:
1534: exception

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

1528: -- Run the report.
1529: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_rc.arrc_rep')
1530: fa_rx_util_pkg.run_report('arrx_rc.arrc_rep', retcode, errbuf);
1531:
1532: fa_rx_util_pkg.debug('arrx_rc.arrc_rep()-');
1533:
1534: exception
1535: when others then
1536: fa_rx_util_pkg.log(sqlcode);

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

1536: fa_rx_util_pkg.log(sqlcode);
1537: fa_rx_util_pkg.log(sqlerrm);
1538: fa_rx_util_pkg.debug(sqlcode);
1539: fa_rx_util_pkg.debug(sqlerrm);
1540: fa_rx_util_pkg.debug('arrx_rc.arrc_rep(EXCEPTION)-');
1541: end arrc_rep;
1542:
1543: ------------------
1544: -- Actual Register

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

1572: is
1573: l_profile_rsob_id NUMBER := NULL;
1574: l_client_info_rsob_id NUMBER := NULL;
1575: begin
1576: fa_rx_util_pkg.debug('arrx_rc.arrc_rep_actual()+');
1577:
1578: -- initialize all var to null
1579: arrx_rc.init_var;
1580:

Line 1579: arrx_rc.init_var;

1575: begin
1576: fa_rx_util_pkg.debug('arrx_rc.arrc_rep_actual()+');
1577:
1578: -- initialize all var to null
1579: arrx_rc.init_var;
1580:
1581: --
1582: -- Assign parameters to global variable
1583: -- These values will be used within the before_report trigger

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

1638: var.ca_sob_type := 'R';
1639: END IF;
1640:
1641: -- Initialize request
1642: fa_rx_util_pkg.init_request('arrx_rc.arrc_rep_actual',request_id,'AR_RECEIPTS_REP_ITF');
1643:
1644: --
1645: -- Assign triggers specific to this report
1646: -- Make sure that you make your assignment to the correct section ('AR RECEIPTS')

Line 1649: 'arrx_rc.before_report;',

1645: -- Assign triggers specific to this report
1646: -- Make sure that you make your assignment to the correct section ('AR RECEIPTS')
1647: fa_rx_util_pkg.assign_report('AR RECEIPTS',
1648: true,
1649: 'arrx_rc.before_report;',
1650: 'arrx_rc.bind(:CURSOR_SELECT);',
1651: 'arrx_rc.after_fetch;',
1652: null);
1653:

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

1646: -- Make sure that you make your assignment to the correct section ('AR RECEIPTS')
1647: fa_rx_util_pkg.assign_report('AR RECEIPTS',
1648: true,
1649: 'arrx_rc.before_report;',
1650: 'arrx_rc.bind(:CURSOR_SELECT);',
1651: 'arrx_rc.after_fetch;',
1652: null);
1653:
1654: --

Line 1651: 'arrx_rc.after_fetch;',

1647: fa_rx_util_pkg.assign_report('AR RECEIPTS',
1648: true,
1649: 'arrx_rc.before_report;',
1650: 'arrx_rc.bind(:CURSOR_SELECT);',
1651: 'arrx_rc.after_fetch;',
1652: null);
1653:
1654: --
1655: -- Run the report.

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

1652: null);
1653:
1654: --
1655: -- Run the report.
1656: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_rc.arrc_rep_actual')
1657: fa_rx_util_pkg.run_report('arrx_rc.arrc_rep_actual', retcode, errbuf);
1658:
1659: fa_rx_util_pkg.debug('arrx_rc.arrc_rep_actual()-');
1660:

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

1653:
1654: --
1655: -- Run the report.
1656: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_rc.arrc_rep_actual')
1657: fa_rx_util_pkg.run_report('arrx_rc.arrc_rep_actual', retcode, errbuf);
1658:
1659: fa_rx_util_pkg.debug('arrx_rc.arrc_rep_actual()-');
1660:
1661: exception

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

1655: -- Run the report.
1656: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_rc.arrc_rep_actual')
1657: fa_rx_util_pkg.run_report('arrx_rc.arrc_rep_actual', retcode, errbuf);
1658:
1659: fa_rx_util_pkg.debug('arrx_rc.arrc_rep_actual()-');
1660:
1661: exception
1662: when others then
1663: fa_rx_util_pkg.log(sqlcode);

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

1663: fa_rx_util_pkg.log(sqlcode);
1664: fa_rx_util_pkg.log(sqlerrm);
1665: fa_rx_util_pkg.debug(sqlcode);
1666: fa_rx_util_pkg.debug(sqlerrm);
1667: fa_rx_util_pkg.debug('arrx_rc.arrc_rep_actual(EXCEPTION)-');
1668: end arrc_rep_actual;
1669:
1670: -------------------
1671: -- Applied Register

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

1703:
1704:
1705: begin
1706:
1707: fa_rx_util_pkg.debug('arrx_rc.arar_rep()+');
1708:
1709: -- initialize all var to null
1710: arrx_rc.init_var;
1711:

Line 1710: arrx_rc.init_var;

1706:
1707: fa_rx_util_pkg.debug('arrx_rc.arar_rep()+');
1708:
1709: -- initialize all var to null
1710: arrx_rc.init_var;
1711:
1712: --5255926
1713: if p_reporting_level = 1000 then
1714: var.books_id := p_reporting_entity_id;

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

1773: END IF;
1774:
1775: --
1776: -- Initialize request
1777: fa_rx_util_pkg.init_request('arrx_rc.arar_rep',request_id,'AR_RECEIPTS_REP_ITF');
1778:
1779: -- Assign triggers specific to this report
1780: -- Make sure that you make your assignment to the correct section ('AR RECEIPTS')
1781:

Line 1784: 'arrx_rc.before_report;',

1780: -- Make sure that you make your assignment to the correct section ('AR RECEIPTS')
1781:
1782: fa_rx_util_pkg.assign_report('AR RECEIPTS',
1783: true,
1784: 'arrx_rc.before_report;',
1785: 'arrx_rc.bind(:CURSOR_SELECT);',
1786: 'arrx_rc.after_fetch;',
1787: null);
1788: --

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

1781:
1782: fa_rx_util_pkg.assign_report('AR RECEIPTS',
1783: true,
1784: 'arrx_rc.before_report;',
1785: 'arrx_rc.bind(:CURSOR_SELECT);',
1786: 'arrx_rc.after_fetch;',
1787: null);
1788: --
1789: -- Run the report.

Line 1786: 'arrx_rc.after_fetch;',

1782: fa_rx_util_pkg.assign_report('AR RECEIPTS',
1783: true,
1784: 'arrx_rc.before_report;',
1785: 'arrx_rc.bind(:CURSOR_SELECT);',
1786: 'arrx_rc.after_fetch;',
1787: null);
1788: --
1789: -- Run the report.
1790: -- Make sure to pass the p_calling_proc assigned from within this procedure

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

1787: null);
1788: --
1789: -- Run the report.
1790: -- Make sure to pass the p_calling_proc assigned from within this procedure
1791: fa_rx_util_pkg.run_report('arrx_rc.arar_rep', retcode, errbuf);
1792:
1793: fa_rx_util_pkg.debug('arrx_rc.arar_rep()-');
1794: exception
1795: when others then

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

1789: -- Run the report.
1790: -- Make sure to pass the p_calling_proc assigned from within this procedure
1791: fa_rx_util_pkg.run_report('arrx_rc.arar_rep', retcode, errbuf);
1792:
1793: fa_rx_util_pkg.debug('arrx_rc.arar_rep()-');
1794: exception
1795: when others then
1796: fa_rx_util_pkg.log(sqlcode);
1797: fa_rx_util_pkg.log(sqlerrm);

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

1826: errbuf out NOCOPY varchar2)
1827: is
1828: begin
1829:
1830: fa_rx_util_pkg.debug('arrx_rc.arar_rep()+');
1831:
1832: -- initialize all var to null
1833: arrx_rc.init_var;
1834: --

Line 1833: arrx_rc.init_var;

1829:
1830: fa_rx_util_pkg.debug('arrx_rc.arar_rep()+');
1831:
1832: -- initialize all var to null
1833: arrx_rc.init_var;
1834: --
1835: -- Assign parameters to global variable
1836: -- These values will be used within the before_report trigger
1837:

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

1880: var.ca_sob_type := 'P';
1881:
1882: --
1883: -- Initialize request
1884: fa_rx_util_pkg.init_request('arrx_rc.armtr_rep',request_id,'AR_RECEIPTS_REP_ITF');
1885:
1886: fa_rx_util_pkg.assign_report('AR RECEIPTS',
1887: true,
1888: 'arrx_rc.before_report;',

Line 1888: 'arrx_rc.before_report;',

1884: fa_rx_util_pkg.init_request('arrx_rc.armtr_rep',request_id,'AR_RECEIPTS_REP_ITF');
1885:
1886: fa_rx_util_pkg.assign_report('AR RECEIPTS',
1887: true,
1888: 'arrx_rc.before_report;',
1889: 'arrx_rc.bind(:CURSOR_SELECT);',
1890: 'arrx_rc.after_fetch;',
1891: null);
1892: --

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

1885:
1886: fa_rx_util_pkg.assign_report('AR RECEIPTS',
1887: true,
1888: 'arrx_rc.before_report;',
1889: 'arrx_rc.bind(:CURSOR_SELECT);',
1890: 'arrx_rc.after_fetch;',
1891: null);
1892: --
1893: -- Run the report.

Line 1890: 'arrx_rc.after_fetch;',

1886: fa_rx_util_pkg.assign_report('AR RECEIPTS',
1887: true,
1888: 'arrx_rc.before_report;',
1889: 'arrx_rc.bind(:CURSOR_SELECT);',
1890: 'arrx_rc.after_fetch;',
1891: null);
1892: --
1893: -- Run the report.
1894: -- Make sure to pass the p_calling_proc assigned from within this procedure

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

1891: null);
1892: --
1893: -- Run the report.
1894: -- Make sure to pass the p_calling_proc assigned from within this procedure
1895: fa_rx_util_pkg.run_report('arrx_rc.armtr_rep', retcode, errbuf);
1896:
1897: exception
1898: when others then
1899: fa_rx_util_pkg.log(sqlcode);

Line 1905: end ARRX_RC;

1901: fa_rx_util_pkg.debug(sqlcode);
1902: fa_rx_util_pkg.debug(sqlerrm);
1903: end armtr_rep;
1904:
1905: end ARRX_RC;
1906: