46: ,p_gl_account_segment => p_gl_account_segment
47: ,p_payroll_cost_segment => p_payroll_cost_segment
48: );
49: exception
50: when hr_api.cannot_find_prog_unit then
51: hr_api.cannot_find_prog_unit_error
52: (
53: p_module_name => 'create_budget_gl_flex_map'
54: ,p_hook_type => 'BP'
47: ,p_payroll_cost_segment => p_payroll_cost_segment
48: );
49: exception
50: when hr_api.cannot_find_prog_unit then
51: hr_api.cannot_find_prog_unit_error
52: (
53: p_module_name => 'create_budget_gl_flex_map'
54: ,p_hook_type => 'BP'
55: );
79: ,p_payroll_cost_segment => p_payroll_cost_segment
80: ,p_object_version_number => l_object_version_number
81: );
82: exception
83: when hr_api.cannot_find_prog_unit then
84: hr_api.cannot_find_prog_unit_error
85: (p_module_name => 'create_budget_gl_flex_map'
86: ,p_hook_type => 'AP'
87: );
80: ,p_object_version_number => l_object_version_number
81: );
82: exception
83: when hr_api.cannot_find_prog_unit then
84: hr_api.cannot_find_prog_unit_error
85: (p_module_name => 'create_budget_gl_flex_map'
86: ,p_hook_type => 'AP'
87: );
88: --
94: --
95: -- When in validation only mode raise the Validate_Enabled exception
96: --
97: if p_validate then
98: raise hr_api.validate_enabled;
99: end if;
100: --
101: -- Set all output arguments
102: --
106: hr_utility.set_location(' Leaving:'||l_proc, 70);
107: --
108: exception
109: --
110: when hr_api.validate_enabled then
111: --
112: -- As the Validate_Enabled exception has been raised
113: -- we must rollback to the savepoint
114: --
138: --
139: procedure update_budget_gl_flex_map
140: (p_validate in boolean default false
141: ,p_budget_gl_flex_map_id in number
142: ,p_budget_id in number default hr_api.g_number
143: ,p_gl_account_segment in varchar2 default hr_api.g_varchar2
144: ,p_payroll_cost_segment in varchar2 default hr_api.g_varchar2
145: ,p_object_version_number in out nocopy number
146: ) is
139: procedure update_budget_gl_flex_map
140: (p_validate in boolean default false
141: ,p_budget_gl_flex_map_id in number
142: ,p_budget_id in number default hr_api.g_number
143: ,p_gl_account_segment in varchar2 default hr_api.g_varchar2
144: ,p_payroll_cost_segment in varchar2 default hr_api.g_varchar2
145: ,p_object_version_number in out nocopy number
146: ) is
147: --
140: (p_validate in boolean default false
141: ,p_budget_gl_flex_map_id in number
142: ,p_budget_id in number default hr_api.g_number
143: ,p_gl_account_segment in varchar2 default hr_api.g_varchar2
144: ,p_payroll_cost_segment in varchar2 default hr_api.g_varchar2
145: ,p_object_version_number in out nocopy number
146: ) is
147: --
148: -- Declare cursors and local variables
176: ,p_payroll_cost_segment => p_payroll_cost_segment
177: ,p_object_version_number => p_object_version_number
178: );
179: exception
180: when hr_api.cannot_find_prog_unit then
181: hr_api.cannot_find_prog_unit_error
182: (p_module_name => 'update_budget_gl_flex_map'
183: ,p_hook_type => 'BP'
184: );
177: ,p_object_version_number => p_object_version_number
178: );
179: exception
180: when hr_api.cannot_find_prog_unit then
181: hr_api.cannot_find_prog_unit_error
182: (p_module_name => 'update_budget_gl_flex_map'
183: ,p_hook_type => 'BP'
184: );
185: --
208: ,p_payroll_cost_segment => p_payroll_cost_segment
209: ,p_object_version_number => l_object_version_number
210: );
211: exception
212: when hr_api.cannot_find_prog_unit then
213: hr_api.cannot_find_prog_unit_error
214: (p_module_name => 'update_budget_gl_flex_map'
215: ,p_hook_type => 'AP'
216: );
209: ,p_object_version_number => l_object_version_number
210: );
211: exception
212: when hr_api.cannot_find_prog_unit then
213: hr_api.cannot_find_prog_unit_error
214: (p_module_name => 'update_budget_gl_flex_map'
215: ,p_hook_type => 'AP'
216: );
217: --
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: hr_utility.set_location(' Leaving:'||l_proc, 70);
235: --
236: exception
237: --
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: --
296: p_budget_gl_flex_map_id => p_budget_gl_flex_map_id
297: ,p_object_version_number => p_object_version_number
298: );
299: exception
300: when hr_api.cannot_find_prog_unit then
301: hr_api.cannot_find_prog_unit_error
302: (p_module_name => 'delete_budget_gl_flex_map'
303: ,p_hook_type => 'BP'
304: );
297: ,p_object_version_number => p_object_version_number
298: );
299: exception
300: when hr_api.cannot_find_prog_unit then
301: hr_api.cannot_find_prog_unit_error
302: (p_module_name => 'delete_budget_gl_flex_map'
303: ,p_hook_type => 'BP'
304: );
305: --
322: p_budget_gl_flex_map_id => p_budget_gl_flex_map_id
323: ,p_object_version_number => l_object_version_number
324: );
325: exception
326: when hr_api.cannot_find_prog_unit then
327: hr_api.cannot_find_prog_unit_error
328: (p_module_name => 'delete_budget_gl_flex_map'
329: ,p_hook_type => 'AP'
330: );
323: ,p_object_version_number => l_object_version_number
324: );
325: exception
326: when hr_api.cannot_find_prog_unit then
327: hr_api.cannot_find_prog_unit_error
328: (p_module_name => 'delete_budget_gl_flex_map'
329: ,p_hook_type => 'AP'
330: );
331: --
337: --
338: -- When in validation only mode raise the Validate_Enabled exception
339: --
340: if p_validate then
341: raise hr_api.validate_enabled;
342: end if;
343: --
344: hr_utility.set_location(' Leaving:'||l_proc, 70);
345: --
344: hr_utility.set_location(' Leaving:'||l_proc, 70);
345: --
346: exception
347: --
348: when hr_api.validate_enabled then
349: --
350: -- As the Validate_Enabled exception has been raised
351: -- we must rollback to the savepoint
352: --