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_CTU_UPD dependencies on OTA_CTU_SHD

Line 55: (p_rec in out nocopy ota_ctu_shd.g_rec_type

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

Line 115: ota_ctu_shd.constraint_error

111: Exception
112: When hr_api.check_integrity_violated Then
113: -- A check constraint has been violated
114: --
115: ota_ctu_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.parent_integrity_violated Then
118: -- Parent integrity has been violated
119: --

Line 120: ota_ctu_shd.constraint_error

116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.parent_integrity_violated Then
118: -- Parent integrity has been violated
119: --
120: ota_ctu_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.unique_integrity_violated Then
123: -- Unique integrity has been violated
124: --

Line 125: ota_ctu_shd.constraint_error

121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When hr_api.unique_integrity_violated Then
123: -- Unique integrity has been violated
124: --
125: ota_ctu_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When Others Then
128: --
129: Raise;

Line 165: (p_rec in ota_ctu_shd.g_rec_type

161: --
162: -- {End Of Comments}
163: -- ----------------------------------------------------------------------------
164: Procedure pre_update
165: (p_rec in ota_ctu_shd.g_rec_type
166: ) is
167: --
168: l_proc varchar2(72) := g_package||'pre_update';
169: --

Line 210: ,p_rec in ota_ctu_shd.g_rec_type

206: -- {End Of Comments}
207: -- ----------------------------------------------------------------------------
208: Procedure post_update
209: (p_effective_date in date
210: ,p_rec in ota_ctu_shd.g_rec_type
211: ) is
212: --
213: l_proc varchar2(72) := g_package||'post_update';
214: --

Line 288: => ota_ctu_shd.g_old_rec.business_group_id

284: => p_rec.data_source
285: ,p_comments
286: => p_rec.comments
287: ,p_business_group_id_o
288: => ota_ctu_shd.g_old_rec.business_group_id
289: ,p_category_o
290: => ota_ctu_shd.g_old_rec.category
291: ,p_object_version_number_o
292: => ota_ctu_shd.g_old_rec.object_version_number

Line 290: => ota_ctu_shd.g_old_rec.category

286: => p_rec.comments
287: ,p_business_group_id_o
288: => ota_ctu_shd.g_old_rec.business_group_id
289: ,p_category_o
290: => ota_ctu_shd.g_old_rec.category
291: ,p_object_version_number_o
292: => ota_ctu_shd.g_old_rec.object_version_number
293: ,p_type_o
294: => ota_ctu_shd.g_old_rec.type

Line 292: => ota_ctu_shd.g_old_rec.object_version_number

288: => ota_ctu_shd.g_old_rec.business_group_id
289: ,p_category_o
290: => ota_ctu_shd.g_old_rec.category
291: ,p_object_version_number_o
292: => ota_ctu_shd.g_old_rec.object_version_number
293: ,p_type_o
294: => ota_ctu_shd.g_old_rec.type
295: ,p_start_date_active_o
296: => ota_ctu_shd.g_old_rec.start_date_active

Line 294: => ota_ctu_shd.g_old_rec.type

290: => ota_ctu_shd.g_old_rec.category
291: ,p_object_version_number_o
292: => ota_ctu_shd.g_old_rec.object_version_number
293: ,p_type_o
294: => ota_ctu_shd.g_old_rec.type
295: ,p_start_date_active_o
296: => ota_ctu_shd.g_old_rec.start_date_active
297: ,p_end_date_active_o
298: => ota_ctu_shd.g_old_rec.end_date_active

Line 296: => ota_ctu_shd.g_old_rec.start_date_active

292: => ota_ctu_shd.g_old_rec.object_version_number
293: ,p_type_o
294: => ota_ctu_shd.g_old_rec.type
295: ,p_start_date_active_o
296: => ota_ctu_shd.g_old_rec.start_date_active
297: ,p_end_date_active_o
298: => ota_ctu_shd.g_old_rec.end_date_active
299: ,p_parent_cat_usage_id_o
300: => ota_ctu_shd.g_old_rec.parent_cat_usage_id

Line 298: => ota_ctu_shd.g_old_rec.end_date_active

294: => ota_ctu_shd.g_old_rec.type
295: ,p_start_date_active_o
296: => ota_ctu_shd.g_old_rec.start_date_active
297: ,p_end_date_active_o
298: => ota_ctu_shd.g_old_rec.end_date_active
299: ,p_parent_cat_usage_id_o
300: => ota_ctu_shd.g_old_rec.parent_cat_usage_id
301: ,p_synchronous_flag_o
302: => ota_ctu_shd.g_old_rec.synchronous_flag

Line 300: => ota_ctu_shd.g_old_rec.parent_cat_usage_id

296: => ota_ctu_shd.g_old_rec.start_date_active
297: ,p_end_date_active_o
298: => ota_ctu_shd.g_old_rec.end_date_active
299: ,p_parent_cat_usage_id_o
300: => ota_ctu_shd.g_old_rec.parent_cat_usage_id
301: ,p_synchronous_flag_o
302: => ota_ctu_shd.g_old_rec.synchronous_flag
303: ,p_online_flag_o
304: => ota_ctu_shd.g_old_rec.online_flag

Line 302: => ota_ctu_shd.g_old_rec.synchronous_flag

298: => ota_ctu_shd.g_old_rec.end_date_active
299: ,p_parent_cat_usage_id_o
300: => ota_ctu_shd.g_old_rec.parent_cat_usage_id
301: ,p_synchronous_flag_o
302: => ota_ctu_shd.g_old_rec.synchronous_flag
303: ,p_online_flag_o
304: => ota_ctu_shd.g_old_rec.online_flag
305: ,p_attribute_category_o
306: => ota_ctu_shd.g_old_rec.attribute_category

Line 304: => ota_ctu_shd.g_old_rec.online_flag

300: => ota_ctu_shd.g_old_rec.parent_cat_usage_id
301: ,p_synchronous_flag_o
302: => ota_ctu_shd.g_old_rec.synchronous_flag
303: ,p_online_flag_o
304: => ota_ctu_shd.g_old_rec.online_flag
305: ,p_attribute_category_o
306: => ota_ctu_shd.g_old_rec.attribute_category
307: ,p_attribute1_o
308: => ota_ctu_shd.g_old_rec.attribute1

Line 306: => ota_ctu_shd.g_old_rec.attribute_category

302: => ota_ctu_shd.g_old_rec.synchronous_flag
303: ,p_online_flag_o
304: => ota_ctu_shd.g_old_rec.online_flag
305: ,p_attribute_category_o
306: => ota_ctu_shd.g_old_rec.attribute_category
307: ,p_attribute1_o
308: => ota_ctu_shd.g_old_rec.attribute1
309: ,p_attribute2_o
310: => ota_ctu_shd.g_old_rec.attribute2

Line 308: => ota_ctu_shd.g_old_rec.attribute1

304: => ota_ctu_shd.g_old_rec.online_flag
305: ,p_attribute_category_o
306: => ota_ctu_shd.g_old_rec.attribute_category
307: ,p_attribute1_o
308: => ota_ctu_shd.g_old_rec.attribute1
309: ,p_attribute2_o
310: => ota_ctu_shd.g_old_rec.attribute2
311: ,p_attribute3_o
312: => ota_ctu_shd.g_old_rec.attribute3

Line 310: => ota_ctu_shd.g_old_rec.attribute2

306: => ota_ctu_shd.g_old_rec.attribute_category
307: ,p_attribute1_o
308: => ota_ctu_shd.g_old_rec.attribute1
309: ,p_attribute2_o
310: => ota_ctu_shd.g_old_rec.attribute2
311: ,p_attribute3_o
312: => ota_ctu_shd.g_old_rec.attribute3
313: ,p_attribute4_o
314: => ota_ctu_shd.g_old_rec.attribute4

Line 312: => ota_ctu_shd.g_old_rec.attribute3

308: => ota_ctu_shd.g_old_rec.attribute1
309: ,p_attribute2_o
310: => ota_ctu_shd.g_old_rec.attribute2
311: ,p_attribute3_o
312: => ota_ctu_shd.g_old_rec.attribute3
313: ,p_attribute4_o
314: => ota_ctu_shd.g_old_rec.attribute4
315: ,p_attribute5_o
316: => ota_ctu_shd.g_old_rec.attribute5

Line 314: => ota_ctu_shd.g_old_rec.attribute4

310: => ota_ctu_shd.g_old_rec.attribute2
311: ,p_attribute3_o
312: => ota_ctu_shd.g_old_rec.attribute3
313: ,p_attribute4_o
314: => ota_ctu_shd.g_old_rec.attribute4
315: ,p_attribute5_o
316: => ota_ctu_shd.g_old_rec.attribute5
317: ,p_attribute6_o
318: => ota_ctu_shd.g_old_rec.attribute6

Line 316: => ota_ctu_shd.g_old_rec.attribute5

312: => ota_ctu_shd.g_old_rec.attribute3
313: ,p_attribute4_o
314: => ota_ctu_shd.g_old_rec.attribute4
315: ,p_attribute5_o
316: => ota_ctu_shd.g_old_rec.attribute5
317: ,p_attribute6_o
318: => ota_ctu_shd.g_old_rec.attribute6
319: ,p_attribute7_o
320: => ota_ctu_shd.g_old_rec.attribute7

Line 318: => ota_ctu_shd.g_old_rec.attribute6

314: => ota_ctu_shd.g_old_rec.attribute4
315: ,p_attribute5_o
316: => ota_ctu_shd.g_old_rec.attribute5
317: ,p_attribute6_o
318: => ota_ctu_shd.g_old_rec.attribute6
319: ,p_attribute7_o
320: => ota_ctu_shd.g_old_rec.attribute7
321: ,p_attribute8_o
322: => ota_ctu_shd.g_old_rec.attribute8

Line 320: => ota_ctu_shd.g_old_rec.attribute7

316: => ota_ctu_shd.g_old_rec.attribute5
317: ,p_attribute6_o
318: => ota_ctu_shd.g_old_rec.attribute6
319: ,p_attribute7_o
320: => ota_ctu_shd.g_old_rec.attribute7
321: ,p_attribute8_o
322: => ota_ctu_shd.g_old_rec.attribute8
323: ,p_attribute9_o
324: => ota_ctu_shd.g_old_rec.attribute9

Line 322: => ota_ctu_shd.g_old_rec.attribute8

318: => ota_ctu_shd.g_old_rec.attribute6
319: ,p_attribute7_o
320: => ota_ctu_shd.g_old_rec.attribute7
321: ,p_attribute8_o
322: => ota_ctu_shd.g_old_rec.attribute8
323: ,p_attribute9_o
324: => ota_ctu_shd.g_old_rec.attribute9
325: ,p_attribute10_o
326: => ota_ctu_shd.g_old_rec.attribute10

Line 324: => ota_ctu_shd.g_old_rec.attribute9

320: => ota_ctu_shd.g_old_rec.attribute7
321: ,p_attribute8_o
322: => ota_ctu_shd.g_old_rec.attribute8
323: ,p_attribute9_o
324: => ota_ctu_shd.g_old_rec.attribute9
325: ,p_attribute10_o
326: => ota_ctu_shd.g_old_rec.attribute10
327: ,p_attribute11_o
328: => ota_ctu_shd.g_old_rec.attribute11

Line 326: => ota_ctu_shd.g_old_rec.attribute10

322: => ota_ctu_shd.g_old_rec.attribute8
323: ,p_attribute9_o
324: => ota_ctu_shd.g_old_rec.attribute9
325: ,p_attribute10_o
326: => ota_ctu_shd.g_old_rec.attribute10
327: ,p_attribute11_o
328: => ota_ctu_shd.g_old_rec.attribute11
329: ,p_attribute12_o
330: => ota_ctu_shd.g_old_rec.attribute12

Line 328: => ota_ctu_shd.g_old_rec.attribute11

324: => ota_ctu_shd.g_old_rec.attribute9
325: ,p_attribute10_o
326: => ota_ctu_shd.g_old_rec.attribute10
327: ,p_attribute11_o
328: => ota_ctu_shd.g_old_rec.attribute11
329: ,p_attribute12_o
330: => ota_ctu_shd.g_old_rec.attribute12
331: ,p_attribute13_o
332: => ota_ctu_shd.g_old_rec.attribute13

Line 330: => ota_ctu_shd.g_old_rec.attribute12

326: => ota_ctu_shd.g_old_rec.attribute10
327: ,p_attribute11_o
328: => ota_ctu_shd.g_old_rec.attribute11
329: ,p_attribute12_o
330: => ota_ctu_shd.g_old_rec.attribute12
331: ,p_attribute13_o
332: => ota_ctu_shd.g_old_rec.attribute13
333: ,p_attribute14_o
334: => ota_ctu_shd.g_old_rec.attribute14

Line 332: => ota_ctu_shd.g_old_rec.attribute13

328: => ota_ctu_shd.g_old_rec.attribute11
329: ,p_attribute12_o
330: => ota_ctu_shd.g_old_rec.attribute12
331: ,p_attribute13_o
332: => ota_ctu_shd.g_old_rec.attribute13
333: ,p_attribute14_o
334: => ota_ctu_shd.g_old_rec.attribute14
335: ,p_attribute15_o
336: => ota_ctu_shd.g_old_rec.attribute15

Line 334: => ota_ctu_shd.g_old_rec.attribute14

330: => ota_ctu_shd.g_old_rec.attribute12
331: ,p_attribute13_o
332: => ota_ctu_shd.g_old_rec.attribute13
333: ,p_attribute14_o
334: => ota_ctu_shd.g_old_rec.attribute14
335: ,p_attribute15_o
336: => ota_ctu_shd.g_old_rec.attribute15
337: ,p_attribute16_o
338: => ota_ctu_shd.g_old_rec.attribute16

Line 336: => ota_ctu_shd.g_old_rec.attribute15

332: => ota_ctu_shd.g_old_rec.attribute13
333: ,p_attribute14_o
334: => ota_ctu_shd.g_old_rec.attribute14
335: ,p_attribute15_o
336: => ota_ctu_shd.g_old_rec.attribute15
337: ,p_attribute16_o
338: => ota_ctu_shd.g_old_rec.attribute16
339: ,p_attribute17_o
340: => ota_ctu_shd.g_old_rec.attribute17

Line 338: => ota_ctu_shd.g_old_rec.attribute16

334: => ota_ctu_shd.g_old_rec.attribute14
335: ,p_attribute15_o
336: => ota_ctu_shd.g_old_rec.attribute15
337: ,p_attribute16_o
338: => ota_ctu_shd.g_old_rec.attribute16
339: ,p_attribute17_o
340: => ota_ctu_shd.g_old_rec.attribute17
341: ,p_attribute18_o
342: => ota_ctu_shd.g_old_rec.attribute18

Line 340: => ota_ctu_shd.g_old_rec.attribute17

336: => ota_ctu_shd.g_old_rec.attribute15
337: ,p_attribute16_o
338: => ota_ctu_shd.g_old_rec.attribute16
339: ,p_attribute17_o
340: => ota_ctu_shd.g_old_rec.attribute17
341: ,p_attribute18_o
342: => ota_ctu_shd.g_old_rec.attribute18
343: ,p_attribute19_o
344: => ota_ctu_shd.g_old_rec.attribute19

Line 342: => ota_ctu_shd.g_old_rec.attribute18

338: => ota_ctu_shd.g_old_rec.attribute16
339: ,p_attribute17_o
340: => ota_ctu_shd.g_old_rec.attribute17
341: ,p_attribute18_o
342: => ota_ctu_shd.g_old_rec.attribute18
343: ,p_attribute19_o
344: => ota_ctu_shd.g_old_rec.attribute19
345: ,p_attribute20_o
346: => ota_ctu_shd.g_old_rec.attribute20

Line 344: => ota_ctu_shd.g_old_rec.attribute19

340: => ota_ctu_shd.g_old_rec.attribute17
341: ,p_attribute18_o
342: => ota_ctu_shd.g_old_rec.attribute18
343: ,p_attribute19_o
344: => ota_ctu_shd.g_old_rec.attribute19
345: ,p_attribute20_o
346: => ota_ctu_shd.g_old_rec.attribute20
347: ,p_data_source_o
348: => ota_ctu_shd.g_old_rec.data_source

Line 346: => ota_ctu_shd.g_old_rec.attribute20

342: => ota_ctu_shd.g_old_rec.attribute18
343: ,p_attribute19_o
344: => ota_ctu_shd.g_old_rec.attribute19
345: ,p_attribute20_o
346: => ota_ctu_shd.g_old_rec.attribute20
347: ,p_data_source_o
348: => ota_ctu_shd.g_old_rec.data_source
349: ,p_comments_o
350: => ota_ctu_shd.g_old_rec.comments

Line 348: => ota_ctu_shd.g_old_rec.data_source

344: => ota_ctu_shd.g_old_rec.attribute19
345: ,p_attribute20_o
346: => ota_ctu_shd.g_old_rec.attribute20
347: ,p_data_source_o
348: => ota_ctu_shd.g_old_rec.data_source
349: ,p_comments_o
350: => ota_ctu_shd.g_old_rec.comments
351:
352: );

Line 350: => ota_ctu_shd.g_old_rec.comments

346: => ota_ctu_shd.g_old_rec.attribute20
347: ,p_data_source_o
348: => ota_ctu_shd.g_old_rec.data_source
349: ,p_comments_o
350: => ota_ctu_shd.g_old_rec.comments
351:
352: );
353: --
354: exception

Line 411: (p_rec in out nocopy ota_ctu_shd.g_rec_type

407: --
408: -- {End Of Comments}
409: -- ----------------------------------------------------------------------------
410: Procedure convert_defs
411: (p_rec in out nocopy ota_ctu_shd.g_rec_type
412: ) is
413: --
414: Begin
415: --

Line 423: ota_ctu_shd.g_old_rec.business_group_id;

419: -- is being used then we must set to the 'current' argument value.
420: --
421: If (p_rec.business_group_id = hr_api.g_number) then
422: p_rec.business_group_id :=
423: ota_ctu_shd.g_old_rec.business_group_id;
424: End If;
425: If (p_rec.category = hr_api.g_varchar2) then
426: p_rec.category :=
427: ota_ctu_shd.g_old_rec.category;

Line 427: ota_ctu_shd.g_old_rec.category;

423: ota_ctu_shd.g_old_rec.business_group_id;
424: End If;
425: If (p_rec.category = hr_api.g_varchar2) then
426: p_rec.category :=
427: ota_ctu_shd.g_old_rec.category;
428: End If;
429: If (p_rec.type = hr_api.g_varchar2) then
430: p_rec.type :=
431: ota_ctu_shd.g_old_rec.type;

Line 431: ota_ctu_shd.g_old_rec.type;

427: ota_ctu_shd.g_old_rec.category;
428: End If;
429: If (p_rec.type = hr_api.g_varchar2) then
430: p_rec.type :=
431: ota_ctu_shd.g_old_rec.type;
432: End If;
433: If (p_rec.start_date_active = hr_api.g_date) then
434: p_rec.start_date_active :=
435: ota_ctu_shd.g_old_rec.start_date_active;

Line 435: ota_ctu_shd.g_old_rec.start_date_active;

431: ota_ctu_shd.g_old_rec.type;
432: End If;
433: If (p_rec.start_date_active = hr_api.g_date) then
434: p_rec.start_date_active :=
435: ota_ctu_shd.g_old_rec.start_date_active;
436: End If;
437: If (p_rec.end_date_active = hr_api.g_date) then
438: p_rec.end_date_active :=
439: ota_ctu_shd.g_old_rec.end_date_active;

Line 439: ota_ctu_shd.g_old_rec.end_date_active;

435: ota_ctu_shd.g_old_rec.start_date_active;
436: End If;
437: If (p_rec.end_date_active = hr_api.g_date) then
438: p_rec.end_date_active :=
439: ota_ctu_shd.g_old_rec.end_date_active;
440: End If;
441: If (p_rec.parent_cat_usage_id = hr_api.g_number) then
442: p_rec.parent_cat_usage_id :=
443: ota_ctu_shd.g_old_rec.parent_cat_usage_id;

Line 443: ota_ctu_shd.g_old_rec.parent_cat_usage_id;

439: ota_ctu_shd.g_old_rec.end_date_active;
440: End If;
441: If (p_rec.parent_cat_usage_id = hr_api.g_number) then
442: p_rec.parent_cat_usage_id :=
443: ota_ctu_shd.g_old_rec.parent_cat_usage_id;
444: End If;
445: If (p_rec.synchronous_flag = hr_api.g_varchar2) then
446: p_rec.synchronous_flag :=
447: ota_ctu_shd.g_old_rec.synchronous_flag;

Line 447: ota_ctu_shd.g_old_rec.synchronous_flag;

443: ota_ctu_shd.g_old_rec.parent_cat_usage_id;
444: End If;
445: If (p_rec.synchronous_flag = hr_api.g_varchar2) then
446: p_rec.synchronous_flag :=
447: ota_ctu_shd.g_old_rec.synchronous_flag;
448: End If;
449: If (p_rec.attribute_category = hr_api.g_varchar2) then
450: p_rec.attribute_category :=
451: ota_ctu_shd.g_old_rec.attribute_category;

Line 451: ota_ctu_shd.g_old_rec.attribute_category;

447: ota_ctu_shd.g_old_rec.synchronous_flag;
448: End If;
449: If (p_rec.attribute_category = hr_api.g_varchar2) then
450: p_rec.attribute_category :=
451: ota_ctu_shd.g_old_rec.attribute_category;
452: End If;
453: If (p_rec.attribute1 = hr_api.g_varchar2) then
454: p_rec.attribute1 :=
455: ota_ctu_shd.g_old_rec.attribute1;

Line 455: ota_ctu_shd.g_old_rec.attribute1;

451: ota_ctu_shd.g_old_rec.attribute_category;
452: End If;
453: If (p_rec.attribute1 = hr_api.g_varchar2) then
454: p_rec.attribute1 :=
455: ota_ctu_shd.g_old_rec.attribute1;
456: End If;
457: If (p_rec.attribute2 = hr_api.g_varchar2) then
458: p_rec.attribute2 :=
459: ota_ctu_shd.g_old_rec.attribute2;

Line 459: ota_ctu_shd.g_old_rec.attribute2;

455: ota_ctu_shd.g_old_rec.attribute1;
456: End If;
457: If (p_rec.attribute2 = hr_api.g_varchar2) then
458: p_rec.attribute2 :=
459: ota_ctu_shd.g_old_rec.attribute2;
460: End If;
461: If (p_rec.attribute3 = hr_api.g_varchar2) then
462: p_rec.attribute3 :=
463: ota_ctu_shd.g_old_rec.attribute3;

Line 463: ota_ctu_shd.g_old_rec.attribute3;

459: ota_ctu_shd.g_old_rec.attribute2;
460: End If;
461: If (p_rec.attribute3 = hr_api.g_varchar2) then
462: p_rec.attribute3 :=
463: ota_ctu_shd.g_old_rec.attribute3;
464: End If;
465: If (p_rec.attribute4 = hr_api.g_varchar2) then
466: p_rec.attribute4 :=
467: ota_ctu_shd.g_old_rec.attribute4;

Line 467: ota_ctu_shd.g_old_rec.attribute4;

463: ota_ctu_shd.g_old_rec.attribute3;
464: End If;
465: If (p_rec.attribute4 = hr_api.g_varchar2) then
466: p_rec.attribute4 :=
467: ota_ctu_shd.g_old_rec.attribute4;
468: End If;
469: If (p_rec.attribute5 = hr_api.g_varchar2) then
470: p_rec.attribute5 :=
471: ota_ctu_shd.g_old_rec.attribute5;

Line 471: ota_ctu_shd.g_old_rec.attribute5;

467: ota_ctu_shd.g_old_rec.attribute4;
468: End If;
469: If (p_rec.attribute5 = hr_api.g_varchar2) then
470: p_rec.attribute5 :=
471: ota_ctu_shd.g_old_rec.attribute5;
472: End If;
473: If (p_rec.attribute6 = hr_api.g_varchar2) then
474: p_rec.attribute6 :=
475: ota_ctu_shd.g_old_rec.attribute6;

Line 475: ota_ctu_shd.g_old_rec.attribute6;

471: ota_ctu_shd.g_old_rec.attribute5;
472: End If;
473: If (p_rec.attribute6 = hr_api.g_varchar2) then
474: p_rec.attribute6 :=
475: ota_ctu_shd.g_old_rec.attribute6;
476: End If;
477: If (p_rec.attribute7 = hr_api.g_varchar2) then
478: p_rec.attribute7 :=
479: ota_ctu_shd.g_old_rec.attribute7;

Line 479: ota_ctu_shd.g_old_rec.attribute7;

475: ota_ctu_shd.g_old_rec.attribute6;
476: End If;
477: If (p_rec.attribute7 = hr_api.g_varchar2) then
478: p_rec.attribute7 :=
479: ota_ctu_shd.g_old_rec.attribute7;
480: End If;
481: If (p_rec.attribute8 = hr_api.g_varchar2) then
482: p_rec.attribute8 :=
483: ota_ctu_shd.g_old_rec.attribute8;

Line 483: ota_ctu_shd.g_old_rec.attribute8;

479: ota_ctu_shd.g_old_rec.attribute7;
480: End If;
481: If (p_rec.attribute8 = hr_api.g_varchar2) then
482: p_rec.attribute8 :=
483: ota_ctu_shd.g_old_rec.attribute8;
484: End If;
485: If (p_rec.attribute9 = hr_api.g_varchar2) then
486: p_rec.attribute9 :=
487: ota_ctu_shd.g_old_rec.attribute9;

Line 487: ota_ctu_shd.g_old_rec.attribute9;

483: ota_ctu_shd.g_old_rec.attribute8;
484: End If;
485: If (p_rec.attribute9 = hr_api.g_varchar2) then
486: p_rec.attribute9 :=
487: ota_ctu_shd.g_old_rec.attribute9;
488: End If;
489: If (p_rec.attribute10 = hr_api.g_varchar2) then
490: p_rec.attribute10 :=
491: ota_ctu_shd.g_old_rec.attribute10;

Line 491: ota_ctu_shd.g_old_rec.attribute10;

487: ota_ctu_shd.g_old_rec.attribute9;
488: End If;
489: If (p_rec.attribute10 = hr_api.g_varchar2) then
490: p_rec.attribute10 :=
491: ota_ctu_shd.g_old_rec.attribute10;
492: End If;
493: If (p_rec.attribute11 = hr_api.g_varchar2) then
494: p_rec.attribute11 :=
495: ota_ctu_shd.g_old_rec.attribute11;

Line 495: ota_ctu_shd.g_old_rec.attribute11;

491: ota_ctu_shd.g_old_rec.attribute10;
492: End If;
493: If (p_rec.attribute11 = hr_api.g_varchar2) then
494: p_rec.attribute11 :=
495: ota_ctu_shd.g_old_rec.attribute11;
496: End If;
497: If (p_rec.attribute12 = hr_api.g_varchar2) then
498: p_rec.attribute12 :=
499: ota_ctu_shd.g_old_rec.attribute12;

Line 499: ota_ctu_shd.g_old_rec.attribute12;

495: ota_ctu_shd.g_old_rec.attribute11;
496: End If;
497: If (p_rec.attribute12 = hr_api.g_varchar2) then
498: p_rec.attribute12 :=
499: ota_ctu_shd.g_old_rec.attribute12;
500: End If;
501: If (p_rec.attribute13 = hr_api.g_varchar2) then
502: p_rec.attribute13 :=
503: ota_ctu_shd.g_old_rec.attribute13;

Line 503: ota_ctu_shd.g_old_rec.attribute13;

499: ota_ctu_shd.g_old_rec.attribute12;
500: End If;
501: If (p_rec.attribute13 = hr_api.g_varchar2) then
502: p_rec.attribute13 :=
503: ota_ctu_shd.g_old_rec.attribute13;
504: End If;
505: If (p_rec.attribute14 = hr_api.g_varchar2) then
506: p_rec.attribute14 :=
507: ota_ctu_shd.g_old_rec.attribute14;

Line 507: ota_ctu_shd.g_old_rec.attribute14;

503: ota_ctu_shd.g_old_rec.attribute13;
504: End If;
505: If (p_rec.attribute14 = hr_api.g_varchar2) then
506: p_rec.attribute14 :=
507: ota_ctu_shd.g_old_rec.attribute14;
508: End If;
509: If (p_rec.attribute15 = hr_api.g_varchar2) then
510: p_rec.attribute15 :=
511: ota_ctu_shd.g_old_rec.attribute15;

Line 511: ota_ctu_shd.g_old_rec.attribute15;

507: ota_ctu_shd.g_old_rec.attribute14;
508: End If;
509: If (p_rec.attribute15 = hr_api.g_varchar2) then
510: p_rec.attribute15 :=
511: ota_ctu_shd.g_old_rec.attribute15;
512: End If;
513: If (p_rec.attribute16 = hr_api.g_varchar2) then
514: p_rec.attribute16 :=
515: ota_ctu_shd.g_old_rec.attribute16;

Line 515: ota_ctu_shd.g_old_rec.attribute16;

511: ota_ctu_shd.g_old_rec.attribute15;
512: End If;
513: If (p_rec.attribute16 = hr_api.g_varchar2) then
514: p_rec.attribute16 :=
515: ota_ctu_shd.g_old_rec.attribute16;
516: End If;
517: If (p_rec.attribute17 = hr_api.g_varchar2) then
518: p_rec.attribute17 :=
519: ota_ctu_shd.g_old_rec.attribute17;

Line 519: ota_ctu_shd.g_old_rec.attribute17;

515: ota_ctu_shd.g_old_rec.attribute16;
516: End If;
517: If (p_rec.attribute17 = hr_api.g_varchar2) then
518: p_rec.attribute17 :=
519: ota_ctu_shd.g_old_rec.attribute17;
520: End If;
521: If (p_rec.attribute18 = hr_api.g_varchar2) then
522: p_rec.attribute18 :=
523: ota_ctu_shd.g_old_rec.attribute18;

Line 523: ota_ctu_shd.g_old_rec.attribute18;

519: ota_ctu_shd.g_old_rec.attribute17;
520: End If;
521: If (p_rec.attribute18 = hr_api.g_varchar2) then
522: p_rec.attribute18 :=
523: ota_ctu_shd.g_old_rec.attribute18;
524: End If;
525: If (p_rec.attribute19 = hr_api.g_varchar2) then
526: p_rec.attribute19 :=
527: ota_ctu_shd.g_old_rec.attribute19;

Line 527: ota_ctu_shd.g_old_rec.attribute19;

523: ota_ctu_shd.g_old_rec.attribute18;
524: End If;
525: If (p_rec.attribute19 = hr_api.g_varchar2) then
526: p_rec.attribute19 :=
527: ota_ctu_shd.g_old_rec.attribute19;
528: End If;
529: If (p_rec.attribute20 = hr_api.g_varchar2) then
530: p_rec.attribute20 :=
531: ota_ctu_shd.g_old_rec.attribute20;

Line 531: ota_ctu_shd.g_old_rec.attribute20;

527: ota_ctu_shd.g_old_rec.attribute19;
528: End If;
529: If (p_rec.attribute20 = hr_api.g_varchar2) then
530: p_rec.attribute20 :=
531: ota_ctu_shd.g_old_rec.attribute20;
532: End If;
533: If (p_rec.data_source = hr_api.g_varchar2) then
534: p_rec.data_source :=
535: ota_ctu_shd.g_old_rec.data_source;

Line 535: ota_ctu_shd.g_old_rec.data_source;

531: ota_ctu_shd.g_old_rec.attribute20;
532: End If;
533: If (p_rec.data_source = hr_api.g_varchar2) then
534: p_rec.data_source :=
535: ota_ctu_shd.g_old_rec.data_source;
536: End If;
537: If (p_rec.online_flag = hr_api.g_varchar2) then
538: p_rec.online_flag :=
539: ota_ctu_shd.g_old_rec.online_flag;

Line 539: ota_ctu_shd.g_old_rec.online_flag;

535: ota_ctu_shd.g_old_rec.data_source;
536: End If;
537: If (p_rec.online_flag = hr_api.g_varchar2) then
538: p_rec.online_flag :=
539: ota_ctu_shd.g_old_rec.online_flag;
540: End If;
541: If (p_rec.comments = hr_api.g_varchar2) then
542: p_rec.comments :=
543: ota_ctu_shd.g_old_rec.comments;

Line 543: ota_ctu_shd.g_old_rec.comments;

539: ota_ctu_shd.g_old_rec.online_flag;
540: End If;
541: If (p_rec.comments = hr_api.g_varchar2) then
542: p_rec.comments :=
543: ota_ctu_shd.g_old_rec.comments;
544: End If;
545:
546: --
547: End convert_defs;

Line 554: ,p_rec in out nocopy ota_ctu_shd.g_rec_type

550: -- |---------------------------------< upd >----------------------------------|
551: -- ----------------------------------------------------------------------------
552: Procedure upd
553: (p_effective_date in date
554: ,p_rec in out nocopy ota_ctu_shd.g_rec_type
555: ) is
556: --
557: l_proc varchar2(72) := g_package||'upd';
558: --

Line 564: ota_ctu_shd.lck

560: hr_utility.set_location('Entering:'||l_proc, 5);
561: --
562: -- We must lock the row which we need to update.
563: --
564: ota_ctu_shd.lck
565: (p_rec.category_usage_id
566: ,p_rec.object_version_number
567: );
568: --

Line 643: l_rec ota_ctu_shd.g_rec_type;

639: ,p_data_source in varchar2 default hr_api.g_varchar2
640: ,p_comments in varchar2 default hr_api.g_varchar2
641: ) is
642: --
643: l_rec ota_ctu_shd.g_rec_type;
644: l_proc varchar2(72) := g_package||'upd';
645: --
646: Begin
647: hr_utility.set_location('Entering:'||l_proc, 5);

Line 653: ota_ctu_shd.convert_args

649: -- Call conversion function to turn arguments into the
650: -- l_rec structure.
651: --
652: l_rec :=
653: ota_ctu_shd.convert_args
654: (p_category_usage_id
655: ,p_business_group_id
656: ,p_category
657: ,p_object_version_number