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_APPLICATIONS

Line 171: CURSOR chgadj_amt_cur (cp_n_invoice_id igs_fi_applications.invoice_id%TYPE) IS

167: AND (cp_n_invoice_id IS NULL OR inv.invoice_id = cp_n_invoice_id)
168: ORDER BY inv.invoice_id;
169:
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

Line 173: FROM igs_fi_applications appl,

169:
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

Line 189: cp_n_invoice_id igs_fi_applications.invoice_id%TYPE,

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,
193: appl.application_id,

Line 197: igs_fi_applications appl,

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

Line 218: CURSOR wavadj_app_cur(cp_n_credit_id igs_fi_applications.credit_id%TYPE,

214: ORDER BY appl.application_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

Line 223: FROM igs_fi_applications appl,

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
226: AND appl.invoice_id = inv.invoice_id
227: AND appl.application_type = 'APP'

Line 233: igs_fi_applications unappl

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
237: AND unappl.application_type = 'UNAPP'

Line 240: l_n_chgadj_amt IGS_FI_APPLICATIONS.amount_applied%TYPE;

236: AND unappl.invoice_id = cp_n_invoice_id
237: AND unappl.application_type = 'UNAPP'
238: AND unappl.amount_applied = - appl.amount_applied );
239:
240: l_n_chgadj_amt IGS_FI_APPLICATIONS.amount_applied%TYPE;
241: l_n_wavadj_amt IGS_FI_APPLICATIONS.amount_applied%TYPE;
242: l_n_net_chg_amount IGS_FI_APPLICATIONS.amount_applied%TYPE;
243: l_n_net_waiver_amt IGS_FI_APPLICATIONS.amount_applied%TYPE;
244:

Line 241: l_n_wavadj_amt IGS_FI_APPLICATIONS.amount_applied%TYPE;

237: AND unappl.application_type = 'UNAPP'
238: AND unappl.amount_applied = - appl.amount_applied );
239:
240: l_n_chgadj_amt IGS_FI_APPLICATIONS.amount_applied%TYPE;
241: l_n_wavadj_amt IGS_FI_APPLICATIONS.amount_applied%TYPE;
242: l_n_net_chg_amount IGS_FI_APPLICATIONS.amount_applied%TYPE;
243: l_n_net_waiver_amt IGS_FI_APPLICATIONS.amount_applied%TYPE;
244:
245: BEGIN

Line 242: l_n_net_chg_amount IGS_FI_APPLICATIONS.amount_applied%TYPE;

238: AND unappl.amount_applied = - appl.amount_applied );
239:
240: l_n_chgadj_amt IGS_FI_APPLICATIONS.amount_applied%TYPE;
241: l_n_wavadj_amt IGS_FI_APPLICATIONS.amount_applied%TYPE;
242: l_n_net_chg_amount IGS_FI_APPLICATIONS.amount_applied%TYPE;
243: l_n_net_waiver_amt IGS_FI_APPLICATIONS.amount_applied%TYPE;
244:
245: BEGIN
246:

Line 243: l_n_net_waiver_amt IGS_FI_APPLICATIONS.amount_applied%TYPE;

239:
240: l_n_chgadj_amt IGS_FI_APPLICATIONS.amount_applied%TYPE;
241: l_n_wavadj_amt IGS_FI_APPLICATIONS.amount_applied%TYPE;
242: l_n_net_chg_amount IGS_FI_APPLICATIONS.amount_applied%TYPE;
243: l_n_net_waiver_amt IGS_FI_APPLICATIONS.amount_applied%TYPE;
244:
245: BEGIN
246:
247: -- Invoke the procedure to validate the Inbound Parameters

Line 976: l_n_app_id igs_fi_applications.application_id%TYPE;

972: AND invln.invoice_id = inv.invoice_id
973: AND NVL(invln.error_account,'N') = 'N'
974: ORDER BY inv.invoice_id;
975:
976: l_n_app_id igs_fi_applications.application_id%TYPE;
977: l_n_amount_apply igs_fi_applications.amount_applied%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;

Line 977: l_n_amount_apply igs_fi_applications.amount_applied%TYPE;

973: AND NVL(invln.error_account,'N') = 'N'
974: ORDER BY inv.invoice_id;
975:
976: l_n_app_id igs_fi_applications.application_id%TYPE;
977: l_n_amount_apply igs_fi_applications.amount_applied%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;

Line 978: l_n_dr_gl_ccid igs_fi_applications.dr_gl_code_ccid%TYPE;

974: ORDER BY inv.invoice_id;
975:
976: l_n_app_id igs_fi_applications.application_id%TYPE;
977: l_n_amount_apply igs_fi_applications.amount_applied%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;

Line 979: l_n_cr_gl_ccid igs_fi_applications.cr_gl_code_ccid%TYPE;

975:
976: l_n_app_id igs_fi_applications.application_id%TYPE;
977: l_n_amount_apply igs_fi_applications.amount_applied%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;

Line 980: l_v_dr_acc_cd igs_fi_applications.dr_account_cd%TYPE;

976: l_n_app_id igs_fi_applications.application_id%TYPE;
977: l_n_amount_apply igs_fi_applications.amount_applied%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);

Line 981: l_v_cr_acc_cd igs_fi_applications.cr_account_cd%TYPE;

977: l_n_amount_apply igs_fi_applications.amount_applied%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;

Line 1112: l_n_app_id igs_fi_applications.application_id%TYPE;

1108: AND invln.invoice_id = inv.invoice_id
1109: AND NVL(invln.error_account,'N') = 'N'
1110: ORDER BY inv.invoice_id;
1111:
1112: l_n_app_id igs_fi_applications.application_id%TYPE;
1113: l_n_amount_apply igs_fi_applications.amount_applied%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;

Line 1113: l_n_amount_apply igs_fi_applications.amount_applied%TYPE;

1109: AND NVL(invln.error_account,'N') = 'N'
1110: ORDER BY inv.invoice_id;
1111:
1112: l_n_app_id igs_fi_applications.application_id%TYPE;
1113: l_n_amount_apply igs_fi_applications.amount_applied%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;

Line 1114: l_n_dr_gl_ccid igs_fi_applications.dr_gl_code_ccid%TYPE;

1110: ORDER BY inv.invoice_id;
1111:
1112: l_n_app_id igs_fi_applications.application_id%TYPE;
1113: l_n_amount_apply igs_fi_applications.amount_applied%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;

Line 1115: l_n_cr_gl_ccid igs_fi_applications.cr_gl_code_ccid%TYPE;

1111:
1112: l_n_app_id igs_fi_applications.application_id%TYPE;
1113: l_n_amount_apply igs_fi_applications.amount_applied%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;

Line 1116: l_v_dr_acc_cd igs_fi_applications.dr_account_cd%TYPE;

1112: l_n_app_id igs_fi_applications.application_id%TYPE;
1113: l_n_amount_apply igs_fi_applications.amount_applied%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);

Line 1117: l_v_cr_acc_cd igs_fi_applications.cr_account_cd%TYPE;

1113: l_n_amount_apply igs_fi_applications.amount_applied%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;

Line 1227: cp_n_invoice_id igs_fi_applications.invoice_id%TYPE,

1223:
1224: -- Fetch the application records other than negative charge adjustment credit,
1225: -- enrollment deposit and other deposits and waiver credit for a charge transaction
1226: CURSOR wav_app_cur (
1227: cp_n_invoice_id igs_fi_applications.invoice_id%TYPE,
1228: cp_cst_app igs_fi_applications.application_type%TYPE) IS
1229: SELECT igs_fi_gen_007.get_sum_appl_amnt(appl.application_id) amount_applied,
1230: appl.application_id,
1231: appl.credit_id,

Line 1228: cp_cst_app igs_fi_applications.application_type%TYPE) IS

1224: -- Fetch the application records other than negative charge adjustment credit,
1225: -- enrollment deposit and other deposits and waiver credit for a charge transaction
1226: CURSOR wav_app_cur (
1227: cp_n_invoice_id igs_fi_applications.invoice_id%TYPE,
1228: cp_cst_app igs_fi_applications.application_type%TYPE) IS
1229: SELECT igs_fi_gen_007.get_sum_appl_amnt(appl.application_id) amount_applied,
1230: appl.application_id,
1231: appl.credit_id,
1232: appl.invoice_id

Line 1233: FROM igs_fi_applications appl,

1229: SELECT igs_fi_gen_007.get_sum_appl_amnt(appl.application_id) amount_applied,
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

Line 1243: FROM igs_fi_applications appl2

1239: AND crd.credit_type_id = cr.credit_type_id
1240: AND cr.credit_class NOT IN ('CHGADJ','WAIVER','ENRDEPOSIT','OTHDEPOSIT')
1241: AND NOT EXISTS(
1242: SELECT 'X'
1243: FROM igs_fi_applications appl2
1244: WHERE appl2.application_type = 'UNAPP'
1245: AND appl2.link_application_id = appl.application_id
1246: AND appl2.amount_applied = - appl.amount_applied)
1247: ORDER BY appl.application_id;

Line 1249: l_n_app_id igs_fi_applications.application_id%TYPE;

1245: AND appl2.link_application_id = appl.application_id
1246: AND appl2.amount_applied = - appl.amount_applied)
1247: ORDER BY appl.application_id;
1248:
1249: l_n_app_id igs_fi_applications.application_id%TYPE;
1250: l_n_amount_apply igs_fi_applications.amount_applied%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;

Line 1250: l_n_amount_apply igs_fi_applications.amount_applied%TYPE;

1246: AND appl2.amount_applied = - appl.amount_applied)
1247: ORDER BY appl.application_id;
1248:
1249: l_n_app_id igs_fi_applications.application_id%TYPE;
1250: l_n_amount_apply igs_fi_applications.amount_applied%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;

Line 1251: l_n_dr_gl_ccid igs_fi_applications.dr_gl_code_ccid%TYPE;

1247: ORDER BY appl.application_id;
1248:
1249: l_n_app_id igs_fi_applications.application_id%TYPE;
1250: l_n_amount_apply igs_fi_applications.amount_applied%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;

Line 1252: l_n_cr_gl_ccid igs_fi_applications.cr_gl_code_ccid%TYPE;

1248:
1249: l_n_app_id igs_fi_applications.application_id%TYPE;
1250: l_n_amount_apply igs_fi_applications.amount_applied%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;

Line 1253: l_v_dr_acc_cd igs_fi_applications.dr_account_cd%TYPE;

1249: l_n_app_id igs_fi_applications.application_id%TYPE;
1250: l_n_amount_apply igs_fi_applications.amount_applied%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);

Line 1254: l_v_cr_acc_cd igs_fi_applications.cr_account_cd%TYPE;

1250: l_n_amount_apply igs_fi_applications.amount_applied%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;

Line 1404: l_n_app_id igs_fi_applications.application_id%TYPE;

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;
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;

Line 1405: l_n_dr_gl_ccid igs_fi_applications.dr_gl_code_ccid%TYPE;

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;
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;

Line 1406: l_n_cr_gl_ccid igs_fi_applications.cr_gl_code_ccid%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;
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;

Line 1407: l_v_dr_acc_cd igs_fi_applications.dr_account_cd%TYPE;

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

Line 1408: l_v_cr_acc_cd igs_fi_applications.cr_account_cd%TYPE;

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

Line 1586: FROM igs_fi_applications appl,

1582: igs_fi_gen_007.get_sum_appl_amnt(appl.application_id) amount_applied,
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'

Line 1594: FROM igs_fi_applications appl2

1590: AND appl.application_type = 'APP'
1591: AND inv.transaction_type <> 'WAIVER_ADJ'
1592: AND NOT EXISTS (
1593: SELECT 'X'
1594: FROM igs_fi_applications appl2
1595: WHERE appl2.application_type = 'UNAPP'
1596: AND appl2.link_application_id = appl.application_id
1597: AND appl2.amount_applied = - appl.amount_applied)
1598: ORDER BY appl.application_id;

Line 1603: l_n_app_id igs_fi_applications.application_id%TYPE;

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;
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;

Line 1604: l_n_dr_gl_ccid igs_fi_applications.dr_gl_code_ccid%TYPE;

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;
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;

Line 1605: l_n_cr_gl_ccid igs_fi_applications.cr_gl_code_ccid%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;
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;

Line 1606: l_v_dr_acc_cd igs_fi_applications.dr_account_cd%TYPE;

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

Line 1607: l_v_cr_acc_cd igs_fi_applications.cr_account_cd%TYPE;

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;
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;