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 ARRX_ADJ

Line 1: PACKAGE BODY ARRX_ADJ as

1: PACKAGE BODY ARRX_ADJ as
2: /* $Header: ARRXADJB.pls 120.24.12010000.2 2008/08/20 11:25:03 dgaurab ship $ */
3:
4: -- make following vars global :
5: CO_SEG_WHERE varchar2(500);

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 185: -- before_report is assigned 'arrx_adj.adj_before_report;'

181: --
182: -- Assign report triggers for this report.
183: -- This report has one section called AR RECEIPT
184: -- NOTE:
185: -- before_report is assigned 'arrx_adj.adj_before_report;'
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'.

Line 192: 'arrx_adj.aradj_before_report;',

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;',
195: null);
196:

Line 193: 'arrx_adj.aradj_bind(:CURSOR_SELECT);',

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;',
195: null);
196:
197: --

Line 194: 'arrx_adj.aradj_after_fetch;',

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;',
195: null);
196:
197: --
198: -- Run the report. Make sure to pass as parameter the same

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 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 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 516: per.person_name, party.party_name) ,1,50)' ,'CUSTOMER_NAME' ,'arrx_adj.var.customer_name' ,'VARCHAR2',50);

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

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 523: DIST_ENTERED := 'arrx_adj.dist_details(adj.adjustment_id, ' || var.chart_of_accounts_id ||

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 ||
524: ',' || var.p_reporting_entity_id || ', ''ENTERED'')';
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 ||

Line 525: DIST_ACCTD := 'arrx_adj.dist_details(adj.adjustment_id, ' || var.chart_of_accounts_id ||

521: if accounting_method = 'ACCRUAL' then
522:
523: DIST_ENTERED := 'arrx_adj.dist_details(adj.adjustment_id, ' || var.chart_of_accounts_id ||
524: ',' || var.p_reporting_entity_id || ', ''ENTERED'')';
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',

Line 527: DIST_CCID_STR := 'arrx_adj.dist_ccid(adj.adjustment_id, ' || var.chart_of_accounts_id ||

523: DIST_ENTERED := 'arrx_adj.dist_details(adj.adjustment_id, ' || var.chart_of_accounts_id ||
524: ',' || var.p_reporting_entity_id || ', ''ENTERED'')';
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',

Line 532: 'arrx_adj.var.adj_amount',

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');
534: fa_rx_util_pkg.assign_column('200',
535: DIST_ACCTD,
536: 'ACCTD_ADJ_AMOUNT',

Line 537: 'arrx_adj.var.acctd_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');
539: fa_rx_util_pkg.assign_column('210',
540: DIST_CCID_STR,
541: 'ACCOUNT_CODE_COMBINATION_ID',

Line 542: 'arrx_adj.var.account_code_combination_id',

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);
544: else
545: fa_rx_util_pkg.assign_column('190',
546: 'round(adj.amount,2)',

Line 548: 'arrx_adj.var.adj_amount',

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');
550: fa_rx_util_pkg.assign_column('200',
551: 'adj.acctd_amount',
552: 'ACCTD_ADJ_AMOUNT',

Line 553: 'arrx_adj.var.acctd_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');
555: fa_rx_util_pkg.assign_column('210',
556: 'glc.code_combination_id',
557: 'ACCOUNT_CODE_COMBINATION_ID',

Line 558: 'arrx_adj.var.account_code_combination_id',

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);
560: end if;
561:
562:

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 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 883: end ARRX_ADJ;

879: --
880:
881: end aradj_after_fetch;
882:
883: end ARRX_ADJ;