DBA Data[Home] [Help]

APPS.CS_KNOWLEDGE_PVT dependencies on CS_KB_NUMBER_TBL_TYPE

Line 131: p_id_tbl in cs_kb_number_tbl_type,

127: )return varchar2;
128:
129:
130: FUNCTION Concat_Ids(
131: p_id_tbl in cs_kb_number_tbl_type,
132: p_separator in varchar2
133: ) return varchar2;
134:
135: FUNCTION Concat_Ids(

Line 165: p_ele_id_tbl in cs_kb_number_tbl_type

161: );
162:
163:
164: FUNCTION Do_Elements_Exist_In_Set (
165: p_ele_id_tbl in cs_kb_number_tbl_type
166: ) return varchar2;
167:
168: FUNCTION Get_External_Obj_Names(
169: p_obj_code_tbl in jtf_varchar2_table_100,

Line 182: -- p_ele_id_tbl in cs_kb_number_tbl_type,

178: --) return number;
179:
180: --FUNCTION Change_Element_Assoc(
181: -- p_set_id in number,
182: -- p_ele_id_tbl in cs_kb_number_tbl_type,
183: -- p_assoc_tbl in cs_kb_varchar100_tbl_type --N = neg, P=positive
184: --) return number;
185:
186: FUNCTION Del_Element_From_Set(

Line 218: p_other_id_tbl in cs_kb_number_tbl_type,

214: x_msg_data OUT NOCOPY varchar2,
215: p_usage_code in varchar2,
216: p_id in number,
217: p_object_code in varchar2,
218: p_other_id_tbl in cs_kb_number_tbl_type,
219: p_other_code_tbl in cs_kb_varchar100_tbl_type
220: );
221:
222: --

Line 233: -- p_link_id_tbl in cs_kb_number_tbl_type,

229: -- p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
230: -- x_return_status OUT NOCOPY varchar2,
231: -- x_msg_count OUT NOCOPY number,
232: -- x_msg_data OUT NOCOPY varchar2,
233: -- p_link_id_tbl in cs_kb_number_tbl_type,
234: -- p_set_type_id_tbl in cs_kb_number_tbl_type
235: --);
236:
237: PROCEDURE Change_Ele_Type_Links(

Line 234: -- p_set_type_id_tbl in cs_kb_number_tbl_type

230: -- x_return_status OUT NOCOPY varchar2,
231: -- x_msg_count OUT NOCOPY number,
232: -- x_msg_data OUT NOCOPY varchar2,
233: -- p_link_id_tbl in cs_kb_number_tbl_type,
234: -- p_set_type_id_tbl in cs_kb_number_tbl_type
235: --);
236:
237: PROCEDURE Change_Ele_Type_Links(
238: p_api_version in number,

Line 245: p_link_id_tbl in cs_kb_number_tbl_type,

241: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
242: x_return_status OUT NOCOPY varchar2,
243: x_msg_count OUT NOCOPY number,
244: x_msg_data OUT NOCOPY varchar2,
245: p_link_id_tbl in cs_kb_number_tbl_type,
246: p_ele_type_id_tbl in cs_kb_number_tbl_type
247: );
248: --
249: -- Update or Delete setlinks

Line 246: p_ele_type_id_tbl in cs_kb_number_tbl_type

242: x_return_status OUT NOCOPY varchar2,
243: x_msg_count OUT NOCOPY number,
244: x_msg_data OUT NOCOPY varchar2,
245: p_link_id_tbl in cs_kb_number_tbl_type,
246: p_ele_type_id_tbl in cs_kb_number_tbl_type
247: );
248: --
249: -- Update or Delete setlinks
250: -- (used when del set)

Line 260: p_link_id_tbl in cs_kb_number_tbl_type,

256: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
257: x_return_status OUT NOCOPY varchar2,
258: x_msg_count OUT NOCOPY number,
259: x_msg_data OUT NOCOPY varchar2,
260: p_link_id_tbl in cs_kb_number_tbl_type,
261: p_set_id_tbl in cs_kb_number_tbl_type
262: );
263:
264: PROCEDURE Change_Element_Links(

Line 261: p_set_id_tbl in cs_kb_number_tbl_type

257: x_return_status OUT NOCOPY varchar2,
258: x_msg_count OUT NOCOPY number,
259: x_msg_data OUT NOCOPY varchar2,
260: p_link_id_tbl in cs_kb_number_tbl_type,
261: p_set_id_tbl in cs_kb_number_tbl_type
262: );
263:
264: PROCEDURE Change_Element_Links(
265: p_api_version in number,

Line 272: p_link_id_tbl in cs_kb_number_tbl_type,

268: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
269: x_return_status OUT NOCOPY varchar2,
270: x_msg_count OUT NOCOPY number,
271: x_msg_data OUT NOCOPY varchar2,
272: p_link_id_tbl in cs_kb_number_tbl_type,
273: p_element_id_tbl in cs_kb_number_tbl_type
274: );
275:
276: PROCEDURE Change_Element_To_Sets(

Line 273: p_element_id_tbl in cs_kb_number_tbl_type

269: x_return_status OUT NOCOPY varchar2,
270: x_msg_count OUT NOCOPY number,
271: x_msg_data OUT NOCOPY varchar2,
272: p_link_id_tbl in cs_kb_number_tbl_type,
273: p_element_id_tbl in cs_kb_number_tbl_type
274: );
275:
276: PROCEDURE Change_Element_To_Sets(
277: p_api_version in number,

Line 285: p_set_id_tbl in cs_kb_number_tbl_type,

281: x_return_status OUT NOCOPY varchar2,
282: x_msg_count OUT NOCOPY number,
283: x_msg_data OUT NOCOPY varchar2,
284: p_element_id in number,
285: p_set_id_tbl in cs_kb_number_tbl_type,
286: p_new_ele_id_tbl in cs_kb_number_tbl_type
287: );
288: --
289: -- Creation APIs using records

Line 286: p_new_ele_id_tbl in cs_kb_number_tbl_type

282: x_msg_count OUT NOCOPY number,
283: x_msg_data OUT NOCOPY varchar2,
284: p_element_id in number,
285: p_set_id_tbl in cs_kb_number_tbl_type,
286: p_new_ele_id_tbl in cs_kb_number_tbl_type
287: );
288: --
289: -- Creation APIs using records
290: --

Line 366: p_ele_assoc_tbl in cs_kb_number_tbl_type :=null,

362: x_msg_data OUT NOCOPY varchar2,
363: p_set_def_obj in cs_kb_set_def_obj_type,
364: p_ele_def_tbl in cs_kb_ele_def_tbl_type,
365: -- p_attrval_def_tbl in cs_kb_attrval_def_tbl_type :=null,
366: p_ele_assoc_tbl in cs_kb_number_tbl_type :=null,
367: x_set_id OUT NOCOPY number
368: );
369:
370: -- New (Post 8/03/00) Contributed element ids passed back

Line 382: p_ele_assoc_tbl in cs_kb_number_tbl_type :=null,

378: x_msg_data OUT NOCOPY varchar2,
379: p_set_def_obj in cs_kb_set_def_obj_type,
380: p_ele_def_tbl in cs_kb_ele_def_tbl_type,
381: -- p_attrval_def_tbl in cs_kb_attrval_def_tbl_type :=null,
382: p_ele_assoc_tbl in cs_kb_number_tbl_type :=null,
383: x_set_id OUT NOCOPY number,
384: x_element_id_tbl OUT NOCOPY cs_kb_number_tbl_type
385: );
386:

Line 384: x_element_id_tbl OUT NOCOPY cs_kb_number_tbl_type

380: p_ele_def_tbl in cs_kb_ele_def_tbl_type,
381: -- p_attrval_def_tbl in cs_kb_attrval_def_tbl_type :=null,
382: p_ele_assoc_tbl in cs_kb_number_tbl_type :=null,
383: x_set_id OUT NOCOPY number,
384: x_element_id_tbl OUT NOCOPY cs_kb_number_tbl_type
385: );
386:
387: PROCEDURE Create_Set(
388: p_api_version in number,

Line 396: p_ele_id_tbl in cs_kb_number_tbl_type,

392: x_return_status OUT NOCOPY varchar2,
393: x_msg_count OUT NOCOPY number,
394: x_msg_data OUT NOCOPY varchar2,
395: p_set_def_obj in cs_kb_set_def_obj_type,
396: p_ele_id_tbl in cs_kb_number_tbl_type,
397: -- p_attrval_def_tbl in cs_kb_attrval_def_tbl_type :=null,
398: p_ele_assoc_tbl in cs_kb_number_tbl_type :=null,
399: x_set_id OUT NOCOPY number
400: );

Line 398: p_ele_assoc_tbl in cs_kb_number_tbl_type :=null,

394: x_msg_data OUT NOCOPY varchar2,
395: p_set_def_obj in cs_kb_set_def_obj_type,
396: p_ele_id_tbl in cs_kb_number_tbl_type,
397: -- p_attrval_def_tbl in cs_kb_attrval_def_tbl_type :=null,
398: p_ele_assoc_tbl in cs_kb_number_tbl_type :=null,
399: x_set_id OUT NOCOPY number
400: );
401:
402: PROCEDURE Create_Element(