APPS.IGF_AP_GEN_001 dependencies on IGF_GR_GEN

Line 33: -- call igf_gr_gen.get_person_id to get the Person ID for the Base ID

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
34: l_person_id :=igf_gr_gen.get_person_id(cp_base_id);
35: -- get the key program from the get_key_program api
36: get_key_program(cp_base_id, x_course_cd, x_version_number);
37: -- get the course commencement date from the spa table. this date can be null !!!

Line 34: l_person_id :=igf_gr_gen.get_person_id(cp_base_id);

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
34: l_person_id :=igf_gr_gen.get_person_id(cp_base_id);
35: -- get the key program from the get_key_program api
36: get_key_program(cp_base_id, x_course_cd, x_version_number);
37: -- get the course commencement date from the spa table. this date can be null !!!
38: OPEN c_comm_date(l_person_id, x_course_cd, x_version_number);

Line 111: -- Call IGF_GR_GEN.GET_PERSON_ID to get the Person ID for the Base ID

107:
108:
109:
110: BEGIN
111: -- Call IGF_GR_GEN.GET_PERSON_ID to get the Person ID for the Base ID
112: l_person_id :=igf_gr_gen.get_person_id(cp_base_id);
113:
114: -- get the key program from the get_key_program api
115: get_key_program(cp_base_id, x_course_cd, x_version_number);

Line 112: l_person_id :=igf_gr_gen.get_person_id(cp_base_id);

108:
109:
110: BEGIN
111: -- Call IGF_GR_GEN.GET_PERSON_ID to get the Person ID for the Base ID
112: l_person_id :=igf_gr_gen.get_person_id(cp_base_id);
113:
114: -- get the key program from the get_key_program api
115: get_key_program(cp_base_id, x_course_cd, x_version_number);
116:

Line 189: l_person_id :=igf_gr_gen.get_person_id(cp_base_id);

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
189: l_person_id :=igf_gr_gen.get_person_id(cp_base_id);
190: -- get the key program from the get_key_program api
191: get_key_program(cp_base_id, x_key_program_course_cd, x_version_number);
192: lv_class_standing := igs_pr_get_class_std.get_class_standing(l_person_id,
193: x_key_program_course_cd,

Line 228: l_person_id :=igf_gr_gen.get_person_id(cp_base_id);

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);
229: -- get the key program from the get_key_program api
230: get_key_program(cp_base_id, x_key_program_course_cd, x_version_number);
231: -- Get the Program Type
232: OPEN Program_Type_Cur(x_key_program_course_cd,x_version_number);

Line 448: l_person_id := igf_gr_Gen.get_person_id(cp_fa_base_id);

444: END LOOP;
445: END LOOP;
446: END IF;
447: -- the control reached here. so no term records for the load calendars. peep into the prog att table directly and return the values
448: l_person_id := igf_gr_Gen.get_person_id(cp_fa_base_id);
449: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
450: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_ap_gen_001.get_term_dtl.debug',
451: 'no term record details available for '||cp_fa_base_id);
452: END IF;