57:
58: --===================================================================
59: TYPE list_group_rec_type IS RECORD
60: (
61: act_list_group_id NUMBER := FND_API.G_MISS_NUM,
62: act_list_used_by_id NUMBER := FND_API.G_MISS_NUM,
63: arc_act_list_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: group_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
65: group_priority NUMBER := FND_API.G_MISS_NUM,
58: --===================================================================
59: TYPE list_group_rec_type IS RECORD
60: (
61: act_list_group_id NUMBER := FND_API.G_MISS_NUM,
62: act_list_used_by_id NUMBER := FND_API.G_MISS_NUM,
63: arc_act_list_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: group_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
65: group_priority NUMBER := FND_API.G_MISS_NUM,
66: last_update_date DATE := FND_API.G_MISS_DATE,
59: TYPE list_group_rec_type IS RECORD
60: (
61: act_list_group_id NUMBER := FND_API.G_MISS_NUM,
62: act_list_used_by_id NUMBER := FND_API.G_MISS_NUM,
63: arc_act_list_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: group_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
65: group_priority NUMBER := FND_API.G_MISS_NUM,
66: last_update_date DATE := FND_API.G_MISS_DATE,
67: last_updated_by NUMBER := FND_API.G_MISS_NUM,
60: (
61: act_list_group_id NUMBER := FND_API.G_MISS_NUM,
62: act_list_used_by_id NUMBER := FND_API.G_MISS_NUM,
63: arc_act_list_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: group_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
65: group_priority NUMBER := FND_API.G_MISS_NUM,
66: last_update_date DATE := FND_API.G_MISS_DATE,
67: last_updated_by NUMBER := FND_API.G_MISS_NUM,
68: creation_date DATE := FND_API.G_MISS_DATE,
61: act_list_group_id NUMBER := FND_API.G_MISS_NUM,
62: act_list_used_by_id NUMBER := FND_API.G_MISS_NUM,
63: arc_act_list_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: group_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
65: group_priority NUMBER := FND_API.G_MISS_NUM,
66: last_update_date DATE := FND_API.G_MISS_DATE,
67: last_updated_by NUMBER := FND_API.G_MISS_NUM,
68: creation_date DATE := FND_API.G_MISS_DATE,
69: created_by NUMBER := FND_API.G_MISS_NUM,
62: act_list_used_by_id NUMBER := FND_API.G_MISS_NUM,
63: arc_act_list_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: group_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
65: group_priority NUMBER := FND_API.G_MISS_NUM,
66: last_update_date DATE := FND_API.G_MISS_DATE,
67: last_updated_by NUMBER := FND_API.G_MISS_NUM,
68: creation_date DATE := FND_API.G_MISS_DATE,
69: created_by NUMBER := FND_API.G_MISS_NUM,
70: last_update_login NUMBER := FND_API.G_MISS_NUM,
63: arc_act_list_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: group_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
65: group_priority NUMBER := FND_API.G_MISS_NUM,
66: last_update_date DATE := FND_API.G_MISS_DATE,
67: last_updated_by NUMBER := FND_API.G_MISS_NUM,
68: creation_date DATE := FND_API.G_MISS_DATE,
69: created_by NUMBER := FND_API.G_MISS_NUM,
70: last_update_login NUMBER := FND_API.G_MISS_NUM,
71: object_version_number NUMBER := FND_API.G_MISS_NUM,
64: group_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
65: group_priority NUMBER := FND_API.G_MISS_NUM,
66: last_update_date DATE := FND_API.G_MISS_DATE,
67: last_updated_by NUMBER := FND_API.G_MISS_NUM,
68: creation_date DATE := FND_API.G_MISS_DATE,
69: created_by NUMBER := FND_API.G_MISS_NUM,
70: last_update_login NUMBER := FND_API.G_MISS_NUM,
71: object_version_number NUMBER := FND_API.G_MISS_NUM,
72: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: group_priority NUMBER := FND_API.G_MISS_NUM,
66: last_update_date DATE := FND_API.G_MISS_DATE,
67: last_updated_by NUMBER := FND_API.G_MISS_NUM,
68: creation_date DATE := FND_API.G_MISS_DATE,
69: created_by NUMBER := FND_API.G_MISS_NUM,
70: last_update_login NUMBER := FND_API.G_MISS_NUM,
71: object_version_number NUMBER := FND_API.G_MISS_NUM,
72: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: user_status_id NUMBER := FND_API.G_MISS_NUM,
66: last_update_date DATE := FND_API.G_MISS_DATE,
67: last_updated_by NUMBER := FND_API.G_MISS_NUM,
68: creation_date DATE := FND_API.G_MISS_DATE,
69: created_by NUMBER := FND_API.G_MISS_NUM,
70: last_update_login NUMBER := FND_API.G_MISS_NUM,
71: object_version_number NUMBER := FND_API.G_MISS_NUM,
72: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: user_status_id NUMBER := FND_API.G_MISS_NUM,
74: calling_calendar_id NUMBER := FND_API.G_MISS_NUM,
67: last_updated_by NUMBER := FND_API.G_MISS_NUM,
68: creation_date DATE := FND_API.G_MISS_DATE,
69: created_by NUMBER := FND_API.G_MISS_NUM,
70: last_update_login NUMBER := FND_API.G_MISS_NUM,
71: object_version_number NUMBER := FND_API.G_MISS_NUM,
72: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: user_status_id NUMBER := FND_API.G_MISS_NUM,
74: calling_calendar_id NUMBER := FND_API.G_MISS_NUM,
75: release_control_alg_id NUMBER := FND_API.G_MISS_NUM,
68: creation_date DATE := FND_API.G_MISS_DATE,
69: created_by NUMBER := FND_API.G_MISS_NUM,
70: last_update_login NUMBER := FND_API.G_MISS_NUM,
71: object_version_number NUMBER := FND_API.G_MISS_NUM,
72: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: user_status_id NUMBER := FND_API.G_MISS_NUM,
74: calling_calendar_id NUMBER := FND_API.G_MISS_NUM,
75: release_control_alg_id NUMBER := FND_API.G_MISS_NUM,
76: release_strategy VARCHAR2(30) := FND_API.G_MISS_CHAR,
69: created_by NUMBER := FND_API.G_MISS_NUM,
70: last_update_login NUMBER := FND_API.G_MISS_NUM,
71: object_version_number NUMBER := FND_API.G_MISS_NUM,
72: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: user_status_id NUMBER := FND_API.G_MISS_NUM,
74: calling_calendar_id NUMBER := FND_API.G_MISS_NUM,
75: release_control_alg_id NUMBER := FND_API.G_MISS_NUM,
76: release_strategy VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: recycling_alg_id NUMBER := FND_API.G_MISS_NUM,
70: last_update_login NUMBER := FND_API.G_MISS_NUM,
71: object_version_number NUMBER := FND_API.G_MISS_NUM,
72: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: user_status_id NUMBER := FND_API.G_MISS_NUM,
74: calling_calendar_id NUMBER := FND_API.G_MISS_NUM,
75: release_control_alg_id NUMBER := FND_API.G_MISS_NUM,
76: release_strategy VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: recycling_alg_id NUMBER := FND_API.G_MISS_NUM,
78: callback_priority_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
71: object_version_number NUMBER := FND_API.G_MISS_NUM,
72: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: user_status_id NUMBER := FND_API.G_MISS_NUM,
74: calling_calendar_id NUMBER := FND_API.G_MISS_NUM,
75: release_control_alg_id NUMBER := FND_API.G_MISS_NUM,
76: release_strategy VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: recycling_alg_id NUMBER := FND_API.G_MISS_NUM,
78: callback_priority_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
79: call_center_ready_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
72: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: user_status_id NUMBER := FND_API.G_MISS_NUM,
74: calling_calendar_id NUMBER := FND_API.G_MISS_NUM,
75: release_control_alg_id NUMBER := FND_API.G_MISS_NUM,
76: release_strategy VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: recycling_alg_id NUMBER := FND_API.G_MISS_NUM,
78: callback_priority_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
79: call_center_ready_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
80: dialing_method VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: user_status_id NUMBER := FND_API.G_MISS_NUM,
74: calling_calendar_id NUMBER := FND_API.G_MISS_NUM,
75: release_control_alg_id NUMBER := FND_API.G_MISS_NUM,
76: release_strategy VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: recycling_alg_id NUMBER := FND_API.G_MISS_NUM,
78: callback_priority_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
79: call_center_ready_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
80: dialing_method VARCHAR2(30) := FND_API.G_MISS_CHAR,
81: quantum NUMBER := FND_API.G_MISS_NUM,
74: calling_calendar_id NUMBER := FND_API.G_MISS_NUM,
75: release_control_alg_id NUMBER := FND_API.G_MISS_NUM,
76: release_strategy VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: recycling_alg_id NUMBER := FND_API.G_MISS_NUM,
78: callback_priority_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
79: call_center_ready_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
80: dialing_method VARCHAR2(30) := FND_API.G_MISS_CHAR,
81: quantum NUMBER := FND_API.G_MISS_NUM,
82: quota NUMBER := FND_API.G_MISS_NUM,
75: release_control_alg_id NUMBER := FND_API.G_MISS_NUM,
76: release_strategy VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: recycling_alg_id NUMBER := FND_API.G_MISS_NUM,
78: callback_priority_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
79: call_center_ready_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
80: dialing_method VARCHAR2(30) := FND_API.G_MISS_CHAR,
81: quantum NUMBER := FND_API.G_MISS_NUM,
82: quota NUMBER := FND_API.G_MISS_NUM,
83: quota_reset NUMBER := FND_API.G_MISS_NUM
76: release_strategy VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: recycling_alg_id NUMBER := FND_API.G_MISS_NUM,
78: callback_priority_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
79: call_center_ready_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
80: dialing_method VARCHAR2(30) := FND_API.G_MISS_CHAR,
81: quantum NUMBER := FND_API.G_MISS_NUM,
82: quota NUMBER := FND_API.G_MISS_NUM,
83: quota_reset NUMBER := FND_API.G_MISS_NUM
84: );
77: recycling_alg_id NUMBER := FND_API.G_MISS_NUM,
78: callback_priority_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
79: call_center_ready_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
80: dialing_method VARCHAR2(30) := FND_API.G_MISS_CHAR,
81: quantum NUMBER := FND_API.G_MISS_NUM,
82: quota NUMBER := FND_API.G_MISS_NUM,
83: quota_reset NUMBER := FND_API.G_MISS_NUM
84: );
85:
78: callback_priority_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
79: call_center_ready_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
80: dialing_method VARCHAR2(30) := FND_API.G_MISS_CHAR,
81: quantum NUMBER := FND_API.G_MISS_NUM,
82: quota NUMBER := FND_API.G_MISS_NUM,
83: quota_reset NUMBER := FND_API.G_MISS_NUM
84: );
85:
86: g_miss_list_group_rec list_group_rec_type;
79: call_center_ready_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
80: dialing_method VARCHAR2(30) := FND_API.G_MISS_CHAR,
81: quantum NUMBER := FND_API.G_MISS_NUM,
82: quota NUMBER := FND_API.G_MISS_NUM,
83: quota_reset NUMBER := FND_API.G_MISS_NUM
84: );
85:
86: g_miss_list_group_rec list_group_rec_type;
87: TYPE list_group_tbl_type IS TABLE OF list_group_rec_type INDEX BY BINARY_INTEGER;
99: -- Parameters
100: --
101: -- IN
102: -- p_api_version_number IN NUMBER Required
103: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
104: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
105: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
106: -- p_list_group_rec IN list_group_rec_type Required
107: --
100: --
101: -- IN
102: -- p_api_version_number IN NUMBER Required
103: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
104: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
105: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
106: -- p_list_group_rec IN list_group_rec_type Required
107: --
108: -- OUT
101: -- IN
102: -- p_api_version_number IN NUMBER Required
103: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
104: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
105: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
106: -- p_list_group_rec IN list_group_rec_type Required
107: --
108: -- OUT
109: -- x_return_status OUT VARCHAR2
118: --
119:
120: PROCEDURE Create_List_Group(
121: p_api_version_number IN NUMBER,
122: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
123: p_commit IN VARCHAR2 := FND_API.G_FALSE,
124: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
125:
126: x_return_status OUT NOCOPY VARCHAR2,
119:
120: PROCEDURE Create_List_Group(
121: p_api_version_number IN NUMBER,
122: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
123: p_commit IN VARCHAR2 := FND_API.G_FALSE,
124: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
125:
126: x_return_status OUT NOCOPY VARCHAR2,
127: x_msg_count OUT NOCOPY NUMBER,
120: PROCEDURE Create_List_Group(
121: p_api_version_number IN NUMBER,
122: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
123: p_commit IN VARCHAR2 := FND_API.G_FALSE,
124: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
125:
126: x_return_status OUT NOCOPY VARCHAR2,
127: x_msg_count OUT NOCOPY NUMBER,
128: x_msg_data OUT NOCOPY VARCHAR2,
143: -- Parameters
144: --
145: -- IN
146: -- p_api_version_number IN NUMBER Required
147: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
148: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
149: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
150: -- p_list_group_rec IN list_group_rec_type Required
151: --
144: --
145: -- IN
146: -- p_api_version_number IN NUMBER Required
147: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
148: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
149: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
150: -- p_list_group_rec IN list_group_rec_type Required
151: --
152: -- OUT
145: -- IN
146: -- p_api_version_number IN NUMBER Required
147: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
148: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
149: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
150: -- p_list_group_rec IN list_group_rec_type Required
151: --
152: -- OUT
153: -- x_return_status OUT VARCHAR2
162: --
163:
164: PROCEDURE Update_List_Group(
165: p_api_version_number IN NUMBER,
166: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
167: p_commit IN VARCHAR2 := FND_API.G_FALSE,
168: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
169:
170: x_return_status OUT NOCOPY VARCHAR2,
163:
164: PROCEDURE Update_List_Group(
165: p_api_version_number IN NUMBER,
166: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
167: p_commit IN VARCHAR2 := FND_API.G_FALSE,
168: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
169:
170: x_return_status OUT NOCOPY VARCHAR2,
171: x_msg_count OUT NOCOPY NUMBER,
164: PROCEDURE Update_List_Group(
165: p_api_version_number IN NUMBER,
166: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
167: p_commit IN VARCHAR2 := FND_API.G_FALSE,
168: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
169:
170: x_return_status OUT NOCOPY VARCHAR2,
171: x_msg_count OUT NOCOPY NUMBER,
172: x_msg_data OUT NOCOPY VARCHAR2,
187: -- Parameters
188: --
189: -- IN
190: -- p_api_version_number IN NUMBER Required
191: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
192: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
193: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
194: -- p_ACT_LIST_GROUP_ID IN NUMBER
195: -- p_object_version_number IN NUMBER Optional Default = NULL
188: --
189: -- IN
190: -- p_api_version_number IN NUMBER Required
191: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
192: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
193: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
194: -- p_ACT_LIST_GROUP_ID IN NUMBER
195: -- p_object_version_number IN NUMBER Optional Default = NULL
196: --
189: -- IN
190: -- p_api_version_number IN NUMBER Required
191: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
192: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
193: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
194: -- p_ACT_LIST_GROUP_ID IN NUMBER
195: -- p_object_version_number IN NUMBER Optional Default = NULL
196: --
197: -- OUT
207: --
208:
209: PROCEDURE Delete_List_Group(
210: p_api_version_number IN NUMBER,
211: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
212: p_commit IN VARCHAR2 := FND_API.G_FALSE,
213: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
214: x_return_status OUT NOCOPY VARCHAR2,
215: x_msg_count OUT NOCOPY NUMBER,
208:
209: PROCEDURE Delete_List_Group(
210: p_api_version_number IN NUMBER,
211: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
212: p_commit IN VARCHAR2 := FND_API.G_FALSE,
213: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
214: x_return_status OUT NOCOPY VARCHAR2,
215: x_msg_count OUT NOCOPY NUMBER,
216: x_msg_data OUT NOCOPY VARCHAR2,
209: PROCEDURE Delete_List_Group(
210: p_api_version_number IN NUMBER,
211: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
212: p_commit IN VARCHAR2 := FND_API.G_FALSE,
213: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
214: x_return_status OUT NOCOPY VARCHAR2,
215: x_msg_count OUT NOCOPY NUMBER,
216: x_msg_data OUT NOCOPY VARCHAR2,
217: p_act_list_group_id IN NUMBER,
230: -- Parameters
231: --
232: -- IN
233: -- p_api_version_number IN NUMBER Required
234: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
235: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
236: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
237: -- p_list_group_rec IN list_group_rec_type Required
238: --
231: --
232: -- IN
233: -- p_api_version_number IN NUMBER Required
234: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
235: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
236: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
237: -- p_list_group_rec IN list_group_rec_type Required
238: --
239: -- OUT
232: -- IN
233: -- p_api_version_number IN NUMBER Required
234: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
235: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
236: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
237: -- p_list_group_rec IN list_group_rec_type Required
238: --
239: -- OUT
240: -- x_return_status OUT VARCHAR2
249: --
250:
251: PROCEDURE Lock_List_Group(
252: p_api_version_number IN NUMBER,
253: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
254:
255: x_return_status OUT NOCOPY VARCHAR2,
256: x_msg_count OUT NOCOPY NUMBER,
257: x_msg_data OUT NOCOPY VARCHAR2,
273: -- End of Comments
274:
275: PROCEDURE Validate_list_group(
276: p_api_version_number IN NUMBER,
277: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
278: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
279: p_list_group_rec IN list_group_rec_type,
280: x_return_status OUT NOCOPY VARCHAR2,
281: x_msg_count OUT NOCOPY NUMBER,
274:
275: PROCEDURE Validate_list_group(
276: p_api_version_number IN NUMBER,
277: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
278: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
279: p_list_group_rec IN list_group_rec_type,
280: x_return_status OUT NOCOPY VARCHAR2,
281: x_msg_count OUT NOCOPY NUMBER,
282: x_msg_data OUT NOCOPY VARCHAR2
311: -- End of Comments
312:
313: PROCEDURE Validate_list_group_rec(
314: p_api_version_number IN NUMBER,
315: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
316: x_return_status OUT NOCOPY VARCHAR2,
317: x_msg_count OUT NOCOPY NUMBER,
318: x_msg_data OUT NOCOPY VARCHAR2,
319: p_list_group_rec IN list_group_rec_type