APPS.IGS_AS_VAL_EVSA dependencies on IGS_CA_INST

Line 52: p_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,

48: END assp_val_evsa_del;
49: --
50: -- To validate the calendar instance system cal status is not 'INACTIVE'
51: FUNCTION ASSP_VAL_CI_STATUS(
52: p_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
53: p_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
54: p_message_name OUT NOCOPY varchar2 )
55: RETURN boolean IS
56: gv_other_detail VARCHAR2(255);

Line 53: p_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,

49: --
50: -- To validate the calendar instance system cal status is not 'INACTIVE'
51: FUNCTION ASSP_VAL_CI_STATUS(
52: p_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
53: p_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
54: p_message_name OUT NOCOPY varchar2 )
55: RETURN boolean IS
56: gv_other_detail VARCHAR2(255);
57: BEGIN -- assp_val_ci_status

Line 62: CURSOR c_cics (cp_cal_type IGS_CA_INST.cal_type%TYPE,

58: -- Validate the ci s_cal_status
59: DECLARE
60: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
61: v_ret_val BOOLEAN DEFAULT TRUE;
62: CURSOR c_cics (cp_cal_type IGS_CA_INST.cal_type%TYPE,
63: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
64: SELECT s_cal_status
65: FROM IGS_CA_STAT cs,
66: IGS_CA_INST ci

Line 63: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

59: DECLARE
60: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
61: v_ret_val BOOLEAN DEFAULT TRUE;
62: CURSOR c_cics (cp_cal_type IGS_CA_INST.cal_type%TYPE,
63: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
64: SELECT s_cal_status
65: FROM IGS_CA_STAT cs,
66: IGS_CA_INST ci
67: WHERE cs.cal_status = ci.cal_status AND

Line 66: IGS_CA_INST ci

62: CURSOR c_cics (cp_cal_type IGS_CA_INST.cal_type%TYPE,
63: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
64: SELECT s_cal_status
65: FROM IGS_CA_STAT cs,
66: IGS_CA_INST ci
67: WHERE cs.cal_status = ci.cal_status AND
68: ci.sequence_number = cp_sequence_number AND
69: ci.cal_type = cp_cal_type;
70: BEGIN