APPS.IGS_PS_VAL_POS dependencies on IGS_CA_TYPE

Line 62: p_cal_type IN IGS_CA_TYPE.cal_type%TYPE ,

58: --
59:
60: -- Validate the calendar type is categorised admission and is not closed.
61: FUNCTION crsp_val_pos_cat(
62: p_cal_type IN IGS_CA_TYPE.cal_type%TYPE ,
63: p_message_name OUT NOCOPY VARCHAR2 )
64: RETURN BOOLEAN AS
65: BEGIN -- crsp_val_pos_cat
66: -- Validate the IGS_CA_TYPE is not closed and the SI_CA_S_CA_CAT is set to ADMISSION.

Line 66: -- Validate the IGS_CA_TYPE is not closed and the SI_CA_S_CA_CAT is set to ADMISSION.

62: p_cal_type IN IGS_CA_TYPE.cal_type%TYPE ,
63: p_message_name OUT NOCOPY VARCHAR2 )
64: RETURN BOOLEAN AS
65: BEGIN -- crsp_val_pos_cat
66: -- Validate the IGS_CA_TYPE is not closed and the SI_CA_S_CA_CAT is set to ADMISSION.
67: DECLARE
68: v_closed_ind IGS_CA_TYPE.closed_ind%TYPE;
69: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;
70: CURSOR c_cat IS

Line 68: v_closed_ind IGS_CA_TYPE.closed_ind%TYPE;

64: RETURN BOOLEAN AS
65: BEGIN -- crsp_val_pos_cat
66: -- Validate the IGS_CA_TYPE is not closed and the SI_CA_S_CA_CAT is set to ADMISSION.
67: DECLARE
68: v_closed_ind IGS_CA_TYPE.closed_ind%TYPE;
69: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;
70: CURSOR c_cat IS
71: SELECT closed_ind,
72: s_cal_cat

Line 69: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;

65: BEGIN -- crsp_val_pos_cat
66: -- Validate the IGS_CA_TYPE is not closed and the SI_CA_S_CA_CAT is set to ADMISSION.
67: DECLARE
68: v_closed_ind IGS_CA_TYPE.closed_ind%TYPE;
69: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;
70: CURSOR c_cat IS
71: SELECT closed_ind,
72: s_cal_cat
73: FROM IGS_CA_TYPE

Line 73: FROM IGS_CA_TYPE

69: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;
70: CURSOR c_cat IS
71: SELECT closed_ind,
72: s_cal_cat
73: FROM IGS_CA_TYPE
74: WHERE cal_type = p_cal_type;
75: BEGIN
76: -- check parameters
77: IF p_cal_type IS NULL THEN

Line 92: --check if IGS_CA_TYPE is closed

88: p_message_name := NULL;
89: RETURN TRUE;
90: END IF;
91: CLOSE c_cat;
92: --check if IGS_CA_TYPE is closed
93: IF v_closed_ind = 'Y' THEN
94: p_message_name := 'IGS_CA_CALTYPE_CLOSED';
95: RETURN FALSE;
96: END IF;

Line 97: --check if the IGS_CA_TYPE is of category 'ADMISSION'

93: IF v_closed_ind = 'Y' THEN
94: p_message_name := 'IGS_CA_CALTYPE_CLOSED';
95: RETURN FALSE;
96: END IF;
97: --check if the IGS_CA_TYPE is of category 'ADMISSION'
98: IF v_s_cal_cat <> 'ADMISSION' THEN
99: p_message_name := 'IGS_PS_CALTYPE_ADMISSION_CAL';
100: RETURN FALSE;
101: END IF;

Line 102: -- validated IGS_CA_TYPE is not closed and SI_CA_S_CA_CAT set to ADMISSION

98: IF v_s_cal_cat <> 'ADMISSION' THEN
99: p_message_name := 'IGS_PS_CALTYPE_ADMISSION_CAL';
100: RETURN FALSE;
101: END IF;
102: -- validated IGS_CA_TYPE is not closed and SI_CA_S_CA_CAT set to ADMISSION
103: p_message_name := NULL;
104: RETURN TRUE;
105: EXCEPTION
106: WHEN OTHERS THEN