APPS.IBC_UTILITIES_PVT dependencies on IBC_CITEM_VERSIONS_TL

Line 64: FROM ibc_citem_versions_tl

60: RETURN VARCHAR2
61: IS
62: CURSOR c_name(p_content_item_id NUMBER) IS
63: SELECT content_item_name
64: FROM ibc_citem_versions_tl
65: WHERE citem_version_id = (SELECT citem_version_id
66: FROM ibc_citem_versions_b civb
67: WHERE content_item_id = p_content_item_id
68: AND version_number = (SELECT MAX(version_number)

Line 73: l_citem_name IBC_CITEM_VERSIONS_TL.content_item_name%TYPE;

69: FROM ibc_citem_versions_b civb2
70: WHERE civb2.content_item_id = civb.content_item_id)
71: )
72: AND language = USERENV('lang');
73: l_citem_name IBC_CITEM_VERSIONS_TL.content_item_name%TYPE;
74: BEGIN
75: OPEN c_name(p_content_item_id);
76: FETCH c_name INTO l_citem_name;
77: IF c_name%NOTFOUND THEN

Line 1260: ibc_citem_versions_tl citem

1256: default_rendition_mime_type,
1257: attachment_file_id
1258: FROM
1259: IBC_RENDITIONS ren,
1260: ibc_citem_versions_tl citem
1261: WHERE
1262: citem.citem_version_id = ren.citem_version_id(+) AND
1263: citem.LANGUAGE = ren.LANGUAGE(+) AND
1264: NVL(default_rendition_mime_type,' ') = NVL(mime_type,' ')

Line 1302: FROM ibc_citem_versions_tl A

1298:
1299: BEGIN
1300: SELECT DECODE(p_file_type,'ATTRIB',ATTRIBUTE_FILE_ID,'ATTACH',ATTACHMENT_FILE_ID) file_id
1301: INTO l_old_file_id
1302: FROM ibc_citem_versions_tl A
1303: WHERE a.citem_version_id = l_citem_version_id
1304: AND A.LANGUAGE = USERENV('LANG');
1305: EXCEPTION WHEN OTHERS THEN
1306: NULL;

Line 1310: UPDATE IBC_CITEM_VERSIONS_TL SET

1306: NULL;
1307: END;
1308:
1309:
1310: UPDATE IBC_CITEM_VERSIONS_TL SET
1311: ATTRIBUTE_FILE_ID =DECODE(p_file_type,'ATTRIB',p_file_id,ATTRIBUTE_FILE_ID)
1312: ,ATTACHMENT_FILE_ID =DECODE(p_file_type,'ATTACH',p_file_id,ATTACHMENT_FILE_ID)
1313: ,last_update_date =SYSDATE
1314: WHERE CITEM_VERSION_ID IN (

Line 1318: ibc_citem_versions_tl a,

1314: WHERE CITEM_VERSION_ID IN (
1315: SELECT
1316: b.citem_version_id
1317: FROM
1318: ibc_citem_versions_tl a,
1319: ibc_citem_versions_tl b
1320: WHERE
1321: a.citem_version_id = l_citem_version_id AND
1322: NVL(a.attachment_file_id, 0) = NVL(DECODE(p_file_type,'ATTACH',b.attachment_file_id,a.attachment_file_id), 0) AND

Line 1319: ibc_citem_versions_tl b

1315: SELECT
1316: b.citem_version_id
1317: FROM
1318: ibc_citem_versions_tl a,
1319: ibc_citem_versions_tl b
1320: WHERE
1321: a.citem_version_id = l_citem_version_id AND
1322: NVL(a.attachment_file_id, 0) = NVL(DECODE(p_file_type,'ATTACH',b.attachment_file_id,a.attachment_file_id), 0) AND
1323: a.attribute_file_id = DECODE(p_file_type,'ATTRIB',b.attribute_file_id,a.attribute_file_id) AND

Line 1332: SET file_name = (SELECT attachment_file_name FROM ibc_citem_versions_tl

1328:
1329: IF p_file_type='ATTACH' THEN
1330:
1331: UPDATE FND_LOBS
1332: SET file_name = (SELECT attachment_file_name FROM ibc_citem_versions_tl
1333: WHERE attachment_file_id=p_file_id AND ROWNUM=1)
1334: WHERE file_id = p_file_id;
1335:
1336: BEGIN

Line 1367: AND NOT EXISTS (SELECT NULL FROM ibc_citem_versions_tl

1363: END IF;
1364:
1365: DELETE FROM fnd_lobs
1366: WHERE file_id = l_old_file_id
1367: AND NOT EXISTS (SELECT NULL FROM ibc_citem_versions_tl
1368: WHERE DECODE(p_file_type,'ATTRIB',ATTRIBUTE_FILE_ID,'ATTACH',ATTACHMENT_FILE_ID) = l_old_file_id);
1369:
1370:
1371: COMMIT;

Line 1443: ibc_citem_versions_tl civtl

1439:
1440: CURSOR c_chk_name IS
1441: SELECT 'CITEM', civb.content_item_id
1442: FROM ibc_citem_versions_b civb,
1443: ibc_citem_versions_tl civtl
1444: WHERE civb.citem_version_id = civtl.citem_version_id
1445: AND language = NVL(p_language, USERENV('lang'))
1446: AND civb.content_item_id <> NVL(p_chk_content_item_id, -1)
1447: AND EXISTS (SELECT 'X'