APPS.BEN_ELIG_OBJ_ELIG_PROFL_SWI dependencies on HR_API

Line 11: (p_validate in number default hr_api.g_false_num

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

Line 59: l_validate := hr_api.constant_to_boolean(p_constant_value => p_validate);

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;

Line 150: (p_validate in number default hr_api.g_false_num

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

Line 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

Line 155: ,p_elig_obj_id in number default hr_api.g_number

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

Line 156: ,p_elig_prfl_id in number default hr_api.g_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
160: ,p_bep_attribute2 in varchar2 default hr_api.g_varchar2

Line 158: ,p_bep_attribute_category 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

Line 159: ,p_bep_attribute1 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

Line 160: ,p_bep_attribute2 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

Line 161: ,p_bep_attribute3 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

Line 162: ,p_bep_attribute4 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

Line 163: ,p_bep_attribute5 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

Line 164: ,p_bep_attribute6 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

Line 165: ,p_bep_attribute7 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

Line 166: ,p_bep_attribute8 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

Line 167: ,p_bep_attribute9 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

Line 168: ,p_bep_attribute10 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

Line 169: ,p_bep_attribute11 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

Line 170: ,p_bep_attribute12 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

Line 171: ,p_bep_attribute13 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

Line 172: ,p_bep_attribute14 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

Line 173: ,p_bep_attribute15 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

Line 174: ,p_bep_attribute16 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

Line 175: ,p_bep_attribute17 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

Line 176: ,p_bep_attribute18 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
180: ,p_effective_date in date

Line 177: ,p_bep_attribute19 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
181: ,p_datetrack_mode in varchar2

Line 178: ,p_bep_attribute20 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
182: ,p_return_status out nocopy varchar2

Line 199: l_validate := hr_api.constant_to_boolean(p_constant_value => p_validate);

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:

Line 283: (p_validate in number default hr_api.g_false_num

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

Line 309: l_validate := hr_api.constant_to_boolean(p_constant_value => p_validate);

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: --