DBA Data[Home] [Help]

APPS.CS_KNOWLEDGE_PVT dependencies on CS_KB_NUMBER_TBL_TYPE

Line 125: p_id_tbl in cs_kb_number_tbl_type,

121: )return varchar2;
122:
123:
124: FUNCTION Concat_Ids(
125: p_id_tbl in cs_kb_number_tbl_type,
126: p_separator in varchar2
127: ) return varchar2;
128:
129: FUNCTION Concat_Ids(

Line 159: p_ele_id_tbl in cs_kb_number_tbl_type

155: );
156:
157:
158: FUNCTION Do_Elements_Exist_In_Set (
159: p_ele_id_tbl in cs_kb_number_tbl_type
160: ) return varchar2;
161:
162: FUNCTION Get_External_Obj_Names(
163: p_obj_code_tbl in jtf_varchar2_table_100,

Line 176: -- p_ele_id_tbl in cs_kb_number_tbl_type,

172: --) return number;
173:
174: --FUNCTION Change_Element_Assoc(
175: -- p_set_id in number,
176: -- p_ele_id_tbl in cs_kb_number_tbl_type,
177: -- p_assoc_tbl in cs_kb_varchar100_tbl_type --N = neg, P=positive
178: --) return number;
179:
180: FUNCTION Del_Element_From_Set(

Line 212: p_other_id_tbl in cs_kb_number_tbl_type,

208: x_msg_data OUT NOCOPY varchar2,
209: p_usage_code in varchar2,
210: p_id in number,
211: p_object_code in varchar2,
212: p_other_id_tbl in cs_kb_number_tbl_type,
213: p_other_code_tbl in cs_kb_varchar100_tbl_type
214: );
215:
216: --

Line 227: -- p_link_id_tbl in cs_kb_number_tbl_type,

223: -- p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
224: -- x_return_status OUT NOCOPY varchar2,
225: -- x_msg_count OUT NOCOPY number,
226: -- x_msg_data OUT NOCOPY varchar2,
227: -- p_link_id_tbl in cs_kb_number_tbl_type,
228: -- p_set_type_id_tbl in cs_kb_number_tbl_type
229: --);
230:
231: PROCEDURE Change_Ele_Type_Links(

Line 228: -- p_set_type_id_tbl in cs_kb_number_tbl_type

224: -- x_return_status OUT NOCOPY varchar2,
225: -- x_msg_count OUT NOCOPY number,
226: -- x_msg_data OUT NOCOPY varchar2,
227: -- p_link_id_tbl in cs_kb_number_tbl_type,
228: -- p_set_type_id_tbl in cs_kb_number_tbl_type
229: --);
230:
231: PROCEDURE Change_Ele_Type_Links(
232: p_api_version in number,

Line 239: p_link_id_tbl in cs_kb_number_tbl_type,

235: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
236: x_return_status OUT NOCOPY varchar2,
237: x_msg_count OUT NOCOPY number,
238: x_msg_data OUT NOCOPY varchar2,
239: p_link_id_tbl in cs_kb_number_tbl_type,
240: p_ele_type_id_tbl in cs_kb_number_tbl_type
241: );
242: --
243: -- Update or Delete setlinks

Line 240: p_ele_type_id_tbl in cs_kb_number_tbl_type

236: x_return_status OUT NOCOPY varchar2,
237: x_msg_count OUT NOCOPY number,
238: x_msg_data OUT NOCOPY varchar2,
239: p_link_id_tbl in cs_kb_number_tbl_type,
240: p_ele_type_id_tbl in cs_kb_number_tbl_type
241: );
242: --
243: -- Update or Delete setlinks
244: -- (used when del set)

Line 254: p_link_id_tbl in cs_kb_number_tbl_type,

250: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
251: x_return_status OUT NOCOPY varchar2,
252: x_msg_count OUT NOCOPY number,
253: x_msg_data OUT NOCOPY varchar2,
254: p_link_id_tbl in cs_kb_number_tbl_type,
255: p_set_id_tbl in cs_kb_number_tbl_type
256: );
257:
258: PROCEDURE Change_Element_Links(

Line 255: p_set_id_tbl in cs_kb_number_tbl_type

251: x_return_status OUT NOCOPY varchar2,
252: x_msg_count OUT NOCOPY number,
253: x_msg_data OUT NOCOPY varchar2,
254: p_link_id_tbl in cs_kb_number_tbl_type,
255: p_set_id_tbl in cs_kb_number_tbl_type
256: );
257:
258: PROCEDURE Change_Element_Links(
259: p_api_version in number,

Line 266: p_link_id_tbl in cs_kb_number_tbl_type,

262: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
263: x_return_status OUT NOCOPY varchar2,
264: x_msg_count OUT NOCOPY number,
265: x_msg_data OUT NOCOPY varchar2,
266: p_link_id_tbl in cs_kb_number_tbl_type,
267: p_element_id_tbl in cs_kb_number_tbl_type
268: );
269:
270: PROCEDURE Change_Element_To_Sets(

Line 267: p_element_id_tbl in cs_kb_number_tbl_type

263: x_return_status OUT NOCOPY varchar2,
264: x_msg_count OUT NOCOPY number,
265: x_msg_data OUT NOCOPY varchar2,
266: p_link_id_tbl in cs_kb_number_tbl_type,
267: p_element_id_tbl in cs_kb_number_tbl_type
268: );
269:
270: PROCEDURE Change_Element_To_Sets(
271: p_api_version in number,

Line 279: p_set_id_tbl in cs_kb_number_tbl_type,

275: x_return_status OUT NOCOPY varchar2,
276: x_msg_count OUT NOCOPY number,
277: x_msg_data OUT NOCOPY varchar2,
278: p_element_id in number,
279: p_set_id_tbl in cs_kb_number_tbl_type,
280: p_new_ele_id_tbl in cs_kb_number_tbl_type
281: );
282: --
283: -- Creation APIs using records

Line 280: p_new_ele_id_tbl in cs_kb_number_tbl_type

276: x_msg_count OUT NOCOPY number,
277: x_msg_data OUT NOCOPY varchar2,
278: p_element_id in number,
279: p_set_id_tbl in cs_kb_number_tbl_type,
280: p_new_ele_id_tbl in cs_kb_number_tbl_type
281: );
282: --
283: -- Creation APIs using records
284: --

Line 360: p_ele_assoc_tbl in cs_kb_number_tbl_type :=null,

356: x_msg_data OUT NOCOPY varchar2,
357: p_set_def_obj in cs_kb_set_def_obj_type,
358: p_ele_def_tbl in cs_kb_ele_def_tbl_type,
359: -- p_attrval_def_tbl in cs_kb_attrval_def_tbl_type :=null,
360: p_ele_assoc_tbl in cs_kb_number_tbl_type :=null,
361: x_set_id OUT NOCOPY number
362: );
363:
364: -- New (Post 8/03/00) Contributed element ids passed back

Line 376: p_ele_assoc_tbl in cs_kb_number_tbl_type :=null,

372: x_msg_data OUT NOCOPY varchar2,
373: p_set_def_obj in cs_kb_set_def_obj_type,
374: p_ele_def_tbl in cs_kb_ele_def_tbl_type,
375: -- p_attrval_def_tbl in cs_kb_attrval_def_tbl_type :=null,
376: p_ele_assoc_tbl in cs_kb_number_tbl_type :=null,
377: x_set_id OUT NOCOPY number,
378: x_element_id_tbl OUT NOCOPY cs_kb_number_tbl_type
379: );
380:

Line 378: x_element_id_tbl OUT NOCOPY cs_kb_number_tbl_type

374: p_ele_def_tbl in cs_kb_ele_def_tbl_type,
375: -- p_attrval_def_tbl in cs_kb_attrval_def_tbl_type :=null,
376: p_ele_assoc_tbl in cs_kb_number_tbl_type :=null,
377: x_set_id OUT NOCOPY number,
378: x_element_id_tbl OUT NOCOPY cs_kb_number_tbl_type
379: );
380:
381: PROCEDURE Create_Set(
382: p_api_version in number,

Line 390: p_ele_id_tbl in cs_kb_number_tbl_type,

386: x_return_status OUT NOCOPY varchar2,
387: x_msg_count OUT NOCOPY number,
388: x_msg_data OUT NOCOPY varchar2,
389: p_set_def_obj in cs_kb_set_def_obj_type,
390: p_ele_id_tbl in cs_kb_number_tbl_type,
391: -- p_attrval_def_tbl in cs_kb_attrval_def_tbl_type :=null,
392: p_ele_assoc_tbl in cs_kb_number_tbl_type :=null,
393: x_set_id OUT NOCOPY number
394: );

Line 392: p_ele_assoc_tbl in cs_kb_number_tbl_type :=null,

388: x_msg_data OUT NOCOPY varchar2,
389: p_set_def_obj in cs_kb_set_def_obj_type,
390: p_ele_id_tbl in cs_kb_number_tbl_type,
391: -- p_attrval_def_tbl in cs_kb_attrval_def_tbl_type :=null,
392: p_ele_assoc_tbl in cs_kb_number_tbl_type :=null,
393: x_set_id OUT NOCOPY number
394: );
395:
396: PROCEDURE Create_Element(