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 66: (p_location_cd IN igs_en_stdnt_ps_att.location_cd%TYPE,

62: END get_hesa_inst_id;
63:
64:
65: PROCEDURE get_campus_id
66: (p_location_cd IN igs_en_stdnt_ps_att.location_cd%TYPE,
67: p_campus_id OUT NOCOPY VARCHAR2)
68: IS
69: /***************************************************************
70: Created By :

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

146: END get_alt_pers_id;
147:
148:
149: PROCEDURE get_stdnt_id
150: (p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
151: p_inst_id IN igs_or_institution.govt_institution_cd%TYPE,
152: p_stdnt_id OUT NOCOPY VARCHAR2,
153: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
154: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE)

Line 177: FROM igs_en_stdnt_ps_att

173: ***************************************************************/
174:
175: CURSOR c_comdt IS
176: SELECT to_char(MIN(commencement_dt),'YY')
177: FROM igs_en_stdnt_ps_att
178: WHERE person_id = p_person_id;
179:
180: CURSOR c_sid IS
181: SELECT igs_he_stdnt_id_s.nextval

Line 701: p_spa_fund_src IN igs_en_stdnt_ps_att.funding_source%TYPE,

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

Line 816: p_spa_funding_source IN igs_en_stdnt_ps_att.funding_source%TYPE,

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

Line 1620: FROM igs_en_stdnt_ps_att_all a , igs_he_st_spa_all b

1616:
1617: -- Get the academic calendar type and student instance number of the current program attempt.
1618: CURSOR c_acad_cal IS
1619: SELECT a.cal_type,b.student_inst_number
1620: FROM igs_en_stdnt_ps_att_all a , igs_he_st_spa_all b
1621: WHERE a.person_id = p_person_id AND
1622: a.course_cd = p_course_cd AND
1623: a.person_id = b.person_id AND
1624: a.course_cd = b.course_cd ;

Line 1636: p_cal_type igs_en_stdnt_ps_att_all.cal_type%TYPE ) IS

1632: -- mandatorily transfer all his unit and unit set attempts , Thus they will be counted in the
1633: -- latest calendar.
1634: -- smaddali 29-oct-03 modified to add condition enrolled_dt <= p_enr_end_dt for bug#3224246
1635: CURSOR c_yos (p_student_inst_number igs_he_st_spa_all.student_inst_number%TYPE,
1636: p_cal_type igs_en_stdnt_ps_att_all.cal_type%TYPE ) IS
1637: SELECT COUNT (DISTINCT cir.sup_ci_sequence_number || cir.sup_cal_type)
1638: FROM igs_he_st_spa_all spa ,
1639: igs_en_stdnt_ps_att sca,
1640: igs_en_su_attempt sua,

Line 1639: igs_en_stdnt_ps_att sca,

1635: CURSOR c_yos (p_student_inst_number igs_he_st_spa_all.student_inst_number%TYPE,
1636: p_cal_type igs_en_stdnt_ps_att_all.cal_type%TYPE ) IS
1637: SELECT COUNT (DISTINCT cir.sup_ci_sequence_number || cir.sup_cal_type)
1638: FROM igs_he_st_spa_all spa ,
1639: igs_en_stdnt_ps_att sca,
1640: igs_en_su_attempt sua,
1641: igs_ca_inst_rel cir,
1642: igs_ca_inst_all ca
1643: WHERE SPA.person_id = p_person_id and

Line 2103: p_crs_req_comp_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,

2099:
2100: PROCEDURE get_rsn_inst_left
2101: (p_person_id IN igs_he_en_susa.person_id%TYPE,
2102: p_course_cd IN igs_he_en_susa.course_cd%TYPE,
2103: p_crs_req_comp_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,
2104: p_crs_req_comp_dt IN igs_en_stdnt_ps_att.course_rqrmnts_complete_dt%TYPE,
2105: p_disc_reason_cd IN igs_en_stdnt_ps_att.discontinuation_reason_cd%TYPE,
2106: p_disc_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
2107: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,

Line 2104: p_crs_req_comp_dt IN igs_en_stdnt_ps_att.course_rqrmnts_complete_dt%TYPE,

2100: PROCEDURE get_rsn_inst_left
2101: (p_person_id IN igs_he_en_susa.person_id%TYPE,
2102: p_course_cd IN igs_he_en_susa.course_cd%TYPE,
2103: p_crs_req_comp_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,
2104: p_crs_req_comp_dt IN igs_en_stdnt_ps_att.course_rqrmnts_complete_dt%TYPE,
2105: p_disc_reason_cd IN igs_en_stdnt_ps_att.discontinuation_reason_cd%TYPE,
2106: p_disc_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
2107: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
2108: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,

Line 2105: p_disc_reason_cd IN igs_en_stdnt_ps_att.discontinuation_reason_cd%TYPE,

2101: (p_person_id IN igs_he_en_susa.person_id%TYPE,
2102: p_course_cd IN igs_he_en_susa.course_cd%TYPE,
2103: p_crs_req_comp_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,
2104: p_crs_req_comp_dt IN igs_en_stdnt_ps_att.course_rqrmnts_complete_dt%TYPE,
2105: p_disc_reason_cd IN igs_en_stdnt_ps_att.discontinuation_reason_cd%TYPE,
2106: p_disc_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
2107: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
2108: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
2109: p_rsn_inst_left OUT NOCOPY VARCHAR2)

Line 2106: p_disc_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,

2102: p_course_cd IN igs_he_en_susa.course_cd%TYPE,
2103: p_crs_req_comp_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,
2104: p_crs_req_comp_dt IN igs_en_stdnt_ps_att.course_rqrmnts_complete_dt%TYPE,
2105: p_disc_reason_cd IN igs_en_stdnt_ps_att.discontinuation_reason_cd%TYPE,
2106: p_disc_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
2107: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
2108: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
2109: p_rsn_inst_left OUT NOCOPY VARCHAR2)
2110: IS

Line 2188: p_crs_req_comp_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,

2184: (p_person_id IN igs_pe_person.person_id%TYPE,
2185: p_course_cd IN igs_he_st_spa.course_cd%TYPE ,
2186: p_susa_comp_status IN igs_he_en_susa.completion_status%TYPE,
2187: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
2188: p_crs_req_comp_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,
2189: p_discont_date IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
2190: p_hesa_comp_status OUT NOCOPY VARCHAR2)
2191: IS
2192: /***************************************************************

Line 2189: p_discont_date IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,

2185: p_course_cd IN igs_he_st_spa.course_cd%TYPE ,
2186: p_susa_comp_status IN igs_he_en_susa.completion_status%TYPE,
2187: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
2188: p_crs_req_comp_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,
2189: p_discont_date IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
2190: p_hesa_comp_status OUT NOCOPY VARCHAR2)
2191: IS
2192: /***************************************************************
2193: Created By :

Line 2299: p_crs_req_comp_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,

2295:
2296: PROCEDURE get_good_stand_mrkr
2297: (p_susa_good_st_mk IN igs_he_en_susa.good_stand_marker%TYPE,
2298: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
2299: p_crs_req_comp_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,
2300: p_discont_date IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
2301: p_hesa_good_st_mk OUT NOCOPY VARCHAR2)
2302: IS
2303: /***************************************************************

Line 2300: p_discont_date IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,

2296: PROCEDURE get_good_stand_mrkr
2297: (p_susa_good_st_mk IN igs_he_en_susa.good_stand_marker%TYPE,
2298: p_fe_stdnt_mrker IN igs_he_st_spa.fe_student_marker%TYPE,
2299: p_crs_req_comp_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,
2300: p_discont_date IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
2301: p_hesa_good_st_mk OUT NOCOPY VARCHAR2)
2302: IS
2303: /***************************************************************
2304: Created By :

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

3039:
3040:
3041:
3042: PROCEDURE get_prog_length
3043: (p_spa_attendance_type IN igs_en_stdnt_ps_att.attendance_type%TYPE,
3044: p_ft_compl_time IN igs_ps_ver.std_ft_completion_time%TYPE,
3045: p_pt_compl_time IN igs_ps_ver.std_pt_completion_time%TYPE,
3046: p_length OUT NOCOPY VARCHAR2,
3047: p_units OUT NOCOPY VARCHAR2)

Line 3528: p_cal_type IN igs_en_stdnt_ps_att.cal_type%TYPE,

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

Line 4506: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,

4502:
4503:
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,

Line 4507: p_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,

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

Line 5088: FROM igs_en_stdnt_ps_att_all

5084: CURSOR c_spa_dt IS
5085: SELECT commencement_dt,
5086: discontinued_dt,
5087: course_rqrmnts_complete_dt
5088: FROM igs_en_stdnt_ps_att_all
5089: WHERE person_id = p_person_id
5090: AND course_cd = p_course_cd
5091: AND version_number = p_version_number;
5092:

Line 5256: p_crse_rqr_complete_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,

5252: p_spcstu IN VARCHAR2,
5253: p_notact IN VARCHAR2,
5254: p_mode IN VARCHAR2,
5255: p_typeyr IN VARCHAR2,
5256: p_crse_rqr_complete_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,
5257: p_crse_req_complete_dt IN igs_en_stdnt_ps_att.course_rqrmnts_complete_dt%TYPE,
5258: p_disc_reason_cd IN igs_en_stdnt_ps_att.discontinuation_reason_cd%TYPE,
5259: p_discont_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
5260: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,

Line 5257: p_crse_req_complete_dt IN igs_en_stdnt_ps_att.course_rqrmnts_complete_dt%TYPE,

5253: p_notact IN VARCHAR2,
5254: p_mode IN VARCHAR2,
5255: p_typeyr IN VARCHAR2,
5256: p_crse_rqr_complete_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,
5257: p_crse_req_complete_dt IN igs_en_stdnt_ps_att.course_rqrmnts_complete_dt%TYPE,
5258: p_disc_reason_cd IN igs_en_stdnt_ps_att.discontinuation_reason_cd%TYPE,
5259: p_discont_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
5260: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
5261: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,

Line 5258: p_disc_reason_cd IN igs_en_stdnt_ps_att.discontinuation_reason_cd%TYPE,

5254: p_mode IN VARCHAR2,
5255: p_typeyr IN VARCHAR2,
5256: p_crse_rqr_complete_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,
5257: p_crse_req_complete_dt IN igs_en_stdnt_ps_att.course_rqrmnts_complete_dt%TYPE,
5258: p_disc_reason_cd IN igs_en_stdnt_ps_att.discontinuation_reason_cd%TYPE,
5259: p_discont_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
5260: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
5261: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
5262: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,

Line 5259: p_discont_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,

5255: p_typeyr IN VARCHAR2,
5256: p_crse_rqr_complete_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,
5257: p_crse_req_complete_dt IN igs_en_stdnt_ps_att.course_rqrmnts_complete_dt%TYPE,
5258: p_disc_reason_cd IN igs_en_stdnt_ps_att.discontinuation_reason_cd%TYPE,
5259: p_discont_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
5260: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
5261: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
5262: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
5263: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,

Line 5262: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,

5258: p_disc_reason_cd IN igs_en_stdnt_ps_att.discontinuation_reason_cd%TYPE,
5259: p_discont_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
5260: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
5261: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
5262: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
5263: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
5264: p_hesa_comp_pyr_study OUT NOCOPY VARCHAR2) IS
5265: /***************************************************************
5266: Created By :

Line 5263: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,

5259: p_discont_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
5260: p_enrl_start_dt IN igs_he_submsn_header.enrolment_start_date%TYPE,
5261: p_enrl_end_dt IN igs_he_submsn_header.enrolment_end_date%TYPE,
5262: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
5263: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
5264: p_hesa_comp_pyr_study OUT NOCOPY VARCHAR2) IS
5265: /***************************************************************
5266: Created By :
5267: Date Created By :

Line 5288: CURSOR cur_prog_out_type (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,

5284: l_prev_decision_dt IGS_PR_STDNT_PR_OU.decision_dt%TYPE;
5285: l_minimum_date DATE;
5286:
5287: -- Cursor to fetch the STudent Progression Outcome Type
5288: CURSOR cur_prog_out_type (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
5289: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
5290: cp_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,
5291: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE) IS
5292: SELECT progression_outcome_type,ca.start_dt , spo.decision_dt, spo.applied_dt

Line 5289: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,

5285: l_minimum_date DATE;
5286:
5287: -- Cursor to fetch the STudent Progression Outcome Type
5288: CURSOR cur_prog_out_type (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
5289: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
5290: cp_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,
5291: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE) IS
5292: SELECT progression_outcome_type,ca.start_dt , spo.decision_dt, spo.applied_dt
5293: FROM IGS_PR_STDNT_PR_OU spo,

Line 6095: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,

6091:
6092:
6093: PROCEDURE get_module_dets
6094: (p_person_id IN igs_pe_person.person_id%TYPE,
6095: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
6096: p_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,
6097: p_student_inst_number IN igs_he_st_spa.student_inst_number%TYPE,
6098: p_cal_type IN igs_en_stdnt_ps_att.cal_type%TYPE,
6099: p_enrl_start_dt IN DATE,

Line 6096: p_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,

6092:
6093: PROCEDURE get_module_dets
6094: (p_person_id IN igs_pe_person.person_id%TYPE,
6095: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
6096: p_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,
6097: p_student_inst_number IN igs_he_st_spa.student_inst_number%TYPE,
6098: p_cal_type IN igs_en_stdnt_ps_att.cal_type%TYPE,
6099: p_enrl_start_dt IN DATE,
6100: p_enrl_end_dt IN DATE,

Line 6098: p_cal_type IN igs_en_stdnt_ps_att.cal_type%TYPE,

6094: (p_person_id IN igs_pe_person.person_id%TYPE,
6095: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
6096: p_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,
6097: p_student_inst_number IN igs_he_st_spa.student_inst_number%TYPE,
6098: p_cal_type IN igs_en_stdnt_ps_att.cal_type%TYPE,
6099: p_enrl_start_dt IN DATE,
6100: p_enrl_end_dt IN DATE,
6101: p_offset_days IN NUMBER,
6102: p_module_rec IN OUT NOCOPY mod_rec,

Line 6324: p_attendance_type IN igs_en_stdnt_ps_att.attendance_type%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
6328: /***************************************************************

Line 6431: FROM igs_en_stdnt_ps_att_all

6427: CURSOR c_spa_dt IS
6428: SELECT commencement_dt,
6429: discontinued_dt,
6430: course_rqrmnts_complete_dt
6431: FROM igs_en_stdnt_ps_att_all
6432: WHERE person_id = p_person_id
6433: AND course_cd = p_course_cd
6434: AND version_number = p_version_number;
6435:

Line 6755: p_enstdnt_commdate IN igs_en_stdnt_ps_att.commencement_dt%TYPE,

6751:
6752:
6753: PROCEDURE get_commencement_dt
6754: ( p_hesa_commdate IN igs_he_st_spa_all.commencement_dt%TYPE ,
6755: p_enstdnt_commdate IN igs_en_stdnt_ps_att.commencement_dt%TYPE,
6756: p_person_id IN igs_pe_person.person_id%TYPE ,
6757: p_course_cd IN igs_he_st_spa_all.course_cd%TYPE,
6758: p_version_number IN igs_he_st_spa_all.version_number%TYPE,
6759: p_student_inst_number IN igs_he_st_spa_all.student_inst_number%TYPE,

Line 6770: and assign the corresponding IGS_EN_STDNT_PS_ATT.commencement_dt value to it

6766: Purpose : This procedure gets the value of commencement date for combined/stduent field 26.
6767: First IGS_HE_ST_SPA_ALL.commencement date is cinsidered.If NULL then it is checked if program transfer has taken palce
6768: If yes ,then assign get the value of first program in chain for that person
6769: (For the person having the same student instance number for the different program transfer are said to be in same chain)
6770: and assign the corresponding IGS_EN_STDNT_PS_ATT.commencement_dt value to it
6771: else if the program transfer has not taken palce then get the IGS_EN_STDNT_PS_ATT.commencement_dt value
6772: of course in context and assign it to field
6773: Known Limitations,Enhancements or Remarks:
6774: Change History :

Line 6771: else if the program transfer has not taken palce then get the IGS_EN_STDNT_PS_ATT.commencement_dt value

6767: First IGS_HE_ST_SPA_ALL.commencement date is cinsidered.If NULL then it is checked if program transfer has taken palce
6768: If yes ,then assign get the value of first program in chain for that person
6769: (For the person having the same student instance number for the different program transfer are said to be in same chain)
6770: and assign the corresponding IGS_EN_STDNT_PS_ATT.commencement_dt value to it
6771: else if the program transfer has not taken palce then get the IGS_EN_STDNT_PS_ATT.commencement_dt value
6772: of course in context and assign it to field
6773: Known Limitations,Enhancements or Remarks:
6774: Change History :
6775: Who When What

Line 6784: FROM igs_en_stdnt_ps_att_all sca,

6780: --Cursor to get the commencement date of the first porgram in chain for the context person from
6781: -- IGS_HE_ST_SPA having same instance number
6782: CURSOR c_list_crs_trn IS
6783: SELECT MIN(sca.commencement_dt) commencement_dt
6784: FROM igs_en_stdnt_ps_att_all sca,
6785: igs_he_st_spa_all hspa
6786: WHERE hspa.person_id = p_person_id
6787: AND hspa.student_inst_number = p_student_inst_number
6788: AND sca.person_id = hspa.person_id

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

6938:
6939: END get_ucasnum ;
6940:
6941: PROCEDURE get_new_prog_length
6942: (p_spa_attendance_type IN igs_en_stdnt_ps_att.attendance_type%TYPE,
6943: p_program_length IN igs_ps_ofr_opt_all.program_length%TYPE,
6944: p_program_length_measurement IN igs_ps_ofr_opt_all.program_length_measurement%TYPE,
6945: p_length OUT NOCOPY NUMBER,
6946: p_units OUT NOCOPY NUMBER)