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_SUB_ELM_RNG

Line 2295: v_ser_logical_delete_dt IGS_FI_SUB_ELM_RNG.logical_delete_date%TYPE;

2291: l_rowid VARCHAR2(25);
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;

Line 2361: CURSOR c_ser_source (cp_er_id IGS_FI_SUB_ELM_RNG.er_id%TYPE) IS

2357: err.s_relation_type = p_relation_type AND
2358: err.range_number = cp_range_number AND
2359: err.rate_number = cp_rate_number;
2360: --Added as a part of CPF build . Bug #3392088
2361: CURSOR c_ser_source (cp_er_id IGS_FI_SUB_ELM_RNG.er_id%TYPE) IS
2362: SELECT er_id,
2363: sub_er_id,
2364: sub_range_num,
2365: sub_chg_method_code,

Line 2368: FROM IGS_FI_SUB_ELM_RNG ser

2364: sub_range_num,
2365: sub_chg_method_code,
2366: sub_lower_range,
2367: sub_upper_range
2368: FROM IGS_FI_SUB_ELM_RNG ser
2369: WHERE ser.er_id = cp_er_id AND
2370: ser.logical_delete_date IS NULL;
2371:
2372: CURSOR c_ser_dest (

Line 2373: cp_er_id IGS_FI_SUB_ELM_RNG.er_id%TYPE,

2369: WHERE ser.er_id = cp_er_id AND
2370: ser.logical_delete_date IS NULL;
2371:
2372: CURSOR c_ser_dest (
2373: cp_er_id IGS_FI_SUB_ELM_RNG.er_id%TYPE,
2374: cp_sub_range_num IGS_FI_SUB_ELM_RNG.sub_range_num%TYPE) IS
2375: SELECT sub_er_id,logical_delete_date
2376: FROM IGS_FI_SUB_ELM_RNG ser
2377: WHERE ser.er_id = cp_er_id AND

Line 2374: cp_sub_range_num IGS_FI_SUB_ELM_RNG.sub_range_num%TYPE) IS

2370: ser.logical_delete_date IS NULL;
2371:
2372: CURSOR c_ser_dest (
2373: cp_er_id IGS_FI_SUB_ELM_RNG.er_id%TYPE,
2374: cp_sub_range_num IGS_FI_SUB_ELM_RNG.sub_range_num%TYPE) IS
2375: SELECT sub_er_id,logical_delete_date
2376: FROM IGS_FI_SUB_ELM_RNG ser
2377: WHERE ser.er_id = cp_er_id AND
2378: ser.sub_range_num = cp_sub_range_num;

Line 2376: FROM IGS_FI_SUB_ELM_RNG ser

2372: CURSOR c_ser_dest (
2373: cp_er_id IGS_FI_SUB_ELM_RNG.er_id%TYPE,
2374: cp_sub_range_num IGS_FI_SUB_ELM_RNG.sub_range_num%TYPE) IS
2375: SELECT sub_er_id,logical_delete_date
2376: FROM IGS_FI_SUB_ELM_RNG ser
2377: WHERE ser.er_id = cp_er_id AND
2378: ser.sub_range_num = cp_sub_range_num;
2379:
2380:

Line 2561: --insert a row into IGS_FI_SUB_ELM_RNG;

2557:
2558: BEGIN
2559: l_rowid :=NULL; -- initialise l_rowid to null before passing into the TBH
2560: -- l_rowid with a value will throw Un-Handled Exception
2561: --insert a row into IGS_FI_SUB_ELM_RNG;
2562: IGS_FI_SUB_ELM_RNG_PKG.INSERT_ROW(
2563: x_rowid=> l_rowid,
2564: x_sub_er_id => l_sub_er_id,
2565: x_er_id => v_er_id,

Line 2562: IGS_FI_SUB_ELM_RNG_PKG.INSERT_ROW(

2558: BEGIN
2559: l_rowid :=NULL; -- initialise l_rowid to null before passing into the TBH
2560: -- l_rowid with a value will throw Un-Handled Exception
2561: --insert a row into IGS_FI_SUB_ELM_RNG;
2562: IGS_FI_SUB_ELM_RNG_PKG.INSERT_ROW(
2563: x_rowid=> l_rowid,
2564: x_sub_er_id => l_sub_er_id,
2565: x_er_id => v_er_id,
2566: x_sub_range_num => v_ser_source_rec.sub_range_num,