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 2789: || INSERT INVOICE TAXES INTO JAI_RGM_TAXES TABLE ---- PART -2

2785: return;
2786: END IF; ---------A2
2787:
2788: /*########################################################################################################
2789: || INSERT INVOICE TAXES INTO JAI_RGM_TAXES TABLE ---- PART -2
2790: ########################################################################################################*/
2791:
2792: IF p_document_type = jai_constants.trx_type_inv_incomp THEN
2793: /*

Line 2948: jai_rgm_taxes

2944: IS
2945: SELECT
2946: *
2947: FROM
2948: jai_rgm_taxes
2949: WHERE
2950: trx_ref_id = cp_trx_ref_id;
2951:
2952: p_araa AR_RECEIVABLE_APPLICATIONS_ALL%ROWTYPE ;

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

3072: END IF; ---------A2
3073:
3074:
3075: /*########################################################################################################
3076: || INSERT CASH RECEIPTS INTO JAI_RGM_TAXES TABLE ---- PART -2
3077: ########################################################################################################*/
3078:
3079: /*
3080: || Copy the taxes from the invoice/DM transaction to the TCS tax repository

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

3755: return;
3756: END IF; ---------A2
3757:
3758: /*########################################################################################################
3759: || COPY APPLICATION TAXES FROM SOURCE TRANSACTION TABLES INTO JAI_RGM_TAXES TABLE ---- PART -2
3760: ########################################################################################################*/
3761: /*commented by csahoo for bug# 6401388
3762: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3763: pv_log_msg => ' Before call to copy_taxes_from_source '

Line 4291: p_tax_id JAI_RGM_TAXES.TAX_ID%TYPE ,

4287: END insert_repository_references;
4288:
4289: procedure insert_repository_taxes (
4290: p_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ,
4291: p_tax_id JAI_RGM_TAXES.TAX_ID%TYPE ,
4292: p_tax_type JAI_RGM_TAXES.TAX_TYPE%TYPE ,
4293: p_tax_rate JAI_RGM_TAXES.TAX_RATE%TYPE ,
4294: p_tax_amount JAI_RGM_TAXES.TAX_AMT%TYPE ,
4295: p_func_tax_amount JAI_RGM_TAXES.FUNC_TAX_AMT%TYPE ,

Line 4292: p_tax_type JAI_RGM_TAXES.TAX_TYPE%TYPE ,

4288:
4289: procedure insert_repository_taxes (
4290: p_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ,
4291: p_tax_id JAI_RGM_TAXES.TAX_ID%TYPE ,
4292: p_tax_type JAI_RGM_TAXES.TAX_TYPE%TYPE ,
4293: p_tax_rate JAI_RGM_TAXES.TAX_RATE%TYPE ,
4294: p_tax_amount JAI_RGM_TAXES.TAX_AMT%TYPE ,
4295: p_func_tax_amount JAI_RGM_TAXES.FUNC_TAX_AMT%TYPE ,
4296: p_tax_modified_by JAI_RGM_TAXES.TAX_MODIFIED_BY%TYPE DEFAULT NULL ,

Line 4293: p_tax_rate JAI_RGM_TAXES.TAX_RATE%TYPE ,

4289: procedure insert_repository_taxes (
4290: p_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ,
4291: p_tax_id JAI_RGM_TAXES.TAX_ID%TYPE ,
4292: p_tax_type JAI_RGM_TAXES.TAX_TYPE%TYPE ,
4293: p_tax_rate JAI_RGM_TAXES.TAX_RATE%TYPE ,
4294: p_tax_amount JAI_RGM_TAXES.TAX_AMT%TYPE ,
4295: p_func_tax_amount JAI_RGM_TAXES.FUNC_TAX_AMT%TYPE ,
4296: p_tax_modified_by JAI_RGM_TAXES.TAX_MODIFIED_BY%TYPE DEFAULT NULL ,
4297: p_currency_code JAI_RGM_TAXES.CURRENCY_CODE%TYPE ,

Line 4294: p_tax_amount JAI_RGM_TAXES.TAX_AMT%TYPE ,

4290: p_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ,
4291: p_tax_id JAI_RGM_TAXES.TAX_ID%TYPE ,
4292: p_tax_type JAI_RGM_TAXES.TAX_TYPE%TYPE ,
4293: p_tax_rate JAI_RGM_TAXES.TAX_RATE%TYPE ,
4294: p_tax_amount JAI_RGM_TAXES.TAX_AMT%TYPE ,
4295: p_func_tax_amount JAI_RGM_TAXES.FUNC_TAX_AMT%TYPE ,
4296: p_tax_modified_by JAI_RGM_TAXES.TAX_MODIFIED_BY%TYPE DEFAULT NULL ,
4297: p_currency_code JAI_RGM_TAXES.CURRENCY_CODE%TYPE ,
4298: p_process_flag OUT NOCOPY VARCHAR2 ,

Line 4295: p_func_tax_amount JAI_RGM_TAXES.FUNC_TAX_AMT%TYPE ,

4291: p_tax_id JAI_RGM_TAXES.TAX_ID%TYPE ,
4292: p_tax_type JAI_RGM_TAXES.TAX_TYPE%TYPE ,
4293: p_tax_rate JAI_RGM_TAXES.TAX_RATE%TYPE ,
4294: p_tax_amount JAI_RGM_TAXES.TAX_AMT%TYPE ,
4295: p_func_tax_amount JAI_RGM_TAXES.FUNC_TAX_AMT%TYPE ,
4296: p_tax_modified_by JAI_RGM_TAXES.TAX_MODIFIED_BY%TYPE DEFAULT NULL ,
4297: p_currency_code JAI_RGM_TAXES.CURRENCY_CODE%TYPE ,
4298: p_process_flag OUT NOCOPY VARCHAR2 ,
4299: p_process_message OUT NOCOPY VARCHAR2

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

4292: p_tax_type JAI_RGM_TAXES.TAX_TYPE%TYPE ,
4293: p_tax_rate JAI_RGM_TAXES.TAX_RATE%TYPE ,
4294: p_tax_amount JAI_RGM_TAXES.TAX_AMT%TYPE ,
4295: p_func_tax_amount JAI_RGM_TAXES.FUNC_TAX_AMT%TYPE ,
4296: p_tax_modified_by JAI_RGM_TAXES.TAX_MODIFIED_BY%TYPE DEFAULT NULL ,
4297: p_currency_code JAI_RGM_TAXES.CURRENCY_CODE%TYPE ,
4298: p_process_flag OUT NOCOPY VARCHAR2 ,
4299: p_process_message OUT NOCOPY VARCHAR2
4300: )

Line 4297: p_currency_code JAI_RGM_TAXES.CURRENCY_CODE%TYPE ,

4293: p_tax_rate JAI_RGM_TAXES.TAX_RATE%TYPE ,
4294: p_tax_amount JAI_RGM_TAXES.TAX_AMT%TYPE ,
4295: p_func_tax_amount JAI_RGM_TAXES.FUNC_TAX_AMT%TYPE ,
4296: p_tax_modified_by JAI_RGM_TAXES.TAX_MODIFIED_BY%TYPE DEFAULT NULL ,
4297: p_currency_code JAI_RGM_TAXES.CURRENCY_CODE%TYPE ,
4298: p_process_flag OUT NOCOPY VARCHAR2 ,
4299: p_process_message OUT NOCOPY VARCHAR2
4300: )
4301:

Line 4318: ln_tax_det_id JAI_RGM_TAXES.TAX_DET_ID%TYPE ;

4314: JAI_CMN_TAXES_ALL
4315: WHERE
4316: tax_id = p_tax_id;
4317:
4318: ln_tax_det_id JAI_RGM_TAXES.TAX_DET_ID%TYPE ;
4319: lv_process_flag VARCHAR2(2) ;
4320: lv_process_message VARCHAR2(2000) ;
4321: ln_user_id JAI_RGM_TAXES.CREATED_BY%TYPE ;
4322: ln_login_id JAI_RGM_TAXES.LAST_UPDATE_LOGIN%TYPE ;

Line 4321: ln_user_id JAI_RGM_TAXES.CREATED_BY%TYPE ;

4317:
4318: ln_tax_det_id JAI_RGM_TAXES.TAX_DET_ID%TYPE ;
4319: lv_process_flag VARCHAR2(2) ;
4320: lv_process_message VARCHAR2(2000) ;
4321: ln_user_id JAI_RGM_TAXES.CREATED_BY%TYPE ;
4322: ln_login_id JAI_RGM_TAXES.LAST_UPDATE_LOGIN%TYPE ;
4323: ln_orig_tax_rate JAI_CMN_TAXES_ALL.ORIG_TAX_PERCENTAGE%TYPE ;
4324: ln_exempted_flag JAI_RGM_TAXES.EXEMPTED_FLAG%TYPE ;
4325: ln_tax_modified_by JAI_RGM_TAXES.TAX_MODIFIED_BY%TYPE ;

Line 4322: ln_login_id JAI_RGM_TAXES.LAST_UPDATE_LOGIN%TYPE ;

4318: ln_tax_det_id JAI_RGM_TAXES.TAX_DET_ID%TYPE ;
4319: lv_process_flag VARCHAR2(2) ;
4320: lv_process_message VARCHAR2(2000) ;
4321: ln_user_id JAI_RGM_TAXES.CREATED_BY%TYPE ;
4322: ln_login_id JAI_RGM_TAXES.LAST_UPDATE_LOGIN%TYPE ;
4323: ln_orig_tax_rate JAI_CMN_TAXES_ALL.ORIG_TAX_PERCENTAGE%TYPE ;
4324: ln_exempted_flag JAI_RGM_TAXES.EXEMPTED_FLAG%TYPE ;
4325: ln_tax_modified_by JAI_RGM_TAXES.TAX_MODIFIED_BY%TYPE ;
4326: BEGIN

Line 4324: ln_exempted_flag JAI_RGM_TAXES.EXEMPTED_FLAG%TYPE ;

4320: lv_process_message VARCHAR2(2000) ;
4321: ln_user_id JAI_RGM_TAXES.CREATED_BY%TYPE ;
4322: ln_login_id JAI_RGM_TAXES.LAST_UPDATE_LOGIN%TYPE ;
4323: ln_orig_tax_rate JAI_CMN_TAXES_ALL.ORIG_TAX_PERCENTAGE%TYPE ;
4324: ln_exempted_flag JAI_RGM_TAXES.EXEMPTED_FLAG%TYPE ;
4325: ln_tax_modified_by JAI_RGM_TAXES.TAX_MODIFIED_BY%TYPE ;
4326: BEGIN
4327:
4328:

Line 4325: ln_tax_modified_by JAI_RGM_TAXES.TAX_MODIFIED_BY%TYPE ;

4321: ln_user_id JAI_RGM_TAXES.CREATED_BY%TYPE ;
4322: ln_login_id JAI_RGM_TAXES.LAST_UPDATE_LOGIN%TYPE ;
4323: ln_orig_tax_rate JAI_CMN_TAXES_ALL.ORIG_TAX_PERCENTAGE%TYPE ;
4324: ln_exempted_flag JAI_RGM_TAXES.EXEMPTED_FLAG%TYPE ;
4325: ln_tax_modified_by JAI_RGM_TAXES.TAX_MODIFIED_BY%TYPE ;
4326: BEGIN
4327:
4328:
4329:

Line 4422: || the table jai_rgm_taxes

4418: ln_login_id := fnd_global.login_id ;
4419:
4420: /*******
4421: || Get the tax_det_id - primary key for
4422: || the table jai_rgm_taxes
4423: *******/
4424: OPEN cur_get_tax_det_id ;
4425: FETCH cur_get_tax_det_id INTO ln_tax_det_id;
4426: CLOSE cur_get_tax_det_id;

Line 4434: || the table jai_rgm_taxes

4430: ################################################################################################################*/
4431:
4432: /*******
4433: || Get the orig_ta_rate of the tax_id
4434: || the table jai_rgm_taxes
4435: *******/
4436: OPEN cur_get_exemption_value;
4437: FETCH cur_get_exemption_value INTO ln_orig_tax_rate;
4438: CLOSE cur_get_exemption_value;

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

4471: ln_tax_modified_by := nvl(p_tax_modified_by ,jai_constants.tax_modified_by_system );
4472:
4473: /*commented by csahoo for bug# 6401388
4474: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4475: pv_log_msg => ' VALUES insert into JAI_RGM_TAXES are : - ' ||fnd_global.local_chr(10)
4476: ||', tax_det_id -> '||ln_tax_det_id ||fnd_global.local_chr(10)
4477: ||', trx_ref_id -> '||p_trx_ref_id ||fnd_global.local_chr(10)
4478: ||', tax_type -> '||p_tax_type ||fnd_global.local_chr(10)
4479: ||', tax_amt -> '||round(nvl(p_tax_amount,0)) ||fnd_global.local_chr(10)

Line 4493: INSERT into jai_rgm_taxes (

4489: ||', last_update_login -> '||ln_login_id
4490: );*/
4491:
4492:
4493: INSERT into jai_rgm_taxes (
4494: tax_det_id ,
4495: trx_ref_id ,
4496: tax_type ,
4497: tax_amt ,

Line 4663: || the TCS tax repository table jai_rgm_taxes

4659: THEN
4660: /***
4661: || Source is INVOICE/DM/CM
4662: || Loop through each tax line of the invoice to hit
4663: || the TCS tax repository table jai_rgm_taxes
4664: ***/
4665:
4666: /*commented by csahoo for bug# 6401388
4667: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,

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

4776: jai_rgm_refs_all
4777: WHERE
4778: transaction_id = p_parent_transaction_id;
4779:
4780: CURSOR cur_get_rgm_taxes ( cp_trx_ref_id JAI_RGM_TAXES.TRX_REF_ID%TYPE )
4781: IS
4782: SELECT
4783: *
4784: FROM

Line 4785: jai_rgm_taxes

4781: IS
4782: SELECT
4783: *
4784: FROM
4785: jai_rgm_taxes
4786: WHERE
4787: trx_ref_id = cp_trx_ref_id;
4788:
4789: rec_cur_get_refs CUR_GET_REFS%ROWTYPE ;

Line 4791: ln_tax_det_id JAI_RGM_TAXES.TAX_DET_ID%TYPE ;

4787: trx_ref_id = cp_trx_ref_id;
4788:
4789: rec_cur_get_refs CUR_GET_REFS%ROWTYPE ;
4790: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;
4791: ln_tax_det_id JAI_RGM_TAXES.TAX_DET_ID%TYPE ;
4792: ln_apportion_ratio NUMBER ;
4793: ln_user_id JAI_RGM_REFS_ALL.CREATED_BY%TYPE ;
4794: ln_login_id JAI_RGM_REFS_ALL.LAST_UPDATE_LOGIN%TYPE ;
4795: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;

Line 4979: || the table jai_rgm_taxes

4975: FOR rec_cur_get_rgm_taxes IN cur_get_rgm_taxes ( cp_trx_ref_id => rec_cur_get_refs.trx_ref_id )
4976: LOOP
4977: /*******
4978: || Get the tax_det_id - primary key for
4979: || the table jai_rgm_taxes
4980: *******/
4981: OPEN cur_get_tax_det_id ;
4982: FETCH cur_get_tax_det_id INTO ln_tax_det_id;
4983: CLOSE cur_get_tax_det_id;

Line 5003: INSERT into jai_rgm_taxes (

4999: ||', last_update_date -> '||sysdate ||fnd_global.local_chr(10)
5000: ||', last_update_login -> '||ln_user_id
5001: );*/
5002:
5003: INSERT into jai_rgm_taxes (
5004: tax_det_id ,
5005: trx_ref_id ,
5006: tax_type ,
5007: tax_amt ,

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

5038:
5039:
5040: /*commented by csahoo for bug# 6401388
5041: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5042: pv_log_msg => ' After Insert into jai_rgm_taxes '
5043: );*/
5044: END LOOP; /* End of tax population */
5045: END LOOP; /*End of jai_rgm_refs_all population */
5046:

Line 5887: jai_rgm_taxes jrt

5883: SELECT
5884: sum(nvl(jrt.func_tax_amt,0)) total_tax_amount
5885: FROM
5886: jai_rgm_refs_all jrra,
5887: jai_rgm_taxes jrt
5888: WHERE
5889: jrra.trx_ref_id = jrt.trx_ref_id
5890: AND jrra.transaction_id = cp_transaction_id;
5891: