1 package body IGW_GR_PERSONNEL as
2 /* $Header: igwgrpersonnelb.pls 120.3 2005/09/30 00:55:31 ashkumar ship $ */
3
4 -------------------------------------------- PERSONNEL GENERAL --------------------------------------
5
6 FUNCTION MIN_PERSONNEL_START_DATE (P_PROPOSAL_ID IN NUMBER,
7 P_PERSON_PARTY_ID IN NUMBER) RETURN DATE is
8
9 l_status varchar2(1);
10 l_min_start_date date;
11 BEGIN
12
13 return l_min_start_date;
14 EXCEPTION
15 when others then
16 return null;
17
18 END MIN_PERSONNEL_START_DATE;
19
20 --------------------------------------------------------------------------------------------------------------------------------
21 FUNCTION MAX_PERSONNEL_END_DATE (P_PROPOSAL_ID IN NUMBER,
22 P_PERSON_PARTY_ID IN NUMBER) RETURN DATE is
23 l_status varchar2(1);
24 l_max_end_date date;
25 BEGIN
26 return l_max_end_date;
27 EXCEPTION
28 when others then
29 return null;
30
31 END MAX_PERSONNEL_END_DATE;
32
33 -------------------------------------------------------------------------------------------------------
34 FUNCTION GET_SPONSOR_NAME(p_sponsor_id in number) return varchar2 is
35 o_sponsor_name varchar2(360);
36 BEGIN
37 return o_sponsor_name;
38
39 EXCEPTION
40 when others then
41 o_sponsor_name := null;
42 return o_sponsor_name;
43 END GET_SPONSOR_NAME;
44
45 ---------------------------------------------------------------------------------------
46 FUNCTION GET_PERSON_NAME(p_person_party_id in number) return varchar2 is
47 o_person_name varchar2(360);
48 BEGIN
49 return o_person_name;
50
51 EXCEPTION
52 when others then
53 o_person_name := null;
54 return o_person_name;
55
56 END GET_PERSON_NAME;
57
58 ---------------------------------------------------------------------------------------------------------
59 FUNCTION GET_MAJOR_GOALS (p_proposal_id NUMBER) RETURN VARCHAR2 is
60 o_major_goals varchar2(250);
61 Begin
62 RETURN o_major_goals;
63 EXCEPTION
64 when no_data_found then
65 o_major_goals := NULL;
66 RETURN o_major_goals;
67 END GET_MAJOR_GOALS;
68
69 -------------------------------------------------------------------------------------------------------------------
70 -- the following code transfers the degrees pertaining to the appropriate proposal and person from the
71 -- igw_person_degrees table to the igw_prop_person_degrees table and from igw_person_biosketch table to
72 -- the igw_prop_person_biosketch_table
73
74 PROCEDURE POPULATE_BIO_TABLES (p_init_msg_list in varchar2,
75 p_commit in varchar2,
76 p_validate_only in varchar2,
77 p_proposal_id in number,
78 p_party_id in number,
79 x_return_status out NOCOPY varchar2,
80 x_msg_count out NOCOPY number,
81 x_msg_data out NOCOPY varchar2) is
82
83
84 BEGIN
85
86 null;
87
88 END POPULATE_BIO_TABLES;
89
90 ------------------------------------------------------------
91 FUNCTION GET_FORMATTED_ADDRESS (P_PARTY_ID NUMBER) RETURN VARCHAR2 is
92 l_address1 hz_parties.address1%TYPE;
93 l_address2 hz_parties.address2%TYPE;
94 l_address3 hz_parties.address3%TYPE;
95 l_address4 hz_parties.address4%TYPE;
96 l_city hz_parties.city%TYPE;
97 l_state hz_parties.state%TYPE;
98 l_postal_code hz_parties.postal_code%TYPE;
99 l_address varchar2(1000) := null;
100
101 BEGIN
102
103 return l_address;
104 EXCEPTION
105 when others then
106 return null;
107
108 END GET_FORMATTED_ADDRESS;
109
110 PROCEDURE add_other_support_commitments (
111 p_init_msg_list IN VARCHAR2,
112 p_validate_only IN VARCHAR2,
113 p_commit IN VARCHAR2,
114 p_prop_person_support_id IN NUMBER,
115 p_proposal_id IN NUMBER,
116 p_person_party_id IN NUMBER,
117 x_return_status OUT NOCOPY VARCHAR2,
118 x_msg_count OUT NOCOPY NUMBER,
119 x_msg_data OUT NOCOPY VARCHAR2) IS
120
121
122 G_PKG_NAME VARCHAR2(100);
123 l_api_name VARCHAR2(100);
124
125 BEGIN
126 null;
127
128 END add_other_support_commitments;
129
130 PROCEDURE delete_personnel_related_data(
131 p_init_msg_list IN VARCHAR2,
132 p_commit IN VARCHAR2,
133 p_proposal_id IN NUMBER,
134 p_person_party_id IN NUMBER,
135 x_return_status OUT NOCOPY VARCHAR2,
136 x_msg_count OUT NOCOPY NUMBER,
137 x_msg_data OUT NOCOPY VARCHAR2) IS
138
139
140 G_PKG_NAME VARCHAR2(100);
141 l_api_name VARCHAR2(100);
142
143 l_success VARCHAR2(100);
144 l_errcode VARCHAR2(100);
145
146 BEGIN
147 null;
148
149 END delete_personnel_related_data;
150
151 END IGW_GR_PERSONNEL;