1 PACKAGE PA_USER_ATTR_PVT AUTHID CURRENT_USER AS
2 /* $Header: PAUATTVS.pls 115.2 2003/08/21 05:58:50 sacgupta noship $ */
3
4 -- API name : DELETE_USER_ATTRS_DATA
5 -- Type : Public
6 -- Pre-reqs : None.
7
8 PROCEDURE DELETE_USER_ATTRS_DATA
9 ( p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
10 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
11 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
12 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
13 ,p_debug_mode IN VARCHAR2 := 'N'
14 ,p_project_id IN NUMBER
15 ,p_proj_element_id IN NUMBER DEFAULT NULL
16 ,p_old_classification_id IN NUMBER
17 ,p_new_classification_id IN NUMBER DEFAULT NULL
18 ,p_classification_type IN VARCHAR2
19 ,x_return_status OUT NOCOPY VARCHAR2
20 ,x_msg_count OUT NOCOPY NUMBER
21 ,x_msg_data OUT NOCOPY VARCHAR2
22 );
23
24
25 PROCEDURE DELETE_ALL_USER_ATTRS_DATA
26 ( p_api_version IN NUMBER := 1.0
27 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
28 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
29 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
30 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
31 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
32 ,p_debug_mode IN VARCHAR2 := 'N'
33 ,p_project_id IN NUMBER
34 ,p_proj_element_id IN NUMBER DEFAULT NULL
35 ,x_return_status OUT NOCOPY VARCHAR2
36 ,x_msg_count OUT NOCOPY NUMBER
37 ,x_msg_data OUT NOCOPY VARCHAR2
38 );
39
40
41 END PA_USER_ATTR_PVT;