eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBC_CITEM_ADMIN_GRP dependencies on DBMS_LOB

Line 1167: DBMS_LOB.writeappend(px_attribute_bundle, LENGTH(temp_text), temp_text);

1163: -- if TEXT, HTML or URL -> Enclose the content on a CDATA
1164: temp_text := '<'||p_attribute_type_codes(counter)||' datatype="'||att_type||'">' ||
1165: ' 1166: END IF;
1167: DBMS_LOB.writeappend(px_attribute_bundle, LENGTH(temp_text), temp_text);
1168:
1169: -- Actual Attribute Value
1170: IF (att_type = IBC_UTILITIES_PUB.G_DTC_DATE) THEN
1171: BEGIN

Line 1185: DBMS_LOB.writeappend(px_attribute_bundle, LENGTH(temp_text), temp_text);

1181: temp_text := p_attributes(counter);
1182: END IF;
1183:
1184: IF temp_text IS NOT NULL THEN
1185: DBMS_LOB.writeappend(px_attribute_bundle, LENGTH(temp_text), temp_text);
1186: END IF;
1187:
1188: WHILE counter + 1 <= qty_codes AND
1189: p_attribute_type_codes(counter) = p_attribute_type_codes(counter+1)

Line 1195: DBMS_LOB.writeappend(px_attribute_bundle, LENGTH(temp_text), temp_text);

1191: IBC_DEBUG_PVT.debug_message('COUNTER=' || counter);
1192: counter := counter + 1;
1193: temp_text := p_attributes(counter);
1194: IF temp_text IS NOT NULL THEN
1195: DBMS_LOB.writeappend(px_attribute_bundle, LENGTH(temp_text), temp_text);
1196: END IF;
1197: END LOOP;
1198:
1199: -- Close TAG

Line 1213: DBMS_LOB.writeappend(px_attribute_bundle, LENGTH(temp_text), temp_text);

1209: temp_text := ']]>' ||
1210: '';
1211: END IF;
1212: -- writing to outgoing lob
1213: DBMS_LOB.writeappend(px_attribute_bundle, LENGTH(temp_text), temp_text);
1214: END IF;
1215: END IF; -- if continue flag ...
1216:
1217: EXIT WHEN counter = qty_codes;

Line 1677: DBMS_LOB.createtemporary(temp_bundle, TRUE, 2);

1673: --DBMS_OUTPUT.put_line('----- get_attribute_bundle_int -----');
1674: x_return_status := FND_API.G_RET_STS_SUCCESS;
1675: --get attributes
1676: -- CREATING TEMP ATTRIBUTE BUNDLE
1677: DBMS_LOB.createtemporary(temp_bundle, TRUE, 2);
1678:
1679: -- Attaching encoding to XML based on DB character set
1680: l_xml_encoding := ' 1681: IBC_UTILITIES_PVT.getEncoding() ||

Line 1683: DBMS_LOB.WRITEAPPEND(temp_bundle, LENGTH(l_xml_encoding), l_xml_encoding);

1679: -- Attaching encoding to XML based on DB character set
1680: l_xml_encoding := ' 1681: IBC_UTILITIES_PVT.getEncoding() ||
1682: '"?>';
1683: DBMS_LOB.WRITEAPPEND(temp_bundle, LENGTH(l_xml_encoding), l_xml_encoding);
1684:
1685: -- BUILDING COMPLETE XML CLOB
1686: -- creating open tags
1687: Ibc_Utilities_Pvt.build_citem_open_tags (

Line 2583: DBMS_LOB.createtemporary(temp_bundle, TRUE, 2);

2579: AND
2580: ibc_citem_versions_b.citem_version_id = p_citem_ver_id;
2581:
2582: -- CREATING TEMP ATTRIBUTE BUNDLE
2583: DBMS_LOB.createtemporary(temp_bundle, TRUE, 2);
2584:
2585: -- BUILDING COMPLETE XML CLOB
2586:
2587: -- Attaching encoding to XML based on DB character set

Line 2591: DBMS_LOB.WRITEAPPEND(temp_bundle, LENGTH(l_xml_encoding), l_xml_encoding);

2587: -- Attaching encoding to XML based on DB character set
2588: l_xml_encoding := ' 2589: IBC_UTILITIES_PVT.getEncoding() ||
2590: '"?>';
2591: DBMS_LOB.WRITEAPPEND(temp_bundle, LENGTH(l_xml_encoding), l_xml_encoding);
2592:
2593: -- creating open tags
2594: Ibc_Utilities_Pvt.build_citem_open_tags (
2595: p_content_type_code => ctype_code

Line 2605: DBMS_LOB.APPEND (

2601: ,p_xml_clob_loc => temp_bundle
2602: );
2603:
2604: --appending given clob
2605: DBMS_LOB.APPEND (
2606: dest_lob => temp_bundle
2607: ,src_lob => p_attribute_bundle
2608: );
2609:

Line 2637: -- l_clob_len := DBMS_LOB.getlength(temp_bundle);

2633: -- DECLARE
2634: -- l_clob_len NUMBER;
2635: -- l_buffer VARCHAR2(10000);
2636: -- BEGIN
2637: -- l_clob_len := DBMS_LOB.getlength(temp_bundle);
2638: -- IBC_DEBUG_PVT.debug_message('CLOBLEN=' || l_clob_len);
2639: -- DBMS_LOB.read(temp_bundle, l_clob_len, 1, l_buffer);
2640: -- IBC_DEBUG_PVT.debug_message(l_buffer);
2641: -- EXCEPTION

Line 2639: -- DBMS_LOB.read(temp_bundle, l_clob_len, 1, l_buffer);

2635: -- l_buffer VARCHAR2(10000);
2636: -- BEGIN
2637: -- l_clob_len := DBMS_LOB.getlength(temp_bundle);
2638: -- IBC_DEBUG_PVT.debug_message('CLOBLEN=' || l_clob_len);
2639: -- DBMS_LOB.read(temp_bundle, l_clob_len, 1, l_buffer);
2640: -- IBC_DEBUG_PVT.debug_message(l_buffer);
2641: -- EXCEPTION
2642: -- WHEN OTHERS THEN
2643: -- NULL;

Line 3024: DBMS_LOB.createtemporary(temp_bundle, TRUE, 2);

3020: x_return_status := FND_API.G_RET_STS_SUCCESS;
3021: temp := p_citem_ver_id;
3022:
3023: -- CREATING TEMP ATTRIBUTE BUNDLE
3024: DBMS_LOB.createtemporary(temp_bundle, TRUE, 2);
3025:
3026: OPEN info;
3027: FETCH info
3028: INTO ovn,version_number,start_date,end_date,attrib_fid,attach_fid,

Line 9265: DBMS_LOB.createtemporary(temp_bundle, TRUE, 2);

9261: --DBMS_OUTPUT.put_line('----- ' || l_api_name || ' -----');
9262: x_return_status := FND_API.G_RET_STS_SUCCESS;
9263:
9264: -- CREATING TEMP ATTRIBUTE BUNDLE
9265: DBMS_LOB.createtemporary(temp_bundle, TRUE, 2);
9266:
9267: -- getting file_id of actual attribute bundle
9268: SELECT
9269: MIN(civtl.attribute_file_id), ci.base_language

Line 9532: DBMS_LOB.createtemporary(bundle_text, TRUE, 2);

9528: ctype_code := getContentType(getCitemId(p_citem_ver_id));
9529:
9530:
9531: -- creating temporary lob
9532: DBMS_LOB.createtemporary(bundle_text, TRUE, 2);
9533:
9534: create_attribute_bundle(
9535: px_attribute_bundle => bundle_text
9536: ,p_attribute_type_codes => p_attribute_type_codes

Line 12073: DBMS_LOB.createtemporary(bundle_text, TRUE, 2);

12069: (p_attributes IS NOT NULL) AND
12070: (x_return_status = FND_API.G_RET_STS_SUCCESS) AND
12071: (do_version <> G_COMMAND_POST_APPROVAL_UPDATE) ) THEN
12072: -- creating temporary lob
12073: DBMS_LOB.createtemporary(bundle_text, TRUE, 2);
12074: create_attribute_bundle(
12075: px_attribute_bundle => bundle_text
12076: ,p_attribute_type_codes => p_attribute_type_codes
12077: ,p_attributes => p_attributes