APPS.IGS_FI_PRC_FEE_ROLLV dependencies on IGS_FI_ANC_RATES

Line 3128: FROM IGS_FI_ANC_RATES sfnr

3124: sfars.fee_ci_sequence_number = p_source_ci_sequence_number;
3125: -- cursor to check whether records are present to be rolled over in the Ancillary rates table
3126: CURSOR c_cur_source_rates IS
3127: SELECT *
3128: FROM IGS_FI_ANC_RATES sfnr
3129: WHERE sfnr.fee_type = p_fee_type AND
3130: sfnr.fee_cal_type = p_source_cal_type AND
3131: sfnr.fee_ci_sequence_number = p_source_ci_sequence_number;
3132: -- cursor to check whether records have already been rolled over in the Ancillary rate segments table

Line 3142: FROM IGS_FI_ANC_RATES dfnr

3138: dfars.fee_ci_sequence_number = p_dest_ci_sequence_number;
3139: -- cursor to check whether records have already been rolled over in the Ancillary rates table
3140: CURSOR c_cur_dest_rates IS
3141: SELECT *
3142: FROM IGS_FI_ANC_RATES dfnr
3143: WHERE dfnr.fee_type = p_fee_type AND
3144: dfnr.fee_cal_type = p_dest_cal_type AND
3145: dfnr.fee_ci_sequence_number = p_dest_ci_sequence_number;
3146: v_cur_dest_sgmnts_rec c_cur_dest_sgmnts%ROWTYPE;

Line 3148: l_ancillary_rate_id IGS_FI_ANC_RATES.ancillary_rate_id%TYPE;

3144: dfnr.fee_cal_type = p_dest_cal_type AND
3145: dfnr.fee_ci_sequence_number = p_dest_ci_sequence_number;
3146: v_cur_dest_sgmnts_rec c_cur_dest_sgmnts%ROWTYPE;
3147: v_cur_dest_rates_rec c_cur_dest_rates%ROWTYPE;
3148: l_ancillary_rate_id IGS_FI_ANC_RATES.ancillary_rate_id%TYPE;
3149: l_anc_rate_segment_id IGS_FI_ANC_RT_SGMNTS.anc_rate_segment_id%TYPE;
3150: l_ancillary_attributes IGS_FI_ANC_RT_SGMNTS.ancillary_attributes%TYPE;
3151:
3152: BEGIN

Line 3157: -- both the tables IGS_FI_ANC_RT_SGMNTS and IGS_FI_ANC_RATES.

3153: -- This function will roll over all Ancillary Segments and Ancillary Rates within a
3154: -- particular FTCI combination.(fee_type, Fee_cal_type and fee_ci_sequence_number).
3155: -- The assumption is being made as per the DLD that a successful rollover is the one when both
3156: -- Ancillary Segments and Ancillary Rates are rolled over i.e., when records are inserted in
3157: -- both the tables IGS_FI_ANC_RT_SGMNTS and IGS_FI_ANC_RATES.
3158: p_message_name := NULL;
3159: v_record_inserted_ind := FALSE;
3160: v_sgmnts_record_exists_ind := FALSE;
3161: v_rates_record_exists_ind := FALSE;

Line 3173: -- Check for the existence of records in the rates IGS_FI_ANC_RATES

3169: END IF;
3170: ELSE
3171: OPEN c_cur_dest_rates;
3172: FETCH c_cur_dest_rates INTO v_cur_dest_rates_rec;
3173: -- Check for the existence of records in the rates IGS_FI_ANC_RATES
3174: -- for the given FTCI (fee type, calendar type and sequence number)
3175: IF (c_cur_dest_rates%FOUND) THEN
3176: -- This means that rollover has already happened, no rollover needs to happen
3177: v_rates_record_exists_ind := TRUE;

Line 3179: FND_FILE.PUT_LINE (FND_FILE.LOG, Fnd_Message.Get_String('IGS','IGS_FI_ANC_RATES_ROLLED'));

3175: IF (c_cur_dest_rates%FOUND) THEN
3176: -- This means that rollover has already happened, no rollover needs to happen
3177: v_rates_record_exists_ind := TRUE;
3178: IF (v_rates_record_exists_ind = TRUE) THEN
3179: FND_FILE.PUT_LINE (FND_FILE.LOG, Fnd_Message.Get_String('IGS','IGS_FI_ANC_RATES_ROLLED'));
3180: END IF;
3181: ELSE
3182: -- Insert into the table when records exist in the source cursor of rate segments
3183: FOR v_cur_source_sgmnts_rec IN c_cur_source_sgmnts LOOP

Line 3225: IGS_FI_ANC_RATES_PKG.INSERT_ROW(

3221: v_rates_flag := TRUE;
3222: l_rowid2 := NULL; -- initialise l_rowid2 to null before passing into the TBH
3223: -- l_rowid2 with a value will throw Un-Handled Exception
3224: BEGIN
3225: IGS_FI_ANC_RATES_PKG.INSERT_ROW(
3226: X_ROWID=>l_rowid2,
3227: X_ANCILLARY_RATE_ID=>l_ancillary_rate_id,
3228: X_FEE_TYPE=>p_fee_type,
3229: X_FEE_CAL_TYPE=>p_dest_cal_type,