1183: /* File.Sql.35 by Brathod */
1184: lv_account_nature VARCHAR2(100); -- := 'VAT INTERIM';
1185: lv_source_name VARCHAR2(100); -- := 'Purchasing India';
1186: lv_category_name VARCHAR2(100); -- := 'Receiving India';
1187: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.process_vat';
1188: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'rcv_transactions';
1189: lv_reference_25 gl_interface.reference25%TYPE ; -- := p_transaction_id;
1190: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'transaction_id';
1191: lv_destination VARCHAR2(10) ; -- := 'G';
1184: lv_account_nature VARCHAR2(100); -- := 'VAT INTERIM';
1185: lv_source_name VARCHAR2(100); -- := 'Purchasing India';
1186: lv_category_name VARCHAR2(100); -- := 'Receiving India';
1187: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.process_vat';
1188: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'rcv_transactions';
1189: lv_reference_25 gl_interface.reference25%TYPE ; -- := p_transaction_id;
1190: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'transaction_id';
1191: lv_destination VARCHAR2(10) ; -- := 'G';
1192: ld_accounting_date DATE ; -- := TRUNC(SYSDATE);
1185: lv_source_name VARCHAR2(100); -- := 'Purchasing India';
1186: lv_category_name VARCHAR2(100); -- := 'Receiving India';
1187: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.process_vat';
1188: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'rcv_transactions';
1189: lv_reference_25 gl_interface.reference25%TYPE ; -- := p_transaction_id;
1190: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'transaction_id';
1191: lv_destination VARCHAR2(10) ; -- := 'G';
1192: ld_accounting_date DATE ; -- := TRUNC(SYSDATE);
1193: /* End of File.Sql.35 by Brathod */
1186: lv_category_name VARCHAR2(100); -- := 'Receiving India';
1187: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.process_vat';
1188: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'rcv_transactions';
1189: lv_reference_25 gl_interface.reference25%TYPE ; -- := p_transaction_id;
1190: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'transaction_id';
1191: lv_destination VARCHAR2(10) ; -- := 'G';
1192: ld_accounting_date DATE ; -- := TRUNC(SYSDATE);
1193: /* End of File.Sql.35 by Brathod */
1194:
1195: ln_code_combination_id NUMBER;
1196: ln_entered_dr NUMBER;
1197: ln_entered_cr NUMBER;
1198: lv_currency_code VARCHAR2(10);
1199: lv_reference_10 gl_interface.reference10%TYPE;
1200: lv_code_path VARCHAR2(1996);
1201: lv_process_status VARCHAR2(2);
1202: lv_process_message VARCHAR2(1000);
1203: ln_location_id NUMBER;
1910: lv_account_nature VARCHAR2(100); -- := 'VAT CLAIM';
1911: lv_source_name VARCHAR2(100); -- := 'Purchasing India';
1912: lv_category_name VARCHAR2(100); -- := 'Receiving India';
1913: ld_accounting_date DATE ; -- := TRUNC(SYSDATE);
1914: lv_reference_10 gl_interface.reference10%TYPE;
1915: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.process_claim';
1916: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'jai_rgm_trx_records';
1917: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'repository_id';
1918: lv_destination VARCHAR2(10) ; -- := 'G';
1911: lv_source_name VARCHAR2(100); -- := 'Purchasing India';
1912: lv_category_name VARCHAR2(100); -- := 'Receiving India';
1913: ld_accounting_date DATE ; -- := TRUNC(SYSDATE);
1914: lv_reference_10 gl_interface.reference10%TYPE;
1915: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.process_claim';
1916: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'jai_rgm_trx_records';
1917: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'repository_id';
1918: lv_destination VARCHAR2(10) ; -- := 'G';
1919:
1912: lv_category_name VARCHAR2(100); -- := 'Receiving India';
1913: ld_accounting_date DATE ; -- := TRUNC(SYSDATE);
1914: lv_reference_10 gl_interface.reference10%TYPE;
1915: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.process_claim';
1916: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'jai_rgm_trx_records';
1917: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'repository_id';
1918: lv_destination VARCHAR2(10) ; -- := 'G';
1919:
1920: ln_code_combination_id NUMBER;
1913: ld_accounting_date DATE ; -- := TRUNC(SYSDATE);
1914: lv_reference_10 gl_interface.reference10%TYPE;
1915: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.process_claim';
1916: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'jai_rgm_trx_records';
1917: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'repository_id';
1918: lv_destination VARCHAR2(10) ; -- := 'G';
1919:
1920: ln_code_combination_id NUMBER;
1921: ln_entered_dr NUMBER;
1919:
1920: ln_code_combination_id NUMBER;
1921: ln_entered_dr NUMBER;
1922: ln_entered_cr NUMBER;
1923: lv_reference_25 gl_interface.reference25%TYPE;
1924: lv_code_path JAI_RCV_TRANSACTIONS.codepath%TYPE;
1925: lv_process_status VARCHAR2(2);
1926: lv_process_message VARCHAR2(1000);
1927: ln_repository_id jai_rgm_trx_records.repository_id%TYPE;
2509: lv_account_nature VARCHAR2(100) ; -- := 'VAT NO CLAIM';
2510: lv_source_name VARCHAR2(100) ; -- := 'Purchasing India';
2511: lv_category_name VARCHAR2(100) ; -- := 'Receiving India';
2512: ld_accounting_date DATE ; -- := TRUNC(SYSDATE);
2513: lv_reference_10 gl_interface.reference10%TYPE ; -- := 'VAT Unclaim of the Receiving Entries';
2514: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.process_no_claim';
2515: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'JAI_RCV_TRANSACTIONS';
2516: lv_reference_25 gl_interface.reference25%TYPE ;
2517: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'transaction_id';
2510: lv_source_name VARCHAR2(100) ; -- := 'Purchasing India';
2511: lv_category_name VARCHAR2(100) ; -- := 'Receiving India';
2512: ld_accounting_date DATE ; -- := TRUNC(SYSDATE);
2513: lv_reference_10 gl_interface.reference10%TYPE ; -- := 'VAT Unclaim of the Receiving Entries';
2514: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.process_no_claim';
2515: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'JAI_RCV_TRANSACTIONS';
2516: lv_reference_25 gl_interface.reference25%TYPE ;
2517: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'transaction_id';
2518: lv_destination VARCHAR2(10) ; -- := 'G';
2511: lv_category_name VARCHAR2(100) ; -- := 'Receiving India';
2512: ld_accounting_date DATE ; -- := TRUNC(SYSDATE);
2513: lv_reference_10 gl_interface.reference10%TYPE ; -- := 'VAT Unclaim of the Receiving Entries';
2514: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.process_no_claim';
2515: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'JAI_RCV_TRANSACTIONS';
2516: lv_reference_25 gl_interface.reference25%TYPE ;
2517: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'transaction_id';
2518: lv_destination VARCHAR2(10) ; -- := 'G';
2519: /* End of File.Sql.35 by Brathod */
2512: ld_accounting_date DATE ; -- := TRUNC(SYSDATE);
2513: lv_reference_10 gl_interface.reference10%TYPE ; -- := 'VAT Unclaim of the Receiving Entries';
2514: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.process_no_claim';
2515: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'JAI_RCV_TRANSACTIONS';
2516: lv_reference_25 gl_interface.reference25%TYPE ;
2517: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'transaction_id';
2518: lv_destination VARCHAR2(10) ; -- := 'G';
2519: /* End of File.Sql.35 by Brathod */
2520:
2513: lv_reference_10 gl_interface.reference10%TYPE ; -- := 'VAT Unclaim of the Receiving Entries';
2514: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.process_no_claim';
2515: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'JAI_RCV_TRANSACTIONS';
2516: lv_reference_25 gl_interface.reference25%TYPE ;
2517: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'transaction_id';
2518: lv_destination VARCHAR2(10) ; -- := 'G';
2519: /* End of File.Sql.35 by Brathod */
2520:
2521: ln_code_combination_id NUMBER;
3086: lv_account_nature VARCHAR2(100) ; -- := 'VAT CLAIM';
3087: lv_source_name VARCHAR2(100) ; -- := 'Purchasing India';
3088: lv_category_name VARCHAR2(100) ; -- := 'Receiving India';
3089: ld_accounting_date DATE ; -- := TRUNC(SYSDATE);
3090: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.process_vat';
3091: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'JAI_RCV_TRANSACTIONS';
3092: lv_reference_25 gl_interface.reference25%TYPE ; -- := p_transaction_id;
3093: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'transaction_id';
3094: lv_destination VARCHAR2(10) ; -- := 'G';
3087: lv_source_name VARCHAR2(100) ; -- := 'Purchasing India';
3088: lv_category_name VARCHAR2(100) ; -- := 'Receiving India';
3089: ld_accounting_date DATE ; -- := TRUNC(SYSDATE);
3090: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.process_vat';
3091: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'JAI_RCV_TRANSACTIONS';
3092: lv_reference_25 gl_interface.reference25%TYPE ; -- := p_transaction_id;
3093: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'transaction_id';
3094: lv_destination VARCHAR2(10) ; -- := 'G';
3095: /* End of File.Sql.35 by Brathod */
3088: lv_category_name VARCHAR2(100) ; -- := 'Receiving India';
3089: ld_accounting_date DATE ; -- := TRUNC(SYSDATE);
3090: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.process_vat';
3091: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'JAI_RCV_TRANSACTIONS';
3092: lv_reference_25 gl_interface.reference25%TYPE ; -- := p_transaction_id;
3093: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'transaction_id';
3094: lv_destination VARCHAR2(10) ; -- := 'G';
3095: /* End of File.Sql.35 by Brathod */
3096:
3089: ld_accounting_date DATE ; -- := TRUNC(SYSDATE);
3090: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.process_vat';
3091: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'JAI_RCV_TRANSACTIONS';
3092: lv_reference_25 gl_interface.reference25%TYPE ; -- := p_transaction_id;
3093: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'transaction_id';
3094: lv_destination VARCHAR2(10) ; -- := 'G';
3095: /* End of File.Sql.35 by Brathod */
3096:
3097: ln_rec_ccid NUMBER;
3099: ln_lib_ccid NUMBER; --vkaranam for bug#9662961
3100: ln_entered_dr NUMBER;
3101: ln_entered_cr NUMBER;
3102:
3103: lv_reference_10 gl_interface.reference10%TYPE;
3104: lv_code_path VARCHAR2(1996);
3105: lv_process_status VARCHAR2(2);
3106: lv_process_message VARCHAR2(1000);
3107: lv_currency_code VARCHAR2(10);
3566: lv_accounting_type VARCHAR2(100) ; -- := 'REGULAR';
3567: lv_account_nature VARCHAR2(100) ; -- := 'Receiving';
3568: lv_source_name VARCHAR2(100) ; -- := 'Purchasing India';
3569: lv_category_name VARCHAR2(100) ; -- := 'Receiving India';
3570: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.do_rma_accounting';
3571: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'rcv_transactions';
3572: lv_reference_25 gl_interface.reference25%TYPE ; -- := p_transaction_id;
3573: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'transaction_id';
3574: lv_destination VARCHAR2(10) ; -- := 'G';
3567: lv_account_nature VARCHAR2(100) ; -- := 'Receiving';
3568: lv_source_name VARCHAR2(100) ; -- := 'Purchasing India';
3569: lv_category_name VARCHAR2(100) ; -- := 'Receiving India';
3570: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.do_rma_accounting';
3571: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'rcv_transactions';
3572: lv_reference_25 gl_interface.reference25%TYPE ; -- := p_transaction_id;
3573: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'transaction_id';
3574: lv_destination VARCHAR2(10) ; -- := 'G';
3575: /* End of File.Sql.35 by Brathod */
3568: lv_source_name VARCHAR2(100) ; -- := 'Purchasing India';
3569: lv_category_name VARCHAR2(100) ; -- := 'Receiving India';
3570: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.do_rma_accounting';
3571: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'rcv_transactions';
3572: lv_reference_25 gl_interface.reference25%TYPE ; -- := p_transaction_id;
3573: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'transaction_id';
3574: lv_destination VARCHAR2(10) ; -- := 'G';
3575: /* End of File.Sql.35 by Brathod */
3576: ln_code_combination_id NUMBER;
3569: lv_category_name VARCHAR2(100) ; -- := 'Receiving India';
3570: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.do_rma_accounting';
3571: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'rcv_transactions';
3572: lv_reference_25 gl_interface.reference25%TYPE ; -- := p_transaction_id;
3573: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'transaction_id';
3574: lv_destination VARCHAR2(10) ; -- := 'G';
3575: /* End of File.Sql.35 by Brathod */
3576: ln_code_combination_id NUMBER;
3577: ln_entered_dr NUMBER;
3577: ln_entered_dr NUMBER;
3578: ln_entered_cr NUMBER;
3579: lv_currency_code VARCHAR2(10);
3580: ld_accounting_date DATE;
3581: lv_reference_10 gl_interface.reference10%TYPE;
3582: lv_code_path JAI_RCV_TRANSACTIONS.codepath%TYPE;
3583: lv_process_status VARCHAR2(2);
3584: lv_process_message VARCHAR2(1000);
3585: ln_apportion_factor NUMBER;