DBA Data[Home] [Help]

PACKAGE: APPS.PER_SOLUTION_CMPT_NAME_API

Source


1 Package per_solution_cmpt_name_api AUTHID CURRENT_USER 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;