[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT rowid,
code_type,
code,
code_text
FROM igs_uc_crfcode_ints
WHERE record_status = 'N';
SELECT 'X'
FROM igs_lookup_values
WHERE lookup_type = 'IGS_UC_CODE_TYPES'
AND lookup_code = p_code
AND enabled_flag = 'Y'
AND NVL(closed_ind, 'N') = 'N';
SELECT rfc.rowid
FROM igs_uc_ref_codes rfc
WHERE code_type = p_type
AND code = p_code ;
igs_uc_ref_codes_pkg.insert_row --IGSXI26B.pls
(
x_rowid => l_rowid
,x_code_type => new_crfcode_rec.code_type
,x_code => new_crfcode_rec.code
,x_code_text => new_crfcode_rec.code_text
,x_imported => 'Y'
,x_mode => 'R'
);
ELSE /* Update the record */
BEGIN
igs_uc_ref_codes_pkg.update_row --IGSXI26B.pls
(
x_rowid => l_rowid
,x_code_type => new_crfcode_rec.code_type
,x_code => new_crfcode_rec.code
,x_code_text => new_crfcode_rec.code_text
,x_imported => 'Y'
,x_mode => 'R'
);
END IF; -- insert / update
UPDATE igs_uc_crfcode_ints
SET error_code = g_error_code
WHERE rowid = new_crfcode_rec.rowid;
UPDATE igs_uc_crfcode_ints
SET record_status = 'D',
error_code = NULL
WHERE rowid = new_crfcode_rec.rowid;
SELECT rowid
,year
,sitting
,awardingbody
,bodyname
,bodyabbrev
FROM igs_uc_crawdbd_ints
WHERE record_status = 'N';
SELECT awd.rowid
FROM igs_uc_ref_awrdbdy awd
WHERE awd.year = p_year
AND awd.sitting = p_sitting
AND awd.awarding_body = p_awd_body;
igs_uc_ref_awrdbdy_pkg.insert_row --IGSXI25B.pls
(
x_rowid => l_rowid
,x_year => new_awdbdy_rec.year
,x_sitting => new_awdbdy_rec.sitting
,x_awarding_body => new_awdbdy_rec.awardingbody
,x_body_name => new_awdbdy_rec.bodyname
,x_body_abbrev => new_awdbdy_rec.bodyabbrev
,x_imported => 'Y'
,x_mode => 'R'
);
ELSE -- update
BEGIN
igs_uc_ref_awrdbdy_pkg.update_row --IGSXI25B.pls
(
x_rowid => l_rowid
,x_year => new_awdbdy_rec.year
,x_sitting => new_awdbdy_rec.sitting
,x_awarding_body => new_awdbdy_rec.awardingbody
,x_body_name => new_awdbdy_rec.bodyname
,x_body_abbrev => new_awdbdy_rec.bodyabbrev
,x_imported => 'Y'
,x_mode => 'R'
);
END IF; -- insert/update
UPDATE igs_uc_crawdbd_ints
SET error_code = g_error_code
WHERE rowid = new_awdbdy_rec.rowid;
UPDATE igs_uc_crawdbd_ints
SET record_status = 'D',
error_code = NULL
WHERE rowid = new_awdbdy_rec.rowid;
SELECT rowid
,dom
,domtext
,leaflag
FROM igs_uc_crapr_ints
WHERE record_status = 'N';
SELECT rapr.rowid
FROM igs_uc_ref_apr rapr
WHERE rapr.dom = p_dom ;
igs_uc_ref_apr_pkg.insert_row --IGSXI24B.pls
(
x_rowid => l_rowid
,x_dom => new_refapr_rec.dom
,x_dom_text => new_refapr_rec.domtext
,x_lea_flag => NVL(new_refapr_rec.leaflag,'Y')
,x_imported => 'Y'
,x_mode => 'R'
);
ELSE -- update
BEGIN
igs_uc_ref_apr_pkg.update_row --IGSXI24B.pls
(
x_rowid => l_rowid
,x_dom => new_refapr_rec.dom
,x_dom_text => new_refapr_rec.domtext
,x_lea_flag => NVL(new_refapr_rec.leaflag,'Y')
,x_imported => 'Y'
,x_mode => 'R'
);
UPDATE igs_uc_crapr_ints
SET error_code = g_error_code
WHERE rowid = new_refapr_rec.rowid;
UPDATE igs_uc_crapr_ints
SET record_status = 'D',
error_code = NULL
WHERE rowid = new_refapr_rec.rowid;
SELECT rowid,
keyword
FROM igs_uc_crkywd_ints
WHERE record_status = 'N';
SELECT rowid
FROM igs_uc_ref_keywords
WHERE keyword = p_keyword ;
igs_uc_ref_keywords_pkg.insert_row --IGSXI29B.pls
(
x_rowid => l_rowid
,x_keyword => new_refkwd_rec.keyword
,x_imported => 'Y'
,x_mode => 'R'
);
ELSE -- update
BEGIN
igs_uc_ref_keywords_pkg.update_row --IGSXI29B.pls
(
x_rowid => l_rowid
,x_keyword => new_refkwd_rec.keyword
,x_imported => 'Y'
,x_mode => 'R'
);
UPDATE igs_uc_crkywd_ints
SET error_code = g_error_code
WHERE rowid = new_refkwd_rec.rowid;
UPDATE igs_uc_crkywd_ints
SET record_status = 'D',
error_code = NULL
WHERE rowid = new_refkwd_rec.rowid;
SELECT rowid
,pocc
,socialclass
,occupationtext
,alternativetext
,alternateclass1
,alternateclass2
,socioeconomic
FROM igs_uc_crefpoc_ints
WHERE record_status = 'N';
SELECT rowid
FROM igs_uc_ref_pocc
WHERE pocc = p_pocc ;
igs_uc_ref_pocc_pkg.insert_row --IGSXI31B.pls
(
x_rowid => l_rowid
,x_pocc => new_refpocc_rec.pocc
,x_social_class => new_refpocc_rec.socialclass
,x_occupation_text => new_refpocc_rec.occupationtext
,x_alternative_text => new_refpocc_rec.alternativetext
,x_alternative_class1 => new_refpocc_rec.alternateclass1
,x_alternative_class2 => new_refpocc_rec.alternateclass2
,x_imported => 'Y'
,x_socio_economic => new_refpocc_rec.socioeconomic
,x_mode => 'R'
);
ELSE -- update
BEGIN
igs_uc_ref_pocc_pkg.update_row --IGSXI31B.pls
(
x_rowid => l_rowid
,x_pocc => new_refpocc_rec.pocc
,x_social_class => new_refpocc_rec.socialclass
,x_occupation_text => new_refpocc_rec.occupationtext
,x_alternative_text => new_refpocc_rec.alternativetext
,x_alternative_class1 => new_refpocc_rec.alternateclass1
,x_alternative_class2 => new_refpocc_rec.alternateclass2
,x_imported => 'Y'
,x_socio_economic => new_refpocc_rec.socioeconomic
,x_mode => 'R'
);
UPDATE igs_uc_crefpoc_ints
SET error_code = g_error_code
WHERE rowid = new_refpocc_rec.rowid;
UPDATE igs_uc_crefpoc_ints
SET record_status = 'D',
error_code = NULL
WHERE rowid = new_refpocc_rec.rowid;
SELECT offab.rowid,
offab.*
FROM igs_uc_croffab_ints offab
WHERE record_status = 'N';
SELECT roab.rowid,
roab.*
FROM igs_uc_ref_off_abrv roab
WHERE abbrev_code = p_abbrev ;
igs_uc_ref_off_abrv_pkg.insert_row --IGSXI30B.pls
(
x_rowid => l_rowid
,x_abbrev_code => 'TO'
,x_uv_updater => NULL
,x_abbrev_text => 'Tariff Offer'
,x_letter_format => 'B'
,x_summary_char => NULL
,x_uncond => 'N'
,x_withdrawal => 'N'
,x_release => 'N'
,x_imported => 'N'
,x_sent_to_ucas => 'Y'
,x_deleted => 'N'
,x_tariff => 'Y'
,x_mode => 'R'
);
igs_uc_ref_off_abrv_pkg.insert_row --IGSXI30B.pls
(
x_rowid => l_rowid
,x_abbrev_code => 'TE'
,x_uv_updater => NULL
,x_abbrev_text => 'End Tariff Offer'
,x_letter_format => 'B'
,x_summary_char => NULL
,x_uncond => 'N'
,x_withdrawal => 'N'
,x_release => 'N'
,x_imported => 'N'
,x_sent_to_ucas => 'Y'
,x_deleted => 'N'
,x_tariff => 'Y'
,x_mode => 'R'
);
igs_uc_ref_off_abrv_pkg.insert_row --IGSXI30B.pls
(
x_rowid => l_rowid
,x_abbrev_code => new_refoffab_rec.abbrevcode
,x_uv_updater => ''
,x_abbrev_text => new_refoffab_rec.abbrevtext
,x_letter_format => new_refoffab_rec.letterformat
,x_summary_char => NVL(new_refoffab_rec.summarychar, 'N')
,x_uncond => NVL(new_refoffab_rec.uncond, 'N')
,x_withdrawal => NVL(new_refoffab_rec.withdrawal, 'N')
,x_release => NVL(new_refoffab_rec.release, 'N')
,x_imported => 'Y'
,x_sent_to_ucas => 'Y'
,x_deleted => 'N'
,x_tariff => new_refoffab_rec.tariff
,x_mode => 'R'
);
ELSE -- update
BEGIN
igs_uc_ref_off_abrv_pkg.update_row --IGSXI30B.pls
(
x_rowid => old_refoffab_rec.rowid
,x_abbrev_code => old_refoffab_rec.abbrev_code
,x_uv_updater => old_refoffab_rec.uv_updater
,x_abbrev_text => new_refoffab_rec.abbrevtext
,x_letter_format => new_refoffab_rec.letterformat
,x_summary_char => NVL(new_refoffab_rec.summarychar, 'N')
,x_uncond => NVL(new_refoffab_rec.uncond, 'N')
,x_withdrawal => NVL(new_refoffab_rec.withdrawal, 'N')
,x_release => NVL(new_refoffab_rec.release, 'N')
,x_imported => 'Y'
,x_sent_to_ucas => 'Y'
,x_deleted => 'N'
,x_tariff => new_refoffab_rec.tariff
,x_mode => 'R'
);
UPDATE igs_uc_croffab_ints
SET error_code = g_error_code
WHERE rowid = new_refoffab_rec.rowid;
UPDATE igs_uc_croffab_ints
SET record_status = 'D',
error_code = NULL
WHERE rowid = new_refoffab_rec.rowid;
SELECT rowid,
subjcode,
subjtext,
subjabbrev,
ebl_subj
FROM igs_uc_crsubj_ints
WHERE record_status = 'N';
SELECT rowid
FROM igs_uc_ref_subj
WHERE SUBJ_CODE = p_subject ;
igs_uc_ref_subj_pkg.Insert_row
(
x_rowid => l_rowid,
x_subj_code => new_refsubj_rec.subjcode,
x_subj_text => new_refsubj_rec.subjtext ,
x_subj_abbrev => new_refsubj_rec.subjabbrev,
x_ebl_subj => new_refsubj_rec.ebl_subj,
x_imported => 'Y',
x_mode => 'R'
);
ELSE -- update
BEGIN
igs_uc_ref_subj_pkg.update_row
(
x_rowid => l_rowid,
x_subj_code => new_refsubj_rec.subjcode,
x_subj_text => new_refsubj_rec.subjtext ,
x_subj_abbrev => new_refsubj_rec.subjabbrev,
x_ebl_subj => new_refsubj_rec.ebl_subj,
x_imported => 'Y',
x_mode => 'R'
);
UPDATE igs_uc_crsubj_ints
SET error_code = g_error_code
WHERE rowid = new_refsubj_rec.rowid;
UPDATE igs_uc_crsubj_ints
SET record_status = 'D',
error_code = NULL
WHERE rowid = new_refsubj_rec.rowid;
SELECT rowid,
examlevel,
examgrade,
tariffscore
FROM igs_uc_ctariff_ints
WHERE record_status = 'N';
SELECT rtrf.rowid,
rtrf.*
FROM igs_uc_ref_tariff rtrf
WHERE rtrf.exam_level = p_examlevel
AND rtrf.exam_grade = p_examgrade;
igs_uc_ref_tariff_pkg.insert_row --
(
x_rowid => old_tariff_rec.rowid
,x_exam_level => new_reftariff_rec.examlevel
,x_exam_grade => new_reftariff_rec.examgrade
,x_tariff_score => new_reftariff_rec.tariffscore
,x_imported =>'Y'
,x_mode =>'R'
);
ELSE -- update
BEGIN
igs_uc_ref_tariff_pkg.update_row --
(
x_rowid => old_tariff_rec.rowid
,x_exam_level => old_tariff_rec.exam_level
,x_exam_grade => old_tariff_rec.exam_grade
,x_tariff_score => new_reftariff_rec.tariffscore
,x_imported =>'Y'
,x_mode =>'R'
);
UPDATE igs_uc_ctariff_ints
SET error_code = g_error_code
WHERE rowid = new_reftariff_rec.rowid;
UPDATE igs_uc_ctariff_ints
SET record_status = 'D',
error_code = NULL
WHERE rowid = new_reftariff_rec.rowid;
SELECT rowid
,childinst
,parentinst1
,parentinst2
,parentinst3
,parentinst4
,parentinst5
FROM igs_uc_cjntadm_ints
WHERE record_status = 'N';
SELECT rowid
FROM igs_uc_jnt_adm_inst
WHERE child_inst = p_childinst ;
SELECT 'X'
FROM igs_uc_com_inst
WHERE inst = p_inst;
igs_uc_jnt_adm_inst_pkg.insert_row --
(
x_rowid => l_rowid
,x_child_inst => new_cjntadm_rec.childinst
,x_parent_inst1 => new_cjntadm_rec.parentinst1
,x_parent_inst2 => new_cjntadm_rec.parentinst2
,x_parent_inst3 => new_cjntadm_rec.parentinst3
,x_parent_inst4 => new_cjntadm_rec.parentinst4
,x_parent_inst5 => new_cjntadm_rec.parentinst5
,x_mode =>'R'
);
ELSE -- update
BEGIN
igs_uc_jnt_adm_inst_pkg.update_row
(
x_rowid => l_rowid
,x_child_inst => new_cjntadm_rec.childinst
,x_parent_inst1 => new_cjntadm_rec.parentinst1
,x_parent_inst2 => new_cjntadm_rec.parentinst2
,x_parent_inst3 => new_cjntadm_rec.parentinst3
,x_parent_inst4 => new_cjntadm_rec.parentinst4
,x_parent_inst5 => new_cjntadm_rec.parentinst5
,x_mode =>'R'
);
UPDATE igs_uc_cjntadm_ints
SET error_code = g_error_code
WHERE rowid = new_cjntadm_rec.rowid;
UPDATE igs_uc_cjntadm_ints
SET record_status = 'D',
error_code = NULL
WHERE rowid = new_cjntadm_rec.rowid;
SELECT rowid
,countrycode
,description
,type
FROM igs_uc_country_ints
WHERE record_status = 'N';
SELECT rowid
FROM igs_uc_ref_country
WHERE country_code = p_country_code;
igs_uc_ref_country_pkg.insert_row --
(
x_rowid => l_rowid
,x_country_code => new_country_rec.countrycode
,x_description => new_country_rec.description
,x_type => new_country_rec.type
,x_imported => 'Y'
,x_mode => 'R'
);
ELSE -- update
BEGIN
igs_uc_ref_country_pkg.update_row
(
x_rowid => l_rowid
,x_country_code => new_country_rec.countrycode
,x_description => new_country_rec.description
,x_type => new_country_rec.type
,x_imported => 'Y'
,x_mode => 'R'
);
UPDATE igs_uc_country_ints
SET error_code = g_error_code
WHERE rowid = new_country_rec.rowid;
UPDATE igs_uc_country_ints
SET record_status = 'D',
error_code = NULL
WHERE rowid = new_country_rec.rowid;