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.

[Home] [Help]

APPS.IGF_SL_DL_GEN_XML dependencies on IGF_SL_GEN

Line 279: student_dtl_rec igf_sl_gen.person_dtl_rec,

275: END print_out_xml;
276:
277: PROCEDURE insert_lor_loc(p_loan_rec cur_pick_loans%ROWTYPE,
278: p_source_id VARCHAR2,
279: student_dtl_rec igf_sl_gen.person_dtl_rec,
280: parent_dtl_rec igf_sl_gen.person_dtl_rec,
281: p_isir_ssn VARCHAR2, p_isir_dob DATE,
282: p_isir_lname VARCHAR2, p_isir_dep VARCHAR2,
283: p_isir_tnum NUMBER, p_acad_begin DATE,

Line 280: parent_dtl_rec igf_sl_gen.person_dtl_rec,

276:
277: PROCEDURE insert_lor_loc(p_loan_rec cur_pick_loans%ROWTYPE,
278: p_source_id VARCHAR2,
279: student_dtl_rec igf_sl_gen.person_dtl_rec,
280: parent_dtl_rec igf_sl_gen.person_dtl_rec,
281: p_isir_ssn VARCHAR2, p_isir_dob DATE,
282: p_isir_lname VARCHAR2, p_isir_dep VARCHAR2,
283: p_isir_tnum NUMBER, p_acad_begin DATE,
284: p_acad_end DATE, p_s_phone VARCHAR2, p_p_phone VARCHAR2)

Line 790: student_dtl_cur igf_sl_gen.person_dtl_cur;

786: l_msg_name fnd_new_messages.message_name%TYPE;
787: l_aid NUMBER;
788: l_loan_tab igf_aw_packng_subfns.std_loan_tab := igf_aw_packng_subfns.std_loan_tab();
789:
790: student_dtl_cur igf_sl_gen.person_dtl_cur;
791: parent_dtl_cur igf_sl_gen.person_dtl_cur;
792: student_dtl_rec igf_sl_gen.person_dtl_rec;
793: parent_dtl_rec igf_sl_gen.person_dtl_rec;
794:

Line 791: parent_dtl_cur igf_sl_gen.person_dtl_cur;

787: l_aid NUMBER;
788: l_loan_tab igf_aw_packng_subfns.std_loan_tab := igf_aw_packng_subfns.std_loan_tab();
789:
790: student_dtl_cur igf_sl_gen.person_dtl_cur;
791: parent_dtl_cur igf_sl_gen.person_dtl_cur;
792: student_dtl_rec igf_sl_gen.person_dtl_rec;
793: parent_dtl_rec igf_sl_gen.person_dtl_rec;
794:
795: p_isir_ssn VARCHAR2(30);

Line 792: student_dtl_rec igf_sl_gen.person_dtl_rec;

788: l_loan_tab igf_aw_packng_subfns.std_loan_tab := igf_aw_packng_subfns.std_loan_tab();
789:
790: student_dtl_cur igf_sl_gen.person_dtl_cur;
791: parent_dtl_cur igf_sl_gen.person_dtl_cur;
792: student_dtl_rec igf_sl_gen.person_dtl_rec;
793: parent_dtl_rec igf_sl_gen.person_dtl_rec;
794:
795: p_isir_ssn VARCHAR2(30);
796: p_isir_dob DATE;

Line 793: parent_dtl_rec igf_sl_gen.person_dtl_rec;

789:
790: student_dtl_cur igf_sl_gen.person_dtl_cur;
791: parent_dtl_cur igf_sl_gen.person_dtl_cur;
792: student_dtl_rec igf_sl_gen.person_dtl_rec;
793: parent_dtl_rec igf_sl_gen.person_dtl_rec;
794:
795: p_isir_ssn VARCHAR2(30);
796: p_isir_dob DATE;
797: p_isir_lname VARCHAR2(100);

Line 870: igf_sl_gen.get_person_details(igf_gr_gen.get_person_id(p_loan_rec.base_id),student_dtl_cur);

866: END IF ;
867: END IF;
868: END IF;
869:
870: igf_sl_gen.get_person_details(igf_gr_gen.get_person_id(p_loan_rec.base_id),student_dtl_cur);
871: FETCH student_dtl_cur INTO student_dtl_rec;
872: CLOSE student_dtl_cur;
873:
874: IF p_loan_rec.fed_fund_code = 'DLP' THEN

Line 875: igf_sl_gen.get_person_details(p_loan_rec.p_person_id,parent_dtl_cur);

871: FETCH student_dtl_cur INTO student_dtl_rec;
872: CLOSE student_dtl_cur;
873:
874: IF p_loan_rec.fed_fund_code = 'DLP' THEN
875: igf_sl_gen.get_person_details(p_loan_rec.p_person_id,parent_dtl_cur);
876: FETCH parent_dtl_cur INTO parent_dtl_rec;
877: CLOSE parent_dtl_cur;
878: END IF;
879:

Line 1042: l_event_name := 'oracle.apps.igf.sl.genxml';

1038: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.submit_xml_event','p_document id: '||p_document_id_txt);
1039: END IF;
1040:
1041: l_parameter_list := wf_parameter_list_t();
1042: l_event_name := 'oracle.apps.igf.sl.genxml';
1043: l_map_code := 'IGF_SL_DL_OUT';
1044: l_param_1 := p_document_id_txt;
1045:
1046:

Line 1712: gv_dl_version := igf_sl_gen.get_dl_version(lv_cal_type, ln_seq_number);

1708: END IF;
1709: --
1710: -- 3. Find Loans to be processed
1711: --
1712: gv_dl_version := igf_sl_gen.get_dl_version(lv_cal_type, ln_seq_number);
1713:
1714: lb_record_exist := FALSE;
1715:
1716: IF p_base_id IS NOT NULL THEN