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_PVT dependencies on PA_PROJECT_SUBTEAMS

Line 1: PACKAGE pa_project_subteams_pvt AS

1: PACKAGE pa_project_subteams_pvt AS
2: --$Header: PARTSTVS.pls 120.1 2005/08/19 17:02:13 mwasowic noship $
3:
4: PROCEDURE Create_Subteam
5: (

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

17: p_debug_mode IN VARCHAR2 := 'N',
18:
19: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
20:
21: p_subteam_name IN pa_project_subteams.name%TYPE := FND_API.g_miss_char,
22: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
23:
24: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
25:

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

18:
19: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
20:
21: p_subteam_name IN pa_project_subteams.name%TYPE := FND_API.g_miss_char,
22: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
23:
24: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
25:
26: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,

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

20:
21: p_subteam_name IN pa_project_subteams.name%TYPE := FND_API.g_miss_char,
22: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
23:
24: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
25:
26: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
27:
28: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,

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

22: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
23:
24: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
25:
26: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
27:
28: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
29:
30: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,

Line 28: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,

24: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
25:
26: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
27:
28: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
29:
30: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,
31:
32: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,

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

26: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
27:
28: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
29:
30: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,
31:
32: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,
33:
34: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,

Line 32: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,

28: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
29:
30: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,
31:
32: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,
33:
34: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,
35:
36: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,

Line 34: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,

30: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,
31:
32: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,
33:
34: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,
35:
36: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,
37:
38: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,

Line 36: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,

32: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,
33:
34: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,
35:
36: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,
37:
38: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,
39:
40:

Line 38: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,

34: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,
35:
36: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,
37:
38: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,
39:
40:
41: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.G_MISS_CHAR,
42:

Line 41: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.G_MISS_CHAR,

37:
38: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,
39:
40:
41: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.G_MISS_CHAR,
42:
43:
44: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.G_MISS_CHAR,
45:

Line 44: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.G_MISS_CHAR,

40:
41: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.G_MISS_CHAR,
42:
43:
44: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.G_MISS_CHAR,
45:
46:
47: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.G_MISS_CHAR,
48:

Line 47: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.G_MISS_CHAR,

43:
44: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.G_MISS_CHAR,
45:
46:
47: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.G_MISS_CHAR,
48:
49:
50: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.G_MISS_CHAR,
51:

Line 50: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.G_MISS_CHAR,

46:
47: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.G_MISS_CHAR,
48:
49:
50: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.G_MISS_CHAR,
51:
52:
53: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.G_MISS_CHAR,
54:

Line 53: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.G_MISS_CHAR,

49:
50: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.G_MISS_CHAR,
51:
52:
53: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.G_MISS_CHAR,
54:
55:
56: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.G_MISS_CHAR,
57:

Line 56: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.G_MISS_CHAR,

52:
53: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.G_MISS_CHAR,
54:
55:
56: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.G_MISS_CHAR,
57:
58:
59: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.G_MISS_CHAR,
60:

Line 59: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.G_MISS_CHAR,

55:
56: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.G_MISS_CHAR,
57:
58:
59: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.G_MISS_CHAR,
60:
61:
62: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.G_MISS_CHAR,
63:

Line 62: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.G_MISS_CHAR,

58:
59: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.G_MISS_CHAR,
60:
61:
62: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.G_MISS_CHAR,
63:
64:
65: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.G_MISS_CHAR,
66:

Line 65: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.G_MISS_CHAR,

61:
62: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.G_MISS_CHAR,
63:
64:
65: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.G_MISS_CHAR,
66:
67:
68: p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.G_MISS_CHAR,
69:

Line 68: p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.G_MISS_CHAR,

64:
65: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.G_MISS_CHAR,
66:
67:
68: p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.G_MISS_CHAR,
69:
70:
71: p_attribute15 IN pa_project_subteams.attribute15%TYPE := FND_API.G_MISS_CHAR,
72:

Line 71: p_attribute15 IN pa_project_subteams.attribute15%TYPE := FND_API.G_MISS_CHAR,

67:
68: p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.G_MISS_CHAR,
69:
70:
71: p_attribute15 IN pa_project_subteams.attribute15%TYPE := FND_API.G_MISS_CHAR,
72:
73:
74: x_subteam_row_id OUT NOCOPY ROWID, --File.Sql.39 bug 4440895
75: x_new_subteam_id OUT NOCOPY pa_project_subteams.project_subteam_id%TYPE, --File.Sql.39 bug 4440895

Line 75: x_new_subteam_id OUT NOCOPY pa_project_subteams.project_subteam_id%TYPE, --File.Sql.39 bug 4440895

71: p_attribute15 IN pa_project_subteams.attribute15%TYPE := FND_API.G_MISS_CHAR,
72:
73:
74: x_subteam_row_id OUT NOCOPY ROWID, --File.Sql.39 bug 4440895
75: x_new_subteam_id OUT NOCOPY pa_project_subteams.project_subteam_id%TYPE, --File.Sql.39 bug 4440895
76: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
77: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
78: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
79: )

Line 101: p_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.g_miss_num,

97: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
98:
99: p_subteam_row_id IN ROWID := null,
100:
101: p_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.g_miss_num,
102:
103: p_subteam_name IN pa_project_subteams.name%TYPE := FND_API.g_miss_char,
104: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
105:

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

99: p_subteam_row_id IN ROWID := null,
100:
101: p_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.g_miss_num,
102:
103: p_subteam_name IN pa_project_subteams.name%TYPE := FND_API.g_miss_char,
104: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
105:
106: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
107:

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

100:
101: p_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.g_miss_num,
102:
103: p_subteam_name IN pa_project_subteams.name%TYPE := FND_API.g_miss_char,
104: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
105:
106: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
107:
108: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,

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

102:
103: p_subteam_name IN pa_project_subteams.name%TYPE := FND_API.g_miss_char,
104: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
105:
106: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
107:
108: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
109:
110: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,

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

104: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
105:
106: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
107:
108: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
109:
110: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
111:
112: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,

Line 110: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,

106: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
107:
108: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
109:
110: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
111:
112: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,
113:
114: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,

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

108: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
109:
110: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
111:
112: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,
113:
114: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,
115:
116: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,

Line 114: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,

110: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
111:
112: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,
113:
114: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,
115:
116: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,
117:
118: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,

Line 116: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,

112: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,
113:
114: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,
115:
116: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,
117:
118: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,
119:
120: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,

Line 118: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,

114: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,
115:
116: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,
117:
118: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,
119:
120: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,
121:
122:

Line 120: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,

116: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,
117:
118: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,
119:
120: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,
121:
122:
123: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.G_MISS_CHAR,
124:

Line 123: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.G_MISS_CHAR,

119:
120: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,
121:
122:
123: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.G_MISS_CHAR,
124:
125:
126: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.G_MISS_CHAR,
127:

Line 126: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.G_MISS_CHAR,

122:
123: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.G_MISS_CHAR,
124:
125:
126: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.G_MISS_CHAR,
127:
128:
129: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.G_MISS_CHAR,
130:

Line 129: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.G_MISS_CHAR,

125:
126: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.G_MISS_CHAR,
127:
128:
129: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.G_MISS_CHAR,
130:
131:
132: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.G_MISS_CHAR,
133:

Line 132: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.G_MISS_CHAR,

128:
129: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.G_MISS_CHAR,
130:
131:
132: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.G_MISS_CHAR,
133:
134:
135: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.G_MISS_CHAR,
136:

Line 135: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.G_MISS_CHAR,

131:
132: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.G_MISS_CHAR,
133:
134:
135: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.G_MISS_CHAR,
136:
137:
138: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.G_MISS_CHAR,
139:

Line 138: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.G_MISS_CHAR,

134:
135: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.G_MISS_CHAR,
136:
137:
138: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.G_MISS_CHAR,
139:
140:
141: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.G_MISS_CHAR,
142:

Line 141: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.G_MISS_CHAR,

137:
138: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.G_MISS_CHAR,
139:
140:
141: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.G_MISS_CHAR,
142:
143:
144: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.G_MISS_CHAR,
145:

Line 144: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.G_MISS_CHAR,

140:
141: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.G_MISS_CHAR,
142:
143:
144: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.G_MISS_CHAR,
145:
146:
147: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.G_MISS_CHAR,
148:

Line 147: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.G_MISS_CHAR,

143:
144: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.G_MISS_CHAR,
145:
146:
147: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.G_MISS_CHAR,
148:
149:
150: p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.G_MISS_CHAR,
151:

Line 150: p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.G_MISS_CHAR,

146:
147: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.G_MISS_CHAR,
148:
149:
150: p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.G_MISS_CHAR,
151:
152:
153: p_attribute15 IN pa_project_subteams.attribute15%TYPE := FND_API.G_MISS_CHAR,
154: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 153: p_attribute15 IN pa_project_subteams.attribute15%TYPE := FND_API.G_MISS_CHAR,

149:
150: p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.G_MISS_CHAR,
151:
152:
153: p_attribute15 IN pa_project_subteams.attribute15%TYPE := FND_API.G_MISS_CHAR,
154: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
155: -- x_record_version_number OUT NUMBER ,
156: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
157: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 181: p_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := fnd_api.g_miss_num,

177: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
178:
179: p_subteam_row_id IN ROWID := NULL,
180:
181: p_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := fnd_api.g_miss_num,
182:
183: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,
184:
185: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 193: p_subteam_name IN pa_project_subteams.name%TYPE := fnd_api.g_miss_char,

189: ) ;
190:
191: PROCEDURE Get_Subteam_Id
192: (
193: p_subteam_name IN pa_project_subteams.name%TYPE := fnd_api.g_miss_char,
194: p_object_type IN pa_project_subteams.object_type%TYPE := fnd_api.g_miss_char,
195: p_object_id IN pa_project_subteams.object_id%TYPE := fnd_api.g_miss_num,
196: x_subteam_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
197: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 194: p_object_type IN pa_project_subteams.object_type%TYPE := fnd_api.g_miss_char,

190:
191: PROCEDURE Get_Subteam_Id
192: (
193: p_subteam_name IN pa_project_subteams.name%TYPE := fnd_api.g_miss_char,
194: p_object_type IN pa_project_subteams.object_type%TYPE := fnd_api.g_miss_char,
195: p_object_id IN pa_project_subteams.object_id%TYPE := fnd_api.g_miss_num,
196: x_subteam_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
197: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
198: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 195: p_object_id IN pa_project_subteams.object_id%TYPE := fnd_api.g_miss_num,

191: PROCEDURE Get_Subteam_Id
192: (
193: p_subteam_name IN pa_project_subteams.name%TYPE := fnd_api.g_miss_char,
194: p_object_type IN pa_project_subteams.object_type%TYPE := fnd_api.g_miss_char,
195: p_object_id IN pa_project_subteams.object_id%TYPE := fnd_api.g_miss_num,
196: x_subteam_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
197: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
198: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
199: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 203: END pa_project_subteams_pvt;

199: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
200:
201: ) ;
202:
203: END pa_project_subteams_pvt;