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 1425: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;

1421: lv_vat_invoice_number JAI_AR_TRXS.VAT_INVOICE_NO%TYPE;
1422: lv_vat_taxes_exist VARCHAR2(1);
1423: lv_vat_no_same_exc_no JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE; -- := 'N'; --Ramananda for File.Sql.35
1424: ld_gl_date RA_CUST_TRX_LINE_GL_DIST_ALL.GL_DATE%TYPE;
1425: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;
1426: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;
1427:
1428:
1429: --3661746

Line 1426: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;

1422: lv_vat_taxes_exist VARCHAR2(1);
1423: lv_vat_no_same_exc_no JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE; -- := 'N'; --Ramananda for File.Sql.35
1424: ld_gl_date RA_CUST_TRX_LINE_GL_DIST_ALL.GL_DATE%TYPE;
1425: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;
1426: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;
1427:
1428:
1429: --3661746
1430:

Line 3400: LN_TCS_REGIME_ID JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;

3396:
3397: -- Added by sacsethi for bug 5631784 on 30-01-2007
3398: -- START 5631784
3399: LN_TCS_EXISTS NUMBER;
3400: LN_TCS_REGIME_ID JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;
3401: LN_THRESHOLD_SLAB_ID JAI_AP_TDS_THHOLD_SLABS.THRESHOLD_SLAB_ID%TYPE;
3402: LN_THRESHOLD_TAX_CAT_ID JAI_AP_TDS_THHOLD_TAXES.TAX_CATEGORY_ID%TYPE;
3403:
3404: CURSOR GC_CHK_RGM_TAX_EXISTS ( CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE

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

3400: LN_TCS_REGIME_ID JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;
3401: LN_THRESHOLD_SLAB_ID JAI_AP_TDS_THHOLD_SLABS.THRESHOLD_SLAB_ID%TYPE;
3402: LN_THRESHOLD_TAX_CAT_ID JAI_AP_TDS_THHOLD_TAXES.TAX_CATEGORY_ID%TYPE;
3403:
3404: CURSOR GC_CHK_RGM_TAX_EXISTS ( CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE
3405: , CP_RGM_TAX_TYPE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE
3406: , CP_TAX_CATEGORY_ID JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_ID%TYPE
3407: )
3408: IS

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

3414: AND CATL.TAX_ID = CODES.TAX_ID
3415: AND CODES.TAX_TYPE = JRTTV.TAX_TYPE
3416: AND JRTTV.REGIME_CODE = CP_REGIME_CODE;
3417:
3418: CURSOR GC_GET_REGIME_ID (CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE)
3419: IS
3420: SELECT REGIME_ID
3421: FROM JAI_RGM_DEFINITIONS
3422: WHERE REGIME_CODE = CP_REGIME_CODE;

Line 3421: FROM JAI_RGM_DEFINITIONS

3417:
3418: CURSOR GC_GET_REGIME_ID (CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE)
3419: IS
3420: SELECT REGIME_ID
3421: FROM JAI_RGM_DEFINITIONS
3422: WHERE REGIME_CODE = CP_REGIME_CODE;
3423:
3424: LV_PROCESS_FLAG VARCHAR2 (2);
3425: LV_PROCESS_MESSAGE VARCHAR2 (1998);

Line 3986: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;

3982: v_organization_id NUMBER ;
3983: v_loc_id NUMBER ;
3984: v_trans_type RA_CUST_TRX_TYPES_ALL.TYPE%TYPE ;
3985: lv_vat_invoice_no JAI_AR_TRXS.VAT_INVOICE_NO%TYPE ;
3986: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
3987: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE ;
3988: lv_process_flag VARCHAR2(10) ;
3989: lv_process_message VARCHAR2(4000) ;
3990: ld_gl_date RA_CUST_TRX_LINE_GL_DIST_ALL.GL_DATE%TYPE ;

Line 3987: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE ;

3983: v_loc_id NUMBER ;
3984: v_trans_type RA_CUST_TRX_TYPES_ALL.TYPE%TYPE ;
3985: lv_vat_invoice_no JAI_AR_TRXS.VAT_INVOICE_NO%TYPE ;
3986: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
3987: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE ;
3988: lv_process_flag VARCHAR2(10) ;
3989: lv_process_message VARCHAR2(4000) ;
3990: ld_gl_date RA_CUST_TRX_LINE_GL_DIST_ALL.GL_DATE%TYPE ;
3991: ld_vat_invoice_date JAI_AR_TRXS.VAT_INVOICE_DATE%TYPE ;