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 FND_API

Line 29: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

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
32: ,x_project_set_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
33: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 30: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

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
32: ,x_project_set_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
33: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
34: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 31: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

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
32: ,x_project_set_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
33: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
34: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
35: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 40: ,p_project_set_name IN pa_project_sets_tl.name%TYPE := FND_API.G_MISS_CHAR

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
44: ,p_access_level IN pa_project_sets_b.access_level%TYPE := FND_API.G_MISS_NUM

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 45: ,p_description IN pa_project_sets_tl.description%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
49: ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE := FND_API.G_MISS_CHAR

Line 46: ,p_party_name IN hz_parties.party_name%TYPE := FND_API.G_MISS_CHAR

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

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 65: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

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
68: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
69: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 66: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

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
68: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
69: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
70: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 67: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

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
68: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
69: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
70: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
71: );

Line 78: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

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
81: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
82: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 79: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

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
81: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
82: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
83: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 80: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

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
81: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
82: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
83: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
84: );

Line 91: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

87: PROCEDURE create_project_set_line
88: (p_project_set_id IN pa_project_set_lines.project_set_id%TYPE
89: ,p_project_id IN pa_project_set_lines.project_id%TYPE
90: ,p_api_version IN NUMBER := 1.0
91: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
92: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
93: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
94: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
95: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 92: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

88: (p_project_set_id IN pa_project_set_lines.project_set_id%TYPE
89: ,p_project_id IN pa_project_set_lines.project_id%TYPE
90: ,p_api_version IN NUMBER := 1.0
91: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
92: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
93: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
94: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
95: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
96: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 93: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

89: ,p_project_id IN pa_project_set_lines.project_id%TYPE
90: ,p_api_version IN NUMBER := 1.0
91: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
92: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
93: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
94: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
95: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
96: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
97: );

Line 104: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

100: PROCEDURE delete_project_set_line
101: (p_project_set_id IN pa_project_set_lines.project_set_id%TYPE
102: ,p_project_id IN pa_project_set_lines.project_id%TYPE
103: ,p_api_version IN NUMBER := 1.0
104: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
105: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
106: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
107: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
108: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 105: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

101: (p_project_set_id IN pa_project_set_lines.project_set_id%TYPE
102: ,p_project_id IN pa_project_set_lines.project_id%TYPE
103: ,p_api_version IN NUMBER := 1.0
104: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
105: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
106: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
107: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
108: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
109: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 106: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

102: ,p_project_id IN pa_project_set_lines.project_id%TYPE
103: ,p_api_version IN NUMBER := 1.0
104: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
105: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
106: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
107: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
108: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
109: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
110: );