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

Line 128: p_cal_type IN igs_ca_inst.cal_type%TYPE,

124: empty_suar_table suar_table_type;
125: suar_table suar_table_type;
126:
127: FUNCTION enrl_sort_usecs ( p_suat IN OUT NOCOPY t_sua_typ,
128: p_cal_type IN igs_ca_inst.cal_type%TYPE,
129: p_ci_seq_num IN igs_ps_unit_ofr_opt.ci_sequence_number%TYPE
130: ) RETURN VARCHAR2 AS
131: ------------------------------------------------------------------
132: --Created by : rvivekan, Oracle IDC

Line 319: p_cal_type IGS_CA_INST.cal_type%TYPE,

315: PROCEDURE enrpl_upd_sca_coo(
316: p_person_id IGS_PE_PERSON.person_id%TYPE,
317: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
318: p_crv_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,
319: p_cal_type IGS_CA_INST.cal_type%TYPE,
320: p_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
321: p_location_cd IGS_EN_STDNT_PS_ATT.location_cd%TYPE,
322: p_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE,
323: p_attendance_mode IGS_EN_STDNT_PS_ATT.attendance_mode%TYPE,

Line 320: p_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,

316: p_person_id IGS_PE_PERSON.person_id%TYPE,
317: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
318: p_crv_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,
319: p_cal_type IGS_CA_INST.cal_type%TYPE,
320: p_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
321: p_location_cd IGS_EN_STDNT_PS_ATT.location_cd%TYPE,
322: p_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE,
323: p_attendance_mode IGS_EN_STDNT_PS_ATT.attendance_mode%TYPE,
324: p_funding_source IGS_EN_STDNT_PS_ATT.funding_source%TYPE,

Line 1299: l_en_cal_type IGS_CA_INST.CAL_TYPE%TYPE;

1295: l_attendance_types VARCHAR2(100); -- As returned from the function igs_en_val_sca.enrp_val_coo_att
1296: l_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
1297: l_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE;
1298: l_person_type IGS_PE_PERSON_TYPES.person_type_code%TYPE;
1299: l_en_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
1300: l_en_ci_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
1301: l_enrolment_cat IGS_PS_TYPE.ENROLMENT_CAT%TYPE;
1302: l_unit_section_status IGS_PS_UNIT_OFR_OPT.unit_section_status%TYPE DEFAULT NULL;
1303: l_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE;

Line 1300: l_en_ci_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE;

1296: l_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
1297: l_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE;
1298: l_person_type IGS_PE_PERSON_TYPES.person_type_code%TYPE;
1299: l_en_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
1300: l_en_ci_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
1301: l_enrolment_cat IGS_PS_TYPE.ENROLMENT_CAT%TYPE;
1302: l_unit_section_status IGS_PS_UNIT_OFR_OPT.unit_section_status%TYPE DEFAULT NULL;
1303: l_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
1304: l_acad_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;

Line 1303: l_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE;

1299: l_en_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
1300: l_en_ci_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
1301: l_enrolment_cat IGS_PS_TYPE.ENROLMENT_CAT%TYPE;
1302: l_unit_section_status IGS_PS_UNIT_OFR_OPT.unit_section_status%TYPE DEFAULT NULL;
1303: l_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
1304: l_acad_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
1305: l_acad_ci_start_dt IGS_CA_INST.START_DT%TYPE;
1306: l_acad_ci_end_dt IGS_CA_INST.END_DT%TYPE;
1307: l_alternate_code IGS_CA_INST.ALTERNATE_CODE%TYPE;

Line 1304: l_acad_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;

1300: l_en_ci_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
1301: l_enrolment_cat IGS_PS_TYPE.ENROLMENT_CAT%TYPE;
1302: l_unit_section_status IGS_PS_UNIT_OFR_OPT.unit_section_status%TYPE DEFAULT NULL;
1303: l_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
1304: l_acad_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
1305: l_acad_ci_start_dt IGS_CA_INST.START_DT%TYPE;
1306: l_acad_ci_end_dt IGS_CA_INST.END_DT%TYPE;
1307: l_alternate_code IGS_CA_INST.ALTERNATE_CODE%TYPE;
1308: l_key IGS_GE_S_LOG_ENTRY.key%TYPE;

Line 1305: l_acad_ci_start_dt IGS_CA_INST.START_DT%TYPE;

1301: l_enrolment_cat IGS_PS_TYPE.ENROLMENT_CAT%TYPE;
1302: l_unit_section_status IGS_PS_UNIT_OFR_OPT.unit_section_status%TYPE DEFAULT NULL;
1303: l_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
1304: l_acad_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
1305: l_acad_ci_start_dt IGS_CA_INST.START_DT%TYPE;
1306: l_acad_ci_end_dt IGS_CA_INST.END_DT%TYPE;
1307: l_alternate_code IGS_CA_INST.ALTERNATE_CODE%TYPE;
1308: l_key IGS_GE_S_LOG_ENTRY.key%TYPE;
1309: l_course_key IGS_GE_S_LOG_ENTRY.key%TYPE;

Line 1306: l_acad_ci_end_dt IGS_CA_INST.END_DT%TYPE;

1302: l_unit_section_status IGS_PS_UNIT_OFR_OPT.unit_section_status%TYPE DEFAULT NULL;
1303: l_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
1304: l_acad_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
1305: l_acad_ci_start_dt IGS_CA_INST.START_DT%TYPE;
1306: l_acad_ci_end_dt IGS_CA_INST.END_DT%TYPE;
1307: l_alternate_code IGS_CA_INST.ALTERNATE_CODE%TYPE;
1308: l_key IGS_GE_S_LOG_ENTRY.key%TYPE;
1309: l_course_key IGS_GE_S_LOG_ENTRY.key%TYPE;
1310: l_unit_key IGS_GE_S_LOG_ENTRY.key%TYPE;

Line 1307: l_alternate_code IGS_CA_INST.ALTERNATE_CODE%TYPE;

1303: l_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
1304: l_acad_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
1305: l_acad_ci_start_dt IGS_CA_INST.START_DT%TYPE;
1306: l_acad_ci_end_dt IGS_CA_INST.END_DT%TYPE;
1307: l_alternate_code IGS_CA_INST.ALTERNATE_CODE%TYPE;
1308: l_key IGS_GE_S_LOG_ENTRY.key%TYPE;
1309: l_course_key IGS_GE_S_LOG_ENTRY.key%TYPE;
1310: l_unit_key IGS_GE_S_LOG_ENTRY.key%TYPE;
1311: l_text IGS_GE_S_LOG_ENTRY.text%TYPE;

Line 1419: CURSOR cur_cal_rel (cp_teach_cal_type igs_ca_inst.cal_type%TYPE,

1415: WHERE person_id = cp_person_id
1416: AND course_cd = cp_course_cd
1417: AND uoo_id = cp_uoo_id;
1418:
1419: CURSOR cur_cal_rel (cp_teach_cal_type igs_ca_inst.cal_type%TYPE,
1420: cp_teach_seq_num igs_ca_inst.sequence_number%TYPE,
1421: cp_load_cal_type igs_ca_inst.cal_type%TYPE,
1422: cp_load_seq_num igs_ca_inst.sequence_number%TYPE) IS
1423: SELECT '1'

Line 1420: cp_teach_seq_num igs_ca_inst.sequence_number%TYPE,

1416: AND course_cd = cp_course_cd
1417: AND uoo_id = cp_uoo_id;
1418:
1419: CURSOR cur_cal_rel (cp_teach_cal_type igs_ca_inst.cal_type%TYPE,
1420: cp_teach_seq_num igs_ca_inst.sequence_number%TYPE,
1421: cp_load_cal_type igs_ca_inst.cal_type%TYPE,
1422: cp_load_seq_num igs_ca_inst.sequence_number%TYPE) IS
1423: SELECT '1'
1424: FROM igs_ca_teach_to_load_v

Line 1421: cp_load_cal_type igs_ca_inst.cal_type%TYPE,

1417: AND uoo_id = cp_uoo_id;
1418:
1419: CURSOR cur_cal_rel (cp_teach_cal_type igs_ca_inst.cal_type%TYPE,
1420: cp_teach_seq_num igs_ca_inst.sequence_number%TYPE,
1421: cp_load_cal_type igs_ca_inst.cal_type%TYPE,
1422: cp_load_seq_num igs_ca_inst.sequence_number%TYPE) IS
1423: SELECT '1'
1424: FROM igs_ca_teach_to_load_v
1425: WHERE teach_cal_type = cp_teach_cal_type

Line 1422: cp_load_seq_num igs_ca_inst.sequence_number%TYPE) IS

1418:
1419: CURSOR cur_cal_rel (cp_teach_cal_type igs_ca_inst.cal_type%TYPE,
1420: cp_teach_seq_num igs_ca_inst.sequence_number%TYPE,
1421: cp_load_cal_type igs_ca_inst.cal_type%TYPE,
1422: cp_load_seq_num igs_ca_inst.sequence_number%TYPE) IS
1423: SELECT '1'
1424: FROM igs_ca_teach_to_load_v
1425: WHERE teach_cal_type = cp_teach_cal_type
1426: AND teach_ci_sequence_number = cp_teach_seq_num

Line 2779: CURSOR c_sua (cp_load_Cal_type IGS_CA_INST.CAL_TYPE%TYPE

2775: l_deny_enrollment VARCHAR2(1);
2776:
2777: -- cursor considers the term records which is fetching the student unit attempts based
2778: -- on the given criteria for unit section transfer
2779: CURSOR c_sua (cp_load_Cal_type IGS_CA_INST.CAL_TYPE%TYPE
2780: , cp_load_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE)IS
2781: SELECT sua.person_id,
2782: sua.course_cd,
2783: sua.location_cd,

Line 2780: , cp_load_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE)IS

2776:
2777: -- cursor considers the term records which is fetching the student unit attempts based
2778: -- on the given criteria for unit section transfer
2779: CURSOR c_sua (cp_load_Cal_type IGS_CA_INST.CAL_TYPE%TYPE
2780: , cp_load_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE)IS
2781: SELECT sua.person_id,
2782: sua.course_cd,
2783: sua.location_cd,
2784: sua.unit_class,

Line 2864: IGS_CA_INST ci,

2860: CURSOR cur_load1 IS
2861: SELECT tl.load_cal_type ,
2862: tl.load_ci_sequence_number
2863: FROM igs_ca_teach_to_load_v tl,
2864: IGS_CA_INST ci,
2865: IGS_CA_STAT cs
2866: WHERE tl.teach_cal_type = p_teach_cal_type
2867: AND tl.teach_ci_sequence_number = p_teach_ci_sequence_number
2868: AND ci.cal_type = tl.load_cal_type

Line 2888: v_acad_cal_type IGS_CA_INST.cal_type%TYPE ;

2884: v_warn_count NUMBER := 0;
2885: v_sua_trnsfr_count NUMBER := 0;
2886: v_total_lock_count NUMBER := 0;
2887: -- output variables
2888: v_acad_cal_type IGS_CA_INST.cal_type%TYPE ;
2889: v_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE ;
2890: v_acad_ci_start_dt IGS_CA_INST.start_dt%TYPE ;
2891: v_acad_ci_end_dt IGS_CA_INST.end_dt%TYPE ;
2892: v_message_name Varchar2(30) ;

Line 2889: v_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE ;

2885: v_sua_trnsfr_count NUMBER := 0;
2886: v_total_lock_count NUMBER := 0;
2887: -- output variables
2888: v_acad_cal_type IGS_CA_INST.cal_type%TYPE ;
2889: v_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE ;
2890: v_acad_ci_start_dt IGS_CA_INST.start_dt%TYPE ;
2891: v_acad_ci_end_dt IGS_CA_INST.end_dt%TYPE ;
2892: v_message_name Varchar2(30) ;
2893: v_teach_start_dt IGS_CA_INST.start_dt%TYPE ;

Line 2890: v_acad_ci_start_dt IGS_CA_INST.start_dt%TYPE ;

2886: v_total_lock_count NUMBER := 0;
2887: -- output variables
2888: v_acad_cal_type IGS_CA_INST.cal_type%TYPE ;
2889: v_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE ;
2890: v_acad_ci_start_dt IGS_CA_INST.start_dt%TYPE ;
2891: v_acad_ci_end_dt IGS_CA_INST.end_dt%TYPE ;
2892: v_message_name Varchar2(30) ;
2893: v_teach_start_dt IGS_CA_INST.start_dt%TYPE ;
2894: v_teach_end_dt IGS_CA_INST.end_dt%TYPE ;

Line 2891: v_acad_ci_end_dt IGS_CA_INST.end_dt%TYPE ;

2887: -- output variables
2888: v_acad_cal_type IGS_CA_INST.cal_type%TYPE ;
2889: v_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE ;
2890: v_acad_ci_start_dt IGS_CA_INST.start_dt%TYPE ;
2891: v_acad_ci_end_dt IGS_CA_INST.end_dt%TYPE ;
2892: v_message_name Varchar2(30) ;
2893: v_teach_start_dt IGS_CA_INST.start_dt%TYPE ;
2894: v_teach_end_dt IGS_CA_INST.end_dt%TYPE ;
2895: v_to_uv_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE := 0;

Line 2893: v_teach_start_dt IGS_CA_INST.start_dt%TYPE ;

2889: v_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE ;
2890: v_acad_ci_start_dt IGS_CA_INST.start_dt%TYPE ;
2891: v_acad_ci_end_dt IGS_CA_INST.end_dt%TYPE ;
2892: v_message_name Varchar2(30) ;
2893: v_teach_start_dt IGS_CA_INST.start_dt%TYPE ;
2894: v_teach_end_dt IGS_CA_INST.end_dt%TYPE ;
2895: v_to_uv_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE := 0;
2896: v_to_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE ;
2897: v_to_unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE ;

Line 2894: v_teach_end_dt IGS_CA_INST.end_dt%TYPE ;

2890: v_acad_ci_start_dt IGS_CA_INST.start_dt%TYPE ;
2891: v_acad_ci_end_dt IGS_CA_INST.end_dt%TYPE ;
2892: v_message_name Varchar2(30) ;
2893: v_teach_start_dt IGS_CA_INST.start_dt%TYPE ;
2894: v_teach_end_dt IGS_CA_INST.end_dt%TYPE ;
2895: v_to_uv_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE := 0;
2896: v_to_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE ;
2897: v_to_unit_class IGS_EN_SU_ATTEMPT.unit_class%TYPE ;
2898: v_rollback_occurred BOOLEAN := FALSE;

Line 2911: l_en_cal_type IGS_CA_INST.CAL_TYPE%TYPE;

2907: v_creation_dt IGS_GE_S_LOG.creation_dt%TYPE ;
2908:
2909: l_enrolment_cat IGS_PS_TYPE.ENROLMENT_CAT%TYPE;
2910: l_commencement_type VARCHAR2(20) DEFAULT NULL;
2911: l_en_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
2912: l_en_ci_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
2913: l_person_type IGS_PE_PERSON_TYPES.person_type_code%TYPE;
2914: l_waitlist_flag VARCHAR2(1) DEFAULT 'N';
2915: l_load_cal_type IGS_CA_INST.CAL_TYPE%TYPE;

Line 2912: l_en_ci_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE;

2908:
2909: l_enrolment_cat IGS_PS_TYPE.ENROLMENT_CAT%TYPE;
2910: l_commencement_type VARCHAR2(20) DEFAULT NULL;
2911: l_en_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
2912: l_en_ci_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
2913: l_person_type IGS_PE_PERSON_TYPES.person_type_code%TYPE;
2914: l_waitlist_flag VARCHAR2(1) DEFAULT 'N';
2915: l_load_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
2916: l_load_seq_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;

Line 2915: l_load_cal_type IGS_CA_INST.CAL_TYPE%TYPE;

2911: l_en_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
2912: l_en_ci_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
2913: l_person_type IGS_PE_PERSON_TYPES.person_type_code%TYPE;
2914: l_waitlist_flag VARCHAR2(1) DEFAULT 'N';
2915: l_load_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
2916: l_load_seq_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
2917: l_unit_attempt_status IGS_EN_SU_ATTEMPT.UNIT_ATTEMPT_STATUS%TYPE;
2918: l_destination_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE;
2919: l_dummy1 VARCHAR2(30);

Line 2916: l_load_seq_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;

2912: l_en_ci_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
2913: l_person_type IGS_PE_PERSON_TYPES.person_type_code%TYPE;
2914: l_waitlist_flag VARCHAR2(1) DEFAULT 'N';
2915: l_load_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
2916: l_load_seq_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
2917: l_unit_attempt_status IGS_EN_SU_ATTEMPT.UNIT_ATTEMPT_STATUS%TYPE;
2918: l_destination_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE;
2919: l_dummy1 VARCHAR2(30);
2920: l_dummy2 VARCHAR2(30);

Line 2929: p_teach_end_dt IGS_CA_INST.end_dt%TYPE,

2925: p_course_cd IGS_PS_VER.course_cd%TYPE,
2926: p_version_number IGS_PS_UNIT_VER.version_number%TYPE, --program version
2927: p_u_version_number IGS_PS_UNIT_VER.version_number%TYPE, --unit version
2928: p_from_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE,
2929: p_teach_end_dt IGS_CA_INST.end_dt%TYPE,
2930: p_location_cd IGS_AD_LOCATION.location_cd%TYPE,
2931: p_unit_class IGS_AS_UNIT_CLASS.unit_class%TYPE,
2932: p_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE,
2933: p_enrolled_dt IGS_EN_SU_ATTEMPT.enrolled_dt%TYPE,