743: -- Retrieve attribute bundle and build output xml
744: IF (l_attribute_file_id is NULL) THEN
745: x_content_item_basic.attribute_bundle := NULL;
746: ELSE
747: DBMS_LOB.CREATETEMPORARY(l_attribute_bundle, TRUE);
748: IBC_UTILITIES_PVT.Build_Citem_Open_Tag (
749: p_content_type_code => l_content_type_code
750: ,p_content_item_id => p_content_item_id
751: ,p_version_number => x_content_item_basic.version_number
862: x_return_status := FND_API.G_RET_STS_SUCCESS;
863:
864: --******************* Real Logic Start *********************
865:
866: DBMS_LOB.CREATETEMPORARY(x_content_item_xml, TRUE);
867:
868: l_xml_encoding := '
869: IBC_UTILITIES_PVT.getEncoding() ||
870: '"?>';
867:
868: l_xml_encoding := '
869: IBC_UTILITIES_PVT.getEncoding() ||
870: '"?>';
871: DBMS_LOB.WRITEAPPEND(x_content_item_xml, LENGTH(l_xml_encoding), l_xml_encoding);
872:
873: IBC_CITEM_RUNTIME_PVT.Get_Citem_Xml (
874: p_init_msg_list => p_init_msg_list, -- p_init_msg_list IN VARCHAR2
875: p_content_item_id => p_content_item_id, -- p_content_item_id IN NUMBER
973: x_return_status := FND_API.G_RET_STS_SUCCESS;
974:
975: --******************* Real Logic Start *********************
976:
977: DBMS_LOB.CREATETEMPORARY(x_content_item_xml, TRUE);
978:
979: l_xml_encoding := '
980: IBC_UTILITIES_PVT.getEncoding() ||
981: '"?>';
978:
979: l_xml_encoding := '
980: IBC_UTILITIES_PVT.getEncoding() ||
981: '"?>';
982: DBMS_LOB.WRITEAPPEND(x_content_item_xml, LENGTH(l_xml_encoding), l_xml_encoding);
983:
984: IBC_CITEM_RUNTIME_PVT.Get_Citem_Xml (
985: p_init_msg_list => p_init_msg_list, -- p_init_msg_list IN VARCHAR2
986: p_content_item_id => p_content_item_id, -- p_content_item_id IN NUMBER
1084: x_return_status := FND_API.G_RET_STS_SUCCESS;
1085:
1086: --******************* Real Logic Start *********************
1087:
1088: DBMS_LOB.CREATETEMPORARY(x_content_item_xml, TRUE);
1089:
1090: l_xml_encoding := '
1091: IBC_UTILITIES_PVT.getEncoding() ||
1092: '"?>';
1089:
1090: l_xml_encoding := '
1091: IBC_UTILITIES_PVT.getEncoding() ||
1092: '"?>';
1093: DBMS_LOB.WRITEAPPEND(x_content_item_xml, LENGTH(l_xml_encoding), l_xml_encoding);
1094:
1095: IBC_CITEM_RUNTIME_PVT.Get_Citem_Xml (
1096: p_init_msg_list => p_init_msg_list, -- p_init_msg_list IN VARCHAR2
1097: p_content_item_id => p_content_item_id, -- p_content_item_id IN NUMBER