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 65: p_fe_program_marker IN igs_he_st_prog.fe_program_marker%TYPE,

61: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE DEFAULT NULL);
62:
63: PROCEDURE get_fe_stdnt_mrker
64: (p_spa_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
65: p_fe_program_marker IN igs_he_st_prog.fe_program_marker%TYPE,
66: p_funding_src IN igs_he_ex_rn_dat_fd.value%TYPE,
67: p_fundability_cd IN igs_he_ex_rn_dat_fd.value%TYPE,
68: p_oss_fe_stdnt_mrker OUT NOCOPY VARCHAR2,
69: p_hesa_fe_stdnt_mrker OUT NOCOPY VARCHAR2);

Line 86: p_prg_fund_cd IN igs_he_st_prog.fundability%TYPE,

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,
90: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE DEFAULT NULL,

Line 175: p_prg_study_location IN igs_he_st_prog.location_of_study%TYPE,

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:
179: -- smaddali 11-dec-03 Modified for bug#3235753 , added 2 new parameters

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

291: p_length OUT NOCOPY VARCHAR2,
292: p_units OUT NOCOPY VARCHAR2);
293:
294: PROCEDURE get_teach_train_crs_id
295: (p_prg_ttcid IN igs_he_st_prog.teacher_train_prog_id%TYPE,
296: p_spa_ttcid IN igs_he_st_spa.teacher_train_prog_id%TYPE,
297: p_hesa_ttcid OUT NOCOPY VARCHAR2);
298:
299: PROCEDURE get_itt_phsc

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

296: p_spa_ttcid IN igs_he_st_spa.teacher_train_prog_id%TYPE,
297: p_hesa_ttcid OUT NOCOPY VARCHAR2);
298:
299: PROCEDURE get_itt_phsc
300: (p_prg_itt_phsc IN igs_he_st_prog.itt_phase%TYPE,
301: p_spa_itt_phsc IN igs_he_st_spa.itt_phase%TYPE,
302: p_hesa_itt_phsc OUT NOCOPY VARCHAR2);
303:
304: PROCEDURE get_itt_mrker

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

301: p_spa_itt_phsc IN igs_he_st_spa.itt_phase%TYPE,
302: p_hesa_itt_phsc OUT NOCOPY VARCHAR2);
303:
304: PROCEDURE get_itt_mrker
305: (p_prg_itt_mrker IN igs_he_st_prog.bilingual_itt_marker%TYPE,
306: p_spa_itt_mrker IN igs_he_st_spa.bilingual_itt_marker%TYPE,
307: p_hesa_itt_mrker OUT NOCOPY VARCHAR2);
308:
309: PROCEDURE get_teach_qual_sect

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

306: p_spa_itt_mrker IN igs_he_st_spa.bilingual_itt_marker%TYPE,
307: p_hesa_itt_mrker OUT NOCOPY VARCHAR2);
308:
309: PROCEDURE get_teach_qual_sect
310: (p_oss_teach_qual_sect IN igs_he_st_prog.teaching_qual_sought_sector%TYPE,
311: p_hesa_teach_qual_sect OUT NOCOPY VARCHAR2);
312:
313: PROCEDURE get_teach_qual_sbj
314: (p_oss_teach_qual_sbj IN igs_he_st_prog.teaching_qual_sought_subj1%TYPE,

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

310: (p_oss_teach_qual_sect IN igs_he_st_prog.teaching_qual_sought_sector%TYPE,
311: p_hesa_teach_qual_sect OUT NOCOPY VARCHAR2);
312:
313: PROCEDURE get_teach_qual_sbj
314: (p_oss_teach_qual_sbj IN igs_he_st_prog.teaching_qual_sought_subj1%TYPE,
315: p_hesa_teach_qual_sbj OUT NOCOPY VARCHAR2);
316:
317: -- smaddali 11-dec-03 Modified for bug#3235753 , added 2 new parameters
318: PROCEDURE get_fee_elig

Line 332: p_prg_fee_band IN igs_he_st_prog.fee_band%TYPE,

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
336: PROCEDURE get_amt_tuition_fees

Line 340: p_fe_prg_mrker IN igs_he_st_prog.fe_program_marker%TYPE,

336: PROCEDURE get_amt_tuition_fees
337: (p_person_id IN igs_pe_person.person_id%TYPE,
338: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
339: p_cal_type IN igs_en_stdnt_ps_att.cal_type%TYPE,
340: p_fe_prg_mrker IN igs_he_st_prog.fe_program_marker%TYPE,
341: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
342: p_oss_amt OUT NOCOPY NUMBER,
343: p_hesa_amt OUT NOCOPY VARCHAR2,
344: p_enrl_start_dt IN DATE DEFAULT NULL,

Line 378: p_program_calc IN igs_he_st_prog.program_calc%TYPE,

374:
375: PROCEDURE get_oth_teach_inst
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,

Line 381: p_prog_inst1 IN igs_he_st_prog.other_inst_prov_teaching1%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,
385: p_hesa_inst1 OUT NOCOPY VARCHAR2,

Line 384: p_prog_inst2 IN igs_he_st_prog.other_inst_prov_teaching1%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,
388: p_enrl_end_dt IN DATE);

Line 396: p_program_calc IN igs_he_st_prog.program_calc%TYPE,

392: (p_person_id IN igs_pe_person.person_id%TYPE,
393: p_course_cd IN igs_he_st_spa.course_cd%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);

Line 399: p_prog_prop IN igs_he_st_prog.prop_not_taught%TYPE,

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
403: (p_oss_credit_trans_sch IN igs_he_st_prog.credit_transfer_scheme%TYPE,

Line 403: (p_oss_credit_trans_sch IN igs_he_st_prog.credit_transfer_scheme%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
403: (p_oss_credit_trans_sch IN igs_he_st_prog.credit_transfer_scheme%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 ,

Line 415: p_prog_calc IN igs_he_st_prog.program_calc%TYPE,

411: -- jbaber added crd_pt3-4, lvl_crd_pt3-4 for HEFD350
412: PROCEDURE get_credit_obtained
413: (p_person_id IN igs_pe_person.person_id%TYPE,
414: p_course_cd IN igs_he_st_spa.course_cd%TYPE,
415: p_prog_calc IN igs_he_st_prog.program_calc%TYPE,
416: p_susa_crd_pt1 IN igs_he_en_susa.credit_pt_achieved1%TYPE,
417: p_susa_crd_pt2 IN igs_he_en_susa.credit_pt_achieved2%TYPE,
418: p_susa_crd_pt3 IN igs_he_en_susa.credit_pt_achieved3%TYPE,
419: p_susa_crd_pt4 IN igs_he_en_susa.credit_pt_achieved4%TYPE,

Line 446: p_program_calc IN igs_he_st_prog.program_calc%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,
450: p_cost_ctr_rec IN OUT NOCOPY cc_rec,

Line 472: p_prg_lvl_appl_fund IN igs_he_st_prog.level_applicable_to_funding%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(
476: p_susa_comp_pyr_study IN igs_he_en_susa.complete_pyr_study_cd%TYPE,

Line 508: p_prog_franch_activity IN igs_he_st_prog.franchising_activity%TYPE,

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
512: (p_spa_social_class_ind IN igs_he_st_spa.social_class_ind%TYPE,

Line 674: p_prog_gov_initiatives_cd IN igs_he_st_prog.gov_initiatives_cd%TYPE,

670: p_hesa_disability_type OUT NOCOPY VARCHAR2);
671:
672: PROCEDURE get_gov_init
673: (p_spa_gov_initiatives_cd IN igs_he_st_spa.gov_initiatives_cd%TYPE,
674: p_prog_gov_initiatives_cd IN igs_he_st_prog.gov_initiatives_cd%TYPE,
675: p_hesa_gov_initiatives_cd OUT NOCOPY VARCHAR2);
676:
677: PROCEDURE get_units_completed
678: (p_person_id IN igs_pe_person.person_id%TYPE,

Line 686: p_prog_disadv_uplift_elig_cd IN igs_he_st_prog.disadv_uplift_elig_cd%TYPE,

682: p_hesa_units_completed OUT NOCOPY VARCHAR2);
683:
684: PROCEDURE get_disadv_uplift_elig
685: (p_spa_disadv_uplift_elig_cd IN igs_he_st_spa.disadv_uplift_elig_cd%TYPE,
686: p_prog_disadv_uplift_elig_cd IN igs_he_st_prog.disadv_uplift_elig_cd%TYPE,
687: p_hesa_disadv_uplift_elig_cd OUT NOCOPY VARCHAR2);
688:
689: PROCEDURE get_franch_out_arr
690: (p_spa_franch_out_arr_cd IN igs_he_st_spa.franch_out_arr_cd%TYPE,

Line 691: p_prog_franch_out_arr_cd IN igs_he_st_prog.franch_out_arr_cd%TYPE,

687: p_hesa_disadv_uplift_elig_cd OUT NOCOPY VARCHAR2);
688:
689: PROCEDURE get_franch_out_arr
690: (p_spa_franch_out_arr_cd IN igs_he_st_spa.franch_out_arr_cd%TYPE,
691: p_prog_franch_out_arr_cd IN igs_he_st_prog.franch_out_arr_cd%TYPE,
692: p_hesa_franch_out_arr_cd OUT NOCOPY VARCHAR2);
693:
694: PROCEDURE get_employer_role
695: (p_spa_employer_role_cd IN igs_he_st_spa.employer_role_cd%TYPE,