1 Package ame_condition_swi As
2 /* $Header: amconswi.pkh 120.0 2005/09/02 03:56 mbocutt noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |-------------------------< create_ame_condition >-------------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: ame_condition_api.create_ame_condition
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_condition
27 (p_validate in number default hr_api.g_false_num
28 ,p_condition_key in varchar2
29 ,p_condition_type in varchar2
30 ,p_attribute_id in number default null
31 ,p_parameter_one in varchar2 default null
32 ,p_parameter_two in varchar2 default null
33 ,p_parameter_three in varchar2 default null
34 ,p_include_upper_limit in varchar2 default null
35 ,p_include_lower_limit in varchar2 default null
36 ,p_string_value in varchar2 default null
37 ,p_condition_id in number
38 ,p_con_start_date out nocopy date
39 ,p_con_end_date out nocopy date
40 ,p_con_object_version_number out nocopy number
41 ,p_stv_start_date out nocopy date
42 ,p_stv_end_date out nocopy date
43 ,p_stv_object_version_number out nocopy number
44 ,p_return_status out nocopy varchar2
45 );
46 -- ----------------------------------------------------------------------------
47 -- |-------------------------< update_ame_condition >-------------------------|
48 -- ----------------------------------------------------------------------------
49 -- {Start of comments}
50 --
51 -- Description:
52 -- This procedure is the self-service wrapper procedure to the following
53 -- API: ame_condition_api.update_ame_condition
54 --
55 -- Pre-requisites
56 -- All 'IN' parameters to this procedure have been appropriately derived.
57 --
58 -- Post Success:
59 -- p_return_status will return value indicating success.
60 --
61 -- Post Failure:
62 -- p_return_status will return value indication failure.
63 --
64 -- Access Status:
65 -- Internal Development use only.
66 --
67 -- {End of comments}
68 -- ----------------------------------------------------------------------------
69 PROCEDURE update_ame_condition
70 (p_validate in number default hr_api.g_false_num
71 ,p_condition_id in number
72 ,p_parameter_one in varchar2 default hr_api.g_varchar2
73 ,p_parameter_two in varchar2 default hr_api.g_varchar2
74 ,p_parameter_three in varchar2 default hr_api.g_varchar2
75 ,p_include_upper_limit in varchar2 default hr_api.g_varchar2
76 ,p_include_lower_limit in varchar2 default hr_api.g_varchar2
77 ,p_object_version_number in out nocopy number
78 ,p_start_date out nocopy date
79 ,p_end_date out nocopy date
80 ,p_return_status out nocopy varchar2
81 );
82 -- ----------------------------------------------------------------------------
83 -- |-------------------------< delete_ame_condition >-------------------------|
84 -- ----------------------------------------------------------------------------
85 -- {Start of comments}
86 --
87 -- Description:
88 -- This procedure is the self-service wrapper procedure to the following
89 -- API: ame_condition_api.delete_ame_condition
90 --
91 -- Pre-requisites
92 -- All 'IN' parameters to this procedure have been appropriately derived.
93 --
94 -- Post Success:
95 -- p_return_status will return value indicating success.
96 --
97 -- Post Failure:
98 -- p_return_status will return value indication failure.
99 --
100 -- Access Status:
101 -- Internal Development use only.
102 --
103 -- {End of comments}
104 -- ----------------------------------------------------------------------------
105 PROCEDURE delete_ame_condition
106 (p_validate in number default hr_api.g_false_num
107 ,p_condition_id in number
108 ,p_object_version_number in out nocopy number
109 ,p_start_date out nocopy date
110 ,p_end_date out nocopy date
111 ,p_return_status out nocopy varchar2
112 );
113 -- ----------------------------------------------------------------------------
114 -- |------------------------< create_ame_string_value >-----------------------|
115 -- ----------------------------------------------------------------------------
116 -- {Start of comments}
117 --
118 -- Description:
119 -- This procedure is the self-service wrapper procedure to the following
120 -- API: ame_condition_api.create_ame_string_value
121 --
122 -- Pre-requisites
123 -- All 'IN' parameters to this procedure have been appropriately derived.
124 --
125 -- Post Success:
126 -- p_return_status will return value indicating success.
127 --
128 -- Post Failure:
129 -- p_return_status will return value indication failure.
130 --
131 -- Access Status:
132 -- Internal Development use only.
133 --
134 -- {End of comments}
135 -- ----------------------------------------------------------------------------
136 PROCEDURE create_ame_string_value
137 (p_validate in number default hr_api.g_false_num
138 ,p_condition_id in number
139 ,p_string_value in varchar2
140 ,p_object_version_number out nocopy number
141 ,p_start_date out nocopy date
142 ,p_end_date out nocopy date
143 ,p_return_status out nocopy varchar2
144 );
145 -- ----------------------------------------------------------------------------
146 -- |------------------------< delete_ame_string_value >-----------------------|
147 -- ----------------------------------------------------------------------------
148 -- {Start of comments}
149 --
150 -- Description:
151 -- This procedure is the self-service wrapper procedure to the following
152 -- API: ame_condition_api.delete_ame_string_value
153 --
154 -- Pre-requisites
155 -- All 'IN' parameters to this procedure have been appropriately derived.
156 --
157 -- Post Success:
158 -- p_return_status will return value indicating success.
159 --
160 -- Post Failure:
161 -- p_return_status will return value indication failure.
162 --
163 -- Access Status:
164 -- Internal Development use only.
165 --
166 -- {End of comments}
167 -- ----------------------------------------------------------------------------
168 PROCEDURE delete_ame_string_value
169 (p_validate in number default hr_api.g_false_num
170 ,p_condition_id in number
171 ,p_string_value in varchar2
172 ,p_object_version_number in out nocopy number
173 ,p_start_date out nocopy date
174 ,p_end_date out nocopy date
175 ,p_return_status out nocopy varchar2
176 );
177 end ame_condition_swi;