1 PACKAGE OKC_ARTICLES_ALL_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKCVARTS.pls 120.2 2011/03/23 08:32:34 kkolukul ship $ */
3
4 ---------------------------------------------------------------------------
5 -- Procedures and Functions
6 ---------------------------------------------------------------------------
7
8 PROCEDURE insert_row(
9 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10 x_return_status OUT NOCOPY VARCHAR2,
11
12 p_article_id IN NUMBER := NULL,
13 p_article_title IN VARCHAR2,
14 p_org_id IN NUMBER,
15 p_article_number IN VARCHAR2,
16 p_standard_yn IN VARCHAR2,
17 p_article_intent IN VARCHAR2,
18 p_article_language IN VARCHAR2,
19 p_article_type IN VARCHAR2,
20 p_orig_system_reference_code IN VARCHAR2,
21 p_orig_system_reference_id1 IN VARCHAR2,
22 p_orig_system_reference_id2 IN VARCHAR2,
23 p_cz_transfer_status_flag IN VARCHAR2,
24 p_program_id IN NUMBER := NULL,
25 p_program_login_id IN NUMBER := NULL,
26 p_program_application_id IN NUMBER := NULL,
27 p_request_id IN NUMBER := NULL,
28
29 p_attribute_category IN VARCHAR2 := NULL,
30 p_attribute1 IN VARCHAR2 := NULL,
31 p_attribute2 IN VARCHAR2 := NULL,
32 p_attribute3 IN VARCHAR2 := NULL,
33 p_attribute4 IN VARCHAR2 := NULL,
34 p_attribute5 IN VARCHAR2 := NULL,
35 p_attribute6 IN VARCHAR2 := NULL,
36 p_attribute7 IN VARCHAR2 := NULL,
37 p_attribute8 IN VARCHAR2 := NULL,
38 p_attribute9 IN VARCHAR2 := NULL,
39 p_attribute10 IN VARCHAR2 := NULL,
40 p_attribute11 IN VARCHAR2 := NULL,
41 p_attribute12 IN VARCHAR2 := NULL,
42 p_attribute13 IN VARCHAR2 := NULL,
43 p_attribute14 IN VARCHAR2 := NULL,
44 p_attribute15 IN VARCHAR2 := NULL,
45
46 x_article_number OUT NOCOPY VARCHAR2,
47 x_article_id OUT NOCOPY NUMBER
48 );
49
50 PROCEDURE lock_row(
51 x_return_status OUT NOCOPY VARCHAR2,
52
53 p_article_id IN NUMBER,
54
55 p_object_version_number IN NUMBER
56 );
57
58 PROCEDURE update_row(
59 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
60 x_return_status OUT NOCOPY VARCHAR2,
61 x_article_intent OUT NOCOPY VARCHAR2,
62
63 p_article_id IN NUMBER,
64 p_article_title IN VARCHAR2,
65 p_org_id IN NUMBER,
66 p_article_number IN VARCHAR2,
67 p_standard_yn IN VARCHAR2,
68 p_article_intent IN VARCHAR2,
69 p_article_language IN VARCHAR2,
70 p_article_type IN VARCHAR2,
71 p_orig_system_reference_code IN VARCHAR2,
72 p_orig_system_reference_id1 IN VARCHAR2,
73 p_orig_system_reference_id2 IN VARCHAR2,
74 p_cz_transfer_status_flag IN VARCHAR2,
75 p_program_id IN NUMBER := NULL,
76 p_program_login_id IN NUMBER := NULL,
77 p_program_application_id IN NUMBER := NULL,
78 p_request_id IN NUMBER := NULL,
79
80 p_attribute_category IN VARCHAR2 := NULL,
81 p_attribute1 IN VARCHAR2 := NULL,
82 p_attribute2 IN VARCHAR2 := NULL,
83 p_attribute3 IN VARCHAR2 := NULL,
84 p_attribute4 IN VARCHAR2 := NULL,
85 p_attribute5 IN VARCHAR2 := NULL,
86 p_attribute6 IN VARCHAR2 := NULL,
87 p_attribute7 IN VARCHAR2 := NULL,
88 p_attribute8 IN VARCHAR2 := NULL,
89 p_attribute9 IN VARCHAR2 := NULL,
90 p_attribute10 IN VARCHAR2 := NULL,
91 p_attribute11 IN VARCHAR2 := NULL,
92 p_attribute12 IN VARCHAR2 := NULL,
93 p_attribute13 IN VARCHAR2 := NULL,
94 p_attribute14 IN VARCHAR2 := NULL,
95 p_attribute15 IN VARCHAR2 := NULL,
96
97 p_object_version_number IN NUMBER
98 );
99
100 PROCEDURE delete_row(
101 x_return_status OUT NOCOPY VARCHAR2,
102
103 p_article_id IN NUMBER,
104
105 p_object_version_number IN NUMBER
106 );
107
108 PROCEDURE validate_row(
109 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
110 p_import_action IN VARCHAR2 := NULL,
111 x_return_status OUT NOCOPY VARCHAR2,
112 p_article_id IN NUMBER,
113 p_article_title IN VARCHAR2,
114 p_org_id IN NUMBER,
115 p_article_number IN VARCHAR2,
116 p_standard_yn IN VARCHAR2,
117 p_article_intent IN VARCHAR2,
118 p_article_language IN VARCHAR2,
119 p_article_type IN VARCHAR2,
120 p_orig_system_reference_code IN VARCHAR2,
121 p_orig_system_reference_id1 IN VARCHAR2,
122 p_orig_system_reference_id2 IN VARCHAR2,
123 p_cz_transfer_status_flag IN VARCHAR2 := NULL,
124 p_program_id IN NUMBER := NULL,
125 p_program_login_id IN NUMBER := NULL,
126 p_program_application_id IN NUMBER := NULL,
127 p_request_id IN NUMBER := NULL,
128 p_attribute_category IN VARCHAR2 := NULL,
129 p_attribute1 IN VARCHAR2 := NULL,
130 p_attribute2 IN VARCHAR2 := NULL,
131 p_attribute3 IN VARCHAR2 := NULL,
132 p_attribute4 IN VARCHAR2 := NULL,
133 p_attribute5 IN VARCHAR2 := NULL,
134 p_attribute6 IN VARCHAR2 := NULL,
135 p_attribute7 IN VARCHAR2 := NULL,
136 p_attribute8 IN VARCHAR2 := NULL,
137 p_attribute9 IN VARCHAR2 := NULL,
138 p_attribute10 IN VARCHAR2 := NULL,
139 p_attribute11 IN VARCHAR2 := NULL,
140 p_attribute12 IN VARCHAR2 := NULL,
141 p_attribute13 IN VARCHAR2 := NULL,
142 p_attribute14 IN VARCHAR2 := NULL,
143 p_attribute15 IN VARCHAR2 := NULL,
144
145 p_object_version_number IN NUMBER := NULL
146 );
147
148 FUNCTION get_rec (
149 p_article_id IN NUMBER,
150
151 x_article_title OUT NOCOPY VARCHAR2,
152 x_org_id OUT NOCOPY NUMBER,
153 x_article_number OUT NOCOPY VARCHAR2,
154 x_standard_yn OUT NOCOPY VARCHAR2,
155 x_article_intent OUT NOCOPY VARCHAR2,
156 x_article_language OUT NOCOPY VARCHAR2,
157 x_article_type OUT NOCOPY VARCHAR2,
158 x_orig_system_reference_code OUT NOCOPY VARCHAR2,
159 x_orig_system_reference_id1 OUT NOCOPY VARCHAR2,
160 x_orig_system_reference_id2 OUT NOCOPY VARCHAR2,
161 x_cz_transfer_status_flag OUT NOCOPY VARCHAR2,
162 x_program_id OUT NOCOPY NUMBER,
163 x_program_login_id OUT NOCOPY NUMBER,
164 x_program_application_id OUT NOCOPY NUMBER,
165 x_request_id OUT NOCOPY NUMBER,
166 x_attribute_category OUT NOCOPY VARCHAR2,
167 x_attribute1 OUT NOCOPY VARCHAR2,
168 x_attribute2 OUT NOCOPY VARCHAR2,
169 x_attribute3 OUT NOCOPY VARCHAR2,
170 x_attribute4 OUT NOCOPY VARCHAR2,
171 x_attribute5 OUT NOCOPY VARCHAR2,
172 x_attribute6 OUT NOCOPY VARCHAR2,
173 x_attribute7 OUT NOCOPY VARCHAR2,
174 x_attribute8 OUT NOCOPY VARCHAR2,
175 x_attribute9 OUT NOCOPY VARCHAR2,
176 x_attribute10 OUT NOCOPY VARCHAR2,
177 x_attribute11 OUT NOCOPY VARCHAR2,
178 x_attribute12 OUT NOCOPY VARCHAR2,
179 x_attribute13 OUT NOCOPY VARCHAR2,
180 x_attribute14 OUT NOCOPY VARCHAR2,
181 x_attribute15 OUT NOCOPY VARCHAR2,
182 x_object_version_number OUT NOCOPY NUMBER,
183 x_created_by OUT NOCOPY NUMBER,
184 x_creation_date OUT NOCOPY DATE,
185 x_last_updated_by OUT NOCOPY NUMBER,
186 x_last_update_login OUT NOCOPY NUMBER,
187 x_last_update_date OUT NOCOPY DATE
188
189 ) RETURN VARCHAR2;
190
191 -- The following is a direct call to Validate Record without going through
192 -- get_rec as in validate_row. This API will be used by import and migration
193 -- only. In this API the actual values are being passed i.e. NULL is NULL and
194 -- hence should not be called with G_MISS_XXX
195
196 FUNCTION Validate_Record (
197 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
198 p_import_action IN VARCHAR2 := NULL,
199 p_article_id IN NUMBER,
200 p_article_title IN VARCHAR2,
201 p_org_id IN NUMBER,
202 p_article_number IN VARCHAR2,
203 p_standard_yn IN VARCHAR2,
204 p_article_intent IN VARCHAR2,
205 p_article_language IN VARCHAR2,
206 p_article_type IN VARCHAR2,
207 p_orig_system_reference_code IN VARCHAR2,
208 p_orig_system_reference_id1 IN VARCHAR2,
209 p_orig_system_reference_id2 IN VARCHAR2,
210 p_cz_transfer_status_flag IN VARCHAR2 := NULL,
211 p_program_id IN NUMBER := NULL,
212 p_program_login_id IN NUMBER := NULL,
213 p_program_application_id IN NUMBER := NULL,
214 p_request_id IN NUMBER := NULL,
215 p_attribute_category IN VARCHAR2,
216 p_attribute1 IN VARCHAR2,
217 p_attribute2 IN VARCHAR2,
218 p_attribute3 IN VARCHAR2,
219 p_attribute4 IN VARCHAR2,
220 p_attribute5 IN VARCHAR2,
221 p_attribute6 IN VARCHAR2,
222 p_attribute7 IN VARCHAR2,
223 p_attribute8 IN VARCHAR2,
224 p_attribute9 IN VARCHAR2,
225 p_attribute10 IN VARCHAR2,
226 p_attribute11 IN VARCHAR2,
227 p_attribute12 IN VARCHAR2,
228 p_attribute13 IN VARCHAR2,
229 p_attribute14 IN VARCHAR2,
230 p_attribute15 IN VARCHAR2
231 ) RETURN VARCHAR2;
232
233
234 END OKC_ARTICLES_ALL_PVT;