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.

[Home] [Help]

APPS.IGS_PR_GEN_005 dependencies on IGS_CA_INST

Line 584: igs_ca_inst ci1

580: SELECT DISTINCT spc.prg_cal_type,
581: spc.prg_ci_sequence_number,
582: ci1.start_dt
583: FROM igs_pr_stdnt_pr_ck spc,
584: igs_ca_inst ci1
585: WHERE spc.person_id = p_person_id
586: AND spc.course_cd = p_course_cd
587: AND igs_pr_gen_001.prgp_get_cal_stream (
588: p_course_cd,

Line 596: FROM igs_ca_inst ci2

592: ) = 'Y'
593: AND ci1.cal_type = spc.prg_cal_type
594: AND ci1.sequence_number = spc.prg_ci_sequence_number
595: AND ci1.start_dt <= (SELECT ci2.start_dt
596: FROM igs_ca_inst ci2
597: WHERE ci2.cal_type = p_prg_cal_type
598: AND ci2.sequence_number = p_prg_sequence_number)
599: ORDER BY ci1.start_dt DESC;
600: CURSOR c_sprc (

Line 788: FROM igs_ca_inst ci

784: AND dai.dt_alias = spc.encumb_end_dt_alias
785: ORDER BY 1 DESC;
786: CURSOR c_ci IS
787: SELECT ci.end_dt
788: FROM igs_ca_inst ci
789: WHERE ci.cal_type = p_prg_cal_type
790: AND ci.sequence_number = p_prg_sequence_number;
791: BEGIN
792: OPEN c_dai_spc;

Line 862: v_latest_cal_type igs_ca_inst.cal_type%TYPE;

858: v_exclusion BOOLEAN DEFAULT FALSE;
859: v_suspension BOOLEAN DEFAULT FALSE;
860: v_probation BOOLEAN DEFAULT FALSE;
861: v_pending BOOLEAN DEFAULT FALSE;
862: v_latest_cal_type igs_ca_inst.cal_type%TYPE;
863: v_latest_sequence_number igs_ca_inst.sequence_number%TYPE;
864: CURSOR c_spo_ci IS
865: SELECT spo.prg_cal_type,
866: spo.prg_ci_sequence_number

Line 863: v_latest_sequence_number igs_ca_inst.sequence_number%TYPE;

859: v_suspension BOOLEAN DEFAULT FALSE;
860: v_probation BOOLEAN DEFAULT FALSE;
861: v_pending BOOLEAN DEFAULT FALSE;
862: v_latest_cal_type igs_ca_inst.cal_type%TYPE;
863: v_latest_sequence_number igs_ca_inst.sequence_number%TYPE;
864: CURSOR c_spo_ci IS
865: SELECT spo.prg_cal_type,
866: spo.prg_ci_sequence_number
867: FROM igs_pr_stdnt_pr_ou spo,

Line 868: igs_ca_inst ci,

864: CURSOR c_spo_ci IS
865: SELECT spo.prg_cal_type,
866: spo.prg_ci_sequence_number
867: FROM igs_pr_stdnt_pr_ou spo,
868: igs_ca_inst ci,
869: igs_pr_ou_type pot
870: WHERE spo.person_id = p_person_id
871: AND spo.course_cd = p_course_cd
872: AND spo.decision_status IN (cst_approved, cst_pending)

Line 888: cp_latest_cal_type igs_ca_inst.cal_type%TYPE,

884: AND spo.progression_outcome_type = pot.progression_outcome_type
885: AND pot.positive_outcome_ind = 'N'
886: ORDER BY ci.start_dt DESC;
887: CURSOR c_spo (
888: cp_latest_cal_type igs_ca_inst.cal_type%TYPE,
889: cp_latest_sequence_number igs_ca_inst.sequence_number%TYPE
890: ) IS
891: SELECT spo.course_cd,
892: spo.sequence_number,

Line 889: cp_latest_sequence_number igs_ca_inst.sequence_number%TYPE

885: AND pot.positive_outcome_ind = 'N'
886: ORDER BY ci.start_dt DESC;
887: CURSOR c_spo (
888: cp_latest_cal_type igs_ca_inst.cal_type%TYPE,
889: cp_latest_sequence_number igs_ca_inst.sequence_number%TYPE
890: ) IS
891: SELECT spo.course_cd,
892: spo.sequence_number,
893: spo.progression_outcome_type,

Line 1247: igs_ca_inst ci1

1243: CURSOR c_sprc IS
1244: SELECT DISTINCT sprc.prg_cal_type,
1245: sprc.prg_ci_sequence_number
1246: FROM igs_pr_sdt_pr_ru_ck sprc,
1247: igs_ca_inst ci1
1248: WHERE sprc.person_id = p_person_id
1249: AND sprc.course_cd = p_course_cd
1250: AND sprc.progression_rule_cat = p_progression_rule_cat
1251: AND sprc.pra_sequence_number = p_pra_sequence_number

Line 1256: FROM igs_ca_inst ci2

1252: AND sprc.prg_cal_type = ci1.cal_type
1253: AND sprc.prg_ci_sequence_number = ci1.sequence_number
1254: AND ci1.start_dt <= --gjha Changed to <= from <
1255: (SELECT ci2.start_dt
1256: FROM igs_ca_inst ci2
1257: WHERE ci2.cal_type = p_prg_cal_type
1258: AND ci2.sequence_number = p_prg_ci_sequence_number);
1259: CURSOR c_ci_ct_cs IS
1260: SELECT ci1.cal_type,

Line 1262: FROM igs_ca_inst ci1,

1258: AND ci2.sequence_number = p_prg_ci_sequence_number);
1259: CURSOR c_ci_ct_cs IS
1260: SELECT ci1.cal_type,
1261: ci1.sequence_number
1262: FROM igs_ca_inst ci1,
1263: igs_ca_type ct,
1264: igs_ca_stat cs
1265: WHERE ct.cal_type = ci1.cal_type
1266: AND ct.s_cal_cat = cst_progress

Line 1270: FROM igs_ca_inst ci2

1266: AND ct.s_cal_cat = cst_progress
1267: AND cs.cal_status = ci1.cal_status
1268: AND cs.s_cal_status = cst_active
1269: AND ci1.start_dt <= (SELECT ci2.start_dt
1270: FROM igs_ca_inst ci2
1271: WHERE ci2.cal_type = p_prg_cal_type
1272: AND ci2.sequence_number = p_prg_ci_sequence_number)
1273: AND (-- Logic from CALP_GET_CAL_STREAM.
1274: EXISTS ( SELECT 'x'

Line 1310: igs_ca_inst_rel cir

1306: )
1307: AND EXISTS ( -- Units must exist within the progression calendar.
1308: SELECT 'X'
1309: FROM igs_en_su_attempt sua,
1310: igs_ca_inst_rel cir
1311: WHERE sua.person_id = p_person_id
1312: AND sua.course_cd = p_course_cd
1313: AND cir.sup_cal_type = ci1.cal_type
1314: AND cir.sup_ci_sequence_number = ci1.sequence_number

Line 1549: igs_ca_inst_rel cir

1545: sua.unit_attempt_status,
1546: sua.discontinued_dt,
1547: sua.uoo_id
1548: FROM igs_en_su_attempt sua,
1549: igs_ca_inst_rel cir
1550: WHERE sua.person_id = p_person_id
1551: AND sua.course_cd = p_course_cd
1552: AND sua.unit_attempt_status IN (cst_enrolled, cst_discontin, cst_completed)
1553: AND cir.sup_cal_type = p_prg_cal_type