DBA Data[Home] [Help]

APPS.BEN_PD_COPY_TO_BEN_ONE dependencies on BEN_PLAN_DESIGN_TXNS_API

Line 2209: l_prefix := BEN_PLAN_DESIGN_TXNS_API.g_pgm_pl_prefix_suffix_text ;

2205: fetch c_find_CPL_name_in_target into l_new_value ;
2206: if c_find_CPL_name_in_target%found then
2207: --
2208: if p_prefix_suffix_cd = 'PREFIX' then
2209: l_prefix := BEN_PLAN_DESIGN_TXNS_API.g_pgm_pl_prefix_suffix_text ;
2210: elsif p_prefix_suffix_cd = 'SUFFIX' then
2211: l_suffix := BEN_PLAN_DESIGN_TXNS_API.g_pgm_pl_prefix_suffix_text ;
2212: else
2213: l_prefix := null ;

Line 2211: l_suffix := BEN_PLAN_DESIGN_TXNS_API.g_pgm_pl_prefix_suffix_text ;

2207: --
2208: if p_prefix_suffix_cd = 'PREFIX' then
2209: l_prefix := BEN_PLAN_DESIGN_TXNS_API.g_pgm_pl_prefix_suffix_text ;
2210: elsif p_prefix_suffix_cd = 'SUFFIX' then
2211: l_suffix := BEN_PLAN_DESIGN_TXNS_API.g_pgm_pl_prefix_suffix_text ;
2212: else
2213: l_prefix := null ;
2214: l_suffix := null ;
2215: end if ;

Line 2712: l_prefix := BEN_PLAN_DESIGN_TXNS_API.g_pgm_pl_prefix_suffix_text ;

2708: fetch c_find_CBP_name_in_target into l_new_value ;
2709: if c_find_CBP_name_in_target%found then
2710: --
2711: if p_prefix_suffix_cd = 'PREFIX' then
2712: l_prefix := BEN_PLAN_DESIGN_TXNS_API.g_pgm_pl_prefix_suffix_text ;
2713: elsif p_prefix_suffix_cd = 'SUFFIX' then
2714: l_suffix := BEN_PLAN_DESIGN_TXNS_API.g_pgm_pl_prefix_suffix_text ;
2715: else
2716: l_prefix := null ;

Line 2714: l_suffix := BEN_PLAN_DESIGN_TXNS_API.g_pgm_pl_prefix_suffix_text ;

2710: --
2711: if p_prefix_suffix_cd = 'PREFIX' then
2712: l_prefix := BEN_PLAN_DESIGN_TXNS_API.g_pgm_pl_prefix_suffix_text ;
2713: elsif p_prefix_suffix_cd = 'SUFFIX' then
2714: l_suffix := BEN_PLAN_DESIGN_TXNS_API.g_pgm_pl_prefix_suffix_text ;
2715: else
2716: l_prefix := null ;
2717: l_suffix := null ;
2718: end if ;

Line 3196: l_prefix := BEN_PLAN_DESIGN_TXNS_API.g_pgm_pl_prefix_suffix_text ;

3192: fetch c_find_CPT_name_in_target into l_new_value ;
3193: if c_find_CPT_name_in_target%found then
3194: --
3195: if p_prefix_suffix_cd = 'PREFIX' then
3196: l_prefix := BEN_PLAN_DESIGN_TXNS_API.g_pgm_pl_prefix_suffix_text ;
3197: elsif p_prefix_suffix_cd = 'SUFFIX' then
3198: l_suffix := BEN_PLAN_DESIGN_TXNS_API.g_pgm_pl_prefix_suffix_text ;
3199: else
3200: l_prefix := null ;

Line 3198: l_suffix := BEN_PLAN_DESIGN_TXNS_API.g_pgm_pl_prefix_suffix_text ;

3194: --
3195: if p_prefix_suffix_cd = 'PREFIX' then
3196: l_prefix := BEN_PLAN_DESIGN_TXNS_API.g_pgm_pl_prefix_suffix_text ;
3197: elsif p_prefix_suffix_cd = 'SUFFIX' then
3198: l_suffix := BEN_PLAN_DESIGN_TXNS_API.g_pgm_pl_prefix_suffix_text ;
3199: else
3200: l_prefix := null ;
3201: l_suffix := null ;
3202: end if ;

Line 14724: if ben_PLAN_DESIGN_TXNS_api.g_pgm_pl_prefix_suffix_text is not null and

14720: -- Derive the prefix - sufix
14721: -- REUSE ENHANCEMENT
14722: --
14723: l_prefix_suffix_text := p_prefix_suffix_text;
14724: if ben_PLAN_DESIGN_TXNS_api.g_pgm_pl_prefix_suffix_text is not null and
14725: r_PLN_unique.information8 = 'PLNIP' then
14726: --
14727: l_prefix_suffix_text := ben_PLAN_DESIGN_TXNS_api.g_pgm_pl_prefix_suffix_text;
14728: --

Line 14727: l_prefix_suffix_text := ben_PLAN_DESIGN_TXNS_api.g_pgm_pl_prefix_suffix_text;

14723: l_prefix_suffix_text := p_prefix_suffix_text;
14724: if ben_PLAN_DESIGN_TXNS_api.g_pgm_pl_prefix_suffix_text is not null and
14725: r_PLN_unique.information8 = 'PLNIP' then
14726: --
14727: l_prefix_suffix_text := ben_PLAN_DESIGN_TXNS_api.g_pgm_pl_prefix_suffix_text;
14728: --
14729: end if;
14730: if p_prefix_suffix_cd = 'PREFIX' then
14731: l_prefix := l_prefix_suffix_text ;

Line 17290: if ben_PLAN_DESIGN_TXNS_api.g_pgm_pl_prefix_suffix_text is not null then

17286: -- REUSE ENHANCEMENT
17287: --
17288: l_prefix_suffix_text := p_prefix_suffix_text;
17289: -- REUSE
17290: if ben_PLAN_DESIGN_TXNS_api.g_pgm_pl_prefix_suffix_text is not null then
17291: --
17292: l_prefix_suffix_text := ben_PLAN_DESIGN_TXNS_api.g_pgm_pl_prefix_suffix_text;
17293: --
17294: end if;

Line 17292: l_prefix_suffix_text := ben_PLAN_DESIGN_TXNS_api.g_pgm_pl_prefix_suffix_text;

17288: l_prefix_suffix_text := p_prefix_suffix_text;
17289: -- REUSE
17290: if ben_PLAN_DESIGN_TXNS_api.g_pgm_pl_prefix_suffix_text is not null then
17291: --
17292: l_prefix_suffix_text := ben_PLAN_DESIGN_TXNS_api.g_pgm_pl_prefix_suffix_text;
17293: --
17294: end if;
17295: --
17296: if ((l_txn_row_type_cd <> 'ELP') and BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PGM'))then