DBA Data[Home] [Help]

APPS.BEN_DERIVE_PART_AND_RATE_FACTS dependencies on BEN_DERIVE_PART_AND_RATE_FACTS

Line 1: PACKAGE BODY ben_derive_part_and_rate_facts AS

1: PACKAGE BODY ben_derive_part_and_rate_facts AS
2: /* $Header: bendrpar.pkb 120.8 2009/05/01 18:35:07 stee ship $ */
3: /*
4: +==============================================================================+
5: | Copyright (c) 1997 Oracle Corporation |

Line 562: g_package VARCHAR2(80) := 'ben_derive_part_and_rate_facts';

558: */
559: --------------------------------------------------------------------------------
560: --
561: --
562: g_package VARCHAR2(80) := 'ben_derive_part_and_rate_facts';
563: g_debug boolean := hr_utility.debug_enabled;
564: g_rec benutils.g_batch_ler_rec;
565: g_lf_evt_exists boolean;
566: --

Line 665: IF (NVL(ben_derive_part_and_rate_facts.g_temp_ler_id,p_ler_id) <> p_ler_id ) OR

661: -- Test to make sure we are only creating life events of a
662: -- certain type. This is specifically for temporal mode.
663: -- Dont trigger Potential if called from Unrestricted U,W,M,I,P,A
664: --
665: IF (NVL(ben_derive_part_and_rate_facts.g_temp_ler_id,p_ler_id) <> p_ler_id ) OR
666: (NVL(g_pgm_typ_cd, 'KKKK') = 'GSP' and
667: (NVL(ben_derive_part_and_rate_facts.g_temp_ler_id,g_gsp_ler_id) <> g_gsp_ler_id )) OR
668: (NVL(ben_derive_part_and_rate_facts.g_no_ptnl_ler_id,p_ler_id) <> p_ler_id )
669: THEN

Line 667: (NVL(ben_derive_part_and_rate_facts.g_temp_ler_id,g_gsp_ler_id) <> g_gsp_ler_id )) OR

663: -- Dont trigger Potential if called from Unrestricted U,W,M,I,P,A
664: --
665: IF (NVL(ben_derive_part_and_rate_facts.g_temp_ler_id,p_ler_id) <> p_ler_id ) OR
666: (NVL(g_pgm_typ_cd, 'KKKK') = 'GSP' and
667: (NVL(ben_derive_part_and_rate_facts.g_temp_ler_id,g_gsp_ler_id) <> g_gsp_ler_id )) OR
668: (NVL(ben_derive_part_and_rate_facts.g_no_ptnl_ler_id,p_ler_id) <> p_ler_id )
669: THEN
670: --
671: hr_utility.set_location('Dont trigger Potential if called from Unrestricted U,W,M,I,P,A.',11);

Line 668: (NVL(ben_derive_part_and_rate_facts.g_no_ptnl_ler_id,p_ler_id) <> p_ler_id )

664: --
665: IF (NVL(ben_derive_part_and_rate_facts.g_temp_ler_id,p_ler_id) <> p_ler_id ) OR
666: (NVL(g_pgm_typ_cd, 'KKKK') = 'GSP' and
667: (NVL(ben_derive_part_and_rate_facts.g_temp_ler_id,g_gsp_ler_id) <> g_gsp_ler_id )) OR
668: (NVL(ben_derive_part_and_rate_facts.g_no_ptnl_ler_id,p_ler_id) <> p_ler_id )
669: THEN
670: --
671: hr_utility.set_location('Dont trigger Potential if called from Unrestricted U,W,M,I,P,A.',11);
672: RETURN TRUE;

Line 975: l_epo_row ben_derive_part_and_rate_facts.g_cache_structure;

971: --
972: l_pl_id NUMBER;
973: l_opt_id NUMBER;
974: l_oipl_rec ben_oipl_f%ROWTYPE;
975: l_epo_row ben_derive_part_and_rate_facts.g_cache_structure;
976: --
977: -- Cursor to get eligible option details
978: --
979: CURSOR c_elig_per_opt(

Line 1870: IF (NVL(ben_derive_part_and_rate_facts.g_temp_ler_id,p_ler_id) <> p_ler_id ) OR

1866: --
1867: -- GRADE/STEP : Added or condition for GSP
1868: -- Dont trigget Potential if called from Unrestricted U,W,M,I,P,A
1869: --
1870: IF (NVL(ben_derive_part_and_rate_facts.g_temp_ler_id,p_ler_id) <> p_ler_id ) OR
1871: (NVL(g_pgm_typ_cd, 'KKKK') = 'GSP' and
1872: (NVL(ben_derive_part_and_rate_facts.g_temp_ler_id,g_gsp_ler_id) <> g_gsp_ler_id )) OR
1873: (NVL(ben_derive_part_and_rate_facts.g_no_ptnl_ler_id,p_ler_id) <> p_ler_id )
1874: THEN

Line 1872: (NVL(ben_derive_part_and_rate_facts.g_temp_ler_id,g_gsp_ler_id) <> g_gsp_ler_id )) OR

1868: -- Dont trigget Potential if called from Unrestricted U,W,M,I,P,A
1869: --
1870: IF (NVL(ben_derive_part_and_rate_facts.g_temp_ler_id,p_ler_id) <> p_ler_id ) OR
1871: (NVL(g_pgm_typ_cd, 'KKKK') = 'GSP' and
1872: (NVL(ben_derive_part_and_rate_facts.g_temp_ler_id,g_gsp_ler_id) <> g_gsp_ler_id )) OR
1873: (NVL(ben_derive_part_and_rate_facts.g_no_ptnl_ler_id,p_ler_id) <> p_ler_id )
1874: THEN
1875: --
1876: -- We are creating life events of this type.

Line 1873: (NVL(ben_derive_part_and_rate_facts.g_no_ptnl_ler_id,p_ler_id) <> p_ler_id )

1869: --
1870: IF (NVL(ben_derive_part_and_rate_facts.g_temp_ler_id,p_ler_id) <> p_ler_id ) OR
1871: (NVL(g_pgm_typ_cd, 'KKKK') = 'GSP' and
1872: (NVL(ben_derive_part_and_rate_facts.g_temp_ler_id,g_gsp_ler_id) <> g_gsp_ler_id )) OR
1873: (NVL(ben_derive_part_and_rate_facts.g_no_ptnl_ler_id,p_ler_id) <> p_ler_id )
1874: THEN
1875: --
1876: -- We are creating life events of this type.
1877: --

Line 11280: END ben_derive_part_and_rate_facts;

11276: hr_utility.set_location('Leaving ' || l_package,10);
11277: end if;
11278: end set_taxunit_context ;
11279: --
11280: END ben_derive_part_and_rate_facts;