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_VAL_FTCI dependencies on IGS_FI_F_CAT_FEE_LBL

Line 5: pmarada 28-jul-2005 Enh 3392095, Added waiver_calc_flag cloumn to the IGS_FI_F_CAT_FEE_LBL_Pkg.Update_Row

1: PACKAGE BODY IGS_FI_VAL_FTCI AS
2: /* $Header: IGSFI34B.pls 120.1 2005/07/28 07:41:33 appldev ship $ */
3: /*
4: Who When What
5: pmarada 28-jul-2005 Enh 3392095, Added waiver_calc_flag cloumn to the IGS_FI_F_CAT_FEE_LBL_Pkg.Update_Row
6: shtatiko 04-FEB-2004 Enh# 3167098, Removed validation of Retro Date Alias from finp_val_ftci_dates.
7: vvutukur 29-Jul-2002 Bug#2425767. Removed payment_hierarchy_rank column references as this
8: is obsoleted(from call to IGS_FI_F_CAT_FEE_LBL_Pkg.Update_Row in
9: FUNCTION finp_upd_fcfl_status.Removed function finp_val_ftci_rank

Line 8: is obsoleted(from call to IGS_FI_F_CAT_FEE_LBL_Pkg.Update_Row in

4: Who When What
5: pmarada 28-jul-2005 Enh 3392095, Added waiver_calc_flag cloumn to the IGS_FI_F_CAT_FEE_LBL_Pkg.Update_Row
6: shtatiko 04-FEB-2004 Enh# 3167098, Removed validation of Retro Date Alias from finp_val_ftci_dates.
7: vvutukur 29-Jul-2002 Bug#2425767. Removed payment_hierarchy_rank column references as this
8: is obsoleted(from call to IGS_FI_F_CAT_FEE_LBL_Pkg.Update_Row in
9: FUNCTION finp_upd_fcfl_status.Removed function finp_val_ftci_rank
10: as this function validates payment_hierarchy_rank,an obsoleted column.)
11: vchappid 25-Apr-2002 Bug# 2329407, Removed the parameters account_cd, fin_cal_type
12: and fin_ci_sequence_number from the function call finp_val_ftci_rqrd

Line 94: -- Validate IGS_FI_F_CAT_FEE_LBL calender instance has

90: WHERE ct.CAL_TYPE = cir.sup_cal_type AND
91: ct.S_CAL_CAT = cst_cal_cat AND
92: ct.closed_ind = 'N');
93: BEGIN
94: -- Validate IGS_FI_F_CAT_FEE_LBL calender instance has
95: --subordinate relationships to 'TEACHING PERIOD' calender
96: --instances. IGS_GE_NOTE: IGS_FI_F_CAT_FEE_LBL calender instances
97: --must be of category 'FEE'.
98: --1. Check parameters

Line 96: --instances. IGS_GE_NOTE: IGS_FI_F_CAT_FEE_LBL calender instances

92: ct.closed_ind = 'N');
93: BEGIN
94: -- Validate IGS_FI_F_CAT_FEE_LBL calender instance has
95: --subordinate relationships to 'TEACHING PERIOD' calender
96: --instances. IGS_GE_NOTE: IGS_FI_F_CAT_FEE_LBL calender instances
97: --must be of category 'FEE'.
98: --1. Check parameters
99: IF (p_fee_cal_type IS NULL OR
100: p_fee_ci_sequence_number IS NULL) THEN

Line 134: v_fee_liability_status IGS_FI_F_CAT_FEE_LBL.fee_liability_status%TYPE;

130: DECLARE
131: e_resource_busy EXCEPTION;
132: PRAGMA EXCEPTION_INIT(e_resource_busy, -54);
133: v_s_fee_structure_status IGS_FI_FEE_STR_STAT.s_fee_structure_status%TYPE;
134: v_fee_liability_status IGS_FI_F_CAT_FEE_LBL.fee_liability_status%TYPE;
135: CURSOR c_fss IS
136: SELECT fss.s_fee_structure_status
137: FROM IGS_FI_FEE_STR_STAT fss
138: WHERE fss.fee_structure_status = p_fee_type_ci_status;

Line 141: FROM IGS_FI_F_CAT_FEE_LBL fcfl

137: FROM IGS_FI_FEE_STR_STAT fss
138: WHERE fss.fee_structure_status = p_fee_type_ci_status;
139: CURSOR c_fcfl IS
140: SELECT fcfl.*, fcfl.rowid -- kdande -> rowid was added to make a call to Update_Row TBH.
141: FROM IGS_FI_F_CAT_FEE_LBL fcfl
142: WHERE fcfl.fee_cal_type = p_fee_cal_type AND
143: fcfl.fee_ci_sequence_number = p_fee_ci_sequence_number AND
144: fcfl.fee_type =p_fee_type
145: FOR UPDATE OF fcfl.fee_liability_status NOWAIT;

Line 149: -- to 'INACTIVE' update the IGS_FI_F_CAT_FEE_LBL.fee_liability_status

145: FOR UPDATE OF fcfl.fee_liability_status NOWAIT;
146: fcfl_rec c_fcfl%ROWTYPE; -- kdande -> Added while converting DMLs.
147: BEGIN
148: -- When the fee_cal_instance.fee_type_ci_status is changed
149: -- to 'INACTIVE' update the IGS_FI_F_CAT_FEE_LBL.fee_liability_status
150: -- in related records to 'INACTIVE'.
151: p_message_name := NULL;
152: -- 1. Check if the fee_type_ci_status relates to a system
153: -- status in IGS_FI_FEE_STR_STAT of 'INACTIVE'.

Line 160: -- 2. Update any related IGS_FI_F_CAT_FEE_LBL records.

156: CLOSE c_fss;
157: IF (v_s_fee_structure_status <> 'INACTIVE') THEN
158: RETURN TRUE;
159: END IF;
160: -- 2. Update any related IGS_FI_F_CAT_FEE_LBL records.
161: OPEN c_fcfl;
162: LOOP
163: FETCH c_fcfl INTO fcfl_rec; -- kdande -> Added fcfl_rec for use in Update_Row DML.
164: IF (c_fcfl%NOTFOUND) THEN

Line 170: IGS_FI_F_CAT_FEE_LBL_Pkg.Update_Row (

166: RETURN TRUE;
167: END IF;
168:
169: /* Call server side TBH package procedure */
170: IGS_FI_F_CAT_FEE_LBL_Pkg.Update_Row (
171: x_rowid => fcfl_rec.rowid,
172: x_fee_cat => fcfl_rec.fee_cat,
173: x_fee_ci_sequence_number => fcfl_rec.fee_ci_sequence_number,
174: x_fee_type => fcfl_rec.fee_type,

Line 351: v_fee_type IGS_FI_F_CAT_FEE_LBL.fee_type%TYPE;

347: cst_institutn CONSTANT IGS_FI_FEE_TYPE.s_fee_trigger_cat%TYPE := 'INSTITUTN';
348: cst_active CONSTANT IGS_FI_FEE_STR_STAT.fee_structure_status%TYPE := 'ACTIVE';
349: v_s_fee_type IGS_FI_FEE_TYPE.s_fee_type%TYPE;
350: v_s_fee_trigger_cat IGS_FI_FEE_TYPE.s_fee_trigger_cat%TYPE;
351: v_fee_type IGS_FI_F_CAT_FEE_LBL.fee_type%TYPE;
352: v_s_fee_structure_status IGS_FI_FEE_STR_STAT.fee_structure_status%TYPE;
353: v_acc_closed_ind IGS_FI_ACC.closed_ind%TYPE;
354: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
355: v_s_cal_cat IGS_CA_TYPE.S_CAL_CAT%TYPE;

Line 368: FROM IGS_FI_F_CAT_FEE_LBL fcfl

364: FROM IGS_FI_FEE_TYPE ft
365: WHERE ft.fee_type = p_fee_type;
366: CURSOR c_fcfl IS
367: SELECT fcfl.fee_type
368: FROM IGS_FI_F_CAT_FEE_LBL fcfl
369: WHERE fcfl.fee_type = p_fee_type AND
370: fcfl.fee_cal_type = p_fee_cal_type AND
371: fcfl.fee_ci_sequence_number = p_fee_ci_sequence_number;
372: CURSOR c_fee_ci IS

Line 511: -- 3. If there are related IGS_FI_F_CAT_FEE_LBL records the s_chg_method_type

507: RETURN FALSE;
508: END IF;
509: -- End of Modifications Enh# 2187247
510:
511: -- 3. If there are related IGS_FI_F_CAT_FEE_LBL records the s_chg_method_type
512: -- or rul_sequence_number cannot be added or removed (can however be changed)
513: IF (p_chg_method IS NULL AND p_old_chg_method IS NOT NULL) OR
514: (p_chg_method IS NOT NULL AND p_old_chg_method IS NULL) OR
515: (p_rule_sequence IS NULL AND p_old_rule_sequence IS NOT NULL) OR

Line 549: v_fee_type IGS_FI_F_CAT_FEE_LBL.fee_type%TYPE;

545: cst_inactive CONSTANT
546: IGS_FI_FEE_STR_STAT.fee_structure_status%TYPE := 'INACTIVE';
547: v_new_system_status IGS_FI_FEE_STR_STAT.s_fee_structure_status%TYPE;
548: v_old_system_status IGS_FI_FEE_STR_STAT.s_fee_structure_status%TYPE;
549: v_fee_type IGS_FI_F_CAT_FEE_LBL.fee_type%TYPE;
550: CURSOR c_fss (
551: cp_ftci_status IGS_FI_FEE_STR_STAT.fee_structure_status%TYPE) IS
552: SELECT fss.s_fee_structure_status
553: FROM IGS_FI_FEE_STR_STAT fss

Line 557: FROM IGS_FI_F_CAT_FEE_LBL fcfl

553: FROM IGS_FI_FEE_STR_STAT fss
554: WHERE fss.fee_structure_status = cp_ftci_status;
555: CURSOR c_fcfl IS
556: SELECT fcfl.fee_type
557: FROM IGS_FI_F_CAT_FEE_LBL fcfl
558: WHERE fcfl.fee_type = p_fee_type AND
559: fcfl.fee_cal_type = p_fee_cal_type AND
560: fcfl.fee_ci_sequence_number = p_fee_ci_sequence_number;
561: CURSOR c_fcfl_fss IS

Line 563: FROM IGS_FI_F_CAT_FEE_LBL fcfl,

559: fcfl.fee_cal_type = p_fee_cal_type AND
560: fcfl.fee_ci_sequence_number = p_fee_ci_sequence_number;
561: CURSOR c_fcfl_fss IS
562: SELECT fcfl.fee_type
563: FROM IGS_FI_F_CAT_FEE_LBL fcfl,
564: IGS_FI_FEE_STR_STAT fss
565: WHERE fcfl.fee_type = p_fee_type AND
566: fcfl.fee_cal_type = p_fee_cal_type AND
567: fcfl.fee_ci_sequence_number = p_fee_ci_sequence_number AND

Line 574: -- IGS_FI_F_CAT_FEE_LBL records.

570: BEGIN
571: -- Validate the IGS_FI_F_TYP_CA_INST.fee_type_ci_status. The checks are:
572: -- Fee_type_ci_status can only be set back to a system status of
573: -- 'PLANNED' from 'ACTIVE' if it has no associated
574: -- IGS_FI_F_CAT_FEE_LBL records.
575: -- Fee_type_ci_status can only be set to a system status of 'INACTIVE' from
576: -- 'ACTIVE' if it has no 'ACTIVE' associated IGS_FI_F_CAT_FEE_LBL records.
577: -- 1. If the status has been changed get the system status:
578: IF (p_new_ftci_status <> p_old_ftci_status) THEN

Line 576: -- 'ACTIVE' if it has no 'ACTIVE' associated IGS_FI_F_CAT_FEE_LBL records.

572: -- Fee_type_ci_status can only be set back to a system status of
573: -- 'PLANNED' from 'ACTIVE' if it has no associated
574: -- IGS_FI_F_CAT_FEE_LBL records.
575: -- Fee_type_ci_status can only be set to a system status of 'INACTIVE' from
576: -- 'ACTIVE' if it has no 'ACTIVE' associated IGS_FI_F_CAT_FEE_LBL records.
577: -- 1. If the status has been changed get the system status:
578: IF (p_new_ftci_status <> p_old_ftci_status) THEN
579: OPEN c_fss(p_new_ftci_status);
580: FETCH c_fss INTO v_new_system_status;

Line 600: -- ACTIVE related IGS_FI_F_CAT_FEE_LBL records

596: END IF;
597: CLOSE c_fcfl;
598: END IF;
599: -- 3. If the new system status is inactive check that there is no
600: -- ACTIVE related IGS_FI_F_CAT_FEE_LBL records
601: IF (v_new_system_status = cst_inactive) THEN
602: OPEN c_fcfl_fss;
603: FETCH c_fcfl_fss INTO v_fee_type;
604: IF (c_fcfl_fss%FOUND) THEN