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_TRX_GT

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

164: ,pv_source => NULL
165: ,pv_report_name => p_report_name
166: ,pv_vat_register_id => p_vat_register_id);
167:
168: -- Insert the record into jg_zz_vat_trx_gt with Sequence and reporting mode info
169: IF l_reporting_status = 'COPY' THEN
170: SELECT last_start_sequence_num
171: INTO l_start_seq
172: FROM jg_zz_vat_final_reports vfr,

Line 180: INSERT INTO jg_zz_vat_trx_gt (jg_info_n1,

176: AND vrs.reporting_status_id = vfr.reporting_status_id
177: AND vrs.tax_calendar_period = p_period;
178: END IF;
179:
180: INSERT INTO jg_zz_vat_trx_gt (jg_info_n1,
181: jg_info_v1,
182: jg_info_v30)
183: VALUES (l_start_seq,
184: l_reporting_status,

Line 288: INSERT INTO jg_zz_vat_trx_gt

284: ,x_err_msg => l_err_msg);
285: fnd_file.put_line(fnd_file.log,'After Calling JOURNAL_AP');
286: END IF;
287:
288: INSERT INTO jg_zz_vat_trx_gt
289: ( jg_info_n1
290: ,jg_info_v1
291: ,jg_info_v2
292: ,jg_info_v3

Line 480: INSERT INTO jg_zz_vat_trx_gt(

476:
477: BEGIN
478: FOR c_belgian_rec IN c_belgian_vat
479: LOOP
480: INSERT INTO jg_zz_vat_trx_gt(
481: jg_info_n1
482: ,jg_info_v1
483: ,jg_info_v2
484: ,jg_info_v11 /* jg_info_n2. Bug#5235824 */

Line 547: FROM jg_zz_vat_trx_gt

543: );
544: END LOOP;
545:
546: SELECT COUNT(*) INTO l_rec_count
547: FROM jg_zz_vat_trx_gt
548: WHERE jg_info_v30='JEBEDV08';
549:
550: IF p_debug_flag = 'Y' THEN
551: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );

Line 551: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );

547: FROM jg_zz_vat_trx_gt
548: WHERE jg_info_v30='JEBEDV08';
549:
550: IF p_debug_flag = 'Y' THEN
551: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );
552: END IF ;
553:
554: EXCEPTION
555: WHEN OTHERS THEN

Line 640: FROM jg_zz_vat_trx_gt

636: BEGIN
637:
638: SELECT jg_info_n1, jg_info_v1
639: INTO lv_start_seq, lv_reporting_status
640: FROM jg_zz_vat_trx_gt
641: WHERE jg_info_v30 = 'SEQ';
642:
643: FOR c_italian_pay_sales_rec IN c_italian_payables_sales_vat
644: LOOP

Line 645: INSERT into jg_zz_vat_trx_gt(jg_info_v1

641: WHERE jg_info_v30 = 'SEQ';
642:
643: FOR c_italian_pay_sales_rec IN c_italian_payables_sales_vat
644: LOOP
645: INSERT into jg_zz_vat_trx_gt(jg_info_v1
646: ,jg_info_v2
647: ,jg_info_v3
648: ,jg_info_v4
649: ,jg_info_v5

Line 715: FROM jg_zz_vat_trx_gt

711: END LOOP;
712:
713: SELECT COUNT(*)
714: INTO l_rec_count
715: FROM jg_zz_vat_trx_gt
716: WHERE jg_info_v30='JEITAPSR';
717:
718: IF p_debug_flag = 'Y' THEN
719: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );

Line 719: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );

715: FROM jg_zz_vat_trx_gt
716: WHERE jg_info_v30='JEITAPSR';
717:
718: IF p_debug_flag = 'Y' THEN
719: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );
720: END IF ;
721:
722: -- Update teh jg_zz_vat_final_reports table for print sequence numbers if lv_reporting_status = 'FINAL'
723: IF lv_reporting_status = 'FINAL' THEN

Line 728: FROM jg_zz_vat_trx_gt

724:
725: SELECT count(*)
726: INTO l_rec_count
727: FROM (SELECT 1
728: FROM jg_zz_vat_trx_gt
729: WHERE jg_info_v30 = 'JEITAPSR'
730: GROUP BY jg_info_v1
731: ,jg_info_d2
732: ,jg_info_v25

Line 851: FROM jg_zz_vat_trx_gt

847: lv_tax_code := nvl(FND_PROFILE.VALUE('JEIT_EXEMPT_TAX_TAG'),'JEIT_NO_EXEMPT_TAX_TAG'); /* Bug#5235824 */
848:
849: SELECT jg_info_n1, jg_info_v1
850: INTO lv_start_seq, lv_reporting_status
851: FROM jg_zz_vat_trx_gt
852: WHERE jg_info_v30 = 'SEQ';
853:
854: FOR c_italian_purchase_vat_rec IN c_italian_purchase_vat(lv_tax_code)
855: LOOP

Line 857: INSERT INTO jg_zz_vat_trx_gt (jg_info_v1

853:
854: FOR c_italian_purchase_vat_rec IN c_italian_purchase_vat(lv_tax_code)
855: LOOP
856:
857: INSERT INTO jg_zz_vat_trx_gt (jg_info_v1
858: ,jg_info_v2
859: ,jg_info_v3
860: ,jg_info_v4
861: ,jg_info_v5

Line 928: -- Count the number of records inserted into jg_zz_vat_trx_gt table

924: ,'JEITAPPV'
925: ,c_italian_purchase_vat_rec.tax_type_code);
926: END LOOP;
927:
928: -- Count the number of records inserted into jg_zz_vat_trx_gt table
929: SELECT COUNT(*)
930: INTO l_rec_count
931: FROM jg_zz_vat_trx_gt
932: WHERE jg_info_v30='JEITAPPV';

Line 931: FROM jg_zz_vat_trx_gt

927:
928: -- Count the number of records inserted into jg_zz_vat_trx_gt table
929: SELECT COUNT(*)
930: INTO l_rec_count
931: FROM jg_zz_vat_trx_gt
932: WHERE jg_info_v30='JEITAPPV';
933:
934: IF p_debug_flag = 'Y' THEN
935: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );

Line 935: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );

931: FROM jg_zz_vat_trx_gt
932: WHERE jg_info_v30='JEITAPPV';
933:
934: IF p_debug_flag = 'Y' THEN
935: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );
936: END IF ;
937:
938: -- Update teh jg_zz_vat_final_reports table for print sequence numbers if lv_reporting_status = 'FINAL'
939: IF lv_reporting_status = 'FINAL' THEN

Line 944: FROM jg_zz_vat_trx_gt

940:
941: SELECT count(*)
942: INTO l_rec_count
943: FROM (SELECT 1
944: FROM jg_zz_vat_trx_gt
945: WHERE jg_info_v30 = 'JEITAPPV'
946: GROUP BY jg_info_v1
947: ,jg_info_d2
948: ,jg_info_n2

Line 1041: INSERT INTO jg_zz_vat_trx_gt (jg_info_d1

1037:
1038: BEGIN
1039: FOR c_spanish_inter_eu_inv_rec IN c_spanish_inter_eu_invoices
1040: LOOP
1041: INSERT INTO jg_zz_vat_trx_gt (jg_info_d1
1042: ,jg_info_v1
1043: ,jg_info_d2
1044: ,jg_info_v2
1045: ,jg_info_v3

Line 1080: FROM jg_zz_vat_trx_gt

1076: END LOOP;
1077:
1078: SELECT COUNT(*)
1079: INTO l_rec_count
1080: FROM jg_zz_vat_trx_gt
1081: WHERE jg_info_v30='JEESRVAR';
1082:
1083: IF p_debug_flag = 'Y' THEN
1084: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );

Line 1084: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );

1080: FROM jg_zz_vat_trx_gt
1081: WHERE jg_info_v30='JEESRVAR';
1082:
1083: IF p_debug_flag = 'Y' THEN
1084: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );
1085: END IF ;
1086:
1087: EXCEPTION
1088: WHEN OTHERS THEN

Line 1199: INSERT INTO jg_zz_vat_trx_gt(jg_info_v1

1195: NULL;
1196: ELSIF c_spanish_input_vat_data_rec.taxable_line_type_code = 'PREPAY' and c_spanish_input_vat_data_rec.taxable_amount IS NULL then
1197: NULL;
1198: ELSE
1199: INSERT INTO jg_zz_vat_trx_gt(jg_info_v1
1200: ,jg_info_d1
1201: ,jg_info_v2
1202: ,jg_info_v3
1203: ,jg_info_v4

Line 1244: FROM jg_zz_vat_trx_gt

1240: END LOOP;
1241:
1242: SELECT COUNT(*)
1243: INTO l_rec_count
1244: FROM jg_zz_vat_trx_gt
1245: WHERE jg_info_v30='JEESRPVP';
1246:
1247: IF p_debug_flag = 'Y' THEN
1248: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );

Line 1248: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );

1244: FROM jg_zz_vat_trx_gt
1245: WHERE jg_info_v30='JEESRPVP';
1246:
1247: IF p_debug_flag = 'Y' THEN
1248: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );
1249: END IF ;
1250:
1251: EXCEPTION
1252: WHEN OTHERS THEN

Line 1339: INSERT INTO jg_zz_vat_trx_gt(

1335: BEGIN
1336: l_rec_count:=0;
1337: FOR c_journal_ap_rec IN c_journal_ap
1338: LOOP
1339: INSERT INTO jg_zz_vat_trx_gt(
1340: jg_info_n29
1341: ,jg_info_v2
1342: ,jg_info_v3
1343: ,jg_info_v24

Line 1454: FROM jg_zz_vat_trx_gt

1450: );
1451: END LOOP;
1452:
1453: SELECT COUNT(*) INTO l_rec_count
1454: FROM jg_zz_vat_trx_gt
1455: WHERE jg_info_v30='JOURNAL_AP';
1456:
1457: IF p_debug_flag = 'Y' THEN
1458: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );

Line 1458: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );

1454: FROM jg_zz_vat_trx_gt
1455: WHERE jg_info_v30='JOURNAL_AP';
1456:
1457: IF p_debug_flag = 'Y' THEN
1458: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );
1459: END IF ;
1460: EXCEPTION
1461: WHEN OTHERS THEN
1462: fnd_file.put_line(fnd_file.log,'EXCEPTION' || SQLERRM || SQLCODE);

Line 1539: FROM jg_zz_vat_trx_gt

1535: BEGIN
1536: IF p_report_name = 'JEITAPPV' or p_report_name = 'JEITAPSR' THEN
1537: SELECT jg_info_n1
1538: INTO l_start_seq
1539: FROM jg_zz_vat_trx_gt
1540: WHERE jg_info_v30 = 'SEQ';
1541:
1542: RETURN l_start_seq;
1543: ELSE