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,
41: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
42: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
43: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%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(
53: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
54: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
55: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
56: p_n_source_credit_id IN igs_fi_credits_all.credit_id%TYPE,
57: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
58: p_v_currency_cd IN igs_fi_inv_int_all.currency_cd%TYPE,
59: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,
60: x_return_status OUT NOCOPY VARCHAR2);
61:
54: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
55: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
56: p_n_source_credit_id IN igs_fi_credits_all.credit_id%TYPE,
57: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
58: p_v_currency_cd IN igs_fi_inv_int_all.currency_cd%TYPE,
59: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,
60: x_return_status OUT NOCOPY VARCHAR2);
61:
62: -- Procedure to Apply the Waiver Credit against the Waiver Adjustment Charges
73:
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,
87: -- Procedure to Un apply existing applications for credits other than
88: -- Negative Charge Adjustmnet, Waiver, Enrollment Deposit and Other Depost types
89: -- and apply the unapplied charges against the balance Waiver Credit
90: PROCEDURE adjust_stdnt_charges(
91: p_n_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
92: p_n_credit_id IN igs_fi_credits_all.credit_id%TYPE,
93: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,
94: p_n_credit_amount IN OUT NOCOPY NUMBER,
95: x_return_status OUT NOCOPY VARCHAR2);
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,
105: p_n_credit_id IN igs_fi_credits_all.credit_id%TYPE,
106: p_v_currency_cd IN igs_fi_inv_int_all.currency_cd%TYPE,
107: p_n_waiver_amt IN igs_fi_inv_int_all.invoice_amount%TYPE,
108: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,
109: x_return_status OUT NOCOPY VARCHAR2);
110:
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,
105: p_n_credit_id IN igs_fi_credits_all.credit_id%TYPE,
106: p_v_currency_cd IN igs_fi_inv_int_all.currency_cd%TYPE,
107: p_n_waiver_amt IN igs_fi_inv_int_all.invoice_amount%TYPE,
108: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,
109: x_return_status OUT NOCOPY VARCHAR2);
110:
111: -- Procedure to apply the Waiver Adjustment Charges for a Waiver Credit,
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,
133: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
134: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
135: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
136: x_return_status OUT NOCOPY VARCHAR2,
137: x_eligible_amount OUT NOCOPY NUMBER ) AS
138: /******************************************************************
139: Created By : Anji Yedubati
151:
152: -- Fecth the Charges in the Student account except Rentension Charges
153: -- for a combination of Person, Fee Type, Fee Period or based on Invoice ID
154: CURSOR stdnt_charges_cur (
155: cp_n_person_id igs_fi_inv_int_all.person_id%TYPE,
156: cp_v_target_fee_type igs_fi_inv_int_all.fee_type%TYPE,
157: cp_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE,
158: cp_n_fee_ci_seq_num igs_fi_inv_int_all.fee_ci_sequence_number%TYPE,
159: cp_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE) IS
152: -- Fecth the Charges in the Student account except Rentension Charges
153: -- for a combination of Person, Fee Type, Fee Period or based on Invoice ID
154: CURSOR stdnt_charges_cur (
155: cp_n_person_id igs_fi_inv_int_all.person_id%TYPE,
156: cp_v_target_fee_type igs_fi_inv_int_all.fee_type%TYPE,
157: cp_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE,
158: cp_n_fee_ci_seq_num igs_fi_inv_int_all.fee_ci_sequence_number%TYPE,
159: cp_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE) IS
160: SELECT inv.invoice_id, inv.invoice_amount
153: -- for a combination of Person, Fee Type, Fee Period or based on Invoice ID
154: CURSOR stdnt_charges_cur (
155: cp_n_person_id igs_fi_inv_int_all.person_id%TYPE,
156: cp_v_target_fee_type igs_fi_inv_int_all.fee_type%TYPE,
157: cp_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE,
158: cp_n_fee_ci_seq_num igs_fi_inv_int_all.fee_ci_sequence_number%TYPE,
159: cp_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE) IS
160: SELECT inv.invoice_id, inv.invoice_amount
161: FROM igs_fi_inv_int_all inv
154: CURSOR stdnt_charges_cur (
155: cp_n_person_id igs_fi_inv_int_all.person_id%TYPE,
156: cp_v_target_fee_type igs_fi_inv_int_all.fee_type%TYPE,
157: cp_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE,
158: cp_n_fee_ci_seq_num igs_fi_inv_int_all.fee_ci_sequence_number%TYPE,
159: cp_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE) IS
160: SELECT inv.invoice_id, inv.invoice_amount
161: FROM igs_fi_inv_int_all inv
162: WHERE inv.person_id = cp_n_person_id
155: cp_n_person_id igs_fi_inv_int_all.person_id%TYPE,
156: cp_v_target_fee_type igs_fi_inv_int_all.fee_type%TYPE,
157: cp_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE,
158: cp_n_fee_ci_seq_num igs_fi_inv_int_all.fee_ci_sequence_number%TYPE,
159: cp_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE) IS
160: SELECT inv.invoice_id, inv.invoice_amount
161: FROM igs_fi_inv_int_all inv
162: WHERE inv.person_id = cp_n_person_id
163: AND inv.fee_type = cp_v_target_fee_type
157: cp_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE,
158: cp_n_fee_ci_seq_num igs_fi_inv_int_all.fee_ci_sequence_number%TYPE,
159: cp_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE) IS
160: SELECT inv.invoice_id, inv.invoice_amount
161: FROM igs_fi_inv_int_all inv
162: WHERE inv.person_id = cp_n_person_id
163: AND inv.fee_type = cp_v_target_fee_type
164: AND inv.fee_cal_type = cp_v_fee_cal_type
165: AND inv.fee_ci_sequence_number = cp_n_fee_ci_seq_num
181:
182: -- Fecth the Waiver Credit Application records applied to the charges having same target fee type
183: -- and fee calendar and other than the waiver program passed as in parameter to the procedure
184: CURSOR wav_applications_cur(
185: cp_n_person_id igs_fi_inv_int_all.person_id%TYPE,
186: cp_v_target_fee_type igs_fi_inv_int_all.fee_type%TYPE,
187: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,
188: cp_n_fee_ci_seq_num igs_fi_credits_all.fee_ci_sequence_number%TYPE,
189: cp_n_invoice_id igs_fi_applications.invoice_id%TYPE,
182: -- Fecth the Waiver Credit Application records applied to the charges having same target fee type
183: -- and fee calendar and other than the waiver program passed as in parameter to the procedure
184: CURSOR wav_applications_cur(
185: cp_n_person_id igs_fi_inv_int_all.person_id%TYPE,
186: cp_v_target_fee_type igs_fi_inv_int_all.fee_type%TYPE,
187: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,
188: cp_n_fee_ci_seq_num igs_fi_credits_all.fee_ci_sequence_number%TYPE,
189: cp_n_invoice_id igs_fi_applications.invoice_id%TYPE,
190: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE) IS
192: appl.amount_applied,
193: appl.application_id,
194: appl.credit_id,
195: appl.invoice_id
196: FROM igs_fi_inv_int_all inv,
197: igs_fi_applications appl,
198: igs_fi_credits_all crd,
199: igs_fi_cr_types cr
200: WHERE inv.person_id = cp_n_person_id
215:
216: -- Fetch Application records for a given waiver credit
217: -- against which waiver adjustment charge applied
218: CURSOR wavadj_app_cur(cp_n_credit_id igs_fi_applications.credit_id%TYPE,
219: cp_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE,
220: cp_n_fee_ci_seq_num igs_fi_inv_int_all.fee_ci_sequence_number%TYPE,
221: cp_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE) IS
222: SELECT appl.amount_applied
223: FROM igs_fi_applications appl,
216: -- Fetch Application records for a given waiver credit
217: -- against which waiver adjustment charge applied
218: CURSOR wavadj_app_cur(cp_n_credit_id igs_fi_applications.credit_id%TYPE,
219: cp_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE,
220: cp_n_fee_ci_seq_num igs_fi_inv_int_all.fee_ci_sequence_number%TYPE,
221: cp_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE) IS
222: SELECT appl.amount_applied
223: FROM igs_fi_applications appl,
224: igs_fi_inv_int_all inv
217: -- against which waiver adjustment charge applied
218: CURSOR wavadj_app_cur(cp_n_credit_id igs_fi_applications.credit_id%TYPE,
219: cp_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE,
220: cp_n_fee_ci_seq_num igs_fi_inv_int_all.fee_ci_sequence_number%TYPE,
221: cp_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE) IS
222: SELECT appl.amount_applied
223: FROM igs_fi_applications appl,
224: igs_fi_inv_int_all inv
225: WHERE appl.credit_id = cp_n_credit_id
220: cp_n_fee_ci_seq_num igs_fi_inv_int_all.fee_ci_sequence_number%TYPE,
221: cp_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE) IS
222: SELECT appl.amount_applied
223: FROM igs_fi_applications appl,
224: igs_fi_inv_int_all inv
225: WHERE appl.credit_id = cp_n_credit_id
226: AND appl.invoice_id = inv.invoice_id
227: AND appl.application_type = 'APP'
228: AND inv.fee_cal_type = cp_v_fee_cal_type
350: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
351: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
352: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
353: p_n_source_credit_id IN igs_fi_credits_all.credit_id%TYPE,
354: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
355: p_v_currency_cd IN igs_fi_inv_int_all.currency_cd%TYPE,
356: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,
357: x_return_status OUT NOCOPY VARCHAR2 ) AS
358: /******************************************************************
351: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
352: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
353: p_n_source_credit_id IN igs_fi_credits_all.credit_id%TYPE,
354: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
355: p_v_currency_cd IN igs_fi_inv_int_all.currency_cd%TYPE,
356: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,
357: x_return_status OUT NOCOPY VARCHAR2 ) AS
358: /******************************************************************
359: Created By : Anji Yedubati
397:
398: -- Fetch the change records other than Re
399: -- for a combination of Person, Fee Type and Fee Period
400: CURSOR stnt_charges_cur(
401: cp_n_person_id igs_fi_inv_int_all.person_id%TYPE,
402: cp_v_target_fee_type igs_fi_inv_int_all.fee_type%TYPE,
403: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,
404: cp_n_fee_ci_seq_num igs_fi_credits_all.fee_ci_sequence_number%TYPE) IS
405: SELECT inv.invoice_id,
398: -- Fetch the change records other than Re
399: -- for a combination of Person, Fee Type and Fee Period
400: CURSOR stnt_charges_cur(
401: cp_n_person_id igs_fi_inv_int_all.person_id%TYPE,
402: cp_v_target_fee_type igs_fi_inv_int_all.fee_type%TYPE,
403: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,
404: cp_n_fee_ci_seq_num igs_fi_credits_all.fee_ci_sequence_number%TYPE) IS
405: SELECT inv.invoice_id,
406: inv.invoice_amount_due
403: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,
404: cp_n_fee_ci_seq_num igs_fi_credits_all.fee_ci_sequence_number%TYPE) IS
405: SELECT inv.invoice_id,
406: inv.invoice_amount_due
407: FROM igs_fi_inv_int_all inv,
408: igs_fi_invln_int_all invln
409: WHERE inv.person_id = cp_n_person_id
410: AND inv.fee_type = cp_v_target_fee_type
411: AND inv.fee_cal_type = cp_v_fee_cal_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,
773: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
774: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
775: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
776: x_return_status OUT NOCOPY VARCHAR2) AS
777: /******************************************************************
778: Created By : Anji Yedubati
779: Date Created By : 19-JUL-2005
853: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
854: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
855: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
856: p_n_source_credit_id IN igs_fi_credits_all.credit_id%TYPE,
857: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
858: p_v_currency_cd IN igs_fi_inv_int_all.currency_cd%TYPE,
859: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,
860: x_return_status OUT NOCOPY VARCHAR2) AS
861: /******************************************************************
854: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
855: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
856: p_n_source_credit_id IN igs_fi_credits_all.credit_id%TYPE,
857: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
858: p_v_currency_cd IN igs_fi_inv_int_all.currency_cd%TYPE,
859: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,
860: x_return_status OUT NOCOPY VARCHAR2) AS
861: /******************************************************************
862: Created By : Anji Yedubati
953:
954: -- Fecth the Waiver adjustment charges having some positive amount due exists
955: -- for the combination of Person, Adjsutment Fee Type, Fee Period and Waiver Name
956: CURSOR waiver_adj_charges_cur(
957: cp_n_person_id igs_fi_inv_int_all.person_id%TYPE,
958: cp_v_adj_fee_type igs_fi_inv_int_all.fee_type%TYPE,
959: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,
960: cp_n_fee_ci_seq_num igs_fi_credits_all.fee_ci_sequence_number%TYPE,
961: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE) IS
954: -- Fecth the Waiver adjustment charges having some positive amount due exists
955: -- for the combination of Person, Adjsutment Fee Type, Fee Period and Waiver Name
956: CURSOR waiver_adj_charges_cur(
957: cp_n_person_id igs_fi_inv_int_all.person_id%TYPE,
958: cp_v_adj_fee_type igs_fi_inv_int_all.fee_type%TYPE,
959: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,
960: cp_n_fee_ci_seq_num igs_fi_credits_all.fee_ci_sequence_number%TYPE,
961: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE) IS
962: SELECT inv.invoice_id,
960: cp_n_fee_ci_seq_num igs_fi_credits_all.fee_ci_sequence_number%TYPE,
961: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE) IS
962: SELECT inv.invoice_id,
963: inv.invoice_amount_due
964: FROM igs_fi_inv_int_all inv,
965: igs_fi_invln_int_all invln
966: WHERE inv.person_id = cp_n_person_id
967: AND inv.fee_type = cp_v_adj_fee_type
968: AND inv.fee_cal_type = cp_v_fee_cal_type
1064:
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,
1088:
1089: -- Fetch the Charges except Retention Charges having some positive amount due exists
1090: -- for a combination of Person, Fee Type and Fee Period or source invoice id alone
1091: CURSOR stnt_charges_cur(
1092: cp_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE,
1093: cp_n_person_id igs_fi_inv_int_all.person_id%TYPE,
1094: cp_v_target_fee_type igs_fi_inv_int_all.fee_type%TYPE,
1095: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,
1096: cp_n_fee_ci_seq_num igs_fi_credits_all.fee_ci_sequence_number%TYPE) IS
1089: -- Fetch the Charges except Retention Charges having some positive amount due exists
1090: -- for a combination of Person, Fee Type and Fee Period or source invoice id alone
1091: CURSOR stnt_charges_cur(
1092: cp_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE,
1093: cp_n_person_id igs_fi_inv_int_all.person_id%TYPE,
1094: cp_v_target_fee_type igs_fi_inv_int_all.fee_type%TYPE,
1095: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,
1096: cp_n_fee_ci_seq_num igs_fi_credits_all.fee_ci_sequence_number%TYPE) IS
1097: SELECT inv.invoice_id,
1090: -- for a combination of Person, Fee Type and Fee Period or source invoice id alone
1091: CURSOR stnt_charges_cur(
1092: cp_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE,
1093: cp_n_person_id igs_fi_inv_int_all.person_id%TYPE,
1094: cp_v_target_fee_type igs_fi_inv_int_all.fee_type%TYPE,
1095: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,
1096: cp_n_fee_ci_seq_num igs_fi_credits_all.fee_ci_sequence_number%TYPE) IS
1097: SELECT inv.invoice_id,
1098: inv.invoice_amount_due
1095: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,
1096: cp_n_fee_ci_seq_num igs_fi_credits_all.fee_ci_sequence_number%TYPE) IS
1097: SELECT inv.invoice_id,
1098: inv.invoice_amount_due
1099: FROM igs_fi_inv_int_all inv,
1100: igs_fi_invln_int_all invln
1101: WHERE (inv.invoice_id = cp_n_invoice_id OR cp_n_invoice_id IS NULL)
1102: AND inv.person_id = cp_n_person_id
1103: AND inv.fee_type = cp_v_target_fee_type
1200:
1201: END process_stdnt_charges;
1202:
1203: PROCEDURE adjust_stdnt_charges(
1204: p_n_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
1205: p_n_credit_id IN igs_fi_credits_all.credit_id%TYPE,
1206: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,
1207: p_n_credit_amount IN OUT NOCOPY NUMBER,
1208: x_return_status OUT NOCOPY VARCHAR2) AS
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,
1384: p_n_credit_id IN igs_fi_credits_all.credit_id%TYPE,
1385: p_v_currency_cd IN igs_fi_inv_int_all.currency_cd%TYPE,
1386: p_n_waiver_amt IN igs_fi_inv_int_all.invoice_amount%TYPE,
1387: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,
1388: x_return_status OUT NOCOPY VARCHAR2) AS
1389: /******************************************************************
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,
1384: p_n_credit_id IN igs_fi_credits_all.credit_id%TYPE,
1385: p_v_currency_cd IN igs_fi_inv_int_all.currency_cd%TYPE,
1386: p_n_waiver_amt IN igs_fi_inv_int_all.invoice_amount%TYPE,
1387: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,
1388: x_return_status OUT NOCOPY VARCHAR2) AS
1389: /******************************************************************
1390: Created By : Anji Yedubati
1397: Change History :
1398: WHO WHEN WHAT
1399: ***************************************************************** */
1400:
1401: l_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE;
1402: l_b_status BOOLEAN;
1403:
1404: l_n_app_id igs_fi_applications.application_id%TYPE;
1405: l_n_dr_gl_ccid igs_fi_applications.dr_gl_code_ccid%TYPE;
1513:
1514: -- Fetch the Waiver charge adjustment records having some positive amount due exists
1515: -- for the combination of Person, Fee Type, Fee Period and Waiver name
1516: CURSOR waiver_adj_charges_cur(
1517: cp_n_person_id igs_fi_inv_int_all.person_id%TYPE,
1518: cp_v_adj_fee_type igs_fi_inv_int_all.fee_type%TYPE,
1519: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,
1520: cp_n_fee_ci_seq_num igs_fi_credits_all.fee_ci_sequence_number%TYPE,
1521: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE) IS
1514: -- Fetch the Waiver charge adjustment records having some positive amount due exists
1515: -- for the combination of Person, Fee Type, Fee Period and Waiver name
1516: CURSOR waiver_adj_charges_cur(
1517: cp_n_person_id igs_fi_inv_int_all.person_id%TYPE,
1518: cp_v_adj_fee_type igs_fi_inv_int_all.fee_type%TYPE,
1519: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,
1520: cp_n_fee_ci_seq_num igs_fi_credits_all.fee_ci_sequence_number%TYPE,
1521: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE) IS
1522: SELECT
1522: SELECT
1523: inv.invoice_id,
1524: inv.invoice_amount,
1525: inv.invoice_amount_due
1526: FROM igs_fi_inv_int_all inv,
1527: igs_fi_invln_int_all invln
1528: WHERE inv.person_id = cp_n_person_id
1529: AND inv.fee_type = cp_v_adj_fee_type
1530: AND inv.fee_cal_type = cp_v_fee_cal_type
1583: appl.application_id,
1584: appl.credit_id,
1585: appl.invoice_id
1586: FROM igs_fi_applications appl,
1587: igs_fi_inv_int_all inv
1588: WHERE appl.credit_id = cp_n_credit_id
1589: AND appl.invoice_id = inv.invoice_id
1590: AND appl.application_type = 'APP'
1591: AND inv.transaction_type <> 'WAIVER_ADJ'
1596: AND appl2.link_application_id = appl.application_id
1597: AND appl2.amount_applied = - appl.amount_applied)
1598: ORDER BY appl.application_id;
1599:
1600: l_n_invoice_amount igs_fi_inv_int_all.invoice_amount%TYPE;
1601: l_n_amount_apply NUMBER;
1602:
1603: l_n_app_id igs_fi_applications.application_id%TYPE;
1604: l_n_dr_gl_ccid igs_fi_applications.dr_gl_code_ccid%TYPE;
1845: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
1846: p_n_credit_type_id IN igs_fi_waiver_pgms.credit_type_id%TYPE,
1847: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
1848: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
1849: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
1850: p_n_waiver_amount IN igs_fi_credits_all.amount%TYPE,
1851: p_v_currency_cd IN igs_fi_inv_int_all.currency_cd%TYPE,
1852: p_d_gl_date IN igs_fi_invln_int_all.gl_date%TYPE,
1853: x_return_status OUT NOCOPY VARCHAR2) IS
1847: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
1848: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
1849: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
1850: p_n_waiver_amount IN igs_fi_credits_all.amount%TYPE,
1851: p_v_currency_cd IN igs_fi_inv_int_all.currency_cd%TYPE,
1852: p_d_gl_date IN igs_fi_invln_int_all.gl_date%TYPE,
1853: x_return_status OUT NOCOPY VARCHAR2) IS
1854: /******************************************************************
1855: Created By : Priya Athipatla