[Home] [Help]
PACKAGE: APPS.IGS_AD_GEN_008
Source
1 PACKAGE IGS_AD_GEN_008 AUTHID CURRENT_USER AS
2 /* $Header: IGSAD08S.pls 115.6 2002/11/28 21:24:09 nsidana ship $ */
3
4 Function Admp_Get_Safs(
5 p_adm_fee_status IN VARCHAR2 )
6 RETURN VARCHAR2;
7
8 Function Admp_Get_Saods(
9 p_adm_offer_dfrmnt_status IN VARCHAR2 )
10 RETURN VARCHAR2;
11
12 Function Admp_Get_Saors(
13 p_adm_offer_resp_status IN VARCHAR2 )
14 RETURN VARCHAR2;
15
16 Function Admp_Get_Saos(
17 p_adm_outcome_status IN VARCHAR2 )
18 RETURN VARCHAR2;
19 PRAGMA RESTRICT_REFERENCES (Admp_Get_Saos,WNDS,WNPS);
20
21 Function Admp_Get_Sauos(
22 p_adm_unit_outcome_status IN VARCHAR2 )
23 RETURN VARCHAR2;
24
25 Function Admp_Get_Short_Dt(
26 p_adm_cal_type IN VARCHAR2 ,
27 p_adm_ci_sequence_number IN NUMBER )
28 RETURN DATE;
29
30 Function Admp_Get_Status_Rule(
31 p_person_id IN NUMBER ,
32 p_correspondence_type IN VARCHAR2 ,
33 p_admission_appl_number NUMBER ,
34 p_nominated_course_cd IN VARCHAR2 ,
35 p_acai_sequence_number IN NUMBER ,
36 p_s_letter_parameter_type IN VARCHAR2 )
37 RETURN VARCHAR2;
38
39 Function Admp_Get_Sys_Aas(
40 p_s_adm_appl_status IN VARCHAR2 )
41 RETURN VARCHAR2;
42
43 PROCEDURE get_acad_cal (
44 p_adm_cal_type IN OUT NOCOPY igs_ca_type.cal_type%TYPE,
45 p_adm_seq IN OUT NOCOPY igs_ca_inst.sequence_number%TYPE,
46 p_acad_cal_type OUT NOCOPY igs_ca_type.cal_type%TYPE,
47 p_acad_seq OUT NOCOPY igs_ca_inst.sequence_number%TYPE,
48 p_adm_alternate_code OUT NOCOPY igs_ca_inst.alternate_code%TYPE,
49 p_message OUT NOCOPY VARCHAR2
50 );
51 END IGS_AD_GEN_008;