APPS.IGS_HE_IMPORT_DATA dependencies on IGS_PE_PERSON

Line 24: CURSOR c_pe_det ( cp_person_number igs_pe_person.person_number%TYPE ) IS

20: l_batch_id igs_he_ucas_imp_err.batch_id%TYPE ;
21: l_error_flag BOOLEAN ;
22:
23: -- Get the oss person details
24: CURSOR c_pe_det ( cp_person_number igs_pe_person.person_number%TYPE ) IS
25: SELECT p.party_id person_id, p.person_last_name surname,
26: p.person_first_name given_names,
27: pp.gender sex,
28: pp.date_of_birth birth_dt

Line 471: p_person_id igs_pe_person.person_id%TYPE ,

467: PROCEDURE populate_imp_int (
468: p_source_type_id igs_pe_src_types_all.source_type_id%TYPE,
469: p_batch_id NUMBER, -- admission import batch id
470: p_orgid NUMBER ,
471: p_person_id igs_pe_person.person_id%TYPE ,
472: p_hesa_id igs_he_ucas_imp_int.interface_hesa_id%TYPE) AS
473: /******************************************************************
474: Created By : smaddali
475: Date Created By : 29-oct-2002

Line 1121: CURSOR c_alt_persid_type( cp_persid_type igs_pe_person_id_typ.person_id_type%TYPE ) IS

1117: err.interface_hesa_id = NVL(cp_interface_id, err.interface_hesa_id);
1118: c_del_err_rec c_del_err%ROWTYPE ;
1119:
1120: -- check if person id type is setup
1121: CURSOR c_alt_persid_type( cp_persid_type igs_pe_person_id_typ.person_id_type%TYPE ) IS
1122: SELECT 'X'
1123: FROM igs_pe_person_id_typ
1124: WHERE person_id_type = cp_persid_type ;
1125:

Line 1123: FROM igs_pe_person_id_typ

1119:
1120: -- check if person id type is setup
1121: CURSOR c_alt_persid_type( cp_persid_type igs_pe_person_id_typ.person_id_type%TYPE ) IS
1122: SELECT 'X'
1123: FROM igs_pe_person_id_typ
1124: WHERE person_id_type = cp_persid_type ;
1125:
1126: -- Check if alternate id type HESA_INST for institution is setup
1127: CURSOR c_alt_orgid IS

Line 1182: l_person_number igs_pe_person.person_number%TYPE ;

1178: AND (end_dt IS NULL OR start_dt <> end_dt);
1179:
1180: c_alt_persid_rec c_alt_persid%ROWTYPE ;
1181:
1182: l_person_number igs_pe_person.person_number%TYPE ;
1183:
1184: -- get the student program attempt hesa record
1185: CURSOR c_spa( cp_person_id igs_he_st_spa.person_id%TYPE ,
1186: cp_course_cd igs_he_st_spa.course_cd%TYPE ) IS

Line 1313: CURSOR c_person_info (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS

1309: AND a.institution_code = cp_inst_cd ;
1310: l_acad_hist_count NUMBER(3);
1311:
1312: -- Get the Person number for the passed person id.
1313: CURSOR c_person_info (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
1314: SELECT person_number, last_name surname, first_name given_names, gender sex, birth_date birth_dt
1315: FROM igs_pe_person_base_v
1316: WHERE person_id = cp_person_id;
1317: l_person_info_rec c_person_info%ROWTYPE;

Line 1315: FROM igs_pe_person_base_v

1311:
1312: -- Get the Person number for the passed person id.
1313: CURSOR c_person_info (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
1314: SELECT person_number, last_name surname, first_name given_names, gender sex, birth_date birth_dt
1315: FROM igs_pe_person_base_v
1316: WHERE person_id = cp_person_id;
1317: l_person_info_rec c_person_info%ROWTYPE;
1318:
1319: -- Get the Admission Interface ID while populating Acad Hisotry Interface table

Line 1333: cp_person_number igs_pe_person.person_number%TYPE ) IS

1329: l_interface_id igs_ad_interface_all.interface_id%TYPE ;
1330:
1331: -- Get the admission application instance interface records whose import has failed
1332: CURSOR c_adm_int( cp_batch_id igs_ad_interface.batch_id%TYPE,
1333: cp_person_number igs_pe_person.person_number%TYPE ) IS
1334: SELECT a.person_number, a.interface_id
1335: FROM igs_ad_interface a
1336: WHERE a.batch_id = cp_batch_id AND
1337: a.person_number= cp_person_number AND