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_ANC_UPD dependencies on OTA_ANC_SHD

Line 55: (p_rec in out nocopy ota_anc_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy ota_anc_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

Line 109: ota_anc_shd.constraint_error

105: Exception
106: When hr_api.check_integrity_violated Then
107: -- A check constraint has been violated
108: --
109: ota_anc_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When hr_api.parent_integrity_violated Then
112: -- Parent integrity has been violated
113: --

Line 114: ota_anc_shd.constraint_error

110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When hr_api.parent_integrity_violated Then
112: -- Parent integrity has been violated
113: --
114: ota_anc_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.unique_integrity_violated Then
117: -- Unique integrity has been violated
118: --

Line 119: ota_anc_shd.constraint_error

115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.unique_integrity_violated Then
117: -- Unique integrity has been violated
118: --
119: ota_anc_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When Others Then
122: --
123: Raise;

Line 159: (p_rec in ota_anc_shd.g_rec_type

155: --
156: -- {End Of Comments}
157: -- ----------------------------------------------------------------------------
158: Procedure pre_update
159: (p_rec in ota_anc_shd.g_rec_type
160: ) is
161: --
162: l_proc varchar2(72) := g_package||'pre_update';
163: --

Line 204: ,p_rec in ota_anc_shd.g_rec_type

200: -- {End Of Comments}
201: -- ----------------------------------------------------------------------------
202: Procedure post_update
203: (p_effective_date in date
204: ,p_rec in ota_anc_shd.g_rec_type
205: ) is
206: --
207: l_proc varchar2(72) := g_package||'post_update';
208: --

Line 270: => ota_anc_shd.g_old_rec.business_group_id

266: => p_rec.attribute19
267: ,p_attribute20
268: => p_rec.attribute20
269: ,p_business_group_id_o
270: => ota_anc_shd.g_old_rec.business_group_id
271: ,p_object_version_number_o
272: => ota_anc_shd.g_old_rec.object_version_number
273: ,p_start_date_active_o
274: => ota_anc_shd.g_old_rec.start_date_active

Line 272: => ota_anc_shd.g_old_rec.object_version_number

268: => p_rec.attribute20
269: ,p_business_group_id_o
270: => ota_anc_shd.g_old_rec.business_group_id
271: ,p_object_version_number_o
272: => ota_anc_shd.g_old_rec.object_version_number
273: ,p_start_date_active_o
274: => ota_anc_shd.g_old_rec.start_date_active
275: ,p_end_date_active_o
276: => ota_anc_shd.g_old_rec.end_date_active

Line 274: => ota_anc_shd.g_old_rec.start_date_active

270: => ota_anc_shd.g_old_rec.business_group_id
271: ,p_object_version_number_o
272: => ota_anc_shd.g_old_rec.object_version_number
273: ,p_start_date_active_o
274: => ota_anc_shd.g_old_rec.start_date_active
275: ,p_end_date_active_o
276: => ota_anc_shd.g_old_rec.end_date_active
277: ,p_owner_id_o
278: => ota_anc_shd.g_old_rec.owner_id

Line 276: => ota_anc_shd.g_old_rec.end_date_active

272: => ota_anc_shd.g_old_rec.object_version_number
273: ,p_start_date_active_o
274: => ota_anc_shd.g_old_rec.start_date_active
275: ,p_end_date_active_o
276: => ota_anc_shd.g_old_rec.end_date_active
277: ,p_owner_id_o
278: => ota_anc_shd.g_old_rec.owner_id
279: ,p_attribute_category_o
280: => ota_anc_shd.g_old_rec.attribute_category

Line 278: => ota_anc_shd.g_old_rec.owner_id

274: => ota_anc_shd.g_old_rec.start_date_active
275: ,p_end_date_active_o
276: => ota_anc_shd.g_old_rec.end_date_active
277: ,p_owner_id_o
278: => ota_anc_shd.g_old_rec.owner_id
279: ,p_attribute_category_o
280: => ota_anc_shd.g_old_rec.attribute_category
281: ,p_attribute1_o
282: => ota_anc_shd.g_old_rec.attribute1

Line 280: => ota_anc_shd.g_old_rec.attribute_category

276: => ota_anc_shd.g_old_rec.end_date_active
277: ,p_owner_id_o
278: => ota_anc_shd.g_old_rec.owner_id
279: ,p_attribute_category_o
280: => ota_anc_shd.g_old_rec.attribute_category
281: ,p_attribute1_o
282: => ota_anc_shd.g_old_rec.attribute1
283: ,p_attribute2_o
284: => ota_anc_shd.g_old_rec.attribute2

Line 282: => ota_anc_shd.g_old_rec.attribute1

278: => ota_anc_shd.g_old_rec.owner_id
279: ,p_attribute_category_o
280: => ota_anc_shd.g_old_rec.attribute_category
281: ,p_attribute1_o
282: => ota_anc_shd.g_old_rec.attribute1
283: ,p_attribute2_o
284: => ota_anc_shd.g_old_rec.attribute2
285: ,p_attribute3_o
286: => ota_anc_shd.g_old_rec.attribute3

Line 284: => ota_anc_shd.g_old_rec.attribute2

280: => ota_anc_shd.g_old_rec.attribute_category
281: ,p_attribute1_o
282: => ota_anc_shd.g_old_rec.attribute1
283: ,p_attribute2_o
284: => ota_anc_shd.g_old_rec.attribute2
285: ,p_attribute3_o
286: => ota_anc_shd.g_old_rec.attribute3
287: ,p_attribute4_o
288: => ota_anc_shd.g_old_rec.attribute4

Line 286: => ota_anc_shd.g_old_rec.attribute3

282: => ota_anc_shd.g_old_rec.attribute1
283: ,p_attribute2_o
284: => ota_anc_shd.g_old_rec.attribute2
285: ,p_attribute3_o
286: => ota_anc_shd.g_old_rec.attribute3
287: ,p_attribute4_o
288: => ota_anc_shd.g_old_rec.attribute4
289: ,p_attribute5_o
290: => ota_anc_shd.g_old_rec.attribute5

Line 288: => ota_anc_shd.g_old_rec.attribute4

284: => ota_anc_shd.g_old_rec.attribute2
285: ,p_attribute3_o
286: => ota_anc_shd.g_old_rec.attribute3
287: ,p_attribute4_o
288: => ota_anc_shd.g_old_rec.attribute4
289: ,p_attribute5_o
290: => ota_anc_shd.g_old_rec.attribute5
291: ,p_attribute6_o
292: => ota_anc_shd.g_old_rec.attribute6

Line 290: => ota_anc_shd.g_old_rec.attribute5

286: => ota_anc_shd.g_old_rec.attribute3
287: ,p_attribute4_o
288: => ota_anc_shd.g_old_rec.attribute4
289: ,p_attribute5_o
290: => ota_anc_shd.g_old_rec.attribute5
291: ,p_attribute6_o
292: => ota_anc_shd.g_old_rec.attribute6
293: ,p_attribute7_o
294: => ota_anc_shd.g_old_rec.attribute7

Line 292: => ota_anc_shd.g_old_rec.attribute6

288: => ota_anc_shd.g_old_rec.attribute4
289: ,p_attribute5_o
290: => ota_anc_shd.g_old_rec.attribute5
291: ,p_attribute6_o
292: => ota_anc_shd.g_old_rec.attribute6
293: ,p_attribute7_o
294: => ota_anc_shd.g_old_rec.attribute7
295: ,p_attribute8_o
296: => ota_anc_shd.g_old_rec.attribute8

Line 294: => ota_anc_shd.g_old_rec.attribute7

290: => ota_anc_shd.g_old_rec.attribute5
291: ,p_attribute6_o
292: => ota_anc_shd.g_old_rec.attribute6
293: ,p_attribute7_o
294: => ota_anc_shd.g_old_rec.attribute7
295: ,p_attribute8_o
296: => ota_anc_shd.g_old_rec.attribute8
297: ,p_attribute9_o
298: => ota_anc_shd.g_old_rec.attribute9

Line 296: => ota_anc_shd.g_old_rec.attribute8

292: => ota_anc_shd.g_old_rec.attribute6
293: ,p_attribute7_o
294: => ota_anc_shd.g_old_rec.attribute7
295: ,p_attribute8_o
296: => ota_anc_shd.g_old_rec.attribute8
297: ,p_attribute9_o
298: => ota_anc_shd.g_old_rec.attribute9
299: ,p_attribute10_o
300: => ota_anc_shd.g_old_rec.attribute10

Line 298: => ota_anc_shd.g_old_rec.attribute9

294: => ota_anc_shd.g_old_rec.attribute7
295: ,p_attribute8_o
296: => ota_anc_shd.g_old_rec.attribute8
297: ,p_attribute9_o
298: => ota_anc_shd.g_old_rec.attribute9
299: ,p_attribute10_o
300: => ota_anc_shd.g_old_rec.attribute10
301: ,p_attribute11_o
302: => ota_anc_shd.g_old_rec.attribute11

Line 300: => ota_anc_shd.g_old_rec.attribute10

296: => ota_anc_shd.g_old_rec.attribute8
297: ,p_attribute9_o
298: => ota_anc_shd.g_old_rec.attribute9
299: ,p_attribute10_o
300: => ota_anc_shd.g_old_rec.attribute10
301: ,p_attribute11_o
302: => ota_anc_shd.g_old_rec.attribute11
303: ,p_attribute12_o
304: => ota_anc_shd.g_old_rec.attribute12

Line 302: => ota_anc_shd.g_old_rec.attribute11

298: => ota_anc_shd.g_old_rec.attribute9
299: ,p_attribute10_o
300: => ota_anc_shd.g_old_rec.attribute10
301: ,p_attribute11_o
302: => ota_anc_shd.g_old_rec.attribute11
303: ,p_attribute12_o
304: => ota_anc_shd.g_old_rec.attribute12
305: ,p_attribute13_o
306: => ota_anc_shd.g_old_rec.attribute13

Line 304: => ota_anc_shd.g_old_rec.attribute12

300: => ota_anc_shd.g_old_rec.attribute10
301: ,p_attribute11_o
302: => ota_anc_shd.g_old_rec.attribute11
303: ,p_attribute12_o
304: => ota_anc_shd.g_old_rec.attribute12
305: ,p_attribute13_o
306: => ota_anc_shd.g_old_rec.attribute13
307: ,p_attribute14_o
308: => ota_anc_shd.g_old_rec.attribute14

Line 306: => ota_anc_shd.g_old_rec.attribute13

302: => ota_anc_shd.g_old_rec.attribute11
303: ,p_attribute12_o
304: => ota_anc_shd.g_old_rec.attribute12
305: ,p_attribute13_o
306: => ota_anc_shd.g_old_rec.attribute13
307: ,p_attribute14_o
308: => ota_anc_shd.g_old_rec.attribute14
309: ,p_attribute15_o
310: => ota_anc_shd.g_old_rec.attribute15

Line 308: => ota_anc_shd.g_old_rec.attribute14

304: => ota_anc_shd.g_old_rec.attribute12
305: ,p_attribute13_o
306: => ota_anc_shd.g_old_rec.attribute13
307: ,p_attribute14_o
308: => ota_anc_shd.g_old_rec.attribute14
309: ,p_attribute15_o
310: => ota_anc_shd.g_old_rec.attribute15
311: ,p_attribute16_o
312: => ota_anc_shd.g_old_rec.attribute16

Line 310: => ota_anc_shd.g_old_rec.attribute15

306: => ota_anc_shd.g_old_rec.attribute13
307: ,p_attribute14_o
308: => ota_anc_shd.g_old_rec.attribute14
309: ,p_attribute15_o
310: => ota_anc_shd.g_old_rec.attribute15
311: ,p_attribute16_o
312: => ota_anc_shd.g_old_rec.attribute16
313: ,p_attribute17_o
314: => ota_anc_shd.g_old_rec.attribute17

Line 312: => ota_anc_shd.g_old_rec.attribute16

308: => ota_anc_shd.g_old_rec.attribute14
309: ,p_attribute15_o
310: => ota_anc_shd.g_old_rec.attribute15
311: ,p_attribute16_o
312: => ota_anc_shd.g_old_rec.attribute16
313: ,p_attribute17_o
314: => ota_anc_shd.g_old_rec.attribute17
315: ,p_attribute18_o
316: => ota_anc_shd.g_old_rec.attribute18

Line 314: => ota_anc_shd.g_old_rec.attribute17

310: => ota_anc_shd.g_old_rec.attribute15
311: ,p_attribute16_o
312: => ota_anc_shd.g_old_rec.attribute16
313: ,p_attribute17_o
314: => ota_anc_shd.g_old_rec.attribute17
315: ,p_attribute18_o
316: => ota_anc_shd.g_old_rec.attribute18
317: ,p_attribute19_o
318: => ota_anc_shd.g_old_rec.attribute19

Line 316: => ota_anc_shd.g_old_rec.attribute18

312: => ota_anc_shd.g_old_rec.attribute16
313: ,p_attribute17_o
314: => ota_anc_shd.g_old_rec.attribute17
315: ,p_attribute18_o
316: => ota_anc_shd.g_old_rec.attribute18
317: ,p_attribute19_o
318: => ota_anc_shd.g_old_rec.attribute19
319: ,p_attribute20_o
320: => ota_anc_shd.g_old_rec.attribute20

Line 318: => ota_anc_shd.g_old_rec.attribute19

314: => ota_anc_shd.g_old_rec.attribute17
315: ,p_attribute18_o
316: => ota_anc_shd.g_old_rec.attribute18
317: ,p_attribute19_o
318: => ota_anc_shd.g_old_rec.attribute19
319: ,p_attribute20_o
320: => ota_anc_shd.g_old_rec.attribute20
321: );
322: --

Line 320: => ota_anc_shd.g_old_rec.attribute20

316: => ota_anc_shd.g_old_rec.attribute18
317: ,p_attribute19_o
318: => ota_anc_shd.g_old_rec.attribute19
319: ,p_attribute20_o
320: => ota_anc_shd.g_old_rec.attribute20
321: );
322: --
323: exception
324: --

Line 380: (p_rec in out nocopy ota_anc_shd.g_rec_type

376: --
377: -- {End Of Comments}
378: -- ----------------------------------------------------------------------------
379: Procedure convert_defs
380: (p_rec in out nocopy ota_anc_shd.g_rec_type
381: ) is
382: --
383: Begin
384: --

Line 392: ota_anc_shd.g_old_rec.business_group_id;

388: -- is being used then we must set to the 'current' argument value.
389: --
390: If (p_rec.business_group_id = hr_api.g_number) then
391: p_rec.business_group_id :=
392: ota_anc_shd.g_old_rec.business_group_id;
393: End If;
394: If (p_rec.start_date_active = hr_api.g_date) then
395: p_rec.start_date_active :=
396: ota_anc_shd.g_old_rec.start_date_active;

Line 396: ota_anc_shd.g_old_rec.start_date_active;

392: ota_anc_shd.g_old_rec.business_group_id;
393: End If;
394: If (p_rec.start_date_active = hr_api.g_date) then
395: p_rec.start_date_active :=
396: ota_anc_shd.g_old_rec.start_date_active;
397: End If;
398: If (p_rec.end_date_active = hr_api.g_date) then
399: p_rec.end_date_active :=
400: ota_anc_shd.g_old_rec.end_date_active;

Line 400: ota_anc_shd.g_old_rec.end_date_active;

396: ota_anc_shd.g_old_rec.start_date_active;
397: End If;
398: If (p_rec.end_date_active = hr_api.g_date) then
399: p_rec.end_date_active :=
400: ota_anc_shd.g_old_rec.end_date_active;
401: End If;
402: If (p_rec.owner_id = hr_api.g_number) then
403: p_rec.owner_id :=
404: ota_anc_shd.g_old_rec.owner_id;

Line 404: ota_anc_shd.g_old_rec.owner_id;

400: ota_anc_shd.g_old_rec.end_date_active;
401: End If;
402: If (p_rec.owner_id = hr_api.g_number) then
403: p_rec.owner_id :=
404: ota_anc_shd.g_old_rec.owner_id;
405: End If;
406: If (p_rec.attribute_category = hr_api.g_varchar2) then
407: p_rec.attribute_category :=
408: ota_anc_shd.g_old_rec.attribute_category;

Line 408: ota_anc_shd.g_old_rec.attribute_category;

404: ota_anc_shd.g_old_rec.owner_id;
405: End If;
406: If (p_rec.attribute_category = hr_api.g_varchar2) then
407: p_rec.attribute_category :=
408: ota_anc_shd.g_old_rec.attribute_category;
409: End If;
410: If (p_rec.attribute1 = hr_api.g_varchar2) then
411: p_rec.attribute1 :=
412: ota_anc_shd.g_old_rec.attribute1;

Line 412: ota_anc_shd.g_old_rec.attribute1;

408: ota_anc_shd.g_old_rec.attribute_category;
409: End If;
410: If (p_rec.attribute1 = hr_api.g_varchar2) then
411: p_rec.attribute1 :=
412: ota_anc_shd.g_old_rec.attribute1;
413: End If;
414: If (p_rec.attribute2 = hr_api.g_varchar2) then
415: p_rec.attribute2 :=
416: ota_anc_shd.g_old_rec.attribute2;

Line 416: ota_anc_shd.g_old_rec.attribute2;

412: ota_anc_shd.g_old_rec.attribute1;
413: End If;
414: If (p_rec.attribute2 = hr_api.g_varchar2) then
415: p_rec.attribute2 :=
416: ota_anc_shd.g_old_rec.attribute2;
417: End If;
418: If (p_rec.attribute3 = hr_api.g_varchar2) then
419: p_rec.attribute3 :=
420: ota_anc_shd.g_old_rec.attribute3;

Line 420: ota_anc_shd.g_old_rec.attribute3;

416: ota_anc_shd.g_old_rec.attribute2;
417: End If;
418: If (p_rec.attribute3 = hr_api.g_varchar2) then
419: p_rec.attribute3 :=
420: ota_anc_shd.g_old_rec.attribute3;
421: End If;
422: If (p_rec.attribute4 = hr_api.g_varchar2) then
423: p_rec.attribute4 :=
424: ota_anc_shd.g_old_rec.attribute4;

Line 424: ota_anc_shd.g_old_rec.attribute4;

420: ota_anc_shd.g_old_rec.attribute3;
421: End If;
422: If (p_rec.attribute4 = hr_api.g_varchar2) then
423: p_rec.attribute4 :=
424: ota_anc_shd.g_old_rec.attribute4;
425: End If;
426: If (p_rec.attribute5 = hr_api.g_varchar2) then
427: p_rec.attribute5 :=
428: ota_anc_shd.g_old_rec.attribute5;

Line 428: ota_anc_shd.g_old_rec.attribute5;

424: ota_anc_shd.g_old_rec.attribute4;
425: End If;
426: If (p_rec.attribute5 = hr_api.g_varchar2) then
427: p_rec.attribute5 :=
428: ota_anc_shd.g_old_rec.attribute5;
429: End If;
430: If (p_rec.attribute6 = hr_api.g_varchar2) then
431: p_rec.attribute6 :=
432: ota_anc_shd.g_old_rec.attribute6;

Line 432: ota_anc_shd.g_old_rec.attribute6;

428: ota_anc_shd.g_old_rec.attribute5;
429: End If;
430: If (p_rec.attribute6 = hr_api.g_varchar2) then
431: p_rec.attribute6 :=
432: ota_anc_shd.g_old_rec.attribute6;
433: End If;
434: If (p_rec.attribute7 = hr_api.g_varchar2) then
435: p_rec.attribute7 :=
436: ota_anc_shd.g_old_rec.attribute7;

Line 436: ota_anc_shd.g_old_rec.attribute7;

432: ota_anc_shd.g_old_rec.attribute6;
433: End If;
434: If (p_rec.attribute7 = hr_api.g_varchar2) then
435: p_rec.attribute7 :=
436: ota_anc_shd.g_old_rec.attribute7;
437: End If;
438: If (p_rec.attribute8 = hr_api.g_varchar2) then
439: p_rec.attribute8 :=
440: ota_anc_shd.g_old_rec.attribute8;

Line 440: ota_anc_shd.g_old_rec.attribute8;

436: ota_anc_shd.g_old_rec.attribute7;
437: End If;
438: If (p_rec.attribute8 = hr_api.g_varchar2) then
439: p_rec.attribute8 :=
440: ota_anc_shd.g_old_rec.attribute8;
441: End If;
442: If (p_rec.attribute9 = hr_api.g_varchar2) then
443: p_rec.attribute9 :=
444: ota_anc_shd.g_old_rec.attribute9;

Line 444: ota_anc_shd.g_old_rec.attribute9;

440: ota_anc_shd.g_old_rec.attribute8;
441: End If;
442: If (p_rec.attribute9 = hr_api.g_varchar2) then
443: p_rec.attribute9 :=
444: ota_anc_shd.g_old_rec.attribute9;
445: End If;
446: If (p_rec.attribute10 = hr_api.g_varchar2) then
447: p_rec.attribute10 :=
448: ota_anc_shd.g_old_rec.attribute10;

Line 448: ota_anc_shd.g_old_rec.attribute10;

444: ota_anc_shd.g_old_rec.attribute9;
445: End If;
446: If (p_rec.attribute10 = hr_api.g_varchar2) then
447: p_rec.attribute10 :=
448: ota_anc_shd.g_old_rec.attribute10;
449: End If;
450: If (p_rec.attribute11 = hr_api.g_varchar2) then
451: p_rec.attribute11 :=
452: ota_anc_shd.g_old_rec.attribute11;

Line 452: ota_anc_shd.g_old_rec.attribute11;

448: ota_anc_shd.g_old_rec.attribute10;
449: End If;
450: If (p_rec.attribute11 = hr_api.g_varchar2) then
451: p_rec.attribute11 :=
452: ota_anc_shd.g_old_rec.attribute11;
453: End If;
454: If (p_rec.attribute12 = hr_api.g_varchar2) then
455: p_rec.attribute12 :=
456: ota_anc_shd.g_old_rec.attribute12;

Line 456: ota_anc_shd.g_old_rec.attribute12;

452: ota_anc_shd.g_old_rec.attribute11;
453: End If;
454: If (p_rec.attribute12 = hr_api.g_varchar2) then
455: p_rec.attribute12 :=
456: ota_anc_shd.g_old_rec.attribute12;
457: End If;
458: If (p_rec.attribute13 = hr_api.g_varchar2) then
459: p_rec.attribute13 :=
460: ota_anc_shd.g_old_rec.attribute13;

Line 460: ota_anc_shd.g_old_rec.attribute13;

456: ota_anc_shd.g_old_rec.attribute12;
457: End If;
458: If (p_rec.attribute13 = hr_api.g_varchar2) then
459: p_rec.attribute13 :=
460: ota_anc_shd.g_old_rec.attribute13;
461: End If;
462: If (p_rec.attribute14 = hr_api.g_varchar2) then
463: p_rec.attribute14 :=
464: ota_anc_shd.g_old_rec.attribute14;

Line 464: ota_anc_shd.g_old_rec.attribute14;

460: ota_anc_shd.g_old_rec.attribute13;
461: End If;
462: If (p_rec.attribute14 = hr_api.g_varchar2) then
463: p_rec.attribute14 :=
464: ota_anc_shd.g_old_rec.attribute14;
465: End If;
466: If (p_rec.attribute15 = hr_api.g_varchar2) then
467: p_rec.attribute15 :=
468: ota_anc_shd.g_old_rec.attribute15;

Line 468: ota_anc_shd.g_old_rec.attribute15;

464: ota_anc_shd.g_old_rec.attribute14;
465: End If;
466: If (p_rec.attribute15 = hr_api.g_varchar2) then
467: p_rec.attribute15 :=
468: ota_anc_shd.g_old_rec.attribute15;
469: End If;
470: If (p_rec.attribute16 = hr_api.g_varchar2) then
471: p_rec.attribute16 :=
472: ota_anc_shd.g_old_rec.attribute16;

Line 472: ota_anc_shd.g_old_rec.attribute16;

468: ota_anc_shd.g_old_rec.attribute15;
469: End If;
470: If (p_rec.attribute16 = hr_api.g_varchar2) then
471: p_rec.attribute16 :=
472: ota_anc_shd.g_old_rec.attribute16;
473: End If;
474: If (p_rec.attribute17 = hr_api.g_varchar2) then
475: p_rec.attribute17 :=
476: ota_anc_shd.g_old_rec.attribute17;

Line 476: ota_anc_shd.g_old_rec.attribute17;

472: ota_anc_shd.g_old_rec.attribute16;
473: End If;
474: If (p_rec.attribute17 = hr_api.g_varchar2) then
475: p_rec.attribute17 :=
476: ota_anc_shd.g_old_rec.attribute17;
477: End If;
478: If (p_rec.attribute18 = hr_api.g_varchar2) then
479: p_rec.attribute18 :=
480: ota_anc_shd.g_old_rec.attribute18;

Line 480: ota_anc_shd.g_old_rec.attribute18;

476: ota_anc_shd.g_old_rec.attribute17;
477: End If;
478: If (p_rec.attribute18 = hr_api.g_varchar2) then
479: p_rec.attribute18 :=
480: ota_anc_shd.g_old_rec.attribute18;
481: End If;
482: If (p_rec.attribute19 = hr_api.g_varchar2) then
483: p_rec.attribute19 :=
484: ota_anc_shd.g_old_rec.attribute19;

Line 484: ota_anc_shd.g_old_rec.attribute19;

480: ota_anc_shd.g_old_rec.attribute18;
481: End If;
482: If (p_rec.attribute19 = hr_api.g_varchar2) then
483: p_rec.attribute19 :=
484: ota_anc_shd.g_old_rec.attribute19;
485: End If;
486: If (p_rec.attribute20 = hr_api.g_varchar2) then
487: p_rec.attribute20 :=
488: ota_anc_shd.g_old_rec.attribute20;

Line 488: ota_anc_shd.g_old_rec.attribute20;

484: ota_anc_shd.g_old_rec.attribute19;
485: End If;
486: If (p_rec.attribute20 = hr_api.g_varchar2) then
487: p_rec.attribute20 :=
488: ota_anc_shd.g_old_rec.attribute20;
489: End If;
490: --
491: End convert_defs;
492: --

Line 498: ,p_rec in out nocopy ota_anc_shd.g_rec_type

494: -- |---------------------------------< upd >----------------------------------|
495: -- ----------------------------------------------------------------------------
496: Procedure upd
497: (p_effective_date in date
498: ,p_rec in out nocopy ota_anc_shd.g_rec_type
499: ) is
500: --
501: l_proc varchar2(72) := g_package||'upd';
502: --

Line 508: ota_anc_shd.lck

504: hr_utility.set_location('Entering:'||l_proc, 5);
505: --
506: -- We must lock the row which we need to update.
507: --
508: ota_anc_shd.lck
509: (p_rec.announcement_id
510: ,p_rec.object_version_number
511: );
512: --

Line 581: l_rec ota_anc_shd.g_rec_type;

577: ,p_attribute19 in varchar2 default hr_api.g_varchar2
578: ,p_attribute20 in varchar2 default hr_api.g_varchar2
579: ) is
580: --
581: l_rec ota_anc_shd.g_rec_type;
582: l_proc varchar2(72) := g_package||'upd';
583: --
584: Begin
585: hr_utility.set_location('Entering:'||l_proc, 5);

Line 591: ota_anc_shd.convert_args

587: -- Call conversion function to turn arguments into the
588: -- l_rec structure.
589: --
590: l_rec :=
591: ota_anc_shd.convert_args
592: (p_announcement_id
593: ,p_business_group_id
594: ,p_object_version_number
595: ,p_start_date_active