eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_FI_WAV_UTILS_001 dependencies on IGS_FI_CREDITS

Line 56: p_n_source_credit_id IN igs_fi_credits_all.credit_id%TYPE,

52: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
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);

Line 69: p_n_credit_id IN igs_fi_credits_all.credit_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,
69: p_n_credit_id IN igs_fi_credits_all.credit_id%TYPE,
70: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,
71: p_n_credit_amount IN OUT NOCOPY NUMBER,
72: x_return_status OUT NOCOPY VARCHAR2);
73:

Line 82: p_n_credit_id IN igs_fi_credits_all.credit_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,
83: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,
84: p_n_credit_amount IN OUT NOCOPY NUMBER,
85: x_return_status OUT NOCOPY VARCHAR2);
86:

Line 92: p_n_credit_id IN igs_fi_credits_all.credit_id%TYPE,

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);
96:

Line 105: p_n_credit_id IN igs_fi_credits_all.credit_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,
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);

Line 114: p_n_source_credit_id IN igs_fi_credits_all.credit_id%TYPE,

110:
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,

Line 174: igs_fi_credits_all crd,

170: -- Fecth the Negative Charge Adjustment application details for a Charge
171: CURSOR chgadj_amt_cur (cp_n_invoice_id igs_fi_applications.invoice_id%TYPE) IS
172: SELECT appl.amount_applied
173: FROM igs_fi_applications appl,
174: igs_fi_credits_all crd,
175: igs_fi_cr_types_all cr
176: WHERE appl.invoice_id = cp_n_invoice_id
177: AND appl.credit_id = crd.credit_id
178: AND appl.application_type = 'APP'

Line 187: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%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
191: SELECT

Line 188: cp_n_fee_ci_seq_num igs_fi_credits_all.fee_ci_sequence_number%TYPE,

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
191: SELECT
192: appl.amount_applied,

Line 190: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE) IS

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
191: SELECT
192: appl.amount_applied,
193: appl.application_id,
194: appl.credit_id,

Line 198: igs_fi_credits_all crd,

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
201: AND inv.fee_type = cp_v_target_fee_type
202: AND inv.fee_cal_type = cp_v_fee_cal_type

Line 232: FROM igs_fi_credits_all crd,

228: AND inv.fee_cal_type = cp_v_fee_cal_type
229: AND inv.fee_ci_sequence_number = cp_n_fee_ci_seq_num
230: AND inv.transaction_type = 'WAIVER_ADJ'
231: AND EXISTS( SELECT '1'
232: FROM igs_fi_credits_all crd,
233: igs_fi_applications unappl
234: WHERE crd.credit_id = appl.credit_id
235: AND unappl.credit_id = crd.credit_id
236: AND unappl.invoice_id = cp_n_invoice_id

Line 353: p_n_source_credit_id IN igs_fi_credits_all.credit_id%TYPE,

349: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%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

Line 374: CURSOR chglvl_waiver_crdits_cur(cp_credit_id igs_fi_credits_all.credit_id%TYPE) IS

370: -- Declare used defined exception to raise when apply waiver credit fails
371: apply_wav_fail EXCEPTION;
372:
373: -- Fetch the credit details for a Credit Id
374: CURSOR chglvl_waiver_crdits_cur(cp_credit_id igs_fi_credits_all.credit_id%TYPE) IS
375: SELECT crd.credit_id,
376: crd.unapplied_amount
377: FROM igs_fi_credits_all crd
378: WHERE crd.credit_id = cp_credit_id

Line 377: FROM igs_fi_credits_all crd

373: -- Fetch the credit details for a Credit Id
374: CURSOR chglvl_waiver_crdits_cur(cp_credit_id igs_fi_credits_all.credit_id%TYPE) IS
375: SELECT crd.credit_id,
376: crd.unapplied_amount
377: FROM igs_fi_credits_all crd
378: WHERE crd.credit_id = cp_credit_id
379: AND NVL(crd.unapplied_amount, 0) > 0;
380:
381: -- Fetch waiver credit records for a combination of Person, Fee Period and Waiver Name

Line 383: cp_credit_id igs_fi_credits_all.credit_id%TYPE,

379: AND NVL(crd.unapplied_amount, 0) > 0;
380:
381: -- Fetch waiver credit records for a combination of Person, Fee Period and Waiver Name
382: CURSOR feelvl_waiver_crdits_cur(
383: cp_credit_id igs_fi_credits_all.credit_id%TYPE,
384: cp_n_person_id igs_fi_credits_all.party_id%TYPE,
385: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,
386: cp_n_fee_ci_seq_num igs_fi_credits_all.fee_ci_sequence_number%TYPE,
387: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE) IS

Line 384: cp_n_person_id igs_fi_credits_all.party_id%TYPE,

380:
381: -- Fetch waiver credit records for a combination of Person, Fee Period and Waiver Name
382: CURSOR feelvl_waiver_crdits_cur(
383: cp_credit_id igs_fi_credits_all.credit_id%TYPE,
384: cp_n_person_id igs_fi_credits_all.party_id%TYPE,
385: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,
386: cp_n_fee_ci_seq_num igs_fi_credits_all.fee_ci_sequence_number%TYPE,
387: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE) IS
388: SELECT crd.credit_id,

Line 385: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,

381: -- Fetch waiver credit records for a combination of Person, Fee Period and Waiver Name
382: CURSOR feelvl_waiver_crdits_cur(
383: cp_credit_id igs_fi_credits_all.credit_id%TYPE,
384: cp_n_person_id igs_fi_credits_all.party_id%TYPE,
385: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,
386: cp_n_fee_ci_seq_num igs_fi_credits_all.fee_ci_sequence_number%TYPE,
387: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE) IS
388: SELECT crd.credit_id,
389: crd.unapplied_amount

Line 386: cp_n_fee_ci_seq_num igs_fi_credits_all.fee_ci_sequence_number%TYPE,

382: CURSOR feelvl_waiver_crdits_cur(
383: cp_credit_id igs_fi_credits_all.credit_id%TYPE,
384: cp_n_person_id igs_fi_credits_all.party_id%TYPE,
385: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,
386: cp_n_fee_ci_seq_num igs_fi_credits_all.fee_ci_sequence_number%TYPE,
387: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE) IS
388: SELECT crd.credit_id,
389: crd.unapplied_amount
390: FROM igs_fi_credits_all crd

Line 387: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE) IS

383: cp_credit_id igs_fi_credits_all.credit_id%TYPE,
384: cp_n_person_id igs_fi_credits_all.party_id%TYPE,
385: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,
386: cp_n_fee_ci_seq_num igs_fi_credits_all.fee_ci_sequence_number%TYPE,
387: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE) IS
388: SELECT crd.credit_id,
389: crd.unapplied_amount
390: FROM igs_fi_credits_all crd
391: WHERE (cp_credit_id IS NULL OR crd.credit_id = cp_credit_id)

Line 390: FROM igs_fi_credits_all crd

386: cp_n_fee_ci_seq_num igs_fi_credits_all.fee_ci_sequence_number%TYPE,
387: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE) IS
388: SELECT crd.credit_id,
389: crd.unapplied_amount
390: FROM igs_fi_credits_all crd
391: WHERE (cp_credit_id IS NULL OR crd.credit_id = cp_credit_id)
392: AND crd.party_id = cp_n_person_id
393: AND crd.fee_cal_type = cp_v_fee_cal_type
394: AND crd.fee_ci_sequence_number = cp_n_fee_ci_seq_num

Line 403: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,

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
407: FROM igs_fi_inv_int_all inv,

Line 404: cp_n_fee_ci_seq_num igs_fi_credits_all.fee_ci_sequence_number%TYPE) IS

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
407: FROM igs_fi_inv_int_all inv,
408: igs_fi_invln_int_all invln

Line 419: l_n_credit_amount IGS_FI_CREDITS_ALL.unapplied_amount%TYPE;

415: AND NVL(invln.error_account,'N') = 'N'
416: ORDER BY inv.invoice_id;
417:
418: l_v_return_status VARCHAR2(1);
419: l_n_credit_amount IGS_FI_CREDITS_ALL.unapplied_amount%TYPE;
420:
421: BEGIN
422:
423: -- Create the Save Point

Line 856: p_n_source_credit_id IN igs_fi_credits_all.credit_id%TYPE,

852: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
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

Line 939: p_n_credit_id IN igs_fi_credits_all.credit_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,
939: p_n_credit_id IN igs_fi_credits_all.credit_id%TYPE,
940: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,
941: p_n_credit_amount IN OUT NOCOPY NUMBER,
942: x_return_status OUT NOCOPY VARCHAR2) AS
943: /******************************************************************

Line 959: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,

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,
963: inv.invoice_amount_due

Line 960: cp_n_fee_ci_seq_num igs_fi_credits_all.fee_ci_sequence_number%TYPE,

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,
963: inv.invoice_amount_due
964: FROM igs_fi_inv_int_all inv,

Line 961: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE) IS

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,
963: inv.invoice_amount_due
964: FROM igs_fi_inv_int_all inv,
965: igs_fi_invln_int_all invln

Line 982: l_n_unapp_amount igs_fi_credits.unapplied_amount%TYPE;

978: l_n_dr_gl_ccid igs_fi_applications.dr_gl_code_ccid%TYPE;
979: l_n_cr_gl_ccid igs_fi_applications.cr_gl_code_ccid%TYPE;
980: l_v_dr_acc_cd igs_fi_applications.dr_account_cd%TYPE;
981: l_v_cr_acc_cd igs_fi_applications.cr_account_cd%TYPE;
982: l_n_unapp_amount igs_fi_credits.unapplied_amount%TYPE;
983: l_n_inv_amt_due igs_fi_inv_int.invoice_amount_due%TYPE;
984: l_v_err_msg VARCHAR2(2000);
985: l_b_status BOOLEAN;
986:

Line 1073: p_n_credit_id IN igs_fi_credits_all.credit_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,
1074: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,
1075: p_n_credit_amount IN OUT NOCOPY NUMBER,
1076: x_return_status OUT NOCOPY VARCHAR2) AS
1077: /******************************************************************

Line 1095: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,

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
1099: FROM igs_fi_inv_int_all inv,

Line 1096: cp_n_fee_ci_seq_num igs_fi_credits_all.fee_ci_sequence_number%TYPE) IS

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
1099: FROM igs_fi_inv_int_all inv,
1100: igs_fi_invln_int_all invln

Line 1118: l_n_unapp_amount igs_fi_credits.unapplied_amount%TYPE;

1114: l_n_dr_gl_ccid igs_fi_applications.dr_gl_code_ccid%TYPE;
1115: l_n_cr_gl_ccid igs_fi_applications.cr_gl_code_ccid%TYPE;
1116: l_v_dr_acc_cd igs_fi_applications.dr_account_cd%TYPE;
1117: l_v_cr_acc_cd igs_fi_applications.cr_account_cd%TYPE;
1118: l_n_unapp_amount igs_fi_credits.unapplied_amount%TYPE;
1119: l_n_inv_amt_due igs_fi_inv_int.invoice_amount_due%TYPE;
1120: l_v_err_msg VARCHAR2(2000);
1121: l_b_status BOOLEAN;
1122:

Line 1205: p_n_credit_id IN igs_fi_credits_all.credit_id%TYPE,

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
1209: /******************************************************************

Line 1234: igs_fi_credits_all crd,

1230: appl.application_id,
1231: appl.credit_id,
1232: appl.invoice_id
1233: FROM igs_fi_applications appl,
1234: igs_fi_credits_all crd,
1235: igs_fi_cr_types cr
1236: WHERE appl.invoice_id = cp_n_invoice_id
1237: AND appl.credit_id = crd.credit_id
1238: AND appl.application_type = cp_cst_app

Line 1255: l_n_unapp_amount igs_fi_credits.unapplied_amount%TYPE;

1251: l_n_dr_gl_ccid igs_fi_applications.dr_gl_code_ccid%TYPE;
1252: l_n_cr_gl_ccid igs_fi_applications.cr_gl_code_ccid%TYPE;
1253: l_v_dr_acc_cd igs_fi_applications.dr_account_cd%TYPE;
1254: l_v_cr_acc_cd igs_fi_applications.cr_account_cd%TYPE;
1255: l_n_unapp_amount igs_fi_credits.unapplied_amount%TYPE;
1256: l_n_inv_amt_due igs_fi_inv_int.invoice_amount_due%TYPE;
1257: l_v_err_msg VARCHAR2(2000);
1258: l_b_status BOOLEAN;
1259:

Line 1384: p_n_credit_id IN igs_fi_credits_all.credit_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,
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

Line 1409: l_n_unapp_amount igs_fi_credits.unapplied_amount%TYPE;

1405: l_n_dr_gl_ccid igs_fi_applications.dr_gl_code_ccid%TYPE;
1406: l_n_cr_gl_ccid igs_fi_applications.cr_gl_code_ccid%TYPE;
1407: l_v_dr_acc_cd igs_fi_applications.dr_account_cd%TYPE;
1408: l_v_cr_acc_cd igs_fi_applications.cr_account_cd%TYPE;
1409: l_n_unapp_amount igs_fi_credits.unapplied_amount%TYPE;
1410: l_n_inv_amt_due igs_fi_inv_int.invoice_amount_due%TYPE;
1411: l_v_err_msg VARCHAR2(2000);
1412:
1413: BEGIN

Line 1491: p_n_source_credit_id IN igs_fi_credits_all.credit_id%TYPE,

1487:
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,

Line 1519: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,

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
1523: inv.invoice_id,

Line 1520: cp_n_fee_ci_seq_num igs_fi_credits_all.fee_ci_sequence_number%TYPE,

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
1523: inv.invoice_id,
1524: inv.invoice_amount,

Line 1521: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE) IS

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
1523: inv.invoice_id,
1524: inv.invoice_amount,
1525: inv.invoice_amount_due

Line 1541: cp_n_credit_id igs_fi_credits_all.credit_id%TYPE,

1537:
1538: -- Fetch the waiver credit records having some positive amount due exists
1539: -- for the combination of Person, Fee Period and Waiver Name
1540: CURSOR stdnt_waiver_crdits_cur(
1541: cp_n_credit_id igs_fi_credits_all.credit_id%TYPE,
1542: cp_n_person_id igs_fi_credits_all.party_id%TYPE,
1543: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,
1544: cp_n_fee_ci_seq_num igs_fi_credits_all.fee_ci_sequence_number%TYPE,
1545: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE) IS

Line 1542: cp_n_person_id igs_fi_credits_all.party_id%TYPE,

1538: -- Fetch the waiver credit records having some positive amount due exists
1539: -- for the combination of Person, Fee Period and Waiver Name
1540: CURSOR stdnt_waiver_crdits_cur(
1541: cp_n_credit_id igs_fi_credits_all.credit_id%TYPE,
1542: cp_n_person_id igs_fi_credits_all.party_id%TYPE,
1543: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,
1544: cp_n_fee_ci_seq_num igs_fi_credits_all.fee_ci_sequence_number%TYPE,
1545: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE) IS
1546: SELECT

Line 1543: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,

1539: -- for the combination of Person, Fee Period and Waiver Name
1540: CURSOR stdnt_waiver_crdits_cur(
1541: cp_n_credit_id igs_fi_credits_all.credit_id%TYPE,
1542: cp_n_person_id igs_fi_credits_all.party_id%TYPE,
1543: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,
1544: cp_n_fee_ci_seq_num igs_fi_credits_all.fee_ci_sequence_number%TYPE,
1545: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE) IS
1546: SELECT
1547: crd.credit_id,

Line 1544: cp_n_fee_ci_seq_num igs_fi_credits_all.fee_ci_sequence_number%TYPE,

1540: CURSOR stdnt_waiver_crdits_cur(
1541: cp_n_credit_id igs_fi_credits_all.credit_id%TYPE,
1542: cp_n_person_id igs_fi_credits_all.party_id%TYPE,
1543: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,
1544: cp_n_fee_ci_seq_num igs_fi_credits_all.fee_ci_sequence_number%TYPE,
1545: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE) IS
1546: SELECT
1547: crd.credit_id,
1548: crd.unapplied_amount

Line 1545: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE) IS

1541: cp_n_credit_id igs_fi_credits_all.credit_id%TYPE,
1542: cp_n_person_id igs_fi_credits_all.party_id%TYPE,
1543: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,
1544: cp_n_fee_ci_seq_num igs_fi_credits_all.fee_ci_sequence_number%TYPE,
1545: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE) IS
1546: SELECT
1547: crd.credit_id,
1548: crd.unapplied_amount
1549: FROM igs_fi_credits_all crd

Line 1549: FROM igs_fi_credits_all crd

1545: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE) IS
1546: SELECT
1547: crd.credit_id,
1548: crd.unapplied_amount
1549: FROM igs_fi_credits_all crd
1550: WHERE (cp_n_credit_id IS NULL OR crd.credit_id = cp_n_credit_id)
1551: AND crd.party_id = cp_n_person_id
1552: AND crd.fee_cal_type = cp_v_fee_cal_type
1553: AND crd.fee_ci_sequence_number = cp_n_fee_ci_seq_num

Line 1561: cp_n_credit_id igs_fi_credits_all.credit_id%TYPE,

1557:
1558: -- Fetch the waiver credit records which are fully applied
1559: -- for the combination of Person, Fee Period and Waiver Name
1560: CURSOR stdnt_fullapplied_wavcr_cur(
1561: cp_n_credit_id igs_fi_credits_all.credit_id%TYPE,
1562: cp_n_person_id igs_fi_credits_all.party_id%TYPE,
1563: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,
1564: cp_n_fee_ci_seq_num igs_fi_credits_all.fee_ci_sequence_number%TYPE,
1565: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE) IS

Line 1562: cp_n_person_id igs_fi_credits_all.party_id%TYPE,

1558: -- Fetch the waiver credit records which are fully applied
1559: -- for the combination of Person, Fee Period and Waiver Name
1560: CURSOR stdnt_fullapplied_wavcr_cur(
1561: cp_n_credit_id igs_fi_credits_all.credit_id%TYPE,
1562: cp_n_person_id igs_fi_credits_all.party_id%TYPE,
1563: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,
1564: cp_n_fee_ci_seq_num igs_fi_credits_all.fee_ci_sequence_number%TYPE,
1565: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE) IS
1566: SELECT

Line 1563: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,

1559: -- for the combination of Person, Fee Period and Waiver Name
1560: CURSOR stdnt_fullapplied_wavcr_cur(
1561: cp_n_credit_id igs_fi_credits_all.credit_id%TYPE,
1562: cp_n_person_id igs_fi_credits_all.party_id%TYPE,
1563: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,
1564: cp_n_fee_ci_seq_num igs_fi_credits_all.fee_ci_sequence_number%TYPE,
1565: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE) IS
1566: SELECT
1567: crd.credit_id,

Line 1564: cp_n_fee_ci_seq_num igs_fi_credits_all.fee_ci_sequence_number%TYPE,

1560: CURSOR stdnt_fullapplied_wavcr_cur(
1561: cp_n_credit_id igs_fi_credits_all.credit_id%TYPE,
1562: cp_n_person_id igs_fi_credits_all.party_id%TYPE,
1563: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,
1564: cp_n_fee_ci_seq_num igs_fi_credits_all.fee_ci_sequence_number%TYPE,
1565: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE) IS
1566: SELECT
1567: crd.credit_id,
1568: crd.unapplied_amount

Line 1565: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE) IS

1561: cp_n_credit_id igs_fi_credits_all.credit_id%TYPE,
1562: cp_n_person_id igs_fi_credits_all.party_id%TYPE,
1563: cp_v_fee_cal_type igs_fi_credits_all.fee_cal_type%TYPE,
1564: cp_n_fee_ci_seq_num igs_fi_credits_all.fee_ci_sequence_number%TYPE,
1565: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE) IS
1566: SELECT
1567: crd.credit_id,
1568: crd.unapplied_amount
1569: FROM igs_fi_credits_all crd

Line 1569: FROM igs_fi_credits_all crd

1565: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE) IS
1566: SELECT
1567: crd.credit_id,
1568: crd.unapplied_amount
1569: FROM igs_fi_credits_all crd
1570: WHERE (cp_n_credit_id IS NULL OR crd.credit_id = cp_n_credit_id)
1571: AND crd.party_id = cp_n_person_id
1572: AND crd.fee_cal_type = cp_v_fee_cal_type
1573: AND crd.fee_ci_sequence_number = cp_n_fee_ci_seq_num

Line 1580: cp_n_credit_id igs_fi_credits_all.credit_id%TYPE) IS

1576:
1577: -- Fetch the application records exist for a waiver credit transaction
1578: -- excluding the applications between the waiver credit and waiver adjustment charge
1579: CURSOR appls_otherthan_wavadj_cur(
1580: cp_n_credit_id igs_fi_credits_all.credit_id%TYPE) IS
1581: SELECT
1582: igs_fi_gen_007.get_sum_appl_amnt(appl.application_id) amount_applied,
1583: appl.application_id,
1584: appl.credit_id,

Line 1608: l_n_unapp_amount igs_fi_credits.unapplied_amount%TYPE;

1604: l_n_dr_gl_ccid igs_fi_applications.dr_gl_code_ccid%TYPE;
1605: l_n_cr_gl_ccid igs_fi_applications.cr_gl_code_ccid%TYPE;
1606: l_v_dr_acc_cd igs_fi_applications.dr_account_cd%TYPE;
1607: l_v_cr_acc_cd igs_fi_applications.cr_account_cd%TYPE;
1608: l_n_unapp_amount igs_fi_credits.unapplied_amount%TYPE;
1609: l_n_inv_amt_due igs_fi_inv_int.invoice_amount_due%TYPE;
1610: l_v_err_msg VARCHAR2(2000);
1611: l_b_status BOOLEAN;
1612:

Line 1850: p_n_waiver_amount IN igs_fi_credits_all.amount%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
1854: /******************************************************************

Line 1871: l_n_credit_id igs_fi_credits_all.credit_id%TYPE;

1867: SELECT waiver_notify_finaid_flag
1868: FROM igs_fi_control_all;
1869:
1870: -- Local variables
1871: l_n_credit_id igs_fi_credits_all.credit_id%TYPE;
1872: l_v_return_status VARCHAR2(1);
1873: l_v_notify_fa_flag igs_fi_control_all.waiver_notify_finaid_flag%TYPE;
1874:
1875: BEGIN