[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE insert_update_emp_data
IS
l_employee_number VARCHAR2(30);
SELECT employee_number,first_name,last_name, sex, start_date, end_date,
business_group_name, location_code,set_of_books,default_expense_account,
job_name, supervisor_emp_num, user_name,password, email_address,
work_telephone
FROM por_employee_loader_values ORDER BY last_update_date ASC;
POR_LOAD_EMPLOYEE.insert_update_employee_info (
x_employee_number => l_employee_number,
x_first_name => l_first_name,
x_last_name => l_last_name,
x_sex => l_sex,
x_effective_start_date => l_start_date,
x_effective_end_date => l_end_date,
x_business_group_name => l_business_group_name,
x_location_name => l_location_code,
x_default_employee_account => l_default_expense_account,
x_set_of_books_name => l_set_of_books ,
x_supervisor_emp_number => l_supervisor_emp_num,
x_job_name => l_job_name,
x_email_address => l_email_address,
x_work_telephone => l_work_telephone);
POR_LOAD_FND_USER.insert_update_user_info (
x_employee_number => l_employee_number,
x_user_name => l_user_name,
x_password => l_password,
x_email_address => l_email_address);
UPDATE por_employee_loader_values
SET loader_status = 'complete'
WHERE employee_number = l_employee_number;
UPDATE por_employee_loader_values
SET loader_status = 'failure'
WHERE employee_number = l_employee_number;
END insert_update_emp_data;
PROCEDURE insert_update_loc_data
IS
l_location_code VARCHAR2(30);
SELECT location_code,business_group, effective_date,description,
address_style,address_line_1, address_line_2,address_line_3,
city,state,county,postal_code,country,telephone,fax,ship_to_location,
ship_to_flag,bill_to_flag,receiving_to_flag,office_site,
internal_site,inventory_Org,tax_name
FROM por_location_loader_values ORDER BY last_update_date ASC;
POR_LOAD_LOCATION.insert_update_location_info (
x_location_code => l_location_code,
x_business_grp_name => l_business_group,
x_effective_date => l_effective_date,
x_description => l_description,
x_address_style => l_address_style,
x_address_line_1 => l_address_line_1,
x_address_line_2 => l_address_line_2,
x_address_line_3 => l_address_line_3,
x_city => l_city,
x_state => l_state,
x_county => l_county,
x_country => l_country,
x_postal_code => l_postal_code,
x_telephone_number_1 => l_telephone,
x_telephone_number_2 => l_fax,
x_shipToLocation => l_ship_to_location,
x_ship_to_flag => l_ship_to_flag,
x_bill_to_flag => l_bill_to_flag,
x_receiving_site => l_receiving_to_flag,
x_office_site_flag => l_office_site,
x_inv_org => l_inventory_Org,
x_tax_name => l_tax_name);
UPDATE por_location_loader_values
SET loader_status = 'complete'
WHERE location_code = l_location_code;
UPDATE por_location_loader_values
SET loader_status = 'failure'
WHERE location_code = l_location_code;
END insert_update_loc_data;