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_PUB 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 := NULL
10: ,p_access_level IN pa_project_sets_b.access_level%TYPE
11: ,p_description IN pa_project_sets_tl.description%TYPE := NULL

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 := NULL
10: ,p_access_level IN pa_project_sets_b.access_level%TYPE
11: ,p_description IN pa_project_sets_tl.description%TYPE := NULL
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 := NULL

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 := NULL
10: ,p_access_level IN pa_project_sets_b.access_level%TYPE
11: ,p_description IN pa_project_sets_tl.description%TYPE := NULL
12: ,p_party_name IN hz_parties.party_name%TYPE
13: ,p_attribute_category IN pa_project_sets_b.attribute_category%TYPE := NULL

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 := NULL
10: ,p_access_level IN pa_project_sets_b.access_level%TYPE
11: ,p_description IN pa_project_sets_tl.description%TYPE := NULL
12: ,p_party_name IN hz_parties.party_name%TYPE
13: ,p_attribute_category IN pa_project_sets_b.attribute_category%TYPE := NULL
14: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE := NULL

Line 13: ,p_attribute_category IN pa_project_sets_b.attribute_category%TYPE := NULL

9: ,p_effective_end_date IN pa_project_sets_b.effective_end_date%TYPE := NULL
10: ,p_access_level IN pa_project_sets_b.access_level%TYPE
11: ,p_description IN pa_project_sets_tl.description%TYPE := NULL
12: ,p_party_name IN hz_parties.party_name%TYPE
13: ,p_attribute_category IN pa_project_sets_b.attribute_category%TYPE := NULL
14: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE := NULL
15: ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE := NULL
16: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE := NULL
17: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE := NULL

Line 14: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE := NULL

10: ,p_access_level IN pa_project_sets_b.access_level%TYPE
11: ,p_description IN pa_project_sets_tl.description%TYPE := NULL
12: ,p_party_name IN hz_parties.party_name%TYPE
13: ,p_attribute_category IN pa_project_sets_b.attribute_category%TYPE := NULL
14: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE := NULL
15: ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE := NULL
16: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE := NULL
17: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE := NULL
18: ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE := NULL

Line 15: ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE := NULL

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

Line 16: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE := NULL

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

Line 17: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE := NULL

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

Line 18: ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE := NULL

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

Line 19: ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE := NULL

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

Line 20: ,p_attribute7 IN pa_project_sets_b.attribute7%TYPE := NULL

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

Line 21: ,p_attribute8 IN pa_project_sets_b.attribute8%TYPE := NULL

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

Line 22: ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE := NULL

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

Line 23: ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE := NULL

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

Line 24: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE := NULL

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

Line 25: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE := NULL

21: ,p_attribute8 IN pa_project_sets_b.attribute8%TYPE := NULL
22: ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE := NULL
23: ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE := NULL
24: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE := NULL
25: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE := NULL
26: ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE := NULL
27: ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE := NULL
28: ,p_attribute15 IN pa_project_sets_b.attribute15%TYPE := NULL
29: ,p_api_version IN NUMBER := 1.0

Line 26: ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE := NULL

22: ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE := NULL
23: ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE := NULL
24: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE := NULL
25: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE := NULL
26: ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE := NULL
27: ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE := NULL
28: ,p_attribute15 IN pa_project_sets_b.attribute15%TYPE := NULL
29: ,p_api_version IN NUMBER := 1.0
30: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

Line 27: ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE := NULL

23: ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE := NULL
24: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE := NULL
25: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE := NULL
26: ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE := NULL
27: ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE := NULL
28: ,p_attribute15 IN pa_project_sets_b.attribute15%TYPE := NULL
29: ,p_api_version IN NUMBER := 1.0
30: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
31: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 28: ,p_attribute15 IN pa_project_sets_b.attribute15%TYPE := NULL

24: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE := NULL
25: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE := NULL
26: ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE := NULL
27: ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE := NULL
28: ,p_attribute15 IN pa_project_sets_b.attribute15%TYPE := NULL
29: ,p_api_version IN NUMBER := 1.0
30: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
31: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
32: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

Line 150: (p_project_set_id IN pa_project_sets_b.project_set_id%TYPE

146: END create_project_set;
147:
148:
149: PROCEDURE update_project_set
150: (p_project_set_id IN pa_project_sets_b.project_set_id%TYPE
151: ,p_project_set_name IN pa_project_sets_tl.name%TYPE := FND_API.G_MISS_CHAR
152: ,p_party_id IN pa_project_sets_b.party_id%TYPE := FND_API.G_MISS_NUM
153: ,p_effective_start_date IN pa_project_sets_b.effective_start_date%TYPE := FND_API.G_MISS_DATE
154: ,p_effective_end_date IN pa_project_sets_b.effective_end_date%TYPE := FND_API.G_MISS_DATE

Line 152: ,p_party_id IN pa_project_sets_b.party_id%TYPE := FND_API.G_MISS_NUM

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

Line 153: ,p_effective_start_date IN pa_project_sets_b.effective_start_date%TYPE := FND_API.G_MISS_DATE

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

Line 154: ,p_effective_end_date IN pa_project_sets_b.effective_end_date%TYPE := FND_API.G_MISS_DATE

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

Line 155: ,p_access_level IN pa_project_sets_b.access_level%TYPE := FND_API.G_MISS_NUM

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

Line 158: ,p_attribute_category IN pa_project_sets_b.attribute_category%TYPE := FND_API.G_MISS_CHAR

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

Line 159: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE := FND_API.G_MISS_CHAR

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

Line 160: ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE := FND_API.G_MISS_CHAR

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

Line 161: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE := FND_API.G_MISS_CHAR

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

Line 162: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE := FND_API.G_MISS_CHAR

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

Line 163: ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE := FND_API.G_MISS_CHAR

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

Line 164: ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE := FND_API.G_MISS_CHAR

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

Line 165: ,p_attribute7 IN pa_project_sets_b.attribute7%TYPE := FND_API.G_MISS_CHAR

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

Line 166: ,p_attribute8 IN pa_project_sets_b.attribute8%TYPE := FND_API.G_MISS_CHAR

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

Line 167: ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE := FND_API.G_MISS_CHAR

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

Line 168: ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE := FND_API.G_MISS_CHAR

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

Line 169: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE := FND_API.G_MISS_CHAR

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

Line 170: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE := FND_API.G_MISS_CHAR

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

Line 171: ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE := FND_API.G_MISS_CHAR

167: ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE := FND_API.G_MISS_CHAR
168: ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE := FND_API.G_MISS_CHAR
169: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE := FND_API.G_MISS_CHAR
170: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE := FND_API.G_MISS_CHAR
171: ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE := FND_API.G_MISS_CHAR
172: ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE := FND_API.G_MISS_CHAR
173: ,p_attribute15 IN pa_project_sets_b.attribute15%TYPE := FND_API.G_MISS_CHAR
174: ,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE := NULL
175: ,p_api_version IN NUMBER := 1.0

Line 172: ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE := FND_API.G_MISS_CHAR

168: ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE := FND_API.G_MISS_CHAR
169: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE := FND_API.G_MISS_CHAR
170: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE := FND_API.G_MISS_CHAR
171: ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE := FND_API.G_MISS_CHAR
172: ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE := FND_API.G_MISS_CHAR
173: ,p_attribute15 IN pa_project_sets_b.attribute15%TYPE := FND_API.G_MISS_CHAR
174: ,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE := NULL
175: ,p_api_version IN NUMBER := 1.0
176: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

Line 173: ,p_attribute15 IN pa_project_sets_b.attribute15%TYPE := FND_API.G_MISS_CHAR

169: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE := FND_API.G_MISS_CHAR
170: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE := FND_API.G_MISS_CHAR
171: ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE := FND_API.G_MISS_CHAR
172: ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE := FND_API.G_MISS_CHAR
173: ,p_attribute15 IN pa_project_sets_b.attribute15%TYPE := FND_API.G_MISS_CHAR
174: ,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE := NULL
175: ,p_api_version IN NUMBER := 1.0
176: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
177: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 174: ,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE := NULL

170: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE := FND_API.G_MISS_CHAR
171: ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE := FND_API.G_MISS_CHAR
172: ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE := FND_API.G_MISS_CHAR
173: ,p_attribute15 IN pa_project_sets_b.attribute15%TYPE := FND_API.G_MISS_CHAR
174: ,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE := NULL
175: ,p_api_version IN NUMBER := 1.0
176: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
177: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
178: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

Line 295: (p_project_set_id IN pa_project_sets_b.project_set_id%TYPE := NULL

291: END update_project_set;
292:
293:
294: PROCEDURE delete_project_set
295: (p_project_set_id IN pa_project_sets_b.project_set_id%TYPE := NULL
296: ,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE := NULL
297: ,p_api_version IN NUMBER := 1.0
298: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
299: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 296: ,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE := NULL

292:
293:
294: PROCEDURE delete_project_set
295: (p_project_set_id IN pa_project_sets_b.project_set_id%TYPE := NULL
296: ,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE := NULL
297: ,p_api_version IN NUMBER := 1.0
298: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
299: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
300: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

Line 593: -- The goal is to fix PARTY_ID in pa_project_sets_b table to point to the

589:
590: -- Update_PC_PARTY_MAERGE (PUBLIC)
591: -- This is the procedure being called during the Party Merge.
592: -- The input/output arguments format matches the document PartyMergeDD.doc.
593: -- The goal is to fix PARTY_ID in pa_project_sets_b table to point to the
594: -- same party when two parties are begin merged.
595: --
596: -- Usage example in pl/sql
597: -- This procedure should only be called from the PartyMerge utility.

Line 618: update PA_PROJECT_SETS_B

614: l_incoming_p_to_id := p_to_id ; -- 4537865
615:
616: if (p_from_fk_id <> p_to_fk_id) then
617:
618: update PA_PROJECT_SETS_B
619: set PARTY_ID = p_to_fk_id,
620: last_update_date = hz_utility_pub.last_update_date,
621: last_updated_by = hz_utility_pub.user_id,
622: last_update_login = hz_utility_pub.last_update_login,