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_LINKS_PKG

Source


1 PACKAGE CS_KB_SET_LINKS_PKG AS
2 /* $Header: cskbsls.pls 120.1 2005/07/27 19:05:06 appldev ship $ */
3 
4   /* for return status */
5   ERROR_STATUS      CONSTANT NUMBER      := -1;
6   OKAY_STATUS       CONSTANT NUMBER      := 0;
7 
8 function Clone_Link(
9 P_SET_SOURCE_ID in NUMBER,
10 P_SET_TARGET_ID in NUMBER
11 )return number;
12 
13 procedure Create_Set_Link(
14   P_LINK_TYPE in VARCHAR,
15   P_OBJECT_CODE in VARCHAR,
16   P_SET_ID in NUMBER,
17   P_OTHER_ID in NUMBER,
18   P_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
19   P_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
20   P_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
21   P_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
22   P_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
23   P_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
24   P_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
25   P_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
26   P_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
27   P_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
28   P_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
29   P_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
30   P_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
31   P_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
32   P_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
33   P_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
34   x_link_id         in OUT NOCOPY           NUMBER,
35   x_return_status      OUT NOCOPY           VARCHAR2,
36   x_msg_data           OUT NOCOPY           VARCHAR2,
37   x_msg_count          OUT NOCOPY           NUMBER
38   );
39 
40 function Create_Set_Link(
41   P_LINK_TYPE in VARCHAR,
42   P_OBJECT_CODE in VARCHAR,
43   P_SET_ID in NUMBER,
44   P_OTHER_ID in NUMBER,
45   P_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
46   P_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
47   P_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
48   P_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
49   P_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
50   P_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
51   P_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
52   P_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
53   P_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
54   P_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
55   P_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
56   P_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
57   P_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
58   P_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
59   P_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
60   P_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL
61 ) return number;
62 
63 procedure Create_Set_Ext_Link(
64   P_LINK_TYPE in VARCHAR,
65   P_OBJECT_CODE in VARCHAR,
66   P_SET_ID in NUMBER,
67   P_OTHER_ID in NUMBER,
68   P_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
69   P_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
70   P_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
71   P_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
72   P_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
73   P_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
74   P_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
75   P_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
76   P_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
77   P_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
78   P_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
79   P_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
80   P_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
81   P_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
82   P_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
83   P_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
84   x_link_id         in OUT NOCOPY           NUMBER,
85   x_return_status      OUT NOCOPY           VARCHAR2,
86   x_msg_data           OUT NOCOPY           VARCHAR2,
87   x_msg_count          OUT NOCOPY           NUMBER
88   );
89 
90 procedure Update_Set_Link(
91   P_LINK_ID in NUMBER,
92   P_LINK_TYPE in VARCHAR,
93   P_OBJECT_CODE in VARCHAR,
94   P_SET_ID in NUMBER,
95   P_OTHER_ID in NUMBER,
96   P_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
97   P_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
98   P_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
99   P_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
100   P_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
101   P_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
102   P_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
103   P_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
104   P_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
105   P_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
106   P_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
107   P_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
108   P_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
109   P_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
110   P_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
111   P_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
112   x_return_status OUT NOCOPY VARCHAR2,
113   x_msg_data      OUT NOCOPY VARCHAR2,
114   x_msg_count     OUT NOCOPY NUMBER
115   );
116 
117 function Update_Set_Link(
118   P_LINK_ID in NUMBER,
119   P_LINK_TYPE in VARCHAR,
120   P_OBJECT_CODE in VARCHAR,
121   P_SET_ID in NUMBER,
122   P_OTHER_ID in NUMBER,
123   P_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
124   P_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
125   P_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
126   P_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
127   P_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
128   P_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
129   P_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
130   P_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
131   P_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
132   P_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
133   P_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
134   P_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
135   P_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
136   P_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
137   P_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
138   P_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL
139 ) return number;
140 
141 function Delete_Set_Link_W_Obj_Code (
142   p_set_id        in Number,
143   p_object_code   in Varchar2,
144   p_other_id      in Number
145 ) return number;
146 
147 function Delete_Set_Link (
148   P_LINK_ID in NUMBER
149 ) return number;
150 
151 procedure INSERT_ROW (
152   X_ROWID in OUT NOCOPY VARCHAR2,
153   X_LINK_ID in NUMBER,
154   X_LINK_TYPE in VARCHAR2,
155   X_OBJECT_CODE in VARCHAR2,
156   X_SET_ID in NUMBER,
157   X_OTHER_ID in NUMBER,
158   X_CREATION_DATE in DATE,
159   X_CREATED_BY in NUMBER,
160   X_LAST_UPDATE_DATE in DATE,
161   X_LAST_UPDATED_BY in NUMBER,
162   X_LAST_UPDATE_LOGIN in NUMBER,
163   X_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
164   X_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
165   X_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
166   X_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
167   X_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
168   X_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
169   X_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
170   X_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
171   X_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
172   X_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
173   X_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
174   X_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
175   X_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
176   X_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
177   X_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
178   X_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL);
179 
180 procedure UPDATE_ROW (
181   X_LINK_ID in NUMBER,
182   X_LINK_TYPE in VARCHAR2,
183   X_OBJECT_CODE in VARCHAR2,
184   X_SET_ID in NUMBER,
185   X_OTHER_ID in NUMBER,
186   X_LAST_UPDATE_DATE in DATE,
187   X_LAST_UPDATED_BY in NUMBER,
188   X_LAST_UPDATE_LOGIN in NUMBER,
189   X_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
190   X_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
191   X_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
192   X_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
193   X_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
194   X_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
195   X_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
196   X_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
197   X_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
198   X_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
199   X_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
200   X_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
201   X_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
202   X_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
203   X_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
204   X_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL
205 );
206 
207 procedure Raise_Solution_Linked_Event(
208    p_set_id NUMBER,
209    p_object_code VARCHAR2,
210    p_object_id   VARCHAR2,
211    p_link_id     NUMBER,
212    p_link_type   VARCHAR2,
213    p_event_date  DATE );
214 
215 procedure Raise_Soln_Link_Updated_Event(
216    p_set_id            NUMBER,
217    p_object_code       VARCHAR2,
218    p_object_id         VARCHAR2,
219    p_link_id           NUMBER,
220    p_link_type         VARCHAR2,
221    p_event_date        DATE );
222 
223 function Create_Set_Link(
224   P_OBJECT_CODE in VARCHAR,
225   P_SET_ID in NUMBER,
226   P_OTHER_ID in NUMBER,
227   P_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
228   P_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
229   P_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
230   P_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
231   P_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
232   P_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
233   P_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
234   P_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
235   P_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
236   P_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
237   P_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
238   P_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
239   P_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
240   P_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
241   P_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
242   P_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL
243 ) return number;
244 
245 end CS_KB_SET_LINKS_PKG;