1 PACKAGE AMS_Ct_Rule_PUB AS
2 /* $Header: amspctrs.pls 120.1 2006/02/22 02:25:51 anchaudh noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_Ct_Rule_PUB
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15
16 -- Default number of records fetch per call
17 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
18 --===================================================================
19 -- Start of Comments
20 -- -------------------------------------------------------
21 -- Record name
22 -- ct_rule_rec_type
23 -- -------------------------------------------------------
24 -- Parameters:
25 -- content_rule_id
26 -- created_by
27 -- creation_date
28 -- last_updated_by
29 -- last_updated_date
30 -- last_update_login
31 -- object_version_number
32 -- object_type
33 -- object_id
34 -- sender
35 -- reply_to
36 -- cover_letter_id
37 -- table_of_content_flag
38 -- trigger_code
39 -- subject
40 --
41 -- Required
42 --
43 -- Defaults
44 --
45 -- Note: This is automatic generated record definition, it includes all columns
46 -- defined in the table, developer must manually add or delete some of the attributes.
47 --
48 -- End of Comments
49
50 --===================================================================
51 TYPE ct_rule_rec_type IS RECORD
52 (
53 content_rule_id NUMBER := FND_API.G_MISS_NUM,
54 created_by NUMBER := FND_API.G_MISS_NUM,
55 creation_date DATE := FND_API.G_MISS_DATE,
56 last_updated_by NUMBER := FND_API.G_MISS_NUM,
57 last_updated_date DATE := FND_API.G_MISS_DATE,
58 last_update_login NUMBER := FND_API.G_MISS_NUM,
59 object_version_number NUMBER := FND_API.G_MISS_NUM,
60 object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
61 object_id NUMBER := FND_API.G_MISS_NUM,
62 sender VARCHAR2(2000) := FND_API.G_MISS_CHAR,
63 reply_to VARCHAR2(2000) := FND_API.G_MISS_CHAR,
64 cover_letter_id NUMBER := FND_API.G_MISS_NUM,
65 table_of_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
66 trigger_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
67 subject VARCHAR2(2000) := FND_API.G_MISS_CHAR,
68 sender_display_name VARCHAR2(2000) := FND_API.G_MISS_CHAR--anchaudh
69 );
70
71 g_miss_ct_rule_rec ct_rule_rec_type;
72 TYPE ct_rule_tbl_type IS TABLE OF ct_rule_rec_type INDEX BY BINARY_INTEGER;
73 g_miss_ct_rule_tbl ct_rule_tbl_type;
74
75 TYPE ct_rule_sort_rec_type IS RECORD
76 (
77 -- Please define your own sort by record here.
78 created_by NUMBER := NULL
79 );
80
81 -- ==============================================================================
82 -- Start of Comments
83 -- ==============================================================================
84 -- API Name
85 -- Create_Ct_Rule
86 -- Type
87 -- Public
88 -- Pre-Req
89 --
90 -- Parameters
91 --
92 -- IN
93 -- p_api_version_number IN NUMBER Required
94 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
95 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
96 -- p_ct_rule_rec IN ct_rule_rec_type Required
97 --
98 -- OUT
99 -- x_return_status OUT VARCHAR2
100 -- x_msg_count OUT NUMBER
101 -- x_msg_data OUT VARCHAR2
102 -- Version : Current version 1.0
103 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
104 -- and basic operation, developer must manually add parameters and business logic as necessary.
105 --
106 -- End of Comments
107 -- ==============================================================================
108 --
109
110 PROCEDURE Create_Ct_Rule(
111 p_api_version_number IN NUMBER,
112 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
113 p_commit IN VARCHAR2 := FND_API.G_FALSE,
114
115 x_return_status OUT NOCOPY VARCHAR2,
116 x_msg_count OUT NOCOPY NUMBER,
117 x_msg_data OUT NOCOPY VARCHAR2,
118
119 p_ct_rule_rec IN ct_rule_rec_type := g_miss_ct_rule_rec,
120 x_content_rule_id OUT NOCOPY NUMBER
121 );
122
123 -- ==============================================================================
124 -- Start of Comments
125 -- ==============================================================================
126 -- API Name
127 -- Update_Ct_Rule
128 -- Type
129 -- Public
130 -- Pre-Req
131 --
132 -- Parameters
133 --
134 -- IN
135 -- p_api_version_number IN NUMBER Required
136 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
137 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
138 -- p_ct_rule_rec IN ct_rule_rec_type Required
139 --
140 -- OUT
141 -- x_return_status OUT VARCHAR2
142 -- x_msg_count OUT NUMBER
143 -- x_msg_data OUT VARCHAR2
144 -- Version : Current version 1.0
145 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
146 -- and basic operation, developer must manually add parameters and business logic as necessary.
147 --
148 -- End of Comments
149 -- ==============================================================================
150 --
151
152 PROCEDURE Update_Ct_Rule(
153 p_api_version_number IN NUMBER,
154 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
155 p_commit IN VARCHAR2 := FND_API.G_FALSE,
156
157 x_return_status OUT NOCOPY VARCHAR2,
158 x_msg_count OUT NOCOPY NUMBER,
159 x_msg_data OUT NOCOPY VARCHAR2,
160
161 p_ct_rule_rec IN ct_rule_rec_type,
162 x_object_version_number OUT NOCOPY NUMBER
163 );
164
165 -- ==============================================================================
166 -- Start of Comments
167 -- ==============================================================================
168 -- API Name
169 -- Delete_Ct_Rule
170 -- Type
171 -- Public
172 -- Pre-Req
173 --
174 -- Parameters
175 --
176 -- IN
177 -- p_api_version_number IN NUMBER Required
178 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
179 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
180 -- p_CONTENT_RULE_ID IN NUMBER
181 -- p_object_version_number IN NUMBER Optional Default = NULL
182 --
183 -- OUT
184 -- x_return_status OUT VARCHAR2
185 -- x_msg_count OUT NUMBER
186 -- x_msg_data OUT VARCHAR2
187 -- Version : Current version 1.0
188 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
189 -- and basic operation, developer must manually add parameters and business logic as necessary.
190 --
191 -- End of Comments
192 -- ==============================================================================
193 --
194
195 PROCEDURE Delete_Ct_Rule(
196 p_api_version_number IN NUMBER,
197 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
198 p_commit IN VARCHAR2 := FND_API.G_FALSE,
199 x_return_status OUT NOCOPY VARCHAR2,
200 x_msg_count OUT NOCOPY NUMBER,
201 x_msg_data OUT NOCOPY VARCHAR2,
202 p_content_rule_id IN NUMBER,
203 p_object_version_number IN NUMBER
204 );
205
206 -- ==============================================================================
207 -- Start of Comments
208 -- ==============================================================================
209 -- API Name
210 -- Lock_Ct_Rule
211 -- Type
212 -- Public
213 -- Pre-Req
214 --
215 -- Parameters
216 --
217 -- IN
218 -- p_api_version_number IN NUMBER Required
219 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
220 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
221 -- p_ct_rule_rec IN ct_rule_rec_type Required
222 --
223 -- OUT
224 -- x_return_status OUT VARCHAR2
225 -- x_msg_count OUT NUMBER
226 -- x_msg_data OUT VARCHAR2
227 -- Version : Current version 1.0
228 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
229 -- and basic operation, developer must manually add parameters and business logic as necessary.
230 --
231 -- End of Comments
232 -- ==============================================================================
233 --
234
235 PROCEDURE Lock_Ct_Rule(
236 p_api_version_number IN NUMBER,
237 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
238 x_return_status OUT NOCOPY VARCHAR2,
239 x_msg_count OUT NOCOPY NUMBER,
240 x_msg_data OUT NOCOPY VARCHAR2,
241
242 p_content_rule_id IN NUMBER,
243 p_object_version IN NUMBER
244 );
245
246 END AMS_Ct_Rule_PUB;