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_SET_LINES_PKG dependencies on PA_ACTION_SET_LINES

Line 1: PACKAGE BODY pa_action_set_lines_pkg AS

1: PACKAGE BODY pa_action_set_lines_pkg AS
2: /*$Header: PARASLKB.pls 120.2 2005/08/26 12:11:37 shyugen noship $*/
3: --
4:
5: PROCEDURE insert_row

Line 6: (p_action_set_id IN pa_action_set_lines.action_set_id%TYPE

2: /*$Header: PARASLKB.pls 120.2 2005/08/26 12:11:37 shyugen 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'

Line 7: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := NULL

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

Line 8: ,p_status_code IN pa_action_set_lines.status_code%TYPE

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

Line 9: ,p_description IN pa_action_set_lines.description%TYPE := NULL

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

Line 10: ,p_line_deleted_flag IN pa_action_set_lines.line_deleted_flag%TYPE :='N'

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

Line 11: ,p_action_code IN pa_action_set_lines.action_code%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

Line 12: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%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

Line 13: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := NULL

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

Line 14: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%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

Line 15: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := NULL

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

Line 16: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := NULL

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

Line 17: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%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

Line 18: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%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

Line 19: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%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

Line 20: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%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: )

Line 21: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%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: IS

Line 44: INSERT INTO pa_action_set_lines

40: ,x_msg => 'Beginning of insert row'
41: ,x_log_level => 5);
42: END IF;
43:
44: INSERT INTO pa_action_set_lines
45: (action_set_line_id
46: ,action_set_id
47: ,action_set_line_number
48: ,status_code

Line 69: ( pa_action_set_lines_s.NEXTVAL

65: ,last_update_date
66: ,last_updated_by
67: ,last_update_login)
68: VALUES
69: ( pa_action_set_lines_s.NEXTVAL
70: ,p_action_set_id
71: ,p_action_set_line_number
72: ,p_status_code
73: ,p_description

Line 100: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SET_LINES_PKG.Insert_row'

96: -- Put any message text from message stack into the Message ARRAY
97: EXCEPTION
98: WHEN OTHERS THEN
99: -- Set the excetption Message and the stack
100: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SET_LINES_PKG.Insert_row'
101: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
102: --
103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
104: RAISE;

Line 110: (p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE

106: END Insert_Row;
107:
108:
109: PROCEDURE update_row
110: (p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
111: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := FND_API.G_MISS_NUM
112: ,p_record_version_number IN NUMBER := NULL
113: ,p_status_code IN pa_action_set_lines.status_code%TYPE := FND_API.G_MISS_CHAR
114: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR

Line 111: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := FND_API.G_MISS_NUM

107:
108:
109: PROCEDURE update_row
110: (p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
111: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := FND_API.G_MISS_NUM
112: ,p_record_version_number IN NUMBER := NULL
113: ,p_status_code IN pa_action_set_lines.status_code%TYPE := FND_API.G_MISS_CHAR
114: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
115: ,p_line_deleted_flag IN pa_action_set_lines.line_deleted_flag%TYPE := FND_API.G_MISS_CHAR

Line 113: ,p_status_code IN pa_action_set_lines.status_code%TYPE := FND_API.G_MISS_CHAR

109: PROCEDURE update_row
110: (p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
111: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := FND_API.G_MISS_NUM
112: ,p_record_version_number IN NUMBER := NULL
113: ,p_status_code IN pa_action_set_lines.status_code%TYPE := FND_API.G_MISS_CHAR
114: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
115: ,p_line_deleted_flag IN pa_action_set_lines.line_deleted_flag%TYPE := FND_API.G_MISS_CHAR
116: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
117: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR

Line 114: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR

110: (p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
111: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := FND_API.G_MISS_NUM
112: ,p_record_version_number IN NUMBER := NULL
113: ,p_status_code IN pa_action_set_lines.status_code%TYPE := FND_API.G_MISS_CHAR
114: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
115: ,p_line_deleted_flag IN pa_action_set_lines.line_deleted_flag%TYPE := FND_API.G_MISS_CHAR
116: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
117: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
118: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR

Line 115: ,p_line_deleted_flag IN pa_action_set_lines.line_deleted_flag%TYPE := FND_API.G_MISS_CHAR

111: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := FND_API.G_MISS_NUM
112: ,p_record_version_number IN NUMBER := NULL
113: ,p_status_code IN pa_action_set_lines.status_code%TYPE := FND_API.G_MISS_CHAR
114: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
115: ,p_line_deleted_flag IN pa_action_set_lines.line_deleted_flag%TYPE := FND_API.G_MISS_CHAR
116: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
117: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
118: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
119: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR

Line 116: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR

112: ,p_record_version_number IN NUMBER := NULL
113: ,p_status_code IN pa_action_set_lines.status_code%TYPE := FND_API.G_MISS_CHAR
114: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
115: ,p_line_deleted_flag IN pa_action_set_lines.line_deleted_flag%TYPE := FND_API.G_MISS_CHAR
116: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
117: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
118: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
119: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
120: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR

Line 117: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR

113: ,p_status_code IN pa_action_set_lines.status_code%TYPE := FND_API.G_MISS_CHAR
114: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
115: ,p_line_deleted_flag IN pa_action_set_lines.line_deleted_flag%TYPE := FND_API.G_MISS_CHAR
116: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
117: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
118: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
119: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
120: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
121: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR

Line 118: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR

114: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
115: ,p_line_deleted_flag IN pa_action_set_lines.line_deleted_flag%TYPE := FND_API.G_MISS_CHAR
116: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
117: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
118: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
119: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
120: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
121: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
122: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR

Line 119: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR

115: ,p_line_deleted_flag IN pa_action_set_lines.line_deleted_flag%TYPE := FND_API.G_MISS_CHAR
116: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
117: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
118: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
119: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
120: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
121: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
122: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
123: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR

Line 120: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR

116: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
117: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
118: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
119: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
120: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
121: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
122: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
123: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
124: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR

Line 121: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR

117: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
118: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
119: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
120: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
121: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
122: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
123: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
124: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
125: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR

Line 122: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR

118: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
119: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
120: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
121: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
122: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
123: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
124: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
125: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
126: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR

Line 123: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR

119: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
120: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
121: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
122: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
123: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
124: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
125: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
126: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
127: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 124: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR

120: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
121: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
122: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
123: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
124: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
125: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
126: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
127: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
128: )

Line 125: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR

121: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
122: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
123: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
124: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
125: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
126: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
127: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
128: )
129: IS

Line 126: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR

122: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
123: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
124: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
125: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
126: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
127: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
128: )
129: IS
130:

Line 147: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SET_LINES_Pkg.update_row.begin'

143: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
144:
145: --Log Message - 4403338
146: IF l_debug_mode = 'Y' THEN
147: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ACTION_SET_LINES_Pkg.update_row.begin'
148: ,x_msg => 'Beginning of update row'
149: ,x_log_level => 5);
150: END IF;
151:

Line 153: FROM pa_action_set_lines

149: ,x_log_level => 5);
150: END IF;
151:
152: SELECT rowid INTO l_rowid
153: FROM pa_action_set_lines
154: WHERE action_set_line_id = p_action_set_line_id
155: FOR UPDATE NOWAIT;
156:
157: UPDATE pa_action_set_lines

Line 157: UPDATE pa_action_set_lines

153: FROM pa_action_set_lines
154: WHERE action_set_line_id = p_action_set_line_id
155: FOR UPDATE NOWAIT;
156:
157: UPDATE pa_action_set_lines
158: SET action_set_line_number = decode(p_action_set_line_number, FND_API.G_MISS_NUM, action_set_line_number, p_action_set_line_number)
159: ,status_code = decode(p_status_code, FND_API.G_MISS_CHAR, status_code, p_status_code)
160: ,description = decode(p_description, FND_API.G_MISS_CHAR, description, p_description)
161: ,line_deleted_flag = decode(p_line_deleted_flag, FND_API.G_MISS_CHAR, line_deleted_flag, p_line_deleted_flag)

Line 197: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SET_LINES_PKG.update_row'

193: x_return_status := FND_API.G_RET_STS_ERROR;
194:
195: WHEN OTHERS THEN
196: -- Set the excetption Message and the stack
197: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_ACTION_SET_LINES_PKG.update_row'
198: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
199: --
200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
201: RAISE;

Line 206: ( p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE

202:
203: END update_row;
204:
205: PROCEDURE Delete_Row
206: ( p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
207: ,p_record_version_number IN NUMBER := NULL
208: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
209: )
210: IS

Line 216: DELETE FROM pa_action_set_lines

212: BEGIN
213:
214: x_return_status := FND_API.G_RET_STS_SUCCESS;
215:
216: DELETE FROM pa_action_set_lines
217: WHERE action_set_line_id = p_action_set_line_id
218: AND nvl(p_record_version_number, record_version_number) = record_version_number;
219:
220: --

Line 234: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ACTION_SET_LINES_PKG.Delete_Row'

230:
231: EXCEPTION
232: WHEN OTHERS THEN
233: -- Set the exception Message and the stack
234: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ACTION_SET_LINES_PKG.Delete_Row'
235: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
237: RAISE;
238: END Delete_Row;

Line 241: END pa_action_set_lines_pkg;

237: RAISE;
238: END Delete_Row;
239:
240:
241: END pa_action_set_lines_pkg;