PACKAGE: APPS.CS_KB_SESSION_ATTR_PKG

Source

1 PACKAGE CS_KB_SESSION_ATTR_PKG AUTHID CURRENT_USER AS
2 /* $Header: cskbssas.pls 115.5 2002/11/11 23:53:03 mkettle noship $ */
3 
4   /* for return status */
5   ERROR_STATUS      CONSTANT NUMBER      := -1;
6   OKAY_STATUS       CONSTANT NUMBER      := 0;
7 
8   /* Valid session attributes */
9   PRODUCT_ATTR      CONSTANT VARCHAR2(30) := 'PRODUCT';
10 
11   /* HIGH LEVEL TABLE HANDLERS */
12 
13   function add_km_session_attr
14   (
15     X_SESSION_ATTR_ID     OUT NOCOPY NUMBER,
16     P_SESSION_ID           in NUMBER,
17     P_ATTRIBUTE_TYPE       in VARCHAR2,
18     P_ATTRIBUTE_NAME       in VARCHAR2,
19     P_VALUE1               in VARCHAR2,
20     P_VALUE2               in VARCHAR2 DEFAULT NULL
21   ) return number;
22 
23   function update_km_session_attr
24   (
25     P_SESSION_ATTR_ID      in NUMBER,
26     P_SESSION_ID           in NUMBER,
27     P_ATTRIBUTE_TYPE       in VARCHAR2,
28     P_ATTRIBUTE_NAME       in VARCHAR2,
29     P_VALUE1               in VARCHAR2,
30     P_VALUE2               in VARCHAR2 DEFAULT NULL
31   ) return number;
32 
33   function remove_km_session_attr
34   (
35     P_SESSION_ATTR_ID      in NUMBER
36   ) return number;
37 
38   function remove_all_km_session_attrs
39   (
40     P_SESSION_ID           in NUMBER
41   ) return number;
42 
43 
44   /* LOW LEVEL TABLE HANDLERS */
45 
46   procedure INSERT_ROW
47   (
48     X_ROWID                OUT NOCOPY VARCHAR2,
49     X_SESSION_ATTR_ID      OUT NOCOPY NUMBER,
50     P_SESSION_ID            in NUMBER,
51     P_ATTRIBUTE_TYPE        in VARCHAR2,
52     P_ATTRIBUTE_NAME       in VARCHAR2,
53     P_VALUE1                in VARCHAR2,
54     P_VALUE2                in VARCHAR2 DEFAULT NULL,
55     P_CREATION_DATE         in DATE,
56     P_CREATED_BY            in NUMBER,
57     P_LAST_UPDATE_DATE      in DATE,
58     P_LAST_UPDATED_BY       in NUMBER,
59     P_LAST_UPDATE_LOGIN     in NUMBER
60   );
61 
62   procedure UPDATE_ROW
63   (
64     P_SESSION_ATTR_ID       in NUMBER,
65     P_SESSION_ID            in NUMBER,
66     P_ATTRIBUTE_TYPE        in VARCHAR2,
67     P_ATTRIBUTE_NAME       in VARCHAR2,
68     P_VALUE1                in VARCHAR2,
69     P_VALUE2                in VARCHAR2 DEFAULT NULL,
70     P_LAST_UPDATE_DATE      in DATE,
71     P_LAST_UPDATED_BY       in NUMBER,
72     P_LAST_UPDATE_LOGIN     in NUMBER
73   );
74 
75   procedure DELETE_ROW
76   (
77     P_SESSION_ATTR_ID       in NUMBER
78   );
79 
80   procedure LOAD_ROW
81   (
82     P_SESSION_ATTR_ID       in NUMBER,
83     P_SESSION_ID            in NUMBER,
84     P_ATTRIBUTE_TYPE        in VARCHAR2,
85     P_ATTRIBUTE_NAME       in VARCHAR2,
86     P_VALUE1                in VARCHAR2,
87     P_VALUE2                in VARCHAR2 DEFAULT NULL,
88     P_OWNER                 in VARCHAR2
89   );
90 
91 END CS_KB_SESSION_ATTR_PKG;