[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;