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_GEN_006

Line 122: IF IGS_PR_GEN_006.IGS_PR_get_within_appl (

118: END IF;
119: -- Determine if the student has had a progression check in the related
120: -- progression periods
121: FOR v_cir_rec IN c_cir LOOP
122: IF IGS_PR_GEN_006.IGS_PR_get_within_appl (
123: v_cir_rec.sup_cal_type,
124: v_cir_rec.sup_ci_sequence_number,
125: p_course_cd,
126: v_version_number,

Line 1025: -- IGS_PR_GEN_006.IGS_PR_get_spo_expiry calculates the expiry date of a student progression outcome record.

1021: END IF;
1022: END IF;
1023:
1024: IF v_spo_rec.expiry_dt IS NULL OR v_spo_rec.expiry_dt > TRUNC(SYSDATE) THEN
1025: -- IGS_PR_GEN_006.IGS_PR_get_spo_expiry calculates the expiry date of a student progression outcome record.
1026: -- An open-ended expiry date returns with the value 01/01/4000.An un-determinable expiry date returns NULL.
1027: v_expiry_status := IGS_PR_GEN_006.IGS_PR_get_spo_expiry
1028: ( p_person_id,
1029: p_course_cd,

Line 1027: v_expiry_status := IGS_PR_GEN_006.IGS_PR_get_spo_expiry

1023:
1024: IF v_spo_rec.expiry_dt IS NULL OR v_spo_rec.expiry_dt > TRUNC(SYSDATE) THEN
1025: -- IGS_PR_GEN_006.IGS_PR_get_spo_expiry calculates the expiry date of a student progression outcome record.
1026: -- An open-ended expiry date returns with the value 01/01/4000.An un-determinable expiry date returns NULL.
1027: v_expiry_status := IGS_PR_GEN_006.IGS_PR_get_spo_expiry
1028: ( p_person_id,
1029: p_course_cd,
1030: p_sequence_number,
1031: NULL,

Line 1440: v_expiry_status := IGS_PR_GEN_006.IGS_PR_get_spo_expiry (

1436: cst_exclusion,
1437: cst_expulsion) THEN
1438:
1439: -- Call routine to determine the prospective expiry date
1440: v_expiry_status := IGS_PR_GEN_006.IGS_PR_get_spo_expiry (
1441: v_spo_rec.person_id,
1442: v_spo_rec.course_cd,
1443: v_spo_rec.sequence_number,
1444: v_spo_rec.expiry_dt,

Line 2021: IF NOT IGS_PR_GEN_006.IGS_PR_upd_spo_pen (

2017:
2018: IF NOT v_process_next_spo AND NOT v_exit_procedure THEN
2019:
2020: -- Call routine to add the encumbrances to the students enrolment
2021: IF NOT IGS_PR_GEN_006.IGS_PR_upd_spo_pen (
2022: v_spo_rec.person_id,
2023: v_spo_rec.course_cd,
2024: v_spo_rec.sequence_number,
2025: v_authorising_person_id,

Line 2131: IGS_PR_GEN_006.IGS_PR_ins_copy_pra (

2127: v_spo_rec.course_cd,
2128: v_spo_rec.sequence_number) LOOP
2129: -- Transfer detail to the sca level
2130: v_new_pra_sequence_number :=
2131: IGS_PR_GEN_006.IGS_PR_ins_copy_pra (
2132: v_pra_rec.progression_rule_cat,
2133: v_pra_rec.sequence_number,
2134: NULL,
2135: NULL,

Line 2297: IF NOT IGS_PR_GEN_006.IGS_PR_upd_spo_pen (

2293: -- being reversed to cancelled or removed.
2294: -- Call routine to lift the encumbrances resulting from the outcome. This
2295: -- must be done prior to any discontinuation being lifted, else enrolment
2296: -- validations will prevent the re-instatement.
2297: IF NOT IGS_PR_GEN_006.IGS_PR_upd_spo_pen (
2298: v_spo_rec.person_id,
2299: v_spo_rec.course_cd,
2300: v_spo_rec.sequence_number,
2301: v_authorising_person_id,

Line 2380: IF IGS_PR_GEN_006.IGS_PR_get_spo_expiry (

2376: v_spo_rec.course_cd,
2377: v_spo_rec.sequence_number,
2378: v_spo_rec.encmb_course_group_cd,
2379: v_spo_rec.version_number) LOOP
2380: IF IGS_PR_GEN_006.IGS_PR_get_spo_expiry (
2381: v_spo_rec.person_id,
2382: v_spo_rec.course_cd,
2383: v_spo_pot_rec.sequence_number,
2384: v_spo_pot_rec.expiry_dt,

Line 2797: IF IGS_PR_GEN_006.IGS_PR_get_within_appl (

2793: v_result_status VARCHAR2(10);
2794: BEGIN
2795:
2796: -- If course version is not within its first processing cycle then skip
2797: IF IGS_PR_GEN_006.IGS_PR_get_within_appl (
2798: p_ci_cal_type,
2799: p_ci_sequence_number,
2800: p_sca_course_cd,
2801: p_sca_version_number,

Line 3280: IF IGS_PR_GEN_006.IGS_PR_get_within_appl (

3276: -- igs_pr_get_within_appl validates that the current course_cd version_number lies
3277: -- is in the bounds of the current progression calendar.
3278: -- If they do not qualify then do not update the plsql
3279: -- table with progression calendar for which rules have to be applied
3280: IF IGS_PR_GEN_006.IGS_PR_get_within_appl (
3281: v_spc_rec.prg_cal_type,
3282: v_spc_rec.prg_ci_sequence_number,
3283: v_st_rec.course_cd,
3284: v_st_rec.version_number,

Line 3319: IF IGS_PR_GEN_006.IGS_PR_get_within_appl (

3315: v_str_rec.ci_sequence_number,
3316: v_st_rec.person_id,
3317: v_st_rec.course_cd) LOOP
3318:
3319: IF IGS_PR_GEN_006.IGS_PR_get_within_appl (
3320: v_spc_rec.prg_cal_type,
3321: v_spc_rec.prg_ci_sequence_number,
3322: v_st_rec.course_cd,
3323: v_st_rec.version_number,

Line 4004: v_new_pra_sequence_number := IGS_PR_GEN_006.IGS_PR_ins_copy_pra (

4000:
4001:
4002: -- Copy any PRO level rules to SPO level.
4003: FOR v_pra_rec IN c_pra LOOP
4004: v_new_pra_sequence_number := IGS_PR_GEN_006.IGS_PR_ins_copy_pra (
4005: v_pra_rec.progression_rule_cat,
4006: v_pra_rec.sequence_number,
4007: NULL,
4008: NULL,

Line 6381: IGS_PR_GEN_006.IGS_PR_GET_SPO_EXPIRY (

6377: spo.course_cd = sca.course_cd)
6378: OR
6379: (spo.decision_status = cst_approved AND
6380: pot.s_progression_outcome_type <> cst_nopenalty AND
6381: IGS_PR_GEN_006.IGS_PR_GET_SPO_EXPIRY (
6382: spo.person_id,
6383: spo.course_cd,
6384: spo.sequence_number,
6385: spo.expiry_dt) <> cst_expired AND

Line 6456: IGS_PR_GEN_006.IGS_PR_GET_SPO_EXPIRY (

6452: spo.course_cd = sca.course_cd AND
6453: spo.decision_status = cst_approved AND
6454: (spo.decision_status = cst_approved AND
6455: pot.s_progression_outcome_type <> cst_nopenalty AND
6456: IGS_PR_GEN_006.IGS_PR_GET_SPO_EXPIRY (
6457: spo.person_id,
6458: spo.course_cd,
6459: spo.sequence_number,
6460: spo.expiry_dt) <> cst_expired AND

Line 6496: v_expiry_type := IGS_PR_GEN_006.IGS_PR_get_spo_expiry (

6492: OPEN c_person(v_spo_rec.person_id);
6493: FETCH c_person INTO lv_person_number;
6494: close c_person;
6495:
6496: v_expiry_type := IGS_PR_GEN_006.IGS_PR_get_spo_expiry (
6497: v_spo_rec.person_id,
6498: v_spo_rec.course_cd,
6499: v_spo_rec.sequence_number,
6500: v_spo_rec.expiry_dt,

Line 6580: v_sca_status_updated := IGS_PR_GEN_006.IGS_PR_upd_sca_status (

6576: OPEN c_person(v_sca_rec.person_id);
6577: FETCH c_person INTO lv_person_number;
6578: close c_person;
6579:
6580: v_sca_status_updated := IGS_PR_GEN_006.IGS_PR_upd_sca_status (
6581: v_sca_rec.person_id,
6582: v_sca_rec.course_cd,
6583: v_sca_rec.progression_status,
6584: v_sca_rec.version_number,

Line 6605: v_sca_status_updated := IGS_PR_GEN_006.IGS_PR_upd_sca_status (

6601: OPEN c_person(v_sca_rec.person_id);
6602: FETCH c_person INTO lv_person_number;
6603: close c_person;
6604:
6605: v_sca_status_updated := IGS_PR_GEN_006.IGS_PR_upd_sca_status (
6606: v_sca_rec.person_id,
6607: v_sca_rec.course_cd,
6608: v_sca_rec.progression_status,
6609: v_sca_rec.version_number,

Line 6626: v_sca_status_updated := IGS_PR_GEN_006.IGS_PR_upd_sca_status (

6622: OPEN c_person(v_sca_rec.person_id);
6623: FETCH c_person INTO lv_person_number;
6624: close c_person;
6625:
6626: v_sca_status_updated := IGS_PR_GEN_006.IGS_PR_upd_sca_status (
6627: v_sca_rec.person_id,
6628: v_sca_rec.course_cd,
6629: v_sca_rec.progression_status,
6630: v_sca_rec.version_number,

Line 6648: v_sca_status_updated := IGS_PR_GEN_006.IGS_PR_upd_sca_status (

6644: OPEN c_person(v_sca_rec.person_id);
6645: FETCH c_person INTO lv_person_number;
6646: close c_person;
6647:
6648: v_sca_status_updated := IGS_PR_GEN_006.IGS_PR_upd_sca_status (
6649: v_sca_rec.person_id,
6650: v_sca_rec.course_cd,
6651: v_sca_rec.progression_status,
6652: v_sca_rec.version_number,