APPS.IGS_CA_VAL_DAIO dependencies on IGS_CA_STAT

Line 26: v_dt_alias_status IGS_CA_STAT.s_cal_status%TYPE;

22: cst_planned CONSTANT VARCHAR2(8) := 'PLANNED';
23: cst_active CONSTANT VARCHAR2(8) := 'ACTIVE';
24: v_other_detail VARCHAR(255);
25: v_alias_value DATE;
26: v_dt_alias_status IGS_CA_STAT.s_cal_status%TYPE;
27: v_offset_dt_alias_status IGS_CA_STAT.s_cal_status%TYPE;
28: CURSOR c_dt_alias_instance_offset (
29: cp_dt_alias IGS_CA_DA_INST_OFST.dt_alias%TYPE,
30: cp_dai_sequence_number IGS_CA_DA_INST_OFST.dai_sequence_number%TYPE,

Line 27: v_offset_dt_alias_status IGS_CA_STAT.s_cal_status%TYPE;

23: cst_active CONSTANT VARCHAR2(8) := 'ACTIVE';
24: v_other_detail VARCHAR(255);
25: v_alias_value DATE;
26: v_dt_alias_status IGS_CA_STAT.s_cal_status%TYPE;
27: v_offset_dt_alias_status IGS_CA_STAT.s_cal_status%TYPE;
28: CURSOR c_dt_alias_instance_offset (
29: cp_dt_alias IGS_CA_DA_INST_OFST.dt_alias%TYPE,
30: cp_dai_sequence_number IGS_CA_DA_INST_OFST.dai_sequence_number%TYPE,
31: cp_cal_type IGS_CA_DA_INST_OFST.cal_type%TYPE,

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

47: SELECT *
48: FROM IGS_CA_INST
49: WHERE cal_type = cp_cal_type and
50: sequence_number = cp_sequence_number;
51: CURSOR c_cal_status(cp_cal_status IGS_CA_STAT.cal_status%TYPE)
52: IS
53: SELECT *
54: FROM IGS_CA_STAT
55: WHERE cal_status = cp_cal_status;

Line 54: FROM IGS_CA_STAT

50: sequence_number = cp_sequence_number;
51: CURSOR c_cal_status(cp_cal_status IGS_CA_STAT.cal_status%TYPE)
52: IS
53: SELECT *
54: FROM IGS_CA_STAT
55: WHERE cal_status = cp_cal_status;
56: FUNCTION find_daio(
57: p_org_dt_alias_inst_ofst IGS_CA_DA_INST_OFST.dt_alias%TYPE,
58: p_org_dai_seq_number IGS_CA_DA_INST_OFST.dai_sequence_number%TYPE,

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

214: SELECT *
215: FROM IGS_CA_INST
216: WHERE cal_type = cp_cal_type and
217: sequence_number = cp_sequence_number;
218: CURSOR c_cal_status(cp_cal_status IGS_CA_STAT.cal_status%TYPE)
219: IS
220: SELECT *
221: FROM IGS_CA_STAT
222: WHERE cal_status = cp_cal_status;

Line 221: FROM IGS_CA_STAT

217: sequence_number = cp_sequence_number;
218: CURSOR c_cal_status(cp_cal_status IGS_CA_STAT.cal_status%TYPE)
219: IS
220: SELECT *
221: FROM IGS_CA_STAT
222: WHERE cal_status = cp_cal_status;
223: BEGIN
224: OPEN c_dt_alias_instance;
225: LOOP