1: PACKAGE pa_action_set_lines_pkg AS
2: /*$Header: PARASLKS.pls 120.1 2005/08/19 16:48:03 mwasowic noship $*/
3: --
4:
5: PROCEDURE insert_row
2: /*$Header: PARASLKS.pls 120.1 2005/08/19 16:48:03 mwasowic noship $*/
3: --
4:
5: PROCEDURE insert_row
6: (p_action_set_id IN pa_action_set_lines.action_set_id%TYPE
7: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := NULL
8: ,p_status_code IN pa_action_set_lines.status_code%TYPE
9: ,p_description IN pa_action_set_lines.description%TYPE := NULL
10: ,p_line_deleted_flag IN pa_action_set_lines.line_deleted_flag%TYPE :='N'
3: --
4:
5: PROCEDURE insert_row
6: (p_action_set_id IN pa_action_set_lines.action_set_id%TYPE
7: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := NULL
8: ,p_status_code IN pa_action_set_lines.status_code%TYPE
9: ,p_description IN pa_action_set_lines.description%TYPE := NULL
10: ,p_line_deleted_flag IN pa_action_set_lines.line_deleted_flag%TYPE :='N'
11: ,p_action_code IN pa_action_set_lines.action_code%TYPE
4:
5: PROCEDURE insert_row
6: (p_action_set_id IN pa_action_set_lines.action_set_id%TYPE
7: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := NULL
8: ,p_status_code IN pa_action_set_lines.status_code%TYPE
9: ,p_description IN pa_action_set_lines.description%TYPE := NULL
10: ,p_line_deleted_flag IN pa_action_set_lines.line_deleted_flag%TYPE :='N'
11: ,p_action_code IN pa_action_set_lines.action_code%TYPE
12: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := NULL
5: PROCEDURE insert_row
6: (p_action_set_id IN pa_action_set_lines.action_set_id%TYPE
7: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := NULL
8: ,p_status_code IN pa_action_set_lines.status_code%TYPE
9: ,p_description IN pa_action_set_lines.description%TYPE := NULL
10: ,p_line_deleted_flag IN pa_action_set_lines.line_deleted_flag%TYPE :='N'
11: ,p_action_code IN pa_action_set_lines.action_code%TYPE
12: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := NULL
13: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := NULL
6: (p_action_set_id IN pa_action_set_lines.action_set_id%TYPE
7: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := NULL
8: ,p_status_code IN pa_action_set_lines.status_code%TYPE
9: ,p_description IN pa_action_set_lines.description%TYPE := NULL
10: ,p_line_deleted_flag IN pa_action_set_lines.line_deleted_flag%TYPE :='N'
11: ,p_action_code IN pa_action_set_lines.action_code%TYPE
12: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := NULL
13: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := NULL
14: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := NULL
7: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := NULL
8: ,p_status_code IN pa_action_set_lines.status_code%TYPE
9: ,p_description IN pa_action_set_lines.description%TYPE := NULL
10: ,p_line_deleted_flag IN pa_action_set_lines.line_deleted_flag%TYPE :='N'
11: ,p_action_code IN pa_action_set_lines.action_code%TYPE
12: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := NULL
13: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := NULL
14: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := NULL
15: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := NULL
8: ,p_status_code IN pa_action_set_lines.status_code%TYPE
9: ,p_description IN pa_action_set_lines.description%TYPE := NULL
10: ,p_line_deleted_flag IN pa_action_set_lines.line_deleted_flag%TYPE :='N'
11: ,p_action_code IN pa_action_set_lines.action_code%TYPE
12: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := NULL
13: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := NULL
14: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := NULL
15: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := NULL
16: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := NULL
9: ,p_description IN pa_action_set_lines.description%TYPE := NULL
10: ,p_line_deleted_flag IN pa_action_set_lines.line_deleted_flag%TYPE :='N'
11: ,p_action_code IN pa_action_set_lines.action_code%TYPE
12: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := NULL
13: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := NULL
14: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := NULL
15: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := NULL
16: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := NULL
17: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := NULL
10: ,p_line_deleted_flag IN pa_action_set_lines.line_deleted_flag%TYPE :='N'
11: ,p_action_code IN pa_action_set_lines.action_code%TYPE
12: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := NULL
13: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := NULL
14: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := NULL
15: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := NULL
16: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := NULL
17: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := NULL
18: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := NULL
11: ,p_action_code IN pa_action_set_lines.action_code%TYPE
12: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := NULL
13: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := NULL
14: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := NULL
15: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := NULL
16: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := NULL
17: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := NULL
18: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := NULL
19: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := NULL
12: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := NULL
13: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := NULL
14: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := NULL
15: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := NULL
16: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := NULL
17: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := NULL
18: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := NULL
19: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := NULL
20: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := NULL
13: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := NULL
14: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := NULL
15: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := NULL
16: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := NULL
17: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := NULL
18: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := NULL
19: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := NULL
20: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := NULL
21: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := NULL
14: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := NULL
15: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := NULL
16: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := NULL
17: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := NULL
18: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := NULL
19: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := NULL
20: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := NULL
21: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := NULL
22: ,x_action_set_line_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
15: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := NULL
16: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := NULL
17: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := NULL
18: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := NULL
19: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := NULL
20: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := NULL
21: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := NULL
22: ,x_action_set_line_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
23: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
16: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := NULL
17: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := NULL
18: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := NULL
19: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := NULL
20: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := NULL
21: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := NULL
22: ,x_action_set_line_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
23: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
24: );
17: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := NULL
18: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := NULL
19: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := NULL
20: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := NULL
21: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := NULL
22: ,x_action_set_line_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
23: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
24: );
25:
24: );
25:
26:
27: PROCEDURE update_row
28: (p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
29: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := FND_API.G_MISS_NUM
30: ,p_record_version_number IN NUMBER := NULL
31: ,p_status_code IN pa_action_set_lines.status_code%TYPE := FND_API.G_MISS_CHAR
32: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
25:
26:
27: PROCEDURE update_row
28: (p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
29: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := FND_API.G_MISS_NUM
30: ,p_record_version_number IN NUMBER := NULL
31: ,p_status_code IN pa_action_set_lines.status_code%TYPE := FND_API.G_MISS_CHAR
32: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
33: ,p_line_deleted_flag IN pa_action_set_lines.line_deleted_flag%TYPE := FND_API.G_MISS_CHAR
27: PROCEDURE update_row
28: (p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
29: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := FND_API.G_MISS_NUM
30: ,p_record_version_number IN NUMBER := NULL
31: ,p_status_code IN pa_action_set_lines.status_code%TYPE := FND_API.G_MISS_CHAR
32: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
33: ,p_line_deleted_flag IN pa_action_set_lines.line_deleted_flag%TYPE := FND_API.G_MISS_CHAR
34: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
35: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
28: (p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
29: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := FND_API.G_MISS_NUM
30: ,p_record_version_number IN NUMBER := NULL
31: ,p_status_code IN pa_action_set_lines.status_code%TYPE := FND_API.G_MISS_CHAR
32: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
33: ,p_line_deleted_flag IN pa_action_set_lines.line_deleted_flag%TYPE := FND_API.G_MISS_CHAR
34: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
35: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
36: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
29: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := FND_API.G_MISS_NUM
30: ,p_record_version_number IN NUMBER := NULL
31: ,p_status_code IN pa_action_set_lines.status_code%TYPE := FND_API.G_MISS_CHAR
32: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
33: ,p_line_deleted_flag IN pa_action_set_lines.line_deleted_flag%TYPE := FND_API.G_MISS_CHAR
34: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
35: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
36: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
37: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
30: ,p_record_version_number IN NUMBER := NULL
31: ,p_status_code IN pa_action_set_lines.status_code%TYPE := FND_API.G_MISS_CHAR
32: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
33: ,p_line_deleted_flag IN pa_action_set_lines.line_deleted_flag%TYPE := FND_API.G_MISS_CHAR
34: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
35: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
36: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
37: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
38: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
31: ,p_status_code IN pa_action_set_lines.status_code%TYPE := FND_API.G_MISS_CHAR
32: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
33: ,p_line_deleted_flag IN pa_action_set_lines.line_deleted_flag%TYPE := FND_API.G_MISS_CHAR
34: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
35: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
36: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
37: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
38: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
39: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
32: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
33: ,p_line_deleted_flag IN pa_action_set_lines.line_deleted_flag%TYPE := FND_API.G_MISS_CHAR
34: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
35: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
36: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
37: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
38: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
39: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
40: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
33: ,p_line_deleted_flag IN pa_action_set_lines.line_deleted_flag%TYPE := FND_API.G_MISS_CHAR
34: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
35: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
36: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
37: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
38: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
39: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
40: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
41: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
34: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
35: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
36: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
37: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
38: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
39: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
40: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
41: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
42: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
35: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
36: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
37: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
38: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
39: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
40: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
41: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
42: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
43: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
36: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
37: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
38: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
39: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
40: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
41: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
42: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
43: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
44: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
37: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
38: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
39: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
40: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
41: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
42: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
43: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
44: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
45: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
38: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
39: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
40: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
41: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
42: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
43: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
44: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
45: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
46: );
39: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
40: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
41: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
42: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
43: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
44: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
45: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
46: );
47:
40: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
41: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
42: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
43: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
44: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
45: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
46: );
47:
48:
46: );
47:
48:
49: PROCEDURE Delete_Row
50: ( p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
51: ,p_record_version_number IN NUMBER := NULL
52: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
53: );
54: