DBA Data[Home] [Help]

APPS.JAI_RCV_RGM_CLAIMS_PKG dependencies on GL_INTERFACE

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

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

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

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

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

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

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

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:

Line 1128: lv_reference_10 gl_interface.reference10%TYPE;

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;

Line 1842: lv_reference_10 gl_interface.reference10%TYPE;

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

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

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

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;

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

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;

Line 1851: lv_reference_25 gl_interface.reference25%TYPE;

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;

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

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

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

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

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

Line 2416: lv_reference_25 gl_interface.reference25%TYPE ;

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:

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

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;

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

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

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

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

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

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:

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

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;

Line 2889: lv_reference_10 gl_interface.reference10%TYPE;

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

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

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

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

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

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

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;

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

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;

Line 3319: lv_reference_10 gl_interface.reference10%TYPE;

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;