APPS.IGW_PROP_PERSON_DEGREES_PVT dependencies on IGW_PERSON_BIOSKETCH

Line 191: -- igw_person_degrees table to the igw_prop_person_degrees table and from igw_person_biosketch table to

187: */
188:
189: -------------------------------------------------------------------------------------------------------------------
190: -- the following code transfers the degrees pertaining to the appropriate proposal and person from the
191: -- igw_person_degrees table to the igw_prop_person_degrees table and from igw_person_biosketch table to
192: -- the igw_prop_person_biosketch_table
193:
194: PROCEDURE POPULATE_BIO_TABLES (p_init_msg_list in varchar2 := FND_API.G_FALSE,
195: p_commit in varchar2 := FND_API.G_FALSE,

Line 204: bio igw_person_biosketch%rowtype;

200: x_msg_count out NOCOPY number,
201: x_msg_data out NOCOPY varchar2) is
202:
203: degrees igw_person_degrees%rowtype;
204: bio igw_person_biosketch%rowtype;
205:
206: cursor c is
207: select person_degree_id,
208: degree_sequence,

Line 229: from igw_person_biosketch

225: last_updated_by,
226: creation_date,
227: created_by,
228: last_update_login
229: from igw_person_biosketch
230: where (party_id = p_party_id) AND
231: (enable_flag = 'Y') AND
232: (person_biosketch_id not in
233: (select person_biosketch_id from igw_prop_person_biosketch

Line 259: -- delete those biosketches in igw_prop_person_biosketch which are not in igw_person_biosketch

255: where (proposal_id = p_proposal_id) AND
256: person_degree_id not in
257: (select person_degree_id from igw_person_degrees);
258:
259: -- delete those biosketches in igw_prop_person_biosketch which are not in igw_person_biosketch
260: -- for the proposal under consideration
261:
262: delete from igw_prop_person_biosketch
263: where (proposal_id = p_proposal_id) AND

Line 265: (select person_biosketch_id from igw_person_biosketch where enable_flag = 'Y');

261:
262: delete from igw_prop_person_biosketch
263: where (proposal_id = p_proposal_id) AND
264: person_biosketch_id not in
265: (select person_biosketch_id from igw_person_biosketch where enable_flag = 'Y');
266:
267: -- insert those degrees not in igw_prop_person_degrees but in igw_person_degrees into
268: -- the table igw_prop_person_degrees for the proposal and person under consideration
269:

Line 315: -- insert those biosketches not in igw_prop_person_biosketch but in igw_person_biosketch into

311:
312: end loop;
313: close c;
314:
315: -- insert those biosketches not in igw_prop_person_biosketch but in igw_person_biosketch into
316: -- the table igw_prop_person_biosketch for the proposal and person under consideration
317:
318: open d;
319: fetch d into bio.person_biosketch_id,