DBA Data[Home] [Help]

APPS.IBC_CITEM_RUNTIME_PUB dependencies on DBMS_LOB

Line 747: DBMS_LOB.CREATETEMPORARY(l_attribute_bundle, TRUE);

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

Line 866: DBMS_LOB.CREATETEMPORARY(x_content_item_xml, TRUE);

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: '"?>';

Line 871: DBMS_LOB.WRITEAPPEND(x_content_item_xml, LENGTH(l_xml_encoding), l_xml_encoding);

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

Line 977: DBMS_LOB.CREATETEMPORARY(x_content_item_xml, TRUE);

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: '"?>';

Line 982: DBMS_LOB.WRITEAPPEND(x_content_item_xml, LENGTH(l_xml_encoding), l_xml_encoding);

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

Line 1088: DBMS_LOB.CREATETEMPORARY(x_content_item_xml, TRUE);

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: '"?>';

Line 1093: DBMS_LOB.WRITEAPPEND(x_content_item_xml, LENGTH(l_xml_encoding), l_xml_encoding);

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