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 193: -- Insert the record into jg_zz_vat_trx_gt with Sequence and reporting mode info

189: ,pv_source => NULL
190: ,pv_report_name => p_report_name
191: ,pv_vat_register_id => p_vat_register_id);
192:
193: -- Insert the record into jg_zz_vat_trx_gt with Sequence and reporting mode info
194: IF l_reporting_status = 'COPY' THEN
195: SELECT last_start_sequence_num
196: INTO l_start_seq
197: FROM jg_zz_vat_final_reports vfr,

Line 205: INSERT INTO jg_zz_vat_trx_gt (jg_info_n1,

201: AND vrs.reporting_status_id = vfr.reporting_status_id
202: AND vrs.tax_calendar_period = p_period;
203: END IF;
204:
205: INSERT INTO jg_zz_vat_trx_gt (jg_info_n1,
206: jg_info_v1,
207: jg_info_v30)
208: VALUES (l_start_seq,
209: l_reporting_status,

Line 330: INSERT INTO jg_zz_vat_trx_gt

326: ,x_err_msg => l_err_msg);
327: fnd_file.put_line(fnd_file.log,'After Calling JOURNAL_AP');
328: END IF;
329:
330: INSERT INTO jg_zz_vat_trx_gt
331: ( jg_info_n1
332: ,jg_info_v1
333: ,jg_info_v2
334: ,jg_info_v3

Line 541: INSERT INTO jg_zz_vat_trx_gt(

537:
538: BEGIN
539: FOR c_belgian_rec IN c_belgian_vat
540: LOOP
541: INSERT INTO jg_zz_vat_trx_gt(
542: jg_info_n1
543: ,jg_info_v1
544: ,jg_info_v2
545: ,jg_info_v11 /* jg_info_n2. Bug#5235824 */

Line 618: update jg_zz_vat_trx_gt

614: );
615: END LOOP;
616: --update table bug8601603
617: --update acctd_inv_amt of the second record for same trx_line_id having tax_recovery_rate <>= 0
618: update jg_zz_vat_trx_gt
619: set
620: jg_info_n14 = 0 --acctd_inv_amt
621: where
622: mod(jg_info_n29,2) = 0

Line 627: update jg_zz_vat_trx_gt

623: and jg_info_n28 <>100;
624:
625:
626: --update acctd_inv_amt for the record having tax_recovery_rate <>= 0
627: update jg_zz_vat_trx_gt
628: set
629: jg_info_n14 = 0 --acctd_inv_amt
630: ,jg_info_n16 = 0 --acctd_tax_rec_amt
631: ,jg_info_n17 = 0 --acctd_tax_nrec_amt

Line 637: update jg_zz_vat_trx_gt

633: jg_info_n29 <> jg_info_n30
634: ;
635:
636: --calculate acctd_vat_amt to displat total vat amount for invoice
637: update jg_zz_vat_trx_gt
638: set
639: jg_info_n13 = nvl(jg_info_n16,0) + nvl(jg_info_n17,0) --acctd_vat_amt
640: ;
641:

Line 643: update jg_zz_vat_trx_gt

639: jg_info_n13 = nvl(jg_info_n16,0) + nvl(jg_info_n17,0) --acctd_vat_amt
640: ;
641:
642: --calculate acctd_tot_amt to displat total amount for invoice
643: update jg_zz_vat_trx_gt
644: set
645: jg_info_n15 = nvl(jg_info_n13,0) + nvl(jg_info_n14,0) --acctd_tot_amt
646: ;
647:

Line 651: fnd_file.put_line(fnd_file.log,'Updating jg_zz_vat_trx_gt using lag logic' );

647:
648: --update used in case of multiple adjusted invoices
649: --update the 2nd record having the same amount for same combination used in partition logic
650: --
651: fnd_file.put_line(fnd_file.log,'Updating jg_zz_vat_trx_gt using lag logic' );
652: update jg_zz_vat_trx_gt
653: set
654: jg_info_n29 = 1
655: where

Line 652: update jg_zz_vat_trx_gt

648: --update used in case of multiple adjusted invoices
649: --update the 2nd record having the same amount for same combination used in partition logic
650: --
651: fnd_file.put_line(fnd_file.log,'Updating jg_zz_vat_trx_gt using lag logic' );
652: update jg_zz_vat_trx_gt
653: set
654: jg_info_n29 = 1
655: where
656: ((mod(jg_info_n29,2) = 0

Line 663: FROM jg_zz_vat_trx_gt

659: and jg_info_n28 <>100))
660: and jg_info_n27 = jg_info_n26 ;
661:
662: SELECT COUNT(*) INTO l_rec_count
663: FROM jg_zz_vat_trx_gt
664: WHERE jg_info_v30='JEBEDV08';
665:
666: IF p_debug_flag = 'Y' THEN
667: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );

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

663: FROM jg_zz_vat_trx_gt
664: WHERE jg_info_v30='JEBEDV08';
665:
666: IF p_debug_flag = 'Y' THEN
667: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );
668: END IF ;
669:
670: EXCEPTION
671: WHEN OTHERS THEN

Line 758: FROM jg_zz_vat_trx_gt

754: BEGIN
755:
756: SELECT jg_info_n1, jg_info_v1
757: INTO lv_start_seq, lv_reporting_status
758: FROM jg_zz_vat_trx_gt
759: WHERE jg_info_v30 = 'SEQ';
760:
761: FOR c_italian_pay_sales_rec IN c_italian_payables_sales_vat
762: LOOP

Line 763: INSERT into jg_zz_vat_trx_gt(jg_info_v1

759: WHERE jg_info_v30 = 'SEQ';
760:
761: FOR c_italian_pay_sales_rec IN c_italian_payables_sales_vat
762: LOOP
763: INSERT into jg_zz_vat_trx_gt(jg_info_v1
764: ,jg_info_v2
765: ,jg_info_v3
766: ,jg_info_v4
767: ,jg_info_v5

Line 835: FROM jg_zz_vat_trx_gt

831: END LOOP;
832:
833: SELECT COUNT(*)
834: INTO l_rec_count
835: FROM jg_zz_vat_trx_gt
836: WHERE jg_info_v30='JEITAPSR';
837:
838: IF p_debug_flag = 'Y' THEN
839: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );

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

835: FROM jg_zz_vat_trx_gt
836: WHERE jg_info_v30='JEITAPSR';
837:
838: IF p_debug_flag = 'Y' THEN
839: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );
840: END IF ;
841:
842: -- Update teh jg_zz_vat_final_reports table for print sequence numbers if lv_reporting_status = 'FINAL'
843: IF lv_reporting_status = 'FINAL' THEN

Line 848: FROM jg_zz_vat_trx_gt

844:
845: SELECT count(*)
846: INTO l_rec_count
847: FROM (SELECT 1
848: FROM jg_zz_vat_trx_gt
849: WHERE jg_info_v30 = 'JEITAPSR'
850: GROUP BY jg_info_v1
851: ,jg_info_d2
852: ,jg_info_n2

Line 1003: FROM jg_zz_vat_trx_gt

999: lv_tax_code := nvl(FND_PROFILE.VALUE('JEIT_EXEMPT_TAX_TAG'),'JEIT_NO_EXEMPT_TAX_TAG'); /* Bug#5235824 */
1000:
1001: SELECT jg_info_n1, jg_info_v1
1002: INTO lv_start_seq, lv_reporting_status
1003: FROM jg_zz_vat_trx_gt
1004: WHERE jg_info_v30 = 'SEQ';
1005:
1006: FOR c_italian_purchase_vat_rec IN c_italian_purchase_vat(lv_tax_code)
1007: LOOP

Line 1009: INSERT INTO jg_zz_vat_trx_gt (jg_info_v1

1005:
1006: FOR c_italian_purchase_vat_rec IN c_italian_purchase_vat(lv_tax_code)
1007: LOOP
1008:
1009: INSERT INTO jg_zz_vat_trx_gt (jg_info_v1
1010: ,jg_info_v2
1011: ,jg_info_v3
1012: ,jg_info_v4
1013: ,jg_info_v5

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

1078: ,'JEITAPPV'
1079: ,c_italian_purchase_vat_rec.tax_type_code);
1080: END LOOP;
1081:
1082: -- Count the number of records inserted into jg_zz_vat_trx_gt table
1083: SELECT COUNT(*)
1084: INTO l_rec_count
1085: FROM jg_zz_vat_trx_gt
1086: WHERE jg_info_v30='JEITAPPV';

Line 1085: FROM jg_zz_vat_trx_gt

1081:
1082: -- Count the number of records inserted into jg_zz_vat_trx_gt table
1083: SELECT COUNT(*)
1084: INTO l_rec_count
1085: FROM jg_zz_vat_trx_gt
1086: WHERE jg_info_v30='JEITAPPV';
1087:
1088: IF p_debug_flag = 'Y' THEN
1089: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );

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

1085: FROM jg_zz_vat_trx_gt
1086: WHERE jg_info_v30='JEITAPPV';
1087:
1088: IF p_debug_flag = 'Y' THEN
1089: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );
1090: END IF ;
1091:
1092: -- Update teh jg_zz_vat_final_reports table for print sequence numbers if lv_reporting_status = 'FINAL'
1093: IF lv_reporting_status = 'FINAL' THEN

Line 1098: FROM jg_zz_vat_trx_gt

1094:
1095: SELECT count(*)
1096: INTO l_rec_count
1097: FROM (SELECT 1
1098: FROM jg_zz_vat_trx_gt
1099: WHERE jg_info_v30 = 'JEITAPPV'
1100: GROUP BY jg_info_v1
1101: ,jg_info_d2
1102: ,jg_info_n2

Line 1216: INSERT INTO jg_zz_vat_trx_gt (jg_info_d1

1212:
1213: BEGIN
1214: FOR c_spanish_inter_eu_inv_rec IN c_spanish_inter_eu_invoices
1215: LOOP
1216: INSERT INTO jg_zz_vat_trx_gt (jg_info_d1
1217: ,jg_info_v1
1218: ,jg_info_d2
1219: ,jg_info_v2
1220: ,jg_info_v3

Line 1255: FROM jg_zz_vat_trx_gt

1251: END LOOP;
1252:
1253: SELECT COUNT(*)
1254: INTO l_rec_count
1255: FROM jg_zz_vat_trx_gt
1256: WHERE jg_info_v30='JEESRVAR';
1257:
1258: IF p_debug_flag = 'Y' THEN
1259: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );

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

1255: FROM jg_zz_vat_trx_gt
1256: WHERE jg_info_v30='JEESRVAR';
1257:
1258: IF p_debug_flag = 'Y' THEN
1259: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );
1260: END IF ;
1261:
1262: EXCEPTION
1263: WHEN OTHERS THEN

Line 1395: INSERT INTO jg_zz_vat_trx_gt(jg_info_v1

1391: NULL;
1392: ELSIF c_spanish_input_vat_data_rec.taxable_line_type_code = 'PREPAY' and c_spanish_input_vat_data_rec.taxable_amount IS NULL then
1393: NULL;
1394: ELSE
1395: INSERT INTO jg_zz_vat_trx_gt(jg_info_v1
1396: ,jg_info_d1
1397: ,jg_info_v2
1398: ,jg_info_v3
1399: ,jg_info_v4

Line 1440: FROM jg_zz_vat_trx_gt

1436: END LOOP;
1437:
1438: SELECT COUNT(*)
1439: INTO l_rec_count
1440: FROM jg_zz_vat_trx_gt
1441: WHERE jg_info_v30='JEESRPVP';
1442:
1443: IF p_debug_flag = 'Y' THEN
1444: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );

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

1440: FROM jg_zz_vat_trx_gt
1441: WHERE jg_info_v30='JEESRPVP';
1442:
1443: IF p_debug_flag = 'Y' THEN
1444: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );
1445: END IF ;
1446:
1447: EXCEPTION
1448: WHEN OTHERS THEN

Line 1535: INSERT INTO jg_zz_vat_trx_gt(

1531: BEGIN
1532: l_rec_count:=0;
1533: FOR c_journal_ap_rec IN c_journal_ap
1534: LOOP
1535: INSERT INTO jg_zz_vat_trx_gt(
1536: jg_info_n29
1537: ,jg_info_v2
1538: ,jg_info_v3
1539: ,jg_info_v24

Line 1650: FROM jg_zz_vat_trx_gt

1646: );
1647: END LOOP;
1648:
1649: SELECT COUNT(*) INTO l_rec_count
1650: FROM jg_zz_vat_trx_gt
1651: WHERE jg_info_v30='JOURNAL_AP';
1652:
1653: IF p_debug_flag = 'Y' THEN
1654: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );

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

1650: FROM jg_zz_vat_trx_gt
1651: WHERE jg_info_v30='JOURNAL_AP';
1652:
1653: IF p_debug_flag = 'Y' THEN
1654: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );
1655: END IF ;
1656: EXCEPTION
1657: WHEN OTHERS THEN
1658: fnd_file.put_line(fnd_file.log,'EXCEPTION' || SQLERRM || SQLCODE);

Line 1735: FROM jg_zz_vat_trx_gt

1731: BEGIN
1732: IF p_report_name = 'JEITAPPV' or p_report_name = 'JEITAPSR' THEN
1733: SELECT jg_info_n1
1734: INTO l_start_seq
1735: FROM jg_zz_vat_trx_gt
1736: WHERE jg_info_v30 = 'SEQ';
1737:
1738: RETURN l_start_seq;
1739: ELSE