DBA Data[Home] [Help]

APPS.HR_COMPETENCE_ELEMENT_BE1 dependencies on FND_NUMBER

Line 123: l_text:=l_text||fnd_number.number_to_canonical(p_competence_element_id);

119: l_text:='';
120: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
121: --
122: l_text:='';
123: l_text:=l_text||fnd_number.number_to_canonical(p_competence_element_id);
124: l_text:=l_text||'
';
125: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
126: l_text:='';
127: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);

Line 127: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);

123: l_text:=l_text||fnd_number.number_to_canonical(p_competence_element_id);
124: l_text:=l_text||'';
125: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
126: l_text:='';
127: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
128: l_text:=l_text||'
';
129: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
130: l_text:='';
131: l_text:=l_text||irc_utilities_pkg.removeTags(p_type);

Line 135: l_text:=l_text||fnd_number.number_to_canonical(p_business_group_id);

131: l_text:=l_text||irc_utilities_pkg.removeTags(p_type);
132: l_text:=l_text||'';
133: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
134: l_text:='';
135: l_text:=l_text||fnd_number.number_to_canonical(p_business_group_id);
136: l_text:=l_text||'
';
137: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
138: l_text:='';
139: l_text:=l_text||fnd_number.number_to_canonical(p_enterprise_id);

Line 139: l_text:=l_text||fnd_number.number_to_canonical(p_enterprise_id);

135: l_text:=l_text||fnd_number.number_to_canonical(p_business_group_id);
136: l_text:=l_text||'';
137: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
138: l_text:='';
139: l_text:=l_text||fnd_number.number_to_canonical(p_enterprise_id);
140: l_text:=l_text||'
';
141: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
142: l_text:='';
143: l_text:=l_text||fnd_number.number_to_canonical(p_competence_id);

Line 143: l_text:=l_text||fnd_number.number_to_canonical(p_competence_id);

139: l_text:=l_text||fnd_number.number_to_canonical(p_enterprise_id);
140: l_text:=l_text||'';
141: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
142: l_text:='';
143: l_text:=l_text||fnd_number.number_to_canonical(p_competence_id);
144: l_text:=l_text||'
';
145: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
146: l_text:='';
147: l_text:=l_text||fnd_number.number_to_canonical(p_proficiency_level_id);

Line 147: l_text:=l_text||fnd_number.number_to_canonical(p_proficiency_level_id);

143: l_text:=l_text||fnd_number.number_to_canonical(p_competence_id);
144: l_text:=l_text||'';
145: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
146: l_text:='';
147: l_text:=l_text||fnd_number.number_to_canonical(p_proficiency_level_id);
148: l_text:=l_text||'
';
149: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
150: l_text:='';
151: l_text:=l_text||fnd_number.number_to_canonical(p_high_proficiency_level_id);

Line 151: l_text:=l_text||fnd_number.number_to_canonical(p_high_proficiency_level_id);

147: l_text:=l_text||fnd_number.number_to_canonical(p_proficiency_level_id);
148: l_text:=l_text||'';
149: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
150: l_text:='';
151: l_text:=l_text||fnd_number.number_to_canonical(p_high_proficiency_level_id);
152: l_text:=l_text||'
';
153: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
154: l_text:='';
155: l_text:=l_text||fnd_number.number_to_canonical(p_weighting_level_id);

Line 155: l_text:=l_text||fnd_number.number_to_canonical(p_weighting_level_id);

151: l_text:=l_text||fnd_number.number_to_canonical(p_high_proficiency_level_id);
152: l_text:=l_text||'';
153: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
154: l_text:='';
155: l_text:=l_text||fnd_number.number_to_canonical(p_weighting_level_id);
156: l_text:=l_text||'
';
157: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
158: l_text:='';
159: l_text:=l_text||fnd_number.number_to_canonical(p_rating_level_id);

Line 159: l_text:=l_text||fnd_number.number_to_canonical(p_rating_level_id);

155: l_text:=l_text||fnd_number.number_to_canonical(p_weighting_level_id);
156: l_text:=l_text||'';
157: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
158: l_text:='';
159: l_text:=l_text||fnd_number.number_to_canonical(p_rating_level_id);
160: l_text:=l_text||'
';
161: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
162: l_text:='';
163: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);

Line 163: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);

159: l_text:=l_text||fnd_number.number_to_canonical(p_rating_level_id);
160: l_text:=l_text||'';
161: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
162: l_text:='';
163: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
164: l_text:=l_text||'
';
165: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
166: l_text:='';
167: l_text:=l_text||fnd_number.number_to_canonical(p_job_id);

Line 167: l_text:=l_text||fnd_number.number_to_canonical(p_job_id);

163: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
164: l_text:=l_text||'';
165: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
166: l_text:='';
167: l_text:=l_text||fnd_number.number_to_canonical(p_job_id);
168: l_text:=l_text||'
';
169: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
170: l_text:='';
171: l_text:=l_text||fnd_number.number_to_canonical(p_valid_grade_id);

Line 171: l_text:=l_text||fnd_number.number_to_canonical(p_valid_grade_id);

167: l_text:=l_text||fnd_number.number_to_canonical(p_job_id);
168: l_text:=l_text||'';
169: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
170: l_text:='';
171: l_text:=l_text||fnd_number.number_to_canonical(p_valid_grade_id);
172: l_text:=l_text||'
';
173: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
174: l_text:='';
175: l_text:=l_text||fnd_number.number_to_canonical(p_position_id);

Line 175: l_text:=l_text||fnd_number.number_to_canonical(p_position_id);

171: l_text:=l_text||fnd_number.number_to_canonical(p_valid_grade_id);
172: l_text:=l_text||'';
173: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
174: l_text:='';
175: l_text:=l_text||fnd_number.number_to_canonical(p_position_id);
176: l_text:=l_text||'
';
177: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
178: l_text:='';
179: l_text:=l_text||fnd_number.number_to_canonical(p_organization_id);

Line 179: l_text:=l_text||fnd_number.number_to_canonical(p_organization_id);

175: l_text:=l_text||fnd_number.number_to_canonical(p_position_id);
176: l_text:=l_text||'';
177: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
178: l_text:='';
179: l_text:=l_text||fnd_number.number_to_canonical(p_organization_id);
180: l_text:=l_text||'
';
181: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
182: l_text:='';
183: l_text:=l_text||fnd_number.number_to_canonical(p_parent_competence_element_id);

Line 183: l_text:=l_text||fnd_number.number_to_canonical(p_parent_competence_element_id);

179: l_text:=l_text||fnd_number.number_to_canonical(p_organization_id);
180: l_text:=l_text||'';
181: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
182: l_text:='';
183: l_text:=l_text||fnd_number.number_to_canonical(p_parent_competence_element_id);
184: l_text:=l_text||'
';
185: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
186: l_text:='';
187: l_text:=l_text||fnd_number.number_to_canonical(p_activity_version_id);

Line 187: l_text:=l_text||fnd_number.number_to_canonical(p_activity_version_id);

183: l_text:=l_text||fnd_number.number_to_canonical(p_parent_competence_element_id);
184: l_text:=l_text||'';
185: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
186: l_text:='';
187: l_text:=l_text||fnd_number.number_to_canonical(p_activity_version_id);
188: l_text:=l_text||'
';
189: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
190: l_text:='';
191: l_text:=l_text||fnd_number.number_to_canonical(p_assessment_id);

Line 191: l_text:=l_text||fnd_number.number_to_canonical(p_assessment_id);

187: l_text:=l_text||fnd_number.number_to_canonical(p_activity_version_id);
188: l_text:=l_text||'';
189: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
190: l_text:='';
191: l_text:=l_text||fnd_number.number_to_canonical(p_assessment_id);
192: l_text:=l_text||'
';
193: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
194: l_text:='';
195: l_text:=l_text||fnd_number.number_to_canonical(p_assessment_type_id);

Line 195: l_text:=l_text||fnd_number.number_to_canonical(p_assessment_type_id);

191: l_text:=l_text||fnd_number.number_to_canonical(p_assessment_id);
192: l_text:=l_text||'';
193: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
194: l_text:='';
195: l_text:=l_text||fnd_number.number_to_canonical(p_assessment_type_id);
196: l_text:=l_text||'
';
197: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
198: l_text:='';
199: l_text:=l_text||irc_utilities_pkg.removeTags(p_mandatory);

Line 219: l_text:=l_text||fnd_number.number_to_canonical(p_normal_elapse_duration);

215: l_text:=l_text||irc_utilities_pkg.removeTags(p_competence_type);
216: l_text:=l_text||'';
217: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
218: l_text:='';
219: l_text:=l_text||fnd_number.number_to_canonical(p_normal_elapse_duration);
220: l_text:=l_text||'
';
221: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
222: l_text:='';
223: l_text:=l_text||irc_utilities_pkg.removeTags(p_normal_elapse_duration_unit);

Line 227: l_text:=l_text||fnd_number.number_to_canonical(p_sequence_number);

223: l_text:=l_text||irc_utilities_pkg.removeTags(p_normal_elapse_duration_unit);
224: l_text:=l_text||'';
225: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
226: l_text:='';
227: l_text:=l_text||fnd_number.number_to_canonical(p_sequence_number);
228: l_text:=l_text||'
';
229: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
230: l_text:='';
231: l_text:=l_text||irc_utilities_pkg.removeTags(p_source_of_proficiency_level);

Line 235: l_text:=l_text||fnd_number.number_to_canonical(p_line_score);

231: l_text:=l_text||irc_utilities_pkg.removeTags(p_source_of_proficiency_level);
232: l_text:=l_text||'';
233: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
234: l_text:='';
235: l_text:=l_text||fnd_number.number_to_canonical(p_line_score);
236: l_text:=l_text||'
';
237: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
238: l_text:='';
239: l_text:=l_text||fnd_date.date_to_canonical(p_certification_date);

Line 343: l_text:=l_text||fnd_number.number_to_canonical(p_object_id);

339: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
340: l_text:=l_text||'';
341: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
342: l_text:='';
343: l_text:=l_text||fnd_number.number_to_canonical(p_object_id);
344: l_text:=l_text||'
';
345: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
346: l_text:='';
347: l_text:=l_text||irc_utilities_pkg.removeTags(p_object_name);

Line 351: l_text:=l_text||fnd_number.number_to_canonical(p_party_id);

347: l_text:=l_text||irc_utilities_pkg.removeTags(p_object_name);
348: l_text:=l_text||'';
349: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
350: l_text:='';
351: l_text:=l_text||fnd_number.number_to_canonical(p_party_id);
352: l_text:=l_text||'
';
353: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
354: l_text:='';
355: l_text:=l_text||fnd_number.number_to_canonical(p_qualification_type_id);

Line 355: l_text:=l_text||fnd_number.number_to_canonical(p_qualification_type_id);

351: l_text:=l_text||fnd_number.number_to_canonical(p_party_id);
352: l_text:=l_text||'';
353: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
354: l_text:='';
355: l_text:=l_text||fnd_number.number_to_canonical(p_qualification_type_id);
356: l_text:=l_text||'
';
357: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
358: l_text:='';
359: l_text:=l_text||irc_utilities_pkg.removeTags(p_unit_standard_type);

Line 455: l_text:=l_text||fnd_number.number_to_canonical(p_appr_line_score);

451: l_text:=l_text||fnd_date.date_to_canonical(p_achieved_date);
452: l_text:=l_text||'';
453: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
454: l_text:='';
455: l_text:=l_text||fnd_number.number_to_canonical(p_appr_line_score);
456: l_text:=l_text||'
';
457: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
458: l_text:='';
459: --