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_TMT_UPD dependencies on OTA_TMT_SHD

Line 55: (p_rec in out nocopy ota_tmt_shd.g_rec_type

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

Line 121: ota_tmt_shd.constraint_error

117: Exception
118: When hr_api.check_integrity_violated Then
119: -- A check constraint has been violated
120: --
121: ota_tmt_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.parent_integrity_violated Then
124: -- Parent integrity has been violated
125: --

Line 126: ota_tmt_shd.constraint_error

122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.parent_integrity_violated Then
124: -- Parent integrity has been violated
125: --
126: ota_tmt_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When hr_api.unique_integrity_violated Then
129: -- Unique integrity has been violated
130: --

Line 131: ota_tmt_shd.constraint_error

127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When hr_api.unique_integrity_violated Then
129: -- Unique integrity has been violated
130: --
131: ota_tmt_shd.constraint_error
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When Others Then
134: --
135: Raise;

Line 171: (p_rec in ota_tmt_shd.g_rec_type

167: --
168: -- {End Of Comments}
169: -- ----------------------------------------------------------------------------
170: Procedure pre_update
171: (p_rec in ota_tmt_shd.g_rec_type
172: ) is
173: --
174: l_proc varchar2(72) := g_package||'pre_update';
175: --

Line 216: ,p_rec in ota_tmt_shd.g_rec_type

212: -- {End Of Comments}
213: -- ----------------------------------------------------------------------------
214: Procedure post_update
215: (p_effective_date in date
216: ,p_rec in ota_tmt_shd.g_rec_type
217: ) is
218: --
219: l_proc varchar2(72) := g_package||'post_update';
220: --

Line 310: => ota_tmt_shd.g_old_rec.tp_measurement_code

306: => p_rec.attribute29
307: ,p_attribute30
308: => p_rec.attribute30
309: ,p_tp_measurement_code_o
310: => ota_tmt_shd.g_old_rec.tp_measurement_code
311: ,p_unit_o
312: => ota_tmt_shd.g_old_rec.unit
313: ,p_reporting_sequence_o
314: => ota_tmt_shd.g_old_rec.reporting_sequence

Line 312: => ota_tmt_shd.g_old_rec.unit

308: => p_rec.attribute30
309: ,p_tp_measurement_code_o
310: => ota_tmt_shd.g_old_rec.tp_measurement_code
311: ,p_unit_o
312: => ota_tmt_shd.g_old_rec.unit
313: ,p_reporting_sequence_o
314: => ota_tmt_shd.g_old_rec.reporting_sequence
315: ,p_budget_level_o
316: => ota_tmt_shd.g_old_rec.budget_level

Line 314: => ota_tmt_shd.g_old_rec.reporting_sequence

310: => ota_tmt_shd.g_old_rec.tp_measurement_code
311: ,p_unit_o
312: => ota_tmt_shd.g_old_rec.unit
313: ,p_reporting_sequence_o
314: => ota_tmt_shd.g_old_rec.reporting_sequence
315: ,p_budget_level_o
316: => ota_tmt_shd.g_old_rec.budget_level
317: ,p_cost_level_o
318: => ota_tmt_shd.g_old_rec.cost_level

Line 316: => ota_tmt_shd.g_old_rec.budget_level

312: => ota_tmt_shd.g_old_rec.unit
313: ,p_reporting_sequence_o
314: => ota_tmt_shd.g_old_rec.reporting_sequence
315: ,p_budget_level_o
316: => ota_tmt_shd.g_old_rec.budget_level
317: ,p_cost_level_o
318: => ota_tmt_shd.g_old_rec.cost_level
319: ,p_many_budget_values_flag_o
320: => ota_tmt_shd.g_old_rec.many_budget_values_flag

Line 318: => ota_tmt_shd.g_old_rec.cost_level

314: => ota_tmt_shd.g_old_rec.reporting_sequence
315: ,p_budget_level_o
316: => ota_tmt_shd.g_old_rec.budget_level
317: ,p_cost_level_o
318: => ota_tmt_shd.g_old_rec.cost_level
319: ,p_many_budget_values_flag_o
320: => ota_tmt_shd.g_old_rec.many_budget_values_flag
321: ,p_item_type_usage_id_o
322: => ota_tmt_shd.g_old_rec.item_type_usage_id

Line 320: => ota_tmt_shd.g_old_rec.many_budget_values_flag

316: => ota_tmt_shd.g_old_rec.budget_level
317: ,p_cost_level_o
318: => ota_tmt_shd.g_old_rec.cost_level
319: ,p_many_budget_values_flag_o
320: => ota_tmt_shd.g_old_rec.many_budget_values_flag
321: ,p_item_type_usage_id_o
322: => ota_tmt_shd.g_old_rec.item_type_usage_id
323: ,p_business_group_id_o
324: => ota_tmt_shd.g_old_rec.business_group_id

Line 322: => ota_tmt_shd.g_old_rec.item_type_usage_id

318: => ota_tmt_shd.g_old_rec.cost_level
319: ,p_many_budget_values_flag_o
320: => ota_tmt_shd.g_old_rec.many_budget_values_flag
321: ,p_item_type_usage_id_o
322: => ota_tmt_shd.g_old_rec.item_type_usage_id
323: ,p_business_group_id_o
324: => ota_tmt_shd.g_old_rec.business_group_id
325: ,p_object_version_number_o
326: => ota_tmt_shd.g_old_rec.object_version_number

Line 324: => ota_tmt_shd.g_old_rec.business_group_id

320: => ota_tmt_shd.g_old_rec.many_budget_values_flag
321: ,p_item_type_usage_id_o
322: => ota_tmt_shd.g_old_rec.item_type_usage_id
323: ,p_business_group_id_o
324: => ota_tmt_shd.g_old_rec.business_group_id
325: ,p_object_version_number_o
326: => ota_tmt_shd.g_old_rec.object_version_number
327: ,p_attribute_category_o
328: => ota_tmt_shd.g_old_rec.attribute_category

Line 326: => ota_tmt_shd.g_old_rec.object_version_number

322: => ota_tmt_shd.g_old_rec.item_type_usage_id
323: ,p_business_group_id_o
324: => ota_tmt_shd.g_old_rec.business_group_id
325: ,p_object_version_number_o
326: => ota_tmt_shd.g_old_rec.object_version_number
327: ,p_attribute_category_o
328: => ota_tmt_shd.g_old_rec.attribute_category
329: ,p_attribute1_o
330: => ota_tmt_shd.g_old_rec.attribute1

Line 328: => ota_tmt_shd.g_old_rec.attribute_category

324: => ota_tmt_shd.g_old_rec.business_group_id
325: ,p_object_version_number_o
326: => ota_tmt_shd.g_old_rec.object_version_number
327: ,p_attribute_category_o
328: => ota_tmt_shd.g_old_rec.attribute_category
329: ,p_attribute1_o
330: => ota_tmt_shd.g_old_rec.attribute1
331: ,p_attribute2_o
332: => ota_tmt_shd.g_old_rec.attribute2

Line 330: => ota_tmt_shd.g_old_rec.attribute1

326: => ota_tmt_shd.g_old_rec.object_version_number
327: ,p_attribute_category_o
328: => ota_tmt_shd.g_old_rec.attribute_category
329: ,p_attribute1_o
330: => ota_tmt_shd.g_old_rec.attribute1
331: ,p_attribute2_o
332: => ota_tmt_shd.g_old_rec.attribute2
333: ,p_attribute3_o
334: => ota_tmt_shd.g_old_rec.attribute3

Line 332: => ota_tmt_shd.g_old_rec.attribute2

328: => ota_tmt_shd.g_old_rec.attribute_category
329: ,p_attribute1_o
330: => ota_tmt_shd.g_old_rec.attribute1
331: ,p_attribute2_o
332: => ota_tmt_shd.g_old_rec.attribute2
333: ,p_attribute3_o
334: => ota_tmt_shd.g_old_rec.attribute3
335: ,p_attribute4_o
336: => ota_tmt_shd.g_old_rec.attribute4

Line 334: => ota_tmt_shd.g_old_rec.attribute3

330: => ota_tmt_shd.g_old_rec.attribute1
331: ,p_attribute2_o
332: => ota_tmt_shd.g_old_rec.attribute2
333: ,p_attribute3_o
334: => ota_tmt_shd.g_old_rec.attribute3
335: ,p_attribute4_o
336: => ota_tmt_shd.g_old_rec.attribute4
337: ,p_attribute5_o
338: => ota_tmt_shd.g_old_rec.attribute5

Line 336: => ota_tmt_shd.g_old_rec.attribute4

332: => ota_tmt_shd.g_old_rec.attribute2
333: ,p_attribute3_o
334: => ota_tmt_shd.g_old_rec.attribute3
335: ,p_attribute4_o
336: => ota_tmt_shd.g_old_rec.attribute4
337: ,p_attribute5_o
338: => ota_tmt_shd.g_old_rec.attribute5
339: ,p_attribute6_o
340: => ota_tmt_shd.g_old_rec.attribute6

Line 338: => ota_tmt_shd.g_old_rec.attribute5

334: => ota_tmt_shd.g_old_rec.attribute3
335: ,p_attribute4_o
336: => ota_tmt_shd.g_old_rec.attribute4
337: ,p_attribute5_o
338: => ota_tmt_shd.g_old_rec.attribute5
339: ,p_attribute6_o
340: => ota_tmt_shd.g_old_rec.attribute6
341: ,p_attribute7_o
342: => ota_tmt_shd.g_old_rec.attribute7

Line 340: => ota_tmt_shd.g_old_rec.attribute6

336: => ota_tmt_shd.g_old_rec.attribute4
337: ,p_attribute5_o
338: => ota_tmt_shd.g_old_rec.attribute5
339: ,p_attribute6_o
340: => ota_tmt_shd.g_old_rec.attribute6
341: ,p_attribute7_o
342: => ota_tmt_shd.g_old_rec.attribute7
343: ,p_attribute8_o
344: => ota_tmt_shd.g_old_rec.attribute8

Line 342: => ota_tmt_shd.g_old_rec.attribute7

338: => ota_tmt_shd.g_old_rec.attribute5
339: ,p_attribute6_o
340: => ota_tmt_shd.g_old_rec.attribute6
341: ,p_attribute7_o
342: => ota_tmt_shd.g_old_rec.attribute7
343: ,p_attribute8_o
344: => ota_tmt_shd.g_old_rec.attribute8
345: ,p_attribute9_o
346: => ota_tmt_shd.g_old_rec.attribute9

Line 344: => ota_tmt_shd.g_old_rec.attribute8

340: => ota_tmt_shd.g_old_rec.attribute6
341: ,p_attribute7_o
342: => ota_tmt_shd.g_old_rec.attribute7
343: ,p_attribute8_o
344: => ota_tmt_shd.g_old_rec.attribute8
345: ,p_attribute9_o
346: => ota_tmt_shd.g_old_rec.attribute9
347: ,p_attribute10_o
348: => ota_tmt_shd.g_old_rec.attribute10

Line 346: => ota_tmt_shd.g_old_rec.attribute9

342: => ota_tmt_shd.g_old_rec.attribute7
343: ,p_attribute8_o
344: => ota_tmt_shd.g_old_rec.attribute8
345: ,p_attribute9_o
346: => ota_tmt_shd.g_old_rec.attribute9
347: ,p_attribute10_o
348: => ota_tmt_shd.g_old_rec.attribute10
349: ,p_attribute11_o
350: => ota_tmt_shd.g_old_rec.attribute11

Line 348: => ota_tmt_shd.g_old_rec.attribute10

344: => ota_tmt_shd.g_old_rec.attribute8
345: ,p_attribute9_o
346: => ota_tmt_shd.g_old_rec.attribute9
347: ,p_attribute10_o
348: => ota_tmt_shd.g_old_rec.attribute10
349: ,p_attribute11_o
350: => ota_tmt_shd.g_old_rec.attribute11
351: ,p_attribute12_o
352: => ota_tmt_shd.g_old_rec.attribute12

Line 350: => ota_tmt_shd.g_old_rec.attribute11

346: => ota_tmt_shd.g_old_rec.attribute9
347: ,p_attribute10_o
348: => ota_tmt_shd.g_old_rec.attribute10
349: ,p_attribute11_o
350: => ota_tmt_shd.g_old_rec.attribute11
351: ,p_attribute12_o
352: => ota_tmt_shd.g_old_rec.attribute12
353: ,p_attribute13_o
354: => ota_tmt_shd.g_old_rec.attribute13

Line 352: => ota_tmt_shd.g_old_rec.attribute12

348: => ota_tmt_shd.g_old_rec.attribute10
349: ,p_attribute11_o
350: => ota_tmt_shd.g_old_rec.attribute11
351: ,p_attribute12_o
352: => ota_tmt_shd.g_old_rec.attribute12
353: ,p_attribute13_o
354: => ota_tmt_shd.g_old_rec.attribute13
355: ,p_attribute14_o
356: => ota_tmt_shd.g_old_rec.attribute14

Line 354: => ota_tmt_shd.g_old_rec.attribute13

350: => ota_tmt_shd.g_old_rec.attribute11
351: ,p_attribute12_o
352: => ota_tmt_shd.g_old_rec.attribute12
353: ,p_attribute13_o
354: => ota_tmt_shd.g_old_rec.attribute13
355: ,p_attribute14_o
356: => ota_tmt_shd.g_old_rec.attribute14
357: ,p_attribute15_o
358: => ota_tmt_shd.g_old_rec.attribute15

Line 356: => ota_tmt_shd.g_old_rec.attribute14

352: => ota_tmt_shd.g_old_rec.attribute12
353: ,p_attribute13_o
354: => ota_tmt_shd.g_old_rec.attribute13
355: ,p_attribute14_o
356: => ota_tmt_shd.g_old_rec.attribute14
357: ,p_attribute15_o
358: => ota_tmt_shd.g_old_rec.attribute15
359: ,p_attribute16_o
360: => ota_tmt_shd.g_old_rec.attribute16

Line 358: => ota_tmt_shd.g_old_rec.attribute15

354: => ota_tmt_shd.g_old_rec.attribute13
355: ,p_attribute14_o
356: => ota_tmt_shd.g_old_rec.attribute14
357: ,p_attribute15_o
358: => ota_tmt_shd.g_old_rec.attribute15
359: ,p_attribute16_o
360: => ota_tmt_shd.g_old_rec.attribute16
361: ,p_attribute17_o
362: => ota_tmt_shd.g_old_rec.attribute17

Line 360: => ota_tmt_shd.g_old_rec.attribute16

356: => ota_tmt_shd.g_old_rec.attribute14
357: ,p_attribute15_o
358: => ota_tmt_shd.g_old_rec.attribute15
359: ,p_attribute16_o
360: => ota_tmt_shd.g_old_rec.attribute16
361: ,p_attribute17_o
362: => ota_tmt_shd.g_old_rec.attribute17
363: ,p_attribute18_o
364: => ota_tmt_shd.g_old_rec.attribute18

Line 362: => ota_tmt_shd.g_old_rec.attribute17

358: => ota_tmt_shd.g_old_rec.attribute15
359: ,p_attribute16_o
360: => ota_tmt_shd.g_old_rec.attribute16
361: ,p_attribute17_o
362: => ota_tmt_shd.g_old_rec.attribute17
363: ,p_attribute18_o
364: => ota_tmt_shd.g_old_rec.attribute18
365: ,p_attribute19_o
366: => ota_tmt_shd.g_old_rec.attribute19

Line 364: => ota_tmt_shd.g_old_rec.attribute18

360: => ota_tmt_shd.g_old_rec.attribute16
361: ,p_attribute17_o
362: => ota_tmt_shd.g_old_rec.attribute17
363: ,p_attribute18_o
364: => ota_tmt_shd.g_old_rec.attribute18
365: ,p_attribute19_o
366: => ota_tmt_shd.g_old_rec.attribute19
367: ,p_attribute20_o
368: => ota_tmt_shd.g_old_rec.attribute20

Line 366: => ota_tmt_shd.g_old_rec.attribute19

362: => ota_tmt_shd.g_old_rec.attribute17
363: ,p_attribute18_o
364: => ota_tmt_shd.g_old_rec.attribute18
365: ,p_attribute19_o
366: => ota_tmt_shd.g_old_rec.attribute19
367: ,p_attribute20_o
368: => ota_tmt_shd.g_old_rec.attribute20
369: ,p_attribute21_o
370: => ota_tmt_shd.g_old_rec.attribute21

Line 368: => ota_tmt_shd.g_old_rec.attribute20

364: => ota_tmt_shd.g_old_rec.attribute18
365: ,p_attribute19_o
366: => ota_tmt_shd.g_old_rec.attribute19
367: ,p_attribute20_o
368: => ota_tmt_shd.g_old_rec.attribute20
369: ,p_attribute21_o
370: => ota_tmt_shd.g_old_rec.attribute21
371: ,p_attribute22_o
372: => ota_tmt_shd.g_old_rec.attribute22

Line 370: => ota_tmt_shd.g_old_rec.attribute21

366: => ota_tmt_shd.g_old_rec.attribute19
367: ,p_attribute20_o
368: => ota_tmt_shd.g_old_rec.attribute20
369: ,p_attribute21_o
370: => ota_tmt_shd.g_old_rec.attribute21
371: ,p_attribute22_o
372: => ota_tmt_shd.g_old_rec.attribute22
373: ,p_attribute23_o
374: => ota_tmt_shd.g_old_rec.attribute23

Line 372: => ota_tmt_shd.g_old_rec.attribute22

368: => ota_tmt_shd.g_old_rec.attribute20
369: ,p_attribute21_o
370: => ota_tmt_shd.g_old_rec.attribute21
371: ,p_attribute22_o
372: => ota_tmt_shd.g_old_rec.attribute22
373: ,p_attribute23_o
374: => ota_tmt_shd.g_old_rec.attribute23
375: ,p_attribute24_o
376: => ota_tmt_shd.g_old_rec.attribute24

Line 374: => ota_tmt_shd.g_old_rec.attribute23

370: => ota_tmt_shd.g_old_rec.attribute21
371: ,p_attribute22_o
372: => ota_tmt_shd.g_old_rec.attribute22
373: ,p_attribute23_o
374: => ota_tmt_shd.g_old_rec.attribute23
375: ,p_attribute24_o
376: => ota_tmt_shd.g_old_rec.attribute24
377: ,p_attribute25_o
378: => ota_tmt_shd.g_old_rec.attribute25

Line 376: => ota_tmt_shd.g_old_rec.attribute24

372: => ota_tmt_shd.g_old_rec.attribute22
373: ,p_attribute23_o
374: => ota_tmt_shd.g_old_rec.attribute23
375: ,p_attribute24_o
376: => ota_tmt_shd.g_old_rec.attribute24
377: ,p_attribute25_o
378: => ota_tmt_shd.g_old_rec.attribute25
379: ,p_attribute26_o
380: => ota_tmt_shd.g_old_rec.attribute26

Line 378: => ota_tmt_shd.g_old_rec.attribute25

374: => ota_tmt_shd.g_old_rec.attribute23
375: ,p_attribute24_o
376: => ota_tmt_shd.g_old_rec.attribute24
377: ,p_attribute25_o
378: => ota_tmt_shd.g_old_rec.attribute25
379: ,p_attribute26_o
380: => ota_tmt_shd.g_old_rec.attribute26
381: ,p_attribute27_o
382: => ota_tmt_shd.g_old_rec.attribute27

Line 380: => ota_tmt_shd.g_old_rec.attribute26

376: => ota_tmt_shd.g_old_rec.attribute24
377: ,p_attribute25_o
378: => ota_tmt_shd.g_old_rec.attribute25
379: ,p_attribute26_o
380: => ota_tmt_shd.g_old_rec.attribute26
381: ,p_attribute27_o
382: => ota_tmt_shd.g_old_rec.attribute27
383: ,p_attribute28_o
384: => ota_tmt_shd.g_old_rec.attribute28

Line 382: => ota_tmt_shd.g_old_rec.attribute27

378: => ota_tmt_shd.g_old_rec.attribute25
379: ,p_attribute26_o
380: => ota_tmt_shd.g_old_rec.attribute26
381: ,p_attribute27_o
382: => ota_tmt_shd.g_old_rec.attribute27
383: ,p_attribute28_o
384: => ota_tmt_shd.g_old_rec.attribute28
385: ,p_attribute29_o
386: => ota_tmt_shd.g_old_rec.attribute29

Line 384: => ota_tmt_shd.g_old_rec.attribute28

380: => ota_tmt_shd.g_old_rec.attribute26
381: ,p_attribute27_o
382: => ota_tmt_shd.g_old_rec.attribute27
383: ,p_attribute28_o
384: => ota_tmt_shd.g_old_rec.attribute28
385: ,p_attribute29_o
386: => ota_tmt_shd.g_old_rec.attribute29
387: ,p_attribute30_o
388: => ota_tmt_shd.g_old_rec.attribute30

Line 386: => ota_tmt_shd.g_old_rec.attribute29

382: => ota_tmt_shd.g_old_rec.attribute27
383: ,p_attribute28_o
384: => ota_tmt_shd.g_old_rec.attribute28
385: ,p_attribute29_o
386: => ota_tmt_shd.g_old_rec.attribute29
387: ,p_attribute30_o
388: => ota_tmt_shd.g_old_rec.attribute30
389: );
390: --

Line 388: => ota_tmt_shd.g_old_rec.attribute30

384: => ota_tmt_shd.g_old_rec.attribute28
385: ,p_attribute29_o
386: => ota_tmt_shd.g_old_rec.attribute29
387: ,p_attribute30_o
388: => ota_tmt_shd.g_old_rec.attribute30
389: );
390: --
391: exception
392: --

Line 448: (p_rec in out nocopy ota_tmt_shd.g_rec_type

444: --
445: -- {End Of Comments}
446: -- ----------------------------------------------------------------------------
447: Procedure convert_defs
448: (p_rec in out nocopy ota_tmt_shd.g_rec_type
449: ) is
450: --
451: Begin
452: --

Line 460: ota_tmt_shd.g_old_rec.tp_measurement_code;

456: -- is being used then we must set to the 'current' argument value.
457: --
458: If (p_rec.tp_measurement_code = hr_api.g_varchar2) then
459: p_rec.tp_measurement_code :=
460: ota_tmt_shd.g_old_rec.tp_measurement_code;
461: End If;
462: If (p_rec.unit = hr_api.g_varchar2) then
463: p_rec.unit :=
464: ota_tmt_shd.g_old_rec.unit;

Line 464: ota_tmt_shd.g_old_rec.unit;

460: ota_tmt_shd.g_old_rec.tp_measurement_code;
461: End If;
462: If (p_rec.unit = hr_api.g_varchar2) then
463: p_rec.unit :=
464: ota_tmt_shd.g_old_rec.unit;
465: End If;
466: If (p_rec.reporting_sequence = hr_api.g_number) then
467: p_rec.reporting_sequence :=
468: ota_tmt_shd.g_old_rec.reporting_sequence;

Line 468: ota_tmt_shd.g_old_rec.reporting_sequence;

464: ota_tmt_shd.g_old_rec.unit;
465: End If;
466: If (p_rec.reporting_sequence = hr_api.g_number) then
467: p_rec.reporting_sequence :=
468: ota_tmt_shd.g_old_rec.reporting_sequence;
469: End If;
470: If (p_rec.budget_level = hr_api.g_varchar2) then
471: p_rec.budget_level :=
472: ota_tmt_shd.g_old_rec.budget_level;

Line 472: ota_tmt_shd.g_old_rec.budget_level;

468: ota_tmt_shd.g_old_rec.reporting_sequence;
469: End If;
470: If (p_rec.budget_level = hr_api.g_varchar2) then
471: p_rec.budget_level :=
472: ota_tmt_shd.g_old_rec.budget_level;
473: End If;
474: If (p_rec.cost_level = hr_api.g_varchar2) then
475: p_rec.cost_level :=
476: ota_tmt_shd.g_old_rec.cost_level;

Line 476: ota_tmt_shd.g_old_rec.cost_level;

472: ota_tmt_shd.g_old_rec.budget_level;
473: End If;
474: If (p_rec.cost_level = hr_api.g_varchar2) then
475: p_rec.cost_level :=
476: ota_tmt_shd.g_old_rec.cost_level;
477: End If;
478: If (p_rec.many_budget_values_flag = hr_api.g_varchar2) then
479: p_rec.many_budget_values_flag :=
480: ota_tmt_shd.g_old_rec.many_budget_values_flag;

Line 480: ota_tmt_shd.g_old_rec.many_budget_values_flag;

476: ota_tmt_shd.g_old_rec.cost_level;
477: End If;
478: If (p_rec.many_budget_values_flag = hr_api.g_varchar2) then
479: p_rec.many_budget_values_flag :=
480: ota_tmt_shd.g_old_rec.many_budget_values_flag;
481: End If;
482: If (p_rec.item_type_usage_id = hr_api.g_number) then
483: p_rec.item_type_usage_id :=
484: ota_tmt_shd.g_old_rec.item_type_usage_id;

Line 484: ota_tmt_shd.g_old_rec.item_type_usage_id;

480: ota_tmt_shd.g_old_rec.many_budget_values_flag;
481: End If;
482: If (p_rec.item_type_usage_id = hr_api.g_number) then
483: p_rec.item_type_usage_id :=
484: ota_tmt_shd.g_old_rec.item_type_usage_id;
485: End If;
486: If (p_rec.business_group_id = hr_api.g_number) then
487: p_rec.business_group_id :=
488: ota_tmt_shd.g_old_rec.business_group_id;

Line 488: ota_tmt_shd.g_old_rec.business_group_id;

484: ota_tmt_shd.g_old_rec.item_type_usage_id;
485: End If;
486: If (p_rec.business_group_id = hr_api.g_number) then
487: p_rec.business_group_id :=
488: ota_tmt_shd.g_old_rec.business_group_id;
489: End If;
490: If (p_rec.attribute_category = hr_api.g_varchar2) then
491: p_rec.attribute_category :=
492: ota_tmt_shd.g_old_rec.attribute_category;

Line 492: ota_tmt_shd.g_old_rec.attribute_category;

488: ota_tmt_shd.g_old_rec.business_group_id;
489: End If;
490: If (p_rec.attribute_category = hr_api.g_varchar2) then
491: p_rec.attribute_category :=
492: ota_tmt_shd.g_old_rec.attribute_category;
493: End If;
494: If (p_rec.attribute1 = hr_api.g_varchar2) then
495: p_rec.attribute1 :=
496: ota_tmt_shd.g_old_rec.attribute1;

Line 496: ota_tmt_shd.g_old_rec.attribute1;

492: ota_tmt_shd.g_old_rec.attribute_category;
493: End If;
494: If (p_rec.attribute1 = hr_api.g_varchar2) then
495: p_rec.attribute1 :=
496: ota_tmt_shd.g_old_rec.attribute1;
497: End If;
498: If (p_rec.attribute2 = hr_api.g_varchar2) then
499: p_rec.attribute2 :=
500: ota_tmt_shd.g_old_rec.attribute2;

Line 500: ota_tmt_shd.g_old_rec.attribute2;

496: ota_tmt_shd.g_old_rec.attribute1;
497: End If;
498: If (p_rec.attribute2 = hr_api.g_varchar2) then
499: p_rec.attribute2 :=
500: ota_tmt_shd.g_old_rec.attribute2;
501: End If;
502: If (p_rec.attribute3 = hr_api.g_varchar2) then
503: p_rec.attribute3 :=
504: ota_tmt_shd.g_old_rec.attribute3;

Line 504: ota_tmt_shd.g_old_rec.attribute3;

500: ota_tmt_shd.g_old_rec.attribute2;
501: End If;
502: If (p_rec.attribute3 = hr_api.g_varchar2) then
503: p_rec.attribute3 :=
504: ota_tmt_shd.g_old_rec.attribute3;
505: End If;
506: If (p_rec.attribute4 = hr_api.g_varchar2) then
507: p_rec.attribute4 :=
508: ota_tmt_shd.g_old_rec.attribute4;

Line 508: ota_tmt_shd.g_old_rec.attribute4;

504: ota_tmt_shd.g_old_rec.attribute3;
505: End If;
506: If (p_rec.attribute4 = hr_api.g_varchar2) then
507: p_rec.attribute4 :=
508: ota_tmt_shd.g_old_rec.attribute4;
509: End If;
510: If (p_rec.attribute5 = hr_api.g_varchar2) then
511: p_rec.attribute5 :=
512: ota_tmt_shd.g_old_rec.attribute5;

Line 512: ota_tmt_shd.g_old_rec.attribute5;

508: ota_tmt_shd.g_old_rec.attribute4;
509: End If;
510: If (p_rec.attribute5 = hr_api.g_varchar2) then
511: p_rec.attribute5 :=
512: ota_tmt_shd.g_old_rec.attribute5;
513: End If;
514: If (p_rec.attribute6 = hr_api.g_varchar2) then
515: p_rec.attribute6 :=
516: ota_tmt_shd.g_old_rec.attribute6;

Line 516: ota_tmt_shd.g_old_rec.attribute6;

512: ota_tmt_shd.g_old_rec.attribute5;
513: End If;
514: If (p_rec.attribute6 = hr_api.g_varchar2) then
515: p_rec.attribute6 :=
516: ota_tmt_shd.g_old_rec.attribute6;
517: End If;
518: If (p_rec.attribute7 = hr_api.g_varchar2) then
519: p_rec.attribute7 :=
520: ota_tmt_shd.g_old_rec.attribute7;

Line 520: ota_tmt_shd.g_old_rec.attribute7;

516: ota_tmt_shd.g_old_rec.attribute6;
517: End If;
518: If (p_rec.attribute7 = hr_api.g_varchar2) then
519: p_rec.attribute7 :=
520: ota_tmt_shd.g_old_rec.attribute7;
521: End If;
522: If (p_rec.attribute8 = hr_api.g_varchar2) then
523: p_rec.attribute8 :=
524: ota_tmt_shd.g_old_rec.attribute8;

Line 524: ota_tmt_shd.g_old_rec.attribute8;

520: ota_tmt_shd.g_old_rec.attribute7;
521: End If;
522: If (p_rec.attribute8 = hr_api.g_varchar2) then
523: p_rec.attribute8 :=
524: ota_tmt_shd.g_old_rec.attribute8;
525: End If;
526: If (p_rec.attribute9 = hr_api.g_varchar2) then
527: p_rec.attribute9 :=
528: ota_tmt_shd.g_old_rec.attribute9;

Line 528: ota_tmt_shd.g_old_rec.attribute9;

524: ota_tmt_shd.g_old_rec.attribute8;
525: End If;
526: If (p_rec.attribute9 = hr_api.g_varchar2) then
527: p_rec.attribute9 :=
528: ota_tmt_shd.g_old_rec.attribute9;
529: End If;
530: If (p_rec.attribute10 = hr_api.g_varchar2) then
531: p_rec.attribute10 :=
532: ota_tmt_shd.g_old_rec.attribute10;

Line 532: ota_tmt_shd.g_old_rec.attribute10;

528: ota_tmt_shd.g_old_rec.attribute9;
529: End If;
530: If (p_rec.attribute10 = hr_api.g_varchar2) then
531: p_rec.attribute10 :=
532: ota_tmt_shd.g_old_rec.attribute10;
533: End If;
534: If (p_rec.attribute11 = hr_api.g_varchar2) then
535: p_rec.attribute11 :=
536: ota_tmt_shd.g_old_rec.attribute11;

Line 536: ota_tmt_shd.g_old_rec.attribute11;

532: ota_tmt_shd.g_old_rec.attribute10;
533: End If;
534: If (p_rec.attribute11 = hr_api.g_varchar2) then
535: p_rec.attribute11 :=
536: ota_tmt_shd.g_old_rec.attribute11;
537: End If;
538: If (p_rec.attribute12 = hr_api.g_varchar2) then
539: p_rec.attribute12 :=
540: ota_tmt_shd.g_old_rec.attribute12;

Line 540: ota_tmt_shd.g_old_rec.attribute12;

536: ota_tmt_shd.g_old_rec.attribute11;
537: End If;
538: If (p_rec.attribute12 = hr_api.g_varchar2) then
539: p_rec.attribute12 :=
540: ota_tmt_shd.g_old_rec.attribute12;
541: End If;
542: If (p_rec.attribute13 = hr_api.g_varchar2) then
543: p_rec.attribute13 :=
544: ota_tmt_shd.g_old_rec.attribute13;

Line 544: ota_tmt_shd.g_old_rec.attribute13;

540: ota_tmt_shd.g_old_rec.attribute12;
541: End If;
542: If (p_rec.attribute13 = hr_api.g_varchar2) then
543: p_rec.attribute13 :=
544: ota_tmt_shd.g_old_rec.attribute13;
545: End If;
546: If (p_rec.attribute14 = hr_api.g_varchar2) then
547: p_rec.attribute14 :=
548: ota_tmt_shd.g_old_rec.attribute14;

Line 548: ota_tmt_shd.g_old_rec.attribute14;

544: ota_tmt_shd.g_old_rec.attribute13;
545: End If;
546: If (p_rec.attribute14 = hr_api.g_varchar2) then
547: p_rec.attribute14 :=
548: ota_tmt_shd.g_old_rec.attribute14;
549: End If;
550: If (p_rec.attribute15 = hr_api.g_varchar2) then
551: p_rec.attribute15 :=
552: ota_tmt_shd.g_old_rec.attribute15;

Line 552: ota_tmt_shd.g_old_rec.attribute15;

548: ota_tmt_shd.g_old_rec.attribute14;
549: End If;
550: If (p_rec.attribute15 = hr_api.g_varchar2) then
551: p_rec.attribute15 :=
552: ota_tmt_shd.g_old_rec.attribute15;
553: End If;
554: If (p_rec.attribute16 = hr_api.g_varchar2) then
555: p_rec.attribute16 :=
556: ota_tmt_shd.g_old_rec.attribute16;

Line 556: ota_tmt_shd.g_old_rec.attribute16;

552: ota_tmt_shd.g_old_rec.attribute15;
553: End If;
554: If (p_rec.attribute16 = hr_api.g_varchar2) then
555: p_rec.attribute16 :=
556: ota_tmt_shd.g_old_rec.attribute16;
557: End If;
558: If (p_rec.attribute17 = hr_api.g_varchar2) then
559: p_rec.attribute17 :=
560: ota_tmt_shd.g_old_rec.attribute17;

Line 560: ota_tmt_shd.g_old_rec.attribute17;

556: ota_tmt_shd.g_old_rec.attribute16;
557: End If;
558: If (p_rec.attribute17 = hr_api.g_varchar2) then
559: p_rec.attribute17 :=
560: ota_tmt_shd.g_old_rec.attribute17;
561: End If;
562: If (p_rec.attribute18 = hr_api.g_varchar2) then
563: p_rec.attribute18 :=
564: ota_tmt_shd.g_old_rec.attribute18;

Line 564: ota_tmt_shd.g_old_rec.attribute18;

560: ota_tmt_shd.g_old_rec.attribute17;
561: End If;
562: If (p_rec.attribute18 = hr_api.g_varchar2) then
563: p_rec.attribute18 :=
564: ota_tmt_shd.g_old_rec.attribute18;
565: End If;
566: If (p_rec.attribute19 = hr_api.g_varchar2) then
567: p_rec.attribute19 :=
568: ota_tmt_shd.g_old_rec.attribute19;

Line 568: ota_tmt_shd.g_old_rec.attribute19;

564: ota_tmt_shd.g_old_rec.attribute18;
565: End If;
566: If (p_rec.attribute19 = hr_api.g_varchar2) then
567: p_rec.attribute19 :=
568: ota_tmt_shd.g_old_rec.attribute19;
569: End If;
570: If (p_rec.attribute20 = hr_api.g_varchar2) then
571: p_rec.attribute20 :=
572: ota_tmt_shd.g_old_rec.attribute20;

Line 572: ota_tmt_shd.g_old_rec.attribute20;

568: ota_tmt_shd.g_old_rec.attribute19;
569: End If;
570: If (p_rec.attribute20 = hr_api.g_varchar2) then
571: p_rec.attribute20 :=
572: ota_tmt_shd.g_old_rec.attribute20;
573: End If;
574: If (p_rec.attribute21 = hr_api.g_varchar2) then
575: p_rec.attribute21 :=
576: ota_tmt_shd.g_old_rec.attribute21;

Line 576: ota_tmt_shd.g_old_rec.attribute21;

572: ota_tmt_shd.g_old_rec.attribute20;
573: End If;
574: If (p_rec.attribute21 = hr_api.g_varchar2) then
575: p_rec.attribute21 :=
576: ota_tmt_shd.g_old_rec.attribute21;
577: End If;
578: If (p_rec.attribute22 = hr_api.g_varchar2) then
579: p_rec.attribute22 :=
580: ota_tmt_shd.g_old_rec.attribute22;

Line 580: ota_tmt_shd.g_old_rec.attribute22;

576: ota_tmt_shd.g_old_rec.attribute21;
577: End If;
578: If (p_rec.attribute22 = hr_api.g_varchar2) then
579: p_rec.attribute22 :=
580: ota_tmt_shd.g_old_rec.attribute22;
581: End If;
582: If (p_rec.attribute23 = hr_api.g_varchar2) then
583: p_rec.attribute23 :=
584: ota_tmt_shd.g_old_rec.attribute23;

Line 584: ota_tmt_shd.g_old_rec.attribute23;

580: ota_tmt_shd.g_old_rec.attribute22;
581: End If;
582: If (p_rec.attribute23 = hr_api.g_varchar2) then
583: p_rec.attribute23 :=
584: ota_tmt_shd.g_old_rec.attribute23;
585: End If;
586: If (p_rec.attribute24 = hr_api.g_varchar2) then
587: p_rec.attribute24 :=
588: ota_tmt_shd.g_old_rec.attribute24;

Line 588: ota_tmt_shd.g_old_rec.attribute24;

584: ota_tmt_shd.g_old_rec.attribute23;
585: End If;
586: If (p_rec.attribute24 = hr_api.g_varchar2) then
587: p_rec.attribute24 :=
588: ota_tmt_shd.g_old_rec.attribute24;
589: End If;
590: If (p_rec.attribute25 = hr_api.g_varchar2) then
591: p_rec.attribute25 :=
592: ota_tmt_shd.g_old_rec.attribute25;

Line 592: ota_tmt_shd.g_old_rec.attribute25;

588: ota_tmt_shd.g_old_rec.attribute24;
589: End If;
590: If (p_rec.attribute25 = hr_api.g_varchar2) then
591: p_rec.attribute25 :=
592: ota_tmt_shd.g_old_rec.attribute25;
593: End If;
594: If (p_rec.attribute26 = hr_api.g_varchar2) then
595: p_rec.attribute26 :=
596: ota_tmt_shd.g_old_rec.attribute26;

Line 596: ota_tmt_shd.g_old_rec.attribute26;

592: ota_tmt_shd.g_old_rec.attribute25;
593: End If;
594: If (p_rec.attribute26 = hr_api.g_varchar2) then
595: p_rec.attribute26 :=
596: ota_tmt_shd.g_old_rec.attribute26;
597: End If;
598: If (p_rec.attribute27 = hr_api.g_varchar2) then
599: p_rec.attribute27 :=
600: ota_tmt_shd.g_old_rec.attribute27;

Line 600: ota_tmt_shd.g_old_rec.attribute27;

596: ota_tmt_shd.g_old_rec.attribute26;
597: End If;
598: If (p_rec.attribute27 = hr_api.g_varchar2) then
599: p_rec.attribute27 :=
600: ota_tmt_shd.g_old_rec.attribute27;
601: End If;
602: If (p_rec.attribute28 = hr_api.g_varchar2) then
603: p_rec.attribute28 :=
604: ota_tmt_shd.g_old_rec.attribute28;

Line 604: ota_tmt_shd.g_old_rec.attribute28;

600: ota_tmt_shd.g_old_rec.attribute27;
601: End If;
602: If (p_rec.attribute28 = hr_api.g_varchar2) then
603: p_rec.attribute28 :=
604: ota_tmt_shd.g_old_rec.attribute28;
605: End If;
606: If (p_rec.attribute29 = hr_api.g_varchar2) then
607: p_rec.attribute29 :=
608: ota_tmt_shd.g_old_rec.attribute29;

Line 608: ota_tmt_shd.g_old_rec.attribute29;

604: ota_tmt_shd.g_old_rec.attribute28;
605: End If;
606: If (p_rec.attribute29 = hr_api.g_varchar2) then
607: p_rec.attribute29 :=
608: ota_tmt_shd.g_old_rec.attribute29;
609: End If;
610: If (p_rec.attribute30 = hr_api.g_varchar2) then
611: p_rec.attribute30 :=
612: ota_tmt_shd.g_old_rec.attribute30;

Line 612: ota_tmt_shd.g_old_rec.attribute30;

608: ota_tmt_shd.g_old_rec.attribute29;
609: End If;
610: If (p_rec.attribute30 = hr_api.g_varchar2) then
611: p_rec.attribute30 :=
612: ota_tmt_shd.g_old_rec.attribute30;
613: End If;
614: --
615: End convert_defs;
616: --

Line 622: ,p_rec in out nocopy ota_tmt_shd.g_rec_type

618: -- |---------------------------------< upd >----------------------------------|
619: -- ----------------------------------------------------------------------------
620: Procedure upd
621: (p_effective_date in date
622: ,p_rec in out nocopy ota_tmt_shd.g_rec_type
623: ) is
624: --
625: l_proc varchar2(72) := g_package||'upd';
626: --

Line 632: ota_tmt_shd.lck

628: hr_utility.set_location('Entering:'||l_proc, 5);
629: --
630: -- We must lock the row which we need to update.
631: --
632: ota_tmt_shd.lck
633: (p_rec.tp_measurement_type_id
634: ,p_rec.object_version_number
635: );
636: --

Line 711: l_rec ota_tmt_shd.g_rec_type;

707: ,p_attribute29 in varchar2 default hr_api.g_varchar2
708: ,p_attribute30 in varchar2 default hr_api.g_varchar2
709: ) is
710: --
711: l_rec ota_tmt_shd.g_rec_type;
712: l_proc varchar2(72) := g_package||'upd';
713: --
714: Begin
715: hr_utility.set_location('Entering:'||l_proc, 5);

Line 721: ota_tmt_shd.convert_args

717: -- Call conversion function to turn arguments into the
718: -- l_rec structure.
719: --
720: l_rec :=
721: ota_tmt_shd.convert_args
722: (p_tp_measurement_type_id
723: ,hr_api.g_varchar2
724: ,p_unit
725: ,p_reporting_sequence