[Home] [Help]
92: FUNCTION validate_input_parameters(
93: p_person_id IN igs_pe_person.person_id%TYPE,
94: p_person_id_grp IN igs_pe_prsid_grp_mem_v.group_id%TYPE,
95: p_fee_period IN VARCHAR2,
96: p_fee_cal_type IN igs_fi_inv_int.fee_cal_type%TYPE,
97: p_fee_ci_sequence_number IN igs_fi_inv_int.fee_ci_sequence_number%TYPE,
98: p_balance_type IN igs_fi_balance_rules.balance_name%TYPE,
99: p_dcnt_reason_cd IN igs_en_dcnt_reasoncd_v.discontinuation_reason_cd%TYPE,
100: p_test_run IN VARCHAR2
93: p_person_id IN igs_pe_person.person_id%TYPE,
94: p_person_id_grp IN igs_pe_prsid_grp_mem_v.group_id%TYPE,
95: p_fee_period IN VARCHAR2,
96: p_fee_cal_type IN igs_fi_inv_int.fee_cal_type%TYPE,
97: p_fee_ci_sequence_number IN igs_fi_inv_int.fee_ci_sequence_number%TYPE,
98: p_balance_type IN igs_fi_balance_rules.balance_name%TYPE,
99: p_dcnt_reason_cd IN igs_en_dcnt_reasoncd_v.discontinuation_reason_cd%TYPE,
100: p_test_run IN VARCHAR2
101: ) RETURN BOOLEAN IS
333: -- and the records do not have waiver details
334:
335: CURSOR cur_person_chrgs(cp_n_person_id IN hz_parties.party_id%type,
336: cp_v_balance_type IN igs_fi_balance_rules.balance_name%TYPE,
337: cp_v_fee_cal_type IN igs_fi_inv_int_all.fee_cal_type%TYPE,
338: cp_n_fee_ci_sequence_number IN igs_fi_inv_int_all.fee_ci_sequence_number%TYPE
339: ) IS
340: SELECT hd.person_id person_id,
341: ln.uoo_id uoo_id,
334:
335: CURSOR cur_person_chrgs(cp_n_person_id IN hz_parties.party_id%type,
336: cp_v_balance_type IN igs_fi_balance_rules.balance_name%TYPE,
337: cp_v_fee_cal_type IN igs_fi_inv_int_all.fee_cal_type%TYPE,
338: cp_n_fee_ci_sequence_number IN igs_fi_inv_int_all.fee_ci_sequence_number%TYPE
339: ) IS
340: SELECT hd.person_id person_id,
341: ln.uoo_id uoo_id,
342: hd.course_cd,
345: hd.fee_cal_type,
346: hd.fee_ci_sequence_number,
347: hd.invoice_id,
348: hd.invoice_amount_due
349: FROM igs_fi_inv_int_all hd,
350: igs_fi_invln_int_v ln
351: WHERE hd.invoice_id = ln.invoice_id
352: AND hd.transaction_type = g_transaction_type
353: AND hd.person_id = cp_n_person_id
365: ORDER BY person_id,course_cd, uoo_id,invoice_creation_date;
366:
367: CURSOR cur_person_group_chrgs(cp_n_person_id_grp IN igs_pe_prsid_grp_mem_all.group_id%TYPE,
368: cp_v_balance_type IN igs_fi_balance_rules.balance_name%TYPE,
369: cp_v_fee_cal_type IN igs_fi_inv_int_all.fee_cal_type%TYPE,
370: cp_n_fee_ci_sequence_number IN igs_fi_inv_int_all.fee_ci_sequence_number%TYPE
371: ) IS
372: SELECT hd.person_id person_id,
373: ln.uoo_id uoo_id,
366:
367: CURSOR cur_person_group_chrgs(cp_n_person_id_grp IN igs_pe_prsid_grp_mem_all.group_id%TYPE,
368: cp_v_balance_type IN igs_fi_balance_rules.balance_name%TYPE,
369: cp_v_fee_cal_type IN igs_fi_inv_int_all.fee_cal_type%TYPE,
370: cp_n_fee_ci_sequence_number IN igs_fi_inv_int_all.fee_ci_sequence_number%TYPE
371: ) IS
372: SELECT hd.person_id person_id,
373: ln.uoo_id uoo_id,
374: hd.course_cd,
377: hd.fee_cal_type,
378: hd.fee_ci_sequence_number,
379: hd.invoice_id,
380: hd.invoice_amount_due
381: FROM igs_fi_inv_int_all hd,
382: igs_fi_invln_int_v ln
383: WHERE hd.invoice_id = ln.invoice_id
384: AND hd.transaction_type = g_transaction_type
385: AND hd.person_id IN (SELECT person_id
400: ORDER BY person_id,course_cd, uoo_id,invoice_creation_date;
401:
402:
403: CURSOR cur_all_person_chrgs(cp_v_balance_type IN igs_fi_balance_rules.balance_name%TYPE,
404: cp_v_fee_cal_type IN Igs_fi_inv_int_all.fee_cal_type%TYPE,
405: cp_n_fee_ci_sequence_number IN Igs_fi_inv_int_all.fee_ci_sequence_number%TYPE
406: ) IS
407: SELECT hd.person_id person_id,
408: ln.uoo_id uoo_id,
401:
402:
403: CURSOR cur_all_person_chrgs(cp_v_balance_type IN igs_fi_balance_rules.balance_name%TYPE,
404: cp_v_fee_cal_type IN Igs_fi_inv_int_all.fee_cal_type%TYPE,
405: cp_n_fee_ci_sequence_number IN Igs_fi_inv_int_all.fee_ci_sequence_number%TYPE
406: ) IS
407: SELECT hd.person_id person_id,
408: ln.uoo_id uoo_id,
409: hd.course_cd,
412: hd.fee_cal_type,
413: hd.fee_ci_sequence_number,
414: hd.invoice_id,
415: hd.invoice_amount_due
416: FROM igs_fi_inv_int_all hd,
417: igs_fi_invln_int_v ln
418: WHERE hd.invoice_id = ln.invoice_id
419: AND hd.transaction_type = g_transaction_type
420: AND hd.invoice_amount_due > 0
461: -- Enh # 2187247
462: -- Modified the cursor
463: -- Removed the subquery as it was redundant
464: CURSOR cur_course_version(p_person_id IN igs_pe_person.person_id%TYPE,
465: p_course_cd IN igs_fi_inv_int.course_cd%TYPE
466: ) IS
467: SELECT ps.course_cd, ps.version_number
468: FROM igs_en_stdnt_ps_att ps
469: WHERE ps.person_id = p_person_id
481: -- Declaration of local variables
482:
483: l_uoo_id igs_fi_invln_int.uoo_id%TYPE;
484: l_person_id igs_pe_person.person_id%TYPE;
485: l_course_cd igs_fi_inv_int.course_cd%TYPE;
486: l_cnt NUMBER;
487: l_str VARCHAR2(4000);
488: l_message VARCHAR2(2000);
489: l_fee_cal_type igs_fi_inv_int.fee_cal_type%TYPE;
485: l_course_cd igs_fi_inv_int.course_cd%TYPE;
486: l_cnt NUMBER;
487: l_str VARCHAR2(4000);
488: l_message VARCHAR2(2000);
489: l_fee_cal_type igs_fi_inv_int.fee_cal_type%TYPE;
490: l_fee_ci_sequence_number igs_fi_inv_int.fee_ci_sequence_number%TYPE;
491: l_ld_cal_type igs_ca_inst.cal_type%TYPE;
492: l_ld_ci_sequence_number Igs_ca_inst.sequence_number%TYPE;
493: l_person_number igs_pe_person.person_number%TYPE;
486: l_cnt NUMBER;
487: l_str VARCHAR2(4000);
488: l_message VARCHAR2(2000);
489: l_fee_cal_type igs_fi_inv_int.fee_cal_type%TYPE;
490: l_fee_ci_sequence_number igs_fi_inv_int.fee_ci_sequence_number%TYPE;
491: l_ld_cal_type igs_ca_inst.cal_type%TYPE;
492: l_ld_ci_sequence_number Igs_ca_inst.sequence_number%TYPE;
493: l_person_number igs_pe_person.person_number%TYPE;
494: l_enrolled_dt igs_en_su_attempt.enrolled_dt%TYPE;