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

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

Line: 5


procedure AFTER_INSERT
(P_CONTACT_RELATIONSHIP_ID in NUMBER
,P_BUSINESS_GROUP_ID in NUMBER
,P_PERSON_ID in NUMBER
,P_CONTACT_PERSON_ID in NUMBER
,P_CONTACT_TYPE in VARCHAR2
,P_COMMENTS in CLOB
,P_PRIMARY_CONTACT_FLAG 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_DATE_START in DATE
,P_START_LIFE_REASON_ID in NUMBER
,P_DATE_END in DATE
,P_END_LIFE_REASON_ID in NUMBER
,P_RLTD_PER_RSDS_W_DSGNTR_FLAG in VARCHAR2
,P_PERSONAL_FLAG in VARCHAR2
,P_SEQUENCE_NUMBER in NUMBER
,P_CONT_ATTRIBUTE_CATEGORY in VARCHAR2
,P_CONT_ATTRIBUTE1 in VARCHAR2
,P_CONT_ATTRIBUTE2 in VARCHAR2
,P_CONT_ATTRIBUTE3 in VARCHAR2
,P_CONT_ATTRIBUTE4 in VARCHAR2
,P_CONT_ATTRIBUTE5 in VARCHAR2
,P_CONT_ATTRIBUTE6 in VARCHAR2
,P_CONT_ATTRIBUTE7 in VARCHAR2
,P_CONT_ATTRIBUTE8 in VARCHAR2
,P_CONT_ATTRIBUTE9 in VARCHAR2
,P_CONT_ATTRIBUTE10 in VARCHAR2
,P_CONT_ATTRIBUTE11 in VARCHAR2
,P_CONT_ATTRIBUTE12 in VARCHAR2
,P_CONT_ATTRIBUTE13 in VARCHAR2
,P_CONT_ATTRIBUTE14 in VARCHAR2
,P_CONT_ATTRIBUTE15 in VARCHAR2
,P_CONT_ATTRIBUTE16 in VARCHAR2
,P_CONT_ATTRIBUTE17 in VARCHAR2
,P_CONT_ATTRIBUTE18 in VARCHAR2
,P_CONT_ATTRIBUTE19 in VARCHAR2
,P_CONT_ATTRIBUTE20 in VARCHAR2
,P_CONT_INFORMATION_CATEGORY in VARCHAR2
,P_CONT_INFORMATION1 in VARCHAR2
,P_CONT_INFORMATION2 in VARCHAR2
,P_CONT_INFORMATION3 in VARCHAR2
,P_CONT_INFORMATION4 in VARCHAR2
,P_CONT_INFORMATION5 in VARCHAR2
,P_CONT_INFORMATION6 in VARCHAR2
,P_CONT_INFORMATION7 in VARCHAR2
,P_CONT_INFORMATION8 in VARCHAR2
,P_CONT_INFORMATION9 in VARCHAR2
,P_CONT_INFORMATION10 in VARCHAR2
,P_CONT_INFORMATION11 in VARCHAR2
,P_CONT_INFORMATION12 in VARCHAR2
,P_CONT_INFORMATION13 in VARCHAR2
,P_CONT_INFORMATION14 in VARCHAR2
,P_CONT_INFORMATION15 in VARCHAR2
,P_CONT_INFORMATION16 in VARCHAR2
,P_CONT_INFORMATION17 in VARCHAR2
,P_CONT_INFORMATION18 in VARCHAR2
,P_CONT_INFORMATION19 in VARCHAR2
,P_CONT_INFORMATION20 in VARCHAR2
,P_THIRD_PARTY_PAY_FLAG in VARCHAR2
,P_BONDHOLDER_FLAG in VARCHAR2
,P_DEPENDENT_FLAG in VARCHAR2
,P_BENEFICIARY_FLAG in VARCHAR2
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_EFFECTIVE_DATE in DATE
)is
l_commit_unit_number number;

Line: 76


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

Line: 99


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

Line: 100


end AFTER_INSERT;