Main Tables Views Indexes Constraints Triggers Procedures Functions Packages Sanity check Index

ACS3 Data Model

Arguments Source

USER_CONTACT_SUMMARY

Arguments:

NameData TypeDefault ValueIn/Out
V_USER_IDINTEGER(38.0) IN

Returns:

VARCHAR2

Source

Source
     1: function user_contact_summary (v_user_id IN integer)
     2: return varchar
     3: as
     4:   contact_row		users_contact%ROWTYPE;
     5: begin
     6:   select * into contact_row from users_contact where user_id = v_user_id;
     7:   IF contact_row.m_address = 'w' THEN
     8:     -- they prefer to receive mail at work
     9:     return contact_row.wa_line1 || ' ' || contact_row.wa_line2 || ' ' || contact_row.wa_city || ', ' || contact_row.wa_state || contact_row.wa_postal_code || ' ' || contact_row.wa_country_code;
    10:   ELSE
    11:     return contact_row.ha_line1 || ' ' || contact_row.ha_line2 || ' ' || contact_row.ha_city || ', ' || contact_row.ha_state || contact_row.ha_postal_code || ' ' || contact_row.ha_country_code;
    12:   END IF;
    13: end user_contact_summary;


Generated by OraSchemaDoc, (c) Aram Kananov, 2002