1: PACKAGE pa_project_subteams_pvt AUTHID CURRENT_USER AS
2: --$Header: PARTSTVS.pls 120.1 2005/08/19 17:02:13 mwasowic noship $
3:
4: PROCEDURE Create_Subteam
5: (
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:
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,
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,
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,
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,
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,
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,
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,
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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
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: )
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:
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:
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,
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,
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,
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,
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,
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,
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,
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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
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
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
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
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
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
199: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
200:
201: ) ;
202:
203: END pa_project_subteams_pvt;