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.20.12020000.4 2012/11/16 11:17:58 kknekkal 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 563: SELECT_BILL_NUMBER := 'DECODE(SYSPARAM.SHOW_BILLING_NUMBER_FLAG,''Y'',ARRX_TX.GET_CONS_BILL_NUMBER(CT.CUSTOMER_TRX_ID),NULL) ';

559: IF var.bill_flag = 'N' THEN
560: SELECT_BILL_NUMBER := null;
561: ELSE
562: */
563: SELECT_BILL_NUMBER := 'DECODE(SYSPARAM.SHOW_BILLING_NUMBER_FLAG,''Y'',ARRX_TX.GET_CONS_BILL_NUMBER(CT.CUSTOMER_TRX_ID),NULL) ';
564:
565: -- END IF;
566:
567:

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

602: fa_rx_util_pkg.debug('ARTX_ASSIGN_SELECT_LIST');
603:
604: -- fa_rx_util_pkg.assign_column(#, select, insert, place, type, len);
605: -->>SELECT_START<<--
606: fa_rx_util_pkg.assign_column('10 ','CCRECDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid', 'NUMBER');
607: fa_rx_util_pkg.assign_column('20 ',null, 'ORGANIZATION_NAME', 'arrx_tx.var.organization_name', 'VARCHAR2', 30);
608: fa_rx_util_pkg.assign_column('30 ',null, 'FUNCTIONAL_CURRENCY_CODE', 'arrx_tx.var.functional_currency_code', 'VARCHAR2', 15);
609: fa_rx_util_pkg.assign_column('40 ','CT.CUSTOMER_TRX_ID', 'CUSTOMER_TRX_ID', 'arrx_tx.var.customer_trx_id', 'NUMBER');
610: fa_rx_util_pkg.assign_column('50 ','CT.TRX_NUMBER', 'TRX_NUMBER', 'arrx_tx.var.trx_number', 'VARCHAR2', 20);

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

603:
604: -- fa_rx_util_pkg.assign_column(#, select, insert, place, type, len);
605: -->>SELECT_START<<--
606: fa_rx_util_pkg.assign_column('10 ','CCRECDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid', 'NUMBER');
607: fa_rx_util_pkg.assign_column('20 ',null, 'ORGANIZATION_NAME', 'arrx_tx.var.organization_name', 'VARCHAR2', 30);
608: fa_rx_util_pkg.assign_column('30 ',null, 'FUNCTIONAL_CURRENCY_CODE', 'arrx_tx.var.functional_currency_code', 'VARCHAR2', 15);
609: fa_rx_util_pkg.assign_column('40 ','CT.CUSTOMER_TRX_ID', 'CUSTOMER_TRX_ID', 'arrx_tx.var.customer_trx_id', 'NUMBER');
610: fa_rx_util_pkg.assign_column('50 ','CT.TRX_NUMBER', 'TRX_NUMBER', 'arrx_tx.var.trx_number', 'VARCHAR2', 20);
611: fa_rx_util_pkg.assign_column('60 ',SELECT_BILL_NUMBER, 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);

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

604: -- fa_rx_util_pkg.assign_column(#, select, insert, place, type, len);
605: -->>SELECT_START<<--
606: fa_rx_util_pkg.assign_column('10 ','CCRECDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid', 'NUMBER');
607: fa_rx_util_pkg.assign_column('20 ',null, 'ORGANIZATION_NAME', 'arrx_tx.var.organization_name', 'VARCHAR2', 30);
608: fa_rx_util_pkg.assign_column('30 ',null, 'FUNCTIONAL_CURRENCY_CODE', 'arrx_tx.var.functional_currency_code', 'VARCHAR2', 15);
609: fa_rx_util_pkg.assign_column('40 ','CT.CUSTOMER_TRX_ID', 'CUSTOMER_TRX_ID', 'arrx_tx.var.customer_trx_id', 'NUMBER');
610: fa_rx_util_pkg.assign_column('50 ','CT.TRX_NUMBER', 'TRX_NUMBER', 'arrx_tx.var.trx_number', 'VARCHAR2', 20);
611: fa_rx_util_pkg.assign_column('60 ',SELECT_BILL_NUMBER, 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);
612: 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 609: fa_rx_util_pkg.assign_column('40 ','CT.CUSTOMER_TRX_ID', 'CUSTOMER_TRX_ID', 'arrx_tx.var.customer_trx_id', 'NUMBER');

605: -->>SELECT_START<<--
606: fa_rx_util_pkg.assign_column('10 ','CCRECDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid', 'NUMBER');
607: fa_rx_util_pkg.assign_column('20 ',null, 'ORGANIZATION_NAME', 'arrx_tx.var.organization_name', 'VARCHAR2', 30);
608: fa_rx_util_pkg.assign_column('30 ',null, 'FUNCTIONAL_CURRENCY_CODE', 'arrx_tx.var.functional_currency_code', 'VARCHAR2', 15);
609: fa_rx_util_pkg.assign_column('40 ','CT.CUSTOMER_TRX_ID', 'CUSTOMER_TRX_ID', 'arrx_tx.var.customer_trx_id', 'NUMBER');
610: fa_rx_util_pkg.assign_column('50 ','CT.TRX_NUMBER', 'TRX_NUMBER', 'arrx_tx.var.trx_number', 'VARCHAR2', 20);
611: fa_rx_util_pkg.assign_column('60 ',SELECT_BILL_NUMBER, 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);
612: 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');
613: fa_rx_util_pkg.assign_column('80 ',REC_ACCOUNT_SEL, 'REC_ACCOUNT', 'arrx_tx.var.rec_account', 'VARCHAR2',240);

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

606: fa_rx_util_pkg.assign_column('10 ','CCRECDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid', 'NUMBER');
607: fa_rx_util_pkg.assign_column('20 ',null, 'ORGANIZATION_NAME', 'arrx_tx.var.organization_name', 'VARCHAR2', 30);
608: fa_rx_util_pkg.assign_column('30 ',null, 'FUNCTIONAL_CURRENCY_CODE', 'arrx_tx.var.functional_currency_code', 'VARCHAR2', 15);
609: fa_rx_util_pkg.assign_column('40 ','CT.CUSTOMER_TRX_ID', 'CUSTOMER_TRX_ID', 'arrx_tx.var.customer_trx_id', 'NUMBER');
610: fa_rx_util_pkg.assign_column('50 ','CT.TRX_NUMBER', 'TRX_NUMBER', 'arrx_tx.var.trx_number', 'VARCHAR2', 20);
611: fa_rx_util_pkg.assign_column('60 ',SELECT_BILL_NUMBER, 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);
612: 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');
613: fa_rx_util_pkg.assign_column('80 ',REC_ACCOUNT_SEL, 'REC_ACCOUNT', 'arrx_tx.var.rec_account', 'VARCHAR2',240);
614: fa_rx_util_pkg.assign_column('90 ',null, 'REC_ACCOUNT_DESC', 'arrx_tx.var.rec_account_desc', 'VARCHAR2',240);

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

607: fa_rx_util_pkg.assign_column('20 ',null, 'ORGANIZATION_NAME', 'arrx_tx.var.organization_name', 'VARCHAR2', 30);
608: fa_rx_util_pkg.assign_column('30 ',null, 'FUNCTIONAL_CURRENCY_CODE', 'arrx_tx.var.functional_currency_code', 'VARCHAR2', 15);
609: fa_rx_util_pkg.assign_column('40 ','CT.CUSTOMER_TRX_ID', 'CUSTOMER_TRX_ID', 'arrx_tx.var.customer_trx_id', 'NUMBER');
610: fa_rx_util_pkg.assign_column('50 ','CT.TRX_NUMBER', 'TRX_NUMBER', 'arrx_tx.var.trx_number', 'VARCHAR2', 20);
611: fa_rx_util_pkg.assign_column('60 ',SELECT_BILL_NUMBER, 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);
612: 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');
613: fa_rx_util_pkg.assign_column('80 ',REC_ACCOUNT_SEL, 'REC_ACCOUNT', 'arrx_tx.var.rec_account', 'VARCHAR2',240);
614: fa_rx_util_pkg.assign_column('90 ',null, 'REC_ACCOUNT_DESC', 'arrx_tx.var.rec_account_desc', 'VARCHAR2',240);
615: fa_rx_util_pkg.assign_column('100',REC_BALANCE_SEL, 'REC_BALANCE', 'arrx_tx.var.rec_balance', 'VARCHAR2',240);

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

608: fa_rx_util_pkg.assign_column('30 ',null, 'FUNCTIONAL_CURRENCY_CODE', 'arrx_tx.var.functional_currency_code', 'VARCHAR2', 15);
609: fa_rx_util_pkg.assign_column('40 ','CT.CUSTOMER_TRX_ID', 'CUSTOMER_TRX_ID', 'arrx_tx.var.customer_trx_id', 'NUMBER');
610: fa_rx_util_pkg.assign_column('50 ','CT.TRX_NUMBER', 'TRX_NUMBER', 'arrx_tx.var.trx_number', 'VARCHAR2', 20);
611: fa_rx_util_pkg.assign_column('60 ',SELECT_BILL_NUMBER, 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);
612: 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');
613: fa_rx_util_pkg.assign_column('80 ',REC_ACCOUNT_SEL, 'REC_ACCOUNT', 'arrx_tx.var.rec_account', 'VARCHAR2',240);
614: fa_rx_util_pkg.assign_column('90 ',null, 'REC_ACCOUNT_DESC', 'arrx_tx.var.rec_account_desc', 'VARCHAR2',240);
615: fa_rx_util_pkg.assign_column('100',REC_BALANCE_SEL, 'REC_BALANCE', 'arrx_tx.var.rec_balance', 'VARCHAR2',240);
616: fa_rx_util_pkg.assign_column('110',null, 'REC_BALANCE_DESC', 'arrx_tx.var.rec_balance_desc', 'VARCHAR2',240);

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

609: fa_rx_util_pkg.assign_column('40 ','CT.CUSTOMER_TRX_ID', 'CUSTOMER_TRX_ID', 'arrx_tx.var.customer_trx_id', 'NUMBER');
610: fa_rx_util_pkg.assign_column('50 ','CT.TRX_NUMBER', 'TRX_NUMBER', 'arrx_tx.var.trx_number', 'VARCHAR2', 20);
611: fa_rx_util_pkg.assign_column('60 ',SELECT_BILL_NUMBER, 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);
612: 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');
613: fa_rx_util_pkg.assign_column('80 ',REC_ACCOUNT_SEL, 'REC_ACCOUNT', 'arrx_tx.var.rec_account', 'VARCHAR2',240);
614: fa_rx_util_pkg.assign_column('90 ',null, 'REC_ACCOUNT_DESC', 'arrx_tx.var.rec_account_desc', 'VARCHAR2',240);
615: fa_rx_util_pkg.assign_column('100',REC_BALANCE_SEL, 'REC_BALANCE', 'arrx_tx.var.rec_balance', 'VARCHAR2',240);
616: fa_rx_util_pkg.assign_column('110',null, 'REC_BALANCE_DESC', 'arrx_tx.var.rec_balance_desc', 'VARCHAR2',240);
617: fa_rx_util_pkg.assign_column('120',REC_NATURAL_SEL, 'REC_NATACCT', 'arrx_tx.var.rec_natacct', 'VARCHAR2',240);

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

610: fa_rx_util_pkg.assign_column('50 ','CT.TRX_NUMBER', 'TRX_NUMBER', 'arrx_tx.var.trx_number', 'VARCHAR2', 20);
611: fa_rx_util_pkg.assign_column('60 ',SELECT_BILL_NUMBER, 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);
612: 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');
613: fa_rx_util_pkg.assign_column('80 ',REC_ACCOUNT_SEL, 'REC_ACCOUNT', 'arrx_tx.var.rec_account', 'VARCHAR2',240);
614: fa_rx_util_pkg.assign_column('90 ',null, 'REC_ACCOUNT_DESC', 'arrx_tx.var.rec_account_desc', 'VARCHAR2',240);
615: fa_rx_util_pkg.assign_column('100',REC_BALANCE_SEL, 'REC_BALANCE', 'arrx_tx.var.rec_balance', 'VARCHAR2',240);
616: fa_rx_util_pkg.assign_column('110',null, 'REC_BALANCE_DESC', 'arrx_tx.var.rec_balance_desc', 'VARCHAR2',240);
617: fa_rx_util_pkg.assign_column('120',REC_NATURAL_SEL, 'REC_NATACCT', 'arrx_tx.var.rec_natacct', 'VARCHAR2',240);
618: fa_rx_util_pkg.assign_column('130',null, 'REC_NATACCT_DESC', 'arrx_tx.var.rec_natacct_desc', 'VARCHAR2',240);

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

611: fa_rx_util_pkg.assign_column('60 ',SELECT_BILL_NUMBER, 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);
612: 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');
613: fa_rx_util_pkg.assign_column('80 ',REC_ACCOUNT_SEL, 'REC_ACCOUNT', 'arrx_tx.var.rec_account', 'VARCHAR2',240);
614: fa_rx_util_pkg.assign_column('90 ',null, 'REC_ACCOUNT_DESC', 'arrx_tx.var.rec_account_desc', 'VARCHAR2',240);
615: fa_rx_util_pkg.assign_column('100',REC_BALANCE_SEL, 'REC_BALANCE', 'arrx_tx.var.rec_balance', 'VARCHAR2',240);
616: fa_rx_util_pkg.assign_column('110',null, 'REC_BALANCE_DESC', 'arrx_tx.var.rec_balance_desc', 'VARCHAR2',240);
617: fa_rx_util_pkg.assign_column('120',REC_NATURAL_SEL, 'REC_NATACCT', 'arrx_tx.var.rec_natacct', 'VARCHAR2',240);
618: fa_rx_util_pkg.assign_column('130',null, 'REC_NATACCT_DESC', 'arrx_tx.var.rec_natacct_desc', 'VARCHAR2',240);
619: 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 616: fa_rx_util_pkg.assign_column('110',null, 'REC_BALANCE_DESC', 'arrx_tx.var.rec_balance_desc', 'VARCHAR2',240);

612: 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');
613: fa_rx_util_pkg.assign_column('80 ',REC_ACCOUNT_SEL, 'REC_ACCOUNT', 'arrx_tx.var.rec_account', 'VARCHAR2',240);
614: fa_rx_util_pkg.assign_column('90 ',null, 'REC_ACCOUNT_DESC', 'arrx_tx.var.rec_account_desc', 'VARCHAR2',240);
615: fa_rx_util_pkg.assign_column('100',REC_BALANCE_SEL, 'REC_BALANCE', 'arrx_tx.var.rec_balance', 'VARCHAR2',240);
616: fa_rx_util_pkg.assign_column('110',null, 'REC_BALANCE_DESC', 'arrx_tx.var.rec_balance_desc', 'VARCHAR2',240);
617: fa_rx_util_pkg.assign_column('120',REC_NATURAL_SEL, 'REC_NATACCT', 'arrx_tx.var.rec_natacct', 'VARCHAR2',240);
618: fa_rx_util_pkg.assign_column('130',null, 'REC_NATACCT_DESC', 'arrx_tx.var.rec_natacct_desc', 'VARCHAR2',240);
619: 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);
620: 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 617: fa_rx_util_pkg.assign_column('120',REC_NATURAL_SEL, 'REC_NATACCT', 'arrx_tx.var.rec_natacct', 'VARCHAR2',240);

613: fa_rx_util_pkg.assign_column('80 ',REC_ACCOUNT_SEL, 'REC_ACCOUNT', 'arrx_tx.var.rec_account', 'VARCHAR2',240);
614: fa_rx_util_pkg.assign_column('90 ',null, 'REC_ACCOUNT_DESC', 'arrx_tx.var.rec_account_desc', 'VARCHAR2',240);
615: fa_rx_util_pkg.assign_column('100',REC_BALANCE_SEL, 'REC_BALANCE', 'arrx_tx.var.rec_balance', 'VARCHAR2',240);
616: fa_rx_util_pkg.assign_column('110',null, 'REC_BALANCE_DESC', 'arrx_tx.var.rec_balance_desc', 'VARCHAR2',240);
617: fa_rx_util_pkg.assign_column('120',REC_NATURAL_SEL, 'REC_NATACCT', 'arrx_tx.var.rec_natacct', 'VARCHAR2',240);
618: fa_rx_util_pkg.assign_column('130',null, 'REC_NATACCT_DESC', 'arrx_tx.var.rec_natacct_desc', 'VARCHAR2',240);
619: 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);
620: 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');
621: 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 618: fa_rx_util_pkg.assign_column('130',null, 'REC_NATACCT_DESC', 'arrx_tx.var.rec_natacct_desc', 'VARCHAR2',240);

614: fa_rx_util_pkg.assign_column('90 ',null, 'REC_ACCOUNT_DESC', 'arrx_tx.var.rec_account_desc', 'VARCHAR2',240);
615: fa_rx_util_pkg.assign_column('100',REC_BALANCE_SEL, 'REC_BALANCE', 'arrx_tx.var.rec_balance', 'VARCHAR2',240);
616: fa_rx_util_pkg.assign_column('110',null, 'REC_BALANCE_DESC', 'arrx_tx.var.rec_balance_desc', 'VARCHAR2',240);
617: fa_rx_util_pkg.assign_column('120',REC_NATURAL_SEL, 'REC_NATACCT', 'arrx_tx.var.rec_natacct', 'VARCHAR2',240);
618: fa_rx_util_pkg.assign_column('130',null, 'REC_NATACCT_DESC', 'arrx_tx.var.rec_natacct_desc', 'VARCHAR2',240);
619: 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);
620: 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');
621: 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');
622: fa_rx_util_pkg.assign_column('170','CT.TRX_DATE', 'TRX_DATE', 'arrx_tx.var.trx_date', 'DATE');

Line 619: 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);

615: fa_rx_util_pkg.assign_column('100',REC_BALANCE_SEL, 'REC_BALANCE', 'arrx_tx.var.rec_balance', 'VARCHAR2',240);
616: fa_rx_util_pkg.assign_column('110',null, 'REC_BALANCE_DESC', 'arrx_tx.var.rec_balance_desc', 'VARCHAR2',240);
617: fa_rx_util_pkg.assign_column('120',REC_NATURAL_SEL, 'REC_NATACCT', 'arrx_tx.var.rec_natacct', 'VARCHAR2',240);
618: fa_rx_util_pkg.assign_column('130',null, 'REC_NATACCT_DESC', 'arrx_tx.var.rec_natacct_desc', 'VARCHAR2',240);
619: 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);
620: 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');
621: 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');
622: fa_rx_util_pkg.assign_column('170','CT.TRX_DATE', 'TRX_DATE', 'arrx_tx.var.trx_date', 'DATE');
623: fa_rx_util_pkg.assign_column('180','CT.INVOICE_CURRENCY_CODE', 'TRX_CURRENCY', 'arrx_tx.var.trx_currency', 'VARCHAR2', 15);

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

616: fa_rx_util_pkg.assign_column('110',null, 'REC_BALANCE_DESC', 'arrx_tx.var.rec_balance_desc', 'VARCHAR2',240);
617: fa_rx_util_pkg.assign_column('120',REC_NATURAL_SEL, 'REC_NATACCT', 'arrx_tx.var.rec_natacct', 'VARCHAR2',240);
618: fa_rx_util_pkg.assign_column('130',null, 'REC_NATACCT_DESC', 'arrx_tx.var.rec_natacct_desc', 'VARCHAR2',240);
619: 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);
620: 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');
621: 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');
622: fa_rx_util_pkg.assign_column('170','CT.TRX_DATE', 'TRX_DATE', 'arrx_tx.var.trx_date', 'DATE');
623: fa_rx_util_pkg.assign_column('180','CT.INVOICE_CURRENCY_CODE', 'TRX_CURRENCY', 'arrx_tx.var.trx_currency', 'VARCHAR2', 15);
624: fa_rx_util_pkg.assign_column('190','CT.EXCHANGE_RATE', 'EXCHANGE_RATE', 'arrx_tx.var.exchange_rate', 'NUMBER');

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

617: fa_rx_util_pkg.assign_column('120',REC_NATURAL_SEL, 'REC_NATACCT', 'arrx_tx.var.rec_natacct', 'VARCHAR2',240);
618: fa_rx_util_pkg.assign_column('130',null, 'REC_NATACCT_DESC', 'arrx_tx.var.rec_natacct_desc', 'VARCHAR2',240);
619: 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);
620: 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');
621: 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');
622: fa_rx_util_pkg.assign_column('170','CT.TRX_DATE', 'TRX_DATE', 'arrx_tx.var.trx_date', 'DATE');
623: fa_rx_util_pkg.assign_column('180','CT.INVOICE_CURRENCY_CODE', 'TRX_CURRENCY', 'arrx_tx.var.trx_currency', 'VARCHAR2', 15);
624: fa_rx_util_pkg.assign_column('190','CT.EXCHANGE_RATE', 'EXCHANGE_RATE', 'arrx_tx.var.exchange_rate', 'NUMBER');
625: fa_rx_util_pkg.assign_column('200','CT.EXCHANGE_DATE', 'EXCHANGE_DATE', 'arrx_tx.var.exchange_date', 'DATE');

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

618: fa_rx_util_pkg.assign_column('130',null, 'REC_NATACCT_DESC', 'arrx_tx.var.rec_natacct_desc', 'VARCHAR2',240);
619: 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);
620: 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');
621: 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');
622: fa_rx_util_pkg.assign_column('170','CT.TRX_DATE', 'TRX_DATE', 'arrx_tx.var.trx_date', 'DATE');
623: fa_rx_util_pkg.assign_column('180','CT.INVOICE_CURRENCY_CODE', 'TRX_CURRENCY', 'arrx_tx.var.trx_currency', 'VARCHAR2', 15);
624: fa_rx_util_pkg.assign_column('190','CT.EXCHANGE_RATE', 'EXCHANGE_RATE', 'arrx_tx.var.exchange_rate', 'NUMBER');
625: fa_rx_util_pkg.assign_column('200','CT.EXCHANGE_DATE', 'EXCHANGE_DATE', 'arrx_tx.var.exchange_date', 'DATE');
626: fa_rx_util_pkg.assign_column('210','CT.EXCHANGE_RATE_TYPE', 'EXCHANGE_TYPE', 'arrx_tx.var.exchange_type', 'VARCHAR2', 30);

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

619: 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);
620: 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');
621: 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');
622: fa_rx_util_pkg.assign_column('170','CT.TRX_DATE', 'TRX_DATE', 'arrx_tx.var.trx_date', 'DATE');
623: fa_rx_util_pkg.assign_column('180','CT.INVOICE_CURRENCY_CODE', 'TRX_CURRENCY', 'arrx_tx.var.trx_currency', 'VARCHAR2', 15);
624: fa_rx_util_pkg.assign_column('190','CT.EXCHANGE_RATE', 'EXCHANGE_RATE', 'arrx_tx.var.exchange_rate', 'NUMBER');
625: fa_rx_util_pkg.assign_column('200','CT.EXCHANGE_DATE', 'EXCHANGE_DATE', 'arrx_tx.var.exchange_date', 'DATE');
626: fa_rx_util_pkg.assign_column('210','CT.EXCHANGE_RATE_TYPE', 'EXCHANGE_TYPE', 'arrx_tx.var.exchange_type', 'VARCHAR2', 30);
627: fa_rx_util_pkg.assign_column('220','RECDIST.GL_DATE', 'RECEIVABLES_GL_DATE', 'arrx_tx.var.receivables_gl_date', 'DATE');

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

620: 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');
621: 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');
622: fa_rx_util_pkg.assign_column('170','CT.TRX_DATE', 'TRX_DATE', 'arrx_tx.var.trx_date', 'DATE');
623: fa_rx_util_pkg.assign_column('180','CT.INVOICE_CURRENCY_CODE', 'TRX_CURRENCY', 'arrx_tx.var.trx_currency', 'VARCHAR2', 15);
624: fa_rx_util_pkg.assign_column('190','CT.EXCHANGE_RATE', 'EXCHANGE_RATE', 'arrx_tx.var.exchange_rate', 'NUMBER');
625: fa_rx_util_pkg.assign_column('200','CT.EXCHANGE_DATE', 'EXCHANGE_DATE', 'arrx_tx.var.exchange_date', 'DATE');
626: fa_rx_util_pkg.assign_column('210','CT.EXCHANGE_RATE_TYPE', 'EXCHANGE_TYPE', 'arrx_tx.var.exchange_type', 'VARCHAR2', 30);
627: fa_rx_util_pkg.assign_column('220','RECDIST.GL_DATE', 'RECEIVABLES_GL_DATE', 'arrx_tx.var.receivables_gl_date', 'DATE');
628: -- bug4274502 added nvl because AutoInvoice does not set term_due_date

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

621: 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');
622: fa_rx_util_pkg.assign_column('170','CT.TRX_DATE', 'TRX_DATE', 'arrx_tx.var.trx_date', 'DATE');
623: fa_rx_util_pkg.assign_column('180','CT.INVOICE_CURRENCY_CODE', 'TRX_CURRENCY', 'arrx_tx.var.trx_currency', 'VARCHAR2', 15);
624: fa_rx_util_pkg.assign_column('190','CT.EXCHANGE_RATE', 'EXCHANGE_RATE', 'arrx_tx.var.exchange_rate', 'NUMBER');
625: fa_rx_util_pkg.assign_column('200','CT.EXCHANGE_DATE', 'EXCHANGE_DATE', 'arrx_tx.var.exchange_date', 'DATE');
626: fa_rx_util_pkg.assign_column('210','CT.EXCHANGE_RATE_TYPE', 'EXCHANGE_TYPE', 'arrx_tx.var.exchange_type', 'VARCHAR2', 30);
627: fa_rx_util_pkg.assign_column('220','RECDIST.GL_DATE', 'RECEIVABLES_GL_DATE', 'arrx_tx.var.receivables_gl_date', 'DATE');
628: -- bug4274502 added nvl because AutoInvoice does not set term_due_date
629: 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 626: fa_rx_util_pkg.assign_column('210','CT.EXCHANGE_RATE_TYPE', 'EXCHANGE_TYPE', 'arrx_tx.var.exchange_type', 'VARCHAR2', 30);

622: fa_rx_util_pkg.assign_column('170','CT.TRX_DATE', 'TRX_DATE', 'arrx_tx.var.trx_date', 'DATE');
623: fa_rx_util_pkg.assign_column('180','CT.INVOICE_CURRENCY_CODE', 'TRX_CURRENCY', 'arrx_tx.var.trx_currency', 'VARCHAR2', 15);
624: fa_rx_util_pkg.assign_column('190','CT.EXCHANGE_RATE', 'EXCHANGE_RATE', 'arrx_tx.var.exchange_rate', 'NUMBER');
625: fa_rx_util_pkg.assign_column('200','CT.EXCHANGE_DATE', 'EXCHANGE_DATE', 'arrx_tx.var.exchange_date', 'DATE');
626: fa_rx_util_pkg.assign_column('210','CT.EXCHANGE_RATE_TYPE', 'EXCHANGE_TYPE', 'arrx_tx.var.exchange_type', 'VARCHAR2', 30);
627: fa_rx_util_pkg.assign_column('220','RECDIST.GL_DATE', 'RECEIVABLES_GL_DATE', 'arrx_tx.var.receivables_gl_date', 'DATE');
628: -- bug4274502 added nvl because AutoInvoice does not set term_due_date
629: 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');
630: fa_rx_util_pkg.assign_column('240', null, 'TAX_HEADER_LEVEL_FLAG', 'arrx_tx.var.tax_header_level_flag', 'VARCHAR2', 1);

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

623: fa_rx_util_pkg.assign_column('180','CT.INVOICE_CURRENCY_CODE', 'TRX_CURRENCY', 'arrx_tx.var.trx_currency', 'VARCHAR2', 15);
624: fa_rx_util_pkg.assign_column('190','CT.EXCHANGE_RATE', 'EXCHANGE_RATE', 'arrx_tx.var.exchange_rate', 'NUMBER');
625: fa_rx_util_pkg.assign_column('200','CT.EXCHANGE_DATE', 'EXCHANGE_DATE', 'arrx_tx.var.exchange_date', 'DATE');
626: fa_rx_util_pkg.assign_column('210','CT.EXCHANGE_RATE_TYPE', 'EXCHANGE_TYPE', 'arrx_tx.var.exchange_type', 'VARCHAR2', 30);
627: fa_rx_util_pkg.assign_column('220','RECDIST.GL_DATE', 'RECEIVABLES_GL_DATE', 'arrx_tx.var.receivables_gl_date', 'DATE');
628: -- bug4274502 added nvl because AutoInvoice does not set term_due_date
629: 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');
630: fa_rx_util_pkg.assign_column('240', null, 'TAX_HEADER_LEVEL_FLAG', 'arrx_tx.var.tax_header_level_flag', 'VARCHAR2', 1);
631: fa_rx_util_pkg.assign_column('250','CT.DOC_SEQUENCE_VALUE', 'DOC_SEQUENCE_VALUE', 'arrx_tx.var.doc_sequence_value', 'NUMBER');

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

625: fa_rx_util_pkg.assign_column('200','CT.EXCHANGE_DATE', 'EXCHANGE_DATE', 'arrx_tx.var.exchange_date', 'DATE');
626: fa_rx_util_pkg.assign_column('210','CT.EXCHANGE_RATE_TYPE', 'EXCHANGE_TYPE', 'arrx_tx.var.exchange_type', 'VARCHAR2', 30);
627: fa_rx_util_pkg.assign_column('220','RECDIST.GL_DATE', 'RECEIVABLES_GL_DATE', 'arrx_tx.var.receivables_gl_date', 'DATE');
628: -- bug4274502 added nvl because AutoInvoice does not set term_due_date
629: 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');
630: fa_rx_util_pkg.assign_column('240', null, 'TAX_HEADER_LEVEL_FLAG', 'arrx_tx.var.tax_header_level_flag', 'VARCHAR2', 1);
631: fa_rx_util_pkg.assign_column('250','CT.DOC_SEQUENCE_VALUE', 'DOC_SEQUENCE_VALUE', 'arrx_tx.var.doc_sequence_value', 'NUMBER');
632: fa_rx_util_pkg.assign_column('260','RECDIST.AMOUNT', 'TRX_AMOUNT', 'arrx_tx.var.trx_amount', 'NUMBER');
633: fa_rx_util_pkg.assign_column('270','RECDIST.ACCTD_AMOUNT', 'TRX_ACCTD_AMOUNT', 'arrx_tx.var.trx_acctd_amount', 'NUMBER');

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

626: fa_rx_util_pkg.assign_column('210','CT.EXCHANGE_RATE_TYPE', 'EXCHANGE_TYPE', 'arrx_tx.var.exchange_type', 'VARCHAR2', 30);
627: fa_rx_util_pkg.assign_column('220','RECDIST.GL_DATE', 'RECEIVABLES_GL_DATE', 'arrx_tx.var.receivables_gl_date', 'DATE');
628: -- bug4274502 added nvl because AutoInvoice does not set term_due_date
629: 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');
630: fa_rx_util_pkg.assign_column('240', null, 'TAX_HEADER_LEVEL_FLAG', 'arrx_tx.var.tax_header_level_flag', 'VARCHAR2', 1);
631: fa_rx_util_pkg.assign_column('250','CT.DOC_SEQUENCE_VALUE', 'DOC_SEQUENCE_VALUE', 'arrx_tx.var.doc_sequence_value', 'NUMBER');
632: fa_rx_util_pkg.assign_column('260','RECDIST.AMOUNT', 'TRX_AMOUNT', 'arrx_tx.var.trx_amount', 'NUMBER');
633: fa_rx_util_pkg.assign_column('270','RECDIST.ACCTD_AMOUNT', 'TRX_ACCTD_AMOUNT', 'arrx_tx.var.trx_acctd_amount', 'NUMBER');
634: 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 631: fa_rx_util_pkg.assign_column('250','CT.DOC_SEQUENCE_VALUE', 'DOC_SEQUENCE_VALUE', 'arrx_tx.var.doc_sequence_value', 'NUMBER');

627: fa_rx_util_pkg.assign_column('220','RECDIST.GL_DATE', 'RECEIVABLES_GL_DATE', 'arrx_tx.var.receivables_gl_date', 'DATE');
628: -- bug4274502 added nvl because AutoInvoice does not set term_due_date
629: 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');
630: fa_rx_util_pkg.assign_column('240', null, 'TAX_HEADER_LEVEL_FLAG', 'arrx_tx.var.tax_header_level_flag', 'VARCHAR2', 1);
631: fa_rx_util_pkg.assign_column('250','CT.DOC_SEQUENCE_VALUE', 'DOC_SEQUENCE_VALUE', 'arrx_tx.var.doc_sequence_value', 'NUMBER');
632: fa_rx_util_pkg.assign_column('260','RECDIST.AMOUNT', 'TRX_AMOUNT', 'arrx_tx.var.trx_amount', 'NUMBER');
633: fa_rx_util_pkg.assign_column('270','RECDIST.ACCTD_AMOUNT', 'TRX_ACCTD_AMOUNT', 'arrx_tx.var.trx_acctd_amount', 'NUMBER');
634: 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);
635: 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 632: fa_rx_util_pkg.assign_column('260','RECDIST.AMOUNT', 'TRX_AMOUNT', 'arrx_tx.var.trx_amount', 'NUMBER');

628: -- bug4274502 added nvl because AutoInvoice does not set term_due_date
629: 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');
630: fa_rx_util_pkg.assign_column('240', null, 'TAX_HEADER_LEVEL_FLAG', 'arrx_tx.var.tax_header_level_flag', 'VARCHAR2', 1);
631: fa_rx_util_pkg.assign_column('250','CT.DOC_SEQUENCE_VALUE', 'DOC_SEQUENCE_VALUE', 'arrx_tx.var.doc_sequence_value', 'NUMBER');
632: fa_rx_util_pkg.assign_column('260','RECDIST.AMOUNT', 'TRX_AMOUNT', 'arrx_tx.var.trx_amount', 'NUMBER');
633: fa_rx_util_pkg.assign_column('270','RECDIST.ACCTD_AMOUNT', 'TRX_ACCTD_AMOUNT', 'arrx_tx.var.trx_acctd_amount', 'NUMBER');
634: 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);
635: 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);
636: 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 633: fa_rx_util_pkg.assign_column('270','RECDIST.ACCTD_AMOUNT', 'TRX_ACCTD_AMOUNT', 'arrx_tx.var.trx_acctd_amount', 'NUMBER');

629: 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');
630: fa_rx_util_pkg.assign_column('240', null, 'TAX_HEADER_LEVEL_FLAG', 'arrx_tx.var.tax_header_level_flag', 'VARCHAR2', 1);
631: fa_rx_util_pkg.assign_column('250','CT.DOC_SEQUENCE_VALUE', 'DOC_SEQUENCE_VALUE', 'arrx_tx.var.doc_sequence_value', 'NUMBER');
632: fa_rx_util_pkg.assign_column('260','RECDIST.AMOUNT', 'TRX_AMOUNT', 'arrx_tx.var.trx_amount', 'NUMBER');
633: fa_rx_util_pkg.assign_column('270','RECDIST.ACCTD_AMOUNT', 'TRX_ACCTD_AMOUNT', 'arrx_tx.var.trx_acctd_amount', 'NUMBER');
634: 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);
635: 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);
636: 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);
637: 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 634: 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);

630: fa_rx_util_pkg.assign_column('240', null, 'TAX_HEADER_LEVEL_FLAG', 'arrx_tx.var.tax_header_level_flag', 'VARCHAR2', 1);
631: fa_rx_util_pkg.assign_column('250','CT.DOC_SEQUENCE_VALUE', 'DOC_SEQUENCE_VALUE', 'arrx_tx.var.doc_sequence_value', 'NUMBER');
632: fa_rx_util_pkg.assign_column('260','RECDIST.AMOUNT', 'TRX_AMOUNT', 'arrx_tx.var.trx_amount', 'NUMBER');
633: fa_rx_util_pkg.assign_column('270','RECDIST.ACCTD_AMOUNT', 'TRX_ACCTD_AMOUNT', 'arrx_tx.var.trx_acctd_amount', 'NUMBER');
634: 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);
635: 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);
636: 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);
637: 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);
638: 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 635: 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);

631: fa_rx_util_pkg.assign_column('250','CT.DOC_SEQUENCE_VALUE', 'DOC_SEQUENCE_VALUE', 'arrx_tx.var.doc_sequence_value', 'NUMBER');
632: fa_rx_util_pkg.assign_column('260','RECDIST.AMOUNT', 'TRX_AMOUNT', 'arrx_tx.var.trx_amount', 'NUMBER');
633: fa_rx_util_pkg.assign_column('270','RECDIST.ACCTD_AMOUNT', 'TRX_ACCTD_AMOUNT', 'arrx_tx.var.trx_acctd_amount', 'NUMBER');
634: 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);
635: 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);
636: 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);
637: 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);
638: 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);
639: fa_rx_util_pkg.assign_column('330','CT.TERM_ID', 'TERM_ID', 'arrx_tx.var.term_id', 'NUMBER', 15);

Line 636: 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);

632: fa_rx_util_pkg.assign_column('260','RECDIST.AMOUNT', 'TRX_AMOUNT', 'arrx_tx.var.trx_amount', 'NUMBER');
633: fa_rx_util_pkg.assign_column('270','RECDIST.ACCTD_AMOUNT', 'TRX_ACCTD_AMOUNT', 'arrx_tx.var.trx_acctd_amount', 'NUMBER');
634: 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);
635: 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);
636: 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);
637: 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);
638: 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);
639: fa_rx_util_pkg.assign_column('330','CT.TERM_ID', 'TERM_ID', 'arrx_tx.var.term_id', 'NUMBER', 15);
640: fa_rx_util_pkg.assign_column('340','CT.DOC_SEQUENCE_ID', 'DOC_SEQUENCE_ID', 'arrx_tx.var.doc_sequence_id', 'NUMBER', 15);

Line 637: 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);

633: fa_rx_util_pkg.assign_column('270','RECDIST.ACCTD_AMOUNT', 'TRX_ACCTD_AMOUNT', 'arrx_tx.var.trx_acctd_amount', 'NUMBER');
634: 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);
635: 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);
636: 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);
637: 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);
638: 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);
639: fa_rx_util_pkg.assign_column('330','CT.TERM_ID', 'TERM_ID', 'arrx_tx.var.term_id', 'NUMBER', 15);
640: fa_rx_util_pkg.assign_column('340','CT.DOC_SEQUENCE_ID', 'DOC_SEQUENCE_ID', 'arrx_tx.var.doc_sequence_id', 'NUMBER', 15);
641: fa_rx_util_pkg.assign_column('350','CT.RECEIPT_METHOD_ID', 'RECEIPT_METHOD_ID', 'arrx_tx.var.receipt_method_id', 'NUMBER', 15);

Line 638: 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);

634: 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);
635: 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);
636: 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);
637: 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);
638: 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);
639: fa_rx_util_pkg.assign_column('330','CT.TERM_ID', 'TERM_ID', 'arrx_tx.var.term_id', 'NUMBER', 15);
640: fa_rx_util_pkg.assign_column('340','CT.DOC_SEQUENCE_ID', 'DOC_SEQUENCE_ID', 'arrx_tx.var.doc_sequence_id', 'NUMBER', 15);
641: fa_rx_util_pkg.assign_column('350','CT.RECEIPT_METHOD_ID', 'RECEIPT_METHOD_ID', 'arrx_tx.var.receipt_method_id', 'NUMBER', 15);
642: fa_rx_util_pkg.assign_column('360','CT.ORG_ID', 'ORG_ID', 'arrx_tx.var.org_id', 'NUMBER', 15);

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

635: 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);
636: 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);
637: 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);
638: 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);
639: fa_rx_util_pkg.assign_column('330','CT.TERM_ID', 'TERM_ID', 'arrx_tx.var.term_id', 'NUMBER', 15);
640: fa_rx_util_pkg.assign_column('340','CT.DOC_SEQUENCE_ID', 'DOC_SEQUENCE_ID', 'arrx_tx.var.doc_sequence_id', 'NUMBER', 15);
641: fa_rx_util_pkg.assign_column('350','CT.RECEIPT_METHOD_ID', 'RECEIPT_METHOD_ID', 'arrx_tx.var.receipt_method_id', 'NUMBER', 15);
642: fa_rx_util_pkg.assign_column('360','CT.ORG_ID', 'ORG_ID', 'arrx_tx.var.org_id', 'NUMBER', 15);
643: -- bug3940958 added batch_id and batch_source_id

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

636: 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);
637: 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);
638: 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);
639: fa_rx_util_pkg.assign_column('330','CT.TERM_ID', 'TERM_ID', 'arrx_tx.var.term_id', 'NUMBER', 15);
640: fa_rx_util_pkg.assign_column('340','CT.DOC_SEQUENCE_ID', 'DOC_SEQUENCE_ID', 'arrx_tx.var.doc_sequence_id', 'NUMBER', 15);
641: fa_rx_util_pkg.assign_column('350','CT.RECEIPT_METHOD_ID', 'RECEIPT_METHOD_ID', 'arrx_tx.var.receipt_method_id', 'NUMBER', 15);
642: fa_rx_util_pkg.assign_column('360','CT.ORG_ID', 'ORG_ID', 'arrx_tx.var.org_id', 'NUMBER', 15);
643: -- bug3940958 added batch_id and batch_source_id
644: fa_rx_util_pkg.assign_column('370','CT.BATCH_ID', 'BATCH_ID', 'arrx_tx.var.batch_id', 'NUMBER', 15);

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

637: 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);
638: 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);
639: fa_rx_util_pkg.assign_column('330','CT.TERM_ID', 'TERM_ID', 'arrx_tx.var.term_id', 'NUMBER', 15);
640: fa_rx_util_pkg.assign_column('340','CT.DOC_SEQUENCE_ID', 'DOC_SEQUENCE_ID', 'arrx_tx.var.doc_sequence_id', 'NUMBER', 15);
641: fa_rx_util_pkg.assign_column('350','CT.RECEIPT_METHOD_ID', 'RECEIPT_METHOD_ID', 'arrx_tx.var.receipt_method_id', 'NUMBER', 15);
642: fa_rx_util_pkg.assign_column('360','CT.ORG_ID', 'ORG_ID', 'arrx_tx.var.org_id', 'NUMBER', 15);
643: -- bug3940958 added batch_id and batch_source_id
644: fa_rx_util_pkg.assign_column('370','CT.BATCH_ID', 'BATCH_ID', 'arrx_tx.var.batch_id', 'NUMBER', 15);
645: fa_rx_util_pkg.assign_column('380','CT.BATCH_SOURCE_ID', 'BATCH_SOURCE_ID', 'arrx_tx.var.batch_source_id', 'NUMBER', 15);

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

638: 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);
639: fa_rx_util_pkg.assign_column('330','CT.TERM_ID', 'TERM_ID', 'arrx_tx.var.term_id', 'NUMBER', 15);
640: fa_rx_util_pkg.assign_column('340','CT.DOC_SEQUENCE_ID', 'DOC_SEQUENCE_ID', 'arrx_tx.var.doc_sequence_id', 'NUMBER', 15);
641: fa_rx_util_pkg.assign_column('350','CT.RECEIPT_METHOD_ID', 'RECEIPT_METHOD_ID', 'arrx_tx.var.receipt_method_id', 'NUMBER', 15);
642: fa_rx_util_pkg.assign_column('360','CT.ORG_ID', 'ORG_ID', 'arrx_tx.var.org_id', 'NUMBER', 15);
643: -- bug3940958 added batch_id and batch_source_id
644: fa_rx_util_pkg.assign_column('370','CT.BATCH_ID', 'BATCH_ID', 'arrx_tx.var.batch_id', 'NUMBER', 15);
645: fa_rx_util_pkg.assign_column('380','CT.BATCH_SOURCE_ID', 'BATCH_SOURCE_ID', 'arrx_tx.var.batch_source_id', 'NUMBER', 15);
646: -->>SELECT_END<<--

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

640: fa_rx_util_pkg.assign_column('340','CT.DOC_SEQUENCE_ID', 'DOC_SEQUENCE_ID', 'arrx_tx.var.doc_sequence_id', 'NUMBER', 15);
641: fa_rx_util_pkg.assign_column('350','CT.RECEIPT_METHOD_ID', 'RECEIPT_METHOD_ID', 'arrx_tx.var.receipt_method_id', 'NUMBER', 15);
642: fa_rx_util_pkg.assign_column('360','CT.ORG_ID', 'ORG_ID', 'arrx_tx.var.org_id', 'NUMBER', 15);
643: -- bug3940958 added batch_id and batch_source_id
644: fa_rx_util_pkg.assign_column('370','CT.BATCH_ID', 'BATCH_ID', 'arrx_tx.var.batch_id', 'NUMBER', 15);
645: fa_rx_util_pkg.assign_column('380','CT.BATCH_SOURCE_ID', 'BATCH_SOURCE_ID', 'arrx_tx.var.batch_source_id', 'NUMBER', 15);
646: -->>SELECT_END<<--
647:
648:

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

641: fa_rx_util_pkg.assign_column('350','CT.RECEIPT_METHOD_ID', 'RECEIPT_METHOD_ID', 'arrx_tx.var.receipt_method_id', 'NUMBER', 15);
642: fa_rx_util_pkg.assign_column('360','CT.ORG_ID', 'ORG_ID', 'arrx_tx.var.org_id', 'NUMBER', 15);
643: -- bug3940958 added batch_id and batch_source_id
644: fa_rx_util_pkg.assign_column('370','CT.BATCH_ID', 'BATCH_ID', 'arrx_tx.var.batch_id', 'NUMBER', 15);
645: fa_rx_util_pkg.assign_column('380','CT.BATCH_SOURCE_ID', 'BATCH_SOURCE_ID', 'arrx_tx.var.batch_source_id', 'NUMBER', 15);
646: -->>SELECT_END<<--
647:
648:
649: --

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

709: DOC_SEQUENCE_NUMBER_WHERE || ' ' ||
710: BATCH_SOURCE_WHERE || ' ' ||
711: REC_ACCOUNT_WHERE ;
712:
713: fa_rx_util_pkg.debug('arrx_tx.before_report()-');
714:
715: end before_report;
716:
717:

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

910: -- Customer Number parameter declarations
911: start_bill_to_customer_number varchar2(30) := NULL;
912: end_bill_to_customer_number varchar2(30) := NULL;
913: begin
914: fa_rx_util_pkg.debug('arrx_tx.artx_rep_check()+');
915:
916: --
917: -- Assign parameters to global variable
918: -- These values will be used within the before_report trigger

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

926: fa_rx_util_pkg.debug('last_updated_by = '|| var.last_updated_by);
927:
928: --
929: -- Initialize request
930: fa_rx_util_pkg.init_request('arrx_tx.artx_rep_check',request_id,'AR_TRANSACTIONS_REP_ITF');
931:
932: --
933: -- Call the main journal report
934:

Line 936: arrx_tx.artx_rep(

932: --
933: -- Call the main journal report
934:
935: -- bug3940958 added some parameters
936: arrx_tx.artx_rep(
937: completed_flag,
938: posted_flag,
939: start_gl_date,
940: end_gl_date,

Line 975: 'arrx_tx.check_before_report;',

971: -- Assign triggers specific to this report
972: -- Make sure that you make your assignment to the correct section ('AR TRANSACTION')
973: fa_rx_util_pkg.assign_report('AR TRANSACTIONS',
974: true,
975: 'arrx_tx.check_before_report;',
976: 'arrx_tx.check_bind(:CURSOR_SELECT);',
977: 'arrx_tx.check_after_fetch;',
978: null);
979:

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

972: -- Make sure that you make your assignment to the correct section ('AR TRANSACTION')
973: fa_rx_util_pkg.assign_report('AR TRANSACTIONS',
974: true,
975: 'arrx_tx.check_before_report;',
976: 'arrx_tx.check_bind(:CURSOR_SELECT);',
977: 'arrx_tx.check_after_fetch;',
978: null);
979:
980: --

Line 977: 'arrx_tx.check_after_fetch;',

973: fa_rx_util_pkg.assign_report('AR TRANSACTIONS',
974: true,
975: 'arrx_tx.check_before_report;',
976: 'arrx_tx.check_bind(:CURSOR_SELECT);',
977: 'arrx_tx.check_after_fetch;',
978: null);
979:
980: --
981: -- Run the report.

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

978: null);
979:
980: --
981: -- Run the report.
982: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_tx.artx_rep_check')
983: fa_rx_util_pkg.run_report('arrx_tx.artx_rep_check', retcode, errbuf);
984:
985: fa_rx_util_pkg.debug('arrx_tx.artx_rep_check()-');
986:

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

979:
980: --
981: -- Run the report.
982: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_tx.artx_rep_check')
983: fa_rx_util_pkg.run_report('arrx_tx.artx_rep_check', retcode, errbuf);
984:
985: fa_rx_util_pkg.debug('arrx_tx.artx_rep_check()-');
986:
987: exception

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

981: -- Run the report.
982: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_tx.artx_rep_check')
983: fa_rx_util_pkg.run_report('arrx_tx.artx_rep_check', retcode, errbuf);
984:
985: fa_rx_util_pkg.debug('arrx_tx.artx_rep_check()-');
986:
987: exception
988: when others then
989: fa_rx_util_pkg.log(sqlcode);

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

989: fa_rx_util_pkg.log(sqlcode);
990: fa_rx_util_pkg.log(sqlerrm);
991: fa_rx_util_pkg.debug(sqlcode);
992: fa_rx_util_pkg.debug(sqlerrm);
993: fa_rx_util_pkg.debug('arrx_tx.artx_rep_check(EXCEPTION)-');
994: end artx_rep_check;
995:
996:
997: --

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

1005: decode_inv varchar2(500);
1006: get_item varchar2(500);
1007: LAST_UPDATE_WHERE varchar2(500);
1008: begin
1009: fa_rx_util_pkg.debug('arrx_tx.check_before_report()+');
1010:
1011: fa_rx_util_pkg.debug('GL_GET_PROFILE_SO_FLEX_CODE');
1012:
1013: oe_profile.get(

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

1063: --
1064: -- Assign another column specific to this report
1065: fa_rx_util_pkg.debug('AR_ADD_SELECT_COLUMNS');
1066:
1067: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');
1068: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1069: 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');
1070: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1071: 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 1068: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');

1064: -- Assign another column specific to this report
1065: fa_rx_util_pkg.debug('AR_ADD_SELECT_COLUMNS');
1066:
1067: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');
1068: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1069: 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');
1070: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1071: 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');
1072: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);

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

1065: fa_rx_util_pkg.debug('AR_ADD_SELECT_COLUMNS');
1066:
1067: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');
1068: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1069: 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');
1070: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1071: 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');
1072: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1073: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);

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

1066:
1067: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');
1068: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1069: 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');
1070: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1071: 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');
1072: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1073: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1074: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);

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

1067: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');
1068: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1069: 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');
1070: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1071: 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');
1072: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1073: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1074: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1075: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);

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

1068: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1069: 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');
1070: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1071: 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');
1072: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1073: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1074: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1075: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1076: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);

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

1069: 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');
1070: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1071: 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');
1072: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1073: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1074: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1075: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1076: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);
1077: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);

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

1070: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1071: 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');
1072: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1073: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1074: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1075: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1076: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);
1077: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);
1078:

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

1071: 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');
1072: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1073: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1074: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1075: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1076: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);
1077: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);
1078:
1079: --

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

1072: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1073: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1074: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1075: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1076: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);
1077: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);
1078:
1079: --
1080: -- Add to the FROM clause specific to this report

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

1073: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1074: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1075: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1076: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);
1077: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);
1078:
1079: --
1080: -- Add to the FROM clause specific to this report
1081: fa_rx_util_pkg.debug('AR_ADD_FORM_CLAUSE');

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

1091: -- Add to the WHERE clause specific to this report
1092: fa_rx_util_pkg.debug('AR_ADD_WHERE_CLAUSE');
1093:
1094: IF var.last_updated_by is null THEN
1095: LAST_UPDATE_WHERE := ' AND ARRX_TX.WHERE_LAST_UPDATE(CT.CUSTOMER_TRX_ID,null,
1096: :start_update_date,:end_update_date) = ''Y'' ';
1097: ELSE
1098: LAST_UPDATE_WHERE := ' AND ARRX_TX.WHERE_LAST_UPDATE(CT.CUSTOMER_TRX_ID,'|| var.last_updated_by ||',
1099: :start_update_date,:end_update_date) = ''Y'' ';

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

1094: IF var.last_updated_by is null THEN
1095: LAST_UPDATE_WHERE := ' AND ARRX_TX.WHERE_LAST_UPDATE(CT.CUSTOMER_TRX_ID,null,
1096: :start_update_date,:end_update_date) = ''Y'' ';
1097: ELSE
1098: LAST_UPDATE_WHERE := ' AND ARRX_TX.WHERE_LAST_UPDATE(CT.CUSTOMER_TRX_ID,'|| var.last_updated_by ||',
1099: :start_update_date,:end_update_date) = ''Y'' ';
1100: END IF;
1101:
1102: fa_rx_util_pkg.Where_Clause :=

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

1110: AND DIST.ACCOUNT_SET_FLAG = ''N''
1111: AND DIST.CODE_COMBINATION_ID = CCDIST.CODE_COMBINATION_ID '||
1112: LAST_UPDATE_WHERE;
1113:
1114: fa_rx_util_pkg.debug('arrx_tx.check_before_report()-');
1115:
1116: end check_before_report;
1117:
1118:

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

1223: start_bill_to_customer_number varchar2(30) := NULL;
1224: end_bill_to_customer_number varchar2(30) := NULL;
1225:
1226: begin
1227: fa_rx_util_pkg.debug('arrx_tx.artx_rep_forecast()+');
1228:
1229: --
1230: -- Assign parameters to global variable
1231: -- These values will be used within the before_report trigger

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

1237: fa_rx_util_pkg.debug('end_due_date = '|| var.end_due_date);
1238:
1239: --
1240: -- Initialize request
1241: fa_rx_util_pkg.init_request('arrx_tx.artx_rep_forecast',request_id,'AR_TRANSACTIONS_REP_ITF');
1242:
1243: --
1244: -- Call the main journal report
1245:

Line 1247: arrx_tx.artx_rep(

1243: --
1244: -- Call the main journal report
1245:
1246: -- bug3940958 added some parameters
1247: arrx_tx.artx_rep(
1248: completed_flag,
1249: posted_flag,
1250: start_gl_date,
1251: end_gl_date,

Line 1285: 'arrx_tx.forecast_before_report;',

1281: -- Assign triggers specific to this report
1282: -- Make sure that you make your assignment to the correct section ('AR TRANSACTION')
1283: fa_rx_util_pkg.assign_report('AR TRANSACTIONS',
1284: true,
1285: 'arrx_tx.forecast_before_report;',
1286: 'arrx_tx.forecast_bind(:CURSOR_SELECT);',
1287: null,
1288: null);
1289:

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

1282: -- Make sure that you make your assignment to the correct section ('AR TRANSACTION')
1283: fa_rx_util_pkg.assign_report('AR TRANSACTIONS',
1284: true,
1285: 'arrx_tx.forecast_before_report;',
1286: 'arrx_tx.forecast_bind(:CURSOR_SELECT);',
1287: null,
1288: null);
1289:
1290: --

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

1288: null);
1289:
1290: --
1291: -- Run the report.
1292: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_tx.artx_rep_forecast')
1293: fa_rx_util_pkg.run_report('arrx_tx.artx_rep_forecast', retcode, errbuf);
1294:
1295: fa_rx_util_pkg.debug('arrx_tx.artx_rep_forecast()-');
1296:

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

1289:
1290: --
1291: -- Run the report.
1292: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_tx.artx_rep_forecast')
1293: fa_rx_util_pkg.run_report('arrx_tx.artx_rep_forecast', retcode, errbuf);
1294:
1295: fa_rx_util_pkg.debug('arrx_tx.artx_rep_forecast()-');
1296:
1297: exception

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

1291: -- Run the report.
1292: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_tx.artx_rep_forecast')
1293: fa_rx_util_pkg.run_report('arrx_tx.artx_rep_forecast', retcode, errbuf);
1294:
1295: fa_rx_util_pkg.debug('arrx_tx.artx_rep_forecast()-');
1296:
1297: exception
1298: when others then
1299: fa_rx_util_pkg.log(sqlcode);

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

1299: fa_rx_util_pkg.log(sqlcode);
1300: fa_rx_util_pkg.log(sqlerrm);
1301: fa_rx_util_pkg.debug(sqlcode);
1302: fa_rx_util_pkg.debug(sqlerrm);
1303: fa_rx_util_pkg.debug('arrx_tx.artx_rep_forecast(EXCEPTION)-');
1304: end artx_rep_forecast;
1305:
1306: --
1307: -- This is the before report trigger for the artx_rep_forecast report.

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

1308: procedure forecast_before_report
1309: is
1310: SCHEDULE_DUE_DATE_WHERE varchar2(500);
1311: begin
1312: fa_rx_util_pkg.debug('arrx_tx.forecast_before_report()+');
1313:
1314: --
1315: -- Assign another column specific to this report
1316: fa_rx_util_pkg.debug('AR_ADD_SELECT_COLUMNS');

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

1314: --
1315: -- Assign another column specific to this report
1316: fa_rx_util_pkg.debug('AR_ADD_SELECT_COLUMNS');
1317:
1318: fa_rx_util_pkg.assign_column('f1 ','PS.PAYMENT_SCHEDULE_ID', 'TRX_PAYMENT_SCHEDULE_ID', 'arrx_tx.var.trx_payment_schedule_id', 'NUMBER');
1319: fa_rx_util_pkg.assign_column('60 ','CONS_INV.CONS_BILLING_NUMBER', 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);
1320:
1321: --
1322: -- Add to the FROM clause specific to this report

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

1315: -- Assign another column specific to this report
1316: fa_rx_util_pkg.debug('AR_ADD_SELECT_COLUMNS');
1317:
1318: fa_rx_util_pkg.assign_column('f1 ','PS.PAYMENT_SCHEDULE_ID', 'TRX_PAYMENT_SCHEDULE_ID', 'arrx_tx.var.trx_payment_schedule_id', 'NUMBER');
1319: fa_rx_util_pkg.assign_column('60 ','CONS_INV.CONS_BILLING_NUMBER', 'CONS_BILL_NUMBER', 'arrx_tx.var.cons_bill_number', 'VARCHAR2', 30);
1320:
1321: --
1322: -- Add to the FROM clause specific to this report
1323: fa_rx_util_pkg.debug('AR_ADD_FORM_CLAUSE');

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

1346: AND PS.STATUS = ''OP''
1347: AND PS.CONS_INV_ID = CONS_INV.CONS_INV_ID(+) '||
1348: SCHEDULE_DUE_DATE_WHERE;
1349:
1350: fa_rx_util_pkg.debug('arrx_tx.forecast_before_report()-');
1351:
1352: end forecast_before_report;
1353:
1354:

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

1412: end_transaction_class varchar2(20) := NULL;
1413: payment_method varchar2(30) := NULL;
1414:
1415: begin
1416: fa_rx_util_pkg.debug('arrx_tx.artx_sales_rep()+');
1417: --
1418: -- Set global variables (This variable will be used in before report trigger.)
1419: --
1420: var.line_invoice := line_invoice;

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

1428: var.end_amount := end_amount;
1429:
1430: --
1431: -- Initialize request
1432: fa_rx_util_pkg.init_request('arrx_tx.artx_sales_rep',request_id,'AR_TRANSACTIONS_REP_ITF');
1433:
1434: --
1435: -- Call the main journal report
1436:

Line 1438: arrx_tx.artx_rep(

1434: --
1435: -- Call the main journal report
1436:
1437: -- bug3940958 added new parameters
1438: arrx_tx.artx_rep(
1439: completed_flag,
1440: posted_flag,
1441: start_gl_date,
1442: end_gl_date,

Line 1476: 'arrx_tx.sales_before_report;',

1472: -- Assign triggers specific to this report
1473: -- Make sure that you make your assignment to the correct section ('AR TRANSACTION')
1474: fa_rx_util_pkg.assign_report('AR TRANSACTIONS',
1475: true,
1476: 'arrx_tx.sales_before_report;',
1477: 'arrx_tx.sales_bind(:CURSOR_SELECT);',
1478: 'arrx_tx.sales_after_fetch;',
1479: null);
1480:

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

1473: -- Make sure that you make your assignment to the correct section ('AR TRANSACTION')
1474: fa_rx_util_pkg.assign_report('AR TRANSACTIONS',
1475: true,
1476: 'arrx_tx.sales_before_report;',
1477: 'arrx_tx.sales_bind(:CURSOR_SELECT);',
1478: 'arrx_tx.sales_after_fetch;',
1479: null);
1480:
1481: --

Line 1478: 'arrx_tx.sales_after_fetch;',

1474: fa_rx_util_pkg.assign_report('AR TRANSACTIONS',
1475: true,
1476: 'arrx_tx.sales_before_report;',
1477: 'arrx_tx.sales_bind(:CURSOR_SELECT);',
1478: 'arrx_tx.sales_after_fetch;',
1479: null);
1480:
1481: --
1482: -- Run the report.

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

1479: null);
1480:
1481: --
1482: -- Run the report.
1483: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_tx.artx_sales_rep')
1484: fa_rx_util_pkg.run_report('arrx_tx.artx_sales_rep', retcode, errbuf);
1485:
1486: fa_rx_util_pkg.debug('arrx_tx.artx_sales_rep()-');
1487:

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

1480:
1481: --
1482: -- Run the report.
1483: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_tx.artx_sales_rep')
1484: fa_rx_util_pkg.run_report('arrx_tx.artx_sales_rep', retcode, errbuf);
1485:
1486: fa_rx_util_pkg.debug('arrx_tx.artx_sales_rep()-');
1487:
1488: exception

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

1482: -- Run the report.
1483: -- Make sure to pass the p_calling_proc assigned from within this procedure ('arrx_tx.artx_sales_rep')
1484: fa_rx_util_pkg.run_report('arrx_tx.artx_sales_rep', retcode, errbuf);
1485:
1486: fa_rx_util_pkg.debug('arrx_tx.artx_sales_rep()-');
1487:
1488: exception
1489: when others then
1490: fa_rx_util_pkg.log(sqlcode);

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

1490: fa_rx_util_pkg.log(sqlcode);
1491: fa_rx_util_pkg.log(sqlerrm);
1492: fa_rx_util_pkg.debug(sqlcode);
1493: fa_rx_util_pkg.debug(sqlerrm);
1494: fa_rx_util_pkg.debug('arrx_tx.artx_sales_rep(EXCEPTION)-');
1495: end artx_sales_rep;
1496:
1497:
1498: --

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

1513: amount_where varchar2(1000); -- where-clause statement for line amounts
1514: line_select_statement varchar2(1000); -- where-clause statement for sub-query of line information
1515:
1516: begin
1517: fa_rx_util_pkg.debug('arrx_tx.sales_before_report()+');
1518:
1519: fa_rx_util_pkg.debug('GL_GET_PROFILE_SO_FLEX_CODE');
1520:
1521: oe_profile.get(

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

1723: --
1724: -- Assign another column specific to this report
1725: fa_rx_util_pkg.debug('AR_ADD_SELECT_COLUMNS');
1726:
1727: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');
1728: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1729: 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');
1730: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1731: 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 1728: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');

1724: -- Assign another column specific to this report
1725: fa_rx_util_pkg.debug('AR_ADD_SELECT_COLUMNS');
1726:
1727: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');
1728: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1729: 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');
1730: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1731: 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');
1732: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);

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

1725: fa_rx_util_pkg.debug('AR_ADD_SELECT_COLUMNS');
1726:
1727: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');
1728: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1729: 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');
1730: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1731: 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');
1732: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1733: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);

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

1726:
1727: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');
1728: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1729: 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');
1730: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1731: 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');
1732: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1733: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1734: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);

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

1727: fa_rx_util_pkg.assign_column('c1 ','CCDIST.CODE_COMBINATION_ID', null, 'arrx_tx.var.ccid2', 'NUMBER');
1728: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1729: 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');
1730: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1731: 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');
1732: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1733: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1734: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1735: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);

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

1728: fa_rx_util_pkg.assign_column('c2 ','CTL.CUSTOMER_TRX_LINE_ID', 'CUSTOMER_TRX_LINE_ID', 'arrx_tx.var.customer_trx_line_id', 'NUMBER');
1729: 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');
1730: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1731: 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');
1732: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1733: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1734: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1735: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1736: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);

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

1729: 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');
1730: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1731: 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');
1732: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1733: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1734: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1735: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1736: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);
1737: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);

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

1730: fa_rx_util_pkg.assign_column('c4 ',decode_inv, 'INVENTORY_ITEM', 'arrx_tx.var.inventory_item', 'VARCHAR2',240);
1731: 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');
1732: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1733: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1734: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1735: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1736: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);
1737: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);
1738: fa_rx_util_pkg.assign_column('c12','ITEM.DESCRIPTION', 'ITEM_DESCRIPTION', 'arrx_tx.var.item_description', 'VARCHAR2',240);

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

1731: 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');
1732: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1733: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1734: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1735: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1736: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);
1737: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);
1738: fa_rx_util_pkg.assign_column('c12','ITEM.DESCRIPTION', 'ITEM_DESCRIPTION', 'arrx_tx.var.item_description', 'VARCHAR2',240);
1739:

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

1732: fa_rx_util_pkg.assign_column('c6 ',CC_ACCOUNT_SEL, 'ACCOUNT', 'arrx_tx.var.account', 'VARCHAR2',240);
1733: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1734: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1735: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1736: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);
1737: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);
1738: fa_rx_util_pkg.assign_column('c12','ITEM.DESCRIPTION', 'ITEM_DESCRIPTION', 'arrx_tx.var.item_description', 'VARCHAR2',240);
1739:
1740: --

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

1733: fa_rx_util_pkg.assign_column('c7 ',null, 'ACCOUNT_DESC', 'arrx_tx.var.account_desc', 'VARCHAR2',240);
1734: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1735: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1736: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);
1737: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);
1738: fa_rx_util_pkg.assign_column('c12','ITEM.DESCRIPTION', 'ITEM_DESCRIPTION', 'arrx_tx.var.item_description', 'VARCHAR2',240);
1739:
1740: --
1741: -- Add to the FROM clause specific to this report

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

1734: fa_rx_util_pkg.assign_column('c8 ',CC_BALANCE_SEL, 'BALANCE', 'arrx_tx.var.balance', 'VARCHAR2',240);
1735: fa_rx_util_pkg.assign_column('c9 ',null, 'BALANCE_DESC', 'arrx_tx.var.balance_desc', 'VARCHAR2',240);
1736: fa_rx_util_pkg.assign_column('c10',CC_NATURAL_SEL, 'NATACCT', 'arrx_tx.var.natacct', 'VARCHAR2',240);
1737: fa_rx_util_pkg.assign_column('c11',null, 'NATACCT_DESC', 'arrx_tx.var.natacct_desc', 'VARCHAR2',240);
1738: fa_rx_util_pkg.assign_column('c12','ITEM.DESCRIPTION', 'ITEM_DESCRIPTION', 'arrx_tx.var.item_description', 'VARCHAR2',240);
1739:
1740: --
1741: -- Add to the FROM clause specific to this report
1742: fa_rx_util_pkg.debug('AR_ADD_FORM_CLAUSE');

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

1804: AND DIST.ACCOUNT_SET_FLAG = ''N''
1805: AND DIST.CODE_COMBINATION_ID = CCDIST.CODE_COMBINATION_ID ';
1806: end if;
1807:
1808: fa_rx_util_pkg.debug('arrx_tx.sales_before_report()-');
1809:
1810: end sales_before_report;
1811:
1812: procedure sales_bind(c in integer)

Line 1994: end ARRX_TX;

1990:
1991: return 'N';
1992: end WHERE_LAST_UPDATE;
1993:
1994: end ARRX_TX;