[Home] [Help]
12: Who When What
13: abshriva 17-May-2006 Bug 5113295 - Added function chk_unit_prg_transfer
14: uudayapr 8-Oct-2005 BUG 4660773 Added the Function mask_card_number for masking the CC Number
15: agairola 27-Sep-2005 Bug # 4625955 Added new PLSQL procedure chk_spa_rec_exists
16: svuppala 16-May-2005 Bug # 4226849 Added New PLSQL function which will return the latest standard
17: balance of the student for the personid provided as input to it.
18: bannamal 14-Apr-2005 Bug#4297359 ER Registration fee issue.
19: Modified the function get_complete_withdr_ret_amt. Added the parameter p_v_nonzero_billable_cp_flag.
20: Modified the where clause of the cursor cur_unit_attmpt.
610: 2.1 If even one Unit Section incurs load, then no Retention is applicable.
611: 2.2 If none of the Unit Sections incur load, then verify if all the
612: Unit sections were dropped in the 0% Retention Period.
613: ( Discontinued Date < Date Alias of the Earliest Retention Schedule)
614: 2.2.1 If Usec is Non-Standard, compare against schedules defined at
615: NS Unit Section level, not from Teaching Period schedules
616: 2.2.1.1 Usec + Fee Type level OR Usec level OR Institution level
617: 2.2.2 If Standard Usec,
618: 2.2.2.1 If the Usec were dropped in the 0% Retention Period, then no
613: ( Discontinued Date < Date Alias of the Earliest Retention Schedule)
614: 2.2.1 If Usec is Non-Standard, compare against schedules defined at
615: NS Unit Section level, not from Teaching Period schedules
616: 2.2.1.1 Usec + Fee Type level OR Usec level OR Institution level
617: 2.2.2 If Standard Usec,
618: 2.2.2.1 If the Usec were dropped in the 0% Retention Period, then no
619: Retention is applicable. Return 0.
620: 2.2.2.2 If the Usec were NOT dropped in the 0% Retention Period, then
621: set local flag (l_b_zero_ret_drop) to TRUE. Apply 100% Retention.
716: -- Variable to indicate whether retention is 0 or Full Amount
717: l_b_zero_ret_drop BOOLEAN := FALSE;
718:
719: -- Local variable to indicate whether Retention Schedules have been found
720: -- at the (Non Standard Unit Section + Fee Type) level
721: l_b_ft_ret_found BOOLEAN := FALSE;
722:
723: -- Local variable to indicate whether Retention Schedules have been found
724: -- at the Non Standard Unit Section level
720: -- at the (Non Standard Unit Section + Fee Type) level
721: l_b_ft_ret_found BOOLEAN := FALSE;
722:
723: -- Local variable to indicate whether Retention Schedules have been found
724: -- at the Non Standard Unit Section level
725: l_b_usec_ret_found BOOLEAN := FALSE;
726:
727:
728: BEGIN
750: END IF;
751:
752: IF rec_unit_attmpt.non_std_usec_ind = 'Y' THEN
753:
754: -- For Non-Standard Unit Sections
755: -- If load is not incurred, check the Discontinued Date against the Retention Date Alias defined at Usec level
756: -- Fetch Retention Schedules defined at Unit Section + Fee Type level
757: FOR rec_ns_ft_ret IN cur_ns_ft_ret(rec_unit_attmpt.uoo_id, p_v_fee_type)
758: LOOP
793: END IF;
794:
795: ELSE -- rec_unit_attmpt.non_std_usec_ind <> 'Y'
796:
797: -- For Standard Unit Sections
798: -- If load is not incurred, check the Discontinued Date against the Retention Date Alias (done in cursor cur_tp_ret)
799: OPEN cur_tp_ret(rec_unit_attmpt.cal_type,
800: rec_unit_attmpt.ci_sequence_number,
801: rec_unit_attmpt.discontinued_dt);
834: /**************************************************************************
835: Created By : Priya Athipatla
836: Date Created By: 03-Sep-2004
837: Purpose : Function to determine the Retention Amount for a
838: Non-Standard Unit Section
839: Known limitations,enhancements,remarks:
840:
841: Change History
842: Who When What
893:
894: l_n_cntr NUMBER := 0;
895:
896: -- Local variable to indicate whether Retention Schedules have been found
897: -- at the (Non Standard Unit Section + Fee Type) level or Unit Section level
898: -- or at the Institution level
899: l_b_ret_found BOOLEAN := FALSE;
900:
901: l_n_ret_amount igs_ps_nsus_rtn_dtl.retention_amount%TYPE := 0;
987: Change History
988: Who When What
989: **************************************************************************/
990:
991: -- Cursor to determine if a given Unit Section is Non-Standard
992: CURSOR cur_non_std_usec(cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
993: SELECT cal_type,
994: ci_sequence_number,
995: non_std_usec_ind
1028:
1029: /***************************************************************************
1030: || Created By : svuppala
1031: || Created On : 10-Apr-2002
1032: || Purpose : New PLSQL function which will return the latest standard
1033: || balance for the student for the personid provided as input to it
1034: ||
1035: || Known limitations, enhancements or remarks :
1036: || Change History :
1037: || Who When What
1038: || (reverse chronological order - newest change first)
1039: ******************************************************************************/
1040:
1041: -- Cursor for fetching the standard balance for the partyid passed as input to the function
1042: CURSOR cur_partyid(cp_partyid NUMBER) IS
1043: SELECT standard_balance
1044: FROM igs_fi_balances
1045: WHERE party_id = cp_partyid
1039: ******************************************************************************/
1040:
1041: -- Cursor for fetching the standard balance for the partyid passed as input to the function
1042: CURSOR cur_partyid(cp_partyid NUMBER) IS
1043: SELECT standard_balance
1044: FROM igs_fi_balances
1045: WHERE party_id = cp_partyid
1046: ORDER BY balance_date DESC;
1047:
1044: FROM igs_fi_balances
1045: WHERE party_id = cp_partyid
1046: ORDER BY balance_date DESC;
1047:
1048: l_std_balance igs_fi_balances.standard_balance%TYPE;
1049:
1050: BEGIN
1051:
1052: -- Fetch the standard Balance
1048: l_std_balance igs_fi_balances.standard_balance%TYPE;
1049:
1050: BEGIN
1051:
1052: -- Fetch the standard Balance
1053: OPEN cur_partyid(p_partyid);
1054: FETCH cur_partyid INTO l_std_balance;
1055: IF cur_partyid%NOTFOUND THEN
1056: l_std_balance := 0;