APPS.IBC_CITEM_ADMIN_GRP dependencies on IBC_CITEM_KEYWORDS

Line 4471: FROM ibc_citem_keywords

4467:
4468:
4469: CURSOR c_keywords(p_content_item_id NUMBER) IS
4470: SELECT keyword
4471: FROM ibc_citem_keywords
4472: WHERE content_item_id = p_content_item_id;
4473:
4474: BEGIN
4475: --DBMS_OUTPUT.put_line('----- ' || l_api_name || ' -----');

Line 4644: IBC_CITEM_KEYWORDS_PKG.insert_row(

4640: );
4641:
4642: -- ***** COPY KEYWORDS ********************************************
4643: FOR r_keyword IN c_keywords(px_content_item_id) LOOP
4644: IBC_CITEM_KEYWORDS_PKG.insert_row(
4645: x_rowid => row_id
4646: ,p_content_item_id => new_citem_id
4647: ,p_keyword => r_keyword.keyword
4648: ,p_object_version_number => 1

Line 6202: FROM ibc_citem_keywords

6198: AND LANGUAGE = p_language;
6199:
6200: CURSOR c_keywords(p_content_item_id NUMBER) IS
6201: SELECT keyword
6202: FROM ibc_citem_keywords
6203: WHERE content_item_id = p_content_item_id;
6204:
6205: CURSOR c_lob(p_file_id NUMBER) IS
6206: SELECT file_name, file_content_type

Line 12401: FROM ibc_citem_keywords

12397: -- On Update
12398: IF ((do_version IN (G_COMMAND_UPDATE,G_COMMAND_POST_APPROVAL_UPDATE)) AND
12399: (p_update = FND_API.g_true) ) THEN
12400: DELETE
12401: FROM ibc_citem_keywords
12402: WHERE content_item_id = px_content_item_id;
12403: END IF;
12404:
12405: IF ( (p_keywords IS NOT NULL)

Line 12411: IBC_CITEM_KEYWORDS_PKG.insert_row(

12407: (x_return_status = FND_API.G_RET_STS_SUCCESS)
12408: )
12409: THEN
12410: FOR I IN 1..p_keywords.COUNT LOOP
12411: IBC_CITEM_KEYWORDS_PKG.insert_row(
12412: x_rowid => row_id
12413: ,p_content_item_id => px_content_item_id
12414: ,p_keyword => p_keywords(I)
12415: ,p_object_version_number => 1

Line 13644: DELETE FROM ibc_citem_keywords WHERE CONTENT_ITEM_ID = l_citem_id;

13640: DELETE FROM IBC_COMPOUND_RELATIONS WHERE CITEM_VERSION_ID = citem_version_rec.CITEM_VERSION_ID;
13641: END LOOP;
13642:
13643: -- Delete citem keywords
13644: DELETE FROM ibc_citem_keywords WHERE CONTENT_ITEM_ID = l_citem_id;
13645:
13646: -- Delete itself from being a child (this should not be needed,
13647: -- if UI disable deletion of children items)
13648: DELETE FROM IBC_COMPOUND_RELATIONS WHERE CONTENT_ITEM_ID = l_citem_id;