PACKAGE: APPS.FUN_RULE_CRITERIA_PKG

Source

1 PACKAGE FUN_RULE_CRITERIA_PKG AS
2 /*$Header: FUNXTMRULRCTTBS.pls 120.0 2005/06/20 04:30:01 ammishra noship $ */
3 
4 PROCEDURE Insert_Row (
5     X_ROWID                                 IN OUT NOCOPY VARCHAR2,
6     X_CRITERIA_ID                           IN     NUMBER,
7     X_RULE_DETAIL_ID                        IN     NUMBER,
8     X_CRITERIA_PARAM_ID		            IN     NUMBER,
9     X_CONDITION				    IN     VARCHAR2,
10     X_PARAM_VALUE			    IN     VARCHAR2,
11     X_CASE_SENSITIVE_FLAG		    IN     VARCHAR2,
12     X_CREATED_BY_MODULE                     IN     VARCHAR2
13 );
14 
15 PROCEDURE Update_Row (
16     X_CRITERIA_ID                           IN     NUMBER,
17     X_RULE_DETAIL_ID		            IN     NUMBER,
18     X_CRITERIA_PARAM_ID		            IN     NUMBER,
19     X_CONDITION				    IN     VARCHAR2,
20     X_PARAM_VALUE			    IN     VARCHAR2,
21     X_CASE_SENSITIVE_FLAG		    IN     VARCHAR2,
22     X_CREATED_BY_MODULE                     IN     VARCHAR2
23 );
24 
25 PROCEDURE Lock_Row (
26     X_CRITERIA_ID                           IN     NUMBER,
27     X_OBJECT_VERSION_NUMBER                 IN     NUMBER
28 );
29 
30 PROCEDURE Select_Row (
31     X_CRITERIA_ID         	            IN  OUT NOCOPY   NUMBER,
32     X_RULE_DETAIL_ID			    IN  OUT NOCOPY   NUMBER,
33     X_CRITERIA_PARAM_ID		            OUT NOCOPY     NUMBER,
34     X_CONDITION                             OUT NOCOPY     VARCHAR2,
35     X_PARAM_VALUE			    OUT NOCOPY     VARCHAR2,
36     X_CASE_SENSITIVE_FLAG		    OUT NOCOPY     VARCHAR2,
37     X_CREATED_BY_MODULE                     OUT NOCOPY     VARCHAR2
38 );
39 
40 PROCEDURE Delete_Row (
41     X_CRITERIA_ID                           IN     NUMBER
42 );
43 
44 END FUN_RULE_CRITERIA_PKG;