[Home] [Help]
50: x_return_status OUT NOCOPY VARCHAR2,
51: x_msg_count OUT NOCOPY NUMBER,
52: x_msg_data OUT NOCOPY VARCHAR2
53: ) AS
54: --******** local variable for standards **********
55: l_api_name CONSTANT VARCHAR2(40) := 'get_rendition_file_id';
56: l_api_version CONSTANT NUMBER := 1.0;
57: --
58: l_citem_ver_id NUMBER;
76: FROM IBC_CONTENT_ITEMS
77: WHERE content_item_id = p_content_item_id;
78:
79: BEGIN
80: -- ******* Standard Begins ********
81: -- Standard call to check for call compatibility.
82: IF NOT FND_API.Compatible_API_Call (
83: l_api_version,
84: p_api_version,
77: WHERE content_item_id = p_content_item_id;
78:
79: BEGIN
80: -- ******* Standard Begins ********
81: -- Standard call to check for call compatibility.
82: IF NOT FND_API.Compatible_API_Call (
83: l_api_version,
84: p_api_version,
85: l_api_name,
158: x_file_id := l_file_id;
159:
160: --******************* Real Logic End ***********************
161:
162: -- Standard call to get message count and if count=1, get the message
163: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
164: p_data => x_msg_data);
165: EXCEPTION
166: WHEN FND_API.G_EXC_ERROR THEN
232: WHERE civb.content_item_id = p_content_item_id
233: AND civb.citem_version_id = civtl.citem_version_id
234: AND language = p_language;
235:
236: --******** local variable for standards **********
237: l_api_name CONSTANT VARCHAR2(40) := 'Get_Accessible_Content_Items';
238: l_api_version CONSTANT NUMBER := 1.0;
239: --
240: l_user_id NUMBER;
247: l_result t_num_tbl;
248: l_count NUMBER;
249:
250: BEGIN
251: -- ******* Standard Begins ********
252: -- Standard call to check for call compatibility.
253: IF NOT FND_API.Compatible_API_Call (
254: l_api_version,
255: p_api_version,
248: l_count NUMBER;
249:
250: BEGIN
251: -- ******* Standard Begins ********
252: -- Standard call to check for call compatibility.
253: IF NOT FND_API.Compatible_API_Call (
254: l_api_version,
255: p_api_version,
256: l_api_name,
319: END LOOP;
320: END IF;
321:
322: --******************* Real Logic End ***********************
323: -- Standard call to get message count and if count=1, get the message
324: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
325: p_data => x_msg_data);
326: EXCEPTION
327: WHEN FND_API.G_EXC_ERROR THEN
375: WHERE civb.content_item_id = p_content_item_id
376: AND civb.citem_version_id = civtl.citem_version_id
377: AND language = p_language;
378:
379: --******** local variable for standards **********
380: l_api_name CONSTANT VARCHAR2(40) := 'Get_Citem_Stylesheets';
381: l_api_version CONSTANT NUMBER := 1.0;
382: --
383: l_user_id NUMBER;
390: l_result t_num_tbl;
391: l_count NUMBER;
392:
393: BEGIN
394: -- ******* Standard Begins ********
395: -- Standard call to check for call compatibility.
396: IF NOT FND_API.Compatible_API_Call (
397: l_api_version,
398: p_api_version,
391: l_count NUMBER;
392:
393: BEGIN
394: -- ******* Standard Begins ********
395: -- Standard call to check for call compatibility.
396: IF NOT FND_API.Compatible_API_Call (
397: l_api_version,
398: p_api_version,
399: l_api_name,
431: END LOOP;
432: END IF;
433:
434: --******************* Real Logic End ***********************
435: -- Standard call to get message count and if count=1, get the message
436: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
437: p_data => x_msg_data);
438: EXCEPTION
439: WHEN FND_API.G_EXC_ERROR THEN