eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_HE_EXTRACT_FIELDS_PKG dependencies on IGS_HE_SUBMSN_AWD

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

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)
1884: IS
1885: BEGIN
1886:

Line 1883: p_awd_conf_end_dt OUT NOCOPY igs_he_submsn_awd.award_end_date%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)
1884: IS
1885: BEGIN
1886:
1887: IF p_search_prog = FALSE and p_search_prog_type = FALSE THEN

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

1945: PROCEDURE get_min_max_awd_dates
1946: (p_submission_name IN igs_he_submsn_header.submission_name%TYPE,
1947: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
1948: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
1949: p_min_start_dt OUT NOCOPY igs_he_submsn_awd.award_start_date%TYPE,
1950: p_max_start_dt OUT NOCOPY igs_he_submsn_awd.award_end_date%TYPE)
1951: IS
1952: /***************************************************************
1953: Created By : jtmathew

Line 1950: p_max_start_dt OUT NOCOPY igs_he_submsn_awd.award_end_date%TYPE)

1946: (p_submission_name IN igs_he_submsn_header.submission_name%TYPE,
1947: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
1948: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
1949: p_min_start_dt OUT NOCOPY igs_he_submsn_awd.award_start_date%TYPE,
1950: p_max_start_dt OUT NOCOPY igs_he_submsn_awd.award_end_date%TYPE)
1951: IS
1952: /***************************************************************
1953: Created By : jtmathew
1954: Date Created By : 28-Dec-2005

Line 1963: CURSOR c_get_min_awd_conf_dt (cp_type igs_he_submsn_awd.type%TYPE) IS

1959: Change History :
1960: Who When What
1961: ***************************************************************/
1962:
1963: CURSOR c_get_min_awd_conf_dt (cp_type igs_he_submsn_awd.type%TYPE) IS
1964: SELECT min(award_start_date)
1965: FROM igs_he_submsn_awd
1966: WHERE submission_name = p_submission_name;
1967:

Line 1965: FROM igs_he_submsn_awd

1961: ***************************************************************/
1962:
1963: CURSOR c_get_min_awd_conf_dt (cp_type igs_he_submsn_awd.type%TYPE) IS
1964: SELECT min(award_start_date)
1965: FROM igs_he_submsn_awd
1966: WHERE submission_name = p_submission_name;
1967:
1968: CURSOR c_get_max_awd_conf_dt (cp_type igs_he_submsn_awd.type%TYPE) IS
1969: SELECT max(award_end_date)

Line 1968: CURSOR c_get_max_awd_conf_dt (cp_type igs_he_submsn_awd.type%TYPE) IS

1964: SELECT min(award_start_date)
1965: FROM igs_he_submsn_awd
1966: WHERE submission_name = p_submission_name;
1967:
1968: CURSOR c_get_max_awd_conf_dt (cp_type igs_he_submsn_awd.type%TYPE) IS
1969: SELECT max(award_end_date)
1970: FROM igs_he_submsn_awd
1971: WHERE submission_name = p_submission_name;
1972:

Line 1970: FROM igs_he_submsn_awd

1966: WHERE submission_name = p_submission_name;
1967:
1968: CURSOR c_get_max_awd_conf_dt (cp_type igs_he_submsn_awd.type%TYPE) IS
1969: SELECT max(award_end_date)
1970: FROM igs_he_submsn_awd
1971: WHERE submission_name = p_submission_name;
1972:
1973: l_min_dt DATE;
1974: l_max_dt DATE;

Line 2012: PROCEDURE get_awd_dtls (p_submission_name IN igs_he_submsn_awd.submission_name%TYPE,

2008:
2009: END get_min_max_awd_dates;
2010:
2011:
2012: PROCEDURE get_awd_dtls (p_submission_name IN igs_he_submsn_awd.submission_name%TYPE,
2013: p_awd_table OUT NOCOPY awd_table,
2014: p_search_prog OUT NOCOPY BOOLEAN,
2015: p_search_prog_type OUT NOCOPY BOOLEAN)
2016: IS

Line 2027: CURSOR c_get_awdcount (cp_type igs_he_submsn_awd.type%TYPE) IS

2023: Known Limitations,Enhancements or Remarks:
2024: Change History :
2025: Who When What
2026: ***************************************************************/
2027: CURSOR c_get_awdcount (cp_type igs_he_submsn_awd.type%TYPE) IS
2028: SELECT 'X'
2029: FROM igs_he_submsn_awd
2030: WHERE submission_name = p_submission_name
2031: AND type = cp_type;

Line 2029: FROM igs_he_submsn_awd

2025: Who When What
2026: ***************************************************************/
2027: CURSOR c_get_awdcount (cp_type igs_he_submsn_awd.type%TYPE) IS
2028: SELECT 'X'
2029: FROM igs_he_submsn_awd
2030: WHERE submission_name = p_submission_name
2031: AND type = cp_type;
2032:
2033: CURSOR c_get_awd_dtls IS

Line 2035: FROM igs_he_submsn_awd

2031: AND type = cp_type;
2032:
2033: CURSOR c_get_awd_dtls IS
2034: SELECT type, key1, award_start_date, award_end_date
2035: FROM igs_he_submsn_awd
2036: WHERE submission_name = p_submission_name
2037: ORDER BY type;
2038:
2039: l_dummy VARCHAR2(1);

Line 2865: p_awd_conf_start_dt IN igs_he_submsn_awd.award_start_date%TYPE)

2861: p_spa_gen_qaim IN igs_he_st_spa.student_qual_aim%TYPE,
2862: p_hesa_gen_qaim OUT NOCOPY VARCHAR2,
2863: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
2864: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
2865: p_awd_conf_start_dt IN igs_he_submsn_awd.award_start_date%TYPE)
2866:
2867: IS
2868: /***************************************************************
2869: Created By :