50: ,p_business_group_id => p_business_group_id
51: );
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_ENT_MINUTES'
57: ,p_hook_type => 'BP'
58: );
51: );
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_ENT_MINUTES'
57: ,p_hook_type => 'BP'
58: );
59: end;
89: );
90:
91:
92: exception
93: when hr_api.cannot_find_prog_unit then
94: hr_api.cannot_find_prog_unit_error
95: (p_module_name => 'CREATE_ENT_MINUTES'
96: ,p_hook_type => 'AP'
97: );
90:
91:
92: exception
93: when hr_api.cannot_find_prog_unit then
94: hr_api.cannot_find_prog_unit_error
95: (p_module_name => 'CREATE_ENT_MINUTES'
96: ,p_hook_type => 'AP'
97: );
98: end;
99: --
100: -- When in validation only mode raise the Validate_Enabled exception
101: --
102: if p_validate then
103: raise hr_api.validate_enabled;
104: end if;
105: --
106: -- Set all output arguments
107: --
110:
111: --
112: hr_utility.set_location(' Leaving:'||l_proc, 70);
113: exception
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: --
145: (p_validate in boolean default false
146: ,p_effective_date in date
147: ,p_ENT_MINUTES_ID in number
148: ,p_object_version_number in out nocopy number
149: ,p_TARIFF_Group_CD in varchar2 default hr_api.g_varchar2
150: ,p_ent_minutes_CD In Varchar2 default hr_api.g_varchar2
151: ,p_description in varchar2 default hr_api.g_varchar2
152: ,p_business_group_id in number default hr_api.g_number
153: ) is
146: ,p_effective_date in date
147: ,p_ENT_MINUTES_ID in number
148: ,p_object_version_number in out nocopy number
149: ,p_TARIFF_Group_CD in varchar2 default hr_api.g_varchar2
150: ,p_ent_minutes_CD In Varchar2 default hr_api.g_varchar2
151: ,p_description in varchar2 default hr_api.g_varchar2
152: ,p_business_group_id in number default hr_api.g_number
153: ) is
154:
147: ,p_ENT_MINUTES_ID in number
148: ,p_object_version_number in out nocopy number
149: ,p_TARIFF_Group_CD in varchar2 default hr_api.g_varchar2
150: ,p_ent_minutes_CD In Varchar2 default hr_api.g_varchar2
151: ,p_description in varchar2 default hr_api.g_varchar2
152: ,p_business_group_id in number default hr_api.g_number
153: ) is
154:
155: l_proc varchar2(72) := g_package||'Update_ENT_MINUTES';
148: ,p_object_version_number in out nocopy number
149: ,p_TARIFF_Group_CD in varchar2 default hr_api.g_varchar2
150: ,p_ent_minutes_CD In Varchar2 default hr_api.g_varchar2
151: ,p_description in varchar2 default hr_api.g_varchar2
152: ,p_business_group_id in number default hr_api.g_number
153: ) is
154:
155: l_proc varchar2(72) := g_package||'Update_ENT_MINUTES';
156: l_object_Version_Number PQH_DE_ENT_MINUTES.OBJECT_VERSION_NUMBER%TYPE := P_Object_version_Number;
180: ,p_business_group_id => p_business_group_id
181: );
182:
183: exception
184: when hr_api.cannot_find_prog_unit then
185: hr_api.cannot_find_prog_unit_error
186: (p_module_name => 'UPDATE_ENT_MINUTES'
187: ,p_hook_type => 'BP'
188: );
181: );
182:
183: exception
184: when hr_api.cannot_find_prog_unit then
185: hr_api.cannot_find_prog_unit_error
186: (p_module_name => 'UPDATE_ENT_MINUTES'
187: ,p_hook_type => 'BP'
188: );
189: end;
213: ,p_business_group_id => p_business_group_id
214: );
215:
216: exception
217: when hr_api.cannot_find_prog_unit then
218: hr_api.cannot_find_prog_unit_error
219: (p_module_name => 'UPDATE_ENT_MINUTES'
220: ,p_hook_type => 'AP'
221: );
214: );
215:
216: exception
217: when hr_api.cannot_find_prog_unit then
218: hr_api.cannot_find_prog_unit_error
219: (p_module_name => 'UPDATE_ENT_MINUTES'
220: ,p_hook_type => 'AP'
221: );
222: end;
223: --
224: -- When in validation only mode raise the Validate_Enabled exception
225: --
226: if p_validate then
227: raise hr_api.validate_enabled;
228: end if;
229: --
230: -- Set all output arguments
231: --
234:
235: --
236: hr_utility.set_location(' Leaving:'||l_proc, 70);
237: exception
238: when hr_api.validate_enabled then
239: --
240: -- As the Validate_Enabled exception has been raised
241: -- we must rollback to the savepoint
242: --
287: ,p_object_version_number => p_object_version_number);
288:
289:
290: exception
291: when hr_api.cannot_find_prog_unit then
292: hr_api.cannot_find_prog_unit_error
293: (p_module_name => 'delete_ENT_MINUTES'
294: ,p_hook_type => 'BP');
295: end;
288:
289:
290: exception
291: when hr_api.cannot_find_prog_unit then
292: hr_api.cannot_find_prog_unit_error
293: (p_module_name => 'delete_ENT_MINUTES'
294: ,p_hook_type => 'BP');
295: end;
296: --
309: (p_ENT_MINUTES_ID => p_ENT_MINUTES_ID
310: ,p_object_version_number => p_object_version_number);
311:
312: exception
313: when hr_api.cannot_find_prog_unit then
314: hr_api.cannot_find_prog_unit_error
315: (p_module_name => 'DELETE_ENT_MINUTES'
316: ,p_hook_type => 'AP');
317: end;
310: ,p_object_version_number => p_object_version_number);
311:
312: exception
313: when hr_api.cannot_find_prog_unit then
314: hr_api.cannot_find_prog_unit_error
315: (p_module_name => 'DELETE_ENT_MINUTES'
316: ,p_hook_type => 'AP');
317: end;
318: --
318: --
319: -- When in validation only mode raise the Validate_Enabled exception
320: --
321: if p_validate then
322: raise hr_api.validate_enabled;
323: end if;
324: --
325: -- Set all output arguments
326: --
325: -- Set all output arguments
326: --
327: hr_utility.set_location(' Leaving:'||l_proc, 70);
328: exception
329: when hr_api.validate_enabled then
330: --
331: -- As the Validate_Enabled exception has been raised
332: -- we must rollback to the savepoint
333: --