PACKAGE: APPS.FND_OAM_USER_INFO

Source

1 PACKAGE fnd_oam_user_info AUTHID CURRENT_USER AS
2 /* $Header: AFOAMUIS.pls 120.2 2005/10/20 12:30:51 ilawler noship $ */
3 -------------------------------------------------------------------------------
4 
5   -- Name
6   --   get_contact_info
7   --
8   -- Purpose
9   --   Returns the contact information of a user
10   --
11   -- Input Arguments
12   --   p_username - User name.
13   --
14   -- Output Arguments
15   --   full_name - Full name of the person
16   --   phone     - Phone number
17   --   email     - Email address
18   --   fax       - Fax number
19   --   user_guid - User_guid
20   --
21   PROCEDURE get_contact_info
22     (p_username IN VARCHAR2,
23      full_name  OUT NOCOPY VARCHAR2,
24      phone      OUT NOCOPY VARCHAR2,
25      email      OUT NOCOPY VARCHAR2,
26      fax        OUT NOCOPY VARCHAR2,
27      user_guid OUT  NOCOPY VARCHAR2);
28 
29   --
30   -- Return PARTY_ID given EMPLOYEE_ID
31   --
32   function GET_PARTY_ID(P_EMPLOYEE_ID in number) return number;
33 
34   --
35   -- Given PARTY_ID return PARTY_NAME, PARTY_TYPE
36   --
37   procedure HZ_PARTY_ID_TO_NAME(P_PARTY_ID in number,
38                                 P_PARTY_NAME out nocopy varchar2,
39                                 P_PARTY_TYPE out nocopy varchar2);
40 
41   --
42   -- Given PARTY_NAME return PARTY_ID, PARTY_TYPE
43   --
44   procedure HZ_PARTY_NAME_TO_ID(P_PARTY_NAME in varchar2,
45                                 P_PARTY_ID OUT NOCOPY number,
46                                 P_PARTY_TYPE out nocopy varchar2);
47 
48   --
49   -- Get organization party ID given customer party ID
50   --
51   function GET_ORGANIZATION_ID(P_CUSTOMER_ID in number) return number;
52 
53 END fnd_oam_user_info;