1 Package PQH_DE_LEVEL_CODES_API AUTHID CURRENT_USER as
2 /* $Header: pqlcdapi.pkh 120.0 2005/05/29 02:10:01 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |--------------------------< <PQH_DE_LEVEL_CODES_API> >--------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 -- This API Creates the the master definition of LEVEL CODES
11 --
12 -- Prerequisites:
13 --
14 --
15 -- In Parameters:
16 -- Name Reqd Type Description
17 --
18 --
19 -- Post Success:
20 --
21 --
22 -- Name Type Description
23 --
24 -- Post Failure:
25 --
26 --
27 -- Access Status:
28 -- Public.
29 --
30 -- {End Of Comments}
31 --
32
33 procedure Insert_LEVEL_CODES
34 (p_validate in boolean default false
35 ,p_effective_date in date
36 ,p_level_number_id in number
37 ,p_level_code in varchar2
38 ,p_description in varchar2
39 ,p_gradual_value_number in number
40 ,p_level_code_id out nocopy number
41 ,p_object_version_number out nocopy number
42 );
43
44 procedure Update_LEVEL_CODES
45 (p_validate in boolean default false
46 ,p_effective_date in date
47 ,p_level_code_id in number
48 ,p_object_version_number in out nocopy number
49 ,p_level_number_id in number default hr_api.g_number
50 ,p_level_code in varchar2 default hr_api.g_varchar2
51 ,p_description in varchar2 default hr_api.g_varchar2
52 ,p_gradual_value_number in number default hr_api.g_number
53 );
54
55 procedure delete_LEVEL_CODES
56 (p_validate in boolean default false
57 ,p_level_code_id in number
58 ,p_object_version_number in number
59 );
60 --
61 end PQH_DE_LEVEL_CODES_API;