APPS.AK_CUSTOM_REGISTRY_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 4

procedure INSERT_ROW (
X_ROWID                  in out NOCOPY VARCHAR2,
X_CUSTOMIZATION_LEVEL_ID in     NUMBER,
X_CUSTOM_LEVEL           in     VARCHAR2,
X_PROPERTY_NAME          in     VARCHAR2,
X_TRANSLATABLE           in     VARCHAR2,
X_CREATED_BY             in     NUMBER,
X_CREATION_DATE          in     DATE,
X_LAST_UPDATED_BY        in     NUMBER,
X_LAST_UPDATE_DATE       in     DATE,
X_LAST_UPDATE_LOGIN      in     NUMBER
) is
cursor C is select ROWID from AK_CUSTOM_REGISTRY
where CUSTOMIZATION_LEVEL_ID = X_CUSTOMIZATION_LEVEL_ID
and   CUSTOM_LEVEL           = X_CUSTOM_LEVEL
and   PROPERTY_NAME          = X_PROPERTY_NAME;

Line: 21

insert into AK_CUSTOM_REGISTRY (
CUSTOMIZATION_LEVEL_ID,
CUSTOM_LEVEL,
PROPERTY_NAME,
TRANSLATABLE,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN
) values (
X_CUSTOMIZATION_LEVEL_ID,
X_CUSTOM_LEVEL,
X_PROPERTY_NAME,
X_TRANSLATABLE,
X_CREATED_BY,
X_CREATION_DATE,
X_LAST_UPDATED_BY,
X_LAST_UPDATE_DATE,
X_LAST_UPDATE_LOGIN
) ;

Line: 50

end INSERT_ROW;

Line: 59

X_LAST_UPDATED_BY        in NUMBER,
X_LAST_UPDATE_DATE       in DATE,
X_LAST_UPDATE_LOGIN      in NUMBER
) is
cursor C is select
CUSTOMIZATION_LEVEL_ID,
CUSTOM_LEVEL,
PROPERTY_NAME,
TRANSLATABLE,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN
from AK_CUSTOM_REGISTRY
where CUSTOMIZATION_LEVEL_ID = X_CUSTOMIZATION_LEVEL_ID
and   CUSTOM_LEVEL           = X_CUSTOM_LEVEL
and   PROPERTY_NAME          = X_PROPERTY_NAME
for update of CUSTOMIZATION_LEVEL_ID nowait;

Line: 84

fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 109

procedure UPDATE_ROW (
X_CUSTOMIZATION_LEVEL_ID in NUMBER,
X_CUSTOM_LEVEL           in VARCHAR2,
X_PROPERTY_NAME          in VARCHAR2,
X_TRANSLATABLE           in VARCHAR2,
X_CREATED_BY             in NUMBER,
X_CREATION_DATE          in DATE,
X_LAST_UPDATED_BY        in NUMBER,
X_LAST_UPDATE_DATE       in DATE,
X_LAST_UPDATE_LOGIN      in NUMBER
) is
begin
update AK_CUSTOM_REGISTRY set
CUSTOMIZATION_LEVEL_ID = X_CUSTOMIZATION_LEVEL_ID,
CUSTOM_LEVEL           = X_CUSTOM_LEVEL,
PROPERTY_NAME          = X_PROPERTY_NAME,
TRANSLATABLE           = X_TRANSLATABLE,
CREATED_BY             = X_CREATED_BY,
CREATION_DATE          = X_CREATION_DATE,
LAST_UPDATED_BY        = X_LAST_UPDATED_BY,
LAST_UPDATE_DATE       = X_LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN      = X_LAST_UPDATE_LOGIN
where CUSTOMIZATION_LEVEL_ID = X_CUSTOMIZATION_LEVEL_ID
and   CUSTOM_LEVEL           = X_CUSTOM_LEVEL
and   PROPERTY_NAME          = X_PROPERTY_NAME;

Line: 138

end UPDATE_ROW;

Line: 140

procedure DELETE_ROW (
X_CUSTOMIZATION_LEVEL_ID in NUMBER,
X_CUSTOM_LEVEL           in VARCHAR2,
X_PROPERTY_NAME          in VARCHAR2
) is
begin
delete from AK_CUSTOM_REGISTRY
where CUSTOMIZATION_LEVEL_ID = X_CUSTOMIZATION_LEVEL_ID
and   CUSTOM_LEVEL           = X_CUSTOM_LEVEL
and   PROPERTY_NAME          = X_PROPERTY_NAME;

Line: 154

end DELETE_ROW;