1 PACKAGE IGS_RE_VAL_THE AUTHID CURRENT_USER AS
2 /* $Header: IGSRE16S.pls 115.5 2002/11/29 10:55:21 pradhakr ship $ */
3 -------------------------------------------------------------------------------------------
4 --Change History:
5 --Who When What
6 --Nishikant 19NOV2002 Bug#2661533. The signature of the functions resp_val_the_expct, resp_val_the_embrg,
7 -- resp_val_the_thr got modified to add one more parameer p_legacy.
8 -- Three more functions get_candidacy_dtls, check_dup_thesis, eval_min_sub_dt are added.
9 --smadathi 25-AUG-2001 Bug No. 1956374 .The function declaration of GENP_VAL_SDTT_SESS
10 -- removed
11 -- pradhakr 29-Nov-2002 Added the hint NOCOPY to all the OUT parameters. Replaced all
12 -- the OUT parameter with OUT NOCOPY. Bug# 2683043
13 -------------------------------------------------------------------------------------------
14 -- To valdate IGS_RE_THESIS citation fiels
15 FUNCTION RESP_VAL_THE_CTN(
16 p_thesis_status IN VARCHAR2 ,
17 p_citation IN VARCHAR2 ,
18 p_message_name OUT NOCOPY VARCHAR2 )
19 RETURN BOOLEAN;
20
21 -- Validate IGS_RE_THESIS logical deletion date
22 FUNCTION RESP_VAL_THE_DEL_DT(
23 p_old_logical_delete_dt IN DATE ,
24 p_new_logical_delete_dt IN DATE ,
25 p_message_name OUT NOCOPY VARCHAR2 )
26 RETURN BOOLEAN;
27
28 -- To validate the IGS_RE_THESIS expected submission date
29 FUNCTION RESP_VAL_THE_EXPCT(
30 p_person_id IN NUMBER ,
31 p_ca_sequence_number IN NUMBER ,
32 p_expected_submission_dt IN DATE ,
33 p_legacy IN VARCHAR2 DEFAULT 'N',
34 p_message_name OUT NOCOPY VARCHAR2 )
35 RETURN BOOLEAN;
36
37 -- To validate IGS_RE_THESIS embargo details
38 FUNCTION RESP_VAL_THE_EMBRG(
39 p_embargo_details IN VARCHAR2 ,
40 p_old_embargo_expiry_dt IN DATE ,
41 p_new_embargo_expiry_dt IN DATE ,
42 p_thesis_status IN VARCHAR2 ,
43 p_legacy IN VARCHAR2 DEFAULT 'N',
44 p_message_name OUT NOCOPY VARCHAR2 )
45 RETURN BOOLEAN;
46
47 -- Validate IGS_RE_THESIS deletion (logical deletion)
48 FUNCTION RESP_VAL_THE_DEL(
49 p_person_id IN NUMBER ,
50 p_ca_sequence_number IN NUMBER ,
51 p_sequence_number IN NUMBER ,
52 p_logical_delete_dt IN DATE ,
53 p_thesis_status IN VARCHAR2 ,
54 p_message_name OUT NOCOPY VARCHAR2 )
55 RETURN BOOLEAN;
56
57 -- To validate IGS_RE_THESIS library details
58 FUNCTION RESP_VAL_THE_LBRY(
59 p_person_id IN NUMBER ,
60 p_ca_sequence_number IN NUMBER ,
61 p_sequence_number IN NUMBER ,
62 p_library_catalogue_number IN VARCHAR2 ,
63 p_library_lodgement_dt IN DATE ,
64 p_thesis_status IN VARCHAR2 ,
65 p_message_name OUT NOCOPY VARCHAR2 )
66 RETURN BOOLEAN;
67
68 -- To validate the IGS_RE_THESIS result code
69 FUNCTION RESP_VAL_THE_THR(
70 p_person_id IN NUMBER ,
71 p_ca_sequence_number IN NUMBER ,
72 p_sequence_number IN NUMBER ,
73 p_thesis_result_cd IN VARCHAR2 ,
74 p_thesis_status IN VARCHAR2 ,
75 p_legacy IN VARCHAR2 DEFAULT 'N',
76 p_message_name OUT NOCOPY VARCHAR2 )
77 RETURN BOOLEAN;
78
79 -- To validate the update of the IGS_RE_THESIS table.
80 FUNCTION RESP_VAL_THE_UPD(
81 p_logical_delete_dt IN DATE ,
82 p_message_name OUT NOCOPY VARCHAR2 )
83 RETURN BOOLEAN;
84
85 -- To validate the IGS_RE_THESIS IGS_PE_TITLE
86 FUNCTION RESP_VAL_THE_TTL(
87 p_old_title IN VARCHAR2 ,
88 p_new_title IN VARCHAR2 ,
89 p_thesis_result_cd IN VARCHAR2 ,
90 p_message_name OUT NOCOPY VARCHAR2 )
91 RETURN BOOLEAN;
92
93 -- To validate IGS_RE_THESIS finalised_title_indicator
94 FUNCTION RESP_VAL_THE_FNL(
95 p_person_id IN NUMBER ,
96 p_ca_sequence_number IN NUMBER ,
97 p_sequence_number IN NUMBER ,
98 p_final_title_ind IN VARCHAR2 ,
99 p_thesis_status IN VARCHAR2 ,
100 p_message_name OUT NOCOPY VARCHAR2 )
101 RETURN BOOLEAN;
102
103 FUNCTION get_candidacy_dtls (
104 p_person_id IN NUMBER ,
105 p_course_cd IN VARCHAR2 ,
106 p_ca_sequence_number OUT NOCOPY NUMBER )
107 RETURN BOOLEAN;
108
109 FUNCTION check_dup_thesis(
110 p_person_id IN NUMBER ,
111 p_title IN VARCHAR2 ,
112 p_ca_sequence_number IN NUMBER )
113 RETURN BOOLEAN;
114
115 FUNCTION eval_min_sub_dt (
116 p_expected_submission_date IN DATE,
117 p_ca_sequence_number IN NUMBER ,
118 p_person_id IN NUMBER )
119 RETURN BOOLEAN;
120
121 END IGS_RE_VAL_THE;