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_ENROLLMENT_RATE_API dependencies on BEN_ENRT_RT

Line 319: l_enrt_rt_id ben_enrt_rt.enrt_rt_id%TYPE;

315: ) is
316: --
317: -- Declare cursors and local variables
318: --
319: l_enrt_rt_id ben_enrt_rt.enrt_rt_id%TYPE;
320: l_proc varchar2(72) := g_package||'create_Enrollment_Rate';
321: l_object_version_number ben_enrt_rt.object_version_number%TYPE;
322: --
323: begin

Line 321: l_object_version_number ben_enrt_rt.object_version_number%TYPE;

317: -- Declare cursors and local variables
318: --
319: l_enrt_rt_id ben_enrt_rt.enrt_rt_id%TYPE;
320: l_proc varchar2(72) := g_package||'create_Enrollment_Rate';
321: l_object_version_number ben_enrt_rt.object_version_number%TYPE;
322: --
323: begin
324: --
325: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 801: l_enrt_rt_id ben_enrt_rt.enrt_rt_id%TYPE;

797: l_proc varchar2(72) := g_package||'create_perf_Enrollment_Rate';
798: --
799: -- Declare cursors and local variables
800: --
801: l_enrt_rt_id ben_enrt_rt.enrt_rt_id%TYPE;
802: l_object_version_number ben_enrt_rt.object_version_number%TYPE;
803: --
804: l_created_by ben_enrt_rt.created_by%TYPE;
805: l_creation_date ben_enrt_rt.creation_date%TYPE;

Line 802: l_object_version_number ben_enrt_rt.object_version_number%TYPE;

798: --
799: -- Declare cursors and local variables
800: --
801: l_enrt_rt_id ben_enrt_rt.enrt_rt_id%TYPE;
802: l_object_version_number ben_enrt_rt.object_version_number%TYPE;
803: --
804: l_created_by ben_enrt_rt.created_by%TYPE;
805: l_creation_date ben_enrt_rt.creation_date%TYPE;
806: l_last_update_date ben_enrt_rt.last_update_date%TYPE;

Line 804: l_created_by ben_enrt_rt.created_by%TYPE;

800: --
801: l_enrt_rt_id ben_enrt_rt.enrt_rt_id%TYPE;
802: l_object_version_number ben_enrt_rt.object_version_number%TYPE;
803: --
804: l_created_by ben_enrt_rt.created_by%TYPE;
805: l_creation_date ben_enrt_rt.creation_date%TYPE;
806: l_last_update_date ben_enrt_rt.last_update_date%TYPE;
807: l_last_updated_by ben_enrt_rt.last_updated_by%TYPE;
808: l_last_update_login ben_enrt_rt.last_update_login%TYPE;

Line 805: l_creation_date ben_enrt_rt.creation_date%TYPE;

801: l_enrt_rt_id ben_enrt_rt.enrt_rt_id%TYPE;
802: l_object_version_number ben_enrt_rt.object_version_number%TYPE;
803: --
804: l_created_by ben_enrt_rt.created_by%TYPE;
805: l_creation_date ben_enrt_rt.creation_date%TYPE;
806: l_last_update_date ben_enrt_rt.last_update_date%TYPE;
807: l_last_updated_by ben_enrt_rt.last_updated_by%TYPE;
808: l_last_update_login ben_enrt_rt.last_update_login%TYPE;
809: --

Line 806: l_last_update_date ben_enrt_rt.last_update_date%TYPE;

802: l_object_version_number ben_enrt_rt.object_version_number%TYPE;
803: --
804: l_created_by ben_enrt_rt.created_by%TYPE;
805: l_creation_date ben_enrt_rt.creation_date%TYPE;
806: l_last_update_date ben_enrt_rt.last_update_date%TYPE;
807: l_last_updated_by ben_enrt_rt.last_updated_by%TYPE;
808: l_last_update_login ben_enrt_rt.last_update_login%TYPE;
809: --
810: Cursor C_Sel1 is select ben_enrt_rt_s.nextval from sys.dual;

Line 807: l_last_updated_by ben_enrt_rt.last_updated_by%TYPE;

803: --
804: l_created_by ben_enrt_rt.created_by%TYPE;
805: l_creation_date ben_enrt_rt.creation_date%TYPE;
806: l_last_update_date ben_enrt_rt.last_update_date%TYPE;
807: l_last_updated_by ben_enrt_rt.last_updated_by%TYPE;
808: l_last_update_login ben_enrt_rt.last_update_login%TYPE;
809: --
810: Cursor C_Sel1 is select ben_enrt_rt_s.nextval from sys.dual;
811: --

Line 808: l_last_update_login ben_enrt_rt.last_update_login%TYPE;

804: l_created_by ben_enrt_rt.created_by%TYPE;
805: l_creation_date ben_enrt_rt.creation_date%TYPE;
806: l_last_update_date ben_enrt_rt.last_update_date%TYPE;
807: l_last_updated_by ben_enrt_rt.last_updated_by%TYPE;
808: l_last_update_login ben_enrt_rt.last_update_login%TYPE;
809: --
810: Cursor C_Sel1 is select ben_enrt_rt_s.nextval from sys.dual;
811: --
812: l_minmax_rec ben_batch_dt_api.gtyp_dtsum_row;

Line 810: Cursor C_Sel1 is select ben_enrt_rt_s.nextval from sys.dual;

806: l_last_update_date ben_enrt_rt.last_update_date%TYPE;
807: l_last_updated_by ben_enrt_rt.last_updated_by%TYPE;
808: l_last_update_login ben_enrt_rt.last_update_login%TYPE;
809: --
810: Cursor C_Sel1 is select ben_enrt_rt_s.nextval from sys.dual;
811: --
812: l_minmax_rec ben_batch_dt_api.gtyp_dtsum_row;
813: --
814: begin

Line 833: insert into ben_enrt_rt

829: --
830: -- Select the next sequence number
831: --
832: hr_utility.set_location('Insert ECR: '||l_proc, 5);
833: insert into ben_enrt_rt
834: (enrt_rt_id
835: ,ordr_num
836: ,acty_typ_cd
837: ,tx_typ_cd

Line 931: (ben_enrt_rt_s.nextval

927: ,program_update_date
928: ,object_version_number
929: )
930: Values
931: (ben_enrt_rt_s.nextval
932: ,p_ordr_num
933: ,p_acty_typ_cd
934: ,p_tx_typ_cd
935: ,p_ctfn_rqd_flag

Line 1641: from ben_enrt_rt

1637: -- Declare cursors and local variables
1638: --
1639: cursor c_rate_vals is
1640: select mx_elcn_val , mn_elcn_val , incrmt_elcn_val , elig_per_elctbl_chc_id
1641: from ben_enrt_rt
1642: where enrt_rt_id = p_enrt_rt_id ;
1643: l_rate_vals c_rate_vals%rowtype;
1644: l_proc varchar2(72) := g_package||'update_Enrollment_Rate';
1645: l_object_version_number ben_enrt_rt.object_version_number%TYPE;

Line 1645: l_object_version_number ben_enrt_rt.object_version_number%TYPE;

1641: from ben_enrt_rt
1642: where enrt_rt_id = p_enrt_rt_id ;
1643: l_rate_vals c_rate_vals%rowtype;
1644: l_proc varchar2(72) := g_package||'update_Enrollment_Rate';
1645: l_object_version_number ben_enrt_rt.object_version_number%TYPE;
1646: --
1647: begin
1648: --
1649: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 2064: l_object_version_number ben_enrt_rt.object_version_number%TYPE;

2060: --
2061: -- Declare cursors and local variables
2062: --
2063: l_proc varchar2(72) := g_package||'update_Enrollment_Rate';
2064: l_object_version_number ben_enrt_rt.object_version_number%TYPE;
2065: --
2066: begin
2067: --
2068: hr_utility.set_location('Entering:'|| l_proc, 10);