1 Package per_solution_set_api as
2 /* $Header: peslsapi.pkh 120.0 2005/05/31 21:12:33 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< CREATE_SOLUTION_SET >---------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 -- This business process adds a new solution set.
11 --
12 -- Prerequisites:
13 -- None
14 --
15 -- In Parameters:
16 -- Name Reqd Type Description
17 -- p_validate yes Boolean If true, the database remains
18 -- unchanged. If false the
19 -- assignment is updated in
20 -- the database.
21 -- p_effective_date yes date Effective date
22 -- p_solution_set_name yes varchar2 Name of the solution set
23 -- p_user_id yes number ID of the owner of the
24 -- solution set
25 -- p_description no varchar2 Description of the solution
26 -- set
27 -- p_status no varchar2 Whether a solution set has
28 -- been completed or implemented
29 -- p_solution_set_impl_id no number Refers to config_hdr_id column
30 -- in az_files table which is a
31 -- sequence number cz_config_hdrs_s.
32 --
33 --
34 -- Post Success:
35 -- When the solution type is valid, the API sets the following out parameters.
36 --
37 -- Name Type Description
38 -- p_object_version_number number If p_validate is false, this
39 -- will be set to the version number
40 -- of the Solution Set created. If
41 -- p_validate is true this parameter
42 -- will be set to null.
43 --
44 --
45 -- Post Failure:
46 -- The API does not create a Solution Set and raises an error.
47 --
48 --
49 -- Access Status:
50 -- Public.
51 --
52 -- {End Of Comments}
53 --
54 procedure create_solution_set
55 (p_validate in boolean default false
56 ,p_effective_date in date
57 ,p_solution_set_name in varchar2
58 ,p_user_id in number
59 ,p_description in varchar2 default null
60 ,p_status in varchar2 default null
61 ,p_solution_set_impl_id in number default hr_api.g_number
62 ,p_object_version_number out nocopy number
63 );
64
65 -- ----------------------------------------------------------------------------
66 -- |------------------------< UPDATE_SOLUTION_SET >---------------------------|
67 -- ----------------------------------------------------------------------------
68 -- {Start Of Comments}
69 --
70 -- Description:
71 -- This business process updates a solution type.
72 --
73 -- Prerequisites:
74 -- The Solution Set record identified by p_solution_type_name and
75 -- p_object_version_number must exist.
76 --
77 -- In Parameters:
78 -- Name Reqd Type Description
79 -- p_validate yes Boolean If true, the database remains
80 -- unchanged. If false the
81 -- assignment is updated in
82 -- the database.
83 -- p_effective_date yes date Effective date
84 -- p_solution_set_name yes varchar2 Name of the solution set
85 -- p_user_id yes number ID of the owner of the
86 -- solution set
87 -- p_description no varchar2 Description of the solution
88 -- set
89 -- p_status no varchar2 Whether a solution set has
90 -- been completed or implemented
91 -- p_object_version_number yes number Object Version Number
92 -- p_solution_set_impl_id no number Refers to config_hdr_id column
93 -- in az_files table which is a
94 -- sequence number cz_config_hdrs_s.
95 --
96 --
97 --
98 -- Post Success:
99 -- The Solution Set record is updated and the API sets the following out
100 -- parameters.
101 --
102 -- Name Type Description
103 -- p_object_version_number number If p_validate is false the
104 -- new version number is returned.
105 -- If p_validate is true then the
106 -- version number passed in is
107 -- returned.
108 --
109 -- Post Failure:
110 -- The API does not update a Solution Set and raises an error.
111 --
112 --
113 -- Access Status:
114 -- Public.
115 --
116 -- {End Of Comments}
117 --
118 procedure update_solution_set
119 (p_validate in boolean default false
120 ,p_effective_date in date
121 ,p_solution_set_name in varchar2
122 ,p_user_id in number
123 ,p_description in varchar2 default hr_api.g_varchar2
124 ,p_status in varchar2 default hr_api.g_varchar2
125 ,p_solution_set_impl_id in number default hr_api.g_number
126 ,p_object_version_number in out nocopy number
127 );
128
129 -- ----------------------------------------------------------------------------
130 -- |------------------------< DELETE_SOLUTION_SET >---------------------------|
131 -- ----------------------------------------------------------------------------
132 -- {Start Of Comments}
133 --
134 -- Description:
135 -- This business process deletes a solution set.
136 --
137 -- Prerequisites:
138 -- The Solution Set record identified by p_solution_type_name and
139 -- p_object_version_number must exist.
140 --
141 -- In Parameters:
142 -- Name Reqd Type Description
143 -- p_validate yes Boolean If true, the database remains
144 -- unchanged. If false the
145 -- assignment is updated in
146 -- the database.
147 -- p_solution_set_name yes varchar2 Name of the solution set
148 -- p_user_id yes number ID of the owner of the
149 -- solution set
150 -- p_object_version_number yes number Object Version Number
151 --
152 -- Post Success:
153 -- The Solution Set is deleted.
154 --
155 -- Post Failure:
156 -- The API does not delete a Solution Set and raises an error.
157 --
158 -- Access Status:
159 -- Public.
160 --
161 -- {End Of Comments}
162 --
163 procedure delete_solution_set
164 (p_validate in boolean default false
165 ,p_solution_set_name in varchar2
166 ,p_user_id in number
167 ,p_object_version_number in number
168 );
169 --
170 end per_solution_set_api;