7: g_package varchar2(33) := ' ben_ELIG_OBJ_ELIG_PROFL_swi.';
8: --
9:
10: procedure create_ELIG_OBJ_ELIG_PROFL
11: (p_validate in number default hr_api.g_false_num
12: ,p_elig_obj_elig_prfl_id in number
13: ,p_effective_start_date out nocopy date
14: ,p_effective_end_date out nocopy date
15: ,p_business_group_id in number default null
55: begin
56: hr_utility.set_location('Entering:'|| l_proc, 10);
57: --
58: --Convert Constant values into their corresponding boolean value
59: l_validate := hr_api.constant_to_boolean(p_constant_value => p_validate);
60:
61: -- Issue a savepoint if operating in validation only mode
62: --
63: savepoint create_ELIG_OBJ_ELIG_PROFL;
146: -- |------------------------< update_ELIG_OBJ_ELIG_PROFL >--- ------------------|
147: -- ----------------------------------------------------------------------------
148: --
149: procedure update_ELIG_OBJ_ELIG_PROFL
150: (p_validate in number default hr_api.g_false_num
151: ,p_elig_obj_elig_prfl_id in number
152: ,p_effective_start_date out nocopy date
153: ,p_effective_end_date out nocopy date
154: ,p_business_group_id in number default hr_api.g_number
150: (p_validate in number default hr_api.g_false_num
151: ,p_elig_obj_elig_prfl_id in number
152: ,p_effective_start_date out nocopy date
153: ,p_effective_end_date out nocopy date
154: ,p_business_group_id in number default hr_api.g_number
155: ,p_elig_obj_id in number default hr_api.g_number
156: ,p_elig_prfl_id in number default hr_api.g_number
157: ,p_mndtry_flag in varchar2 default 'N'
158: ,p_bep_attribute_category in varchar2 default hr_api.g_varchar2
151: ,p_elig_obj_elig_prfl_id in number
152: ,p_effective_start_date out nocopy date
153: ,p_effective_end_date out nocopy date
154: ,p_business_group_id in number default hr_api.g_number
155: ,p_elig_obj_id in number default hr_api.g_number
156: ,p_elig_prfl_id in number default hr_api.g_number
157: ,p_mndtry_flag in varchar2 default 'N'
158: ,p_bep_attribute_category in varchar2 default hr_api.g_varchar2
159: ,p_bep_attribute1 in varchar2 default hr_api.g_varchar2
152: ,p_effective_start_date out nocopy date
153: ,p_effective_end_date out nocopy date
154: ,p_business_group_id in number default hr_api.g_number
155: ,p_elig_obj_id in number default hr_api.g_number
156: ,p_elig_prfl_id in number default hr_api.g_number
157: ,p_mndtry_flag in varchar2 default 'N'
158: ,p_bep_attribute_category in varchar2 default hr_api.g_varchar2
159: ,p_bep_attribute1 in varchar2 default hr_api.g_varchar2
160: ,p_bep_attribute2 in varchar2 default hr_api.g_varchar2
154: ,p_business_group_id in number default hr_api.g_number
155: ,p_elig_obj_id in number default hr_api.g_number
156: ,p_elig_prfl_id in number default hr_api.g_number
157: ,p_mndtry_flag in varchar2 default 'N'
158: ,p_bep_attribute_category in varchar2 default hr_api.g_varchar2
159: ,p_bep_attribute1 in varchar2 default hr_api.g_varchar2
160: ,p_bep_attribute2 in varchar2 default hr_api.g_varchar2
161: ,p_bep_attribute3 in varchar2 default hr_api.g_varchar2
162: ,p_bep_attribute4 in varchar2 default hr_api.g_varchar2
155: ,p_elig_obj_id in number default hr_api.g_number
156: ,p_elig_prfl_id in number default hr_api.g_number
157: ,p_mndtry_flag in varchar2 default 'N'
158: ,p_bep_attribute_category in varchar2 default hr_api.g_varchar2
159: ,p_bep_attribute1 in varchar2 default hr_api.g_varchar2
160: ,p_bep_attribute2 in varchar2 default hr_api.g_varchar2
161: ,p_bep_attribute3 in varchar2 default hr_api.g_varchar2
162: ,p_bep_attribute4 in varchar2 default hr_api.g_varchar2
163: ,p_bep_attribute5 in varchar2 default hr_api.g_varchar2
156: ,p_elig_prfl_id in number default hr_api.g_number
157: ,p_mndtry_flag in varchar2 default 'N'
158: ,p_bep_attribute_category in varchar2 default hr_api.g_varchar2
159: ,p_bep_attribute1 in varchar2 default hr_api.g_varchar2
160: ,p_bep_attribute2 in varchar2 default hr_api.g_varchar2
161: ,p_bep_attribute3 in varchar2 default hr_api.g_varchar2
162: ,p_bep_attribute4 in varchar2 default hr_api.g_varchar2
163: ,p_bep_attribute5 in varchar2 default hr_api.g_varchar2
164: ,p_bep_attribute6 in varchar2 default hr_api.g_varchar2
157: ,p_mndtry_flag in varchar2 default 'N'
158: ,p_bep_attribute_category in varchar2 default hr_api.g_varchar2
159: ,p_bep_attribute1 in varchar2 default hr_api.g_varchar2
160: ,p_bep_attribute2 in varchar2 default hr_api.g_varchar2
161: ,p_bep_attribute3 in varchar2 default hr_api.g_varchar2
162: ,p_bep_attribute4 in varchar2 default hr_api.g_varchar2
163: ,p_bep_attribute5 in varchar2 default hr_api.g_varchar2
164: ,p_bep_attribute6 in varchar2 default hr_api.g_varchar2
165: ,p_bep_attribute7 in varchar2 default hr_api.g_varchar2
158: ,p_bep_attribute_category in varchar2 default hr_api.g_varchar2
159: ,p_bep_attribute1 in varchar2 default hr_api.g_varchar2
160: ,p_bep_attribute2 in varchar2 default hr_api.g_varchar2
161: ,p_bep_attribute3 in varchar2 default hr_api.g_varchar2
162: ,p_bep_attribute4 in varchar2 default hr_api.g_varchar2
163: ,p_bep_attribute5 in varchar2 default hr_api.g_varchar2
164: ,p_bep_attribute6 in varchar2 default hr_api.g_varchar2
165: ,p_bep_attribute7 in varchar2 default hr_api.g_varchar2
166: ,p_bep_attribute8 in varchar2 default hr_api.g_varchar2
159: ,p_bep_attribute1 in varchar2 default hr_api.g_varchar2
160: ,p_bep_attribute2 in varchar2 default hr_api.g_varchar2
161: ,p_bep_attribute3 in varchar2 default hr_api.g_varchar2
162: ,p_bep_attribute4 in varchar2 default hr_api.g_varchar2
163: ,p_bep_attribute5 in varchar2 default hr_api.g_varchar2
164: ,p_bep_attribute6 in varchar2 default hr_api.g_varchar2
165: ,p_bep_attribute7 in varchar2 default hr_api.g_varchar2
166: ,p_bep_attribute8 in varchar2 default hr_api.g_varchar2
167: ,p_bep_attribute9 in varchar2 default hr_api.g_varchar2
160: ,p_bep_attribute2 in varchar2 default hr_api.g_varchar2
161: ,p_bep_attribute3 in varchar2 default hr_api.g_varchar2
162: ,p_bep_attribute4 in varchar2 default hr_api.g_varchar2
163: ,p_bep_attribute5 in varchar2 default hr_api.g_varchar2
164: ,p_bep_attribute6 in varchar2 default hr_api.g_varchar2
165: ,p_bep_attribute7 in varchar2 default hr_api.g_varchar2
166: ,p_bep_attribute8 in varchar2 default hr_api.g_varchar2
167: ,p_bep_attribute9 in varchar2 default hr_api.g_varchar2
168: ,p_bep_attribute10 in varchar2 default hr_api.g_varchar2
161: ,p_bep_attribute3 in varchar2 default hr_api.g_varchar2
162: ,p_bep_attribute4 in varchar2 default hr_api.g_varchar2
163: ,p_bep_attribute5 in varchar2 default hr_api.g_varchar2
164: ,p_bep_attribute6 in varchar2 default hr_api.g_varchar2
165: ,p_bep_attribute7 in varchar2 default hr_api.g_varchar2
166: ,p_bep_attribute8 in varchar2 default hr_api.g_varchar2
167: ,p_bep_attribute9 in varchar2 default hr_api.g_varchar2
168: ,p_bep_attribute10 in varchar2 default hr_api.g_varchar2
169: ,p_bep_attribute11 in varchar2 default hr_api.g_varchar2
162: ,p_bep_attribute4 in varchar2 default hr_api.g_varchar2
163: ,p_bep_attribute5 in varchar2 default hr_api.g_varchar2
164: ,p_bep_attribute6 in varchar2 default hr_api.g_varchar2
165: ,p_bep_attribute7 in varchar2 default hr_api.g_varchar2
166: ,p_bep_attribute8 in varchar2 default hr_api.g_varchar2
167: ,p_bep_attribute9 in varchar2 default hr_api.g_varchar2
168: ,p_bep_attribute10 in varchar2 default hr_api.g_varchar2
169: ,p_bep_attribute11 in varchar2 default hr_api.g_varchar2
170: ,p_bep_attribute12 in varchar2 default hr_api.g_varchar2
163: ,p_bep_attribute5 in varchar2 default hr_api.g_varchar2
164: ,p_bep_attribute6 in varchar2 default hr_api.g_varchar2
165: ,p_bep_attribute7 in varchar2 default hr_api.g_varchar2
166: ,p_bep_attribute8 in varchar2 default hr_api.g_varchar2
167: ,p_bep_attribute9 in varchar2 default hr_api.g_varchar2
168: ,p_bep_attribute10 in varchar2 default hr_api.g_varchar2
169: ,p_bep_attribute11 in varchar2 default hr_api.g_varchar2
170: ,p_bep_attribute12 in varchar2 default hr_api.g_varchar2
171: ,p_bep_attribute13 in varchar2 default hr_api.g_varchar2
164: ,p_bep_attribute6 in varchar2 default hr_api.g_varchar2
165: ,p_bep_attribute7 in varchar2 default hr_api.g_varchar2
166: ,p_bep_attribute8 in varchar2 default hr_api.g_varchar2
167: ,p_bep_attribute9 in varchar2 default hr_api.g_varchar2
168: ,p_bep_attribute10 in varchar2 default hr_api.g_varchar2
169: ,p_bep_attribute11 in varchar2 default hr_api.g_varchar2
170: ,p_bep_attribute12 in varchar2 default hr_api.g_varchar2
171: ,p_bep_attribute13 in varchar2 default hr_api.g_varchar2
172: ,p_bep_attribute14 in varchar2 default hr_api.g_varchar2
165: ,p_bep_attribute7 in varchar2 default hr_api.g_varchar2
166: ,p_bep_attribute8 in varchar2 default hr_api.g_varchar2
167: ,p_bep_attribute9 in varchar2 default hr_api.g_varchar2
168: ,p_bep_attribute10 in varchar2 default hr_api.g_varchar2
169: ,p_bep_attribute11 in varchar2 default hr_api.g_varchar2
170: ,p_bep_attribute12 in varchar2 default hr_api.g_varchar2
171: ,p_bep_attribute13 in varchar2 default hr_api.g_varchar2
172: ,p_bep_attribute14 in varchar2 default hr_api.g_varchar2
173: ,p_bep_attribute15 in varchar2 default hr_api.g_varchar2
166: ,p_bep_attribute8 in varchar2 default hr_api.g_varchar2
167: ,p_bep_attribute9 in varchar2 default hr_api.g_varchar2
168: ,p_bep_attribute10 in varchar2 default hr_api.g_varchar2
169: ,p_bep_attribute11 in varchar2 default hr_api.g_varchar2
170: ,p_bep_attribute12 in varchar2 default hr_api.g_varchar2
171: ,p_bep_attribute13 in varchar2 default hr_api.g_varchar2
172: ,p_bep_attribute14 in varchar2 default hr_api.g_varchar2
173: ,p_bep_attribute15 in varchar2 default hr_api.g_varchar2
174: ,p_bep_attribute16 in varchar2 default hr_api.g_varchar2
167: ,p_bep_attribute9 in varchar2 default hr_api.g_varchar2
168: ,p_bep_attribute10 in varchar2 default hr_api.g_varchar2
169: ,p_bep_attribute11 in varchar2 default hr_api.g_varchar2
170: ,p_bep_attribute12 in varchar2 default hr_api.g_varchar2
171: ,p_bep_attribute13 in varchar2 default hr_api.g_varchar2
172: ,p_bep_attribute14 in varchar2 default hr_api.g_varchar2
173: ,p_bep_attribute15 in varchar2 default hr_api.g_varchar2
174: ,p_bep_attribute16 in varchar2 default hr_api.g_varchar2
175: ,p_bep_attribute17 in varchar2 default hr_api.g_varchar2
168: ,p_bep_attribute10 in varchar2 default hr_api.g_varchar2
169: ,p_bep_attribute11 in varchar2 default hr_api.g_varchar2
170: ,p_bep_attribute12 in varchar2 default hr_api.g_varchar2
171: ,p_bep_attribute13 in varchar2 default hr_api.g_varchar2
172: ,p_bep_attribute14 in varchar2 default hr_api.g_varchar2
173: ,p_bep_attribute15 in varchar2 default hr_api.g_varchar2
174: ,p_bep_attribute16 in varchar2 default hr_api.g_varchar2
175: ,p_bep_attribute17 in varchar2 default hr_api.g_varchar2
176: ,p_bep_attribute18 in varchar2 default hr_api.g_varchar2
169: ,p_bep_attribute11 in varchar2 default hr_api.g_varchar2
170: ,p_bep_attribute12 in varchar2 default hr_api.g_varchar2
171: ,p_bep_attribute13 in varchar2 default hr_api.g_varchar2
172: ,p_bep_attribute14 in varchar2 default hr_api.g_varchar2
173: ,p_bep_attribute15 in varchar2 default hr_api.g_varchar2
174: ,p_bep_attribute16 in varchar2 default hr_api.g_varchar2
175: ,p_bep_attribute17 in varchar2 default hr_api.g_varchar2
176: ,p_bep_attribute18 in varchar2 default hr_api.g_varchar2
177: ,p_bep_attribute19 in varchar2 default hr_api.g_varchar2
170: ,p_bep_attribute12 in varchar2 default hr_api.g_varchar2
171: ,p_bep_attribute13 in varchar2 default hr_api.g_varchar2
172: ,p_bep_attribute14 in varchar2 default hr_api.g_varchar2
173: ,p_bep_attribute15 in varchar2 default hr_api.g_varchar2
174: ,p_bep_attribute16 in varchar2 default hr_api.g_varchar2
175: ,p_bep_attribute17 in varchar2 default hr_api.g_varchar2
176: ,p_bep_attribute18 in varchar2 default hr_api.g_varchar2
177: ,p_bep_attribute19 in varchar2 default hr_api.g_varchar2
178: ,p_bep_attribute20 in varchar2 default hr_api.g_varchar2
171: ,p_bep_attribute13 in varchar2 default hr_api.g_varchar2
172: ,p_bep_attribute14 in varchar2 default hr_api.g_varchar2
173: ,p_bep_attribute15 in varchar2 default hr_api.g_varchar2
174: ,p_bep_attribute16 in varchar2 default hr_api.g_varchar2
175: ,p_bep_attribute17 in varchar2 default hr_api.g_varchar2
176: ,p_bep_attribute18 in varchar2 default hr_api.g_varchar2
177: ,p_bep_attribute19 in varchar2 default hr_api.g_varchar2
178: ,p_bep_attribute20 in varchar2 default hr_api.g_varchar2
179: ,p_object_version_number in out nocopy number
172: ,p_bep_attribute14 in varchar2 default hr_api.g_varchar2
173: ,p_bep_attribute15 in varchar2 default hr_api.g_varchar2
174: ,p_bep_attribute16 in varchar2 default hr_api.g_varchar2
175: ,p_bep_attribute17 in varchar2 default hr_api.g_varchar2
176: ,p_bep_attribute18 in varchar2 default hr_api.g_varchar2
177: ,p_bep_attribute19 in varchar2 default hr_api.g_varchar2
178: ,p_bep_attribute20 in varchar2 default hr_api.g_varchar2
179: ,p_object_version_number in out nocopy number
180: ,p_effective_date in date
173: ,p_bep_attribute15 in varchar2 default hr_api.g_varchar2
174: ,p_bep_attribute16 in varchar2 default hr_api.g_varchar2
175: ,p_bep_attribute17 in varchar2 default hr_api.g_varchar2
176: ,p_bep_attribute18 in varchar2 default hr_api.g_varchar2
177: ,p_bep_attribute19 in varchar2 default hr_api.g_varchar2
178: ,p_bep_attribute20 in varchar2 default hr_api.g_varchar2
179: ,p_object_version_number in out nocopy number
180: ,p_effective_date in date
181: ,p_datetrack_mode in varchar2
174: ,p_bep_attribute16 in varchar2 default hr_api.g_varchar2
175: ,p_bep_attribute17 in varchar2 default hr_api.g_varchar2
176: ,p_bep_attribute18 in varchar2 default hr_api.g_varchar2
177: ,p_bep_attribute19 in varchar2 default hr_api.g_varchar2
178: ,p_bep_attribute20 in varchar2 default hr_api.g_varchar2
179: ,p_object_version_number in out nocopy number
180: ,p_effective_date in date
181: ,p_datetrack_mode in varchar2
182: ,p_return_status out nocopy varchar2
195: begin
196: hr_utility.set_location('Entering:'|| l_proc, 10);
197: --
198: --Convert Constant values into their corresponding boolean value
199: l_validate := hr_api.constant_to_boolean(p_constant_value => p_validate);
200: -- Issue a savepoint if operating in validation only mode
201: --
202: savepoint update_ELIG_OBJ_ELIG_PROFL;
203:
279: -- |------------------------< delete_ELIG_OBJ_ELIG_PROFL >----------------------|
280: -- ----------------------------------------------------------------------------
281: --
282: procedure delete_ELIG_OBJ_ELIG_PROFL
283: (p_validate in number default hr_api.g_false_num
284: ,p_elig_obj_elig_prfl_id in number
285: ,p_effective_start_date out nocopy date
286: ,p_effective_end_date out nocopy date
287: ,p_object_version_number in out nocopy number
305: begin
306: hr_utility.set_location('Entering:'|| l_proc, 10);
307: --
308: --Convert Constant values into their corresponding boolean value
309: l_validate := hr_api.constant_to_boolean(p_constant_value => p_validate);
310: l_effective_date := trunc(p_effective_date);
311:
312: -- Issue a savepoint if operating in validation only mode
313: --