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_ST_PROG

Line 634: p_fe_program_marker IN igs_he_st_prog.fe_program_marker%TYPE,

630:
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)

Line 818: p_prg_fund_cd IN igs_he_st_prog.fundability%TYPE,

814: (p_person_id IN igs_pe_person.person_id%TYPE,
815: p_susa_fund_cd IN igs_he_en_susa.fundability_code%TYPE,
816: p_spa_funding_source IN igs_en_stdnt_ps_att.funding_source%TYPE,
817: p_poous_fund_cd IN igs_he_poous.fundability_cd%TYPE,
818: p_prg_fund_cd IN igs_he_st_prog.fundability%TYPE,
819: p_prg_funding_source IN igs_fi_fnd_src_rstn.funding_source%TYPE,
820: p_oss_fund_cd OUT NOCOPY VARCHAR2,
821: p_hesa_fund_cd OUT NOCOPY VARCHAR2,
822: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,

Line 1697: p_prg_study_location IN igs_he_st_prog.location_of_study%TYPE,

1693:
1694: PROCEDURE get_study_location
1695: (p_susa_study_location IN igs_he_en_susa.study_location%TYPE,
1696: p_poous_study_location IN igs_he_poous.location_of_study%TYPE,
1697: p_prg_study_location IN igs_he_st_prog.location_of_study%TYPE,
1698: p_oss_study_location OUT NOCOPY VARCHAR2,
1699: p_hesa_study_location OUT NOCOPY VARCHAR2)
1700: IS
1701: /***************************************************************

Line 3117: (p_prg_ttcid IN igs_he_st_prog.teacher_train_prog_id%TYPE,

3113: App_Exception.Raise_Exception;
3114: END get_prog_length;
3115:
3116: PROCEDURE get_teach_train_crs_id
3117: (p_prg_ttcid IN igs_he_st_prog.teacher_train_prog_id%TYPE,
3118: p_spa_ttcid IN igs_he_st_spa.teacher_train_prog_id%TYPE,
3119: p_hesa_ttcid OUT NOCOPY VARCHAR2)
3120: IS
3121: /***************************************************************

Line 3157: (p_prg_itt_phsc IN igs_he_st_prog.itt_phase%TYPE,

3153: END get_teach_train_crs_id;
3154:
3155:
3156: PROCEDURE get_itt_phsc
3157: (p_prg_itt_phsc IN igs_he_st_prog.itt_phase%TYPE,
3158: p_spa_itt_phsc IN igs_he_st_spa.itt_phase%TYPE,
3159: p_hesa_itt_phsc OUT NOCOPY VARCHAR2)
3160: IS
3161: /***************************************************************

Line 3197: (p_prg_itt_mrker IN igs_he_st_prog.bilingual_itt_marker%TYPE,

3193: END get_itt_phsc;
3194:
3195:
3196: PROCEDURE get_itt_mrker
3197: (p_prg_itt_mrker IN igs_he_st_prog.bilingual_itt_marker%TYPE,
3198: p_spa_itt_mrker IN igs_he_st_spa.bilingual_itt_marker%TYPE,
3199: p_hesa_itt_mrker OUT NOCOPY VARCHAR2)
3200: IS
3201: /***************************************************************

Line 3238: (p_oss_teach_qual_sect IN igs_he_st_prog.teaching_qual_sought_sector%TYPE,

3234:
3235:
3236:
3237: PROCEDURE get_teach_qual_sect
3238: (p_oss_teach_qual_sect IN igs_he_st_prog.teaching_qual_sought_sector%TYPE,
3239: p_hesa_teach_qual_sect OUT NOCOPY VARCHAR2)
3240: IS
3241: /***************************************************************
3242: Created By :

Line 3278: (p_oss_teach_qual_sbj IN igs_he_st_prog.teaching_qual_sought_subj1%TYPE,

3274:
3275:
3276:
3277: PROCEDURE get_teach_qual_sbj
3278: (p_oss_teach_qual_sbj IN igs_he_st_prog.teaching_qual_sought_subj1%TYPE,
3279: p_hesa_teach_qual_sbj OUT NOCOPY VARCHAR2)
3280: IS
3281: /***************************************************************
3282: Created By :

Line 3475: p_prg_fee_band IN igs_he_st_prog.fee_band%TYPE,

3471: PROCEDURE get_fee_band
3472: (p_hesa_fee_elig IN igs_he_en_susa.fee_eligibility%TYPE,
3473: p_susa_fee_band IN igs_he_en_susa.fee_band%TYPE,
3474: p_poous_fee_band IN igs_he_poous.fee_band%TYPE,
3475: p_prg_fee_band IN igs_he_st_prog.fee_band%TYPE,
3476: p_hesa_fee_band OUT NOCOPY VARCHAR2)
3477: IS
3478: /***************************************************************
3479: Created By :

Line 3529: p_fe_prg_mrker IN igs_he_st_prog.fe_program_marker%TYPE,

3525: PROCEDURE get_amt_tuition_fees
3526: (p_person_id IN igs_pe_person.person_id%TYPE,
3527: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
3528: p_cal_type IN igs_en_stdnt_ps_att.cal_type%TYPE,
3529: p_fe_prg_mrker IN igs_he_st_prog.fe_program_marker%TYPE,
3530: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
3531: p_oss_amt OUT NOCOPY NUMBER,
3532: p_hesa_amt OUT NOCOPY VARCHAR2,
3533: p_enrl_start_dt IN DATE,

Line 4035: p_program_calc IN igs_he_st_prog.program_calc%TYPE,

4031:
4032: PROCEDURE get_oth_teach_inst
4033: (p_person_id IN igs_pe_person.person_id%TYPE,
4034: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
4035: p_program_calc IN igs_he_st_prog.program_calc%TYPE,
4036: p_susa_inst1 IN igs_he_en_susa.teaching_inst1%TYPE,
4037: p_poous_inst1 IN igs_he_poous.other_instit_teach1%TYPE,
4038: p_prog_inst1 IN igs_he_st_prog.other_inst_prov_teaching1%TYPE,
4039: p_susa_inst2 IN igs_he_en_susa.teaching_inst1%TYPE,

Line 4038: p_prog_inst1 IN igs_he_st_prog.other_inst_prov_teaching1%TYPE,

4034: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
4035: p_program_calc IN igs_he_st_prog.program_calc%TYPE,
4036: p_susa_inst1 IN igs_he_en_susa.teaching_inst1%TYPE,
4037: p_poous_inst1 IN igs_he_poous.other_instit_teach1%TYPE,
4038: p_prog_inst1 IN igs_he_st_prog.other_inst_prov_teaching1%TYPE,
4039: p_susa_inst2 IN igs_he_en_susa.teaching_inst1%TYPE,
4040: p_poous_inst2 IN igs_he_poous.other_instit_teach1%TYPE,
4041: p_prog_inst2 IN igs_he_st_prog.other_inst_prov_teaching1%TYPE,
4042: p_hesa_inst1 OUT NOCOPY VARCHAR2,

Line 4041: p_prog_inst2 IN igs_he_st_prog.other_inst_prov_teaching1%TYPE,

4037: p_poous_inst1 IN igs_he_poous.other_instit_teach1%TYPE,
4038: p_prog_inst1 IN igs_he_st_prog.other_inst_prov_teaching1%TYPE,
4039: p_susa_inst2 IN igs_he_en_susa.teaching_inst1%TYPE,
4040: p_poous_inst2 IN igs_he_poous.other_instit_teach1%TYPE,
4041: p_prog_inst2 IN igs_he_st_prog.other_inst_prov_teaching1%TYPE,
4042: p_hesa_inst1 OUT NOCOPY VARCHAR2,
4043: p_hesa_inst2 OUT NOCOPY VARCHAR2,
4044: p_enrl_start_dt IN DATE,
4045: p_enrl_end_dt IN DATE)

Line 4152: p_program_calc IN igs_he_st_prog.program_calc%TYPE,

4148: (p_person_id IN igs_pe_person.person_id%TYPE,
4149: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
4150: p_enrl_start_dt IN DATE,
4151: p_enrl_end_dt IN DATE,
4152: p_program_calc IN igs_he_st_prog.program_calc%TYPE,
4153: p_susa_prop IN igs_he_en_susa.pro_not_taught%TYPE,
4154: p_poous_prop IN igs_he_poous.prop_not_taught%TYPE,
4155: p_prog_prop IN igs_he_st_prog.prop_not_taught%TYPE,
4156: p_hesa_prop OUT NOCOPY VARCHAR2)

Line 4155: p_prog_prop IN igs_he_st_prog.prop_not_taught%TYPE,

4151: p_enrl_end_dt IN DATE,
4152: p_program_calc IN igs_he_st_prog.program_calc%TYPE,
4153: p_susa_prop IN igs_he_en_susa.pro_not_taught%TYPE,
4154: p_poous_prop IN igs_he_poous.prop_not_taught%TYPE,
4155: p_prog_prop IN igs_he_st_prog.prop_not_taught%TYPE,
4156: p_hesa_prop OUT NOCOPY VARCHAR2)
4157:
4158: IS
4159: /***************************************************************

Line 4273: (p_oss_credit_trans_sch IN igs_he_st_prog.credit_transfer_scheme%TYPE,

4269:
4270:
4271:
4272: PROCEDURE get_credit_trans_sch
4273: (p_oss_credit_trans_sch IN igs_he_st_prog.credit_transfer_scheme%TYPE,
4274: p_hesa_credit_trans_sch OUT NOCOPY VARCHAR2)
4275: IS
4276: /***************************************************************
4277: Created By :

Line 4359: p_prog_calc IN igs_he_st_prog.program_calc%TYPE,

4355:
4356: PROCEDURE get_credit_obtained
4357: (p_person_id IN igs_pe_person.person_id%TYPE,
4358: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
4359: p_prog_calc IN igs_he_st_prog.program_calc%TYPE,
4360: p_susa_crd_pt1 IN igs_he_en_susa.credit_pt_achieved1%TYPE,
4361: p_susa_crd_pt2 IN igs_he_en_susa.credit_pt_achieved2%TYPE,
4362: p_susa_crd_pt3 IN igs_he_en_susa.credit_pt_achieved3%TYPE,
4363: p_susa_crd_pt4 IN igs_he_en_susa.credit_pt_achieved4%TYPE,

Line 4514: p_program_calc IN igs_he_st_prog.program_calc%TYPE,

4510: p_cal_type IN igs_he_poous.cal_type%TYPE,
4511: p_attendance_mode IN igs_he_poous.attendance_mode%TYPE,
4512: p_attendance_type IN igs_he_poous.attendance_type%TYPE,
4513: p_location_cd IN igs_he_poous.location_cd%TYPE,
4514: p_program_calc IN igs_he_st_prog.program_calc%TYPE,
4515: p_unit_cd IN igs_he_st_unt_vs.unit_cd%TYPE,
4516: p_uv_version_number IN igs_he_st_unt_vs.version_number%TYPE,
4517: p_return_type IN VARCHAR2,
4518: p_cost_ctr_rec IN OUT NOCOPY cc_rec,

Line 5210: p_prg_lvl_appl_fund IN igs_he_st_prog.level_applicable_to_funding%TYPE,

5206:
5207:
5208: PROCEDURE get_lvl_appl_to_fund
5209: (p_poous_lvl_appl_fund IN igs_he_poous.level_applicable_to_funding%TYPE,
5210: p_prg_lvl_appl_fund IN igs_he_st_prog.level_applicable_to_funding%TYPE,
5211: p_hesa_lvl_appl_fund OUT NOCOPY VARCHAR2)
5212: IS
5213: /***************************************************************
5214: Created By :

Line 5632: p_prog_franch_activity IN igs_he_st_prog.franchising_activity%TYPE,

5628:
5629: PROCEDURE get_franchising_activity
5630: (p_susa_franch_activity IN igs_he_en_susa.franchising_activity%TYPE,
5631: p_poous_franch_activity IN igs_he_poous.franchising_activity%TYPE,
5632: p_prog_franch_activity IN igs_he_st_prog.franchising_activity%TYPE,
5633: p_hesa_franch_activity OUT NOCOPY VARCHAR2)
5634: IS
5635: /***************************************************************
5636: Created By :

Line 7472: p_prog_gov_initiatives_cd IN igs_he_st_prog.gov_initiatives_cd%TYPE,

7468:
7469:
7470: PROCEDURE get_gov_init
7471: (p_spa_gov_initiatives_cd IN igs_he_st_spa.gov_initiatives_cd%TYPE,
7472: p_prog_gov_initiatives_cd IN igs_he_st_prog.gov_initiatives_cd%TYPE,
7473: p_hesa_gov_initiatives_cd OUT NOCOPY VARCHAR2)
7474: IS
7475: /***************************************************************
7476: Created By : Jonathan Baber

Line 7589: p_prog_disadv_uplift_elig_cd IN igs_he_st_prog.disadv_uplift_elig_cd%TYPE,

7585: END get_units_completed;
7586:
7587: PROCEDURE get_disadv_uplift_elig
7588: (p_spa_disadv_uplift_elig_cd IN igs_he_st_spa.disadv_uplift_elig_cd%TYPE,
7589: p_prog_disadv_uplift_elig_cd IN igs_he_st_prog.disadv_uplift_elig_cd%TYPE,
7590: p_hesa_disadv_uplift_elig_cd OUT NOCOPY VARCHAR2)
7591: IS
7592: /***************************************************************
7593: Created By : Jonathan Baber

Line 7628: p_prog_franch_out_arr_cd IN igs_he_st_prog.franch_out_arr_cd%TYPE,

7624: END get_disadv_uplift_elig;
7625:
7626: PROCEDURE get_franch_out_arr
7627: (p_spa_franch_out_arr_cd IN igs_he_st_spa.franch_out_arr_cd%TYPE,
7628: p_prog_franch_out_arr_cd IN igs_he_st_prog.franch_out_arr_cd%TYPE,
7629: p_hesa_franch_out_arr_cd OUT NOCOPY VARCHAR2)
7630: IS
7631: /***************************************************************
7632: Created By : Jonathan Baber