The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 1
FROM dual
WHERE EXISTS (SELECT 1
FROM OE_DEF_ATTR_CONDNS
WHERE CONDITION_ID = p_condition_id);
SELECT 1
FROM dual
WHERE EXISTS (SELECT 1
FROM OE_DEF_CONDN_ELEMS
WHERE CONDITION_ID = p_condition_id);
SELECT display_name from OE_DEF_CONDITIONS_VL
WHERE display_name = p_display_name
and database_object_name = p_database_object_name
and ((p_rowid is null) OR (row_id <> p_rowid));
PROCEDURE Insert_Row(
--------------------------------------------------------------------------
p_rowid in out NOCOPY /* file.sql.39 change */ varchar2
,p_condition_id in out NOCOPY /* file.sql.39 change */ number
,p_display_name in varchar2
,p_description in varchar2
,p_database_object_name in varchar2
,p_number_of_elements in number
,p_system_flag in varchar2
,p_created_by in number
,p_creation_date in date
,p_last_updated_by in number
,p_last_update_date in date
,p_last_update_login in number
,p_attribute_category in varchar2
,p_attribute1 in varchar2
,p_attribute2 in varchar2
,p_attribute3 in varchar2
,p_attribute4 in varchar2
,p_attribute5 in varchar2
,p_attribute6 in varchar2
,p_attribute7 in varchar2
,p_attribute8 in varchar2
,p_attribute9 in varchar2
,p_attribute10 in varchar2
,p_attribute11 in varchar2
,p_attribute12 in varchar2
,p_attribute13 in varchar2
,p_attribute14 in varchar2
,p_attribute15 in varchar2
) IS
CURSOR C IS SELECT rowid from OE_DEF_CONDITIONS
WHERE condition_id = p_condition_id;
INSERT INTO OE_DEF_CONDITIONS(
condition_id,
database_object_name,
number_of_elements,
created_by,
creation_date,
last_updated_by,
system_flag,
last_update_date,last_update_login)
VALUES (
p_condition_id,
p_database_object_name,
p_number_of_elements,
p_created_by,
p_creation_date,
p_last_updated_by,
p_system_flag,
p_last_update_date,p_last_update_login);
INSERT INTO OE_DEF_CONDITIONS_TL(display_name,description,condition_id,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
language,source_lang)
SELECT
p_display_name,
p_description,
p_condition_id
,p_created_by
,p_creation_date
,p_last_updated_by
,p_last_update_date
,p_last_update_login
,l.language_code
,USERENV('LANG')
FROM fnd_languages l
WHERE l.installed_flag in ('I', 'B')
AND not exists (
SELECT null
FROM oe_def_conditions_tl t
WHERE t.condition_id = p_condition_id
AND t.language = l.language_code);
END Insert_Row;
PROCEDURE Update_Row(
--------------------------------------------------------------------------
p_rowid in varchar2
,p_condition_id in number
,p_display_name in varchar2
,p_description in varchar2
,p_database_object_name in varchar2
,p_number_of_elements in number
,p_system_flag in varchar2
,p_created_by in number
,p_creation_date in date
,p_last_updated_by in number
,p_last_update_date in date
,p_last_update_login in number
,p_attribute_category in varchar2
,p_attribute1 in varchar2
,p_attribute2 in varchar2
,p_attribute3 in varchar2
,p_attribute4 in varchar2
,p_attribute5 in varchar2
,p_attribute6 in varchar2
,p_attribute7 in varchar2
,p_attribute8 in varchar2
,p_attribute9 in varchar2
,p_attribute10 in varchar2
,p_attribute11 in varchar2
,p_attribute12 in varchar2
,p_attribute13 in varchar2
,p_attribute14 in varchar2
,p_attribute15 in varchar2
) IS
BEGIN
UPDATE oe_def_conditions
SET
condition_id = p_condition_id
,system_flag = p_system_flag
,created_by = p_created_by
,creation_date = p_creation_date
,last_updated_by = p_last_updated_by
,last_update_date = p_last_update_date
,last_update_login = p_last_update_login
,attribute_category = p_attribute_category
,attribute1 = p_attribute1
,attribute2 = p_attribute2
,attribute3 = p_attribute3
,attribute4 = p_attribute4
,attribute5 = p_attribute5
,attribute6 = p_attribute6
,attribute7 = p_attribute7
,attribute8 = p_attribute8
,attribute9 = p_attribute9
,attribute10 = p_attribute10
,attribute11 = p_attribute11
,attribute12 = p_attribute12
,attribute13 = p_attribute13
,attribute14 = p_attribute14
,attribute15 = p_attribute15
WHERE condition_id = p_condition_id
AND database_object_name = p_database_object_name;
UPDATE oe_def_conditions_tl
SET
source_lang = USERENV('LANG')
,last_updated_by = p_last_updated_by
,last_update_date = p_last_update_date
,last_update_login = p_last_update_login
,display_name = p_display_name
,description = p_description
WHERE condition_id = p_condition_id
AND USERENV('LANG') in (language, source_lang);
END Update_Row;
PROCEDURE Delete_Row(p_Rowid in VARCHAR2,
p_system_flag in VARCHAR2) IS
--------------------------------------------------------------------------
l_condition_id NUMBER;
SELECT condition_id INTO l_condition_id
FROM OE_DEF_CONDITIONS
WHERE rowid = p_rowid;
DELETE FROM OE_DEF_CONDITIONS
WHERE rowid = p_rowid;
DELETE FROM OE_DEF_CONDITIONS_TL
WHERE condition_id = l_condition_id;
DELETE FROM OE_DEF_CONDN_ELEMS
WHERE condition_id = l_condition_id;
DELETE FROM OE_DEF_ATTR_DEF_RULES
WHERE attr_def_condition_id = l_condition_id;
DELETE FROM OE_DEF_ATTR_CONDNS
WHERE condition_id = l_condition_id;
END Delete_Row;
,p_last_updated_by in number
,p_last_update_date in date
,p_last_update_login in number
,p_attribute_category in varchar2
,p_attribute1 in varchar2
,p_attribute2 in varchar2
,p_attribute3 in varchar2
,p_attribute4 in varchar2
,p_attribute5 in varchar2
,p_attribute6 in varchar2
,p_attribute7 in varchar2
,p_attribute8 in varchar2
,p_attribute9 in varchar2
,p_attribute10 in varchar2
,p_attribute11 in varchar2
,p_attribute12 in varchar2
,p_attribute13 in varchar2
,p_attribute14 in varchar2
,p_attribute15 in varchar2
) IS
CURSOR C IS
SELECT * FROM OE_DEF_CONDITIONS
WHERE rowid = p_Rowid
FOR UPDATE OF condition_id NOWAIT;
SELECT *
FROM oe_def_conditions_tl t
WHERE condition_id = p_condition_id
AND language = userenv('LANG')
FOR UPDATE OF condition_id NOWAIT;
FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
AND (tlinfo.last_updated_by = p_last_updated_by)
AND (tlinfo.creation_date = p_creation_date)
AND (tlinfo.created_by = p_created_by)
AND (tlinfo.last_update_date = p_last_update_date)
AND (tlinfo.last_update_login = p_last_update_login)
AND ( (rtrim(tlinfo.description) = p_description)
OR ( (tlinfo.description IS NULL)
AND(p_description IS NULL)))
) then
return;
UPDATE oe_def_conditions_tl
SET
source_lang = USERENV('LANG')
,last_updated_by = decode(p_OWNER, 'SEED', 1, 0)
,last_update_date = sysdate
,last_update_login = 0
,display_name = p_display_name
,description = p_description
WHERE condition_id = p_condition_id
AND USERENV('LANG') in (language, source_lang);
defcondn_pkg.UPDATE_ROW(
p_rowid => row_id
,p_condition_id => p_condition_id
,p_display_name => p_display_name
,p_description => p_description
,p_database_object_name => p_database_object_name
,p_number_of_elements => p_number_of_elements
,p_system_flag => p_system_flag
,p_created_by => user_id
,p_creation_date => sysdate
,p_last_updated_by => user_id
,p_last_update_date => sysdate
,p_last_update_login => 0
,p_attribute_category => p_attribute_category
,p_attribute1 => p_attribute1
,p_attribute2 => p_attribute2
,p_attribute3 => p_attribute3
,p_attribute4 => p_attribute4
,p_attribute5 => p_attribute5
,p_attribute6 => p_attribute6
,p_attribute7 => p_attribute7
,p_attribute8 => p_attribute8
,p_attribute9 => p_attribute9
,p_attribute10 => p_attribute10
,p_attribute11 => p_attribute11
,p_attribute12 => p_attribute12
,p_attribute13 => p_attribute13
,p_attribute14 => p_attribute14
,p_attribute15 => p_attribute15
);
defcondn_pkg.INSERT_ROW(
p_rowid => row_id
,p_condition_id => l_condition_id
,p_display_name => p_display_name
,p_description => p_description
,p_database_object_name => p_database_object_name
,p_number_of_elements => p_number_of_elements
,p_system_flag => p_system_flag
,p_created_by => user_id
,p_creation_date => sysdate
,p_last_updated_by => user_id
,p_last_update_date => sysdate
,p_last_update_login => 0
,p_attribute_category => p_attribute_category
,p_attribute1 => p_attribute1
,p_attribute2 => p_attribute2
,p_attribute3 => p_attribute3
,p_attribute4 => p_attribute4
,p_attribute5 => p_attribute5
,p_attribute6 => p_attribute6
,p_attribute7 => p_attribute7
,p_attribute8 => p_attribute8
,p_attribute9 => p_attribute9
,p_attribute10 => p_attribute10
,p_attribute11 => p_attribute11
,p_attribute12 => p_attribute12
,p_attribute13 => p_attribute13
,p_attribute14 => p_attribute14
,p_attribute15 => p_attribute15
);
DELETE FROM oe_def_conditions_tl t
WHERE NOT EXISTS
(SELECT null
FROM oe_def_conditions b
where b.condition_id = t.condition_id);
UPDATE oe_def_conditions_tl t
SET
(
display_name,
description
) = (
SELECT
b.display_name,
b.description
FROM oe_def_conditions_tl b
WHERE b.condition_id = t.condition_id
AND b.language = t.source_lang
)
where
(
t.condition_id,
t.language
) IN (
SELECT
subt.condition_id,
subt.language
FROM oe_def_conditions_tl subb, oe_def_conditions_tl subt
WHERE subb.condition_id = subt.condition_id
AND subb.language = subt.source_lang
AND(subb.display_name <> subt.display_name
OR subb.DESCRIPTION <> subt.description
OR (subb.description IS null AND subt.description IS NOT null)
OR (subb.description IS NOT null AND subt.description IS null)
)
);
INSERT INTO oe_def_conditions_tl
(
condition_id
,language
,source_lang
,created_by
,creation_date
,last_updated_by
,last_update_date
,display_name
,description
,last_update_login
)
SELECT
b.condition_id
,l.language_code
,b.source_lang -- bug 2329327
,b.created_by
,b.creation_date
,b.last_updated_by
,b.last_update_date
,b.display_name
,b.description
,b.last_update_login
FROM oe_def_conditions_tl b, fnd_languages l
WHERE l.installed_flag IN ('I', 'B')
AND b.language = USERENV('LANG')
AND NOT EXISTS
( SELECT null
FROM oe_def_conditions_tl t
WHERE t.condition_id = b.condition_id
AND t.language = l.language_code);