DBA Data[Home] [Help]

APPS.IGS_HE_EXTRACT_FIELDS_PKG dependencies on IGS_PS_VER

Line 73: (p_course_cd IN igs_ps_ver.course_cd%TYPE,

69: p_hesa_fe_stdnt_mrker OUT NOCOPY VARCHAR2);
70:
71:
72: PROCEDURE get_funding_src
73: (p_course_cd IN igs_ps_ver.course_cd%TYPE,
74: p_version_number IN igs_ps_ver.version_number%TYPE,
75: p_spa_fund_src IN igs_en_stdnt_ps_att.funding_source%TYPE,
76: p_poous_fund_src IN igs_he_poous.funding_source%TYPE,
77: p_oss_fund_src OUT NOCOPY VARCHAR2,

Line 74: p_version_number IN igs_ps_ver.version_number%TYPE,

70:
71:
72: PROCEDURE get_funding_src
73: (p_course_cd IN igs_ps_ver.course_cd%TYPE,
74: p_version_number IN igs_ps_ver.version_number%TYPE,
75: p_spa_fund_src IN igs_en_stdnt_ps_att.funding_source%TYPE,
76: p_poous_fund_src IN igs_he_poous.funding_source%TYPE,
77: p_oss_fund_src OUT NOCOPY VARCHAR2,
78: p_hesa_fund_src OUT NOCOPY VARCHAR2);

Line 206: p_course_cd IN igs_ps_ver_all.course_cd%TYPE,

202: (p_awd_table IN awd_table,
203: p_submission_name IN igs_he_ext_run_dtls.submission_name%TYPE,
204: p_search_prog IN BOOLEAN,
205: p_search_prog_type IN BOOLEAN,
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,

Line 207: p_course_type IN igs_ps_ver_all.course_type%TYPE,

203: p_submission_name IN igs_he_ext_run_dtls.submission_name%TYPE,
204: p_search_prog IN BOOLEAN,
205: p_search_prog_type IN BOOLEAN,
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);

Line 289: p_ft_compl_time IN igs_ps_ver.std_ft_completion_time%TYPE,

285: p_awd_body2 OUT NOCOPY VARCHAR2);
286:
287: PROCEDURE get_prog_length
288: (p_spa_attendance_type IN igs_en_stdnt_ps_att.attendance_type%TYPE,
289: p_ft_compl_time IN igs_ps_ver.std_ft_completion_time%TYPE,
290: p_pt_compl_time IN igs_ps_ver.std_pt_completion_time%TYPE,
291: p_length OUT NOCOPY VARCHAR2,
292: p_units OUT NOCOPY VARCHAR2);
293:

Line 290: p_pt_compl_time IN igs_ps_ver.std_pt_completion_time%TYPE,

286:
287: PROCEDURE get_prog_length
288: (p_spa_attendance_type IN igs_en_stdnt_ps_att.attendance_type%TYPE,
289: p_ft_compl_time IN igs_ps_ver.std_ft_completion_time%TYPE,
290: p_pt_compl_time IN igs_ps_ver.std_pt_completion_time%TYPE,
291: p_length OUT NOCOPY VARCHAR2,
292: p_units OUT NOCOPY VARCHAR2);
293:
294: PROCEDURE get_teach_train_crs_id

Line 679: p_course_cd IN igs_ps_ver.course_cd%TYPE,

675: p_hesa_gov_initiatives_cd OUT NOCOPY VARCHAR2);
676:
677: PROCEDURE get_units_completed
678: (p_person_id IN igs_pe_person.person_id%TYPE,
679: p_course_cd IN igs_ps_ver.course_cd%TYPE,
680: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
681: p_spa_units_completed IN igs_he_st_spa.units_completed%TYPE,
682: p_hesa_units_completed OUT NOCOPY VARCHAR2);
683: