[Home] [Help]
PACKAGE: APPS.PA_TEAM_TEMPLATES_PUB
Source
4
1 PACKAGE pa_team_templates_pub AUTHID CURRENT_USER AS
2 /*$Header: PARTPUBS.pls 120.1 2005/08/19 17:01:16 mwasowic noship $*/
3 --
5 TYPE team_template_rec IS RECORD
6 (team_template_id pa_team_templates.team_template_id%TYPE := FND_API.G_MISS_NUM
7 ,record_version_number pa_team_templates.record_version_number%TYPE := FND_API.G_MISS_NUM
8 ,team_template_name pa_team_templates.team_template_name%TYPE := FND_API.G_MISS_CHAR
9 ,start_date_active pa_team_templates.start_date_active%TYPE := FND_API.G_MISS_DATE
10 ,end_date_active pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE
11 ,description pa_team_templates.description%TYPE := FND_API.G_MISS_CHAR
12 ,role_list_id pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
13 ,calendar_id pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
14 ,work_type_id pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
15 ,team_start_date pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
16 ,workflow_in_progress_flag pa_team_templates.workflow_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
17 ,attribute_category pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
21 ,attribute4 pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
18 ,attribute1 pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
19 ,attribute2 pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
20 ,attribute3 pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
22 ,attribute5 pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
23 ,attribute6 pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
24 ,attribute7 pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
25 ,attribute8 pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
26 ,attribute9 pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
27 ,attribute10 pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
28 ,attribute11 pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
29 ,attribute12 pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR
30 ,attribute13 pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR
31 ,attribute14 pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR
32 ,attribute15 pa_team_templates.attribute15%TYPE := FND_API.G_MISS_CHAR );
33
34
35 TYPE team_template_id_rec IS RECORD(
36 team_template_id pa_team_templates.team_template_id%TYPE);
37
38 TYPE team_template_id_tbl IS TABLE OF team_template_id_rec
39 INDEX BY BINARY_INTEGER;
40
41 g_team_template_id_tbl team_template_id_tbl;
42
43 PROCEDURE Execute_Apply_Team_Template
44 (p_team_template_id IN pa_team_templates.team_template_id%TYPE
45 ,p_project_id IN pa_projects_all.project_id%TYPE
46 ,p_project_start_date IN pa_projects_all.start_date%TYPE
47 ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
48 ,p_use_project_location IN VARCHAR2 := 'N'
49 ,p_project_location_id IN pa_projects_all.location_id%TYPE := NULL
50 ,p_use_project_calendar IN VARCHAR2 := 'N'
51 ,p_project_calendar_id IN pa_projects_all.calendar_id%TYPE := NULL
52 ,p_apply IN VARCHAR2 := 'Y'
53 ,p_api_version IN NUMBER := 1.0
54 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
55 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
56 ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
57 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
58 ,x_msg_count OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
59 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
60 );
61
62 PROCEDURE Apply_Team_Template
63 (p_team_template_id_tbl IN team_template_id_tbl
64 ,p_project_id IN pa_projects_all.project_id%TYPE
65 ,p_project_start_date IN pa_projects_all.start_date%TYPE
66 ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
67 ,p_use_project_location IN VARCHAR2 := 'N'
68 ,p_project_location_id IN pa_projects_all.location_id%TYPE := NULL
69 ,p_use_project_calendar IN VARCHAR2 := 'N'
70 ,p_project_calendar_id IN pa_projects_all.calendar_id%TYPE := NULL
71 ,p_api_version IN NUMBER := 1.0
72 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
73 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
74 ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
75 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
76 ,x_msg_count OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
77 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
78 );
79
80 PROCEDURE Execute_Create_Team_Template
81 (p_team_template_name IN pa_team_templates.team_template_name%TYPE
82 ,p_description IN pa_team_templates.description%TYPE := FND_API.G_MISS_CHAR
83 ,p_start_date_active IN pa_team_templates.start_date_active%TYPE
84 ,p_end_date_active IN pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE
85 ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
86 ,p_calendar_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
87 ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
88 ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
89 ,p_role_list_name IN pa_role_lists.name%TYPE := FND_API.G_MISS_CHAR
90 ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
91 ,p_team_start_date IN pa_team_templates.team_start_date%TYPE
92 ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
96 ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
93 ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
94 ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
95 ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
97 ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
98 ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
99 ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
100 ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
101 ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
102 ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
103 ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
104 ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR
105 ,p_attribute13 IN pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR
106 ,p_attribute14 IN pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR
107 ,p_attribute15 IN pa_team_templates.attribute15%TYPE := FND_API.G_MISS_CHAR
108 ,p_api_version IN NUMBER := 1.0
109 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
110 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
111 ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
112 ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
113 ,x_team_template_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
114 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
115 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
116 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
117 );
118
119 PROCEDURE Create_Team_Template
120 ( p_team_template_rec IN team_template_rec
121 ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
122 ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
123 ,p_role_list_name IN pa_role_lists.name%TYPE := FND_API.G_MISS_CHAR
124 ,p_api_version IN NUMBER := 1.0
125 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
126 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
127 ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
128 ,p_validate_only IN VARCHAR2 := FND_API.G_FAlSE
129 ,x_team_template_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
130 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
131 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
132 ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
133
134
135 PROCEDURE Execute_Update_Team_Template
136 ( p_team_template_id IN pa_team_templates.team_template_id%TYPE
137 ,p_record_version_number IN pa_team_templates.record_version_number%TYPE
138 ,p_team_template_name IN pa_team_templates.team_template_name%TYPE := FND_API.G_MISS_CHAR
139 ,p_description IN pa_team_templates.description%TYPE := FND_API.G_MISS_CHAR
140 ,p_start_date_active IN pa_team_templates.start_date_active%TYPE := FND_API.G_MISS_DATE
141 ,p_end_date_active IN pa_team_templates.end_date_active%TYPE := FND_API.G_MISS_DATE
142 ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
143 ,p_calendar_id IN pa_team_templates.calendar_id%TYPE := FND_API.G_MISS_NUM
144 ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
145 ,p_work_type_id IN pa_team_templates.work_type_id%TYPE := FND_API.G_MISS_NUM
146 ,p_role_list_name IN pa_role_lists.name%TYPE := FND_API.G_MISS_CHAR
147 ,p_role_list_id IN pa_team_templates.role_list_id%TYPE := FND_API.G_MISS_NUM
148 ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
149 ,p_workflow_in_progress_flag IN pa_team_templates.workflow_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
150 ,p_attribute_category IN pa_team_templates.attribute_category%TYPE := FND_API.G_MISS_CHAR
151 ,p_attribute1 IN pa_team_templates.attribute1%TYPE := FND_API.G_MISS_CHAR
152 ,p_attribute2 IN pa_team_templates.attribute2%TYPE := FND_API.G_MISS_CHAR
153 ,p_attribute3 IN pa_team_templates.attribute3%TYPE := FND_API.G_MISS_CHAR
154 ,p_attribute4 IN pa_team_templates.attribute4%TYPE := FND_API.G_MISS_CHAR
155 ,p_attribute5 IN pa_team_templates.attribute5%TYPE := FND_API.G_MISS_CHAR
156 ,p_attribute6 IN pa_team_templates.attribute6%TYPE := FND_API.G_MISS_CHAR
160 ,p_attribute10 IN pa_team_templates.attribute10%TYPE := FND_API.G_MISS_CHAR
157 ,p_attribute7 IN pa_team_templates.attribute7%TYPE := FND_API.G_MISS_CHAR
158 ,p_attribute8 IN pa_team_templates.attribute8%TYPE := FND_API.G_MISS_CHAR
159 ,p_attribute9 IN pa_team_templates.attribute9%TYPE := FND_API.G_MISS_CHAR
161 ,p_attribute11 IN pa_team_templates.attribute11%TYPE := FND_API.G_MISS_CHAR
162 ,p_attribute12 IN pa_team_templates.attribute12%TYPE := FND_API.G_MISS_CHAR
163 ,p_attribute13 IN pa_team_templates.attribute13%TYPE := FND_API.G_MISS_CHAR
164 ,p_attribute14 IN pa_team_templates.attribute14%TYPE := FND_API.G_MISS_CHAR
165 ,p_attribute15 IN pa_team_templates.attribute15%TYPE := FND_API.G_MISS_CHAR
166 ,p_api_version IN NUMBER := 1.0
167 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
168 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
169 ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
170 ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
171 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
172 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
173 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
174 );
175
176
177 PROCEDURE Update_Team_Template
178 ( p_team_template_rec IN team_template_rec
179 ,p_calendar_name IN jtf_calendars_tl.calendar_name%TYPE := FND_API.G_MISS_CHAR
180 ,p_work_type_name IN pa_work_types_vl.name%TYPE := FND_API.G_MISS_CHAR
181 ,p_role_list_name IN pa_role_lists.name%TYPE := FND_API.G_MISS_CHAR
182 ,p_api_version IN NUMBER := 1.0
183 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
184 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
185 ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
186 ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
187 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
188 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
189 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
190 );
191
192 PROCEDURE Delete_Team_Template
193 ( p_team_template_id IN pa_team_templates.team_template_id%TYPE
194 ,p_record_version_number IN NUMBER
195 ,p_api_version IN NUMBER := 1
196 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
197 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
198 ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
199 ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
200 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
201 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
202 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
203 );
204
205 END pa_team_templates_pub;