1 PACKAGE FUN_RULE_DETAILS_PKG AS
2 /*$Header: FUNXTMRULRDTTBS.pls 120.0 2005/06/20 04:30:04 ammishra noship $ */
3
4 PROCEDURE Insert_Row (
5 X_ROWID IN OUT NOCOPY VARCHAR2,
6 X_RULE_DETAIL_ID IN NUMBER,
7 X_RULE_OBJECT_ID IN NUMBER,
8 X_RULE_NAME IN VARCHAR2,
9 X_SEQ IN NUMBER,
10 X_OPERATOR IN VARCHAR2,
11 X_ENABLED_FLAG IN VARCHAR2,
12 X_RESULT_APPLICATION_ID IN NUMBER,
13 X_RESULT_VALUE IN VARCHAR2,
14 X_CREATED_BY_MODULE IN VARCHAR2
15 );
16
17 PROCEDURE Update_Row (
18 X_RULE_DETAIL_ID IN NUMBER,
19 X_RULE_OBJECT_ID IN NUMBER,
20 X_RULE_NAME IN VARCHAR2,
21 X_SEQ IN NUMBER,
22 X_OPERATOR IN VARCHAR2,
23 X_ENABLED_FLAG IN VARCHAR2,
24 X_RESULT_APPLICATION_ID IN NUMBER,
25 X_RESULT_VALUE IN VARCHAR2,
26 X_CREATED_BY_MODULE IN VARCHAR2
27 );
28
29 PROCEDURE Lock_Row (
30 X_RULE_DETAIL_ID IN NUMBER,
31 X_OBJECT_VERSION_NUMBER IN NUMBER
32 );
33
34 PROCEDURE Select_Row (
35 X_RULE_NAME IN OUT NOCOPY VARCHAR2,
36 X_RULE_DETAIL_ID IN OUT NOCOPY NUMBER,
37 X_RULE_OBJECT_ID IN OUT NOCOPY NUMBER,
38 X_SEQ OUT NOCOPY NUMBER,
39 X_OPERATOR OUT NOCOPY VARCHAR2,
40 X_ENABLED_FLAG OUT NOCOPY VARCHAR2,
41 X_RESULT_APPLICATION_ID OUT NOCOPY NUMBER,
42 X_RESULT_VALUE OUT NOCOPY VARCHAR2,
43 X_CREATED_BY_MODULE OUT NOCOPY VARCHAR2
44 );
45
46 PROCEDURE Delete_Row (
47 X_RULE_DETAIL_ID IN NUMBER
48 );
49
50 END FUN_RULE_DETAILS_PKG;