1 Package hxc_approval_styles_api AUTHID CURRENT_USER as
2 /* $Header: hxchasapi.pkh 120.1 2006/06/08 14:47:44 gsirigin noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |--------------------------< create_approval_styles >----------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 --
11 -- This API creates the Approval Styles.
12 --
13 -- Prerequisites:
14 --
15 -- None.
16 --
17 -- In Parameters:
18 -- Name Reqd Type Description
19 --
20 -- p_validate No boolean If TRUE then the database
21 -- remains unchanged. If FALSE
22 -- then a new Approval Style is
23 -- created. Default is FALSE.
24 -- p_approval_style_id Yes number Primary Key for entity
25 -- p_object_version_number No number Object Version Number
26 -- p_name Yes varchar2 Name for the Approval Style
27 -- p_description No varchar2 User description of the style
28 --
29 -- Post Success:
30 --
31 -- The OUT PARAMETERS set,after the approval style has been created
32 -- successfully,are:
33 --
34 -- Name Type Description
35 --
36 -- p_approval_style_id number Primary key of the new
37 -- approval style
38 -- p_object_version_number number Object version number for the
39 -- new approval style
40 --
41 -- Post Failure:
42 --
43 -- The approval style will not be created and an application error will be
44 -- raised.
45 --
46 -- Access Status:
47 -- Public.
48 --
49 -- {End Of Comments}
50 --
51 procedure create_approval_styles
52 (p_validate in boolean default false
53 ,p_approval_style_id in out nocopy number
54 ,p_object_version_number in out nocopy number
55 ,p_name in varchar2
56 ,p_business_group_id in number default null
57 ,p_legislation_code in varchar2 default null
58 ,p_description in varchar2 default null
59 ,p_run_recipient_extensions in varchar2 default null
60 ,p_admin_role in varchar2 default null
61 ,p_error_admin_role in varchar2 default null
62 -- ,p_effective_date in date default null
63 );
64 --
65 -- ----------------------------------------------------------------------------
66 -- |------------------------<update_approval_styles>--------------------------|
67 -- ----------------------------------------------------------------------------
68 --
69 -- {Start Of Comments}
70 --
71 -- Description:
72 --
73 -- This API updates an existing Approval Style
74 --
75 -- Prerequisites:
76 --
77 -- None
78 --
79 -- In Parameters:
80 -- Name Reqd Type Description
81 --
82 -- p_validate No boolean If TRUE then the database
83 -- remains unchanged. If FALSE
84 -- then the approval style
85 -- is updated. Default is FALSE.
86 -- p_approval_style_id Yes number Primary Key for entity
87 -- p_object_version_number No number Object Version Number
88 -- p_name Yes varchar2 Name for the Approval Style
89 -- p_description No varchar2 User description of the style
90 --
91 -- Post Success:
92 --
93 -- when the approval style has been updated successfully the following
94 -- out parameters are set.
95 --
96 -- Name Type Description
97 --
98 -- p_object_version_number Number Object version number for the
99 -- updated approval style
100 --
101 -- Post Failure:
102 --
103 -- The approval style will not be updated and an application error raised
104 --
105 -- Access Status:
106 -- Public.
107 --
108 -- {End Of Comments}
109 --
110 procedure update_approval_styles
111 (p_validate in boolean default false
112 ,p_approval_style_id in number
113 ,p_object_version_number in out nocopy number
114 ,p_name in varchar2
115 ,p_business_group_id in number default hr_api.g_number
116 ,p_legislation_code in varchar2 default hr_api.g_varchar2
117 ,p_description in varchar2 default hr_api.g_varchar2
118 ,p_run_recipient_extensions in varchar2 default hr_api.g_varchar2
119 ,p_admin_role in varchar2 default hr_api.g_varchar2
120 ,p_error_admin_role in varchar2 default hr_api.g_varchar2
121 -- ,p_effective_date in date default null
122 );
123 --
124 -- ----------------------------------------------------------------------------
125 -- |------------------------< delete_approval_styles >------------------------|
126 -- ----------------------------------------------------------------------------
127 --
128 -- {Start Of Comments}
129 --
130 -- Description:
131 --
132 -- This API deletes an existing Approval Style
133 --
134 -- Prerequisites:
135 --
136 -- None
137 --
138 -- In Parameters:
139 -- Name Reqd Type Description
140 --
141 -- p_validate No boolean If TRUE then the database
142 -- remains unchanged. If FALSE
143 -- then the approval style
144 -- is deleted. Default is FALSE.
145 -- p_approval_style_id Yes number Primary Key for entity
146 -- p_object_version_number Yes number Object Version Number
147 --
148 -- Post Success:
149 --
150 -- when the approval style has been deleted successfully the process
151 -- completes with success.
152 --
153 -- Post Failure:
154 --
155 -- The approval style will not be deleted and an application error raised
156 --
157 -- Access Status:
158 -- Public.
159 --
160 -- {End Of Comments}
161 --
162 procedure delete_approval_styles
163 (p_validate in boolean default false
164 ,p_approval_style_id in number
165 ,p_object_version_number in number
166 );
167 --
168 --
169 END hxc_approval_styles_api;
[Home] [Help]