50: ,p_primary_flag => p_primary_flag
51: ,p_object_version_number => p_object_version_number
52: );
53: exception
54: when hr_api.cannot_find_prog_unit then
55: hr_api.cannot_find_prog_unit_error
56: (p_module_name => 'CREATE_CHAT_OBJ_INCLUSION'
57: ,p_hook_type => 'BP'
58: );
51: ,p_object_version_number => p_object_version_number
52: );
53: exception
54: when hr_api.cannot_find_prog_unit then
55: hr_api.cannot_find_prog_unit_error
56: (p_module_name => 'CREATE_CHAT_OBJ_INCLUSION'
57: ,p_hook_type => 'BP'
58: );
59: end;
92: ,p_primary_flag => p_primary_flag
93: ,p_object_version_number => p_object_version_number
94: );
95: exception
96: when hr_api.cannot_find_prog_unit then
97: hr_api.cannot_find_prog_unit_error
98: (p_module_name => 'CREATE_CHAT_OBJ_INCLUSION'
99: ,p_hook_type => 'AP'
100: );
93: ,p_object_version_number => p_object_version_number
94: );
95: exception
96: when hr_api.cannot_find_prog_unit then
97: hr_api.cannot_find_prog_unit_error
98: (p_module_name => 'CREATE_CHAT_OBJ_INCLUSION'
99: ,p_hook_type => 'AP'
100: );
101: end;
104: --
105: -- When in validation only mode raise the Validate_Enabled exception
106: --
107: if p_validate then
108: raise hr_api.validate_enabled;
109: end if;
110: --
111: -- Set all output arguments
112: --
114:
115:
116: hr_utility.set_location(' Leaving:'||l_proc, 70);
117: exception
118: when hr_api.validate_enabled then
119: --
120: -- As the Validate_Enabled exception has been raised
121: -- we must rollback to the savepoint
122: --
146: p_validate in boolean default false
147: ,p_effective_date in date
148: ,p_object_id in number
149: ,p_object_type in varchar2
150: ,p_primary_flag in varchar2 default hr_api.g_varchar2
151: ,p_start_date_active in date default hr_api.g_date
152: ,p_end_date_active in date default hr_api.g_date
153: ,p_chat_id in number
154: ,p_object_version_number in out nocopy number
147: ,p_effective_date in date
148: ,p_object_id in number
149: ,p_object_type in varchar2
150: ,p_primary_flag in varchar2 default hr_api.g_varchar2
151: ,p_start_date_active in date default hr_api.g_date
152: ,p_end_date_active in date default hr_api.g_date
153: ,p_chat_id in number
154: ,p_object_version_number in out nocopy number
155: ) is
148: ,p_object_id in number
149: ,p_object_type in varchar2
150: ,p_primary_flag in varchar2 default hr_api.g_varchar2
151: ,p_start_date_active in date default hr_api.g_date
152: ,p_end_date_active in date default hr_api.g_date
153: ,p_chat_id in number
154: ,p_object_version_number in out nocopy number
155: ) is
156: --
183: ,p_primary_flag => p_primary_flag
184: ,p_object_version_number => l_object_version_number
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_CHAT_OBJ_INCLUSION'
190: ,p_hook_type => 'BP'
191: );
184: ,p_object_version_number => l_object_version_number
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_CHAT_OBJ_INCLUSION'
190: ,p_hook_type => 'BP'
191: );
192: end;
225: ,p_primary_flag => p_primary_flag
226: ,p_object_version_number => l_object_version_number
227: );
228: exception
229: when hr_api.cannot_find_prog_unit then
230: hr_api.cannot_find_prog_unit_error
231: (p_module_name => 'UPDATE_CHAT_OBJ_INCLUSION'
232: ,p_hook_type => 'AP'
233: );
226: ,p_object_version_number => l_object_version_number
227: );
228: exception
229: when hr_api.cannot_find_prog_unit then
230: hr_api.cannot_find_prog_unit_error
231: (p_module_name => 'UPDATE_CHAT_OBJ_INCLUSION'
232: ,p_hook_type => 'AP'
233: );
234: end;
237: --
238: -- When in validation only mode raise the Validate_Enabled exception
239: --
240: if p_validate then
241: raise hr_api.validate_enabled;
242: end if;
243: --
244: -- Set all output arguments
245: --
244: -- Set all output arguments
245: --
246: hr_utility.set_location(' Leaving:'||l_proc, 70);
247: exception
248: when hr_api.validate_enabled then
249: --
250: -- As the Validate_Enabled exception has been raised
251: -- we must rollback to the savepoint
252: --
305: ,p_object_type => p_object_type
306: ,p_object_version_number => p_object_version_number
307: );
308: exception
309: when hr_api.cannot_find_prog_unit then
310: hr_api.cannot_find_prog_unit_error
311: (p_module_name => 'DELETE_CHAT_OBJ_INCLUSION'
312: ,p_hook_type => 'BP'
313: );
306: ,p_object_version_number => p_object_version_number
307: );
308: exception
309: when hr_api.cannot_find_prog_unit then
310: hr_api.cannot_find_prog_unit_error
311: (p_module_name => 'DELETE_CHAT_OBJ_INCLUSION'
312: ,p_hook_type => 'BP'
313: );
314: end;
337: ,p_object_type => p_object_type
338: ,p_object_version_number => p_object_version_number
339: );
340: exception
341: when hr_api.cannot_find_prog_unit then
342: hr_api.cannot_find_prog_unit_error
343: (p_module_name => 'DELETE_CHAT_OBJ_INCLUSION'
344: ,p_hook_type => 'AP'
345: );
338: ,p_object_version_number => p_object_version_number
339: );
340: exception
341: when hr_api.cannot_find_prog_unit then
342: hr_api.cannot_find_prog_unit_error
343: (p_module_name => 'DELETE_CHAT_OBJ_INCLUSION'
344: ,p_hook_type => 'AP'
345: );
346: end;
347: --
348: -- When in validation only mode raise the Validate_Enabled exception
349: --
350: if p_validate then
351: raise hr_api.validate_enabled;
352: end if;
353: --
354: -- Set all output arguments
355: --
355: --
356: --
357: hr_utility.set_location(' Leaving:'||l_proc, 170);
358: exception
359: when hr_api.validate_enabled then
360: --
361: -- As the Validate_Enabled exception has been raised
362: -- we must rollback to the savepoint
363: --