APPS.IGS_PE_RELATIONSHIPS_PKG dependencies on IGS_PE_PERSON

Line 106: CURSOR c_student_age (cp_person_id igs_pe_person.person_id%TYPE) IS

102:
103: --
104: -- cursor to get the age of student
105: --
106: CURSOR c_student_age (cp_person_id igs_pe_person.person_id%TYPE) IS
107: SELECT TO_NUMBER(nvl((SYSDATE-birth_date)/365,0))
108: FROM igs_pe_person_base_v
109: WHERE person_id = cp_person_id;
110: l_student_age NUMBER;

Line 108: FROM igs_pe_person_base_v

104: -- cursor to get the age of student
105: --
106: CURSOR c_student_age (cp_person_id igs_pe_person.person_id%TYPE) IS
107: SELECT TO_NUMBER(nvl((SYSDATE-birth_date)/365,0))
108: FROM igs_pe_person_base_v
109: WHERE person_id = cp_person_id;
110: l_student_age NUMBER;
111:
112: l_return_status VARCHAR2(1) := NULL;

Line 188: IGS_PE_PERSON_ADDR_PKG.INSERT_ROW(

184:
185: IF (p_validate) THEN
186: l_party_site_id := rec_student_addr.party_site_id;
187:
188: IGS_PE_PERSON_ADDR_PKG.INSERT_ROW(
189: p_action =>'INSERT',
190: p_rowid => l_rowid,
191: p_location_id => l_location_id,
192: p_start_dt => rec_student_addr.START_DT,

Line 349: FROM IGS_PE_PERSON_BASE_V

345: IF p_DML = 'BEFORE' THEN
346: DECLARE
347: CURSOR per_birth_dt IS
348: SELECT birth_date
349: FROM IGS_PE_PERSON_BASE_V
350: WHERE person_id = p_subject_id;
351:
352: l_birth_date IGS_PE_PERSON_BASE_V.BIRTH_DATE%TYPE;
353: BEGIN

Line 352: l_birth_date IGS_PE_PERSON_BASE_V.BIRTH_DATE%TYPE;

348: SELECT birth_date
349: FROM IGS_PE_PERSON_BASE_V
350: WHERE person_id = p_subject_id;
351:
352: l_birth_date IGS_PE_PERSON_BASE_V.BIRTH_DATE%TYPE;
353: BEGIN
354: IF p_start_date > sysdate THEN
355: fnd_message.set_name ('IGS', 'IGS_AD_ST_DT_LT_SYS_DT');
356: igs_ge_msg_stack.add;

Line 450: l_result := Igs_Pe_Person_PKG.Get_PK_For_Validation(p_object_id);

446: FETCH get_party_rel_type_cur INTO l_party_rel_type;
447: CLOSE get_party_rel_type_cur;
448: IF l_party_rel_type = 'X' THEN
449: -- fix for bug 5254202
450: l_result := Igs_Pe_Person_PKG.Get_PK_For_Validation(p_object_id);
451:
452: IGS_PE_HZ_REL_PKG.INSERT_ROW(
453: x_rowid =>l_rowid ,
454: x_relationship_id =>p_party_relationship_id,