1: PACKAGE FUN_RULE_DETAILS_PUB AUTHID CURRENT_USER AS
2: /*$Header: FUNXTMRULRDTPUS.pls 120.3 2006/10/05 04:57:22 havvari noship $ */
3: /*
4: * This package contains the public APIs for set of Rules.
5: * @rep:scope internal
4: * This package contains the public APIs for set of Rules.
5: * @rep:scope internal
6: * @rep:product FUN
7: * @rep:displayname Rules Framework:Set of Rules Defintion
8: * @rep:category BUSINESS_ENTITY FUN_rule_details
9: * @rep:lifecycle active
10: */
11:
12: --------------------------------------
13: -- declaration of record type
14: --------------------------------------
15:
16: TYPE rule_details_rec_type IS RECORD (
17: rule_detail_id FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE,
18: rule_object_id FUN_RULE_DETAILS.RULE_OBJECT_ID%TYPE,
19: rule_name FUN_RULE_DETAILS.RULE_NAME%TYPE,
20: seq FUN_RULE_DETAILS.SEQ%TYPE,
21: operator FUN_RULE_DETAILS.OPERATOR%TYPE,
14: --------------------------------------
15:
16: TYPE rule_details_rec_type IS RECORD (
17: rule_detail_id FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE,
18: rule_object_id FUN_RULE_DETAILS.RULE_OBJECT_ID%TYPE,
19: rule_name FUN_RULE_DETAILS.RULE_NAME%TYPE,
20: seq FUN_RULE_DETAILS.SEQ%TYPE,
21: operator FUN_RULE_DETAILS.OPERATOR%TYPE,
22: enabled_flag FUN_RULE_DETAILS.ENABLED_FLAG%TYPE,
15:
16: TYPE rule_details_rec_type IS RECORD (
17: rule_detail_id FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE,
18: rule_object_id FUN_RULE_DETAILS.RULE_OBJECT_ID%TYPE,
19: rule_name FUN_RULE_DETAILS.RULE_NAME%TYPE,
20: seq FUN_RULE_DETAILS.SEQ%TYPE,
21: operator FUN_RULE_DETAILS.OPERATOR%TYPE,
22: enabled_flag FUN_RULE_DETAILS.ENABLED_FLAG%TYPE,
23: result_application_id FUN_RULE_DETAILS.RESULT_APPLICATION_ID%TYPE,
16: TYPE rule_details_rec_type IS RECORD (
17: rule_detail_id FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE,
18: rule_object_id FUN_RULE_DETAILS.RULE_OBJECT_ID%TYPE,
19: rule_name FUN_RULE_DETAILS.RULE_NAME%TYPE,
20: seq FUN_RULE_DETAILS.SEQ%TYPE,
21: operator FUN_RULE_DETAILS.OPERATOR%TYPE,
22: enabled_flag FUN_RULE_DETAILS.ENABLED_FLAG%TYPE,
23: result_application_id FUN_RULE_DETAILS.RESULT_APPLICATION_ID%TYPE,
24: result_value FUN_RULE_DETAILS.RESULT_VALUE%TYPE,
17: rule_detail_id FUN_RULE_DETAILS.RULE_DETAIL_ID%TYPE,
18: rule_object_id FUN_RULE_DETAILS.RULE_OBJECT_ID%TYPE,
19: rule_name FUN_RULE_DETAILS.RULE_NAME%TYPE,
20: seq FUN_RULE_DETAILS.SEQ%TYPE,
21: operator FUN_RULE_DETAILS.OPERATOR%TYPE,
22: enabled_flag FUN_RULE_DETAILS.ENABLED_FLAG%TYPE,
23: result_application_id FUN_RULE_DETAILS.RESULT_APPLICATION_ID%TYPE,
24: result_value FUN_RULE_DETAILS.RESULT_VALUE%TYPE,
25: creation_date FUN_RULE_DETAILS.CREATION_DATE%TYPE,
18: rule_object_id FUN_RULE_DETAILS.RULE_OBJECT_ID%TYPE,
19: rule_name FUN_RULE_DETAILS.RULE_NAME%TYPE,
20: seq FUN_RULE_DETAILS.SEQ%TYPE,
21: operator FUN_RULE_DETAILS.OPERATOR%TYPE,
22: enabled_flag FUN_RULE_DETAILS.ENABLED_FLAG%TYPE,
23: result_application_id FUN_RULE_DETAILS.RESULT_APPLICATION_ID%TYPE,
24: result_value FUN_RULE_DETAILS.RESULT_VALUE%TYPE,
25: creation_date FUN_RULE_DETAILS.CREATION_DATE%TYPE,
26: created_by FUN_RULE_DETAILS.CREATED_BY%TYPE,
19: rule_name FUN_RULE_DETAILS.RULE_NAME%TYPE,
20: seq FUN_RULE_DETAILS.SEQ%TYPE,
21: operator FUN_RULE_DETAILS.OPERATOR%TYPE,
22: enabled_flag FUN_RULE_DETAILS.ENABLED_FLAG%TYPE,
23: result_application_id FUN_RULE_DETAILS.RESULT_APPLICATION_ID%TYPE,
24: result_value FUN_RULE_DETAILS.RESULT_VALUE%TYPE,
25: creation_date FUN_RULE_DETAILS.CREATION_DATE%TYPE,
26: created_by FUN_RULE_DETAILS.CREATED_BY%TYPE,
27: last_update_date FUN_RULE_DETAILS.LAST_UPDATE_DATE%TYPE,
20: seq FUN_RULE_DETAILS.SEQ%TYPE,
21: operator FUN_RULE_DETAILS.OPERATOR%TYPE,
22: enabled_flag FUN_RULE_DETAILS.ENABLED_FLAG%TYPE,
23: result_application_id FUN_RULE_DETAILS.RESULT_APPLICATION_ID%TYPE,
24: result_value FUN_RULE_DETAILS.RESULT_VALUE%TYPE,
25: creation_date FUN_RULE_DETAILS.CREATION_DATE%TYPE,
26: created_by FUN_RULE_DETAILS.CREATED_BY%TYPE,
27: last_update_date FUN_RULE_DETAILS.LAST_UPDATE_DATE%TYPE,
28: last_updated_by FUN_RULE_DETAILS.LAST_UPDATED_BY%TYPE,
21: operator FUN_RULE_DETAILS.OPERATOR%TYPE,
22: enabled_flag FUN_RULE_DETAILS.ENABLED_FLAG%TYPE,
23: result_application_id FUN_RULE_DETAILS.RESULT_APPLICATION_ID%TYPE,
24: result_value FUN_RULE_DETAILS.RESULT_VALUE%TYPE,
25: creation_date FUN_RULE_DETAILS.CREATION_DATE%TYPE,
26: created_by FUN_RULE_DETAILS.CREATED_BY%TYPE,
27: last_update_date FUN_RULE_DETAILS.LAST_UPDATE_DATE%TYPE,
28: last_updated_by FUN_RULE_DETAILS.LAST_UPDATED_BY%TYPE,
29: last_update_login FUN_RULE_DETAILS.LAST_UPDATE_LOGIN%TYPE,
22: enabled_flag FUN_RULE_DETAILS.ENABLED_FLAG%TYPE,
23: result_application_id FUN_RULE_DETAILS.RESULT_APPLICATION_ID%TYPE,
24: result_value FUN_RULE_DETAILS.RESULT_VALUE%TYPE,
25: creation_date FUN_RULE_DETAILS.CREATION_DATE%TYPE,
26: created_by FUN_RULE_DETAILS.CREATED_BY%TYPE,
27: last_update_date FUN_RULE_DETAILS.LAST_UPDATE_DATE%TYPE,
28: last_updated_by FUN_RULE_DETAILS.LAST_UPDATED_BY%TYPE,
29: last_update_login FUN_RULE_DETAILS.LAST_UPDATE_LOGIN%TYPE,
30: created_by_module FUN_RULE_DETAILS.CREATED_BY_MODULE%TYPE
23: result_application_id FUN_RULE_DETAILS.RESULT_APPLICATION_ID%TYPE,
24: result_value FUN_RULE_DETAILS.RESULT_VALUE%TYPE,
25: creation_date FUN_RULE_DETAILS.CREATION_DATE%TYPE,
26: created_by FUN_RULE_DETAILS.CREATED_BY%TYPE,
27: last_update_date FUN_RULE_DETAILS.LAST_UPDATE_DATE%TYPE,
28: last_updated_by FUN_RULE_DETAILS.LAST_UPDATED_BY%TYPE,
29: last_update_login FUN_RULE_DETAILS.LAST_UPDATE_LOGIN%TYPE,
30: created_by_module FUN_RULE_DETAILS.CREATED_BY_MODULE%TYPE
31: );
24: result_value FUN_RULE_DETAILS.RESULT_VALUE%TYPE,
25: creation_date FUN_RULE_DETAILS.CREATION_DATE%TYPE,
26: created_by FUN_RULE_DETAILS.CREATED_BY%TYPE,
27: last_update_date FUN_RULE_DETAILS.LAST_UPDATE_DATE%TYPE,
28: last_updated_by FUN_RULE_DETAILS.LAST_UPDATED_BY%TYPE,
29: last_update_login FUN_RULE_DETAILS.LAST_UPDATE_LOGIN%TYPE,
30: created_by_module FUN_RULE_DETAILS.CREATED_BY_MODULE%TYPE
31: );
32:
25: creation_date FUN_RULE_DETAILS.CREATION_DATE%TYPE,
26: created_by FUN_RULE_DETAILS.CREATED_BY%TYPE,
27: last_update_date FUN_RULE_DETAILS.LAST_UPDATE_DATE%TYPE,
28: last_updated_by FUN_RULE_DETAILS.LAST_UPDATED_BY%TYPE,
29: last_update_login FUN_RULE_DETAILS.LAST_UPDATE_LOGIN%TYPE,
30: created_by_module FUN_RULE_DETAILS.CREATED_BY_MODULE%TYPE
31: );
32:
33:
26: created_by FUN_RULE_DETAILS.CREATED_BY%TYPE,
27: last_update_date FUN_RULE_DETAILS.LAST_UPDATE_DATE%TYPE,
28: last_updated_by FUN_RULE_DETAILS.LAST_UPDATED_BY%TYPE,
29: last_update_login FUN_RULE_DETAILS.LAST_UPDATE_LOGIN%TYPE,
30: created_by_module FUN_RULE_DETAILS.CREATED_BY_MODULE%TYPE
31: );
32:
33:
34: --------------------------------------
36: --------------------------------------
37:
38: /**
39: * Use this routine to create a rule and its related information.
40: * With this API you can create a record in the FUN_RULE_DETAILS table.
41: * @rep:scope internal
42: * @rep:lifecycle active
43: * @rep:displayname Create Rule
44: * @rep:businessevent oracle.apps.fun.rules.server.HACustomizableObjectEO.create
63: );
64:
65: /**
66: * Use this routine to update a user defined rule. The API updates records in the
67: * FUN_RULE_DETAILS table.
68: * @rep:scope internal
69: * @rep:lifecycle active
70: * @rep:displayname Update User Defined Rule
71: * @rep:businessevent
118: );
119:
120: /**
121: * Use this routine to delete a rule. The API deletes records in the
122: * FUN_RULE_DETAILS table.
123: *
124: * @rep:scope internal
125: * @rep:lifecycle active
126: * @rep:displayname Delete Rule.
144: x_msg_data OUT NOCOPY VARCHAR2
145: );
146:
147:
148: END FUN_RULE_DETAILS_PUB;