DBA Data[Home] [Help]

APPS.AMS_CT_RULE_PVT dependencies on FND_API

Line 61: content_rule_id NUMBER := FND_API.G_MISS_NUM,

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,

Line 62: created_by NUMBER := FND_API.G_MISS_NUM,

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,

Line 63: creation_date DATE := FND_API.G_MISS_DATE,

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,

Line 64: last_updated_by 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,

Line 65: last_updated_date DATE := FND_API.G_MISS_DATE,

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,

Line 66: last_update_login 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,

Line 67: object_version_number 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,
71: reply_to VARCHAR2(2000) := FND_API.G_MISS_CHAR,

Line 68: object_type VARCHAR2(30) := 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,

Line 69: object_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,

Line 70: sender VARCHAR2(2000) := 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,

Line 71: reply_to VARCHAR2(2000) := 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,

Line 72: cover_letter_id 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,
76: subject VARCHAR2(2000) := FND_API.G_MISS_CHAR,

Line 73: table_of_content_flag VARCHAR2(1) := 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

Line 74: trigger_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

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

Line 75: enabled_flag VARCHAR2(1) := 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
79: );

Line 76: subject 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: );
80:

Line 77: sender_display_name VARCHAR2(2000) := FND_API.G_MISS_CHAR,--anchaudh

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;

Line 78: delivery_mode VARCHAR2(30) := FND_API.G_MISS_CHAR --prageorg

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;

Line 98: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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: --

Line 99: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

Line 100: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

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

Line 117: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 118: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 119: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 142: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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: --

Line 143: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

Line 144: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

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

Line 161: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 162: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 163: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 186: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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

Line 187: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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: --

Line 188: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

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

Line 206: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 207: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 208: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 229: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

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: --

Line 230: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

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

Line 231: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

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

Line 248: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 272: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 273: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 311: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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

Line 334: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

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,

Line 335: p_commit IN VARCHAR2 := FND_API.g_false,

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,