PACKAGE: APPS.CS_KB_SESSION_PKG

Source

1 PACKAGE CS_KB_SESSION_PKG AUTHID CURRENT_USER AS
2 /* $Header: cskbsess.pls 120.0 2005/06/01 12:33:09 appldev noship $ */
3 
4   /* for return status */
5   ERROR_STATUS      CONSTANT NUMBER      := -1;
6   OKAY_STATUS       CONSTANT NUMBER      := 0;
7 
8   procedure INSERT_ROW
9   (
10     X_ROWID                OUT NOCOPY VARCHAR2,
11     X_SESSION_ID           OUT NOCOPY NUMBER,
12     P_SOURCE_OBJECT_CODE    in VARCHAR2,
13     P_SOURCE_OBJECT_ID      in NUMBER,
14     P_CREATION_DATE         in DATE,
15     P_CREATED_BY            in NUMBER,
16     P_LAST_UPDATE_DATE      in DATE,
17     P_LAST_UPDATED_BY       in NUMBER,
18     P_LAST_UPDATE_LOGIN     in NUMBER
19   );
20 
21   procedure UPDATE_ROW
22   (
23     P_SESSION_ID            in NUMBER,
24     P_SOURCE_OBJECT_CODE    in VARCHAR2,
25     P_SOURCE_OBJECT_ID      in NUMBER,
26     P_LAST_UPDATE_DATE      in DATE,
27     P_LAST_UPDATED_BY       in NUMBER,
28     P_LAST_UPDATE_LOGIN     in NUMBER
29   );
30 
31   procedure DELETE_ROW
32   (
33     P_SESSION_ID            in NUMBER
34   );
35 
36   procedure LOAD_ROW
37   (
38     P_SESSION_ID            in NUMBER,
39     P_SOURCE_OBJECT_CODE    in VARCHAR2,
40     P_SOURCE_OBJECT_ID      in NUMBER,
41     P_OWNER                 in VARCHAR2
42   );
43 
44 END CS_KB_SESSION_PKG;