eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROJECT_SUBTEAMS_PVT dependencies on FND_API

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

3:
4: PROCEDURE Create_Subteam
5: (
6: p_api_version IN NUMBER := 1.0,
7: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
8: p_commit IN VARCHAR2 := FND_API.g_false,
9:
10: p_validate_only IN VARCHAR2 := FND_API.g_true,
11:

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

4: PROCEDURE Create_Subteam
5: (
6: p_api_version IN NUMBER := 1.0,
7: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
8: p_commit IN VARCHAR2 := FND_API.g_false,
9:
10: p_validate_only IN VARCHAR2 := FND_API.g_true,
11:
12: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

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

6: p_api_version IN NUMBER := 1.0,
7: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
8: p_commit IN VARCHAR2 := FND_API.g_false,
9:
10: p_validate_only IN VARCHAR2 := FND_API.g_true,
11:
12: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
13:
14: p_calling_module IN VARCHAR2

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

8: p_commit IN VARCHAR2 := FND_API.g_false,
9:
10: p_validate_only IN VARCHAR2 := FND_API.g_true,
11:
12: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
13:
14: p_calling_module IN VARCHAR2
15: := 'SELF_SERVICE',
16:

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

15: := 'SELF_SERVICE',
16:
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:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

81:
82: PROCEDURE Update_Subteam
83: (
84: p_api_version IN NUMBER := 1.0,
85: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
86: p_commit IN VARCHAR2 := FND_API.g_false,
87:
88: p_validate_only IN VARCHAR2 := FND_API.g_true,
89:

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

82: PROCEDURE Update_Subteam
83: (
84: p_api_version IN NUMBER := 1.0,
85: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
86: p_commit IN VARCHAR2 := FND_API.g_false,
87:
88: p_validate_only IN VARCHAR2 := FND_API.g_true,
89:
90: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

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

84: p_api_version IN NUMBER := 1.0,
85: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
86: p_commit IN VARCHAR2 := FND_API.g_false,
87:
88: p_validate_only IN VARCHAR2 := FND_API.g_true,
89:
90: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
91:
92: p_calling_module IN VARCHAR2

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

86: p_commit IN VARCHAR2 := FND_API.g_false,
87:
88: p_validate_only IN VARCHAR2 := FND_API.g_true,
89:
90: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
91:
92: p_calling_module IN VARCHAR2
93: := 'SELF_SERVICE',
94:

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

93: := 'SELF_SERVICE',
94:
95: p_debug_mode IN VARCHAR2 := 'N',
96:
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,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

161:
162: PROCEDURE Delete_Subteam
163: (
164: p_api_version IN NUMBER := 1.0,
165: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
166: p_commit IN VARCHAR2 := FND_API.g_false,
167:
168: p_validate_only IN VARCHAR2 := FND_API.g_true,
169:

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

162: PROCEDURE Delete_Subteam
163: (
164: p_api_version IN NUMBER := 1.0,
165: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
166: p_commit IN VARCHAR2 := FND_API.g_false,
167:
168: p_validate_only IN VARCHAR2 := FND_API.g_true,
169:
170: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

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

164: p_api_version IN NUMBER := 1.0,
165: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
166: p_commit IN VARCHAR2 := FND_API.g_false,
167:
168: p_validate_only IN VARCHAR2 := FND_API.g_true,
169:
170: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
171:
172: p_calling_module IN VARCHAR2

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

166: p_commit IN VARCHAR2 := FND_API.g_false,
167:
168: p_validate_only IN VARCHAR2 := FND_API.g_true,
169:
170: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
171:
172: p_calling_module IN VARCHAR2
173: := 'SELF_SERVICE',
174:

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

173: := 'SELF_SERVICE',
174:
175: p_debug_mode IN VARCHAR2 := 'N',
176:
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,

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

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

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

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
186: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
187: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

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

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

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

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

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