eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGW_PROP_PERSON_DEGREES_PVT dependencies on IGW_PROP_PERSON_DEGREES

Line 1: PACKAGE BODY IGW_PROP_PERSON_DEGREES_PVT as

1: PACKAGE BODY IGW_PROP_PERSON_DEGREES_PVT as
2: /* $Header: igwvppdb.pls 115.4 2002/11/15 00:41:41 ashkumar ship $*/
3:
4:
5: Procedure update_prop_person_degrees (

Line 64: igw_prop_person_degrees_tbh.update_row (

60:
61: -------------------------------------------- validations -----------------------------------------------------
62:
63: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then
64: igw_prop_person_degrees_tbh.update_row (
65: x_rowid => x_rowid
66: ,P_PROPOSAL_ID => P_PROPOSAL_ID
67: ,P_PERSON_DEGREE_ID => P_PERSON_DEGREE_ID
68: ,P_SHOW_FLAG => P_SHOW_FLAG

Line 108: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_PERSON_DEGREES_PVT',

104: END IF;
105:
106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
107:
108: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_PERSON_DEGREES_PVT',
109: p_procedure_name => 'UPDATE_PROP_PERSON_DEGREES',
110: p_error_text => SUBSTRB(SQLERRM,1,240));
111:
112: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 128: from igw_prop_person_degrees

124: l_proposal_id number;
125: BEGIN
126: select proposal_id
127: into l_proposal_id
128: from igw_prop_person_degrees
129: where rowid = x_rowid
130: and record_version_number = p_record_version_number;
131:
132: EXCEPTION

Line 142: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_PERSON_DEGREES_PVT',

138: raise fnd_api.g_exc_error;
139:
140: WHEN OTHERS THEN
141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
142: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_PERSON_DEGREES_PVT',
143: p_procedure_name => 'CHECK_LOCK',
144: p_error_text => SUBSTRB(SQLERRM,1,240));
145: raise fnd_api.g_exc_unexpected_error;
146:

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 217: (select person_degree_id from igw_prop_person_degrees

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));
219:
220:
221: cursor d is

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 254: delete from igw_prop_person_degrees

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
257: (select person_degree_id from igw_person_degrees);
258:

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,

Line 268: -- the table igw_prop_person_degrees for the proposal and person under consideration

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,
272: degrees.degree_sequence,

Line 280: insert into igw_prop_person_degrees (

276: degrees.created_by,
277: degrees.last_update_login;
278:
279: while c%found loop
280: insert into igw_prop_person_degrees (
281: proposal_id,
282: person_degree_id,
283: degree_sequence,
284: show_flag,

Line 382: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_PERSON_DEGREES_PVT',

378: END IF;
379:
380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
381:
382: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_PERSON_DEGREES_PVT',
383: p_procedure_name => 'POPULATE_BIO_TABLES',
384: p_error_text => SUBSTRB(SQLERRM,1,240));
385:
386: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 392: END IGW_PROP_PERSON_DEGREES_PVT;

388:
389: END POPULATE_BIO_TABLES;
390:
391:
392: END IGW_PROP_PERSON_DEGREES_PVT;