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_PKG

Line 1436: IBC_CITEM_VERSIONS_PKG.insert_base_lang(

1432: --DBMS_OUTPUT.put_line('insert base lang with citem_id '||px_content_item_id||' and citem_ver_id '||new_citem_ver_id|| 'and ovn '||px_object_version_number);
1433:
1434: -- new_citem_ver_id should always be null since a new version is created with EVERY copy
1435: -- ****RENDITIONS_WORK****
1436: IBC_CITEM_VERSIONS_PKG.insert_base_lang(
1437: x_rowid => row_id
1438: ,px_citem_version_id => new_citem_ver_id
1439: ,p_content_item_id => px_content_item_id
1440: ,p_version_number => new_ver_num

Line 1495: Ibc_Citem_Versions_Pkg.POPULATE_ALL_ATTACHMENTS(new_citem_ver_id,p_language);

1491: WHERE citem_version_id = px_citem_ver_id
1492: AND LANGUAGE <> p_language;
1493:
1494: --Bug Fix: 3623676
1495: Ibc_Citem_Versions_Pkg.POPULATE_ALL_ATTACHMENTS(new_citem_ver_id,p_language);
1496:
1497: END IF;
1498:
1499: -- insert renditions --------------------------------

Line 3062: Ibc_Citem_Versions_Pkg.update_row(

3058: -- doing actual updates
3059: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3060: --DBMS_OUTPUT.put_line('APPROVING VERSION');
3061: -- update version status
3062: Ibc_Citem_Versions_Pkg.update_row(
3063: p_CITEM_VERSION_ID => p_citem_ver_id
3064: ,p_content_item_id => p_content_item_id
3065: ,p_CITEM_VERSION_STATUS => Ibc_Utilities_Pub.G_STV_APPROVED
3066: ,P_SOURCE_LANG => p_base_lang

Line 3084: Ibc_Citem_Versions_Pkg.populate_all_lang (

3080:
3081: --DBMS_OUTPUT.put_line('POPULATING ALL LANGS');
3082: -- populating all the other languages
3083: -- ****RENDITIONS_WORK****
3084: Ibc_Citem_Versions_Pkg.populate_all_lang (
3085: p_CITEM_VERSION_ID => temp
3086: ,p_CONTENT_ITEM_ID => p_content_item_id
3087: ,p_VERSION_NUMBER => version_number
3088: ,p_CITEM_VERSION_STATUS => Ibc_Utilities_Pub.G_STV_APPROVED

Line 4174: Ibc_Citem_Versions_Pkg.update_row(

4170: ELSE
4171:
4172: --DBMS_OUTPUT.put_line('sending to update row with civid/ciid/stat/lang/ovn :'||p_citem_ver_id||' / '||content_item_id||' / '||p_new_status||' / '||p_language||' / '||px_object_version_number);
4173: -- update version status
4174: Ibc_Citem_Versions_Pkg.update_row(
4175: p_CITEM_VERSION_ID => p_citem_ver_id
4176: ,p_content_item_id => content_item_id
4177: ,p_CITEM_VERSION_STATUS => p_new_status
4178: ,P_SOURCE_LANG => p_language

Line 8852: Ibc_Citem_Versions_Pkg.insert_base_lang(

8848: END IF;
8849:
8850:
8851: -- inserting new row into ibc_citem_versions
8852: Ibc_Citem_Versions_Pkg.insert_base_lang(
8853: x_rowid => row_id
8854: ,px_citem_version_id => x_citem_ver_id
8855: ,p_content_item_id => px_content_item_id
8856: ,p_version_number => current_version

Line 9567: Ibc_Citem_Versions_Pkg.update_row(

9563: FND_MSG_PUB.ADD;
9564: RAISE FND_API.G_EXC_ERROR;
9565: ELSE
9566: -- adding attribute bundle file id to citem version if bundle went in correctly
9567: Ibc_Citem_Versions_Pkg.update_row(
9568: p_citem_version_id => p_citem_ver_id
9569: ,p_content_item_id => content_item_id
9570: ,p_attribute_file_id => file_id
9571: ,px_object_version_number => px_object_version_number

Line 9979: Ibc_Citem_Versions_Pkg.update_row (

9975: -- ***************PERMISSION CHECK*********************************************************************
9976:
9977: -- Adding data
9978: -- ****RENDITIONS_WORK****
9979: Ibc_Citem_Versions_Pkg.update_row (
9980: p_citem_version_id => p_citem_ver_id
9981: ,p_content_item_id => content_item_id
9982: ,p_attachment_file_id => Conv_To_TblHandler(p_attach_file_id) -- Updated for STANDARD/perf change of G_MISS_xxx
9983: ,p_attachment_file_name => Conv_To_TblHandler(att_file_name) -- Updated for STANDARD/perf change of G_MISS_xxx

Line 10874: Ibc_Citem_Versions_Pkg.update_row (

10870: END IF; --|*|
10871: -- ***************PERMISSION CHECK*********************************************************************
10872:
10873: -- Updating Content Item Version
10874: Ibc_Citem_Versions_Pkg.update_row (
10875: p_citem_version_id => p_citem_ver_id
10876: ,p_content_item_id => content_item_id
10877: ,p_start_date => Conv_To_TblHandler(p_start_date) -- Updated for STANDARD/perf change of G_MISS_xxx
10878: ,p_end_date => Conv_To_TblHandler(p_end_date) -- Updated for STANDARD/perf change of G_MISS_xxx

Line 12130: Ibc_Citem_Versions_Pkg.insert_base_lang(

12126:
12127: --DBMS_OUTPUT.put_line('VERSION - INSERT BASE LANG');
12128:
12129: -- ****RENDITIONS_WORK****
12130: Ibc_Citem_Versions_Pkg.insert_base_lang(
12131: X_ROWID => row_id
12132: ,PX_CITEM_VERSION_ID => px_citem_ver_id
12133: ,P_CONTENT_ITEM_ID => px_content_item_id
12134: ,P_VERSION_NUMBER => current_version

Line 12218: Ibc_Citem_Versions_Pkg.update_row(

12214:
12215: --DBMS_OUTPUT.put_line('VERSION - UPDATE ROW');
12216: -- updating row in ibc_citem_versions
12217: -- ****RENDITIONS_WORK****
12218: Ibc_Citem_Versions_Pkg.update_row(
12219: P_CITEM_VERSION_ID => px_citem_ver_id
12220: ,P_CONTENT_ITEM_ID => px_content_item_id
12221: ,P_SOURCE_LANG => lang
12222: ,P_CITEM_VERSION_STATUS => Conv_To_TblHandler(bulk_status) -- Updated for STANDARD/perf change of G_MISS_xxx

Line 12302: Ibc_Citem_Versions_Pkg.update_row(

12298: END LOOP;
12299:
12300: --DBMS_OUTPUT.put_line('VERSION - UPDATE POST APPROVAL ROW');
12301: --updating row in ibc_citem_versions
12302: Ibc_Citem_Versions_Pkg.update_row(
12303: P_CITEM_VERSION_ID => px_citem_ver_id
12304: ,P_CONTENT_ITEM_ID => px_content_item_id
12305: ,P_SOURCE_LANG => lang
12306: ,P_CONTENT_ITEM_NAME => Conv_To_TblHandler(p_citem_name) -- Updated for STANDARD/perf change of G_MISS_xxx

Line 13376: Ibc_Citem_Versions_Pkg.DELETE_ROW(l_citem_version_id);

13372:
13373: END IF; -- End checking if this version belongs to the same content item
13374:
13375: -- Delete version
13376: Ibc_Citem_Versions_Pkg.DELETE_ROW(l_citem_version_id);
13377:
13378: -- Delete Renditions
13379: DELETE FROM ibc_renditions WHERE citem_Version_id = l_citem_version_id;
13380:

Line 13631: Ibc_Citem_Versions_Pkg.DELETE_ROW(citem_version_rec.CITEM_VERSION_ID);

13627: -- ***************PERMISSION CHECK**********************************************************************
13628:
13629: FOR citem_version_rec IN Get_Item_Versions LOOP
13630: -- Delete version
13631: Ibc_Citem_Versions_Pkg.DELETE_ROW(citem_version_rec.CITEM_VERSION_ID);
13632:
13633: -- Delete Renditions
13634: DELETE FROM ibc_renditions WHERE citem_version_id = citem_version_Rec.citem_version_id;
13635:

Line 13942: Ibc_Citem_Versions_Pkg.update_row(

13938: -- ***************PERMISSION CHECK*********************************************************************
13939:
13940: px_object_version_number := NULL;
13941: -- update version status
13942: Ibc_Citem_Versions_Pkg.update_row(
13943: p_CITEM_VERSION_ID => p_citem_ver_id
13944: ,p_content_item_id => content_item_id
13945: ,p_citem_translation_status => p_new_status
13946: ,P_SOURCE_LANG => p_language