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_GEN_011 dependencies on IGS_PE_PERSON

Line 316: p_person_id IGS_PE_PERSON.person_id%TYPE,

312: v_to_location_cd IGS_EN_STDNT_PS_ATT.location_cd%TYPE ;
313: v_to_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE ;
314: v_to_attendance_mode IGS_EN_STDNT_PS_ATT.attendance_mode%TYPE ;
315: PROCEDURE enrpl_upd_sca_coo(
316: p_person_id IGS_PE_PERSON.person_id%TYPE,
317: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
318: p_crv_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,
319: p_cal_type IGS_CA_INST.cal_type%TYPE,
320: p_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,

Line 1298: l_person_type IGS_PE_PERSON_TYPES.person_type_code%TYPE;

1294: l_att_type VARCHAR2(40);
1295: l_attendance_types VARCHAR2(100); -- As returned from the function igs_en_val_sca.enrp_val_coo_att
1296: l_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
1297: l_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE;
1298: l_person_type IGS_PE_PERSON_TYPES.person_type_code%TYPE;
1299: l_en_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
1300: l_en_ci_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
1301: l_enrolment_cat IGS_PS_TYPE.ENROLMENT_CAT%TYPE;
1302: l_unit_section_status IGS_PS_UNIT_OFR_OPT.unit_section_status%TYPE DEFAULT NULL;

Line 1317: l_person_number IGS_PE_PERSON.person_number%TYPE;

1313: l_discon IGS_LOOKUP_VALUES.meaning%TYPE;
1314: l_eftsu_total IGS_EN_SU_ATTEMPT.override_eftsu%type;
1315: l_total_credit_points IGS_EN_SU_ATTEMPT.override_enrolled_cp%TYPE ;
1316: l_administrative_unit_status IGS_EN_SU_ATTEMPT_ALL.administrative_unit_status%TYPE;
1317: l_person_number IGS_PE_PERSON.person_number%TYPE;
1318: l_dummy VARCHAR2(100);
1319: l_creation_dt DATE;
1320: l_encoded_msg VARCHAR2(2000);
1321: l_app_sht_name VARCHAR2(100);

Line 1335: CURSOR c_per_num (cp_person_id igs_pe_person.person_id%TYPE)

1331: l_succ_msg VARCHAR2(100);
1332: l_failed_uoo_ids VARCHAR2(2000);
1333:
1334: -- modified cursor for perf bug : 3696293 : sql id: 14791714
1335: CURSOR c_per_num (cp_person_id igs_pe_person.person_id%TYPE)
1336: IS SELECT party_number FROM hz_parties
1337: WHERE party_id = cp_person_id;
1338:
1339:

Line 2913: l_person_type IGS_PE_PERSON_TYPES.person_type_code%TYPE;

2909: l_enrolment_cat IGS_PS_TYPE.ENROLMENT_CAT%TYPE;
2910: l_commencement_type VARCHAR2(20) DEFAULT NULL;
2911: l_en_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
2912: l_en_ci_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
2913: l_person_type IGS_PE_PERSON_TYPES.person_type_code%TYPE;
2914: l_waitlist_flag VARCHAR2(1) DEFAULT 'N';
2915: l_load_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
2916: l_load_seq_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
2917: l_unit_attempt_status IGS_EN_SU_ATTEMPT.UNIT_ATTEMPT_STATUS%TYPE;

Line 5198: -- rules checking for a IGS_PE_PERSON's IGS_PS_COURSE.

5194: cst_enr_blk_uo,
5195: cst_unit_rule_check,
5196: v_rule_creation_dt);
5197: -- Call the routine to process the IGS_PS_UNIT
5198: -- rules checking for a IGS_PE_PERSON's IGS_PS_COURSE.
5199: IF NOT IGS_EN_GEN_012.enrp_upd_sca_urule(
5200: v_acad_cal_type,
5201: v_acad_ci_sequence_number,
5202: v_sua_rec.person_id,

Line 6106: v_person_id IGS_PE_PERSON.person_id%TYPE;

6102: p_enr_method_type IN VARCHAR2 )
6103: AS
6104: BEGIN
6105: DECLARE
6106: v_person_id IGS_PE_PERSON.person_id%TYPE;
6107: v_dummy IGS_PE_PERS_PREFS.LAST_UPDATED_BY%TYPE;
6108: CURSOR c_person(
6109: cp_username IGS_PE_PERSON.oracle_username%TYPE) IS
6110: SELECT person_id

Line 6109: cp_username IGS_PE_PERSON.oracle_username%TYPE) IS

6105: DECLARE
6106: v_person_id IGS_PE_PERSON.person_id%TYPE;
6107: v_dummy IGS_PE_PERS_PREFS.LAST_UPDATED_BY%TYPE;
6108: CURSOR c_person(
6109: cp_username IGS_PE_PERSON.oracle_username%TYPE) IS
6110: SELECT person_id
6111: FROM IGS_PE_PERSON
6112: WHERE oracle_username = cp_username;
6113: CURSOR c_person_prefs(

Line 6111: FROM IGS_PE_PERSON

6107: v_dummy IGS_PE_PERS_PREFS.LAST_UPDATED_BY%TYPE;
6108: CURSOR c_person(
6109: cp_username IGS_PE_PERSON.oracle_username%TYPE) IS
6110: SELECT person_id
6111: FROM IGS_PE_PERSON
6112: WHERE oracle_username = cp_username;
6113: CURSOR c_person_prefs(
6114: cp_person_id IGS_PE_PERSON.person_id%TYPE) IS
6115: SELECT LAST_UPDATED_BY

Line 6114: cp_person_id IGS_PE_PERSON.person_id%TYPE) IS

6110: SELECT person_id
6111: FROM IGS_PE_PERSON
6112: WHERE oracle_username = cp_username;
6113: CURSOR c_person_prefs(
6114: cp_person_id IGS_PE_PERSON.person_id%TYPE) IS
6115: SELECT LAST_UPDATED_BY
6116: FROM IGS_PE_PERS_PREFS_all
6117: WHERE person_id = cp_person_id;
6118: v_other_detail VARCHAR2(255);

Line 6120: -- this module updates the enrolment values for a IGS_PE_PERSON's preference

6116: FROM IGS_PE_PERS_PREFS_all
6117: WHERE person_id = cp_person_id;
6118: v_other_detail VARCHAR2(255);
6119: BEGIN
6120: -- this module updates the enrolment values for a IGS_PE_PERSON's preference
6121: -- table
6122:
6123: -- added after ORACLE_USERNAME issue...
6124: v_person_id := FND_GLOBAL.USER_ID;