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_PRC_LOAD dependencies on IGS_EN_SPA_TERMS

Line 1693: FROM igs_en_spa_terms

1689: person_id=p_person_id;
1690:
1691: CURSOR c_term_key_prog IS
1692: SELECT program_cd, program_version
1693: FROM igs_en_spa_terms
1694: WHERE person_id = p_person_id
1695: AND term_cal_type = p_term_cal_type
1696: AND term_sequence_number = p_term_sequence_number
1697: AND key_program_flag = 'Y';

Line 1813: cp_load_cal_type IGS_EN_SPA_TERMS.term_cal_type%TYPE,

1809:
1810: l_person hz_parties.party_number%TYPE;
1811:
1812: CURSOR c_spa(cp_person_id IGS_PE_PERSON.person_id%TYPE,
1813: cp_load_cal_type IGS_EN_SPA_TERMS.term_cal_type%TYPE,
1814: cp_load_seq_number IGS_EN_SPA_TERMS.term_sequence_number%TYPE) IS
1815: Select sca.course_cd
1816: From igs_en_stdnt_ps_att_all sca,
1817: igs_ps_ver_all pv

Line 1814: cp_load_seq_number IGS_EN_SPA_TERMS.term_sequence_number%TYPE) IS

1810: l_person hz_parties.party_number%TYPE;
1811:
1812: CURSOR c_spa(cp_person_id IGS_PE_PERSON.person_id%TYPE,
1813: cp_load_cal_type IGS_EN_SPA_TERMS.term_cal_type%TYPE,
1814: cp_load_seq_number IGS_EN_SPA_TERMS.term_sequence_number%TYPE) IS
1815: Select sca.course_cd
1816: From igs_en_stdnt_ps_att_all sca,
1817: igs_ps_ver_all pv
1818: WHERE sca.person_id = cp_person_id

Line 1822: (NVL(FND_PROFILE.VALUE('CAREER_MODEL_ENABLED'),'N') = 'Y' AND igs_en_spa_terms_api.get_spat_primary_prg(sca.person_id, sca.course_cd, cp_load_cal_type,cp_load_seq_number)='PRIMARY')

1818: WHERE sca.person_id = cp_person_id
1819: AND sca.course_cd = pv.course_cd
1820: AND sca.version_number = pv.version_number
1821: AND (
1822: (NVL(FND_PROFILE.VALUE('CAREER_MODEL_ENABLED'),'N') = 'Y' AND igs_en_spa_terms_api.get_spat_primary_prg(sca.person_id, sca.course_cd, cp_load_cal_type,cp_load_seq_number)='PRIMARY')
1823: OR
1824: (NVL(FND_PROFILE.VALUE('CAREER_MODEL_ENABLED'),'N') = 'N')
1825: );
1826:

Line 1975: igs_en_spa_terms_api.get_spat_program_version(p_person_id, course_cd,

1971: l_attendance_type igs_en_atd_type_load.attendance_type%TYPE;
1972:
1973: CURSOR c_active_cd(l_career VARCHAR2) IS
1974: SELECT course_cd,
1975: igs_en_spa_terms_api.get_spat_program_version(p_person_id, course_cd,
1976: p_load_cal_type, p_load_seq_number)
1977:
1978: FROM igs_en_stdnt_ps_att sca
1979: WHERE person_id = p_person_id AND

Line 1983: (EXISTS (SELECT 'x' FROM igs_en_spa_terms spat

1979: WHERE person_id = p_person_id AND
1980: --anilk, Bug# 3046897
1981: course_attempt_status IN (cst_enrolled, cst_inactive, cst_discontin, cst_completed) AND
1982: ((l_career ='Y' AND
1983: (EXISTS (SELECT 'x' FROM igs_en_spa_terms spat
1984: WHERE spat.person_id = sca.person_id
1985: AND spat.program_cd = sca.course_cd
1986: AND spat.term_cal_type = p_load_cal_type
1987: AND spat.term_sequence_number = p_load_seq_number)

Line 1991: FROM igs_en_spa_terms spat, igs_ps_ver pv1, igs_ps_ver pv2

1987: AND spat.term_sequence_number = p_load_seq_number)
1988: OR
1989: (sca.primary_program_type='PRIMARY' AND
1990: NOT EXISTS (SELECT 'x'
1991: FROM igs_en_spa_terms spat, igs_ps_ver pv1, igs_ps_ver pv2
1992: WHERE spat.person_id = sca.person_id
1993: AND spat.program_cd = pv1.course_cd
1994: AND spat.program_version = pv1.version_number
1995: AND sca.course_cd = pv2.course_cd

Line 2181: ( EXISTS (SELECT 'x' FROM igs_en_spa_terms spat

2177: WHERE
2178: sca.person_id = p_person_id AND
2179: sca.person_id = sua.person_id AND
2180: sca.course_cd = sua.course_cd AND
2181: ( EXISTS (SELECT 'x' FROM igs_en_spa_terms spat
2182: WHERE spat.person_id = sca.person_id
2183: AND spat.program_cd = sca.course_cd
2184: AND spat.term_cal_type = p_load_cal_type
2185: AND spat.term_sequence_number = p_load_sequence_number)

Line 2189: FROM igs_en_spa_terms spat, igs_ps_ver pv1, igs_ps_ver pv2

2185: AND spat.term_sequence_number = p_load_sequence_number)
2186: OR
2187: (sca.primary_program_type='PRIMARY' AND
2188: NOT EXISTS (SELECT 'x'
2189: FROM igs_en_spa_terms spat, igs_ps_ver pv1, igs_ps_ver pv2
2190: WHERE spat.person_id = sca.person_id
2191: AND spat.program_cd = pv1.course_cd
2192: AND spat.program_version = pv1.version_number
2193: AND sca.course_cd = pv2.course_cd