eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.HR_JP_STANDARD_PKG

Source


1 PACKAGE hr_jp_standard_pkg AS
2 /* $Header: hrjpstnd.pkh 120.9 2006/12/05 07:44:22 ttagawa noship $ */
3 type t_varchar2_tbl is table of varchar2(4000) index by binary_integer;
4 -- |---------------------------------------------------------------------------|
5 -- |-------------------------------< hextochar >-------------------------------|
6 -- |---------------------------------------------------------------------------|
7 FUNCTION hextochar(
8 	p_src		IN VARCHAR2,
9 	p_src_cset	IN VARCHAR2) RETURN VARCHAR2 DETERMINISTIC;
10 -- |---------------------------------------------------------------------------|
11 -- |------------------------------< sjhextochar >------------------------------|
12 -- |---------------------------------------------------------------------------|
13 FUNCTION sjhextochar(
14 	p_src		IN VARCHAR2) RETURN VARCHAR2 DETERMINISTIC;
15 -- |---------------------------------------------------------------------------|
16 -- |-------------------------------< chartohex >-------------------------------|
17 -- |---------------------------------------------------------------------------|
18 FUNCTION chartohex(
19 	p_src		IN VARCHAR2,
20 	p_dest_cset	IN VARCHAR2) RETURN VARCHAR2 DETERMINISTIC;
21 -- |---------------------------------------------------------------------------|
22 -- |------------------------------< chartosjhex >------------------------------|
23 -- |---------------------------------------------------------------------------|
24 FUNCTION chartosjhex(
25 	p_src		IN VARCHAR2) RETURN VARCHAR2 DETERMINISTIC;
26 -- |---------------------------------------------------------------------------|
27 -- |------------------------------< translate2 >-------------------------------|
28 -- |---------------------------------------------------------------------------|
29 function translate2(
30 	p_str		in varchar2,
31 	p_old_chrs	in varchar2,
32 	p_new_chrs	in varchar2 default null) return varchar2 deterministic;
33 -- |---------------------------------------------------------------------------|
34 -- |---------------------------------< strip >---------------------------------|
35 -- |---------------------------------------------------------------------------|
36 function strip(
37 	p_str			in varchar2,
38 	p_chrs			in varchar2,
39 	p_replacement_chr	in varchar2 default null) return varchar2 deterministic;
40 -- |---------------------------------------------------------------------------|
41 -- |---------------------------< recursive_replace >---------------------------|
42 -- |---------------------------------------------------------------------------|
43 function recursive_replace(
44 	p_str		in varchar2,
45 	p_old_str	in varchar2,
46 	p_new_str	in varchar2 default null) return varchar2 deterministic;
47 -- |---------------------------------------------------------------------------|
48 -- |--------------------------------< round2 >---------------------------------|
49 -- |---------------------------------------------------------------------------|
50 function round2(
51 	p_num		in number,
52 	p_places	in number default 0) return number deterministic;
53 -- |---------------------------------------------------------------------------|
54 -- |------------------------------< is_integer >-------------------------------|
55 -- |---------------------------------------------------------------------------|
56 function is_integer(p_num in number) return varchar2 deterministic;
57 -- |---------------------------------------------------------------------------|
58 -- |------------------------------< is_hankaku >-------------------------------|
59 -- |---------------------------------------------------------------------------|
60 function is_hankaku(p_chr in varchar2) return boolean deterministic;
61 -- |---------------------------------------------------------------------------|
62 -- |------------------------------< is_zenkaku >-------------------------------|
63 -- |---------------------------------------------------------------------------|
64 function is_zenkaku(p_chr in varchar2) return boolean deterministic;
65 -- |---------------------------------------------------------------------------|
66 -- |------------------------------< to_hankaku >-------------------------------|
67 -- |---------------------------------------------------------------------------|
68 function to_hankaku(
69 	p_chr			in varchar2,
70 	p_replacement_chr	in varchar2) return varchar2 deterministic;
71 function to_hankaku(
72 	p_chr			in varchar2) return varchar2 deterministic;
73 -- |---------------------------------------------------------------------------|
74 -- |------------------------------< to_zenkaku >-------------------------------|
75 -- |---------------------------------------------------------------------------|
76 function to_zenkaku(
77 	p_chr			in varchar2,
78 	p_replacement_chr	in varchar2) return varchar2 deterministic;
79 function to_zenkaku(
80 	p_chr			in varchar2) return varchar2 deterministic;
81 -- |---------------------------------------------------------------------------|
82 -- |------------------------------< lower_kana >-------------------------------|
83 -- |---------------------------------------------------------------------------|
84 function lower_kana(p_chr in varchar2) return varchar2 deterministic;
85 -- |---------------------------------------------------------------------------|
86 -- |------------------------------< upper_kana >-------------------------------|
87 -- |---------------------------------------------------------------------------|
88 function upper_kana(p_chr in varchar2) return varchar2 deterministic;
89 -- |---------------------------------------------------------------------------|
90 -- |-----------------------------< upper_hankaku >-----------------------------|
91 -- |---------------------------------------------------------------------------|
92 function upper_hankaku(p_chr in varchar2) return varchar2 deterministic;
93 -- |---------------------------------------------------------------------------|
94 -- |-------------------------------< to_table >--------------------------------|
95 -- |---------------------------------------------------------------------------|
96 procedure to_table(
97 	p_str		in varchar2,
98 	p_lengthb	in binary_integer,
99 	p_str_tbl	out nocopy t_varchar2_tbl);
100 function to_table(
101 	p_str		in varchar2,
102 	p_lengthb	in binary_integer) return FND_TABLE_OF_VARCHAR2_4000 deterministic;
103 function get_index_at(
104 	p_varchar2_tbl	in hr_jp_standard_pkg.t_varchar2_tbl,
105 	p_index		in number) return varchar2 deterministic;
106 -- |---------------------------------------------------------------------------|
107 -- |------------------------------< to_jp_char >-------------------------------|
108 -- |---------------------------------------------------------------------------|
109 function to_jp_char(
110 	p_date		in date,
111 	p_date_format	in varchar2 default null) return varchar2 deterministic;
112 -- |---------------------------------------------------------------------------|
113 -- |------------------------------< to_jp_date >-------------------------------|
114 -- |---------------------------------------------------------------------------|
115 function to_jp_date(
116 	p_str		in varchar2,
117 	p_date_format	in varchar2 default null) return date deterministic;
118 -- |---------------------------------------------------------------------------|
119 -- |------------------------------< to_jis8_raw >------------------------------|
120 -- |---------------------------------------------------------------------------|
121 function to_jis8_raw(
122 	p_chr	in varchar2,
123 	p_ki	in raw default null,
124 	p_ko	in raw default null) return raw deterministic;
125 -- |---------------------------------------------------------------------------|
126 -- |--------------------------------< to_jis8 >--------------------------------|
127 -- |---------------------------------------------------------------------------|
128 function to_jis8(
129 	p_chr	in varchar2,
130 	p_ki	in raw default null,
131 	p_ko	in raw default null) return varchar2 deterministic;
132 -- |---------------------------------------------------------------------------|
133 -- |----------------------------------< gcd >----------------------------------|
134 -- |---------------------------------------------------------------------------|
135 function gcd(a integer, b integer) return integer deterministic;
136 -- |---------------------------------------------------------------------------|
137 -- |----------------------------------< lcm >----------------------------------|
138 -- |---------------------------------------------------------------------------|
139 function lcm(a integer, b integer) return integer deterministic;
140 -- |---------------------------------------------------------------------------|
141 -- |------------------------------< get_message >------------------------------|
142 -- |---------------------------------------------------------------------------|
143 /*
144 function get_message(
145 	p_application_short_name	in varchar2,
146 	p_message_name			in varchar2,
147 	p_token_name1			in varchar2 default null,
148 	p_token_value1			in varchar2 default null,
149 	p_token_name2			in varchar2 default null,
150 	p_token_value2			in varchar2 default null,
151 	p_token_name3			in varchar2 default null,
152 	p_token_value3			in varchar2 default null,
153 	p_token_name4			in varchar2 default null,
154 	p_token_value4			in varchar2 default null,
155 	p_token_name5			in varchar2 default null,
156 	p_token_value5			in varchar2 default null) return varchar2;
157 */
158 function get_message(
159 	p_application_short_name	in varchar2,
160 	p_message_name			in varchar2,
161 	p_language_code			in varchar2,
162 	p_token_name1			in varchar2 default null,
163 	p_token_value1			in varchar2 default null,
164 	p_token_name2			in varchar2 default null,
165 	p_token_value2			in varchar2 default null,
166 	p_token_name3			in varchar2 default null,
167 	p_token_value3			in varchar2 default null,
168 	p_token_name4			in varchar2 default null,
169 	p_token_value4			in varchar2 default null,
170 	p_token_name5			in varchar2 default null,
171 	p_token_value5			in varchar2 default null) return varchar2 deterministic;
172 --
173 END hr_jp_standard_pkg;