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

Line 227: FROM HZ_PARTIES hp1 -- Person

223: , X_USER_FAX_COUNTRY_CODE
224: , X_USER_FAX_AREA_CODE
225: , X_USER_FAX
226: , X_USER_FAX_EXTENSION
227: FROM HZ_PARTIES hp1 -- Person
228: , HZ_CONTACT_POINTS hc1 -- Phone
229: , HZ_CONTACT_POINTS hc3 -- Email
230: , HZ_CONTACT_POINTS hc4 -- Fax
231: , POS_SUPPLIER_USERS_V posv

Line 235: AND hc1.owner_table_name(+) = 'HZ_PARTIES'

231: , POS_SUPPLIER_USERS_V posv
232: WHERE hp1.party_id = x_user_party_id
233: AND hp1.party_id = posv.person_party_id
234: AND hp1.status = 'A'
235: AND hc1.owner_table_name(+) = 'HZ_PARTIES'
236: AND hc1.owner_table_id(+) = posv.rel_party_id
237: AND hc1.contact_point_type(+) = 'PHONE'
238: AND hc1.phone_line_type(+) = 'GEN'
239: AND hc1.status(+) = 'A'

Line 241: AND hc3.owner_table_name(+) = 'HZ_PARTIES'

237: AND hc1.contact_point_type(+) = 'PHONE'
238: AND hc1.phone_line_type(+) = 'GEN'
239: AND hc1.status(+) = 'A'
240: AND hc1.primary_flag(+) = 'Y'
241: AND hc3.owner_table_name(+) = 'HZ_PARTIES'
242: AND hc3.owner_table_id(+) = posv.rel_party_id
243: AND hc3.contact_point_type(+) = 'EMAIL'
244: AND hc3.primary_flag(+) = 'Y'
245: AND hc3.status(+) = 'A'

Line 246: AND hc4.owner_table_name(+) = 'HZ_PARTIES'

242: AND hc3.owner_table_id(+) = posv.rel_party_id
243: AND hc3.contact_point_type(+) = 'EMAIL'
244: AND hc3.primary_flag(+) = 'Y'
245: AND hc3.status(+) = 'A'
246: AND hc4.owner_table_name(+) = 'HZ_PARTIES'
247: AND hc4.owner_table_id(+) = posv.rel_party_id
248: AND hc4.contact_point_type(+) = 'PHONE'
249: AND hc4.phone_line_type(+) = 'FAX'
250: AND hc4.status(+) = 'A'

Line 293: FROM HZ_PARTIES hp1 -- Person

289: , X_USER_FAX_COUNTRY_CODE
290: , X_USER_FAX_AREA_CODE
291: , X_USER_FAX
292: , X_USER_FAX_EXTENSION
293: FROM HZ_PARTIES hp1 -- Person
294: , HZ_CONTACT_POINTS hc1 -- Phone
295: , HZ_CONTACT_POINTS hc3 -- Email
296: , HZ_CONTACT_POINTS hc4 -- Fax
297: , POS_SUPPLIER_USERS_V posv

Line 301: AND hc1.owner_table_name(+) = 'HZ_PARTIES'

297: , POS_SUPPLIER_USERS_V posv
298: WHERE hp1.party_id = x_user_party_id
299: AND hp1.party_id = posv.person_party_id
300: AND hp1.status = 'A'
301: AND hc1.owner_table_name(+) = 'HZ_PARTIES'
302: AND hc1.owner_table_id(+) = posv.rel_party_id
303: AND hc1.contact_point_type(+) = 'PHONE'
304: AND hc1.phone_line_type(+) = 'GEN'
305: AND hc1.status(+) = 'A'

Line 307: AND hc3.owner_table_name(+) = 'HZ_PARTIES'

303: AND hc1.contact_point_type(+) = 'PHONE'
304: AND hc1.phone_line_type(+) = 'GEN'
305: AND hc1.status(+) = 'A'
306: AND hc1.primary_flag(+) = 'Y'
307: AND hc3.owner_table_name(+) = 'HZ_PARTIES'
308: AND hc3.owner_table_id(+) = posv.rel_party_id
309: AND hc3.contact_point_type(+) = 'EMAIL'
310: AND hc3.primary_flag(+) = 'Y'
311: AND hc3.status(+) = 'A'

Line 312: AND hc4.owner_table_name(+) = 'HZ_PARTIES'

308: AND hc3.owner_table_id(+) = posv.rel_party_id
309: AND hc3.contact_point_type(+) = 'EMAIL'
310: AND hc3.primary_flag(+) = 'Y'
311: AND hc3.status(+) = 'A'
312: AND hc4.owner_table_name(+) = 'HZ_PARTIES'
313: AND hc4.owner_table_id(+) = posv.rel_party_id
314: AND hc4.contact_point_type(+) = 'PHONE'
315: AND hc4.phone_line_type(+) = 'FAX'
316: AND hc4.status(+) = 'A'

Line 429: --get rid of hz_parties row

425: --get rid of user profile
426: DELETE FROM hz_person_profiles
427: WHERE party_id = l_user_party_id;
428:
429: --get rid of hz_parties row
430: DELETE FROM hz_parties
431: WHERE party_id = l_user_party_id;
432:
433: --get rid of contact points

Line 430: DELETE FROM hz_parties

426: DELETE FROM hz_person_profiles
427: WHERE party_id = l_user_party_id;
428:
429: --get rid of hz_parties row
430: DELETE FROM hz_parties
431: WHERE party_id = l_user_party_id;
432:
433: --get rid of contact points
434: DELETE FROM hz_contact_points

Line 435: WHERE owner_table_name = 'HZ_PARTIES'

431: WHERE party_id = l_user_party_id;
432:
433: --get rid of contact points
434: DELETE FROM hz_contact_points
435: WHERE owner_table_name = 'HZ_PARTIES'
436: AND owner_table_id = l_user_party_id;
437:
438: x_status := 'S';
439: EXCEPTION

Line 869: FROM HZ_PARTIES hp1 -- Person

865: , X_USER_FAX_COUNTRY_CODE
866: , X_USER_FAX_AREA_CODE
867: , X_USER_FAX
868: , X_USER_FAX_EXTENSION
869: FROM HZ_PARTIES hp1 -- Person
870: , HZ_CONTACT_POINTS hc1 -- Phone
871: , HZ_CONTACT_POINTS hc3 -- Email
872: , HZ_CONTACT_POINTS hc4 -- Fax
873: WHERE hp1.party_id = x_user_party_id

Line 874: AND hc1.owner_table_name(+) = 'HZ_PARTIES'

870: , HZ_CONTACT_POINTS hc1 -- Phone
871: , HZ_CONTACT_POINTS hc3 -- Email
872: , HZ_CONTACT_POINTS hc4 -- Fax
873: WHERE hp1.party_id = x_user_party_id
874: AND hc1.owner_table_name(+) = 'HZ_PARTIES'
875: AND hc1.owner_table_id(+) = hp1.party_id
876: AND hc1.contact_point_type(+) = 'PHONE'
877: AND hc1.phone_line_type(+) = 'GEN'
878: AND hc1.status(+) = 'A'

Line 880: AND hc3.owner_table_name(+) = 'HZ_PARTIES'

876: AND hc1.contact_point_type(+) = 'PHONE'
877: AND hc1.phone_line_type(+) = 'GEN'
878: AND hc1.status(+) = 'A'
879: AND hc1.primary_flag(+) = 'Y'
880: AND hc3.owner_table_name(+) = 'HZ_PARTIES'
881: AND hc3.owner_table_id(+) = hp1.party_id
882: AND hc3.contact_point_type(+) = 'EMAIL'
883: AND hc3.EMAIL_FORMAT(+) = 'MAILTEXT'
884: AND hc3.status(+) = 'A'

Line 886: AND hc4.owner_table_name(+) = 'HZ_PARTIES'

882: AND hc3.contact_point_type(+) = 'EMAIL'
883: AND hc3.EMAIL_FORMAT(+) = 'MAILTEXT'
884: AND hc3.status(+) = 'A'
885: AND hc3.primary_flag(+) = 'Y'
886: AND hc4.owner_table_name(+) = 'HZ_PARTIES'
887: AND hc4.owner_table_id(+) = hp1.party_id
888: AND hc4.contact_point_type(+) = 'PHONE'
889: AND hc4.phone_line_type(+) = 'FAX'
890: AND hc4.status(+) = 'A'

Line 975: FROM HZ_PARTIES hp1 -- Person

971: , X_USER_NAME_M
972: , X_USER_NAME_L
973: , X_USER_NAME_SUFFIX
974: , X_USER_TITLE
975: FROM HZ_PARTIES hp1 -- Person
976: WHERE hp1.party_id = x_user_party_id
977: and hp1.status = 'A';
978:
979: begin