PACKAGE: APPS.IGS_PS_VAL_US

Source

1 PACKAGE IGS_PS_VAL_US AUTHID CURRENT_USER AS
2 /* $Header: IGSPS68S.pls 115.5 2002/11/29 03:09:58 nsidana ship $ */
3 
4   --sarakshi  14-nov-2002  bug#2649028,modified function crsp_val_ver_dt, added parameter p_lgcy_validator
5   -- Bug #1956374
6   -- As part of the bug# 1956374 removed the function crsp_val_ou_sys_sts
7   -- As part of the bug# 1956374 removed the function crsp_val_us_exists
8 
9   -- Validate the IGS_PS_UNIT set status closed indicator.
10   FUNCTION crsp_val_uss_closed(
11   p_unit_set_status IN VARCHAR2 ,
12   p_message_name OUT NOCOPY VARCHAR2 )
13 RETURN BOOLEAN;
14 
15   --
16   -- Validate the IGS_PS_UNIT set category closed indicator.
17   FUNCTION crsp_val_usc_closed(
18   p_unit_set_cat IN VARCHAR2 ,
19   p_message_name OUT NOCOPY VARCHAR2 )
20 RETURN BOOLEAN;
21 
22   --
23   -- Validate version dates for IGS_PS_COURSE and IGS_PS_UNIT versions.
24   FUNCTION crsp_val_ver_dt(
25   p_start_dt IN DATE ,
26   p_end_dt IN DATE ,
27   p_expiry_dt IN DATE ,
28   p_message_name OUT NOCOPY VARCHAR2 ,
29   p_lgcy_validator IN BOOLEAN DEFAULT FALSE)
30 RETURN BOOLEAN;
31 
32   --
33   -- Validate IGS_PS_UNIT set end date and IGS_PS_UNIT set status
34   FUNCTION crsp_val_us_end_sts(
35   p_end_dt IN DATE ,
36   p_unit_set_status IN VARCHAR2 ,
37   p_message_name OUT NOCOPY VARCHAR2 )
38 RETURN BOOLEAN;
39 
40   --
41   -- Validate IGS_PS_UNIT set end date and status when active students exist
42   FUNCTION crsp_val_us_enr(
43   p_unit_set_cd IN VARCHAR2 ,
44   p_version_number IN NUMBER ,
45   p_message_name OUT NOCOPY VARCHAR2 )
46 RETURN BOOLEAN;
47 
48   --
49   -- Validate IGS_PS_UNIT set status changes
50   FUNCTION crsp_val_us_status(
51   p_old_unit_set_status IN VARCHAR2 ,
52   p_new_unit_set_status IN VARCHAR2 ,
53   p_message_name OUT NOCOPY VARCHAR2 )
54 RETURN BOOLEAN;
55 
56   --
57   -- Validate IGS_PS_UNIT set expiry date and IGS_PS_UNIT set status
58   FUNCTION crsp_val_us_exp_sts(
59   p_unit_set_cd IN VARCHAR2 ,
60   p_version_number IN NUMBER ,
61   p_unit_set_status IN VARCHAR2 ,
62   p_expiry_dt IN DATE ,
63   p_message_name OUT NOCOPY VARCHAR2 )
64 RETURN BOOLEAN;
65 
66 
67   --
68   -- Validate IGS_PS_UNIT set status for ins/upd/del of IGS_PS_UNIT set details
69   FUNCTION crsp_val_iud_us_dtl2(
70   p_old_unit_set_status IN VARCHAR2 ,
71   p_new_unit_set_status IN VARCHAR2 ,
72   p_message_name OUT NOCOPY VARCHAR2 )
73 RETURN BOOLEAN;
74 
75 
76 
77   --
78   -- Validate IGS_PS_UNIT set category changes
79   FUNCTION crsp_val_us_category(
80   p_unit_set_status IN VARCHAR2 ,
81   p_old_unit_set_cat IN VARCHAR2 ,
82   p_new_unit_set_cat IN VARCHAR2 ,
83   p_message_name OUT NOCOPY VARCHAR2 )
84 RETURN BOOLEAN;
85 END IGS_PS_VAL_US;