DBA Data[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;