DBA Data[Home] [Help]

APPS.JAI_AR_RCTA_TRIGGER_PKG dependencies on JAI_RGM_DEFINITIONS

Line 639: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;

635: v_organization_id NUMBER ;
636: v_loc_id NUMBER ;
637: v_trans_type RA_CUST_TRX_TYPES_ALL.TYPE%TYPE ;
638: lv_vat_invoice_no JAI_AR_TRXS.VAT_INVOICE_NO%TYPE ;
639: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
640: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE ;
641: lv_process_flag VARCHAR2(10) ;
642: lv_process_message VARCHAR2(4000) ;
643: ld_gl_date RA_CUST_TRX_LINE_GL_DIST_ALL.GL_DATE%TYPE ;

Line 640: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE ;

636: v_loc_id NUMBER ;
637: v_trans_type RA_CUST_TRX_TYPES_ALL.TYPE%TYPE ;
638: lv_vat_invoice_no JAI_AR_TRXS.VAT_INVOICE_NO%TYPE ;
639: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
640: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE ;
641: lv_process_flag VARCHAR2(10) ;
642: lv_process_message VARCHAR2(4000) ;
643: ld_gl_date RA_CUST_TRX_LINE_GL_DIST_ALL.GL_DATE%TYPE ;
644: ld_vat_invoice_date JAI_AR_TRXS.VAT_INVOICE_DATE%TYPE ;

Line 1396: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;

1392: lv_vat_invoice_number JAI_AR_TRXS.VAT_INVOICE_NO%TYPE;
1393: lv_vat_taxes_exist VARCHAR2(1);
1394: lv_vat_no_same_exc_no JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE; -- := 'N'; --Ramananda for File.Sql.35
1395: ld_gl_date RA_CUST_TRX_LINE_GL_DIST_ALL.GL_DATE%TYPE;
1396: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;
1397: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;
1398:
1399:
1400: --3661746

Line 1397: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;

1393: lv_vat_taxes_exist VARCHAR2(1);
1394: lv_vat_no_same_exc_no JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE; -- := 'N'; --Ramananda for File.Sql.35
1395: ld_gl_date RA_CUST_TRX_LINE_GL_DIST_ALL.GL_DATE%TYPE;
1396: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;
1397: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;
1398:
1399:
1400: --3661746
1401:

Line 2871: LN_TCS_REGIME_ID JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;

2867:
2868: -- Added by sacsethi for bug 5631784 on 30-01-2007
2869: -- START 5631784
2870: LN_TCS_EXISTS NUMBER;
2871: LN_TCS_REGIME_ID JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;
2872: LN_THRESHOLD_SLAB_ID JAI_AP_TDS_THHOLD_SLABS.THRESHOLD_SLAB_ID%TYPE;
2873: LN_THRESHOLD_TAX_CAT_ID JAI_AP_TDS_THHOLD_TAXES.TAX_CATEGORY_ID%TYPE;
2874:
2875: CURSOR GC_CHK_RGM_TAX_EXISTS ( CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE

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

2871: LN_TCS_REGIME_ID JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;
2872: LN_THRESHOLD_SLAB_ID JAI_AP_TDS_THHOLD_SLABS.THRESHOLD_SLAB_ID%TYPE;
2873: LN_THRESHOLD_TAX_CAT_ID JAI_AP_TDS_THHOLD_TAXES.TAX_CATEGORY_ID%TYPE;
2874:
2875: CURSOR GC_CHK_RGM_TAX_EXISTS ( CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE
2876: , CP_RGM_TAX_TYPE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE
2877: , CP_TAX_CATEGORY_ID JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_ID%TYPE
2878: )
2879: IS

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

2885: AND CATL.TAX_ID = CODES.TAX_ID
2886: AND CODES.TAX_TYPE = JRTTV.TAX_TYPE
2887: AND JRTTV.REGIME_CODE = CP_REGIME_CODE;
2888:
2889: CURSOR GC_GET_REGIME_ID (CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE)
2890: IS
2891: SELECT REGIME_ID
2892: FROM JAI_RGM_DEFINITIONS
2893: WHERE REGIME_CODE = CP_REGIME_CODE;

Line 2892: FROM JAI_RGM_DEFINITIONS

2888:
2889: CURSOR GC_GET_REGIME_ID (CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE)
2890: IS
2891: SELECT REGIME_ID
2892: FROM JAI_RGM_DEFINITIONS
2893: WHERE REGIME_CODE = CP_REGIME_CODE;
2894:
2895: LV_PROCESS_FLAG VARCHAR2 (2);
2896: LV_PROCESS_MESSAGE VARCHAR2 (1998);