1 PACKAGE CN_RuleAttribute_PUB AUTHID CURRENT_USER AS
2 --$Header: cnpratrs.pls 120.1 2005/08/25 23:38:05 rramakri noship $
3
4 TYPE RuleAttribute_rec_type IS RECORD
5 (ruleset_name cn_rulesets.name%TYPE,
6 start_date cn_rulesets.start_date%TYPE,
7 end_date cn_rulesets.end_date%TYPE,
8 rule_name cn_rules.name%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 org_id cn_rules.org_id%TYPE
15 );
16
17 -- Start of comments
18 -- API name : Create_RuleAttribute
19 -- Type : Public
20 -- Function : This Public API can be used to create a rule attribute
21 -- Pre-reqs : None.
22 -- Parameters :
23 -- IN : p_api_version IN NUMBER Required
24 -- p_init_msg_list IN VARCHAR2 Optional
25 -- Default = FND_API.G_FALSE
26 -- p_commit IN VARCHAR2 Optional
27 -- Default = FND_API.G_FALSE
28 -- p_validation_level IN NUMBER Optional
29 -- Default = FND_API.G_VALID_LEVEL_FULL
30 -- p_RuleAttribute_rec IN
31 -- CN_RuleAttribute_PUB.RuleAttribute_rec_type
32 --
33 -- OUT : x_return_status OUT VARCHAR2(1)
34 -- x_msg_count OUT NUMBER
35 -- x_msg_data OUT VARCHAR2(2000)
36 --
37 -- Version : Current version 1.0
38 -- 25-Mar-99 Renu Chintalapati
39 -- previous version y.y
40 -- Changed....
41 -- Initial version 1.0
42 -- 25-Mar-99 Renu Chintalapati
43 --
44 -- Notes : Note text
45 --
46 -- End of comments
47
48 PROCEDURE Create_RuleAttribute
49 ( p_api_version IN NUMBER,
50 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
51 p_commit IN VARCHAR2 := FND_API.G_FALSE,
52 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
53 x_return_status OUT NOCOPY VARCHAR2,
54 x_msg_count OUT NOCOPY NUMBER,
55 x_msg_data OUT NOCOPY VARCHAR2,
56 x_loading_status OUT NOCOPY VARCHAR2,
57 p_RuleAttribute_rec IN CN_RuleAttribute_PUB.RuleAttribute_rec_type
58 );
59
60 -- Start of comments
61 -- API name : Update_RuleAttribute
62 -- Type : Public
63 -- Function : This public API can be used to update a rule attribute
64 -- Pre-reqs : None.
65 -- Parameters :
66 -- IN : p_api_version IN NUMBER Required
67 -- p_init_msg_list IN VARCHAR2 Optional
68 -- Default = FND_API.G_FALSE
69 -- p_commit IN VARCHAR2 Optional
70 -- Default = FND_API.G_FALSE
71 -- p_validation_level IN NUMBER Optional
72 -- Default = FND_API.G_VALID_LEVEL_FULL
73 -- p_RuleAttribute_rec IN
74 -- CN_RuleAttribute_PUB.RuleAttribute_rec_type
75 --
76 -- OUT : x_return_status OUT VARCHAR2(1)
77 -- x_msg_count OUT NUMBER
78 -- x_msg_data OUT VARCHAR2(2000)
79 --
80 -- Version : Current version 1.0
81 -- 25-Mar-99 Renu Chintalapati
82 -- previous version y.y
83 -- Changed....
84 -- Initial version 1.0
85 -- 25-Mar-99 Renu Chintalapati
86 --
87 -- Notes : Note text
88 --
89 -- End of comments
90
91
92 PROCEDURE Update_RuleAttribute
93 ( p_api_version IN NUMBER,
94 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
95 p_commit IN VARCHAR2 := FND_API.G_FALSE,
96 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
97 x_return_status OUT NOCOPY VARCHAR2,
98 x_msg_count OUT NOCOPY NUMBER,
99 x_msg_data OUT NOCOPY VARCHAR2,
100 x_loading_status OUT NOCOPY VARCHAR2,
101 p_old_RuleAttribute_rec IN CN_RuleAttribute_PUB.RuleAttribute_rec_type,
102 p_RuleAttribute_rec IN CN_RuleAttribute_PUB.RuleAttribute_rec_type
103 );
104
105 -- Start of comments
106 -- API name : Delete_RuleAttribute
107 -- Type : Public
108 -- Function : This Public API can be used to delete a rule attribute
109 -- Pre-reqs : None.
110 -- Parameters :
111 -- IN : p_api_version IN NUMBER Required
112 -- p_init_msg_list IN VARCHAR2 Optional
113 -- Default = FND_API.G_FALSE
114 -- p_commit IN VARCHAR2 Optional
115 -- Default = FND_API.G_FALSE
116 -- p_validation_level IN NUMBER Optional
117 -- Default = FND_API.G_VALID_LEVEL_FULL
118 -- p_attribute_rule_id IN
119 -- cn_attribute_rule.attribute_rule_id%type
120 --
121 -- OUT : x_return_status OUT VARCHAR2(1)
122 -- x_msg_count OUT NUMBER
123 -- x_msg_data OUT VARCHAR2(2000)
124 --
125 -- Version : Current version 1.0
126 -- 25-Mar-99 Renu Chintalapati
127 -- previous version y.y
128 -- Changed....
129 -- Initial version 1.0
130 -- 25-Mar-99 Renu Chintalapati
131 --
132 -- Notes : Note text
133 --
134 -- End of comments
135
136 PROCEDURE Delete_RuleAttribute
137 ( p_api_version IN NUMBER,
138 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
139 p_commit IN VARCHAR2 := FND_API.G_FALSE,
140 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
141 x_return_status OUT NOCOPY VARCHAR2,
142 x_msg_count OUT NOCOPY NUMBER,
143 x_msg_data OUT NOCOPY VARCHAR2,
144 x_loading_status OUT NOCOPY VARCHAR2,
145 p_ruleattribute_rec IN CN_RuleAttribute_PUB.ruleattribute_rec_type);
146
147 END CN_RuleAttribute_PUB;