70: -- Get the email address from the party relationship.
71: -- If email is still missing, then return null
72: --
73: -- IN
74: -- p_person_party_id - The party ID of the person defined in hz_parties table
75: -- OUT
76: -- x_email_address - Email address of the person
77:
78: Procedure Get_Party_Email_Address (p_person_party_id in hz_parties.party_id%type,
74: -- p_person_party_id - The party ID of the person defined in hz_parties table
75: -- OUT
76: -- x_email_address - Email address of the person
77:
78: Procedure Get_Party_Email_Address (p_person_party_id in hz_parties.party_id%type,
79: x_email_address out NOCOPY hz_parties.email_address%type);
80:
81:
82: FUNCTION GET_PERSON_EMAIL_ADDRESS(p_person_party_id in hz_parties.party_id%type) return varchar2;
75: -- OUT
76: -- x_email_address - Email address of the person
77:
78: Procedure Get_Party_Email_Address (p_person_party_id in hz_parties.party_id%type,
79: x_email_address out NOCOPY hz_parties.email_address%type);
80:
81:
82: FUNCTION GET_PERSON_EMAIL_ADDRESS(p_person_party_id in hz_parties.party_id%type) return varchar2;
83:
78: Procedure Get_Party_Email_Address (p_person_party_id in hz_parties.party_id%type,
79: x_email_address out NOCOPY hz_parties.email_address%type);
80:
81:
82: FUNCTION GET_PERSON_EMAIL_ADDRESS(p_person_party_id in hz_parties.party_id%type) return varchar2;
83:
84: --
85: -- Function
86: -- Register_Individual_User