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_SET_TYPES_PKG

Source


1 PACKAGE CS_KB_SET_TYPES_PKG AUTHID CURRENT_USER AS
2 /* $Header: cskbsts.pls 115.6 2002/11/11 23:53:31 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  |  29-JAN-2000 ALAM    Added parameter name to create/update func.     |
11  |  14-AUG-2002 KLOU  (SEDATE)                                          |
12  |              1. Add new parameters p_start_date and p_end_date.      |
13  +======================================================================*/
14 
15 
16   /* for return status */
17   ERROR_STATUS      CONSTANT NUMBER      := -1;
18   OKAY_STATUS       CONSTANT NUMBER      := 0;
19 
20   /* for cs_kb_set_eles.assoc_degree  */
21   POSITIVE_ASSOC  	CONSTANT NUMBER      := 1;
22   NEGATIVE_ASSOC  	CONSTANT NUMBER      := -1;
23 
24   /* default increment for count */
25   COUNT_INCR  	CONSTANT NUMBER      := 1;
26   COUNT_INIT  	CONSTANT NUMBER      := 1;
27 
28 
29 FUNCTION Create_Set_Type(
30   p_name in varchar2,
31   p_desc in varchar2,
32   P_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
33   P_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
34   P_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
35   P_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
36   P_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
37   P_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
38   P_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
39   P_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
40   P_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
41   P_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
42   P_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
43   P_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
44   P_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
45   P_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
46   P_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
47   P_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
48   P_START_DATE  in DATE     DEFAULT NULL,
49   P_END_DATE    in DATE     DEFAULT NULL
50 ) return number;
51 
52 FUNCTION Update_Set_Type(
53   p_set_type_id in number,
54   p_name in varchar2,
55   p_desc in varchar2,
56   P_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
57   P_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
58   P_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
59   P_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
60   P_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
61   P_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
62   P_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
63   P_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
64   P_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
65   P_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
66   P_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
67   P_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
68   P_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
69   P_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
70   P_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
71   P_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
72   P_START_DATE  in DATE     DEFAULT NULL,
73   P_END_DATE    in DATE     DEFAULT NULL
74 ) return number;
75 
76 FUNCTION Delete_Set_Type(
77   p_set_type_id in number
78 ) return number;
79 
80 
81 procedure INSERT_ROW (
82   X_ROWID in OUT NOCOPY VARCHAR2,
83   X_SET_TYPE_ID in NUMBER,
84   X_SET_TYPE_NAME in VARCHAR2,
85   X_NAME in VARCHAR2,
86   X_DESCRIPTION in VARCHAR2,
87   X_CREATION_DATE in DATE,
88   X_CREATED_BY in NUMBER,
89   X_LAST_UPDATE_DATE in DATE,
90   X_LAST_UPDATED_BY in NUMBER,
91   X_LAST_UPDATE_LOGIN in NUMBER,
92   X_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
93   X_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
94   X_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
95   X_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
96   X_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
97   X_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
98   X_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
99   X_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
100   X_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
101   X_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
102   X_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
103   X_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
104   X_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
105   X_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
106   X_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
107   X_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
108   X_START_DATE  in DATE     DEFAULT NULL,
109   X_END_DATE    in DATE     DEFAULT NULL
110 );
111 
112 procedure LOCK_ROW (
113   X_SET_TYPE_ID in NUMBER,
114   X_SET_TYPE_NAME in VARCHAR2,
115   X_NAME in VARCHAR2,
116   X_DESCRIPTION in VARCHAR2,
117   X_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
118   X_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
119   X_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
120   X_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
121   X_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
122   X_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
123   X_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
124   X_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
125   X_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
126   X_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
127   X_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
128   X_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
129   X_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
130   X_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
131   X_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
132   X_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
133   X_START_DATE  in DATE     DEFAULT NULL,
134   X_END_DATE    in DATE     DEFAULT NULL
135 );
136 
137 procedure UPDATE_ROW (
138   X_SET_TYPE_ID in NUMBER,
139   X_SET_TYPE_NAME in VARCHAR2,
140   X_NAME in VARCHAR2,
141   X_DESCRIPTION in VARCHAR2,
142   X_LAST_UPDATE_DATE in DATE,
143   X_LAST_UPDATED_BY in NUMBER,
144   X_LAST_UPDATE_LOGIN in NUMBER,
145   X_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
146   X_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
147   X_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
148   X_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
149   X_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
150   X_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
151   X_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
152   X_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
153   X_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
154   X_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
155   X_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
156   X_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
157   X_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
158   X_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
159   X_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
160   X_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
161   X_START_DATE  in DATE     DEFAULT NULL,
162   X_END_DATE    in DATE     DEFAULT NULL
163 );
164 
165 procedure DELETE_ROW (
166   X_SET_TYPE_ID in NUMBER
167 );
168 
169 procedure ADD_LANGUAGE;
170 
171 PROCEDURE TRANSLATE_ROW(
172         x_set_type_id in number,
173 	x_owner in varchar2,
174         x_name in varchar2,
175         x_description in varchar2);
176 
177 PROCEDURE LOAD_ROW(
178         x_set_type_id in number,
179 	x_owner in varchar2,
180         x_name in varchar2,
181         x_description in varchar2);
182 
183 end CS_KB_SET_TYPES_PKG;