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_MAN_INS dependencies on AME_MAN_INS

Line 1: Package Body ame_man_ins as

1: Package Body ame_man_ins as
2: /* $Header: ammanrhi.pkb 120.5 2005/11/22 03:18 santosin noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' ame_man_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_man_ins.g_attribute_id_i := p_attribute_id;

24: --
25: Begin
26: hr_utility.set_location('Entering:'||l_proc, 10);
27: --
28: ame_man_ins.g_attribute_id_i := p_attribute_id;
29: ame_man_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_man_ins.g_action_type_id_i := p_action_type_id;

25: Begin
26: hr_utility.set_location('Entering:'||l_proc, 10);
27: --
28: ame_man_ins.g_attribute_id_i := p_attribute_id;
29: ame_man_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 255: ame_man_ins.dt_insert_dml

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

Line 319: ame_man_ins.g_attribute_id_i

315: Cursor C_Sel2 is
316: Select null
317: from ame_mandatory_attributes
318: where attribute_id =
319: ame_man_ins.g_attribute_id_i
320: and action_type_id =
321: ame_man_ins.g_action_type_id_i;
322: --
323: l_proc varchar2(72) := g_package||'pre_insert';

Line 321: ame_man_ins.g_action_type_id_i;

317: from ame_mandatory_attributes
318: where attribute_id =
319: ame_man_ins.g_attribute_id_i
320: and action_type_id =
321: ame_man_ins.g_action_type_id_i;
322: --
323: l_proc varchar2(72) := g_package||'pre_insert';
324: l_exists varchar2(1);
325: --

Line 329: If (ame_man_ins.g_attribute_id_i is not null or

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

Line 330: ame_man_ins.g_action_type_id_i is not null) Then

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

Line 350: ame_man_ins.g_attribute_id_i;

346: --
347: -- Use registered key values and clear globals
348: --
349: p_rec.attribute_id :=
350: ame_man_ins.g_attribute_id_i;
351: ame_man_ins.g_attribute_id_i := null;
352: p_rec.action_type_id :=
353: ame_man_ins.g_action_type_id_i;
354: ame_man_ins.g_action_type_id_i := null;

Line 351: ame_man_ins.g_attribute_id_i := null;

347: -- Use registered key values and clear globals
348: --
349: p_rec.attribute_id :=
350: ame_man_ins.g_attribute_id_i;
351: ame_man_ins.g_attribute_id_i := null;
352: p_rec.action_type_id :=
353: ame_man_ins.g_action_type_id_i;
354: ame_man_ins.g_action_type_id_i := null;
355: End If;

Line 353: ame_man_ins.g_action_type_id_i;

349: p_rec.attribute_id :=
350: ame_man_ins.g_attribute_id_i;
351: ame_man_ins.g_attribute_id_i := null;
352: p_rec.action_type_id :=
353: ame_man_ins.g_action_type_id_i;
354: ame_man_ins.g_action_type_id_i := null;
355: End If;
356: --
357: -- No registerd key values, so select the next sequence number

Line 354: ame_man_ins.g_action_type_id_i := null;

350: ame_man_ins.g_attribute_id_i;
351: ame_man_ins.g_attribute_id_i := null;
352: p_rec.action_type_id :=
353: ame_man_ins.g_action_type_id_i;
354: ame_man_ins.g_action_type_id_i := null;
355: End If;
356: --
357: -- No registerd key values, so select the next sequence number
358: --

Line 550: ame_man_ins.ins_lck

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

Line 573: ame_man_ins.pre_insert

569: hr_multi_message.end_validation_set;
570: --
571: -- Call the supporting pre-insert operation
572: --
573: ame_man_ins.pre_insert
574: (p_rec => p_rec
575: ,p_effective_date => p_effective_date
576: ,p_datetrack_mode => l_datetrack_mode
577: ,p_validation_start_date => l_validation_start_date

Line 583: ame_man_ins.insert_dml

579: );
580: --
581: -- Insert the row
582: --
583: ame_man_ins.insert_dml
584: (p_rec => p_rec
585: ,p_effective_date => p_effective_date
586: ,p_datetrack_mode => l_datetrack_mode
587: ,p_validation_start_date => l_validation_start_date

Line 593: ame_man_ins.post_insert

589: );
590: --
591: -- Call the supporting post-insert operation
592: --
593: ame_man_ins.post_insert
594: (p_rec => p_rec
595: ,p_effective_date => p_effective_date
596: ,p_datetrack_mode => l_datetrack_mode
597: ,p_validation_start_date => l_validation_start_date

Line 643: ame_man_ins.ins

639: -- Having converted the arguments into the ame_man_rec
640: -- plsql record structure we call the corresponding record
641: -- business process.
642: --
643: ame_man_ins.ins
644: (p_effective_date
645: ,l_rec
646: );
647: --

Line 658: end ame_man_ins;

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