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 1854: ln_tcs_regime_id JAI_RGM_DEFINITIONS.regime_id%type;

1850: ln_legal_entity_id NUMBER ; /* rallamse bug#4510143 */
1851: -- Date 26-feb-2006 added by sacsethi for bug 5631784
1852: --start 5631784
1853: ln_tcs_exists number;
1854: ln_tcs_regime_id JAI_RGM_DEFINITIONS.regime_id%type;
1855: ln_threshold_slab_id jai_ap_tds_thhold_slabs.threshold_slab_id%type;
1856: ln_last_line_no number;
1857: ln_base_line_no number;
1858: lv_process_flag VARCHAR2(2);

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

1857: ln_base_line_no number;
1858: lv_process_flag VARCHAR2(2);
1859: lv_process_message VARCHAR2(1996);
1860: ln_reg_id number;
1861: cursor c_chk_rgm_tax_exists ( cp_regime_code JAI_RGM_DEFINITIONS.regime_code%type
1862: , cp_cust_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%type
1863: )
1864: is
1865: select count(1)

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

1869: where jtc.tax_id = jrctt.tax_id
1870: and jtc.tax_type = jrttv.tax_type
1871: and regime_code = cp_regime_code
1872: and jrctt.link_to_cust_trx_line_id = cp_cust_trx_line_id;
1873: cursor c_get_regime_id (cp_regime_code JAI_RGM_DEFINITIONS.regime_code%type)
1874: is
1875: select regime_id
1876: from JAI_RGM_DEFINITIONS
1877: where regime_code = cp_regime_code;

Line 1876: from JAI_RGM_DEFINITIONS

1872: and jrctt.link_to_cust_trx_line_id = cp_cust_trx_line_id;
1873: cursor c_get_regime_id (cp_regime_code JAI_RGM_DEFINITIONS.regime_code%type)
1874: is
1875: select regime_id
1876: from JAI_RGM_DEFINITIONS
1877: where regime_code = cp_regime_code;
1878: --end 5631784
1879: /*added for bug#6498072*/
1880: Cursor get_ar_tax_amount

Line 4890: ln_tcs_regime_id JAI_RGM_DEFINITIONS.regime_id%type;

4886: v_books_id Number;
4887: v_gl_date Date;
4888: -- Date 26-feb-2006 added by sacsethi for bug 5631784
4889: ln_tcs_exists number;
4890: ln_tcs_regime_id JAI_RGM_DEFINITIONS.regime_id%type;
4891: ln_threshold_slab_id JAI_AP_TDS_THHOLD_SLABS.threshold_slab_id%type;
4892: ln_threshold_tax_cat_id JAI_AP_TDS_THHOLD_TAXES.tax_category_id%type;
4893: ld_gl_dist_date date;
4894: v_service_type VARCHAR2(30); -- added by csahoo for bug#5879769

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

4900: where customer_trx_id = cp_customer_trx_id
4901: and account_class = jai_constants.account_class_rec
4902: and latest_rec_flag = jai_constants.yes;
4903:
4904: CURSOR GC_GET_REGIME_ID (CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE)
4905: IS
4906: SELECT REGIME_ID
4907: FROM JAI_RGM_DEFINITIONS
4908: WHERE REGIME_CODE = CP_REGIME_CODE;

Line 4907: FROM JAI_RGM_DEFINITIONS

4903:
4904: CURSOR GC_GET_REGIME_ID (CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE)
4905: IS
4906: SELECT REGIME_ID
4907: FROM JAI_RGM_DEFINITIONS
4908: WHERE REGIME_CODE = CP_REGIME_CODE;
4909: CURSOR GC_CHK_RGM_TAX_EXISTS ( CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE
4910: , CP_RGM_TAX_TYPE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE
4911: , CP_TAX_CATEGORY_ID JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_ID%TYPE

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

4905: IS
4906: SELECT REGIME_ID
4907: FROM JAI_RGM_DEFINITIONS
4908: WHERE REGIME_CODE = CP_REGIME_CODE;
4909: CURSOR GC_CHK_RGM_TAX_EXISTS ( CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE
4910: , CP_RGM_TAX_TYPE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE
4911: , CP_TAX_CATEGORY_ID JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_ID%TYPE
4912: )
4913: IS