1 package ben_global_functions AUTHID CURRENT_USER as
2 /* $Header: beglbfnc.pkh 120.1 2006/05/02 07:08:49 rbingi noship $*/
3 --
4 /*
5 +==============================================================================+
6 | Copyright (c) 1997 Oracle Corporation |
7 | Redwood Shores, California, USA |
8 | All rights reserved. |
9 +==============================================================================+
10 --
11 History
12 Version Date Who What?
13 --------- --------- ---------- --------------------------------------------
14 115.0 18-Dec-00 mhoyes Created.
15 115.3 02-May-06 rbingi Added opt_id to get_par id procs
16 Added proc get_vpf_par_pgm_r_pl_id
17 -----------------------------------------------------------------------------
18 */
19 --
20 ------------------------------------------------------------------------
21 -- DELETE CACHED DATA
22 ------------------------------------------------------------------------
23 function is_plnip_related
24 (p_pl_id in number
25 ,p_oipl_id in number
26 )
27 return varchar2;
28 --
29 function get_par_plnip_id
30 (p_pl_id in number
31 ,p_oipl_id in number
32 ,p_opt_id in number default null
33 )
34 return number;
35 --
36 function get_par_pgm_id
37 (p_pgm_id in number
38 ,p_ptip_id in number
39 ,p_pl_id in number
40 ,p_plip_id in number
41 ,p_oipl_id in number
42 ,p_oiplip_id in number
43 ,p_opt_id in number default null
44 )
45 return number;
46 --
47 function is_monetary_abr
48 (p_acty_base_rt_id in number
49 )
50 return varchar2;
51 --
52 function get_abr_par_pgm_id
53 (p_acty_base_rt_id in number
54 )
55 return number;
56 --
57 function get_abr_par_plnip_id
58 (p_acty_base_rt_id in number
59 )
60 return number;
61 --
62 function get_ecr_abrpar_pgm_id
63 (p_enrt_rt_id in number
64 )
65 return number;
66 --
67 function round_monetary_value
68 (p_rnd_code_type in varchar2
69 ,p_rounding_cd in varchar2
70 ,p_rounding_rl in varchar2
71 ,p_effective_date in date
72 ,p_monetary_value in number
73 )
74 return number;
75 --
76 function get_vpf_par_pgm_r_pl_id
77 (p_vrbl_rt_prfl_id in number,
78 p_vpf_usg_cd in varchar2,
79 p_pgm_nip_lvl in varchar2
80 )
81 return number;
82 --
83 END ben_global_functions;