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_FUTURE_DT_TRANS dependencies on IGS_GR_AWD_CRMN_HIST

Line 150: cp_create_dt IGS_GR_AWD_CRMN_HIST.create_dt%TYPE) IS

146: FOR UPDATE OF gua.LAST_UPDATE_DATE NOWAIT ;
147:
148:
149: CURSOR c_gach (
150: cp_create_dt IGS_GR_AWD_CRMN_HIST.create_dt%TYPE) IS
151: SELECT gach.gach_id
152: FROM IGS_GR_AWD_CRMN_HIST gach
153: WHERE gach.person_id = p_person_id
154: AND gach.create_dt = cp_create_dt;

Line 152: FROM IGS_GR_AWD_CRMN_HIST gach

148:
149: CURSOR c_gach (
150: cp_create_dt IGS_GR_AWD_CRMN_HIST.create_dt%TYPE) IS
151: SELECT gach.gach_id
152: FROM IGS_GR_AWD_CRMN_HIST gach
153: WHERE gach.person_id = p_person_id
154: AND gach.create_dt = cp_create_dt;
155:
156: CURSOR c_gach_del (

Line 157: cp_gach_id IGS_GR_AWD_CRMN_HIST.gach_id%TYPE) IS

153: WHERE gach.person_id = p_person_id
154: AND gach.create_dt = cp_create_dt;
155:
156: CURSOR c_gach_del (
157: cp_gach_id IGS_GR_AWD_CRMN_HIST.gach_id%TYPE) IS
158: SELECT rowid
159: FROM IGS_GR_AWD_CRMN_HIST gach
160: WHERE gach.gach_id = cp_gach_id
161: FOR UPDATE OF gach.LAST_UPDATE_DATE NOWAIT ;

Line 159: FROM IGS_GR_AWD_CRMN_HIST gach

155:
156: CURSOR c_gach_del (
157: cp_gach_id IGS_GR_AWD_CRMN_HIST.gach_id%TYPE) IS
158: SELECT rowid
159: FROM IGS_GR_AWD_CRMN_HIST gach
160: WHERE gach.gach_id = cp_gach_id
161: FOR UPDATE OF gach.LAST_UPDATE_DATE NOWAIT ;
162:
163: CURSOR c_gac (

Line 185: -- Delete unconfirmed IGS_GR_AWD_CRMN_HIST records

181:
182: FOR v_gua_rec IN c_gua LOOP
183: FOR v_gach_rec IN c_gach (v_gua_rec.create_dt) LOOP
184: BEGIN
185: -- Delete unconfirmed IGS_GR_AWD_CRMN_HIST records
186: FOR c_gach_del_rec in c_gach_del(v_gach_rec.gach_id)
187: LOOP
188:
189: IGS_GR_AWD_CRMN_HIST_PKG.DELETE_ROW( X_ROWID => c_gach_del_rec.ROWID );

Line 189: IGS_GR_AWD_CRMN_HIST_PKG.DELETE_ROW( X_ROWID => c_gach_del_rec.ROWID );

185: -- Delete unconfirmed IGS_GR_AWD_CRMN_HIST records
186: FOR c_gach_del_rec in c_gach_del(v_gach_rec.gach_id)
187: LOOP
188:
189: IGS_GR_AWD_CRMN_HIST_PKG.DELETE_ROW( X_ROWID => c_gach_del_rec.ROWID );
190:
191: END LOOP;
192:
193: EXCEPTION

Line 198: l_entity_name := 'IGS_GR_AWD_CRMN_HIST';

194: WHEN e_resource_busy THEN
195: IF c_gach_del%ISOPEN THEN
196: CLOSE c_gach_del;
197: END IF;
198: l_entity_name := 'IGS_GR_AWD_CRMN_HIST';
199: EXIT;
200: END;
201: END LOOP;
202: IF l_entity_name IS NOT NULL THEN