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_ADD_RKI SQL Statements

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

Line: 5


procedure AFTER_INSERT
(P_ADDRESS_ID in NUMBER
,P_BUSINESS_GROUP_ID in NUMBER
,P_PERSON_ID in NUMBER
,P_DATE_FROM in DATE
,P_PRIMARY_FLAG in VARCHAR2
,P_STYLE in VARCHAR2
,P_ADDRESS_LINE1 in VARCHAR2
,P_ADDRESS_LINE2 in VARCHAR2
,P_ADDRESS_LINE3 in VARCHAR2
,P_ADDRESS_TYPE in VARCHAR2
,P_COMMENTS in CLOB
,P_COUNTRY in VARCHAR2
,P_DATE_TO in DATE
,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_TOWN_OR_CITY in VARCHAR2
,P_REQUEST_ID in NUMBER
,P_PROGRAM_APPLICATION_ID in NUMBER
,P_PROGRAM_ID in NUMBER
,P_PROGRAM_UPDATE_DATE in DATE
,P_ADDR_ATTRIBUTE_CATEGORY in VARCHAR2
,P_ADDR_ATTRIBUTE1 in VARCHAR2
,P_ADDR_ATTRIBUTE2 in VARCHAR2
,P_ADDR_ATTRIBUTE3 in VARCHAR2
,P_ADDR_ATTRIBUTE4 in VARCHAR2
,P_ADDR_ATTRIBUTE5 in VARCHAR2
,P_ADDR_ATTRIBUTE6 in VARCHAR2
,P_ADDR_ATTRIBUTE7 in VARCHAR2
,P_ADDR_ATTRIBUTE8 in VARCHAR2
,P_ADDR_ATTRIBUTE9 in VARCHAR2
,P_ADDR_ATTRIBUTE10 in VARCHAR2
,P_ADDR_ATTRIBUTE11 in VARCHAR2
,P_ADDR_ATTRIBUTE12 in VARCHAR2
,P_ADDR_ATTRIBUTE13 in VARCHAR2
,P_ADDR_ATTRIBUTE14 in VARCHAR2
,P_ADDR_ATTRIBUTE15 in VARCHAR2
,P_ADDR_ATTRIBUTE16 in VARCHAR2
,P_ADDR_ATTRIBUTE17 in VARCHAR2
,P_ADDR_ATTRIBUTE18 in VARCHAR2
,P_ADDR_ATTRIBUTE19 in VARCHAR2
,P_ADDR_ATTRIBUTE20 in VARCHAR2
,P_ADD_INFORMATION13 in VARCHAR2
,P_ADD_INFORMATION14 in VARCHAR2
,P_ADD_INFORMATION15 in VARCHAR2
,P_ADD_INFORMATION16 in VARCHAR2
,P_ADD_INFORMATION17 in VARCHAR2
,P_ADD_INFORMATION18 in VARCHAR2
,P_ADD_INFORMATION19 in VARCHAR2
,P_ADD_INFORMATION20 in VARCHAR2
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_EFFECTIVE_DATE in DATE
,P_VALIDATE_COUNTY in BOOLEAN
,P_PARTY_ID in NUMBER
)is
l_commit_unit_number number;

Line: 68


hr_utility.set_location('Entering: PER_ADD_RKI.AFTER_INSERT', 10);

Line: 117


PER_KR_ADDRESS_UPDATE_HOOK_PKG.UPDATE_ADDRESS_LINE1_AI
(P_ADDRESS_ID => P_ADDRESS_ID
,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
,P_PERSON_ID => P_PERSON_ID
,P_STYLE => P_STYLE
,P_ADD_INFORMATION17 => P_ADD_INFORMATION17
);

Line: 127


hr_utility.set_location(' Leaving: PER_ADD_RKI.AFTER_INSERT', 20);

Line: 128


end AFTER_INSERT;