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 PA_PROJECT_SUBTEAMS

Line 1: PACKAGE BODY PA_PROJECT_SUBTEAMS_pkg AS

1: PACKAGE BODY PA_PROJECT_SUBTEAMS_pkg AS
2: --$Header: PARTSTHB.pls 120.1 2005/08/19 17:01:53 mwasowic noship $
3:
4: PROCEDURE Insert_Row
5: (

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 28: x_new_subteam_id OUT NOCOPY pa_project_subteams.project_subteam_id%TYPE, --File.Sql.39 bug 4440895

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
31: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
32: ) IS

Line 39: FROM pa_project_subteams

35: l_record_version_number NUMBER := 1;
36:
37: CURSOR c1 IS
38: SELECT rowid
39: FROM pa_project_subteams
40: WHERE project_subteam_id = l_subteam_id;
41:
42: BEGIN
43:

Line 47: --SELECT pa_project_subteams_s.NEXTVAL

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
49: --FROM dual;
50:
51:

Line 52: INSERT INTO pa_project_subteams

48: --INTO l_subteam_id
49: --FROM dual;
50:
51:
52: INSERT INTO pa_project_subteams
53: (project_subteam_id,
54: name,
55: object_type,
56: object_id,

Line 82: pa_project_subteams_s.NEXTVAL,

78: last_updated_by,
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),

Line 125: -- PA_Error_Utils.Set_Error_Stack('PA_PROJECT_SUBTEAMS_PKG.Insert_Row');

121: --
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:

Line 135: p_subteam_id IN pa_project_subteams.project_subteam_id%TYPE,

131: (
132:
133: p_subteam_row_id IN ROWID :=NULL,
134:
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,

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 188: FROM pa_project_subteams

184: l_record_version_number NUMBER;
185:
186: CURSOR get_row_id IS
187: SELECT rowid
188: FROM pa_project_subteams
189: WHERE project_subteam_id = p_subteam_id;
190:
191:
192: BEGIN

Line 199: FROM pa_project_subteams

195:
196: /* ??????
197: -- Lock the row first
198: SELECT rowid INTO l_row_id
199: FROM pa_project_subteams
200: WHERE project_subteam_id = p_subteam_id
201: OR rowid = p_subteam_row_id
202: FOR UPDATE NOWAIT;
203: */

Line 222: UPDATE pa_project_subteams

218:
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:

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 264: -- PA_Error_Utils.Set_Error_Stack('PA_PROJECT_SUBTEAMS_PKG.Update_Row');

260: --
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;

Line 272: ,p_subteam_id IN pa_project_subteams.project_subteam_id%TYPE

268: END Update_Row;
269:
270: PROCEDURE Delete_Row
271: ( p_subteam_row_id IN ROWID
272: ,p_subteam_id IN pa_project_subteams.project_subteam_id%TYPE
273: ,p_record_version_number IN NUMBER := NULL
274: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
275: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
276: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 289: FROM pa_project_subteams

285:
286: /*
287: -- Lock the Subteam;
288: SELECT rowid INTO l_row_id
289: FROM pa_project_subteams
290: WHERE project_subteam_id = p_subteam_id
291: FOR UPDATE NOWAIT;
292: */
293:

Line 294: DELETE FROM pa_project_subteams

290: WHERE project_subteam_id = p_subteam_id
291: FOR UPDATE NOWAIT;
292: */
293:
294: DELETE FROM pa_project_subteams
295: WHERE project_subteam_id = p_subteam_id
296: OR rowid = p_subteam_row_id;
297: --AND nvl(p_record_version_number, record_version_number) = record_version_number;
298:

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 310: -- PA_Error_Utils.Set_Error_Stack('PA_PROJECT_SUBTEAMS_PKG.Delete_Row');

306:
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:

Line 317: END PA_PROJECT_SUBTEAMS_pkg;

313: END Delete_Row;
314:
315: --
316: --
317: END PA_PROJECT_SUBTEAMS_pkg;