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.

[Home] [Help]

APPS.IGS_GR_GEN_001 dependencies on IGS_GR_GRADUAND_ALL

Line 227: v_person_id igs_gr_graduand_all.person_id%TYPE;

223: DECLARE
224: --
225: e_resource_busy EXCEPTION;
226: PRAGMA EXCEPTION_INIT (e_resource_busy, -54);
227: v_person_id igs_gr_graduand_all.person_id%TYPE;
228: v_create_dt igs_gr_graduand_all.create_dt%TYPE;
229: v_gac_locked VARCHAR2 (1);
230: --
231: CURSOR c_gr IS

Line 228: v_create_dt igs_gr_graduand_all.create_dt%TYPE;

224: --
225: e_resource_busy EXCEPTION;
226: PRAGMA EXCEPTION_INIT (e_resource_busy, -54);
227: v_person_id igs_gr_graduand_all.person_id%TYPE;
228: v_create_dt igs_gr_graduand_all.create_dt%TYPE;
229: v_gac_locked VARCHAR2 (1);
230: --
231: CURSOR c_gr IS
232: SELECT gr.person_id,

Line 234: FROM igs_gr_graduand_all gr,

230: --
231: CURSOR c_gr IS
232: SELECT gr.person_id,
233: gr.create_dt
234: FROM igs_gr_graduand_all gr,
235: igs_gr_stat gst
236: WHERE gr.grd_cal_type = p_grd_cal_type
237: AND gr.grd_ci_sequence_number = p_grd_ci_sequence_number
238: AND gr.graduand_status = gst.graduand_status

Line 244: cp_gr_person_id igs_gr_graduand_all.person_id%TYPE,

240: AND gr.grd_cal_type = p_grd_cal_type
241: AND gr.grd_ci_sequence_number = p_grd_ci_sequence_number;
242: --
243: CURSOR c_gr_del (
244: cp_gr_person_id igs_gr_graduand_all.person_id%TYPE,
245: cp_gr_create_dt igs_gr_graduand_all.create_dt%TYPE
246: ) IS
247: SELECT ROWID
248: FROM igs_gr_graduand_all gr

Line 245: cp_gr_create_dt igs_gr_graduand_all.create_dt%TYPE

241: AND gr.grd_ci_sequence_number = p_grd_ci_sequence_number;
242: --
243: CURSOR c_gr_del (
244: cp_gr_person_id igs_gr_graduand_all.person_id%TYPE,
245: cp_gr_create_dt igs_gr_graduand_all.create_dt%TYPE
246: ) IS
247: SELECT ROWID
248: FROM igs_gr_graduand_all gr
249: WHERE gr.person_id = cp_gr_person_id

Line 248: FROM igs_gr_graduand_all gr

244: cp_gr_person_id igs_gr_graduand_all.person_id%TYPE,
245: cp_gr_create_dt igs_gr_graduand_all.create_dt%TYPE
246: ) IS
247: SELECT ROWID
248: FROM igs_gr_graduand_all gr
249: WHERE gr.person_id = cp_gr_person_id
250: AND gr.create_dt = cp_gr_create_dt
251: AND NOT EXISTS (SELECT 'X'
252: FROM igs_gr_awd_crmn gac

Line 258: cp_gr_person_id igs_gr_graduand_all.person_id%TYPE,

254: AND gac.create_dt = cp_gr_create_dt)
255: FOR UPDATE OF gr.person_id NOWAIT;
256: --
257: CURSOR c_grh_del (
258: cp_gr_person_id igs_gr_graduand_all.person_id%TYPE,
259: cp_gr_create_dt igs_gr_graduand_all.create_dt%TYPE
260: ) IS
261: SELECT ROWID
262: FROM igs_gr_graduand_hist grh

Line 259: cp_gr_create_dt igs_gr_graduand_all.create_dt%TYPE

255: FOR UPDATE OF gr.person_id NOWAIT;
256: --
257: CURSOR c_grh_del (
258: cp_gr_person_id igs_gr_graduand_all.person_id%TYPE,
259: cp_gr_create_dt igs_gr_graduand_all.create_dt%TYPE
260: ) IS
261: SELECT ROWID
262: FROM igs_gr_graduand_hist grh
263: WHERE grh.person_id = cp_gr_person_id

Line 268: cp_gr_person_id igs_gr_graduand_all.person_id%TYPE,

264: AND grh.create_dt = cp_gr_create_dt
265: FOR UPDATE OF grh.person_id NOWAIT;
266: --
267: CURSOR c_gac (
268: cp_gr_person_id igs_gr_graduand_all.person_id%TYPE,
269: cp_gr_create_dt igs_gr_graduand_all.create_dt%TYPE
270: ) IS
271: SELECT ROWID
272: FROM igs_gr_awd_crmn gac

Line 269: cp_gr_create_dt igs_gr_graduand_all.create_dt%TYPE

265: FOR UPDATE OF grh.person_id NOWAIT;
266: --
267: CURSOR c_gac (
268: cp_gr_person_id igs_gr_graduand_all.person_id%TYPE,
269: cp_gr_create_dt igs_gr_graduand_all.create_dt%TYPE
270: ) IS
271: SELECT ROWID
272: FROM igs_gr_awd_crmn gac
273: WHERE gac.person_id = cp_gr_person_id

Line 278: cp_gr_person_id igs_gr_graduand_all.person_id%TYPE,

274: AND gac.create_dt = cp_gr_create_dt
275: FOR UPDATE OF gac.person_id NOWAIT;
276: --
277: CURSOR c_gach (
278: cp_gr_person_id igs_gr_graduand_all.person_id%TYPE,
279: cp_gr_create_dt igs_gr_graduand_all.create_dt%TYPE
280: ) IS
281: SELECT ROWID
282: FROM igs_gr_awd_crmn_hist gach

Line 279: cp_gr_create_dt igs_gr_graduand_all.create_dt%TYPE

275: FOR UPDATE OF gac.person_id NOWAIT;
276: --
277: CURSOR c_gach (
278: cp_gr_person_id igs_gr_graduand_all.person_id%TYPE,
279: cp_gr_create_dt igs_gr_graduand_all.create_dt%TYPE
280: ) IS
281: SELECT ROWID
282: FROM igs_gr_awd_crmn_hist gach
283: WHERE gach.person_id = cp_gr_person_id

Line 503: v_graduation_name igs_gr_graduand_all.graduation_name%TYPE DEFAULT '';

499: cst_surname CONSTANT VARCHAR2 (7) := 'SURNAME';
500: v_surname igs_pe_person_base_v.last_name%TYPE DEFAULT NULL;
501: v_given_names igs_pe_person_base_v.first_name%TYPE DEFAULT NULL;
502: v_title igs_pe_person_base_v.title%TYPE DEFAULT NULL;
503: v_graduation_name igs_gr_graduand_all.graduation_name%TYPE DEFAULT '';
504: --
505: CURSOR c_pe IS
506: SELECT pe.last_name,
507: pe.first_name,

Line 627: FROM igs_gr_graduand_all gr,

623: v_govt_honours_level igs_gr_honours_level.govt_honours_level%TYPE;
624: --
625: CURSOR c_gr_gst_aw_hl IS
626: SELECT hl.govt_honours_level
627: FROM igs_gr_graduand_all gr,
628: igs_gr_stat gst,
629: igs_ps_awd aw,
630: igs_gr_honours_level hl
631: WHERE gr.person_id = p_person_id