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_ST_GEN_004 dependencies on IGS_EN_ST_SNAPSHOT

Line 256: v_load_cal_type IGS_EN_ST_SNAPSHOT.ci_cal_type%TYPE DEFAULT NULL;

252: v_attendance_mode_2 IGS_EN_ATD_MODE.attendance_mode%TYPE;
253: v_govt_attendance_mode_2 IGS_EN_ATD_MODE.govt_attendance_mode%TYPE;
254: v_attendance_mode_3 IGS_EN_ATD_MODE.attendance_mode%TYPE;
255: v_govt_attendance_mode_3 IGS_EN_ATD_MODE.govt_attendance_mode%TYPE;
256: v_load_cal_type IGS_EN_ST_SNAPSHOT.ci_cal_type%TYPE DEFAULT NULL;
257: v_load_ci_sequence_number
258: IGS_EN_ST_SNAPSHOT.ci_sequence_number%TYPE DEFAULT NULL;
259: v_teach_cal_type IGS_EN_ST_SNAPSHOT.sua_cal_type%TYPE DEFAULT NULL;
260: v_teach_ci_sequence_number

Line 258: IGS_EN_ST_SNAPSHOT.ci_sequence_number%TYPE DEFAULT NULL;

254: v_attendance_mode_3 IGS_EN_ATD_MODE.attendance_mode%TYPE;
255: v_govt_attendance_mode_3 IGS_EN_ATD_MODE.govt_attendance_mode%TYPE;
256: v_load_cal_type IGS_EN_ST_SNAPSHOT.ci_cal_type%TYPE DEFAULT NULL;
257: v_load_ci_sequence_number
258: IGS_EN_ST_SNAPSHOT.ci_sequence_number%TYPE DEFAULT NULL;
259: v_teach_cal_type IGS_EN_ST_SNAPSHOT.sua_cal_type%TYPE DEFAULT NULL;
260: v_teach_ci_sequence_number
261: IGS_EN_ST_SNAPSHOT.sua_ci_sequence_number%TYPE DEFAULT NULL;
262: v_person_id IGS_PE_STATISTICS.person_id%TYPE DEFAULT NULL;

Line 259: v_teach_cal_type IGS_EN_ST_SNAPSHOT.sua_cal_type%TYPE DEFAULT NULL;

255: v_govt_attendance_mode_3 IGS_EN_ATD_MODE.govt_attendance_mode%TYPE;
256: v_load_cal_type IGS_EN_ST_SNAPSHOT.ci_cal_type%TYPE DEFAULT NULL;
257: v_load_ci_sequence_number
258: IGS_EN_ST_SNAPSHOT.ci_sequence_number%TYPE DEFAULT NULL;
259: v_teach_cal_type IGS_EN_ST_SNAPSHOT.sua_cal_type%TYPE DEFAULT NULL;
260: v_teach_ci_sequence_number
261: IGS_EN_ST_SNAPSHOT.sua_ci_sequence_number%TYPE DEFAULT NULL;
262: v_person_id IGS_PE_STATISTICS.person_id%TYPE DEFAULT NULL;
263: v_course_cd IGS_EN_ST_SNAPSHOT.course_cd%TYPE DEFAULT NULL;

Line 261: IGS_EN_ST_SNAPSHOT.sua_ci_sequence_number%TYPE DEFAULT NULL;

257: v_load_ci_sequence_number
258: IGS_EN_ST_SNAPSHOT.ci_sequence_number%TYPE DEFAULT NULL;
259: v_teach_cal_type IGS_EN_ST_SNAPSHOT.sua_cal_type%TYPE DEFAULT NULL;
260: v_teach_ci_sequence_number
261: IGS_EN_ST_SNAPSHOT.sua_ci_sequence_number%TYPE DEFAULT NULL;
262: v_person_id IGS_PE_STATISTICS.person_id%TYPE DEFAULT NULL;
263: v_course_cd IGS_EN_ST_SNAPSHOT.course_cd%TYPE DEFAULT NULL;
264: v_gse_person_id IGS_PE_STATISTICS.person_id%TYPE DEFAULT NULL;
265: v_gse_course_cd IGS_EN_ST_SNAPSHOT.course_cd%TYPE DEFAULT NULL;

Line 263: v_course_cd IGS_EN_ST_SNAPSHOT.course_cd%TYPE DEFAULT NULL;

259: v_teach_cal_type IGS_EN_ST_SNAPSHOT.sua_cal_type%TYPE DEFAULT NULL;
260: v_teach_ci_sequence_number
261: IGS_EN_ST_SNAPSHOT.sua_ci_sequence_number%TYPE DEFAULT NULL;
262: v_person_id IGS_PE_STATISTICS.person_id%TYPE DEFAULT NULL;
263: v_course_cd IGS_EN_ST_SNAPSHOT.course_cd%TYPE DEFAULT NULL;
264: v_gse_person_id IGS_PE_STATISTICS.person_id%TYPE DEFAULT NULL;
265: v_gse_course_cd IGS_EN_ST_SNAPSHOT.course_cd%TYPE DEFAULT NULL;
266: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE DEFAULT NULL;
267: v_govt_semester IGS_ST_GVT_STDNTLOAD.govt_semester%TYPE DEFAULT NULL;

Line 265: v_gse_course_cd IGS_EN_ST_SNAPSHOT.course_cd%TYPE DEFAULT NULL;

261: IGS_EN_ST_SNAPSHOT.sua_ci_sequence_number%TYPE DEFAULT NULL;
262: v_person_id IGS_PE_STATISTICS.person_id%TYPE DEFAULT NULL;
263: v_course_cd IGS_EN_ST_SNAPSHOT.course_cd%TYPE DEFAULT NULL;
264: v_gse_person_id IGS_PE_STATISTICS.person_id%TYPE DEFAULT NULL;
265: v_gse_course_cd IGS_EN_ST_SNAPSHOT.course_cd%TYPE DEFAULT NULL;
266: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE DEFAULT NULL;
267: v_govt_semester IGS_ST_GVT_STDNTLOAD.govt_semester%TYPE DEFAULT NULL;
268: v_govt_reportable IGS_EN_ST_SNAPSHOT.govt_reportable_ind%TYPE;
269: v_birth_dt IGS_ST_GOVT_STDNT_EN.birth_dt%TYPE;

Line 268: v_govt_reportable IGS_EN_ST_SNAPSHOT.govt_reportable_ind%TYPE;

264: v_gse_person_id IGS_PE_STATISTICS.person_id%TYPE DEFAULT NULL;
265: v_gse_course_cd IGS_EN_ST_SNAPSHOT.course_cd%TYPE DEFAULT NULL;
266: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE DEFAULT NULL;
267: v_govt_semester IGS_ST_GVT_STDNTLOAD.govt_semester%TYPE DEFAULT NULL;
268: v_govt_reportable IGS_EN_ST_SNAPSHOT.govt_reportable_ind%TYPE;
269: v_birth_dt IGS_ST_GOVT_STDNT_EN.birth_dt%TYPE;
270: v_sex IGS_ST_GOVT_STDNT_EN.sex%TYPE;
271: v_govt_disability IGS_ST_GOVT_STDNT_EN.govt_disability%TYPE;
272: v_aborig_torres_cd IGS_ST_GOVT_STDNT_EN.aborig_torres_cd%TYPE;

Line 450: FROM IGS_EN_ST_SNAPSHOT ess,

446: ess.commencing_student_ind,
447: ct.award_course_ind,
448: uoo.uoo_id,
449: ess.sua_location_cd
450: FROM IGS_EN_ST_SNAPSHOT ess,
451: IGS_PS_TYPE ct,
452: igs_ps_unit_ofr_opt uoo
453: WHERE ess.snapshot_dt_time = cp_dt_time AND
454: ess.govt_reportable_ind <> 'X' AND

Line 480: cp_teach_cal_type IGS_EN_ST_SNAPSHOT.sua_cal_type%TYPE,

476: daiv.ci_sequence_number = cp_teach_ci_seq_num AND
477: daiv.dt_alias = sgcc.census_dt_alias
478: ORDER BY daiv.alias_val ASC;
479: CURSOR c_ci (
480: cp_teach_cal_type IGS_EN_ST_SNAPSHOT.sua_cal_type%TYPE,
481: cp_teach_ci_sequence_number
482: IGS_EN_ST_SNAPSHOT.sua_ci_sequence_number%TYPE) IS
483: SELECT ci.start_dt,
484: ci.end_dt

Line 482: IGS_EN_ST_SNAPSHOT.sua_ci_sequence_number%TYPE) IS

478: ORDER BY daiv.alias_val ASC;
479: CURSOR c_ci (
480: cp_teach_cal_type IGS_EN_ST_SNAPSHOT.sua_cal_type%TYPE,
481: cp_teach_ci_sequence_number
482: IGS_EN_ST_SNAPSHOT.sua_ci_sequence_number%TYPE) IS
483: SELECT ci.start_dt,
484: ci.end_dt
485: FROM IGS_CA_INST ci
486: WHERE ci.cal_type = cp_teach_cal_type AND

Line 729: p_person_id IGS_EN_ST_SNAPSHOT.person_id%TYPE,

725: gse.course_cd = cp_course_cd
726: FOR UPDATE OF gse.commencement_dt NOWAIT;
727:
728: PROCEDURE stapl_val_unit_compltn_status(
729: p_person_id IGS_EN_ST_SNAPSHOT.person_id%TYPE,
730: p_course_cd IGS_EN_ST_SNAPSHOT.course_cd%TYPE,
731: p_unit_cd IGS_EN_ST_SNAPSHOT.unit_cd%TYPE,
732: p_sua_cal_type IGS_EN_ST_SNAPSHOT.sua_cal_type%TYPE,
733: p_sua_ci_sequence_number IGS_EN_ST_SNAPSHOT.sua_ci_sequence_number%TYPE,

Line 730: p_course_cd IGS_EN_ST_SNAPSHOT.course_cd%TYPE,

726: FOR UPDATE OF gse.commencement_dt NOWAIT;
727:
728: PROCEDURE stapl_val_unit_compltn_status(
729: p_person_id IGS_EN_ST_SNAPSHOT.person_id%TYPE,
730: p_course_cd IGS_EN_ST_SNAPSHOT.course_cd%TYPE,
731: p_unit_cd IGS_EN_ST_SNAPSHOT.unit_cd%TYPE,
732: p_sua_cal_type IGS_EN_ST_SNAPSHOT.sua_cal_type%TYPE,
733: p_sua_ci_sequence_number IGS_EN_ST_SNAPSHOT.sua_ci_sequence_number%TYPE,
734: p_unit_completion_status OUT NOCOPY NUMBER,

Line 731: p_unit_cd IGS_EN_ST_SNAPSHOT.unit_cd%TYPE,

727:
728: PROCEDURE stapl_val_unit_compltn_status(
729: p_person_id IGS_EN_ST_SNAPSHOT.person_id%TYPE,
730: p_course_cd IGS_EN_ST_SNAPSHOT.course_cd%TYPE,
731: p_unit_cd IGS_EN_ST_SNAPSHOT.unit_cd%TYPE,
732: p_sua_cal_type IGS_EN_ST_SNAPSHOT.sua_cal_type%TYPE,
733: p_sua_ci_sequence_number IGS_EN_ST_SNAPSHOT.sua_ci_sequence_number%TYPE,
734: p_unit_completion_status OUT NOCOPY NUMBER,
735: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE)

Line 732: p_sua_cal_type IGS_EN_ST_SNAPSHOT.sua_cal_type%TYPE,

728: PROCEDURE stapl_val_unit_compltn_status(
729: p_person_id IGS_EN_ST_SNAPSHOT.person_id%TYPE,
730: p_course_cd IGS_EN_ST_SNAPSHOT.course_cd%TYPE,
731: p_unit_cd IGS_EN_ST_SNAPSHOT.unit_cd%TYPE,
732: p_sua_cal_type IGS_EN_ST_SNAPSHOT.sua_cal_type%TYPE,
733: p_sua_ci_sequence_number IGS_EN_ST_SNAPSHOT.sua_ci_sequence_number%TYPE,
734: p_unit_completion_status OUT NOCOPY NUMBER,
735: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE)
736: AS

Line 733: p_sua_ci_sequence_number IGS_EN_ST_SNAPSHOT.sua_ci_sequence_number%TYPE,

729: p_person_id IGS_EN_ST_SNAPSHOT.person_id%TYPE,
730: p_course_cd IGS_EN_ST_SNAPSHOT.course_cd%TYPE,
731: p_unit_cd IGS_EN_ST_SNAPSHOT.unit_cd%TYPE,
732: p_sua_cal_type IGS_EN_ST_SNAPSHOT.sua_cal_type%TYPE,
733: p_sua_ci_sequence_number IGS_EN_ST_SNAPSHOT.sua_ci_sequence_number%TYPE,
734: p_unit_completion_status OUT NOCOPY NUMBER,
735: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE)
736: AS
737: gv_other_detail VARCHAR2(255);

Line 838: p_current_person_id IGS_EN_ST_SNAPSHOT.person_id%TYPE,

834: IGS_GE_MSG_STACK.ADD;
835: App_Exception.Raise_Exception;
836: END stapl_ins_govt_sdnt_load_rec;
837: PROCEDURE stapl_get_sca_data_for_liab(
838: p_current_person_id IGS_EN_ST_SNAPSHOT.person_id%TYPE,
839: -- current person_id
840: p_old_person_id IGS_EN_ST_SNAPSHOT.person_id%TYPE,
841: -- last person_id retrieved
842: p_current_course_cd IGS_EN_ST_SNAPSHOT.course_cd%TYPE,

Line 840: p_old_person_id IGS_EN_ST_SNAPSHOT.person_id%TYPE,

836: END stapl_ins_govt_sdnt_load_rec;
837: PROCEDURE stapl_get_sca_data_for_liab(
838: p_current_person_id IGS_EN_ST_SNAPSHOT.person_id%TYPE,
839: -- current person_id
840: p_old_person_id IGS_EN_ST_SNAPSHOT.person_id%TYPE,
841: -- last person_id retrieved
842: p_current_course_cd IGS_EN_ST_SNAPSHOT.course_cd%TYPE,
843: -- current course_cd
844: p_old_course_cd IGS_EN_ST_SNAPSHOT.course_cd%TYPE,

Line 842: p_current_course_cd IGS_EN_ST_SNAPSHOT.course_cd%TYPE,

838: p_current_person_id IGS_EN_ST_SNAPSHOT.person_id%TYPE,
839: -- current person_id
840: p_old_person_id IGS_EN_ST_SNAPSHOT.person_id%TYPE,
841: -- last person_id retrieved
842: p_current_course_cd IGS_EN_ST_SNAPSHOT.course_cd%TYPE,
843: -- current course_cd
844: p_old_course_cd IGS_EN_ST_SNAPSHOT.course_cd%TYPE,
845: -- last course_cdretrieved
846: p_effective_dt DATE,

Line 844: p_old_course_cd IGS_EN_ST_SNAPSHOT.course_cd%TYPE,

840: p_old_person_id IGS_EN_ST_SNAPSHOT.person_id%TYPE,
841: -- last person_id retrieved
842: p_current_course_cd IGS_EN_ST_SNAPSHOT.course_cd%TYPE,
843: -- current course_cd
844: p_old_course_cd IGS_EN_ST_SNAPSHOT.course_cd%TYPE,
845: -- last course_cdretrieved
846: p_effective_dt DATE,
847: p_logged_ind IN OUT NOCOPY BOOLEAN,
848: p_s_log_type VARCHAR2,

Line 2851: FROM IGS_EN_ST_SNAPSHOT ess

2847: t_blank t_units_typ;
2848: cst_exempt CONSTANT VARCHAR2(6) := 'EXEMPT';
2849: CURSOR c_ess IS
2850: SELECT UNIQUE ess.snapshot_dt_time
2851: FROM IGS_EN_ST_SNAPSHOT ess
2852: ORDER BY ess.snapshot_dt_time DESC;
2853: CURSOR c_gsli_gslc IS
2854: SELECT gsli.person_id,
2855: gsli.course_cd,

Line 2995: cp_snapshot_dt_time IGS_EN_ST_SNAPSHOT.snapshot_dt_time%TYPE,

2991: gslo.sua_ci_sequence_number = uoo.ci_sequence_number AND
2992: gslo.sua_location_cd = uoo.location_cd AND
2993: gslo.unit_class = uoo.unit_class;
2994: CURSOR c_ess_uv_gslc (
2995: cp_snapshot_dt_time IGS_EN_ST_SNAPSHOT.snapshot_dt_time%TYPE,
2996: cp_govt_semester IGS_ST_GVTSEMLOAD_CA.govt_semester%TYPE,
2997: cp_person_id IGS_EN_ST_SNAPSHOT.person_id%TYPE,
2998: cp_course_cd IGS_EN_ST_SNAPSHOT.course_cd%TYPE) IS
2999: SELECT ess.unit_cd,

Line 2997: cp_person_id IGS_EN_ST_SNAPSHOT.person_id%TYPE,

2993: gslo.unit_class = uoo.unit_class;
2994: CURSOR c_ess_uv_gslc (
2995: cp_snapshot_dt_time IGS_EN_ST_SNAPSHOT.snapshot_dt_time%TYPE,
2996: cp_govt_semester IGS_ST_GVTSEMLOAD_CA.govt_semester%TYPE,
2997: cp_person_id IGS_EN_ST_SNAPSHOT.person_id%TYPE,
2998: cp_course_cd IGS_EN_ST_SNAPSHOT.course_cd%TYPE) IS
2999: SELECT ess.unit_cd,
3000: ess.sua_cal_type,
3001: ess.sua_ci_sequence_number,

Line 2998: cp_course_cd IGS_EN_ST_SNAPSHOT.course_cd%TYPE) IS

2994: CURSOR c_ess_uv_gslc (
2995: cp_snapshot_dt_time IGS_EN_ST_SNAPSHOT.snapshot_dt_time%TYPE,
2996: cp_govt_semester IGS_ST_GVTSEMLOAD_CA.govt_semester%TYPE,
2997: cp_person_id IGS_EN_ST_SNAPSHOT.person_id%TYPE,
2998: cp_course_cd IGS_EN_ST_SNAPSHOT.course_cd%TYPE) IS
2999: SELECT ess.unit_cd,
3000: ess.sua_cal_type,
3001: ess.sua_ci_sequence_number,
3002: ess.tr_org_unit_cd,

Line 3014: FROM IGS_EN_ST_SNAPSHOT ess,

3010: ess.discontinued_dt,
3011: ess.ci_cal_type,
3012: ess.ci_sequence_number,
3013: uoo.uoo_id
3014: FROM IGS_EN_ST_SNAPSHOT ess,
3015: IGS_PS_UNIT_VER uv,
3016: IGS_ST_GVTSEMLOAD_CA gslc,
3017: igs_ps_unit_ofr_opt uoo
3018: WHERE ess.snapshot_dt_time = cp_snapshot_dt_time AND

Line 3179: v_unit_cd IGS_EN_ST_SNAPSHOT.unit_cd%TYPE;

3175: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
3176: v_message_name VARCHAR2(30);
3177: v_hecs_amount_paid NUMBER;
3178: v_dummy VARCHAR2(1);
3179: v_unit_cd IGS_EN_ST_SNAPSHOT.unit_cd%TYPE;
3180: v_uv_version_number IGS_EN_ST_SNAPSHOT.uv_version_number%TYPE;
3181: v_sua_cal_type IGS_EN_ST_SNAPSHOT.sua_cal_type%TYPE;
3182: v_sua_ci_sequence_number IGS_EN_ST_SNAPSHOT.sua_ci_sequence_number%TYPE;
3183: v_tr_org_unit_cd IGS_EN_ST_SNAPSHOT.tr_org_unit_cd%TYPE;

Line 3180: v_uv_version_number IGS_EN_ST_SNAPSHOT.uv_version_number%TYPE;

3176: v_message_name VARCHAR2(30);
3177: v_hecs_amount_paid NUMBER;
3178: v_dummy VARCHAR2(1);
3179: v_unit_cd IGS_EN_ST_SNAPSHOT.unit_cd%TYPE;
3180: v_uv_version_number IGS_EN_ST_SNAPSHOT.uv_version_number%TYPE;
3181: v_sua_cal_type IGS_EN_ST_SNAPSHOT.sua_cal_type%TYPE;
3182: v_sua_ci_sequence_number IGS_EN_ST_SNAPSHOT.sua_ci_sequence_number%TYPE;
3183: v_tr_org_unit_cd IGS_EN_ST_SNAPSHOT.tr_org_unit_cd%TYPE;
3184: v_tr_ou_start_dt IGS_EN_ST_SNAPSHOT.tr_ou_start_dt%TYPE;

Line 3181: v_sua_cal_type IGS_EN_ST_SNAPSHOT.sua_cal_type%TYPE;

3177: v_hecs_amount_paid NUMBER;
3178: v_dummy VARCHAR2(1);
3179: v_unit_cd IGS_EN_ST_SNAPSHOT.unit_cd%TYPE;
3180: v_uv_version_number IGS_EN_ST_SNAPSHOT.uv_version_number%TYPE;
3181: v_sua_cal_type IGS_EN_ST_SNAPSHOT.sua_cal_type%TYPE;
3182: v_sua_ci_sequence_number IGS_EN_ST_SNAPSHOT.sua_ci_sequence_number%TYPE;
3183: v_tr_org_unit_cd IGS_EN_ST_SNAPSHOT.tr_org_unit_cd%TYPE;
3184: v_tr_ou_start_dt IGS_EN_ST_SNAPSHOT.tr_ou_start_dt%TYPE;
3185: v_eftsu IGS_EN_ST_SNAPSHOT.eftsu%TYPE;

Line 3182: v_sua_ci_sequence_number IGS_EN_ST_SNAPSHOT.sua_ci_sequence_number%TYPE;

3178: v_dummy VARCHAR2(1);
3179: v_unit_cd IGS_EN_ST_SNAPSHOT.unit_cd%TYPE;
3180: v_uv_version_number IGS_EN_ST_SNAPSHOT.uv_version_number%TYPE;
3181: v_sua_cal_type IGS_EN_ST_SNAPSHOT.sua_cal_type%TYPE;
3182: v_sua_ci_sequence_number IGS_EN_ST_SNAPSHOT.sua_ci_sequence_number%TYPE;
3183: v_tr_org_unit_cd IGS_EN_ST_SNAPSHOT.tr_org_unit_cd%TYPE;
3184: v_tr_ou_start_dt IGS_EN_ST_SNAPSHOT.tr_ou_start_dt%TYPE;
3185: v_eftsu IGS_EN_ST_SNAPSHOT.eftsu%TYPE;
3186: v_enrolled_dt IGS_EN_ST_SNAPSHOT.enrolled_dt%TYPE;

Line 3183: v_tr_org_unit_cd IGS_EN_ST_SNAPSHOT.tr_org_unit_cd%TYPE;

3179: v_unit_cd IGS_EN_ST_SNAPSHOT.unit_cd%TYPE;
3180: v_uv_version_number IGS_EN_ST_SNAPSHOT.uv_version_number%TYPE;
3181: v_sua_cal_type IGS_EN_ST_SNAPSHOT.sua_cal_type%TYPE;
3182: v_sua_ci_sequence_number IGS_EN_ST_SNAPSHOT.sua_ci_sequence_number%TYPE;
3183: v_tr_org_unit_cd IGS_EN_ST_SNAPSHOT.tr_org_unit_cd%TYPE;
3184: v_tr_ou_start_dt IGS_EN_ST_SNAPSHOT.tr_ou_start_dt%TYPE;
3185: v_eftsu IGS_EN_ST_SNAPSHOT.eftsu%TYPE;
3186: v_enrolled_dt IGS_EN_ST_SNAPSHOT.enrolled_dt%TYPE;
3187: v_discontinued_dt IGS_EN_ST_SNAPSHOT.discontinued_dt%TYPE;

Line 3184: v_tr_ou_start_dt IGS_EN_ST_SNAPSHOT.tr_ou_start_dt%TYPE;

3180: v_uv_version_number IGS_EN_ST_SNAPSHOT.uv_version_number%TYPE;
3181: v_sua_cal_type IGS_EN_ST_SNAPSHOT.sua_cal_type%TYPE;
3182: v_sua_ci_sequence_number IGS_EN_ST_SNAPSHOT.sua_ci_sequence_number%TYPE;
3183: v_tr_org_unit_cd IGS_EN_ST_SNAPSHOT.tr_org_unit_cd%TYPE;
3184: v_tr_ou_start_dt IGS_EN_ST_SNAPSHOT.tr_ou_start_dt%TYPE;
3185: v_eftsu IGS_EN_ST_SNAPSHOT.eftsu%TYPE;
3186: v_enrolled_dt IGS_EN_ST_SNAPSHOT.enrolled_dt%TYPE;
3187: v_discontinued_dt IGS_EN_ST_SNAPSHOT.discontinued_dt%TYPE;
3188: v_old_unit_cd IGS_EN_ST_SNAPSHOT.unit_cd%TYPE;

Line 3185: v_eftsu IGS_EN_ST_SNAPSHOT.eftsu%TYPE;

3181: v_sua_cal_type IGS_EN_ST_SNAPSHOT.sua_cal_type%TYPE;
3182: v_sua_ci_sequence_number IGS_EN_ST_SNAPSHOT.sua_ci_sequence_number%TYPE;
3183: v_tr_org_unit_cd IGS_EN_ST_SNAPSHOT.tr_org_unit_cd%TYPE;
3184: v_tr_ou_start_dt IGS_EN_ST_SNAPSHOT.tr_ou_start_dt%TYPE;
3185: v_eftsu IGS_EN_ST_SNAPSHOT.eftsu%TYPE;
3186: v_enrolled_dt IGS_EN_ST_SNAPSHOT.enrolled_dt%TYPE;
3187: v_discontinued_dt IGS_EN_ST_SNAPSHOT.discontinued_dt%TYPE;
3188: v_old_unit_cd IGS_EN_ST_SNAPSHOT.unit_cd%TYPE;
3189: v_old_eftsu IGS_EN_ST_SNAPSHOT.eftsu%TYPE;

Line 3186: v_enrolled_dt IGS_EN_ST_SNAPSHOT.enrolled_dt%TYPE;

3182: v_sua_ci_sequence_number IGS_EN_ST_SNAPSHOT.sua_ci_sequence_number%TYPE;
3183: v_tr_org_unit_cd IGS_EN_ST_SNAPSHOT.tr_org_unit_cd%TYPE;
3184: v_tr_ou_start_dt IGS_EN_ST_SNAPSHOT.tr_ou_start_dt%TYPE;
3185: v_eftsu IGS_EN_ST_SNAPSHOT.eftsu%TYPE;
3186: v_enrolled_dt IGS_EN_ST_SNAPSHOT.enrolled_dt%TYPE;
3187: v_discontinued_dt IGS_EN_ST_SNAPSHOT.discontinued_dt%TYPE;
3188: v_old_unit_cd IGS_EN_ST_SNAPSHOT.unit_cd%TYPE;
3189: v_old_eftsu IGS_EN_ST_SNAPSHOT.eftsu%TYPE;
3190: v_new_unit_cd IGS_EN_ST_SNAPSHOT.unit_cd%TYPE;

Line 3187: v_discontinued_dt IGS_EN_ST_SNAPSHOT.discontinued_dt%TYPE;

3183: v_tr_org_unit_cd IGS_EN_ST_SNAPSHOT.tr_org_unit_cd%TYPE;
3184: v_tr_ou_start_dt IGS_EN_ST_SNAPSHOT.tr_ou_start_dt%TYPE;
3185: v_eftsu IGS_EN_ST_SNAPSHOT.eftsu%TYPE;
3186: v_enrolled_dt IGS_EN_ST_SNAPSHOT.enrolled_dt%TYPE;
3187: v_discontinued_dt IGS_EN_ST_SNAPSHOT.discontinued_dt%TYPE;
3188: v_old_unit_cd IGS_EN_ST_SNAPSHOT.unit_cd%TYPE;
3189: v_old_eftsu IGS_EN_ST_SNAPSHOT.eftsu%TYPE;
3190: v_new_unit_cd IGS_EN_ST_SNAPSHOT.unit_cd%TYPE;
3191: v_new_eftsu IGS_EN_ST_SNAPSHOT.eftsu%TYPE;

Line 3188: v_old_unit_cd IGS_EN_ST_SNAPSHOT.unit_cd%TYPE;

3184: v_tr_ou_start_dt IGS_EN_ST_SNAPSHOT.tr_ou_start_dt%TYPE;
3185: v_eftsu IGS_EN_ST_SNAPSHOT.eftsu%TYPE;
3186: v_enrolled_dt IGS_EN_ST_SNAPSHOT.enrolled_dt%TYPE;
3187: v_discontinued_dt IGS_EN_ST_SNAPSHOT.discontinued_dt%TYPE;
3188: v_old_unit_cd IGS_EN_ST_SNAPSHOT.unit_cd%TYPE;
3189: v_old_eftsu IGS_EN_ST_SNAPSHOT.eftsu%TYPE;
3190: v_new_unit_cd IGS_EN_ST_SNAPSHOT.unit_cd%TYPE;
3191: v_new_eftsu IGS_EN_ST_SNAPSHOT.eftsu%TYPE;
3192: v_last_updated_by IGS_EN_STDNTPSHECSOP.last_updated_by%TYPE;

Line 3189: v_old_eftsu IGS_EN_ST_SNAPSHOT.eftsu%TYPE;

3185: v_eftsu IGS_EN_ST_SNAPSHOT.eftsu%TYPE;
3186: v_enrolled_dt IGS_EN_ST_SNAPSHOT.enrolled_dt%TYPE;
3187: v_discontinued_dt IGS_EN_ST_SNAPSHOT.discontinued_dt%TYPE;
3188: v_old_unit_cd IGS_EN_ST_SNAPSHOT.unit_cd%TYPE;
3189: v_old_eftsu IGS_EN_ST_SNAPSHOT.eftsu%TYPE;
3190: v_new_unit_cd IGS_EN_ST_SNAPSHOT.unit_cd%TYPE;
3191: v_new_eftsu IGS_EN_ST_SNAPSHOT.eftsu%TYPE;
3192: v_last_updated_by IGS_EN_STDNTPSHECSOP.last_updated_by%TYPE;
3193: v_last_update_date IGS_EN_STDNTPSHECSOP.last_update_date%TYPE;

Line 3190: v_new_unit_cd IGS_EN_ST_SNAPSHOT.unit_cd%TYPE;

3186: v_enrolled_dt IGS_EN_ST_SNAPSHOT.enrolled_dt%TYPE;
3187: v_discontinued_dt IGS_EN_ST_SNAPSHOT.discontinued_dt%TYPE;
3188: v_old_unit_cd IGS_EN_ST_SNAPSHOT.unit_cd%TYPE;
3189: v_old_eftsu IGS_EN_ST_SNAPSHOT.eftsu%TYPE;
3190: v_new_unit_cd IGS_EN_ST_SNAPSHOT.unit_cd%TYPE;
3191: v_new_eftsu IGS_EN_ST_SNAPSHOT.eftsu%TYPE;
3192: v_last_updated_by IGS_EN_STDNTPSHECSOP.last_updated_by%TYPE;
3193: v_last_update_date IGS_EN_STDNTPSHECSOP.last_update_date%TYPE;
3194: v_old_units_rows NUMBER;

Line 3191: v_new_eftsu IGS_EN_ST_SNAPSHOT.eftsu%TYPE;

3187: v_discontinued_dt IGS_EN_ST_SNAPSHOT.discontinued_dt%TYPE;
3188: v_old_unit_cd IGS_EN_ST_SNAPSHOT.unit_cd%TYPE;
3189: v_old_eftsu IGS_EN_ST_SNAPSHOT.eftsu%TYPE;
3190: v_new_unit_cd IGS_EN_ST_SNAPSHOT.unit_cd%TYPE;
3191: v_new_eftsu IGS_EN_ST_SNAPSHOT.eftsu%TYPE;
3192: v_last_updated_by IGS_EN_STDNTPSHECSOP.last_updated_by%TYPE;
3193: v_last_update_date IGS_EN_STDNTPSHECSOP.last_update_date%TYPE;
3194: v_old_units_rows NUMBER;
3195: v_new_units_rows NUMBER;

Line 3205: IGS_EN_ST_SNAPSHOT.govt_discipline_group_cd%TYPE;

3201: v_char_date VARCHAR2(10);
3202: v_crv_version_number IGS_ST_GVT_STDNT_LBL.version_number%TYPE;
3203: v_govt_reportable_ind VARCHAR2(1);
3204: v_govt_discipline_group_cd
3205: IGS_EN_ST_SNAPSHOT.govt_discipline_group_cd%TYPE;
3206: v_industrial_ind IGS_PS_UNIT_VER.industrial_ind%TYPE;
3207: v_old_cntr NUMBER;
3208: v_new_cntr NUMBER;
3209: v_citizenship_cd IGS_PE_STATISTICS.citizenship_cd%TYPE;