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.BEN_ELIGIBLE_PERSON_API dependencies on BEN_ELIG_PER_F

Line 122: l_elig_per_id ben_elig_per_f.elig_per_id%TYPE;

118: is
119: --
120: -- Declare cursors and local variables
121: --
122: l_elig_per_id ben_elig_per_f.elig_per_id%TYPE;
123: l_effective_start_date ben_elig_per_f.effective_start_date%TYPE;
124: l_effective_end_date ben_elig_per_f.effective_end_date%TYPE;
125: l_proc varchar2(72) := g_package||'create_Eligible_Person';
126: l_object_version_number ben_elig_per_f.object_version_number%TYPE;

Line 123: l_effective_start_date ben_elig_per_f.effective_start_date%TYPE;

119: --
120: -- Declare cursors and local variables
121: --
122: l_elig_per_id ben_elig_per_f.elig_per_id%TYPE;
123: l_effective_start_date ben_elig_per_f.effective_start_date%TYPE;
124: l_effective_end_date ben_elig_per_f.effective_end_date%TYPE;
125: l_proc varchar2(72) := g_package||'create_Eligible_Person';
126: l_object_version_number ben_elig_per_f.object_version_number%TYPE;
127: --

Line 124: l_effective_end_date ben_elig_per_f.effective_end_date%TYPE;

120: -- Declare cursors and local variables
121: --
122: l_elig_per_id ben_elig_per_f.elig_per_id%TYPE;
123: l_effective_start_date ben_elig_per_f.effective_start_date%TYPE;
124: l_effective_end_date ben_elig_per_f.effective_end_date%TYPE;
125: l_proc varchar2(72) := g_package||'create_Eligible_Person';
126: l_object_version_number ben_elig_per_f.object_version_number%TYPE;
127: --
128: begin

Line 126: l_object_version_number ben_elig_per_f.object_version_number%TYPE;

122: l_elig_per_id ben_elig_per_f.elig_per_id%TYPE;
123: l_effective_start_date ben_elig_per_f.effective_start_date%TYPE;
124: l_effective_end_date ben_elig_per_f.effective_end_date%TYPE;
125: l_proc varchar2(72) := g_package||'create_Eligible_Person';
126: l_object_version_number ben_elig_per_f.object_version_number%TYPE;
127: --
128: begin
129: --
130: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 649: l_elig_per_id ben_elig_per_f.elig_per_id%TYPE;

645: l_rec ben_pep_shd.g_rec_type;
646: --
647: -- Declare cursors and local variables
648: --
649: l_elig_per_id ben_elig_per_f.elig_per_id%TYPE;
650: l_effective_start_date ben_elig_per_f.effective_start_date%TYPE;
651: l_effective_end_date ben_elig_per_f.effective_end_date%TYPE;
652: l_object_version_number ben_elig_per_f.object_version_number%TYPE;
653: --

Line 650: l_effective_start_date ben_elig_per_f.effective_start_date%TYPE;

646: --
647: -- Declare cursors and local variables
648: --
649: l_elig_per_id ben_elig_per_f.elig_per_id%TYPE;
650: l_effective_start_date ben_elig_per_f.effective_start_date%TYPE;
651: l_effective_end_date ben_elig_per_f.effective_end_date%TYPE;
652: l_object_version_number ben_elig_per_f.object_version_number%TYPE;
653: --
654: l_created_by ben_elig_per_f.created_by%TYPE;

Line 651: l_effective_end_date ben_elig_per_f.effective_end_date%TYPE;

647: -- Declare cursors and local variables
648: --
649: l_elig_per_id ben_elig_per_f.elig_per_id%TYPE;
650: l_effective_start_date ben_elig_per_f.effective_start_date%TYPE;
651: l_effective_end_date ben_elig_per_f.effective_end_date%TYPE;
652: l_object_version_number ben_elig_per_f.object_version_number%TYPE;
653: --
654: l_created_by ben_elig_per_f.created_by%TYPE;
655: l_creation_date ben_elig_per_f.creation_date%TYPE;

Line 652: l_object_version_number ben_elig_per_f.object_version_number%TYPE;

648: --
649: l_elig_per_id ben_elig_per_f.elig_per_id%TYPE;
650: l_effective_start_date ben_elig_per_f.effective_start_date%TYPE;
651: l_effective_end_date ben_elig_per_f.effective_end_date%TYPE;
652: l_object_version_number ben_elig_per_f.object_version_number%TYPE;
653: --
654: l_created_by ben_elig_per_f.created_by%TYPE;
655: l_creation_date ben_elig_per_f.creation_date%TYPE;
656: l_last_update_date ben_elig_per_f.last_update_date%TYPE;

Line 654: l_created_by ben_elig_per_f.created_by%TYPE;

650: l_effective_start_date ben_elig_per_f.effective_start_date%TYPE;
651: l_effective_end_date ben_elig_per_f.effective_end_date%TYPE;
652: l_object_version_number ben_elig_per_f.object_version_number%TYPE;
653: --
654: l_created_by ben_elig_per_f.created_by%TYPE;
655: l_creation_date ben_elig_per_f.creation_date%TYPE;
656: l_last_update_date ben_elig_per_f.last_update_date%TYPE;
657: l_last_updated_by ben_elig_per_f.last_updated_by%TYPE;
658: l_last_update_login ben_elig_per_f.last_update_login%TYPE;

Line 655: l_creation_date ben_elig_per_f.creation_date%TYPE;

651: l_effective_end_date ben_elig_per_f.effective_end_date%TYPE;
652: l_object_version_number ben_elig_per_f.object_version_number%TYPE;
653: --
654: l_created_by ben_elig_per_f.created_by%TYPE;
655: l_creation_date ben_elig_per_f.creation_date%TYPE;
656: l_last_update_date ben_elig_per_f.last_update_date%TYPE;
657: l_last_updated_by ben_elig_per_f.last_updated_by%TYPE;
658: l_last_update_login ben_elig_per_f.last_update_login%TYPE;
659: --

Line 656: l_last_update_date ben_elig_per_f.last_update_date%TYPE;

652: l_object_version_number ben_elig_per_f.object_version_number%TYPE;
653: --
654: l_created_by ben_elig_per_f.created_by%TYPE;
655: l_creation_date ben_elig_per_f.creation_date%TYPE;
656: l_last_update_date ben_elig_per_f.last_update_date%TYPE;
657: l_last_updated_by ben_elig_per_f.last_updated_by%TYPE;
658: l_last_update_login ben_elig_per_f.last_update_login%TYPE;
659: --
660: l_minmax_rec ben_batch_dt_api.gtyp_dtsum_row;

Line 657: l_last_updated_by ben_elig_per_f.last_updated_by%TYPE;

653: --
654: l_created_by ben_elig_per_f.created_by%TYPE;
655: l_creation_date ben_elig_per_f.creation_date%TYPE;
656: l_last_update_date ben_elig_per_f.last_update_date%TYPE;
657: l_last_updated_by ben_elig_per_f.last_updated_by%TYPE;
658: l_last_update_login ben_elig_per_f.last_update_login%TYPE;
659: --
660: l_minmax_rec ben_batch_dt_api.gtyp_dtsum_row;
661: --

Line 658: l_last_update_login ben_elig_per_f.last_update_login%TYPE;

654: l_created_by ben_elig_per_f.created_by%TYPE;
655: l_creation_date ben_elig_per_f.creation_date%TYPE;
656: l_last_update_date ben_elig_per_f.last_update_date%TYPE;
657: l_last_updated_by ben_elig_per_f.last_updated_by%TYPE;
658: l_last_update_login ben_elig_per_f.last_update_login%TYPE;
659: --
660: l_minmax_rec ben_batch_dt_api.gtyp_dtsum_row;
661: --
662: begin

Line 805: -- Insert the row into: ben_elig_per_f

801: l_object_version_number := 1;
802: --
803: ben_pep_shd.g_api_dml := true; -- Set the api dml status
804: --
805: -- Insert the row into: ben_elig_per_f
806: --
807: hr_utility.set_location('Insert: '||l_proc, 5);
808: insert into ben_elig_per_f
809: (

Line 808: insert into ben_elig_per_f

804: --
805: -- Insert the row into: ben_elig_per_f
806: --
807: hr_utility.set_location('Insert: '||l_proc, 5);
808: insert into ben_elig_per_f
809: (
810: elig_per_id,
811: effective_start_date,
812: effective_end_date,

Line 916: ben_elig_per_f_s.nextval,

912: last_update_login
913: )
914: Values
915: (
916: ben_elig_per_f_s.nextval,
917: l_effective_start_date,
918: l_effective_end_date,
919: p_business_group_id,
920: p_pl_id,

Line 1184: l_object_version_number ben_elig_per_f.object_version_number%TYPE;

1180: --
1181: -- Declare cursors and local variables
1182: --
1183: l_proc varchar2(72) := g_package||'update_Eligible_Person';
1184: l_object_version_number ben_elig_per_f.object_version_number%TYPE;
1185: l_effective_start_date ben_elig_per_f.effective_start_date%TYPE;
1186: l_effective_end_date ben_elig_per_f.effective_end_date%TYPE;
1187: --
1188: begin

Line 1185: l_effective_start_date ben_elig_per_f.effective_start_date%TYPE;

1181: -- Declare cursors and local variables
1182: --
1183: l_proc varchar2(72) := g_package||'update_Eligible_Person';
1184: l_object_version_number ben_elig_per_f.object_version_number%TYPE;
1185: l_effective_start_date ben_elig_per_f.effective_start_date%TYPE;
1186: l_effective_end_date ben_elig_per_f.effective_end_date%TYPE;
1187: --
1188: begin
1189: --

Line 1186: l_effective_end_date ben_elig_per_f.effective_end_date%TYPE;

1182: --
1183: l_proc varchar2(72) := g_package||'update_Eligible_Person';
1184: l_object_version_number ben_elig_per_f.object_version_number%TYPE;
1185: l_effective_start_date ben_elig_per_f.effective_start_date%TYPE;
1186: l_effective_end_date ben_elig_per_f.effective_end_date%TYPE;
1187: --
1188: begin
1189: --
1190: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 1605: l_object_version_number ben_elig_per_f.object_version_number%TYPE;

1601: --
1602: -- Declare cursors and local variables
1603: --
1604: l_proc varchar2(72) := g_package||'update_Eligible_Person';
1605: l_object_version_number ben_elig_per_f.object_version_number%TYPE;
1606: l_effective_start_date ben_elig_per_f.effective_start_date%TYPE;
1607: l_effective_end_date ben_elig_per_f.effective_end_date%TYPE;
1608: --
1609: begin

Line 1606: l_effective_start_date ben_elig_per_f.effective_start_date%TYPE;

1602: -- Declare cursors and local variables
1603: --
1604: l_proc varchar2(72) := g_package||'update_Eligible_Person';
1605: l_object_version_number ben_elig_per_f.object_version_number%TYPE;
1606: l_effective_start_date ben_elig_per_f.effective_start_date%TYPE;
1607: l_effective_end_date ben_elig_per_f.effective_end_date%TYPE;
1608: --
1609: begin
1610: --

Line 1607: l_effective_end_date ben_elig_per_f.effective_end_date%TYPE;

1603: --
1604: l_proc varchar2(72) := g_package||'update_Eligible_Person';
1605: l_object_version_number ben_elig_per_f.object_version_number%TYPE;
1606: l_effective_start_date ben_elig_per_f.effective_start_date%TYPE;
1607: l_effective_end_date ben_elig_per_f.effective_end_date%TYPE;
1608: --
1609: begin
1610: --
1611: hr_utility.set_location('Entering:'|| l_proc, 10);