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_EN_STDNT_PS_ATT

Line 44: (p_location_cd IN igs_en_stdnt_ps_att.location_cd%TYPE,

40: PROCEDURE get_hesa_inst_id
41: (p_hesa_inst_id OUT NOCOPY VARCHAR2);
42:
43: PROCEDURE get_campus_id
44: (p_location_cd IN igs_en_stdnt_ps_att.location_cd%TYPE,
45: p_campus_id OUT NOCOPY VARCHAR2);
46:
47: -- smaddali 11-dec-03 Modified for bug#3235753 , added 2 new parameters
48: PROCEDURE get_alt_pers_id

Line 57: (p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,

53: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE DEFAULT NULL);
54:
55: -- smaddali 11-dec-03 Modified for bug#3235753 , added 2 new parameters
56: PROCEDURE get_stdnt_id
57: (p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
58: p_inst_id IN igs_or_institution.govt_institution_cd%TYPE,
59: p_stdnt_id OUT NOCOPY VARCHAR2,
60: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE DEFAULT NULL,
61: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE DEFAULT NULL);

Line 75: p_spa_fund_src IN igs_en_stdnt_ps_att.funding_source%TYPE,

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

Line 84: p_spa_funding_source IN igs_en_stdnt_ps_att.funding_source%TYPE,

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

Line 216: p_crs_req_comp_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,

212:
213: PROCEDURE get_rsn_inst_left
214: (p_person_id IN igs_he_en_susa.person_id%TYPE,
215: p_course_cd IN igs_he_en_susa.course_cd%TYPE,
216: p_crs_req_comp_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,
217: p_crs_req_comp_dt IN igs_en_stdnt_ps_att.course_rqrmnts_complete_dt%TYPE,
218: p_disc_reason_cd IN igs_en_stdnt_ps_att.discontinuation_reason_cd%TYPE,
219: p_disc_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
220: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,

Line 217: p_crs_req_comp_dt IN igs_en_stdnt_ps_att.course_rqrmnts_complete_dt%TYPE,

213: PROCEDURE get_rsn_inst_left
214: (p_person_id IN igs_he_en_susa.person_id%TYPE,
215: p_course_cd IN igs_he_en_susa.course_cd%TYPE,
216: p_crs_req_comp_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,
217: p_crs_req_comp_dt IN igs_en_stdnt_ps_att.course_rqrmnts_complete_dt%TYPE,
218: p_disc_reason_cd IN igs_en_stdnt_ps_att.discontinuation_reason_cd%TYPE,
219: p_disc_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
220: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
221: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,

Line 218: p_disc_reason_cd IN igs_en_stdnt_ps_att.discontinuation_reason_cd%TYPE,

214: (p_person_id IN igs_he_en_susa.person_id%TYPE,
215: p_course_cd IN igs_he_en_susa.course_cd%TYPE,
216: p_crs_req_comp_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,
217: p_crs_req_comp_dt IN igs_en_stdnt_ps_att.course_rqrmnts_complete_dt%TYPE,
218: p_disc_reason_cd IN igs_en_stdnt_ps_att.discontinuation_reason_cd%TYPE,
219: p_disc_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
220: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
221: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
222: p_rsn_inst_left OUT NOCOPY VARCHAR2);

Line 219: p_disc_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,

215: p_course_cd IN igs_he_en_susa.course_cd%TYPE,
216: p_crs_req_comp_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,
217: p_crs_req_comp_dt IN igs_en_stdnt_ps_att.course_rqrmnts_complete_dt%TYPE,
218: p_disc_reason_cd IN igs_en_stdnt_ps_att.discontinuation_reason_cd%TYPE,
219: p_disc_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
220: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
221: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
222: p_rsn_inst_left OUT NOCOPY VARCHAR2);
223:

Line 231: p_crs_req_comp_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE ,

227: (p_person_id IN igs_pe_person.person_id%TYPE,
228: p_course_cd IN igs_he_st_spa.course_cd%TYPE ,
229: p_susa_comp_status IN igs_he_en_susa.completion_status%TYPE,
230: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
231: p_crs_req_comp_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE ,
232: p_discont_date IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
233: p_hesa_comp_status OUT NOCOPY VARCHAR2);
234:
235: PROCEDURE get_good_stand_mrkr

Line 232: p_discont_date IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,

228: p_course_cd IN igs_he_st_spa.course_cd%TYPE ,
229: p_susa_comp_status IN igs_he_en_susa.completion_status%TYPE,
230: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
231: p_crs_req_comp_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE ,
232: p_discont_date IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
233: p_hesa_comp_status OUT NOCOPY VARCHAR2);
234:
235: PROCEDURE get_good_stand_mrkr
236: (p_susa_good_st_mk IN igs_he_en_susa.good_stand_marker%TYPE,

Line 238: p_crs_req_comp_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE ,

234:
235: PROCEDURE get_good_stand_mrkr
236: (p_susa_good_st_mk IN igs_he_en_susa.good_stand_marker%TYPE,
237: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
238: p_crs_req_comp_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE ,
239: p_discont_date IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
240: p_hesa_good_st_mk OUT NOCOPY VARCHAR2);
241:
242: PROCEDURE get_qual_obtained

Line 239: p_discont_date IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,

235: PROCEDURE get_good_stand_mrkr
236: (p_susa_good_st_mk IN igs_he_en_susa.good_stand_marker%TYPE,
237: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
238: p_crs_req_comp_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE ,
239: p_discont_date IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
240: p_hesa_good_st_mk OUT NOCOPY VARCHAR2);
241:
242: PROCEDURE get_qual_obtained
243: (p_person_id IN igs_pe_person.person_id%TYPE,

Line 288: (p_spa_attendance_type IN igs_en_stdnt_ps_att.attendance_type%TYPE,

284: p_awd_body1 OUT NOCOPY VARCHAR2,
285: p_awd_body2 OUT NOCOPY VARCHAR2);
286:
287: PROCEDURE get_prog_length
288: (p_spa_attendance_type IN igs_en_stdnt_ps_att.attendance_type%TYPE,
289: p_ft_compl_time IN igs_ps_ver.std_ft_completion_time%TYPE,
290: p_pt_compl_time IN igs_ps_ver.std_pt_completion_time%TYPE,
291: p_length OUT NOCOPY VARCHAR2,
292: p_units OUT NOCOPY VARCHAR2);

Line 339: p_cal_type IN igs_en_stdnt_ps_att.cal_type%TYPE,

335: -- smaddali 13-oct-03 modified procedure to add 2 new parameters for bug# 3179544
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,

Line 438: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,

434:
435: --jbaber added new parameter p_validation_country for HEFD350 process 2
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,

Line 439: p_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,

435: --jbaber added new parameter p_validation_country for HEFD350 process 2
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,

Line 482: p_crse_rqr_complete_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,

478: p_spcstu IN VARCHAR2,
479: p_notact IN VARCHAR2,
480: p_mode IN VARCHAR2,
481: p_typeyr IN VARCHAR2,
482: p_crse_rqr_complete_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,
483: p_crse_req_complete_dt IN igs_en_stdnt_ps_att.course_rqrmnts_complete_dt%TYPE,
484: p_disc_reason_cd IN igs_en_stdnt_ps_att.discontinuation_reason_cd%TYPE,
485: p_discont_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
486: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,

Line 483: p_crse_req_complete_dt IN igs_en_stdnt_ps_att.course_rqrmnts_complete_dt%TYPE,

479: p_notact IN VARCHAR2,
480: p_mode IN VARCHAR2,
481: p_typeyr IN VARCHAR2,
482: p_crse_rqr_complete_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,
483: p_crse_req_complete_dt IN igs_en_stdnt_ps_att.course_rqrmnts_complete_dt%TYPE,
484: p_disc_reason_cd IN igs_en_stdnt_ps_att.discontinuation_reason_cd%TYPE,
485: p_discont_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
486: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
487: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,

Line 484: p_disc_reason_cd IN igs_en_stdnt_ps_att.discontinuation_reason_cd%TYPE,

480: p_mode IN VARCHAR2,
481: p_typeyr IN VARCHAR2,
482: p_crse_rqr_complete_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,
483: p_crse_req_complete_dt IN igs_en_stdnt_ps_att.course_rqrmnts_complete_dt%TYPE,
484: p_disc_reason_cd IN igs_en_stdnt_ps_att.discontinuation_reason_cd%TYPE,
485: p_discont_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
486: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
487: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
488: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,

Line 485: p_discont_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,

481: p_typeyr IN VARCHAR2,
482: p_crse_rqr_complete_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,
483: p_crse_req_complete_dt IN igs_en_stdnt_ps_att.course_rqrmnts_complete_dt%TYPE,
484: p_disc_reason_cd IN igs_en_stdnt_ps_att.discontinuation_reason_cd%TYPE,
485: p_discont_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
486: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
487: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
488: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
489: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,

Line 488: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,

484: p_disc_reason_cd IN igs_en_stdnt_ps_att.discontinuation_reason_cd%TYPE,
485: p_discont_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
486: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
487: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
488: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
489: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
490: p_hesa_comp_pyr_study OUT NOCOPY VARCHAR2);
491:
492: PROCEDURE get_destination

Line 489: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,

485: p_discont_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
486: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
487: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
488: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
489: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
490: p_hesa_comp_pyr_study OUT NOCOPY VARCHAR2);
491:
492: PROCEDURE get_destination
493: (p_oss_destination IN igs_he_st_spa.destination%TYPE,

Line 551: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,

547:
548:
549: PROCEDURE get_module_dets
550: (p_person_id IN igs_pe_person.person_id%TYPE,
551: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
552: p_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,
553: p_student_inst_number IN igs_he_st_spa.student_inst_number%TYPE,
554: p_cal_type IN igs_en_stdnt_ps_att.cal_type%TYPE,
555: p_enrl_start_dt IN DATE,

Line 552: p_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,

548:
549: PROCEDURE get_module_dets
550: (p_person_id IN igs_pe_person.person_id%TYPE,
551: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
552: p_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,
553: p_student_inst_number IN igs_he_st_spa.student_inst_number%TYPE,
554: p_cal_type IN igs_en_stdnt_ps_att.cal_type%TYPE,
555: p_enrl_start_dt IN DATE,
556: p_enrl_end_dt IN DATE,

Line 554: p_cal_type IN igs_en_stdnt_ps_att.cal_type%TYPE,

550: (p_person_id IN igs_pe_person.person_id%TYPE,
551: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
552: p_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,
553: p_student_inst_number IN igs_he_st_spa.student_inst_number%TYPE,
554: p_cal_type IN igs_en_stdnt_ps_att.cal_type%TYPE,
555: p_enrl_start_dt IN DATE,
556: p_enrl_end_dt IN DATE,
557: p_offset_days IN NUMBER,
558: p_module_rec IN OUT NOCOPY mod_rec,

Line 570: p_attendance_type IN igs_en_stdnt_ps_att.attendance_type%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
574: (p_person_id IN igs_pe_person.person_id%TYPE,

Line 623: p_enstdnt_commdate IN igs_en_stdnt_ps_att.commencement_dt%TYPE DEFAULT NULL,

619:
620:
621: PROCEDURE get_commencement_dt
622: ( p_hesa_commdate IN igs_he_st_spa_all.commencement_dt%TYPE DEFAULT NULL,
623: p_enstdnt_commdate IN igs_en_stdnt_ps_att.commencement_dt%TYPE DEFAULT NULL,
624: p_person_id IN igs_pe_person.person_id%TYPE ,
625: p_course_cd IN igs_he_st_spa_all.course_cd%TYPE,
626: p_version_number IN igs_he_st_spa_all.version_number%TYPE,
627: p_student_inst_number IN igs_he_st_spa_all.student_inst_number%TYPE,

Line 640: (p_spa_attendance_type IN igs_en_stdnt_ps_att.attendance_type%TYPE,

636: p_hesa_qualaim_sbj OUT NOCOPY igs_he_code_values.value%TYPE);
637:
638:
639: PROCEDURE get_new_prog_length
640: (p_spa_attendance_type IN igs_en_stdnt_ps_att.attendance_type%TYPE,
641: p_program_length IN igs_ps_ofr_opt_all.program_length%TYPE,
642: p_program_length_measurement IN igs_ps_ofr_opt_all.program_length_measurement%TYPE,
643: p_length OUT NOCOPY NUMBER,
644: p_units OUT NOCOPY NUMBER);