[Home] [Help]
PACKAGE: APPS.PA_ACTION_SETS_PKG
Source
1 PACKAGE pa_action_sets_pkg AS
2 /*$Header: PARASPKS.pls 120.1 2005/08/19 16:48:09 mwasowic noship $*/
3 --
4
5 PROCEDURE insert_row
6 (p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE
7 ,p_action_set_name IN pa_action_sets.action_set_name%TYPE
8 ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
9 ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
10 ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := NULL
11 ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := NULL
12 ,p_description IN pa_action_sets.description%TYPE := NULL
13 ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := NULL
14 ,p_status_code IN pa_action_sets.status_code%TYPE
15 ,p_actual_start_date IN pa_action_sets.actual_start_date%TYPE := NULL
16 ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := NULL
17 ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := NULL
18 ,p_attribute1 IN pa_action_sets.attribute1%TYPE := NULL
19 ,p_attribute2 IN pa_action_sets.attribute2%TYPE := NULL
20 ,p_attribute3 IN pa_action_sets.attribute3%TYPE := NULL
21 ,p_attribute4 IN pa_action_sets.attribute4%TYPE := NULL
22 ,p_attribute5 IN pa_action_sets.attribute5%TYPE := NULL
23 ,p_attribute6 IN pa_action_sets.attribute6%TYPE := NULL
24 ,p_attribute7 IN pa_action_sets.attribute7%TYPE := NULL
25 ,p_attribute8 IN pa_action_sets.attribute8%TYPE := NULL
26 ,p_attribute9 IN pa_action_sets.attribute9%TYPE := NULL
27 ,p_attribute10 IN pa_action_sets.attribute10%TYPE := NULL
28 ,p_attribute11 IN pa_action_sets.attribute11%TYPE := NULL
29 ,p_attribute12 IN pa_action_sets.attribute12%TYPE := NULL
30 ,p_attribute13 IN pa_action_sets.attribute13%TYPE := NULL
31 ,p_attribute14 IN pa_action_sets.attribute14%TYPE := NULL
32 ,p_attribute15 IN pa_action_sets.attribute15%TYPE := NULL
33 ,x_action_set_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
34 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
35 );
36
37
38 PROCEDURE update_row
39 (p_action_set_id IN pa_action_sets.action_set_id%TYPE
40 ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
41 ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
42 ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
43 ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
44 ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := FND_API.G_MISS_NUM
45 ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
46 ,p_actual_start_date IN pa_action_sets.actual_start_date%TYPE := FND_API.G_MISS_DATE
47 ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
48 ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
49 ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
50 ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
51 ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
52 ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
53 ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
54 ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
55 ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
56 ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
57 ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
58 ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
59 ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
60 ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
61 ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
62 ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
63 ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR
64 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
65 );
66
67
68 PROCEDURE Delete_Row
69 ( p_action_set_id IN pa_action_sets.action_set_id%TYPE
70 ,p_record_version_number IN NUMBER := NULL
71 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
72 );
73
74 END;