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_PR_CLASS_STD

Line 2257: X_IGS_PR_CLASS_STD_ID => v_pra_upd_rec.IGS_PR_CLASS_STD_ID

2253: X_MESSAGE => v_pra_upd_rec.MESSAGE,
2254: X_MODE => 'R',
2255: X_MIN_CP => v_pra_upd_rec.MIN_CP,
2256: X_MAX_CP => v_pra_upd_rec.MAX_CP,
2257: X_IGS_PR_CLASS_STD_ID => v_pra_upd_rec.IGS_PR_CLASS_STD_ID
2258: );
2259:
2260: END LOOP; -- c_pra_upd2
2261: EXCEPTION

Line 2469: X_IGS_PR_CLASS_STD_ID => v_sca_rec.IGS_PR_CLASS_STD_ID,

2465: X_OVERRIDE_TIME_LIMITATION => v_sca_rec.OVERRIDE_TIME_LIMITATION,
2466: X_MODE => 'R',
2467: X_LAST_DATE_OF_ATTENDANCE => v_sca_rec.LAST_DATE_OF_ATTENDANCE,
2468: X_DROPPED_BY => v_sca_rec.DROPPED_BY,
2469: X_IGS_PR_CLASS_STD_ID => v_sca_rec.IGS_PR_CLASS_STD_ID,
2470: X_PRIMARY_PROGRAM_TYPE => v_sca_rec.PRIMARY_PROGRAM_TYPE,
2471: X_PRIMARY_PROG_TYPE_SOURCE => v_sca_rec.PRIMARY_PROG_TYPE_SOURCE,
2472: X_CATALOG_CAL_TYPE => v_sca_rec.CATALOG_CAL_TYPE,
2473: X_CATALOG_SEQ_NUM => v_sca_rec.CATALOG_SEQ_NUM,

Line 2588: X_IGS_PR_CLASS_STD_ID => v_pra_upd_rec.IGS_PR_CLASS_STD_ID

2584: X_MESSAGE => v_pra_upd_rec.MESSAGE,
2585: X_MODE => 'R',
2586: X_MIN_CP => v_pra_upd_rec.MIN_CP,
2587: X_MAX_CP => v_pra_upd_rec.MAX_CP,
2588: X_IGS_PR_CLASS_STD_ID => v_pra_upd_rec.IGS_PR_CLASS_STD_ID
2589: );
2590: END LOOP; -- c_pra_upd1
2591: EXCEPTION
2592: WHEN e_record_locked THEN

Line 4905: p_igs_pr_class_std_id IGS_PR_CLASS_STD.igs_pr_class_std_id%TYPE)

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
4909: -- the appropriate Class Standing type within the progression period.

Line 4908: -- If the sprav.igs_pr_class_std_id is set, then the student must be of

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
4909: -- the appropriate Class Standing type within the progression period.
4910: -- Relationships to a load calendar are used to determine this.
4911: DECLARE
4912: cst_active CONSTANT VARCHAR2(10) := 'ACTIVE';

Line 4919: v_class_standing IGS_PR_CLASS_STD.CLASS_STANDING%TYPE;

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
4922: SELECT cir.sub_cal_type,
4923: cir.sub_ci_sequence_number

Line 4920: v_derived_class_standing IGS_PR_CLASS_STD.CLASS_STANDING%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
4922: SELECT cir.sub_cal_type,
4923: cir.sub_ci_sequence_number
4924: FROM IGS_CA_INST ci,

Line 4939: FROM igs_pr_class_std cstd

4935: cs.s_CAL_STATUS = cst_active;
4936:
4937: CURSOR c_cstd IS
4938: SELECT cstd.class_standing
4939: FROM igs_pr_class_std cstd
4940: WHERE cstd.igs_pr_class_std_id = p_igs_pr_class_std_id;
4941:
4942: BEGIN
4943: OPEN c_cir;

Line 4940: WHERE cstd.igs_pr_class_std_id = p_igs_pr_class_std_id;

4936:
4937: CURSOR c_cstd IS
4938: SELECT cstd.class_standing
4939: FROM igs_pr_class_std cstd
4940: WHERE cstd.igs_pr_class_std_id = p_igs_pr_class_std_id;
4941:
4942: BEGIN
4943: OPEN c_cir;
4944: FETCH c_cir INTO v_sub_cal_type,

Line 5119: p_igs_pr_class_std_id IGS_PR_CLASS_STD.IGS_PR_CLASS_STD_ID%TYPE,

5115: p_progression_rule_cd IGS_PR_RU_APPL.progression_rule_cd%TYPE,
5116: p_rul_sequence_number IGS_PR_RU_APPL.rul_sequence_number%TYPE,
5117: p_attendance_type IGS_PR_RU_APPL.attendance_type%TYPE,
5118: p_reference_cd IGS_PR_RU_APPL.reference_cd%TYPE,
5119: p_igs_pr_class_std_id IGS_PR_CLASS_STD.IGS_PR_CLASS_STD_ID%TYPE,
5120: p_min_cp IGS_PR_RU_APPL.min_cp%TYPE,
5121: p_max_cp IGS_PR_RU_APPL.max_cp%TYPE
5122: )
5123: RETURN BOOLEAN

Line 5167: IF p_igs_pr_class_std_id IS NOT NULL THEN

5163: END IF;
5164: END IF;
5165:
5166: -- if rule application specifies class standing then check for match
5167: IF p_igs_pr_class_std_id IS NOT NULL THEN
5168: IF prgpl_match_class_standing(
5169: p_person_id,
5170: p_course_cd,
5171: p_prg_cal_type,

Line 5173: p_igs_pr_class_std_id) = 'N' THEN

5169: p_person_id,
5170: p_course_cd,
5171: p_prg_cal_type,
5172: p_prg_sequence_number,
5173: p_igs_pr_class_std_id) = 'N' THEN
5174: RETURN TRUE;
5175: END IF;
5176: END IF;
5177:

Line 5478: pra.reference_cd, pra.igs_pr_class_std_id, pra.min_cp, pra.max_cp,

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,
5480: prctv.start_effective_period, prctv.num_of_applications,
5481: pra.sca_person_id, pra.sca_course_cd, pra.crv_course_cd,
5482: pra.crv_version_number, pra.ou_org_unit_cd, pra.ou_start_dt,

Line 5500: pra.reference_cd, pra.igs_pr_class_std_id, pra.min_cp, pra.max_cp,

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,
5502: prctv.start_effective_period, prctv.num_of_applications,
5503: pra.sca_person_id, pra.sca_course_cd, pra.crv_course_cd,
5504: pra.crv_version_number, pra.ou_org_unit_cd, pra.ou_start_dt,

Line 5522: pra.reference_cd, pra.igs_pr_class_std_id, pra.min_cp, pra.max_cp,

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,
5524: prctv.start_effective_period, prctv.num_of_applications,
5525: pra.sca_person_id, pra.sca_course_cd, pra.crv_course_cd,
5526: pra.crv_version_number, pra.ou_org_unit_cd, pra.ou_start_dt,

Line 5590: pra.reference_cd, pra.igs_pr_class_std_id, pra.min_cp, pra.max_cp,

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,
5592: prctv.start_effective_period, prctv.num_of_applications,
5593: pra.sca_person_id, pra.sca_course_cd, pra.crv_course_cd,
5594: pra.crv_version_number, pra.ou_org_unit_cd, pra.ou_start_dt,

Line 5707: v_pra_rec.igs_pr_class_std_id,

5703: v_pra_rec.progression_rule_cd,
5704: v_pra_rec.rul_sequence_number,
5705: v_pra_rec.attendance_type,
5706: v_pra_rec.reference_cd,
5707: v_pra_rec.igs_pr_class_std_id,
5708: v_pra_rec.min_cp,
5709: v_pra_rec.max_cp) THEN
5710: -- Changes rolled back
5711: EXIT;

Line 5794: v_pra_rec.igs_pr_class_std_id,

5790: v_pra_rec.progression_rule_cd,
5791: v_pra_rec.rul_sequence_number,
5792: v_pra_rec.attendance_type,
5793: v_pra_rec.reference_cd,
5794: v_pra_rec.igs_pr_class_std_id,
5795: v_pra_rec.min_cp,
5796: v_pra_rec.max_cp) THEN
5797: -- Changes rolled back
5798: EXIT;

Line 5877: v_pra_rec.igs_pr_class_std_id,

5873: v_pra_rec.progression_rule_cd,
5874: v_pra_rec.rul_sequence_number,
5875: v_pra_rec.attendance_type,
5876: v_pra_rec.reference_cd,
5877: v_pra_rec.igs_pr_class_std_id,
5878: v_pra_rec.min_cp,
5879: v_pra_rec.max_cp) THEN
5880: -- Changes rolled back
5881: EXIT;

Line 5960: v_pra_rec.igs_pr_class_std_id,

5956: v_pra_rec.progression_rule_cd,
5957: v_pra_rec.rul_sequence_number,
5958: v_pra_rec.attendance_type,
5959: v_pra_rec.reference_cd,
5960: v_pra_rec.igs_pr_class_std_id,
5961: v_pra_rec.min_cp,
5962: v_pra_rec.max_cp) THEN
5963: -- Changes rolled back
5964: EXIT;