eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.PA_PROJECT_SETS_PVT

Source


1 PACKAGE pa_project_sets_pvt AUTHID CURRENT_USER AS
2 /*$Header: PAPPSPVS.pls 120.1 2005/08/19 16:43:52 mwasowic noship $*/
3 --+
4 
5 PROCEDURE create_project_set
6 ( p_project_set_name       IN    pa_project_sets_tl.name%TYPE
7  ,p_party_id               IN    pa_project_sets_b.party_id%TYPE
8  ,p_effective_start_date   IN    pa_project_sets_b.effective_start_date%TYPE
9  ,p_effective_end_date     IN    pa_project_sets_b.effective_end_date%TYPE
10  ,p_access_level           IN    pa_project_sets_b.access_level%TYPE
11  ,p_description            IN    pa_project_sets_tl.description%TYPE
12  ,p_party_name             IN    hz_parties.party_name%TYPE
13  ,p_attribute_category     IN    pa_project_sets_b.attribute_category%TYPE
14  ,p_attribute1             IN    pa_project_sets_b.attribute1%TYPE
15  ,p_attribute2             IN    pa_project_sets_b.attribute2%TYPE
16  ,p_attribute3             IN    pa_project_sets_b.attribute3%TYPE
17  ,p_attribute4             IN    pa_project_sets_b.attribute4%TYPE
18  ,p_attribute5             IN    pa_project_sets_b.attribute5%TYPE
19  ,p_attribute6             IN    pa_project_sets_b.attribute6%TYPE
20  ,p_attribute7             IN    pa_project_sets_b.attribute7%TYPE
21  ,p_attribute8             IN    pa_project_sets_b.attribute8%TYPE
22  ,p_attribute9             IN    pa_project_sets_b.attribute9%TYPE
23  ,p_attribute10            IN    pa_project_sets_b.attribute10%TYPE
24  ,p_attribute11            IN    pa_project_sets_b.attribute11%TYPE
25  ,p_attribute12            IN    pa_project_sets_b.attribute12%TYPE
26  ,p_attribute13            IN    pa_project_sets_b.attribute13%TYPE
27  ,p_attribute14            IN    pa_project_sets_b.attribute14%TYPE
28  ,p_attribute15            IN    pa_project_sets_b.attribute15%TYPE
29  ,x_project_set_id        OUT    NOCOPY pa_project_sets_b.project_set_id%TYPE           --File.Sql.39 bug 4440895
30  ,x_return_status         OUT    NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
31 );
32 
33 PROCEDURE update_project_set
34 ( p_project_set_id         IN    pa_project_sets_b.project_set_id%TYPE
35  ,p_project_set_name       IN    pa_project_sets_tl.name%TYPE
36  ,p_party_id               IN    pa_project_sets_b.party_id%TYPE
37  ,p_effective_start_date   IN    pa_project_sets_b.effective_start_date%TYPE
38  ,p_effective_end_date     IN    pa_project_sets_b.effective_end_date%TYPE
39  ,p_access_level           IN    pa_project_sets_b.access_level%TYPE
40  ,p_description            IN    pa_project_sets_tl.description%TYPE
41  ,p_party_name             IN    hz_parties.party_name%TYPE
42  ,p_attribute_category     IN    pa_project_sets_b.attribute_category%TYPE
43  ,p_attribute1             IN    pa_project_sets_b.attribute1%TYPE
44  ,p_attribute2             IN    pa_project_sets_b.attribute2%TYPE
45  ,p_attribute3             IN    pa_project_sets_b.attribute3%TYPE
46  ,p_attribute4             IN    pa_project_sets_b.attribute4%TYPE
47  ,p_attribute5             IN    pa_project_sets_b.attribute5%TYPE
48  ,p_attribute6             IN    pa_project_sets_b.attribute6%TYPE
49  ,p_attribute7             IN    pa_project_sets_b.attribute7%TYPE
50  ,p_attribute8             IN    pa_project_sets_b.attribute8%TYPE
51  ,p_attribute9             IN    pa_project_sets_b.attribute9%TYPE
52  ,p_attribute10            IN    pa_project_sets_b.attribute10%TYPE
53  ,p_attribute11            IN    pa_project_sets_b.attribute11%TYPE
54  ,p_attribute12            IN    pa_project_sets_b.attribute12%TYPE
55  ,p_attribute13            IN    pa_project_sets_b.attribute13%TYPE
56  ,p_attribute14            IN    pa_project_sets_b.attribute14%TYPE
57  ,p_attribute15            IN    pa_project_sets_b.attribute15%TYPE
58  ,p_record_version_number  IN    pa_project_sets_b.record_version_number%TYPE
59  ,x_return_status         OUT    NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
60 );
61 
62 PROCEDURE delete_project_set
63 (  p_project_set_id        IN  pa_project_sets_b.project_set_id%TYPE
64   ,p_record_version_number IN  pa_project_sets_b.record_version_number%TYPE
65   ,x_return_status        OUT  NOCOPY VARCHAR2   --File.Sql.39 bug 4440895
66 );
67 
68 
69 PROCEDURE create_project_set_line
70 (  p_project_set_id     IN   pa_project_set_lines.project_set_id%TYPE
71   ,p_project_id         IN   pa_project_set_lines.project_id%TYPE
72   ,x_return_status     OUT   NOCOPY VARCHAR2    --File.Sql.39 bug 4440895
73 );
74 
75 
76 PROCEDURE delete_project_set_line
77 (  p_project_set_id     IN   pa_project_set_lines.project_set_id%TYPE
78   ,p_project_id         IN   pa_project_set_lines.project_id%TYPE
79   ,x_return_status     OUT   NOCOPY VARCHAR2    --File.Sql.39 bug 4440895
80 );
81 
82 PROCEDURE delete_proj_from_proj_set
83 (  p_project_id         IN   pa_project_set_lines.project_id%TYPE
84   ,x_return_status     OUT   NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
85 );
86 
87 END PA_PROJECT_SETS_PVT;