1 Package per_solution_type_cmpt_api as
2 /* $Header: pestcapi.pkh 120.0 2005/05/31 21:57:13 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |--------------------< CREATE_SOLUTION_TYPE_CMPT >-------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 -- This business process adds a new solution type component.
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_component_name yes varchar2 Name of the component
23 -- p_solution_type_name yes varchar2 Name of the solution type
24 -- p_api_name yes varchar2 Name of the API to load this
25 -- component
26 -- p_parent_component_name no varchar2 Parent of component hierarchy
27 -- p_updateable yes varchar2 Flag to determine whether a
28 -- user can update this solution
29 -- type component.
30 -- p_extensible yes varchar2 Flag to determine whether a
31 -- user can extend this solution
32 -- type component.
33 -- p_legislation_code yes varchar2 Legislation Code
34 --
35 --
36 -- Post Success:
37 -- When the solution type component is valid, the API sets the following
38 -- out parameters.
39 --
40 -- Name Type Description
41 -- p_object_version_number number If p_validate is false, this
42 -- will be set to the version number
43 -- of the Solution Type Component
44 -- created. If p_validate is true this
45 -- parameter will be set to null.
46 --
47 --
48 -- Post Failure:
49 -- The API does not create a Solution Type Component and raises an error.
50 --
51 --
52 -- Access Status:
53 -- Public.
54 --
55 -- {End Of Comments}
56 --
57 procedure create_solution_type_cmpt
58 (p_validate in boolean default false
59 ,p_effective_date in date
60 ,p_component_name in varchar2
61 ,p_solution_type_name in varchar2
62 ,p_legislation_code in varchar2
63 ,p_api_name in varchar2 default null
64 ,p_parent_component_name in varchar2 default null
65 ,p_updateable in varchar2 default null
66 ,p_extensible in varchar2 default null
67 ,p_object_version_number out nocopy number
68 );
69
70 -- ----------------------------------------------------------------------------
71 -- |--------------------< UPDATE_SOLUTION_TYPE_CMPT >-------------------------|
72 -- ----------------------------------------------------------------------------
73 -- {Start Of Comments}
74 --
75 -- Description:
76 -- This business process updates a solution type component.
77 --
78 -- Prerequisites:
79 -- The Solution Type Component record identified by p_solution_type_name and
80 -- p_object_version_number must exist.
81 --
82 -- In Parameters:
83 -- Name Reqd Type Description
84 -- p_validate yes Boolean If true, the database remains
85 -- unchanged. If false the
86 -- assignment is updated in
87 -- the database.
88 -- p_effective_date yes date Effective date
89 -- p_component_name yes varchar2 Name of the component
90 -- p_solution_type_name yes varchar2 Name of the solution type
91 -- p_legislation_code yes varchar2 Legislation Code
92 -- p_api_name no varchar2 Name of the API to load this
93 -- component
94 -- p_parent_component_name no varchar2 Parent of component hierarchy
95 -- p_updateable no varchar2 Flag to determine whether a
96 -- user can update this solution
97 -- type component.
98 -- p_updateable no varchar2 Flag to determine whether a
99 -- user can extend this solution
100 -- type component.
101 -- p_object_version_number yes number Object Version Number
102 --
103 --
104 --
105 -- Post Success:
106 -- The Solution Type Component record is updated and the API sets the
107 -- following out parameters.
108 --
109 -- Name Type Description
110 -- p_object_version_number number If p_validate is false the
111 -- new version number is returned.
112 -- If p_validate is true then the
113 -- version number passed in is
114 -- returned.
115 --
116 -- Post Failure:
117 -- The API does not update a Solution Type Component and raises an error.
118 --
119 --
120 -- Access Status:
121 -- Public.
122 --
123 -- {End Of Comments}
124 --
125 procedure update_solution_type_cmpt
126 (p_validate in boolean default false
127 ,p_effective_date in date
128 ,p_component_name in varchar2
129 ,p_solution_type_name in varchar2
130 ,p_legislation_code in varchar2
131 ,p_api_name in varchar2 default hr_api.g_varchar2
132 ,p_parent_component_name in varchar2 default hr_api.g_varchar2
133 ,p_updateable in varchar2 default hr_api.g_varchar2
134 ,p_extensible in varchar2 default hr_api.g_varchar2
135 ,p_object_version_number in out nocopy number
136 );
137
138 -- ----------------------------------------------------------------------------
139 -- |--------------------< DELETE_SOLUTION_TYPE_CMPT >-------------------------|
140 -- ----------------------------------------------------------------------------
141 -- {Start Of Comments}
142 --
143 -- Description:
144 -- This business process deletes a solution type component.
145 --
146 -- Prerequisites:
147 -- The Solution Type Component record identified by p_solution_type_name and
148 -- p_object_version_number must exist.
149 --
150 -- In Parameters:
151 -- Name Reqd Type Description
152 -- p_validate yes Boolean If true, the database remains
153 -- unchanged. If false the
154 -- assignment is updated in
155 -- the database.
156 -- p_component_name yes varchar2 Name of the component
157 -- p_solution_type_name yes number Solution Type Component Name
158 -- p_legislation_code yes varchar2 Legislation Code
159 -- p_object_version_number yes number Object Version Number
160 --
161 -- Post Success:
162 -- The Solution Type Component is deleted.
163 --
164 -- Post Failure:
165 -- The API does not delete a Solution Type Component and raises an error.
166 --
167 -- Access Status:
168 -- Public.
169 --
170 -- {End Of Comments}
171 --
172 procedure delete_solution_type_cmpt
173 (p_validate in boolean default false
174 ,p_component_name in varchar2
175 ,p_solution_type_name in varchar2
176 ,p_legislation_code in varchar2
177 ,p_object_version_number in number
178 );
179 --
180 end per_solution_type_cmpt_api;