DBA Data[Home] [Help]

APPS.JAI_AR_TAX_LINES_PKG dependencies on JAI_RGM_DEFINITIONS

Line 263: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;

259: SELECT regime_id, regime_code
260: FROM jai_regime_tax_types_v jrttv
261: WHERE upper(jrttv.tax_type) = upper(cp_tax_type);
262:
263: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;
264: lv_attr_value JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
265:
266: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;
267: lv_error_flag VARCHAR2(2);

Line 266: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;

262:
263: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;
264: lv_attr_value JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
265:
266: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;
267: lv_error_flag VARCHAR2(2);
268: lv_error_message VARCHAR2(4000);
269:
270: v_err_mesg VARCHAR2(250);

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

305: ln_nonship_rma_flag NUMBER;
306:
307: v_counter NUMBER := 0;
308: lb_is_accrual_basis BOOLEAN := FALSE;
309: CURSOR GC_GET_REGIME_ID(CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE) IS
310: SELECT REGIME_ID
311: FROM JAI_RGM_DEFINITIONS
312: WHERE REGIME_CODE = CP_REGIME_CODE;
313: ln_tcs_regime_id JAI_RGM_DEFINITIONS.regime_id%type;

Line 311: FROM JAI_RGM_DEFINITIONS

307: v_counter NUMBER := 0;
308: lb_is_accrual_basis BOOLEAN := FALSE;
309: CURSOR GC_GET_REGIME_ID(CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE) IS
310: SELECT REGIME_ID
311: FROM JAI_RGM_DEFINITIONS
312: WHERE REGIME_CODE = CP_REGIME_CODE;
313: ln_tcs_regime_id JAI_RGM_DEFINITIONS.regime_id%type;
314: ln_threshold_slab_id jai_ap_tds_thhold_slabs.threshold_slab_id%type;
315: ln_threshold_tax_cat_id jai_ap_tds_thhold_taxes.tax_category_id%type;

Line 313: ln_tcs_regime_id JAI_RGM_DEFINITIONS.regime_id%type;

309: CURSOR GC_GET_REGIME_ID(CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE) IS
310: SELECT REGIME_ID
311: FROM JAI_RGM_DEFINITIONS
312: WHERE REGIME_CODE = CP_REGIME_CODE;
313: ln_tcs_regime_id JAI_RGM_DEFINITIONS.regime_id%type;
314: ln_threshold_slab_id jai_ap_tds_thhold_slabs.threshold_slab_id%type;
315: ln_threshold_tax_cat_id jai_ap_tds_thhold_taxes.tax_category_id%type;
316: lv_process_flag VARCHAR2(2);
317: lv_process_message VARCHAR2(1996);