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_WIC_PKG dependencies on STANDARD

Line 563: l_prev_job_info.salary_payer_address_kanji := hr_jp_standard_pkg.to_zenkaku(l_prev_job_info.salary_payer_address_kanji);

559: for i in 1..l_prev_jobs_count loop
560: if i = 1 then
561: l_prev_job_info := p_prev_jobs(i);
562: --
563: l_prev_job_info.salary_payer_address_kanji := hr_jp_standard_pkg.to_zenkaku(l_prev_job_info.salary_payer_address_kanji);
564: l_prev_job_info.salary_payer_address_kana := hr_jp_standard_pkg.upper_kana(
565: hr_jp_standard_pkg.to_hankaku(l_prev_job_info.salary_payer_address_kana, '?'));
566: --
567: if l_prev_jobs_count > 1 then

Line 564: l_prev_job_info.salary_payer_address_kana := hr_jp_standard_pkg.upper_kana(

560: if i = 1 then
561: l_prev_job_info := p_prev_jobs(i);
562: --
563: l_prev_job_info.salary_payer_address_kanji := hr_jp_standard_pkg.to_zenkaku(l_prev_job_info.salary_payer_address_kanji);
564: l_prev_job_info.salary_payer_address_kana := hr_jp_standard_pkg.upper_kana(
565: hr_jp_standard_pkg.to_hankaku(l_prev_job_info.salary_payer_address_kana, '?'));
566: --
567: if l_prev_jobs_count > 1 then
568: l_prev_job_info.salary_payer_name_kanji := ltrim( l_prev_job_info.salary_payer_name_kanji

Line 565: hr_jp_standard_pkg.to_hankaku(l_prev_job_info.salary_payer_address_kana, '?'));

561: l_prev_job_info := p_prev_jobs(i);
562: --
563: l_prev_job_info.salary_payer_address_kanji := hr_jp_standard_pkg.to_zenkaku(l_prev_job_info.salary_payer_address_kanji);
564: l_prev_job_info.salary_payer_address_kana := hr_jp_standard_pkg.upper_kana(
565: hr_jp_standard_pkg.to_hankaku(l_prev_job_info.salary_payer_address_kana, '?'));
566: --
567: if l_prev_jobs_count > 1 then
568: l_prev_job_info.salary_payer_name_kanji := ltrim( l_prev_job_info.salary_payer_name_kanji
569: || ' '

Line 581: l_prev_job_info.salary_payer_name_kanji := hr_jp_standard_pkg.to_zenkaku(l_prev_job_info.salary_payer_name_kanji);

577: || to_char(l_prev_jobs_count - 1)
578: || g_prompt_kana.count);
579: end if;
580: --
581: l_prev_job_info.salary_payer_name_kanji := hr_jp_standard_pkg.to_zenkaku(l_prev_job_info.salary_payer_name_kanji);
582: l_prev_job_info.salary_payer_name_kana := hr_jp_standard_pkg.upper_kana(
583: hr_jp_standard_pkg.to_hankaku(l_prev_job_info.salary_payer_name_kana, '?'));
584: else
585: l_prev_job_info.taxable_income := l_prev_job_info.taxable_income + p_prev_jobs(i).taxable_income;

Line 582: l_prev_job_info.salary_payer_name_kana := hr_jp_standard_pkg.upper_kana(

578: || g_prompt_kana.count);
579: end if;
580: --
581: l_prev_job_info.salary_payer_name_kanji := hr_jp_standard_pkg.to_zenkaku(l_prev_job_info.salary_payer_name_kanji);
582: l_prev_job_info.salary_payer_name_kana := hr_jp_standard_pkg.upper_kana(
583: hr_jp_standard_pkg.to_hankaku(l_prev_job_info.salary_payer_name_kana, '?'));
584: else
585: l_prev_job_info.taxable_income := l_prev_job_info.taxable_income + p_prev_jobs(i).taxable_income;
586: -- mutual_aid_prem can be , so remember to use nvl before adding.

Line 583: hr_jp_standard_pkg.to_hankaku(l_prev_job_info.salary_payer_name_kana, '?'));

579: end if;
580: --
581: l_prev_job_info.salary_payer_name_kanji := hr_jp_standard_pkg.to_zenkaku(l_prev_job_info.salary_payer_name_kanji);
582: l_prev_job_info.salary_payer_name_kana := hr_jp_standard_pkg.upper_kana(
583: hr_jp_standard_pkg.to_hankaku(l_prev_job_info.salary_payer_name_kana, '?'));
584: else
585: l_prev_job_info.taxable_income := l_prev_job_info.taxable_income + p_prev_jobs(i).taxable_income;
586: -- mutual_aid_prem can be , so remember to use nvl before adding.
587: if p_prev_jobs(i).mutual_aid_prem <> 0 then

Line 859: hr_jp_standard_pkg.to_hankaku(hr_general.decode_lookup('JP_CONTACT_KANA', ctr.contact_type))) D_CONTACT_TYPE_KANA,

855: per.date_of_birth,
856: decode(ctr.contact_type, 'S', decode(p_sex, 'F', g_prompt_kanji.husband, g_prompt_kanji.wife),
857: hr_general.decode_lookup('CONTACT', ctr.contact_type)) D_CONTACT_TYPE_KANJI,
858: decode(ctr.contact_type, 'S', decode(p_sex, 'F', g_prompt_kana.husband, g_prompt_kana.wife),
859: hr_jp_standard_pkg.to_hankaku(hr_general.decode_lookup('JP_CONTACT_KANA', ctr.contact_type))) D_CONTACT_TYPE_KANA,
860: trunc(months_between(
861: to_date(decode(to_char(nvl(least(per.date_of_death, p_effective_date), p_effective_date),'YYYY/MM/DD'),
862: to_char(per.date_of_death,'YYYY/MM/DD'), to_char(per.date_of_death,'YYYY/MM/DD'),
863: to_char(add_months(trunc(p_effective_date, 'YYYY'), 12) - 1,'YYYY/MM/DD')),'YYYY/MM/DD') + 1,

Line 1205: -- hr_jp_standard_pkg.to_zenkaku.

1201: l_index := p_descriptions.count + 1;
1202: --
1203: -- PAYJPITW outputs mixed Kanji/Kana characters
1204: -- into description field, so do not use
1205: -- hr_jp_standard_pkg.to_zenkaku.
1206: -- Use hr_jp_standard_pkg.to_zenkaku just before
1207: -- outputting those in reports, e.g. PAYJPWTM.
1208: --
1209: p_descriptions(l_index).description_type := p_description_type;

Line 1206: -- Use hr_jp_standard_pkg.to_zenkaku just before

1202: --
1203: -- PAYJPITW outputs mixed Kanji/Kana characters
1204: -- into description field, so do not use
1205: -- hr_jp_standard_pkg.to_zenkaku.
1206: -- Use hr_jp_standard_pkg.to_zenkaku just before
1207: -- outputting those in reports, e.g. PAYJPWTM.
1208: --
1209: p_descriptions(l_index).description_type := p_description_type;
1210: p_descriptions(l_index).description_kanji := p_description_kanji;

Line 1211: -- p_descriptions(l_index).description_kana := hr_jp_standard_pkg.upper_kana(

1207: -- outputting those in reports, e.g. PAYJPWTM.
1208: --
1209: p_descriptions(l_index).description_type := p_description_type;
1210: p_descriptions(l_index).description_kanji := p_description_kanji;
1211: -- p_descriptions(l_index).description_kana := hr_jp_standard_pkg.upper_kana(
1212: -- hr_jp_standard_pkg.to_hankaku(p_description_kana, '?'));
1213: p_descriptions(l_index).description_kana := hr_jp_standard_pkg.to_hankaku(p_description_kana, '?');
1214: end add_description;
1215: -- |-------------------------------------------------------------------|

Line 1212: -- hr_jp_standard_pkg.to_hankaku(p_description_kana, '?'));

1208: --
1209: p_descriptions(l_index).description_type := p_description_type;
1210: p_descriptions(l_index).description_kanji := p_description_kanji;
1211: -- p_descriptions(l_index).description_kana := hr_jp_standard_pkg.upper_kana(
1212: -- hr_jp_standard_pkg.to_hankaku(p_description_kana, '?'));
1213: p_descriptions(l_index).description_kana := hr_jp_standard_pkg.to_hankaku(p_description_kana, '?');
1214: end add_description;
1215: -- |-------------------------------------------------------------------|
1216: -- |-----------------------< get_descriptions >------------------------|

Line 1213: p_descriptions(l_index).description_kana := hr_jp_standard_pkg.to_hankaku(p_description_kana, '?');

1209: p_descriptions(l_index).description_type := p_description_type;
1210: p_descriptions(l_index).description_kanji := p_description_kanji;
1211: -- p_descriptions(l_index).description_kana := hr_jp_standard_pkg.upper_kana(
1212: -- hr_jp_standard_pkg.to_hankaku(p_description_kana, '?'));
1213: p_descriptions(l_index).description_kana := hr_jp_standard_pkg.to_hankaku(p_description_kana, '?');
1214: end add_description;
1215: -- |-------------------------------------------------------------------|
1216: -- |-----------------------< get_descriptions >------------------------|
1217: -- |-------------------------------------------------------------------|

Line 1379: -- l_description_kanji := l_description_kanji||hr_jp_standard_pkg.to_jp_char(p_housing_tbl(1).residence_date,c_date_fmt_itw);

1375: -- and p_housing_tbl.count <> 0 then
1376: -- --
1377: -- if p_housing_tbl.count = 1 then
1378: -- --
1379: -- l_description_kanji := l_description_kanji||hr_jp_standard_pkg.to_jp_char(p_housing_tbl(1).residence_date,c_date_fmt_itw);
1380: -- l_description_kana := l_description_kana||hr_jp_standard_pkg.to_jp_char(p_housing_tbl(1).residence_date,c_date_fmt_itw);
1381: -- --
1382: -- end if;
1383: -- --

Line 1380: -- l_description_kana := l_description_kana||hr_jp_standard_pkg.to_jp_char(p_housing_tbl(1).residence_date,c_date_fmt_itw);

1376: -- --
1377: -- if p_housing_tbl.count = 1 then
1378: -- --
1379: -- l_description_kanji := l_description_kanji||hr_jp_standard_pkg.to_jp_char(p_housing_tbl(1).residence_date,c_date_fmt_itw);
1380: -- l_description_kana := l_description_kana||hr_jp_standard_pkg.to_jp_char(p_housing_tbl(1).residence_date,c_date_fmt_itw);
1381: -- --
1382: -- end if;
1383: -- --
1384: -- if (p_housing_tbl.count > 1

Line 1398: -- l_description_kanji := l_description_kanji||hr_jp_standard_pkg.to_jp_char(p_housing_tbl(i).residence_date,c_date_fmt_itw);

1394: -- -- this skip in case loan_type = 03
1395: -- --
1396: -- if p_housing_tbl.count <> 1 then
1397: -- --
1398: -- l_description_kanji := l_description_kanji||hr_jp_standard_pkg.to_jp_char(p_housing_tbl(i).residence_date,c_date_fmt_itw);
1399: -- l_description_kana := l_description_kana||hr_jp_standard_pkg.to_jp_char(p_housing_tbl(i).residence_date,c_date_fmt_itw);
1400: -- --
1401: -- end if;
1402: -- --

Line 1399: -- l_description_kana := l_description_kana||hr_jp_standard_pkg.to_jp_char(p_housing_tbl(i).residence_date,c_date_fmt_itw);

1395: -- --
1396: -- if p_housing_tbl.count <> 1 then
1397: -- --
1398: -- l_description_kanji := l_description_kanji||hr_jp_standard_pkg.to_jp_char(p_housing_tbl(i).residence_date,c_date_fmt_itw);
1399: -- l_description_kana := l_description_kana||hr_jp_standard_pkg.to_jp_char(p_housing_tbl(i).residence_date,c_date_fmt_itw);
1400: -- --
1401: -- end if;
1402: -- --
1403: -- else

Line 1405: -- l_description_kanji := l_description_kanji||c_space_separator||g_prompt_kanji.housing_res_date_itw||hr_jp_standard_pkg.to_jp_char(p_housing_tbl(i).residence_date,c_date_fmt_itw);

1401: -- end if;
1402: -- --
1403: -- else
1404: -- --
1405: -- l_description_kanji := l_description_kanji||c_space_separator||g_prompt_kanji.housing_res_date_itw||hr_jp_standard_pkg.to_jp_char(p_housing_tbl(i).residence_date,c_date_fmt_itw);
1406: -- l_description_kana := l_description_kana||c_space_separator||g_prompt_kana.housing_res_date_itw||hr_jp_standard_pkg.to_jp_char(p_housing_tbl(i).residence_date,c_date_fmt_itw);
1407: -- --
1408: -- end if;
1409: -- --

Line 1406: -- l_description_kana := l_description_kana||c_space_separator||g_prompt_kana.housing_res_date_itw||hr_jp_standard_pkg.to_jp_char(p_housing_tbl(i).residence_date,c_date_fmt_itw);

1402: -- --
1403: -- else
1404: -- --
1405: -- l_description_kanji := l_description_kanji||c_space_separator||g_prompt_kanji.housing_res_date_itw||hr_jp_standard_pkg.to_jp_char(p_housing_tbl(i).residence_date,c_date_fmt_itw);
1406: -- l_description_kana := l_description_kana||c_space_separator||g_prompt_kana.housing_res_date_itw||hr_jp_standard_pkg.to_jp_char(p_housing_tbl(i).residence_date,c_date_fmt_itw);
1407: -- --
1408: -- end if;
1409: -- --
1410: -- -- return multiple resident date only in case unclaimed reduciton = 0, type, balance are not required. (ie. payable_loan = total_housing_loan <> 0)

Line 1479: hr_jp_standard_pkg.to_jp_char(p_housing_tbl(i).residence_date,g_prompt_kanji.date_format)||c_space_separator||

1475: l_description_kanji :=
1476: g_prompt_kanji.housing_loan_type_wtm||c_bracket_left||to_char(i)||g_prompt_kanji.housing_count_wtm||c_bracket_right||
1477: p_housing_tbl(i).loan_type||c_space_separator||
1478: g_prompt_kanji.housing_res_date_wtm||c_bracket_left||to_char(i)||g_prompt_kanji.housing_count_wtm||c_bracket_right||
1479: hr_jp_standard_pkg.to_jp_char(p_housing_tbl(i).residence_date,g_prompt_kanji.date_format)||c_space_separator||
1480: g_prompt_kanji.housing_loan_balance_wtm||c_bracket_left||to_char(i)||g_prompt_kanji.housing_count_wtm||c_bracket_right||
1481: to_char(p_housing_tbl(i).loan_balance)||g_prompt_kanji.yen;
1482: l_description_kana :=
1483: g_prompt_kana.housing_loan_type_wtm||c_bracket_left||to_char(i)||g_prompt_kana.housing_count_wtm||c_bracket_right||

Line 1486: hr_jp_standard_pkg.to_jp_char(p_housing_tbl(i).residence_date,g_prompt_kana.date_format)||c_space_separator||

1482: l_description_kana :=
1483: g_prompt_kana.housing_loan_type_wtm||c_bracket_left||to_char(i)||g_prompt_kana.housing_count_wtm||c_bracket_right||
1484: p_housing_tbl(i).loan_type||c_space_separator||
1485: g_prompt_kana.housing_res_date_wtm||c_bracket_left||to_char(i)||g_prompt_kana.housing_count_wtm||c_bracket_right||
1486: hr_jp_standard_pkg.to_jp_char(p_housing_tbl(i).residence_date,g_prompt_kana.date_format)||c_space_separator||
1487: g_prompt_kana.housing_loan_balance_wtm||c_bracket_left||to_char(i)||g_prompt_kana.housing_count_wtm||c_bracket_right||
1488: to_char(p_housing_tbl(i).loan_balance)||g_prompt_kana.yen;
1489: --
1490: add_description(

Line 1541: -- l_description_kanji := l_description_kanji||hr_jp_standard_pkg.to_jp_char(p_certificate_info.housing_residence_date,c_date_fmt_itw);

1537: ----
1538: -- if p_itax_yea_category = '0'
1539: -- and l_total_housing_loan <> 0 then
1540: -- --
1541: -- l_description_kanji := l_description_kanji||hr_jp_standard_pkg.to_jp_char(p_certificate_info.housing_residence_date,c_date_fmt_itw);
1542: -- l_description_kana := l_description_kana||hr_jp_standard_pkg.to_jp_char(p_certificate_info.housing_residence_date,c_date_fmt_itw);
1543: -- --
1544: -- end if;
1545: --

Line 1542: -- l_description_kana := l_description_kana||hr_jp_standard_pkg.to_jp_char(p_certificate_info.housing_residence_date,c_date_fmt_itw);

1538: -- if p_itax_yea_category = '0'
1539: -- and l_total_housing_loan <> 0 then
1540: -- --
1541: -- l_description_kanji := l_description_kanji||hr_jp_standard_pkg.to_jp_char(p_certificate_info.housing_residence_date,c_date_fmt_itw);
1542: -- l_description_kana := l_description_kana||hr_jp_standard_pkg.to_jp_char(p_certificate_info.housing_residence_date,c_date_fmt_itw);
1543: -- --
1544: -- end if;
1545: --
1546: add_description(

Line 1608: l_description_kanji := l_description_kanji||hr_jp_standard_pkg.to_jp_char(p_housing_tbl(1).residence_date,c_date_fmt_itw);

1604: and p_housing_tbl.count <> 0 then
1605: --
1606: if p_housing_tbl.count = 1 then
1607: --
1608: l_description_kanji := l_description_kanji||hr_jp_standard_pkg.to_jp_char(p_housing_tbl(1).residence_date,c_date_fmt_itw);
1609: l_description_kana := l_description_kana||hr_jp_standard_pkg.to_jp_char(p_housing_tbl(1).residence_date,c_date_fmt_itw);
1610: --
1611: end if;
1612: --

Line 1609: l_description_kana := l_description_kana||hr_jp_standard_pkg.to_jp_char(p_housing_tbl(1).residence_date,c_date_fmt_itw);

1605: --
1606: if p_housing_tbl.count = 1 then
1607: --
1608: l_description_kanji := l_description_kanji||hr_jp_standard_pkg.to_jp_char(p_housing_tbl(1).residence_date,c_date_fmt_itw);
1609: l_description_kana := l_description_kana||hr_jp_standard_pkg.to_jp_char(p_housing_tbl(1).residence_date,c_date_fmt_itw);
1610: --
1611: end if;
1612: --
1613: if (p_housing_tbl.count > 1

Line 1627: l_description_kanji := l_description_kanji||hr_jp_standard_pkg.to_jp_char(p_housing_tbl(i).residence_date,c_date_fmt_itw);

1623: -- this skip in case loan_type = 03
1624: --
1625: if p_housing_tbl.count <> 1 then
1626: --
1627: l_description_kanji := l_description_kanji||hr_jp_standard_pkg.to_jp_char(p_housing_tbl(i).residence_date,c_date_fmt_itw);
1628: l_description_kana := l_description_kana||hr_jp_standard_pkg.to_jp_char(p_housing_tbl(i).residence_date,c_date_fmt_itw);
1629: --
1630: end if;
1631: --

Line 1628: l_description_kana := l_description_kana||hr_jp_standard_pkg.to_jp_char(p_housing_tbl(i).residence_date,c_date_fmt_itw);

1624: --
1625: if p_housing_tbl.count <> 1 then
1626: --
1627: l_description_kanji := l_description_kanji||hr_jp_standard_pkg.to_jp_char(p_housing_tbl(i).residence_date,c_date_fmt_itw);
1628: l_description_kana := l_description_kana||hr_jp_standard_pkg.to_jp_char(p_housing_tbl(i).residence_date,c_date_fmt_itw);
1629: --
1630: end if;
1631: --
1632: else

Line 1634: l_description_kanji := l_description_kanji||c_space_separator||g_prompt_kanji.housing_res_date_itw||hr_jp_standard_pkg.to_jp_char(p_housing_tbl(i).residence_date,c_date_fmt_itw);

1630: end if;
1631: --
1632: else
1633: --
1634: l_description_kanji := l_description_kanji||c_space_separator||g_prompt_kanji.housing_res_date_itw||hr_jp_standard_pkg.to_jp_char(p_housing_tbl(i).residence_date,c_date_fmt_itw);
1635: l_description_kana := l_description_kana||c_space_separator||g_prompt_kana.housing_res_date_itw||hr_jp_standard_pkg.to_jp_char(p_housing_tbl(i).residence_date,c_date_fmt_itw);
1636: --
1637: end if;
1638: --

Line 1635: l_description_kana := l_description_kana||c_space_separator||g_prompt_kana.housing_res_date_itw||hr_jp_standard_pkg.to_jp_char(p_housing_tbl(i).residence_date,c_date_fmt_itw);

1631: --
1632: else
1633: --
1634: l_description_kanji := l_description_kanji||c_space_separator||g_prompt_kanji.housing_res_date_itw||hr_jp_standard_pkg.to_jp_char(p_housing_tbl(i).residence_date,c_date_fmt_itw);
1635: l_description_kana := l_description_kana||c_space_separator||g_prompt_kana.housing_res_date_itw||hr_jp_standard_pkg.to_jp_char(p_housing_tbl(i).residence_date,c_date_fmt_itw);
1636: --
1637: end if;
1638: --
1639: -- return multiple resident date only in case unclaimed reduciton = 0, type, balance are not required. (ie. payable_loan = total_housing_loan <> 0)

Line 1737: l_description_kanji := l_description_kanji||hr_jp_standard_pkg.to_jp_char(p_certificate_info.housing_residence_date,c_date_fmt_itw);

1733: --
1734: if p_itax_yea_category = '0'
1735: and l_total_housing_loan <> 0 then
1736: --
1737: l_description_kanji := l_description_kanji||hr_jp_standard_pkg.to_jp_char(p_certificate_info.housing_residence_date,c_date_fmt_itw);
1738: l_description_kana := l_description_kana||hr_jp_standard_pkg.to_jp_char(p_certificate_info.housing_residence_date,c_date_fmt_itw);
1739: --
1740: end if;
1741: --

Line 1738: l_description_kana := l_description_kana||hr_jp_standard_pkg.to_jp_char(p_certificate_info.housing_residence_date,c_date_fmt_itw);

1734: if p_itax_yea_category = '0'
1735: and l_total_housing_loan <> 0 then
1736: --
1737: l_description_kanji := l_description_kanji||hr_jp_standard_pkg.to_jp_char(p_certificate_info.housing_residence_date,c_date_fmt_itw);
1738: l_description_kana := l_description_kana||hr_jp_standard_pkg.to_jp_char(p_certificate_info.housing_residence_date,c_date_fmt_itw);
1739: --
1740: end if;
1741: --
1742: add_description(

Line 1870: l_description_kanji := l_description_kanji||c_space_separator||hr_jp_standard_pkg.to_jp_char(p_prev_jobs(i).termination_date,g_prompt_kanji.date_format)||g_prompt_kanji.terminated;

1866: -- Here uses to_char of ORACLE as a workaround.
1867: --
1868: if p_prev_jobs(i).termination_date is not null then
1869: --
1870: l_description_kanji := l_description_kanji||c_space_separator||hr_jp_standard_pkg.to_jp_char(p_prev_jobs(i).termination_date,g_prompt_kanji.date_format)||g_prompt_kanji.terminated;
1871: l_description_kana := l_description_kana||c_space_separator||hr_jp_standard_pkg.to_jp_char(p_prev_jobs(i).termination_date,g_prompt_kana.date_format)||g_prompt_kana.terminated;
1872: --
1873: end if;
1874: --

Line 1871: l_description_kana := l_description_kana||c_space_separator||hr_jp_standard_pkg.to_jp_char(p_prev_jobs(i).termination_date,g_prompt_kana.date_format)||g_prompt_kana.terminated;

1867: --
1868: if p_prev_jobs(i).termination_date is not null then
1869: --
1870: l_description_kanji := l_description_kanji||c_space_separator||hr_jp_standard_pkg.to_jp_char(p_prev_jobs(i).termination_date,g_prompt_kanji.date_format)||g_prompt_kanji.terminated;
1871: l_description_kana := l_description_kana||c_space_separator||hr_jp_standard_pkg.to_jp_char(p_prev_jobs(i).termination_date,g_prompt_kana.date_format)||g_prompt_kana.terminated;
1872: --
1873: end if;
1874: --
1875: add_description(

Line 2189: hr_jp_standard_pkg.to_jp_char(p_prev_jobs(i).termination_date, g_prompt_kanji.date_format) ||

2185: --
2186: if p_prev_jobs(i).termination_date is not null then
2187: --
2188: l_description_kanji := l_description_kanji || ' ' ||
2189: hr_jp_standard_pkg.to_jp_char(p_prev_jobs(i).termination_date, g_prompt_kanji.date_format) ||
2190: g_prompt_kanji.terminated;
2191: --
2192: l_description_kana := l_description_kana || ' ' ||
2193: hr_jp_standard_pkg.to_jp_char(p_prev_jobs(i).termination_date, g_prompt_kana.date_format) ||

Line 2193: hr_jp_standard_pkg.to_jp_char(p_prev_jobs(i).termination_date, g_prompt_kana.date_format) ||

2189: hr_jp_standard_pkg.to_jp_char(p_prev_jobs(i).termination_date, g_prompt_kanji.date_format) ||
2190: g_prompt_kanji.terminated;
2191: --
2192: l_description_kana := l_description_kana || ' ' ||
2193: hr_jp_standard_pkg.to_jp_char(p_prev_jobs(i).termination_date, g_prompt_kana.date_format) ||
2194: g_prompt_kana.terminated;
2195: --
2196: end if;
2197: --

Line 2234: hr_jp_standard_pkg.to_jp_char(p_certificate_info.housing_residence_date, g_prompt_kanji.date_format);

2230: if p_certificate_info.housing_residence_date is not null then
2231: --
2232: l_description_kanji := l_description_kanji ||
2233: g_prompt_kanji.residence_date ||
2234: hr_jp_standard_pkg.to_jp_char(p_certificate_info.housing_residence_date, g_prompt_kanji.date_format);
2235: --
2236: l_description_kana := l_description_kana ||
2237: g_prompt_kana.residence_date ||
2238: hr_jp_standard_pkg.to_jp_char(p_certificate_info.housing_residence_date, g_prompt_kana.date_format);

Line 2238: hr_jp_standard_pkg.to_jp_char(p_certificate_info.housing_residence_date, g_prompt_kana.date_format);

2234: hr_jp_standard_pkg.to_jp_char(p_certificate_info.housing_residence_date, g_prompt_kanji.date_format);
2235: --
2236: l_description_kana := l_description_kana ||
2237: g_prompt_kana.residence_date ||
2238: hr_jp_standard_pkg.to_jp_char(p_certificate_info.housing_residence_date, g_prompt_kana.date_format);
2239: --
2240: l_separator := ' ';
2241: --
2242: end if;

Line 3170: p_certificate_info.description_kana := hr_jp_standard_pkg.to_hankaku(l_description);

3166: --
3167: hr_utility.set_location(c_proc, 41);
3168: --
3169: p_certificate_info.description_kanji := l_description;
3170: p_certificate_info.description_kana := hr_jp_standard_pkg.to_hankaku(l_description);
3171: --
3172: else
3173: --
3174: hr_utility.set_location(c_proc, 42);

Line 3234: concat_description(hr_jp_standard_pkg.to_hankaku(l_description), p_certificate_info.description_kana, ',');

3230: --
3231: end loop;
3232: --
3233: concat_description(l_description, p_certificate_info.description_kanji, ',');
3234: concat_description(hr_jp_standard_pkg.to_hankaku(l_description), p_certificate_info.description_kana, ',');
3235: --
3236: end if;
3237: --
3238: hr_utility.set_location('Leaving: ' || c_proc, 100);