[Home] [Help]
PACKAGE: APPS.CN_RULEATTRIBUTE_PVT
Source
1 PACKAGE CN_RuleAttribute_PVT AUTHID CURRENT_USER AS
2 --$Header: cnvratrs.pls 120.2 2005/07/04 05:24:30 appldev ship $
3
4 TYPE RuleAttribute_rec_type IS RECORD
5 (ruleset_id cn_attribute_rules.ruleset_id%TYPE,
6 rule_id cn_attribute_rules.rule_id%TYPE,
7 attribute_rule_id cn_attribute_rules.attribute_rule_id%TYPE,
8 org_id cn_attribute_rules.org_id%TYPE,
9 object_name cn_objects.name%TYPE,
10 not_flag cn_attribute_rules.not_flag%TYPE,
11 value_1 cn_attribute_rules.column_value%TYPE,
12 value_2 cn_attribute_rules.high_value%TYPE,
13 data_flag varchar2(1),
14 object_version_number cn_attribute_rules.object_version_number%TYPE);
15
16 -- Start of comments
17 -- API name : Create_RuleAttribute
18 -- Type : Private
19 -- Function : This Public API can be used to create a rule attribute
20 -- Pre-reqs : None.
21 -- Parameters :
22 -- IN : p_api_version IN NUMBER Required
23 -- p_init_msg_list IN VARCHAR2 Optional
24 -- Default = FND_API.G_FALSE
25 -- p_commit IN VARCHAR2 Optional
26 -- Default = FND_API.G_FALSE
27 -- p_validation_level IN NUMBER Optional
28 -- Default = FND_API.G_VALID_LEVEL_FULL
29 -- p_RuleAttribute_rec IN
30 -- CN_RuleAttribute_PVT.RuleAttribute_rec_type
31 --
32 -- OUT : x_return_status OUT VARCHAR2(1)
33 -- x_msg_count OUT NUMBER
34 -- x_msg_data OUT VARCHAR2(2000)
35 --
36 -- Version : Current version 1.0
37 -- 25-Mar-99 Renu Chintalapati
38 -- previous version y.y
39 -- Changed....
40 -- Initial version 1.0
41 -- 25-Mar-99 Renu Chintalapati
42 --
43 -- Notes : Note text
44 --
45 -- End of comments
46
47 PROCEDURE Create_RuleAttribute
48 ( p_api_version IN NUMBER,
49 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
50 p_commit IN VARCHAR2 := FND_API.G_FALSE,
51 p_validation_level IN NUMBER := 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 x_loading_status OUT NOCOPY VARCHAR2,
56 p_RuleAttribute_rec IN OUT NOCOPY CN_RuleAttribute_PVT.RuleAttribute_rec_type
57 );
58
59 -- Start of comments
60 -- API name : Update_RuleAttribute
61 -- Type : Private
62 -- Function : This private API can be used to update a rule attribute
63 -- Pre-reqs : None.
64 -- Parameters :
65 -- IN : p_api_version IN NUMBER Required
66 -- p_init_msg_list IN VARCHAR2 Optional
67 -- Default = FND_API.G_FALSE
68 -- p_commit IN VARCHAR2 Optional
69 -- Default = FND_API.G_FALSE
70 -- p_validation_level IN NUMBER Optional
71 -- Default = FND_API.G_VALID_LEVEL_FULL
72 -- p_RuleAttribute_rec IN
73 -- CN_RuleAttribute_PVT.RuleAttribute_rec_type
74 --
75 -- OUT : x_return_status OUT VARCHAR2(1)
76 -- x_msg_count OUT NUMBER
77 -- x_msg_data OUT VARCHAR2(2000)
78 --
79 -- Version : Current version 1.0
80 -- 25-Mar-99 Renu Chintalapati
81 -- previous version y.y
82 -- Changed....
83 -- Initial version 1.0
84 -- 25-Mar-99 Renu Chintalapati
85 --
86 -- Notes : Note text
87 --
88 -- End of comments
89
90 FUNCTION get_valuset_query (l_valueset_id NUMBER) RETURN VARCHAR2;
91
92 FUNCTION get_operator(l_attribute_rule_id NUMBER,l_org_id NUMBER) return varchar2;
93
94 FUNCTION get_rendered(l_attribute_rule_id NUMBER,l_org_id NUMBER) return number;
95
96
97
98 PROCEDURE Update_RuleAttribute
99 ( p_api_version IN NUMBER,
100 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101 p_commit IN VARCHAR2 := FND_API.G_FALSE,
102 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
103 x_return_status OUT NOCOPY VARCHAR2,
104 x_msg_count OUT NOCOPY NUMBER,
105 x_msg_data OUT NOCOPY VARCHAR2,
106 x_loading_status OUT NOCOPY VARCHAR2,
107 p_old_RuleAttribute_rec IN OUT NOCOPY CN_RuleAttribute_PVT.RuleAttribute_rec_type,
108 p_RuleAttribute_rec IN OUT NOCOPY CN_RuleAttribute_PVT.RuleAttribute_rec_type
109 );
110
111 -- Start of comments
112 -- API name : Delete_RuleAttribute
113 -- Type : Private
114 -- Function : This Private API can be used to delete a rule attribute
115 -- Pre-reqs : None.
116 -- Parameters :
117 -- IN : p_api_version IN NUMBER Required
118 -- p_init_msg_list IN VARCHAR2 Optional
119 -- Default = FND_API.G_FALSE
120 -- p_commit IN VARCHAR2 Optional
121 -- Default = FND_API.G_FALSE
122 -- p_validation_level IN NUMBER Optional
123 -- Default = FND_API.G_VALID_LEVEL_FULL
124 -- p_attribute_rule_id IN
125 -- cn_attribute_rule.attribute_rule_id%type
126 --
127 -- OUT : x_return_status OUT VARCHAR2(1)
128 -- x_msg_count OUT NUMBER
129 -- x_msg_data OUT VARCHAR2(2000)
130 --
131 -- Version : Current version 1.0
132 -- 25-Mar-99 Renu Chintalapati
133 -- previous version y.y
134 -- Changed....
135 -- Initial version 1.0
136 -- 25-Mar-99 Renu Chintalapati
137 --
138 -- Notes : Note text
139 --
140 -- End of comments
141
142 PROCEDURE Delete_RuleAttribute
143 ( p_api_version IN NUMBER,
144 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145 p_commit IN VARCHAR2 := FND_API.G_FALSE,
146 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
147 x_return_status OUT NOCOPY VARCHAR2,
148 x_msg_count OUT NOCOPY NUMBER,
149 x_msg_data OUT NOCOPY VARCHAR2,
150 x_loading_status OUT NOCOPY VARCHAR2,
151 p_ruleset_id IN cn_attribute_rules.ruleset_id%TYPE,
152 p_rule_id IN cn_attribute_rules.rule_id%TYPE,
153 p_attribute_rule_id IN cn_attribute_rules.attribute_rule_id%TYPE,
154 p_object_version_number IN cn_attribute_rules.object_version_number%TYPE
155 );
156
157 PROCEDURE Check_Attr_types
158 (p_value_1 IN VARCHAR2 := NULL,
159 p_value_2 IN VARCHAR2 := NULL,
160 p_column_id IN NUMBER,
161 p_rule_id IN NUMBER := NULL,
162 p_ruleset_id IN NUMBER := NULL,
163 p_org_id IN NUMBER,
164 p_data_flag IN VARCHAR2,
165 p_loading_status IN VARCHAR2,
166 x_loading_status OUT NOCOPY VARCHAR2) ;
167
168
169 --=======================================================================
170 -- Procedure Name: Get_attr_valueset
171 -- Purpose
172 --=======================================================================
173 PROCEDURE get_attr_valueset
174 (p_column_id IN NUMBER,
175 p_column_name IN VARCHAR2,
176 p_org_id IN NUMBER,
177 x_select OUT NOCOPY VARCHAR2,
178 x_from OUT NOCOPY VARCHAR2,
179 x_where OUT NOCOPY VARCHAR2) ;
180
181
182 END CN_RuleAttribute_PVT;