1112: /* File.Sql.35 by Brathod */
1113: lv_account_nature VARCHAR2(100); -- := 'VAT INTERIM';
1114: lv_source_name VARCHAR2(100); -- := 'Purchasing India';
1115: lv_category_name VARCHAR2(100); -- := 'Receiving India';
1116: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.process_vat';
1117: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'rcv_transactions';
1118: lv_reference_25 gl_interface.reference25%TYPE ; -- := p_transaction_id;
1119: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'transaction_id';
1120: lv_destination VARCHAR2(10) ; -- := 'G';
1113: lv_account_nature VARCHAR2(100); -- := 'VAT INTERIM';
1114: lv_source_name VARCHAR2(100); -- := 'Purchasing India';
1115: lv_category_name VARCHAR2(100); -- := 'Receiving India';
1116: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.process_vat';
1117: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'rcv_transactions';
1118: lv_reference_25 gl_interface.reference25%TYPE ; -- := p_transaction_id;
1119: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'transaction_id';
1120: lv_destination VARCHAR2(10) ; -- := 'G';
1121: ld_accounting_date DATE ; -- := TRUNC(SYSDATE);
1114: lv_source_name VARCHAR2(100); -- := 'Purchasing India';
1115: lv_category_name VARCHAR2(100); -- := 'Receiving India';
1116: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.process_vat';
1117: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'rcv_transactions';
1118: lv_reference_25 gl_interface.reference25%TYPE ; -- := p_transaction_id;
1119: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'transaction_id';
1120: lv_destination VARCHAR2(10) ; -- := 'G';
1121: ld_accounting_date DATE ; -- := TRUNC(SYSDATE);
1122: /* End of File.Sql.35 by Brathod */
1115: lv_category_name VARCHAR2(100); -- := 'Receiving India';
1116: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.process_vat';
1117: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'rcv_transactions';
1118: lv_reference_25 gl_interface.reference25%TYPE ; -- := p_transaction_id;
1119: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'transaction_id';
1120: lv_destination VARCHAR2(10) ; -- := 'G';
1121: ld_accounting_date DATE ; -- := TRUNC(SYSDATE);
1122: /* End of File.Sql.35 by Brathod */
1123:
1124: ln_code_combination_id NUMBER;
1125: ln_entered_dr NUMBER;
1126: ln_entered_cr NUMBER;
1127: lv_currency_code VARCHAR2(10);
1128: lv_reference_10 gl_interface.reference10%TYPE;
1129: lv_code_path VARCHAR2(1996);
1130: lv_process_status VARCHAR2(2);
1131: lv_process_message VARCHAR2(1000);
1132: ln_location_id NUMBER;
1838: lv_account_nature VARCHAR2(100); -- := 'VAT CLAIM';
1839: lv_source_name VARCHAR2(100); -- := 'Purchasing India';
1840: lv_category_name VARCHAR2(100); -- := 'Receiving India';
1841: ld_accounting_date DATE ; -- := TRUNC(SYSDATE);
1842: lv_reference_10 gl_interface.reference10%TYPE;
1843: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.process_claim';
1844: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'jai_rgm_trx_records';
1845: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'repository_id';
1846: lv_destination VARCHAR2(10) ; -- := 'G';
1839: lv_source_name VARCHAR2(100); -- := 'Purchasing India';
1840: lv_category_name VARCHAR2(100); -- := 'Receiving India';
1841: ld_accounting_date DATE ; -- := TRUNC(SYSDATE);
1842: lv_reference_10 gl_interface.reference10%TYPE;
1843: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.process_claim';
1844: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'jai_rgm_trx_records';
1845: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'repository_id';
1846: lv_destination VARCHAR2(10) ; -- := 'G';
1847:
1840: lv_category_name VARCHAR2(100); -- := 'Receiving India';
1841: ld_accounting_date DATE ; -- := TRUNC(SYSDATE);
1842: lv_reference_10 gl_interface.reference10%TYPE;
1843: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.process_claim';
1844: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'jai_rgm_trx_records';
1845: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'repository_id';
1846: lv_destination VARCHAR2(10) ; -- := 'G';
1847:
1848: ln_code_combination_id NUMBER;
1841: ld_accounting_date DATE ; -- := TRUNC(SYSDATE);
1842: lv_reference_10 gl_interface.reference10%TYPE;
1843: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.process_claim';
1844: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'jai_rgm_trx_records';
1845: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'repository_id';
1846: lv_destination VARCHAR2(10) ; -- := 'G';
1847:
1848: ln_code_combination_id NUMBER;
1849: ln_entered_dr NUMBER;
1847:
1848: ln_code_combination_id NUMBER;
1849: ln_entered_dr NUMBER;
1850: ln_entered_cr NUMBER;
1851: lv_reference_25 gl_interface.reference25%TYPE;
1852: lv_code_path JAI_RCV_TRANSACTIONS.codepath%TYPE;
1853: lv_process_status VARCHAR2(2);
1854: lv_process_message VARCHAR2(1000);
1855: ln_repository_id jai_rgm_trx_records.repository_id%TYPE;
2409: lv_account_nature VARCHAR2(100) ; -- := 'VAT NO CLAIM';
2410: lv_source_name VARCHAR2(100) ; -- := 'Purchasing India';
2411: lv_category_name VARCHAR2(100) ; -- := 'Receiving India';
2412: ld_accounting_date DATE ; -- := TRUNC(SYSDATE);
2413: lv_reference_10 gl_interface.reference10%TYPE ; -- := 'VAT Unclaim of the Receiving Entries';
2414: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.process_no_claim';
2415: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'JAI_RCV_TRANSACTIONS';
2416: lv_reference_25 gl_interface.reference25%TYPE ;
2417: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'transaction_id';
2410: lv_source_name VARCHAR2(100) ; -- := 'Purchasing India';
2411: lv_category_name VARCHAR2(100) ; -- := 'Receiving India';
2412: ld_accounting_date DATE ; -- := TRUNC(SYSDATE);
2413: lv_reference_10 gl_interface.reference10%TYPE ; -- := 'VAT Unclaim of the Receiving Entries';
2414: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.process_no_claim';
2415: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'JAI_RCV_TRANSACTIONS';
2416: lv_reference_25 gl_interface.reference25%TYPE ;
2417: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'transaction_id';
2418: lv_destination VARCHAR2(10) ; -- := 'G';
2411: lv_category_name VARCHAR2(100) ; -- := 'Receiving India';
2412: ld_accounting_date DATE ; -- := TRUNC(SYSDATE);
2413: lv_reference_10 gl_interface.reference10%TYPE ; -- := 'VAT Unclaim of the Receiving Entries';
2414: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.process_no_claim';
2415: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'JAI_RCV_TRANSACTIONS';
2416: lv_reference_25 gl_interface.reference25%TYPE ;
2417: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'transaction_id';
2418: lv_destination VARCHAR2(10) ; -- := 'G';
2419: /* End of File.Sql.35 by Brathod */
2412: ld_accounting_date DATE ; -- := TRUNC(SYSDATE);
2413: lv_reference_10 gl_interface.reference10%TYPE ; -- := 'VAT Unclaim of the Receiving Entries';
2414: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.process_no_claim';
2415: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'JAI_RCV_TRANSACTIONS';
2416: lv_reference_25 gl_interface.reference25%TYPE ;
2417: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'transaction_id';
2418: lv_destination VARCHAR2(10) ; -- := 'G';
2419: /* End of File.Sql.35 by Brathod */
2420:
2413: lv_reference_10 gl_interface.reference10%TYPE ; -- := 'VAT Unclaim of the Receiving Entries';
2414: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.process_no_claim';
2415: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'JAI_RCV_TRANSACTIONS';
2416: lv_reference_25 gl_interface.reference25%TYPE ;
2417: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'transaction_id';
2418: lv_destination VARCHAR2(10) ; -- := 'G';
2419: /* End of File.Sql.35 by Brathod */
2420:
2421: ln_code_combination_id NUMBER;
2873: lv_account_nature VARCHAR2(100) ; -- := 'VAT CLAIM';
2874: lv_source_name VARCHAR2(100) ; -- := 'Purchasing India';
2875: lv_category_name VARCHAR2(100) ; -- := 'Receiving India';
2876: ld_accounting_date DATE ; -- := TRUNC(SYSDATE);
2877: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.process_vat';
2878: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'JAI_RCV_TRANSACTIONS';
2879: lv_reference_25 gl_interface.reference25%TYPE ; -- := p_transaction_id;
2880: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'transaction_id';
2881: lv_destination VARCHAR2(10) ; -- := 'G';
2874: lv_source_name VARCHAR2(100) ; -- := 'Purchasing India';
2875: lv_category_name VARCHAR2(100) ; -- := 'Receiving India';
2876: ld_accounting_date DATE ; -- := TRUNC(SYSDATE);
2877: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.process_vat';
2878: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'JAI_RCV_TRANSACTIONS';
2879: lv_reference_25 gl_interface.reference25%TYPE ; -- := p_transaction_id;
2880: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'transaction_id';
2881: lv_destination VARCHAR2(10) ; -- := 'G';
2882: /* End of File.Sql.35 by Brathod */
2875: lv_category_name VARCHAR2(100) ; -- := 'Receiving India';
2876: ld_accounting_date DATE ; -- := TRUNC(SYSDATE);
2877: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.process_vat';
2878: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'JAI_RCV_TRANSACTIONS';
2879: lv_reference_25 gl_interface.reference25%TYPE ; -- := p_transaction_id;
2880: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'transaction_id';
2881: lv_destination VARCHAR2(10) ; -- := 'G';
2882: /* End of File.Sql.35 by Brathod */
2883:
2876: ld_accounting_date DATE ; -- := TRUNC(SYSDATE);
2877: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.process_vat';
2878: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'JAI_RCV_TRANSACTIONS';
2879: lv_reference_25 gl_interface.reference25%TYPE ; -- := p_transaction_id;
2880: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'transaction_id';
2881: lv_destination VARCHAR2(10) ; -- := 'G';
2882: /* End of File.Sql.35 by Brathod */
2883:
2884: ln_rec_ccid NUMBER;
2885: ln_int_ccid NUMBER;
2886: ln_entered_dr NUMBER;
2887: ln_entered_cr NUMBER;
2888:
2889: lv_reference_10 gl_interface.reference10%TYPE;
2890: lv_code_path VARCHAR2(1996);
2891: lv_process_status VARCHAR2(2);
2892: lv_process_message VARCHAR2(1000);
2893: lv_currency_code VARCHAR2(10);
3304: lv_accounting_type VARCHAR2(100) ; -- := 'REGULAR';
3305: lv_account_nature VARCHAR2(100) ; -- := 'Receiving';
3306: lv_source_name VARCHAR2(100) ; -- := 'Purchasing India';
3307: lv_category_name VARCHAR2(100) ; -- := 'Receiving India';
3308: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.do_rma_accounting';
3309: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'rcv_transactions';
3310: lv_reference_25 gl_interface.reference25%TYPE ; -- := p_transaction_id;
3311: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'transaction_id';
3312: lv_destination VARCHAR2(10) ; -- := 'G';
3305: lv_account_nature VARCHAR2(100) ; -- := 'Receiving';
3306: lv_source_name VARCHAR2(100) ; -- := 'Purchasing India';
3307: lv_category_name VARCHAR2(100) ; -- := 'Receiving India';
3308: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.do_rma_accounting';
3309: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'rcv_transactions';
3310: lv_reference_25 gl_interface.reference25%TYPE ; -- := p_transaction_id;
3311: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'transaction_id';
3312: lv_destination VARCHAR2(10) ; -- := 'G';
3313: /* End of File.Sql.35 by Brathod */
3306: lv_source_name VARCHAR2(100) ; -- := 'Purchasing India';
3307: lv_category_name VARCHAR2(100) ; -- := 'Receiving India';
3308: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.do_rma_accounting';
3309: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'rcv_transactions';
3310: lv_reference_25 gl_interface.reference25%TYPE ; -- := p_transaction_id;
3311: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'transaction_id';
3312: lv_destination VARCHAR2(10) ; -- := 'G';
3313: /* End of File.Sql.35 by Brathod */
3314: ln_code_combination_id NUMBER;
3307: lv_category_name VARCHAR2(100) ; -- := 'Receiving India';
3308: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.do_rma_accounting';
3309: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'rcv_transactions';
3310: lv_reference_25 gl_interface.reference25%TYPE ; -- := p_transaction_id;
3311: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'transaction_id';
3312: lv_destination VARCHAR2(10) ; -- := 'G';
3313: /* End of File.Sql.35 by Brathod */
3314: ln_code_combination_id NUMBER;
3315: ln_entered_dr NUMBER;
3315: ln_entered_dr NUMBER;
3316: ln_entered_cr NUMBER;
3317: lv_currency_code VARCHAR2(10);
3318: ld_accounting_date DATE;
3319: lv_reference_10 gl_interface.reference10%TYPE;
3320: lv_code_path JAI_RCV_TRANSACTIONS.codepath%TYPE;
3321: lv_process_status VARCHAR2(2);
3322: lv_process_message VARCHAR2(1000);
3323: ln_apportion_factor NUMBER;