[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 1
FROM per_recruitment_activities rec
WHERE upper(rec.NAME) = upper(p_Name)
AND rec.business_group_id + 0 = P_business_group_id
AND (P_rowid <> rec.rowid
or P_rowid is NULL);
SELECT asg.recruitment_activity_id
FROM per_assignments_F asg
WHERE asg.recruitment_activity_id = P_recruitment_activity_id
AND asg.business_group_id + 0 = P_Business_group_id;
SELECT acts.recruitment_activity_id
FROM per_recruitment_activities acts
WHERE acts.parent_recruitment_activity_id = P_recruitment_activity_id
AND acts.business_group_id + 0 = P_Business_group_id;
SELECT organization_id
FROM hr_organization_units
WHERE organization_id = P_org_run_by_Id
AND business_group_id + 0 = P_Business_Group_id
AND date_from <= P_date_start
AND ((date_to is null) or
(date_to is not null and date_to >= P_date_start));
SELECT p.person_id
FROM per_people_f p
WHERE p.person_id = P_authorising_person_id
AND p.current_employee_flag = 'Y'
AND (p.business_group_id = P_Business_Group_id OR
nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
AND P_date_start
between p.effective_start_date and p.effective_end_date;
SELECT p.person_id
FROM per_people_f p
WHERE p.person_id = P_internal_contact_person_id
AND p.current_employee_flag = 'Y'
AND p.employee_number is not null
AND (nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N') = 'Y'
OR p.business_group_id = P_Business_Group_id)
AND P_date_start
between p.effective_start_date and p.effective_end_date;
SELECT recruitment_activity_id
FROM per_recruitment_activities
WHERE recruitment_activity_id = P_parent_rec_id
AND business_group_id + 0 = P_Business_Group_id
AND date_start <= P_date_start
AND ((date_end is null) or
(date_end is not null and date_end >= P_date_start));
SELECT raf.vacancy_id
FROM per_vacancies v,
per_recruitment_activity_for raf
WHERE raf.recruitment_activity_id = P_rec_activity_id
AND v.business_group_id + 0 = P_Business_Group_id
AND raf.vacancy_id = v.vacancy_id
AND (v.date_from > P_date_start
OR (v.date_to is not null and
v.date_to < P_date_start));
SELECT 1
FROM per_recruitment_activities
WHERE parent_recruitment_activity_id = P_rec_act_id
AND business_group_id + 0 = P_Business_Group_id;
SELECT parent_recruitment_activity_id
FROM per_recruitment_activities
WHERE parent_recruitment_activity_id = P_rec_act_id
AND business_group_id + 0 = P_Business_Group_id
AND P_date_start > date_start;
SELECT 1
FROM per_recruitment_activities
WHERE parent_recruitment_activity_id = P_rec_act_id
AND business_group_id + 0 = P_Business_Group_id;
SELECT parent_recruitment_activity_id
FROM per_recruitment_activities
WHERE parent_recruitment_activity_id = P_rec_act_id
AND business_group_id + 0 = P_Business_Group_id
AND P_date_end < date_start;
SELECT currency_code
FROM per_business_groups
WHERE business_group_id = P_Business_Group_Id;
PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
X_Recruitment_Activity_Id IN OUT NOCOPY NUMBER,
X_Business_Group_Id NUMBER,
X_Authorising_Person_Id NUMBER,
X_Run_By_Organization_Id NUMBER,
X_Internal_Contact_Person_Id NUMBER,
X_Parent_Rec_Activity_Id NUMBER,
X_Currency_Code VARCHAR2,
X_Date_Start DATE,
X_Name VARCHAR2,
X_Actual_Cost VARCHAR2,
X_Comments varchar2,
X_Contact_Telephone_Number VARCHAR2,
X_Date_Closing DATE,
X_Date_End DATE,
X_External_Contact VARCHAR2,
X_Planned_Cost VARCHAR2,
X_Type VARCHAR2,
X_Attribute_Category VARCHAR2,
X_Attribute1 VARCHAR2,
X_Attribute2 VARCHAR2,
X_Attribute3 VARCHAR2,
X_Attribute4 VARCHAR2,
X_Attribute5 VARCHAR2,
X_Attribute6 VARCHAR2,
X_Attribute7 VARCHAR2,
X_Attribute8 VARCHAR2,
X_Attribute9 VARCHAR2,
X_Attribute10 VARCHAR2,
X_Attribute11 VARCHAR2,
X_Attribute12 VARCHAR2,
X_Attribute13 VARCHAR2,
X_Attribute14 VARCHAR2,
X_Attribute15 VARCHAR2,
X_Attribute16 VARCHAR2,
X_Attribute17 VARCHAR2,
X_Attribute18 VARCHAR2,
X_Attribute19 VARCHAR2,
X_Attribute20 VARCHAR2
) IS
CURSOR C IS
SELECT rowid
FROM PER_RECRUITMENT_ACTIVITIES
WHERE recruitment_activity_id = X_Recruitment_Activity_Id;
SELECT per_recruitment_activities_s.nextval
FROM sys.dual;
INSERT INTO PER_RECRUITMENT_ACTIVITIES(
recruitment_activity_id,
business_group_id,
authorising_person_id,
run_by_organization_id,
internal_contact_person_id,
parent_recruitment_activity_id,
currency_code,
date_start,
name,
actual_cost,
comments,
contact_telephone_number,
date_closing,
date_end,
external_contact,
planned_cost,
type,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute16,
attribute17,
attribute18,
attribute19,
attribute20
) VALUES (
X_Recruitment_Activity_Id,
X_Business_Group_Id,
X_Authorising_Person_Id,
X_Run_By_Organization_Id,
X_Internal_Contact_Person_Id,
X_Parent_Rec_Activity_Id,
X_Currency_Code,
X_Date_Start,
X_Name,
X_Actual_Cost,
X_Comments,
X_Contact_Telephone_Number,
X_Date_Closing,
X_Date_End,
X_External_Contact,
X_Planned_Cost,
X_Type,
X_Attribute_Category,
X_Attribute1,
X_Attribute2,
X_Attribute3,
X_Attribute4,
X_Attribute5,
X_Attribute6,
X_Attribute7,
X_Attribute8,
X_Attribute9,
X_Attribute10,
X_Attribute11,
X_Attribute12,
X_Attribute13,
X_Attribute14,
X_Attribute15,
X_Attribute16,
X_Attribute17,
X_Attribute18,
X_Attribute19,
X_Attribute20);
'per_recruitment_activity_pkg.insert_row');
END Insert_Row;
SELECT *
FROM PER_RECRUITMENT_ACTIVITIES
WHERE rowid = X_Rowid
FOR UPDATE of Recruitment_Activity_Id NOWAIT;
PROCEDURE Update_Row(X_Rowid VARCHAR2,
X_Recruitment_Activity_Id NUMBER,
X_Business_Group_Id NUMBER,
X_Authorising_Person_Id NUMBER,
X_Run_By_Organization_Id NUMBER,
X_Internal_Contact_Person_Id NUMBER,
X_Parent_Rec_Activity_Id NUMBER,
X_Currency_Code VARCHAR2,
X_Date_Start DATE,
X_Name VARCHAR2,
X_Actual_Cost VARCHAR2,
X_Comments varchar2,
X_Contact_Telephone_Number VARCHAR2,
X_Date_Closing DATE,
X_Date_End DATE,
X_External_Contact VARCHAR2,
X_Planned_Cost VARCHAR2,
X_Type VARCHAR2,
X_Attribute_Category VARCHAR2,
X_Attribute1 VARCHAR2,
X_Attribute2 VARCHAR2,
X_Attribute3 VARCHAR2,
X_Attribute4 VARCHAR2,
X_Attribute5 VARCHAR2,
X_Attribute6 VARCHAR2,
X_Attribute7 VARCHAR2,
X_Attribute8 VARCHAR2,
X_Attribute9 VARCHAR2,
X_Attribute10 VARCHAR2,
X_Attribute11 VARCHAR2,
X_Attribute12 VARCHAR2,
X_Attribute13 VARCHAR2,
X_Attribute14 VARCHAR2,
X_Attribute15 VARCHAR2,
X_Attribute16 VARCHAR2,
X_Attribute17 VARCHAR2,
X_Attribute18 VARCHAR2,
X_Attribute19 VARCHAR2,
X_Attribute20 VARCHAR2
) IS
BEGIN
UPDATE PER_RECRUITMENT_ACTIVITIES
SET
recruitment_activity_id = X_Recruitment_Activity_Id,
business_group_id = X_Business_Group_Id,
authorising_person_id = X_Authorising_Person_Id,
run_by_organization_id = X_Run_By_Organization_Id,
internal_contact_person_id = X_Internal_Contact_Person_Id,
parent_recruitment_activity_id = X_Parent_Rec_Activity_Id,
currency_code = X_Currency_Code,
date_start = X_Date_Start,
name = X_Name,
actual_cost = X_Actual_Cost,
comments = X_Comments,
contact_telephone_number = X_Contact_Telephone_Number,
date_closing = X_Date_Closing,
date_end = X_Date_End,
external_contact = X_External_Contact,
planned_cost = X_Planned_Cost,
type = X_Type,
attribute_category = X_Attribute_Category,
attribute1 = X_Attribute1,
attribute2 = X_Attribute2,
attribute3 = X_Attribute3,
attribute4 = X_Attribute4,
attribute5 = X_Attribute5,
attribute6 = X_Attribute6,
attribute7 = X_Attribute7,
attribute8 = X_Attribute8,
attribute9 = X_Attribute9,
attribute10 = X_Attribute10,
attribute11 = X_Attribute11,
attribute12 = X_Attribute12,
attribute13 = X_Attribute13,
attribute14 = X_Attribute14,
attribute15 = X_Attribute15,
attribute16 = X_Attribute16,
attribute17 = X_Attribute17,
attribute18 = X_Attribute18,
attribute19 = X_Attribute19,
attribute20 = X_Attribute20
WHERE rowid = X_rowid;
'per_recruitment_activities_pkg.update_row');
END Update_Row;
PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
BEGIN
DELETE FROM PER_RECRUITMENT_ACTIVITIES
WHERE rowid = X_Rowid;
'per_recruitment_activites_pkg.delete_row');
END Delete_Row;