[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT catalog_version_id,
catalog_version,
description,
closed_ind,
catalog_schedule,
created_by,
creation_date,
last_update_date,
last_update_login,
last_updated_by
FROM IGS_PS_CATLG_VERS
WHERE catalog_version = p_catalog_version
AND catalog_schedule = 'CATALOG';
SELECT catalog_note_id,
catalog_version_id,
note_type_id,
create_date,
end_date,
SEQUENCE,
note_text,
created_by,
creation_date,
last_update_date,
last_update_login,
last_updated_by
FROM IGS_PS_CATLG_NOTES
WHERE catalog_version_id = p_catalog_version_id;
SELECT ROWID, -- included
catalog_note_id,
catalog_version_id,
note_type_id,
create_date,
end_date,
SEQUENCE,
note_text,
created_by,
creation_date,
last_update_date,
last_update_login,
last_updated_by
FROM IGS_PS_CATLG_NOTES
WHERE catalog_version_id = p_catalog_version_id
AND note_type_id = p_note_type_id
AND SEQUENCE = p_sequence
FOR UPDATE NOWAIT;
igs_ps_catlg_vers_pkg.insert_row(
x_rowid => lv_rowid,
x_catalog_version_id => lv_new_catalog_version_id,
x_catalog_version => p_new_catalog_version,
x_description => cur_sel_ctlg_vers.description,
x_closed_ind => cur_sel_ctlg_vers.closed_ind,
x_catalog_schedule => cur_sel_ctlg_vers.catalog_schedule,
x_mode => 'R',
x_org_id => p_org_id );
igs_ps_catlg_notes_pkg.insert_row(
x_rowid => lv_rowid,
x_catalog_note_id => lv_catalog_note_id,
x_catalog_version_id => lv_new_catalog_version_id,
x_note_type_id => cur_sel_old_ctlg_notes.note_type_id,
x_create_date => cur_sel_old_ctlg_notes.create_date,
x_end_date => cur_sel_old_ctlg_notes.end_date,
x_sequence => cur_sel_old_ctlg_notes.SEQUENCE,
x_note_text => cur_sel_old_ctlg_notes.note_text,
x_mode => 'R',
x_org_id => p_org_id );
igs_ps_catlg_notes_pkg.update_row(
x_rowid => cur_sel_new_ctlg_notes.ROWID,
x_catalog_note_id => cur_sel_new_ctlg_notes.catalog_note_id,
x_catalog_version_id => cur_sel_new_ctlg_notes.catalog_version_id,
x_note_type_id => cur_sel_new_ctlg_notes.note_type_id,
x_create_date => cur_sel_new_ctlg_notes.create_date,
x_end_date => cur_sel_new_ctlg_notes.end_date,
x_sequence => cur_sel_new_ctlg_notes.SEQUENCE,
x_note_text => cur_sel_old_ctlg_notes.note_text,
x_mode => 'R');