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,
196: p_validate_only in varchar2 := FND_API.G_FALSE,
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
234: where proposal_id = p_proposal_id));
235:
236: BEGIN
237:
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
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
264: person_biosketch_id not in
265: (select person_biosketch_id from igw_person_biosketch where enable_flag = 'Y');
266:
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,
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,
320: bio.line_sequence,
324: bio.created_by,
325: bio.last_update_login;
326:
327: while d%found loop
328: insert into igw_prop_person_biosketch (
329: proposal_id,
330: person_biosketch_id,
331: line_sequence,
332: show_flag,