1 PACKAGE IGS_RE_VAL_RSUP AUTHID CURRENT_USER AS
2 /* $Header: IGSRE11S.pls 115.5 2002/11/29 03:29:23 nsidana ship $ */
3 -------------------------------------------------------------------------------------------
4 --Change History:
5 --Who When What
6 --smadathi 29-AUG-2001 Bug No. 1956374 .The Function genp_val_sdtt_sess removed
7 --smadathi 29-AUG-2001 Bug No. 1956374 .The Function genp_val_strt_end_dt removed
8 -- pradhakr 20-Nov-2002 Bug# 2661533. Created a new function to get the
9 -- organization start date for the given organisation unit code.
10 -- Added p_legacy paramter to some of the functions.
11 -------------------------------------------------------------------------------------------
12
13 /*
14 || Bug ID 1956374 - Removal of Duplicate Program Units from OSS.
15 || Removed program unit (RESP_VAL_CA_CHILDUPD) - from the spec and body. -- kdande
16 || Removed program unit (RESP_VAL_CA_TRG) - from the spec and body. -- kdande
17 */
18
19 -- Bug No 1956374 , Procedure admp_val_ca_comm is removed
20 -- Validate research supervisor principal at commencement.
21 FUNCTION resp_val_rsup_comm(
22 p_ca_person_id IN NUMBER ,
23 p_ca_sequence_number IN NUMBER ,
24 p_message_name OUT NOCOPY VARCHAR2 )
25 RETURN BOOLEAN;
26
27
28 -- Validate research supervisor percentage.
29 FUNCTION resp_val_rsup_perc(
30 p_ca_person_id IN NUMBER ,
31 p_ca_sequence_number IN NUMBER ,
32 p_sca_course_cd IN VARCHAR2 ,
33 p_acai_admission_appl_number IN NUMBER ,
34 p_acai_nominated_course_cd IN VARCHAR2 ,
35 p_acai_sequence_number IN NUMBER ,
36 p_val_supervision_perc_ind IN VARCHAR2 DEFAULT 'N',
37 p_val_funding_perc_ind IN VARCHAR2 DEFAULT 'N',
38 p_parent IN VARCHAR2 ,
39 p_supervision_start_dt OUT NOCOPY DATE ,
40 p_message_name OUT NOCOPY VARCHAR2 )
41 RETURN BOOLEAN;
42 PRAGMA RESTRICT_REFERENCES (RESP_VAL_RSUP_PERC, WNDS, WNPS);
43
44 -- Validate research supervisor IGS_PE_PERSON.
45 FUNCTION resp_val_rsup_person(
46 p_ca_person_id IN NUMBER ,
47 p_person_id IN NUMBER ,
48 p_legacy IN VARCHAR2 DEFAULT 'N',
49 p_message_name OUT NOCOPY VARCHAR2 )
50 RETURN BOOLEAN;
51
52 -- Validate research supervisor principal.
53 FUNCTION resp_val_rsup_princ(
54 p_ca_person_id IN NUMBER ,
55 p_ca_sequence_number IN NUMBER ,
56 p_start_dt IN DATE ,
57 p_end_dt IN DATE ,
58 p_parent IN VARCHAR2 ,
59 p_message_name OUT NOCOPY VARCHAR2 )
60 RETURN BOOLEAN;
61 PRAGMA RESTRICT_REFERENCES (RESP_VAL_RSUP_PRINC, WNDS, WNPS);
62 --
63 -- Validate research supervisor replaced supervisor.
64 FUNCTION resp_val_rsup_repl(
65 p_ca_person_id IN NUMBER ,
66 p_ca_sequence_number IN NUMBER ,
67 p_person_id IN NUMBER ,
68 p_start_dt IN DATE ,
69 p_replaced_person_id IN NUMBER ,
70 p_replaced_sequence_number IN NUMBER ,
71 p_legacy IN VARCHAR2 DEFAULT 'N',
72 p_message_name OUT NOCOPY VARCHAR2 )
73 RETURN BOOLEAN;
74
75 -- Validate research supervisor funding percentage.
76 FUNCTION resp_val_rsup_fund(
77 p_person_id IN NUMBER ,
78 p_org_unit_cd IN VARCHAR2 ,
79 p_ou_start_dt IN DATE ,
80 p_funding_percentage IN NUMBER ,
81 p_staff_member_ind IN VARCHAR2 DEFAULT 'N',
82 p_legacy IN VARCHAR2 DEFAULT 'N',
83 p_message_name OUT NOCOPY VARCHAR2 )
84 RETURN BOOLEAN;
85
86 -- Validate research supervisor organisational IGS_PS_UNIT.
87 FUNCTION resp_val_rsup_ou(
88 p_person_id IN NUMBER ,
89 p_org_unit_cd IN VARCHAR2 ,
90 p_ou_start_dt IN DATE ,
91 p_staff_member_ind IN VARCHAR2 DEFAULT 'N',
92 p_legacy IN VARCHAR2 DEFAULT 'N',
93 p_message_name OUT NOCOPY VARCHAR2 )
94 RETURN BOOLEAN;
95
96 -- Validate research supervisor overlaps.
97 FUNCTION resp_val_rsup_ovrlp(
98 p_ca_person_id IN NUMBER ,
99 p_ca_sequence_number IN NUMBER ,
100 p_person_id IN NUMBER ,
101 p_sequence_number IN NUMBER ,
102 p_start_dt IN DATE ,
103 p_end_dt IN DATE ,
104 p_legacy IN VARCHAR2 DEFAULT 'N',
105 p_message_name OUT NOCOPY VARCHAR2 )
106 RETURN BOOLEAN;
107
108
109
110 -- Validate research supervisor end date.
111 FUNCTION resp_val_rsup_end_dt(
112 p_ca_person_id IN NUMBER ,
113 p_ca_sequence_number IN NUMBER ,
114 p_person_id IN NUMBER ,
115 p_sequence_number NUMBER ,
116 p_start_dt IN DATE ,
117 p_end_dt IN DATE ,
118 p_legacy IN VARCHAR2 DEFAULT 'N',
119 p_message_name OUT NOCOPY VARCHAR2 )
120 RETURN BOOLEAN;
121
122 -- Validate if Research Supervisor Type is closed.
123 FUNCTION resp_val_rst_closed(
124 p_research_supervisor_type IN VARCHAR2 ,
125 p_message_name OUT NOCOPY VARCHAR2 )
126 RETURN BOOLEAN;
127
128 -- Function to get the Start Date of the Organisation Unit.
129 FUNCTION get_org_unit_dtls (
130 p_org_unit_cd IN VARCHAR2,
131 p_start_dt OUT NOCOPY DATE
132 ) RETURN BOOLEAN;
133
134
135 END IGS_RE_VAL_RSUP;