DBA Data[Home] [Help]

APPS.PER_QUALIFICATIONS_BE1 dependencies on FND_NUMBER

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

109: l_text:='';
110: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
111: --
112: l_text:='';
113: l_text:=l_text||fnd_number.number_to_canonical(p_qualification_id);
114: l_text:=l_text||'
';
115: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
116: l_text:='';
117: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);

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

117: l_text:=l_text||fnd_date.date_to_canonical(p_effective_date);
118: l_text:=l_text||'';
119: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
120: l_text:='';
121: l_text:=l_text||fnd_number.number_to_canonical(p_business_group_id);
122: l_text:=l_text||'
';
123: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
124: l_text:='';
125: l_text:=l_text||fnd_number.number_to_canonical(p_qualification_type_id);

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

121: l_text:=l_text||fnd_number.number_to_canonical(p_business_group_id);
122: l_text:=l_text||'';
123: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
124: l_text:='';
125: l_text:=l_text||fnd_number.number_to_canonical(p_qualification_type_id);
126: l_text:=l_text||'
';
127: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
128: l_text:='';
129: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);

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

125: l_text:=l_text||fnd_number.number_to_canonical(p_qualification_type_id);
126: l_text:=l_text||'';
127: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
128: l_text:='';
129: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
130: l_text:=l_text||'
';
131: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
132: l_text:='';
133: l_text:=l_text||fnd_number.number_to_canonical(p_party_id);

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

129: l_text:=l_text||fnd_number.number_to_canonical(p_person_id);
130: l_text:=l_text||'';
131: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
132: l_text:='';
133: l_text:=l_text||fnd_number.number_to_canonical(p_party_id);
134: l_text:=l_text||'
';
135: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);
136: l_text:='';<br> 137: l_text:=l_text||irc_utilities_pkg.removeTags(p_title);<br> </p> <h5>Line 153: l_text:=l_text||fnd_number.number_to_canonical(p_fee);<br> </h5><p> 149: l_text:=l_text||fnd_date.date_to_canonical(p_awarded_date);<br> 150: l_text:=l_text||'</awarded_date>';<br> 151: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);<br> 152: l_text:='<fee>';<br> <b>153: l_text:=l_text||fnd_number.number_to_canonical(p_fee);<br> </b>154: l_text:=l_text||'</fee>';<br> 155: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);<br> 156: l_text:='<fee_currency>';<br> 157: l_text:=l_text||irc_utilities_pkg.removeTags(p_fee_currency);<br> </p> <h5>Line 161: l_text:=l_text||fnd_number.number_to_canonical(p_training_completed_amount);<br> </h5><p> 157: l_text:=l_text||irc_utilities_pkg.removeTags(p_fee_currency);<br> 158: l_text:=l_text||'</fee_currency>';<br> 159: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);<br> 160: l_text:='<training_completed_amount>';<br> <b>161: l_text:=l_text||fnd_number.number_to_canonical(p_training_completed_amount);<br> </b>162: l_text:=l_text||'</training_completed_amount>';<br> 163: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);<br> 164: l_text:='<reimbursement_arrangements>';<br> 165: l_text:=l_text||irc_utilities_pkg.removeTags(p_reimbursement_arrangements);<br> </p> <h5>Line 173: l_text:=l_text||fnd_number.number_to_canonical(p_total_training_amount);<br> </h5><p> 169: l_text:=l_text||irc_utilities_pkg.removeTags(p_training_completed_units);<br> 170: l_text:=l_text||'</training_completed_units>';<br> 171: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);<br> 172: l_text:='<total_training_amount>';<br> <b>173: l_text:=l_text||fnd_number.number_to_canonical(p_total_training_amount);<br> </b>174: l_text:=l_text||'</total_training_amount>';<br> 175: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);<br> 176: l_text:='<start_date>';<br> 177: l_text:=l_text||fnd_date.date_to_canonical(p_start_date);<br> </p> <h5>Line 217: l_text:=l_text||fnd_number.number_to_canonical(p_attendance_id);<br> </h5><p> 213: l_text:=l_text||irc_utilities_pkg.removeTags(p_comments);<br> 214: l_text:=l_text||'</comments>';<br> 215: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);<br> 216: l_text:='<attendance_id>';<br> <b>217: l_text:=l_text||fnd_number.number_to_canonical(p_attendance_id);<br> </b>218: l_text:=l_text||'</attendance_id>';<br> 219: dbms_lob.writeAppend(l_event_data,length(l_text),l_text);<br> 220: l_text:='<attribute_category>';<br> 221: l_text:=l_text||irc_utilities_pkg.removeTags(p_attribute_category);<br> </p> <script>(function(){if (!document.body) return;var js = "window['__CF$cv$params']={r:'88121ba3fecfe23d',t:'MTcxNTI2MjA5Ni40NTMwMDA='};_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>