[Home] [Help]
175: g_v_person_number hz_parties.party_number%TYPE;
176: l_v_lkp_all CONSTANT VARCHAR2(60) := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'ALL');
177:
178: TYPE inst_prog_details_rec_type IS RECORD (
179: program_cd igs_ps_ver_all.course_cd%TYPE,
180: program_version igs_ps_ver_all.version_number%TYPE,
181: career igs_ps_ver_all.course_type%TYPE );
182:
183: -- This table type will hold the program details which are liable for an Institution system fee trigger category.
176: l_v_lkp_all CONSTANT VARCHAR2(60) := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'ALL');
177:
178: TYPE inst_prog_details_rec_type IS RECORD (
179: program_cd igs_ps_ver_all.course_cd%TYPE,
180: program_version igs_ps_ver_all.version_number%TYPE,
181: career igs_ps_ver_all.course_type%TYPE );
182:
183: -- This table type will hold the program details which are liable for an Institution system fee trigger category.
184: TYPE inst_prog_det_tbl_typ IS TABLE OF inst_prog_details_rec_type INDEX BY BINARY_INTEGER;
177:
178: TYPE inst_prog_details_rec_type IS RECORD (
179: program_cd igs_ps_ver_all.course_cd%TYPE,
180: program_version igs_ps_ver_all.version_number%TYPE,
181: career igs_ps_ver_all.course_type%TYPE );
182:
183: -- This table type will hold the program details which are liable for an Institution system fee trigger category.
184: TYPE inst_prog_det_tbl_typ IS TABLE OF inst_prog_details_rec_type INDEX BY BINARY_INTEGER;
185:
234: TYPE wav_fcfl_rec_type IS RECORD (
235: p_fee_category igs_fi_f_cat_fee_lbl_all.fee_cat%TYPE,
236: p_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE,
237: p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
238: p_career igs_ps_ver_all.course_type%TYPE);
239:
240: TYPE wav_fcfl_tbl_type IS TABLE OF wav_fcfl_rec_type INDEX BY BINARY_INTEGER;
241: tbl_wav_fcfl wav_fcfl_tbl_type;
242: t_dummy_wav_fcfl wav_fcfl_tbl_type;
340:
341: END check_census_dt_setup;
342:
343: FUNCTION finpl_lock_records(p_n_person_id IN igs_fi_fee_as_all.person_id%TYPE,
344: p_v_course_cd IN igs_ps_ver_all.course_cd%TYPE,
345: p_v_fee_cal_type IN igs_fi_fee_as_all.fee_cal_type%TYPE,
346: p_n_fee_ci_sequence_number IN igs_fi_fee_as_all.fee_ci_sequence_number%TYPE) RETURN BOOLEAN;
347:
348: FUNCTION finpl_get_derived_am_at (p_person_id IN hz_parties.party_id%TYPE,
352: p_fee_ci_sequence_number IN igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,
353: p_fee_type IN igs_fi_f_cat_fee_lbl_all.fee_type%TYPE,
354: p_s_fee_trigger_cat IN igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,
355: p_trace_on IN VARCHAR2,
356: p_c_career IN igs_ps_ver_all.course_type%TYPE,
357: p_derived_attendance_type OUT NOCOPY igs_fi_fee_as_rate.attendance_type%TYPE,
358: p_derived_att_mode OUT NOCOPY igs_en_atd_mode_all.govt_attendance_mode%TYPE) RETURN BOOLEAN;
359:
360:
395: p_creation_dt IN OUT NOCOPY DATE ,
396: p_charge_elements IN OUT NOCOPY igs_fi_fee_as_all.chg_elements%TYPE ,
397: p_fee_assessment IN OUT NOCOPY NUMBER ,
398: p_charge_rate OUT NOCOPY IGS_FI_FEE_AS_RATE.chg_rate%TYPE,
399: p_c_career IN igs_ps_ver_all.course_type%TYPE,
400: p_elm_rng_order_name IN igs_fi_f_typ_ca_inst_all.elm_rng_order_name%TYPE,
401: p_n_max_chg_elements IN igs_fi_fee_as_items.max_chg_elements%TYPE,
402: p_n_called IN NUMBER) RETURN BOOLEAN;
403:
452:
453: END get_stdnt_res_status_cd;
454:
455: FUNCTION get_stdnt_class_standing ( p_n_person_id IN igs_en_stdnt_ps_att_all.person_id%TYPE,
456: p_v_course_cd IN igs_ps_ver_all.course_cd%TYPE,
457: p_v_s_fee_trigger_cat IN igs_fi_fee_type_all.s_fee_trigger_cat%TYPE ) RETURN VARCHAR2 AS
458: /*************************************************************
459: Created By : Shirish Tatikonda
460: Date Created By : 30-DEC-2003
526:
527: END get_stdnt_class_standing;
528:
529: PROCEDURE get_stdnt_unit_set_dtls ( p_n_person_id IN igs_en_stdnt_ps_att_all.person_id%TYPE,
530: p_v_course_cd IN igs_ps_ver_all.course_cd%TYPE,
531: p_v_s_fee_trigger_cat IN igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,
532: p_v_unit_set_cd OUT NOCOPY igs_as_su_setatmpt.unit_set_cd%TYPE,
533: p_n_unit_set_ver_num OUT NOCOPY igs_as_su_setatmpt.us_version_number%TYPE ) AS
534: /*************************************************************
546: ***************************************************************/
547:
548: -- Derive the Unit Set Code and Version Number, but only of category Pre Enrollment.
549: CURSOR cur_unit_set (cp_person_id hz_parties.party_id%TYPE,
550: cp_course_cd igs_ps_ver_all.course_cd%TYPE,
551: cp_effective_dt DATE,
552: cp_v_student_confirmed_ind igs_as_su_setatmpt.student_confirmed_ind%TYPE,
553: cp_v_s_unit_set_cat igs_en_unit_set_cat.s_unit_set_cat%TYPE) IS
554: SELECT asu.unit_set_cd,
1075: p_fee_ci_sequence_number igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,
1076: p_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE,
1077: p_s_fee_trigger_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,
1078: p_trace_on VARCHAR2,
1079: p_c_career IN igs_ps_ver_all.course_type%TYPE,
1080: p_derived_attendance_type OUT NOCOPY igs_fi_fee_as_rate.attendance_type%TYPE,
1081: p_derived_att_mode OUT NOCOPY igs_en_atd_mode_all.govt_attendance_mode%TYPE) RETURN BOOLEAN AS
1082: /*************************************************************
1083: Created By : abshriva
1099: v_derived_prog_att_mode igs_en_atd_mode_all.attendance_mode%TYPE; -- Used in Nominated Profile. Holds value of AM associated at Prog Attempt.
1100: v_on_att_mode BOOLEAN := FALSE;
1101: v_off_att_mode BOOLEAN := FALSE;
1102: v_composite_att_mode BOOLEAN := FALSE;
1103: TYPE derived_values_rec IS RECORD ( course_cd igs_ps_ver_all.course_cd%TYPE,
1104: course_type igs_ps_ver_all.course_type%TYPE);
1105: TYPE derived_values_ref IS REF CURSOR RETURN derived_values_rec;
1106: c_scafv derived_values_ref;
1107: l_c_scafv c_scafv%ROWTYPE;
1100: v_on_att_mode BOOLEAN := FALSE;
1101: v_off_att_mode BOOLEAN := FALSE;
1102: v_composite_att_mode BOOLEAN := FALSE;
1103: TYPE derived_values_rec IS RECORD ( course_cd igs_ps_ver_all.course_cd%TYPE,
1104: course_type igs_ps_ver_all.course_type%TYPE);
1105: TYPE derived_values_ref IS REF CURSOR RETURN derived_values_rec;
1106: c_scafv derived_values_ref;
1107: l_c_scafv c_scafv%ROWTYPE;
1108:
1134: spat.attendance_type,
1135: ps.course_type
1136: FROM igs_en_spa_terms spat,
1137: igs_en_stdnt_ps_att_all sca,
1138: igs_ps_ver_all ps,
1139: igs_lookups_view lkps
1140: WHERE spat.person_id = p_person_id
1141: AND spat.person_id = sca.person_id
1142: AND spat.program_cd = sca.course_cd
1463: p_creation_dt IN OUT NOCOPY DATE ,
1464: p_charge_elements IN OUT NOCOPY igs_fi_fee_as_all.chg_elements%TYPE ,
1465: p_fee_assessment IN OUT NOCOPY NUMBER,
1466: p_charge_rate OUT NOCOPY IGS_FI_FEE_AS_RATE.chg_rate%TYPE,
1467: p_c_career IN igs_ps_ver_all.course_type%TYPE,
1468: p_elm_rng_order_name IN igs_fi_f_typ_ca_inst_all.elm_rng_order_name%TYPE,
1469: p_n_max_chg_elements IN igs_fi_fee_as_items.max_chg_elements%TYPE,
1470: p_n_called IN NUMBER) RETURN BOOLEAN AS
1471: /*************************************************************
1659: WHERE am.ATTENDANCE_MODE = cp_attendance_mode;
1660:
1661: -- To find the organization unit code from the Student Attempt Table (For Charge Method of
1662: -- FLATRATE)
1663: CURSOR c_resp_org_unit_cd(cp_course_cd IN igs_ps_ver_all.course_cd%TYPE,
1664: cp_version_number IN igs_ps_ver_all.version_number%TYPE ) IS
1665: SELECT responsible_org_unit_cd
1666: FROM igs_ps_ver_all v
1667: WHERE v.course_cd = cp_course_cd
1660:
1661: -- To find the organization unit code from the Student Attempt Table (For Charge Method of
1662: -- FLATRATE)
1663: CURSOR c_resp_org_unit_cd(cp_course_cd IN igs_ps_ver_all.course_cd%TYPE,
1664: cp_version_number IN igs_ps_ver_all.version_number%TYPE ) IS
1665: SELECT responsible_org_unit_cd
1666: FROM igs_ps_ver_all v
1667: WHERE v.course_cd = cp_course_cd
1668: AND v.version_number = cp_version_number;
1662: -- FLATRATE)
1663: CURSOR c_resp_org_unit_cd(cp_course_cd IN igs_ps_ver_all.course_cd%TYPE,
1664: cp_version_number IN igs_ps_ver_all.version_number%TYPE ) IS
1665: SELECT responsible_org_unit_cd
1666: FROM igs_ps_ver_all v
1667: WHERE v.course_cd = cp_course_cd
1668: AND v.version_number = cp_version_number;
1669:
1670: -- To find the organization unit code from the Unit Section Level
1682: p_rate_location_cd igs_fi_fee_as_rate.location_cd%TYPE,
1683: p_rate_attendance_type igs_fi_fee_as_rate.attendance_type%TYPE,
1684: p_rate_attendance_mode igs_fi_fee_as_rate.attendance_mode%TYPE,
1685: p_rate_class_standing IGS_PR_CLASS_STD.CLASS_STANDING%TYPE,
1686: p_rate_course_cd igs_ps_ver_all.course_cd%TYPE,
1687: p_rate_version_number igs_ps_ver_all.version_number%TYPE,
1688: p_rate_org_unit_cd igs_ps_unit_ver_all.owner_org_unit_cd%TYPE,
1689: p_rate_residency_status_cd igs_pe_res_dtls_all.residency_status_cd%TYPE,
1690: p_derived_location_cd igs_fi_fee_as_rate.location_cd%TYPE,
1683: p_rate_attendance_type igs_fi_fee_as_rate.attendance_type%TYPE,
1684: p_rate_attendance_mode igs_fi_fee_as_rate.attendance_mode%TYPE,
1685: p_rate_class_standing IGS_PR_CLASS_STD.CLASS_STANDING%TYPE,
1686: p_rate_course_cd igs_ps_ver_all.course_cd%TYPE,
1687: p_rate_version_number igs_ps_ver_all.version_number%TYPE,
1688: p_rate_org_unit_cd igs_ps_unit_ver_all.owner_org_unit_cd%TYPE,
1689: p_rate_residency_status_cd igs_pe_res_dtls_all.residency_status_cd%TYPE,
1690: p_derived_location_cd igs_fi_fee_as_rate.location_cd%TYPE,
1691: p_derived_attendance_type igs_fi_fee_as_rate.attendance_type%TYPE,
1691: p_derived_attendance_type igs_fi_fee_as_rate.attendance_type%TYPE,
1692: p_derived_govt_att_mode igs_en_atd_mode_all.govt_attendance_mode%TYPE,
1693: p_derived_prog_att_mode igs_en_atd_mode_all.attendance_mode%TYPE,
1694: p_derived_class_standing IGS_PR_CLASS_STD.CLASS_STANDING%TYPE,
1695: p_derived_course_cd igs_ps_ver_all.course_cd%TYPE,
1696: p_derived_version_number igs_ps_ver_all.version_number%TYPE,
1697: p_derived_org_unit_cd igs_ps_unit_ver_all.owner_org_unit_cd%TYPE,
1698: p_derived_residency_status_cd igs_pe_res_dtls_all.residency_status_cd%TYPE,
1699: p_rate_unit_set_cd igs_fi_fee_as_rate.unit_set_cd%TYPE,
1692: p_derived_govt_att_mode igs_en_atd_mode_all.govt_attendance_mode%TYPE,
1693: p_derived_prog_att_mode igs_en_atd_mode_all.attendance_mode%TYPE,
1694: p_derived_class_standing IGS_PR_CLASS_STD.CLASS_STANDING%TYPE,
1695: p_derived_course_cd igs_ps_ver_all.course_cd%TYPE,
1696: p_derived_version_number igs_ps_ver_all.version_number%TYPE,
1697: p_derived_org_unit_cd igs_ps_unit_ver_all.owner_org_unit_cd%TYPE,
1698: p_derived_residency_status_cd igs_pe_res_dtls_all.residency_status_cd%TYPE,
1699: p_rate_unit_set_cd igs_fi_fee_as_rate.unit_set_cd%TYPE,
1700: p_rate_us_version_num igs_fi_fee_as_rate.us_version_number%TYPE,
1918: p_derived_govt_att_mode OUT NOCOPY igs_en_atd_mode_all.govt_attendance_mode%TYPE,
1919: p_derived_prog_att_mode OUT NOCOPY igs_en_atd_mode_all.attendance_mode%TYPE, -- Added as part of 3795849
1920: p_derived_residency_status_cd OUT NOCOPY igs_pe_res_dtls_all.residency_status_cd%TYPE,
1921: p_derived_class_standing OUT NOCOPY IGS_PR_CLASS_STD.CLASS_STANDING%TYPE,
1922: p_c_career IN igs_ps_ver_all.course_type%TYPE,
1923: p_derived_unit_set_cd OUT NOCOPY igs_en_unit_set_all.unit_set_cd%TYPE,
1924: p_derived_us_version_num OUT NOCOPY igs_en_unit_set_all.version_number%TYPE
1925: ) RETURN BOOLEAN AS
1926: /*************************************************************
1961: -- Bug# 2122257, Modified the cursor select statement to include the audit table (IGS_FI_F_CAT_CAL_REL)
1962: -- for selecting Fee Category when it is changed.
1963: /* Modified by vchappid as a part of SFCR015 Build */
1964: -- cursor modified as per enh# 2162747, implemented as ref cursor
1965: TYPE derived_values_rec IS RECORD ( course_cd igs_ps_ver_all.course_cd%TYPE,
1966: course_type igs_ps_ver_all.course_type%TYPE);
1967: TYPE derived_values_ref IS REF CURSOR RETURN derived_values_rec;
1968: c_scafv derived_values_ref;
1969: l_c_scafv c_scafv%ROWTYPE;
1962: -- for selecting Fee Category when it is changed.
1963: /* Modified by vchappid as a part of SFCR015 Build */
1964: -- cursor modified as per enh# 2162747, implemented as ref cursor
1965: TYPE derived_values_rec IS RECORD ( course_cd igs_ps_ver_all.course_cd%TYPE,
1966: course_type igs_ps_ver_all.course_type%TYPE);
1967: TYPE derived_values_ref IS REF CURSOR RETURN derived_values_rec;
1968: c_scafv derived_values_ref;
1969: l_c_scafv c_scafv%ROWTYPE;
1970:
1967: TYPE derived_values_ref IS REF CURSOR RETURN derived_values_rec;
1968: c_scafv derived_values_ref;
1969: l_c_scafv c_scafv%ROWTYPE;
1970:
1971: l_c_course_cd igs_ps_ver_all.course_cd%TYPE;
1972:
1973: -- record type variable defined for geeting the attendance type and govt attendance mode when the
1974: -- nominated values are used
1975: TYPE l_der_nom_rec IS RECORD ( attendance_type igs_en_atd_type_all.attendance_type%TYPE,
2385: p_derived_prog_att_mode igs_en_atd_mode_all.attendance_mode%TYPE,
2386: p_trace_on VARCHAR2,
2387: p_derived_residency_status_cd igs_pe_res_dtls_all.residency_status_cd%TYPE,
2388: p_derived_org_unit_cd igs_ps_unit_ver_all.owner_org_unit_cd%TYPE,
2389: p_derived_course_cd igs_ps_ver_all.course_cd%TYPE,
2390: p_derived_version_number igs_ps_ver_all.version_number%TYPE,
2391: p_derived_class_standing IGS_PR_CLASS_STD.CLASS_STANDING%TYPE,
2392: p_charge_rate OUT NOCOPY IGS_FI_FEE_AS_RATE.chg_rate%TYPE,
2393: p_derived_unit_set_cd IN igs_fi_fee_as_rate.unit_set_cd%TYPE,
2386: p_trace_on VARCHAR2,
2387: p_derived_residency_status_cd igs_pe_res_dtls_all.residency_status_cd%TYPE,
2388: p_derived_org_unit_cd igs_ps_unit_ver_all.owner_org_unit_cd%TYPE,
2389: p_derived_course_cd igs_ps_ver_all.course_cd%TYPE,
2390: p_derived_version_number igs_ps_ver_all.version_number%TYPE,
2391: p_derived_class_standing IGS_PR_CLASS_STD.CLASS_STANDING%TYPE,
2392: p_charge_rate OUT NOCOPY IGS_FI_FEE_AS_RATE.chg_rate%TYPE,
2393: p_derived_unit_set_cd IN igs_fi_fee_as_rate.unit_set_cd%TYPE,
2394: p_derived_us_version_num IN igs_fi_fee_as_rate.us_version_number%TYPE,
2889: ORDER BY far.order_of_precedence;
2890:
2891: -- To find the organization unit code from the Prgoram Version Table (For Charge Method of
2892: -- FLATRATE)
2893: CURSOR c_resp_org_unit_cd(cp_course_cd IN igs_ps_ver_all.course_cd%TYPE,
2894: cp_version_number IN igs_ps_ver_all.version_number%TYPE
2895: )IS
2896: SELECT responsible_org_unit_cd
2897: FROM igs_ps_ver_all v
2890:
2891: -- To find the organization unit code from the Prgoram Version Table (For Charge Method of
2892: -- FLATRATE)
2893: CURSOR c_resp_org_unit_cd(cp_course_cd IN igs_ps_ver_all.course_cd%TYPE,
2894: cp_version_number IN igs_ps_ver_all.version_number%TYPE
2895: )IS
2896: SELECT responsible_org_unit_cd
2897: FROM igs_ps_ver_all v
2898: WHERE v.course_cd = cp_course_cd
2893: CURSOR c_resp_org_unit_cd(cp_course_cd IN igs_ps_ver_all.course_cd%TYPE,
2894: cp_version_number IN igs_ps_ver_all.version_number%TYPE
2895: )IS
2896: SELECT responsible_org_unit_cd
2897: FROM igs_ps_ver_all v
2898: WHERE v.course_cd = cp_course_cd
2899: AND v.version_number = cp_version_number;
2900:
2901: CURSOR cur_get_ret_level (cp_v_fee_type igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
2906: WHERE fee_type = cp_v_fee_type
2907: AND fee_cal_type = cp_v_fee_cal_type
2908: AND fee_ci_sequence_number = cp_n_fee_ci_sequence_num;
2909:
2910: l_v_derived_org_unit_cd igs_ps_ver_all.responsible_org_unit_cd%TYPE;
2911: l_rec_sub_rates cur_sub_elm_rng_rates%ROWTYPE;
2912: l_rec_global_rates c_elm_rng_rates%ROWTYPE;
2913: l_n_count NUMBER; -- Used like an index variable when a new record in added to the plsql table tbl_fai_unit_dtls
2914: l_v_party_number hz_parties.party_number%TYPE := NULL;
4519: p_test_run IN VARCHAR2 ,
4520: p_creation_dt IN OUT NOCOPY DATE ,
4521: p_message_name OUT NOCOPY VARCHAR2,
4522: p_process_mode IN VARCHAR2 ,
4523: p_c_career IN igs_ps_ver_all.course_type%TYPE,
4524: p_d_gl_date IN DATE,
4525: p_v_wav_calc_flag IN VARCHAR2,
4526: p_n_waiver_amount OUT NOCOPY NUMBER
4527: ) RETURN BOOLEAN AS
4685: sca.discontinued_dt,
4686: psv.short_title,
4687: esptv.key_program_flag
4688: FROM igs_en_spa_terms esptv,
4689: igs_ps_ver_all psv,
4690: igs_en_stdnt_ps_att_all sca,
4691: igs_lookups_view scas
4692: WHERE esptv.program_cd = psv.course_cd
4693: AND esptv.program_version = psv.version_number
4721: CURSOR cur_spa (cp_n_person_id hz_parties.party_id%TYPE,
4722: cp_v_load_cal_type igs_ca_inst_all.cal_type%TYPE,
4723: cp_n_load_ci_seq_num igs_ca_inst_all.sequence_number%TYPE,
4724: cp_v_key_program_flag igs_en_spa_terms.key_program_flag%TYPE,
4725: cp_v_course_type igs_ps_ver_all.course_type%TYPE,
4726: cp_v_lookup_type igs_lookups_view.lookup_type%TYPE,
4727: cp_v_fee_ass_ind igs_lookups_view.fee_ass_ind%TYPE,
4728: cp_v_fee_cat igs_en_spa_terms.fee_cat%TYPE) IS
4729: SELECT esptv.person_id,
4740: sca.discontinued_dt,
4741: psv.short_title,
4742: esptv.key_program_flag
4743: FROM igs_en_spa_terms esptv,
4744: igs_ps_ver_all psv,
4745: igs_en_stdnt_ps_att_all sca,
4746: igs_lookups_view scas
4747: WHERE esptv.program_cd = psv.course_cd
4748: AND esptv.program_version = psv.version_number
4978: p_n_scope_rul_seq_num igs_fi_fee_as_items.scope_rul_sequence_num%TYPE,
4979: p_v_chg_method_type igs_fi_fee_as_items.s_chg_method_type%TYPE,
4980: p_s_fee_trigger_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,
4981: p_v_location_cd igs_fi_fee_as_items.location_cd%TYPE,
4982: p_v_career igs_ps_ver_all.course_type%TYPE,
4983: p_elm_rng_order_name igs_fi_f_typ_ca_inst_all.elm_rng_order_name%TYPE,
4984: p_attendance_mode igs_fi_fee_as_items.attendance_mode%TYPE,
4985: p_attendance_type igs_fi_fee_as_items.attendance_type%TYPE,
4986: p_n_max_chg_elements igs_fi_fee_as_items.max_chg_elements%TYPE
5665: p_n_rul_sequence_number IN igs_fi_fee_as_items.rul_sequence_number%TYPE,
5666: p_n_scope_rul_seq_num IN igs_fi_fee_as_items.scope_rul_sequence_num%TYPE,
5667: p_v_chg_method_type IN igs_fi_fee_as_items.s_chg_method_type%TYPE,
5668: p_v_location_cd IN igs_fi_fee_as_items.location_cd%TYPE,
5669: p_v_career IN igs_ps_ver_all.course_type%TYPE,
5670: p_elm_rng_order_name IN igs_fi_f_typ_ca_inst_all.elm_rng_order_name%TYPE,
5671: p_n_max_chg_elements IN igs_fi_fee_as_items.max_chg_elements%TYPE) AS
5672:
5673: /*************************************************************************************************
6262: p_ret_true_flag OUT NOCOPY BOOLEAN,
6263: p_message_name OUT NOCOPY VARCHAR2,
6264: p_s_fee_trigger_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,
6265: p_uoo_id IGS_FI_FEE_AS_ITEMS.UOO_ID%TYPE,
6266: p_unit_course_cd igs_ps_ver_all.course_cd%TYPE,
6267: p_n_unit_type_id igs_fi_fee_as_items.unit_type_id%TYPE,
6268: p_v_unit_level igs_fi_fee_as_items.unit_level%TYPE,
6269: p_v_unit_mode igs_fi_fee_as_items.unit_mode%TYPE
6270: ) RETURN BOOLEAN AS
6325: AND uoo.unit_class = cp_unit_class;
6326:
6327: -- To find the organization unit code from the Prgoram Version Table (For Charge Method of
6328: -- FLATRATE)
6329: CURSOR c_resp_org_unit_cd(cp_course_cd IN igs_ps_ver_all.course_cd%TYPE,
6330: cp_version_number IN igs_ps_ver_all.version_number%TYPE
6331: )IS
6332: SELECT responsible_org_unit_cd
6333: FROM igs_ps_ver_all v
6326:
6327: -- To find the organization unit code from the Prgoram Version Table (For Charge Method of
6328: -- FLATRATE)
6329: CURSOR c_resp_org_unit_cd(cp_course_cd IN igs_ps_ver_all.course_cd%TYPE,
6330: cp_version_number IN igs_ps_ver_all.version_number%TYPE
6331: )IS
6332: SELECT responsible_org_unit_cd
6333: FROM igs_ps_ver_all v
6334: WHERE v.course_cd = cp_course_cd
6329: CURSOR c_resp_org_unit_cd(cp_course_cd IN igs_ps_ver_all.course_cd%TYPE,
6330: cp_version_number IN igs_ps_ver_all.version_number%TYPE
6331: )IS
6332: SELECT responsible_org_unit_cd
6333: FROM igs_ps_ver_all v
6334: WHERE v.course_cd = cp_course_cd
6335: AND v.version_number = cp_version_number;
6336:
6337: -- End of Additions made by schodava as a part of Fee Calc CCR
6705: p_s_fee_trigger_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,
6706: p_charge_elements IN OUT NOCOPY igs_fi_fee_as_all.chg_elements%TYPE,
6707: p_message_name OUT NOCOPY VARCHAR2,
6708: p_location_cd IGS_FI_FEE_AS_ITEMS.LOCATION_CD%TYPE,
6709: p_c_career igs_ps_ver_all.course_type%TYPE,
6710: p_n_selection_rule IN igs_ru_rule.sequence_number%TYPE
6711: )
6712: RETURN BOOLEAN AS
6713: /*************************************************************
6795:
6796: -- cursor to find student unit attempt for a course in context and in the given term.
6797: -- Enh# 3741400, igs_en_get_suaeh_dtl.enrp_get_suaeh_eff_st is replaced with SYSDATE
6798: CURSOR c_sua_load ( cp_person_id hz_parties.party_id%TYPE,
6799: cp_course_cd igs_ps_ver_all.course_cd%TYPE,
6800: cp_course_version igs_ps_ver_all.version_number%TYPE,
6801: cp_load_cal_type igs_ca_inst_all.cal_type%TYPE,
6802: cp_load_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,
6803: cp_v_fee_ass_ind VARCHAR2,
6796: -- cursor to find student unit attempt for a course in context and in the given term.
6797: -- Enh# 3741400, igs_en_get_suaeh_dtl.enrp_get_suaeh_eff_st is replaced with SYSDATE
6798: CURSOR c_sua_load ( cp_person_id hz_parties.party_id%TYPE,
6799: cp_course_cd igs_ps_ver_all.course_cd%TYPE,
6800: cp_course_version igs_ps_ver_all.version_number%TYPE,
6801: cp_load_cal_type igs_ca_inst_all.cal_type%TYPE,
6802: cp_load_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,
6803: cp_v_fee_ass_ind VARCHAR2,
6804: cp_v_lookup_type igs_lookup_values.lookup_type%TYPE,
6877: ) = cp_v_enrp_get_load_apply;
6878:
6879: -- Added by schodava as a part of the CCR for the Fee Calc (Enh # 1851586) DLD
6880: -- To find the organization unit code from the Program Version Table (For Charge Method of 'FLATRATE','EFTSU','PERUNIT','CREDIT POINT')
6881: CURSOR c_resp_org_unit_cd(cp_course_cd IN igs_ps_ver_all.course_cd%TYPE,
6882: cp_version_number IN igs_ps_ver_all.version_number%TYPE
6883: )IS
6884: SELECT responsible_org_unit_cd
6885: FROM igs_ps_ver_all v
6878:
6879: -- Added by schodava as a part of the CCR for the Fee Calc (Enh # 1851586) DLD
6880: -- To find the organization unit code from the Program Version Table (For Charge Method of 'FLATRATE','EFTSU','PERUNIT','CREDIT POINT')
6881: CURSOR c_resp_org_unit_cd(cp_course_cd IN igs_ps_ver_all.course_cd%TYPE,
6882: cp_version_number IN igs_ps_ver_all.version_number%TYPE
6883: )IS
6884: SELECT responsible_org_unit_cd
6885: FROM igs_ps_ver_all v
6886: WHERE v.course_cd = cp_course_cd
6881: CURSOR c_resp_org_unit_cd(cp_course_cd IN igs_ps_ver_all.course_cd%TYPE,
6882: cp_version_number IN igs_ps_ver_all.version_number%TYPE
6883: )IS
6884: SELECT responsible_org_unit_cd
6885: FROM igs_ps_ver_all v
6886: WHERE v.course_cd = cp_course_cd
6887: AND v.version_number = cp_version_number;
6888:
6889: -- Enh# 3167098, Removed references to igs_fi_f_cat_cal_rel and igs_fi_cng_fcat_lbl_sca_pr_v in following cursor.
6905: spat.attendance_type,
6906: ps.course_type
6907: FROM igs_en_spa_terms spat,
6908: igs_en_stdnt_ps_att_all sca,
6909: igs_ps_ver_all ps,
6910: igs_lookups_view lkps
6911: WHERE spat.person_id = p_person_id
6912: AND spat.person_id = sca.person_id
6913: AND spat.program_cd = sca.course_cd
6945: AND fee_cal_type = cp_v_fee_cal_type
6946: AND fee_ci_sequence_number = cp_n_fee_ci_sequence_num;
6947:
6948: CURSOR cur_unit_set (cp_person_id hz_parties.party_id%TYPE,
6949: cp_course_cd igs_ps_ver_all.course_cd%TYPE,
6950: cp_effective_dt DATE,
6951: cp_v_student_confirmed_ind igs_as_su_setatmpt.student_confirmed_ind%TYPE,
6952: cp_v_s_unit_set_cat igs_en_unit_set_cat.s_unit_set_cat%TYPE) IS
6953: SELECT asu.unit_set_cd,
7730: p_discontinued_dt igs_en_stdnt_ps_att_all.discontinued_dt%TYPE,
7731: p_course_attempt_status igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
7732: p_message_name OUT NOCOPY VARCHAR2,
7733: p_process_mode IN VARCHAR2 ,
7734: p_c_career IN igs_ps_ver_all.course_type%TYPE,
7735: p_waiver_call_ind IN VARCHAR2,
7736: p_target_fee_type IN VARCHAR2
7737: ) RETURN BOOLEAN AS
7738: /*************************************************************
7918: ast.max_chg_elements
7919: FROM igs_fi_fee_as_items ast,
7920: igs_fi_fee_as_all fas,
7921: igs_fi_fee_type_all ft,
7922: igs_ps_ver_all ps
7923: WHERE ast.person_id = p_person_id
7924: AND (p_fee_type IS NULL OR (p_fee_type IS NOT NULL AND ast.fee_type = p_fee_type))-- will reverse existing charges only when user has not provided Fee Type as input
7925: AND ps.course_cd (+) = ast.course_cd
7926: AND ps.version_number (+) = ast.crs_version_number
7967: spt.attendance_mode,
7968: spt.attendance_type
7969: FROM igs_en_spa_terms spt,
7970: igs_en_stdnt_ps_att_all spa,
7971: igs_ps_ver_all ps,
7972: igs_lookups_view lkps
7973: WHERE spt.person_id = spa.person_id
7974: AND spt.program_cd = spa.course_cd
7975: AND spt.program_version = spa.version_number
8006: p_fee_ci_sequence_number IGS_FI_FEE_AS_ITEMS.fee_ci_sequence_number%TYPE,
8007: p_course_cd IGS_FI_FEE_AS_ITEMS.course_cd%TYPE,
8008: p_effective_date DATE,
8009: p_trace_on VARCHAR2,
8010: p_c_career igs_ps_ver_all.course_type%TYPE)
8011: RETURN BOOLEAN
8012: AS
8013: /*************************************************************
8014: Created By :syam shankar
8053: cp_fee_type igs_fi_fee_as_items.fee_type%TYPE ,
8054: cp_fee_cal_type igs_fi_fee_as_items.fee_cal_type%TYPE,
8055: cp_fee_ci_sequence_number igs_fi_fee_as_items.fee_ci_sequence_number%TYPE,
8056: cp_course_cd igs_fi_fee_as_items.course_cd%TYPE,
8057: cp_career igs_ps_ver_all.course_type%TYPE,
8058: cp_s_trigger_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,
8059: cp_v_s_transaction_type1 igs_fi_fee_as_all.s_transaction_type%TYPE,
8060: cp_v_s_transaction_type2 igs_fi_fee_as_all.s_transaction_type%TYPE
8061: ) IS
8069: a.org_unit_cd,
8070: a.uoo_id,
8071: a.fee_cat
8072: FROM igs_fi_fee_as_items a,
8073: igs_ps_ver_all ps
8074: WHERE a.course_cd = ps.course_cd (+)
8075: AND a.crs_version_number = ps.version_number (+)
8076: AND a.person_id = cp_person_id
8077: AND a.fee_type = cp_fee_type
8170: cp_fee_type igs_fi_fee_as_all.fee_type%TYPE,
8171: cp_course_cd igs_fi_fee_as_all.course_cd%TYPE,
8172: cp_fee_cal_type igs_fi_fee_as_all.fee_cal_type%TYPE,
8173: cp_fee_ci_Sequence_number igs_fi_fee_as_all.fee_ci_sequence_number%TYPE,
8174: cp_career igs_ps_ver_all.course_type%TYPE) IS
8175:
8176: SELECT a.fee_ass_item_id upd,
8177: a.s_chg_method_type
8178: FROM igs_fi_fee_as_items a,
8175:
8176: SELECT a.fee_ass_item_id upd,
8177: a.s_chg_method_type
8178: FROM igs_fi_fee_as_items a,
8179: igs_ps_ver_all ps
8180: WHERE a.course_cd = ps.course_cd (+)
8181: AND a.crs_version_number = ps.version_number (+)
8182: AND a.person_id = cp_person_id
8183: AND a.fee_type = cp_fee_type
9138: App_Exception.Raise_Exception;
9139: END finpl_prc_fee_cat_fee_liab;
9140:
9141: PROCEDURE finpl_prc_predictive_scas ( p_n_person_id IN igs_fi_fee_as_items.person_id%TYPE,
9142: p_v_course_cd IN igs_ps_ver_all.course_cd%TYPE,
9143: p_v_career IN igs_ps_ver_all.course_type%TYPE,
9144: p_v_fee_category IN igs_fi_fee_cat_all.fee_cat%TYPE,
9145: p_v_fee_cal_type IN igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
9146: p_n_fee_ci_sequence_num IN igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE,
9139: END finpl_prc_fee_cat_fee_liab;
9140:
9141: PROCEDURE finpl_prc_predictive_scas ( p_n_person_id IN igs_fi_fee_as_items.person_id%TYPE,
9142: p_v_course_cd IN igs_ps_ver_all.course_cd%TYPE,
9143: p_v_career IN igs_ps_ver_all.course_type%TYPE,
9144: p_v_fee_category IN igs_fi_fee_cat_all.fee_cat%TYPE,
9145: p_v_fee_cal_type IN igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
9146: p_n_fee_ci_sequence_num IN igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE,
9147: p_v_curr_cd IN igs_fi_control_all.currency_cd%TYPE,
9168: ***************************************************************/
9169:
9170: TYPE prd_prog_details_rec_typ IS RECORD (
9171: person_id hz_parties.party_id%TYPE,
9172: program_cd igs_ps_ver_all.course_cd%TYPE,
9173: program_version igs_ps_ver_all.version_number%TYPE,
9174: career igs_ps_ver_all.course_type%TYPE,
9175: fee_cat igs_fi_fee_cat_all.fee_cat%TYPE,
9176: crs_cal_type igs_en_stdnt_ps_att_all.cal_type%TYPE,
9169:
9170: TYPE prd_prog_details_rec_typ IS RECORD (
9171: person_id hz_parties.party_id%TYPE,
9172: program_cd igs_ps_ver_all.course_cd%TYPE,
9173: program_version igs_ps_ver_all.version_number%TYPE,
9174: career igs_ps_ver_all.course_type%TYPE,
9175: fee_cat igs_fi_fee_cat_all.fee_cat%TYPE,
9176: crs_cal_type igs_en_stdnt_ps_att_all.cal_type%TYPE,
9177: location_cd igs_en_stdnt_ps_att_all.location_cd%TYPE,
9170: TYPE prd_prog_details_rec_typ IS RECORD (
9171: person_id hz_parties.party_id%TYPE,
9172: program_cd igs_ps_ver_all.course_cd%TYPE,
9173: program_version igs_ps_ver_all.version_number%TYPE,
9174: career igs_ps_ver_all.course_type%TYPE,
9175: fee_cat igs_fi_fee_cat_all.fee_cat%TYPE,
9176: crs_cal_type igs_en_stdnt_ps_att_all.cal_type%TYPE,
9177: location_cd igs_en_stdnt_ps_att_all.location_cd%TYPE,
9178: att_mode igs_en_stdnt_ps_att_all.attendance_mode%TYPE,
9200: --Enh 3988455: Uptake of Program Transfer Enhancements
9201: --Cursor modified to ignore program attempts with Future-Dated Transfer flag set to 'C'
9202: CURSOR c_get_term_recs(cp_n_person_id igs_fi_fee_as_items.person_id%TYPE,
9203: cp_v_fee_category igs_fi_fee_cat_all.fee_cat%TYPE,
9204: cp_v_course_cd igs_ps_ver_all.course_cd%TYPE,
9205: cp_v_career igs_ps_ver_all.course_type%TYPE,
9206: cp_v_key_program_flag igs_en_spa_terms.key_program_flag%TYPE,
9207: cp_v_course_attempt_status1 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9208: cp_v_course_attempt_status2 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9201: --Cursor modified to ignore program attempts with Future-Dated Transfer flag set to 'C'
9202: CURSOR c_get_term_recs(cp_n_person_id igs_fi_fee_as_items.person_id%TYPE,
9203: cp_v_fee_category igs_fi_fee_cat_all.fee_cat%TYPE,
9204: cp_v_course_cd igs_ps_ver_all.course_cd%TYPE,
9205: cp_v_career igs_ps_ver_all.course_type%TYPE,
9206: cp_v_key_program_flag igs_en_spa_terms.key_program_flag%TYPE,
9207: cp_v_course_attempt_status1 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9208: cp_v_course_attempt_status2 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9209: cp_v_course_attempt_status3 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9224: sca.commencement_dt,
9225: sca.discontinued_dt
9226: FROM igs_en_spa_terms spat,
9227: igs_en_stdnt_ps_att_all sca,
9228: igs_ps_ver_all psv
9229: WHERE spat.program_cd = psv.course_cd
9230: AND spat.program_version = psv.version_number
9231: AND spat.person_id = cp_n_person_id
9232: AND spat.program_cd = sca.course_cd
9263: --Enh 3988455: Uptake of Program Transfer Enhancements
9264: --Cursor modified to ignore program attempts with Future-Dated Transfer flag set to 'C'
9265: CURSOR c_get_scas_recs(cp_n_person_id igs_fi_fee_as_items.person_id%TYPE,
9266: cp_v_fee_cat igs_fi_fee_cat_all.fee_cat%TYPE,
9267: cp_v_course_cd igs_ps_ver_all.course_cd%TYPE,
9268: cp_v_career igs_ps_ver_all.course_type%TYPE,
9269: cp_v_primary_program_type igs_en_stdnt_ps_att_all.primary_program_type%TYPE,
9270: cp_v_key_program igs_en_stdnt_ps_att_all.key_program%TYPE,
9271: cp_v_course_attempt_status1 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9264: --Cursor modified to ignore program attempts with Future-Dated Transfer flag set to 'C'
9265: CURSOR c_get_scas_recs(cp_n_person_id igs_fi_fee_as_items.person_id%TYPE,
9266: cp_v_fee_cat igs_fi_fee_cat_all.fee_cat%TYPE,
9267: cp_v_course_cd igs_ps_ver_all.course_cd%TYPE,
9268: cp_v_career igs_ps_ver_all.course_type%TYPE,
9269: cp_v_primary_program_type igs_en_stdnt_ps_att_all.primary_program_type%TYPE,
9270: cp_v_key_program igs_en_stdnt_ps_att_all.key_program%TYPE,
9271: cp_v_course_attempt_status1 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9272: cp_v_course_attempt_status2 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9289: sca.adm_admission_appl_number,
9290: sca.adm_nominated_course_cd,
9291: sca.adm_sequence_number
9292: FROM igs_en_stdnt_ps_att_all sca,
9293: igs_ps_ver_all psv
9294: WHERE sca.course_cd = psv.course_cd
9295: AND sca. version_number = psv.version_number
9296: AND sca.person_id = cp_n_person_id
9297: AND (cp_v_fee_cat IS NULL OR sca.fee_cat = cp_v_fee_cat)
9325: l_b_rec_found_at_terms BOOLEAN;
9326: l_b_prog_att_liable BOOLEAN;
9327: l_n_cntr NUMBER;
9328:
9329: FUNCTION find_record_exists ( p_v_course_cd IN igs_ps_ver_all.course_cd%TYPE,
9330: p_v_career IN igs_ps_ver_all.course_type%TYPE ) RETURN BOOLEAN IS
9331: /*************************************************************
9332: Created By : Shirish Tatikonda
9333: Date Created By : 30-DEC-2003
9326: l_b_prog_att_liable BOOLEAN;
9327: l_n_cntr NUMBER;
9328:
9329: FUNCTION find_record_exists ( p_v_course_cd IN igs_ps_ver_all.course_cd%TYPE,
9330: p_v_career IN igs_ps_ver_all.course_type%TYPE ) RETURN BOOLEAN IS
9331: /*************************************************************
9332: Created By : Shirish Tatikonda
9333: Date Created By : 30-DEC-2003
9334: Purpose : Function to check whether the given course/career is already existing in the table.
9383: l_v_message_name fnd_new_messages.message_name%TYPE;
9384:
9385: -- Cursor to get latest intermission end date.
9386: CURSOR c_latest_intermit_date ( cp_n_person_id igs_en_stdnt_ps_intm.person_id%TYPE,
9387: cp_v_course_cd igs_ps_ver_all.course_cd%TYPE,
9388: cp_logical_delete_date igs_en_stdnt_ps_intm.logical_delete_date%TYPE) IS
9389: SELECT sci.end_dt
9390: FROM igs_en_stdnt_ps_intm sci,
9391: IGS_EN_INTM_TYPES eit
10749: END ;
10750: END finp_ins_enr_fee_ass;
10751:
10752: FUNCTION finpl_insert_record(p_n_person_id IN igs_fi_fee_as_all.person_id%TYPE,
10753: p_v_course_cd IN igs_ps_ver_all.course_cd%TYPE,
10754: p_v_fee_cal_type IN igs_fi_fee_as_all.fee_cal_type%TYPE,
10755: p_n_fee_ci_sequence_number IN igs_fi_fee_as_all.fee_ci_sequence_number%TYPE)
10756: RETURN BOOLEAN
10757: IS
10805: END finpl_insert_record;
10806:
10807:
10808: FUNCTION finpl_lock_records(p_n_person_id IN igs_fi_fee_as_all.person_id%TYPE,
10809: p_v_course_cd IN igs_ps_ver_all.course_cd%TYPE,
10810: p_v_fee_cal_type IN igs_fi_fee_as_all.fee_cal_type%TYPE,
10811: p_n_fee_ci_sequence_number IN igs_fi_fee_as_all.fee_ci_sequence_number%TYPE)
10812: RETURN BOOLEAN IS
10813: /*************************************************************