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