DBA Data[Home] [Help]

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 371: l_varchar2_tbl hr_jp_standard_pkg.t_varchar2_tbl;

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

Line 582: p_varchar2_tbl in hr_jp_standard_pkg.t_varchar2_tbl,

578: end if;
579: end concat_description;
580: --
581: function get_index_at(
582: p_varchar2_tbl in hr_jp_standard_pkg.t_varchar2_tbl,
583: p_index in number) return varchar2
584: is
585: begin
586: if p_varchar2_tbl.exists(p_index) then

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

604: elsif p_user_description is null then
605: l_description := p_system_description;
606: else
607: if p_is_zenkaku then
608: l_separator := hr_jp_standard_pkg.to_zenkaku(l_separator);
609: end if;
610: --
611: l_description := p_system_description || l_separator || p_user_description;
612: end if;

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

1086: concat_description(l_wtm_system_desc_kana,l_wtm_descriptions(i).description_kana,',');
1087: --
1088: end loop;
1089: --
1090: l_wtm_system_desc_kanji := hr_jp_standard_pkg.to_zenkaku(l_wtm_system_desc_kanji);
1091: l_wtm_system_desc_kana := hr_jp_standard_pkg.upper_kana(hr_jp_standard_pkg.to_hankaku(l_wtm_system_desc_kana, '?'));
1092: l_wtm_user_desc_kanji := hr_jp_standard_pkg.to_zenkaku(l_wtm_user_desc_kanji);
1093: l_wtm_user_desc_kana := hr_jp_standard_pkg.upper_kana(hr_jp_standard_pkg.to_hankaku(l_wtm_user_desc_kana, '?'));
1094: --

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

1087: --
1088: end loop;
1089: --
1090: l_wtm_system_desc_kanji := hr_jp_standard_pkg.to_zenkaku(l_wtm_system_desc_kanji);
1091: l_wtm_system_desc_kana := hr_jp_standard_pkg.upper_kana(hr_jp_standard_pkg.to_hankaku(l_wtm_system_desc_kana, '?'));
1092: l_wtm_user_desc_kanji := hr_jp_standard_pkg.to_zenkaku(l_wtm_user_desc_kanji);
1093: l_wtm_user_desc_kana := hr_jp_standard_pkg.upper_kana(hr_jp_standard_pkg.to_hankaku(l_wtm_user_desc_kana, '?'));
1094: --
1095: hr_utility.trace('***** original descriptions *****');

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

1088: end loop;
1089: --
1090: l_wtm_system_desc_kanji := hr_jp_standard_pkg.to_zenkaku(l_wtm_system_desc_kanji);
1091: l_wtm_system_desc_kana := hr_jp_standard_pkg.upper_kana(hr_jp_standard_pkg.to_hankaku(l_wtm_system_desc_kana, '?'));
1092: l_wtm_user_desc_kanji := hr_jp_standard_pkg.to_zenkaku(l_wtm_user_desc_kanji);
1093: l_wtm_user_desc_kana := hr_jp_standard_pkg.upper_kana(hr_jp_standard_pkg.to_hankaku(l_wtm_user_desc_kana, '?'));
1094: --
1095: hr_utility.trace('***** original descriptions *****');
1096: hr_utility.trace('itw_system_desc1_kanji: ' || l_itw_system_desc1_kanji);

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

1089: --
1090: l_wtm_system_desc_kanji := hr_jp_standard_pkg.to_zenkaku(l_wtm_system_desc_kanji);
1091: l_wtm_system_desc_kana := hr_jp_standard_pkg.upper_kana(hr_jp_standard_pkg.to_hankaku(l_wtm_system_desc_kana, '?'));
1092: l_wtm_user_desc_kanji := hr_jp_standard_pkg.to_zenkaku(l_wtm_user_desc_kanji);
1093: l_wtm_user_desc_kana := hr_jp_standard_pkg.upper_kana(hr_jp_standard_pkg.to_hankaku(l_wtm_user_desc_kana, '?'));
1094: --
1095: hr_utility.trace('***** original descriptions *****');
1096: hr_utility.trace('itw_system_desc1_kanji: ' || l_itw_system_desc1_kanji);
1097: hr_utility.trace('itw_system_desc2_kanji: ' || l_itw_system_desc2_kanji);

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

1132: -- which will truncate multibyte characters.
1133: --
1134: l_other2_rec.action_information23 := l_itw_system_desc1_kanji;
1135: --
1136: hr_jp_standard_pkg.to_table(l_itw_system_desc2_kanji, 240, l_varchar2_tbl);
1137: l_other2_rec.action_information15 := get_index_at(l_varchar2_tbl, 1);
1138: l_other2_rec.action_information16 := get_index_at(l_varchar2_tbl, 2);
1139: --
1140: hr_jp_standard_pkg.to_table(l_itw_user_desc_kanji, 240, l_varchar2_tbl);

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

1136: hr_jp_standard_pkg.to_table(l_itw_system_desc2_kanji, 240, l_varchar2_tbl);
1137: l_other2_rec.action_information15 := get_index_at(l_varchar2_tbl, 1);
1138: l_other2_rec.action_information16 := get_index_at(l_varchar2_tbl, 2);
1139: --
1140: hr_jp_standard_pkg.to_table(l_itw_user_desc_kanji, 240, l_varchar2_tbl);
1141: l_other2_rec.action_information25 := get_index_at(l_varchar2_tbl, 1);
1142: l_other2_rec.action_information26 := get_index_at(l_varchar2_tbl, 2);
1143: --
1144: hr_jp_standard_pkg.to_table(l_wtm_system_desc_kanji, 240, l_varchar2_tbl);

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

1140: hr_jp_standard_pkg.to_table(l_itw_user_desc_kanji, 240, l_varchar2_tbl);
1141: l_other2_rec.action_information25 := get_index_at(l_varchar2_tbl, 1);
1142: l_other2_rec.action_information26 := get_index_at(l_varchar2_tbl, 2);
1143: --
1144: hr_jp_standard_pkg.to_table(l_wtm_system_desc_kanji, 240, l_varchar2_tbl);
1145: l_other2_rec.action_information19 := get_index_at(l_varchar2_tbl, 1);
1146: l_other2_rec.action_information20 := get_index_at(l_varchar2_tbl, 2);
1147: --
1148: hr_jp_standard_pkg.to_table(l_wtm_system_desc_kana, 240, l_varchar2_tbl);

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

1144: hr_jp_standard_pkg.to_table(l_wtm_system_desc_kanji, 240, l_varchar2_tbl);
1145: l_other2_rec.action_information19 := get_index_at(l_varchar2_tbl, 1);
1146: l_other2_rec.action_information20 := get_index_at(l_varchar2_tbl, 2);
1147: --
1148: hr_jp_standard_pkg.to_table(l_wtm_system_desc_kana, 240, l_varchar2_tbl);
1149: l_other2_rec.action_information21 := get_index_at(l_varchar2_tbl, 1);
1150: l_other2_rec.action_information22 := get_index_at(l_varchar2_tbl, 2);
1151: --
1152: hr_jp_standard_pkg.to_table(l_wtm_user_desc_kanji, 240, l_varchar2_tbl);

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

1148: hr_jp_standard_pkg.to_table(l_wtm_system_desc_kana, 240, l_varchar2_tbl);
1149: l_other2_rec.action_information21 := get_index_at(l_varchar2_tbl, 1);
1150: l_other2_rec.action_information22 := get_index_at(l_varchar2_tbl, 2);
1151: --
1152: hr_jp_standard_pkg.to_table(l_wtm_user_desc_kanji, 240, l_varchar2_tbl);
1153: l_other2_rec.action_information27 := get_index_at(l_varchar2_tbl, 1);
1154: l_other2_rec.action_information28 := get_index_at(l_varchar2_tbl, 2);
1155: --
1156: hr_jp_standard_pkg.to_table(l_wtm_user_desc_kana, 240, l_varchar2_tbl);

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

1152: hr_jp_standard_pkg.to_table(l_wtm_user_desc_kanji, 240, l_varchar2_tbl);
1153: l_other2_rec.action_information27 := get_index_at(l_varchar2_tbl, 1);
1154: l_other2_rec.action_information28 := get_index_at(l_varchar2_tbl, 2);
1155: --
1156: hr_jp_standard_pkg.to_table(l_wtm_user_desc_kana, 240, l_varchar2_tbl);
1157: l_other2_rec.action_information29 := get_index_at(l_varchar2_tbl, 1);
1158: l_other2_rec.action_information30 := get_index_at(l_varchar2_tbl, 2);
1159: --
1160: hr_utility.set_location(c_proc, 90);