[Home] [Help]
PACKAGE: APPS.PA_PROJECT_SUBTEAMS_PKG
Source
1 PACKAGE PA_PROJECT_SUBTEAMS_pkg AS
2 /*$Header: PARTSTHS.pls 120.1 2005/08/19 17:01:58 mwasowic noship $*/
3
4 PROCEDURE Insert_Row
5 (
6 p_subteam_name IN pa_project_subteams.name%TYPE := FND_API.g_miss_char ,
7 p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
8 p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
9 p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char ,
10 p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char ,
11 p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.g_miss_char ,
12 p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.g_miss_char ,
13 p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.g_miss_char ,
14 p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.g_miss_char ,
15 p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.g_miss_char ,
16 p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.g_miss_char ,
17 p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.g_miss_char ,
18 p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.g_miss_char ,
19 p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.g_miss_char ,
20 p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.g_miss_char ,
21 p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.g_miss_char ,
22 p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.g_miss_char ,
23 p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.g_miss_char ,
24 p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.g_miss_char ,
25 p_attribute15 IN pa_project_subteams.attribute15%TYPE := FND_API.g_miss_char ,
26 x_subteam_row_id OUT NOCOPY ROWID, --File.Sql.39 bug 4440895
27 x_new_subteam_id OUT NOCOPY pa_project_subteams.project_subteam_id%TYPE, --File.Sql.39 bug 4440895
28 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
29 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
30 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
31 );
32
33
34 PROCEDURE Update_Row
35 (
36
37 p_subteam_row_id IN ROWID :=NULL,
38 p_subteam_id IN pa_project_subteams.project_subteam_id%TYPE,
39 p_record_version_number IN NUMBER := NULL,
40 p_subteam_name IN pa_project_subteams.name%TYPE:= FND_API.g_miss_char,
41 p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
42 p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
43 p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
44 p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char ,
45 p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.g_miss_char ,
46 p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.g_miss_char ,
47 p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.g_miss_char ,
48 p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.g_miss_char ,
49 p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.g_miss_char ,
50 p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.g_miss_char ,
51 p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.g_miss_char ,
52 p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.g_miss_char ,
53 p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.g_miss_char ,
54 p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.g_miss_char ,
55 p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.g_miss_char ,
56 p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.g_miss_char ,
57 p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.g_miss_char ,
58 p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.g_miss_char ,
59 p_attribute15 IN pa_project_subteams.attribute15%TYPE := FND_API.g_miss_char ,
60 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
61 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
62 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
63 );
64
65
66 PROCEDURE Delete_Row
67 ( p_subteam_row_id IN ROWID
68 ,p_subteam_id IN pa_project_subteams.project_subteam_id%TYPE
69 ,p_record_version_number IN NUMBER := NULL
70 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
71 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
72 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
73 );
74
75
76 END PA_PROJECT_SUBTEAMS_pkg;