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_INSTANCE_VALUE_ID IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
P_SECT_COMP_MAP_ID IN NUMBER,
P_Template_Instance_ID IN NUMBER,
P_created_by IN NUMBER ,
P_last_updated_by IN NUMBER,
P_last_update_login IN NUMBER,
P_creation_date IN DATE := SYSDATE,
P_last_update_date IN DATE := SYSDATE,
P_Value IN VARCHAR2 := NULL,
P_Value_Type_Qualifier IN VARCHAR2 := NULL,
P_Response_id IN NUMBER := NULL,
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_INSTANCE_VALUE
where INSTANCE_VALUE_ID = PX_INSTANCE_VALUE_ID ;
select ASO_SUP_INST_VALUE_S.NEXTVAL from sys.dual;
insert into ASO_SUP_INSTANCE_VALUE (
INSTANCE_VALUE_ID,
SECT_COMP_MAP_ID,
Template_Instance_ID,
Value,
Value_Type_Qualifier,
Response_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_INSTANCE_VALUE_ID,
P_SECT_COMP_MAP_ID,
P_Template_Instance_ID,
P_Value,
P_Value_Type_Qualifier,
P_Response_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_INSTANCE_VALUE_ID IN NUMBER,
P_SECT_COMP_MAP_ID IN NUMBER,
P_Template_Instance_ID IN NUMBER,
P_last_updated_by IN NUMBER,
P_last_update_date IN DATE := SYSDATE,
P_last_update_login IN NUMBER,
P_Value IN VARCHAR2,
P_Value_Type_Qualifier IN VARCHAR2,
P_Response_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_INSTANCE_VALUE
set
SECT_COMP_MAP_ID = P_SECT_COMP_MAP_ID,
Template_Instance_ID = P_Template_Instance_ID,
Value = P_Value ,
Value_Type_Qualifier = P_Value_Type_Qualifier,
Response_id = P_Response_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 INSTANCE_VALUE_ID = P_INSTANCE_VALUE_ID;
End UPDATE_ROW;
/* procedure to Delete Row */
procedure DELETE_ROW (
P_INSTANCE_VALUE_ID IN NUMBER
)
IS
Begin
delete from ASO_SUP_INSTANCE_VALUE
where INSTANCE_VALUE_ID = P_INSTANCE_VALUE_ID;
End Delete_row;
P_last_updated_by IN NUMBER,
P_last_update_date IN DATE,
P_last_update_login IN NUMBER,
P_Value IN VARCHAR2,
P_Value_Type_Qualifier IN VARCHAR2,
P_Response_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.INSTANCE_VALUE_ID ,
--OBJECT_VERSION_NUMBER,
a.SECT_COMP_MAP_ID,
a.Template_Instance_ID,
a.Value,
a.Value_Type_Qualifier,
a.Response_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_INSTANCE_VALUE a
where a.INSTANCE_VALUE_ID = P_INSTANCE_VALUE_ID
for update of a.INSTANCE_VALUE_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;