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_INV_INT

Line 43: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%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,
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(

Line 57: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%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);
61:

Line 58: p_v_currency_cd IN igs_fi_inv_int_all.currency_cd%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:
62: -- Procedure to Apply the Waiver Credit against the Waiver Adjustment Charges

Line 77: p_n_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,

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,

Line 91: p_n_invoice_id IN igs_fi_inv_int_all.invoice_id%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);

Line 106: p_v_currency_cd IN igs_fi_inv_int_all.currency_cd%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);
110:

Line 107: p_n_waiver_amt IN igs_fi_inv_int_all.invoice_amount%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:
111: -- Procedure to apply the Waiver Adjustment Charges for a Waiver Credit,

Line 135: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%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,
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

Line 155: cp_n_person_id igs_fi_inv_int_all.person_id%TYPE,

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

Line 156: cp_v_target_fee_type igs_fi_inv_int_all.fee_type%TYPE,

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

Line 157: cp_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE,

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

Line 158: cp_n_fee_ci_seq_num igs_fi_inv_int_all.fee_ci_sequence_number%TYPE,

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

Line 159: cp_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE) IS

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

Line 161: FROM igs_fi_inv_int_all inv

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

Line 185: cp_n_person_id igs_fi_inv_int_all.person_id%TYPE,

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,

Line 186: cp_v_target_fee_type igs_fi_inv_int_all.fee_type%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

Line 196: FROM igs_fi_inv_int_all inv,

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

Line 219: cp_v_fee_cal_type igs_fi_inv_int_all.fee_cal_type%TYPE,

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,

Line 220: cp_n_fee_ci_seq_num igs_fi_inv_int_all.fee_ci_sequence_number%TYPE,

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

Line 221: cp_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE) IS

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

Line 224: igs_fi_inv_int_all inv

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

Line 354: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%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: /******************************************************************

Line 355: p_v_currency_cd IN igs_fi_inv_int_all.currency_cd%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: /******************************************************************
359: Created By : Anji Yedubati

Line 401: cp_n_person_id igs_fi_inv_int_all.person_id%TYPE,

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,

Line 402: cp_v_target_fee_type igs_fi_inv_int_all.fee_type%TYPE,

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

Line 407: FROM igs_fi_inv_int_all inv,

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

Line 775: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%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

Line 857: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%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
861: /******************************************************************

Line 858: p_v_currency_cd IN igs_fi_inv_int_all.currency_cd%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: /******************************************************************
862: Created By : Anji Yedubati

Line 957: cp_n_person_id igs_fi_inv_int_all.person_id%TYPE,

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

Line 958: cp_v_adj_fee_type igs_fi_inv_int_all.fee_type%TYPE,

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,

Line 964: FROM igs_fi_inv_int_all inv,

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

Line 983: l_n_inv_amt_due igs_fi_inv_int.invoice_amount_due%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:
987: BEGIN

Line 1068: p_n_invoice_id IN igs_fi_inv_int_all.invoice_id%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,

Line 1092: cp_n_invoice_id igs_fi_inv_int_all.invoice_id%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

Line 1093: cp_n_person_id igs_fi_inv_int_all.person_id%TYPE,

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,

Line 1094: cp_v_target_fee_type igs_fi_inv_int_all.fee_type%TYPE,

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

Line 1099: FROM igs_fi_inv_int_all inv,

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

Line 1119: l_n_inv_amt_due igs_fi_inv_int.invoice_amount_due%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:
1123: BEGIN

Line 1204: p_n_invoice_id IN igs_fi_inv_int_all.invoice_id%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

Line 1256: l_n_inv_amt_due igs_fi_inv_int.invoice_amount_due%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:
1260: BEGIN

Line 1385: p_v_currency_cd IN igs_fi_inv_int_all.currency_cd%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
1389: /******************************************************************

Line 1386: p_n_waiver_amt IN igs_fi_inv_int_all.invoice_amount%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: /******************************************************************
1390: Created By : Anji Yedubati

Line 1401: l_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE;

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;

Line 1410: l_n_inv_amt_due igs_fi_inv_int.invoice_amount_due%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
1414:

Line 1517: cp_n_person_id igs_fi_inv_int_all.person_id%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

Line 1518: cp_v_adj_fee_type igs_fi_inv_int_all.fee_type%TYPE,

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

Line 1526: FROM igs_fi_inv_int_all inv,

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

Line 1587: igs_fi_inv_int_all inv

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'

Line 1600: l_n_invoice_amount igs_fi_inv_int_all.invoice_amount%TYPE;

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;

Line 1609: l_n_inv_amt_due igs_fi_inv_int.invoice_amount_due%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:
1613: BEGIN

Line 1849: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%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

Line 1851: p_v_currency_cd IN igs_fi_inv_int_all.currency_cd%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: /******************************************************************
1855: Created By : Priya Athipatla