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 157: fa_rx_util_pkg.enable_debug;

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

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

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

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

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

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

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

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

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

Line 206: fa_rx_util_pkg.log(sqlcode);

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

Line 207: fa_rx_util_pkg.log(sqlerrm);

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

Line 208: fa_rx_util_pkg.debug(sqlcode);

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

Line 209: fa_rx_util_pkg.debug(sqlerrm);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

311: --Bug fix 5595083 ends
312: --
313: -- Figure out NOCOPY the where clause for the parameters
314: --
315: fa_rx_util_pkg.debug('AR_GET_PARAMETERS');
316:
317: --
318: --CURRENCY_CODE where clause
319: --

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

486: --
487: -- Assign SELECT list
488: --
489:
490: fa_rx_util_pkg.debug('ARTX_ASSIGN_SELECT_LIST');
491:
492: -->>SELECT_START<<--
493:
494: fa_rx_util_pkg.assign_column('10',NULL ,'ORGANIZATION_NAME' ,'arrx_adj.var.organization_name' ,'VARCHAR2',50);

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

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

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

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

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

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

493:
494: fa_rx_util_pkg.assign_column('10',NULL ,'ORGANIZATION_NAME' ,'arrx_adj.var.organization_name' ,'VARCHAR2',50);
495: fa_rx_util_pkg.assign_column('20',NULL ,'FUNCTIONAL_CURRENCY_CODE' ,'arrx_adj.var.functional_currency_code' ,'VARCHAR2',15);
496: fa_rx_util_pkg.assign_column('30',POSTABLE_DECODE ,'POSTABLE' ,'arrx_adj.var.postable' ,'VARCHAR2',15);
497: fa_rx_util_pkg.assign_column('40','trx.invoice_currency_code' ,'ADJ_CURRENCY_CODE' ,'arrx_adj.var.adj_currency_code' ,'VARCHAR2',15);
498: fa_rx_util_pkg.assign_column('50','1' ,'CONS' ,'arrx_adj.var.cons' ,'VARCHAR2',15);
499: /*fa_rx_util_pkg.assign_column('60',SORTBY_DECODE ,'SORTBY' ,'arrx_adj.var.sortby' ,'VARCHAR2',30);*/
500: 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);
501: fa_rx_util_pkg.assign_column('70',D_OR_I_DECODE ,'D_OR_I' ,'arrx_adj.var.d_or_i' ,'VARCHAR2',6);

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

494: fa_rx_util_pkg.assign_column('10',NULL ,'ORGANIZATION_NAME' ,'arrx_adj.var.organization_name' ,'VARCHAR2',50);
495: fa_rx_util_pkg.assign_column('20',NULL ,'FUNCTIONAL_CURRENCY_CODE' ,'arrx_adj.var.functional_currency_code' ,'VARCHAR2',15);
496: fa_rx_util_pkg.assign_column('30',POSTABLE_DECODE ,'POSTABLE' ,'arrx_adj.var.postable' ,'VARCHAR2',15);
497: fa_rx_util_pkg.assign_column('40','trx.invoice_currency_code' ,'ADJ_CURRENCY_CODE' ,'arrx_adj.var.adj_currency_code' ,'VARCHAR2',15);
498: fa_rx_util_pkg.assign_column('50','1' ,'CONS' ,'arrx_adj.var.cons' ,'VARCHAR2',15);
499: /*fa_rx_util_pkg.assign_column('60',SORTBY_DECODE ,'SORTBY' ,'arrx_adj.var.sortby' ,'VARCHAR2',30);*/
500: 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);
501: fa_rx_util_pkg.assign_column('70',D_OR_I_DECODE ,'D_OR_I' ,'arrx_adj.var.d_or_i' ,'VARCHAR2',6);
502: IF (BILL_FLAG = 'Y') THEN

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

495: fa_rx_util_pkg.assign_column('20',NULL ,'FUNCTIONAL_CURRENCY_CODE' ,'arrx_adj.var.functional_currency_code' ,'VARCHAR2',15);
496: fa_rx_util_pkg.assign_column('30',POSTABLE_DECODE ,'POSTABLE' ,'arrx_adj.var.postable' ,'VARCHAR2',15);
497: fa_rx_util_pkg.assign_column('40','trx.invoice_currency_code' ,'ADJ_CURRENCY_CODE' ,'arrx_adj.var.adj_currency_code' ,'VARCHAR2',15);
498: fa_rx_util_pkg.assign_column('50','1' ,'CONS' ,'arrx_adj.var.cons' ,'VARCHAR2',15);
499: /*fa_rx_util_pkg.assign_column('60',SORTBY_DECODE ,'SORTBY' ,'arrx_adj.var.sortby' ,'VARCHAR2',30);*/
500: 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);
501: fa_rx_util_pkg.assign_column('70',D_OR_I_DECODE ,'D_OR_I' ,'arrx_adj.var.d_or_i' ,'VARCHAR2',6);
502: IF (BILL_FLAG = 'Y') THEN
503: 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 500: 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);

496: fa_rx_util_pkg.assign_column('30',POSTABLE_DECODE ,'POSTABLE' ,'arrx_adj.var.postable' ,'VARCHAR2',15);
497: fa_rx_util_pkg.assign_column('40','trx.invoice_currency_code' ,'ADJ_CURRENCY_CODE' ,'arrx_adj.var.adj_currency_code' ,'VARCHAR2',15);
498: fa_rx_util_pkg.assign_column('50','1' ,'CONS' ,'arrx_adj.var.cons' ,'VARCHAR2',15);
499: /*fa_rx_util_pkg.assign_column('60',SORTBY_DECODE ,'SORTBY' ,'arrx_adj.var.sortby' ,'VARCHAR2',30);*/
500: 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);
501: fa_rx_util_pkg.assign_column('70',D_OR_I_DECODE ,'D_OR_I' ,'arrx_adj.var.d_or_i' ,'VARCHAR2',6);
502: IF (BILL_FLAG = 'Y') THEN
503: 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
504: ELSE

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

497: fa_rx_util_pkg.assign_column('40','trx.invoice_currency_code' ,'ADJ_CURRENCY_CODE' ,'arrx_adj.var.adj_currency_code' ,'VARCHAR2',15);
498: fa_rx_util_pkg.assign_column('50','1' ,'CONS' ,'arrx_adj.var.cons' ,'VARCHAR2',15);
499: /*fa_rx_util_pkg.assign_column('60',SORTBY_DECODE ,'SORTBY' ,'arrx_adj.var.sortby' ,'VARCHAR2',30);*/
500: 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);
501: fa_rx_util_pkg.assign_column('70',D_OR_I_DECODE ,'D_OR_I' ,'arrx_adj.var.d_or_i' ,'VARCHAR2',6);
502: IF (BILL_FLAG = 'Y') THEN
503: 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
504: ELSE
505: fa_rx_util_pkg.assign_column('80','trx.trx_number' ,'TRX_NUMBER' ,'arrx_adj.var.trx_number' ,'VARCHAR2',36);--bug4612433

Line 503: 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

499: /*fa_rx_util_pkg.assign_column('60',SORTBY_DECODE ,'SORTBY' ,'arrx_adj.var.sortby' ,'VARCHAR2',30);*/
500: 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);
501: fa_rx_util_pkg.assign_column('70',D_OR_I_DECODE ,'D_OR_I' ,'arrx_adj.var.d_or_i' ,'VARCHAR2',6);
502: IF (BILL_FLAG = 'Y') THEN
503: 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
504: ELSE
505: fa_rx_util_pkg.assign_column('80','trx.trx_number' ,'TRX_NUMBER' ,'arrx_adj.var.trx_number' ,'VARCHAR2',36);--bug4612433
506: END IF;
507: fa_rx_util_pkg.assign_column('90','pay.due_date' ,'DUE_DATE' ,'arrx_adj.var.due_date' ,'DATE');

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

501: fa_rx_util_pkg.assign_column('70',D_OR_I_DECODE ,'D_OR_I' ,'arrx_adj.var.d_or_i' ,'VARCHAR2',6);
502: IF (BILL_FLAG = 'Y') THEN
503: 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
504: ELSE
505: fa_rx_util_pkg.assign_column('80','trx.trx_number' ,'TRX_NUMBER' ,'arrx_adj.var.trx_number' ,'VARCHAR2',36);--bug4612433
506: END IF;
507: fa_rx_util_pkg.assign_column('90','pay.due_date' ,'DUE_DATE' ,'arrx_adj.var.due_date' ,'DATE');
508: fa_rx_util_pkg.assign_column('100','adj.gl_date' ,'GL_DATE' ,'arrx_adj.var.gl_date' ,'DATE');
509: -- Bug 1371540 Aug 2000: changed reference from Adjustment_id to Adjustment_number: jskhan

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

503: 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
504: ELSE
505: fa_rx_util_pkg.assign_column('80','trx.trx_number' ,'TRX_NUMBER' ,'arrx_adj.var.trx_number' ,'VARCHAR2',36);--bug4612433
506: END IF;
507: fa_rx_util_pkg.assign_column('90','pay.due_date' ,'DUE_DATE' ,'arrx_adj.var.due_date' ,'DATE');
508: fa_rx_util_pkg.assign_column('100','adj.gl_date' ,'GL_DATE' ,'arrx_adj.var.gl_date' ,'DATE');
509: -- Bug 1371540 Aug 2000: changed reference from Adjustment_id to Adjustment_number: jskhan
510: fa_rx_util_pkg.assign_column('110','adj.adjustment_number' ,'ADJ_NUMBER' ,'arrx_adj.var.adj_number' ,'VARCHAR2',20);
511: fa_rx_util_pkg.assign_column('120',ADJ_CLASS_DECODE ,'ADJ_CLASS' ,'arrx_adj.var.adj_class' ,'VARCHAR2',30);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 529: fa_rx_util_pkg.assign_column('190',

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

Line 534: fa_rx_util_pkg.assign_column('200',

530: DIST_ENTERED,
531: 'ADJ_AMOUNT',
532: 'arrx_adj.var.adj_amount',
533: 'NUMBER');
534: fa_rx_util_pkg.assign_column('200',
535: DIST_ACCTD,
536: 'ACCTD_ADJ_AMOUNT',
537: 'arrx_adj.var.acctd_adj_amount',
538: 'NUMBER');

Line 539: fa_rx_util_pkg.assign_column('210',

535: DIST_ACCTD,
536: 'ACCTD_ADJ_AMOUNT',
537: 'arrx_adj.var.acctd_adj_amount',
538: 'NUMBER');
539: fa_rx_util_pkg.assign_column('210',
540: DIST_CCID_STR,
541: 'ACCOUNT_CODE_COMBINATION_ID',
542: 'arrx_adj.var.account_code_combination_id',
543: 'VARCHAR2',240);

Line 545: fa_rx_util_pkg.assign_column('190',

541: 'ACCOUNT_CODE_COMBINATION_ID',
542: 'arrx_adj.var.account_code_combination_id',
543: 'VARCHAR2',240);
544: else
545: fa_rx_util_pkg.assign_column('190',
546: 'round(adj.amount,2)',
547: 'ADJ_AMOUNT',
548: 'arrx_adj.var.adj_amount',
549: 'NUMBER');

Line 550: fa_rx_util_pkg.assign_column('200',

546: 'round(adj.amount,2)',
547: 'ADJ_AMOUNT',
548: 'arrx_adj.var.adj_amount',
549: 'NUMBER');
550: fa_rx_util_pkg.assign_column('200',
551: 'adj.acctd_amount',
552: 'ACCTD_ADJ_AMOUNT',
553: 'arrx_adj.var.acctd_adj_amount',
554: 'NUMBER');

Line 555: fa_rx_util_pkg.assign_column('210',

551: 'adj.acctd_amount',
552: 'ACCTD_ADJ_AMOUNT',
553: 'arrx_adj.var.acctd_adj_amount',
554: 'NUMBER');
555: fa_rx_util_pkg.assign_column('210',
556: 'glc.code_combination_id',
557: 'ACCOUNT_CODE_COMBINATION_ID',
558: 'arrx_adj.var.account_code_combination_id',
559: 'VARCHAR2',240);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 590: fa_rx_util_pkg.from_clause := fa_rx_util_pkg.from_clause ||

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

Line 596: fa_rx_util_pkg.from_clause := fa_rx_util_pkg.from_clause ||

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

Line 599: fa_rx_util_pkg.from_clause := fa_rx_util_pkg.from_clause ||

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

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

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

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

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

Line 664: fa_rx_util_pkg.where_clause := fa_rx_util_pkg.where_clause ||

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

Line 669: fa_rx_util_pkg.where_clause := fa_rx_util_pkg.where_clause ||

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

Line 681: fa_rx_util_pkg.where_clause := fa_rx_util_pkg.where_clause ||

677: end if;
678:
679: /*
680: if accounting_method <> 'ACCRUAL' then
681: fa_rx_util_pkg.where_clause := fa_rx_util_pkg.where_clause ||
682: ' and adj.code_combination_id = glc.code_combination_id
683: and glc.chart_of_accounts_id = :p_coa_id ' ||
684: CO_SEG_WHERE ;
685: end if;

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

687:
688: -- Assign ORDER BY clause
689: --
690:
691: fa_rx_util_pkg.debug('AR_ASSIGN_ORDER_BY_CLAUSE');
692:
693: fa_rx_util_pkg.order_by_clause := ' arpt_sql_func_util.get_trx_type_details(trx.cust_trx_type_id,''POST'',trx.org_id) ,
694: arpt_sql_func_util.get_trx_type_details(trx.cust_trx_type_id,''NAME'',trx.org_id),
695: trx.trx_number,

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

689: --
690:
691: fa_rx_util_pkg.debug('AR_ASSIGN_ORDER_BY_CLAUSE');
692:
693: fa_rx_util_pkg.order_by_clause := ' arpt_sql_func_util.get_trx_type_details(trx.cust_trx_type_id,''POST'',trx.org_id) ,
694: arpt_sql_func_util.get_trx_type_details(trx.cust_trx_type_id,''NAME'',trx.org_id),
695: trx.trx_number,
696: pay.due_date,
697: adj.adjustment_number';

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

698: --Bug 1371540 jskhan changing adjustment_id for adjustment_number
699: -- adj.adjustment_id';
700:
701:
702: fa_rx_util_pkg.log('from clause ' || fa_rx_util_pkg.from_clause );
703: fa_rx_util_pkg.log('Where clause ' || fa_rx_util_pkg.where_clause );
704:
705: fa_rx_util_pkg.debug('arrx_adj.adj_before_report()-');
706:

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

699: -- adj.adjustment_id';
700:
701:
702: fa_rx_util_pkg.log('from clause ' || fa_rx_util_pkg.from_clause );
703: fa_rx_util_pkg.log('Where clause ' || fa_rx_util_pkg.where_clause );
704:
705: fa_rx_util_pkg.debug('arrx_adj.adj_before_report()-');
706:
707: end aradj_before_report;

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

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

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

718: l_Yes VARCHAR2(80);
719: l_No VARCHAR2(80);
720:
721: begin
722: fa_rx_util_pkg.debug('AR_GET_BIND');
723: --
724: -- Binding vars that appear in SELECT statement depending on input params
725: --
726:

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

825: var.organization_name := var.org_name;
826: */
827:
828:
829: fa_rx_util_pkg.debug('var.account_code_combination_id = ' || var.account_code_combination_id);
830: fa_rx_util_pkg.debug('var.adj_number = ' || var.adj_number);
831: --
832: -- Assign acount data
833: --

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

826: */
827:
828:
829: fa_rx_util_pkg.debug('var.account_code_combination_id = ' || var.account_code_combination_id);
830: fa_rx_util_pkg.debug('var.adj_number = ' || var.adj_number);
831: --
832: -- Assign acount data
833: --
834: