85: FROM igs_re_cdt_fld_of_sy
86: WHERE person_id = cp_person_id
87: AND ca_sequence_number = cp_ca_sequence_number;
88:
89: CURSOR c_get_cand_seo_cls (cp_person_id igs_re_cand_seo_cls.person_id%TYPE,
90: cp_ca_sequence_number igs_re_cand_seo_cls.ca_sequence_number%TYPE) IS
91: SELECT *
92: FROM igs_re_cand_seo_cls
93: WHERE person_id = cp_person_id
86: WHERE person_id = cp_person_id
87: AND ca_sequence_number = cp_ca_sequence_number;
88:
89: CURSOR c_get_cand_seo_cls (cp_person_id igs_re_cand_seo_cls.person_id%TYPE,
90: cp_ca_sequence_number igs_re_cand_seo_cls.ca_sequence_number%TYPE) IS
91: SELECT *
92: FROM igs_re_cand_seo_cls
93: WHERE person_id = cp_person_id
94: AND ca_sequence_number = cp_ca_sequence_number;
88:
89: CURSOR c_get_cand_seo_cls (cp_person_id igs_re_cand_seo_cls.person_id%TYPE,
90: cp_ca_sequence_number igs_re_cand_seo_cls.ca_sequence_number%TYPE) IS
91: SELECT *
92: FROM igs_re_cand_seo_cls
93: WHERE person_id = cp_person_id
94: AND ca_sequence_number = cp_ca_sequence_number;
95:
96: CURSOR c_get_scholarship (cp_person_id igs_re_scholarship_all.person_id%TYPE,
327: v_message_name:= 'IGS_AD_RSCH_SEO';
328:
329: l_rowid_child1 := NULL;
330:
331: IGS_RE_CAND_SEO_CLS_PKG.INSERT_ROW(
332: X_ROWID => l_rowid_child1,
333: X_PERSON_ID => p_person_id,
334: X_CA_SEQUENCE_NUMBER => l_get_candidature_sequence,
335: X_SEO_CLASS_CD => l_get_cand_seo_cls_rec.seo_class_cd,