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 44: fa_rx_util_pkg.debug('aprx_wt.get_witholding_tax()+');

40: debug_info VARCHAR2(10000);
41:
42: BEGIN
43:
44: fa_rx_util_pkg.debug('aprx_wt.get_witholding_tax()+');
45:
46: -- Initialize request
47:
48: fa_rx_util_pkg.init_request('aprx_wt.get_witholding_tax', request_id);

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

44: fa_rx_util_pkg.debug('aprx_wt.get_witholding_tax()+');
45:
46: -- Initialize request
47:
48: fa_rx_util_pkg.init_request('aprx_wt.get_witholding_tax', request_id);
49:
50: fa_rx_util_pkg.assign_report(section_name,
51: true,
52: 'aprx_wt.before_report;',

Line 50: fa_rx_util_pkg.assign_report(section_name,

46: -- Initialize request
47:
48: fa_rx_util_pkg.init_request('aprx_wt.get_witholding_tax', request_id);
49:
50: fa_rx_util_pkg.assign_report(section_name,
51: true,
52: 'aprx_wt.before_report;',
53: NULL,
54: NULL,

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

53: NULL,
54: NULL,
55: NULL);
56:
57: fa_rx_util_pkg.run_report('aprx_wt.get_witholding_tax', retcode, errbuf);
58:
59: fa_rx_util_pkg.debug('aprx_wt.get_witholding_tax()-');
60:
61: END GET_WITHOLDING_TAX;

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

55: NULL);
56:
57: fa_rx_util_pkg.run_report('aprx_wt.get_witholding_tax', retcode, errbuf);
58:
59: fa_rx_util_pkg.debug('aprx_wt.get_witholding_tax()-');
60:
61: END GET_WITHOLDING_TAX;
62:
63: -- This procedure is a plug-in for the (Tax Letter) Report

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

77: DBG_Loc VARCHAR2(30) := 'ap_wht_tax_report';
78: debug_info VARCHAR2(10000);
79:
80: BEGIN
81: fa_rx_util_pkg.debug('aprx_wt.ap_wht_tax_report()+');
82: fa_rx_util_pkg.debug('p_date_from '||p_date_from);
83: fa_rx_util_pkg.debug('canonical date from '||to_char(fnd_date.canonical_to_date(p_date_from)));
84: fa_rx_util_pkg.init_request('aprx_wt.ap_wht_tax_report', request_id);
85: debug_info := 'aprx_wt.ap_wht_tax_report()+';

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

78: debug_info VARCHAR2(10000);
79:
80: BEGIN
81: fa_rx_util_pkg.debug('aprx_wt.ap_wht_tax_report()+');
82: fa_rx_util_pkg.debug('p_date_from '||p_date_from);
83: fa_rx_util_pkg.debug('canonical date from '||to_char(fnd_date.canonical_to_date(p_date_from)));
84: fa_rx_util_pkg.init_request('aprx_wt.ap_wht_tax_report', request_id);
85: debug_info := 'aprx_wt.ap_wht_tax_report()+';
86: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

79:
80: BEGIN
81: fa_rx_util_pkg.debug('aprx_wt.ap_wht_tax_report()+');
82: fa_rx_util_pkg.debug('p_date_from '||p_date_from);
83: fa_rx_util_pkg.debug('canonical date from '||to_char(fnd_date.canonical_to_date(p_date_from)));
84: fa_rx_util_pkg.init_request('aprx_wt.ap_wht_tax_report', request_id);
85: debug_info := 'aprx_wt.ap_wht_tax_report()+';
86: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
87: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);

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

80: BEGIN
81: fa_rx_util_pkg.debug('aprx_wt.ap_wht_tax_report()+');
82: fa_rx_util_pkg.debug('p_date_from '||p_date_from);
83: fa_rx_util_pkg.debug('canonical date from '||to_char(fnd_date.canonical_to_date(p_date_from)));
84: fa_rx_util_pkg.init_request('aprx_wt.ap_wht_tax_report', request_id);
85: debug_info := 'aprx_wt.ap_wht_tax_report()+';
86: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
87: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);
88: END IF;

Line 117: fa_rx_util_pkg.assign_report('get_witholding_tax',

113: retcode,
114: errbuf);
115:
116: -- Continue with the execution of the plug-in
117: fa_rx_util_pkg.assign_report('get_witholding_tax',
118: true,
119: 'aprx_wt.awt_before_report;',
120: 'aprx_wt.awt_bind(:CURSOR_SELECT);',
121: NULL, null);

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

119: 'aprx_wt.awt_before_report;',
120: 'aprx_wt.awt_bind(:CURSOR_SELECT);',
121: NULL, null);
122:
123: fa_rx_util_pkg.run_report('aprx_wt.ap_wht_tax_report', retcode, errbuf);
124:
125: fa_rx_util_pkg.debug('aprx_wt.ap_wht_tax_report()-');
126:
127: END ap_wht_tax_report;

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

121: NULL, null);
122:
123: fa_rx_util_pkg.run_report('aprx_wt.ap_wht_tax_report', retcode, errbuf);
124:
125: fa_rx_util_pkg.debug('aprx_wt.ap_wht_tax_report()-');
126:
127: END ap_wht_tax_report;
128:
129: /*=======================================================================================================

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

143: DBG_Loc VARCHAR2(30) := 'before_report';
144: debug_info VARCHAR2(10000);
145:
146: BEGIN
147: fa_rx_util_pkg.debug('aprx_wt.before_report()+');
148:
149: /*Bug 9897890 Commented the below code*/
150: /*
151: fa_rx_util_pkg.debug('GL_SET_OF_BKS_ID');

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

147: fa_rx_util_pkg.debug('aprx_wt.before_report()+');
148:
149: /*Bug 9897890 Commented the below code*/
150: /*
151: fa_rx_util_pkg.debug('GL_SET_OF_BKS_ID');
152:
153: --
154: -- Get Profile GL_SET_OF_BKS_ID
155: --

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

153: --
154: -- Get Profile GL_SET_OF_BKS_ID
155: --
156:
157: fa_rx_util_pkg.debug('GL_GET_PROFILE_BKS_ID');
158: fnd_profile.get(
159: name => 'GL_SET_OF_BKS_ID',
160: val => var.books_id);
161:

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

161:
162: --
163: -- Get CHART_OF_ACCOUNTS_ID
164: --
165: fa_rx_util_pkg.debug('GL_GET_CHART_OF_ACCOUNTS_ID');
166:
167: select CURRENCY_CODE,NAME
168: into var.functional_currency_code
169: , var.organization_name

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

220:
221: --Assign SELECT list
222: -- the Select statement is build over here
223:
224: -- fa_rx_util_pkg.assign_column(#, select, insert, place, type, len);
225:
226: -->>SELECT_START<<--
227:
228: fa_rx_util_pkg.assign_column('1', 'pv1.vendor_name', 'tax_authority','aprx_wt.var.tax_authority','VARCHAR2', 240);

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

224: -- fa_rx_util_pkg.assign_column(#, select, insert, place, type, len);
225:
226: -->>SELECT_START<<--
227:
228: fa_rx_util_pkg.assign_column('1', 'pv1.vendor_name', 'tax_authority','aprx_wt.var.tax_authority','VARCHAR2', 240);
229:
230: fa_rx_util_pkg.assign_column('2', 'pv2.vendor_type_lookup_code', 'supplier_type','aprx_wt.var.supplier_type','VARCHAR2',30); -- Bug 10021563
231:
232: fa_rx_util_pkg.assign_column('3', 'pv2.vendor_name', 'supplier_name', 'aprx_wt.var.supplier_name','VARCHAR2',240);

Line 230: fa_rx_util_pkg.assign_column('2', 'pv2.vendor_type_lookup_code', 'supplier_type','aprx_wt.var.supplier_type','VARCHAR2',30); -- Bug 10021563

226: -->>SELECT_START<<--
227:
228: fa_rx_util_pkg.assign_column('1', 'pv1.vendor_name', 'tax_authority','aprx_wt.var.tax_authority','VARCHAR2', 240);
229:
230: fa_rx_util_pkg.assign_column('2', 'pv2.vendor_type_lookup_code', 'supplier_type','aprx_wt.var.supplier_type','VARCHAR2',30); -- Bug 10021563
231:
232: fa_rx_util_pkg.assign_column('3', 'pv2.vendor_name', 'supplier_name', 'aprx_wt.var.supplier_name','VARCHAR2',240);
233:
234: fa_rx_util_pkg.assign_column('4', 'pv2.num_1099', 'taxpayer_id','aprx_wt.var.taxpayer_id','VARCHAR2',30);

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

228: fa_rx_util_pkg.assign_column('1', 'pv1.vendor_name', 'tax_authority','aprx_wt.var.tax_authority','VARCHAR2', 240);
229:
230: fa_rx_util_pkg.assign_column('2', 'pv2.vendor_type_lookup_code', 'supplier_type','aprx_wt.var.supplier_type','VARCHAR2',30); -- Bug 10021563
231:
232: fa_rx_util_pkg.assign_column('3', 'pv2.vendor_name', 'supplier_name', 'aprx_wt.var.supplier_name','VARCHAR2',240);
233:
234: fa_rx_util_pkg.assign_column('4', 'pv2.num_1099', 'taxpayer_id','aprx_wt.var.taxpayer_id','VARCHAR2',30);
235:
236: fa_rx_util_pkg.assign_column('5', 'pv2.segment1', 'supplier_number', 'aprx_wt.var.supplier_number','VARCHAR2',30);

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

230: fa_rx_util_pkg.assign_column('2', 'pv2.vendor_type_lookup_code', 'supplier_type','aprx_wt.var.supplier_type','VARCHAR2',30); -- Bug 10021563
231:
232: fa_rx_util_pkg.assign_column('3', 'pv2.vendor_name', 'supplier_name', 'aprx_wt.var.supplier_name','VARCHAR2',240);
233:
234: fa_rx_util_pkg.assign_column('4', 'pv2.num_1099', 'taxpayer_id','aprx_wt.var.taxpayer_id','VARCHAR2',30);
235:
236: fa_rx_util_pkg.assign_column('5', 'pv2.segment1', 'supplier_number', 'aprx_wt.var.supplier_number','VARCHAR2',30);
237:
238: fa_rx_util_pkg.assign_column('6', 'pvs.vendor_site_code', 'supplier_site_code', 'aprx_wt.var.supplier_site_code','VARCHAR2',15);

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

232: fa_rx_util_pkg.assign_column('3', 'pv2.vendor_name', 'supplier_name', 'aprx_wt.var.supplier_name','VARCHAR2',240);
233:
234: fa_rx_util_pkg.assign_column('4', 'pv2.num_1099', 'taxpayer_id','aprx_wt.var.taxpayer_id','VARCHAR2',30);
235:
236: fa_rx_util_pkg.assign_column('5', 'pv2.segment1', 'supplier_number', 'aprx_wt.var.supplier_number','VARCHAR2',30);
237:
238: fa_rx_util_pkg.assign_column('6', 'pvs.vendor_site_code', 'supplier_site_code', 'aprx_wt.var.supplier_site_code','VARCHAR2',15);
239:
240: fa_rx_util_pkg.assign_column('7', 'pvs.vat_registration_num', 'vat_registration_number', 'aprx_wt.var.vat_registration_number','VARCHAR2',20);

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

234: fa_rx_util_pkg.assign_column('4', 'pv2.num_1099', 'taxpayer_id','aprx_wt.var.taxpayer_id','VARCHAR2',30);
235:
236: fa_rx_util_pkg.assign_column('5', 'pv2.segment1', 'supplier_number', 'aprx_wt.var.supplier_number','VARCHAR2',30);
237:
238: fa_rx_util_pkg.assign_column('6', 'pvs.vendor_site_code', 'supplier_site_code', 'aprx_wt.var.supplier_site_code','VARCHAR2',15);
239:
240: fa_rx_util_pkg.assign_column('7', 'pvs.vat_registration_num', 'vat_registration_number', 'aprx_wt.var.vat_registration_number','VARCHAR2',20);
241:
242:

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

236: fa_rx_util_pkg.assign_column('5', 'pv2.segment1', 'supplier_number', 'aprx_wt.var.supplier_number','VARCHAR2',30);
237:
238: fa_rx_util_pkg.assign_column('6', 'pvs.vendor_site_code', 'supplier_site_code', 'aprx_wt.var.supplier_site_code','VARCHAR2',15);
239:
240: fa_rx_util_pkg.assign_column('7', 'pvs.vat_registration_num', 'vat_registration_number', 'aprx_wt.var.vat_registration_number','VARCHAR2',20);
241:
242:
243: fa_rx_util_pkg.assign_column('8', 'pvs.address_line1', 'supplier_address_line1', 'aprx_wt.var.supplier_address_line1','VARCHAR2',240);
244:

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

239:
240: fa_rx_util_pkg.assign_column('7', 'pvs.vat_registration_num', 'vat_registration_number', 'aprx_wt.var.vat_registration_number','VARCHAR2',20);
241:
242:
243: fa_rx_util_pkg.assign_column('8', 'pvs.address_line1', 'supplier_address_line1', 'aprx_wt.var.supplier_address_line1','VARCHAR2',240);
244:
245: fa_rx_util_pkg.assign_column('9', 'pvs.address_line2', 'supplier_address_line2', 'aprx_wt.var.supplier_address_line2','VARCHAR2',240);
246:
247: fa_rx_util_pkg.assign_column('10', 'pvs.address_line3', 'supplier_address_line3', 'aprx_wt.var.supplier_address_line3','VARCHAR2',240);

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

241:
242:
243: fa_rx_util_pkg.assign_column('8', 'pvs.address_line1', 'supplier_address_line1', 'aprx_wt.var.supplier_address_line1','VARCHAR2',240);
244:
245: fa_rx_util_pkg.assign_column('9', 'pvs.address_line2', 'supplier_address_line2', 'aprx_wt.var.supplier_address_line2','VARCHAR2',240);
246:
247: fa_rx_util_pkg.assign_column('10', 'pvs.address_line3', 'supplier_address_line3', 'aprx_wt.var.supplier_address_line3','VARCHAR2',240);
248:
249: fa_rx_util_pkg.assign_column('11', 'pvs.city', 'supplier_city', 'aprx_wt.var.supplier_city','VARCHAR2',25);

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

243: fa_rx_util_pkg.assign_column('8', 'pvs.address_line1', 'supplier_address_line1', 'aprx_wt.var.supplier_address_line1','VARCHAR2',240);
244:
245: fa_rx_util_pkg.assign_column('9', 'pvs.address_line2', 'supplier_address_line2', 'aprx_wt.var.supplier_address_line2','VARCHAR2',240);
246:
247: fa_rx_util_pkg.assign_column('10', 'pvs.address_line3', 'supplier_address_line3', 'aprx_wt.var.supplier_address_line3','VARCHAR2',240);
248:
249: fa_rx_util_pkg.assign_column('11', 'pvs.city', 'supplier_city', 'aprx_wt.var.supplier_city','VARCHAR2',25);
250:
251: fa_rx_util_pkg.assign_column('12', 'pvs.state', 'supplier_state', 'aprx_wt.var.supplier_state','VARCHAR2',150);

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

245: fa_rx_util_pkg.assign_column('9', 'pvs.address_line2', 'supplier_address_line2', 'aprx_wt.var.supplier_address_line2','VARCHAR2',240);
246:
247: fa_rx_util_pkg.assign_column('10', 'pvs.address_line3', 'supplier_address_line3', 'aprx_wt.var.supplier_address_line3','VARCHAR2',240);
248:
249: fa_rx_util_pkg.assign_column('11', 'pvs.city', 'supplier_city', 'aprx_wt.var.supplier_city','VARCHAR2',25);
250:
251: fa_rx_util_pkg.assign_column('12', 'pvs.state', 'supplier_state', 'aprx_wt.var.supplier_state','VARCHAR2',150);
252:
253: fa_rx_util_pkg.assign_column('13', 'pvs.zip', 'supplier_zip', 'aprx_wt.var.supplier_zip','VARCHAR2',20);

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

247: fa_rx_util_pkg.assign_column('10', 'pvs.address_line3', 'supplier_address_line3', 'aprx_wt.var.supplier_address_line3','VARCHAR2',240);
248:
249: fa_rx_util_pkg.assign_column('11', 'pvs.city', 'supplier_city', 'aprx_wt.var.supplier_city','VARCHAR2',25);
250:
251: fa_rx_util_pkg.assign_column('12', 'pvs.state', 'supplier_state', 'aprx_wt.var.supplier_state','VARCHAR2',150);
252:
253: fa_rx_util_pkg.assign_column('13', 'pvs.zip', 'supplier_zip', 'aprx_wt.var.supplier_zip','VARCHAR2',20);
254:
255: fa_rx_util_pkg.assign_column('14', 'pvs.province', 'supplier_province', 'aprx_wt.var.supplier_province','VARCHAR2',150);

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

249: fa_rx_util_pkg.assign_column('11', 'pvs.city', 'supplier_city', 'aprx_wt.var.supplier_city','VARCHAR2',25);
250:
251: fa_rx_util_pkg.assign_column('12', 'pvs.state', 'supplier_state', 'aprx_wt.var.supplier_state','VARCHAR2',150);
252:
253: fa_rx_util_pkg.assign_column('13', 'pvs.zip', 'supplier_zip', 'aprx_wt.var.supplier_zip','VARCHAR2',20);
254:
255: fa_rx_util_pkg.assign_column('14', 'pvs.province', 'supplier_province', 'aprx_wt.var.supplier_province','VARCHAR2',150);
256:
257: fa_rx_util_pkg.assign_column('15', 'pvs.country', 'supplier_country', 'aprx_wt.var.supplier_country','VARCHAR2',25);

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

251: fa_rx_util_pkg.assign_column('12', 'pvs.state', 'supplier_state', 'aprx_wt.var.supplier_state','VARCHAR2',150);
252:
253: fa_rx_util_pkg.assign_column('13', 'pvs.zip', 'supplier_zip', 'aprx_wt.var.supplier_zip','VARCHAR2',20);
254:
255: fa_rx_util_pkg.assign_column('14', 'pvs.province', 'supplier_province', 'aprx_wt.var.supplier_province','VARCHAR2',150);
256:
257: fa_rx_util_pkg.assign_column('15', 'pvs.country', 'supplier_country', 'aprx_wt.var.supplier_country','VARCHAR2',25);
258:
259: fa_rx_util_pkg.assign_column('16', 'ai.invoice_num', 'invoice_num', 'aprx_wt.var.invoice_num','VARCHAR2',50);

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

253: fa_rx_util_pkg.assign_column('13', 'pvs.zip', 'supplier_zip', 'aprx_wt.var.supplier_zip','VARCHAR2',20);
254:
255: fa_rx_util_pkg.assign_column('14', 'pvs.province', 'supplier_province', 'aprx_wt.var.supplier_province','VARCHAR2',150);
256:
257: fa_rx_util_pkg.assign_column('15', 'pvs.country', 'supplier_country', 'aprx_wt.var.supplier_country','VARCHAR2',25);
258:
259: fa_rx_util_pkg.assign_column('16', 'ai.invoice_num', 'invoice_num', 'aprx_wt.var.invoice_num','VARCHAR2',50);
260:
261: fa_rx_util_pkg.assign_column('17', 'ai.invoice_amount', 'invoice_amount', 'aprx_wt.var.invoice_amount','NUMBER');

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

255: fa_rx_util_pkg.assign_column('14', 'pvs.province', 'supplier_province', 'aprx_wt.var.supplier_province','VARCHAR2',150);
256:
257: fa_rx_util_pkg.assign_column('15', 'pvs.country', 'supplier_country', 'aprx_wt.var.supplier_country','VARCHAR2',25);
258:
259: fa_rx_util_pkg.assign_column('16', 'ai.invoice_num', 'invoice_num', 'aprx_wt.var.invoice_num','VARCHAR2',50);
260:
261: fa_rx_util_pkg.assign_column('17', 'ai.invoice_amount', 'invoice_amount', 'aprx_wt.var.invoice_amount','NUMBER');
262:
263: fa_rx_util_pkg.assign_column('18', 'ai.invoice_currency_code', 'invoice_currency_code', 'aprx_wt.var.invoice_currency_code','VARCHAR2',15);

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

257: fa_rx_util_pkg.assign_column('15', 'pvs.country', 'supplier_country', 'aprx_wt.var.supplier_country','VARCHAR2',25);
258:
259: fa_rx_util_pkg.assign_column('16', 'ai.invoice_num', 'invoice_num', 'aprx_wt.var.invoice_num','VARCHAR2',50);
260:
261: fa_rx_util_pkg.assign_column('17', 'ai.invoice_amount', 'invoice_amount', 'aprx_wt.var.invoice_amount','NUMBER');
262:
263: fa_rx_util_pkg.assign_column('18', 'ai.invoice_currency_code', 'invoice_currency_code', 'aprx_wt.var.invoice_currency_code','VARCHAR2',15);
264:
265: fa_rx_util_pkg.assign_column('19', 'ai.invoice_date', 'invoice_date', 'aprx_wt.var.invoice_date','DATE');

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

259: fa_rx_util_pkg.assign_column('16', 'ai.invoice_num', 'invoice_num', 'aprx_wt.var.invoice_num','VARCHAR2',50);
260:
261: fa_rx_util_pkg.assign_column('17', 'ai.invoice_amount', 'invoice_amount', 'aprx_wt.var.invoice_amount','NUMBER');
262:
263: fa_rx_util_pkg.assign_column('18', 'ai.invoice_currency_code', 'invoice_currency_code', 'aprx_wt.var.invoice_currency_code','VARCHAR2',15);
264:
265: fa_rx_util_pkg.assign_column('19', 'ai.invoice_date', 'invoice_date', 'aprx_wt.var.invoice_date','DATE');
266:
267: fa_rx_util_pkg.assign_column('20', 'atr.tax_name', 'awt_code', 'aprx_wt.var.awt_code','VARCHAR2',15);

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

261: fa_rx_util_pkg.assign_column('17', 'ai.invoice_amount', 'invoice_amount', 'aprx_wt.var.invoice_amount','NUMBER');
262:
263: fa_rx_util_pkg.assign_column('18', 'ai.invoice_currency_code', 'invoice_currency_code', 'aprx_wt.var.invoice_currency_code','VARCHAR2',15);
264:
265: fa_rx_util_pkg.assign_column('19', 'ai.invoice_date', 'invoice_date', 'aprx_wt.var.invoice_date','DATE');
266:
267: fa_rx_util_pkg.assign_column('20', 'atr.tax_name', 'awt_code', 'aprx_wt.var.awt_code','VARCHAR2',15);
268:
269: fa_rx_util_pkg.assign_column('21', 'atr.tax_rate', 'awt_rate', 'aprx_wt.var.awt_rate','NUMBER');

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

263: fa_rx_util_pkg.assign_column('18', 'ai.invoice_currency_code', 'invoice_currency_code', 'aprx_wt.var.invoice_currency_code','VARCHAR2',15);
264:
265: fa_rx_util_pkg.assign_column('19', 'ai.invoice_date', 'invoice_date', 'aprx_wt.var.invoice_date','DATE');
266:
267: fa_rx_util_pkg.assign_column('20', 'atr.tax_name', 'awt_code', 'aprx_wt.var.awt_code','VARCHAR2',15);
268:
269: fa_rx_util_pkg.assign_column('21', 'atr.tax_rate', 'awt_rate', 'aprx_wt.var.awt_rate','NUMBER');
270:
271: fa_rx_util_pkg.assign_column('22', 'nvl(aid.amount*(-1),0)', 'awt_amount', 'aprx_wt.var.awt_amount','NUMBER');

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

265: fa_rx_util_pkg.assign_column('19', 'ai.invoice_date', 'invoice_date', 'aprx_wt.var.invoice_date','DATE');
266:
267: fa_rx_util_pkg.assign_column('20', 'atr.tax_name', 'awt_code', 'aprx_wt.var.awt_code','VARCHAR2',15);
268:
269: fa_rx_util_pkg.assign_column('21', 'atr.tax_rate', 'awt_rate', 'aprx_wt.var.awt_rate','NUMBER');
270:
271: fa_rx_util_pkg.assign_column('22', 'nvl(aid.amount*(-1),0)', 'awt_amount', 'aprx_wt.var.awt_amount','NUMBER');
272:
273: 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 271: fa_rx_util_pkg.assign_column('22', 'nvl(aid.amount*(-1),0)', 'awt_amount', 'aprx_wt.var.awt_amount','NUMBER');

267: fa_rx_util_pkg.assign_column('20', 'atr.tax_name', 'awt_code', 'aprx_wt.var.awt_code','VARCHAR2',15);
268:
269: fa_rx_util_pkg.assign_column('21', 'atr.tax_rate', 'awt_rate', 'aprx_wt.var.awt_rate','NUMBER');
270:
271: fa_rx_util_pkg.assign_column('22', 'nvl(aid.amount*(-1),0)', 'awt_amount', 'aprx_wt.var.awt_amount','NUMBER');
272:
273: 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');
274:
275: fa_rx_util_pkg.assign_column('24', 'atg.name', 'awt_group_name', 'aprx_wt.var.awt_group_name','VARCHAR2',25);

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

269: fa_rx_util_pkg.assign_column('21', 'atr.tax_rate', 'awt_rate', 'aprx_wt.var.awt_rate','NUMBER');
270:
271: fa_rx_util_pkg.assign_column('22', 'nvl(aid.amount*(-1),0)', 'awt_amount', 'aprx_wt.var.awt_amount','NUMBER');
272:
273: 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');
274:
275: fa_rx_util_pkg.assign_column('24', 'atg.name', 'awt_group_name', 'aprx_wt.var.awt_group_name','VARCHAR2',25);
276:
277: fa_rx_util_pkg.assign_column('25', 'aid.accounting_date', 'awt_gl_date', 'aprx_wt.var.awt_gl_date','DATE');

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

271: fa_rx_util_pkg.assign_column('22', 'nvl(aid.amount*(-1),0)', 'awt_amount', 'aprx_wt.var.awt_amount','NUMBER');
272:
273: 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');
274:
275: fa_rx_util_pkg.assign_column('24', 'atg.name', 'awt_group_name', 'aprx_wt.var.awt_group_name','VARCHAR2',25);
276:
277: fa_rx_util_pkg.assign_column('25', 'aid.accounting_date', 'awt_gl_date', 'aprx_wt.var.awt_gl_date','DATE');
278:
279: -- bug 8258934

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

273: 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');
274:
275: fa_rx_util_pkg.assign_column('24', 'atg.name', 'awt_group_name', 'aprx_wt.var.awt_group_name','VARCHAR2',25);
276:
277: fa_rx_util_pkg.assign_column('25', 'aid.accounting_date', 'awt_gl_date', 'aprx_wt.var.awt_gl_date','DATE');
278:
279: -- bug 8258934
280: /* bug 10080788 Modified the below code to consider all different cases to derive proper awt_gross_amount.
281: Refer to bug for more details */

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

279: -- bug 8258934
280: /* bug 10080788 Modified the below code to consider all different cases to derive proper awt_gross_amount.
281: Refer to bug for more details */
282:
283: -- fa_rx_util_pkg.assign_column('26', 'aid.awt_gross_amount', 'awt_gross_amount', 'aprx_wt.var.awt_gross_amount','NUMBER');
284: /* fa_rx_util_pkg.assign_column('26', 'DECODE(aid.reversal_flag,''Y'',aid.awt_gross_amount,nvl(DECODE(atc.awt_rate_type,''R'',aid.awt_gross_amount, '||
285: 'DECODE((ROW_NUMBER() OVER (PARTITION BY aid.invoice_id, aid.awt_origin_group_id, aid.awt_related_id '||
286: 'ORDER BY aid.awt_group_id, aid.invoice_line_number, aid.distribution_line_number)), 1, aid1.amount , 0))'||
287: ',aid.awt_gross_amount))', 'awt_gross_amount', 'aprx_wt.var.awt_gross_amount','NUMBER');

Line 284: /* fa_rx_util_pkg.assign_column('26', 'DECODE(aid.reversal_flag,''Y'',aid.awt_gross_amount,nvl(DECODE(atc.awt_rate_type,''R'',aid.awt_gross_amount, '||

280: /* bug 10080788 Modified the below code to consider all different cases to derive proper awt_gross_amount.
281: Refer to bug for more details */
282:
283: -- fa_rx_util_pkg.assign_column('26', 'aid.awt_gross_amount', 'awt_gross_amount', 'aprx_wt.var.awt_gross_amount','NUMBER');
284: /* fa_rx_util_pkg.assign_column('26', 'DECODE(aid.reversal_flag,''Y'',aid.awt_gross_amount,nvl(DECODE(atc.awt_rate_type,''R'',aid.awt_gross_amount, '||
285: 'DECODE((ROW_NUMBER() OVER (PARTITION BY aid.invoice_id, aid.awt_origin_group_id, aid.awt_related_id '||
286: 'ORDER BY aid.awt_group_id, aid.invoice_line_number, aid.distribution_line_number)), 1, aid1.amount , 0))'||
287: ',aid.awt_gross_amount))', 'awt_gross_amount', 'aprx_wt.var.awt_gross_amount','NUMBER');
288:

Line 291: fa_rx_util_pkg.assign_column('26', 'DECODE(aid.reversal_flag,''Y'',nvl(aid.awt_gross_amount,0),nvl(DECODE(atc.awt_rate_type,'||

287: ',aid.awt_gross_amount))', 'awt_gross_amount', 'aprx_wt.var.awt_gross_amount','NUMBER');
288:
289: Bug 10220008 Commented the above code and replaced it with the following code */
290:
291: fa_rx_util_pkg.assign_column('26', 'DECODE(aid.reversal_flag,''Y'',nvl(aid.awt_gross_amount,0),nvl(DECODE(atc.awt_rate_type,'||
292: '''R'',DECODE((ROW_NUMBER() OVER (PARTITION BY aid.invoice_id, aid.awt_origin_group_id, '||
293: 'aid.awt_tax_rate_id ORDER BY nvl(aid.awt_group_id,aid.pay_awt_group_id), aid.invoice_line_number'||
294: ', aid.distribution_line_number)), 1, aid.awt_gross_amount , 0),'||
295: 'DECODE((ROW_NUMBER() OVER (PARTITION BY aid.invoice_id, aid.awt_origin_group_id '||

Line 301: fa_rx_util_pkg.assign_column('27', 'hrl.address_line_1', 'address_line1','aprx_wt.var.address_line1', 'VARCHAR2',240); --bug9897890

297: ', 1, aid.awt_gross_amount , 0)),aid.awt_gross_amount))', 'awt_gross_amount', 'aprx_wt.var.awt_gross_amount','NUMBER');
298:
299: /*Bug 9897890 Modified the below calls and added values like hrl.address_line_1,hrl.address_line_2*/
300:
301: fa_rx_util_pkg.assign_column('27', 'hrl.address_line_1', 'address_line1','aprx_wt.var.address_line1', 'VARCHAR2',240); --bug9897890
302:
303: fa_rx_util_pkg.assign_column('28', 'hrl.address_line_2', 'address_line2','aprx_wt.var.address_line2', 'VARCHAR2',240); --bug9897890
304:
305: fa_rx_util_pkg.assign_column('29', 'hrl.address_line_3', 'address_line3','aprx_wt.var.address_line3', 'VARCHAR2',240); --bug9897890

Line 303: fa_rx_util_pkg.assign_column('28', 'hrl.address_line_2', 'address_line2','aprx_wt.var.address_line2', 'VARCHAR2',240); --bug9897890

299: /*Bug 9897890 Modified the below calls and added values like hrl.address_line_1,hrl.address_line_2*/
300:
301: fa_rx_util_pkg.assign_column('27', 'hrl.address_line_1', 'address_line1','aprx_wt.var.address_line1', 'VARCHAR2',240); --bug9897890
302:
303: fa_rx_util_pkg.assign_column('28', 'hrl.address_line_2', 'address_line2','aprx_wt.var.address_line2', 'VARCHAR2',240); --bug9897890
304:
305: fa_rx_util_pkg.assign_column('29', 'hrl.address_line_3', 'address_line3','aprx_wt.var.address_line3', 'VARCHAR2',240); --bug9897890
306:
307: fa_rx_util_pkg.assign_column('30', 'hrl.town_or_city', 'city','aprx_wt.var.city', 'VARCHAR2',30); --bug9897890

Line 305: fa_rx_util_pkg.assign_column('29', 'hrl.address_line_3', 'address_line3','aprx_wt.var.address_line3', 'VARCHAR2',240); --bug9897890

301: fa_rx_util_pkg.assign_column('27', 'hrl.address_line_1', 'address_line1','aprx_wt.var.address_line1', 'VARCHAR2',240); --bug9897890
302:
303: fa_rx_util_pkg.assign_column('28', 'hrl.address_line_2', 'address_line2','aprx_wt.var.address_line2', 'VARCHAR2',240); --bug9897890
304:
305: fa_rx_util_pkg.assign_column('29', 'hrl.address_line_3', 'address_line3','aprx_wt.var.address_line3', 'VARCHAR2',240); --bug9897890
306:
307: fa_rx_util_pkg.assign_column('30', 'hrl.town_or_city', 'city','aprx_wt.var.city', 'VARCHAR2',30); --bug9897890
308:
309: fa_rx_util_pkg.assign_column('31', 'hrl.postal_code', 'zip','aprx_wt.var.zip', 'VARCHAR2',30); --bug9897890

Line 307: fa_rx_util_pkg.assign_column('30', 'hrl.town_or_city', 'city','aprx_wt.var.city', 'VARCHAR2',30); --bug9897890

303: fa_rx_util_pkg.assign_column('28', 'hrl.address_line_2', 'address_line2','aprx_wt.var.address_line2', 'VARCHAR2',240); --bug9897890
304:
305: fa_rx_util_pkg.assign_column('29', 'hrl.address_line_3', 'address_line3','aprx_wt.var.address_line3', 'VARCHAR2',240); --bug9897890
306:
307: fa_rx_util_pkg.assign_column('30', 'hrl.town_or_city', 'city','aprx_wt.var.city', 'VARCHAR2',30); --bug9897890
308:
309: fa_rx_util_pkg.assign_column('31', 'hrl.postal_code', 'zip','aprx_wt.var.zip', 'VARCHAR2',30); --bug9897890
310:
311: fa_rx_util_pkg.assign_column('32', 'hrl.country', 'country','aprx_wt.var.country', 'VARCHAR2',60); --bug9897890

Line 309: fa_rx_util_pkg.assign_column('31', 'hrl.postal_code', 'zip','aprx_wt.var.zip', 'VARCHAR2',30); --bug9897890

305: fa_rx_util_pkg.assign_column('29', 'hrl.address_line_3', 'address_line3','aprx_wt.var.address_line3', 'VARCHAR2',240); --bug9897890
306:
307: fa_rx_util_pkg.assign_column('30', 'hrl.town_or_city', 'city','aprx_wt.var.city', 'VARCHAR2',30); --bug9897890
308:
309: fa_rx_util_pkg.assign_column('31', 'hrl.postal_code', 'zip','aprx_wt.var.zip', 'VARCHAR2',30); --bug9897890
310:
311: fa_rx_util_pkg.assign_column('32', 'hrl.country', 'country','aprx_wt.var.country', 'VARCHAR2',60); --bug9897890
312:
313: fa_rx_util_pkg.assign_column('33', 'hou.name', 'organization_name','aprx_wt.var.organization_name', 'VARCHAR2',240); --bug7621919

Line 311: fa_rx_util_pkg.assign_column('32', 'hrl.country', 'country','aprx_wt.var.country', 'VARCHAR2',60); --bug9897890

307: fa_rx_util_pkg.assign_column('30', 'hrl.town_or_city', 'city','aprx_wt.var.city', 'VARCHAR2',30); --bug9897890
308:
309: fa_rx_util_pkg.assign_column('31', 'hrl.postal_code', 'zip','aprx_wt.var.zip', 'VARCHAR2',30); --bug9897890
310:
311: fa_rx_util_pkg.assign_column('32', 'hrl.country', 'country','aprx_wt.var.country', 'VARCHAR2',60); --bug9897890
312:
313: fa_rx_util_pkg.assign_column('33', 'hou.name', 'organization_name','aprx_wt.var.organization_name', 'VARCHAR2',240); --bug7621919
314:
315: fa_rx_util_pkg.assign_column('34', 'gld.currency_code', 'functional_currency_code','aprx_wt.var.functional_currency_code', 'VARCHAR2',15); --bug9897890

Line 313: fa_rx_util_pkg.assign_column('33', 'hou.name', 'organization_name','aprx_wt.var.organization_name', 'VARCHAR2',240); --bug7621919

309: fa_rx_util_pkg.assign_column('31', 'hrl.postal_code', 'zip','aprx_wt.var.zip', 'VARCHAR2',30); --bug9897890
310:
311: fa_rx_util_pkg.assign_column('32', 'hrl.country', 'country','aprx_wt.var.country', 'VARCHAR2',60); --bug9897890
312:
313: fa_rx_util_pkg.assign_column('33', 'hou.name', 'organization_name','aprx_wt.var.organization_name', 'VARCHAR2',240); --bug7621919
314:
315: fa_rx_util_pkg.assign_column('34', 'gld.currency_code', 'functional_currency_code','aprx_wt.var.functional_currency_code', 'VARCHAR2',15); --bug9897890
316:
317: fa_rx_util_pkg.assign_column('35', 'hrl.region_1', 'province','aprx_wt.var.province', 'VARCHAR2',150);

Line 315: fa_rx_util_pkg.assign_column('34', 'gld.currency_code', 'functional_currency_code','aprx_wt.var.functional_currency_code', 'VARCHAR2',15); --bug9897890

311: fa_rx_util_pkg.assign_column('32', 'hrl.country', 'country','aprx_wt.var.country', 'VARCHAR2',60); --bug9897890
312:
313: fa_rx_util_pkg.assign_column('33', 'hou.name', 'organization_name','aprx_wt.var.organization_name', 'VARCHAR2',240); --bug7621919
314:
315: fa_rx_util_pkg.assign_column('34', 'gld.currency_code', 'functional_currency_code','aprx_wt.var.functional_currency_code', 'VARCHAR2',15); --bug9897890
316:
317: fa_rx_util_pkg.assign_column('35', 'hrl.region_1', 'province','aprx_wt.var.province', 'VARCHAR2',150);
318:
319: fa_rx_util_pkg.assign_column('36', 'hrl.region_2', 'state','aprx_wt.var.state', 'VARCHAR2',150);

Line 317: fa_rx_util_pkg.assign_column('35', 'hrl.region_1', 'province','aprx_wt.var.province', 'VARCHAR2',150);

313: fa_rx_util_pkg.assign_column('33', 'hou.name', 'organization_name','aprx_wt.var.organization_name', 'VARCHAR2',240); --bug7621919
314:
315: fa_rx_util_pkg.assign_column('34', 'gld.currency_code', 'functional_currency_code','aprx_wt.var.functional_currency_code', 'VARCHAR2',15); --bug9897890
316:
317: fa_rx_util_pkg.assign_column('35', 'hrl.region_1', 'province','aprx_wt.var.province', 'VARCHAR2',150);
318:
319: fa_rx_util_pkg.assign_column('36', 'hrl.region_2', 'state','aprx_wt.var.state', 'VARCHAR2',150);
320:
321: -->>SELECT_END<<--

Line 319: fa_rx_util_pkg.assign_column('36', 'hrl.region_2', 'state','aprx_wt.var.state', 'VARCHAR2',150);

315: fa_rx_util_pkg.assign_column('34', 'gld.currency_code', 'functional_currency_code','aprx_wt.var.functional_currency_code', 'VARCHAR2',15); --bug9897890
316:
317: fa_rx_util_pkg.assign_column('35', 'hrl.region_1', 'province','aprx_wt.var.province', 'VARCHAR2',150);
318:
319: fa_rx_util_pkg.assign_column('36', 'hrl.region_2', 'state','aprx_wt.var.state', 'VARCHAR2',150);
320:
321: -->>SELECT_END<<--
322:
323:

Line 330: fa_rx_util_pkg.From_Clause :=

326: --
327: /*Bug 9897890 Added the tables hr_locations, gl_ledgers to the from clause
328: Bug 10080788 Added a self join to table ap_invoice_distributions_all */
329:
330: fa_rx_util_pkg.From_Clause :=
331: 'po_vendors pv2,
332: po_vendors pv1,
333: po_vendor_sites pvs ,
334: ap_invoices ai,

Line 351: --begin bug12694504, changed the fa_rx_util_pkg.where_clase

347:
348: /*Bug 9897890 Added joins with tables hr_locations, gl_ledgers to the where clause
349: Bug 10080788 Added a self join to table ap_invoice_distributions_all */
350:
351: --begin bug12694504, changed the fa_rx_util_pkg.where_clase
352: /*
353: fa_rx_util_pkg.Where_Clause := 'pv2.vendor_id = ai.vendor_id and
354: pvs.vendor_site_id = ai.vendor_site_id and
355: atg.group_id(+) = aid.awt_origin_group_id and

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

349: Bug 10080788 Added a self join to table ap_invoice_distributions_all */
350:
351: --begin bug12694504, changed the fa_rx_util_pkg.where_clase
352: /*
353: fa_rx_util_pkg.Where_Clause := 'pv2.vendor_id = ai.vendor_id and
354: pvs.vendor_site_id = ai.vendor_site_id and
355: atg.group_id(+) = aid.awt_origin_group_id and
356: ai.invoice_id = aid.invoice_id and
357: aid.withholding_tax_code_id = atc.tax_id and

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

363: hou.organization_id = aid.org_id and
364: ai.set_of_books_id = gld.ledger_id and
365: hrl.location_id = hou.location_id'; --bug7621919 bug9897890 bug10090309
366: */
367: fa_rx_util_pkg.Where_Clause := 'pv2.vendor_id = ai.vendor_id and
368: pvs.vendor_site_id = ai.vendor_site_id and
369: atg.group_id(+) = aid.awt_origin_group_id and
370: ai.invoice_id = aid.invoice_id and
371: aid.withholding_tax_code_id = atc.tax_id(+) and

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

377: ai.set_of_books_id = gld.ledger_id and
378: hrl.location_id = hou.location_id'; --bug7621919 bug9897890 bug10090309
379: --end bug12694504
380:
381: fa_rx_util_pkg.debug('aprx_wt.before_report()-');
382:
383: END BEFORE_REPORT;
384:
385: /* Bug7376771 -- Modified the tax_code_id to withholding_tax_code_id as in R12

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

453: ELSE
454: parm.P_System_Acct_Method := 'BOTH';
455: END IF;
456:
457: fa_rx_util_pkg.debug('system_acct_method'||parm.P_System_Acct_Method);
458:
459: -- Add the WHERE clause which is specific to the AP Witholding Report
460:
461: IF parm.p_date_from IS NOT NULL THEN

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

458:
459: -- Add the WHERE clause which is specific to the AP Witholding Report
460:
461: IF parm.p_date_from IS NOT NULL THEN
462: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause || ' and aid.accounting_date >= fnd_date.canonical_to_date(:b_date_from)' ;
463: END IF;
464:
465: IF parm.p_date_to IS NOT NULL THEN
466: 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 466: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause || ' and aid.accounting_date <= fnd_date.canonical_to_date(:b_date_to) ';

462: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause || ' and aid.accounting_date >= fnd_date.canonical_to_date(:b_date_from)' ;
463: END IF;
464:
465: IF parm.p_date_to IS NOT NULL THEN
466: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause || ' and aid.accounting_date <= fnd_date.canonical_to_date(:b_date_to) ';
467: END IF;
468:
469: IF parm.p_supplier_from IS NOT NULL THEN
470: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause || ' and UPPER(pv2.vendor_name) >= UPPER(:b_supplier_from)';

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

466: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause || ' and aid.accounting_date <= fnd_date.canonical_to_date(:b_date_to) ';
467: END IF;
468:
469: IF parm.p_supplier_from IS NOT NULL THEN
470: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause || ' and UPPER(pv2.vendor_name) >= UPPER(:b_supplier_from)';
471: END IF;
472:
473: IF parm.p_supplier_to IS NOT NULL THEN
474: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause || ' and UPPER(pv2.vendor_name) <= UPPER(:b_supplier_to)' ;

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

470: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause || ' and UPPER(pv2.vendor_name) >= UPPER(:b_supplier_from)';
471: END IF;
472:
473: IF parm.p_supplier_to IS NOT NULL THEN
474: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause || ' and UPPER(pv2.vendor_name) <= UPPER(:b_supplier_to)' ;
475: END IF;
476:
477: IF parm.p_supplier_type IS NOT NULL THEN
478: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause || ' and pv2.vendor_type_lookup_code = :b_supplier_type';

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

474: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause || ' and UPPER(pv2.vendor_name) <= UPPER(:b_supplier_to)' ;
475: END IF;
476:
477: IF parm.p_supplier_type IS NOT NULL THEN
478: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause || ' and pv2.vendor_type_lookup_code = :b_supplier_type';
479: END IF;
480:
481: IF parm.p_system_acct_method IS NOT NULL THEN
482: 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 482: 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)';

478: fa_rx_util_pkg.Where_clause := fa_rx_util_pkg.Where_clause || ' and pv2.vendor_type_lookup_code = :b_supplier_type';
479: END IF;
480:
481: IF parm.p_system_acct_method IS NOT NULL THEN
482: 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)';
483: 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)';
484: END IF;
485:
486: fa_rx_util_pkg.debug('aprx_wt.awt_before_report()-');

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

479: END IF;
480:
481: IF parm.p_system_acct_method IS NOT NULL THEN
482: 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)';
483: 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)';
484: END IF;
485:
486: fa_rx_util_pkg.debug('aprx_wt.awt_before_report()-');
487:

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

482: 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)';
483: 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)';
484: END IF;
485:
486: fa_rx_util_pkg.debug('aprx_wt.awt_before_report()-');
487:
488: END awt_before_report;
489:
490: -- This is the bind trigger for the

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

496: b_supplier_to AP_SUPPLIERS.vendor_name%TYPE; -- Bug 10021563 varchar2(80);
497: b_supplier_type PO_LOOKUP_CODES.lookup_code%TYPE; -- Bug 10021563 varchar2(25);
498: b_system_acct_method varchar2(240);
499: BEGIN
500: fa_rx_util_pkg.debug('aprx_wt.awt_bind()+');
501:
502: IF parm.p_date_from is not null then
503: fa_rx_util_pkg.debug('Binding b_date_from');
504: dbms_sql.bind_variable(c, 'b_date_from', parm.p_date_from);

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

499: BEGIN
500: fa_rx_util_pkg.debug('aprx_wt.awt_bind()+');
501:
502: IF parm.p_date_from is not null then
503: fa_rx_util_pkg.debug('Binding b_date_from');
504: dbms_sql.bind_variable(c, 'b_date_from', parm.p_date_from);
505: END IF;
506:
507: IF parm.p_date_to is not null then

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

504: dbms_sql.bind_variable(c, 'b_date_from', parm.p_date_from);
505: END IF;
506:
507: IF parm.p_date_to is not null then
508: fa_rx_util_pkg.debug('Binding b_date_to');
509: dbms_sql.bind_variable(c, 'b_date_to', parm.p_date_to);
510: END IF;
511:
512: IF parm.p_supplier_from is not null then

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

509: dbms_sql.bind_variable(c, 'b_date_to', parm.p_date_to);
510: END IF;
511:
512: IF parm.p_supplier_from is not null then
513: fa_rx_util_pkg.debug('Binding b_supplier_from');
514: dbms_sql.bind_variable(c, 'b_supplier_from', parm.p_supplier_from);
515: END IF;
516:
517: IF parm.p_supplier_to is not null then

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

514: dbms_sql.bind_variable(c, 'b_supplier_from', parm.p_supplier_from);
515: END IF;
516:
517: IF parm.p_supplier_to is not null then
518: fa_rx_util_pkg.debug('Binding b_supplier_to');
519: dbms_sql.bind_variable(c, 'b_supplier_to', parm.p_supplier_to);
520: END IF;
521:
522: IF parm.p_supplier_type is not null then

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

519: dbms_sql.bind_variable(c, 'b_supplier_to', parm.p_supplier_to);
520: END IF;
521:
522: IF parm.p_supplier_type is not null then
523: fa_rx_util_pkg.debug('Binding b_supplier_type_from');
524: dbms_sql.bind_variable(c, 'b_supplier_type', parm.p_supplier_type);
525: END IF;
526:
527: IF parm.p_system_acct_method is not null then

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

524: dbms_sql.bind_variable(c, 'b_supplier_type', parm.p_supplier_type);
525: END IF;
526:
527: IF parm.p_system_acct_method is not null then
528: fa_rx_util_pkg.debug('Binding b_system_acct_method');
529: dbms_sql.bind_variable(c, 'b_system_acct_method', parm.p_system_acct_method);
530: END IF;
531:
532: fa_rx_util_pkg.debug('aprx_wt.awt_bind()-');

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

528: fa_rx_util_pkg.debug('Binding b_system_acct_method');
529: dbms_sql.bind_variable(c, 'b_system_acct_method', parm.p_system_acct_method);
530: END IF;
531:
532: fa_rx_util_pkg.debug('aprx_wt.awt_bind()-');
533:
534: END awt_bind;
535:
536: