APPS.IGW_PROP_PERSON_DEGREES_PVT dependencies on IGW_PERSON_DEGREES

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 203: degrees igw_person_degrees%rowtype;

199: x_return_status out NOCOPY varchar2,
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,

Line 214: from igw_person_degrees

210: last_updated_by,
211: creation_date,
212: created_by,
213: last_update_login
214: from igw_person_degrees
215: where (party_id = p_party_id) AND
216: (person_degree_id not in
217: (select person_degree_id from igw_prop_person_degrees
218: where proposal_id = p_proposal_id));

Line 252: -- delete those degrees in igw_prop_person_degrees which are not in igw_person_degrees

248: -- initialize return status to success
249: x_return_status := fnd_api.g_ret_sts_success;
250:
251:
252: -- delete those degrees in igw_prop_person_degrees which are not in igw_person_degrees
253: -- for the proposal under consideration
254: delete from igw_prop_person_degrees
255: where (proposal_id = p_proposal_id) AND
256: person_degree_id not in

Line 257: (select person_degree_id from igw_person_degrees);

253: -- for the proposal under consideration
254: delete from igw_prop_person_degrees
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:

Line 267: -- insert those degrees not in igw_prop_person_degrees but in igw_person_degrees into

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:
270: open c;
271: fetch c into degrees.person_degree_id,