44:
45: /*
46: ** Set language for iteration....
47: */
48: ota_mls_utility.set_session_nls_language(c_language.nls_language);
49: l_current_language := c_language.language_code;
50:
51: /*
52: ** Insert the TL rows.
87: end loop;
88:
89: p_rows_processed := l_rows_processed;
90:
91: ota_mls_utility.set_session_language_code( l_userenv_language_code );
92:
93: Exception
94: --
95: When Others Then
93: Exception
94: --
95: When Others Then
96: --
97: ota_mls_utility.set_session_language_code( l_userenv_language_code );
98: --
99: raise;
100: end;
101:
142:
143: /*
144: ** Set language for iteration....
145: */
146: ota_mls_utility.set_session_nls_language(c_language.nls_language);
147: l_current_language := c_language.language_code;
148:
149: /*
150: ** Insert the TL rows.
187: end loop;
188:
189: p_rows_processed := l_rows_processed;
190:
191: ota_mls_utility.set_session_language_code( l_userenv_language_code );
192:
193: Exception
194: --
195: When Others Then
193: Exception
194: --
195: When Others Then
196: --
197: ota_mls_utility.set_session_language_code( l_userenv_language_code );
198: --
199: raise;
200:
201: end;
243:
244: /*
245: ** Set language for iteration....
246: */
247: ota_mls_utility.set_session_nls_language(c_language.nls_language);
248: l_current_language := c_language.language_code;
249:
250: /*
251: ** Insert the TL rows.
284: end loop;
285:
286: p_rows_processed := l_rows_processed;
287:
288: ota_mls_utility.set_session_language_code( l_userenv_language_code );
289:
290: Exception
291: --
292: When Others Then
290: Exception
291: --
292: When Others Then
293: --
294: ota_mls_utility.set_session_language_code( l_userenv_language_code );
295: --
296: raise;
297:
298: end;
340:
341: /*
342: ** Set language for iteration....
343: */
344: ota_mls_utility.set_session_nls_language(c_language.nls_language);
345: l_current_language := c_language.language_code;
346:
347: /*
348: ** Insert the TL rows.
382: end loop;
383:
384: p_rows_processed := l_rows_processed;
385:
386: ota_mls_utility.set_session_language_code( l_userenv_language_code );
387:
388: Exception
389: --
390: When Others Then
388: Exception
389: --
390: When Others Then
391: --
392: ota_mls_utility.set_session_language_code( l_userenv_language_code );
393: --
394: raise;
395:
396: end;
438:
439: /*
440: ** Set language for iteration....
441: */
442: ota_mls_utility.set_session_nls_language(c_language.nls_language);
443: l_current_language := c_language.language_code;
444:
445: /*
446: ** Insert the TL rows.
482: end loop;
483:
484: p_rows_processed := l_rows_processed;
485:
486: ota_mls_utility.set_session_language_code( l_userenv_language_code );
487:
488: Exception
489: --
490: When Others Then
488: Exception
489: --
490: When Others Then
491: --
492: ota_mls_utility.set_session_language_code( l_userenv_language_code );
493: --
494: raise;
495:
496: end;