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