1 package CSD_FLOW_STATUSES_PKG AUTHID CURRENT_USER as
2 /* $Header: csdtflss.pls 120.0 2005/06/14 10:10:45 vkjain noship $ */
3
4 procedure INSERT_ROW (
5 -- P_ROWID in out nocopy VARCHAR2,
6 PX_FLOW_STATUS_ID in out nocopy NUMBER,
7 P_FLOW_STATUS_CODE in VARCHAR2,
8 P_STATUS_CODE in VARCHAR2,
9 P_SEEDED_FLAG in VARCHAR2,
10 P_OBJECT_VERSION_NUMBER in NUMBER,
11 P_EXTERNAL_DISPLAY_STATUS in VARCHAR2,
12 P_ATTRIBUTE_CATEGORY in VARCHAR2,
13 P_ATTRIBUTE1 in VARCHAR2,
14 P_ATTRIBUTE2 in VARCHAR2,
15 P_ATTRIBUTE3 in VARCHAR2,
16 P_ATTRIBUTE4 in VARCHAR2,
17 P_ATTRIBUTE5 in VARCHAR2,
18 P_ATTRIBUTE6 in VARCHAR2,
19 P_ATTRIBUTE7 in VARCHAR2,
20 P_ATTRIBUTE8 in VARCHAR2,
21 P_ATTRIBUTE9 in VARCHAR2,
22 P_ATTRIBUTE10 in VARCHAR2,
23 P_ATTRIBUTE11 in VARCHAR2,
24 P_ATTRIBUTE12 in VARCHAR2,
25 P_ATTRIBUTE13 in VARCHAR2,
26 P_ATTRIBUTE14 in VARCHAR2,
27 P_ATTRIBUTE15 in VARCHAR2,
28 P_CREATION_DATE in DATE,
29 P_CREATED_BY in NUMBER,
30 P_LAST_UPDATE_DATE in DATE,
31 P_LAST_UPDATED_BY in NUMBER,
32 P_LAST_UPDATE_LOGIN in NUMBER);
33
34 procedure LOCK_ROW (
35 P_FLOW_STATUS_ID in NUMBER,
36 P_OBJECT_VERSION_NUMBER in NUMBER
37
38 /*
39 P_ATTRIBUTE10 in VARCHAR2,
40 P_ATTRIBUTE11 in VARCHAR2,
41 P_ATTRIBUTE12 in VARCHAR2,
42 P_ATTRIBUTE13 in VARCHAR2,
43 P_ATTRIBUTE14 in VARCHAR2,
44 P_ATTRIBUTE15 in VARCHAR2,
45 P_FLOW_STATUS_CODE in VARCHAR2,
46 P_STATUS_CODE in VARCHAR2,
47 P_SEEDED_FLAG in VARCHAR2,
48 P_ATTRIBUTE8 in VARCHAR2,
49 P_ATTRIBUTE9 in VARCHAR2,
50 P_ATTRIBUTE7 in VARCHAR2,
51 P_ATTRIBUTE_CATEGORY in VARCHAR2,
52 P_ATTRIBUTE1 in VARCHAR2,
53 P_ATTRIBUTE2 in VARCHAR2,
54 P_ATTRIBUTE3 in VARCHAR2,
55 P_ATTRIBUTE4 in VARCHAR2,
56 P_ATTRIBUTE5 in VARCHAR2,
57 P_ATTRIBUTE6 in VARCHAR2,
58 P_EXTERNAL_DISPLAY_STATUS in VARCHAR2
59 */
60 );
61
62 procedure UPDATE_ROW (
63 P_FLOW_STATUS_ID in NUMBER,
64 P_FLOW_STATUS_CODE in VARCHAR2,
65 P_STATUS_CODE in VARCHAR2,
66 P_SEEDED_FLAG in VARCHAR2,
67 P_OBJECT_VERSION_NUMBER in NUMBER,
68 P_EXTERNAL_DISPLAY_STATUS 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 P_LAST_UPDATE_DATE in DATE,
86 P_LAST_UPDATED_BY in NUMBER,
87 P_LAST_UPDATE_LOGIN in NUMBER
88 );
89
90 procedure DELETE_ROW (
91 P_FLOW_STATUS_ID in NUMBER
92 );
93
94 procedure ADD_LANGUAGE;
95
96 end CSD_FLOW_STATUSES_PKG;