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.APRX_WT dependencies on FA_RX_UTIL_PKG

Line 27: fa_rx_util_pkg.debug('aprx_wt.get_witholding_tax()+');

23: )
24: IS
25: BEGIN
26:
27: fa_rx_util_pkg.debug('aprx_wt.get_witholding_tax()+');
28:
29: -- Initialize request
30:
31: fa_rx_util_pkg.init_request('aprx_wt.get_witholding_tax', request_id);

Line 31: fa_rx_util_pkg.init_request('aprx_wt.get_witholding_tax', request_id);

27: fa_rx_util_pkg.debug('aprx_wt.get_witholding_tax()+');
28:
29: -- Initialize request
30:
31: fa_rx_util_pkg.init_request('aprx_wt.get_witholding_tax', request_id);
32:
33: fa_rx_util_pkg.assign_report(section_name,
34: true,
35: 'aprx_wt.before_report;',

Line 33: fa_rx_util_pkg.assign_report(section_name,

29: -- Initialize request
30:
31: fa_rx_util_pkg.init_request('aprx_wt.get_witholding_tax', request_id);
32:
33: fa_rx_util_pkg.assign_report(section_name,
34: true,
35: 'aprx_wt.before_report;',
36: NULL,
37: NULL,

Line 40: fa_rx_util_pkg.run_report('aprx_wt.get_witholding_tax', retcode, errbuf);

36: NULL,
37: NULL,
38: NULL);
39:
40: fa_rx_util_pkg.run_report('aprx_wt.get_witholding_tax', retcode, errbuf);
41:
42: fa_rx_util_pkg.debug('aprx_wt.get_witholding_tax()-');
43:
44: END GET_WITHOLDING_TAX;

Line 42: fa_rx_util_pkg.debug('aprx_wt.get_witholding_tax()-');

38: NULL);
39:
40: fa_rx_util_pkg.run_report('aprx_wt.get_witholding_tax', retcode, errbuf);
41:
42: fa_rx_util_pkg.debug('aprx_wt.get_witholding_tax()-');
43:
44: END GET_WITHOLDING_TAX;
45:
46: -- This procedure is a plug-in for the (Tax Letter) Report

Line 60: fa_rx_util_pkg.debug('aprx_wt.ap_wht_tax_report()+');

56: errbuf out NOCOPY varchar2
57: )
58: IS
59: BEGIN
60: fa_rx_util_pkg.debug('aprx_wt.ap_wht_tax_report()+');
61: fa_rx_util_pkg.debug('p_date_from '||p_date_from);
62: fa_rx_util_pkg.debug('canonical date from '||to_char(fnd_date.canonical_to_date(p_date_from)));
63: fa_rx_util_pkg.init_request('aprx_wt.ap_wht_tax_report', request_id);
64:

Line 61: fa_rx_util_pkg.debug('p_date_from '||p_date_from);

57: )
58: IS
59: BEGIN
60: fa_rx_util_pkg.debug('aprx_wt.ap_wht_tax_report()+');
61: fa_rx_util_pkg.debug('p_date_from '||p_date_from);
62: fa_rx_util_pkg.debug('canonical date from '||to_char(fnd_date.canonical_to_date(p_date_from)));
63: fa_rx_util_pkg.init_request('aprx_wt.ap_wht_tax_report', request_id);
64:
65: -- Store the paremters in a variable which can be accesed globally accross all procedures

Line 62: fa_rx_util_pkg.debug('canonical date from '||to_char(fnd_date.canonical_to_date(p_date_from)));

58: IS
59: BEGIN
60: fa_rx_util_pkg.debug('aprx_wt.ap_wht_tax_report()+');
61: fa_rx_util_pkg.debug('p_date_from '||p_date_from);
62: fa_rx_util_pkg.debug('canonical date from '||to_char(fnd_date.canonical_to_date(p_date_from)));
63: fa_rx_util_pkg.init_request('aprx_wt.ap_wht_tax_report', request_id);
64:
65: -- Store the paremters in a variable which can be accesed globally accross all procedures
66: parm.p_date_from := p_date_from;

Line 63: fa_rx_util_pkg.init_request('aprx_wt.ap_wht_tax_report', request_id);

59: BEGIN
60: fa_rx_util_pkg.debug('aprx_wt.ap_wht_tax_report()+');
61: fa_rx_util_pkg.debug('p_date_from '||p_date_from);
62: fa_rx_util_pkg.debug('canonical date from '||to_char(fnd_date.canonical_to_date(p_date_from)));
63: fa_rx_util_pkg.init_request('aprx_wt.ap_wht_tax_report', request_id);
64:
65: -- Store the paremters in a variable which can be accesed globally accross all procedures
66: parm.p_date_from := p_date_from;
67: parm.p_date_to := p_date_to;

Line 83: fa_rx_util_pkg.assign_report('get_witholding_tax',

79: retcode,
80: errbuf);
81:
82: -- Continue with the execution of the plug-in
83: fa_rx_util_pkg.assign_report('get_witholding_tax',
84: true,
85: 'aprx_wt.awt_before_report;',
86: 'aprx_wt.awt_bind(:CURSOR_SELECT);',
87: NULL, null);

Line 89: fa_rx_util_pkg.run_report('aprx_wt.ap_wht_tax_report', retcode, errbuf);

85: 'aprx_wt.awt_before_report;',
86: 'aprx_wt.awt_bind(:CURSOR_SELECT);',
87: NULL, null);
88:
89: fa_rx_util_pkg.run_report('aprx_wt.ap_wht_tax_report', retcode, errbuf);
90:
91: fa_rx_util_pkg.debug('aprx_wt.ap_wht_tax_report()-');
92:
93: END ap_wht_tax_report;

Line 91: fa_rx_util_pkg.debug('aprx_wt.ap_wht_tax_report()-');

87: NULL, null);
88:
89: fa_rx_util_pkg.run_report('aprx_wt.ap_wht_tax_report', retcode, errbuf);
90:
91: fa_rx_util_pkg.debug('aprx_wt.ap_wht_tax_report()-');
92:
93: END ap_wht_tax_report;
94:
95: /*=======================================================================================================

Line 109: fa_rx_util_pkg.debug('aprx_wt.before_report()+');

105:
106: PROCEDURE before_report
107: IS
108: BEGIN
109: fa_rx_util_pkg.debug('aprx_wt.before_report()+');
110:
111:
112: fa_rx_util_pkg.debug('GL_SET_OF_BKS_ID');
113:

Line 112: fa_rx_util_pkg.debug('GL_SET_OF_BKS_ID');

108: BEGIN
109: fa_rx_util_pkg.debug('aprx_wt.before_report()+');
110:
111:
112: fa_rx_util_pkg.debug('GL_SET_OF_BKS_ID');
113:
114: --
115: -- Get Profile GL_SET_OF_BKS_ID
116: --

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

113:
114: --
115: -- Get Profile GL_SET_OF_BKS_ID
116: --
117: fa_rx_util_pkg.debug('GL_GET_PROFILE_BKS_ID');
118: fnd_profile.get(
119: name => 'GL_SET_OF_BKS_ID',
120: val => var.books_id);
121:

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

121:
122: --
123: -- Get CHART_OF_ACCOUNTS_ID
124: --
125: fa_rx_util_pkg.debug('GL_GET_CHART_OF_ACCOUNTS_ID');
126:
127: select CURRENCY_CODE,NAME
128: into var.functional_currency_code
129: , var.organization_name

Line 181: -- fa_rx_util_pkg.assign_column(#, select, insert, place, type, len);

177:
178: --Assign SELECT list
179: -- the Select statement is build over here
180:
181: -- fa_rx_util_pkg.assign_column(#, select, insert, place, type, len);
182:
183: -->>SELECT_START<<--
184:
185: fa_rx_util_pkg.assign_column('1', 'pv1.vendor_name', 'tax_authority','aprx_wt.var.tax_authority','VARCHAR2', 240);

Line 185: fa_rx_util_pkg.assign_column('1', 'pv1.vendor_name', 'tax_authority','aprx_wt.var.tax_authority','VARCHAR2', 240);

181: -- fa_rx_util_pkg.assign_column(#, select, insert, place, type, len);
182:
183: -->>SELECT_START<<--
184:
185: fa_rx_util_pkg.assign_column('1', 'pv1.vendor_name', 'tax_authority','aprx_wt.var.tax_authority','VARCHAR2', 240);
186:
187: fa_rx_util_pkg.assign_column('2', 'pv2.vendor_type_lookup_code', 'supplier_type','aprx_wt.var.supplier_type','VARCHAR2',25);
188:
189: fa_rx_util_pkg.assign_column('3', 'pv2.vendor_name', 'supplier_name', 'aprx_wt.var.supplier_name','VARCHAR2',240);

Line 187: fa_rx_util_pkg.assign_column('2', 'pv2.vendor_type_lookup_code', 'supplier_type','aprx_wt.var.supplier_type','VARCHAR2',25);

183: -->>SELECT_START<<--
184:
185: fa_rx_util_pkg.assign_column('1', 'pv1.vendor_name', 'tax_authority','aprx_wt.var.tax_authority','VARCHAR2', 240);
186:
187: fa_rx_util_pkg.assign_column('2', 'pv2.vendor_type_lookup_code', 'supplier_type','aprx_wt.var.supplier_type','VARCHAR2',25);
188:
189: fa_rx_util_pkg.assign_column('3', 'pv2.vendor_name', 'supplier_name', 'aprx_wt.var.supplier_name','VARCHAR2',240);
190:
191: fa_rx_util_pkg.assign_column('4', 'pv2.num_1099', 'taxpayer_id','aprx_wt.var.taxpayer_id','VARCHAR2',30);

Line 189: fa_rx_util_pkg.assign_column('3', 'pv2.vendor_name', 'supplier_name', 'aprx_wt.var.supplier_name','VARCHAR2',240);

185: fa_rx_util_pkg.assign_column('1', 'pv1.vendor_name', 'tax_authority','aprx_wt.var.tax_authority','VARCHAR2', 240);
186:
187: fa_rx_util_pkg.assign_column('2', 'pv2.vendor_type_lookup_code', 'supplier_type','aprx_wt.var.supplier_type','VARCHAR2',25);
188:
189: fa_rx_util_pkg.assign_column('3', 'pv2.vendor_name', 'supplier_name', 'aprx_wt.var.supplier_name','VARCHAR2',240);
190:
191: fa_rx_util_pkg.assign_column('4', 'pv2.num_1099', 'taxpayer_id','aprx_wt.var.taxpayer_id','VARCHAR2',30);
192:
193: fa_rx_util_pkg.assign_column('5', 'pv2.segment1', 'supplier_number', 'aprx_wt.var.supplier_number','VARCHAR2',30);

Line 191: fa_rx_util_pkg.assign_column('4', 'pv2.num_1099', 'taxpayer_id','aprx_wt.var.taxpayer_id','VARCHAR2',30);

187: fa_rx_util_pkg.assign_column('2', 'pv2.vendor_type_lookup_code', 'supplier_type','aprx_wt.var.supplier_type','VARCHAR2',25);
188:
189: fa_rx_util_pkg.assign_column('3', 'pv2.vendor_name', 'supplier_name', 'aprx_wt.var.supplier_name','VARCHAR2',240);
190:
191: fa_rx_util_pkg.assign_column('4', 'pv2.num_1099', 'taxpayer_id','aprx_wt.var.taxpayer_id','VARCHAR2',30);
192:
193: fa_rx_util_pkg.assign_column('5', 'pv2.segment1', 'supplier_number', 'aprx_wt.var.supplier_number','VARCHAR2',30);
194:
195: fa_rx_util_pkg.assign_column('6', 'pvs.vendor_site_code', 'supplier_site_code', 'aprx_wt.var.supplier_site_code','VARCHAR2',15);

Line 193: fa_rx_util_pkg.assign_column('5', 'pv2.segment1', 'supplier_number', 'aprx_wt.var.supplier_number','VARCHAR2',30);

189: fa_rx_util_pkg.assign_column('3', 'pv2.vendor_name', 'supplier_name', 'aprx_wt.var.supplier_name','VARCHAR2',240);
190:
191: fa_rx_util_pkg.assign_column('4', 'pv2.num_1099', 'taxpayer_id','aprx_wt.var.taxpayer_id','VARCHAR2',30);
192:
193: fa_rx_util_pkg.assign_column('5', 'pv2.segment1', 'supplier_number', 'aprx_wt.var.supplier_number','VARCHAR2',30);
194:
195: fa_rx_util_pkg.assign_column('6', 'pvs.vendor_site_code', 'supplier_site_code', 'aprx_wt.var.supplier_site_code','VARCHAR2',15);
196:
197: fa_rx_util_pkg.assign_column('7', 'pvs.vat_registration_num', 'vat_registration_number', 'aprx_wt.var.vat_registration_number','VARCHAR2',20);

Line 195: fa_rx_util_pkg.assign_column('6', 'pvs.vendor_site_code', 'supplier_site_code', 'aprx_wt.var.supplier_site_code','VARCHAR2',15);

191: fa_rx_util_pkg.assign_column('4', 'pv2.num_1099', 'taxpayer_id','aprx_wt.var.taxpayer_id','VARCHAR2',30);
192:
193: fa_rx_util_pkg.assign_column('5', 'pv2.segment1', 'supplier_number', 'aprx_wt.var.supplier_number','VARCHAR2',30);
194:
195: fa_rx_util_pkg.assign_column('6', 'pvs.vendor_site_code', 'supplier_site_code', 'aprx_wt.var.supplier_site_code','VARCHAR2',15);
196:
197: fa_rx_util_pkg.assign_column('7', 'pvs.vat_registration_num', 'vat_registration_number', 'aprx_wt.var.vat_registration_number','VARCHAR2',20);
198:
199:

Line 197: fa_rx_util_pkg.assign_column('7', 'pvs.vat_registration_num', 'vat_registration_number', 'aprx_wt.var.vat_registration_number','VARCHAR2',20);

193: fa_rx_util_pkg.assign_column('5', 'pv2.segment1', 'supplier_number', 'aprx_wt.var.supplier_number','VARCHAR2',30);
194:
195: fa_rx_util_pkg.assign_column('6', 'pvs.vendor_site_code', 'supplier_site_code', 'aprx_wt.var.supplier_site_code','VARCHAR2',15);
196:
197: fa_rx_util_pkg.assign_column('7', 'pvs.vat_registration_num', 'vat_registration_number', 'aprx_wt.var.vat_registration_number','VARCHAR2',20);
198:
199:
200: fa_rx_util_pkg.assign_column('8', 'pvs.address_line1', 'supplier_address_line1', 'aprx_wt.var.supplier_address_line1','VARCHAR2',240);
201:

Line 200: fa_rx_util_pkg.assign_column('8', 'pvs.address_line1', 'supplier_address_line1', 'aprx_wt.var.supplier_address_line1','VARCHAR2',240);

196:
197: fa_rx_util_pkg.assign_column('7', 'pvs.vat_registration_num', 'vat_registration_number', 'aprx_wt.var.vat_registration_number','VARCHAR2',20);
198:
199:
200: fa_rx_util_pkg.assign_column('8', 'pvs.address_line1', 'supplier_address_line1', 'aprx_wt.var.supplier_address_line1','VARCHAR2',240);
201:
202: fa_rx_util_pkg.assign_column('9', 'pvs.address_line2', 'supplier_address_line2', 'aprx_wt.var.supplier_address_line2','VARCHAR2',240);
203:
204: fa_rx_util_pkg.assign_column('10', 'pvs.address_line3', 'supplier_address_line3', 'aprx_wt.var.supplier_address_line3','VARCHAR2',240);

Line 202: fa_rx_util_pkg.assign_column('9', 'pvs.address_line2', 'supplier_address_line2', 'aprx_wt.var.supplier_address_line2','VARCHAR2',240);

198:
199:
200: fa_rx_util_pkg.assign_column('8', 'pvs.address_line1', 'supplier_address_line1', 'aprx_wt.var.supplier_address_line1','VARCHAR2',240);
201:
202: fa_rx_util_pkg.assign_column('9', 'pvs.address_line2', 'supplier_address_line2', 'aprx_wt.var.supplier_address_line2','VARCHAR2',240);
203:
204: fa_rx_util_pkg.assign_column('10', 'pvs.address_line3', 'supplier_address_line3', 'aprx_wt.var.supplier_address_line3','VARCHAR2',240);
205:
206: fa_rx_util_pkg.assign_column('11', 'pvs.city', 'supplier_city', 'aprx_wt.var.supplier_city','VARCHAR2',25);

Line 204: fa_rx_util_pkg.assign_column('10', 'pvs.address_line3', 'supplier_address_line3', 'aprx_wt.var.supplier_address_line3','VARCHAR2',240);

200: fa_rx_util_pkg.assign_column('8', 'pvs.address_line1', 'supplier_address_line1', 'aprx_wt.var.supplier_address_line1','VARCHAR2',240);
201:
202: fa_rx_util_pkg.assign_column('9', 'pvs.address_line2', 'supplier_address_line2', 'aprx_wt.var.supplier_address_line2','VARCHAR2',240);
203:
204: fa_rx_util_pkg.assign_column('10', 'pvs.address_line3', 'supplier_address_line3', 'aprx_wt.var.supplier_address_line3','VARCHAR2',240);
205:
206: fa_rx_util_pkg.assign_column('11', 'pvs.city', 'supplier_city', 'aprx_wt.var.supplier_city','VARCHAR2',25);
207:
208: fa_rx_util_pkg.assign_column('12', 'pvs.state', 'supplier_state', 'aprx_wt.var.supplier_state','VARCHAR2',150);

Line 206: fa_rx_util_pkg.assign_column('11', 'pvs.city', 'supplier_city', 'aprx_wt.var.supplier_city','VARCHAR2',25);

202: fa_rx_util_pkg.assign_column('9', 'pvs.address_line2', 'supplier_address_line2', 'aprx_wt.var.supplier_address_line2','VARCHAR2',240);
203:
204: fa_rx_util_pkg.assign_column('10', 'pvs.address_line3', 'supplier_address_line3', 'aprx_wt.var.supplier_address_line3','VARCHAR2',240);
205:
206: fa_rx_util_pkg.assign_column('11', 'pvs.city', 'supplier_city', 'aprx_wt.var.supplier_city','VARCHAR2',25);
207:
208: fa_rx_util_pkg.assign_column('12', 'pvs.state', 'supplier_state', 'aprx_wt.var.supplier_state','VARCHAR2',150);
209:
210: fa_rx_util_pkg.assign_column('13', 'pvs.zip', 'supplier_zip', 'aprx_wt.var.supplier_zip','VARCHAR2',20);

Line 208: fa_rx_util_pkg.assign_column('12', 'pvs.state', 'supplier_state', 'aprx_wt.var.supplier_state','VARCHAR2',150);

204: fa_rx_util_pkg.assign_column('10', 'pvs.address_line3', 'supplier_address_line3', 'aprx_wt.var.supplier_address_line3','VARCHAR2',240);
205:
206: fa_rx_util_pkg.assign_column('11', 'pvs.city', 'supplier_city', 'aprx_wt.var.supplier_city','VARCHAR2',25);
207:
208: fa_rx_util_pkg.assign_column('12', 'pvs.state', 'supplier_state', 'aprx_wt.var.supplier_state','VARCHAR2',150);
209:
210: fa_rx_util_pkg.assign_column('13', 'pvs.zip', 'supplier_zip', 'aprx_wt.var.supplier_zip','VARCHAR2',20);
211:
212: fa_rx_util_pkg.assign_column('14', 'pvs.province', 'supplier_province', 'aprx_wt.var.supplier_province','VARCHAR2',150);

Line 210: fa_rx_util_pkg.assign_column('13', 'pvs.zip', 'supplier_zip', 'aprx_wt.var.supplier_zip','VARCHAR2',20);

206: fa_rx_util_pkg.assign_column('11', 'pvs.city', 'supplier_city', 'aprx_wt.var.supplier_city','VARCHAR2',25);
207:
208: fa_rx_util_pkg.assign_column('12', 'pvs.state', 'supplier_state', 'aprx_wt.var.supplier_state','VARCHAR2',150);
209:
210: fa_rx_util_pkg.assign_column('13', 'pvs.zip', 'supplier_zip', 'aprx_wt.var.supplier_zip','VARCHAR2',20);
211:
212: fa_rx_util_pkg.assign_column('14', 'pvs.province', 'supplier_province', 'aprx_wt.var.supplier_province','VARCHAR2',150);
213:
214: fa_rx_util_pkg.assign_column('15', 'pvs.country', 'supplier_country', 'aprx_wt.var.supplier_country','VARCHAR2',25);

Line 212: fa_rx_util_pkg.assign_column('14', 'pvs.province', 'supplier_province', 'aprx_wt.var.supplier_province','VARCHAR2',150);

208: fa_rx_util_pkg.assign_column('12', 'pvs.state', 'supplier_state', 'aprx_wt.var.supplier_state','VARCHAR2',150);
209:
210: fa_rx_util_pkg.assign_column('13', 'pvs.zip', 'supplier_zip', 'aprx_wt.var.supplier_zip','VARCHAR2',20);
211:
212: fa_rx_util_pkg.assign_column('14', 'pvs.province', 'supplier_province', 'aprx_wt.var.supplier_province','VARCHAR2',150);
213:
214: fa_rx_util_pkg.assign_column('15', 'pvs.country', 'supplier_country', 'aprx_wt.var.supplier_country','VARCHAR2',25);
215:
216: fa_rx_util_pkg.assign_column('16', 'ai.invoice_num', 'invoice_num', 'aprx_wt.var.invoice_num','VARCHAR2',50);

Line 214: fa_rx_util_pkg.assign_column('15', 'pvs.country', 'supplier_country', 'aprx_wt.var.supplier_country','VARCHAR2',25);

210: fa_rx_util_pkg.assign_column('13', 'pvs.zip', 'supplier_zip', 'aprx_wt.var.supplier_zip','VARCHAR2',20);
211:
212: fa_rx_util_pkg.assign_column('14', 'pvs.province', 'supplier_province', 'aprx_wt.var.supplier_province','VARCHAR2',150);
213:
214: fa_rx_util_pkg.assign_column('15', 'pvs.country', 'supplier_country', 'aprx_wt.var.supplier_country','VARCHAR2',25);
215:
216: fa_rx_util_pkg.assign_column('16', 'ai.invoice_num', 'invoice_num', 'aprx_wt.var.invoice_num','VARCHAR2',50);
217:
218: fa_rx_util_pkg.assign_column('17', 'ai.invoice_amount', 'invoice_amount', 'aprx_wt.var.invoice_amount','NUMBER');

Line 216: fa_rx_util_pkg.assign_column('16', 'ai.invoice_num', 'invoice_num', 'aprx_wt.var.invoice_num','VARCHAR2',50);

212: fa_rx_util_pkg.assign_column('14', 'pvs.province', 'supplier_province', 'aprx_wt.var.supplier_province','VARCHAR2',150);
213:
214: fa_rx_util_pkg.assign_column('15', 'pvs.country', 'supplier_country', 'aprx_wt.var.supplier_country','VARCHAR2',25);
215:
216: fa_rx_util_pkg.assign_column('16', 'ai.invoice_num', 'invoice_num', 'aprx_wt.var.invoice_num','VARCHAR2',50);
217:
218: fa_rx_util_pkg.assign_column('17', 'ai.invoice_amount', 'invoice_amount', 'aprx_wt.var.invoice_amount','NUMBER');
219:
220: fa_rx_util_pkg.assign_column('18', 'ai.invoice_currency_code', 'invoice_currency_code', 'aprx_wt.var.invoice_currency_code','VARCHAR2',15);

Line 218: fa_rx_util_pkg.assign_column('17', 'ai.invoice_amount', 'invoice_amount', 'aprx_wt.var.invoice_amount','NUMBER');

214: fa_rx_util_pkg.assign_column('15', 'pvs.country', 'supplier_country', 'aprx_wt.var.supplier_country','VARCHAR2',25);
215:
216: fa_rx_util_pkg.assign_column('16', 'ai.invoice_num', 'invoice_num', 'aprx_wt.var.invoice_num','VARCHAR2',50);
217:
218: fa_rx_util_pkg.assign_column('17', 'ai.invoice_amount', 'invoice_amount', 'aprx_wt.var.invoice_amount','NUMBER');
219:
220: fa_rx_util_pkg.assign_column('18', 'ai.invoice_currency_code', 'invoice_currency_code', 'aprx_wt.var.invoice_currency_code','VARCHAR2',15);
221:
222: fa_rx_util_pkg.assign_column('19', 'ai.invoice_date', 'invoice_date', 'aprx_wt.var.invoice_date','DATE');

Line 220: fa_rx_util_pkg.assign_column('18', 'ai.invoice_currency_code', 'invoice_currency_code', 'aprx_wt.var.invoice_currency_code','VARCHAR2',15);

216: fa_rx_util_pkg.assign_column('16', 'ai.invoice_num', 'invoice_num', 'aprx_wt.var.invoice_num','VARCHAR2',50);
217:
218: fa_rx_util_pkg.assign_column('17', 'ai.invoice_amount', 'invoice_amount', 'aprx_wt.var.invoice_amount','NUMBER');
219:
220: fa_rx_util_pkg.assign_column('18', 'ai.invoice_currency_code', 'invoice_currency_code', 'aprx_wt.var.invoice_currency_code','VARCHAR2',15);
221:
222: fa_rx_util_pkg.assign_column('19', 'ai.invoice_date', 'invoice_date', 'aprx_wt.var.invoice_date','DATE');
223:
224: fa_rx_util_pkg.assign_column('20', 'atr.tax_name', 'awt_code', 'aprx_wt.var.awt_code','VARCHAR2',15);

Line 222: fa_rx_util_pkg.assign_column('19', 'ai.invoice_date', 'invoice_date', 'aprx_wt.var.invoice_date','DATE');

218: fa_rx_util_pkg.assign_column('17', 'ai.invoice_amount', 'invoice_amount', 'aprx_wt.var.invoice_amount','NUMBER');
219:
220: fa_rx_util_pkg.assign_column('18', 'ai.invoice_currency_code', 'invoice_currency_code', 'aprx_wt.var.invoice_currency_code','VARCHAR2',15);
221:
222: fa_rx_util_pkg.assign_column('19', 'ai.invoice_date', 'invoice_date', 'aprx_wt.var.invoice_date','DATE');
223:
224: fa_rx_util_pkg.assign_column('20', 'atr.tax_name', 'awt_code', 'aprx_wt.var.awt_code','VARCHAR2',15);
225:
226: fa_rx_util_pkg.assign_column('21', 'atr.tax_rate', 'awt_rate', 'aprx_wt.var.awt_rate','NUMBER');

Line 224: fa_rx_util_pkg.assign_column('20', 'atr.tax_name', 'awt_code', 'aprx_wt.var.awt_code','VARCHAR2',15);

220: fa_rx_util_pkg.assign_column('18', 'ai.invoice_currency_code', 'invoice_currency_code', 'aprx_wt.var.invoice_currency_code','VARCHAR2',15);
221:
222: fa_rx_util_pkg.assign_column('19', 'ai.invoice_date', 'invoice_date', 'aprx_wt.var.invoice_date','DATE');
223:
224: fa_rx_util_pkg.assign_column('20', 'atr.tax_name', 'awt_code', 'aprx_wt.var.awt_code','VARCHAR2',15);
225:
226: fa_rx_util_pkg.assign_column('21', 'atr.tax_rate', 'awt_rate', 'aprx_wt.var.awt_rate','NUMBER');
227:
228: fa_rx_util_pkg.assign_column('22', 'nvl(aid.amount*(-1),0)', 'awt_amount', 'aprx_wt.var.awt_amount','NUMBER');

Line 226: fa_rx_util_pkg.assign_column('21', 'atr.tax_rate', 'awt_rate', 'aprx_wt.var.awt_rate','NUMBER');

222: fa_rx_util_pkg.assign_column('19', 'ai.invoice_date', 'invoice_date', 'aprx_wt.var.invoice_date','DATE');
223:
224: fa_rx_util_pkg.assign_column('20', 'atr.tax_name', 'awt_code', 'aprx_wt.var.awt_code','VARCHAR2',15);
225:
226: fa_rx_util_pkg.assign_column('21', 'atr.tax_rate', 'awt_rate', 'aprx_wt.var.awt_rate','NUMBER');
227:
228: fa_rx_util_pkg.assign_column('22', 'nvl(aid.amount*(-1),0)', 'awt_amount', 'aprx_wt.var.awt_amount','NUMBER');
229:
230: fa_rx_util_pkg.assign_column('23', 'nvl(aid.base_amount*(-1),aid.amount*(-1))', 'awt_base_amount', 'aprx_wt.var.awt_base_amount','NUMBER');

Line 228: fa_rx_util_pkg.assign_column('22', 'nvl(aid.amount*(-1),0)', 'awt_amount', 'aprx_wt.var.awt_amount','NUMBER');

224: fa_rx_util_pkg.assign_column('20', 'atr.tax_name', 'awt_code', 'aprx_wt.var.awt_code','VARCHAR2',15);
225:
226: fa_rx_util_pkg.assign_column('21', 'atr.tax_rate', 'awt_rate', 'aprx_wt.var.awt_rate','NUMBER');
227:
228: fa_rx_util_pkg.assign_column('22', 'nvl(aid.amount*(-1),0)', 'awt_amount', 'aprx_wt.var.awt_amount','NUMBER');
229:
230: fa_rx_util_pkg.assign_column('23', 'nvl(aid.base_amount*(-1),aid.amount*(-1))', 'awt_base_amount', 'aprx_wt.var.awt_base_amount','NUMBER');
231:
232: fa_rx_util_pkg.assign_column('24', 'atg.name', 'awt_group_name', 'aprx_wt.var.awt_group_name','VARCHAR2',25);

Line 230: fa_rx_util_pkg.assign_column('23', 'nvl(aid.base_amount(-1),aid.amount(-1))', 'awt_base_amount', 'aprx_wt.var.awt_base_amount','NUMBER');

226: fa_rx_util_pkg.assign_column('21', 'atr.tax_rate', 'awt_rate', 'aprx_wt.var.awt_rate','NUMBER');
227:
228: fa_rx_util_pkg.assign_column('22', 'nvl(aid.amount*(-1),0)', 'awt_amount', 'aprx_wt.var.awt_amount','NUMBER');
229:
230: fa_rx_util_pkg.assign_column('23', 'nvl(aid.base_amount*(-1),aid.amount*(-1))', 'awt_base_amount', 'aprx_wt.var.awt_base_amount','NUMBER');
231:
232: fa_rx_util_pkg.assign_column('24', 'atg.name', 'awt_group_name', 'aprx_wt.var.awt_group_name','VARCHAR2',25);
233:
234: fa_rx_util_pkg.assign_column('25', 'aid.accounting_date', 'awt_gl_date', 'aprx_wt.var.awt_gl_date','DATE');

Line 232: fa_rx_util_pkg.assign_column('24', 'atg.name', 'awt_group_name', 'aprx_wt.var.awt_group_name','VARCHAR2',25);

228: fa_rx_util_pkg.assign_column('22', 'nvl(aid.amount*(-1),0)', 'awt_amount', 'aprx_wt.var.awt_amount','NUMBER');
229:
230: fa_rx_util_pkg.assign_column('23', 'nvl(aid.base_amount*(-1),aid.amount*(-1))', 'awt_base_amount', 'aprx_wt.var.awt_base_amount','NUMBER');
231:
232: fa_rx_util_pkg.assign_column('24', 'atg.name', 'awt_group_name', 'aprx_wt.var.awt_group_name','VARCHAR2',25);
233:
234: fa_rx_util_pkg.assign_column('25', 'aid.accounting_date', 'awt_gl_date', 'aprx_wt.var.awt_gl_date','DATE');
235:
236: fa_rx_util_pkg.assign_column('26', 'aid.awt_gross_amount', 'awt_gross_amount', 'aprx_wt.var.awt_gross_amount','NUMBER');

Line 234: fa_rx_util_pkg.assign_column('25', 'aid.accounting_date', 'awt_gl_date', 'aprx_wt.var.awt_gl_date','DATE');

230: fa_rx_util_pkg.assign_column('23', 'nvl(aid.base_amount*(-1),aid.amount*(-1))', 'awt_base_amount', 'aprx_wt.var.awt_base_amount','NUMBER');
231:
232: fa_rx_util_pkg.assign_column('24', 'atg.name', 'awt_group_name', 'aprx_wt.var.awt_group_name','VARCHAR2',25);
233:
234: fa_rx_util_pkg.assign_column('25', 'aid.accounting_date', 'awt_gl_date', 'aprx_wt.var.awt_gl_date','DATE');
235:
236: fa_rx_util_pkg.assign_column('26', 'aid.awt_gross_amount', 'awt_gross_amount', 'aprx_wt.var.awt_gross_amount','NUMBER');
237:
238:

Line 236: fa_rx_util_pkg.assign_column('26', 'aid.awt_gross_amount', 'awt_gross_amount', 'aprx_wt.var.awt_gross_amount','NUMBER');

232: fa_rx_util_pkg.assign_column('24', 'atg.name', 'awt_group_name', 'aprx_wt.var.awt_group_name','VARCHAR2',25);
233:
234: fa_rx_util_pkg.assign_column('25', 'aid.accounting_date', 'awt_gl_date', 'aprx_wt.var.awt_gl_date','DATE');
235:
236: fa_rx_util_pkg.assign_column('26', 'aid.awt_gross_amount', 'awt_gross_amount', 'aprx_wt.var.awt_gross_amount','NUMBER');
237:
238:
239: fa_rx_util_pkg.assign_column('27', NULL, 'address_line1','aprx_wt.var.address_line1', 'VARCHAR2',240);
240:

Line 239: fa_rx_util_pkg.assign_column('27', NULL, 'address_line1','aprx_wt.var.address_line1', 'VARCHAR2',240);

235:
236: fa_rx_util_pkg.assign_column('26', 'aid.awt_gross_amount', 'awt_gross_amount', 'aprx_wt.var.awt_gross_amount','NUMBER');
237:
238:
239: fa_rx_util_pkg.assign_column('27', NULL, 'address_line1','aprx_wt.var.address_line1', 'VARCHAR2',240);
240:
241: fa_rx_util_pkg.assign_column('28', NULL, 'address_line2','aprx_wt.var.address_line2', 'VARCHAR2',240);
242:
243: fa_rx_util_pkg.assign_column('29', NULL, 'address_line3','aprx_wt.var.address_line3', 'VARCHAR2',240);

Line 241: fa_rx_util_pkg.assign_column('28', NULL, 'address_line2','aprx_wt.var.address_line2', 'VARCHAR2',240);

237:
238:
239: fa_rx_util_pkg.assign_column('27', NULL, 'address_line1','aprx_wt.var.address_line1', 'VARCHAR2',240);
240:
241: fa_rx_util_pkg.assign_column('28', NULL, 'address_line2','aprx_wt.var.address_line2', 'VARCHAR2',240);
242:
243: fa_rx_util_pkg.assign_column('29', NULL, 'address_line3','aprx_wt.var.address_line3', 'VARCHAR2',240);
244:
245: fa_rx_util_pkg.assign_column('30', NULL, 'city','aprx_wt.var.city', 'VARCHAR2',30);

Line 243: fa_rx_util_pkg.assign_column('29', NULL, 'address_line3','aprx_wt.var.address_line3', 'VARCHAR2',240);

239: fa_rx_util_pkg.assign_column('27', NULL, 'address_line1','aprx_wt.var.address_line1', 'VARCHAR2',240);
240:
241: fa_rx_util_pkg.assign_column('28', NULL, 'address_line2','aprx_wt.var.address_line2', 'VARCHAR2',240);
242:
243: fa_rx_util_pkg.assign_column('29', NULL, 'address_line3','aprx_wt.var.address_line3', 'VARCHAR2',240);
244:
245: fa_rx_util_pkg.assign_column('30', NULL, 'city','aprx_wt.var.city', 'VARCHAR2',30);
246:
247: fa_rx_util_pkg.assign_column('31', NULL, 'zip','aprx_wt.var.zip', 'VARCHAR2',30);

Line 245: fa_rx_util_pkg.assign_column('30', NULL, 'city','aprx_wt.var.city', 'VARCHAR2',30);

241: fa_rx_util_pkg.assign_column('28', NULL, 'address_line2','aprx_wt.var.address_line2', 'VARCHAR2',240);
242:
243: fa_rx_util_pkg.assign_column('29', NULL, 'address_line3','aprx_wt.var.address_line3', 'VARCHAR2',240);
244:
245: fa_rx_util_pkg.assign_column('30', NULL, 'city','aprx_wt.var.city', 'VARCHAR2',30);
246:
247: fa_rx_util_pkg.assign_column('31', NULL, 'zip','aprx_wt.var.zip', 'VARCHAR2',30);
248:
249: fa_rx_util_pkg.assign_column('32', NULL, 'country','aprx_wt.var.country', 'VARCHAR2',60);

Line 247: fa_rx_util_pkg.assign_column('31', NULL, 'zip','aprx_wt.var.zip', 'VARCHAR2',30);

243: fa_rx_util_pkg.assign_column('29', NULL, 'address_line3','aprx_wt.var.address_line3', 'VARCHAR2',240);
244:
245: fa_rx_util_pkg.assign_column('30', NULL, 'city','aprx_wt.var.city', 'VARCHAR2',30);
246:
247: fa_rx_util_pkg.assign_column('31', NULL, 'zip','aprx_wt.var.zip', 'VARCHAR2',30);
248:
249: fa_rx_util_pkg.assign_column('32', NULL, 'country','aprx_wt.var.country', 'VARCHAR2',60);
250:
251: fa_rx_util_pkg.assign_column('33', NULL, 'organization_name','aprx_wt.var.organization_name', 'VARCHAR2',240);

Line 249: fa_rx_util_pkg.assign_column('32', NULL, 'country','aprx_wt.var.country', 'VARCHAR2',60);

245: fa_rx_util_pkg.assign_column('30', NULL, 'city','aprx_wt.var.city', 'VARCHAR2',30);
246:
247: fa_rx_util_pkg.assign_column('31', NULL, 'zip','aprx_wt.var.zip', 'VARCHAR2',30);
248:
249: fa_rx_util_pkg.assign_column('32', NULL, 'country','aprx_wt.var.country', 'VARCHAR2',60);
250:
251: fa_rx_util_pkg.assign_column('33', NULL, 'organization_name','aprx_wt.var.organization_name', 'VARCHAR2',240);
252:
253: fa_rx_util_pkg.assign_column('34', NULL, 'functional_currency_code','aprx_wt.var.functional_currency_code', 'VARCHAR2',15);

Line 251: fa_rx_util_pkg.assign_column('33', NULL, 'organization_name','aprx_wt.var.organization_name', 'VARCHAR2',240);

247: fa_rx_util_pkg.assign_column('31', NULL, 'zip','aprx_wt.var.zip', 'VARCHAR2',30);
248:
249: fa_rx_util_pkg.assign_column('32', NULL, 'country','aprx_wt.var.country', 'VARCHAR2',60);
250:
251: fa_rx_util_pkg.assign_column('33', NULL, 'organization_name','aprx_wt.var.organization_name', 'VARCHAR2',240);
252:
253: fa_rx_util_pkg.assign_column('34', NULL, 'functional_currency_code','aprx_wt.var.functional_currency_code', 'VARCHAR2',15);
254:
255: fa_rx_util_pkg.assign_column('35', NULL, 'province','aprx_wt.var.province', 'VARCHAR2',150);

Line 253: fa_rx_util_pkg.assign_column('34', NULL, 'functional_currency_code','aprx_wt.var.functional_currency_code', 'VARCHAR2',15);

249: fa_rx_util_pkg.assign_column('32', NULL, 'country','aprx_wt.var.country', 'VARCHAR2',60);
250:
251: fa_rx_util_pkg.assign_column('33', NULL, 'organization_name','aprx_wt.var.organization_name', 'VARCHAR2',240);
252:
253: fa_rx_util_pkg.assign_column('34', NULL, 'functional_currency_code','aprx_wt.var.functional_currency_code', 'VARCHAR2',15);
254:
255: fa_rx_util_pkg.assign_column('35', NULL, 'province','aprx_wt.var.province', 'VARCHAR2',150);
256:
257: fa_rx_util_pkg.assign_column('36', NULL, 'state','aprx_wt.var.state', 'VARCHAR2',150);

Line 255: fa_rx_util_pkg.assign_column('35', NULL, 'province','aprx_wt.var.province', 'VARCHAR2',150);

251: fa_rx_util_pkg.assign_column('33', NULL, 'organization_name','aprx_wt.var.organization_name', 'VARCHAR2',240);
252:
253: fa_rx_util_pkg.assign_column('34', NULL, 'functional_currency_code','aprx_wt.var.functional_currency_code', 'VARCHAR2',15);
254:
255: fa_rx_util_pkg.assign_column('35', NULL, 'province','aprx_wt.var.province', 'VARCHAR2',150);
256:
257: fa_rx_util_pkg.assign_column('36', NULL, 'state','aprx_wt.var.state', 'VARCHAR2',150);
258:
259: -->>SELECT_END<<--

Line 257: fa_rx_util_pkg.assign_column('36', NULL, 'state','aprx_wt.var.state', 'VARCHAR2',150);

253: fa_rx_util_pkg.assign_column('34', NULL, 'functional_currency_code','aprx_wt.var.functional_currency_code', 'VARCHAR2',15);
254:
255: fa_rx_util_pkg.assign_column('35', NULL, 'province','aprx_wt.var.province', 'VARCHAR2',150);
256:
257: fa_rx_util_pkg.assign_column('36', NULL, 'state','aprx_wt.var.state', 'VARCHAR2',150);
258:
259: -->>SELECT_END<<--
260:
261:

Line 265: fa_rx_util_pkg.From_Clause :=

261:
262: --
263: -- Assign From Clause
264: --
265: fa_rx_util_pkg.From_Clause :=
266: 'po_vendors pv2,
267: po_vendors pv1,
268: po_vendor_sites pvs ,
269: ap_invoices ai,

Line 280: fa_rx_util_pkg.Where_Clause := 'pv2.vendor_id = ai.vendor_id and

276: -- Assign Where Clause
277:
278: -- Bug 2825570. Add filter on invoice_date between start and end dates.
279:
280: fa_rx_util_pkg.Where_Clause := 'pv2.vendor_id = ai.vendor_id and
281: pvs.vendor_site_id = ai.vendor_site_id and
282: atg.group_id(+) = aid.awt_origin_group_id and
283: ai.invoice_id = aid.invoice_id and
284: aid.tax_code_id = atc.tax_id and

Line 290: fa_rx_util_pkg.debug('aprx_wt.before_report()-');

286: aid.line_type_lookup_code=''AWT'' and
287: ai.invoice_date between NVL(atr.start_date , ai.invoice_date) and NVL(atr.end_date , ai.invoice_date) and
288: atc.awt_vendor_id = pv1.vendor_id';
289:
290: fa_rx_util_pkg.debug('aprx_wt.before_report()-');
291:
292: END BEFORE_REPORT;
293:
294:

Line 359: fa_rx_util_pkg.debug('system_acct_method'||parm.P_System_Acct_Method);

355: ELSE
356: parm.P_System_Acct_Method := 'BOTH';
357: END IF;
358:
359: fa_rx_util_pkg.debug('system_acct_method'||parm.P_System_Acct_Method);
360:
361: -- Add the WHERE clause which is specific to the AP Witholding Report
362:
363: IF parm.p_date_from IS NOT NULL THEN

Line 364: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause || ' and aid.accounting_date >= fnd_date.canonical_to_date(:b_date_from)' ;

360:
361: -- Add the WHERE clause which is specific to the AP Witholding Report
362:
363: IF parm.p_date_from IS NOT NULL THEN
364: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause || ' and aid.accounting_date >= fnd_date.canonical_to_date(:b_date_from)' ;
365: END IF;
366:
367: IF parm.p_date_to IS NOT NULL THEN
368: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause || ' and aid.accounting_date <= fnd_date.canonical_to_date(:b_date_to) ';

Line 368: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause || ' and aid.accounting_date <= fnd_date.canonical_to_date(:b_date_to) ';

364: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause || ' and aid.accounting_date >= fnd_date.canonical_to_date(:b_date_from)' ;
365: END IF;
366:
367: IF parm.p_date_to IS NOT NULL THEN
368: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause || ' and aid.accounting_date <= fnd_date.canonical_to_date(:b_date_to) ';
369:
370: END IF;
371:
372: IF parm.p_supplier_from IS NOT NULL THEN

Line 373: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause || ' and UPPER(pv2.vendor_name) >= UPPER(:b_supplier_from)';

369:
370: END IF;
371:
372: IF parm.p_supplier_from IS NOT NULL THEN
373: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause || ' and UPPER(pv2.vendor_name) >= UPPER(:b_supplier_from)';
374: END IF;
375:
376: IF parm.p_supplier_to IS NOT NULL THEN
377: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause || ' and UPPER(pv2.vendor_name) <= UPPER(:b_supplier_to)' ;

Line 377: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause || ' and UPPER(pv2.vendor_name) <= UPPER(:b_supplier_to)' ;

373: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause || ' and UPPER(pv2.vendor_name) >= UPPER(:b_supplier_from)';
374: END IF;
375:
376: IF parm.p_supplier_to IS NOT NULL THEN
377: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause || ' and UPPER(pv2.vendor_name) <= UPPER(:b_supplier_to)' ;
378: END IF;
379:
380: IF parm.p_supplier_type IS NOT NULL THEN
381: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause || ' and pv2.vendor_type_lookup_code = :b_supplier_type';

Line 381: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause || ' and pv2.vendor_type_lookup_code = :b_supplier_type';

377: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause || ' and UPPER(pv2.vendor_name) <= UPPER(:b_supplier_to)' ;
378: END IF;
379:
380: IF parm.p_supplier_type IS NOT NULL THEN
381: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause || ' and pv2.vendor_type_lookup_code = :b_supplier_type';
382: END IF;
383:
384: IF parm.p_system_acct_method IS NOT NULL THEN
385: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause ||' and aid.accrual_posted_flag = decode(:b_system_acct_method,''ACCRUAL'',''Y'',''BOTH'',''Y'',aid.accrual_posted_flag)';

Line 385: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause ||' and aid.accrual_posted_flag = decode(:b_system_acct_method,''ACCRUAL'',''Y'',''BOTH'',''Y'',aid.accrual_posted_flag)';

381: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause || ' and pv2.vendor_type_lookup_code = :b_supplier_type';
382: END IF;
383:
384: IF parm.p_system_acct_method IS NOT NULL THEN
385: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause ||' and aid.accrual_posted_flag = decode(:b_system_acct_method,''ACCRUAL'',''Y'',''BOTH'',''Y'',aid.accrual_posted_flag)';
386: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause ||' and aid.cash_posted_flag = decode(:b_system_acct_method,''CASH'',''Y'',''BOTH'',''Y'',aid.cash_posted_flag)';
387: END IF;
388:
389: fa_rx_util_pkg.debug('aprx_wt.awt_before_report()-');

Line 386: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause ||' and aid.cash_posted_flag = decode(:b_system_acct_method,''CASH'',''Y'',''BOTH'',''Y'',aid.cash_posted_flag)';

382: END IF;
383:
384: IF parm.p_system_acct_method IS NOT NULL THEN
385: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause ||' and aid.accrual_posted_flag = decode(:b_system_acct_method,''ACCRUAL'',''Y'',''BOTH'',''Y'',aid.accrual_posted_flag)';
386: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause ||' and aid.cash_posted_flag = decode(:b_system_acct_method,''CASH'',''Y'',''BOTH'',''Y'',aid.cash_posted_flag)';
387: END IF;
388:
389: fa_rx_util_pkg.debug('aprx_wt.awt_before_report()-');
390:

Line 389: fa_rx_util_pkg.debug('aprx_wt.awt_before_report()-');

385: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause ||' and aid.accrual_posted_flag = decode(:b_system_acct_method,''ACCRUAL'',''Y'',''BOTH'',''Y'',aid.accrual_posted_flag)';
386: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause ||' and aid.cash_posted_flag = decode(:b_system_acct_method,''CASH'',''Y'',''BOTH'',''Y'',aid.cash_posted_flag)';
387: END IF;
388:
389: fa_rx_util_pkg.debug('aprx_wt.awt_before_report()-');
390:
391: END awt_before_report;
392:
393: -- This is the bind trigger for the

Line 403: fa_rx_util_pkg.debug('aprx_wt.awt_bind()+');

399: b_supplier_to varchar2(80);
400: b_supplier_type varchar2(25);
401: b_system_acct_method varchar2(240);
402: BEGIN
403: fa_rx_util_pkg.debug('aprx_wt.awt_bind()+');
404:
405: IF parm.p_date_from is not null then
406: fa_rx_util_pkg.debug('Binding b_date_from');
407: dbms_sql.bind_variable(c, 'b_date_from', parm.p_date_from);

Line 406: fa_rx_util_pkg.debug('Binding b_date_from');

402: BEGIN
403: fa_rx_util_pkg.debug('aprx_wt.awt_bind()+');
404:
405: IF parm.p_date_from is not null then
406: fa_rx_util_pkg.debug('Binding b_date_from');
407: dbms_sql.bind_variable(c, 'b_date_from', parm.p_date_from);
408: END IF;
409:
410: IF parm.p_date_to is not null then

Line 411: fa_rx_util_pkg.debug('Binding b_date_to');

407: dbms_sql.bind_variable(c, 'b_date_from', parm.p_date_from);
408: END IF;
409:
410: IF parm.p_date_to is not null then
411: fa_rx_util_pkg.debug('Binding b_date_to');
412: dbms_sql.bind_variable(c, 'b_date_to', parm.p_date_to);
413: END IF;
414:
415: IF parm.p_supplier_from is not null then

Line 416: fa_rx_util_pkg.debug('Binding b_supplier_from');

412: dbms_sql.bind_variable(c, 'b_date_to', parm.p_date_to);
413: END IF;
414:
415: IF parm.p_supplier_from is not null then
416: fa_rx_util_pkg.debug('Binding b_supplier_from');
417: dbms_sql.bind_variable(c, 'b_supplier_from', parm.p_supplier_from);
418: END IF;
419:
420: IF parm.p_supplier_to is not null then

Line 421: fa_rx_util_pkg.debug('Binding b_supplier_to');

417: dbms_sql.bind_variable(c, 'b_supplier_from', parm.p_supplier_from);
418: END IF;
419:
420: IF parm.p_supplier_to is not null then
421: fa_rx_util_pkg.debug('Binding b_supplier_to');
422: dbms_sql.bind_variable(c, 'b_supplier_to', parm.p_supplier_to);
423: END IF;
424:
425: IF parm.p_supplier_type is not null then

Line 426: fa_rx_util_pkg.debug('Binding b_supplier_type_from');

422: dbms_sql.bind_variable(c, 'b_supplier_to', parm.p_supplier_to);
423: END IF;
424:
425: IF parm.p_supplier_type is not null then
426: fa_rx_util_pkg.debug('Binding b_supplier_type_from');
427: dbms_sql.bind_variable(c, 'b_supplier_type', parm.p_supplier_type);
428: END IF;
429:
430: IF parm.p_system_acct_method is not null then

Line 431: fa_rx_util_pkg.debug('Binding b_system_acct_method');

427: dbms_sql.bind_variable(c, 'b_supplier_type', parm.p_supplier_type);
428: END IF;
429:
430: IF parm.p_system_acct_method is not null then
431: fa_rx_util_pkg.debug('Binding b_system_acct_method');
432: dbms_sql.bind_variable(c, 'b_system_acct_method', parm.p_system_acct_method);
433: END IF;
434:
435: fa_rx_util_pkg.debug('aprx_wt.awt_bind()-');

Line 435: fa_rx_util_pkg.debug('aprx_wt.awt_bind()-');

431: fa_rx_util_pkg.debug('Binding b_system_acct_method');
432: dbms_sql.bind_variable(c, 'b_system_acct_method', parm.p_system_acct_method);
433: END IF;
434:
435: fa_rx_util_pkg.debug('aprx_wt.awt_bind()-');
436:
437: END awt_bind;
438:
439: