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_EN_VAL_SUSA dependencies on IGS_GE_DATE

Line 1888: (NVL(p_authorised_on,IGS_GE_DATE.IGSDATE('1900/01/01'))

1884: IF v_inserting OR
1885: (v_updating AND
1886: ((NVL(p_authorised_person_id, 0) <>
1887: NVL(v_old_susa_rec.authorised_person_id, 0)) OR
1888: (NVL(p_authorised_on,IGS_GE_DATE.IGSDATE('1900/01/01'))
1889: <> NVL(v_old_susa_rec.authorised_on,
1890: IGS_GE_DATE.IGSDATE('1900/01/01'))))) THEN
1891: IF Igs_En_Val_Susa.enrp_val_susa_auth(
1892: p_unit_set_cd,

Line 1890: IGS_GE_DATE.IGSDATE('1900/01/01'))))) THEN

1886: ((NVL(p_authorised_person_id, 0) <>
1887: NVL(v_old_susa_rec.authorised_person_id, 0)) OR
1888: (NVL(p_authorised_on,IGS_GE_DATE.IGSDATE('1900/01/01'))
1889: <> NVL(v_old_susa_rec.authorised_on,
1890: IGS_GE_DATE.IGSDATE('1900/01/01'))))) THEN
1891: IF Igs_En_Val_Susa.enrp_val_susa_auth(
1892: p_unit_set_cd,
1893: p_us_version_number,
1894: p_end_dt,

Line 1908: (NVL(p_authorised_on,IGS_GE_DATE.IGSDATE('1900/01/01'))

1904: (v_updating AND
1905: ((NVL(p_authorised_person_id, 0) <>
1906: NVL(v_old_susa_rec.authorised_person_id, 0)) OR
1907: (p_student_confirmed_ind <> v_old_susa_rec.student_confirmed_ind) OR
1908: (NVL(p_authorised_on,IGS_GE_DATE.IGSDATE('1900/01/01'))
1909: <> NVL(v_old_susa_rec.authorised_on,
1910: IGS_GE_DATE.IGSDATE('1900/01/01'))))) THEN
1911: -- Validate that the authorisation fields must be set when
1912: -- the unit set cd requires authorisation (IGS_EN_UNIT_SET.authorisation_ind = 'Y')

Line 1910: IGS_GE_DATE.IGSDATE('1900/01/01'))))) THEN

1906: NVL(v_old_susa_rec.authorised_person_id, 0)) OR
1907: (p_student_confirmed_ind <> v_old_susa_rec.student_confirmed_ind) OR
1908: (NVL(p_authorised_on,IGS_GE_DATE.IGSDATE('1900/01/01'))
1909: <> NVL(v_old_susa_rec.authorised_on,
1910: IGS_GE_DATE.IGSDATE('1900/01/01'))))) THEN
1911: -- Validate that the authorisation fields must be set when
1912: -- the unit set cd requires authorisation (IGS_EN_UNIT_SET.authorisation_ind = 'Y')
1913: -- Check required only when the unit set is confirmed.
1914: IF (p_student_confirmed_ind = 'Y') THEN

Line 1933: (NVL(p_rqrmnts_complete_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))

1929: IF v_inserting OR
1930: (v_updating AND
1931: ((NVL(p_rqrmnts_complete_ind, 'x')
1932: <> NVL(v_old_susa_rec.rqrmnts_complete_ind, 'x')) OR
1933: (NVL(p_rqrmnts_complete_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))
1934: <> NVL(v_old_susa_rec.rqrmnts_complete_dt,
1935: IGS_GE_DATE.IGSDATE('1900/01/01')))))THEN
1936: IF Igs_En_Val_Susa.enrp_val_susa_cmplt(
1937: p_rqrmnts_complete_dt,

Line 1935: IGS_GE_DATE.IGSDATE('1900/01/01')))))THEN

1931: ((NVL(p_rqrmnts_complete_ind, 'x')
1932: <> NVL(v_old_susa_rec.rqrmnts_complete_ind, 'x')) OR
1933: (NVL(p_rqrmnts_complete_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))
1934: <> NVL(v_old_susa_rec.rqrmnts_complete_dt,
1935: IGS_GE_DATE.IGSDATE('1900/01/01')))))THEN
1936: IF Igs_En_Val_Susa.enrp_val_susa_cmplt(
1937: p_rqrmnts_complete_dt,
1938: p_rqrmnts_complete_ind,
1939: p_student_confirmed_ind,

Line 1955: (NVL(p_rqrmnts_complete_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))

1951: ((NVL(p_rqrmnts_complete_ind, 'x')
1952: <> NVL(v_old_susa_rec.rqrmnts_complete_ind, 'x')) OR
1953: (NVL(p_s_completed_source_type, 'x')
1954: <> NVL(v_old_susa_rec.s_completed_source_type, 'x')) OR
1955: (NVL(p_rqrmnts_complete_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))
1956: <> NVL(v_old_susa_rec.rqrmnts_complete_dt,
1957: IGS_GE_DATE.IGSDATE('1900/01/01')))))THEN
1958: IF Igs_En_Val_Susa.enrp_val_susa_scst(
1959: p_rqrmnts_complete_dt,

Line 1957: IGS_GE_DATE.IGSDATE('1900/01/01')))))THEN

1953: (NVL(p_s_completed_source_type, 'x')
1954: <> NVL(v_old_susa_rec.s_completed_source_type, 'x')) OR
1955: (NVL(p_rqrmnts_complete_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))
1956: <> NVL(v_old_susa_rec.rqrmnts_complete_dt,
1957: IGS_GE_DATE.IGSDATE('1900/01/01')))))THEN
1958: IF Igs_En_Val_Susa.enrp_val_susa_scst(
1959: p_rqrmnts_complete_dt,
1960: p_rqrmnts_complete_ind,
1961: p_s_completed_source_type,

Line 1971: ((NVL(p_selection_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))

1967: -- Validate the date fields.
1968:
1969: IF v_inserting OR
1970: (v_updating AND
1971: ((NVL(p_selection_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))
1972: <> NVL(v_old_susa_rec.selection_dt,
1973: IGS_GE_DATE.IGSDATE('1900/01/01'))) OR
1974: (NVL(p_end_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))
1975: <> NVL(v_old_susa_rec.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))) OR

Line 1973: IGS_GE_DATE.IGSDATE('1900/01/01'))) OR

1969: IF v_inserting OR
1970: (v_updating AND
1971: ((NVL(p_selection_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))
1972: <> NVL(v_old_susa_rec.selection_dt,
1973: IGS_GE_DATE.IGSDATE('1900/01/01'))) OR
1974: (NVL(p_end_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))
1975: <> NVL(v_old_susa_rec.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))) OR
1976: (NVL(p_rqrmnts_complete_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))
1977: <> NVL(v_old_susa_rec.rqrmnts_complete_dt,

Line 1974: (NVL(p_end_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))

1970: (v_updating AND
1971: ((NVL(p_selection_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))
1972: <> NVL(v_old_susa_rec.selection_dt,
1973: IGS_GE_DATE.IGSDATE('1900/01/01'))) OR
1974: (NVL(p_end_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))
1975: <> NVL(v_old_susa_rec.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))) OR
1976: (NVL(p_rqrmnts_complete_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))
1977: <> NVL(v_old_susa_rec.rqrmnts_complete_dt,
1978: IGS_GE_DATE.IGSDATE('1900/01/01'))))) THEN

Line 1975: <> NVL(v_old_susa_rec.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))) OR

1971: ((NVL(p_selection_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))
1972: <> NVL(v_old_susa_rec.selection_dt,
1973: IGS_GE_DATE.IGSDATE('1900/01/01'))) OR
1974: (NVL(p_end_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))
1975: <> NVL(v_old_susa_rec.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))) OR
1976: (NVL(p_rqrmnts_complete_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))
1977: <> NVL(v_old_susa_rec.rqrmnts_complete_dt,
1978: IGS_GE_DATE.IGSDATE('1900/01/01'))))) THEN
1979: IF Igs_En_Val_Susa.enrp_val_susa_dts(

Line 1976: (NVL(p_rqrmnts_complete_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))

1972: <> NVL(v_old_susa_rec.selection_dt,
1973: IGS_GE_DATE.IGSDATE('1900/01/01'))) OR
1974: (NVL(p_end_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))
1975: <> NVL(v_old_susa_rec.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))) OR
1976: (NVL(p_rqrmnts_complete_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))
1977: <> NVL(v_old_susa_rec.rqrmnts_complete_dt,
1978: IGS_GE_DATE.IGSDATE('1900/01/01'))))) THEN
1979: IF Igs_En_Val_Susa.enrp_val_susa_dts(
1980: p_selection_dt,

Line 1978: IGS_GE_DATE.IGSDATE('1900/01/01'))))) THEN

1974: (NVL(p_end_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))
1975: <> NVL(v_old_susa_rec.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))) OR
1976: (NVL(p_rqrmnts_complete_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))
1977: <> NVL(v_old_susa_rec.rqrmnts_complete_dt,
1978: IGS_GE_DATE.IGSDATE('1900/01/01'))))) THEN
1979: IF Igs_En_Val_Susa.enrp_val_susa_dts(
1980: p_selection_dt,
1981: p_end_dt,
1982: p_rqrmnts_complete_dt,

Line 1994: (NVL(p_selection_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))

1990: IF v_inserting OR
1991: (v_updating AND
1992:
1993: ((p_student_confirmed_ind <> v_old_susa_rec.student_confirmed_ind) OR
1994: (NVL(p_selection_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))
1995: <> NVL(v_old_susa_rec.selection_dt,
1996: IGS_GE_DATE.IGSDATE('1900/01/01'))))) THEN
1997: IF Igs_En_Val_Susa.enrp_val_susa_sci_sd(
1998: p_student_confirmed_ind,

Line 1996: IGS_GE_DATE.IGSDATE('1900/01/01'))))) THEN

1992:
1993: ((p_student_confirmed_ind <> v_old_susa_rec.student_confirmed_ind) OR
1994: (NVL(p_selection_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))
1995: <> NVL(v_old_susa_rec.selection_dt,
1996: IGS_GE_DATE.IGSDATE('1900/01/01'))))) THEN
1997: IF Igs_En_Val_Susa.enrp_val_susa_sci_sd(
1998: p_student_confirmed_ind,
1999: p_selection_dt,
2000: v_message_name,

Line 2011: (NVL(p_end_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))

2007: -- set.
2008: IF v_inserting OR
2009: (v_updating AND
2010: ((p_voluntary_end_ind <> v_old_susa_rec.voluntary_end_ind) OR
2011: (NVL(p_end_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))
2012: <> NVL(v_old_susa_rec.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))))) THEN
2013: IF Igs_En_Val_Susa.enrp_val_susa_end_vi(
2014: p_voluntary_end_ind,
2015: p_end_dt,

Line 2012: <> NVL(v_old_susa_rec.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))))) THEN

2008: IF v_inserting OR
2009: (v_updating AND
2010: ((p_voluntary_end_ind <> v_old_susa_rec.voluntary_end_ind) OR
2011: (NVL(p_end_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))
2012: <> NVL(v_old_susa_rec.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))))) THEN
2013: IF Igs_En_Val_Susa.enrp_val_susa_end_vi(
2014: p_voluntary_end_ind,
2015: p_end_dt,
2016: v_message_name) = FALSE THEN

Line 2103: (NVL(p_end_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))

2099: RETURN FALSE;
2100: END IF;
2101: END IF;
2102: IF v_inserting OR
2103: (NVL(p_end_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))
2104: <> NVL(v_old_susa_rec.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN
2105: -- Validate the end date, check if the authorisation details
2106: -- need to be set or if more than one open end dated instance
2107: -- of the unit set exists. Also cannot be cleared if parent ended.

Line 2104: <> NVL(v_old_susa_rec.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN

2100: END IF;
2101: END IF;
2102: IF v_inserting OR
2103: (NVL(p_end_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))
2104: <> NVL(v_old_susa_rec.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN
2105: -- Validate the end date, check if the authorisation details
2106: -- need to be set or if more than one open end dated instance
2107: -- of the unit set exists. Also cannot be cleared if parent ended.
2108: -- If part of the admissions offer, authorisation required to end