51: ,p_col_crit_cd => p_col_crit_cd
52: ,p_alct_by_cd => p_alct_by_cd
53: );
54: exception
55: when hr_api.cannot_find_prog_unit then
56: hr_api.cannot_find_prog_unit_error
57: (p_module_name => 'create_cwb_matrix'
58: ,p_hook_type => 'BP'
59: );
52: ,p_alct_by_cd => p_alct_by_cd
53: );
54: exception
55: when hr_api.cannot_find_prog_unit then
56: hr_api.cannot_find_prog_unit_error
57: (p_module_name => 'create_cwb_matrix'
58: ,p_hook_type => 'BP'
59: );
60: end;
93: ,p_object_version_number => l_object_version_number
94: );
95:
96: exception
97: when hr_api.cannot_find_prog_unit then
98: hr_api.cannot_find_prog_unit_error
99: (p_module_name => 'create_cwb_matrix'
100: ,p_hook_type => 'AP'
101: );
94: );
95:
96: exception
97: when hr_api.cannot_find_prog_unit then
98: hr_api.cannot_find_prog_unit_error
99: (p_module_name => 'create_cwb_matrix'
100: ,p_hook_type => 'AP'
101: );
102: end;
103: --
104: -- When in validation only mode raise the Validate_Enabled exception
105: --
106: if p_validate then
107: raise hr_api.validate_enabled;
108: end if;
109: --
110: -- Set all output arguments
111: --
114: --
115: hr_utility.set_location(' Leaving:'||l_proc, 70);
116: --
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: --
149: procedure update_cwb_matrix
150: (p_validate in boolean default false
151: ,p_cwb_matrix_id in number
152: ,p_effective_date in date
153: ,p_business_group_id in number default hr_api.g_number
154: ,p_name in varchar2 default hr_api.g_varchar2
155: ,p_plan_id in number default hr_api.g_number
156: ,p_matrix_typ_cd in varchar2 default hr_api.g_varchar2
157: ,p_person_id in number default hr_api.g_number
150: (p_validate in boolean default false
151: ,p_cwb_matrix_id in number
152: ,p_effective_date in date
153: ,p_business_group_id in number default hr_api.g_number
154: ,p_name in varchar2 default hr_api.g_varchar2
155: ,p_plan_id in number default hr_api.g_number
156: ,p_matrix_typ_cd in varchar2 default hr_api.g_varchar2
157: ,p_person_id in number default hr_api.g_number
158: ,p_row_crit_cd in varchar2 default hr_api.g_varchar2
151: ,p_cwb_matrix_id in number
152: ,p_effective_date in date
153: ,p_business_group_id in number default hr_api.g_number
154: ,p_name in varchar2 default hr_api.g_varchar2
155: ,p_plan_id in number default hr_api.g_number
156: ,p_matrix_typ_cd in varchar2 default hr_api.g_varchar2
157: ,p_person_id in number default hr_api.g_number
158: ,p_row_crit_cd in varchar2 default hr_api.g_varchar2
159: ,p_col_crit_cd in varchar2 default hr_api.g_varchar2
152: ,p_effective_date in date
153: ,p_business_group_id in number default hr_api.g_number
154: ,p_name in varchar2 default hr_api.g_varchar2
155: ,p_plan_id in number default hr_api.g_number
156: ,p_matrix_typ_cd in varchar2 default hr_api.g_varchar2
157: ,p_person_id in number default hr_api.g_number
158: ,p_row_crit_cd in varchar2 default hr_api.g_varchar2
159: ,p_col_crit_cd in varchar2 default hr_api.g_varchar2
160: ,p_alct_by_cd in varchar2 default hr_api.g_varchar2
153: ,p_business_group_id in number default hr_api.g_number
154: ,p_name in varchar2 default hr_api.g_varchar2
155: ,p_plan_id in number default hr_api.g_number
156: ,p_matrix_typ_cd in varchar2 default hr_api.g_varchar2
157: ,p_person_id in number default hr_api.g_number
158: ,p_row_crit_cd in varchar2 default hr_api.g_varchar2
159: ,p_col_crit_cd in varchar2 default hr_api.g_varchar2
160: ,p_alct_by_cd in varchar2 default hr_api.g_varchar2
161: ,p_object_version_number in out nocopy number
154: ,p_name in varchar2 default hr_api.g_varchar2
155: ,p_plan_id in number default hr_api.g_number
156: ,p_matrix_typ_cd in varchar2 default hr_api.g_varchar2
157: ,p_person_id in number default hr_api.g_number
158: ,p_row_crit_cd in varchar2 default hr_api.g_varchar2
159: ,p_col_crit_cd in varchar2 default hr_api.g_varchar2
160: ,p_alct_by_cd in varchar2 default hr_api.g_varchar2
161: ,p_object_version_number in out nocopy number
162: ) is
155: ,p_plan_id in number default hr_api.g_number
156: ,p_matrix_typ_cd in varchar2 default hr_api.g_varchar2
157: ,p_person_id in number default hr_api.g_number
158: ,p_row_crit_cd in varchar2 default hr_api.g_varchar2
159: ,p_col_crit_cd in varchar2 default hr_api.g_varchar2
160: ,p_alct_by_cd in varchar2 default hr_api.g_varchar2
161: ,p_object_version_number in out nocopy number
162: ) is
163: --
156: ,p_matrix_typ_cd in varchar2 default hr_api.g_varchar2
157: ,p_person_id in number default hr_api.g_number
158: ,p_row_crit_cd in varchar2 default hr_api.g_varchar2
159: ,p_col_crit_cd in varchar2 default hr_api.g_varchar2
160: ,p_alct_by_cd in varchar2 default hr_api.g_varchar2
161: ,p_object_version_number in out nocopy number
162: ) is
163: --
164: -- Declare cursors and local variables
196: ,p_object_version_number => p_object_version_number
197: );
198:
199: exception
200: when hr_api.cannot_find_prog_unit then
201: hr_api.cannot_find_prog_unit_error
202: (p_module_name => 'update_cwb_matrix'
203: ,p_hook_type => 'BP'
204: );
197: );
198:
199: exception
200: when hr_api.cannot_find_prog_unit then
201: hr_api.cannot_find_prog_unit_error
202: (p_module_name => 'update_cwb_matrix'
203: ,p_hook_type => 'BP'
204: );
205: end;
241: ,p_object_version_number => l_object_version_number
242: );
243:
244: exception
245: when hr_api.cannot_find_prog_unit then
246: hr_api.cannot_find_prog_unit_error
247: (p_module_name => 'update_cwb_matrix'
248: ,p_hook_type => 'AP'
249: );
242: );
243:
244: exception
245: when hr_api.cannot_find_prog_unit then
246: hr_api.cannot_find_prog_unit_error
247: (p_module_name => 'update_cwb_matrix'
248: ,p_hook_type => 'AP'
249: );
250: --
254: --
255: -- When in validation only mode raise the Validate_Enabled exception
256: --
257: if p_validate then
258: raise hr_api.validate_enabled;
259: end if;
260: --
261: -- Set all output arguments
262: --
264: --
265: hr_utility.set_location(' Leaving:'||l_proc, 70);
266: --
267: exception
268: when hr_api.validate_enabled then
269: --
270: -- As the Validate_Enabled exception has been raised
271: -- we must rollback to the savepoint
272: --
326: ,p_object_version_number => p_object_version_number
327: );
328:
329: exception
330: when hr_api.cannot_find_prog_unit then
331: hr_api.cannot_find_prog_unit_error
332: (p_module_name => 'delete_cwb_matrix'
333: ,p_hook_type => 'BP'
334: );
327: );
328:
329: exception
330: when hr_api.cannot_find_prog_unit then
331: hr_api.cannot_find_prog_unit_error
332: (p_module_name => 'delete_cwb_matrix'
333: ,p_hook_type => 'BP'
334: );
335: end;
353: ,p_object_version_number => l_object_version_number
354: );
355:
356: exception
357: when hr_api.cannot_find_prog_unit then
358: hr_api.cannot_find_prog_unit_error
359: (p_module_name => 'delete_cwb_matrix'
360: ,p_hook_type => 'AP'
361: );
354: );
355:
356: exception
357: when hr_api.cannot_find_prog_unit then
358: hr_api.cannot_find_prog_unit_error
359: (p_module_name => 'delete_cwb_matrix'
360: ,p_hook_type => 'AP'
361: );
362: --
366: --
367: -- When in validation only mode raise the Validate_Enabled exception
368: --
369: if p_validate then
370: raise hr_api.validate_enabled;
371: end if;
372: --
373: hr_utility.set_location(' Leaving:'||l_proc, 70);
374: --
372: --
373: hr_utility.set_location(' Leaving:'||l_proc, 70);
374: --
375: exception
376: when hr_api.validate_enabled then
377: --
378: -- As the Validate_Enabled exception has been raised
379: -- we must rollback to the savepoint
380: --