1 PACKAGE EGO_RULES_UTIL_PUB AUTHID CURRENT_USER AS
2 /* $Header: EGORUTLS.pls 120.0.12010000.1 2009/08/13 19:05:31 chulhale noship $ */
3
4 -- Start of comments
5 -- API name : Get_Run_Rule_Result
6 -- Type : Public
7 -- Pre-reqs : None.
8 -- Function : Customized Get_Run_Rule_Result procudure based on information
9 -- related to user, entity, and object etc.
10 -- Parameters :
11 -- IN : p_rule_id IN VARCHAR2(150)
12 -- p_entity_type_name IN VARCHAR2(150)
13 -- p_data_level_name IN VARCHAR2(150)
14 -- p_entity_key_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
15 -- p_additional_key_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
16 -- OUT : x_rule_result OUT VARCHAR2 = 'T' if Rule_Result is TRUE
17 -- 'F' if Rule_Result is FALSE
18 -- 'U' Defalut and if there are unexpected errors
19 -- Oracle API Standard Parameters :
20 -- IN : p_api_version IN NUMBER Required
21 -- p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
22 -- Optional
23 -- p_commit IN VARCHAR2 default FND_API.G_FALSE
24 -- Optional
25 -- p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
26 -- Optional
27 -- OUT : x_return_status OUT VARCHAR2(1)
28 -- x_msg_count OUT NUMBER
29 -- x_msg_data OUT VARCHAR2(2000)
30 --
31 -- Version : Current version 1.0
32 -- Previous version N/A
33 -- Initial version 1.0
34 --
35 -- End of comments
36
37 PROCEDURE Get_Run_Rule_Result
38 (
39 --program parameters
40 p_rule_id IN VARCHAR2
41 ,p_entity_type_name IN VARCHAR2
42 ,p_data_level_name IN VARCHAR2
43 ,p_entity_key_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY default NULL
44 ,p_additional_key_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY default NULL
45 ,x_rule_result OUT NOCOPY VARCHAR2
46
47 --standard parameters
48 ,p_api_version IN NUMBER default 1.0
49 ,p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
50 ,p_commit IN VARCHAR2 default FND_API.G_FALSE
51 ,p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
52 ,x_return_status OUT NOCOPY VARCHAR2
53 ,x_msg_count OUT NOCOPY NUMBER
54 ,x_msg_data OUT NOCOPY VARCHAR2
55 );
56
57 END EGO_RULES_UTIL_PUB;