APPS.BEN_EXT_WHERE_CLAUSE_API dependencies on HR_API

Line 68: when hr_api.cannot_find_prog_unit then

64: ,p_cond_ext_data_elmt_in_rcd_id => p_cond_ext_data_elmt_in_rcd_id
65: ,p_effective_date => trunc(p_effective_date)
66: );
67: exception
68: when hr_api.cannot_find_prog_unit then
69: hr_api.cannot_find_prog_unit_error
70: (
71: p_module_name => 'CREATE_ext_where_clause'
72: ,p_hook_type => 'BP'

Line 69: hr_api.cannot_find_prog_unit_error

65: ,p_effective_date => trunc(p_effective_date)
66: );
67: exception
68: when hr_api.cannot_find_prog_unit then
69: hr_api.cannot_find_prog_unit_error
70: (
71: p_module_name => 'CREATE_ext_where_clause'
72: ,p_hook_type => 'BP'
73: );

Line 119: when hr_api.cannot_find_prog_unit then

115: ,p_cond_ext_data_elmt_in_rcd_id => p_cond_ext_data_elmt_in_rcd_id
116: ,p_effective_date => trunc(p_effective_date)
117: );
118: exception
119: when hr_api.cannot_find_prog_unit then
120: hr_api.cannot_find_prog_unit_error
121: (p_module_name => 'CREATE_ext_where_clause'
122: ,p_hook_type => 'AP'
123: );

Line 120: hr_api.cannot_find_prog_unit_error

116: ,p_effective_date => trunc(p_effective_date)
117: );
118: exception
119: when hr_api.cannot_find_prog_unit then
120: hr_api.cannot_find_prog_unit_error
121: (p_module_name => 'CREATE_ext_where_clause'
122: ,p_hook_type => 'AP'
123: );
124: --

Line 134: raise hr_api.validate_enabled;

130: --
131: -- When in validation only mode raise the Validate_Enabled exception
132: --
133: if p_validate then
134: raise hr_api.validate_enabled;
135: end if;
136: --
137: -- Set all output arguments
138: --

Line 146: when hr_api.validate_enabled then

142: hr_utility.set_location(' Leaving:'||l_proc, 70);
143: --
144: exception
145: --
146: when hr_api.validate_enabled then
147: --
148: -- As the Validate_Enabled exception has been raised
149: -- we must rollback to the savepoint
150: --

Line 178: ,p_seq_num in number default hr_api.g_number

174: --
175: procedure update_ext_where_clause
176: (p_validate in boolean default false
177: ,p_ext_where_clause_id in number
178: ,p_seq_num in number default hr_api.g_number
179: ,p_oper_cd in varchar2 default hr_api.g_varchar2
180: ,p_val in varchar2 default hr_api.g_varchar2
181: ,p_and_or_cd in varchar2 default hr_api.g_varchar2
182: ,p_ext_data_elmt_id in number default hr_api.g_number

Line 179: ,p_oper_cd in varchar2 default hr_api.g_varchar2

175: procedure update_ext_where_clause
176: (p_validate in boolean default false
177: ,p_ext_where_clause_id in number
178: ,p_seq_num in number default hr_api.g_number
179: ,p_oper_cd in varchar2 default hr_api.g_varchar2
180: ,p_val in varchar2 default hr_api.g_varchar2
181: ,p_and_or_cd in varchar2 default hr_api.g_varchar2
182: ,p_ext_data_elmt_id in number default hr_api.g_number
183: ,p_cond_ext_data_elmt_id in number default hr_api.g_number

Line 180: ,p_val in varchar2 default hr_api.g_varchar2

176: (p_validate in boolean default false
177: ,p_ext_where_clause_id in number
178: ,p_seq_num in number default hr_api.g_number
179: ,p_oper_cd in varchar2 default hr_api.g_varchar2
180: ,p_val in varchar2 default hr_api.g_varchar2
181: ,p_and_or_cd in varchar2 default hr_api.g_varchar2
182: ,p_ext_data_elmt_id in number default hr_api.g_number
183: ,p_cond_ext_data_elmt_id in number default hr_api.g_number
184: ,p_ext_rcd_in_file_id in number default hr_api.g_number

Line 181: ,p_and_or_cd in varchar2 default hr_api.g_varchar2

177: ,p_ext_where_clause_id in number
178: ,p_seq_num in number default hr_api.g_number
179: ,p_oper_cd in varchar2 default hr_api.g_varchar2
180: ,p_val in varchar2 default hr_api.g_varchar2
181: ,p_and_or_cd in varchar2 default hr_api.g_varchar2
182: ,p_ext_data_elmt_id in number default hr_api.g_number
183: ,p_cond_ext_data_elmt_id in number default hr_api.g_number
184: ,p_ext_rcd_in_file_id in number default hr_api.g_number
185: ,p_ext_data_elmt_in_rcd_id in number default hr_api.g_number

Line 182: ,p_ext_data_elmt_id in number default hr_api.g_number

178: ,p_seq_num in number default hr_api.g_number
179: ,p_oper_cd in varchar2 default hr_api.g_varchar2
180: ,p_val in varchar2 default hr_api.g_varchar2
181: ,p_and_or_cd in varchar2 default hr_api.g_varchar2
182: ,p_ext_data_elmt_id in number default hr_api.g_number
183: ,p_cond_ext_data_elmt_id in number default hr_api.g_number
184: ,p_ext_rcd_in_file_id in number default hr_api.g_number
185: ,p_ext_data_elmt_in_rcd_id in number default hr_api.g_number
186: ,p_business_group_id in number default hr_api.g_number

Line 183: ,p_cond_ext_data_elmt_id in number default hr_api.g_number

179: ,p_oper_cd in varchar2 default hr_api.g_varchar2
180: ,p_val in varchar2 default hr_api.g_varchar2
181: ,p_and_or_cd in varchar2 default hr_api.g_varchar2
182: ,p_ext_data_elmt_id in number default hr_api.g_number
183: ,p_cond_ext_data_elmt_id in number default hr_api.g_number
184: ,p_ext_rcd_in_file_id in number default hr_api.g_number
185: ,p_ext_data_elmt_in_rcd_id in number default hr_api.g_number
186: ,p_business_group_id in number default hr_api.g_number
187: ,p_legislation_code in varchar2 default hr_api.g_varchar2

Line 184: ,p_ext_rcd_in_file_id in number default hr_api.g_number

180: ,p_val in varchar2 default hr_api.g_varchar2
181: ,p_and_or_cd in varchar2 default hr_api.g_varchar2
182: ,p_ext_data_elmt_id in number default hr_api.g_number
183: ,p_cond_ext_data_elmt_id in number default hr_api.g_number
184: ,p_ext_rcd_in_file_id in number default hr_api.g_number
185: ,p_ext_data_elmt_in_rcd_id in number default hr_api.g_number
186: ,p_business_group_id in number default hr_api.g_number
187: ,p_legislation_code in varchar2 default hr_api.g_varchar2
188: ,p_object_version_number in out nocopy number

Line 185: ,p_ext_data_elmt_in_rcd_id in number default hr_api.g_number

181: ,p_and_or_cd in varchar2 default hr_api.g_varchar2
182: ,p_ext_data_elmt_id in number default hr_api.g_number
183: ,p_cond_ext_data_elmt_id in number default hr_api.g_number
184: ,p_ext_rcd_in_file_id in number default hr_api.g_number
185: ,p_ext_data_elmt_in_rcd_id in number default hr_api.g_number
186: ,p_business_group_id in number default hr_api.g_number
187: ,p_legislation_code in varchar2 default hr_api.g_varchar2
188: ,p_object_version_number in out nocopy number
189: ,p_cond_ext_data_elmt_in_rcd_id in number default hr_api.g_number

Line 186: ,p_business_group_id in number default hr_api.g_number

182: ,p_ext_data_elmt_id in number default hr_api.g_number
183: ,p_cond_ext_data_elmt_id in number default hr_api.g_number
184: ,p_ext_rcd_in_file_id in number default hr_api.g_number
185: ,p_ext_data_elmt_in_rcd_id in number default hr_api.g_number
186: ,p_business_group_id in number default hr_api.g_number
187: ,p_legislation_code in varchar2 default hr_api.g_varchar2
188: ,p_object_version_number in out nocopy number
189: ,p_cond_ext_data_elmt_in_rcd_id in number default hr_api.g_number
190: ,p_effective_date in date

Line 187: ,p_legislation_code in varchar2 default hr_api.g_varchar2

183: ,p_cond_ext_data_elmt_id in number default hr_api.g_number
184: ,p_ext_rcd_in_file_id in number default hr_api.g_number
185: ,p_ext_data_elmt_in_rcd_id in number default hr_api.g_number
186: ,p_business_group_id in number default hr_api.g_number
187: ,p_legislation_code in varchar2 default hr_api.g_varchar2
188: ,p_object_version_number in out nocopy number
189: ,p_cond_ext_data_elmt_in_rcd_id in number default hr_api.g_number
190: ,p_effective_date in date
191: ) is

Line 189: ,p_cond_ext_data_elmt_in_rcd_id in number default hr_api.g_number

185: ,p_ext_data_elmt_in_rcd_id in number default hr_api.g_number
186: ,p_business_group_id in number default hr_api.g_number
187: ,p_legislation_code in varchar2 default hr_api.g_varchar2
188: ,p_object_version_number in out nocopy number
189: ,p_cond_ext_data_elmt_in_rcd_id in number default hr_api.g_number
190: ,p_effective_date in date
191: ) is
192: --
193: -- Declare cursors and local variables

Line 234: when hr_api.cannot_find_prog_unit then

230: ,p_cond_ext_data_elmt_in_rcd_id => p_cond_ext_data_elmt_in_rcd_id
231: ,p_effective_date => trunc(p_effective_date)
232: );
233: exception
234: when hr_api.cannot_find_prog_unit then
235: hr_api.cannot_find_prog_unit_error
236: (p_module_name => 'UPDATE_ext_where_clause'
237: ,p_hook_type => 'BP'
238: );

Line 235: hr_api.cannot_find_prog_unit_error

231: ,p_effective_date => trunc(p_effective_date)
232: );
233: exception
234: when hr_api.cannot_find_prog_unit then
235: hr_api.cannot_find_prog_unit_error
236: (p_module_name => 'UPDATE_ext_where_clause'
237: ,p_hook_type => 'BP'
238: );
239: --

Line 284: when hr_api.cannot_find_prog_unit then

280: ,p_cond_ext_data_elmt_in_rcd_id => p_cond_ext_data_elmt_in_rcd_id
281: ,p_effective_date => trunc(p_effective_date)
282: );
283: exception
284: when hr_api.cannot_find_prog_unit then
285: hr_api.cannot_find_prog_unit_error
286: (p_module_name => 'UPDATE_ext_where_clause'
287: ,p_hook_type => 'AP'
288: );

Line 285: hr_api.cannot_find_prog_unit_error

281: ,p_effective_date => trunc(p_effective_date)
282: );
283: exception
284: when hr_api.cannot_find_prog_unit then
285: hr_api.cannot_find_prog_unit_error
286: (p_module_name => 'UPDATE_ext_where_clause'
287: ,p_hook_type => 'AP'
288: );
289: --

Line 299: raise hr_api.validate_enabled;

295: --
296: -- When in validation only mode raise the Validate_Enabled exception
297: --
298: if p_validate then
299: raise hr_api.validate_enabled;
300: end if;
301: --
302: -- Set all output arguments
303: --

Line 310: when hr_api.validate_enabled then

306: hr_utility.set_location(' Leaving:'||l_proc, 70);
307: --
308: exception
309: --
310: when hr_api.validate_enabled then
311: --
312: -- As the Validate_Enabled exception has been raised
313: -- we must rollback to the savepoint
314: --

Line 375: when hr_api.cannot_find_prog_unit then

371: ,p_object_version_number => p_object_version_number
372: ,p_effective_date => trunc(p_effective_date)
373: );
374: exception
375: when hr_api.cannot_find_prog_unit then
376: hr_api.cannot_find_prog_unit_error
377: (p_module_name => 'DELETE_ext_where_clause'
378: ,p_hook_type => 'BP'
379: );

Line 376: hr_api.cannot_find_prog_unit_error

372: ,p_effective_date => trunc(p_effective_date)
373: );
374: exception
375: when hr_api.cannot_find_prog_unit then
376: hr_api.cannot_find_prog_unit_error
377: (p_module_name => 'DELETE_ext_where_clause'
378: ,p_hook_type => 'BP'
379: );
380: --

Line 405: when hr_api.cannot_find_prog_unit then

401: ,p_object_version_number => l_object_version_number
402: ,p_effective_date => trunc(p_effective_date)
403: );
404: exception
405: when hr_api.cannot_find_prog_unit then
406: hr_api.cannot_find_prog_unit_error
407: (p_module_name => 'DELETE_ext_where_clause'
408: ,p_hook_type => 'AP'
409: );

Line 406: hr_api.cannot_find_prog_unit_error

402: ,p_effective_date => trunc(p_effective_date)
403: );
404: exception
405: when hr_api.cannot_find_prog_unit then
406: hr_api.cannot_find_prog_unit_error
407: (p_module_name => 'DELETE_ext_where_clause'
408: ,p_hook_type => 'AP'
409: );
410: --

Line 420: raise hr_api.validate_enabled;

416: --
417: -- When in validation only mode raise the Validate_Enabled exception
418: --
419: if p_validate then
420: raise hr_api.validate_enabled;
421: end if;
422: --
423: hr_utility.set_location(' Leaving:'||l_proc, 70);
424: --

Line 427: when hr_api.validate_enabled then

423: hr_utility.set_location(' Leaving:'||l_proc, 70);
424: --
425: exception
426: --
427: when hr_api.validate_enabled then
428: --
429: -- As the Validate_Enabled exception has been raised
430: -- we must rollback to the savepoint
431: --