APPS.IGF_GR_GEN_XML dependencies on IGF_SL_GEN

Line 38: student_dtl_rec igf_sl_gen.person_dtl_rec;

34:
35: gv_document_id_txt VARCHAR2(30);
36: g_ver_num VARCHAR2(30);
37: g_full_resp_code VARCHAR2(30);
38: student_dtl_rec igf_sl_gen.person_dtl_rec;
39:
40: FUNCTION is_alpha_numeric(p_param_value IN VARCHAR2)
41: RETURN BOOLEAN AS
42: /*************************************************************

Line 604: student_dtl_cur igf_sl_gen.person_dtl_cur;

600: WHERE dbchgdtls.award_id = cp_award_id;
601: rec_disb_chg_dtls cur_disb_chg_dtls%ROWTYPE;
602:
603:
604: student_dtl_cur igf_sl_gen.person_dtl_cur;
605: lv_complete BOOLEAN := TRUE;
606: l_award_id igf_aw_db_chg_dtls.award_id%TYPE;
607:
608: --akomurav

Line 625: -- Use the igf_sl_gen.get_person_details for getting the student

621: --akomurav
622:
623: BEGIN
624:
625: -- Use the igf_sl_gen.get_person_details for getting the student
626: igf_sl_gen.get_person_details(igf_gr_gen.get_person_id(p_rfms_rec.base_id),student_dtl_cur);
627: FETCH student_dtl_cur INTO student_dtl_rec;
628:
629: CLOSE student_dtl_cur;

Line 626: igf_sl_gen.get_person_details(igf_gr_gen.get_person_id(p_rfms_rec.base_id),student_dtl_cur);

622:
623: BEGIN
624:
625: -- Use the igf_sl_gen.get_person_details for getting the student
626: igf_sl_gen.get_person_details(igf_gr_gen.get_person_id(p_rfms_rec.base_id),student_dtl_cur);
627: FETCH student_dtl_cur INTO student_dtl_rec;
628:
629: CLOSE student_dtl_cur;
630:

Line 944: student_dtl_cur igf_sl_gen.person_dtl_cur;

940: FROM igf_aw_db_chg_dtls chg
941: WHERE award_id = cp_award_id
942: AND disb_status = 'G'; -- Ready to Send (introduced this predicate again bcz of bug #4390096)
943:
944: student_dtl_cur igf_sl_gen.person_dtl_cur;
945:
946: lv_last_name VARCHAR2(150);
947: lv_ssn VARCHAR2(30);
948: ld_dob DATE;

Line 973: -- Use the igf_sl_gen.get_person_details for getting the student

969: --akomurav
970:
971: BEGIN
972:
973: -- Use the igf_sl_gen.get_person_details for getting the student
974: igf_sl_gen.get_person_details(igf_gr_gen.get_person_id(p_rfms_rec.base_id),student_dtl_cur);
975: FETCH student_dtl_cur INTO student_dtl_rec;
976: CLOSE student_dtl_cur;
977:

Line 974: igf_sl_gen.get_person_details(igf_gr_gen.get_person_id(p_rfms_rec.base_id),student_dtl_cur);

970:
971: BEGIN
972:
973: -- Use the igf_sl_gen.get_person_details for getting the student
974: igf_sl_gen.get_person_details(igf_gr_gen.get_person_id(p_rfms_rec.base_id),student_dtl_cur);
975: FETCH student_dtl_cur INTO student_dtl_rec;
976: CLOSE student_dtl_cur;
977:
978: --akomurav

Line 1023: l_s_phone := igf_sl_gen.get_person_phone(igf_gr_gen.get_person_id(p_rfms_rec.base_id));

1019: CLOSE cur_get_chg_data;
1020: END IF;
1021: --akomurav
1022:
1023: l_s_phone := igf_sl_gen.get_person_phone(igf_gr_gen.get_person_id(p_rfms_rec.base_id));
1024:
1025: IF l_s_phone = 'N/A' then
1026: l_s_phone := NULL;
1027: END IF;