1: PACKAGE pa_action_sets_pub AUTHID CURRENT_USER AS
2: /*$Header: PARASPUS.pls 120.1 2005/08/19 16:48:17 mwasowic noship $*/
3: --
4: PROCEDURE create_action_set
5: (p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE
2: /*$Header: PARASPUS.pls 120.1 2005/08/19 16:48:17 mwasowic noship $*/
3: --
4: PROCEDURE create_action_set
5: (p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE
6: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE
7: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
8: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
9: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := NULL
10: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := NULL
3: --
4: PROCEDURE create_action_set
5: (p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE
6: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE
7: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
8: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
9: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := NULL
10: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := NULL
11: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := NULL
4: PROCEDURE create_action_set
5: (p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE
6: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE
7: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
8: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
9: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := NULL
10: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := NULL
11: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := NULL
12: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := NULL
5: (p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE
6: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE
7: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
8: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
9: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := NULL
10: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := NULL
11: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := NULL
12: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := NULL
13: ,p_status_code IN pa_action_sets.status_code%TYPE := NULL
6: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE
7: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
8: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
9: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := NULL
10: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := NULL
11: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := NULL
12: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := NULL
13: ,p_status_code IN pa_action_sets.status_code%TYPE := NULL
14: ,p_description IN pa_action_sets.description%TYPE := NULL
7: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
8: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
9: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := NULL
10: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := NULL
11: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := NULL
12: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := NULL
13: ,p_status_code IN pa_action_sets.status_code%TYPE := NULL
14: ,p_description IN pa_action_sets.description%TYPE := NULL
15: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := NULL
8: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
9: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := NULL
10: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := NULL
11: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := NULL
12: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := NULL
13: ,p_status_code IN pa_action_sets.status_code%TYPE := NULL
14: ,p_description IN pa_action_sets.description%TYPE := NULL
15: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := NULL
16: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := NULL
9: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := NULL
10: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := NULL
11: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := NULL
12: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := NULL
13: ,p_status_code IN pa_action_sets.status_code%TYPE := NULL
14: ,p_description IN pa_action_sets.description%TYPE := NULL
15: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := NULL
16: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := NULL
17: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := NULL
10: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := NULL
11: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := NULL
12: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := NULL
13: ,p_status_code IN pa_action_sets.status_code%TYPE := NULL
14: ,p_description IN pa_action_sets.description%TYPE := NULL
15: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := NULL
16: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := NULL
17: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := NULL
18: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := NULL
11: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := NULL
12: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := NULL
13: ,p_status_code IN pa_action_sets.status_code%TYPE := NULL
14: ,p_description IN pa_action_sets.description%TYPE := NULL
15: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := NULL
16: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := NULL
17: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := NULL
18: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := NULL
19: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := NULL
12: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := NULL
13: ,p_status_code IN pa_action_sets.status_code%TYPE := NULL
14: ,p_description IN pa_action_sets.description%TYPE := NULL
15: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := NULL
16: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := NULL
17: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := NULL
18: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := NULL
19: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := NULL
20: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := NULL
13: ,p_status_code IN pa_action_sets.status_code%TYPE := NULL
14: ,p_description IN pa_action_sets.description%TYPE := NULL
15: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := NULL
16: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := NULL
17: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := NULL
18: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := NULL
19: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := NULL
20: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := NULL
21: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := NULL
14: ,p_description IN pa_action_sets.description%TYPE := NULL
15: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := NULL
16: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := NULL
17: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := NULL
18: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := NULL
19: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := NULL
20: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := NULL
21: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := NULL
22: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := NULL
15: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := NULL
16: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := NULL
17: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := NULL
18: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := NULL
19: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := NULL
20: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := NULL
21: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := NULL
22: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := NULL
23: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := NULL
16: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := NULL
17: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := NULL
18: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := NULL
19: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := NULL
20: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := NULL
21: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := NULL
22: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := NULL
23: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := NULL
24: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := NULL
17: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := NULL
18: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := NULL
19: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := NULL
20: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := NULL
21: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := NULL
22: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := NULL
23: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := NULL
24: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := NULL
25: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := NULL
18: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := NULL
19: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := NULL
20: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := NULL
21: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := NULL
22: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := NULL
23: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := NULL
24: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := NULL
25: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := NULL
26: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := NULL
19: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := NULL
20: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := NULL
21: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := NULL
22: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := NULL
23: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := NULL
24: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := NULL
25: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := NULL
26: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := NULL
27: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := NULL
20: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := NULL
21: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := NULL
22: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := NULL
23: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := NULL
24: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := NULL
25: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := NULL
26: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := NULL
27: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := NULL
28: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := NULL
21: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := NULL
22: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := NULL
23: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := NULL
24: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := NULL
25: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := NULL
26: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := NULL
27: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := NULL
28: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := NULL
29: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := NULL
22: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := NULL
23: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := NULL
24: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := NULL
25: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := NULL
26: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := NULL
27: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := NULL
28: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := NULL
29: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := NULL
30: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := NULL
23: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := NULL
24: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := NULL
25: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := NULL
26: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := NULL
27: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := NULL
28: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := NULL
29: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := NULL
30: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := NULL
31: ,p_api_version IN NUMBER := 1.0
24: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := NULL
25: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := NULL
26: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := NULL
27: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := NULL
28: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := NULL
29: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := NULL
30: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := NULL
31: ,p_api_version IN NUMBER := 1.0
32: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
25: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := NULL
26: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := NULL
27: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := NULL
28: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := NULL
29: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := NULL
30: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := NULL
31: ,p_api_version IN NUMBER := 1.0
32: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
33: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
26: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := NULL
27: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := NULL
28: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := NULL
29: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := NULL
30: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := NULL
31: ,p_api_version IN NUMBER := 1.0
32: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
33: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
34: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
38: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
39: );
40:
41: PROCEDURE update_action_set
42: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
43: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
44: ,p_object_type IN pa_action_sets.object_type%TYPE := FND_API.G_MISS_CHAR
45: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := FND_API.G_MISS_CHAR
46: ,p_object_id IN pa_action_sets.object_id%TYPE := FND_API.G_MISS_NUM
39: );
40:
41: PROCEDURE update_action_set
42: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
43: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
44: ,p_object_type IN pa_action_sets.object_type%TYPE := FND_API.G_MISS_CHAR
45: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := FND_API.G_MISS_CHAR
46: ,p_object_id IN pa_action_sets.object_id%TYPE := FND_API.G_MISS_NUM
47: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
40:
41: PROCEDURE update_action_set
42: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
43: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
44: ,p_object_type IN pa_action_sets.object_type%TYPE := FND_API.G_MISS_CHAR
45: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := FND_API.G_MISS_CHAR
46: ,p_object_id IN pa_action_sets.object_id%TYPE := FND_API.G_MISS_NUM
47: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
48: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
41: PROCEDURE update_action_set
42: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
43: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
44: ,p_object_type IN pa_action_sets.object_type%TYPE := FND_API.G_MISS_CHAR
45: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := FND_API.G_MISS_CHAR
46: ,p_object_id IN pa_action_sets.object_id%TYPE := FND_API.G_MISS_NUM
47: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
48: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
49: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
42: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
43: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
44: ,p_object_type IN pa_action_sets.object_type%TYPE := FND_API.G_MISS_CHAR
45: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := FND_API.G_MISS_CHAR
46: ,p_object_id IN pa_action_sets.object_id%TYPE := FND_API.G_MISS_NUM
47: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
48: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
49: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
50: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
43: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
44: ,p_object_type IN pa_action_sets.object_type%TYPE := FND_API.G_MISS_CHAR
45: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := FND_API.G_MISS_CHAR
46: ,p_object_id IN pa_action_sets.object_id%TYPE := FND_API.G_MISS_NUM
47: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
48: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
49: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
50: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
51: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
44: ,p_object_type IN pa_action_sets.object_type%TYPE := FND_API.G_MISS_CHAR
45: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := FND_API.G_MISS_CHAR
46: ,p_object_id IN pa_action_sets.object_id%TYPE := FND_API.G_MISS_NUM
47: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
48: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
49: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
50: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
51: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
52: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
45: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := FND_API.G_MISS_CHAR
46: ,p_object_id IN pa_action_sets.object_id%TYPE := FND_API.G_MISS_NUM
47: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
48: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
49: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
50: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
51: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
52: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
53: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
46: ,p_object_id IN pa_action_sets.object_id%TYPE := FND_API.G_MISS_NUM
47: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
48: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
49: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
50: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
51: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
52: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
53: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
54: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
47: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
48: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
49: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
50: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
51: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
52: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
53: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
54: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
55: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
48: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
49: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
50: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
51: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
52: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
53: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
54: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
55: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
56: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
49: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
50: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
51: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
52: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
53: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
54: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
55: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
56: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
57: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
50: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
51: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
52: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
53: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
54: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
55: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
56: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
57: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
58: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
51: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
52: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
53: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
54: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
55: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
56: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
57: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
58: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
59: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
52: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
53: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
54: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
55: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
56: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
57: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
58: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
59: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
60: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
53: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
54: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
55: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
56: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
57: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
58: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
59: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
60: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
61: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
54: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
55: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
56: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
57: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
58: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
59: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
60: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
61: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
62: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
55: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
56: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
57: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
58: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
59: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
60: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
61: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
62: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
63: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
56: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
57: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
58: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
59: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
60: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
61: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
62: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
63: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
64: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
57: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
58: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
59: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
60: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
61: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
62: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
63: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
64: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
65: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
58: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
59: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
60: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
61: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
62: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
63: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
64: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
65: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
66: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
59: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
60: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
61: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
62: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
63: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
64: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
65: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
66: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
67: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
60: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
61: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
62: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
63: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
64: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
65: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
66: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
67: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
68: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR
61: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
62: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
63: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
64: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
65: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
66: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
67: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
68: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR
69: ,p_api_version IN NUMBER := 1.0
62: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
63: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
64: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
65: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
66: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
67: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
68: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR
69: ,p_api_version IN NUMBER := 1.0
70: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
63: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
64: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
65: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
66: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
67: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
68: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR
69: ,p_api_version IN NUMBER := 1.0
70: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
71: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
64: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
65: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
66: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
67: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
68: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR
69: ,p_api_version IN NUMBER := 1.0
70: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
71: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
72: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
75: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
76: );
77:
78: PROCEDURE delete_action_set
79: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
80: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := NULL
81: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
82: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
83: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
76: );
77:
78: PROCEDURE delete_action_set
79: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
80: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := NULL
81: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
82: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
83: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
84: ,p_api_version IN NUMBER := 1.0
77:
78: PROCEDURE delete_action_set
79: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
80: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := NULL
81: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
82: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
83: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
84: ,p_api_version IN NUMBER := 1.0
85: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
78: PROCEDURE delete_action_set
79: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
80: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := NULL
81: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
82: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
83: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
84: ,p_api_version IN NUMBER := 1.0
85: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
86: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
79: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
80: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := NULL
81: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
82: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
83: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
84: ,p_api_version IN NUMBER := 1.0
85: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
86: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
87: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
90: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
91: );
92:
93: PROCEDURE create_action_set_line
94: (p_action_set_id IN pa_action_sets.action_set_id%TYPE
95: ,p_use_def_description_flag IN VARCHAR2 := 'Y'
96: ,p_description IN pa_action_set_lines.description%TYPE := NULL
97: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := NULL
98: ,p_action_code IN pa_action_set_lines.action_code%TYPE
145: );
146:
147:
148: PROCEDURE delete_action_set_line
149: (p_action_set_line_id IN pa_action_sets.action_set_id%TYPE := NULL
150: ,p_record_version_number IN pa_action_set_lines.record_version_number%TYPE := NULL
151: ,p_api_version IN NUMBER := 1.0
152: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
153: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
157: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
158: );
159:
160: PROCEDURE apply_action_set
161: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
162: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
163: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
164: ,p_perform_action_set_flag IN VARCHAR2 := 'N'
165: ,p_api_version IN NUMBER := 1.0
158: );
159:
160: PROCEDURE apply_action_set
161: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
162: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
163: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
164: ,p_perform_action_set_flag IN VARCHAR2 := 'N'
165: ,p_api_version IN NUMBER := 1.0
166: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
159:
160: PROCEDURE apply_action_set
161: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
162: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
163: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
164: ,p_perform_action_set_flag IN VARCHAR2 := 'N'
165: ,p_api_version IN NUMBER := 1.0
166: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
167: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
172: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
173: );
174:
175: PROCEDURE replace_action_set
176: (p_current_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
177: ,p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE := NULL
178: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
179: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
180: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
174:
175: PROCEDURE replace_action_set
176: (p_current_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
177: ,p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE := NULL
178: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
179: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
180: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
181: ,p_new_action_set_id IN pa_action_sets.action_set_id%TYPE
182: ,p_api_version IN NUMBER := 1.0
175: PROCEDURE replace_action_set
176: (p_current_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
177: ,p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE := NULL
178: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
179: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
180: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
181: ,p_new_action_set_id IN pa_action_sets.action_set_id%TYPE
182: ,p_api_version IN NUMBER := 1.0
183: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
176: (p_current_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
177: ,p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE := NULL
178: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
179: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
180: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
181: ,p_new_action_set_id IN pa_action_sets.action_set_id%TYPE
182: ,p_api_version IN NUMBER := 1.0
183: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
184: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
177: ,p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE := NULL
178: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
179: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
180: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
181: ,p_new_action_set_id IN pa_action_sets.action_set_id%TYPE
182: ,p_api_version IN NUMBER := 1.0
183: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
184: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
185: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
189: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
190: );
191:
192: PROCEDURE perform_single_action_set
193: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
194: ,p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE := NULL
195: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
196: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
197: ,p_api_version IN NUMBER := 1.0
191:
192: PROCEDURE perform_single_action_set
193: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
194: ,p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE := NULL
195: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
196: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
197: ,p_api_version IN NUMBER := 1.0
198: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
199: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
192: PROCEDURE perform_single_action_set
193: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
194: ,p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE := NULL
195: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
196: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
197: ,p_api_version IN NUMBER := 1.0
198: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
199: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
200: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
210: x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
211:
212:
213: PROCEDURE create_line_single_cond
214: (p_action_set_id IN pa_action_sets.action_set_id%TYPE
215: ,p_use_def_description_flag IN VARCHAR2 := 'Y'
216: ,p_action_description IN pa_action_set_lines.description%TYPE := NULL
217: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := NULL
218: ,p_action_code IN pa_action_set_lines.action_code%TYPE
248: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
249: );
250:
251: PROCEDURE update_line_single_cond
252: (p_action_set_line_id IN pa_action_sets.action_set_id%TYPE
253: ,p_record_version_number IN NUMBER := NULL
254: ,p_action_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
255: ,p_action_code IN pa_action_set_lines.action_code%TYPE
256: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR