1 PACKAGE ASG_PUB_PKG as
2 /* $Header: asgppubs.pls 120.1 2005/08/12 02:53:24 saradhak noship $ */
3
4 --
5 -- Table handler for ASG_PUB table.
6 --
7 -- HISTORY
8 -- JUL 16, 2003 ytian Added ADDITIONAL_DEVICE_TYPE column.
9 -- MAR 11, 2003 yazhang add shared_by
10 -- AUG 30, 2002 ytian Added ENABLE_SYNCH.
11 -- JUN 06 2002 ytian Modified device_type to varchar2.
12 -- MAR. 11, 2002 ytian Created.
13 --
14
15 procedure insert_row (
16 x_PUB_ID in VARCHAR2,
17 x_NAME in VARCHAR2,
18 x_ENABLED in VARCHAR2,
19 x_STATUS in VARCHAR2,
20 x_LAST_RELEASE_VERSION in NUMBER,
21 x_CURRENT_RELEASE_VERSION in NUMBER,
22 x_WRAPPER_NAME in VARCHAR2,
23 x_DEVICE_TYPE in VARCHAR2,
24 x_ENABLE_SYNCH in VARCHAR2,
25 x_NEED_RESOURCEID in VARCHAR2,
26 x_CUSTOM in VARCHAR2,
27 x_SHARED_BY in VARCHAR2,
28 x_ADDITIONAL_DEVICE_TYPE in VARCHAR2,
29 x_CREATION_DATE in DATE,
30 x_CREATED_BY in NUMBER,
31 x_LAST_UPDATE_DATE in DATE,
32 x_LAST_UPDATED_BY in NUMBER);
33
34
35 procedure update_row (
36 x_PUB_ID in VARCHAR2,
37 x_NAME in VARCHAR2,
38 x_ENABLED in VARCHAR2,
39 x_STATUS in VARCHAR2,
40 x_LAST_RELEASE_VERSION in NUMBER,
41 x_CURRENT_RELEASE_VERSION in NUMBER,
42 x_WRAPPER_NAME in VARCHAR2,
43 x_DEVICE_TYPE in VARCHAR2,
44 x_ENABLE_SYNCH in VARCHAR2,
45 x_NEED_RESOURCEID in VARCHAR2,
46 x_CUSTOM in VARCHAR2,
47 x_SHARED_BY in VARCHAR2,
48 x_ADDITIONAL_DEVICE_TYPE in VARCHAR2,
49 x_CREATION_DATE in DATE,
50 x_CREATED_BY in NUMBER,
51 x_LAST_UPDATE_DATE in DATE,
52 x_LAST_UPDATED_BY in NUMBER);
53
54
55 procedure load_row (
56 x_PUB_ID in VARCHAR2,
57 x_NAME in VARCHAR2,
58 x_ENABLED in VARCHAR2,
59 x_STATUS in VARCHAR2,
60 x_LAST_RELEASE_VERSION in NUMBER,
61 x_CURRENT_RELEASE_VERSION in NUMBER,
62 x_WRAPPER_NAME in VARCHAR2,
63 x_DEVICE_TYPE in VARCHAR2,
64 x_ENABLE_SYNCH in VARCHAR2,
65 x_NEED_RESOURCEID in VARCHAR2,
66 x_CUSTOM in VARCHAR2,
67 x_SHARED_BY in VARCHAR2,
68 x_ADDITIONAL_DEVICE_TYPE in VARCHAR2,
69 x_CREATION_DATE in DATE,
70 x_CREATED_BY in NUMBER,
71 x_LAST_UPDATE_DATE in DATE,
72 x_LAST_UPDATED_BY in NUMBER,
73 p_owner in VARCHAR2);
74
75 END ASG_PUB_PKG;