1 Package ame_attribute_swi As
2 /* $Header: amatrswi.pkh 120.0 2005/09/02 03:51 mbocutt noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |-------------------------< create_ame_attribute >-------------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: ame_attribute_api.create_ame_attribute
11 --
12 -- Pre-requisites
13 -- All 'IN' parameters to this procedure have been appropriately derived.
14 --
15 -- Post Success:
16 -- p_return_status will return value indicating success.
17 --
18 -- Post Failure:
19 -- p_return_status will return value indication failure.
20 --
21 -- Access Status:
22 -- Internal Development use only.
23 --
24 -- {End of comments}
25 -- ----------------------------------------------------------------------------
26 PROCEDURE create_ame_attribute
27 (p_validate in number default hr_api.g_false_num
28 ,p_name in varchar2
29 ,p_description in varchar2
30 ,p_attribute_type in varchar2
31 ,p_item_class_id in number
32 ,p_approver_type_id in number default null
33 ,p_application_id in number default null
34 ,p_is_static in varchar2 default ame_util.booleanTrue
35 ,p_query_string in varchar2 default null
36 ,p_user_editable in varchar2 default ame_util.booleanTrue
37 ,p_value_set_id in number default null
38 ,p_attribute_id in number
39 ,p_atr_object_version_number out nocopy number
40 ,p_atr_start_date out nocopy date
41 ,p_atr_end_date out nocopy date
42 ,p_atu_object_version_number out nocopy number
43 ,p_atu_start_date out nocopy date
44 ,p_atu_end_date out nocopy date
45 ,p_return_status out nocopy varchar2
46 );
47 -- ----------------------------------------------------------------------------
48 -- |----------------------< create_ame_attribute_usage >----------------------|
49 -- ----------------------------------------------------------------------------
50 -- {Start of comments}
51 --
52 -- Description:
53 -- This procedure is the self-service wrapper procedure to the following
54 -- API: ame_attribute_api.create_ame_attribute_usage
55 --
56 -- Pre-requisites
57 -- All 'IN' parameters to this procedure have been appropriately derived.
58 --
59 -- Post Success:
60 -- p_return_status will return value indicating success.
61 --
62 -- Post Failure:
63 -- p_return_status will return value indication failure.
64 --
65 -- Access Status:
66 -- Internal Development use only.
67 --
68 -- {End of comments}
69 -- ----------------------------------------------------------------------------
70 PROCEDURE create_ame_attribute_usage
71 (p_validate in number default hr_api.g_false_num
72 ,p_attribute_id in number
73 ,p_application_id in number
74 ,p_is_static in varchar2 default ame_util.booleanTrue
75 ,p_query_string in varchar2 default null
76 ,p_user_editable in varchar2 default ame_util.booleanTrue
77 ,p_value_set_id in number default null
78 ,p_object_version_number out nocopy number
79 ,p_start_date out nocopy date
80 ,p_end_date out nocopy date
81 ,p_return_status out nocopy varchar2
82 );
83 -- ----------------------------------------------------------------------------
84 -- |-------------------------< update_ame_attribute >-------------------------|
85 -- ----------------------------------------------------------------------------
86 -- {Start of comments}
87 --
88 -- Description:
89 -- This procedure is the self-service wrapper procedure to the following
90 -- API: ame_attribute_api.update_ame_attribute
91 --
92 -- Pre-requisites
93 -- All 'IN' parameters to this procedure have been appropriately derived.
94 --
95 -- Post Success:
96 -- p_return_status will return value indicating success.
97 --
98 -- Post Failure:
99 -- p_return_status will return value indication failure.
100 --
101 -- Access Status:
102 -- Internal Development use only.
103 --
104 -- {End of comments}
105 -- ----------------------------------------------------------------------------
106 PROCEDURE update_ame_attribute
107 (p_validate in number default hr_api.g_false_num
108 ,p_attribute_id in number
109 ,p_description in varchar2 default hr_api.g_varchar2
110 ,p_object_version_number in out nocopy number
111 ,p_start_date out nocopy date
112 ,p_end_date out nocopy date
113 ,p_return_status out nocopy varchar2
114 );
115 -- ----------------------------------------------------------------------------
116 -- |----------------------< update_ame_attribute_usage >----------------------|
117 -- ----------------------------------------------------------------------------
118 -- {Start of comments}
119 --
120 -- Description:
121 -- This procedure is the self-service wrapper procedure to the following
122 -- API: ame_attribute_api.update_ame_attribute_usage
123 --
124 -- Pre-requisites
125 -- All 'IN' parameters to this procedure have been appropriately derived.
126 --
127 -- Post Success:
128 -- p_return_status will return value indicating success.
129 --
130 -- Post Failure:
131 -- p_return_status will return value indication failure.
132 --
133 -- Access Status:
134 -- Internal Development use only.
135 --
136 -- {End of comments}
137 -- ----------------------------------------------------------------------------
138 PROCEDURE update_ame_attribute_usage
139 (p_validate in number default hr_api.g_false_num
140 ,p_attribute_id in number
141 ,p_application_id in number
142 ,p_is_static in varchar2 default hr_api.g_varchar2
143 ,p_query_string in varchar2 default hr_api.g_varchar2
144 ,p_value_set_id in number default null
145 ,p_object_version_number in out nocopy number
146 ,p_start_date out nocopy date
147 ,p_end_date out nocopy date
148 ,p_return_status out nocopy varchar2
149 );
150 -- ----------------------------------------------------------------------------
151 -- |----------------------< delete_ame_attribute_usage >----------------------|
152 -- ----------------------------------------------------------------------------
153 -- {Start of comments}
154 --
155 -- Description:
156 -- This procedure is the self-service wrapper procedure to the following
157 -- API: ame_attribute_api.delete_ame_attribute_usage
158 --
159 -- Pre-requisites
160 -- All 'IN' parameters to this procedure have been appropriately derived.
161 --
162 -- Post Success:
163 -- p_return_status will return value indicating success.
164 --
165 -- Post Failure:
166 -- p_return_status will return value indication failure.
167 --
168 -- Access Status:
169 -- Internal Development use only.
170 --
171 -- {End of comments}
172 -- ----------------------------------------------------------------------------
173 PROCEDURE delete_ame_attribute_usage
174 (p_validate in number default hr_api.g_false_num
175 ,p_attribute_id in number
176 ,p_application_id in number
177 ,p_object_version_number in out nocopy number
178 ,p_start_date out nocopy date
179 ,p_end_date out nocopy date
180 ,p_return_status out nocopy varchar2
181 );
182 end ame_attribute_swi;