1 PACKAGE CS_SR_TSK_TMPL_SEQ_RULES_PKG AUTHID CURRENT_USER AS
2 /* $Header: cstskrls.pls 120.0 2006/03/07 18:39:38 jngeorge noship $ */
3
4 procedure INSERT_ROW (
5 X_ROWID in out NOCOPY VARCHAR2,
6 P_SEARCH_RULE_ID in NUMBER,
7 P_ACTIVE_FLAG in VARCHAR2,
8 P_OBJECT_VERSION_NUMBER in NUMBER,
9 P_SECURITY_GROUP_ID in NUMBER,
10 P_SEARCH_RULE_CODE in VARCHAR2,
11 P_SEARCH_SEQUENCE in NUMBER,
12 P_CREATION_DATE in DATE,
13 P_CREATED_BY in NUMBER,
14 P_LAST_UPDATE_DATE in DATE,
15 P_LAST_UPDATED_BY in NUMBER,
16 P_LAST_UPDATE_LOGIN in NUMBER
17 );
18
19 procedure LOCK_ROW (
20 P_SEARCH_RULE_ID in NUMBER,
21 P_ACTIVE_FLAG in VARCHAR2,
22 P_OBJECT_VERSION_NUMBER in NUMBER,
23 P_SECURITY_GROUP_ID in NUMBER,
24 P_SEARCH_RULE_CODE in VARCHAR2,
25 P_SEARCH_SEQUENCE in NUMBER
26 );
27
28 procedure UPDATE_ROW (
29 P_SEARCH_RULE_ID in NUMBER,
30 P_ACTIVE_FLAG in VARCHAR2,
31 P_OBJECT_VERSION_NUMBER in NUMBER,
32 P_SECURITY_GROUP_ID in NUMBER,
33 P_SEARCH_RULE_CODE in VARCHAR2,
34 P_SEARCH_SEQUENCE in NUMBER,
35 P_LAST_UPDATE_DATE in DATE,
36 P_LAST_UPDATED_BY in NUMBER,
37 P_LAST_UPDATE_LOGIN in NUMBER
38 );
39
40 procedure DELETE_ROW (
41 P_SEARCH_RULE_ID in NUMBER);
42
43 procedure LOAD_ROW (
44 X_ROWID IN out NOCOPY VARCHAR2,
45 P_SEARCH_RULE_ID IN NUMBER,
46 P_ACTIVE_FLAG IN VARCHAR2,
47 P_OBJECT_VERSION_NUMBER IN NUMBER,
48 P_SECURITY_GROUP_ID IN NUMBER,
49 P_SEARCH_RULE_CODE IN VARCHAR2,
50 P_SEARCH_SEQUENCE IN NUMBER,
51 P_CREATION_DATE IN DATE,
52 P_CREATED_BY IN NUMBER,
53 P_LAST_UPDATE_DATE IN DATE,
54 P_LAST_UPDATED_BY IN NUMBER,
55 P_LAST_UPDATE_LOGIN IN NUMBER,
56 P_OWNER IN VARCHAR2
57 ) ;
58
59 END CS_SR_TSK_TMPL_SEQ_RULES_PKG;