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

Line 16: v_tac_id IGS_PE_ALT_PERS_ID.api_person_id%TYPE;

12: BEGIN -- admp_get_tac_api
13: -- This function gets the TAC alternate person ID
14: DECLARE
15: cst_tac CONSTANT IGS_PE_PERSON_ID_TYP.s_person_id_type%TYPE := 'TAC';
16: v_tac_id IGS_PE_ALT_PERS_ID.api_person_id%TYPE;
17: CURSOR c_api_pit IS
18: SELECT api.api_person_id
19: FROM IGS_PE_ALT_PERS_ID api,
20: IGS_PE_PERSON_ID_TYP pit

Line 19: FROM IGS_PE_ALT_PERS_ID api,

15: cst_tac CONSTANT IGS_PE_PERSON_ID_TYP.s_person_id_type%TYPE := 'TAC';
16: v_tac_id IGS_PE_ALT_PERS_ID.api_person_id%TYPE;
17: CURSOR c_api_pit IS
18: SELECT api.api_person_id
19: FROM IGS_PE_ALT_PERS_ID api,
20: IGS_PE_PERSON_ID_TYP pit
21: WHERE api.pe_person_id = p_person_id AND
22: pit.person_id_type = api.person_id_type AND
23: pit.s_person_id_type = cst_tac;

Line 228: v_matched_id IGS_PE_ALT_PERS_ID.pe_person_id%TYPE;

224: cst_dfr_reject CONSTANT VARCHAR2(10) := 'DFR-REJECT';
225: cst_rejected CONSTANT VARCHAR2(10) := 'REJECTED';
226: cst_active CONSTANT VARCHAR2(10) := 'ACTIVE';
227: v_message_name varchar2(30);
228: v_matched_id IGS_PE_ALT_PERS_ID.pe_person_id%TYPE;
229: v_given_names IGS_PE_PERSON.given_names%TYPE;
230: v_course_cd IGS_PS_ENT_PT_REF_CD.course_cd%TYPE;
231: v_version_number IGS_PS_ENT_PT_REF_CD.version_number%TYPE;
232: v_location_cd IGS_PS_ENT_PT_REF_CD.location_cd%TYPE;

Line 244: FROM IGS_PE_ALT_PERS_ID api,

240: v_course_off_found BOOLEAN;
241: v_course_ins_found BOOLEAN;
242: CURSOR c_tac_id_api IS
243: SELECT api.pe_person_id
244: FROM IGS_PE_ALT_PERS_ID api,
245: IGS_PE_PERSON_ID_TYP pit
246: WHERE pit.s_person_id_type = 'TAC' AND
247: api.person_id_type = pit.person_id_type AND
248: api.api_person_id = p_tac_person_id;

Line 285: cp_matched_id IGS_PE_ALT_PERS_ID.pe_person_id%TYPE,

281: uss.unit_set_status = us.unit_set_status AND
282: uss.s_unit_set_status = cst_active))
283: ORDER BY rct.s_reference_cd_type DESC;
284: CURSOR c_course_ins_1(
285: cp_matched_id IGS_PE_ALT_PERS_ID.pe_person_id%TYPE,
286: cp_course_cd IGS_PS_ENT_PT_REF_CD.course_cd%TYPE,
287: cp_version_number IGS_PS_ENT_PT_REF_CD.version_number%TYPE,
288: cp_location_cd IGS_PS_ENT_PT_REF_CD.location_cd%TYPE,
289: cp_attendance_mode IGS_PS_ENT_PT_REF_CD.attendance_mode%TYPE,

Line 311: cp_matched_id IGS_PE_ALT_PERS_ID.pe_person_id%TYPE) IS

307: aa.person_id = acaiv.person_id AND
308: aa.admission_appl_number = acaiv.admission_appl_number;
309:
310: CURSOR c_course_ins_2(
311: cp_matched_id IGS_PE_ALT_PERS_ID.pe_person_id%TYPE) IS
312: SELECT aors.s_adm_offer_resp_status,
313: aods.s_adm_offer_dfrmnt_status,
314: acaiv.course_cd,
315: ceprc.reference_cd

Line 345: cp_person_id IGS_PE_ALT_PERS_ID.pe_person_id%TYPE) IS

341: FROM IGS_EN_ATD_TYPE
342: WHERE attendance_type = v_attendance_type;
343: CURSOR c_attn_mode(
344: cp_course_cd IGS_PS_ENT_PT_REF_CD.course_cd%TYPE,
345: cp_person_id IGS_PE_ALT_PERS_ID.pe_person_id%TYPE) IS
346: SELECT am.govt_attendance_mode
347: FROM IGS_EN_STDNT_PS_ATT sca,
348: IGS_EN_ATD_MODE am
349: WHERE sca.course_cd = cp_course_cd AND