1 PACKAGE IGS_RE_VAL_TEX AS
2 /* $Header: IGSRE15S.pls 120.0 2005/06/01 15:38:26 appldev noship $ */
3 -------------------------------------------------------------------------------------------
4 --Change History:
5 --Who When What
6 --Nishikant 19NOV2002 Bug#2661533. The signature of the functions resp_val_tex_sbmsn got modified to add
7 -- two more parameer p_legacy and p_final_title_ind.
8 --smadathi 25-AUG-2001 Bug No. 1956374 .The function declaration of GENP_VAL_SDTT_SESS
9 -- removed .
10 -------------------------------------------------------------------------------------------
11 -- Validate the deceased indicator for a IGS_PE_PERSON.
12 FUNCTION GENP_VAL_PE_DECEASED(
13 p_person_id IN NUMBER ,
14 p_message_type IN VARCHAR2 ,
15 p_message_name OUT NOCOPY VARCHAR2 )
16 RETURN BOOLEAN;
17
18 -- To validate IGS_RE_THESIS examination submission date
19 FUNCTION RESP_VAL_TEX_SBMSN(
20 p_person_id IN NUMBER,
21 p_ca_sequence_number IN NUMBER ,
22 p_the_sequence_number IN NUMBER ,
23 p_creation_dt IN DATE,
24 p_thesis_result_cd IN VARCHAR2 ,
25 p_submission_dt IN DATE,
26 p_legacy IN VARCHAR2 DEFAULT 'N',
27 p_final_title_ind IN VARCHAR2,
28 p_message_name OUT NOCOPY VARCHAR2 )
29 RETURN BOOLEAN;
30
31 -- To validate the IGS_RE_THESIS examination update
32 FUNCTION RESP_VAL_TEX_UPD(
33 p_person_id IN NUMBER ,
34 p_ca_sequence_number IN NUMBER ,
35 p_the_sequence_number IN NUMBER ,
36 p_transaction_type IN VARCHAR2 ,
37 p_submission_dt IN DATE ,
38 p_message_name OUT NOCOPY VARCHAR2 )
39 RETURN BOOLEAN;
40
41 -- To validate IGS_RE_THESIS examination type
42 FUNCTION RESP_VAL_TEX_TET(
43 p_thesis_exam_type IN VARCHAR2 ,
44 p_message_name OUT NOCOPY VARCHAR2 )
45 RETURN BOOLEAN;
46
47 -- To validate IGS_RE_THESIS examination result code
48 FUNCTION RESP_VAL_TEX_THR(
49 p_person_id IN NUMBER ,
50 p_ca_sequence_number IN NUMBER ,
51 p_the_sequence_number IN NUMBER ,
52 p_creation_dt IN DATE ,
53 p_submission_dt IN DATE ,
54 p_thesis_result_cd IN VARCHAR2 ,
55 p_thesis_panel_type IN VARCHAR2 ,
56 p_message_name OUT NOCOPY VARCHAR2 )
57 RETURN BOOLEAN;
58
59 -- To validate IGS_RE_THESIS_EXAM panel type
60 FUNCTION RESP_VAL_TEX_TPT(
61 p_thesis_panel_type IN VARCHAR2 ,
62 p_message_name OUT NOCOPY VARCHAR2 )
63 RETURN BOOLEAN;
64
65 END IGS_RE_VAL_TEX;