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_APU_INS dependencies on AME_APU_INS

Line 1: Package Body ame_apu_ins as

1: Package Body ame_apu_ins as
2: /* $Header: amapurhi.pkb 120.3 2005/11/22 03:13 santosin noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' ame_apu_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_apu_ins.g_approver_type_id_i := p_approver_type_id;

24: --
25: Begin
26: hr_utility.set_location('Entering:'||l_proc, 10);
27: --
28: ame_apu_ins.g_approver_type_id_i := p_approver_type_id;
29: ame_apu_ins.g_action_type_id_i := p_action_type_id;
30: --
31: hr_utility.set_location(' Leaving:'||l_proc, 20);
32: End set_base_key_value;

Line 29: ame_apu_ins.g_action_type_id_i := p_action_type_id;

25: Begin
26: hr_utility.set_location('Entering:'||l_proc, 10);
27: --
28: ame_apu_ins.g_approver_type_id_i := p_approver_type_id;
29: ame_apu_ins.g_action_type_id_i := p_action_type_id;
30: --
31: hr_utility.set_location(' Leaving:'||l_proc, 20);
32: End set_base_key_value;
33: --

Line 253: ame_apu_ins.dt_insert_dml

249: --
250: Begin
251: hr_utility.set_location('Entering:'||l_proc, 5);
252: --
253: ame_apu_ins.dt_insert_dml
254: (p_rec => p_rec
255: ,p_effective_date => p_effective_date
256: ,p_datetrack_mode => p_datetrack_mode
257: ,p_validation_start_date => p_validation_start_date

Line 317: ame_apu_ins.g_approver_type_id_i

313: Cursor C_Sel2 is
314: Select null
315: from ame_approver_type_usages
316: where approver_type_id =
317: ame_apu_ins.g_approver_type_id_i
318: and action_type_id =
319: ame_apu_ins.g_action_type_id_i;
320: --
321: l_proc varchar2(72) := g_package||'pre_insert';

Line 319: ame_apu_ins.g_action_type_id_i;

315: from ame_approver_type_usages
316: where approver_type_id =
317: ame_apu_ins.g_approver_type_id_i
318: and action_type_id =
319: ame_apu_ins.g_action_type_id_i;
320: --
321: l_proc varchar2(72) := g_package||'pre_insert';
322: l_exists varchar2(1);
323: --

Line 327: If (ame_apu_ins.g_approver_type_id_i is not null or

323: --
324: Begin
325: hr_utility.set_location('Entering:'||l_proc, 5);
326: --
327: If (ame_apu_ins.g_approver_type_id_i is not null or
328: ame_apu_ins.g_action_type_id_i is not null) Then
329: --
330: -- Verify registered primary key values not already in use
331: --

Line 328: ame_apu_ins.g_action_type_id_i is not null) Then

324: Begin
325: hr_utility.set_location('Entering:'||l_proc, 5);
326: --
327: If (ame_apu_ins.g_approver_type_id_i is not null or
328: ame_apu_ins.g_action_type_id_i is not null) Then
329: --
330: -- Verify registered primary key values not already in use
331: --
332: Open C_Sel2;

Line 348: ame_apu_ins.g_approver_type_id_i;

344: --
345: -- Use registered key values and clear globals
346: --
347: p_rec.approver_type_id :=
348: ame_apu_ins.g_approver_type_id_i;
349: ame_apu_ins.g_approver_type_id_i := null;
350: p_rec.action_type_id :=
351: ame_apu_ins.g_action_type_id_i;
352: ame_apu_ins.g_action_type_id_i := null;

Line 349: ame_apu_ins.g_approver_type_id_i := null;

345: -- Use registered key values and clear globals
346: --
347: p_rec.approver_type_id :=
348: ame_apu_ins.g_approver_type_id_i;
349: ame_apu_ins.g_approver_type_id_i := null;
350: p_rec.action_type_id :=
351: ame_apu_ins.g_action_type_id_i;
352: ame_apu_ins.g_action_type_id_i := null;
353: End if;

Line 351: ame_apu_ins.g_action_type_id_i;

347: p_rec.approver_type_id :=
348: ame_apu_ins.g_approver_type_id_i;
349: ame_apu_ins.g_approver_type_id_i := null;
350: p_rec.action_type_id :=
351: ame_apu_ins.g_action_type_id_i;
352: ame_apu_ins.g_action_type_id_i := null;
353: End if;
354: /*
355: Else

Line 352: ame_apu_ins.g_action_type_id_i := null;

348: ame_apu_ins.g_approver_type_id_i;
349: ame_apu_ins.g_approver_type_id_i := null;
350: p_rec.action_type_id :=
351: ame_apu_ins.g_action_type_id_i;
352: ame_apu_ins.g_action_type_id_i := null;
353: End if;
354: /*
355: Else
356: --

Line 547: ame_apu_ins.ins_lck

543: hr_utility.set_location('Entering:'||l_proc, 5);
544: --
545: -- Call the lock operation
546: --
547: ame_apu_ins.ins_lck
548: (p_effective_date => p_effective_date
549: ,p_datetrack_mode => l_datetrack_mode
550: ,p_rec => p_rec
551: ,p_validation_start_date => l_validation_start_date

Line 570: ame_apu_ins.pre_insert

566: hr_multi_message.end_validation_set;
567: --
568: -- Call the supporting pre-insert operation
569: --
570: ame_apu_ins.pre_insert
571: (p_rec => p_rec
572: ,p_effective_date => p_effective_date
573: ,p_datetrack_mode => l_datetrack_mode
574: ,p_validation_start_date => l_validation_start_date

Line 580: ame_apu_ins.insert_dml

576: );
577: --
578: -- Insert the row
579: --
580: ame_apu_ins.insert_dml
581: (p_rec => p_rec
582: ,p_effective_date => p_effective_date
583: ,p_datetrack_mode => l_datetrack_mode
584: ,p_validation_start_date => l_validation_start_date

Line 590: ame_apu_ins.post_insert

586: );
587: --
588: -- Call the supporting post-insert operation
589: --
590: ame_apu_ins.post_insert
591: (p_rec => p_rec
592: ,p_effective_date => p_effective_date
593: ,p_datetrack_mode => l_datetrack_mode
594: ,p_validation_start_date => l_validation_start_date

Line 638: ame_apu_ins.ins

634: -- Having converted the arguments into the ame_apu_rec
635: -- plsql record structure we call the corresponding record
636: -- business process.
637: --
638: ame_apu_ins.ins
639: (p_effective_date
640: ,l_rec
641: );
642: --

Line 657: end ame_apu_ins;

653: --
654: hr_utility.set_location(' Leaving:'||l_proc, 10);
655: End ins;
656: --
657: end ame_apu_ins;