[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 'Y'
FROM igs_ps_type_all pt, igs_ps_ver_all cv
WHERE cv.course_cd = p_course_cd AND
cv.version_number = p_version_number AND
cv.course_type = pt.course_type AND
pt.research_type_ind = 'Y' AND
pt.closed_ind = 'N' ;
SELECT mode_of_study
FROM igs_he_poous_all
WHERE unit_set_cd = p_unit_set_cd AND
us_version_number = p_us_version_number AND
course_cd = l_course_cd AND
crv_version_number = l_version_number AND
cal_type = l_cal_type AND
location_cd = l_location_cd AND
attendance_type = l_attendance_type AND
attendance_mode = l_attendance_mode ;
SELECT study_mode
FROM igs_he_en_susa
WHERE person_id = p_person_id AND
course_cd = l_course_cd AND
unit_set_cd = p_unit_set_cd AND
sequence_number = p_sequence_number ;
SELECT map1
FROM IGS_HE_CODE_MAP_VAL
WHERE association_code = 'OSS_HESA_ATTEND_MODE_ASSOC' AND
map2 = (SELECT attendance_type
FROM igs_ps_ofr_opt_all
WHERE coo_id = p_coo_id
AND delete_flag = 'N');
SELECT map1
FROM IGS_HE_CODE_MAP_VAL
WHERE map2 = cp_oss_mode_of_study AND
association_code = 'OSS_HESA_MODE_ASSOC' ;
SELECT course_cd , version_number, cal_type, location_cd ,attendance_type ,attendance_mode
FROM igs_ps_ofr_opt_all
WHERE coo_id = p_coo_id
AND delete_flag = 'N';
p_selection_dt_from IN VARCHAR2,
p_selection_dt_to IN VARCHAR2,
p_message OUT NOCOPY VARCHAR2 ) AS
/*************************************************************
Created By : smaddali
Date Created By : 15-APR-2002
Purpose : To find the FTE calculation type . It can return 'U' /'I'/'B'
Or to find the FTE_intensity value . If the parameters p_unit_set_cd ,p_us_version_number,p_sequence_number
are NULL then FTE_calculation type is determined else if all are passed FTE_intensity is determined
Know limitations, enhancements or remarks
Change History
Who When What
jtmathew 05-Apr-2006 Changes for HE370 - Introduced 'Use Attendance Percentage for Research' functionality
jtmathew 25-Jan-2005 Changes for HE357 - modified c_year
smaddali 08-Oct-2003 Removed cursor c_prg_limit and its code for bug#3175107 since std_pt_completion_time and
std_ft_completion_time fields are obsolete
sarakshi 24-Feb-2003 Enh#2797116,modified cursor c_coo,c_crs_dets,c_crs_off.Added delete_flag check in the where clause
smaddali 05-Jul-2002 modified cursor c_year for bug 2448315
(reverse chronological order - newest change first)
***************************************************************/
l_hesa_att_type igs_he_code_map_val.map1%TYPE := NULL;
SELECT susa.unit_set_cd , susa.us_version_number , susa.sequence_number
FROM igs_as_su_setatmpt susa, igs_ps_us_prenr_cfg us
WHERE susa.unit_set_cd = us.unit_set_cd
AND susa.person_id = p_person_id
AND susa.course_cd = l_course_cd
AND susa.selection_dt IS NOT NULL
AND susa.selection_dt < p_fte_end_dt
AND ((susa.rqrmnts_complete_dt > p_fte_start_dt OR susa.end_dt > p_fte_start_dt)
OR (susa.end_dt IS NULL AND susa.rqrmnts_complete_dt IS NULL))
AND (p_selection_dt_from IS NULL
OR susa.selection_dt BETWEEN p_selection_dt_from AND p_selection_dt_to)
ORDER BY NVL(susa.rqrmnts_complete_dt, susa.end_dt) DESC;
SELECT fte_calc_type , fte_intensity
FROM igs_he_poous_all
WHERE unit_set_cd = cp_unit_set_cd AND
us_version_number = cp_us_version_number AND
course_cd = l_course_cd AND
crv_version_number = l_version_number AND
cal_type = l_cal_type AND
location_cd = l_location_cd AND
attendance_type = l_attendance_type AND
attendance_mode = l_attendance_mode ;
SELECT fte_calc_type , fte_intensity
FROM igs_he_en_susa
WHERE person_id = p_person_id AND
course_cd = l_course_cd AND
unit_set_cd = cp_unit_set_cd AND
sequence_number = cp_sequence_number ;
SELECT map1
FROM IGS_HE_CODE_MAP_VAL
WHERE association_code = 'OSS_HESA_ATTEND_MODE_ASSOC' AND
map2 = (SELECT attendance_type
FROM igs_ps_ofr_opt_all
WHERE coo_id = p_coo_id
AND delete_flag = 'N');
SELECT course_cd , version_number, cal_type, location_cd ,attendance_type ,attendance_mode
FROM igs_ps_ofr_opt_all
WHERE coo_id = p_coo_id
AND delete_flag = 'N';
SELECT attendance_percentage
FROM igs_re_candidature_all
WHERE person_id = p_person_id AND
sca_course_cd = l_course_cd ;
SELECT fte_intensity
FROM igs_he_st_prog_all
WHERE course_cd = l_course_cd AND
version_number = l_version_number ;
SELECT coo_id
FROM igs_ps_ofr_opt_all
WHERE course_cd = l_course_cd AND
version_number = l_version_number AND
delete_flag = 'N';
P_Selection_dt_from IN VARCHAR2,
P_Selection_dt_to IN VARCHAR2,
P_App_res_st_fte IN VARCHAR2,
P_Att_prc_st_fte IN VARCHAR2) IS
/*************************************************************
Created By : smaddali
Date Created By : 15-APR-2002
Purpose : To calculate the fte and save it in igs_he_en_susa
for each eligible student program attempt
Know limitations, enhancements or remarks
Change History
Who When What
sarakshi 26-jun-2003 Enh#2930935,modified cursors c_sua,c_trn_from_units to include uoo_id
and cursor c_unit_cp to pick enrolled credit point from unit section
level if exists else from unit level
smaddali modified cursors c_crs_year , c_year , c_sca for bug 2448315
smaddali modified cursors c_crs_year and c_year_cal for bug 2452785
smaddali 08-Oct-2003 Removed cursor c_prg_limit and its code for bug#3175107 since std_pt_completion_time and
std_ft_completion_time fields are obsolete
smaddali 10-Oct-2003 Modified code to apportion fte for research students ,
to check that commencement_dt and discontinued_dt lie in the FTE period ,
for bug#3177328
smaddali 13-Oct-2003 Modified cursor c_sca , removed cursors c_trn_from and c_sca_sin for bug#3171373
smaddali 02-Dec-2003 Modified code logic for coo_id and course_cat parameters for HECR214 build, Bug#3291656
ayedubat 29-Apr-2004 Changed the cursors, c_intermit and c_intm_part to add a new condition to check
for approved intermissions, if approval is required for Bug, 3494224
rnirwani 13-Sep-2004 changed cursor c_intermit to not consider logically deleted records and
also to avoid un-approved intermission records. Bug# 3885804
jbaber 30-Nov-2004 Removed c_intermit, using isDormant instead for bug# 4037237
jtmathew 25-Jan-2005 Changes for HE357 - modified c_sua, c_trn_from_units, c_year, c_crs_year, c_fte_prop
and rewrote c_year_cal. Created c_multi_yop and TYPE year_cal_type. Also modified
intensity based calculation algorithm.
jtmathew 24-Oct-2005 Created c_en_hist for bug 4221427
anwest 18-jan-2006 Bug# 4950285 R12 Disable OSS Mandate
jchakrab 20-Feb-2006 Modified for 4251041 - removed ORDER BY from cursor c_sua query
jtmathew 23-Feb-2006 Modified c_poous_app for bug 5051155
jtmathew 05-Apr-2006 Changes for HE370 - Additional parameters: P_Person_id_grp, P_Selection_dts, P_att_prc_st_fte
Modified cursors: c_sua, c_year, c_crs_year, c_year_cal, c_multi_yop
c_spa has been removed and is now implemented using dynamic sql.
***************************************************************/
BEGIN
DECLARE
cst_enrolled CONSTANT VARCHAR2(10) := 'ENROLLED';
l_selection_dt_to DATE := NULL;
l_selection_dt_from DATE := NULL;
SELECT ci.start_dt , ci.end_dt
FROM igs_ca_inst ci
WHERE ci.cal_type = p_fte_cal_type AND
ci.sequence_number = p_fte_sequence_number ;
SELECT 'X'
FROM igs_as_sc_attempt_h_all
WHERE person_id = cp_person_id
AND course_cd = cp_course_cd
AND hist_start_dt < p_fte_end_dt + 1
AND course_attempt_status = cst_enrolled;
SELECT sua.unit_cd,
sua.version_number,
sua.enrolled_dt ,
sua.override_enrolled_cp ,
sua.cal_type,
sua.ci_sequence_number ,
sua.unit_attempt_status ,
sua.discontinued_dt ,
sua.uoo_id
FROM IGS_EN_SU_ATTEMPT_ALL sua,
IGS_HE_ST_UNT_VS_ALL hsu,
IGS_PS_UNIT_OFR_OPT_ALL uoo
WHERE sua.person_id = cp_person_id
AND sua.course_cd = cp_course_cd
AND sua.unit_cd = hsu.unit_cd (+)
AND sua.version_number = hsu.version_number (+)
AND NVL(hsu.exclude_flag, 'N') = 'N'
AND sua.unit_attempt_status IN (cst_enrolled,cst_discontin,cst_completed)
AND sua.unit_cd = uoo.unit_cd (+)
AND sua.version_number = uoo.version_number (+)
AND sua.cal_type = uoo.cal_type (+)
AND sua.ci_sequence_number = uoo.ci_sequence_number (+)
AND sua.location_cd = uoo.location_cd (+)
AND sua.unit_class = uoo.unit_class (+)
AND ( NVL(uoo.unit_section_start_date, sua.ci_start_dt) BETWEEN p_fte_start_dt AND p_fte_end_dt);
SELECT NVL(cps.enrolled_credit_points,uv.enrolled_credit_points) enrolled_credit_points
FROM igs_ps_unit_ver_all uv,
igs_ps_unit_ofr_opt uoo,
igs_ps_usec_cps cps
WHERE uoo.uoo_id=cps.uoo_id(+) AND
uoo.unit_cd=uv.unit_cd AND
uoo.version_number=uv.version_number AND
uoo.uoo_id=cp_uoo_id;
SELECT transfer_course_cd
FROM igs_ps_stdnt_trn
WHERE person_id = cp_person_id AND
course_cd = cp_course_cd AND
( transfer_dt BETWEEN p_fte_start_dt AND p_fte_end_dt );
SELECT unit_cd,
version_number,
ci_start_dt,
override_enrolled_cp ,
uoo_id
FROM igs_en_su_attempt_all
WHERE person_id = cp_person_id AND
course_cd = cp_course_cd AND
unit_attempt_status = cst_completed AND
(ci_start_dt BETWEEN p_fte_start_dt AND p_fte_end_dt) ;
cp_selection_dt_from igs_as_su_setatmpt.selection_dt%TYPE,
cp_selection_dt_to igs_as_su_setatmpt.selection_dt%TYPE) IS
SELECT usv.unit_set_cd , usv.us_version_number , usv.sequence_number,
us.sequence_no acad_perd, usv.selection_dt, usv.rqrmnts_complete_dt completion_dt, usv.end_dt
FROM igs_as_su_setatmpt usv , igs_ps_us_prenr_cfg us
WHERE usv.unit_set_cd = us.unit_set_cd
AND usv.person_id = cp_person_id
AND usv.course_cd = cp_course_cd
AND usv.selection_dt IS NOT NULL
AND usv.selection_dt < p_fte_end_dt
AND ((usv.rqrmnts_complete_dt > p_fte_start_dt OR usv.end_dt > p_fte_start_dt)
OR (usv.end_dt IS NULL AND usv.rqrmnts_complete_dt IS NULL))
AND (cp_selection_dt_from IS NULL
OR usv.selection_dt BETWEEN cp_selection_dt_from AND cp_selection_dt_to)
ORDER BY NVL(usv.rqrmnts_complete_dt, usv.end_dt) DESC;
cp_selection_dt_from igs_as_su_setatmpt.selection_dt%TYPE,
cp_selection_dt_to igs_as_su_setatmpt.selection_dt%TYPE) IS
SELECT usv.person_id, usv.course_cd, count(*) multi_yop_count
FROM igs_as_su_setatmpt usv , igs_ps_us_prenr_cfg us
WHERE usv.unit_set_cd = us.unit_set_cd
AND usv.person_id = cp_person_id
AND usv.course_cd = cp_course_cd
AND usv.selection_dt IS NOT NULL
AND usv.selection_dt < p_fte_end_dt
AND ((usv.rqrmnts_complete_dt > p_fte_start_dt OR usv.end_dt > p_fte_start_dt)
OR (usv.end_dt IS NULL AND usv.rqrmnts_complete_dt IS NULL))
AND (cp_selection_dt_from IS NULL
OR usv.selection_dt BETWEEN cp_selection_dt_from AND cp_selection_dt_to)
GROUP BY usv.person_id, usv.course_cd
HAVING count(*) > 1;
cp_selection_dt_from igs_as_su_setatmpt.selection_dt%TYPE,
cp_selection_dt_to igs_as_su_setatmpt.selection_dt%TYPE) IS
SELECT ci.cal_type, ci.sequence_number, ci.start_dt, ci.end_dt
FROM igs_ca_inst ci,
igs_ca_type cat,
igs_ca_stat cs,
igs_en_stdnt_ps_att_all sca,
igs_as_su_setatmpt susa
WHERE sca.person_id = susa.person_id
AND sca.course_cd = susa.course_cd
AND sca.cal_type = ci.cal_type
AND ci.cal_type = cat.cal_type
AND ci.cal_status = cs.cal_status
AND cs.s_cal_status = 'ACTIVE'
AND cat.s_cal_cat = 'ACADEMIC'
AND sca.person_id = cp_person_id
AND sca.course_cd = cp_course_cd
AND susa.unit_set_cd = cp_unit_set_cd
AND ((susa.selection_dt < ci.end_dt ) OR
( susa.rqrmnts_complete_dt IS NOT NULL AND
(ci.end_dt BETWEEN susa.selection_dt AND susa.rqrmnts_complete_dt)) OR
( susa.end_dt IS NOT NULL AND
(ci.end_dt BETWEEN susa.selection_dt AND susa.end_dt)))
AND ci.start_dt < p_fte_end_dt
AND (cp_selection_dt_from IS NULL
OR susa.selection_dt BETWEEN cp_selection_dt_from AND cp_selection_dt_to)
ORDER BY ci.start_dt DESC;
SELECT std_annual_load
FROM igs_ps_ver_all
WHERE course_cd = cp_course_cd AND
version_number = cp_version_number ;
cp_selection_dt_from igs_as_su_setatmpt.selection_dt%TYPE,
cp_selection_dt_to igs_as_su_setatmpt.selection_dt%TYPE) IS
SELECT susa.unit_set_cd , susa.us_version_number , susa.sequence_number
FROM igs_as_su_setatmpt susa, igs_ps_us_prenr_cfg us
WHERE susa.unit_set_cd = us.unit_set_cd
AND susa.person_id = cp_person_id
AND susa.course_cd = cp_course_cd
AND susa.selection_dt IS NOT NULL
AND susa.selection_dt < p_fte_end_dt
AND ((susa.rqrmnts_complete_dt > p_fte_start_dt OR susa.end_dt > p_fte_start_dt)
OR (susa.end_dt IS NULL AND susa.rqrmnts_complete_dt IS NULL))
AND (cp_selection_dt_from IS NULL
OR susa.selection_dt BETWEEN cp_selection_dt_from AND cp_selection_dt_to)
ORDER BY NVL(susa.rqrmnts_complete_dt, susa.end_dt) DESC;
SELECT rowid , susa.*
FROM igs_he_en_susa susa
WHERE person_id = cp_person_id AND
course_cd = cp_course_cd AND
unit_set_cd = cp_unit_set_cd AND
sequence_number = cp_sequence_number ;
SELECT fte_perc
FROM igs_he_fte_proprt
WHERE cal_type = cp_cal_type AND
ci_sequence_number = cp_ci_sequence_number AND
fte_cal_type = p_fte_cal_type AND
fte_sequence_num = p_fte_sequence_number AND
year_of_program = cp_acad_perd AND
closed_ind = 'N';
SELECT start_dt , end_dt
FROM igs_en_stdnt_ps_intm spi
WHERE spi.person_id = cp_person_id AND
spi.course_cd = cp_course_cd AND
spi.start_dt < cp_end_dt AND
spi.end_dt > cp_start_dt AND
spi.logical_delete_date = TO_DATE('31-12-4712','DD-MM-YYYY') AND
(spi.approved = 'Y' OR
EXISTS( SELECT 1 FROM igs_en_intm_types
WHERE intermission_type = spi.intermission_type AND
appr_reqd_ind = 'N' ));
SELECT teach_period_start_dt , teach_period_end_dt
FROM igs_he_st_prog_all prog
WHERE prog.course_cd = cp_course_cd AND
prog.version_number = cp_version_number ;
SELECT teach_period_start_dt , teach_period_end_dt
FROM igs_he_poous_all poous, igs_ps_ofr_opt_all coo
WHERE poous.course_cd = coo.course_cd AND
poous.crv_version_number = coo.version_number AND
poous.cal_type = coo.cal_type AND
poous.location_cd = coo.location_cd AND
poous.attendance_type = coo.attendance_type AND
poous.attendance_mode = coo.attendance_mode AND
coo.coo_id = cp_coo_id AND
unit_set_cd = cp_unit_set_cd AND
us_version_number = cp_us_version_number ;
SELECT ci.start_dt , ci.end_dt
FROM igs_he_fte_cal_prd fp , igs_ca_inst ci
WHERE fp.teach_cal_type = ci.cal_type AND
fp.teach_sequence_num = ci.sequence_number AND
fp.fte_cal_type = p_fte_cal_type AND
fp.fte_sequence_num = p_fte_sequence_number ;
SELECT start_dt , end_dt
FROM igs_ca_inst
WHERE cal_type = cp_cal_type AND
sequence_number = cp_sequence_number ;
SELECT MIN(sca.commencement_dt) trn_commencement_dt
FROM igs_en_stdnt_ps_att sca,
igs_he_st_spa hspa
WHERE hspa.person_id = cp_person_id
AND hspa.student_inst_number = cp_stin
AND sca.person_id = hspa.person_id
AND sca.course_cd = hspa.course_cd;
SELECT tr.program_version , tr.coo_id
FROM igs_en_spa_terms tr , igs_ca_inst_all ca
WHERE tr.term_cal_type = ca.cal_type AND
tr.term_sequence_number = ca.sequence_number AND
tr.person_id = cp_person_id AND
tr.program_cd = cp_course_cd AND
cp_lev_dt BETWEEN ca.start_dt AND ca.end_dt
ORDER BY ca.start_dt DESC;
SELECT tr.program_version , tr.coo_id
FROM igs_en_spa_terms tr , igs_ca_inst_all ca
WHERE tr.term_cal_type = ca.cal_type AND
tr.term_sequence_number = ca.sequence_number AND
tr.person_id = cp_person_id AND
tr.program_cd = cp_course_cd AND
cp_lev_dt > ca.start_dt AND
ca.start_dt BETWEEN p_fte_start_dt AND p_fte_end_dt
ORDER BY ca.start_dt DESC;
SELECT tr.program_version , tr.coo_id
FROM igs_en_spa_terms tr , igs_ca_inst_all ca
WHERE tr.term_cal_type = ca.cal_type AND
tr.term_sequence_number = ca.sequence_number AND
tr.person_id = cp_person_id AND
tr.program_cd = cp_course_cd AND
ca.start_dt BETWEEN p_fte_start_dt AND p_fte_end_dt
ORDER BY ca.start_dt DESC;
SELECT course_cd,version_number
FROM igs_ps_categorise_all ct where
ct.course_cd = cp_course_cd AND
ct.version_number = cp_version_number AND
ct.course_cat = p_course_cat ;
SELECT group_type
FROM igs_pe_persid_group_v
WHERE group_id = p_person_id_grp;
l_selection_dt_from := TO_DATE(p_selection_dt_from, 'yyyy/mm/dd hh24:mi:ss');
l_selection_dt_to := TO_DATE(p_selection_dt_to, 'yyyy/mm/dd hh24:mi:ss');
IF (l_selection_dt_from IS NULL AND l_selection_dt_to IS NOT NULL) OR
(l_selection_dt_from IS NOT NULL AND l_selection_dt_to IS NULL) THEN
fnd_message.set_name('IGS','IGS_HE_FTE_US_SEL_DT_ERR');
log_messages('P_SELECTION_DT_FROM ',p_selection_dt_from);
log_messages('P_SELECTION_DT_TO ',p_selection_dt_to);
fnd_dsql.add_text('SELECT pe.person_number,spa.person_id, spa.course_cd ,spa.version_number,spa.coo_id,');
fnd_dsql.add_text(' (SELECT ''X'' ');
IF l_selection_dt_from IS NOT NULL THEN
fnd_dsql.add_text(' AND EXISTS (');
fnd_dsql.add_text(' SELECT b.person_id, b.course_cd');
fnd_dsql.add_text(' AND b.selection_dt between ');
fnd_dsql.add_bind(l_selection_dt_from);
fnd_dsql.add_bind(l_selection_dt_to);
p_selection_dt_from => l_selection_dt_from,
p_selection_dt_to => l_selection_dt_to,
p_message => l_message) ;
l_selection_dt_from, l_selection_dt_to);
l_selection_dt_from, l_selection_dt_to) LOOP
-- derive the fte_intensity set up '
l_fte_intensity := NULL ;
p_selection_dt_from => l_selection_dt_from,
p_selection_dt_to => l_selection_dt_to,
p_message => l_message) ;
l_selection_dt_from, l_selection_dt_to) ;
ELSIF NOT (c_crs_year_rec.selection_dt between p_fte_start_dt and p_fte_end_dt) THEN
-- Ignore all year of programs that do not have a selection date within
-- the FTE calculation period
l_calculated_intensity := 0;
l_selection_dt_from, l_selection_dt_to);
igs_he_en_susa_pkg.update_row(
X_ROWID => c_susa_upd_rec.rowid ,
X_HESA_EN_SUSA_ID => c_susa_upd_rec.hesa_en_susa_id ,
X_PERSON_ID => c_susa_upd_rec.person_id ,
X_COURSE_CD => c_susa_upd_rec.course_cd ,
X_UNIT_SET_CD => c_susa_upd_rec.unit_set_cd ,
X_US_VERSION_NUMBER => c_susa_upd_rec.us_version_number ,
X_SEQUENCE_NUMBER => c_susa_upd_rec.sequence_number ,
X_NEW_HE_ENTRANT_CD => c_susa_upd_rec.new_he_entrant_cd ,
X_TERM_TIME_ACCOM => c_susa_upd_rec.term_time_accom ,
X_DISABILITY_ALLOW => c_susa_upd_rec.disability_allow ,
X_ADDITIONAL_SUP_BAND => c_susa_upd_rec.additional_sup_band ,
X_SLDD_DISCRETE_PROV => c_susa_upd_rec.sldd_discrete_prov,
X_STUDY_MODE => c_susa_upd_rec.study_mode ,
X_STUDY_LOCATION => c_susa_upd_rec.study_location ,
X_FTE_PERC_OVERRIDE => c_susa_upd_rec.fte_perc_override ,
X_FRANCHISING_ACTIVITY => c_susa_upd_rec.franchising_activity ,
X_COMPLETION_STATUS => c_susa_upd_rec.completion_status,
X_GOOD_STAND_MARKER => c_susa_upd_rec.good_stand_marker ,
X_COMPLETE_PYR_STUDY_CD => c_susa_upd_rec.complete_pyr_study_cd ,
X_CREDIT_VALUE_YOP1 => c_susa_upd_rec.credit_value_yop1 ,
X_CREDIT_VALUE_YOP2 => c_susa_upd_rec.credit_value_yop2 ,
X_CREDIT_VALUE_YOP3 => c_susa_upd_rec.credit_value_yop3 ,
X_CREDIT_VALUE_YOP4 => c_susa_upd_rec.credit_value_yop4 ,
X_CREDIT_LEVEL_ACHIEVED1 => c_susa_upd_rec.credit_level_achieved1 ,
X_CREDIT_LEVEL_ACHIEVED2 => c_susa_upd_rec.credit_level_achieved2 ,
X_CREDIT_LEVEL_ACHIEVED3 => c_susa_upd_rec.credit_level_achieved3 ,
X_CREDIT_LEVEL_ACHIEVED4 => c_susa_upd_rec.credit_level_achieved4 ,
X_CREDIT_PT_ACHIEVED1 => c_susa_upd_rec.credit_pt_achieved1 ,
X_CREDIT_PT_ACHIEVED2 => c_susa_upd_rec.credit_pt_achieved2 ,
X_CREDIT_PT_ACHIEVED3 => c_susa_upd_rec.credit_pt_achieved3 ,
X_CREDIT_PT_ACHIEVED4 => c_susa_upd_rec.credit_pt_achieved4 ,
X_CREDIT_LEVEL1 => c_susa_upd_rec.credit_level1 ,
X_CREDIT_LEVEL2 => c_susa_upd_rec.credit_level2 ,
X_CREDIT_LEVEL3 => c_susa_upd_rec.credit_level3 ,
X_CREDIT_LEVEL4 => c_susa_upd_rec.credit_level4 ,
X_ADDITIONAL_SUP_COST => c_susa_upd_rec.additional_sup_cost ,
X_ENH_FUND_ELIG_CD => c_susa_upd_rec.enh_fund_elig_cd ,
X_DISADV_UPLIFT_FACTOR => c_susa_upd_rec.disadv_uplift_factor ,
X_YEAR_STU => c_susa_upd_rec.year_stu ,
X_GRAD_SCH_GRADE => c_susa_upd_rec.grad_sch_grade ,
X_MARK => c_susa_upd_rec.mark ,
X_TEACHING_INST1 => c_susa_upd_rec.teaching_inst1 ,
X_TEACHING_INST2 => c_susa_upd_rec.teaching_inst2 ,
X_PRO_NOT_TAUGHT => c_susa_upd_rec.pro_not_taught ,
X_FUNDABILITY_CODE => c_susa_upd_rec.fundability_code ,
X_FEE_ELIGIBILITY => c_susa_upd_rec.fee_eligibility ,
X_FEE_BAND => c_susa_upd_rec.fee_band ,
X_NON_PAYMENT_REASON => c_susa_upd_rec.non_payment_reason ,
X_STUDENT_FEE => c_susa_upd_rec.student_fee ,
X_FTE_INTENSITY => c_susa_upd_rec.fte_intensity ,
X_CALCULATED_FTE => l_calculated_fte ,
X_FTE_CALC_TYPE => c_susa_upd_rec.fte_calc_type ,
X_TYPE_OF_YEAR => c_susa_upd_rec.type_of_year ,
X_MODE => 'R'
) ;
igs_he_en_susa_pkg.insert_row(
X_ROWID => l_rowid ,
X_HESA_EN_SUSA_ID => l_hesa_en_susa_id ,
X_PERSON_ID => c_sca_rec.person_id ,
X_COURSE_CD => c_sca_rec.course_cd ,
X_UNIT_SET_CD => c_year_rec.unit_set_cd ,
X_US_VERSION_NUMBER => c_year_rec.us_version_number ,
X_SEQUENCE_NUMBER => c_year_rec.sequence_number ,
X_NEW_HE_ENTRANT_CD => NULL ,
X_TERM_TIME_ACCOM => NULL ,
X_DISABILITY_ALLOW => NULL ,
X_ADDITIONAL_SUP_BAND => NULL ,
X_SLDD_DISCRETE_PROV => NULL ,
X_STUDY_MODE => NULL ,
X_STUDY_LOCATION => NULL ,
X_FTE_PERC_OVERRIDE => NULL ,
X_FRANCHISING_ACTIVITY => NULL ,
X_COMPLETION_STATUS => NULL ,
X_GOOD_STAND_MARKER => NULL ,
X_COMPLETE_PYR_STUDY_CD => NULL ,
X_CREDIT_VALUE_YOP1 => NULL ,
X_CREDIT_VALUE_YOP2 => NULL ,
X_CREDIT_VALUE_YOP3 => NULL ,
X_CREDIT_VALUE_YOP4 => NULL ,
X_CREDIT_LEVEL_ACHIEVED1 => NULL ,
X_CREDIT_LEVEL_ACHIEVED2 => NULL ,
X_CREDIT_LEVEL_ACHIEVED3 => NULL ,
X_CREDIT_LEVEL_ACHIEVED4 => NULL ,
X_CREDIT_PT_ACHIEVED1 => NULL ,
X_CREDIT_PT_ACHIEVED2 => NULL ,
X_CREDIT_PT_ACHIEVED3 => NULL ,
X_CREDIT_PT_ACHIEVED4 => NULL ,
X_CREDIT_LEVEL1 => NULL ,
X_CREDIT_LEVEL2 => NULL ,
X_CREDIT_LEVEL3 => NULL ,
X_CREDIT_LEVEL4 => NULL ,
X_ADDITIONAL_SUP_COST => NULL ,
X_ENH_FUND_ELIG_CD => NULL ,
X_DISADV_UPLIFT_FACTOR => NULL ,
X_YEAR_STU => NULL ,
X_GRAD_SCH_GRADE => NULL ,
X_MARK => NULL ,
X_TEACHING_INST1 => NULL ,
X_TEACHING_INST2 => NULL ,
X_PRO_NOT_TAUGHT => NULL ,
X_FUNDABILITY_CODE => NULL ,
X_FEE_ELIGIBILITY => NULL ,
X_FEE_BAND => NULL ,
X_NON_PAYMENT_REASON => NULL ,
X_STUDENT_FEE => NULL ,
X_FTE_INTENSITY => NULL ,
X_CALCULATED_FTE => l_calculated_fte ,
X_FTE_CALC_TYPE => l_fte_calc_type ,
X_TYPE_OF_YEAR => NULL ,
X_MODE => 'R'
) ;