[Home] [Help]
1004:
1005: -- Invoke the application procedure to create an application
1006: l_n_app_id := NULL;
1007: l_v_err_msg := NULL;
1008: igs_fi_gen_007.create_application(
1009: p_application_id => l_n_app_id,
1010: p_credit_id => p_n_credit_id,
1011: p_invoice_id => waiver_adj_charges_rec.invoice_id,
1012: p_amount_apply => l_n_amount_apply,
1140:
1141: -- Invoke the application procedure to create an application
1142: l_n_app_id := NULL;
1143: l_v_err_msg := NULL;
1144: igs_fi_gen_007.create_application(
1145: p_application_id => l_n_app_id,
1146: p_credit_id => p_n_credit_id,
1147: p_invoice_id => stnt_charges_rec.invoice_id,
1148: p_amount_apply => l_n_amount_apply,
1217:
1218: Change History :
1219: WHO WHEN WHAT
1220: AYEDUBAT 03-NOV-2005 Changed the cursor, wav_app_cur to fetch the amount_applied using the
1221: function call, igs_fi_gen_007.get_sum_appl_amnt for bug# 4634950
1222: ***************************************************************** */
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
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
1233: FROM igs_fi_applications appl,
1276:
1277: -- Invoke the application procedure to un apply the context application
1278: l_n_app_id := wav_app_rec.application_id;
1279: l_v_err_msg := NULL;
1280: igs_fi_gen_007.create_application(
1281: p_application_id => l_n_app_id,
1282: p_credit_id => wav_app_rec.credit_id,
1283: p_invoice_id => wav_app_rec.invoice_id,
1284: p_amount_apply => l_n_amount_apply,
1303:
1304: -- Invoke the application procedure to craete the application
1305: l_n_app_id := NULL;
1306: l_v_err_msg := NULL;
1307: igs_fi_gen_007.create_application(
1308: p_application_id => l_n_app_id,
1309: p_credit_id => p_n_credit_id,
1310: p_invoice_id => wav_app_rec.invoice_id,
1311: p_amount_apply => l_n_amount_apply,
1437: -- Invoke the application procedure to apply the Waiver Adjustment Charge
1438: -- against the Waiver Credit record in entirity
1439: l_n_app_id := NULL;
1440: l_v_err_msg := NULL;
1441: igs_fi_gen_007.create_application(
1442: p_application_id => l_n_app_id,
1443: p_credit_id => p_n_credit_id,
1444: p_invoice_id => l_n_invoice_id,
1445: p_amount_apply => p_n_waiver_amt,
1505:
1506: Change History :
1507: WHO WHEN WHAT
1508: AYEDUBAT 03-NOV-2005 Changed the cursor, appls_otherthan_wavadj_cur to fetch the amount_applied
1509: using the function call, igs_fi_gen_007.get_sum_appl_amnt.
1510: Added the Not exist clause to the cursor,appls_otherthan_wavadj_cur to restrict
1511: the records which are already un applied for bug# 4634950
1512: ***************************************************************** */
1513:
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,
1585: appl.invoice_id
1586: FROM igs_fi_applications appl,
1649:
1650: --Invoke the application procedure to create Application
1651: l_n_app_id := NULL;
1652: l_v_err_msg := NULL;
1653: igs_fi_gen_007.create_application(
1654: p_application_id => l_n_app_id,
1655: p_credit_id => stdnt_waiver_crdits_rec.credit_id,
1656: p_invoice_id => waiver_adj_charges_rec.invoice_id,
1657: p_amount_apply => l_n_amount_apply,
1715:
1716: -- Invoke the application procedure to Un apply the context application
1717: l_v_err_msg := NULL;
1718: l_n_app_id := appls_otherthan_wavadj_rec.application_id;
1719: igs_fi_gen_007.create_application(
1720: p_application_id => l_n_app_id,
1721: p_credit_id => appls_otherthan_wavadj_rec.credit_id,
1722: p_invoice_id => appls_otherthan_wavadj_rec.invoice_id,
1723: p_amount_apply => l_n_amount_apply,
1754: -- Invoke the procedure to apply the context application credit record
1755: -- against the Waiver Adjustment Charge
1756: l_n_app_id := NULL;
1757: l_v_err_msg := NULL;
1758: igs_fi_gen_007.create_application(
1759: p_application_id => l_n_app_id,
1760: p_credit_id => appls_otherthan_wavadj_rec.credit_id,
1761: p_invoice_id => waiver_adj_charges_rec.invoice_id,
1762: p_amount_apply => l_n_amount_apply,