APPS.IGS_FI_PRC_FEE_ROLLV dependencies on IGS_FI_SUB_ER_RT

Line 2296: v_sert_logical_delete_dt IGS_FI_SUB_ER_RT.logical_delete_date%TYPE;

2292: l_sub_er_id VARCHAR2(25);
2293: l_sub_err_id VARCHAR2(25);
2294:
2295: v_ser_logical_delete_dt IGS_FI_SUB_ELM_RNG.logical_delete_date%TYPE;
2296: v_sert_logical_delete_dt IGS_FI_SUB_ER_RT.logical_delete_date%TYPE;
2297:
2298: v_ser_record_exists_ind BOOLEAN;
2299: v_sert_record_exists_ind BOOLEAN;
2300: v_ser_record_inserted_ind BOOLEAN;

Line 2308: v_sert_rate_number IGS_FI_SUB_ER_RT.far_id%TYPE := NULL;

2304: l_c_v_rates_exist VARCHAR2(1);
2305:
2306: cst_incremental CONSTANT VARCHAR2(11) := 'INCREMENTAL';
2307:
2308: v_sert_rate_number IGS_FI_SUB_ER_RT.far_id%TYPE := NULL;
2309:
2310: CURSOR c_er_source IS
2311: SELECT er.range_number,
2312: er.fee_cat,

Line 2382: cp_sub_er_id IGS_FI_SUB_ER_RT.sub_er_id%TYPE) IS

2378: ser.sub_range_num = cp_sub_range_num;
2379:
2380:
2381: CURSOR c_sert_source (
2382: cp_sub_er_id IGS_FI_SUB_ER_RT.sub_er_id%TYPE) IS
2383: SELECT sub_er_id,
2384: far_id,
2385: create_date
2386: FROM IGS_FI_SUB_ER_RT sert

Line 2386: FROM IGS_FI_SUB_ER_RT sert

2382: cp_sub_er_id IGS_FI_SUB_ER_RT.sub_er_id%TYPE) IS
2383: SELECT sub_er_id,
2384: far_id,
2385: create_date
2386: FROM IGS_FI_SUB_ER_RT sert
2387: WHERE sert.sub_er_id = cp_sub_er_id AND
2388: sert.logical_delete_date IS NULL;
2389:
2390: CURSOR c_sert_dest (

Line 2391: cp_sub_er_id IGS_FI_SUB_ER_RT.sub_er_id%TYPE,

2387: WHERE sert.sub_er_id = cp_sub_er_id AND
2388: sert.logical_delete_date IS NULL;
2389:
2390: CURSOR c_sert_dest (
2391: cp_sub_er_id IGS_FI_SUB_ER_RT.sub_er_id%TYPE,
2392: cp_far_id IGS_FI_SUB_ER_RT.far_id%TYPE) IS
2393:
2394: SELECT 'X'
2395: FROM IGS_FI_SUB_ER_RT sert

Line 2392: cp_far_id IGS_FI_SUB_ER_RT.far_id%TYPE) IS

2388: sert.logical_delete_date IS NULL;
2389:
2390: CURSOR c_sert_dest (
2391: cp_sub_er_id IGS_FI_SUB_ER_RT.sub_er_id%TYPE,
2392: cp_far_id IGS_FI_SUB_ER_RT.far_id%TYPE) IS
2393:
2394: SELECT 'X'
2395: FROM IGS_FI_SUB_ER_RT sert
2396: WHERE sert.sub_er_id = cp_sub_er_id AND

Line 2395: FROM IGS_FI_SUB_ER_RT sert

2391: cp_sub_er_id IGS_FI_SUB_ER_RT.sub_er_id%TYPE,
2392: cp_far_id IGS_FI_SUB_ER_RT.far_id%TYPE) IS
2393:
2394: SELECT 'X'
2395: FROM IGS_FI_SUB_ER_RT sert
2396: WHERE sert.sub_er_id = cp_sub_er_id AND
2397: sert.far_id = cp_far_id;
2398:
2399: CURSOR c_err_exists IS

Line 2411: FROM IGS_FI_SUB_ER_RT serr,

2407: err.logical_delete_dt IS NULL;
2408:
2409: CURSOR c_serr_exists IS
2410: SELECT 'X'
2411: FROM IGS_FI_SUB_ER_RT serr,
2412: IGS_FI_FEE_AS_RATE far
2413: WHERE far.fee_type = p_fee_type AND
2414: far.fee_cal_type = p_source_cal_type AND
2415: far.fee_ci_sequence_number = p_source_sequence_number AND

Line 2431: CURSOR c_sert_far_id_to_rt_num(cp_far_id IGS_FI_SUB_ER_RT.far_id%TYPE) IS

2427: far.s_relation_type = p_relation_type AND
2428: (far.fee_cat = p_fee_cat OR p_fee_cat IS NULL) AND
2429: far.logical_delete_dt IS NULL;
2430:
2431: CURSOR c_sert_far_id_to_rt_num(cp_far_id IGS_FI_SUB_ER_RT.far_id%TYPE) IS
2432: SELECT rate_number
2433: FROM IGS_FI_FEE_AS_RATE far
2434: WHERE far.far_id = cp_far_id;
2435:

Line 2608: --insert the record into IGS_FI_SUB_ER_RT;

2604: -- l_rowid with a value will throw Un-Handled Exception
2605: l_sub_err_id :=NULL; -- initialise l_rowid to null before passing into the TBH
2606: -- l_rowid with a value will throw Un-Handled Exception
2607:
2608: --insert the record into IGS_FI_SUB_ER_RT;
2609: IGS_FI_SUB_ER_RT_PKG.INSERT_ROW(
2610: x_rowid => l_rowid,
2611: x_sub_err_id => l_sub_err_id,
2612: x_sub_er_id => l_sub_er_id,

Line 2609: IGS_FI_SUB_ER_RT_PKG.INSERT_ROW(

2605: l_sub_err_id :=NULL; -- initialise l_rowid to null before passing into the TBH
2606: -- l_rowid with a value will throw Un-Handled Exception
2607:
2608: --insert the record into IGS_FI_SUB_ER_RT;
2609: IGS_FI_SUB_ER_RT_PKG.INSERT_ROW(
2610: x_rowid => l_rowid,
2611: x_sub_err_id => l_sub_err_id,
2612: x_sub_er_id => l_sub_er_id,
2613: x_far_id => v_sert_source_rec.far_id,