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_JOURNAL_AP_PKG dependencies on JG_ZZ_VAT_FINAL_REPORTS

Line 21: FROM jg_zz_vat_final_reports vfr,

17: l_period_start_date DATE;
18: BEGIN
19: SELECT max(vrs.period_start_date)
20: INTO l_period_start_date
21: FROM jg_zz_vat_final_reports vfr,
22: jg_zz_vat_rep_status vrs
23: WHERE vfr.report_name = p_report_name
24: AND vfr.vat_register_id = p_vat_register_id
25: AND vrs.reporting_status_id = vfr.reporting_status_id;

Line 29: FROM jg_zz_vat_final_reports vfr,

25: AND vrs.reporting_status_id = vfr.reporting_status_id;
26:
27: SELECT nvl(start_sequence_num,0)
28: INTO l_start_seq
29: FROM jg_zz_vat_final_reports vfr,
30: jg_zz_vat_rep_status vrs
31: WHERE vfr.report_name = p_report_name
32: AND vfr.vat_register_id = p_vat_register_id
33: AND vrs.reporting_status_id = vfr.reporting_status_id

Line 197: FROM jg_zz_vat_final_reports vfr,

193: -- Insert the record into jg_zz_vat_trx_gt with Sequence and reporting mode info
194: IF l_reporting_status = 'COPY' THEN
195: SELECT last_start_sequence_num
196: INTO l_start_seq
197: FROM jg_zz_vat_final_reports vfr,
198: jg_zz_vat_rep_status vrs
199: WHERE vfr.report_name = p_report_name
200: AND vfr.vat_register_id = p_vat_register_id
201: AND vrs.reporting_status_id = vfr.reporting_status_id

Line 751: lv_start_seq jg_zz_vat_final_reports.start_sequence_num%type;

747: -- BUG 7451529 : Invoices with zero tax amounts should also get picked up. For eg:
748: -- the ones which use 'EXEMPT' tax-type.
749:
750:
751: lv_start_seq jg_zz_vat_final_reports.start_sequence_num%type;
752: lv_reporting_status varchar2(15);
753:
754: BEGIN
755:

Line 842: -- Update teh jg_zz_vat_final_reports table for print sequence numbers if lv_reporting_status = 'FINAL'

838: IF p_debug_flag = 'Y' THEN
839: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );
840: END IF ;
841:
842: -- Update teh jg_zz_vat_final_reports table for print sequence numbers if lv_reporting_status = 'FINAL'
843: IF lv_reporting_status = 'FINAL' THEN
844:
845: SELECT count(*)
846: INTO l_rec_count

Line 867: -- Update the entry in JG_ZZ_VAT_FINAL_REPORTS table

863: ,jg_info_d1
864: ,jg_info_v2
865: ,jg_info_v8);
866:
867: -- Update the entry in JG_ZZ_VAT_FINAL_REPORTS table
868: UPDATE jg_zz_vat_final_reports
869: SET start_sequence_num = lv_start_seq + l_rec_count,
870: last_start_sequence_num = lv_start_seq
871: WHERE report_name = p_report_name

Line 868: UPDATE jg_zz_vat_final_reports

864: ,jg_info_v2
865: ,jg_info_v8);
866:
867: -- Update the entry in JG_ZZ_VAT_FINAL_REPORTS table
868: UPDATE jg_zz_vat_final_reports
869: SET start_sequence_num = lv_start_seq + l_rec_count,
870: last_start_sequence_num = lv_start_seq
871: WHERE report_name = p_report_name
872: AND vat_register_id = p_vat_register_id

Line 994: lv_start_seq jg_zz_vat_final_reports.start_sequence_num%type;

990:
991:
992: -- lv_tax_tag fnd_lookup_values_vl.tag%type ;
993: lv_tax_code VARCHAR2(60);
994: lv_start_seq jg_zz_vat_final_reports.start_sequence_num%type;
995: lv_reporting_status varchar2(15);
996:
997: BEGIN
998: -- lv_tax_tag := nvl(FND_PROFILE.VALUE('JEIT_EXEMPT_TAX_TAG'),'JEIT_NO_EXEMPT_TAX_TAG'); /* Bug#5235824 */

Line 1092: -- Update teh jg_zz_vat_final_reports table for print sequence numbers if lv_reporting_status = 'FINAL'

1088: IF p_debug_flag = 'Y' THEN
1089: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );
1090: END IF ;
1091:
1092: -- Update teh jg_zz_vat_final_reports table for print sequence numbers if lv_reporting_status = 'FINAL'
1093: IF lv_reporting_status = 'FINAL' THEN
1094:
1095: SELECT count(*)
1096: INTO l_rec_count

Line 1121: -- Update the entry in JG_ZZ_VAT_FINAL_REPORTS table

1117: ,jg_info_v3
1118: ,jg_info_v8
1119: ,jg_info_v20 );
1120:
1121: -- Update the entry in JG_ZZ_VAT_FINAL_REPORTS table
1122: UPDATE jg_zz_vat_final_reports
1123: SET start_sequence_num = lv_start_seq + l_rec_count,
1124: last_start_sequence_num = lv_start_seq
1125: WHERE report_name = p_report_name

Line 1122: UPDATE jg_zz_vat_final_reports

1118: ,jg_info_v8
1119: ,jg_info_v20 );
1120:
1121: -- Update the entry in JG_ZZ_VAT_FINAL_REPORTS table
1122: UPDATE jg_zz_vat_final_reports
1123: SET start_sequence_num = lv_start_seq + l_rec_count,
1124: last_start_sequence_num = lv_start_seq
1125: WHERE report_name = p_report_name
1126: AND vat_register_id = p_vat_register_id