412: BEGIN
413: if l_text is not NULL then
414: if p_kana_flag = 1 then
415: l_district_name := replace(l_district_name,
416: hr_jp_standard_pkg.sjhextochar('B8DEDD'),
417: hr_jp_standard_pkg.sjhextochar('B8DEDD20'));
418: l_district_name := replace(l_district_name,
419: hr_jp_standard_pkg.sjhextochar('20CFB8DEDD20'),
420: hr_jp_standard_pkg.sjhextochar('CFB8DEDD20'));
413: if l_text is not NULL then
414: if p_kana_flag = 1 then
415: l_district_name := replace(l_district_name,
416: hr_jp_standard_pkg.sjhextochar('B8DEDD'),
417: hr_jp_standard_pkg.sjhextochar('B8DEDD20'));
418: l_district_name := replace(l_district_name,
419: hr_jp_standard_pkg.sjhextochar('20CFB8DEDD20'),
420: hr_jp_standard_pkg.sjhextochar('CFB8DEDD20'));
421: l_district_name := replace(l_district_name,
415: l_district_name := replace(l_district_name,
416: hr_jp_standard_pkg.sjhextochar('B8DEDD'),
417: hr_jp_standard_pkg.sjhextochar('B8DEDD20'));
418: l_district_name := replace(l_district_name,
419: hr_jp_standard_pkg.sjhextochar('20CFB8DEDD20'),
420: hr_jp_standard_pkg.sjhextochar('CFB8DEDD20'));
421: l_district_name := replace(l_district_name,
422: hr_jp_standard_pkg.sjhextochar('20B8DEDD20'),
423: hr_jp_standard_pkg.sjhextochar('20B8DEDD'));
416: hr_jp_standard_pkg.sjhextochar('B8DEDD'),
417: hr_jp_standard_pkg.sjhextochar('B8DEDD20'));
418: l_district_name := replace(l_district_name,
419: hr_jp_standard_pkg.sjhextochar('20CFB8DEDD20'),
420: hr_jp_standard_pkg.sjhextochar('CFB8DEDD20'));
421: l_district_name := replace(l_district_name,
422: hr_jp_standard_pkg.sjhextochar('20B8DEDD20'),
423: hr_jp_standard_pkg.sjhextochar('20B8DEDD'));
424: --SEIREI SHITEI TOSHI 12
418: l_district_name := replace(l_district_name,
419: hr_jp_standard_pkg.sjhextochar('20CFB8DEDD20'),
420: hr_jp_standard_pkg.sjhextochar('CFB8DEDD20'));
421: l_district_name := replace(l_district_name,
422: hr_jp_standard_pkg.sjhextochar('20B8DEDD20'),
423: hr_jp_standard_pkg.sjhextochar('20B8DEDD'));
424: --SEIREI SHITEI TOSHI 12
425: l_district_name := replace(l_district_name,
426: hr_jp_standard_pkg.sjhextochar('C1CADEBC'),
419: hr_jp_standard_pkg.sjhextochar('20CFB8DEDD20'),
420: hr_jp_standard_pkg.sjhextochar('CFB8DEDD20'));
421: l_district_name := replace(l_district_name,
422: hr_jp_standard_pkg.sjhextochar('20B8DEDD20'),
423: hr_jp_standard_pkg.sjhextochar('20B8DEDD'));
424: --SEIREI SHITEI TOSHI 12
425: l_district_name := replace(l_district_name,
426: hr_jp_standard_pkg.sjhextochar('C1CADEBC'),
427: hr_jp_standard_pkg.sjhextochar('C1CADEBC20'));
422: hr_jp_standard_pkg.sjhextochar('20B8DEDD20'),
423: hr_jp_standard_pkg.sjhextochar('20B8DEDD'));
424: --SEIREI SHITEI TOSHI 12
425: l_district_name := replace(l_district_name,
426: hr_jp_standard_pkg.sjhextochar('C1CADEBC'),
427: hr_jp_standard_pkg.sjhextochar('C1CADEBC20'));
428: l_district_name := replace(l_district_name,
429: hr_jp_standard_pkg.sjhextochar('D6BACACFBC'),
430: hr_jp_standard_pkg.sjhextochar('D6BACACFBC20'));
423: hr_jp_standard_pkg.sjhextochar('20B8DEDD'));
424: --SEIREI SHITEI TOSHI 12
425: l_district_name := replace(l_district_name,
426: hr_jp_standard_pkg.sjhextochar('C1CADEBC'),
427: hr_jp_standard_pkg.sjhextochar('C1CADEBC20'));
428: l_district_name := replace(l_district_name,
429: hr_jp_standard_pkg.sjhextochar('D6BACACFBC'),
430: hr_jp_standard_pkg.sjhextochar('D6BACACFBC20'));
431: l_district_name := replace(l_district_name,
425: l_district_name := replace(l_district_name,
426: hr_jp_standard_pkg.sjhextochar('C1CADEBC'),
427: hr_jp_standard_pkg.sjhextochar('C1CADEBC20'));
428: l_district_name := replace(l_district_name,
429: hr_jp_standard_pkg.sjhextochar('D6BACACFBC'),
430: hr_jp_standard_pkg.sjhextochar('D6BACACFBC20'));
431: l_district_name := replace(l_district_name,
432: hr_jp_standard_pkg.sjhextochar('C5BADED4BC'),
433: hr_jp_standard_pkg.sjhextochar('C5BADED4BC20'));
426: hr_jp_standard_pkg.sjhextochar('C1CADEBC'),
427: hr_jp_standard_pkg.sjhextochar('C1CADEBC20'));
428: l_district_name := replace(l_district_name,
429: hr_jp_standard_pkg.sjhextochar('D6BACACFBC'),
430: hr_jp_standard_pkg.sjhextochar('D6BACACFBC20'));
431: l_district_name := replace(l_district_name,
432: hr_jp_standard_pkg.sjhextochar('C5BADED4BC'),
433: hr_jp_standard_pkg.sjhextochar('C5BADED4BC20'));
434: l_district_name := replace(l_district_name,
428: l_district_name := replace(l_district_name,
429: hr_jp_standard_pkg.sjhextochar('D6BACACFBC'),
430: hr_jp_standard_pkg.sjhextochar('D6BACACFBC20'));
431: l_district_name := replace(l_district_name,
432: hr_jp_standard_pkg.sjhextochar('C5BADED4BC'),
433: hr_jp_standard_pkg.sjhextochar('C5BADED4BC20'));
434: l_district_name := replace(l_district_name,
435: hr_jp_standard_pkg.sjhextochar('BBAFCEDFDBBC'),
436: hr_jp_standard_pkg.sjhextochar('BBAFCEDFDBBC20'));
429: hr_jp_standard_pkg.sjhextochar('D6BACACFBC'),
430: hr_jp_standard_pkg.sjhextochar('D6BACACFBC20'));
431: l_district_name := replace(l_district_name,
432: hr_jp_standard_pkg.sjhextochar('C5BADED4BC'),
433: hr_jp_standard_pkg.sjhextochar('C5BADED4BC20'));
434: l_district_name := replace(l_district_name,
435: hr_jp_standard_pkg.sjhextochar('BBAFCEDFDBBC'),
436: hr_jp_standard_pkg.sjhextochar('BBAFCEDFDBBC20'));
437: l_district_name := replace(l_district_name,
431: l_district_name := replace(l_district_name,
432: hr_jp_standard_pkg.sjhextochar('C5BADED4BC'),
433: hr_jp_standard_pkg.sjhextochar('C5BADED4BC20'));
434: l_district_name := replace(l_district_name,
435: hr_jp_standard_pkg.sjhextochar('BBAFCEDFDBBC'),
436: hr_jp_standard_pkg.sjhextochar('BBAFCEDFDBBC20'));
437: l_district_name := replace(l_district_name,
438: hr_jp_standard_pkg.sjhextochar('BEDDC0DEB2BC'),
439: hr_jp_standard_pkg.sjhextochar('BEDDC0DEB2BC20'));
432: hr_jp_standard_pkg.sjhextochar('C5BADED4BC'),
433: hr_jp_standard_pkg.sjhextochar('C5BADED4BC20'));
434: l_district_name := replace(l_district_name,
435: hr_jp_standard_pkg.sjhextochar('BBAFCEDFDBBC'),
436: hr_jp_standard_pkg.sjhextochar('BBAFCEDFDBBC20'));
437: l_district_name := replace(l_district_name,
438: hr_jp_standard_pkg.sjhextochar('BEDDC0DEB2BC'),
439: hr_jp_standard_pkg.sjhextochar('BEDDC0DEB2BC20'));
440: l_district_name := replace(l_district_name,
434: l_district_name := replace(l_district_name,
435: hr_jp_standard_pkg.sjhextochar('BBAFCEDFDBBC'),
436: hr_jp_standard_pkg.sjhextochar('BBAFCEDFDBBC20'));
437: l_district_name := replace(l_district_name,
438: hr_jp_standard_pkg.sjhextochar('BEDDC0DEB2BC'),
439: hr_jp_standard_pkg.sjhextochar('BEDDC0DEB2BC20'));
440: l_district_name := replace(l_district_name,
441: hr_jp_standard_pkg.sjhextochar('BBB2C0CFBC'),
442: hr_jp_standard_pkg.sjhextochar('BBB2C0CFBC20'));
435: hr_jp_standard_pkg.sjhextochar('BBAFCEDFDBBC'),
436: hr_jp_standard_pkg.sjhextochar('BBAFCEDFDBBC20'));
437: l_district_name := replace(l_district_name,
438: hr_jp_standard_pkg.sjhextochar('BEDDC0DEB2BC'),
439: hr_jp_standard_pkg.sjhextochar('BEDDC0DEB2BC20'));
440: l_district_name := replace(l_district_name,
441: hr_jp_standard_pkg.sjhextochar('BBB2C0CFBC'),
442: hr_jp_standard_pkg.sjhextochar('BBB2C0CFBC20'));
443: l_district_name := replace(l_district_name,
437: l_district_name := replace(l_district_name,
438: hr_jp_standard_pkg.sjhextochar('BEDDC0DEB2BC'),
439: hr_jp_standard_pkg.sjhextochar('BEDDC0DEB2BC20'));
440: l_district_name := replace(l_district_name,
441: hr_jp_standard_pkg.sjhextochar('BBB2C0CFBC'),
442: hr_jp_standard_pkg.sjhextochar('BBB2C0CFBC20'));
443: l_district_name := replace(l_district_name,
444: hr_jp_standard_pkg.sjhextochar('BCBDDEB5B6BC'),
445: hr_jp_standard_pkg.sjhextochar('BCBDDEB5B6BC20'));
438: hr_jp_standard_pkg.sjhextochar('BEDDC0DEB2BC'),
439: hr_jp_standard_pkg.sjhextochar('BEDDC0DEB2BC20'));
440: l_district_name := replace(l_district_name,
441: hr_jp_standard_pkg.sjhextochar('BBB2C0CFBC'),
442: hr_jp_standard_pkg.sjhextochar('BBB2C0CFBC20'));
443: l_district_name := replace(l_district_name,
444: hr_jp_standard_pkg.sjhextochar('BCBDDEB5B6BC'),
445: hr_jp_standard_pkg.sjhextochar('BCBDDEB5B6BC20'));
446: l_district_name := replace(l_district_name,
440: l_district_name := replace(l_district_name,
441: hr_jp_standard_pkg.sjhextochar('BBB2C0CFBC'),
442: hr_jp_standard_pkg.sjhextochar('BBB2C0CFBC20'));
443: l_district_name := replace(l_district_name,
444: hr_jp_standard_pkg.sjhextochar('BCBDDEB5B6BC'),
445: hr_jp_standard_pkg.sjhextochar('BCBDDEB5B6BC20'));
446: l_district_name := replace(l_district_name,
447: hr_jp_standard_pkg.sjhextochar('B7AEB3C4BC'),
448: hr_jp_standard_pkg.sjhextochar('B7AEB3C4BC20'));
441: hr_jp_standard_pkg.sjhextochar('BBB2C0CFBC'),
442: hr_jp_standard_pkg.sjhextochar('BBB2C0CFBC20'));
443: l_district_name := replace(l_district_name,
444: hr_jp_standard_pkg.sjhextochar('BCBDDEB5B6BC'),
445: hr_jp_standard_pkg.sjhextochar('BCBDDEB5B6BC20'));
446: l_district_name := replace(l_district_name,
447: hr_jp_standard_pkg.sjhextochar('B7AEB3C4BC'),
448: hr_jp_standard_pkg.sjhextochar('B7AEB3C4BC20'));
449: l_district_name := replace(l_district_name,
443: l_district_name := replace(l_district_name,
444: hr_jp_standard_pkg.sjhextochar('BCBDDEB5B6BC'),
445: hr_jp_standard_pkg.sjhextochar('BCBDDEB5B6BC20'));
446: l_district_name := replace(l_district_name,
447: hr_jp_standard_pkg.sjhextochar('B7AEB3C4BC'),
448: hr_jp_standard_pkg.sjhextochar('B7AEB3C4BC20'));
449: l_district_name := replace(l_district_name,
450: hr_jp_standard_pkg.sjhextochar('B5B5BBB6BC'),
451: hr_jp_standard_pkg.sjhextochar('B5B5BBB6BC20'));
444: hr_jp_standard_pkg.sjhextochar('BCBDDEB5B6BC'),
445: hr_jp_standard_pkg.sjhextochar('BCBDDEB5B6BC20'));
446: l_district_name := replace(l_district_name,
447: hr_jp_standard_pkg.sjhextochar('B7AEB3C4BC'),
448: hr_jp_standard_pkg.sjhextochar('B7AEB3C4BC20'));
449: l_district_name := replace(l_district_name,
450: hr_jp_standard_pkg.sjhextochar('B5B5BBB6BC'),
451: hr_jp_standard_pkg.sjhextochar('B5B5BBB6BC20'));
452: l_district_name := replace(l_district_name,
446: l_district_name := replace(l_district_name,
447: hr_jp_standard_pkg.sjhextochar('B7AEB3C4BC'),
448: hr_jp_standard_pkg.sjhextochar('B7AEB3C4BC20'));
449: l_district_name := replace(l_district_name,
450: hr_jp_standard_pkg.sjhextochar('B5B5BBB6BC'),
451: hr_jp_standard_pkg.sjhextochar('B5B5BBB6BC20'));
452: l_district_name := replace(l_district_name,
453: hr_jp_standard_pkg.sjhextochar('BAB3CDDEBC'),
454: hr_jp_standard_pkg.sjhextochar('BAB3CDDEBC20'));
447: hr_jp_standard_pkg.sjhextochar('B7AEB3C4BC'),
448: hr_jp_standard_pkg.sjhextochar('B7AEB3C4BC20'));
449: l_district_name := replace(l_district_name,
450: hr_jp_standard_pkg.sjhextochar('B5B5BBB6BC'),
451: hr_jp_standard_pkg.sjhextochar('B5B5BBB6BC20'));
452: l_district_name := replace(l_district_name,
453: hr_jp_standard_pkg.sjhextochar('BAB3CDDEBC'),
454: hr_jp_standard_pkg.sjhextochar('BAB3CDDEBC20'));
455: l_district_name := replace(l_district_name,
449: l_district_name := replace(l_district_name,
450: hr_jp_standard_pkg.sjhextochar('B5B5BBB6BC'),
451: hr_jp_standard_pkg.sjhextochar('B5B5BBB6BC20'));
452: l_district_name := replace(l_district_name,
453: hr_jp_standard_pkg.sjhextochar('BAB3CDDEBC'),
454: hr_jp_standard_pkg.sjhextochar('BAB3CDDEBC20'));
455: l_district_name := replace(l_district_name,
456: hr_jp_standard_pkg.sjhextochar('CBDBBCCFBC'),
457: hr_jp_standard_pkg.sjhextochar('CBDBBCCFBC20'));
450: hr_jp_standard_pkg.sjhextochar('B5B5BBB6BC'),
451: hr_jp_standard_pkg.sjhextochar('B5B5BBB6BC20'));
452: l_district_name := replace(l_district_name,
453: hr_jp_standard_pkg.sjhextochar('BAB3CDDEBC'),
454: hr_jp_standard_pkg.sjhextochar('BAB3CDDEBC20'));
455: l_district_name := replace(l_district_name,
456: hr_jp_standard_pkg.sjhextochar('CBDBBCCFBC'),
457: hr_jp_standard_pkg.sjhextochar('CBDBBCCFBC20'));
458: l_district_name := replace(l_district_name,
452: l_district_name := replace(l_district_name,
453: hr_jp_standard_pkg.sjhextochar('BAB3CDDEBC'),
454: hr_jp_standard_pkg.sjhextochar('BAB3CDDEBC20'));
455: l_district_name := replace(l_district_name,
456: hr_jp_standard_pkg.sjhextochar('CBDBBCCFBC'),
457: hr_jp_standard_pkg.sjhextochar('CBDBBCCFBC20'));
458: l_district_name := replace(l_district_name,
459: hr_jp_standard_pkg.sjhextochar('B7C0B7ADB3BCADB3BC'),
460: hr_jp_standard_pkg.sjhextochar('B7C0B7ADB3BCADB3BC20'));
453: hr_jp_standard_pkg.sjhextochar('BAB3CDDEBC'),
454: hr_jp_standard_pkg.sjhextochar('BAB3CDDEBC20'));
455: l_district_name := replace(l_district_name,
456: hr_jp_standard_pkg.sjhextochar('CBDBBCCFBC'),
457: hr_jp_standard_pkg.sjhextochar('CBDBBCCFBC20'));
458: l_district_name := replace(l_district_name,
459: hr_jp_standard_pkg.sjhextochar('B7C0B7ADB3BCADB3BC'),
460: hr_jp_standard_pkg.sjhextochar('B7C0B7ADB3BCADB3BC20'));
461: l_district_name := replace(l_district_name,
455: l_district_name := replace(l_district_name,
456: hr_jp_standard_pkg.sjhextochar('CBDBBCCFBC'),
457: hr_jp_standard_pkg.sjhextochar('CBDBBCCFBC20'));
458: l_district_name := replace(l_district_name,
459: hr_jp_standard_pkg.sjhextochar('B7C0B7ADB3BCADB3BC'),
460: hr_jp_standard_pkg.sjhextochar('B7C0B7ADB3BCADB3BC20'));
461: l_district_name := replace(l_district_name,
462: hr_jp_standard_pkg.sjhextochar('CCB8B5B6BC'),
463: hr_jp_standard_pkg.sjhextochar('CCB8B5B6BC20'));
456: hr_jp_standard_pkg.sjhextochar('CBDBBCCFBC'),
457: hr_jp_standard_pkg.sjhextochar('CBDBBCCFBC20'));
458: l_district_name := replace(l_district_name,
459: hr_jp_standard_pkg.sjhextochar('B7C0B7ADB3BCADB3BC'),
460: hr_jp_standard_pkg.sjhextochar('B7C0B7ADB3BCADB3BC20'));
461: l_district_name := replace(l_district_name,
462: hr_jp_standard_pkg.sjhextochar('CCB8B5B6BC'),
463: hr_jp_standard_pkg.sjhextochar('CCB8B5B6BC20'));
464: l_district_name := replace(l_district_name,
458: l_district_name := replace(l_district_name,
459: hr_jp_standard_pkg.sjhextochar('B7C0B7ADB3BCADB3BC'),
460: hr_jp_standard_pkg.sjhextochar('B7C0B7ADB3BCADB3BC20'));
461: l_district_name := replace(l_district_name,
462: hr_jp_standard_pkg.sjhextochar('CCB8B5B6BC'),
463: hr_jp_standard_pkg.sjhextochar('CCB8B5B6BC20'));
464: l_district_name := replace(l_district_name,
465: hr_jp_standard_pkg.sjhextochar('B5B5BCCFB5B5BCCFCFC1'),
466: hr_jp_standard_pkg.sjhextochar('B5B5BCCF20B5B5BCCFCFC1'));
459: hr_jp_standard_pkg.sjhextochar('B7C0B7ADB3BCADB3BC'),
460: hr_jp_standard_pkg.sjhextochar('B7C0B7ADB3BCADB3BC20'));
461: l_district_name := replace(l_district_name,
462: hr_jp_standard_pkg.sjhextochar('CCB8B5B6BC'),
463: hr_jp_standard_pkg.sjhextochar('CCB8B5B6BC20'));
464: l_district_name := replace(l_district_name,
465: hr_jp_standard_pkg.sjhextochar('B5B5BCCFB5B5BCCFCFC1'),
466: hr_jp_standard_pkg.sjhextochar('B5B5BCCF20B5B5BCCFCFC1'));
467: --
461: l_district_name := replace(l_district_name,
462: hr_jp_standard_pkg.sjhextochar('CCB8B5B6BC'),
463: hr_jp_standard_pkg.sjhextochar('CCB8B5B6BC20'));
464: l_district_name := replace(l_district_name,
465: hr_jp_standard_pkg.sjhextochar('B5B5BCCFB5B5BCCFCFC1'),
466: hr_jp_standard_pkg.sjhextochar('B5B5BCCF20B5B5BCCFCFC1'));
467: --
468: l_district_name := replace(l_district_name,
469: hr_jp_standard_pkg.sjhextochar('C4BCCFC4BCCFD1D7'),
462: hr_jp_standard_pkg.sjhextochar('CCB8B5B6BC'),
463: hr_jp_standard_pkg.sjhextochar('CCB8B5B6BC20'));
464: l_district_name := replace(l_district_name,
465: hr_jp_standard_pkg.sjhextochar('B5B5BCCFB5B5BCCFCFC1'),
466: hr_jp_standard_pkg.sjhextochar('B5B5BCCF20B5B5BCCFCFC1'));
467: --
468: l_district_name := replace(l_district_name,
469: hr_jp_standard_pkg.sjhextochar('C4BCCFC4BCCFD1D7'),
470: hr_jp_standard_pkg.sjhextochar('C4BCCF20C4BCCFD1D7'));
465: hr_jp_standard_pkg.sjhextochar('B5B5BCCFB5B5BCCFCFC1'),
466: hr_jp_standard_pkg.sjhextochar('B5B5BCCF20B5B5BCCFCFC1'));
467: --
468: l_district_name := replace(l_district_name,
469: hr_jp_standard_pkg.sjhextochar('C4BCCFC4BCCFD1D7'),
470: hr_jp_standard_pkg.sjhextochar('C4BCCF20C4BCCFD1D7'));
471: l_district_name := replace(l_district_name,
472: hr_jp_standard_pkg.sjhextochar('C6B2BCDECFC6B2BCDECFD1D7'),
473: hr_jp_standard_pkg.sjhextochar('C6B2BCDECF20C6B2BCDECFD1D7'));
466: hr_jp_standard_pkg.sjhextochar('B5B5BCCF20B5B5BCCFCFC1'));
467: --
468: l_district_name := replace(l_district_name,
469: hr_jp_standard_pkg.sjhextochar('C4BCCFC4BCCFD1D7'),
470: hr_jp_standard_pkg.sjhextochar('C4BCCF20C4BCCFD1D7'));
471: l_district_name := replace(l_district_name,
472: hr_jp_standard_pkg.sjhextochar('C6B2BCDECFC6B2BCDECFD1D7'),
473: hr_jp_standard_pkg.sjhextochar('C6B2BCDECF20C6B2BCDECFD1D7'));
474: l_district_name := replace(l_district_name,
468: l_district_name := replace(l_district_name,
469: hr_jp_standard_pkg.sjhextochar('C4BCCFC4BCCFD1D7'),
470: hr_jp_standard_pkg.sjhextochar('C4BCCF20C4BCCFD1D7'));
471: l_district_name := replace(l_district_name,
472: hr_jp_standard_pkg.sjhextochar('C6B2BCDECFC6B2BCDECFD1D7'),
473: hr_jp_standard_pkg.sjhextochar('C6B2BCDECF20C6B2BCDECFD1D7'));
474: l_district_name := replace(l_district_name,
475: hr_jp_standard_pkg.sjhextochar('BAB3BDDEBCCFBAB3C2DEBCCFD1D7'),
476: hr_jp_standard_pkg.sjhextochar('BAB3BDDEBCCF20BAB3C2DEBCCFD1D7'));
469: hr_jp_standard_pkg.sjhextochar('C4BCCFC4BCCFD1D7'),
470: hr_jp_standard_pkg.sjhextochar('C4BCCF20C4BCCFD1D7'));
471: l_district_name := replace(l_district_name,
472: hr_jp_standard_pkg.sjhextochar('C6B2BCDECFC6B2BCDECFD1D7'),
473: hr_jp_standard_pkg.sjhextochar('C6B2BCDECF20C6B2BCDECFD1D7'));
474: l_district_name := replace(l_district_name,
475: hr_jp_standard_pkg.sjhextochar('BAB3BDDEBCCFBAB3C2DEBCCFD1D7'),
476: hr_jp_standard_pkg.sjhextochar('BAB3BDDEBCCF20BAB3C2DEBCCFD1D7'));
477: l_district_name := replace(l_district_name,
471: l_district_name := replace(l_district_name,
472: hr_jp_standard_pkg.sjhextochar('C6B2BCDECFC6B2BCDECFD1D7'),
473: hr_jp_standard_pkg.sjhextochar('C6B2BCDECF20C6B2BCDECFD1D7'));
474: l_district_name := replace(l_district_name,
475: hr_jp_standard_pkg.sjhextochar('BAB3BDDEBCCFBAB3C2DEBCCFD1D7'),
476: hr_jp_standard_pkg.sjhextochar('BAB3BDDEBCCF20BAB3C2DEBCCFD1D7'));
477: l_district_name := replace(l_district_name,
478: hr_jp_standard_pkg.sjhextochar('D0D4B9BCDECFD0D4B9D1D7'),
479: hr_jp_standard_pkg.sjhextochar('D0D4B9BCDECF20D0D4B9D1D7'));
472: hr_jp_standard_pkg.sjhextochar('C6B2BCDECFC6B2BCDECFD1D7'),
473: hr_jp_standard_pkg.sjhextochar('C6B2BCDECF20C6B2BCDECFD1D7'));
474: l_district_name := replace(l_district_name,
475: hr_jp_standard_pkg.sjhextochar('BAB3BDDEBCCFBAB3C2DEBCCFD1D7'),
476: hr_jp_standard_pkg.sjhextochar('BAB3BDDEBCCF20BAB3C2DEBCCFD1D7'));
477: l_district_name := replace(l_district_name,
478: hr_jp_standard_pkg.sjhextochar('D0D4B9BCDECFD0D4B9D1D7'),
479: hr_jp_standard_pkg.sjhextochar('D0D4B9BCDECF20D0D4B9D1D7'));
480: l_district_name := replace(l_district_name,
474: l_district_name := replace(l_district_name,
475: hr_jp_standard_pkg.sjhextochar('BAB3BDDEBCCFBAB3C2DEBCCFD1D7'),
476: hr_jp_standard_pkg.sjhextochar('BAB3BDDEBCCF20BAB3C2DEBCCFD1D7'));
477: l_district_name := replace(l_district_name,
478: hr_jp_standard_pkg.sjhextochar('D0D4B9BCDECFD0D4B9D1D7'),
479: hr_jp_standard_pkg.sjhextochar('D0D4B9BCDECF20D0D4B9D1D7'));
480: l_district_name := replace(l_district_name,
481: hr_jp_standard_pkg.sjhextochar('D0B8D7BCDECFD0B8D7BCDECFD1D7'),
482: hr_jp_standard_pkg.sjhextochar('D0B8D7BCDECF20D0B8D7BCDECFD1D7'));
475: hr_jp_standard_pkg.sjhextochar('BAB3BDDEBCCFBAB3C2DEBCCFD1D7'),
476: hr_jp_standard_pkg.sjhextochar('BAB3BDDEBCCF20BAB3C2DEBCCFD1D7'));
477: l_district_name := replace(l_district_name,
478: hr_jp_standard_pkg.sjhextochar('D0D4B9BCDECFD0D4B9D1D7'),
479: hr_jp_standard_pkg.sjhextochar('D0D4B9BCDECF20D0D4B9D1D7'));
480: l_district_name := replace(l_district_name,
481: hr_jp_standard_pkg.sjhextochar('D0B8D7BCDECFD0B8D7BCDECFD1D7'),
482: hr_jp_standard_pkg.sjhextochar('D0B8D7BCDECF20D0B8D7BCDECFD1D7'));
483: l_district_name := replace(l_district_name,
477: l_district_name := replace(l_district_name,
478: hr_jp_standard_pkg.sjhextochar('D0D4B9BCDECFD0D4B9D1D7'),
479: hr_jp_standard_pkg.sjhextochar('D0D4B9BCDECF20D0D4B9D1D7'));
480: l_district_name := replace(l_district_name,
481: hr_jp_standard_pkg.sjhextochar('D0B8D7BCDECFD0B8D7BCDECFD1D7'),
482: hr_jp_standard_pkg.sjhextochar('D0B8D7BCDECF20D0B8D7BCDECFD1D7'));
483: l_district_name := replace(l_district_name,
484: hr_jp_standard_pkg.sjhextochar('CAC1BCDED6B3BCDECFCAC1BCDED6B3CFC1'),
485: hr_jp_standard_pkg.sjhextochar('CAC1BCDED6B3BCDECF20CAC1BCDED6B3CFC1'));
478: hr_jp_standard_pkg.sjhextochar('D0D4B9BCDECFD0D4B9D1D7'),
479: hr_jp_standard_pkg.sjhextochar('D0D4B9BCDECF20D0D4B9D1D7'));
480: l_district_name := replace(l_district_name,
481: hr_jp_standard_pkg.sjhextochar('D0B8D7BCDECFD0B8D7BCDECFD1D7'),
482: hr_jp_standard_pkg.sjhextochar('D0B8D7BCDECF20D0B8D7BCDECFD1D7'));
483: l_district_name := replace(l_district_name,
484: hr_jp_standard_pkg.sjhextochar('CAC1BCDED6B3BCDECFCAC1BCDED6B3CFC1'),
485: hr_jp_standard_pkg.sjhextochar('CAC1BCDED6B3BCDECF20CAC1BCDED6B3CFC1'));
486: l_district_name := replace(l_district_name,
480: l_district_name := replace(l_district_name,
481: hr_jp_standard_pkg.sjhextochar('D0B8D7BCDECFD0B8D7BCDECFD1D7'),
482: hr_jp_standard_pkg.sjhextochar('D0B8D7BCDECF20D0B8D7BCDECFD1D7'));
483: l_district_name := replace(l_district_name,
484: hr_jp_standard_pkg.sjhextochar('CAC1BCDED6B3BCDECFCAC1BCDED6B3CFC1'),
485: hr_jp_standard_pkg.sjhextochar('CAC1BCDED6B3BCDECF20CAC1BCDED6B3CFC1'));
486: l_district_name := replace(l_district_name,
487: hr_jp_standard_pkg.sjhextochar('B1B5B6DEBCCFB1B5B6DEBCCFD1D7'),
488: hr_jp_standard_pkg.sjhextochar('B1B5B6DEBCCF20B1B5B6DEBCCFD1D7'));
481: hr_jp_standard_pkg.sjhextochar('D0B8D7BCDECFD0B8D7BCDECFD1D7'),
482: hr_jp_standard_pkg.sjhextochar('D0B8D7BCDECF20D0B8D7BCDECFD1D7'));
483: l_district_name := replace(l_district_name,
484: hr_jp_standard_pkg.sjhextochar('CAC1BCDED6B3BCDECFCAC1BCDED6B3CFC1'),
485: hr_jp_standard_pkg.sjhextochar('CAC1BCDED6B3BCDECF20CAC1BCDED6B3CFC1'));
486: l_district_name := replace(l_district_name,
487: hr_jp_standard_pkg.sjhextochar('B1B5B6DEBCCFB1B5B6DEBCCFD1D7'),
488: hr_jp_standard_pkg.sjhextochar('B1B5B6DEBCCF20B1B5B6DEBCCFD1D7'));
489:
483: l_district_name := replace(l_district_name,
484: hr_jp_standard_pkg.sjhextochar('CAC1BCDED6B3BCDECFCAC1BCDED6B3CFC1'),
485: hr_jp_standard_pkg.sjhextochar('CAC1BCDED6B3BCDECF20CAC1BCDED6B3CFC1'));
486: l_district_name := replace(l_district_name,
487: hr_jp_standard_pkg.sjhextochar('B1B5B6DEBCCFB1B5B6DEBCCFD1D7'),
488: hr_jp_standard_pkg.sjhextochar('B1B5B6DEBCCF20B1B5B6DEBCCFD1D7'));
489:
490: l_district_name := replace(l_district_name,
491: hr_jp_standard_pkg.sjhextochar('B5B6DEBBDCD7BCAEC4B3B5B6DEBBDCD7D1D7'),
484: hr_jp_standard_pkg.sjhextochar('CAC1BCDED6B3BCDECFCAC1BCDED6B3CFC1'),
485: hr_jp_standard_pkg.sjhextochar('CAC1BCDED6B3BCDECF20CAC1BCDED6B3CFC1'));
486: l_district_name := replace(l_district_name,
487: hr_jp_standard_pkg.sjhextochar('B1B5B6DEBCCFB1B5B6DEBCCFD1D7'),
488: hr_jp_standard_pkg.sjhextochar('B1B5B6DEBCCF20B1B5B6DEBCCFD1D7'));
489:
490: l_district_name := replace(l_district_name,
491: hr_jp_standard_pkg.sjhextochar('B5B6DEBBDCD7BCAEC4B3B5B6DEBBDCD7D1D7'),
492: hr_jp_standard_pkg.sjhextochar('B5B6DEBBDCD7BCAEC4B320B5B6DEBBDCD7D1D7'));
487: hr_jp_standard_pkg.sjhextochar('B1B5B6DEBCCFB1B5B6DEBCCFD1D7'),
488: hr_jp_standard_pkg.sjhextochar('B1B5B6DEBCCF20B1B5B6DEBCCFD1D7'));
489:
490: l_district_name := replace(l_district_name,
491: hr_jp_standard_pkg.sjhextochar('B5B6DEBBDCD7BCAEC4B3B5B6DEBBDCD7D1D7'),
492: hr_jp_standard_pkg.sjhextochar('B5B6DEBBDCD7BCAEC4B320B5B6DEBBDCD7D1D7'));
493: l_text := l_prefecture_name||' '||l_district_name;
494: else
495: l_text := replace(l_text,
488: hr_jp_standard_pkg.sjhextochar('B1B5B6DEBCCF20B1B5B6DEBCCFD1D7'));
489:
490: l_district_name := replace(l_district_name,
491: hr_jp_standard_pkg.sjhextochar('B5B6DEBBDCD7BCAEC4B3B5B6DEBBDCD7D1D7'),
492: hr_jp_standard_pkg.sjhextochar('B5B6DEBBDCD7BCAEC4B320B5B6DEBBDCD7D1D7'));
493: l_text := l_prefecture_name||' '||l_district_name;
494: else
495: l_text := replace(l_text,
496: hr_jp_standard_pkg.sjhextochar('8C53'),
492: hr_jp_standard_pkg.sjhextochar('B5B6DEBBDCD7BCAEC4B320B5B6DEBBDCD7D1D7'));
493: l_text := l_prefecture_name||' '||l_district_name;
494: else
495: l_text := replace(l_text,
496: hr_jp_standard_pkg.sjhextochar('8C53'),
497: hr_jp_standard_pkg.sjhextochar('8C538140'));
498: l_text := replace(l_text,
499: hr_jp_standard_pkg.sjhextochar('8E73'),
500: hr_jp_standard_pkg.sjhextochar('8E738140'));
493: l_text := l_prefecture_name||' '||l_district_name;
494: else
495: l_text := replace(l_text,
496: hr_jp_standard_pkg.sjhextochar('8C53'),
497: hr_jp_standard_pkg.sjhextochar('8C538140'));
498: l_text := replace(l_text,
499: hr_jp_standard_pkg.sjhextochar('8E73'),
500: hr_jp_standard_pkg.sjhextochar('8E738140'));
501: l_text := replace(l_text,
495: l_text := replace(l_text,
496: hr_jp_standard_pkg.sjhextochar('8C53'),
497: hr_jp_standard_pkg.sjhextochar('8C538140'));
498: l_text := replace(l_text,
499: hr_jp_standard_pkg.sjhextochar('8E73'),
500: hr_jp_standard_pkg.sjhextochar('8E738140'));
501: l_text := replace(l_text,
502: hr_jp_standard_pkg.sjhextochar('8CA7'),
503: hr_jp_standard_pkg.sjhextochar('8CA78140'));
496: hr_jp_standard_pkg.sjhextochar('8C53'),
497: hr_jp_standard_pkg.sjhextochar('8C538140'));
498: l_text := replace(l_text,
499: hr_jp_standard_pkg.sjhextochar('8E73'),
500: hr_jp_standard_pkg.sjhextochar('8E738140'));
501: l_text := replace(l_text,
502: hr_jp_standard_pkg.sjhextochar('8CA7'),
503: hr_jp_standard_pkg.sjhextochar('8CA78140'));
504: --
498: l_text := replace(l_text,
499: hr_jp_standard_pkg.sjhextochar('8E73'),
500: hr_jp_standard_pkg.sjhextochar('8E738140'));
501: l_text := replace(l_text,
502: hr_jp_standard_pkg.sjhextochar('8CA7'),
503: hr_jp_standard_pkg.sjhextochar('8CA78140'));
504: --
505: l_text := replace(l_text,
506: hr_jp_standard_pkg.sjhextochar('966B8A4393B9'),
499: hr_jp_standard_pkg.sjhextochar('8E73'),
500: hr_jp_standard_pkg.sjhextochar('8E738140'));
501: l_text := replace(l_text,
502: hr_jp_standard_pkg.sjhextochar('8CA7'),
503: hr_jp_standard_pkg.sjhextochar('8CA78140'));
504: --
505: l_text := replace(l_text,
506: hr_jp_standard_pkg.sjhextochar('966B8A4393B9'),
507: hr_jp_standard_pkg.sjhextochar('966B8A4393B98140'));
502: hr_jp_standard_pkg.sjhextochar('8CA7'),
503: hr_jp_standard_pkg.sjhextochar('8CA78140'));
504: --
505: l_text := replace(l_text,
506: hr_jp_standard_pkg.sjhextochar('966B8A4393B9'),
507: hr_jp_standard_pkg.sjhextochar('966B8A4393B98140'));
508: l_text := replace(l_text,
509: hr_jp_standard_pkg.sjhextochar('938C8B9E9373'),
510: hr_jp_standard_pkg.sjhextochar('938C8B9E93738140'));
503: hr_jp_standard_pkg.sjhextochar('8CA78140'));
504: --
505: l_text := replace(l_text,
506: hr_jp_standard_pkg.sjhextochar('966B8A4393B9'),
507: hr_jp_standard_pkg.sjhextochar('966B8A4393B98140'));
508: l_text := replace(l_text,
509: hr_jp_standard_pkg.sjhextochar('938C8B9E9373'),
510: hr_jp_standard_pkg.sjhextochar('938C8B9E93738140'));
511: l_text := replace(l_text,
505: l_text := replace(l_text,
506: hr_jp_standard_pkg.sjhextochar('966B8A4393B9'),
507: hr_jp_standard_pkg.sjhextochar('966B8A4393B98140'));
508: l_text := replace(l_text,
509: hr_jp_standard_pkg.sjhextochar('938C8B9E9373'),
510: hr_jp_standard_pkg.sjhextochar('938C8B9E93738140'));
511: l_text := replace(l_text,
512: hr_jp_standard_pkg.sjhextochar('8B9E9373957B'),
513: hr_jp_standard_pkg.sjhextochar('8B9E9373957B8140'));
506: hr_jp_standard_pkg.sjhextochar('966B8A4393B9'),
507: hr_jp_standard_pkg.sjhextochar('966B8A4393B98140'));
508: l_text := replace(l_text,
509: hr_jp_standard_pkg.sjhextochar('938C8B9E9373'),
510: hr_jp_standard_pkg.sjhextochar('938C8B9E93738140'));
511: l_text := replace(l_text,
512: hr_jp_standard_pkg.sjhextochar('8B9E9373957B'),
513: hr_jp_standard_pkg.sjhextochar('8B9E9373957B8140'));
514: l_text := replace(l_text,
508: l_text := replace(l_text,
509: hr_jp_standard_pkg.sjhextochar('938C8B9E9373'),
510: hr_jp_standard_pkg.sjhextochar('938C8B9E93738140'));
511: l_text := replace(l_text,
512: hr_jp_standard_pkg.sjhextochar('8B9E9373957B'),
513: hr_jp_standard_pkg.sjhextochar('8B9E9373957B8140'));
514: l_text := replace(l_text,
515: hr_jp_standard_pkg.sjhextochar('91E58DE3957B'),
516: hr_jp_standard_pkg.sjhextochar('91E58DE3957B8140'));
509: hr_jp_standard_pkg.sjhextochar('938C8B9E9373'),
510: hr_jp_standard_pkg.sjhextochar('938C8B9E93738140'));
511: l_text := replace(l_text,
512: hr_jp_standard_pkg.sjhextochar('8B9E9373957B'),
513: hr_jp_standard_pkg.sjhextochar('8B9E9373957B8140'));
514: l_text := replace(l_text,
515: hr_jp_standard_pkg.sjhextochar('91E58DE3957B'),
516: hr_jp_standard_pkg.sjhextochar('91E58DE3957B8140'));
517: --
511: l_text := replace(l_text,
512: hr_jp_standard_pkg.sjhextochar('8B9E9373957B'),
513: hr_jp_standard_pkg.sjhextochar('8B9E9373957B8140'));
514: l_text := replace(l_text,
515: hr_jp_standard_pkg.sjhextochar('91E58DE3957B'),
516: hr_jp_standard_pkg.sjhextochar('91E58DE3957B8140'));
517: --
518: l_text := replace(l_text,
519: hr_jp_standard_pkg.sjhextochar('8C5381408C538140'),
512: hr_jp_standard_pkg.sjhextochar('8B9E9373957B'),
513: hr_jp_standard_pkg.sjhextochar('8B9E9373957B8140'));
514: l_text := replace(l_text,
515: hr_jp_standard_pkg.sjhextochar('91E58DE3957B'),
516: hr_jp_standard_pkg.sjhextochar('91E58DE3957B8140'));
517: --
518: l_text := replace(l_text,
519: hr_jp_standard_pkg.sjhextochar('8C5381408C538140'),
520: hr_jp_standard_pkg.sjhextochar('8C5381408C53'));
515: hr_jp_standard_pkg.sjhextochar('91E58DE3957B'),
516: hr_jp_standard_pkg.sjhextochar('91E58DE3957B8140'));
517: --
518: l_text := replace(l_text,
519: hr_jp_standard_pkg.sjhextochar('8C5381408C538140'),
520: hr_jp_standard_pkg.sjhextochar('8C5381408C53'));
521: l_text := replace(l_text,
522: hr_jp_standard_pkg.sjhextochar('8C5381408E738140'),
523: hr_jp_standard_pkg.sjhextochar('8C5381408E73'));
516: hr_jp_standard_pkg.sjhextochar('91E58DE3957B8140'));
517: --
518: l_text := replace(l_text,
519: hr_jp_standard_pkg.sjhextochar('8C5381408C538140'),
520: hr_jp_standard_pkg.sjhextochar('8C5381408C53'));
521: l_text := replace(l_text,
522: hr_jp_standard_pkg.sjhextochar('8C5381408E738140'),
523: hr_jp_standard_pkg.sjhextochar('8C5381408E73'));
524:
518: l_text := replace(l_text,
519: hr_jp_standard_pkg.sjhextochar('8C5381408C538140'),
520: hr_jp_standard_pkg.sjhextochar('8C5381408C53'));
521: l_text := replace(l_text,
522: hr_jp_standard_pkg.sjhextochar('8C5381408E738140'),
523: hr_jp_standard_pkg.sjhextochar('8C5381408E73'));
524:
525: --case of GIFU or FUKUSIMA
526: if substrb(l_text,1,6) = hr_jp_standard_pkg.sjhextochar('8AF2958C8CA7')
519: hr_jp_standard_pkg.sjhextochar('8C5381408C538140'),
520: hr_jp_standard_pkg.sjhextochar('8C5381408C53'));
521: l_text := replace(l_text,
522: hr_jp_standard_pkg.sjhextochar('8C5381408E738140'),
523: hr_jp_standard_pkg.sjhextochar('8C5381408E73'));
524:
525: --case of GIFU or FUKUSIMA
526: if substrb(l_text,1,6) = hr_jp_standard_pkg.sjhextochar('8AF2958C8CA7')
527: or substrb(l_text,1,6) = hr_jp_standard_pkg.sjhextochar('959F93878CA7') then
522: hr_jp_standard_pkg.sjhextochar('8C5381408E738140'),
523: hr_jp_standard_pkg.sjhextochar('8C5381408E73'));
524:
525: --case of GIFU or FUKUSIMA
526: if substrb(l_text,1,6) = hr_jp_standard_pkg.sjhextochar('8AF2958C8CA7')
527: or substrb(l_text,1,6) = hr_jp_standard_pkg.sjhextochar('959F93878CA7') then
528: l_text := replace(l_text,
529: hr_jp_standard_pkg.sjhextochar('8CA781408C538140'),
530: hr_jp_standard_pkg.sjhextochar('8CA781408C53'));
523: hr_jp_standard_pkg.sjhextochar('8C5381408E73'));
524:
525: --case of GIFU or FUKUSIMA
526: if substrb(l_text,1,6) = hr_jp_standard_pkg.sjhextochar('8AF2958C8CA7')
527: or substrb(l_text,1,6) = hr_jp_standard_pkg.sjhextochar('959F93878CA7') then
528: l_text := replace(l_text,
529: hr_jp_standard_pkg.sjhextochar('8CA781408C538140'),
530: hr_jp_standard_pkg.sjhextochar('8CA781408C53'));
531: else
525: --case of GIFU or FUKUSIMA
526: if substrb(l_text,1,6) = hr_jp_standard_pkg.sjhextochar('8AF2958C8CA7')
527: or substrb(l_text,1,6) = hr_jp_standard_pkg.sjhextochar('959F93878CA7') then
528: l_text := replace(l_text,
529: hr_jp_standard_pkg.sjhextochar('8CA781408C538140'),
530: hr_jp_standard_pkg.sjhextochar('8CA781408C53'));
531: else
532: l_text := replace(l_text,
533: hr_jp_standard_pkg.sjhextochar('8CA781408C538140'),
526: if substrb(l_text,1,6) = hr_jp_standard_pkg.sjhextochar('8AF2958C8CA7')
527: or substrb(l_text,1,6) = hr_jp_standard_pkg.sjhextochar('959F93878CA7') then
528: l_text := replace(l_text,
529: hr_jp_standard_pkg.sjhextochar('8CA781408C538140'),
530: hr_jp_standard_pkg.sjhextochar('8CA781408C53'));
531: else
532: l_text := replace(l_text,
533: hr_jp_standard_pkg.sjhextochar('8CA781408C538140'),
534: hr_jp_standard_pkg.sjhextochar('8CA78C538140'));
529: hr_jp_standard_pkg.sjhextochar('8CA781408C538140'),
530: hr_jp_standard_pkg.sjhextochar('8CA781408C53'));
531: else
532: l_text := replace(l_text,
533: hr_jp_standard_pkg.sjhextochar('8CA781408C538140'),
534: hr_jp_standard_pkg.sjhextochar('8CA78C538140'));
535: end if;
536: l_text := replace(l_text,
537: hr_jp_standard_pkg.sjhextochar('8CA781408E738140'),
530: hr_jp_standard_pkg.sjhextochar('8CA781408C53'));
531: else
532: l_text := replace(l_text,
533: hr_jp_standard_pkg.sjhextochar('8CA781408C538140'),
534: hr_jp_standard_pkg.sjhextochar('8CA78C538140'));
535: end if;
536: l_text := replace(l_text,
537: hr_jp_standard_pkg.sjhextochar('8CA781408E738140'),
538: hr_jp_standard_pkg.sjhextochar('8CA781408E73'));
533: hr_jp_standard_pkg.sjhextochar('8CA781408C538140'),
534: hr_jp_standard_pkg.sjhextochar('8CA78C538140'));
535: end if;
536: l_text := replace(l_text,
537: hr_jp_standard_pkg.sjhextochar('8CA781408E738140'),
538: hr_jp_standard_pkg.sjhextochar('8CA781408E73'));
539: l_text := replace(l_text,
540: hr_jp_standard_pkg.sjhextochar('8E7381408C538140'),
541: hr_jp_standard_pkg.sjhextochar('8E738C538140'));
534: hr_jp_standard_pkg.sjhextochar('8CA78C538140'));
535: end if;
536: l_text := replace(l_text,
537: hr_jp_standard_pkg.sjhextochar('8CA781408E738140'),
538: hr_jp_standard_pkg.sjhextochar('8CA781408E73'));
539: l_text := replace(l_text,
540: hr_jp_standard_pkg.sjhextochar('8E7381408C538140'),
541: hr_jp_standard_pkg.sjhextochar('8E738C538140'));
542: l_text := replace(l_text,
536: l_text := replace(l_text,
537: hr_jp_standard_pkg.sjhextochar('8CA781408E738140'),
538: hr_jp_standard_pkg.sjhextochar('8CA781408E73'));
539: l_text := replace(l_text,
540: hr_jp_standard_pkg.sjhextochar('8E7381408C538140'),
541: hr_jp_standard_pkg.sjhextochar('8E738C538140'));
542: l_text := replace(l_text,
543: hr_jp_standard_pkg.sjhextochar('94AA93FA8E7381408FEA8E73'),
544: hr_jp_standard_pkg.sjhextochar('94AA93FA8E738FEA8E73'));
537: hr_jp_standard_pkg.sjhextochar('8CA781408E738140'),
538: hr_jp_standard_pkg.sjhextochar('8CA781408E73'));
539: l_text := replace(l_text,
540: hr_jp_standard_pkg.sjhextochar('8E7381408C538140'),
541: hr_jp_standard_pkg.sjhextochar('8E738C538140'));
542: l_text := replace(l_text,
543: hr_jp_standard_pkg.sjhextochar('94AA93FA8E7381408FEA8E73'),
544: hr_jp_standard_pkg.sjhextochar('94AA93FA8E738FEA8E73'));
545: l_text := replace(l_text,
539: l_text := replace(l_text,
540: hr_jp_standard_pkg.sjhextochar('8E7381408C538140'),
541: hr_jp_standard_pkg.sjhextochar('8E738C538140'));
542: l_text := replace(l_text,
543: hr_jp_standard_pkg.sjhextochar('94AA93FA8E7381408FEA8E73'),
544: hr_jp_standard_pkg.sjhextochar('94AA93FA8E738FEA8E73'));
545: l_text := replace(l_text,
546: hr_jp_standard_pkg.sjhextochar('91E598618C5381408E528E73'),
547: hr_jp_standard_pkg.sjhextochar('91E598618C538E528E73'));
540: hr_jp_standard_pkg.sjhextochar('8E7381408C538140'),
541: hr_jp_standard_pkg.sjhextochar('8E738C538140'));
542: l_text := replace(l_text,
543: hr_jp_standard_pkg.sjhextochar('94AA93FA8E7381408FEA8E73'),
544: hr_jp_standard_pkg.sjhextochar('94AA93FA8E738FEA8E73'));
545: l_text := replace(l_text,
546: hr_jp_standard_pkg.sjhextochar('91E598618C5381408E528E73'),
547: hr_jp_standard_pkg.sjhextochar('91E598618C538E528E73'));
548: l_text := replace(l_text,
542: l_text := replace(l_text,
543: hr_jp_standard_pkg.sjhextochar('94AA93FA8E7381408FEA8E73'),
544: hr_jp_standard_pkg.sjhextochar('94AA93FA8E738FEA8E73'));
545: l_text := replace(l_text,
546: hr_jp_standard_pkg.sjhextochar('91E598618C5381408E528E73'),
547: hr_jp_standard_pkg.sjhextochar('91E598618C538E528E73'));
548: l_text := replace(l_text,
549: hr_jp_standard_pkg.sjhextochar('938C8E738140978892AC'),
550: hr_jp_standard_pkg.sjhextochar('938C8E73978892AC'));
543: hr_jp_standard_pkg.sjhextochar('94AA93FA8E7381408FEA8E73'),
544: hr_jp_standard_pkg.sjhextochar('94AA93FA8E738FEA8E73'));
545: l_text := replace(l_text,
546: hr_jp_standard_pkg.sjhextochar('91E598618C5381408E528E73'),
547: hr_jp_standard_pkg.sjhextochar('91E598618C538E528E73'));
548: l_text := replace(l_text,
549: hr_jp_standard_pkg.sjhextochar('938C8E738140978892AC'),
550: hr_jp_standard_pkg.sjhextochar('938C8E73978892AC'));
551: --
545: l_text := replace(l_text,
546: hr_jp_standard_pkg.sjhextochar('91E598618C5381408E528E73'),
547: hr_jp_standard_pkg.sjhextochar('91E598618C538E528E73'));
548: l_text := replace(l_text,
549: hr_jp_standard_pkg.sjhextochar('938C8E738140978892AC'),
550: hr_jp_standard_pkg.sjhextochar('938C8E73978892AC'));
551: --
552: l_text := replace(l_text,
553: hr_jp_standard_pkg.sjhextochar('91E5938791E5938792AC'),
546: hr_jp_standard_pkg.sjhextochar('91E598618C5381408E528E73'),
547: hr_jp_standard_pkg.sjhextochar('91E598618C538E528E73'));
548: l_text := replace(l_text,
549: hr_jp_standard_pkg.sjhextochar('938C8E738140978892AC'),
550: hr_jp_standard_pkg.sjhextochar('938C8E73978892AC'));
551: --
552: l_text := replace(l_text,
553: hr_jp_standard_pkg.sjhextochar('91E5938791E5938792AC'),
554: hr_jp_standard_pkg.sjhextochar('91E59387814091E5938792AC'));
549: hr_jp_standard_pkg.sjhextochar('938C8E738140978892AC'),
550: hr_jp_standard_pkg.sjhextochar('938C8E73978892AC'));
551: --
552: l_text := replace(l_text,
553: hr_jp_standard_pkg.sjhextochar('91E5938791E5938792AC'),
554: hr_jp_standard_pkg.sjhextochar('91E59387814091E5938792AC'));
555: l_text := replace(l_text,
556: hr_jp_standard_pkg.sjhextochar('979893879798938791BA'),
557: hr_jp_standard_pkg.sjhextochar('9798938781409798938791BA'));
550: hr_jp_standard_pkg.sjhextochar('938C8E73978892AC'));
551: --
552: l_text := replace(l_text,
553: hr_jp_standard_pkg.sjhextochar('91E5938791E5938792AC'),
554: hr_jp_standard_pkg.sjhextochar('91E59387814091E5938792AC'));
555: l_text := replace(l_text,
556: hr_jp_standard_pkg.sjhextochar('979893879798938791BA'),
557: hr_jp_standard_pkg.sjhextochar('9798938781409798938791BA'));
558: l_text := replace(l_text,
552: l_text := replace(l_text,
553: hr_jp_standard_pkg.sjhextochar('91E5938791E5938792AC'),
554: hr_jp_standard_pkg.sjhextochar('91E59387814091E5938792AC'));
555: l_text := replace(l_text,
556: hr_jp_standard_pkg.sjhextochar('979893879798938791BA'),
557: hr_jp_standard_pkg.sjhextochar('9798938781409798938791BA'));
558: l_text := replace(l_text,
559: hr_jp_standard_pkg.sjhextochar('905693879056938791BA'),
560: hr_jp_standard_pkg.sjhextochar('9056938781409056938791BA'));
553: hr_jp_standard_pkg.sjhextochar('91E5938791E5938792AC'),
554: hr_jp_standard_pkg.sjhextochar('91E59387814091E5938792AC'));
555: l_text := replace(l_text,
556: hr_jp_standard_pkg.sjhextochar('979893879798938791BA'),
557: hr_jp_standard_pkg.sjhextochar('9798938781409798938791BA'));
558: l_text := replace(l_text,
559: hr_jp_standard_pkg.sjhextochar('905693879056938791BA'),
560: hr_jp_standard_pkg.sjhextochar('9056938781409056938791BA'));
561: l_text := replace(l_text,
555: l_text := replace(l_text,
556: hr_jp_standard_pkg.sjhextochar('979893879798938791BA'),
557: hr_jp_standard_pkg.sjhextochar('9798938781409798938791BA'));
558: l_text := replace(l_text,
559: hr_jp_standard_pkg.sjhextochar('905693879056938791BA'),
560: hr_jp_standard_pkg.sjhextochar('9056938781409056938791BA'));
561: l_text := replace(l_text,
562: hr_jp_standard_pkg.sjhextochar('905F92C39387905F92C3938791BA'),
563: hr_jp_standard_pkg.sjhextochar('905F92C393878140905F92C3938791BA'));
556: hr_jp_standard_pkg.sjhextochar('979893879798938791BA'),
557: hr_jp_standard_pkg.sjhextochar('9798938781409798938791BA'));
558: l_text := replace(l_text,
559: hr_jp_standard_pkg.sjhextochar('905693879056938791BA'),
560: hr_jp_standard_pkg.sjhextochar('9056938781409056938791BA'));
561: l_text := replace(l_text,
562: hr_jp_standard_pkg.sjhextochar('905F92C39387905F92C3938791BA'),
563: hr_jp_standard_pkg.sjhextochar('905F92C393878140905F92C3938791BA'));
564: l_text := replace(l_text,
558: l_text := replace(l_text,
559: hr_jp_standard_pkg.sjhextochar('905693879056938791BA'),
560: hr_jp_standard_pkg.sjhextochar('9056938781409056938791BA'));
561: l_text := replace(l_text,
562: hr_jp_standard_pkg.sjhextochar('905F92C39387905F92C3938791BA'),
563: hr_jp_standard_pkg.sjhextochar('905F92C393878140905F92C3938791BA'));
564: l_text := replace(l_text,
565: hr_jp_standard_pkg.sjhextochar('8E4F91EE93878E4F91EE91BA'),
566: hr_jp_standard_pkg.sjhextochar('8E4F91EE938781408E4F91EE91BA'));
559: hr_jp_standard_pkg.sjhextochar('905693879056938791BA'),
560: hr_jp_standard_pkg.sjhextochar('9056938781409056938791BA'));
561: l_text := replace(l_text,
562: hr_jp_standard_pkg.sjhextochar('905F92C39387905F92C3938791BA'),
563: hr_jp_standard_pkg.sjhextochar('905F92C393878140905F92C3938791BA'));
564: l_text := replace(l_text,
565: hr_jp_standard_pkg.sjhextochar('8E4F91EE93878E4F91EE91BA'),
566: hr_jp_standard_pkg.sjhextochar('8E4F91EE938781408E4F91EE91BA'));
567: l_text := replace(l_text,
561: l_text := replace(l_text,
562: hr_jp_standard_pkg.sjhextochar('905F92C39387905F92C3938791BA'),
563: hr_jp_standard_pkg.sjhextochar('905F92C393878140905F92C3938791BA'));
564: l_text := replace(l_text,
565: hr_jp_standard_pkg.sjhextochar('8E4F91EE93878E4F91EE91BA'),
566: hr_jp_standard_pkg.sjhextochar('8E4F91EE938781408E4F91EE91BA'));
567: l_text := replace(l_text,
568: hr_jp_standard_pkg.sjhextochar('8CE491A093878CE491A0938791BA'),
569: hr_jp_standard_pkg.sjhextochar('8CE491A0938781408CE491A0938791BA'));
562: hr_jp_standard_pkg.sjhextochar('905F92C39387905F92C3938791BA'),
563: hr_jp_standard_pkg.sjhextochar('905F92C393878140905F92C3938791BA'));
564: l_text := replace(l_text,
565: hr_jp_standard_pkg.sjhextochar('8E4F91EE93878E4F91EE91BA'),
566: hr_jp_standard_pkg.sjhextochar('8E4F91EE938781408E4F91EE91BA'));
567: l_text := replace(l_text,
568: hr_jp_standard_pkg.sjhextochar('8CE491A093878CE491A0938791BA'),
569: hr_jp_standard_pkg.sjhextochar('8CE491A0938781408CE491A0938791BA'));
570: l_text := replace(l_text,
564: l_text := replace(l_text,
565: hr_jp_standard_pkg.sjhextochar('8E4F91EE93878E4F91EE91BA'),
566: hr_jp_standard_pkg.sjhextochar('8E4F91EE938781408E4F91EE91BA'));
567: l_text := replace(l_text,
568: hr_jp_standard_pkg.sjhextochar('8CE491A093878CE491A0938791BA'),
569: hr_jp_standard_pkg.sjhextochar('8CE491A0938781408CE491A0938791BA'));
570: l_text := replace(l_text,
571: hr_jp_standard_pkg.sjhextochar('94AA8FE4938794AA8FE492AC'),
572: hr_jp_standard_pkg.sjhextochar('94AA8FE49387814094AA8FE492AC'));
565: hr_jp_standard_pkg.sjhextochar('8E4F91EE93878E4F91EE91BA'),
566: hr_jp_standard_pkg.sjhextochar('8E4F91EE938781408E4F91EE91BA'));
567: l_text := replace(l_text,
568: hr_jp_standard_pkg.sjhextochar('8CE491A093878CE491A0938791BA'),
569: hr_jp_standard_pkg.sjhextochar('8CE491A0938781408CE491A0938791BA'));
570: l_text := replace(l_text,
571: hr_jp_standard_pkg.sjhextochar('94AA8FE4938794AA8FE492AC'),
572: hr_jp_standard_pkg.sjhextochar('94AA8FE49387814094AA8FE492AC'));
573: l_text := replace(l_text,
567: l_text := replace(l_text,
568: hr_jp_standard_pkg.sjhextochar('8CE491A093878CE491A0938791BA'),
569: hr_jp_standard_pkg.sjhextochar('8CE491A0938781408CE491A0938791BA'));
570: l_text := replace(l_text,
571: hr_jp_standard_pkg.sjhextochar('94AA8FE4938794AA8FE492AC'),
572: hr_jp_standard_pkg.sjhextochar('94AA8FE49387814094AA8FE492AC'));
573: l_text := replace(l_text,
574: hr_jp_standard_pkg.sjhextochar('90C28350938790C28350938791BA'),
575: hr_jp_standard_pkg.sjhextochar('90C283509387814090C28350938791BA'));
568: hr_jp_standard_pkg.sjhextochar('8CE491A093878CE491A0938791BA'),
569: hr_jp_standard_pkg.sjhextochar('8CE491A0938781408CE491A0938791BA'));
570: l_text := replace(l_text,
571: hr_jp_standard_pkg.sjhextochar('94AA8FE4938794AA8FE492AC'),
572: hr_jp_standard_pkg.sjhextochar('94AA8FE49387814094AA8FE492AC'));
573: l_text := replace(l_text,
574: hr_jp_standard_pkg.sjhextochar('90C28350938790C28350938791BA'),
575: hr_jp_standard_pkg.sjhextochar('90C283509387814090C28350938791BA'));
576: l_text := replace(l_text,
570: l_text := replace(l_text,
571: hr_jp_standard_pkg.sjhextochar('94AA8FE4938794AA8FE492AC'),
572: hr_jp_standard_pkg.sjhextochar('94AA8FE49387814094AA8FE492AC'));
573: l_text := replace(l_text,
574: hr_jp_standard_pkg.sjhextochar('90C28350938790C28350938791BA'),
575: hr_jp_standard_pkg.sjhextochar('90C283509387814090C28350938791BA'));
576: l_text := replace(l_text,
577: hr_jp_standard_pkg.sjhextochar('8FAC8A7D8CB48F9493878FAC8A7D8CB491BA'),
578: hr_jp_standard_pkg.sjhextochar('8FAC8A7D8CB48F94938781408FAC8A7D8CB491BA'));
571: hr_jp_standard_pkg.sjhextochar('94AA8FE4938794AA8FE492AC'),
572: hr_jp_standard_pkg.sjhextochar('94AA8FE49387814094AA8FE492AC'));
573: l_text := replace(l_text,
574: hr_jp_standard_pkg.sjhextochar('90C28350938790C28350938791BA'),
575: hr_jp_standard_pkg.sjhextochar('90C283509387814090C28350938791BA'));
576: l_text := replace(l_text,
577: hr_jp_standard_pkg.sjhextochar('8FAC8A7D8CB48F9493878FAC8A7D8CB491BA'),
578: hr_jp_standard_pkg.sjhextochar('8FAC8A7D8CB48F94938781408FAC8A7D8CB491BA'));
579: end if;
573: l_text := replace(l_text,
574: hr_jp_standard_pkg.sjhextochar('90C28350938790C28350938791BA'),
575: hr_jp_standard_pkg.sjhextochar('90C283509387814090C28350938791BA'));
576: l_text := replace(l_text,
577: hr_jp_standard_pkg.sjhextochar('8FAC8A7D8CB48F9493878FAC8A7D8CB491BA'),
578: hr_jp_standard_pkg.sjhextochar('8FAC8A7D8CB48F94938781408FAC8A7D8CB491BA'));
579: end if;
580: end if;
581: return l_text;
574: hr_jp_standard_pkg.sjhextochar('90C28350938790C28350938791BA'),
575: hr_jp_standard_pkg.sjhextochar('90C283509387814090C28350938791BA'));
576: l_text := replace(l_text,
577: hr_jp_standard_pkg.sjhextochar('8FAC8A7D8CB48F9493878FAC8A7D8CB491BA'),
578: hr_jp_standard_pkg.sjhextochar('8FAC8A7D8CB48F94938781408FAC8A7D8CB491BA'));
579: end if;
580: end if;
581: return l_text;
582: END set_space_on_address;
656: return NULL;
657: end if;
658:
659: for i in 1.. length(p_src) loop
660: l_src := hr_jp_standard_pkg.chartohex(substr(p_src,i,1),'JA16SJIS');
661: if length(l_src) = 2 then --1byte character
662: if l_kanji = 1 and l_ank = 0 then
663: l_ank := 1;
664: l_kanji := 0;
672: l_b3 := substr(l_src,3,1);
673: l_b4 := substr(l_src,4,1);
674:
675: -- hex A..F -> 10..15
676: if to_number(hr_jp_standard_pkg.chartohex(l_b1,'JA16SJIS')) >= 41 then
677: l_b1 := to_char(to_number(hr_jp_standard_pkg.chartohex(l_b1,'JA16SJIS'))) - 31;
678: end if;
679: if to_number(hr_jp_standard_pkg.chartohex(l_b2,'JA16SJIS')) >= 41 then
680: l_b2 := to_char(to_number(hr_jp_standard_pkg.chartohex(l_b2,'JA16SJIS'))) - 31;
673: l_b4 := substr(l_src,4,1);
674:
675: -- hex A..F -> 10..15
676: if to_number(hr_jp_standard_pkg.chartohex(l_b1,'JA16SJIS')) >= 41 then
677: l_b1 := to_char(to_number(hr_jp_standard_pkg.chartohex(l_b1,'JA16SJIS'))) - 31;
678: end if;
679: if to_number(hr_jp_standard_pkg.chartohex(l_b2,'JA16SJIS')) >= 41 then
680: l_b2 := to_char(to_number(hr_jp_standard_pkg.chartohex(l_b2,'JA16SJIS'))) - 31;
681: end if;
675: -- hex A..F -> 10..15
676: if to_number(hr_jp_standard_pkg.chartohex(l_b1,'JA16SJIS')) >= 41 then
677: l_b1 := to_char(to_number(hr_jp_standard_pkg.chartohex(l_b1,'JA16SJIS'))) - 31;
678: end if;
679: if to_number(hr_jp_standard_pkg.chartohex(l_b2,'JA16SJIS')) >= 41 then
680: l_b2 := to_char(to_number(hr_jp_standard_pkg.chartohex(l_b2,'JA16SJIS'))) - 31;
681: end if;
682: if to_number(hr_jp_standard_pkg.chartohex(l_b3,'JA16SJIS')) >= 41 then
683: l_b3 := to_char(to_number(hr_jp_standard_pkg.chartohex(l_b3,'JA16SJIS'))) - 31;
676: if to_number(hr_jp_standard_pkg.chartohex(l_b1,'JA16SJIS')) >= 41 then
677: l_b1 := to_char(to_number(hr_jp_standard_pkg.chartohex(l_b1,'JA16SJIS'))) - 31;
678: end if;
679: if to_number(hr_jp_standard_pkg.chartohex(l_b2,'JA16SJIS')) >= 41 then
680: l_b2 := to_char(to_number(hr_jp_standard_pkg.chartohex(l_b2,'JA16SJIS'))) - 31;
681: end if;
682: if to_number(hr_jp_standard_pkg.chartohex(l_b3,'JA16SJIS')) >= 41 then
683: l_b3 := to_char(to_number(hr_jp_standard_pkg.chartohex(l_b3,'JA16SJIS'))) - 31;
684: end if;
678: end if;
679: if to_number(hr_jp_standard_pkg.chartohex(l_b2,'JA16SJIS')) >= 41 then
680: l_b2 := to_char(to_number(hr_jp_standard_pkg.chartohex(l_b2,'JA16SJIS'))) - 31;
681: end if;
682: if to_number(hr_jp_standard_pkg.chartohex(l_b3,'JA16SJIS')) >= 41 then
683: l_b3 := to_char(to_number(hr_jp_standard_pkg.chartohex(l_b3,'JA16SJIS'))) - 31;
684: end if;
685: if to_number(hr_jp_standard_pkg.chartohex(l_b4,'JA16SJIS')) >= 41 then
686: l_b4 := to_char(to_number(hr_jp_standard_pkg.chartohex(l_b4,'JA16SJIS'))) - 31;
679: if to_number(hr_jp_standard_pkg.chartohex(l_b2,'JA16SJIS')) >= 41 then
680: l_b2 := to_char(to_number(hr_jp_standard_pkg.chartohex(l_b2,'JA16SJIS'))) - 31;
681: end if;
682: if to_number(hr_jp_standard_pkg.chartohex(l_b3,'JA16SJIS')) >= 41 then
683: l_b3 := to_char(to_number(hr_jp_standard_pkg.chartohex(l_b3,'JA16SJIS'))) - 31;
684: end if;
685: if to_number(hr_jp_standard_pkg.chartohex(l_b4,'JA16SJIS')) >= 41 then
686: l_b4 := to_char(to_number(hr_jp_standard_pkg.chartohex(l_b4,'JA16SJIS'))) - 31;
687: end if;
681: end if;
682: if to_number(hr_jp_standard_pkg.chartohex(l_b3,'JA16SJIS')) >= 41 then
683: l_b3 := to_char(to_number(hr_jp_standard_pkg.chartohex(l_b3,'JA16SJIS'))) - 31;
684: end if;
685: if to_number(hr_jp_standard_pkg.chartohex(l_b4,'JA16SJIS')) >= 41 then
686: l_b4 := to_char(to_number(hr_jp_standard_pkg.chartohex(l_b4,'JA16SJIS'))) - 31;
687: end if;
688:
689: -- if 1byte >= 0xE0 then 1byte := 1byte - 0x40;
682: if to_number(hr_jp_standard_pkg.chartohex(l_b3,'JA16SJIS')) >= 41 then
683: l_b3 := to_char(to_number(hr_jp_standard_pkg.chartohex(l_b3,'JA16SJIS'))) - 31;
684: end if;
685: if to_number(hr_jp_standard_pkg.chartohex(l_b4,'JA16SJIS')) >= 41 then
686: l_b4 := to_char(to_number(hr_jp_standard_pkg.chartohex(l_b4,'JA16SJIS'))) - 31;
687: end if;
688:
689: -- if 1byte >= 0xE0 then 1byte := 1byte - 0x40;
690: if to_number(l_b1) >= 14 then
743: l_jis := l_jis || '1B2440';
744: end if;
745:
746: if to_number(l_b1) > 9 then
747: l_b1 := hr_jp_standard_pkg.sjhextochar(to_char(to_number(l_b1)+31));
748: end if;
749: if to_number(l_b2) > 9 then
750: l_b2 := hr_jp_standard_pkg.sjhextochar(to_char(to_number(l_b2)+31));
751: end if;
746: if to_number(l_b1) > 9 then
747: l_b1 := hr_jp_standard_pkg.sjhextochar(to_char(to_number(l_b1)+31));
748: end if;
749: if to_number(l_b2) > 9 then
750: l_b2 := hr_jp_standard_pkg.sjhextochar(to_char(to_number(l_b2)+31));
751: end if;
752: if to_number(l_b3) > 9 then
753: l_b3 := hr_jp_standard_pkg.sjhextochar(to_char(to_number(l_b3)+31));
754: end if;
749: if to_number(l_b2) > 9 then
750: l_b2 := hr_jp_standard_pkg.sjhextochar(to_char(to_number(l_b2)+31));
751: end if;
752: if to_number(l_b3) > 9 then
753: l_b3 := hr_jp_standard_pkg.sjhextochar(to_char(to_number(l_b3)+31));
754: end if;
755: if to_number(l_b4) > 9 then
756: l_b4 := hr_jp_standard_pkg.sjhextochar(to_char(to_number(l_b4)+31));
757: end if;
752: if to_number(l_b3) > 9 then
753: l_b3 := hr_jp_standard_pkg.sjhextochar(to_char(to_number(l_b3)+31));
754: end if;
755: if to_number(l_b4) > 9 then
756: l_b4 := hr_jp_standard_pkg.sjhextochar(to_char(to_number(l_b4)+31));
757: end if;
758:
759: l_jis := l_jis || l_b1 || l_b2 || l_b3 || l_b4;
760: end if;
764: -- escape sequence KO (kanji out, ANK shift code "ESC(H")
765: l_jis := l_jis || '1B2848';
766: end if;
767:
768: return hr_jp_standard_pkg.sjhextochar(l_jis);
769: -- dbms_output.put_line(l_jis);
770: END sjtojis;
771: -----------------------------------------------------
772: -- ELIGIBLE_FOR_SUBMISSION --
1297: end if;
1298: if nvl(p_kanji_flag,'1') = '0' then
1299: -- Translate KANA 2 byte to 1 byte
1300: l_text := translate(l_text,
1301: hr_jp_standard_pkg.sjhextochar('83418343834583478349834A834C834E83508352835483568358835A835C835E83608363836583678369836A836B836C836D836E837183748377837A837D837E8380838183828384838683888389838A838B838C838D838F83928393'),
1302: hr_jp_standard_pkg.sjhextochar('B1B2B3B4B5B6B7B8B9BABBBCBDBEBFC0C1C2C3C4C5C6C7C8C9CACBCCCDCECFD0D1D2D3D4D5D6D7D8D9DADBDCA6DD'));
1303:
1304: -- for voiced sound
1305: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('834B'),hr_jp_standard_pkg.sjhextochar('B6DE'));
1298: if nvl(p_kanji_flag,'1') = '0' then
1299: -- Translate KANA 2 byte to 1 byte
1300: l_text := translate(l_text,
1301: hr_jp_standard_pkg.sjhextochar('83418343834583478349834A834C834E83508352835483568358835A835C835E83608363836583678369836A836B836C836D836E837183748377837A837D837E8380838183828384838683888389838A838B838C838D838F83928393'),
1302: hr_jp_standard_pkg.sjhextochar('B1B2B3B4B5B6B7B8B9BABBBCBDBEBFC0C1C2C3C4C5C6C7C8C9CACBCCCDCECFD0D1D2D3D4D5D6D7D8D9DADBDCA6DD'));
1303:
1304: -- for voiced sound
1305: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('834B'),hr_jp_standard_pkg.sjhextochar('B6DE'));
1306: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('834D'),hr_jp_standard_pkg.sjhextochar('B7DE'));
1301: hr_jp_standard_pkg.sjhextochar('83418343834583478349834A834C834E83508352835483568358835A835C835E83608363836583678369836A836B836C836D836E837183748377837A837D837E8380838183828384838683888389838A838B838C838D838F83928393'),
1302: hr_jp_standard_pkg.sjhextochar('B1B2B3B4B5B6B7B8B9BABBBCBDBEBFC0C1C2C3C4C5C6C7C8C9CACBCCCDCECFD0D1D2D3D4D5D6D7D8D9DADBDCA6DD'));
1303:
1304: -- for voiced sound
1305: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('834B'),hr_jp_standard_pkg.sjhextochar('B6DE'));
1306: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('834D'),hr_jp_standard_pkg.sjhextochar('B7DE'));
1307: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('834F'),hr_jp_standard_pkg.sjhextochar('B8DE'));
1308: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8351'),hr_jp_standard_pkg.sjhextochar('B9DE'));
1309: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8353'),hr_jp_standard_pkg.sjhextochar('BADE'));
1302: hr_jp_standard_pkg.sjhextochar('B1B2B3B4B5B6B7B8B9BABBBCBDBEBFC0C1C2C3C4C5C6C7C8C9CACBCCCDCECFD0D1D2D3D4D5D6D7D8D9DADBDCA6DD'));
1303:
1304: -- for voiced sound
1305: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('834B'),hr_jp_standard_pkg.sjhextochar('B6DE'));
1306: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('834D'),hr_jp_standard_pkg.sjhextochar('B7DE'));
1307: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('834F'),hr_jp_standard_pkg.sjhextochar('B8DE'));
1308: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8351'),hr_jp_standard_pkg.sjhextochar('B9DE'));
1309: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8353'),hr_jp_standard_pkg.sjhextochar('BADE'));
1310: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8355'),hr_jp_standard_pkg.sjhextochar('BBDE'));
1303:
1304: -- for voiced sound
1305: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('834B'),hr_jp_standard_pkg.sjhextochar('B6DE'));
1306: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('834D'),hr_jp_standard_pkg.sjhextochar('B7DE'));
1307: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('834F'),hr_jp_standard_pkg.sjhextochar('B8DE'));
1308: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8351'),hr_jp_standard_pkg.sjhextochar('B9DE'));
1309: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8353'),hr_jp_standard_pkg.sjhextochar('BADE'));
1310: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8355'),hr_jp_standard_pkg.sjhextochar('BBDE'));
1311: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8357'),hr_jp_standard_pkg.sjhextochar('BCDE'));
1304: -- for voiced sound
1305: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('834B'),hr_jp_standard_pkg.sjhextochar('B6DE'));
1306: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('834D'),hr_jp_standard_pkg.sjhextochar('B7DE'));
1307: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('834F'),hr_jp_standard_pkg.sjhextochar('B8DE'));
1308: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8351'),hr_jp_standard_pkg.sjhextochar('B9DE'));
1309: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8353'),hr_jp_standard_pkg.sjhextochar('BADE'));
1310: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8355'),hr_jp_standard_pkg.sjhextochar('BBDE'));
1311: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8357'),hr_jp_standard_pkg.sjhextochar('BCDE'));
1312: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8359'),hr_jp_standard_pkg.sjhextochar('BDDE'));
1305: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('834B'),hr_jp_standard_pkg.sjhextochar('B6DE'));
1306: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('834D'),hr_jp_standard_pkg.sjhextochar('B7DE'));
1307: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('834F'),hr_jp_standard_pkg.sjhextochar('B8DE'));
1308: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8351'),hr_jp_standard_pkg.sjhextochar('B9DE'));
1309: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8353'),hr_jp_standard_pkg.sjhextochar('BADE'));
1310: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8355'),hr_jp_standard_pkg.sjhextochar('BBDE'));
1311: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8357'),hr_jp_standard_pkg.sjhextochar('BCDE'));
1312: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8359'),hr_jp_standard_pkg.sjhextochar('BDDE'));
1313: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('835B'),hr_jp_standard_pkg.sjhextochar('BEDE'));
1306: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('834D'),hr_jp_standard_pkg.sjhextochar('B7DE'));
1307: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('834F'),hr_jp_standard_pkg.sjhextochar('B8DE'));
1308: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8351'),hr_jp_standard_pkg.sjhextochar('B9DE'));
1309: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8353'),hr_jp_standard_pkg.sjhextochar('BADE'));
1310: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8355'),hr_jp_standard_pkg.sjhextochar('BBDE'));
1311: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8357'),hr_jp_standard_pkg.sjhextochar('BCDE'));
1312: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8359'),hr_jp_standard_pkg.sjhextochar('BDDE'));
1313: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('835B'),hr_jp_standard_pkg.sjhextochar('BEDE'));
1314: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('835D'),hr_jp_standard_pkg.sjhextochar('BFDE'));
1307: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('834F'),hr_jp_standard_pkg.sjhextochar('B8DE'));
1308: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8351'),hr_jp_standard_pkg.sjhextochar('B9DE'));
1309: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8353'),hr_jp_standard_pkg.sjhextochar('BADE'));
1310: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8355'),hr_jp_standard_pkg.sjhextochar('BBDE'));
1311: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8357'),hr_jp_standard_pkg.sjhextochar('BCDE'));
1312: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8359'),hr_jp_standard_pkg.sjhextochar('BDDE'));
1313: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('835B'),hr_jp_standard_pkg.sjhextochar('BEDE'));
1314: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('835D'),hr_jp_standard_pkg.sjhextochar('BFDE'));
1315: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('835F'),hr_jp_standard_pkg.sjhextochar('C0DE'));
1308: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8351'),hr_jp_standard_pkg.sjhextochar('B9DE'));
1309: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8353'),hr_jp_standard_pkg.sjhextochar('BADE'));
1310: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8355'),hr_jp_standard_pkg.sjhextochar('BBDE'));
1311: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8357'),hr_jp_standard_pkg.sjhextochar('BCDE'));
1312: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8359'),hr_jp_standard_pkg.sjhextochar('BDDE'));
1313: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('835B'),hr_jp_standard_pkg.sjhextochar('BEDE'));
1314: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('835D'),hr_jp_standard_pkg.sjhextochar('BFDE'));
1315: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('835F'),hr_jp_standard_pkg.sjhextochar('C0DE'));
1316: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8361'),hr_jp_standard_pkg.sjhextochar('C1DE'));
1309: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8353'),hr_jp_standard_pkg.sjhextochar('BADE'));
1310: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8355'),hr_jp_standard_pkg.sjhextochar('BBDE'));
1311: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8357'),hr_jp_standard_pkg.sjhextochar('BCDE'));
1312: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8359'),hr_jp_standard_pkg.sjhextochar('BDDE'));
1313: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('835B'),hr_jp_standard_pkg.sjhextochar('BEDE'));
1314: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('835D'),hr_jp_standard_pkg.sjhextochar('BFDE'));
1315: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('835F'),hr_jp_standard_pkg.sjhextochar('C0DE'));
1316: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8361'),hr_jp_standard_pkg.sjhextochar('C1DE'));
1317: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8364'),hr_jp_standard_pkg.sjhextochar('C2DE'));
1310: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8355'),hr_jp_standard_pkg.sjhextochar('BBDE'));
1311: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8357'),hr_jp_standard_pkg.sjhextochar('BCDE'));
1312: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8359'),hr_jp_standard_pkg.sjhextochar('BDDE'));
1313: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('835B'),hr_jp_standard_pkg.sjhextochar('BEDE'));
1314: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('835D'),hr_jp_standard_pkg.sjhextochar('BFDE'));
1315: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('835F'),hr_jp_standard_pkg.sjhextochar('C0DE'));
1316: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8361'),hr_jp_standard_pkg.sjhextochar('C1DE'));
1317: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8364'),hr_jp_standard_pkg.sjhextochar('C2DE'));
1318: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8366'),hr_jp_standard_pkg.sjhextochar('C3DE'));
1311: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8357'),hr_jp_standard_pkg.sjhextochar('BCDE'));
1312: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8359'),hr_jp_standard_pkg.sjhextochar('BDDE'));
1313: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('835B'),hr_jp_standard_pkg.sjhextochar('BEDE'));
1314: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('835D'),hr_jp_standard_pkg.sjhextochar('BFDE'));
1315: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('835F'),hr_jp_standard_pkg.sjhextochar('C0DE'));
1316: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8361'),hr_jp_standard_pkg.sjhextochar('C1DE'));
1317: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8364'),hr_jp_standard_pkg.sjhextochar('C2DE'));
1318: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8366'),hr_jp_standard_pkg.sjhextochar('C3DE'));
1319: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8368'),hr_jp_standard_pkg.sjhextochar('C4DE'));
1312: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8359'),hr_jp_standard_pkg.sjhextochar('BDDE'));
1313: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('835B'),hr_jp_standard_pkg.sjhextochar('BEDE'));
1314: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('835D'),hr_jp_standard_pkg.sjhextochar('BFDE'));
1315: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('835F'),hr_jp_standard_pkg.sjhextochar('C0DE'));
1316: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8361'),hr_jp_standard_pkg.sjhextochar('C1DE'));
1317: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8364'),hr_jp_standard_pkg.sjhextochar('C2DE'));
1318: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8366'),hr_jp_standard_pkg.sjhextochar('C3DE'));
1319: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8368'),hr_jp_standard_pkg.sjhextochar('C4DE'));
1320: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('836F'),hr_jp_standard_pkg.sjhextochar('CADE'));
1313: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('835B'),hr_jp_standard_pkg.sjhextochar('BEDE'));
1314: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('835D'),hr_jp_standard_pkg.sjhextochar('BFDE'));
1315: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('835F'),hr_jp_standard_pkg.sjhextochar('C0DE'));
1316: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8361'),hr_jp_standard_pkg.sjhextochar('C1DE'));
1317: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8364'),hr_jp_standard_pkg.sjhextochar('C2DE'));
1318: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8366'),hr_jp_standard_pkg.sjhextochar('C3DE'));
1319: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8368'),hr_jp_standard_pkg.sjhextochar('C4DE'));
1320: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('836F'),hr_jp_standard_pkg.sjhextochar('CADE'));
1321: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8370'),hr_jp_standard_pkg.sjhextochar('CADF'));
1314: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('835D'),hr_jp_standard_pkg.sjhextochar('BFDE'));
1315: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('835F'),hr_jp_standard_pkg.sjhextochar('C0DE'));
1316: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8361'),hr_jp_standard_pkg.sjhextochar('C1DE'));
1317: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8364'),hr_jp_standard_pkg.sjhextochar('C2DE'));
1318: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8366'),hr_jp_standard_pkg.sjhextochar('C3DE'));
1319: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8368'),hr_jp_standard_pkg.sjhextochar('C4DE'));
1320: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('836F'),hr_jp_standard_pkg.sjhextochar('CADE'));
1321: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8370'),hr_jp_standard_pkg.sjhextochar('CADF'));
1322: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8372'),hr_jp_standard_pkg.sjhextochar('CBDE'));
1315: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('835F'),hr_jp_standard_pkg.sjhextochar('C0DE'));
1316: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8361'),hr_jp_standard_pkg.sjhextochar('C1DE'));
1317: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8364'),hr_jp_standard_pkg.sjhextochar('C2DE'));
1318: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8366'),hr_jp_standard_pkg.sjhextochar('C3DE'));
1319: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8368'),hr_jp_standard_pkg.sjhextochar('C4DE'));
1320: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('836F'),hr_jp_standard_pkg.sjhextochar('CADE'));
1321: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8370'),hr_jp_standard_pkg.sjhextochar('CADF'));
1322: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8372'),hr_jp_standard_pkg.sjhextochar('CBDE'));
1323: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8373'),hr_jp_standard_pkg.sjhextochar('CBDF'));
1316: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8361'),hr_jp_standard_pkg.sjhextochar('C1DE'));
1317: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8364'),hr_jp_standard_pkg.sjhextochar('C2DE'));
1318: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8366'),hr_jp_standard_pkg.sjhextochar('C3DE'));
1319: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8368'),hr_jp_standard_pkg.sjhextochar('C4DE'));
1320: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('836F'),hr_jp_standard_pkg.sjhextochar('CADE'));
1321: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8370'),hr_jp_standard_pkg.sjhextochar('CADF'));
1322: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8372'),hr_jp_standard_pkg.sjhextochar('CBDE'));
1323: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8373'),hr_jp_standard_pkg.sjhextochar('CBDF'));
1324: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8375'),hr_jp_standard_pkg.sjhextochar('CCDE'));
1317: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8364'),hr_jp_standard_pkg.sjhextochar('C2DE'));
1318: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8366'),hr_jp_standard_pkg.sjhextochar('C3DE'));
1319: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8368'),hr_jp_standard_pkg.sjhextochar('C4DE'));
1320: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('836F'),hr_jp_standard_pkg.sjhextochar('CADE'));
1321: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8370'),hr_jp_standard_pkg.sjhextochar('CADF'));
1322: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8372'),hr_jp_standard_pkg.sjhextochar('CBDE'));
1323: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8373'),hr_jp_standard_pkg.sjhextochar('CBDF'));
1324: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8375'),hr_jp_standard_pkg.sjhextochar('CCDE'));
1325: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8376'),hr_jp_standard_pkg.sjhextochar('CCDF'));
1318: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8366'),hr_jp_standard_pkg.sjhextochar('C3DE'));
1319: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8368'),hr_jp_standard_pkg.sjhextochar('C4DE'));
1320: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('836F'),hr_jp_standard_pkg.sjhextochar('CADE'));
1321: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8370'),hr_jp_standard_pkg.sjhextochar('CADF'));
1322: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8372'),hr_jp_standard_pkg.sjhextochar('CBDE'));
1323: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8373'),hr_jp_standard_pkg.sjhextochar('CBDF'));
1324: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8375'),hr_jp_standard_pkg.sjhextochar('CCDE'));
1325: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8376'),hr_jp_standard_pkg.sjhextochar('CCDF'));
1326: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8378'),hr_jp_standard_pkg.sjhextochar('CDDE'));
1319: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8368'),hr_jp_standard_pkg.sjhextochar('C4DE'));
1320: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('836F'),hr_jp_standard_pkg.sjhextochar('CADE'));
1321: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8370'),hr_jp_standard_pkg.sjhextochar('CADF'));
1322: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8372'),hr_jp_standard_pkg.sjhextochar('CBDE'));
1323: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8373'),hr_jp_standard_pkg.sjhextochar('CBDF'));
1324: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8375'),hr_jp_standard_pkg.sjhextochar('CCDE'));
1325: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8376'),hr_jp_standard_pkg.sjhextochar('CCDF'));
1326: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8378'),hr_jp_standard_pkg.sjhextochar('CDDE'));
1327: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8379'),hr_jp_standard_pkg.sjhextochar('CDDF'));
1320: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('836F'),hr_jp_standard_pkg.sjhextochar('CADE'));
1321: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8370'),hr_jp_standard_pkg.sjhextochar('CADF'));
1322: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8372'),hr_jp_standard_pkg.sjhextochar('CBDE'));
1323: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8373'),hr_jp_standard_pkg.sjhextochar('CBDF'));
1324: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8375'),hr_jp_standard_pkg.sjhextochar('CCDE'));
1325: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8376'),hr_jp_standard_pkg.sjhextochar('CCDF'));
1326: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8378'),hr_jp_standard_pkg.sjhextochar('CDDE'));
1327: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8379'),hr_jp_standard_pkg.sjhextochar('CDDF'));
1328: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('837B'),hr_jp_standard_pkg.sjhextochar('CEDE'));
1321: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8370'),hr_jp_standard_pkg.sjhextochar('CADF'));
1322: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8372'),hr_jp_standard_pkg.sjhextochar('CBDE'));
1323: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8373'),hr_jp_standard_pkg.sjhextochar('CBDF'));
1324: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8375'),hr_jp_standard_pkg.sjhextochar('CCDE'));
1325: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8376'),hr_jp_standard_pkg.sjhextochar('CCDF'));
1326: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8378'),hr_jp_standard_pkg.sjhextochar('CDDE'));
1327: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8379'),hr_jp_standard_pkg.sjhextochar('CDDF'));
1328: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('837B'),hr_jp_standard_pkg.sjhextochar('CEDE'));
1329: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('837C'),hr_jp_standard_pkg.sjhextochar('CEDF'));
1322: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8372'),hr_jp_standard_pkg.sjhextochar('CBDE'));
1323: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8373'),hr_jp_standard_pkg.sjhextochar('CBDF'));
1324: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8375'),hr_jp_standard_pkg.sjhextochar('CCDE'));
1325: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8376'),hr_jp_standard_pkg.sjhextochar('CCDF'));
1326: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8378'),hr_jp_standard_pkg.sjhextochar('CDDE'));
1327: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8379'),hr_jp_standard_pkg.sjhextochar('CDDF'));
1328: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('837B'),hr_jp_standard_pkg.sjhextochar('CEDE'));
1329: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('837C'),hr_jp_standard_pkg.sjhextochar('CEDF'));
1330:
1323: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8373'),hr_jp_standard_pkg.sjhextochar('CBDF'));
1324: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8375'),hr_jp_standard_pkg.sjhextochar('CCDE'));
1325: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8376'),hr_jp_standard_pkg.sjhextochar('CCDF'));
1326: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8378'),hr_jp_standard_pkg.sjhextochar('CDDE'));
1327: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8379'),hr_jp_standard_pkg.sjhextochar('CDDF'));
1328: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('837B'),hr_jp_standard_pkg.sjhextochar('CEDE'));
1329: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('837C'),hr_jp_standard_pkg.sjhextochar('CEDF'));
1330:
1331: -- for double consonant and so on
1324: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8375'),hr_jp_standard_pkg.sjhextochar('CCDE'));
1325: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8376'),hr_jp_standard_pkg.sjhextochar('CCDF'));
1326: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8378'),hr_jp_standard_pkg.sjhextochar('CDDE'));
1327: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8379'),hr_jp_standard_pkg.sjhextochar('CDDF'));
1328: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('837B'),hr_jp_standard_pkg.sjhextochar('CEDE'));
1329: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('837C'),hr_jp_standard_pkg.sjhextochar('CEDF'));
1330:
1331: -- for double consonant and so on
1332: l_text := translate(l_text,
1325: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8376'),hr_jp_standard_pkg.sjhextochar('CCDF'));
1326: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8378'),hr_jp_standard_pkg.sjhextochar('CDDE'));
1327: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('8379'),hr_jp_standard_pkg.sjhextochar('CDDF'));
1328: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('837B'),hr_jp_standard_pkg.sjhextochar('CEDE'));
1329: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('837C'),hr_jp_standard_pkg.sjhextochar('CEDF'));
1330:
1331: -- for double consonant and so on
1332: l_text := translate(l_text,
1333: hr_jp_standard_pkg.sjhextochar('834083428344834683488383838583878362A7A8A9AAABACADAEAF'),
1329: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('837C'),hr_jp_standard_pkg.sjhextochar('CEDF'));
1330:
1331: -- for double consonant and so on
1332: l_text := translate(l_text,
1333: hr_jp_standard_pkg.sjhextochar('834083428344834683488383838583878362A7A8A9AAABACADAEAF'),
1334: hr_jp_standard_pkg.sjhextochar('B1B2B3B4B5D4D5D6C2B1B2B3B4B5D4D5D6C2'));
1335:
1336: -- for others
1337: l_text := translate(l_text,
1330:
1331: -- for double consonant and so on
1332: l_text := translate(l_text,
1333: hr_jp_standard_pkg.sjhextochar('834083428344834683488383838583878362A7A8A9AAABACADAEAF'),
1334: hr_jp_standard_pkg.sjhextochar('B1B2B3B4B5D4D5D6C2B1B2B3B4B5D4D5D6C2'));
1335:
1336: -- for others
1337: l_text := translate(l_text,
1338: hr_jp_standard_pkg.sjhextochar('81428175817681418145815B'),
1334: hr_jp_standard_pkg.sjhextochar('B1B2B3B4B5D4D5D6C2B1B2B3B4B5D4D5D6C2'));
1335:
1336: -- for others
1337: l_text := translate(l_text,
1338: hr_jp_standard_pkg.sjhextochar('81428175817681418145815B'),
1339: hr_jp_standard_pkg.sjhextochar('A1A2A3A4A5B0'));
1340:
1341: -- for space
1342: l_text := translate(l_text,hr_jp_standard_pkg.sjhextochar('8140'),' ');
1335:
1336: -- for others
1337: l_text := translate(l_text,
1338: hr_jp_standard_pkg.sjhextochar('81428175817681418145815B'),
1339: hr_jp_standard_pkg.sjhextochar('A1A2A3A4A5B0'));
1340:
1341: -- for space
1342: l_text := translate(l_text,hr_jp_standard_pkg.sjhextochar('8140'),' ');
1343:
1338: hr_jp_standard_pkg.sjhextochar('81428175817681418145815B'),
1339: hr_jp_standard_pkg.sjhextochar('A1A2A3A4A5B0'));
1340:
1341: -- for space
1342: l_text := translate(l_text,hr_jp_standard_pkg.sjhextochar('8140'),' ');
1343:
1344: else
1345: -- Translate 1 byte to 2 byte
1346: l_text := to_multi_byte(l_text);
1345: -- Translate 1 byte to 2 byte
1346: l_text := to_multi_byte(l_text);
1347:
1348: -- for voiced sound and so on
1349: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('B6DE'),hr_jp_standard_pkg.sjhextochar('834B'));
1350: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('B7DE'),hr_jp_standard_pkg.sjhextochar('834D'));
1351: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('B8DE'),hr_jp_standard_pkg.sjhextochar('834F'));
1352: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('B9DE'),hr_jp_standard_pkg.sjhextochar('8351'));
1353: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BADE'),hr_jp_standard_pkg.sjhextochar('8353'));
1346: l_text := to_multi_byte(l_text);
1347:
1348: -- for voiced sound and so on
1349: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('B6DE'),hr_jp_standard_pkg.sjhextochar('834B'));
1350: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('B7DE'),hr_jp_standard_pkg.sjhextochar('834D'));
1351: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('B8DE'),hr_jp_standard_pkg.sjhextochar('834F'));
1352: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('B9DE'),hr_jp_standard_pkg.sjhextochar('8351'));
1353: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BADE'),hr_jp_standard_pkg.sjhextochar('8353'));
1354: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BBDE'),hr_jp_standard_pkg.sjhextochar('8355'));
1347:
1348: -- for voiced sound and so on
1349: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('B6DE'),hr_jp_standard_pkg.sjhextochar('834B'));
1350: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('B7DE'),hr_jp_standard_pkg.sjhextochar('834D'));
1351: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('B8DE'),hr_jp_standard_pkg.sjhextochar('834F'));
1352: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('B9DE'),hr_jp_standard_pkg.sjhextochar('8351'));
1353: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BADE'),hr_jp_standard_pkg.sjhextochar('8353'));
1354: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BBDE'),hr_jp_standard_pkg.sjhextochar('8355'));
1355: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BCDE'),hr_jp_standard_pkg.sjhextochar('8357'));
1348: -- for voiced sound and so on
1349: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('B6DE'),hr_jp_standard_pkg.sjhextochar('834B'));
1350: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('B7DE'),hr_jp_standard_pkg.sjhextochar('834D'));
1351: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('B8DE'),hr_jp_standard_pkg.sjhextochar('834F'));
1352: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('B9DE'),hr_jp_standard_pkg.sjhextochar('8351'));
1353: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BADE'),hr_jp_standard_pkg.sjhextochar('8353'));
1354: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BBDE'),hr_jp_standard_pkg.sjhextochar('8355'));
1355: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BCDE'),hr_jp_standard_pkg.sjhextochar('8357'));
1356: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BDDE'),hr_jp_standard_pkg.sjhextochar('8359'));
1349: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('B6DE'),hr_jp_standard_pkg.sjhextochar('834B'));
1350: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('B7DE'),hr_jp_standard_pkg.sjhextochar('834D'));
1351: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('B8DE'),hr_jp_standard_pkg.sjhextochar('834F'));
1352: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('B9DE'),hr_jp_standard_pkg.sjhextochar('8351'));
1353: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BADE'),hr_jp_standard_pkg.sjhextochar('8353'));
1354: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BBDE'),hr_jp_standard_pkg.sjhextochar('8355'));
1355: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BCDE'),hr_jp_standard_pkg.sjhextochar('8357'));
1356: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BDDE'),hr_jp_standard_pkg.sjhextochar('8359'));
1357: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BEDE'),hr_jp_standard_pkg.sjhextochar('835B'));
1350: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('B7DE'),hr_jp_standard_pkg.sjhextochar('834D'));
1351: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('B8DE'),hr_jp_standard_pkg.sjhextochar('834F'));
1352: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('B9DE'),hr_jp_standard_pkg.sjhextochar('8351'));
1353: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BADE'),hr_jp_standard_pkg.sjhextochar('8353'));
1354: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BBDE'),hr_jp_standard_pkg.sjhextochar('8355'));
1355: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BCDE'),hr_jp_standard_pkg.sjhextochar('8357'));
1356: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BDDE'),hr_jp_standard_pkg.sjhextochar('8359'));
1357: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BEDE'),hr_jp_standard_pkg.sjhextochar('835B'));
1358: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BFDE'),hr_jp_standard_pkg.sjhextochar('835D'));
1351: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('B8DE'),hr_jp_standard_pkg.sjhextochar('834F'));
1352: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('B9DE'),hr_jp_standard_pkg.sjhextochar('8351'));
1353: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BADE'),hr_jp_standard_pkg.sjhextochar('8353'));
1354: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BBDE'),hr_jp_standard_pkg.sjhextochar('8355'));
1355: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BCDE'),hr_jp_standard_pkg.sjhextochar('8357'));
1356: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BDDE'),hr_jp_standard_pkg.sjhextochar('8359'));
1357: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BEDE'),hr_jp_standard_pkg.sjhextochar('835B'));
1358: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BFDE'),hr_jp_standard_pkg.sjhextochar('835D'));
1359: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('C0DE'),hr_jp_standard_pkg.sjhextochar('835F'));
1352: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('B9DE'),hr_jp_standard_pkg.sjhextochar('8351'));
1353: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BADE'),hr_jp_standard_pkg.sjhextochar('8353'));
1354: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BBDE'),hr_jp_standard_pkg.sjhextochar('8355'));
1355: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BCDE'),hr_jp_standard_pkg.sjhextochar('8357'));
1356: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BDDE'),hr_jp_standard_pkg.sjhextochar('8359'));
1357: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BEDE'),hr_jp_standard_pkg.sjhextochar('835B'));
1358: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BFDE'),hr_jp_standard_pkg.sjhextochar('835D'));
1359: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('C0DE'),hr_jp_standard_pkg.sjhextochar('835F'));
1360: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('C1DE'),hr_jp_standard_pkg.sjhextochar('8361'));
1353: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BADE'),hr_jp_standard_pkg.sjhextochar('8353'));
1354: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BBDE'),hr_jp_standard_pkg.sjhextochar('8355'));
1355: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BCDE'),hr_jp_standard_pkg.sjhextochar('8357'));
1356: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BDDE'),hr_jp_standard_pkg.sjhextochar('8359'));
1357: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BEDE'),hr_jp_standard_pkg.sjhextochar('835B'));
1358: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BFDE'),hr_jp_standard_pkg.sjhextochar('835D'));
1359: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('C0DE'),hr_jp_standard_pkg.sjhextochar('835F'));
1360: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('C1DE'),hr_jp_standard_pkg.sjhextochar('8361'));
1361: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('C2DE'),hr_jp_standard_pkg.sjhextochar('8364'));
1354: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BBDE'),hr_jp_standard_pkg.sjhextochar('8355'));
1355: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BCDE'),hr_jp_standard_pkg.sjhextochar('8357'));
1356: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BDDE'),hr_jp_standard_pkg.sjhextochar('8359'));
1357: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BEDE'),hr_jp_standard_pkg.sjhextochar('835B'));
1358: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BFDE'),hr_jp_standard_pkg.sjhextochar('835D'));
1359: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('C0DE'),hr_jp_standard_pkg.sjhextochar('835F'));
1360: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('C1DE'),hr_jp_standard_pkg.sjhextochar('8361'));
1361: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('C2DE'),hr_jp_standard_pkg.sjhextochar('8364'));
1362: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('C3DE'),hr_jp_standard_pkg.sjhextochar('8366'));
1355: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BCDE'),hr_jp_standard_pkg.sjhextochar('8357'));
1356: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BDDE'),hr_jp_standard_pkg.sjhextochar('8359'));
1357: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BEDE'),hr_jp_standard_pkg.sjhextochar('835B'));
1358: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BFDE'),hr_jp_standard_pkg.sjhextochar('835D'));
1359: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('C0DE'),hr_jp_standard_pkg.sjhextochar('835F'));
1360: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('C1DE'),hr_jp_standard_pkg.sjhextochar('8361'));
1361: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('C2DE'),hr_jp_standard_pkg.sjhextochar('8364'));
1362: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('C3DE'),hr_jp_standard_pkg.sjhextochar('8366'));
1363: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('C4DE'),hr_jp_standard_pkg.sjhextochar('8368'));
1356: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BDDE'),hr_jp_standard_pkg.sjhextochar('8359'));
1357: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BEDE'),hr_jp_standard_pkg.sjhextochar('835B'));
1358: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BFDE'),hr_jp_standard_pkg.sjhextochar('835D'));
1359: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('C0DE'),hr_jp_standard_pkg.sjhextochar('835F'));
1360: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('C1DE'),hr_jp_standard_pkg.sjhextochar('8361'));
1361: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('C2DE'),hr_jp_standard_pkg.sjhextochar('8364'));
1362: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('C3DE'),hr_jp_standard_pkg.sjhextochar('8366'));
1363: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('C4DE'),hr_jp_standard_pkg.sjhextochar('8368'));
1364: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CADE'),hr_jp_standard_pkg.sjhextochar('836F'));
1357: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BEDE'),hr_jp_standard_pkg.sjhextochar('835B'));
1358: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BFDE'),hr_jp_standard_pkg.sjhextochar('835D'));
1359: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('C0DE'),hr_jp_standard_pkg.sjhextochar('835F'));
1360: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('C1DE'),hr_jp_standard_pkg.sjhextochar('8361'));
1361: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('C2DE'),hr_jp_standard_pkg.sjhextochar('8364'));
1362: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('C3DE'),hr_jp_standard_pkg.sjhextochar('8366'));
1363: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('C4DE'),hr_jp_standard_pkg.sjhextochar('8368'));
1364: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CADE'),hr_jp_standard_pkg.sjhextochar('836F'));
1365: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CADF'),hr_jp_standard_pkg.sjhextochar('8370'));
1358: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('BFDE'),hr_jp_standard_pkg.sjhextochar('835D'));
1359: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('C0DE'),hr_jp_standard_pkg.sjhextochar('835F'));
1360: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('C1DE'),hr_jp_standard_pkg.sjhextochar('8361'));
1361: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('C2DE'),hr_jp_standard_pkg.sjhextochar('8364'));
1362: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('C3DE'),hr_jp_standard_pkg.sjhextochar('8366'));
1363: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('C4DE'),hr_jp_standard_pkg.sjhextochar('8368'));
1364: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CADE'),hr_jp_standard_pkg.sjhextochar('836F'));
1365: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CADF'),hr_jp_standard_pkg.sjhextochar('8370'));
1366: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CBDE'),hr_jp_standard_pkg.sjhextochar('8372'));
1359: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('C0DE'),hr_jp_standard_pkg.sjhextochar('835F'));
1360: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('C1DE'),hr_jp_standard_pkg.sjhextochar('8361'));
1361: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('C2DE'),hr_jp_standard_pkg.sjhextochar('8364'));
1362: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('C3DE'),hr_jp_standard_pkg.sjhextochar('8366'));
1363: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('C4DE'),hr_jp_standard_pkg.sjhextochar('8368'));
1364: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CADE'),hr_jp_standard_pkg.sjhextochar('836F'));
1365: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CADF'),hr_jp_standard_pkg.sjhextochar('8370'));
1366: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CBDE'),hr_jp_standard_pkg.sjhextochar('8372'));
1367: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CBDF'),hr_jp_standard_pkg.sjhextochar('8373'));
1360: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('C1DE'),hr_jp_standard_pkg.sjhextochar('8361'));
1361: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('C2DE'),hr_jp_standard_pkg.sjhextochar('8364'));
1362: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('C3DE'),hr_jp_standard_pkg.sjhextochar('8366'));
1363: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('C4DE'),hr_jp_standard_pkg.sjhextochar('8368'));
1364: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CADE'),hr_jp_standard_pkg.sjhextochar('836F'));
1365: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CADF'),hr_jp_standard_pkg.sjhextochar('8370'));
1366: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CBDE'),hr_jp_standard_pkg.sjhextochar('8372'));
1367: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CBDF'),hr_jp_standard_pkg.sjhextochar('8373'));
1368: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CCDE'),hr_jp_standard_pkg.sjhextochar('8375'));
1361: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('C2DE'),hr_jp_standard_pkg.sjhextochar('8364'));
1362: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('C3DE'),hr_jp_standard_pkg.sjhextochar('8366'));
1363: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('C4DE'),hr_jp_standard_pkg.sjhextochar('8368'));
1364: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CADE'),hr_jp_standard_pkg.sjhextochar('836F'));
1365: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CADF'),hr_jp_standard_pkg.sjhextochar('8370'));
1366: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CBDE'),hr_jp_standard_pkg.sjhextochar('8372'));
1367: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CBDF'),hr_jp_standard_pkg.sjhextochar('8373'));
1368: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CCDE'),hr_jp_standard_pkg.sjhextochar('8375'));
1369: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CCDF'),hr_jp_standard_pkg.sjhextochar('8376'));
1362: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('C3DE'),hr_jp_standard_pkg.sjhextochar('8366'));
1363: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('C4DE'),hr_jp_standard_pkg.sjhextochar('8368'));
1364: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CADE'),hr_jp_standard_pkg.sjhextochar('836F'));
1365: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CADF'),hr_jp_standard_pkg.sjhextochar('8370'));
1366: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CBDE'),hr_jp_standard_pkg.sjhextochar('8372'));
1367: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CBDF'),hr_jp_standard_pkg.sjhextochar('8373'));
1368: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CCDE'),hr_jp_standard_pkg.sjhextochar('8375'));
1369: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CCDF'),hr_jp_standard_pkg.sjhextochar('8376'));
1370: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CDDE'),hr_jp_standard_pkg.sjhextochar('8378'));
1363: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('C4DE'),hr_jp_standard_pkg.sjhextochar('8368'));
1364: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CADE'),hr_jp_standard_pkg.sjhextochar('836F'));
1365: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CADF'),hr_jp_standard_pkg.sjhextochar('8370'));
1366: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CBDE'),hr_jp_standard_pkg.sjhextochar('8372'));
1367: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CBDF'),hr_jp_standard_pkg.sjhextochar('8373'));
1368: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CCDE'),hr_jp_standard_pkg.sjhextochar('8375'));
1369: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CCDF'),hr_jp_standard_pkg.sjhextochar('8376'));
1370: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CDDE'),hr_jp_standard_pkg.sjhextochar('8378'));
1371: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CDDF'),hr_jp_standard_pkg.sjhextochar('8379'));
1364: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CADE'),hr_jp_standard_pkg.sjhextochar('836F'));
1365: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CADF'),hr_jp_standard_pkg.sjhextochar('8370'));
1366: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CBDE'),hr_jp_standard_pkg.sjhextochar('8372'));
1367: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CBDF'),hr_jp_standard_pkg.sjhextochar('8373'));
1368: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CCDE'),hr_jp_standard_pkg.sjhextochar('8375'));
1369: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CCDF'),hr_jp_standard_pkg.sjhextochar('8376'));
1370: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CDDE'),hr_jp_standard_pkg.sjhextochar('8378'));
1371: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CDDF'),hr_jp_standard_pkg.sjhextochar('8379'));
1372: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CEDE'),hr_jp_standard_pkg.sjhextochar('837B'));
1365: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CADF'),hr_jp_standard_pkg.sjhextochar('8370'));
1366: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CBDE'),hr_jp_standard_pkg.sjhextochar('8372'));
1367: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CBDF'),hr_jp_standard_pkg.sjhextochar('8373'));
1368: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CCDE'),hr_jp_standard_pkg.sjhextochar('8375'));
1369: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CCDF'),hr_jp_standard_pkg.sjhextochar('8376'));
1370: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CDDE'),hr_jp_standard_pkg.sjhextochar('8378'));
1371: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CDDF'),hr_jp_standard_pkg.sjhextochar('8379'));
1372: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CEDE'),hr_jp_standard_pkg.sjhextochar('837B'));
1373: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CEDF'),hr_jp_standard_pkg.sjhextochar('837C'));
1366: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CBDE'),hr_jp_standard_pkg.sjhextochar('8372'));
1367: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CBDF'),hr_jp_standard_pkg.sjhextochar('8373'));
1368: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CCDE'),hr_jp_standard_pkg.sjhextochar('8375'));
1369: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CCDF'),hr_jp_standard_pkg.sjhextochar('8376'));
1370: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CDDE'),hr_jp_standard_pkg.sjhextochar('8378'));
1371: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CDDF'),hr_jp_standard_pkg.sjhextochar('8379'));
1372: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CEDE'),hr_jp_standard_pkg.sjhextochar('837B'));
1373: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CEDF'),hr_jp_standard_pkg.sjhextochar('837C'));
1374:
1367: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CBDF'),hr_jp_standard_pkg.sjhextochar('8373'));
1368: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CCDE'),hr_jp_standard_pkg.sjhextochar('8375'));
1369: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CCDF'),hr_jp_standard_pkg.sjhextochar('8376'));
1370: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CDDE'),hr_jp_standard_pkg.sjhextochar('8378'));
1371: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CDDF'),hr_jp_standard_pkg.sjhextochar('8379'));
1372: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CEDE'),hr_jp_standard_pkg.sjhextochar('837B'));
1373: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CEDF'),hr_jp_standard_pkg.sjhextochar('837C'));
1374:
1375: -- for KANA
1368: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CCDE'),hr_jp_standard_pkg.sjhextochar('8375'));
1369: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CCDF'),hr_jp_standard_pkg.sjhextochar('8376'));
1370: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CDDE'),hr_jp_standard_pkg.sjhextochar('8378'));
1371: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CDDF'),hr_jp_standard_pkg.sjhextochar('8379'));
1372: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CEDE'),hr_jp_standard_pkg.sjhextochar('837B'));
1373: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CEDF'),hr_jp_standard_pkg.sjhextochar('837C'));
1374:
1375: -- for KANA
1376: l_text := translate(l_text,
1369: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CCDF'),hr_jp_standard_pkg.sjhextochar('8376'));
1370: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CDDE'),hr_jp_standard_pkg.sjhextochar('8378'));
1371: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CDDF'),hr_jp_standard_pkg.sjhextochar('8379'));
1372: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CEDE'),hr_jp_standard_pkg.sjhextochar('837B'));
1373: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CEDF'),hr_jp_standard_pkg.sjhextochar('837C'));
1374:
1375: -- for KANA
1376: l_text := translate(l_text,
1377: hr_jp_standard_pkg.sjhextochar('B1B2B3B4B5B6B7B8B9BABBBCBDBEBFC0C1C2C3C4C5C6C7C8C9CACBCCCDCECFD0D1D2D3D4D5D6D7D8D9DADBDCA6DD'),
1373: l_text := replace(l_text,hr_jp_standard_pkg.sjhextochar('CEDF'),hr_jp_standard_pkg.sjhextochar('837C'));
1374:
1375: -- for KANA
1376: l_text := translate(l_text,
1377: hr_jp_standard_pkg.sjhextochar('B1B2B3B4B5B6B7B8B9BABBBCBDBEBFC0C1C2C3C4C5C6C7C8C9CACBCCCDCECFD0D1D2D3D4D5D6D7D8D9DADBDCA6DD'),
1378: hr_jp_standard_pkg.sjhextochar('83418343834583478349834A834C834E83508352835483568358835A835C835E83608363836583678369836A836B836C836D836E837183748377837A837D837E8380838183828384838683888389838A838B838C838D838F83928393'));
1379:
1380: -- for double consonant and so on
1381: l_text := translate(l_text,
1374:
1375: -- for KANA
1376: l_text := translate(l_text,
1377: hr_jp_standard_pkg.sjhextochar('B1B2B3B4B5B6B7B8B9BABBBCBDBEBFC0C1C2C3C4C5C6C7C8C9CACBCCCDCECFD0D1D2D3D4D5D6D7D8D9DADBDCA6DD'),
1378: hr_jp_standard_pkg.sjhextochar('83418343834583478349834A834C834E83508352835483568358835A835C835E83608363836583678369836A836B836C836D836E837183748377837A837D837E8380838183828384838683888389838A838B838C838D838F83928393'));
1379:
1380: -- for double consonant and so on
1381: l_text := translate(l_text,
1382: hr_jp_standard_pkg.sjhextochar('A7A8A9AAABACADAEAF'),
1378: hr_jp_standard_pkg.sjhextochar('83418343834583478349834A834C834E83508352835483568358835A835C835E83608363836583678369836A836B836C836D836E837183748377837A837D837E8380838183828384838683888389838A838B838C838D838F83928393'));
1379:
1380: -- for double consonant and so on
1381: l_text := translate(l_text,
1382: hr_jp_standard_pkg.sjhextochar('A7A8A9AAABACADAEAF'),
1383: hr_jp_standard_pkg.sjhextochar('834083428344834683488383838583878362'));
1384:
1385: -- for others
1386: l_text := translate(l_text,
1379:
1380: -- for double consonant and so on
1381: l_text := translate(l_text,
1382: hr_jp_standard_pkg.sjhextochar('A7A8A9AAABACADAEAF'),
1383: hr_jp_standard_pkg.sjhextochar('834083428344834683488383838583878362'));
1384:
1385: -- for others
1386: l_text := translate(l_text,
1387: hr_jp_standard_pkg.sjhextochar('A1A2A3A4A5B0'),
1383: hr_jp_standard_pkg.sjhextochar('834083428344834683488383838583878362'));
1384:
1385: -- for others
1386: l_text := translate(l_text,
1387: hr_jp_standard_pkg.sjhextochar('A1A2A3A4A5B0'),
1388: hr_jp_standard_pkg.sjhextochar('81428175817681418145815B'));
1389:
1390: -- for space
1391: l_text := translate(l_text,' ',hr_jp_standard_pkg.sjhextochar('8140'));
1384:
1385: -- for others
1386: l_text := translate(l_text,
1387: hr_jp_standard_pkg.sjhextochar('A1A2A3A4A5B0'),
1388: hr_jp_standard_pkg.sjhextochar('81428175817681418145815B'));
1389:
1390: -- for space
1391: l_text := translate(l_text,' ',hr_jp_standard_pkg.sjhextochar('8140'));
1392: end if;
1387: hr_jp_standard_pkg.sjhextochar('A1A2A3A4A5B0'),
1388: hr_jp_standard_pkg.sjhextochar('81428175817681418145815B'));
1389:
1390: -- for space
1391: l_text := translate(l_text,' ',hr_jp_standard_pkg.sjhextochar('8140'));
1392: end if;
1393:
1394:
1395: return ltrim(rtrim(substrb(l_text,1,2000)));
3064: begin
3065: --
3066: -- use substr (not substrb)
3067: if p_type = 'z' then
3068: return substr(hr_jp_standard_pkg.to_zenkaku(p_text),1,p_len);
3069: elsif p_type = 'h' then
3070: return substr(hr_jp_standard_pkg.to_hankaku(p_text),1,p_len);
3071: else
3072: return substr(p_text,1,p_len);
3066: -- use substr (not substrb)
3067: if p_type = 'z' then
3068: return substr(hr_jp_standard_pkg.to_zenkaku(p_text),1,p_len);
3069: elsif p_type = 'h' then
3070: return substr(hr_jp_standard_pkg.to_hankaku(p_text),1,p_len);
3071: else
3072: return substr(p_text,1,p_len);
3073: end if;
3074: --