1 package CSD_BULLETINS_PKG as
2 /* $Header: csdtbuls.pls 120.0.12010000.1 2008/12/11 01:03:19 swai noship $ */
3
4
5 procedure INSERT_ROW (
6 PX_ROWID in out nocopy VARCHAR2,
7 PX_BULLETIN_ID in out nocopy NUMBER,
8 P_OBJECT_VERSION_NUMBER in NUMBER,
9 P_CREATION_DATE in DATE,
10 P_CREATED_BY in NUMBER,
11 P_LAST_UPDATE_DATE in DATE,
12 P_LAST_UPDATED_BY in NUMBER,
13 P_LAST_UPDATE_LOGIN in NUMBER,
14 P_NAME in VARCHAR2,
15 P_DESCRIPTION in VARCHAR2,
16 P_BULLETIN_TYPE_CODE in VARCHAR2,
17 P_ACTIVE_FROM in DATE,
18 P_ACTIVE_TO in DATE,
19 P_PUBLISHED_FLAG in VARCHAR2,
20 P_ESCALATION_CODE in VARCHAR2,
21 P_MANDATORY_FLAG in VARCHAR2,
22 P_FREQUENCY_CODE in VARCHAR2,
23 P_WF_ITEM_TYPE in VARCHAR2,
24 P_WF_PROCESS_NAME in VARCHAR2,
25 P_ATTRIBUTE_CATEGORY in VARCHAR2,
26 P_ATTRIBUTE1 in VARCHAR2,
27 P_ATTRIBUTE2 in VARCHAR2,
28 P_ATTRIBUTE3 in VARCHAR2,
29 P_ATTRIBUTE4 in VARCHAR2,
30 P_ATTRIBUTE5 in VARCHAR2,
31 P_ATTRIBUTE6 in VARCHAR2,
32 P_ATTRIBUTE7 in VARCHAR2,
33 P_ATTRIBUTE8 in VARCHAR2,
34 P_ATTRIBUTE9 in VARCHAR2,
35 P_ATTRIBUTE10 in VARCHAR2,
36 P_ATTRIBUTE11 in VARCHAR2,
37 P_ATTRIBUTE12 in VARCHAR2,
38 P_ATTRIBUTE13 in VARCHAR2,
39 P_ATTRIBUTE14 in VARCHAR2,
40 P_ATTRIBUTE15 in VARCHAR2
41 );
42
43
44
45 procedure LOCK_ROW (
46 P_BULLETIN_ID in NUMBER,
47 P_OBJECT_VERSION_NUMBER in NUMBER
48 );
49
50 procedure UPDATE_ROW (
51 P_BULLETIN_ID in NUMBER,
52 P_OBJECT_VERSION_NUMBER in NUMBER,
53 P_CREATION_DATE in DATE,
54 P_CREATED_BY in NUMBER,
55 P_LAST_UPDATE_DATE in DATE,
56 P_LAST_UPDATED_BY in NUMBER,
57 P_LAST_UPDATE_LOGIN in NUMBER,
58 P_NAME in VARCHAR2,
59 P_DESCRIPTION in VARCHAR2,
60 P_BULLETIN_TYPE_CODE in VARCHAR2,
61 P_ACTIVE_FROM in DATE,
62 P_ACTIVE_TO in DATE,
63 P_PUBLISHED_FLAG in VARCHAR2,
64 P_ESCALATION_CODE in VARCHAR2,
65 P_MANDATORY_FLAG in VARCHAR2,
66 P_FREQUENCY_CODE in VARCHAR2,
67 P_WF_ITEM_TYPE in VARCHAR2,
68 P_WF_PROCESS_NAME in VARCHAR2,
69 P_ATTRIBUTE_CATEGORY in VARCHAR2,
70 P_ATTRIBUTE1 in VARCHAR2,
71 P_ATTRIBUTE2 in VARCHAR2,
72 P_ATTRIBUTE3 in VARCHAR2,
73 P_ATTRIBUTE4 in VARCHAR2,
74 P_ATTRIBUTE5 in VARCHAR2,
75 P_ATTRIBUTE6 in VARCHAR2,
76 P_ATTRIBUTE7 in VARCHAR2,
77 P_ATTRIBUTE8 in VARCHAR2,
78 P_ATTRIBUTE9 in VARCHAR2,
79 P_ATTRIBUTE10 in VARCHAR2,
80 P_ATTRIBUTE11 in VARCHAR2,
81 P_ATTRIBUTE12 in VARCHAR2,
82 P_ATTRIBUTE13 in VARCHAR2,
83 P_ATTRIBUTE14 in VARCHAR2,
84 P_ATTRIBUTE15 in VARCHAR2
85 );
86
87 procedure DELETE_ROW (
88 P_BULLETIN_ID in NUMBER
89 );
90
91 procedure ADD_LANGUAGE;
92
93 end CSD_BULLETINS_PKG;