[Home] [Help]
171: ***************************************************************/
172: --
173: X_ROWID VARCHAR2(25);
174: v_fa_sequence_number igs_fi_fee_as_all.transaction_id%TYPE;
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,
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,
349: p_course_cd IN igs_ps_course.course_cd%TYPE,
350: p_effective_dt IN DATE,
351: p_fee_cal_type IN igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
352: p_fee_ci_sequence_number IN igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,
375: p_trace_on IN VARCHAR2);
376:
377: FUNCTION finp_clc_ass_amnt(
378: p_effective_dt IN DATE ,
379: p_person_id IN hz_parties.party_id%TYPE ,
380: p_course_cd IN igs_en_stdnt_ps_att_all.course_cd%TYPE ,
381: p_course_version_number IN igs_en_stdnt_ps_att_all.version_number%TYPE ,
382: p_course_attempt_status IN VARCHAR2 ,
383: p_fee_type IN igs_fi_f_cat_fee_lbl_all.fee_type%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:
404:
405: FUNCTION finpl_get_org_unit_cd(p_n_party_id IN hz_parties.party_id%TYPE) RETURN VARCHAR2;
406:
407: FUNCTION get_stdnt_res_status_cd ( p_n_person_id IN igs_en_stdnt_ps_att_all.person_id%TYPE) RETURN VARCHAR2 AS
408: /*************************************************************
409: Created By : Shirish Tatikonda
545: shtatiko 30-DEC-2003 Enh# 3167098, Created this function.
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
1067: END finpl_clc_sua_cp;
1068:
1069: -----------------------------------------------------------------------------------
1070: FUNCTION finpl_get_derived_am_at (
1071: p_person_id hz_parties.party_id%TYPE,
1072: p_course_cd IGS_PS_COURSE.course_cd%TYPE,
1073: p_effective_dt DATE,
1074: p_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
1075: p_fee_ci_sequence_number igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,
1443: END finpl_get_derived_am_at;
1444: -----------------------------------------------------------------------------------
1445:
1446: FUNCTION finp_clc_ass_amnt( p_effective_dt IN DATE ,
1447: p_person_id IN hz_parties.party_id%TYPE ,
1448: p_course_cd IN igs_en_stdnt_ps_att_all.course_cd%TYPE ,
1449: p_course_version_number IN igs_en_stdnt_ps_att_all.version_number%TYPE ,
1450: p_course_attempt_status IN VARCHAR2 ,
1451: p_fee_type IN igs_fi_f_cat_fee_lbl_all.fee_type%TYPE ,
1531: v_derived_govt_att_mode igs_en_atd_mode_all.govt_attendance_mode%TYPE;
1532: l_v_derived_prog_att_mode igs_en_atd_mode_all.attendance_mode%TYPE;
1533:
1534: v_derived_residency_status_cd igs_fi_fee_as_rate.residency_status_cd%TYPE;
1535: v_derived_org_unit_cd hz_parties.party_number%TYPE;
1536: v_derived_class_standing igs_fi_fee_as_rate.class_standing%TYPE;
1537:
1538: v_derived_unit_set_cd igs_fi_fee_as_rate.unit_set_cd%TYPE := NULL;
1539: v_derived_us_version_num igs_fi_fee_as_rate.us_version_number%TYPE := NULL;
1905: END finpl_ins_match_chg_rate;
1906:
1907: -------------------------------------------------------------------------------
1908: FUNCTION finpl_get_derived_values (
1909: p_person_id hz_parties.party_id%TYPE,
1910: p_course_cd IGS_PS_COURSE.course_cd%TYPE,
1911: p_effective_dt DATE,
1912: p_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
1913: p_fee_ci_sequence_number igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,
2369:
2370:
2371: -------------------------------------------------------------------------------
2372: PROCEDURE finpl_find_far(
2373: p_person_id hz_parties.party_id%TYPE,
2374: p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
2375: p_fee_cat IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE,
2376: p_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
2377: p_fee_ci_sequence_number igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,
2504: ORDER BY far.order_of_precedence ASC;
2505:
2506: l_c_ftfarv1 c_ftfarv1%ROWTYPE;
2507: l_b_cursor BOOLEAN;
2508: l_v_party_number hz_parties.party_number%TYPE := NULL;
2509: l_v_level_code igs_ps_unit_type_lvl.level_code%TYPE;
2510:
2511: BEGIN
2512: log_to_fnd( p_v_module => 'finpl_find_far',
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;
2915: l_n_loop_subelm_rng NUMBER;
2916: l_n_previous_upper igs_fi_sub_elm_rng.sub_upper_range%TYPE;
2917: l_v_lower_nrml_rate_ovrd_ind IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE;
2918: l_n_cfar_chg_rate IGS_FI_FEE_AS_RT.chg_rate%TYPE;
4714: ORDER BY esptv.fee_cat, esptv.person_id, esptv.program_cd;
4715:
4716: CURSOR cur_person_name (cp_n_person_id PLS_INTEGER) IS
4717: SELECT party_name
4718: FROM hz_parties p
4719: WHERE p.party_id = cp_n_person_id;
4720:
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,
4717: SELECT party_name
4718: FROM hz_parties p
4719: WHERE p.party_id = cp_n_person_id;
4720:
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,
4759: AND scas.lookup_type = cp_v_lookup_type
4760: AND scas.fee_ass_ind = cp_v_fee_ass_ind
4761: AND esptv.fee_cat = cp_v_fee_cat;
4762:
4763: l_v_person_name hz_parties.party_name%TYPE;
4764: l_v_currency_cd igs_fi_fee_cat_all.currency_cd%TYPE;
4765:
4766: TYPE t_fee_type_typ IS TABLE OF igs_fi_fee_type_all.fee_type%TYPE INDEX BY BINARY_INTEGER;
4767: tbl_fee_type t_fee_type_typ;
5042: SELECT fai.*
5043: FROM igs_fi_fai_dtls fai
5044: WHERE fee_ass_item_id = cp_n_fee_ass_item_id;
5045:
5046: CURSOR cur_dropped_unit (cp_person_id hz_parties.party_id%TYPE,
5047: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,
5048: cp_v_fee_ass_ind VARCHAR2,
5049: cp_v_lookup_type igs_lookups_view.lookup_type%TYPE,
5050: cp_v_enrp_get_load_apply VARCHAR2,
5069: AND sua.uoo_id = cp_n_uoo_id
5070: AND (igs_fi_gen_008.chk_unit_prg_transfer(sua.dcnt_reason_cd) = 'N')
5071: ORDER BY sua.discontinued_dt;
5072:
5073: CURSOR cur_enr_date (cp_person_id hz_parties.party_id%TYPE,
5074: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,
5075: cp_n_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS
5076: SELECT sua.enrolled_dt
5077: FROM igs_en_su_attempt_all sua
5078: WHERE sua.uoo_id = cp_n_uoo_id
5079: AND sua.person_id = cp_person_id
5080: AND sua.course_cd = cp_course_cd;
5081:
5082: CURSOR cur_disc_dt (cp_n_person_id hz_parties.party_id%TYPE,
5083: cp_v_course_cd igs_en_su_attempt_all.course_cd%TYPE,
5084: cp_n_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS
5085: SELECT sua.dcnt_reason_cd
5086: FROM igs_en_su_attempt_all sua
5641: app_exception.raise_exception;
5642: END finpl_chk_debt_ret_sched;
5643:
5644: PROCEDURE finpl_ins_fee_ass(
5645: p_person_id hz_parties.party_id%TYPE,
5646: p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
5647: p_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE,
5648: p_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
5649: p_fee_ci_sequence_number igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,
6238: -------------------------------------------------------------------------------
6239: FUNCTION finpl_prc_sua_load (
6240: p_effective_dt DATE,
6241: p_trace_on VARCHAR2,
6242: p_person_id hz_parties.party_id%TYPE,
6243: p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
6244: p_course_version_number igs_en_stdnt_ps_att_all.version_number%TYPE,
6245: p_unit_cd igs_en_su_attempt_h_all.unit_cd%TYPE,
6246: p_unit_version_number igs_en_su_attempt_h_all.version_number%TYPE,
6762:
6763: -- Enh#2162747, Modified the cursor, removed the eftsu and credit point calculation, same function is invoked to calculate EFTSU, CREDIT POINTS
6764: -- when the the charge method is either EFTSU or CREDIT POINTS
6765: -- Enh# 3167098, modified following cursor
6766: CURSOR c_sualv_scafv (cp_person_id hz_parties.party_id%TYPE,
6767: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,
6768: cp_v_fee_ass_ind VARCHAR2,
6769: cp_v_lookup_type igs_lookups_view.lookup_type%TYPE,
6770: cp_v_fee_ass_indicator igs_lookups_view.fee_ass_ind%TYPE) IS
6794: AND uoo.uoo_id = sua.uoo_id;
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,
6944: WHERE fee_type = cp_v_fee_type
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
7719: p_fee_cal_type igs_ca_inst_all.cal_type%TYPE,
7720: p_fee_ci_sequence_num igs_ca_inst_all.sequence_number%TYPE,
7721: p_local_currency igs_fi_control_all.currency_cd%TYPE,
7722: p_fee_cat igs_en_stdnt_ps_att_all.fee_cat%tYPE,
7723: p_person_id hz_parties.party_id%TYPE,
7724: p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
7725: p_course_version_number igs_en_stdnt_ps_att_all.version_number%TYPE,
7726: p_cal_type igs_en_stdnt_ps_att_all.cal_type%TYPE,
7727: p_scahv_location_cd igs_en_stdnt_ps_att_all.location_cd%TYPE,
9167: shtatiko 30-DEC-2003 Enh# 3167098, Created this function.
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,
11217:
11218: END create_retention_charge;
11219:
11220:
11221: FUNCTION finpl_get_org_unit_cd(p_n_party_id IN hz_parties.party_id%TYPE) RETURN VARCHAR2 AS
11222: /*************************************************************
11223: Created By : Priya Athipatla
11224: Date Created By : 10-Oct-2005
11225: Purpose : Function to return the Party Number for an Organization
11228: Who When What
11229: ***************************************************************/
11230:
11231: -- Cursor to fetch the Org Unit Cd
11232: CURSOR cur_org_unit_cd(cp_n_party_id hz_parties.party_id%TYPE) IS
11233: SELECT party_number
11234: FROM igs_or_inst_org_base_v
11235: WHERE party_id = cp_n_party_id;
11236: