1 PACKAGE IGW_PROP_PERSON_SUPPORT_PVT AUTHID CURRENT_USER as
2 /* $Header: igwvppss.pls 115.6 2002/11/15 00:42:55 ashkumar ship $ */
3 PROCEDURE create_prop_person_support (
4 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
5 p_commit IN VARCHAR2 := FND_API.G_FALSE,
6 p_validate_only IN VARCHAR2 := FND_API.G_FALSE,
7 p_get_data IN VARCHAR2,
8 x_rowid out NOCOPY VARCHAR2,
9 X_PROP_PERSON_SUPPORT_ID OUT NOCOPY NUMBER,
10 P_PROPOSAL_ID IN NUMBER,
11 P_PERSON_ID IN NUMBER,
12 P_PARTY_ID IN NUMBER,
13 P_SUPPORT_TYPE IN VARCHAR2,
14 P_PROPOSAL_AWARD_ID IN NUMBER,
15 P_PROPOSAL_AWARD_NUMBER IN VARCHAR2,
16 P_PROPOSAL_AWARD_TITLE IN VARCHAR2,
17 P_PI_PERSON_ID IN NUMBER,
18 P_PI_PARTY_ID IN NUMBER,
19 P_PI_PERSON_NAME IN VARCHAR2,
20 P_SPONSOR_ID IN NUMBER,
21 P_SPONSOR_NAME IN VARCHAR2,
22 P_PROJECT_LOCATION IN VARCHAR2,
23 P_LOCATION_PARTY_ID IN NUMBER,
24 P_PROJECT_LOCATION_NAME IN VARCHAR2,
25 P_START_DATE IN DATE,
26 P_END_DATE IN DATE,
27 P_PERCENT_EFFORT IN NUMBER,
28 P_MAJOR_GOALS IN VARCHAR2,
29 P_OVERLAP IN VARCHAR2,
30 P_ANNUAL_DIRECT_COST IN NUMBER,
31 P_TOTAL_COST IN NUMBER,
32 P_CALENDAR_START_DATE IN DATE,
33 P_CALENDAR_END_DATE IN DATE,
34 P_ACADEMIC_START_DATE IN DATE,
35 P_ACADEMIC_END_DATE IN DATE,
36 P_SUMMER_START_DATE IN DATE,
37 P_SUMMER_END_DATE IN DATE,
38 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
39 P_ATTRIBUTE1 IN VARCHAR2,
40 P_ATTRIBUTE2 IN VARCHAR2,
41 P_ATTRIBUTE3 IN VARCHAR2,
42 P_ATTRIBUTE4 IN VARCHAR2,
43 P_ATTRIBUTE5 IN VARCHAR2,
44 P_ATTRIBUTE6 IN VARCHAR2,
45 P_ATTRIBUTE7 IN VARCHAR2,
46 P_ATTRIBUTE8 IN VARCHAR2,
47 P_ATTRIBUTE9 IN VARCHAR2,
48 P_ATTRIBUTE10 IN VARCHAR2,
49 P_ATTRIBUTE11 IN VARCHAR2,
50 P_ATTRIBUTE12 IN VARCHAR2,
51 P_ATTRIBUTE13 IN VARCHAR2,
52 P_ATTRIBUTE14 IN VARCHAR2,
53 P_ATTRIBUTE15 IN VARCHAR2,
54 P_SEQUENCE_NUMBER IN NUMBER,
55 x_return_status OUT NOCOPY VARCHAR2,
56 x_msg_count OUT NOCOPY NUMBER,
57 x_msg_data OUT NOCOPY VARCHAR2);
58 --------------------------------------------------------------------------------------------------------------
59
60 Procedure update_prop_person_support (
61 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
62 p_commit IN VARCHAR2 := FND_API.G_FALSE,
63 p_validate_only IN VARCHAR2 := FND_API.G_FALSE,
64 p_get_data IN VARCHAR2,
65 x_rowid IN VARCHAR2,
66 P_PROP_PERSON_SUPPORT_ID IN NUMBER,
67 P_PROPOSAL_ID IN NUMBER,
68 P_PERSON_ID IN NUMBER,
69 P_PARTY_ID IN NUMBER,
70 P_SUPPORT_TYPE IN VARCHAR2,
71 P_PROPOSAL_AWARD_ID IN NUMBER,
72 P_PROPOSAL_AWARD_NUMBER IN VARCHAR2,
73 P_PROPOSAL_AWARD_TITLE IN VARCHAR2,
74 P_PI_PERSON_ID IN NUMBER,
75 P_PI_PARTY_ID IN NUMBER,
76 P_PI_PERSON_NAME IN VARCHAR2,
77 P_SPONSOR_ID IN NUMBER,
78 P_SPONSOR_NAME IN VARCHAR2,
79 P_PROJECT_LOCATION IN VARCHAR2,
80 P_LOCATION_PARTY_ID IN NUMBER,
81 P_PROJECT_LOCATION_NAME IN VARCHAR2,
82 P_START_DATE IN DATE,
83 P_END_DATE IN DATE,
84 P_PERCENT_EFFORT IN NUMBER,
85 P_MAJOR_GOALS IN VARCHAR2,
86 P_OVERLAP IN VARCHAR2,
87 P_ANNUAL_DIRECT_COST IN NUMBER,
88 P_TOTAL_COST IN NUMBER,
89 P_CALENDAR_START_DATE IN DATE,
90 P_CALENDAR_END_DATE IN DATE,
91 P_ACADEMIC_START_DATE IN DATE,
92 P_ACADEMIC_END_DATE IN DATE,
93 P_SUMMER_START_DATE IN DATE,
94 P_SUMMER_END_DATE IN DATE,
95 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
96 P_ATTRIBUTE1 IN VARCHAR2,
97 P_ATTRIBUTE2 IN VARCHAR2,
98 P_ATTRIBUTE3 IN VARCHAR2,
99 P_ATTRIBUTE4 IN VARCHAR2,
100 P_ATTRIBUTE5 IN VARCHAR2,
101 P_ATTRIBUTE6 IN VARCHAR2,
102 P_ATTRIBUTE7 IN VARCHAR2,
103 P_ATTRIBUTE8 IN VARCHAR2,
104 P_ATTRIBUTE9 IN VARCHAR2,
105 P_ATTRIBUTE10 IN VARCHAR2,
106 P_ATTRIBUTE11 IN VARCHAR2,
107 P_ATTRIBUTE12 IN VARCHAR2,
108 P_ATTRIBUTE13 IN VARCHAR2,
109 P_ATTRIBUTE14 IN VARCHAR2,
110 P_ATTRIBUTE15 IN VARCHAR2,
111 p_record_version_number IN NUMBER,
112 P_SEQUENCE_NUMBER IN NUMBER,
113 x_return_status OUT NOCOPY VARCHAR2,
114 x_msg_count OUT NOCOPY NUMBER,
115 x_msg_data OUT NOCOPY VARCHAR2);
116 --------------------------------------------------------------------------------------------------------
117
118 Procedure delete_prop_person_support (
119 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
120 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
121 ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
122 ,x_rowid IN VARCHAR2
123 ,p_record_version_number IN NUMBER
124 ,x_return_status OUT NOCOPY VARCHAR2
125 ,x_msg_count OUT NOCOPY NUMBER
126 ,x_msg_data OUT NOCOPY VARCHAR2);
127
128 ------------------------------------------------------------------------------------------
129
130 PROCEDURE CHECK_LOCK
131 (x_rowid IN VARCHAR2
132 ,p_record_version_number IN NUMBER
133 ,x_return_status OUT NOCOPY VARCHAR2);
134
135
136 -------------------------------------------------------------------------------------------------------
137 PROCEDURE CHECK_ERRORS;
138
139 -------------------------------------------------------------------------------------------------------
140 PROCEDURE POPULATE_OTHER_SUPPORT_TABLE (p_init_msg_list in varchar2 := FND_API.G_FALSE,
141 p_commit in varchar2 := FND_API.G_FALSE,
142 p_validate_only in varchar2 := FND_API.G_FALSE,
143 p_proposal_id in number,
144 p_person_id in number,
145 p_party_id in number,
146 x_return_status out NOCOPY varchar2,
147 x_msg_count out NOCOPY number,
148 x_msg_data out NOCOPY varchar2);
149
150 -------------------------------------------------------------------------------------------------------------
151 PROCEDURE POPULATE_PROP_AWARD_INFO (p_proposal_id in number,
152 p_person_id in number,
153 p_party_id in number,
154 p_support_type in varchar2,
155 p_proposal_award_number in varchar2,
156 x_proposal_award_id out NOCOPY number,
157 x_proposal_award_title out NOCOPY varchar2,
158 x_sponsor_id out NOCOPY number,
159 x_start_date out NOCOPY date,
160 x_end_date out NOCOPY date,
161 x_pi_person_id out NOCOPY number,
162 x_pi_party_id out NOCOPY number,
163 x_project_location out NOCOPY varchar2,
164 x_location_party_id out NOCOPY number,
165 x_annual_direct_cost out NOCOPY number,
166 x_total_cost out NOCOPY number,
167 x_major_goals out NOCOPY varchar2,
168 x_percent_effort out NOCOPY number,
169 x_return_status out NOCOPY varchar2);
170 ---------------------------------------------------------------------------------------------------------------
171 PROCEDURE Get_Award_Id
172 (
173 p_context_field IN VARCHAR2,
174 p_check_id_flag IN VARCHAR2,
175 p_award_number IN VARCHAR2,
176 p_award_id IN NUMBER,
177 x_award_id OUT NOCOPY NUMBER,
178 x_return_status OUT NOCOPY VARCHAR2
179 );
180
181 FUNCTION get_person_name
182 ( p_party_id number, p_person_id number )
183 RETURN varchar2;
184
185
186 END IGW_PROP_PERSON_SUPPORT_PVT;