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.UMX_REGISTRATION_PVT dependencies on HZ_PARTIES

Line 220: from hz_parties

216:
217: cursor get_address_info is
218: select ADDRESS1, ADDRESS2, ADDRESS3, ADDRESS4, CITY,
219: POSTAL_CODE, PROVINCE, STATE, COUNTY, COUNTRY
220: from hz_parties
221: where party_id = p_party_id;
222:
223: l_address1 HZ_PARTIES.ADDRESS1%TYPE;
224: l_address2 HZ_PARTIES.ADDRESS2%TYPE;

Line 223: l_address1 HZ_PARTIES.ADDRESS1%TYPE;

219: POSTAL_CODE, PROVINCE, STATE, COUNTY, COUNTRY
220: from hz_parties
221: where party_id = p_party_id;
222:
223: l_address1 HZ_PARTIES.ADDRESS1%TYPE;
224: l_address2 HZ_PARTIES.ADDRESS2%TYPE;
225: l_address3 HZ_PARTIES.ADDRESS3%TYPE;
226: l_address4 HZ_PARTIES.ADDRESS4%TYPE;
227: l_city HZ_PARTIES.CITY%TYPE;

Line 224: l_address2 HZ_PARTIES.ADDRESS2%TYPE;

220: from hz_parties
221: where party_id = p_party_id;
222:
223: l_address1 HZ_PARTIES.ADDRESS1%TYPE;
224: l_address2 HZ_PARTIES.ADDRESS2%TYPE;
225: l_address3 HZ_PARTIES.ADDRESS3%TYPE;
226: l_address4 HZ_PARTIES.ADDRESS4%TYPE;
227: l_city HZ_PARTIES.CITY%TYPE;
228: l_postal_code HZ_PARTIES.POSTAL_CODE%TYPE;

Line 225: l_address3 HZ_PARTIES.ADDRESS3%TYPE;

221: where party_id = p_party_id;
222:
223: l_address1 HZ_PARTIES.ADDRESS1%TYPE;
224: l_address2 HZ_PARTIES.ADDRESS2%TYPE;
225: l_address3 HZ_PARTIES.ADDRESS3%TYPE;
226: l_address4 HZ_PARTIES.ADDRESS4%TYPE;
227: l_city HZ_PARTIES.CITY%TYPE;
228: l_postal_code HZ_PARTIES.POSTAL_CODE%TYPE;
229: l_province HZ_PARTIES.PROVINCE%TYPE;

Line 226: l_address4 HZ_PARTIES.ADDRESS4%TYPE;

222:
223: l_address1 HZ_PARTIES.ADDRESS1%TYPE;
224: l_address2 HZ_PARTIES.ADDRESS2%TYPE;
225: l_address3 HZ_PARTIES.ADDRESS3%TYPE;
226: l_address4 HZ_PARTIES.ADDRESS4%TYPE;
227: l_city HZ_PARTIES.CITY%TYPE;
228: l_postal_code HZ_PARTIES.POSTAL_CODE%TYPE;
229: l_province HZ_PARTIES.PROVINCE%TYPE;
230: l_state HZ_PARTIES.STATE%TYPE;

Line 227: l_city HZ_PARTIES.CITY%TYPE;

223: l_address1 HZ_PARTIES.ADDRESS1%TYPE;
224: l_address2 HZ_PARTIES.ADDRESS2%TYPE;
225: l_address3 HZ_PARTIES.ADDRESS3%TYPE;
226: l_address4 HZ_PARTIES.ADDRESS4%TYPE;
227: l_city HZ_PARTIES.CITY%TYPE;
228: l_postal_code HZ_PARTIES.POSTAL_CODE%TYPE;
229: l_province HZ_PARTIES.PROVINCE%TYPE;
230: l_state HZ_PARTIES.STATE%TYPE;
231: l_county HZ_PARTIES.COUNTY%TYPE;

Line 228: l_postal_code HZ_PARTIES.POSTAL_CODE%TYPE;

224: l_address2 HZ_PARTIES.ADDRESS2%TYPE;
225: l_address3 HZ_PARTIES.ADDRESS3%TYPE;
226: l_address4 HZ_PARTIES.ADDRESS4%TYPE;
227: l_city HZ_PARTIES.CITY%TYPE;
228: l_postal_code HZ_PARTIES.POSTAL_CODE%TYPE;
229: l_province HZ_PARTIES.PROVINCE%TYPE;
230: l_state HZ_PARTIES.STATE%TYPE;
231: l_county HZ_PARTIES.COUNTY%TYPE;
232: l_country HZ_PARTIES.COUNTRY%TYPE;

Line 229: l_province HZ_PARTIES.PROVINCE%TYPE;

225: l_address3 HZ_PARTIES.ADDRESS3%TYPE;
226: l_address4 HZ_PARTIES.ADDRESS4%TYPE;
227: l_city HZ_PARTIES.CITY%TYPE;
228: l_postal_code HZ_PARTIES.POSTAL_CODE%TYPE;
229: l_province HZ_PARTIES.PROVINCE%TYPE;
230: l_state HZ_PARTIES.STATE%TYPE;
231: l_county HZ_PARTIES.COUNTY%TYPE;
232: l_country HZ_PARTIES.COUNTRY%TYPE;
233:

Line 230: l_state HZ_PARTIES.STATE%TYPE;

226: l_address4 HZ_PARTIES.ADDRESS4%TYPE;
227: l_city HZ_PARTIES.CITY%TYPE;
228: l_postal_code HZ_PARTIES.POSTAL_CODE%TYPE;
229: l_province HZ_PARTIES.PROVINCE%TYPE;
230: l_state HZ_PARTIES.STATE%TYPE;
231: l_county HZ_PARTIES.COUNTY%TYPE;
232: l_country HZ_PARTIES.COUNTRY%TYPE;
233:
234: l_return_status VARCHAR2(1);

Line 231: l_county HZ_PARTIES.COUNTY%TYPE;

227: l_city HZ_PARTIES.CITY%TYPE;
228: l_postal_code HZ_PARTIES.POSTAL_CODE%TYPE;
229: l_province HZ_PARTIES.PROVINCE%TYPE;
230: l_state HZ_PARTIES.STATE%TYPE;
231: l_county HZ_PARTIES.COUNTY%TYPE;
232: l_country HZ_PARTIES.COUNTRY%TYPE;
233:
234: l_return_status VARCHAR2(1);
235: l_msg_count NUMBER;

Line 232: l_country HZ_PARTIES.COUNTRY%TYPE;

228: l_postal_code HZ_PARTIES.POSTAL_CODE%TYPE;
229: l_province HZ_PARTIES.PROVINCE%TYPE;
230: l_state HZ_PARTIES.STATE%TYPE;
231: l_county HZ_PARTIES.COUNTY%TYPE;
232: l_country HZ_PARTIES.COUNTRY%TYPE;
233:
234: l_return_status VARCHAR2(1);
235: l_msg_count NUMBER;
236: l_msg_data NUMBER;

Line 1342: function GET_PERSON_ID (p_party_id in hz_parties.party_id%type) return number IS

1338: /**
1339: * Please refer to the package specifications for details
1340: */
1341:
1342: function GET_PERSON_ID (p_party_id in hz_parties.party_id%type) return number IS
1343: l_matches varchar2(5);
1344: l_person_id per_all_people_f.person_id%type;
1345: l_cursorid integer;
1346: l_blockstr varchar2(1000);