DBA Data[Home] [Help]

APPS.IGS_PR_GEN_004 dependencies on IGS_PR_GEN_005

Line 968: -- IGS_PR_GEN_005.IGS_PR_clc_cause_expry calculates the show cause expiry dates for a nominated

964: v_spo_rec.show_cause_expiry_dt IS NULL AND v_spo_rec.show_cause_dt IS NULL
965: AND
966: v_spo_rec.appeal_dt IS NULL THEN
967: v_old_show_cause_expiry_dt := v_spo_rec.show_cause_expiry_dt;
968: -- IGS_PR_GEN_005.IGS_PR_clc_cause_expry calculates the show cause expiry dates for a nominated
969: -- rule within a nominated progression calendar. This routine also considers whether a show cause
970: -- is actually permitted ,if not the date is returned as null.
971: v_spo_rec.show_cause_expiry_dt := IGS_PR_GEN_005.IGS_PR_clc_cause_expry
972: ( p_course_cd,

Line 971: v_spo_rec.show_cause_expiry_dt := IGS_PR_GEN_005.IGS_PR_clc_cause_expry

967: v_old_show_cause_expiry_dt := v_spo_rec.show_cause_expiry_dt;
968: -- IGS_PR_GEN_005.IGS_PR_clc_cause_expry calculates the show cause expiry dates for a nominated
969: -- rule within a nominated progression calendar. This routine also considers whether a show cause
970: -- is actually permitted ,if not the date is returned as null.
971: v_spo_rec.show_cause_expiry_dt := IGS_PR_GEN_005.IGS_PR_clc_cause_expry
972: ( p_course_cd,
973: v_spo_rec.version_number,
974: v_spo_rec.prg_cal_type,
975: v_spo_rec.prg_ci_sequence_number,

Line 984: IF IGS_PR_GEN_005.IGS_PR_get_appeal_alwd

980: -- Determines whether an appeal is permitted for a nominated outcome.
981: -- If an appeal is permitted then ensure that an appeal expiry date is not earlier than
982: -- the show cause expiry date.
983: -- Else if an appeal is not permitted then set the old show cause expiry date.
984: IF IGS_PR_GEN_005.IGS_PR_get_appeal_alwd
985: ( v_spo_rec.progression_rule_cat,
986: v_spo_rec.pra_sequence_number,
987: v_spo_rec.pro_sequence_number,
988: v_spo_rec.course_cd,

Line 1007: v_spo_rec.appeal_expiry_dt := IGS_PR_GEN_005.IGS_PR_clc_apl_expry

1003: END IF;
1004:
1005: IF p_appeal_ind = 'Y' AND p_apply_before_appeal_ind = 'Y' AND
1006: v_spo_rec.appeal_expiry_dt IS NULL AND v_spo_rec.appeal_dt IS NULL THEN
1007: v_spo_rec.appeal_expiry_dt := IGS_PR_GEN_005.IGS_PR_clc_apl_expry
1008: ( p_course_cd,
1009: v_spo_rec.version_number,
1010: v_spo_rec.prg_cal_type,
1011: v_spo_rec.prg_ci_sequence_number,

Line 2809: v_result_status := IGS_PR_GEN_005.IGS_PR_get_sca_state (

2805:
2806: RETURN 'N';
2807: END IF;
2808: -- Check whether student is effectively enrolled in the period
2809: v_result_status := IGS_PR_GEN_005.IGS_PR_get_sca_state (
2810: p_sca_person_id,
2811: p_sca_course_cd,
2812: p_ci_cal_type,
2813: p_ci_sequence_number);

Line 3803: v_show_cause_expiry_dt := IGS_PR_GEN_005.IGS_PR_clc_cause_expry (

3799: CLOSE c_crv;
3800: v_decision_dt := TRUNC(SYSDATE);
3801: -- Get the show cause expiry date (routine will return NULL if not
3802: -- applicable).
3803: v_show_cause_expiry_dt := IGS_PR_GEN_005.IGS_PR_clc_cause_expry (
3804: p_course_cd,
3805: p_sca_version_number,
3806: p_prg_cal_type,
3807: p_prg_sequence_number,

Line 3812: v_appeal_expiry_dt := IGS_PR_GEN_005.IGS_PR_clc_apl_expry (

3808: p_progression_rule_cat,
3809: p_pra_sequence_number,
3810: p_pro_sequence_number);
3811: -- Get the appeal expiry date (routine will return NULL if not applicable).
3812: v_appeal_expiry_dt := IGS_PR_GEN_005.IGS_PR_clc_apl_expry (
3813: p_course_cd,
3814: p_sca_version_number,
3815: p_prg_cal_type,
3816: p_prg_sequence_number,

Line 4154: v_consecutive_failures := IGS_PR_GEN_005.IGS_PR_get_num_fail (

4150: -- The logic in this section will use the record equal or closest to the
4151: -- number of failures by a student. Matches with 'consecutive repeat' records
4152: -- will always take priority. It is not expected that ambiguous mixes of
4153: -- repeat and consecutive repeat records will happen too much in 'REAL life'.
4154: v_consecutive_failures := IGS_PR_GEN_005.IGS_PR_get_num_fail (
4155: p_person_id,
4156: p_course_cd,
4157: p_sca_version_number,
4158: p_progression_rule_cat,

Line 4193: v_repeat_failures := IGS_PR_GEN_005.IGS_PR_get_num_fail (

4189: IF v_spo_added THEN
4190: RETURN;
4191: END IF;
4192: END IF;
4193: v_repeat_failures := IGS_PR_GEN_005.IGS_PR_get_num_fail (
4194: p_person_id,
4195: p_course_cd,
4196: p_sca_version_number,
4197: p_progression_rule_cat,

Line 5314: v_alias_val := IGS_PR_GEN_005.IGS_PR_get_prg_dai (

5310: IF v_sprc_passed_ind <> 'X' THEN
5311: -- Check for timeframes for todo processing
5312: IF v_passed_ind = 'Y' THEN
5313: -- Check if beyond benefit cutoff date
5314: v_alias_val := IGS_PR_GEN_005.IGS_PR_get_prg_dai (
5315: p_course_cd,
5316: p_sca_version_number,
5317: p_prg_cal_type,
5318: p_prg_sequence_number,

Line 5348: v_alias_val := IGS_PR_GEN_005.IGS_PR_get_prg_dai (

5344: v_outcomes_removed := TRUE;
5345: END IF;
5346: ELSE
5347: -- Check if beyond penalty cutoff date
5348: v_alias_val := IGS_PR_GEN_005.IGS_PR_get_prg_dai (
5349: p_course_cd,
5350: p_sca_version_number,
5351: p_prg_cal_type,
5352: p_prg_sequence_number,

Line 5673: IF IGS_PR_GEN_005.igs_pr_get_sca_appl (

5669: -- Check that student complies with effective period and number of
5670: -- applications options where applicable.
5671: IF v_still_valid AND (v_pra_rec.start_effective_period IS NOT NULL
5672: OR v_pra_rec.num_of_applications IS NOT NULL) THEN
5673: IF IGS_PR_GEN_005.igs_pr_get_sca_appl (
5674: p_person_id,
5675: p_course_cd,
5676: p_sca_version_number,
5677: p_course_type,

Line 5764: IF IGS_PR_GEN_005.igs_pr_get_sca_appl (

5760: -- Check that student complies with effective period and number of
5761: -- applications options where applicable.
5762: IF v_still_valid AND (v_pra_rec.start_effective_period IS NOT NULL
5763: OR v_pra_rec.num_of_applications IS NOT NULL) THEN
5764: IF IGS_PR_GEN_005.igs_pr_get_sca_appl (
5765: p_person_id,
5766: p_course_cd,
5767: p_sca_version_number,
5768: p_course_type,

Line 5847: IF IGS_PR_GEN_005.igs_pr_get_sca_appl (

5843: -- Check that student complies with effective period and number of
5844: -- applications options where applicable.
5845: IF v_still_valid AND (v_pra_rec.start_effective_period IS NOT NULL
5846: OR v_pra_rec.num_of_applications IS NOT NULL) THEN
5847: IF IGS_PR_GEN_005.igs_pr_get_sca_appl (
5848: p_person_id,
5849: p_course_cd,
5850: p_sca_version_number,
5851: p_course_type,

Line 5930: IF IGS_PR_GEN_005.igs_pr_get_sca_appl (

5926: -- Check that student complies with effective period and number of
5927: -- applications options where applicable.
5928: IF v_still_valid AND (v_pra_rec.start_effective_period IS NOT NULL
5929: OR v_pra_rec.num_of_applications IS NOT NULL) THEN
5930: IF IGS_PR_GEN_005.igs_pr_get_sca_appl (
5931: p_person_id,
5932: p_course_cd,
5933: p_sca_version_number,
5934: p_course_type,

Line 6036: v_start_dt := IGS_PR_GEN_005.IGS_PR_get_prg_dai (

6032: ELSIF v_course_attempt_status = cst_unconfirm THEN
6033: p_message_name := 'IGS_PR_CNT_AP_PRRU_UCON_CRAT';
6034: RETURN;
6035: END IF;
6036: v_start_dt := IGS_PR_GEN_005.IGS_PR_get_prg_dai (
6037: p_course_cd,
6038: v_sca_version_number,
6039: p_prg_cal_type,
6040: p_prg_sequence_number,

Line 6068: v_result_status := IGS_PR_GEN_005.IGS_PR_get_sca_state (

6064: v_calculate_gpa_ind,
6065: v_outcome_check_type);
6066: -- Check the state of the students enrolment against the configuration
6067: -- options.
6068: v_result_status := IGS_PR_GEN_005.IGS_PR_get_sca_state (
6069: p_person_id,
6070: p_course_cd,
6071: p_prg_cal_type,
6072: p_prg_sequence_number);