eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_KI_TOPIC_INTEGRATIONS_BK2 SQL Statements

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

Line: 5


procedure UPDATE_TOPIC_INTEGRATION_A
(P_TOPIC_ID in NUMBER
,P_INTEGRATION_ID in NUMBER
,P_PARAM_NAME1 in VARCHAR2
,P_PARAM_VALUE1 in VARCHAR2
,P_PARAM_NAME2 in VARCHAR2
,P_PARAM_VALUE2 in VARCHAR2
,P_PARAM_NAME3 in VARCHAR2
,P_PARAM_VALUE3 in VARCHAR2
,P_PARAM_NAME4 in VARCHAR2
,P_PARAM_VALUE4 in VARCHAR2
,P_PARAM_NAME5 in VARCHAR2
,P_PARAM_VALUE5 in VARCHAR2
,P_PARAM_NAME6 in VARCHAR2
,P_PARAM_VALUE6 in VARCHAR2
,P_PARAM_NAME7 in VARCHAR2
,P_PARAM_VALUE7 in VARCHAR2
,P_PARAM_NAME8 in VARCHAR2
,P_PARAM_VALUE8 in VARCHAR2
,P_PARAM_NAME9 in VARCHAR2
,P_PARAM_VALUE9 in VARCHAR2
,P_PARAM_NAME10 in VARCHAR2
,P_PARAM_VALUE10 in VARCHAR2
,P_TOPIC_INTEGRATIONS_ID in NUMBER
,P_OBJECT_VERSION_NUMBER in NUMBER
)is
begin
hr_utility.set_location('Entering: HR_KI_TOPIC_INTEGRATIONS_BK2.UPDATE_TOPIC_INTEGRATION_A', 10);

Line: 33


hr_utility.set_location(' Leaving: HR_KI_TOPIC_INTEGRATIONS_BK2.UPDATE_TOPIC_INTEGRATION_A', 20);

Line: 34


end UPDATE_TOPIC_INTEGRATION_A;

Line: 35


procedure UPDATE_TOPIC_INTEGRATION_B
(P_TOPIC_ID in NUMBER
,P_INTEGRATION_ID in NUMBER
,P_PARAM_NAME1 in VARCHAR2
,P_PARAM_VALUE1 in VARCHAR2
,P_PARAM_NAME2 in VARCHAR2
,P_PARAM_VALUE2 in VARCHAR2
,P_PARAM_NAME3 in VARCHAR2
,P_PARAM_VALUE3 in VARCHAR2
,P_PARAM_NAME4 in VARCHAR2
,P_PARAM_VALUE4 in VARCHAR2
,P_PARAM_NAME5 in VARCHAR2
,P_PARAM_VALUE5 in VARCHAR2
,P_PARAM_NAME6 in VARCHAR2
,P_PARAM_VALUE6 in VARCHAR2
,P_PARAM_NAME7 in VARCHAR2
,P_PARAM_VALUE7 in VARCHAR2
,P_PARAM_NAME8 in VARCHAR2
,P_PARAM_VALUE8 in VARCHAR2
,P_PARAM_NAME9 in VARCHAR2
,P_PARAM_VALUE9 in VARCHAR2
,P_PARAM_NAME10 in VARCHAR2
,P_PARAM_VALUE10 in VARCHAR2
,P_TOPIC_INTEGRATIONS_ID in NUMBER
,P_OBJECT_VERSION_NUMBER in NUMBER
)is
begin
hr_utility.set_location('Entering: HR_KI_TOPIC_INTEGRATIONS_BK2.UPDATE_TOPIC_INTEGRATION_B', 10);

Line: 63


hr_utility.set_location(' Leaving: HR_KI_TOPIC_INTEGRATIONS_BK2.UPDATE_TOPIC_INTEGRATION_B', 20);

Line: 64


end UPDATE_TOPIC_INTEGRATION_B;