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 IGS_PE_PERSON

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 798: FROM igs_pe_person_id_typ

794: IS
795:
796: CURSOR c_id_type IS
797: SELECT description
798: FROM igs_pe_person_id_typ
799: WHERE preferred_ind ='Y';
800:
801: l_id_type igs_pe_person_id_typ.description%TYPE;
802:

Line 801: l_id_type igs_pe_person_id_typ.description%TYPE;

797: SELECT description
798: FROM igs_pe_person_id_typ
799: WHERE preferred_ind ='Y';
800:
801: l_id_type igs_pe_person_id_typ.description%TYPE;
802:
803:
804: BEGIN
805:

Line 1046: TYPE member_type IS RECORD( person_id igs_pe_person_base_v.person_id%TYPE,

1042: l_group_type IGS_PE_PERSID_GROUP_V.group_type%TYPE;
1043: TYPE pgroup_query IS REF CURSOR;
1044: pgroup_refcur pgroup_query;
1045:
1046: TYPE member_type IS RECORD( person_id igs_pe_person_base_v.person_id%TYPE,
1047: person_number igs_pe_person_base_v.person_number%TYPE,
1048: full_name igs_pe_person_base_v.full_name%TYPE,
1049: sex igs_pe_person_base_v.gender%TYPE,
1050: birth_date igs_pe_person_base_v.birth_date%TYPE,

Line 1047: person_number igs_pe_person_base_v.person_number%TYPE,

1043: TYPE pgroup_query IS REF CURSOR;
1044: pgroup_refcur pgroup_query;
1045:
1046: TYPE member_type IS RECORD( person_id igs_pe_person_base_v.person_id%TYPE,
1047: person_number igs_pe_person_base_v.person_number%TYPE,
1048: full_name igs_pe_person_base_v.full_name%TYPE,
1049: sex igs_pe_person_base_v.gender%TYPE,
1050: birth_date igs_pe_person_base_v.birth_date%TYPE,
1051: title igs_pe_person_base_v.title%TYPE,

Line 1048: full_name igs_pe_person_base_v.full_name%TYPE,

1044: pgroup_refcur pgroup_query;
1045:
1046: TYPE member_type IS RECORD( person_id igs_pe_person_base_v.person_id%TYPE,
1047: person_number igs_pe_person_base_v.person_number%TYPE,
1048: full_name igs_pe_person_base_v.full_name%TYPE,
1049: sex igs_pe_person_base_v.gender%TYPE,
1050: birth_date igs_pe_person_base_v.birth_date%TYPE,
1051: title igs_pe_person_base_v.title%TYPE,
1052: surname igs_pe_person_base_v.last_name%TYPE,

Line 1049: sex igs_pe_person_base_v.gender%TYPE,

1045:
1046: TYPE member_type IS RECORD( person_id igs_pe_person_base_v.person_id%TYPE,
1047: person_number igs_pe_person_base_v.person_number%TYPE,
1048: full_name igs_pe_person_base_v.full_name%TYPE,
1049: sex igs_pe_person_base_v.gender%TYPE,
1050: birth_date igs_pe_person_base_v.birth_date%TYPE,
1051: title igs_pe_person_base_v.title%TYPE,
1052: surname igs_pe_person_base_v.last_name%TYPE,
1053: given_name igs_pe_person_base_v.first_name%TYPE,

Line 1050: birth_date igs_pe_person_base_v.birth_date%TYPE,

1046: TYPE member_type IS RECORD( person_id igs_pe_person_base_v.person_id%TYPE,
1047: person_number igs_pe_person_base_v.person_number%TYPE,
1048: full_name igs_pe_person_base_v.full_name%TYPE,
1049: sex igs_pe_person_base_v.gender%TYPE,
1050: birth_date igs_pe_person_base_v.birth_date%TYPE,
1051: title igs_pe_person_base_v.title%TYPE,
1052: surname igs_pe_person_base_v.last_name%TYPE,
1053: given_name igs_pe_person_base_v.first_name%TYPE,
1054: preferred_name igs_pe_person_base_v.known_as%TYPE,

Line 1051: title igs_pe_person_base_v.title%TYPE,

1047: person_number igs_pe_person_base_v.person_number%TYPE,
1048: full_name igs_pe_person_base_v.full_name%TYPE,
1049: sex igs_pe_person_base_v.gender%TYPE,
1050: birth_date igs_pe_person_base_v.birth_date%TYPE,
1051: title igs_pe_person_base_v.title%TYPE,
1052: surname igs_pe_person_base_v.last_name%TYPE,
1053: given_name igs_pe_person_base_v.first_name%TYPE,
1054: preferred_name igs_pe_person_base_v.known_as%TYPE,
1055: suffix igs_pe_person_base_v.suffix%TYPE,

Line 1052: surname igs_pe_person_base_v.last_name%TYPE,

1048: full_name igs_pe_person_base_v.full_name%TYPE,
1049: sex igs_pe_person_base_v.gender%TYPE,
1050: birth_date igs_pe_person_base_v.birth_date%TYPE,
1051: title igs_pe_person_base_v.title%TYPE,
1052: surname igs_pe_person_base_v.last_name%TYPE,
1053: given_name igs_pe_person_base_v.first_name%TYPE,
1054: preferred_name igs_pe_person_base_v.known_as%TYPE,
1055: suffix igs_pe_person_base_v.suffix%TYPE,
1056: prefix igs_pe_person_base_v.pre_name_adjunct%TYPE,

Line 1053: given_name igs_pe_person_base_v.first_name%TYPE,

1049: sex igs_pe_person_base_v.gender%TYPE,
1050: birth_date igs_pe_person_base_v.birth_date%TYPE,
1051: title igs_pe_person_base_v.title%TYPE,
1052: surname igs_pe_person_base_v.last_name%TYPE,
1053: given_name igs_pe_person_base_v.first_name%TYPE,
1054: preferred_name igs_pe_person_base_v.known_as%TYPE,
1055: suffix igs_pe_person_base_v.suffix%TYPE,
1056: prefix igs_pe_person_base_v.pre_name_adjunct%TYPE,
1057: middle_name igs_pe_person_base_v.middle_name%TYPE,

Line 1054: preferred_name igs_pe_person_base_v.known_as%TYPE,

1050: birth_date igs_pe_person_base_v.birth_date%TYPE,
1051: title igs_pe_person_base_v.title%TYPE,
1052: surname igs_pe_person_base_v.last_name%TYPE,
1053: given_name igs_pe_person_base_v.first_name%TYPE,
1054: preferred_name igs_pe_person_base_v.known_as%TYPE,
1055: suffix igs_pe_person_base_v.suffix%TYPE,
1056: prefix igs_pe_person_base_v.pre_name_adjunct%TYPE,
1057: middle_name igs_pe_person_base_v.middle_name%TYPE,
1058: alternate_id igs_pe_person_id_type_v.api_person_id%TYPE);

Line 1055: suffix igs_pe_person_base_v.suffix%TYPE,

1051: title igs_pe_person_base_v.title%TYPE,
1052: surname igs_pe_person_base_v.last_name%TYPE,
1053: given_name igs_pe_person_base_v.first_name%TYPE,
1054: preferred_name igs_pe_person_base_v.known_as%TYPE,
1055: suffix igs_pe_person_base_v.suffix%TYPE,
1056: prefix igs_pe_person_base_v.pre_name_adjunct%TYPE,
1057: middle_name igs_pe_person_base_v.middle_name%TYPE,
1058: alternate_id igs_pe_person_id_type_v.api_person_id%TYPE);
1059:

Line 1056: prefix igs_pe_person_base_v.pre_name_adjunct%TYPE,

1052: surname igs_pe_person_base_v.last_name%TYPE,
1053: given_name igs_pe_person_base_v.first_name%TYPE,
1054: preferred_name igs_pe_person_base_v.known_as%TYPE,
1055: suffix igs_pe_person_base_v.suffix%TYPE,
1056: prefix igs_pe_person_base_v.pre_name_adjunct%TYPE,
1057: middle_name igs_pe_person_base_v.middle_name%TYPE,
1058: alternate_id igs_pe_person_id_type_v.api_person_id%TYPE);
1059:
1060: l_member_rec member_type;

Line 1057: middle_name igs_pe_person_base_v.middle_name%TYPE,

1053: given_name igs_pe_person_base_v.first_name%TYPE,
1054: preferred_name igs_pe_person_base_v.known_as%TYPE,
1055: suffix igs_pe_person_base_v.suffix%TYPE,
1056: prefix igs_pe_person_base_v.pre_name_adjunct%TYPE,
1057: middle_name igs_pe_person_base_v.middle_name%TYPE,
1058: alternate_id igs_pe_person_id_type_v.api_person_id%TYPE);
1059:
1060: l_member_rec member_type;
1061:

Line 1058: alternate_id igs_pe_person_id_type_v.api_person_id%TYPE);

1054: preferred_name igs_pe_person_base_v.known_as%TYPE,
1055: suffix igs_pe_person_base_v.suffix%TYPE,
1056: prefix igs_pe_person_base_v.pre_name_adjunct%TYPE,
1057: middle_name igs_pe_person_base_v.middle_name%TYPE,
1058: alternate_id igs_pe_person_id_type_v.api_person_id%TYPE);
1059:
1060: l_member_rec member_type;
1061:
1062: -- changed the cursor to pick up the primary email and removed the

Line 1065: CURSOR c_email_info(cp_person_id IGS_PE_PERSON.PERSON_ID%TYPE) IS

1061:
1062: -- changed the cursor to pick up the primary email and removed the
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:

Line 1070: CURSOR c_fnd_user_present(p_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
1072: FROM fnd_user fnd
1073: WHERE fnd.person_party_id = p_person_id;
1074:

Line 1105: ' igs_pe_person_base_v p, ' ||

1101: ' p.pre_name_adjunct prefix, ' ||
1102: ' p.middle_name, ' ||
1103: ' pit.api_person_id alternate_id ' ||
1104: ' FROM ' ||
1105: ' igs_pe_person_base_v p, ' ||
1106: ' igs_pe_person_id_type_v pit ' ||
1107: ' WHERE ' ||
1108: ' p.person_id = pit.pe_person_id (+) AND ' ||
1109: ' p.person_id IN ';

Line 1106: ' igs_pe_person_id_type_v pit ' ||

1102: ' p.middle_name, ' ||
1103: ' pit.api_person_id alternate_id ' ||
1104: ' FROM ' ||
1105: ' igs_pe_person_base_v p, ' ||
1106: ' igs_pe_person_id_type_v pit ' ||
1107: ' WHERE ' ||
1108: ' p.person_id = pit.pe_person_id (+) AND ' ||
1109: ' p.person_id IN ';
1110:

Line 1333: CURSOR c_resp(cp_system_type igs_pe_person_types.system_type%TYPE) IS

1329: WHERE c.person_id = cp_party_id
1330: AND cp_sysdate BETWEEN c.start_date AND NVL(c.end_date, cp_sysdate);
1331:
1332: -- Cursor to get the responsibilities associated with a particular person type
1333: CURSOR c_resp(cp_system_type igs_pe_person_types.system_type%TYPE) IS
1334: SELECT st.responsibility_key resp_name,
1335: st.application_short_name apps_name,
1336: rsp.application_id apps_id,
1337: rsp.responsibility_id resp_id

Line 1430: l_id_type igs_pe_person_id_typ.person_id_type%TYPE;

1426: l_msg_count NUMBER;
1427: l_msg_data VARCHAR2(255);
1428: l_contact_point_id hz_contact_points.contact_point_id%TYPE;
1429: l_date DATE;
1430: l_id_type igs_pe_person_id_typ.person_id_type%TYPE;
1431: l_count NUMBER(9);
1432:
1433: CURSOR c_id_type IS
1434: SELECT person_id_type

Line 1435: FROM igs_pe_person_id_typ

1431: l_count NUMBER(9);
1432:
1433: CURSOR c_id_type IS
1434: SELECT person_id_type
1435: FROM igs_pe_person_id_typ
1436: WHERE preferred_ind ='Y';
1437:
1438: CURSOR c_email(cp_person_id NUMBER) IS
1439: SELECT email_address

Line 1506: igs_pe_person_pkg.insert_row(

1502: l_debug_str := 'Before Person Insert';
1503: fnd_log.string( fnd_log.level_procedure,l_label,l_debug_str);
1504: END IF;
1505:
1506: igs_pe_person_pkg.insert_row(
1507: x_msg_count => l_msg_count,
1508: x_msg_data => l_msg_data,
1509: x_rowid => l_rowid,
1510: x_return_status => l_return_status,

Line 1734: FROM igs_pe_person_base_v PE, IGS_PE_PERSON_ID_TYPE_V ALT

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(+)
1736: AND UPPER(pe.first_name) = UPPER(cp_first_name)
1737: AND UPPER(pe.last_name) = UPPER(cp_last_name)
1738: AND NVL(pe.birth_date,l_default_date) = NVL(cp_birth_date,l_default_date)

Line 1760: FROM igs_pe_alt_pers_id alt, igs_pe_person_id_typ typ

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
1761: WHERE alt.api_person_id = cp_alt_id
1762: AND typ.person_id_type = alt.person_id_type
1763: AND typ.preferred_ind = 'Y';
1764: l_alt_id_found NUMBER;

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 1950: FROM igs_pe_person_id_typ

1946: || p_phoneNumber,p_person_id
1947: */
1948: CURSOR c_pref_alt_type IS
1949: SELECT person_id_type, unique_ind, description, format_mask
1950: FROM igs_pe_person_id_typ
1951: WHERE preferred_ind ='Y';
1952:
1953: CURSOR c_seq_num IS
1954: SELECT IGS_PE_GEN_USER_S.nextval

Line 1957: lv_UniqueInd igs_pe_person_id_typ.UNIQUE_IND%TYPE;

1953: CURSOR c_seq_num IS
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;

Line 1960: l_person_id_typ igs_pe_person_id_typ.PERSON_ID_TYPE%TYPE;

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);
1963: l_alt_id_desc igs_pe_person_id_typ.description%TYPE;
1964:

Line 1961: l_format igs_pe_person_id_typ.format_mask%type;

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);
1963: l_alt_id_desc igs_pe_person_id_typ.description%TYPE;
1964:
1965: l_event_t wf_event_t;

Line 1963: l_alt_id_desc igs_pe_person_id_typ.description%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);
1963: l_alt_id_desc igs_pe_person_id_typ.description%TYPE;
1964:
1965: l_event_t wf_event_t;
1966: l_parameter_list_t wf_parameter_list_t;
1967: l_wf_name VARCHAR2(8) ;

Line 2175: FROM igs_pe_person_id_typ

2171: AND lookup_code = cp_gender;
2172:
2173: CURSOR cur_person_id_type (cp_pers_id_type VARCHAR2) IS
2174: SELECT description
2175: FROM igs_pe_person_id_typ
2176: WHERE person_id_type = cp_pers_id_type;
2177:
2178: l_gender FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE;
2179: l_phone_area_code HZ_CONTACT_POINTS.PHONE_AREA_CODE%TYPE;

Line 2183: l_person_id_type IGS_PE_PERSON_ID_TYP.DESCRIPTION%TYPE;

2179: l_phone_area_code HZ_CONTACT_POINTS.PHONE_AREA_CODE%TYPE;
2180: l_phone_country_code HZ_CONTACT_POINTS.PHONE_COUNTRY_CODE%TYPE;
2181: l_phone_number HZ_CONTACT_POINTS.PHONE_NUMBER%TYPE;
2182: l_gender_meaning FND_LOOKUP_VALUES.MEANING%TYPE;
2183: l_person_id_type IGS_PE_PERSON_ID_TYP.DESCRIPTION%TYPE;
2184: l_formatted_phone VARCHAR2(100);
2185: x_return_status VARCHAR2(1);
2186: x_msg_count NUMBER;
2187: x_msg_data VARCHAR2(2000);