51: ,P_UNIT_PERCENTAGE => p_Unit_Percentage);
52:
53:
54: exception
55: when hr_api.cannot_find_prog_unit then
56: hr_api.cannot_find_prog_unit_error
57: (p_module_name => 'Insert_Vldtn_Oprn'
58: ,p_hook_type => 'BP'
59: );
52:
53:
54: exception
55: when hr_api.cannot_find_prog_unit then
56: hr_api.cannot_find_prog_unit_error
57: (p_module_name => 'Insert_Vldtn_Oprn'
58: ,p_hook_type => 'BP'
59: );
60: end;
87: ,P_WRKPLC_VLDTN_OP_ID => l_WRKPLC_VLDTN_OP_ID
88: ,p_object_version_number => l_object_version_number);
89:
90: exception
91: when hr_api.cannot_find_prog_unit then
92: hr_api.cannot_find_prog_unit_error
93: (p_module_name => 'Insert_Vldtn_Oprn'
94: ,p_hook_type => 'AP'
95: );
88: ,p_object_version_number => l_object_version_number);
89:
90: exception
91: when hr_api.cannot_find_prog_unit then
92: hr_api.cannot_find_prog_unit_error
93: (p_module_name => 'Insert_Vldtn_Oprn'
94: ,p_hook_type => 'AP'
95: );
96: end;
97: --
98: -- When in validation only mode raise the Validate_Enabled exception
99: --
100: if p_validate then
101: raise hr_api.validate_enabled;
102: end if;
103: --
104: -- Set all output arguments
105: --
108:
109: --
110: hr_utility.set_location(' Leaving:'||l_proc, 70);
111: exception
112: when hr_api.validate_enabled then
113: --
114: -- As the Validate_Enabled exception has been raised
115: -- we must rollback to the savepoint
116: --
142:
143: procedure Update_Vldtn_Oprn
144: (p_validate in boolean default false
145: ,p_effective_date in date
146: ,p_business_group_id in number Default hr_api.g_Number
147: ,P_WRKPLC_VLDTN_VER_ID In Number Default hr_api.g_Number
148: ,P_WRKPLC_OPERATION_ID In Number Default hr_api.g_Number
149: ,P_DESCRIPTION In Varchar2 Default hr_api.g_Varchar2
150: ,P_UNIT_PERCENTAGE In Number Default hr_api.g_Number
143: procedure Update_Vldtn_Oprn
144: (p_validate in boolean default false
145: ,p_effective_date in date
146: ,p_business_group_id in number Default hr_api.g_Number
147: ,P_WRKPLC_VLDTN_VER_ID In Number Default hr_api.g_Number
148: ,P_WRKPLC_OPERATION_ID In Number Default hr_api.g_Number
149: ,P_DESCRIPTION In Varchar2 Default hr_api.g_Varchar2
150: ,P_UNIT_PERCENTAGE In Number Default hr_api.g_Number
151: ,P_WRKPLC_VLDTN_OP_ID In Number
144: (p_validate in boolean default false
145: ,p_effective_date in date
146: ,p_business_group_id in number Default hr_api.g_Number
147: ,P_WRKPLC_VLDTN_VER_ID In Number Default hr_api.g_Number
148: ,P_WRKPLC_OPERATION_ID In Number Default hr_api.g_Number
149: ,P_DESCRIPTION In Varchar2 Default hr_api.g_Varchar2
150: ,P_UNIT_PERCENTAGE In Number Default hr_api.g_Number
151: ,P_WRKPLC_VLDTN_OP_ID In Number
152: ,p_object_version_number In out nocopy number) Is
145: ,p_effective_date in date
146: ,p_business_group_id in number Default hr_api.g_Number
147: ,P_WRKPLC_VLDTN_VER_ID In Number Default hr_api.g_Number
148: ,P_WRKPLC_OPERATION_ID In Number Default hr_api.g_Number
149: ,P_DESCRIPTION In Varchar2 Default hr_api.g_Varchar2
150: ,P_UNIT_PERCENTAGE In Number Default hr_api.g_Number
151: ,P_WRKPLC_VLDTN_OP_ID In Number
152: ,p_object_version_number In out nocopy number) Is
153:
146: ,p_business_group_id in number Default hr_api.g_Number
147: ,P_WRKPLC_VLDTN_VER_ID In Number Default hr_api.g_Number
148: ,P_WRKPLC_OPERATION_ID In Number Default hr_api.g_Number
149: ,P_DESCRIPTION In Varchar2 Default hr_api.g_Varchar2
150: ,P_UNIT_PERCENTAGE In Number Default hr_api.g_Number
151: ,P_WRKPLC_VLDTN_OP_ID In Number
152: ,p_object_version_number In out nocopy number) Is
153:
154: l_proc varchar2(72) := g_package||'Update_Vldtn_Oprn';
180: ,P_WRKPLC_VLDTN_OP_ID => P_WRKPLC_VLDTN_OP_ID
181: ,p_object_version_number => l_object_version_number);
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_Vldtn_Oprn'
187: ,p_hook_type => 'BP'
188: );
181: ,p_object_version_number => l_object_version_number);
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_Vldtn_Oprn'
187: ,p_hook_type => 'BP'
188: );
189: end;
214: ,P_WRKPLC_VLDTN_OP_ID => P_WRKPLC_VLDTN_OP_ID
215: ,p_object_version_number => l_object_version_number);
216:
217: exception
218: when hr_api.cannot_find_prog_unit then
219: hr_api.cannot_find_prog_unit_error
220: (p_module_name => 'Insert_Vldtn_Oprn'
221: ,p_hook_type => 'AP'
222: );
215: ,p_object_version_number => l_object_version_number);
216:
217: exception
218: when hr_api.cannot_find_prog_unit then
219: hr_api.cannot_find_prog_unit_error
220: (p_module_name => 'Insert_Vldtn_Oprn'
221: ,p_hook_type => 'AP'
222: );
223: end;
224: --
225: -- When in validation only mode raise the Validate_Enabled exception
226: --
227: if p_validate then
228: raise hr_api.validate_enabled;
229: end if;
230: --
231: -- Set all output arguments
232: --
235:
236: --
237: hr_utility.set_location(' Leaving:'||l_proc, 70);
238: exception
239: when hr_api.validate_enabled then
240: --
241: -- As the Validate_Enabled exception has been raised
242: -- we must rollback to the savepoint
243: --
285: PQH_DE_VLDOPR_BK3.Delete_Vldtn_Oprn_b
286: (p_WRKPLC_VLDTN_OP_ID => p_WRKPLC_VLDTN_OP_ID
287: ,p_object_version_number => p_object_version_number);
288: exception
289: when hr_api.cannot_find_prog_unit then
290: hr_api.cannot_find_prog_unit_error
291: (p_module_name => 'delete_Vldtn_Vern'
292: ,p_hook_type => 'BP');
293: end;
286: (p_WRKPLC_VLDTN_OP_ID => p_WRKPLC_VLDTN_OP_ID
287: ,p_object_version_number => p_object_version_number);
288: exception
289: when hr_api.cannot_find_prog_unit then
290: hr_api.cannot_find_prog_unit_error
291: (p_module_name => 'delete_Vldtn_Vern'
292: ,p_hook_type => 'BP');
293: end;
294: --
306: (p_WRKPLC_VLDTN_OP_ID => p_WRKPLC_VLDTN_OP_ID
307: ,p_object_version_number => p_object_version_number);
308:
309: exception
310: when hr_api.cannot_find_prog_unit then
311: hr_api.cannot_find_prog_unit_error
312: (p_module_name => 'delete_Vldtn_Oprn'
313: ,p_hook_type => 'AP');
314: end;
307: ,p_object_version_number => p_object_version_number);
308:
309: exception
310: when hr_api.cannot_find_prog_unit then
311: hr_api.cannot_find_prog_unit_error
312: (p_module_name => 'delete_Vldtn_Oprn'
313: ,p_hook_type => 'AP');
314: end;
315: --
315: --
316: -- When in validation only mode raise the Validate_Enabled exception
317: --
318: if p_validate then
319: raise hr_api.validate_enabled;
320: end if;
321: --
322: -- Set all output arguments
323: --
322: -- Set all output arguments
323: --
324: hr_utility.set_location(' Leaving:'||l_proc, 70);
325: exception
326: when hr_api.validate_enabled then
327: --
328: -- As the Validate_Enabled exception has been raised
329: -- we must rollback to the savepoint
330: --