1 PACKAGE Igw_Utils AUTHID CURRENT_USER AS
2 --$Header: igwutils.pls 115.13 2002/11/15 00:52:17 ashkumar ship $
3
4 ---------------------------------------------------------------------------
5
6 /*
7 ** This API is used to find the PROPOSAL_ID for a given PROPOSAL_NUMBER
8 */
9
10 PROCEDURE Get_Proposal_Id
11 (
12 p_context_field IN VARCHAR2,
13 p_check_id_flag IN VARCHAR2,
14 p_proposal_number IN VARCHAR2,
15 p_proposal_id IN NUMBER,
16 x_proposal_id OUT NOCOPY NUMBER,
17 x_return_status OUT NOCOPY VARCHAR2
18 );
19
20 ---------------------------------------------------------------------------
21
22 /*
23 ** This API is used to find the PERSON_ID for a given FULL_NAME
24 */
25
26 PROCEDURE Get_Person_Id
27 (
28 p_context_field IN VARCHAR2,
29 p_check_id_flag IN VARCHAR2,
30 p_full_name IN VARCHAR2,
31 p_person_id IN NUMBER,
32 p_party_id IN NUMBER,
33 x_person_id OUT NOCOPY NUMBER,
34 x_party_id OUT NOCOPY NUMBER,
35 x_return_status OUT NOCOPY VARCHAR2
36 );
37
38 ---------------------------------------------------------------------------
39
40 /*
41 ** This API is used to find the USER_ID for a given USER_NAME
42 */
43
44 PROCEDURE Get_User_Id
45 (
46 p_check_id_flag IN VARCHAR2,
47 p_user_name IN VARCHAR2,
48 p_user_id IN NUMBER,
49 x_user_id OUT NOCOPY NUMBER,
50 x_return_status OUT NOCOPY VARCHAR2
51 );
52
53 ---------------------------------------------------------------------------
54
55 /*
56 ** This API is used to find the USER_ID for a given PERSON_FULL_NAME
57 */
58
59 PROCEDURE Get_Person_User_Id
60 (
61 p_context_field IN VARCHAR2,
62 p_check_id_flag IN VARCHAR2,
63 p_person_id IN NUMBER,
64 p_user_id IN NUMBER,
65 x_user_id OUT NOCOPY NUMBER,
66 x_return_status OUT NOCOPY VARCHAR2
67 );
68
69 ---------------------------------------------------------------------------
70
71 /*
72 ** This API is used to find the SPONSOR_ID for a given SPONSOR_NAME
73 */
74
75 PROCEDURE Get_Sponsor_Id
76 (
77 p_context_field IN VARCHAR2,
78 p_check_id_flag IN VARCHAR2,
79 p_sponsor_name IN VARCHAR2,
80 p_sponsor_id IN NUMBER,
81 x_sponsor_id OUT NOCOPY NUMBER,
82 x_return_status OUT NOCOPY VARCHAR2
83 );
84
85 ---------------------------------------------------------------------------
86
87 /*
88 ** This API is used to find the ORGANIZATION_ID for a given
89 ** ORGANIZATION_NAME
90 */
91
92 PROCEDURE Get_Organization_Id
93 (
94 p_context_field IN VARCHAR2,
95 p_check_id_flag IN VARCHAR2,
96 p_organization_name IN VARCHAR2,
97 p_organization_id IN NUMBER,
98 p_party_id IN NUMBER default null,
99 x_organization_id OUT NOCOPY NUMBER,
100 x_party_id OUT NOCOPY NUMBER,
101 x_return_status OUT NOCOPY VARCHAR2
102 );
103
104 ---------------------------------------------------------------------------
105
106 /*
107 ** This API is used to find the LOOKUP_CODE for a given LOOKUP_TYPE and
108 ** MEANING
109 */
110
111 PROCEDURE Get_Lookup_Code
112 (
113 p_context_field IN VARCHAR2,
114 p_check_id_flag IN VARCHAR2,
115 p_lookup_type IN VARCHAR2,
116 p_lookup_meaning IN VARCHAR2,
117 p_lookup_code IN VARCHAR2,
118 x_lookup_code OUT NOCOPY VARCHAR2,
119 x_return_status OUT NOCOPY VARCHAR2
120 );
121
122 ---------------------------------------------------------------------------
123
124 /*
125 ** This API is used to verify that the END_DATE is greater than the
126 ** START_DATE
127 */
128
129 PROCEDURE Check_Date_Validity
130 (
131 p_context_field IN VARCHAR2,
132 p_start_date IN DATE,
133 p_end_date IN DATE,
134 x_return_status OUT NOCOPY VARCHAR2
135 );
136
137 ---------------------------------------------------------------------------
138
139 /*
140 ** This API is used to provide information about the rights of a user on
141 ** a given proposal module
142 */
143
144 PROCEDURE Check_Rights
145 (
146 p_proposal_id IN NUMBER,
147 x_modify_general OUT NOCOPY VARCHAR2,
148 x_modify_budget OUT NOCOPY VARCHAR2,
149 x_modify_narrative OUT NOCOPY VARCHAR2,
150 x_modify_checklist OUT NOCOPY VARCHAR2,
151 x_modify_approval OUT NOCOPY VARCHAR2,
152 x_modify_sponsor_action OUT NOCOPY VARCHAR2,
153 x_modify_award OUT NOCOPY VARCHAR2,
154 x_return_status OUT NOCOPY VARCHAR2
155 );
156
157 ---------------------------------------------------------------------------
158
159 /*
160 ** This API is used to find the SCIENCE_CODE for a given DESCRIPTION
161 */
162
163 PROCEDURE Get_Science_Code
164 (
165 p_check_id_flag IN VARCHAR2,
166 p_description IN VARCHAR2,
167 p_science_code IN VARCHAR2,
168 x_science_code OUT NOCOPY VARCHAR2,
169 x_return_status OUT NOCOPY VARCHAR2
170 );
171
172 ---------------------------------------------------------------------------
173
174 /*
175 ** This API is used to send notifications to a set of persons
176 */
177
178 TYPE person_list_type IS TABLE of NUMBER
179 INDEX BY binary_integer;
180
181 PROCEDURE Send_Notification
182 (
183 p_event IN VARCHAR2,
184 p_proposal_id IN NUMBER,
185 p_person_list IN PERSON_LIST_TYPE,
186 x_return_status OUT NOCOPY VARCHAR2
187 );
188
189 ---------------------------------------------------------------------------
190
191 /*
192 ** This API is used to copy proposal
193 */
194
195
196 PROCEDURE Copy_Proposal
197 (
198 p_old_proposal_id IN NUMBER,
199 p_new_proposal_number IN VARCHAR2,
200 p_budget_copy_flag IN VARCHAR2 := 'N',
201 p_narrative_copy_flag IN VARCHAR2 := 'N',
202 p_proposal_owner_id IN NUMBER := Fnd_Global.User_Id,
203 x_new_proposal_id OUT NOCOPY NUMBER,
204 x_return_status OUT NOCOPY VARCHAR2,
205 x_msg_count OUT NOCOPY NUMBER,
206 x_msg_data OUT NOCOPY VARCHAR2
207 );
208
209 ---------------------------------------------------------------------------
210
211 END Igw_Utils;