278: BEGIN
279: IF (p_file_id IS NOT NULL) THEN
280: SELECT attribute_bundle_data
281: INTO xmlBlob_loc
282: FROM IBC_ATTRIBUTE_BUNDLES
283: WHERE attribute_bundle_id = p_file_id;
284:
285: DBMS_LOB.APPEND(dest_lob => p_xml_clob_loc, src_lob => xmlBlob_loc);
286: END IF;
1036: BEGIN
1037: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1038:
1039: -- Getting next fnd_lobs sequence number
1040: SELECT ibc_attribute_bundles_s1.NEXTVAL
1041: INTO x_lob_file_id
1042: FROM dual;
1043:
1044: INSERT INTO IBC_ATTRIBUTE_BUNDLES(
1040: SELECT ibc_attribute_bundles_s1.NEXTVAL
1041: INTO x_lob_file_id
1042: FROM dual;
1043:
1044: INSERT INTO IBC_ATTRIBUTE_BUNDLES(
1045: attribute_bundle_id
1046: ,attribute_bundle_data
1047: ,created_by
1048: ,creation_date