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_SWI dependencies on HR_API

Line 12: (p_validate in number default hr_api.g_false_num

8: -- ----------------------------------------------------------------------------
9: -- |-------------------------< create_attended_estab >------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_attended_estab
12: (p_validate in number default hr_api.g_false_num
13: ,p_effective_date in date
14: ,p_fulltime in varchar2
15: ,p_attended_start_date in date
16: ,p_attended_end_date in date default null

Line 74: hr_api.constant_to_boolean

70: --
71: -- Convert constant values to their corresponding boolean value
72: --
73: l_validate :=
74: hr_api.constant_to_boolean
75: (p_constant_value => p_validate);
76: --
77: -- Register Surrogate ID or user key values
78: --

Line 174: (p_validate in number default hr_api.g_false_num

170: -- ----------------------------------------------------------------------------
171: -- |-------------------------< delete_attended_estab >------------------------|
172: -- ----------------------------------------------------------------------------
173: PROCEDURE delete_attended_estab
174: (p_validate in number default hr_api.g_false_num
175: ,p_attendance_id in number
176: ,p_object_version_number in number
177: ,p_return_status out nocopy varchar2
178: ) is

Line 204: hr_api.constant_to_boolean

200: --
201: -- Convert constant values to their corresponding boolean value
202: --
203: l_validate :=
204: hr_api.constant_to_boolean
205: (p_constant_value => p_validate);
206: --
207: -- Register Surrogate ID or user key values
208: --

Line 268: (p_validate in number default hr_api.g_false_num

264: -- ----------------------------------------------------------------------------
265: -- |-------------------------< update_attended_estab >------------------------|
266: -- ----------------------------------------------------------------------------
267: PROCEDURE update_attended_estab
268: (p_validate in number default hr_api.g_false_num
269: ,p_effective_date in date
270: ,p_attendance_id in number
271: ,p_fulltime in varchar2
272: ,p_attended_start_date in date

Line 273: ,p_attended_end_date in date default hr_api.g_date

269: ,p_effective_date in date
270: ,p_attendance_id in number
271: ,p_fulltime in varchar2
272: ,p_attended_start_date in date
273: ,p_attended_end_date in date default hr_api.g_date
274: ,p_establishment in varchar2 default hr_api.g_varchar2
275: ,p_establishment_id in number default hr_api.g_number
276: ,p_address in varchar2 default hr_api.g_varchar2
277: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 274: ,p_establishment in varchar2 default hr_api.g_varchar2

270: ,p_attendance_id in number
271: ,p_fulltime in varchar2
272: ,p_attended_start_date in date
273: ,p_attended_end_date in date default hr_api.g_date
274: ,p_establishment in varchar2 default hr_api.g_varchar2
275: ,p_establishment_id in number default hr_api.g_number
276: ,p_address in varchar2 default hr_api.g_varchar2
277: ,p_attribute_category in varchar2 default hr_api.g_varchar2
278: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 275: ,p_establishment_id in number default hr_api.g_number

271: ,p_fulltime in varchar2
272: ,p_attended_start_date in date
273: ,p_attended_end_date in date default hr_api.g_date
274: ,p_establishment in varchar2 default hr_api.g_varchar2
275: ,p_establishment_id in number default hr_api.g_number
276: ,p_address in varchar2 default hr_api.g_varchar2
277: ,p_attribute_category in varchar2 default hr_api.g_varchar2
278: ,p_attribute1 in varchar2 default hr_api.g_varchar2
279: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 276: ,p_address in varchar2 default hr_api.g_varchar2

272: ,p_attended_start_date in date
273: ,p_attended_end_date in date default hr_api.g_date
274: ,p_establishment in varchar2 default hr_api.g_varchar2
275: ,p_establishment_id in number default hr_api.g_number
276: ,p_address in varchar2 default hr_api.g_varchar2
277: ,p_attribute_category in varchar2 default hr_api.g_varchar2
278: ,p_attribute1 in varchar2 default hr_api.g_varchar2
279: ,p_attribute2 in varchar2 default hr_api.g_varchar2
280: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 277: ,p_attribute_category in varchar2 default hr_api.g_varchar2

273: ,p_attended_end_date in date default hr_api.g_date
274: ,p_establishment in varchar2 default hr_api.g_varchar2
275: ,p_establishment_id in number default hr_api.g_number
276: ,p_address in varchar2 default hr_api.g_varchar2
277: ,p_attribute_category in varchar2 default hr_api.g_varchar2
278: ,p_attribute1 in varchar2 default hr_api.g_varchar2
279: ,p_attribute2 in varchar2 default hr_api.g_varchar2
280: ,p_attribute3 in varchar2 default hr_api.g_varchar2
281: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 278: ,p_attribute1 in varchar2 default hr_api.g_varchar2

274: ,p_establishment in varchar2 default hr_api.g_varchar2
275: ,p_establishment_id in number default hr_api.g_number
276: ,p_address in varchar2 default hr_api.g_varchar2
277: ,p_attribute_category in varchar2 default hr_api.g_varchar2
278: ,p_attribute1 in varchar2 default hr_api.g_varchar2
279: ,p_attribute2 in varchar2 default hr_api.g_varchar2
280: ,p_attribute3 in varchar2 default hr_api.g_varchar2
281: ,p_attribute4 in varchar2 default hr_api.g_varchar2
282: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 279: ,p_attribute2 in varchar2 default hr_api.g_varchar2

275: ,p_establishment_id in number default hr_api.g_number
276: ,p_address in varchar2 default hr_api.g_varchar2
277: ,p_attribute_category in varchar2 default hr_api.g_varchar2
278: ,p_attribute1 in varchar2 default hr_api.g_varchar2
279: ,p_attribute2 in varchar2 default hr_api.g_varchar2
280: ,p_attribute3 in varchar2 default hr_api.g_varchar2
281: ,p_attribute4 in varchar2 default hr_api.g_varchar2
282: ,p_attribute5 in varchar2 default hr_api.g_varchar2
283: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 280: ,p_attribute3 in varchar2 default hr_api.g_varchar2

276: ,p_address in varchar2 default hr_api.g_varchar2
277: ,p_attribute_category in varchar2 default hr_api.g_varchar2
278: ,p_attribute1 in varchar2 default hr_api.g_varchar2
279: ,p_attribute2 in varchar2 default hr_api.g_varchar2
280: ,p_attribute3 in varchar2 default hr_api.g_varchar2
281: ,p_attribute4 in varchar2 default hr_api.g_varchar2
282: ,p_attribute5 in varchar2 default hr_api.g_varchar2
283: ,p_attribute6 in varchar2 default hr_api.g_varchar2
284: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 281: ,p_attribute4 in varchar2 default hr_api.g_varchar2

277: ,p_attribute_category in varchar2 default hr_api.g_varchar2
278: ,p_attribute1 in varchar2 default hr_api.g_varchar2
279: ,p_attribute2 in varchar2 default hr_api.g_varchar2
280: ,p_attribute3 in varchar2 default hr_api.g_varchar2
281: ,p_attribute4 in varchar2 default hr_api.g_varchar2
282: ,p_attribute5 in varchar2 default hr_api.g_varchar2
283: ,p_attribute6 in varchar2 default hr_api.g_varchar2
284: ,p_attribute7 in varchar2 default hr_api.g_varchar2
285: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 282: ,p_attribute5 in varchar2 default hr_api.g_varchar2

278: ,p_attribute1 in varchar2 default hr_api.g_varchar2
279: ,p_attribute2 in varchar2 default hr_api.g_varchar2
280: ,p_attribute3 in varchar2 default hr_api.g_varchar2
281: ,p_attribute4 in varchar2 default hr_api.g_varchar2
282: ,p_attribute5 in varchar2 default hr_api.g_varchar2
283: ,p_attribute6 in varchar2 default hr_api.g_varchar2
284: ,p_attribute7 in varchar2 default hr_api.g_varchar2
285: ,p_attribute8 in varchar2 default hr_api.g_varchar2
286: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 283: ,p_attribute6 in varchar2 default hr_api.g_varchar2

279: ,p_attribute2 in varchar2 default hr_api.g_varchar2
280: ,p_attribute3 in varchar2 default hr_api.g_varchar2
281: ,p_attribute4 in varchar2 default hr_api.g_varchar2
282: ,p_attribute5 in varchar2 default hr_api.g_varchar2
283: ,p_attribute6 in varchar2 default hr_api.g_varchar2
284: ,p_attribute7 in varchar2 default hr_api.g_varchar2
285: ,p_attribute8 in varchar2 default hr_api.g_varchar2
286: ,p_attribute9 in varchar2 default hr_api.g_varchar2
287: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 284: ,p_attribute7 in varchar2 default hr_api.g_varchar2

280: ,p_attribute3 in varchar2 default hr_api.g_varchar2
281: ,p_attribute4 in varchar2 default hr_api.g_varchar2
282: ,p_attribute5 in varchar2 default hr_api.g_varchar2
283: ,p_attribute6 in varchar2 default hr_api.g_varchar2
284: ,p_attribute7 in varchar2 default hr_api.g_varchar2
285: ,p_attribute8 in varchar2 default hr_api.g_varchar2
286: ,p_attribute9 in varchar2 default hr_api.g_varchar2
287: ,p_attribute10 in varchar2 default hr_api.g_varchar2
288: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 285: ,p_attribute8 in varchar2 default hr_api.g_varchar2

281: ,p_attribute4 in varchar2 default hr_api.g_varchar2
282: ,p_attribute5 in varchar2 default hr_api.g_varchar2
283: ,p_attribute6 in varchar2 default hr_api.g_varchar2
284: ,p_attribute7 in varchar2 default hr_api.g_varchar2
285: ,p_attribute8 in varchar2 default hr_api.g_varchar2
286: ,p_attribute9 in varchar2 default hr_api.g_varchar2
287: ,p_attribute10 in varchar2 default hr_api.g_varchar2
288: ,p_attribute11 in varchar2 default hr_api.g_varchar2
289: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 286: ,p_attribute9 in varchar2 default hr_api.g_varchar2

282: ,p_attribute5 in varchar2 default hr_api.g_varchar2
283: ,p_attribute6 in varchar2 default hr_api.g_varchar2
284: ,p_attribute7 in varchar2 default hr_api.g_varchar2
285: ,p_attribute8 in varchar2 default hr_api.g_varchar2
286: ,p_attribute9 in varchar2 default hr_api.g_varchar2
287: ,p_attribute10 in varchar2 default hr_api.g_varchar2
288: ,p_attribute11 in varchar2 default hr_api.g_varchar2
289: ,p_attribute12 in varchar2 default hr_api.g_varchar2
290: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 287: ,p_attribute10 in varchar2 default hr_api.g_varchar2

283: ,p_attribute6 in varchar2 default hr_api.g_varchar2
284: ,p_attribute7 in varchar2 default hr_api.g_varchar2
285: ,p_attribute8 in varchar2 default hr_api.g_varchar2
286: ,p_attribute9 in varchar2 default hr_api.g_varchar2
287: ,p_attribute10 in varchar2 default hr_api.g_varchar2
288: ,p_attribute11 in varchar2 default hr_api.g_varchar2
289: ,p_attribute12 in varchar2 default hr_api.g_varchar2
290: ,p_attribute13 in varchar2 default hr_api.g_varchar2
291: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 288: ,p_attribute11 in varchar2 default hr_api.g_varchar2

284: ,p_attribute7 in varchar2 default hr_api.g_varchar2
285: ,p_attribute8 in varchar2 default hr_api.g_varchar2
286: ,p_attribute9 in varchar2 default hr_api.g_varchar2
287: ,p_attribute10 in varchar2 default hr_api.g_varchar2
288: ,p_attribute11 in varchar2 default hr_api.g_varchar2
289: ,p_attribute12 in varchar2 default hr_api.g_varchar2
290: ,p_attribute13 in varchar2 default hr_api.g_varchar2
291: ,p_attribute14 in varchar2 default hr_api.g_varchar2
292: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 289: ,p_attribute12 in varchar2 default hr_api.g_varchar2

285: ,p_attribute8 in varchar2 default hr_api.g_varchar2
286: ,p_attribute9 in varchar2 default hr_api.g_varchar2
287: ,p_attribute10 in varchar2 default hr_api.g_varchar2
288: ,p_attribute11 in varchar2 default hr_api.g_varchar2
289: ,p_attribute12 in varchar2 default hr_api.g_varchar2
290: ,p_attribute13 in varchar2 default hr_api.g_varchar2
291: ,p_attribute14 in varchar2 default hr_api.g_varchar2
292: ,p_attribute15 in varchar2 default hr_api.g_varchar2
293: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 290: ,p_attribute13 in varchar2 default hr_api.g_varchar2

286: ,p_attribute9 in varchar2 default hr_api.g_varchar2
287: ,p_attribute10 in varchar2 default hr_api.g_varchar2
288: ,p_attribute11 in varchar2 default hr_api.g_varchar2
289: ,p_attribute12 in varchar2 default hr_api.g_varchar2
290: ,p_attribute13 in varchar2 default hr_api.g_varchar2
291: ,p_attribute14 in varchar2 default hr_api.g_varchar2
292: ,p_attribute15 in varchar2 default hr_api.g_varchar2
293: ,p_attribute16 in varchar2 default hr_api.g_varchar2
294: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 291: ,p_attribute14 in varchar2 default hr_api.g_varchar2

287: ,p_attribute10 in varchar2 default hr_api.g_varchar2
288: ,p_attribute11 in varchar2 default hr_api.g_varchar2
289: ,p_attribute12 in varchar2 default hr_api.g_varchar2
290: ,p_attribute13 in varchar2 default hr_api.g_varchar2
291: ,p_attribute14 in varchar2 default hr_api.g_varchar2
292: ,p_attribute15 in varchar2 default hr_api.g_varchar2
293: ,p_attribute16 in varchar2 default hr_api.g_varchar2
294: ,p_attribute17 in varchar2 default hr_api.g_varchar2
295: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 292: ,p_attribute15 in varchar2 default hr_api.g_varchar2

288: ,p_attribute11 in varchar2 default hr_api.g_varchar2
289: ,p_attribute12 in varchar2 default hr_api.g_varchar2
290: ,p_attribute13 in varchar2 default hr_api.g_varchar2
291: ,p_attribute14 in varchar2 default hr_api.g_varchar2
292: ,p_attribute15 in varchar2 default hr_api.g_varchar2
293: ,p_attribute16 in varchar2 default hr_api.g_varchar2
294: ,p_attribute17 in varchar2 default hr_api.g_varchar2
295: ,p_attribute18 in varchar2 default hr_api.g_varchar2
296: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 293: ,p_attribute16 in varchar2 default hr_api.g_varchar2

289: ,p_attribute12 in varchar2 default hr_api.g_varchar2
290: ,p_attribute13 in varchar2 default hr_api.g_varchar2
291: ,p_attribute14 in varchar2 default hr_api.g_varchar2
292: ,p_attribute15 in varchar2 default hr_api.g_varchar2
293: ,p_attribute16 in varchar2 default hr_api.g_varchar2
294: ,p_attribute17 in varchar2 default hr_api.g_varchar2
295: ,p_attribute18 in varchar2 default hr_api.g_varchar2
296: ,p_attribute19 in varchar2 default hr_api.g_varchar2
297: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 294: ,p_attribute17 in varchar2 default hr_api.g_varchar2

290: ,p_attribute13 in varchar2 default hr_api.g_varchar2
291: ,p_attribute14 in varchar2 default hr_api.g_varchar2
292: ,p_attribute15 in varchar2 default hr_api.g_varchar2
293: ,p_attribute16 in varchar2 default hr_api.g_varchar2
294: ,p_attribute17 in varchar2 default hr_api.g_varchar2
295: ,p_attribute18 in varchar2 default hr_api.g_varchar2
296: ,p_attribute19 in varchar2 default hr_api.g_varchar2
297: ,p_attribute20 in varchar2 default hr_api.g_varchar2
298: ,p_object_version_number in out nocopy number

Line 295: ,p_attribute18 in varchar2 default hr_api.g_varchar2

291: ,p_attribute14 in varchar2 default hr_api.g_varchar2
292: ,p_attribute15 in varchar2 default hr_api.g_varchar2
293: ,p_attribute16 in varchar2 default hr_api.g_varchar2
294: ,p_attribute17 in varchar2 default hr_api.g_varchar2
295: ,p_attribute18 in varchar2 default hr_api.g_varchar2
296: ,p_attribute19 in varchar2 default hr_api.g_varchar2
297: ,p_attribute20 in varchar2 default hr_api.g_varchar2
298: ,p_object_version_number in out nocopy number
299: ,p_return_status out nocopy varchar2

Line 296: ,p_attribute19 in varchar2 default hr_api.g_varchar2

292: ,p_attribute15 in varchar2 default hr_api.g_varchar2
293: ,p_attribute16 in varchar2 default hr_api.g_varchar2
294: ,p_attribute17 in varchar2 default hr_api.g_varchar2
295: ,p_attribute18 in varchar2 default hr_api.g_varchar2
296: ,p_attribute19 in varchar2 default hr_api.g_varchar2
297: ,p_attribute20 in varchar2 default hr_api.g_varchar2
298: ,p_object_version_number in out nocopy number
299: ,p_return_status out nocopy varchar2
300: ) is

Line 297: ,p_attribute20 in varchar2 default hr_api.g_varchar2

293: ,p_attribute16 in varchar2 default hr_api.g_varchar2
294: ,p_attribute17 in varchar2 default hr_api.g_varchar2
295: ,p_attribute18 in varchar2 default hr_api.g_varchar2
296: ,p_attribute19 in varchar2 default hr_api.g_varchar2
297: ,p_attribute20 in varchar2 default hr_api.g_varchar2
298: ,p_object_version_number in out nocopy number
299: ,p_return_status out nocopy varchar2
300: ) is
301: --

Line 328: hr_api.constant_to_boolean

324: --
325: -- Convert constant values to their corresponding boolean value
326: --
327: l_validate :=
328: hr_api.constant_to_boolean
329: (p_constant_value => p_validate);
330: --
331: -- Register Surrogate ID or user key values
332: --