49:
50: --===================================================================
51: TYPE act_list_rec_type IS RECORD
52: (
53: act_list_header_id NUMBER := FND_API.G_MISS_NUM,
54: last_update_date DATE := FND_API.G_MISS_DATE,
55: last_updated_by NUMBER := FND_API.G_MISS_NUM,
56: creation_date DATE := FND_API.G_MISS_DATE,
57: created_by NUMBER := FND_API.G_MISS_NUM,
50: --===================================================================
51: TYPE act_list_rec_type IS RECORD
52: (
53: act_list_header_id NUMBER := FND_API.G_MISS_NUM,
54: last_update_date DATE := FND_API.G_MISS_DATE,
55: last_updated_by NUMBER := FND_API.G_MISS_NUM,
56: creation_date DATE := FND_API.G_MISS_DATE,
57: created_by NUMBER := FND_API.G_MISS_NUM,
58: object_version_number NUMBER := FND_API.G_MISS_NUM,
51: TYPE act_list_rec_type IS RECORD
52: (
53: act_list_header_id NUMBER := FND_API.G_MISS_NUM,
54: last_update_date DATE := FND_API.G_MISS_DATE,
55: last_updated_by NUMBER := FND_API.G_MISS_NUM,
56: creation_date DATE := FND_API.G_MISS_DATE,
57: created_by NUMBER := FND_API.G_MISS_NUM,
58: object_version_number NUMBER := FND_API.G_MISS_NUM,
59: last_update_login NUMBER := FND_API.G_MISS_NUM,
52: (
53: act_list_header_id NUMBER := FND_API.G_MISS_NUM,
54: last_update_date DATE := FND_API.G_MISS_DATE,
55: last_updated_by NUMBER := FND_API.G_MISS_NUM,
56: creation_date DATE := FND_API.G_MISS_DATE,
57: created_by NUMBER := FND_API.G_MISS_NUM,
58: object_version_number NUMBER := FND_API.G_MISS_NUM,
59: last_update_login NUMBER := FND_API.G_MISS_NUM,
60: list_header_id NUMBER := FND_API.G_MISS_NUM,
53: act_list_header_id NUMBER := FND_API.G_MISS_NUM,
54: last_update_date DATE := FND_API.G_MISS_DATE,
55: last_updated_by NUMBER := FND_API.G_MISS_NUM,
56: creation_date DATE := FND_API.G_MISS_DATE,
57: created_by NUMBER := FND_API.G_MISS_NUM,
58: object_version_number NUMBER := FND_API.G_MISS_NUM,
59: last_update_login NUMBER := FND_API.G_MISS_NUM,
60: list_header_id NUMBER := FND_API.G_MISS_NUM,
61: group_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
54: last_update_date DATE := FND_API.G_MISS_DATE,
55: last_updated_by NUMBER := FND_API.G_MISS_NUM,
56: creation_date DATE := FND_API.G_MISS_DATE,
57: created_by NUMBER := FND_API.G_MISS_NUM,
58: object_version_number NUMBER := FND_API.G_MISS_NUM,
59: last_update_login NUMBER := FND_API.G_MISS_NUM,
60: list_header_id NUMBER := FND_API.G_MISS_NUM,
61: group_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
62: list_used_by_id NUMBER := FND_API.G_MISS_NUM,
55: last_updated_by NUMBER := FND_API.G_MISS_NUM,
56: creation_date DATE := FND_API.G_MISS_DATE,
57: created_by NUMBER := FND_API.G_MISS_NUM,
58: object_version_number NUMBER := FND_API.G_MISS_NUM,
59: last_update_login NUMBER := FND_API.G_MISS_NUM,
60: list_header_id NUMBER := FND_API.G_MISS_NUM,
61: group_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
62: list_used_by_id NUMBER := FND_API.G_MISS_NUM,
63: list_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: creation_date DATE := FND_API.G_MISS_DATE,
57: created_by NUMBER := FND_API.G_MISS_NUM,
58: object_version_number NUMBER := FND_API.G_MISS_NUM,
59: last_update_login NUMBER := FND_API.G_MISS_NUM,
60: list_header_id NUMBER := FND_API.G_MISS_NUM,
61: group_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
62: list_used_by_id NUMBER := FND_API.G_MISS_NUM,
63: list_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: list_act_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
57: created_by NUMBER := FND_API.G_MISS_NUM,
58: object_version_number NUMBER := FND_API.G_MISS_NUM,
59: last_update_login NUMBER := FND_API.G_MISS_NUM,
60: list_header_id NUMBER := FND_API.G_MISS_NUM,
61: group_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
62: list_used_by_id NUMBER := FND_API.G_MISS_NUM,
63: list_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: list_act_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: list_action_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
58: object_version_number NUMBER := FND_API.G_MISS_NUM,
59: last_update_login NUMBER := FND_API.G_MISS_NUM,
60: list_header_id NUMBER := FND_API.G_MISS_NUM,
61: group_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
62: list_used_by_id NUMBER := FND_API.G_MISS_NUM,
63: list_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: list_act_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: list_action_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: order_number NUMBER := FND_API.G_MISS_NUM
59: last_update_login NUMBER := FND_API.G_MISS_NUM,
60: list_header_id NUMBER := FND_API.G_MISS_NUM,
61: group_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
62: list_used_by_id NUMBER := FND_API.G_MISS_NUM,
63: list_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: list_act_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: list_action_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: order_number NUMBER := FND_API.G_MISS_NUM
67: );
60: list_header_id NUMBER := FND_API.G_MISS_NUM,
61: group_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
62: list_used_by_id NUMBER := FND_API.G_MISS_NUM,
63: list_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: list_act_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: list_action_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: order_number NUMBER := FND_API.G_MISS_NUM
67: );
68:
61: group_code VARCHAR2(10) := FND_API.G_MISS_CHAR,
62: list_used_by_id NUMBER := FND_API.G_MISS_NUM,
63: list_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: list_act_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: list_action_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: order_number NUMBER := FND_API.G_MISS_NUM
67: );
68:
69: g_miss_act_list_rec act_list_rec_type;
62: list_used_by_id NUMBER := FND_API.G_MISS_NUM,
63: list_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
64: list_act_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: list_action_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
66: order_number NUMBER := FND_API.G_MISS_NUM
67: );
68:
69: g_miss_act_list_rec act_list_rec_type;
70: TYPE act_list_tbl_type IS TABLE OF act_list_rec_type INDEX BY BINARY_INTEGER;
82: -- Parameters
83: --
84: -- IN
85: -- p_api_version_number IN NUMBER Required
86: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
87: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
88: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
89: -- p_act_list_rec IN act_list_rec_type Required
90: --
83: --
84: -- IN
85: -- p_api_version_number IN NUMBER Required
86: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
87: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
88: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
89: -- p_act_list_rec IN act_list_rec_type Required
90: --
91: -- OUT
84: -- IN
85: -- p_api_version_number IN NUMBER Required
86: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
87: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
88: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
89: -- p_act_list_rec IN act_list_rec_type Required
90: --
91: -- OUT
92: -- x_return_status OUT VARCHAR2
101: --
102:
103: PROCEDURE Create_Act_List(
104: p_api_version_number IN NUMBER,
105: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
106: p_commit IN VARCHAR2 := FND_API.G_FALSE,
107: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
108:
109: x_return_status OUT NOCOPY VARCHAR2,
102:
103: PROCEDURE Create_Act_List(
104: p_api_version_number IN NUMBER,
105: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
106: p_commit IN VARCHAR2 := FND_API.G_FALSE,
107: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
108:
109: x_return_status OUT NOCOPY VARCHAR2,
110: x_msg_count OUT NOCOPY NUMBER,
103: PROCEDURE Create_Act_List(
104: p_api_version_number IN NUMBER,
105: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
106: p_commit IN VARCHAR2 := FND_API.G_FALSE,
107: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
108:
109: x_return_status OUT NOCOPY VARCHAR2,
110: x_msg_count OUT NOCOPY NUMBER,
111: x_msg_data OUT NOCOPY VARCHAR2,
126: -- Parameters
127: --
128: -- IN
129: -- p_api_version_number IN NUMBER Required
130: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
131: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
132: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
133: -- p_act_list_rec IN act_list_rec_type Required
134: --
127: --
128: -- IN
129: -- p_api_version_number IN NUMBER Required
130: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
131: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
132: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
133: -- p_act_list_rec IN act_list_rec_type Required
134: --
135: -- OUT
128: -- IN
129: -- p_api_version_number IN NUMBER Required
130: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
131: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
132: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
133: -- p_act_list_rec IN act_list_rec_type Required
134: --
135: -- OUT
136: -- x_return_status OUT VARCHAR2
145: --
146:
147: PROCEDURE Update_Act_List(
148: p_api_version_number IN NUMBER,
149: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
150: p_commit IN VARCHAR2 := FND_API.G_FALSE,
151: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
152:
153: x_return_status OUT NOCOPY VARCHAR2,
146:
147: PROCEDURE Update_Act_List(
148: p_api_version_number IN NUMBER,
149: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
150: p_commit IN VARCHAR2 := FND_API.G_FALSE,
151: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
152:
153: x_return_status OUT NOCOPY VARCHAR2,
154: x_msg_count OUT NOCOPY NUMBER,
147: PROCEDURE Update_Act_List(
148: p_api_version_number IN NUMBER,
149: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
150: p_commit IN VARCHAR2 := FND_API.G_FALSE,
151: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
152:
153: x_return_status OUT NOCOPY VARCHAR2,
154: x_msg_count OUT NOCOPY NUMBER,
155: x_msg_data OUT NOCOPY VARCHAR2,
170: -- Parameters
171: --
172: -- IN
173: -- p_api_version_number IN NUMBER Required
174: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
175: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
176: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
177: -- p_ACT_LIST_HEADER_ID IN NUMBER
178: -- p_object_version_number IN NUMBER Optional Default = NULL
171: --
172: -- IN
173: -- p_api_version_number IN NUMBER Required
174: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
175: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
176: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
177: -- p_ACT_LIST_HEADER_ID IN NUMBER
178: -- p_object_version_number IN NUMBER Optional Default = NULL
179: --
172: -- IN
173: -- p_api_version_number IN NUMBER Required
174: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
175: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
176: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
177: -- p_ACT_LIST_HEADER_ID IN NUMBER
178: -- p_object_version_number IN NUMBER Optional Default = NULL
179: --
180: -- OUT
190: --
191:
192: PROCEDURE Delete_Act_List(
193: p_api_version_number IN NUMBER,
194: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
195: p_commit IN VARCHAR2 := FND_API.G_FALSE,
196: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
197: x_return_status OUT NOCOPY VARCHAR2,
198: x_msg_count OUT NOCOPY NUMBER,
191:
192: PROCEDURE Delete_Act_List(
193: p_api_version_number IN NUMBER,
194: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
195: p_commit IN VARCHAR2 := FND_API.G_FALSE,
196: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
197: x_return_status OUT NOCOPY VARCHAR2,
198: x_msg_count OUT NOCOPY NUMBER,
199: x_msg_data OUT NOCOPY VARCHAR2,
192: PROCEDURE Delete_Act_List(
193: p_api_version_number IN NUMBER,
194: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
195: p_commit IN VARCHAR2 := FND_API.G_FALSE,
196: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
197: x_return_status OUT NOCOPY VARCHAR2,
198: x_msg_count OUT NOCOPY NUMBER,
199: x_msg_data OUT NOCOPY VARCHAR2,
200: p_act_list_header_id IN NUMBER,
213: -- Parameters
214: --
215: -- IN
216: -- p_api_version_number IN NUMBER Required
217: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
218: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
219: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
220: -- p_act_list_rec IN act_list_rec_type Required
221: --
214: --
215: -- IN
216: -- p_api_version_number IN NUMBER Required
217: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
218: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
219: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
220: -- p_act_list_rec IN act_list_rec_type Required
221: --
222: -- OUT
215: -- IN
216: -- p_api_version_number IN NUMBER Required
217: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
218: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
219: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
220: -- p_act_list_rec IN act_list_rec_type Required
221: --
222: -- OUT
223: -- x_return_status OUT VARCHAR2
232: --
233:
234: PROCEDURE Lock_Act_List(
235: p_api_version_number IN NUMBER,
236: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
237:
238: x_return_status OUT NOCOPY VARCHAR2,
239: x_msg_count OUT NOCOPY NUMBER,
240: x_msg_data OUT NOCOPY VARCHAR2,
256: -- End of Comments
257:
258: PROCEDURE Validate_act_list(
259: p_api_version_number IN NUMBER,
260: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
261: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
262: p_act_list_rec IN act_list_rec_type,
263: x_return_status OUT NOCOPY VARCHAR2,
264: x_msg_count OUT NOCOPY NUMBER,
257:
258: PROCEDURE Validate_act_list(
259: p_api_version_number IN NUMBER,
260: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
261: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
262: p_act_list_rec IN act_list_rec_type,
263: x_return_status OUT NOCOPY VARCHAR2,
264: x_msg_count OUT NOCOPY NUMBER,
265: x_msg_data OUT NOCOPY VARCHAR2
294: -- End of Comments
295:
296: PROCEDURE Validate_act_list_rec(
297: p_api_version_number IN NUMBER,
298: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
299: x_return_status OUT NOCOPY VARCHAR2,
300: x_msg_count OUT NOCOPY NUMBER,
301: x_msg_data OUT NOCOPY VARCHAR2,
302: p_act_list_rec IN act_list_rec_type
303: );
304:
305: PROCEDURE generate_target_group_list
306: ( p_api_version IN NUMBER,
307: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
308: p_commit IN VARCHAR2 := FND_API.G_FALSE,
309: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
310: p_list_used_by in VARCHAR2,
311: p_list_used_by_id in NUMBER,
304:
305: PROCEDURE generate_target_group_list
306: ( p_api_version IN NUMBER,
307: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
308: p_commit IN VARCHAR2 := FND_API.G_FALSE,
309: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
310: p_list_used_by in VARCHAR2,
311: p_list_used_by_id in NUMBER,
312: x_return_status OUT NOCOPY VARCHAR2,
305: PROCEDURE generate_target_group_list
306: ( p_api_version IN NUMBER,
307: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
308: p_commit IN VARCHAR2 := FND_API.G_FALSE,
309: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
310: p_list_used_by in VARCHAR2,
311: p_list_used_by_id in NUMBER,
312: x_return_status OUT NOCOPY VARCHAR2,
313: x_msg_count OUT NOCOPY NUMBER,
314: x_msg_data OUT NOCOPY VARCHAR2
315: ) ;
316: PROCEDURE generate_target_group_list_old
317: ( p_api_version IN NUMBER,
318: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
319: p_commit IN VARCHAR2 := FND_API.G_FALSE,
320: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
321: p_list_used_by in VARCHAR2,
322: p_list_used_by_id in NUMBER,
315: ) ;
316: PROCEDURE generate_target_group_list_old
317: ( p_api_version IN NUMBER,
318: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
319: p_commit IN VARCHAR2 := FND_API.G_FALSE,
320: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
321: p_list_used_by in VARCHAR2,
322: p_list_used_by_id in NUMBER,
323: x_return_status OUT NOCOPY VARCHAR2,
316: PROCEDURE generate_target_group_list_old
317: ( p_api_version IN NUMBER,
318: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
319: p_commit IN VARCHAR2 := FND_API.G_FALSE,
320: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
321: p_list_used_by in VARCHAR2,
322: p_list_used_by_id in NUMBER,
323: x_return_status OUT NOCOPY VARCHAR2,
324: x_msg_count OUT NOCOPY NUMBER,
327:
328:
329: PROCEDURE create_target_group_list
330: ( p_api_version IN NUMBER,
331: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
332: p_commit IN VARCHAR2 := FND_API.G_FALSE,
333: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
334: p_list_used_by_name in VARCHAR2,
335: p_list_used_by in VARCHAR2,
328:
329: PROCEDURE create_target_group_list
330: ( p_api_version IN NUMBER,
331: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
332: p_commit IN VARCHAR2 := FND_API.G_FALSE,
333: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
334: p_list_used_by_name in VARCHAR2,
335: p_list_used_by in VARCHAR2,
336: p_list_used_by_id in NUMBER,
329: PROCEDURE create_target_group_list
330: ( p_api_version IN NUMBER,
331: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
332: p_commit IN VARCHAR2 := FND_API.G_FALSE,
333: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
334: p_list_used_by_name in VARCHAR2,
335: p_list_used_by in VARCHAR2,
336: p_list_used_by_id in NUMBER,
337: p_list_type in VARCHAR2 := 'TARGET' ,