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.29 2011/06/14 02:25:14 chuansha ship $ */
3:
4: -- make following vars global :
5: CO_SEG_WHERE varchar2(500);

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

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

Line 191: 'arrx_adj.aradj_before_report;',

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

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

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

Line 193: 'arrx_adj.aradj_after_fetch;',

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

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

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

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

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

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

525: if accounting_method = 'ACCRUAL' then
526:
527: DIST_ENTERED := 'arrx_adj.dist_details(adj.adjustment_id, ' || var.chart_of_accounts_id ||
528: ',' || var.p_reporting_entity_id || ', ''ENTERED'')';
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',

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

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

Line 536: 'arrx_adj.var.adj_amount',

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');
538: fa_rx_util_pkg.assign_column('200',
539: DIST_ACCTD,
540: 'ACCTD_ADJ_AMOUNT',

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

Line 546: 'arrx_adj.var.account_code_combination_id',

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);
548: else
549: fa_rx_util_pkg.assign_column('190',
550: 'round(adj.amount,2)',

Line 552: 'arrx_adj.var.adj_amount',

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');
554: fa_rx_util_pkg.assign_column('200',
555: 'adj.acctd_amount',
556: 'ACCTD_ADJ_AMOUNT',

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

Line 562: 'arrx_adj.var.account_code_combination_id',

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);
564: end if;
565:
566:

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

883: --
884:
885: end aradj_after_fetch;
886:
887: end ARRX_ADJ;