APPS.IGS_AD_INT_RECONSIDER dependencies on IGS_RE_CAND_SEO_CLS

Line 67: CURSOR c_get_cand_seo_cls (cp_person_id igs_re_cand_seo_cls.person_id%TYPE,

63: FROM igs_re_cdt_fld_of_sy
64: WHERE person_id = cp_person_id
65: AND ca_sequence_number = cp_ca_sequence_number;
66:
67: CURSOR c_get_cand_seo_cls (cp_person_id igs_re_cand_seo_cls.person_id%TYPE,
68: cp_ca_sequence_number igs_re_cand_seo_cls.ca_sequence_number%TYPE) IS
69: SELECT *
70: FROM igs_re_cand_seo_cls
71: WHERE person_id = cp_person_id

Line 68: cp_ca_sequence_number igs_re_cand_seo_cls.ca_sequence_number%TYPE) IS

64: WHERE person_id = cp_person_id
65: AND ca_sequence_number = cp_ca_sequence_number;
66:
67: CURSOR c_get_cand_seo_cls (cp_person_id igs_re_cand_seo_cls.person_id%TYPE,
68: cp_ca_sequence_number igs_re_cand_seo_cls.ca_sequence_number%TYPE) IS
69: SELECT *
70: FROM igs_re_cand_seo_cls
71: WHERE person_id = cp_person_id
72: AND ca_sequence_number = cp_ca_sequence_number;

Line 70: FROM igs_re_cand_seo_cls

66:
67: CURSOR c_get_cand_seo_cls (cp_person_id igs_re_cand_seo_cls.person_id%TYPE,
68: cp_ca_sequence_number igs_re_cand_seo_cls.ca_sequence_number%TYPE) IS
69: SELECT *
70: FROM igs_re_cand_seo_cls
71: WHERE person_id = cp_person_id
72: AND ca_sequence_number = cp_ca_sequence_number;
73:
74: CURSOR c_get_scholarship (cp_person_id igs_re_scholarship_all.person_id%TYPE,

Line 309: IGS_RE_CAND_SEO_CLS_PKG.INSERT_ROW(

305: v_message_name:= 'IGS_AD_RSCH_SEO';
306:
307: l_rowid_child1 := NULL;
308:
309: IGS_RE_CAND_SEO_CLS_PKG.INSERT_ROW(
310: X_ROWID => l_rowid_child1,
311: X_PERSON_ID => p_person_id,
312: X_CA_SEQUENCE_NUMBER => l_get_candidature_sequence,
313: X_SEO_CLASS_CD => l_get_cand_seo_cls_rec.seo_class_cd,