[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE insert_update_employee_info (
x_employee_number IN VARCHAR2,
x_first_name IN VARCHAR2,
x_last_name IN VARCHAR2,
x_sex IN VARCHAR2,
x_effective_start_date IN DATE,
x_effective_end_date IN DATE,
x_business_group_name IN VARCHAR2,
x_location_name IN VARCHAR2,
x_default_employee_account IN VARCHAR2,
x_set_of_books_name IN VARCHAR2,
x_supervisor_emp_number IN VARCHAR2,
x_job_name IN VARCHAR2,
x_email_address IN VARCHAR2,
x_work_telephone IN VARCHAR2)
IS
l_person_id NUMBER;
p_Last_Update_Date DATE;
p_Last_Updated_By NUMBER;
p_Last_Update_Login NUMBER;
p_Last_Update_Date,
p_Last_Updated_By,
p_Last_Update_Login);
PER_PEOPLE_V15_PKG.Update_Row(
X_Rowid => l_row_id,
X_Person_Id => l_person_id,
X_Effective_Start_Date => l_effective_start_date,
X_Effective_End_Date => effective_end_date,
X_Business_Group_Id => l_business_group_id,
X_Person_Type_Id => p_Person_Type_Id,
X_Last_Name => x_last_name,
X_Email_Address => x_email_address,
X_Start_Date => p_Start_Date,
X_Hire_date => p_Hire_date,
X_S_Hire_Date => NULL,
X_Period_of_service_id => NULL,
X_Termination_Date => NULL,
X_S_Termination_Date => NULL,
X_Applicant_Number => p_Applicant_Number,
X_Comment_Id => p_Comment_Id,
X_Current_Applicant_Flag => p_Current_Applicant_Flag,
X_Current_Emp_Or_Apl_Flag => p_Current_Emp_Or_Apl_Flag,
X_Current_Employee_Flag => p_Current_Employee_Flag,
X_Date_Employee_Data_Verified => p_Date_Employee_Data_Verified,
X_Date_Of_Birth => p_Date_Of_Birth,
X_Employee_Number => x_employee_number,
X_Expense_Check_To_Address => p_Expense_Check_To_Address,
X_First_Name => x_first_name,
X_Full_Name => p_Full_Name,
X_Known_As => p_Known_As,
X_Marital_Status =>p_Marital_Status ,
X_Middle_Names => p_Middle_Names,
X_Nationality => p_Nationality,
X_National_Identifier => p_National_Identifier,
X_Previous_Last_Name => p_Previous_Last_Name,
X_Registered_Disabled_Flag => p_Registered_Disabled_Flag,
X_Sex => x_sex,
X_Title => p_Title,
X_Vendor_Id => p_Vendor_Id,
X_Work_Telephone => x_work_telephone,
X_Attribute_Category => p_Attribute_Category,
X_Attribute1 => p_Attribute1,
X_Attribute2 => p_Attribute2,
X_Attribute3 => p_Attribute3,
X_Attribute4 => p_Attribute4,
X_Attribute5 => p_Attribute5,
X_Attribute6 => p_Attribute6,
X_Attribute7 => p_Attribute7,
X_Attribute8 => p_Attribute8,
X_Attribute9 => p_Attribute9,
X_Attribute10 => p_Attribute10,
X_Attribute11 => p_Attribute11,
X_Attribute12 => p_Attribute12,
X_Attribute13 => p_Attribute13,
X_Attribute14 => p_Attribute14,
X_Attribute15 => p_Attribute15,
X_Attribute16 => p_Attribute16,
X_Attribute17 => p_Attribute17,
X_Attribute18 => p_Attribute18,
X_Attribute19 => p_Attribute19,
X_Attribute20 => p_Attribute20,
X_Attribute21 => p_Attribute21,
X_Attribute22 => p_Attribute22,
X_Attribute23 => p_Attribute23,
X_Attribute24 => p_Attribute24,
X_Attribute25 => p_Attribute25,
X_Attribute26 => p_Attribute26,
X_Attribute27 => p_Attribute27,
X_Attribute28 => p_Attribute28,
X_Attribute29 => p_Attribute29,
X_Attribute30 => p_Attribute30,
X_Last_Update_Date => sysdate,
X_Last_Updated_By => p_Last_Updated_By,
X_Last_Update_Login => p_Last_Update_Login);
POR_LOAD_EMPLOYEE_ASSIGNMENT.insert_update_employee_asg(
l_person_id,
l_business_group_id,
x_location_name,
l_assignment_number,
x_default_employee_account,
x_set_of_books_name,
x_job_name,
x_supervisor_emp_number,
x_effective_start_date,
x_effective_end_date);
END insert_update_employee_info;
SELECT business_group_id INTO l_business_group_id
FROM per_business_groups
WHERE name = p_business_group_name;
SELECT person_id INTO l_person_id
FROM per_all_people_f
WHERE employee_number = p_employee_number;
SELECT rowid INTO l_row_id
FROM per_all_people_f
WHERE employee_number = p_employee_number;
p_Last_Update_Date OUT NOCOPY DATE,
p_Last_Updated_By OUT NOCOPY NUMBER,
p_Last_Update_Login OUT NOCOPY NUMBER)
IS
BEGIN
SELECT EFFECTIVE_START_DATE,
EFFECTIVE_END_DATE,
BUSINESS_GROUP_ID,
PERSON_TYPE_ID,
LAST_NAME,
START_DATE,
ORIGINAL_DATE_OF_HIRE,
APPLICANT_NUMBER,
COMMENT_ID,
CURRENT_APPLICANT_FLAG,
CURRENT_EMP_OR_APL_FLAG,
CURRENT_EMPLOYEE_FLAG,
DATE_EMPLOYEE_DATA_VERIFIED,
DATE_OF_BIRTH,
EMAIL_ADDRESS,
EXPENSE_CHECK_SEND_TO_ADDRESS,
FIRST_NAME,
FULL_NAME,
KNOWN_AS,
MARITAL_STATUS,
MIDDLE_NAMES,
NATIONALITY,
NATIONAL_IDENTIFIER,
PREVIOUS_LAST_NAME,
REGISTERED_DISABLED_FLAG,
SEX,
TITLE,
VENDOR_ID,
WORK_TELEPHONE,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
ATTRIBUTE16,
ATTRIBUTE17,
ATTRIBUTE18,
ATTRIBUTE19,
ATTRIBUTE20,
ATTRIBUTE21,
ATTRIBUTE22,
ATTRIBUTE23,
ATTRIBUTE24,
ATTRIBUTE25,
ATTRIBUTE26,
ATTRIBUTE27,
ATTRIBUTE28,
ATTRIBUTE29,
ATTRIBUTE30,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN
INTO p_Effective_Start_Date,
p_Effective_End_Date,
p_Business_Group_Id,
p_Person_Type_Id,
p_Last_Name,
p_Start_Date,
p_Hire_date,
p_Applicant_Number,
p_Comment_Id,
p_Current_Applicant_Flag,
p_Current_Emp_Or_Apl_Flag,
p_Current_Employee_Flag,
p_Date_Employee_Data_Verified,
p_Date_Of_Birth,
p_Email_Address,
p_Expense_Check_To_Address,
p_First_Name,
p_Full_Name,
p_Known_As,
p_Marital_Status,
p_Middle_Names,
p_Nationality,
p_National_Identifier,
p_Previous_Last_Name,
p_Registered_Disabled_Flag,
p_Sex,
p_Title,
p_Vendor_Id,
p_Work_Telephone,
p_Attribute_Category,
p_Attribute1,
p_Attribute2,
p_Attribute3,
p_Attribute4,
p_Attribute5,
p_Attribute6,
p_Attribute7,
p_Attribute8,
p_Attribute9,
p_Attribute10,
p_Attribute11,
p_Attribute12,
p_Attribute13,
p_Attribute14,
p_Attribute15,
p_Attribute16,
p_Attribute17,
p_Attribute18,
p_Attribute19,
p_Attribute20,
p_Attribute21,
p_Attribute22,
p_Attribute23,
p_Attribute24,
p_Attribute25,
p_Attribute26,
p_Attribute27,
p_Attribute28,
p_Attribute29,
p_Attribute30,
p_Last_Update_Date,
p_Last_Updated_By,
p_Last_Update_Login
FROM per_all_people_f
WHERE EMPLOYEE_NUMBER = x_employee_number;