1 package CS_SR_SAVED_ADV_CRITERIA_PKG AUTHID CURRENT_USER as
2 /* $Header: csxtssas.pls 115.1 2003/09/18 04:44:59 aktripat noship $*/
3
4 procedure INSERT_ROW ( X_ROWID in out nocopy VARCHAR2,
5 X_SEARCH_ID in NUMBER,
6 X_FIELD_NAME in VARCHAR2,
7 X_ROWNUM_IN_LAYOUT in NUMBER,
8 X_FIELD_NAME_ID in VARCHAR2,
9 X_CONDITION in VARCHAR2,
10 X_FIELD_VALUE_ID in VARCHAR2,
11 X_OBJECT_VERSION_NUMBER in NUMBER,
12 X_FIELD_VALUE in VARCHAR2,
13 X_CREATION_DATE in DATE,
14 X_CREATED_BY in NUMBER,
15 X_LAST_UPDATE_DATE in DATE,
16 X_LAST_UPDATED_BY in NUMBER,
17 X_LAST_UPDATE_LOGIN in NUMBER,
18 X_COMMIT_FLAG in VARCHAR2);
19
20 procedure LOCK_ROW ( X_SEARCH_ID in NUMBER,
21 X_FIELD_NAME in VARCHAR2,
22 X_ROWNUM_IN_LAYOUT in NUMBER,
23 X_FIELD_NAME_ID in VARCHAR2,
24 X_CONDITION in VARCHAR2,
25 X_FIELD_VALUE_ID in VARCHAR2,
26 X_OBJECT_VERSION_NUMBER in NUMBER,
27 X_SECURITY_GROUP_ID in NUMBER,
28 X_FIELD_VALUE in VARCHAR2);
29
30 procedure UPDATE_ROW ( X_SEARCH_ID in NUMBER,
31 X_FIELD_NAME in VARCHAR2,
32 X_ROWNUM_IN_LAYOUT in NUMBER,
33 X_FIELD_NAME_ID in VARCHAR2,
34 X_CONDITION in VARCHAR2,
35 X_FIELD_VALUE_ID in VARCHAR2,
36 X_OBJECT_VERSION_NUMBER in NUMBER,
37 X_SECURITY_GROUP_ID in NUMBER,
38 X_FIELD_VALUE in VARCHAR2,
39 X_LAST_UPDATE_DATE in DATE,
40 X_LAST_UPDATED_BY in NUMBER,
41 X_LAST_UPDATE_LOGIN in NUMBER);
42
43 procedure DELETE_ROW ( X_SEARCH_ID in NUMBER );
44 end CS_SR_SAVED_ADV_CRITERIA_PKG;