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.PER_CEL_UPD dependencies on HR_API

Line 50: -- by raising and handling the exception hr_api.validate_enabled. We use

46: -- default is false. The validation is controlled by a savepoint and
47: -- rollback mechanism. The savepoint is issued at the beginning of the
48: -- process and is rollbacked at the end of the process
49: -- when all the processing has been completed. The rollback is controlled
50: -- by raising and handling the exception hr_api.validate_enabled. We use
51: -- the exception because, by raising the exception with the
52: -- process, we can exit successfully without having any of the 'OUT'
53: -- parameters being set.
54: --

Line 126: p_proficiency_level_id in number default hr_api.g_number,

122: Procedure upd
123: (
124: p_competence_element_id in number,
125: p_object_version_number in out nocopy number,
126: p_proficiency_level_id in number default hr_api.g_number,
127: p_high_proficiency_level_id in number default hr_api.g_number,
128: p_weighting_level_id in number default hr_api.g_number,
129: p_rating_level_id in number default hr_api.g_number,
130: p_mandatory in varchar2 default hr_api.g_varchar2,

Line 127: p_high_proficiency_level_id in number default hr_api.g_number,

123: (
124: p_competence_element_id in number,
125: p_object_version_number in out nocopy number,
126: p_proficiency_level_id in number default hr_api.g_number,
127: p_high_proficiency_level_id in number default hr_api.g_number,
128: p_weighting_level_id in number default hr_api.g_number,
129: p_rating_level_id in number default hr_api.g_number,
130: p_mandatory in varchar2 default hr_api.g_varchar2,
131: p_effective_date_from in date default hr_api.g_date,

Line 128: p_weighting_level_id in number default hr_api.g_number,

124: p_competence_element_id in number,
125: p_object_version_number in out nocopy number,
126: p_proficiency_level_id in number default hr_api.g_number,
127: p_high_proficiency_level_id in number default hr_api.g_number,
128: p_weighting_level_id in number default hr_api.g_number,
129: p_rating_level_id in number default hr_api.g_number,
130: p_mandatory in varchar2 default hr_api.g_varchar2,
131: p_effective_date_from in date default hr_api.g_date,
132: p_effective_date_to in date default hr_api.g_date,

Line 129: p_rating_level_id in number default hr_api.g_number,

125: p_object_version_number in out nocopy number,
126: p_proficiency_level_id in number default hr_api.g_number,
127: p_high_proficiency_level_id in number default hr_api.g_number,
128: p_weighting_level_id in number default hr_api.g_number,
129: p_rating_level_id in number default hr_api.g_number,
130: p_mandatory in varchar2 default hr_api.g_varchar2,
131: p_effective_date_from in date default hr_api.g_date,
132: p_effective_date_to in date default hr_api.g_date,
133: p_group_competence_type in varchar2 default hr_api.g_varchar2,

Line 130: p_mandatory in varchar2 default hr_api.g_varchar2,

126: p_proficiency_level_id in number default hr_api.g_number,
127: p_high_proficiency_level_id in number default hr_api.g_number,
128: p_weighting_level_id in number default hr_api.g_number,
129: p_rating_level_id in number default hr_api.g_number,
130: p_mandatory in varchar2 default hr_api.g_varchar2,
131: p_effective_date_from in date default hr_api.g_date,
132: p_effective_date_to in date default hr_api.g_date,
133: p_group_competence_type in varchar2 default hr_api.g_varchar2,
134: p_competence_type in varchar2 default hr_api.g_varchar2,

Line 131: p_effective_date_from in date default hr_api.g_date,

127: p_high_proficiency_level_id in number default hr_api.g_number,
128: p_weighting_level_id in number default hr_api.g_number,
129: p_rating_level_id in number default hr_api.g_number,
130: p_mandatory in varchar2 default hr_api.g_varchar2,
131: p_effective_date_from in date default hr_api.g_date,
132: p_effective_date_to in date default hr_api.g_date,
133: p_group_competence_type in varchar2 default hr_api.g_varchar2,
134: p_competence_type in varchar2 default hr_api.g_varchar2,
135: p_normal_elapse_duration in number default hr_api.g_number,

Line 132: p_effective_date_to in date default hr_api.g_date,

128: p_weighting_level_id in number default hr_api.g_number,
129: p_rating_level_id in number default hr_api.g_number,
130: p_mandatory in varchar2 default hr_api.g_varchar2,
131: p_effective_date_from in date default hr_api.g_date,
132: p_effective_date_to in date default hr_api.g_date,
133: p_group_competence_type in varchar2 default hr_api.g_varchar2,
134: p_competence_type in varchar2 default hr_api.g_varchar2,
135: p_normal_elapse_duration in number default hr_api.g_number,
136: p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,

Line 133: p_group_competence_type in varchar2 default hr_api.g_varchar2,

129: p_rating_level_id in number default hr_api.g_number,
130: p_mandatory in varchar2 default hr_api.g_varchar2,
131: p_effective_date_from in date default hr_api.g_date,
132: p_effective_date_to in date default hr_api.g_date,
133: p_group_competence_type in varchar2 default hr_api.g_varchar2,
134: p_competence_type in varchar2 default hr_api.g_varchar2,
135: p_normal_elapse_duration in number default hr_api.g_number,
136: p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,
137: p_sequence_number in number default hr_api.g_number,

Line 134: p_competence_type in varchar2 default hr_api.g_varchar2,

130: p_mandatory in varchar2 default hr_api.g_varchar2,
131: p_effective_date_from in date default hr_api.g_date,
132: p_effective_date_to in date default hr_api.g_date,
133: p_group_competence_type in varchar2 default hr_api.g_varchar2,
134: p_competence_type in varchar2 default hr_api.g_varchar2,
135: p_normal_elapse_duration in number default hr_api.g_number,
136: p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,
137: p_sequence_number in number default hr_api.g_number,
138: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,

Line 135: p_normal_elapse_duration in number default hr_api.g_number,

131: p_effective_date_from in date default hr_api.g_date,
132: p_effective_date_to in date default hr_api.g_date,
133: p_group_competence_type in varchar2 default hr_api.g_varchar2,
134: p_competence_type in varchar2 default hr_api.g_varchar2,
135: p_normal_elapse_duration in number default hr_api.g_number,
136: p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,
137: p_sequence_number in number default hr_api.g_number,
138: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
139: p_line_score in number default hr_api.g_number,

Line 136: p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,

132: p_effective_date_to in date default hr_api.g_date,
133: p_group_competence_type in varchar2 default hr_api.g_varchar2,
134: p_competence_type in varchar2 default hr_api.g_varchar2,
135: p_normal_elapse_duration in number default hr_api.g_number,
136: p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,
137: p_sequence_number in number default hr_api.g_number,
138: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
139: p_line_score in number default hr_api.g_number,
140: p_certification_date in date default hr_api.g_date,

Line 137: p_sequence_number in number default hr_api.g_number,

133: p_group_competence_type in varchar2 default hr_api.g_varchar2,
134: p_competence_type in varchar2 default hr_api.g_varchar2,
135: p_normal_elapse_duration in number default hr_api.g_number,
136: p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,
137: p_sequence_number in number default hr_api.g_number,
138: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
139: p_line_score in number default hr_api.g_number,
140: p_certification_date in date default hr_api.g_date,
141: p_certification_method in varchar2 default hr_api.g_varchar2,

Line 138: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,

134: p_competence_type in varchar2 default hr_api.g_varchar2,
135: p_normal_elapse_duration in number default hr_api.g_number,
136: p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,
137: p_sequence_number in number default hr_api.g_number,
138: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
139: p_line_score in number default hr_api.g_number,
140: p_certification_date in date default hr_api.g_date,
141: p_certification_method in varchar2 default hr_api.g_varchar2,
142: p_next_certification_date in date default hr_api.g_date,

Line 139: p_line_score in number default hr_api.g_number,

135: p_normal_elapse_duration in number default hr_api.g_number,
136: p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,
137: p_sequence_number in number default hr_api.g_number,
138: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
139: p_line_score in number default hr_api.g_number,
140: p_certification_date in date default hr_api.g_date,
141: p_certification_method in varchar2 default hr_api.g_varchar2,
142: p_next_certification_date in date default hr_api.g_date,
143: p_comments in varchar2 default hr_api.g_varchar2,

Line 140: p_certification_date in date default hr_api.g_date,

136: p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,
137: p_sequence_number in number default hr_api.g_number,
138: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
139: p_line_score in number default hr_api.g_number,
140: p_certification_date in date default hr_api.g_date,
141: p_certification_method in varchar2 default hr_api.g_varchar2,
142: p_next_certification_date in date default hr_api.g_date,
143: p_comments in varchar2 default hr_api.g_varchar2,
144: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 141: p_certification_method in varchar2 default hr_api.g_varchar2,

137: p_sequence_number in number default hr_api.g_number,
138: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
139: p_line_score in number default hr_api.g_number,
140: p_certification_date in date default hr_api.g_date,
141: p_certification_method in varchar2 default hr_api.g_varchar2,
142: p_next_certification_date in date default hr_api.g_date,
143: p_comments in varchar2 default hr_api.g_varchar2,
144: p_attribute_category in varchar2 default hr_api.g_varchar2,
145: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 142: p_next_certification_date in date default hr_api.g_date,

138: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
139: p_line_score in number default hr_api.g_number,
140: p_certification_date in date default hr_api.g_date,
141: p_certification_method in varchar2 default hr_api.g_varchar2,
142: p_next_certification_date in date default hr_api.g_date,
143: p_comments in varchar2 default hr_api.g_varchar2,
144: p_attribute_category in varchar2 default hr_api.g_varchar2,
145: p_attribute1 in varchar2 default hr_api.g_varchar2,
146: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 143: p_comments in varchar2 default hr_api.g_varchar2,

139: p_line_score in number default hr_api.g_number,
140: p_certification_date in date default hr_api.g_date,
141: p_certification_method in varchar2 default hr_api.g_varchar2,
142: p_next_certification_date in date default hr_api.g_date,
143: p_comments in varchar2 default hr_api.g_varchar2,
144: p_attribute_category in varchar2 default hr_api.g_varchar2,
145: p_attribute1 in varchar2 default hr_api.g_varchar2,
146: p_attribute2 in varchar2 default hr_api.g_varchar2,
147: p_attribute3 in varchar2 default hr_api.g_varchar2,

Line 144: p_attribute_category in varchar2 default hr_api.g_varchar2,

140: p_certification_date in date default hr_api.g_date,
141: p_certification_method in varchar2 default hr_api.g_varchar2,
142: p_next_certification_date in date default hr_api.g_date,
143: p_comments in varchar2 default hr_api.g_varchar2,
144: p_attribute_category in varchar2 default hr_api.g_varchar2,
145: p_attribute1 in varchar2 default hr_api.g_varchar2,
146: p_attribute2 in varchar2 default hr_api.g_varchar2,
147: p_attribute3 in varchar2 default hr_api.g_varchar2,
148: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 145: p_attribute1 in varchar2 default hr_api.g_varchar2,

141: p_certification_method in varchar2 default hr_api.g_varchar2,
142: p_next_certification_date in date default hr_api.g_date,
143: p_comments in varchar2 default hr_api.g_varchar2,
144: p_attribute_category in varchar2 default hr_api.g_varchar2,
145: p_attribute1 in varchar2 default hr_api.g_varchar2,
146: p_attribute2 in varchar2 default hr_api.g_varchar2,
147: p_attribute3 in varchar2 default hr_api.g_varchar2,
148: p_attribute4 in varchar2 default hr_api.g_varchar2,
149: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 146: p_attribute2 in varchar2 default hr_api.g_varchar2,

142: p_next_certification_date in date default hr_api.g_date,
143: p_comments in varchar2 default hr_api.g_varchar2,
144: p_attribute_category in varchar2 default hr_api.g_varchar2,
145: p_attribute1 in varchar2 default hr_api.g_varchar2,
146: p_attribute2 in varchar2 default hr_api.g_varchar2,
147: p_attribute3 in varchar2 default hr_api.g_varchar2,
148: p_attribute4 in varchar2 default hr_api.g_varchar2,
149: p_attribute5 in varchar2 default hr_api.g_varchar2,
150: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 147: p_attribute3 in varchar2 default hr_api.g_varchar2,

143: p_comments in varchar2 default hr_api.g_varchar2,
144: p_attribute_category in varchar2 default hr_api.g_varchar2,
145: p_attribute1 in varchar2 default hr_api.g_varchar2,
146: p_attribute2 in varchar2 default hr_api.g_varchar2,
147: p_attribute3 in varchar2 default hr_api.g_varchar2,
148: p_attribute4 in varchar2 default hr_api.g_varchar2,
149: p_attribute5 in varchar2 default hr_api.g_varchar2,
150: p_attribute6 in varchar2 default hr_api.g_varchar2,
151: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 148: p_attribute4 in varchar2 default hr_api.g_varchar2,

144: p_attribute_category in varchar2 default hr_api.g_varchar2,
145: p_attribute1 in varchar2 default hr_api.g_varchar2,
146: p_attribute2 in varchar2 default hr_api.g_varchar2,
147: p_attribute3 in varchar2 default hr_api.g_varchar2,
148: p_attribute4 in varchar2 default hr_api.g_varchar2,
149: p_attribute5 in varchar2 default hr_api.g_varchar2,
150: p_attribute6 in varchar2 default hr_api.g_varchar2,
151: p_attribute7 in varchar2 default hr_api.g_varchar2,
152: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 149: p_attribute5 in varchar2 default hr_api.g_varchar2,

145: p_attribute1 in varchar2 default hr_api.g_varchar2,
146: p_attribute2 in varchar2 default hr_api.g_varchar2,
147: p_attribute3 in varchar2 default hr_api.g_varchar2,
148: p_attribute4 in varchar2 default hr_api.g_varchar2,
149: p_attribute5 in varchar2 default hr_api.g_varchar2,
150: p_attribute6 in varchar2 default hr_api.g_varchar2,
151: p_attribute7 in varchar2 default hr_api.g_varchar2,
152: p_attribute8 in varchar2 default hr_api.g_varchar2,
153: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 150: p_attribute6 in varchar2 default hr_api.g_varchar2,

146: p_attribute2 in varchar2 default hr_api.g_varchar2,
147: p_attribute3 in varchar2 default hr_api.g_varchar2,
148: p_attribute4 in varchar2 default hr_api.g_varchar2,
149: p_attribute5 in varchar2 default hr_api.g_varchar2,
150: p_attribute6 in varchar2 default hr_api.g_varchar2,
151: p_attribute7 in varchar2 default hr_api.g_varchar2,
152: p_attribute8 in varchar2 default hr_api.g_varchar2,
153: p_attribute9 in varchar2 default hr_api.g_varchar2,
154: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 151: p_attribute7 in varchar2 default hr_api.g_varchar2,

147: p_attribute3 in varchar2 default hr_api.g_varchar2,
148: p_attribute4 in varchar2 default hr_api.g_varchar2,
149: p_attribute5 in varchar2 default hr_api.g_varchar2,
150: p_attribute6 in varchar2 default hr_api.g_varchar2,
151: p_attribute7 in varchar2 default hr_api.g_varchar2,
152: p_attribute8 in varchar2 default hr_api.g_varchar2,
153: p_attribute9 in varchar2 default hr_api.g_varchar2,
154: p_attribute10 in varchar2 default hr_api.g_varchar2,
155: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 152: p_attribute8 in varchar2 default hr_api.g_varchar2,

148: p_attribute4 in varchar2 default hr_api.g_varchar2,
149: p_attribute5 in varchar2 default hr_api.g_varchar2,
150: p_attribute6 in varchar2 default hr_api.g_varchar2,
151: p_attribute7 in varchar2 default hr_api.g_varchar2,
152: p_attribute8 in varchar2 default hr_api.g_varchar2,
153: p_attribute9 in varchar2 default hr_api.g_varchar2,
154: p_attribute10 in varchar2 default hr_api.g_varchar2,
155: p_attribute11 in varchar2 default hr_api.g_varchar2,
156: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 153: p_attribute9 in varchar2 default hr_api.g_varchar2,

149: p_attribute5 in varchar2 default hr_api.g_varchar2,
150: p_attribute6 in varchar2 default hr_api.g_varchar2,
151: p_attribute7 in varchar2 default hr_api.g_varchar2,
152: p_attribute8 in varchar2 default hr_api.g_varchar2,
153: p_attribute9 in varchar2 default hr_api.g_varchar2,
154: p_attribute10 in varchar2 default hr_api.g_varchar2,
155: p_attribute11 in varchar2 default hr_api.g_varchar2,
156: p_attribute12 in varchar2 default hr_api.g_varchar2,
157: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 154: p_attribute10 in varchar2 default hr_api.g_varchar2,

150: p_attribute6 in varchar2 default hr_api.g_varchar2,
151: p_attribute7 in varchar2 default hr_api.g_varchar2,
152: p_attribute8 in varchar2 default hr_api.g_varchar2,
153: p_attribute9 in varchar2 default hr_api.g_varchar2,
154: p_attribute10 in varchar2 default hr_api.g_varchar2,
155: p_attribute11 in varchar2 default hr_api.g_varchar2,
156: p_attribute12 in varchar2 default hr_api.g_varchar2,
157: p_attribute13 in varchar2 default hr_api.g_varchar2,
158: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 155: p_attribute11 in varchar2 default hr_api.g_varchar2,

151: p_attribute7 in varchar2 default hr_api.g_varchar2,
152: p_attribute8 in varchar2 default hr_api.g_varchar2,
153: p_attribute9 in varchar2 default hr_api.g_varchar2,
154: p_attribute10 in varchar2 default hr_api.g_varchar2,
155: p_attribute11 in varchar2 default hr_api.g_varchar2,
156: p_attribute12 in varchar2 default hr_api.g_varchar2,
157: p_attribute13 in varchar2 default hr_api.g_varchar2,
158: p_attribute14 in varchar2 default hr_api.g_varchar2,
159: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 156: p_attribute12 in varchar2 default hr_api.g_varchar2,

152: p_attribute8 in varchar2 default hr_api.g_varchar2,
153: p_attribute9 in varchar2 default hr_api.g_varchar2,
154: p_attribute10 in varchar2 default hr_api.g_varchar2,
155: p_attribute11 in varchar2 default hr_api.g_varchar2,
156: p_attribute12 in varchar2 default hr_api.g_varchar2,
157: p_attribute13 in varchar2 default hr_api.g_varchar2,
158: p_attribute14 in varchar2 default hr_api.g_varchar2,
159: p_attribute15 in varchar2 default hr_api.g_varchar2,
160: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 157: p_attribute13 in varchar2 default hr_api.g_varchar2,

153: p_attribute9 in varchar2 default hr_api.g_varchar2,
154: p_attribute10 in varchar2 default hr_api.g_varchar2,
155: p_attribute11 in varchar2 default hr_api.g_varchar2,
156: p_attribute12 in varchar2 default hr_api.g_varchar2,
157: p_attribute13 in varchar2 default hr_api.g_varchar2,
158: p_attribute14 in varchar2 default hr_api.g_varchar2,
159: p_attribute15 in varchar2 default hr_api.g_varchar2,
160: p_attribute16 in varchar2 default hr_api.g_varchar2,
161: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 158: p_attribute14 in varchar2 default hr_api.g_varchar2,

154: p_attribute10 in varchar2 default hr_api.g_varchar2,
155: p_attribute11 in varchar2 default hr_api.g_varchar2,
156: p_attribute12 in varchar2 default hr_api.g_varchar2,
157: p_attribute13 in varchar2 default hr_api.g_varchar2,
158: p_attribute14 in varchar2 default hr_api.g_varchar2,
159: p_attribute15 in varchar2 default hr_api.g_varchar2,
160: p_attribute16 in varchar2 default hr_api.g_varchar2,
161: p_attribute17 in varchar2 default hr_api.g_varchar2,
162: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 159: p_attribute15 in varchar2 default hr_api.g_varchar2,

155: p_attribute11 in varchar2 default hr_api.g_varchar2,
156: p_attribute12 in varchar2 default hr_api.g_varchar2,
157: p_attribute13 in varchar2 default hr_api.g_varchar2,
158: p_attribute14 in varchar2 default hr_api.g_varchar2,
159: p_attribute15 in varchar2 default hr_api.g_varchar2,
160: p_attribute16 in varchar2 default hr_api.g_varchar2,
161: p_attribute17 in varchar2 default hr_api.g_varchar2,
162: p_attribute18 in varchar2 default hr_api.g_varchar2,
163: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 160: p_attribute16 in varchar2 default hr_api.g_varchar2,

156: p_attribute12 in varchar2 default hr_api.g_varchar2,
157: p_attribute13 in varchar2 default hr_api.g_varchar2,
158: p_attribute14 in varchar2 default hr_api.g_varchar2,
159: p_attribute15 in varchar2 default hr_api.g_varchar2,
160: p_attribute16 in varchar2 default hr_api.g_varchar2,
161: p_attribute17 in varchar2 default hr_api.g_varchar2,
162: p_attribute18 in varchar2 default hr_api.g_varchar2,
163: p_attribute19 in varchar2 default hr_api.g_varchar2,
164: p_attribute20 in varchar2 default hr_api.g_varchar2,

Line 161: p_attribute17 in varchar2 default hr_api.g_varchar2,

157: p_attribute13 in varchar2 default hr_api.g_varchar2,
158: p_attribute14 in varchar2 default hr_api.g_varchar2,
159: p_attribute15 in varchar2 default hr_api.g_varchar2,
160: p_attribute16 in varchar2 default hr_api.g_varchar2,
161: p_attribute17 in varchar2 default hr_api.g_varchar2,
162: p_attribute18 in varchar2 default hr_api.g_varchar2,
163: p_attribute19 in varchar2 default hr_api.g_varchar2,
164: p_attribute20 in varchar2 default hr_api.g_varchar2,
165: p_effective_date in Date,

Line 162: p_attribute18 in varchar2 default hr_api.g_varchar2,

158: p_attribute14 in varchar2 default hr_api.g_varchar2,
159: p_attribute15 in varchar2 default hr_api.g_varchar2,
160: p_attribute16 in varchar2 default hr_api.g_varchar2,
161: p_attribute17 in varchar2 default hr_api.g_varchar2,
162: p_attribute18 in varchar2 default hr_api.g_varchar2,
163: p_attribute19 in varchar2 default hr_api.g_varchar2,
164: p_attribute20 in varchar2 default hr_api.g_varchar2,
165: p_effective_date in Date,
166: p_party_id in number default hr_api.g_number,

Line 163: p_attribute19 in varchar2 default hr_api.g_varchar2,

159: p_attribute15 in varchar2 default hr_api.g_varchar2,
160: p_attribute16 in varchar2 default hr_api.g_varchar2,
161: p_attribute17 in varchar2 default hr_api.g_varchar2,
162: p_attribute18 in varchar2 default hr_api.g_varchar2,
163: p_attribute19 in varchar2 default hr_api.g_varchar2,
164: p_attribute20 in varchar2 default hr_api.g_varchar2,
165: p_effective_date in Date,
166: p_party_id in number default hr_api.g_number,
167: p_validate in boolean default false

Line 164: p_attribute20 in varchar2 default hr_api.g_varchar2,

160: p_attribute16 in varchar2 default hr_api.g_varchar2,
161: p_attribute17 in varchar2 default hr_api.g_varchar2,
162: p_attribute18 in varchar2 default hr_api.g_varchar2,
163: p_attribute19 in varchar2 default hr_api.g_varchar2,
164: p_attribute20 in varchar2 default hr_api.g_varchar2,
165: p_effective_date in Date,
166: p_party_id in number default hr_api.g_number,
167: p_validate in boolean default false
168: -- p_object_id in number default hr_api.g_number,

Line 166: p_party_id in number default hr_api.g_number,

162: p_attribute18 in varchar2 default hr_api.g_varchar2,
163: p_attribute19 in varchar2 default hr_api.g_varchar2,
164: p_attribute20 in varchar2 default hr_api.g_varchar2,
165: p_effective_date in Date,
166: p_party_id in number default hr_api.g_number,
167: p_validate in boolean default false
168: -- p_object_id in number default hr_api.g_number,
169: -- p_object_name in varchar2 default hr_api.g_varchar2
170: -- BUG3356369

Line 168: -- p_object_id in number default hr_api.g_number,

164: p_attribute20 in varchar2 default hr_api.g_varchar2,
165: p_effective_date in Date,
166: p_party_id in number default hr_api.g_number,
167: p_validate in boolean default false
168: -- p_object_id in number default hr_api.g_number,
169: -- p_object_name in varchar2 default hr_api.g_varchar2
170: -- BUG3356369
171: ,p_qualification_type_id in number default hr_api.g_number
172: ,p_unit_standard_type in varchar2 default hr_api.g_varchar2

Line 169: -- p_object_name in varchar2 default hr_api.g_varchar2

165: p_effective_date in Date,
166: p_party_id in number default hr_api.g_number,
167: p_validate in boolean default false
168: -- p_object_id in number default hr_api.g_number,
169: -- p_object_name in varchar2 default hr_api.g_varchar2
170: -- BUG3356369
171: ,p_qualification_type_id in number default hr_api.g_number
172: ,p_unit_standard_type in varchar2 default hr_api.g_varchar2
173: ,p_status in varchar2 default hr_api.g_varchar2

Line 171: ,p_qualification_type_id in number default hr_api.g_number

167: p_validate in boolean default false
168: -- p_object_id in number default hr_api.g_number,
169: -- p_object_name in varchar2 default hr_api.g_varchar2
170: -- BUG3356369
171: ,p_qualification_type_id in number default hr_api.g_number
172: ,p_unit_standard_type in varchar2 default hr_api.g_varchar2
173: ,p_status in varchar2 default hr_api.g_varchar2
174: ,p_information_category in varchar2 default hr_api.g_varchar2
175: ,p_information1 in varchar2 default hr_api.g_varchar2

Line 172: ,p_unit_standard_type in varchar2 default hr_api.g_varchar2

168: -- p_object_id in number default hr_api.g_number,
169: -- p_object_name in varchar2 default hr_api.g_varchar2
170: -- BUG3356369
171: ,p_qualification_type_id in number default hr_api.g_number
172: ,p_unit_standard_type in varchar2 default hr_api.g_varchar2
173: ,p_status in varchar2 default hr_api.g_varchar2
174: ,p_information_category in varchar2 default hr_api.g_varchar2
175: ,p_information1 in varchar2 default hr_api.g_varchar2
176: ,p_information2 in varchar2 default hr_api.g_varchar2

Line 173: ,p_status in varchar2 default hr_api.g_varchar2

169: -- p_object_name in varchar2 default hr_api.g_varchar2
170: -- BUG3356369
171: ,p_qualification_type_id in number default hr_api.g_number
172: ,p_unit_standard_type in varchar2 default hr_api.g_varchar2
173: ,p_status in varchar2 default hr_api.g_varchar2
174: ,p_information_category in varchar2 default hr_api.g_varchar2
175: ,p_information1 in varchar2 default hr_api.g_varchar2
176: ,p_information2 in varchar2 default hr_api.g_varchar2
177: ,p_information3 in varchar2 default hr_api.g_varchar2

Line 174: ,p_information_category in varchar2 default hr_api.g_varchar2

170: -- BUG3356369
171: ,p_qualification_type_id in number default hr_api.g_number
172: ,p_unit_standard_type in varchar2 default hr_api.g_varchar2
173: ,p_status in varchar2 default hr_api.g_varchar2
174: ,p_information_category in varchar2 default hr_api.g_varchar2
175: ,p_information1 in varchar2 default hr_api.g_varchar2
176: ,p_information2 in varchar2 default hr_api.g_varchar2
177: ,p_information3 in varchar2 default hr_api.g_varchar2
178: ,p_information4 in varchar2 default hr_api.g_varchar2

Line 175: ,p_information1 in varchar2 default hr_api.g_varchar2

171: ,p_qualification_type_id in number default hr_api.g_number
172: ,p_unit_standard_type in varchar2 default hr_api.g_varchar2
173: ,p_status in varchar2 default hr_api.g_varchar2
174: ,p_information_category in varchar2 default hr_api.g_varchar2
175: ,p_information1 in varchar2 default hr_api.g_varchar2
176: ,p_information2 in varchar2 default hr_api.g_varchar2
177: ,p_information3 in varchar2 default hr_api.g_varchar2
178: ,p_information4 in varchar2 default hr_api.g_varchar2
179: ,p_information5 in varchar2 default hr_api.g_varchar2

Line 176: ,p_information2 in varchar2 default hr_api.g_varchar2

172: ,p_unit_standard_type in varchar2 default hr_api.g_varchar2
173: ,p_status in varchar2 default hr_api.g_varchar2
174: ,p_information_category in varchar2 default hr_api.g_varchar2
175: ,p_information1 in varchar2 default hr_api.g_varchar2
176: ,p_information2 in varchar2 default hr_api.g_varchar2
177: ,p_information3 in varchar2 default hr_api.g_varchar2
178: ,p_information4 in varchar2 default hr_api.g_varchar2
179: ,p_information5 in varchar2 default hr_api.g_varchar2
180: ,p_information6 in varchar2 default hr_api.g_varchar2

Line 177: ,p_information3 in varchar2 default hr_api.g_varchar2

173: ,p_status in varchar2 default hr_api.g_varchar2
174: ,p_information_category in varchar2 default hr_api.g_varchar2
175: ,p_information1 in varchar2 default hr_api.g_varchar2
176: ,p_information2 in varchar2 default hr_api.g_varchar2
177: ,p_information3 in varchar2 default hr_api.g_varchar2
178: ,p_information4 in varchar2 default hr_api.g_varchar2
179: ,p_information5 in varchar2 default hr_api.g_varchar2
180: ,p_information6 in varchar2 default hr_api.g_varchar2
181: ,p_information7 in varchar2 default hr_api.g_varchar2

Line 178: ,p_information4 in varchar2 default hr_api.g_varchar2

174: ,p_information_category in varchar2 default hr_api.g_varchar2
175: ,p_information1 in varchar2 default hr_api.g_varchar2
176: ,p_information2 in varchar2 default hr_api.g_varchar2
177: ,p_information3 in varchar2 default hr_api.g_varchar2
178: ,p_information4 in varchar2 default hr_api.g_varchar2
179: ,p_information5 in varchar2 default hr_api.g_varchar2
180: ,p_information6 in varchar2 default hr_api.g_varchar2
181: ,p_information7 in varchar2 default hr_api.g_varchar2
182: ,p_information8 in varchar2 default hr_api.g_varchar2

Line 179: ,p_information5 in varchar2 default hr_api.g_varchar2

175: ,p_information1 in varchar2 default hr_api.g_varchar2
176: ,p_information2 in varchar2 default hr_api.g_varchar2
177: ,p_information3 in varchar2 default hr_api.g_varchar2
178: ,p_information4 in varchar2 default hr_api.g_varchar2
179: ,p_information5 in varchar2 default hr_api.g_varchar2
180: ,p_information6 in varchar2 default hr_api.g_varchar2
181: ,p_information7 in varchar2 default hr_api.g_varchar2
182: ,p_information8 in varchar2 default hr_api.g_varchar2
183: ,p_information9 in varchar2 default hr_api.g_varchar2

Line 180: ,p_information6 in varchar2 default hr_api.g_varchar2

176: ,p_information2 in varchar2 default hr_api.g_varchar2
177: ,p_information3 in varchar2 default hr_api.g_varchar2
178: ,p_information4 in varchar2 default hr_api.g_varchar2
179: ,p_information5 in varchar2 default hr_api.g_varchar2
180: ,p_information6 in varchar2 default hr_api.g_varchar2
181: ,p_information7 in varchar2 default hr_api.g_varchar2
182: ,p_information8 in varchar2 default hr_api.g_varchar2
183: ,p_information9 in varchar2 default hr_api.g_varchar2
184: ,p_information10 in varchar2 default hr_api.g_varchar2

Line 181: ,p_information7 in varchar2 default hr_api.g_varchar2

177: ,p_information3 in varchar2 default hr_api.g_varchar2
178: ,p_information4 in varchar2 default hr_api.g_varchar2
179: ,p_information5 in varchar2 default hr_api.g_varchar2
180: ,p_information6 in varchar2 default hr_api.g_varchar2
181: ,p_information7 in varchar2 default hr_api.g_varchar2
182: ,p_information8 in varchar2 default hr_api.g_varchar2
183: ,p_information9 in varchar2 default hr_api.g_varchar2
184: ,p_information10 in varchar2 default hr_api.g_varchar2
185: ,p_information11 in varchar2 default hr_api.g_varchar2

Line 182: ,p_information8 in varchar2 default hr_api.g_varchar2

178: ,p_information4 in varchar2 default hr_api.g_varchar2
179: ,p_information5 in varchar2 default hr_api.g_varchar2
180: ,p_information6 in varchar2 default hr_api.g_varchar2
181: ,p_information7 in varchar2 default hr_api.g_varchar2
182: ,p_information8 in varchar2 default hr_api.g_varchar2
183: ,p_information9 in varchar2 default hr_api.g_varchar2
184: ,p_information10 in varchar2 default hr_api.g_varchar2
185: ,p_information11 in varchar2 default hr_api.g_varchar2
186: ,p_information12 in varchar2 default hr_api.g_varchar2

Line 183: ,p_information9 in varchar2 default hr_api.g_varchar2

179: ,p_information5 in varchar2 default hr_api.g_varchar2
180: ,p_information6 in varchar2 default hr_api.g_varchar2
181: ,p_information7 in varchar2 default hr_api.g_varchar2
182: ,p_information8 in varchar2 default hr_api.g_varchar2
183: ,p_information9 in varchar2 default hr_api.g_varchar2
184: ,p_information10 in varchar2 default hr_api.g_varchar2
185: ,p_information11 in varchar2 default hr_api.g_varchar2
186: ,p_information12 in varchar2 default hr_api.g_varchar2
187: ,p_information13 in varchar2 default hr_api.g_varchar2

Line 184: ,p_information10 in varchar2 default hr_api.g_varchar2

180: ,p_information6 in varchar2 default hr_api.g_varchar2
181: ,p_information7 in varchar2 default hr_api.g_varchar2
182: ,p_information8 in varchar2 default hr_api.g_varchar2
183: ,p_information9 in varchar2 default hr_api.g_varchar2
184: ,p_information10 in varchar2 default hr_api.g_varchar2
185: ,p_information11 in varchar2 default hr_api.g_varchar2
186: ,p_information12 in varchar2 default hr_api.g_varchar2
187: ,p_information13 in varchar2 default hr_api.g_varchar2
188: ,p_information14 in varchar2 default hr_api.g_varchar2

Line 185: ,p_information11 in varchar2 default hr_api.g_varchar2

181: ,p_information7 in varchar2 default hr_api.g_varchar2
182: ,p_information8 in varchar2 default hr_api.g_varchar2
183: ,p_information9 in varchar2 default hr_api.g_varchar2
184: ,p_information10 in varchar2 default hr_api.g_varchar2
185: ,p_information11 in varchar2 default hr_api.g_varchar2
186: ,p_information12 in varchar2 default hr_api.g_varchar2
187: ,p_information13 in varchar2 default hr_api.g_varchar2
188: ,p_information14 in varchar2 default hr_api.g_varchar2
189: ,p_information15 in varchar2 default hr_api.g_varchar2

Line 186: ,p_information12 in varchar2 default hr_api.g_varchar2

182: ,p_information8 in varchar2 default hr_api.g_varchar2
183: ,p_information9 in varchar2 default hr_api.g_varchar2
184: ,p_information10 in varchar2 default hr_api.g_varchar2
185: ,p_information11 in varchar2 default hr_api.g_varchar2
186: ,p_information12 in varchar2 default hr_api.g_varchar2
187: ,p_information13 in varchar2 default hr_api.g_varchar2
188: ,p_information14 in varchar2 default hr_api.g_varchar2
189: ,p_information15 in varchar2 default hr_api.g_varchar2
190: ,p_information16 in varchar2 default hr_api.g_varchar2

Line 187: ,p_information13 in varchar2 default hr_api.g_varchar2

183: ,p_information9 in varchar2 default hr_api.g_varchar2
184: ,p_information10 in varchar2 default hr_api.g_varchar2
185: ,p_information11 in varchar2 default hr_api.g_varchar2
186: ,p_information12 in varchar2 default hr_api.g_varchar2
187: ,p_information13 in varchar2 default hr_api.g_varchar2
188: ,p_information14 in varchar2 default hr_api.g_varchar2
189: ,p_information15 in varchar2 default hr_api.g_varchar2
190: ,p_information16 in varchar2 default hr_api.g_varchar2
191: ,p_information17 in varchar2 default hr_api.g_varchar2

Line 188: ,p_information14 in varchar2 default hr_api.g_varchar2

184: ,p_information10 in varchar2 default hr_api.g_varchar2
185: ,p_information11 in varchar2 default hr_api.g_varchar2
186: ,p_information12 in varchar2 default hr_api.g_varchar2
187: ,p_information13 in varchar2 default hr_api.g_varchar2
188: ,p_information14 in varchar2 default hr_api.g_varchar2
189: ,p_information15 in varchar2 default hr_api.g_varchar2
190: ,p_information16 in varchar2 default hr_api.g_varchar2
191: ,p_information17 in varchar2 default hr_api.g_varchar2
192: ,p_information18 in varchar2 default hr_api.g_varchar2

Line 189: ,p_information15 in varchar2 default hr_api.g_varchar2

185: ,p_information11 in varchar2 default hr_api.g_varchar2
186: ,p_information12 in varchar2 default hr_api.g_varchar2
187: ,p_information13 in varchar2 default hr_api.g_varchar2
188: ,p_information14 in varchar2 default hr_api.g_varchar2
189: ,p_information15 in varchar2 default hr_api.g_varchar2
190: ,p_information16 in varchar2 default hr_api.g_varchar2
191: ,p_information17 in varchar2 default hr_api.g_varchar2
192: ,p_information18 in varchar2 default hr_api.g_varchar2
193: ,p_information19 in varchar2 default hr_api.g_varchar2

Line 190: ,p_information16 in varchar2 default hr_api.g_varchar2

186: ,p_information12 in varchar2 default hr_api.g_varchar2
187: ,p_information13 in varchar2 default hr_api.g_varchar2
188: ,p_information14 in varchar2 default hr_api.g_varchar2
189: ,p_information15 in varchar2 default hr_api.g_varchar2
190: ,p_information16 in varchar2 default hr_api.g_varchar2
191: ,p_information17 in varchar2 default hr_api.g_varchar2
192: ,p_information18 in varchar2 default hr_api.g_varchar2
193: ,p_information19 in varchar2 default hr_api.g_varchar2
194: ,p_information20 in varchar2 default hr_api.g_varchar2

Line 191: ,p_information17 in varchar2 default hr_api.g_varchar2

187: ,p_information13 in varchar2 default hr_api.g_varchar2
188: ,p_information14 in varchar2 default hr_api.g_varchar2
189: ,p_information15 in varchar2 default hr_api.g_varchar2
190: ,p_information16 in varchar2 default hr_api.g_varchar2
191: ,p_information17 in varchar2 default hr_api.g_varchar2
192: ,p_information18 in varchar2 default hr_api.g_varchar2
193: ,p_information19 in varchar2 default hr_api.g_varchar2
194: ,p_information20 in varchar2 default hr_api.g_varchar2
195: ,p_achieved_date in date default hr_api.g_date

Line 192: ,p_information18 in varchar2 default hr_api.g_varchar2

188: ,p_information14 in varchar2 default hr_api.g_varchar2
189: ,p_information15 in varchar2 default hr_api.g_varchar2
190: ,p_information16 in varchar2 default hr_api.g_varchar2
191: ,p_information17 in varchar2 default hr_api.g_varchar2
192: ,p_information18 in varchar2 default hr_api.g_varchar2
193: ,p_information19 in varchar2 default hr_api.g_varchar2
194: ,p_information20 in varchar2 default hr_api.g_varchar2
195: ,p_achieved_date in date default hr_api.g_date
196: ,p_appr_line_score in number default hr_api.g_number

Line 193: ,p_information19 in varchar2 default hr_api.g_varchar2

189: ,p_information15 in varchar2 default hr_api.g_varchar2
190: ,p_information16 in varchar2 default hr_api.g_varchar2
191: ,p_information17 in varchar2 default hr_api.g_varchar2
192: ,p_information18 in varchar2 default hr_api.g_varchar2
193: ,p_information19 in varchar2 default hr_api.g_varchar2
194: ,p_information20 in varchar2 default hr_api.g_varchar2
195: ,p_achieved_date in date default hr_api.g_date
196: ,p_appr_line_score in number default hr_api.g_number
197: );

Line 194: ,p_information20 in varchar2 default hr_api.g_varchar2

190: ,p_information16 in varchar2 default hr_api.g_varchar2
191: ,p_information17 in varchar2 default hr_api.g_varchar2
192: ,p_information18 in varchar2 default hr_api.g_varchar2
193: ,p_information19 in varchar2 default hr_api.g_varchar2
194: ,p_information20 in varchar2 default hr_api.g_varchar2
195: ,p_achieved_date in date default hr_api.g_date
196: ,p_appr_line_score in number default hr_api.g_number
197: );
198: --

Line 195: ,p_achieved_date in date default hr_api.g_date

191: ,p_information17 in varchar2 default hr_api.g_varchar2
192: ,p_information18 in varchar2 default hr_api.g_varchar2
193: ,p_information19 in varchar2 default hr_api.g_varchar2
194: ,p_information20 in varchar2 default hr_api.g_varchar2
195: ,p_achieved_date in date default hr_api.g_date
196: ,p_appr_line_score in number default hr_api.g_number
197: );
198: --
199: end per_cel_upd;

Line 196: ,p_appr_line_score in number default hr_api.g_number

192: ,p_information18 in varchar2 default hr_api.g_varchar2
193: ,p_information19 in varchar2 default hr_api.g_varchar2
194: ,p_information20 in varchar2 default hr_api.g_varchar2
195: ,p_achieved_date in date default hr_api.g_date
196: ,p_appr_line_score in number default hr_api.g_number
197: );
198: --
199: end per_cel_upd;