DBA Data[Home] [Help]

PACKAGE: APPS.PA_ACTION_SET_LINE_COND_PKG

Source


1 PACKAGE pa_action_set_line_cond_pkg AUTHID CURRENT_USER AS
2 /*$Header: PARASCKS.pls 120.1 2005/08/19 16:47:51 mwasowic noship $*/
3 --
4 
5 PROCEDURE insert_row
6  (p_action_set_line_id        IN    pa_action_set_lines.action_set_line_id%TYPE
7  ,p_condition_date            IN    pa_action_set_line_cond.condition_date%TYPE                     := NULL
8  ,p_description               IN    pa_action_set_line_cond.description%TYPE                        := NULL
9  ,p_condition_code            IN    pa_action_set_line_cond.condition_code%TYPE
10  ,p_condition_attribute1      IN    pa_action_set_line_cond.condition_attribute1%TYPE               := NULL
11  ,p_condition_attribute2      IN    pa_action_set_line_cond.condition_attribute2%TYPE               := NULL
12  ,p_condition_attribute3      IN    pa_action_set_line_cond.condition_attribute3%TYPE               := NULL
13  ,p_condition_attribute4      IN    pa_action_set_line_cond.condition_attribute4%TYPE               := NULL
14  ,p_condition_attribute5      IN    pa_action_set_line_cond.condition_attribute5%TYPE               := NULL
15  ,p_condition_attribute6      IN    pa_action_set_line_cond.condition_attribute6%TYPE               := NULL
16  ,p_condition_attribute7      IN    pa_action_set_line_cond.condition_attribute7%TYPE               := NULL
17  ,p_condition_attribute8      IN    pa_action_set_line_cond.condition_attribute8%TYPE               := NULL
18  ,p_condition_attribute9      IN    pa_action_set_line_cond.condition_attribute9%TYPE               := NULL
19  ,p_condition_attribute10     IN    pa_action_set_line_cond.condition_attribute10%TYPE              := NULL
20  ,x_action_set_line_condition_id    OUT    NOCOPY NUMBER --File.Sql.39 bug 4440895
21  ,x_return_status                   OUT    NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
22 );
23 
24 
25 PROCEDURE update_row
26  (p_action_set_line_condition_id  IN    pa_action_set_line_cond.action_set_line_condition_id%TYPE
27  ,p_condition_date            IN    pa_action_set_line_cond.condition_date%TYPE                  := FND_API.G_MISS_DATE
28  ,p_description               IN    pa_action_set_line_cond.description%TYPE                     := FND_API.G_MISS_CHAR
29  ,p_record_version_number     IN    NUMBER                                                       := NULL
30  ,p_condition_code            IN    pa_action_set_line_cond.condition_code%TYPE                  := FND_API.G_MISS_CHAR
31  ,p_condition_attribute1      IN    pa_action_set_line_cond.condition_attribute1%TYPE            := FND_API.G_MISS_CHAR
32  ,p_condition_attribute2      IN    pa_action_set_line_cond.condition_attribute2%TYPE            := FND_API.G_MISS_CHAR
33  ,p_condition_attribute3      IN    pa_action_set_line_cond.condition_attribute3%TYPE            := FND_API.G_MISS_CHAR
34  ,p_condition_attribute4      IN    pa_action_set_line_cond.condition_attribute4%TYPE            := FND_API.G_MISS_CHAR
35  ,p_condition_attribute5      IN    pa_action_set_line_cond.condition_attribute5%TYPE            := FND_API.G_MISS_CHAR
36  ,p_condition_attribute6      IN    pa_action_set_line_cond.condition_attribute6%TYPE            := FND_API.G_MISS_CHAR
37  ,p_condition_attribute7      IN    pa_action_set_line_cond.condition_attribute7%TYPE            := FND_API.G_MISS_CHAR
38  ,p_condition_attribute8      IN    pa_action_set_line_cond.condition_attribute8%TYPE            := FND_API.G_MISS_CHAR
39  ,p_condition_attribute9      IN    pa_action_set_line_cond.condition_attribute9%TYPE            := FND_API.G_MISS_CHAR
40  ,p_condition_attribute10     IN    pa_action_set_line_cond.condition_attribute10%TYPE           := FND_API.G_MISS_CHAR
41  ,x_return_status                   OUT    NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
42 );
43 
44 
45 PROCEDURE Delete_Row
46 ( p_action_set_line_condition_id IN    pa_action_set_line_cond.action_set_line_condition_id%TYPE
47  ,p_record_version_number        IN    NUMBER                                                := NULL
48  ,x_return_status                OUT   NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
49 );
50 
51 END;