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_USERID_PKG dependencies on HZ_PARTIES

Line 154: l_party_id hz_parties.party_id%TYPE;

150:
151: l_wf_name VARCHAR2(8) ;
152: l_process_name VARCHAR2(255) ;
153: l_item_key VARCHAR(255);
154: l_party_id hz_parties.party_id%TYPE;
155: --skpandey Bug#4937960, changed c_name cursor definition to optimize query
156: CURSOR c_name(cp_party_id hz_parties.party_id%TYPE) IS
157: SELECT upper(substr(person_last_name,1,12)||'.'||substr(person_first_name,1,14))
158: FROM hz_parties

Line 156: CURSOR c_name(cp_party_id hz_parties.party_id%TYPE) IS

152: l_process_name VARCHAR2(255) ;
153: l_item_key VARCHAR(255);
154: l_party_id hz_parties.party_id%TYPE;
155: --skpandey Bug#4937960, changed c_name cursor definition to optimize query
156: CURSOR c_name(cp_party_id hz_parties.party_id%TYPE) IS
157: SELECT upper(substr(person_last_name,1,12)||'.'||substr(person_first_name,1,14))
158: FROM hz_parties
159: WHERE party_id = cp_party_id;
160:

Line 158: FROM hz_parties

154: l_party_id hz_parties.party_id%TYPE;
155: --skpandey Bug#4937960, changed c_name cursor definition to optimize query
156: CURSOR c_name(cp_party_id hz_parties.party_id%TYPE) IS
157: SELECT upper(substr(person_last_name,1,12)||'.'||substr(person_first_name,1,14))
158: FROM hz_parties
159: WHERE party_id = cp_party_id;
160:
161: l_name VARCHAR2(30);
162: l_user_name FND_USER.USER_NAME%TYPE;

Line 163: l_person_number HZ_PARTIES.PARTY_NUMBER%TYPE;

159: WHERE party_id = cp_party_id;
160:
161: l_name VARCHAR2(30);
162: l_user_name FND_USER.USER_NAME%TYPE;
163: l_person_number HZ_PARTIES.PARTY_NUMBER%TYPE;
164: l_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
165: l_last_name HZ_PARTIES. PERSON_LAST_NAME%TYPE;
166: l_middle_name HZ_PARTIES. PERSON_MIDDLE_NAME%TYPE;
167: l_pref_name HZ_PARTIES.KNOWN_AS%TYPE;

Line 164: l_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;

160:
161: l_name VARCHAR2(30);
162: l_user_name FND_USER.USER_NAME%TYPE;
163: l_person_number HZ_PARTIES.PARTY_NUMBER%TYPE;
164: l_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
165: l_last_name HZ_PARTIES. PERSON_LAST_NAME%TYPE;
166: l_middle_name HZ_PARTIES. PERSON_MIDDLE_NAME%TYPE;
167: l_pref_name HZ_PARTIES.KNOWN_AS%TYPE;
168: l_pref_alt_id IGS_PE_ALT_PERS_ID.API_PERSON_ID%TYPE;

Line 165: l_last_name HZ_PARTIES. PERSON_LAST_NAME%TYPE;

161: l_name VARCHAR2(30);
162: l_user_name FND_USER.USER_NAME%TYPE;
163: l_person_number HZ_PARTIES.PARTY_NUMBER%TYPE;
164: l_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
165: l_last_name HZ_PARTIES. PERSON_LAST_NAME%TYPE;
166: l_middle_name HZ_PARTIES. PERSON_MIDDLE_NAME%TYPE;
167: l_pref_name HZ_PARTIES.KNOWN_AS%TYPE;
168: l_pref_alt_id IGS_PE_ALT_PERS_ID.API_PERSON_ID%TYPE;
169: l_title HZ_PERSON_PROFILES.PERSON_TITLE%TYPE;

Line 166: l_middle_name HZ_PARTIES. PERSON_MIDDLE_NAME%TYPE;

162: l_user_name FND_USER.USER_NAME%TYPE;
163: l_person_number HZ_PARTIES.PARTY_NUMBER%TYPE;
164: l_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
165: l_last_name HZ_PARTIES. PERSON_LAST_NAME%TYPE;
166: l_middle_name HZ_PARTIES. PERSON_MIDDLE_NAME%TYPE;
167: l_pref_name HZ_PARTIES.KNOWN_AS%TYPE;
168: l_pref_alt_id IGS_PE_ALT_PERS_ID.API_PERSON_ID%TYPE;
169: l_title HZ_PERSON_PROFILES.PERSON_TITLE%TYPE;
170: l_prefix HZ_PERSON_PROFILES.PERSON_PRE_NAME_ADJUNCT%TYPE;

Line 167: l_pref_name HZ_PARTIES.KNOWN_AS%TYPE;

163: l_person_number HZ_PARTIES.PARTY_NUMBER%TYPE;
164: l_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
165: l_last_name HZ_PARTIES. PERSON_LAST_NAME%TYPE;
166: l_middle_name HZ_PARTIES. PERSON_MIDDLE_NAME%TYPE;
167: l_pref_name HZ_PARTIES.KNOWN_AS%TYPE;
168: l_pref_alt_id IGS_PE_ALT_PERS_ID.API_PERSON_ID%TYPE;
169: l_title HZ_PERSON_PROFILES.PERSON_TITLE%TYPE;
170: l_prefix HZ_PERSON_PROFILES.PERSON_PRE_NAME_ADJUNCT%TYPE;
171: l_suffix HZ_PARTIES.PERSON_NAME_SUFFIX%TYPE;

Line 171: l_suffix HZ_PARTIES.PERSON_NAME_SUFFIX%TYPE;

167: l_pref_name HZ_PARTIES.KNOWN_AS%TYPE;
168: l_pref_alt_id IGS_PE_ALT_PERS_ID.API_PERSON_ID%TYPE;
169: l_title HZ_PERSON_PROFILES.PERSON_TITLE%TYPE;
170: l_prefix HZ_PERSON_PROFILES.PERSON_PRE_NAME_ADJUNCT%TYPE;
171: l_suffix HZ_PARTIES.PERSON_NAME_SUFFIX%TYPE;
172: l_gender HZ_PERSON_PROFILES.GENDER%TYPE;
173: l_birth_date DATE;
174: l_email_address HZ_CONTACT_POINTS.EMAIL_ADDRESS%TYPE;
175: l_email_format HZ_CONTACT_POINTS.EMAIL_FORMAT%TYPE;

Line 405: FROM hz_parties

401: */
402:
403: CURSOR c_party_number(cp_party_num VARCHAR2) IS
404: SELECT 'X'
405: FROM hz_parties
406: WHERE party_number = cp_party_num;
407:
408: l_party_found VARCHAR2(1);
409: l_person_number VARCHAR2(30);

Line 494: l_party_id hz_parties.party_id%TYPE;

490: l_user_id fnd_user.user_id%TYPE;
491: l_user_name VARCHAR2(255);
492: l_user_password VARCHAR2(255);
493: l_email_address VARCHAR2(255);
494: l_party_id hz_parties.party_id%TYPE;
495:
496: BEGIN
497:
498:

Line 533: UPDATE igs_pe_hz_parties

529: assign_responsibility(l_party_id, l_user_id);
530:
531: END IF;
532:
533: UPDATE igs_pe_hz_parties
534: SET oracle_username =l_user_name
535: WHERE party_id = l_party_id;
536:
537: resultout := 'COMPLETE:S' ;

Line 618: gmaheswa 23-Jan-2006 Bug: 4869740. Modified cursor c_hz_parties to use igs_pe_pers_base_v instead of igs_pe_person_v. Performan issue.

614: Who When What
615: pkpatel 21-JAN-2003 Bug No: 2753728
616: Added the validation that the password if entered should be at least 5 characters.
617: pkpatel 6-JAn-2004 Bug No: 3316053 (Modified the validation for passing Person Number/Preferred Alternate ID)
618: gmaheswa 23-Jan-2006 Bug: 4869740. Modified cursor c_hz_parties to use igs_pe_pers_base_v instead of igs_pe_person_v. Performan issue.
619: ******************************************************************/
620: l_api_name CONSTANT VARCHAR2(30) := 'Generate_User' ;
621: l_api_version CONSTANT NUMBER := 1.0 ;
622: l_return_status VARCHAR2(1) ;

Line 626: l_party_id hz_parties.party_id%TYPE;

622: l_return_status VARCHAR2(1) ;
623: l_msg_count NUMBER ;
624: l_msg_data VARCHAR2(2000) ;
625: l_item_key VARCHAR2(255);
626: l_party_id hz_parties.party_id%TYPE;
627: l_user_name VARCHAR2(30);
628: l_wf_name VARCHAR2(8) ;
629: l_process_name VARCHAR2(255) ;
630:

Line 650: CURSOR c_hz_parties(cp_person_number VARCHAR2) IS

646: FROM wf_items
647: WHERE item_type = cp_wf_name
648: AND item_key like cp_item_key||'%' ;
649:
650: CURSOR c_hz_parties(cp_person_number VARCHAR2) IS
651: SELECT party_id
652: FROM hz_parties
653: WHERE party_number = cp_person_number;
654:

Line 652: FROM hz_parties

648: AND item_key like cp_item_key||'%' ;
649:
650: CURSOR c_hz_parties(cp_person_number VARCHAR2) IS
651: SELECT party_id
652: FROM hz_parties
653: WHERE party_number = cp_person_number;
654:
655: CURSOR c_inst(cp_party_number hz_parties.party_number%TYPE) IS
656: SELECT party_name

Line 655: CURSOR c_inst(cp_party_number hz_parties.party_number%TYPE) IS

651: SELECT party_id
652: FROM hz_parties
653: WHERE party_number = cp_person_number;
654:
655: CURSOR c_inst(cp_party_number hz_parties.party_number%TYPE) IS
656: SELECT party_name
657: FROM igs_or_inst_org_base_v
658: WHERE party_number = cp_party_number
659: AND inst_org_ind = 'I';

Line 703: -- Check HZ parties

699: FETCH c_get_wf_name INTO l_item_key;
700: CLOSE c_get_wf_name;
701:
702:
703: -- Check HZ parties
704: OPEN c_hz_parties(p_number);
705: FETCH c_hz_parties INTO l_party_id;
706: CLOSE c_hz_parties;
707:

Line 704: OPEN c_hz_parties(p_number);

700: CLOSE c_get_wf_name;
701:
702:
703: -- Check HZ parties
704: OPEN c_hz_parties(p_number);
705: FETCH c_hz_parties INTO l_party_id;
706: CLOSE c_hz_parties;
707:
708: --Everything is ok - proceed to submition

Line 705: FETCH c_hz_parties INTO l_party_id;

701:
702:
703: -- Check HZ parties
704: OPEN c_hz_parties(p_number);
705: FETCH c_hz_parties INTO l_party_id;
706: CLOSE c_hz_parties;
707:
708: --Everything is ok - proceed to submition
709:

Line 706: CLOSE c_hz_parties;

702:
703: -- Check HZ parties
704: OPEN c_hz_parties(p_number);
705: FETCH c_hz_parties INTO l_party_id;
706: CLOSE c_hz_parties;
707:
708: --Everything is ok - proceed to submition
709:
710: wf_engine.CreateProcess ( ItemType => l_wf_name,

Line 1067: FROM hz_parties

1063: -- active clause, since the primary email is always active.
1064:
1065: CURSOR c_email_info(cp_person_id IGS_PE_PERSON.PERSON_ID%TYPE) IS
1066: SELECT email_address
1067: FROM hz_parties
1068: WHERE party_id = cp_person_id;
1069:
1070: CURSOR c_fnd_user_present(p_person_id IGS_PE_PERSON.PERSON_ID%TYPE) IS
1071: SELECT fnd.user_name,end_date

Line 1326: CURSOR c_get_sys_typ(cp_party_id hz_parties.party_id%TYPE, cp_sysdate DATE) IS

1322: Who When What
1323: ******************************************************************/
1324:
1325: -- Cursor to get all the active person types associated with the person
1326: CURSOR c_get_sys_typ(cp_party_id hz_parties.party_id%TYPE, cp_sysdate DATE) IS
1327: SELECT c.system_type
1328: FROM igs_pe_typ_instances c
1329: WHERE c.person_id = cp_party_id
1330: AND cp_sysdate BETWEEN c.start_date AND NVL(c.end_date, cp_sysdate);

Line 1440: FROM hz_parties

1436: WHERE preferred_ind ='Y';
1437:
1438: CURSOR c_email(cp_person_id NUMBER) IS
1439: SELECT email_address
1440: FROM hz_parties
1441: WHERE party_id = cp_person_id;
1442:
1443: l_default_date DATE := TRUNC(SYSDATE);
1444:

Line 1537: x_hz_parties_ovn => l_object_version_number,

1533: x_email_addr => l_email_address,
1534: x_level_of_qual_id => '',
1535: x_military_service_reg => '',
1536: x_veteran => '',
1537: x_hz_parties_ovn => l_object_version_number,
1538: x_attribute_category => '',
1539: x_attribute1 => '',
1540: x_attribute2 => '',
1541: x_attribute3 => '',

Line 1606: p_owner_table_name => 'HZ_PARTIES',

1602: IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKE(
1603: p_action => 'INSERT',
1604: p_rowid => l_rowid ,
1605: p_status => 'A',
1606: p_owner_table_name => 'HZ_PARTIES',
1607: p_owner_table_id => l_person_id,
1608: P_primary_flag => 'Y',
1609: p_email_format => l_email_format,
1610: p_email_address => l_email_address,

Line 1730: -- Hz parties check

1726: */
1727: PRAGMA AUTONOMOUS_TRANSACTION;
1728: l_default_date DATE := TRUNC(SYSDATE);
1729:
1730: -- Hz parties check
1731: CURSOR cur_hz_parties (cp_first_name VARCHAR2, cp_last_name VARCHAR2,cp_birth_date DATE,
1732: cp_gender VARCHAR2, cp_person_num VARCHAR2, cp_pref_alt_id VARCHAR2) IS
1733: SELECT count(*), max(person_id)
1734: FROM igs_pe_person_base_v PE, IGS_PE_PERSON_ID_TYPE_V ALT

Line 1731: CURSOR cur_hz_parties (cp_first_name VARCHAR2, cp_last_name VARCHAR2,cp_birth_date DATE,

1727: PRAGMA AUTONOMOUS_TRANSACTION;
1728: l_default_date DATE := TRUNC(SYSDATE);
1729:
1730: -- Hz parties check
1731: CURSOR cur_hz_parties (cp_first_name VARCHAR2, cp_last_name VARCHAR2,cp_birth_date DATE,
1732: cp_gender VARCHAR2, cp_person_num VARCHAR2, cp_pref_alt_id VARCHAR2) IS
1733: SELECT count(*), max(person_id)
1734: FROM igs_pe_person_base_v PE, IGS_PE_PERSON_ID_TYPE_V ALT
1735: WHERE pe.person_id = alt.pe_person_id(+)

Line 1751: l_party_id HZ_PARTIES.PARTY_ID%TYPE;

1747: WHERE person_party_id = cp_party_id;
1748:
1749: l_count NUMBER;
1750: l_user_id FND_USER.USER_ID%TYPE;
1751: l_party_id HZ_PARTIES.PARTY_ID%TYPE;
1752:
1753: l_zip_count NUMBER;
1754: l_zip_exact_match BOOLEAN;
1755: l_zip_no_match BOOLEAN;

Line 1756: l_zip_party_id HZ_PARTIES.PARTY_ID%TYPE;

1752:
1753: l_zip_count NUMBER;
1754: l_zip_exact_match BOOLEAN;
1755: l_zip_no_match BOOLEAN;
1756: l_zip_party_id HZ_PARTIES.PARTY_ID%TYPE;
1757:
1758: CURSOR c_pref_alt_id(cp_alt_id VARCHAR2) IS
1759: SELECT 1
1760: FROM igs_pe_alt_pers_id alt, igs_pe_person_id_typ typ

Line 1769: FROM igs_pe_person_id_type_v alt, hz_parties hz, hz_person_profiles hzp

1765:
1766: CURSOR c_dup_zip(cp_first_name VARCHAR2, cp_last_name VARCHAR2, cp_birth_date VARCHAR2, cp_pref_alt_id VARCHAR2,
1767: cp_person_num VARCHAR2, cp_gender VARCHAR2, cp_zipcode VARCHAR2) IS
1768: SELECT count(*), max(hz.party_id)
1769: FROM igs_pe_person_id_type_v alt, hz_parties hz, hz_person_profiles hzp
1770: WHERE hz.party_id = alt.pe_person_id(+)
1771: AND UPPER(hz.person_first_name) = UPPER(cp_first_name)
1772: AND UPPER(hz.person_last_name) = UPPER(cp_last_name)
1773: AND NVL(hzp.date_of_birth,l_default_date) = NVL(cp_birth_date,l_default_date)

Line 1796: OPEN cur_hz_parties(p_first_name,p_last_name,p_birth_date, p_gender,p_person_num, p_pref_alt_id);

1792: l_count :=0;
1793: l_zip_exact_match := FALSE;
1794: l_zip_no_match := FALSE;
1795:
1796: OPEN cur_hz_parties(p_first_name,p_last_name,p_birth_date, p_gender,p_person_num, p_pref_alt_id);
1797: FETCH cur_hz_parties INTO l_count, l_party_id;
1798: CLOSE cur_hz_parties;
1799:
1800: IF l_count > 1 THEN

Line 1797: FETCH cur_hz_parties INTO l_count, l_party_id;

1793: l_zip_exact_match := FALSE;
1794: l_zip_no_match := FALSE;
1795:
1796: OPEN cur_hz_parties(p_first_name,p_last_name,p_birth_date, p_gender,p_person_num, p_pref_alt_id);
1797: FETCH cur_hz_parties INTO l_count, l_party_id;
1798: CLOSE cur_hz_parties;
1799:
1800: IF l_count > 1 THEN
1801: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN

Line 1798: CLOSE cur_hz_parties;

1794: l_zip_no_match := FALSE;
1795:
1796: OPEN cur_hz_parties(p_first_name,p_last_name,p_birth_date, p_gender,p_person_num, p_pref_alt_id);
1797: FETCH cur_hz_parties INTO l_count, l_party_id;
1798: CLOSE cur_hz_parties;
1799:
1800: IF l_count > 1 THEN
1801: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
1802: l_label := 'igs.plsql.igs_pe_userid_pkg.Validate_Person.Dup_Person_Check';

Line 1958: l_person_number hz_parties.party_number%TYPE;

1954: SELECT IGS_PE_GEN_USER_S.nextval
1955: FROM DUAL;
1956:
1957: lv_UniqueInd igs_pe_person_id_typ.UNIQUE_IND%TYPE;
1958: l_person_number hz_parties.party_number%TYPE;
1959:
1960: l_person_id_typ igs_pe_person_id_typ.PERSON_ID_TYPE%TYPE;
1961: l_format igs_pe_person_id_typ.format_mask%type;
1962: l_exists VARCHAR2(1);