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_ELM_RANGE

Line 204: p_fee_type IN IGS_FI_ELM_RANGE.fee_type%TYPE ,

200: RETURN BOOLEAN;
201: --
202: -- Routine to rollover elements ranges between cal instances
203: FUNCTION finp_ins_roll_er(
204: p_fee_type IN IGS_FI_ELM_RANGE.fee_type%TYPE ,
205: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
206: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
207: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
208: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,

Line 209: p_relation_type IN IGS_FI_ELM_RANGE.s_relation_type%TYPE ,

205: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
206: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
207: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
208: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
209: p_relation_type IN IGS_FI_ELM_RANGE.s_relation_type%TYPE ,
210: p_fee_cat IN IGS_FI_ELM_RANGE.fee_cat%TYPE ,
211: p_message_name OUT NOCOPY VARCHAR2 )
212: RETURN BOOLEAN;
213:

Line 210: p_fee_cat IN IGS_FI_ELM_RANGE.fee_cat%TYPE ,

206: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
207: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
208: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
209: p_relation_type IN IGS_FI_ELM_RANGE.s_relation_type%TYPE ,
210: p_fee_cat IN IGS_FI_ELM_RANGE.fee_cat%TYPE ,
211: p_message_name OUT NOCOPY VARCHAR2 )
212: RETURN BOOLEAN;
213:
214: -- Function to roll over Fee Trigger Groups

Line 800: -- * IGS_FI_ELM_RANGE

796: -- * IGS_FI_FEE_RET_SCHD
797: -- * IGS_FI_FEE_ENCMB
798: -- * IGS_FI_CHG_MTH_APP
799: -- * IGS_FI_FEE_AS_RATE
800: -- * IGS_FI_ELM_RANGE
801: -- The assumption is being made that the "destination" IGS_CA_INST
802: -- is open and active - it is the responsibility of the calling routine
803: -- to check for this.
804: -- IGS_GE_NOTE: If some of the IGS_FI_F_TYP_CA_INST records already exist then

Line 1802: -- * IGS_FI_ELM_RANGE

1798: -- * IGS_FI_FEE_RET_SCHD
1799: -- * IGS_FI_FEE_ENCMB
1800: -- * IGS_FI_CHG_MTH_APP
1801: -- * IGS_FI_FEE_AS_RATE
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

Line 2262: p_fee_type IN IGS_FI_ELM_RANGE.fee_type%TYPE ,

2258: --
2259: -- Routine to rollover elements ranges between cal instances
2260:
2261: FUNCTION finp_ins_roll_er(
2262: p_fee_type IN IGS_FI_ELM_RANGE.fee_type%TYPE ,
2263: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2264: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2265: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2266: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,

Line 2267: p_relation_type IN IGS_FI_ELM_RANGE.s_relation_type%TYPE ,

2263: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2264: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2265: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2266: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2267: p_relation_type IN IGS_FI_ELM_RANGE.s_relation_type%TYPE ,
2268: p_fee_cat IN IGS_FI_ELM_RANGE.fee_cat%TYPE ,
2269: p_message_name OUT NOCOPY VARCHAR2 )
2270: RETURN BOOLEAN AS
2271: /*******************************************************************/

Line 2268: p_fee_cat IN IGS_FI_ELM_RANGE.fee_cat%TYPE ,

2264: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2265: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2266: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2267: p_relation_type IN IGS_FI_ELM_RANGE.s_relation_type%TYPE ,
2268: p_fee_cat IN IGS_FI_ELM_RANGE.fee_cat%TYPE ,
2269: p_message_name OUT NOCOPY VARCHAR2 )
2270: RETURN BOOLEAN AS
2271: /*******************************************************************/
2272: --Change History

Line 2287: v_range_number IGS_FI_ELM_RANGE.range_number%TYPE;

2283: v_er_record_exists_ind BOOLEAN;
2284: v_err_record_inserted_ind BOOLEAN;
2285: v_err_record_exists_ind BOOLEAN;
2286: v_message_name VARCHAR2(30);
2287: v_range_number IGS_FI_ELM_RANGE.range_number%TYPE;
2288: v_logical_delete_dt IGS_FI_ELM_RANGE.logical_delete_dt%TYPE;
2289: v_er_id NUMBER;
2290: v_err_id NUMBER;
2291: l_rowid VARCHAR2(25);

Line 2288: v_logical_delete_dt IGS_FI_ELM_RANGE.logical_delete_dt%TYPE;

2284: v_err_record_inserted_ind BOOLEAN;
2285: v_err_record_exists_ind BOOLEAN;
2286: v_message_name VARCHAR2(30);
2287: v_range_number IGS_FI_ELM_RANGE.range_number%TYPE;
2288: v_logical_delete_dt IGS_FI_ELM_RANGE.logical_delete_dt%TYPE;
2289: v_er_id NUMBER;
2290: v_err_id NUMBER;
2291: l_rowid VARCHAR2(25);
2292: l_sub_er_id VARCHAR2(25);

Line 2317: FROM IGS_FI_ELM_RANGE er

2313: er.lower_range,
2314: er.upper_range,
2315: er.s_chg_method_type,
2316: er.er_id
2317: FROM IGS_FI_ELM_RANGE er
2318: WHERE er.fee_type = p_fee_type AND
2319: er.fee_cal_type = p_source_cal_type AND
2320: er.fee_ci_sequence_number = p_source_sequence_number AND
2321: er.s_relation_type = p_relation_type AND

Line 2327: cp_range_number IGS_FI_ELM_RANGE.range_number%TYPE) IS

2323: (fee_cat = p_fee_cat OR
2324: p_fee_cat IS NULL);
2325: --Included selection of er_id in the cursor select query as a part of CPF build . Bug #3392088
2326: CURSOR c_er_dest (
2327: cp_range_number IGS_FI_ELM_RANGE.range_number%TYPE) IS
2328: SELECT er.er_id,
2329: er.range_number,
2330: er.logical_delete_dt
2331: FROM IGS_FI_ELM_RANGE er

Line 2331: FROM IGS_FI_ELM_RANGE er

2327: cp_range_number IGS_FI_ELM_RANGE.range_number%TYPE) IS
2328: SELECT er.er_id,
2329: er.range_number,
2330: er.logical_delete_dt
2331: FROM IGS_FI_ELM_RANGE er
2332: WHERE er.fee_type = p_fee_type AND
2333: er.fee_cal_type = p_dest_cal_type AND
2334: er.fee_ci_sequence_number = p_dest_sequence_number AND
2335: er.s_relation_type = p_relation_type AND

Line 2338: cp_range_number IGS_FI_ELM_RANGE.range_number%TYPE) IS

2334: er.fee_ci_sequence_number = p_dest_sequence_number AND
2335: er.s_relation_type = p_relation_type AND
2336: er.range_number = cp_range_number;
2337: CURSOR c_err_source (
2338: cp_range_number IGS_FI_ELM_RANGE.range_number%TYPE) IS
2339: SELECT err.rate_number,
2340: err.fee_cat
2341: FROM IGS_FI_ELM_RANGE_RT err
2342: WHERE err.fee_type = p_fee_type AND

Line 2341: FROM IGS_FI_ELM_RANGE_RT err

2337: CURSOR c_err_source (
2338: cp_range_number IGS_FI_ELM_RANGE.range_number%TYPE) IS
2339: SELECT err.rate_number,
2340: err.fee_cat
2341: FROM IGS_FI_ELM_RANGE_RT err
2342: WHERE err.fee_type = p_fee_type AND
2343: err.fee_cal_type = p_source_cal_type AND
2344: err.fee_ci_sequence_number = p_source_sequence_number AND
2345: err.s_relation_type = p_relation_type AND

Line 2349: cp_range_number IGS_FI_ELM_RANGE_RT.range_number%TYPE,

2345: err.s_relation_type = p_relation_type AND
2346: err.range_number = cp_range_number AND
2347: err.logical_delete_dt IS NULL;
2348: CURSOR c_err_dest (
2349: cp_range_number IGS_FI_ELM_RANGE_RT.range_number%TYPE,
2350: cp_rate_number IGS_FI_ELM_RANGE_RT.rate_number%TYPE) IS
2351: SELECT err.range_number,
2352: err.logical_delete_dt
2353: FROM IGS_FI_ELM_RANGE_RT err

Line 2350: cp_rate_number IGS_FI_ELM_RANGE_RT.rate_number%TYPE) IS

2346: err.range_number = cp_range_number AND
2347: err.logical_delete_dt IS NULL;
2348: CURSOR c_err_dest (
2349: cp_range_number IGS_FI_ELM_RANGE_RT.range_number%TYPE,
2350: cp_rate_number IGS_FI_ELM_RANGE_RT.rate_number%TYPE) IS
2351: SELECT err.range_number,
2352: err.logical_delete_dt
2353: FROM IGS_FI_ELM_RANGE_RT err
2354: WHERE err.fee_type = p_fee_type AND

Line 2353: FROM IGS_FI_ELM_RANGE_RT err

2349: cp_range_number IGS_FI_ELM_RANGE_RT.range_number%TYPE,
2350: cp_rate_number IGS_FI_ELM_RANGE_RT.rate_number%TYPE) IS
2351: SELECT err.range_number,
2352: err.logical_delete_dt
2353: FROM IGS_FI_ELM_RANGE_RT err
2354: WHERE err.fee_type = p_fee_type AND
2355: err.fee_cal_type = p_dest_cal_type AND
2356: err.fee_ci_sequence_number = p_dest_sequence_number AND
2357: err.s_relation_type = p_relation_type AND

Line 2401: FROM IGS_FI_ELM_RANGE_RT err

2397: sert.far_id = cp_far_id;
2398:
2399: CURSOR c_err_exists IS
2400: SELECT 'X'
2401: FROM IGS_FI_ELM_RANGE_RT err
2402: WHERE err.fee_type = p_fee_type AND
2403: err.fee_cal_type = p_source_cal_type AND
2404: err.fee_ci_sequence_number = p_source_sequence_number AND
2405: err.s_relation_type = p_relation_type AND

Line 2437: -- This function will roll all IGS_FI_ELM_RANGE and associated

2433: FROM IGS_FI_FEE_AS_RATE far
2434: WHERE far.far_id = cp_far_id;
2435:
2436: BEGIN
2437: -- This function will roll all IGS_FI_ELM_RANGE and associated
2438: -- IGS_FI_ELM_RANGE_RT records underneath a
2439: -- nominated IGS_CA_INST to beneath another nominated IGS_CA_INST.
2440: -- The assumption is being made that the "destination" IGS_CA_INST
2441: -- is open and active - it is the responsibility of the calling routine to

Line 2438: -- IGS_FI_ELM_RANGE_RT records underneath a

2434: WHERE far.far_id = cp_far_id;
2435:
2436: BEGIN
2437: -- This function will roll all IGS_FI_ELM_RANGE and associated
2438: -- IGS_FI_ELM_RANGE_RT records underneath a
2439: -- nominated IGS_CA_INST to beneath another nominated IGS_CA_INST.
2440: -- The assumption is being made that the "destination" IGS_CA_INST
2441: -- is open and active - it is the responsibility of the calling routine to
2442: -- check for this.

Line 2443: -- IGS_GE_NOTE: If some of the elemets_range/IGS_FI_ELM_RANGE_RT records already

2439: -- nominated IGS_CA_INST to beneath another nominated IGS_CA_INST.
2440: -- The assumption is being made that the "destination" IGS_CA_INST
2441: -- is open and active - it is the responsibility of the calling routine to
2442: -- check for this.
2443: -- IGS_GE_NOTE: If some of the elemets_range/IGS_FI_ELM_RANGE_RT records already
2444: -- exist then these will remain unaltered.
2445: p_message_name := Null;
2446: -- 1. Process the elements range records matching the source calendar instance
2447: v_er_record_inserted_ind := FALSE;

Line 2485: -- Check for the existence of the IGS_FI_ELM_RANGE

2481: FOR v_er_source_rec IN c_er_source LOOP
2482:
2483: v_er_id := NULL;
2484:
2485: -- Check for the existence of the IGS_FI_ELM_RANGE
2486: -- record under the destination calendar
2487: OPEN c_er_dest(v_er_source_rec.range_number);
2488: FETCH c_er_dest INTO v_er_id,
2489: v_range_number,

Line 2649: -- Check for the existence of the IGS_FI_ELM_RANGE_RT record

2645: ELSE
2646: -- Process the elements range rate records
2647: -- matching the elements range
2648: FOR v_err_source_rec IN c_err_source(v_er_source_rec.range_number) LOOP
2649: -- Check for the existence of the IGS_FI_ELM_RANGE_RT record
2650: -- under the rolled over elements range
2651: OPEN c_err_dest(
2652: v_er_source_rec.range_number,
2653: v_err_source_rec.rate_number);

Line 2666: IGS_FI_ELM_RANGE_RT_PKG.INSERT_ROW(

2662: CLOSE c_err_dest;
2663: BEGIN
2664: l_rowid :=NULL; -- initialise l_rowid to null before passing into the TBH
2665: -- l_rowid with a value will throw Un-Handled Exception
2666: IGS_FI_ELM_RANGE_RT_PKG.INSERT_ROW(
2667: X_ROWID=>l_rowid,
2668: X_ERR_ID => v_err_id,
2669: X_FEE_TYPE=>p_fee_type,
2670: X_FEE_CAL_TYPE=>p_dest_cal_type,