[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 gl_bc_option_details
WHERE bc_option_id = X_bc_option_id
AND je_source_name = X_je_source_name
AND je_category_name = X_je_category_name
AND ((X_rowid IS NULL) OR (rowid <> X_rowid)));
PROCEDURE insert_row(X_rowid IN OUT NOCOPY VARCHAR2 ,
X_bc_option_id NUMBER ,
X_last_update_date DATE ,
X_last_updated_by NUMBER ,
X_last_update_login NUMBER ,
X_je_source_name VARCHAR2 ,
X_je_category_name VARCHAR2 ,
X_funds_check_level_code VARCHAR2 ,
X_creation_date DATE ,
X_created_by NUMBER ,
X_override_amount NUMBER ,
X_tolerance_percentage NUMBER ,
X_tolerance_amount 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 gl_bc_option_details
WHERE bc_option_id = X_bc_option_id
AND je_source_name = X_je_source_name
AND je_category_name = X_je_category_name;
INSERT INTO gl_bc_option_details(
bc_option_id ,
last_update_date ,
last_updated_by ,
last_update_login ,
je_source_name ,
je_category_name ,
funds_check_level_code ,
creation_date ,
created_by ,
override_amount ,
tolerance_percentage ,
tolerance_amount ,
context ,
attribute1 ,
attribute2 ,
attribute3 ,
attribute4 ,
attribute5 ,
attribute6 ,
attribute7 ,
attribute8 ,
attribute9 ,
attribute10 ,
attribute11 ,
attribute12 ,
attribute13 ,
attribute14 ,
attribute15 )
VALUES
(X_bc_option_id ,
X_last_update_date ,
X_last_updated_by ,
X_last_update_login ,
X_je_source_name ,
X_je_category_name ,
X_funds_check_level_code ,
X_creation_date ,
X_created_by ,
X_override_amount ,
X_tolerance_percentage ,
X_tolerance_amount ,
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_bc_option_id NUMBER ,
X_last_update_date DATE ,
X_last_updated_by NUMBER ,
X_last_update_login NUMBER ,
X_je_source_name VARCHAR2 ,
X_je_category_name VARCHAR2 ,
X_funds_check_level_code VARCHAR2 ,
X_override_amount NUMBER ,
X_tolerance_percentage NUMBER ,
X_tolerance_amount 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 gl_bc_option_details
SET
bc_option_id = X_bc_option_id ,
last_update_date = X_last_update_date ,
last_updated_by = X_last_updated_by ,
last_update_login = X_last_update_login ,
je_source_name = X_je_source_name ,
je_category_name = X_je_category_name ,
funds_check_level_code = X_funds_check_level_code ,
override_amount = X_override_amount ,
tolerance_percentage = X_tolerance_percentage ,
tolerance_amount = X_tolerance_amount ,
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 gl_bc_option_details
WHERE rowid = X_rowid
FOR UPDATE OF bc_option_id NOWAIT;
FND_MESSAGE.set_name('FND', 'FORM_RECORD_DELETED');
PROCEDURE delete_row(X_rowid VARCHAR2) IS
BEGIN
DELETE FROM gl_bc_option_details
WHERE rowid = X_rowid;
END delete_row;
SELECT user_je_source_name
INTO name
FROM gl_je_sources
WHERE je_source_name = 'Other';
SELECT user_je_category_name
INTO name
FROM gl_je_categories
WHERE je_category_name = 'Other';