eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_ACTION_SETS_PKG dependencies on PA_ACTION_SETS

Line 1: PACKAGE pa_action_sets_pkg AS

1: PACKAGE pa_action_sets_pkg AS
2: /*$Header: PARASPKS.pls 120.1 2005/08/19 16:48:09 mwasowic noship $*/
3: --
4:
5: PROCEDURE insert_row

Line 7: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE

3: --
4:
5: PROCEDURE insert_row
6: (p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE
7: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE
8: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
9: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
10: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := NULL
11: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := NULL

Line 8: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL

4:
5: PROCEDURE insert_row
6: (p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE
7: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE
8: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
9: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
10: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := NULL
11: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := NULL
12: ,p_description IN pa_action_sets.description%TYPE := NULL

Line 9: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL

5: PROCEDURE insert_row
6: (p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE
7: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE
8: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
9: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
10: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := NULL
11: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := NULL
12: ,p_description IN pa_action_sets.description%TYPE := NULL
13: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := NULL

Line 10: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := NULL

6: (p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE
7: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE
8: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
9: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
10: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := NULL
11: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := NULL
12: ,p_description IN pa_action_sets.description%TYPE := NULL
13: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := NULL
14: ,p_status_code IN pa_action_sets.status_code%TYPE

Line 11: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := NULL

7: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE
8: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
9: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
10: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := NULL
11: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := NULL
12: ,p_description IN pa_action_sets.description%TYPE := NULL
13: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := NULL
14: ,p_status_code IN pa_action_sets.status_code%TYPE
15: ,p_actual_start_date IN pa_action_sets.actual_start_date%TYPE := NULL

Line 12: ,p_description IN pa_action_sets.description%TYPE := NULL

8: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
9: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
10: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := NULL
11: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := NULL
12: ,p_description IN pa_action_sets.description%TYPE := NULL
13: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := NULL
14: ,p_status_code IN pa_action_sets.status_code%TYPE
15: ,p_actual_start_date IN pa_action_sets.actual_start_date%TYPE := NULL
16: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := NULL

Line 13: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := NULL

9: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
10: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := NULL
11: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := NULL
12: ,p_description IN pa_action_sets.description%TYPE := NULL
13: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := NULL
14: ,p_status_code IN pa_action_sets.status_code%TYPE
15: ,p_actual_start_date IN pa_action_sets.actual_start_date%TYPE := NULL
16: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := NULL
17: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := NULL

Line 14: ,p_status_code IN pa_action_sets.status_code%TYPE

10: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := NULL
11: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := NULL
12: ,p_description IN pa_action_sets.description%TYPE := NULL
13: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := NULL
14: ,p_status_code IN pa_action_sets.status_code%TYPE
15: ,p_actual_start_date IN pa_action_sets.actual_start_date%TYPE := NULL
16: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := NULL
17: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := NULL
18: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := NULL

Line 15: ,p_actual_start_date IN pa_action_sets.actual_start_date%TYPE := NULL

11: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := NULL
12: ,p_description IN pa_action_sets.description%TYPE := NULL
13: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := NULL
14: ,p_status_code IN pa_action_sets.status_code%TYPE
15: ,p_actual_start_date IN pa_action_sets.actual_start_date%TYPE := NULL
16: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := NULL
17: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := NULL
18: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := NULL
19: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := NULL

Line 16: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := NULL

12: ,p_description IN pa_action_sets.description%TYPE := NULL
13: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := NULL
14: ,p_status_code IN pa_action_sets.status_code%TYPE
15: ,p_actual_start_date IN pa_action_sets.actual_start_date%TYPE := NULL
16: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := NULL
17: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := NULL
18: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := NULL
19: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := NULL
20: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := NULL

Line 17: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := NULL

13: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := NULL
14: ,p_status_code IN pa_action_sets.status_code%TYPE
15: ,p_actual_start_date IN pa_action_sets.actual_start_date%TYPE := NULL
16: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := NULL
17: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := NULL
18: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := NULL
19: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := NULL
20: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := NULL
21: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := NULL

Line 18: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := NULL

14: ,p_status_code IN pa_action_sets.status_code%TYPE
15: ,p_actual_start_date IN pa_action_sets.actual_start_date%TYPE := NULL
16: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := NULL
17: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := NULL
18: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := NULL
19: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := NULL
20: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := NULL
21: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := NULL
22: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := NULL

Line 19: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := NULL

15: ,p_actual_start_date IN pa_action_sets.actual_start_date%TYPE := NULL
16: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := NULL
17: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := NULL
18: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := NULL
19: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := NULL
20: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := NULL
21: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := NULL
22: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := NULL
23: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := NULL

Line 20: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := NULL

16: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := NULL
17: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := NULL
18: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := NULL
19: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := NULL
20: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := NULL
21: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := NULL
22: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := NULL
23: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := NULL
24: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := NULL

Line 21: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := NULL

17: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := NULL
18: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := NULL
19: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := NULL
20: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := NULL
21: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := NULL
22: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := NULL
23: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := NULL
24: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := NULL
25: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := NULL

Line 22: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := NULL

18: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := NULL
19: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := NULL
20: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := NULL
21: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := NULL
22: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := NULL
23: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := NULL
24: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := NULL
25: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := NULL
26: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := NULL

Line 23: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := NULL

19: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := NULL
20: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := NULL
21: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := NULL
22: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := NULL
23: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := NULL
24: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := NULL
25: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := NULL
26: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := NULL
27: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := NULL

Line 24: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := NULL

20: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := NULL
21: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := NULL
22: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := NULL
23: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := NULL
24: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := NULL
25: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := NULL
26: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := NULL
27: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := NULL
28: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := NULL

Line 25: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := NULL

21: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := NULL
22: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := NULL
23: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := NULL
24: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := NULL
25: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := NULL
26: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := NULL
27: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := NULL
28: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := NULL
29: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := NULL

Line 26: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := NULL

22: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := NULL
23: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := NULL
24: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := NULL
25: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := NULL
26: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := NULL
27: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := NULL
28: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := NULL
29: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := NULL
30: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := NULL

Line 27: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := NULL

23: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := NULL
24: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := NULL
25: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := NULL
26: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := NULL
27: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := NULL
28: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := NULL
29: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := NULL
30: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := NULL
31: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := NULL

Line 28: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := NULL

24: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := NULL
25: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := NULL
26: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := NULL
27: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := NULL
28: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := NULL
29: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := NULL
30: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := NULL
31: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := NULL
32: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := NULL

Line 29: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := NULL

25: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := NULL
26: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := NULL
27: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := NULL
28: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := NULL
29: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := NULL
30: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := NULL
31: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := NULL
32: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := NULL
33: ,x_action_set_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 30: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := NULL

26: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := NULL
27: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := NULL
28: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := NULL
29: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := NULL
30: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := NULL
31: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := NULL
32: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := NULL
33: ,x_action_set_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
34: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 31: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := NULL

27: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := NULL
28: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := NULL
29: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := NULL
30: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := NULL
31: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := NULL
32: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := NULL
33: ,x_action_set_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
34: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
35: );

Line 32: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := NULL

28: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := NULL
29: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := NULL
30: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := NULL
31: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := NULL
32: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := NULL
33: ,x_action_set_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
34: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
35: );
36:

Line 39: (p_action_set_id IN pa_action_sets.action_set_id%TYPE

35: );
36:
37:
38: PROCEDURE update_row
39: (p_action_set_id IN pa_action_sets.action_set_id%TYPE
40: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
41: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
42: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
43: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR

Line 40: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR

36:
37:
38: PROCEDURE update_row
39: (p_action_set_id IN pa_action_sets.action_set_id%TYPE
40: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
41: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
42: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
43: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
44: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := FND_API.G_MISS_NUM

Line 41: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE

37:
38: PROCEDURE update_row
39: (p_action_set_id IN pa_action_sets.action_set_id%TYPE
40: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
41: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
42: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
43: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
44: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := FND_API.G_MISS_NUM
45: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR

Line 42: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE

38: PROCEDURE update_row
39: (p_action_set_id IN pa_action_sets.action_set_id%TYPE
40: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
41: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
42: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
43: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
44: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := FND_API.G_MISS_NUM
45: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
46: ,p_actual_start_date IN pa_action_sets.actual_start_date%TYPE := FND_API.G_MISS_DATE

Line 43: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR

39: (p_action_set_id IN pa_action_sets.action_set_id%TYPE
40: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
41: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
42: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
43: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
44: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := FND_API.G_MISS_NUM
45: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
46: ,p_actual_start_date IN pa_action_sets.actual_start_date%TYPE := FND_API.G_MISS_DATE
47: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL

Line 44: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := FND_API.G_MISS_NUM

40: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
41: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
42: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
43: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
44: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := FND_API.G_MISS_NUM
45: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
46: ,p_actual_start_date IN pa_action_sets.actual_start_date%TYPE := FND_API.G_MISS_DATE
47: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
48: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR

Line 45: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR

41: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
42: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
43: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
44: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := FND_API.G_MISS_NUM
45: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
46: ,p_actual_start_date IN pa_action_sets.actual_start_date%TYPE := FND_API.G_MISS_DATE
47: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
48: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
49: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR

Line 46: ,p_actual_start_date IN pa_action_sets.actual_start_date%TYPE := FND_API.G_MISS_DATE

42: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
43: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
44: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := FND_API.G_MISS_NUM
45: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
46: ,p_actual_start_date IN pa_action_sets.actual_start_date%TYPE := FND_API.G_MISS_DATE
47: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
48: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
49: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
50: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR

Line 47: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL

43: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
44: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := FND_API.G_MISS_NUM
45: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
46: ,p_actual_start_date IN pa_action_sets.actual_start_date%TYPE := FND_API.G_MISS_DATE
47: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
48: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
49: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
50: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
51: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR

Line 48: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR

44: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := FND_API.G_MISS_NUM
45: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
46: ,p_actual_start_date IN pa_action_sets.actual_start_date%TYPE := FND_API.G_MISS_DATE
47: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
48: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
49: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
50: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
51: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
52: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR

Line 49: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR

45: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
46: ,p_actual_start_date IN pa_action_sets.actual_start_date%TYPE := FND_API.G_MISS_DATE
47: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
48: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
49: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
50: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
51: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
52: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
53: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR

Line 50: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR

46: ,p_actual_start_date IN pa_action_sets.actual_start_date%TYPE := FND_API.G_MISS_DATE
47: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
48: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
49: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
50: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
51: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
52: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
53: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
54: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR

Line 51: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR

47: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
48: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
49: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
50: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
51: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
52: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
53: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
54: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
55: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR

Line 52: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR

48: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
49: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
50: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
51: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
52: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
53: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
54: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
55: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
56: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR

Line 53: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR

49: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
50: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
51: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
52: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
53: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
54: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
55: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
56: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
57: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR

Line 54: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR

50: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
51: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
52: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
53: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
54: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
55: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
56: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
57: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
58: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR

Line 55: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR

51: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
52: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
53: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
54: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
55: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
56: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
57: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
58: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
59: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR

Line 56: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR

52: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
53: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
54: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
55: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
56: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
57: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
58: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
59: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
60: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR

Line 57: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR

53: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
54: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
55: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
56: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
57: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
58: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
59: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
60: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
61: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR

Line 58: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR

54: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
55: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
56: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
57: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
58: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
59: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
60: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
61: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
62: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR

Line 59: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR

55: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
56: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
57: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
58: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
59: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
60: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
61: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
62: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
63: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR

Line 60: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR

56: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
57: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
58: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
59: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
60: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
61: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
62: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
63: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR
64: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 61: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR

57: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
58: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
59: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
60: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
61: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
62: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
63: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR
64: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
65: );

Line 62: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR

58: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
59: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
60: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
61: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
62: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
63: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR
64: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
65: );
66:

Line 63: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR

59: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
60: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
61: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
62: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
63: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR
64: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
65: );
66:
67:

Line 69: ( p_action_set_id IN pa_action_sets.action_set_id%TYPE

65: );
66:
67:
68: PROCEDURE Delete_Row
69: ( p_action_set_id IN pa_action_sets.action_set_id%TYPE
70: ,p_record_version_number IN NUMBER := NULL
71: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
72: );
73: