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.

APPS.PAY_JP_ITAX_ARCHIVE_PKG dependencies on STANDARD

Line 78: l_char_date := hr_jp_standard_pkg.to_jp_char(p_date, 'EYYMMDD');

74: begin
75: hr_utility.trace('jp_date: ' || p_date);
76: --
77: if p_date is not null then
78: l_char_date := hr_jp_standard_pkg.to_jp_char(p_date, 'EYYMMDD');
79: l_era_code := substr(l_char_date, 1, 1);
80: --
81: p_meiji := check_when_true(l_era_code = 'M');
82: p_taishou := check_when_true(l_era_code = 'T');

Line 369: l_varchar2_tbl hr_jp_standard_pkg.t_varchar2_tbl;

365: l_itw_system_desc1_kanji varchar2(32767);
366: l_itw_system_desc2_kanji varchar2(32767);
367: l_wtm_system_desc_kanji varchar2(32767);
368: l_wtm_system_desc_kana varchar2(32767);
369: l_varchar2_tbl hr_jp_standard_pkg.t_varchar2_tbl;
370: --
371: l_person_rec pay_action_information%rowtype;
372: l_arch_rec pay_action_information%rowtype;
373: l_tax_rec pay_action_information%rowtype;

Line 571: p_varchar2_tbl in hr_jp_standard_pkg.t_varchar2_tbl,

567: end if;
568: end concat_description;
569: --
570: function get_index_at(
571: p_varchar2_tbl in hr_jp_standard_pkg.t_varchar2_tbl,
572: p_index in number) return varchar2
573: is
574: begin
575: if p_varchar2_tbl.exists(p_index) then

Line 597: l_separator := hr_jp_standard_pkg.to_zenkaku(l_separator);

593: elsif p_user_description is null then
594: l_description := p_system_description;
595: else
596: if p_is_zenkaku then
597: l_separator := hr_jp_standard_pkg.to_zenkaku(l_separator);
598: end if;
599: --
600: l_description := p_system_description || l_separator || p_user_description;
601: end if;

Line 1021: l_wtm_system_desc_kanji := hr_jp_standard_pkg.to_zenkaku(l_wtm_system_desc_kanji);

1017: concat_description(l_wtm_system_desc_kanji, l_wtm_descriptions(i).description_kanji, ',');
1018: concat_description(l_wtm_system_desc_kana, l_wtm_descriptions(i).description_kana, ',');
1019: end loop;
1020: --
1021: l_wtm_system_desc_kanji := hr_jp_standard_pkg.to_zenkaku(l_wtm_system_desc_kanji);
1022: l_wtm_system_desc_kana := hr_jp_standard_pkg.upper_kana(hr_jp_standard_pkg.to_hankaku(l_wtm_system_desc_kana, '?'));
1023: l_wtm_user_desc_kanji := hr_jp_standard_pkg.to_zenkaku(l_wtm_user_desc_kanji);
1024: l_wtm_user_desc_kana := hr_jp_standard_pkg.upper_kana(hr_jp_standard_pkg.to_hankaku(l_wtm_user_desc_kana, '?'));
1025: --

Line 1022: l_wtm_system_desc_kana := hr_jp_standard_pkg.upper_kana(hr_jp_standard_pkg.to_hankaku(l_wtm_system_desc_kana, '?'));

1018: concat_description(l_wtm_system_desc_kana, l_wtm_descriptions(i).description_kana, ',');
1019: end loop;
1020: --
1021: l_wtm_system_desc_kanji := hr_jp_standard_pkg.to_zenkaku(l_wtm_system_desc_kanji);
1022: l_wtm_system_desc_kana := hr_jp_standard_pkg.upper_kana(hr_jp_standard_pkg.to_hankaku(l_wtm_system_desc_kana, '?'));
1023: l_wtm_user_desc_kanji := hr_jp_standard_pkg.to_zenkaku(l_wtm_user_desc_kanji);
1024: l_wtm_user_desc_kana := hr_jp_standard_pkg.upper_kana(hr_jp_standard_pkg.to_hankaku(l_wtm_user_desc_kana, '?'));
1025: --
1026: hr_utility.trace('***** original descriptions *****');

Line 1023: l_wtm_user_desc_kanji := hr_jp_standard_pkg.to_zenkaku(l_wtm_user_desc_kanji);

1019: end loop;
1020: --
1021: l_wtm_system_desc_kanji := hr_jp_standard_pkg.to_zenkaku(l_wtm_system_desc_kanji);
1022: l_wtm_system_desc_kana := hr_jp_standard_pkg.upper_kana(hr_jp_standard_pkg.to_hankaku(l_wtm_system_desc_kana, '?'));
1023: l_wtm_user_desc_kanji := hr_jp_standard_pkg.to_zenkaku(l_wtm_user_desc_kanji);
1024: l_wtm_user_desc_kana := hr_jp_standard_pkg.upper_kana(hr_jp_standard_pkg.to_hankaku(l_wtm_user_desc_kana, '?'));
1025: --
1026: hr_utility.trace('***** original descriptions *****');
1027: hr_utility.trace('itw_system_desc1_kanji: ' || l_itw_system_desc1_kanji);

Line 1024: l_wtm_user_desc_kana := hr_jp_standard_pkg.upper_kana(hr_jp_standard_pkg.to_hankaku(l_wtm_user_desc_kana, '?'));

1020: --
1021: l_wtm_system_desc_kanji := hr_jp_standard_pkg.to_zenkaku(l_wtm_system_desc_kanji);
1022: l_wtm_system_desc_kana := hr_jp_standard_pkg.upper_kana(hr_jp_standard_pkg.to_hankaku(l_wtm_system_desc_kana, '?'));
1023: l_wtm_user_desc_kanji := hr_jp_standard_pkg.to_zenkaku(l_wtm_user_desc_kanji);
1024: l_wtm_user_desc_kana := hr_jp_standard_pkg.upper_kana(hr_jp_standard_pkg.to_hankaku(l_wtm_user_desc_kana, '?'));
1025: --
1026: hr_utility.trace('***** original descriptions *****');
1027: hr_utility.trace('itw_system_desc1_kanji: ' || l_itw_system_desc1_kanji);
1028: hr_utility.trace('itw_system_desc2_kanji: ' || l_itw_system_desc2_kanji);

Line 1065: hr_jp_standard_pkg.to_table(l_itw_system_desc2_kanji, 240, l_varchar2_tbl);

1061: -- which will truncate multibyte characters.
1062: --
1063: l_other2_rec.action_information23 := l_itw_system_desc1_kanji;
1064: --
1065: hr_jp_standard_pkg.to_table(l_itw_system_desc2_kanji, 240, l_varchar2_tbl);
1066: l_other2_rec.action_information15 := get_index_at(l_varchar2_tbl, 1);
1067: l_other2_rec.action_information16 := get_index_at(l_varchar2_tbl, 2);
1068: --
1069: hr_jp_standard_pkg.to_table(l_itw_user_desc_kanji, 240, l_varchar2_tbl);

Line 1069: hr_jp_standard_pkg.to_table(l_itw_user_desc_kanji, 240, l_varchar2_tbl);

1065: hr_jp_standard_pkg.to_table(l_itw_system_desc2_kanji, 240, l_varchar2_tbl);
1066: l_other2_rec.action_information15 := get_index_at(l_varchar2_tbl, 1);
1067: l_other2_rec.action_information16 := get_index_at(l_varchar2_tbl, 2);
1068: --
1069: hr_jp_standard_pkg.to_table(l_itw_user_desc_kanji, 240, l_varchar2_tbl);
1070: l_other2_rec.action_information25 := get_index_at(l_varchar2_tbl, 1);
1071: l_other2_rec.action_information26 := get_index_at(l_varchar2_tbl, 2);
1072: --
1073: hr_jp_standard_pkg.to_table(l_wtm_system_desc_kanji, 240, l_varchar2_tbl);

Line 1073: hr_jp_standard_pkg.to_table(l_wtm_system_desc_kanji, 240, l_varchar2_tbl);

1069: hr_jp_standard_pkg.to_table(l_itw_user_desc_kanji, 240, l_varchar2_tbl);
1070: l_other2_rec.action_information25 := get_index_at(l_varchar2_tbl, 1);
1071: l_other2_rec.action_information26 := get_index_at(l_varchar2_tbl, 2);
1072: --
1073: hr_jp_standard_pkg.to_table(l_wtm_system_desc_kanji, 240, l_varchar2_tbl);
1074: l_other2_rec.action_information19 := get_index_at(l_varchar2_tbl, 1);
1075: l_other2_rec.action_information20 := get_index_at(l_varchar2_tbl, 2);
1076: --
1077: hr_jp_standard_pkg.to_table(l_wtm_system_desc_kana, 240, l_varchar2_tbl);

Line 1077: hr_jp_standard_pkg.to_table(l_wtm_system_desc_kana, 240, l_varchar2_tbl);

1073: hr_jp_standard_pkg.to_table(l_wtm_system_desc_kanji, 240, l_varchar2_tbl);
1074: l_other2_rec.action_information19 := get_index_at(l_varchar2_tbl, 1);
1075: l_other2_rec.action_information20 := get_index_at(l_varchar2_tbl, 2);
1076: --
1077: hr_jp_standard_pkg.to_table(l_wtm_system_desc_kana, 240, l_varchar2_tbl);
1078: l_other2_rec.action_information21 := get_index_at(l_varchar2_tbl, 1);
1079: l_other2_rec.action_information22 := get_index_at(l_varchar2_tbl, 2);
1080: --
1081: hr_jp_standard_pkg.to_table(l_wtm_user_desc_kanji, 240, l_varchar2_tbl);

Line 1081: hr_jp_standard_pkg.to_table(l_wtm_user_desc_kanji, 240, l_varchar2_tbl);

1077: hr_jp_standard_pkg.to_table(l_wtm_system_desc_kana, 240, l_varchar2_tbl);
1078: l_other2_rec.action_information21 := get_index_at(l_varchar2_tbl, 1);
1079: l_other2_rec.action_information22 := get_index_at(l_varchar2_tbl, 2);
1080: --
1081: hr_jp_standard_pkg.to_table(l_wtm_user_desc_kanji, 240, l_varchar2_tbl);
1082: l_other2_rec.action_information27 := get_index_at(l_varchar2_tbl, 1);
1083: l_other2_rec.action_information28 := get_index_at(l_varchar2_tbl, 2);
1084: --
1085: hr_jp_standard_pkg.to_table(l_wtm_user_desc_kana, 240, l_varchar2_tbl);

Line 1085: hr_jp_standard_pkg.to_table(l_wtm_user_desc_kana, 240, l_varchar2_tbl);

1081: hr_jp_standard_pkg.to_table(l_wtm_user_desc_kanji, 240, l_varchar2_tbl);
1082: l_other2_rec.action_information27 := get_index_at(l_varchar2_tbl, 1);
1083: l_other2_rec.action_information28 := get_index_at(l_varchar2_tbl, 2);
1084: --
1085: hr_jp_standard_pkg.to_table(l_wtm_user_desc_kana, 240, l_varchar2_tbl);
1086: l_other2_rec.action_information29 := get_index_at(l_varchar2_tbl, 1);
1087: l_other2_rec.action_information30 := get_index_at(l_varchar2_tbl, 2);
1088: --
1089: hr_utility.set_location(c_proc, 90);