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 5: TYPE cc IS TABLE of igs_he_poous_ou_cc.cost_centre%TYPE

1: PACKAGE IGS_HE_EXTRACT_FIELDS_PKG AS
2: /* $Header: IGSHE9CS.pls 120.5 2006/09/15 01:48:52 jtmathew noship $ */
3:
4: -- Structure to hold Cost Centre details
5: TYPE cc IS TABLE of igs_he_poous_ou_cc.cost_centre%TYPE
6: INDEX BY binary_integer;
7: TYPE subj IS TABLE of igs_he_poous_ou_cc.subject%TYPE
8: INDEX BY binary_integer;
9: TYPE prop IS TABLE of igs_he_poous_ou_cc.proportion%TYPE

Line 7: TYPE subj IS TABLE of igs_he_poous_ou_cc.subject%TYPE

3:
4: -- Structure to hold Cost Centre details
5: TYPE cc IS TABLE of igs_he_poous_ou_cc.cost_centre%TYPE
6: INDEX BY binary_integer;
7: TYPE subj IS TABLE of igs_he_poous_ou_cc.subject%TYPE
8: INDEX BY binary_integer;
9: TYPE prop IS TABLE of igs_he_poous_ou_cc.proportion%TYPE
10: INDEX BY binary_integer;
11:

Line 9: TYPE prop IS TABLE of igs_he_poous_ou_cc.proportion%TYPE

5: TYPE cc IS TABLE of igs_he_poous_ou_cc.cost_centre%TYPE
6: INDEX BY binary_integer;
7: TYPE subj IS TABLE of igs_he_poous_ou_cc.subject%TYPE
8: INDEX BY binary_integer;
9: TYPE prop IS TABLE of igs_he_poous_ou_cc.proportion%TYPE
10: INDEX BY binary_integer;
11:
12: TYPE cc_rec IS RECORD
13: (cost_centre cc,

Line 76: p_poous_fund_src IN igs_he_poous.funding_source%TYPE,

72: PROCEDURE get_funding_src
73: (p_course_cd IN igs_ps_ver.course_cd%TYPE,
74: p_version_number IN igs_ps_ver.version_number%TYPE,
75: p_spa_fund_src IN igs_en_stdnt_ps_att.funding_source%TYPE,
76: p_poous_fund_src IN igs_he_poous.funding_source%TYPE,
77: p_oss_fund_src OUT NOCOPY VARCHAR2,
78: p_hesa_fund_src OUT NOCOPY VARCHAR2);
79:
80: -- smaddali 11-dec-03 Modified for bug#3235753 , added 2 new parameters

Line 85: p_poous_fund_cd IN igs_he_poous.fundability_cd%TYPE,

81: PROCEDURE get_fundability_cd
82: (p_person_id IN igs_pe_person.person_id%TYPE,
83: p_susa_fund_cd IN igs_he_en_susa.fundability_code%TYPE,
84: p_spa_funding_source IN igs_en_stdnt_ps_att.funding_source%TYPE,
85: p_poous_fund_cd IN igs_he_poous.fundability_cd%TYPE,
86: p_prg_fund_cd IN igs_he_st_prog.fundability%TYPE,
87: p_prg_funding_source IN igs_fi_fnd_src_rstn.funding_source%TYPE,
88: p_oss_fund_cd OUT NOCOPY VARCHAR2,
89: p_hesa_fund_cd OUT NOCOPY VARCHAR2,

Line 174: p_poous_study_location IN igs_he_poous.location_of_study%TYPE,

170:
171:
172: PROCEDURE get_study_location
173: (p_susa_study_location IN igs_he_en_susa.study_location%TYPE,
174: p_poous_study_location IN igs_he_poous.location_of_study%TYPE,
175: p_prg_study_location IN igs_he_st_prog.location_of_study%TYPE,
176: p_oss_study_location OUT NOCOPY VARCHAR2,
177: p_hesa_study_location OUT NOCOPY VARCHAR2);
178:

Line 331: p_poous_fee_band IN igs_he_poous.fee_band%TYPE,

327:
328: PROCEDURE get_fee_band
329: (p_hesa_fee_elig IN igs_he_en_susa.fee_eligibility%TYPE,
330: p_susa_fee_band IN igs_he_en_susa.fee_band%TYPE,
331: p_poous_fee_band IN igs_he_poous.fee_band%TYPE,
332: p_prg_fee_band IN igs_he_st_prog.fee_band%TYPE,
333: p_hesa_fee_band OUT NOCOPY VARCHAR2);
334:
335: -- smaddali 13-oct-03 modified procedure to add 2 new parameters for bug# 3179544

Line 380: p_poous_inst1 IN igs_he_poous.other_instit_teach1%TYPE,

376: (p_person_id IN igs_pe_person.person_id%TYPE,
377: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
378: p_program_calc IN igs_he_st_prog.program_calc%TYPE,
379: p_susa_inst1 IN igs_he_en_susa.teaching_inst1%TYPE,
380: p_poous_inst1 IN igs_he_poous.other_instit_teach1%TYPE,
381: p_prog_inst1 IN igs_he_st_prog.other_inst_prov_teaching1%TYPE,
382: p_susa_inst2 IN igs_he_en_susa.teaching_inst1%TYPE,
383: p_poous_inst2 IN igs_he_poous.other_instit_teach1%TYPE,
384: p_prog_inst2 IN igs_he_st_prog.other_inst_prov_teaching1%TYPE,

Line 383: p_poous_inst2 IN igs_he_poous.other_instit_teach1%TYPE,

379: p_susa_inst1 IN igs_he_en_susa.teaching_inst1%TYPE,
380: p_poous_inst1 IN igs_he_poous.other_instit_teach1%TYPE,
381: p_prog_inst1 IN igs_he_st_prog.other_inst_prov_teaching1%TYPE,
382: p_susa_inst2 IN igs_he_en_susa.teaching_inst1%TYPE,
383: p_poous_inst2 IN igs_he_poous.other_instit_teach1%TYPE,
384: p_prog_inst2 IN igs_he_st_prog.other_inst_prov_teaching1%TYPE,
385: p_hesa_inst1 OUT NOCOPY VARCHAR2,
386: p_hesa_inst2 OUT NOCOPY VARCHAR2,
387: p_enrl_start_dt IN DATE,

Line 398: p_poous_prop IN igs_he_poous.prop_not_taught%TYPE,

394: p_enrl_start_dt IN DATE,
395: p_enrl_end_dt IN DATE,
396: p_program_calc IN igs_he_st_prog.program_calc%TYPE,
397: p_susa_prop IN igs_he_en_susa.pro_not_taught%TYPE,
398: p_poous_prop IN igs_he_poous.prop_not_taught%TYPE,
399: p_prog_prop IN igs_he_st_prog.prop_not_taught%TYPE,
400: p_hesa_prop OUT NOCOPY VARCHAR2);
401:
402: PROCEDURE get_credit_trans_sch

Line 408: p_poous_credit_level IN igs_he_poous.level_credit1%TYPE,

404: p_hesa_credit_trans_sch OUT NOCOPY VARCHAR2);
405: --smaddali added new parameter p_susa_credit_level for bug 2415879
406: PROCEDURE get_credit_level
407: (p_susa_credit_level IN igs_he_en_susa.credit_level1%TYPE ,
408: p_poous_credit_level IN igs_he_poous.level_credit1%TYPE,
409: p_hesa_credit_level OUT NOCOPY VARCHAR2);
410:
411: -- jbaber added crd_pt3-4, lvl_crd_pt3-4 for HEFD350
412: PROCEDURE get_credit_obtained

Line 440: p_unit_set_cd IN igs_he_poous.unit_set_cd%TYPE,

436: PROCEDURE get_cost_centres
437: (p_person_id IN igs_pe_person.person_id%TYPE,
438: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
439: p_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,
440: p_unit_set_cd IN igs_he_poous.unit_set_cd%TYPE,
441: p_us_version_number IN igs_he_poous.us_version_number%TYPE,
442: p_cal_type IN igs_he_poous.cal_type%TYPE,
443: p_attendance_mode IN igs_he_poous.attendance_mode%TYPE,
444: p_attendance_type IN igs_he_poous.attendance_type%TYPE,

Line 441: p_us_version_number IN igs_he_poous.us_version_number%TYPE,

437: (p_person_id IN igs_pe_person.person_id%TYPE,
438: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
439: p_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,
440: p_unit_set_cd IN igs_he_poous.unit_set_cd%TYPE,
441: p_us_version_number IN igs_he_poous.us_version_number%TYPE,
442: p_cal_type IN igs_he_poous.cal_type%TYPE,
443: p_attendance_mode IN igs_he_poous.attendance_mode%TYPE,
444: p_attendance_type IN igs_he_poous.attendance_type%TYPE,
445: p_location_cd IN igs_he_poous.location_cd%TYPE,

Line 442: p_cal_type IN igs_he_poous.cal_type%TYPE,

438: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
439: p_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,
440: p_unit_set_cd IN igs_he_poous.unit_set_cd%TYPE,
441: p_us_version_number IN igs_he_poous.us_version_number%TYPE,
442: p_cal_type IN igs_he_poous.cal_type%TYPE,
443: p_attendance_mode IN igs_he_poous.attendance_mode%TYPE,
444: p_attendance_type IN igs_he_poous.attendance_type%TYPE,
445: p_location_cd IN igs_he_poous.location_cd%TYPE,
446: p_program_calc IN igs_he_st_prog.program_calc%TYPE,

Line 443: p_attendance_mode IN igs_he_poous.attendance_mode%TYPE,

439: p_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,
440: p_unit_set_cd IN igs_he_poous.unit_set_cd%TYPE,
441: p_us_version_number IN igs_he_poous.us_version_number%TYPE,
442: p_cal_type IN igs_he_poous.cal_type%TYPE,
443: p_attendance_mode IN igs_he_poous.attendance_mode%TYPE,
444: p_attendance_type IN igs_he_poous.attendance_type%TYPE,
445: p_location_cd IN igs_he_poous.location_cd%TYPE,
446: p_program_calc IN igs_he_st_prog.program_calc%TYPE,
447: p_unit_cd IN igs_he_st_unt_vs.unit_cd%TYPE,

Line 444: p_attendance_type IN igs_he_poous.attendance_type%TYPE,

440: p_unit_set_cd IN igs_he_poous.unit_set_cd%TYPE,
441: p_us_version_number IN igs_he_poous.us_version_number%TYPE,
442: p_cal_type IN igs_he_poous.cal_type%TYPE,
443: p_attendance_mode IN igs_he_poous.attendance_mode%TYPE,
444: p_attendance_type IN igs_he_poous.attendance_type%TYPE,
445: p_location_cd IN igs_he_poous.location_cd%TYPE,
446: p_program_calc IN igs_he_st_prog.program_calc%TYPE,
447: p_unit_cd IN igs_he_st_unt_vs.unit_cd%TYPE,
448: p_uv_version_number IN igs_he_st_unt_vs.version_number%TYPE,

Line 445: p_location_cd IN igs_he_poous.location_cd%TYPE,

441: p_us_version_number IN igs_he_poous.us_version_number%TYPE,
442: p_cal_type IN igs_he_poous.cal_type%TYPE,
443: p_attendance_mode IN igs_he_poous.attendance_mode%TYPE,
444: p_attendance_type IN igs_he_poous.attendance_type%TYPE,
445: p_location_cd IN igs_he_poous.location_cd%TYPE,
446: p_program_calc IN igs_he_st_prog.program_calc%TYPE,
447: p_unit_cd IN igs_he_st_unt_vs.unit_cd%TYPE,
448: p_uv_version_number IN igs_he_st_unt_vs.version_number%TYPE,
449: p_return_type IN VARCHAR2,

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

463: p_enrl_end_dt IN DATE,
464: p_susp_act_std OUT NOCOPY VARCHAR2);
465:
466: PROCEDURE get_pyr_type
467: (p_oss_pyr_type IN igs_he_poous.type_of_year%TYPE,
468: p_hesa_pyr_type OUT NOCOPY VARCHAR2);
469:
470: PROCEDURE get_lvl_appl_to_fund
471: (p_poous_lvl_appl_fund IN igs_he_poous.level_applicable_to_funding%TYPE,

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

467: (p_oss_pyr_type IN igs_he_poous.type_of_year%TYPE,
468: p_hesa_pyr_type OUT NOCOPY VARCHAR2);
469:
470: PROCEDURE get_lvl_appl_to_fund
471: (p_poous_lvl_appl_fund IN igs_he_poous.level_applicable_to_funding%TYPE,
472: p_prg_lvl_appl_fund IN igs_he_st_prog.level_applicable_to_funding%TYPE,
473: p_hesa_lvl_appl_fund OUT NOCOPY VARCHAR2);
474:
475: PROCEDURE get_comp_pyr_study(

Line 507: p_poous_franch_activity IN igs_he_poous.franchising_activity%TYPE,

503: p_hesa_ufi_place OUT NOCOPY VARCHAR2);
504:
505: PROCEDURE get_franchising_activity
506: (p_susa_franch_activity IN igs_he_en_susa.franchising_activity%TYPE,
507: p_poous_franch_activity IN igs_he_poous.franchising_activity%TYPE,
508: p_prog_franch_activity IN igs_he_st_prog.franchising_activity%TYPE,
509: p_hesa_franch_activity OUT NOCOPY VARCHAR2);
510:
511: PROCEDURE get_social_class_ind

Line 569: p_poous_study_mode IN igs_he_poous.attendance_mode%TYPE,

565: p_version_number IN igs_he_st_spa.version_number%TYPE,
566: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
567: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
568: p_susa_study_mode IN igs_he_en_susa.study_mode%TYPE,
569: p_poous_study_mode IN igs_he_poous.attendance_mode%TYPE,
570: p_attendance_type IN igs_en_stdnt_ps_att.attendance_type%TYPE,
571: p_mode_of_study OUT NOCOPY VARCHAR2);
572:
573: FUNCTION isDormant