APPS.IGS_EN_VAL_DLA dependencies on IGS_CA_STAT

Line 13: cst_active IGS_CA_STAT.s_cal_status%TYPE DEFAULT 'ACTIVE';

9: RETURN BOOLEAN AS
10:
11: BEGIN
12: DECLARE
13: cst_active IGS_CA_STAT.s_cal_status%TYPE DEFAULT 'ACTIVE';
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,

Line 14: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;

10:
11: BEGIN
12: DECLARE
13: cst_active IGS_CA_STAT.s_cal_status%TYPE DEFAULT 'ACTIVE';
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

Line 17: FROM IGS_CA_STAT cs,

13: cst_active IGS_CA_STAT.s_cal_status%TYPE DEFAULT 'ACTIVE';
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;

Line 52: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;

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
56: WHERE cal_type = p_cal_type AND

Line 58: CURSOR c_cs (cp_cal_status IGS_CA_STAT.cal_status%TYPE) 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
60: FROM IGS_CA_STAT
61: WHERE cal_status = cp_cal_status;
62: BEGIN

Line 60: FROM IGS_CA_STAT

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
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.