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'
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: );
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: );
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: --
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: --
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: --
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
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
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
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
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
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
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
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
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
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
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
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: );
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: --
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: );
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: --
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: --
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: --
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: );
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: --
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: );
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: --
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: --
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: --