APPS.IBC_CITEM_VERSIONS_PKG dependencies on IBC_CONTENT_ITEMS

Line 71: FROM ibc_content_items citems

67:
68: CURSOR c_citem_dirnode(p_content_item_id NUMBER)
69: IS
70: SELECT directory_node_id
71: FROM ibc_content_items citems
72: WHERE content_item_id = p_content_item_id;
73:
74:
75: l_dirnode NUMBER;

Line 107: Ibc_Content_Items_Pkg.UPDATE_ROW (

103: -- RAISE Fnd_Api.G_EXC_ERROR;
104: -- END IF;
105:
106:
107: Ibc_Content_Items_Pkg.UPDATE_ROW (
108: p_CONTENT_ITEM_ID =>p_CONTENT_ITEM_ID
109: ,px_OBJECT_VERSION_NUMBER =>px_object_version_number
110: ,p_last_updated_by =>p_last_updated_by);
111:

Line 260: FROM ibc_content_items citems

256:
257: CURSOR c_citem_dirnode(p_content_item_id NUMBER)
258: IS
259: SELECT directory_node_id
260: FROM ibc_content_items citems
261: WHERE content_item_id = p_content_item_id;
262:
263: l_prev_version_id NUMBER;
264: l_dirnode NUMBER;

Line 439: FROM ibc_content_items citems

435:
436: CURSOR c_citem_dirnode(p_content_item_id NUMBER)
437: IS
438: SELECT directory_node_id
439: FROM ibc_content_items citems
440: WHERE content_item_id = p_content_item_id;
441:
442: l_dirnode NUMBER;
443:

Line 474: Ibc_Content_Items_Pkg.UPDATE_ROW (

470: RAISE Fnd_Api.G_EXC_ERROR;
471: END IF;
472:
473:
474: Ibc_Content_Items_Pkg.UPDATE_ROW (
475: p_CONTENT_ITEM_ID =>p_CONTENT_ITEM_ID
476: ,px_OBJECT_VERSION_NUMBER =>px_object_version_number
477: ,p_last_updated_by =>p_last_updated_by);
478:

Line 695: FROM ibc_content_items citems

691:
692: CURSOR c_citem_dirnode(p_content_item_id NUMBER)
693: IS
694: SELECT directory_node_id
695: FROM ibc_content_items citems
696: WHERE content_item_id = p_content_item_id;
697:
698: l_dirnode NUMBER;
699:

Line 732: Ibc_Content_Items_Pkg.UPDATE_ROW (

728: RAISE Fnd_Api.G_EXC_ERROR;
729: END IF;
730:
731:
732: Ibc_Content_Items_Pkg.UPDATE_ROW (
733: p_CONTENT_ITEM_ID =>p_CONTENT_ITEM_ID
734: ,px_OBJECT_VERSION_NUMBER =>px_object_version_number
735: ,p_last_updated_by =>p_last_updated_by);
736:

Line 1004: FROM ibc_content_items citems

1000:
1001: CURSOR c_citem_dirnode(p_content_item_id NUMBER)
1002: IS
1003: SELECT directory_node_id
1004: FROM ibc_content_items citems
1005: WHERE content_item_id = p_content_item_id;
1006:
1007: l_dirnode NUMBER;
1008:

Line 1059: FROM IBC_CONTENT_ITEMS

1055: RAISE Fnd_Api.G_EXC_ERROR;
1056: END IF;
1057:
1058: SELECT MAX(object_version_number) INTO lx_object_version_number
1059: FROM IBC_CONTENT_ITEMS
1060: WHERE content_item_id = p_content_item_id;
1061:
1062: IF (FND_LOAD_UTIL.UPLOAD_TEST(l_user_id, l_last_update_date,
1063: db_user_id, db_last_update_date, p_upload_mode )) THEN

Line 1091: FROM IBC_CONTENT_ITEMS

1087: EXCEPTION
1088: WHEN no_data_found THEN
1089:
1090: SELECT MAX(object_version_number) INTO lx_object_version_number
1091: FROM IBC_CONTENT_ITEMS
1092: WHERE content_item_id = p_content_item_id;
1093:
1094: Ibc_Citem_Versions_Pkg.INSERT_ROW (
1095: X_ROWID => l_row_id,

Line 1143: FROM ibc_content_items citems

1139:
1140: CURSOR c_citem_dirnode(p_content_item_id NUMBER)
1141: IS
1142: SELECT directory_node_id
1143: FROM ibc_content_items citems
1144: WHERE content_item_id = p_content_item_id;
1145:
1146: l_dirnode NUMBER;
1147: l_object_type VARCHAR2(30);