1 PACKAGE IGS_RE_VAL_TPM AS
2 /* $Header: IGSRE17S.pls 120.0 2005/06/01 13:53:58 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 removed
7 --msrinivi 25-Aug-2001 Bug No. 1956374. the func genp_val_pe_deceased removed
8 -------------------------------------------------------------------------------------------
9 -- To validate IGS_RE_THESIS panel member minimum panel size
10 FUNCTION RESP_VAL_TPM_MIN(
11 p_person_id IN NUMBER ,
12 p_ca_sequence_number IN NUMBER ,
13 p_the_sequence_number IN NUMBER ,
14 p_creation_dt IN DATE ,
15 p_thesis_panel_type IN VARCHAR2 ,
16 p_message_name OUT NOCOPY VARCHAR2 )
17 RETURN boolean;
18
19 -- To validate the IGS_RE_THESIS panel member chair indicator
20 FUNCTION RESP_VAL_TPM_CHAIR(
21 p_ca_person_id IN NUMBER ,
22 p_ca_sequence_number IN NUMBER ,
23 p_the_sequence_number IN NUMBER ,
24 p_creation_dt IN DATE ,
25 p_message_name OUT NOCOPY VARCHAR2 )
26 RETURN boolean;
27
28 -- To validate IGS_RE_THESIS panel member paid date
29 FUNCTION RESP_VAL_TPM_PAID(
30 p_paid_dt IN DATE ,
31 p_confirmed_dt IN DATE ,
32 p_message_name OUT NOCOPY VARCHAR2 )
33 RETURN boolean;
34
35 -- To validate the IGS_RE_THESIS panel member confirmed date
36 FUNCTION RESP_VAL_TPM_CNFRM(
37 p_confirmed_dt IN DATE ,
38 p_thesis_result_cd IN VARCHAR2 ,
39 p_paid_dt IN DATE ,
40 p_declined_dt IN DATE ,
41 p_message_name OUT NOCOPY VARCHAR2 )
42 RETURN boolean;
43
44 -- To validate IGS_RE_THESIS panel member declined date
45 FUNCTION RESP_VAL_TPM_DCLN(
46 p_declined_dt IN DATE ,
47 p_confirmed_dt IN DATE ,
48 p_message_name OUT NOCOPY VARCHAR2 )
49 RETURN boolean;
50
51 -- To validate the IGS_RE_THESIS panel member IGS_PE_PERSON ID
52 FUNCTION RESP_VAL_TPM_PE(
53 p_ca_person_id IN NUMBER ,
54 p_ca_sequence_number IN NUMBER ,
55 p_person_id IN NUMBER ,
56 p_message_name OUT NOCOPY VARCHAR2 )
57 RETURN boolean;
58
59 -- To validate the IGS_RE_THESIS panel member IGS_RE_THESIS result code
60 FUNCTION RESP_VAL_TPM_THR(
61 p_ca_person_id IN NUMBER ,
62 p_ca_sequence_number IN NUMBER ,
63 p_the_sequence_number IN NUMBER ,
64 p_creation_dt IN DATE ,
65 p_thesis_result_cd IN VARCHAR2 ,
66 p_recommendation_summary IN VARCHAR2 ,
67 p_confirmed_dt IN DATE ,
68 p_message_name OUT NOCOPY VARCHAR2 )
69 RETURN boolean;
70
71 -- To validate IGS_RE_THESIS panel member panel type
72 FUNCTION RESP_VAL_TPM_TPMT(
73 p_panel_member_type IN VARCHAR2 ,
74 p_message_name OUT NOCOPY VARCHAR2 )
75 RETURN boolean;
76
77 -- To validate IGS_RE_THESIS panel member updates
78 FUNCTION RESP_VAL_TPM_UPD(
79 p_ca_person_id IN NUMBER ,
80 p_ca_sequence_number IN NUMBER ,
81 p_the_sequence_number IN NUMBER ,
82 p_creation_dt IN DATE ,
83 p_transaction_type IN VARCHAR2 ,
84 p_old_thesis_result_cd IN VARCHAR2 ,
85 p_new_thesis_result_cd IN VARCHAR2 ,
86 p_old_panel_member_type IN VARCHAR2 ,
87 p_new_panel_member_type IN VARCHAR2 ,
88 p_old_confirmed_dt IN DATE ,
89 p_new_confirmed_dt IN DATE ,
90 p_message_name OUT NOCOPY VARCHAR2 )
91 RETURN boolean;
92
93 END IGS_RE_VAL_TPM;