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_GCF_INS dependencies on AME_GCF_INS

Line 1: Package Body ame_gcf_ins as

1: Package Body ame_gcf_ins as
2: /* $Header: amgcfrhi.pkb 120.5 2006/10/05 16:08:09 pvelugul noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

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

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

Line 29: ame_gcf_ins.g_approval_group_id_i := p_approval_group_id;

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

Line 258: ame_gcf_ins.dt_insert_dml

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

Line 386: ame_gcf_ins.g_application_id_i

382: Cursor C_Sel2 is
383: Select null
384: from ame_approval_group_config
385: where application_id =
386: ame_gcf_ins.g_application_id_i
387: and approval_group_id =
388: ame_gcf_ins.g_approval_group_id_i
389: and p_effective_date between start_date
390: and nvl(end_date - ame_util.oneSecond , p_effective_date);

Line 388: ame_gcf_ins.g_approval_group_id_i

384: from ame_approval_group_config
385: where application_id =
386: ame_gcf_ins.g_application_id_i
387: and approval_group_id =
388: ame_gcf_ins.g_approval_group_id_i
389: and p_effective_date between start_date
390: and nvl(end_date - ame_util.oneSecond , p_effective_date);
391: --
392: l_proc varchar2(72) := g_package||'pre_insert';

Line 398: If (ame_gcf_ins.g_application_id_i is not null or

394: --
395: Begin
396: hr_utility.set_location('Entering:'||l_proc, 5);
397: --
398: If (ame_gcf_ins.g_application_id_i is not null or
399: ame_gcf_ins.g_approval_group_id_i is not null) Then
400: --
401: -- Verify registered primary key values not already in use
402: --

Line 399: ame_gcf_ins.g_approval_group_id_i is not null) Then

395: Begin
396: hr_utility.set_location('Entering:'||l_proc, 5);
397: --
398: If (ame_gcf_ins.g_application_id_i is not null or
399: ame_gcf_ins.g_approval_group_id_i is not null) Then
400: --
401: -- Verify registered primary key values not already in use
402: --
403: Open C_Sel2;

Line 419: ame_gcf_ins.g_application_id_i;

415: --
416: -- Use registered key values and clear globals
417: --
418: p_rec.application_id :=
419: ame_gcf_ins.g_application_id_i;
420: ame_gcf_ins.g_application_id_i := null;
421: p_rec.approval_group_id :=
422: ame_gcf_ins.g_approval_group_id_i;
423: ame_gcf_ins.g_approval_group_id_i := null;

Line 420: ame_gcf_ins.g_application_id_i := null;

416: -- Use registered key values and clear globals
417: --
418: p_rec.application_id :=
419: ame_gcf_ins.g_application_id_i;
420: ame_gcf_ins.g_application_id_i := null;
421: p_rec.approval_group_id :=
422: ame_gcf_ins.g_approval_group_id_i;
423: ame_gcf_ins.g_approval_group_id_i := null;
424: end if;

Line 422: ame_gcf_ins.g_approval_group_id_i;

418: p_rec.application_id :=
419: ame_gcf_ins.g_application_id_i;
420: ame_gcf_ins.g_application_id_i := null;
421: p_rec.approval_group_id :=
422: ame_gcf_ins.g_approval_group_id_i;
423: ame_gcf_ins.g_approval_group_id_i := null;
424: end if;
425: --+
426: --+ Set the appropriate order number.

Line 423: ame_gcf_ins.g_approval_group_id_i := null;

419: ame_gcf_ins.g_application_id_i;
420: ame_gcf_ins.g_application_id_i := null;
421: p_rec.approval_group_id :=
422: ame_gcf_ins.g_approval_group_id_i;
423: ame_gcf_ins.g_approval_group_id_i := null;
424: end if;
425: --+
426: --+ Set the appropriate order number.
427: --+

Line 643: ame_gcf_ins.ins_lck

639: hr_utility.set_location('Entering:'||l_proc, 5);
640: --
641: -- Call the lock operation
642: --
643: ame_gcf_ins.ins_lck
644: (p_effective_date => p_effective_date
645: ,p_datetrack_mode => l_datetrack_mode
646: ,p_rec => p_rec
647: ,p_validation_start_date => l_validation_start_date

Line 666: ame_gcf_ins.pre_insert

662: hr_multi_message.end_validation_set;
663: --
664: -- Call the supporting pre-insert operation
665: --
666: ame_gcf_ins.pre_insert
667: (p_rec => p_rec
668: ,p_effective_date => p_effective_date
669: ,p_datetrack_mode => l_datetrack_mode
670: ,p_validation_start_date => l_validation_start_date

Line 676: ame_gcf_ins.insert_dml

672: );
673: --
674: -- Insert the row
675: --
676: ame_gcf_ins.insert_dml
677: (p_rec => p_rec
678: ,p_effective_date => p_effective_date
679: ,p_datetrack_mode => l_datetrack_mode
680: ,p_validation_start_date => l_validation_start_date

Line 686: ame_gcf_ins.post_insert

682: );
683: --
684: -- Call the supporting post-insert operation
685: --
686: ame_gcf_ins.post_insert
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 738: ame_gcf_ins.ins

734: -- Having converted the arguments into the ame_gcf_rec
735: -- plsql record structure we call the corresponding record
736: -- business process.
737: --
738: ame_gcf_ins.ins
739: (p_effective_date
740: ,l_rec
741: );
742: --

Line 753: end ame_gcf_ins;

749: --
750: hr_utility.set_location(' Leaving:'||l_proc, 10);
751: End ins;
752: --
753: end ame_gcf_ins;