[Home] [Help]
32: p_v_string IN VARCHAR2);
33:
34: -- Procedure to validate the parameters passed to get Eligible Waiver Amount
35: PROCEDURE validate_elg_wavamt_params(
36: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
37: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
38: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
39: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
40: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
44: x_return_status OUT NOCOPY VARCHAR2);
45:
46: -- Procedure to validate the parameters passed to Apply Waivers procedure
47: PROCEDURE validate_applywav_params(
48: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
49: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
50: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
51: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
52: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
60: x_return_status OUT NOCOPY VARCHAR2);
61:
62: -- Procedure to Apply the Waiver Credit against the Waiver Adjustment Charges
63: PROCEDURE process_wavadj_charges(
64: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
65: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
66: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
67: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
68: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
74: -- Procedure to Apply the balance Waiver Credit against the charges in the
75: -- student account except the Rentension Charges
76: PROCEDURE process_stdnt_charges(
77: p_n_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
78: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
79: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
80: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
81: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
82: p_n_credit_id IN igs_fi_credits_all.credit_id%TYPE,
96:
97: -- Procedure to create the Waiver Adjustment Charge and
98: -- apply the charge against the waiver credit
99: PROCEDURE create_wavadj_charge(
100: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
101: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
102: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
103: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
104: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
111: -- Procedure to apply the Waiver Adjustment Charges for a Waiver Credit,
112: -- which has some positive amount due exists
113: PROCEDURE process_due_wavadj_charges(
114: p_n_source_credit_id IN igs_fi_credits_all.credit_id%TYPE,
115: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
116: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
117: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
118: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
119: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
124: -- Public Procedures
125: --
126:
127: PROCEDURE get_eligible_waiver_amt(
128: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
129: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
130: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
131: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
132: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
341: END get_eligible_waiver_amt;
342:
343:
344: PROCEDURE apply_waivers(
345: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
346: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
347: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
348: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
349: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
764: -- Local Procedures Definition
765: --
766:
767: PROCEDURE validate_elg_wavamt_params(
768: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
769: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
770: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
771: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
772: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
844:
845: END validate_elg_wavamt_params;
846:
847: PROCEDURE validate_applywav_params(
848: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
849: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
850: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
851: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
852: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
930:
931: END validate_applywav_params;
932:
933: PROCEDURE process_wavadj_charges(
934: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
935: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
936: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
937: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
938: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
1065: END process_wavadj_charges;
1066:
1067: PROCEDURE process_stdnt_charges(
1068: p_n_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
1069: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
1070: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
1071: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
1072: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
1073: p_n_credit_id IN igs_fi_credits_all.credit_id%TYPE,
1375:
1376: END adjust_stdnt_charges;
1377:
1378: PROCEDURE create_wavadj_charge(
1379: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
1380: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
1381: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
1382: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
1383: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
1488: END create_wavadj_charge;
1489:
1490: PROCEDURE process_due_wavadj_charges(
1491: p_n_source_credit_id IN igs_fi_credits_all.credit_id%TYPE,
1492: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
1493: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
1494: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
1495: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
1496: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
1836: END log_to_fnd;
1837:
1838:
1839: PROCEDURE create_ss_waiver_transactions(
1840: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
1841: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
1842: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
1843: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
1844: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,