1 PACKAGE cn_job_title_pvt AUTHID CURRENT_USER AS
2 --$Header: cnvjobs.pls 115.5 2002/11/21 21:14:11 hlchen ship $
3 TYPE job_title_rec_type IS record
4 (job_title_id cn_job_titles.job_title_id%type,
5 name cn_job_titles.name%type,
6 job_code cn_job_titles.job_code%type,
7 role_id cn_roles.role_id%type,
8 role_name cn_roles.name%type);
9
10 TYPE job_title_tbl_type IS table OF job_title_rec_type
11 INDEX BY binary_integer;
12
13 TYPE job_role_rec_type IS record
14 (job_role_id cn_job_roles.job_role_id%type,
15 job_title_id cn_job_roles.job_title_id%type,
16 role_id cn_job_roles.role_id%type,
17 start_date cn_job_roles.start_date%type,
18 end_date cn_job_roles.end_date%type,
19 default_flag cn_job_roles.default_flag%type,
20 attribute_category cn_job_roles.attribute_category%type,
21 attribute1 cn_job_roles.attribute1%type,
22 attribute2 cn_job_roles.attribute2%type,
23 attribute3 cn_job_roles.attribute3%type,
24 attribute4 cn_job_roles.attribute4%type,
25 attribute5 cn_job_roles.attribute5%type,
26 attribute6 cn_job_roles.attribute6%type,
27 attribute7 cn_job_roles.attribute7%type,
28 attribute8 cn_job_roles.attribute8%type,
29 attribute9 cn_job_roles.attribute9%type,
30 attribute10 cn_job_roles.attribute10%type,
31 attribute11 cn_job_roles.attribute11%type,
32 attribute12 cn_job_roles.attribute12%type,
33 attribute13 cn_job_roles.attribute13%type,
34 attribute14 cn_job_roles.attribute14%type,
35 attribute15 cn_job_roles.attribute15%type,
36 object_version_number cn_job_roles.object_version_number%type);
37
38 TYPE job_role_tbl_type IS table of job_role_rec_type
39 INDEX BY binary_integer;
40
41 -- Start of comments
42 -- API name : Create_Job_Role - Private.
43 -- Pre-reqs : None.
44 -- IN : standard params
45 -- p_rec of table rec type
46 -- OUT : standard params
47 -- x_job_role_id
48 -- Version : 1.0
49 --
50 -- End of comments
51
52 PROCEDURE Create_Job_Role
53 (p_api_version IN NUMBER, -- required
54 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
55 p_commit IN VARCHAR2 := FND_API.G_FALSE,
56 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
57 p_rec IN job_role_rec_type,
58 x_return_status OUT NOCOPY VARCHAR2,
59 x_msg_count OUT NOCOPY NUMBER,
60 x_msg_data OUT NOCOPY VARCHAR2,
61 x_job_role_id OUT NOCOPY cn_job_roles.job_role_id%type);
62
63 -- Start of comments
64 -- API name : Update_Job_Role - Private.
65 -- Pre-reqs : None.
66 -- IN : standard params
67 -- p_rec of table rec type
68 -- OUT : standard params
69 -- Version : Current version 1.0
70 --
71 -- End of comments
72
73 PROCEDURE Update_Job_Role
74 (p_api_version IN NUMBER, -- required
75 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
76 p_commit IN VARCHAR2 := FND_API.G_FALSE,
77 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
78 p_rec IN job_role_rec_type,
79 x_return_status OUT NOCOPY VARCHAR2,
80 x_msg_count OUT NOCOPY NUMBER,
81 x_msg_data OUT NOCOPY VARCHAR2);
82
83 -- Start of comments
84 -- API name : Delete_Job_Role - Private.
85 -- Pre-reqs : None.
86 -- IN : standard params
87 -- p_job_role_id
88 -- OUT : standard params
89 -- Version : Current version 1.0
90 --
91 -- End of comments
92
93 PROCEDURE Delete_Job_Role
94 (p_api_version IN NUMBER, -- required
95 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
96 p_commit IN VARCHAR2 := FND_API.G_FALSE,
97 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
98 p_job_role_id IN cn_job_roles.job_role_id%type,
99 p_object_version_number IN cn_job_roles.object_version_number%type,
100 x_return_status OUT NOCOPY VARCHAR2,
101 x_msg_count OUT NOCOPY NUMBER,
102 x_msg_data OUT NOCOPY VARCHAR2);
103
104 -- Start of comments
105 -- API name : Get_Job_Details - Private
106 -- Pre-reqs : None.
107 -- IN : p_job_title_id
108 -- OUT : x_result_tbl
109 -- Version : Current version 1.0
110 --
111 -- End of comments
112
113 PROCEDURE Get_Job_Details
114 (p_job_title_id IN cn_job_titles.job_title_id%type,
115 x_result_tbl OUT NOCOPY job_role_tbl_type);
116
117 -- Start of comments
118 -- API name : Get_Job_Titles - Private
119 -- Pre-reqs : None.
120 -- IN : range params, search string for name
121 -- OUT : x_result_tbl
122 -- Version : Current version 1.0
123 --
124 -- End of comments
125
126 PROCEDURE Get_Job_Titles
127 (p_range_low IN NUMBER,
128 p_range_high IN NUMBER,
129 p_search_name IN VARCHAR2 := '%',
130 p_search_code IN VARCHAR2 := '%',
131 x_total_rows OUT NOCOPY NUMBER,
132 x_result_tbl OUT NOCOPY job_title_tbl_type);
133
134 -- Start of comments
135 -- API name : Get_All_Job_Titles - Private
136 -- Pre-reqs : None.
137 -- IN : (none)
138 -- OUT : x_result_tbl
139 -- Version : Current version 1.0
140 --
141 -- End of comments
142
143 PROCEDURE Get_All_Job_Titles
144 (x_result_tbl OUT NOCOPY job_title_tbl_type);
145
146 -- Start of comments
147 -- API name : Get_Job_Roles - Private
148 -- Pre-reqs : None.
149 -- IN : (none)
150 -- OUT : x_result_tbl
151 -- Version : Current version 1.0
152 --
153 -- End of comments
154
155 PROCEDURE Get_Job_Roles
156 (x_result_tbl OUT NOCOPY job_title_tbl_type);
157
158 END CN_JOB_TITLE_PVT;