DBA Data[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;