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 IBC_CITEM_VERSIONS_TL

Line 127: -- the information about the lob located in the ibc_citem_versions_tl table.

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

Line 143: ibc_citem_versions_tl

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;

Line 323: ibc_citem_versions_tl

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;

Line 1279: o_name IBC_CITEM_VERSIONS_TL.content_item_name%TYPE;

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;

Line 1280: o_description IBC_CITEM_VERSIONS_TL.description%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;

Line 1283: o_attach_attrib_code IBC_CITEM_VERSIONS_TL.attachment_attribute_code%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;

Line 1284: o_source_lang IBC_CITEM_VERSIONS_TL.source_lang%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;
1288:

Line 1285: o_attach_fname IBC_CITEM_VERSIONS_TL.attachment_file_name%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:
1289: compound_id NUMBER; --temp holder of newly created compound id

Line 1286: o_default_rendition_mime_type IBC_CITEM_VERSIONS_TL.default_rendition_mime_type%TYPE;

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;

Line 1457: INSERT INTO IBC_CITEM_VERSIONS_TL (

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,

Line 1490: FROM IBC_CITEM_VERSIONS_TL

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

Line 2486: citem_name IBC_CITEM_VERSIONS_TL.content_item_name%TYPE; -- content item name

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;

Line 2487: citem_desc IBC_CITEM_VERSIONS_TL.description%TYPE; -- content item description

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;

Line 2488: attach_file_id IBC_CITEM_VERSIONS_TL.attachment_file_id%TYPE;

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

Line 2529: temp_desc IBC_CITEM_VERSIONS_TL.description%TYPE;

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;

Line 2560: ,ibc_citem_versions_tl.content_item_name

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

Line 2561: ,ibc_citem_versions_tl.description

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

Line 2562: ,ibc_citem_versions_tl.attachment_file_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

Line 2571: ,ibc_citem_versions_tl

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

Line 2576: ibc_citem_versions_b.citem_version_id = ibc_citem_versions_tl.citem_version_id

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;

Line 2578: ibc_citem_versions_tl.LANGUAGE = p_language

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

Line 2664: ibc_citem_versions_tl

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;

Line 2940: content_item_name IBC_CITEM_VERSIONS_TL.content_item_name%TYPE;

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;

Line 2941: description IBC_CITEM_VERSIONS_TL.description%TYPE;

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;

Line 2948: attach_code IBC_CITEM_VERSIONS_TL.attachment_attribute_code%TYPE;

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;

Line 2949: attach_fname IBC_CITEM_VERSIONS_TL.attachment_file_name%TYPE;

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:

Line 2950: default_rendition_mime_type IBC_CITEM_VERSIONS_TL.default_rendition_mime_type%TYPE;

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

Line 2960: ,IBC_CITEM_VERSIONS_TL.attribute_file_id

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

Line 2961: ,IBC_CITEM_VERSIONS_TL.attachment_file_id

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

Line 2962: ,IBC_CITEM_VERSIONS_TL.content_item_name

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

Line 2963: ,IBC_CITEM_VERSIONS_TL.description

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

Line 2964: ,IBC_CITEM_VERSIONS_TL.attachment_file_name

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

Line 2965: ,IBC_CITEM_VERSIONS_TL.default_rendition_mime_type

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

Line 2966: ,IBC_CITEM_VERSIONS_TL.attachment_attribute_code

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

Line 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

Line 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;

Line 2976: IBC_CITEM_VERSIONS_TL.citem_version_id = p_citem_ver_id

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;

Line 2978: IBC_CITEM_VERSIONS_TL.LANGUAGE = p_base_lang;

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:

Line 2996: FROM ibc_citem_versions_tl CIVTL

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

Line 3513: ,ibc_citem_versions_tl

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

Line 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

Line 3522: ibc_citem_versions_tl.source_lang = base_lang

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

Line 3525: ibc_citem_versions_b.citem_version_id = ibc_citem_versions_tl.citem_version_id

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:

Line 4410: lang IBC_CITEM_VERSIONS_TL.LANGUAGE%TYPE;

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:

Line 4957: lang IBC_CITEM_VERSIONS_TL.LANGUAGE%TYPE;

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 ******************************

Line 6157: lang IBC_CITEM_VERSIONS_TL.LANGUAGE%TYPE;

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

Line 6174: ,ibc_citem_versions_tl.content_item_name cin

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

Line 6180: ,ibc_citem_versions_tl

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)

Line 6181: WHERE b1.citem_version_id = ibc_citem_versions_tl.citem_version_id

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

Line 6188: AND ibc_citem_versions_tl.LANGUAGE = p_language

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,

Line 9274: ibc_citem_versions_tl civtl,

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

Line 9800: att_file_name IBC_CITEM_VERSIONS_TL.attachment_file_name%TYPE;

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;

Line 9900: FROM ibc_citem_versions_tl

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

Line 11567: attach_code IBC_CITEM_VERSIONS_TL.attachment_attribute_code%TYPE;

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: l_attach_file_name IBC_CITEM_VERSIONS_TL.attachment_file_name%TYPE;
11569: l_attach_rendition_mtype IBC_CITEM_VERSIONS_TL.default_rendition_mime_type%TYPE;
11570: l_dummy_attach_file_name IBC_CITEM_VERSIONS_TL.attachment_file_name%TYPE;
11571: l_dummy_attach_rendition_mtype IBC_CITEM_VERSIONS_TL.default_rendition_mime_type%TYPE;

Line 11568: l_attach_file_name IBC_CITEM_VERSIONS_TL.attachment_file_name%TYPE;

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: l_attach_file_name IBC_CITEM_VERSIONS_TL.attachment_file_name%TYPE;
11569: l_attach_rendition_mtype IBC_CITEM_VERSIONS_TL.default_rendition_mime_type%TYPE;
11570: l_dummy_attach_file_name IBC_CITEM_VERSIONS_TL.attachment_file_name%TYPE;
11571: l_dummy_attach_rendition_mtype IBC_CITEM_VERSIONS_TL.default_rendition_mime_type%TYPE;
11572: p_object_ver_num NUMBER := 1; -- object version number (static since this is insert only)

Line 11569: l_attach_rendition_mtype IBC_CITEM_VERSIONS_TL.default_rendition_mime_type%TYPE;

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: l_attach_file_name IBC_CITEM_VERSIONS_TL.attachment_file_name%TYPE;
11569: l_attach_rendition_mtype IBC_CITEM_VERSIONS_TL.default_rendition_mime_type%TYPE;
11570: l_dummy_attach_file_name IBC_CITEM_VERSIONS_TL.attachment_file_name%TYPE;
11571: l_dummy_attach_rendition_mtype IBC_CITEM_VERSIONS_TL.default_rendition_mime_type%TYPE;
11572: p_object_ver_num NUMBER := 1; -- object version number (static since this is insert only)
11573: l_rendition_id NUMBER;

Line 11570: l_dummy_attach_file_name IBC_CITEM_VERSIONS_TL.attachment_file_name%TYPE;

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: l_attach_file_name IBC_CITEM_VERSIONS_TL.attachment_file_name%TYPE;
11569: l_attach_rendition_mtype IBC_CITEM_VERSIONS_TL.default_rendition_mime_type%TYPE;
11570: l_dummy_attach_file_name IBC_CITEM_VERSIONS_TL.attachment_file_name%TYPE;
11571: l_dummy_attach_rendition_mtype IBC_CITEM_VERSIONS_TL.default_rendition_mime_type%TYPE;
11572: p_object_ver_num NUMBER := 1; -- object version number (static since this is insert only)
11573: l_rendition_id NUMBER;
11574: bundle_text CLOB; -- tempory blob

Line 11571: l_dummy_attach_rendition_mtype IBC_CITEM_VERSIONS_TL.default_rendition_mime_type%TYPE;

11567: attach_code IBC_CITEM_VERSIONS_TL.attachment_attribute_code%TYPE;
11568: l_attach_file_name IBC_CITEM_VERSIONS_TL.attachment_file_name%TYPE;
11569: l_attach_rendition_mtype IBC_CITEM_VERSIONS_TL.default_rendition_mime_type%TYPE;
11570: l_dummy_attach_file_name IBC_CITEM_VERSIONS_TL.attachment_file_name%TYPE;
11571: l_dummy_attach_rendition_mtype IBC_CITEM_VERSIONS_TL.default_rendition_mime_type%TYPE;
11572: p_object_ver_num NUMBER := 1; -- object version number (static since this is insert only)
11573: l_rendition_id NUMBER;
11574: bundle_text CLOB; -- tempory blob
11575: bundle_file_id NUMBER; -- pointer to actual FND_LOB location

Line 11583: lang IBC_CITEM_VERSIONS_TL.LANGUAGE%TYPE;

11579: current_version NUMBER := 1;
11580: tempfid NUMBER;
11581: directory_node NUMBER;
11582: return_status CHAR(1);
11583: lang IBC_CITEM_VERSIONS_TL.LANGUAGE%TYPE;
11584: base_lang IBC_CITEM_VERSIONS_TL.LANGUAGE%TYPE;
11585: temp VARCHAR2(10); -- throw away variable
11586: do_item CHAR(1);
11587: do_version CHAR(1);

Line 11584: base_lang IBC_CITEM_VERSIONS_TL.LANGUAGE%TYPE;

11580: tempfid NUMBER;
11581: directory_node NUMBER;
11582: return_status CHAR(1);
11583: lang IBC_CITEM_VERSIONS_TL.LANGUAGE%TYPE;
11584: base_lang IBC_CITEM_VERSIONS_TL.LANGUAGE%TYPE;
11585: temp VARCHAR2(10); -- throw away variable
11586: do_item CHAR(1);
11587: do_version CHAR(1);
11588: perm_code JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();