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_SPA_TERMS_API dependencies on IGS_PS_VER

Line 5: cp_program_cd IGS_PS_VER.course_cd%TYPE,

1: PACKAGE BODY IGS_EN_SPA_TERMS_API AS
2: /* $Header: IGSENB1B.pls 120.14 2005/11/28 02:26:46 appldev noship $ */
3:
4: CURSOR c_term_exists(cp_person_id IGS_PE_PERSON.person_id%TYPE,
5: cp_program_cd IGS_PS_VER.course_cd%TYPE,
6: cp_program_version IGS_PS_VER.version_number%TYPE,
7: cp_term_cal_type IGS_CA_INST.cal_type%TYPE,
8: cp_term_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
9: SELECT spat.term_record_id

Line 6: cp_program_version IGS_PS_VER.version_number%TYPE,

2: /* $Header: IGSENB1B.pls 120.14 2005/11/28 02:26:46 appldev noship $ */
3:
4: CURSOR c_term_exists(cp_person_id IGS_PE_PERSON.person_id%TYPE,
5: cp_program_cd IGS_PS_VER.course_cd%TYPE,
6: cp_program_version IGS_PS_VER.version_number%TYPE,
7: cp_term_cal_type IGS_CA_INST.cal_type%TYPE,
8: cp_term_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
9: SELECT spat.term_record_id
10: FROM IGS_EN_SPA_TERMS spat, igs_ps_ver cv1

Line 10: FROM IGS_EN_SPA_TERMS spat, igs_ps_ver cv1

6: cp_program_version IGS_PS_VER.version_number%TYPE,
7: cp_term_cal_type IGS_CA_INST.cal_type%TYPE,
8: cp_term_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
9: SELECT spat.term_record_id
10: FROM IGS_EN_SPA_TERMS spat, igs_ps_ver cv1
11: WHERE spat.person_id = cp_person_id
12: AND spat.term_cal_type = cp_term_cal_type
13: AND spat.term_sequence_number = cp_term_sequence_number
14: AND cv1.course_cd = spat.program_cd

Line 20: FROM IGS_PS_VER cv2

16: AND
17: ( (
18: NVL(FND_PROFILE.VALUE('CAREER_MODEL_ENABLED'),'N') = 'Y'
19: AND cv1.course_type = (SELECT cv2.course_type
20: FROM IGS_PS_VER cv2
21: WHERE cv2.course_cd = cp_program_cd
22: AND cv2.version_number = cp_program_version)
23: )
24: OR

Line 135: l_program_cd IGS_PS_VER.course_cd%TYPE;

131: WHERE sub_cal_type = p_term_cal_type
132: and sub_ci_sequence_number = p_term_sequence_number
133: and sup_cal_type = cp_acad_cal_type;
134:
135: l_program_cd IGS_PS_VER.course_cd%TYPE;
136: l_dummy VARCHAR2(1);
137: l_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
138: BEGIN
139: OPEN c_key_record_exists;

Line 220: l_program_cd IGS_PS_VER.COURSE_CD%TYPE;

216: FROM igs_en_stdnt_ps_att
217: WHERE person_id = p_person_id
218: AND course_cd = p_program_cd;
219:
220: l_program_cd IGS_PS_VER.COURSE_CD%TYPE;
221:
222: BEGIN
223: --## 1. If term record exists for the effective term then get the attribute details
224: --## from it, set in EN_SPAT_REC_TYPE and exit

Line 400: cp_program_cd IGS_PS_VER.course_cd%TYPE,

396: ----------------------------------------------------------------------*/
397:
398: vc_career_model_enabled VARCHAR2(1);
399: CURSOR c_term_rec_exists(cp_person_id IGS_PE_PERSON.person_id%TYPE,
400: cp_program_cd IGS_PS_VER.course_cd%TYPE,
401: cp_program_version IGS_PS_VER.version_number%TYPE,
402: cp_term_cal_type IGS_CA_INST.cal_type%TYPE,
403: cp_term_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
404: SELECT spat.term_record_id

Line 401: cp_program_version IGS_PS_VER.version_number%TYPE,

397:
398: vc_career_model_enabled VARCHAR2(1);
399: CURSOR c_term_rec_exists(cp_person_id IGS_PE_PERSON.person_id%TYPE,
400: cp_program_cd IGS_PS_VER.course_cd%TYPE,
401: cp_program_version IGS_PS_VER.version_number%TYPE,
402: cp_term_cal_type IGS_CA_INST.cal_type%TYPE,
403: cp_term_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
404: SELECT spat.term_record_id
405: FROM IGS_EN_SPA_TERMS spat, igs_ps_ver cv1

Line 405: FROM IGS_EN_SPA_TERMS spat, igs_ps_ver cv1

401: cp_program_version IGS_PS_VER.version_number%TYPE,
402: cp_term_cal_type IGS_CA_INST.cal_type%TYPE,
403: cp_term_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
404: SELECT spat.term_record_id
405: FROM IGS_EN_SPA_TERMS spat, igs_ps_ver cv1
406: WHERE spat.person_id = cp_person_id
407: AND spat.term_cal_type = cp_term_cal_type
408: AND spat.term_sequence_number = cp_term_sequence_number
409: AND cv1.course_cd = spat.program_cd

Line 415: FROM IGS_PS_VER cv2

411: AND
412: ( (
413: NVL(FND_PROFILE.VALUE('CAREER_MODEL_ENABLED'),'N') = 'Y'
414: AND cv1.course_type = (SELECT cv2.course_type
415: FROM IGS_PS_VER cv2
416: WHERE cv2.course_cd = cp_program_cd
417: AND cv2.version_number = cp_program_version)
418: )
419: OR

Line 664: IGS_PS_VER cv

660: FROM IGS_EN_SPA_TERMS spat,
661: IGS_CA_INST_REL cr,
662: IGS_CA_INST_REL cr2,
663: IGS_CA_INST ci,
664: IGS_PS_VER cv
665: WHERE cr.sup_cal_type = cp_acad_cal_type
666: AND cr.sub_cal_type = p_term_cal_type
667: AND cr.sub_ci_sequence_number = p_term_sequence_number
668: AND cr.sup_cal_type = cr2.sup_cal_type

Line 686: FROM IGS_PS_VER cv2

682: AND (
683: (
684: cp_chk_othr_prms = 'Y' AND
685: cv.course_type = (SELECT course_type
686: FROM IGS_PS_VER cv2
687: WHERE cv2.course_cd = p_program_cd
688: AND cv2.version_number = cp_program_version)
689: )
690: OR

Line 837: IGS_PS_VER CV,

833: SPT.ATTENDANCE_TYPE,
834: SPT.FEE_CAT,
835: SPT.CLASS_STANDING_ID
836: FROM IGS_EN_SPA_TERMS SPT,
837: IGS_PS_VER CV,
838: IGS_CA_INST CI,
839: IGS_CA_INST CI2
840: WHERE SPT.PERSON_ID = :1
841: AND SPT.PROGRAM_CD = CV.COURSE_CD

Line 844: FROM IGS_PS_VER CV2

840: WHERE SPT.PERSON_ID = :1
841: AND SPT.PROGRAM_CD = CV.COURSE_CD
842: AND SPT.PROGRAM_VERSION = CV.VERSION_NUMBER
843: AND CV.COURSE_TYPE IN (SELECT CV2.COURSE_TYPE
844: FROM IGS_PS_VER CV2
845: WHERE CV2.COURSE_CD = :2
846: AND CV2.VERSION_NUMBER = :3)
847: AND CI2.CAL_TYPE = SPT.TERM_CAL_TYPE
848: AND CI2.SEQUENCE_NUMBER = SPT.TERM_SEQUENCE_NUMBER

Line 1036: cp_program_cd IGS_PS_VER.COURSE_CD%TYPE) IS

1032: ORDER BY ci.start_dt ASC;
1033:
1034: CURSOR c_other_recs ( cp_term_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
1035: cp_term_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE,
1036: cp_program_cd IGS_PS_VER.COURSE_CD%TYPE) IS
1037: SELECT *
1038: FROM IGS_EN_SPA_TERMS
1039: WHERE person_id = p_term_rec.person_id
1040: AND program_cd <> cp_program_cd

Line 1063: IGS_PS_VER CV,

1059: CI2.SEQUENCE_NUMBER,
1060: CI.CAL_TYPE,
1061: CI.SEQUENCE_NUMBER
1062: FROM IGS_EN_SPA_TERMS SPT,
1063: IGS_PS_VER CV,
1064: IGS_CA_INST CI,
1065: IGS_CA_INST CI2
1066: WHERE SPT.PERSON_ID = :1
1067: AND SPT.PROGRAM_CD = CV.COURSE_CD

Line 1070: FROM IGS_PS_VER CV2

1066: WHERE SPT.PERSON_ID = :1
1067: AND SPT.PROGRAM_CD = CV.COURSE_CD
1068: AND SPT.PROGRAM_VERSION = CV.VERSION_NUMBER
1069: AND CV.COURSE_TYPE IN (SELECT CV2.COURSE_TYPE
1070: FROM IGS_PS_VER CV2
1071: WHERE CV2.COURSE_CD = :2
1072: AND CV2.VERSION_NUMBER = :3)
1073: AND CI2.CAL_TYPE = SPT.TERM_CAL_TYPE
1074: AND CI2.SEQUENCE_NUMBER = SPT.TERM_SEQUENCE_NUMBER

Line 1345: IGS_PS_VER cv

1341: FROM IGS_EN_SPA_TERMS spat,
1342: IGS_CA_INST_REL cr,
1343: IGS_CA_INST_REL cr2,
1344: IGS_CA_INST ci,
1345: IGS_PS_VER cv
1346: WHERE cr.sub_cal_type = p_term_cal_type
1347: AND cr.sub_ci_sequence_number = p_term_sequence_number
1348: AND cr.sup_cal_type = cr2.sup_cal_type
1349: AND cr2.sub_cal_type = spat.term_cal_type

Line 1370: l_program_cd IGS_PS_VER.COURSE_CD%TYPE;

1366: l_message_name VARCHAR2(2000);
1367: l_term_rec EN_SPAT_REC_TYPE%TYPE;
1368: l_rowid ROWID;
1369: l_term_id IGS_EN_SPA_TERMS.term_record_id%TYPE;
1370: l_program_cd IGS_PS_VER.COURSE_CD%TYPE;
1371:
1372: BEGIN
1373: l_term_rec := p_term_rec;
1374: -- Reset all future key term records as Non-Key

Line 2123: l_key_program IGS_PS_VER.COURSE_CD%TYPE;

2119: p_program_cd IN VARCHAR2,
2120: p_term_cal_type IN VARCHAR2,
2121: p_term_sequence_NUMBER IN NUMBER
2122: ) RETURN VARCHAR2 AS
2123: l_key_program IGS_PS_VER.COURSE_CD%TYPE;
2124: BEGIN
2125: l_key_program := find_key_effective_for(p_person_id,p_term_cal_type, p_term_sequence_NUMBER);
2126: if (p_program_cd = l_key_program) THEN
2127: RETURN 'Y';

Line 2248: FROM igs_ps_ver ps,

2244:
2245: -- cursor to retrieve course_type for given program and person
2246: CURSOR cur_c2 IS
2247: SELECT ps.course_type
2248: FROM igs_ps_ver ps,
2249: igs_en_stdnt_ps_att spa
2250: WHERE
2251: spa.course_cd = p_program_cd AND
2252: spa.person_id = p_person_id AND

Line 2262: p_program_type = (SELECT course_type FROM igs_ps_ver

2258: CURSOR cur_c3(p_program_type IN VARCHAR2) IS
2259: SELECT 'x'
2260: FROM igs_en_spa_terms spat
2261: WHERE spat.person_id = p_person_id AND
2262: p_program_type = (SELECT course_type FROM igs_ps_ver
2263: WHERE course_cd = spat.program_cd
2264: AND version_number = spat.program_version)
2265: AND spat.term_cal_type = p_term_cal_type
2266: AND spat.term_sequence_number = p_term_sequence_number;

Line 2276: cp_program_type igs_ps_ver.course_type%TYPE,

2272: WHERE cal_type = cp_cal_type
2273: AND sequence_number = cp_ci_Sequence_number;
2274:
2275: CURSOR cur_c3prev (cp_person_id igs_en_spa_terms.person_id%TYPE,
2276: cp_program_type igs_ps_ver.course_type%TYPE,
2277: cp_start_dt IGS_CA_INST.START_DT%TYPE) IS
2278: SELECT
2279: SPAT.PROGRAM_CD
2280: FROM

Line 2286: FROM igs_ps_ver cv

2282: IGS_CA_INST CI2
2283: WHERE
2284: SPAT.PERSON_ID = cp_person_id AND
2285: cp_program_type = (SELECT course_type
2286: FROM igs_ps_ver cv
2287: WHERE spat.program_cd = cv.course_cd
2288: AND spat.program_version = cv.version_number) AND
2289: SPAT.TERM_CAL_TYPE = CI2.CAL_TYPE AND
2290: SPAT.TERM_SEQUENCE_NUMBER = CI2.SEQUENCE_NUMBER AND

Line 2306: l_program_type IGS_PS_VER.COURSE_TYPE%TYPE;

2302:
2303:
2304: l_primary_prg IGS_EN_STDNT_PS_ATT.PRIMARY_PROGRAM_TYPE%TYPE;
2305: l_profile VARCHAR2(1);
2306: l_program_type IGS_PS_VER.COURSE_TYPE%TYPE;
2307: l_check VARCHAR2(1);
2308: l_program_cd IGS_EN_STDNT_PS_ATT.COURSE_CD%TYPE;
2309: l_start_dt IGS_CA_INST.START_DT%TYPE;
2310: