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_RCTLA_TRIGGER_PKG dependencies on JAI_RGM_DEFINITIONS

Line 2064: ln_tcs_regime_id JAI_RGM_DEFINITIONS.regime_id%type;

2060: ln_legal_entity_id NUMBER ; /* rallamse bug#4510143 */
2061: -- Date 26-feb-2006 added by sacsethi for bug 5631784
2062: --start 5631784
2063: ln_tcs_exists number;
2064: ln_tcs_regime_id JAI_RGM_DEFINITIONS.regime_id%type;
2065: ln_threshold_slab_id jai_ap_tds_thhold_slabs.threshold_slab_id%type;
2066: ln_last_line_no number;
2067: ln_base_line_no number;
2068: lv_process_flag VARCHAR2(2);

Line 2071: cursor c_chk_rgm_tax_exists ( cp_regime_code JAI_RGM_DEFINITIONS.regime_code%type

2067: ln_base_line_no number;
2068: lv_process_flag VARCHAR2(2);
2069: lv_process_message VARCHAR2(1996);
2070: ln_reg_id number;
2071: cursor c_chk_rgm_tax_exists ( cp_regime_code JAI_RGM_DEFINITIONS.regime_code%type
2072: , cp_cust_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%type
2073: )
2074: is
2075: select count(1)

Line 2083: cursor c_get_regime_id (cp_regime_code JAI_RGM_DEFINITIONS.regime_code%type)

2079: where jtc.tax_id = jrctt.tax_id
2080: and jtc.tax_type = jrttv.tax_type
2081: and regime_code = cp_regime_code
2082: and jrctt.link_to_cust_trx_line_id = cp_cust_trx_line_id;
2083: cursor c_get_regime_id (cp_regime_code JAI_RGM_DEFINITIONS.regime_code%type)
2084: is
2085: select regime_id
2086: from JAI_RGM_DEFINITIONS
2087: where regime_code = cp_regime_code;

Line 2086: from JAI_RGM_DEFINITIONS

2082: and jrctt.link_to_cust_trx_line_id = cp_cust_trx_line_id;
2083: cursor c_get_regime_id (cp_regime_code JAI_RGM_DEFINITIONS.regime_code%type)
2084: is
2085: select regime_id
2086: from JAI_RGM_DEFINITIONS
2087: where regime_code = cp_regime_code;
2088: --end 5631784
2089: /*added for bug#6498072*/
2090: Cursor get_ar_tax_amount

Line 4794: ln_tcs_regime_id JAI_RGM_DEFINITIONS.regime_id%type;

4790: lv_addl_msg JAI_CMN_ERRORS_T.ADDITIONAL_ERROR_MESG%type;
4791:
4792: ln_legal_entity_id NUMBER;
4793: ln_tcs_exists number;
4794: ln_tcs_regime_id JAI_RGM_DEFINITIONS.regime_id%type;
4795: ln_threshold_slab_id jai_ap_tds_thhold_slabs.threshold_slab_id%type;
4796: ln_last_line_no number;
4797: ln_base_line_no number;
4798: lv_process_flag VARCHAR2(2);

Line 4802: cursor c_chk_rgm_tax_exists ( cp_regime_code JAI_RGM_DEFINITIONS.regime_code%type

4798: lv_process_flag VARCHAR2(2);
4799: lv_process_message VARCHAR2(1996);
4800: ln_reg_id number;
4801: ln_threshold_tax_cat_id jai_ap_tds_thhold_taxes.tax_category_id%type;
4802: cursor c_chk_rgm_tax_exists ( cp_regime_code JAI_RGM_DEFINITIONS.regime_code%type
4803: , cp_cust_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%type
4804: )
4805: is
4806: select count(1)

Line 4814: cursor c_get_regime_id (cp_regime_code JAI_RGM_DEFINITIONS.regime_code%type)

4810: where jtc.tax_id = jrctt.tax_id
4811: and jtc.tax_type = jrttv.tax_type
4812: and regime_code = cp_regime_code
4813: and jrctt.link_to_cust_trx_line_id = cp_cust_trx_line_id;
4814: cursor c_get_regime_id (cp_regime_code JAI_RGM_DEFINITIONS.regime_code%type)
4815: is
4816: select regime_id
4817: from JAI_RGM_DEFINITIONS
4818: where regime_code = cp_regime_code;

Line 4817: from JAI_RGM_DEFINITIONS

4813: and jrctt.link_to_cust_trx_line_id = cp_cust_trx_line_id;
4814: cursor c_get_regime_id (cp_regime_code JAI_RGM_DEFINITIONS.regime_code%type)
4815: is
4816: select regime_id
4817: from JAI_RGM_DEFINITIONS
4818: where regime_code = cp_regime_code;
4819:
4820: Cursor get_ar_tax_amount
4821: is

Line 6260: ln_tcs_regime_id JAI_RGM_DEFINITIONS.regime_id%type;

6256: v_books_id Number;
6257: v_gl_date Date;
6258: -- Date 26-feb-2006 added by sacsethi for bug 5631784
6259: ln_tcs_exists number;
6260: ln_tcs_regime_id JAI_RGM_DEFINITIONS.regime_id%type;
6261: ln_threshold_slab_id JAI_AP_TDS_THHOLD_SLABS.threshold_slab_id%type;
6262: ln_threshold_tax_cat_id JAI_AP_TDS_THHOLD_TAXES.tax_category_id%type;
6263: ld_gl_dist_date date;
6264: v_service_type VARCHAR2(30); -- added by csahoo for bug#5879769

Line 6276: CURSOR GC_GET_REGIME_ID (CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE)

6272: where customer_trx_id = cp_customer_trx_id
6273: and account_class = jai_constants.account_class_rec
6274: and latest_rec_flag = jai_constants.yes;
6275:
6276: CURSOR GC_GET_REGIME_ID (CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE)
6277: IS
6278: SELECT REGIME_ID
6279: FROM JAI_RGM_DEFINITIONS
6280: WHERE REGIME_CODE = CP_REGIME_CODE;

Line 6279: FROM JAI_RGM_DEFINITIONS

6275:
6276: CURSOR GC_GET_REGIME_ID (CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE)
6277: IS
6278: SELECT REGIME_ID
6279: FROM JAI_RGM_DEFINITIONS
6280: WHERE REGIME_CODE = CP_REGIME_CODE;
6281: CURSOR GC_CHK_RGM_TAX_EXISTS ( CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE
6282: , CP_RGM_TAX_TYPE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE
6283: , CP_TAX_CATEGORY_ID JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_ID%TYPE

Line 6281: CURSOR GC_CHK_RGM_TAX_EXISTS ( CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE

6277: IS
6278: SELECT REGIME_ID
6279: FROM JAI_RGM_DEFINITIONS
6280: WHERE REGIME_CODE = CP_REGIME_CODE;
6281: CURSOR GC_CHK_RGM_TAX_EXISTS ( CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE
6282: , CP_RGM_TAX_TYPE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE
6283: , CP_TAX_CATEGORY_ID JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_ID%TYPE
6284: )
6285: IS