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