DBA Data[Home] [Help]

APPS.HR_JP_STANDARD_PKG dependencies on UTL_RAW

Line 48: -- utl_raw.convert fails when l_raw is null.

44: l_raw RAW(2000);
45: l_src_lang VARCHAR2(91);
46: BEGIN
47: --
48: -- utl_raw.convert fails when l_raw is null.
49: --
50: if p_src is NULL then
51: return NULL;
52: else

Line 58: return utl_raw.cast_to_varchar2(utl_raw.convert(l_raw, c_nls_lang, l_src_lang));

54: -- Convert raw value to DB character set and return value with casted to varchar2.
55: --
56: l_raw := hextoraw(p_src);
57: l_src_lang := 'AMERICAN_AMERICA.' || p_src_cset;
58: return utl_raw.cast_to_varchar2(utl_raw.convert(l_raw, c_nls_lang, l_src_lang));
59: end if;
60: END hextochar;
61: -- |---------------------------------------------------------------------------|
62: -- |------------------------------< sjhextochar >------------------------------|

Line 86: -- utl_raw.convert fails when l_raw is null.

82: l_raw RAW(2000);
83: l_dest_lang VARCHAR2(91);
84: BEGIN
85: --
86: -- utl_raw.convert fails when l_raw is null.
87: --
88: if p_src is NULL then
89: return NULL;
90: else

Line 94: l_raw := utl_raw.cast_to_raw(p_src);

90: else
91: --
92: -- Convert raw value to DB character set and return value with casted to varchar2.
93: --
94: l_raw := utl_raw.cast_to_raw(p_src);
95: l_dest_lang := 'AMERICAN_AMERICA.' || p_dest_cset;
96: return rawtohex(utl_raw.convert(l_raw, l_dest_lang, c_nls_lang));
97: end if;
98: END chartohex;

Line 96: return rawtohex(utl_raw.convert(l_raw, l_dest_lang, c_nls_lang));

92: -- Convert raw value to DB character set and return value with casted to varchar2.
93: --
94: l_raw := utl_raw.cast_to_raw(p_src);
95: l_dest_lang := 'AMERICAN_AMERICA.' || p_dest_cset;
96: return rawtohex(utl_raw.convert(l_raw, l_dest_lang, c_nls_lang));
97: end if;
98: END chartohex;
99: -- |---------------------------------------------------------------------------|
100: -- |------------------------------< chartosjhex >------------------------------|

Line 794: return utl_raw.cast_to_varchar2(to_jis8_raw(p_chr, p_ki, p_ko));

790: p_ki in raw,
791: p_ko in raw) return varchar2
792: is
793: begin
794: return utl_raw.cast_to_varchar2(to_jis8_raw(p_chr, p_ki, p_ko));
795: end to_jis8;
796: -- |---------------------------------------------------------------------------|
797: -- |----------------------------------< gcd >----------------------------------|
798: -- |---------------------------------------------------------------------------|