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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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: );
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:
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;
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;
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
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
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,
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,
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
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
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,
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,
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: --
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
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,
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,
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
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
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: