APPS.IGS_DA_TRNS_IMP dependencies on HZ_EDUCATION

Line 196: l_object_version_number hz_education.object_version_number%TYPE

192: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
193: l_error_text VARCHAR2 (2000);
194: l_education_id NUMBER;
195: l_status VARCHAR2 (10);
196: l_object_version_number hz_education.object_version_number%TYPE
197: := NULL;
198: l_rowid VARCHAR2 (25);
199: l_prog_label VARCHAR2 (100)
200: := 'igs.plsql.igs_da_trns_imp';

Line 366: FROM hz_education h1, hz_parties h2

362:
363: CURSOR c_edu_id
364: IS
365: SELECT h1.education_id
366: FROM hz_education h1, hz_parties h2
367: WHERE h1.party_id = acad_hist_rec.person_id
368: AND h2.party_number = acad_hist_rec.prev_institution_code
369: AND h2.party_id = h1.school_party_id
370: ORDER BY h1.creation_date DESC;

Line 427: FROM hz_education

423: AS
424: CURSOR c_edu_id
425: IS
426: SELECT education_id
427: FROM hz_education
428: WHERE party_id = p_person_id;
429:
430: CURSOR c_trans (cp_education_id igs_ad_transcript.education_id%TYPE)
431: IS

Line 1379: cp_person_id hz_education.party_id%TYPE,

1375: )
1376: ORDER BY last_update_date DESC;
1377:
1378: CURSOR c_edu_id (
1379: cp_person_id hz_education.party_id%TYPE,
1380: p_school_party_id hz_education.school_party_id%TYPE
1381: )
1382: IS
1383: SELECT hz.ROWID, hz.*

Line 1380: p_school_party_id hz_education.school_party_id%TYPE

1376: ORDER BY last_update_date DESC;
1377:
1378: CURSOR c_edu_id (
1379: cp_person_id hz_education.party_id%TYPE,
1380: p_school_party_id hz_education.school_party_id%TYPE
1381: )
1382: IS
1383: SELECT hz.ROWID, hz.*
1384: FROM hz_education hz

Line 1384: FROM hz_education hz

1380: p_school_party_id hz_education.school_party_id%TYPE
1381: )
1382: IS
1383: SELECT hz.ROWID, hz.*
1384: FROM hz_education hz
1385: WHERE hz.party_id = cp_person_id
1386: AND hz.school_party_id = p_school_party_id
1387: ORDER BY hz.last_update_date DESC;
1388:

Line 1410: FROM hz_education hz

1406:
1407: CURSOR c_edu
1408: IS
1409: SELECT hz.ROWID, hz.*
1410: FROM hz_education hz
1411: WHERE education_id = l_trans_cur_rec.education_id;
1412:
1413: dup_cur_rec c_dup_cur%ROWTYPE;
1414: l_person_number hz_parties.party_number%TYPE;

Line 1493: hz_education_pkg.update_row (x_rowid => l_edu_id_rec.ROWID,

1489:
1490: IF c_edu_id%FOUND
1491: THEN
1492: l_trans_cur_rec.education_id := l_edu_id_rec.education_id;
1493: hz_education_pkg.update_row (x_rowid => l_edu_id_rec.ROWID,
1494: x_education_id => l_edu_id_rec.education_id,
1495: x_course_major => l_edu_id_rec.course_major,
1496: x_party_id => l_edu_id_rec.party_id,
1497: x_school_party_id => l_edu_id_rec.school_party_id,

Line 1589: hz_education_pkg.update_row (x_rowid => l_edu_rec.ROWID,

1585: -- set the institution rec as inactive
1586:
1587: OPEN c_edu;
1588: FETCH c_edu INTO l_edu_rec;
1589: hz_education_pkg.update_row (x_rowid => l_edu_rec.ROWID,
1590: x_education_id => l_edu_rec.education_id,
1591: x_course_major => l_edu_rec.course_major,
1592: x_party_id => l_edu_rec.party_id,
1593: x_school_party_id => l_edu_rec.school_party_id,