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

Line 105: || pmarada 28-jul-2005 Enh 3392095, Added waiver_calc_flag column to the IGS_FI_F_CAT_FEE_LBL_Pkg.Update_Row

101: || Known limitations, enhancements or remarks :
102: || Change History :
103: || Who When What
104: || (reverse chronological order - newest change first)
105: || pmarada 28-jul-2005 Enh 3392095, Added waiver_calc_flag column to the IGS_FI_F_CAT_FEE_LBL_Pkg.Update_Row
106: || vvutukur 23-Jul-2002 Bug#2425767.Removed references to payment_hierarchy_rank(from the call
107: || to IGS_FI_F_CAT_FEE_LBL_Pkg.Update_Row).
108: ----------------------------------------------------------------------------*/
109: gv_other_detail VARCHAR2(255);

Line 107: || to IGS_FI_F_CAT_FEE_LBL_Pkg.Update_Row).

103: || Who When What
104: || (reverse chronological order - newest change first)
105: || pmarada 28-jul-2005 Enh 3392095, Added waiver_calc_flag column to the IGS_FI_F_CAT_FEE_LBL_Pkg.Update_Row
106: || vvutukur 23-Jul-2002 Bug#2425767.Removed references to payment_hierarchy_rank(from the call
107: || to IGS_FI_F_CAT_FEE_LBL_Pkg.Update_Row).
108: ----------------------------------------------------------------------------*/
109: gv_other_detail VARCHAR2(255);
110: BEGIN
111: DECLARE

Line 121: FROM IGS_FI_F_CAT_FEE_LBL fcfl

117: FROM IGS_FI_FEE_STR_STAT fss
118: WHERE fss.fee_structure_status = p_fee_cat_ci_status;
119: CURSOR c_fcfl IS
120: SELECT fcfl.*, fcfl.rowid -- kdande -> rowid was added to make a call to Update_Row TBH.
121: FROM IGS_FI_F_CAT_FEE_LBL fcfl
122: WHERE fcfl.fee_cal_type = p_fee_cal_type AND
123: fcfl.fee_ci_sequence_number = p_fee_ci_sequence_number AND
124: fcfl.fee_cat =p_fee_cat AND
125: fcfl.fee_liability_status in

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

131: fcfl_rec c_fcfl%ROWTYPE; -- kdande -> Added while converting DMLs.
132:
133: BEGIN
134: -- When the IGS_FI_F_CAT_CA_INST.fee_cat_ci_status is changed
135: -- to 'INACTIVE' update the IGS_FI_F_CAT_FEE_LBL.fee_liability_status
136: -- in related records to 'INACTIVE'.
137: p_message_name := NULL;
138: -- 1. Check if the fee_cat_ci_status relates to a system
139: -- status in IGS_FI_FEE_STR_STAT of 'INACTIVE'.

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

142: CLOSE c_fss;
143: IF (v_s_fee_structure_status <> 'INACTIVE') THEN
144: RETURN TRUE;
145: END IF;
146: -- 2. Update any related IGS_FI_F_CAT_FEE_LBL records.
147: OPEN c_fcfl;
148: LOOP
149: FETCH c_fcfl INTO fcfl_rec; -- kdande -> Added fcfl_rec for use in Update_Row DML.
150: IF (c_fcfl%NOTFOUND) THEN

Line 156: IGS_FI_F_CAT_FEE_LBL_Pkg.Update_Row (

152: RETURN TRUE;
153: END IF;
154:
155: /* Call server side TBH package procedure */
156: IGS_FI_F_CAT_FEE_LBL_Pkg.Update_Row (
157: x_rowid => fcfl_rec.rowid,
158: x_fee_cat => fcfl_rec.fee_cat,
159: x_fee_ci_sequence_number => fcfl_rec.fee_ci_sequence_number,
160: x_fee_type => fcfl_rec.fee_type,

Line 205: v_fee_cat IGS_FI_F_CAT_FEE_LBL.fee_cat%TYPE;

201: cst_inactive CONSTANT
202: IGS_FI_FEE_STR_STAT.fee_structure_status%TYPE := 'INACTIVE';
203: v_new_system_status IGS_FI_FEE_STR_STAT.s_fee_structure_status%TYPE;
204: v_old_system_status IGS_FI_FEE_STR_STAT.s_fee_structure_status%TYPE;
205: v_fee_cat IGS_FI_F_CAT_FEE_LBL.fee_cat%TYPE;
206: CURSOR c_fss (
207: cp_fcci_status IGS_FI_FEE_STR_STAT.fee_structure_status%TYPE) IS
208: SELECT fss.s_fee_structure_status
209: FROM IGS_FI_FEE_STR_STAT fss

Line 213: FROM IGS_FI_F_CAT_FEE_LBL fcfl

209: FROM IGS_FI_FEE_STR_STAT fss
210: WHERE fss.FEE_STRUCTURE_STATUS = cp_fcci_status;
211: CURSOR c_fcfl IS
212: SELECT fcfl.fee_cat
213: FROM IGS_FI_F_CAT_FEE_LBL fcfl
214: WHERE fcfl.fee_cat = p_fee_cat AND
215: fcfl.fee_cal_type = p_fee_cal_type AND
216: fcfl.fee_ci_sequence_number = p_fee_ci_sequence_number;
217: CURSOR c_fcfl_fss IS

Line 219: FROM IGS_FI_F_CAT_FEE_LBL fcfl,

215: fcfl.fee_cal_type = p_fee_cal_type AND
216: fcfl.fee_ci_sequence_number = p_fee_ci_sequence_number;
217: CURSOR c_fcfl_fss IS
218: SELECT fcfl.fee_cat
219: FROM IGS_FI_F_CAT_FEE_LBL fcfl,
220: IGS_FI_FEE_STR_STAT fss
221: WHERE fcfl.fee_cat = p_fee_cat AND
222: fcfl.fee_cal_type = p_fee_cal_type AND
223: fcfl.fee_ci_sequence_number = p_fee_ci_sequence_number AND

Line 230: -- IGS_FI_F_CAT_FEE_LBL records.

226: BEGIN
227: -- Validate the IGS_FI_F_CAT_CA_INST.fee_cat_ci_status. The checks are:
228: -- Fee_cat_ci_status can only be set back to a system status of
229: -- 'PLANNED' from 'ACTIVE' if it has no associate
230: -- IGS_FI_F_CAT_FEE_LBL records.
231: -- Fee_cat_ci_status can only be set to a system status of 'INACTIVE' from
232: -- 'ACTIVE' if it has no 'ACTIVE' associated IGS_FI_F_CAT_FEE_LBL records.
233: -- 1. If the status has been changed get the system status:
234: IF (p_new_fcci_status <> p_old_fcci_status) THEN

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

228: -- Fee_cat_ci_status can only be set back to a system status of
229: -- 'PLANNED' from 'ACTIVE' if it has no associate
230: -- IGS_FI_F_CAT_FEE_LBL records.
231: -- Fee_cat_ci_status can only be set to a system status of 'INACTIVE' from
232: -- 'ACTIVE' if it has no 'ACTIVE' associated IGS_FI_F_CAT_FEE_LBL records.
233: -- 1. If the status has been changed get the system status:
234: IF (p_new_fcci_status <> p_old_fcci_status) THEN
235: OPEN c_fss(p_new_fcci_status);
236: FETCH c_fss INTO v_new_system_status;

Line 256: -- ACTIVE related IGS_FI_F_CAT_FEE_LBL records

252: END IF;
253: CLOSE c_fcfl;
254: END IF;
255: -- 3. If the new system status is planned check that there is no
256: -- ACTIVE related IGS_FI_F_CAT_FEE_LBL records
257: IF (v_new_system_status = cst_inactive) THEN
258: OPEN c_fcfl_fss;
259: FETCH c_fcfl_fss INTO v_fee_cat;
260: IF (c_fcfl_fss%FOUND) THEN