1 PACKAGE IGS_PS_VAL_CEPRC AUTHID CURRENT_USER AS
2 /* $Header: IGSPS18S.pls 115.5 2002/11/29 02:57:52 nsidana ship $ */
3 -- Bug #1956374
4 -- As part of the bug# 1956374 removed the function crsp_val_ref_cd_type
5 -- As a part of the bug#2146753 removed the function crsp_val_ceprc_uref
6
7 -- Validate unique combination of IGS_PS_UNIT set and IGS_PS_COURSE offerning option
8 FUNCTION crsp_val_ceprc_uniq(
9 p_coo_id IN NUMBER ,
10 p_reference_cd_type IN VARCHAR2 ,
11 p_sequence_number IN NUMBER ,
12 p_unit_set_cd IN VARCHAR2 ,
13 p_us_version_number IN NUMBER ,
14 p_message_name OUT NOCOPY VARCHAR2 )
15 RETURN BOOLEAN;
16
17 --
18 -- Validate crs entry point IGS_PS_UNIT set against crs offer option IGS_PS_UNIT set
19 FUNCTION crsp_val_ceprc_coous(
20 p_coo_id IN NUMBER ,
21 p_unit_set_cd IN VARCHAR2 ,
22 p_us_version_number IN NUMBER ,
23 p_message_name OUT NOCOPY VARCHAR2 )
24 RETURN VARCHAR2;
25 END IGS_PS_VAL_CEPRC;