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_B

Line 469: ibc_citem_versions_b

465: CURSOR c_item IS
466: SELECT
467: content_item_id
468: FROM
469: ibc_citem_versions_b
470: WHERE
471: citem_version_id = f_citem_version_id;
472:
473: temp NUMBER;

Line 505: ibc_citem_versions_b

501: CURSOR c_maxv IS
502: SELECT
503: MAX(citem_version_id)
504: FROM
505: ibc_citem_versions_b
506: WHERE
507: content_item_id = f_content_item_id;
508:
509: temp NUMBER;

Line 883: ,ibc_citem_versions_b

879: SELECT
880: ibc_content_items.content_type_code
881: FROM
882: ibc_content_items
883: ,ibc_citem_versions_b
884: WHERE
885: ibc_citem_versions_b.content_item_id = ibc_content_items.content_item_id
886: AND
887: ibc_citem_versions_b.citem_version_id = f_citem_ver_id;

Line 885: ibc_citem_versions_b.content_item_id = ibc_content_items.content_item_id

881: FROM
882: ibc_content_items
883: ,ibc_citem_versions_b
884: WHERE
885: ibc_citem_versions_b.content_item_id = ibc_content_items.content_item_id
886: AND
887: ibc_citem_versions_b.citem_version_id = f_citem_ver_id;
888: temp IBC_CONTENT_TYPES_B.content_type_code%TYPE;
889: BEGIN

Line 887: ibc_citem_versions_b.citem_version_id = f_citem_ver_id;

883: ,ibc_citem_versions_b
884: WHERE
885: ibc_citem_versions_b.content_item_id = ibc_content_items.content_item_id
886: AND
887: ibc_citem_versions_b.citem_version_id = f_citem_ver_id;
888: temp IBC_CONTENT_TYPES_B.content_type_code%TYPE;
889: BEGIN
890: --DBMS_OUTPUT.put_line('----- getContentTypeV -----');
891: OPEN c_ctypev;

Line 921: ibc_citem_versions_b

917: CURSOR c_max IS
918: SELECT
919: MAX(version_number)
920: FROM
921: ibc_citem_versions_b
922: WHERE
923: content_item_id = f_content_item_id;
924:
925: temp NUMBER;

Line 2570: ibc_citem_versions_b

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

Line 2574: ibc_content_items.content_item_id = ibc_citem_versions_b.content_item_id

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

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 2580: ibc_citem_versions_b.citem_version_id = p_citem_ver_id;

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
2583: DBMS_LOB.createtemporary(temp_bundle, TRUE, 2);
2584:

Line 2911: ,ibc_citem_versions_b

2907: ,x_ctype_code
2908: ,x_object_version_number
2909: FROM
2910: ibc_content_items
2911: ,ibc_citem_versions_b
2912: WHERE
2913: IBC_CONTENT_ITEMS.content_item_id = IBC_CITEM_VERSIONS_B.content_item_id
2914: AND
2915: IBC_CITEM_VERSIONS_B.citem_version_id = p_citem_ver_id;

Line 2913: IBC_CONTENT_ITEMS.content_item_id = IBC_CITEM_VERSIONS_B.content_item_id

2909: FROM
2910: ibc_content_items
2911: ,ibc_citem_versions_b
2912: WHERE
2913: IBC_CONTENT_ITEMS.content_item_id = IBC_CITEM_VERSIONS_B.content_item_id
2914: AND
2915: IBC_CITEM_VERSIONS_B.citem_version_id = p_citem_ver_id;
2916: -- Exception Handler Added for NOCOPY Change (11/08/2002) By ENUNEZ
2917: EXCEPTION

Line 2915: IBC_CITEM_VERSIONS_B.citem_version_id = p_citem_ver_id;

2911: ,ibc_citem_versions_b
2912: WHERE
2913: IBC_CONTENT_ITEMS.content_item_id = IBC_CITEM_VERSIONS_B.content_item_id
2914: AND
2915: IBC_CITEM_VERSIONS_B.citem_version_id = p_citem_ver_id;
2916: -- Exception Handler Added for NOCOPY Change (11/08/2002) By ENUNEZ
2917: EXCEPTION
2918: WHEN OTHERS THEN
2919: RAISE;

Line 2942: version_number IBC_CITEM_VERSIONS_B.version_number%TYPE;

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;
2946: attach_fid NUMBER;

Line 2957: ,IBC_CITEM_VERSIONS_B.version_number

2953:
2954: CURSOR info IS
2955: SELECT
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

Line 2958: ,IBC_CITEM_VERSIONS_B.start_date

2954: CURSOR info IS
2955: SELECT
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

Line 2959: ,IBC_CITEM_VERSIONS_B.end_date

2955: SELECT
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

Line 2969: ,IBC_CITEM_VERSIONS_B

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
2971: WHERE
2972: IBC_CONTENT_ITEMS.content_item_id = IBC_CITEM_VERSIONS_B.content_item_id
2973: AND

Line 2972: IBC_CONTENT_ITEMS.content_item_id = IBC_CITEM_VERSIONS_B.content_item_id

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
2975: AND
2976: IBC_CITEM_VERSIONS_TL.citem_version_id = p_citem_ver_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 3419: FROM ibc_citem_versions_b a,

3415: CURSOR c_component_not_status (p_citem_ver_id IN NUMBER,
3416: p_status IN VARCHAR2)
3417: IS
3418: SELECT 'X'
3419: FROM ibc_citem_versions_b a,
3420: ibc_compound_relations b,
3421: ibc_content_items c
3422: WHERE a.citem_version_id = b.citem_version_id
3423: AND b.content_item_id = c.content_item_id

Line 3488: ,ibc_citem_versions_b

3484: ,base_lang
3485: ,dir_id
3486: FROM
3487: ibc_content_items
3488: ,ibc_citem_versions_b
3489: WHERE
3490: ibc_content_items.content_item_id = ibc_citem_versions_b.content_item_id
3491: AND
3492: ibc_citem_versions_b.citem_version_id = p_citem_ver_id;

Line 3490: ibc_content_items.content_item_id = ibc_citem_versions_b.content_item_id

3486: FROM
3487: ibc_content_items
3488: ,ibc_citem_versions_b
3489: WHERE
3490: ibc_content_items.content_item_id = ibc_citem_versions_b.content_item_id
3491: AND
3492: ibc_citem_versions_b.citem_version_id = p_citem_ver_id;
3493:
3494: -- ***************PERMISSION CHECK**********************************

Line 3492: ibc_citem_versions_b.citem_version_id = p_citem_ver_id;

3488: ,ibc_citem_versions_b
3489: WHERE
3490: ibc_content_items.content_item_id = ibc_citem_versions_b.content_item_id
3491: AND
3492: ibc_citem_versions_b.citem_version_id = p_citem_ver_id;
3493:
3494: -- ***************PERMISSION CHECK**********************************
3495: IF (hasPermission(content_item_id) = FND_API.g_false) THEN
3496: --DBMS_OUTPUT.put_line('EX - no lock permissions');

Line 3508: MIN(ibc_citem_versions_b.citem_version_id)

3504:
3505: -- **************CHECKING IF APPROVAL IS ALLOWED ******************
3506: -- can be approved if source lang is already approved or if this is the source lang
3507: SELECT
3508: MIN(ibc_citem_versions_b.citem_version_id)
3509: INTO
3510: temp
3511: FROM
3512: ibc_citem_versions_b

Line 3512: ibc_citem_versions_b

3508: MIN(ibc_citem_versions_b.citem_version_id)
3509: INTO
3510: temp
3511: FROM
3512: ibc_citem_versions_b
3513: ,ibc_citem_versions_tl
3514: WHERE
3515: (
3516: (

Line 3519: ibc_citem_versions_b.citem_version_status = Ibc_Utilities_Pub.G_STV_APPROVED

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
3522: ibc_citem_versions_tl.source_lang = base_lang
3523: )

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 3527: ibc_citem_versions_b.citem_version_id = p_citem_ver_id;

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:
3530: IF (temp IS NULL) THEN
3531: --DBMS_OUTPUT.put_line('EX - version cannot be approved');

Line 6179: ,ibc_citem_versions_b b1

6175: ,ibc_compound_relations.sort_order sor
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

Line 6185: FROM ibc_citem_versions_b b2

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

Line 9275: ibc_citem_versions_b civb,

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
9279: AND

Line 10497: IBC_CITEM_VERSIONS_B CIVER

10493: p_citem_ver_id NUMBER)
10494: IS
10495: SELECT 'X'
10496: FROM IBC_CONTENT_ITEMS CITEM,
10497: IBC_CITEM_VERSIONS_B CIVER
10498: WHERE CITEM.content_item_id = CIVER.content_item_id
10499: AND CITEM.content_item_id = p_content_item_id
10500: AND CIVER.citem_version_id = p_citem_ver_id;
10501:

Line 13256: l_citem_version_status IBC_CITEM_VERSIONS_B.citem_version_status%TYPE;

13252: l_api_version_number CONSTANT NUMBER := G_API_VERSION_DEFAULT; --|**|
13253: --******************* END REQUIRED VARIABLES ****************************
13254: --
13255: l_citem_version_id NUMBER;
13256: l_citem_version_status IBC_CITEM_VERSIONS_B.citem_version_status%TYPE;
13257: l_citem_version_attr_id NUMBER;
13258: l_content_item_id NUMBER;
13259: l_directory_node_id NUMBER;
13260:

Line 14145: FROM ibc_citem_versions_b

14141: l_dummy VARCHAR2(2);
14142: l_result BOOLEAN;
14143: CURSOR cur IS
14144: SELECT 'X'
14145: FROM ibc_citem_versions_b
14146: WHERE content_item_id = p_content_item_id
14147: AND citem_version_status = p_citem_version_status;
14148: BEGIN
14149: l_result := FALSE;