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 FA_RX_UTIL_PKG

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 91: fa_rx_util_pkg.assign_report('AR OTHERREC',

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'.
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;',

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 107: fa_rx_util_pkg.log(sqlcode);

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);
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)-');

Line 108: fa_rx_util_pkg.log(sqlerrm);

104:
105: exception
106: when others then
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;

Line 109: fa_rx_util_pkg.debug(sqlcode);

105: exception
106: when others then
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:

Line 110: fa_rx_util_pkg.debug(sqlerrm);

106: when others then
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:

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 173: fa_rx_util_pkg.debug('GL_GET_PROFILE_BKS_ID');

169:
170: --
171: -- Get Profile GL_SET_OF_BKS_ID
172: --
173: fa_rx_util_pkg.debug('GL_GET_PROFILE_BKS_ID');
174:
175: --Bug5373461
176: -- var.books_id := arp_global.sysparam.set_of_books_id;
177:

Line 181: fa_rx_util_pkg.debug('GL_GET_CHART_OF_ACCOUNTS_ID');

177:
178: --
179: -- Get CHART_OF_ACCOUNTS_ID
180: --
181: fa_rx_util_pkg.debug('GL_GET_CHART_OF_ACCOUNTS_ID');
182:
183: select CHART_OF_ACCOUNTS_ID,CURRENCY_CODE,NAME
184: into var.chart_of_accounts_id,var.functional_currency_code,var.organization_name
185: from GL_SETS_OF_BOOKS

Line 188: fa_rx_util_pkg.debug('Chart of Accounts ID : '||var.chart_of_accounts_id);

184: into var.chart_of_accounts_id,var.functional_currency_code,var.organization_name
185: from GL_SETS_OF_BOOKS
186: where SET_OF_BOOKS_ID = var.books_id;
187:
188: fa_rx_util_pkg.debug('Chart of Accounts ID : '||var.chart_of_accounts_id);
189: fa_rx_util_pkg.debug('Functional Currency : '||var.functional_currency_code);
190: fa_rx_util_pkg.debug('Organization Name : '||var.organization_name);
191:
192: XLA_MO_REPORTING_API.Initialize(var.p_reporting_level, var.p_reporting_entity_id, 'AUTO');

Line 189: fa_rx_util_pkg.debug('Functional Currency : '||var.functional_currency_code);

185: from GL_SETS_OF_BOOKS
186: where SET_OF_BOOKS_ID = var.books_id;
187:
188: fa_rx_util_pkg.debug('Chart of Accounts ID : '||var.chart_of_accounts_id);
189: fa_rx_util_pkg.debug('Functional Currency : '||var.functional_currency_code);
190: fa_rx_util_pkg.debug('Organization Name : '||var.organization_name);
191:
192: XLA_MO_REPORTING_API.Initialize(var.p_reporting_level, var.p_reporting_entity_id, 'AUTO');
193:

Line 190: fa_rx_util_pkg.debug('Organization Name : '||var.organization_name);

186: where SET_OF_BOOKS_ID = var.books_id;
187:
188: fa_rx_util_pkg.debug('Chart of Accounts ID : '||var.chart_of_accounts_id);
189: fa_rx_util_pkg.debug('Functional Currency : '||var.functional_currency_code);
190: fa_rx_util_pkg.debug('Organization Name : '||var.organization_name);
191:
192: XLA_MO_REPORTING_API.Initialize(var.p_reporting_level, var.p_reporting_entity_id, 'AUTO');
193:
194: L_APP_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('APP',NULL);

Line 208: fa_rx_util_pkg.debug('AR_GET_PARAMETERS');

204: L_RBFIRST_ORG_WHERE := XLA_MO_REPORTING_API.Get_Predicate('RBFIRST',NULL);
205: --
206: -- Figure out NOCOPY the where clause for the parameters
207: --
208: fa_rx_util_pkg.debug('AR_GET_PARAMETERS');
209:
210: -- CO_SEG_WHERE clause
211: IF var.p_co_seg_low IS NULL AND var.p_co_seg_high IS NULL THEN
212: OPER := NULL;

Line 356: fa_rx_util_pkg.debug('ARTX_ASSIGN_SELECT_LIST');

352: DECODE_CURRENCY := 'DECODE(:P_ENTERED_CURRENCY,NULL,:P_FUNCTIONAL_CURRENCY,CR.CURRENCY_CODE)';
353:
354: -- Assign SELECT list
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',

Line 358: fa_rx_util_pkg.assign_column('10',NULL,'ORGANIZATION_NAME',

354: -- Assign SELECT list
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',

Line 360: fa_rx_util_pkg.assign_column('20',NULL,'FUNCTIONAL_CURRENCY_CODE',

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);
364: fa_rx_util_pkg.assign_column('40','glc.code_combination_id','ACCOUNT_CODE_COMBINATION_ID',

Line 362: fa_rx_util_pkg.assign_column('30',ACCT_FLEX,'ACCOUNTING_FLEXFIELD',

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');
366: fa_rx_util_pkg.assign_column('50','AB.BANK_ACCOUNT_NUM','ACCOUNT_NUMBER',

Line 364: fa_rx_util_pkg.assign_column('40','glc.code_combination_id','ACCOUNT_CODE_COMBINATION_ID',

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);
368: fa_rx_util_pkg.assign_column('60','APP.ACCTD_AMOUNT_APPLIED_FROM','ACCTD_AMOUNT_APPLIED_FROM',

Line 366: fa_rx_util_pkg.assign_column('50','AB.BANK_ACCOUNT_NUM','ACCOUNT_NUMBER',

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');
370: fa_rx_util_pkg.assign_column('70','APP.ACCTD_AMOUNT_APPLIED_TO','ACCTD_AMOUNT_APPLIED_TO',

Line 368: fa_rx_util_pkg.assign_column('60','APP.ACCTD_AMOUNT_APPLIED_FROM','ACCTD_AMOUNT_APPLIED_FROM',

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');
372: fa_rx_util_pkg.assign_column('80',DECODE_ACT_NAME ,'ACTIVITY_NAME',

Line 370: fa_rx_util_pkg.assign_column('70','APP.ACCTD_AMOUNT_APPLIED_TO','ACCTD_AMOUNT_APPLIED_TO',

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);
374: fa_rx_util_pkg.assign_column('90','APP.AMOUNT_APPLIED','AMOUNT_APPLIED',

Line 372: fa_rx_util_pkg.assign_column('80',DECODE_ACT_NAME ,'ACTIVITY_NAME',

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');
376: fa_rx_util_pkg.assign_column('100','APP.APPLICATION_REF_NUM','APPLICATION_REF_NUMBER',

Line 374: fa_rx_util_pkg.assign_column('90','APP.AMOUNT_APPLIED','AMOUNT_APPLIED',

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);
378: fa_rx_util_pkg.assign_column('110',DECODE_REF_TYPE,'APPLICATION_REF_TYPE',

Line 376: fa_rx_util_pkg.assign_column('100','APP.APPLICATION_REF_NUM','APPLICATION_REF_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);
380: fa_rx_util_pkg.assign_column('120','APP.STATUS','APPLICATION_STATUS',

Line 378: fa_rx_util_pkg.assign_column('110',DECODE_REF_TYPE,'APPLICATION_REF_TYPE',

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);
382: fa_rx_util_pkg.assign_column('130','APP.APPLY_DATE','APPLY_DATE',

Line 380: fa_rx_util_pkg.assign_column('120','APP.STATUS','APPLICATION_STATUS',

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');
384: fa_rx_util_pkg.assign_column('140', 'RBFIRST.BATCH_ID','BATCH_ID',

Line 382: fa_rx_util_pkg.assign_column('130','APP.APPLY_DATE','APPLY_DATE',

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');
386: fa_rx_util_pkg.assign_column('150','RBFIRST.NAME','BATCH_NAME',

Line 384: fa_rx_util_pkg.assign_column('140', 'RBFIRST.BATCH_ID','BATCH_ID',

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);
388: fa_rx_util_pkg.assign_column('160','BSFIRST.NAME','BATCH_SOURCE',

Line 386: fa_rx_util_pkg.assign_column('150','RBFIRST.NAME','BATCH_NAME',

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);
390: fa_rx_util_pkg.assign_column('170','CR.CASH_RECEIPT_ID','CASH_RECEIPT_ID',

Line 388: fa_rx_util_pkg.assign_column('160','BSFIRST.NAME','BATCH_SOURCE',

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');
392: fa_rx_util_pkg.assign_column('180' ,'SUBSTRB(PARTY.PARTY_NAME,1,50)','CUSTOMER_NAME',

Line 390: fa_rx_util_pkg.assign_column('170','CR.CASH_RECEIPT_ID','CASH_RECEIPT_ID',

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);
394: fa_rx_util_pkg.assign_column('190','CUST.ACCOUNT_NUMBER','CUSTOMER_NUMBER',

Line 392: fa_rx_util_pkg.assign_column('180' ,'SUBSTRB(PARTY.PARTY_NAME,1,50)','CUSTOMER_NAME',

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);
396: fa_rx_util_pkg.assign_column('200',null,'DEBIT_BALANCING',

Line 394: fa_rx_util_pkg.assign_column('190','CUST.ACCOUNT_NUMBER','CUSTOMER_NUMBER',

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);
398: fa_rx_util_pkg.assign_column('210',DECODE_CURRENCY,'FORMAT_CURRENCY_CODE',

Line 396: fa_rx_util_pkg.assign_column('200',null,'DEBIT_BALANCING',

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);
400: fa_rx_util_pkg.assign_column('220','APP.GL_DATE','GL_DATE',

Line 398: fa_rx_util_pkg.assign_column('210',DECODE_CURRENCY,'FORMAT_CURRENCY_CODE',

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');
402: fa_rx_util_pkg.assign_column('230','CR.CURRENCY_CODE','RECEIPT_CURRENCY_CODE',

Line 400: fa_rx_util_pkg.assign_column('220','APP.GL_DATE','GL_DATE',

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);
404: fa_rx_util_pkg.assign_column('240','CR.RECEIPT_DATE','RECEIPT_DATE',

Line 402: fa_rx_util_pkg.assign_column('230','CR.CURRENCY_CODE','RECEIPT_CURRENCY_CODE',

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');
406: fa_rx_util_pkg.assign_column('250','CR.RECEIPT_NUMBER','RECEIPT_NUMBER',

Line 404: fa_rx_util_pkg.assign_column('240','CR.RECEIPT_DATE','RECEIPT_DATE',

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);
408: fa_rx_util_pkg.assign_column('260','CR.STATUS','RECEIPT_STATUS',

Line 406: fa_rx_util_pkg.assign_column('250','CR.RECEIPT_NUMBER','RECEIPT_NUMBER',

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);
410: fa_rx_util_pkg.assign_column('270','CR.TYPE','RECEIPT_TYPE',

Line 408: fa_rx_util_pkg.assign_column('260','CR.STATUS','RECEIPT_STATUS',

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);
412: fa_rx_util_pkg.assign_column('275','CR.AMOUNT','RECEIPT_AMOUNT',

Line 410: fa_rx_util_pkg.assign_column('270','CR.TYPE','RECEIPT_TYPE',

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');
414: fa_rx_util_pkg.assign_column('280','RB.NAME','REMIT_BATCH_NAME',

Line 412: fa_rx_util_pkg.assign_column('275','CR.AMOUNT','RECEIPT_AMOUNT',

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);
416:

Line 414: fa_rx_util_pkg.assign_column('280','RB.NAME','REMIT_BATCH_NAME',

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
418:

Line 419: fa_rx_util_pkg.debug('Assign FROM Clause using ALL tables');

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');
420: fa_rx_util_pkg.from_clause := ' AR_RECEIVABLE_APPLICATIONS_ALL APP
421: , AR_CASH_RECEIPTS_ALL CR
422: , AR_CASH_RECEIPT_HISTORY_ALL CRH
423: , AR_PAYMENT_SCHEDULES_ALL PS

Line 420: fa_rx_util_pkg.from_clause := ' AR_RECEIVABLE_APPLICATIONS_ALL APP

416:
417: -- Assign FROM clause
418:
419: fa_rx_util_pkg.debug('Assign FROM Clause using ALL tables');
420: fa_rx_util_pkg.from_clause := ' AR_RECEIVABLE_APPLICATIONS_ALL APP
421: , AR_CASH_RECEIPTS_ALL CR
422: , AR_CASH_RECEIPT_HISTORY_ALL CRH
423: , AR_PAYMENT_SCHEDULES_ALL PS
424: , HZ_CUST_ACCOUNTS_ALL CUST

Line 440: fa_rx_util_pkg.debug('AR_ASSIGN_WHERE_CLAUSE');

436: , AR_CASH_RECEIPT_HISTORY_ALL CRHFIRST
437: , AR_BATCH_SOURCES_ALL BSFIRST';
438:
439: -- Assign WHERE clause
440: fa_rx_util_pkg.debug('AR_ASSIGN_WHERE_CLAUSE');
441: fa_rx_util_pkg.where_clause := '
442: APP.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
443: AND APP.CASH_RECEIPT_ID = CRH.CASH_RECEIPT_ID
444: AND APP.APPLIED_PAYMENT_SCHEDULE_ID = PS.PAYMENT_SCHEDULE_ID

Line 441: fa_rx_util_pkg.where_clause := '

437: , AR_BATCH_SOURCES_ALL BSFIRST';
438:
439: -- Assign WHERE clause
440: fa_rx_util_pkg.debug('AR_ASSIGN_WHERE_CLAUSE');
441: fa_rx_util_pkg.where_clause := '
442: APP.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
443: AND APP.CASH_RECEIPT_ID = CRH.CASH_RECEIPT_ID
444: AND APP.APPLIED_PAYMENT_SCHEDULE_ID = PS.PAYMENT_SCHEDULE_ID
445: AND CRH.CURRENT_RECORD_FLAG = ''Y''

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

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

Line 498: fa_rx_util_pkg.debug('AR_GET_BIND');

494: procedure bind (c in integer)
495: is
496:
497: begin
498: fa_rx_util_pkg.debug('AR_GET_BIND');
499: --
500: -- Binding vars that appear in SELECT statement depending on input params
501: --
502: IF var.p_reporting_level = 3000 THEN