APPS.IGS_AD_ACAD_HISTORY_PKG dependencies on HZ_EDUCATION

Line 87: CURSOR c_degree_code (p_degree hz_education.degree_received%TYPE) IS

83: FROM hz_parties hz, igs_pe_hz_parties php
84: WHERE php.oss_org_unit_cd = p_party_number
85: AND php.party_id = hz.party_id ;
86:
87: CURSOR c_degree_code (p_degree hz_education.degree_received%TYPE) IS
88: SELECT dg.degree_cd
89: FROM igs_ps_degrees dg,
90: igs_ps_type_all ps
91: WHERE dg.degree_cd = p_degree

Line 103: lv_school_party_id hz_education.school_party_id%TYPE;

99: WHERE person_id = p_person_id;
100:
101: tmp_var1 VARCHAR2(2000);
102: tmp_var VARCHAR2(2000);
103: lv_school_party_id hz_education.school_party_id%TYPE;
104: lv_school_attended_name hz_parties.party_name%TYPE;
105: lv_degree hz_education.degree_received%TYPE;
106: l_birth_dt igs_pe_person_base_v.birth_date%TYPE;
107: /*

Line 105: lv_degree hz_education.degree_received%TYPE;

101: tmp_var1 VARCHAR2(2000);
102: tmp_var VARCHAR2(2000);
103: lv_school_party_id hz_education.school_party_id%TYPE;
104: lv_school_attended_name hz_parties.party_name%TYPE;
105: lv_degree hz_education.degree_received%TYPE;
106: l_birth_dt igs_pe_person_base_v.birth_date%TYPE;
107: /*
108: || Created By : [email protected]
109: || Created On : 07-SEP-2000

Line 447: CURSOR c_degree_code (p_degree hz_education.degree_received%TYPE) IS

443: FROM igs_av_adv_standing
444: WHERE person_id = p_person_id
445: AND exemption_institution_cd = p_party_number;
446:
447: CURSOR c_degree_code (p_degree hz_education.degree_received%TYPE) IS
448: SELECT dg.degree_cd
449: FROM igs_ps_degrees dg
450: WHERE dg.degree_cd = p_degree
451: AND dg.closed_ind ='N'

Line 484: lv_school_party_id hz_education.school_party_id%TYPE ;

480: old_program_code IGS_AD_ACAD_HISTORY_V.program_code%TYPE;
481:
482: lv_adv_standing_exists VARCHAR2(1) := NULL ;
483: lv_school_attended_name hz_parties.party_name%TYPE;
484: lv_school_party_id hz_education.school_party_id%TYPE ;
485: lv_degree hz_education.degree_received%TYPE;
486: l_birth_dt igs_pe_person_base_v.birth_date%TYPE;
487:
488: l_count NUMBER; --jchin Bug 4629226

Line 485: lv_degree hz_education.degree_received%TYPE;

481:
482: lv_adv_standing_exists VARCHAR2(1) := NULL ;
483: lv_school_attended_name hz_parties.party_name%TYPE;
484: lv_school_party_id hz_education.school_party_id%TYPE ;
485: lv_degree hz_education.degree_received%TYPE;
486: l_birth_dt igs_pe_person_base_v.birth_date%TYPE;
487:
488: l_count NUMBER; --jchin Bug 4629226
489:

Line 634: --Update HZ_EDUCATION table by calling this proc hz_per_info_pub.Update_education

630:
631: END IF;
632:
633:
634: --Update HZ_EDUCATION table by calling this proc hz_per_info_pub.Update_education
635: hz_person_info_v2pub.Update_education(
636: p_init_msg_list => FND_API.G_TRUE,
637: p_education_rec => l_education_rec,
638: p_object_version_number => x_object_version_number,