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_POOUS

Line 702: p_poous_fund_src IN igs_he_poous.funding_source%TYPE,

698: PROCEDURE get_funding_src
699: (p_course_cd IN igs_ps_ver.course_cd%TYPE,
700: p_version_number IN igs_ps_ver.version_number%TYPE,
701: p_spa_fund_src IN igs_en_stdnt_ps_att.funding_source%TYPE,
702: p_poous_fund_src IN igs_he_poous.funding_source%TYPE,
703: p_oss_fund_src OUT NOCOPY VARCHAR2,
704: p_hesa_fund_src OUT NOCOPY VARCHAR2)
705:
706: IS

Line 817: p_poous_fund_cd IN igs_he_poous.fundability_cd%TYPE,

813: PROCEDURE get_fundability_cd
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,

Line 1696: p_poous_study_location IN igs_he_poous.location_of_study%TYPE,

1692:
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

Line 3474: p_poous_fee_band IN igs_he_poous.fee_band%TYPE,

3470:
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: /***************************************************************

Line 4037: p_poous_inst1 IN igs_he_poous.other_instit_teach1%TYPE,

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,
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,

Line 4040: p_poous_inst2 IN igs_he_poous.other_instit_teach1%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,
4043: p_hesa_inst2 OUT NOCOPY VARCHAR2,
4044: p_enrl_start_dt IN DATE,

Line 4154: p_poous_prop IN igs_he_poous.prop_not_taught%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)
4157:
4158: IS

Line 4317: p_poous_credit_level IN igs_he_poous.level_credit1%TYPE,

4313:
4314:
4315: PROCEDURE get_credit_level
4316: (p_susa_credit_level IN igs_he_en_susa.credit_level1%TYPE ,
4317: p_poous_credit_level IN igs_he_poous.level_credit1%TYPE,
4318: p_hesa_credit_level OUT NOCOPY VARCHAR2)
4319: IS
4320: /***************************************************************
4321: Created By :

Line 4508: p_unit_set_cd IN igs_he_poous.unit_set_cd%TYPE,

4504: PROCEDURE get_cost_centres
4505: (p_person_id IN igs_pe_person.person_id%TYPE,
4506: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
4507: p_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,
4508: p_unit_set_cd IN igs_he_poous.unit_set_cd%TYPE,
4509: p_us_version_number IN igs_he_poous.us_version_number%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,

Line 4509: p_us_version_number IN igs_he_poous.us_version_number%TYPE,

4505: (p_person_id IN igs_pe_person.person_id%TYPE,
4506: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
4507: p_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,
4508: p_unit_set_cd IN igs_he_poous.unit_set_cd%TYPE,
4509: p_us_version_number IN igs_he_poous.us_version_number%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,

Line 4510: p_cal_type IN igs_he_poous.cal_type%TYPE,

4506: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
4507: p_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,
4508: p_unit_set_cd IN igs_he_poous.unit_set_cd%TYPE,
4509: p_us_version_number IN igs_he_poous.us_version_number%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,

Line 4511: p_attendance_mode IN igs_he_poous.attendance_mode%TYPE,

4507: p_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,
4508: p_unit_set_cd IN igs_he_poous.unit_set_cd%TYPE,
4509: p_us_version_number IN igs_he_poous.us_version_number%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,

Line 4512: p_attendance_type IN igs_he_poous.attendance_type%TYPE,

4508: p_unit_set_cd IN igs_he_poous.unit_set_cd%TYPE,
4509: p_us_version_number IN igs_he_poous.us_version_number%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,

Line 4513: p_location_cd IN igs_he_poous.location_cd%TYPE,

4509: p_us_version_number IN igs_he_poous.us_version_number%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,

Line 4548: l_poous_cc igs_he_poous_ou_cc%ROWTYPE;

4544: l_sql_stmt VARCHAR2(2000);
4545: l_index NUMBER;
4546: l_total_prop NUMBER := 0;
4547: l_he_code_map_val igs_he_code_map_val%ROWTYPE := NULL;
4548: l_poous_cc igs_he_poous_ou_cc%ROWTYPE;
4549: l_max_recs NUMBER;
4550:
4551: TYPE cur_cc IS REF CURSOR;
4552: c_cc cur_cc;

Line 4555: CURSOR c_field_of_study(p_subject igs_he_poous_ou_cc.subject%TYPE) IS

4551: TYPE cur_cc IS REF CURSOR;
4552: c_cc cur_cc;
4553:
4554: --smaddali added this cursor for bug 2417454 to get the govt code for oss field of study
4555: CURSOR c_field_of_study(p_subject igs_he_poous_ou_cc.subject%TYPE) IS
4556: SELECT govt_field_of_study
4557: FROM IGS_PS_FLD_OF_STUDY PFS
4558: WHERE field_of_study = p_subject;
4559:

Line 4581: CURSOR poo_cc_dtls_cur( cp_course_cd IGS_HE_POOUS_OU_ALL.course_cd%TYPE,

4577: WHERE person_id = cp_person_id
4578: AND course_cd = cp_course_cd;
4579:
4580: -- Cost Centers at Program Offering Option Level
4581: CURSOR poo_cc_dtls_cur( cp_course_cd IGS_HE_POOUS_OU_ALL.course_cd%TYPE,
4582: cp_crv_version_number IGS_HE_POOUS_OU_ALL.crv_version_number%TYPE,
4583: cp_unit_set_cd IGS_HE_POOUS_OU_ALL.unit_set_cd%TYPE,
4584: cp_us_version_number IGS_HE_POOUS_OU_ALL.us_version_number%TYPE,
4585: cp_cal_type IGS_HE_POOUS_OU_ALL.cal_type%TYPE,

Line 4582: cp_crv_version_number IGS_HE_POOUS_OU_ALL.crv_version_number%TYPE,

4578: AND course_cd = cp_course_cd;
4579:
4580: -- Cost Centers at Program Offering Option Level
4581: CURSOR poo_cc_dtls_cur( cp_course_cd IGS_HE_POOUS_OU_ALL.course_cd%TYPE,
4582: cp_crv_version_number IGS_HE_POOUS_OU_ALL.crv_version_number%TYPE,
4583: cp_unit_set_cd IGS_HE_POOUS_OU_ALL.unit_set_cd%TYPE,
4584: cp_us_version_number IGS_HE_POOUS_OU_ALL.us_version_number%TYPE,
4585: cp_cal_type IGS_HE_POOUS_OU_ALL.cal_type%TYPE,
4586: cp_attendance_mode IGS_HE_POOUS_OU_ALL.attendance_mode%TYPE,

Line 4583: cp_unit_set_cd IGS_HE_POOUS_OU_ALL.unit_set_cd%TYPE,

4579:
4580: -- Cost Centers at Program Offering Option Level
4581: CURSOR poo_cc_dtls_cur( cp_course_cd IGS_HE_POOUS_OU_ALL.course_cd%TYPE,
4582: cp_crv_version_number IGS_HE_POOUS_OU_ALL.crv_version_number%TYPE,
4583: cp_unit_set_cd IGS_HE_POOUS_OU_ALL.unit_set_cd%TYPE,
4584: cp_us_version_number IGS_HE_POOUS_OU_ALL.us_version_number%TYPE,
4585: cp_cal_type IGS_HE_POOUS_OU_ALL.cal_type%TYPE,
4586: cp_attendance_mode IGS_HE_POOUS_OU_ALL.attendance_mode%TYPE,
4587: cp_attendance_type IGS_HE_POOUS_OU_ALL.attendance_type%TYPE,

Line 4584: cp_us_version_number IGS_HE_POOUS_OU_ALL.us_version_number%TYPE,

4580: -- Cost Centers at Program Offering Option Level
4581: CURSOR poo_cc_dtls_cur( cp_course_cd IGS_HE_POOUS_OU_ALL.course_cd%TYPE,
4582: cp_crv_version_number IGS_HE_POOUS_OU_ALL.crv_version_number%TYPE,
4583: cp_unit_set_cd IGS_HE_POOUS_OU_ALL.unit_set_cd%TYPE,
4584: cp_us_version_number IGS_HE_POOUS_OU_ALL.us_version_number%TYPE,
4585: cp_cal_type IGS_HE_POOUS_OU_ALL.cal_type%TYPE,
4586: cp_attendance_mode IGS_HE_POOUS_OU_ALL.attendance_mode%TYPE,
4587: cp_attendance_type IGS_HE_POOUS_OU_ALL.attendance_type%TYPE,
4588: cp_location_cd IGS_HE_POOUS_OU_ALL.location_cd%TYPE ) IS

Line 4585: cp_cal_type IGS_HE_POOUS_OU_ALL.cal_type%TYPE,

4581: CURSOR poo_cc_dtls_cur( cp_course_cd IGS_HE_POOUS_OU_ALL.course_cd%TYPE,
4582: cp_crv_version_number IGS_HE_POOUS_OU_ALL.crv_version_number%TYPE,
4583: cp_unit_set_cd IGS_HE_POOUS_OU_ALL.unit_set_cd%TYPE,
4584: cp_us_version_number IGS_HE_POOUS_OU_ALL.us_version_number%TYPE,
4585: cp_cal_type IGS_HE_POOUS_OU_ALL.cal_type%TYPE,
4586: cp_attendance_mode IGS_HE_POOUS_OU_ALL.attendance_mode%TYPE,
4587: cp_attendance_type IGS_HE_POOUS_OU_ALL.attendance_type%TYPE,
4588: cp_location_cd IGS_HE_POOUS_OU_ALL.location_cd%TYPE ) IS
4589: SELECT 'X'

Line 4586: cp_attendance_mode IGS_HE_POOUS_OU_ALL.attendance_mode%TYPE,

4582: cp_crv_version_number IGS_HE_POOUS_OU_ALL.crv_version_number%TYPE,
4583: cp_unit_set_cd IGS_HE_POOUS_OU_ALL.unit_set_cd%TYPE,
4584: cp_us_version_number IGS_HE_POOUS_OU_ALL.us_version_number%TYPE,
4585: cp_cal_type IGS_HE_POOUS_OU_ALL.cal_type%TYPE,
4586: cp_attendance_mode IGS_HE_POOUS_OU_ALL.attendance_mode%TYPE,
4587: cp_attendance_type IGS_HE_POOUS_OU_ALL.attendance_type%TYPE,
4588: cp_location_cd IGS_HE_POOUS_OU_ALL.location_cd%TYPE ) IS
4589: SELECT 'X'
4590: FROM IGS_HE_POOUS_OU_CC pocc,

Line 4587: cp_attendance_type IGS_HE_POOUS_OU_ALL.attendance_type%TYPE,

4583: cp_unit_set_cd IGS_HE_POOUS_OU_ALL.unit_set_cd%TYPE,
4584: cp_us_version_number IGS_HE_POOUS_OU_ALL.us_version_number%TYPE,
4585: cp_cal_type IGS_HE_POOUS_OU_ALL.cal_type%TYPE,
4586: cp_attendance_mode IGS_HE_POOUS_OU_ALL.attendance_mode%TYPE,
4587: cp_attendance_type IGS_HE_POOUS_OU_ALL.attendance_type%TYPE,
4588: cp_location_cd IGS_HE_POOUS_OU_ALL.location_cd%TYPE ) IS
4589: SELECT 'X'
4590: FROM IGS_HE_POOUS_OU_CC pocc,
4591: IGS_HE_POOUS_OU_ALL poou

Line 4588: cp_location_cd IGS_HE_POOUS_OU_ALL.location_cd%TYPE ) IS

4584: cp_us_version_number IGS_HE_POOUS_OU_ALL.us_version_number%TYPE,
4585: cp_cal_type IGS_HE_POOUS_OU_ALL.cal_type%TYPE,
4586: cp_attendance_mode IGS_HE_POOUS_OU_ALL.attendance_mode%TYPE,
4587: cp_attendance_type IGS_HE_POOUS_OU_ALL.attendance_type%TYPE,
4588: cp_location_cd IGS_HE_POOUS_OU_ALL.location_cd%TYPE ) IS
4589: SELECT 'X'
4590: FROM IGS_HE_POOUS_OU_CC pocc,
4591: IGS_HE_POOUS_OU_ALL poou
4592: WHERE poou.hesa_poous_ou_id = pocc.hesa_poous_ou_id

Line 4590: FROM IGS_HE_POOUS_OU_CC pocc,

4586: cp_attendance_mode IGS_HE_POOUS_OU_ALL.attendance_mode%TYPE,
4587: cp_attendance_type IGS_HE_POOUS_OU_ALL.attendance_type%TYPE,
4588: cp_location_cd IGS_HE_POOUS_OU_ALL.location_cd%TYPE ) IS
4589: SELECT 'X'
4590: FROM IGS_HE_POOUS_OU_CC pocc,
4591: IGS_HE_POOUS_OU_ALL poou
4592: WHERE poou.hesa_poous_ou_id = pocc.hesa_poous_ou_id
4593: AND poou.course_cd = cp_course_cd
4594: AND poou.crv_version_number = cp_crv_version_number

Line 4591: IGS_HE_POOUS_OU_ALL poou

4587: cp_attendance_type IGS_HE_POOUS_OU_ALL.attendance_type%TYPE,
4588: cp_location_cd IGS_HE_POOUS_OU_ALL.location_cd%TYPE ) IS
4589: SELECT 'X'
4590: FROM IGS_HE_POOUS_OU_CC pocc,
4591: IGS_HE_POOUS_OU_ALL poou
4592: WHERE poou.hesa_poous_ou_id = pocc.hesa_poous_ou_id
4593: AND poou.course_cd = cp_course_cd
4594: AND poou.crv_version_number = cp_crv_version_number
4595: AND poou.unit_set_cd = cp_unit_set_cd

Line 4607: igs_he_poous_ou_all poo

4603: CURSOR poo_org_cc_dtls_cur IS
4604: SELECT 'X'
4605: FROM
4606: igs_he_ou_cc org,
4607: igs_he_poous_ou_all poo
4608: WHERE
4609: org.org_unit_cd = poo.organization_unit
4610: AND poo.course_cd = p_course_cd
4611: AND poo.crv_version_number = p_version_number

Line 4764: FROM igs_he_poous_ou_cc pocc,

4760: CLOSE poo_cc_dtls_cur;
4761:
4762: OPEN c_cc FOR
4763: SELECT cost_centre, subject, SUM (pocc.proportion*NVL(poou.proportion,0)/100) proportion
4764: FROM igs_he_poous_ou_cc pocc,
4765: igs_he_poous_ou_all poou
4766: WHERE poou.hesa_poous_ou_id = pocc.hesa_poous_ou_id
4767: AND poou.course_cd = p_course_cd
4768: AND poou.crv_version_number = p_version_number

Line 4765: igs_he_poous_ou_all poou

4761:
4762: OPEN c_cc FOR
4763: SELECT cost_centre, subject, SUM (pocc.proportion*NVL(poou.proportion,0)/100) proportion
4764: FROM igs_he_poous_ou_cc pocc,
4765: igs_he_poous_ou_all poou
4766: WHERE poou.hesa_poous_ou_id = pocc.hesa_poous_ou_id
4767: AND poou.course_cd = p_course_cd
4768: AND poou.crv_version_number = p_version_number
4769: AND poou.unit_set_cd = p_unit_set_cd

Line 4794: igs_he_poous_ou_all poo

4790: SELECT org.cost_centre,
4791: org.subject,
4792: SUM((NVL(poo.proportion,0) * org.proportion / 100)) proportion
4793: FROM igs_he_ou_cc org,
4794: igs_he_poous_ou_all poo
4795: WHERE org.org_unit_cd = poo.organization_unit
4796: AND poo.course_cd = p_course_cd
4797: AND poo.crv_version_number = p_version_number
4798: AND poo.unit_set_cd = p_unit_set_cd

Line 5170: (p_oss_pyr_type IN igs_he_poous.type_of_year%TYPE,

5166: END get_studies_susp;
5167:
5168:
5169: PROCEDURE get_pyr_type
5170: (p_oss_pyr_type IN igs_he_poous.type_of_year%TYPE,
5171: p_hesa_pyr_type OUT NOCOPY VARCHAR2)
5172: IS
5173: /***************************************************************
5174: Created By :

Line 5209: (p_poous_lvl_appl_fund IN igs_he_poous.level_applicable_to_funding%TYPE,

5205: END get_pyr_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: /***************************************************************

Line 5631: p_poous_franch_activity IN igs_he_poous.franchising_activity%TYPE,

5627:
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: /***************************************************************

Line 6323: p_poous_study_mode IN igs_he_poous.attendance_mode%TYPE,

6319: p_version_number IN igs_he_st_spa.version_number%TYPE,
6320: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
6321: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
6322: p_susa_study_mode IN igs_he_en_susa.study_mode%TYPE,
6323: p_poous_study_mode IN igs_he_poous.attendance_mode%TYPE,
6324: p_attendance_type IN igs_en_stdnt_ps_att.attendance_type%TYPE,
6325: p_mode_of_study OUT NOCOPY VARCHAR2)
6326:
6327: IS