eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_ACTIVITY_CATEGORY_API dependencies on HR_API

Line 101: when hr_api.cannot_find_prog_unit then

97: p_primary_flag => p_primary_flag,
98: p_category_usage_id => p_category_usage_id
99: );
100: exception
101: when hr_api.cannot_find_prog_unit then
102: hr_api.cannot_find_prog_unit_error
103: (p_module_name => 'create_act_cat_inclusion_b'
104: ,p_hook_type => 'BP'
105: );

Line 102: hr_api.cannot_find_prog_unit_error

98: p_category_usage_id => p_category_usage_id
99: );
100: exception
101: when hr_api.cannot_find_prog_unit then
102: hr_api.cannot_find_prog_unit_error
103: (p_module_name => 'create_act_cat_inclusion_b'
104: ,p_hook_type => 'BP'
105: );
106: end;

Line 184: when hr_api.cannot_find_prog_unit then

180: p_category_usage_id => p_category_usage_id
181: );
182:
183: exception
184: when hr_api.cannot_find_prog_unit then
185: hr_api.cannot_find_prog_unit_error
186: (p_module_name => 'create_act_cat_inclusion_a'
187: ,p_hook_type => 'AP'
188: );

Line 185: hr_api.cannot_find_prog_unit_error

181: );
182:
183: exception
184: when hr_api.cannot_find_prog_unit then
185: hr_api.cannot_find_prog_unit_error
186: (p_module_name => 'create_act_cat_inclusion_a'
187: ,p_hook_type => 'AP'
188: );
189: end;

Line 194: raise hr_api.validate_enabled;

190: --
191: -- When in validation only mode raise the Validate_Enabled exception
192: --
193: if p_validate then
194: raise hr_api.validate_enabled;
195: end if;
196: --
197: -- Set all output arguments
198: --

Line 204: when hr_api.validate_enabled then

200: p_object_version_number := l_object_version_number;
201: --
202: hr_utility.set_location(' Leaving:'||l_proc, 70);
203: exception
204: when hr_api.validate_enabled then
205: --
206: -- As the Validate_Enabled exception has been raised
207: -- we must rollback to the savepoint
208: --

Line 235: ,p_comments in varchar2 default hr_api.g_varchar2

231: (p_validate in boolean default false
232: ,p_effective_date in date
233: ,p_activity_version_id in number
234: ,p_activity_category in varchar2
235: ,p_comments in varchar2 default hr_api.g_varchar2
236: ,p_object_version_number in out nocopy number
237: ,p_aci_information_category in varchar2 default hr_api.g_varchar2
238: ,p_aci_information1 in varchar2 default hr_api.g_varchar2
239: ,p_aci_information2 in varchar2 default hr_api.g_varchar2

Line 237: ,p_aci_information_category in varchar2 default hr_api.g_varchar2

233: ,p_activity_version_id in number
234: ,p_activity_category in varchar2
235: ,p_comments in varchar2 default hr_api.g_varchar2
236: ,p_object_version_number in out nocopy number
237: ,p_aci_information_category in varchar2 default hr_api.g_varchar2
238: ,p_aci_information1 in varchar2 default hr_api.g_varchar2
239: ,p_aci_information2 in varchar2 default hr_api.g_varchar2
240: ,p_aci_information3 in varchar2 default hr_api.g_varchar2
241: ,p_aci_information4 in varchar2 default hr_api.g_varchar2

Line 238: ,p_aci_information1 in varchar2 default hr_api.g_varchar2

234: ,p_activity_category in varchar2
235: ,p_comments in varchar2 default hr_api.g_varchar2
236: ,p_object_version_number in out nocopy number
237: ,p_aci_information_category in varchar2 default hr_api.g_varchar2
238: ,p_aci_information1 in varchar2 default hr_api.g_varchar2
239: ,p_aci_information2 in varchar2 default hr_api.g_varchar2
240: ,p_aci_information3 in varchar2 default hr_api.g_varchar2
241: ,p_aci_information4 in varchar2 default hr_api.g_varchar2
242: ,p_aci_information5 in varchar2 default hr_api.g_varchar2

Line 239: ,p_aci_information2 in varchar2 default hr_api.g_varchar2

235: ,p_comments in varchar2 default hr_api.g_varchar2
236: ,p_object_version_number in out nocopy number
237: ,p_aci_information_category in varchar2 default hr_api.g_varchar2
238: ,p_aci_information1 in varchar2 default hr_api.g_varchar2
239: ,p_aci_information2 in varchar2 default hr_api.g_varchar2
240: ,p_aci_information3 in varchar2 default hr_api.g_varchar2
241: ,p_aci_information4 in varchar2 default hr_api.g_varchar2
242: ,p_aci_information5 in varchar2 default hr_api.g_varchar2
243: ,p_aci_information6 in varchar2 default hr_api.g_varchar2

Line 240: ,p_aci_information3 in varchar2 default hr_api.g_varchar2

236: ,p_object_version_number in out nocopy number
237: ,p_aci_information_category in varchar2 default hr_api.g_varchar2
238: ,p_aci_information1 in varchar2 default hr_api.g_varchar2
239: ,p_aci_information2 in varchar2 default hr_api.g_varchar2
240: ,p_aci_information3 in varchar2 default hr_api.g_varchar2
241: ,p_aci_information4 in varchar2 default hr_api.g_varchar2
242: ,p_aci_information5 in varchar2 default hr_api.g_varchar2
243: ,p_aci_information6 in varchar2 default hr_api.g_varchar2
244: ,p_aci_information7 in varchar2 default hr_api.g_varchar2

Line 241: ,p_aci_information4 in varchar2 default hr_api.g_varchar2

237: ,p_aci_information_category in varchar2 default hr_api.g_varchar2
238: ,p_aci_information1 in varchar2 default hr_api.g_varchar2
239: ,p_aci_information2 in varchar2 default hr_api.g_varchar2
240: ,p_aci_information3 in varchar2 default hr_api.g_varchar2
241: ,p_aci_information4 in varchar2 default hr_api.g_varchar2
242: ,p_aci_information5 in varchar2 default hr_api.g_varchar2
243: ,p_aci_information6 in varchar2 default hr_api.g_varchar2
244: ,p_aci_information7 in varchar2 default hr_api.g_varchar2
245: ,p_aci_information8 in varchar2 default hr_api.g_varchar2

Line 242: ,p_aci_information5 in varchar2 default hr_api.g_varchar2

238: ,p_aci_information1 in varchar2 default hr_api.g_varchar2
239: ,p_aci_information2 in varchar2 default hr_api.g_varchar2
240: ,p_aci_information3 in varchar2 default hr_api.g_varchar2
241: ,p_aci_information4 in varchar2 default hr_api.g_varchar2
242: ,p_aci_information5 in varchar2 default hr_api.g_varchar2
243: ,p_aci_information6 in varchar2 default hr_api.g_varchar2
244: ,p_aci_information7 in varchar2 default hr_api.g_varchar2
245: ,p_aci_information8 in varchar2 default hr_api.g_varchar2
246: ,p_aci_information9 in varchar2 default hr_api.g_varchar2

Line 243: ,p_aci_information6 in varchar2 default hr_api.g_varchar2

239: ,p_aci_information2 in varchar2 default hr_api.g_varchar2
240: ,p_aci_information3 in varchar2 default hr_api.g_varchar2
241: ,p_aci_information4 in varchar2 default hr_api.g_varchar2
242: ,p_aci_information5 in varchar2 default hr_api.g_varchar2
243: ,p_aci_information6 in varchar2 default hr_api.g_varchar2
244: ,p_aci_information7 in varchar2 default hr_api.g_varchar2
245: ,p_aci_information8 in varchar2 default hr_api.g_varchar2
246: ,p_aci_information9 in varchar2 default hr_api.g_varchar2
247: ,p_aci_information10 in varchar2 default hr_api.g_varchar2

Line 244: ,p_aci_information7 in varchar2 default hr_api.g_varchar2

240: ,p_aci_information3 in varchar2 default hr_api.g_varchar2
241: ,p_aci_information4 in varchar2 default hr_api.g_varchar2
242: ,p_aci_information5 in varchar2 default hr_api.g_varchar2
243: ,p_aci_information6 in varchar2 default hr_api.g_varchar2
244: ,p_aci_information7 in varchar2 default hr_api.g_varchar2
245: ,p_aci_information8 in varchar2 default hr_api.g_varchar2
246: ,p_aci_information9 in varchar2 default hr_api.g_varchar2
247: ,p_aci_information10 in varchar2 default hr_api.g_varchar2
248: ,p_aci_information11 in varchar2 default hr_api.g_varchar2

Line 245: ,p_aci_information8 in varchar2 default hr_api.g_varchar2

241: ,p_aci_information4 in varchar2 default hr_api.g_varchar2
242: ,p_aci_information5 in varchar2 default hr_api.g_varchar2
243: ,p_aci_information6 in varchar2 default hr_api.g_varchar2
244: ,p_aci_information7 in varchar2 default hr_api.g_varchar2
245: ,p_aci_information8 in varchar2 default hr_api.g_varchar2
246: ,p_aci_information9 in varchar2 default hr_api.g_varchar2
247: ,p_aci_information10 in varchar2 default hr_api.g_varchar2
248: ,p_aci_information11 in varchar2 default hr_api.g_varchar2
249: ,p_aci_information12 in varchar2 default hr_api.g_varchar2

Line 246: ,p_aci_information9 in varchar2 default hr_api.g_varchar2

242: ,p_aci_information5 in varchar2 default hr_api.g_varchar2
243: ,p_aci_information6 in varchar2 default hr_api.g_varchar2
244: ,p_aci_information7 in varchar2 default hr_api.g_varchar2
245: ,p_aci_information8 in varchar2 default hr_api.g_varchar2
246: ,p_aci_information9 in varchar2 default hr_api.g_varchar2
247: ,p_aci_information10 in varchar2 default hr_api.g_varchar2
248: ,p_aci_information11 in varchar2 default hr_api.g_varchar2
249: ,p_aci_information12 in varchar2 default hr_api.g_varchar2
250: ,p_aci_information13 in varchar2 default hr_api.g_varchar2

Line 247: ,p_aci_information10 in varchar2 default hr_api.g_varchar2

243: ,p_aci_information6 in varchar2 default hr_api.g_varchar2
244: ,p_aci_information7 in varchar2 default hr_api.g_varchar2
245: ,p_aci_information8 in varchar2 default hr_api.g_varchar2
246: ,p_aci_information9 in varchar2 default hr_api.g_varchar2
247: ,p_aci_information10 in varchar2 default hr_api.g_varchar2
248: ,p_aci_information11 in varchar2 default hr_api.g_varchar2
249: ,p_aci_information12 in varchar2 default hr_api.g_varchar2
250: ,p_aci_information13 in varchar2 default hr_api.g_varchar2
251: ,p_aci_information14 in varchar2 default hr_api.g_varchar2

Line 248: ,p_aci_information11 in varchar2 default hr_api.g_varchar2

244: ,p_aci_information7 in varchar2 default hr_api.g_varchar2
245: ,p_aci_information8 in varchar2 default hr_api.g_varchar2
246: ,p_aci_information9 in varchar2 default hr_api.g_varchar2
247: ,p_aci_information10 in varchar2 default hr_api.g_varchar2
248: ,p_aci_information11 in varchar2 default hr_api.g_varchar2
249: ,p_aci_information12 in varchar2 default hr_api.g_varchar2
250: ,p_aci_information13 in varchar2 default hr_api.g_varchar2
251: ,p_aci_information14 in varchar2 default hr_api.g_varchar2
252: ,p_aci_information15 in varchar2 default hr_api.g_varchar2

Line 249: ,p_aci_information12 in varchar2 default hr_api.g_varchar2

245: ,p_aci_information8 in varchar2 default hr_api.g_varchar2
246: ,p_aci_information9 in varchar2 default hr_api.g_varchar2
247: ,p_aci_information10 in varchar2 default hr_api.g_varchar2
248: ,p_aci_information11 in varchar2 default hr_api.g_varchar2
249: ,p_aci_information12 in varchar2 default hr_api.g_varchar2
250: ,p_aci_information13 in varchar2 default hr_api.g_varchar2
251: ,p_aci_information14 in varchar2 default hr_api.g_varchar2
252: ,p_aci_information15 in varchar2 default hr_api.g_varchar2
253: ,p_aci_information16 in varchar2 default hr_api.g_varchar2

Line 250: ,p_aci_information13 in varchar2 default hr_api.g_varchar2

246: ,p_aci_information9 in varchar2 default hr_api.g_varchar2
247: ,p_aci_information10 in varchar2 default hr_api.g_varchar2
248: ,p_aci_information11 in varchar2 default hr_api.g_varchar2
249: ,p_aci_information12 in varchar2 default hr_api.g_varchar2
250: ,p_aci_information13 in varchar2 default hr_api.g_varchar2
251: ,p_aci_information14 in varchar2 default hr_api.g_varchar2
252: ,p_aci_information15 in varchar2 default hr_api.g_varchar2
253: ,p_aci_information16 in varchar2 default hr_api.g_varchar2
254: ,p_aci_information17 in varchar2 default hr_api.g_varchar2

Line 251: ,p_aci_information14 in varchar2 default hr_api.g_varchar2

247: ,p_aci_information10 in varchar2 default hr_api.g_varchar2
248: ,p_aci_information11 in varchar2 default hr_api.g_varchar2
249: ,p_aci_information12 in varchar2 default hr_api.g_varchar2
250: ,p_aci_information13 in varchar2 default hr_api.g_varchar2
251: ,p_aci_information14 in varchar2 default hr_api.g_varchar2
252: ,p_aci_information15 in varchar2 default hr_api.g_varchar2
253: ,p_aci_information16 in varchar2 default hr_api.g_varchar2
254: ,p_aci_information17 in varchar2 default hr_api.g_varchar2
255: ,p_aci_information18 in varchar2 default hr_api.g_varchar2

Line 252: ,p_aci_information15 in varchar2 default hr_api.g_varchar2

248: ,p_aci_information11 in varchar2 default hr_api.g_varchar2
249: ,p_aci_information12 in varchar2 default hr_api.g_varchar2
250: ,p_aci_information13 in varchar2 default hr_api.g_varchar2
251: ,p_aci_information14 in varchar2 default hr_api.g_varchar2
252: ,p_aci_information15 in varchar2 default hr_api.g_varchar2
253: ,p_aci_information16 in varchar2 default hr_api.g_varchar2
254: ,p_aci_information17 in varchar2 default hr_api.g_varchar2
255: ,p_aci_information18 in varchar2 default hr_api.g_varchar2
256: ,p_aci_information19 in varchar2 default hr_api.g_varchar2

Line 253: ,p_aci_information16 in varchar2 default hr_api.g_varchar2

249: ,p_aci_information12 in varchar2 default hr_api.g_varchar2
250: ,p_aci_information13 in varchar2 default hr_api.g_varchar2
251: ,p_aci_information14 in varchar2 default hr_api.g_varchar2
252: ,p_aci_information15 in varchar2 default hr_api.g_varchar2
253: ,p_aci_information16 in varchar2 default hr_api.g_varchar2
254: ,p_aci_information17 in varchar2 default hr_api.g_varchar2
255: ,p_aci_information18 in varchar2 default hr_api.g_varchar2
256: ,p_aci_information19 in varchar2 default hr_api.g_varchar2
257: ,p_aci_information20 in varchar2 default hr_api.g_varchar2

Line 254: ,p_aci_information17 in varchar2 default hr_api.g_varchar2

250: ,p_aci_information13 in varchar2 default hr_api.g_varchar2
251: ,p_aci_information14 in varchar2 default hr_api.g_varchar2
252: ,p_aci_information15 in varchar2 default hr_api.g_varchar2
253: ,p_aci_information16 in varchar2 default hr_api.g_varchar2
254: ,p_aci_information17 in varchar2 default hr_api.g_varchar2
255: ,p_aci_information18 in varchar2 default hr_api.g_varchar2
256: ,p_aci_information19 in varchar2 default hr_api.g_varchar2
257: ,p_aci_information20 in varchar2 default hr_api.g_varchar2
258: ,p_start_date_active in date default hr_api.g_date

Line 255: ,p_aci_information18 in varchar2 default hr_api.g_varchar2

251: ,p_aci_information14 in varchar2 default hr_api.g_varchar2
252: ,p_aci_information15 in varchar2 default hr_api.g_varchar2
253: ,p_aci_information16 in varchar2 default hr_api.g_varchar2
254: ,p_aci_information17 in varchar2 default hr_api.g_varchar2
255: ,p_aci_information18 in varchar2 default hr_api.g_varchar2
256: ,p_aci_information19 in varchar2 default hr_api.g_varchar2
257: ,p_aci_information20 in varchar2 default hr_api.g_varchar2
258: ,p_start_date_active in date default hr_api.g_date
259: ,p_end_date_active in date default hr_api.g_date

Line 256: ,p_aci_information19 in varchar2 default hr_api.g_varchar2

252: ,p_aci_information15 in varchar2 default hr_api.g_varchar2
253: ,p_aci_information16 in varchar2 default hr_api.g_varchar2
254: ,p_aci_information17 in varchar2 default hr_api.g_varchar2
255: ,p_aci_information18 in varchar2 default hr_api.g_varchar2
256: ,p_aci_information19 in varchar2 default hr_api.g_varchar2
257: ,p_aci_information20 in varchar2 default hr_api.g_varchar2
258: ,p_start_date_active in date default hr_api.g_date
259: ,p_end_date_active in date default hr_api.g_date
260: ,p_primary_flag in varchar2 default hr_api.g_varchar2

Line 257: ,p_aci_information20 in varchar2 default hr_api.g_varchar2

253: ,p_aci_information16 in varchar2 default hr_api.g_varchar2
254: ,p_aci_information17 in varchar2 default hr_api.g_varchar2
255: ,p_aci_information18 in varchar2 default hr_api.g_varchar2
256: ,p_aci_information19 in varchar2 default hr_api.g_varchar2
257: ,p_aci_information20 in varchar2 default hr_api.g_varchar2
258: ,p_start_date_active in date default hr_api.g_date
259: ,p_end_date_active in date default hr_api.g_date
260: ,p_primary_flag in varchar2 default hr_api.g_varchar2
261: ,p_category_usage_id in number

Line 258: ,p_start_date_active in date default hr_api.g_date

254: ,p_aci_information17 in varchar2 default hr_api.g_varchar2
255: ,p_aci_information18 in varchar2 default hr_api.g_varchar2
256: ,p_aci_information19 in varchar2 default hr_api.g_varchar2
257: ,p_aci_information20 in varchar2 default hr_api.g_varchar2
258: ,p_start_date_active in date default hr_api.g_date
259: ,p_end_date_active in date default hr_api.g_date
260: ,p_primary_flag in varchar2 default hr_api.g_varchar2
261: ,p_category_usage_id in number
262: ) is

Line 259: ,p_end_date_active in date default hr_api.g_date

255: ,p_aci_information18 in varchar2 default hr_api.g_varchar2
256: ,p_aci_information19 in varchar2 default hr_api.g_varchar2
257: ,p_aci_information20 in varchar2 default hr_api.g_varchar2
258: ,p_start_date_active in date default hr_api.g_date
259: ,p_end_date_active in date default hr_api.g_date
260: ,p_primary_flag in varchar2 default hr_api.g_varchar2
261: ,p_category_usage_id in number
262: ) is
263: --

Line 260: ,p_primary_flag in varchar2 default hr_api.g_varchar2

256: ,p_aci_information19 in varchar2 default hr_api.g_varchar2
257: ,p_aci_information20 in varchar2 default hr_api.g_varchar2
258: ,p_start_date_active in date default hr_api.g_date
259: ,p_end_date_active in date default hr_api.g_date
260: ,p_primary_flag in varchar2 default hr_api.g_varchar2
261: ,p_category_usage_id in number
262: ) is
263: --
264: -- Declare cursors and local variables

Line 320: when hr_api.cannot_find_prog_unit then

316: p_category_usage_id => p_category_usage_id
317: );
318:
319: exception
320: when hr_api.cannot_find_prog_unit then
321: hr_api.cannot_find_prog_unit_error
322: (p_module_name => 'update_act_cat_inclusion_b'
323: ,p_hook_type => 'BP'
324: );

Line 321: hr_api.cannot_find_prog_unit_error

317: );
318:
319: exception
320: when hr_api.cannot_find_prog_unit then
321: hr_api.cannot_find_prog_unit_error
322: (p_module_name => 'update_act_cat_inclusion_b'
323: ,p_hook_type => 'BP'
324: );
325: end;

Line 401: when hr_api.cannot_find_prog_unit then

397: p_primary_flag => p_primary_flag,
398: p_category_usage_id => p_category_usage_id
399: );
400: exception
401: when hr_api.cannot_find_prog_unit then
402: hr_api.cannot_find_prog_unit_error
403: (p_module_name => 'update_act_cat_inclusion'
404: ,p_hook_type => 'AP'
405: );

Line 402: hr_api.cannot_find_prog_unit_error

398: p_category_usage_id => p_category_usage_id
399: );
400: exception
401: when hr_api.cannot_find_prog_unit then
402: hr_api.cannot_find_prog_unit_error
403: (p_module_name => 'update_act_cat_inclusion'
404: ,p_hook_type => 'AP'
405: );
406: end;

Line 411: raise hr_api.validate_enabled;

407: --
408: -- When in validation only mode raise the Validate_Enabled exception
409: --
410: if p_validate then
411: raise hr_api.validate_enabled;
412: end if;
413: --
414: -- Set all output arguments
415: --

Line 420: when hr_api.validate_enabled then

416: -- p_object_version_number := l_object_version_number;
417: --
418: hr_utility.set_location(' Leaving:'||l_proc, 70);
419: exception
420: when hr_api.validate_enabled then
421: --
422: -- As the Validate_Enabled exception has been raised
423: -- we must rollback to the savepoint
424: --

Line 476: when hr_api.cannot_find_prog_unit then

472: p_category_usage_id => p_category_usage_id,
473: p_object_version_number => p_object_version_number);
474:
475: exception
476: when hr_api.cannot_find_prog_unit then
477: hr_api.cannot_find_prog_unit_error
478: (p_module_name => 'delete_act_cat_inclusion_b '
479: ,p_hook_type => 'BP'
480: );

Line 477: hr_api.cannot_find_prog_unit_error

473: p_object_version_number => p_object_version_number);
474:
475: exception
476: when hr_api.cannot_find_prog_unit then
477: hr_api.cannot_find_prog_unit_error
478: (p_module_name => 'delete_act_cat_inclusion_b '
479: ,p_hook_type => 'BP'
480: );
481: end;

Line 501: when hr_api.cannot_find_prog_unit then

497: (p_activity_version_id => p_activity_version_id ,
498: p_category_usage_id => p_category_usage_id,
499: p_object_version_number => p_object_version_number);
500: exception
501: when hr_api.cannot_find_prog_unit then
502: hr_api.cannot_find_prog_unit_error
503: (p_module_name => 'delete_act_cat_inclusion_a '
504: ,p_hook_type => 'AP'
505: );

Line 502: hr_api.cannot_find_prog_unit_error

498: p_category_usage_id => p_category_usage_id,
499: p_object_version_number => p_object_version_number);
500: exception
501: when hr_api.cannot_find_prog_unit then
502: hr_api.cannot_find_prog_unit_error
503: (p_module_name => 'delete_act_cat_inclusion_a '
504: ,p_hook_type => 'AP'
505: );
506: end;

Line 511: raise hr_api.validate_enabled;

507: --
508: -- When in validation only mode raise the Validate_Enabled exception
509: --
510: if p_validate then
511: raise hr_api.validate_enabled;
512: end if;
513: --
514: -- Set all output arguments
515: --

Line 519: when hr_api.validate_enabled then

515: --
516: --
517: hr_utility.set_location(' Leaving:'||l_proc, 170);
518: exception
519: when hr_api.validate_enabled then
520: --
521: -- As the Validate_Enabled exception has been raised
522: -- we must rollback to the savepoint
523: --