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_CFS_UPD dependencies on OTA_CFS_SHD

Line 55: (p_rec in out nocopy ota_cfs_shd.g_rec_type

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

Line 111: ota_cfs_shd.constraint_error

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

Line 116: ota_cfs_shd.constraint_error

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

Line 121: ota_cfs_shd.constraint_error

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

Line 161: (p_rec in ota_cfs_shd.g_rec_type

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

Line 206: ,p_rec in ota_cfs_shd.g_rec_type

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

Line 276: => ota_cfs_shd.g_old_rec.url

272: => p_rec.attribute19
273: ,p_attribute20
274: => p_rec.attribute20
275: ,p_url_o
276: => ota_cfs_shd.g_old_rec.url
277: ,p_type_o
278: => ota_cfs_shd.g_old_rec.type
279: ,p_owc_site_id_o
280: => ota_cfs_shd.g_old_rec.owc_site_id

Line 278: => ota_cfs_shd.g_old_rec.type

274: => p_rec.attribute20
275: ,p_url_o
276: => ota_cfs_shd.g_old_rec.url
277: ,p_type_o
278: => ota_cfs_shd.g_old_rec.type
279: ,p_owc_site_id_o
280: => ota_cfs_shd.g_old_rec.owc_site_id
281: ,p_owc_auth_token_o
282: => ota_cfs_shd.g_old_rec.owc_auth_token

Line 280: => ota_cfs_shd.g_old_rec.owc_site_id

276: => ota_cfs_shd.g_old_rec.url
277: ,p_type_o
278: => ota_cfs_shd.g_old_rec.type
279: ,p_owc_site_id_o
280: => ota_cfs_shd.g_old_rec.owc_site_id
281: ,p_owc_auth_token_o
282: => ota_cfs_shd.g_old_rec.owc_auth_token
283: ,p_end_date_active_o
284: => ota_cfs_shd.g_old_rec.end_date_active

Line 282: => ota_cfs_shd.g_old_rec.owc_auth_token

278: => ota_cfs_shd.g_old_rec.type
279: ,p_owc_site_id_o
280: => ota_cfs_shd.g_old_rec.owc_site_id
281: ,p_owc_auth_token_o
282: => ota_cfs_shd.g_old_rec.owc_auth_token
283: ,p_end_date_active_o
284: => ota_cfs_shd.g_old_rec.end_date_active
285: ,p_object_version_number_o
286: => ota_cfs_shd.g_old_rec.object_version_number

Line 284: => ota_cfs_shd.g_old_rec.end_date_active

280: => ota_cfs_shd.g_old_rec.owc_site_id
281: ,p_owc_auth_token_o
282: => ota_cfs_shd.g_old_rec.owc_auth_token
283: ,p_end_date_active_o
284: => ota_cfs_shd.g_old_rec.end_date_active
285: ,p_object_version_number_o
286: => ota_cfs_shd.g_old_rec.object_version_number
287: ,p_business_group_id_o
288: => ota_cfs_shd.g_old_rec.business_group_id

Line 286: => ota_cfs_shd.g_old_rec.object_version_number

282: => ota_cfs_shd.g_old_rec.owc_auth_token
283: ,p_end_date_active_o
284: => ota_cfs_shd.g_old_rec.end_date_active
285: ,p_object_version_number_o
286: => ota_cfs_shd.g_old_rec.object_version_number
287: ,p_business_group_id_o
288: => ota_cfs_shd.g_old_rec.business_group_id
289: ,p_attribute_category_o
290: => ota_cfs_shd.g_old_rec.attribute_category

Line 288: => ota_cfs_shd.g_old_rec.business_group_id

284: => ota_cfs_shd.g_old_rec.end_date_active
285: ,p_object_version_number_o
286: => ota_cfs_shd.g_old_rec.object_version_number
287: ,p_business_group_id_o
288: => ota_cfs_shd.g_old_rec.business_group_id
289: ,p_attribute_category_o
290: => ota_cfs_shd.g_old_rec.attribute_category
291: ,p_attribute1_o
292: => ota_cfs_shd.g_old_rec.attribute1

Line 290: => ota_cfs_shd.g_old_rec.attribute_category

286: => ota_cfs_shd.g_old_rec.object_version_number
287: ,p_business_group_id_o
288: => ota_cfs_shd.g_old_rec.business_group_id
289: ,p_attribute_category_o
290: => ota_cfs_shd.g_old_rec.attribute_category
291: ,p_attribute1_o
292: => ota_cfs_shd.g_old_rec.attribute1
293: ,p_attribute2_o
294: => ota_cfs_shd.g_old_rec.attribute2

Line 292: => ota_cfs_shd.g_old_rec.attribute1

288: => ota_cfs_shd.g_old_rec.business_group_id
289: ,p_attribute_category_o
290: => ota_cfs_shd.g_old_rec.attribute_category
291: ,p_attribute1_o
292: => ota_cfs_shd.g_old_rec.attribute1
293: ,p_attribute2_o
294: => ota_cfs_shd.g_old_rec.attribute2
295: ,p_attribute3_o
296: => ota_cfs_shd.g_old_rec.attribute3

Line 294: => ota_cfs_shd.g_old_rec.attribute2

290: => ota_cfs_shd.g_old_rec.attribute_category
291: ,p_attribute1_o
292: => ota_cfs_shd.g_old_rec.attribute1
293: ,p_attribute2_o
294: => ota_cfs_shd.g_old_rec.attribute2
295: ,p_attribute3_o
296: => ota_cfs_shd.g_old_rec.attribute3
297: ,p_attribute4_o
298: => ota_cfs_shd.g_old_rec.attribute4

Line 296: => ota_cfs_shd.g_old_rec.attribute3

292: => ota_cfs_shd.g_old_rec.attribute1
293: ,p_attribute2_o
294: => ota_cfs_shd.g_old_rec.attribute2
295: ,p_attribute3_o
296: => ota_cfs_shd.g_old_rec.attribute3
297: ,p_attribute4_o
298: => ota_cfs_shd.g_old_rec.attribute4
299: ,p_attribute5_o
300: => ota_cfs_shd.g_old_rec.attribute5

Line 298: => ota_cfs_shd.g_old_rec.attribute4

294: => ota_cfs_shd.g_old_rec.attribute2
295: ,p_attribute3_o
296: => ota_cfs_shd.g_old_rec.attribute3
297: ,p_attribute4_o
298: => ota_cfs_shd.g_old_rec.attribute4
299: ,p_attribute5_o
300: => ota_cfs_shd.g_old_rec.attribute5
301: ,p_attribute6_o
302: => ota_cfs_shd.g_old_rec.attribute6

Line 300: => ota_cfs_shd.g_old_rec.attribute5

296: => ota_cfs_shd.g_old_rec.attribute3
297: ,p_attribute4_o
298: => ota_cfs_shd.g_old_rec.attribute4
299: ,p_attribute5_o
300: => ota_cfs_shd.g_old_rec.attribute5
301: ,p_attribute6_o
302: => ota_cfs_shd.g_old_rec.attribute6
303: ,p_attribute7_o
304: => ota_cfs_shd.g_old_rec.attribute7

Line 302: => ota_cfs_shd.g_old_rec.attribute6

298: => ota_cfs_shd.g_old_rec.attribute4
299: ,p_attribute5_o
300: => ota_cfs_shd.g_old_rec.attribute5
301: ,p_attribute6_o
302: => ota_cfs_shd.g_old_rec.attribute6
303: ,p_attribute7_o
304: => ota_cfs_shd.g_old_rec.attribute7
305: ,p_attribute8_o
306: => ota_cfs_shd.g_old_rec.attribute8

Line 304: => ota_cfs_shd.g_old_rec.attribute7

300: => ota_cfs_shd.g_old_rec.attribute5
301: ,p_attribute6_o
302: => ota_cfs_shd.g_old_rec.attribute6
303: ,p_attribute7_o
304: => ota_cfs_shd.g_old_rec.attribute7
305: ,p_attribute8_o
306: => ota_cfs_shd.g_old_rec.attribute8
307: ,p_attribute9_o
308: => ota_cfs_shd.g_old_rec.attribute9

Line 306: => ota_cfs_shd.g_old_rec.attribute8

302: => ota_cfs_shd.g_old_rec.attribute6
303: ,p_attribute7_o
304: => ota_cfs_shd.g_old_rec.attribute7
305: ,p_attribute8_o
306: => ota_cfs_shd.g_old_rec.attribute8
307: ,p_attribute9_o
308: => ota_cfs_shd.g_old_rec.attribute9
309: ,p_attribute10_o
310: => ota_cfs_shd.g_old_rec.attribute10

Line 308: => ota_cfs_shd.g_old_rec.attribute9

304: => ota_cfs_shd.g_old_rec.attribute7
305: ,p_attribute8_o
306: => ota_cfs_shd.g_old_rec.attribute8
307: ,p_attribute9_o
308: => ota_cfs_shd.g_old_rec.attribute9
309: ,p_attribute10_o
310: => ota_cfs_shd.g_old_rec.attribute10
311: ,p_attribute11_o
312: => ota_cfs_shd.g_old_rec.attribute11

Line 310: => ota_cfs_shd.g_old_rec.attribute10

306: => ota_cfs_shd.g_old_rec.attribute8
307: ,p_attribute9_o
308: => ota_cfs_shd.g_old_rec.attribute9
309: ,p_attribute10_o
310: => ota_cfs_shd.g_old_rec.attribute10
311: ,p_attribute11_o
312: => ota_cfs_shd.g_old_rec.attribute11
313: ,p_attribute12_o
314: => ota_cfs_shd.g_old_rec.attribute12

Line 312: => ota_cfs_shd.g_old_rec.attribute11

308: => ota_cfs_shd.g_old_rec.attribute9
309: ,p_attribute10_o
310: => ota_cfs_shd.g_old_rec.attribute10
311: ,p_attribute11_o
312: => ota_cfs_shd.g_old_rec.attribute11
313: ,p_attribute12_o
314: => ota_cfs_shd.g_old_rec.attribute12
315: ,p_attribute13_o
316: => ota_cfs_shd.g_old_rec.attribute13

Line 314: => ota_cfs_shd.g_old_rec.attribute12

310: => ota_cfs_shd.g_old_rec.attribute10
311: ,p_attribute11_o
312: => ota_cfs_shd.g_old_rec.attribute11
313: ,p_attribute12_o
314: => ota_cfs_shd.g_old_rec.attribute12
315: ,p_attribute13_o
316: => ota_cfs_shd.g_old_rec.attribute13
317: ,p_attribute14_o
318: => ota_cfs_shd.g_old_rec.attribute14

Line 316: => ota_cfs_shd.g_old_rec.attribute13

312: => ota_cfs_shd.g_old_rec.attribute11
313: ,p_attribute12_o
314: => ota_cfs_shd.g_old_rec.attribute12
315: ,p_attribute13_o
316: => ota_cfs_shd.g_old_rec.attribute13
317: ,p_attribute14_o
318: => ota_cfs_shd.g_old_rec.attribute14
319: ,p_attribute15_o
320: => ota_cfs_shd.g_old_rec.attribute15

Line 318: => ota_cfs_shd.g_old_rec.attribute14

314: => ota_cfs_shd.g_old_rec.attribute12
315: ,p_attribute13_o
316: => ota_cfs_shd.g_old_rec.attribute13
317: ,p_attribute14_o
318: => ota_cfs_shd.g_old_rec.attribute14
319: ,p_attribute15_o
320: => ota_cfs_shd.g_old_rec.attribute15
321: ,p_attribute16_o
322: => ota_cfs_shd.g_old_rec.attribute16

Line 320: => ota_cfs_shd.g_old_rec.attribute15

316: => ota_cfs_shd.g_old_rec.attribute13
317: ,p_attribute14_o
318: => ota_cfs_shd.g_old_rec.attribute14
319: ,p_attribute15_o
320: => ota_cfs_shd.g_old_rec.attribute15
321: ,p_attribute16_o
322: => ota_cfs_shd.g_old_rec.attribute16
323: ,p_attribute17_o
324: => ota_cfs_shd.g_old_rec.attribute17

Line 322: => ota_cfs_shd.g_old_rec.attribute16

318: => ota_cfs_shd.g_old_rec.attribute14
319: ,p_attribute15_o
320: => ota_cfs_shd.g_old_rec.attribute15
321: ,p_attribute16_o
322: => ota_cfs_shd.g_old_rec.attribute16
323: ,p_attribute17_o
324: => ota_cfs_shd.g_old_rec.attribute17
325: ,p_attribute18_o
326: => ota_cfs_shd.g_old_rec.attribute18

Line 324: => ota_cfs_shd.g_old_rec.attribute17

320: => ota_cfs_shd.g_old_rec.attribute15
321: ,p_attribute16_o
322: => ota_cfs_shd.g_old_rec.attribute16
323: ,p_attribute17_o
324: => ota_cfs_shd.g_old_rec.attribute17
325: ,p_attribute18_o
326: => ota_cfs_shd.g_old_rec.attribute18
327: ,p_attribute19_o
328: => ota_cfs_shd.g_old_rec.attribute19

Line 326: => ota_cfs_shd.g_old_rec.attribute18

322: => ota_cfs_shd.g_old_rec.attribute16
323: ,p_attribute17_o
324: => ota_cfs_shd.g_old_rec.attribute17
325: ,p_attribute18_o
326: => ota_cfs_shd.g_old_rec.attribute18
327: ,p_attribute19_o
328: => ota_cfs_shd.g_old_rec.attribute19
329: ,p_attribute20_o
330: => ota_cfs_shd.g_old_rec.attribute20

Line 328: => ota_cfs_shd.g_old_rec.attribute19

324: => ota_cfs_shd.g_old_rec.attribute17
325: ,p_attribute18_o
326: => ota_cfs_shd.g_old_rec.attribute18
327: ,p_attribute19_o
328: => ota_cfs_shd.g_old_rec.attribute19
329: ,p_attribute20_o
330: => ota_cfs_shd.g_old_rec.attribute20
331: );
332: --

Line 330: => ota_cfs_shd.g_old_rec.attribute20

326: => ota_cfs_shd.g_old_rec.attribute18
327: ,p_attribute19_o
328: => ota_cfs_shd.g_old_rec.attribute19
329: ,p_attribute20_o
330: => ota_cfs_shd.g_old_rec.attribute20
331: );
332: --
333: exception
334: --

Line 390: (p_rec in out nocopy ota_cfs_shd.g_rec_type

386: --
387: -- {End Of Comments}
388: -- ----------------------------------------------------------------------------
389: Procedure convert_defs
390: (p_rec in out nocopy ota_cfs_shd.g_rec_type
391: ) is
392: --
393: Begin
394: --

Line 403: ota_cfs_shd.g_old_rec.url;

399: --
400:
401: If (p_rec.url = hr_api.g_varchar2) then
402: p_rec.url :=
403: ota_cfs_shd.g_old_rec.url;
404: End If;
405: If (p_rec.type = hr_api.g_varchar2) then
406: p_rec.type :=
407: ota_cfs_shd.g_old_rec.type;

Line 407: ota_cfs_shd.g_old_rec.type;

403: ota_cfs_shd.g_old_rec.url;
404: End If;
405: If (p_rec.type = hr_api.g_varchar2) then
406: p_rec.type :=
407: ota_cfs_shd.g_old_rec.type;
408: End If;
409: If (p_rec.owc_site_id = hr_api.g_varchar2) then
410: p_rec.owc_site_id :=
411: ota_cfs_shd.g_old_rec.owc_site_id;

Line 411: ota_cfs_shd.g_old_rec.owc_site_id;

407: ota_cfs_shd.g_old_rec.type;
408: End If;
409: If (p_rec.owc_site_id = hr_api.g_varchar2) then
410: p_rec.owc_site_id :=
411: ota_cfs_shd.g_old_rec.owc_site_id;
412: End If;
413: If (p_rec.owc_auth_token = hr_api.g_varchar2) then
414: p_rec.owc_auth_token :=
415: ota_cfs_shd.g_old_rec.owc_auth_token;

Line 415: ota_cfs_shd.g_old_rec.owc_auth_token;

411: ota_cfs_shd.g_old_rec.owc_site_id;
412: End If;
413: If (p_rec.owc_auth_token = hr_api.g_varchar2) then
414: p_rec.owc_auth_token :=
415: ota_cfs_shd.g_old_rec.owc_auth_token;
416: End If;
417: If (p_rec.end_date_active = hr_api.g_date) then
418: p_rec.end_date_active :=
419: ota_cfs_shd.g_old_rec.end_date_active;

Line 419: ota_cfs_shd.g_old_rec.end_date_active;

415: ota_cfs_shd.g_old_rec.owc_auth_token;
416: End If;
417: If (p_rec.end_date_active = hr_api.g_date) then
418: p_rec.end_date_active :=
419: ota_cfs_shd.g_old_rec.end_date_active;
420: End If;
421: If (p_rec.business_group_id = hr_api.g_number) then
422: p_rec.business_group_id :=
423: ota_cfs_shd.g_old_rec.business_group_id;

Line 423: ota_cfs_shd.g_old_rec.business_group_id;

419: ota_cfs_shd.g_old_rec.end_date_active;
420: End If;
421: If (p_rec.business_group_id = hr_api.g_number) then
422: p_rec.business_group_id :=
423: ota_cfs_shd.g_old_rec.business_group_id;
424: End If;
425: If (p_rec.attribute_category = hr_api.g_varchar2) then
426: p_rec.attribute_category :=
427: ota_cfs_shd.g_old_rec.attribute_category;

Line 427: ota_cfs_shd.g_old_rec.attribute_category;

423: ota_cfs_shd.g_old_rec.business_group_id;
424: End If;
425: If (p_rec.attribute_category = hr_api.g_varchar2) then
426: p_rec.attribute_category :=
427: ota_cfs_shd.g_old_rec.attribute_category;
428: End If;
429: If (p_rec.attribute1 = hr_api.g_varchar2) then
430: p_rec.attribute1 :=
431: ota_cfs_shd.g_old_rec.attribute1;

Line 431: ota_cfs_shd.g_old_rec.attribute1;

427: ota_cfs_shd.g_old_rec.attribute_category;
428: End If;
429: If (p_rec.attribute1 = hr_api.g_varchar2) then
430: p_rec.attribute1 :=
431: ota_cfs_shd.g_old_rec.attribute1;
432: End If;
433: If (p_rec.attribute2 = hr_api.g_varchar2) then
434: p_rec.attribute2 :=
435: ota_cfs_shd.g_old_rec.attribute2;

Line 435: ota_cfs_shd.g_old_rec.attribute2;

431: ota_cfs_shd.g_old_rec.attribute1;
432: End If;
433: If (p_rec.attribute2 = hr_api.g_varchar2) then
434: p_rec.attribute2 :=
435: ota_cfs_shd.g_old_rec.attribute2;
436: End If;
437: If (p_rec.attribute3 = hr_api.g_varchar2) then
438: p_rec.attribute3 :=
439: ota_cfs_shd.g_old_rec.attribute3;

Line 439: ota_cfs_shd.g_old_rec.attribute3;

435: ota_cfs_shd.g_old_rec.attribute2;
436: End If;
437: If (p_rec.attribute3 = hr_api.g_varchar2) then
438: p_rec.attribute3 :=
439: ota_cfs_shd.g_old_rec.attribute3;
440: End If;
441: If (p_rec.attribute4 = hr_api.g_varchar2) then
442: p_rec.attribute4 :=
443: ota_cfs_shd.g_old_rec.attribute4;

Line 443: ota_cfs_shd.g_old_rec.attribute4;

439: ota_cfs_shd.g_old_rec.attribute3;
440: End If;
441: If (p_rec.attribute4 = hr_api.g_varchar2) then
442: p_rec.attribute4 :=
443: ota_cfs_shd.g_old_rec.attribute4;
444: End If;
445: If (p_rec.attribute5 = hr_api.g_varchar2) then
446: p_rec.attribute5 :=
447: ota_cfs_shd.g_old_rec.attribute5;

Line 447: ota_cfs_shd.g_old_rec.attribute5;

443: ota_cfs_shd.g_old_rec.attribute4;
444: End If;
445: If (p_rec.attribute5 = hr_api.g_varchar2) then
446: p_rec.attribute5 :=
447: ota_cfs_shd.g_old_rec.attribute5;
448: End If;
449: If (p_rec.attribute6 = hr_api.g_varchar2) then
450: p_rec.attribute6 :=
451: ota_cfs_shd.g_old_rec.attribute6;

Line 451: ota_cfs_shd.g_old_rec.attribute6;

447: ota_cfs_shd.g_old_rec.attribute5;
448: End If;
449: If (p_rec.attribute6 = hr_api.g_varchar2) then
450: p_rec.attribute6 :=
451: ota_cfs_shd.g_old_rec.attribute6;
452: End If;
453: If (p_rec.attribute7 = hr_api.g_varchar2) then
454: p_rec.attribute7 :=
455: ota_cfs_shd.g_old_rec.attribute7;

Line 455: ota_cfs_shd.g_old_rec.attribute7;

451: ota_cfs_shd.g_old_rec.attribute6;
452: End If;
453: If (p_rec.attribute7 = hr_api.g_varchar2) then
454: p_rec.attribute7 :=
455: ota_cfs_shd.g_old_rec.attribute7;
456: End If;
457: If (p_rec.attribute8 = hr_api.g_varchar2) then
458: p_rec.attribute8 :=
459: ota_cfs_shd.g_old_rec.attribute8;

Line 459: ota_cfs_shd.g_old_rec.attribute8;

455: ota_cfs_shd.g_old_rec.attribute7;
456: End If;
457: If (p_rec.attribute8 = hr_api.g_varchar2) then
458: p_rec.attribute8 :=
459: ota_cfs_shd.g_old_rec.attribute8;
460: End If;
461: If (p_rec.attribute9 = hr_api.g_varchar2) then
462: p_rec.attribute9 :=
463: ota_cfs_shd.g_old_rec.attribute9;

Line 463: ota_cfs_shd.g_old_rec.attribute9;

459: ota_cfs_shd.g_old_rec.attribute8;
460: End If;
461: If (p_rec.attribute9 = hr_api.g_varchar2) then
462: p_rec.attribute9 :=
463: ota_cfs_shd.g_old_rec.attribute9;
464: End If;
465: If (p_rec.attribute10 = hr_api.g_varchar2) then
466: p_rec.attribute10 :=
467: ota_cfs_shd.g_old_rec.attribute10;

Line 467: ota_cfs_shd.g_old_rec.attribute10;

463: ota_cfs_shd.g_old_rec.attribute9;
464: End If;
465: If (p_rec.attribute10 = hr_api.g_varchar2) then
466: p_rec.attribute10 :=
467: ota_cfs_shd.g_old_rec.attribute10;
468: End If;
469: If (p_rec.attribute11 = hr_api.g_varchar2) then
470: p_rec.attribute11 :=
471: ota_cfs_shd.g_old_rec.attribute11;

Line 471: ota_cfs_shd.g_old_rec.attribute11;

467: ota_cfs_shd.g_old_rec.attribute10;
468: End If;
469: If (p_rec.attribute11 = hr_api.g_varchar2) then
470: p_rec.attribute11 :=
471: ota_cfs_shd.g_old_rec.attribute11;
472: End If;
473: If (p_rec.attribute12 = hr_api.g_varchar2) then
474: p_rec.attribute12 :=
475: ota_cfs_shd.g_old_rec.attribute12;

Line 475: ota_cfs_shd.g_old_rec.attribute12;

471: ota_cfs_shd.g_old_rec.attribute11;
472: End If;
473: If (p_rec.attribute12 = hr_api.g_varchar2) then
474: p_rec.attribute12 :=
475: ota_cfs_shd.g_old_rec.attribute12;
476: End If;
477: If (p_rec.attribute13 = hr_api.g_varchar2) then
478: p_rec.attribute13 :=
479: ota_cfs_shd.g_old_rec.attribute13;

Line 479: ota_cfs_shd.g_old_rec.attribute13;

475: ota_cfs_shd.g_old_rec.attribute12;
476: End If;
477: If (p_rec.attribute13 = hr_api.g_varchar2) then
478: p_rec.attribute13 :=
479: ota_cfs_shd.g_old_rec.attribute13;
480: End If;
481: If (p_rec.attribute14 = hr_api.g_varchar2) then
482: p_rec.attribute14 :=
483: ota_cfs_shd.g_old_rec.attribute14;

Line 483: ota_cfs_shd.g_old_rec.attribute14;

479: ota_cfs_shd.g_old_rec.attribute13;
480: End If;
481: If (p_rec.attribute14 = hr_api.g_varchar2) then
482: p_rec.attribute14 :=
483: ota_cfs_shd.g_old_rec.attribute14;
484: End If;
485: If (p_rec.attribute15 = hr_api.g_varchar2) then
486: p_rec.attribute15 :=
487: ota_cfs_shd.g_old_rec.attribute15;

Line 487: ota_cfs_shd.g_old_rec.attribute15;

483: ota_cfs_shd.g_old_rec.attribute14;
484: End If;
485: If (p_rec.attribute15 = hr_api.g_varchar2) then
486: p_rec.attribute15 :=
487: ota_cfs_shd.g_old_rec.attribute15;
488: End If;
489: If (p_rec.attribute16 = hr_api.g_varchar2) then
490: p_rec.attribute16 :=
491: ota_cfs_shd.g_old_rec.attribute16;

Line 491: ota_cfs_shd.g_old_rec.attribute16;

487: ota_cfs_shd.g_old_rec.attribute15;
488: End If;
489: If (p_rec.attribute16 = hr_api.g_varchar2) then
490: p_rec.attribute16 :=
491: ota_cfs_shd.g_old_rec.attribute16;
492: End If;
493: If (p_rec.attribute17 = hr_api.g_varchar2) then
494: p_rec.attribute17 :=
495: ota_cfs_shd.g_old_rec.attribute17;

Line 495: ota_cfs_shd.g_old_rec.attribute17;

491: ota_cfs_shd.g_old_rec.attribute16;
492: End If;
493: If (p_rec.attribute17 = hr_api.g_varchar2) then
494: p_rec.attribute17 :=
495: ota_cfs_shd.g_old_rec.attribute17;
496: End If;
497: If (p_rec.attribute18 = hr_api.g_varchar2) then
498: p_rec.attribute18 :=
499: ota_cfs_shd.g_old_rec.attribute18;

Line 499: ota_cfs_shd.g_old_rec.attribute18;

495: ota_cfs_shd.g_old_rec.attribute17;
496: End If;
497: If (p_rec.attribute18 = hr_api.g_varchar2) then
498: p_rec.attribute18 :=
499: ota_cfs_shd.g_old_rec.attribute18;
500: End If;
501: If (p_rec.attribute19 = hr_api.g_varchar2) then
502: p_rec.attribute19 :=
503: ota_cfs_shd.g_old_rec.attribute19;

Line 503: ota_cfs_shd.g_old_rec.attribute19;

499: ota_cfs_shd.g_old_rec.attribute18;
500: End If;
501: If (p_rec.attribute19 = hr_api.g_varchar2) then
502: p_rec.attribute19 :=
503: ota_cfs_shd.g_old_rec.attribute19;
504: End If;
505: If (p_rec.attribute20 = hr_api.g_varchar2) then
506: p_rec.attribute20 :=
507: ota_cfs_shd.g_old_rec.attribute20;

Line 507: ota_cfs_shd.g_old_rec.attribute20;

503: ota_cfs_shd.g_old_rec.attribute19;
504: End If;
505: If (p_rec.attribute20 = hr_api.g_varchar2) then
506: p_rec.attribute20 :=
507: ota_cfs_shd.g_old_rec.attribute20;
508: End If;
509: --
510: End convert_defs;
511: --

Line 517: ,p_rec in out nocopy ota_cfs_shd.g_rec_type

513: -- |---------------------------------< upd >----------------------------------|
514: -- ----------------------------------------------------------------------------
515: Procedure upd
516: (p_effective_date in date
517: ,p_rec in out nocopy ota_cfs_shd.g_rec_type
518: ,p_name in varchar2
519: ) is
520: --
521: l_proc varchar2(72) := g_package||'upd';

Line 528: ota_cfs_shd.lck

524: hr_utility.set_location('Entering:'||l_proc, 5);
525: --
526: -- We must lock the row which we need to update.
527: --
528: ota_cfs_shd.lck
529: (p_rec.conference_server_id
530: ,p_rec.object_version_number
531: );
532: --

Line 606: l_rec ota_cfs_shd.g_rec_type;

602: ,p_attribute19 in varchar2 default hr_api.g_varchar2
603: ,p_attribute20 in varchar2 default hr_api.g_varchar2
604: ) is
605: --
606: l_rec ota_cfs_shd.g_rec_type;
607: l_proc varchar2(72) := g_package||'upd';
608: --
609: Begin
610: hr_utility.set_location('Entering:'||l_proc, 5);

Line 616: ota_cfs_shd.convert_args

612: -- Call conversion function to turn arguments into the
613: -- l_rec structure.
614: --
615: l_rec :=
616: ota_cfs_shd.convert_args
617: (p_conference_server_id
618: ,p_name
619: ,p_description
620: ,p_url