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