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.JAI_AR_TCS_REP_PKG dependencies on JAI_RGM_TAXES

Line 22: || for the table jai_rgm_taxes

18: dual;
19:
20: /****
21: || Get the primary key
22: || for the table jai_rgm_taxes
23: *****/
24: CURSOR cur_get_tax_det_id
25: IS
26: SELECT

Line 27: jai_rgm_taxes_s.nextval

23: *****/
24: CURSOR cur_get_tax_det_id
25: IS
26: SELECT
27: jai_rgm_taxes_s.nextval
28: FROM
29: dual;
30:
31: /*

Line 2274: || INSERT INVOICE TAXES INTO JAI_RGM_TAXES TABLE ---- PART -2

2270: return;
2271: END IF; ---------A2
2272:
2273: /*########################################################################################################
2274: || INSERT INVOICE TAXES INTO JAI_RGM_TAXES TABLE ---- PART -2
2275: ########################################################################################################*/
2276:
2277: IF p_document_type = jai_constants.trx_type_inv_incomp THEN
2278: /*

Line 2433: jai_rgm_taxes

2429: IS
2430: SELECT
2431: *
2432: FROM
2433: jai_rgm_taxes
2434: WHERE
2435: trx_ref_id = cp_trx_ref_id;
2436:
2437: p_araa AR_RECEIVABLE_APPLICATIONS_ALL%ROWTYPE ;

Line 2561: || INSERT CASH RECEIPTS INTO JAI_RGM_TAXES TABLE ---- PART -2

2557: END IF; ---------A2
2558:
2559:
2560: /*########################################################################################################
2561: || INSERT CASH RECEIPTS INTO JAI_RGM_TAXES TABLE ---- PART -2
2562: ########################################################################################################*/
2563:
2564: /*
2565: || Copy the taxes from the invoice/DM transaction to the TCS tax repository

Line 3223: || COPY APPLICATION TAXES FROM SOURCE TRANSACTION TABLES INTO JAI_RGM_TAXES TABLE ---- PART -2

3219: return;
3220: END IF; ---------A2
3221:
3222: /*########################################################################################################
3223: || COPY APPLICATION TAXES FROM SOURCE TRANSACTION TABLES INTO JAI_RGM_TAXES TABLE ---- PART -2
3224: ########################################################################################################*/
3225: /*commented by csahoo for bug# 6401388
3226: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3227: pv_log_msg => ' Before call to copy_taxes_from_source '

Line 3750: p_tax_id JAI_RGM_TAXES.TAX_ID%TYPE ,

3746: END insert_repository_references;
3747:
3748: procedure insert_repository_taxes (
3749: p_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ,
3750: p_tax_id JAI_RGM_TAXES.TAX_ID%TYPE ,
3751: p_tax_type JAI_RGM_TAXES.TAX_TYPE%TYPE ,
3752: p_tax_rate JAI_RGM_TAXES.TAX_RATE%TYPE ,
3753: p_tax_amount JAI_RGM_TAXES.TAX_AMT%TYPE ,
3754: p_func_tax_amount JAI_RGM_TAXES.FUNC_TAX_AMT%TYPE ,

Line 3751: p_tax_type JAI_RGM_TAXES.TAX_TYPE%TYPE ,

3747:
3748: procedure insert_repository_taxes (
3749: p_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ,
3750: p_tax_id JAI_RGM_TAXES.TAX_ID%TYPE ,
3751: p_tax_type JAI_RGM_TAXES.TAX_TYPE%TYPE ,
3752: p_tax_rate JAI_RGM_TAXES.TAX_RATE%TYPE ,
3753: p_tax_amount JAI_RGM_TAXES.TAX_AMT%TYPE ,
3754: p_func_tax_amount JAI_RGM_TAXES.FUNC_TAX_AMT%TYPE ,
3755: p_tax_modified_by JAI_RGM_TAXES.TAX_MODIFIED_BY%TYPE DEFAULT NULL ,

Line 3752: p_tax_rate JAI_RGM_TAXES.TAX_RATE%TYPE ,

3748: procedure insert_repository_taxes (
3749: p_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ,
3750: p_tax_id JAI_RGM_TAXES.TAX_ID%TYPE ,
3751: p_tax_type JAI_RGM_TAXES.TAX_TYPE%TYPE ,
3752: p_tax_rate JAI_RGM_TAXES.TAX_RATE%TYPE ,
3753: p_tax_amount JAI_RGM_TAXES.TAX_AMT%TYPE ,
3754: p_func_tax_amount JAI_RGM_TAXES.FUNC_TAX_AMT%TYPE ,
3755: p_tax_modified_by JAI_RGM_TAXES.TAX_MODIFIED_BY%TYPE DEFAULT NULL ,
3756: p_currency_code JAI_RGM_TAXES.CURRENCY_CODE%TYPE ,

Line 3753: p_tax_amount JAI_RGM_TAXES.TAX_AMT%TYPE ,

3749: p_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ,
3750: p_tax_id JAI_RGM_TAXES.TAX_ID%TYPE ,
3751: p_tax_type JAI_RGM_TAXES.TAX_TYPE%TYPE ,
3752: p_tax_rate JAI_RGM_TAXES.TAX_RATE%TYPE ,
3753: p_tax_amount JAI_RGM_TAXES.TAX_AMT%TYPE ,
3754: p_func_tax_amount JAI_RGM_TAXES.FUNC_TAX_AMT%TYPE ,
3755: p_tax_modified_by JAI_RGM_TAXES.TAX_MODIFIED_BY%TYPE DEFAULT NULL ,
3756: p_currency_code JAI_RGM_TAXES.CURRENCY_CODE%TYPE ,
3757: p_process_flag OUT NOCOPY VARCHAR2 ,

Line 3754: p_func_tax_amount JAI_RGM_TAXES.FUNC_TAX_AMT%TYPE ,

3750: p_tax_id JAI_RGM_TAXES.TAX_ID%TYPE ,
3751: p_tax_type JAI_RGM_TAXES.TAX_TYPE%TYPE ,
3752: p_tax_rate JAI_RGM_TAXES.TAX_RATE%TYPE ,
3753: p_tax_amount JAI_RGM_TAXES.TAX_AMT%TYPE ,
3754: p_func_tax_amount JAI_RGM_TAXES.FUNC_TAX_AMT%TYPE ,
3755: p_tax_modified_by JAI_RGM_TAXES.TAX_MODIFIED_BY%TYPE DEFAULT NULL ,
3756: p_currency_code JAI_RGM_TAXES.CURRENCY_CODE%TYPE ,
3757: p_process_flag OUT NOCOPY VARCHAR2 ,
3758: p_process_message OUT NOCOPY VARCHAR2

Line 3755: p_tax_modified_by JAI_RGM_TAXES.TAX_MODIFIED_BY%TYPE DEFAULT NULL ,

3751: p_tax_type JAI_RGM_TAXES.TAX_TYPE%TYPE ,
3752: p_tax_rate JAI_RGM_TAXES.TAX_RATE%TYPE ,
3753: p_tax_amount JAI_RGM_TAXES.TAX_AMT%TYPE ,
3754: p_func_tax_amount JAI_RGM_TAXES.FUNC_TAX_AMT%TYPE ,
3755: p_tax_modified_by JAI_RGM_TAXES.TAX_MODIFIED_BY%TYPE DEFAULT NULL ,
3756: p_currency_code JAI_RGM_TAXES.CURRENCY_CODE%TYPE ,
3757: p_process_flag OUT NOCOPY VARCHAR2 ,
3758: p_process_message OUT NOCOPY VARCHAR2
3759: )

Line 3756: p_currency_code JAI_RGM_TAXES.CURRENCY_CODE%TYPE ,

3752: p_tax_rate JAI_RGM_TAXES.TAX_RATE%TYPE ,
3753: p_tax_amount JAI_RGM_TAXES.TAX_AMT%TYPE ,
3754: p_func_tax_amount JAI_RGM_TAXES.FUNC_TAX_AMT%TYPE ,
3755: p_tax_modified_by JAI_RGM_TAXES.TAX_MODIFIED_BY%TYPE DEFAULT NULL ,
3756: p_currency_code JAI_RGM_TAXES.CURRENCY_CODE%TYPE ,
3757: p_process_flag OUT NOCOPY VARCHAR2 ,
3758: p_process_message OUT NOCOPY VARCHAR2
3759: )
3760:

Line 3777: ln_tax_det_id JAI_RGM_TAXES.TAX_DET_ID%TYPE ;

3773: JAI_CMN_TAXES_ALL
3774: WHERE
3775: tax_id = p_tax_id;
3776:
3777: ln_tax_det_id JAI_RGM_TAXES.TAX_DET_ID%TYPE ;
3778: lv_process_flag VARCHAR2(2) ;
3779: lv_process_message VARCHAR2(2000) ;
3780: ln_user_id JAI_RGM_TAXES.CREATED_BY%TYPE ;
3781: ln_login_id JAI_RGM_TAXES.LAST_UPDATE_LOGIN%TYPE ;

Line 3780: ln_user_id JAI_RGM_TAXES.CREATED_BY%TYPE ;

3776:
3777: ln_tax_det_id JAI_RGM_TAXES.TAX_DET_ID%TYPE ;
3778: lv_process_flag VARCHAR2(2) ;
3779: lv_process_message VARCHAR2(2000) ;
3780: ln_user_id JAI_RGM_TAXES.CREATED_BY%TYPE ;
3781: ln_login_id JAI_RGM_TAXES.LAST_UPDATE_LOGIN%TYPE ;
3782: ln_orig_tax_rate JAI_CMN_TAXES_ALL.ORIG_TAX_PERCENTAGE%TYPE ;
3783: ln_exempted_flag JAI_RGM_TAXES.EXEMPTED_FLAG%TYPE ;
3784: ln_tax_modified_by JAI_RGM_TAXES.TAX_MODIFIED_BY%TYPE ;

Line 3781: ln_login_id JAI_RGM_TAXES.LAST_UPDATE_LOGIN%TYPE ;

3777: ln_tax_det_id JAI_RGM_TAXES.TAX_DET_ID%TYPE ;
3778: lv_process_flag VARCHAR2(2) ;
3779: lv_process_message VARCHAR2(2000) ;
3780: ln_user_id JAI_RGM_TAXES.CREATED_BY%TYPE ;
3781: ln_login_id JAI_RGM_TAXES.LAST_UPDATE_LOGIN%TYPE ;
3782: ln_orig_tax_rate JAI_CMN_TAXES_ALL.ORIG_TAX_PERCENTAGE%TYPE ;
3783: ln_exempted_flag JAI_RGM_TAXES.EXEMPTED_FLAG%TYPE ;
3784: ln_tax_modified_by JAI_RGM_TAXES.TAX_MODIFIED_BY%TYPE ;
3785: BEGIN

Line 3783: ln_exempted_flag JAI_RGM_TAXES.EXEMPTED_FLAG%TYPE ;

3779: lv_process_message VARCHAR2(2000) ;
3780: ln_user_id JAI_RGM_TAXES.CREATED_BY%TYPE ;
3781: ln_login_id JAI_RGM_TAXES.LAST_UPDATE_LOGIN%TYPE ;
3782: ln_orig_tax_rate JAI_CMN_TAXES_ALL.ORIG_TAX_PERCENTAGE%TYPE ;
3783: ln_exempted_flag JAI_RGM_TAXES.EXEMPTED_FLAG%TYPE ;
3784: ln_tax_modified_by JAI_RGM_TAXES.TAX_MODIFIED_BY%TYPE ;
3785: BEGIN
3786:
3787:

Line 3784: ln_tax_modified_by JAI_RGM_TAXES.TAX_MODIFIED_BY%TYPE ;

3780: ln_user_id JAI_RGM_TAXES.CREATED_BY%TYPE ;
3781: ln_login_id JAI_RGM_TAXES.LAST_UPDATE_LOGIN%TYPE ;
3782: ln_orig_tax_rate JAI_CMN_TAXES_ALL.ORIG_TAX_PERCENTAGE%TYPE ;
3783: ln_exempted_flag JAI_RGM_TAXES.EXEMPTED_FLAG%TYPE ;
3784: ln_tax_modified_by JAI_RGM_TAXES.TAX_MODIFIED_BY%TYPE ;
3785: BEGIN
3786:
3787:
3788:

Line 3851: || the table jai_rgm_taxes

3847: ln_login_id := fnd_global.login_id ;
3848:
3849: /*******
3850: || Get the tax_det_id - primary key for
3851: || the table jai_rgm_taxes
3852: *******/
3853: OPEN cur_get_tax_det_id ;
3854: FETCH cur_get_tax_det_id INTO ln_tax_det_id;
3855: CLOSE cur_get_tax_det_id;

Line 3863: || the table jai_rgm_taxes

3859: ################################################################################################################*/
3860:
3861: /*******
3862: || Get the orig_ta_rate of the tax_id
3863: || the table jai_rgm_taxes
3864: *******/
3865: OPEN cur_get_exemption_value;
3866: FETCH cur_get_exemption_value INTO ln_orig_tax_rate;
3867: CLOSE cur_get_exemption_value;

Line 3904: pv_log_msg => ' VALUES insert into JAI_RGM_TAXES are : - ' ||fnd_global.local_chr(10)

3900: ln_tax_modified_by := nvl(p_tax_modified_by ,jai_constants.tax_modified_by_system );
3901:
3902: /*commented by csahoo for bug# 6401388
3903: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3904: pv_log_msg => ' VALUES insert into JAI_RGM_TAXES are : - ' ||fnd_global.local_chr(10)
3905: ||', tax_det_id -> '||ln_tax_det_id ||fnd_global.local_chr(10)
3906: ||', trx_ref_id -> '||p_trx_ref_id ||fnd_global.local_chr(10)
3907: ||', tax_type -> '||p_tax_type ||fnd_global.local_chr(10)
3908: ||', tax_amt -> '||round(nvl(p_tax_amount,0)) ||fnd_global.local_chr(10)

Line 3922: INSERT into jai_rgm_taxes (

3918: ||', last_update_login -> '||ln_login_id
3919: );*/
3920:
3921:
3922: INSERT into jai_rgm_taxes (
3923: tax_det_id ,
3924: trx_ref_id ,
3925: tax_type ,
3926: tax_amt ,

Line 4092: || the TCS tax repository table jai_rgm_taxes

4088: THEN
4089: /***
4090: || Source is INVOICE/DM/CM
4091: || Loop through each tax line of the invoice to hit
4092: || the TCS tax repository table jai_rgm_taxes
4093: ***/
4094:
4095: /*commented by csahoo for bug# 6401388
4096: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,

Line 4209: CURSOR cur_get_rgm_taxes ( cp_trx_ref_id JAI_RGM_TAXES.TRX_REF_ID%TYPE )

4205: jai_rgm_refs_all
4206: WHERE
4207: transaction_id = p_parent_transaction_id;
4208:
4209: CURSOR cur_get_rgm_taxes ( cp_trx_ref_id JAI_RGM_TAXES.TRX_REF_ID%TYPE )
4210: IS
4211: SELECT
4212: *
4213: FROM

Line 4214: jai_rgm_taxes

4210: IS
4211: SELECT
4212: *
4213: FROM
4214: jai_rgm_taxes
4215: WHERE
4216: trx_ref_id = cp_trx_ref_id;
4217:
4218: rec_cur_get_refs CUR_GET_REFS%ROWTYPE ;

Line 4220: ln_tax_det_id JAI_RGM_TAXES.TAX_DET_ID%TYPE ;

4216: trx_ref_id = cp_trx_ref_id;
4217:
4218: rec_cur_get_refs CUR_GET_REFS%ROWTYPE ;
4219: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;
4220: ln_tax_det_id JAI_RGM_TAXES.TAX_DET_ID%TYPE ;
4221: ln_apportion_ratio NUMBER ;
4222: ln_user_id JAI_RGM_REFS_ALL.CREATED_BY%TYPE ;
4223: ln_login_id JAI_RGM_REFS_ALL.LAST_UPDATE_LOGIN%TYPE ;
4224: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;

Line 4408: || the table jai_rgm_taxes

4404: FOR rec_cur_get_rgm_taxes IN cur_get_rgm_taxes ( cp_trx_ref_id => rec_cur_get_refs.trx_ref_id )
4405: LOOP
4406: /*******
4407: || Get the tax_det_id - primary key for
4408: || the table jai_rgm_taxes
4409: *******/
4410: OPEN cur_get_tax_det_id ;
4411: FETCH cur_get_tax_det_id INTO ln_tax_det_id;
4412: CLOSE cur_get_tax_det_id;

Line 4432: INSERT into jai_rgm_taxes (

4428: ||', last_update_date -> '||sysdate ||fnd_global.local_chr(10)
4429: ||', last_update_login -> '||ln_user_id
4430: );*/
4431:
4432: INSERT into jai_rgm_taxes (
4433: tax_det_id ,
4434: trx_ref_id ,
4435: tax_type ,
4436: tax_amt ,

Line 4471: pv_log_msg => ' After Insert into jai_rgm_taxes '

4467:
4468:
4469: /*commented by csahoo for bug# 6401388
4470: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4471: pv_log_msg => ' After Insert into jai_rgm_taxes '
4472: );*/
4473: END LOOP; /* End of tax population */
4474: END LOOP; /*End of jai_rgm_refs_all population */
4475:

Line 5275: jai_rgm_taxes jrt

5271: SELECT
5272: sum(nvl(jrt.func_tax_amt,0)) total_tax_amount
5273: FROM
5274: jai_rgm_refs_all jrra,
5275: jai_rgm_taxes jrt
5276: WHERE
5277: jrra.trx_ref_id = jrt.trx_ref_id
5278: AND jrra.transaction_id = cp_transaction_id;
5279: