APPS.IGS_CA_VAL_CIR dependencies on IGS_CA_TYPE

Line 28: -- To validate that the calendar has a IGS_CA_TYPE.s_cal_cat of type 'LOAD'

24: schodava 21-Jan-2002 Enh # 2187247
25: Modifies the FUNCTION calp_val_ci_rltnshp
26: ******************************************************************/
27:
28: -- To validate that the calendar has a IGS_CA_TYPE.s_cal_cat of type 'LOAD'
29: FUNCTION calp_val_cat_load( p_cal_type IN VARCHAR2 ,
30: p_message_name OUT NOCOPY VARCHAR2 )
31: RETURN BOOLEAN AS
32:

Line 37: cst_load CONSTANT IGS_CA_TYPE.s_cal_cat%TYPE := 'LOAD';

33: gv_other_detail VARCHAR2(255);
34:
35: BEGIN
36: DECLARE
37: cst_load CONSTANT IGS_CA_TYPE.s_cal_cat%TYPE := 'LOAD';
38: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;
39:
40: CURSOR c_cat IS
41: SELECT s_cal_cat

Line 38: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;

34:
35: BEGIN
36: DECLARE
37: cst_load CONSTANT IGS_CA_TYPE.s_cal_cat%TYPE := 'LOAD';
38: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;
39:
40: CURSOR c_cat IS
41: SELECT s_cal_cat
42: FROM igs_ca_type cat

Line 42: FROM igs_ca_type cat

38: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;
39:
40: CURSOR c_cat IS
41: SELECT s_cal_cat
42: FROM igs_ca_type cat
43: WHERE cat.cal_type = p_cal_type;
44:
45: BEGIN
46: OPEN c_cat;