47: x_msg_count OUT NOCOPY NUMBER,
48: x_msg_data OUT NOCOPY VARCHAR2,
49: x_content_item_meta_tbl OUT NOCOPY CONTENT_ITEM_META_TBL
50: ) AS
51: --******** local variable for standards **********
52: l_api_name CONSTANT VARCHAR2(30) := 'Get_Citems_Meta_By_Assoc';
53: l_api_version CONSTANT NUMBER := 1.0;
54: --
55: l_citem_count NUMBER := 1;
66: and NVL(ASSOCIATED_OBJECT_VAL4, '0') = NVL(p_associated_object_val4, '0')
67: and NVL(ASSOCIATED_OBJECT_VAL5, '0') = NVL(p_associated_object_val5, '0');
68:
69: BEGIN
70: -- ******* Standard Begins ********
71:
72: -- Standard call to check for call compatibility.
73: IF NOT FND_API.Compatible_API_Call (
74: l_api_version,
68:
69: BEGIN
70: -- ******* Standard Begins ********
71:
72: -- Standard call to check for call compatibility.
73: IF NOT FND_API.Compatible_API_Call (
74: l_api_version,
75: p_api_version,
76: l_api_name,
127: END IF;
128:
129: --******************* Real Logic End ***********************
130:
131: -- Standard call to get message count and if count=1, get the message
132: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
133: p_data => x_msg_data);
134: EXCEPTION
135: WHEN FND_API.G_EXC_ERROR THEN
195: x_msg_count OUT NOCOPY NUMBER,
196: x_msg_data OUT NOCOPY VARCHAR2,
197: x_content_item_meta_tbl OUT NOCOPY CONTENT_ITEM_META_TBL
198: ) AS
199: --******** local variable for standards **********
200: l_api_name CONSTANT VARCHAR2(30) := 'Get_Citems_Meta_By_Assoc_Ctype';
201: l_api_version CONSTANT NUMBER := 1.0;
202: --
203: l_citem_count NUMBER := 1;
217: and a.CONTENT_ITEM_ID = c.CONTENT_ITEM_ID
218: and c.CONTENT_TYPE_CODE = p_content_type_code;
219:
220: BEGIN
221: -- ******* Standard Begins ********
222:
223: -- Standard call to check for call compatibility.
224: IF NOT FND_API.Compatible_API_Call (
225: l_api_version,
219:
220: BEGIN
221: -- ******* Standard Begins ********
222:
223: -- Standard call to check for call compatibility.
224: IF NOT FND_API.Compatible_API_Call (
225: l_api_version,
226: p_api_version,
227: l_api_name,
289: END IF;
290:
291: --******************* Real Logic End ***********************
292:
293: -- Standard call to get message count and if count=1, get the message
294: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
295: p_data => x_msg_data);
296: EXCEPTION
297: WHEN FND_API.G_EXC_ERROR THEN
342: x_msg_count OUT NOCOPY NUMBER,
343: x_msg_data OUT NOCOPY VARCHAR2,
344: x_content_item_meta_tbl OUT NOCOPY CONTENT_ITEM_META_TBL
345: ) AS
346: --******** local variable for standards **********
347: l_api_name CONSTANT VARCHAR2(30) := 'Get_Citems_Meta';
348: l_api_version CONSTANT NUMBER := 1.0;
349: --
350: l_citem_count NUMBER := 1;
352: l_citem_meta_rec Content_Item_Meta_Rec;
353: l_item_found VARCHAR2(1) := FND_API.G_TRUE;
354:
355: BEGIN
356: -- ******* Standard Begins ********
357:
358: -- Standard call to check for call compatibility.
359: IF NOT FND_API.Compatible_API_Call (
360: l_api_version,
354:
355: BEGIN
356: -- ******* Standard Begins ********
357:
358: -- Standard call to check for call compatibility.
359: IF NOT FND_API.Compatible_API_Call (
360: l_api_version,
361: p_api_version,
362: l_api_name,
403: END LOOP;
404:
405: --******************* Real Logic End *********************
406:
407: -- Standard call to get message count and if count=1, get the message
408: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
409: p_data => x_msg_data);
410: EXCEPTION
411: WHEN FND_API.G_EXC_ERROR THEN
454: x_msg_count OUT NOCOPY NUMBER,
455: x_msg_data OUT NOCOPY VARCHAR2,
456: x_content_item_meta OUT NOCOPY CONTENT_ITEM_META_REC
457: ) AS
458: --******** local variable for standards **********
459: l_api_name CONSTANT VARCHAR2(30) := 'Get_Citem_Meta';
460: l_api_version CONSTANT NUMBER := 1.0;
461: --
462: l_item_found VARCHAR2(1) := FND_API.G_TRUE;
461: --
462: l_item_found VARCHAR2(1) := FND_API.G_TRUE;
463:
464: BEGIN
465: -- ******* Standard Begins ********
466:
467: -- Standard call to check for call compatibility.
468: IF NOT FND_API.Compatible_API_Call (
469: l_api_version,
463:
464: BEGIN
465: -- ******* Standard Begins ********
466:
467: -- Standard call to check for call compatibility.
468: IF NOT FND_API.Compatible_API_Call (
469: l_api_version,
470: p_api_version,
471: l_api_name,
498: END IF;
499:
500: --******************* Real Logic End *********************
501:
502: -- Standard call to get message count and if count=1, get the message
503: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
504: p_data => x_msg_data);
505: EXCEPTION
506: WHEN FND_API.G_EXC_ERROR THEN
549: x_msg_count OUT NOCOPY NUMBER,
550: x_msg_data OUT NOCOPY VARCHAR2,
551: x_content_item_basic OUT NOCOPY CONTENT_ITEM_BASIC_REC
552: ) AS
553: --******** local variable for standards **********
554: l_api_name CONSTANT VARCHAR2(30) := 'Get_Citem_Basic';
555: l_api_version CONSTANT NUMBER := 1.0;
556: --
557: l_live_citem_version_id NUMBER;
597: where CITEM_VERSION_ID = l_citem_version_id
598: order by SORT_ORDER;
599:
600: BEGIN
601: -- ******* Standard Begins ********
602:
603: -- Standard call to check for call compatibility.
604: IF NOT FND_API.Compatible_API_Call (
605: l_api_version,
599:
600: BEGIN
601: -- ******* Standard Begins ********
602:
603: -- Standard call to check for call compatibility.
604: IF NOT FND_API.Compatible_API_Call (
605: l_api_version,
606: p_api_version,
607: l_api_name,
779: END LOOP;
780:
781: --******************* Real Logic End *********************
782:
783: -- Standard call to get message count and if count=1, get the message
784: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
785: p_data => x_msg_data);
786: EXCEPTION
787: WHEN FND_API.G_EXC_ERROR THEN
833: x_msg_count OUT NOCOPY NUMBER,
834: x_msg_data OUT NOCOPY VARCHAR2,
835: x_content_item_xml OUT NOCOPY CLOB
836: ) AS
837: --******** local variable for standards **********
838: l_api_name CONSTANT VARCHAR2(30) := 'Get_Citem_Basic_Xml';
839: l_api_version CONSTANT NUMBER := 1.0;
840: --
841: x_num_levels_loaded NUMBER;
840: --
841: x_num_levels_loaded NUMBER;
842: l_xml_encoding VARCHAR2(50);
843: BEGIN
844: -- ******* Standard Begins ********
845:
846: -- Standard call to check for call compatibility.
847: IF NOT FND_API.Compatible_API_Call (
848: l_api_version,
842: l_xml_encoding VARCHAR2(50);
843: BEGIN
844: -- ******* Standard Begins ********
845:
846: -- Standard call to check for call compatibility.
847: IF NOT FND_API.Compatible_API_Call (
848: l_api_version,
849: p_api_version,
850: l_api_name,
888: END IF;
889:
890: --******************* Real Logic End *********************
891:
892: -- Standard call to get message count and if count=1, get the message
893: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
894: p_data => x_msg_data);
895: EXCEPTION
896: WHEN FND_API.G_EXC_ERROR THEN
945: x_msg_data OUT NOCOPY VARCHAR2,
946: x_content_item_xml OUT NOCOPY CLOB,
947: x_num_levels_loaded OUT NOCOPY NUMBER
948: ) AS
949: --******** local variable for standards **********
950: l_api_name CONSTANT VARCHAR2(30) := 'Get_Citem_Deep_Xml';
951: l_api_version CONSTANT NUMBER := 1.0;
952: --
953: l_xml_encoding VARCHAR2(50);
951: l_api_version CONSTANT NUMBER := 1.0;
952: --
953: l_xml_encoding VARCHAR2(50);
954: BEGIN
955: -- ******* Standard Begins ********
956:
957: -- Standard call to check for call compatibility.
958: IF NOT FND_API.Compatible_API_Call (
959: l_api_version,
953: l_xml_encoding VARCHAR2(50);
954: BEGIN
955: -- ******* Standard Begins ********
956:
957: -- Standard call to check for call compatibility.
958: IF NOT FND_API.Compatible_API_Call (
959: l_api_version,
960: p_api_version,
961: l_api_name,
999: END IF;
1000:
1001: --******************* Real Logic End *********************
1002:
1003: -- Standard call to get message count and if count=1, get the message
1004: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1005: p_data => x_msg_data);
1006: EXCEPTION
1007: WHEN FND_API.G_EXC_ERROR THEN
1056: x_msg_data OUT NOCOPY VARCHAR2,
1057: x_content_item_xml OUT NOCOPY CLOB,
1058: x_num_levels_loaded OUT NOCOPY NUMBER
1059: ) AS
1060: --******** local variable for standards **********
1061: l_api_name CONSTANT VARCHAR2(30) := 'Get_Citem_Deep_Xml';
1062: l_api_version CONSTANT NUMBER := 1.0;
1063: --
1064: l_xml_encoding VARCHAR2(50);
1062: l_api_version CONSTANT NUMBER := 1.0;
1063: --
1064: l_xml_encoding VARCHAR2(50);
1065: BEGIN
1066: -- ******* Standard Begins ********
1067:
1068: -- Standard call to check for call compatibility.
1069: IF NOT FND_API.Compatible_API_Call (
1070: l_api_version,
1064: l_xml_encoding VARCHAR2(50);
1065: BEGIN
1066: -- ******* Standard Begins ********
1067:
1068: -- Standard call to check for call compatibility.
1069: IF NOT FND_API.Compatible_API_Call (
1070: l_api_version,
1071: p_api_version,
1072: l_api_name,
1110: END IF;
1111:
1112: --******************* Real Logic End *********************
1113:
1114: -- Standard call to get message count and if count=1, get the message
1115: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1116: p_data => x_msg_data);
1117: EXCEPTION
1118: WHEN FND_API.G_EXC_ERROR THEN