[Home] [Help]
PACKAGE: APPS.IGS_PS_VAL_CRFC
Source
1 PACKAGE IGS_PS_VAL_CRFC AUTHID CURRENT_USER AS
2 /* $Header: IGSPS32S.pls 115.3 2002/11/29 03:01:45 nsidana ship $ */
3
4 --
5 --
6 -- Validate the reference code type
7 FUNCTION crsp_val_ref_cd_type(
8 p_reference_cd_type IN VARCHAR2 ,
9 p_message_name OUT NOCOPY VARCHAR2 )
10 RETURN BOOLEAN;
11 --
12 -- Validate that only one open reference code type exists
13 FUNCTION crsp_val_crfc_rct(
14 p_course_cd IN IGS_PS_REF_CD.course_cd%TYPE ,
15 p_version_number IN IGS_PS_REF_CD.version_number%TYPE ,
16 p_reference_cd_type IN VARCHAR2 ,
17 p_reference_cd IN IGS_PS_REF_CD.reference_cd%TYPE ,
18 p_message_name OUT NOCOPY VARCHAR2 )
19 RETURN BOOLEAN;
20 --
21 END IGS_PS_VAL_CRFC;