APPS.JG_ZZ_JOURNAL_AR_PKG dependencies on JG_ZZ_VAT_TRX_GT

Line 244: -- Insert the record into jg_zz_vat_trx_gt with Sequence and reporting mode info

240: ,pv_source => NULL
241: ,pv_report_name => p_report_name
242: ,pv_vat_register_id => p_vat_register_id);
243:
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,

Line 256: INSERT INTO jg_zz_vat_trx_gt (jg_info_n1,

252: AND vrs.reporting_status_id = vfr.reporting_status_id
253: AND vrs.tax_calendar_period = p_period;
254: END IF;
255:
256: INSERT INTO jg_zz_vat_trx_gt (jg_info_n1,
257: jg_info_v1,
258: jg_info_v30)
259: VALUES (l_start_seq,
260: l_reporting_status,

Line 347: INSERT INTO jg_zz_vat_trx_gt

343: ELSE
344: l_sequence_start := 0;
345: END IF;
346: END IF;
347: INSERT INTO jg_zz_vat_trx_gt
348: (
349: jg_info_n1
350: ,jg_info_v1
351: ,jg_info_v2

Line 551: INSERT INTO jg_zz_vat_trx_gt

547: OPEN c_invoice;
548: LOOP
549: FETCH c_invoice INTO l_invoice;
550: EXIT WHEN c_invoice%NOTFOUND;
551: INSERT INTO jg_zz_vat_trx_gt
552: (
553: jg_info_n1
554: , jg_info_v1
555: , jg_info_v2

Line 688: FROM jg_zz_vat_trx_gt

684: BEGIN
685:
686: SELECT jg_info_n1, jg_info_v1
687: INTO lv_start_seq, lv_reporting_status
688: FROM jg_zz_vat_trx_gt
689: WHERE jg_info_v30 = 'SEQ';
690:
691: OPEN c_get_std_invoice;
692: LOOP

Line 696: INSERT INTO jg_zz_vat_trx_gt

692: LOOP
693: FETCH c_get_std_invoice INTO l_get_std_invoice;
694:
695: EXIT WHEN c_get_std_invoice%NOTFOUND;
696: INSERT INTO jg_zz_vat_trx_gt
697: (
698: jg_info_v2
699: , jg_info_v1
700: , jg_info_d1

Line 758: FROM jg_zz_vat_trx_gt

754:
755: SELECT count(*)
756: INTO l_rec_count
757: FROM (SELECT 1
758: FROM jg_zz_vat_trx_gt
759: WHERE jg_info_v30 = 'JEITARSV'
760: GROUP BY jg_info_v2
761: , jg_info_n2
762: , jg_info_v1

Line 874: FROM jg_zz_vat_trx_gt

870: BEGIN
871:
872: SELECT jg_info_n1, jg_info_v1
873: INTO lv_start_seq, lv_reporting_status
874: FROM jg_zz_vat_trx_gt
875: WHERE jg_info_v30 = 'SEQ';
876:
877: OPEN c_get_std_invoice;
878: LOOP

Line 881: INSERT INTO jg_zz_vat_trx_gt

877: OPEN c_get_std_invoice;
878: LOOP
879: FETCH c_get_std_invoice INTO l_get_std_invoice;
880: EXIT WHEN c_get_std_invoice%NOTFOUND;
881: INSERT INTO jg_zz_vat_trx_gt
882: (
883: jg_info_v1
884: , jg_info_v2
885: , jg_info_d1

Line 946: FROM jg_zz_vat_trx_gt

942:
943: SELECT count(*)
944: INTO l_rec_count
945: FROM (SELECT 1
946: FROM jg_zz_vat_trx_gt
947: WHERE jg_info_v30 = 'JEITRDVR'
948: GROUP BY jg_info_v1
949: ,jg_info_v2
950: ,jg_info_d1

Line 1069: INSERT INTO jg_zz_vat_trx_gt

1065: LOOP
1066: FETCH c_inv_lines INTO l_inv_lines;
1067: EXIT WHEN c_inv_lines%NOTFOUND;
1068:
1069: INSERT INTO jg_zz_vat_trx_gt
1070: (
1071: jg_info_n1
1072: , jg_info_v1
1073: , jg_info_d1

Line 1115: FROM jg_zz_vat_trx_gt

1111: BEGIN
1112: IF p_report_name = 'JEITARSV' or p_report_name = 'JEITRDVR' THEN
1113: SELECT jg_info_n1
1114: INTO l_start_seq
1115: FROM jg_zz_vat_trx_gt
1116: WHERE jg_info_v30 = 'SEQ';
1117:
1118: RETURN l_start_seq;
1119: ELSE