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.PER_CNL_RKD SQL Statements

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

Line: 5


procedure AFTER_DELETE
(P_LOCATION_ID in NUMBER
,P_CONFIGURATION_CODE_O in VARCHAR2
,P_CONFIGURATION_CONTEXT_O in VARCHAR2
,P_LOCATION_CODE_O in VARCHAR2
,P_DESCRIPTION_O in VARCHAR2
,P_STYLE_O in VARCHAR2
,P_ADDRESS_LINE_1_O in VARCHAR2
,P_ADDRESS_LINE_2_O in VARCHAR2
,P_ADDRESS_LINE_3_O in VARCHAR2
,P_TOWN_OR_CITY_O in VARCHAR2
,P_COUNTRY_O in VARCHAR2
,P_POSTAL_CODE_O in VARCHAR2
,P_REGION_1_O in VARCHAR2
,P_REGION_2_O in VARCHAR2
,P_REGION_3_O in VARCHAR2
,P_TELEPHONE_NUMBER_1_O in VARCHAR2
,P_TELEPHONE_NUMBER_2_O in VARCHAR2
,P_TELEPHONE_NUMBER_3_O in VARCHAR2
,P_LOC_INFORMATION13_O in VARCHAR2
,P_LOC_INFORMATION14_O in VARCHAR2
,P_LOC_INFORMATION15_O in VARCHAR2
,P_LOC_INFORMATION16_O in VARCHAR2
,P_LOC_INFORMATION17_O in VARCHAR2
,P_LOC_INFORMATION18_O in VARCHAR2
,P_LOC_INFORMATION19_O in VARCHAR2
,P_LOC_INFORMATION20_O in VARCHAR2
,P_OBJECT_VERSION_NUMBER_O in NUMBER
)is
begin
hr_utility.set_location('Entering: PER_CNL_RKD.AFTER_DELETE', 10);

Line: 36


hr_utility.set_location(' Leaving: PER_CNL_RKD.AFTER_DELETE', 20);

Line: 37


end AFTER_DELETE;