DBA Data[Home] [Help]

APPS.IGS_EN_GEN_LEGACY dependencies on IGS_EN_STDNT_PS_INTM

Line 1718: p_person_id IN igs_en_stdnt_ps_intm.person_id%TYPE,

1714: END check_dup_susa;
1715:
1716:
1717: FUNCTION validate_intm_ua_ovrlp (
1718: p_person_id IN igs_en_stdnt_ps_intm.person_id%TYPE,
1719: p_program_cd IN igs_en_stdnt_ps_intm.course_cd%TYPE,
1720: p_start_dt IN igs_en_stdnt_ps_intm.start_dt%TYPE,
1721: p_end_dt IN igs_en_stdnt_ps_intm.end_dt%TYPE
1722: ) RETURN BOOLEAN AS

Line 1719: p_program_cd IN igs_en_stdnt_ps_intm.course_cd%TYPE,

1715:
1716:
1717: FUNCTION validate_intm_ua_ovrlp (
1718: p_person_id IN igs_en_stdnt_ps_intm.person_id%TYPE,
1719: p_program_cd IN igs_en_stdnt_ps_intm.course_cd%TYPE,
1720: p_start_dt IN igs_en_stdnt_ps_intm.start_dt%TYPE,
1721: p_end_dt IN igs_en_stdnt_ps_intm.end_dt%TYPE
1722: ) RETURN BOOLEAN AS
1723:

Line 1720: p_start_dt IN igs_en_stdnt_ps_intm.start_dt%TYPE,

1716:
1717: FUNCTION validate_intm_ua_ovrlp (
1718: p_person_id IN igs_en_stdnt_ps_intm.person_id%TYPE,
1719: p_program_cd IN igs_en_stdnt_ps_intm.course_cd%TYPE,
1720: p_start_dt IN igs_en_stdnt_ps_intm.start_dt%TYPE,
1721: p_end_dt IN igs_en_stdnt_ps_intm.end_dt%TYPE
1722: ) RETURN BOOLEAN AS
1723:
1724: /**********************************************************************************************

Line 1721: p_end_dt IN igs_en_stdnt_ps_intm.end_dt%TYPE

1717: FUNCTION validate_intm_ua_ovrlp (
1718: p_person_id IN igs_en_stdnt_ps_intm.person_id%TYPE,
1719: p_program_cd IN igs_en_stdnt_ps_intm.course_cd%TYPE,
1720: p_start_dt IN igs_en_stdnt_ps_intm.start_dt%TYPE,
1721: p_end_dt IN igs_en_stdnt_ps_intm.end_dt%TYPE
1722: ) RETURN BOOLEAN AS
1723:
1724: /**********************************************************************************************
1725: Created By : pradhakr

Line 1787: p_intermission_type IN igs_en_stdnt_ps_intm.intermission_type%TYPE

1783: END validate_intm_ua_ovrlp;
1784:
1785:
1786: FUNCTION check_approv_reqd (
1787: p_intermission_type IN igs_en_stdnt_ps_intm.intermission_type%TYPE
1788: ) RETURN BOOLEAN as
1789:
1790: /**********************************************************************************************
1791: Created By : pradhakr

Line 1824: p_intermission_type IN igs_en_stdnt_ps_intm.intermission_type%TYPE

1820:
1821:
1822:
1823: FUNCTION check_study_antr_instu (
1824: p_intermission_type IN igs_en_stdnt_ps_intm.intermission_type%TYPE
1825: ) RETURN BOOLEAN as
1826:
1827: /**********************************************************************************************
1828: Created By : pradhakr

Line 1862: p_institution_name IN igs_en_stdnt_ps_intm.institution_name%TYPE

1858:
1859:
1860:
1861: FUNCTION check_institution (
1862: p_institution_name IN igs_en_stdnt_ps_intm.institution_name%TYPE
1863: ) RETURN BOOLEAN AS
1864:
1865: /**********************************************************************************************
1866: Created By : pradhakr

Line 1919: p_person_id IN igs_en_stdnt_ps_intm.person_id%TYPE,

1915: END check_institution;
1916:
1917:
1918: FUNCTION check_sca_status_upd (
1919: p_person_id IN igs_en_stdnt_ps_intm.person_id%TYPE,
1920: p_program_cd IN igs_en_stdnt_ps_intm.course_cd%TYPE,
1921: p_called_from IN VARCHAR2,
1922: p_course_attempt_status OUT NOCOPY igs_en_stdnt_ps_att.course_attempt_status%TYPE
1923: ) RETURN BOOLEAN as

Line 1920: p_program_cd IN igs_en_stdnt_ps_intm.course_cd%TYPE,

1916:
1917:
1918: FUNCTION check_sca_status_upd (
1919: p_person_id IN igs_en_stdnt_ps_intm.person_id%TYPE,
1920: p_program_cd IN igs_en_stdnt_ps_intm.course_cd%TYPE,
1921: p_called_from IN VARCHAR2,
1922: p_course_attempt_status OUT NOCOPY igs_en_stdnt_ps_att.course_attempt_status%TYPE
1923: ) RETURN BOOLEAN as
1924: /**********************************************************************************************