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_BASE_V

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 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 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)