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_GEN_002 dependencies on IGS_FI_ELM_RANGE

Line 244: p_fee_type IN IGS_FI_ELM_RANGE.FEE_TYPE%TYPE ,

240: -- this procedure invoked the TBH for the history table which was also being obsolete
241: -- bug# 2187247 (rnirwani)
242: --
243: PROCEDURE finp_ins_er_hist(
244: p_fee_type IN IGS_FI_ELM_RANGE.FEE_TYPE%TYPE ,
245: p_fee_cal_type IN IGS_FI_ELM_RANGE.fee_cal_type%TYPE ,
246: p_fee_ci_sequence_number IN IGS_FI_ELM_RANGE.fee_ci_sequence_number%TYPE ,
247: p_s_relation_type IN IGS_FI_ELM_RANGE.s_relation_type%TYPE ,
248: p_range_number IN IGS_FI_ELM_RANGE.range_number%TYPE ,

Line 245: p_fee_cal_type IN IGS_FI_ELM_RANGE.fee_cal_type%TYPE ,

241: -- bug# 2187247 (rnirwani)
242: --
243: PROCEDURE finp_ins_er_hist(
244: p_fee_type IN IGS_FI_ELM_RANGE.FEE_TYPE%TYPE ,
245: p_fee_cal_type IN IGS_FI_ELM_RANGE.fee_cal_type%TYPE ,
246: p_fee_ci_sequence_number IN IGS_FI_ELM_RANGE.fee_ci_sequence_number%TYPE ,
247: p_s_relation_type IN IGS_FI_ELM_RANGE.s_relation_type%TYPE ,
248: p_range_number IN IGS_FI_ELM_RANGE.range_number%TYPE ,
249: p_new_fee_cat IN IGS_FI_ELM_RANGE.FEE_CAT%TYPE ,

Line 246: p_fee_ci_sequence_number IN IGS_FI_ELM_RANGE.fee_ci_sequence_number%TYPE ,

242: --
243: PROCEDURE finp_ins_er_hist(
244: p_fee_type IN IGS_FI_ELM_RANGE.FEE_TYPE%TYPE ,
245: p_fee_cal_type IN IGS_FI_ELM_RANGE.fee_cal_type%TYPE ,
246: p_fee_ci_sequence_number IN IGS_FI_ELM_RANGE.fee_ci_sequence_number%TYPE ,
247: p_s_relation_type IN IGS_FI_ELM_RANGE.s_relation_type%TYPE ,
248: p_range_number IN IGS_FI_ELM_RANGE.range_number%TYPE ,
249: p_new_fee_cat IN IGS_FI_ELM_RANGE.FEE_CAT%TYPE ,
250: p_old_fee_cat IN IGS_FI_ELM_RANGE.FEE_CAT%TYPE ,

Line 247: p_s_relation_type IN IGS_FI_ELM_RANGE.s_relation_type%TYPE ,

243: PROCEDURE finp_ins_er_hist(
244: p_fee_type IN IGS_FI_ELM_RANGE.FEE_TYPE%TYPE ,
245: p_fee_cal_type IN IGS_FI_ELM_RANGE.fee_cal_type%TYPE ,
246: p_fee_ci_sequence_number IN IGS_FI_ELM_RANGE.fee_ci_sequence_number%TYPE ,
247: p_s_relation_type IN IGS_FI_ELM_RANGE.s_relation_type%TYPE ,
248: p_range_number IN IGS_FI_ELM_RANGE.range_number%TYPE ,
249: p_new_fee_cat IN IGS_FI_ELM_RANGE.FEE_CAT%TYPE ,
250: p_old_fee_cat IN IGS_FI_ELM_RANGE.FEE_CAT%TYPE ,
251: p_new_lower_range IN IGS_FI_ELM_RANGE.lower_range%TYPE ,

Line 248: p_range_number IN IGS_FI_ELM_RANGE.range_number%TYPE ,

244: p_fee_type IN IGS_FI_ELM_RANGE.FEE_TYPE%TYPE ,
245: p_fee_cal_type IN IGS_FI_ELM_RANGE.fee_cal_type%TYPE ,
246: p_fee_ci_sequence_number IN IGS_FI_ELM_RANGE.fee_ci_sequence_number%TYPE ,
247: p_s_relation_type IN IGS_FI_ELM_RANGE.s_relation_type%TYPE ,
248: p_range_number IN IGS_FI_ELM_RANGE.range_number%TYPE ,
249: p_new_fee_cat IN IGS_FI_ELM_RANGE.FEE_CAT%TYPE ,
250: p_old_fee_cat IN IGS_FI_ELM_RANGE.FEE_CAT%TYPE ,
251: p_new_lower_range IN IGS_FI_ELM_RANGE.lower_range%TYPE ,
252: p_old_lower_range IN IGS_FI_ELM_RANGE.lower_range%TYPE ,

Line 249: p_new_fee_cat IN IGS_FI_ELM_RANGE.FEE_CAT%TYPE ,

245: p_fee_cal_type IN IGS_FI_ELM_RANGE.fee_cal_type%TYPE ,
246: p_fee_ci_sequence_number IN IGS_FI_ELM_RANGE.fee_ci_sequence_number%TYPE ,
247: p_s_relation_type IN IGS_FI_ELM_RANGE.s_relation_type%TYPE ,
248: p_range_number IN IGS_FI_ELM_RANGE.range_number%TYPE ,
249: p_new_fee_cat IN IGS_FI_ELM_RANGE.FEE_CAT%TYPE ,
250: p_old_fee_cat IN IGS_FI_ELM_RANGE.FEE_CAT%TYPE ,
251: p_new_lower_range IN IGS_FI_ELM_RANGE.lower_range%TYPE ,
252: p_old_lower_range IN IGS_FI_ELM_RANGE.lower_range%TYPE ,
253: p_new_upper_range IN IGS_FI_ELM_RANGE.upper_range%TYPE ,

Line 250: p_old_fee_cat IN IGS_FI_ELM_RANGE.FEE_CAT%TYPE ,

246: p_fee_ci_sequence_number IN IGS_FI_ELM_RANGE.fee_ci_sequence_number%TYPE ,
247: p_s_relation_type IN IGS_FI_ELM_RANGE.s_relation_type%TYPE ,
248: p_range_number IN IGS_FI_ELM_RANGE.range_number%TYPE ,
249: p_new_fee_cat IN IGS_FI_ELM_RANGE.FEE_CAT%TYPE ,
250: p_old_fee_cat IN IGS_FI_ELM_RANGE.FEE_CAT%TYPE ,
251: p_new_lower_range IN IGS_FI_ELM_RANGE.lower_range%TYPE ,
252: p_old_lower_range IN IGS_FI_ELM_RANGE.lower_range%TYPE ,
253: p_new_upper_range IN IGS_FI_ELM_RANGE.upper_range%TYPE ,
254: p_old_upper_range IN IGS_FI_ELM_RANGE.upper_range%TYPE ,

Line 251: p_new_lower_range IN IGS_FI_ELM_RANGE.lower_range%TYPE ,

247: p_s_relation_type IN IGS_FI_ELM_RANGE.s_relation_type%TYPE ,
248: p_range_number IN IGS_FI_ELM_RANGE.range_number%TYPE ,
249: p_new_fee_cat IN IGS_FI_ELM_RANGE.FEE_CAT%TYPE ,
250: p_old_fee_cat IN IGS_FI_ELM_RANGE.FEE_CAT%TYPE ,
251: p_new_lower_range IN IGS_FI_ELM_RANGE.lower_range%TYPE ,
252: p_old_lower_range IN IGS_FI_ELM_RANGE.lower_range%TYPE ,
253: p_new_upper_range IN IGS_FI_ELM_RANGE.upper_range%TYPE ,
254: p_old_upper_range IN IGS_FI_ELM_RANGE.upper_range%TYPE ,
255: p_new_s_chg_method_type IN IGS_FI_ELM_RANGE.s_chg_method_type%TYPE ,

Line 252: p_old_lower_range IN IGS_FI_ELM_RANGE.lower_range%TYPE ,

248: p_range_number IN IGS_FI_ELM_RANGE.range_number%TYPE ,
249: p_new_fee_cat IN IGS_FI_ELM_RANGE.FEE_CAT%TYPE ,
250: p_old_fee_cat IN IGS_FI_ELM_RANGE.FEE_CAT%TYPE ,
251: p_new_lower_range IN IGS_FI_ELM_RANGE.lower_range%TYPE ,
252: p_old_lower_range IN IGS_FI_ELM_RANGE.lower_range%TYPE ,
253: p_new_upper_range IN IGS_FI_ELM_RANGE.upper_range%TYPE ,
254: p_old_upper_range IN IGS_FI_ELM_RANGE.upper_range%TYPE ,
255: p_new_s_chg_method_type IN IGS_FI_ELM_RANGE.s_chg_method_type%TYPE ,
256: p_old_s_chg_method_type IN IGS_FI_ELM_RANGE.s_chg_method_type%TYPE ,

Line 253: p_new_upper_range IN IGS_FI_ELM_RANGE.upper_range%TYPE ,

249: p_new_fee_cat IN IGS_FI_ELM_RANGE.FEE_CAT%TYPE ,
250: p_old_fee_cat IN IGS_FI_ELM_RANGE.FEE_CAT%TYPE ,
251: p_new_lower_range IN IGS_FI_ELM_RANGE.lower_range%TYPE ,
252: p_old_lower_range IN IGS_FI_ELM_RANGE.lower_range%TYPE ,
253: p_new_upper_range IN IGS_FI_ELM_RANGE.upper_range%TYPE ,
254: p_old_upper_range IN IGS_FI_ELM_RANGE.upper_range%TYPE ,
255: p_new_s_chg_method_type IN IGS_FI_ELM_RANGE.s_chg_method_type%TYPE ,
256: p_old_s_chg_method_type IN IGS_FI_ELM_RANGE.s_chg_method_type%TYPE ,
257: p_new_last_updated_by IN IGS_FI_ELM_RANGE.last_updated_by%TYPE ,

Line 254: p_old_upper_range IN IGS_FI_ELM_RANGE.upper_range%TYPE ,

250: p_old_fee_cat IN IGS_FI_ELM_RANGE.FEE_CAT%TYPE ,
251: p_new_lower_range IN IGS_FI_ELM_RANGE.lower_range%TYPE ,
252: p_old_lower_range IN IGS_FI_ELM_RANGE.lower_range%TYPE ,
253: p_new_upper_range IN IGS_FI_ELM_RANGE.upper_range%TYPE ,
254: p_old_upper_range IN IGS_FI_ELM_RANGE.upper_range%TYPE ,
255: p_new_s_chg_method_type IN IGS_FI_ELM_RANGE.s_chg_method_type%TYPE ,
256: p_old_s_chg_method_type IN IGS_FI_ELM_RANGE.s_chg_method_type%TYPE ,
257: p_new_last_updated_by IN IGS_FI_ELM_RANGE.last_updated_by%TYPE ,
258: p_old_last_updated_by IN IGS_FI_ELM_RANGE.last_updated_by%TYPE ,

Line 255: p_new_s_chg_method_type IN IGS_FI_ELM_RANGE.s_chg_method_type%TYPE ,

251: p_new_lower_range IN IGS_FI_ELM_RANGE.lower_range%TYPE ,
252: p_old_lower_range IN IGS_FI_ELM_RANGE.lower_range%TYPE ,
253: p_new_upper_range IN IGS_FI_ELM_RANGE.upper_range%TYPE ,
254: p_old_upper_range IN IGS_FI_ELM_RANGE.upper_range%TYPE ,
255: p_new_s_chg_method_type IN IGS_FI_ELM_RANGE.s_chg_method_type%TYPE ,
256: p_old_s_chg_method_type IN IGS_FI_ELM_RANGE.s_chg_method_type%TYPE ,
257: p_new_last_updated_by IN IGS_FI_ELM_RANGE.last_updated_by%TYPE ,
258: p_old_last_updated_by IN IGS_FI_ELM_RANGE.last_updated_by%TYPE ,
259: p_new_last_update_date IN IGS_FI_ELM_RANGE.last_update_date%TYPE ,

Line 256: p_old_s_chg_method_type IN IGS_FI_ELM_RANGE.s_chg_method_type%TYPE ,

252: p_old_lower_range IN IGS_FI_ELM_RANGE.lower_range%TYPE ,
253: p_new_upper_range IN IGS_FI_ELM_RANGE.upper_range%TYPE ,
254: p_old_upper_range IN IGS_FI_ELM_RANGE.upper_range%TYPE ,
255: p_new_s_chg_method_type IN IGS_FI_ELM_RANGE.s_chg_method_type%TYPE ,
256: p_old_s_chg_method_type IN IGS_FI_ELM_RANGE.s_chg_method_type%TYPE ,
257: p_new_last_updated_by IN IGS_FI_ELM_RANGE.last_updated_by%TYPE ,
258: p_old_last_updated_by IN IGS_FI_ELM_RANGE.last_updated_by%TYPE ,
259: p_new_last_update_date IN IGS_FI_ELM_RANGE.last_update_date%TYPE ,
260: p_old_last_update_date IN IGS_FI_ELM_RANGE.last_update_date%TYPE )

Line 257: p_new_last_updated_by IN IGS_FI_ELM_RANGE.last_updated_by%TYPE ,

253: p_new_upper_range IN IGS_FI_ELM_RANGE.upper_range%TYPE ,
254: p_old_upper_range IN IGS_FI_ELM_RANGE.upper_range%TYPE ,
255: p_new_s_chg_method_type IN IGS_FI_ELM_RANGE.s_chg_method_type%TYPE ,
256: p_old_s_chg_method_type IN IGS_FI_ELM_RANGE.s_chg_method_type%TYPE ,
257: p_new_last_updated_by IN IGS_FI_ELM_RANGE.last_updated_by%TYPE ,
258: p_old_last_updated_by IN IGS_FI_ELM_RANGE.last_updated_by%TYPE ,
259: p_new_last_update_date IN IGS_FI_ELM_RANGE.last_update_date%TYPE ,
260: p_old_last_update_date IN IGS_FI_ELM_RANGE.last_update_date%TYPE )
261: AS

Line 258: p_old_last_updated_by IN IGS_FI_ELM_RANGE.last_updated_by%TYPE ,

254: p_old_upper_range IN IGS_FI_ELM_RANGE.upper_range%TYPE ,
255: p_new_s_chg_method_type IN IGS_FI_ELM_RANGE.s_chg_method_type%TYPE ,
256: p_old_s_chg_method_type IN IGS_FI_ELM_RANGE.s_chg_method_type%TYPE ,
257: p_new_last_updated_by IN IGS_FI_ELM_RANGE.last_updated_by%TYPE ,
258: p_old_last_updated_by IN IGS_FI_ELM_RANGE.last_updated_by%TYPE ,
259: p_new_last_update_date IN IGS_FI_ELM_RANGE.last_update_date%TYPE ,
260: p_old_last_update_date IN IGS_FI_ELM_RANGE.last_update_date%TYPE )
261: AS
262: gv_other_detail VARCHAR2(255);

Line 259: p_new_last_update_date IN IGS_FI_ELM_RANGE.last_update_date%TYPE ,

255: p_new_s_chg_method_type IN IGS_FI_ELM_RANGE.s_chg_method_type%TYPE ,
256: p_old_s_chg_method_type IN IGS_FI_ELM_RANGE.s_chg_method_type%TYPE ,
257: p_new_last_updated_by IN IGS_FI_ELM_RANGE.last_updated_by%TYPE ,
258: p_old_last_updated_by IN IGS_FI_ELM_RANGE.last_updated_by%TYPE ,
259: p_new_last_update_date IN IGS_FI_ELM_RANGE.last_update_date%TYPE ,
260: p_old_last_update_date IN IGS_FI_ELM_RANGE.last_update_date%TYPE )
261: AS
262: gv_other_detail VARCHAR2(255);
263: BEGIN

Line 260: p_old_last_update_date IN IGS_FI_ELM_RANGE.last_update_date%TYPE )

256: p_old_s_chg_method_type IN IGS_FI_ELM_RANGE.s_chg_method_type%TYPE ,
257: p_new_last_updated_by IN IGS_FI_ELM_RANGE.last_updated_by%TYPE ,
258: p_old_last_updated_by IN IGS_FI_ELM_RANGE.last_updated_by%TYPE ,
259: p_new_last_update_date IN IGS_FI_ELM_RANGE.last_update_date%TYPE ,
260: p_old_last_update_date IN IGS_FI_ELM_RANGE.last_update_date%TYPE )
261: AS
262: gv_other_detail VARCHAR2(255);
263: BEGIN
264: DECLARE

Line 266: r_erh IGS_FI_ELM_RANGE_H%ROWTYPE;

262: gv_other_detail VARCHAR2(255);
263: BEGIN
264: DECLARE
265: X_ROWID VARCHAR2(25);
266: r_erh IGS_FI_ELM_RANGE_H%ROWTYPE;
267: v_create_history BOOLEAN := FALSE;
268: l_n_org_id IGS_FI_ELM_RANGE_H.org_id%TYPE := igs_ge_gen_003.get_org_id;
269: BEGIN
270: -- Create a history for a IGS_FI_ELM_RANGE record.

Line 268: l_n_org_id IGS_FI_ELM_RANGE_H.org_id%TYPE := igs_ge_gen_003.get_org_id;

264: DECLARE
265: X_ROWID VARCHAR2(25);
266: r_erh IGS_FI_ELM_RANGE_H%ROWTYPE;
267: v_create_history BOOLEAN := FALSE;
268: l_n_org_id IGS_FI_ELM_RANGE_H.org_id%TYPE := igs_ge_gen_003.get_org_id;
269: BEGIN
270: -- Create a history for a IGS_FI_ELM_RANGE record.
271: -- Check if any of the non-primary key fields have been changed
272: -- and set the flag v_create_history to indicate so.

Line 270: -- Create a history for a IGS_FI_ELM_RANGE record.

266: r_erh IGS_FI_ELM_RANGE_H%ROWTYPE;
267: v_create_history BOOLEAN := FALSE;
268: l_n_org_id IGS_FI_ELM_RANGE_H.org_id%TYPE := igs_ge_gen_003.get_org_id;
269: BEGIN
270: -- Create a history for a IGS_FI_ELM_RANGE record.
271: -- Check if any of the non-primary key fields have been changed
272: -- and set the flag v_create_history to indicate so.
273: IF NVL(p_new_fee_cat, 'NULL') <> NVL(p_old_fee_cat, 'NULL') THEN
274: r_erh.FEE_CAT := p_old_fee_cat;

Line 300: IGS_FI_ELM_RANGE_H_PKG.INSERT_ROW(

296: r_erh.range_number := p_range_number;
297: r_erh.hist_start_dt := p_old_last_update_date;
298: r_erh.hist_end_dt := p_new_last_update_date;
299: r_erh.hist_who := p_old_last_updated_by;
300: IGS_FI_ELM_RANGE_H_PKG.INSERT_ROW(
301: X_ROWID => X_ROWID,
302: X_FEE_TYPE => r_erh.FEE_TYPE,
303: X_fee_cal_type => r_erh.fee_cal_type,
304: X_fee_ci_sequence_number => r_erh.fee_ci_sequence_number,