PACKAGE: APPS.IGS_PS_VAL_COUSR

Source

1 PACKAGE IGS_PS_VAL_COusr AUTHID CURRENT_USER AS
2 /* $Header: IGSPS29S.pls 115.3 2002/11/29 03:01:01 nsidana ship $ */
3 
4   -- Validate IGS_PS_UNIT set status for ins/upd/del of detail records
5   FUNCTION crsp_val_iud_us_dtl(
6   p_unit_set_cd IN VARCHAR2 ,
7   p_version_number IN NUMBER ,
8   p_message_name OUT NOCOPY VARCHAR2 )
9 RETURN BOOLEAN;
10   --
11   -- Validate COUSR hierarchy for duplicate ancestors/descendants
12   FUNCTION crsp_val_cousr_tree(
13   p_course_cd IN VARCHAR2 ,
14   p_crv_version_number IN NUMBER ,
15   p_cal_type IN VARCHAR2 ,
16   p_sup_unit_set_cd IN VARCHAR2 ,
17   p_sup_us_version_number IN NUMBER ,
18   p_sub_unit_set_cd IN VARCHAR2 ,
19   p_sub_us_version_number IN NUMBER ,
20   p_message_name OUT NOCOPY VARCHAR2 )
21 RETURN BOOLEAN;
22   --
23   -- Validate COUSR can only be created with US as superior if appropriate
24   FUNCTION crsp_val_cousr_sub(
25   p_course_cd IN VARCHAR2 ,
26   p_crv_version_number IN NUMBER ,
27   p_cal_type IN VARCHAR2 ,
28   p_sup_unit_set_cd IN VARCHAR2 ,
29   p_sup_us_version_number IN NUMBER ,
30   p_message_name OUT NOCOPY VARCHAR2 )
31 RETURN BOOLEAN;
32 
33   --
34   -- Validate COUSR can only be created as sub if CACUS rec does not exist
35   FUNCTION crsp_val_cousr_cacus(
36   p_course_cd IN VARCHAR2 ,
37   p_crv_version_number IN NUMBER ,
38   p_cal_type IN VARCHAR2 ,
39   p_sub_unit_set_cd IN VARCHAR2 ,
40   p_sub_us_version_number IN NUMBER ,
41   p_message_name OUT NOCOPY VARCHAR2 )
42 RETURN BOOLEAN;
43 
44 END IGS_PS_VAL_COusr;