DBA Data[Home] [Help]

APPS.PAY_EVENT_PROCEDURES_API dependencies on HR_API

Line 50: when hr_api.cannot_find_prog_unit then

46: ,p_legislation_code => p_legislation_code
47: ,p_column_name => p_column_name
48: );
49: exception
50: when hr_api.cannot_find_prog_unit then
51: hr_api.cannot_find_prog_unit_error
52: (p_module_name => 'CREATE_EVENT_PROC',
53: p_hook_type => 'BP'
54: );

Line 51: hr_api.cannot_find_prog_unit_error

47: ,p_column_name => p_column_name
48: );
49: exception
50: when hr_api.cannot_find_prog_unit then
51: hr_api.cannot_find_prog_unit_error
52: (p_module_name => 'CREATE_EVENT_PROC',
53: p_hook_type => 'BP'
54: );
55: end;

Line 84: when hr_api.cannot_find_prog_unit then

80: ,p_event_procedure_id => l_event_procedure_id
81: ,p_object_version_number => l_object_version_number
82: );
83: exception
84: when hr_api.cannot_find_prog_unit then
85: hr_api.cannot_find_prog_unit_error
86: (p_module_name => 'CREATE_EVENT_PROC',
87: p_hook_type => 'AP'
88: );

Line 85: hr_api.cannot_find_prog_unit_error

81: ,p_object_version_number => l_object_version_number
82: );
83: exception
84: when hr_api.cannot_find_prog_unit then
85: hr_api.cannot_find_prog_unit_error
86: (p_module_name => 'CREATE_EVENT_PROC',
87: p_hook_type => 'AP'
88: );
89: end;

Line 96: raise hr_api.validate_enabled;

92: -- Bug no. 4038782
93: -- When in validation only mode raise the Validate_Enabled exception
94: --
95: if p_validate then
96: raise hr_api.validate_enabled;
97: end if;
98: --
99: p_event_procedure_id := l_event_procedure_id;
100: p_object_version_number := l_object_version_number;

Line 104: when hr_api.validate_enabled then

100: p_object_version_number := l_object_version_number;
101: --
102: exception
103: --
104: when hr_api.validate_enabled then
105: --
106: -- As the Validate_Enabled exception has been raised
107: -- we must rollback to the savepoint
108: --

Line 149: ,p_dated_table_id in number default hr_api.g_number

145: Procedure update_event_proc
146: (p_validate in boolean default false
147: ,p_event_procedure_id in number
148: ,p_object_version_number in out nocopy number
149: ,p_dated_table_id in number default hr_api.g_number
150: ,p_procedure_name in varchar2 default hr_api.g_varchar2
151: ,p_business_group_id in number default hr_api.g_number
152: ,p_legislation_code in varchar2 default hr_api.g_varchar2
153: ,p_column_name in varchar2 default hr_api.g_varchar2

Line 150: ,p_procedure_name in varchar2 default hr_api.g_varchar2

146: (p_validate in boolean default false
147: ,p_event_procedure_id in number
148: ,p_object_version_number in out nocopy number
149: ,p_dated_table_id in number default hr_api.g_number
150: ,p_procedure_name in varchar2 default hr_api.g_varchar2
151: ,p_business_group_id in number default hr_api.g_number
152: ,p_legislation_code in varchar2 default hr_api.g_varchar2
153: ,p_column_name in varchar2 default hr_api.g_varchar2
154: ) is

Line 151: ,p_business_group_id in number default hr_api.g_number

147: ,p_event_procedure_id in number
148: ,p_object_version_number in out nocopy number
149: ,p_dated_table_id in number default hr_api.g_number
150: ,p_procedure_name in varchar2 default hr_api.g_varchar2
151: ,p_business_group_id in number default hr_api.g_number
152: ,p_legislation_code in varchar2 default hr_api.g_varchar2
153: ,p_column_name in varchar2 default hr_api.g_varchar2
154: ) is
155: --

Line 152: ,p_legislation_code in varchar2 default hr_api.g_varchar2

148: ,p_object_version_number in out nocopy number
149: ,p_dated_table_id in number default hr_api.g_number
150: ,p_procedure_name in varchar2 default hr_api.g_varchar2
151: ,p_business_group_id in number default hr_api.g_number
152: ,p_legislation_code in varchar2 default hr_api.g_varchar2
153: ,p_column_name in varchar2 default hr_api.g_varchar2
154: ) is
155: --
156: -- Declare cursors and local variables

Line 153: ,p_column_name in varchar2 default hr_api.g_varchar2

149: ,p_dated_table_id in number default hr_api.g_number
150: ,p_procedure_name in varchar2 default hr_api.g_varchar2
151: ,p_business_group_id in number default hr_api.g_number
152: ,p_legislation_code in varchar2 default hr_api.g_varchar2
153: ,p_column_name in varchar2 default hr_api.g_varchar2
154: ) is
155: --
156: -- Declare cursors and local variables
157: --

Line 185: when hr_api.cannot_find_prog_unit then

181: ,p_legislation_code => p_legislation_code
182: ,p_column_name => p_column_name
183: );
184: exception
185: when hr_api.cannot_find_prog_unit then
186: hr_api.cannot_find_prog_unit_error
187: (p_module_name => 'UPDATE_EVENT_PROC',
188: p_hook_type => 'BP'
189: );

Line 186: hr_api.cannot_find_prog_unit_error

182: ,p_column_name => p_column_name
183: );
184: exception
185: when hr_api.cannot_find_prog_unit then
186: hr_api.cannot_find_prog_unit_error
187: (p_module_name => 'UPDATE_EVENT_PROC',
188: p_hook_type => 'BP'
189: );
190: end;

Line 216: when hr_api.cannot_find_prog_unit then

212: ,p_legislation_code => p_legislation_code
213: ,p_column_name => p_column_name
214: );
215: exception
216: when hr_api.cannot_find_prog_unit then
217: hr_api.cannot_find_prog_unit_error
218: (p_module_name => 'UPDATE_EVENT_PROC',
219: p_hook_type => 'AP'
220: );

Line 217: hr_api.cannot_find_prog_unit_error

213: ,p_column_name => p_column_name
214: );
215: exception
216: when hr_api.cannot_find_prog_unit then
217: hr_api.cannot_find_prog_unit_error
218: (p_module_name => 'UPDATE_EVENT_PROC',
219: p_hook_type => 'AP'
220: );
221: end;

Line 229: raise hr_api.validate_enabled;

225: -- Bug no. 4038782
226: -- When in validation only mode raise the Validate_Enabled exception
227: --
228: if p_validate then
229: raise hr_api.validate_enabled;
230: end if;
231: --
232: p_object_version_number := l_object_version_number;
233:

Line 236: when hr_api.validate_enabled then

232: p_object_version_number := l_object_version_number;
233:
234: exception
235: --
236: when hr_api.validate_enabled then
237: --
238: -- As the Validate_Enabled exception has been raised
239: -- we must rollback to the savepoint
240: --

Line 301: when hr_api.cannot_find_prog_unit then

297: p_event_procedure_id => p_event_procedure_id
298: ,p_object_version_number => l_object_version_number
299: );
300: exception
301: when hr_api.cannot_find_prog_unit then
302: hr_api.cannot_find_prog_unit_error
303: (p_module_name => 'DELETE_EVENT_PROC',
304: p_hook_type => 'BP'
305: );

Line 302: hr_api.cannot_find_prog_unit_error

298: ,p_object_version_number => l_object_version_number
299: );
300: exception
301: when hr_api.cannot_find_prog_unit then
302: hr_api.cannot_find_prog_unit_error
303: (p_module_name => 'DELETE_EVENT_PROC',
304: p_hook_type => 'BP'
305: );
306: end;

Line 325: when hr_api.cannot_find_prog_unit then

321: p_event_procedure_id => p_event_procedure_id
322: ,p_object_version_number => l_object_version_number
323: );
324: exception
325: when hr_api.cannot_find_prog_unit then
326: hr_api.cannot_find_prog_unit_error
327: (p_module_name => 'DELETE_EVENT_PROC',
328: p_hook_type => 'AP'
329: );

Line 326: hr_api.cannot_find_prog_unit_error

322: ,p_object_version_number => l_object_version_number
323: );
324: exception
325: when hr_api.cannot_find_prog_unit then
326: hr_api.cannot_find_prog_unit_error
327: (p_module_name => 'DELETE_EVENT_PROC',
328: p_hook_type => 'AP'
329: );
330: end;

Line 337: raise hr_api.validate_enabled;

333: -- Bug no. 4038782
334: -- When in validation only mode raise the Validate_Enabled exception
335: --
336: if p_validate then
337: raise hr_api.validate_enabled;
338: end if;
339: --
340: p_object_version_number := l_object_version_number;
341: --

Line 344: when hr_api.validate_enabled then

340: p_object_version_number := l_object_version_number;
341: --
342: exception
343: --
344: when hr_api.validate_enabled then
345: --
346: -- As the Validate_Enabled exception has been raised
347: -- we must rollback to the savepoint
348: --