[Home] [Help]
PACKAGE: APPS.IGS_GR_VAL_GAC
Source
1 PACKAGE IGS_GR_VAL_GAC AUTHID CURRENT_USER AS
2 /* $Header: IGSGR08S.pls 115.7 2002/11/29 00:41:03 nsidana ship $ */
3 -------------------------------------------------------------------------------------------
4 --Change History:
5 --Who When What
6 --smadathi 27-AUG-2001 Bug No. 1956374 .The function declaration of GRDP_VAL_ACUSG_CLOSE
7 -- removed .
8 --smadathi 27-AUG-2001 Bug No. 1956374 .The function declaration of grdp_val_awc_closed
9 -- removed .
10 -------------------------------------------------------------------------------------------
11 -- Validate graduand award ceremony insert.
12 FUNCTION grdp_val_gac_insert(
13 p_person_id IGS_GR_AWD_CRMN.person_id%TYPE ,
14 p_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE ,
15 p_message_name OUT NOCOPY VARCHAR2 )
16 RETURN BOOLEAN;
17 --
18 -- Validate inserting or updating a IGS_GR_GRADUAND IGS_PS_AWD ceremony.
19 FUNCTION grdp_val_gac_iu(
20 p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
21 p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
22 p_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE ,
23 p_message_name OUT NOCOPY VARCHAR2 )
24 RETURN BOOLEAN;
25 --
26 -- Validate inserting or updating a graduand award ceremony.
27 FUNCTION grdp_val_gac_rqrd(
28 p_award_course_cd IGS_GR_AWD_CRMN.award_course_cd%TYPE ,
29 p_award_crs_version_number IGS_GR_AWD_CRMN.award_crs_version_number%TYPE ,
30 p_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE ,
31 p_us_group_number IGS_GR_AWD_CRMN.us_group_number%TYPE ,
32 p_academic_dress_rqrd_ind VARCHAR2 DEFAULT 'N',
33 p_academic_gown_size VARCHAR2 ,
34 p_academic_hat_size VARCHAR2 ,
35 p_message_name OUT NOCOPY VARCHAR2 )
36 RETURN BOOLEAN;
37 --
38 -- Validate graduand seat number is unique for the person.
39 FUNCTION grdp_val_gac_seat(
40 p_person_id IGS_GR_AWD_CRMN.person_id%TYPE ,
41 p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
42 p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
43 p_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE ,
44 p_graduand_seat_number IGS_GR_AWD_CRMN.graduand_seat_number%TYPE ,
45 p_message_name OUT NOCOPY VARCHAR2 )
46 RETURN BOOLEAN;
47 --
48 -- Validate Graduand Student Unit Set Attempts.
49 FUNCTION grdp_val_gac_susa(
50 p_person_id IGS_GR_AWD_CRMN.person_id%TYPE ,
51 p_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE ,
52 p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
53 p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
54 p_course_cd IGS_PS_COURSE.course_cd%TYPE ,
55 p_graduand_status VARCHAR2 ,
56 p_ceremony_number IGS_GR_AWD_CRMN.ceremony_number%TYPE ,
57 p_award_course_cd IGS_GR_AWD_CRMN.award_course_cd%TYPE ,
58 p_award_crs_version_number IGS_GR_AWD_CRMN.award_crs_version_number%TYPE ,
59 p_award_cd IGS_GR_AWD_CRMN.award_cd%TYPE ,
60 p_us_group_number IGS_GR_AWD_CRMN.us_group_number%TYPE ,
61 p_message_name OUT NOCOPY VARCHAR2 )
62 RETURN BOOLEAN;
63 --
64 -- Validate Graduand Award Ceremony graduation calendar instance.
65 FUNCTION grdp_val_gac_grd_ci(
66 p_grd_cal_type IGS_GR_AWD_CRMN.grd_cal_type%TYPE ,
67 p_grd_ci_sequence_number IGS_GR_AWD_CRMN.grd_ci_sequence_number%TYPE ,
68 p_message_name OUT NOCOPY VARCHAR2 )
69 RETURN BOOLEAN;
70 --
71 -- Validate graduand award ceremony order in presentation is unique.
72 FUNCTION grdp_val_gac_order(
73 p_person_id IN NUMBER ,
74 p_grd_cal_type IN VARCHAR2 ,
75 p_grd_ci_sequence_number IN NUMBER ,
76 p_ceremony_number IN NUMBER ,
77 p_order_in_presentation IN NUMBER ,
78 p_message_name OUT NOCOPY VARCHAR2 )
79 RETURN BOOLEAN;
80 --
81 --
82 -- Validate a measurement code is not closed.
83 FUNCTION GRDP_VAL_MSR_CLOSED(
84 p_measurement_cd IGS_GE_MEASUREMENT.measurement_cd%TYPE ,
85 p_message_name OUT NOCOPY VARCHAR2 )
86 RETURN BOOLEAN;
87 END IGS_GR_VAL_GAC;