DBA Data[Home] [Help]

APPS.IGS_HE_EXTRACT_FIELDS_PKG dependencies on IGS_HE_SUBMSN_AWD

Line 32: (type igs_he_submsn_awd.type%TYPE,

28: prop_in_welsh welsh_prop);
29:
30: -- Index Table to hold the award conferral dates for the submission
31: TYPE awd_defn IS RECORD
32: (type igs_he_submsn_awd.type%TYPE,
33: key1 igs_he_submsn_awd.key1%TYPE,
34: award_start_date igs_he_submsn_awd.award_start_date%TYPE,
35: award_end_date igs_he_submsn_awd.award_end_date%TYPE);
36:

Line 33: key1 igs_he_submsn_awd.key1%TYPE,

29:
30: -- Index Table to hold the award conferral dates for the submission
31: TYPE awd_defn IS RECORD
32: (type igs_he_submsn_awd.type%TYPE,
33: key1 igs_he_submsn_awd.key1%TYPE,
34: award_start_date igs_he_submsn_awd.award_start_date%TYPE,
35: award_end_date igs_he_submsn_awd.award_end_date%TYPE);
36:
37: TYPE awd_table IS TABLE of awd_defn

Line 34: award_start_date igs_he_submsn_awd.award_start_date%TYPE,

30: -- Index Table to hold the award conferral dates for the submission
31: TYPE awd_defn IS RECORD
32: (type igs_he_submsn_awd.type%TYPE,
33: key1 igs_he_submsn_awd.key1%TYPE,
34: award_start_date igs_he_submsn_awd.award_start_date%TYPE,
35: award_end_date igs_he_submsn_awd.award_end_date%TYPE);
36:
37: TYPE awd_table IS TABLE of awd_defn
38: INDEX BY binary_integer;

Line 35: award_end_date igs_he_submsn_awd.award_end_date%TYPE);

31: TYPE awd_defn IS RECORD
32: (type igs_he_submsn_awd.type%TYPE,
33: key1 igs_he_submsn_awd.key1%TYPE,
34: award_start_date igs_he_submsn_awd.award_start_date%TYPE,
35: award_end_date igs_he_submsn_awd.award_end_date%TYPE);
36:
37: TYPE awd_table IS TABLE of awd_defn
38: INDEX BY binary_integer;
39:

Line 192: p_min_start_dt OUT NOCOPY igs_he_submsn_awd.award_start_date%TYPE,

188: PROCEDURE get_min_max_awd_dates
189: (p_submission_name IN igs_he_submsn_header.submission_name%TYPE,
190: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
191: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
192: p_min_start_dt OUT NOCOPY igs_he_submsn_awd.award_start_date%TYPE,
193: p_max_start_dt OUT NOCOPY igs_he_submsn_awd.award_end_date%TYPE);
194:
195: PROCEDURE get_awd_dtls
196: (p_submission_name IN igs_he_submsn_awd.submission_name%TYPE,

Line 193: p_max_start_dt OUT NOCOPY igs_he_submsn_awd.award_end_date%TYPE);

189: (p_submission_name IN igs_he_submsn_header.submission_name%TYPE,
190: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
191: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
192: p_min_start_dt OUT NOCOPY igs_he_submsn_awd.award_start_date%TYPE,
193: p_max_start_dt OUT NOCOPY igs_he_submsn_awd.award_end_date%TYPE);
194:
195: PROCEDURE get_awd_dtls
196: (p_submission_name IN igs_he_submsn_awd.submission_name%TYPE,
197: p_awd_table OUT NOCOPY awd_table,

Line 196: (p_submission_name IN igs_he_submsn_awd.submission_name%TYPE,

192: p_min_start_dt OUT NOCOPY igs_he_submsn_awd.award_start_date%TYPE,
193: p_max_start_dt OUT NOCOPY igs_he_submsn_awd.award_end_date%TYPE);
194:
195: PROCEDURE get_awd_dtls
196: (p_submission_name IN igs_he_submsn_awd.submission_name%TYPE,
197: p_awd_table OUT NOCOPY awd_table,
198: p_search_prog OUT NOCOPY BOOLEAN,
199: p_search_prog_type OUT NOCOPY BOOLEAN);
200:

Line 210: p_awd_conf_start_dt OUT NOCOPY igs_he_submsn_awd.award_start_date%TYPE,

206: p_course_cd IN igs_ps_ver_all.course_cd%TYPE,
207: p_course_type IN igs_ps_ver_all.course_type%TYPE,
208: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
209: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
210: p_awd_conf_start_dt OUT NOCOPY igs_he_submsn_awd.award_start_date%TYPE,
211: p_awd_conf_end_dt OUT NOCOPY igs_he_submsn_awd.award_end_date%TYPE);
212:
213: PROCEDURE get_rsn_inst_left
214: (p_person_id IN igs_he_en_susa.person_id%TYPE,

Line 211: p_awd_conf_end_dt OUT NOCOPY igs_he_submsn_awd.award_end_date%TYPE);

207: p_course_type IN igs_ps_ver_all.course_type%TYPE,
208: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
209: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
210: p_awd_conf_start_dt OUT NOCOPY igs_he_submsn_awd.award_start_date%TYPE,
211: p_awd_conf_end_dt OUT NOCOPY igs_he_submsn_awd.award_end_date%TYPE);
212:
213: PROCEDURE get_rsn_inst_left
214: (p_person_id IN igs_he_en_susa.person_id%TYPE,
215: p_course_cd IN igs_he_en_susa.course_cd%TYPE,

Line 277: p_awd_conf_start_dt IN igs_he_submsn_awd.award_start_date%TYPE DEFAULT NULL);

273: p_spa_gen_qaim IN igs_he_st_spa.student_qual_aim%TYPE,
274: p_hesa_gen_qaim OUT NOCOPY VARCHAR2,
275: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE DEFAULT NULL,
276: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE DEFAULT NULL,
277: p_awd_conf_start_dt IN igs_he_submsn_awd.award_start_date%TYPE DEFAULT NULL);
278:
279: PROCEDURE get_awd_body_12
280: (p_course_cd IN igs_he_st_spa.course_cd%TYPE,
281: p_version_number IN igs_he_st_spa.version_number%TYPE,