DBA Data[Home] [Help]

APPS.PA_PROJECT_SUBTEAM_PARTIES_PKG dependencies on PA_PROJECT_SUBTEAM_PARTIES

Line 1: PACKAGE pa_project_subteam_parties_pkg AS

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

Line 9: p_object_type IN pa_project_subteam_parties.object_type%TYPE := FND_API.g_miss_char,

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',

Line 11: p_object_id IN pa_project_subteam_parties.object_id%TYPE := fnd_api.g_miss_num,

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

Line 13: p_primary_subteam_flag IN pa_project_subteam_parties.primary_subteam_flag%TYPE := 'Y',

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

Line 17: x_project_subteam_party_id OUT NOCOPY pa_project_subteam_parties.project_subteam_party_id%TYPE, --File.Sql.39 bug 4440895

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

Line 30: p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE,

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,

Line 38: p_primary_subteam_flag IN pa_project_subteam_parties.primary_subteam_flag%TYPE := 'Y',

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

Line 52: ,p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE

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

Line 59: END PA_PROJECT_SUBTEAM_PARTIES_pkg;

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;