[Home] [Help]
PACKAGE: APPS.PA_PROJECT_SUBTEAMS_PUB
Source
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 (
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,
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,
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,
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,
43 x_msg_count OUT NOCOPY NUMBER,
44 x_msg_data OUT NOCOPY VARCHAR2
45 --Bug: 4537865
46 );
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',
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,
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,
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,
83 --Bug: 4537865
84 x_return_status OUT NOCOPY VARCHAR2,
85 x_msg_count OUT NOCOPY NUMBER,
86 x_msg_data OUT NOCOPY VARCHAR2
87 --Bug: 4537865
88 );
89
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',
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
108 x_return_status OUT NOCOPY VARCHAR2,
109 x_msg_count OUT NOCOPY NUMBER,
110 x_msg_data OUT NOCOPY VARCHAR2
111 --Bug: 4537865
112 );
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
122 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
123
124 p_calling_module IN VARCHAR2
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
134 --Bug: 4537865
135 x_return_status OUT NOCOPY VARCHAR2,
136
137 x_msg_count OUT NOCOPY NUMBER,
138
139 x_msg_data OUT NOCOPY VARCHAR2
140 --Bug: 4537865
141 ) ;
142
143 END PA_PROJECT_SUBTEAMS_PUB;