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_PROJECT_SUBTEAMS_PKG dependencies on FND_API

Line 7: p_subteam_name IN pa_project_subteams.name%TYPE := FND_API.g_miss_char ,

3:
4: PROCEDURE Insert_Row
5: (
6:
7: p_subteam_name IN pa_project_subteams.name%TYPE := FND_API.g_miss_char ,
8: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
9: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
10: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char ,
11: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char ,

Line 8: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,

4: PROCEDURE Insert_Row
5: (
6:
7: p_subteam_name IN pa_project_subteams.name%TYPE := FND_API.g_miss_char ,
8: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
9: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
10: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char ,
11: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char ,
12: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.g_miss_char ,

Line 9: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,

5: (
6:
7: p_subteam_name IN pa_project_subteams.name%TYPE := FND_API.g_miss_char ,
8: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
9: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
10: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char ,
11: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char ,
12: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.g_miss_char ,
13: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.g_miss_char ,

Line 10: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char ,

6:
7: p_subteam_name IN pa_project_subteams.name%TYPE := FND_API.g_miss_char ,
8: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
9: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
10: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char ,
11: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char ,
12: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.g_miss_char ,
13: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.g_miss_char ,
14: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.g_miss_char ,

Line 11: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char ,

7: p_subteam_name IN pa_project_subteams.name%TYPE := FND_API.g_miss_char ,
8: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
9: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
10: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char ,
11: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char ,
12: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.g_miss_char ,
13: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.g_miss_char ,
14: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.g_miss_char ,
15: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.g_miss_char ,

Line 12: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.g_miss_char ,

8: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
9: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
10: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char ,
11: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char ,
12: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.g_miss_char ,
13: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.g_miss_char ,
14: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.g_miss_char ,
15: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.g_miss_char ,
16: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.g_miss_char ,

Line 13: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.g_miss_char ,

9: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
10: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char ,
11: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char ,
12: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.g_miss_char ,
13: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.g_miss_char ,
14: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.g_miss_char ,
15: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.g_miss_char ,
16: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.g_miss_char ,
17: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.g_miss_char ,

Line 14: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.g_miss_char ,

10: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char ,
11: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char ,
12: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.g_miss_char ,
13: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.g_miss_char ,
14: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.g_miss_char ,
15: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.g_miss_char ,
16: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.g_miss_char ,
17: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.g_miss_char ,
18: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.g_miss_char ,

Line 15: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.g_miss_char ,

11: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char ,
12: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.g_miss_char ,
13: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.g_miss_char ,
14: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.g_miss_char ,
15: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.g_miss_char ,
16: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.g_miss_char ,
17: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.g_miss_char ,
18: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.g_miss_char ,
19: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.g_miss_char ,

Line 16: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.g_miss_char ,

12: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.g_miss_char ,
13: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.g_miss_char ,
14: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.g_miss_char ,
15: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.g_miss_char ,
16: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.g_miss_char ,
17: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.g_miss_char ,
18: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.g_miss_char ,
19: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.g_miss_char ,
20: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.g_miss_char ,

Line 17: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.g_miss_char ,

13: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.g_miss_char ,
14: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.g_miss_char ,
15: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.g_miss_char ,
16: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.g_miss_char ,
17: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.g_miss_char ,
18: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.g_miss_char ,
19: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.g_miss_char ,
20: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.g_miss_char ,
21: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.g_miss_char ,

Line 18: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.g_miss_char ,

14: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.g_miss_char ,
15: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.g_miss_char ,
16: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.g_miss_char ,
17: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.g_miss_char ,
18: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.g_miss_char ,
19: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.g_miss_char ,
20: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.g_miss_char ,
21: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.g_miss_char ,
22: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.g_miss_char ,

Line 19: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.g_miss_char ,

15: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.g_miss_char ,
16: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.g_miss_char ,
17: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.g_miss_char ,
18: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.g_miss_char ,
19: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.g_miss_char ,
20: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.g_miss_char ,
21: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.g_miss_char ,
22: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.g_miss_char ,
23: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.g_miss_char ,

Line 20: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.g_miss_char ,

16: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.g_miss_char ,
17: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.g_miss_char ,
18: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.g_miss_char ,
19: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.g_miss_char ,
20: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.g_miss_char ,
21: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.g_miss_char ,
22: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.g_miss_char ,
23: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.g_miss_char ,
24: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.g_miss_char ,

Line 21: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.g_miss_char ,

17: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.g_miss_char ,
18: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.g_miss_char ,
19: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.g_miss_char ,
20: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.g_miss_char ,
21: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.g_miss_char ,
22: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.g_miss_char ,
23: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.g_miss_char ,
24: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.g_miss_char ,
25: p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.g_miss_char ,

Line 22: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.g_miss_char ,

18: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.g_miss_char ,
19: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.g_miss_char ,
20: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.g_miss_char ,
21: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.g_miss_char ,
22: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.g_miss_char ,
23: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.g_miss_char ,
24: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.g_miss_char ,
25: p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.g_miss_char ,
26: p_attribute15 IN pa_project_subteams.attribute15%TYPE := FND_API.g_miss_char ,

Line 23: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.g_miss_char ,

19: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.g_miss_char ,
20: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.g_miss_char ,
21: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.g_miss_char ,
22: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.g_miss_char ,
23: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.g_miss_char ,
24: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.g_miss_char ,
25: p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.g_miss_char ,
26: p_attribute15 IN pa_project_subteams.attribute15%TYPE := FND_API.g_miss_char ,
27: x_subteam_row_id OUT NOCOPY ROWID, --File.Sql.39 bug 4440895

Line 24: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.g_miss_char ,

20: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.g_miss_char ,
21: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.g_miss_char ,
22: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.g_miss_char ,
23: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.g_miss_char ,
24: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.g_miss_char ,
25: p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.g_miss_char ,
26: p_attribute15 IN pa_project_subteams.attribute15%TYPE := FND_API.g_miss_char ,
27: x_subteam_row_id OUT NOCOPY ROWID, --File.Sql.39 bug 4440895
28: x_new_subteam_id OUT NOCOPY pa_project_subteams.project_subteam_id%TYPE, --File.Sql.39 bug 4440895

Line 25: p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.g_miss_char ,

21: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.g_miss_char ,
22: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.g_miss_char ,
23: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.g_miss_char ,
24: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.g_miss_char ,
25: p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.g_miss_char ,
26: p_attribute15 IN pa_project_subteams.attribute15%TYPE := FND_API.g_miss_char ,
27: x_subteam_row_id OUT NOCOPY ROWID, --File.Sql.39 bug 4440895
28: x_new_subteam_id OUT NOCOPY pa_project_subteams.project_subteam_id%TYPE, --File.Sql.39 bug 4440895
29: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 26: p_attribute15 IN pa_project_subteams.attribute15%TYPE := FND_API.g_miss_char ,

22: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.g_miss_char ,
23: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.g_miss_char ,
24: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.g_miss_char ,
25: p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.g_miss_char ,
26: p_attribute15 IN pa_project_subteams.attribute15%TYPE := FND_API.g_miss_char ,
27: x_subteam_row_id OUT NOCOPY ROWID, --File.Sql.39 bug 4440895
28: x_new_subteam_id OUT NOCOPY pa_project_subteams.project_subteam_id%TYPE, --File.Sql.39 bug 4440895
29: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
30: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 44: x_return_status := FND_API.G_RET_STS_SUCCESS;

40: WHERE project_subteam_id = l_subteam_id;
41:
42: BEGIN
43:
44: x_return_status := FND_API.G_RET_STS_SUCCESS;
45:
46: --Fetch the next sequence number for subteam
47: --SELECT pa_project_subteams_s.NEXTVAL
48: --INTO l_subteam_id

Line 83: DECODE(p_subteam_name, FND_API.G_MISS_CHAR, NULL, p_subteam_name),

79: last_update_login )
80: VALUES
81: (
82: pa_project_subteams_s.NEXTVAL,
83: DECODE(p_subteam_name, FND_API.G_MISS_CHAR, NULL, p_subteam_name),
84: DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type),
85: DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id),
86: DECODE(p_description, FND_API.G_MISS_CHAR, NULL, p_description),
87: l_record_version_number,

Line 84: DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type),

80: VALUES
81: (
82: pa_project_subteams_s.NEXTVAL,
83: DECODE(p_subteam_name, FND_API.G_MISS_CHAR, NULL, p_subteam_name),
84: DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type),
85: DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id),
86: DECODE(p_description, FND_API.G_MISS_CHAR, NULL, p_description),
87: l_record_version_number,
88: DECODE(p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),

Line 85: DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id),

81: (
82: pa_project_subteams_s.NEXTVAL,
83: DECODE(p_subteam_name, FND_API.G_MISS_CHAR, NULL, p_subteam_name),
84: DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type),
85: DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id),
86: DECODE(p_description, FND_API.G_MISS_CHAR, NULL, p_description),
87: l_record_version_number,
88: DECODE(p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
89: DECODE(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),

Line 86: DECODE(p_description, FND_API.G_MISS_CHAR, NULL, p_description),

82: pa_project_subteams_s.NEXTVAL,
83: DECODE(p_subteam_name, FND_API.G_MISS_CHAR, NULL, p_subteam_name),
84: DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type),
85: DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id),
86: DECODE(p_description, FND_API.G_MISS_CHAR, NULL, p_description),
87: l_record_version_number,
88: DECODE(p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
89: DECODE(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
90: DECODE(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),

Line 88: DECODE(p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),

84: DECODE(p_object_type, FND_API.G_MISS_CHAR, NULL, p_object_type),
85: DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id),
86: DECODE(p_description, FND_API.G_MISS_CHAR, NULL, p_description),
87: l_record_version_number,
88: DECODE(p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
89: DECODE(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
90: DECODE(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
91: DECODE(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
92: DECODE(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),

Line 89: DECODE(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),

85: DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id),
86: DECODE(p_description, FND_API.G_MISS_CHAR, NULL, p_description),
87: l_record_version_number,
88: DECODE(p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
89: DECODE(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
90: DECODE(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
91: DECODE(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
92: DECODE(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
93: DECODE(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),

Line 90: DECODE(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),

86: DECODE(p_description, FND_API.G_MISS_CHAR, NULL, p_description),
87: l_record_version_number,
88: DECODE(p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
89: DECODE(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
90: DECODE(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
91: DECODE(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
92: DECODE(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
93: DECODE(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
94: DECODE(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),

Line 91: DECODE(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),

87: l_record_version_number,
88: DECODE(p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
89: DECODE(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
90: DECODE(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
91: DECODE(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
92: DECODE(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
93: DECODE(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
94: DECODE(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
95: DECODE(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),

Line 92: DECODE(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),

88: DECODE(p_attribute_category, FND_API.G_MISS_CHAR, NULL, p_attribute_category),
89: DECODE(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
90: DECODE(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
91: DECODE(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
92: DECODE(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
93: DECODE(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
94: DECODE(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
95: DECODE(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
96: DECODE(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),

Line 93: DECODE(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),

89: DECODE(p_attribute1, FND_API.G_MISS_CHAR, NULL, p_attribute1),
90: DECODE(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
91: DECODE(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
92: DECODE(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
93: DECODE(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
94: DECODE(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
95: DECODE(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
96: DECODE(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
97: DECODE(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),

Line 94: DECODE(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),

90: DECODE(p_attribute2, FND_API.G_MISS_CHAR, NULL, p_attribute2),
91: DECODE(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
92: DECODE(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
93: DECODE(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
94: DECODE(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
95: DECODE(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
96: DECODE(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
97: DECODE(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
98: DECODE(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),

Line 95: DECODE(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),

91: DECODE(p_attribute3, FND_API.G_MISS_CHAR, NULL, p_attribute3),
92: DECODE(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
93: DECODE(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
94: DECODE(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
95: DECODE(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
96: DECODE(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
97: DECODE(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
98: DECODE(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
99: DECODE(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),

Line 96: DECODE(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),

92: DECODE(p_attribute4, FND_API.G_MISS_CHAR, NULL, p_attribute4),
93: DECODE(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
94: DECODE(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
95: DECODE(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
96: DECODE(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
97: DECODE(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
98: DECODE(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
99: DECODE(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
100: DECODE(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),

Line 97: DECODE(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),

93: DECODE(p_attribute5, FND_API.G_MISS_CHAR, NULL, p_attribute5),
94: DECODE(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
95: DECODE(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
96: DECODE(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
97: DECODE(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
98: DECODE(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
99: DECODE(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
100: DECODE(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
101: DECODE(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),

Line 98: DECODE(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),

94: DECODE(p_attribute6, FND_API.G_MISS_CHAR, NULL, p_attribute6),
95: DECODE(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
96: DECODE(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
97: DECODE(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
98: DECODE(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
99: DECODE(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
100: DECODE(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
101: DECODE(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
102: DECODE(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),

Line 99: DECODE(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),

95: DECODE(p_attribute7, FND_API.G_MISS_CHAR, NULL, p_attribute7),
96: DECODE(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
97: DECODE(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
98: DECODE(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
99: DECODE(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
100: DECODE(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
101: DECODE(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
102: DECODE(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
103: DECODE(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),

Line 100: DECODE(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),

96: DECODE(p_attribute8, FND_API.G_MISS_CHAR, NULL, p_attribute8),
97: DECODE(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
98: DECODE(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
99: DECODE(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
100: DECODE(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
101: DECODE(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
102: DECODE(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
103: DECODE(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
104: sysdate,

Line 101: DECODE(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),

97: DECODE(p_attribute9, FND_API.G_MISS_CHAR, NULL, p_attribute9),
98: DECODE(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
99: DECODE(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
100: DECODE(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
101: DECODE(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
102: DECODE(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
103: DECODE(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
104: sysdate,
105: fnd_global.user_id,

Line 102: DECODE(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),

98: DECODE(p_attribute10, FND_API.G_MISS_CHAR, NULL, p_attribute10),
99: DECODE(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
100: DECODE(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
101: DECODE(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
102: DECODE(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
103: DECODE(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
104: sysdate,
105: fnd_global.user_id,
106: sysdate,

Line 103: DECODE(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),

99: DECODE(p_attribute11, FND_API.G_MISS_CHAR, NULL, p_attribute11),
100: DECODE(p_attribute12, FND_API.G_MISS_CHAR, NULL, p_attribute12),
101: DECODE(p_attribute13, FND_API.G_MISS_CHAR, NULL, p_attribute13),
102: DECODE(p_attribute14, FND_API.G_MISS_CHAR, NULL, p_attribute14),
103: DECODE(p_attribute15, FND_API.G_MISS_CHAR, NULL, p_attribute15),
104: sysdate,
105: fnd_global.user_id,
106: sysdate,
107: fnd_global.user_id,

Line 126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

122: EXCEPTION
123: WHEN OTHERS THEN -- catch the exceptions here
124: -- Set the current program unit name in the error stack
125: -- PA_Error_Utils.Set_Error_Stack('PA_PROJECT_SUBTEAMS_PKG.Insert_Row');
126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
127: RAISE;
128: END Insert_Row;
129:
130: PROCEDURE Update_Row

Line 139: p_subteam_name IN pa_project_subteams.name%TYPE:= FND_API.g_miss_char,

135: p_subteam_id IN pa_project_subteams.project_subteam_id%TYPE,
136:
137: p_record_version_number IN NUMBER := NULL,
138:
139: p_subteam_name IN pa_project_subteams.name%TYPE:= FND_API.g_miss_char,
140:
141: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
142: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
143:

Line 141: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,

137: p_record_version_number IN NUMBER := NULL,
138:
139: p_subteam_name IN pa_project_subteams.name%TYPE:= FND_API.g_miss_char,
140:
141: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
142: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
143:
144: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
145:

Line 142: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,

138:
139: p_subteam_name IN pa_project_subteams.name%TYPE:= FND_API.g_miss_char,
140:
141: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
142: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
143:
144: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
145:
146: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char ,

Line 144: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,

140:
141: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
142: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
143:
144: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
145:
146: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char ,
147:
148: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.g_miss_char ,

Line 146: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char ,

142: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
143:
144: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
145:
146: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char ,
147:
148: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.g_miss_char ,
149:
150: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.g_miss_char ,

Line 148: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.g_miss_char ,

144: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
145:
146: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char ,
147:
148: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.g_miss_char ,
149:
150: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.g_miss_char ,
151:
152: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.g_miss_char ,

Line 150: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.g_miss_char ,

146: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char ,
147:
148: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.g_miss_char ,
149:
150: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.g_miss_char ,
151:
152: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.g_miss_char ,
153:
154: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.g_miss_char ,

Line 152: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.g_miss_char ,

148: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.g_miss_char ,
149:
150: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.g_miss_char ,
151:
152: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.g_miss_char ,
153:
154: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.g_miss_char ,
155:
156: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.g_miss_char ,

Line 154: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.g_miss_char ,

150: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.g_miss_char ,
151:
152: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.g_miss_char ,
153:
154: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.g_miss_char ,
155:
156: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.g_miss_char ,
157:
158: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.g_miss_char ,

Line 156: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.g_miss_char ,

152: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.g_miss_char ,
153:
154: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.g_miss_char ,
155:
156: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.g_miss_char ,
157:
158: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.g_miss_char ,
159:
160: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.g_miss_char ,

Line 158: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.g_miss_char ,

154: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.g_miss_char ,
155:
156: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.g_miss_char ,
157:
158: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.g_miss_char ,
159:
160: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.g_miss_char ,
161:
162: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.g_miss_char ,

Line 160: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.g_miss_char ,

156: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.g_miss_char ,
157:
158: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.g_miss_char ,
159:
160: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.g_miss_char ,
161:
162: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.g_miss_char ,
163:
164: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.g_miss_char ,

Line 162: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.g_miss_char ,

158: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.g_miss_char ,
159:
160: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.g_miss_char ,
161:
162: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.g_miss_char ,
163:
164: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.g_miss_char ,
165:
166: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.g_miss_char ,

Line 164: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.g_miss_char ,

160: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.g_miss_char ,
161:
162: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.g_miss_char ,
163:
164: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.g_miss_char ,
165:
166: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.g_miss_char ,
167:
168: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.g_miss_char ,

Line 166: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.g_miss_char ,

162: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.g_miss_char ,
163:
164: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.g_miss_char ,
165:
166: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.g_miss_char ,
167:
168: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.g_miss_char ,
169:
170: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.g_miss_char ,

Line 168: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.g_miss_char ,

164: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.g_miss_char ,
165:
166: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.g_miss_char ,
167:
168: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.g_miss_char ,
169:
170: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.g_miss_char ,
171:
172: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.g_miss_char ,

Line 170: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.g_miss_char ,

166: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.g_miss_char ,
167:
168: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.g_miss_char ,
169:
170: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.g_miss_char ,
171:
172: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.g_miss_char ,
173:
174: p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.g_miss_char ,

Line 172: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.g_miss_char ,

168: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.g_miss_char ,
169:
170: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.g_miss_char ,
171:
172: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.g_miss_char ,
173:
174: p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.g_miss_char ,
175:
176: p_attribute15 IN pa_project_subteams.attribute15%TYPE := FND_API.g_miss_char ,

Line 174: p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.g_miss_char ,

170: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.g_miss_char ,
171:
172: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.g_miss_char ,
173:
174: p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.g_miss_char ,
175:
176: p_attribute15 IN pa_project_subteams.attribute15%TYPE := FND_API.g_miss_char ,
177:
178: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 176: p_attribute15 IN pa_project_subteams.attribute15%TYPE := FND_API.g_miss_char ,

172: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.g_miss_char ,
173:
174: p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.g_miss_char ,
175:
176: p_attribute15 IN pa_project_subteams.attribute15%TYPE := FND_API.g_miss_char ,
177:
178: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
179: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
180: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 194: x_return_status := FND_API.G_RET_STS_SUCCESS;

190:
191:
192: BEGIN
193:
194: x_return_status := FND_API.G_RET_STS_SUCCESS;
195:
196: /* ??????
197: -- Lock the row first
198: SELECT rowid INTO l_row_id

Line 223: SET name = DECODE(p_subteam_name, FND_API.G_MISS_CHAR, name, p_subteam_name),

219: -- Increment the record version number by 1
220: l_record_version_number := p_record_version_number +1;
221:
222: UPDATE pa_project_subteams
223: SET name = DECODE(p_subteam_name, FND_API.G_MISS_CHAR, name, p_subteam_name),
224:
225: record_version_number = DECODE(p_record_version_number, NULL, record_version_number, l_record_version_number),
226:
227: object_type = DECODE(p_object_type, FND_API.G_MISS_CHAR, object_type, p_object_type),

Line 227: object_type = DECODE(p_object_type, FND_API.G_MISS_CHAR, object_type, p_object_type),

223: SET name = DECODE(p_subteam_name, FND_API.G_MISS_CHAR, name, p_subteam_name),
224:
225: record_version_number = DECODE(p_record_version_number, NULL, record_version_number, l_record_version_number),
226:
227: object_type = DECODE(p_object_type, FND_API.G_MISS_CHAR, object_type, p_object_type),
228: object_id = DECODE(p_object_id, FND_API.G_MISS_NUM, object_id, p_object_id),
229:
230: description = DECODE(p_description, FND_API.G_MISS_CHAR, description, p_description),
231:

Line 228: object_id = DECODE(p_object_id, FND_API.G_MISS_NUM, object_id, p_object_id),

224:
225: record_version_number = DECODE(p_record_version_number, NULL, record_version_number, l_record_version_number),
226:
227: object_type = DECODE(p_object_type, FND_API.G_MISS_CHAR, object_type, p_object_type),
228: object_id = DECODE(p_object_id, FND_API.G_MISS_NUM, object_id, p_object_id),
229:
230: description = DECODE(p_description, FND_API.G_MISS_CHAR, description, p_description),
231:
232: attribute_category = DECODE(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category),

Line 230: description = DECODE(p_description, FND_API.G_MISS_CHAR, description, p_description),

226:
227: object_type = DECODE(p_object_type, FND_API.G_MISS_CHAR, object_type, p_object_type),
228: object_id = DECODE(p_object_id, FND_API.G_MISS_NUM, object_id, p_object_id),
229:
230: description = DECODE(p_description, FND_API.G_MISS_CHAR, description, p_description),
231:
232: attribute_category = DECODE(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category),
233: attribute1 = DECODE(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1),
234: attribute2 = DECODE(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2),

Line 232: attribute_category = DECODE(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category),

228: object_id = DECODE(p_object_id, FND_API.G_MISS_NUM, object_id, p_object_id),
229:
230: description = DECODE(p_description, FND_API.G_MISS_CHAR, description, p_description),
231:
232: attribute_category = DECODE(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category),
233: attribute1 = DECODE(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1),
234: attribute2 = DECODE(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2),
235: attribute3 = DECODE(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3),
236: attribute4 = DECODE(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4),

Line 233: attribute1 = DECODE(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1),

229:
230: description = DECODE(p_description, FND_API.G_MISS_CHAR, description, p_description),
231:
232: attribute_category = DECODE(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category),
233: attribute1 = DECODE(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1),
234: attribute2 = DECODE(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2),
235: attribute3 = DECODE(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3),
236: attribute4 = DECODE(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4),
237: attribute5 = DECODE(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5),

Line 234: attribute2 = DECODE(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2),

230: description = DECODE(p_description, FND_API.G_MISS_CHAR, description, p_description),
231:
232: attribute_category = DECODE(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category),
233: attribute1 = DECODE(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1),
234: attribute2 = DECODE(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2),
235: attribute3 = DECODE(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3),
236: attribute4 = DECODE(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4),
237: attribute5 = DECODE(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5),
238: attribute6 = DECODE(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6),

Line 235: attribute3 = DECODE(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3),

231:
232: attribute_category = DECODE(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category),
233: attribute1 = DECODE(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1),
234: attribute2 = DECODE(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2),
235: attribute3 = DECODE(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3),
236: attribute4 = DECODE(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4),
237: attribute5 = DECODE(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5),
238: attribute6 = DECODE(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6),
239: attribute7 = DECODE(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7),

Line 236: attribute4 = DECODE(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4),

232: attribute_category = DECODE(p_attribute_category, FND_API.G_MISS_CHAR, attribute_category, p_attribute_category),
233: attribute1 = DECODE(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1),
234: attribute2 = DECODE(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2),
235: attribute3 = DECODE(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3),
236: attribute4 = DECODE(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4),
237: attribute5 = DECODE(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5),
238: attribute6 = DECODE(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6),
239: attribute7 = DECODE(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7),
240: attribute8 = DECODE(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8),

Line 237: attribute5 = DECODE(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5),

233: attribute1 = DECODE(p_attribute1, FND_API.G_MISS_CHAR, attribute1, p_attribute1),
234: attribute2 = DECODE(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2),
235: attribute3 = DECODE(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3),
236: attribute4 = DECODE(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4),
237: attribute5 = DECODE(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5),
238: attribute6 = DECODE(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6),
239: attribute7 = DECODE(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7),
240: attribute8 = DECODE(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8),
241: attribute9 = DECODE(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9),

Line 238: attribute6 = DECODE(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6),

234: attribute2 = DECODE(p_attribute2, FND_API.G_MISS_CHAR, attribute2, p_attribute2),
235: attribute3 = DECODE(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3),
236: attribute4 = DECODE(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4),
237: attribute5 = DECODE(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5),
238: attribute6 = DECODE(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6),
239: attribute7 = DECODE(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7),
240: attribute8 = DECODE(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8),
241: attribute9 = DECODE(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9),
242: attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10),

Line 239: attribute7 = DECODE(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7),

235: attribute3 = DECODE(p_attribute3, FND_API.G_MISS_CHAR, attribute3, p_attribute3),
236: attribute4 = DECODE(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4),
237: attribute5 = DECODE(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5),
238: attribute6 = DECODE(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6),
239: attribute7 = DECODE(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7),
240: attribute8 = DECODE(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8),
241: attribute9 = DECODE(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9),
242: attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10),
243: attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11),

Line 240: attribute8 = DECODE(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8),

236: attribute4 = DECODE(p_attribute4, FND_API.G_MISS_CHAR, attribute4, p_attribute4),
237: attribute5 = DECODE(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5),
238: attribute6 = DECODE(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6),
239: attribute7 = DECODE(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7),
240: attribute8 = DECODE(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8),
241: attribute9 = DECODE(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9),
242: attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10),
243: attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11),
244: attribute12 = DECODE(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12),

Line 241: attribute9 = DECODE(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9),

237: attribute5 = DECODE(p_attribute5, FND_API.G_MISS_CHAR, attribute5, p_attribute5),
238: attribute6 = DECODE(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6),
239: attribute7 = DECODE(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7),
240: attribute8 = DECODE(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8),
241: attribute9 = DECODE(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9),
242: attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10),
243: attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11),
244: attribute12 = DECODE(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12),
245: attribute13 = DECODE(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13),

Line 242: attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10),

238: attribute6 = DECODE(p_attribute6, FND_API.G_MISS_CHAR, attribute6, p_attribute6),
239: attribute7 = DECODE(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7),
240: attribute8 = DECODE(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8),
241: attribute9 = DECODE(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9),
242: attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10),
243: attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11),
244: attribute12 = DECODE(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12),
245: attribute13 = DECODE(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13),
246: attribute14 = DECODE(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14),

Line 243: attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11),

239: attribute7 = DECODE(p_attribute7, FND_API.G_MISS_CHAR, attribute7, p_attribute7),
240: attribute8 = DECODE(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8),
241: attribute9 = DECODE(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9),
242: attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10),
243: attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11),
244: attribute12 = DECODE(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12),
245: attribute13 = DECODE(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13),
246: attribute14 = DECODE(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14),
247: attribute15 = DECODE(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15),

Line 244: attribute12 = DECODE(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12),

240: attribute8 = DECODE(p_attribute8, FND_API.G_MISS_CHAR, attribute8, p_attribute8),
241: attribute9 = DECODE(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9),
242: attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10),
243: attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11),
244: attribute12 = DECODE(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12),
245: attribute13 = DECODE(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13),
246: attribute14 = DECODE(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14),
247: attribute15 = DECODE(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15),
248: last_update_date = sysdate,

Line 245: attribute13 = DECODE(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13),

241: attribute9 = DECODE(p_attribute9, FND_API.G_MISS_CHAR, attribute9, p_attribute9),
242: attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10),
243: attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11),
244: attribute12 = DECODE(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12),
245: attribute13 = DECODE(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13),
246: attribute14 = DECODE(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14),
247: attribute15 = DECODE(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15),
248: last_update_date = sysdate,
249: last_updated_by = fnd_global.user_id,

Line 246: attribute14 = DECODE(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14),

242: attribute10 = DECODE(p_attribute10, FND_API.G_MISS_CHAR, attribute10, p_attribute10),
243: attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11),
244: attribute12 = DECODE(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12),
245: attribute13 = DECODE(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13),
246: attribute14 = DECODE(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14),
247: attribute15 = DECODE(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15),
248: last_update_date = sysdate,
249: last_updated_by = fnd_global.user_id,
250: last_update_login = fnd_global.login_id

Line 247: attribute15 = DECODE(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15),

243: attribute11 = DECODE(p_attribute11, FND_API.G_MISS_CHAR, attribute11, p_attribute11),
244: attribute12 = DECODE(p_attribute12, FND_API.G_MISS_CHAR, attribute12, p_attribute12),
245: attribute13 = DECODE(p_attribute13, FND_API.G_MISS_CHAR, attribute13, p_attribute13),
246: attribute14 = DECODE(p_attribute14, FND_API.G_MISS_CHAR, attribute14, p_attribute14),
247: attribute15 = DECODE(p_attribute15, FND_API.G_MISS_CHAR, attribute15, p_attribute15),
248: last_update_date = sysdate,
249: last_updated_by = fnd_global.user_id,
250: last_update_login = fnd_global.login_id
251: WHERE rowid = l_row_id

Line 257: PA_PROJECT_SUBTEAMS_PUB.g_error_exists := FND_API.G_TRUE;

253: --
254:
255: IF (SQL%NOTFOUND) THEN
256: PA_UTILS.Add_Message ( p_app_short_name => 'PA',p_msg_name => 'PA_XC_RECORD_CHANGED');
257: PA_PROJECT_SUBTEAMS_PUB.g_error_exists := FND_API.G_TRUE;
258: END IF;
259:
260: --
261: EXCEPTION

Line 265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

261: EXCEPTION
262: WHEN OTHERS THEN -- catch the exceptins here
263: -- Set the current program unit name in the error stack
264: -- PA_Error_Utils.Set_Error_Stack('PA_PROJECT_SUBTEAMS_PKG.Update_Row');
265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
266: RAISE;
267: --
268: END Update_Row;
269:

Line 283: x_return_status := FND_API.G_RET_STS_SUCCESS;

279: l_row_id ROWID;
280:
281: BEGIN
282:
283: x_return_status := FND_API.G_RET_STS_SUCCESS;
284:
285:
286: /*
287: -- Lock the Subteam;

Line 302: PA_PROJECT_SUBTEAMS_PUB.g_error_exists := FND_API.G_TRUE;

298:
299: --
300: IF (SQL%NOTFOUND) THEN
301: PA_UTILS.Add_Message ( p_app_short_name => 'PA', p_msg_name => 'PA_XC_RECORD_CHANGED');
302: PA_PROJECT_SUBTEAMS_PUB.g_error_exists := FND_API.G_TRUE;
303: END IF;
304: --
305: --
306:

Line 311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

307: EXCEPTION
308: WHEN OTHERS THEN
309: -- Set the current program unit name in the error stack
310: -- PA_Error_Utils.Set_Error_Stack('PA_PROJECT_SUBTEAMS_PKG.Delete_Row');
311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
312: RAISE;
313: END Delete_Row;
314:
315: --