APPS.IGS_AD_INT_RECONSIDER dependencies on IGS_RE_CDT_FLD_OF_SY

Line 60: CURSOR c_get_cdt_fld_of_sy (cp_person_id igs_re_cdt_fld_of_sy.person_id%TYPE,

56: FROM dual;
57:
58: l_get_thesis_sequence igs_re_thesis_all.sequence_number%TYPE;
59:
60: CURSOR c_get_cdt_fld_of_sy (cp_person_id igs_re_cdt_fld_of_sy.person_id%TYPE,
61: cp_ca_sequence_number igs_re_cdt_fld_of_sy.ca_sequence_number%TYPE) IS
62: SELECT *
63: FROM igs_re_cdt_fld_of_sy
64: WHERE person_id = cp_person_id

Line 61: cp_ca_sequence_number igs_re_cdt_fld_of_sy.ca_sequence_number%TYPE) IS

57:
58: l_get_thesis_sequence igs_re_thesis_all.sequence_number%TYPE;
59:
60: CURSOR c_get_cdt_fld_of_sy (cp_person_id igs_re_cdt_fld_of_sy.person_id%TYPE,
61: cp_ca_sequence_number igs_re_cdt_fld_of_sy.ca_sequence_number%TYPE) IS
62: SELECT *
63: FROM igs_re_cdt_fld_of_sy
64: WHERE person_id = cp_person_id
65: AND ca_sequence_number = cp_ca_sequence_number;

Line 63: FROM igs_re_cdt_fld_of_sy

59:
60: CURSOR c_get_cdt_fld_of_sy (cp_person_id igs_re_cdt_fld_of_sy.person_id%TYPE,
61: cp_ca_sequence_number igs_re_cdt_fld_of_sy.ca_sequence_number%TYPE) IS
62: SELECT *
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,

Line 292: IGS_RE_CDT_FLD_OF_SY_PKG.INSERT_ROW(

288: v_message_name:= 'IGS_AD_RSCH_CAND_FOS';
289:
290: l_rowid_child1 := NULL;
291:
292: IGS_RE_CDT_FLD_OF_SY_PKG.INSERT_ROW(
293: X_ROWID => l_rowid_child1,
294: X_PERSON_ID => p_person_id,
295: X_CA_SEQUENCE_NUMBER => l_get_candidature_sequence,
296: X_FIELD_OF_STUDY => l_get_cdt_fld_of_sy_rec.field_of_study,