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_TL

Line 151: INSERT INTO IBC_CITEM_VERSIONS_TL (

147: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
148: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
149: );
150:
151: INSERT INTO IBC_CITEM_VERSIONS_TL (
152: CITEM_VERSION_ID,
153: ATTRIBUTE_FILE_ID,
154: ATTACHMENT_ATTRIBUTE_CODE,
155: CONTENT_ITEM_NAME,

Line 189: FROM IBC_CITEM_VERSIONS_TL T

185: FROM FND_LANGUAGES L
186: WHERE L.INSTALLED_FLAG IN ('I', 'B')
187: AND NOT EXISTS
188: (SELECT NULL
189: FROM IBC_CITEM_VERSIONS_TL T
190: WHERE T.CITEM_VERSION_ID = px_CITEM_VERSION_ID
191: AND T.LANGUAGE = L.LANGUAGE_CODE);
192:
193: OPEN c;

Line 210: UPDATE IBC_CITEM_VERSIONS_TL

206: -- Reverting back the previous change. In R12 Enhancement Bug 3664840 Content Item Name should be the same
207: -- across all versions for that language
208:
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);

Line 300: INSERT INTO IBC_CITEM_VERSIONS_TL (

296: OPEN c_prev_version(p_content_item_id, p_citem_version_id);
297: FETCH c_prev_version INTO l_prev_version_id;
298: IF c_prev_version%FOUND THEN
299:
300: INSERT INTO IBC_CITEM_VERSIONS_TL (
301: CITEM_VERSION_ID,
302: ATTRIBUTE_FILE_ID,
303: ATTACHMENT_ATTRIBUTE_CODE,
304: CONTENT_ITEM_NAME,

Line 338: FROM ibc_citem_versions_tl L

334: NULL, Fnd_Global.login_id, p_last_update_login),
335: language,
336: DECODE(P_SOURCE_LANG, Fnd_Api.G_MISS_CHAR,USERENV('LANG'), NULL, USERENV('LANG'),P_SOURCE_LANG),
337: DECODE(p_CITEM_TRANSLATION_STATUS,Fnd_Api.G_MISS_CHAR,NULL,p_CITEM_TRANSLATION_STATUS)
338: FROM ibc_citem_versions_tl L
339: WHERE L.citem_version_id = l_prev_version_id
340: AND NOT EXISTS
341: (SELECT NULL
342: FROM IBC_CITEM_VERSIONS_TL T

Line 342: FROM IBC_CITEM_VERSIONS_TL T

338: FROM ibc_citem_versions_tl L
339: WHERE L.citem_version_id = l_prev_version_id
340: AND NOT EXISTS
341: (SELECT NULL
342: FROM IBC_CITEM_VERSIONS_TL T
343: WHERE T.CITEM_VERSION_ID = p_CITEM_VERSION_ID
344: AND T.LANGUAGE = L.LANGUAGE);
345:
346: END IF;

Line 350: INSERT INTO IBC_CITEM_VERSIONS_TL (

346: END IF;
347: CLOSE c_prev_version;
348: END IF;
349:
350: INSERT INTO IBC_CITEM_VERSIONS_TL (
351: CITEM_VERSION_ID,
352: ATTRIBUTE_FILE_ID,
353: ATTACHMENT_ATTRIBUTE_CODE,
354: CONTENT_ITEM_NAME,

Line 393: FROM IBC_CITEM_VERSIONS_TL T

389: FROM FND_LANGUAGES L
390: WHERE L.INSTALLED_FLAG IN ('I', 'B')
391: AND NOT EXISTS
392: (SELECT NULL
393: FROM IBC_CITEM_VERSIONS_TL T
394: WHERE T.CITEM_VERSION_ID = p_CITEM_VERSION_ID
395: AND T.LANGUAGE = L.LANGUAGE_CODE);
396:
397: -- Added by svatsa

Line 522: INSERT INTO IBC_CITEM_VERSIONS_TL (

518: DECODE(p_last_update_login, Fnd_Api.G_MISS_NUM, Fnd_Global.login_id,
519: NULL, Fnd_Global.login_id, p_last_update_login)
520: );
521:
522: INSERT INTO IBC_CITEM_VERSIONS_TL (
523: CITEM_VERSION_ID,
524: ATTRIBUTE_FILE_ID,
525: ATTACHMENT_ATTRIBUTE_CODE,
526: CONTENT_ITEM_NAME,

Line 584: UPDATE IBC_CITEM_VERSIONS_TL

580: -- Reverting back the previous change. In R12 Enhancement Bug 3664840 Content Item Name should be the same
581: -- across all versions for that language
582:
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);

Line 623: FROM IBC_CITEM_VERSIONS_TL

619: ATTRIBUTE_FILE_ID,
620: CONTENT_ITEM_NAME,
621: DESCRIPTION,
622: DECODE(LANGUAGE, USERENV('LANG'), 'Y', 'N') BASELANG
623: FROM IBC_CITEM_VERSIONS_TL
624: WHERE CITEM_VERSION_ID = p_CITEM_VERSION_ID
625: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG)
626: FOR UPDATE OF CITEM_VERSION_ID NOWAIT;
627: BEGIN

Line 767: UPDATE IBC_CITEM_VERSIONS_TL SET

763: RAISE Fnd_Api.G_EXC_ERROR;
764: END IF;
765:
766: --Bug Fix:3589057
767: UPDATE IBC_CITEM_VERSIONS_TL SET
768: content_item_name = DECODE(p_content_item_name,FND_API.G_MISS_CHAR,NULL,NULL,content_item_name,p_content_item_name)
769: ,description = DECODE(p_description,FND_API.G_MISS_CHAR,NULL,NULL,description,p_description)
770: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
771: ,last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)

Line 787: UPDATE IBC_CITEM_VERSIONS_TL SET

783: RAISE Fnd_Api.G_EXC_ERROR;
784: END IF;
785:
786: --Bug Fix:3589057
787: UPDATE IBC_CITEM_VERSIONS_TL SET
788: attribute_file_id = DECODE(p_attribute_file_id,FND_API.G_MISS_NUM,NULL,NULL,attribute_file_id,p_attribute_file_id)
789: ,attachment_file_id = DECODE(p_attachment_file_id,FND_API.G_MISS_NUM,NULL,NULL,attachment_file_id,p_attachment_file_id)
790: ,attachment_file_name = DECODE(p_attachment_file_name,FND_API.G_MISS_CHAR,NULL,NULL,attachment_file_name,p_attachment_file_name)
791: ,attachment_attribute_code = DECODE(p_attachment_attribute_code,FND_API.G_MISS_CHAR,NULL,NULL,attachment_attribute_code,p_attachment_attribute_code)

Line 815: UPDATE IBC_CITEM_VERSIONS_TL

811: -- Reverting back the previous change. In R12 Enhancement Bug 3664840 Content Item Name should be the same
812: -- across all versions for that language
813:
814: -- Update Content Item Name for all versions of current language
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

Line 821: AND IBC_CITEM_VERSIONS_TL.citem_version_id = verb.citem_version_id

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:
824: --
825: -- submits a concurrent request

Line 850: DELETE FROM IBC_CITEM_VERSIONS_TL

846:
847: G_API_NAME CONSTANT VARCHAR2(30) := 'DELETE_ROW';
848:
849: BEGIN
850: DELETE FROM IBC_CITEM_VERSIONS_TL
851: WHERE CITEM_VERSION_ID = p_CITEM_VERSION_ID;
852:
853: IF (SQL%NOTFOUND) THEN
854: Fnd_Message.Set_Name('IBC', 'IBC_ERROR_RETURNED');

Line 878: DELETE FROM IBC_CITEM_VERSIONS_TL T

874:
875: PROCEDURE ADD_LANGUAGE
876: IS
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

Line 885: UPDATE IBC_CITEM_VERSIONS_TL T SET (

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 (
886: ATTACHMENT_ATTRIBUTE_CODE,
887: ATTRIBUTE_FILE_ID,
888: CONTENT_ITEM_NAME,
889: DESCRIPTION,

Line 903: FROM IBC_CITEM_VERSIONS_TL B

899: B.ATTACHMENT_FILE_NAME,
900: B.ATTACHMENT_FILE_ID,
901: B.default_rendition_mime_type,
902: B.citem_translation_status
903: FROM IBC_CITEM_VERSIONS_TL B
904: WHERE B.CITEM_VERSION_ID = T.CITEM_VERSION_ID
905: AND B.LANGUAGE = T.SOURCE_LANG)
906: WHERE (
907: T.CITEM_VERSION_ID,

Line 912: FROM IBC_CITEM_VERSIONS_TL SUBB, IBC_CITEM_VERSIONS_TL SUBT

908: T.LANGUAGE
909: ) IN (SELECT
910: SUBT.CITEM_VERSION_ID,
911: SUBT.LANGUAGE
912: FROM IBC_CITEM_VERSIONS_TL SUBB, IBC_CITEM_VERSIONS_TL SUBT
913: WHERE SUBB.CITEM_VERSION_ID = SUBT.CITEM_VERSION_ID
914: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
915: AND (SUBB.ATTACHMENT_ATTRIBUTE_CODE <> SUBT.ATTACHMENT_ATTRIBUTE_CODE
916: OR (SUBB.ATTACHMENT_ATTRIBUTE_CODE IS NULL AND SUBT.ATTACHMENT_ATTRIBUTE_CODE IS NOT NULL)

Line 935: INSERT INTO IBC_CITEM_VERSIONS_TL (

931: OR (SUBB.default_rendition_mime_type IS NULL AND SUBT.default_rendition_mime_type IS NOT NULL)
932: OR (SUBB.default_rendition_mime_type IS NOT NULL AND SUBT.default_rendition_mime_type IS NULL)
933: ));
934:
935: INSERT INTO IBC_CITEM_VERSIONS_TL (
936: ATTACHMENT_FILE_ID,
937: ATTACHMENT_FILE_NAME,
938: CITEM_VERSION_ID,
939: ATTACHMENT_ATTRIBUTE_CODE,

Line 971: FROM IBC_CITEM_VERSIONS_TL B, FND_LANGUAGES L

967: B.SECURITY_GROUP_ID,
968: L.LANGUAGE_CODE,
969: B.SOURCE_LANG,
970: B.citem_translation_status
971: FROM IBC_CITEM_VERSIONS_TL B, FND_LANGUAGES L
972: WHERE L.INSTALLED_FLAG IN ('I', 'B')
973: AND B.LANGUAGE = USERENV('LANG')
974: AND NOT EXISTS
975: (SELECT NULL

Line 976: FROM IBC_CITEM_VERSIONS_TL T

972: WHERE L.INSTALLED_FLAG IN ('I', 'B')
973: AND B.LANGUAGE = USERENV('LANG')
974: AND NOT EXISTS
975: (SELECT NULL
976: FROM IBC_CITEM_VERSIONS_TL T
977: WHERE T.CITEM_VERSION_ID = B.CITEM_VERSION_ID
978: AND T.LANGUAGE = L.LANGUAGE_CODE);
979: END ADD_LANGUAGE;
980:

Line 1160: FROM IBC_CITEM_VERSIONS_TL

1156: l_last_update_date := nvl(TO_DATE(p_last_update_date, 'YYYY/MM/DD'),SYSDATE);
1157:
1158: -- get updatedby and update_date values if existing in db
1159: SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE INTO db_user_id, db_last_update_date
1160: FROM IBC_CITEM_VERSIONS_TL
1161: WHERE CITEM_VERSION_ID = p_CITEM_VERSION_ID
1162: AND USERENV('LANG') IN (LANGUAGE, source_lang);
1163:
1164: -- Validation of Unique Name in a particular directory for a especific

Line 1198: UPDATE IBC_CITEM_VERSIONS_TL

1194: IF (FND_LOAD_UTIL.UPLOAD_TEST(l_user_id, l_last_update_date,
1195: db_user_id, db_last_update_date, p_upload_mode )) THEN
1196:
1197: -- Only update rows which have not been altered by user
1198: UPDATE IBC_CITEM_VERSIONS_TL
1199: SET
1200: ATTRIBUTE_FILE_ID = (SELECT ATTRIBUTE_FILE_ID FROM IBC_CITEM_VERSIONS_TL
1201: WHERE citem_version_id = p_citem_version_id
1202: AND LANGUAGE = 'US'),

Line 1200: ATTRIBUTE_FILE_ID = (SELECT ATTRIBUTE_FILE_ID FROM IBC_CITEM_VERSIONS_TL

1196:
1197: -- Only update rows which have not been altered by user
1198: UPDATE IBC_CITEM_VERSIONS_TL
1199: SET
1200: ATTRIBUTE_FILE_ID = (SELECT ATTRIBUTE_FILE_ID FROM IBC_CITEM_VERSIONS_TL
1201: WHERE citem_version_id = p_citem_version_id
1202: AND LANGUAGE = 'US'),
1203: ATTACHMENT_FILE_ID = (SELECT ATTACHMENT_FILE_ID FROM IBC_CITEM_VERSIONS_TL
1204: WHERE citem_version_id = p_citem_version_id

Line 1203: ATTACHMENT_FILE_ID = (SELECT ATTACHMENT_FILE_ID FROM IBC_CITEM_VERSIONS_TL

1199: SET
1200: ATTRIBUTE_FILE_ID = (SELECT ATTRIBUTE_FILE_ID FROM IBC_CITEM_VERSIONS_TL
1201: WHERE citem_version_id = p_citem_version_id
1202: AND LANGUAGE = 'US'),
1203: ATTACHMENT_FILE_ID = (SELECT ATTACHMENT_FILE_ID FROM IBC_CITEM_VERSIONS_TL
1204: WHERE citem_version_id = p_citem_version_id
1205: AND LANGUAGE = 'US'),
1206: CONTENT_ITEM_NAME = p_CONTENT_ITEM_NAME,
1207: ATTACHMENT_FILE_NAME = p_ATTACHMENT_FILE_NAME,

Line 1233: FROM ibc_citem_versions_tl

1229:
1230: CURSOR version_cur (cv_version_id NUMBER
1231: ,cv_language VARCHAR2) IS
1232: SELECT attachment_file_id
1233: FROM ibc_citem_versions_tl
1234: WHERE citem_version_id = cv_version_id
1235: AND language = cv_language
1236: AND attachment_file_id IS NOT NULL;
1237: base_ver_rec version_cur%ROWTYPE;

Line 1244: FROM ibc_citem_versions_tl

1240:
1241: CURSOR trans_ver_cur (cv_version_id NUMBER
1242: ,cv_base_language VARCHAR2) IS
1243: SELECT citem_version_id, language, attachment_file_id
1244: FROM ibc_citem_versions_tl
1245: WHERE citem_version_id = cv_version_id
1246: AND language <> cv_base_language FOR UPDATE;
1247: trans_ver_rec trans_ver_cur%ROWTYPE ;
1248:

Line 1290: -- Update the file_id in ibc_citem_versions_tl

1286: ,file_format
1287: FROM fnd_lobs
1288: WHERE file_id = trans_ver_rec.attachment_file_id;
1289:
1290: -- Update the file_id in ibc_citem_versions_tl
1291: UPDATE ibc_citem_versions_tl
1292: SET attachment_file_id = fnd_lobs_s.currval
1293: WHERE citem_version_id = trans_ver_rec.citem_version_id
1294: AND language = trans_ver_rec.language;

Line 1291: UPDATE ibc_citem_versions_tl

1287: FROM fnd_lobs
1288: WHERE file_id = trans_ver_rec.attachment_file_id;
1289:
1290: -- Update the file_id in ibc_citem_versions_tl
1291: UPDATE ibc_citem_versions_tl
1292: SET attachment_file_id = fnd_lobs_s.currval
1293: WHERE citem_version_id = trans_ver_rec.citem_version_id
1294: AND language = trans_ver_rec.language;
1295: END LOOP;

Line 1309: FROM ibc_citem_versions_tl

1305:
1306: CURSOR version_cur (cv_version_id NUMBER
1307: ,cv_language VARCHAR2) IS
1308: SELECT attachment_file_id
1309: FROM ibc_citem_versions_tl
1310: WHERE citem_version_id = cv_version_id
1311: AND LANGUAGE = cv_language
1312: AND attachment_file_id IS NOT NULL;
1313: base_ver_rec version_cur%ROWTYPE;

Line 1320: FROM ibc_citem_versions_tl

1316:
1317: CURSOR trans_ver_cur (cv_version_id NUMBER
1318: ,cv_base_language VARCHAR2) IS
1319: SELECT citem_version_id, LANGUAGE, attachment_file_id
1320: FROM ibc_citem_versions_tl
1321: WHERE citem_version_id = cv_version_id;
1322: -- AND LANGUAGE <> cv_base_language FOR UPDATE;
1323: trans_ver_rec trans_ver_cur%ROWTYPE ;
1324:

Line 1366: -- Update the file_id in ibc_citem_versions_tl

1362: ,file_format
1363: FROM fnd_lobs
1364: WHERE file_id = trans_ver_rec.attachment_file_id;
1365:
1366: -- Update the file_id in ibc_citem_versions_tl
1367: UPDATE ibc_citem_versions_tl
1368: SET attachment_file_id = fnd_lobs_s.CURRVAL
1369: WHERE citem_version_id = trans_ver_rec.citem_version_id
1370: AND LANGUAGE = trans_ver_rec.LANGUAGE;

Line 1367: UPDATE ibc_citem_versions_tl

1363: FROM fnd_lobs
1364: WHERE file_id = trans_ver_rec.attachment_file_id;
1365:
1366: -- Update the file_id in ibc_citem_versions_tl
1367: UPDATE ibc_citem_versions_tl
1368: SET attachment_file_id = fnd_lobs_s.CURRVAL
1369: WHERE citem_version_id = trans_ver_rec.citem_version_id
1370: AND LANGUAGE = trans_ver_rec.LANGUAGE;
1371: END LOOP;