DBA Data[Home] [Help]

PACKAGE: APPS.JTF_UM_RESP_INFO_PVT

Source


1 PACKAGE JTF_UM_RESP_INFO_PVT AUTHID CURRENT_USER as
2 /*$Header: JTFVRESS.pls 115.3 2002/11/21 22:57:58 kching ship $*/
3 
4 
5 TYPE RESP_INFO_SOURCE IS RECORD
6 (
7   RESP_ID        NUMBER                                         := FND_API.G_MISS_NUM,
8   APP_ID         NUMBER                                         := FND_API.G_MISS_NUM,
9   RESP_NAME      FND_RESPONSIBILITY_VL.RESPONSIBILITY_NAME%TYPE := FND_API.G_MISS_CHAR,
10   RESP_KEY      FND_RESPONSIBILITY_VL.RESPONSIBILITY_KEY%TYPE  := FND_API.G_MISS_CHAR,
11   RESP_SOURCE    VARCHAR2(4000)                                 := FND_API.G_MISS_CHAR
12 );
13 
14 TYPE RESP_INFO_TABLE_TYPE IS TABLE OF RESP_INFO_SOURCE INDEX BY BINARY_INTEGER;
15 
16 /**
17   * Procedure   :  GET_RESP_INFO_SOURCE
18   * Type        :  Private
19   * Pre_reqs    :  None
20   * Description :  Returns the responsibility details and source for a user
21   * Parameters  :
22   * input parameters
23   * @param     p_user_name
24   *     description:  The user_name of a user
25   *     required   :  Y
26   *     validation :  Must be a valid user name
27   * output parameters
28   *   x_result: RESP_INFO_TABLE_TYPE
29  */
30 procedure GET_RESP_INFO_SOURCE(
31                        p_user_id      in number,
32                        x_result       out NOCOPY RESP_INFO_TABLE_TYPE
33                        );
34 
35 end JTF_UM_RESP_INFO_PVT;