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.JG_ZZ_VAT_REP_UTILITY dependencies on JG_ZZ_VAT_FINAL_REPORTS

Line 956: from jg_zz_vat_final_reports fin,jg_zz_vat_rep_status rep

952: /* check if final rep has been done before */
953: begin
954: select 'Y'
955: into lf_final_flag
956: from jg_zz_vat_final_reports fin,jg_zz_vat_rep_status rep
957: where fin.REPORT_NAME = pv_report_name
958: and NVL(fin.vat_register_id, -1) = NVL(pv_vat_register_id, -1)
959: and fin.REPORTING_STATUS_ID = rep.reporting_status_id
960: and rep.vat_reporting_entity_id = pn_vat_reporting_entity_id

Line 1004: insert into jg_zz_vat_final_reports

1000: ,pv_tax_calendar_period
1001: ,pv_tax_calendar_year
1002: ,lv_source)
1003: loop
1004: insert into jg_zz_vat_final_reports
1005: (
1006: FINAL_REPORT_ID
1007: , REPORTING_STATUS_ID
1008: , REPORT_NAME

Line 1023: jg_zz_vat_final_reports_s.NEXTVAL

1019: , OBJECT_VERSION_NUMBER
1020: )
1021: values
1022: (
1023: jg_zz_vat_final_reports_s.NEXTVAL
1024: , i.reporting_status_id
1025: , pv_report_name
1026: , pv_vat_register_id
1027: , nvl(fnd_profile.value('USER_ID'),1)