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.AME_ATU_INS dependencies on AME_ATU_INS

Line 1: Package Body ame_atu_ins as

1: Package Body ame_atu_ins as
2: /* $Header: amaturhi.pkb 120.6 2006/02/15 04:04 prasashe noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package varchar2(33) := ' ame_atu_ins.'; -- Global package name

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' ame_atu_ins.'; -- Global package name
9: --
10: -- The following global variables are only to be used by
11: -- the set_base_key_value and pre_insert procedures.
12: --

Line 28: ame_atu_ins.g_attribute_id_i := p_attribute_id;

24: --
25: Begin
26: hr_utility.set_location('Entering:'||l_proc, 10);
27: --
28: ame_atu_ins.g_attribute_id_i := p_attribute_id;
29: ame_atu_ins.g_application_id_i := p_application_id;
30: --
31: hr_utility.set_location(' Leaving:'||l_proc, 20);
32: End set_base_key_value;

Line 29: ame_atu_ins.g_application_id_i := p_application_id;

25: Begin
26: hr_utility.set_location('Entering:'||l_proc, 10);
27: --
28: ame_atu_ins.g_attribute_id_i := p_attribute_id;
29: ame_atu_ins.g_application_id_i := p_application_id;
30: --
31: hr_utility.set_location(' Leaving:'||l_proc, 20);
32: End set_base_key_value;
33: --

Line 266: ame_atu_ins.dt_insert_dml

262: --
263: Begin
264: hr_utility.set_location('Entering:'||l_proc, 5);
265: --
266: ame_atu_ins.dt_insert_dml
267: (p_rec => p_rec
268: ,p_effective_date => p_effective_date
269: ,p_datetrack_mode => p_datetrack_mode
270: ,p_validation_start_date => p_validation_start_date

Line 328: ame_atu_ins.g_attribute_id_i

324: Cursor C_Sel2 is
325: Select null
326: from ame_attribute_usages
327: where attribute_id =
328: ame_atu_ins.g_attribute_id_i
329: and application_id =
330: ame_atu_ins.g_application_id_i
331: and p_effective_date between start_date
332: and nvl(end_date - ame_util.oneSecond , p_effective_date);

Line 330: ame_atu_ins.g_application_id_i

326: from ame_attribute_usages
327: where attribute_id =
328: ame_atu_ins.g_attribute_id_i
329: and application_id =
330: ame_atu_ins.g_application_id_i
331: and p_effective_date between start_date
332: and nvl(end_date - ame_util.oneSecond , p_effective_date);
333: --
334: l_proc varchar2(72) := g_package||'pre_insert';

Line 340: If (ame_atu_ins.g_attribute_id_i is not null or

336: --
337: Begin
338: hr_utility.set_location('Entering:'||l_proc, 5);
339: --
340: If (ame_atu_ins.g_attribute_id_i is not null or
341: ame_atu_ins.g_application_id_i is not null) Then
342: --
343: -- Verify registered primary key values not already in use
344: --

Line 341: ame_atu_ins.g_application_id_i is not null) Then

337: Begin
338: hr_utility.set_location('Entering:'||l_proc, 5);
339: --
340: If (ame_atu_ins.g_attribute_id_i is not null or
341: ame_atu_ins.g_application_id_i is not null) Then
342: --
343: -- Verify registered primary key values not already in use
344: --
345: Open C_Sel2;

Line 361: ame_atu_ins.g_attribute_id_i;

357: --
358: -- Use registered key values and clear globals
359: --
360: p_rec.attribute_id :=
361: ame_atu_ins.g_attribute_id_i;
362: ame_atu_ins.g_attribute_id_i := null;
363: p_rec.application_id :=
364: ame_atu_ins.g_application_id_i;
365: ame_atu_ins.g_application_id_i := null;

Line 362: ame_atu_ins.g_attribute_id_i := null;

358: -- Use registered key values and clear globals
359: --
360: p_rec.attribute_id :=
361: ame_atu_ins.g_attribute_id_i;
362: ame_atu_ins.g_attribute_id_i := null;
363: p_rec.application_id :=
364: ame_atu_ins.g_application_id_i;
365: ame_atu_ins.g_application_id_i := null;
366: End If;

Line 364: ame_atu_ins.g_application_id_i;

360: p_rec.attribute_id :=
361: ame_atu_ins.g_attribute_id_i;
362: ame_atu_ins.g_attribute_id_i := null;
363: p_rec.application_id :=
364: ame_atu_ins.g_application_id_i;
365: ame_atu_ins.g_application_id_i := null;
366: End If;
367: --
368: --

Line 365: ame_atu_ins.g_application_id_i := null;

361: ame_atu_ins.g_attribute_id_i;
362: ame_atu_ins.g_attribute_id_i := null;
363: p_rec.application_id :=
364: ame_atu_ins.g_application_id_i;
365: ame_atu_ins.g_application_id_i := null;
366: End If;
367: --
368: --
369: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 564: ame_atu_ins.ins_lck

560: --
561: -- Call the lock operation
562: --
563: hr_utility.set_location('Entering:'||l_proc, 15);
564: ame_atu_ins.ins_lck
565: (p_effective_date => p_effective_date
566: ,p_datetrack_mode => l_datetrack_mode
567: ,p_rec => p_rec
568: ,p_validation_start_date => l_validation_start_date

Line 589: ame_atu_ins.pre_insert

585: --
586: -- Call the supporting pre-insert operation
587: --
588: hr_utility.set_location('Entering:'||l_proc, 35);
589: ame_atu_ins.pre_insert
590: (p_rec => p_rec
591: ,p_effective_date => p_effective_date
592: ,p_datetrack_mode => l_datetrack_mode
593: ,p_validation_start_date => l_validation_start_date

Line 600: ame_atu_ins.insert_dml

596: --
597: -- Insert the row
598: --
599: hr_utility.set_location('Entering:'||l_proc, 45);
600: ame_atu_ins.insert_dml
601: (p_rec => p_rec
602: ,p_effective_date => p_effective_date
603: ,p_datetrack_mode => l_datetrack_mode
604: ,p_validation_start_date => l_validation_start_date

Line 611: ame_atu_ins.post_insert

607: --
608: -- Call the supporting post-insert operation
609: --
610: hr_utility.set_location('Entering:'||l_proc, 55);
611: ame_atu_ins.post_insert
612: (p_rec => p_rec
613: ,p_effective_date => p_effective_date
614: ,p_datetrack_mode => l_datetrack_mode
615: ,p_validation_start_date => l_validation_start_date

Line 671: ame_atu_ins.ins

667: -- Having converted the arguments into the ame_atu_rec
668: -- plsql record structure we call the corresponding record
669: -- business process.
670: --
671: ame_atu_ins.ins
672: (p_effective_date
673: ,l_rec
674: );
675: --

Line 686: end ame_atu_ins;

682: --
683: hr_utility.set_location(' Leaving:'||l_proc, 10);
684: End ins;
685: --
686: end ame_atu_ins;