DBA Data[Home] [Help]

PACKAGE: APPS.PA_TEAM_TEMPLATES_PVT

Source


1 PACKAGE pa_team_templates_pvt AUTHID CURRENT_USER 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'
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 
17 PROCEDURE Apply_Team_Template_WF
18 (p_item_type     IN        VARCHAR2,
19  p_item_key      IN        VARCHAR2,
20  p_actid         IN        NUMBER,
21  p_funcmode      IN        VARCHAR2,
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'
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 
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
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 );
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  );
61 
62 END pa_team_templates_pvt;