[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
260: END IF;
261:
262: BEGIN
263: IF p_report_name = 'JEPTAVAT' THEN --Only for annual report, period year is passed
264: jg_zz_common_pkg.funct_curr_legal(x_func_curr_code => l_func_curr
265: ,x_rep_entity_name => l_legal_entity_name
266: ,x_legal_entity_id => l_legal_entity_id
267: ,x_taxpayer_id => l_tax_payer_id
268: ,pn_vat_rep_entity_id => p_vat_rep_entity_id
269: ,pn_period_year => to_number(p_period));
270:
271: p_legal_entity_id := l_legal_entity_id;
272: ELSE
273: jg_zz_common_pkg.funct_curr_legal(x_func_curr_code => l_func_curr
274: ,x_rep_entity_name => l_legal_entity_name
275: ,x_legal_entity_id => l_legal_entity_id
276: ,x_taxpayer_id => l_tax_payer_id
277: ,pn_vat_rep_entity_id => p_vat_rep_entity_id
280: p_legal_entity_id := l_legal_entity_id;
281: END IF ;
282: EXCEPTION
283: WHEN OTHERS THEN
284: fnd_file.put_line(fnd_file.log,'Executing jg_zz_common_pkg.funct_curr_legal: '||SUBSTR(SQLERRM,1,200));
285: END;
286:
287: BEGIN
288: IF p_report_name = 'JEPTAVAT' THEN
285: END;
286:
287: BEGIN
288: IF p_report_name = 'JEPTAVAT' THEN
289: jg_zz_common_pkg.tax_registration(x_tax_registration => l_tax_registration_num
290: ,x_period_start_date => l_period_start_date
291: ,x_period_end_date => l_period_end_date
292: ,x_status => l_reporting_status
293: ,pn_vat_rep_entity_id => p_vat_rep_entity_id
294: ,pv_period_name => NULL
295: ,pn_period_year => to_number(p_period)
296: ,pv_source => 'ALL');
297: ELSE
298: jg_zz_common_pkg.tax_registration(x_tax_registration => l_tax_registration_num
299: ,x_period_start_date => l_period_start_date
300: ,x_period_end_date => l_period_end_date
301: ,x_status => l_reporting_status
302: ,pn_vat_rep_entity_id => p_vat_rep_entity_id
305: ,pv_source => 'ALL');
306: END IF;
307: EXCEPTION
308: WHEN OTHERS THEN
309: fnd_file.put_line(fnd_file.log,'Executing jg_zz_common_pkg.tax_registration: '||SUBSTR(SQLERRM,1,200));
310: END;
311:
312: BEGIN
313: if(P_REPORT_NAME <> 'JEPTAVAT' )then
331: end if;
332:
333: EXCEPTION
334: WHEN OTHERS THEN
335: fnd_file.put_line(fnd_file.log,'Executing jg_zz_common_pkg.tax_registration: '||SUBSTR(SQLERRM,1,200));
336: END;
337:
338: BEGIN
339: jg_zz_common_pkg.company_detail(x_company_name => l_company_name
335: fnd_file.put_line(fnd_file.log,'Executing jg_zz_common_pkg.tax_registration: '||SUBSTR(SQLERRM,1,200));
336: END;
337:
338: BEGIN
339: jg_zz_common_pkg.company_detail(x_company_name => l_company_name
340: ,x_registration_number => l_registration_num
341: ,x_country => l_country
342: ,x_address1 => l_address_line_1
343: ,x_address2 => l_address_line_2
353: ,pn_legal_entity_id => l_legal_entity_id
354: ,p_vat_reporting_entity_id => P_VAT_REP_ENTITY_ID);
355: EXCEPTION
356: WHEN OTHERS THEN
357: fnd_file.put_line(fnd_file.log,'Executing jg_zz_common_pkg.company_detail: '||SUBSTR(SQLERRM,1,200));
358: END;
359: BEGIN
360: SELECT activity_code
361: INTO l_activity_code