1 PACKAGE Ibc_citem_keywords_Pkg AUTHID CURRENT_USER AS
2 /* $Header: ibctkwds.pls 115.2 2003/06/23 21:14:25 srrangar noship $*/
3
4 -- Purpose: Table Handler for Ibc_Citem_Keywords table.
5
6 -- MODIFICATION HISTORY
7 -- Person Date Comments
8 -- --------- ------ ------------------------------------------
9 -- Edward Nunez 06/12/2003 Created Package
10
11 PROCEDURE INSERT_ROW (
12 x_ROWID OUT NOCOPY VARCHAR2,
13 p_CONTENT_ITEM_ID IN NUMBER,
14 p_KEYWORD IN VARCHAR2,
15 p_OBJECT_VERSION_NUMBER IN NUMBER,
16 p_CREATION_DATE IN DATE DEFAULT NULL,
17 p_CREATED_BY IN NUMBER DEFAULT NULL,
18 p_LAST_UPDATE_DATE IN DATE DEFAULT NULL,
19 p_LAST_UPDATED_BY IN NUMBER DEFAULT NULL
20 );
21
22 PROCEDURE LOCK_ROW (
23 p_CONTENT_ITEM_ID IN NUMBER,
24 p_KEYWORD IN VARCHAR2,
25 p_OBJECT_VERSION_NUMBER IN NUMBER
26 );
27
28 PROCEDURE UPDATE_ROW (
29 p_CONTENT_ITEM_ID IN NUMBER,
30 p_KEYWORD IN VARCHAR2,
31 px_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER
32 ,p_last_update_date IN DATE DEFAULT NULL
33 ,p_last_updated_by IN NUMBER DEFAULT NULL
34 );
35
36 PROCEDURE DELETE_ROW (
37 p_CONTENT_ITEM_ID IN NUMBER,
38 p_KEYWORD IN VARCHAR2
39 );
40
41 PROCEDURE LOAD_ROW (
42 p_CONTENT_ITEM_ID IN NUMBER,
43 p_KEYWORD IN VARCHAR2,
44 p_OWNER IN VARCHAR2
45 );
46
47 END Ibc_citem_keywords_Pkg;