APPS.JG_ZZ_SUMMARY_AP_PKG dependencies on JG_ZZ_VAT_TRX_GT

Line 433: FROM JG_ZZ_VAT_TRX_GT tmp,

429: tmp.rowid,
430: jg_info_v14 tax_code,
431: jg_info_n5 trx_id,
432: jg_info_v15 reporting_code
433: FROM JG_ZZ_VAT_TRX_GT tmp,
434: gl_periods glp,
435: jg_zz_vat_rep_status JZVRS
436: WHERE jg_info_v9 = 'M'
437: AND JZVRS.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID

Line 1134: INSERT INTO JG_ZZ_VAT_TRX_GT

1130: THEN
1131: l_ledger_id := -1;
1132: END IF;
1133:
1134: INSERT INTO JG_ZZ_VAT_TRX_GT
1135: (jg_info_v1 -- curr_code
1136: ,jg_info_v2 -- entity_name
1137: ,jg_info_v3 -- taxpayer_id
1138: ,jg_info_v4 -- company_name

Line 1175: if g_debug = true then fnd_file.put_line(fnd_file.log,'Inserted Company Details in JG_ZZ_VAT_TRX_GT table'); end if;

1171: ,l_period_start_date
1172: ,l_period_end_date
1173: --,l_reporting_status); Bug 12773668
1174: ,l_reporting_status_1); --Bug 12773668
1175: if g_debug = true then fnd_file.put_line(fnd_file.log,'Inserted Company Details in JG_ZZ_VAT_TRX_GT table'); end if;
1176:
1177: IF P_CALLING_REPORT IS NOT NULL THEN --A1
1178:
1179: /* commented during UT TEST

Line 1395: INSERT INTO JG_ZZ_VAT_TRX_GT

1391: --Populated the data for Israel VAT AP Detail Report.
1392: FOR cur_israel_new_details IN israel_new_details
1393: LOOP
1394:
1395: INSERT INTO JG_ZZ_VAT_TRX_GT
1396: (jg_info_v1 , --vendor_name
1397: jg_info_v6 , --Vendor Number
1398: jg_info_v2 , --SITE_NAME
1399: jg_info_v10 , --TAX_REG_NUM

Line 1446: INSERT INTO JG_ZZ_VAT_TRX_GT

1442: --Populated the data for VAT-File Not Related 835 -Israel
1443: FOR israel_inv_lines IN israel_details
1444: LOOP
1445:
1446: INSERT INTO JG_ZZ_VAT_TRX_GT
1447: (jg_info_v1 , --vendor_name
1448: -- jg_info_n1 , --vendor_number
1449: jg_info_v6 , --Vendor Number
1450: jg_info_v2 , --SITE_NAME

Line 1517: INSERT INTO JG_ZZ_VAT_TRX_GT

1513: ,pv_offset_tax_code => c_data_rec1.OFFSET_TAX_RATE_CODE
1514: ,pd_end_date => c_data_rec1.PERIOD_END_DATE);
1515:
1516:
1517: INSERT INTO JG_ZZ_VAT_TRX_GT
1518: (jg_info_n1 -- seq_number
1519: ,jg_info_v1 -- inv_number
1520: ,jg_info_v2 -- customer_name
1521: ,jg_info_d1 -- tax_date

Line 1606: INSERT INTO JG_ZZ_VAT_TRX_GT

1602: ,pn_taxable_amount => c_data_rec.taxable_amount
1603: ,pv_offset_tax_code => c_data_rec.OFFSET_TAX_RATE_CODE
1604: ,pd_end_date => c_data_rec.PERIOD_END_DATE);
1605:
1606: INSERT INTO JG_ZZ_VAT_TRX_GT
1607: (jg_info_n1 -- seq_number
1608: ,jg_info_v1 -- inv_number
1609: ,jg_info_v2 -- customer_name
1610: ,jg_info_d1 -- tax_date

Line 1712: FROM JG_ZZ_VAT_TRX_GT T1

1708: END IF;
1709:
1710: SELECT distinct JG_INFO_V40
1711: INTO v_is_seq_updated
1712: FROM JG_ZZ_VAT_TRX_GT T1
1713: WHERE T1.jg_info_n5 = c_data.trx_id
1714: AND T1.jg_info_v7 = c_data.vat_code
1715: AND T1.jg_info_v15 = c_data.reporting_code;
1716:

Line 1721: UPDATE JG_ZZ_VAT_TRX_GT SET jg_info_n1 = v_count ,

1717: IF NVL(v_is_seq_updated,'N') <> 'Y' THEN
1718:
1719: v_count := v_count+1;
1720:
1721: UPDATE JG_ZZ_VAT_TRX_GT SET jg_info_n1 = v_count ,
1722: jg_info_v40 = 'Y'
1723: WHERE jg_info_n5 = c_data.trx_id
1724: AND jg_info_v7 = c_data.vat_code
1725: AND jg_info_v15 = c_data.reporting_code;

Line 1839: INSERT INTO JG_ZZ_VAT_TRX_GT

1835: FOR c_data_rec2 IN c_complete
1836: LOOP
1837:
1838:
1839: INSERT INTO JG_ZZ_VAT_TRX_GT
1840: (jg_info_n1 -- seq_number
1841: ,jg_info_v1 -- inv_number
1842: ,jg_info_v2 -- customer_name
1843: ,jg_info_d1 -- tax_date