APPS.IGS_AV_GEN_001 dependencies on IGS_GE_DATE

Line 1774: NVL(expiry_dt, IGS_GE_DATE.IGSDATE('9999/01/01')) < SYSDATE

1770: CURSOR c_person IS
1771: SELECT person_id
1772: FROM IGS_AV_STND_UNIT_ALL
1773: WHERE s_adv_stnd_granting_status = 'APPROVED' AND
1774: NVL(expiry_dt, IGS_GE_DATE.IGSDATE('9999/01/01')) < SYSDATE
1775: UNION
1776: SELECT person_id
1777: FROM IGS_AV_STND_UNIT_LVL_ALL
1778: WHERE s_adv_stnd_granting_status = 'APPROVED' AND

Line 1779: NVL(expiry_dt, IGS_GE_DATE.IGSDATE('9999/01/01')) < SYSDATE;

1775: UNION
1776: SELECT person_id
1777: FROM IGS_AV_STND_UNIT_LVL_ALL
1778: WHERE s_adv_stnd_granting_status = 'APPROVED' AND
1779: NVL(expiry_dt, IGS_GE_DATE.IGSDATE('9999/01/01')) < SYSDATE;
1780:
1781: CURSOR c_adv_stnd_unit (cp_person_id IGS_PE_PERSON.person_id%TYPE) IS
1782: SELECT rowid , IGS_AV_STND_UNIT.*
1783: FROM igs_av_stnd_unit

Line 1785: NVL(expiry_dt, IGS_GE_DATE.IGSDATE('9999/01/01')) < SYSDATE AND

1781: CURSOR c_adv_stnd_unit (cp_person_id IGS_PE_PERSON.person_id%TYPE) IS
1782: SELECT rowid , IGS_AV_STND_UNIT.*
1783: FROM igs_av_stnd_unit
1784: WHERE s_adv_stnd_granting_status = 'APPROVED' AND
1785: NVL(expiry_dt, IGS_GE_DATE.IGSDATE('9999/01/01')) < SYSDATE AND
1786: person_id = cp_person_id AND
1787: s_adv_stnd_recognition_type <> 'PRECLUSION' /* Added as per Bug# 2441175 */
1788: ORDER BY
1789: person_id,

Line 1798: NVL(expiry_dt, IGS_GE_DATE.IGSDATE('9999/01/01')) < SYSDATE AND

1794: CURSOR c_adv_stnd_unit_level (cp_person_id IGS_PE_PERSON.person_id%TYPE) IS
1795: SELECT rowid,IGS_AV_STND_UNIT_LVL.*
1796: FROM IGS_AV_STND_UNIT_LVL
1797: WHERE s_adv_stnd_granting_status = 'APPROVED' AND
1798: NVL(expiry_dt, IGS_GE_DATE.IGSDATE('9999/01/01')) < SYSDATE AND
1799: person_id = cp_person_id
1800: ORDER BY
1801: person_id,
1802: as_course_cd,

Line 1999: IF (p_basis_year > TO_NUMBER(SUBSTR(IGS_GE_DATE.IGSCHAR(SYSDATE),1,4))) THEN

1995: p_version_number IS NULL) THEN
1996: RETURN 'Y';
1997: END IF;
1998: -- Validate that basis_year is not greater than the current year.(E)
1999: IF (p_basis_year > TO_NUMBER(SUBSTR(IGS_GE_DATE.IGSCHAR(SYSDATE),1,4))) THEN
2000: p_message_name := 'IGS_AV_LYENR_NOTGT_CURYR';
2001: p_return_type := 'E';
2002: RETURN 'Y';
2003: END IF;

Line 2013: TO_NUMBER(SUBSTR(IGS_GE_DATE.IGSCHAR(SYSDATE),1,4)) - v_qualification_recency) THEN

2009: RAISE NO_DATA_FOUND;
2010: END IF;
2011: CLOSE c_qualification_recency;
2012: IF (p_basis_year <
2013: TO_NUMBER(SUBSTR(IGS_GE_DATE.IGSCHAR(SYSDATE),1,4)) - v_qualification_recency) THEN
2014: p_message_name := 'IGS_AV_LRENR_OUTSIDE_QUALIFY';
2015: p_return_type := 'W';
2016: RETURN 'Y';
2017: END IF;