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.PER_ESTAB_ATTENDANCES_API dependencies on HR_API

Line 108: when hr_api.cannot_find_prog_unit then

104: ,p_attribute20 => p_attribute20
105: ,p_address => p_address
106: );
107: exception
108: when hr_api.cannot_find_prog_unit then
109: hr_api.cannot_find_prog_unit_error
110: (p_module_name => 'CREATE_ATTENDED_ESTAB_b'
111: ,p_hook_type => 'BP'
112: );

Line 109: hr_api.cannot_find_prog_unit_error

105: ,p_address => p_address
106: );
107: exception
108: when hr_api.cannot_find_prog_unit then
109: hr_api.cannot_find_prog_unit_error
110: (p_module_name => 'CREATE_ATTENDED_ESTAB_b'
111: ,p_hook_type => 'BP'
112: );
113: end;

Line 194: when hr_api.cannot_find_prog_unit then

190: ,p_address => p_address
191: );
192:
193: exception
194: when hr_api.cannot_find_prog_unit then
195: hr_api.cannot_find_prog_unit_error
196: (p_module_name => 'CREATE_ATTENDED_ESTAB_a'
197: ,p_hook_type => 'AP'
198: );

Line 195: hr_api.cannot_find_prog_unit_error

191: );
192:
193: exception
194: when hr_api.cannot_find_prog_unit then
195: hr_api.cannot_find_prog_unit_error
196: (p_module_name => 'CREATE_ATTENDED_ESTAB_a'
197: ,p_hook_type => 'AP'
198: );
199: end;

Line 204: raise hr_api.validate_enabled;

200: --
201: -- When in validation only mode raise the Validate_Enabled exception
202: --
203: if p_validate then
204: raise hr_api.validate_enabled;
205: end if;
206: --
207: -- Set all output arguments
208: --

Line 214: when hr_api.validate_enabled then

210: p_attendance_id := l_attendance_id;
211: p_object_version_number := l_object_version_number;
212: hr_utility.set_location(' Leaving:'||l_proc, 70);
213: exception
214: when hr_api.validate_enabled then
215: --
216: -- As the Validate_Enabled exception has been raised
217: -- we must rollback to the savepoint
218: --

Line 252: ,p_attended_start_date in date default hr_api.g_date

248: (p_validate in boolean default false
249: ,p_effective_date in date
250: ,p_attendance_id in number
251: ,p_fulltime in varchar2
252: ,p_attended_start_date in date default hr_api.g_date
253: ,p_attended_end_date in date default hr_api.g_date
254: ,p_establishment in varchar2 default hr_api.g_varchar2
255: ,p_establishment_id in number default hr_api.g_number
256: ,p_address in varchar2 default hr_api.g_varchar2

Line 253: ,p_attended_end_date in date default hr_api.g_date

249: ,p_effective_date in date
250: ,p_attendance_id in number
251: ,p_fulltime in varchar2
252: ,p_attended_start_date in date default hr_api.g_date
253: ,p_attended_end_date in date default hr_api.g_date
254: ,p_establishment in varchar2 default hr_api.g_varchar2
255: ,p_establishment_id in number default hr_api.g_number
256: ,p_address in varchar2 default hr_api.g_varchar2
257: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 254: ,p_establishment in varchar2 default hr_api.g_varchar2

250: ,p_attendance_id in number
251: ,p_fulltime in varchar2
252: ,p_attended_start_date in date default hr_api.g_date
253: ,p_attended_end_date in date default hr_api.g_date
254: ,p_establishment in varchar2 default hr_api.g_varchar2
255: ,p_establishment_id in number default hr_api.g_number
256: ,p_address in varchar2 default hr_api.g_varchar2
257: ,p_attribute_category in varchar2 default hr_api.g_varchar2
258: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 255: ,p_establishment_id in number default hr_api.g_number

251: ,p_fulltime in varchar2
252: ,p_attended_start_date in date default hr_api.g_date
253: ,p_attended_end_date in date default hr_api.g_date
254: ,p_establishment in varchar2 default hr_api.g_varchar2
255: ,p_establishment_id in number default hr_api.g_number
256: ,p_address in varchar2 default hr_api.g_varchar2
257: ,p_attribute_category in varchar2 default hr_api.g_varchar2
258: ,p_attribute1 in varchar2 default hr_api.g_varchar2
259: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 256: ,p_address in varchar2 default hr_api.g_varchar2

252: ,p_attended_start_date in date default hr_api.g_date
253: ,p_attended_end_date in date default hr_api.g_date
254: ,p_establishment in varchar2 default hr_api.g_varchar2
255: ,p_establishment_id in number default hr_api.g_number
256: ,p_address in varchar2 default hr_api.g_varchar2
257: ,p_attribute_category in varchar2 default hr_api.g_varchar2
258: ,p_attribute1 in varchar2 default hr_api.g_varchar2
259: ,p_attribute2 in varchar2 default hr_api.g_varchar2
260: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 257: ,p_attribute_category in varchar2 default hr_api.g_varchar2

253: ,p_attended_end_date in date default hr_api.g_date
254: ,p_establishment in varchar2 default hr_api.g_varchar2
255: ,p_establishment_id in number default hr_api.g_number
256: ,p_address in varchar2 default hr_api.g_varchar2
257: ,p_attribute_category in varchar2 default hr_api.g_varchar2
258: ,p_attribute1 in varchar2 default hr_api.g_varchar2
259: ,p_attribute2 in varchar2 default hr_api.g_varchar2
260: ,p_attribute3 in varchar2 default hr_api.g_varchar2
261: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 258: ,p_attribute1 in varchar2 default hr_api.g_varchar2

254: ,p_establishment in varchar2 default hr_api.g_varchar2
255: ,p_establishment_id in number default hr_api.g_number
256: ,p_address in varchar2 default hr_api.g_varchar2
257: ,p_attribute_category in varchar2 default hr_api.g_varchar2
258: ,p_attribute1 in varchar2 default hr_api.g_varchar2
259: ,p_attribute2 in varchar2 default hr_api.g_varchar2
260: ,p_attribute3 in varchar2 default hr_api.g_varchar2
261: ,p_attribute4 in varchar2 default hr_api.g_varchar2
262: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 259: ,p_attribute2 in varchar2 default hr_api.g_varchar2

255: ,p_establishment_id in number default hr_api.g_number
256: ,p_address in varchar2 default hr_api.g_varchar2
257: ,p_attribute_category in varchar2 default hr_api.g_varchar2
258: ,p_attribute1 in varchar2 default hr_api.g_varchar2
259: ,p_attribute2 in varchar2 default hr_api.g_varchar2
260: ,p_attribute3 in varchar2 default hr_api.g_varchar2
261: ,p_attribute4 in varchar2 default hr_api.g_varchar2
262: ,p_attribute5 in varchar2 default hr_api.g_varchar2
263: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 260: ,p_attribute3 in varchar2 default hr_api.g_varchar2

256: ,p_address in varchar2 default hr_api.g_varchar2
257: ,p_attribute_category in varchar2 default hr_api.g_varchar2
258: ,p_attribute1 in varchar2 default hr_api.g_varchar2
259: ,p_attribute2 in varchar2 default hr_api.g_varchar2
260: ,p_attribute3 in varchar2 default hr_api.g_varchar2
261: ,p_attribute4 in varchar2 default hr_api.g_varchar2
262: ,p_attribute5 in varchar2 default hr_api.g_varchar2
263: ,p_attribute6 in varchar2 default hr_api.g_varchar2
264: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 261: ,p_attribute4 in varchar2 default hr_api.g_varchar2

257: ,p_attribute_category in varchar2 default hr_api.g_varchar2
258: ,p_attribute1 in varchar2 default hr_api.g_varchar2
259: ,p_attribute2 in varchar2 default hr_api.g_varchar2
260: ,p_attribute3 in varchar2 default hr_api.g_varchar2
261: ,p_attribute4 in varchar2 default hr_api.g_varchar2
262: ,p_attribute5 in varchar2 default hr_api.g_varchar2
263: ,p_attribute6 in varchar2 default hr_api.g_varchar2
264: ,p_attribute7 in varchar2 default hr_api.g_varchar2
265: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 262: ,p_attribute5 in varchar2 default hr_api.g_varchar2

258: ,p_attribute1 in varchar2 default hr_api.g_varchar2
259: ,p_attribute2 in varchar2 default hr_api.g_varchar2
260: ,p_attribute3 in varchar2 default hr_api.g_varchar2
261: ,p_attribute4 in varchar2 default hr_api.g_varchar2
262: ,p_attribute5 in varchar2 default hr_api.g_varchar2
263: ,p_attribute6 in varchar2 default hr_api.g_varchar2
264: ,p_attribute7 in varchar2 default hr_api.g_varchar2
265: ,p_attribute8 in varchar2 default hr_api.g_varchar2
266: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 263: ,p_attribute6 in varchar2 default hr_api.g_varchar2

259: ,p_attribute2 in varchar2 default hr_api.g_varchar2
260: ,p_attribute3 in varchar2 default hr_api.g_varchar2
261: ,p_attribute4 in varchar2 default hr_api.g_varchar2
262: ,p_attribute5 in varchar2 default hr_api.g_varchar2
263: ,p_attribute6 in varchar2 default hr_api.g_varchar2
264: ,p_attribute7 in varchar2 default hr_api.g_varchar2
265: ,p_attribute8 in varchar2 default hr_api.g_varchar2
266: ,p_attribute9 in varchar2 default hr_api.g_varchar2
267: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 264: ,p_attribute7 in varchar2 default hr_api.g_varchar2

260: ,p_attribute3 in varchar2 default hr_api.g_varchar2
261: ,p_attribute4 in varchar2 default hr_api.g_varchar2
262: ,p_attribute5 in varchar2 default hr_api.g_varchar2
263: ,p_attribute6 in varchar2 default hr_api.g_varchar2
264: ,p_attribute7 in varchar2 default hr_api.g_varchar2
265: ,p_attribute8 in varchar2 default hr_api.g_varchar2
266: ,p_attribute9 in varchar2 default hr_api.g_varchar2
267: ,p_attribute10 in varchar2 default hr_api.g_varchar2
268: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 265: ,p_attribute8 in varchar2 default hr_api.g_varchar2

261: ,p_attribute4 in varchar2 default hr_api.g_varchar2
262: ,p_attribute5 in varchar2 default hr_api.g_varchar2
263: ,p_attribute6 in varchar2 default hr_api.g_varchar2
264: ,p_attribute7 in varchar2 default hr_api.g_varchar2
265: ,p_attribute8 in varchar2 default hr_api.g_varchar2
266: ,p_attribute9 in varchar2 default hr_api.g_varchar2
267: ,p_attribute10 in varchar2 default hr_api.g_varchar2
268: ,p_attribute11 in varchar2 default hr_api.g_varchar2
269: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 266: ,p_attribute9 in varchar2 default hr_api.g_varchar2

262: ,p_attribute5 in varchar2 default hr_api.g_varchar2
263: ,p_attribute6 in varchar2 default hr_api.g_varchar2
264: ,p_attribute7 in varchar2 default hr_api.g_varchar2
265: ,p_attribute8 in varchar2 default hr_api.g_varchar2
266: ,p_attribute9 in varchar2 default hr_api.g_varchar2
267: ,p_attribute10 in varchar2 default hr_api.g_varchar2
268: ,p_attribute11 in varchar2 default hr_api.g_varchar2
269: ,p_attribute12 in varchar2 default hr_api.g_varchar2
270: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 267: ,p_attribute10 in varchar2 default hr_api.g_varchar2

263: ,p_attribute6 in varchar2 default hr_api.g_varchar2
264: ,p_attribute7 in varchar2 default hr_api.g_varchar2
265: ,p_attribute8 in varchar2 default hr_api.g_varchar2
266: ,p_attribute9 in varchar2 default hr_api.g_varchar2
267: ,p_attribute10 in varchar2 default hr_api.g_varchar2
268: ,p_attribute11 in varchar2 default hr_api.g_varchar2
269: ,p_attribute12 in varchar2 default hr_api.g_varchar2
270: ,p_attribute13 in varchar2 default hr_api.g_varchar2
271: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 268: ,p_attribute11 in varchar2 default hr_api.g_varchar2

264: ,p_attribute7 in varchar2 default hr_api.g_varchar2
265: ,p_attribute8 in varchar2 default hr_api.g_varchar2
266: ,p_attribute9 in varchar2 default hr_api.g_varchar2
267: ,p_attribute10 in varchar2 default hr_api.g_varchar2
268: ,p_attribute11 in varchar2 default hr_api.g_varchar2
269: ,p_attribute12 in varchar2 default hr_api.g_varchar2
270: ,p_attribute13 in varchar2 default hr_api.g_varchar2
271: ,p_attribute14 in varchar2 default hr_api.g_varchar2
272: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 269: ,p_attribute12 in varchar2 default hr_api.g_varchar2

265: ,p_attribute8 in varchar2 default hr_api.g_varchar2
266: ,p_attribute9 in varchar2 default hr_api.g_varchar2
267: ,p_attribute10 in varchar2 default hr_api.g_varchar2
268: ,p_attribute11 in varchar2 default hr_api.g_varchar2
269: ,p_attribute12 in varchar2 default hr_api.g_varchar2
270: ,p_attribute13 in varchar2 default hr_api.g_varchar2
271: ,p_attribute14 in varchar2 default hr_api.g_varchar2
272: ,p_attribute15 in varchar2 default hr_api.g_varchar2
273: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 270: ,p_attribute13 in varchar2 default hr_api.g_varchar2

266: ,p_attribute9 in varchar2 default hr_api.g_varchar2
267: ,p_attribute10 in varchar2 default hr_api.g_varchar2
268: ,p_attribute11 in varchar2 default hr_api.g_varchar2
269: ,p_attribute12 in varchar2 default hr_api.g_varchar2
270: ,p_attribute13 in varchar2 default hr_api.g_varchar2
271: ,p_attribute14 in varchar2 default hr_api.g_varchar2
272: ,p_attribute15 in varchar2 default hr_api.g_varchar2
273: ,p_attribute16 in varchar2 default hr_api.g_varchar2
274: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 271: ,p_attribute14 in varchar2 default hr_api.g_varchar2

267: ,p_attribute10 in varchar2 default hr_api.g_varchar2
268: ,p_attribute11 in varchar2 default hr_api.g_varchar2
269: ,p_attribute12 in varchar2 default hr_api.g_varchar2
270: ,p_attribute13 in varchar2 default hr_api.g_varchar2
271: ,p_attribute14 in varchar2 default hr_api.g_varchar2
272: ,p_attribute15 in varchar2 default hr_api.g_varchar2
273: ,p_attribute16 in varchar2 default hr_api.g_varchar2
274: ,p_attribute17 in varchar2 default hr_api.g_varchar2
275: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 272: ,p_attribute15 in varchar2 default hr_api.g_varchar2

268: ,p_attribute11 in varchar2 default hr_api.g_varchar2
269: ,p_attribute12 in varchar2 default hr_api.g_varchar2
270: ,p_attribute13 in varchar2 default hr_api.g_varchar2
271: ,p_attribute14 in varchar2 default hr_api.g_varchar2
272: ,p_attribute15 in varchar2 default hr_api.g_varchar2
273: ,p_attribute16 in varchar2 default hr_api.g_varchar2
274: ,p_attribute17 in varchar2 default hr_api.g_varchar2
275: ,p_attribute18 in varchar2 default hr_api.g_varchar2
276: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 273: ,p_attribute16 in varchar2 default hr_api.g_varchar2

269: ,p_attribute12 in varchar2 default hr_api.g_varchar2
270: ,p_attribute13 in varchar2 default hr_api.g_varchar2
271: ,p_attribute14 in varchar2 default hr_api.g_varchar2
272: ,p_attribute15 in varchar2 default hr_api.g_varchar2
273: ,p_attribute16 in varchar2 default hr_api.g_varchar2
274: ,p_attribute17 in varchar2 default hr_api.g_varchar2
275: ,p_attribute18 in varchar2 default hr_api.g_varchar2
276: ,p_attribute19 in varchar2 default hr_api.g_varchar2
277: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 274: ,p_attribute17 in varchar2 default hr_api.g_varchar2

270: ,p_attribute13 in varchar2 default hr_api.g_varchar2
271: ,p_attribute14 in varchar2 default hr_api.g_varchar2
272: ,p_attribute15 in varchar2 default hr_api.g_varchar2
273: ,p_attribute16 in varchar2 default hr_api.g_varchar2
274: ,p_attribute17 in varchar2 default hr_api.g_varchar2
275: ,p_attribute18 in varchar2 default hr_api.g_varchar2
276: ,p_attribute19 in varchar2 default hr_api.g_varchar2
277: ,p_attribute20 in varchar2 default hr_api.g_varchar2
278: ,p_object_version_number in out nocopy number

Line 275: ,p_attribute18 in varchar2 default hr_api.g_varchar2

271: ,p_attribute14 in varchar2 default hr_api.g_varchar2
272: ,p_attribute15 in varchar2 default hr_api.g_varchar2
273: ,p_attribute16 in varchar2 default hr_api.g_varchar2
274: ,p_attribute17 in varchar2 default hr_api.g_varchar2
275: ,p_attribute18 in varchar2 default hr_api.g_varchar2
276: ,p_attribute19 in varchar2 default hr_api.g_varchar2
277: ,p_attribute20 in varchar2 default hr_api.g_varchar2
278: ,p_object_version_number in out nocopy number
279: ) is

Line 276: ,p_attribute19 in varchar2 default hr_api.g_varchar2

272: ,p_attribute15 in varchar2 default hr_api.g_varchar2
273: ,p_attribute16 in varchar2 default hr_api.g_varchar2
274: ,p_attribute17 in varchar2 default hr_api.g_varchar2
275: ,p_attribute18 in varchar2 default hr_api.g_varchar2
276: ,p_attribute19 in varchar2 default hr_api.g_varchar2
277: ,p_attribute20 in varchar2 default hr_api.g_varchar2
278: ,p_object_version_number in out nocopy number
279: ) is
280: --

Line 277: ,p_attribute20 in varchar2 default hr_api.g_varchar2

273: ,p_attribute16 in varchar2 default hr_api.g_varchar2
274: ,p_attribute17 in varchar2 default hr_api.g_varchar2
275: ,p_attribute18 in varchar2 default hr_api.g_varchar2
276: ,p_attribute19 in varchar2 default hr_api.g_varchar2
277: ,p_attribute20 in varchar2 default hr_api.g_varchar2
278: ,p_object_version_number in out nocopy number
279: ) is
280: --
281: -- Declare cursors and local variables

Line 340: when hr_api.cannot_find_prog_unit then

336: ,p_object_version_number => l_object_version_number
337: ,p_address => p_address
338: );
339: exception
340: when hr_api.cannot_find_prog_unit then
341: hr_api.cannot_find_prog_unit_error
342: (p_module_name => 'UPDATE_ATTENDED_ESTAB_b'
343: ,p_hook_type => 'BP'
344: );

Line 341: hr_api.cannot_find_prog_unit_error

337: ,p_address => p_address
338: );
339: exception
340: when hr_api.cannot_find_prog_unit then
341: hr_api.cannot_find_prog_unit_error
342: (p_module_name => 'UPDATE_ATTENDED_ESTAB_b'
343: ,p_hook_type => 'BP'
344: );
345: end;

Line 422: when hr_api.cannot_find_prog_unit then

418: ,p_address => p_address
419: );
420:
421: exception
422: when hr_api.cannot_find_prog_unit then
423: hr_api.cannot_find_prog_unit_error
424: (p_module_name => 'UPDATE_ATTENDED_ESTAB_a'
425: ,p_hook_type => 'AP'
426: );

Line 423: hr_api.cannot_find_prog_unit_error

419: );
420:
421: exception
422: when hr_api.cannot_find_prog_unit then
423: hr_api.cannot_find_prog_unit_error
424: (p_module_name => 'UPDATE_ATTENDED_ESTAB_a'
425: ,p_hook_type => 'AP'
426: );
427: end;

Line 432: raise hr_api.validate_enabled;

428: --
429: -- When in validation only mode raise the Validate_Enabled exception
430: --
431: if p_validate then
432: raise hr_api.validate_enabled;
433: end if;
434: --
435: -- Set all output arguments
436: --

Line 441: when hr_api.validate_enabled then

437: --
438: p_object_version_number := l_object_version_number;
439: hr_utility.set_location(' Leaving:'||l_proc, 70);
440: exception
441: when hr_api.validate_enabled then
442: --
443: -- As the Validate_Enabled exception has been raised
444: -- we must rollback to the savepoint
445: --

Line 497: when hr_api.cannot_find_prog_unit then

493: (p_attendance_id => p_attendance_id
494: ,p_object_version_number => p_object_version_number
495: );
496: exception
497: when hr_api.cannot_find_prog_unit then
498: hr_api.cannot_find_prog_unit_error
499: (p_module_name => 'DELETE_ATTENDED_ESTAB_b'
500: ,p_hook_type => 'BP'
501: );

Line 498: hr_api.cannot_find_prog_unit_error

494: ,p_object_version_number => p_object_version_number
495: );
496: exception
497: when hr_api.cannot_find_prog_unit then
498: hr_api.cannot_find_prog_unit_error
499: (p_module_name => 'DELETE_ATTENDED_ESTAB_b'
500: ,p_hook_type => 'BP'
501: );
502: end;

Line 524: when hr_api.cannot_find_prog_unit then

520: ,p_object_version_number => p_object_version_number
521: );
522:
523: exception
524: when hr_api.cannot_find_prog_unit then
525: hr_api.cannot_find_prog_unit_error
526: (p_module_name => 'DELETE_ATTENDED_ESTAB_a'
527: ,p_hook_type => 'AP'
528: );

Line 525: hr_api.cannot_find_prog_unit_error

521: );
522:
523: exception
524: when hr_api.cannot_find_prog_unit then
525: hr_api.cannot_find_prog_unit_error
526: (p_module_name => 'DELETE_ATTENDED_ESTAB_a'
527: ,p_hook_type => 'AP'
528: );
529: end;

Line 534: raise hr_api.validate_enabled;

530: --
531: -- When in validation only mode raise the Validate_Enabled exception
532: --
533: if p_validate then
534: raise hr_api.validate_enabled;
535: end if;
536: --
537: -- Set all output arguments
538: --

Line 542: when hr_api.validate_enabled then

538: --
539: --
540: hr_utility.set_location(' Leaving:'||l_proc, 70);
541: exception
542: when hr_api.validate_enabled then
543: --
544: -- As the Validate_Enabled exception has been raised
545: -- we must rollback to the savepoint
546: --