200: p_message_name OUT NOCOPY VARCHAR2)
201: RETURN BOOLEAN AS
202:
203: BEGIN -- enrp_ins_csc_trnsfr
204: --This module inserts research IGS_RE_CAND_SEO_CLS details as a result of IGS_PS_COURSE
205: -- transfer. All Candidature research supervisor details
206: --(p_person_id/p_transfer_ca_sequence_number) are to be copied to the new
207: --Candidature (p_person_id/p_ca_sequence_number).
208: DECLARE
209: v_csc_exists VARCHAR2(1);
210: cst_enrp_ins_ca_trnsfr CONSTANT VARCHAR2(18) := 'ENRP_INS_CA_TRNSFR';
211: CURSOR c_csc IS
212: SELECT 'x'
213: FROM IGS_RE_CAND_SEO_CLS csc
214: WHERE csc.person_id = p_person_id AND
215: csc.ca_sequence_number = p_ca_sequence_number;
216: CURSOR c_csc1 IS
217: SELECT csc.seo_class_cd,
215: csc.ca_sequence_number = p_ca_sequence_number;
216: CURSOR c_csc1 IS
217: SELECT csc.seo_class_cd,
218: csc.percentage
219: FROM IGS_RE_CAND_SEO_CLS csc
220: WHERE csc.person_id = p_person_id AND
221: csc.ca_sequence_number = p_transfer_ca_sequence_number;
222: BEGIN
223: -- Set the default message number
246: BEGIN
247: DECLARE
248: l_rowid VARCHAR2(25);
249: BEGIN
250: IGS_RE_CAND_SEO_CLS_PKG.INSERT_ROW(
251: x_rowid => l_rowid,
252: x_person_id => p_person_id,
253: x_ca_sequence_number => p_ca_sequence_number,
254: x_seo_class_cd => v_csc1_rec.seo_class_cd,