1 PACKAGE PA_USER_ATTR_PUB AUTHID DEFINER AS
2 /* $Header: PAUATTPS.pls 115.9 2003/08/20 06:14:45 bchandra noship $ */
3
4
5 -- API name : COPY_USER_ATTRS_DATA
6 -- Type : Public
7 -- Pre-reqs : None.
8
9 PROCEDURE COPY_USER_ATTRS_DATA
10 ( p_api_version IN NUMBER := 1.0
11 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
12 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
13 ,p_debug_mode IN VARCHAR2 := 'N'
14 ,p_object_id_from IN NUMBER
15 ,p_object_id_to IN NUMBER
16 ,p_object_type IN VARCHAR2
17 ,x_return_status OUT NOCOPY VARCHAR2
18 ,x_errorcode OUT NOCOPY NUMBER
19 ,x_msg_count OUT NOCOPY NUMBER
20 ,x_msg_data OUT NOCOPY VARCHAR2
21 );
22
23
24 -- API name : DELETE_USER_ATTRS_DATA
25 -- Type : Public
26 -- Pre-reqs : None.
27
28 PROCEDURE DELETE_USER_ATTRS_DATA
29 ( p_api_version IN NUMBER := 1.0
30 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
31 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
32 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
33 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
34 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
35 ,p_debug_mode IN VARCHAR2 := 'N'
36 ,p_project_id IN NUMBER
37 ,p_proj_element_id IN NUMBER DEFAULT NULL
38 ,p_old_classification_id IN NUMBER
39 ,p_new_classification_id IN NUMBER DEFAULT NULL
40 ,p_classification_type IN VARCHAR2
41 ,x_return_status OUT NOCOPY VARCHAR2
42 ,x_msg_count OUT NOCOPY NUMBER
43 ,x_msg_data OUT NOCOPY VARCHAR2
44 );
45
46
47 -- API name : CHECK_DELETE_ASSOC_OK
48 -- Type : Public
49 -- Pre-reqs : None.
50
51 PROCEDURE CHECK_DELETE_ASSOC_OK
52 ( p_api_version IN NUMBER := 1.0
53 ,p_association_id IN NUMBER
54 ,p_classification_code IN VARCHAR2
55 ,p_data_level IN VARCHAR2
56 ,p_attr_group_id IN NUMBER
57 ,p_application_id IN NUMBER
58 ,p_attr_group_type IN VARCHAR2
59 ,p_attr_group_name IN VARCHAR2
60 ,p_enabled_code IN VARCHAR2
61 ,x_ok_to_delete OUT NOCOPY VARCHAR2
62 ,x_return_status OUT NOCOPY VARCHAR2
63 ,x_errorcode OUT NOCOPY NUMBER
64 ,x_msg_count OUT NOCOPY NUMBER
65 ,x_msg_data OUT NOCOPY VARCHAR2
66 );
67
68
69 -- API name : DELETE_ALL_USER_ATTRS_DATA
70 -- Type : Public
71 -- Pre-reqs : None.
72
73 PROCEDURE DELETE_ALL_USER_ATTRS_DATA
74 ( p_api_version IN NUMBER := 1.0
75 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
76 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
77 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
78 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
79 ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
80 ,p_debug_mode IN VARCHAR2 := 'N'
81 ,p_project_id IN NUMBER
82 ,p_proj_element_id IN NUMBER DEFAULT NULL
83 ,x_return_status OUT NOCOPY VARCHAR2
84 ,x_msg_count OUT NOCOPY NUMBER
85 ,x_msg_data OUT NOCOPY VARCHAR2
86 );
87
88 -- API name : Process_User_Attrs_Data
89 -- Type : Public
90 -- Pre-reqs : None.
91 -- Description : This API is a wrapper for the EGO API
92 -- EGO_USER_ATTRS_DATA_PUB.Process_User_Attr_Data
93 -- It performs the following operations:
94 -- 1. transpose data from the PA data structure
95 -- to a format that is understood by the EGO API
96 -- 2. Call the EGO api and return the results
97 PROCEDURE Process_User_Attrs_Data
98 ( p_api_version IN NUMBER := 1.0
99 , p_object_name IN VARCHAR2 := 'PA_PROJECTS'
100 , p_ext_attr_data_table IN PA_PROJECT_PUB.PA_EXT_ATTR_TABLE_TYPE
101 , p_project_id IN NUMBER := 0
102 , p_structure_type IN VARCHAR2 := 'FINANCIAL'
103 , p_entity_id IN NUMBER := NULL
104 , p_entity_index IN NUMBER := NULL
105 , p_entity_code IN VARCHAR2 := NULL
106 , p_debug_mode IN VARCHAR2 := 'N'
107 , p_debug_level IN NUMBER := 0
108 , p_init_error_handler IN VARCHAR2 := FND_API.G_FALSE
109 , p_write_to_concurrent_log IN VARCHAR2 := FND_API.G_FALSE
110 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
111 , p_log_errors IN VARCHAR2 := FND_API.G_FALSE
112 , p_commit IN VARCHAR2 := FND_API.G_FALSE
113 , x_failed_row_id_list OUT NOCOPY VARCHAR2
114 , x_return_status OUT NOCOPY VARCHAR2
115 , x_errorcode OUT NOCOPY NUMBER
116 , x_msg_count OUT NOCOPY NUMBER
117 , x_msg_data OUT NOCOPY VARCHAR2);
118
119
120 -- API name : Check_Class_Assoc_Exists
121 -- Type : Public
122 -- Pre-reqs : None.
123
124 PROCEDURE CHECK_CLASS_ASSOC_EXISTS
125 ( P_ROW_ID IN VARCHAR2
126 ,P_NEW_CLASS_CATEGORY IN VARCHAR2 DEFAULT NULL
127 ,P_NEW_CLASS_CODE IN VARCHAR2 DEFAULT NULL
128 ,P_MODE IN VARCHAR2
129 ,X_ASSOC_EXISTS OUT NOCOPY VARCHAR2 );
130
131
132 -- API name : Check_PT_Assoc_Exists
133 -- Type : Public
134 -- Pre-reqs : None.
135
136 PROCEDURE CHECK_PT_ASSOC_EXISTS
137 ( P_PROJECT_ID IN NUMBER
138 ,P_NEW_PROJECT_TYPE IN VARCHAR2
139 ,X_ASSOC_EXISTS OUT NOCOPY VARCHAR2 );
140
141 END PA_USER_ATTR_PUB;