The following lines contain the word 'select', 'insert', 'update' or 'delete':
FND_MSG_PUB.DELETE_MSG(l_msg_count);
FND_MSG_PUB.DELETE_MSG(l_msg_count);
FND_MSG_PUB.DELETE_MSG(l_msg_count);
FND_MSG_PUB.DELETE_MSG(l_msg_count);
SELECT igs_he_st_spa_all_s.NEXTVAL
FROM dual;
INSERT INTO igs_he_st_spa_all (
hesa_st_spa_id,
org_id,
person_id,
course_cd,
version_number,
fe_student_marker,
domicile_cd,
inst_last_attended,
year_left_last_inst,
highest_qual_on_entry,
date_qual_on_entry_calc,
a_level_point_score,
highers_points_scores,
occupation_code,
commencement_dt,
special_student,
student_qual_aim,
student_fe_qual_aim,
teacher_train_prog_id,
itt_phase,
bilingual_itt_marker,
teaching_qual_gain_sector,
teaching_qual_gain_subj1,
teaching_qual_gain_subj2,
teaching_qual_gain_subj3,
student_inst_number,
destination,
itt_prog_outcome,
hesa_return_name,
hesa_return_id,
hesa_submission_name,
associate_ucas_number,
associate_scott_cand,
associate_teach_ref_num,
associate_nhs_reg_num,
nhs_funding_source,
ufi_place,
postcode,
social_class_ind,
occcode,
total_ucas_tariff,
nhs_employer,
creation_date,
created_by,
last_update_date,
last_updated_by,
last_update_login,
return_type,
calculated_fte,
qual_aim_subj1,
qual_aim_subj2,
qual_aim_subj3,
qual_aim_proportion,
dependants_cd,
implied_fund_rate,
gov_initiatives_cd,
units_for_qual,
disadv_uplift_elig_cd,
franch_partner_cd,
units_completed,
franch_out_arr_cd,
employer_role_cd,
disadv_uplift_factor,
enh_fund_elig_cd,
exclude_flag)
VALUES (
l_hesa_st_spa_id,
igs_ge_gen_003.get_org_id(),
l_person_id,
p_hesa_spa_stats_rec.program_cd,
l_version_number,
p_hesa_spa_stats_rec.fe_student_marker,
p_hesa_spa_stats_rec.domicile_cd,
NULL, --inst_last_attended,
NULL, --year_left_last_inst,
p_hesa_spa_stats_rec.highest_qual_on_entry,
NULL, --date_qual_on_entry_calc,
NULL, --a_level_point_score,
NULL, --highers_points_scores,
p_hesa_spa_stats_rec.occupation_code,
p_hesa_spa_stats_rec.commencement_dt,
p_hesa_spa_stats_rec.special_student,
p_hesa_spa_stats_rec.student_qual_aim,
p_hesa_spa_stats_rec.student_fe_qual_aim,
p_hesa_spa_stats_rec.teacher_train_prog_id,
p_hesa_spa_stats_rec.itt_phase,
p_hesa_spa_stats_rec.bilingual_itt_marker,
p_hesa_spa_stats_rec.teaching_qual_gain_sector,
p_hesa_spa_stats_rec.teaching_qual_gain_subj1,
p_hesa_spa_stats_rec.teaching_qual_gain_subj2,
p_hesa_spa_stats_rec.teaching_qual_gain_subj3,
p_hesa_spa_stats_rec.student_inst_number,
p_hesa_spa_stats_rec.destination,
p_hesa_spa_stats_rec.itt_prog_outcome,
NULL, --hesa_return_name,
NULL, --hesa_return_id,
NULL, --hesa_submission_name,
NVL(p_hesa_spa_stats_rec.associate_ucas_number,'Y'),
NVL(p_hesa_spa_stats_rec.associate_scott_cand,'Y'),
NVL(p_hesa_spa_stats_rec.associate_teach_ref_num,'Y'),
NVL(p_hesa_spa_stats_rec.associate_nhs_reg_num,'Y'),
p_hesa_spa_stats_rec.nhs_funding_source,
p_hesa_spa_stats_rec.ufi_place,
p_hesa_spa_stats_rec.postcode,
p_hesa_spa_stats_rec.social_class_ind,
p_hesa_spa_stats_rec.occcode,
NULL, --total_ucas_tariff,
p_hesa_spa_stats_rec.nhs_employer,
SYSDATE, --creation_date,
NVL(FND_GLOBAL.USER_ID,-1), --created_by,
SYSDATE, --last_update_date,
NVL(FND_GLOBAL.USER_ID,-1), --last_updated_by,
NVL(FND_GLOBAL.LOGIN_ID,-1), --last_update_login,
p_hesa_spa_stats_rec.return_type,
NULL, --calculated_fte,
p_hesa_spa_stats_rec.subj_qualaim1,
p_hesa_spa_stats_rec.subj_qualaim2,
p_hesa_spa_stats_rec.subj_qualaim3,
p_hesa_spa_stats_rec.qualaim_proportion,
p_hesa_spa_stats_rec.dependants_cd,
p_hesa_spa_stats_rec.implied_fund_rate,
p_hesa_spa_stats_rec.gov_initiatives_cd,
p_hesa_spa_stats_rec.units_for_qual,
p_hesa_spa_stats_rec.disadv_uplift_elig_cd,
p_hesa_spa_stats_rec.franch_partner_cd,
p_hesa_spa_stats_rec.units_completed,
p_hesa_spa_stats_rec.franch_out_arr_cd,
p_hesa_spa_stats_rec.employer_role_cd,
p_hesa_spa_stats_rec.disadv_uplift_factor,
p_hesa_spa_stats_rec.enh_fund_elig_cd,
'N');