48: ,p_reference_type_cd => p_reference_type_cd
49: ,p_effective_date => trunc(p_effective_date)
50: );
51: exception
52: when hr_api.cannot_find_prog_unit then
53: hr_api.cannot_find_prog_unit_error
54: (
55: p_module_name => 'CREATE_REF_TEMPLATE'
56: ,p_hook_type => 'BP'
49: ,p_effective_date => trunc(p_effective_date)
50: );
51: exception
52: when hr_api.cannot_find_prog_unit then
53: hr_api.cannot_find_prog_unit_error
54: (
55: p_module_name => 'CREATE_REF_TEMPLATE'
56: ,p_hook_type => 'BP'
57: );
83: ,p_object_version_number => l_object_version_number
84: ,p_effective_date => trunc(p_effective_date)
85: );
86: exception
87: when hr_api.cannot_find_prog_unit then
88: hr_api.cannot_find_prog_unit_error
89: (p_module_name => 'CREATE_REF_TEMPLATE'
90: ,p_hook_type => 'AP'
91: );
84: ,p_effective_date => trunc(p_effective_date)
85: );
86: exception
87: when hr_api.cannot_find_prog_unit then
88: hr_api.cannot_find_prog_unit_error
89: (p_module_name => 'CREATE_REF_TEMPLATE'
90: ,p_hook_type => 'AP'
91: );
92: --
98: --
99: -- When in validation only mode raise the Validate_Enabled exception
100: --
101: if p_validate then
102: raise hr_api.validate_enabled;
103: end if;
104: --
105: -- Set all output arguments
106: --
110: hr_utility.set_location(' Leaving:'||l_proc, 70);
111: --
112: exception
113: --
114: when hr_api.validate_enabled then
115: --
116: -- As the Validate_Enabled exception has been raised
117: -- we must rollback to the savepoint
118: --
142: --
143: procedure update_REF_TEMPLATE
144: (p_validate in boolean default false
145: ,p_ref_template_id in number
146: ,p_base_template_id in number default hr_api.g_number
147: ,p_parent_template_id in number default hr_api.g_number
148: ,p_reference_type_cd in varchar2 default hr_api.g_varchar2
149: ,p_object_version_number in out nocopy number
150: ,p_effective_date in date
143: procedure update_REF_TEMPLATE
144: (p_validate in boolean default false
145: ,p_ref_template_id in number
146: ,p_base_template_id in number default hr_api.g_number
147: ,p_parent_template_id in number default hr_api.g_number
148: ,p_reference_type_cd in varchar2 default hr_api.g_varchar2
149: ,p_object_version_number in out nocopy number
150: ,p_effective_date in date
151: ) is
144: (p_validate in boolean default false
145: ,p_ref_template_id in number
146: ,p_base_template_id in number default hr_api.g_number
147: ,p_parent_template_id in number default hr_api.g_number
148: ,p_reference_type_cd in varchar2 default hr_api.g_varchar2
149: ,p_object_version_number in out nocopy number
150: ,p_effective_date in date
151: ) is
152: --
183: ,p_effective_date => trunc(p_effective_date)
184:
185: );
186: exception
187: when hr_api.cannot_find_prog_unit then
188: hr_api.cannot_find_prog_unit_error
189: (p_module_name => 'UPDATE_REF_TEMPLATE'
190: ,p_hook_type => 'BP'
191: );
184:
185: );
186: exception
187: when hr_api.cannot_find_prog_unit then
188: hr_api.cannot_find_prog_unit_error
189: (p_module_name => 'UPDATE_REF_TEMPLATE'
190: ,p_hook_type => 'BP'
191: );
192: --
219: ,p_effective_date => trunc(p_effective_date)
220:
221: );
222: exception
223: when hr_api.cannot_find_prog_unit then
224: hr_api.cannot_find_prog_unit_error
225: (p_module_name => 'UPDATE_REF_TEMPLATE'
226: ,p_hook_type => 'AP'
227: );
220:
221: );
222: exception
223: when hr_api.cannot_find_prog_unit then
224: hr_api.cannot_find_prog_unit_error
225: (p_module_name => 'UPDATE_REF_TEMPLATE'
226: ,p_hook_type => 'AP'
227: );
228: --
234: --
235: -- When in validation only mode raise the Validate_Enabled exception
236: --
237: if p_validate then
238: raise hr_api.validate_enabled;
239: end if;
240: --
241: -- Set all output arguments
242: --
245: hr_utility.set_location(' Leaving:'||l_proc, 70);
246: --
247: exception
248: --
249: when hr_api.validate_enabled then
250: --
251: -- As the Validate_Enabled exception has been raised
252: -- we must rollback to the savepoint
253: --
310: ,p_effective_date => trunc(p_effective_date)
311:
312: );
313: exception
314: when hr_api.cannot_find_prog_unit then
315: hr_api.cannot_find_prog_unit_error
316: (p_module_name => 'DELETE_REF_TEMPLATE'
317: ,p_hook_type => 'BP'
318: );
311:
312: );
313: exception
314: when hr_api.cannot_find_prog_unit then
315: hr_api.cannot_find_prog_unit_error
316: (p_module_name => 'DELETE_REF_TEMPLATE'
317: ,p_hook_type => 'BP'
318: );
319: --
340: ,p_effective_date => trunc(p_effective_date)
341:
342: );
343: exception
344: when hr_api.cannot_find_prog_unit then
345: hr_api.cannot_find_prog_unit_error
346: (p_module_name => 'DELETE_REF_TEMPLATE'
347: ,p_hook_type => 'AP'
348: );
341:
342: );
343: exception
344: when hr_api.cannot_find_prog_unit then
345: hr_api.cannot_find_prog_unit_error
346: (p_module_name => 'DELETE_REF_TEMPLATE'
347: ,p_hook_type => 'AP'
348: );
349: --
355: --
356: -- When in validation only mode raise the Validate_Enabled exception
357: --
358: if p_validate then
359: raise hr_api.validate_enabled;
360: end if;
361: --
362: hr_utility.set_location(' Leaving:'||l_proc, 70);
363: --
362: hr_utility.set_location(' Leaving:'||l_proc, 70);
363: --
364: exception
365: --
366: when hr_api.validate_enabled then
367: --
368: -- As the Validate_Enabled exception has been raised
369: -- we must rollback to the savepoint
370: --