123: -- --------------------------------------------------------------
124: -- DELETE ATTRIBUTE BUNDLE
125: --
126: -- Used delete the attribute bundle. This function does NOT edit
127: -- the information about the lob located in the ibc_citem_versions_tl table.
128: --
129: -- --------------------------------------------------------------
130: FUNCTION deleteAttributeBundle(
131: f_citem_ver_id IN NUMBER
139: CURSOR c_bundle IS
140: SELECT
141: attribute_file_id
142: FROM
143: ibc_citem_versions_tl
144: WHERE
145: citem_version_id = f_citem_ver_id
146: AND
147: LANGUAGE = f_language;
319: CURSOR c_afid IS
320: SELECT
321: attribute_file_id
322: FROM
323: ibc_citem_versions_tl
324: WHERE
325: citem_version_id = f_citem_ver_id
326: AND
327: LANGUAGE = f_language;
1275: o_ovn NUMBER;
1276: o_content_item_id NUMBER;
1277: o_start_date DATE;
1278: o_end_date DATE;
1279: o_name IBC_CITEM_VERSIONS_TL.content_item_name%TYPE;
1280: o_description IBC_CITEM_VERSIONS_TL.description%TYPE;
1281: o_attrib_fid NUMBER;
1282: o_attach_fid NUMBER;
1283: o_attach_attrib_code IBC_CITEM_VERSIONS_TL.attachment_attribute_code%TYPE;
1276: o_content_item_id NUMBER;
1277: o_start_date DATE;
1278: o_end_date DATE;
1279: o_name IBC_CITEM_VERSIONS_TL.content_item_name%TYPE;
1280: o_description IBC_CITEM_VERSIONS_TL.description%TYPE;
1281: o_attrib_fid NUMBER;
1282: o_attach_fid NUMBER;
1283: o_attach_attrib_code IBC_CITEM_VERSIONS_TL.attachment_attribute_code%TYPE;
1284: o_source_lang IBC_CITEM_VERSIONS_TL.source_lang%TYPE;
1279: o_name IBC_CITEM_VERSIONS_TL.content_item_name%TYPE;
1280: o_description IBC_CITEM_VERSIONS_TL.description%TYPE;
1281: o_attrib_fid NUMBER;
1282: o_attach_fid NUMBER;
1283: o_attach_attrib_code IBC_CITEM_VERSIONS_TL.attachment_attribute_code%TYPE;
1284: o_source_lang IBC_CITEM_VERSIONS_TL.source_lang%TYPE;
1285: o_attach_fname IBC_CITEM_VERSIONS_TL.attachment_file_name%TYPE;
1286: o_default_rendition_mime_type IBC_CITEM_VERSIONS_TL.default_rendition_mime_type%TYPE;
1287: o_attrib_bundle CLOB;
1280: o_description IBC_CITEM_VERSIONS_TL.description%TYPE;
1281: o_attrib_fid NUMBER;
1282: o_attach_fid NUMBER;
1283: o_attach_attrib_code IBC_CITEM_VERSIONS_TL.attachment_attribute_code%TYPE;
1284: o_source_lang IBC_CITEM_VERSIONS_TL.source_lang%TYPE;
1285: o_attach_fname IBC_CITEM_VERSIONS_TL.attachment_file_name%TYPE;
1286: o_default_rendition_mime_type IBC_CITEM_VERSIONS_TL.default_rendition_mime_type%TYPE;
1287: o_attrib_bundle CLOB;
1288:
1281: o_attrib_fid NUMBER;
1282: o_attach_fid NUMBER;
1283: o_attach_attrib_code IBC_CITEM_VERSIONS_TL.attachment_attribute_code%TYPE;
1284: o_source_lang IBC_CITEM_VERSIONS_TL.source_lang%TYPE;
1285: o_attach_fname IBC_CITEM_VERSIONS_TL.attachment_file_name%TYPE;
1286: o_default_rendition_mime_type IBC_CITEM_VERSIONS_TL.default_rendition_mime_type%TYPE;
1287: o_attrib_bundle CLOB;
1288:
1289: compound_id NUMBER; --temp holder of newly created compound id
1282: o_attach_fid NUMBER;
1283: o_attach_attrib_code IBC_CITEM_VERSIONS_TL.attachment_attribute_code%TYPE;
1284: o_source_lang IBC_CITEM_VERSIONS_TL.source_lang%TYPE;
1285: o_attach_fname IBC_CITEM_VERSIONS_TL.attachment_file_name%TYPE;
1286: o_default_rendition_mime_type IBC_CITEM_VERSIONS_TL.default_rendition_mime_type%TYPE;
1287: o_attrib_bundle CLOB;
1288:
1289: compound_id NUMBER; --temp holder of newly created compound id
1290: l_rendition_id NUMBER;
1453: );
1454:
1455: -- Copying Translation rows from source version
1456: -- 11.5.10 enhancement (for PRP)
1457: INSERT INTO IBC_CITEM_VERSIONS_TL (
1458: CITEM_VERSION_ID,
1459: ATTRIBUTE_FILE_ID,
1460: ATTACHMENT_ATTRIBUTE_CODE,
1461: CONTENT_ITEM_NAME,
1486: last_update_login,
1487: LANGUAGE,
1488: source_lang,
1489: IBC_UTILITIES_PUB.g_stv_work_in_progress
1490: FROM IBC_CITEM_VERSIONS_TL
1491: WHERE citem_version_id = px_citem_ver_id
1492: AND LANGUAGE <> p_language;
1493:
1494: --Bug Fix: 3623676
2482: )
2483: IS
2484: content_item_id NUMBER; --content item id
2485: ctype_code IBC_CONTENT_TYPES_B.content_type_code%TYPE; -- content type code
2486: citem_name IBC_CITEM_VERSIONS_TL.content_item_name%TYPE; -- content item name
2487: citem_desc IBC_CITEM_VERSIONS_TL.description%TYPE; -- content item description
2488: attach_file_id IBC_CITEM_VERSIONS_TL.attachment_file_id%TYPE;
2489: temp_bundle CLOB; -- temporary clob to hold text information while creating
2490: xml_parser XMLPARSER.parser;
2483: IS
2484: content_item_id NUMBER; --content item id
2485: ctype_code IBC_CONTENT_TYPES_B.content_type_code%TYPE; -- content type code
2486: citem_name IBC_CITEM_VERSIONS_TL.content_item_name%TYPE; -- content item name
2487: citem_desc IBC_CITEM_VERSIONS_TL.description%TYPE; -- content item description
2488: attach_file_id IBC_CITEM_VERSIONS_TL.attachment_file_id%TYPE;
2489: temp_bundle CLOB; -- temporary clob to hold text information while creating
2490: xml_parser XMLPARSER.parser;
2491: dom_doc XMLDOM.DOMDocument;
2484: content_item_id NUMBER; --content item id
2485: ctype_code IBC_CONTENT_TYPES_B.content_type_code%TYPE; -- content type code
2486: citem_name IBC_CITEM_VERSIONS_TL.content_item_name%TYPE; -- content item name
2487: citem_desc IBC_CITEM_VERSIONS_TL.description%TYPE; -- content item description
2488: attach_file_id IBC_CITEM_VERSIONS_TL.attachment_file_id%TYPE;
2489: temp_bundle CLOB; -- temporary clob to hold text information while creating
2490: xml_parser XMLPARSER.parser;
2491: dom_doc XMLDOM.DOMDocument;
2492: dom_node_list XMLDOM.DOMNodeList; -- base nodes
2525: l_res_buffer VARCHAR2(32767);
2526: l_total_length NUMBER;
2527:
2528: temp NUMBER;
2529: temp_desc IBC_CITEM_VERSIONS_TL.description%TYPE;
2530: return_status VARCHAR2(1); -- hold temporary status so all errors can be found before error is thrown
2531:
2532: l_exists VARCHAR2(1);
2533: l_msg_count NUMBER;
2556: -- getting citem, ctype, attribute information for use in checking
2557: SELECT
2558: ibc_content_items.content_type_code
2559: ,ibc_content_items.content_item_id
2560: ,ibc_citem_versions_tl.content_item_name
2561: ,ibc_citem_versions_tl.description
2562: ,ibc_citem_versions_tl.attachment_file_id
2563: INTO
2564: ctype_code
2557: SELECT
2558: ibc_content_items.content_type_code
2559: ,ibc_content_items.content_item_id
2560: ,ibc_citem_versions_tl.content_item_name
2561: ,ibc_citem_versions_tl.description
2562: ,ibc_citem_versions_tl.attachment_file_id
2563: INTO
2564: ctype_code
2565: ,content_item_id
2558: ibc_content_items.content_type_code
2559: ,ibc_content_items.content_item_id
2560: ,ibc_citem_versions_tl.content_item_name
2561: ,ibc_citem_versions_tl.description
2562: ,ibc_citem_versions_tl.attachment_file_id
2563: INTO
2564: ctype_code
2565: ,content_item_id
2566: ,citem_name
2567: ,citem_desc
2568: ,attach_file_id
2569: FROM
2570: ibc_citem_versions_b
2571: ,ibc_citem_versions_tl
2572: ,ibc_content_items
2573: WHERE
2574: ibc_content_items.content_item_id = ibc_citem_versions_b.content_item_id
2575: AND
2572: ,ibc_content_items
2573: WHERE
2574: ibc_content_items.content_item_id = ibc_citem_versions_b.content_item_id
2575: AND
2576: ibc_citem_versions_b.citem_version_id = ibc_citem_versions_tl.citem_version_id
2577: AND
2578: ibc_citem_versions_tl.LANGUAGE = p_language
2579: AND
2580: ibc_citem_versions_b.citem_version_id = p_citem_ver_id;
2574: ibc_content_items.content_item_id = ibc_citem_versions_b.content_item_id
2575: AND
2576: ibc_citem_versions_b.citem_version_id = ibc_citem_versions_tl.citem_version_id
2577: AND
2578: ibc_citem_versions_tl.LANGUAGE = p_language
2579: AND
2580: ibc_citem_versions_b.citem_version_id = p_citem_ver_id;
2581:
2582: -- CREATING TEMP ATTRIBUTE BUNDLE
2660: description
2661: INTO
2662: temp_desc
2663: FROM
2664: ibc_citem_versions_tl
2665: WHERE
2666: citem_version_id = p_citem_ver_id
2667: AND
2668: LANGUAGE = p_language;
2936: IS
2937: --******************* BEGIN REQUIRED VARIABLES *************************
2938: l_api_name CONSTANT VARCHAR2(30) := 'approve_citem_version_int';--|**|
2939: --******************* END REQUIRED VARIABLES ***************************
2940: content_item_name IBC_CITEM_VERSIONS_TL.content_item_name%TYPE;
2941: description IBC_CITEM_VERSIONS_TL.description%TYPE;
2942: version_number IBC_CITEM_VERSIONS_B.version_number%TYPE;
2943: start_date DATE;
2944: end_date DATE;
2937: --******************* BEGIN REQUIRED VARIABLES *************************
2938: l_api_name CONSTANT VARCHAR2(30) := 'approve_citem_version_int';--|**|
2939: --******************* END REQUIRED VARIABLES ***************************
2940: content_item_name IBC_CITEM_VERSIONS_TL.content_item_name%TYPE;
2941: description IBC_CITEM_VERSIONS_TL.description%TYPE;
2942: version_number IBC_CITEM_VERSIONS_B.version_number%TYPE;
2943: start_date DATE;
2944: end_date DATE;
2945: ovn NUMBER;
2944: end_date DATE;
2945: ovn NUMBER;
2946: attach_fid NUMBER;
2947: attrib_fid NUMBER;
2948: attach_code IBC_CITEM_VERSIONS_TL.attachment_attribute_code%TYPE;
2949: attach_fname IBC_CITEM_VERSIONS_TL.attachment_file_name%TYPE;
2950: default_rendition_mime_type IBC_CITEM_VERSIONS_TL.default_rendition_mime_type%TYPE;
2951: temp_bundle CLOB;
2952: temp NUMBER;
2945: ovn NUMBER;
2946: attach_fid NUMBER;
2947: attrib_fid NUMBER;
2948: attach_code IBC_CITEM_VERSIONS_TL.attachment_attribute_code%TYPE;
2949: attach_fname IBC_CITEM_VERSIONS_TL.attachment_file_name%TYPE;
2950: default_rendition_mime_type IBC_CITEM_VERSIONS_TL.default_rendition_mime_type%TYPE;
2951: temp_bundle CLOB;
2952: temp NUMBER;
2953:
2946: attach_fid NUMBER;
2947: attrib_fid NUMBER;
2948: attach_code IBC_CITEM_VERSIONS_TL.attachment_attribute_code%TYPE;
2949: attach_fname IBC_CITEM_VERSIONS_TL.attachment_file_name%TYPE;
2950: default_rendition_mime_type IBC_CITEM_VERSIONS_TL.default_rendition_mime_type%TYPE;
2951: temp_bundle CLOB;
2952: temp NUMBER;
2953:
2954: CURSOR info IS
2956: IBC_CONTENT_ITEMS.object_version_number
2957: ,IBC_CITEM_VERSIONS_B.version_number
2958: ,IBC_CITEM_VERSIONS_B.start_date
2959: ,IBC_CITEM_VERSIONS_B.end_date
2960: ,IBC_CITEM_VERSIONS_TL.attribute_file_id
2961: ,IBC_CITEM_VERSIONS_TL.attachment_file_id
2962: ,IBC_CITEM_VERSIONS_TL.content_item_name
2963: ,IBC_CITEM_VERSIONS_TL.description
2964: ,IBC_CITEM_VERSIONS_TL.attachment_file_name
2957: ,IBC_CITEM_VERSIONS_B.version_number
2958: ,IBC_CITEM_VERSIONS_B.start_date
2959: ,IBC_CITEM_VERSIONS_B.end_date
2960: ,IBC_CITEM_VERSIONS_TL.attribute_file_id
2961: ,IBC_CITEM_VERSIONS_TL.attachment_file_id
2962: ,IBC_CITEM_VERSIONS_TL.content_item_name
2963: ,IBC_CITEM_VERSIONS_TL.description
2964: ,IBC_CITEM_VERSIONS_TL.attachment_file_name
2965: ,IBC_CITEM_VERSIONS_TL.default_rendition_mime_type
2958: ,IBC_CITEM_VERSIONS_B.start_date
2959: ,IBC_CITEM_VERSIONS_B.end_date
2960: ,IBC_CITEM_VERSIONS_TL.attribute_file_id
2961: ,IBC_CITEM_VERSIONS_TL.attachment_file_id
2962: ,IBC_CITEM_VERSIONS_TL.content_item_name
2963: ,IBC_CITEM_VERSIONS_TL.description
2964: ,IBC_CITEM_VERSIONS_TL.attachment_file_name
2965: ,IBC_CITEM_VERSIONS_TL.default_rendition_mime_type
2966: ,IBC_CITEM_VERSIONS_TL.attachment_attribute_code
2959: ,IBC_CITEM_VERSIONS_B.end_date
2960: ,IBC_CITEM_VERSIONS_TL.attribute_file_id
2961: ,IBC_CITEM_VERSIONS_TL.attachment_file_id
2962: ,IBC_CITEM_VERSIONS_TL.content_item_name
2963: ,IBC_CITEM_VERSIONS_TL.description
2964: ,IBC_CITEM_VERSIONS_TL.attachment_file_name
2965: ,IBC_CITEM_VERSIONS_TL.default_rendition_mime_type
2966: ,IBC_CITEM_VERSIONS_TL.attachment_attribute_code
2967: FROM
2960: ,IBC_CITEM_VERSIONS_TL.attribute_file_id
2961: ,IBC_CITEM_VERSIONS_TL.attachment_file_id
2962: ,IBC_CITEM_VERSIONS_TL.content_item_name
2963: ,IBC_CITEM_VERSIONS_TL.description
2964: ,IBC_CITEM_VERSIONS_TL.attachment_file_name
2965: ,IBC_CITEM_VERSIONS_TL.default_rendition_mime_type
2966: ,IBC_CITEM_VERSIONS_TL.attachment_attribute_code
2967: FROM
2968: IBC_CONTENT_ITEMS
2961: ,IBC_CITEM_VERSIONS_TL.attachment_file_id
2962: ,IBC_CITEM_VERSIONS_TL.content_item_name
2963: ,IBC_CITEM_VERSIONS_TL.description
2964: ,IBC_CITEM_VERSIONS_TL.attachment_file_name
2965: ,IBC_CITEM_VERSIONS_TL.default_rendition_mime_type
2966: ,IBC_CITEM_VERSIONS_TL.attachment_attribute_code
2967: FROM
2968: IBC_CONTENT_ITEMS
2969: ,IBC_CITEM_VERSIONS_B
2962: ,IBC_CITEM_VERSIONS_TL.content_item_name
2963: ,IBC_CITEM_VERSIONS_TL.description
2964: ,IBC_CITEM_VERSIONS_TL.attachment_file_name
2965: ,IBC_CITEM_VERSIONS_TL.default_rendition_mime_type
2966: ,IBC_CITEM_VERSIONS_TL.attachment_attribute_code
2967: FROM
2968: IBC_CONTENT_ITEMS
2969: ,IBC_CITEM_VERSIONS_B
2970: ,IBC_CITEM_VERSIONS_TL
2966: ,IBC_CITEM_VERSIONS_TL.attachment_attribute_code
2967: FROM
2968: IBC_CONTENT_ITEMS
2969: ,IBC_CITEM_VERSIONS_B
2970: ,IBC_CITEM_VERSIONS_TL
2971: WHERE
2972: IBC_CONTENT_ITEMS.content_item_id = IBC_CITEM_VERSIONS_B.content_item_id
2973: AND
2974: IBC_CITEM_VERSIONS_B.citem_version_id = IBC_CITEM_VERSIONS_TL.citem_version_id
2970: ,IBC_CITEM_VERSIONS_TL
2971: WHERE
2972: IBC_CONTENT_ITEMS.content_item_id = IBC_CITEM_VERSIONS_B.content_item_id
2973: AND
2974: IBC_CITEM_VERSIONS_B.citem_version_id = IBC_CITEM_VERSIONS_TL.citem_version_id
2975: AND
2976: IBC_CITEM_VERSIONS_TL.citem_version_id = p_citem_ver_id
2977: AND
2978: IBC_CITEM_VERSIONS_TL.LANGUAGE = p_base_lang;
2972: IBC_CONTENT_ITEMS.content_item_id = IBC_CITEM_VERSIONS_B.content_item_id
2973: AND
2974: IBC_CITEM_VERSIONS_B.citem_version_id = IBC_CITEM_VERSIONS_TL.citem_version_id
2975: AND
2976: IBC_CITEM_VERSIONS_TL.citem_version_id = p_citem_ver_id
2977: AND
2978: IBC_CITEM_VERSIONS_TL.LANGUAGE = p_base_lang;
2979:
2980: l_rendition_id NUMBER;
2974: IBC_CITEM_VERSIONS_B.citem_version_id = IBC_CITEM_VERSIONS_TL.citem_version_id
2975: AND
2976: IBC_CITEM_VERSIONS_TL.citem_version_id = p_citem_ver_id
2977: AND
2978: IBC_CITEM_VERSIONS_TL.LANGUAGE = p_base_lang;
2979:
2980: l_rendition_id NUMBER;
2981: row_id VARCHAR2(250);
2982:
2992:
2993: CURSOR c_populate_rend(cv_citem_version_id NUMBER
2994: ,cv_language VARCHAR2) IS
2995: SELECT CIVTL.LANGUAGE
2996: FROM ibc_citem_versions_tl CIVTL
2997: WHERE CIVTL.citem_version_id = cv_citem_version_id
2998: AND CIVTL.LANGUAGE <> cv_language;
2999:
3000: BEGIN
3509: INTO
3510: temp
3511: FROM
3512: ibc_citem_versions_b
3513: ,ibc_citem_versions_tl
3514: WHERE
3515: (
3516: (
3517: ibc_citem_versions_tl.LANGUAGE = ibc_citem_versions_tl.source_lang
3513: ,ibc_citem_versions_tl
3514: WHERE
3515: (
3516: (
3517: ibc_citem_versions_tl.LANGUAGE = ibc_citem_versions_tl.source_lang
3518: AND
3519: ibc_citem_versions_b.citem_version_status = Ibc_Utilities_Pub.G_STV_APPROVED
3520: )
3521: OR
3518: AND
3519: ibc_citem_versions_b.citem_version_status = Ibc_Utilities_Pub.G_STV_APPROVED
3520: )
3521: OR
3522: ibc_citem_versions_tl.source_lang = base_lang
3523: )
3524: AND
3525: ibc_citem_versions_b.citem_version_id = ibc_citem_versions_tl.citem_version_id
3526: AND
3521: OR
3522: ibc_citem_versions_tl.source_lang = base_lang
3523: )
3524: AND
3525: ibc_citem_versions_b.citem_version_id = ibc_citem_versions_tl.citem_version_id
3526: AND
3527: ibc_citem_versions_b.citem_version_id = p_citem_ver_id;
3528:
3529:
4406: l_api_name CONSTANT VARCHAR2(30) := 'copy_item'; --|**|
4407: l_api_version_number CONSTANT NUMBER := G_API_VERSION_DEFAULT; --|**|
4408: --******************* END REQUIRED VARIABLES ***************************
4409: row_id VARCHAR2(250); -- required for use with table handlers
4410: lang IBC_CITEM_VERSIONS_TL.LANGUAGE%TYPE;
4411: new_citem_id NUMBER;
4412: new_citem_ver_id NUMBER;
4413: l_new_citem_name VARCHAR2(240) := p_new_citem_name;
4414:
4953: --******************* BEGIN REQUIRED VARIABLES *************************
4954: l_api_name CONSTANT VARCHAR2(30) := 'copy_version'; --|**|
4955: l_api_version_number CONSTANT NUMBER := G_API_VERSION_DEFAULT; --|**|
4956: --******************* END REQUIRED VARIABLES ***************************
4957: lang IBC_CITEM_VERSIONS_TL.LANGUAGE%TYPE;
4958:
4959: BEGIN
4960: --DBMS_OUTPUT.put_line('----- ' || l_api_name || ' -----');
4961: --******************* BEGIN REQUIRED AREA ******************************
6153: l_default_rendition_mime_type VARCHAR2(80);
6154:
6155: l_index INTEGER := 1; -- counter for component loop
6156: return_status CHAR(1);
6157: lang IBC_CITEM_VERSIONS_TL.LANGUAGE%TYPE;
6158:
6159: CURSOR c_Rendition_Name(p_mime_type VARCHAR2, p_language VARCHAR2) IS
6160: SELECT MEANING
6161: FROM FND_LOOKUP_VALUES
6170: SELECT ibc_compound_relations.content_item_id ciid
6171: ,ibc_content_items.owner_resource_id orid
6172: ,ibc_content_items.owner_resource_type ort
6173: ,ibc_compound_relations.attribute_type_code atc
6174: ,ibc_citem_versions_tl.content_item_name cin
6175: ,ibc_compound_relations.sort_order sor
6176: ,ibc_compound_relations.subitem_version_id svid
6177: FROM ibc_compound_relations
6178: ,ibc_content_items
6176: ,ibc_compound_relations.subitem_version_id svid
6177: FROM ibc_compound_relations
6178: ,ibc_content_items
6179: ,ibc_citem_versions_b b1
6180: ,ibc_citem_versions_tl
6181: WHERE b1.citem_version_id = ibc_citem_versions_tl.citem_version_id
6182: AND b1.content_item_id = ibc_content_items.content_item_id
6183: AND ibc_content_items.content_item_id = ibc_compound_relations.content_item_id
6184: AND b1.version_number = (SELECT MAX(b2.version_number)
6177: FROM ibc_compound_relations
6178: ,ibc_content_items
6179: ,ibc_citem_versions_b b1
6180: ,ibc_citem_versions_tl
6181: WHERE b1.citem_version_id = ibc_citem_versions_tl.citem_version_id
6182: AND b1.content_item_id = ibc_content_items.content_item_id
6183: AND ibc_content_items.content_item_id = ibc_compound_relations.content_item_id
6184: AND b1.version_number = (SELECT MAX(b2.version_number)
6185: FROM ibc_citem_versions_b b2
6184: AND b1.version_number = (SELECT MAX(b2.version_number)
6185: FROM ibc_citem_versions_b b2
6186: WHERE b1.content_item_id = b2.content_item_id
6187: )
6188: AND ibc_citem_versions_tl.LANGUAGE = p_language
6189: AND ibc_compound_relations.citem_version_id = p_citem_version_id
6190: ORDER BY ibc_compound_relations.sort_order;
6191:
6192: CURSOR c_renditions(p_citem_version_id NUMBER,
9270: INTO
9271: file_id,
9272: base_language
9273: FROM
9274: ibc_citem_versions_tl civtl,
9275: ibc_citem_versions_b civb,
9276: ibc_content_items ci
9277: WHERE
9278: civb.content_item_id = ci.content_item_id
9796: --******************* BEGIN REQUIRED VARIABLES *************************
9797: l_api_name CONSTANT VARCHAR2(30) := 'set_citem_attachment'; --|**|
9798: l_api_version_number CONSTANT NUMBER := G_API_VERSION_DEFAULT; --|**|
9799: --******************* END REQUIRED VARIABLES ***************************
9800: att_file_name IBC_CITEM_VERSIONS_TL.attachment_file_name%TYPE;
9801: att_type_code IBC_ATTRIBUTE_TYPES_B.data_type_code%TYPE;
9802: l_attach_rendition_mtype FND_LOBS.file_content_type%TYPE;
9803: l_current_attachment_file_id NUMBER;
9804: content_item_id NUMBER;
9896: content_item_id := getCitemId(p_citem_ver_id);
9897:
9898: SELECT attachment_file_id
9899: INTO l_current_attachment_file_id
9900: FROM ibc_citem_versions_tl
9901: WHERE citem_version_id = p_citem_ver_id;
9902:
9903: -- attachment
9904: -- if attachment given
11563: l_api_version_number CONSTANT NUMBER := G_API_VERSION_DEFAULT; --|**|
11564: --******************* END REQUIRED VARIABLES ****************************
11565: row_id VARCHAR2(250); -- required for use with table handlers
11566: locked_by NUMBER; -- locked_by value to be determined from attributes and logic
11567: attach_code IBC_CITEM_VERSIONS_TL.attachment_attribute_code%TYPE;
11568: --fix for bug 11699833.
11569: l_attach_file_name VARCHAR(32000);
11570: l_attach_rendition_mtype VARCHAR(32000);
11571: l_dummy_attach_file_name VARCHAR(32000);
11580: current_version NUMBER := 1;
11581: tempfid NUMBER;
11582: directory_node NUMBER;
11583: return_status CHAR(1);
11584: lang IBC_CITEM_VERSIONS_TL.LANGUAGE%TYPE;
11585: base_lang IBC_CITEM_VERSIONS_TL.LANGUAGE%TYPE;
11586: temp VARCHAR2(10); -- throw away variable
11587: do_item CHAR(1);
11588: do_version CHAR(1);
11581: tempfid NUMBER;
11582: directory_node NUMBER;
11583: return_status CHAR(1);
11584: lang IBC_CITEM_VERSIONS_TL.LANGUAGE%TYPE;
11585: base_lang IBC_CITEM_VERSIONS_TL.LANGUAGE%TYPE;
11586: temp VARCHAR2(10); -- throw away variable
11587: do_item CHAR(1);
11588: do_version CHAR(1);
11589: perm_code JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();