APPS.IGF_AP_GEN_001 dependencies on HZ_PARTIES

Line 21: CURSOR c_comm_date(cp_person_id hz_parties.party_id%TYPE, cp_course_cd igs_ps_ver_all.course_cd%TYPE,

17: || procedure that gets the key program based on the
18: || award year. this key program will be used in calculating
19: || the course commencement date
20: */
21: CURSOR c_comm_date(cp_person_id hz_parties.party_id%TYPE, cp_course_cd igs_ps_ver_all.course_cd%TYPE,
22: cp_version_number igs_ps_ver_all.version_number%TYPE)IS
23: SELECT commencement_dt
24: FROM igs_en_stdnt_ps_att_all
25: WHERE course_cd = cp_course_cd

Line 29: l_person_id hz_parties.party_id%TYPE;

25: WHERE course_cd = cp_course_cd
26: AND version_number = cp_version_number
27: AND person_id = cp_person_id;
28: l_comm_date c_comm_date%ROWTYPE;
29: l_person_id hz_parties.party_id%TYPE;
30: x_course_cd igs_ps_ver_all.course_cd%TYPE;
31: x_version_number igs_ps_ver_all.version_number%TYPE;
32: BEGIN
33: -- call igf_gr_gen.get_person_id to get the Person ID for the Base ID

Line 61: CURSOR key_program_dtl_cur(cp_person_id hz_parties.party_id%TYPE, cp_course_cd igs_ps_ver_all.course_cd%TYPE,

57: || Who When What
58: || (reverse chronological order - newest change first)
59: */
60: -- Get the details of the Key Program
61: CURSOR key_program_dtl_cur(cp_person_id hz_parties.party_id%TYPE, cp_course_cd igs_ps_ver_all.course_cd%TYPE,
62: cp_version_number igs_ps_ver_all.version_number%TYPE) IS
63: SELECT course_cd, version_number, cal_type, location_cd, attendance_mode, attendance_type
64: FROM igs_en_stdnt_ps_att_all
65: WHERE course_cd = cp_course_cd

Line 98: CURSOR c_spa( cp_person_id hz_parties.party_id%TYPE,

94: cp_term_enr_dtl_rec igs_en_spa_terms%ROWTYPE;
95: x_course_cd igs_ps_ver_all.course_cd%TYPE;
96: x_version_number igs_ps_ver_all.version_number%TYPE;
97:
98: CURSOR c_spa( cp_person_id hz_parties.party_id%TYPE,
99: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
100: cp_version_number igs_en_stdnt_ps_att.version_number%TYPE
101: )IS
102: SELECT commencement_dt

Line 184: l_person_id hz_parties.party_id%TYPE;

180: || Change History :
181: || Who When What
182: || (reverse chronological order - newest change first)
183: */
184: l_person_id hz_parties.party_id%TYPE;
185: lv_class_standing igs_pr_class_std.class_standing%TYPE;
186: x_key_program_course_cd igs_ps_ver_all.course_cd%TYPE;
187: x_version_number igs_ps_ver_all.version_number%TYPE;
188: BEGIN

Line 224: l_person_id hz_parties.party_id%TYPE;

220: FROM igs_ps_ver
221: WHERE course_cd = cp_course_cd
222: AND version_number = cp_version_number;
223: l_Program_Type Program_Type_Cur%ROWTYPE;
224: l_person_id hz_parties.party_id%TYPE;
225: x_key_program_course_cd igs_ps_ver_all.course_cd%TYPE;
226: x_version_number igs_ps_ver_all.version_number%TYPE;
227: BEGIN
228: l_person_id :=igf_gr_gen.get_person_id(cp_base_id);

Line 346: CURSOR c_spa_terms( cp_person_id hz_parties.party_id%TYPE, cp_cal_type igs_ca_inst.cal_type%TYPE, cp_seq_no igs_ca_inst.sequence_number%TYPE)IS

342: AND sup_ci_sequence_number = cp_aw_seq_no
343: )
344: ORDER BY enrolled_start_dt;
345:
346: CURSOR c_spa_terms( cp_person_id hz_parties.party_id%TYPE, cp_cal_type igs_ca_inst.cal_type%TYPE, cp_seq_no igs_ca_inst.sequence_number%TYPE)IS
347: SELECT spa.*
348: FROM IGS_EN_SPA_TERMS spa,
349: (SELECT su.person_id,
350: su.course_cd,

Line 369: CURSOR c_spa( cp_person_id hz_parties.party_id%TYPE)IS

365: AND unit_attempt.load_cal_type = spa.term_cal_type
366: AND unit_attempt.load_ci_sequence_number = spa.term_sequence_number;
367: l_term_rec c_ld_calendars_start%ROWTYPE;
368:
369: CURSOR c_spa( cp_person_id hz_parties.party_id%TYPE)IS
370: SELECT *
371: FROM igs_en_stdnt_ps_att
372: WHERE person_id = cp_person_id
373: AND key_program = 'Y';

Line 526: cp_person_id hz_parties.party_id%TYPE,

522: WHERE fa.base_id = cp_base_id ;
523: l_fa_base_rec c_fa_base_rec%ROWTYPE;
524:
525: CURSOR c_spa_terms(
526: cp_person_id hz_parties.party_id%TYPE,
527: cp_cal_type igs_ca_inst.cal_type%TYPE,
528: cp_seq_no igs_ca_inst.sequence_number%TYPE
529: ) IS
530: SELECT *