eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_ACTION_SETS_PKG dependencies on PA_ACTION_SETS

Line 1: PACKAGE BODY pa_action_sets_pkg AS

1: PACKAGE BODY pa_action_sets_pkg AS
2: /*$Header: PARASPKB.pls 120.2 2005/08/26 12:14:33 shyugen noship $*/
3: --
4:
5: PROCEDURE insert_row

Line 7: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE

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

Line 8: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL

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

Line 9: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL

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

Line 10: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := NULL

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

Line 11: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := NULL

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

Line 12: ,p_description IN pa_action_sets.description%TYPE := NULL

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

Line 13: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%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

Line 14: ,p_status_code IN pa_action_sets.status_code%TYPE

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

Line 15: ,p_actual_start_date IN pa_action_sets.actual_start_date%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

Line 16: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%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

Line 17: ,p_attribute_category IN pa_action_sets.attribute_category%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

Line 18: ,p_attribute1 IN pa_action_sets.attribute1%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

Line 19: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := NULL

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

Line 20: ,p_attribute3 IN pa_action_sets.attribute3%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

Line 21: ,p_attribute4 IN pa_action_sets.attribute4%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

Line 22: ,p_attribute5 IN pa_action_sets.attribute5%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

Line 23: ,p_attribute6 IN pa_action_sets.attribute6%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

Line 24: ,p_attribute7 IN pa_action_sets.attribute7%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

Line 25: ,p_attribute8 IN pa_action_sets.attribute8%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

Line 26: ,p_attribute9 IN pa_action_sets.attribute9%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

Line 27: ,p_attribute10 IN pa_action_sets.attribute10%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

Line 28: ,p_attribute11 IN pa_action_sets.attribute11%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

Line 29: ,p_attribute12 IN pa_action_sets.attribute12%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

Line 30: ,p_attribute13 IN pa_action_sets.attribute13%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

Line 31: ,p_attribute14 IN pa_action_sets.attribute14%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: )

Line 32: ,p_attribute15 IN pa_action_sets.attribute15%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: IS

Line 55: INSERT INTO pa_action_sets

51: ,x_msg => 'Beginning of insert row'
52: ,x_log_level => 5);
53: END IF;
54:
55: INSERT INTO pa_action_sets
56: (action_set_id
57: ,action_set_type_code
58: ,action_set_name
59: ,object_type

Line 92: ( pa_action_sets_s.NEXTVAL

88: ,last_update_date
89: ,last_updated_by
90: ,last_update_login)
91: VALUES
92: ( pa_action_sets_s.NEXTVAL
93: ,p_action_set_type_code
94: ,p_action_set_name
95: ,p_object_type
96: ,p_object_id

Line 135: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PKG.Insert_row'

131: -- Put any message text from message stack into the Message ARRAY
132: EXCEPTION
133: WHEN OTHERS THEN
134: -- Set the excetption Message and the stack
135: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PKG.Insert_row'
136: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
137: --
138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
139: RAISE;

Line 145: (p_action_set_id IN pa_action_sets.action_set_id%TYPE

141: END Insert_Row;
142:
143:
144: PROCEDURE update_row
145: (p_action_set_id IN pa_action_sets.action_set_id%TYPE
146: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
147: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
148: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
149: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR

Line 146: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR

142:
143:
144: PROCEDURE update_row
145: (p_action_set_id IN pa_action_sets.action_set_id%TYPE
146: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
147: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
148: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
149: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
150: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := FND_API.G_MISS_NUM

Line 147: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE

143:
144: PROCEDURE update_row
145: (p_action_set_id IN pa_action_sets.action_set_id%TYPE
146: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
147: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
148: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
149: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
150: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := FND_API.G_MISS_NUM
151: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR

Line 148: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE

144: PROCEDURE update_row
145: (p_action_set_id IN pa_action_sets.action_set_id%TYPE
146: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
147: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
148: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
149: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
150: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := FND_API.G_MISS_NUM
151: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
152: ,p_actual_start_date IN pa_action_sets.actual_start_date%TYPE := FND_API.G_MISS_DATE

Line 149: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR

145: (p_action_set_id IN pa_action_sets.action_set_id%TYPE
146: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
147: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
148: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
149: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
150: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := FND_API.G_MISS_NUM
151: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
152: ,p_actual_start_date IN pa_action_sets.actual_start_date%TYPE := FND_API.G_MISS_DATE
153: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL

Line 150: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := FND_API.G_MISS_NUM

146: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
147: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
148: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
149: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
150: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := FND_API.G_MISS_NUM
151: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
152: ,p_actual_start_date IN pa_action_sets.actual_start_date%TYPE := FND_API.G_MISS_DATE
153: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
154: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR

Line 151: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR

147: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
148: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
149: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
150: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := FND_API.G_MISS_NUM
151: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
152: ,p_actual_start_date IN pa_action_sets.actual_start_date%TYPE := FND_API.G_MISS_DATE
153: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
154: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
155: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR

Line 152: ,p_actual_start_date IN pa_action_sets.actual_start_date%TYPE := FND_API.G_MISS_DATE

148: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
149: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
150: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := FND_API.G_MISS_NUM
151: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
152: ,p_actual_start_date IN pa_action_sets.actual_start_date%TYPE := FND_API.G_MISS_DATE
153: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
154: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
155: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
156: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR

Line 153: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL

149: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
150: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := FND_API.G_MISS_NUM
151: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
152: ,p_actual_start_date IN pa_action_sets.actual_start_date%TYPE := FND_API.G_MISS_DATE
153: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
154: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
155: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
156: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
157: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR

Line 154: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR

150: ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := FND_API.G_MISS_NUM
151: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
152: ,p_actual_start_date IN pa_action_sets.actual_start_date%TYPE := FND_API.G_MISS_DATE
153: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
154: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
155: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
156: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
157: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
158: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR

Line 155: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR

151: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
152: ,p_actual_start_date IN pa_action_sets.actual_start_date%TYPE := FND_API.G_MISS_DATE
153: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
154: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
155: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
156: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
157: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
158: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
159: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR

Line 156: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR

152: ,p_actual_start_date IN pa_action_sets.actual_start_date%TYPE := FND_API.G_MISS_DATE
153: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
154: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
155: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
156: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
157: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
158: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
159: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR

Line 157: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR

153: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
154: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
155: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
156: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
157: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
158: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
159: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR

Line 158: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR

154: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
155: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
156: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
157: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
158: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
159: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
162: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR

Line 159: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR

155: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
156: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
157: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
158: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
159: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
162: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
163: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR

Line 160: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR

156: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
157: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
158: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
159: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
162: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
163: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
164: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR

Line 161: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR

157: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
158: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
159: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
162: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
163: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
164: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
165: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR

Line 162: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR

158: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
159: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
162: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
163: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
164: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
165: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
166: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR

Line 163: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR

159: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
160: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
162: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
163: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
164: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
165: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
166: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
167: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR

Line 164: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR

160: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
161: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
162: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
163: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
164: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
165: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
166: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
167: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
168: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR

Line 165: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR

161: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
162: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
163: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
164: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
165: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
166: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
167: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
168: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
169: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR

Line 166: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR

162: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
163: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
164: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
165: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
166: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
167: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
168: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
169: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR
170: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 167: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR

163: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
164: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
165: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
166: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
167: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
168: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
169: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR
170: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
171: )

Line 168: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR

164: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
165: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
166: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
167: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
168: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
169: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR
170: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
171: )
172: IS

Line 169: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR

165: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
166: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
167: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
168: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
169: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR
170: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
171: )
172: IS
173:

Line 186: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_Pkg.update_row.begin'

182: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
183:
184: --Log Message: 4403338
185: IF l_debug_mode = 'Y' THEN
186: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SETS_Pkg.update_row.begin'
187: ,x_msg => 'Beginning of update row'
188: ,x_log_level => 5);
189: END IF;
190:

Line 191: UPDATE pa_action_sets

187: ,x_msg => 'Beginning of update row'
188: ,x_log_level => 5);
189: END IF;
190:
191: UPDATE pa_action_sets
192: SET action_set_name = decode(p_action_set_name, FND_API.G_MISS_CHAR, action_set_name, p_action_set_name)
193: ,start_date_active = decode(p_start_date_active, FND_API.G_MISS_DATE, start_date_active, p_start_date_active)
194: ,end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE, end_date_active, p_end_date_active)
195: ,description = decode(p_description, FND_API.G_MISS_CHAR, description, p_description)

Line 233: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PKG.update_row'

229: -- Put any message text from message stack into the Message ARRAY
230: EXCEPTION
231: WHEN OTHERS THEN
232: -- Set the excetption Message and the stack
233: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SETS_PKG.update_row'
234: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
235: --
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
237: RAISE;

Line 242: ( p_action_set_id IN pa_action_sets.action_set_id%TYPE

238:
239: END update_row;
240:
241: PROCEDURE Delete_Row
242: ( p_action_set_id IN pa_action_sets.action_set_id%TYPE
243: ,p_record_version_number IN NUMBER := NULL
244: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
245: )
246: IS

Line 252: DELETE FROM pa_action_sets

248: BEGIN
249:
250: x_return_status := FND_API.G_RET_STS_SUCCESS;
251:
252: DELETE FROM pa_action_sets
253: WHERE action_set_id = p_action_set_id
254: AND nvl(p_record_version_number, record_version_number) = record_version_number;
255:
256: --

Line 270: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ACTION_SETS_PKG.Delete_Row'

266:
267: EXCEPTION
268: WHEN OTHERS THEN
269: -- Set the exception Message and the stack
270: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ACTION_SETS_PKG.Delete_Row'
271: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
273: RAISE;
274: END Delete_Row;

Line 277: END pa_action_sets_pkg;

273: RAISE;
274: END Delete_Row;
275:
276:
277: END pa_action_sets_pkg;