[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
sql_stmt := 'SELECT ''x'' FROM ' || p_synonym || ' WHERE 1 = 2 ';
SELECT MAX(current_cycle) current_cycle , MAX(configured_cycle) configured_cycle
FROM igs_uc_defaults ;
SELECT iuc.rowid, iuc.*
FROM igs_uc_defaults iuc
WHERE system_code <> 'S';
SELECT ucas_interface
FROM IGS_UC_CYC_DEFAULTS
WHERE system_code = cp_system_code
AND ucas_cycle = cp_ucas_cycle;
SELECT synonym_name object_name
FROM user_synonyms
WHERE synonym_name IN (
'IGS_UC_U_CVCONTROL_2003',
'IGS_UC_U_CVCOURSE_2003',
'IGS_UC_U_CVEBLSUBJECT_2003',
'IGS_UC_U_CVINSTITUTION_2003',
'IGS_UC_U_CVJNTADMISSIONS_2003',
'IGS_UC_U_CVNAME_2003',
'IGS_UC_U_CVREFAMENDMENTS_2003',
'IGS_UC_U_CVREFAPR_2003',
'IGS_UC_U_CVREFAWARDBODY_2003',
'IGS_UC_U_CVREFDIS_2003',
'IGS_UC_U_CVREFERROR_2003',
'IGS_UC_U_CVREFESTGROUP_2003',
'IGS_UC_U_CVREFETHNIC_2003',
'IGS_UC_U_CVREFEXAM_2003',
'IGS_UC_U_CVREFFEE_2003',
'IGS_UC_U_CVREFKEYWORD_2003',
'IGS_UC_U_CVREFOEQ_2003',
'IGS_UC_U_CVREFOFFERABBREV_2003',
'IGS_UC_U_CVREFOFFERSUBJ_2003',
'IGS_UC_U_CVREFPOCC_2003',
'IGS_UC_U_CVREFPRE2000POCC_2003',
'IGS_UC_U_CVREFRESCAT_2003',
'IGS_UC_U_CVREFSCHOOLTYPE_2003',
'IGS_UC_U_CVREFSOCIALCLASS_2003',
'IGS_UC_U_CVREFSOCIOECON_2003',
'IGS_UC_U_CVREFSTATUS_2003',
'IGS_UC_U_CVREFSUBJ_2003',
'IGS_UC_U_CVREFTARIFF_2003',
'IGS_UC_U_CVREFUCASGROUP_2003',
'IGS_UC_U_CVSCHOOLCONTACT_2003',
'IGS_UC_U_CVSCHOOL_2003',
'IGS_UC_U_UVCONTACT_2003',
'IGS_UC_U_UVCONTGRP_2003',
'IGS_UC_U_UVCOURSEKEYWORD_2003',
'IGS_UC_U_UVCOURSEVACS_2003',
'IGS_UC_U_UVCOURSEVACOPS_2003',
'IGS_UC_U_UVCOURSE_2003',
'IGS_UC_U_UVINSTITUTION_2003',
'IGS_UC_U_UVINSTITUTION_2004',
'IGS_UC_U_UVOFFERABBREV_2003',
'IGS_UC_U_IVOFFER_2003',
'IGS_UC_U_IVQUALIFICATION_2003',
'IGS_UC_U_IVSTARA_2003',
'IGS_UC_U_IVSTARC_2003',
'IGS_UC_U_IVSTARH_2003',
'IGS_UC_U_IVSTARK_2003',
'IGS_UC_U_IVSTARN_2003',
'IGS_UC_U_IVSTARPQR_2003',
'IGS_UC_U_IVSTARW_2003',
'IGS_UC_U_IVSTARX_2003',
'IGS_UC_U_IVSTARZ1_2003',
'IGS_UC_U_IVSTARZ2_2003',
'IGS_UC_U_IVSTATEMENT_2003',
'IGS_UC_U_TRANIN_2003',
'IGS_UC_U_IVFORMQUALS_2004',
'IGS_UC_U_IVREFERENCE_2004',
'IGS_UC_U_IVSTARJ_2004',
'IGS_UC_U_IVSTARW_2004',
'IGS_UC_U_TRANIN_2004',
'IGS_UC_U_IVSTATEMENT_2004',
'IGS_UC_U_IVREFERENCE_2006',
'IGS_UC_U_IVSTARA_2006',
'IGS_UC_U_IVFORMQUALS_2006',
'IGS_UC_U_IVSTARA_2007',
'IGS_UC_U_IVSTARN_2007',
'IGS_UC_U_IVSTARK_2007',
'IGS_UC_U_CVREFCOUNTRY_2007',
'IGS_UC_U_CVREFNATIONALITY_2007',
'IGS_UC_U_CVREFAMENDMENTS_2007',
-- Small Systems Synonyms
'IGS_UC_G_CVGNAME_2006',
'IGS_UC_N_CVNNAME_2006',
'IGS_UC_G_IVGOFFER_2006',
'IGS_UC_N_IVNOFFER_2006',
'IGS_UC_G_IVGSTARA_2006',
'IGS_UC_N_IVNSTARA_2006',
'IGS_UC_N_IVNSTARC_2006',
'IGS_UC_G_IVGSTARG_2006',
'IGS_UC_G_IVGSTARH_2006',
'IGS_UC_N_IVNSTARH_2006',
'IGS_UC_G_IVGSTARK_2006',
'IGS_UC_N_IVNSTARK_2006',
'IGS_UC_G_IVGSTARN_2006',
'IGS_UC_N_IVNSTARN_2006',
'IGS_UC_G_IVGSTARW_2006',
'IGS_UC_N_IVNSTARW_2006',
'IGS_UC_G_IVGSTARX_2006',
'IGS_UC_N_IVNSTARX_2006',
'IGS_UC_N_IVNSTARZ1_2006',
'IGS_UC_G_IVGSTATEMENT_2006',
'IGS_UC_N_IVNSTATEMENT_2006',
'IGS_UC_G_IVGREFERENCE_2006',
'IGS_UC_N_IVNREFERENCE_2006',
'IGS_UC_G_CVGREFAMENDMENTS_2006',
'IGS_UC_G_CVGREFDEGREESUBJ_2006',
'IGS_UC_G_IVGSTARA_2007',
'IGS_UC_N_IVNSTARA_2007',
'IGS_UC_G_IVGSTARN_2007',
'IGS_UC_N_IVNSTARN_2007',
'IGS_UC_G_IVGSTARK_2007',
'IGS_UC_N_IVNSTARK_2007',
'IGS_UC_G_IVGSTARW_2007',
'IGS_UC_N_IVNSTARW_2007',
'IGS_UC_G_CVGCOURSE_2007',
'IGS_UC_N_CVNCOURSE_2007'
);
igs_uc_defaults_pkg.update_row( x_rowid => rec_cur_defaults.rowid,
x_current_inst_code => rec_cur_defaults.current_inst_code,
x_ucas_id_format => rec_cur_defaults.ucas_id_format,
x_test_app_no => rec_cur_defaults.test_app_no,
x_test_choice_no => rec_cur_defaults.test_choice_no,
x_test_transaction_type => rec_cur_defaults.test_transaction_type,
x_copy_ucas_id => rec_cur_defaults.copy_ucas_id,
x_mode => 'R',
x_decision_make_id => rec_cur_defaults.decision_make_id,
x_decision_reason_id => rec_cur_defaults.decision_reason_id,
x_obsolete_outcome_status => rec_cur_defaults.obsolete_outcome_status,
x_pending_outcome_status => rec_cur_defaults.pending_outcome_status,
x_rejected_outcome_status => rec_cur_defaults.rejected_outcome_status,
x_system_code => rec_cur_defaults.system_code,
x_ni_number_alt_pers_type => rec_cur_defaults.ni_number_alt_pers_type,
x_application_type => rec_cur_defaults.application_type,
x_name => rec_cur_defaults.name,
x_description => rec_cur_defaults.description,
x_ucas_security_key => rec_cur_defaults.ucas_security_key,
x_current_cycle => rec_cur_defaults.current_cycle,
x_configured_cycle => p_target_cycle,
x_prev_inst_left_date => rec_cur_defaults.prev_inst_left_date
);