DBA Data[Home] [Help]

APPS.PA_TEAM_TEMPLATES_PVT dependencies on PA_PROJECTS_ALL

Line 6: ,p_project_id IN pa_projects_all.project_id%TYPE

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'
10: ,p_project_location_id IN pa_projects_all.location_id%TYPE := NULL

Line 7: ,p_project_start_date IN pa_projects_all.start_date%TYPE

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'
10: ,p_project_location_id IN pa_projects_all.location_id%TYPE := NULL
11: ,p_use_project_calendar IN VARCHAR2 := 'N'

Line 10: ,p_project_location_id IN pa_projects_all.location_id%TYPE := NULL

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
13: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
14: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 12: ,p_project_calendar_id IN pa_projects_all.calendar_id%TYPE := NULL

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
13: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
14: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
15: );
16:

Line 27: ,p_project_id IN pa_projects_all.project_id%TYPE

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'
31: ,p_project_location_id IN pa_projects_all.location_id%TYPE := NULL

Line 28: ,p_project_start_date IN pa_projects_all.start_date%TYPE

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'
31: ,p_project_location_id IN pa_projects_all.location_id%TYPE := NULL
32: ,p_use_project_calendar IN VARCHAR2 := 'N'

Line 31: ,p_project_location_id IN pa_projects_all.location_id%TYPE := NULL

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
34: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
35: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 33: ,p_project_calendar_id IN pa_projects_all.calendar_id%TYPE := NULL

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
34: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
35: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
36: );
37: