1 PACKAGE IGS_PS_VAL_UOo AUTHID CURRENT_USER AS
2 /* $Header: IGSPS65S.pls 115.5 2002/11/29 03:09:43 nsidana ship $ */
3 -------------------------------------------------------------------------------------------
4 --Change History:
5 --Who When What
6 --smadathi 28-AUG-2001 Bug No. 1956374 .The function declaration of genp_val_staff_prsn removed
7
8 -------------------------------------------------------------------------------------------
9 -- Bug #1956374
10 -- As part of the bug# 1956374 added the pragma for the function crsp_val_loc_cd
11 -- Bug # 1956374 Procedure assp_val_gs_cur_fut is removed
12 -- Bug #1956374
13 -- As part of the bug# 1956374 removed the function crsp_val_uo_cal_type
14 --
15 --
16 -- Validate IGS_PS_COURSE IGS_AD_LOCATION code.
17 FUNCTION crsp_val_loc_cd(
18 p_location_cd IN VARCHAR2 ,
19 p_message_name OUT NOCOPY VARCHAR2 )
20 RETURN BOOLEAN;
21 pragma restrict_references(crsp_val_loc_cd,wnds);
22
23 --
24 -- Validate the IGS_PS_UNIT class for IGS_PS_UNIT offering option.
25 FUNCTION crsp_val_uoo_uc(
26 p_unit_class IN VARCHAR2 ,
27 p_message_name OUT NOCOPY VARCHAR2 )
28 RETURN BOOLEAN;
29
30
31 --
32 -- Validate the IGS_PS_UNIT contact for IGS_PS_UNIT offering option is a staff member.
33 FUNCTION crsp_val_uoo_contact(
34 p_person_id IN NUMBER ,
35 p_message_name OUT NOCOPY VARCHAR2 )
36 RETURN BOOLEAN;
37
38 --
39 -- Validate IGS_PS_UNIT Offering Option is active.
40 FUNCTION CRSP_VAL_UOO_INACTIV(
41 p_unit_cd IN VARCHAR2 ,
42 p_version_number IN NUMBER ,
43 p_cal_type IN VARCHAR2 ,
44 p_ci_sequence_number IN NUMBER ,
45 p_location_cd IN VARCHAR2 ,
46 p_unit_class IN VARCHAR2 ,
47 p_message_name OUT NOCOPY VARCHAR2 )
48 RETURN BOOLEAN;
49
50 --
51
52
53 END IGS_PS_VAL_UOo;