[Home] [Help]
17: g_ps_ver igs_ps_ver%ROWTYPE;
18: g_ps_type igs_ps_type_all%ROWTYPE;
19: g_ps_ofr_opt igs_ps_ofr_opt%ROWTYPE;
20: g_he_poous igs_he_poous%ROWTYPE;
21: g_pe_person igs_pe_person%ROWTYPE;
22: g_pe_stat_v igs_pe_stat_v%ROWTYPE;
23: g_he_ad_dtl igs_he_ad_dtl%ROWTYPE;
24: g_he_st_unt_vs igs_he_st_unt_vs%ROWTYPE;
25: g_ps_unit_ver_v igs_ps_unit_ver_v%ROWTYPE;
84: END write_to_log;
85:
86: --smaddali added this new local procedure for bug 2452592 to calculte field 76
87: PROCEDURE get_pgce_subj
88: (p_person_id IN igs_pe_person.person_id%TYPE,
89: p_pgce_subj OUT NOCOPY VARCHAR2) IS
90: /***************************************************************
91: Created By : bayadav
92: Date Created By : 25-Mar-2002
744: l_spcstu igs_he_ex_rn_dat_fd.value%TYPE;
745: l_notact igs_he_ex_rn_dat_fd.value%TYPE;
746: l_mode igs_he_ex_rn_dat_fd.value%TYPE;
747: l_typeyr igs_he_ex_rn_dat_fd.value%TYPE;
748: l_fmly_name igs_pe_person.surname%TYPE;
749: l_disadv_uplift_factor igs_he_st_spa.disadv_uplift_factor%TYPE;
750:
751: CURSOR c_subj(cp_field_of_study igs_ps_fld_of_study.field_of_study%TYPE)
752: IS
4668: l_spcstu igs_he_ex_rn_dat_fd.value%TYPE;
4669: l_notact igs_he_ex_rn_dat_fd.value%TYPE;
4670: l_mode igs_he_ex_rn_dat_fd.value%TYPE;
4671: l_typeyr igs_he_ex_rn_dat_fd.value%TYPE;
4672: l_fmly_name igs_pe_person.surname%TYPE;
4673: l_disadv_uplift_factor igs_he_st_spa.disadv_uplift_factor%TYPE;
4674:
4675: CURSOR c_subj(cp_field_of_study igs_ps_fld_of_study.field_of_study%TYPE)
4676: IS
9438: Known Limitations,Enhancements or Remarks:
9439: Change History :
9440: Who When What
9441: pkpatel 27-MAR-2003 Bug No: 2261717
9442: These 2 columns are obsolete from igs_pe_person_v and here they are not being used for any processing.
9443: Hence removed to avoid confusion.
9444: smaddali 3-dec-03 modified cursors c_yop to add condition complete_ind=Y , for HECR210 build, bug#2874542
9445: smaddali 10-dec-03 Modified logic to get Term record details for HECR214 - Term based fees enhancement, bug#3291656
9446: smaddali 14-jan-04 Modified logic not to stop processing student when igs_pe_stats record is not found : bug#3361317
9834: c_term_con_rec c_term_con%ROWTYPE ;
9835: l_lev_dt igs_en_stdnt_ps_att_all.discontinued_dt%TYPE ;
9836:
9837: -- smaddali added cursor for bug#3361317
9838: CURSOR c_pers_number ( cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
9839: SELECT party_number person_number
9840: FROM hz_parties
9841: WHERE party_id = cp_person_id ;
9842: l_person_number igs_pe_Person_base_v.person_number%TYPE;
9838: CURSOR c_pers_number ( cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
9839: SELECT party_number person_number
9840: FROM hz_parties
9841: WHERE party_id = cp_person_id ;
9842: l_person_number igs_pe_Person_base_v.person_number%TYPE;
9843:
9844: BEGIN
9845:
9846: -- Fetch the Person Details
10617: l_message VARCHAR2(2000);
10618:
10619:
10620: -- smaddali added cursor for bug#3361317
10621: CURSOR c_pers_number ( cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
10622: SELECT party_number person_number
10623: FROM hz_parties
10624: WHERE party_id = cp_person_id ;
10625: l_person_number igs_pe_Person_base_v.person_number%TYPE;
10621: CURSOR c_pers_number ( cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
10622: SELECT party_number person_number
10623: FROM hz_parties
10624: WHERE party_id = cp_person_id ;
10625: l_person_number igs_pe_Person_base_v.person_number%TYPE;
10626:
10627: TYPE INTRM_RECORDS IS TABLE OF NUMBER(15) NOT NULL INDEX BY BINARY_INTEGER;
10628: l_rec_list INTRM_RECORDS;
10629: l_rec_cnt NUMBER;