586:
587: CURSOR Get_Rendition_Name IS
588: SELECT NVL(DESCRIPTION, MEANING)
589: FROM FND_LOOKUP_VALUES
590: WHERE LOOKUP_TYPE = IBC_UTILITIES_PVT.G_REND_LOOKUP_TYPE
591: AND LANGUAGE = userenv('LANG')
592: AND LOOKUP_CODE = l_mime_type;
593:
594: CURSOR Get_Compound_Item_Ref IS
697: OPEN Get_Rendition_Name;
698: FETCH Get_Rendition_Name INTO x_content_item_basic.default_rendition_name;
699: IF Get_Rendition_Name%NOTFOUND THEN
700: CLOSE Get_Rendition_Name;
701: l_mime_type := IBC_UTILITIES_PVT.G_REND_UNKNOWN_MIME;
702: OPEN Get_Rendition_Name;
703: FETCH Get_Rendition_Name INTO x_content_item_basic.default_rendition_name;
704: CLOSE Get_Rendition_Name;
705: ELSE
728: OPEN Get_Rendition_Name;
729: FETCH Get_Rendition_Name INTO x_content_item_basic.rendition_names(l_count);
730: IF Get_Rendition_Name%NOTFOUND THEN
731: CLOSE Get_Rendition_Name;
732: l_mime_type := IBC_UTILITIES_PVT.G_REND_UNKNOWN_MIME;
733: OPEN Get_Rendition_Name;
734: FETCH Get_Rendition_Name INTO x_content_item_basic.rendition_names(l_count);
735: CLOSE Get_Rendition_Name;
736: ELSE
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
752: ,p_item_reference_code => l_item_reference_code
752: ,p_item_reference_code => l_item_reference_code
753: ,p_item_label => p_label_code
754: ,p_xml_clob_loc => l_attribute_bundle
755: );
756: IBC_UTILITIES_PVT.Build_Attribute_Bundle (
757: l_attribute_file_id, -- p_file_id IN NUMBER
758: l_attribute_bundle -- p_xml_clob_loc IN OUT CLOB
759: );
760: IBC_UTILITIES_PVT.Build_Close_Tag (
756: IBC_UTILITIES_PVT.Build_Attribute_Bundle (
757: l_attribute_file_id, -- p_file_id IN NUMBER
758: l_attribute_bundle -- p_xml_clob_loc IN OUT CLOB
759: );
760: IBC_UTILITIES_PVT.Build_Close_Tag (
761: l_content_type_code, -- p_close_tag IN VARCHAR2
762: l_attribute_bundle -- p_xml_clob_loc IN OUT CLOB
763: );
764: x_content_item_basic.attribute_bundle := l_attribute_bundle;
865:
866: DBMS_LOB.CREATETEMPORARY(x_content_item_xml, TRUE);
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 (
976:
977: DBMS_LOB.CREATETEMPORARY(x_content_item_xml, TRUE);
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 (
1087:
1088: DBMS_LOB.CREATETEMPORARY(x_content_item_xml, TRUE);
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 (