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.IGS_HE_IDENTIFY_TARGET_POP dependencies on IGS_HE_EX_RN_DAT_FD

Line 176: l_comdate igs_he_ex_rn_dat_fd.value%TYPE;

172: ORDER BY hst.person_id;
173:
174: l_research_std cur_research_std%ROWTYPE;
175:
176: l_comdate igs_he_ex_rn_dat_fd.value%TYPE;
177: l_previous_person_id igs_pe_person_base_v.person_id%TYPE;
178:
179: -- Local variable holds C(created dlhe), U(Updated dlhe), E(Record Exists with an open qual period), F for field validation failed
180: l_cre_upd_dlhe VARCHAR2(1);

Line 856: l_oss_qual1 igs_he_ex_rn_dat_fd.value%TYPE;

852:
853: l_person_number igs_pe_person_base_v.person_number%TYPE;
854:
855: -- QUAL1 and QUAL2 out parameter/local variables
856: l_oss_qual1 igs_he_ex_rn_dat_fd.value%TYPE;
857: l_oss_qual2 igs_he_ex_rn_dat_fd.value%TYPE;
858: l_hesa_qual1 igs_he_ex_rn_dat_fd.value%TYPE;
859: l_hesa_qual2 igs_he_ex_rn_dat_fd.value%TYPE;
860: l_hesa_classification igs_he_ex_rn_dat_fd.value%TYPE;

Line 857: l_oss_qual2 igs_he_ex_rn_dat_fd.value%TYPE;

853: l_person_number igs_pe_person_base_v.person_number%TYPE;
854:
855: -- QUAL1 and QUAL2 out parameter/local variables
856: l_oss_qual1 igs_he_ex_rn_dat_fd.value%TYPE;
857: l_oss_qual2 igs_he_ex_rn_dat_fd.value%TYPE;
858: l_hesa_qual1 igs_he_ex_rn_dat_fd.value%TYPE;
859: l_hesa_qual2 igs_he_ex_rn_dat_fd.value%TYPE;
860: l_hesa_classification igs_he_ex_rn_dat_fd.value%TYPE;
861:

Line 858: l_hesa_qual1 igs_he_ex_rn_dat_fd.value%TYPE;

854:
855: -- QUAL1 and QUAL2 out parameter/local variables
856: l_oss_qual1 igs_he_ex_rn_dat_fd.value%TYPE;
857: l_oss_qual2 igs_he_ex_rn_dat_fd.value%TYPE;
858: l_hesa_qual1 igs_he_ex_rn_dat_fd.value%TYPE;
859: l_hesa_qual2 igs_he_ex_rn_dat_fd.value%TYPE;
860: l_hesa_classification igs_he_ex_rn_dat_fd.value%TYPE;
861:
862: -- LOCSDY out parameter/local variables

Line 859: l_hesa_qual2 igs_he_ex_rn_dat_fd.value%TYPE;

855: -- QUAL1 and QUAL2 out parameter/local variables
856: l_oss_qual1 igs_he_ex_rn_dat_fd.value%TYPE;
857: l_oss_qual2 igs_he_ex_rn_dat_fd.value%TYPE;
858: l_hesa_qual1 igs_he_ex_rn_dat_fd.value%TYPE;
859: l_hesa_qual2 igs_he_ex_rn_dat_fd.value%TYPE;
860: l_hesa_classification igs_he_ex_rn_dat_fd.value%TYPE;
861:
862: -- LOCSDY out parameter/local variables
863: l_oss_locsdy igs_he_ex_rn_dat_fd.value%TYPE;

Line 860: l_hesa_classification igs_he_ex_rn_dat_fd.value%TYPE;

856: l_oss_qual1 igs_he_ex_rn_dat_fd.value%TYPE;
857: l_oss_qual2 igs_he_ex_rn_dat_fd.value%TYPE;
858: l_hesa_qual1 igs_he_ex_rn_dat_fd.value%TYPE;
859: l_hesa_qual2 igs_he_ex_rn_dat_fd.value%TYPE;
860: l_hesa_classification igs_he_ex_rn_dat_fd.value%TYPE;
861:
862: -- LOCSDY out parameter/local variables
863: l_oss_locsdy igs_he_ex_rn_dat_fd.value%TYPE;
864: l_hesa_locsdy igs_he_ex_rn_dat_fd.value%TYPE;

Line 863: l_oss_locsdy igs_he_ex_rn_dat_fd.value%TYPE;

859: l_hesa_qual2 igs_he_ex_rn_dat_fd.value%TYPE;
860: l_hesa_classification igs_he_ex_rn_dat_fd.value%TYPE;
861:
862: -- LOCSDY out parameter/local variables
863: l_oss_locsdy igs_he_ex_rn_dat_fd.value%TYPE;
864: l_hesa_locsdy igs_he_ex_rn_dat_fd.value%TYPE;
865:
866: -- RSNLEAVE out parameter/local variables
867: l_rsn_inst_left igs_he_ex_rn_dat_fd.value%TYPE;

Line 864: l_hesa_locsdy igs_he_ex_rn_dat_fd.value%TYPE;

860: l_hesa_classification igs_he_ex_rn_dat_fd.value%TYPE;
861:
862: -- LOCSDY out parameter/local variables
863: l_oss_locsdy igs_he_ex_rn_dat_fd.value%TYPE;
864: l_hesa_locsdy igs_he_ex_rn_dat_fd.value%TYPE;
865:
866: -- RSNLEAVE out parameter/local variables
867: l_rsn_inst_left igs_he_ex_rn_dat_fd.value%TYPE;
868:

Line 867: l_rsn_inst_left igs_he_ex_rn_dat_fd.value%TYPE;

863: l_oss_locsdy igs_he_ex_rn_dat_fd.value%TYPE;
864: l_hesa_locsdy igs_he_ex_rn_dat_fd.value%TYPE;
865:
866: -- RSNLEAVE out parameter/local variables
867: l_rsn_inst_left igs_he_ex_rn_dat_fd.value%TYPE;
868:
869: -- DOMICILE out parameter/local variables
870: l_hesa_domicile igs_he_ex_rn_dat_fd.value%TYPE;
871:

Line 870: l_hesa_domicile igs_he_ex_rn_dat_fd.value%TYPE;

866: -- RSNLEAVE out parameter/local variables
867: l_rsn_inst_left igs_he_ex_rn_dat_fd.value%TYPE;
868:
869: -- DOMICILE out parameter/local variables
870: l_hesa_domicile igs_he_ex_rn_dat_fd.value%TYPE;
871:
872: -- MODE out parameter/local variables
873: l_mode igs_he_ex_rn_dat_fd.value%TYPE;
874:

Line 873: l_mode igs_he_ex_rn_dat_fd.value%TYPE;

869: -- DOMICILE out parameter/local variables
870: l_hesa_domicile igs_he_ex_rn_dat_fd.value%TYPE;
871:
872: -- MODE out parameter/local variables
873: l_mode igs_he_ex_rn_dat_fd.value%TYPE;
874:
875: -- Special Student out parameter/local variables
876: l_oss_special_student igs_he_ex_rn_dat_fd.value%TYPE;
877: l_hesa_special_student igs_he_ex_rn_dat_fd.value%TYPE;

Line 876: l_oss_special_student igs_he_ex_rn_dat_fd.value%TYPE;

872: -- MODE out parameter/local variables
873: l_mode igs_he_ex_rn_dat_fd.value%TYPE;
874:
875: -- Special Student out parameter/local variables
876: l_oss_special_student igs_he_ex_rn_dat_fd.value%TYPE;
877: l_hesa_special_student igs_he_ex_rn_dat_fd.value%TYPE;
878:
879: -- MSTUFEE out parameter/local variables
880: l_hesa_mstufee igs_he_ex_rn_dat_fd.value%TYPE;

Line 877: l_hesa_special_student igs_he_ex_rn_dat_fd.value%TYPE;

873: l_mode igs_he_ex_rn_dat_fd.value%TYPE;
874:
875: -- Special Student out parameter/local variables
876: l_oss_special_student igs_he_ex_rn_dat_fd.value%TYPE;
877: l_hesa_special_student igs_he_ex_rn_dat_fd.value%TYPE;
878:
879: -- MSTUFEE out parameter/local variables
880: l_hesa_mstufee igs_he_ex_rn_dat_fd.value%TYPE;
881:

Line 880: l_hesa_mstufee igs_he_ex_rn_dat_fd.value%TYPE;

876: l_oss_special_student igs_he_ex_rn_dat_fd.value%TYPE;
877: l_hesa_special_student igs_he_ex_rn_dat_fd.value%TYPE;
878:
879: -- MSTUFEE out parameter/local variables
880: l_hesa_mstufee igs_he_ex_rn_dat_fd.value%TYPE;
881:
882: l_include VARCHAR2(1);
883: l_qualified_teacher VARCHAR2(1);
884: l_pt_study VARCHAR2(1);