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.

APPS.PA_PROJECT_SETS_PVT dependencies on PA_PROJECT_SETS_B

Line 7: ,p_party_id IN pa_project_sets_b.party_id%TYPE

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

Line 8: ,p_effective_start_date IN pa_project_sets_b.effective_start_date%TYPE

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

Line 9: ,p_effective_end_date IN pa_project_sets_b.effective_end_date%TYPE

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

Line 10: ,p_access_level IN pa_project_sets_b.access_level%TYPE

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

Line 13: ,p_attribute_category IN pa_project_sets_b.attribute_category%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

Line 14: ,p_attribute1 IN pa_project_sets_b.attribute1%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

Line 15: ,p_attribute2 IN pa_project_sets_b.attribute2%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

Line 16: ,p_attribute3 IN pa_project_sets_b.attribute3%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

Line 17: ,p_attribute4 IN pa_project_sets_b.attribute4%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

Line 18: ,p_attribute5 IN pa_project_sets_b.attribute5%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

Line 19: ,p_attribute6 IN pa_project_sets_b.attribute6%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

Line 20: ,p_attribute7 IN pa_project_sets_b.attribute7%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

Line 21: ,p_attribute8 IN pa_project_sets_b.attribute8%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

Line 22: ,p_attribute9 IN pa_project_sets_b.attribute9%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

Line 23: ,p_attribute10 IN pa_project_sets_b.attribute10%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

Line 24: ,p_attribute11 IN pa_project_sets_b.attribute11%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

Line 25: ,p_attribute12 IN pa_project_sets_b.attribute12%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

Line 26: ,p_attribute13 IN pa_project_sets_b.attribute13%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

Line 27: ,p_attribute14 IN pa_project_sets_b.attribute14%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: )

Line 28: ,p_attribute15 IN pa_project_sets_b.attribute15%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: IS

Line 29: ,x_project_set_id OUT NOCOPY pa_project_sets_b.project_set_id%TYPE --File.Sql.39 bug 4440895

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: IS
33: l_party_id pa_project_sets_b.party_id%TYPE := p_party_id;

Line 33: l_party_id pa_project_sets_b.party_id%TYPE := p_party_id;

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: IS
33: l_party_id pa_project_sets_b.party_id%TYPE := p_party_id;
34: l_return_status VARCHAR2(1);
35: l_unique VARCHAR2(1);
36: l_msg_count NUMBER;
37: l_msg_data VARCHAR2(240);

Line 149: ( p_project_set_id IN pa_project_sets_b.project_set_id%TYPE

145: END Create_Project_Set;
146:
147:
148: PROCEDURE update_project_set
149: ( p_project_set_id IN pa_project_sets_b.project_set_id%TYPE
150: ,p_project_set_name IN pa_project_sets_tl.name%TYPE
151: ,p_party_id IN pa_project_sets_b.party_id%TYPE
152: ,p_effective_start_date IN pa_project_sets_b.effective_start_date%TYPE
153: ,p_effective_end_date IN pa_project_sets_b.effective_end_date%TYPE

Line 151: ,p_party_id IN pa_project_sets_b.party_id%TYPE

147:
148: PROCEDURE update_project_set
149: ( p_project_set_id IN pa_project_sets_b.project_set_id%TYPE
150: ,p_project_set_name IN pa_project_sets_tl.name%TYPE
151: ,p_party_id IN pa_project_sets_b.party_id%TYPE
152: ,p_effective_start_date IN pa_project_sets_b.effective_start_date%TYPE
153: ,p_effective_end_date IN pa_project_sets_b.effective_end_date%TYPE
154: ,p_access_level IN pa_project_sets_b.access_level%TYPE
155: ,p_description IN pa_project_sets_tl.description%TYPE

Line 152: ,p_effective_start_date IN pa_project_sets_b.effective_start_date%TYPE

148: PROCEDURE update_project_set
149: ( p_project_set_id IN pa_project_sets_b.project_set_id%TYPE
150: ,p_project_set_name IN pa_project_sets_tl.name%TYPE
151: ,p_party_id IN pa_project_sets_b.party_id%TYPE
152: ,p_effective_start_date IN pa_project_sets_b.effective_start_date%TYPE
153: ,p_effective_end_date IN pa_project_sets_b.effective_end_date%TYPE
154: ,p_access_level IN pa_project_sets_b.access_level%TYPE
155: ,p_description IN pa_project_sets_tl.description%TYPE
156: ,p_party_name IN hz_parties.party_name%TYPE

Line 153: ,p_effective_end_date IN pa_project_sets_b.effective_end_date%TYPE

149: ( p_project_set_id IN pa_project_sets_b.project_set_id%TYPE
150: ,p_project_set_name IN pa_project_sets_tl.name%TYPE
151: ,p_party_id IN pa_project_sets_b.party_id%TYPE
152: ,p_effective_start_date IN pa_project_sets_b.effective_start_date%TYPE
153: ,p_effective_end_date IN pa_project_sets_b.effective_end_date%TYPE
154: ,p_access_level IN pa_project_sets_b.access_level%TYPE
155: ,p_description IN pa_project_sets_tl.description%TYPE
156: ,p_party_name IN hz_parties.party_name%TYPE
157: ,p_attribute_category IN pa_project_sets_b.attribute_category%TYPE

Line 154: ,p_access_level IN pa_project_sets_b.access_level%TYPE

150: ,p_project_set_name IN pa_project_sets_tl.name%TYPE
151: ,p_party_id IN pa_project_sets_b.party_id%TYPE
152: ,p_effective_start_date IN pa_project_sets_b.effective_start_date%TYPE
153: ,p_effective_end_date IN pa_project_sets_b.effective_end_date%TYPE
154: ,p_access_level IN pa_project_sets_b.access_level%TYPE
155: ,p_description IN pa_project_sets_tl.description%TYPE
156: ,p_party_name IN hz_parties.party_name%TYPE
157: ,p_attribute_category IN pa_project_sets_b.attribute_category%TYPE
158: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE

Line 157: ,p_attribute_category IN pa_project_sets_b.attribute_category%TYPE

153: ,p_effective_end_date IN pa_project_sets_b.effective_end_date%TYPE
154: ,p_access_level IN pa_project_sets_b.access_level%TYPE
155: ,p_description IN pa_project_sets_tl.description%TYPE
156: ,p_party_name IN hz_parties.party_name%TYPE
157: ,p_attribute_category IN pa_project_sets_b.attribute_category%TYPE
158: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE
159: ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE
160: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE
161: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE

Line 158: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE

154: ,p_access_level IN pa_project_sets_b.access_level%TYPE
155: ,p_description IN pa_project_sets_tl.description%TYPE
156: ,p_party_name IN hz_parties.party_name%TYPE
157: ,p_attribute_category IN pa_project_sets_b.attribute_category%TYPE
158: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE
159: ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE
160: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE
161: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE
162: ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE

Line 159: ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE

155: ,p_description IN pa_project_sets_tl.description%TYPE
156: ,p_party_name IN hz_parties.party_name%TYPE
157: ,p_attribute_category IN pa_project_sets_b.attribute_category%TYPE
158: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE
159: ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE
160: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE
161: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE
162: ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE
163: ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE

Line 160: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE

156: ,p_party_name IN hz_parties.party_name%TYPE
157: ,p_attribute_category IN pa_project_sets_b.attribute_category%TYPE
158: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE
159: ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE
160: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE
161: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE
162: ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE
163: ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE
164: ,p_attribute7 IN pa_project_sets_b.attribute7%TYPE

Line 161: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE

157: ,p_attribute_category IN pa_project_sets_b.attribute_category%TYPE
158: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE
159: ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE
160: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE
161: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE
162: ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE
163: ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE
164: ,p_attribute7 IN pa_project_sets_b.attribute7%TYPE
165: ,p_attribute8 IN pa_project_sets_b.attribute8%TYPE

Line 162: ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE

158: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE
159: ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE
160: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE
161: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE
162: ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE
163: ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE
164: ,p_attribute7 IN pa_project_sets_b.attribute7%TYPE
165: ,p_attribute8 IN pa_project_sets_b.attribute8%TYPE
166: ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE

Line 163: ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE

159: ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE
160: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE
161: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE
162: ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE
163: ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE
164: ,p_attribute7 IN pa_project_sets_b.attribute7%TYPE
165: ,p_attribute8 IN pa_project_sets_b.attribute8%TYPE
166: ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE
167: ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE

Line 164: ,p_attribute7 IN pa_project_sets_b.attribute7%TYPE

160: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE
161: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE
162: ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE
163: ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE
164: ,p_attribute7 IN pa_project_sets_b.attribute7%TYPE
165: ,p_attribute8 IN pa_project_sets_b.attribute8%TYPE
166: ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE
167: ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE
168: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE

Line 165: ,p_attribute8 IN pa_project_sets_b.attribute8%TYPE

161: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE
162: ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE
163: ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE
164: ,p_attribute7 IN pa_project_sets_b.attribute7%TYPE
165: ,p_attribute8 IN pa_project_sets_b.attribute8%TYPE
166: ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE
167: ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE
168: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE
169: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE

Line 166: ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE

162: ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE
163: ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE
164: ,p_attribute7 IN pa_project_sets_b.attribute7%TYPE
165: ,p_attribute8 IN pa_project_sets_b.attribute8%TYPE
166: ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE
167: ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE
168: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE
169: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE
170: ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE

Line 167: ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE

163: ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE
164: ,p_attribute7 IN pa_project_sets_b.attribute7%TYPE
165: ,p_attribute8 IN pa_project_sets_b.attribute8%TYPE
166: ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE
167: ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE
168: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE
169: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE
170: ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE
171: ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE

Line 168: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE

164: ,p_attribute7 IN pa_project_sets_b.attribute7%TYPE
165: ,p_attribute8 IN pa_project_sets_b.attribute8%TYPE
166: ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE
167: ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE
168: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE
169: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE
170: ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE
171: ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE
172: ,p_attribute15 IN pa_project_sets_b.attribute15%TYPE

Line 169: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE

165: ,p_attribute8 IN pa_project_sets_b.attribute8%TYPE
166: ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE
167: ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE
168: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE
169: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE
170: ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE
171: ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE
172: ,p_attribute15 IN pa_project_sets_b.attribute15%TYPE
173: ,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE

Line 170: ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE

166: ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE
167: ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE
168: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE
169: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE
170: ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE
171: ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE
172: ,p_attribute15 IN pa_project_sets_b.attribute15%TYPE
173: ,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE
174: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 171: ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE

167: ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE
168: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE
169: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE
170: ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE
171: ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE
172: ,p_attribute15 IN pa_project_sets_b.attribute15%TYPE
173: ,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE
174: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
175: )

Line 172: ,p_attribute15 IN pa_project_sets_b.attribute15%TYPE

168: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE
169: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE
170: ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE
171: ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE
172: ,p_attribute15 IN pa_project_sets_b.attribute15%TYPE
173: ,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE
174: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
175: )
176: IS

Line 173: ,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE

169: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE
170: ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE
171: ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE
172: ,p_attribute15 IN pa_project_sets_b.attribute15%TYPE
173: ,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE
174: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
175: )
176: IS
177: l_party_id pa_project_sets_b.party_id%TYPE := p_party_id;

Line 177: l_party_id pa_project_sets_b.party_id%TYPE := p_party_id;

173: ,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE
174: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
175: )
176: IS
177: l_party_id pa_project_sets_b.party_id%TYPE := p_party_id;
178: l_return_status VARCHAR2(1);
179: l_unique VARCHAR2(1);
180: l_msg_count NUMBER;
181: l_msg_data VARCHAR2(240);

Line 281: ( p_project_set_id IN pa_project_sets_b.project_set_id%TYPE

277: END Update_Project_Set;
278:
279:
280: PROCEDURE delete_project_set
281: ( p_project_set_id IN pa_project_sets_b.project_set_id%TYPE
282: ,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE
283: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
284: )
285: IS

Line 282: ,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE

278:
279:
280: PROCEDURE delete_project_set
281: ( p_project_set_id IN pa_project_sets_b.project_set_id%TYPE
282: ,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE
283: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
284: )
285: IS
286: l_return_status VARCHAR2(1);

Line 356: l_project_set_id PA_PROJECT_SETS_B.project_set_id%TYPE;

352: )
353: IS
354: l_return_status VARCHAR2(1);
355: l_exists VARCHAR2(1);
356: l_project_set_id PA_PROJECT_SETS_B.project_set_id%TYPE;
357: e_row_is_locked EXCEPTION;
358: PRAGMA EXCEPTION_INIT(e_row_is_locked, -54);
359: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
360:

Line 375: FROM pa_project_sets_b

371: END IF;
372:
373: SELECT project_set_id
374: INTO l_project_set_id
375: FROM pa_project_sets_b
376: WHERE project_set_id = p_project_set_id
377: FOR UPDATE NOWAIT;
378:
379: l_exists := PA_PROJECT_SET_UTILS.check_projects_in_set(