APPS.PER_CNL_RKU SQL Statements

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

Line: 5

procedure AFTER_UPDATE
(P_EFFECTIVE_DATE in DATE
,P_CONFIGURATION_CODE in VARCHAR2
,P_CONFIGURATION_CONTEXT in VARCHAR2
,P_LOCATION_ID in NUMBER
,P_LOCATION_CODE in VARCHAR2
,P_DESCRIPTION in VARCHAR2
,P_STYLE in VARCHAR2
,P_ADDRESS_LINE_1 in VARCHAR2
,P_ADDRESS_LINE_2 in VARCHAR2
,P_ADDRESS_LINE_3 in VARCHAR2
,P_TOWN_OR_CITY in VARCHAR2
,P_COUNTRY in VARCHAR2
,P_POSTAL_CODE in VARCHAR2
,P_REGION_1 in VARCHAR2
,P_REGION_2 in VARCHAR2
,P_REGION_3 in VARCHAR2
,P_TELEPHONE_NUMBER_1 in VARCHAR2
,P_TELEPHONE_NUMBER_2 in VARCHAR2
,P_TELEPHONE_NUMBER_3 in VARCHAR2
,P_LOC_INFORMATION13 in VARCHAR2
,P_LOC_INFORMATION14 in VARCHAR2
,P_LOC_INFORMATION15 in VARCHAR2
,P_LOC_INFORMATION16 in VARCHAR2
,P_LOC_INFORMATION17 in VARCHAR2
,P_LOC_INFORMATION18 in VARCHAR2
,P_LOC_INFORMATION19 in VARCHAR2
,P_LOC_INFORMATION20 in VARCHAR2
,P_OBJECT_VERSION_NUMBER 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_RKU.AFTER_UPDATE', 10);

Line: 63

hr_utility.set_location(' Leaving: PER_CNL_RKU.AFTER_UPDATE', 20);

Line: 64

end AFTER_UPDATE;