DBA Data[Home] [Help]

APPS.FUN_RULE_CRITERIA_PUB dependencies on FUN_RULE_CRITERIA

Line 1: PACKAGE FUN_RULE_CRITERIA_PUB AUTHID CURRENT_USER AS

1: PACKAGE FUN_RULE_CRITERIA_PUB AUTHID CURRENT_USER AS
2: /*$Header: FUNXTMRULRCTPUS.pls 120.1 2005/06/22 05:01:02 ammishra noship $ */
3: /*#
4: * This package contains the public APIs for Rules Criteria.
5: * @rep:scope internal

Line 8: * @rep:category BUSINESS_ENTITY FUN_RULE_CRITERIA

4: * This package contains the public APIs for Rules Criteria.
5: * @rep:scope internal
6: * @rep:product FUN
7: * @rep:displayname Rules Framework:Rules Criteria Definition
8: * @rep:category BUSINESS_ENTITY FUN_RULE_CRITERIA
9: * @rep:lifecycle active
10: */
11:
12: --------------------------------------

Line 17: criteria_id FUN_RULE_CRITERIA.CRITERIA_ID%TYPE,

13: -- declaration of record type
14: --------------------------------------
15:
16: TYPE rule_criteria_rec_type IS RECORD (
17: criteria_id FUN_RULE_CRITERIA.CRITERIA_ID%TYPE,
18: rule_detail_id FUN_RULE_CRITERIA.RULE_DETAIL_ID%TYPE,
19: criteria_param_id FUN_RULE_CRITERIA.CRITERIA_PARAM_ID%TYPE,
20: condition FUN_RULE_CRITERIA.CONDITION%TYPE,
21: param_value FUN_RULE_CRITERIA.PARAM_VALUE%TYPE,

Line 18: rule_detail_id FUN_RULE_CRITERIA.RULE_DETAIL_ID%TYPE,

14: --------------------------------------
15:
16: TYPE rule_criteria_rec_type IS RECORD (
17: criteria_id FUN_RULE_CRITERIA.CRITERIA_ID%TYPE,
18: rule_detail_id FUN_RULE_CRITERIA.RULE_DETAIL_ID%TYPE,
19: criteria_param_id FUN_RULE_CRITERIA.CRITERIA_PARAM_ID%TYPE,
20: condition FUN_RULE_CRITERIA.CONDITION%TYPE,
21: param_value FUN_RULE_CRITERIA.PARAM_VALUE%TYPE,
22: case_sensitive_flag FUN_RULE_CRITERIA.CASE_SENSITIVE_FLAG%TYPE,

Line 19: criteria_param_id FUN_RULE_CRITERIA.CRITERIA_PARAM_ID%TYPE,

15:
16: TYPE rule_criteria_rec_type IS RECORD (
17: criteria_id FUN_RULE_CRITERIA.CRITERIA_ID%TYPE,
18: rule_detail_id FUN_RULE_CRITERIA.RULE_DETAIL_ID%TYPE,
19: criteria_param_id FUN_RULE_CRITERIA.CRITERIA_PARAM_ID%TYPE,
20: condition FUN_RULE_CRITERIA.CONDITION%TYPE,
21: param_value FUN_RULE_CRITERIA.PARAM_VALUE%TYPE,
22: case_sensitive_flag FUN_RULE_CRITERIA.CASE_SENSITIVE_FLAG%TYPE,
23: creation_date FUN_RULE_CRITERIA.CREATION_DATE%TYPE,

Line 20: condition FUN_RULE_CRITERIA.CONDITION%TYPE,

16: TYPE rule_criteria_rec_type IS RECORD (
17: criteria_id FUN_RULE_CRITERIA.CRITERIA_ID%TYPE,
18: rule_detail_id FUN_RULE_CRITERIA.RULE_DETAIL_ID%TYPE,
19: criteria_param_id FUN_RULE_CRITERIA.CRITERIA_PARAM_ID%TYPE,
20: condition FUN_RULE_CRITERIA.CONDITION%TYPE,
21: param_value FUN_RULE_CRITERIA.PARAM_VALUE%TYPE,
22: case_sensitive_flag FUN_RULE_CRITERIA.CASE_SENSITIVE_FLAG%TYPE,
23: creation_date FUN_RULE_CRITERIA.CREATION_DATE%TYPE,
24: created_by FUN_RULE_CRITERIA.CREATED_BY%TYPE,

Line 21: param_value FUN_RULE_CRITERIA.PARAM_VALUE%TYPE,

17: criteria_id FUN_RULE_CRITERIA.CRITERIA_ID%TYPE,
18: rule_detail_id FUN_RULE_CRITERIA.RULE_DETAIL_ID%TYPE,
19: criteria_param_id FUN_RULE_CRITERIA.CRITERIA_PARAM_ID%TYPE,
20: condition FUN_RULE_CRITERIA.CONDITION%TYPE,
21: param_value FUN_RULE_CRITERIA.PARAM_VALUE%TYPE,
22: case_sensitive_flag FUN_RULE_CRITERIA.CASE_SENSITIVE_FLAG%TYPE,
23: creation_date FUN_RULE_CRITERIA.CREATION_DATE%TYPE,
24: created_by FUN_RULE_CRITERIA.CREATED_BY%TYPE,
25: last_update_date FUN_RULE_CRITERIA.LAST_UPDATE_DATE%TYPE,

Line 22: case_sensitive_flag FUN_RULE_CRITERIA.CASE_SENSITIVE_FLAG%TYPE,

18: rule_detail_id FUN_RULE_CRITERIA.RULE_DETAIL_ID%TYPE,
19: criteria_param_id FUN_RULE_CRITERIA.CRITERIA_PARAM_ID%TYPE,
20: condition FUN_RULE_CRITERIA.CONDITION%TYPE,
21: param_value FUN_RULE_CRITERIA.PARAM_VALUE%TYPE,
22: case_sensitive_flag FUN_RULE_CRITERIA.CASE_SENSITIVE_FLAG%TYPE,
23: creation_date FUN_RULE_CRITERIA.CREATION_DATE%TYPE,
24: created_by FUN_RULE_CRITERIA.CREATED_BY%TYPE,
25: last_update_date FUN_RULE_CRITERIA.LAST_UPDATE_DATE%TYPE,
26: last_updated_by FUN_RULE_CRITERIA.LAST_UPDATED_BY%TYPE,

Line 23: creation_date FUN_RULE_CRITERIA.CREATION_DATE%TYPE,

19: criteria_param_id FUN_RULE_CRITERIA.CRITERIA_PARAM_ID%TYPE,
20: condition FUN_RULE_CRITERIA.CONDITION%TYPE,
21: param_value FUN_RULE_CRITERIA.PARAM_VALUE%TYPE,
22: case_sensitive_flag FUN_RULE_CRITERIA.CASE_SENSITIVE_FLAG%TYPE,
23: creation_date FUN_RULE_CRITERIA.CREATION_DATE%TYPE,
24: created_by FUN_RULE_CRITERIA.CREATED_BY%TYPE,
25: last_update_date FUN_RULE_CRITERIA.LAST_UPDATE_DATE%TYPE,
26: last_updated_by FUN_RULE_CRITERIA.LAST_UPDATED_BY%TYPE,
27: last_update_login FUN_RULE_CRITERIA.LAST_UPDATE_LOGIN%TYPE,

Line 24: created_by FUN_RULE_CRITERIA.CREATED_BY%TYPE,

20: condition FUN_RULE_CRITERIA.CONDITION%TYPE,
21: param_value FUN_RULE_CRITERIA.PARAM_VALUE%TYPE,
22: case_sensitive_flag FUN_RULE_CRITERIA.CASE_SENSITIVE_FLAG%TYPE,
23: creation_date FUN_RULE_CRITERIA.CREATION_DATE%TYPE,
24: created_by FUN_RULE_CRITERIA.CREATED_BY%TYPE,
25: last_update_date FUN_RULE_CRITERIA.LAST_UPDATE_DATE%TYPE,
26: last_updated_by FUN_RULE_CRITERIA.LAST_UPDATED_BY%TYPE,
27: last_update_login FUN_RULE_CRITERIA.LAST_UPDATE_LOGIN%TYPE,
28: created_by_module FUN_RULE_CRITERIA.CREATED_BY_MODULE%TYPE

Line 25: last_update_date FUN_RULE_CRITERIA.LAST_UPDATE_DATE%TYPE,

21: param_value FUN_RULE_CRITERIA.PARAM_VALUE%TYPE,
22: case_sensitive_flag FUN_RULE_CRITERIA.CASE_SENSITIVE_FLAG%TYPE,
23: creation_date FUN_RULE_CRITERIA.CREATION_DATE%TYPE,
24: created_by FUN_RULE_CRITERIA.CREATED_BY%TYPE,
25: last_update_date FUN_RULE_CRITERIA.LAST_UPDATE_DATE%TYPE,
26: last_updated_by FUN_RULE_CRITERIA.LAST_UPDATED_BY%TYPE,
27: last_update_login FUN_RULE_CRITERIA.LAST_UPDATE_LOGIN%TYPE,
28: created_by_module FUN_RULE_CRITERIA.CREATED_BY_MODULE%TYPE
29: );

Line 26: last_updated_by FUN_RULE_CRITERIA.LAST_UPDATED_BY%TYPE,

22: case_sensitive_flag FUN_RULE_CRITERIA.CASE_SENSITIVE_FLAG%TYPE,
23: creation_date FUN_RULE_CRITERIA.CREATION_DATE%TYPE,
24: created_by FUN_RULE_CRITERIA.CREATED_BY%TYPE,
25: last_update_date FUN_RULE_CRITERIA.LAST_UPDATE_DATE%TYPE,
26: last_updated_by FUN_RULE_CRITERIA.LAST_UPDATED_BY%TYPE,
27: last_update_login FUN_RULE_CRITERIA.LAST_UPDATE_LOGIN%TYPE,
28: created_by_module FUN_RULE_CRITERIA.CREATED_BY_MODULE%TYPE
29: );
30:

Line 27: last_update_login FUN_RULE_CRITERIA.LAST_UPDATE_LOGIN%TYPE,

23: creation_date FUN_RULE_CRITERIA.CREATION_DATE%TYPE,
24: created_by FUN_RULE_CRITERIA.CREATED_BY%TYPE,
25: last_update_date FUN_RULE_CRITERIA.LAST_UPDATE_DATE%TYPE,
26: last_updated_by FUN_RULE_CRITERIA.LAST_UPDATED_BY%TYPE,
27: last_update_login FUN_RULE_CRITERIA.LAST_UPDATE_LOGIN%TYPE,
28: created_by_module FUN_RULE_CRITERIA.CREATED_BY_MODULE%TYPE
29: );
30:
31:

Line 28: created_by_module FUN_RULE_CRITERIA.CREATED_BY_MODULE%TYPE

24: created_by FUN_RULE_CRITERIA.CREATED_BY%TYPE,
25: last_update_date FUN_RULE_CRITERIA.LAST_UPDATE_DATE%TYPE,
26: last_updated_by FUN_RULE_CRITERIA.LAST_UPDATED_BY%TYPE,
27: last_update_login FUN_RULE_CRITERIA.LAST_UPDATE_LOGIN%TYPE,
28: created_by_module FUN_RULE_CRITERIA.CREATED_BY_MODULE%TYPE
29: );
30:
31:
32: --------------------------------------

Line 68: * With this API you can create a record in the FUN_RULE_CRITERIA table.

64: */
65:
66: /**
67: * Use this routine to create a rule criteria and its related information.
68: * With this API you can create a record in the FUN_RULE_CRITERIA table.
69: * By defining a criteria for rule end users can define their individual
70: * criteria parametere object name, condition, param value, case sensitive
71: * checking allowed or not etc.
72: * @rep:scope internal

Line 100: * FUN_RULE_CRITERIA table.

96:
97:
98: /**
99: * Use this routine to update a Rule Criteria. The API updates records in the
100: * FUN_RULE_CRITERIA table.
101: * @rep:scope internal
102: * @rep:lifecycle active
103: * @rep:displayname Update Rule Criteria
104: * @rep:businessevent

Line 127: * FUN_RULE_CRITERIA table.

123:
124:
125: /**
126: * Use this routine to Get a Rule Criteria Record. The API selects record from the
127: * FUN_RULE_CRITERIA table.
128: *
129: * @rep:scope internal
130: * @rep:lifecycle active
131: * @rep:displayname Retrieve Rule Criteria Record

Line 157: * FUN_RULE_CRITERIA table.

153: );
154:
155: /**
156: * Use this routine to delete a Rule Criteria. The API deletes records in the
157: * FUN_RULE_CRITERIA table.
158: *
159: * @rep:scope internal
160: * @rep:lifecycle active
161: * @rep:displayname Delete Rule Criteria

Line 180: END FUN_RULE_CRITERIA_PUB;

176: x_msg_count OUT NOCOPY NUMBER,
177: x_msg_data OUT NOCOPY VARCHAR2
178: );
179:
180: END FUN_RULE_CRITERIA_PUB;