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_CONTENT_ITEMS

Line 78: FROM ibc_content_items

74: l_dummy VARCHAR2(2);
75: l_result BOOLEAN;
76: CURSOR chk_refcode IS
77: SELECT 'X'
78: FROM ibc_content_items
79: WHERE content_item_id <> NVL(p_content_item_id, -1)
80: AND item_reference_code = UPPER(p_reference_code);
81: BEGIN
82: l_result := FALSE;

Line 249: ,ibc_content_items

245: SELECT
246: ibc_attribute_types_b.attribute_type_code
247: FROM
248: ibc_attribute_types_b
249: ,ibc_content_items
250: WHERE
251: ibc_content_items.content_item_id = f_citem_id
252: AND
253: ibc_attribute_types_b.content_type_code = ibc_content_items.content_type_code

Line 251: ibc_content_items.content_item_id = f_citem_id

247: FROM
248: ibc_attribute_types_b
249: ,ibc_content_items
250: WHERE
251: ibc_content_items.content_item_id = f_citem_id
252: AND
253: ibc_attribute_types_b.content_type_code = ibc_content_items.content_type_code
254: AND
255: ibc_attribute_types_b.data_type_code = Ibc_Utilities_Pub.G_DTC_ATTACHMENT;

Line 253: ibc_attribute_types_b.content_type_code = ibc_content_items.content_type_code

249: ,ibc_content_items
250: WHERE
251: ibc_content_items.content_item_id = f_citem_id
252: AND
253: ibc_attribute_types_b.content_type_code = ibc_content_items.content_type_code
254: AND
255: ibc_attribute_types_b.data_type_code = Ibc_Utilities_Pub.G_DTC_ATTACHMENT;
256:
257: BEGIN

Line 393: ibc_content_items

389: CURSOR c_base IS
390: SELECT
391: content_item_status
392: FROM
393: ibc_content_items
394: WHERE
395: content_item_id = f_content_item_id;
396:
397: temp IBC_CONTENT_ITEMS.content_item_status%TYPE;

Line 397: temp IBC_CONTENT_ITEMS.content_item_status%TYPE;

393: ibc_content_items
394: WHERE
395: content_item_id = f_content_item_id;
396:
397: temp IBC_CONTENT_ITEMS.content_item_status%TYPE;
398: BEGIN
399: --DBMS_OUTPUT.put_line('----- getBaseLanguage -----');
400:
401: OPEN c_base;

Line 431: ibc_content_items

427: CURSOR c_base IS
428: SELECT
429: base_language
430: FROM
431: ibc_content_items
432: WHERE
433: content_item_id = f_content_item_id;
434:
435: temp IBC_CONTENT_ITEMS.base_language%TYPE;

Line 435: temp IBC_CONTENT_ITEMS.base_language%TYPE;

431: ibc_content_items
432: WHERE
433: content_item_id = f_content_item_id;
434:
435: temp IBC_CONTENT_ITEMS.base_language%TYPE;
436: BEGIN
437: --DBMS_OUTPUT.put_line('----- getBaseLanguage -----');
438:
439: OPEN c_base;

Line 541: ibc_content_items

537: CURSOR c_perm IS
538: SELECT
539: locked_by_user_id
540: FROM
541: ibc_content_items
542: WHERE
543: content_item_id = f_content_item_id
544: AND
545: ( (locked_by_user_id IS NULL)

Line 710: ibc_content_items

706: owner_resource_id
707: ,owner_resource_type
708: ,created_by
709: FROM
710: ibc_content_items
711: WHERE
712: content_item_id = f_content_item_id;
713:
714:

Line 716: ort IBC_CONTENT_ITEMS.owner_resource_type%TYPE;

712: content_item_id = f_content_item_id;
713:
714:
715: ori NUMBER;
716: ort IBC_CONTENT_ITEMS.owner_resource_type%TYPE;
717: cby NUMBER;
718:
719: BEGIN
720: --DBMS_OUTPUT.put_line('----- isItemAdmin-----');

Line 769: ibc_content_items b

765: IS
766: CURSOR c_cct IS
767: SELECT a.reference_code
768: FROM ibc_attribute_types_b a,
769: ibc_content_items b
770: WHERE b.content_item_id = f_content_item_id
771: AND b.content_type_code = a.content_type_code
772: AND a.attribute_type_code = f_attribute_type_code
773: AND a.reference_code = f_content_type_code;

Line 808: ibc_content_items

804: CURSOR c_dir IS
805: SELECT
806: directory_node_id
807: FROM
808: ibc_content_items
809: WHERE
810: content_item_id = f_content_item_id;
811:
812: temp NUMBER;

Line 845: ibc_content_items

841: CURSOR c_ctype IS
842: SELECT
843: content_type_code
844: FROM
845: ibc_content_items
846: WHERE
847: content_item_id = f_content_item_id;
848:
849: temp IBC_CONTENT_TYPES_B.content_type_code%TYPE;

Line 880: ibc_content_items.content_type_code

876: RETURN VARCHAR2
877: IS
878: CURSOR c_ctypev IS
879: SELECT
880: ibc_content_items.content_type_code
881: FROM
882: ibc_content_items
883: ,ibc_citem_versions_b
884: WHERE

Line 882: ibc_content_items

878: CURSOR c_ctypev IS
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

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 961: ibc_content_items

957: CURSOR c_ovn IS
958: SELECT
959: object_version_number
960: FROM
961: ibc_content_items
962: WHERE
963: content_item_id = f_citem_id;
964:
965: temp NUMBER;

Line 999: ibc_content_items

995: IS
996: BEGIN
997: --DBMS_OUTPUT.put_line('----- changeLock -----');
998: UPDATE
999: ibc_content_items
1000: SET
1001: locked_by_user_id = f_new_lock
1002: WHERE
1003: content_item_id = f_content_item_id;

Line 2198: ibc_content_items

2194: MIN(parent_item_id)
2195: INTO
2196: temp
2197: FROM
2198: ibc_content_items
2199: WHERE
2200: content_item_id = p_content_item_ids(counter);
2201:
2202: IF( (temp IS NOT NULL) AND (temp <> p_content_item_id) ) THEN

Line 2558: ibc_content_items.content_type_code

2554: x_return_status := FND_API.G_RET_STS_SUCCESS;
2555:
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

Line 2559: ,ibc_content_items.content_item_id

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

Line 2572: ,ibc_content_items

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
2576: ibc_citem_versions_b.citem_version_id = ibc_citem_versions_tl.citem_version_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 2902: IBC_CONTENT_ITEMS.content_item_id

2898: --******************* END REQUIRED VARIABLES ***************************
2899: BEGIN
2900: --DBMS_OUTPUT.put_line('----- ' || l_api_name || ' -----');
2901: SELECT
2902: IBC_CONTENT_ITEMS.content_item_id
2903: ,IBC_CONTENT_ITEMS.content_type_code
2904: ,IBC_CONTENT_ITEMS.object_version_number
2905: INTO
2906: x_content_item_id

Line 2903: ,IBC_CONTENT_ITEMS.content_type_code

2899: BEGIN
2900: --DBMS_OUTPUT.put_line('----- ' || l_api_name || ' -----');
2901: SELECT
2902: IBC_CONTENT_ITEMS.content_item_id
2903: ,IBC_CONTENT_ITEMS.content_type_code
2904: ,IBC_CONTENT_ITEMS.object_version_number
2905: INTO
2906: x_content_item_id
2907: ,x_ctype_code

Line 2904: ,IBC_CONTENT_ITEMS.object_version_number

2900: --DBMS_OUTPUT.put_line('----- ' || l_api_name || ' -----');
2901: SELECT
2902: IBC_CONTENT_ITEMS.content_item_id
2903: ,IBC_CONTENT_ITEMS.content_type_code
2904: ,IBC_CONTENT_ITEMS.object_version_number
2905: INTO
2906: x_content_item_id
2907: ,x_ctype_code
2908: ,x_object_version_number

Line 2910: ibc_content_items

2906: x_content_item_id
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

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 2956: IBC_CONTENT_ITEMS.object_version_number

2952: temp 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

Line 2968: IBC_CONTENT_ITEMS

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

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 3073: Ibc_Content_Items_Pkg.update_row (

3069: );
3070:
3071: --DBMS_OUTPUT.put_line('APPROVING ITEM');
3072: -- set live version if this is base language
3073: Ibc_Content_Items_Pkg.update_row (
3074: p_CONTENT_ITEM_ID => p_content_item_id
3075: ,p_LIVE_CITEM_VERSION_ID => p_citem_ver_id
3076: ,p_CONTENT_ITEM_STATUS => Ibc_Utilities_Pub.G_STI_APPROVED
3077: ,p_LOCKED_BY_USER_ID => FND_API.G_MISS_NUM -- Updated for STANDARD/perf change of G_MISS_xxx

Line 3410: base_lang IBC_CONTENT_ITEMS.base_language%TYPE;

3406: l_api_version_number CONSTANT NUMBER := G_API_VERSION_DEFAULT; --|**|
3407: --******************* END REQUIRED VARIABLES ***************************
3408: content_item_id NUMBER;
3409: -- variable used to determine whether to update live_version_id
3410: base_lang IBC_CONTENT_ITEMS.base_language%TYPE;
3411: temp NUMBER;
3412: dir_id NUMBER;
3413: l_dummy VARCHAR2(1);
3414:

Line 3421: ibc_content_items c

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
3424: AND a.citem_version_id = p_citem_ver_id
3425: AND c.content_item_status <> p_status;

Line 3479: ibc_content_items.content_item_id

3475: END IF;
3476:
3477: -- getting content item id and base language
3478: SELECT
3479: ibc_content_items.content_item_id
3480: ,ibc_content_items.base_language
3481: ,ibc_content_items.directory_node_id
3482: INTO
3483: content_item_id

Line 3480: ,ibc_content_items.base_language

3476:
3477: -- getting content item id and base language
3478: SELECT
3479: ibc_content_items.content_item_id
3480: ,ibc_content_items.base_language
3481: ,ibc_content_items.directory_node_id
3482: INTO
3483: content_item_id
3484: ,base_lang

Line 3481: ,ibc_content_items.directory_node_id

3477: -- getting content item id and base language
3478: SELECT
3479: ibc_content_items.content_item_id
3480: ,ibc_content_items.base_language
3481: ,ibc_content_items.directory_node_id
3482: INTO
3483: content_item_id
3484: ,base_lang
3485: ,dir_id

Line 3487: ibc_content_items

3483: content_item_id
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

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 3716: FROM ibc_content_items

3712: l_created_by NUMBER;
3713:
3714: CURSOR c_creator(p_content_item_id NUMBER) IS
3715: SELECT created_by
3716: FROM ibc_content_items
3717: WHERE content_item_id = p_content_item_id;
3718:
3719: BEGIN
3720: --DBMS_OUTPUT.put_line('----- ' || l_api_name || ' -----');

Line 3881: Ibc_Content_Items_Pkg.update_row (

3877: -- ***************PERMISSION CHECK*********************************************************************
3878:
3879: -- Actual update
3880: IF p_cascaded_flag = FND_API.g_false THEN
3881: Ibc_Content_Items_Pkg.update_row (
3882: p_content_item_id => p_content_item_id
3883: ,p_content_item_status => Ibc_Utilities_Pub.G_STI_ARCHIVED
3884: ,p_locked_by_user_id => FND_API.G_MISS_NUM -- Updated for STANDARD/perf change of G_MISS_xxx
3885: ,px_object_version_number => px_object_version_number

Line 3888: Ibc_Content_Items_Pkg.update_row (

3884: ,p_locked_by_user_id => FND_API.G_MISS_NUM -- Updated for STANDARD/perf change of G_MISS_xxx
3885: ,px_object_version_number => px_object_version_number
3886: );
3887: ELSE
3888: Ibc_Content_Items_Pkg.update_row (
3889: p_content_item_id => p_content_item_id
3890: ,p_content_item_status => Ibc_Utilities_Pub.G_STI_ARCHIVED_CASCADE
3891: ,p_locked_by_user_id => FND_API.G_MISS_NUM -- Updated for STANDARD/perf change of G_MISS_xxx
3892: ,px_object_version_number => px_object_version_number

Line 4415: o_ctype_code IBC_CONTENT_ITEMS.content_type_code%TYPE;

4411: new_citem_id NUMBER;
4412: new_citem_ver_id NUMBER;
4413: l_new_citem_name VARCHAR2(240) := p_new_citem_name;
4414:
4415: o_ctype_code IBC_CONTENT_ITEMS.content_type_code%TYPE;
4416: o_dir_node NUMBER;
4417: o_parent_id NUMBER;
4418: o_wd_flag IBC_CONTENT_ITEMS.wd_restricted_flag%TYPE;
4419: o_trans_flag IBC_CONTENT_ITEMS.translation_required_flag%TYPE;

Line 4418: o_wd_flag IBC_CONTENT_ITEMS.wd_restricted_flag%TYPE;

4414:
4415: o_ctype_code IBC_CONTENT_ITEMS.content_type_code%TYPE;
4416: o_dir_node NUMBER;
4417: o_parent_id NUMBER;
4418: o_wd_flag IBC_CONTENT_ITEMS.wd_restricted_flag%TYPE;
4419: o_trans_flag IBC_CONTENT_ITEMS.translation_required_flag%TYPE;
4420:
4421: CURSOR c_old_item IS
4422: SELECT

Line 4419: o_trans_flag IBC_CONTENT_ITEMS.translation_required_flag%TYPE;

4415: o_ctype_code IBC_CONTENT_ITEMS.content_type_code%TYPE;
4416: o_dir_node NUMBER;
4417: o_parent_id NUMBER;
4418: o_wd_flag IBC_CONTENT_ITEMS.wd_restricted_flag%TYPE;
4419: o_trans_flag IBC_CONTENT_ITEMS.translation_required_flag%TYPE;
4420:
4421: CURSOR c_old_item IS
4422: SELECT
4423: content_type_code

Line 4429: IBC_CONTENT_ITEMS

4425: ,parent_item_id
4426: ,wd_restricted_flag
4427: ,translation_required_flag
4428: FROM
4429: IBC_CONTENT_ITEMS
4430: WHERE
4431: content_item_id = px_content_item_id;
4432:
4433: /*

Line 4610: IBC_CONTENT_ITEMS_PKG.insert_row(

4606:
4607:
4608: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4609: -- ******* GOT INFO, NOW CREATE! ************************************
4610: IBC_CONTENT_ITEMS_PKG.insert_row(
4611: x_rowid => row_id
4612: ,px_content_item_id => new_citem_id
4613: ,p_content_type_code => o_ctype_code
4614: ,p_item_reference_code => p_item_reference_code

Line 6171: ,ibc_content_items.owner_resource_id orid

6167: CURSOR c_components(p_citem_version_id NUMBER,
6168: p_language VARCHAR2)
6169: IS
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

Line 6172: ,ibc_content_items.owner_resource_type ort

6168: p_language VARCHAR2)
6169: IS
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

Line 6178: ,ibc_content_items

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

Line 6182: AND b1.content_item_id = ibc_content_items.content_item_id

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
6186: WHERE b1.content_item_id = b2.content_item_id

Line 6183: AND ibc_content_items.content_item_id = ibc_compound_relations.content_item_id

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
6186: WHERE b1.content_item_id = b2.content_item_id
6187: )

Line 8645: status IBC_CONTENT_ITEMS.content_item_status%TYPE := Ibc_Utilities_Pub.G_STI_PENDING;

8641: l_api_version_number CONSTANT NUMBER := G_API_VERSION_DEFAULT; --|**|
8642: --******************* END REQUIRED VARIABLES ***************************
8643: row_id VARCHAR2(250); -- required for use with table handlers
8644: locked_by NUMBER; -- variable used to set locked_by column (logic needed)
8645: status IBC_CONTENT_ITEMS.content_item_status%TYPE := Ibc_Utilities_Pub.G_STI_PENDING;
8646: current_version NUMBER;
8647: BEGIN
8648: --DBMS_OUTPUT.put_line('----- ' || l_api_name || ' -----');
8649: --******************* BEGIN REQUIRED AREA ******************************

Line 8811: -- inserting new row into ibc_content_items

8807: END IF;
8808:
8809: IF (px_content_item_id IS NULL) THEN
8810: -- create new content item
8811: -- inserting new row into ibc_content_items
8812: Ibc_Content_Items_Pkg.insert_row(
8813: x_rowid => row_id
8814: ,px_content_item_id => px_content_item_id
8815: ,p_content_type_code => p_ctype_code

Line 8812: Ibc_Content_Items_Pkg.insert_row(

8808:
8809: IF (px_content_item_id IS NULL) THEN
8810: -- create new content item
8811: -- inserting new row into ibc_content_items
8812: Ibc_Content_Items_Pkg.insert_row(
8813: x_rowid => row_id
8814: ,px_content_item_id => px_content_item_id
8815: ,p_content_type_code => p_ctype_code
8816: ,p_item_reference_code => NULL

Line 9276: ibc_content_items ci

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
9280: civb.citem_version_id = p_citem_ver_id

Line 10331: Ibc_Content_Items_Pkg.update_row (

10327: -- ***************PERMISSION CHECK*********************************************************************
10328:
10329: -- *** UPDATING DATA IN DB *********
10330: -- Updating Content Item
10331: Ibc_Content_Items_Pkg.update_row (
10332: p_content_item_id => p_content_item_id
10333: ,p_directory_node_id => Conv_To_TblHandler(directory_node) -- Update for STANDARD/perf change of G_MISS_xxx
10334: ,p_wd_restricted_flag => Conv_To_TblHandler(p_wd_restricted) -- Updated for STANDARD/perf change of G_MISS_xxx
10335: ,p_translation_required_flag => Conv_To_TblHandler(p_trans_required) -- Updated for STANDARD/perf change of G_MISS_xxx

Line 10496: FROM IBC_CONTENT_ITEMS CITEM,

10492: CURSOR c_chk_citem (p_content_item_id NUMBER,
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;

Line 10610: Ibc_Content_Items_Pkg.update_row (

10606: END IF; --|*|
10607: END IF; --|*|
10608: -- ***************PERMISSION CHECK*********************************************************************
10609:
10610: Ibc_Content_Items_Pkg.update_row (
10611: p_CONTENT_ITEM_ID => p_content_item_id
10612: ,p_LIVE_CITEM_VERSION_ID => p_citem_ver_id
10613: ,px_object_version_number => px_object_version_number
10614: );

Line 11042: new_status IBC_CONTENT_ITEMS.content_item_status%TYPE;

11038: --******************* BEGIN REQUIRED VARIABLES *************************
11039: l_api_name CONSTANT VARCHAR2(30) := 'unarchive_item'; --|**|
11040: l_api_version_number CONSTANT NUMBER := G_API_VERSION_DEFAULT; --|**|
11041: --******************* END REQUIRED VARIABLES ***************************
11042: new_status IBC_CONTENT_ITEMS.content_item_status%TYPE;
11043: base_lang IBC_CONTENT_ITEMS.base_language%TYPE;
11044: citem_version_id NUMBER;
11045: locked_by NUMBER;
11046: temp NUMBER;

Line 11043: base_lang IBC_CONTENT_ITEMS.base_language%TYPE;

11039: l_api_name CONSTANT VARCHAR2(30) := 'unarchive_item'; --|**|
11040: l_api_version_number CONSTANT NUMBER := G_API_VERSION_DEFAULT; --|**|
11041: --******************* END REQUIRED VARIABLES ***************************
11042: new_status IBC_CONTENT_ITEMS.content_item_status%TYPE;
11043: base_lang IBC_CONTENT_ITEMS.base_language%TYPE;
11044: citem_version_id NUMBER;
11045: locked_by NUMBER;
11046: temp NUMBER;
11047: dir_id NUMBER;

Line 11120: ibc_content_items

11116: ,base_lang
11117: ,locked_by
11118: ,dir_id
11119: FROM
11120: ibc_content_items
11121: WHERE
11122: content_item_id = p_content_item_id;
11123:
11124: -- ***************PERMISSION CHECK*********************************************************************

Line 11177: Ibc_Content_Items_Pkg.update_row (

11173: END IF;
11174: END IF;
11175:
11176: -- Actual changing of status if made it to this point
11177: Ibc_Content_Items_Pkg.update_row (
11178: p_content_item_id => p_content_item_id
11179: ,p_content_item_status => new_status
11180: ,p_locked_by_user_id => FND_API.G_MISS_NUM -- Updated for STANDARD/perf change of G_MISS_xxx
11181: ,px_object_version_number => px_object_version_number

Line 11405: ibc_content_items

11401: -- ***************PERMISSION CHECK*********************************************************************
11402:
11403: -- ACTUAL UNLOCKING!
11404: UPDATE
11405: ibc_content_items
11406: SET
11407: locked_by_user_id = NULL
11408: WHERE
11409: content_item_id = p_content_item_id;

Line 11578: bulk_status IBC_CONTENT_ITEMS.content_item_status%TYPE;

11574: l_rendition_id NUMBER;
11575: bundle_text CLOB; -- tempory blob
11576: bundle_file_id NUMBER; -- pointer to actual FND_LOB location
11577: -- status used when creating not using approved until it passes without any errors
11578: bulk_status IBC_CONTENT_ITEMS.content_item_status%TYPE;
11579: purge_old VARCHAR2(1) := FND_API.g_true;
11580: current_version NUMBER := 1;
11581: tempfid NUMBER;
11582: directory_node NUMBER;

Line 11896: Ibc_Content_Items_Pkg.insert_row(

11892: END IF; --|*|
11893: -- ***************PERMISSION CHECK*********************************************************************
11894:
11895: --DBMS_OUTPUT.put_line('ITEM - INSERT ROW');
11896: Ibc_Content_Items_Pkg.insert_row(
11897: x_ROWID => row_id
11898: ,px_CONTENT_ITEM_ID => px_content_item_id
11899: ,p_CONTENT_TYPE_CODE => p_ctype_code
11900: ,p_ITEM_REFERENCE_CODE => p_reference_code

Line 11949: Ibc_Content_Items_Pkg.update_row(

11945: END IF; --|*|
11946: -- ***************PERMISSION CHECK*********************************************************************
11947:
11948: --DBMS_OUTPUT.put_line('ITEM - UPDATE ROW');
11949: Ibc_Content_Items_Pkg.update_row(
11950: p_CONTENT_ITEM_ID => px_content_item_id
11951: ,p_ITEM_REFERENCE_CODE => Conv_To_TblHandler(p_reference_code) -- Updated for STANDARD/perf change of G_MISS_xxx
11952: ,p_DIRECTORY_NODE_ID => Conv_To_TblHandler(directory_node) -- Updated for STANDARD/perf change of G_MISS_xxx
11953: ,p_LOCKED_BY_USER_ID => Conv_To_TblHandler(locked_by) -- Updated for STANDARD/perf change of G_MISS_xxx

Line 13652: DELETE FROM IBC_CONTENT_ITEMS WHERE CONTENT_ITEM_ID = l_citem_id;

13648: -- if UI disable deletion of children items)
13649: DELETE FROM IBC_COMPOUND_RELATIONS WHERE CONTENT_ITEM_ID = l_citem_id;
13650:
13651: -- Delete itself
13652: DELETE FROM IBC_CONTENT_ITEMS WHERE CONTENT_ITEM_ID = l_citem_id;
13653:
13654: -- Delete from Version Labels
13655: DELETE FROM IBC_CITEM_VERSION_LABELS WHERE CONTENT_ITEM_ID = l_citem_id;
13656:

Line 14173: FROM ibc_content_items

14169: l_dummy VARCHAR2(2);
14170: l_result BOOLEAN;
14171: CURSOR cur IS
14172: SELECT 'X'
14173: FROM ibc_content_items
14174: WHERE content_item_id = p_content_item_id
14175: AND NVL(locked_by_user_id,FND_GLOBAL.user_id) = FND_GLOBAL.user_id;
14176: BEGIN
14177: l_result := FALSE;