APPS.JG_ZZ_JOURNAL_AR_PKG dependencies on JG_ZZ_VAT_TRX_GT

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

215: ,pv_source => NULL
216: ,pv_report_name => p_report_name
217: ,pv_vat_register_id => p_vat_register_id);
218:
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,

Line 231: INSERT INTO jg_zz_vat_trx_gt (jg_info_n1,

227: AND vrs.reporting_status_id = vfr.reporting_status_id
228: AND vrs.tax_calendar_period = p_period;
229: END IF;
230:
231: INSERT INTO jg_zz_vat_trx_gt (jg_info_n1,
232: jg_info_v1,
233: jg_info_v30)
234: VALUES (l_start_seq,
235: l_reporting_status,

Line 320: INSERT INTO jg_zz_vat_trx_gt

316: ELSE
317: l_sequence_start := 0;
318: END IF;
319: END IF;
320: INSERT INTO jg_zz_vat_trx_gt
321: (
322: jg_info_n1
323: ,jg_info_v1
324: ,jg_info_v2

Line 570: INSERT INTO jg_zz_vat_trx_gt

566: OPEN c_invoice;
567: LOOP
568: FETCH c_invoice INTO l_invoice;
569: EXIT WHEN c_invoice%NOTFOUND;
570: INSERT INTO jg_zz_vat_trx_gt
571: (
572: jg_info_n1
573: , jg_info_v1
574: , jg_info_v2

Line 707: FROM jg_zz_vat_trx_gt

703: BEGIN
704:
705: SELECT jg_info_n1, jg_info_v1
706: INTO lv_start_seq, lv_reporting_status
707: FROM jg_zz_vat_trx_gt
708: WHERE jg_info_v30 = 'SEQ';
709:
710: OPEN c_get_std_invoice;
711: LOOP

Line 715: INSERT INTO jg_zz_vat_trx_gt

711: LOOP
712: FETCH c_get_std_invoice INTO l_get_std_invoice;
713:
714: EXIT WHEN c_get_std_invoice%NOTFOUND;
715: INSERT INTO jg_zz_vat_trx_gt
716: (
717: jg_info_v2
718: , jg_info_v1
719: , jg_info_d1

Line 777: FROM jg_zz_vat_trx_gt

773:
774: SELECT count(*)
775: INTO l_rec_count
776: FROM (SELECT 1
777: FROM jg_zz_vat_trx_gt
778: WHERE jg_info_v30 = 'JEITARSV'
779: GROUP BY jg_info_v2
780: , jg_info_n2
781: , jg_info_v1

Line 892: FROM jg_zz_vat_trx_gt

888: BEGIN
889:
890: SELECT jg_info_n1, jg_info_v1
891: INTO lv_start_seq, lv_reporting_status
892: FROM jg_zz_vat_trx_gt
893: WHERE jg_info_v30 = 'SEQ';
894:
895: OPEN c_get_std_invoice;
896: LOOP

Line 899: INSERT INTO jg_zz_vat_trx_gt

895: OPEN c_get_std_invoice;
896: LOOP
897: FETCH c_get_std_invoice INTO l_get_std_invoice;
898: EXIT WHEN c_get_std_invoice%NOTFOUND;
899: INSERT INTO jg_zz_vat_trx_gt
900: (
901: jg_info_v1
902: , jg_info_v2
903: , jg_info_d1

Line 962: FROM jg_zz_vat_trx_gt

958:
959: SELECT count(*)
960: INTO l_rec_count
961: FROM (SELECT 1
962: FROM jg_zz_vat_trx_gt
963: WHERE jg_info_v30 = 'JEITRDVR'
964: GROUP BY jg_info_v1
965: ,jg_info_v2
966: ,jg_info_d1

Line 1063: INSERT INTO jg_zz_vat_trx_gt

1059: LOOP
1060: FETCH c_inv_lines INTO l_inv_lines;
1061: EXIT WHEN c_inv_lines%NOTFOUND;
1062:
1063: INSERT INTO jg_zz_vat_trx_gt
1064: (
1065: jg_info_n1
1066: , jg_info_v1
1067: , jg_info_d1

Line 1109: FROM jg_zz_vat_trx_gt

1105: BEGIN
1106: IF p_report_name = 'JEITARSV' or p_report_name = 'JEITRDVR' THEN
1107: SELECT jg_info_n1
1108: INTO l_start_seq
1109: FROM jg_zz_vat_trx_gt
1110: WHERE jg_info_v30 = 'SEQ';
1111:
1112: RETURN l_start_seq;
1113: ELSE