APPS.IGS_CA_VAL_CIR dependencies on IGS_CA_STAT

Line 88: v_sup_cal_status IGS_CA_STAT.s_cal_status%TYPE;

84: e_subordinate_not_found EXCEPTION;
85: v_superior_found BOOLEAN := FALSE;
86: v_subordinate_found BOOLEAN := FALSE;
87: v_other_detail VARCHAR2(255);
88: v_sup_cal_status IGS_CA_STAT.s_cal_status%TYPE;
89: v_sub_cal_status IGS_CA_STAT.s_cal_status%TYPE;
90:
91: CURSOR c_cal_inst_rltshp_sup IS
92: SELECT *

Line 89: v_sub_cal_status IGS_CA_STAT.s_cal_status%TYPE;

85: v_superior_found BOOLEAN := FALSE;
86: v_subordinate_found BOOLEAN := FALSE;
87: v_other_detail VARCHAR2(255);
88: v_sup_cal_status IGS_CA_STAT.s_cal_status%TYPE;
89: v_sub_cal_status IGS_CA_STAT.s_cal_status%TYPE;
90:
91: CURSOR c_cal_inst_rltshp_sup IS
92: SELECT *
93: FROM igs_ca_inst_rel

Line 114: CURSOR c_cal_status( cp_cal_status igs_ca_stat.cal_status%TYPE) IS

110: FROM igs_ca_inst
111: WHERE cal_type = cp_cal_type
112: AND sequence_number = cp_cal_sequence_number ;
113:
114: CURSOR c_cal_status( cp_cal_status igs_ca_stat.cal_status%TYPE) IS
115: SELECT *
116: FROM igs_ca_stat
117: WHERE cal_status = cp_cal_status;
118:

Line 116: FROM igs_ca_stat

112: AND sequence_number = cp_cal_sequence_number ;
113:
114: CURSOR c_cal_status( cp_cal_status igs_ca_stat.cal_status%TYPE) IS
115: SELECT *
116: FROM igs_ca_stat
117: WHERE cal_status = cp_cal_status;
118:
119: FUNCTION calp_find_superior( p_sup_cal_type igs_ca_inst_rel.sup_cal_type%TYPE,
120: p_sup_ci_sequence_number igs_ca_inst_rel.sup_ci_sequence_number%TYPE,