APPS.IGS_CA_VAL_CIR dependencies on IGS_CA_INST

Line 81: v_cal_inst_rltshp_sup_rec IGS_CA_INST_REL%ROWTYPE;

77:
78: cst_planned CONSTANT VARCHAR2(8) := 'PLANNED';
79: cst_active CONSTANT VARCHAR2(8) := 'ACTIVE';
80: cst_inactive CONSTANT VARCHAR2(8) := 'INACTIVE';
81: v_cal_inst_rltshp_sup_rec IGS_CA_INST_REL%ROWTYPE;
82: v_cal_inst_rltshp_sub_rec IGS_CA_INST_REL%ROWTYPE;
83: e_superior_not_found EXCEPTION;
84: e_subordinate_not_found EXCEPTION;
85: v_superior_found BOOLEAN := FALSE;

Line 82: v_cal_inst_rltshp_sub_rec IGS_CA_INST_REL%ROWTYPE;

78: cst_planned CONSTANT VARCHAR2(8) := 'PLANNED';
79: cst_active CONSTANT VARCHAR2(8) := 'ACTIVE';
80: cst_inactive CONSTANT VARCHAR2(8) := 'INACTIVE';
81: v_cal_inst_rltshp_sup_rec IGS_CA_INST_REL%ROWTYPE;
82: v_cal_inst_rltshp_sub_rec IGS_CA_INST_REL%ROWTYPE;
83: e_superior_not_found EXCEPTION;
84: e_subordinate_not_found EXCEPTION;
85: v_superior_found BOOLEAN := FALSE;
86: v_subordinate_found BOOLEAN := FALSE;

Line 93: FROM igs_ca_inst_rel

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
94: WHERE sub_cal_type = p_sub_cal_type
95: AND sub_ci_sequence_number = p_sub_ci_sequence_number
96: AND (sup_cal_type <> p_sup_cal_type)
97: AND (sup_ci_sequence_number <> p_sup_ci_sequence_number);

Line 101: FROM igs_ca_inst_rel

97: AND (sup_ci_sequence_number <> p_sup_ci_sequence_number);
98:
99: CURSOR c_cal_inst_rltshp_sub IS
100: SELECT *
101: FROM igs_ca_inst_rel
102: WHERE sup_cal_type = p_sup_cal_type
103: AND sup_ci_sequence_number = p_sup_ci_sequence_number
104: AND (sub_cal_type <> p_sub_cal_type)
105: AND (sub_ci_sequence_number <> p_sub_ci_sequence_number);

Line 107: CURSOR c_cal_instance ( cp_cal_type igs_ca_inst.cal_type%TYPE,

103: AND sup_ci_sequence_number = p_sup_ci_sequence_number
104: AND (sub_cal_type <> p_sub_cal_type)
105: AND (sub_ci_sequence_number <> p_sub_ci_sequence_number);
106:
107: CURSOR c_cal_instance ( cp_cal_type igs_ca_inst.cal_type%TYPE,
108: cp_cal_sequence_number igs_ca_inst.sequence_number%TYPE) IS
109: SELECT *
110: FROM igs_ca_inst
111: WHERE cal_type = cp_cal_type

Line 108: cp_cal_sequence_number igs_ca_inst.sequence_number%TYPE) IS

104: AND (sub_cal_type <> p_sub_cal_type)
105: AND (sub_ci_sequence_number <> p_sub_ci_sequence_number);
106:
107: CURSOR c_cal_instance ( cp_cal_type igs_ca_inst.cal_type%TYPE,
108: cp_cal_sequence_number igs_ca_inst.sequence_number%TYPE) IS
109: SELECT *
110: FROM igs_ca_inst
111: WHERE cal_type = cp_cal_type
112: AND sequence_number = cp_cal_sequence_number ;

Line 110: FROM igs_ca_inst

106:
107: CURSOR c_cal_instance ( cp_cal_type igs_ca_inst.cal_type%TYPE,
108: cp_cal_sequence_number igs_ca_inst.sequence_number%TYPE) IS
109: SELECT *
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

Line 119: FUNCTION calp_find_superior( p_sup_cal_type igs_ca_inst_rel.sup_cal_type%TYPE,

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,
121: p_sub_cal_type igs_ca_inst_rel.sub_cal_type%TYPE,
122: p_sub_ci_sequence_number igs_ca_inst_rel.sub_ci_sequence_number%TYPE)
123: RETURN BOOLEAN AS

Line 120: p_sup_ci_sequence_number igs_ca_inst_rel.sup_ci_sequence_number%TYPE,

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,
121: p_sub_cal_type igs_ca_inst_rel.sub_cal_type%TYPE,
122: p_sub_ci_sequence_number igs_ca_inst_rel.sub_ci_sequence_number%TYPE)
123: RETURN BOOLEAN AS
124:

Line 121: p_sub_cal_type igs_ca_inst_rel.sub_cal_type%TYPE,

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,
121: p_sub_cal_type igs_ca_inst_rel.sub_cal_type%TYPE,
122: p_sub_ci_sequence_number igs_ca_inst_rel.sub_ci_sequence_number%TYPE)
123: RETURN BOOLEAN AS
124:
125: v_cal_inst_rltshp_sup_rec igs_ca_inst_rel%ROWTYPE;

Line 122: p_sub_ci_sequence_number igs_ca_inst_rel.sub_ci_sequence_number%TYPE)

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,
121: p_sub_cal_type igs_ca_inst_rel.sub_cal_type%TYPE,
122: p_sub_ci_sequence_number igs_ca_inst_rel.sub_ci_sequence_number%TYPE)
123: RETURN BOOLEAN AS
124:
125: v_cal_inst_rltshp_sup_rec igs_ca_inst_rel%ROWTYPE;
126:

Line 125: v_cal_inst_rltshp_sup_rec igs_ca_inst_rel%ROWTYPE;

121: p_sub_cal_type igs_ca_inst_rel.sub_cal_type%TYPE,
122: p_sub_ci_sequence_number igs_ca_inst_rel.sub_ci_sequence_number%TYPE)
123: RETURN BOOLEAN AS
124:
125: v_cal_inst_rltshp_sup_rec igs_ca_inst_rel%ROWTYPE;
126:
127: CURSOR c_cal_inst_rltshp_sup( cp_sup_cal_type igs_ca_inst_rel.sup_cal_type%TYPE,
128: cp_sup_ci_sequence_number igs_ca_inst_rel.sup_ci_sequence_number%TYPE) IS
129: SELECT *

Line 127: CURSOR c_cal_inst_rltshp_sup( cp_sup_cal_type igs_ca_inst_rel.sup_cal_type%TYPE,

123: RETURN BOOLEAN AS
124:
125: v_cal_inst_rltshp_sup_rec igs_ca_inst_rel%ROWTYPE;
126:
127: CURSOR c_cal_inst_rltshp_sup( cp_sup_cal_type igs_ca_inst_rel.sup_cal_type%TYPE,
128: cp_sup_ci_sequence_number igs_ca_inst_rel.sup_ci_sequence_number%TYPE) IS
129: SELECT *
130: FROM igs_ca_inst_rel
131: WHERE sub_cal_type = cp_sup_cal_type

Line 128: cp_sup_ci_sequence_number igs_ca_inst_rel.sup_ci_sequence_number%TYPE) IS

124:
125: v_cal_inst_rltshp_sup_rec igs_ca_inst_rel%ROWTYPE;
126:
127: CURSOR c_cal_inst_rltshp_sup( cp_sup_cal_type igs_ca_inst_rel.sup_cal_type%TYPE,
128: cp_sup_ci_sequence_number igs_ca_inst_rel.sup_ci_sequence_number%TYPE) IS
129: SELECT *
130: FROM igs_ca_inst_rel
131: WHERE sub_cal_type = cp_sup_cal_type
132: AND sub_ci_sequence_number = cp_sup_ci_sequence_number;

Line 130: FROM igs_ca_inst_rel

126:
127: CURSOR c_cal_inst_rltshp_sup( cp_sup_cal_type igs_ca_inst_rel.sup_cal_type%TYPE,
128: cp_sup_ci_sequence_number igs_ca_inst_rel.sup_ci_sequence_number%TYPE) IS
129: SELECT *
130: FROM igs_ca_inst_rel
131: WHERE sub_cal_type = cp_sup_cal_type
132: AND sub_ci_sequence_number = cp_sup_ci_sequence_number;
133:
134: BEGIN

Line 167: FUNCTION calp_find_subordinate( p_sub_cal_type igs_ca_inst_rel.sub_cal_type%TYPE,

163: RETURN FALSE;
164:
165: END calp_find_superior;
166:
167: FUNCTION calp_find_subordinate( p_sub_cal_type igs_ca_inst_rel.sub_cal_type%TYPE,
168: p_sub_ci_sequence_number igs_ca_inst_rel.sub_ci_sequence_number%TYPE,
169: p_sup_cal_type igs_ca_inst_rel.sup_cal_type%TYPE,
170: p_sup_ci_sequence_number igs_ca_inst_rel.sup_ci_sequence_number%TYPE)
171: --simran perf

Line 168: p_sub_ci_sequence_number igs_ca_inst_rel.sub_ci_sequence_number%TYPE,

164:
165: END calp_find_superior;
166:
167: FUNCTION calp_find_subordinate( p_sub_cal_type igs_ca_inst_rel.sub_cal_type%TYPE,
168: p_sub_ci_sequence_number igs_ca_inst_rel.sub_ci_sequence_number%TYPE,
169: p_sup_cal_type igs_ca_inst_rel.sup_cal_type%TYPE,
170: p_sup_ci_sequence_number igs_ca_inst_rel.sup_ci_sequence_number%TYPE)
171: --simran perf
172: --)

Line 169: p_sup_cal_type igs_ca_inst_rel.sup_cal_type%TYPE,

165: END calp_find_superior;
166:
167: FUNCTION calp_find_subordinate( p_sub_cal_type igs_ca_inst_rel.sub_cal_type%TYPE,
168: p_sub_ci_sequence_number igs_ca_inst_rel.sub_ci_sequence_number%TYPE,
169: p_sup_cal_type igs_ca_inst_rel.sup_cal_type%TYPE,
170: p_sup_ci_sequence_number igs_ca_inst_rel.sup_ci_sequence_number%TYPE)
171: --simran perf
172: --)
173: RETURN BOOLEAN AS

Line 170: p_sup_ci_sequence_number igs_ca_inst_rel.sup_ci_sequence_number%TYPE)

166:
167: FUNCTION calp_find_subordinate( p_sub_cal_type igs_ca_inst_rel.sub_cal_type%TYPE,
168: p_sub_ci_sequence_number igs_ca_inst_rel.sub_ci_sequence_number%TYPE,
169: p_sup_cal_type igs_ca_inst_rel.sup_cal_type%TYPE,
170: p_sup_ci_sequence_number igs_ca_inst_rel.sup_ci_sequence_number%TYPE)
171: --simran perf
172: --)
173: RETURN BOOLEAN AS
174:

Line 175: v_cal_inst_rltshp_sub_rec igs_ca_inst_rel%ROWTYPE;

171: --simran perf
172: --)
173: RETURN BOOLEAN AS
174:
175: v_cal_inst_rltshp_sub_rec igs_ca_inst_rel%ROWTYPE;
176:
177: CURSOR c_cal_inst_rltshp_sub( cp_sub_cal_type igs_ca_inst_rel.sub_cal_type%TYPE,
178: cp_sub_ci_sequence_number igs_ca_inst_rel.sub_ci_sequence_number%TYPE) IS
179: ----simran perf

Line 177: CURSOR c_cal_inst_rltshp_sub( cp_sub_cal_type igs_ca_inst_rel.sub_cal_type%TYPE,

173: RETURN BOOLEAN AS
174:
175: v_cal_inst_rltshp_sub_rec igs_ca_inst_rel%ROWTYPE;
176:
177: CURSOR c_cal_inst_rltshp_sub( cp_sub_cal_type igs_ca_inst_rel.sub_cal_type%TYPE,
178: cp_sub_ci_sequence_number igs_ca_inst_rel.sub_ci_sequence_number%TYPE) IS
179: ----simran perf
180: SELECT *
181: FROM igs_ca_inst_rel

Line 178: cp_sub_ci_sequence_number igs_ca_inst_rel.sub_ci_sequence_number%TYPE) IS

174:
175: v_cal_inst_rltshp_sub_rec igs_ca_inst_rel%ROWTYPE;
176:
177: CURSOR c_cal_inst_rltshp_sub( cp_sub_cal_type igs_ca_inst_rel.sub_cal_type%TYPE,
178: cp_sub_ci_sequence_number igs_ca_inst_rel.sub_ci_sequence_number%TYPE) IS
179: ----simran perf
180: SELECT *
181: FROM igs_ca_inst_rel
182: WHERE sup_cal_type = cp_sub_cal_type

Line 181: FROM igs_ca_inst_rel

177: CURSOR c_cal_inst_rltshp_sub( cp_sub_cal_type igs_ca_inst_rel.sub_cal_type%TYPE,
178: cp_sub_ci_sequence_number igs_ca_inst_rel.sub_ci_sequence_number%TYPE) IS
179: ----simran perf
180: SELECT *
181: FROM igs_ca_inst_rel
182: WHERE sup_cal_type = cp_sub_cal_type
183: AND sup_ci_sequence_number = cp_sub_ci_sequence_number; --simran perf --this was missing.
184: --due to which it was FTS on ca_inst_rel and doing recursive FTS as this func is recursive.
185: