[Home] [Help]
PACKAGE: APPS.PA_PROJECT_SETS_PUB
Source
1 PACKAGE pa_project_sets_pub AUTHID CURRENT_USER AS
2 /*$Header: PAPPSPUS.pls 120.1 2005/08/19 16:43:45 mwasowic noship $*/
3 --
4 PROCEDURE create_project_set
5 ( p_project_set_name IN pa_project_sets_tl.name%TYPE
6 ,p_party_id IN pa_project_sets_b.party_id%TYPE
7 ,p_effective_start_date IN pa_project_sets_b.effective_start_date%TYPE
8 ,p_effective_end_date IN pa_project_sets_b.effective_end_date%TYPE := NULL
9 ,p_access_level IN pa_project_sets_b.access_level%TYPE
10 ,p_description IN pa_project_sets_tl.description%TYPE := NULL
11 ,p_party_name IN hz_parties.party_name%TYPE
12 ,p_attribute_category IN pa_project_sets_b.attribute_category%TYPE := NULL
13 ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE := NULL
14 ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE := NULL
15 ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE := NULL
16 ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE := NULL
17 ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE := NULL
18 ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE := NULL
19 ,p_attribute7 IN pa_project_sets_b.attribute7%TYPE := NULL
20 ,p_attribute8 IN pa_project_sets_b.attribute8%TYPE := NULL
21 ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE := NULL
22 ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE := NULL
23 ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE := NULL
24 ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE := NULL
25 ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE := NULL
26 ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE := NULL
27 ,p_attribute15 IN pa_project_sets_b.attribute15%TYPE := NULL
28 ,p_api_version IN NUMBER := 1.0
29 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
30 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
31 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
32 ,x_project_set_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
33 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
34 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
35 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
36 );
37
38 PROCEDURE update_project_set
39 (p_project_set_id IN pa_project_sets_b.project_set_id%TYPE
40 ,p_project_set_name IN pa_project_sets_tl.name%TYPE := FND_API.G_MISS_CHAR
41 ,p_party_id IN pa_project_sets_b.party_id%TYPE := FND_API.G_MISS_NUM
42 ,p_effective_start_date IN pa_project_sets_b.effective_start_date%TYPE := FND_API.G_MISS_DATE
43 ,p_effective_end_date IN pa_project_sets_b.effective_end_date%TYPE := FND_API.G_MISS_DATE
44 ,p_access_level IN pa_project_sets_b.access_level%TYPE := FND_API.G_MISS_NUM
45 ,p_description IN pa_project_sets_tl.description%TYPE := FND_API.G_MISS_CHAR
46 ,p_party_name IN hz_parties.party_name%TYPE := FND_API.G_MISS_CHAR
47 ,p_attribute_category IN pa_project_sets_b.attribute_category%TYPE := FND_API.G_MISS_CHAR
48 ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE := FND_API.G_MISS_CHAR
49 ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE := FND_API.G_MISS_CHAR
50 ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE := FND_API.G_MISS_CHAR
51 ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE := FND_API.G_MISS_CHAR
52 ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE := FND_API.G_MISS_CHAR
53 ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE := FND_API.G_MISS_CHAR
54 ,p_attribute7 IN pa_project_sets_b.attribute7%TYPE := FND_API.G_MISS_CHAR
55 ,p_attribute8 IN pa_project_sets_b.attribute8%TYPE := FND_API.G_MISS_CHAR
56 ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE := FND_API.G_MISS_CHAR
57 ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE := FND_API.G_MISS_CHAR
58 ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE := FND_API.G_MISS_CHAR
59 ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE := FND_API.G_MISS_CHAR
60 ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE := FND_API.G_MISS_CHAR
61 ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE := FND_API.G_MISS_CHAR
62 ,p_attribute15 IN pa_project_sets_b.attribute15%TYPE := FND_API.G_MISS_CHAR
63 ,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE := NULL
64 ,p_api_version IN NUMBER := 1.0
65 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
66 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
67 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
68 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
69 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
70 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
71 );
72
73
74 PROCEDURE delete_project_set
75 (p_project_set_id IN pa_project_sets_b.project_set_id%TYPE := NULL
76 ,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE := NULL
77 ,p_api_version IN NUMBER := 1.0
78 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
79 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
80 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
81 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
82 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
83 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
84 );
85
86
87 PROCEDURE create_project_set_line
88 (p_project_set_id IN pa_project_set_lines.project_set_id%TYPE
89 ,p_project_id IN pa_project_set_lines.project_id%TYPE
90 ,p_api_version IN NUMBER := 1.0
91 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
92 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
93 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
94 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
95 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
96 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
97 );
98
99
100 PROCEDURE delete_project_set_line
101 (p_project_set_id IN pa_project_set_lines.project_set_id%TYPE
102 ,p_project_id IN pa_project_set_lines.project_id%TYPE
103 ,p_api_version IN NUMBER := 1.0
104 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
105 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
106 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
107 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
108 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
109 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
110 );
111
112 procedure party_merge(
113 p_entity_name IN varchar2
114 ,p_from_id IN number
115 ,p_to_id in OUT nocopy number
116 ,p_from_fk_id IN number
117 ,p_to_fk_id IN number
118 ,p_parent_entity_name IN varchar2
119 ,p_batch_id IN number
120 ,p_batch_party_id IN number
121 ,p_return_status IN OUT nocopy varchar2
122 );
123
124 END;