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_UC_PROC_APPLICATION_DATA dependencies on IGS_PE_ALT_PERS_ID

Line 250: CURSOR get_person_cur (p_ucas_appno igs_pe_alt_pers_id.api_person_id%TYPE,

246: WHERE oss_person_id IS NULL;
247:
248:
249: -- get all the records with NULL Person ID
250: CURSOR get_person_cur (p_ucas_appno igs_pe_alt_pers_id.api_person_id%TYPE,
251: p_ucas_system igs_pe_alt_pers_id.person_id_type%TYPE) IS
252: SELECT pe_person_id
253: FROM igs_pe_alt_pers_id
254: WHERE api_person_id = p_ucas_appno

Line 251: p_ucas_system igs_pe_alt_pers_id.person_id_type%TYPE) IS

247:
248:
249: -- get all the records with NULL Person ID
250: CURSOR get_person_cur (p_ucas_appno igs_pe_alt_pers_id.api_person_id%TYPE,
251: p_ucas_system igs_pe_alt_pers_id.person_id_type%TYPE) IS
252: SELECT pe_person_id
253: FROM igs_pe_alt_pers_id
254: WHERE api_person_id = p_ucas_appno
255: AND person_id_type = p_ucas_system;

Line 253: FROM igs_pe_alt_pers_id

249: -- get all the records with NULL Person ID
250: CURSOR get_person_cur (p_ucas_appno igs_pe_alt_pers_id.api_person_id%TYPE,
251: p_ucas_system igs_pe_alt_pers_id.person_id_type%TYPE) IS
252: SELECT pe_person_id
253: FROM igs_pe_alt_pers_id
254: WHERE api_person_id = p_ucas_appno
255: AND person_id_type = p_ucas_system;
256:
257:

Line 259: l_system_type igs_pe_alt_pers_id.person_id_type%TYPE;

255: AND person_id_type = p_ucas_system;
256:
257:
258: l_oss_person_id igs_uc_applicants.oss_person_id%TYPE;
259: l_system_type igs_pe_alt_pers_id.person_id_type%TYPE;
260:
261: BEGIN
262:
263: -- log Processing message