APPS.JAI_AR_TRX_HEADERS_PKG dependencies on JAI_RGM_DEFINITIONS

Line 1011: LN_TCS_REGIME_ID JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;

1007:
1008: ln_vat_assessable_value JAI_AR_TRX_LINES.VAT_ASSESSABLE_VALUE%TYPE;
1009:
1010: LN_TCS_EXISTS NUMBER;
1011: LN_TCS_REGIME_ID JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;
1012: LN_THRESHOLD_SLAB_ID JAI_AP_TDS_THHOLD_SLABS.THRESHOLD_SLAB_ID%TYPE;
1013: LN_THRESHOLD_TAX_CAT_ID JAI_AP_TDS_THHOLD_TAXES.TAX_CATEGORY_ID%TYPE;
1014:
1015: CURSOR GC_CHK_RGM_TAX_EXISTS(CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE,

Line 1015: CURSOR GC_CHK_RGM_TAX_EXISTS(CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE,

1011: LN_TCS_REGIME_ID JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;
1012: LN_THRESHOLD_SLAB_ID JAI_AP_TDS_THHOLD_SLABS.THRESHOLD_SLAB_ID%TYPE;
1013: LN_THRESHOLD_TAX_CAT_ID JAI_AP_TDS_THHOLD_TAXES.TAX_CATEGORY_ID%TYPE;
1014:
1015: CURSOR GC_CHK_RGM_TAX_EXISTS(CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE,
1016: CP_RGM_TAX_TYPE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE,
1017: CP_TAX_CATEGORY_ID JAI_CMN_TAX_CTGS_ALL.TAX_CATEGORY_ID%TYPE) IS
1018: SELECT COUNT(1)
1019: FROM JAI_CMN_TAX_CTG_LINES CATL,

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

1023: AND CATL.TAX_ID = CODES.TAX_ID
1024: AND CODES.TAX_TYPE = JRTTV.TAX_TYPE
1025: AND JRTTV.REGIME_CODE = CP_REGIME_CODE;
1026:
1027: CURSOR GC_GET_REGIME_ID(CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE) IS
1028: SELECT REGIME_ID
1029: FROM JAI_RGM_DEFINITIONS
1030: WHERE REGIME_CODE = CP_REGIME_CODE;
1031:

Line 1029: FROM JAI_RGM_DEFINITIONS

1025: AND JRTTV.REGIME_CODE = CP_REGIME_CODE;
1026:
1027: CURSOR GC_GET_REGIME_ID(CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE) IS
1028: SELECT REGIME_ID
1029: FROM JAI_RGM_DEFINITIONS
1030: WHERE REGIME_CODE = CP_REGIME_CODE;
1031:
1032: LV_PROCESS_FLAG VARCHAR2(2);
1033: LV_PROCESS_MESSAGE VARCHAR2(1998);

Line 1573: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;

1569: v_organization_id NUMBER;
1570: v_loc_id NUMBER;
1571: v_trans_type RA_CUST_TRX_TYPES_ALL.TYPE%TYPE;
1572: lv_vat_invoice_no JAI_AR_TRXS.VAT_INVOICE_NO%TYPE;
1573: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;
1574: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;
1575: lv_process_flag VARCHAR2(10);
1576: lv_process_message VARCHAR2(4000);
1577: ld_gl_date RA_CUST_TRX_LINE_GL_DIST_ALL.GL_DATE%TYPE;

Line 1574: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;

1570: v_loc_id NUMBER;
1571: v_trans_type RA_CUST_TRX_TYPES_ALL.TYPE%TYPE;
1572: lv_vat_invoice_no JAI_AR_TRXS.VAT_INVOICE_NO%TYPE;
1573: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;
1574: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;
1575: lv_process_flag VARCHAR2(10);
1576: lv_process_message VARCHAR2(4000);
1577: ld_gl_date RA_CUST_TRX_LINE_GL_DIST_ALL.GL_DATE%TYPE;
1578: ld_vat_invoice_date JAI_AR_TRXS.VAT_INVOICE_DATE%TYPE;

Line 2195: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;

2191: lv_vat_invoice_number JAI_AR_TRXS.VAT_INVOICE_NO%TYPE;
2192: lv_vat_taxes_exist VARCHAR2(1);
2193: lv_vat_no_same_exc_no JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
2194: ld_gl_date RA_CUST_TRX_LINE_GL_DIST_ALL.GL_DATE%TYPE;
2195: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;
2196: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;
2197:
2198: lv_doc_type_class varchar2(2);
2199: ln_cgst_regime_id NUMBER;

Line 2196: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;

2192: lv_vat_taxes_exist VARCHAR2(1);
2193: lv_vat_no_same_exc_no JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
2194: ld_gl_date RA_CUST_TRX_LINE_GL_DIST_ALL.GL_DATE%TYPE;
2195: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;
2196: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;
2197:
2198: lv_doc_type_class varchar2(2);
2199: ln_cgst_regime_id NUMBER;
2200: ln_sgst_regime_id NUMBER;