1 PACKAGE IGS_GR_PRC_GAC AUTHID CURRENT_USER AS
2 /* $Header: IGSGR01S.pls 115.4 2002/11/29 00:39:26 nsidana ship $ */
3 --
4 -- Create graduand award ceremony records for graduands
5 FUNCTION grdp_ins_gac(
6 p_person_id IN NUMBER ,
7 p_create_dt IN DATE ,
8 p_grd_cal_type IN VARCHAR2 ,
9 p_grd_ci_sequence_number IN NUMBER ,
10 p_name_pronunciation IN VARCHAR2 ,
11 p_name_announced IN VARCHAR2 ,
12 p_academic_dress_rqrd_ind IN VARCHAR2 DEFAULT 'N',
13 p_academic_gown_size IN VARCHAR2 ,
14 p_academic_hat_size IN VARCHAR2 ,
15 p_guest_tickets_requested IN NUMBER ,
16 p_guest_tickets_allocated IN NUMBER ,
17 p_guest_seats IN VARCHAR2 ,
18 p_fees_paid_ind IN VARCHAR2 DEFAULT 'N',
19 p_special_requirements IN VARCHAR2 ,
20 p_resolve_stalemate_type IN VARCHAR2 ,
21 p_ignore_unit_sets_ind IN VARCHAR2 DEFAULT 'N',
22 p_message_name OUT NOCOPY VARCHAR2 )
23 RETURN BOOLEAN;
24
25 --
26 -- Process the close of a Award Ceremony Unit Set Group
27 FUNCTION grdp_prc_acusg_close(
28 p_grd_cal_type IN VARCHAR2 ,
29 p_grd_ci_sequence_number IN NUMBER ,
30 p_ceremony_number IN NUMBER ,
31 p_award_course_cd IN VARCHAR2 ,
32 p_award_crs_version_number IN NUMBER ,
33 p_award_cd IN VARCHAR2 ,
34 p_us_group_number IN NUMBER ,
35 p_resolve_stalemate_type IN VARCHAR2 ,
36 p_ignore_unit_sets_ind IN VARCHAR2 DEFAULT 'N',
37 p_message_name OUT NOCOPY VARCHAR2 )
38 RETURN BOOLEAN;
39
40 --
41 -- Process the close of a Award Ceremony
42 FUNCTION grdp_prc_awc_close(
43 p_grd_cal_type IN VARCHAR2 ,
44 p_grd_ci_sequence_number IN NUMBER ,
45 p_ceremony_number IN NUMBER ,
46 p_award_course_cd IN VARCHAR2 ,
47 p_award_crs_version_number IN NUMBER ,
48 p_award_cd IN VARCHAR2 ,
49 p_resolve_stalemate_type IN VARCHAR2 ,
50 p_ignore_unit_sets_ind IN VARCHAR2 DEFAULT 'N',
51 p_message_name OUT NOCOPY VARCHAR2 )
52 RETURN BOOLEAN;
53
54 END IGS_GR_PRC_GAC;