[Home] [Help]
695: END get_fe_stdnt_mrker;
696:
697:
698: PROCEDURE get_funding_src
699: (p_course_cd IN igs_ps_ver.course_cd%TYPE,
700: p_version_number IN igs_ps_ver.version_number%TYPE,
701: p_spa_fund_src IN igs_en_stdnt_ps_att.funding_source%TYPE,
702: p_poous_fund_src IN igs_he_poous.funding_source%TYPE,
703: p_oss_fund_src OUT NOCOPY VARCHAR2,
696:
697:
698: PROCEDURE get_funding_src
699: (p_course_cd IN igs_ps_ver.course_cd%TYPE,
700: p_version_number IN igs_ps_ver.version_number%TYPE,
701: p_spa_fund_src IN igs_en_stdnt_ps_att.funding_source%TYPE,
702: p_poous_fund_src IN igs_he_poous.funding_source%TYPE,
703: p_oss_fund_src OUT NOCOPY VARCHAR2,
704: p_hesa_fund_src OUT NOCOPY VARCHAR2)
1874: (p_awd_table IN awd_table,
1875: p_submission_name IN igs_he_ext_run_dtls.submission_name%TYPE,
1876: p_search_prog IN BOOLEAN,
1877: p_search_prog_type IN BOOLEAN,
1878: p_course_cd IN igs_ps_ver_all.course_cd%TYPE,
1879: p_course_type IN igs_ps_ver_all.course_type%TYPE,
1880: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
1881: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
1882: p_awd_conf_start_dt OUT NOCOPY igs_he_submsn_awd.award_start_date%TYPE,
1875: p_submission_name IN igs_he_ext_run_dtls.submission_name%TYPE,
1876: p_search_prog IN BOOLEAN,
1877: p_search_prog_type IN BOOLEAN,
1878: p_course_cd IN igs_ps_ver_all.course_cd%TYPE,
1879: p_course_type IN igs_ps_ver_all.course_type%TYPE,
1880: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
1881: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
1882: p_awd_conf_start_dt OUT NOCOPY igs_he_submsn_awd.award_start_date%TYPE,
1883: p_awd_conf_end_dt OUT NOCOPY igs_he_submsn_awd.award_end_date%TYPE)
3040:
3041:
3042: PROCEDURE get_prog_length
3043: (p_spa_attendance_type IN igs_en_stdnt_ps_att.attendance_type%TYPE,
3044: p_ft_compl_time IN igs_ps_ver.std_ft_completion_time%TYPE,
3045: p_pt_compl_time IN igs_ps_ver.std_pt_completion_time%TYPE,
3046: p_length OUT NOCOPY VARCHAR2,
3047: p_units OUT NOCOPY VARCHAR2)
3048: IS
3041:
3042: PROCEDURE get_prog_length
3043: (p_spa_attendance_type IN igs_en_stdnt_ps_att.attendance_type%TYPE,
3044: p_ft_compl_time IN igs_ps_ver.std_ft_completion_time%TYPE,
3045: p_pt_compl_time IN igs_ps_ver.std_pt_completion_time%TYPE,
3046: p_length OUT NOCOPY VARCHAR2,
3047: p_units OUT NOCOPY VARCHAR2)
3048: IS
3049: /***************************************************************
7509: END get_gov_init;
7510:
7511: PROCEDURE get_units_completed
7512: (p_person_id IN igs_pe_person.person_id%TYPE,
7513: p_course_cd IN igs_ps_ver.course_cd%TYPE,
7514: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
7515: p_spa_units_completed IN igs_he_st_spa.units_completed%TYPE,
7516: p_hesa_units_completed OUT NOCOPY VARCHAR2)
7517: IS