1 PACKAGE ENG_TYPE_CONFIGURATION_PKG AUTHID CURRENT_USER AS
2 /* $Header: ENGTYCONS.pls 115.0 2003/10/15 14:31:22 asjohal noship $ */
3 /*---------------------------------------------------------------------------+
4 | This package contains public API for Search Framework |
5 +---------------------------------------------------------------------------*/
6
7
8 PROCEDURE create_type_config
9 (
10 X_CUSTOMIZATION_APPLICATION_ID IN NUMBER,
11 X_CUSTOMIZATION_CODE IN VARCHAR2,
12 X_REGION_APPLICATION_ID IN NUMBER,
13 X_REGION_CODE IN VARCHAR2,
14 X_NAME IN VARCHAR2,
15 X_CREATED_BY IN NUMBER,
16 X_CREATION_DATE IN DATE,
17 X_LAST_UPDATED_BY IN NUMBER,
18 X_LAST_UPDATE_DATE IN DATE,
19 X_LAST_UPDATE_LOGIN IN NUMBER,
20 X_CLASSIFICATION_1 IN VARCHAR2 DEFAULT NULL,
21 X_CLASSIFICATION_2 IN VARCHAR2 DEFAULT NULL,
22 X_CLASSIFICATION_3 IN VARCHAR2 DEFAULT NULL,
23 X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
24 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
25 X_ERRORCODE OUT NOCOPY NUMBER
26 );
27
28 PROCEDURE update_type_Config
29 (
30 X_CUSTOMIZATION_APPLICATION_ID IN NUMBER,
31 X_CUSTOMIZATION_CODE IN VARCHAR2,
32 X_REGION_APPLICATION_ID IN NUMBER,
33 X_REGION_CODE IN VARCHAR2,
34 X_NAME IN VARCHAR2,
35 X_LAST_UPDATED_BY IN NUMBER,
36 X_LAST_UPDATE_DATE IN DATE,
37 X_LAST_UPDATE_LOGIN IN NUMBER,
38 X_CLASSIFICATION_1 IN VARCHAR2 DEFAULT NULL,
39 X_CLASSIFICATION_2 IN VARCHAR2 DEFAULT NULL,
40 X_CLASSIFICATION_3 IN VARCHAR2 DEFAULT NULL,
41 X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
42 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
43 X_ERRORCODE OUT NOCOPY NUMBER
44 );
45
46
47 PROCEDURE delete_type_config
48 (
49 X_CUSTOMIZATION_APPLICATION_ID IN NUMBER,
50 X_CUSTOMIZATION_CODE IN VARCHAR2,
51 X_REGION_APPLICATION_ID IN NUMBER,
52 X_REGION_CODE IN VARCHAR2,
53 X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
54 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
55 X_ERRORCODE OUT NOCOPY NUMBER
56 );
57
58 ---------------------------------------------------------
59
60
61 PROCEDURE create_Primary_Attribute
62 (
63 X_CUSTOMIZATION_APPLICATION_ID IN NUMBER,
64 X_CUSTOMIZATION_CODE IN VARCHAR2,
65 X_REGION_APPLICATION_ID IN NUMBER,
66 X_REGION_CODE IN VARCHAR2,
67 X_ATTRIBUTE_APPLICATION_ID IN NUMBER,
68 X_ATTRIBUTE_CODE IN VARCHAR2,
69 X_DISPLAY_SEQUENCE IN NUMBER,
70 X_ORDER_SEQUENCE IN NUMBER,
71 X_ORDER_DIRECTION IN VARCHAR2,
72 X_COLUMN_NAME IN VARCHAR2 := NULL,
73 X_SHOW_TOTAL IN VARCHAR2 := NULL,
74 X_CREATED_BY IN NUMBER,
75 X_CREATION_DATE IN DATE,
76 X_LAST_UPDATED_BY IN NUMBER,
77 X_LAST_UPDATE_DATE IN DATE,
78 X_LAST_UPDATE_LOGIN IN NUMBER,
79 X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
80 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
81 X_ERRORCODE OUT NOCOPY NUMBER
82 );
83
84 PROCEDURE update_Primary_Attribute
85 (
86 X_CUSTOMIZATION_APPLICATION_ID IN NUMBER,
87 X_CUSTOMIZATION_CODE IN VARCHAR2,
88 X_REGION_APPLICATION_ID IN NUMBER,
89 X_REGION_CODE IN VARCHAR2,
90 X_ATTRIBUTE_APPLICATION_ID IN NUMBER,
91 X_ATTRIBUTE_CODE IN VARCHAR2,
92 X_DISPLAY_SEQUENCE IN NUMBER,
93 X_ORDER_SEQUENCE IN NUMBER,
94 X_ORDER_DIRECTION IN VARCHAR2,
95 X_COLUMN_NAME IN VARCHAR2 := NULL,
96 X_SHOW_TOTAL IN VARCHAR2 := NULL,
97 X_LAST_UPDATED_BY IN NUMBER,
98 X_LAST_UPDATE_DATE IN DATE,
99 X_LAST_UPDATE_LOGIN IN NUMBER,
100 X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
101 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
102 X_ERRORCODE OUT NOCOPY NUMBER
103 );
104
105 PROCEDURE delete_Primary_Attribute
106 (
107 X_CUSTOMIZATION_APPLICATION_ID IN NUMBER,
108 X_CUSTOMIZATION_CODE IN VARCHAR2,
109 X_REGION_APPLICATION_ID IN NUMBER,
110 X_REGION_CODE IN VARCHAR2,
111 X_ATTRIBUTE_APPLICATION_ID IN NUMBER,
112 X_ATTRIBUTE_CODE IN VARCHAR2,
113 X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
114 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
115 X_ERRORCODE OUT NOCOPY NUMBER
116 );
117
118 ---------------------------------------------------------
119
120
121 PROCEDURE create_config_section
122 (
123 X_CUSTOMIZATION_APPLICATION_ID IN NUMBER,
124 X_CUSTOMIZATION_CODE IN VARCHAR2,
125 X_REGION_APPLICATION_ID IN NUMBER,
126 X_REGION_CODE IN VARCHAR2,
127 X_ATTRIBUTE_APPLICATION_ID IN NUMBER,
128 X_ATTRIBUTE_CODE IN VARCHAR2,
129 X_DISPLAY_SEQUENCE IN NUMBER,
130 X_CREATED_BY IN NUMBER,
131 X_CREATION_DATE IN DATE,
132 X_LAST_UPDATED_BY IN NUMBER,
133 X_LAST_UPDATE_DATE IN DATE,
134 X_LAST_UPDATE_LOGIN IN NUMBER,
135 X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
136 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
137 X_ERRORCODE OUT NOCOPY NUMBER
138 );
139
140 PROCEDURE update_config_section
141 (
142 X_CUSTOMIZATION_APPLICATION_ID IN NUMBER,
143 X_CUSTOMIZATION_CODE IN VARCHAR2,
144 X_REGION_APPLICATION_ID IN NUMBER,
145 X_REGION_CODE IN VARCHAR2,
146 X_ATTRIBUTE_APPLICATION_ID IN NUMBER,
147 X_ATTRIBUTE_CODE IN VARCHAR2,
148 X_DISPLAY_SEQUENCE IN NUMBER,
149 X_LAST_UPDATED_BY IN NUMBER,
150 X_LAST_UPDATE_DATE IN DATE,
151 X_LAST_UPDATE_LOGIN IN NUMBER,
152 X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
153 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
154 X_ERRORCODE OUT NOCOPY NUMBER
155 );
156
157 PROCEDURE delete_config_section
158 (
159 X_CUSTOMIZATION_APPLICATION_ID IN NUMBER,
160 X_CUSTOMIZATION_CODE IN VARCHAR2,
161 X_REGION_APPLICATION_ID IN NUMBER,
162 X_REGION_CODE IN VARCHAR2,
163 X_ATTRIBUTE_APPLICATION_ID IN NUMBER,
164 X_ATTRIBUTE_CODE IN VARCHAR2,
165 X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
166 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
167 X_ERRORCODE OUT NOCOPY NUMBER
168 );
169
170 PROCEDURE Check_Configuration_delete
171 (
172 X_CUSTOMIZATION_APPLICATION_ID IN NUMBER,
173 X_CUSTOMIZATION_CODE IN VARCHAR2,
174 X_REGION_APPLICATION_ID IN NUMBER,
175 X_REGION_CODE IN VARCHAR2,
176 X_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
177 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
178 X_ERRORCODE OUT NOCOPY NUMBER
179 );
180
181 END ENG_TYPE_CONFIGURATION_PKG;