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_CONTACT_POINTS

Line 228: , HZ_CONTACT_POINTS hc1 -- Phone

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
232: WHERE hp1.party_id = x_user_party_id

Line 229: , HZ_CONTACT_POINTS hc3 -- Email

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
232: WHERE hp1.party_id = x_user_party_id
233: AND hp1.party_id = posv.person_party_id

Line 230: , HZ_CONTACT_POINTS hc4 -- 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
232: WHERE hp1.party_id = x_user_party_id
233: AND hp1.party_id = posv.person_party_id
234: AND hp1.status = 'A'

Line 294: , HZ_CONTACT_POINTS hc1 -- Phone

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
298: WHERE hp1.party_id = x_user_party_id

Line 295: , HZ_CONTACT_POINTS hc3 -- Email

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
298: WHERE hp1.party_id = x_user_party_id
299: AND hp1.party_id = posv.person_party_id

Line 296: , HZ_CONTACT_POINTS hc4 -- 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
298: WHERE hp1.party_id = x_user_party_id
299: AND hp1.party_id = posv.person_party_id
300: AND hp1.status = 'A'

Line 434: DELETE FROM hz_contact_points

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
435: WHERE owner_table_name = 'HZ_PARTIES'
436: AND owner_table_id = l_user_party_id;
437:
438: x_status := 'S';

Line 870: , HZ_CONTACT_POINTS hc1 -- Phone

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
874: AND hc1.owner_table_name(+) = 'HZ_PARTIES'

Line 871: , HZ_CONTACT_POINTS hc3 -- Email

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
874: AND hc1.owner_table_name(+) = 'HZ_PARTIES'
875: AND hc1.owner_table_id(+) = hp1.party_id

Line 872: , HZ_CONTACT_POINTS hc4 -- 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
874: AND hc1.owner_table_name(+) = 'HZ_PARTIES'
875: AND hc1.owner_table_id(+) = hp1.party_id
876: AND hc1.contact_point_type(+) = 'PHONE'