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

Line 635: p_funding_src IN igs_he_ex_rn_dat_fd.value%TYPE,

631:
632: PROCEDURE get_fe_stdnt_mrker
633: (p_spa_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
634: p_fe_program_marker IN igs_he_st_prog.fe_program_marker%TYPE,
635: p_funding_src IN igs_he_ex_rn_dat_fd.value%TYPE,
636: p_fundability_cd IN igs_he_ex_rn_dat_fd.value%TYPE,
637: p_oss_fe_stdnt_mrker OUT NOCOPY VARCHAR2,
638: p_hesa_fe_stdnt_mrker OUT NOCOPY VARCHAR2)
639: IS

Line 636: p_fundability_cd IN igs_he_ex_rn_dat_fd.value%TYPE,

632: PROCEDURE get_fe_stdnt_mrker
633: (p_spa_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
634: p_fe_program_marker IN igs_he_st_prog.fe_program_marker%TYPE,
635: p_funding_src IN igs_he_ex_rn_dat_fd.value%TYPE,
636: p_fundability_cd IN igs_he_ex_rn_dat_fd.value%TYPE,
637: p_oss_fe_stdnt_mrker OUT NOCOPY VARCHAR2,
638: p_hesa_fe_stdnt_mrker OUT NOCOPY VARCHAR2)
639: IS
640: /***************************************************************

Line 724: l_hesa_fund_src igs_he_ex_rn_dat_fd.value%TYPE;

720: ***************************************************************/
721:
722: l_he_code_map_val igs_he_code_map_val%ROWTYPE;
723: l_oss_fund_src igs_he_code_map_val.map1%TYPE;
724: l_hesa_fund_src igs_he_ex_rn_dat_fd.value%TYPE;
725: l_govt_fund_src igs_he_ex_rn_dat_fd.value%TYPE;
726:
727: CURSOR c_fsrc IS
728: SELECT b.govt_funding_source,

Line 725: l_govt_fund_src igs_he_ex_rn_dat_fd.value%TYPE;

721:
722: l_he_code_map_val igs_he_code_map_val%ROWTYPE;
723: l_oss_fund_src igs_he_code_map_val.map1%TYPE;
724: l_hesa_fund_src igs_he_ex_rn_dat_fd.value%TYPE;
725: l_govt_fund_src igs_he_ex_rn_dat_fd.value%TYPE;
726:
727: CURSOR c_fsrc IS
728: SELECT b.govt_funding_source,
729: a.funding_source

Line 1283: l_hesa_disability igs_he_ex_rn_dat_fd.value%TYPE;

1279: ORDER BY Start_Date DESC;
1280:
1281: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;
1282: l_disability igs_pe_pers_disablty_v.disability_type%TYPE;
1283: l_hesa_disability igs_he_ex_rn_dat_fd.value%TYPE;
1284:
1285: BEGIN
1286: -- jbaber modified association code, HEFD350
1287: l_he_code_map_val.association_code := 'OSS_HESA_DISABILITY_ASSOC';

Line 2711: FUNCTION is_ucas_ftug (p_hesa_qual_aim IN igs_he_ex_rn_dat_fd.value%TYPE,

2707: IGS_GE_MSG_STACK.ADD;
2708: App_Exception.Raise_Exception;
2709: END get_qual_aim_sbj;
2710:
2711: FUNCTION is_ucas_ftug (p_hesa_qual_aim IN igs_he_ex_rn_dat_fd.value%TYPE,
2712: p_hesa_commdate IN igs_he_ex_rn_dat_fd.value%TYPE,
2713: p_ucasnum IN igs_he_ex_rn_dat_fd.value%TYPE,
2714: p_min_commdate IN DATE) RETURN BOOLEAN
2715: IS

Line 2712: p_hesa_commdate IN igs_he_ex_rn_dat_fd.value%TYPE,

2708: App_Exception.Raise_Exception;
2709: END get_qual_aim_sbj;
2710:
2711: FUNCTION is_ucas_ftug (p_hesa_qual_aim IN igs_he_ex_rn_dat_fd.value%TYPE,
2712: p_hesa_commdate IN igs_he_ex_rn_dat_fd.value%TYPE,
2713: p_ucasnum IN igs_he_ex_rn_dat_fd.value%TYPE,
2714: p_min_commdate IN DATE) RETURN BOOLEAN
2715: IS
2716: /***************************************************************

Line 2713: p_ucasnum IN igs_he_ex_rn_dat_fd.value%TYPE,

2709: END get_qual_aim_sbj;
2710:
2711: FUNCTION is_ucas_ftug (p_hesa_qual_aim IN igs_he_ex_rn_dat_fd.value%TYPE,
2712: p_hesa_commdate IN igs_he_ex_rn_dat_fd.value%TYPE,
2713: p_ucasnum IN igs_he_ex_rn_dat_fd.value%TYPE,
2714: p_min_commdate IN DATE) RETURN BOOLEAN
2715: IS
2716: /***************************************************************
2717: Created By : Jay Mathew

Line 2806: p_tariff_score IN OUT NOCOPY igs_he_ex_rn_dat_fd.value%TYPE)

2802: PROCEDURE limit_tariff_score(p_field_number IN NUMBER,
2803: p_person_number IN igs_pe_person.person_number%TYPE,
2804: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
2805: p_hesa_qual IN VARCHAR2,
2806: p_tariff_score IN OUT NOCOPY igs_he_ex_rn_dat_fd.value%TYPE)
2807: IS
2808: /***************************************************************
2809: Created By :
2810: Date Created By : 15-Mar-2005

Line 3749: l_value igs_he_ex_rn_dat_fd.value%TYPE;

3745: AND inv.fee_cal_type = cp_fee_cal_type
3746: AND inv.fee_ci_sequence_number = cp_fee_ci_sequence_number
3747: AND ft.s_fee_type = 'TUTNFEE';
3748:
3749: l_value igs_he_ex_rn_dat_fd.value%TYPE;
3750: l_slc_lea_cd igs_pe_alt_pers_id.api_person_id%TYPE;
3751: l_he_code_map_val igs_he_code_map_val%ROWTYPE;
3752: l_invoice_amt igs_fi_inv_int.invoice_amount%TYPE;
3753: l_tot_invoice_amt igs_fi_inv_int.invoice_amount%TYPE;

Line 6760: p_final_commdate OUT NOCOPY igs_he_ex_rn_dat_fd.value%TYPE)

6756: p_person_id IN igs_pe_person.person_id%TYPE ,
6757: p_course_cd IN igs_he_st_spa_all.course_cd%TYPE,
6758: p_version_number IN igs_he_st_spa_all.version_number%TYPE,
6759: p_student_inst_number IN igs_he_st_spa_all.student_inst_number%TYPE,
6760: p_final_commdate OUT NOCOPY igs_he_ex_rn_dat_fd.value%TYPE)
6761:
6762: IS
6763: /***************************************************************
6764: Created By : bayadav