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 207: from hz_parties

203:
204: cursor get_address_info is
205: select ADDRESS1, ADDRESS2, ADDRESS3, ADDRESS4, CITY,
206: POSTAL_CODE, PROVINCE, STATE, COUNTY, COUNTRY
207: from hz_parties
208: where party_id = p_party_id;
209:
210: l_address1 HZ_PARTIES.ADDRESS1%TYPE;
211: l_address2 HZ_PARTIES.ADDRESS2%TYPE;

Line 210: l_address1 HZ_PARTIES.ADDRESS1%TYPE;

206: POSTAL_CODE, PROVINCE, STATE, COUNTY, COUNTRY
207: from hz_parties
208: where party_id = p_party_id;
209:
210: l_address1 HZ_PARTIES.ADDRESS1%TYPE;
211: l_address2 HZ_PARTIES.ADDRESS2%TYPE;
212: l_address3 HZ_PARTIES.ADDRESS3%TYPE;
213: l_address4 HZ_PARTIES.ADDRESS4%TYPE;
214: l_city HZ_PARTIES.CITY%TYPE;

Line 211: l_address2 HZ_PARTIES.ADDRESS2%TYPE;

207: from hz_parties
208: where party_id = p_party_id;
209:
210: l_address1 HZ_PARTIES.ADDRESS1%TYPE;
211: l_address2 HZ_PARTIES.ADDRESS2%TYPE;
212: l_address3 HZ_PARTIES.ADDRESS3%TYPE;
213: l_address4 HZ_PARTIES.ADDRESS4%TYPE;
214: l_city HZ_PARTIES.CITY%TYPE;
215: l_postal_code HZ_PARTIES.POSTAL_CODE%TYPE;

Line 212: l_address3 HZ_PARTIES.ADDRESS3%TYPE;

208: where party_id = p_party_id;
209:
210: l_address1 HZ_PARTIES.ADDRESS1%TYPE;
211: l_address2 HZ_PARTIES.ADDRESS2%TYPE;
212: l_address3 HZ_PARTIES.ADDRESS3%TYPE;
213: l_address4 HZ_PARTIES.ADDRESS4%TYPE;
214: l_city HZ_PARTIES.CITY%TYPE;
215: l_postal_code HZ_PARTIES.POSTAL_CODE%TYPE;
216: l_province HZ_PARTIES.PROVINCE%TYPE;

Line 213: l_address4 HZ_PARTIES.ADDRESS4%TYPE;

209:
210: l_address1 HZ_PARTIES.ADDRESS1%TYPE;
211: l_address2 HZ_PARTIES.ADDRESS2%TYPE;
212: l_address3 HZ_PARTIES.ADDRESS3%TYPE;
213: l_address4 HZ_PARTIES.ADDRESS4%TYPE;
214: l_city HZ_PARTIES.CITY%TYPE;
215: l_postal_code HZ_PARTIES.POSTAL_CODE%TYPE;
216: l_province HZ_PARTIES.PROVINCE%TYPE;
217: l_state HZ_PARTIES.STATE%TYPE;

Line 214: l_city HZ_PARTIES.CITY%TYPE;

210: l_address1 HZ_PARTIES.ADDRESS1%TYPE;
211: l_address2 HZ_PARTIES.ADDRESS2%TYPE;
212: l_address3 HZ_PARTIES.ADDRESS3%TYPE;
213: l_address4 HZ_PARTIES.ADDRESS4%TYPE;
214: l_city HZ_PARTIES.CITY%TYPE;
215: l_postal_code HZ_PARTIES.POSTAL_CODE%TYPE;
216: l_province HZ_PARTIES.PROVINCE%TYPE;
217: l_state HZ_PARTIES.STATE%TYPE;
218: l_county HZ_PARTIES.COUNTY%TYPE;

Line 215: l_postal_code HZ_PARTIES.POSTAL_CODE%TYPE;

211: l_address2 HZ_PARTIES.ADDRESS2%TYPE;
212: l_address3 HZ_PARTIES.ADDRESS3%TYPE;
213: l_address4 HZ_PARTIES.ADDRESS4%TYPE;
214: l_city HZ_PARTIES.CITY%TYPE;
215: l_postal_code HZ_PARTIES.POSTAL_CODE%TYPE;
216: l_province HZ_PARTIES.PROVINCE%TYPE;
217: l_state HZ_PARTIES.STATE%TYPE;
218: l_county HZ_PARTIES.COUNTY%TYPE;
219: l_country HZ_PARTIES.COUNTRY%TYPE;

Line 216: l_province HZ_PARTIES.PROVINCE%TYPE;

212: l_address3 HZ_PARTIES.ADDRESS3%TYPE;
213: l_address4 HZ_PARTIES.ADDRESS4%TYPE;
214: l_city HZ_PARTIES.CITY%TYPE;
215: l_postal_code HZ_PARTIES.POSTAL_CODE%TYPE;
216: l_province HZ_PARTIES.PROVINCE%TYPE;
217: l_state HZ_PARTIES.STATE%TYPE;
218: l_county HZ_PARTIES.COUNTY%TYPE;
219: l_country HZ_PARTIES.COUNTRY%TYPE;
220:

Line 217: l_state HZ_PARTIES.STATE%TYPE;

213: l_address4 HZ_PARTIES.ADDRESS4%TYPE;
214: l_city HZ_PARTIES.CITY%TYPE;
215: l_postal_code HZ_PARTIES.POSTAL_CODE%TYPE;
216: l_province HZ_PARTIES.PROVINCE%TYPE;
217: l_state HZ_PARTIES.STATE%TYPE;
218: l_county HZ_PARTIES.COUNTY%TYPE;
219: l_country HZ_PARTIES.COUNTRY%TYPE;
220:
221: l_return_status VARCHAR2(1);

Line 218: l_county HZ_PARTIES.COUNTY%TYPE;

214: l_city HZ_PARTIES.CITY%TYPE;
215: l_postal_code HZ_PARTIES.POSTAL_CODE%TYPE;
216: l_province HZ_PARTIES.PROVINCE%TYPE;
217: l_state HZ_PARTIES.STATE%TYPE;
218: l_county HZ_PARTIES.COUNTY%TYPE;
219: l_country HZ_PARTIES.COUNTRY%TYPE;
220:
221: l_return_status VARCHAR2(1);
222: l_msg_count NUMBER;

Line 219: l_country HZ_PARTIES.COUNTRY%TYPE;

215: l_postal_code HZ_PARTIES.POSTAL_CODE%TYPE;
216: l_province HZ_PARTIES.PROVINCE%TYPE;
217: l_state HZ_PARTIES.STATE%TYPE;
218: l_county HZ_PARTIES.COUNTY%TYPE;
219: l_country HZ_PARTIES.COUNTRY%TYPE;
220:
221: l_return_status VARCHAR2(1);
222: l_msg_count NUMBER;
223: l_msg_data NUMBER;

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

1323: /**
1324: * Please refer to the package specifications for details
1325: */
1326:
1327: function GET_PERSON_ID (p_party_id in hz_parties.party_id%type) return number IS
1328: l_matches varchar2(5);
1329: l_person_id per_all_people_f.person_id%type;
1330: l_cursorid integer;
1331: l_blockstr varchar2(1000);