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_PKG dependencies on PA_PROJECT_SETS_B

Line 7: ,p_party_id IN pa_project_sets_b.party_id%TYPE

3: --+
4:
5: PROCEDURE insert_row
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 insert_row
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_attribute_category IN pa_project_sets_b.attribute_category%TYPE

Line 9: ,p_effective_end_date IN pa_project_sets_b.effective_end_date%TYPE

5: PROCEDURE insert_row
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_attribute_category IN pa_project_sets_b.attribute_category%TYPE
13: ,p_attribute1 IN pa_project_sets_b.attribute1%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_attribute_category IN pa_project_sets_b.attribute_category%TYPE
13: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE
14: ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE

Line 12: ,p_attribute_category IN pa_project_sets_b.attribute_category%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_attribute_category IN pa_project_sets_b.attribute_category%TYPE
13: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE
14: ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE
15: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE
16: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE

Line 13: ,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_attribute_category IN pa_project_sets_b.attribute_category%TYPE
13: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE
14: ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE
15: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE
16: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE
17: ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE

Line 14: ,p_attribute2 IN pa_project_sets_b.attribute2%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_attribute_category IN pa_project_sets_b.attribute_category%TYPE
13: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE
14: ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE
15: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE
16: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE
17: ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE
18: ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE

Line 15: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE

11: ,p_description IN pa_project_sets_tl.description%TYPE
12: ,p_attribute_category IN pa_project_sets_b.attribute_category%TYPE
13: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE
14: ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE
15: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE
16: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE
17: ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE
18: ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE
19: ,p_attribute7 IN pa_project_sets_b.attribute7%TYPE

Line 16: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE

12: ,p_attribute_category IN pa_project_sets_b.attribute_category%TYPE
13: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE
14: ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE
15: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE
16: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE
17: ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE
18: ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE
19: ,p_attribute7 IN pa_project_sets_b.attribute7%TYPE
20: ,p_attribute8 IN pa_project_sets_b.attribute8%TYPE

Line 17: ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE

13: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE
14: ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE
15: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE
16: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE
17: ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE
18: ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE
19: ,p_attribute7 IN pa_project_sets_b.attribute7%TYPE
20: ,p_attribute8 IN pa_project_sets_b.attribute8%TYPE
21: ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE

Line 18: ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE

14: ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE
15: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE
16: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE
17: ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE
18: ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE
19: ,p_attribute7 IN pa_project_sets_b.attribute7%TYPE
20: ,p_attribute8 IN pa_project_sets_b.attribute8%TYPE
21: ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE
22: ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE

Line 19: ,p_attribute7 IN pa_project_sets_b.attribute7%TYPE

15: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE
16: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE
17: ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE
18: ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE
19: ,p_attribute7 IN pa_project_sets_b.attribute7%TYPE
20: ,p_attribute8 IN pa_project_sets_b.attribute8%TYPE
21: ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE
22: ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE
23: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE

Line 20: ,p_attribute8 IN pa_project_sets_b.attribute8%TYPE

16: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE
17: ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE
18: ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE
19: ,p_attribute7 IN pa_project_sets_b.attribute7%TYPE
20: ,p_attribute8 IN pa_project_sets_b.attribute8%TYPE
21: ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE
22: ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE
23: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE
24: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE

Line 21: ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE

17: ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE
18: ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE
19: ,p_attribute7 IN pa_project_sets_b.attribute7%TYPE
20: ,p_attribute8 IN pa_project_sets_b.attribute8%TYPE
21: ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE
22: ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE
23: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE
24: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE
25: ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE

Line 22: ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE

18: ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE
19: ,p_attribute7 IN pa_project_sets_b.attribute7%TYPE
20: ,p_attribute8 IN pa_project_sets_b.attribute8%TYPE
21: ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE
22: ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE
23: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE
24: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE
25: ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE
26: ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE

Line 23: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE

19: ,p_attribute7 IN pa_project_sets_b.attribute7%TYPE
20: ,p_attribute8 IN pa_project_sets_b.attribute8%TYPE
21: ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE
22: ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE
23: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE
24: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE
25: ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE
26: ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE
27: ,p_attribute15 IN pa_project_sets_b.attribute15%TYPE

Line 24: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE

20: ,p_attribute8 IN pa_project_sets_b.attribute8%TYPE
21: ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE
22: ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE
23: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE
24: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE
25: ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE
26: ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE
27: ,p_attribute15 IN pa_project_sets_b.attribute15%TYPE
28: ,x_project_set_id OUT NOCOPY pa_project_sets_b.project_set_id%TYPE --File.Sql.39 bug 4440895

Line 25: ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE

21: ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE
22: ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE
23: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE
24: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE
25: ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE
26: ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE
27: ,p_attribute15 IN pa_project_sets_b.attribute15%TYPE
28: ,x_project_set_id OUT NOCOPY pa_project_sets_b.project_set_id%TYPE --File.Sql.39 bug 4440895
29: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 26: ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE

22: ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE
23: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE
24: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE
25: ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE
26: ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE
27: ,p_attribute15 IN pa_project_sets_b.attribute15%TYPE
28: ,x_project_set_id OUT NOCOPY pa_project_sets_b.project_set_id%TYPE --File.Sql.39 bug 4440895
29: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
30: );

Line 27: ,p_attribute15 IN pa_project_sets_b.attribute15%TYPE

23: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE
24: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE
25: ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE
26: ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE
27: ,p_attribute15 IN pa_project_sets_b.attribute15%TYPE
28: ,x_project_set_id OUT NOCOPY pa_project_sets_b.project_set_id%TYPE --File.Sql.39 bug 4440895
29: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
30: );
31:

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

24: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE
25: ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE
26: ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE
27: ,p_attribute15 IN pa_project_sets_b.attribute15%TYPE
28: ,x_project_set_id OUT NOCOPY pa_project_sets_b.project_set_id%TYPE --File.Sql.39 bug 4440895
29: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
30: );
31:
32:

Line 34: ( p_project_set_id IN pa_project_sets_b.project_set_id%TYPE

30: );
31:
32:
33: PROCEDURE update_row
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

Line 36: ,p_party_id IN pa_project_sets_b.party_id%TYPE

32:
33: PROCEDURE update_row
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

Line 37: ,p_effective_start_date IN pa_project_sets_b.effective_start_date%TYPE

33: PROCEDURE update_row
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_attribute_category IN pa_project_sets_b.attribute_category%TYPE

Line 38: ,p_effective_end_date IN pa_project_sets_b.effective_end_date%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_attribute_category IN pa_project_sets_b.attribute_category%TYPE
42: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE

Line 39: ,p_access_level IN pa_project_sets_b.access_level%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_attribute_category IN pa_project_sets_b.attribute_category%TYPE
42: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE
43: ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE

Line 41: ,p_attribute_category IN pa_project_sets_b.attribute_category%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_attribute_category IN pa_project_sets_b.attribute_category%TYPE
42: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE
43: ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE
44: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE
45: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE

Line 42: ,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_attribute_category IN pa_project_sets_b.attribute_category%TYPE
42: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE
43: ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE
44: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE
45: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE
46: ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE

Line 43: ,p_attribute2 IN pa_project_sets_b.attribute2%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_attribute_category IN pa_project_sets_b.attribute_category%TYPE
42: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE
43: ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE
44: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE
45: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE
46: ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE
47: ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE

Line 44: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE

40: ,p_description IN pa_project_sets_tl.description%TYPE
41: ,p_attribute_category IN pa_project_sets_b.attribute_category%TYPE
42: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE
43: ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE
44: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE
45: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE
46: ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE
47: ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE
48: ,p_attribute7 IN pa_project_sets_b.attribute7%TYPE

Line 45: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE

41: ,p_attribute_category IN pa_project_sets_b.attribute_category%TYPE
42: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE
43: ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE
44: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE
45: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE
46: ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE
47: ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE
48: ,p_attribute7 IN pa_project_sets_b.attribute7%TYPE
49: ,p_attribute8 IN pa_project_sets_b.attribute8%TYPE

Line 46: ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE

42: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE
43: ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE
44: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE
45: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE
46: ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE
47: ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE
48: ,p_attribute7 IN pa_project_sets_b.attribute7%TYPE
49: ,p_attribute8 IN pa_project_sets_b.attribute8%TYPE
50: ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE

Line 47: ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE

43: ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE
44: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE
45: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE
46: ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE
47: ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE
48: ,p_attribute7 IN pa_project_sets_b.attribute7%TYPE
49: ,p_attribute8 IN pa_project_sets_b.attribute8%TYPE
50: ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE
51: ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE

Line 48: ,p_attribute7 IN pa_project_sets_b.attribute7%TYPE

44: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE
45: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE
46: ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE
47: ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE
48: ,p_attribute7 IN pa_project_sets_b.attribute7%TYPE
49: ,p_attribute8 IN pa_project_sets_b.attribute8%TYPE
50: ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE
51: ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE
52: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE

Line 49: ,p_attribute8 IN pa_project_sets_b.attribute8%TYPE

45: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE
46: ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE
47: ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE
48: ,p_attribute7 IN pa_project_sets_b.attribute7%TYPE
49: ,p_attribute8 IN pa_project_sets_b.attribute8%TYPE
50: ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE
51: ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE
52: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE
53: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE

Line 50: ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE

46: ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE
47: ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE
48: ,p_attribute7 IN pa_project_sets_b.attribute7%TYPE
49: ,p_attribute8 IN pa_project_sets_b.attribute8%TYPE
50: ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE
51: ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE
52: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE
53: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE
54: ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE

Line 51: ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE

47: ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE
48: ,p_attribute7 IN pa_project_sets_b.attribute7%TYPE
49: ,p_attribute8 IN pa_project_sets_b.attribute8%TYPE
50: ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE
51: ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE
52: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE
53: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE
54: ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE
55: ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE

Line 52: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE

48: ,p_attribute7 IN pa_project_sets_b.attribute7%TYPE
49: ,p_attribute8 IN pa_project_sets_b.attribute8%TYPE
50: ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE
51: ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE
52: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE
53: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE
54: ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE
55: ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE
56: ,p_attribute15 IN pa_project_sets_b.attribute15%TYPE

Line 53: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE

49: ,p_attribute8 IN pa_project_sets_b.attribute8%TYPE
50: ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE
51: ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE
52: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE
53: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE
54: ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE
55: ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE
56: ,p_attribute15 IN pa_project_sets_b.attribute15%TYPE
57: ,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE

Line 54: ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE

50: ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE
51: ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE
52: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE
53: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE
54: ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE
55: ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE
56: ,p_attribute15 IN pa_project_sets_b.attribute15%TYPE
57: ,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE
58: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 55: ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE

51: ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE
52: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE
53: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE
54: ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE
55: ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE
56: ,p_attribute15 IN pa_project_sets_b.attribute15%TYPE
57: ,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE
58: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
59: );

Line 56: ,p_attribute15 IN pa_project_sets_b.attribute15%TYPE

52: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE
53: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE
54: ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE
55: ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE
56: ,p_attribute15 IN pa_project_sets_b.attribute15%TYPE
57: ,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE
58: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
59: );
60:

Line 57: ,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE

53: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE
54: ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE
55: ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE
56: ,p_attribute15 IN pa_project_sets_b.attribute15%TYPE
57: ,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE
58: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
59: );
60:
61:

Line 63: ( p_project_set_id IN pa_project_sets_b.project_set_id%TYPE

59: );
60:
61:
62: PROCEDURE delete_row
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:

Line 64: ,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE

60:
61:
62: PROCEDURE delete_row
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: PROCEDURE insert_row_lines