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_VERSIONS_PKG dependencies on IBC_CITEM_VERSIONS_B

Line 63: CURSOR C IS SELECT ROWID FROM IBC_CITEM_VERSIONS_B

59: ,p_last_update_login IN NUMBER --DEFAULT NULL
60: ,p_citem_translation_status IN VARCHAR2 --DEFAULT NULL
61: )
62: IS
63: CURSOR C IS SELECT ROWID FROM IBC_CITEM_VERSIONS_B
64: WHERE CITEM_VERSION_ID = px_CITEM_VERSION_ID;
65:
66: CURSOR c2 IS SELECT ibc_citem_versions_s1.NEXTVAL FROM dual;
67:

Line 123: INSERT INTO IBC_CITEM_VERSIONS_B (

119: FETCH c2 INTO px_CITEM_VERSION_ID;
120: CLOSE c2;
121: END IF;
122:
123: INSERT INTO IBC_CITEM_VERSIONS_B (
124: CITEM_VERSION_ID,
125: CONTENT_ITEM_ID,
126: VERSION_NUMBER,
127: CITEM_VERSION_STATUS,

Line 213: FROM IBC_CITEM_VERSIONS_B verb

209: -- Update Content Item Name for all versions of current language
210: UPDATE IBC_CITEM_VERSIONS_TL
211: SET CONTENT_ITEM_NAME = DECODE(p_content_item_name,Fnd_Api.G_MISS_CHAR,NULL,NULL,content_item_name,p_content_item_name)
212: WHERE citem_version_id IN (SELECT citem_version_id
213: FROM IBC_CITEM_VERSIONS_B verb
214: WHERE verb.content_item_id = p_content_item_id);
215:
216:
217: END INSERT_ROW;

Line 249: FROM ibc_citem_versions_b

245: CURSOR c_prev_version(p_content_item_id NUMBER,
246: p_citem_version_id NUMBER)
247: IS
248: SELECT citem_version_id
249: FROM ibc_citem_versions_b
250: WHERE content_item_id = p_content_item_id
251: AND version_number < (SELECT version_number
252: FROM ibc_citem_versions_b
253: WHERE content_item_id = p_content_item_id

Line 252: FROM ibc_citem_versions_b

248: SELECT citem_version_id
249: FROM ibc_citem_versions_b
250: WHERE content_item_id = p_content_item_id
251: AND version_number < (SELECT version_number
252: FROM ibc_citem_versions_b
253: WHERE content_item_id = p_content_item_id
254: AND citem_version_id = p_citem_version_id)
255: ORDER BY version_number desc;
256:

Line 432: CURSOR C IS SELECT ROWID FROM IBC_CITEM_VERSIONS_B

428: )
429:
430:
431: IS
432: CURSOR C IS SELECT ROWID FROM IBC_CITEM_VERSIONS_B
433: WHERE CITEM_VERSION_ID = px_CITEM_VERSION_ID;
434: CURSOR c2 IS SELECT ibc_citem_versions_s1.NEXTVAL FROM dual;
435:
436: CURSOR c_citem_dirnode(p_content_item_id NUMBER)

Line 489: INSERT INTO IBC_CITEM_VERSIONS_B (

485: FETCH c2 INTO px_CITEM_VERSION_ID;
486: CLOSE c2;
487: END IF;
488:
489: INSERT INTO IBC_CITEM_VERSIONS_B (
490: CITEM_VERSION_ID,
491: CONTENT_ITEM_ID,
492: VERSION_NUMBER,
493: CITEM_VERSION_STATUS,

Line 587: FROM IBC_CITEM_VERSIONS_B verb

583: -- Update Content Item Name for all versions of current language
584: UPDATE IBC_CITEM_VERSIONS_TL
585: SET CONTENT_ITEM_NAME = DECODE(p_content_item_name,Fnd_Api.G_MISS_CHAR,NULL,NULL,content_item_name,p_content_item_name)
586: WHERE citem_version_id IN (SELECT citem_version_id
587: FROM IBC_CITEM_VERSIONS_B verb
588: WHERE verb.content_item_id = p_content_item_id);
589:
590: END INSERT_BASE_LANG;
591:

Line 613: FROM IBC_CITEM_VERSIONS_B

609: CITEM_VERSION_STATUS,
610: START_DATE,
611: END_DATE,
612: OBJECT_VERSION_NUMBER
613: FROM IBC_CITEM_VERSIONS_B
614: WHERE CITEM_VERSION_ID = p_CITEM_VERSION_ID
615: FOR UPDATE OF CITEM_VERSION_ID NOWAIT;
616: recinfo c%ROWTYPE;
617:

Line 738: UPDATE IBC_CITEM_VERSIONS_B SET

734: ,px_OBJECT_VERSION_NUMBER =>px_object_version_number
735: ,p_last_updated_by =>p_last_updated_by);
736:
737:
738: UPDATE IBC_CITEM_VERSIONS_B SET
739: content_item_id = DECODE(p_content_item_id,FND_API.G_MISS_NUM,NULL,NULL,content_item_id,p_content_item_id)
740: ,version_number = DECODE(p_version_number,FND_API.G_MISS_NUM,NULL,NULL,version_number,p_version_number)
741: ,citem_version_status = DECODE(p_citem_version_status,FND_API.G_MISS_CHAR,NULL,NULL,citem_version_status,p_citem_version_status)
742: ,start_date = DECODE(p_start_date,FND_API.G_MISS_DATE,NULL,NULL,start_date,p_start_date)

Line 819: FROM IBC_CITEM_VERSIONS_B verb

815: UPDATE IBC_CITEM_VERSIONS_TL
816: SET CONTENT_ITEM_NAME = DECODE(p_content_item_name,FND_API.G_MISS_CHAR,NULL,NULL,content_item_name,p_content_item_name)
817: WHERE P_SOURCE_LANG IN (LANGUAGE, SOURCE_LANG)
818: AND EXISTS (SELECT 'X'
819: FROM IBC_CITEM_VERSIONS_B verb
820: WHERE verb.content_item_id = p_content_item_id
821: AND IBC_CITEM_VERSIONS_TL.citem_version_id = verb.citem_version_id
822: );
823:

Line 862: DELETE FROM IBC_CITEM_VERSIONS_B

858: RAISE Fnd_Api.G_EXC_ERROR;
859: --RAISE NO_DATA_FOUND;
860: END IF;
861:
862: DELETE FROM IBC_CITEM_VERSIONS_B
863: WHERE CITEM_VERSION_ID = p_CITEM_VERSION_ID;
864:
865: IF (SQL%NOTFOUND) THEN
866: Fnd_Message.Set_Name('IBC', 'IBC_ERROR_RETURNED');

Line 881: FROM IBC_CITEM_VERSIONS_B B

877: BEGIN
878: DELETE FROM IBC_CITEM_VERSIONS_TL T
879: WHERE NOT EXISTS
880: (SELECT NULL
881: FROM IBC_CITEM_VERSIONS_B B
882: WHERE B.CITEM_VERSION_ID = T.CITEM_VERSION_ID
883: );
884:
885: UPDATE IBC_CITEM_VERSIONS_TL T SET (

Line 1031: FROM IBC_CITEM_VERSIONS_B

1027: l_last_update_date := nvl(TO_DATE(p_last_update_date, 'YYYY/MM/DD'),SYSDATE);
1028:
1029: -- get updatedby and update_date values if existing in db
1030: SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE INTO db_user_id, db_last_update_date
1031: FROM IBC_CITEM_VERSIONS_B
1032: WHERE CITEM_VERSION_ID = p_CITEM_VERSION_ID;
1033:
1034: -- Validation of Unique Name in a particular directory for a especific
1035: -- Language.

Line 1167: FROM IBC_CITEM_VERSIONS_B

1163:
1164: -- Validation of Unique Name in a particular directory for a especific
1165: -- Language.
1166: FOR r_citem IN (SELECT content_item_id
1167: FROM IBC_CITEM_VERSIONS_B
1168: WHERE citem_version_id = p_citem_version_id)
1169: LOOP
1170: OPEN c_citem_dirnode(r_citem.content_item_id);
1171: FETCH c_citem_dirnode INTO l_dirnode;