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_EN_ELGBL_PROGRAM dependencies on IGS_PE_PERSENC_EFFCT

Line 569: l_override_limit igs_pe_persenc_effct.restricted_enrolment_cp%TYPE;

565: -- Cursor Row Type Variables
566: l_cur_uoo_id cur_uoo_id%ROWTYPE;
567:
568: -- Table.Column Type Variables
569: l_override_limit igs_pe_persenc_effct.restricted_enrolment_cp%TYPE;
570: l_max_cp_allowed igs_pe_persenc_effct.restricted_enrolment_cp%TYPE;
571: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
572: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
573: l_unit_cp igs_ps_unit_ver.enrolled_credit_points%TYPE;

Line 570: l_max_cp_allowed igs_pe_persenc_effct.restricted_enrolment_cp%TYPE;

566: l_cur_uoo_id cur_uoo_id%ROWTYPE;
567:
568: -- Table.Column Type Variables
569: l_override_limit igs_pe_persenc_effct.restricted_enrolment_cp%TYPE;
570: l_max_cp_allowed igs_pe_persenc_effct.restricted_enrolment_cp%TYPE;
571: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
572: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
573: l_unit_cp igs_ps_unit_ver.enrolled_credit_points%TYPE;
574: l_rule_message igs_ru_item.value%TYPE;

Line 1001: l_override_limit igs_pe_persenc_effct.restricted_enrolment_cp%TYPE;

997: -- Below local variable added as part of Enrl Elgbl and Validation Build. Bug#2616692
998: l_min_cp_config cur_min_cp_config%ROWTYPE;
999:
1000: -- Table.Column Type Variables
1001: l_override_limit igs_pe_persenc_effct.restricted_enrolment_cp%TYPE;
1002: l_min_cp_allowed igs_pe_persenc_effct.restricted_enrolment_cp%TYPE;
1003: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
1004: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1005: l_unit_cp igs_ps_unit_ver.enrolled_credit_points%TYPE;

Line 1002: l_min_cp_allowed igs_pe_persenc_effct.restricted_enrolment_cp%TYPE;

998: l_min_cp_config cur_min_cp_config%ROWTYPE;
999:
1000: -- Table.Column Type Variables
1001: l_override_limit igs_pe_persenc_effct.restricted_enrolment_cp%TYPE;
1002: l_min_cp_allowed igs_pe_persenc_effct.restricted_enrolment_cp%TYPE;
1003: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
1004: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1005: l_unit_cp igs_ps_unit_ver.enrolled_credit_points%TYPE;
1006: l_rule_message igs_ru_item.value%TYPE;

Line 1806: FROM igs_pe_persenc_effct

1802: -- Cursor for getting the minimum progression credit points that are defined
1803: CURSOR cur_min_progression_cp(cp_effective_date DATE)
1804: IS
1805: SELECT MIN(restricted_enrolment_cp) restricted_enrolment_cp
1806: FROM igs_pe_persenc_effct
1807: WHERE person_id = p_person_id
1808: AND s_encmb_effect_type = 'RSTR_GE_CP'
1809: AND pee_start_dt <= cp_effective_date
1810: AND (expiry_dt IS NULL OR expiry_dt >= cp_effective_date);

Line 1843: l_override_limit igs_pe_persenc_effct.restricted_enrolment_cp%TYPE;

1839: l_cur_min_primary_cp cur_min_primary_cp%ROWTYPE;
1840: l_message VARCHAR2(30) := NULL ;
1841:
1842: -- Table.Column Type Variables
1843: l_override_limit igs_pe_persenc_effct.restricted_enrolment_cp%TYPE;
1844: l_min_cp_allowed igs_pe_persenc_effct.restricted_enrolment_cp%TYPE := NULL ;
1845:
1846: l_get_min_cp_ovr igs_en_config_enr_cp.min_cp_per_term%TYPE;
1847: l_return_value BOOLEAN;

Line 1844: l_min_cp_allowed igs_pe_persenc_effct.restricted_enrolment_cp%TYPE := NULL ;

1840: l_message VARCHAR2(30) := NULL ;
1841:
1842: -- Table.Column Type Variables
1843: l_override_limit igs_pe_persenc_effct.restricted_enrolment_cp%TYPE;
1844: l_min_cp_allowed igs_pe_persenc_effct.restricted_enrolment_cp%TYPE := NULL ;
1845:
1846: l_get_min_cp_ovr igs_en_config_enr_cp.min_cp_per_term%TYPE;
1847: l_return_value BOOLEAN;
1848: l_effective_date igs_ca_inst.start_dt%TYPE;

Line 1977: FROM igs_pe_persenc_effct

1973: -- Cursor for getting the maximum progression credit points that are defined
1974: CURSOR cur_max_progression_cp(cp_effective_date DATE)
1975: IS
1976: SELECT MAX(restricted_enrolment_cp) restricted_enrolment_cp
1977: FROM igs_pe_persenc_effct
1978: WHERE person_id = p_person_id
1979: AND s_encmb_effect_type = 'RSTR_LE_CP'
1980: AND pee_start_dt <= cp_effective_date
1981: AND (expiry_dt IS NULL OR expiry_dt >= cp_effective_date);

Line 2011: l_override_limit igs_pe_persenc_effct.restricted_enrolment_cp%TYPE;

2007: l_cur_uoo_id cur_uoo_id%ROWTYPE;
2008: l_cur_max_progression_cp cur_max_progression_cp%ROWTYPE;
2009: l_cur_max_primary_cp cur_max_primary_cp%ROWTYPE;
2010: l_get_max_cp_ovr cur_get_max_cp_ovr%ROWTYPE;
2011: l_override_limit igs_pe_persenc_effct.restricted_enrolment_cp%TYPE;
2012: l_return_value BOOLEAN;
2013: l_effective_date DATE;
2014: l_prsid_max_cp igs_en_pig_cp_setup.prsid_max_cp%TYPE;
2015: l_message VARCHAR2(30);

Line 2016: l_max_cp_allowed igs_pe_persenc_effct.restricted_enrolment_cp%TYPE;

2012: l_return_value BOOLEAN;
2013: l_effective_date DATE;
2014: l_prsid_max_cp igs_en_pig_cp_setup.prsid_max_cp%TYPE;
2015: l_message VARCHAR2(30);
2016: l_max_cp_allowed igs_pe_persenc_effct.restricted_enrolment_cp%TYPE;
2017:
2018: l_enrol_cal_type igs_ca_type.cal_type%TYPE;
2019: l_enrol_sequence_number igs_ca_inst_all.sequence_number%TYPE;
2020:

Line 2365: l_override_limit igs_pe_persenc_effct.restricted_enrolment_cp%TYPE;

2361:
2362: l_sua_cp IGS_PS_UNIT_VER.POINTS_MAX%TYPE;
2363: l_return_value BOOLEAN;
2364: l_alternate_code IGS_CA_INST.alternate_code%TYPE;
2365: l_override_limit igs_pe_persenc_effct.restricted_enrolment_cp%TYPE;
2366: l_return_eftsu NUMBER := 0;
2367: v_um_s_unit_mode IGS_AS_UNIT_MODE.s_unit_mode%TYPE;
2368: v_am_govt_attendance_mode IGS_EN_ATD_MODE.govt_attendance_mode%TYPE;
2369: