The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure INSERT_ROW (
X_ROWID in out nocopy VARCHAR2,
X_TOPIC_INTEGRATIONS_ID in out nocopy NUMBER,
X_TOPIC_ID in NUMBER,
X_INTEGRATION_ID in NUMBER,
X_PARAM_NAME1 in VARCHAR2,
X_PARAM_VALUE1 in VARCHAR2,
X_PARAM_NAME2 in VARCHAR2,
X_PARAM_VALUE2 in VARCHAR2,
X_PARAM_NAME3 in VARCHAR2,
X_PARAM_VALUE3 in VARCHAR2,
X_PARAM_NAME4 in VARCHAR2,
X_PARAM_VALUE4 in VARCHAR2,
X_PARAM_NAME5 in VARCHAR2,
X_PARAM_VALUE5 in VARCHAR2,
X_PARAM_NAME6 in VARCHAR2,
X_PARAM_VALUE6 in VARCHAR2,
X_PARAM_NAME7 in VARCHAR2,
X_PARAM_VALUE7 in VARCHAR2,
X_PARAM_NAME8 in VARCHAR2,
X_PARAM_VALUE8 in VARCHAR2,
X_PARAM_NAME9 in VARCHAR2,
X_PARAM_VALUE9 in VARCHAR2,
X_PARAM_NAME10 in VARCHAR2,
X_PARAM_VALUE10 in VARCHAR2,
X_CREATED_BY in NUMBER,
X_CREATION_DATE in DATE,
X_LAST_UPDATE_DATE in DATE,
X_LAST_UPDATED_BY in NUMBER,
X_LAST_UPDATE_LOGIN in NUMBER
) is
L_LOCK_HANDLE varchar2(500);
SELECT ROWID
FROM HR_KI_TOPIC_INTEGRATIONS
WHERE topic_integrations_id = x_topic_integrations_id;
select HR_KI_TOPIC_INTEGRATIONS_S.NEXTVAL into x_topic_integrations_id
from sys.dual;
insert into HR_KI_TOPIC_INTEGRATIONS (
TOPIC_INTEGRATIONS_ID,
TOPIC_ID,
INTEGRATION_ID,
PARAM_NAME1,
PARAM_VALUE1,
PARAM_NAME2,
PARAM_VALUE2,
PARAM_NAME3,
PARAM_VALUE3,
PARAM_NAME4,
PARAM_VALUE4,
PARAM_NAME5,
PARAM_VALUE5,
PARAM_NAME6,
PARAM_VALUE6,
PARAM_NAME7,
PARAM_VALUE7,
PARAM_NAME8,
PARAM_VALUE8,
PARAM_NAME9,
PARAM_VALUE9,
PARAM_NAME10,
PARAM_VALUE10,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
OBJECT_VERSION_NUMBER
) values (
X_TOPIC_INTEGRATIONS_ID,
X_TOPIC_ID,
X_INTEGRATION_ID,
X_PARAM_NAME1,
X_PARAM_VALUE1,
X_PARAM_NAME2,
X_PARAM_VALUE2,
X_PARAM_NAME3,
X_PARAM_VALUE3,
X_PARAM_NAME4,
X_PARAM_VALUE4,
X_PARAM_NAME5,
X_PARAM_VALUE5,
X_PARAM_NAME6,
X_PARAM_VALUE6,
X_PARAM_NAME7,
X_PARAM_VALUE7,
X_PARAM_NAME8,
X_PARAM_VALUE8,
X_PARAM_NAME9,
X_PARAM_VALUE9,
X_PARAM_NAME10,
X_PARAM_VALUE10,
X_CREATION_DATE,
X_CREATED_BY,
X_LAST_UPDATE_DATE,
X_LAST_UPDATED_BY,
X_LAST_UPDATE_LOGIN,
1
);
'HR_KI_TOPIC_INTEGRATIONS.insert_row');
end INSERT_ROW;
procedure UPDATE_ROW
(X_TOPIC_INTEGRATIONS_ID in NUMBER,
X_TOPIC_ID in NUMBER,
X_INTEGRATION_ID in NUMBER,
X_PARAM_NAME1 in VARCHAR2,
X_PARAM_VALUE1 in VARCHAR2,
X_PARAM_NAME2 in VARCHAR2,
X_PARAM_VALUE2 in VARCHAR2,
X_PARAM_NAME3 in VARCHAR2,
X_PARAM_VALUE3 in VARCHAR2,
X_PARAM_NAME4 in VARCHAR2,
X_PARAM_VALUE4 in VARCHAR2,
X_PARAM_NAME5 in VARCHAR2,
X_PARAM_VALUE5 in VARCHAR2,
X_PARAM_NAME6 in VARCHAR2,
X_PARAM_VALUE6 in VARCHAR2,
X_PARAM_NAME7 in VARCHAR2,
X_PARAM_VALUE7 in VARCHAR2,
X_PARAM_NAME8 in VARCHAR2,
X_PARAM_VALUE8 in VARCHAR2,
X_PARAM_NAME9 in VARCHAR2,
X_PARAM_VALUE9 in VARCHAR2,
X_PARAM_NAME10 in VARCHAR2,
X_PARAM_VALUE10 in VARCHAR2,
X_CREATED_BY in NUMBER,
X_CREATION_DATE in DATE,
X_LAST_UPDATE_DATE in DATE,
X_LAST_UPDATED_BY in NUMBER,
X_LAST_UPDATE_LOGIN in NUMBER,
X_OBJECT_VERSION_NUMBER in NUMBER
) as
L_LOCK_HANDLE varchar2(500);
UPDATE HR_KI_TOPIC_INTEGRATIONS TIS
SET tis.topic_id = X_TOPIC_ID
,tis.integration_id = X_INTEGRATION_ID
,tis.PARAM_NAME1 = X_PARAM_NAME1
,tis.PARAM_VALUE1 = X_PARAM_VALUE1
,tis.PARAM_NAME2 = X_PARAM_NAME2
,tis.PARAM_VALUE2 = X_PARAM_VALUE2
,tis.PARAM_NAME3 = X_PARAM_NAME3
,tis.PARAM_VALUE3 = X_PARAM_VALUE3
,tis.PARAM_NAME4 = X_PARAM_NAME4
,tis.PARAM_VALUE4 = X_PARAM_VALUE4
,tis.PARAM_NAME5 = X_PARAM_NAME5
,tis.PARAM_VALUE5 = X_PARAM_VALUE5
,tis.PARAM_NAME6 = X_PARAM_NAME6
,tis.PARAM_VALUE6 = X_PARAM_VALUE6
,tis.PARAM_NAME7 = X_PARAM_NAME7
,tis.PARAM_VALUE7 = X_PARAM_VALUE7
,tis.PARAM_NAME8 = X_PARAM_NAME8
,tis.PARAM_VALUE8 = X_PARAM_VALUE8
,tis.PARAM_NAME9 = X_PARAM_NAME9
,tis.PARAM_VALUE9 = X_PARAM_VALUE9
,tis.PARAM_NAME10 = X_PARAM_NAME10
,tis.PARAM_VALUE10 = X_PARAM_VALUE10
,tis.CREATED_BY = X_CREATED_BY
,tis.CREATION_DATE = X_CREATION_DATE
,tis.LAST_UPDATE_DATE = X_LAST_UPDATE_DATE
,tis.LAST_UPDATED_BY = X_LAST_UPDATED_BY
,tis.LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
,tis.OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER
WHERE tis.TOPIC_INTEGRATIONS_ID = X_TOPIC_INTEGRATIONS_ID;
end UPDATE_ROW;
select topic_id
from HR_KI_TOPICS
where upper(topic_key) = upper(X_TOPIC_KEY);
select integration_id
from HR_KI_INTEGRATIONS
where upper(integration_key) = upper(X_INTEGRATION_KEY);
X_LAST_UPDATE_DATE in VARCHAR2,
X_CUSTOM_MODE in VARCHAR2,
X_OWNER in VARCHAR2
)
is
l_proc VARCHAR2(31) := 'HR_KI_TIS_LOAD_API.LOAD_ROW';
l_last_update_date HR_KI_TOPIC_INTEGRATIONS.last_update_date%TYPE := SYSDATE;
l_last_updated_by HR_KI_TOPIC_INTEGRATIONS.last_updated_by%TYPE := 0;
l_last_update_login HR_KI_TOPIC_INTEGRATIONS.last_update_login%TYPE := 0;
db_ludate date; -- entity update date in db
select tpi.topic_integrations_id,
nvl(tpi.object_version_number,1)
from hr_ki_topic_integrations tpi,
hr_ki_topics top,
hr_ki_integrations int
where tpi.topic_id = top.topic_id
and tpi.integration_id = int.integration_id
and top.topic_key = X_TOPIC_KEY
and int.integration_key = X_INTEGRATION_KEY;
X_CURRENT_LAST_UPDATE_DATE HR_KI_TOPIC_INTEGRATIONS.last_update_date%TYPE;
l_last_updated_by := fnd_load_util.owner_id(X_OWNER);
l_last_update_date := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD hh24:mi:ss'), sysdate);
INSERT_ROW
(X_ROWID => l_rowid
,X_TOPIC_INTEGRATIONS_ID => l_topic_integrations_id
,X_TOPIC_ID => l_topic_id
,X_INTEGRATION_ID => l_integration_id
,X_PARAM_NAME1 => X_PARAM_NAME1
,X_PARAM_VALUE1 => X_PARAM_VALUE1
,X_PARAM_NAME2 => X_PARAM_NAME2
,X_PARAM_VALUE2 => X_PARAM_VALUE2
,X_PARAM_NAME3 => X_PARAM_NAME3
,X_PARAM_VALUE3 => X_PARAM_VALUE3
,X_PARAM_NAME4 => X_PARAM_NAME4
,X_PARAM_VALUE4 => X_PARAM_VALUE4
,X_PARAM_NAME5 => X_PARAM_NAME5
,X_PARAM_VALUE5 => X_PARAM_VALUE5
,X_PARAM_NAME6 => X_PARAM_NAME6
,X_PARAM_VALUE6 => X_PARAM_VALUE6
,X_PARAM_NAME7 => X_PARAM_NAME7
,X_PARAM_VALUE7 => X_PARAM_VALUE7
,X_PARAM_NAME8 => X_PARAM_NAME8
,X_PARAM_VALUE8 => X_PARAM_VALUE8
,X_PARAM_NAME9 => X_PARAM_NAME9
,X_PARAM_VALUE9 => X_PARAM_VALUE9
,X_PARAM_NAME10 => X_PARAM_NAME10
,X_PARAM_VALUE10 => X_PARAM_VALUE10
,X_CREATED_BY => l_created_by
,X_CREATION_DATE => l_creation_date
,X_LAST_UPDATE_DATE => l_last_update_date
,X_LAST_UPDATED_BY => l_last_updated_by
,X_LAST_UPDATE_LOGIN => l_last_update_login
);
SELECT tis.LAST_UPDATED_BY,
tis.LAST_UPDATE_DATE
INTO X_CURRENT_OWNER,
X_CURRENT_LAST_UPDATE_DATE
FROM HR_KI_TOPIC_INTEGRATIONS tis
WHERE tis.topic_id = l_topic_id
AND tis.integration_id = l_integration_id;
(P_FILE_ID => l_last_updated_by
,P_FILE_LUD => l_last_update_date
,P_DB_ID => X_CURRENT_OWNER
,P_DB_LUD => to_date(X_CURRENT_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS')
,P_CUSTOM_MODE => X_CUSTOM_MODE
)
) then
UPDATE_ROW
(X_TOPIC_INTEGRATIONS_ID => l_topic_integrations_id
,X_TOPIC_ID => l_topic_id
,X_INTEGRATION_ID => l_integration_id
,X_PARAM_NAME1 => X_PARAM_NAME1
,X_PARAM_VALUE1 => X_PARAM_VALUE1
,X_PARAM_NAME2 => X_PARAM_NAME2
,X_PARAM_VALUE2 => X_PARAM_VALUE2
,X_PARAM_NAME3 => X_PARAM_NAME3
,X_PARAM_VALUE3 => X_PARAM_VALUE3
,X_PARAM_NAME4 => X_PARAM_NAME4
,X_PARAM_VALUE4 => X_PARAM_VALUE4
,X_PARAM_NAME5 => X_PARAM_NAME5
,X_PARAM_VALUE5 => X_PARAM_VALUE5
,X_PARAM_NAME6 => X_PARAM_NAME6
,X_PARAM_VALUE6 => X_PARAM_VALUE6
,X_PARAM_NAME7 => X_PARAM_NAME7
,X_PARAM_VALUE7 => X_PARAM_VALUE7
,X_PARAM_NAME8 => X_PARAM_NAME8
,X_PARAM_VALUE8 => X_PARAM_VALUE8
,X_PARAM_NAME9 => X_PARAM_NAME9
,X_PARAM_VALUE9 => X_PARAM_VALUE9
,X_PARAM_NAME10 => X_PARAM_NAME10
,X_PARAM_VALUE10 => X_PARAM_VALUE10
,X_CREATED_BY => l_created_by
,X_CREATION_DATE => l_creation_date
,X_LAST_UPDATE_DATE => l_last_update_date
,X_LAST_UPDATED_BY => l_last_updated_by
,X_LAST_UPDATE_LOGIN => l_last_update_login
,X_OBJECT_VERSION_NUMBER => l_object_version_number + 1
);