[Home] [Help]
PACKAGE: APPS.PA_ACTION_SET_LINES_PKG
Source
1 PACKAGE pa_action_set_lines_pkg AUTHID CURRENT_USER AS
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'
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
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
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
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
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
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
55 END;