eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_ACAD_HISTORY_PKG dependencies on HZ_PARTIES

Line 73: lv_institution_code HZ_PARTIES.party_number%TYPE;

69: lv_msg_data VARCHAR2(200);
70: lv_education_id NUMBER;
71: lv_Hz_Acad_Hist_Id NUMBER;
72: l_RowId VARCHAR2(25);
73: lv_institution_code HZ_PARTIES.party_number%TYPE;
74: l_mode VARCHAR2(1);
75:
76: CURSOR c_school_party_id (p_party_number hz_parties.party_number%TYPE) IS
77: SELECT party_id

Line 76: CURSOR c_school_party_id (p_party_number hz_parties.party_number%TYPE) IS

72: l_RowId VARCHAR2(25);
73: lv_institution_code HZ_PARTIES.party_number%TYPE;
74: l_mode VARCHAR2(1);
75:
76: CURSOR c_school_party_id (p_party_number hz_parties.party_number%TYPE) IS
77: SELECT party_id
78: FROM igs_pe_hz_parties
79: WHERE oss_org_unit_cd = p_party_number;
80:

Line 78: FROM igs_pe_hz_parties

74: l_mode VARCHAR2(1);
75:
76: CURSOR c_school_party_id (p_party_number hz_parties.party_number%TYPE) IS
77: SELECT party_id
78: FROM igs_pe_hz_parties
79: WHERE oss_org_unit_cd = p_party_number;
80:
81: CURSOR c_school_attended_name (p_party_number hz_parties.party_number%TYPE) IS
82: SELECT party_name

Line 81: CURSOR c_school_attended_name (p_party_number hz_parties.party_number%TYPE) IS

77: SELECT party_id
78: FROM igs_pe_hz_parties
79: WHERE oss_org_unit_cd = p_party_number;
80:
81: CURSOR c_school_attended_name (p_party_number hz_parties.party_number%TYPE) IS
82: SELECT party_name
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 ;

Line 83: FROM hz_parties hz, igs_pe_hz_parties php

79: WHERE oss_org_unit_cd = p_party_number;
80:
81: CURSOR c_school_attended_name (p_party_number hz_parties.party_number%TYPE) IS
82: SELECT party_name
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

Line 95: CURSOR get_dob_dt_cur(p_person_id igs_pe_hz_parties.party_id%TYPE)

91: WHERE dg.degree_cd = p_degree
92: AND dg.closed_ind ='N'
93: AND dg.program_type = ps.course_type;
94:
95: CURSOR get_dob_dt_cur(p_person_id igs_pe_hz_parties.party_id%TYPE)
96: IS
97: SELECT birth_date
98: FROM igs_pe_person_base_v
99: WHERE person_id = p_person_id;

Line 104: lv_school_attended_name hz_parties.party_name%TYPE;

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: /*
108: || Created By : [email protected]

Line 411: lv_institution_code HZ_PARTIES.party_number%TYPE;

407: lv_msg_data VARCHAR2(200);
408: lv_education_id NUMBER;
409: lv_Hz_Acad_Hist_Id NUMBER;
410: l_RowId VARCHAR2(25);
411: lv_institution_code HZ_PARTIES.party_number%TYPE;
412: lv_created_by_module VARCHAR2(255);
413: tmp_var1 VARCHAR2(2000);
414: tmp_var VARCHAR2(2000);
415: l_mode VARCHAR2(1);

Line 430: CURSOR c_school_party_id (p_party_number hz_parties.party_number%TYPE) IS

426: SELECT ROWID, HZ_ACAD_HIST_ID
427: FROM IGS_AD_HZ_ACAD_HIST
428: WHERE EDUCATION_ID = x_Education_Id;
429:
430: CURSOR c_school_party_id (p_party_number hz_parties.party_number%TYPE) IS
431: SELECT party_id
432: FROM igs_pe_hz_parties
433: WHERE oss_org_unit_cd = p_party_number;
434:

Line 432: FROM igs_pe_hz_parties

428: WHERE EDUCATION_ID = x_Education_Id;
429:
430: CURSOR c_school_party_id (p_party_number hz_parties.party_number%TYPE) IS
431: SELECT party_id
432: FROM igs_pe_hz_parties
433: WHERE oss_org_unit_cd = p_party_number;
434:
435: CURSOR c_school_attended_name (p_party_number hz_parties.party_number%TYPE) IS
436: SELECT party_name

Line 435: CURSOR c_school_attended_name (p_party_number hz_parties.party_number%TYPE) IS

431: SELECT party_id
432: FROM igs_pe_hz_parties
433: WHERE oss_org_unit_cd = p_party_number;
434:
435: CURSOR c_school_attended_name (p_party_number hz_parties.party_number%TYPE) IS
436: SELECT party_name
437: FROM hz_parties hz, igs_pe_hz_parties php
438: WHERE php.oss_org_unit_cd = p_party_number
439: AND php.party_id = hz.party_id ;

Line 437: FROM hz_parties hz, igs_pe_hz_parties php

433: WHERE oss_org_unit_cd = p_party_number;
434:
435: CURSOR c_school_attended_name (p_party_number hz_parties.party_number%TYPE) IS
436: SELECT party_name
437: FROM hz_parties hz, igs_pe_hz_parties php
438: WHERE php.oss_org_unit_cd = p_party_number
439: AND php.party_id = hz.party_id ;
440:
441: CURSOR c_adv_standing ( p_party_number hz_parties.party_number%TYPE, p_person_id hz_parties.party_id%TYPE) IS

Line 441: CURSOR c_adv_standing ( p_party_number hz_parties.party_number%TYPE, p_person_id hz_parties.party_id%TYPE) IS

437: FROM hz_parties hz, igs_pe_hz_parties php
438: WHERE php.oss_org_unit_cd = p_party_number
439: AND php.party_id = hz.party_id ;
440:
441: CURSOR c_adv_standing ( p_party_number hz_parties.party_number%TYPE, p_person_id hz_parties.party_id%TYPE) IS
442: SELECT '1'
443: FROM igs_av_adv_standing
444: WHERE person_id = p_person_id
445: AND exemption_institution_cd = p_party_number;

Line 459: CURSOR get_dob_dt_cur(p_person_id igs_pe_hz_parties.party_id%TYPE)

455: SELECT degree_attempted, degree_earned, program_code
456: FROM IGS_AD_ACAD_HISTORY_V ach
457: WHERE ach.education_id = x_education_id;
458:
459: CURSOR get_dob_dt_cur(p_person_id igs_pe_hz_parties.party_id%TYPE)
460: IS
461: SELECT birth_date
462: FROM igs_pe_person_base_v
463: WHERE person_id = p_person_id;

Line 483: lv_school_attended_name hz_parties.party_name%TYPE;

479: old_degree_earned IGS_AD_ACAD_HISTORY_V.degree_earned%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: