APPS.POR_LOAD_HR_DATA dependencies on POR_EMPLOYEE_LOADER_VALUES

Line 31: FROM por_employee_loader_values ORDER BY last_update_date ASC;

27: SELECT employee_number,first_name,last_name, sex, start_date, end_date,
28: business_group_name, location_code,set_of_books,default_expense_account,
29: job_name, supervisor_emp_num, user_name,password, email_address,
30: work_telephone
31: FROM por_employee_loader_values ORDER BY last_update_date ASC;
32:
33: BEGIN
34:
35: OPEN c_employees;

Line 68: UPDATE por_employee_loader_values

64: x_password => l_password,
65: x_email_address => l_email_address);
66:
67:
68: UPDATE por_employee_loader_values
69: SET loader_status = 'complete'
70: WHERE employee_number = l_employee_number;
71:
72: EXCEPTION

Line 84: UPDATE por_employee_loader_values

80: ELSE
81: ERROR_STACK.PUSHMESSAGE(hr_utility.get_message(),'ICX');
82: END IF;
83:
84: UPDATE por_employee_loader_values
85: SET loader_status = 'failure'
86: WHERE employee_number = l_employee_number;
87:
88: END;