[Home] [Help]
38: -- 120.6 26-Apr-2006 Ramananda Pokkula In Proceudre jeptavat: Removed
39: -- dummy insert statements. Added
40: -- missing join condition:
41: -- AL.vat_transaction_id = JG.vat_transaction_id
42: -- In the call jg_zz_common_pkg.tax_registration
43: -- pn_period_year parameter is changed to
44: -- pv_period_name
45: -- 120.7 28-Apr-2006 Ramananda Pokkula Dummy assignments are removed
46: -- 120.8 31-May-2006 Ramananda Pokkula Refer bug#5258440 for UT changes
79: -- to avoid ORA 1403.
80: -- 120.20 25-AUG-2006 SPASUPUN Bug:5553811. Modified the cursor-c_pt_annual_vat
81: -- select query for column tax_class.
82: -- Added a separate call to API
83: -- jg_zz_common_pkg.tax_registration for report
84: -- JEPTAVAT. Included some debug messages.
85: -- 120.21 05-SEP-2006 RJREDDY Bug: 5563317. Modified c_belgian_vat cursor
86: -- query, so that the Taxable_Amt should always be
87: -- multiplied by taxable_non_rec_sign_flag and Tax_Amt
191: END IF;
192:
193: BEGIN
194: IF p_report_name = 'JEPTAVAT' THEN --Only for annual report, period year is passed
195: jg_zz_common_pkg.funct_curr_legal(x_func_curr_code => l_func_curr
196: ,x_rep_entity_name => l_legal_entity_name
197: ,x_legal_entity_id => l_legal_entity_id
198: ,x_taxpayer_id => l_tax_payer_id
199: ,pn_vat_rep_entity_id => p_vat_rep_entity_id
200: ,pn_period_year => to_number(p_period));
201:
202: p_legal_entity_id := l_legal_entity_id;
203: ELSE
204: jg_zz_common_pkg.funct_curr_legal(x_func_curr_code => l_func_curr
205: ,x_rep_entity_name => l_legal_entity_name
206: ,x_legal_entity_id => l_legal_entity_id
207: ,x_taxpayer_id => l_tax_payer_id
208: ,pn_vat_rep_entity_id => p_vat_rep_entity_id
211: p_legal_entity_id := l_legal_entity_id;
212: END IF ;
213: EXCEPTION
214: WHEN OTHERS THEN
215: fnd_file.put_line(fnd_file.log,'Executing jg_zz_common_pkg.funct_curr_legal: '||SUBSTR(SQLERRM,1,200));
216: END;
217:
218: BEGIN
219: IF p_report_name = 'JEPTAVAT' THEN
216: END;
217:
218: BEGIN
219: IF p_report_name = 'JEPTAVAT' THEN
220: jg_zz_common_pkg.tax_registration(x_tax_registration => l_tax_registration_num
221: ,x_period_start_date => l_period_start_date
222: ,x_period_end_date => l_period_end_date
223: ,x_status => l_reporting_status
224: ,pn_vat_rep_entity_id => p_vat_rep_entity_id
225: ,pv_period_name => NULL
226: ,pn_period_year => to_number(p_period)
227: ,pv_source => 'ALL');
228: ELSE
229: jg_zz_common_pkg.tax_registration(x_tax_registration => l_tax_registration_num
230: ,x_period_start_date => l_period_start_date
231: ,x_period_end_date => l_period_end_date
232: ,x_status => l_reporting_status
233: ,pn_vat_rep_entity_id => p_vat_rep_entity_id
236: ,pv_source => 'ALL');
237: END IF;
238: EXCEPTION
239: WHEN OTHERS THEN
240: fnd_file.put_line(fnd_file.log,'Executing jg_zz_common_pkg.tax_registration: '||SUBSTR(SQLERRM,1,200));
241: END;
242:
243: BEGIN
244: if(P_REPORT_NAME <> 'JEPTAVAT' )then
262: end if;
263:
264: EXCEPTION
265: WHEN OTHERS THEN
266: fnd_file.put_line(fnd_file.log,'Executing jg_zz_common_pkg.tax_registration: '||SUBSTR(SQLERRM,1,200));
267: END;
268:
269: BEGIN
270: jg_zz_common_pkg.company_detail(x_company_name => l_company_name
266: fnd_file.put_line(fnd_file.log,'Executing jg_zz_common_pkg.tax_registration: '||SUBSTR(SQLERRM,1,200));
267: END;
268:
269: BEGIN
270: jg_zz_common_pkg.company_detail(x_company_name => l_company_name
271: ,x_registration_number => l_registration_num
272: ,x_country => l_country
273: ,x_address1 => l_address_line_1
274: ,x_address2 => l_address_line_2
284: ,pn_legal_entity_id => l_legal_entity_id
285: ,p_vat_reporting_entity_id => P_VAT_REP_ENTITY_ID);
286: EXCEPTION
287: WHEN OTHERS THEN
288: fnd_file.put_line(fnd_file.log,'Executing jg_zz_common_pkg.company_detail: '||SUBSTR(SQLERRM,1,200));
289: END;
290: BEGIN
291: SELECT activity_code
292: INTO l_activity_code