eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_PER_TYPE_USAGE_INTERNAL dependencies on BEN_PTU_LER

Line 8: g_old_ben_ptu_ler_rec ben_ptu_ler.g_ptu_ler_rec;

4: -- Package Variables
5: --
6: g_package varchar2(33) := ' per_person_type_usage_internal.';
7: g_debug boolean := hr_utility.debug_enabled;
8: g_old_ben_ptu_ler_rec ben_ptu_ler.g_ptu_ler_rec;
9: --
10: -- ----------------------------------------------------------------------------
11: -- |------------------------< create_person_type_usage >----------------------|
12: -- ----------------------------------------------------------------------------

Line 443: -- |-------------------------< get_ben_ptu_ler_rec >--------------------------|

439: --
440: end update_person_type_usage;
441: --
442: -- ----------------------------------------------------------------------------
443: -- |-------------------------< get_ben_ptu_ler_rec >--------------------------|
444: -- ----------------------------------------------------------------------------
445: function get_ben_ptu_ler_rec
446: ( p_effective_date in date
447: ,p_person_type_usage_id in number

Line 445: function get_ben_ptu_ler_rec

441: --
442: -- ----------------------------------------------------------------------------
443: -- |-------------------------< get_ben_ptu_ler_rec >--------------------------|
444: -- ----------------------------------------------------------------------------
445: function get_ben_ptu_ler_rec
446: ( p_effective_date in date
447: ,p_person_type_usage_id in number
448: )
449: return ben_ptu_ler.g_ptu_ler_rec is

Line 449: return ben_ptu_ler.g_ptu_ler_rec is

445: function get_ben_ptu_ler_rec
446: ( p_effective_date in date
447: ,p_person_type_usage_id in number
448: )
449: return ben_ptu_ler.g_ptu_ler_rec is
450: --
451: -- Declare cursors and local variables
452: --
453: cursor csr_person_type_usages

Line 463: l_ben_ptu_ler_rec ben_ptu_ler.g_ptu_ler_rec;

459: where p_effective_date between ptu.effective_start_date and ptu.effective_end_date
460: and ptu.person_type_usage_id = p_person_type_usage_id;
461: l_person_type_usage csr_person_type_usages%rowtype;
462: --
463: l_ben_ptu_ler_rec ben_ptu_ler.g_ptu_ler_rec;
464: --
465: begin
466: --
467: open csr_person_type_usages

Line 473: l_ben_ptu_ler_rec.person_id := l_person_type_usage.person_id;

469: ,p_person_type_usage_id => p_person_type_usage_id
470: );
471: fetch csr_person_type_usages into l_person_type_usage;
472: close csr_person_type_usages;
473: l_ben_ptu_ler_rec.person_id := l_person_type_usage.person_id;
474: l_ben_ptu_ler_rec.person_type_usage_id := l_person_type_usage.person_type_usage_id;
475: l_ben_ptu_ler_rec.person_type_id := l_person_type_usage.person_type_id;
476: l_ben_ptu_ler_rec.effective_start_date := l_person_type_usage.effective_start_date;
477: l_ben_ptu_ler_rec.effective_end_date := l_person_type_usage.effective_end_date;

Line 474: l_ben_ptu_ler_rec.person_type_usage_id := l_person_type_usage.person_type_usage_id;

470: );
471: fetch csr_person_type_usages into l_person_type_usage;
472: close csr_person_type_usages;
473: l_ben_ptu_ler_rec.person_id := l_person_type_usage.person_id;
474: l_ben_ptu_ler_rec.person_type_usage_id := l_person_type_usage.person_type_usage_id;
475: l_ben_ptu_ler_rec.person_type_id := l_person_type_usage.person_type_id;
476: l_ben_ptu_ler_rec.effective_start_date := l_person_type_usage.effective_start_date;
477: l_ben_ptu_ler_rec.effective_end_date := l_person_type_usage.effective_end_date;
478: --

Line 475: l_ben_ptu_ler_rec.person_type_id := l_person_type_usage.person_type_id;

471: fetch csr_person_type_usages into l_person_type_usage;
472: close csr_person_type_usages;
473: l_ben_ptu_ler_rec.person_id := l_person_type_usage.person_id;
474: l_ben_ptu_ler_rec.person_type_usage_id := l_person_type_usage.person_type_usage_id;
475: l_ben_ptu_ler_rec.person_type_id := l_person_type_usage.person_type_id;
476: l_ben_ptu_ler_rec.effective_start_date := l_person_type_usage.effective_start_date;
477: l_ben_ptu_ler_rec.effective_end_date := l_person_type_usage.effective_end_date;
478: --
479: return l_ben_ptu_ler_rec;

Line 476: l_ben_ptu_ler_rec.effective_start_date := l_person_type_usage.effective_start_date;

472: close csr_person_type_usages;
473: l_ben_ptu_ler_rec.person_id := l_person_type_usage.person_id;
474: l_ben_ptu_ler_rec.person_type_usage_id := l_person_type_usage.person_type_usage_id;
475: l_ben_ptu_ler_rec.person_type_id := l_person_type_usage.person_type_id;
476: l_ben_ptu_ler_rec.effective_start_date := l_person_type_usage.effective_start_date;
477: l_ben_ptu_ler_rec.effective_end_date := l_person_type_usage.effective_end_date;
478: --
479: return l_ben_ptu_ler_rec;
480: --

Line 477: l_ben_ptu_ler_rec.effective_end_date := l_person_type_usage.effective_end_date;

473: l_ben_ptu_ler_rec.person_id := l_person_type_usage.person_id;
474: l_ben_ptu_ler_rec.person_type_usage_id := l_person_type_usage.person_type_usage_id;
475: l_ben_ptu_ler_rec.person_type_id := l_person_type_usage.person_type_id;
476: l_ben_ptu_ler_rec.effective_start_date := l_person_type_usage.effective_start_date;
477: l_ben_ptu_ler_rec.effective_end_date := l_person_type_usage.effective_end_date;
478: --
479: return l_ben_ptu_ler_rec;
480: --
481: end get_ben_ptu_ler_rec;

Line 479: return l_ben_ptu_ler_rec;

475: l_ben_ptu_ler_rec.person_type_id := l_person_type_usage.person_type_id;
476: l_ben_ptu_ler_rec.effective_start_date := l_person_type_usage.effective_start_date;
477: l_ben_ptu_ler_rec.effective_end_date := l_person_type_usage.effective_end_date;
478: --
479: return l_ben_ptu_ler_rec;
480: --
481: end get_ben_ptu_ler_rec;
482: --
483: -- ----------------------------------------------------------------------------

Line 481: end get_ben_ptu_ler_rec;

477: l_ben_ptu_ler_rec.effective_end_date := l_person_type_usage.effective_end_date;
478: --
479: return l_ben_ptu_ler_rec;
480: --
481: end get_ben_ptu_ler_rec;
482: --
483: -- ----------------------------------------------------------------------------
484: -- |---------------------< benefits_person_type_usage_b >---------------------|
485: -- ----------------------------------------------------------------------------

Line 494: g_old_ben_ptu_ler_rec := get_ben_ptu_ler_rec

490: ) is
491: --
492: begin
493: --
494: g_old_ben_ptu_ler_rec := get_ben_ptu_ler_rec
495: (p_effective_date => p_effective_date
496: ,p_person_type_usage_id => p_person_type_usage_id
497: );
498: --

Line 512: l_old_ben_ptu_ler_rec ben_ptu_ler.g_ptu_ler_rec;

508: ) is
509: --
510: -- Declare cursors and local variables
511: --
512: l_old_ben_ptu_ler_rec ben_ptu_ler.g_ptu_ler_rec;
513: l_new_ben_ptu_ler_rec ben_ptu_ler.g_ptu_ler_rec;
514: --
515: begin
516: --

Line 513: l_new_ben_ptu_ler_rec ben_ptu_ler.g_ptu_ler_rec;

509: --
510: -- Declare cursors and local variables
511: --
512: l_old_ben_ptu_ler_rec ben_ptu_ler.g_ptu_ler_rec;
513: l_new_ben_ptu_ler_rec ben_ptu_ler.g_ptu_ler_rec;
514: --
515: begin
516: --
517: l_old_ben_ptu_ler_rec := g_old_ben_ptu_ler_rec;

Line 517: l_old_ben_ptu_ler_rec := g_old_ben_ptu_ler_rec;

513: l_new_ben_ptu_ler_rec ben_ptu_ler.g_ptu_ler_rec;
514: --
515: begin
516: --
517: l_old_ben_ptu_ler_rec := g_old_ben_ptu_ler_rec;
518: l_new_ben_ptu_ler_rec := get_ben_ptu_ler_rec
519: (p_effective_date => p_effective_date
520: ,p_person_type_usage_id => p_person_type_usage_id
521: );

Line 518: l_new_ben_ptu_ler_rec := get_ben_ptu_ler_rec

514: --
515: begin
516: --
517: l_old_ben_ptu_ler_rec := g_old_ben_ptu_ler_rec;
518: l_new_ben_ptu_ler_rec := get_ben_ptu_ler_rec
519: (p_effective_date => p_effective_date
520: ,p_person_type_usage_id => p_person_type_usage_id
521: );
522: --

Line 523: ben_ptu_ler.ler_chk

519: (p_effective_date => p_effective_date
520: ,p_person_type_usage_id => p_person_type_usage_id
521: );
522: --
523: ben_ptu_ler.ler_chk
524: (p_old => l_old_ben_ptu_ler_rec
525: ,p_new => l_new_ben_ptu_ler_rec
526: ,p_effective_date => p_effective_date
527: );

Line 524: (p_old => l_old_ben_ptu_ler_rec

520: ,p_person_type_usage_id => p_person_type_usage_id
521: );
522: --
523: ben_ptu_ler.ler_chk
524: (p_old => l_old_ben_ptu_ler_rec
525: ,p_new => l_new_ben_ptu_ler_rec
526: ,p_effective_date => p_effective_date
527: );
528: --

Line 525: ,p_new => l_new_ben_ptu_ler_rec

521: );
522: --
523: ben_ptu_ler.ler_chk
524: (p_old => l_old_ben_ptu_ler_rec
525: ,p_new => l_new_ben_ptu_ler_rec
526: ,p_effective_date => p_effective_date
527: );
528: --
529: end benefits_person_type_usage_a;

Line 1364: l_old ben_ptu_ler.g_ptu_ler_rec;

1360: and p1.person_id=p_person_id);
1361: --
1362: l_prev_other_row csr_prev_other_row%rowtype;
1363: l_ptu_prev_row csr_ptu_prev_row%rowtype;
1364: l_old ben_ptu_ler.g_ptu_ler_rec;
1365: l_new ben_ptu_ler.g_ptu_ler_rec;
1366: --
1367: l_c1 c1%rowtype;
1368: l_rows_found boolean := false;

Line 1365: l_new ben_ptu_ler.g_ptu_ler_rec;

1361: --
1362: l_prev_other_row csr_prev_other_row%rowtype;
1363: l_ptu_prev_row csr_ptu_prev_row%rowtype;
1364: l_old ben_ptu_ler.g_ptu_ler_rec;
1365: l_new ben_ptu_ler.g_ptu_ler_rec;
1366: --
1367: l_c1 c1%rowtype;
1368: l_rows_found boolean := false;
1369: --

Line 1504: ben_ptu_ler.ler_chk(p_old => l_old,

1500: l_new.person_type_id := l_c1.person_type_id;
1501: l_new.effective_start_date := p_date_start;
1502: l_new.effective_end_date := l_c1.effective_end_date;
1503: --
1504: ben_ptu_ler.ler_chk(p_old => l_old,
1505: p_new => l_new,
1506: p_effective_date => p_date_start);
1507: --
1508: end if;