[Home] [Help]
PACKAGE: APPS.CS_KB_SOLUTION_PVT
Source
1 PACKAGE CS_KB_SOLUTION_PVT AUTHID CURRENT_USER AS
2 /* $Header: cskvsols.pls 120.1.12010000.2 2008/09/12 05:52:58 mmaiya ship $ */
3
4 --for RETURN status
5 ERROR_STATUS CONSTANT NUMBER := -1;
6
7 --Exceptions
8 INVALID_CATEGORY_ID EXCEPTION;
9 INVALID_SET_CATEGORY_LINK EXCEPTION;
10
11
12 PROCEDURE Get_Set_Details(
13 P_SET_ID IN NUMBER,
14 X_SET_NUMBER OUT NOCOPY VARCHAR2,
15 X_STATUS OUT NOCOPY VARCHAR2,
16 X_FLOW_DETAILS_ID OUT NOCOPY NUMBER,
17 X_LOCKED_BY OUT NOCOPY NUMBER );
18
19 FUNCTION Get_Set_Number(
20 P_SET_ID IN NUMBER)
21 RETURN VARCHAR2;
22
23 FUNCTION Get_Latest_Version_Id(
24 P_SET_NUMBER IN VARCHAR2)
25 RETURN NUMBER;
26
27 FUNCTION Get_Published_Set_Id(
28 P_SET_NUMBER IN VARCHAR2)
29 RETURN NUMBER;
30
31 FUNCTION Get_Obsoleted_Set_Id(
32 P_SET_NUMBER IN VARCHAR2)
33 RETURN NUMBER;
34
35 FUNCTION Get_Solution_Title(
36 P_SET_ID IN NUMBER)
37 RETURN VARCHAR2;
38
39 FUNCTION Locked_By(
40 P_SET_NUMBER IN VARCHAR2)
41 RETURN NUMBER;
42
43 FUNCTION Locked_By(
44 P_SET_ID IN NUMBER)
45 RETURN NUMBER;
46
47 PROCEDURE Outdate_Solution(
48 P_SET_NUMBER IN VARCHAR2,
49 P_CURRENT_SET_ID IN NUMBER);
50
51 FUNCTION Clone_Solution(
52 P_SET_NUMBER IN VARCHAR2,
53 P_STATUS IN VARCHAR2,
54 P_FLOW_DETAILS_ID IN NUMBER,
55 P_LOCKED_BY IN NUMBER )
56 RETURN NUMBER; --set_id
57
58 PROCEDURE Get_Lock_Info(
59 P_SET_NUMBER IN VARCHAR2,
60 X_LOCKED_BY OUT NOCOPY NUMBER,
61 X_LOCK_DATE OUT NOCOPY DATE);
62
63 -- Api's used in 11.5.10 by OAF:
64
65 PROCEDURE Snatch_Lock_From_User(
66 P_SET_ID IN NUMBER,
67 P_SET_NUMBER IN VARCHAR2,
68 P_USER_ID IN NUMBER,
69 P_LOCKED_BY IN NUMBER,
70 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
71 X_MSG_DATA OUT NOCOPY VARCHAR2,
72 X_MSG_COUNT OUT NOCOPY NUMBER);
73
74 PROCEDURE Create_Solution(
75 X_SET_ID IN OUT NOCOPY NUMBER,
76 P_SET_TYPE_ID IN NUMBER,
77 P_NAME IN VARCHAR2,
78 P_STATUS IN VARCHAR2 DEFAULT NULL,
79 P_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
80 P_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
81 P_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
82 P_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
83 P_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
84 P_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
85 P_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
86 P_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
87 P_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
88 P_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
89 P_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
90 P_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
91 P_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
92 P_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
93 P_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
94 P_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
95 X_SET_NUMBER OUT NOCOPY VARCHAR2,
96 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
97 X_MSG_DATA OUT NOCOPY VARCHAR2,
98 X_MSG_COUNT OUT NOCOPY NUMBER,
99 P_VISIBILITY_ID IN NUMBER DEFAULT NULL );
100
101 PROCEDURE Update_Solution(
102 P_SET_ID IN NUMBER,
103 P_SET_NUMBER IN VARCHAR2,
104 P_SET_TYPE_ID IN NUMBER,
105 P_NAME IN VARCHAR2,
106 P_STATUS IN VARCHAR2,
107 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
108 P_ATTRIBUTE1 IN VARCHAR2,
109 P_ATTRIBUTE2 IN VARCHAR2,
110 P_ATTRIBUTE3 IN VARCHAR2,
111 P_ATTRIBUTE4 IN VARCHAR2,
112 P_ATTRIBUTE5 IN VARCHAR2,
113 P_ATTRIBUTE6 IN VARCHAR2,
114 P_ATTRIBUTE7 IN VARCHAR2,
115 P_ATTRIBUTE8 IN VARCHAR2,
116 P_ATTRIBUTE9 IN VARCHAR2,
117 P_ATTRIBUTE10 IN VARCHAR2,
118 P_ATTRIBUTE11 IN VARCHAR2,
119 P_ATTRIBUTE12 IN VARCHAR2,
120 P_ATTRIBUTE13 IN VARCHAR2,
121 P_ATTRIBUTE14 IN VARCHAR2,
122 P_ATTRIBUTE15 IN VARCHAR2,
123 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
124 X_MSG_DATA OUT NOCOPY VARCHAR2,
125 X_MSG_COUNT OUT NOCOPY NUMBER,
126 P_VISIBILITY_ID IN NUMBER DEFAULT NULL );
127
128
129 PROCEDURE Submit_Solution(
130 P_SET_NUMBER IN VARCHAR2,
131 P_SET_ID IN NUMBER ,
132 P_NEW_STEP IN NUMBER ,
133 X_RETURN OUT NOCOPY NUMBER,
134 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
135 X_MSG_DATA OUT NOCOPY VARCHAR2,
136 X_MSG_COUNT OUT NOCOPY NUMBER );
137
138 FUNCTION Get_User_Soln_Access (
139 P_SET_ID IN NUMBER,
140 P_SET_NUMBER IN VARCHAR2 )
141 RETURN VARCHAR2;
142
143 PROCEDURE CheckOut_Solution(
144 P_SET_ID IN NUMBER ,
145 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
146 X_MSG_DATA OUT NOCOPY VARCHAR2,
147 X_MSG_COUNT OUT NOCOPY NUMBER );
148
149 PROCEDURE Move_Solutions(
150 p_api_version in number,
151 p_init_msg_list in varchar2 := FND_API.G_FALSE,
152 p_commit in varchar2 := FND_API.G_FALSE,
153 p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
154 x_return_status OUT NOCOPY varchar2,
155 x_msg_count OUT NOCOPY number,
156 x_msg_data OUT NOCOPY varchar2,
157 P_SET_IDS IN JTF_NUMBER_TABLE,
158 P_SRC_CAT_ID IN NUMBER,
159 P_DEST_CAT_ID IN NUMBER
160 );
161
162 --Start Bugfix 7117546
163 PROCEDURE unlock_solution
164 (
165 p_set_id IN NUMBER,
166 p_commit IN VARCHAR2 DEFAULT 'N',
167 x_return_status OUT NOCOPY VARCHAR2,
168 x_msg_data OUT NOCOPY VARCHAR2,
169 x_msg_count OUT NOCOPY NUMBER);
170
171 --End Bugfix 7117546
172
173 END CS_KB_SOLUTION_PVT;