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_EN_TIMESLOT_PREF_PKG dependencies on IGS_PE_PERSID_GROUP_ALL

Line 272: CURSOR grp_id_cur is select group_id from igs_pe_persid_group_all

268: END get_fk_igs_en_timeslot_prty;
269:
270: PROCEDURE BeforeInsertUpdate(p_inserting BOOLEAN , p_updating BOOLEAN) AS
271: p_message_name VARCHAR2(30);
272: CURSOR grp_id_cur is select group_id from igs_pe_persid_group_all
273: WHERE group_cd = new_references.preference_code;
274: l_group_id igs_pe_persid_group_all.group_id%TYPE;
275: BEGIN
276: IF ( p_inserting = TRUE OR (p_updating = TRUE AND new_references.preference_code <> old_references.preference_code ) ) THEN

Line 274: l_group_id igs_pe_persid_group_all.group_id%TYPE;

270: PROCEDURE BeforeInsertUpdate(p_inserting BOOLEAN , p_updating BOOLEAN) AS
271: p_message_name VARCHAR2(30);
272: CURSOR grp_id_cur is select group_id from igs_pe_persid_group_all
273: WHERE group_cd = new_references.preference_code;
274: l_group_id igs_pe_persid_group_all.group_id%TYPE;
275: BEGIN
276: IF ( p_inserting = TRUE OR (p_updating = TRUE AND new_references.preference_code <> old_references.preference_code ) ) THEN
277: OPEN grp_id_cur;
278: FETCH grp_id_cur INTO l_group_id;