eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.CS_KB_ELEMENT_TYPES_PKG

Source


1 PACKAGE CS_KB_ELEMENT_TYPES_PKG AUTHID CURRENT_USER AS
2 /* $Header: cskbets.pls 115.7 2002/11/11 23:52:45 mkettle ship $ */
3 /*======================================================================+
4  |                Copyright (c) 1999 Oracle Corporation                 |
5  |                   Redwood Shores, California, USA                    |
6  |                        All rights reserved.                          |
7  +======================================================================+
8  | HISTORY                                                              |
9  |  18-OCT-1999 A. WONG Created                                         |
10  |  05-JAN-2000 HBALA   Added LOAD_ROW, TRANSLATE_ROW                   |
11  |  28-JAN-2000 ALAM    Modified the Delete_Element_Type function.      |
12  |  25-APR-2001 SKLEONG Modified the Delete_Element_Type function.      |
13  |  14-AUG-2002 KLOU  (SEDATE)                                          |
14  |              1. Add logic to handle new columns start_date_active and|
15  |                 end_date_active.                                     |
16  +======================================================================*/
17 
18 
19   /* for return status */
20   ERROR_STATUS      CONSTANT NUMBER      := -1;
21   OKAY_STATUS       CONSTANT NUMBER      := 0;
22 
23   /* for cs_kb_set_eles.assoc_degree  */
24   POSITIVE_ASSOC  	CONSTANT NUMBER      := 1;
25   NEGATIVE_ASSOC  	CONSTANT NUMBER      := -1;
26 
27   /* default increment for count */
28   COUNT_INCR  	CONSTANT NUMBER      := 1;
29   COUNT_INIT  	CONSTANT NUMBER      := 1;
30 
31 
32 FUNCTION Does_Ele_Type_Exist(
33   p_element_type_id in number
34 ) return varchar2;
35 
36 FUNCTION Create_Element_Type(
37   p_name in varchar2,
38   p_desc in varchar2,
39   P_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
40   P_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
41   P_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
42   P_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
43   P_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
44   P_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
45   P_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
46   P_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
47   P_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
48   P_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
49   P_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
50   P_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
51   P_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
52   P_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
53   P_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
54   P_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
55   P_START_DATE  in DATE     DEFAULT NULL,
56   P_END_DATE    in DATE     DEFAULT NULL
57 ) return number;
58 
59 FUNCTION Update_Element_Type(
60   p_element_type_id in number,
61   p_name in varchar2,
62   p_desc in varchar2,
63   P_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
64   P_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
65   P_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
66   P_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
67   P_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
68   P_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
69   P_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
70   P_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
71   P_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
72   P_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
73   P_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
74   P_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
75   P_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
76   P_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
77   P_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
78   P_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
79   P_START_DATE  in DATE     DEFAULT NULL,
80   P_END_DATE    in DATE     DEFAULT NULL
81 ) return number;
82 
83 FUNCTION Delete_Element_Type(
84   p_element_type_id in number
85 ) return number;
86 
87 procedure INSERT_ROW (
88   X_ROWID in OUT NOCOPY VARCHAR2,
89   X_ELEMENT_TYPE_ID in NUMBER,
90   X_ELEMENT_TYPE_NAME in VARCHAR2,
91   X_NAME in VARCHAR2,
92   X_DESCRIPTION in VARCHAR2,
93   X_CREATION_DATE in DATE,
94   X_CREATED_BY in NUMBER,
95   X_LAST_UPDATE_DATE in DATE,
96   X_LAST_UPDATED_BY in NUMBER,
97   X_LAST_UPDATE_LOGIN in NUMBER,
98   X_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
99   X_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
100   X_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
101   X_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
102   X_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
103   X_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
104   X_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
105   X_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
106   X_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
107   X_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
108   X_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
109   X_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
110   X_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
111   X_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
112   X_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
113   X_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
114   X_START_DATE  in DATE     DEFAULT NULL,
115   X_END_DATE    in DATE     DEFAULT NULL
116 );
117 
118 procedure LOCK_ROW (
119   X_ELEMENT_TYPE_ID in NUMBER,
120   X_ELEMENT_TYPE_NAME in VARCHAR2,
121   X_NAME in VARCHAR2,
122   X_DESCRIPTION in VARCHAR2,
123   X_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
124   X_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
125   X_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
126   X_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
127   X_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
128   X_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
129   X_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
130   X_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
131   X_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
132   X_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
133   X_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
134   X_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
135   X_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
136   X_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
137   X_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
138   X_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
139   X_START_DATE  in DATE     DEFAULT NULL,
140   X_END_DATE    in DATE     DEFAULT NULL
141 );
142 
143 procedure UPDATE_ROW (
144   X_ELEMENT_TYPE_ID in NUMBER,
145   X_ELEMENT_TYPE_NAME in VARCHAR2,
146   X_NAME in VARCHAR2,
147   X_DESCRIPTION in VARCHAR2,
148   X_LAST_UPDATE_DATE in DATE,
149   X_LAST_UPDATED_BY in NUMBER,
150   X_LAST_UPDATE_LOGIN in NUMBER,
151   X_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
152   X_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
153   X_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
154   X_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
155   X_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
156   X_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
157   X_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
158   X_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
159   X_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
160   X_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
161   X_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
162   X_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
163   X_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
164   X_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
165   X_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
166   X_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
167   X_START_DATE  in DATE     DEFAULT NULL,
168   X_END_DATE    in DATE     DEFAULT NULL
169 );
170 
171 procedure DELETE_ROW (
172   X_ELEMENT_TYPE_ID in NUMBER
173 );
174 
175 procedure ADD_LANGUAGE;
176 
177 PROCEDURE TRANSLATE_ROW(
178         x_element_type_id in number,
179 	x_owner in varchar2,
180         x_name in varchar2,
181         x_description in varchar2);
182 
183 PROCEDURE LOAD_ROW(
184         x_element_type_id in number,
185 	x_owner in varchar2,
186         x_name in varchar2,
187         x_description in varchar2);
188 
189 end CS_KB_ELEMENT_TYPES_PKG;