1 PACKAGE CN_ADD_TBH_PVT AUTHID CURRENT_USER AS
2 /*$Header: cnvatbhs.pls 115.5 2002/11/25 19:07:59 nkodkani ship $*/
3
4 -- Start of comments
5 -- API name : Create_TBH - Private.
6 -- Pre-reqs : None.
7 -- IN : standard params
8 -- mgr_srp_id, emp_num, name, comp_group, job_title_id
9 -- start+end date for srp, mgr assignment, job assignment
10 -- OUT : standard params
11 -- x_srp_id
12 -- Version : 1.0
13 --
14 -- End of comments
15
16 PROCEDURE Create_TBH
17 (p_api_version IN NUMBER, -- required
18 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
19 p_commit IN VARCHAR2 := FND_API.G_FALSE,
20 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
21 p_mgr_srp_id IN NUMBER,
22 p_name IN VARCHAR2,
23 p_emp_num IN VARCHAR2,
24 p_comp_group_id IN NUMBER,
25 p_start_date_active IN DATE,
26 p_end_date_active IN DATE,
27 x_return_status OUT NOCOPY VARCHAR2,
28 x_msg_count OUT NOCOPY NUMBER,
29 x_msg_data OUT NOCOPY VARCHAR2,
30 x_srp_id OUT NOCOPY NUMBER);
31
32 -- Given a manager's employee number, create the next sequence number
33 -- for a TBH under that manager
34 FUNCTION Get_TBH_Emp_Num
35 (p_mgr_emp_num IN VARCHAR2) RETURN NUMBER;
36
37 END CN_ADD_TBH_PVT;