APPS.HZ_UI_UTIL_PKG dependencies on HZ_FORMAT_PUB

Line 438: SELECT hz_format_pub.format_address ( hps.LOCATION_ID , null , null ,' , ' , null , null , null , null )

434: BEGIN
435:
436: IF p_cust_acct_id IS NOT NULL THEN
437: BEGIN
438: SELECT hz_format_pub.format_address ( hps.LOCATION_ID , null , null ,' , ' , null , null , null , null )
439: INTO x_billto_address
440: FROM HZ_PARTY_SITES hps , HZ_CUST_ACCT_SITES_ALL hcas
441: WHERE hcas.BILL_TO_FLAG='P'
442: AND hcas.CUST_ACCOUNT_ID = p_cust_acct_id

Line 463: hz_format_pub.format_address(p_location_id, null, null, ', ');

459: END IF;
460:
461: IF p_location_id IS NOT NULL THEN
462: x_formatted_address :=
463: hz_format_pub.format_address(p_location_id, null, null, ', ');
464: END IF;
465:
466: IF p_act_cont_role_id IS NOT NULL THEN
467: x_act_contact_roles := hz_act_util_pub.get_act_contact_roles(p_act_cont_role_id);

Line 490: SELECT HZ_FORMAT_PUB.format_address(party_site.location_id, null, null, ', ')

486:
487: IF p_cust_acct_site_id IS NOT NULL
488: THEN
489: BEGIN
490: SELECT HZ_FORMAT_PUB.format_address(party_site.location_id, null, null, ', ')
491: ||decode(acct.PARTY_ID,
492: party_site.PARTY_ID,'',
493: ' ('||(select party.PARTY_NAME
494: from HZ_PARTIES party, HZ_RELATIONSHIPS reln