DBA Data[Home] [Help]

PACKAGE: APPS.ICX_CAT_ATTRIBUTES_PVT

Source


1 PACKAGE ICX_CAT_ATTRIBUTES_PVT AS
2     /* $Header: ICXVATRS.pls 120.1 2005/10/22 05:19:12 srmani noship $ */
3 
4     PROCEDURE INSERT_ROW(X_ROWID                  IN OUT NOCOPY VARCHAR2,
5                          X_ATTRIBUTE_ID           IN NUMBER,
6                          X_KEY                    IN VARCHAR2,
7                          X_ATTRIBUTE_NAME         IN VARCHAR2,
8                          X_DESCRIPTION            IN VARCHAR2,
9                          X_RT_CATEGORY_ID         IN NUMBER,
10                          X_TYPE                   IN NUMBER,
11                          X_SEARCH_RESULTS_VISIBLE IN VARCHAR2,
12                          X_ITEM_DETAIL_VISIBLE    IN VARCHAR2,
13                          X_SEARCHABLE             IN NUMBER,
14                          X_SEQUENCE               IN NUMBER,
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_REQUEST_ID             IN NUMBER,
21                          X_PROGRAM_APPLICATION_ID IN NUMBER,
22                          X_PROGRAM_ID             IN NUMBER,
23                          X_STORED_IN_TABLE        IN VARCHAR2,
24                          X_STORED_IN_COLUMN       IN VARCHAR2,
25                          X_SECTION_TAG            IN NUMBER);
26 
27     PROCEDURE LOCK_ROW(X_ATTRIBUTE_ID           IN NUMBER,
28                        X_KEY                    IN VARCHAR2,
29                        X_ATTRIBUTE_NAME         IN VARCHAR2,
30                        X_DESCRIPTION            IN VARCHAR2,
31                        X_RT_CATEGORY_ID         IN NUMBER,
32                        X_TYPE                   IN NUMBER,
33                        X_SEARCH_RESULTS_VISIBLE IN VARCHAR2,
34                        X_ITEM_DETAIL_VISIBLE    IN VARCHAR2,
35                        X_SEARCHABLE             IN NUMBER,
36                        X_SEQUENCE               IN NUMBER);
37 
38     PROCEDURE UPDATE_ROW(X_ATTRIBUTE_ID           IN NUMBER,
39                          X_KEY                    IN VARCHAR2,
40                          X_ATTRIBUTE_NAME         IN VARCHAR2,
41                          X_DESCRIPTION            IN VARCHAR2,
42                          X_RT_CATEGORY_ID         IN NUMBER,
43                          X_TYPE                   IN NUMBER,
44                          X_SEARCH_RESULTS_VISIBLE IN VARCHAR2,
45                          X_ITEM_DETAIL_VISIBLE    IN VARCHAR2,
46                          X_SEARCHABLE             IN NUMBER,
47                          X_SEQUENCE               IN NUMBER,
48                          X_LAST_UPDATED_BY        IN NUMBER,
49                          X_LAST_UPDATE_DATE       IN DATE,
50                          X_LAST_UPDATE_LOGIN      IN NUMBER,
51                          X_REQUEST_ID             IN NUMBER,
52                          X_PROGRAM_APPLICATION_ID IN NUMBER,
53                          X_PROGRAM_ID             IN NUMBER,
54                          X_STORED_IN_TABLE        IN VARCHAR2,
55                          X_STORED_IN_COLUMN       IN VARCHAR2,
56                          X_SECTION_TAG            IN NUMBER);
57 
58     PROCEDURE DELETE_ROW(X_ATTRIBUTE_ID IN NUMBER);
59 
60     PROCEDURE TRANSLATE_ROW(X_ATTRIBUTE_ID      IN VARCHAR2,
61                             X_OWNER             IN VARCHAR2,
62                             X_ATTRIBUTE_NAME    IN VARCHAR2,
63                             X_DESCRIPTION       IN VARCHAR2,
64                             X_CUSTOM_MODE       IN VARCHAR2,
65                             X_LAST_UPDATE_DATE  IN VARCHAR2);
66 
67     PROCEDURE LOAD_ROW(X_ATTRIBUTE_ID           IN VARCHAR2,
68                        X_OWNER                  IN VARCHAR2,
69                        X_KEY                    IN VARCHAR2,
70                        X_ATTRIBUTE_NAME         IN VARCHAR2,
71                        X_DESCRIPTION            IN VARCHAR2,
72                        X_CATEGORY_ID            IN VARCHAR2,
73                        X_TYPE                   IN VARCHAR2,
74                        X_SEARCH_RESULTS_VISIBLE IN VARCHAR2,
75                        X_ITEM_DETAIL_VISIBLE    IN VARCHAR2,
76                        X_SEARCHABLE             IN VARCHAR2,
77                        X_SEQUENCE               IN VARCHAR2,
78                        X_STORED_IN_TABLE        IN VARCHAR2,
79                        X_STORED_IN_COLUMN       IN VARCHAR2,
80                        X_SECTION_TAG            IN NUMBER,
81                        X_CUSTOM_MODE            IN VARCHAR2,
82                        X_LAST_UPDATE_DATE       IN VARCHAR2);
83 
84     PROCEDURE ADD_LANGUAGE;
85 
86 END ICX_CAT_ATTRIBUTES_PVT;
87