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

Line 571: l_acad_cal_type igs_ca_inst.cal_type%TYPE;

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;
575: l_acad_message VARCHAR2(30);

Line 572: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

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;
575: l_acad_message VARCHAR2(30);
576: l_dummy_c VARCHAR2(200);

Line 585: l_acad_start_dt IGS_CA_INST.start_dt%TYPE;

581: l_total_eftsu_cp NUMBER; -- NUMBER as returned from the function
582: l_credit_points NUMBER;
583: l_exclude_cp NUMBER;
584: l_rule_return_value VARCHAR2(30); -- as returned from Rules function
585: l_acad_start_dt IGS_CA_INST.start_dt%TYPE;
586: l_acad_end_dt IGS_CA_INST.end_dt%TYPE;
587: l_alternate_code IGS_CA_INST.alternate_code%TYPE;
588: l_dummy NUMBER;
589: l_unit_incurred_cp NUMBER;

Line 586: l_acad_end_dt IGS_CA_INST.end_dt%TYPE;

582: l_credit_points NUMBER;
583: l_exclude_cp NUMBER;
584: l_rule_return_value VARCHAR2(30); -- as returned from Rules function
585: l_acad_start_dt IGS_CA_INST.start_dt%TYPE;
586: l_acad_end_dt IGS_CA_INST.end_dt%TYPE;
587: l_alternate_code IGS_CA_INST.alternate_code%TYPE;
588: l_dummy NUMBER;
589: l_unit_incurred_cp NUMBER;
590: l_effective_date DATE;

Line 587: l_alternate_code IGS_CA_INST.alternate_code%TYPE;

583: l_exclude_cp NUMBER;
584: l_rule_return_value VARCHAR2(30); -- as returned from Rules function
585: l_acad_start_dt IGS_CA_INST.start_dt%TYPE;
586: l_acad_end_dt IGS_CA_INST.end_dt%TYPE;
587: l_alternate_code IGS_CA_INST.alternate_code%TYPE;
588: l_dummy NUMBER;
589: l_unit_incurred_cp NUMBER;
590: l_effective_date DATE;
591: l_message VARCHAR2(2000);

Line 611: l_enrol_sequence_number igs_ca_inst_all.sequence_number%TYPE;

607: AND course_cd = p_program_cd
608: AND uoo_id = p_uoo_id;
609:
610: l_enrol_cal_type igs_ca_type.cal_type%TYPE;
611: l_enrol_sequence_number igs_ca_inst_all.sequence_number%TYPE;
612: l_no_assessment_ind igs_en_su_attempt.no_assessment_ind%TYPE;
613:
614:
615: BEGIN

Line 1003: l_acad_cal_type igs_ca_inst.cal_type%TYPE;

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;
1007: -- Below two local variables added as part of Enrl Elgbl and Validation Build. Bug#2616692

Line 1004: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

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;
1007: -- Below two local variables added as part of Enrl Elgbl and Validation Build. Bug#2616692
1008:

Line 1019: l_acad_start_dt IGS_CA_INST.start_dt%TYPE;

1015: l_total_eftsu_cp NUMBER; -- As defined in the function
1016: l_credit_points NUMBER; -- clarify
1017: l_rule_return_value VARCHAR2(30); -- as returned from Rules function
1018: l_acad_message VARCHAR2(30); -- as returned from Get Academic Calendar procedure
1019: l_acad_start_dt IGS_CA_INST.start_dt%TYPE;
1020: l_acad_end_dt IGS_CA_INST.end_dt%TYPE;
1021: l_alternate_code IGS_CA_INST.alternate_code%TYPE;
1022: l_dummy NUMBER;
1023: l_unit_incurred_cp NUMBER;

Line 1020: l_acad_end_dt IGS_CA_INST.end_dt%TYPE;

1016: l_credit_points NUMBER; -- clarify
1017: l_rule_return_value VARCHAR2(30); -- as returned from Rules function
1018: l_acad_message VARCHAR2(30); -- as returned from Get Academic Calendar procedure
1019: l_acad_start_dt IGS_CA_INST.start_dt%TYPE;
1020: l_acad_end_dt IGS_CA_INST.end_dt%TYPE;
1021: l_alternate_code IGS_CA_INST.alternate_code%TYPE;
1022: l_dummy NUMBER;
1023: l_unit_incurred_cp NUMBER;
1024: -- Below local variable added as part of Enrl Elgbl and Validation Build. Bug#2616692

Line 1021: l_alternate_code IGS_CA_INST.alternate_code%TYPE;

1017: l_rule_return_value VARCHAR2(30); -- as returned from Rules function
1018: l_acad_message VARCHAR2(30); -- as returned from Get Academic Calendar procedure
1019: l_acad_start_dt IGS_CA_INST.start_dt%TYPE;
1020: l_acad_end_dt IGS_CA_INST.end_dt%TYPE;
1021: l_alternate_code IGS_CA_INST.alternate_code%TYPE;
1022: l_dummy NUMBER;
1023: l_unit_incurred_cp NUMBER;
1024: -- Below local variable added as part of Enrl Elgbl and Validation Build. Bug#2616692
1025: l_deny_warn igs_en_cpd_ext_v.notification_flag%TYPE;

Line 1382: l_acad_cal_type igs_ca_inst.cal_type%TYPE;

1378:
1379: -- Table.Column Type Variables
1380: l_coo_id igs_en_stdnt_ps_att.coo_id%TYPE;
1381: l_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE; -- should be NUMBER(6,3) Instead of NUMBER(5,3)
1382: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
1383: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1384: l_get_alias_val igs_ca_da_inst_v.alias_val%TYPE;
1385:
1386: -- Variables

Line 1383: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

1379: -- Table.Column Type Variables
1380: l_coo_id igs_en_stdnt_ps_att.coo_id%TYPE;
1381: l_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE; -- should be NUMBER(6,3) Instead of NUMBER(5,3)
1382: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
1383: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1384: l_get_alias_val igs_ca_da_inst_v.alias_val%TYPE;
1385:
1386: -- Variables
1387: l_return_value BOOLEAN;

Line 1391: l_acad_start_dt IGS_CA_INST.start_dt%TYPE;

1387: l_return_value BOOLEAN;
1388: l_message_name VARCHAR2(30); -- As returned from the function igs_en_val_sca.enrp_val_coo_att
1389: l_attendance_types VARCHAR2(100); -- As returned from the function igs_en_val_sca.enrp_val_coo_att
1390: l_acad_message VARCHAR2(30); -- as reutrned from the procedure Get Academic Calendar
1391: l_acad_start_dt IGS_CA_INST.start_dt%TYPE;
1392: l_acad_end_dt IGS_CA_INST.end_dt%TYPE;
1393: l_alternate_code IGS_CA_INST.alternate_code%TYPE;
1394: --Below Three variables added as part of Enrl Elgbl and Validation Build. Bug#2616692
1395: l_credit_points igs_en_config_enr_cp.min_cp_per_term%TYPE;

Line 1392: l_acad_end_dt IGS_CA_INST.end_dt%TYPE;

1388: l_message_name VARCHAR2(30); -- As returned from the function igs_en_val_sca.enrp_val_coo_att
1389: l_attendance_types VARCHAR2(100); -- As returned from the function igs_en_val_sca.enrp_val_coo_att
1390: l_acad_message VARCHAR2(30); -- as reutrned from the procedure Get Academic Calendar
1391: l_acad_start_dt IGS_CA_INST.start_dt%TYPE;
1392: l_acad_end_dt IGS_CA_INST.end_dt%TYPE;
1393: l_alternate_code IGS_CA_INST.alternate_code%TYPE;
1394: --Below Three variables added as part of Enrl Elgbl and Validation Build. Bug#2616692
1395: l_credit_points igs_en_config_enr_cp.min_cp_per_term%TYPE;
1396: l_min_credit_point igs_en_config_enr_cp.min_cp_per_term%TYPE;

Line 1393: l_alternate_code IGS_CA_INST.alternate_code%TYPE;

1389: l_attendance_types VARCHAR2(100); -- As returned from the function igs_en_val_sca.enrp_val_coo_att
1390: l_acad_message VARCHAR2(30); -- as reutrned from the procedure Get Academic Calendar
1391: l_acad_start_dt IGS_CA_INST.start_dt%TYPE;
1392: l_acad_end_dt IGS_CA_INST.end_dt%TYPE;
1393: l_alternate_code IGS_CA_INST.alternate_code%TYPE;
1394: --Below Three variables added as part of Enrl Elgbl and Validation Build. Bug#2616692
1395: l_credit_points igs_en_config_enr_cp.min_cp_per_term%TYPE;
1396: l_min_credit_point igs_en_config_enr_cp.min_cp_per_term%TYPE;
1397: l_deny_warn VARCHAR2(20);

Line 1604: FROM igs_ca_inst_rel

1600: ******************************************************************/
1601:
1602: CURSOR c_acad_cal IS
1603: SELECT sup_ci_sequence_number
1604: FROM igs_ca_inst_rel
1605: WHERE sub_cal_type = p_load_cal AND
1606: sub_ci_sequence_number = p_load_ci_sequence_number AND
1607: sup_cal_type = p_acad_cal;
1608:

Line 1632: l_acad_ci_seq_number igs_ca_inst_rel.sup_ci_sequence_number%TYPE;

1628: AND sua.ci_sequence_number = ltt.teach_ci_sequence_number
1629: AND ltt.load_cal_type = p_load_cal
1630: AND ltt.load_ci_sequence_number = p_load_ci_sequence_number ;
1631:
1632: l_acad_ci_seq_number igs_ca_inst_rel.sup_ci_sequence_number%TYPE;
1633: l_commencement_type VARCHAR2(10);
1634: l_enrollment_cat igs_en_cat_prc_dtl.enrolment_cat%TYPE;
1635: l_enrol_cal_type igs_ca_inst_all.cal_type%TYPE;
1636: l_enrol_sequence_number igs_ca_inst_all.sequence_number%TYPE;

Line 1635: l_enrol_cal_type igs_ca_inst_all.cal_type%TYPE;

1631:
1632: l_acad_ci_seq_number igs_ca_inst_rel.sup_ci_sequence_number%TYPE;
1633: l_commencement_type VARCHAR2(10);
1634: l_enrollment_cat igs_en_cat_prc_dtl.enrolment_cat%TYPE;
1635: l_enrol_cal_type igs_ca_inst_all.cal_type%TYPE;
1636: l_enrol_sequence_number igs_ca_inst_all.sequence_number%TYPE;
1637: l_notification_flag igs_en_cpd_ext.notification_flag%TYPE;
1638: l_message fnd_new_messages.message_name%TYPE;
1639: l_credit_points igs_en_config_enr_cp.min_cp_per_term%TYPE;

Line 1636: l_enrol_sequence_number igs_ca_inst_all.sequence_number%TYPE;

1632: l_acad_ci_seq_number igs_ca_inst_rel.sup_ci_sequence_number%TYPE;
1633: l_commencement_type VARCHAR2(10);
1634: l_enrollment_cat igs_en_cat_prc_dtl.enrolment_cat%TYPE;
1635: l_enrol_cal_type igs_ca_inst_all.cal_type%TYPE;
1636: l_enrol_sequence_number igs_ca_inst_all.sequence_number%TYPE;
1637: l_notification_flag igs_en_cpd_ext.notification_flag%TYPE;
1638: l_message fnd_new_messages.message_name%TYPE;
1639: l_credit_points igs_en_config_enr_cp.min_cp_per_term%TYPE;
1640: l_min_credit_point igs_en_config_enr_cp.min_cp_per_term%TYPE;

Line 1832: FROM igs_ca_inst

1828:
1829: -- Cursor to get the Load Calendar Start Date when the uoo_id is not mentioned.
1830: CURSOR get_load_cal_st_dt IS
1831: SELECT start_dt
1832: FROM igs_ca_inst
1833: WHERE cal_type = p_load_calendar_type AND
1834: sequence_number = p_load_cal_sequence_number ;
1835:
1836: -- Cursor Row Type Variables

Line 1848: l_effective_date igs_ca_inst.start_dt%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;
1849: l_prsid_min_cp igs_en_pig_cp_setup.prsid_min_cp%TYPE;
1850:
1851: BEGIN
1852: l_return_value := igs_en_gen_015.validation_step_is_overridden ( p_eligibility_step_type => 'FMIN_CRDT',

Line 2003: FROM igs_ca_inst

1999:
2000: -- Cursor to get the Load Calendar Start Date when the uoo_id is not mentioned.
2001: CURSOR get_load_cal_st_dt IS
2002: SELECT start_dt
2003: FROM igs_ca_inst
2004: WHERE cal_type = p_load_calendar_type AND
2005: sequence_number = p_load_cal_sequence_number ;
2006:
2007: l_cur_uoo_id cur_uoo_id%ROWTYPE;

Line 2019: l_enrol_sequence_number igs_ca_inst_all.sequence_number%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:
2021: BEGIN
2022:
2023: l_return_value := igs_en_gen_015.validation_step_is_overridden ( p_eligibility_step_type => 'FMAX_CRDT',

Line 2235: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

2231: -- Cursor to fetch the Cross faculty Element restrictions
2232: CURSOR c_cop (
2233: cp_sca_coo_id IGS_EN_STDNT_PS_ATT.coo_id%TYPE,
2234: cp_cal_type IGS_EN_STDNT_PS_ATT.cal_type%TYPE,
2235: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
2236: SELECT cop.max_cross_faculty_cp,
2237: cop.max_cross_mode_cp,
2238: cop.max_cross_location_cp
2239: FROM IGS_PS_OFR_PAT cop

Line 2256: cp_load_cal_type IGS_CA_INST.cal_type%TYPE, -- Load Cal

2252:
2253: CURSOR c_sua_uv (
2254: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
2255: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
2256: cp_load_cal_type IGS_CA_INST.cal_type%TYPE, -- Load Cal
2257: cp_load_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS-- Load Cal
2258: SELECT DISTINCT sua.unit_cd,
2259: sua.version_number,
2260: sua.cal_type,

Line 2257: cp_load_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS-- Load Cal

2253: CURSOR c_sua_uv (
2254: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
2255: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
2256: cp_load_cal_type IGS_CA_INST.cal_type%TYPE, -- Load Cal
2257: cp_load_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS-- Load Cal
2258: SELECT DISTINCT sua.unit_cd,
2259: sua.version_number,
2260: sua.cal_type,
2261: sua.ci_sequence_number,

Line 2364: l_alternate_code IGS_CA_INST.alternate_code%TYPE;

2360: l_no_assessment_ind igs_en_su_attempt.no_assessment_ind%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;

Line 2382: l_acad_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;

2378: l_cow_org_unit_cd IGS_PS_OWN.org_unit_cd%TYPE;
2379: v_cow_ou_start_dt IGS_PS_OWN.ou_start_dt%TYPE;
2380:
2381: l_acad_cal_type IGS_CA_TYPE.CAL_TYPE%TYPE;
2382: l_acad_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
2383: l_acad_start_dt IGS_CA_INST.START_DT%TYPE;
2384: l_acad_end_dt IGS_CA_INST.END_DT%TYPE;
2385: l_acad_message VARCHAR2(30);
2386: l_temp NUMBER := 0 ;

Line 2383: l_acad_start_dt IGS_CA_INST.START_DT%TYPE;

2379: v_cow_ou_start_dt IGS_PS_OWN.ou_start_dt%TYPE;
2380:
2381: l_acad_cal_type IGS_CA_TYPE.CAL_TYPE%TYPE;
2382: l_acad_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
2383: l_acad_start_dt IGS_CA_INST.START_DT%TYPE;
2384: l_acad_end_dt IGS_CA_INST.END_DT%TYPE;
2385: l_acad_message VARCHAR2(30);
2386: l_temp NUMBER := 0 ;
2387: --dummy variable to pick up audit, billing, enrolled credit points

Line 2384: l_acad_end_dt IGS_CA_INST.END_DT%TYPE;

2380:
2381: l_acad_cal_type IGS_CA_TYPE.CAL_TYPE%TYPE;
2382: l_acad_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
2383: l_acad_start_dt IGS_CA_INST.START_DT%TYPE;
2384: l_acad_end_dt IGS_CA_INST.END_DT%TYPE;
2385: l_acad_message VARCHAR2(30);
2386: l_temp NUMBER := 0 ;
2387: --dummy variable to pick up audit, billing, enrolled credit points
2388: --due to signature change by EN308 Billing credit hours Bug 3782329