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_TX dependencies on ARRX_TX

Line 1: PACKAGE BODY ARRX_TX as

1: PACKAGE BODY ARRX_TX as
2: /* $Header: ARRXTXB.pls 120.15 2007/12/19 05:54:25 bsuri ship $ */
3:
4: --
5: -- Main AR TRANSACTION RX Report function

Line 45: fa_rx_util_pkg.debug('arrx_tx.artx_rep()+');

41: l_profile_rsob_id NUMBER := NULL;
42: l_client_info_rsob_id NUMBER := NULL;
43: l_client_info_org_id NUMBER := NULL;
44: begin
45: fa_rx_util_pkg.debug('arrx_tx.artx_rep()+');
46:
47: --
48: -- Assign parameters to global variable
49: -- These values will be used within the before_report trigger

Line 167: fa_rx_util_pkg.init_request('arrx_tx.artx_rep',request_id,'AR_TRANSACTIONS_REP_ITF');

163: mo_global.set_policy_context('S',var.reporting_entity_id);
164: END IF;
165: --End bug 5571594 SPDIXIT
166: -- Initialize request
167: fa_rx_util_pkg.init_request('arrx_tx.artx_rep',request_id,'AR_TRANSACTIONS_REP_ITF');
168:
169: --
170: -- Assign report triggers for this report.
171: -- This report has one section called AR TRANSACTION

Line 173: -- before_report is assigned 'arrx_tx.before_report;'

169: --
170: -- Assign report triggers for this report.
171: -- This report has one section called AR TRANSACTION
172: -- NOTE:
173: -- before_report is assigned 'arrx_tx.before_report;'
174: -- bind is assigned 'arrx_tx.bind(:CURSOR_SELECT);'
175: -- Each trigger event is assigned with the full procedure name (including package name).
176: -- They end with a ';'.
177: -- The bind trigger requires one host variable ':CURSOR_SELECT'.

Line 174: -- bind is assigned 'arrx_tx.bind(:CURSOR_SELECT);'

170: -- Assign report triggers for this report.
171: -- This report has one section called AR TRANSACTION
172: -- NOTE:
173: -- before_report is assigned 'arrx_tx.before_report;'
174: -- bind is assigned 'arrx_tx.bind(:CURSOR_SELECT);'
175: -- Each trigger event is assigned with the full procedure name (including package name).
176: -- They end with a ';'.
177: -- The bind trigger requires one host variable ':CURSOR_SELECT'.
178: fa_rx_util_pkg.assign_report('AR TRANSACTIONS',

Line 180: 'arrx_tx.before_report;',

176: -- They end with a ';'.
177: -- The bind trigger requires one host variable ':CURSOR_SELECT'.
178: fa_rx_util_pkg.assign_report('AR TRANSACTIONS',
179: true,
180: 'arrx_tx.before_report;',
181: 'arrx_tx.bind(:CURSOR_SELECT);',
182: 'arrx_tx.after_fetch;',
183: null);
184:

Line 181: 'arrx_tx.bind(:CURSOR_SELECT);',

177: -- The bind trigger requires one host variable ':CURSOR_SELECT'.
178: fa_rx_util_pkg.assign_report('AR TRANSACTIONS',
179: true,
180: 'arrx_tx.before_report;',
181: 'arrx_tx.bind(:CURSOR_SELECT);',
182: 'arrx_tx.after_fetch;',
183: null);
184:
185: --

Line 182: 'arrx_tx.after_fetch;',

178: fa_rx_util_pkg.assign_report('AR TRANSACTIONS',
179: true,
180: 'arrx_tx.before_report;',
181: 'arrx_tx.bind(:CURSOR_SELECT);',
182: 'arrx_tx.after_fetch;',
183: null);
184:
185: --
186: -- Run the report. Make sure to pass as parameter the same

Line 188: fa_rx_util_pkg.run_report('arrx_tx.artx_rep', retcode, errbuf);

184:
185: --
186: -- Run the report. Make sure to pass as parameter the same
187: -- value passed to p_calling_proc in init_request().
188: fa_rx_util_pkg.run_report('arrx_tx.artx_rep', retcode, errbuf);
189:
190: fa_rx_util_pkg.debug('arrx_tx.artx_rep()-');
191:
192: exception

Line 190: fa_rx_util_pkg.debug('arrx_tx.artx_rep()-');

186: -- Run the report. Make sure to pass as parameter the same
187: -- value passed to p_calling_proc in init_request().
188: fa_rx_util_pkg.run_report('arrx_tx.artx_rep', retcode, errbuf);
189:
190: fa_rx_util_pkg.debug('arrx_tx.artx_rep()-');
191:
192: exception
193: when others then
194: fa_rx_util_pkg.log(sqlcode);

Line 198: fa_rx_util_pkg.debug('arrx_tx.artx_rep(EXCEPTION)-');

194: fa_rx_util_pkg.log(sqlcode);
195: fa_rx_util_pkg.log(sqlerrm);
196: fa_rx_util_pkg.debug(sqlcode);
197: fa_rx_util_pkg.debug(sqlerrm);
198: fa_rx_util_pkg.debug('arrx_tx.artx_rep(EXCEPTION)-');
199: end artx_rep;
200:
201:
202: --

Line 203: -- This is the before report trigger for the main arrx_tx report.

199: end artx_rep;
200:
201:
202: --
203: -- This is the before report trigger for the main arrx_tx report.
204: procedure before_report
205: is
206: REC_ACCOUNT_SEL varchar2(2000); /*4653230*/
207: REC_BALANCE_SEL varchar2(2000); /*4653230*/

Line 236: fa_rx_util_pkg.debug('arrx_tx.before_report()+');

232: L_BS_ORG_WHERE varchar2(500);
233: BATCH_SOURCE_WHERE varchar2(500);
234: REC_ACCOUNT_WHERE varchar2(4500); /*4653230*/
235: begin
236: fa_rx_util_pkg.debug('arrx_tx.before_report()+');
237:
238: --
239: -- Get Profile GL_SET_OF_BKS_ID
240: --

Line 541: SELECT_BILL_NUMBER := 'DECODE(SYSPARAM.SHOW_BILLING_NUMBER_FLAG,''Y'',ARRX_TX.GET_CONS_BILL_NUMBER(CT.CUSTOMER_TRX_ID),NULL) ';

537: IF var.bill_flag = 'N' THEN
538: SELECT_BILL_NUMBER := null;
539: ELSE
540: */
541: SELECT_BILL_NUMBER := 'DECODE(SYSPARAM.SHOW_BILLING_NUMBER_FLAG,''Y'',ARRX_TX.GET_CONS_BILL_NUMBER(CT.CUSTOMER_TRX_ID),NULL) ';
542:
543: -- END IF;
544:
545:

Line 584: fa_rx_util_pkg.assign_column('10 ','CCRECDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid', 'NUMBER');

580: fa_rx_util_pkg.debug('ARTX_ASSIGN_SELECT_LIST');
581:
582: -- fa_rx_util_pkg.assign_column(#, select, insert, place, type, len);
583: -->>SELECT_START<<--
584: fa_rx_util_pkg.assign_column('10 ','CCRECDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid', 'NUMBER');
585: fa_rx_util_pkg.assign_column('20 ',null, 'ORGANIZATION_NAME', 'arrx_tx.var.organization_name', 'VARCHAR2', 30);
586: fa_rx_util_pkg.assign_column('30 ',null, 'FUNCTIONAL_CURRENCY_CODE', 'arrx_tx.var.functional_currency_code', 'VARCHAR2', 15);
587: fa_rx_util_pkg.assign_column('40 ','CT.CUSTOMER_TRX_ID', 'CUSTOMER_TRX_ID', 'arrx_tx.var.customer_trx_id', 'NUMBER');
588: fa_rx_util_pkg.assign_column('50 ','CT.TRX_NUMBER', 'TRX_NUMBER', 'arrx_tx.var.trx_number', 'VARCHAR2', 20);

Line 585: fa_rx_util_pkg.assign_column('20 ',null, 'ORGANIZATION_NAME', 'arrx_tx.var.organization_name', 'VARCHAR2', 30);

581:
582: -- fa_rx_util_pkg.assign_column(#, select, insert, place, type, len);
583: -->>SELECT_START<<--
584: fa_rx_util_pkg.assign_column('10 ','CCRECDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid', 'NUMBER');
585: fa_rx_util_pkg.assign_column('20 ',null, 'ORGANIZATION_NAME', 'arrx_tx.var.organization_name', 'VARCHAR2', 30);
586: fa_rx_util_pkg.assign_column('30 ',null, 'FUNCTIONAL_CURRENCY_CODE', 'arrx_tx.var.functional_currency_code', 'VARCHAR2', 15);
587: fa_rx_util_pkg.assign_column('40 ','CT.CUSTOMER_TRX_ID', 'CUSTOMER_TRX_ID', 'arrx_tx.var.customer_trx_id', 'NUMBER');
588: fa_rx_util_pkg.assign_column('50 ','CT.TRX_NUMBER', 'TRX_NUMBER', 'arrx_tx.var.trx_number', 'VARCHAR2', 20);
589: fa_rx_util_pkg.assign_column('60 ',SELECT_BILL_NUMBER, 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);

Line 586: fa_rx_util_pkg.assign_column('30 ',null, 'FUNCTIONAL_CURRENCY_CODE', 'arrx_tx.var.functional_currency_code', 'VARCHAR2', 15);

582: -- fa_rx_util_pkg.assign_column(#, select, insert, place, type, len);
583: -->>SELECT_START<<--
584: fa_rx_util_pkg.assign_column('10 ','CCRECDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid', 'NUMBER');
585: fa_rx_util_pkg.assign_column('20 ',null, 'ORGANIZATION_NAME', 'arrx_tx.var.organization_name', 'VARCHAR2', 30);
586: fa_rx_util_pkg.assign_column('30 ',null, 'FUNCTIONAL_CURRENCY_CODE', 'arrx_tx.var.functional_currency_code', 'VARCHAR2', 15);
587: fa_rx_util_pkg.assign_column('40 ','CT.CUSTOMER_TRX_ID', 'CUSTOMER_TRX_ID', 'arrx_tx.var.customer_trx_id', 'NUMBER');
588: fa_rx_util_pkg.assign_column('50 ','CT.TRX_NUMBER', 'TRX_NUMBER', 'arrx_tx.var.trx_number', 'VARCHAR2', 20);
589: fa_rx_util_pkg.assign_column('60 ',SELECT_BILL_NUMBER, 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);
590: fa_rx_util_pkg.assign_column('70 ','RECDIST.CUST_TRX_LINE_GL_DIST_ID', 'REC_CUST_TRX_LINE_GL_DIST_ID','arrx_tx.var.rec_cust_trx_line_gl_dist_id','NUMBER');

Line 587: fa_rx_util_pkg.assign_column('40 ','CT.CUSTOMER_TRX_ID', 'CUSTOMER_TRX_ID', 'arrx_tx.var.customer_trx_id', 'NUMBER');

583: -->>SELECT_START<<--
584: fa_rx_util_pkg.assign_column('10 ','CCRECDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid', 'NUMBER');
585: fa_rx_util_pkg.assign_column('20 ',null, 'ORGANIZATION_NAME', 'arrx_tx.var.organization_name', 'VARCHAR2', 30);
586: fa_rx_util_pkg.assign_column('30 ',null, 'FUNCTIONAL_CURRENCY_CODE', 'arrx_tx.var.functional_currency_code', 'VARCHAR2', 15);
587: fa_rx_util_pkg.assign_column('40 ','CT.CUSTOMER_TRX_ID', 'CUSTOMER_TRX_ID', 'arrx_tx.var.customer_trx_id', 'NUMBER');
588: fa_rx_util_pkg.assign_column('50 ','CT.TRX_NUMBER', 'TRX_NUMBER', 'arrx_tx.var.trx_number', 'VARCHAR2', 20);
589: fa_rx_util_pkg.assign_column('60 ',SELECT_BILL_NUMBER, 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);
590: fa_rx_util_pkg.assign_column('70 ','RECDIST.CUST_TRX_LINE_GL_DIST_ID', 'REC_CUST_TRX_LINE_GL_DIST_ID','arrx_tx.var.rec_cust_trx_line_gl_dist_id','NUMBER');
591: fa_rx_util_pkg.assign_column('80 ',REC_ACCOUNT_SEL, 'REC_ACCOUNT', 'arrx_tx.var.rec_account', 'VARCHAR2',240);

Line 588: fa_rx_util_pkg.assign_column('50 ','CT.TRX_NUMBER', 'TRX_NUMBER', 'arrx_tx.var.trx_number', 'VARCHAR2', 20);

584: fa_rx_util_pkg.assign_column('10 ','CCRECDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid', 'NUMBER');
585: fa_rx_util_pkg.assign_column('20 ',null, 'ORGANIZATION_NAME', 'arrx_tx.var.organization_name', 'VARCHAR2', 30);
586: fa_rx_util_pkg.assign_column('30 ',null, 'FUNCTIONAL_CURRENCY_CODE', 'arrx_tx.var.functional_currency_code', 'VARCHAR2', 15);
587: fa_rx_util_pkg.assign_column('40 ','CT.CUSTOMER_TRX_ID', 'CUSTOMER_TRX_ID', 'arrx_tx.var.customer_trx_id', 'NUMBER');
588: fa_rx_util_pkg.assign_column('50 ','CT.TRX_NUMBER', 'TRX_NUMBER', 'arrx_tx.var.trx_number', 'VARCHAR2', 20);
589: fa_rx_util_pkg.assign_column('60 ',SELECT_BILL_NUMBER, 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);
590: fa_rx_util_pkg.assign_column('70 ','RECDIST.CUST_TRX_LINE_GL_DIST_ID', 'REC_CUST_TRX_LINE_GL_DIST_ID','arrx_tx.var.rec_cust_trx_line_gl_dist_id','NUMBER');
591: fa_rx_util_pkg.assign_column('80 ',REC_ACCOUNT_SEL, 'REC_ACCOUNT', 'arrx_tx.var.rec_account', 'VARCHAR2',240);
592: fa_rx_util_pkg.assign_column('90 ',null, 'REC_ACCOUNT_DESC', 'arrx_tx.var.rec_account_desc', 'VARCHAR2',240);

Line 589: fa_rx_util_pkg.assign_column('60 ',SELECT_BILL_NUMBER, 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);

585: fa_rx_util_pkg.assign_column('20 ',null, 'ORGANIZATION_NAME', 'arrx_tx.var.organization_name', 'VARCHAR2', 30);
586: fa_rx_util_pkg.assign_column('30 ',null, 'FUNCTIONAL_CURRENCY_CODE', 'arrx_tx.var.functional_currency_code', 'VARCHAR2', 15);
587: fa_rx_util_pkg.assign_column('40 ','CT.CUSTOMER_TRX_ID', 'CUSTOMER_TRX_ID', 'arrx_tx.var.customer_trx_id', 'NUMBER');
588: fa_rx_util_pkg.assign_column('50 ','CT.TRX_NUMBER', 'TRX_NUMBER', 'arrx_tx.var.trx_number', 'VARCHAR2', 20);
589: fa_rx_util_pkg.assign_column('60 ',SELECT_BILL_NUMBER, 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);
590: fa_rx_util_pkg.assign_column('70 ','RECDIST.CUST_TRX_LINE_GL_DIST_ID', 'REC_CUST_TRX_LINE_GL_DIST_ID','arrx_tx.var.rec_cust_trx_line_gl_dist_id','NUMBER');
591: fa_rx_util_pkg.assign_column('80 ',REC_ACCOUNT_SEL, 'REC_ACCOUNT', 'arrx_tx.var.rec_account', 'VARCHAR2',240);
592: fa_rx_util_pkg.assign_column('90 ',null, 'REC_ACCOUNT_DESC', 'arrx_tx.var.rec_account_desc', 'VARCHAR2',240);
593: fa_rx_util_pkg.assign_column('100',REC_BALANCE_SEL, 'REC_BALANCE', 'arrx_tx.var.rec_balance', 'VARCHAR2',240);

Line 590: fa_rx_util_pkg.assign_column('70 ','RECDIST.CUST_TRX_LINE_GL_DIST_ID', 'REC_CUST_TRX_LINE_GL_DIST_ID','arrx_tx.var.rec_cust_trx_line_gl_dist_id','NUMBER');

586: fa_rx_util_pkg.assign_column('30 ',null, 'FUNCTIONAL_CURRENCY_CODE', 'arrx_tx.var.functional_currency_code', 'VARCHAR2', 15);
587: fa_rx_util_pkg.assign_column('40 ','CT.CUSTOMER_TRX_ID', 'CUSTOMER_TRX_ID', 'arrx_tx.var.customer_trx_id', 'NUMBER');
588: fa_rx_util_pkg.assign_column('50 ','CT.TRX_NUMBER', 'TRX_NUMBER', 'arrx_tx.var.trx_number', 'VARCHAR2', 20);
589: fa_rx_util_pkg.assign_column('60 ',SELECT_BILL_NUMBER, 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);
590: fa_rx_util_pkg.assign_column('70 ','RECDIST.CUST_TRX_LINE_GL_DIST_ID', 'REC_CUST_TRX_LINE_GL_DIST_ID','arrx_tx.var.rec_cust_trx_line_gl_dist_id','NUMBER');
591: fa_rx_util_pkg.assign_column('80 ',REC_ACCOUNT_SEL, 'REC_ACCOUNT', 'arrx_tx.var.rec_account', 'VARCHAR2',240);
592: fa_rx_util_pkg.assign_column('90 ',null, 'REC_ACCOUNT_DESC', 'arrx_tx.var.rec_account_desc', 'VARCHAR2',240);
593: fa_rx_util_pkg.assign_column('100',REC_BALANCE_SEL, 'REC_BALANCE', 'arrx_tx.var.rec_balance', 'VARCHAR2',240);
594: fa_rx_util_pkg.assign_column('110',null, 'REC_BALANCE_DESC', 'arrx_tx.var.rec_balance_desc', 'VARCHAR2',240);

Line 591: fa_rx_util_pkg.assign_column('80 ',REC_ACCOUNT_SEL, 'REC_ACCOUNT', 'arrx_tx.var.rec_account', 'VARCHAR2',240);

587: fa_rx_util_pkg.assign_column('40 ','CT.CUSTOMER_TRX_ID', 'CUSTOMER_TRX_ID', 'arrx_tx.var.customer_trx_id', 'NUMBER');
588: fa_rx_util_pkg.assign_column('50 ','CT.TRX_NUMBER', 'TRX_NUMBER', 'arrx_tx.var.trx_number', 'VARCHAR2', 20);
589: fa_rx_util_pkg.assign_column('60 ',SELECT_BILL_NUMBER, 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);
590: fa_rx_util_pkg.assign_column('70 ','RECDIST.CUST_TRX_LINE_GL_DIST_ID', 'REC_CUST_TRX_LINE_GL_DIST_ID','arrx_tx.var.rec_cust_trx_line_gl_dist_id','NUMBER');
591: fa_rx_util_pkg.assign_column('80 ',REC_ACCOUNT_SEL, 'REC_ACCOUNT', 'arrx_tx.var.rec_account', 'VARCHAR2',240);
592: fa_rx_util_pkg.assign_column('90 ',null, 'REC_ACCOUNT_DESC', 'arrx_tx.var.rec_account_desc', 'VARCHAR2',240);
593: fa_rx_util_pkg.assign_column('100',REC_BALANCE_SEL, 'REC_BALANCE', 'arrx_tx.var.rec_balance', 'VARCHAR2',240);
594: fa_rx_util_pkg.assign_column('110',null, 'REC_BALANCE_DESC', 'arrx_tx.var.rec_balance_desc', 'VARCHAR2',240);
595: fa_rx_util_pkg.assign_column('120',REC_NATURAL_SEL, 'REC_NATACCT', 'arrx_tx.var.rec_natacct', 'VARCHAR2',240);

Line 592: fa_rx_util_pkg.assign_column('90 ',null, 'REC_ACCOUNT_DESC', 'arrx_tx.var.rec_account_desc', 'VARCHAR2',240);

588: fa_rx_util_pkg.assign_column('50 ','CT.TRX_NUMBER', 'TRX_NUMBER', 'arrx_tx.var.trx_number', 'VARCHAR2', 20);
589: fa_rx_util_pkg.assign_column('60 ',SELECT_BILL_NUMBER, 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);
590: fa_rx_util_pkg.assign_column('70 ','RECDIST.CUST_TRX_LINE_GL_DIST_ID', 'REC_CUST_TRX_LINE_GL_DIST_ID','arrx_tx.var.rec_cust_trx_line_gl_dist_id','NUMBER');
591: fa_rx_util_pkg.assign_column('80 ',REC_ACCOUNT_SEL, 'REC_ACCOUNT', 'arrx_tx.var.rec_account', 'VARCHAR2',240);
592: fa_rx_util_pkg.assign_column('90 ',null, 'REC_ACCOUNT_DESC', 'arrx_tx.var.rec_account_desc', 'VARCHAR2',240);
593: fa_rx_util_pkg.assign_column('100',REC_BALANCE_SEL, 'REC_BALANCE', 'arrx_tx.var.rec_balance', 'VARCHAR2',240);
594: fa_rx_util_pkg.assign_column('110',null, 'REC_BALANCE_DESC', 'arrx_tx.var.rec_balance_desc', 'VARCHAR2',240);
595: fa_rx_util_pkg.assign_column('120',REC_NATURAL_SEL, 'REC_NATACCT', 'arrx_tx.var.rec_natacct', 'VARCHAR2',240);
596: fa_rx_util_pkg.assign_column('130',null, 'REC_NATACCT_DESC', 'arrx_tx.var.rec_natacct_desc', 'VARCHAR2',240);

Line 593: fa_rx_util_pkg.assign_column('100',REC_BALANCE_SEL, 'REC_BALANCE', 'arrx_tx.var.rec_balance', 'VARCHAR2',240);

589: fa_rx_util_pkg.assign_column('60 ',SELECT_BILL_NUMBER, 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);
590: fa_rx_util_pkg.assign_column('70 ','RECDIST.CUST_TRX_LINE_GL_DIST_ID', 'REC_CUST_TRX_LINE_GL_DIST_ID','arrx_tx.var.rec_cust_trx_line_gl_dist_id','NUMBER');
591: fa_rx_util_pkg.assign_column('80 ',REC_ACCOUNT_SEL, 'REC_ACCOUNT', 'arrx_tx.var.rec_account', 'VARCHAR2',240);
592: fa_rx_util_pkg.assign_column('90 ',null, 'REC_ACCOUNT_DESC', 'arrx_tx.var.rec_account_desc', 'VARCHAR2',240);
593: fa_rx_util_pkg.assign_column('100',REC_BALANCE_SEL, 'REC_BALANCE', 'arrx_tx.var.rec_balance', 'VARCHAR2',240);
594: fa_rx_util_pkg.assign_column('110',null, 'REC_BALANCE_DESC', 'arrx_tx.var.rec_balance_desc', 'VARCHAR2',240);
595: fa_rx_util_pkg.assign_column('120',REC_NATURAL_SEL, 'REC_NATACCT', 'arrx_tx.var.rec_natacct', 'VARCHAR2',240);
596: fa_rx_util_pkg.assign_column('130',null, 'REC_NATACCT_DESC', 'arrx_tx.var.rec_natacct_desc', 'VARCHAR2',240);
597: fa_rx_util_pkg.assign_column('140','DECODE(RECDIST.GL_DATE,NULL,:NO,:YES)', 'REC_POSTABLE_FLAG', 'arrx_tx.var.rec_postable_flag', 'VARCHAR2', 10);

Line 594: fa_rx_util_pkg.assign_column('110',null, 'REC_BALANCE_DESC', 'arrx_tx.var.rec_balance_desc', 'VARCHAR2',240);

590: fa_rx_util_pkg.assign_column('70 ','RECDIST.CUST_TRX_LINE_GL_DIST_ID', 'REC_CUST_TRX_LINE_GL_DIST_ID','arrx_tx.var.rec_cust_trx_line_gl_dist_id','NUMBER');
591: fa_rx_util_pkg.assign_column('80 ',REC_ACCOUNT_SEL, 'REC_ACCOUNT', 'arrx_tx.var.rec_account', 'VARCHAR2',240);
592: fa_rx_util_pkg.assign_column('90 ',null, 'REC_ACCOUNT_DESC', 'arrx_tx.var.rec_account_desc', 'VARCHAR2',240);
593: fa_rx_util_pkg.assign_column('100',REC_BALANCE_SEL, 'REC_BALANCE', 'arrx_tx.var.rec_balance', 'VARCHAR2',240);
594: fa_rx_util_pkg.assign_column('110',null, 'REC_BALANCE_DESC', 'arrx_tx.var.rec_balance_desc', 'VARCHAR2',240);
595: fa_rx_util_pkg.assign_column('120',REC_NATURAL_SEL, 'REC_NATACCT', 'arrx_tx.var.rec_natacct', 'VARCHAR2',240);
596: fa_rx_util_pkg.assign_column('130',null, 'REC_NATACCT_DESC', 'arrx_tx.var.rec_natacct_desc', 'VARCHAR2',240);
597: fa_rx_util_pkg.assign_column('140','DECODE(RECDIST.GL_DATE,NULL,:NO,:YES)', 'REC_POSTABLE_FLAG', 'arrx_tx.var.rec_postable_flag', 'VARCHAR2', 10);
598: fa_rx_util_pkg.assign_column('150','ARRX_TX.LAST_UPDATED_BY(CT.CUSTOMER_TRX_ID)', 'TRX_LAST_UPDATED_BY', 'arrx_tx.var.trx_last_updated_by', 'NUMBER');

Line 595: fa_rx_util_pkg.assign_column('120',REC_NATURAL_SEL, 'REC_NATACCT', 'arrx_tx.var.rec_natacct', 'VARCHAR2',240);

591: fa_rx_util_pkg.assign_column('80 ',REC_ACCOUNT_SEL, 'REC_ACCOUNT', 'arrx_tx.var.rec_account', 'VARCHAR2',240);
592: fa_rx_util_pkg.assign_column('90 ',null, 'REC_ACCOUNT_DESC', 'arrx_tx.var.rec_account_desc', 'VARCHAR2',240);
593: fa_rx_util_pkg.assign_column('100',REC_BALANCE_SEL, 'REC_BALANCE', 'arrx_tx.var.rec_balance', 'VARCHAR2',240);
594: fa_rx_util_pkg.assign_column('110',null, 'REC_BALANCE_DESC', 'arrx_tx.var.rec_balance_desc', 'VARCHAR2',240);
595: fa_rx_util_pkg.assign_column('120',REC_NATURAL_SEL, 'REC_NATACCT', 'arrx_tx.var.rec_natacct', 'VARCHAR2',240);
596: fa_rx_util_pkg.assign_column('130',null, 'REC_NATACCT_DESC', 'arrx_tx.var.rec_natacct_desc', 'VARCHAR2',240);
597: fa_rx_util_pkg.assign_column('140','DECODE(RECDIST.GL_DATE,NULL,:NO,:YES)', 'REC_POSTABLE_FLAG', 'arrx_tx.var.rec_postable_flag', 'VARCHAR2', 10);
598: fa_rx_util_pkg.assign_column('150','ARRX_TX.LAST_UPDATED_BY(CT.CUSTOMER_TRX_ID)', 'TRX_LAST_UPDATED_BY', 'arrx_tx.var.trx_last_updated_by', 'NUMBER');
599: fa_rx_util_pkg.assign_column('160','ARRX_TX.LAST_UPDATE_DATE(CT.CUSTOMER_TRX_ID)','TRX_LAST_UPDATE_DATE', 'arrx_tx.var.trx_last_update_date', 'DATE');

Line 596: fa_rx_util_pkg.assign_column('130',null, 'REC_NATACCT_DESC', 'arrx_tx.var.rec_natacct_desc', 'VARCHAR2',240);

592: fa_rx_util_pkg.assign_column('90 ',null, 'REC_ACCOUNT_DESC', 'arrx_tx.var.rec_account_desc', 'VARCHAR2',240);
593: fa_rx_util_pkg.assign_column('100',REC_BALANCE_SEL, 'REC_BALANCE', 'arrx_tx.var.rec_balance', 'VARCHAR2',240);
594: fa_rx_util_pkg.assign_column('110',null, 'REC_BALANCE_DESC', 'arrx_tx.var.rec_balance_desc', 'VARCHAR2',240);
595: fa_rx_util_pkg.assign_column('120',REC_NATURAL_SEL, 'REC_NATACCT', 'arrx_tx.var.rec_natacct', 'VARCHAR2',240);
596: fa_rx_util_pkg.assign_column('130',null, 'REC_NATACCT_DESC', 'arrx_tx.var.rec_natacct_desc', 'VARCHAR2',240);
597: fa_rx_util_pkg.assign_column('140','DECODE(RECDIST.GL_DATE,NULL,:NO,:YES)', 'REC_POSTABLE_FLAG', 'arrx_tx.var.rec_postable_flag', 'VARCHAR2', 10);
598: fa_rx_util_pkg.assign_column('150','ARRX_TX.LAST_UPDATED_BY(CT.CUSTOMER_TRX_ID)', 'TRX_LAST_UPDATED_BY', 'arrx_tx.var.trx_last_updated_by', 'NUMBER');
599: fa_rx_util_pkg.assign_column('160','ARRX_TX.LAST_UPDATE_DATE(CT.CUSTOMER_TRX_ID)','TRX_LAST_UPDATE_DATE', 'arrx_tx.var.trx_last_update_date', 'DATE');
600: fa_rx_util_pkg.assign_column('170','CT.TRX_DATE', 'TRX_DATE', 'arrx_tx.var.trx_date', 'DATE');

Line 597: fa_rx_util_pkg.assign_column('140','DECODE(RECDIST.GL_DATE,NULL,:NO,:YES)', 'REC_POSTABLE_FLAG', 'arrx_tx.var.rec_postable_flag', 'VARCHAR2', 10);

593: fa_rx_util_pkg.assign_column('100',REC_BALANCE_SEL, 'REC_BALANCE', 'arrx_tx.var.rec_balance', 'VARCHAR2',240);
594: fa_rx_util_pkg.assign_column('110',null, 'REC_BALANCE_DESC', 'arrx_tx.var.rec_balance_desc', 'VARCHAR2',240);
595: fa_rx_util_pkg.assign_column('120',REC_NATURAL_SEL, 'REC_NATACCT', 'arrx_tx.var.rec_natacct', 'VARCHAR2',240);
596: fa_rx_util_pkg.assign_column('130',null, 'REC_NATACCT_DESC', 'arrx_tx.var.rec_natacct_desc', 'VARCHAR2',240);
597: fa_rx_util_pkg.assign_column('140','DECODE(RECDIST.GL_DATE,NULL,:NO,:YES)', 'REC_POSTABLE_FLAG', 'arrx_tx.var.rec_postable_flag', 'VARCHAR2', 10);
598: fa_rx_util_pkg.assign_column('150','ARRX_TX.LAST_UPDATED_BY(CT.CUSTOMER_TRX_ID)', 'TRX_LAST_UPDATED_BY', 'arrx_tx.var.trx_last_updated_by', 'NUMBER');
599: fa_rx_util_pkg.assign_column('160','ARRX_TX.LAST_UPDATE_DATE(CT.CUSTOMER_TRX_ID)','TRX_LAST_UPDATE_DATE', 'arrx_tx.var.trx_last_update_date', 'DATE');
600: fa_rx_util_pkg.assign_column('170','CT.TRX_DATE', 'TRX_DATE', 'arrx_tx.var.trx_date', 'DATE');
601: fa_rx_util_pkg.assign_column('180','CT.INVOICE_CURRENCY_CODE', 'TRX_CURRENCY', 'arrx_tx.var.trx_currency', 'VARCHAR2', 15);

Line 598: fa_rx_util_pkg.assign_column('150','ARRX_TX.LAST_UPDATED_BY(CT.CUSTOMER_TRX_ID)', 'TRX_LAST_UPDATED_BY', 'arrx_tx.var.trx_last_updated_by', 'NUMBER');

594: fa_rx_util_pkg.assign_column('110',null, 'REC_BALANCE_DESC', 'arrx_tx.var.rec_balance_desc', 'VARCHAR2',240);
595: fa_rx_util_pkg.assign_column('120',REC_NATURAL_SEL, 'REC_NATACCT', 'arrx_tx.var.rec_natacct', 'VARCHAR2',240);
596: fa_rx_util_pkg.assign_column('130',null, 'REC_NATACCT_DESC', 'arrx_tx.var.rec_natacct_desc', 'VARCHAR2',240);
597: fa_rx_util_pkg.assign_column('140','DECODE(RECDIST.GL_DATE,NULL,:NO,:YES)', 'REC_POSTABLE_FLAG', 'arrx_tx.var.rec_postable_flag', 'VARCHAR2', 10);
598: fa_rx_util_pkg.assign_column('150','ARRX_TX.LAST_UPDATED_BY(CT.CUSTOMER_TRX_ID)', 'TRX_LAST_UPDATED_BY', 'arrx_tx.var.trx_last_updated_by', 'NUMBER');
599: fa_rx_util_pkg.assign_column('160','ARRX_TX.LAST_UPDATE_DATE(CT.CUSTOMER_TRX_ID)','TRX_LAST_UPDATE_DATE', 'arrx_tx.var.trx_last_update_date', 'DATE');
600: fa_rx_util_pkg.assign_column('170','CT.TRX_DATE', 'TRX_DATE', 'arrx_tx.var.trx_date', 'DATE');
601: fa_rx_util_pkg.assign_column('180','CT.INVOICE_CURRENCY_CODE', 'TRX_CURRENCY', 'arrx_tx.var.trx_currency', 'VARCHAR2', 15);
602: fa_rx_util_pkg.assign_column('190','CT.EXCHANGE_RATE', 'EXCHANGE_RATE', 'arrx_tx.var.exchange_rate', 'NUMBER');

Line 599: fa_rx_util_pkg.assign_column('160','ARRX_TX.LAST_UPDATE_DATE(CT.CUSTOMER_TRX_ID)','TRX_LAST_UPDATE_DATE', 'arrx_tx.var.trx_last_update_date', 'DATE');

595: fa_rx_util_pkg.assign_column('120',REC_NATURAL_SEL, 'REC_NATACCT', 'arrx_tx.var.rec_natacct', 'VARCHAR2',240);
596: fa_rx_util_pkg.assign_column('130',null, 'REC_NATACCT_DESC', 'arrx_tx.var.rec_natacct_desc', 'VARCHAR2',240);
597: fa_rx_util_pkg.assign_column('140','DECODE(RECDIST.GL_DATE,NULL,:NO,:YES)', 'REC_POSTABLE_FLAG', 'arrx_tx.var.rec_postable_flag', 'VARCHAR2', 10);
598: fa_rx_util_pkg.assign_column('150','ARRX_TX.LAST_UPDATED_BY(CT.CUSTOMER_TRX_ID)', 'TRX_LAST_UPDATED_BY', 'arrx_tx.var.trx_last_updated_by', 'NUMBER');
599: fa_rx_util_pkg.assign_column('160','ARRX_TX.LAST_UPDATE_DATE(CT.CUSTOMER_TRX_ID)','TRX_LAST_UPDATE_DATE', 'arrx_tx.var.trx_last_update_date', 'DATE');
600: fa_rx_util_pkg.assign_column('170','CT.TRX_DATE', 'TRX_DATE', 'arrx_tx.var.trx_date', 'DATE');
601: fa_rx_util_pkg.assign_column('180','CT.INVOICE_CURRENCY_CODE', 'TRX_CURRENCY', 'arrx_tx.var.trx_currency', 'VARCHAR2', 15);
602: fa_rx_util_pkg.assign_column('190','CT.EXCHANGE_RATE', 'EXCHANGE_RATE', 'arrx_tx.var.exchange_rate', 'NUMBER');
603: fa_rx_util_pkg.assign_column('200','CT.EXCHANGE_DATE', 'EXCHANGE_DATE', 'arrx_tx.var.exchange_date', 'DATE');

Line 600: fa_rx_util_pkg.assign_column('170','CT.TRX_DATE', 'TRX_DATE', 'arrx_tx.var.trx_date', 'DATE');

596: fa_rx_util_pkg.assign_column('130',null, 'REC_NATACCT_DESC', 'arrx_tx.var.rec_natacct_desc', 'VARCHAR2',240);
597: fa_rx_util_pkg.assign_column('140','DECODE(RECDIST.GL_DATE,NULL,:NO,:YES)', 'REC_POSTABLE_FLAG', 'arrx_tx.var.rec_postable_flag', 'VARCHAR2', 10);
598: fa_rx_util_pkg.assign_column('150','ARRX_TX.LAST_UPDATED_BY(CT.CUSTOMER_TRX_ID)', 'TRX_LAST_UPDATED_BY', 'arrx_tx.var.trx_last_updated_by', 'NUMBER');
599: fa_rx_util_pkg.assign_column('160','ARRX_TX.LAST_UPDATE_DATE(CT.CUSTOMER_TRX_ID)','TRX_LAST_UPDATE_DATE', 'arrx_tx.var.trx_last_update_date', 'DATE');
600: fa_rx_util_pkg.assign_column('170','CT.TRX_DATE', 'TRX_DATE', 'arrx_tx.var.trx_date', 'DATE');
601: fa_rx_util_pkg.assign_column('180','CT.INVOICE_CURRENCY_CODE', 'TRX_CURRENCY', 'arrx_tx.var.trx_currency', 'VARCHAR2', 15);
602: fa_rx_util_pkg.assign_column('190','CT.EXCHANGE_RATE', 'EXCHANGE_RATE', 'arrx_tx.var.exchange_rate', 'NUMBER');
603: fa_rx_util_pkg.assign_column('200','CT.EXCHANGE_DATE', 'EXCHANGE_DATE', 'arrx_tx.var.exchange_date', 'DATE');
604: fa_rx_util_pkg.assign_column('210','CT.EXCHANGE_RATE_TYPE', 'EXCHANGE_TYPE', 'arrx_tx.var.exchange_type', 'VARCHAR2', 30);

Line 601: fa_rx_util_pkg.assign_column('180','CT.INVOICE_CURRENCY_CODE', 'TRX_CURRENCY', 'arrx_tx.var.trx_currency', 'VARCHAR2', 15);

597: fa_rx_util_pkg.assign_column('140','DECODE(RECDIST.GL_DATE,NULL,:NO,:YES)', 'REC_POSTABLE_FLAG', 'arrx_tx.var.rec_postable_flag', 'VARCHAR2', 10);
598: fa_rx_util_pkg.assign_column('150','ARRX_TX.LAST_UPDATED_BY(CT.CUSTOMER_TRX_ID)', 'TRX_LAST_UPDATED_BY', 'arrx_tx.var.trx_last_updated_by', 'NUMBER');
599: fa_rx_util_pkg.assign_column('160','ARRX_TX.LAST_UPDATE_DATE(CT.CUSTOMER_TRX_ID)','TRX_LAST_UPDATE_DATE', 'arrx_tx.var.trx_last_update_date', 'DATE');
600: fa_rx_util_pkg.assign_column('170','CT.TRX_DATE', 'TRX_DATE', 'arrx_tx.var.trx_date', 'DATE');
601: fa_rx_util_pkg.assign_column('180','CT.INVOICE_CURRENCY_CODE', 'TRX_CURRENCY', 'arrx_tx.var.trx_currency', 'VARCHAR2', 15);
602: fa_rx_util_pkg.assign_column('190','CT.EXCHANGE_RATE', 'EXCHANGE_RATE', 'arrx_tx.var.exchange_rate', 'NUMBER');
603: fa_rx_util_pkg.assign_column('200','CT.EXCHANGE_DATE', 'EXCHANGE_DATE', 'arrx_tx.var.exchange_date', 'DATE');
604: fa_rx_util_pkg.assign_column('210','CT.EXCHANGE_RATE_TYPE', 'EXCHANGE_TYPE', 'arrx_tx.var.exchange_type', 'VARCHAR2', 30);
605: fa_rx_util_pkg.assign_column('220','RECDIST.GL_DATE', 'RECEIVABLES_GL_DATE', 'arrx_tx.var.receivables_gl_date', 'DATE');

Line 602: fa_rx_util_pkg.assign_column('190','CT.EXCHANGE_RATE', 'EXCHANGE_RATE', 'arrx_tx.var.exchange_rate', 'NUMBER');

598: fa_rx_util_pkg.assign_column('150','ARRX_TX.LAST_UPDATED_BY(CT.CUSTOMER_TRX_ID)', 'TRX_LAST_UPDATED_BY', 'arrx_tx.var.trx_last_updated_by', 'NUMBER');
599: fa_rx_util_pkg.assign_column('160','ARRX_TX.LAST_UPDATE_DATE(CT.CUSTOMER_TRX_ID)','TRX_LAST_UPDATE_DATE', 'arrx_tx.var.trx_last_update_date', 'DATE');
600: fa_rx_util_pkg.assign_column('170','CT.TRX_DATE', 'TRX_DATE', 'arrx_tx.var.trx_date', 'DATE');
601: fa_rx_util_pkg.assign_column('180','CT.INVOICE_CURRENCY_CODE', 'TRX_CURRENCY', 'arrx_tx.var.trx_currency', 'VARCHAR2', 15);
602: fa_rx_util_pkg.assign_column('190','CT.EXCHANGE_RATE', 'EXCHANGE_RATE', 'arrx_tx.var.exchange_rate', 'NUMBER');
603: fa_rx_util_pkg.assign_column('200','CT.EXCHANGE_DATE', 'EXCHANGE_DATE', 'arrx_tx.var.exchange_date', 'DATE');
604: fa_rx_util_pkg.assign_column('210','CT.EXCHANGE_RATE_TYPE', 'EXCHANGE_TYPE', 'arrx_tx.var.exchange_type', 'VARCHAR2', 30);
605: fa_rx_util_pkg.assign_column('220','RECDIST.GL_DATE', 'RECEIVABLES_GL_DATE', 'arrx_tx.var.receivables_gl_date', 'DATE');
606: -- bug4274502 added nvl because AutoInvoice does not set term_due_date

Line 603: fa_rx_util_pkg.assign_column('200','CT.EXCHANGE_DATE', 'EXCHANGE_DATE', 'arrx_tx.var.exchange_date', 'DATE');

599: fa_rx_util_pkg.assign_column('160','ARRX_TX.LAST_UPDATE_DATE(CT.CUSTOMER_TRX_ID)','TRX_LAST_UPDATE_DATE', 'arrx_tx.var.trx_last_update_date', 'DATE');
600: fa_rx_util_pkg.assign_column('170','CT.TRX_DATE', 'TRX_DATE', 'arrx_tx.var.trx_date', 'DATE');
601: fa_rx_util_pkg.assign_column('180','CT.INVOICE_CURRENCY_CODE', 'TRX_CURRENCY', 'arrx_tx.var.trx_currency', 'VARCHAR2', 15);
602: fa_rx_util_pkg.assign_column('190','CT.EXCHANGE_RATE', 'EXCHANGE_RATE', 'arrx_tx.var.exchange_rate', 'NUMBER');
603: fa_rx_util_pkg.assign_column('200','CT.EXCHANGE_DATE', 'EXCHANGE_DATE', 'arrx_tx.var.exchange_date', 'DATE');
604: fa_rx_util_pkg.assign_column('210','CT.EXCHANGE_RATE_TYPE', 'EXCHANGE_TYPE', 'arrx_tx.var.exchange_type', 'VARCHAR2', 30);
605: fa_rx_util_pkg.assign_column('220','RECDIST.GL_DATE', 'RECEIVABLES_GL_DATE', 'arrx_tx.var.receivables_gl_date', 'DATE');
606: -- bug4274502 added nvl because AutoInvoice does not set term_due_date
607: fa_rx_util_pkg.assign_column('230','NVL(CT.TERM_DUE_DATE,ARPT_SQL_FUNC_UTIL.GET_FIRST_REAL_DUE_DATE(CT.CUSTOMER_TRX_ID, CT.TERM_ID, CT.TRX_DATE)) ', 'TRX_DUE_DATE', 'arrx_tx.var.trx_due_date', 'DATE');

Line 604: fa_rx_util_pkg.assign_column('210','CT.EXCHANGE_RATE_TYPE', 'EXCHANGE_TYPE', 'arrx_tx.var.exchange_type', 'VARCHAR2', 30);

600: fa_rx_util_pkg.assign_column('170','CT.TRX_DATE', 'TRX_DATE', 'arrx_tx.var.trx_date', 'DATE');
601: fa_rx_util_pkg.assign_column('180','CT.INVOICE_CURRENCY_CODE', 'TRX_CURRENCY', 'arrx_tx.var.trx_currency', 'VARCHAR2', 15);
602: fa_rx_util_pkg.assign_column('190','CT.EXCHANGE_RATE', 'EXCHANGE_RATE', 'arrx_tx.var.exchange_rate', 'NUMBER');
603: fa_rx_util_pkg.assign_column('200','CT.EXCHANGE_DATE', 'EXCHANGE_DATE', 'arrx_tx.var.exchange_date', 'DATE');
604: fa_rx_util_pkg.assign_column('210','CT.EXCHANGE_RATE_TYPE', 'EXCHANGE_TYPE', 'arrx_tx.var.exchange_type', 'VARCHAR2', 30);
605: fa_rx_util_pkg.assign_column('220','RECDIST.GL_DATE', 'RECEIVABLES_GL_DATE', 'arrx_tx.var.receivables_gl_date', 'DATE');
606: -- bug4274502 added nvl because AutoInvoice does not set term_due_date
607: fa_rx_util_pkg.assign_column('230','NVL(CT.TERM_DUE_DATE,ARPT_SQL_FUNC_UTIL.GET_FIRST_REAL_DUE_DATE(CT.CUSTOMER_TRX_ID, CT.TERM_ID, CT.TRX_DATE)) ', 'TRX_DUE_DATE', 'arrx_tx.var.trx_due_date', 'DATE');
608: fa_rx_util_pkg.assign_column('240', null, 'TAX_HEADER_LEVEL_FLAG', 'arrx_tx.var.tax_header_level_flag', 'VARCHAR2', 1);

Line 605: fa_rx_util_pkg.assign_column('220','RECDIST.GL_DATE', 'RECEIVABLES_GL_DATE', 'arrx_tx.var.receivables_gl_date', 'DATE');

601: fa_rx_util_pkg.assign_column('180','CT.INVOICE_CURRENCY_CODE', 'TRX_CURRENCY', 'arrx_tx.var.trx_currency', 'VARCHAR2', 15);
602: fa_rx_util_pkg.assign_column('190','CT.EXCHANGE_RATE', 'EXCHANGE_RATE', 'arrx_tx.var.exchange_rate', 'NUMBER');
603: fa_rx_util_pkg.assign_column('200','CT.EXCHANGE_DATE', 'EXCHANGE_DATE', 'arrx_tx.var.exchange_date', 'DATE');
604: fa_rx_util_pkg.assign_column('210','CT.EXCHANGE_RATE_TYPE', 'EXCHANGE_TYPE', 'arrx_tx.var.exchange_type', 'VARCHAR2', 30);
605: fa_rx_util_pkg.assign_column('220','RECDIST.GL_DATE', 'RECEIVABLES_GL_DATE', 'arrx_tx.var.receivables_gl_date', 'DATE');
606: -- bug4274502 added nvl because AutoInvoice does not set term_due_date
607: fa_rx_util_pkg.assign_column('230','NVL(CT.TERM_DUE_DATE,ARPT_SQL_FUNC_UTIL.GET_FIRST_REAL_DUE_DATE(CT.CUSTOMER_TRX_ID, CT.TERM_ID, CT.TRX_DATE)) ', 'TRX_DUE_DATE', 'arrx_tx.var.trx_due_date', 'DATE');
608: fa_rx_util_pkg.assign_column('240', null, 'TAX_HEADER_LEVEL_FLAG', 'arrx_tx.var.tax_header_level_flag', 'VARCHAR2', 1);
609: fa_rx_util_pkg.assign_column('250','CT.DOC_SEQUENCE_VALUE', 'DOC_SEQUENCE_VALUE', 'arrx_tx.var.doc_sequence_value', 'NUMBER');

Line 607: fa_rx_util_pkg.assign_column('230','NVL(CT.TERM_DUE_DATE,ARPT_SQL_FUNC_UTIL.GET_FIRST_REAL_DUE_DATE(CT.CUSTOMER_TRX_ID, CT.TERM_ID, CT.TRX_DATE)) ', 'TRX_DUE_DATE', 'arrx_tx.var.trx_due_date', 'DATE');

603: fa_rx_util_pkg.assign_column('200','CT.EXCHANGE_DATE', 'EXCHANGE_DATE', 'arrx_tx.var.exchange_date', 'DATE');
604: fa_rx_util_pkg.assign_column('210','CT.EXCHANGE_RATE_TYPE', 'EXCHANGE_TYPE', 'arrx_tx.var.exchange_type', 'VARCHAR2', 30);
605: fa_rx_util_pkg.assign_column('220','RECDIST.GL_DATE', 'RECEIVABLES_GL_DATE', 'arrx_tx.var.receivables_gl_date', 'DATE');
606: -- bug4274502 added nvl because AutoInvoice does not set term_due_date
607: fa_rx_util_pkg.assign_column('230','NVL(CT.TERM_DUE_DATE,ARPT_SQL_FUNC_UTIL.GET_FIRST_REAL_DUE_DATE(CT.CUSTOMER_TRX_ID, CT.TERM_ID, CT.TRX_DATE)) ', 'TRX_DUE_DATE', 'arrx_tx.var.trx_due_date', 'DATE');
608: fa_rx_util_pkg.assign_column('240', null, 'TAX_HEADER_LEVEL_FLAG', 'arrx_tx.var.tax_header_level_flag', 'VARCHAR2', 1);
609: fa_rx_util_pkg.assign_column('250','CT.DOC_SEQUENCE_VALUE', 'DOC_SEQUENCE_VALUE', 'arrx_tx.var.doc_sequence_value', 'NUMBER');
610: fa_rx_util_pkg.assign_column('260','RECDIST.AMOUNT', 'TRX_AMOUNT', 'arrx_tx.var.trx_amount', 'NUMBER');
611: fa_rx_util_pkg.assign_column('270','RECDIST.ACCTD_AMOUNT', 'TRX_ACCTD_AMOUNT', 'arrx_tx.var.trx_acctd_amount', 'NUMBER');

Line 608: fa_rx_util_pkg.assign_column('240', null, 'TAX_HEADER_LEVEL_FLAG', 'arrx_tx.var.tax_header_level_flag', 'VARCHAR2', 1);

604: fa_rx_util_pkg.assign_column('210','CT.EXCHANGE_RATE_TYPE', 'EXCHANGE_TYPE', 'arrx_tx.var.exchange_type', 'VARCHAR2', 30);
605: fa_rx_util_pkg.assign_column('220','RECDIST.GL_DATE', 'RECEIVABLES_GL_DATE', 'arrx_tx.var.receivables_gl_date', 'DATE');
606: -- bug4274502 added nvl because AutoInvoice does not set term_due_date
607: fa_rx_util_pkg.assign_column('230','NVL(CT.TERM_DUE_DATE,ARPT_SQL_FUNC_UTIL.GET_FIRST_REAL_DUE_DATE(CT.CUSTOMER_TRX_ID, CT.TERM_ID, CT.TRX_DATE)) ', 'TRX_DUE_DATE', 'arrx_tx.var.trx_due_date', 'DATE');
608: fa_rx_util_pkg.assign_column('240', null, 'TAX_HEADER_LEVEL_FLAG', 'arrx_tx.var.tax_header_level_flag', 'VARCHAR2', 1);
609: fa_rx_util_pkg.assign_column('250','CT.DOC_SEQUENCE_VALUE', 'DOC_SEQUENCE_VALUE', 'arrx_tx.var.doc_sequence_value', 'NUMBER');
610: fa_rx_util_pkg.assign_column('260','RECDIST.AMOUNT', 'TRX_AMOUNT', 'arrx_tx.var.trx_amount', 'NUMBER');
611: fa_rx_util_pkg.assign_column('270','RECDIST.ACCTD_AMOUNT', 'TRX_ACCTD_AMOUNT', 'arrx_tx.var.trx_acctd_amount', 'NUMBER');
612: fa_rx_util_pkg.assign_column('280','CT.SHIP_TO_CUSTOMER_ID', 'SHIP_TO_CUSTOMER_ID', 'arrx_tx.var.ship_to_customer_id', 'NUMBER', 15);

Line 609: fa_rx_util_pkg.assign_column('250','CT.DOC_SEQUENCE_VALUE', 'DOC_SEQUENCE_VALUE', 'arrx_tx.var.doc_sequence_value', 'NUMBER');

605: fa_rx_util_pkg.assign_column('220','RECDIST.GL_DATE', 'RECEIVABLES_GL_DATE', 'arrx_tx.var.receivables_gl_date', 'DATE');
606: -- bug4274502 added nvl because AutoInvoice does not set term_due_date
607: fa_rx_util_pkg.assign_column('230','NVL(CT.TERM_DUE_DATE,ARPT_SQL_FUNC_UTIL.GET_FIRST_REAL_DUE_DATE(CT.CUSTOMER_TRX_ID, CT.TERM_ID, CT.TRX_DATE)) ', 'TRX_DUE_DATE', 'arrx_tx.var.trx_due_date', 'DATE');
608: fa_rx_util_pkg.assign_column('240', null, 'TAX_HEADER_LEVEL_FLAG', 'arrx_tx.var.tax_header_level_flag', 'VARCHAR2', 1);
609: fa_rx_util_pkg.assign_column('250','CT.DOC_SEQUENCE_VALUE', 'DOC_SEQUENCE_VALUE', 'arrx_tx.var.doc_sequence_value', 'NUMBER');
610: fa_rx_util_pkg.assign_column('260','RECDIST.AMOUNT', 'TRX_AMOUNT', 'arrx_tx.var.trx_amount', 'NUMBER');
611: fa_rx_util_pkg.assign_column('270','RECDIST.ACCTD_AMOUNT', 'TRX_ACCTD_AMOUNT', 'arrx_tx.var.trx_acctd_amount', 'NUMBER');
612: fa_rx_util_pkg.assign_column('280','CT.SHIP_TO_CUSTOMER_ID', 'SHIP_TO_CUSTOMER_ID', 'arrx_tx.var.ship_to_customer_id', 'NUMBER', 15);
613: fa_rx_util_pkg.assign_column('290','CT.SHIP_TO_SITE_USE_ID', 'SHIP_TO_SITE_USE_ID', 'arrx_tx.var.ship_to_site_use_id', 'NUMBER', 15);

Line 610: fa_rx_util_pkg.assign_column('260','RECDIST.AMOUNT', 'TRX_AMOUNT', 'arrx_tx.var.trx_amount', 'NUMBER');

606: -- bug4274502 added nvl because AutoInvoice does not set term_due_date
607: fa_rx_util_pkg.assign_column('230','NVL(CT.TERM_DUE_DATE,ARPT_SQL_FUNC_UTIL.GET_FIRST_REAL_DUE_DATE(CT.CUSTOMER_TRX_ID, CT.TERM_ID, CT.TRX_DATE)) ', 'TRX_DUE_DATE', 'arrx_tx.var.trx_due_date', 'DATE');
608: fa_rx_util_pkg.assign_column('240', null, 'TAX_HEADER_LEVEL_FLAG', 'arrx_tx.var.tax_header_level_flag', 'VARCHAR2', 1);
609: fa_rx_util_pkg.assign_column('250','CT.DOC_SEQUENCE_VALUE', 'DOC_SEQUENCE_VALUE', 'arrx_tx.var.doc_sequence_value', 'NUMBER');
610: fa_rx_util_pkg.assign_column('260','RECDIST.AMOUNT', 'TRX_AMOUNT', 'arrx_tx.var.trx_amount', 'NUMBER');
611: fa_rx_util_pkg.assign_column('270','RECDIST.ACCTD_AMOUNT', 'TRX_ACCTD_AMOUNT', 'arrx_tx.var.trx_acctd_amount', 'NUMBER');
612: fa_rx_util_pkg.assign_column('280','CT.SHIP_TO_CUSTOMER_ID', 'SHIP_TO_CUSTOMER_ID', 'arrx_tx.var.ship_to_customer_id', 'NUMBER', 15);
613: fa_rx_util_pkg.assign_column('290','CT.SHIP_TO_SITE_USE_ID', 'SHIP_TO_SITE_USE_ID', 'arrx_tx.var.ship_to_site_use_id', 'NUMBER', 15);
614: fa_rx_util_pkg.assign_column('300','CT.BILL_TO_CUSTOMER_ID', 'BILL_TO_CUSTOMER_ID', 'arrx_tx.var.bill_to_customer_id', 'NUMBER', 15);

Line 611: fa_rx_util_pkg.assign_column('270','RECDIST.ACCTD_AMOUNT', 'TRX_ACCTD_AMOUNT', 'arrx_tx.var.trx_acctd_amount', 'NUMBER');

607: fa_rx_util_pkg.assign_column('230','NVL(CT.TERM_DUE_DATE,ARPT_SQL_FUNC_UTIL.GET_FIRST_REAL_DUE_DATE(CT.CUSTOMER_TRX_ID, CT.TERM_ID, CT.TRX_DATE)) ', 'TRX_DUE_DATE', 'arrx_tx.var.trx_due_date', 'DATE');
608: fa_rx_util_pkg.assign_column('240', null, 'TAX_HEADER_LEVEL_FLAG', 'arrx_tx.var.tax_header_level_flag', 'VARCHAR2', 1);
609: fa_rx_util_pkg.assign_column('250','CT.DOC_SEQUENCE_VALUE', 'DOC_SEQUENCE_VALUE', 'arrx_tx.var.doc_sequence_value', 'NUMBER');
610: fa_rx_util_pkg.assign_column('260','RECDIST.AMOUNT', 'TRX_AMOUNT', 'arrx_tx.var.trx_amount', 'NUMBER');
611: fa_rx_util_pkg.assign_column('270','RECDIST.ACCTD_AMOUNT', 'TRX_ACCTD_AMOUNT', 'arrx_tx.var.trx_acctd_amount', 'NUMBER');
612: fa_rx_util_pkg.assign_column('280','CT.SHIP_TO_CUSTOMER_ID', 'SHIP_TO_CUSTOMER_ID', 'arrx_tx.var.ship_to_customer_id', 'NUMBER', 15);
613: fa_rx_util_pkg.assign_column('290','CT.SHIP_TO_SITE_USE_ID', 'SHIP_TO_SITE_USE_ID', 'arrx_tx.var.ship_to_site_use_id', 'NUMBER', 15);
614: fa_rx_util_pkg.assign_column('300','CT.BILL_TO_CUSTOMER_ID', 'BILL_TO_CUSTOMER_ID', 'arrx_tx.var.bill_to_customer_id', 'NUMBER', 15);
615: fa_rx_util_pkg.assign_column('310','CT.BILL_TO_SITE_USE_ID', 'BILL_TO_SITE_USE_ID', 'arrx_tx.var.bill_to_site_use_id', 'NUMBER', 15);

Line 612: fa_rx_util_pkg.assign_column('280','CT.SHIP_TO_CUSTOMER_ID', 'SHIP_TO_CUSTOMER_ID', 'arrx_tx.var.ship_to_customer_id', 'NUMBER', 15);

608: fa_rx_util_pkg.assign_column('240', null, 'TAX_HEADER_LEVEL_FLAG', 'arrx_tx.var.tax_header_level_flag', 'VARCHAR2', 1);
609: fa_rx_util_pkg.assign_column('250','CT.DOC_SEQUENCE_VALUE', 'DOC_SEQUENCE_VALUE', 'arrx_tx.var.doc_sequence_value', 'NUMBER');
610: fa_rx_util_pkg.assign_column('260','RECDIST.AMOUNT', 'TRX_AMOUNT', 'arrx_tx.var.trx_amount', 'NUMBER');
611: fa_rx_util_pkg.assign_column('270','RECDIST.ACCTD_AMOUNT', 'TRX_ACCTD_AMOUNT', 'arrx_tx.var.trx_acctd_amount', 'NUMBER');
612: fa_rx_util_pkg.assign_column('280','CT.SHIP_TO_CUSTOMER_ID', 'SHIP_TO_CUSTOMER_ID', 'arrx_tx.var.ship_to_customer_id', 'NUMBER', 15);
613: fa_rx_util_pkg.assign_column('290','CT.SHIP_TO_SITE_USE_ID', 'SHIP_TO_SITE_USE_ID', 'arrx_tx.var.ship_to_site_use_id', 'NUMBER', 15);
614: fa_rx_util_pkg.assign_column('300','CT.BILL_TO_CUSTOMER_ID', 'BILL_TO_CUSTOMER_ID', 'arrx_tx.var.bill_to_customer_id', 'NUMBER', 15);
615: fa_rx_util_pkg.assign_column('310','CT.BILL_TO_SITE_USE_ID', 'BILL_TO_SITE_USE_ID', 'arrx_tx.var.bill_to_site_use_id', 'NUMBER', 15);
616: fa_rx_util_pkg.assign_column('320','CT.CUST_TRX_TYPE_ID', 'CUST_TRX_TYPE_ID', 'arrx_tx.var.cust_trx_type_id', 'NUMBER', 15);

Line 613: fa_rx_util_pkg.assign_column('290','CT.SHIP_TO_SITE_USE_ID', 'SHIP_TO_SITE_USE_ID', 'arrx_tx.var.ship_to_site_use_id', 'NUMBER', 15);

609: fa_rx_util_pkg.assign_column('250','CT.DOC_SEQUENCE_VALUE', 'DOC_SEQUENCE_VALUE', 'arrx_tx.var.doc_sequence_value', 'NUMBER');
610: fa_rx_util_pkg.assign_column('260','RECDIST.AMOUNT', 'TRX_AMOUNT', 'arrx_tx.var.trx_amount', 'NUMBER');
611: fa_rx_util_pkg.assign_column('270','RECDIST.ACCTD_AMOUNT', 'TRX_ACCTD_AMOUNT', 'arrx_tx.var.trx_acctd_amount', 'NUMBER');
612: fa_rx_util_pkg.assign_column('280','CT.SHIP_TO_CUSTOMER_ID', 'SHIP_TO_CUSTOMER_ID', 'arrx_tx.var.ship_to_customer_id', 'NUMBER', 15);
613: fa_rx_util_pkg.assign_column('290','CT.SHIP_TO_SITE_USE_ID', 'SHIP_TO_SITE_USE_ID', 'arrx_tx.var.ship_to_site_use_id', 'NUMBER', 15);
614: fa_rx_util_pkg.assign_column('300','CT.BILL_TO_CUSTOMER_ID', 'BILL_TO_CUSTOMER_ID', 'arrx_tx.var.bill_to_customer_id', 'NUMBER', 15);
615: fa_rx_util_pkg.assign_column('310','CT.BILL_TO_SITE_USE_ID', 'BILL_TO_SITE_USE_ID', 'arrx_tx.var.bill_to_site_use_id', 'NUMBER', 15);
616: fa_rx_util_pkg.assign_column('320','CT.CUST_TRX_TYPE_ID', 'CUST_TRX_TYPE_ID', 'arrx_tx.var.cust_trx_type_id', 'NUMBER', 15);
617: fa_rx_util_pkg.assign_column('330','CT.TERM_ID', 'TERM_ID', 'arrx_tx.var.term_id', 'NUMBER', 15);

Line 614: fa_rx_util_pkg.assign_column('300','CT.BILL_TO_CUSTOMER_ID', 'BILL_TO_CUSTOMER_ID', 'arrx_tx.var.bill_to_customer_id', 'NUMBER', 15);

610: fa_rx_util_pkg.assign_column('260','RECDIST.AMOUNT', 'TRX_AMOUNT', 'arrx_tx.var.trx_amount', 'NUMBER');
611: fa_rx_util_pkg.assign_column('270','RECDIST.ACCTD_AMOUNT', 'TRX_ACCTD_AMOUNT', 'arrx_tx.var.trx_acctd_amount', 'NUMBER');
612: fa_rx_util_pkg.assign_column('280','CT.SHIP_TO_CUSTOMER_ID', 'SHIP_TO_CUSTOMER_ID', 'arrx_tx.var.ship_to_customer_id', 'NUMBER', 15);
613: fa_rx_util_pkg.assign_column('290','CT.SHIP_TO_SITE_USE_ID', 'SHIP_TO_SITE_USE_ID', 'arrx_tx.var.ship_to_site_use_id', 'NUMBER', 15);
614: fa_rx_util_pkg.assign_column('300','CT.BILL_TO_CUSTOMER_ID', 'BILL_TO_CUSTOMER_ID', 'arrx_tx.var.bill_to_customer_id', 'NUMBER', 15);
615: fa_rx_util_pkg.assign_column('310','CT.BILL_TO_SITE_USE_ID', 'BILL_TO_SITE_USE_ID', 'arrx_tx.var.bill_to_site_use_id', 'NUMBER', 15);
616: fa_rx_util_pkg.assign_column('320','CT.CUST_TRX_TYPE_ID', 'CUST_TRX_TYPE_ID', 'arrx_tx.var.cust_trx_type_id', 'NUMBER', 15);
617: fa_rx_util_pkg.assign_column('330','CT.TERM_ID', 'TERM_ID', 'arrx_tx.var.term_id', 'NUMBER', 15);
618: fa_rx_util_pkg.assign_column('340','CT.DOC_SEQUENCE_ID', 'DOC_SEQUENCE_ID', 'arrx_tx.var.doc_sequence_id', 'NUMBER', 15);

Line 615: fa_rx_util_pkg.assign_column('310','CT.BILL_TO_SITE_USE_ID', 'BILL_TO_SITE_USE_ID', 'arrx_tx.var.bill_to_site_use_id', 'NUMBER', 15);

611: fa_rx_util_pkg.assign_column('270','RECDIST.ACCTD_AMOUNT', 'TRX_ACCTD_AMOUNT', 'arrx_tx.var.trx_acctd_amount', 'NUMBER');
612: fa_rx_util_pkg.assign_column('280','CT.SHIP_TO_CUSTOMER_ID', 'SHIP_TO_CUSTOMER_ID', 'arrx_tx.var.ship_to_customer_id', 'NUMBER', 15);
613: fa_rx_util_pkg.assign_column('290','CT.SHIP_TO_SITE_USE_ID', 'SHIP_TO_SITE_USE_ID', 'arrx_tx.var.ship_to_site_use_id', 'NUMBER', 15);
614: fa_rx_util_pkg.assign_column('300','CT.BILL_TO_CUSTOMER_ID', 'BILL_TO_CUSTOMER_ID', 'arrx_tx.var.bill_to_customer_id', 'NUMBER', 15);
615: fa_rx_util_pkg.assign_column('310','CT.BILL_TO_SITE_USE_ID', 'BILL_TO_SITE_USE_ID', 'arrx_tx.var.bill_to_site_use_id', 'NUMBER', 15);
616: fa_rx_util_pkg.assign_column('320','CT.CUST_TRX_TYPE_ID', 'CUST_TRX_TYPE_ID', 'arrx_tx.var.cust_trx_type_id', 'NUMBER', 15);
617: fa_rx_util_pkg.assign_column('330','CT.TERM_ID', 'TERM_ID', 'arrx_tx.var.term_id', 'NUMBER', 15);
618: fa_rx_util_pkg.assign_column('340','CT.DOC_SEQUENCE_ID', 'DOC_SEQUENCE_ID', 'arrx_tx.var.doc_sequence_id', 'NUMBER', 15);
619: fa_rx_util_pkg.assign_column('350','CT.RECEIPT_METHOD_ID', 'RECEIPT_METHOD_ID', 'arrx_tx.var.receipt_method_id', 'NUMBER', 15);

Line 616: fa_rx_util_pkg.assign_column('320','CT.CUST_TRX_TYPE_ID', 'CUST_TRX_TYPE_ID', 'arrx_tx.var.cust_trx_type_id', 'NUMBER', 15);

612: fa_rx_util_pkg.assign_column('280','CT.SHIP_TO_CUSTOMER_ID', 'SHIP_TO_CUSTOMER_ID', 'arrx_tx.var.ship_to_customer_id', 'NUMBER', 15);
613: fa_rx_util_pkg.assign_column('290','CT.SHIP_TO_SITE_USE_ID', 'SHIP_TO_SITE_USE_ID', 'arrx_tx.var.ship_to_site_use_id', 'NUMBER', 15);
614: fa_rx_util_pkg.assign_column('300','CT.BILL_TO_CUSTOMER_ID', 'BILL_TO_CUSTOMER_ID', 'arrx_tx.var.bill_to_customer_id', 'NUMBER', 15);
615: fa_rx_util_pkg.assign_column('310','CT.BILL_TO_SITE_USE_ID', 'BILL_TO_SITE_USE_ID', 'arrx_tx.var.bill_to_site_use_id', 'NUMBER', 15);
616: fa_rx_util_pkg.assign_column('320','CT.CUST_TRX_TYPE_ID', 'CUST_TRX_TYPE_ID', 'arrx_tx.var.cust_trx_type_id', 'NUMBER', 15);
617: fa_rx_util_pkg.assign_column('330','CT.TERM_ID', 'TERM_ID', 'arrx_tx.var.term_id', 'NUMBER', 15);
618: fa_rx_util_pkg.assign_column('340','CT.DOC_SEQUENCE_ID', 'DOC_SEQUENCE_ID', 'arrx_tx.var.doc_sequence_id', 'NUMBER', 15);
619: fa_rx_util_pkg.assign_column('350','CT.RECEIPT_METHOD_ID', 'RECEIPT_METHOD_ID', 'arrx_tx.var.receipt_method_id', 'NUMBER', 15);
620: fa_rx_util_pkg.assign_column('360','CT.ORG_ID', 'ORG_ID', 'arrx_tx.var.org_id', 'NUMBER', 15);

Line 617: fa_rx_util_pkg.assign_column('330','CT.TERM_ID', 'TERM_ID', 'arrx_tx.var.term_id', 'NUMBER', 15);

613: fa_rx_util_pkg.assign_column('290','CT.SHIP_TO_SITE_USE_ID', 'SHIP_TO_SITE_USE_ID', 'arrx_tx.var.ship_to_site_use_id', 'NUMBER', 15);
614: fa_rx_util_pkg.assign_column('300','CT.BILL_TO_CUSTOMER_ID', 'BILL_TO_CUSTOMER_ID', 'arrx_tx.var.bill_to_customer_id', 'NUMBER', 15);
615: fa_rx_util_pkg.assign_column('310','CT.BILL_TO_SITE_USE_ID', 'BILL_TO_SITE_USE_ID', 'arrx_tx.var.bill_to_site_use_id', 'NUMBER', 15);
616: fa_rx_util_pkg.assign_column('320','CT.CUST_TRX_TYPE_ID', 'CUST_TRX_TYPE_ID', 'arrx_tx.var.cust_trx_type_id', 'NUMBER', 15);
617: fa_rx_util_pkg.assign_column('330','CT.TERM_ID', 'TERM_ID', 'arrx_tx.var.term_id', 'NUMBER', 15);
618: fa_rx_util_pkg.assign_column('340','CT.DOC_SEQUENCE_ID', 'DOC_SEQUENCE_ID', 'arrx_tx.var.doc_sequence_id', 'NUMBER', 15);
619: fa_rx_util_pkg.assign_column('350','CT.RECEIPT_METHOD_ID', 'RECEIPT_METHOD_ID', 'arrx_tx.var.receipt_method_id', 'NUMBER', 15);
620: fa_rx_util_pkg.assign_column('360','CT.ORG_ID', 'ORG_ID', 'arrx_tx.var.org_id', 'NUMBER', 15);
621: -- bug3940958 added batch_id and batch_source_id

Line 618: fa_rx_util_pkg.assign_column('340','CT.DOC_SEQUENCE_ID', 'DOC_SEQUENCE_ID', 'arrx_tx.var.doc_sequence_id', 'NUMBER', 15);

614: fa_rx_util_pkg.assign_column('300','CT.BILL_TO_CUSTOMER_ID', 'BILL_TO_CUSTOMER_ID', 'arrx_tx.var.bill_to_customer_id', 'NUMBER', 15);
615: fa_rx_util_pkg.assign_column('310','CT.BILL_TO_SITE_USE_ID', 'BILL_TO_SITE_USE_ID', 'arrx_tx.var.bill_to_site_use_id', 'NUMBER', 15);
616: fa_rx_util_pkg.assign_column('320','CT.CUST_TRX_TYPE_ID', 'CUST_TRX_TYPE_ID', 'arrx_tx.var.cust_trx_type_id', 'NUMBER', 15);
617: fa_rx_util_pkg.assign_column('330','CT.TERM_ID', 'TERM_ID', 'arrx_tx.var.term_id', 'NUMBER', 15);
618: fa_rx_util_pkg.assign_column('340','CT.DOC_SEQUENCE_ID', 'DOC_SEQUENCE_ID', 'arrx_tx.var.doc_sequence_id', 'NUMBER', 15);
619: fa_rx_util_pkg.assign_column('350','CT.RECEIPT_METHOD_ID', 'RECEIPT_METHOD_ID', 'arrx_tx.var.receipt_method_id', 'NUMBER', 15);
620: fa_rx_util_pkg.assign_column('360','CT.ORG_ID', 'ORG_ID', 'arrx_tx.var.org_id', 'NUMBER', 15);
621: -- bug3940958 added batch_id and batch_source_id
622: fa_rx_util_pkg.assign_column('370','CT.BATCH_ID', 'BATCH_ID', 'arrx_tx.var.batch_id', 'NUMBER', 15);

Line 619: fa_rx_util_pkg.assign_column('350','CT.RECEIPT_METHOD_ID', 'RECEIPT_METHOD_ID', 'arrx_tx.var.receipt_method_id', 'NUMBER', 15);

615: fa_rx_util_pkg.assign_column('310','CT.BILL_TO_SITE_USE_ID', 'BILL_TO_SITE_USE_ID', 'arrx_tx.var.bill_to_site_use_id', 'NUMBER', 15);
616: fa_rx_util_pkg.assign_column('320','CT.CUST_TRX_TYPE_ID', 'CUST_TRX_TYPE_ID', 'arrx_tx.var.cust_trx_type_id', 'NUMBER', 15);
617: fa_rx_util_pkg.assign_column('330','CT.TERM_ID', 'TERM_ID', 'arrx_tx.var.term_id', 'NUMBER', 15);
618: fa_rx_util_pkg.assign_column('340','CT.DOC_SEQUENCE_ID', 'DOC_SEQUENCE_ID', 'arrx_tx.var.doc_sequence_id', 'NUMBER', 15);
619: fa_rx_util_pkg.assign_column('350','CT.RECEIPT_METHOD_ID', 'RECEIPT_METHOD_ID', 'arrx_tx.var.receipt_method_id', 'NUMBER', 15);
620: fa_rx_util_pkg.assign_column('360','CT.ORG_ID', 'ORG_ID', 'arrx_tx.var.org_id', 'NUMBER', 15);
621: -- bug3940958 added batch_id and batch_source_id
622: fa_rx_util_pkg.assign_column('370','CT.BATCH_ID', 'BATCH_ID', 'arrx_tx.var.batch_id', 'NUMBER', 15);
623: fa_rx_util_pkg.assign_column('380','CT.BATCH_SOURCE_ID', 'BATCH_SOURCE_ID', 'arrx_tx.var.batch_source_id', 'NUMBER', 15);

Line 620: fa_rx_util_pkg.assign_column('360','CT.ORG_ID', 'ORG_ID', 'arrx_tx.var.org_id', 'NUMBER', 15);

616: fa_rx_util_pkg.assign_column('320','CT.CUST_TRX_TYPE_ID', 'CUST_TRX_TYPE_ID', 'arrx_tx.var.cust_trx_type_id', 'NUMBER', 15);
617: fa_rx_util_pkg.assign_column('330','CT.TERM_ID', 'TERM_ID', 'arrx_tx.var.term_id', 'NUMBER', 15);
618: fa_rx_util_pkg.assign_column('340','CT.DOC_SEQUENCE_ID', 'DOC_SEQUENCE_ID', 'arrx_tx.var.doc_sequence_id', 'NUMBER', 15);
619: fa_rx_util_pkg.assign_column('350','CT.RECEIPT_METHOD_ID', 'RECEIPT_METHOD_ID', 'arrx_tx.var.receipt_method_id', 'NUMBER', 15);
620: fa_rx_util_pkg.assign_column('360','CT.ORG_ID', 'ORG_ID', 'arrx_tx.var.org_id', 'NUMBER', 15);
621: -- bug3940958 added batch_id and batch_source_id
622: fa_rx_util_pkg.assign_column('370','CT.BATCH_ID', 'BATCH_ID', 'arrx_tx.var.batch_id', 'NUMBER', 15);
623: fa_rx_util_pkg.assign_column('380','CT.BATCH_SOURCE_ID', 'BATCH_SOURCE_ID', 'arrx_tx.var.batch_source_id', 'NUMBER', 15);
624: -->>SELECT_END<<--

Line 622: fa_rx_util_pkg.assign_column('370','CT.BATCH_ID', 'BATCH_ID', 'arrx_tx.var.batch_id', 'NUMBER', 15);

618: fa_rx_util_pkg.assign_column('340','CT.DOC_SEQUENCE_ID', 'DOC_SEQUENCE_ID', 'arrx_tx.var.doc_sequence_id', 'NUMBER', 15);
619: fa_rx_util_pkg.assign_column('350','CT.RECEIPT_METHOD_ID', 'RECEIPT_METHOD_ID', 'arrx_tx.var.receipt_method_id', 'NUMBER', 15);
620: fa_rx_util_pkg.assign_column('360','CT.ORG_ID', 'ORG_ID', 'arrx_tx.var.org_id', 'NUMBER', 15);
621: -- bug3940958 added batch_id and batch_source_id
622: fa_rx_util_pkg.assign_column('370','CT.BATCH_ID', 'BATCH_ID', 'arrx_tx.var.batch_id', 'NUMBER', 15);
623: fa_rx_util_pkg.assign_column('380','CT.BATCH_SOURCE_ID', 'BATCH_SOURCE_ID', 'arrx_tx.var.batch_source_id', 'NUMBER', 15);
624: -->>SELECT_END<<--
625:
626:

Line 623: fa_rx_util_pkg.assign_column('380','CT.BATCH_SOURCE_ID', 'BATCH_SOURCE_ID', 'arrx_tx.var.batch_source_id', 'NUMBER', 15);

619: fa_rx_util_pkg.assign_column('350','CT.RECEIPT_METHOD_ID', 'RECEIPT_METHOD_ID', 'arrx_tx.var.receipt_method_id', 'NUMBER', 15);
620: fa_rx_util_pkg.assign_column('360','CT.ORG_ID', 'ORG_ID', 'arrx_tx.var.org_id', 'NUMBER', 15);
621: -- bug3940958 added batch_id and batch_source_id
622: fa_rx_util_pkg.assign_column('370','CT.BATCH_ID', 'BATCH_ID', 'arrx_tx.var.batch_id', 'NUMBER', 15);
623: fa_rx_util_pkg.assign_column('380','CT.BATCH_SOURCE_ID', 'BATCH_SOURCE_ID', 'arrx_tx.var.batch_source_id', 'NUMBER', 15);
624: -->>SELECT_END<<--
625:
626:
627: --

Line 695: fa_rx_util_pkg.debug('arrx_tx.before_report()-');

691: L_BILL_TO_ORG_WHERE || ' ' ||
692: BATCH_SOURCE_WHERE || ' ' ||
693: REC_ACCOUNT_WHERE ;
694:
695: fa_rx_util_pkg.debug('arrx_tx.before_report()-');
696:
697: end before_report;
698:
699:

Line 896: fa_rx_util_pkg.debug('arrx_tx.artx_rep_check()+');

892: -- Customer Number parameter declarations
893: start_bill_to_customer_number varchar2(30) := NULL;
894: end_bill_to_customer_number varchar2(30) := NULL;
895: begin
896: fa_rx_util_pkg.debug('arrx_tx.artx_rep_check()+');
897:
898: --
899: -- Assign parameters to global variable
900: -- These values will be used within the before_report trigger

Line 912: fa_rx_util_pkg.init_request('arrx_tx.artx_rep_check',request_id,'AR_TRANSACTIONS_REP_ITF');

908: fa_rx_util_pkg.debug('last_updated_by = '|| var.last_updated_by);
909:
910: --
911: -- Initialize request
912: fa_rx_util_pkg.init_request('arrx_tx.artx_rep_check',request_id,'AR_TRANSACTIONS_REP_ITF');
913:
914: --
915: -- Call the main journal report
916:

Line 918: arrx_tx.artx_rep(

914: --
915: -- Call the main journal report
916:
917: -- bug3940958 added some parameters
918: arrx_tx.artx_rep(
919: completed_flag,
920: posted_flag,
921: start_gl_date,
922: end_gl_date,

Line 957: 'arrx_tx.check_before_report;',

953: -- Assign triggers specific to this report
954: -- Make sure that you make your assignment to the correct section ('AR TRANSACTION')
955: fa_rx_util_pkg.assign_report('AR TRANSACTIONS',
956: true,
957: 'arrx_tx.check_before_report;',
958: 'arrx_tx.check_bind(:CURSOR_SELECT);',
959: 'arrx_tx.check_after_fetch;',
960: null);
961:

Line 958: 'arrx_tx.check_bind(:CURSOR_SELECT);',

954: -- Make sure that you make your assignment to the correct section ('AR TRANSACTION')
955: fa_rx_util_pkg.assign_report('AR TRANSACTIONS',
956: true,
957: 'arrx_tx.check_before_report;',
958: 'arrx_tx.check_bind(:CURSOR_SELECT);',
959: 'arrx_tx.check_after_fetch;',
960: null);
961:
962: --

Line 959: 'arrx_tx.check_after_fetch;',

955: fa_rx_util_pkg.assign_report('AR TRANSACTIONS',
956: true,
957: 'arrx_tx.check_before_report;',
958: 'arrx_tx.check_bind(:CURSOR_SELECT);',
959: 'arrx_tx.check_after_fetch;',
960: null);
961:
962: --
963: -- Run the report.

Line 964: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_tx.artx_rep_check')

960: null);
961:
962: --
963: -- Run the report.
964: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_tx.artx_rep_check')
965: fa_rx_util_pkg.run_report('arrx_tx.artx_rep_check', retcode, errbuf);
966:
967: fa_rx_util_pkg.debug('arrx_tx.artx_rep_check()-');
968:

Line 965: fa_rx_util_pkg.run_report('arrx_tx.artx_rep_check', retcode, errbuf);

961:
962: --
963: -- Run the report.
964: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_tx.artx_rep_check')
965: fa_rx_util_pkg.run_report('arrx_tx.artx_rep_check', retcode, errbuf);
966:
967: fa_rx_util_pkg.debug('arrx_tx.artx_rep_check()-');
968:
969: exception

Line 967: fa_rx_util_pkg.debug('arrx_tx.artx_rep_check()-');

963: -- Run the report.
964: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_tx.artx_rep_check')
965: fa_rx_util_pkg.run_report('arrx_tx.artx_rep_check', retcode, errbuf);
966:
967: fa_rx_util_pkg.debug('arrx_tx.artx_rep_check()-');
968:
969: exception
970: when others then
971: fa_rx_util_pkg.log(sqlcode);

Line 975: fa_rx_util_pkg.debug('arrx_tx.artx_rep_check(EXCEPTION)-');

971: fa_rx_util_pkg.log(sqlcode);
972: fa_rx_util_pkg.log(sqlerrm);
973: fa_rx_util_pkg.debug(sqlcode);
974: fa_rx_util_pkg.debug(sqlerrm);
975: fa_rx_util_pkg.debug('arrx_tx.artx_rep_check(EXCEPTION)-');
976: end artx_rep_check;
977:
978:
979: --

Line 991: fa_rx_util_pkg.debug('arrx_tx.check_before_report()+');

987: decode_inv varchar2(500);
988: get_item varchar2(500);
989: LAST_UPDATE_WHERE varchar2(500);
990: begin
991: fa_rx_util_pkg.debug('arrx_tx.check_before_report()+');
992:
993: fa_rx_util_pkg.debug('GL_GET_PROFILE_SO_FLEX_CODE');
994:
995: oe_profile.get(

Line 1049: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');

1045: --
1046: -- Assign another column specific to this report
1047: fa_rx_util_pkg.debug('AR_ADD_SELECT_COLUMNS');
1048:
1049: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');
1050: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1051: fa_rx_util_pkg.assign_column('c3 ','CTL.LINK_TO_CUST_TRX_LINE_ID', 'LINK_TO_CUST_TRX_LINE_ID', 'arrx_tx.var.link_to_cust_trx_line_id', 'NUMBER');
1052: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1053: fa_rx_util_pkg.assign_column('c5 ','DIST.CUST_TRX_LINE_GL_DIST_ID', 'CUST_TRX_LINE_GL_DIST_ID', 'arrx_tx.var.cust_trx_line_gl_dist_id', 'NUMBER');

Line 1050: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');

1046: -- Assign another column specific to this report
1047: fa_rx_util_pkg.debug('AR_ADD_SELECT_COLUMNS');
1048:
1049: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');
1050: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1051: fa_rx_util_pkg.assign_column('c3 ','CTL.LINK_TO_CUST_TRX_LINE_ID', 'LINK_TO_CUST_TRX_LINE_ID', 'arrx_tx.var.link_to_cust_trx_line_id', 'NUMBER');
1052: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1053: fa_rx_util_pkg.assign_column('c5 ','DIST.CUST_TRX_LINE_GL_DIST_ID', 'CUST_TRX_LINE_GL_DIST_ID', 'arrx_tx.var.cust_trx_line_gl_dist_id', 'NUMBER');
1054: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);

Line 1051: fa_rx_util_pkg.assign_column('c3 ','CTL.LINK_TO_CUST_TRX_LINE_ID', 'LINK_TO_CUST_TRX_LINE_ID', 'arrx_tx.var.link_to_cust_trx_line_id', 'NUMBER');

1047: fa_rx_util_pkg.debug('AR_ADD_SELECT_COLUMNS');
1048:
1049: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');
1050: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1051: fa_rx_util_pkg.assign_column('c3 ','CTL.LINK_TO_CUST_TRX_LINE_ID', 'LINK_TO_CUST_TRX_LINE_ID', 'arrx_tx.var.link_to_cust_trx_line_id', 'NUMBER');
1052: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1053: fa_rx_util_pkg.assign_column('c5 ','DIST.CUST_TRX_LINE_GL_DIST_ID', 'CUST_TRX_LINE_GL_DIST_ID', 'arrx_tx.var.cust_trx_line_gl_dist_id', 'NUMBER');
1054: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1055: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);

Line 1052: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);

1048:
1049: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');
1050: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1051: fa_rx_util_pkg.assign_column('c3 ','CTL.LINK_TO_CUST_TRX_LINE_ID', 'LINK_TO_CUST_TRX_LINE_ID', 'arrx_tx.var.link_to_cust_trx_line_id', 'NUMBER');
1052: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1053: fa_rx_util_pkg.assign_column('c5 ','DIST.CUST_TRX_LINE_GL_DIST_ID', 'CUST_TRX_LINE_GL_DIST_ID', 'arrx_tx.var.cust_trx_line_gl_dist_id', 'NUMBER');
1054: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1055: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1056: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);

Line 1053: fa_rx_util_pkg.assign_column('c5 ','DIST.CUST_TRX_LINE_GL_DIST_ID', 'CUST_TRX_LINE_GL_DIST_ID', 'arrx_tx.var.cust_trx_line_gl_dist_id', 'NUMBER');

1049: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');
1050: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1051: fa_rx_util_pkg.assign_column('c3 ','CTL.LINK_TO_CUST_TRX_LINE_ID', 'LINK_TO_CUST_TRX_LINE_ID', 'arrx_tx.var.link_to_cust_trx_line_id', 'NUMBER');
1052: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1053: fa_rx_util_pkg.assign_column('c5 ','DIST.CUST_TRX_LINE_GL_DIST_ID', 'CUST_TRX_LINE_GL_DIST_ID', 'arrx_tx.var.cust_trx_line_gl_dist_id', 'NUMBER');
1054: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1055: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1056: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1057: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);

Line 1054: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);

1050: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1051: fa_rx_util_pkg.assign_column('c3 ','CTL.LINK_TO_CUST_TRX_LINE_ID', 'LINK_TO_CUST_TRX_LINE_ID', 'arrx_tx.var.link_to_cust_trx_line_id', 'NUMBER');
1052: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1053: fa_rx_util_pkg.assign_column('c5 ','DIST.CUST_TRX_LINE_GL_DIST_ID', 'CUST_TRX_LINE_GL_DIST_ID', 'arrx_tx.var.cust_trx_line_gl_dist_id', 'NUMBER');
1054: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1055: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1056: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1057: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1058: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);

Line 1055: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);

1051: fa_rx_util_pkg.assign_column('c3 ','CTL.LINK_TO_CUST_TRX_LINE_ID', 'LINK_TO_CUST_TRX_LINE_ID', 'arrx_tx.var.link_to_cust_trx_line_id', 'NUMBER');
1052: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1053: fa_rx_util_pkg.assign_column('c5 ','DIST.CUST_TRX_LINE_GL_DIST_ID', 'CUST_TRX_LINE_GL_DIST_ID', 'arrx_tx.var.cust_trx_line_gl_dist_id', 'NUMBER');
1054: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1055: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1056: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1057: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1058: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);
1059: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);

Line 1056: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);

1052: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1053: fa_rx_util_pkg.assign_column('c5 ','DIST.CUST_TRX_LINE_GL_DIST_ID', 'CUST_TRX_LINE_GL_DIST_ID', 'arrx_tx.var.cust_trx_line_gl_dist_id', 'NUMBER');
1054: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1055: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1056: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1057: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1058: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);
1059: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);
1060:

Line 1057: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);

1053: fa_rx_util_pkg.assign_column('c5 ','DIST.CUST_TRX_LINE_GL_DIST_ID', 'CUST_TRX_LINE_GL_DIST_ID', 'arrx_tx.var.cust_trx_line_gl_dist_id', 'NUMBER');
1054: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1055: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1056: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1057: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1058: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);
1059: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);
1060:
1061: --

Line 1058: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);

1054: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1055: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1056: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1057: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1058: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);
1059: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);
1060:
1061: --
1062: -- Add to the FROM clause specific to this report

Line 1059: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);

1055: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1056: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1057: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1058: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);
1059: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);
1060:
1061: --
1062: -- Add to the FROM clause specific to this report
1063: fa_rx_util_pkg.debug('AR_ADD_FORM_CLAUSE');

Line 1077: LAST_UPDATE_WHERE := ' AND ARRX_TX.WHERE_LAST_UPDATE(CT.CUSTOMER_TRX_ID,null,

1073: -- Add to the WHERE clause specific to this report
1074: fa_rx_util_pkg.debug('AR_ADD_WHERE_CLAUSE');
1075:
1076: IF var.last_updated_by is null THEN
1077: LAST_UPDATE_WHERE := ' AND ARRX_TX.WHERE_LAST_UPDATE(CT.CUSTOMER_TRX_ID,null,
1078: :start_update_date,:end_update_date) = ''Y'' ';
1079: ELSE
1080: LAST_UPDATE_WHERE := ' AND ARRX_TX.WHERE_LAST_UPDATE(CT.CUSTOMER_TRX_ID,'|| var.last_updated_by ||',
1081: :start_update_date,:end_update_date) = ''Y'' ';

Line 1080: LAST_UPDATE_WHERE := ' AND ARRX_TX.WHERE_LAST_UPDATE(CT.CUSTOMER_TRX_ID,'|| var.last_updated_by ||',

1076: IF var.last_updated_by is null THEN
1077: LAST_UPDATE_WHERE := ' AND ARRX_TX.WHERE_LAST_UPDATE(CT.CUSTOMER_TRX_ID,null,
1078: :start_update_date,:end_update_date) = ''Y'' ';
1079: ELSE
1080: LAST_UPDATE_WHERE := ' AND ARRX_TX.WHERE_LAST_UPDATE(CT.CUSTOMER_TRX_ID,'|| var.last_updated_by ||',
1081: :start_update_date,:end_update_date) = ''Y'' ';
1082: END IF;
1083:
1084: fa_rx_util_pkg.Where_Clause :=

Line 1096: fa_rx_util_pkg.debug('arrx_tx.check_before_report()-');

1092: AND DIST.ACCOUNT_SET_FLAG = ''N''
1093: AND DIST.CODE_COMBINATION_ID = CCDIST.CODE_COMBINATION_ID '||
1094: LAST_UPDATE_WHERE;
1095:
1096: fa_rx_util_pkg.debug('arrx_tx.check_before_report()-');
1097:
1098: end check_before_report;
1099:
1100:

Line 1209: fa_rx_util_pkg.debug('arrx_tx.artx_rep_forecast()+');

1205: start_bill_to_customer_number varchar2(30) := NULL;
1206: end_bill_to_customer_number varchar2(30) := NULL;
1207:
1208: begin
1209: fa_rx_util_pkg.debug('arrx_tx.artx_rep_forecast()+');
1210:
1211: --
1212: -- Assign parameters to global variable
1213: -- These values will be used within the before_report trigger

Line 1223: fa_rx_util_pkg.init_request('arrx_tx.artx_rep_forecast',request_id,'AR_TRANSACTIONS_REP_ITF');

1219: fa_rx_util_pkg.debug('end_due_date = '|| var.end_due_date);
1220:
1221: --
1222: -- Initialize request
1223: fa_rx_util_pkg.init_request('arrx_tx.artx_rep_forecast',request_id,'AR_TRANSACTIONS_REP_ITF');
1224:
1225: --
1226: -- Call the main journal report
1227:

Line 1229: arrx_tx.artx_rep(

1225: --
1226: -- Call the main journal report
1227:
1228: -- bug3940958 added some parameters
1229: arrx_tx.artx_rep(
1230: completed_flag,
1231: posted_flag,
1232: start_gl_date,
1233: end_gl_date,

Line 1267: 'arrx_tx.forecast_before_report;',

1263: -- Assign triggers specific to this report
1264: -- Make sure that you make your assignment to the correct section ('AR TRANSACTION')
1265: fa_rx_util_pkg.assign_report('AR TRANSACTIONS',
1266: true,
1267: 'arrx_tx.forecast_before_report;',
1268: 'arrx_tx.forecast_bind(:CURSOR_SELECT);',
1269: null,
1270: null);
1271:

Line 1268: 'arrx_tx.forecast_bind(:CURSOR_SELECT);',

1264: -- Make sure that you make your assignment to the correct section ('AR TRANSACTION')
1265: fa_rx_util_pkg.assign_report('AR TRANSACTIONS',
1266: true,
1267: 'arrx_tx.forecast_before_report;',
1268: 'arrx_tx.forecast_bind(:CURSOR_SELECT);',
1269: null,
1270: null);
1271:
1272: --

Line 1274: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_tx.artx_rep_forecast')

1270: null);
1271:
1272: --
1273: -- Run the report.
1274: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_tx.artx_rep_forecast')
1275: fa_rx_util_pkg.run_report('arrx_tx.artx_rep_forecast', retcode, errbuf);
1276:
1277: fa_rx_util_pkg.debug('arrx_tx.artx_rep_forecast()-');
1278:

Line 1275: fa_rx_util_pkg.run_report('arrx_tx.artx_rep_forecast', retcode, errbuf);

1271:
1272: --
1273: -- Run the report.
1274: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_tx.artx_rep_forecast')
1275: fa_rx_util_pkg.run_report('arrx_tx.artx_rep_forecast', retcode, errbuf);
1276:
1277: fa_rx_util_pkg.debug('arrx_tx.artx_rep_forecast()-');
1278:
1279: exception

Line 1277: fa_rx_util_pkg.debug('arrx_tx.artx_rep_forecast()-');

1273: -- Run the report.
1274: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_tx.artx_rep_forecast')
1275: fa_rx_util_pkg.run_report('arrx_tx.artx_rep_forecast', retcode, errbuf);
1276:
1277: fa_rx_util_pkg.debug('arrx_tx.artx_rep_forecast()-');
1278:
1279: exception
1280: when others then
1281: fa_rx_util_pkg.log(sqlcode);

Line 1285: fa_rx_util_pkg.debug('arrx_tx.artx_rep_forecast(EXCEPTION)-');

1281: fa_rx_util_pkg.log(sqlcode);
1282: fa_rx_util_pkg.log(sqlerrm);
1283: fa_rx_util_pkg.debug(sqlcode);
1284: fa_rx_util_pkg.debug(sqlerrm);
1285: fa_rx_util_pkg.debug('arrx_tx.artx_rep_forecast(EXCEPTION)-');
1286: end artx_rep_forecast;
1287:
1288: --
1289: -- This is the before report trigger for the artx_rep_forecast report.

Line 1294: fa_rx_util_pkg.debug('arrx_tx.forecast_before_report()+');

1290: procedure forecast_before_report
1291: is
1292: SCHEDULE_DUE_DATE_WHERE varchar2(500);
1293: begin
1294: fa_rx_util_pkg.debug('arrx_tx.forecast_before_report()+');
1295:
1296: --
1297: -- Assign another column specific to this report
1298: fa_rx_util_pkg.debug('AR_ADD_SELECT_COLUMNS');

Line 1300: fa_rx_util_pkg.assign_column('f1 ','PS.PAYMENT_SCHEDULE_ID', 'TRX_PAYMENT_SCHEDULE_ID', 'arrx_tx.var.trx_payment_schedule_id', 'NUMBER');

1296: --
1297: -- Assign another column specific to this report
1298: fa_rx_util_pkg.debug('AR_ADD_SELECT_COLUMNS');
1299:
1300: fa_rx_util_pkg.assign_column('f1 ','PS.PAYMENT_SCHEDULE_ID', 'TRX_PAYMENT_SCHEDULE_ID', 'arrx_tx.var.trx_payment_schedule_id', 'NUMBER');
1301: fa_rx_util_pkg.assign_column('60 ','CONS_INV.CONS_BILLING_NUMBER', 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);
1302:
1303: --
1304: -- Add to the FROM clause specific to this report

Line 1301: fa_rx_util_pkg.assign_column('60 ','CONS_INV.CONS_BILLING_NUMBER', 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);

1297: -- Assign another column specific to this report
1298: fa_rx_util_pkg.debug('AR_ADD_SELECT_COLUMNS');
1299:
1300: fa_rx_util_pkg.assign_column('f1 ','PS.PAYMENT_SCHEDULE_ID', 'TRX_PAYMENT_SCHEDULE_ID', 'arrx_tx.var.trx_payment_schedule_id', 'NUMBER');
1301: fa_rx_util_pkg.assign_column('60 ','CONS_INV.CONS_BILLING_NUMBER', 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);
1302:
1303: --
1304: -- Add to the FROM clause specific to this report
1305: fa_rx_util_pkg.debug('AR_ADD_FORM_CLAUSE');

Line 1332: fa_rx_util_pkg.debug('arrx_tx.forecast_before_report()-');

1328: AND PS.STATUS = ''OP''
1329: AND PS.CONS_INV_ID = CONS_INV.CONS_INV_ID(+) '||
1330: SCHEDULE_DUE_DATE_WHERE;
1331:
1332: fa_rx_util_pkg.debug('arrx_tx.forecast_before_report()-');
1333:
1334: end forecast_before_report;
1335:
1336:

Line 1398: fa_rx_util_pkg.debug('arrx_tx.artx_sales_rep()+');

1394: end_transaction_class varchar2(20) := NULL;
1395: payment_method varchar2(30) := NULL;
1396:
1397: begin
1398: fa_rx_util_pkg.debug('arrx_tx.artx_sales_rep()+');
1399: --
1400: -- Set global variables (This variable will be used in before report trigger.)
1401: --
1402: var.line_invoice := line_invoice;

Line 1414: fa_rx_util_pkg.init_request('arrx_tx.artx_sales_rep',request_id,'AR_TRANSACTIONS_REP_ITF');

1410: var.end_amount := end_amount;
1411:
1412: --
1413: -- Initialize request
1414: fa_rx_util_pkg.init_request('arrx_tx.artx_sales_rep',request_id,'AR_TRANSACTIONS_REP_ITF');
1415:
1416: --
1417: -- Call the main journal report
1418:

Line 1420: arrx_tx.artx_rep(

1416: --
1417: -- Call the main journal report
1418:
1419: -- bug3940958 added new parameters
1420: arrx_tx.artx_rep(
1421: completed_flag,
1422: posted_flag,
1423: start_gl_date,
1424: end_gl_date,

Line 1458: 'arrx_tx.sales_before_report;',

1454: -- Assign triggers specific to this report
1455: -- Make sure that you make your assignment to the correct section ('AR TRANSACTION')
1456: fa_rx_util_pkg.assign_report('AR TRANSACTIONS',
1457: true,
1458: 'arrx_tx.sales_before_report;',
1459: 'arrx_tx.sales_bind(:CURSOR_SELECT);',
1460: 'arrx_tx.sales_after_fetch;',
1461: null);
1462:

Line 1459: 'arrx_tx.sales_bind(:CURSOR_SELECT);',

1455: -- Make sure that you make your assignment to the correct section ('AR TRANSACTION')
1456: fa_rx_util_pkg.assign_report('AR TRANSACTIONS',
1457: true,
1458: 'arrx_tx.sales_before_report;',
1459: 'arrx_tx.sales_bind(:CURSOR_SELECT);',
1460: 'arrx_tx.sales_after_fetch;',
1461: null);
1462:
1463: --

Line 1460: 'arrx_tx.sales_after_fetch;',

1456: fa_rx_util_pkg.assign_report('AR TRANSACTIONS',
1457: true,
1458: 'arrx_tx.sales_before_report;',
1459: 'arrx_tx.sales_bind(:CURSOR_SELECT);',
1460: 'arrx_tx.sales_after_fetch;',
1461: null);
1462:
1463: --
1464: -- Run the report.

Line 1465: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_tx.artx_sales_rep')

1461: null);
1462:
1463: --
1464: -- Run the report.
1465: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_tx.artx_sales_rep')
1466: fa_rx_util_pkg.run_report('arrx_tx.artx_sales_rep', retcode, errbuf);
1467:
1468: fa_rx_util_pkg.debug('arrx_tx.artx_sales_rep()-');
1469:

Line 1466: fa_rx_util_pkg.run_report('arrx_tx.artx_sales_rep', retcode, errbuf);

1462:
1463: --
1464: -- Run the report.
1465: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_tx.artx_sales_rep')
1466: fa_rx_util_pkg.run_report('arrx_tx.artx_sales_rep', retcode, errbuf);
1467:
1468: fa_rx_util_pkg.debug('arrx_tx.artx_sales_rep()-');
1469:
1470: exception

Line 1468: fa_rx_util_pkg.debug('arrx_tx.artx_sales_rep()-');

1464: -- Run the report.
1465: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_tx.artx_sales_rep')
1466: fa_rx_util_pkg.run_report('arrx_tx.artx_sales_rep', retcode, errbuf);
1467:
1468: fa_rx_util_pkg.debug('arrx_tx.artx_sales_rep()-');
1469:
1470: exception
1471: when others then
1472: fa_rx_util_pkg.log(sqlcode);

Line 1476: fa_rx_util_pkg.debug('arrx_tx.artx_sales_rep(EXCEPTION)-');

1472: fa_rx_util_pkg.log(sqlcode);
1473: fa_rx_util_pkg.log(sqlerrm);
1474: fa_rx_util_pkg.debug(sqlcode);
1475: fa_rx_util_pkg.debug(sqlerrm);
1476: fa_rx_util_pkg.debug('arrx_tx.artx_sales_rep(EXCEPTION)-');
1477: end artx_sales_rep;
1478:
1479:
1480: --

Line 1499: fa_rx_util_pkg.debug('arrx_tx.sales_before_report()+');

1495: amount_where varchar2(1000); -- where-clause statement for line amounts
1496: line_select_statement varchar2(1000); -- where-clause statement for sub-query of line information
1497:
1498: begin
1499: fa_rx_util_pkg.debug('arrx_tx.sales_before_report()+');
1500:
1501: fa_rx_util_pkg.debug('GL_GET_PROFILE_SO_FLEX_CODE');
1502:
1503: oe_profile.get(

Line 1709: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');

1705: --
1706: -- Assign another column specific to this report
1707: fa_rx_util_pkg.debug('AR_ADD_SELECT_COLUMNS');
1708:
1709: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');
1710: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1711: fa_rx_util_pkg.assign_column('c3 ','CTL.LINK_TO_CUST_TRX_LINE_ID', 'LINK_TO_CUST_TRX_LINE_ID', 'arrx_tx.var.link_to_cust_trx_line_id', 'NUMBER');
1712: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1713: fa_rx_util_pkg.assign_column('c5 ','DIST.CUST_TRX_LINE_GL_DIST_ID', 'CUST_TRX_LINE_GL_DIST_ID', 'arrx_tx.var.cust_trx_line_gl_dist_id', 'NUMBER');

Line 1710: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');

1706: -- Assign another column specific to this report
1707: fa_rx_util_pkg.debug('AR_ADD_SELECT_COLUMNS');
1708:
1709: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');
1710: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1711: fa_rx_util_pkg.assign_column('c3 ','CTL.LINK_TO_CUST_TRX_LINE_ID', 'LINK_TO_CUST_TRX_LINE_ID', 'arrx_tx.var.link_to_cust_trx_line_id', 'NUMBER');
1712: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1713: fa_rx_util_pkg.assign_column('c5 ','DIST.CUST_TRX_LINE_GL_DIST_ID', 'CUST_TRX_LINE_GL_DIST_ID', 'arrx_tx.var.cust_trx_line_gl_dist_id', 'NUMBER');
1714: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);

Line 1711: fa_rx_util_pkg.assign_column('c3 ','CTL.LINK_TO_CUST_TRX_LINE_ID', 'LINK_TO_CUST_TRX_LINE_ID', 'arrx_tx.var.link_to_cust_trx_line_id', 'NUMBER');

1707: fa_rx_util_pkg.debug('AR_ADD_SELECT_COLUMNS');
1708:
1709: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');
1710: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1711: fa_rx_util_pkg.assign_column('c3 ','CTL.LINK_TO_CUST_TRX_LINE_ID', 'LINK_TO_CUST_TRX_LINE_ID', 'arrx_tx.var.link_to_cust_trx_line_id', 'NUMBER');
1712: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1713: fa_rx_util_pkg.assign_column('c5 ','DIST.CUST_TRX_LINE_GL_DIST_ID', 'CUST_TRX_LINE_GL_DIST_ID', 'arrx_tx.var.cust_trx_line_gl_dist_id', 'NUMBER');
1714: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1715: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);

Line 1712: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);

1708:
1709: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');
1710: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1711: fa_rx_util_pkg.assign_column('c3 ','CTL.LINK_TO_CUST_TRX_LINE_ID', 'LINK_TO_CUST_TRX_LINE_ID', 'arrx_tx.var.link_to_cust_trx_line_id', 'NUMBER');
1712: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1713: fa_rx_util_pkg.assign_column('c5 ','DIST.CUST_TRX_LINE_GL_DIST_ID', 'CUST_TRX_LINE_GL_DIST_ID', 'arrx_tx.var.cust_trx_line_gl_dist_id', 'NUMBER');
1714: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1715: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1716: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);

Line 1713: fa_rx_util_pkg.assign_column('c5 ','DIST.CUST_TRX_LINE_GL_DIST_ID', 'CUST_TRX_LINE_GL_DIST_ID', 'arrx_tx.var.cust_trx_line_gl_dist_id', 'NUMBER');

1709: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');
1710: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1711: fa_rx_util_pkg.assign_column('c3 ','CTL.LINK_TO_CUST_TRX_LINE_ID', 'LINK_TO_CUST_TRX_LINE_ID', 'arrx_tx.var.link_to_cust_trx_line_id', 'NUMBER');
1712: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1713: fa_rx_util_pkg.assign_column('c5 ','DIST.CUST_TRX_LINE_GL_DIST_ID', 'CUST_TRX_LINE_GL_DIST_ID', 'arrx_tx.var.cust_trx_line_gl_dist_id', 'NUMBER');
1714: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1715: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1716: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1717: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);

Line 1714: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);

1710: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1711: fa_rx_util_pkg.assign_column('c3 ','CTL.LINK_TO_CUST_TRX_LINE_ID', 'LINK_TO_CUST_TRX_LINE_ID', 'arrx_tx.var.link_to_cust_trx_line_id', 'NUMBER');
1712: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1713: fa_rx_util_pkg.assign_column('c5 ','DIST.CUST_TRX_LINE_GL_DIST_ID', 'CUST_TRX_LINE_GL_DIST_ID', 'arrx_tx.var.cust_trx_line_gl_dist_id', 'NUMBER');
1714: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1715: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1716: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1717: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1718: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);

Line 1715: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);

1711: fa_rx_util_pkg.assign_column('c3 ','CTL.LINK_TO_CUST_TRX_LINE_ID', 'LINK_TO_CUST_TRX_LINE_ID', 'arrx_tx.var.link_to_cust_trx_line_id', 'NUMBER');
1712: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1713: fa_rx_util_pkg.assign_column('c5 ','DIST.CUST_TRX_LINE_GL_DIST_ID', 'CUST_TRX_LINE_GL_DIST_ID', 'arrx_tx.var.cust_trx_line_gl_dist_id', 'NUMBER');
1714: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1715: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1716: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1717: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1718: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);
1719: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);

Line 1716: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);

1712: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1713: fa_rx_util_pkg.assign_column('c5 ','DIST.CUST_TRX_LINE_GL_DIST_ID', 'CUST_TRX_LINE_GL_DIST_ID', 'arrx_tx.var.cust_trx_line_gl_dist_id', 'NUMBER');
1714: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1715: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1716: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1717: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1718: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);
1719: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);
1720: fa_rx_util_pkg.assign_column('c12','ITEM.DESCRIPTION', 'ITEM_DESCRIPTION', 'arrx_tx.var.item_description', 'VARCHAR2',240);

Line 1717: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);

1713: fa_rx_util_pkg.assign_column('c5 ','DIST.CUST_TRX_LINE_GL_DIST_ID', 'CUST_TRX_LINE_GL_DIST_ID', 'arrx_tx.var.cust_trx_line_gl_dist_id', 'NUMBER');
1714: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1715: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1716: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1717: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1718: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);
1719: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);
1720: fa_rx_util_pkg.assign_column('c12','ITEM.DESCRIPTION', 'ITEM_DESCRIPTION', 'arrx_tx.var.item_description', 'VARCHAR2',240);
1721:

Line 1718: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);

1714: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1715: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1716: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1717: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1718: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);
1719: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);
1720: fa_rx_util_pkg.assign_column('c12','ITEM.DESCRIPTION', 'ITEM_DESCRIPTION', 'arrx_tx.var.item_description', 'VARCHAR2',240);
1721:
1722: --

Line 1719: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);

1715: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1716: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1717: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1718: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);
1719: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);
1720: fa_rx_util_pkg.assign_column('c12','ITEM.DESCRIPTION', 'ITEM_DESCRIPTION', 'arrx_tx.var.item_description', 'VARCHAR2',240);
1721:
1722: --
1723: -- Add to the FROM clause specific to this report

Line 1720: fa_rx_util_pkg.assign_column('c12','ITEM.DESCRIPTION', 'ITEM_DESCRIPTION', 'arrx_tx.var.item_description', 'VARCHAR2',240);

1716: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1717: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1718: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);
1719: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);
1720: fa_rx_util_pkg.assign_column('c12','ITEM.DESCRIPTION', 'ITEM_DESCRIPTION', 'arrx_tx.var.item_description', 'VARCHAR2',240);
1721:
1722: --
1723: -- Add to the FROM clause specific to this report
1724: fa_rx_util_pkg.debug('AR_ADD_FORM_CLAUSE');

Line 1790: fa_rx_util_pkg.debug('arrx_tx.sales_before_report()-');

1786: AND DIST.ACCOUNT_SET_FLAG = ''N''
1787: AND DIST.CODE_COMBINATION_ID = CCDIST.CODE_COMBINATION_ID ';
1788: end if;
1789:
1790: fa_rx_util_pkg.debug('arrx_tx.sales_before_report()-');
1791:
1792: end sales_before_report;
1793:
1794: procedure sales_bind(c in integer)

Line 1976: end ARRX_TX;

1972:
1973: return 'N';
1974: end WHERE_LAST_UPDATE;
1975:
1976: end ARRX_TX;