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