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 APRX_WT

Line 1: PACKAGE BODY APRX_WT AS

1: PACKAGE BODY APRX_WT AS
2: /* $Header: aprxwtb.pls 120.15 2011/10/12 06:36:09 tjbhatt ship $ */
3:
4: /*Bug 9897890 Added the below parameters to enable fnd log */
5:

Line 13: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'AP.PLSQL.APRX_WT.';

9: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
10: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
11: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
12: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
13: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'AP.PLSQL.APRX_WT.';
14:
15: DBG_Loc VARCHAR2(30) := 'GET_WITHOLDING_TAX';
16: debug_info VARCHAR2(20000);
17: -- Structure to hold values of parameters

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 52: 'aprx_wt.before_report;',

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,
55: NULL);
56:

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 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 85: debug_info := 'aprx_wt.ap_wht_tax_report()+';

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;
89: debug_info := 'p_date_from '||p_date_from;

Line 110: aprx_wt.get_witholding_tax (

106: -- Call the core report.This executes the core report and the SELECT statement of the core
107: -- is built.Now the plug-in has to add only what is specific to it.
108: -- No data is inserted into the interface table.
109:
110: aprx_wt.get_witholding_tax (
111: request_id,
112: 'get_witholding_tax',
113: retcode,
114: errbuf);

Line 119: 'aprx_wt.awt_before_report;',

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);
122:
123: fa_rx_util_pkg.run_report('aprx_wt.ap_wht_tax_report', retcode, errbuf);

Line 120: 'aprx_wt.awt_bind(:CURSOR_SELECT);',

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);
122:
123: fa_rx_util_pkg.run_report('aprx_wt.ap_wht_tax_report', retcode, errbuf);
124:

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 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 287: ',aid.awt_gross_amount))', 'awt_gross_amount', 'aprx_wt.var.awt_gross_amount','NUMBER');

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:
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,'||

Line 297: ', 1, aid.awt_gross_amount , 0)),aid.awt_gross_amount))', 'awt_gross_amount', 'aprx_wt.var.awt_gross_amount','NUMBER');

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 '||
296: 'ORDER BY nvl(aid.awt_group_id,aid.pay_awt_group_id), aid.invoice_line_number, aid.distribution_line_number))'||
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

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 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 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 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:

Line 543: END APRX_WT;

539: END OF AP WITHHOLDING TAX REPORT
540:
541: ===============================================================================================*/
542:
543: END APRX_WT;