1 PACKAGE IGS_RE_VAL_MIL AS
2 /* $Header: IGSRE09S.pls 120.0 2005/06/01 20:41:47 appldev noship $ */
3 -------------------------------------------------------------------------------------------
4 --Change History:
5 --Who When What
6 --smadathi 25-AUG-2001 Bug No. 1956374 .The function declaration of GENP_VAL_SDTT_SESS
7 -- removed .
8 -------------------------------------------------------------------------------------------
9 -- To validate the logical uniqueness of IGS_PR_MILESTONEs
10 FUNCTION RESP_VAL_MIL_UNIQ(
11 p_person_id IN NUMBER ,
12 p_ca_sequence_number IN NUMBER ,
13 p_message_name OUT NOCOPY VARCHAR2 )
14 RETURN boolean;
15
16 -- To validate the delete of IGS_PR_MILESTONE details
17 FUNCTION RESP_VAL_MIL_DEL(
18 p_person_id IN NUMBER ,
19 p_ca_sequence_number IN NUMBER ,
20 p_sequence_number IN NUMBER ,
21 p_milestone_status IN VARCHAR2 ,
22 p_message_name OUT NOCOPY VARCHAR2 )
23 RETURN boolean;
24
25 -- To validate IGS_PR_MILESTONE actual date reached
26 FUNCTION RESP_VAL_MIL_ACTUAL(
27 p_milestone_status IN VARCHAR2 ,
28 p_actual_reached_dt IN DATE ,
29 p_message_name OUT NOCOPY VARCHAR2 )
30 RETURN boolean;
31
32 -- To validate IGS_PR_MILESTONE notification days
33 FUNCTION RESP_VAL_MIL_DAYS(
34 p_milestone_type IN VARCHAR2 ,
35 p_milestone_status IN VARCHAR2 ,
36 p_due_dt IN DATE ,
37 p_old_imminent_days IN NUMBER ,
38 p_new_imminent_days IN NUMBER ,
39 p_old_reminder_days IN NUMBER ,
40 p_new_reminder_days IN NUMBER ,
41 p_old_re_reminder_days IN NUMBER ,
42 p_new_re_reminder_days IN NUMBER ,
43 p_message_name OUT NOCOPY VARCHAR2 )
44 RETURN boolean;
45
46 -- To validate IGS_PR_MILESTONE due date
47 FUNCTION RESP_VAL_MIL_DUE(
48 p_person_id IN NUMBER ,
49 p_ca_sequence_number IN NUMBER ,
50 p_sequence_number IN NUMBER ,
51 p_old_milestone_status IN VARCHAR2 ,
52 p_new_milestone_status IN VARCHAR2 ,
53 p_old_due_dt IN DATE ,
54 p_new_due_dt IN DATE ,
55 p_message_name OUT NOCOPY VARCHAR2 )
56 RETURN boolean;
57
58 -- To validate IGS_PR_MILESTONE status
59 FUNCTION RESP_VAL_MIL_MST(
60 p_person_id IN NUMBER ,
61 p_ca_sequence_number IN NUMBER ,
62 p_preced_sequence_number IN NUMBER ,
63 p_old_milestone_status IN VARCHAR2 ,
64 p_new_milestone_status IN VARCHAR2 ,
65 p_old_due_dt IN DATE ,
66 p_new_due_dt IN DATE ,
67 p_validation_level IN VARCHAR2 ,
68 p_message_name OUT NOCOPY VARCHAR2 )
69 RETURN boolean;
70
71 -- To validate IGS_PR_MILESTONE type
72 FUNCTION RESP_VAL_MIL_MTY(
73 p_milestone_type IN VARCHAR2 ,
74 p_message_name OUT NOCOPY VARCHAR2 )
75 RETURN boolean;
76
77 -- To validate IGS_PR_MILESTONE preceding sequence number
78 FUNCTION RESP_VAL_MIL_PRCD(
79 p_person_id IN NUMBER ,
80 p_ca_sequence_number IN NUMBER ,
81 p_sequence_number IN NUMBER ,
82 p_due_dt IN DATE ,
83 p_preced_sequence_number IN NUMBER ,
84 p_message_name OUT NOCOPY VARCHAR2 )
85 RETURN boolean;
86
87 END IGS_RE_VAL_MIL;