1: PACKAGE PA_PROJECT_SUBTEAMS_PUB AUTHID CURRENT_USER AS
2: --$Header: PARTSTPS.pls 120.1 2005/09/28 04:53:36 sunkalya noship $
3:
4: g_error_exists VARCHAR2(1) := FND_API.G_FALSE;
5:
6:
7: PROCEDURE Create_Subteam
8: (
6:
7: PROCEDURE Create_Subteam
8: (
9: p_api_version IN NUMBER := 1.0,
10: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
11: p_commit IN VARCHAR2 := FND_API.g_false,
12: p_validate_only IN VARCHAR2 := FND_API.g_true,
13: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
14: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
7: PROCEDURE Create_Subteam
8: (
9: p_api_version IN NUMBER := 1.0,
10: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
11: p_commit IN VARCHAR2 := FND_API.g_false,
12: p_validate_only IN VARCHAR2 := FND_API.g_true,
13: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
14: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
15: p_debug_mode IN VARCHAR2 := 'N',
8: (
9: p_api_version IN NUMBER := 1.0,
10: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
11: p_commit IN VARCHAR2 := FND_API.g_false,
12: p_validate_only IN VARCHAR2 := FND_API.g_true,
13: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
14: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
15: p_debug_mode IN VARCHAR2 := 'N',
16: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
9: p_api_version IN NUMBER := 1.0,
10: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
11: p_commit IN VARCHAR2 := FND_API.g_false,
12: p_validate_only IN VARCHAR2 := FND_API.g_true,
13: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
14: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
15: p_debug_mode IN VARCHAR2 := 'N',
16: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
17: p_subteam_name IN pa_project_subteams.name%TYPE := FND_API.g_miss_char,
12: p_validate_only IN VARCHAR2 := FND_API.g_true,
13: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
14: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
15: p_debug_mode IN VARCHAR2 := 'N',
16: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
17: p_subteam_name IN pa_project_subteams.name%TYPE := FND_API.g_miss_char,
18: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
19: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
20: p_object_name IN VARCHAR2 := FND_API.g_miss_char,
13: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
14: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
15: p_debug_mode IN VARCHAR2 := 'N',
16: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
17: p_subteam_name IN pa_project_subteams.name%TYPE := FND_API.g_miss_char,
18: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
19: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
20: p_object_name IN VARCHAR2 := FND_API.g_miss_char,
21: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
14: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
15: p_debug_mode IN VARCHAR2 := 'N',
16: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
17: p_subteam_name IN pa_project_subteams.name%TYPE := FND_API.g_miss_char,
18: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
19: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
20: p_object_name IN VARCHAR2 := FND_API.g_miss_char,
21: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
22: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
15: p_debug_mode IN VARCHAR2 := 'N',
16: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
17: p_subteam_name IN pa_project_subteams.name%TYPE := FND_API.g_miss_char,
18: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
19: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
20: p_object_name IN VARCHAR2 := FND_API.g_miss_char,
21: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
22: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
23: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,
16: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
17: p_subteam_name IN pa_project_subteams.name%TYPE := FND_API.g_miss_char,
18: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
19: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
20: p_object_name IN VARCHAR2 := FND_API.g_miss_char,
21: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
22: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
23: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,
24: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,
17: p_subteam_name IN pa_project_subteams.name%TYPE := FND_API.g_miss_char,
18: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
19: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
20: p_object_name IN VARCHAR2 := FND_API.g_miss_char,
21: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
22: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
23: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,
24: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,
25: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,
18: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
19: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
20: p_object_name IN VARCHAR2 := FND_API.g_miss_char,
21: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
22: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
23: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,
24: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,
25: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,
26: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,
19: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
20: p_object_name IN VARCHAR2 := FND_API.g_miss_char,
21: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
22: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
23: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,
24: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,
25: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,
26: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,
27: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,
20: p_object_name IN VARCHAR2 := FND_API.g_miss_char,
21: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
22: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
23: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,
24: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,
25: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,
26: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,
27: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,
28: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.G_MISS_CHAR,
21: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
22: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
23: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,
24: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,
25: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,
26: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,
27: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,
28: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.G_MISS_CHAR,
29: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.G_MISS_CHAR,
22: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
23: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,
24: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,
25: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,
26: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,
27: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,
28: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.G_MISS_CHAR,
29: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.G_MISS_CHAR,
30: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.G_MISS_CHAR,
23: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,
24: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,
25: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,
26: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,
27: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,
28: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.G_MISS_CHAR,
29: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.G_MISS_CHAR,
30: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.G_MISS_CHAR,
31: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.G_MISS_CHAR,
24: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,
25: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,
26: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,
27: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,
28: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.G_MISS_CHAR,
29: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.G_MISS_CHAR,
30: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.G_MISS_CHAR,
31: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.G_MISS_CHAR,
32: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.G_MISS_CHAR,
25: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,
26: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,
27: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,
28: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.G_MISS_CHAR,
29: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.G_MISS_CHAR,
30: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.G_MISS_CHAR,
31: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.G_MISS_CHAR,
32: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.G_MISS_CHAR,
33: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.G_MISS_CHAR,
26: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,
27: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,
28: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.G_MISS_CHAR,
29: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.G_MISS_CHAR,
30: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.G_MISS_CHAR,
31: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.G_MISS_CHAR,
32: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.G_MISS_CHAR,
33: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.G_MISS_CHAR,
34: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.G_MISS_CHAR,
27: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,
28: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.G_MISS_CHAR,
29: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.G_MISS_CHAR,
30: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.G_MISS_CHAR,
31: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.G_MISS_CHAR,
32: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.G_MISS_CHAR,
33: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.G_MISS_CHAR,
34: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.G_MISS_CHAR,
35: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.G_MISS_CHAR,
28: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.G_MISS_CHAR,
29: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.G_MISS_CHAR,
30: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.G_MISS_CHAR,
31: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.G_MISS_CHAR,
32: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.G_MISS_CHAR,
33: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.G_MISS_CHAR,
34: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.G_MISS_CHAR,
35: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.G_MISS_CHAR,
36: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.G_MISS_CHAR,
29: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.G_MISS_CHAR,
30: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.G_MISS_CHAR,
31: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.G_MISS_CHAR,
32: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.G_MISS_CHAR,
33: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.G_MISS_CHAR,
34: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.G_MISS_CHAR,
35: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.G_MISS_CHAR,
36: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.G_MISS_CHAR,
37: p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.G_MISS_CHAR,
30: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.G_MISS_CHAR,
31: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.G_MISS_CHAR,
32: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.G_MISS_CHAR,
33: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.G_MISS_CHAR,
34: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.G_MISS_CHAR,
35: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.G_MISS_CHAR,
36: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.G_MISS_CHAR,
37: p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.G_MISS_CHAR,
38: p_attribute15 IN pa_project_subteams.attribute15%TYPE := FND_API.G_MISS_CHAR,
31: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.G_MISS_CHAR,
32: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.G_MISS_CHAR,
33: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.G_MISS_CHAR,
34: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.G_MISS_CHAR,
35: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.G_MISS_CHAR,
36: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.G_MISS_CHAR,
37: p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.G_MISS_CHAR,
38: p_attribute15 IN pa_project_subteams.attribute15%TYPE := FND_API.G_MISS_CHAR,
39: --Bug: 4537865
32: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.G_MISS_CHAR,
33: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.G_MISS_CHAR,
34: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.G_MISS_CHAR,
35: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.G_MISS_CHAR,
36: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.G_MISS_CHAR,
37: p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.G_MISS_CHAR,
38: p_attribute15 IN pa_project_subteams.attribute15%TYPE := FND_API.G_MISS_CHAR,
39: --Bug: 4537865
40: x_new_subteam_id OUT NOCOPY pa_project_subteams.project_subteam_id%TYPE,
33: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.G_MISS_CHAR,
34: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.G_MISS_CHAR,
35: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.G_MISS_CHAR,
36: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.G_MISS_CHAR,
37: p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.G_MISS_CHAR,
38: p_attribute15 IN pa_project_subteams.attribute15%TYPE := FND_API.G_MISS_CHAR,
39: --Bug: 4537865
40: x_new_subteam_id OUT NOCOPY pa_project_subteams.project_subteam_id%TYPE,
41: x_subteam_row_id OUT NOCOPY ROWID,
34: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.G_MISS_CHAR,
35: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.G_MISS_CHAR,
36: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.G_MISS_CHAR,
37: p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.G_MISS_CHAR,
38: p_attribute15 IN pa_project_subteams.attribute15%TYPE := FND_API.G_MISS_CHAR,
39: --Bug: 4537865
40: x_new_subteam_id OUT NOCOPY pa_project_subteams.project_subteam_id%TYPE,
41: x_subteam_row_id OUT NOCOPY ROWID,
42: x_return_status OUT NOCOPY VARCHAR2,
47:
48: PROCEDURE Update_Subteam
49: (
50: p_api_version IN NUMBER := 1.0,
51: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
52: p_commit IN VARCHAR2 := FND_API.g_false,
53: p_validate_only IN VARCHAR2 := FND_API.g_true,
54: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
55: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
48: PROCEDURE Update_Subteam
49: (
50: p_api_version IN NUMBER := 1.0,
51: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
52: p_commit IN VARCHAR2 := FND_API.g_false,
53: p_validate_only IN VARCHAR2 := FND_API.g_true,
54: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
55: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
56: p_debug_mode IN VARCHAR2 := 'N',
49: (
50: p_api_version IN NUMBER := 1.0,
51: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
52: p_commit IN VARCHAR2 := FND_API.g_false,
53: p_validate_only IN VARCHAR2 := FND_API.g_true,
54: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
55: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
56: p_debug_mode IN VARCHAR2 := 'N',
57: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
50: p_api_version IN NUMBER := 1.0,
51: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
52: p_commit IN VARCHAR2 := FND_API.g_false,
53: p_validate_only IN VARCHAR2 := FND_API.g_true,
54: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
55: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
56: p_debug_mode IN VARCHAR2 := 'N',
57: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
58: p_subteam_row_id IN ROWID := NULL,
53: p_validate_only IN VARCHAR2 := FND_API.g_true,
54: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
55: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
56: p_debug_mode IN VARCHAR2 := 'N',
57: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
58: p_subteam_row_id IN ROWID := NULL,
59: p_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.g_miss_num,
60: p_subteam_name IN pa_project_subteams.name%TYPE := FND_API.g_miss_char,
61: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
55: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
56: p_debug_mode IN VARCHAR2 := 'N',
57: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
58: p_subteam_row_id IN ROWID := NULL,
59: p_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.g_miss_num,
60: p_subteam_name IN pa_project_subteams.name%TYPE := FND_API.g_miss_char,
61: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
62: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
63: p_object_name IN VARCHAR2 := FND_API.g_miss_char,
56: p_debug_mode IN VARCHAR2 := 'N',
57: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
58: p_subteam_row_id IN ROWID := NULL,
59: p_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.g_miss_num,
60: p_subteam_name IN pa_project_subteams.name%TYPE := FND_API.g_miss_char,
61: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
62: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
63: p_object_name IN VARCHAR2 := FND_API.g_miss_char,
64: --p_project_number IN VARCHAR2 := FND_API.g_miss_char,
57: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
58: p_subteam_row_id IN ROWID := NULL,
59: p_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.g_miss_num,
60: p_subteam_name IN pa_project_subteams.name%TYPE := FND_API.g_miss_char,
61: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
62: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
63: p_object_name IN VARCHAR2 := FND_API.g_miss_char,
64: --p_project_number IN VARCHAR2 := FND_API.g_miss_char,
65: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
58: p_subteam_row_id IN ROWID := NULL,
59: p_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.g_miss_num,
60: p_subteam_name IN pa_project_subteams.name%TYPE := FND_API.g_miss_char,
61: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
62: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
63: p_object_name IN VARCHAR2 := FND_API.g_miss_char,
64: --p_project_number IN VARCHAR2 := FND_API.g_miss_char,
65: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
66: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
59: p_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.g_miss_num,
60: p_subteam_name IN pa_project_subteams.name%TYPE := FND_API.g_miss_char,
61: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
62: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
63: p_object_name IN VARCHAR2 := FND_API.g_miss_char,
64: --p_project_number IN VARCHAR2 := FND_API.g_miss_char,
65: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
66: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
67: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,
60: p_subteam_name IN pa_project_subteams.name%TYPE := FND_API.g_miss_char,
61: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
62: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
63: p_object_name IN VARCHAR2 := FND_API.g_miss_char,
64: --p_project_number IN VARCHAR2 := FND_API.g_miss_char,
65: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
66: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
67: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,
68: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,
61: p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
62: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
63: p_object_name IN VARCHAR2 := FND_API.g_miss_char,
64: --p_project_number IN VARCHAR2 := FND_API.g_miss_char,
65: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
66: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
67: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,
68: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,
69: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,
62: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
63: p_object_name IN VARCHAR2 := FND_API.g_miss_char,
64: --p_project_number IN VARCHAR2 := FND_API.g_miss_char,
65: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
66: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
67: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,
68: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,
69: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,
70: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,
63: p_object_name IN VARCHAR2 := FND_API.g_miss_char,
64: --p_project_number IN VARCHAR2 := FND_API.g_miss_char,
65: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
66: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
67: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,
68: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,
69: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,
70: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,
71: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,
64: --p_project_number IN VARCHAR2 := FND_API.g_miss_char,
65: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
66: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
67: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,
68: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,
69: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,
70: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,
71: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,
72: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.G_MISS_CHAR,
65: p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
66: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
67: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,
68: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,
69: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,
70: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,
71: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,
72: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.G_MISS_CHAR,
73: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.G_MISS_CHAR,
66: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
67: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,
68: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,
69: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,
70: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,
71: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,
72: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.G_MISS_CHAR,
73: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.G_MISS_CHAR,
74: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.G_MISS_CHAR,
67: p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,
68: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,
69: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,
70: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,
71: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,
72: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.G_MISS_CHAR,
73: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.G_MISS_CHAR,
74: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.G_MISS_CHAR,
75: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.G_MISS_CHAR,
68: p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,
69: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,
70: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,
71: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,
72: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.G_MISS_CHAR,
73: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.G_MISS_CHAR,
74: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.G_MISS_CHAR,
75: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.G_MISS_CHAR,
76: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.G_MISS_CHAR,
69: p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,
70: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,
71: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,
72: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.G_MISS_CHAR,
73: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.G_MISS_CHAR,
74: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.G_MISS_CHAR,
75: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.G_MISS_CHAR,
76: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.G_MISS_CHAR,
77: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.G_MISS_CHAR,
70: p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,
71: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,
72: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.G_MISS_CHAR,
73: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.G_MISS_CHAR,
74: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.G_MISS_CHAR,
75: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.G_MISS_CHAR,
76: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.G_MISS_CHAR,
77: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.G_MISS_CHAR,
78: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.G_MISS_CHAR,
71: p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,
72: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.G_MISS_CHAR,
73: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.G_MISS_CHAR,
74: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.G_MISS_CHAR,
75: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.G_MISS_CHAR,
76: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.G_MISS_CHAR,
77: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.G_MISS_CHAR,
78: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.G_MISS_CHAR,
79: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.G_MISS_CHAR,
72: p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.G_MISS_CHAR,
73: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.G_MISS_CHAR,
74: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.G_MISS_CHAR,
75: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.G_MISS_CHAR,
76: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.G_MISS_CHAR,
77: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.G_MISS_CHAR,
78: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.G_MISS_CHAR,
79: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.G_MISS_CHAR,
80: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.G_MISS_CHAR,
73: p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.G_MISS_CHAR,
74: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.G_MISS_CHAR,
75: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.G_MISS_CHAR,
76: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.G_MISS_CHAR,
77: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.G_MISS_CHAR,
78: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.G_MISS_CHAR,
79: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.G_MISS_CHAR,
80: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.G_MISS_CHAR,
81: p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.G_MISS_CHAR,
74: p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.G_MISS_CHAR,
75: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.G_MISS_CHAR,
76: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.G_MISS_CHAR,
77: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.G_MISS_CHAR,
78: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.G_MISS_CHAR,
79: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.G_MISS_CHAR,
80: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.G_MISS_CHAR,
81: p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.G_MISS_CHAR,
82: p_attribute15 IN pa_project_subteams.attribute15%TYPE := FND_API.G_MISS_CHAR,
75: p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.G_MISS_CHAR,
76: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.G_MISS_CHAR,
77: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.G_MISS_CHAR,
78: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.G_MISS_CHAR,
79: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.G_MISS_CHAR,
80: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.G_MISS_CHAR,
81: p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.G_MISS_CHAR,
82: p_attribute15 IN pa_project_subteams.attribute15%TYPE := FND_API.G_MISS_CHAR,
83: --Bug: 4537865
76: p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.G_MISS_CHAR,
77: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.G_MISS_CHAR,
78: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.G_MISS_CHAR,
79: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.G_MISS_CHAR,
80: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.G_MISS_CHAR,
81: p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.G_MISS_CHAR,
82: p_attribute15 IN pa_project_subteams.attribute15%TYPE := FND_API.G_MISS_CHAR,
83: --Bug: 4537865
84: x_return_status OUT NOCOPY VARCHAR2,
77: p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.G_MISS_CHAR,
78: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.G_MISS_CHAR,
79: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.G_MISS_CHAR,
80: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.G_MISS_CHAR,
81: p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.G_MISS_CHAR,
82: p_attribute15 IN pa_project_subteams.attribute15%TYPE := FND_API.G_MISS_CHAR,
83: --Bug: 4537865
84: x_return_status OUT NOCOPY VARCHAR2,
85: x_msg_count OUT NOCOPY NUMBER,
78: p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.G_MISS_CHAR,
79: p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.G_MISS_CHAR,
80: p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.G_MISS_CHAR,
81: p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.G_MISS_CHAR,
82: p_attribute15 IN pa_project_subteams.attribute15%TYPE := FND_API.G_MISS_CHAR,
83: --Bug: 4537865
84: x_return_status OUT NOCOPY VARCHAR2,
85: x_msg_count OUT NOCOPY NUMBER,
86: x_msg_data OUT NOCOPY VARCHAR2
90:
91: PROCEDURE Delete_Subteam
92: (
93: p_api_version IN NUMBER := 1.0,
94: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
95: p_commit IN VARCHAR2 := FND_API.g_false,
96: p_validate_only IN VARCHAR2 := FND_API.g_true,
97: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
98: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
91: PROCEDURE Delete_Subteam
92: (
93: p_api_version IN NUMBER := 1.0,
94: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
95: p_commit IN VARCHAR2 := FND_API.g_false,
96: p_validate_only IN VARCHAR2 := FND_API.g_true,
97: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
98: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
99: p_debug_mode IN VARCHAR2 := 'N',
92: (
93: p_api_version IN NUMBER := 1.0,
94: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
95: p_commit IN VARCHAR2 := FND_API.g_false,
96: p_validate_only IN VARCHAR2 := FND_API.g_true,
97: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
98: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
99: p_debug_mode IN VARCHAR2 := 'N',
100: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
93: p_api_version IN NUMBER := 1.0,
94: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
95: p_commit IN VARCHAR2 := FND_API.g_false,
96: p_validate_only IN VARCHAR2 := FND_API.g_true,
97: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
98: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
99: p_debug_mode IN VARCHAR2 := 'N',
100: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
101: p_subteam_row_id IN ROWID := NULL,
96: p_validate_only IN VARCHAR2 := FND_API.g_true,
97: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
98: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
99: p_debug_mode IN VARCHAR2 := 'N',
100: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
101: p_subteam_row_id IN ROWID := NULL,
102: p_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM,
103: p_object_type IN pa_project_subteams.object_type%TYPE := fnd_api.g_miss_char,
104: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
98: p_calling_module IN VARCHAR2 := 'SELF_SERVICE',
99: p_debug_mode IN VARCHAR2 := 'N',
100: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
101: p_subteam_row_id IN ROWID := NULL,
102: p_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM,
103: p_object_type IN pa_project_subteams.object_type%TYPE := fnd_api.g_miss_char,
104: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
105: p_subteam_name IN pa_project_subteams.name%TYPE := fnd_api.g_miss_char,
106: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM ,
99: p_debug_mode IN VARCHAR2 := 'N',
100: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
101: p_subteam_row_id IN ROWID := NULL,
102: p_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM,
103: p_object_type IN pa_project_subteams.object_type%TYPE := fnd_api.g_miss_char,
104: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
105: p_subteam_name IN pa_project_subteams.name%TYPE := fnd_api.g_miss_char,
106: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM ,
107: --Bug: 4537865
100: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
101: p_subteam_row_id IN ROWID := NULL,
102: p_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM,
103: p_object_type IN pa_project_subteams.object_type%TYPE := fnd_api.g_miss_char,
104: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
105: p_subteam_name IN pa_project_subteams.name%TYPE := fnd_api.g_miss_char,
106: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM ,
107: --Bug: 4537865
108: x_return_status OUT NOCOPY VARCHAR2,
101: p_subteam_row_id IN ROWID := NULL,
102: p_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM,
103: p_object_type IN pa_project_subteams.object_type%TYPE := fnd_api.g_miss_char,
104: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
105: p_subteam_name IN pa_project_subteams.name%TYPE := fnd_api.g_miss_char,
106: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM ,
107: --Bug: 4537865
108: x_return_status OUT NOCOPY VARCHAR2,
109: x_msg_count OUT NOCOPY NUMBER,
102: p_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM,
103: p_object_type IN pa_project_subteams.object_type%TYPE := fnd_api.g_miss_char,
104: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
105: p_subteam_name IN pa_project_subteams.name%TYPE := fnd_api.g_miss_char,
106: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM ,
107: --Bug: 4537865
108: x_return_status OUT NOCOPY VARCHAR2,
109: x_msg_count OUT NOCOPY NUMBER,
110: x_msg_data OUT NOCOPY VARCHAR2
113:
114: PROCEDURE Delete_Subteam_By_Obj
115: (
116: p_api_version IN NUMBER := 1.0,
117: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
118: p_commit IN VARCHAR2 := FND_API.g_false,
119:
120: p_validate_only IN VARCHAR2 := FND_API.g_true,
121:
114: PROCEDURE Delete_Subteam_By_Obj
115: (
116: p_api_version IN NUMBER := 1.0,
117: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
118: p_commit IN VARCHAR2 := FND_API.g_false,
119:
120: p_validate_only IN VARCHAR2 := FND_API.g_true,
121:
122: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
116: p_api_version IN NUMBER := 1.0,
117: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
118: p_commit IN VARCHAR2 := FND_API.g_false,
119:
120: p_validate_only IN VARCHAR2 := FND_API.g_true,
121:
122: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
123:
124: p_calling_module IN VARCHAR2
118: p_commit IN VARCHAR2 := FND_API.g_false,
119:
120: p_validate_only IN VARCHAR2 := FND_API.g_true,
121:
122: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
123:
124: p_calling_module IN VARCHAR2
125: := 'SELF_SERVICE',
126:
125: := 'SELF_SERVICE',
126:
127: p_debug_mode IN VARCHAR2 := 'N',
128:
129: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
130:
131: p_object_type IN pa_project_subteams.object_type%TYPE := fnd_api.g_miss_char,
132: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
133:
127: p_debug_mode IN VARCHAR2 := 'N',
128:
129: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
130:
131: p_object_type IN pa_project_subteams.object_type%TYPE := fnd_api.g_miss_char,
132: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
133:
134: --Bug: 4537865
135: x_return_status OUT NOCOPY VARCHAR2,
128:
129: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
130:
131: p_object_type IN pa_project_subteams.object_type%TYPE := fnd_api.g_miss_char,
132: p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
133:
134: --Bug: 4537865
135: x_return_status OUT NOCOPY VARCHAR2,
136: