APPS.IGS_EN_VAL_DLA dependencies on IGS_CA_INST

Line 18: IGS_CA_INST ci

14: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
15: CURSOR c_chk_scc IS
16: SELECT s_cal_status
17: FROM IGS_CA_STAT cs,
18: IGS_CA_INST ci
19: WHERE ci.cal_type = p_cal_type AND
20: ci.sequence_number = p_ci_sequence_number AND
21: cs.cal_status = ci.cal_status;
22: BEGIN

Line 51: v_cal_status IGS_CA_INST.cal_status%TYPE;

47: RETURN BOOLEAN AS
48:
49: BEGIN
50: DECLARE
51: v_cal_status IGS_CA_INST.cal_status%TYPE;
52: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
53: CURSOR c_ci IS
54: SELECT cal_status
55: FROM IGS_CA_INST

Line 55: FROM IGS_CA_INST

51: v_cal_status IGS_CA_INST.cal_status%TYPE;
52: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
53: CURSOR c_ci IS
54: SELECT cal_status
55: FROM IGS_CA_INST
56: WHERE cal_type = p_cal_type AND
57: sequence_number = p_ci_sequence;
58: CURSOR c_cs (cp_cal_status IGS_CA_STAT.cal_status%TYPE) IS
59: SELECT s_cal_status

Line 63: -- This function validates the IGS_CA_INST calendar status

59: SELECT s_cal_status
60: FROM IGS_CA_STAT
61: WHERE cal_status = cp_cal_status;
62: BEGIN
63: -- This function validates the IGS_CA_INST calendar status
64: -- for a IGS_ST_DFT_LOAD_APPO record being inserted.
65: --- Set the default message number
66: p_message_name := null;
67: OPEN c_ci;