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

Line 22: FROM jg_zz_vat_final_reports vfr,

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

Line 30: FROM jg_zz_vat_final_reports vfr,

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

Line 248: FROM jg_zz_vat_final_reports vfr,

244: -- Insert the record into jg_zz_vat_trx_gt with Sequence and reporting mode info
245: IF l_reporting_status = 'COPY' THEN
246: SELECT last_start_sequence_num
247: INTO l_start_seq
248: FROM jg_zz_vat_final_reports vfr,
249: jg_zz_vat_rep_status vrs
250: WHERE vfr.report_name = p_report_name
251: AND vfr.vat_register_id = p_vat_register_id
252: AND vrs.reporting_status_id = vfr.reporting_status_id

Line 680: lv_start_seq jg_zz_vat_final_reports.start_sequence_num%type;

676: AND JZVRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
677: AND JZVRV.vat_register_id = P_VAT_REGISTER_ID;
678:
679: l_get_std_invoice c_get_std_invoice%ROWTYPE;
680: lv_start_seq jg_zz_vat_final_reports.start_sequence_num%type;
681: lv_reporting_status varchar2(15);
682: l_rec_count number(15);
683:
684: BEGIN

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

748: END LOOP;
749:
750: CLOSE c_get_std_invoice;
751:
752: -- Update teh jg_zz_vat_final_reports table for print sequence numbers if lv_reporting_status = 'FINAL'
753: IF lv_reporting_status = 'FINAL' THEN
754:
755: SELECT count(*)
756: INTO l_rec_count

Line 775: -- Update the entry in JG_ZZ_VAT_FINAL_REPORTS table

771: , jg_info_v12
772: , jg_info_v10
773: , jg_info_d5);
774:
775: -- Update the entry in JG_ZZ_VAT_FINAL_REPORTS table
776: UPDATE jg_zz_vat_final_reports
777: SET start_sequence_num = lv_start_seq + l_rec_count,
778: last_start_sequence_num = lv_start_seq
779: WHERE report_name = p_report_name

Line 776: UPDATE jg_zz_vat_final_reports

772: , jg_info_v10
773: , jg_info_d5);
774:
775: -- Update the entry in JG_ZZ_VAT_FINAL_REPORTS table
776: UPDATE jg_zz_vat_final_reports
777: SET start_sequence_num = lv_start_seq + l_rec_count,
778: last_start_sequence_num = lv_start_seq
779: WHERE report_name = p_report_name
780: AND vat_register_id = p_vat_register_id

Line 866: lv_start_seq jg_zz_vat_final_reports.start_sequence_num%type;

862: AND nvl(JZVTD.offset_flag,'N') <> 'Y';
863:
864:
865: l_get_std_invoice c_get_std_invoice%ROWTYPE;
866: lv_start_seq jg_zz_vat_final_reports.start_sequence_num%type;
867: lv_reporting_status varchar2(15);
868: l_rec_count number;
869:
870: BEGIN

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

936: ,l_get_std_invoice.accounting_date
937: );
938: END LOOP;
939:
940: -- Update teh jg_zz_vat_final_reports table for print sequence numbers if lv_reporting_status = 'FINAL'
941: IF lv_reporting_status = 'FINAL' THEN
942:
943: SELECT count(*)
944: INTO l_rec_count

Line 957: -- Update the entry in JG_ZZ_VAT_FINAL_REPORTS table

953: ,jg_info_v5
954: ,jg_info_v6
955: ,jg_info_d2);
956:
957: -- Update the entry in JG_ZZ_VAT_FINAL_REPORTS table
958: UPDATE jg_zz_vat_final_reports
959: SET start_sequence_num = lv_start_seq + l_rec_count,
960: last_start_sequence_num = lv_start_seq
961: WHERE report_name = p_report_name

Line 958: UPDATE jg_zz_vat_final_reports

954: ,jg_info_v6
955: ,jg_info_d2);
956:
957: -- Update the entry in JG_ZZ_VAT_FINAL_REPORTS table
958: UPDATE jg_zz_vat_final_reports
959: SET start_sequence_num = lv_start_seq + l_rec_count,
960: last_start_sequence_num = lv_start_seq
961: WHERE report_name = p_report_name
962: AND vat_register_id = p_vat_register_id