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_IDENTIFY_DUPS dependencies on IGS_PE_DUP_MATCHES_PPA_V

Line 148: l_surname igs_pe_dup_matches_ppa_v.surname%TYPE;

144: || gmaheswa 24-jan-2005 Bug: 3882788 Added the start_dt <> end_dt or end_dt is null check for person_id_type
145: || (reverse chronological order - newest change first)
146: */
147:
148: l_surname igs_pe_dup_matches_ppa_v.surname%TYPE;
149: l_given_names igs_pe_dup_matches_ppa_v.given_names%TYPE;
150: l_given_name_1_char igs_pe_dup_matches_ppa_v.given_name_1_char%TYPE;
151: l_api_person_id igs_pe_dup_matches_ppa_v.api_person_id%TYPE;
152: l_pref_alternate_id igs_pe_dup_matches_ppa_v.pref_alternate_id%TYPE;

Line 149: l_given_names igs_pe_dup_matches_ppa_v.given_names%TYPE;

145: || (reverse chronological order - newest change first)
146: */
147:
148: l_surname igs_pe_dup_matches_ppa_v.surname%TYPE;
149: l_given_names igs_pe_dup_matches_ppa_v.given_names%TYPE;
150: l_given_name_1_char igs_pe_dup_matches_ppa_v.given_name_1_char%TYPE;
151: l_api_person_id igs_pe_dup_matches_ppa_v.api_person_id%TYPE;
152: l_pref_alternate_id igs_pe_dup_matches_ppa_v.pref_alternate_id%TYPE;
153: l_person_id_type igs_pe_dup_matches_ppa_v.person_id_type%TYPE;

Line 150: l_given_name_1_char igs_pe_dup_matches_ppa_v.given_name_1_char%TYPE;

146: */
147:
148: l_surname igs_pe_dup_matches_ppa_v.surname%TYPE;
149: l_given_names igs_pe_dup_matches_ppa_v.given_names%TYPE;
150: l_given_name_1_char igs_pe_dup_matches_ppa_v.given_name_1_char%TYPE;
151: l_api_person_id igs_pe_dup_matches_ppa_v.api_person_id%TYPE;
152: l_pref_alternate_id igs_pe_dup_matches_ppa_v.pref_alternate_id%TYPE;
153: l_person_id_type igs_pe_dup_matches_ppa_v.person_id_type%TYPE;
154: l_sex igs_pe_dup_matches_ppa_v.sex%TYPE;

Line 151: l_api_person_id igs_pe_dup_matches_ppa_v.api_person_id%TYPE;

147:
148: l_surname igs_pe_dup_matches_ppa_v.surname%TYPE;
149: l_given_names igs_pe_dup_matches_ppa_v.given_names%TYPE;
150: l_given_name_1_char igs_pe_dup_matches_ppa_v.given_name_1_char%TYPE;
151: l_api_person_id igs_pe_dup_matches_ppa_v.api_person_id%TYPE;
152: l_pref_alternate_id igs_pe_dup_matches_ppa_v.pref_alternate_id%TYPE;
153: l_person_id_type igs_pe_dup_matches_ppa_v.person_id_type%TYPE;
154: l_sex igs_pe_dup_matches_ppa_v.sex%TYPE;
155: l_ethnic_origin igs_pe_dup_matches_ppa_v.ethnic_origin%TYPE;

Line 152: l_pref_alternate_id igs_pe_dup_matches_ppa_v.pref_alternate_id%TYPE;

148: l_surname igs_pe_dup_matches_ppa_v.surname%TYPE;
149: l_given_names igs_pe_dup_matches_ppa_v.given_names%TYPE;
150: l_given_name_1_char igs_pe_dup_matches_ppa_v.given_name_1_char%TYPE;
151: l_api_person_id igs_pe_dup_matches_ppa_v.api_person_id%TYPE;
152: l_pref_alternate_id igs_pe_dup_matches_ppa_v.pref_alternate_id%TYPE;
153: l_person_id_type igs_pe_dup_matches_ppa_v.person_id_type%TYPE;
154: l_sex igs_pe_dup_matches_ppa_v.sex%TYPE;
155: l_ethnic_origin igs_pe_dup_matches_ppa_v.ethnic_origin%TYPE;
156: l_addr_type igs_pe_dup_matches_ppa_v.addr_type%TYPE;

Line 153: l_person_id_type igs_pe_dup_matches_ppa_v.person_id_type%TYPE;

149: l_given_names igs_pe_dup_matches_ppa_v.given_names%TYPE;
150: l_given_name_1_char igs_pe_dup_matches_ppa_v.given_name_1_char%TYPE;
151: l_api_person_id igs_pe_dup_matches_ppa_v.api_person_id%TYPE;
152: l_pref_alternate_id igs_pe_dup_matches_ppa_v.pref_alternate_id%TYPE;
153: l_person_id_type igs_pe_dup_matches_ppa_v.person_id_type%TYPE;
154: l_sex igs_pe_dup_matches_ppa_v.sex%TYPE;
155: l_ethnic_origin igs_pe_dup_matches_ppa_v.ethnic_origin%TYPE;
156: l_addr_type igs_pe_dup_matches_ppa_v.addr_type%TYPE;
157: l_addr_line_1 igs_pe_dup_matches_ppa_v.addr_line_1%TYPE;

Line 154: l_sex igs_pe_dup_matches_ppa_v.sex%TYPE;

150: l_given_name_1_char igs_pe_dup_matches_ppa_v.given_name_1_char%TYPE;
151: l_api_person_id igs_pe_dup_matches_ppa_v.api_person_id%TYPE;
152: l_pref_alternate_id igs_pe_dup_matches_ppa_v.pref_alternate_id%TYPE;
153: l_person_id_type igs_pe_dup_matches_ppa_v.person_id_type%TYPE;
154: l_sex igs_pe_dup_matches_ppa_v.sex%TYPE;
155: l_ethnic_origin igs_pe_dup_matches_ppa_v.ethnic_origin%TYPE;
156: l_addr_type igs_pe_dup_matches_ppa_v.addr_type%TYPE;
157: l_addr_line_1 igs_pe_dup_matches_ppa_v.addr_line_1%TYPE;
158: l_conct_address_lines igs_pe_dup_matches_prim_ppa_v.conct_address_lines%TYPE;

Line 155: l_ethnic_origin igs_pe_dup_matches_ppa_v.ethnic_origin%TYPE;

151: l_api_person_id igs_pe_dup_matches_ppa_v.api_person_id%TYPE;
152: l_pref_alternate_id igs_pe_dup_matches_ppa_v.pref_alternate_id%TYPE;
153: l_person_id_type igs_pe_dup_matches_ppa_v.person_id_type%TYPE;
154: l_sex igs_pe_dup_matches_ppa_v.sex%TYPE;
155: l_ethnic_origin igs_pe_dup_matches_ppa_v.ethnic_origin%TYPE;
156: l_addr_type igs_pe_dup_matches_ppa_v.addr_type%TYPE;
157: l_addr_line_1 igs_pe_dup_matches_ppa_v.addr_line_1%TYPE;
158: l_conct_address_lines igs_pe_dup_matches_prim_ppa_v.conct_address_lines%TYPE;
159: l_addr_line_2 igs_pe_dup_matches_ppa_v.addr_line_2%TYPE;

Line 156: l_addr_type igs_pe_dup_matches_ppa_v.addr_type%TYPE;

152: l_pref_alternate_id igs_pe_dup_matches_ppa_v.pref_alternate_id%TYPE;
153: l_person_id_type igs_pe_dup_matches_ppa_v.person_id_type%TYPE;
154: l_sex igs_pe_dup_matches_ppa_v.sex%TYPE;
155: l_ethnic_origin igs_pe_dup_matches_ppa_v.ethnic_origin%TYPE;
156: l_addr_type igs_pe_dup_matches_ppa_v.addr_type%TYPE;
157: l_addr_line_1 igs_pe_dup_matches_ppa_v.addr_line_1%TYPE;
158: l_conct_address_lines igs_pe_dup_matches_prim_ppa_v.conct_address_lines%TYPE;
159: l_addr_line_2 igs_pe_dup_matches_ppa_v.addr_line_2%TYPE;
160: l_addr_line_3 igs_pe_dup_matches_ppa_v.addr_line_3%TYPE;

Line 157: l_addr_line_1 igs_pe_dup_matches_ppa_v.addr_line_1%TYPE;

153: l_person_id_type igs_pe_dup_matches_ppa_v.person_id_type%TYPE;
154: l_sex igs_pe_dup_matches_ppa_v.sex%TYPE;
155: l_ethnic_origin igs_pe_dup_matches_ppa_v.ethnic_origin%TYPE;
156: l_addr_type igs_pe_dup_matches_ppa_v.addr_type%TYPE;
157: l_addr_line_1 igs_pe_dup_matches_ppa_v.addr_line_1%TYPE;
158: l_conct_address_lines igs_pe_dup_matches_prim_ppa_v.conct_address_lines%TYPE;
159: l_addr_line_2 igs_pe_dup_matches_ppa_v.addr_line_2%TYPE;
160: l_addr_line_3 igs_pe_dup_matches_ppa_v.addr_line_3%TYPE;
161: l_addr_line_4 igs_pe_dup_matches_ppa_v.addr_line_4%TYPE;

Line 159: l_addr_line_2 igs_pe_dup_matches_ppa_v.addr_line_2%TYPE;

155: l_ethnic_origin igs_pe_dup_matches_ppa_v.ethnic_origin%TYPE;
156: l_addr_type igs_pe_dup_matches_ppa_v.addr_type%TYPE;
157: l_addr_line_1 igs_pe_dup_matches_ppa_v.addr_line_1%TYPE;
158: l_conct_address_lines igs_pe_dup_matches_prim_ppa_v.conct_address_lines%TYPE;
159: l_addr_line_2 igs_pe_dup_matches_ppa_v.addr_line_2%TYPE;
160: l_addr_line_3 igs_pe_dup_matches_ppa_v.addr_line_3%TYPE;
161: l_addr_line_4 igs_pe_dup_matches_ppa_v.addr_line_4%TYPE;
162: l_city igs_pe_dup_matches_ppa_v.city%TYPE;
163: l_state igs_pe_dup_matches_ppa_v.state%TYPE;

Line 160: l_addr_line_3 igs_pe_dup_matches_ppa_v.addr_line_3%TYPE;

156: l_addr_type igs_pe_dup_matches_ppa_v.addr_type%TYPE;
157: l_addr_line_1 igs_pe_dup_matches_ppa_v.addr_line_1%TYPE;
158: l_conct_address_lines igs_pe_dup_matches_prim_ppa_v.conct_address_lines%TYPE;
159: l_addr_line_2 igs_pe_dup_matches_ppa_v.addr_line_2%TYPE;
160: l_addr_line_3 igs_pe_dup_matches_ppa_v.addr_line_3%TYPE;
161: l_addr_line_4 igs_pe_dup_matches_ppa_v.addr_line_4%TYPE;
162: l_city igs_pe_dup_matches_ppa_v.city%TYPE;
163: l_state igs_pe_dup_matches_ppa_v.state%TYPE;
164: l_province igs_pe_dup_matches_ppa_v.province%TYPE;

Line 161: l_addr_line_4 igs_pe_dup_matches_ppa_v.addr_line_4%TYPE;

157: l_addr_line_1 igs_pe_dup_matches_ppa_v.addr_line_1%TYPE;
158: l_conct_address_lines igs_pe_dup_matches_prim_ppa_v.conct_address_lines%TYPE;
159: l_addr_line_2 igs_pe_dup_matches_ppa_v.addr_line_2%TYPE;
160: l_addr_line_3 igs_pe_dup_matches_ppa_v.addr_line_3%TYPE;
161: l_addr_line_4 igs_pe_dup_matches_ppa_v.addr_line_4%TYPE;
162: l_city igs_pe_dup_matches_ppa_v.city%TYPE;
163: l_state igs_pe_dup_matches_ppa_v.state%TYPE;
164: l_province igs_pe_dup_matches_ppa_v.province%TYPE;
165: l_county igs_pe_dup_matches_ppa_v.county%TYPE;

Line 162: l_city igs_pe_dup_matches_ppa_v.city%TYPE;

158: l_conct_address_lines igs_pe_dup_matches_prim_ppa_v.conct_address_lines%TYPE;
159: l_addr_line_2 igs_pe_dup_matches_ppa_v.addr_line_2%TYPE;
160: l_addr_line_3 igs_pe_dup_matches_ppa_v.addr_line_3%TYPE;
161: l_addr_line_4 igs_pe_dup_matches_ppa_v.addr_line_4%TYPE;
162: l_city igs_pe_dup_matches_ppa_v.city%TYPE;
163: l_state igs_pe_dup_matches_ppa_v.state%TYPE;
164: l_province igs_pe_dup_matches_ppa_v.province%TYPE;
165: l_county igs_pe_dup_matches_ppa_v.county%TYPE;
166: l_country igs_pe_dup_matches_ppa_v.country%TYPE;

Line 163: l_state igs_pe_dup_matches_ppa_v.state%TYPE;

159: l_addr_line_2 igs_pe_dup_matches_ppa_v.addr_line_2%TYPE;
160: l_addr_line_3 igs_pe_dup_matches_ppa_v.addr_line_3%TYPE;
161: l_addr_line_4 igs_pe_dup_matches_ppa_v.addr_line_4%TYPE;
162: l_city igs_pe_dup_matches_ppa_v.city%TYPE;
163: l_state igs_pe_dup_matches_ppa_v.state%TYPE;
164: l_province igs_pe_dup_matches_ppa_v.province%TYPE;
165: l_county igs_pe_dup_matches_ppa_v.county%TYPE;
166: l_country igs_pe_dup_matches_ppa_v.country%TYPE;
167: l_postcode igs_pe_dup_matches_ppa_v.postcode%TYPE;

Line 164: l_province igs_pe_dup_matches_ppa_v.province%TYPE;

160: l_addr_line_3 igs_pe_dup_matches_ppa_v.addr_line_3%TYPE;
161: l_addr_line_4 igs_pe_dup_matches_ppa_v.addr_line_4%TYPE;
162: l_city igs_pe_dup_matches_ppa_v.city%TYPE;
163: l_state igs_pe_dup_matches_ppa_v.state%TYPE;
164: l_province igs_pe_dup_matches_ppa_v.province%TYPE;
165: l_county igs_pe_dup_matches_ppa_v.county%TYPE;
166: l_country igs_pe_dup_matches_ppa_v.country%TYPE;
167: l_postcode igs_pe_dup_matches_ppa_v.postcode%TYPE;
168:

Line 165: l_county igs_pe_dup_matches_ppa_v.county%TYPE;

161: l_addr_line_4 igs_pe_dup_matches_ppa_v.addr_line_4%TYPE;
162: l_city igs_pe_dup_matches_ppa_v.city%TYPE;
163: l_state igs_pe_dup_matches_ppa_v.state%TYPE;
164: l_province igs_pe_dup_matches_ppa_v.province%TYPE;
165: l_county igs_pe_dup_matches_ppa_v.county%TYPE;
166: l_country igs_pe_dup_matches_ppa_v.country%TYPE;
167: l_postcode igs_pe_dup_matches_ppa_v.postcode%TYPE;
168:
169:

Line 166: l_country igs_pe_dup_matches_ppa_v.country%TYPE;

162: l_city igs_pe_dup_matches_ppa_v.city%TYPE;
163: l_state igs_pe_dup_matches_ppa_v.state%TYPE;
164: l_province igs_pe_dup_matches_ppa_v.province%TYPE;
165: l_county igs_pe_dup_matches_ppa_v.county%TYPE;
166: l_country igs_pe_dup_matches_ppa_v.country%TYPE;
167: l_postcode igs_pe_dup_matches_ppa_v.postcode%TYPE;
168:
169:
170: l_SelectClause VARCHAR2(2000);

Line 167: l_postcode igs_pe_dup_matches_ppa_v.postcode%TYPE;

163: l_state igs_pe_dup_matches_ppa_v.state%TYPE;
164: l_province igs_pe_dup_matches_ppa_v.province%TYPE;
165: l_county igs_pe_dup_matches_ppa_v.county%TYPE;
166: l_country igs_pe_dup_matches_ppa_v.country%TYPE;
167: l_postcode igs_pe_dup_matches_ppa_v.postcode%TYPE;
168:
169:
170: l_SelectClause VARCHAR2(2000);
171: