PACKAGE: APPS.PA_PROJECT_SUBTEAM_PARTIES_PKG

Source

1 PACKAGE pa_project_subteam_parties_pkg AS
2 --$Header: PARTSPHS.pls 120.1 2005/08/19 17:01:41 mwasowic noship $
3 
4 
5 PROCEDURE Insert_Row
6 (
7  p_project_subteam_id     IN pa_project_subteams.Project_subteam_id%TYPE := FND_API.g_miss_num,
8 
9  p_object_type            IN pa_project_subteam_parties.object_type%TYPE := FND_API.g_miss_char,
10 
11  p_object_id              IN pa_project_subteam_parties.object_id%TYPE := fnd_api.g_miss_num,
12 
13  p_primary_subteam_flag           IN pa_project_subteam_parties.primary_subteam_flag%TYPE := 'Y',
14 
15  x_project_subteam_party_row_id   OUT  NOCOPY ROWID, --File.Sql.39 bug 4440895
16 
17  x_project_subteam_party_id       OUT  NOCOPY pa_project_subteam_parties.project_subteam_party_id%TYPE, --File.Sql.39 bug 4440895
18 
19  x_return_status          OUT  NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
20 
21  x_msg_count              OUT    NOCOPY NUMBER, --File.Sql.39 bug 4440895
22 
23  x_msg_data               OUT    NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
24 );
25 
26 PROCEDURE Update_Row
27 (
28  p_project_subteam_party_row_id   IN   ROWID :=NULL,
29 
30  p_project_subteam_party_id       IN   pa_project_subteam_parties.project_subteam_party_id%TYPE,
31 
32  p_project_subteam_id     IN   pa_project_subteams.project_subteam_id%TYPE,
33 
34 -- p_object_type            IN varchar2,
35 
36 -- p_object_id              IN NUMBER := fnd_api.g_miss_num,
37 
38  p_primary_subteam_flag            IN  pa_project_subteam_parties.primary_subteam_flag%TYPE := 'Y',
39 
40  p_record_version_number  IN NUMBER   := NULL,
41 
42  x_return_status          OUT  NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
43 
44  x_msg_count              OUT  NOCOPY NUMBER, --File.Sql.39 bug 4440895
45 
46  x_msg_data               OUT  NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
47 );
48 
49 PROCEDURE Delete_Row
50 (
51   p_project_subteam_party_row_id       IN   ROWID
52  ,p_project_subteam_party_id            IN   pa_project_subteam_parties.project_subteam_party_id%TYPE
53  ,p_record_version_number       IN   NUMBER  := NULL
54  ,x_return_status               OUT  NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
55  ,x_msg_count                   OUT  NOCOPY NUMBER --File.Sql.39 bug 4440895
56  ,x_msg_data                    OUT  NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
57 ) ;
58 
59 END PA_PROJECT_SUBTEAM_PARTIES_pkg;