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