APPS.IGS_CA_VAL_CI dependencies on IGS_CA_STAT

Line 17: --This module Validates if IGS_CA_STAT.cal_status is closed

13: p_message_name OUT NOCOPY VARCHAR2 )
14: RETURN BOOLEAN AS
15: gv_other_detail VARCHAR2(255);
16: BEGIN --calp_val_cs_closed
17: --This module Validates if IGS_CA_STAT.cal_status is closed
18: DECLARE
19: v_cs_exists VARCHAR2(1);
20: CURSOR c_cs IS
21: SELECT 'X'

Line 22: FROM IGS_CA_STAT cs

18: DECLARE
19: v_cs_exists VARCHAR2(1);
20: CURSOR c_cs IS
21: SELECT 'X'
22: FROM IGS_CA_STAT cs
23: WHERE cs.cal_status = p_cal_status AND
24: cs.closed_ind = 'Y';
25: BEGIN
26: --Set the default message number

Line 129: v_new_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;

125: v_other_detail VARCHAR2(255);
126: v_cal_instance_rec IGS_CA_INST%ROWTYPE;
127: v_cal_instance_rltshp_rec IGS_CA_INST_REL%ROWTYPE;
128: v_dt_alias_instance_rec IGS_CA_DA_INST_V%ROWTYPE;
129: v_new_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
130: v_old_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
131: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
132: -- define cursors
133: CURSOR c_cal_status(cp_cal_status IGS_CA_STAT.cal_status%TYPE)

Line 130: v_old_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;

126: v_cal_instance_rec IGS_CA_INST%ROWTYPE;
127: v_cal_instance_rltshp_rec IGS_CA_INST_REL%ROWTYPE;
128: v_dt_alias_instance_rec IGS_CA_DA_INST_V%ROWTYPE;
129: v_new_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
130: v_old_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
131: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
132: -- define cursors
133: CURSOR c_cal_status(cp_cal_status IGS_CA_STAT.cal_status%TYPE)
134: IS

Line 131: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;

127: v_cal_instance_rltshp_rec IGS_CA_INST_REL%ROWTYPE;
128: v_dt_alias_instance_rec IGS_CA_DA_INST_V%ROWTYPE;
129: v_new_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
130: v_old_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
131: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
132: -- define cursors
133: CURSOR c_cal_status(cp_cal_status IGS_CA_STAT.cal_status%TYPE)
134: IS
135: SELECT *

Line 133: CURSOR c_cal_status(cp_cal_status IGS_CA_STAT.cal_status%TYPE)

129: v_new_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
130: v_old_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
131: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
132: -- define cursors
133: CURSOR c_cal_status(cp_cal_status IGS_CA_STAT.cal_status%TYPE)
134: IS
135: SELECT *
136: FROM IGS_CA_STAT
137: WHERE cal_status = cp_cal_status;

Line 136: FROM IGS_CA_STAT

132: -- define cursors
133: CURSOR c_cal_status(cp_cal_status IGS_CA_STAT.cal_status%TYPE)
134: IS
135: SELECT *
136: FROM IGS_CA_STAT
137: WHERE cal_status = cp_cal_status;
138: CURSOR c_cir_subord_calendars
139: IS
140: SELECT *

Line 284: p_message_name :='IGS_CA_STATUS_NOTCHG_ACTIVE';

280: EXIT WHEN
281: c_dt_alias_instance%NOTFOUND;
282: IF (v_dt_alias_instance_rec.alias_val IS NULL) THEN
283: CLOSE c_dt_alias_instance;
284: p_message_name :='IGS_CA_STATUS_NOTCHG_ACTIVE';
285: RETURN FALSE;
286: END IF;
287: END LOOP;
288: IF (c_dt_alias_instance%ISOPEN) THEN