The following lines contain the word 'select', 'insert', 'update' or 'delete':
/* procedure to insert INSERT_ROW */
PROCEDURE INSERT_ROW
(
PX_ROWID IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
PX_TEMPLATE_INSTANCE_ID IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
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_TEMPLATE_ID IN NUMBER,
P_Owner_Table_Name IN VARCHAR2,
P_Owner_Table_Id IN NUMBER,
P_CONTEXT IN VARCHAR2 := NULL,
P_ATTRIBUTE1 IN VARCHAR2 := NULL,
P_ATTRIBUTE2 IN VARCHAR2 := NULL,
P_ATTRIBUTE3 IN VARCHAR2 := NULL,
P_ATTRIBUTE4 IN VARCHAR2 := NULL,
P_ATTRIBUTE5 IN VARCHAR2 := NULL,
P_ATTRIBUTE6 IN VARCHAR2 := NULL,
P_ATTRIBUTE7 IN VARCHAR2 := NULL,
P_ATTRIBUTE8 IN VARCHAR2 := NULL,
P_ATTRIBUTE9 IN VARCHAR2 := NULL,
P_ATTRIBUTE10 IN VARCHAR2 := NULL,
P_ATTRIBUTE11 IN VARCHAR2 := NULL,
P_ATTRIBUTE12 IN VARCHAR2 := NULL,
P_ATTRIBUTE13 IN VARCHAR2 := NULL,
P_ATTRIBUTE14 IN VARCHAR2 := NULL,
P_ATTRIBUTE15 IN VARCHAR2 := NULL,
P_ATTRIBUTE16 IN VARCHAR2 := NULL,
P_ATTRIBUTE17 IN VARCHAR2 := NULL,
P_ATTRIBUTE18 IN VARCHAR2 := NULL,
P_ATTRIBUTE19 IN VARCHAR2 := NULL,
P_ATTRIBUTE20 IN VARCHAR2 := NULL,
p_OBJECT_VERSION_NUMBER IN NUMBER
)
IS
cursor c is
select ROWID
from ASO_SUP_TMPL_INSTANCE
where TEMPLATE_INSTANCE_ID = PX_TEMPLATE_INSTANCE_ID ;
select ASO_SUP_TMPL_INSTANCE_S.NEXTVAL from sys.dual;
insert into ASO_SUP_TMPL_INSTANCE (
TEMPLATE_INSTANCE_ID,
TEMPLATE_ID,
Owner_Table_Name,
Owner_Table_Id,
created_by ,
creation_date ,
last_updated_by ,
last_update_date ,
last_update_login ,
CONTEXT,
ATTRIBUTE1 ,
ATTRIBUTE2 ,
ATTRIBUTE3 ,
ATTRIBUTE4 ,
ATTRIBUTE5 ,
ATTRIBUTE6 ,
ATTRIBUTE7 ,
ATTRIBUTE8 ,
ATTRIBUTE9 ,
ATTRIBUTE10 ,
ATTRIBUTE11 ,
ATTRIBUTE12 ,
ATTRIBUTE13 ,
ATTRIBUTE14 ,
ATTRIBUTE15,
ATTRIBUTE16,
ATTRIBUTE17,
ATTRIBUTE18,
ATTRIBUTE19,
ATTRIBUTE20,
OBJECT_VERSION_NUMBER
)
values
(
PX_TEMPLATE_INSTANCE_ID,
P_TEMPLATE_ID,
P_Owner_Table_Name,
P_Owner_Table_Id,
P_created_by ,
P_creation_date ,
P_last_updated_by ,
P_last_update_date ,
P_last_update_login,
P_CONTEXT,
P_ATTRIBUTE1 ,
P_ATTRIBUTE2 ,
P_ATTRIBUTE3 ,
P_ATTRIBUTE4 ,
P_ATTRIBUTE5 ,
P_ATTRIBUTE6 ,
P_ATTRIBUTE7 ,
P_ATTRIBUTE8 ,
P_ATTRIBUTE9 ,
P_ATTRIBUTE10 ,
P_ATTRIBUTE11 ,
P_ATTRIBUTE12 ,
P_ATTRIBUTE13 ,
P_ATTRIBUTE14 ,
P_ATTRIBUTE15,
P_ATTRIBUTE16,
P_ATTRIBUTE17,
P_ATTRIBUTE18,
P_ATTRIBUTE19,
P_ATTRIBUTE20,
decode ( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,1,NULL,1, p_OBJECT_VERSION_NUMBER)
) ;
end INSERT_ROW;
/* procedure to Update Row */
PROCEDURE UPDATE_ROW
(
P_TEMPLATE_INSTANCE_ID IN NUMBER,
P_last_updated_by IN NUMBER,
P_last_update_date IN DATE,
P_last_update_login IN NUMBER,
P_TEMPLATE_ID IN NUMBER,
P_Owner_Table_Name IN VARCHAR2,
P_Owner_Table_Id IN NUMBER,
P_CONTEXT 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,
P_ATTRIBUTE16 IN VARCHAR2,
P_ATTRIBUTE17 IN VARCHAR2,
P_ATTRIBUTE18 IN VARCHAR2,
P_ATTRIBUTE19 IN VARCHAR2,
P_ATTRIBUTE20 IN VARCHAR2,
p_OBJECT_VERSION_NUMBER IN NUMBER
)
IS
Begin
update ASO_SUP_TMPL_INSTANCE
set
TEMPLATE_ID = P_TEMPLATE_ID,
Owner_Table_Name = P_Owner_Table_Name ,
Owner_Table_Id = P_Owner_Table_Id ,
last_updated_by = P_last_updated_by,
last_update_date = P_last_update_date,
last_update_login = P_last_update_login,
context = P_context,
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,
ATTRIBUTE16 = P_ATTRIBUTE16,
ATTRIBUTE17 = P_ATTRIBUTE17,
ATTRIBUTE18 = P_ATTRIBUTE18,
ATTRIBUTE19 = P_ATTRIBUTE19,
ATTRIBUTE20 = P_ATTRIBUTE20,
OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, nvl(OBJECT_VERSION_NUMBER,0)+1, nvl(p_OBJECT_VERSION_NUMBER, nvl(OBJECT_VERSION_NUMBER,0))+1)
where TEMPLATE_INSTANCE_ID = P_TEMPLATE_INSTANCE_ID;
End UPDATE_ROW;
/* procedure to Delete Row */
procedure DELETE_ROW (
P_TEMPLATE_INSTANCE_ID IN NUMBER
)
IS
Begin
delete from ASO_SUP_TMPL_INSTANCE
where TEMPLATE_INSTANCE_ID = P_TEMPLATE_INSTANCE_ID;
End Delete_row;
P_last_updated_by IN NUMBER,
P_last_update_date IN DATE,
P_last_update_login IN NUMBER,
P_TEMPLATE_ID IN NUMBER,
P_Owner_Table_Name IN VARCHAR2,
P_Owner_Table_Id IN NUMBER,
P_CONTEXT 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 i_csr is
SELECT
a.TEMPLATE_INSTANCE_ID ,
--OBJECT_VERSION_NUMBER,
a.TEMPLATE_ID,
a.Owner_Table_Name ,
a.Owner_Table_Id,
created_by ,
creation_date ,
last_updated_by ,
last_update_date ,
last_update_login ,
context,
ATTRIBUTE1 ,
ATTRIBUTE2 ,
ATTRIBUTE3 ,
ATTRIBUTE4 ,
ATTRIBUTE5 ,
ATTRIBUTE6 ,
ATTRIBUTE7 ,
ATTRIBUTE8 ,
ATTRIBUTE9 ,
ATTRIBUTE10 ,
ATTRIBUTE11 ,
ATTRIBUTE12 ,
ATTRIBUTE13 ,
ATTRIBUTE14 ,
ATTRIBUTE15
from ASO_SUP_TMPL_INSTANCE a
where a.TEMPLATE_INSTANCE_ID = P_TEMPLATE_INSTANCE_ID
for update of a.TEMPLATE_INSTANCE_ID nowait;
fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
AND ((recinfo.LAST_UPDATED_BY = P_LAST_UPDATED_BY)
OR ((recinfo.LAST_UPDATED_BY is null) AND (P_LAST_UPDATED_BY is null)))
AND ((recinfo.LAST_UPDATE_DATE = P_LAST_UPDATE_DATE)
OR ((recinfo.LAST_UPDATE_DATE is null) AND (P_LAST_UPDATE_DATE is null)))
/* AND
( ( Recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER)
OR ( ( Recinfo.OBJECT_VERSION_NUMBER IS NULL )
AND ( p_OBJECT_VERSION_NUMBER IS NULL )))*/
AND ((recinfo.LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN)
OR ((recinfo.LAST_UPDATE_LOGIN is null) AND (P_LAST_UPDATE_LOGIN is null)))
AND ((recinfo.CONTEXT = P_CONTEXT)
OR ((recinfo.CONTEXT is null) AND (P_CONTEXT is null)))
AND ((recinfo.ATTRIBUTE1 = P_ATTRIBUTE1)
OR ((recinfo.ATTRIBUTE1 is null) AND (P_ATTRIBUTE1 is null)))
AND ((recinfo.ATTRIBUTE2 = P_ATTRIBUTE2)
OR ((recinfo.ATTRIBUTE2 is null) AND (P_ATTRIBUTE2 is null)))
AND ((recinfo.ATTRIBUTE3 = P_ATTRIBUTE3)
OR ((recinfo.ATTRIBUTE3 is null) AND (P_ATTRIBUTE3 is null)))
AND ((recinfo.ATTRIBUTE4 = P_ATTRIBUTE4)
OR ((recinfo.ATTRIBUTE4 is null) AND (P_ATTRIBUTE4 is null)))
AND ((recinfo.ATTRIBUTE5 = P_ATTRIBUTE5)
OR ((recinfo.ATTRIBUTE5 is null) AND (P_ATTRIBUTE5 is null)))
AND ((recinfo.ATTRIBUTE6 = P_ATTRIBUTE6)
OR ((recinfo.ATTRIBUTE6 is null) AND (P_ATTRIBUTE6 is null)))
AND ((recinfo.ATTRIBUTE7 = P_ATTRIBUTE7)
OR ((recinfo.ATTRIBUTE7 is null) AND (P_ATTRIBUTE7 is null)))
AND ((recinfo.ATTRIBUTE8 = P_ATTRIBUTE8)
OR ((recinfo.ATTRIBUTE8 is null) AND (P_ATTRIBUTE8 is null)))
AND ((recinfo.ATTRIBUTE9 = P_ATTRIBUTE9)
OR ((recinfo.ATTRIBUTE9 is null) AND (P_ATTRIBUTE9 is null)))
AND ((recinfo.ATTRIBUTE10 = P_ATTRIBUTE10)
OR ((recinfo.ATTRIBUTE10 is null) AND (P_ATTRIBUTE10 is null)))
AND ((recinfo.ATTRIBUTE11 = P_ATTRIBUTE11)
OR ((recinfo.ATTRIBUTE11 is null) AND (P_ATTRIBUTE11 is null)))
AND ((recinfo.ATTRIBUTE12 = P_ATTRIBUTE12)
OR ((recinfo.ATTRIBUTE12 is null) AND (P_ATTRIBUTE12 is null)))
AND ((recinfo.ATTRIBUTE13 = P_ATTRIBUTE13)
OR ((recinfo.ATTRIBUTE13 is null) AND (P_ATTRIBUTE13 is null)))
AND ((recinfo.ATTRIBUTE14 = P_ATTRIBUTE14)
OR ((recinfo.ATTRIBUTE14 is null) AND (P_ATTRIBUTE14 is null)))
AND ((recinfo.ATTRIBUTE15 = P_ATTRIBUTE15)
OR ((recinfo.ATTRIBUTE15 is null) AND (P_ATTRIBUTE15 is null)))
) then
null;