DBA Data[Home] [Help]

APPS.PAY_JP_WIC_PKG dependencies on STANDARD

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

514: for i in 1..l_prev_jobs_count loop
515: if i = 1 then
516: l_prev_job_info := p_prev_jobs(i);
517: --
518: l_prev_job_info.salary_payer_address_kanji := hr_jp_standard_pkg.to_zenkaku(l_prev_job_info.salary_payer_address_kanji);
519: l_prev_job_info.salary_payer_address_kana := hr_jp_standard_pkg.upper_kana(
520: hr_jp_standard_pkg.to_hankaku(l_prev_job_info.salary_payer_address_kana, '?'));
521: --
522: if l_prev_jobs_count > 1 then

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

515: if i = 1 then
516: l_prev_job_info := p_prev_jobs(i);
517: --
518: l_prev_job_info.salary_payer_address_kanji := hr_jp_standard_pkg.to_zenkaku(l_prev_job_info.salary_payer_address_kanji);
519: l_prev_job_info.salary_payer_address_kana := hr_jp_standard_pkg.upper_kana(
520: hr_jp_standard_pkg.to_hankaku(l_prev_job_info.salary_payer_address_kana, '?'));
521: --
522: if l_prev_jobs_count > 1 then
523: l_prev_job_info.salary_payer_name_kanji := ltrim( l_prev_job_info.salary_payer_name_kanji

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

516: l_prev_job_info := p_prev_jobs(i);
517: --
518: l_prev_job_info.salary_payer_address_kanji := hr_jp_standard_pkg.to_zenkaku(l_prev_job_info.salary_payer_address_kanji);
519: l_prev_job_info.salary_payer_address_kana := hr_jp_standard_pkg.upper_kana(
520: hr_jp_standard_pkg.to_hankaku(l_prev_job_info.salary_payer_address_kana, '?'));
521: --
522: if l_prev_jobs_count > 1 then
523: l_prev_job_info.salary_payer_name_kanji := ltrim( l_prev_job_info.salary_payer_name_kanji
524: || ' '

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

532: || to_char(l_prev_jobs_count - 1)
533: || g_prompt_kana.count);
534: end if;
535: --
536: l_prev_job_info.salary_payer_name_kanji := hr_jp_standard_pkg.to_zenkaku(l_prev_job_info.salary_payer_name_kanji);
537: l_prev_job_info.salary_payer_name_kana := hr_jp_standard_pkg.upper_kana(
538: hr_jp_standard_pkg.to_hankaku(l_prev_job_info.salary_payer_name_kana, '?'));
539: else
540: l_prev_job_info.taxable_income := l_prev_job_info.taxable_income + p_prev_jobs(i).taxable_income;

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

533: || g_prompt_kana.count);
534: end if;
535: --
536: l_prev_job_info.salary_payer_name_kanji := hr_jp_standard_pkg.to_zenkaku(l_prev_job_info.salary_payer_name_kanji);
537: l_prev_job_info.salary_payer_name_kana := hr_jp_standard_pkg.upper_kana(
538: hr_jp_standard_pkg.to_hankaku(l_prev_job_info.salary_payer_name_kana, '?'));
539: else
540: l_prev_job_info.taxable_income := l_prev_job_info.taxable_income + p_prev_jobs(i).taxable_income;
541: -- mutual_aid_prem can be , so remember to use nvl before adding.

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

534: end if;
535: --
536: l_prev_job_info.salary_payer_name_kanji := hr_jp_standard_pkg.to_zenkaku(l_prev_job_info.salary_payer_name_kanji);
537: l_prev_job_info.salary_payer_name_kana := hr_jp_standard_pkg.upper_kana(
538: hr_jp_standard_pkg.to_hankaku(l_prev_job_info.salary_payer_name_kana, '?'));
539: else
540: l_prev_job_info.taxable_income := l_prev_job_info.taxable_income + p_prev_jobs(i).taxable_income;
541: -- mutual_aid_prem can be , so remember to use nvl before adding.
542: if p_prev_jobs(i).mutual_aid_prem <> 0 then

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

715: per.date_of_birth,
716: decode(ctr.contact_type, 'S', decode(p_sex, 'F', g_prompt_kanji.husband, g_prompt_kanji.wife),
717: hr_general.decode_lookup('CONTACT', ctr.contact_type)) D_CONTACT_TYPE_KANJI,
718: decode(ctr.contact_type, 'S', decode(p_sex, 'F', g_prompt_kana.husband, g_prompt_kana.wife),
719: hr_jp_standard_pkg.to_hankaku(hr_general.decode_lookup('JP_CONTACT_KANA', ctr.contact_type))) D_CONTACT_TYPE_KANA
720: from per_contact_relationships ctr,
721: per_all_people_f per
722: where ctr.person_id = p_person_id
723: and ctr.dependent_flag = 'Y'

Line 948: -- hr_jp_standard_pkg.to_zenkaku.

944: l_index := p_descriptions.count + 1;
945: --
946: -- PAYJPITW outputs mixed Kanji/Kana characters
947: -- into description field, so do not use
948: -- hr_jp_standard_pkg.to_zenkaku.
949: -- Use hr_jp_standard_pkg.to_zenkaku just before
950: -- outputting those in reports, e.g. PAYJPWTM.
951: --
952: p_descriptions(l_index).description_type := p_description_type;

Line 949: -- Use hr_jp_standard_pkg.to_zenkaku just before

945: --
946: -- PAYJPITW outputs mixed Kanji/Kana characters
947: -- into description field, so do not use
948: -- hr_jp_standard_pkg.to_zenkaku.
949: -- Use hr_jp_standard_pkg.to_zenkaku just before
950: -- outputting those in reports, e.g. PAYJPWTM.
951: --
952: p_descriptions(l_index).description_type := p_description_type;
953: p_descriptions(l_index).description_kanji := p_description_kanji;

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

950: -- outputting those in reports, e.g. PAYJPWTM.
951: --
952: p_descriptions(l_index).description_type := p_description_type;
953: p_descriptions(l_index).description_kanji := p_description_kanji;
954: -- p_descriptions(l_index).description_kana := hr_jp_standard_pkg.upper_kana(
955: -- hr_jp_standard_pkg.to_hankaku(p_description_kana, '?'));
956: p_descriptions(l_index).description_kana := hr_jp_standard_pkg.to_hankaku(p_description_kana, '?');
957: end add_description;
958: -- |-------------------------------------------------------------------|

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

951: --
952: p_descriptions(l_index).description_type := p_description_type;
953: p_descriptions(l_index).description_kanji := p_description_kanji;
954: -- p_descriptions(l_index).description_kana := hr_jp_standard_pkg.upper_kana(
955: -- hr_jp_standard_pkg.to_hankaku(p_description_kana, '?'));
956: p_descriptions(l_index).description_kana := hr_jp_standard_pkg.to_hankaku(p_description_kana, '?');
957: end add_description;
958: -- |-------------------------------------------------------------------|
959: -- |-----------------------< get_descriptions >------------------------|

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

952: p_descriptions(l_index).description_type := p_description_type;
953: p_descriptions(l_index).description_kanji := p_description_kanji;
954: -- p_descriptions(l_index).description_kana := hr_jp_standard_pkg.upper_kana(
955: -- hr_jp_standard_pkg.to_hankaku(p_description_kana, '?'));
956: p_descriptions(l_index).description_kana := hr_jp_standard_pkg.to_hankaku(p_description_kana, '?');
957: end add_description;
958: -- |-------------------------------------------------------------------|
959: -- |-----------------------< get_descriptions >------------------------|
960: -- |-------------------------------------------------------------------|

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

1213: -- Here uses to_char of ORACLE as a workaround.
1214: --
1215: if p_prev_jobs(i).termination_date is not null then
1216: l_description_kanji := l_description_kanji || ' ' ||
1217: hr_jp_standard_pkg.to_jp_char(p_prev_jobs(i).termination_date, g_prompt_kanji.date_format) ||
1218: g_prompt_kanji.terminated;
1219: l_description_kana := l_description_kana || ' ' ||
1220: hr_jp_standard_pkg.to_jp_char(p_prev_jobs(i).termination_date, g_prompt_kana.date_format) ||
1221: g_prompt_kana.terminated;

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

1216: l_description_kanji := l_description_kanji || ' ' ||
1217: hr_jp_standard_pkg.to_jp_char(p_prev_jobs(i).termination_date, g_prompt_kanji.date_format) ||
1218: g_prompt_kanji.terminated;
1219: l_description_kana := l_description_kana || ' ' ||
1220: hr_jp_standard_pkg.to_jp_char(p_prev_jobs(i).termination_date, g_prompt_kana.date_format) ||
1221: g_prompt_kana.terminated;
1222: end if;
1223: --
1224: add_description(

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

1249: --
1250: if p_certificate_info.housing_residence_date is not null then
1251: l_description_kanji := l_description_kanji ||
1252: g_prompt_kanji.residence_date ||
1253: hr_jp_standard_pkg.to_jp_char(p_certificate_info.housing_residence_date, g_prompt_kanji.date_format);
1254: l_description_kana := l_description_kana ||
1255: g_prompt_kana.residence_date ||
1256: hr_jp_standard_pkg.to_jp_char(p_certificate_info.housing_residence_date, g_prompt_kana.date_format);
1257: l_separator := ' ';

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

1252: g_prompt_kanji.residence_date ||
1253: hr_jp_standard_pkg.to_jp_char(p_certificate_info.housing_residence_date, g_prompt_kanji.date_format);
1254: l_description_kana := l_description_kana ||
1255: g_prompt_kana.residence_date ||
1256: hr_jp_standard_pkg.to_jp_char(p_certificate_info.housing_residence_date, g_prompt_kana.date_format);
1257: l_separator := ' ';
1258: end if;
1259: --
1260: if p_certificate_info.unclaimed_housing_tax_reduct <> 0 then

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

1873: if l_override_flag = 'Y' then
1874: hr_utility.set_location(c_proc, 41);
1875: --
1876: p_certificate_info.description_kanji := l_description;
1877: p_certificate_info.description_kana := hr_jp_standard_pkg.to_hankaku(l_description);
1878: else
1879: hr_utility.set_location(c_proc, 42);
1880: --
1881: get_dpnts(

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

1924: end if;
1925: end loop;
1926: --
1927: concat_description(l_description, p_certificate_info.description_kanji, ',');
1928: concat_description(hr_jp_standard_pkg.to_hankaku(l_description), p_certificate_info.description_kana, ',');
1929: end if;
1930: --
1931: hr_utility.set_location('Leaving: ' || c_proc, 100);
1932: end get_certificate_info;