1 PACKAGE IGF_SP_CREATE_BASE_REC AUTHID CURRENT_USER AS
2 /* $Header: IGFSP01S.pls 115.2 2002/11/28 14:35:54 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 package deals with the creation of equivalent records of OSS in
10 -- Financial Aid system. The system is a pre-requisite for Assigning students
11 -- sponsor and also for sponsor award process.
12 -- It has the following procedure/function:
13 -- i) procedure create_base_record - this is the main procedure called
14 -- from the concurrent manager
15 -- ii) function create_fa_base_record - this is a function called from
16 -- create_base_record for actual creation of the base records
17 --
18 --Known limitations/enhancements and/or remarks:
19 --
20 --Change History:
21 --Who When What
22 -------------------------------------------------------------------------------------
23
24 PROCEDURE create_base_record
25 (errbuf OUT NOCOPY VARCHAR2,
26 retcode OUT NOCOPY NUMBER,
27 p_award_year IN VARCHAR2,
28 p_person_id IN igs_pe_person.person_id%TYPE,
29 p_person_group_id IN igs_pe_prsid_grp_mem.group_id%TYPE,
30 p_org_id IN NUMBER DEFAULT NULL);
31
32 FUNCTION create_fa_base_record
33 (p_cal_type IN igs_ca_inst.cal_type%TYPE,
34 p_sequence_number IN igs_ca_inst.sequence_number%TYPE,
35 p_person_id IN igs_pe_person.person_id%TYPE,
36 p_base_id OUT NOCOPY igf_ap_fa_base_rec.base_id%TYPE,
37 p_message OUT NOCOPY VARCHAR2)
38 RETURN BOOLEAN;
39
40 END IGF_SP_CREATE_BASE_REC;