1 package JTF_TASK_CUSTOM_COLORS_PKG AUTHID CURRENT_USER as
2 /* $Header: jtftkcls.pls 115.2 2002/12/04 02:27:46 sachoudh ship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out nocopy VARCHAR2,
5 X_RULE_ID in NUMBER,
6 X_COLOR_DETERMINATION_PRIORITY in NUMBER,
7 X_TYPE_ID in NUMBER,
8 X_PRIORITY_ID in NUMBER,
9 X_ASSIGNMENT_STATUS_ID in NUMBER,
10 X_ESCALATED_TASK in VARCHAR2,
11 X_ACTIVE_FLAG in VARCHAR2,
12 X_BACKGROUND_COL_DEC in NUMBER,
13 X_BACKGROUND_COL_RGB in VARCHAR2,
14 X_CREATION_DATE in DATE,
15 X_CREATED_BY in NUMBER,
16 X_LAST_UPDATE_DATE in DATE,
17 X_LAST_UPDATED_BY in NUMBER,
18 X_LAST_UPDATE_LOGIN in NUMBER);
19
20 procedure LOCK_ROW (
21 X_RULE_ID in NUMBER,
22 X_OBJECT_VERSION_NUMBER in NUMBER
23 );
24
25 procedure UPDATE_ROW (
26 X_RULE_ID in NUMBER,
27 X_OBJECT_VERSION_NUMBER in NUMBER,
28 X_COLOR_DETERMINATION_PRIORITY in NUMBER,
29 X_TYPE_ID in NUMBER,
30 X_PRIORITY_ID in NUMBER,
31 X_ASSIGNMENT_STATUS_ID in NUMBER,
32 X_ESCALATED_TASK in VARCHAR2,
33 X_ACTIVE_FLAG in VARCHAR2,
34 X_BACKGROUND_COL_DEC in NUMBER,
35 X_BACKGROUND_COL_RGB in VARCHAR2,
36 X_LAST_UPDATE_DATE in DATE,
37 X_LAST_UPDATED_BY in NUMBER,
38 X_LAST_UPDATE_LOGIN in NUMBER
39 );
40
41 procedure DELETE_ROW (
42 X_RULE_ID in NUMBER
43 );
44
45 end JTF_TASK_CUSTOM_COLORS_PKG;