1 PACKAGE igf_sl_lar_creation AS
2 /* $Header: IGFSL01S.pls 120.0 2005/06/01 14:16:15 appldev noship $ */
3
4 /***************************************************************
5 Created By : mesriniv
6 Date Created By : 2000/11/13
7 Purpose : To Insert Loan Records into
8 IGF_SL_LOANS
9 Known Limitations,Enhancements or Remarks
10 Change History :
11 Bug ID : 1818617
12 Who When What
13 ------------------------------------------------------------------------
14 -- veramach July 2004 FA 151 HR Integration (bug 3709292)
15 -- Published get_loan_start_dt and get_loan_end_dt in the spec
16 ------------------------------------------------------------------------
17 -- rasahoo 02-Sep-2003 Replaced igf_ap_fa_base_h.class_standing%TYPE with
18 -- igs_pr_css_class_std_v.class_standing%TYPE and
19 -- igf_ap_fa_base_h.enrl_program_type%TYPE with igs_ps_ver_all.course_type%TYPE.
20 -- sjadhav 24-jul-2001 added parameter p_get_recent_info
21 --
22 ------------------------------------------------------------------------
23 ***************************************************************/
24
25 PROCEDURE get_dl_cl_std_code ( p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE ,
26 p_class_standing IN igs_pr_css_class_std_v.class_standing%TYPE ,
27 p_program_type IN igs_ps_ver_all.course_type%TYPE ,
28 p_dl_std_code OUT NOCOPY igf_ap_class_std_map.dl_std_code%TYPE ,
29 p_cl_std_code OUT NOCOPY igf_ap_class_std_map.cl_std_code%TYPE ) ;
30
31 PROCEDURE insert_loan_records(
32 ERRBUF OUT NOCOPY VARCHAR2,
33 RETCODE OUT NOCOPY NUMBER,
34 p_award_year IN VARCHAR2,
35 p_run_mode IN VARCHAR2,
36 p_fund_id IN NUMBER,
37 p_dummy_1 IN NUMBER,
38 p_base_id IN NUMBER,
39 p_dummy_2 IN NUMBER,
40 p_award_id IN NUMBER,
41 p_dummy_3 IN NUMBER,
42 p_dyn_pid_grp IN NUMBER ) ;
43
44 FUNCTION get_loan_start_dt ( p_award_id igf_aw_award_all.award_id%TYPE)
45 RETURN DATE;
46
47 FUNCTION get_loan_end_dt ( p_award_id igf_aw_award_all.award_id%TYPE)
48 RETURN DATE;
49
50 END igf_sl_lar_creation;