APPS.IGS_CA_VAL_CAT dependencies on IGS_CA_TYPE

Line 13: cp_cal_type IGS_CA_TYPE.CAL_TYPE%TYPE) IS

9: DECLARE
10: cst_active CONSTANT VARCHAR2(10) := 'ACTIVE';
11: cst_inactive CONSTANT VARCHAR2(10) := 'INACTIVE';
12: CURSOR c_cal_instance_rec (
13: cp_cal_type IGS_CA_TYPE.CAL_TYPE%TYPE) IS
14: SELECT DISTINCT 'x'
15: FROM IGS_CA_INST ci,
16: IGS_CA_STAT cs
17: WHERE ci.CAL_TYPE = cp_cal_type AND

Line 24: -- This module validates that IGS_CA_TYPE.S_CAL_CAT

20: v_other_detail VARCHAR2(255);
21: v_cal_instance_rec IGS_CA_INST%ROWTYPE;
22: v_check CHAR;
23: BEGIN
24: -- This module validates that IGS_CA_TYPE.S_CAL_CAT
25: -- cannot be changed if ACTIVE calendar instances
26: -- exist for the calendar type.
27: -- validate the input parameters
28: IF (p_cal_type IS NULL) THEN

Line 89: cst_teaching CONSTANT IGS_CA_TYPE.S_CAL_CAT%TYPE := 'TEACHING';

85: RETURN BOOLEAN AS
86: gv_other_detail VARCHAR2(255);
87: BEGIN
88: DECLARE
89: cst_teaching CONSTANT IGS_CA_TYPE.S_CAL_CAT%TYPE := 'TEACHING';
90: BEGIN
91: -- Validate if IGS_CA_TYPE.ARTS_TEACHING_CAL_TYPE_CD exists,
92: -- and only exists for IGS_CA_TYPE.S_CAL_CAT 'TEACHING'.
93: IF (p_arts_teaching_cal_type_cd IS NULL) THEN

Line 91: -- Validate if IGS_CA_TYPE.ARTS_TEACHING_CAL_TYPE_CD exists,

87: BEGIN
88: DECLARE
89: cst_teaching CONSTANT IGS_CA_TYPE.S_CAL_CAT%TYPE := 'TEACHING';
90: BEGIN
91: -- Validate if IGS_CA_TYPE.ARTS_TEACHING_CAL_TYPE_CD exists,
92: -- and only exists for IGS_CA_TYPE.S_CAL_CAT 'TEACHING'.
93: IF (p_arts_teaching_cal_type_cd IS NULL) THEN
94: IF (p_s_cal_cat = cst_teaching) THEN
95: p_message_name := 'IGS_CA_ARTS_CALTYPE_TEACHING';

Line 92: -- and only exists for IGS_CA_TYPE.S_CAL_CAT 'TEACHING'.

88: DECLARE
89: cst_teaching CONSTANT IGS_CA_TYPE.S_CAL_CAT%TYPE := 'TEACHING';
90: BEGIN
91: -- Validate if IGS_CA_TYPE.ARTS_TEACHING_CAL_TYPE_CD exists,
92: -- and only exists for IGS_CA_TYPE.S_CAL_CAT 'TEACHING'.
93: IF (p_arts_teaching_cal_type_cd IS NULL) THEN
94: IF (p_s_cal_cat = cst_teaching) THEN
95: p_message_name := 'IGS_CA_ARTS_CALTYPE_TEACHING';
96: RETURN FALSE;