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_EXTRACT2_PKG dependencies on IGS_HE_EX_RN_DAT_FD

Line 28: l_hesa_method igs_he_ex_rn_dat_fd.value%TYPE;

24: g_he_st_unt_vs igs_he_st_unt_vs%ROWTYPE;
25: g_ps_unit_ver_v igs_ps_unit_ver_v%ROWTYPE;
26: g_default_pro VARCHAR2(1);
27: g_he_stdnt_dlhe igs_he_stdnt_dlhe%ROWTYPE ;
28: l_hesa_method igs_he_ex_rn_dat_fd.value%TYPE;
29: l_hesa_empcir igs_he_ex_rn_dat_fd.value%TYPE;
30: l_hesa_modstudy igs_he_ex_rn_dat_fd.value%TYPE;
31: l_hesa_natstudy igs_he_ex_rn_dat_fd.value%TYPE;
32: l_hesa_empcrse igs_he_ex_rn_dat_fd.value%TYPE;

Line 29: l_hesa_empcir igs_he_ex_rn_dat_fd.value%TYPE;

25: g_ps_unit_ver_v igs_ps_unit_ver_v%ROWTYPE;
26: g_default_pro VARCHAR2(1);
27: g_he_stdnt_dlhe igs_he_stdnt_dlhe%ROWTYPE ;
28: l_hesa_method igs_he_ex_rn_dat_fd.value%TYPE;
29: l_hesa_empcir igs_he_ex_rn_dat_fd.value%TYPE;
30: l_hesa_modstudy igs_he_ex_rn_dat_fd.value%TYPE;
31: l_hesa_natstudy igs_he_ex_rn_dat_fd.value%TYPE;
32: l_hesa_empcrse igs_he_ex_rn_dat_fd.value%TYPE;
33: l_hesa_prevemp igs_he_ex_rn_dat_fd.value%TYPE;

Line 30: l_hesa_modstudy igs_he_ex_rn_dat_fd.value%TYPE;

26: g_default_pro VARCHAR2(1);
27: g_he_stdnt_dlhe igs_he_stdnt_dlhe%ROWTYPE ;
28: l_hesa_method igs_he_ex_rn_dat_fd.value%TYPE;
29: l_hesa_empcir igs_he_ex_rn_dat_fd.value%TYPE;
30: l_hesa_modstudy igs_he_ex_rn_dat_fd.value%TYPE;
31: l_hesa_natstudy igs_he_ex_rn_dat_fd.value%TYPE;
32: l_hesa_empcrse igs_he_ex_rn_dat_fd.value%TYPE;
33: l_hesa_prevemp igs_he_ex_rn_dat_fd.value%TYPE;
34: l_hesa_tchemp igs_he_ex_rn_dat_fd.value%TYPE;

Line 31: l_hesa_natstudy igs_he_ex_rn_dat_fd.value%TYPE;

27: g_he_stdnt_dlhe igs_he_stdnt_dlhe%ROWTYPE ;
28: l_hesa_method igs_he_ex_rn_dat_fd.value%TYPE;
29: l_hesa_empcir igs_he_ex_rn_dat_fd.value%TYPE;
30: l_hesa_modstudy igs_he_ex_rn_dat_fd.value%TYPE;
31: l_hesa_natstudy igs_he_ex_rn_dat_fd.value%TYPE;
32: l_hesa_empcrse igs_he_ex_rn_dat_fd.value%TYPE;
33: l_hesa_prevemp igs_he_ex_rn_dat_fd.value%TYPE;
34: l_hesa_tchemp igs_he_ex_rn_dat_fd.value%TYPE;
35: g_field_exists BOOLEAN;

Line 32: l_hesa_empcrse igs_he_ex_rn_dat_fd.value%TYPE;

28: l_hesa_method igs_he_ex_rn_dat_fd.value%TYPE;
29: l_hesa_empcir igs_he_ex_rn_dat_fd.value%TYPE;
30: l_hesa_modstudy igs_he_ex_rn_dat_fd.value%TYPE;
31: l_hesa_natstudy igs_he_ex_rn_dat_fd.value%TYPE;
32: l_hesa_empcrse igs_he_ex_rn_dat_fd.value%TYPE;
33: l_hesa_prevemp igs_he_ex_rn_dat_fd.value%TYPE;
34: l_hesa_tchemp igs_he_ex_rn_dat_fd.value%TYPE;
35: g_field_exists BOOLEAN;
36: g_prog_rec_flag BOOLEAN; -- used as a flag to check whether to search igs_he_submsn_awd table

Line 33: l_hesa_prevemp igs_he_ex_rn_dat_fd.value%TYPE;

29: l_hesa_empcir igs_he_ex_rn_dat_fd.value%TYPE;
30: l_hesa_modstudy igs_he_ex_rn_dat_fd.value%TYPE;
31: l_hesa_natstudy igs_he_ex_rn_dat_fd.value%TYPE;
32: l_hesa_empcrse igs_he_ex_rn_dat_fd.value%TYPE;
33: l_hesa_prevemp igs_he_ex_rn_dat_fd.value%TYPE;
34: l_hesa_tchemp igs_he_ex_rn_dat_fd.value%TYPE;
35: g_field_exists BOOLEAN;
36: g_prog_rec_flag BOOLEAN; -- used as a flag to check whether to search igs_he_submsn_awd table
37: g_prog_type_rec_flag BOOLEAN; -- used as a flag to check whether to search igs_he_submsn_awd table

Line 34: l_hesa_tchemp igs_he_ex_rn_dat_fd.value%TYPE;

30: l_hesa_modstudy igs_he_ex_rn_dat_fd.value%TYPE;
31: l_hesa_natstudy igs_he_ex_rn_dat_fd.value%TYPE;
32: l_hesa_empcrse igs_he_ex_rn_dat_fd.value%TYPE;
33: l_hesa_prevemp igs_he_ex_rn_dat_fd.value%TYPE;
34: l_hesa_tchemp igs_he_ex_rn_dat_fd.value%TYPE;
35: g_field_exists BOOLEAN;
36: g_prog_rec_flag BOOLEAN; -- used as a flag to check whether to search igs_he_submsn_awd table
37: g_prog_type_rec_flag BOOLEAN; -- used as a flag to check whether to search igs_he_submsn_awd table
38: l_awd_conf_start_dt DATE;

Line 52: TYPE value IS TABLE OF igs_he_ex_rn_dat_fd.value%TYPE

48: TYPE defval IS TABLE OF igs_he_usr_rt_cl_fld.default_val%TYPE
49: INDEX BY binary_integer;
50: TYPE reportnullflag IS TABLE OF igs_he_usr_rt_cl_fld.report_null_flag%TYPE
51: INDEX BY binary_integer;
52: TYPE value IS TABLE OF igs_he_ex_rn_dat_fd.value%TYPE
53: INDEX BY binary_integer;
54:
55: TYPE field_defn IS RECORD
56: (field_number fldnum,

Line 695: p_value IN OUT NOCOPY igs_he_ex_rn_dat_fd.value%TYPE)

691: p_course_cd IN igs_he_ex_rn_dat_ln.course_cd%TYPE,
692: p_crv_version_number IN igs_he_ex_rn_dat_ln.crv_version_number%TYPE,
693: p_student_inst_number IN igs_he_ex_rn_dat_ln.student_inst_number%TYPE,
694: p_field_number IN NUMBER,
695: p_value IN OUT NOCOPY igs_he_ex_rn_dat_fd.value%TYPE)
696:
697: IS
698: /***************************************************************
699: Created By :

Line 743: l_fundlev igs_he_ex_rn_dat_fd.value%TYPE;

739: l_prop_not_taught NUMBER ;
740: l_dummy1 igs_ps_fld_of_study.govt_field_of_study%TYPE;
741: l_dummy2 igs_ps_fld_of_study.govt_field_of_study%TYPE;
742: l_dummy3 igs_ps_fld_of_study.govt_field_of_study%TYPE;
743: l_fundlev igs_he_ex_rn_dat_fd.value%TYPE;
744: l_spcstu igs_he_ex_rn_dat_fd.value%TYPE;
745: l_notact igs_he_ex_rn_dat_fd.value%TYPE;
746: l_mode igs_he_ex_rn_dat_fd.value%TYPE;
747: l_typeyr igs_he_ex_rn_dat_fd.value%TYPE;

Line 744: l_spcstu igs_he_ex_rn_dat_fd.value%TYPE;

740: l_dummy1 igs_ps_fld_of_study.govt_field_of_study%TYPE;
741: l_dummy2 igs_ps_fld_of_study.govt_field_of_study%TYPE;
742: l_dummy3 igs_ps_fld_of_study.govt_field_of_study%TYPE;
743: l_fundlev igs_he_ex_rn_dat_fd.value%TYPE;
744: l_spcstu igs_he_ex_rn_dat_fd.value%TYPE;
745: l_notact igs_he_ex_rn_dat_fd.value%TYPE;
746: l_mode igs_he_ex_rn_dat_fd.value%TYPE;
747: l_typeyr igs_he_ex_rn_dat_fd.value%TYPE;
748: l_fmly_name igs_pe_person.surname%TYPE;

Line 745: l_notact igs_he_ex_rn_dat_fd.value%TYPE;

741: l_dummy2 igs_ps_fld_of_study.govt_field_of_study%TYPE;
742: l_dummy3 igs_ps_fld_of_study.govt_field_of_study%TYPE;
743: l_fundlev igs_he_ex_rn_dat_fd.value%TYPE;
744: l_spcstu igs_he_ex_rn_dat_fd.value%TYPE;
745: l_notact igs_he_ex_rn_dat_fd.value%TYPE;
746: l_mode igs_he_ex_rn_dat_fd.value%TYPE;
747: l_typeyr igs_he_ex_rn_dat_fd.value%TYPE;
748: l_fmly_name igs_pe_person.surname%TYPE;
749: l_disadv_uplift_factor igs_he_st_spa.disadv_uplift_factor%TYPE;

Line 746: l_mode igs_he_ex_rn_dat_fd.value%TYPE;

742: l_dummy3 igs_ps_fld_of_study.govt_field_of_study%TYPE;
743: l_fundlev igs_he_ex_rn_dat_fd.value%TYPE;
744: l_spcstu igs_he_ex_rn_dat_fd.value%TYPE;
745: l_notact igs_he_ex_rn_dat_fd.value%TYPE;
746: l_mode igs_he_ex_rn_dat_fd.value%TYPE;
747: l_typeyr igs_he_ex_rn_dat_fd.value%TYPE;
748: l_fmly_name igs_pe_person.surname%TYPE;
749: l_disadv_uplift_factor igs_he_st_spa.disadv_uplift_factor%TYPE;
750:

Line 747: l_typeyr igs_he_ex_rn_dat_fd.value%TYPE;

743: l_fundlev igs_he_ex_rn_dat_fd.value%TYPE;
744: l_spcstu igs_he_ex_rn_dat_fd.value%TYPE;
745: l_notact igs_he_ex_rn_dat_fd.value%TYPE;
746: l_mode igs_he_ex_rn_dat_fd.value%TYPE;
747: l_typeyr igs_he_ex_rn_dat_fd.value%TYPE;
748: l_fmly_name igs_pe_person.surname%TYPE;
749: l_disadv_uplift_factor igs_he_st_spa.disadv_uplift_factor%TYPE;
750:
751: CURSOR c_subj(cp_field_of_study igs_ps_fld_of_study.field_of_study%TYPE)

Line 4624: p_value IN OUT NOCOPY igs_he_ex_rn_dat_fd.value%TYPE)

4620: p_course_cd IN igs_he_ex_rn_dat_ln.course_cd%TYPE,
4621: p_crv_version_number IN igs_he_ex_rn_dat_ln.crv_version_number%TYPE,
4622: p_student_inst_number IN igs_he_ex_rn_dat_ln.student_inst_number%TYPE,
4623: p_field_number IN NUMBER,
4624: p_value IN OUT NOCOPY igs_he_ex_rn_dat_fd.value%TYPE)
4625:
4626: IS
4627: /***************************************************************
4628: Created By :

Line 4667: l_fundlev igs_he_ex_rn_dat_fd.value%TYPE;

4663: l_dummy VARCHAR2(50);
4664: l_dummy1 igs_ps_fld_of_study.govt_field_of_study%TYPE;
4665: l_dummy2 igs_ps_fld_of_study.govt_field_of_study%TYPE;
4666: l_dummy3 igs_ps_fld_of_study.govt_field_of_study%TYPE;
4667: l_fundlev igs_he_ex_rn_dat_fd.value%TYPE;
4668: l_spcstu igs_he_ex_rn_dat_fd.value%TYPE;
4669: l_notact igs_he_ex_rn_dat_fd.value%TYPE;
4670: l_mode igs_he_ex_rn_dat_fd.value%TYPE;
4671: l_typeyr igs_he_ex_rn_dat_fd.value%TYPE;

Line 4668: l_spcstu igs_he_ex_rn_dat_fd.value%TYPE;

4664: l_dummy1 igs_ps_fld_of_study.govt_field_of_study%TYPE;
4665: l_dummy2 igs_ps_fld_of_study.govt_field_of_study%TYPE;
4666: l_dummy3 igs_ps_fld_of_study.govt_field_of_study%TYPE;
4667: l_fundlev igs_he_ex_rn_dat_fd.value%TYPE;
4668: l_spcstu igs_he_ex_rn_dat_fd.value%TYPE;
4669: l_notact igs_he_ex_rn_dat_fd.value%TYPE;
4670: l_mode igs_he_ex_rn_dat_fd.value%TYPE;
4671: l_typeyr igs_he_ex_rn_dat_fd.value%TYPE;
4672: l_fmly_name igs_pe_person.surname%TYPE;

Line 4669: l_notact igs_he_ex_rn_dat_fd.value%TYPE;

4665: l_dummy2 igs_ps_fld_of_study.govt_field_of_study%TYPE;
4666: l_dummy3 igs_ps_fld_of_study.govt_field_of_study%TYPE;
4667: l_fundlev igs_he_ex_rn_dat_fd.value%TYPE;
4668: l_spcstu igs_he_ex_rn_dat_fd.value%TYPE;
4669: l_notact igs_he_ex_rn_dat_fd.value%TYPE;
4670: l_mode igs_he_ex_rn_dat_fd.value%TYPE;
4671: l_typeyr igs_he_ex_rn_dat_fd.value%TYPE;
4672: l_fmly_name igs_pe_person.surname%TYPE;
4673: l_disadv_uplift_factor igs_he_st_spa.disadv_uplift_factor%TYPE;

Line 4670: l_mode igs_he_ex_rn_dat_fd.value%TYPE;

4666: l_dummy3 igs_ps_fld_of_study.govt_field_of_study%TYPE;
4667: l_fundlev igs_he_ex_rn_dat_fd.value%TYPE;
4668: l_spcstu igs_he_ex_rn_dat_fd.value%TYPE;
4669: l_notact igs_he_ex_rn_dat_fd.value%TYPE;
4670: l_mode igs_he_ex_rn_dat_fd.value%TYPE;
4671: l_typeyr igs_he_ex_rn_dat_fd.value%TYPE;
4672: l_fmly_name igs_pe_person.surname%TYPE;
4673: l_disadv_uplift_factor igs_he_st_spa.disadv_uplift_factor%TYPE;
4674:

Line 4671: l_typeyr igs_he_ex_rn_dat_fd.value%TYPE;

4667: l_fundlev igs_he_ex_rn_dat_fd.value%TYPE;
4668: l_spcstu igs_he_ex_rn_dat_fd.value%TYPE;
4669: l_notact igs_he_ex_rn_dat_fd.value%TYPE;
4670: l_mode igs_he_ex_rn_dat_fd.value%TYPE;
4671: l_typeyr igs_he_ex_rn_dat_fd.value%TYPE;
4672: l_fmly_name igs_pe_person.surname%TYPE;
4673: l_disadv_uplift_factor igs_he_st_spa.disadv_uplift_factor%TYPE;
4674:
4675: CURSOR c_subj(cp_field_of_study igs_ps_fld_of_study.field_of_study%TYPE)

Line 8227: p_field_number IN igs_he_ex_rn_dat_fd.field_number%TYPE,

8223: ----------------------------------------------------------------------*/
8224: PROCEDURE process_module_fields
8225: (p_unit_cd IN igs_he_ex_rn_dat_ln.unit_cd%TYPE,
8226: p_uv_version_number IN igs_he_ex_rn_dat_ln.uv_version_number%TYPE,
8227: p_field_number IN igs_he_ex_rn_dat_fd.field_number%TYPE,
8228: p_value IN OUT NOCOPY igs_he_ex_rn_dat_fd.value%TYPE)
8229: IS
8230: /***************************************************************
8231: Created By :

Line 8228: p_value IN OUT NOCOPY igs_he_ex_rn_dat_fd.value%TYPE)

8224: PROCEDURE process_module_fields
8225: (p_unit_cd IN igs_he_ex_rn_dat_ln.unit_cd%TYPE,
8226: p_uv_version_number IN igs_he_ex_rn_dat_ln.uv_version_number%TYPE,
8227: p_field_number IN igs_he_ex_rn_dat_fd.field_number%TYPE,
8228: p_value IN OUT NOCOPY igs_he_ex_rn_dat_fd.value%TYPE)
8229: IS
8230: /***************************************************************
8231: Created By :
8232: Date Created By :

Line 8599: p_value IN OUT NOCOPY igs_he_ex_rn_dat_fd.value%TYPE)

8595: ----------------------------------------------------------------------*/
8596: PROCEDURE process_dlhe_fields
8597: (p_person_id IN igs_he_ex_rn_dat_ln.person_id%TYPE,
8598: p_field_number IN NUMBER,
8599: p_value IN OUT NOCOPY igs_he_ex_rn_dat_fd.value%TYPE)
8600:
8601: IS
8602: /***************************************************************
8603: Created By : smaddali

Line 9218: l_fld_seq igs_he_ex_rn_dat_fd.rn_dat_fd_id%TYPE;

9214: jbaber 15-Mar-2006 Update recalculated fields for HE365 - Extract Rerun
9215: ***************************************************************/
9216:
9217: l_rowid VARCHAR2(30);
9218: l_fld_seq igs_he_ex_rn_dat_fd.rn_dat_fd_id%TYPE;
9219: l_index NUMBER;
9220: l_value igs_he_ex_rn_dat_fd.value%TYPE;
9221:
9222: l_last_update_date DATE;

Line 9220: l_value igs_he_ex_rn_dat_fd.value%TYPE;

9216:
9217: l_rowid VARCHAR2(30);
9218: l_fld_seq igs_he_ex_rn_dat_fd.rn_dat_fd_id%TYPE;
9219: l_index NUMBER;
9220: l_value igs_he_ex_rn_dat_fd.value%TYPE;
9221:
9222: l_last_update_date DATE;
9223: l_last_updated_by NUMBER;
9224: l_last_update_login NUMBER;

Line 9359: UPDATE igs_he_ex_rn_dat_fd

9355:
9356: -- If field is being recalculated then we should update field rather than insert
9357: IF g_field_exists THEN
9358:
9359: UPDATE igs_he_ex_rn_dat_fd
9360: SET value = l_value
9361: WHERE extract_run_id = p_extract_run_id
9362: AND line_number = p_line_number
9363: AND field_number = g_field_defn.field_number(l_index);

Line 9373: INSERT INTO igs_he_ex_rn_dat_fd (

9369: -- which will pick up the new fields.
9370: IF NOT g_field_exists OR (SQL%ROWCOUNT = 0) THEN
9371:
9372: --jchakrab - 4006205 - replace TBH with direct DML call
9373: INSERT INTO igs_he_ex_rn_dat_fd (
9374: rn_dat_fd_id,
9375: extract_run_id,
9376: line_number,
9377: field_number,

Line 9386: IGS_HE_EX_RN_DAT_FD_S.NEXTVAL,

9382: last_update_date,
9383: last_updated_by,
9384: last_update_login
9385: ) VALUES (
9386: IGS_HE_EX_RN_DAT_FD_S.NEXTVAL,
9387: p_extract_run_id,
9388: p_line_number,
9389: g_field_defn.field_number(l_index),
9390: l_value,