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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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: );
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:
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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: );
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:
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
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:
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: