[Home] [Help]
PACKAGE: APPS.CS_KB_SET_USED_HISTS_PKG
Source
1 PACKAGE CS_KB_SET_USED_HISTS_PKG AUTHID CURRENT_USER AS
2 /* $Header: cskbsuhs.pls 115.3 2002/02/01 17:24:28 pkm ship $ */
3
4 /* for return status */
5 ERROR_STATUS CONSTANT NUMBER := -1;
6 OKAY_STATUS CONSTANT NUMBER := 0;
7
8
9 function Create_Set_Used_History(
10 P_SET_ID in NUMBER,
11 P_HISTORY_ID in NUMBER,
12 P_USED_TYPE in VARCHAR2 DEFAULT NULL,
13 P_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
14 P_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
15 P_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
16 P_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
17 P_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
18 P_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
19 P_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
20 P_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
21 P_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
22 P_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
23 P_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
24 P_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
25 P_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
26 P_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
27 P_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
28 P_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL
29 ) return number;
30
31
32 function Update_Set_Used_History(
33 P_SET_ID in NUMBER,
34 P_HISTORY_ID in NUMBER,
35 P_USED_TYPE in VARCHAR2 DEFAULT NULL,
36 P_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
37 P_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
38 P_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
39 P_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
40 P_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
41 P_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
42 P_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
43 P_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
44 P_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
45 P_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
46 P_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
47 P_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
48 P_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
49 P_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
50 P_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
51 P_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL
52 ) return number;
53
54
55 function Delete_Set_Used_History (
56 P_SET_ID in NUMBER,
57 P_HISTORY_ID in NUMBER
58 ) return number;
59
60
61 end CS_KB_SET_USED_HISTS_PKG;