APPS.AME_ACF_INS dependencies on AME_ACF_INS

Line 1: Package Body ame_acf_ins as

1: Package Body ame_acf_ins as
2: /* $Header: amacfrhi.pkb 120.5 2006/12/23 12:19:44 avarri noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' ame_acf_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_acf_ins.g_application_id_i := p_application_id;

24: --
25: Begin
26: hr_utility.set_location('Entering:'||l_proc, 10);
27: --
28: ame_acf_ins.g_application_id_i := p_application_id;
29: ame_acf_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_acf_ins.g_action_type_id_i := p_action_type_id;

25: Begin
26: hr_utility.set_location('Entering:'||l_proc, 10);
27: --
28: ame_acf_ins.g_application_id_i := p_application_id;
29: ame_acf_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 259: ame_acf_ins.dt_insert_dml

255: --
256: Begin
257: hr_utility.set_location('Entering:'||l_proc, 5);
258: --
259: ame_acf_ins.dt_insert_dml
260: (p_rec => p_rec
261: ,p_effective_date => p_effective_date
262: ,p_datetrack_mode => p_datetrack_mode
263: ,p_validation_start_date => p_validation_start_date

Line 418: ame_acf_ins.g_application_id_i

414: Cursor C_Sel2 is
415: Select null
416: from ame_action_type_config
417: where application_id =
418: ame_acf_ins.g_application_id_i
419: and action_type_id =
420: ame_acf_ins.g_action_type_id_i;
421: --
422: l_proc varchar2(72) := g_package||'pre_insert';

Line 420: ame_acf_ins.g_action_type_id_i;

416: from ame_action_type_config
417: where application_id =
418: ame_acf_ins.g_application_id_i
419: and action_type_id =
420: ame_acf_ins.g_action_type_id_i;
421: --
422: l_proc varchar2(72) := g_package||'pre_insert';
423: l_exists varchar2(1);
424: l_order_number number;

Line 429: If (ame_acf_ins.g_application_id_i is not null or

425: --
426: Begin
427: hr_utility.set_location('Entering:'||l_proc, 5);
428: --
429: If (ame_acf_ins.g_application_id_i is not null or
430: ame_acf_ins.g_action_type_id_i is not null) Then
431: --
432: -- Verify registered primary key values not already in use
433: --

Line 430: ame_acf_ins.g_action_type_id_i is not null) Then

426: Begin
427: hr_utility.set_location('Entering:'||l_proc, 5);
428: --
429: If (ame_acf_ins.g_application_id_i is not null or
430: ame_acf_ins.g_action_type_id_i is not null) Then
431: --
432: -- Verify registered primary key values not already in use
433: --
434: Open C_Sel2;

Line 450: ame_acf_ins.g_application_id_i;

446: --
447: -- Use registered key values and clear globals
448: --
449: p_rec.application_id :=
450: ame_acf_ins.g_application_id_i;
451: ame_acf_ins.g_application_id_i := null;
452: p_rec.action_type_id :=
453: ame_acf_ins.g_action_type_id_i;
454: ame_acf_ins.g_action_type_id_i := null;

Line 451: ame_acf_ins.g_application_id_i := null;

447: -- Use registered key values and clear globals
448: --
449: p_rec.application_id :=
450: ame_acf_ins.g_application_id_i;
451: ame_acf_ins.g_application_id_i := null;
452: p_rec.action_type_id :=
453: ame_acf_ins.g_action_type_id_i;
454: ame_acf_ins.g_action_type_id_i := null;
455: END If;

Line 453: ame_acf_ins.g_action_type_id_i;

449: p_rec.application_id :=
450: ame_acf_ins.g_application_id_i;
451: ame_acf_ins.g_application_id_i := null;
452: p_rec.action_type_id :=
453: ame_acf_ins.g_action_type_id_i;
454: ame_acf_ins.g_action_type_id_i := null;
455: END If;
456: /*
457: Else

Line 454: ame_acf_ins.g_action_type_id_i := null;

450: ame_acf_ins.g_application_id_i;
451: ame_acf_ins.g_application_id_i := null;
452: p_rec.action_type_id :=
453: ame_acf_ins.g_action_type_id_i;
454: ame_acf_ins.g_action_type_id_i := null;
455: END If;
456: /*
457: Else
458: --

Line 653: ame_acf_ins.ins_lck

649: hr_utility.set_location('Entering:'||l_proc, 5);
650: --
651: -- Call the lock operation
652: --
653: ame_acf_ins.ins_lck
654: (p_effective_date => p_effective_date
655: ,p_datetrack_mode => l_datetrack_mode
656: ,p_rec => p_rec
657: ,p_validation_start_date => l_validation_start_date

Line 673: ame_acf_ins.pre_insert

669: );
670: --
671: -- Call the supporting pre-insert operation
672: --
673: ame_acf_ins.pre_insert
674: (p_rec => p_rec
675: ,p_effective_date => p_effective_date
676: ,p_datetrack_mode => l_datetrack_mode
677: ,p_validation_start_date => l_validation_start_date

Line 686: ame_acf_ins.insert_dml

682: hr_multi_message.end_validation_set;
683: --
684: -- Insert the row
685: --
686: ame_acf_ins.insert_dml
687: (p_rec => p_rec
688: ,p_effective_date => p_effective_date
689: ,p_datetrack_mode => l_datetrack_mode
690: ,p_validation_start_date => l_validation_start_date

Line 696: ame_acf_ins.post_insert

692: );
693: --
694: -- Call the supporting post-insert operation
695: --
696: ame_acf_ins.post_insert
697: (p_rec => p_rec
698: ,p_effective_date => p_effective_date
699: ,p_datetrack_mode => l_datetrack_mode
700: ,p_validation_start_date => l_validation_start_date

Line 750: ame_acf_ins.ins

746: -- Having converted the arguments into the ame_acf_rec
747: -- plsql record structure we call the corresponding record
748: -- business process.
749: --
750: ame_acf_ins.ins
751: (p_effective_date
752: ,l_rec
753: );
754: --

Line 769: end ame_acf_ins;

765: --
766: hr_utility.set_location(' Leaving:'||l_proc, 10);
767: End ins;
768: --
769: end ame_acf_ins;