APPS.IGF_SL_DL_VALIDATION dependencies on IGF_SL_DL_GEN_XML

Line 879: FUNCTION cod_loan_validations ( p_loan_rec igf_sl_dl_gen_xml.cur_pick_loans%ROWTYPE,

875: app_exception.raise_exception;
876:
877: END dl_lar_validate;
878:
879: FUNCTION cod_loan_validations ( p_loan_rec igf_sl_dl_gen_xml.cur_pick_loans%ROWTYPE,
880: p_call_from VARCHAR2,
881: p_isir_ssn OUT NOCOPY VARCHAR2,
882: p_isir_dob OUT NOCOPY DATE,
883: p_isir_lname OUT NOCOPY VARCHAR2,

Line 1861: loan_rec igf_sl_dl_gen_xml.cur_pick_loans_all_status%ROWTYPE;

1857: p_fund_id NUMBER,
1858: p_loan_id NUMBER)
1859: RETURN BOOLEAN
1860: IS
1861: loan_rec igf_sl_dl_gen_xml.cur_pick_loans_all_status%ROWTYPE;
1862: p_isir_ssn VARCHAR2(30);
1863: p_isir_dob DATE;
1864: p_isir_lname VARCHAR2(100);
1865: p_isir_dep VARCHAR2(1);

Line 1873: OPEN igf_sl_dl_gen_xml.cur_pick_loans_all_status(p_cal_type, p_seq_number,

1869: p_s_phone VARCHAR2(30);
1870: p_p_phone VARCHAR2(30);
1871:
1872: BEGIN
1873: OPEN igf_sl_dl_gen_xml.cur_pick_loans_all_status(p_cal_type, p_seq_number,
1874: p_base_id,
1875: p_report_id,
1876: p_attend_id,
1877: p_fund_id,

Line 1879: FETCH igf_sl_dl_gen_xml.cur_pick_loans_all_status INTO loan_rec;

1875: p_report_id,
1876: p_attend_id,
1877: p_fund_id,
1878: p_loan_id);
1879: FETCH igf_sl_dl_gen_xml.cur_pick_loans_all_status INTO loan_rec;
1880: CLOSE igf_sl_dl_gen_xml.cur_pick_loans_all_status;
1881:
1882: loan_rec.grade_level_code := NVL(loan_rec.override_grade_level_code,loan_rec.grade_level_code);
1883:

Line 1880: CLOSE igf_sl_dl_gen_xml.cur_pick_loans_all_status;

1876: p_attend_id,
1877: p_fund_id,
1878: p_loan_id);
1879: FETCH igf_sl_dl_gen_xml.cur_pick_loans_all_status INTO loan_rec;
1880: CLOSE igf_sl_dl_gen_xml.cur_pick_loans_all_status;
1881:
1882: loan_rec.grade_level_code := NVL(loan_rec.override_grade_level_code,loan_rec.grade_level_code);
1883:
1884: RETURN cod_loan_validations(loan_rec,'FORM',p_isir_ssn,