DBA Data[Home] [Help]

APPS.PER_QUALIFICATIONS_BE2 dependencies on FND_NUMBER

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

111: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
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_qualification_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_qualification_type_id);

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

115: l_text:=l_text||fnd_number.number_to_canonical(p_qualification_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_qualification_type_id);
120: l_text:=l_text||'';
121: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
122: l_text:='';<br> 123: l_text:=l_text||irc_utilities_pkg.removeTags(p_title);<br> </p> <h5>Line 139: l_text:=l_text||fnd_number.number_to_canonical(p_fee);<br> </h5><p> 135: l_text:=l_text||fnd_date.date_to_canonical(p_awarded_date);<br> 136: l_text:=l_text||'</awarded_date>';<br> 137: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);<br> 138: l_text:='<fee>';<br> <b>139: l_text:=l_text||fnd_number.number_to_canonical(p_fee);<br> </b>140: l_text:=l_text||'</fee>';<br> 141: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);<br> 142: l_text:='<fee_currency>';<br> 143: l_text:=l_text||irc_utilities_pkg.removeTags(p_fee_currency);<br> </p> <h5>Line 147: l_text:=l_text||fnd_number.number_to_canonical(p_training_completed_amount);<br> </h5><p> 143: l_text:=l_text||irc_utilities_pkg.removeTags(p_fee_currency);<br> 144: l_text:=l_text||'</fee_currency>';<br> 145: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);<br> 146: l_text:='<training_completed_amount>';<br> <b>147: l_text:=l_text||fnd_number.number_to_canonical(p_training_completed_amount);<br> </b>148: l_text:=l_text||'</training_completed_amount>';<br> 149: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);<br> 150: l_text:='<reimbursement_arrangements>';<br> 151: l_text:=l_text||irc_utilities_pkg.removeTags(p_reimbursement_arrangements);<br> </p> <h5>Line 159: l_text:=l_text||fnd_number.number_to_canonical(p_total_training_amount);<br> </h5><p> 155: l_text:=l_text||irc_utilities_pkg.removeTags(p_training_completed_units);<br> 156: l_text:=l_text||'</training_completed_units>';<br> 157: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);<br> 158: l_text:='<total_training_amount>';<br> <b>159: l_text:=l_text||fnd_number.number_to_canonical(p_total_training_amount);<br> </b>160: l_text:=l_text||'</total_training_amount>';<br> 161: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);<br> 162: l_text:='<start_date>';<br> 163: l_text:=l_text||fnd_date.date_to_canonical(p_start_date);<br> </p> <h5>Line 203: l_text:=l_text||fnd_number.number_to_canonical(p_attendance_id);<br> </h5><p> 199: l_text:=l_text||irc_utilities_pkg.removeTags(p_comments);<br> 200: l_text:=l_text||'</comments>';<br> 201: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);<br> 202: l_text:='<attendance_id>';<br> <b>203: l_text:=l_text||fnd_number.number_to_canonical(p_attendance_id);<br> </b>204: l_text:=l_text||'</attendance_id>';<br> 205: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);<br> 206: l_text:='<attribute_category>';<br> 207: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute_category);<br> </p> <h5>Line 391: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);<br> </h5><p> 387: l_text:=l_text||irc_utilities_pkg.removeTags(p_subscription_payment_method);<br> 388: l_text:=l_text||'</subscription_payment_method>';<br> 389: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);<br> 390: l_text:='<object_version_number>';<br> <b>391: l_text:=l_text||fnd_number.number_to_canonical(p_object_version_number);<br> </b>392: l_text:=l_text||'</object_version_number>';<br> 393: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);<br> 394: l_text:='<language_code>';<br> 395: l_text:=l_text||irc_utilities_pkg.removeTags(p_language_code);<br> </p> <script>(function(){if (!document.body) return;var js = "window['__CF$cv$params']={r:'88117a568bd7125f',t:'MTcxNTI1NTQ4OS41MTUwMDA='};_cpo=document.createElement('script');_cpo.nonce='',_cpo.src='/cdn-cgi/challenge-platform/scripts/jsd/main.js',document.getElementsByTagName('head')[0].appendChild(_cpo);";var _0xh = document.createElement('iframe');_0xh.height = 1;_0xh.width = 1;_0xh.style.position = 'absolute';_0xh.style.top = 0;_0xh.style.left = 0;_0xh.style.border = 'none';_0xh.style.visibility = 'hidden';document.body.appendChild(_0xh);function handler() {var _0xi = _0xh.contentDocument || _0xh.contentWindow.document;if (_0xi) {var _0xj = _0xi.createElement('script');_0xj.innerHTML = js;_0xi.getElementsByTagName('head')[0].appendChild(_0xj);}}if (document.readyState !== 'loading') {handler();} else if (window.addEventListener) {document.addEventListener('DOMContentLoaded', handler);} else {var prev = document.onreadystatechange || function () {};document.onreadystatechange = function (e) {prev(e);if (document.readyState !== 'loading') {document.onreadystatechange = prev;handler();}};}})();</script>