DBA Data[Home] [Help]

PACKAGE: APPS.IBC_CITEM_KEYWORDS_PKG

Source


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;