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 6: ,p_party_id IN pa_project_sets_b.party_id%TYPE

2: /*$Header: PAPPSPUS.pls 120.1 2005/08/19 16:43:45 mwasowic noship $*/
3: --
4: PROCEDURE create_project_set
5: ( p_project_set_name IN pa_project_sets_tl.name%TYPE
6: ,p_party_id IN pa_project_sets_b.party_id%TYPE
7: ,p_effective_start_date IN pa_project_sets_b.effective_start_date%TYPE
8: ,p_effective_end_date IN pa_project_sets_b.effective_end_date%TYPE := NULL
9: ,p_access_level IN pa_project_sets_b.access_level%TYPE
10: ,p_description IN pa_project_sets_tl.description%TYPE := NULL

Line 7: ,p_effective_start_date IN pa_project_sets_b.effective_start_date%TYPE

3: --
4: PROCEDURE create_project_set
5: ( p_project_set_name IN pa_project_sets_tl.name%TYPE
6: ,p_party_id IN pa_project_sets_b.party_id%TYPE
7: ,p_effective_start_date IN pa_project_sets_b.effective_start_date%TYPE
8: ,p_effective_end_date IN pa_project_sets_b.effective_end_date%TYPE := NULL
9: ,p_access_level IN pa_project_sets_b.access_level%TYPE
10: ,p_description IN pa_project_sets_tl.description%TYPE := NULL
11: ,p_party_name IN hz_parties.party_name%TYPE

Line 8: ,p_effective_end_date IN pa_project_sets_b.effective_end_date%TYPE := NULL

4: PROCEDURE create_project_set
5: ( p_project_set_name IN pa_project_sets_tl.name%TYPE
6: ,p_party_id IN pa_project_sets_b.party_id%TYPE
7: ,p_effective_start_date IN pa_project_sets_b.effective_start_date%TYPE
8: ,p_effective_end_date IN pa_project_sets_b.effective_end_date%TYPE := NULL
9: ,p_access_level IN pa_project_sets_b.access_level%TYPE
10: ,p_description IN pa_project_sets_tl.description%TYPE := NULL
11: ,p_party_name IN hz_parties.party_name%TYPE
12: ,p_attribute_category IN pa_project_sets_b.attribute_category%TYPE := NULL

Line 9: ,p_access_level IN pa_project_sets_b.access_level%TYPE

5: ( p_project_set_name IN pa_project_sets_tl.name%TYPE
6: ,p_party_id IN pa_project_sets_b.party_id%TYPE
7: ,p_effective_start_date IN pa_project_sets_b.effective_start_date%TYPE
8: ,p_effective_end_date IN pa_project_sets_b.effective_end_date%TYPE := NULL
9: ,p_access_level IN pa_project_sets_b.access_level%TYPE
10: ,p_description IN pa_project_sets_tl.description%TYPE := NULL
11: ,p_party_name IN hz_parties.party_name%TYPE
12: ,p_attribute_category IN pa_project_sets_b.attribute_category%TYPE := NULL
13: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE := NULL

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 39: (p_project_set_id IN pa_project_sets_b.project_set_id%TYPE

35: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
36: );
37:
38: PROCEDURE update_project_set
39: (p_project_set_id IN pa_project_sets_b.project_set_id%TYPE
40: ,p_project_set_name IN pa_project_sets_tl.name%TYPE := FND_API.G_MISS_CHAR
41: ,p_party_id IN pa_project_sets_b.party_id%TYPE := FND_API.G_MISS_NUM
42: ,p_effective_start_date IN pa_project_sets_b.effective_start_date%TYPE := FND_API.G_MISS_DATE
43: ,p_effective_end_date IN pa_project_sets_b.effective_end_date%TYPE := FND_API.G_MISS_DATE

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

37:
38: PROCEDURE update_project_set
39: (p_project_set_id IN pa_project_sets_b.project_set_id%TYPE
40: ,p_project_set_name IN pa_project_sets_tl.name%TYPE := FND_API.G_MISS_CHAR
41: ,p_party_id IN pa_project_sets_b.party_id%TYPE := FND_API.G_MISS_NUM
42: ,p_effective_start_date IN pa_project_sets_b.effective_start_date%TYPE := FND_API.G_MISS_DATE
43: ,p_effective_end_date IN pa_project_sets_b.effective_end_date%TYPE := FND_API.G_MISS_DATE
44: ,p_access_level IN pa_project_sets_b.access_level%TYPE := FND_API.G_MISS_NUM
45: ,p_description IN pa_project_sets_tl.description%TYPE := FND_API.G_MISS_CHAR

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

38: PROCEDURE update_project_set
39: (p_project_set_id IN pa_project_sets_b.project_set_id%TYPE
40: ,p_project_set_name IN pa_project_sets_tl.name%TYPE := FND_API.G_MISS_CHAR
41: ,p_party_id IN pa_project_sets_b.party_id%TYPE := FND_API.G_MISS_NUM
42: ,p_effective_start_date IN pa_project_sets_b.effective_start_date%TYPE := FND_API.G_MISS_DATE
43: ,p_effective_end_date IN pa_project_sets_b.effective_end_date%TYPE := FND_API.G_MISS_DATE
44: ,p_access_level IN pa_project_sets_b.access_level%TYPE := FND_API.G_MISS_NUM
45: ,p_description IN pa_project_sets_tl.description%TYPE := FND_API.G_MISS_CHAR
46: ,p_party_name IN hz_parties.party_name%TYPE := FND_API.G_MISS_CHAR

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

39: (p_project_set_id IN pa_project_sets_b.project_set_id%TYPE
40: ,p_project_set_name IN pa_project_sets_tl.name%TYPE := FND_API.G_MISS_CHAR
41: ,p_party_id IN pa_project_sets_b.party_id%TYPE := FND_API.G_MISS_NUM
42: ,p_effective_start_date IN pa_project_sets_b.effective_start_date%TYPE := FND_API.G_MISS_DATE
43: ,p_effective_end_date IN pa_project_sets_b.effective_end_date%TYPE := FND_API.G_MISS_DATE
44: ,p_access_level IN pa_project_sets_b.access_level%TYPE := FND_API.G_MISS_NUM
45: ,p_description IN pa_project_sets_tl.description%TYPE := FND_API.G_MISS_CHAR
46: ,p_party_name IN hz_parties.party_name%TYPE := FND_API.G_MISS_CHAR
47: ,p_attribute_category IN pa_project_sets_b.attribute_category%TYPE := FND_API.G_MISS_CHAR

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

40: ,p_project_set_name IN pa_project_sets_tl.name%TYPE := FND_API.G_MISS_CHAR
41: ,p_party_id IN pa_project_sets_b.party_id%TYPE := FND_API.G_MISS_NUM
42: ,p_effective_start_date IN pa_project_sets_b.effective_start_date%TYPE := FND_API.G_MISS_DATE
43: ,p_effective_end_date IN pa_project_sets_b.effective_end_date%TYPE := FND_API.G_MISS_DATE
44: ,p_access_level IN pa_project_sets_b.access_level%TYPE := FND_API.G_MISS_NUM
45: ,p_description IN pa_project_sets_tl.description%TYPE := FND_API.G_MISS_CHAR
46: ,p_party_name IN hz_parties.party_name%TYPE := FND_API.G_MISS_CHAR
47: ,p_attribute_category IN pa_project_sets_b.attribute_category%TYPE := FND_API.G_MISS_CHAR
48: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE := FND_API.G_MISS_CHAR

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

43: ,p_effective_end_date IN pa_project_sets_b.effective_end_date%TYPE := FND_API.G_MISS_DATE
44: ,p_access_level IN pa_project_sets_b.access_level%TYPE := FND_API.G_MISS_NUM
45: ,p_description IN pa_project_sets_tl.description%TYPE := FND_API.G_MISS_CHAR
46: ,p_party_name IN hz_parties.party_name%TYPE := FND_API.G_MISS_CHAR
47: ,p_attribute_category IN pa_project_sets_b.attribute_category%TYPE := FND_API.G_MISS_CHAR
48: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE := FND_API.G_MISS_CHAR
49: ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE := FND_API.G_MISS_CHAR
50: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE := FND_API.G_MISS_CHAR
51: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE := FND_API.G_MISS_CHAR

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

44: ,p_access_level IN pa_project_sets_b.access_level%TYPE := FND_API.G_MISS_NUM
45: ,p_description IN pa_project_sets_tl.description%TYPE := FND_API.G_MISS_CHAR
46: ,p_party_name IN hz_parties.party_name%TYPE := FND_API.G_MISS_CHAR
47: ,p_attribute_category IN pa_project_sets_b.attribute_category%TYPE := FND_API.G_MISS_CHAR
48: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE := FND_API.G_MISS_CHAR
49: ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE := FND_API.G_MISS_CHAR
50: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE := FND_API.G_MISS_CHAR
51: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE := FND_API.G_MISS_CHAR
52: ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE := FND_API.G_MISS_CHAR

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

45: ,p_description IN pa_project_sets_tl.description%TYPE := FND_API.G_MISS_CHAR
46: ,p_party_name IN hz_parties.party_name%TYPE := FND_API.G_MISS_CHAR
47: ,p_attribute_category IN pa_project_sets_b.attribute_category%TYPE := FND_API.G_MISS_CHAR
48: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE := FND_API.G_MISS_CHAR
49: ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE := FND_API.G_MISS_CHAR
50: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE := FND_API.G_MISS_CHAR
51: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE := FND_API.G_MISS_CHAR
52: ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE := FND_API.G_MISS_CHAR
53: ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE := FND_API.G_MISS_CHAR

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

46: ,p_party_name IN hz_parties.party_name%TYPE := FND_API.G_MISS_CHAR
47: ,p_attribute_category IN pa_project_sets_b.attribute_category%TYPE := FND_API.G_MISS_CHAR
48: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE := FND_API.G_MISS_CHAR
49: ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE := FND_API.G_MISS_CHAR
50: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE := FND_API.G_MISS_CHAR
51: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE := FND_API.G_MISS_CHAR
52: ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE := FND_API.G_MISS_CHAR
53: ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE := FND_API.G_MISS_CHAR
54: ,p_attribute7 IN pa_project_sets_b.attribute7%TYPE := FND_API.G_MISS_CHAR

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

47: ,p_attribute_category IN pa_project_sets_b.attribute_category%TYPE := FND_API.G_MISS_CHAR
48: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE := FND_API.G_MISS_CHAR
49: ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE := FND_API.G_MISS_CHAR
50: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE := FND_API.G_MISS_CHAR
51: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE := FND_API.G_MISS_CHAR
52: ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE := FND_API.G_MISS_CHAR
53: ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE := FND_API.G_MISS_CHAR
54: ,p_attribute7 IN pa_project_sets_b.attribute7%TYPE := FND_API.G_MISS_CHAR
55: ,p_attribute8 IN pa_project_sets_b.attribute8%TYPE := FND_API.G_MISS_CHAR

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

48: ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE := FND_API.G_MISS_CHAR
49: ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE := FND_API.G_MISS_CHAR
50: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE := FND_API.G_MISS_CHAR
51: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE := FND_API.G_MISS_CHAR
52: ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE := FND_API.G_MISS_CHAR
53: ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE := FND_API.G_MISS_CHAR
54: ,p_attribute7 IN pa_project_sets_b.attribute7%TYPE := FND_API.G_MISS_CHAR
55: ,p_attribute8 IN pa_project_sets_b.attribute8%TYPE := FND_API.G_MISS_CHAR
56: ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE := FND_API.G_MISS_CHAR

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

49: ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE := FND_API.G_MISS_CHAR
50: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE := FND_API.G_MISS_CHAR
51: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE := FND_API.G_MISS_CHAR
52: ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE := FND_API.G_MISS_CHAR
53: ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE := FND_API.G_MISS_CHAR
54: ,p_attribute7 IN pa_project_sets_b.attribute7%TYPE := FND_API.G_MISS_CHAR
55: ,p_attribute8 IN pa_project_sets_b.attribute8%TYPE := FND_API.G_MISS_CHAR
56: ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE := FND_API.G_MISS_CHAR
57: ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE := FND_API.G_MISS_CHAR

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

50: ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE := FND_API.G_MISS_CHAR
51: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE := FND_API.G_MISS_CHAR
52: ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE := FND_API.G_MISS_CHAR
53: ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE := FND_API.G_MISS_CHAR
54: ,p_attribute7 IN pa_project_sets_b.attribute7%TYPE := FND_API.G_MISS_CHAR
55: ,p_attribute8 IN pa_project_sets_b.attribute8%TYPE := FND_API.G_MISS_CHAR
56: ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE := FND_API.G_MISS_CHAR
57: ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE := FND_API.G_MISS_CHAR
58: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE := FND_API.G_MISS_CHAR

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

51: ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE := FND_API.G_MISS_CHAR
52: ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE := FND_API.G_MISS_CHAR
53: ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE := FND_API.G_MISS_CHAR
54: ,p_attribute7 IN pa_project_sets_b.attribute7%TYPE := FND_API.G_MISS_CHAR
55: ,p_attribute8 IN pa_project_sets_b.attribute8%TYPE := FND_API.G_MISS_CHAR
56: ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE := FND_API.G_MISS_CHAR
57: ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE := FND_API.G_MISS_CHAR
58: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE := FND_API.G_MISS_CHAR
59: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE := FND_API.G_MISS_CHAR

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

52: ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE := FND_API.G_MISS_CHAR
53: ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE := FND_API.G_MISS_CHAR
54: ,p_attribute7 IN pa_project_sets_b.attribute7%TYPE := FND_API.G_MISS_CHAR
55: ,p_attribute8 IN pa_project_sets_b.attribute8%TYPE := FND_API.G_MISS_CHAR
56: ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE := FND_API.G_MISS_CHAR
57: ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE := FND_API.G_MISS_CHAR
58: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE := FND_API.G_MISS_CHAR
59: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE := FND_API.G_MISS_CHAR
60: ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE := FND_API.G_MISS_CHAR

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

53: ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE := FND_API.G_MISS_CHAR
54: ,p_attribute7 IN pa_project_sets_b.attribute7%TYPE := FND_API.G_MISS_CHAR
55: ,p_attribute8 IN pa_project_sets_b.attribute8%TYPE := FND_API.G_MISS_CHAR
56: ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE := FND_API.G_MISS_CHAR
57: ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE := FND_API.G_MISS_CHAR
58: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE := FND_API.G_MISS_CHAR
59: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE := FND_API.G_MISS_CHAR
60: ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE := FND_API.G_MISS_CHAR
61: ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE := FND_API.G_MISS_CHAR

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

54: ,p_attribute7 IN pa_project_sets_b.attribute7%TYPE := FND_API.G_MISS_CHAR
55: ,p_attribute8 IN pa_project_sets_b.attribute8%TYPE := FND_API.G_MISS_CHAR
56: ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE := FND_API.G_MISS_CHAR
57: ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE := FND_API.G_MISS_CHAR
58: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE := FND_API.G_MISS_CHAR
59: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE := FND_API.G_MISS_CHAR
60: ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE := FND_API.G_MISS_CHAR
61: ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE := FND_API.G_MISS_CHAR
62: ,p_attribute15 IN pa_project_sets_b.attribute15%TYPE := FND_API.G_MISS_CHAR

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

55: ,p_attribute8 IN pa_project_sets_b.attribute8%TYPE := FND_API.G_MISS_CHAR
56: ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE := FND_API.G_MISS_CHAR
57: ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE := FND_API.G_MISS_CHAR
58: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE := FND_API.G_MISS_CHAR
59: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE := FND_API.G_MISS_CHAR
60: ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE := FND_API.G_MISS_CHAR
61: ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE := FND_API.G_MISS_CHAR
62: ,p_attribute15 IN pa_project_sets_b.attribute15%TYPE := FND_API.G_MISS_CHAR
63: ,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE := NULL

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

56: ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE := FND_API.G_MISS_CHAR
57: ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE := FND_API.G_MISS_CHAR
58: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE := FND_API.G_MISS_CHAR
59: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE := FND_API.G_MISS_CHAR
60: ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE := FND_API.G_MISS_CHAR
61: ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE := FND_API.G_MISS_CHAR
62: ,p_attribute15 IN pa_project_sets_b.attribute15%TYPE := FND_API.G_MISS_CHAR
63: ,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE := NULL
64: ,p_api_version IN NUMBER := 1.0

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

57: ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE := FND_API.G_MISS_CHAR
58: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE := FND_API.G_MISS_CHAR
59: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE := FND_API.G_MISS_CHAR
60: ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE := FND_API.G_MISS_CHAR
61: ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE := FND_API.G_MISS_CHAR
62: ,p_attribute15 IN pa_project_sets_b.attribute15%TYPE := FND_API.G_MISS_CHAR
63: ,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE := NULL
64: ,p_api_version IN NUMBER := 1.0
65: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

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

58: ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE := FND_API.G_MISS_CHAR
59: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE := FND_API.G_MISS_CHAR
60: ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE := FND_API.G_MISS_CHAR
61: ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE := FND_API.G_MISS_CHAR
62: ,p_attribute15 IN pa_project_sets_b.attribute15%TYPE := FND_API.G_MISS_CHAR
63: ,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE := NULL
64: ,p_api_version IN NUMBER := 1.0
65: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
66: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

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

59: ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE := FND_API.G_MISS_CHAR
60: ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE := FND_API.G_MISS_CHAR
61: ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE := FND_API.G_MISS_CHAR
62: ,p_attribute15 IN pa_project_sets_b.attribute15%TYPE := FND_API.G_MISS_CHAR
63: ,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE := NULL
64: ,p_api_version IN NUMBER := 1.0
65: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
66: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
67: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

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

71: );
72:
73:
74: PROCEDURE delete_project_set
75: (p_project_set_id IN pa_project_sets_b.project_set_id%TYPE := NULL
76: ,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE := NULL
77: ,p_api_version IN NUMBER := 1.0
78: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
79: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

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

72:
73:
74: PROCEDURE delete_project_set
75: (p_project_set_id IN pa_project_sets_b.project_set_id%TYPE := NULL
76: ,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE := NULL
77: ,p_api_version IN NUMBER := 1.0
78: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
79: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
80: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE