1 package ben_efc_functions AUTHID CURRENT_USER as
2 /* $Header: beefcfnc.pkh 115.8 2002/12/31 23:58:32 mmudigon 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.1 31-Jan-01 mhoyes Added more functions.
16 115.2 06-Apr-01 mhoyes Enhanced for Patchset D.
17 115.3 12-Jul-01 mhoyes Enhanced for Patchset E.
18 115.5 26-Jul-01 mhoyes Enhanced for Patchset E+ patch.
19 115.6 26-Sep-01 mhoyes Enhanced for Patchset G.
20 115.7 26-Sep-01 mhoyes Enhanced for Patchset G.
21 115.8 31-Dec-02 mmudigon NOCOPY
22 -----------------------------------------------------------------------------
23 */
24 --
25 type g_attach_df_counts is record
26 (epa_count pls_integer
27 ,abr_count pls_integer
28 ,apr_count pls_integer
29 ,ccm_count pls_integer
30 ,noattdf_count pls_integer
31 );
32 --
33 g_epe_count pls_integer;
34 g_enb_count pls_integer;
35 g_epeenbnull_count pls_integer;
36 g_noepedets_count pls_integer;
37 g_noenbdets_count pls_integer;
38 --
39 procedure setup_workers
40 (p_component_name in varchar2
41 ,p_sub_step in varchar2
42 ,p_table_name in varchar2
43 ,p_worker_id in number
44 ,p_total_workers in number
45 --
46 ,p_business_group_id in number default null
47 --
48 ,p_chunk out nocopy varchar2
49 ,p_status out nocopy varchar2
50 ,p_action_id out nocopy number
51 ,p_pk1 out nocopy number
52 ,p_efc_worker_id out nocopy number
53 );
54 --
55 procedure maintain_chunks
56 (p_row_count in out nocopy number
57 ,p_pk1 in number
58 ,p_chunk_size in number
59 ,p_efc_worker_id in number
60 );
61 --
62 procedure conv_check
63 (p_table_name in varchar2
64 ,p_efctable_name in varchar2
65 ,p_tabwhere_clause in varchar2 default null
66 --
67 ,p_bgp_id in number default null
68 ,p_action_id in number default null
69 --
70 ,p_table_sql in varchar2 default null
71 ,p_efctable_sql in varchar2 default null
72 --
73 ,p_tabrow_count out nocopy number
74 ,p_conv_count out nocopy number
75 ,p_unconv_count out nocopy number
76 );
77 --
78 procedure EPEorENB_InitCounts;
79 --
80 procedure EPEorENB_GetEPEDets
81 (p_elig_per_elctbl_chc_id in number default null
82 ,p_enrt_bnft_id in number default null
83 --
84 ,p_currepe_row out nocopy ben_epe_cache.g_pilepe_inst_row
85 );
86 --
87 procedure CompObject_ChkAttachDF
88 (p_coent_scode in varchar2
89 ,p_compobj_id in number default null
90 --
91 ,p_counts out nocopy g_attach_df_counts
92 );
93 --
94 procedure BGP_WriteEFCAction
95 (p_bgp_id in number
96 --
97 ,p_efc_action_id out nocopy number
98 );
99 --
100 procedure BGP_SetupEFCAction
101 (p_bgp_id in number
102 --
103 ,p_efc_action_id out nocopy number
104 );
105 --
106 /*
107 CURSOR gc_currefcact
108 (c_bgp_id in number
109 )
110 IS
111 select act.efc_action_id,
112 act.business_group_id
113 from hr_efc_actions act
114 where act.business_group_id = c_bgp_id
115 and act.efc_action_status = 'P'
116 and act.efc_action_type = 'C'
117 and act.efc_action_id =
118 (select max(act1.efc_action_id)
119 from hr_efc_actions act1
120 where act1.business_group_id = c_bgp_id
121 and act1.efc_action_status = 'P'
122 and act1.efc_action_type = 'C'
123 );
124 --
125 procedure BGP_GetEFCActDetails
126 (p_bgp_id in number
127 --
128 ,p_efcact_dets out nocopy gc_currefcact%rowtype
129 );
130 */
131 --
132 function CurrCode_IsNCU
133 (p_curr_code in varchar2
134 )
135 return boolean;
136 --
137 function UOM_IsCurrency
138 (p_uom in varchar2
139 )
140 return boolean;
141 --
142 procedure CompObject_GetParUom
143 (p_pgm_id in number
144 ,p_ptip_id in number
145 ,p_pl_id in number
146 ,p_plip_id in number
147 ,p_oipl_id in number
148 ,p_oiplip_id in number
149 ,p_eff_date in date
150 --
151 ,p_paruom out nocopy varchar2
152 ,p_faterr_code out nocopy varchar2
153 ,p_faterr_type out nocopy varchar2
154 );
155 --
156 END ben_efc_functions;