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

Line 147: CURSOR c_igs_pe_ucas(cp_n_person_id igs_pe_person.person_id%TYPE) IS

143: AND aav.admission_appl_number = cp_admission_appl_number;
144:
145: c_aav_uk_rec c_aav_uk%ROWTYPE;
146:
147: CURSOR c_igs_pe_ucas(cp_n_person_id igs_pe_person.person_id%TYPE) IS
148: SELECT
149: api_person_id
150: FROM
151: igs_pe_alt_pers_id

Line 276: -- IGS_PE_PERSON in the same admission period.

272: EXIT;
273: END LOOP;
274: ELSE
275: -- Validate for a matching admission course application instance for the
276: -- IGS_PE_PERSON in the same admission period.
277: FOR v_acaiv_rec IN c_acaiv(
278: p_person_id,
279: p_course_cd,
280: p_admission_appl_number,

Line 300: -- IGS_PE_PERSON

296: CLOSE c_igs_pe_ucas;
297:
298: IF(v_return = TRUE) THEN
299: -- Validate for a matching admission course application instance for the
300: -- IGS_PE_PERSON
301: -- in a different admission period.
302: FOR v_acaiv_aa_rec IN c_acaiv_aa(
303: p_person_id,
304: p_course_cd,

Line 2834: -- 1) The admission outcome status authorising IGS_PE_PERSON ID must be null if the

2830: p_message_name OUT NOCOPY VARCHAR2 )
2831: RETURN BOOLEAN AS
2832: BEGIN -- admp_val_ovrd_person
2833: -- Validate the following :
2834: -- 1) The admission outcome status authorising IGS_PE_PERSON ID must be null if the
2835: -- outcome
2836: -- status cannot be overridden for the admission process category of the
2837: -- admission application
2838: -- 2) The admission outcome status authorising IGS_PE_PERSON ID must be null if the

Line 2838: -- 2) The admission outcome status authorising IGS_PE_PERSON ID must be null if the

2834: -- 1) The admission outcome status authorising IGS_PE_PERSON ID must be null if the
2835: -- outcome
2836: -- status cannot be overridden for the admission process category of the
2837: -- admission application
2838: -- 2) The admission outcome status authorising IGS_PE_PERSON ID must be null if the
2839: -- admission outcome
2840: -- status authorising date is not set
2841: -- 3) The admission outcome status authorising IGS_PE_PERSON ID must be set if the
2842: -- admission outcome

Line 2841: -- 3) The admission outcome status authorising IGS_PE_PERSON ID must be set if the

2837: -- admission application
2838: -- 2) The admission outcome status authorising IGS_PE_PERSON ID must be null if the
2839: -- admission outcome
2840: -- status authorising date is not set
2841: -- 3) The admission outcome status authorising IGS_PE_PERSON ID must be set if the
2842: -- admission outcome
2843: -- status authorising date is set
2844: -- 4) If set, the admission outcome status authorising IGS_PE_PERSON ID must be a
2845: -- staff member.

Line 2844: -- 4) If set, the admission outcome status authorising IGS_PE_PERSON ID must be a

2840: -- status authorising date is not set
2841: -- 3) The admission outcome status authorising IGS_PE_PERSON ID must be set if the
2842: -- admission outcome
2843: -- status authorising date is set
2844: -- 4) If set, the admission outcome status authorising IGS_PE_PERSON ID must be a
2845: -- staff member.
2846: DECLARE
2847: v_message_name VARCHAR2(30);
2848: BEGIN

Line 2868: -- Check if the overriding IGS_PE_PERSON ID is a staff member.

2864: p_adm_otcm_status_auth_person IS NULL THEN
2865: p_message_name := 'IGS_AD_ARTH_PRSNID_SET_ARTHDT' ;
2866: RETURN FALSE;
2867: END IF;
2868: -- Check if the overriding IGS_PE_PERSON ID is a staff member.
2869: IF p_adm_otcm_status_auth_person IS NOT NULL THEN
2870: IF IGS_AD_VAL_ACAI.genp_val_staff_prsn (
2871: p_adm_otcm_status_auth_person,
2872: v_message_name) = FALSE THEN

Line 2887: -- Validate a IGS_PE_PERSON id to ensure the IGS_PE_PERSON is a staff member.

2883: IGS_GE_MSG_STACK.ADD;
2884: APP_EXCEPTION.RAISE_EXCEPTION;
2885: END admp_val_ovrd_person;
2886: --
2887: -- Validate a IGS_PE_PERSON id to ensure the IGS_PE_PERSON is a staff member.
2888: FUNCTION genp_val_staff_prsn(
2889: p_person_id IN NUMBER ,
2890: p_message_name OUT NOCOPY VARCHAR2 )
2891: RETURN BOOLEAN AS

Line 2896: FROM igs_pe_person_types pt,igs_pe_typ_instances pti

2892: BEGIN
2893: DECLARE
2894: CURSOR pe_typ_cd IS
2895: SELECT pti.person_type_code
2896: FROM igs_pe_person_types pt,igs_pe_typ_instances pti
2897: WHERE pti.person_id = p_person_id
2898: AND pti.person_type_code = pt.person_type_code
2899: AND pt.system_type = 'STAFF'
2900: AND SYSDATE BETWEEN pti.start_date AND NVL(pti.end_date,SYSDATE);

Line 2918: -- Validate a IGS_PE_PERSON id to ensure the IGS_PE_PERSON is a staff/Faculty member.

2914: END IF;
2915: END;
2916: END genp_val_staff_prsn;
2917: --
2918: -- Validate a IGS_PE_PERSON id to ensure the IGS_PE_PERSON is a staff/Faculty member.
2919: FUNCTION genp_val_staff_fculty_prsn(
2920: p_person_id IN NUMBER ,
2921: p_message_name OUT NOCOPY VARCHAR2 )
2922: RETURN BOOLEAN AS

Line 2926: FROM igs_pe_person_types pt,igs_pe_typ_instances pti

2922: RETURN BOOLEAN AS
2923:
2924: CURSOR pe_typ_cd IS
2925: SELECT pti.person_type_code
2926: FROM igs_pe_person_types pt,igs_pe_typ_instances pti
2927: WHERE pti.person_id = p_person_id
2928: AND pti.person_type_code = pt.person_type_code
2929: AND pt.system_type IN ('STAFF', 'FACULTY')
2930: AND SYSDATE BETWEEN pti.start_date AND NVL(pti.end_date,SYSDATE);

Line 2935: FROM igs_pe_person_base_v base, igs_pe_hz_parties pd

2931: lv_pe_typ_cd pe_typ_cd%RowType;
2932:
2933: CURSOR c_dmi IS
2934: SELECT 'X'
2935: FROM igs_pe_person_base_v base, igs_pe_hz_parties pd
2936: WHERE base.person_id = p_person_id
2937: AND base.person_id = pd.party_id (+)
2938: AND DECODE(base.date_of_death,NULL,NVL(pd.deceased_ind,'N'),'Y') = 'Y';
2939:

Line 2940: l_deceased igs_pe_person.person_id%TYPE := NULL;

2936: WHERE base.person_id = p_person_id
2937: AND base.person_id = pd.party_id (+)
2938: AND DECODE(base.date_of_death,NULL,NVL(pd.deceased_ind,'N'),'Y') = 'Y';
2939:
2940: l_deceased igs_pe_person.person_id%TYPE := NULL;
2941:
2942: BEGIN
2943:
2944: OPEN pe_typ_cd;

Line 2962: -- Validate a IGS_PE_PERSON id to ensure the IGS_PE_PERSON is a staff/Faculty OR Evaluator member.

2958:
2959: RETURN TRUE;
2960: END genp_val_staff_fculty_prsn;
2961:
2962: -- Validate a IGS_PE_PERSON id to ensure the IGS_PE_PERSON is a staff/Faculty OR Evaluator member.
2963: FUNCTION genp_val_staff_fac_eva_prsn(
2964: p_person_id IN NUMBER ,
2965: p_message_name OUT NOCOPY VARCHAR2 )
2966: RETURN BOOLEAN AS

Line 2970: FROM igs_pe_person_types pt,igs_pe_typ_instances pti

2966: RETURN BOOLEAN AS
2967:
2968: CURSOR pe_typ_cd IS
2969: SELECT pti.person_type_code
2970: FROM igs_pe_person_types pt,igs_pe_typ_instances pti
2971: WHERE pti.person_id = p_person_id
2972: AND pti.person_type_code = pt.person_type_code
2973: AND pt.system_type IN ('STAFF', 'FACULTY' , 'EVALUATOR')
2974: AND SYSDATE BETWEEN pti.start_date AND NVL(pti.end_date,SYSDATE);

Line 2979: FROM igs_pe_person_base_v base, igs_pe_hz_parties pd

2975: lv_pe_typ_cd pe_typ_cd%RowType;
2976:
2977: CURSOR c_dmi IS
2978: SELECT 'X'
2979: FROM igs_pe_person_base_v base, igs_pe_hz_parties pd
2980: WHERE base.person_id = p_person_id
2981: AND base.person_id = pd.party_id (+)
2982: AND DECODE(base.date_of_death,NULL,NVL(pd.deceased_ind,'N'),'Y') = 'Y';
2983:

Line 2984: l_deceased igs_pe_person.person_id%TYPE := NULL;

2980: WHERE base.person_id = p_person_id
2981: AND base.person_id = pd.party_id (+)
2982: AND DECODE(base.date_of_death,NULL,NVL(pd.deceased_ind,'N'),'Y') = 'Y';
2983:
2984: l_deceased igs_pe_person.person_id%TYPE := NULL;
2985:
2986: BEGIN
2987:
2988: OPEN pe_typ_cd;

Line 3247: --validate if the admission application IGS_PE_PERSON details are complete

3243: v_mandatory_acad_honors ,
3244: v_mandatory_des_unitsets,
3245: v_mandatory_extrcurr);
3246:
3247: --validate if the admission application IGS_PE_PERSON details are complete
3248: IF (IGS_AD_VAL_ACAI.admp_val_pe_comp(
3249: p_person_id,
3250: p_effective_dt,
3251: v_mandatory_athletics,

Line 3530: v_person_id igs_pe_person_v.person_id%TYPE;

3526: cty.course_type = crv.course_type AND
3527: cty.research_type_ind = 'Y';
3528:
3529: v_return BOOLEAN := TRUE;
3530: v_person_id igs_pe_person_v.person_id%TYPE;
3531: CURSOR c_apcs IS
3532: SELECT apcs.s_admission_step_type
3533: FROM IGS_AD_PRCS_CAT_STEP apcs
3534: WHERE admission_cat= (SELECT admission_cat

Line 4381: -- Validate if the specified admission application IGS_PE_PERSON is complete.

4377: IGS_GE_MSG_STACK.ADD;
4378: APP_EXCEPTION.RAISE_EXCEPTION;
4379: END admp_val_acai_comp;
4380: --
4381: -- Validate if the specified admission application IGS_PE_PERSON is complete.
4382: FUNCTION admp_val_pe_comp(
4383: p_person_id IN NUMBER ,
4384: p_effective_dt IN DATE ,
4385: p_check_athletics IN BOOLEAN,

Line 4423: -- Validate if the specified admission application IGS_PE_PERSON is complete

4419: p_valid_excurr OUT NOCOPY BOOLEAN)
4420: RETURN BOOLEAN AS
4421:
4422: BEGIN -- admp_val_pe_comp
4423: -- Validate if the specified admission application IGS_PE_PERSON is complete
4424: DECLARE
4425: v_valid_athletics BOOLEAN := FALSE;
4426: v_valid_alternate BOOLEAN := FALSE;
4427: v_valid_address BOOLEAN := FALSE;

Line 4441: v_birth_dt IGS_PE_PERSON.birth_dt%TYPE;

4437: v_valid_employment BOOLEAN := FALSE;
4438: v_valid_membership BOOLEAN := FALSE;
4439: v_valid_dob BOOLEAN := FALSE;
4440: v_valid_title BOOLEAN := FALSE;
4441: v_birth_dt IGS_PE_PERSON.birth_dt%TYPE;
4442: v_title IGS_PE_PERSON.title%TYPE;
4443: v_valid_excurr BOOLEAN := FALSE;
4444: CURSOR c_pe IS
4445: SELECT pe.birth_date birth_dt,

Line 4442: v_title IGS_PE_PERSON.title%TYPE;

4438: v_valid_membership BOOLEAN := FALSE;
4439: v_valid_dob BOOLEAN := FALSE;
4440: v_valid_title BOOLEAN := FALSE;
4441: v_birth_dt IGS_PE_PERSON.birth_dt%TYPE;
4442: v_title IGS_PE_PERSON.title%TYPE;
4443: v_valid_excurr BOOLEAN := FALSE;
4444: CURSOR c_pe IS
4445: SELECT pe.birth_date birth_dt,
4446: pe.title

Line 4447: FROM IGS_PE_PERSON_BASE_V pe

4443: v_valid_excurr BOOLEAN := FALSE;
4444: CURSOR c_pe IS
4445: SELECT pe.birth_date birth_dt,
4446: pe.title
4447: FROM IGS_PE_PERSON_BASE_V pe
4448: WHERE pe.person_id = p_person_id;
4449: v_list_element VARCHAR2(30);
4450: BEGIN
4451: --set default message number

Line 4540: -- Validate IGS_PE_PERSON level data

4536: ELSE
4537: p_valid_excurr := TRUE;
4538: END IF;
4539:
4540: -- Validate IGS_PE_PERSON level data
4541: IF ( p_check_athletics = TRUE OR
4542: p_check_alternate = TRUE OR
4543: p_check_address = TRUE OR
4544: p_check_disability = TRUE OR