[Home] [Help]
PACKAGE: APPS.CS_KB_SET_RECS_PKG
Source
1 PACKAGE CS_KB_SET_RECS_PKG AUTHID CURRENT_USER AS
2 /* $Header: cskbsrs.pls 115.6 2003/08/30 00:50:27 speng ship $ */
3
4 /* for return status */
5 ERROR_STATUS CONSTANT NUMBER := -1;
6 OKAY_STATUS CONSTANT NUMBER := 0;
7
8
9 PROCEDURE Move_Up_Solution_Rec
10 ( p_set_rec_id in number,
11 x_ret_status out nocopy varchar2,
12 x_msg_count out nocopy number,
13 x_msg_data out nocopy varchar2 );
14
15 PROCEDURE Move_Down_Solution_Rec
16 ( p_set_rec_id in number,
17 x_ret_status out nocopy varchar2,
18 x_msg_count out nocopy number,
19 x_msg_data out nocopy varchar2 );
20
21 PROCEDURE Create_Set_Rec
22 ( P_SET_REC_ID in NUMBER DEFAULT NULL,
23 P_SET_NUMBER in VARCHAR2,
24 P_SET_ORDER in NUMBER DEFAULT NULL,
25 P_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
26 P_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
27 P_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
28 P_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
29 P_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
30 P_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
31 P_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
32 P_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
33 P_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
34 P_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
35 P_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
36 P_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
37 P_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
38 P_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
39 P_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
40 P_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
41 X_SET_REC_ID out nocopy NUMBER,
42 X_RET_STATUS out nocopy VARCHAR2,
43 X_MSG_COUNT out nocopy NUMBER,
44 X_MSG_DATA out nocopy VARCHAR2 );
45
46 procedure Update_Set_Rec
47 ( P_SET_REC_ID in NUMBER,
48 P_SET_NUMBER in VARCHAR2,
49 P_SET_ORDER in NUMBER,
50 P_ATTRIBUTE_CATEGORY in VARCHAR2 DEFAULT NULL,
51 P_ATTRIBUTE1 in VARCHAR2 DEFAULT NULL,
52 P_ATTRIBUTE2 in VARCHAR2 DEFAULT NULL,
53 P_ATTRIBUTE3 in VARCHAR2 DEFAULT NULL,
54 P_ATTRIBUTE4 in VARCHAR2 DEFAULT NULL,
55 P_ATTRIBUTE5 in VARCHAR2 DEFAULT NULL,
56 P_ATTRIBUTE6 in VARCHAR2 DEFAULT NULL,
57 P_ATTRIBUTE7 in VARCHAR2 DEFAULT NULL,
58 P_ATTRIBUTE8 in VARCHAR2 DEFAULT NULL,
59 P_ATTRIBUTE9 in VARCHAR2 DEFAULT NULL,
60 P_ATTRIBUTE10 in VARCHAR2 DEFAULT NULL,
61 P_ATTRIBUTE11 in VARCHAR2 DEFAULT NULL,
62 P_ATTRIBUTE12 in VARCHAR2 DEFAULT NULL,
63 P_ATTRIBUTE13 in VARCHAR2 DEFAULT NULL,
64 P_ATTRIBUTE14 in VARCHAR2 DEFAULT NULL,
65 P_ATTRIBUTE15 in VARCHAR2 DEFAULT NULL,
66 X_RET_STATUS out nocopy VARCHAR2,
67 X_MSG_COUNT out nocopy NUMBER,
68 X_MSG_DATA out nocopy VARCHAR2 );
69
70 PROCEDURE Delete_Set_Rec
71 ( p_set_rec_id in number,
72 x_ret_status out nocopy varchar2,
73 x_msg_count out nocopy number,
74 x_msg_data out nocopy varchar2 );
75
76 end CS_KB_SET_RECS_PKG;