APPS.AK_CRITERIA_PKG SQL Statements

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

Line: 3

procedure INSERT_ROW (
X_ROWID                        in out NOCOPY VARCHAR2,
X_CUSTOMIZATION_APPLICATION_ID in     NUMBER,
X_CUSTOMIZATION_CODE           in     VARCHAR2,
X_REGION_APPLICATION_ID        in     NUMBER,
X_REGION_CODE                  in     VARCHAR2,
X_ATTRIBUTE_APPLICATION_ID     in     NUMBER,
X_ATTRIBUTE_CODE               in     VARCHAR2,
X_SEQUENCE_NUMBER              in     NUMBER,
X_OPERATION                    in     VARCHAR2,
X_VALUE_VARCHAR2               in     VARCHAR2,
X_VALUE_NUMBER                 in     NUMBER,
X_VALUE_DATE                   in     DATE,
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,
X_START_DATE_ACTIVE            in     DATE,
X_END_DATE_ACTIVE              in     DATE
) is
cursor C is select ROWID from AK_CRITERIA
where CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
and   CUSTOMIZATION_CODE           = X_CUSTOMIZATION_CODE
and   REGION_APPLICATION_ID        = X_REGION_APPLICATION_ID
and   REGION_CODE                  = X_REGION_CODE
and   ATTRIBUTE_APPLICATION_ID     = X_ATTRIBUTE_APPLICATION_ID
and   ATTRIBUTE_CODE               = X_ATTRIBUTE_CODE
and   SEQUENCE_NUMBER              = X_SEQUENCE_NUMBER;

Line: 33

insert into AK_CRITERIA (
CUSTOMIZATION_APPLICATION_ID,
CUSTOMIZATION_CODE,
REGION_APPLICATION_ID,
REGION_CODE,
ATTRIBUTE_APPLICATION_ID,
ATTRIBUTE_CODE,
SEQUENCE_NUMBER,
OPERATION,
VALUE_VARCHAR2,
VALUE_NUMBER,
VALUE_DATE,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
START_DATE_ACTIVE,
END_DATE_ACTIVE
) values (
X_CUSTOMIZATION_APPLICATION_ID,
X_CUSTOMIZATION_CODE,
X_REGION_APPLICATION_ID,
X_REGION_CODE,
X_ATTRIBUTE_APPLICATION_ID,
X_ATTRIBUTE_CODE,
X_SEQUENCE_NUMBER,
X_OPERATION,
X_VALUE_VARCHAR2,
X_VALUE_NUMBER,
X_VALUE_DATE,
X_CREATED_BY,
X_CREATION_DATE,
X_LAST_UPDATED_BY,
X_LAST_UPDATE_DATE,
X_LAST_UPDATE_LOGIN,
X_START_DATE_ACTIVE,
X_END_DATE_ACTIVE
);

Line: 80

end INSERT_ROW;

Line: 96

X_LAST_UPDATED_BY              in     NUMBER,
X_LAST_UPDATE_DATE             in     DATE,
X_LAST_UPDATE_LOGIN            in     NUMBER,
X_START_DATE_ACTIVE            in     DATE,
X_END_DATE_ACTIVE              in     DATE
) is
cursor C is select
CUSTOMIZATION_APPLICATION_ID,
CUSTOMIZATION_CODE,
REGION_APPLICATION_ID,
REGION_CODE,
ATTRIBUTE_APPLICATION_ID,
ATTRIBUTE_CODE,
SEQUENCE_NUMBER,
OPERATION,
VALUE_VARCHAR2,
VALUE_NUMBER,
VALUE_DATE
from AK_CRITERIA
where CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
and   CUSTOMIZATION_CODE           = X_CUSTOMIZATION_CODE
and   REGION_APPLICATION_ID        = X_REGION_APPLICATION_ID
and   REGION_CODE                  = X_REGION_CODE
and   ATTRIBUTE_APPLICATION_ID     = X_ATTRIBUTE_APPLICATION_ID
and   ATTRIBUTE_CODE               = X_ATTRIBUTE_CODE
and   SEQUENCE_NUMBER              = X_SEQUENCE_NUMBER
for update of CUSTOMIZATION_APPLICATION_ID nowait;

Line: 129

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

Line: 176

procedure UPDATE_ROW (
X_CUSTOMIZATION_APPLICATION_ID in NUMBER,
X_CUSTOMIZATION_CODE           in VARCHAR2,
X_REGION_APPLICATION_ID        in NUMBER,
X_REGION_CODE                  in VARCHAR2,
X_ATTRIBUTE_APPLICATION_ID     in NUMBER,
X_ATTRIBUTE_CODE               in VARCHAR2,
X_SEQUENCE_NUMBER              in NUMBER,
X_OPERATION                    in VARCHAR2,
X_VALUE_VARCHAR2               in VARCHAR2,
X_VALUE_NUMBER                 in NUMBER,
X_VALUE_DATE                   in DATE,
X_LAST_UPDATED_BY              in NUMBER,
X_LAST_UPDATE_DATE             in DATE,
X_LAST_UPDATE_LOGIN            in NUMBER,
X_START_DATE_ACTIVE            in DATE,
X_END_DATE_ACTIVE              in DATE
) is
begin
update AK_CRITERIA set
CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID,
CUSTOMIZATION_CODE           = X_CUSTOMIZATION_CODE,
REGION_APPLICATION_ID        = X_REGION_APPLICATION_ID,
REGION_CODE                  = X_REGION_CODE,
ATTRIBUTE_APPLICATION_ID     = X_ATTRIBUTE_APPLICATION_ID,
ATTRIBUTE_CODE               = X_ATTRIBUTE_CODE,
SEQUENCE_NUMBER              = X_SEQUENCE_NUMBER,
OPERATION                    = X_OPERATION,
VALUE_VARCHAR2               = X_VALUE_VARCHAR2,
VALUE_NUMBER                 = X_VALUE_NUMBER,
VALUE_DATE                   = X_VALUE_DATE,
LAST_UPDATED_BY              = X_LAST_UPDATED_BY,
LAST_UPDATE_DATE             = X_LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN            = X_LAST_UPDATE_LOGIN,
START_DATE_ACTIVE            = X_START_DATE_ACTIVE,
END_DATE_ACTIVE              = X_END_DATE_ACTIVE
where CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
and   CUSTOMIZATION_CODE           = X_CUSTOMIZATION_CODE
and   REGION_APPLICATION_ID        = X_REGION_APPLICATION_ID
and   REGION_CODE                  = X_REGION_CODE
and   ATTRIBUTE_APPLICATION_ID     = X_ATTRIBUTE_APPLICATION_ID
and   ATTRIBUTE_CODE               = X_ATTRIBUTE_CODE
and   SEQUENCE_NUMBER              = X_SEQUENCE_NUMBER;

Line: 223

end UPDATE_ROW;

Line: 225

procedure DELETE_ROW (
X_CUSTOMIZATION_APPLICATION_ID in NUMBER,
X_CUSTOMIZATION_CODE           in VARCHAR2,
X_REGION_APPLICATION_ID        in NUMBER,
X_REGION_CODE                  in VARCHAR2,
X_ATTRIBUTE_APPLICATION_ID     in NUMBER,
X_ATTRIBUTE_CODE               in VARCHAR2,
X_SEQUENCE_NUMBER              in NUMBER
) is
begin
delete from AK_CRITERIA
where CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
and   CUSTOMIZATION_CODE           = X_CUSTOMIZATION_CODE
and   REGION_APPLICATION_ID        = X_REGION_APPLICATION_ID
and   REGION_CODE                  = X_REGION_CODE
and   ATTRIBUTE_APPLICATION_ID     = X_ATTRIBUTE_APPLICATION_ID
and   ATTRIBUTE_CODE               = X_ATTRIBUTE_CODE
and   SEQUENCE_NUMBER              = X_SEQUENCE_NUMBER;

Line: 247

end DELETE_ROW;