1 Package per_solution_cmpt_name_api as
2 /* $Header: pescnapi.pkh 120.0 2005/05/31 20:46:04 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |-----------------------< CREATE_SOLUTION_CMPT_NAME >---------------------------|
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_solution_id yes number Solution Id
22 -- p_component_name yes varchar2 Component Name
23 -- p_solution_type_name yes varchar2 Solution Type Name
24 -- p_name no varchar2 Name of the component row
25 -- p_template_file no blob The template file as defined
26 -- in AZ_FILES
27 --
28 --
29 -- Post Success:
30 -- When the solution type is valid, the API sets the following out parameters.
31 --
32 -- Name Type Description
33 -- p_object_version_number number If p_validate is false, this
34 -- will be set to the version number
35 -- of the Solution Component Name
36 -- created. If p_validate is true this
37 -- parameter will be set to null.
38 --
39 --
40 -- Post Failure:
41 -- The API does not create a Solution Component Name and raises an error.
42 --
43 --
44 -- Access Status:
45 -- Public.
46 --
47 -- {End Of Comments}
48 --
49 procedure create_solution_cmpt_name
50 (p_validate in boolean default false
51 ,p_solution_id in number
52 ,p_component_name in varchar2
53 ,p_solution_type_name in varchar2
54 ,p_name in varchar2 default null
55 ,p_object_version_number out nocopy number
56 );
57 --
58 --
59 procedure create_solution_cmpt_name
60 (p_validate in boolean default false
61 ,p_solution_id in number
62 ,p_component_name in varchar2
63 ,p_solution_type_name in varchar2
64 ,p_name in varchar2 default null
65 ,p_template_file in varchar2
66 ,p_object_version_number out nocopy number
67 );
68 --
69 --
70 -- ----------------------------------------------------------------------------
71 -- |--------------------< UPDATE_SOLUTION_CMPT_NAME >-------------------------|
72 -- ----------------------------------------------------------------------------
73 -- {Start Of Comments}
74 --
75 -- Description:
76 -- This business process updates a solution component name.
77 --
78 -- Prerequisites:
79 -- The Solution Component Name record must exist.
80 --
81 -- In Parameters:
82 -- Name Reqd Type Description
83 -- p_validate yes Boolean If true, the database remains
84 -- unchanged. If false the
85 -- assignment is updated in
86 -- the database.
87 -- p_solution_id yes number Solution Id
88 -- p_component_name yes varchar2 Component Name
89 -- p_solution_type_name yes varchar2 Solution Type Name
90 -- p_name no varchar2 Name of the component row
91 -- p_template_file no blob The template file as defined
92 -- in AZ_FILES
93 -- p_object_version_number yes number Object Version Number
94 --
95 --
96 --
97 -- Post Success:
98 -- The Solution Component Name record is updated and the API sets the following out
99 -- parameters.
100 --
101 -- Name Type Description
102 -- p_object_version_number number If p_validate is false the
103 -- new version number is returned.
104 -- If p_validate is true then the
105 -- version number passed in is
106 -- returned.
107 --
108 -- Post Failure:
109 -- The API does not update a Solution Component Name and raises an error.
110 --
111 --
112 -- Access Status:
113 -- Public.
114 --
115 -- {End Of Comments}
116 --
117 procedure update_solution_cmpt_name
118 (p_validate in boolean default false
119 ,p_solution_id in number
120 ,p_component_name in varchar2
121 ,p_solution_type_name in varchar2
122 ,p_name in varchar2 default hr_api.g_varchar2
123 ,p_template_file in varchar2
124 ,p_object_version_number in out nocopy number
125 );
126
127 -- ----------------------------------------------------------------------------
128 -- |--------------------< DELETE_SOLUTION_CMPT_NAME >-------------------------|
129 -- ----------------------------------------------------------------------------
130 -- {Start Of Comments}
131 --
132 -- Description:
133 -- This business process deletes a solution component name.
134 --
135 -- Prerequisites:
136 -- The Solution Component Name record identified by p_solution_cmpt_name_name
137 -- and p_object_version_number must exist.
138 --
139 -- In Parameters:
140 -- Name Reqd Type Description
141 -- p_validate yes Boolean If true, the database remains
142 -- unchanged. If false the
143 -- assignment is updated in
144 -- the database.
145 -- p_solution_id yes number Solution Id
146 -- p_component_name yes varchar2 Component Name
147 -- p_solution_type_name yes varchar2 Solution Type Name
148 -- p_object_version_number yes number Object Version Number
149 --
150 -- Post Success:
151 -- The Solution Component Name is deleted.
152 --
153 -- Post Failure:
154 -- The API does not delete a Solution Component Name and raises an error.
155 --
156 -- Access Status:
157 -- Public.
158 --
159 -- {End Of Comments}
160 --
161 procedure delete_solution_cmpt_name
162 (p_validate in boolean default false
163 ,p_solution_id in number
164 ,p_component_name in varchar2
165 ,p_solution_type_name in varchar2
166 ,p_object_version_number in number
167 );
168 --
169 end per_solution_cmpt_name_api;