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_OTH dependencies on ARRX_OTH

Line 1: PACKAGE BODY ARRX_OTH as

1: PACKAGE BODY ARRX_OTH as
2: /* $Header: ARRXOTHB.pls 120.8.12020000.2 2012/07/25 10:25:44 kkikkise ship $ */
3:
4: --
5: -- Main Other Receipt Applications Report function

Line 80: fa_rx_util_pkg.init_request('arrx_oth.oth_rec_app',request_id,'AR_RECEIPTS_REP_ITF');

76: where org_id = p_reporting_entity;
77: end if;
78: --
79: -- Initialize request
80: fa_rx_util_pkg.init_request('arrx_oth.oth_rec_app',request_id,'AR_RECEIPTS_REP_ITF');
81:
82: --
83: -- Assign report triggers for this report.
84: -- This report has one section called AR OTHERREC

Line 86: -- before_report is assigned 'arrx_oth.before_report;'

82: --
83: -- Assign report triggers for this report.
84: -- This report has one section called AR OTHERREC
85: -- NOTE:
86: -- before_report is assigned 'arrx_oth.before_report;'
87: -- bind is assigned 'arrx_rc.bind(:CURSOR_SELECT);'
88: -- Each trigger event is assigned with the full procedure name (including package name).
89: -- They end with a ';'.
90: -- The bind trigger requires one host variable ':CURSOR_SELECT'.

Line 93: 'arrx_oth.before_report;',

89: -- They end with a ';'.
90: -- The bind trigger requires one host variable ':CURSOR_SELECT'.
91: fa_rx_util_pkg.assign_report('AR OTHERREC',
92: true,
93: 'arrx_oth.before_report;',
94: 'arrx_oth.bind(:CURSOR_SELECT);',
95: 'arrx_oth.after_fetch;',
96: null);
97:

Line 94: 'arrx_oth.bind(:CURSOR_SELECT);',

90: -- The bind trigger requires one host variable ':CURSOR_SELECT'.
91: fa_rx_util_pkg.assign_report('AR OTHERREC',
92: true,
93: 'arrx_oth.before_report;',
94: 'arrx_oth.bind(:CURSOR_SELECT);',
95: 'arrx_oth.after_fetch;',
96: null);
97:
98: --

Line 95: 'arrx_oth.after_fetch;',

91: fa_rx_util_pkg.assign_report('AR OTHERREC',
92: true,
93: 'arrx_oth.before_report;',
94: 'arrx_oth.bind(:CURSOR_SELECT);',
95: 'arrx_oth.after_fetch;',
96: null);
97:
98: --
99: -- Run the report. Make sure to pass as parameter the same

Line 101: fa_rx_util_pkg.run_report('arrx_oth.oth_rec_app', retcode, errbuf);

97:
98: --
99: -- Run the report. Make sure to pass as parameter the same
100: -- value passed to p_calling_proc in init_request().
101: fa_rx_util_pkg.run_report('arrx_oth.oth_rec_app', retcode, errbuf);
102:
103: fa_rx_util_pkg.debug('arrx_oth.oth_rec_app()-');
104:
105: exception

Line 103: fa_rx_util_pkg.debug('arrx_oth.oth_rec_app()-');

99: -- Run the report. Make sure to pass as parameter the same
100: -- value passed to p_calling_proc in init_request().
101: fa_rx_util_pkg.run_report('arrx_oth.oth_rec_app', retcode, errbuf);
102:
103: fa_rx_util_pkg.debug('arrx_oth.oth_rec_app()-');
104:
105: exception
106: when others then
107: fa_rx_util_pkg.log(sqlcode);

Line 111: fa_rx_util_pkg.debug('arrx_oth.oth_rec_app(EXCEPTION)-');

107: fa_rx_util_pkg.log(sqlcode);
108: fa_rx_util_pkg.log(sqlerrm);
109: fa_rx_util_pkg.debug(sqlcode);
110: fa_rx_util_pkg.debug(sqlerrm);
111: fa_rx_util_pkg.debug('arrx_oth.oth_rec_app(EXCEPTION)-');
112: end oth_rec_app;
113:
114:
115: -- This is the before trigger for the main Adj Report ---

Line 168: fa_rx_util_pkg.debug('arrx_oth.before_report()+');

164: L_CRHFIRST_ORG_WHERE varchar2(500);
165: L_RBFIRST_ORG_WHERE varchar2(500);
166: begin
167:
168: fa_rx_util_pkg.debug('arrx_oth.before_report()+');
169:
170: --
171: -- Get Profile GL_SET_OF_BKS_ID
172: --

Line 359: 'arrx_oth.var.organization_name','VARCHAR2',50);

355: -- sequence, select, field in itf, into, type, len
356: fa_rx_util_pkg.debug('ARTX_ASSIGN_SELECT_LIST');
357:
358: fa_rx_util_pkg.assign_column('10',NULL,'ORGANIZATION_NAME',
359: 'arrx_oth.var.organization_name','VARCHAR2',50);
360: fa_rx_util_pkg.assign_column('20',NULL,'FUNCTIONAL_CURRENCY_CODE',
361: 'arrx_oth.var.functional_currency_code','VARCHAR2',15);
362: fa_rx_util_pkg.assign_column('30',ACCT_FLEX,'ACCOUNTING_FLEXFIELD',
363: 'arrx_oth.var.accounting_flexfield','VARCHAR2',4000);

Line 361: 'arrx_oth.var.functional_currency_code','VARCHAR2',15);

357:
358: fa_rx_util_pkg.assign_column('10',NULL,'ORGANIZATION_NAME',
359: 'arrx_oth.var.organization_name','VARCHAR2',50);
360: fa_rx_util_pkg.assign_column('20',NULL,'FUNCTIONAL_CURRENCY_CODE',
361: 'arrx_oth.var.functional_currency_code','VARCHAR2',15);
362: fa_rx_util_pkg.assign_column('30',ACCT_FLEX,'ACCOUNTING_FLEXFIELD',
363: 'arrx_oth.var.accounting_flexfield','VARCHAR2',4000);
364: fa_rx_util_pkg.assign_column('40','glc.code_combination_id','ACCOUNT_CODE_COMBINATION_ID',
365: 'arrx_oth.var.code_combination_id','NUMBER');

Line 363: 'arrx_oth.var.accounting_flexfield','VARCHAR2',4000);

359: 'arrx_oth.var.organization_name','VARCHAR2',50);
360: fa_rx_util_pkg.assign_column('20',NULL,'FUNCTIONAL_CURRENCY_CODE',
361: 'arrx_oth.var.functional_currency_code','VARCHAR2',15);
362: fa_rx_util_pkg.assign_column('30',ACCT_FLEX,'ACCOUNTING_FLEXFIELD',
363: 'arrx_oth.var.accounting_flexfield','VARCHAR2',4000);
364: fa_rx_util_pkg.assign_column('40','glc.code_combination_id','ACCOUNT_CODE_COMBINATION_ID',
365: 'arrx_oth.var.code_combination_id','NUMBER');
366: fa_rx_util_pkg.assign_column('50','AB.BANK_ACCOUNT_NUM','ACCOUNT_NUMBER',
367: 'arrx_oth.var.bank_account_number','VARCHAR2',30);

Line 365: 'arrx_oth.var.code_combination_id','NUMBER');

361: 'arrx_oth.var.functional_currency_code','VARCHAR2',15);
362: fa_rx_util_pkg.assign_column('30',ACCT_FLEX,'ACCOUNTING_FLEXFIELD',
363: 'arrx_oth.var.accounting_flexfield','VARCHAR2',4000);
364: fa_rx_util_pkg.assign_column('40','glc.code_combination_id','ACCOUNT_CODE_COMBINATION_ID',
365: 'arrx_oth.var.code_combination_id','NUMBER');
366: fa_rx_util_pkg.assign_column('50','AB.BANK_ACCOUNT_NUM','ACCOUNT_NUMBER',
367: 'arrx_oth.var.bank_account_number','VARCHAR2',30);
368: fa_rx_util_pkg.assign_column('60','APP.ACCTD_AMOUNT_APPLIED_FROM','ACCTD_AMOUNT_APPLIED_FROM',
369: 'arrx_oth.var.acctd_amount_applied_from','NUMBER');

Line 367: 'arrx_oth.var.bank_account_number','VARCHAR2',30);

363: 'arrx_oth.var.accounting_flexfield','VARCHAR2',4000);
364: fa_rx_util_pkg.assign_column('40','glc.code_combination_id','ACCOUNT_CODE_COMBINATION_ID',
365: 'arrx_oth.var.code_combination_id','NUMBER');
366: fa_rx_util_pkg.assign_column('50','AB.BANK_ACCOUNT_NUM','ACCOUNT_NUMBER',
367: 'arrx_oth.var.bank_account_number','VARCHAR2',30);
368: fa_rx_util_pkg.assign_column('60','APP.ACCTD_AMOUNT_APPLIED_FROM','ACCTD_AMOUNT_APPLIED_FROM',
369: 'arrx_oth.var.acctd_amount_applied_from','NUMBER');
370: fa_rx_util_pkg.assign_column('70','APP.ACCTD_AMOUNT_APPLIED_TO','ACCTD_AMOUNT_APPLIED_TO',
371: 'arrx_oth.var.acctd_amount_applied_to','NUMBER');

Line 369: 'arrx_oth.var.acctd_amount_applied_from','NUMBER');

365: 'arrx_oth.var.code_combination_id','NUMBER');
366: fa_rx_util_pkg.assign_column('50','AB.BANK_ACCOUNT_NUM','ACCOUNT_NUMBER',
367: 'arrx_oth.var.bank_account_number','VARCHAR2',30);
368: fa_rx_util_pkg.assign_column('60','APP.ACCTD_AMOUNT_APPLIED_FROM','ACCTD_AMOUNT_APPLIED_FROM',
369: 'arrx_oth.var.acctd_amount_applied_from','NUMBER');
370: fa_rx_util_pkg.assign_column('70','APP.ACCTD_AMOUNT_APPLIED_TO','ACCTD_AMOUNT_APPLIED_TO',
371: 'arrx_oth.var.acctd_amount_applied_to','NUMBER');
372: fa_rx_util_pkg.assign_column('80',DECODE_ACT_NAME ,'ACTIVITY_NAME',
373: 'arrx_oth.var.activity_name','VARCHAR2',50);

Line 371: 'arrx_oth.var.acctd_amount_applied_to','NUMBER');

367: 'arrx_oth.var.bank_account_number','VARCHAR2',30);
368: fa_rx_util_pkg.assign_column('60','APP.ACCTD_AMOUNT_APPLIED_FROM','ACCTD_AMOUNT_APPLIED_FROM',
369: 'arrx_oth.var.acctd_amount_applied_from','NUMBER');
370: fa_rx_util_pkg.assign_column('70','APP.ACCTD_AMOUNT_APPLIED_TO','ACCTD_AMOUNT_APPLIED_TO',
371: 'arrx_oth.var.acctd_amount_applied_to','NUMBER');
372: fa_rx_util_pkg.assign_column('80',DECODE_ACT_NAME ,'ACTIVITY_NAME',
373: 'arrx_oth.var.activity_name','VARCHAR2',50);
374: fa_rx_util_pkg.assign_column('90','APP.AMOUNT_APPLIED','AMOUNT_APPLIED',
375: 'arrx_oth.var.amount_applied','NUMBER');

Line 373: 'arrx_oth.var.activity_name','VARCHAR2',50);

369: 'arrx_oth.var.acctd_amount_applied_from','NUMBER');
370: fa_rx_util_pkg.assign_column('70','APP.ACCTD_AMOUNT_APPLIED_TO','ACCTD_AMOUNT_APPLIED_TO',
371: 'arrx_oth.var.acctd_amount_applied_to','NUMBER');
372: fa_rx_util_pkg.assign_column('80',DECODE_ACT_NAME ,'ACTIVITY_NAME',
373: 'arrx_oth.var.activity_name','VARCHAR2',50);
374: fa_rx_util_pkg.assign_column('90','APP.AMOUNT_APPLIED','AMOUNT_APPLIED',
375: 'arrx_oth.var.amount_applied','NUMBER');
376: fa_rx_util_pkg.assign_column('100','APP.APPLICATION_REF_NUM','APPLICATION_REF_NUMBER',
377: 'arrx_oth.var.application_ref_num','VARCHAR2',30);

Line 375: 'arrx_oth.var.amount_applied','NUMBER');

371: 'arrx_oth.var.acctd_amount_applied_to','NUMBER');
372: fa_rx_util_pkg.assign_column('80',DECODE_ACT_NAME ,'ACTIVITY_NAME',
373: 'arrx_oth.var.activity_name','VARCHAR2',50);
374: fa_rx_util_pkg.assign_column('90','APP.AMOUNT_APPLIED','AMOUNT_APPLIED',
375: 'arrx_oth.var.amount_applied','NUMBER');
376: fa_rx_util_pkg.assign_column('100','APP.APPLICATION_REF_NUM','APPLICATION_REF_NUMBER',
377: 'arrx_oth.var.application_ref_num','VARCHAR2',30);
378: fa_rx_util_pkg.assign_column('110',DECODE_REF_TYPE,'APPLICATION_REF_TYPE',
379: 'arrx_oth.var.application_ref_type','VARCHAR2',80);

Line 377: 'arrx_oth.var.application_ref_num','VARCHAR2',30);

373: 'arrx_oth.var.activity_name','VARCHAR2',50);
374: fa_rx_util_pkg.assign_column('90','APP.AMOUNT_APPLIED','AMOUNT_APPLIED',
375: 'arrx_oth.var.amount_applied','NUMBER');
376: fa_rx_util_pkg.assign_column('100','APP.APPLICATION_REF_NUM','APPLICATION_REF_NUMBER',
377: 'arrx_oth.var.application_ref_num','VARCHAR2',30);
378: fa_rx_util_pkg.assign_column('110',DECODE_REF_TYPE,'APPLICATION_REF_TYPE',
379: 'arrx_oth.var.application_ref_type','VARCHAR2',80);
380: fa_rx_util_pkg.assign_column('120','APP.STATUS','APPLICATION_STATUS',
381: 'arrx_oth.var.application_status','VARCHAR2',20);

Line 379: 'arrx_oth.var.application_ref_type','VARCHAR2',80);

375: 'arrx_oth.var.amount_applied','NUMBER');
376: fa_rx_util_pkg.assign_column('100','APP.APPLICATION_REF_NUM','APPLICATION_REF_NUMBER',
377: 'arrx_oth.var.application_ref_num','VARCHAR2',30);
378: fa_rx_util_pkg.assign_column('110',DECODE_REF_TYPE,'APPLICATION_REF_TYPE',
379: 'arrx_oth.var.application_ref_type','VARCHAR2',80);
380: fa_rx_util_pkg.assign_column('120','APP.STATUS','APPLICATION_STATUS',
381: 'arrx_oth.var.application_status','VARCHAR2',20);
382: fa_rx_util_pkg.assign_column('130','APP.APPLY_DATE','APPLY_DATE',
383: 'arrx_oth.var.apply_date','DATE');

Line 381: 'arrx_oth.var.application_status','VARCHAR2',20);

377: 'arrx_oth.var.application_ref_num','VARCHAR2',30);
378: fa_rx_util_pkg.assign_column('110',DECODE_REF_TYPE,'APPLICATION_REF_TYPE',
379: 'arrx_oth.var.application_ref_type','VARCHAR2',80);
380: fa_rx_util_pkg.assign_column('120','APP.STATUS','APPLICATION_STATUS',
381: 'arrx_oth.var.application_status','VARCHAR2',20);
382: fa_rx_util_pkg.assign_column('130','APP.APPLY_DATE','APPLY_DATE',
383: 'arrx_oth.var.apply_date','DATE');
384: fa_rx_util_pkg.assign_column('140', 'RBFIRST.BATCH_ID','BATCH_ID',
385: 'arrx_oth.var.batch_id','NUMBER');

Line 383: 'arrx_oth.var.apply_date','DATE');

379: 'arrx_oth.var.application_ref_type','VARCHAR2',80);
380: fa_rx_util_pkg.assign_column('120','APP.STATUS','APPLICATION_STATUS',
381: 'arrx_oth.var.application_status','VARCHAR2',20);
382: fa_rx_util_pkg.assign_column('130','APP.APPLY_DATE','APPLY_DATE',
383: 'arrx_oth.var.apply_date','DATE');
384: fa_rx_util_pkg.assign_column('140', 'RBFIRST.BATCH_ID','BATCH_ID',
385: 'arrx_oth.var.batch_id','NUMBER');
386: fa_rx_util_pkg.assign_column('150','RBFIRST.NAME','BATCH_NAME',
387: 'arrx_oth.var.batch_name','VARCHAR2',20);

Line 385: 'arrx_oth.var.batch_id','NUMBER');

381: 'arrx_oth.var.application_status','VARCHAR2',20);
382: fa_rx_util_pkg.assign_column('130','APP.APPLY_DATE','APPLY_DATE',
383: 'arrx_oth.var.apply_date','DATE');
384: fa_rx_util_pkg.assign_column('140', 'RBFIRST.BATCH_ID','BATCH_ID',
385: 'arrx_oth.var.batch_id','NUMBER');
386: fa_rx_util_pkg.assign_column('150','RBFIRST.NAME','BATCH_NAME',
387: 'arrx_oth.var.batch_name','VARCHAR2',20);
388: fa_rx_util_pkg.assign_column('160','BSFIRST.NAME','BATCH_SOURCE',
389: 'arrx_oth.var.batch_source','VARCHAR2',50);

Line 387: 'arrx_oth.var.batch_name','VARCHAR2',20);

383: 'arrx_oth.var.apply_date','DATE');
384: fa_rx_util_pkg.assign_column('140', 'RBFIRST.BATCH_ID','BATCH_ID',
385: 'arrx_oth.var.batch_id','NUMBER');
386: fa_rx_util_pkg.assign_column('150','RBFIRST.NAME','BATCH_NAME',
387: 'arrx_oth.var.batch_name','VARCHAR2',20);
388: fa_rx_util_pkg.assign_column('160','BSFIRST.NAME','BATCH_SOURCE',
389: 'arrx_oth.var.batch_source','VARCHAR2',50);
390: fa_rx_util_pkg.assign_column('170','CR.CASH_RECEIPT_ID','CASH_RECEIPT_ID',
391: 'arrx_oth.var.cash_receipt_id','NUMBER');

Line 389: 'arrx_oth.var.batch_source','VARCHAR2',50);

385: 'arrx_oth.var.batch_id','NUMBER');
386: fa_rx_util_pkg.assign_column('150','RBFIRST.NAME','BATCH_NAME',
387: 'arrx_oth.var.batch_name','VARCHAR2',20);
388: fa_rx_util_pkg.assign_column('160','BSFIRST.NAME','BATCH_SOURCE',
389: 'arrx_oth.var.batch_source','VARCHAR2',50);
390: fa_rx_util_pkg.assign_column('170','CR.CASH_RECEIPT_ID','CASH_RECEIPT_ID',
391: 'arrx_oth.var.cash_receipt_id','NUMBER');
392: fa_rx_util_pkg.assign_column('180' ,'SUBSTRB(PARTY.PARTY_NAME,1,50)','CUSTOMER_NAME',
393: 'arrx_oth.var.customer_name','VARCHAR2',50);

Line 391: 'arrx_oth.var.cash_receipt_id','NUMBER');

387: 'arrx_oth.var.batch_name','VARCHAR2',20);
388: fa_rx_util_pkg.assign_column('160','BSFIRST.NAME','BATCH_SOURCE',
389: 'arrx_oth.var.batch_source','VARCHAR2',50);
390: fa_rx_util_pkg.assign_column('170','CR.CASH_RECEIPT_ID','CASH_RECEIPT_ID',
391: 'arrx_oth.var.cash_receipt_id','NUMBER');
392: fa_rx_util_pkg.assign_column('180' ,'SUBSTRB(PARTY.PARTY_NAME,1,50)','CUSTOMER_NAME',
393: 'arrx_oth.var.customer_name','VARCHAR2',50);
394: fa_rx_util_pkg.assign_column('190','CUST.ACCOUNT_NUMBER','CUSTOMER_NUMBER',
395: 'arrx_oth.var.customer_number','VARCHAR2',30);

Line 393: 'arrx_oth.var.customer_name','VARCHAR2',50);

389: 'arrx_oth.var.batch_source','VARCHAR2',50);
390: fa_rx_util_pkg.assign_column('170','CR.CASH_RECEIPT_ID','CASH_RECEIPT_ID',
391: 'arrx_oth.var.cash_receipt_id','NUMBER');
392: fa_rx_util_pkg.assign_column('180' ,'SUBSTRB(PARTY.PARTY_NAME,1,50)','CUSTOMER_NAME',
393: 'arrx_oth.var.customer_name','VARCHAR2',50);
394: fa_rx_util_pkg.assign_column('190','CUST.ACCOUNT_NUMBER','CUSTOMER_NUMBER',
395: 'arrx_oth.var.customer_number','VARCHAR2',30);
396: fa_rx_util_pkg.assign_column('200',null,'DEBIT_BALANCING',
397: 'arrx_oth.var.debit_balancing','VARCHAR2',240);

Line 395: 'arrx_oth.var.customer_number','VARCHAR2',30);

391: 'arrx_oth.var.cash_receipt_id','NUMBER');
392: fa_rx_util_pkg.assign_column('180' ,'SUBSTRB(PARTY.PARTY_NAME,1,50)','CUSTOMER_NAME',
393: 'arrx_oth.var.customer_name','VARCHAR2',50);
394: fa_rx_util_pkg.assign_column('190','CUST.ACCOUNT_NUMBER','CUSTOMER_NUMBER',
395: 'arrx_oth.var.customer_number','VARCHAR2',30);
396: fa_rx_util_pkg.assign_column('200',null,'DEBIT_BALANCING',
397: 'arrx_oth.var.debit_balancing','VARCHAR2',240);
398: fa_rx_util_pkg.assign_column('210',DECODE_CURRENCY,'FORMAT_CURRENCY_CODE',
399: 'arrx_oth.var.format_currency_code','VARCHAR2',15);

Line 397: 'arrx_oth.var.debit_balancing','VARCHAR2',240);

393: 'arrx_oth.var.customer_name','VARCHAR2',50);
394: fa_rx_util_pkg.assign_column('190','CUST.ACCOUNT_NUMBER','CUSTOMER_NUMBER',
395: 'arrx_oth.var.customer_number','VARCHAR2',30);
396: fa_rx_util_pkg.assign_column('200',null,'DEBIT_BALANCING',
397: 'arrx_oth.var.debit_balancing','VARCHAR2',240);
398: fa_rx_util_pkg.assign_column('210',DECODE_CURRENCY,'FORMAT_CURRENCY_CODE',
399: 'arrx_oth.var.format_currency_code','VARCHAR2',15);
400: fa_rx_util_pkg.assign_column('220','APP.GL_DATE','GL_DATE',
401: 'arrx_oth.var.gl_date','DATE');

Line 399: 'arrx_oth.var.format_currency_code','VARCHAR2',15);

395: 'arrx_oth.var.customer_number','VARCHAR2',30);
396: fa_rx_util_pkg.assign_column('200',null,'DEBIT_BALANCING',
397: 'arrx_oth.var.debit_balancing','VARCHAR2',240);
398: fa_rx_util_pkg.assign_column('210',DECODE_CURRENCY,'FORMAT_CURRENCY_CODE',
399: 'arrx_oth.var.format_currency_code','VARCHAR2',15);
400: fa_rx_util_pkg.assign_column('220','APP.GL_DATE','GL_DATE',
401: 'arrx_oth.var.gl_date','DATE');
402: fa_rx_util_pkg.assign_column('230','CR.CURRENCY_CODE','RECEIPT_CURRENCY_CODE',
403: 'arrx_oth.var.receipt_currency_code','VARCHAR2',15);

Line 401: 'arrx_oth.var.gl_date','DATE');

397: 'arrx_oth.var.debit_balancing','VARCHAR2',240);
398: fa_rx_util_pkg.assign_column('210',DECODE_CURRENCY,'FORMAT_CURRENCY_CODE',
399: 'arrx_oth.var.format_currency_code','VARCHAR2',15);
400: fa_rx_util_pkg.assign_column('220','APP.GL_DATE','GL_DATE',
401: 'arrx_oth.var.gl_date','DATE');
402: fa_rx_util_pkg.assign_column('230','CR.CURRENCY_CODE','RECEIPT_CURRENCY_CODE',
403: 'arrx_oth.var.receipt_currency_code','VARCHAR2',15);
404: fa_rx_util_pkg.assign_column('240','CR.RECEIPT_DATE','RECEIPT_DATE',
405: 'arrx_oth.var.receipt_date','DATE');

Line 403: 'arrx_oth.var.receipt_currency_code','VARCHAR2',15);

399: 'arrx_oth.var.format_currency_code','VARCHAR2',15);
400: fa_rx_util_pkg.assign_column('220','APP.GL_DATE','GL_DATE',
401: 'arrx_oth.var.gl_date','DATE');
402: fa_rx_util_pkg.assign_column('230','CR.CURRENCY_CODE','RECEIPT_CURRENCY_CODE',
403: 'arrx_oth.var.receipt_currency_code','VARCHAR2',15);
404: fa_rx_util_pkg.assign_column('240','CR.RECEIPT_DATE','RECEIPT_DATE',
405: 'arrx_oth.var.receipt_date','DATE');
406: fa_rx_util_pkg.assign_column('250','CR.RECEIPT_NUMBER','RECEIPT_NUMBER',
407: 'arrx_oth.var.receipt_number','VARCHAR2',30);

Line 405: 'arrx_oth.var.receipt_date','DATE');

401: 'arrx_oth.var.gl_date','DATE');
402: fa_rx_util_pkg.assign_column('230','CR.CURRENCY_CODE','RECEIPT_CURRENCY_CODE',
403: 'arrx_oth.var.receipt_currency_code','VARCHAR2',15);
404: fa_rx_util_pkg.assign_column('240','CR.RECEIPT_DATE','RECEIPT_DATE',
405: 'arrx_oth.var.receipt_date','DATE');
406: fa_rx_util_pkg.assign_column('250','CR.RECEIPT_NUMBER','RECEIPT_NUMBER',
407: 'arrx_oth.var.receipt_number','VARCHAR2',30);
408: fa_rx_util_pkg.assign_column('260','CR.STATUS','RECEIPT_STATUS',
409: 'arrx_oth.var.receipt_status','VARCHAR2',40);

Line 407: 'arrx_oth.var.receipt_number','VARCHAR2',30);

403: 'arrx_oth.var.receipt_currency_code','VARCHAR2',15);
404: fa_rx_util_pkg.assign_column('240','CR.RECEIPT_DATE','RECEIPT_DATE',
405: 'arrx_oth.var.receipt_date','DATE');
406: fa_rx_util_pkg.assign_column('250','CR.RECEIPT_NUMBER','RECEIPT_NUMBER',
407: 'arrx_oth.var.receipt_number','VARCHAR2',30);
408: fa_rx_util_pkg.assign_column('260','CR.STATUS','RECEIPT_STATUS',
409: 'arrx_oth.var.receipt_status','VARCHAR2',40);
410: fa_rx_util_pkg.assign_column('270','CR.TYPE','RECEIPT_TYPE',
411: 'arrx_oth.var.receipt_type','VARCHAR2',30);

Line 409: 'arrx_oth.var.receipt_status','VARCHAR2',40);

405: 'arrx_oth.var.receipt_date','DATE');
406: fa_rx_util_pkg.assign_column('250','CR.RECEIPT_NUMBER','RECEIPT_NUMBER',
407: 'arrx_oth.var.receipt_number','VARCHAR2',30);
408: fa_rx_util_pkg.assign_column('260','CR.STATUS','RECEIPT_STATUS',
409: 'arrx_oth.var.receipt_status','VARCHAR2',40);
410: fa_rx_util_pkg.assign_column('270','CR.TYPE','RECEIPT_TYPE',
411: 'arrx_oth.var.receipt_type','VARCHAR2',30);
412: fa_rx_util_pkg.assign_column('275','CR.AMOUNT','RECEIPT_AMOUNT',
413: 'arrx_oth.var.receipt_amount','NUMBER');

Line 411: 'arrx_oth.var.receipt_type','VARCHAR2',30);

407: 'arrx_oth.var.receipt_number','VARCHAR2',30);
408: fa_rx_util_pkg.assign_column('260','CR.STATUS','RECEIPT_STATUS',
409: 'arrx_oth.var.receipt_status','VARCHAR2',40);
410: fa_rx_util_pkg.assign_column('270','CR.TYPE','RECEIPT_TYPE',
411: 'arrx_oth.var.receipt_type','VARCHAR2',30);
412: fa_rx_util_pkg.assign_column('275','CR.AMOUNT','RECEIPT_AMOUNT',
413: 'arrx_oth.var.receipt_amount','NUMBER');
414: fa_rx_util_pkg.assign_column('280','RB.NAME','REMIT_BATCH_NAME',
415: 'arrx_oth.var.remit_batch_name','VARCHAR2',20);

Line 413: 'arrx_oth.var.receipt_amount','NUMBER');

409: 'arrx_oth.var.receipt_status','VARCHAR2',40);
410: fa_rx_util_pkg.assign_column('270','CR.TYPE','RECEIPT_TYPE',
411: 'arrx_oth.var.receipt_type','VARCHAR2',30);
412: fa_rx_util_pkg.assign_column('275','CR.AMOUNT','RECEIPT_AMOUNT',
413: 'arrx_oth.var.receipt_amount','NUMBER');
414: fa_rx_util_pkg.assign_column('280','RB.NAME','REMIT_BATCH_NAME',
415: 'arrx_oth.var.remit_batch_name','VARCHAR2',20);
416:
417: -- Assign FROM clause

Line 415: 'arrx_oth.var.remit_batch_name','VARCHAR2',20);

411: 'arrx_oth.var.receipt_type','VARCHAR2',30);
412: fa_rx_util_pkg.assign_column('275','CR.AMOUNT','RECEIPT_AMOUNT',
413: 'arrx_oth.var.receipt_amount','NUMBER');
414: fa_rx_util_pkg.assign_column('280','RB.NAME','REMIT_BATCH_NAME',
415: 'arrx_oth.var.remit_batch_name','VARCHAR2',20);
416:
417: -- Assign FROM clause
418:
419: fa_rx_util_pkg.debug('Assign FROM Clause using ALL tables');

Line 488: fa_rx_util_pkg.debug('arrx_oth.adj_before_report()-');

484: L_BSFIRST_ORG_WHERE || ' ' ||
485: L_CRHFIRST_ORG_WHERE || ' ' ||
486: L_RBFIRST_ORG_WHERE;
487:
488: fa_rx_util_pkg.debug('arrx_oth.adj_before_report()-');
489:
490: end before_report;
491:
492: --

Line 610: end ARRX_OTH;

606: --
607:
608: end after_fetch;
609:
610: end ARRX_OTH;