APPS.IGS_GR_VAL_CRD dependencies on IGS_CA_TYPE

Line 10: -- Validate that the IGS_CA_TYPE specified has a SI_CA_S_CA_CAT

6: p_cal_type IN VARCHAR2 ,
7: p_message_name OUT NOCOPY VARCHAR2 )
8: RETURN BOOLEAN AS
9: BEGIN -- grdp_val_ci_grad
10: -- Validate that the IGS_CA_TYPE specified has a SI_CA_S_CA_CAT
11: -- of GRADUATION.
12: DECLARE
13: v_ct_found VARCHAR2(1);
14: cst_graduation CONSTANT VARCHAR2(10) := 'GRADUATION';

Line 17: FROM IGS_CA_TYPE

13: v_ct_found VARCHAR2(1);
14: cst_graduation CONSTANT VARCHAR2(10) := 'GRADUATION';
15: CURSOR c_ct IS
16: SELECT 'x'
17: FROM IGS_CA_TYPE
18: WHERE cal_type = p_cal_type AND
19: s_cal_cat = cst_graduation;
20: BEGIN
21: p_message_name := NULL;

Line 26: -- Check for IGS_CA_TYPE records with a IGS_CA_TYPE of p_cal_type and a

22: -- Check paramter
23: IF p_cal_type IS NULL THEN
24: RETURN TRUE;
25: END IF;
26: -- Check for IGS_CA_TYPE records with a IGS_CA_TYPE of p_cal_type and a
27: -- SI_CA_S_CA_CAT of GRADUATION.
28: OPEN c_ct;
29: FETCH c_ct INTO v_ct_found;
30: IF (c_ct%NOTFOUND) THEN