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

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

Line: 5


procedure UPDATE_RECRUITMENT_ACTIVITY_A
(P_RECRUITMENT_ACTIVITY_ID in NUMBER
,P_AUTHORISING_PERSON_ID in NUMBER
,P_RUN_BY_ORGANIZATION_ID in NUMBER
,P_INTERNAL_CONTACT_PERSON_ID in NUMBER
,P_PARENT_RECRUITMENT_ACTIVITY in NUMBER
,P_CURRENCY_CODE in VARCHAR2
,P_DATE_START in DATE
,P_NAME in VARCHAR2
,P_ACTUAL_COST in VARCHAR2
,P_COMMENTS in LONG
,P_CONTACT_TELEPHONE_NUMBER in VARCHAR2
,P_DATE_CLOSING in DATE
,P_DATE_END in DATE
,P_EXTERNAL_CONTACT in VARCHAR2
,P_PLANNED_COST in VARCHAR2
,P_RECRUITING_SITE_ID in NUMBER
,P_RECRUITING_SITE_RESPONSE in VARCHAR2
,P_LAST_POSTED_DATE in DATE
,P_TYPE in VARCHAR2
,P_ATTRIBUTE_CATEGORY in VARCHAR2
,P_ATTRIBUTE1 in VARCHAR2
,P_ATTRIBUTE2 in VARCHAR2
,P_ATTRIBUTE3 in VARCHAR2
,P_ATTRIBUTE4 in VARCHAR2
,P_ATTRIBUTE5 in VARCHAR2
,P_ATTRIBUTE6 in VARCHAR2
,P_ATTRIBUTE7 in VARCHAR2
,P_ATTRIBUTE8 in VARCHAR2
,P_ATTRIBUTE9 in VARCHAR2
,P_ATTRIBUTE10 in VARCHAR2
,P_ATTRIBUTE11 in VARCHAR2
,P_ATTRIBUTE12 in VARCHAR2
,P_ATTRIBUTE13 in VARCHAR2
,P_ATTRIBUTE14 in VARCHAR2
,P_ATTRIBUTE15 in VARCHAR2
,P_ATTRIBUTE16 in VARCHAR2
,P_ATTRIBUTE17 in VARCHAR2
,P_ATTRIBUTE18 in VARCHAR2
,P_ATTRIBUTE19 in VARCHAR2
,P_ATTRIBUTE20 in VARCHAR2
,P_POSTING_CONTENT_ID in NUMBER
,P_STATUS in VARCHAR2
,P_OBJECT_VERSION_NUMBER in NUMBER
)is
l_commit_unit_number number;

Line: 53


hr_utility.set_location('Entering: PER_RECRUITMENT_ACTIVITY_BK2.UPDATE_RECRUITMENT_ACTIVITY_A', 10);

Line: 56


per_recruitment_activity_be2.UPDATE_RECRUITMENT_ACTIVITY_A
(P_RECRUITMENT_ACTIVITY_ID => P_RECRUITMENT_ACTIVITY_ID
,P_AUTHORISING_PERSON_ID => P_AUTHORISING_PERSON_ID
,P_RUN_BY_ORGANIZATION_ID => P_RUN_BY_ORGANIZATION_ID
,P_INTERNAL_CONTACT_PERSON_ID => P_INTERNAL_CONTACT_PERSON_ID
,P_PARENT_RECRUITMENT_ACTIVITY => P_PARENT_RECRUITMENT_ACTIVITY
,P_CURRENCY_CODE => P_CURRENCY_CODE
,P_DATE_START => P_DATE_START
,P_NAME => P_NAME
,P_ACTUAL_COST => P_ACTUAL_COST
,P_COMMENTS => P_COMMENTS
,P_CONTACT_TELEPHONE_NUMBER => P_CONTACT_TELEPHONE_NUMBER
,P_DATE_CLOSING => P_DATE_CLOSING
,P_DATE_END => P_DATE_END
,P_EXTERNAL_CONTACT => P_EXTERNAL_CONTACT
,P_PLANNED_COST => P_PLANNED_COST
,P_RECRUITING_SITE_ID => P_RECRUITING_SITE_ID
,P_RECRUITING_SITE_RESPONSE => P_RECRUITING_SITE_RESPONSE
,P_LAST_POSTED_DATE => P_LAST_POSTED_DATE
,P_TYPE => P_TYPE
,P_ATTRIBUTE_CATEGORY => P_ATTRIBUTE_CATEGORY
,P_ATTRIBUTE1 => P_ATTRIBUTE1
,P_ATTRIBUTE2 => P_ATTRIBUTE2
,P_ATTRIBUTE3 => P_ATTRIBUTE3
,P_ATTRIBUTE4 => P_ATTRIBUTE4
,P_ATTRIBUTE5 => P_ATTRIBUTE5
,P_ATTRIBUTE6 => P_ATTRIBUTE6
,P_ATTRIBUTE7 => P_ATTRIBUTE7
,P_ATTRIBUTE8 => P_ATTRIBUTE8
,P_ATTRIBUTE9 => P_ATTRIBUTE9
,P_ATTRIBUTE10 => P_ATTRIBUTE10
,P_ATTRIBUTE11 => P_ATTRIBUTE11
,P_ATTRIBUTE12 => P_ATTRIBUTE12
,P_ATTRIBUTE13 => P_ATTRIBUTE13
,P_ATTRIBUTE14 => P_ATTRIBUTE14
,P_ATTRIBUTE15 => P_ATTRIBUTE15
,P_ATTRIBUTE16 => P_ATTRIBUTE16
,P_ATTRIBUTE17 => P_ATTRIBUTE17
,P_ATTRIBUTE18 => P_ATTRIBUTE18
,P_ATTRIBUTE19 => P_ATTRIBUTE19
,P_ATTRIBUTE20 => P_ATTRIBUTE20
,P_POSTING_CONTENT_ID => P_POSTING_CONTENT_ID
,P_STATUS => P_STATUS
,P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
);

Line: 103


hr_api.validate_commit_unit(l_commit_unit_number, 'UPDATE_RECRUITMENT_ACTIVITY', 'AP');

Line: 104


hr_utility.set_location(' Leaving: PER_RECRUITMENT_ACTIVITY_BK2.UPDATE_RECRUITMENT_ACTIVITY_A', 20);

Line: 105


end UPDATE_RECRUITMENT_ACTIVITY_A;

Line: 106


procedure UPDATE_RECRUITMENT_ACTIVITY_B
(P_RECRUITMENT_ACTIVITY_ID in NUMBER
,P_AUTHORISING_PERSON_ID in NUMBER
,P_RUN_BY_ORGANIZATION_ID in NUMBER
,P_INTERNAL_CONTACT_PERSON_ID in NUMBER
,P_PARENT_RECRUITMENT_ACTIVITY in NUMBER
,P_CURRENCY_CODE in VARCHAR2
,P_DATE_START in DATE
,P_NAME in VARCHAR2
,P_ACTUAL_COST in VARCHAR2
,P_COMMENTS in LONG
,P_CONTACT_TELEPHONE_NUMBER in VARCHAR2
,P_DATE_CLOSING in DATE
,P_DATE_END in DATE
,P_EXTERNAL_CONTACT in VARCHAR2
,P_PLANNED_COST in VARCHAR2
,P_RECRUITING_SITE_ID in NUMBER
,P_RECRUITING_SITE_RESPONSE in VARCHAR2
,P_LAST_POSTED_DATE in DATE
,P_TYPE in VARCHAR2
,P_ATTRIBUTE_CATEGORY in VARCHAR2
,P_ATTRIBUTE1 in VARCHAR2
,P_ATTRIBUTE2 in VARCHAR2
,P_ATTRIBUTE3 in VARCHAR2
,P_ATTRIBUTE4 in VARCHAR2
,P_ATTRIBUTE5 in VARCHAR2
,P_ATTRIBUTE6 in VARCHAR2
,P_ATTRIBUTE7 in VARCHAR2
,P_ATTRIBUTE8 in VARCHAR2
,P_ATTRIBUTE9 in VARCHAR2
,P_ATTRIBUTE10 in VARCHAR2
,P_ATTRIBUTE11 in VARCHAR2
,P_ATTRIBUTE12 in VARCHAR2
,P_ATTRIBUTE13 in VARCHAR2
,P_ATTRIBUTE14 in VARCHAR2
,P_ATTRIBUTE15 in VARCHAR2
,P_ATTRIBUTE16 in VARCHAR2
,P_ATTRIBUTE17 in VARCHAR2
,P_ATTRIBUTE18 in VARCHAR2
,P_ATTRIBUTE19 in VARCHAR2
,P_ATTRIBUTE20 in VARCHAR2
,P_POSTING_CONTENT_ID in NUMBER
,P_STATUS in VARCHAR2
,P_OBJECT_VERSION_NUMBER in NUMBER
)is
begin
hr_utility.set_location('Entering: PER_RECRUITMENT_ACTIVITY_BK2.UPDATE_RECRUITMENT_ACTIVITY_B', 10);

Line: 153


hr_utility.set_location(' Leaving: PER_RECRUITMENT_ACTIVITY_BK2.UPDATE_RECRUITMENT_ACTIVITY_B', 20);

Line: 154


end UPDATE_RECRUITMENT_ACTIVITY_B;