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_PR_GEN_004 dependencies on IGS_CA_INST

Line 76: FROM IGS_CA_INST_REL cir,

72: sca.course_cd = p_course_cd;
73: CURSOR c_cir IS
74: SELECT cir.sup_cal_type,
75: cir.sup_ci_sequence_number
76: FROM IGS_CA_INST_REL cir,
77: IGS_CA_INST ci,
78: IGS_CA_TYPE ct,
79: IGS_CA_STAT cs
80: WHERE cir.sub_cal_type = p_cal_type AND

Line 77: IGS_CA_INST ci,

73: CURSOR c_cir IS
74: SELECT cir.sup_cal_type,
75: cir.sup_ci_sequence_number
76: FROM IGS_CA_INST_REL cir,
77: IGS_CA_INST ci,
78: IGS_CA_TYPE ct,
79: IGS_CA_STAT cs
80: WHERE cir.sub_cal_type = p_cal_type AND
81: cir.sub_ci_sequence_number = p_ci_sequence_number AND

Line 201: l_load_cal_type IGS_CA_INST.CAL_TYPE%TYPE;

197: WHERE teach_cal_type = p_teach_cal_type
198: AND teach_ci_sequence_number = p_teach_ci_sequence_number
199: ORDER BY LOAD_START_DT ASC;
200:
201: l_load_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
202: l_load_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
203: l_return_status VARCHAR2(10);
204:
205: BEGIN

Line 202: l_load_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;

198: AND teach_ci_sequence_number = p_teach_ci_sequence_number
199: ORDER BY LOAD_START_DT ASC;
200:
201: l_load_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
202: l_load_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
203: l_return_status VARCHAR2(10);
204:
205: BEGIN
206:

Line 323: v_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;

319: v_expiry_status VARCHAR2(10);
320: v_expiry_dt DATE;
321: v_authorising_person_id IGS_PE_person.person_id%TYPE;
322: v_new_pra_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE;
323: v_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
324: v_message_text VARCHAR2(2000);
325: v_message_level VARCHAR2(10);
326: v_message_name VARCHAR2(30);
327: v_administrative_unit_status IGS_PS_UNIT_DISC_CRT.administrative_unit_status%TYPE;

Line 458: IGS_CA_INST ci1

454: EXISTS
455: (
456: SELECT 'X'
457: FROM IGS_AS_SC_ATMPT_ENR scae,
458: IGS_CA_INST ci1
459: WHERE sca.person_id = scae.person_id AND
460: sca.course_cd = scae.course_cd AND
461: scae.enrolment_cat = p_enrolment_cat AND
462: ci1.cal_type = scae.cal_type AND

Line 468: IGS_CA_INST ci2

464: ci1.end_dt =
465: (
466: SELECT MAX(ci2.end_dt)
467: FROM IGS_AS_SC_ATMPT_ENR scae2,
468: IGS_CA_INST ci2
469: WHERE
470: scae2.person_id = scae.person_id AND
471: scae2.course_cd = scae.course_cd AND
472: ci2.cal_type = scae2.cal_type AND

Line 693: cp_prg_cal_type IGS_CA_INST.cal_type%TYPE,

689: pra.spo_course_cd = cp_spo_course_cd AND
690: pra.spo_sequence_number = cp_spo_sequence_number ; -- commented by Prajeesh
691: --FOR UPDATE NOWAIT;
692: CURSOR c_ci (
693: cp_prg_cal_type IGS_CA_INST.cal_type%TYPE,
694: cp_spo_cal_type IGS_CA_INST.cal_type%TYPE,
695: cp_spo_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
696: SELECT ci1.sequence_number
697: FROM IGS_CA_INST ci1,

Line 694: cp_spo_cal_type IGS_CA_INST.cal_type%TYPE,

690: pra.spo_sequence_number = cp_spo_sequence_number ; -- commented by Prajeesh
691: --FOR UPDATE NOWAIT;
692: CURSOR c_ci (
693: cp_prg_cal_type IGS_CA_INST.cal_type%TYPE,
694: cp_spo_cal_type IGS_CA_INST.cal_type%TYPE,
695: cp_spo_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
696: SELECT ci1.sequence_number
697: FROM IGS_CA_INST ci1,
698: IGS_CA_STAT cs

Line 695: cp_spo_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

691: --FOR UPDATE NOWAIT;
692: CURSOR c_ci (
693: cp_prg_cal_type IGS_CA_INST.cal_type%TYPE,
694: cp_spo_cal_type IGS_CA_INST.cal_type%TYPE,
695: cp_spo_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
696: SELECT ci1.sequence_number
697: FROM IGS_CA_INST ci1,
698: IGS_CA_STAT cs
699: WHERE ci1.cal_type = cp_prg_cal_type AND

Line 697: FROM IGS_CA_INST ci1,

693: cp_prg_cal_type IGS_CA_INST.cal_type%TYPE,
694: cp_spo_cal_type IGS_CA_INST.cal_type%TYPE,
695: cp_spo_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
696: SELECT ci1.sequence_number
697: FROM IGS_CA_INST ci1,
698: IGS_CA_STAT cs
699: WHERE ci1.cal_type = cp_prg_cal_type AND
700: cs.CAL_STATUS = ci1.CAL_STATUS AND
701: cs.s_CAL_STATUS = cst_active AND

Line 704: FROM IGS_CA_INST ci2

700: cs.CAL_STATUS = ci1.CAL_STATUS AND
701: cs.s_CAL_STATUS = cst_active AND
702: ci1.start_dt >
703: (SELECT ci2.start_dt
704: FROM IGS_CA_INST ci2
705: WHERE ci2.cal_type = cp_spo_cal_type AND
706: ci2.sequence_number = cp_spo_sequence_number)
707: ORDER BY ci1.start_dt ASC;
708: CURSOR c_pra_upd1 (

Line 799: p_prg_cal_type IGS_CA_INST.cal_type%TYPE,

795: p_log_creation_dt IGS_GE_s_log.creation_dt%TYPE,
796: p_record_type VARCHAR2,
797: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
798: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
799: p_prg_cal_type IGS_CA_INST.cal_type%TYPE,
800: p_prg_sequence_number IGS_CA_INST.sequence_number%TYPE,
801: p_spo_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE,
802: p_progression_outcome_type IGS_PR_STDNT_PR_OU.progression_outcome_type%TYPE,
803: p_duration_type IGS_PR_STDNT_PR_OU.duration_type%TYPE,

Line 800: p_prg_sequence_number IGS_CA_INST.sequence_number%TYPE,

796: p_record_type VARCHAR2,
797: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
798: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
799: p_prg_cal_type IGS_CA_INST.cal_type%TYPE,
800: p_prg_sequence_number IGS_CA_INST.sequence_number%TYPE,
801: p_spo_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE,
802: p_progression_outcome_type IGS_PR_STDNT_PR_OU.progression_outcome_type%TYPE,
803: p_duration_type IGS_PR_STDNT_PR_OU.duration_type%TYPE,
804: p_duration IGS_PR_STDNT_PR_OU.duration%TYPE,

Line 805: p_ci_cal_type IGS_CA_INST.cal_type%TYPE,

801: p_spo_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE,
802: p_progression_outcome_type IGS_PR_STDNT_PR_OU.progression_outcome_type%TYPE,
803: p_duration_type IGS_PR_STDNT_PR_OU.duration_type%TYPE,
804: p_duration IGS_PR_STDNT_PR_OU.duration%TYPE,
805: p_ci_cal_type IGS_CA_INST.cal_type%TYPE,
806: p_message_name VARCHAR2,
807: p_text IGS_GE_s_log_entry.text%TYPE
808: ) IS
809: --rvangala 07-OCT-2003 Value for CORE_INDICATOR_CODE passed to IGS_EN_SUA_API.UPDATE_UNIT_ATTEMPT

Line 2721: FROM IGS_CA_INST ci,

2717: ci.alternate_code,
2718: IGS_EN_GEN_014.ENRS_GET_ACAD_ALT_CD(
2719: ci.cal_type,
2720: ci.sequence_number) acad_alternate_code
2721: FROM IGS_CA_INST ci,
2722: IGS_CA_TYPE cat,
2723: IGS_CA_STAT cs
2724: WHERE (p_prg_cal_type IS NULL OR
2725: (ci.cal_type = p_prg_cal_type AND

Line 2780: p_ci_cal_type IGS_CA_INST.cal_type%TYPE,

2776: FUNCTION prgpl_upd_check_readiness (
2777: p_sca_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
2778: p_sca_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
2779: p_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,
2780: p_ci_cal_type IGS_CA_INST.cal_type%TYPE,
2781: p_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
2782: p_outcome_check_type IGS_PR_S_PRG_CONF.outcome_check_type%TYPE)
2783: RETURN VARCHAR2
2784: IS

Line 2781: p_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,

2777: p_sca_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
2778: p_sca_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
2779: p_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,
2780: p_ci_cal_type IGS_CA_INST.cal_type%TYPE,
2781: p_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
2782: p_outcome_check_type IGS_PR_S_PRG_CONF.outcome_check_type%TYPE)
2783: RETURN VARCHAR2
2784: IS
2785: BEGIN -- prgpl_upd_check_readiness

Line 2844: p_ci_cal_type igs_ca_inst.cal_type%TYPE,

2840: --
2841: --
2842: --
2843: PROCEDURE prgpl_upd_initial_appl (
2844: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
2845: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE
2846: ) IS
2847: BEGIN -- prgpl_upd_initial_appl
2848: DECLARE

Line 2845: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE

2841: --
2842: --
2843: PROCEDURE prgpl_upd_initial_appl (
2844: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
2845: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE
2846: ) IS
2847: BEGIN -- prgpl_upd_initial_appl
2848: DECLARE
2849: v_apply_start_dt_alias igs_pr_s_prg_conf.apply_start_dt_alias%TYPE;

Line 2876: igs_ca_inst_all ci

2872: cp_course_cd IN VARCHAR2
2873: ) IS
2874: SELECT scae.enrolment_cat enrolment_cat
2875: FROM igs_as_sc_atmpt_enr scae,
2876: igs_ca_inst_all ci
2877: WHERE scae.person_id = cp_person_id
2878: AND scae.course_cd = cp_course_cd
2879: AND scae.cal_type = ci.cal_type
2880: AND scae.ci_sequence_number = ci.sequence_number

Line 2891: from_clause := from_clause || 'FROM igs_en_stdnt_ps_att_all sca, igs_en_su_attempt_all sua, igs_ca_inst_rel cir';

2887: process_record BOOLEAN := TRUE;
2888: --
2889: BEGIN
2890: --
2891: from_clause := from_clause || 'FROM igs_en_stdnt_ps_att_all sca, igs_en_su_attempt_all sua, igs_ca_inst_rel cir';
2892: --
2893: -- Append Person ID Group filter to the Where clause only when it is passed
2894: --
2895: IF (p_group_id IS NOT NULL) THEN

Line 3131: IGS_CA_INST ci1

3127: (p_enrolment_cat IS NULL OR
3128: EXISTS (
3129: SELECT 'X'
3130: FROM IGS_AS_SC_ATMPT_ENR scae,
3131: IGS_CA_INST ci1
3132: WHERE sca.person_id = scae.person_id AND
3133: sca.course_cd = scae.course_cd AND
3134: scae.enrolment_cat = p_enrolment_cat AND
3135: ci1.cal_type = scae.cal_type AND

Line 3140: IGS_CA_INST ci2

3136: ci1.sequence_number = scae.ci_sequence_number AND
3137: ci1.end_dt =
3138: (SELECT MAX(ci2.end_dt)
3139: FROM IGS_AS_SC_ATMPT_ENR scae2,
3140: IGS_CA_INST ci2
3141: WHERE scae2.person_id = scae.person_id AND
3142: scae2.course_cd = scae.course_cd AND
3143: ci2.cal_type = scae2.cal_type AND
3144: ci2.sequence_number = scae2.ci_sequence_number)));

Line 3199: cp_cal_type IGS_CA_INST.cal_type%TYPE,

3195: FROM IGS_PR_STDNT_PR_CK spc
3196: WHERE spc.person_id = cp_person_id AND
3197: spc.course_cd = cp_course_cd;
3198: CURSOR c_spc2 (
3199: cp_cal_type IGS_CA_INST.cal_type%TYPE,
3200: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
3201: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
3202: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
3203: SELECT spc.prg_cal_type,

Line 3200: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,

3196: WHERE spc.person_id = cp_person_id AND
3197: spc.course_cd = cp_course_cd;
3198: CURSOR c_spc2 (
3199: cp_cal_type IGS_CA_INST.cal_type%TYPE,
3200: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
3201: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
3202: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
3203: SELECT spc.prg_cal_type,
3204: spc.prg_ci_sequence_number

Line 3206: IGS_CA_INST ci1

3202: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
3203: SELECT spc.prg_cal_type,
3204: spc.prg_ci_sequence_number
3205: FROM IGS_PR_STDNT_PR_CK spc,
3206: IGS_CA_INST ci1
3207: WHERE spc.person_id = cp_person_id AND
3208: spc.course_cd = cp_course_cd AND
3209: ci1.cal_type = spc.prg_cal_type AND
3210: ci1.sequence_number = spc.prg_ci_sequence_number AND

Line 3215: FROM IGS_CA_INST_REL cir,

3211: ci1.start_dt >=
3212: -- On or after the first progression period linked to the student unit
3213: -- attempt
3214: (SELECT MIN(ci2.start_dt)
3215: FROM IGS_CA_INST_REL cir,
3216: IGS_CA_INST ci2,
3217: IGS_CA_STAT cs,
3218: IGS_CA_TYPE cat
3219: WHERE cir.sub_cal_type = cp_cal_type AND

Line 3216: IGS_CA_INST ci2,

3212: -- On or after the first progression period linked to the student unit
3213: -- attempt
3214: (SELECT MIN(ci2.start_dt)
3215: FROM IGS_CA_INST_REL cir,
3216: IGS_CA_INST ci2,
3217: IGS_CA_STAT cs,
3218: IGS_CA_TYPE cat
3219: WHERE cir.sub_cal_type = cp_cal_type AND
3220: cir.sub_ci_sequence_number = cp_ci_sequence_number AND

Line 3228: cal_type IGS_CA_INST.cal_type%TYPE,

3224: cat.s_cal_cat = cst_progress AND
3225: cs.CAL_STATUS = ci2.CAL_STATUS AND
3226: cs.s_CAL_STATUS = cst_active);
3227: TYPE r_ci_record_type IS RECORD (
3228: cal_type IGS_CA_INST.cal_type%TYPE,
3229: sequence_number IGS_CA_INST.sequence_number%TYPE);
3230: r_ci_record r_ci_record_type;
3231: TYPE t_ci_type IS TABLE OF r_ci_record%TYPE
3232: INDEX BY BINARY_INTEGER;

Line 3229: sequence_number IGS_CA_INST.sequence_number%TYPE);

3225: cs.CAL_STATUS = ci2.CAL_STATUS AND
3226: cs.s_CAL_STATUS = cst_active);
3227: TYPE r_ci_record_type IS RECORD (
3228: cal_type IGS_CA_INST.cal_type%TYPE,
3229: sequence_number IGS_CA_INST.sequence_number%TYPE);
3230: r_ci_record r_ci_record_type;
3231: TYPE t_ci_type IS TABLE OF r_ci_record%TYPE
3232: INDEX BY BINARY_INTEGER;
3233: v_ci_table t_ci_type;

Line 4820: p_prg_cal_type IGS_CA_INST.cal_type%TYPE,

4816:
4817: FUNCTION prgpl_match_att_type (
4818: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
4819: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
4820: p_prg_cal_type IGS_CA_INST.cal_type%TYPE,
4821: p_prg_sequence_number IGS_CA_INST.sequence_number%TYPE,
4822: p_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE)
4823: RETURN VARCHAR2
4824: IS

Line 4821: p_prg_sequence_number IGS_CA_INST.sequence_number%TYPE,

4817: FUNCTION prgpl_match_att_type (
4818: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
4819: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
4820: p_prg_cal_type IGS_CA_INST.cal_type%TYPE,
4821: p_prg_sequence_number IGS_CA_INST.sequence_number%TYPE,
4822: p_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE)
4823: RETURN VARCHAR2
4824: IS
4825: BEGIN -- prgpl_match_att_type

Line 4833: v_sub_cal_type IGS_CA_INST.cal_type%TYPE;

4829: DECLARE
4830: cst_active CONSTANT VARCHAR2(10) := 'ACTIVE';
4831: cst_load CONSTANT VARCHAR2(10) := 'LOAD';
4832: cst_no_load CONSTANT VARCHAR2(10) := 'NO-LOAD';
4833: v_sub_cal_type IGS_CA_INST.cal_type%TYPE;
4834: v_sub_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
4835: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
4836: CURSOR c_cir IS
4837: SELECT cir.sub_cal_type,

Line 4834: v_sub_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;

4830: cst_active CONSTANT VARCHAR2(10) := 'ACTIVE';
4831: cst_load CONSTANT VARCHAR2(10) := 'LOAD';
4832: cst_no_load CONSTANT VARCHAR2(10) := 'NO-LOAD';
4833: v_sub_cal_type IGS_CA_INST.cal_type%TYPE;
4834: v_sub_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
4835: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
4836: CURSOR c_cir IS
4837: SELECT cir.sub_cal_type,
4838: cir.sub_ci_sequence_number

Line 4839: FROM IGS_CA_INST ci,

4835: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
4836: CURSOR c_cir IS
4837: SELECT cir.sub_cal_type,
4838: cir.sub_ci_sequence_number
4839: FROM IGS_CA_INST ci,
4840: IGS_CA_INST_REL cir,
4841: IGS_CA_TYPE cat,
4842: IGS_CA_STAT cs
4843: WHERE cir.sup_cal_type = p_prg_cal_type AND

Line 4840: IGS_CA_INST_REL cir,

4836: CURSOR c_cir IS
4837: SELECT cir.sub_cal_type,
4838: cir.sub_ci_sequence_number
4839: FROM IGS_CA_INST ci,
4840: IGS_CA_INST_REL cir,
4841: IGS_CA_TYPE cat,
4842: IGS_CA_STAT cs
4843: WHERE cir.sup_cal_type = p_prg_cal_type AND
4844: cir.sup_ci_sequence_number = p_prg_sequence_number AND

Line 4903: p_prg_cal_type IGS_CA_INST.cal_type%TYPE,

4899: --------------------------------------------------------------------------------
4900: FUNCTION prgpl_match_class_standing (
4901: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
4902: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
4903: p_prg_cal_type IGS_CA_INST.cal_type%TYPE,
4904: p_prg_sequence_number IGS_CA_INST.sequence_number%TYPE,
4905: p_igs_pr_class_std_id IGS_PR_CLASS_STD.igs_pr_class_std_id%TYPE)
4906: RETURN VARCHAR2 AS
4907: BEGIN -- prgpl_match_class_standing

Line 4904: p_prg_sequence_number IGS_CA_INST.sequence_number%TYPE,

4900: FUNCTION prgpl_match_class_standing (
4901: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
4902: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
4903: p_prg_cal_type IGS_CA_INST.cal_type%TYPE,
4904: p_prg_sequence_number IGS_CA_INST.sequence_number%TYPE,
4905: p_igs_pr_class_std_id IGS_PR_CLASS_STD.igs_pr_class_std_id%TYPE)
4906: RETURN VARCHAR2 AS
4907: BEGIN -- prgpl_match_class_standing
4908: -- If the sprav.igs_pr_class_std_id is set, then the student must be of

Line 4915: v_sub_cal_type IGS_CA_INST.cal_type%TYPE;

4911: DECLARE
4912: cst_active CONSTANT VARCHAR2(10) := 'ACTIVE';
4913: cst_load CONSTANT VARCHAR2(10) := 'LOAD';
4914: cst_no_load CONSTANT VARCHAR2(10) := 'NO-LOAD';
4915: v_sub_cal_type IGS_CA_INST.cal_type%TYPE;
4916:
4917: v_sub_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
4918: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
4919: v_class_standing IGS_PR_CLASS_STD.CLASS_STANDING%TYPE;

Line 4917: v_sub_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;

4913: cst_load CONSTANT VARCHAR2(10) := 'LOAD';
4914: cst_no_load CONSTANT VARCHAR2(10) := 'NO-LOAD';
4915: v_sub_cal_type IGS_CA_INST.cal_type%TYPE;
4916:
4917: v_sub_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
4918: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
4919: v_class_standing IGS_PR_CLASS_STD.CLASS_STANDING%TYPE;
4920: v_derived_class_standing IGS_PR_CLASS_STD.CLASS_STANDING%TYPE;
4921: CURSOR c_cir IS

Line 4924: FROM IGS_CA_INST ci,

4920: v_derived_class_standing IGS_PR_CLASS_STD.CLASS_STANDING%TYPE;
4921: CURSOR c_cir IS
4922: SELECT cir.sub_cal_type,
4923: cir.sub_ci_sequence_number
4924: FROM IGS_CA_INST ci,
4925: IGS_CA_INST_REL cir,
4926: IGS_CA_TYPE cat,
4927: IGS_CA_STAT cs
4928: WHERE cir.sup_cal_type = p_prg_cal_type AND

Line 4925: IGS_CA_INST_REL cir,

4921: CURSOR c_cir IS
4922: SELECT cir.sub_cal_type,
4923: cir.sub_ci_sequence_number
4924: FROM IGS_CA_INST ci,
4925: IGS_CA_INST_REL cir,
4926: IGS_CA_TYPE cat,
4927: IGS_CA_STAT cs
4928: WHERE cir.sup_cal_type = p_prg_cal_type AND
4929: cir.sup_ci_sequence_number = p_prg_sequence_number AND

Line 5008: p_prg_cal_type IGS_CA_INST.cal_type%TYPE,

5004:
5005: FUNCTION prgpl_match_cp_range (
5006: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
5007: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
5008: p_prg_cal_type IGS_CA_INST.cal_type%TYPE,
5009: p_prg_sequence_number IGS_CA_INST.sequence_number%TYPE,
5010: p_min_cp IGS_PR_RU_APPL.min_cp%TYPE,
5011: p_max_cp IGS_PR_RU_APPL.max_cp%TYPE)
5012: RETURN VARCHAR2 AS

Line 5009: p_prg_sequence_number IGS_CA_INST.sequence_number%TYPE,

5005: FUNCTION prgpl_match_cp_range (
5006: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
5007: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
5008: p_prg_cal_type IGS_CA_INST.cal_type%TYPE,
5009: p_prg_sequence_number IGS_CA_INST.sequence_number%TYPE,
5010: p_min_cp IGS_PR_RU_APPL.min_cp%TYPE,
5011: p_max_cp IGS_PR_RU_APPL.max_cp%TYPE)
5012: RETURN VARCHAR2 AS
5013: BEGIN -- prgpl_match_cp_range

Line 5022: v_sub_cal_type IGS_CA_INST.cal_type%TYPE;

5018: DECLARE
5019: cst_active CONSTANT VARCHAR2(10) := 'ACTIVE';
5020: cst_load CONSTANT VARCHAR2(10) := 'LOAD';
5021: cst_no_load CONSTANT VARCHAR2(10) := 'NO-LOAD';
5022: v_sub_cal_type IGS_CA_INST.cal_type%TYPE;
5023: v_sub_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
5024: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
5025: v_earned_cp NUMBER;
5026: v_attempted_cp NUMBER;

Line 5023: v_sub_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;

5019: cst_active CONSTANT VARCHAR2(10) := 'ACTIVE';
5020: cst_load CONSTANT VARCHAR2(10) := 'LOAD';
5021: cst_no_load CONSTANT VARCHAR2(10) := 'NO-LOAD';
5022: v_sub_cal_type IGS_CA_INST.cal_type%TYPE;
5023: v_sub_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
5024: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
5025: v_earned_cp NUMBER;
5026: v_attempted_cp NUMBER;
5027: v_return_status VARCHAR2(1);

Line 5034: FROM IGS_CA_INST ci,

5030:
5031: CURSOR c_cir IS
5032: SELECT cir.sub_cal_type,
5033: cir.sub_ci_sequence_number
5034: FROM IGS_CA_INST ci,
5035: IGS_CA_INST_REL cir,
5036: IGS_CA_TYPE cat,
5037: IGS_CA_STAT cs
5038: WHERE cir.sup_cal_type = p_prg_cal_type AND

Line 5035: IGS_CA_INST_REL cir,

5031: CURSOR c_cir IS
5032: SELECT cir.sub_cal_type,
5033: cir.sub_ci_sequence_number
5034: FROM IGS_CA_INST ci,
5035: IGS_CA_INST_REL cir,
5036: IGS_CA_TYPE cat,
5037: IGS_CA_STAT cs
5038: WHERE cir.sup_cal_type = p_prg_cal_type AND
5039: cir.sup_ci_sequence_number = p_prg_sequence_number AND

Line 5441: CURSOR c_ci (cp_prg_cal_type IGS_CA_INST.cal_type%TYPE,

5437: v_process_cat BOOLEAN;
5438: v_still_valid BOOLEAN;
5439: v_dummy VARCHAR2(1);
5440:
5441: CURSOR c_ci (cp_prg_cal_type IGS_CA_INST.cal_type%TYPE,
5442: cp_prg_sequence_number IGS_CA_INST.sequence_number%TYPE,
5443: cp_start_sequence_number IGS_CA_INST.sequence_number%TYPE,
5444: cp_check_type VARCHAR2) IS
5445: SELECT 'X'

Line 5442: cp_prg_sequence_number IGS_CA_INST.sequence_number%TYPE,

5438: v_still_valid BOOLEAN;
5439: v_dummy VARCHAR2(1);
5440:
5441: CURSOR c_ci (cp_prg_cal_type IGS_CA_INST.cal_type%TYPE,
5442: cp_prg_sequence_number IGS_CA_INST.sequence_number%TYPE,
5443: cp_start_sequence_number IGS_CA_INST.sequence_number%TYPE,
5444: cp_check_type VARCHAR2) IS
5445: SELECT 'X'
5446: FROM igs_ca_inst ci, igs_ca_inst ci1

Line 5443: cp_start_sequence_number IGS_CA_INST.sequence_number%TYPE,

5439: v_dummy VARCHAR2(1);
5440:
5441: CURSOR c_ci (cp_prg_cal_type IGS_CA_INST.cal_type%TYPE,
5442: cp_prg_sequence_number IGS_CA_INST.sequence_number%TYPE,
5443: cp_start_sequence_number IGS_CA_INST.sequence_number%TYPE,
5444: cp_check_type VARCHAR2) IS
5445: SELECT 'X'
5446: FROM igs_ca_inst ci, igs_ca_inst ci1
5447: WHERE ci.cal_type = cp_prg_cal_type

Line 5446: FROM igs_ca_inst ci, igs_ca_inst ci1

5442: cp_prg_sequence_number IGS_CA_INST.sequence_number%TYPE,
5443: cp_start_sequence_number IGS_CA_INST.sequence_number%TYPE,
5444: cp_check_type VARCHAR2) IS
5445: SELECT 'X'
5446: FROM igs_ca_inst ci, igs_ca_inst ci1
5447: WHERE ci.cal_type = cp_prg_cal_type
5448: AND ci.sequence_number = cp_prg_sequence_number
5449: AND ci1.cal_type = cp_prg_cal_type
5450: AND ci1.sequence_number = cp_start_sequence_number

Line 5455: CURSOR c_progression_rule_cat(cp_cal_type IGS_CA_INST.cal_type%TYPE) IS

5451: AND ( (cp_check_type = cst_start AND ci1.start_dt > ci.start_dt)
5452: OR (cp_check_type = cst_end AND ci1.start_dt <= ci.start_dt)
5453: );
5454:
5455: CURSOR c_progression_rule_cat(cp_cal_type IGS_CA_INST.cal_type%TYPE) IS
5456: SELECT pra.progression_rule_cat, pra.s_relation_type
5457: FROM igs_pr_ru_appl pra, igs_pr_ru_ca_type_v prctv
5458: WHERE pra.s_relation_type IN (cst_sca, cst_crv, cst_ou, cst_cty)
5459: AND pra.progression_rule_cat = prctv.progression_rule_cat

Line 5475: cp_cal_type IGS_CA_INST.cal_type%TYPE) IS

5471:
5472: CURSOR c_pra_cst_sca (cp_prg_rule_cat IGS_PR_RU_APPL.progression_rule_cat%TYPE,
5473: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
5474: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
5475: cp_cal_type IGS_CA_INST.cal_type%TYPE) IS
5476: SELECT pra.progression_rule_cat, pra.sequence_number, pra.s_relation_type,
5477: pra.progression_rule_cd, pra.rul_sequence_number, pra.attendance_type,
5478: pra.reference_cd, pra.igs_pr_class_std_id, pra.min_cp, pra.max_cp,
5479: prctv.start_sequence_number, prctv.end_sequence_number,

Line 5497: cp_cal_type IGS_CA_INST.cal_type%TYPE) IS

5493:
5494: CURSOR c_pra_cst_crv (cp_prg_rule_cat IGS_PR_RU_APPL.progression_rule_cat%TYPE,
5495: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
5496: cp_version_number IGS_PR_RU_APPL.crv_version_number%TYPE,
5497: cp_cal_type IGS_CA_INST.cal_type%TYPE) IS
5498: SELECT pra.progression_rule_cat, pra.sequence_number, pra.s_relation_type,
5499: pra.progression_rule_cd, pra.rul_sequence_number, pra.attendance_type,
5500: pra.reference_cd, pra.igs_pr_class_std_id, pra.min_cp, pra.max_cp,
5501: prctv.start_sequence_number, prctv.end_sequence_number,

Line 5519: cp_cal_type IGS_CA_INST.cal_type%TYPE) IS

5515:
5516: CURSOR c_pra_cst_ou (cp_prg_rule_cat IGS_PR_RU_APPL.progression_rule_cat%TYPE,
5517: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
5518: cp_version_number IGS_PR_RU_APPL.crv_version_number%TYPE,
5519: cp_cal_type IGS_CA_INST.cal_type%TYPE) IS
5520: SELECT pra.progression_rule_cat, pra.sequence_number, pra.s_relation_type,
5521: pra.progression_rule_cd, pra.rul_sequence_number, pra.attendance_type,
5522: pra.reference_cd, pra.igs_pr_class_std_id, pra.min_cp, pra.max_cp,
5523: prctv.start_sequence_number, prctv.end_sequence_number,

Line 5587: cp_cal_type IGS_CA_INST.cal_type%TYPE) IS

5583:
5584: CURSOR c_pra_cst_cty (cp_prg_rule_cat IGS_PR_RU_APPL.progression_rule_cat%TYPE,
5585: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
5586: cp_version_number IGS_PR_RU_APPL.crv_version_number%TYPE,
5587: cp_cal_type IGS_CA_INST.cal_type%TYPE) IS
5588: SELECT pra.progression_rule_cat, pra.sequence_number, pra.s_relation_type,
5589: pra.progression_rule_cd, pra.rul_sequence_number, pra.attendance_type,
5590: pra.reference_cd, pra.igs_pr_class_std_id, pra.min_cp, pra.max_cp,
5591: prctv.start_sequence_number, prctv.end_sequence_number,