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.JE_ES_MODELO_EXT_PKG dependencies on JG_ZZ_VAT_TRX_GT

Line 733: INSERT INTO JG_ZZ_VAT_TRX_GT

729:
730: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'inserting with tipo 3: p_cust_tax_reg_num=' ||p_cust_tax_reg_num); END IF;
731:
732: -- dbms_output.put_line ('inserting ');
733: INSERT INTO JG_ZZ_VAT_TRX_GT
734: ( jg_info_v1 -- tipo
735: , jg_info_v6 -- p_tipo to link the arrenda record to its 'tipo' pair
736: , jg_info_n2 -- importe -- sum_trx_line_amt
737: , jg_info_v11 -- nombre -- cust name (Bug 8485057 switched nif to v11)

Line 811: FROM JG_ZZ_VAT_TRX_GT

807: , jg_info_v15 C_YEAR
808: , jg_info_v16 C_PERIOD
809: , jg_info_v17 C_OPERACION_TRIANGULAR
810: , rowid row_id
811: FROM JG_ZZ_VAT_TRX_GT
812: ORDER BY rpad(jg_info_v12,40,'A')
813: , jg_info_v1,jg_info_v15, jg_info_v16 desc;*/ -- Bug 5525421
814: /** This query is used to find out the report level information of the following
815: 1. summ of correction amount

Line 834: FROM JG_ZZ_VAT_TRX_GT JZVTG

830: , SUM(jg_info_n10) C_RUNNING_TOTAL
831: , jg_info_v23 SIGN
832: , jg_info_v18 POST_CODE
833: , jg_info_v17 OPERACION_TRIANGULAR
834: FROM JG_ZZ_VAT_TRX_GT JZVTG
835: WHERE NVL(JZVTG.jg_info_v30, 'X') <>'H'
836: AND jg_info_v27 = DECODE(P_DISPLAY_PERIOD,'OA',jg_info_v27,P_DISPLAY_PERIOD) -- Modified for Bug 7486406
837: GROUP BY jg_info_v21
838: , jg_info_v22

Line 968: UPDATE JG_ZZ_VAT_TRX_GT

964: ln_cuenta_3_4 := 0;
965:
966: END LOOP;
967:
968: UPDATE JG_ZZ_VAT_TRX_GT
969: SET jg_info_N1 = ln_grp_cuenta_1
970: , jg_info_N2 = ln_grp_imp_1
971: , jg_info_N3 = ln_grp_cuenta_3_4
972: , jg_info_N4 = ln_grp_imp_2

Line 1208: Commented to use jg_zz_vat_trx_detail instead of JG_ZZ_VAT_TRX_GT

1204: BEGIN
1205:
1206: /**
1207: author: brathod
1208: Commented to use jg_zz_vat_trx_detail instead of JG_ZZ_VAT_TRX_GT
1209: SELECT SUM(ROUND(DECODE( NVL(JVGT.jg_info_n8,0)
1210: ,0 , JVGT.jg_info_n6
1211: , JVGT.jg_info_n8
1212: )

Line 1216: FROM JG_ZZ_VAT_TRX_GT JVGT

1212: )
1213: , g_cur_precision)
1214: )
1215: INTO v_arrenda_amount
1216: FROM JG_ZZ_VAT_TRX_GT JVGT
1217: , hz_cust_acct_sites_all HCAS
1218: , hz_party_sites HPS
1219: , hz_locations HL
1220: , fnd_territories FT

Line 1241: 1. Add code below to use jg_zz_vat_trx_detail instead of JG_ZZ_VAT_TRX_GT

1237: ,'347PR');*/
1238:
1239: /**
1240: author: brathod
1241: 1. Add code below to use jg_zz_vat_trx_detail instead of JG_ZZ_VAT_TRX_GT
1242: 2. Commented TCA related tables as they are not required to fetch the amount and directly joined HCSU with JVGT*
1243: */
1244:
1245: SELECT /* Bug 8485057: total transaction amount was wrong, trx_line_amt calculation changed to consider

Line 1525: UPDATE JG_ZZ_VAT_TRX_GT JZVTG

1521: PROCEDURE MOD347_MIN_AMOUNT ( p_tipo IN VARCHAR2 ) IS
1522:
1523: BEGIN
1524: fnd_file.put_line(FND_FILE.LOG,'G_MIN_VALUE1 :'||G_MIN_VALUE);
1525: UPDATE JG_ZZ_VAT_TRX_GT JZVTG
1526: SET JZVTG.jg_info_n4 = 1
1527: WHERE JZVTG.jg_info_v11 IN (
1528: SELECT JZVTG1.jg_info_v11
1529: FROM JG_ZZ_VAT_TRX_GT JZVTG1

Line 1529: FROM JG_ZZ_VAT_TRX_GT JZVTG1

1525: UPDATE JG_ZZ_VAT_TRX_GT JZVTG
1526: SET JZVTG.jg_info_n4 = 1
1527: WHERE JZVTG.jg_info_v11 IN (
1528: SELECT JZVTG1.jg_info_v11
1529: FROM JG_ZZ_VAT_TRX_GT JZVTG1
1530: WHERE JZVTG1.jg_info_v1= p_tipo
1531: AND NVL(JZVTG.jg_info_n4,0) <> 1 -- record was not 'marked'
1532: GROUP BY JZVTG1.jg_info_v11,JZVTG1.jg_info_v1
1533: HAVING SUM(NVL(NVL(JZVTG1.jg_info_n2,JZVTG1.jg_info_n1),0)) <= NVL(G_MIN_VALUE,0)) -- 347-AP,415-AP ln_sum_trx_line_amt

Line 1544: UPDATE JG_ZZ_VAT_TRX_GT JZVTG

1540: Transaction codes(Tipos) B, F are subject to minimum amount. Tipos A,G are not. */
1541: PROCEDURE MOD347_MIN_CASH_AMOUNT ( p_tipo IN VARCHAR2 ) IS
1542:
1543: BEGIN
1544: UPDATE JG_ZZ_VAT_TRX_GT JZVTG
1545: SET JZVTG.jg_info_n6 = 0, JZVTG.jg_info_n28 = 0 -- Cash amount received does not meet the minimum -- bug 14725974
1546: WHERE JZVTG.jg_info_v11 IN
1547: (SELECT JZVTG1.jg_info_v11
1548: FROM JG_ZZ_VAT_TRX_GT JZVTG1

Line 1548: FROM JG_ZZ_VAT_TRX_GT JZVTG1

1544: UPDATE JG_ZZ_VAT_TRX_GT JZVTG
1545: SET JZVTG.jg_info_n6 = 0, JZVTG.jg_info_n28 = 0 -- Cash amount received does not meet the minimum -- bug 14725974
1546: WHERE JZVTG.jg_info_v11 IN
1547: (SELECT JZVTG1.jg_info_v11
1548: FROM JG_ZZ_VAT_TRX_GT JZVTG1
1549: WHERE JZVTG1.jg_info_v1= p_tipo -- Tipo
1550: AND NVL(JZVTG1.jg_info_n4,0) <> 1
1551: GROUP BY JZVTG1.jg_info_v11,JZVTG1.jg_info_v1
1552: HAVING SUM(NVL(JZVTG1.jg_info_n6,0)) <= NVL(P_MIN_CASH_AMOUNT_VALUE,0))

Line 1562: UPDATE JG_ZZ_VAT_TRX_GT JZVTG

1558:
1559: PROCEDURE MOD340_MIN_CASH_AMOUNT ( p_transaction_code IN VARCHAR2 ) IS
1560:
1561: BEGIN
1562: UPDATE JG_ZZ_VAT_TRX_GT JZVTG
1563: SET JZVTG.jg_info_n6 = 0 -- Cash amount received does not meet the minimum
1564: WHERE JZVTG.jg_info_v4 IN
1565: (SELECT JZVTG1.jg_info_v4
1566: FROM JG_ZZ_VAT_TRX_GT JZVTG1

Line 1566: FROM JG_ZZ_VAT_TRX_GT JZVTG1

1562: UPDATE JG_ZZ_VAT_TRX_GT JZVTG
1563: SET JZVTG.jg_info_n6 = 0 -- Cash amount received does not meet the minimum
1564: WHERE JZVTG.jg_info_v4 IN
1565: (SELECT JZVTG1.jg_info_v4
1566: FROM JG_ZZ_VAT_TRX_GT JZVTG1
1567: WHERE JZVTG1.jg_info_v10= p_transaction_code
1568: AND JZVTG1.jg_info_v9 in ('E','F')
1569: GROUP BY JZVTG1.jg_info_v4,JZVTG1.jg_info_v10
1570: HAVING SUM(NVL(JZVTG1.jg_info_n6,0)) <= NVL(P_MIN_CASH_AMOUNT_VALUE,0))

Line 1932: lc_clave_operation JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;

1928: lc_jgzz_mod_query_340 VARCHAR2(32000);
1929: lc_jgzz_mod_query_340_exp VARCHAR2(32000);
1930: lc_jgzz_mod_query_340_tax VARCHAR2(1000);
1931: --
1932: lc_clave_operation JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1933: lc_tax_registration_number JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1934: lc_customer_name JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1935: lc_customer_address_id JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1936: lc_billing_trading_partner_id JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;

Line 1933: lc_tax_registration_number JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;

1929: lc_jgzz_mod_query_340_exp VARCHAR2(32000);
1930: lc_jgzz_mod_query_340_tax VARCHAR2(1000);
1931: --
1932: lc_clave_operation JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1933: lc_tax_registration_number JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1934: lc_customer_name JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1935: lc_customer_address_id JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1936: lc_billing_trading_partner_id JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1937: ln_sum_taxable_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;

Line 1934: lc_customer_name JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;

1930: lc_jgzz_mod_query_340_tax VARCHAR2(1000);
1931: --
1932: lc_clave_operation JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1933: lc_tax_registration_number JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1934: lc_customer_name JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1935: lc_customer_address_id JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1936: lc_billing_trading_partner_id JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1937: ln_sum_taxable_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
1938: ln_sum_taxable_amt_qtr1 JG_ZZ_VAT_TRX_GT.jg_info_n16%TYPE;

Line 1935: lc_customer_address_id JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;

1931: --
1932: lc_clave_operation JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1933: lc_tax_registration_number JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1934: lc_customer_name JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1935: lc_customer_address_id JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1936: lc_billing_trading_partner_id JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1937: ln_sum_taxable_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
1938: ln_sum_taxable_amt_qtr1 JG_ZZ_VAT_TRX_GT.jg_info_n16%TYPE;
1939: ln_sum_taxable_amt_qtr2 JG_ZZ_VAT_TRX_GT.jg_info_n18%TYPE;

Line 1936: lc_billing_trading_partner_id JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;

1932: lc_clave_operation JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1933: lc_tax_registration_number JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1934: lc_customer_name JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1935: lc_customer_address_id JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1936: lc_billing_trading_partner_id JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1937: ln_sum_taxable_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
1938: ln_sum_taxable_amt_qtr1 JG_ZZ_VAT_TRX_GT.jg_info_n16%TYPE;
1939: ln_sum_taxable_amt_qtr2 JG_ZZ_VAT_TRX_GT.jg_info_n18%TYPE;
1940: ln_sum_taxable_amt_qtr3 JG_ZZ_VAT_TRX_GT.jg_info_n20%TYPE;

Line 1937: ln_sum_taxable_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;

1933: lc_tax_registration_number JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1934: lc_customer_name JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1935: lc_customer_address_id JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1936: lc_billing_trading_partner_id JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1937: ln_sum_taxable_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
1938: ln_sum_taxable_amt_qtr1 JG_ZZ_VAT_TRX_GT.jg_info_n16%TYPE;
1939: ln_sum_taxable_amt_qtr2 JG_ZZ_VAT_TRX_GT.jg_info_n18%TYPE;
1940: ln_sum_taxable_amt_qtr3 JG_ZZ_VAT_TRX_GT.jg_info_n20%TYPE;
1941: ln_sum_taxable_amt_qtr4 JG_ZZ_VAT_TRX_GT.jg_info_n22%TYPE;

Line 1938: ln_sum_taxable_amt_qtr1 JG_ZZ_VAT_TRX_GT.jg_info_n16%TYPE;

1934: lc_customer_name JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1935: lc_customer_address_id JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1936: lc_billing_trading_partner_id JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1937: ln_sum_taxable_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
1938: ln_sum_taxable_amt_qtr1 JG_ZZ_VAT_TRX_GT.jg_info_n16%TYPE;
1939: ln_sum_taxable_amt_qtr2 JG_ZZ_VAT_TRX_GT.jg_info_n18%TYPE;
1940: ln_sum_taxable_amt_qtr3 JG_ZZ_VAT_TRX_GT.jg_info_n20%TYPE;
1941: ln_sum_taxable_amt_qtr4 JG_ZZ_VAT_TRX_GT.jg_info_n22%TYPE;
1942:

Line 1939: ln_sum_taxable_amt_qtr2 JG_ZZ_VAT_TRX_GT.jg_info_n18%TYPE;

1935: lc_customer_address_id JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1936: lc_billing_trading_partner_id JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1937: ln_sum_taxable_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
1938: ln_sum_taxable_amt_qtr1 JG_ZZ_VAT_TRX_GT.jg_info_n16%TYPE;
1939: ln_sum_taxable_amt_qtr2 JG_ZZ_VAT_TRX_GT.jg_info_n18%TYPE;
1940: ln_sum_taxable_amt_qtr3 JG_ZZ_VAT_TRX_GT.jg_info_n20%TYPE;
1941: ln_sum_taxable_amt_qtr4 JG_ZZ_VAT_TRX_GT.jg_info_n22%TYPE;
1942:
1943:

Line 1940: ln_sum_taxable_amt_qtr3 JG_ZZ_VAT_TRX_GT.jg_info_n20%TYPE;

1936: lc_billing_trading_partner_id JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1937: ln_sum_taxable_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
1938: ln_sum_taxable_amt_qtr1 JG_ZZ_VAT_TRX_GT.jg_info_n16%TYPE;
1939: ln_sum_taxable_amt_qtr2 JG_ZZ_VAT_TRX_GT.jg_info_n18%TYPE;
1940: ln_sum_taxable_amt_qtr3 JG_ZZ_VAT_TRX_GT.jg_info_n20%TYPE;
1941: ln_sum_taxable_amt_qtr4 JG_ZZ_VAT_TRX_GT.jg_info_n22%TYPE;
1942:
1943:
1944: ln_sum_trx_line_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;

Line 1941: ln_sum_taxable_amt_qtr4 JG_ZZ_VAT_TRX_GT.jg_info_n22%TYPE;

1937: ln_sum_taxable_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
1938: ln_sum_taxable_amt_qtr1 JG_ZZ_VAT_TRX_GT.jg_info_n16%TYPE;
1939: ln_sum_taxable_amt_qtr2 JG_ZZ_VAT_TRX_GT.jg_info_n18%TYPE;
1940: ln_sum_taxable_amt_qtr3 JG_ZZ_VAT_TRX_GT.jg_info_n20%TYPE;
1941: ln_sum_taxable_amt_qtr4 JG_ZZ_VAT_TRX_GT.jg_info_n22%TYPE;
1942:
1943:
1944: ln_sum_trx_line_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
1945: ln_sum_trx_line_amt_q1 JG_ZZ_VAT_TRX_GT.jg_info_n17%TYPE;

Line 1944: ln_sum_trx_line_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;

1940: ln_sum_taxable_amt_qtr3 JG_ZZ_VAT_TRX_GT.jg_info_n20%TYPE;
1941: ln_sum_taxable_amt_qtr4 JG_ZZ_VAT_TRX_GT.jg_info_n22%TYPE;
1942:
1943:
1944: ln_sum_trx_line_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
1945: ln_sum_trx_line_amt_q1 JG_ZZ_VAT_TRX_GT.jg_info_n17%TYPE;
1946: ln_sum_trx_line_amt_q2 JG_ZZ_VAT_TRX_GT.jg_info_n19%TYPE;
1947: ln_sum_trx_line_amt_q3 JG_ZZ_VAT_TRX_GT.jg_info_n21%TYPE;
1948: ln_sum_trx_line_amt_q4 JG_ZZ_VAT_TRX_GT.jg_info_n23%TYPE;

Line 1945: ln_sum_trx_line_amt_q1 JG_ZZ_VAT_TRX_GT.jg_info_n17%TYPE;

1941: ln_sum_taxable_amt_qtr4 JG_ZZ_VAT_TRX_GT.jg_info_n22%TYPE;
1942:
1943:
1944: ln_sum_trx_line_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
1945: ln_sum_trx_line_amt_q1 JG_ZZ_VAT_TRX_GT.jg_info_n17%TYPE;
1946: ln_sum_trx_line_amt_q2 JG_ZZ_VAT_TRX_GT.jg_info_n19%TYPE;
1947: ln_sum_trx_line_amt_q3 JG_ZZ_VAT_TRX_GT.jg_info_n21%TYPE;
1948: ln_sum_trx_line_amt_q4 JG_ZZ_VAT_TRX_GT.jg_info_n23%TYPE;
1949:

Line 1946: ln_sum_trx_line_amt_q2 JG_ZZ_VAT_TRX_GT.jg_info_n19%TYPE;

1942:
1943:
1944: ln_sum_trx_line_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
1945: ln_sum_trx_line_amt_q1 JG_ZZ_VAT_TRX_GT.jg_info_n17%TYPE;
1946: ln_sum_trx_line_amt_q2 JG_ZZ_VAT_TRX_GT.jg_info_n19%TYPE;
1947: ln_sum_trx_line_amt_q3 JG_ZZ_VAT_TRX_GT.jg_info_n21%TYPE;
1948: ln_sum_trx_line_amt_q4 JG_ZZ_VAT_TRX_GT.jg_info_n23%TYPE;
1949:
1950: ln_ncorrection_amount JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;

Line 1947: ln_sum_trx_line_amt_q3 JG_ZZ_VAT_TRX_GT.jg_info_n21%TYPE;

1943:
1944: ln_sum_trx_line_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
1945: ln_sum_trx_line_amt_q1 JG_ZZ_VAT_TRX_GT.jg_info_n17%TYPE;
1946: ln_sum_trx_line_amt_q2 JG_ZZ_VAT_TRX_GT.jg_info_n19%TYPE;
1947: ln_sum_trx_line_amt_q3 JG_ZZ_VAT_TRX_GT.jg_info_n21%TYPE;
1948: ln_sum_trx_line_amt_q4 JG_ZZ_VAT_TRX_GT.jg_info_n23%TYPE;
1949:
1950: ln_ncorrection_amount JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
1951: ln_correction_amount JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;

Line 1948: ln_sum_trx_line_amt_q4 JG_ZZ_VAT_TRX_GT.jg_info_n23%TYPE;

1944: ln_sum_trx_line_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
1945: ln_sum_trx_line_amt_q1 JG_ZZ_VAT_TRX_GT.jg_info_n17%TYPE;
1946: ln_sum_trx_line_amt_q2 JG_ZZ_VAT_TRX_GT.jg_info_n19%TYPE;
1947: ln_sum_trx_line_amt_q3 JG_ZZ_VAT_TRX_GT.jg_info_n21%TYPE;
1948: ln_sum_trx_line_amt_q4 JG_ZZ_VAT_TRX_GT.jg_info_n23%TYPE;
1949:
1950: ln_ncorrection_amount JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
1951: ln_correction_amount JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
1952: lc_correction_year JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;

Line 1950: ln_ncorrection_amount JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;

1946: ln_sum_trx_line_amt_q2 JG_ZZ_VAT_TRX_GT.jg_info_n19%TYPE;
1947: ln_sum_trx_line_amt_q3 JG_ZZ_VAT_TRX_GT.jg_info_n21%TYPE;
1948: ln_sum_trx_line_amt_q4 JG_ZZ_VAT_TRX_GT.jg_info_n23%TYPE;
1949:
1950: ln_ncorrection_amount JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
1951: ln_correction_amount JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
1952: lc_correction_year JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1953: lc_correction_period JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1954: lc_triangulation JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;

Line 1951: ln_correction_amount JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;

1947: ln_sum_trx_line_amt_q3 JG_ZZ_VAT_TRX_GT.jg_info_n21%TYPE;
1948: ln_sum_trx_line_amt_q4 JG_ZZ_VAT_TRX_GT.jg_info_n23%TYPE;
1949:
1950: ln_ncorrection_amount JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
1951: ln_correction_amount JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
1952: lc_correction_year JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1953: lc_correction_period JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1954: lc_triangulation JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1955: lc_trx_period VARCHAR2(2);

Line 1952: lc_correction_year JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;

1948: ln_sum_trx_line_amt_q4 JG_ZZ_VAT_TRX_GT.jg_info_n23%TYPE;
1949:
1950: ln_ncorrection_amount JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
1951: ln_correction_amount JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
1952: lc_correction_year JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1953: lc_correction_period JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1954: lc_triangulation JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1955: lc_trx_period VARCHAR2(2);
1956: lc_print_year NUMBER;

Line 1953: lc_correction_period JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;

1949:
1950: ln_ncorrection_amount JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
1951: ln_correction_amount JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
1952: lc_correction_year JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1953: lc_correction_period JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1954: lc_triangulation JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1955: lc_trx_period VARCHAR2(2);
1956: lc_print_year NUMBER;
1957: lc_print_period VARCHAR2(2);

Line 1954: lc_triangulation JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;

1950: ln_ncorrection_amount JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
1951: ln_correction_amount JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
1952: lc_correction_year JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1953: lc_correction_period JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1954: lc_triangulation JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1955: lc_trx_period VARCHAR2(2);
1956: lc_print_year NUMBER;
1957: lc_print_period VARCHAR2(2);
1958: lc_property_retail_flag JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;

Line 1958: lc_property_retail_flag JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;

1954: lc_triangulation JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1955: lc_trx_period VARCHAR2(2);
1956: lc_print_year NUMBER;
1957: lc_print_period VARCHAR2(2);
1958: lc_property_retail_flag JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1959: lc_address_detail JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1960: --
1961: ln_base_imponiable NUMBER;
1962: ln_running_total NUMBER;

Line 1959: lc_address_detail JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;

1955: lc_trx_period VARCHAR2(2);
1956: lc_print_year NUMBER;
1957: lc_print_period VARCHAR2(2);
1958: lc_property_retail_flag JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1959: lc_address_detail JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
1960: --
1961: ln_base_imponiable NUMBER;
1962: ln_running_total NUMBER;
1963: ln_formerly_decl_amt NUMBER;

Line 1994: lc_key_id JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;

1990: ln_transmission_prop_amt_q3 NUMBER;
1991: ln_transmission_prop_amt_q4 NUMBER;
1992: ln_cash_received_amount NUMBER;
1993: -- Added for Modelo 340
1994: lc_key_id JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
1995: lc_foreign_taxpayer_id jg_zz_vat_trx_details.billing_tp_taxpayer_id%TYPE;
1996: lc_book_type VARCHAR2(1);
1997: lc_transaction_code VARCHAR2(1);
1998: ld_invoice_date JG_ZZ_VAT_TRX_GT.jg_info_d1%TYPE;

Line 1998: ld_invoice_date JG_ZZ_VAT_TRX_GT.jg_info_d1%TYPE;

1994: lc_key_id JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
1995: lc_foreign_taxpayer_id jg_zz_vat_trx_details.billing_tp_taxpayer_id%TYPE;
1996: lc_book_type VARCHAR2(1);
1997: lc_transaction_code VARCHAR2(1);
1998: ld_invoice_date JG_ZZ_VAT_TRX_GT.jg_info_d1%TYPE;
1999: ld_trx_date JG_ZZ_VAT_TRX_GT.jg_info_d1%TYPE;
2000: lc_doc_seq JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2001: lc_intra_type VARCHAR2(1);
2002: lc_key_declared VARCHAR2(1);

Line 1999: ld_trx_date JG_ZZ_VAT_TRX_GT.jg_info_d1%TYPE;

1995: lc_foreign_taxpayer_id jg_zz_vat_trx_details.billing_tp_taxpayer_id%TYPE;
1996: lc_book_type VARCHAR2(1);
1997: lc_transaction_code VARCHAR2(1);
1998: ld_invoice_date JG_ZZ_VAT_TRX_GT.jg_info_d1%TYPE;
1999: ld_trx_date JG_ZZ_VAT_TRX_GT.jg_info_d1%TYPE;
2000: lc_doc_seq JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2001: lc_intra_type VARCHAR2(1);
2002: lc_key_declared VARCHAR2(1);
2003: lc_trx_deadline JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;

Line 2000: lc_doc_seq JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;

1996: lc_book_type VARCHAR2(1);
1997: lc_transaction_code VARCHAR2(1);
1998: ld_invoice_date JG_ZZ_VAT_TRX_GT.jg_info_d1%TYPE;
1999: ld_trx_date JG_ZZ_VAT_TRX_GT.jg_info_d1%TYPE;
2000: lc_doc_seq JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2001: lc_intra_type VARCHAR2(1);
2002: lc_key_declared VARCHAR2(1);
2003: lc_trx_deadline JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2004: lc_desc_of_goods JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;

Line 2003: lc_trx_deadline JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;

1999: ld_trx_date JG_ZZ_VAT_TRX_GT.jg_info_d1%TYPE;
2000: lc_doc_seq JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2001: lc_intra_type VARCHAR2(1);
2002: lc_key_declared VARCHAR2(1);
2003: lc_trx_deadline JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2004: lc_desc_of_goods JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
2005: ln_taxable_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2006: ln_tax_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2007: ln_inv_total_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;

Line 2004: lc_desc_of_goods JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;

2000: lc_doc_seq JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2001: lc_intra_type VARCHAR2(1);
2002: lc_key_declared VARCHAR2(1);
2003: lc_trx_deadline JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2004: lc_desc_of_goods JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
2005: ln_taxable_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2006: ln_tax_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2007: ln_inv_total_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2008: ln_deductable_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;

Line 2005: ln_taxable_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;

2001: lc_intra_type VARCHAR2(1);
2002: lc_key_declared VARCHAR2(1);
2003: lc_trx_deadline JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2004: lc_desc_of_goods JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
2005: ln_taxable_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2006: ln_tax_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2007: ln_inv_total_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2008: ln_deductable_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2009: ln_tax_rate JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;

Line 2006: ln_tax_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;

2002: lc_key_declared VARCHAR2(1);
2003: lc_trx_deadline JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2004: lc_desc_of_goods JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
2005: ln_taxable_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2006: ln_tax_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2007: ln_inv_total_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2008: ln_deductable_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2009: ln_tax_rate JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2010: ln_trx_line_number JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;

Line 2007: ln_inv_total_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;

2003: lc_trx_deadline JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2004: lc_desc_of_goods JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
2005: ln_taxable_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2006: ln_tax_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2007: ln_inv_total_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2008: ln_deductable_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2009: ln_tax_rate JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2010: ln_trx_line_number JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2011: ln_trx_line_id JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;

Line 2008: ln_deductable_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;

2004: lc_desc_of_goods JG_ZZ_VAT_TRX_GT.jg_info_v11%TYPE;
2005: ln_taxable_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2006: ln_tax_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2007: ln_inv_total_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2008: ln_deductable_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2009: ln_tax_rate JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2010: ln_trx_line_number JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2011: ln_trx_line_id JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2012: ln_trx_id JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;

Line 2009: ln_tax_rate JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;

2005: ln_taxable_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2006: ln_tax_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2007: ln_inv_total_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2008: ln_deductable_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2009: ln_tax_rate JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2010: ln_trx_line_number JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2011: ln_trx_line_id JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2012: ln_trx_id JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2013: ln_reporting_status_id JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;

Line 2010: ln_trx_line_number JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;

2006: ln_tax_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2007: ln_inv_total_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2008: ln_deductable_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2009: ln_tax_rate JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2010: ln_trx_line_number JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2011: ln_trx_line_id JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2012: ln_trx_id JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2013: ln_reporting_status_id JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2014: ln_line_count JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;

Line 2011: ln_trx_line_id JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;

2007: ln_inv_total_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2008: ln_deductable_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2009: ln_tax_rate JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2010: ln_trx_line_number JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2011: ln_trx_line_id JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2012: ln_trx_id JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2013: ln_reporting_status_id JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2014: ln_line_count JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2015: ln_surcharge_amount JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;

Line 2012: ln_trx_id JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;

2008: ln_deductable_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2009: ln_tax_rate JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2010: ln_trx_line_number JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2011: ln_trx_line_id JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2012: ln_trx_id JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2013: ln_reporting_status_id JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2014: ln_line_count JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2015: ln_surcharge_amount JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2016: ln_surcharge_rate JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;

Line 2013: ln_reporting_status_id JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;

2009: ln_tax_rate JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2010: ln_trx_line_number JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2011: ln_trx_line_id JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2012: ln_trx_id JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2013: ln_reporting_status_id JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2014: ln_line_count JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2015: ln_surcharge_amount JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2016: ln_surcharge_rate JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2017: ln_ar_tax_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;

Line 2014: ln_line_count JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;

2010: ln_trx_line_number JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2011: ln_trx_line_id JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2012: ln_trx_id JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2013: ln_reporting_status_id JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2014: ln_line_count JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2015: ln_surcharge_amount JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2016: ln_surcharge_rate JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2017: ln_ar_tax_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2018: ln_ar_tax_rate JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;

Line 2015: ln_surcharge_amount JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;

2011: ln_trx_line_id JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2012: ln_trx_id JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2013: ln_reporting_status_id JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2014: ln_line_count JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2015: ln_surcharge_amount JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2016: ln_surcharge_rate JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2017: ln_ar_tax_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2018: ln_ar_tax_rate JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2019:

Line 2016: ln_surcharge_rate JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;

2012: ln_trx_id JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2013: ln_reporting_status_id JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2014: ln_line_count JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2015: ln_surcharge_amount JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2016: ln_surcharge_rate JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2017: ln_ar_tax_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2018: ln_ar_tax_rate JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2019:
2020:

Line 2017: ln_ar_tax_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;

2013: ln_reporting_status_id JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2014: ln_line_count JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2015: ln_surcharge_amount JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2016: ln_surcharge_rate JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2017: ln_ar_tax_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2018: ln_ar_tax_rate JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2019:
2020:
2021: TYPE c_modelo_ext_type IS REF CURSOR ;

Line 2018: ln_ar_tax_rate JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;

2014: ln_line_count JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2015: ln_surcharge_amount JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2016: ln_surcharge_rate JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2017: ln_ar_tax_amt JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2018: ln_ar_tax_rate JG_ZZ_VAT_TRX_GT.jg_info_n11%TYPE;
2019:
2020:
2021: TYPE c_modelo_ext_type IS REF CURSOR ;
2022: c_modelo_ext c_modelo_ext_type;

Line 2281: INSERT INTO JG_ZZ_VAT_TRX_GT

2277: END IF;
2278: -- dbms_output.put_line ('BEFORE INSERT HEADER');
2279: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'BEFORE INSERT HEADER'); END IF;
2280:
2281: INSERT INTO JG_ZZ_VAT_TRX_GT
2282: (jg_info_v1 -- curr_code
2283: ,jg_info_v2 -- entity_name
2284: ,jg_info_v3 -- taxpayer_id
2285: ,jg_info_v4 -- company_name

Line 2376: Only reporting entity related information is populated in JG_ZZ_VAT_TRX_GT global temp table.

2372: /**
2373: author: brathod
2374: date : 23/05/2006
2375: User has requested "Generic Extract". Hence no need to apply report specific filters.
2376: Only reporting entity related information is populated in JG_ZZ_VAT_TRX_GT global temp table.
2377: Returning control from here to continue with xml data template query processing
2378: */
2379:
2380: IF (P_REPORT_NAME IS NULL) THEN

Line 3207: FROM JG_ZZ_VAT_TRX_GT M349

3203:
3204: begin
3205: SELECT NVL(jg_info_n10,0) -- running total
3206: INTO ln_formerly_decl_amt
3207: FROM JG_ZZ_VAT_TRX_GT M349
3208: WHERE RTRIM(jg_info_v11) = RTRIM(lc_tax_registration_number)
3209: AND RTRIM(jg_info_v12) = RTRIM(lc_customer_name)
3210: AND jg_info_n13 = lc_correction_year -- correction year
3211: AND jg_info_v27 = lc_correction_period -- correction period

Line 3230: /* UPDATE JG_ZZ_VAT_TRX_GT

3226: -- update running total
3227: --
3228: -- As per R11i logic this update should happend after the insert. Hence moving this to after insert.
3229:
3230: /* UPDATE JG_ZZ_VAT_TRX_GT
3231: SET jg_info_n10 = ln_formerly_decl_amt + ln_ncorrection_amount
3232: WHERE RTRIM(jg_info_v15) = RTRIM(lc_correction_year) --RTRIM(SUBSTR(lc_correction_year,3,2))
3233: AND RTRIM(jg_info_v16) = RTRIM(lc_correction_period)
3234: AND jg_info_v14 IS NOT NULL

Line 3253: INSERT INTO JG_ZZ_VAT_TRX_GT

3249: END IF;
3250:
3251: G_LINENO := '1.6.3';
3252:
3253: INSERT INTO JG_ZZ_VAT_TRX_GT
3254: ( jg_info_v1 -- lc_clave_operation lc_clave_operation
3255: , jg_info_v6 -- lc_country Bug 8485057
3256: , jg_info_v11 -- c_modelo_rec.tax_registration_number lc_tax_registration_number
3257: , jg_info_v12 -- c_modelo_rec.customer_name lc_customer_name

Line 3330: UPDATE JG_ZZ_VAT_TRX_GT

3326: IF P_MODELO = '349' THEN
3327: IF P_REPORT_NAME = 'JEESAMOR' THEN
3328: IF lc_correction_year IS NOT NULL AND lc_correction_period IS NOT NULL THEN --IS a Correction
3329:
3330: UPDATE JG_ZZ_VAT_TRX_GT
3331: SET jg_info_n10 = ln_formerly_decl_amt + ln_ncorrection_amount
3332: WHERE RTRIM(jg_info_v15) = RTRIM(lc_correction_year) --RTRIM(SUBSTR(lc_correction_year,3,2))
3333: AND RTRIM(jg_info_v16) = RTRIM(lc_correction_period)
3334: AND jg_info_v14 IS NOT NULL

Line 3990: INSERT INTO JG_ZZ_VAT_TRX_GT

3986: --fnd_file.put_line(FND_FILE.LOG,'receipt method:= '||fnd_profile.value('JEES_MOD347_RECEIPT_METHOD'));
3987: END IF;
3988:
3989: /* Bug 8485057 Transmission of property transactions are always different than property rental transactions */
3990: INSERT INTO JG_ZZ_VAT_TRX_GT
3991: ( jg_info_v1 -- lc_clave_operation
3992: , jg_info_n2 -- ln_arrenda_amount
3993: , jg_info_n17 -- ln_arrenda_amt_q1
3994: , jg_info_n19 -- ln_arrenda_amt_q2

Line 4074: INSERT INTO JG_ZZ_VAT_TRX_GT

4070: fnd_file.put_line(FND_FILE.LOG,'ln_cash_received_amount :='||ln_cash_received_amount);
4071: -- fnd_file.put_line(FND_FILE.LOG,'receipt method:= '||fnd_profile.value('JEES_MOD347_RECEIPT_METHOD'));
4072: END IF;
4073:
4074: INSERT INTO JG_ZZ_VAT_TRX_GT
4075: ( jg_info_v1 -- lc_clave_operation
4076: , jg_info_n2 -- ln_sum_trx_line_amt
4077: , jg_info_n17 -- ln_sum_trx_line_amt_q1
4078: , jg_info_n19 -- ln_sum_trx_line_amt_q2

Line 4136: -- fnd_file.put_line(FND_FILE.LOG,G_LINENO||'Inseted into JG_ZZ_VAT_TRX_GT');

4132: , lc_postal_code1
4133: ) ;
4134: G_LINENO := '2.4.8.2';
4135:
4136: -- fnd_file.put_line(FND_FILE.LOG,G_LINENO||'Inseted into JG_ZZ_VAT_TRX_GT');
4137:
4138: end if;
4139: G_LINENO := '2.4.9';
4140: ELSIF P_MODELO = '349' THEN

Line 4220: FROM JG_ZZ_VAT_TRX_GT M349

4216:
4217: begin
4218: SELECT NVL(jg_info_n10,0) -- running total
4219: INTO ln_formerly_decl_amt
4220: FROM JG_ZZ_VAT_TRX_GT M349
4221: WHERE RTRIM(jg_info_v11) = RTRIM(lc_tax_registration_number)
4222: AND RTRIM(jg_info_v12) = RTRIM(lc_customer_name)
4223: AND jg_info_n13 = lc_correction_year -- correction year -- Bug 5525421
4224: AND jg_info_v27 = lc_correction_period -- correction period -- Bug 5525421

Line 4240: /* UPDATE JG_ZZ_VAT_TRX_GT

4236: G_LINENO := '2.4.10.2.7';
4237: --
4238: -- update running total
4239: -- -- Bug 5525421 As per R11i logic this update should happend after the insert. Hence moving this to after insert.
4240: /* UPDATE JG_ZZ_VAT_TRX_GT
4241: SET jg_info_n10 = ln_formerly_decl_amt + ln_ncorrection_amount
4242: WHERE RTRIM(jg_info_v15) = RTRIM(lc_correction_year)--RTRIM(SUBSTR(lc_correction_year,3,2))
4243: AND RTRIM(jg_info_v16) = RTRIM(lc_correction_period)
4244: AND jg_info_v15 IS NOT NULL

Line 4261: INSERT INTO JG_ZZ_VAT_TRX_GT

4257: G_LINENO := '2.5';
4258:
4259: IF P_MODELO <> '347' THEN
4260: G_LINENO := '2.5.1';
4261: INSERT INTO JG_ZZ_VAT_TRX_GT
4262: ( jg_info_v1 -- lc_clave_operation
4263: , jg_info_v11 -- c_modelo_rec.tax_registration_number
4264: , jg_info_v12 -- c_modelo_rec.customer_name
4265: , jg_info_v13 -- c_modelo_rec.customer_address_id

Line 4324: UPDATE JG_ZZ_VAT_TRX_GT

4320: IF P_MODELO = '349' THEN
4321: IF P_REPORT_NAME = 'JEESAMOR' THEN
4322: IF lc_correction_year IS NOT NULL AND lc_correction_period IS NOT NULL THEN --IS a Correction
4323:
4324: UPDATE JG_ZZ_VAT_TRX_GT
4325: SET jg_info_n10 = ln_formerly_decl_amt + ln_ncorrection_amount
4326: WHERE RTRIM(jg_info_v15) = RTRIM(lc_correction_year)--RTRIM(SUBSTR(lc_correction_year,3,2))
4327: AND RTRIM(jg_info_v16) = RTRIM(lc_correction_period)
4328: AND jg_info_v15 IS NOT NULL

Line 4771: INSERT INTO JG_ZZ_VAT_TRX_GT

4767:
4768: G_LINENO := '2.5.5.4';
4769:
4770: -- Insert payables record
4771: INSERT INTO JG_ZZ_VAT_TRX_GT
4772: ( jg_info_v1
4773: , jg_info_v20 -- p_tax_year
4774: , jg_info_v2 -- lc_taxpayer_id
4775: , jg_info_v3 -- lc_company_name

Line 5256: INSERT INTO JG_ZZ_VAT_TRX_GT

5252: fnd_file.put_line(FND_FILE.LOG, 'Inv Amount: '||ln_inv_total_amt);
5253: END IF;
5254:
5255: -- Insert AR record
5256: INSERT INTO JG_ZZ_VAT_TRX_GT
5257: ( jg_info_v1
5258: , jg_info_v20 -- p_tax_year
5259: , jg_info_v2 -- lc_taxpayer_id
5260: , jg_info_v3 -- lc_company_name

Line 5348: FROM JG_ZZ_VAT_TRX_GT

5344: sum(jg_info_n4) INV_TOTAL_AMT
5345: INTO ln_taxable_amt,
5346: ln_tax_amt,
5347: ln_inv_total_amt
5348: FROM JG_ZZ_VAT_TRX_GT
5349: WHERE nvl(jg_info_v30,'X') <> 'H';
5350:
5351: UPDATE JG_ZZ_VAT_TRX_GT
5352: SET jg_info_n2 = ln_taxable_amt,

Line 5351: UPDATE JG_ZZ_VAT_TRX_GT

5347: ln_inv_total_amt
5348: FROM JG_ZZ_VAT_TRX_GT
5349: WHERE nvl(jg_info_v30,'X') <> 'H';
5350:
5351: UPDATE JG_ZZ_VAT_TRX_GT
5352: SET jg_info_n2 = ln_taxable_amt,
5353: jg_info_n3 = ln_tax_amt,
5354: jg_info_n4 = ln_inv_total_amt
5355: WHERE jg_info_v30 = 'H';

Line 5363: FROM JG_ZZ_VAT_TRX_GT

5359: IF P_MODELO = '340' THEN
5360:
5361: SELECT SUM(count_group) INTO P_REC_COUNT FROM (
5362: SELECT 1 count_group
5363: FROM JG_ZZ_VAT_TRX_GT
5364: WHERE NVL(jg_info_v30,'X') <> 'H'
5365: GROUP BY jg_info_v11, jg_info_n1, jg_info_n8);
5366:
5367:

Line 5402: FROM JG_ZZ_VAT_TRX_GT

5398: ELSE
5399:
5400: SELECT COUNT(*)
5401: INTO P_REC_COUNT
5402: FROM JG_ZZ_VAT_TRX_GT
5403: WHERE NVL(jg_info_v30,'X') <> 'H';
5404:
5405: /* Bug 8485057 apply minimum amounts to the selected transactions */
5406: IF P_MODELO = '347'

Line 5409: fnd_file.put_line(FND_FILE.LOG,'Count of detail records in JG_ZZ_VAT_TRX_GT, before applying minimum amount='||P_REC_COUNT);

5405: /* Bug 8485057 apply minimum amounts to the selected transactions */
5406: IF P_MODELO = '347'
5407: THEN
5408: IF G_DEBUG THEN
5409: fnd_file.put_line(FND_FILE.LOG,'Count of detail records in JG_ZZ_VAT_TRX_GT, before applying minimum amount='||P_REC_COUNT);
5410: END IF;
5411:
5412: -- Apply minimum amount parameter to the selected transactions
5413: -- Note: Only transactions tipo 'A' and 'B' are subject to this minimum

Line 5420: FROM JG_ZZ_VAT_TRX_GT

5416:
5417: -- Recount the number of transactions after applying the minimum amount
5418: SELECT COUNT(*)
5419: INTO P_REC_COUNT
5420: FROM JG_ZZ_VAT_TRX_GT
5421: WHERE NVL(jg_info_v30,'X') <> 'H'
5422: AND NVL(jg_info_n4,0) <> 1;
5423:
5424: -- Apply minimum cash amount received parameter to the selected transactions

Line 5433: UPDATE JG_ZZ_VAT_TRX_GT SET JG_INFO_N30= P_REC_COUNT WHERE jg_info_v30='H';

5429:
5430: END IF; -- 347
5431: END IF; -- 340
5432:
5433: UPDATE JG_ZZ_VAT_TRX_GT SET JG_INFO_N30= P_REC_COUNT WHERE jg_info_v30='H';
5434:
5435: G_LINENO := '2.7';
5436: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'Count of detail records in JG_ZZ_VAT_TRX_GT='||P_REC_COUNT); END IF;
5437: IF P_REPORT_NAME = 'JEESAMOR' THEN

Line 5436: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'Count of detail records in JG_ZZ_VAT_TRX_GT='||P_REC_COUNT); END IF;

5432:
5433: UPDATE JG_ZZ_VAT_TRX_GT SET JG_INFO_N30= P_REC_COUNT WHERE jg_info_v30='H';
5434:
5435: G_LINENO := '2.7';
5436: IF G_DEBUG THEN fnd_file.put_line(FND_FILE.LOG,'Count of detail records in JG_ZZ_VAT_TRX_GT='||P_REC_COUNT); END IF;
5437: IF P_REPORT_NAME = 'JEESAMOR' THEN
5438: G_LINENO := '2.7.1';
5439:
5440: IF P_MODELO = '347' THEN

Line 5443: UPDATE JG_ZZ_VAT_TRX_GT

5439:
5440: IF P_MODELO = '347' THEN
5441: G_LINENO := '2.7.1.1';
5442:
5443: UPDATE JG_ZZ_VAT_TRX_GT
5444: SET jg_info_n11 = ( SELECT count(*)
5445: FROM JG_ZZ_VAT_TRX_GT
5446: WHERE jg_info_v1 <> '3'
5447: AND NVL(jg_info_n4,0) <> 1

Line 5445: FROM JG_ZZ_VAT_TRX_GT

5441: G_LINENO := '2.7.1.1';
5442:
5443: UPDATE JG_ZZ_VAT_TRX_GT
5444: SET jg_info_n11 = ( SELECT count(*)
5445: FROM JG_ZZ_VAT_TRX_GT
5446: WHERE jg_info_v1 <> '3'
5447: AND NVL(jg_info_n4,0) <> 1
5448: AND nvl(jg_info_v30,'X') <> 'H' ) -- CP_TOTAL_DEC_D
5449: , jg_info_n12 = ( SELECT count(*)

Line 5450: FROM JG_ZZ_VAT_TRX_GT

5446: WHERE jg_info_v1 <> '3'
5447: AND NVL(jg_info_n4,0) <> 1
5448: AND nvl(jg_info_v30,'X') <> 'H' ) -- CP_TOTAL_DEC_D
5449: , jg_info_n12 = ( SELECT count(*)
5450: FROM JG_ZZ_VAT_TRX_GT
5451: WHERE jg_info_v1 = '3'
5452: AND NVL(jg_info_n4,0) <> 1
5453: AND nvl(jg_info_v30,'X') <> 'H' ) -- CP_TOTAL_DEC_I
5454: , jg_info_n13 = ( Select Decode(G_Currency_Code,'EUR',

Line 5457: FROM JG_ZZ_VAT_TRX_GT

5453: AND nvl(jg_info_v30,'X') <> 'H' ) -- CP_TOTAL_DEC_I
5454: , jg_info_n13 = ( Select Decode(G_Currency_Code,'EUR',
5455: (Round(Sum(Nvl(Jg_Info_N2,Jg_Info_N1)),G_Cur_Precision)*100)
5456: ,round(SUM(nvl(jg_info_n2,jg_info_n1)),G_Cur_Precision)) ----rounded by ratnadeep for bug:16169794
5457: FROM JG_ZZ_VAT_TRX_GT
5458: WHERE jg_info_v1 <> '3'
5459: AND NVL(jg_info_n4,0) <> 1) -- CP_TOTAL_AMT_DEC_D
5460: , jg_info_n14 = ( SELECT SUM(jg_info_n2)
5461: FROM JG_ZZ_VAT_TRX_GT

Line 5461: FROM JG_ZZ_VAT_TRX_GT

5457: FROM JG_ZZ_VAT_TRX_GT
5458: WHERE jg_info_v1 <> '3'
5459: AND NVL(jg_info_n4,0) <> 1) -- CP_TOTAL_AMT_DEC_D
5460: , jg_info_n14 = ( SELECT SUM(jg_info_n2)
5461: FROM JG_ZZ_VAT_TRX_GT
5462: WHERE jg_info_v1 = '3'
5463: AND NVL(jg_info_n4,0) <> 1
5464: AND NVL(jg_info_v30,'X') <> 'H' ) -- CP_TOTAL_DEC_I
5465: , jg_info_n15 = ( SELECT count(*)

Line 5466: FROM JG_ZZ_VAT_TRX_GT

5462: WHERE jg_info_v1 = '3'
5463: AND NVL(jg_info_n4,0) <> 1
5464: AND NVL(jg_info_v30,'X') <> 'H' ) -- CP_TOTAL_DEC_I
5465: , jg_info_n15 = ( SELECT count(*)
5466: FROM JG_ZZ_VAT_TRX_GT
5467: WHERE nvl(jg_info_v30,'X') <> 'H'
5468: AND NVL(jg_info_n4,0) <> 1) -- CP_NO_OF_TYPE2
5469: WHERE jg_info_v30 = 'H';
5470: G_LINENO := '2.7.1.2';

Line 5474: UPDATE JG_ZZ_VAT_TRX_GT

5470: G_LINENO := '2.7.1.2';
5471:
5472: ELSIF P_MODELO = '415' THEN /** author:brathod; Modified for condition from P_MODELO='347' */
5473: G_LINENO := '2.7.1.3';
5474: UPDATE JG_ZZ_VAT_TRX_GT
5475: SET ( jg_info_n11 -- CS_IMP_VENTAS
5476: , jg_info_n12 -- CS_NUMERO_VENTAS
5477: , jg_info_n13 -- CS_IMP_MEDIACION
5478: , jg_info_n14 -- CS_NUMERO_MEDIACION

Line 5543: FROM JG_ZZ_VAT_TRX_GT

5539: , SUM( DECODE( jg_info_v1
5540: , 'G', 1
5541: , 0 ) ) CP_NUMERO_TAP
5542:
5543: FROM JG_ZZ_VAT_TRX_GT
5544: WHERE NVL(jg_info_v30,'X') <> 'H'
5545: )
5546: WHERE jg_info_v30 = 'H';
5547: G_LINENO := '2.7.1.4';