APPS.IGS_AD_INT_RECONSIDER dependencies on IGS_RE_CANDIDATURE

Line 30: CURSOR c_get_candidature (cp_person_id igs_re_candidature.person_id%TYPE,

26: *******************************************************************************/
27:
28: l_get_modified_comm_dt DATE;
29:
30: CURSOR c_get_candidature (cp_person_id igs_re_candidature.person_id%TYPE,
31: cp_acai_admission_appl_number igs_re_candidature.acai_admission_appl_number%TYPE,
32: cp_acai_nominated_course_cd igs_re_candidature.acai_nominated_course_cd%TYPE,
33: cp_acai_sequence_number igs_re_candidature.acai_sequence_number%TYPE) IS
34: SELECT *

Line 31: cp_acai_admission_appl_number igs_re_candidature.acai_admission_appl_number%TYPE,

27:
28: l_get_modified_comm_dt DATE;
29:
30: CURSOR c_get_candidature (cp_person_id igs_re_candidature.person_id%TYPE,
31: cp_acai_admission_appl_number igs_re_candidature.acai_admission_appl_number%TYPE,
32: cp_acai_nominated_course_cd igs_re_candidature.acai_nominated_course_cd%TYPE,
33: cp_acai_sequence_number igs_re_candidature.acai_sequence_number%TYPE) IS
34: SELECT *
35: FROM igs_re_candidature

Line 32: cp_acai_nominated_course_cd igs_re_candidature.acai_nominated_course_cd%TYPE,

28: l_get_modified_comm_dt DATE;
29:
30: CURSOR c_get_candidature (cp_person_id igs_re_candidature.person_id%TYPE,
31: cp_acai_admission_appl_number igs_re_candidature.acai_admission_appl_number%TYPE,
32: cp_acai_nominated_course_cd igs_re_candidature.acai_nominated_course_cd%TYPE,
33: cp_acai_sequence_number igs_re_candidature.acai_sequence_number%TYPE) IS
34: SELECT *
35: FROM igs_re_candidature
36: WHERE person_id = cp_person_id

Line 33: cp_acai_sequence_number igs_re_candidature.acai_sequence_number%TYPE) IS

29:
30: CURSOR c_get_candidature (cp_person_id igs_re_candidature.person_id%TYPE,
31: cp_acai_admission_appl_number igs_re_candidature.acai_admission_appl_number%TYPE,
32: cp_acai_nominated_course_cd igs_re_candidature.acai_nominated_course_cd%TYPE,
33: cp_acai_sequence_number igs_re_candidature.acai_sequence_number%TYPE) IS
34: SELECT *
35: FROM igs_re_candidature
36: WHERE person_id = cp_person_id
37: AND acai_admission_appl_number = cp_acai_admission_appl_number

Line 35: FROM igs_re_candidature

31: cp_acai_admission_appl_number igs_re_candidature.acai_admission_appl_number%TYPE,
32: cp_acai_nominated_course_cd igs_re_candidature.acai_nominated_course_cd%TYPE,
33: cp_acai_sequence_number igs_re_candidature.acai_sequence_number%TYPE) IS
34: SELECT *
35: FROM igs_re_candidature
36: WHERE person_id = cp_person_id
37: AND acai_admission_appl_number = cp_acai_admission_appl_number
38: AND acai_nominated_course_cd = cp_acai_nominated_course_cd
39: AND acai_sequence_number = cp_acai_sequence_number;

Line 42: SELECT igs_re_candidature_seq_num_s.nextval

38: AND acai_nominated_course_cd = cp_acai_nominated_course_cd
39: AND acai_sequence_number = cp_acai_sequence_number;
40:
41: CURSOR c_get_candidature_sequence IS
42: SELECT igs_re_candidature_seq_num_s.nextval
43: FROM dual;
44:
45: l_get_candidature_sequence igs_re_candidature.sequence_number%TYPE;
46:

Line 45: l_get_candidature_sequence igs_re_candidature.sequence_number%TYPE;

41: CURSOR c_get_candidature_sequence IS
42: SELECT igs_re_candidature_seq_num_s.nextval
43: FROM dual;
44:
45: l_get_candidature_sequence igs_re_candidature.sequence_number%TYPE;
46:
47: CURSOR c_get_thesis (cp_person_id igs_re_thesis_all.person_id%TYPE,
48: cp_ca_sequence_number igs_re_thesis_all.ca_sequence_number%TYPE) IS
49: SELECT *

Line 122: l_min_submission_dt igs_re_candidature.min_submission_dt%TYPE;

118: l_rowid_child1 VARCHAR2(30);
119: l_rowid_child2 VARCHAR2(30);
120: l_rowid_child3 VARCHAR2(30);
121:
122: l_min_submission_dt igs_re_candidature.min_submission_dt%TYPE;
123: l_max_submission_dt igs_re_candidature.max_submission_dt%TYPE;
124:
125: l_supvsr_start_dt igs_re_sprvsr.start_dt%TYPE;
126: l_supvsr_end_dt igs_re_sprvsr.end_dt%TYPE;

Line 123: l_max_submission_dt igs_re_candidature.max_submission_dt%TYPE;

119: l_rowid_child2 VARCHAR2(30);
120: l_rowid_child3 VARCHAR2(30);
121:
122: l_min_submission_dt igs_re_candidature.min_submission_dt%TYPE;
123: l_max_submission_dt igs_re_candidature.max_submission_dt%TYPE;
124:
125: l_supvsr_start_dt igs_re_sprvsr.start_dt%TYPE;
126: l_supvsr_end_dt igs_re_sprvsr.end_dt%TYPE;
127: l_comm_date_offset NUMBER;

Line 171: IGS_RE_CANDIDATURE_PKG.INSERT_ROW(

167: CLOSE c_get_candidature_sequence;
168:
169: l_rowid := NULL;
170:
171: IGS_RE_CANDIDATURE_PKG.INSERT_ROW(
172: X_ROWID => l_rowid,
173: X_PERSON_ID => p_person_id,
174: X_SEQUENCE_NUMBER => l_get_candidature_sequence,
175: X_SCA_COURSE_CD => l_get_candidature_rec.sca_course_cd,