PACKAGE: APPS.IGS_EN_VAL_SCI

Source

1 PACKAGE IGS_EN_VAL_SCI  AS
2 /* $Header: IGSEN64S.pls 120.1 2005/09/08 16:31:42 appldev noship $ */
3   -------------------------------------------------------------------------------------------
4   --Change History:
5   --Who         When            What
6   --smadathi    28-AUG-2001     Bug No. 1956374 .The function declaration of genp_val_strt_end_dt
7   --                            removed .
8   -------------------------------------------------------------------------------------------
9  -- gt_empty_table t_sci_rowid;
10   --
11   --
12   --gt_rowid_table t_sci_rowid;
13   --
14   --
15   --gv_table_index BINARY_INTEGER;
16   --
17   -- To validate that SCI is possible with students UA's
18   FUNCTION ENRP_VAL_SCI_UA(
19   p_person_id IN NUMBER ,
20   p_course_cd IN VARCHAR2 ,
21   p_start_dt IN DATE ,
22   p_message_name OUT NOCOPY VARCHAR2)
23 RETURN boolean;
24 --PRAGMA RESTRICT_REFERENCES( ENRP_VAL_SCI_UA , WNDS);
25   --
26   -- Validate that intermission is allowed for the student course attempt
27   FUNCTION ENRP_VAL_SCI_ALWD(
28   p_person_id IN NUMBER ,
29   p_course_cd IN VARCHAR2 ,
30   p_message_name OUT NOCOPY VARCHAR2)
31 RETURN boolean;
32 --PRAGMA RESTRICT_REFERENCES(  ENRP_VAL_SCI_ALWD, WNDS);
33   --
34   -- Validate course version of student course intermission.
35   FUNCTION ENRP_VAL_SCI_CV_ALWD(
36   p_person_id IN NUMBER ,
37   p_course_cd IN VARCHAR2 ,
38   p_message_name OUT NOCOPY VARCHAR2)
39 RETURN boolean;
40 --PRAGMA RESTRICT_REFERENCES( ENRP_VAL_SCI_CV_ALWD , WNDS);
41 
42   --
43   -- Validate whether student course intermission deletion is allowed
44   FUNCTION ENRP_VAL_SCI_DEL(
45   p_start_dt IN DATE ,
46   p_message_name OUT NOCOPY VARCHAR2)
47 RETURN boolean;
48 --PRAGMA RESTRICT_REFERENCES(  ENRP_VAL_SCI_DEL, WNDS);
49   --
50   -- Validate student course intermission duration
51   FUNCTION ENRP_VAL_SCI_DRTN(
52   p_course_cd IN VARCHAR2 ,
53   p_version_number IN NUMBER ,
54   p_start_dt IN DATE ,
55   p_end_dt IN DATE ,
56   p_message_name OUT NOCOPY VARCHAR2)
57 RETURN boolean;
58 --PRAGMA RESTRICT_REFERENCES(  ENRP_VAL_SCI_DRTN, WNDS);
59   --
60   -- Validate for overlap of student course intermission records.
61   FUNCTION ENRP_VAL_SCI_OVRLP(
62   p_person_id IN NUMBER ,
63   p_course_cd IN VARCHAR2 ,
64   p_start_dt IN DATE ,
65   p_end_dt IN DATE ,
66   p_message_name OUT NOCOPY VARCHAR2)
67 RETURN boolean;
68 --PRAGMA RESTRICT_REFERENCES( ENRP_VAL_SCI_OVRLP , WNDS);
69 
70 END IGS_EN_VAL_SCI;