PACKAGE: APPS.POR_LOAD_EMPLOYEE_ASSIGNMENT

Source

1 PACKAGE POR_LOAD_EMPLOYEE_ASSIGNMENT AUTHID CURRENT_USER as
2 /* $Header: PORLEMAS.pls 115.2 2002/11/19 00:35:22 jjessup ship $ */
3 
4 PROCEDURE insert_update_employee_asg(
5         x_person_id IN NUMBER,
6         x_business_group_id IN NUMBER,
7         x_location_name IN VARCHAR2,
8         x_assignment_number IN OUT NOCOPY VARCHAR2,
9         x_default_employee_account IN VARCHAR2,
10         x_set_of_books_name IN VARCHAR2,
11         x_job_name IN VARCHAR2,
12         x_supervisor_emp_number IN VARCHAR2,
13         x_effective_start_date IN DATE,
14         x_effective_end_date IN DATE);
15 
16 FUNCTION get_set_of_books_id(p_set_of_books_name IN VARCHAR2) RETURN NUMBER;
17 
18 FUNCTION get_chart_of_accounts_id (p_set_of_books_id IN NUMBER) RETURN NUMBER;
19 
20 FUNCTION get_ccid (p_chart_of_accounts_id IN NUMBER, p_concatenated_segs IN VARCHAR2) RETURN NUMBER;
21 
22 PROCEDURE get_assignment_exists(p_person_id IN NUMBER,p_effective_start_date IN DATE, p_effective_end_date IN DATE,l_assignment_id OUT NOCOPY NUMBER,l_object_version_number OUT NOCOPY NUMBER);
23 
24 FUNCTION get_job_id (p_job_name IN VARCHAR2, p_business_group_id IN NUMBER) RETURN NUMBER;
25 
26 FUNCTION get_supervisor_id(x_supervisor_emp_num IN VARCHAR2) RETURN NUMBER;
27 
28 FUNCTION get_address_exists(p_person_id IN NUMBER) RETURN NUMBER;
29 
30 FUNCTION get_location_id (p_location_name IN VARCHAR2) RETURN NUMBER;
31 END POR_LOAD_EMPLOYEE_ASSIGNMENT;