APPS.IGS_OR_VAL_INS dependencies on IGS_OR_INST_STAT

Line 221: v_closed_ind IGS_OR_INST_STAT.closed_ind%TYPE;

217: p_message_name OUT NOCOPY VARCHAR2 )
218:
219: RETURN Boolean AS
220:
221: v_closed_ind IGS_OR_INST_STAT.closed_ind%TYPE;
222:
223: v_s_institution_status IGS_OR_INST_STAT.s_institution_status%TYPE;
224:
225: v_message_name VARCHAR2(30);

Line 223: v_s_institution_status IGS_OR_INST_STAT.s_institution_status%TYPE;

219: RETURN Boolean AS
220:
221: v_closed_ind IGS_OR_INST_STAT.closed_ind%TYPE;
222:
223: v_s_institution_status IGS_OR_INST_STAT.s_institution_status%TYPE;
224:
225: v_message_name VARCHAR2(30);
226:
227: v_other_detail VARCHAR2(255);

Line 239: FROM IGS_OR_INST_STAT

235: INTO v_closed_ind,
236:
237: v_s_institution_status
238:
239: FROM IGS_OR_INST_STAT
240:
241: WHERE institution_status = p_institution_status;
242:
243: -- Validate the closed indicator.

Line 331: p_message_name := 'IGS_OR_INST_STAT_CANT_CHANGED';

327: ELSE
328:
329: CLOSE c_ou;
330:
331: p_message_name := 'IGS_OR_INST_STAT_CANT_CHANGED';
332:
333: RETURN FALSE;
334:
335: END IF;