1 PACKAGE IGS_AD_GEN_012 AS
2 /* $Header: IGSAD12S.pls 120.0 2005/06/01 20:11:59 appldev noship $ */
3 /****************************************************************************
4 Created By :
5 Date Created On :
6 Purpose :
7
8 Change History
9 Who When What
10 sjlaport 18-FEB-2005 Removed function get_inq_stat_id for IGR Migration
11 rboddu 13-FEB-2003 removed PROCEDURE Admp_Upd_Eap_Avail. Moved this to
12 igs_rc_gen_001 package. Bug:2664699
13 (reverse chronological order - newest change first)
14 *****************************************************************************/
15
16 FUNCTION Admp_Upd_Acai_Comm(
17 p_person_id IN NUMBER ,
18 p_admission_appl_number IN NUMBER ,
19 p_nominated_course_cd IN VARCHAR2 ,
20 p_acai_sequence_number IN NUMBER ,
21 p_prpsd_commencement_dt IN DATE ,
22 p_message_name OUT NOCOPY VARCHAR2 )
23 RETURN BOOLEAN;
24
25 PROCEDURE Admp_Upd_Acai_Defer(
26 p_log_creation_dt OUT NOCOPY DATE );
27
28 PROCEDURE Admp_Upd_Acai_Lapsed(
29 errbuf OUT NOCOPY VARCHAR2,
30 retcode OUT NOCOPY NUMBER,
31 p_org_id IN NUMBER );
32
33 PROCEDURE Admp_Upd_Acai_Recon(
34 p_log_creation_dt OUT NOCOPY DATE );
35
36 PROCEDURE Admp_Upd_Adm_Pp(
37 p_oracle_username IN VARCHAR2 ,
38 p_adm_acad_cal_type IN VARCHAR2 ,
39 p_adm_acad_ci_sequence_number IN NUMBER ,
40 p_adm_adm_cal_type IN VARCHAR2 ,
41 p_adm_adm_ci_sequence_number IN NUMBER ,
42 p_adm_admission_cat IN VARCHAR2 ,
43 p_adm_s_admission_process_type IN VARCHAR2 );
44
45 PROCEDURE Admp_Upd_Enq_Pp(
46 p_oracle_username IN VARCHAR2 ,
47 p_enq_acad_cal_type IN VARCHAR2 ,
48 p_enq_acad_ci_sequence_number IN NUMBER ,
49 p_enq_adm_cal_type IN VARCHAR2 ,
50 p_enq_adm_ci_sequence_number IN NUMBER );
51
52 FUNCTION Adms_Get_Acaiu_Uv(
53 p_unit_cd IN VARCHAR2 ,
54 p_version_number IN NUMBER ,
55 p_s_admission_process_type IN VARCHAR2 ,
56 p_offer_ind IN VARCHAR2 DEFAULT 'N')
57 RETURN VARCHAR2;
58
59 FUNCTION ret_group_cd RETURN VARCHAR2;
60
61 --removed the function get_inq_stat_id for IGR migration (bug 2664699) sjlaport
62
63 END igs_ad_gen_012;