APPS.IGS_FI_PRC_FEE_ROLLV dependencies on IGS_FI_ELM_RANGE_RT

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 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 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,