APPS.PA_TEAM_TEMPLATES_PVT dependencies on PA_TEAM_TEMPLATES

Line 1: PACKAGE pa_team_templates_pvt AS

1: PACKAGE pa_team_templates_pvt AS
2: /*$Header: PARTPVTS.pls 120.1 2005/08/19 17:01:24 mwasowic noship $*/
3: --
4: PROCEDURE Start_Apply_Team_Template_WF
5: (p_team_template_id_tbl IN PA_TEAM_TEMPLATES_PUB.team_template_id_tbl

Line 5: (p_team_template_id_tbl IN PA_TEAM_TEMPLATES_PUB.team_template_id_tbl

1: PACKAGE pa_team_templates_pvt AS
2: /*$Header: PARTPVTS.pls 120.1 2005/08/19 17:01:24 mwasowic noship $*/
3: --
4: PROCEDURE Start_Apply_Team_Template_WF
5: (p_team_template_id_tbl IN PA_TEAM_TEMPLATES_PUB.team_template_id_tbl
6: ,p_project_id IN pa_projects_all.project_id%TYPE
7: ,p_project_start_date IN pa_projects_all.start_date%TYPE
8: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
9: ,p_use_project_location IN VARCHAR2 := 'N'

Line 8: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE

4: PROCEDURE Start_Apply_Team_Template_WF
5: (p_team_template_id_tbl IN PA_TEAM_TEMPLATES_PUB.team_template_id_tbl
6: ,p_project_id IN pa_projects_all.project_id%TYPE
7: ,p_project_start_date IN pa_projects_all.start_date%TYPE
8: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
9: ,p_use_project_location IN VARCHAR2 := 'N'
10: ,p_project_location_id IN pa_projects_all.location_id%TYPE := NULL
11: ,p_use_project_calendar IN VARCHAR2 := 'N'
12: ,p_project_calendar_id IN pa_projects_all.calendar_id%TYPE := NULL

Line 26: (p_team_template_id IN pa_team_templates.team_template_id%TYPE

22: p_result OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
23:
24:
25: PROCEDURE Apply_Team_Template
26: (p_team_template_id IN pa_team_templates.team_template_id%TYPE
27: ,p_project_id IN pa_projects_all.project_id%TYPE
28: ,p_project_start_date IN pa_projects_all.start_date%TYPE
29: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
30: ,p_use_project_location IN VARCHAR2 := 'N'

Line 29: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE

25: PROCEDURE Apply_Team_Template
26: (p_team_template_id IN pa_team_templates.team_template_id%TYPE
27: ,p_project_id IN pa_projects_all.project_id%TYPE
28: ,p_project_start_date IN pa_projects_all.start_date%TYPE
29: ,p_team_start_date IN pa_team_templates.team_start_date%TYPE := FND_API.G_MISS_DATE
30: ,p_use_project_location IN VARCHAR2 := 'N'
31: ,p_project_location_id IN pa_projects_all.location_id%TYPE := NULL
32: ,p_use_project_calendar IN VARCHAR2 := 'N'
33: ,p_project_calendar_id IN pa_projects_all.calendar_id%TYPE := NULL

Line 39: ( p_team_template_rec IN PA_TEAM_TEMPLATES_PUB.team_template_rec

35: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
36: );
37:
38: PROCEDURE Create_Team_Template
39: ( p_team_template_rec IN PA_TEAM_TEMPLATES_PUB.team_template_rec
40: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
41: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
42: ,x_team_template_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
43: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 48: ( p_team_template_rec IN PA_TEAM_TEMPLATES_PUB.team_template_rec

44: );
45:
46:
47: PROCEDURE Update_Team_Template
48: ( p_team_template_rec IN PA_TEAM_TEMPLATES_PUB.team_template_rec
49: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
50: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
51: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
52: );

Line 56: ( p_team_template_id IN pa_team_templates.team_template_id%TYPE

52: );
53:
54:
55: PROCEDURE Delete_Team_Template
56: ( p_team_template_id IN pa_team_templates.team_template_id%TYPE
57: ,p_record_version_number IN NUMBER
58: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
59: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
60: );

Line 62: END pa_team_templates_pvt;

58: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
59: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
60: );
61:
62: END pa_team_templates_pvt;