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.IGS_PE_CONFIG_PVT dependencies on IGS_PE_HZ_PARTIES

Line 15: Replaced column inst_priority_code_id with inst_priority_cd in igs_pe_hz_parties_pkg

11: Bug Desc :
12: Change History :
13: Who When What
14: pkpatel 25-OCT-2002 Bug No: 2613704
15: Replaced column inst_priority_code_id with inst_priority_cd in igs_pe_hz_parties_pkg
16: pkpatel 2-DEC-2002 Bug No: 2599109
17: Added column birth_city, birth_country in the call to TBH igs_pe_hz_parties_pkg
18: pkpatel 25-FEB-2003 Bug 2750800
19: Modified the Cursor cur_term_date in PROCEDURE verify_pe_info for performance tuning

Line 17: Added column birth_city, birth_country in the call to TBH igs_pe_hz_parties_pkg

13: Who When What
14: pkpatel 25-OCT-2002 Bug No: 2613704
15: Replaced column inst_priority_code_id with inst_priority_cd in igs_pe_hz_parties_pkg
16: pkpatel 2-DEC-2002 Bug No: 2599109
17: Added column birth_city, birth_country in the call to TBH igs_pe_hz_parties_pkg
18: pkpatel 25-FEB-2003 Bug 2750800
19: Modified the Cursor cur_term_date in PROCEDURE verify_pe_info for performance tuning
20: skpandey 04-JUN-2005 Bug : 4327807
21: The parameter FELONY_CONVICTED_FLAG is added in update_row procedure of igs_pe_hz_parties_pkg package.

Line 21: The parameter FELONY_CONVICTED_FLAG is added in update_row procedure of igs_pe_hz_parties_pkg package.

17: Added column birth_city, birth_country in the call to TBH igs_pe_hz_parties_pkg
18: pkpatel 25-FEB-2003 Bug 2750800
19: Modified the Cursor cur_term_date in PROCEDURE verify_pe_info for performance tuning
20: skpandey 04-JUN-2005 Bug : 4327807
21: The parameter FELONY_CONVICTED_FLAG is added in update_row procedure of igs_pe_hz_parties_pkg package.
22: mmkumar 18-JUL-2005 Party number impact, passed NULL for OSS_ORG_UNIT_CD in call to update_row of IGS_PE_HZ_PARTIES_PKG
23: **********************************************************************/
24:
25: g_pkg_name CONSTANT VARCHAR2(30) := 'PE_INFO';

Line 22: mmkumar 18-JUL-2005 Party number impact, passed NULL for OSS_ORG_UNIT_CD in call to update_row of IGS_PE_HZ_PARTIES_PKG

18: pkpatel 25-FEB-2003 Bug 2750800
19: Modified the Cursor cur_term_date in PROCEDURE verify_pe_info for performance tuning
20: skpandey 04-JUN-2005 Bug : 4327807
21: The parameter FELONY_CONVICTED_FLAG is added in update_row procedure of igs_pe_hz_parties_pkg package.
22: mmkumar 18-JUL-2005 Party number impact, passed NULL for OSS_ORG_UNIT_CD in call to update_row of IGS_PE_HZ_PARTIES_PKG
23: **********************************************************************/
24:
25: g_pkg_name CONSTANT VARCHAR2(30) := 'PE_INFO';
26:

Line 80: FROM IGS_PE_HZ_PARTIES

76:
77: --Cursor to fetch the Latest Verification date for the person
78: CURSOR cur_verify_time IS
79: SELECT pe_info_verify_time
80: FROM IGS_PE_HZ_PARTIES
81: WHERE party_id = p_person_id;
82:
83:
84: l_verify_mode fnd_profile_option_values.profile_option_value%TYPE;

Line 266: Replaced column inst_priority_code_id with inst_priority_cd in igs_pe_hz_parties_pkg

262: Who When What
263: ssawhney API standards implementation
264: ssawhney 22aug2002 Bug 2524217 : defaults removed in params, p_commit defaulted in spec.
265: pkpatel 25-OCT-2002 Bug No: 2613704
266: Replaced column inst_priority_code_id with inst_priority_cd in igs_pe_hz_parties_pkg
267: pkpatel 2-DEC-2002 Bug No: 2599109
268: Added column birth_city, birth_country in the call to TBH igs_pe_hz_parties_pkg
269:
270: **********************************************************************/

Line 268: Added column birth_city, birth_country in the call to TBH igs_pe_hz_parties_pkg

264: ssawhney 22aug2002 Bug 2524217 : defaults removed in params, p_commit defaulted in spec.
265: pkpatel 25-OCT-2002 Bug No: 2613704
266: Replaced column inst_priority_code_id with inst_priority_cd in igs_pe_hz_parties_pkg
267: pkpatel 2-DEC-2002 Bug No: 2599109
268: Added column birth_city, birth_country in the call to TBH igs_pe_hz_parties_pkg
269:
270: **********************************************************************/
271: AS
272:

Line 277: FROM igs_pe_hz_parties hz

273:
274: --Cursor to fetch the Person ID from HZ Parties to update the Latest Verification Date
275: CURSOR cur_get_person IS
276: SELECT rowid,hz.*
277: FROM igs_pe_hz_parties hz
278: WHERE hz.party_id =p_person_id
279: FOR UPDATE OF hz.party_id NOWAIT;
280:
281: l_cur_person cur_get_person%ROWTYPE;

Line 316: igs_pe_hz_parties_pkg.update_row(

312: FETCH cur_get_person INTO l_cur_person;
313: IF cur_get_person%FOUND THEN
314:
315:
316: igs_pe_hz_parties_pkg.update_row(
317: x_rowid =>l_cur_person.rowid,
318: x_party_id =>l_cur_person.party_id,
319: x_deceased_ind =>l_cur_person.deceased_ind,
320: x_archive_exclusion_ind =>l_cur_person.archive_exclusion_ind,