53: ,p_object_version_number => p_object_version_number
54: );
55:
56: exception
57: when hr_api.cannot_find_prog_unit then
58: hr_api.cannot_find_prog_unit_error
59: (p_module_name => 'create_hr_gl_flex_b'
60: ,p_hook_type => 'BP'
61: );
54: );
55:
56: exception
57: when hr_api.cannot_find_prog_unit then
58: hr_api.cannot_find_prog_unit_error
59: (p_module_name => 'create_hr_gl_flex_b'
60: ,p_hook_type => 'BP'
61: );
62: end;
98: ,p_gl_default_segment_id => p_gl_default_segment_id
99: ,p_object_version_number => p_object_version_number
100: );
101: exception
102: when hr_api.cannot_find_prog_unit then
103: hr_api.cannot_find_prog_unit_error
104: (p_module_name => 'create_hr_gl_flex_a'
105: ,p_hook_type => 'AP'
106: );
99: ,p_object_version_number => p_object_version_number
100: );
101: exception
102: when hr_api.cannot_find_prog_unit then
103: hr_api.cannot_find_prog_unit_error
104: (p_module_name => 'create_hr_gl_flex_a'
105: ,p_hook_type => 'AP'
106: );
107: end;
108: --
109: -- When in validation only mode raise the Validate_Enabled exception
110: --
111: if p_validate then
112: raise hr_api.validate_enabled;
113: end if;
114: --
115: -- Set all output arguments
116: --
119: p_some_warning :=
120: --
121: hr_utility.set_location(' Leaving:'||l_proc, 70);
122: exception
123: when hr_api.validate_enabled then
124: --
125: -- As the Validate_Enabled exception has been raised
126: -- we must rollback to the savepoint
127: --
154: procedure update_hr_gl_flex
155: (p_effective_date in date
156: ,p_gl_default_segment_id in number
157: ,p_object_version_number in out nocopy number
158: ,p_cross_charge_id in number default hr_api.g_number
159: ,p_segment in varchar2 default hr_api.g_varchar2
160: ,p_segment_num in number default hr_api.g_number
161: ,p_hr_data_source in varchar2 default hr_api.g_varchar2
162: ,p_constant in varchar2 default hr_api.g_varchar2
155: (p_effective_date in date
156: ,p_gl_default_segment_id in number
157: ,p_object_version_number in out nocopy number
158: ,p_cross_charge_id in number default hr_api.g_number
159: ,p_segment in varchar2 default hr_api.g_varchar2
160: ,p_segment_num in number default hr_api.g_number
161: ,p_hr_data_source in varchar2 default hr_api.g_varchar2
162: ,p_constant in varchar2 default hr_api.g_varchar2
163: ,p_hr_cost_segment in varchar2 default hr_api.g_varchar2
156: ,p_gl_default_segment_id in number
157: ,p_object_version_number in out nocopy number
158: ,p_cross_charge_id in number default hr_api.g_number
159: ,p_segment in varchar2 default hr_api.g_varchar2
160: ,p_segment_num in number default hr_api.g_number
161: ,p_hr_data_source in varchar2 default hr_api.g_varchar2
162: ,p_constant in varchar2 default hr_api.g_varchar2
163: ,p_hr_cost_segment in varchar2 default hr_api.g_varchar2
164: ,p_validate in boolean default false
157: ,p_object_version_number in out nocopy number
158: ,p_cross_charge_id in number default hr_api.g_number
159: ,p_segment in varchar2 default hr_api.g_varchar2
160: ,p_segment_num in number default hr_api.g_number
161: ,p_hr_data_source in varchar2 default hr_api.g_varchar2
162: ,p_constant in varchar2 default hr_api.g_varchar2
163: ,p_hr_cost_segment in varchar2 default hr_api.g_varchar2
164: ,p_validate in boolean default false
165: ) is
158: ,p_cross_charge_id in number default hr_api.g_number
159: ,p_segment in varchar2 default hr_api.g_varchar2
160: ,p_segment_num in number default hr_api.g_number
161: ,p_hr_data_source in varchar2 default hr_api.g_varchar2
162: ,p_constant in varchar2 default hr_api.g_varchar2
163: ,p_hr_cost_segment in varchar2 default hr_api.g_varchar2
164: ,p_validate in boolean default false
165: ) is
166:
159: ,p_segment in varchar2 default hr_api.g_varchar2
160: ,p_segment_num in number default hr_api.g_number
161: ,p_hr_data_source in varchar2 default hr_api.g_varchar2
162: ,p_constant in varchar2 default hr_api.g_varchar2
163: ,p_hr_cost_segment in varchar2 default hr_api.g_varchar2
164: ,p_validate in boolean default false
165: ) is
166:
167:
193: ,p_gl_default_segment_id => p_gl_default_segment_id
194: ,p_object_version_number => p_object_version_number
195: );
196: exception
197: when hr_api.cannot_find_prog_unit then
198: hr_api.cannot_find_prog_unit_error
199: (p_module_name => 'update_hr_gl_flex_b'
200: ,p_hook_type => 'BP'
201: );
194: ,p_object_version_number => p_object_version_number
195: );
196: exception
197: when hr_api.cannot_find_prog_unit then
198: hr_api.cannot_find_prog_unit_error
199: (p_module_name => 'update_hr_gl_flex_b'
200: ,p_hook_type => 'BP'
201: );
202: end;
240: ,p_object_version_number => p_object_version_number
241: );
242:
243: exception
244: when hr_api.cannot_find_prog_unit then
245: hr_api.cannot_find_prog_unit_error
246: (p_module_name => 'update_hr_gl_flex_a'
247: ,p_hook_type => 'AP'
248: );
241: );
242:
243: exception
244: when hr_api.cannot_find_prog_unit then
245: hr_api.cannot_find_prog_unit_error
246: (p_module_name => 'update_hr_gl_flex_a'
247: ,p_hook_type => 'AP'
248: );
249: end;
250: --
251: -- When in validation only mode raise the Validate_Enabled exception
252: --
253: if p_validate then
254: raise hr_api.validate_enabled;
255: end if;
256: --
257: -- Set all output arguments
258: --
261: p_some_warning :=
262: --
263: hr_utility.set_location(' Leaving:'||l_proc, 70);
264: exception
265: when hr_api.validate_enabled then
266: --
267: -- As the Validate_Enabled exception has been raised
268: -- we must rollback to the savepoint
269: --