APPS.JA_JAIN23P2_XMLP_PKG dependencies on JAI_CMN_RG_PERIOD_BALS

Line 44: LV_REGISTER_TYPE JAI_CMN_RG_PERIOD_BALS.REGISTER_TYPE%TYPE;

40: LN_BALANCES_END_DATE NUMBER;
41: LD_DELTA_START_DATE DATE;
42: LN_DELTA_OPENING_BAL NUMBER;
43: LN_DELTA_AMOUNT NUMBER;
44: LV_REGISTER_TYPE JAI_CMN_RG_PERIOD_BALS.REGISTER_TYPE%TYPE;
45: R_PERIOD_BAL JAI_CMN_RG_PERIOD_BALS%ROWTYPE;
46: CURSOR C_PERIOD_BAL(CP_ORGANIZATION_ID IN NUMBER,CP_LOCATION_ID IN NUMBER,CP_REGISTER_TYPE IN VARCHAR2,CP_START_DATE IN DATE) IS
47: SELECT
48: *

Line 45: R_PERIOD_BAL JAI_CMN_RG_PERIOD_BALS%ROWTYPE;

41: LD_DELTA_START_DATE DATE;
42: LN_DELTA_OPENING_BAL NUMBER;
43: LN_DELTA_AMOUNT NUMBER;
44: LV_REGISTER_TYPE JAI_CMN_RG_PERIOD_BALS.REGISTER_TYPE%TYPE;
45: R_PERIOD_BAL JAI_CMN_RG_PERIOD_BALS%ROWTYPE;
46: CURSOR C_PERIOD_BAL(CP_ORGANIZATION_ID IN NUMBER,CP_LOCATION_ID IN NUMBER,CP_REGISTER_TYPE IN VARCHAR2,CP_START_DATE IN DATE) IS
47: SELECT
48: *
49: FROM

Line 50: JAI_CMN_RG_PERIOD_BALS

46: CURSOR C_PERIOD_BAL(CP_ORGANIZATION_ID IN NUMBER,CP_LOCATION_ID IN NUMBER,CP_REGISTER_TYPE IN VARCHAR2,CP_START_DATE IN DATE) IS
47: SELECT
48: *
49: FROM
50: JAI_CMN_RG_PERIOD_BALS
51: WHERE ORGANIZATION_ID = CP_ORGANIZATION_ID
52: AND LOCATION_ID = CP_LOCATION_ID
53: AND REGISTER_TYPE = CP_REGISTER_TYPE
54: AND CP_START_DATE BETWEEN START_DATE

Line 60: JAI_CMN_RG_PERIOD_BALS

56: CURSOR C_MAX_PERIOD_BAL(CP_ORGANIZATION_ID IN NUMBER,CP_LOCATION_ID IN NUMBER,CP_REGISTER_TYPE IN VARCHAR2) IS
57: SELECT
58: *
59: FROM
60: JAI_CMN_RG_PERIOD_BALS
61: WHERE ORGANIZATION_ID = CP_ORGANIZATION_ID
62: AND LOCATION_ID = CP_LOCATION_ID
63: AND REGISTER_TYPE = CP_REGISTER_TYPE
64: AND ( START_DATE , END_DATE ) = (

Line 69: JAI_CMN_RG_PERIOD_BALS

65: SELECT
66: MAX(START_DATE),
67: MAX(END_DATE)
68: FROM
69: JAI_CMN_RG_PERIOD_BALS
70: WHERE ORGANIZATION_ID = CP_ORGANIZATION_ID
71: AND LOCATION_ID = CP_LOCATION_ID
72: AND REGISTER_TYPE = CP_REGISTER_TYPE );
73: LN_DE_EXC_EDU_SH_CESS_OP_BAL NUMBER;

Line 164: LN_DELTA_EXC_EDU_CESS_OP_BAL := JAI_CMN_RG_PERIOD_BALS_PKG.GET_CESS_OPENING_BALANCE(CP_ORGANIZATION_ID => R_PERIOD_BAL.ORGANIZATION_ID

160: ,0);
161: ELSE
162: LD_DELTA_START_DATE := R_PERIOD_BAL.START_DATE - 1;
163: LN_DELTA_OPENING_BAL := R_PERIOD_BAL.OPENING_BALANCE + R_PERIOD_BAL.CUMULATIVE_MISC_ADJUSTMENT + R_PERIOD_BAL.CUMULATIVE_ROUNDING_ADJUSTMENT;
164: LN_DELTA_EXC_EDU_CESS_OP_BAL := JAI_CMN_RG_PERIOD_BALS_PKG.GET_CESS_OPENING_BALANCE(CP_ORGANIZATION_ID => R_PERIOD_BAL.ORGANIZATION_ID
165: ,CP_LOCATION_ID => R_PERIOD_BAL.LOCATION_ID
166: ,CP_REGISTER_TYPE => R_PERIOD_BAL.REGISTER_TYPE
167: ,CP_PERIOD_START_DATE => R_PERIOD_BAL.START_DATE
168: ,CP_TAX_TYPE => 'EXCISE_EDUCATION_CESS') + NVL(R_PERIOD_BAL.EXC_EDU_CESS_ADJ_OP_BAL

Line 170: LN_DELTA_CVD_EDU_CESS_OP_BAL := JAI_CMN_RG_PERIOD_BALS_PKG.GET_CESS_OPENING_BALANCE(CP_ORGANIZATION_ID => R_PERIOD_BAL.ORGANIZATION_ID

166: ,CP_REGISTER_TYPE => R_PERIOD_BAL.REGISTER_TYPE
167: ,CP_PERIOD_START_DATE => R_PERIOD_BAL.START_DATE
168: ,CP_TAX_TYPE => 'EXCISE_EDUCATION_CESS') + NVL(R_PERIOD_BAL.EXC_EDU_CESS_ADJ_OP_BAL
169: ,0);
170: LN_DELTA_CVD_EDU_CESS_OP_BAL := JAI_CMN_RG_PERIOD_BALS_PKG.GET_CESS_OPENING_BALANCE(CP_ORGANIZATION_ID => R_PERIOD_BAL.ORGANIZATION_ID
171: ,CP_LOCATION_ID => R_PERIOD_BAL.LOCATION_ID
172: ,CP_REGISTER_TYPE => R_PERIOD_BAL.REGISTER_TYPE
173: ,CP_PERIOD_START_DATE => R_PERIOD_BAL.START_DATE
174: ,CP_TAX_TYPE => 'CVD_EDUCATION_CESS') + NVL(R_PERIOD_BAL.CVD_EDU_CESS_ADJ_OP_BAL

Line 176: LN_DE_EXC_EDU_SH_CESS_OP_BAL := JAI_CMN_RG_PERIOD_BALS_PKG.GET_CESS_OPENING_BALANCE(CP_ORGANIZATION_ID => R_PERIOD_BAL.ORGANIZATION_ID

172: ,CP_REGISTER_TYPE => R_PERIOD_BAL.REGISTER_TYPE
173: ,CP_PERIOD_START_DATE => R_PERIOD_BAL.START_DATE
174: ,CP_TAX_TYPE => 'CVD_EDUCATION_CESS') + NVL(R_PERIOD_BAL.CVD_EDU_CESS_ADJ_OP_BAL
175: ,0);
176: LN_DE_EXC_EDU_SH_CESS_OP_BAL := JAI_CMN_RG_PERIOD_BALS_PKG.GET_CESS_OPENING_BALANCE(CP_ORGANIZATION_ID => R_PERIOD_BAL.ORGANIZATION_ID
177: ,CP_LOCATION_ID => R_PERIOD_BAL.LOCATION_ID
178: ,CP_REGISTER_TYPE => R_PERIOD_BAL.REGISTER_TYPE
179: ,CP_PERIOD_START_DATE => R_PERIOD_BAL.START_DATE
180: ,CP_TAX_TYPE => 'EXCISE_SH_EDU_CESS') + NVL(R_PERIOD_BAL.SH_EXC_EDU_CESS_ADJ_OP_BAL

Line 182: LN_DE_CVD_EDU_SH_CESS_OP_BAL := JAI_CMN_RG_PERIOD_BALS_PKG.GET_CESS_OPENING_BALANCE(CP_ORGANIZATION_ID => R_PERIOD_BAL.ORGANIZATION_ID

178: ,CP_REGISTER_TYPE => R_PERIOD_BAL.REGISTER_TYPE
179: ,CP_PERIOD_START_DATE => R_PERIOD_BAL.START_DATE
180: ,CP_TAX_TYPE => 'EXCISE_SH_EDU_CESS') + NVL(R_PERIOD_BAL.SH_EXC_EDU_CESS_ADJ_OP_BAL
181: ,0);
182: LN_DE_CVD_EDU_SH_CESS_OP_BAL := JAI_CMN_RG_PERIOD_BALS_PKG.GET_CESS_OPENING_BALANCE(CP_ORGANIZATION_ID => R_PERIOD_BAL.ORGANIZATION_ID
183: ,CP_LOCATION_ID => R_PERIOD_BAL.LOCATION_ID
184: ,CP_REGISTER_TYPE => R_PERIOD_BAL.REGISTER_TYPE
185: ,CP_PERIOD_START_DATE => R_PERIOD_BAL.START_DATE
186: ,CP_TAX_TYPE => 'CVD_SH_EDU_CESS') + NVL(R_PERIOD_BAL.SH_CVD_EDU_CESS_ADJ_OP_BAL