APPS.IGS_AD_VAL_ACAI_FTR_OFFER dependencies on IGS_RE_CANDIDATURE

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

48: *******************************************************************************/
49:
50: l_get_modified_comm_dt DATE;
51:
52: CURSOR c_get_candidature (cp_person_id igs_re_candidature.person_id%TYPE,
53: cp_acai_admission_appl_number igs_re_candidature.acai_admission_appl_number%TYPE,
54: cp_acai_nominated_course_cd igs_re_candidature.acai_nominated_course_cd%TYPE,
55: cp_acai_sequence_number igs_re_candidature.acai_sequence_number%TYPE) IS
56: SELECT *

Line 53: cp_acai_admission_appl_number igs_re_candidature.acai_admission_appl_number%TYPE,

49:
50: l_get_modified_comm_dt DATE;
51:
52: CURSOR c_get_candidature (cp_person_id igs_re_candidature.person_id%TYPE,
53: cp_acai_admission_appl_number igs_re_candidature.acai_admission_appl_number%TYPE,
54: cp_acai_nominated_course_cd igs_re_candidature.acai_nominated_course_cd%TYPE,
55: cp_acai_sequence_number igs_re_candidature.acai_sequence_number%TYPE) IS
56: SELECT *
57: FROM igs_re_candidature

Line 54: cp_acai_nominated_course_cd igs_re_candidature.acai_nominated_course_cd%TYPE,

50: l_get_modified_comm_dt DATE;
51:
52: CURSOR c_get_candidature (cp_person_id igs_re_candidature.person_id%TYPE,
53: cp_acai_admission_appl_number igs_re_candidature.acai_admission_appl_number%TYPE,
54: cp_acai_nominated_course_cd igs_re_candidature.acai_nominated_course_cd%TYPE,
55: cp_acai_sequence_number igs_re_candidature.acai_sequence_number%TYPE) IS
56: SELECT *
57: FROM igs_re_candidature
58: WHERE person_id = cp_person_id

Line 55: cp_acai_sequence_number igs_re_candidature.acai_sequence_number%TYPE) IS

51:
52: CURSOR c_get_candidature (cp_person_id igs_re_candidature.person_id%TYPE,
53: cp_acai_admission_appl_number igs_re_candidature.acai_admission_appl_number%TYPE,
54: cp_acai_nominated_course_cd igs_re_candidature.acai_nominated_course_cd%TYPE,
55: cp_acai_sequence_number igs_re_candidature.acai_sequence_number%TYPE) IS
56: SELECT *
57: FROM igs_re_candidature
58: WHERE person_id = cp_person_id
59: AND acai_admission_appl_number = cp_acai_admission_appl_number

Line 57: FROM igs_re_candidature

53: cp_acai_admission_appl_number igs_re_candidature.acai_admission_appl_number%TYPE,
54: cp_acai_nominated_course_cd igs_re_candidature.acai_nominated_course_cd%TYPE,
55: cp_acai_sequence_number igs_re_candidature.acai_sequence_number%TYPE) IS
56: SELECT *
57: FROM igs_re_candidature
58: WHERE person_id = cp_person_id
59: AND acai_admission_appl_number = cp_acai_admission_appl_number
60: AND acai_nominated_course_cd = cp_acai_nominated_course_cd
61: AND acai_sequence_number = cp_acai_sequence_number;

Line 64: SELECT igs_re_candidature_seq_num_s.nextval

60: AND acai_nominated_course_cd = cp_acai_nominated_course_cd
61: AND acai_sequence_number = cp_acai_sequence_number;
62:
63: CURSOR c_get_candidature_sequence IS
64: SELECT igs_re_candidature_seq_num_s.nextval
65: FROM dual;
66:
67: l_get_candidature_sequence igs_re_candidature.sequence_number%TYPE;
68:

Line 67: l_get_candidature_sequence igs_re_candidature.sequence_number%TYPE;

63: CURSOR c_get_candidature_sequence IS
64: SELECT igs_re_candidature_seq_num_s.nextval
65: FROM dual;
66:
67: l_get_candidature_sequence igs_re_candidature.sequence_number%TYPE;
68:
69: CURSOR c_get_thesis (cp_person_id igs_re_thesis_all.person_id%TYPE,
70: cp_ca_sequence_number igs_re_thesis_all.ca_sequence_number%TYPE) IS
71: SELECT *

Line 144: l_min_submission_dt igs_re_candidature.min_submission_dt%TYPE;

140: l_rowid_child1 VARCHAR2(30);
141: l_rowid_child2 VARCHAR2(30);
142: l_rowid_child3 VARCHAR2(30);
143:
144: l_min_submission_dt igs_re_candidature.min_submission_dt%TYPE;
145: l_max_submission_dt igs_re_candidature.max_submission_dt%TYPE;
146:
147: l_supvsr_start_dt igs_re_sprvsr.start_dt%TYPE;
148: l_supvsr_end_dt igs_re_sprvsr.end_dt%TYPE;

Line 145: l_max_submission_dt igs_re_candidature.max_submission_dt%TYPE;

141: l_rowid_child2 VARCHAR2(30);
142: l_rowid_child3 VARCHAR2(30);
143:
144: l_min_submission_dt igs_re_candidature.min_submission_dt%TYPE;
145: l_max_submission_dt igs_re_candidature.max_submission_dt%TYPE;
146:
147: l_supvsr_start_dt igs_re_sprvsr.start_dt%TYPE;
148: l_supvsr_end_dt igs_re_sprvsr.end_dt%TYPE;
149: l_comm_date_offset NUMBER;

Line 193: IGS_RE_CANDIDATURE_PKG.INSERT_ROW(

189: CLOSE c_get_candidature_sequence;
190:
191: l_rowid := NULL;
192:
193: IGS_RE_CANDIDATURE_PKG.INSERT_ROW(
194: X_ROWID => l_rowid,
195: X_PERSON_ID => p_person_id,
196: X_SEQUENCE_NUMBER => l_get_candidature_sequence,
197: X_SCA_COURSE_CD => l_get_candidature_rec.sca_course_cd,