DBA Data[Home] [Help]

PACKAGE: APPS.CS_SR_TSK_TMPL_SEQ_RULES_PKG

Source


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;