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

Line 37: svuppala 22-Aug-2005 Enh 3392095, Added waiver_calc_flag column to the IGS_FI_F_CAT_FEE_LBL_Pkg.Insert_Row

33: This is done even for FCFL.
34: svuppala 09-Sep-2005 Bug 3822813 - The setting of variable l_b_fcfl_not_found to TRUE is removed
35: in finp_ins_roll_ftci
36: gurprsin 29-Aug-2005 Bug 3392088, Added max_chg_elements column to the IGS_FI_F_TYP_CA_INST_PKG.Insert_Row
37: svuppala 22-Aug-2005 Enh 3392095, Added waiver_calc_flag column to the IGS_FI_F_CAT_FEE_LBL_Pkg.Insert_Row
38: gurprsin 28-Jun-2005 Bug# 3392088 Modified the rollover process to incorporate
39: sub element ranges and rates table rollover.
40: svuppala 03-Jun-2005 Enh# 3442712 - Modified TBH calls to table IGS_FI_FEE_AS_RATE to include
41: 5 new Unit Level Attributes in insert_row method

Line 151: p_fee_liability_status IN IGS_FI_F_CAT_FEE_LBL.fee_liability_status%TYPE ,

147: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
148: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
149: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
150: p_fee_cat_ci_status IN IGS_FI_F_CAT_CA_INST.fee_cat_ci_status%TYPE ,
151: p_fee_liability_status IN IGS_FI_F_CAT_FEE_LBL.fee_liability_status%TYPE ,
152: p_fee_type IN IGS_FI_FEE_TYPE.fee_type%TYPE ,
153: p_message_name OUT NOCOPY VARCHAR2 ,
154: p_message_warning OUT NOCOPY VARCHAR2 )
155: RETURN BOOLEAN;

Line 174: p_fee_cat IN IGS_FI_F_CAT_FEE_LBL.fee_cat%TYPE ,

170: /* sykrishn 29november2001 Removed the procedure finp_ins_roll_fe - as part of obseletion in bug 2126091. */
171: --
172: -- Routine to rollover fee cat fee liabilities between cal instances
173: FUNCTION finp_ins_roll_fcfl(
174: p_fee_cat IN IGS_FI_F_CAT_FEE_LBL.fee_cat%TYPE ,
175: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
176: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
177: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
178: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,

Line 179: p_fee_type IN IGS_FI_F_CAT_FEE_LBL.fee_type%TYPE ,

175: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
176: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
177: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
178: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
179: p_fee_type IN IGS_FI_F_CAT_FEE_LBL.fee_type%TYPE ,
180: p_fee_liability_status IN IGS_FI_F_CAT_FEE_LBL.fee_liability_status%TYPE ,
181: p_message_name OUT NOCOPY VARCHAR2 ,
182: p_message_warning OUT NOCOPY VARCHAR2 )
183: RETURN BOOLEAN;

Line 180: p_fee_liability_status IN IGS_FI_F_CAT_FEE_LBL.fee_liability_status%TYPE ,

176: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
177: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
178: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
179: p_fee_type IN IGS_FI_F_CAT_FEE_LBL.fee_type%TYPE ,
180: p_fee_liability_status IN IGS_FI_F_CAT_FEE_LBL.fee_liability_status%TYPE ,
181: p_message_name OUT NOCOPY VARCHAR2 ,
182: p_message_warning OUT NOCOPY VARCHAR2 )
183: RETURN BOOLEAN;
184: --

Line 357: p_fee_liability_status IN IGS_FI_F_CAT_FEE_LBL_ALL.fee_liability_status%TYPE,

353: p_fee_type IN IGS_FI_FEE_TYPE_ALL.fee_type%TYPE ,
354: p_fee_cat IN IGS_FI_F_CAT_CA_INST.fee_cat%TYPE ,
355: p_fee_type_ci_status IN IGS_FI_F_TYP_CA_INST_ALL.fee_type_ci_status%TYPE ,
356: p_fee_cat_ci_status IN IGS_FI_F_CAT_CA_INST.fee_cat_ci_status%TYPE ,
357: p_fee_liability_status IN IGS_FI_F_CAT_FEE_LBL_ALL.fee_liability_status%TYPE,
358: p_org_id NUMBER
359: ) AS
360: /*----------------------------------------------------------------------------
361: || Created By :

Line 704: v_fee_cat IGS_FI_F_CAT_FEE_LBL.fee_cat%TYPE;

700: v_process_next_ftci BOOLEAN;
701: v_insert_record BOOLEAN; -- used for diff bet ins/upd of rec for dest cal type. not reqd now as no upd takes place
702: l_already_rolled BOOLEAN := FALSE;
703: l_fcfl_exists_ind BOOLEAN := TRUE;
704: v_fee_cat IGS_FI_F_CAT_FEE_LBL.fee_cat%TYPE;
705: v_fee_type_ci_status IGS_FI_F_TYP_CA_INST.fee_type_ci_status%TYPE;
706: v_tmp_fee_type IGS_FI_F_TYP_CA_INST.fee_type%TYPE;
707: v_closed_ind IGS_FI_FEE_TYPE.closed_ind%TYPE;
708: v_sequence_number IGS_CA_INST.sequence_number%TYPE;

Line 769: cp_fee_type IGS_FI_F_CAT_FEE_LBL.fee_type%TYPE) IS

765: WHERE ftci.fee_type = cp_fee_type AND
766: ftci.fee_cal_type = p_dest_cal_type AND
767: ftci.fee_ci_sequence_number = p_dest_sequence_number;
768: CURSOR c_fcfl (
769: cp_fee_type IGS_FI_F_CAT_FEE_LBL.fee_type%TYPE) IS
770: SELECT fcfl.fee_cat
771: FROM IGS_FI_F_CAT_FEE_LBL fcfl
772: WHERE fcfl.fee_cat = p_fee_cat AND
773: fcfl.fee_cal_type = p_source_cal_type AND

Line 771: FROM IGS_FI_F_CAT_FEE_LBL fcfl

767: ftci.fee_ci_sequence_number = p_dest_sequence_number;
768: CURSOR c_fcfl (
769: cp_fee_type IGS_FI_F_CAT_FEE_LBL.fee_type%TYPE) IS
770: SELECT fcfl.fee_cat
771: FROM IGS_FI_F_CAT_FEE_LBL fcfl
772: WHERE fcfl.fee_cat = p_fee_cat AND
773: fcfl.fee_cal_type = p_source_cal_type AND
774: fcfl.fee_ci_sequence_number = p_source_sequence_number AND
775: fcfl.fee_type = cp_fee_type;

Line 1181: p_fee_liability_status IN IGS_FI_F_CAT_FEE_LBL.fee_liability_status%TYPE ,

1177: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
1178: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
1179: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
1180: p_fee_cat_ci_status IN IGS_FI_F_CAT_CA_INST.fee_cat_ci_status%TYPE ,
1181: p_fee_liability_status IN IGS_FI_F_CAT_FEE_LBL.fee_liability_status%TYPE ,
1182: p_fee_type IN IGS_FI_FEE_TYPE.fee_type%TYPE ,
1183: p_message_name OUT NOCOPY VARCHAR2 ,
1184: p_message_warning OUT NOCOPY VARCHAR2 )
1185: /*----------------------------------------------------------------------------

Line 1213: v_fee_type IGS_FI_F_CAT_FEE_LBL.fee_type%TYPE;

1209: v_fcci_inserted_ind BOOLEAN;
1210: v_fcci_exists_ind BOOLEAN;
1211: v_process_next_fcci BOOLEAN;
1212: v_fee_cat IGS_FI_F_CAT_CA_INST.fee_cat%TYPE;
1213: v_fee_type IGS_FI_F_CAT_FEE_LBL.fee_type%TYPE;
1214: v_fee_cat_ci_status IGS_FI_F_CAT_CA_INST.fee_cat_ci_status%TYPE;
1215: v_valid_dai BOOLEAN;
1216: v_dummy IGS_CA_DA_INST.dt_alias%TYPE;
1217: l_rowid VARCHAR2(25);

Line 1247: cp_fee_cat IGS_FI_F_CAT_FEE_LBL.fee_cat%TYPE) IS

1243: WHERE fcci.fee_cat= cp_fee_cat AND
1244: fcci.fee_cal_type = p_dest_cal_type AND
1245: fcci.fee_ci_sequence_number = p_dest_sequence_number;
1246: CURSOR c_fcfl (
1247: cp_fee_cat IGS_FI_F_CAT_FEE_LBL.fee_cat%TYPE) IS
1248: SELECT fcfl.fee_type
1249: FROM IGS_FI_F_CAT_FEE_LBL fcfl
1250: WHERE fcfl.fee_cat = cp_fee_cat AND
1251: fcfl.fee_cal_type = p_source_cal_type AND

Line 1249: FROM IGS_FI_F_CAT_FEE_LBL fcfl

1245: fcci.fee_ci_sequence_number = p_dest_sequence_number;
1246: CURSOR c_fcfl (
1247: cp_fee_cat IGS_FI_F_CAT_FEE_LBL.fee_cat%TYPE) IS
1248: SELECT fcfl.fee_type
1249: FROM IGS_FI_F_CAT_FEE_LBL fcfl
1250: WHERE fcfl.fee_cat = cp_fee_cat AND
1251: fcfl.fee_cal_type = p_source_cal_type AND
1252: fcfl.fee_ci_sequence_number = p_source_sequence_number AND
1253: fcfl.fee_type = p_fee_type;

Line 1272: -- * IGS_FI_F_CAT_FEE_LBL

1268: -- It also controls the rollover of
1269: -- * fee_refund_schedule
1270: -- * IGS_FI_FEE_RET_SCHD
1271: -- * IGS_FI_FEE_ENCMB
1272: -- * IGS_FI_F_CAT_FEE_LBL
1273: -- The assumption is being made that the "destination" IGS_CA_INST
1274: -- is open and active - it is the responsibility of the calling routine
1275: -- to check for this.
1276: -- IGS_GE_NOTE: If some of the IGS_FI_F_CAT_CA_INST records already exist then

Line 1698: p_fee_cat IN IGS_FI_F_CAT_FEE_LBL.fee_cat%TYPE ,

1694: --sykrishn 29november2001 Removed the procedure finp_ins_roll_fe - as part of obseletion in bug 2126091.
1695: --
1696: -- Routine to rollover fee cat fee liabilities between cal instances
1697: FUNCTION finp_ins_roll_fcfl(
1698: p_fee_cat IN IGS_FI_F_CAT_FEE_LBL.fee_cat%TYPE ,
1699: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
1700: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
1701: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
1702: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,

Line 1703: p_fee_type IN IGS_FI_F_CAT_FEE_LBL.fee_type%TYPE ,

1699: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
1700: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
1701: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
1702: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
1703: p_fee_type IN IGS_FI_F_CAT_FEE_LBL.fee_type%TYPE ,
1704: p_fee_liability_status IN IGS_FI_F_CAT_FEE_LBL.fee_liability_status%TYPE ,
1705: p_message_name OUT NOCOPY VARCHAR2 ,
1706: p_message_warning OUT NOCOPY VARCHAR2 )
1707: RETURN BOOLEAN AS

Line 1704: p_fee_liability_status IN IGS_FI_F_CAT_FEE_LBL.fee_liability_status%TYPE ,

1700: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
1701: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
1702: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
1703: p_fee_type IN IGS_FI_F_CAT_FEE_LBL.fee_type%TYPE ,
1704: p_fee_liability_status IN IGS_FI_F_CAT_FEE_LBL.fee_liability_status%TYPE ,
1705: p_message_name OUT NOCOPY VARCHAR2 ,
1706: p_message_warning OUT NOCOPY VARCHAR2 )
1707: RETURN BOOLEAN AS
1708: /*----------------------------------------------------------------------------

Line 1721: || svuppala 22-Aug-2005 Enh 3392095, Added waiver_calc_flag column to the IGS_FI_F_CAT_FEE_LBL_Pkg.Insert_Row

1717: || sapanigr 29-Mar-2006 Bug 4606670. Out parameter p_message_name assigned dummy value cst_warning
1718: || if calls to finp_ins_roll_frtns or finp_ins_roll_far returns this value.
1719: || akandreg 10-Nov-2005 Bugs 4680440 , 4232201 - Validation on Charge Method/Rule Seq Num at FCFL level
1720: || Before rolling over an FCFL, validate whether Charge Method/Rule Seq Num has a value at source.
1721: || svuppala 22-Aug-2005 Enh 3392095, Added waiver_calc_flag column to the IGS_FI_F_CAT_FEE_LBL_Pkg.Insert_Row
1722: || Modified cursor c_fcfl_fss to get waiver_calc_flag
1723: || pathipat 12-Jul-2004 Bug 3759552 - Added code to roll over Fee Trig Groups, Unit Triggers
1724: || and Unit Set Triggers.
1725: || pathipat 24-Jan-2003 Bug: 2765199 - Removed exception section

Line 1729: || c_fcfl_fss and from the call to IGS_FI_F_CAT_FEE_LBL_PKG.INSERT_ROW).

1725: || pathipat 24-Jan-2003 Bug: 2765199 - Removed exception section
1726: || vvutukur 26-Aug-2002 Bug#2531390.The comment in the code regarding the rollover of fee payment
1727: || schedules is removed to avoid confusion.
1728: || vvutukur 23-Jul-2002 Bug#2425767.Removed references to payment_hierarchy_rank(from cursor
1729: || c_fcfl_fss and from the call to IGS_FI_F_CAT_FEE_LBL_PKG.INSERT_ROW).
1730: ----------------------------------------------------------------------------*/
1731: gv_other_detail VARCHAR2(255);
1732: l_v_token1_val IGS_LOOKUP_VALUES.MEANING%TYPE;
1733: BEGIN

Line 1743: v_fee_liability_status IGS_FI_F_CAT_FEE_LBL.fee_liability_status%TYPE;

1739: v_message_warning VARCHAR2(30);
1740: v_fcfl_inserted_ind BOOLEAN;
1741: v_fcfl_exists_ind BOOLEAN;
1742: v_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE;
1743: v_fee_liability_status IGS_FI_F_CAT_FEE_LBL.fee_liability_status%TYPE;
1744: v_next_fcfl BOOLEAN;
1745: v_valid_dai BOOLEAN;
1746: v_dummy IGS_CA_DA_INST.dt_alias%TYPE;
1747: l_n_org_id IGS_FI_F_CAT_FEE_LBL.ORG_ID%type := igs_ge_gen_003.get_org_id;

Line 1747: l_n_org_id IGS_FI_F_CAT_FEE_LBL.ORG_ID%type := igs_ge_gen_003.get_org_id;

1743: v_fee_liability_status IGS_FI_F_CAT_FEE_LBL.fee_liability_status%TYPE;
1744: v_next_fcfl BOOLEAN;
1745: v_valid_dai BOOLEAN;
1746: v_dummy IGS_CA_DA_INST.dt_alias%TYPE;
1747: l_n_org_id IGS_FI_F_CAT_FEE_LBL.ORG_ID%type := igs_ge_gen_003.get_org_id;
1748: l_rowid VARCHAR2(25);
1749: CURSOR c_fcfl_fss IS
1750: SELECT fcfl.fee_type,
1751: fcfl.fee_liability_status,

Line 1758: FROM IGS_FI_F_CAT_FEE_LBL fcfl,

1754: fcfl.s_chg_method_type,
1755: fcfl.rul_sequence_number,
1756: fcfl.fee_cat,
1757: fcfl.waiver_calc_flag
1758: FROM IGS_FI_F_CAT_FEE_LBL fcfl,
1759: IGS_FI_FEE_STR_STAT fss
1760: WHERE fcfl.fee_cat = p_fee_cat AND
1761: fcfl.fee_cal_type = p_source_cal_type AND
1762: fcfl.fee_ci_sequence_number = p_source_sequence_number AND

Line 1768: cp_fee_type IGS_FI_F_CAT_FEE_LBL.fee_type%TYPE) IS

1764: p_fee_type IS NULL) AND
1765: fcfl.fee_liability_status = fss.fee_structure_status AND
1766: fss.s_fee_structure_status = cst_active;
1767: CURSOR c_fcfl (
1768: cp_fee_type IGS_FI_F_CAT_FEE_LBL.fee_type%TYPE) IS
1769: SELECT fcfl.fee_type
1770: FROM IGS_FI_F_CAT_FEE_LBL fcfl
1771: WHERE fcfl.fee_cat = p_fee_cat AND
1772: fcfl.fee_cal_type = p_dest_cal_type AND

Line 1770: FROM IGS_FI_F_CAT_FEE_LBL fcfl

1766: fss.s_fee_structure_status = cst_active;
1767: CURSOR c_fcfl (
1768: cp_fee_type IGS_FI_F_CAT_FEE_LBL.fee_type%TYPE) IS
1769: SELECT fcfl.fee_type
1770: FROM IGS_FI_F_CAT_FEE_LBL fcfl
1771: WHERE fcfl.fee_cat = p_fee_cat AND
1772: fcfl.fee_cal_type = p_dest_cal_type AND
1773: fcfl.fee_ci_sequence_number = p_dest_sequence_number AND
1774: fcfl.fee_type = cp_fee_type;

Line 1794: -- This function will roll all IGS_FI_F_CAT_FEE_LBL records underneath a

1790: sequence_number = cp_sequence_number AND
1791: cal_type = cp_cal_type AND
1792: ci_sequence_number = cp_ci_sequence_number;
1793: BEGIN
1794: -- This function will roll all IGS_FI_F_CAT_FEE_LBL records underneath a
1795: -- nominated IGS_CA_INST to beneath another nominated IGS_CA_INST.
1796: -- It also controls the rollovr of
1797: -- * fee_refund_schedule
1798: -- * IGS_FI_FEE_RET_SCHD

Line 1806: -- IGS_GE_NOTE: If some of the IGS_FI_F_CAT_FEE_LBL records already exist then

1802: -- * IGS_FI_ELM_RANGE
1803: -- The assumption is being made that the "destination" IGS_CA_INST
1804: -- is open and active - it is the responsibility of the calling routine
1805: -- to check for this.
1806: -- IGS_GE_NOTE: If some of the IGS_FI_F_CAT_FEE_LBL records already exist then
1807: -- these will remain unaltered.
1808: p_message_name := Null;
1809: -- 1. Process the fee category fee liability records matching the
1810: -- source calendar instance.

Line 1825: -- Check for the existence of the IGS_FI_F_CAT_FEE_LBL

1821: FND_MESSAGE.SET_TOKEN('FTCI_FCFL',l_v_token1_val);
1822: fnd_file.put_line(fnd_file.log,fnd_message.Get);
1823: v_next_fcfl := TRUE;
1824: END IF;
1825: -- Check for the existence of the IGS_FI_F_CAT_FEE_LBL
1826: -- record under the destination calendar
1827:
1828: OPEN c_fcfl(
1829: v_fcfl_fss_rec.fee_type);

Line 1849: -- process next IGS_FI_F_CAT_FEE_LBL

1845: -- record under the destination calendar
1846: OPEN c_ftci( v_fcfl_fss_rec.fee_type);
1847: FETCH c_ftci INTO v_fee_type;
1848: IF (c_ftci%NOTFOUND) THEN
1849: -- process next IGS_FI_F_CAT_FEE_LBL
1850: v_next_fcfl := TRUE;
1851: END IF;
1852: CLOSE c_ftci;
1853: -- validate status

Line 1861: -- process next IGS_FI_F_CAT_FEE_LBL

1857: p_dest_cal_type,
1858: p_dest_sequence_number,
1859: v_message_name) = FALSE) THEN
1860: FND_FILE.PUT_LINE (FND_FILE.LOG, Fnd_Message.Get_String('IGS',v_message_name));
1861: -- process next IGS_FI_F_CAT_FEE_LBL
1862: v_next_fcfl := TRUE;
1863: END IF;
1864: END IF;
1865: IF (v_next_fcfl = FALSE) THEN

Line 1874: -- process next IGS_FI_F_CAT_FEE_LBL

1870: v_fcfl_fss_rec.fee_type,
1871: v_fee_liability_status,
1872: v_message_name) = FALSE) THEN
1873: FND_FILE.PUT_LINE (FND_FILE.LOG, Fnd_Message.Get_String('IGS',v_message_name));
1874: -- process next IGS_FI_F_CAT_FEE_LBL
1875: v_next_fcfl := TRUE;
1876: END IF;
1877: END IF;
1878: IF (v_next_fcfl = FALSE) THEN

Line 1904: IGS_FI_F_CAT_FEE_LBL_PKG.INSERT_ROW(

1900: IF v_valid_dai THEN
1901: BEGIN
1902: l_rowid := NULL; -- initialise l_rowid to null before passing into the TBH
1903: -- l_rowid with a value will throw Un-Handled Exception
1904: IGS_FI_F_CAT_FEE_LBL_PKG.INSERT_ROW(
1905: X_ROWID=>l_rowid,
1906: X_FEE_CAT=>p_fee_cat,
1907: X_FEE_CI_SEQUENCE_NUMBER=>p_dest_sequence_number,
1908: X_FEE_TYPE=>v_fcfl_fss_rec.fee_type,