447: -- ----------------------------------------------------------------------------
448: procedure derive_locale(p_rec in out nocopy per_add_shd.g_rec_type)
449: is
450: --
451: l_number_table dbms_describe.number_table;
452: l_varchar_table dbms_describe.varchar2_table;
453: l_package_exists boolean;
454: l_package_name varchar2(2000);
455: l_seperator varchar2(1);
448: procedure derive_locale(p_rec in out nocopy per_add_shd.g_rec_type)
449: is
450: --
451: l_number_table dbms_describe.number_table;
452: l_varchar_table dbms_describe.varchar2_table;
453: l_package_exists boolean;
454: l_package_name varchar2(2000);
455: l_seperator varchar2(1);
456: --