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_CANDIDATE_PUB dependencies on PA_CANDIDATES

Line 40: p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,

36: p_project_super_user IN VARCHAR2 DEFAULT 'N',
37: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE, -- Added for Bug 5130421: PJR Enhancements for Public APIs\
38: -- Added for bug 8339510
39: -- start for bug#9468526 , Added default null values
40: p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,
41: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,
42: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
43: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
44: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,

Line 41: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,

37: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE, -- Added for Bug 5130421: PJR Enhancements for Public APIs\
38: -- Added for bug 8339510
39: -- start for bug#9468526 , Added default null values
40: p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,
41: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,
42: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
43: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
44: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
45: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,

Line 42: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,

38: -- Added for bug 8339510
39: -- start for bug#9468526 , Added default null values
40: p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,
41: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,
42: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
43: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
44: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
45: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
46: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,

Line 43: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,

39: -- start for bug#9468526 , Added default null values
40: p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,
41: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,
42: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
43: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
44: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
45: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
46: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
47: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,

Line 44: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,

40: p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,
41: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,
42: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
43: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
44: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
45: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
46: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
47: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
48: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,

Line 45: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,

41: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,
42: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
43: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
44: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
45: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
46: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
47: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
48: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
49: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,

Line 46: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,

42: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
43: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
44: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
45: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
46: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
47: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
48: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
49: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
50: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,

Line 47: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,

43: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
44: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
45: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
46: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
47: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
48: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
49: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
50: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
51: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,

Line 48: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,

44: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
45: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
46: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
47: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
48: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
49: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
50: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
51: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
52: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,

Line 49: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,

45: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
46: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
47: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
48: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
49: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
50: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
51: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
52: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
53: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,

Line 50: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,

46: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
47: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
48: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
49: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
50: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
51: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
52: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
53: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,
54: p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,

Line 51: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,

47: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
48: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
49: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
50: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
51: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
52: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
53: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,
54: p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,
55: p_attribute15 IN pa_candidates.attribute15%TYPE :=NULL ,

Line 52: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,

48: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
49: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
50: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
51: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
52: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
53: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,
54: p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,
55: p_attribute15 IN pa_candidates.attribute15%TYPE :=NULL ,
56: -- start for bug#9468526 , Added default null values

Line 53: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,

49: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
50: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
51: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
52: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
53: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,
54: p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,
55: p_attribute15 IN pa_candidates.attribute15%TYPE :=NULL ,
56: -- start for bug#9468526 , Added default null values
57: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 54: p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,

50: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
51: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
52: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
53: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,
54: p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,
55: p_attribute15 IN pa_candidates.attribute15%TYPE :=NULL ,
56: -- start for bug#9468526 , Added default null values
57: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
58: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 55: p_attribute15 IN pa_candidates.attribute15%TYPE :=NULL ,

51: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
52: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
53: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,
54: p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,
55: p_attribute15 IN pa_candidates.attribute15%TYPE :=NULL ,
56: -- start for bug#9468526 , Added default null values
57: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
58: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
59: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 76: p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,

72: p_change_reason_code IN VARCHAR2,
73: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
74: -- Added for bug 8339510
75: -- start for bug#9468526 , Added default null values
76: p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,
77: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,
78: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
79: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
80: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,

Line 77: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,

73: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
74: -- Added for bug 8339510
75: -- start for bug#9468526 , Added default null values
76: p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,
77: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,
78: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
79: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
80: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
81: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,

Line 78: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,

74: -- Added for bug 8339510
75: -- start for bug#9468526 , Added default null values
76: p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,
77: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,
78: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
79: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
80: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
81: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
82: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,

Line 79: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,

75: -- start for bug#9468526 , Added default null values
76: p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,
77: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,
78: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
79: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
80: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
81: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
82: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
83: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,

Line 80: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,

76: p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,
77: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,
78: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
79: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
80: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
81: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
82: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
83: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
84: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,

Line 81: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,

77: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,
78: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
79: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
80: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
81: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
82: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
83: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
84: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
85: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,

Line 82: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,

78: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
79: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
80: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
81: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
82: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
83: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
84: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
85: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
86: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,

Line 83: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,

79: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
80: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
81: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
82: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
83: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
84: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
85: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
86: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
87: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,

Line 84: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,

80: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
81: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
82: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
83: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
84: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
85: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
86: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
87: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
88: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,

Line 85: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,

81: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
82: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
83: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
84: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
85: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
86: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
87: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
88: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
89: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,

Line 86: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,

82: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
83: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
84: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
85: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
86: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
87: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
88: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
89: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,
90: p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,

Line 87: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,

83: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
84: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
85: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
86: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
87: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
88: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
89: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,
90: p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,
91: p_attribute15 IN pa_candidates.attribute15%TYPE :=NULL ,

Line 88: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,

84: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
85: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
86: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
87: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
88: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
89: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,
90: p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,
91: p_attribute15 IN pa_candidates.attribute15%TYPE :=NULL ,
92: -- start for bug#9468526 , Added default null values

Line 89: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,

85: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
86: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
87: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
88: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
89: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,
90: p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,
91: p_attribute15 IN pa_candidates.attribute15%TYPE :=NULL ,
92: -- start for bug#9468526 , Added default null values
93: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 90: p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,

86: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
87: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
88: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
89: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,
90: p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,
91: p_attribute15 IN pa_candidates.attribute15%TYPE :=NULL ,
92: -- start for bug#9468526 , Added default null values
93: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
94: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 91: p_attribute15 IN pa_candidates.attribute15%TYPE :=NULL ,

87: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
88: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
89: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,
90: p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,
91: p_attribute15 IN pa_candidates.attribute15%TYPE :=NULL ,
92: -- start for bug#9468526 , Added default null values
93: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
94: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
95: x_msg_count OUT NOCOPY NUMBER); --File.Sql.39 bug 4440895

Line 107: p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,

103: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE, -- Added for Bug 5130421: PJR Enhancements for Public APIs
104: x_cand_record_version_number OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
105: -- Added for bug 8339510
106: -- start for bug#9468526 , Added default null values
107: p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,
108: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,
109: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
110: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
111: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,

Line 108: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,

104: x_cand_record_version_number OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
105: -- Added for bug 8339510
106: -- start for bug#9468526 , Added default null values
107: p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,
108: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,
109: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
110: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
111: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
112: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,

Line 109: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,

105: -- Added for bug 8339510
106: -- start for bug#9468526 , Added default null values
107: p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,
108: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,
109: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
110: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
111: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
112: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
113: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,

Line 110: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,

106: -- start for bug#9468526 , Added default null values
107: p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,
108: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,
109: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
110: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
111: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
112: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
113: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
114: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,

Line 111: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,

107: p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,
108: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,
109: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
110: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
111: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
112: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
113: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
114: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
115: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,

Line 112: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,

108: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,
109: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
110: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
111: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
112: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
113: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
114: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
115: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
116: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,

Line 113: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,

109: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
110: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
111: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
112: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
113: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
114: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
115: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
116: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
117: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,

Line 114: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,

110: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
111: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
112: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
113: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
114: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
115: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
116: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
117: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
118: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,

Line 115: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,

111: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
112: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
113: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
114: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
115: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
116: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
117: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
118: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
119: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,

Line 116: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,

112: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
113: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
114: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
115: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
116: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
117: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
118: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
119: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
120: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,

Line 117: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,

113: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
114: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
115: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
116: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
117: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
118: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
119: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
120: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,
121: p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,

Line 118: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,

114: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
115: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
116: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
117: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
118: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
119: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
120: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,
121: p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,
122: p_attribute15 IN pa_candidates.attribute15%TYPE :=NULL ,

Line 119: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,

115: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
116: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
117: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
118: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
119: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
120: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,
121: p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,
122: p_attribute15 IN pa_candidates.attribute15%TYPE :=NULL ,
123: -- start for bug#9468526 , Added default null values

Line 120: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,

116: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
117: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
118: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
119: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
120: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,
121: p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,
122: p_attribute15 IN pa_candidates.attribute15%TYPE :=NULL ,
123: -- start for bug#9468526 , Added default null values
124: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 121: p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,

117: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
118: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
119: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
120: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,
121: p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,
122: p_attribute15 IN pa_candidates.attribute15%TYPE :=NULL ,
123: -- start for bug#9468526 , Added default null values
124: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
125: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 122: p_attribute15 IN pa_candidates.attribute15%TYPE :=NULL ,

118: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
119: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
120: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,
121: p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,
122: p_attribute15 IN pa_candidates.attribute15%TYPE :=NULL ,
123: -- start for bug#9468526 , Added default null values
124: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
125: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
126: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 138: p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,

134: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
135: p_validate_status IN VARCHAR2 := FND_API.G_TRUE,
136: -- Added for bug 8339510
137: -- start for bug#9468526 , Added default null values
138: p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,
139: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,
140: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
141: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
142: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,

Line 139: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,

135: p_validate_status IN VARCHAR2 := FND_API.G_TRUE,
136: -- Added for bug 8339510
137: -- start for bug#9468526 , Added default null values
138: p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,
139: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,
140: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
141: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
142: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
143: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,

Line 140: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,

136: -- Added for bug 8339510
137: -- start for bug#9468526 , Added default null values
138: p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,
139: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,
140: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
141: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
142: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
143: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
144: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,

Line 141: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,

137: -- start for bug#9468526 , Added default null values
138: p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,
139: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,
140: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
141: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
142: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
143: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
144: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
145: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,

Line 142: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,

138: p_attribute_category IN pa_candidates.attribute_category%TYPE :=NULL ,
139: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,
140: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
141: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
142: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
143: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
144: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
145: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
146: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,

Line 143: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,

139: p_attribute1 IN pa_candidates.attribute1%TYPE :=NULL ,
140: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
141: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
142: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
143: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
144: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
145: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
146: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
147: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,

Line 144: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,

140: p_attribute2 IN pa_candidates.attribute2%TYPE :=NULL ,
141: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
142: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
143: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
144: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
145: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
146: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
147: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
148: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,

Line 145: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,

141: p_attribute3 IN pa_candidates.attribute3%TYPE :=NULL ,
142: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
143: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
144: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
145: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
146: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
147: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
148: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
149: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,

Line 146: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,

142: p_attribute4 IN pa_candidates.attribute4%TYPE :=NULL ,
143: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
144: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
145: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
146: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
147: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
148: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
149: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
150: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,

Line 147: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,

143: p_attribute5 IN pa_candidates.attribute5%TYPE :=NULL ,
144: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
145: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
146: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
147: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
148: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
149: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
150: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
151: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,

Line 148: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,

144: p_attribute6 IN pa_candidates.attribute6%TYPE :=NULL ,
145: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
146: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
147: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
148: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
149: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
150: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
151: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,
152: p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,

Line 149: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,

145: p_attribute7 IN pa_candidates.attribute7%TYPE :=NULL ,
146: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
147: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
148: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
149: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
150: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
151: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,
152: p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,
153: p_attribute15 IN pa_candidates.attribute15%TYPE :=NULL ,

Line 150: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,

146: p_attribute8 IN pa_candidates.attribute8%TYPE :=NULL ,
147: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
148: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
149: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
150: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
151: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,
152: p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,
153: p_attribute15 IN pa_candidates.attribute15%TYPE :=NULL ,
154: -- start for bug#9468526 , Added default null values

Line 151: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,

147: p_attribute9 IN pa_candidates.attribute9%TYPE :=NULL ,
148: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
149: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
150: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
151: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,
152: p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,
153: p_attribute15 IN pa_candidates.attribute15%TYPE :=NULL ,
154: -- start for bug#9468526 , Added default null values
155: x_record_version_number OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 152: p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,

148: p_attribute10 IN pa_candidates.attribute10%TYPE :=NULL ,
149: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
150: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
151: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,
152: p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,
153: p_attribute15 IN pa_candidates.attribute15%TYPE :=NULL ,
154: -- start for bug#9468526 , Added default null values
155: x_record_version_number OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
156: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 153: p_attribute15 IN pa_candidates.attribute15%TYPE :=NULL ,

149: p_attribute11 IN pa_candidates.attribute11%TYPE :=NULL ,
150: p_attribute12 IN pa_candidates.attribute12%TYPE :=NULL ,
151: p_attribute13 IN pa_candidates.attribute13%TYPE :=NULL ,
152: p_attribute14 IN pa_candidates.attribute14%TYPE :=NULL ,
153: p_attribute15 IN pa_candidates.attribute15%TYPE :=NULL ,
154: -- start for bug#9468526 , Added default null values
155: x_record_version_number OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
156: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
157: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895