APPS.IGS_CA_VAL_DAIOC dependencies on IGS_CA_TYPE

Line 10: -- Validate IGS_CA_TYPE.s_cal_cat. If IGS_CA_TYPE.s_cal_cat = ?HOLIDAY?, then

6: p_message_name OUT NOCOPY VARCHAR2 )
7: RETURN BOOLEAN AS
8: gv_other_detail VARCHAR2(255);
9: BEGIN -- calp_val_daioc_ins
10: -- Validate IGS_CA_TYPE.s_cal_cat. If IGS_CA_TYPE.s_cal_cat = ?HOLIDAY?, then
11: -- offset constraints cannot be defined.
12: DECLARE
13: CURSOR c_ct(
14: cp_cal_type IGS_CA_TYPE.cal_type%TYPE) IS

Line 14: cp_cal_type IGS_CA_TYPE.cal_type%TYPE) IS

10: -- Validate IGS_CA_TYPE.s_cal_cat. If IGS_CA_TYPE.s_cal_cat = ?HOLIDAY?, then
11: -- offset constraints cannot be defined.
12: DECLARE
13: CURSOR c_ct(
14: cp_cal_type IGS_CA_TYPE.cal_type%TYPE) IS
15: SELECT s_cal_cat
16: FROM IGS_CA_TYPE
17: WHERE cal_type = cp_cal_type;
18: v_ct_rec c_ct%ROWTYPE;

Line 16: FROM IGS_CA_TYPE

12: DECLARE
13: CURSOR c_ct(
14: cp_cal_type IGS_CA_TYPE.cal_type%TYPE) IS
15: SELECT s_cal_cat
16: FROM IGS_CA_TYPE
17: WHERE cal_type = cp_cal_type;
18: v_ct_rec c_ct%ROWTYPE;
19: cst_holiday CONSTANT VARCHAR2(7) := 'HOLIDAY';
20: BEGIN

Line 27: -- Get the system calendar category of the IGS_CA_TYPE.

23: -- Check parameters
24: IF p_cal_type IS NULL THEN
25: RETURN TRUE;
26: END IF;
27: -- Get the system calendar category of the IGS_CA_TYPE.
28: OPEN c_ct (p_cal_type);
29: FETCH c_ct INTO v_ct_rec;
30: IF c_ct%NOTFOUND THEN
31: CLOSE c_ct;