DBA Data[Home] [Help]

APPS.JAI_RCV_RGM_CLAIMS_PKG dependencies on GL_INTERFACE

Line 1187: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.process_vat';

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';

Line 1188: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'rcv_transactions';

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);

Line 1189: lv_reference_25 gl_interface.reference25%TYPE ; -- := p_transaction_id;

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 */

Line 1190: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'transaction_id';

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:

Line 1199: lv_reference_10 gl_interface.reference10%TYPE;

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;

Line 1914: lv_reference_10 gl_interface.reference10%TYPE;

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';

Line 1915: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.process_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';
1919:

Line 1916: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'jai_rgm_trx_records';

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;

Line 1917: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'repository_id';

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;

Line 1923: lv_reference_25 gl_interface.reference25%TYPE;

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;

Line 2513: lv_reference_10 gl_interface.reference10%TYPE ; -- := 'VAT Unclaim of the Receiving Entries';

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';

Line 2514: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.process_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';
2518: lv_destination VARCHAR2(10) ; -- := 'G';

Line 2515: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'JAI_RCV_TRANSACTIONS';

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 */

Line 2516: lv_reference_25 gl_interface.reference25%TYPE ;

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:

Line 2517: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'transaction_id';

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;

Line 3090: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.process_vat';

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';

Line 3091: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'JAI_RCV_TRANSACTIONS';

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 */

Line 3092: lv_reference_25 gl_interface.reference25%TYPE ; -- := p_transaction_id;

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:

Line 3093: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'transaction_id';

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;

Line 3103: lv_reference_10 gl_interface.reference10%TYPE;

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);

Line 3570: lv_reference_23 gl_interface.reference23%TYPE ; -- := 'jai_rgm_claim_pkg.do_rma_accounting';

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';

Line 3571: lv_reference_24 gl_interface.reference24%TYPE ; -- := 'rcv_transactions';

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 */

Line 3572: lv_reference_25 gl_interface.reference25%TYPE ; -- := p_transaction_id;

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;

Line 3573: lv_reference_26 gl_interface.reference26%TYPE ; -- := 'transaction_id';

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;

Line 3581: lv_reference_10 gl_interface.reference10%TYPE;

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;