[Home] [Help]
236: x_return_status OUT NOCOPY VARCHAR2,
237: x_msg_count OUT NOCOPY NUMBER,
238: x_msg_data OUT NOCOPY VARCHAR2
239: ) AS
240: --******** local variable for standards **********
241: l_api_name CONSTANT VARCHAR2(40) := 'Get_Approved_Default_StyleSht';
242: l_api_version CONSTANT NUMBER := 1.0;
243: --
244: l_stylesheet_id NUMBER;
250: and i.CONTENT_TYPE_CODE = s.CONTENT_TYPE_CODE
251: and s.DEFAULT_STYLESHEET_FLAG = FND_API.G_TRUE;
252:
253: BEGIN
254: -- ******* Standard Begins ********
255: -- Standard call to check for call compatibility.
256: IF NOT FND_API.Compatible_API_Call (
257: l_api_version,
258: p_api_version,
251: and s.DEFAULT_STYLESHEET_FLAG = FND_API.G_TRUE;
252:
253: BEGIN
254: -- ******* Standard Begins ********
255: -- Standard call to check for call compatibility.
256: IF NOT FND_API.Compatible_API_Call (
257: l_api_version,
258: p_api_version,
259: l_api_name,
291: );
292:
293: --******************* Real Logic End ***********************
294:
295: -- Standard call to get message count and if count=1, get the message
296: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
297: p_data => x_msg_data);
298: EXCEPTION
299: WHEN FND_API.G_EXC_ERROR THEN
324: x_return_status OUT NOCOPY VARCHAR2,
325: x_msg_count OUT NOCOPY NUMBER,
326: x_msg_data OUT NOCOPY VARCHAR2
327: ) AS
328: --******** local variable for standards **********
329: l_api_name CONSTANT VARCHAR2(40) := 'Get_Apprv_Default_StyleSht_Id';
330: l_api_version CONSTANT NUMBER := 1.0;
331: --
332: l_stylesheet_id NUMBER;
338: and i.CONTENT_TYPE_CODE = s.CONTENT_TYPE_CODE
339: and s.DEFAULT_STYLESHEET_FLAG = FND_API.G_TRUE;
340:
341: BEGIN
342: -- ******* Standard Begins ********
343: -- Standard call to check for call compatibility.
344: IF NOT FND_API.Compatible_API_Call (
345: l_api_version,
346: p_api_version,
339: and s.DEFAULT_STYLESHEET_FLAG = FND_API.G_TRUE;
340:
341: BEGIN
342: -- ******* Standard Begins ********
343: -- Standard call to check for call compatibility.
344: IF NOT FND_API.Compatible_API_Call (
345: l_api_version,
346: p_api_version,
347: l_api_name,
401: x_return_status OUT NOCOPY VARCHAR2,
402: x_msg_count OUT NOCOPY NUMBER,
403: x_msg_data OUT NOCOPY VARCHAR2
404: ) AS
405: --******** local variable for standards **********
406: l_api_name CONSTANT VARCHAR2(40) := 'Get_Approved_StyleSheet';
407: l_api_version CONSTANT NUMBER := 1.0;
408: --
409:
407: l_api_version CONSTANT NUMBER := 1.0;
408: --
409:
410: BEGIN
411: -- ******* Standard Begins ********
412: -- Standard call to check for call compatibility.
413: IF NOT FND_API.Compatible_API_Call (
414: l_api_version,
415: p_api_version,
408: --
409:
410: BEGIN
411: -- ******* Standard Begins ********
412: -- Standard call to check for call compatibility.
413: IF NOT FND_API.Compatible_API_Call (
414: l_api_version,
415: p_api_version,
416: l_api_name,
439: );
440:
441: --******************* Real Logic End ***********************
442:
443: -- Standard call to get message count and if count=1, get the message
444: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
445: p_data => x_msg_data);
446: EXCEPTION
447: WHEN FND_API.G_EXC_ERROR THEN
473: x_return_status OUT NOCOPY VARCHAR2,
474: x_msg_count OUT NOCOPY NUMBER,
475: x_msg_data OUT NOCOPY VARCHAR2
476: ) AS
477: --******** local variable for standards **********
478: l_api_name CONSTANT VARCHAR2(40) := 'Get_Approved_StyleSht_RC';
479: l_api_version CONSTANT NUMBER := 1.0;
480: --
481: l_stylesheet_id NUMBER;
485: from IBC_CONTENT_ITEMS
486: where ITEM_REFERENCE_CODE = p_stylesheet_ref_code;
487:
488: BEGIN
489: -- ******* Standard Begins ********
490: -- Standard call to check for call compatibility.
491: IF NOT FND_API.Compatible_API_Call (
492: l_api_version,
493: p_api_version,
486: where ITEM_REFERENCE_CODE = p_stylesheet_ref_code;
487:
488: BEGIN
489: -- ******* Standard Begins ********
490: -- Standard call to check for call compatibility.
491: IF NOT FND_API.Compatible_API_Call (
492: l_api_version,
493: p_api_version,
494: l_api_name,
529: );
530:
531: --******************* Real Logic End ***********************
532:
533: -- Standard call to get message count and if count=1, get the message
534: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
535: p_data => x_msg_data);
536: EXCEPTION
537: WHEN FND_API.G_EXC_ERROR THEN
571: x_return_status OUT NOCOPY VARCHAR2,
572: x_msg_count OUT NOCOPY NUMBER,
573: x_msg_data OUT NOCOPY VARCHAR2
574: ) AS
575: --******** local variable for standards **********
576: l_api_name CONSTANT VARCHAR2(40) := 'Get_StyleSheet_Items';
577: l_api_version CONSTANT NUMBER := 1.0;
578: --
579: l_in_citem_ids JTF_NUMBER_TABLE;
589: where i.CONTENT_ITEM_ID = p_content_item_id
590: and i.CONTENT_TYPE_CODE = s.CONTENT_TYPE_CODE;
591:
592: BEGIN
593: -- ******* Standard Begins ********
594: -- Standard call to check for call compatibility.
595: IF NOT FND_API.Compatible_API_Call (
596: l_api_version,
597: p_api_version,
590: and i.CONTENT_TYPE_CODE = s.CONTENT_TYPE_CODE;
591:
592: BEGIN
593: -- ******* Standard Begins ********
594: -- Standard call to check for call compatibility.
595: IF NOT FND_API.Compatible_API_Call (
596: l_api_version,
597: p_api_version,
598: l_api_name,
658: END IF;
659: END IF;
660: --******************* Real Logic End ***********************
661:
662: -- Standard call to get message count and if count=1, get the message
663: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
664: p_data => x_msg_data);
665: EXCEPTION
666: WHEN FND_API.G_EXC_ERROR THEN