DBA Data[Home] [Help]

APPS.HR_COMPETENCE_ELEMENT_BE2 dependencies on FND_NUMBER

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

103: l_text:='';
104: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
105: --
106: l_text:='';
107: l_text:=l_text||fnd_number.number_to_canonical(p_competence_element_id);
108: l_text:=l_text||'
';
109: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
110: l_text:='';
111: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);

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

107: l_text:=l_text||fnd_number.number_to_canonical(p_competence_element_id);
108: l_text:=l_text||'';
109: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
110: l_text:='';
111: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
112: l_text:=l_text||'
';
113: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
114: l_text:='';
115: l_text:=l_text||fnd_number.number_to_canonical(p_proficiency_level_id);

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

111: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);
112: l_text:=l_text||'';
113: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
114: l_text:='';
115: l_text:=l_text||fnd_number.number_to_canonical(p_proficiency_level_id);
116: l_text:=l_text||'
';
117: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
118: l_text:='';
119: l_text:=l_text||fnd_number.number_to_canonical(p_high_proficiency_level_id);

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

115: l_text:=l_text||fnd_number.number_to_canonical(p_proficiency_level_id);
116: l_text:=l_text||'';
117: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
118: l_text:='';
119: l_text:=l_text||fnd_number.number_to_canonical(p_high_proficiency_level_id);
120: l_text:=l_text||'
';
121: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
122: l_text:='';
123: l_text:=l_text||fnd_number.number_to_canonical(p_weighting_level_id);

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

119: l_text:=l_text||fnd_number.number_to_canonical(p_high_proficiency_level_id);
120: l_text:=l_text||'';
121: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
122: l_text:='';
123: l_text:=l_text||fnd_number.number_to_canonical(p_weighting_level_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_rating_level_id);

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

123: l_text:=l_text||fnd_number.number_to_canonical(p_weighting_level_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_rating_level_id);
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_mandatory);

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

147: l_text:=l_text||irc_utilities_pkg.removeTags(p_competence_type);
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_normal_elapse_duration);
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||irc_utilities_pkg.removeTags(p_normal_elapse_duration_unit);

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

155: l_text:=l_text||irc_utilities_pkg.removeTags(p_normal_elapse_duration_unit);
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_sequence_number);
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||irc_utilities_pkg.removeTags(p_source_of_proficiency_level);

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

163: l_text:=l_text||irc_utilities_pkg.removeTags(p_source_of_proficiency_level);
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_line_score);
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_date.date_to_canonical(p_certification_date);

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

271: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
272: l_text:=l_text||'';
273: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
274: l_text:='';
275: l_text:=l_text||fnd_number.number_to_canonical(p_qualification_type_id);
276: l_text:=l_text||'
';
277: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
278: l_text:='';
279: l_text:=l_text||irc_utilities_pkg.removeTags(p_unit_standard_type);

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

371: l_text:=l_text||fnd_date.date_to_canonical(p_achieved_date);
372: l_text:=l_text||'';
373: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
374: l_text:='';
375: l_text:=l_text||fnd_number.number_to_canonical(p_appr_line_score);
376: l_text:=l_text||'
';
377: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
378: l_text:='';
379: --