1 PACKAGE IGF_SP_AWARD AUTHID CURRENT_USER AS
2 /* $Header: IGFSP03S.pls 115.1 2002/11/28 14:36:24 nsidana noship $ */
3
4 ------------------------------------------------------------------------------------
5 --Created by : smanglm ( Oracle IDC)
6 --Date created: 2002/01/11
7 --
8 --Purpose: Created as part of the build for DLD Sponsorship
9 -- This is a batch process that created both Award and disbursement
10 -- for a fund in FA system. Process will also check for the eligibility
11 -- and validations before awarding the Sponsor amount to the students.
12 -- Awarding money to the students can be done manually apart from awarding
13 -- money through a batch process.
14 --
15 --Known limitations/enhancements and/or remarks:
16 --
17 --Change History:
18 --Who When What
19 -------------------------------------------------------------------------------------
20
21 PROCEDURE create_award_disb
22 (errbuf OUT NOCOPY VARCHAR2,
23 retcode OUT NOCOPY NUMBER,
24 p_award_year IN VARCHAR2,
25 p_term_calendar IN VARCHAR2,
26 p_person_id IN igs_pe_person.person_id%TYPE,
27 p_person_group_id IN igs_pe_prsid_grp_mem.group_id%TYPE,
28 p_fund_id IN igf_sp_stdnt_rel.fund_id%TYPE,
29 p_award_type IN igf_aw_awd_disb.trans_type%TYPE,
30 p_test_mode IN VARCHAR2,
31 p_org_id IN NUMBER DEFAULT NULL);
32
33 END IGF_SP_AWARD;