1 Package hr_ki_options_swi AUTHID CURRENT_USER As
2 /* $Header: hroptswi.pkh 115.0 2004/01/09 02:36 vkarandi noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |-----------------------------< create_option >----------------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: hr_ki_options_api.create_option
11 --
12 -- Pre-requisites
13 -- All 'IN' parameters to this procedure have been appropriately derived.
14 --
15 -- Post Success:
16 -- p_return_status will return value indicating success.
17 --
18 -- Post Failure:
19 -- p_return_status will return value indication failure.
20 --
21 -- Access Status:
22 -- Internal Development use only.
23 --
24 -- {End of comments}
25 -- ----------------------------------------------------------------------------
26 PROCEDURE create_option
27 (p_validate in number default hr_api.g_false_num
28 ,p_effective_date in date
29 ,p_option_type_id in number
30 ,p_option_level in number
31 ,p_option_level_id in varchar2 default null
32 ,p_value in varchar2 default null
33 ,p_encrypted in varchar2 default 'N'
34 ,p_integration_id in number
35 ,p_option_id in number
36 ,p_object_version_number out nocopy number
37 ,p_return_status out nocopy varchar2
38 );
39 -- ----------------------------------------------------------------------------
40 -- |-----------------------------< delete_option >----------------------------|
41 -- ----------------------------------------------------------------------------
42 -- {Start of comments}
43 --
44 -- Description:
45 -- This procedure is the self-service wrapper procedure to the following
46 -- API: hr_ki_options_api.delete_option
47 --
48 -- Pre-requisites
49 -- All 'IN' parameters to this procedure have been appropriately derived.
50 --
51 -- Post Success:
52 -- p_return_status will return value indicating success.
53 --
54 -- Post Failure:
55 -- p_return_status will return value indication failure.
56 --
57 -- Access Status:
58 -- Internal Development use only.
59 --
60 -- {End of comments}
61 -- ----------------------------------------------------------------------------
62 PROCEDURE delete_option
63 (p_validate in number default hr_api.g_false_num
64 ,p_option_id in number
65 ,p_object_version_number in number
66 ,p_return_status out nocopy varchar2
67 );
68 -- ----------------------------------------------------------------------------
69 -- |-----------------------------< update_option >----------------------------|
70 -- ----------------------------------------------------------------------------
71 -- {Start of comments}
72 --
73 -- Description:
74 -- This procedure is the self-service wrapper procedure to the following
75 -- API: hr_ki_options_api.update_option
76 --
77 -- Pre-requisites
78 -- All 'IN' parameters to this procedure have been appropriately derived.
79 --
80 -- Post Success:
81 -- p_return_status will return value indicating success.
82 --
83 -- Post Failure:
84 -- p_return_status will return value indication failure.
85 --
86 -- Access Status:
87 -- Internal Development use only.
88 --
89 -- {End of comments}
90 -- ----------------------------------------------------------------------------
91 PROCEDURE update_option
92 (p_validate in number default hr_api.g_false_num
93 ,p_option_id in number
94 ,p_value in varchar2 default hr_api.g_varchar2
95 ,p_encrypted in varchar2 default hr_api.g_varchar2
96 ,p_object_version_number in out nocopy number
97 ,p_return_status out nocopy varchar2
98 );
99 end hr_ki_options_swi;