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 223: FROM jg_zz_vat_final_reports vfr,

219: -- Insert the record into jg_zz_vat_trx_gt with Sequence and reporting mode info
220: IF l_reporting_status = 'COPY' THEN
221: SELECT last_start_sequence_num
222: INTO l_start_seq
223: FROM jg_zz_vat_final_reports vfr,
224: jg_zz_vat_rep_status vrs
225: WHERE vfr.report_name = p_report_name
226: AND vfr.vat_register_id = p_vat_register_id
227: AND vrs.reporting_status_id = vfr.reporting_status_id

Line 699: lv_start_seq jg_zz_vat_final_reports.start_sequence_num%type;

695: AND JZVRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
696: AND JZVRV.vat_register_id = P_VAT_REGISTER_ID;
697:
698: l_get_std_invoice c_get_std_invoice%ROWTYPE;
699: lv_start_seq jg_zz_vat_final_reports.start_sequence_num%type;
700: lv_reporting_status varchar2(15);
701: l_rec_count number(15);
702:
703: BEGIN

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

767: END LOOP;
768:
769: CLOSE c_get_std_invoice;
770:
771: -- Update teh jg_zz_vat_final_reports table for print sequence numbers if lv_reporting_status = 'FINAL'
772: IF lv_reporting_status = 'FINAL' THEN
773:
774: SELECT count(*)
775: INTO l_rec_count

Line 794: -- Update the entry in JG_ZZ_VAT_FINAL_REPORTS table

790: , jg_info_v12
791: , jg_info_v10
792: , jg_info_d5);
793:
794: -- Update the entry in JG_ZZ_VAT_FINAL_REPORTS table
795: UPDATE jg_zz_vat_final_reports
796: SET start_sequence_num = lv_start_seq + l_rec_count,
797: last_start_sequence_num = lv_start_seq
798: WHERE report_name = p_report_name

Line 795: UPDATE jg_zz_vat_final_reports

791: , jg_info_v10
792: , jg_info_d5);
793:
794: -- Update the entry in JG_ZZ_VAT_FINAL_REPORTS table
795: UPDATE jg_zz_vat_final_reports
796: SET start_sequence_num = lv_start_seq + l_rec_count,
797: last_start_sequence_num = lv_start_seq
798: WHERE report_name = p_report_name
799: AND vat_register_id = p_vat_register_id

Line 884: lv_start_seq jg_zz_vat_final_reports.start_sequence_num%type;

880: AND nvl(JZVTD.offset_flag,'N') <> 'Y';
881:
882:
883: l_get_std_invoice c_get_std_invoice%ROWTYPE;
884: lv_start_seq jg_zz_vat_final_reports.start_sequence_num%type;
885: lv_reporting_status varchar2(15);
886: l_rec_count number;
887:
888: BEGIN

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

952: , 'JEITRDVR'
953: );
954: END LOOP;
955:
956: -- Update teh jg_zz_vat_final_reports table for print sequence numbers if lv_reporting_status = 'FINAL'
957: IF lv_reporting_status = 'FINAL' THEN
958:
959: SELECT count(*)
960: INTO l_rec_count

Line 973: -- Update the entry in JG_ZZ_VAT_FINAL_REPORTS table

969: ,jg_info_v5
970: ,jg_info_v6
971: ,jg_info_d2);
972:
973: -- Update the entry in JG_ZZ_VAT_FINAL_REPORTS table
974: UPDATE jg_zz_vat_final_reports
975: SET start_sequence_num = lv_start_seq + l_rec_count,
976: last_start_sequence_num = lv_start_seq
977: WHERE report_name = p_report_name

Line 974: UPDATE jg_zz_vat_final_reports

970: ,jg_info_v6
971: ,jg_info_d2);
972:
973: -- Update the entry in JG_ZZ_VAT_FINAL_REPORTS table
974: UPDATE jg_zz_vat_final_reports
975: SET start_sequence_num = lv_start_seq + l_rec_count,
976: last_start_sequence_num = lv_start_seq
977: WHERE report_name = p_report_name
978: AND vat_register_id = p_vat_register_id