1 PACKAGE AHL_MC_RULE_ENGINE_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVRUES.pls 115.1 2003/09/26 00:49:39 cxcheng noship $ */
3
4
5 ------------------------
6 -- Declare Procedures --
7 ------------------------
8 -- Start of Comments --
9 -- Procedure name : Check_Rules_For_Unit
10 -- Type : Private
11 -- Function : Checks rule completeness for unit
12 -- Pre-reqs :
13 -- Parameters :
14 --
15 -- Check_Rules_For_Unit Parameters:
16 -- p_unit_header_id IN NUMBER Required.
17 -- p_check_subconfig_flag IN VARCHAR2, T/F whether to check
18 -- subconfig rules
19 -- p_rule_type IN VARCHAR2 Rule Type: MANDATORY or FLEET
20 -- x_evaluation_status OUT VARCHAR2 T/F for the evaluation
21 -- result of all the rules
22 --
23 --
24 -- End of Comments.
25
26 PROCEDURE Check_Rules_For_Unit (
27 p_api_version IN NUMBER,
28 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
29 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
30 x_return_status OUT NOCOPY VARCHAR2,
31 x_msg_count OUT NOCOPY NUMBER,
32 x_msg_data OUT NOCOPY VARCHAR2,
33 p_unit_header_id IN NUMBER,
34 p_rule_type IN VARCHAR2,
35 p_check_subconfig_flag IN VARCHAR2 := FND_API.G_TRUE,
36 x_evaluation_status OUT NOCOPY VARCHAR2);
37
38 ------------------------
39 -- Start of Comments --
40 -- Procedure name : Validate_Rules_For_Unit
41 -- Type : Private
42 -- Function : Validate all rule completeness for unit
43 -- Pre-reqs :
44 -- Parameters :
45 --
46 -- Validate_Rules_For_Unit Parameters:
47 -- p_unit_header_id IN NUMBER Required.
48 -- p_check_subconfig_flag IN VARCHAR2, T/F whether to check
49 -- subconfig rules
50 -- p_rule_type IN VARCHAR2 Rule Type: MANDATORY or FLEET
51 -- x_evaluation_status OUT VARCHAR2 T/F for the evaluation
52 -- result of all the rules
53 -- p_x_error_tbl IN OUT Lists all the error messages for failed rules
54 -- End of Comments.
55
56 PROCEDURE Validate_Rules_For_Unit (
57 p_api_version IN NUMBER,
58 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
59 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
60 x_return_status OUT NOCOPY VARCHAR2,
61 x_msg_count OUT NOCOPY NUMBER,
62 x_msg_data OUT NOCOPY VARCHAR2,
63 p_unit_header_id IN NUMBER,
64 p_rule_type IN VARCHAR2,
65 p_check_subconfig_flag IN VARCHAR2 := FND_API.G_TRUE,
66 p_x_error_tbl IN OUT NOCOPY AHL_UC_VALIDATION_PUB.Error_Tbl_Type,
67 x_evaluation_status OUT NOCOPY VARCHAR2);
68
69 ------------------------
70 -- Start of Comments --
71 -- Procedure name : Validate_Rules_For_Position
72 -- Type : Private
73 -- Function : Validate rules for one position
74 -- Pre-reqs :
75 -- Parameters :
76 --
77 -- Validate_Rules_For_Position Parameters:
78 -- p_item_instance_id IN NUMBER Required.
79 -- p_rule_type IN VARCHAR2 Rule Type: MANDATORY or FLEET
80 -- x_evaluation_status OUT VARCHAR2 T/F for the evaluation
81 -- result of all the rules
82 -- p_x_error_tbl IN OUT Lists all the error messages for failed rules--
83 -- End of Comments.
84
85 PROCEDURE Validate_Rules_For_Position (
86 p_api_version IN NUMBER,
87 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
88 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
89 x_return_status OUT NOCOPY VARCHAR2,
90 x_msg_count OUT NOCOPY NUMBER,
91 x_msg_data OUT NOCOPY VARCHAR2,
92 p_item_instance_id IN NUMBER,
93 p_rule_type IN VARCHAR2,
94 p_x_error_tbl IN OUT NOCOPY AHL_UC_VALIDATION_PUB.Error_Tbl_Type,
95 x_evaluation_status OUT NOCOPY VARCHAR2);
96
97 ------------------------
98 -- Start of Comments --
99 -- Procedure name : Evaluate_Rule
100 -- Type : Private
101 -- Function : Evaluate 1 rule against 1 starting position
102 -- Pre-reqs :
103 -- Parameters :
104 --
105 -- Evaludate_Rule Parameters:
106 -- p_item_instance_id IN NUMBER Required.
107 -- p_rule_id IN NUMBER Required. Rule to eval.
108 -- x_eval_result OUT VARCHAR2 T/F/U depending on rule
109 -- evaluation result.
110 -- End of Comments.
111
112 PROCEDURE Evaluate_Rule (
113 p_api_version IN NUMBER,
114 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
115 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
116 x_return_status OUT NOCOPY VARCHAR2,
117 x_msg_count OUT NOCOPY NUMBER,
118 x_msg_data OUT NOCOPY VARCHAR2,
119 p_item_instance_id IN NUMBER,
120 p_rule_id IN NUMBER,
121 x_eval_result OUT NOCOPY VARCHAR2);
122
123
124 End AHL_MC_RULE_ENGINE_PVT;