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: IS

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: IS
32: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

Line 45: INSERT INTO pa_project_sets_b

41: ,x_msg => 'Beginning of insert row'
42: ,x_log_level => 5);
43: END IF;
44:
45: INSERT INTO pa_project_sets_b
46: (project_set_id
47: ,party_id
48: ,effective_start_date
49: ,effective_end_date

Line 74: ( pa_project_sets_b_s.NEXTVAL

70: ,last_update_date
71: ,last_updated_by
72: ,last_update_login)
73: VALUES
74: ( pa_project_sets_b_s.NEXTVAL
75: ,p_party_id
76: ,p_effective_start_date
77: ,p_effective_end_date
78: ,p_access_level

Line 149: ( p_project_set_id IN pa_project_sets_b.project_set_id%TYPE

145: END Insert_Row;
146:
147:
148: PROCEDURE update_row
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_row
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_row
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_attribute_category IN pa_project_sets_b.attribute_category%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_attribute_category IN pa_project_sets_b.attribute_category%TYPE
157: ,p_attribute1 IN pa_project_sets_b.attribute1%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_attribute_category IN pa_project_sets_b.attribute_category%TYPE
157: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE
158: ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE

Line 156: ,p_attribute_category IN pa_project_sets_b.attribute_category%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_attribute_category IN pa_project_sets_b.attribute_category%TYPE
157: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE
158: ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE
159: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE
160: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE

Line 157: ,p_attribute1 IN pa_project_sets_b.attribute1%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_attribute_category IN pa_project_sets_b.attribute_category%TYPE
157: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE
158: ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE
159: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE
160: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE
161: ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE

Line 158: ,p_attribute2 IN pa_project_sets_b.attribute2%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_attribute_category IN pa_project_sets_b.attribute_category%TYPE
157: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE
158: ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE
159: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE
160: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE
161: ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE
162: ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE

Line 159: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE

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

Line 160: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE

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

Line 161: ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE

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

Line 162: ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE

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

Line 163: ,p_attribute7 IN pa_project_sets_b.attribute7%TYPE

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

Line 164: ,p_attribute8 IN pa_project_sets_b.attribute8%TYPE

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

Line 165: ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE

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

Line 166: ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE

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

Line 167: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE

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

Line 168: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE

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

Line 169: ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE

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

Line 170: ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE

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

Line 171: ,p_attribute15 IN pa_project_sets_b.attribute15%TYPE

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

Line 172: ,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE

168: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE
169: ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE
170: ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE
171: ,p_attribute15 IN pa_project_sets_b.attribute15%TYPE
172: ,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE
173: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
174: )
175: IS
176: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

Line 189: UPDATE pa_project_sets_b

185: ,x_msg => 'Beginning of update row'
186: ,x_log_level => 5);
187: END IF;
188:
189: UPDATE pa_project_sets_b
190: SET party_id = decode(p_party_id, FND_API.G_MISS_NUM, party_id, p_party_id)
191: ,effective_start_date = decode(p_effective_start_date, FND_API.G_MISS_DATE, effective_start_date, p_effective_start_date)
192: ,effective_end_date = decode(p_effective_end_date, FND_API.G_MISS_DATE, effective_end_date, p_effective_end_date)
193: ,access_level = decode(p_access_level, FND_API.G_MISS_NUM, access_level, p_access_level)

Line 252: ( p_project_set_id IN pa_project_sets_b.project_set_id%TYPE

248: END update_row;
249:
250:
251: PROCEDURE delete_row
252: ( p_project_set_id IN pa_project_sets_b.project_set_id%TYPE
253: ,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE
254: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
255: )
256: IS

Line 253: ,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE

249:
250:
251: PROCEDURE delete_row
252: ( p_project_set_id IN pa_project_sets_b.project_set_id%TYPE
253: ,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE
254: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
255: )
256: IS
257: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

Line 263: DELETE FROM pa_project_sets_b

259:
260: -- Initialize the return status to success
261: x_return_status := FND_API.G_RET_STS_SUCCESS;
262:
263: DELETE FROM pa_project_sets_b
264: WHERE project_set_id = p_project_set_id
265: AND nvl(p_record_version_number, record_version_number) = record_version_number;
266:
267: IF (SQL%NOTFOUND) THEN

Line 387: from PA_PROJECT_SETS_B B

383: begin
384: delete from PA_PROJECT_SETS_TL T
385: where not exists
386: (select NULL
387: from PA_PROJECT_SETS_B B
388: where B.PROJECT_SET_ID = T.PROJECT_SET_ID
389: );
390:
391: update PA_PROJECT_SETS_TL T set (