The following lines contain the word 'select', 'insert', 'update' or 'delete':
X_LAST_UPDATED_BY out nocopy NUMBER,
X_LAST_UPDATE_LOGIN out nocopy NUMBER
) is
begin
X_CREATED_BY := AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER);
X_LAST_UPDATED_BY := AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER);
X_LAST_UPDATE_LOGIN := 0;
select ATTRIBUTE_ID
from AME_ATTRIBUTES
where NAME = X_ATTRIBUTE_NAME
and sysdate between START_DATE
and nvl(END_DATE-(1/86400), sysdate);
select CONDITION_ID, CREATED_BY
from AME_CONDITIONS
where CONDITION_KEY = X_CONDITION_KEY;
select C.CREATED_BY
from AME_ATTRIBUTES C
where C.START_DATE =
(select min(A.START_DATE) from AME_ATTRIBUTES A
where A.ATTRIBUTE_ID = C.ATTRIBUTE_ID)
and C.ATTRIBUTE_ID = X_ATTRIBUTE_ID;
select CONDITION_ID
from AME_CONDITIONS
where CONDITION_KEY = X_CONDITION_KEY;
select CONDITION_KEY
from AME_CONDITIONS
where CONDITION_ID = X_CONDITION_ID;
select count(*)
from AME_CONDITIONS
where CONDITION_ID = X_CONDITION_ID;
select C.CREATED_BY
from AME_ATTRIBUTES C
where C.START_DATE =
(select min(A.START_DATE) from AME_ATTRIBUTES A
where A.ATTRIBUTE_ID = C.ATTRIBUTE_ID)
and C.ATTRIBUTE_ID = X_ATTRIBUTE_ID;
select ATTRIBUTE_ID
from AME_ATTRIBUTES
where NAME = X_ATTRIBUTE_NAME
and ((START_DATE - (1/86400)) <= sysdate)
and (((END_DATE - (1/86400)) >= sysdate)
or (END_DATE is null));
select ATTRIBUTE_TYPE
into X_ATTRIBUTE_TYPE
from AME_ATTRIBUTES
where NAME = X_ATTRIBUTE_NAME
and sysdate between START_DATE
and nvl(END_DATE-(1/86400), sysdate);
select to_number(X_PARAMETER_ONE)
into X_PARAMETER_ONE_NUMBER
from dual;
select to_number(X_PARAMETER_TWO)
into X_PARAMETER_TWO_NUMBER
from dual;
select to_number(X_PARAMETER_ONE)
into X_PARAMETER_ONE_NUMBER
from dual;
select to_number(X_PARAMETER_TWO)
into X_PARAMETER_TWO_NUMBER
from dual;
select to_date(X_PARAMETER_ONE,'YYYY:MM:DD:HH24:MI:SS')
into X_PARAMETER_ONE_DATE
from dual;
select to_date(X_PARAMETER_TWO,'YYYY:MM:DD:HH24:MI:SS')
into X_PARAMETER_TWO_DATE
from dual;
procedure INSERT_ROW (
X_CONDITION_KEY in VARCHAR2,
X_CONDITION_TYPE in VARCHAR2,
X_ATTRIBUTE_ID in NUMBER,
X_PARAMETER_ONE in VARCHAR2,
X_PARAMETER_TWO in VARCHAR2,
X_PARAMETER_THREE in VARCHAR2,
X_INCLUDE_UPPER_LIMIT in VARCHAR2,
X_INCLUDE_LOWER_LIMIT 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,
X_START_DATE in DATE,
X_OBJECT_VERSION_NUMBER in NUMBER)
is
lockHandle varchar2(500);
insert into AME_CONDITIONS
(
CONDITION_ID,
CONDITION_KEY,
CONDITION_TYPE,
ATTRIBUTE_ID,
PARAMETER_ONE,
PARAMETER_TWO,
PARAMETER_THREE,
INCLUDE_UPPER_LIMIT,
INCLUDE_LOWER_LIMIT,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
START_DATE,
END_DATE,
OBJECT_VERSION_NUMBER
) select
ame_conditions_s.nextval,
X_CONDITION_KEY,
X_CONDITION_TYPE,
X_ATTRIBUTE_ID,
X_PARAMETER_ONE,
X_PARAMETER_TWO,
X_PARAMETER_THREE,
X_INCLUDE_UPPER_LIMIT,
X_INCLUDE_LOWER_LIMIT,
X_CREATED_BY,
X_CREATION_DATE,
X_LAST_UPDATED_BY,
X_LAST_UPDATE_DATE,
X_LAST_UPDATE_LOGIN,
X_START_DATE,
AME_SEED_UTILITY.GET_DEFAULT_END_DATE,
X_OBJECT_VERSION_NUMBER
from sys.dual
where not exists (select NULL
from AME_CONDITIONS
where CONDITION_KEY = X_CONDITION_KEY);
end INSERT_ROW;
procedure INSERT_ROW_2 (
X_CONDITION_ID in NUMBER,
X_CONDITION_KEY in VARCHAR2,
X_CONDITION_TYPE in VARCHAR2,
X_ATTRIBUTE_ID in NUMBER,
X_PARAMETER_ONE in VARCHAR2,
X_PARAMETER_TWO in VARCHAR2,
X_PARAMETER_THREE in VARCHAR2,
X_INCLUDE_UPPER_LIMIT in VARCHAR2,
X_INCLUDE_LOWER_LIMIT 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,
X_START_DATE in DATE,
X_OBJECT_VERSION_NUMBER in NUMBER)
is
lockHandle varchar2(500);
insert into AME_CONDITIONS
(
CONDITION_ID,
CONDITION_KEY,
CONDITION_TYPE,
ATTRIBUTE_ID,
PARAMETER_ONE,
PARAMETER_TWO,
PARAMETER_THREE,
INCLUDE_UPPER_LIMIT,
INCLUDE_LOWER_LIMIT,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
START_DATE,
END_DATE,
OBJECT_VERSION_NUMBER
) select
X_CONDITION_ID,
X_CONDITION_KEY,
X_CONDITION_TYPE,
X_ATTRIBUTE_ID,
X_PARAMETER_ONE,
X_PARAMETER_TWO,
X_PARAMETER_THREE,
X_INCLUDE_UPPER_LIMIT,
X_INCLUDE_LOWER_LIMIT,
X_CREATED_BY,
X_CREATION_DATE,
X_LAST_UPDATED_BY,
X_LAST_UPDATE_DATE,
X_LAST_UPDATE_LOGIN,
X_START_DATE,
AME_SEED_UTILITY.GET_DEFAULT_END_DATE,
X_OBJECT_VERSION_NUMBER
from sys.dual
where not exists (select NULL
from AME_CONDITIONS
where CONDITION_ID = X_CONDITION_ID);
end INSERT_ROW_2;
procedure DELETE_ROW (
X_CONDITION_KEY in VARCHAR2
) is
begin
delete from AME_CONDITIONS
where CONDITION_KEY = X_CONDITION_KEY;
end DELETE_ROW;
X_LAST_UPDATE_DATE in VARCHAR2,
X_CUSTOM_MODE in VARCHAR2
)
is
X_ATTRIBUTE_ID NUMBER;
X_LAST_UPDATED_BY NUMBER;
X_LAST_UPDATE_LOGIN NUMBER;
X_LAST_UPDATED_BY,
X_LAST_UPDATE_LOGIN
);
update AME_CONDITIONS
set CONDITION_KEY = '@' || X_CONDITION_KEY
where CONDITION_KEY = X_CONDITION_KEY;
INSERT_ROW (
X_CONDITION_KEY,
X_CONDITION_TYPE,
X_ATTRIBUTE_ID,
X_PARAMETER_ONE,
X_PARAMETER_TWO,
X_PARAMETER_THREE,
X_INCLUDE_UPPER_LIMIT,
X_INCLUDE_LOWER_LIMIT,
X_CREATED_BY,
to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
X_LAST_UPDATED_BY,
to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
X_LAST_UPDATE_LOGIN,
to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
1);
INSERT_ROW (
X_CONDITION_KEY,
X_CONDITION_TYPE,
X_ATTRIBUTE_ID,
X_PARAMETER_ONE,
X_PARAMETER_TWO,
X_PARAMETER_THREE,
X_INCLUDE_UPPER_LIMIT,
X_INCLUDE_LOWER_LIMIT,
X_CREATED_BY,
to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
X_LAST_UPDATED_BY,
to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
X_LAST_UPDATE_LOGIN,
to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
1);
INSERT_ROW_2 (
X_CONDITION_ID,
X_CONDITION_KEY2,
X_CONDITION_TYPE,
X_ATTRIBUTE_ID,
X_PARAMETER_ONE,
X_PARAMETER_TWO,
X_PARAMETER_THREE,
X_INCLUDE_UPPER_LIMIT,
X_INCLUDE_LOWER_LIMIT,
X_CREATED_BY,
to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
X_LAST_UPDATED_BY,
to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
X_LAST_UPDATE_LOGIN,
to_date(X_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS'),
1);
update AME_CONDITIONS
set CONDITION_KEY = X_CONDITION_KEY
where CONDITION_KEY = X_EXISTING_CONDITION_KEY
and CONDITION_ID = X_CONDITION_ID;