DBA Data[Home] [Help]

APPS.PA_PROJECT_SUBTEAMS_PUB dependencies on FND_API

Line 4: g_error_exists VARCHAR2(1) := FND_API.G_FALSE;

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

Line 10: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,

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',

Line 11: p_commit IN VARCHAR2 := FND_API.g_false,

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',

Line 12: p_validate_only IN VARCHAR2 := FND_API.g_true,

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,

Line 13: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

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,

Line 16: p_max_msg_count IN NUMBER := FND_API.g_miss_num,

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,

Line 17: p_subteam_name IN pa_project_subteams.name%TYPE := 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,

Line 18: p_object_type IN pa_project_subteams.object_type%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,

Line 19: p_object_id IN pa_project_subteams.object_id%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,

Line 20: p_object_name IN VARCHAR2 := 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,

Line 21: p_description IN pa_project_subteams.description%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,

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

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,

Line 23: p_attribute_category IN pa_project_subteams.attribute_category%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,

Line 24: p_attribute1 IN pa_project_subteams.attribute1%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,

Line 25: p_attribute2 IN pa_project_subteams.attribute2%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,

Line 26: p_attribute3 IN pa_project_subteams.attribute3%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,

Line 27: p_attribute4 IN pa_project_subteams.attribute4%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,

Line 28: p_attribute5 IN pa_project_subteams.attribute5%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,

Line 29: p_attribute6 IN pa_project_subteams.attribute6%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,

Line 30: p_attribute7 IN pa_project_subteams.attribute7%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,

Line 31: p_attribute8 IN pa_project_subteams.attribute8%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,

Line 32: p_attribute9 IN pa_project_subteams.attribute9%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,

Line 33: p_attribute10 IN pa_project_subteams.attribute10%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,

Line 34: p_attribute11 IN pa_project_subteams.attribute11%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,

Line 35: p_attribute12 IN pa_project_subteams.attribute12%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

Line 36: p_attribute13 IN pa_project_subteams.attribute13%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
40: x_new_subteam_id OUT NOCOPY pa_project_subteams.project_subteam_id%TYPE,

Line 37: p_attribute14 IN pa_project_subteams.attribute14%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,
41: x_subteam_row_id OUT NOCOPY ROWID,

Line 38: p_attribute15 IN pa_project_subteams.attribute15%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,
42: x_return_status OUT NOCOPY VARCHAR2,

Line 51: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,

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',

Line 52: p_commit IN VARCHAR2 := FND_API.g_false,

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',

Line 53: p_validate_only IN VARCHAR2 := FND_API.g_true,

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,

Line 54: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

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,

Line 57: p_max_msg_count IN NUMBER := FND_API.g_miss_num,

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,

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

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,

Line 60: p_subteam_name IN pa_project_subteams.name%TYPE := 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,

Line 61: p_object_type IN pa_project_subteams.object_type%TYPE := 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,

Line 62: p_object_id IN pa_project_subteams.object_id%TYPE := 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,
66: p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,

Line 63: p_object_name IN VARCHAR2 := FND_API.g_miss_char,

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,

Line 64: --p_project_number IN VARCHAR2 := 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,

Line 65: p_description IN pa_project_subteams.description%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,

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

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,

Line 67: p_attribute_category IN pa_project_subteams.attribute_category%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,

Line 68: p_attribute1 IN pa_project_subteams.attribute1%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,

Line 69: p_attribute2 IN pa_project_subteams.attribute2%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,

Line 70: p_attribute3 IN pa_project_subteams.attribute3%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,

Line 71: p_attribute4 IN pa_project_subteams.attribute4%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,

Line 72: p_attribute5 IN pa_project_subteams.attribute5%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,

Line 73: p_attribute6 IN pa_project_subteams.attribute6%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,

Line 74: p_attribute7 IN pa_project_subteams.attribute7%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,

Line 75: p_attribute8 IN pa_project_subteams.attribute8%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,

Line 76: p_attribute9 IN pa_project_subteams.attribute9%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,

Line 77: p_attribute10 IN pa_project_subteams.attribute10%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,

Line 78: p_attribute11 IN pa_project_subteams.attribute11%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,

Line 79: p_attribute12 IN pa_project_subteams.attribute12%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

Line 80: p_attribute13 IN pa_project_subteams.attribute13%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
84: x_return_status OUT NOCOPY VARCHAR2,

Line 81: p_attribute14 IN pa_project_subteams.attribute14%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,
85: x_msg_count OUT NOCOPY NUMBER,

Line 82: p_attribute15 IN pa_project_subteams.attribute15%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,
86: x_msg_data OUT NOCOPY VARCHAR2

Line 94: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,

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',

Line 95: p_commit IN VARCHAR2 := FND_API.g_false,

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',

Line 96: p_validate_only IN VARCHAR2 := FND_API.g_true,

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,

Line 97: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

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,

Line 100: p_max_msg_count IN NUMBER := FND_API.g_miss_num,

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,

Line 102: p_subteam_id IN pa_project_subteams.project_subteam_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 ,

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

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

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

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,

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

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,

Line 106: p_record_version_number IN NUMBER := FND_API.G_MISS_NUM ,

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

Line 117: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,

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:

Line 118: p_commit IN VARCHAR2 := FND_API.g_false,

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,

Line 120: p_validate_only IN VARCHAR2 := FND_API.g_true,

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

Line 122: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

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:

Line 129: p_max_msg_count IN NUMBER := FND_API.g_miss_num,

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:

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

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,

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

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: