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_PVT dependencies on PA_ACTION_SETS

Line 1: PACKAGE pa_action_sets_pvt AUTHID CURRENT_USER AS

1: PACKAGE pa_action_sets_pvt AUTHID CURRENT_USER AS
2: /*$Header: PARASPVS.pls 120.1 2005/08/19 16:48:26 mwasowic noship $*/
3: --
4:
5: g_line_number_msg_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 10: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE

6: g_info_msg_tbl SYSTEm.pa_varchar2_2000_tbl_type := SYSTEm.pa_varchar2_2000_tbl_type();
7:
8: PROCEDURE create_action_set
9: (p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE
10: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE
11: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
12: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
13: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := NULL
14: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := NULL

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

7:
8: PROCEDURE create_action_set
9: (p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE
10: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE
11: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
12: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
13: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := NULL
14: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := NULL
15: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := NULL

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

8: PROCEDURE create_action_set
9: (p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE
10: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE
11: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
12: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
13: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := NULL
14: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := NULL
15: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := NULL
16: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := NULL

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

9: (p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE
10: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE
11: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
12: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
13: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := NULL
14: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := NULL
15: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := NULL
16: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := NULL
17: ,p_status_code IN pa_action_sets.status_code%TYPE := NULL

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

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

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

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

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

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

Line 17: ,p_status_code IN pa_action_sets.status_code%TYPE := NULL

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

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

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

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

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

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

16: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := NULL
17: ,p_status_code IN pa_action_sets.status_code%TYPE := NULL
18: ,p_description IN pa_action_sets.description%TYPE := NULL
19: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := NULL
20: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := NULL
21: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := NULL
22: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := NULL
23: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := NULL
24: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := NULL

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 40: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL

36: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
37: );
38:
39: PROCEDURE update_action_set
40: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
41: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
42: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := FND_API.G_MISS_CHAR
43: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
44: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE

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

37: );
38:
39: PROCEDURE update_action_set
40: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
41: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
42: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := FND_API.G_MISS_CHAR
43: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
44: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
45: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR

Line 42: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := FND_API.G_MISS_CHAR

38:
39: PROCEDURE update_action_set
40: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
41: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
42: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := FND_API.G_MISS_CHAR
43: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
44: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
45: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
46: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR

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

39: PROCEDURE update_action_set
40: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
41: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
42: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := FND_API.G_MISS_CHAR
43: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
44: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
45: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
46: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
47: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR

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

40: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
41: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
42: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := FND_API.G_MISS_CHAR
43: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
44: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
45: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
46: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
47: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
48: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE

Line 45: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR

41: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
42: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := FND_API.G_MISS_CHAR
43: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
44: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
45: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
46: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
47: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
48: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
49: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR

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

42: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := FND_API.G_MISS_CHAR
43: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
44: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
45: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
46: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
47: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
48: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
49: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
50: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR

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

43: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
44: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
45: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
46: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
47: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
48: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
49: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
50: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
51: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR

Line 48: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE

44: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
45: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
46: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
47: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
48: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
49: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
50: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
51: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
52: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR

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

45: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
46: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
47: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
48: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
49: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
50: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
51: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
52: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
53: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 69: (p_action_set_id IN pa_action_sets.action_set_id%TYPE

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

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

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

Line 74: (p_action_set_id IN pa_action_sets.action_set_id%TYPE

70: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
71: ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
72:
73: PROCEDURE create_action_set_line
74: (p_action_set_id IN pa_action_sets.action_set_id%TYPE
75: ,p_use_def_description_flag IN VARCHAR2 := 'Y'
76: ,p_description IN pa_action_set_lines.description%TYPE := NULL
77: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := NULL
78: ,p_action_code IN pa_action_set_lines.action_code%TYPE

Line 115: (p_action_set_line_id IN pa_action_sets.action_set_id%TYPE

111: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
112: );
113:
114: PROCEDURE delete_action_set_line
115: (p_action_set_line_id IN pa_action_sets.action_set_id%TYPE
116: ,p_record_version_number IN pa_action_set_lines.record_version_number%TYPE
117: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
118: );
119:

Line 125: p_object_type IN pa_action_sets.object_type%TYPE,

121: p_reason IN VARCHAR2) RETURN pa_action_set_utils.insert_audit_lines_tbl_type;
122:
123: PROCEDURE bulk_insert_audit_lines(p_audit_lines_tbl IN pa_action_set_utils.insert_audit_lines_tbl_type,
124: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE,
125: p_object_type IN pa_action_sets.object_type%TYPE,
126: p_object_id IN pa_action_sets.object_id%TYPE,
127: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE,
128: p_status_code IN VARCHAR2,
129: x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 126: p_object_id IN pa_action_sets.object_id%TYPE,

122:
123: PROCEDURE bulk_insert_audit_lines(p_audit_lines_tbl IN pa_action_set_utils.insert_audit_lines_tbl_type,
124: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE,
125: p_object_type IN pa_action_sets.object_type%TYPE,
126: p_object_id IN pa_action_sets.object_id%TYPE,
127: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE,
128: p_status_code IN VARCHAR2,
129: x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
130:

Line 127: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE,

123: PROCEDURE bulk_insert_audit_lines(p_audit_lines_tbl IN pa_action_set_utils.insert_audit_lines_tbl_type,
124: p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE,
125: p_object_type IN pa_action_sets.object_type%TYPE,
126: p_object_id IN pa_action_sets.object_id%TYPE,
127: p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE,
128: p_status_code IN VARCHAR2,
129: x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
130:
131: PROCEDURE perform_action_set_line

Line 133: ,p_action_set_line_id IN pa_action_sets.action_set_id%TYPE

129: x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
130:
131: PROCEDURE perform_action_set_line
132: (p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE
133: ,p_action_set_line_id IN pa_action_sets.action_set_id%TYPE
134: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
135: );
136:
137: PROCEDURE bulk_update_line_number(p_action_set_line_id_tbl IN pa_action_set_utils.number_tbl_type,