57:
58: --===================================================================
59: TYPE ct_rule_rec_type IS RECORD
60: (
61: content_rule_id NUMBER := FND_API.G_MISS_NUM,
62: created_by NUMBER := FND_API.G_MISS_NUM,
63: creation_date DATE := FND_API.G_MISS_DATE,
64: last_updated_by NUMBER := FND_API.G_MISS_NUM,
65: last_updated_date DATE := FND_API.G_MISS_DATE,
58: --===================================================================
59: TYPE ct_rule_rec_type IS RECORD
60: (
61: content_rule_id NUMBER := FND_API.G_MISS_NUM,
62: created_by NUMBER := FND_API.G_MISS_NUM,
63: creation_date DATE := FND_API.G_MISS_DATE,
64: last_updated_by NUMBER := FND_API.G_MISS_NUM,
65: last_updated_date DATE := FND_API.G_MISS_DATE,
66: last_update_login NUMBER := FND_API.G_MISS_NUM,
59: TYPE ct_rule_rec_type IS RECORD
60: (
61: content_rule_id NUMBER := FND_API.G_MISS_NUM,
62: created_by NUMBER := FND_API.G_MISS_NUM,
63: creation_date DATE := FND_API.G_MISS_DATE,
64: last_updated_by NUMBER := FND_API.G_MISS_NUM,
65: last_updated_date DATE := FND_API.G_MISS_DATE,
66: last_update_login NUMBER := FND_API.G_MISS_NUM,
67: object_version_number NUMBER := FND_API.G_MISS_NUM,
60: (
61: content_rule_id NUMBER := FND_API.G_MISS_NUM,
62: created_by NUMBER := FND_API.G_MISS_NUM,
63: creation_date DATE := FND_API.G_MISS_DATE,
64: last_updated_by NUMBER := FND_API.G_MISS_NUM,
65: last_updated_date DATE := FND_API.G_MISS_DATE,
66: last_update_login NUMBER := FND_API.G_MISS_NUM,
67: object_version_number NUMBER := FND_API.G_MISS_NUM,
68: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
61: content_rule_id NUMBER := FND_API.G_MISS_NUM,
62: created_by NUMBER := FND_API.G_MISS_NUM,
63: creation_date DATE := FND_API.G_MISS_DATE,
64: last_updated_by NUMBER := FND_API.G_MISS_NUM,
65: last_updated_date DATE := FND_API.G_MISS_DATE,
66: last_update_login NUMBER := FND_API.G_MISS_NUM,
67: object_version_number NUMBER := FND_API.G_MISS_NUM,
68: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: object_id NUMBER := FND_API.G_MISS_NUM,
62: created_by NUMBER := FND_API.G_MISS_NUM,
63: creation_date DATE := FND_API.G_MISS_DATE,
64: last_updated_by NUMBER := FND_API.G_MISS_NUM,
65: last_updated_date DATE := FND_API.G_MISS_DATE,
66: last_update_login NUMBER := FND_API.G_MISS_NUM,
67: object_version_number NUMBER := FND_API.G_MISS_NUM,
68: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: object_id NUMBER := FND_API.G_MISS_NUM,
70: sender VARCHAR2(2000) := FND_API.G_MISS_CHAR,
63: creation_date DATE := FND_API.G_MISS_DATE,
64: last_updated_by NUMBER := FND_API.G_MISS_NUM,
65: last_updated_date DATE := FND_API.G_MISS_DATE,
66: last_update_login NUMBER := FND_API.G_MISS_NUM,
67: object_version_number NUMBER := FND_API.G_MISS_NUM,
68: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: object_id NUMBER := FND_API.G_MISS_NUM,
70: sender VARCHAR2(2000) := FND_API.G_MISS_CHAR,
71: reply_to VARCHAR2(2000) := FND_API.G_MISS_CHAR,
64: last_updated_by NUMBER := FND_API.G_MISS_NUM,
65: last_updated_date DATE := FND_API.G_MISS_DATE,
66: last_update_login NUMBER := FND_API.G_MISS_NUM,
67: object_version_number NUMBER := FND_API.G_MISS_NUM,
68: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: object_id NUMBER := FND_API.G_MISS_NUM,
70: sender VARCHAR2(2000) := FND_API.G_MISS_CHAR,
71: reply_to VARCHAR2(2000) := FND_API.G_MISS_CHAR,
72: cover_letter_id NUMBER := FND_API.G_MISS_NUM,
65: last_updated_date DATE := FND_API.G_MISS_DATE,
66: last_update_login NUMBER := FND_API.G_MISS_NUM,
67: object_version_number NUMBER := FND_API.G_MISS_NUM,
68: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: object_id NUMBER := FND_API.G_MISS_NUM,
70: sender VARCHAR2(2000) := FND_API.G_MISS_CHAR,
71: reply_to VARCHAR2(2000) := FND_API.G_MISS_CHAR,
72: cover_letter_id NUMBER := FND_API.G_MISS_NUM,
73: table_of_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
66: last_update_login NUMBER := FND_API.G_MISS_NUM,
67: object_version_number NUMBER := FND_API.G_MISS_NUM,
68: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: object_id NUMBER := FND_API.G_MISS_NUM,
70: sender VARCHAR2(2000) := FND_API.G_MISS_CHAR,
71: reply_to VARCHAR2(2000) := FND_API.G_MISS_CHAR,
72: cover_letter_id NUMBER := FND_API.G_MISS_NUM,
73: table_of_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
74: trigger_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
67: object_version_number NUMBER := FND_API.G_MISS_NUM,
68: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: object_id NUMBER := FND_API.G_MISS_NUM,
70: sender VARCHAR2(2000) := FND_API.G_MISS_CHAR,
71: reply_to VARCHAR2(2000) := FND_API.G_MISS_CHAR,
72: cover_letter_id NUMBER := FND_API.G_MISS_NUM,
73: table_of_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
74: trigger_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
75: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
68: object_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: object_id NUMBER := FND_API.G_MISS_NUM,
70: sender VARCHAR2(2000) := FND_API.G_MISS_CHAR,
71: reply_to VARCHAR2(2000) := FND_API.G_MISS_CHAR,
72: cover_letter_id NUMBER := FND_API.G_MISS_NUM,
73: table_of_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
74: trigger_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
75: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
76: subject VARCHAR2(2000) := FND_API.G_MISS_CHAR,
69: object_id NUMBER := FND_API.G_MISS_NUM,
70: sender VARCHAR2(2000) := FND_API.G_MISS_CHAR,
71: reply_to VARCHAR2(2000) := FND_API.G_MISS_CHAR,
72: cover_letter_id NUMBER := FND_API.G_MISS_NUM,
73: table_of_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
74: trigger_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
75: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
76: subject VARCHAR2(2000) := FND_API.G_MISS_CHAR,
77: sender_display_name VARCHAR2(2000) := FND_API.G_MISS_CHAR,--anchaudh
70: sender VARCHAR2(2000) := FND_API.G_MISS_CHAR,
71: reply_to VARCHAR2(2000) := FND_API.G_MISS_CHAR,
72: cover_letter_id NUMBER := FND_API.G_MISS_NUM,
73: table_of_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
74: trigger_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
75: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
76: subject VARCHAR2(2000) := FND_API.G_MISS_CHAR,
77: sender_display_name VARCHAR2(2000) := FND_API.G_MISS_CHAR,--anchaudh
78: delivery_mode VARCHAR2(30) := FND_API.G_MISS_CHAR --prageorg
71: reply_to VARCHAR2(2000) := FND_API.G_MISS_CHAR,
72: cover_letter_id NUMBER := FND_API.G_MISS_NUM,
73: table_of_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
74: trigger_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
75: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
76: subject VARCHAR2(2000) := FND_API.G_MISS_CHAR,
77: sender_display_name VARCHAR2(2000) := FND_API.G_MISS_CHAR,--anchaudh
78: delivery_mode VARCHAR2(30) := FND_API.G_MISS_CHAR --prageorg
79: );
72: cover_letter_id NUMBER := FND_API.G_MISS_NUM,
73: table_of_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
74: trigger_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
75: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
76: subject VARCHAR2(2000) := FND_API.G_MISS_CHAR,
77: sender_display_name VARCHAR2(2000) := FND_API.G_MISS_CHAR,--anchaudh
78: delivery_mode VARCHAR2(30) := FND_API.G_MISS_CHAR --prageorg
79: );
80:
73: table_of_content_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
74: trigger_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
75: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
76: subject VARCHAR2(2000) := FND_API.G_MISS_CHAR,
77: sender_display_name VARCHAR2(2000) := FND_API.G_MISS_CHAR,--anchaudh
78: delivery_mode VARCHAR2(30) := FND_API.G_MISS_CHAR --prageorg
79: );
80:
81: g_miss_ct_rule_rec ct_rule_rec_type;
74: trigger_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
75: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
76: subject VARCHAR2(2000) := FND_API.G_MISS_CHAR,
77: sender_display_name VARCHAR2(2000) := FND_API.G_MISS_CHAR,--anchaudh
78: delivery_mode VARCHAR2(30) := FND_API.G_MISS_CHAR --prageorg
79: );
80:
81: g_miss_ct_rule_rec ct_rule_rec_type;
82: TYPE ct_rule_tbl_type IS TABLE OF ct_rule_rec_type INDEX BY BINARY_INTEGER;
94: -- Parameters
95: --
96: -- IN
97: -- p_api_version_number IN NUMBER Required
98: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
99: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
100: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
101: -- p_ct_rule_rec IN ct_rule_rec_type Required
102: --
95: --
96: -- IN
97: -- p_api_version_number IN NUMBER Required
98: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
99: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
100: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
101: -- p_ct_rule_rec IN ct_rule_rec_type Required
102: --
103: -- OUT
96: -- IN
97: -- p_api_version_number IN NUMBER Required
98: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
99: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
100: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
101: -- p_ct_rule_rec IN ct_rule_rec_type Required
102: --
103: -- OUT
104: -- x_return_status OUT VARCHAR2
113: --
114:
115: PROCEDURE Create_Ct_Rule(
116: p_api_version_number IN NUMBER,
117: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
118: p_commit IN VARCHAR2 := FND_API.G_FALSE,
119: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
120:
121: x_return_status OUT NOCOPY VARCHAR2,
114:
115: PROCEDURE Create_Ct_Rule(
116: p_api_version_number IN NUMBER,
117: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
118: p_commit IN VARCHAR2 := FND_API.G_FALSE,
119: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
120:
121: x_return_status OUT NOCOPY VARCHAR2,
122: x_msg_count OUT NOCOPY NUMBER,
115: PROCEDURE Create_Ct_Rule(
116: p_api_version_number IN NUMBER,
117: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
118: p_commit IN VARCHAR2 := FND_API.G_FALSE,
119: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
120:
121: x_return_status OUT NOCOPY VARCHAR2,
122: x_msg_count OUT NOCOPY NUMBER,
123: x_msg_data OUT NOCOPY VARCHAR2,
138: -- Parameters
139: --
140: -- IN
141: -- p_api_version_number IN NUMBER Required
142: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
143: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
144: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
145: -- p_ct_rule_rec IN ct_rule_rec_type Required
146: --
139: --
140: -- IN
141: -- p_api_version_number IN NUMBER Required
142: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
143: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
144: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
145: -- p_ct_rule_rec IN ct_rule_rec_type Required
146: --
147: -- OUT
140: -- IN
141: -- p_api_version_number IN NUMBER Required
142: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
143: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
144: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
145: -- p_ct_rule_rec IN ct_rule_rec_type Required
146: --
147: -- OUT
148: -- x_return_status OUT VARCHAR2
157: --
158:
159: PROCEDURE Update_Ct_Rule(
160: p_api_version_number IN NUMBER,
161: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
162: p_commit IN VARCHAR2 := FND_API.G_FALSE,
163: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
164:
165: x_return_status OUT NOCOPY VARCHAR2,
158:
159: PROCEDURE Update_Ct_Rule(
160: p_api_version_number IN NUMBER,
161: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
162: p_commit IN VARCHAR2 := FND_API.G_FALSE,
163: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
164:
165: x_return_status OUT NOCOPY VARCHAR2,
166: x_msg_count OUT NOCOPY NUMBER,
159: PROCEDURE Update_Ct_Rule(
160: p_api_version_number IN NUMBER,
161: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
162: p_commit IN VARCHAR2 := FND_API.G_FALSE,
163: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
164:
165: x_return_status OUT NOCOPY VARCHAR2,
166: x_msg_count OUT NOCOPY NUMBER,
167: x_msg_data OUT NOCOPY VARCHAR2,
182: -- Parameters
183: --
184: -- IN
185: -- p_api_version_number IN NUMBER Required
186: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
187: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
188: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
189: -- p_CONTENT_RULE_ID IN NUMBER
190: -- p_object_version_number IN NUMBER Optional Default = NULL
183: --
184: -- IN
185: -- p_api_version_number IN NUMBER Required
186: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
187: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
188: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
189: -- p_CONTENT_RULE_ID IN NUMBER
190: -- p_object_version_number IN NUMBER Optional Default = NULL
191: --
184: -- IN
185: -- p_api_version_number IN NUMBER Required
186: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
187: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
188: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
189: -- p_CONTENT_RULE_ID IN NUMBER
190: -- p_object_version_number IN NUMBER Optional Default = NULL
191: --
192: -- OUT
202: --
203:
204: PROCEDURE Delete_Ct_Rule(
205: p_api_version_number IN NUMBER,
206: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
207: p_commit IN VARCHAR2 := FND_API.G_FALSE,
208: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
209: x_return_status OUT NOCOPY VARCHAR2,
210: x_msg_count OUT NOCOPY NUMBER,
203:
204: PROCEDURE Delete_Ct_Rule(
205: p_api_version_number IN NUMBER,
206: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
207: p_commit IN VARCHAR2 := FND_API.G_FALSE,
208: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
209: x_return_status OUT NOCOPY VARCHAR2,
210: x_msg_count OUT NOCOPY NUMBER,
211: x_msg_data OUT NOCOPY VARCHAR2,
204: PROCEDURE Delete_Ct_Rule(
205: p_api_version_number IN NUMBER,
206: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
207: p_commit IN VARCHAR2 := FND_API.G_FALSE,
208: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
209: x_return_status OUT NOCOPY VARCHAR2,
210: x_msg_count OUT NOCOPY NUMBER,
211: x_msg_data OUT NOCOPY VARCHAR2,
212: p_content_rule_id IN NUMBER,
225: -- Parameters
226: --
227: -- IN
228: -- p_api_version_number IN NUMBER Required
229: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
230: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
231: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
232: -- p_ct_rule_rec IN ct_rule_rec_type Required
233: --
226: --
227: -- IN
228: -- p_api_version_number IN NUMBER Required
229: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
230: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
231: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
232: -- p_ct_rule_rec IN ct_rule_rec_type Required
233: --
234: -- OUT
227: -- IN
228: -- p_api_version_number IN NUMBER Required
229: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
230: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
231: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
232: -- p_ct_rule_rec IN ct_rule_rec_type Required
233: --
234: -- OUT
235: -- x_return_status OUT VARCHAR2
244: --
245:
246: PROCEDURE Lock_Ct_Rule(
247: p_api_version_number IN NUMBER,
248: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
249:
250: x_return_status OUT NOCOPY VARCHAR2,
251: x_msg_count OUT NOCOPY NUMBER,
252: x_msg_data OUT NOCOPY VARCHAR2,
268: -- End of Comments
269:
270: PROCEDURE Validate_ct_rule(
271: p_api_version_number IN NUMBER,
272: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
273: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
274: p_ct_rule_rec IN ct_rule_rec_type,
275: p_validation_mode IN VARCHAR2,
276: x_return_status OUT NOCOPY VARCHAR2,
269:
270: PROCEDURE Validate_ct_rule(
271: p_api_version_number IN NUMBER,
272: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
273: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
274: p_ct_rule_rec IN ct_rule_rec_type,
275: p_validation_mode IN VARCHAR2,
276: x_return_status OUT NOCOPY VARCHAR2,
277: x_msg_count OUT NOCOPY NUMBER,
307: -- End of Comments
308:
309: PROCEDURE Validate_ct_rule_rec(
310: p_api_version_number IN NUMBER,
311: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
312: x_return_status OUT NOCOPY VARCHAR2,
313: x_msg_count OUT NOCOPY NUMBER,
314: x_msg_data OUT NOCOPY VARCHAR2,
315: p_ct_rule_rec IN ct_rule_rec_type
330: --===================================================================
331:
332: PROCEDURE check_content_rule(
333: p_api_version IN NUMBER,
334: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
335: p_commit IN VARCHAR2 := FND_API.g_false,
336: p_object_type IN VARCHAR2,
337: p_object_id IN NUMBER,
338: p_trigger_type IN VARCHAR2,
331:
332: PROCEDURE check_content_rule(
333: p_api_version IN NUMBER,
334: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
335: p_commit IN VARCHAR2 := FND_API.g_false,
336: p_object_type IN VARCHAR2,
337: p_object_id IN NUMBER,
338: p_trigger_type IN VARCHAR2,
339: p_requestor_type IN VARCHAR2 := NULL,