[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select 1 into dummy from dual
where not exists
(select 1 from rg_report_displays
where report_display_set_id = nvl(X_report_display_set_id,-1)
and sequence = X_sequence
and ((X_rowid IS NULL) OR (rowid <> X_rowid)));
select rg_report_displays_s.nextval
into next_id
from dual;
PROCEDURE insert_row(X_rowid IN OUT NOCOPY VARCHAR2,
X_report_display_id NUMBER,
X_report_display_set_id NUMBER,
X_sequence NUMBER,
X_display_flag VARCHAR2,
X_row_group_id NUMBER,
X_column_group_id NUMBER,
X_description VARCHAR2,
X_creation_date DATE,
X_created_by NUMBER,
X_last_update_date DATE,
X_last_updated_by NUMBER,
X_last_update_login NUMBER,
X_context VARCHAR2,
X_attribute1 VARCHAR2,
X_attribute2 VARCHAR2,
X_attribute3 VARCHAR2,
X_attribute4 VARCHAR2,
X_attribute5 VARCHAR2,
X_attribute6 VARCHAR2,
X_attribute7 VARCHAR2,
X_attribute8 VARCHAR2,
X_attribute9 VARCHAR2,
X_attribute10 VARCHAR2,
X_attribute11 VARCHAR2,
X_attribute12 VARCHAR2,
X_attribute13 VARCHAR2,
X_attribute14 VARCHAR2,
X_attribute15 VARCHAR2) IS
CURSOR C IS SELECT rowid FROM rg_report_displays
WHERE report_display_id = X_report_display_id;
INSERT INTO RG_REPORT_DISPLAYS
(report_display_id ,
report_display_set_id ,
sequence ,
display_flag ,
row_group_id ,
column_group_id ,
description ,
creation_date ,
created_by ,
last_update_date ,
last_updated_by ,
last_update_login ,
context ,
attribute1 ,
attribute2 ,
attribute3 ,
attribute4 ,
attribute5 ,
attribute6 ,
attribute7 ,
attribute8 ,
attribute9 ,
attribute10 ,
attribute11 ,
attribute12 ,
attribute13 ,
attribute14 ,
attribute15 )
VALUES
(X_report_display_id ,
X_report_display_set_id ,
X_sequence ,
X_display_flag ,
X_row_group_id ,
X_column_group_id ,
X_description ,
X_creation_date ,
X_created_by ,
X_last_update_date ,
X_last_updated_by ,
X_last_update_login ,
X_context ,
X_attribute1 ,
X_attribute2 ,
X_attribute3 ,
X_attribute4 ,
X_attribute5 ,
X_attribute6 ,
X_attribute7 ,
X_attribute8 ,
X_attribute9 ,
X_attribute10 ,
X_attribute11 ,
X_attribute12 ,
X_attribute13 ,
X_attribute14 ,
X_attribute15 );
END insert_row;
PROCEDURE update_row(X_rowid IN OUT NOCOPY VARCHAR2,
X_report_display_id NUMBER,
X_report_display_set_id NUMBER,
X_sequence NUMBER,
X_display_flag VARCHAR2,
X_row_group_id NUMBER,
X_column_group_id NUMBER,
X_description VARCHAR2,
X_last_update_date DATE,
X_last_updated_by NUMBER,
X_last_update_login NUMBER,
X_context VARCHAR2,
X_attribute1 VARCHAR2,
X_attribute2 VARCHAR2,
X_attribute3 VARCHAR2,
X_attribute4 VARCHAR2,
X_attribute5 VARCHAR2,
X_attribute6 VARCHAR2,
X_attribute7 VARCHAR2,
X_attribute8 VARCHAR2,
X_attribute9 VARCHAR2,
X_attribute10 VARCHAR2,
X_attribute11 VARCHAR2,
X_attribute12 VARCHAR2,
X_attribute13 VARCHAR2,
X_attribute14 VARCHAR2,
X_attribute15 VARCHAR2) IS
BEGIN
UPDATE RG_REPORT_DISPLAYS
SET report_display_id = X_report_display_id ,
report_display_set_id = X_report_display_set_id ,
sequence = X_sequence ,
display_flag = X_display_flag ,
row_group_id = X_row_group_id ,
column_group_id = X_column_group_id ,
description = X_description ,
last_update_date = X_last_update_date ,
last_updated_by = X_last_updated_by ,
last_update_login = X_last_update_login ,
context = X_context ,
attribute1 = X_attribute1 ,
attribute2 = X_attribute2 ,
attribute3 = X_attribute3 ,
attribute4 = X_attribute4 ,
attribute5 = X_attribute5 ,
attribute6 = X_attribute6 ,
attribute7 = X_attribute7 ,
attribute8 = X_attribute8 ,
attribute9 = X_attribute9 ,
attribute10 = X_attribute10 ,
attribute11 = X_attribute11 ,
attribute12 = X_attribute12 ,
attribute13 = X_attribute13 ,
attribute14 = X_attribute14 ,
attribute15 = X_attribute15
WHERE rowid = X_rowid;
END update_row;
SELECT *
FROM rg_report_displays
WHERE rowid = X_rowid
FOR UPDATE OF sequence NOWAIT;
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
PROCEDURE delete_row(X_rowid VARCHAR2) IS
BEGIN
DELETE FROM rg_report_displays
WHERE rowid = X_rowid;
END delete_row;