APPS.IGS_FI_GEN_003 dependencies on IGS_FI_SUB_ELM_RNG

Line 372: FROM IGS_FI_SUB_ELM_RNG fser

368: sub_lower_range,
369: sub_upper_range,
370: sub_chg_method_code,
371: LOGICAL_DELETE_DATE
372: FROM IGS_FI_SUB_ELM_RNG fser
373: WHERE fser.er_id = p_er_id AND
374: fser.logical_delete_date IS NULL
375: FOR UPDATE OF fser.logical_delete_date NOWAIT;
376: v_message_name VARCHAR2(30);

Line 389: -- Perform a logical delete of the associated IGS_FI_SUB_ELM_RNG items.

385: END IF;
386: -- 2. Issue a save point for the module so that if locks exist,
387: -- a rollback can be performed.
388: SAVEPOINT sp_fser_save_point;
389: -- Perform a logical delete of the associated IGS_FI_SUB_ELM_RNG items.
390: -- Update the appropriate records with NOWAIT option.
391: FOR v_fser_rec IN c_fser LOOP
392:
393: igs_fi_sub_elm_rng_pkg.update_row (

Line 393: igs_fi_sub_elm_rng_pkg.update_row (

389: -- Perform a logical delete of the associated IGS_FI_SUB_ELM_RNG items.
390: -- Update the appropriate records with NOWAIT option.
391: FOR v_fser_rec IN c_fser LOOP
392:
393: igs_fi_sub_elm_rng_pkg.update_row (
394: x_mode => 'R',
395: x_rowid => v_fser_rec.ROWID,
396: x_sub_er_id => v_fser_rec.SUB_ER_ID,
397: x_er_id => v_fser_rec.ER_ID,