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_ADJ dependencies on FA_RX_UTIL_PKG

Line 156: fa_rx_util_pkg.enable_debug;

152: var.p_co_seg_high := p_co_seg_high;
153: var.p_doc_seq_name := p_doc_seq_name;
154: var.p_doc_seq_low := p_doc_seq_low;
155: var.p_doc_seq_high := p_doc_seq_high;
156: fa_rx_util_pkg.enable_debug;
157: --
158: -- Initialize request
159: fa_rx_util_pkg.init_request('arrx_adj.aradj_rep',request_id,'AR_ADJUSTMENTS_REP_ITF');
160:

Line 159: fa_rx_util_pkg.init_request('arrx_adj.aradj_rep',request_id,'AR_ADJUSTMENTS_REP_ITF');

155: var.p_doc_seq_high := p_doc_seq_high;
156: fa_rx_util_pkg.enable_debug;
157: --
158: -- Initialize request
159: fa_rx_util_pkg.init_request('arrx_adj.aradj_rep',request_id,'AR_ADJUSTMENTS_REP_ITF');
160:
161:
162: /* Bug 5244313 Setting the SOB based on the Reporting context */
163: if p_reporting_level = 1000 then

Line 189: fa_rx_util_pkg.assign_report('AR ADJUSTMENTS',

185: -- bind is assigned 'arrx_rc.bind(:CURSOR_SELECT);'
186: -- Each trigger event is assigned with the full procedure name (including package name).
187: -- They end with a ';'.
188: -- The bind trigger requires one host variable ':CURSOR_SELECT'.
189: fa_rx_util_pkg.assign_report('AR ADJUSTMENTS',
190: true,
191: 'arrx_adj.aradj_before_report;',
192: 'arrx_adj.aradj_bind(:CURSOR_SELECT);',
193: 'arrx_adj.aradj_after_fetch;',

Line 199: fa_rx_util_pkg.run_report('arrx_adj.aradj_rep', retcode, errbuf);

195:
196: --
197: -- Run the report. Make sure to pass as parameter the same
198: -- value passed to p_calling_proc in init_request().
199: fa_rx_util_pkg.run_report('arrx_adj.aradj_rep', retcode, errbuf);
200:
201: fa_rx_util_pkg.debug('arrx_adj.aradj_rep()-');
202:
203: exception

Line 201: fa_rx_util_pkg.debug('arrx_adj.aradj_rep()-');

197: -- Run the report. Make sure to pass as parameter the same
198: -- value passed to p_calling_proc in init_request().
199: fa_rx_util_pkg.run_report('arrx_adj.aradj_rep', retcode, errbuf);
200:
201: fa_rx_util_pkg.debug('arrx_adj.aradj_rep()-');
202:
203: exception
204: when others then
205: fa_rx_util_pkg.log(sqlcode);

Line 205: fa_rx_util_pkg.log(sqlcode);

201: fa_rx_util_pkg.debug('arrx_adj.aradj_rep()-');
202:
203: exception
204: when others then
205: fa_rx_util_pkg.log(sqlcode);
206: fa_rx_util_pkg.log(sqlerrm);
207: fa_rx_util_pkg.debug(sqlcode);
208: fa_rx_util_pkg.debug(sqlerrm);
209: fa_rx_util_pkg.debug('arrx_adj.aradj_rep(EXCEPTION)-');

Line 206: fa_rx_util_pkg.log(sqlerrm);

202:
203: exception
204: when others then
205: fa_rx_util_pkg.log(sqlcode);
206: fa_rx_util_pkg.log(sqlerrm);
207: fa_rx_util_pkg.debug(sqlcode);
208: fa_rx_util_pkg.debug(sqlerrm);
209: fa_rx_util_pkg.debug('arrx_adj.aradj_rep(EXCEPTION)-');
210: end aradj_rep;

Line 207: fa_rx_util_pkg.debug(sqlcode);

203: exception
204: when others then
205: fa_rx_util_pkg.log(sqlcode);
206: fa_rx_util_pkg.log(sqlerrm);
207: fa_rx_util_pkg.debug(sqlcode);
208: fa_rx_util_pkg.debug(sqlerrm);
209: fa_rx_util_pkg.debug('arrx_adj.aradj_rep(EXCEPTION)-');
210: end aradj_rep;
211:

Line 208: fa_rx_util_pkg.debug(sqlerrm);

204: when others then
205: fa_rx_util_pkg.log(sqlcode);
206: fa_rx_util_pkg.log(sqlerrm);
207: fa_rx_util_pkg.debug(sqlcode);
208: fa_rx_util_pkg.debug(sqlerrm);
209: fa_rx_util_pkg.debug('arrx_adj.aradj_rep(EXCEPTION)-');
210: end aradj_rep;
211:
212:

Line 209: fa_rx_util_pkg.debug('arrx_adj.aradj_rep(EXCEPTION)-');

205: fa_rx_util_pkg.log(sqlcode);
206: fa_rx_util_pkg.log(sqlerrm);
207: fa_rx_util_pkg.debug(sqlcode);
208: fa_rx_util_pkg.debug(sqlerrm);
209: fa_rx_util_pkg.debug('arrx_adj.aradj_rep(EXCEPTION)-');
210: end aradj_rep;
211:
212:
213: -- This is the before trigger for the main Adj Report ---

Line 262: fa_rx_util_pkg.debug('arrx_adj.adj_before_report()+');

258: DIST_CCID_STR VARCHAR2(500);
259:
260: begin
261:
262: fa_rx_util_pkg.debug('arrx_adj.adj_before_report()+');
263:
264: --
265: -- Get Profile GL_SET_OF_BKS_ID
266: --

Line 267: fa_rx_util_pkg.debug('GL_GET_PROFILE_BKS_ID');

263:
264: --
265: -- Get Profile GL_SET_OF_BKS_ID
266: --
267: fa_rx_util_pkg.debug('GL_GET_PROFILE_BKS_ID');
268:
269: -- bug 5244313
270: -- var.books_id := arp_global.sysparam.set_of_books_id;
271:

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

271:
272: --
273: -- Get CHART_OF_ACCOUNTS_ID
274: --
275: fa_rx_util_pkg.debug('GL_GET_CHART_OF_ACCOUNTS_ID');
276:
277: select CHART_OF_ACCOUNTS_ID,CURRENCY_CODE,NAME
278: into var.chart_of_accounts_id,var.functional_currency_code,var.organization_name
279: from GL_SETS_OF_BOOKS

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

278: into var.chart_of_accounts_id,var.functional_currency_code,var.organization_name
279: from GL_SETS_OF_BOOKS
280: where SET_OF_BOOKS_ID = var.books_id;
281:
282: fa_rx_util_pkg.debug('Chart of Accounts ID : '||var.chart_of_accounts_id);
283: fa_rx_util_pkg.debug('Functional Currency : '||var.functional_currency_code);
284: fa_rx_util_pkg.debug('Organization Name : '||var.organization_name);
285:
286: -- Get Accounting Method --5244313

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

279: from GL_SETS_OF_BOOKS
280: where SET_OF_BOOKS_ID = var.books_id;
281:
282: fa_rx_util_pkg.debug('Chart of Accounts ID : '||var.chart_of_accounts_id);
283: fa_rx_util_pkg.debug('Functional Currency : '||var.functional_currency_code);
284: fa_rx_util_pkg.debug('Organization Name : '||var.organization_name);
285:
286: -- Get Accounting Method --5244313
287: --bug fix 5595083

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

280: where SET_OF_BOOKS_ID = var.books_id;
281:
282: fa_rx_util_pkg.debug('Chart of Accounts ID : '||var.chart_of_accounts_id);
283: fa_rx_util_pkg.debug('Functional Currency : '||var.functional_currency_code);
284: fa_rx_util_pkg.debug('Organization Name : '||var.organization_name);
285:
286: -- Get Accounting Method --5244313
287: --bug fix 5595083
288: --Changing the logic of getting the accounting_method. The accounting_method should belong to the ledger for which the report is being generated.

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

315: --Bug fix 5595083 ends
316: --
317: -- Figure out NOCOPY the where clause for the parameters
318: --
319: fa_rx_util_pkg.debug('AR_GET_PARAMETERS');
320:
321: --
322: --CURRENCY_CODE where clause
323: --

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

490: --
491: -- Assign SELECT list
492: --
493:
494: fa_rx_util_pkg.debug('ARTX_ASSIGN_SELECT_LIST');
495:
496: -->>SELECT_START<<--
497:
498: fa_rx_util_pkg.assign_column('10',NULL ,'ORGANIZATION_NAME' ,'arrx_adj.var.organization_name' ,'VARCHAR2',50);

Line 498: fa_rx_util_pkg.assign_column('10',NULL ,'ORGANIZATION_NAME' ,'arrx_adj.var.organization_name' ,'VARCHAR2',50);

494: fa_rx_util_pkg.debug('ARTX_ASSIGN_SELECT_LIST');
495:
496: -->>SELECT_START<<--
497:
498: fa_rx_util_pkg.assign_column('10',NULL ,'ORGANIZATION_NAME' ,'arrx_adj.var.organization_name' ,'VARCHAR2',50);
499: fa_rx_util_pkg.assign_column('20',NULL ,'FUNCTIONAL_CURRENCY_CODE' ,'arrx_adj.var.functional_currency_code' ,'VARCHAR2',15);
500: fa_rx_util_pkg.assign_column('30',POSTABLE_DECODE ,'POSTABLE' ,'arrx_adj.var.postable' ,'VARCHAR2',15);
501: fa_rx_util_pkg.assign_column('40','trx.invoice_currency_code' ,'ADJ_CURRENCY_CODE' ,'arrx_adj.var.adj_currency_code' ,'VARCHAR2',15);
502: fa_rx_util_pkg.assign_column('50','1' ,'CONS' ,'arrx_adj.var.cons' ,'VARCHAR2',15);

Line 499: fa_rx_util_pkg.assign_column('20',NULL ,'FUNCTIONAL_CURRENCY_CODE' ,'arrx_adj.var.functional_currency_code' ,'VARCHAR2',15);

495:
496: -->>SELECT_START<<--
497:
498: fa_rx_util_pkg.assign_column('10',NULL ,'ORGANIZATION_NAME' ,'arrx_adj.var.organization_name' ,'VARCHAR2',50);
499: fa_rx_util_pkg.assign_column('20',NULL ,'FUNCTIONAL_CURRENCY_CODE' ,'arrx_adj.var.functional_currency_code' ,'VARCHAR2',15);
500: fa_rx_util_pkg.assign_column('30',POSTABLE_DECODE ,'POSTABLE' ,'arrx_adj.var.postable' ,'VARCHAR2',15);
501: fa_rx_util_pkg.assign_column('40','trx.invoice_currency_code' ,'ADJ_CURRENCY_CODE' ,'arrx_adj.var.adj_currency_code' ,'VARCHAR2',15);
502: fa_rx_util_pkg.assign_column('50','1' ,'CONS' ,'arrx_adj.var.cons' ,'VARCHAR2',15);
503: /*fa_rx_util_pkg.assign_column('60',SORTBY_DECODE ,'SORTBY' ,'arrx_adj.var.sortby' ,'VARCHAR2',30);*/

Line 500: fa_rx_util_pkg.assign_column('30',POSTABLE_DECODE ,'POSTABLE' ,'arrx_adj.var.postable' ,'VARCHAR2',15);

496: -->>SELECT_START<<--
497:
498: fa_rx_util_pkg.assign_column('10',NULL ,'ORGANIZATION_NAME' ,'arrx_adj.var.organization_name' ,'VARCHAR2',50);
499: fa_rx_util_pkg.assign_column('20',NULL ,'FUNCTIONAL_CURRENCY_CODE' ,'arrx_adj.var.functional_currency_code' ,'VARCHAR2',15);
500: fa_rx_util_pkg.assign_column('30',POSTABLE_DECODE ,'POSTABLE' ,'arrx_adj.var.postable' ,'VARCHAR2',15);
501: fa_rx_util_pkg.assign_column('40','trx.invoice_currency_code' ,'ADJ_CURRENCY_CODE' ,'arrx_adj.var.adj_currency_code' ,'VARCHAR2',15);
502: fa_rx_util_pkg.assign_column('50','1' ,'CONS' ,'arrx_adj.var.cons' ,'VARCHAR2',15);
503: /*fa_rx_util_pkg.assign_column('60',SORTBY_DECODE ,'SORTBY' ,'arrx_adj.var.sortby' ,'VARCHAR2',30);*/
504: fa_rx_util_pkg.assign_column('60',' arpt_sql_func_util.get_trx_type_details(trx.cust_trx_type_id,''NAME'',trx.org_id)' ,'ADJ_NAME' ,'arrx_adj.var.adj_name' ,'VARCHAR2',30);

Line 501: fa_rx_util_pkg.assign_column('40','trx.invoice_currency_code' ,'ADJ_CURRENCY_CODE' ,'arrx_adj.var.adj_currency_code' ,'VARCHAR2',15);

497:
498: fa_rx_util_pkg.assign_column('10',NULL ,'ORGANIZATION_NAME' ,'arrx_adj.var.organization_name' ,'VARCHAR2',50);
499: fa_rx_util_pkg.assign_column('20',NULL ,'FUNCTIONAL_CURRENCY_CODE' ,'arrx_adj.var.functional_currency_code' ,'VARCHAR2',15);
500: fa_rx_util_pkg.assign_column('30',POSTABLE_DECODE ,'POSTABLE' ,'arrx_adj.var.postable' ,'VARCHAR2',15);
501: fa_rx_util_pkg.assign_column('40','trx.invoice_currency_code' ,'ADJ_CURRENCY_CODE' ,'arrx_adj.var.adj_currency_code' ,'VARCHAR2',15);
502: fa_rx_util_pkg.assign_column('50','1' ,'CONS' ,'arrx_adj.var.cons' ,'VARCHAR2',15);
503: /*fa_rx_util_pkg.assign_column('60',SORTBY_DECODE ,'SORTBY' ,'arrx_adj.var.sortby' ,'VARCHAR2',30);*/
504: fa_rx_util_pkg.assign_column('60',' arpt_sql_func_util.get_trx_type_details(trx.cust_trx_type_id,''NAME'',trx.org_id)' ,'ADJ_NAME' ,'arrx_adj.var.adj_name' ,'VARCHAR2',30);
505: fa_rx_util_pkg.assign_column('70',D_OR_I_DECODE ,'D_OR_I' ,'arrx_adj.var.d_or_i' ,'VARCHAR2',6);

Line 502: fa_rx_util_pkg.assign_column('50','1' ,'CONS' ,'arrx_adj.var.cons' ,'VARCHAR2',15);

498: fa_rx_util_pkg.assign_column('10',NULL ,'ORGANIZATION_NAME' ,'arrx_adj.var.organization_name' ,'VARCHAR2',50);
499: fa_rx_util_pkg.assign_column('20',NULL ,'FUNCTIONAL_CURRENCY_CODE' ,'arrx_adj.var.functional_currency_code' ,'VARCHAR2',15);
500: fa_rx_util_pkg.assign_column('30',POSTABLE_DECODE ,'POSTABLE' ,'arrx_adj.var.postable' ,'VARCHAR2',15);
501: fa_rx_util_pkg.assign_column('40','trx.invoice_currency_code' ,'ADJ_CURRENCY_CODE' ,'arrx_adj.var.adj_currency_code' ,'VARCHAR2',15);
502: fa_rx_util_pkg.assign_column('50','1' ,'CONS' ,'arrx_adj.var.cons' ,'VARCHAR2',15);
503: /*fa_rx_util_pkg.assign_column('60',SORTBY_DECODE ,'SORTBY' ,'arrx_adj.var.sortby' ,'VARCHAR2',30);*/
504: fa_rx_util_pkg.assign_column('60',' arpt_sql_func_util.get_trx_type_details(trx.cust_trx_type_id,''NAME'',trx.org_id)' ,'ADJ_NAME' ,'arrx_adj.var.adj_name' ,'VARCHAR2',30);
505: fa_rx_util_pkg.assign_column('70',D_OR_I_DECODE ,'D_OR_I' ,'arrx_adj.var.d_or_i' ,'VARCHAR2',6);
506: IF (BILL_FLAG = 'Y') THEN

Line 503: /fa_rx_util_pkg.assign_column('60',SORTBY_DECODE ,'SORTBY' ,'arrx_adj.var.sortby' ,'VARCHAR2',30);/

499: fa_rx_util_pkg.assign_column('20',NULL ,'FUNCTIONAL_CURRENCY_CODE' ,'arrx_adj.var.functional_currency_code' ,'VARCHAR2',15);
500: fa_rx_util_pkg.assign_column('30',POSTABLE_DECODE ,'POSTABLE' ,'arrx_adj.var.postable' ,'VARCHAR2',15);
501: fa_rx_util_pkg.assign_column('40','trx.invoice_currency_code' ,'ADJ_CURRENCY_CODE' ,'arrx_adj.var.adj_currency_code' ,'VARCHAR2',15);
502: fa_rx_util_pkg.assign_column('50','1' ,'CONS' ,'arrx_adj.var.cons' ,'VARCHAR2',15);
503: /*fa_rx_util_pkg.assign_column('60',SORTBY_DECODE ,'SORTBY' ,'arrx_adj.var.sortby' ,'VARCHAR2',30);*/
504: fa_rx_util_pkg.assign_column('60',' arpt_sql_func_util.get_trx_type_details(trx.cust_trx_type_id,''NAME'',trx.org_id)' ,'ADJ_NAME' ,'arrx_adj.var.adj_name' ,'VARCHAR2',30);
505: fa_rx_util_pkg.assign_column('70',D_OR_I_DECODE ,'D_OR_I' ,'arrx_adj.var.d_or_i' ,'VARCHAR2',6);
506: IF (BILL_FLAG = 'Y') THEN
507: fa_rx_util_pkg.assign_column('80','decode(ci.cons_billing_number, null, trx.trx_number, SUBSTRB(trx.trx_number||''/''||rtrim(ci.cons_billing_number),1,36))' ,'TRX_NUMBER' ,'arrx_adj.var.trx_number' ,'VARCHAR2',36);--bug4612433

Line 504: fa_rx_util_pkg.assign_column('60',' arpt_sql_func_util.get_trx_type_details(trx.cust_trx_type_id,''NAME'',trx.org_id)' ,'ADJ_NAME' ,'arrx_adj.var.adj_name' ,'VARCHAR2',30);

500: fa_rx_util_pkg.assign_column('30',POSTABLE_DECODE ,'POSTABLE' ,'arrx_adj.var.postable' ,'VARCHAR2',15);
501: fa_rx_util_pkg.assign_column('40','trx.invoice_currency_code' ,'ADJ_CURRENCY_CODE' ,'arrx_adj.var.adj_currency_code' ,'VARCHAR2',15);
502: fa_rx_util_pkg.assign_column('50','1' ,'CONS' ,'arrx_adj.var.cons' ,'VARCHAR2',15);
503: /*fa_rx_util_pkg.assign_column('60',SORTBY_DECODE ,'SORTBY' ,'arrx_adj.var.sortby' ,'VARCHAR2',30);*/
504: fa_rx_util_pkg.assign_column('60',' arpt_sql_func_util.get_trx_type_details(trx.cust_trx_type_id,''NAME'',trx.org_id)' ,'ADJ_NAME' ,'arrx_adj.var.adj_name' ,'VARCHAR2',30);
505: fa_rx_util_pkg.assign_column('70',D_OR_I_DECODE ,'D_OR_I' ,'arrx_adj.var.d_or_i' ,'VARCHAR2',6);
506: IF (BILL_FLAG = 'Y') THEN
507: fa_rx_util_pkg.assign_column('80','decode(ci.cons_billing_number, null, trx.trx_number, SUBSTRB(trx.trx_number||''/''||rtrim(ci.cons_billing_number),1,36))' ,'TRX_NUMBER' ,'arrx_adj.var.trx_number' ,'VARCHAR2',36);--bug4612433
508: ELSE

Line 505: fa_rx_util_pkg.assign_column('70',D_OR_I_DECODE ,'D_OR_I' ,'arrx_adj.var.d_or_i' ,'VARCHAR2',6);

501: fa_rx_util_pkg.assign_column('40','trx.invoice_currency_code' ,'ADJ_CURRENCY_CODE' ,'arrx_adj.var.adj_currency_code' ,'VARCHAR2',15);
502: fa_rx_util_pkg.assign_column('50','1' ,'CONS' ,'arrx_adj.var.cons' ,'VARCHAR2',15);
503: /*fa_rx_util_pkg.assign_column('60',SORTBY_DECODE ,'SORTBY' ,'arrx_adj.var.sortby' ,'VARCHAR2',30);*/
504: fa_rx_util_pkg.assign_column('60',' arpt_sql_func_util.get_trx_type_details(trx.cust_trx_type_id,''NAME'',trx.org_id)' ,'ADJ_NAME' ,'arrx_adj.var.adj_name' ,'VARCHAR2',30);
505: fa_rx_util_pkg.assign_column('70',D_OR_I_DECODE ,'D_OR_I' ,'arrx_adj.var.d_or_i' ,'VARCHAR2',6);
506: IF (BILL_FLAG = 'Y') THEN
507: fa_rx_util_pkg.assign_column('80','decode(ci.cons_billing_number, null, trx.trx_number, SUBSTRB(trx.trx_number||''/''||rtrim(ci.cons_billing_number),1,36))' ,'TRX_NUMBER' ,'arrx_adj.var.trx_number' ,'VARCHAR2',36);--bug4612433
508: ELSE
509: fa_rx_util_pkg.assign_column('80','trx.trx_number' ,'TRX_NUMBER' ,'arrx_adj.var.trx_number' ,'VARCHAR2',36);--bug4612433

Line 507: fa_rx_util_pkg.assign_column('80','decode(ci.cons_billing_number, null, trx.trx_number, SUBSTRB(trx.trx_number||''/''||rtrim(ci.cons_billing_number),1,36))' ,'TRX_NUMBER' ,'arrx_adj.var.trx_number' ,'VARCHAR2',36);--bug4612433

503: /*fa_rx_util_pkg.assign_column('60',SORTBY_DECODE ,'SORTBY' ,'arrx_adj.var.sortby' ,'VARCHAR2',30);*/
504: fa_rx_util_pkg.assign_column('60',' arpt_sql_func_util.get_trx_type_details(trx.cust_trx_type_id,''NAME'',trx.org_id)' ,'ADJ_NAME' ,'arrx_adj.var.adj_name' ,'VARCHAR2',30);
505: fa_rx_util_pkg.assign_column('70',D_OR_I_DECODE ,'D_OR_I' ,'arrx_adj.var.d_or_i' ,'VARCHAR2',6);
506: IF (BILL_FLAG = 'Y') THEN
507: fa_rx_util_pkg.assign_column('80','decode(ci.cons_billing_number, null, trx.trx_number, SUBSTRB(trx.trx_number||''/''||rtrim(ci.cons_billing_number),1,36))' ,'TRX_NUMBER' ,'arrx_adj.var.trx_number' ,'VARCHAR2',36);--bug4612433
508: ELSE
509: fa_rx_util_pkg.assign_column('80','trx.trx_number' ,'TRX_NUMBER' ,'arrx_adj.var.trx_number' ,'VARCHAR2',36);--bug4612433
510: END IF;
511: fa_rx_util_pkg.assign_column('90','pay.due_date' ,'DUE_DATE' ,'arrx_adj.var.due_date' ,'DATE');

Line 509: fa_rx_util_pkg.assign_column('80','trx.trx_number' ,'TRX_NUMBER' ,'arrx_adj.var.trx_number' ,'VARCHAR2',36);--bug4612433

505: fa_rx_util_pkg.assign_column('70',D_OR_I_DECODE ,'D_OR_I' ,'arrx_adj.var.d_or_i' ,'VARCHAR2',6);
506: IF (BILL_FLAG = 'Y') THEN
507: fa_rx_util_pkg.assign_column('80','decode(ci.cons_billing_number, null, trx.trx_number, SUBSTRB(trx.trx_number||''/''||rtrim(ci.cons_billing_number),1,36))' ,'TRX_NUMBER' ,'arrx_adj.var.trx_number' ,'VARCHAR2',36);--bug4612433
508: ELSE
509: fa_rx_util_pkg.assign_column('80','trx.trx_number' ,'TRX_NUMBER' ,'arrx_adj.var.trx_number' ,'VARCHAR2',36);--bug4612433
510: END IF;
511: fa_rx_util_pkg.assign_column('90','pay.due_date' ,'DUE_DATE' ,'arrx_adj.var.due_date' ,'DATE');
512: fa_rx_util_pkg.assign_column('100','adj.gl_date' ,'GL_DATE' ,'arrx_adj.var.gl_date' ,'DATE');
513: -- Bug 1371540 Aug 2000: changed reference from Adjustment_id to Adjustment_number: jskhan

Line 511: fa_rx_util_pkg.assign_column('90','pay.due_date' ,'DUE_DATE' ,'arrx_adj.var.due_date' ,'DATE');

507: fa_rx_util_pkg.assign_column('80','decode(ci.cons_billing_number, null, trx.trx_number, SUBSTRB(trx.trx_number||''/''||rtrim(ci.cons_billing_number),1,36))' ,'TRX_NUMBER' ,'arrx_adj.var.trx_number' ,'VARCHAR2',36);--bug4612433
508: ELSE
509: fa_rx_util_pkg.assign_column('80','trx.trx_number' ,'TRX_NUMBER' ,'arrx_adj.var.trx_number' ,'VARCHAR2',36);--bug4612433
510: END IF;
511: fa_rx_util_pkg.assign_column('90','pay.due_date' ,'DUE_DATE' ,'arrx_adj.var.due_date' ,'DATE');
512: fa_rx_util_pkg.assign_column('100','adj.gl_date' ,'GL_DATE' ,'arrx_adj.var.gl_date' ,'DATE');
513: -- Bug 1371540 Aug 2000: changed reference from Adjustment_id to Adjustment_number: jskhan
514: fa_rx_util_pkg.assign_column('110','adj.adjustment_number' ,'ADJ_NUMBER' ,'arrx_adj.var.adj_number' ,'VARCHAR2',20);
515: fa_rx_util_pkg.assign_column('120',ADJ_CLASS_DECODE ,'ADJ_CLASS' ,'arrx_adj.var.adj_class' ,'VARCHAR2',30);

Line 512: fa_rx_util_pkg.assign_column('100','adj.gl_date' ,'GL_DATE' ,'arrx_adj.var.gl_date' ,'DATE');

508: ELSE
509: fa_rx_util_pkg.assign_column('80','trx.trx_number' ,'TRX_NUMBER' ,'arrx_adj.var.trx_number' ,'VARCHAR2',36);--bug4612433
510: END IF;
511: fa_rx_util_pkg.assign_column('90','pay.due_date' ,'DUE_DATE' ,'arrx_adj.var.due_date' ,'DATE');
512: fa_rx_util_pkg.assign_column('100','adj.gl_date' ,'GL_DATE' ,'arrx_adj.var.gl_date' ,'DATE');
513: -- Bug 1371540 Aug 2000: changed reference from Adjustment_id to Adjustment_number: jskhan
514: fa_rx_util_pkg.assign_column('110','adj.adjustment_number' ,'ADJ_NUMBER' ,'arrx_adj.var.adj_number' ,'VARCHAR2',20);
515: fa_rx_util_pkg.assign_column('120',ADJ_CLASS_DECODE ,'ADJ_CLASS' ,'arrx_adj.var.adj_class' ,'VARCHAR2',30);
516: fa_rx_util_pkg.assign_column('130','adj.type' ,'ADJ_TYPE_CODE' ,'arrx_adj.var.adj_type_code' ,'VARCHAR2',30);

Line 514: fa_rx_util_pkg.assign_column('110','adj.adjustment_number' ,'ADJ_NUMBER' ,'arrx_adj.var.adj_number' ,'VARCHAR2',20);

510: END IF;
511: fa_rx_util_pkg.assign_column('90','pay.due_date' ,'DUE_DATE' ,'arrx_adj.var.due_date' ,'DATE');
512: fa_rx_util_pkg.assign_column('100','adj.gl_date' ,'GL_DATE' ,'arrx_adj.var.gl_date' ,'DATE');
513: -- Bug 1371540 Aug 2000: changed reference from Adjustment_id to Adjustment_number: jskhan
514: fa_rx_util_pkg.assign_column('110','adj.adjustment_number' ,'ADJ_NUMBER' ,'arrx_adj.var.adj_number' ,'VARCHAR2',20);
515: fa_rx_util_pkg.assign_column('120',ADJ_CLASS_DECODE ,'ADJ_CLASS' ,'arrx_adj.var.adj_class' ,'VARCHAR2',30);
516: fa_rx_util_pkg.assign_column('130','adj.type' ,'ADJ_TYPE_CODE' ,'arrx_adj.var.adj_type_code' ,'VARCHAR2',30);
517: fa_rx_util_pkg.assign_column('140','ladjtype.meaning' ,'ADJ_TYPE_MEANING' ,'arrx_adj.var.adj_type_meaning' ,'VARCHAR2',30);
518: /*bug5968198 changed to retrieve customer name based on party_type.*/

Line 515: fa_rx_util_pkg.assign_column('120',ADJ_CLASS_DECODE ,'ADJ_CLASS' ,'arrx_adj.var.adj_class' ,'VARCHAR2',30);

511: fa_rx_util_pkg.assign_column('90','pay.due_date' ,'DUE_DATE' ,'arrx_adj.var.due_date' ,'DATE');
512: fa_rx_util_pkg.assign_column('100','adj.gl_date' ,'GL_DATE' ,'arrx_adj.var.gl_date' ,'DATE');
513: -- Bug 1371540 Aug 2000: changed reference from Adjustment_id to Adjustment_number: jskhan
514: fa_rx_util_pkg.assign_column('110','adj.adjustment_number' ,'ADJ_NUMBER' ,'arrx_adj.var.adj_number' ,'VARCHAR2',20);
515: fa_rx_util_pkg.assign_column('120',ADJ_CLASS_DECODE ,'ADJ_CLASS' ,'arrx_adj.var.adj_class' ,'VARCHAR2',30);
516: fa_rx_util_pkg.assign_column('130','adj.type' ,'ADJ_TYPE_CODE' ,'arrx_adj.var.adj_type_code' ,'VARCHAR2',30);
517: fa_rx_util_pkg.assign_column('140','ladjtype.meaning' ,'ADJ_TYPE_MEANING' ,'arrx_adj.var.adj_type_meaning' ,'VARCHAR2',30);
518: /*bug5968198 changed to retrieve customer name based on party_type.*/
519: fa_rx_util_pkg.assign_column('150','substrb(decode(UPPER(party.party_type), ''ORGANIZATION'', org.organization_name, ''PERSON'',

Line 516: fa_rx_util_pkg.assign_column('130','adj.type' ,'ADJ_TYPE_CODE' ,'arrx_adj.var.adj_type_code' ,'VARCHAR2',30);

512: fa_rx_util_pkg.assign_column('100','adj.gl_date' ,'GL_DATE' ,'arrx_adj.var.gl_date' ,'DATE');
513: -- Bug 1371540 Aug 2000: changed reference from Adjustment_id to Adjustment_number: jskhan
514: fa_rx_util_pkg.assign_column('110','adj.adjustment_number' ,'ADJ_NUMBER' ,'arrx_adj.var.adj_number' ,'VARCHAR2',20);
515: fa_rx_util_pkg.assign_column('120',ADJ_CLASS_DECODE ,'ADJ_CLASS' ,'arrx_adj.var.adj_class' ,'VARCHAR2',30);
516: fa_rx_util_pkg.assign_column('130','adj.type' ,'ADJ_TYPE_CODE' ,'arrx_adj.var.adj_type_code' ,'VARCHAR2',30);
517: fa_rx_util_pkg.assign_column('140','ladjtype.meaning' ,'ADJ_TYPE_MEANING' ,'arrx_adj.var.adj_type_meaning' ,'VARCHAR2',30);
518: /*bug5968198 changed to retrieve customer name based on party_type.*/
519: fa_rx_util_pkg.assign_column('150','substrb(decode(UPPER(party.party_type), ''ORGANIZATION'', org.organization_name, ''PERSON'',
520: per.person_name, party.party_name) ,1,50)' ,'CUSTOMER_NAME' ,'arrx_adj.var.customer_name' ,'VARCHAR2',50);

Line 517: fa_rx_util_pkg.assign_column('140','ladjtype.meaning' ,'ADJ_TYPE_MEANING' ,'arrx_adj.var.adj_type_meaning' ,'VARCHAR2',30);

513: -- Bug 1371540 Aug 2000: changed reference from Adjustment_id to Adjustment_number: jskhan
514: fa_rx_util_pkg.assign_column('110','adj.adjustment_number' ,'ADJ_NUMBER' ,'arrx_adj.var.adj_number' ,'VARCHAR2',20);
515: fa_rx_util_pkg.assign_column('120',ADJ_CLASS_DECODE ,'ADJ_CLASS' ,'arrx_adj.var.adj_class' ,'VARCHAR2',30);
516: fa_rx_util_pkg.assign_column('130','adj.type' ,'ADJ_TYPE_CODE' ,'arrx_adj.var.adj_type_code' ,'VARCHAR2',30);
517: fa_rx_util_pkg.assign_column('140','ladjtype.meaning' ,'ADJ_TYPE_MEANING' ,'arrx_adj.var.adj_type_meaning' ,'VARCHAR2',30);
518: /*bug5968198 changed to retrieve customer name based on party_type.*/
519: fa_rx_util_pkg.assign_column('150','substrb(decode(UPPER(party.party_type), ''ORGANIZATION'', org.organization_name, ''PERSON'',
520: per.person_name, party.party_name) ,1,50)' ,'CUSTOMER_NAME' ,'arrx_adj.var.customer_name' ,'VARCHAR2',50);
521: fa_rx_util_pkg.assign_column('160','cust.account_number' ,'CUSTOMER_NUMBER' ,'arrx_adj.var.customer_number' ,'VARCHAR2',30);

Line 519: fa_rx_util_pkg.assign_column('150','substrb(decode(UPPER(party.party_type), ''ORGANIZATION'', org.organization_name, ''PERSON'',

515: fa_rx_util_pkg.assign_column('120',ADJ_CLASS_DECODE ,'ADJ_CLASS' ,'arrx_adj.var.adj_class' ,'VARCHAR2',30);
516: fa_rx_util_pkg.assign_column('130','adj.type' ,'ADJ_TYPE_CODE' ,'arrx_adj.var.adj_type_code' ,'VARCHAR2',30);
517: fa_rx_util_pkg.assign_column('140','ladjtype.meaning' ,'ADJ_TYPE_MEANING' ,'arrx_adj.var.adj_type_meaning' ,'VARCHAR2',30);
518: /*bug5968198 changed to retrieve customer name based on party_type.*/
519: fa_rx_util_pkg.assign_column('150','substrb(decode(UPPER(party.party_type), ''ORGANIZATION'', org.organization_name, ''PERSON'',
520: per.person_name, party.party_name) ,1,50)' ,'CUSTOMER_NAME' ,'arrx_adj.var.customer_name' ,'VARCHAR2',50);
521: fa_rx_util_pkg.assign_column('160','cust.account_number' ,'CUSTOMER_NUMBER' ,'arrx_adj.var.customer_number' ,'VARCHAR2',30);
522: fa_rx_util_pkg.assign_column('170','cust.cust_account_id' ,'CUSTOMER_ID' ,'arrx_adj.var.customer_id' ,'NUMBER');
523: fa_rx_util_pkg.assign_column('180','trx.trx_date' ,'TRX_DATE' ,'arrx_adj.var.trx_date' ,'DATE');

Line 521: fa_rx_util_pkg.assign_column('160','cust.account_number' ,'CUSTOMER_NUMBER' ,'arrx_adj.var.customer_number' ,'VARCHAR2',30);

517: fa_rx_util_pkg.assign_column('140','ladjtype.meaning' ,'ADJ_TYPE_MEANING' ,'arrx_adj.var.adj_type_meaning' ,'VARCHAR2',30);
518: /*bug5968198 changed to retrieve customer name based on party_type.*/
519: fa_rx_util_pkg.assign_column('150','substrb(decode(UPPER(party.party_type), ''ORGANIZATION'', org.organization_name, ''PERSON'',
520: per.person_name, party.party_name) ,1,50)' ,'CUSTOMER_NAME' ,'arrx_adj.var.customer_name' ,'VARCHAR2',50);
521: fa_rx_util_pkg.assign_column('160','cust.account_number' ,'CUSTOMER_NUMBER' ,'arrx_adj.var.customer_number' ,'VARCHAR2',30);
522: fa_rx_util_pkg.assign_column('170','cust.cust_account_id' ,'CUSTOMER_ID' ,'arrx_adj.var.customer_id' ,'NUMBER');
523: fa_rx_util_pkg.assign_column('180','trx.trx_date' ,'TRX_DATE' ,'arrx_adj.var.trx_date' ,'DATE');
524:
525: if accounting_method = 'ACCRUAL' then

Line 522: fa_rx_util_pkg.assign_column('170','cust.cust_account_id' ,'CUSTOMER_ID' ,'arrx_adj.var.customer_id' ,'NUMBER');

518: /*bug5968198 changed to retrieve customer name based on party_type.*/
519: fa_rx_util_pkg.assign_column('150','substrb(decode(UPPER(party.party_type), ''ORGANIZATION'', org.organization_name, ''PERSON'',
520: per.person_name, party.party_name) ,1,50)' ,'CUSTOMER_NAME' ,'arrx_adj.var.customer_name' ,'VARCHAR2',50);
521: fa_rx_util_pkg.assign_column('160','cust.account_number' ,'CUSTOMER_NUMBER' ,'arrx_adj.var.customer_number' ,'VARCHAR2',30);
522: fa_rx_util_pkg.assign_column('170','cust.cust_account_id' ,'CUSTOMER_ID' ,'arrx_adj.var.customer_id' ,'NUMBER');
523: fa_rx_util_pkg.assign_column('180','trx.trx_date' ,'TRX_DATE' ,'arrx_adj.var.trx_date' ,'DATE');
524:
525: if accounting_method = 'ACCRUAL' then
526:

Line 523: fa_rx_util_pkg.assign_column('180','trx.trx_date' ,'TRX_DATE' ,'arrx_adj.var.trx_date' ,'DATE');

519: fa_rx_util_pkg.assign_column('150','substrb(decode(UPPER(party.party_type), ''ORGANIZATION'', org.organization_name, ''PERSON'',
520: per.person_name, party.party_name) ,1,50)' ,'CUSTOMER_NAME' ,'arrx_adj.var.customer_name' ,'VARCHAR2',50);
521: fa_rx_util_pkg.assign_column('160','cust.account_number' ,'CUSTOMER_NUMBER' ,'arrx_adj.var.customer_number' ,'VARCHAR2',30);
522: fa_rx_util_pkg.assign_column('170','cust.cust_account_id' ,'CUSTOMER_ID' ,'arrx_adj.var.customer_id' ,'NUMBER');
523: fa_rx_util_pkg.assign_column('180','trx.trx_date' ,'TRX_DATE' ,'arrx_adj.var.trx_date' ,'DATE');
524:
525: if accounting_method = 'ACCRUAL' then
526:
527: DIST_ENTERED := 'arrx_adj.dist_details(adj.adjustment_id, ' || var.chart_of_accounts_id ||

Line 533: fa_rx_util_pkg.assign_column('190',

529: DIST_ACCTD := 'arrx_adj.dist_details(adj.adjustment_id, ' || var.chart_of_accounts_id ||
530: ',' || var.p_reporting_entity_id || ', ''ACCTD'')';
531: DIST_CCID_STR := 'arrx_adj.dist_ccid(adj.adjustment_id, ' || var.chart_of_accounts_id ||
532: ',' || var.p_reporting_entity_id || ')';
533: fa_rx_util_pkg.assign_column('190',
534: DIST_ENTERED,
535: 'ADJ_AMOUNT',
536: 'arrx_adj.var.adj_amount',
537: 'NUMBER');

Line 538: fa_rx_util_pkg.assign_column('200',

534: DIST_ENTERED,
535: 'ADJ_AMOUNT',
536: 'arrx_adj.var.adj_amount',
537: 'NUMBER');
538: fa_rx_util_pkg.assign_column('200',
539: DIST_ACCTD,
540: 'ACCTD_ADJ_AMOUNT',
541: 'arrx_adj.var.acctd_adj_amount',
542: 'NUMBER');

Line 543: fa_rx_util_pkg.assign_column('210',

539: DIST_ACCTD,
540: 'ACCTD_ADJ_AMOUNT',
541: 'arrx_adj.var.acctd_adj_amount',
542: 'NUMBER');
543: fa_rx_util_pkg.assign_column('210',
544: DIST_CCID_STR,
545: 'ACCOUNT_CODE_COMBINATION_ID',
546: 'arrx_adj.var.account_code_combination_id',
547: 'VARCHAR2',240);

Line 549: fa_rx_util_pkg.assign_column('190',

545: 'ACCOUNT_CODE_COMBINATION_ID',
546: 'arrx_adj.var.account_code_combination_id',
547: 'VARCHAR2',240);
548: else
549: fa_rx_util_pkg.assign_column('190',
550: 'round(adj.amount,2)',
551: 'ADJ_AMOUNT',
552: 'arrx_adj.var.adj_amount',
553: 'NUMBER');

Line 554: fa_rx_util_pkg.assign_column('200',

550: 'round(adj.amount,2)',
551: 'ADJ_AMOUNT',
552: 'arrx_adj.var.adj_amount',
553: 'NUMBER');
554: fa_rx_util_pkg.assign_column('200',
555: 'adj.acctd_amount',
556: 'ACCTD_ADJ_AMOUNT',
557: 'arrx_adj.var.acctd_adj_amount',
558: 'NUMBER');

Line 559: fa_rx_util_pkg.assign_column('210',

555: 'adj.acctd_amount',
556: 'ACCTD_ADJ_AMOUNT',
557: 'arrx_adj.var.acctd_adj_amount',
558: 'NUMBER');
559: fa_rx_util_pkg.assign_column('210',
560: 'glc.code_combination_id',
561: 'ACCOUNT_CODE_COMBINATION_ID',
562: 'arrx_adj.var.account_code_combination_id',
563: 'VARCHAR2',240);

Line 567: fa_rx_util_pkg.assign_column('230',null ,'DEBIT_ACCOUNT_DESC' ,'arrx_adj.var.debit_account_desc' ,'VARCHAR2',240);

563: 'VARCHAR2',240);
564: end if;
565:
566:
567: fa_rx_util_pkg.assign_column('230',null ,'DEBIT_ACCOUNT_DESC' ,'arrx_adj.var.debit_account_desc' ,'VARCHAR2',240);
568: fa_rx_util_pkg.assign_column('240',null ,'DEBIT_BALANCING' ,'arrx_adj.var.debit_balancing' ,'VARCHAR2',240);
569: fa_rx_util_pkg.assign_column('250',null ,'DEBIT_BALANCING_DESC' ,'arrx_adj.var.debit_balancing_desc' ,'VARCHAR2',240);
570: fa_rx_util_pkg.assign_column('260',null ,'DEBIT_NATACCT' ,'arrx_adj.var.debit_natacct' ,'VARCHAR2',240);
571: fa_rx_util_pkg.assign_column('270',null ,'DEBIT_NATACCT_DESC' ,'arrx_adj.var.debit_natacct_desc' ,'VARCHAR2',240);

Line 568: fa_rx_util_pkg.assign_column('240',null ,'DEBIT_BALANCING' ,'arrx_adj.var.debit_balancing' ,'VARCHAR2',240);

564: end if;
565:
566:
567: fa_rx_util_pkg.assign_column('230',null ,'DEBIT_ACCOUNT_DESC' ,'arrx_adj.var.debit_account_desc' ,'VARCHAR2',240);
568: fa_rx_util_pkg.assign_column('240',null ,'DEBIT_BALANCING' ,'arrx_adj.var.debit_balancing' ,'VARCHAR2',240);
569: fa_rx_util_pkg.assign_column('250',null ,'DEBIT_BALANCING_DESC' ,'arrx_adj.var.debit_balancing_desc' ,'VARCHAR2',240);
570: fa_rx_util_pkg.assign_column('260',null ,'DEBIT_NATACCT' ,'arrx_adj.var.debit_natacct' ,'VARCHAR2',240);
571: fa_rx_util_pkg.assign_column('270',null ,'DEBIT_NATACCT_DESC' ,'arrx_adj.var.debit_natacct_desc' ,'VARCHAR2',240);
572: fa_rx_util_pkg.assign_column('280','nvl(adj.doc_sequence_value,'''')' ,'DOC_SEQUENCE_VALUE' ,'arrx_adj.var.doc_seq_value' ,'NUMBER');

Line 569: fa_rx_util_pkg.assign_column('250',null ,'DEBIT_BALANCING_DESC' ,'arrx_adj.var.debit_balancing_desc' ,'VARCHAR2',240);

565:
566:
567: fa_rx_util_pkg.assign_column('230',null ,'DEBIT_ACCOUNT_DESC' ,'arrx_adj.var.debit_account_desc' ,'VARCHAR2',240);
568: fa_rx_util_pkg.assign_column('240',null ,'DEBIT_BALANCING' ,'arrx_adj.var.debit_balancing' ,'VARCHAR2',240);
569: fa_rx_util_pkg.assign_column('250',null ,'DEBIT_BALANCING_DESC' ,'arrx_adj.var.debit_balancing_desc' ,'VARCHAR2',240);
570: fa_rx_util_pkg.assign_column('260',null ,'DEBIT_NATACCT' ,'arrx_adj.var.debit_natacct' ,'VARCHAR2',240);
571: fa_rx_util_pkg.assign_column('270',null ,'DEBIT_NATACCT_DESC' ,'arrx_adj.var.debit_natacct_desc' ,'VARCHAR2',240);
572: fa_rx_util_pkg.assign_column('280','nvl(adj.doc_sequence_value,'''')' ,'DOC_SEQUENCE_VALUE' ,'arrx_adj.var.doc_seq_value' ,'NUMBER');
573: fa_rx_util_pkg.assign_column('290',null ,'DOC_SEQUENCE_NAME' ,'arrx_adj.var.doc_seq_name' ,'VARCHAR2',30);

Line 570: fa_rx_util_pkg.assign_column('260',null ,'DEBIT_NATACCT' ,'arrx_adj.var.debit_natacct' ,'VARCHAR2',240);

566:
567: fa_rx_util_pkg.assign_column('230',null ,'DEBIT_ACCOUNT_DESC' ,'arrx_adj.var.debit_account_desc' ,'VARCHAR2',240);
568: fa_rx_util_pkg.assign_column('240',null ,'DEBIT_BALANCING' ,'arrx_adj.var.debit_balancing' ,'VARCHAR2',240);
569: fa_rx_util_pkg.assign_column('250',null ,'DEBIT_BALANCING_DESC' ,'arrx_adj.var.debit_balancing_desc' ,'VARCHAR2',240);
570: fa_rx_util_pkg.assign_column('260',null ,'DEBIT_NATACCT' ,'arrx_adj.var.debit_natacct' ,'VARCHAR2',240);
571: fa_rx_util_pkg.assign_column('270',null ,'DEBIT_NATACCT_DESC' ,'arrx_adj.var.debit_natacct_desc' ,'VARCHAR2',240);
572: fa_rx_util_pkg.assign_column('280','nvl(adj.doc_sequence_value,'''')' ,'DOC_SEQUENCE_VALUE' ,'arrx_adj.var.doc_seq_value' ,'NUMBER');
573: fa_rx_util_pkg.assign_column('290',null ,'DOC_SEQUENCE_NAME' ,'arrx_adj.var.doc_seq_name' ,'VARCHAR2',30);
574:

Line 571: fa_rx_util_pkg.assign_column('270',null ,'DEBIT_NATACCT_DESC' ,'arrx_adj.var.debit_natacct_desc' ,'VARCHAR2',240);

567: fa_rx_util_pkg.assign_column('230',null ,'DEBIT_ACCOUNT_DESC' ,'arrx_adj.var.debit_account_desc' ,'VARCHAR2',240);
568: fa_rx_util_pkg.assign_column('240',null ,'DEBIT_BALANCING' ,'arrx_adj.var.debit_balancing' ,'VARCHAR2',240);
569: fa_rx_util_pkg.assign_column('250',null ,'DEBIT_BALANCING_DESC' ,'arrx_adj.var.debit_balancing_desc' ,'VARCHAR2',240);
570: fa_rx_util_pkg.assign_column('260',null ,'DEBIT_NATACCT' ,'arrx_adj.var.debit_natacct' ,'VARCHAR2',240);
571: fa_rx_util_pkg.assign_column('270',null ,'DEBIT_NATACCT_DESC' ,'arrx_adj.var.debit_natacct_desc' ,'VARCHAR2',240);
572: fa_rx_util_pkg.assign_column('280','nvl(adj.doc_sequence_value,'''')' ,'DOC_SEQUENCE_VALUE' ,'arrx_adj.var.doc_seq_value' ,'NUMBER');
573: fa_rx_util_pkg.assign_column('290',null ,'DOC_SEQUENCE_NAME' ,'arrx_adj.var.doc_seq_name' ,'VARCHAR2',30);
574:
575: --

Line 572: fa_rx_util_pkg.assign_column('280','nvl(adj.doc_sequence_value,'''')' ,'DOC_SEQUENCE_VALUE' ,'arrx_adj.var.doc_seq_value' ,'NUMBER');

568: fa_rx_util_pkg.assign_column('240',null ,'DEBIT_BALANCING' ,'arrx_adj.var.debit_balancing' ,'VARCHAR2',240);
569: fa_rx_util_pkg.assign_column('250',null ,'DEBIT_BALANCING_DESC' ,'arrx_adj.var.debit_balancing_desc' ,'VARCHAR2',240);
570: fa_rx_util_pkg.assign_column('260',null ,'DEBIT_NATACCT' ,'arrx_adj.var.debit_natacct' ,'VARCHAR2',240);
571: fa_rx_util_pkg.assign_column('270',null ,'DEBIT_NATACCT_DESC' ,'arrx_adj.var.debit_natacct_desc' ,'VARCHAR2',240);
572: fa_rx_util_pkg.assign_column('280','nvl(adj.doc_sequence_value,'''')' ,'DOC_SEQUENCE_VALUE' ,'arrx_adj.var.doc_seq_value' ,'NUMBER');
573: fa_rx_util_pkg.assign_column('290',null ,'DOC_SEQUENCE_NAME' ,'arrx_adj.var.doc_seq_name' ,'VARCHAR2',30);
574:
575: --
576: -- Assign FROM clause

Line 573: fa_rx_util_pkg.assign_column('290',null ,'DOC_SEQUENCE_NAME' ,'arrx_adj.var.doc_seq_name' ,'VARCHAR2',30);

569: fa_rx_util_pkg.assign_column('250',null ,'DEBIT_BALANCING_DESC' ,'arrx_adj.var.debit_balancing_desc' ,'VARCHAR2',240);
570: fa_rx_util_pkg.assign_column('260',null ,'DEBIT_NATACCT' ,'arrx_adj.var.debit_natacct' ,'VARCHAR2',240);
571: fa_rx_util_pkg.assign_column('270',null ,'DEBIT_NATACCT_DESC' ,'arrx_adj.var.debit_natacct_desc' ,'VARCHAR2',240);
572: fa_rx_util_pkg.assign_column('280','nvl(adj.doc_sequence_value,'''')' ,'DOC_SEQUENCE_VALUE' ,'arrx_adj.var.doc_seq_value' ,'NUMBER');
573: fa_rx_util_pkg.assign_column('290',null ,'DOC_SEQUENCE_NAME' ,'arrx_adj.var.doc_seq_name' ,'VARCHAR2',30);
574:
575: --
576: -- Assign FROM clause
577: --

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

575: --
576: -- Assign FROM clause
577: --
578:
579: fa_rx_util_pkg.debug('Assign FROM Clause using ALL tables');
580: -- Bug 1719611 Tim Dexter - added ar_distributions
581: fa_rx_util_pkg.from_clause := 'hz_cust_accounts_all cust,
582: hz_parties party,
583: ar_lookups ladjtype,

Line 581: fa_rx_util_pkg.from_clause := 'hz_cust_accounts_all cust,

577: --
578:
579: fa_rx_util_pkg.debug('Assign FROM Clause using ALL tables');
580: -- Bug 1719611 Tim Dexter - added ar_distributions
581: fa_rx_util_pkg.from_clause := 'hz_cust_accounts_all cust,
582: hz_parties party,
583: ar_lookups ladjtype,
584: ar_payment_schedules_all pay,
585: ra_customer_trx_all trx,

Line 594: fa_rx_util_pkg.from_clause := fa_rx_util_pkg.from_clause ||

590: || SHOW_BILL_FROM;
591:
592: /*
593: if accounting_method <> 'ACCRUAL' then
594: fa_rx_util_pkg.from_clause := fa_rx_util_pkg.from_clause ||
595: ',gl_code_combinations glc ';
596: end if;
597: */
598: /* Start FP Bug 5724794 - Bug 4619624 introduce join with GL_code_combination for segment based search */

Line 600: fa_rx_util_pkg.from_clause := fa_rx_util_pkg.from_clause ||

596: end if;
597: */
598: /* Start FP Bug 5724794 - Bug 4619624 introduce join with GL_code_combination for segment based search */
599: if accounting_method = 'CASH' THEN
600: fa_rx_util_pkg.from_clause := fa_rx_util_pkg.from_clause ||
601: ',gl_code_combinations glc ';
602: elsif accounting_method = 'ACCRUAL' AND CO_SEG_WHERE IS NOT NULL THEN
603: fa_rx_util_pkg.from_clause := fa_rx_util_pkg.from_clause ||
604: ',gl_code_combinations glc , ar_distributions dist_all';

Line 603: fa_rx_util_pkg.from_clause := fa_rx_util_pkg.from_clause ||

599: if accounting_method = 'CASH' THEN
600: fa_rx_util_pkg.from_clause := fa_rx_util_pkg.from_clause ||
601: ',gl_code_combinations glc ';
602: elsif accounting_method = 'ACCRUAL' AND CO_SEG_WHERE IS NOT NULL THEN
603: fa_rx_util_pkg.from_clause := fa_rx_util_pkg.from_clause ||
604: ',gl_code_combinations glc , ar_distributions dist_all';
605:
606: end if;
607: /* End FP Bug 5724794 SPDIXIT */

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

610: -- Assign WHERE clause
611: --
612: -- Bug 1385105 added 'and adj.receivables_trx_id <> -15' to exclude these adjustments
613:
614: fa_rx_util_pkg.debug('AR_ASSIGN_WHERE_CLAUSE');
615: fa_rx_util_pkg.where_clause := 'trx.complete_flag = ''Y''
616: and cust.cust_account_id = trx.bill_to_customer_id
617: and cust.party_id = party.party_id
618: and trx.set_of_books_id = :set_of_books_id

Line 615: fa_rx_util_pkg.where_clause := 'trx.complete_flag = ''Y''

611: --
612: -- Bug 1385105 added 'and adj.receivables_trx_id <> -15' to exclude these adjustments
613:
614: fa_rx_util_pkg.debug('AR_ASSIGN_WHERE_CLAUSE');
615: fa_rx_util_pkg.where_clause := 'trx.complete_flag = ''Y''
616: and cust.cust_account_id = trx.bill_to_customer_id
617: and cust.party_id = party.party_id
618: and trx.set_of_books_id = :set_of_books_id
619: and trx.customer_trx_id = pay.customer_trx_id

Line 668: fa_rx_util_pkg.where_clause := fa_rx_util_pkg.where_clause ||

664: L_TRX_ORG_WHERE;
665:
666: /* Start FP Bug 5724794 - Changed for bug 4619624 for joining with gl_code_combinations */
667: if accounting_method = 'CASH' THEN
668: fa_rx_util_pkg.where_clause := fa_rx_util_pkg.where_clause ||
669: ' and adj.code_combination_id = glc.code_combination_id
670: and glc.chart_of_accounts_id = :p_coa_id ' ||
671: CO_SEG_WHERE ;
672: elsif accounting_method = 'ACCRUAL' AND CO_SEG_WHERE IS NOT NULL THEN

Line 673: fa_rx_util_pkg.where_clause := fa_rx_util_pkg.where_clause ||

669: ' and adj.code_combination_id = glc.code_combination_id
670: and glc.chart_of_accounts_id = :p_coa_id ' ||
671: CO_SEG_WHERE ;
672: elsif accounting_method = 'ACCRUAL' AND CO_SEG_WHERE IS NOT NULL THEN
673: fa_rx_util_pkg.where_clause := fa_rx_util_pkg.where_clause ||
674: 'and glc.code_combination_id = dist_all.code_combination_id
675: and glc.chart_of_accounts_id = :p_coa_id
676: and dist_all.source_id = adj.adjustment_id
677: and dist_all.source_table = ''ADJ''

Line 685: fa_rx_util_pkg.where_clause := fa_rx_util_pkg.where_clause ||

681: end if;
682:
683: /*
684: if accounting_method <> 'ACCRUAL' then
685: fa_rx_util_pkg.where_clause := fa_rx_util_pkg.where_clause ||
686: ' and adj.code_combination_id = glc.code_combination_id
687: and glc.chart_of_accounts_id = :p_coa_id ' ||
688: CO_SEG_WHERE ;
689: end if;

Line 695: fa_rx_util_pkg.debug('AR_ASSIGN_ORDER_BY_CLAUSE');

691:
692: -- Assign ORDER BY clause
693: --
694:
695: fa_rx_util_pkg.debug('AR_ASSIGN_ORDER_BY_CLAUSE');
696:
697: fa_rx_util_pkg.order_by_clause := ' arpt_sql_func_util.get_trx_type_details(trx.cust_trx_type_id,''POST'',trx.org_id) ,
698: arpt_sql_func_util.get_trx_type_details(trx.cust_trx_type_id,''NAME'',trx.org_id),
699: trx.trx_number,

Line 697: fa_rx_util_pkg.order_by_clause := ' arpt_sql_func_util.get_trx_type_details(trx.cust_trx_type_id,''POST'',trx.org_id) ,

693: --
694:
695: fa_rx_util_pkg.debug('AR_ASSIGN_ORDER_BY_CLAUSE');
696:
697: fa_rx_util_pkg.order_by_clause := ' arpt_sql_func_util.get_trx_type_details(trx.cust_trx_type_id,''POST'',trx.org_id) ,
698: arpt_sql_func_util.get_trx_type_details(trx.cust_trx_type_id,''NAME'',trx.org_id),
699: trx.trx_number,
700: pay.due_date,
701: adj.adjustment_number';

Line 706: fa_rx_util_pkg.log('from clause ' || fa_rx_util_pkg.from_clause );

702: --Bug 1371540 jskhan changing adjustment_id for adjustment_number
703: -- adj.adjustment_id';
704:
705:
706: fa_rx_util_pkg.log('from clause ' || fa_rx_util_pkg.from_clause );
707: fa_rx_util_pkg.log('Where clause ' || fa_rx_util_pkg.where_clause );
708:
709: fa_rx_util_pkg.debug('arrx_adj.adj_before_report()-');
710:

Line 707: fa_rx_util_pkg.log('Where clause ' || fa_rx_util_pkg.where_clause );

703: -- adj.adjustment_id';
704:
705:
706: fa_rx_util_pkg.log('from clause ' || fa_rx_util_pkg.from_clause );
707: fa_rx_util_pkg.log('Where clause ' || fa_rx_util_pkg.where_clause );
708:
709: fa_rx_util_pkg.debug('arrx_adj.adj_before_report()-');
710:
711: end aradj_before_report;

Line 709: fa_rx_util_pkg.debug('arrx_adj.adj_before_report()-');

705:
706: fa_rx_util_pkg.log('from clause ' || fa_rx_util_pkg.from_clause );
707: fa_rx_util_pkg.log('Where clause ' || fa_rx_util_pkg.where_clause );
708:
709: fa_rx_util_pkg.debug('arrx_adj.adj_before_report()-');
710:
711: end aradj_before_report;
712:
713:

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

722: l_Yes VARCHAR2(80);
723: l_No VARCHAR2(80);
724:
725: begin
726: fa_rx_util_pkg.debug('AR_GET_BIND');
727: --
728: -- Binding vars that appear in SELECT statement depending on input params
729: --
730:

Line 833: fa_rx_util_pkg.debug('var.account_code_combination_id = ' || var.account_code_combination_id);

829: var.organization_name := var.org_name;
830: */
831:
832:
833: fa_rx_util_pkg.debug('var.account_code_combination_id = ' || var.account_code_combination_id);
834: fa_rx_util_pkg.debug('var.adj_number = ' || var.adj_number);
835: --
836: -- Assign acount data
837: --

Line 834: fa_rx_util_pkg.debug('var.adj_number = ' || var.adj_number);

830: */
831:
832:
833: fa_rx_util_pkg.debug('var.account_code_combination_id = ' || var.account_code_combination_id);
834: fa_rx_util_pkg.debug('var.adj_number = ' || var.adj_number);
835: --
836: -- Assign acount data
837: --
838: