APPS.IGS_AD_IMP_ADM_DES dependencies on IGS_PE_PERSON

Line 62: p_person_id IN igs_pe_person.person_id%TYPE,

58:
59: PROCEDURE validate_set_decision_details (
60: p_batch_id IN igs_ad_admde_int.batch_id%TYPE,
61: p_interface_mkdes_id IN igs_ad_admde_int.interface_mkdes_id%TYPE,
62: p_person_id IN igs_pe_person.person_id%TYPE,
63: p_acad_cal_type IN igs_ad_appl.acad_cal_type%TYPE,
64: p_acad_ci_sequence_number IN igs_ad_appl.acad_ci_sequence_number%TYPE,
65: p_adm_cal_type IN igs_ad_appl.adm_cal_type%TYPE,
66: p_adm_ci_sequence_number IN igs_ad_appl.adm_ci_sequence_number%TYPE,

Line 121: cp_person_id igs_pe_person.person_id%TYPE,

117: l_c_appl_des_fields_rec appl_des_fields_cur%ROWTYPE;
118: l_decision_maker VARCHAR2(1);
119:
120: CURSOR appl_dt_cur (
121: cp_person_id igs_pe_person.person_id%TYPE,
122: cp_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE
123: )
124: IS
125: SELECT appl_dt

Line 142: CURSOR c_decision_maker (cp_decision_maker_id igs_pe_person_base_v.person_id%TYPE) IS

138: AND closed_ind = 'N';
139:
140: l_decision_reason_id_found VARCHAR2(1);
141: l_pending_reason_id_found VARCHAR2(1);
142: CURSOR c_decision_maker (cp_decision_maker_id igs_pe_person_base_v.person_id%TYPE) IS
143: SELECT 'x'
144: FROM igs_pe_typ_instances typeinst
145: WHERE typeinst.person_id = cp_decision_maker_id
146: AND typeinst.system_type IN ('STAFF','FACULTY')

Line 151: FROM igs_pe_person_base_v base, igs_pe_hz_parties pd

147: AND (SYSDATE between typeinst.start_date AND NVL(typeinst.end_date,SYSDATE));
148:
149: CURSOR c_dmi (cp_person_id NUMBER) IS
150: SELECT 'X'
151: FROM igs_pe_person_base_v base, igs_pe_hz_parties pd
152: WHERE base.person_id = cp_person_id
153: AND base.person_id = pd.party_id (+)
154: AND DECODE(base.date_of_death,NULL,NVL(pd.deceased_ind,'N'),'Y') = 'Y';
155:

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

152: WHERE base.person_id = cp_person_id
153: AND base.person_id = pd.party_id (+)
154: AND DECODE(base.date_of_death,NULL,NVL(pd.deceased_ind,'N'),'Y') = 'Y';
155:
156: l_deceased igs_pe_person.person_id%TYPE := NULL;
157:
158: BEGIN
159: /* Open the details */
160: OPEN def_fields_cur;

Line 251: p_person_id IN igs_pe_person.person_id%TYPE,

247: p_return_status := 'FALSE';
248: END validate_set_decision_details;
249:
250: PROCEDURE prc_adm_outcome_status (
251: p_person_id IN igs_pe_person.person_id%TYPE,
252: p_admission_appl_number IN igs_ad_appl.admission_appl_number%TYPE,
253: p_nominated_course_cd IN igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
254: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE,
255: p_adm_outcome_status IN igs_ad_ou_stat.adm_outcome_status%TYPE,

Line 572: cp_person_id IN igs_pe_person.person_id%TYPE,

568: AND appl.S_ADMISSION_PROCESS_TYPE = abdd.S_ADMISSION_PROCESS_TYPE /*2*/) /*1*/)
569: AND status = '2';
570:
571: CURSOR c_old_adm_outcome_status (
572: cp_person_id IN igs_pe_person.person_id%TYPE,
573: cp_admission_appl_number IN igs_ad_appl.admission_appl_number%TYPE,
574: cp_nominated_course_cd IN igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
575: cp_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE
576: ) IS