1 PACKAGE WIP_BIS_COMMON AUTHID CURRENT_USER AS
2 /* $Header: wipbcoms.pls 120.1 2011/08/08 17:35:02 hliew ship $ */
3
4
5 /* Public Procedures */
6
7 FUNCTION GET_SEGMENT( str IN VARCHAR2,
8 delim IN VARCHAR2,
9 segment_num IN NUMBER ) return VARCHAR2;
10
11 function Avg_Employee_Num
12 (p_acct_period_id IN NUMBER,
13 p_organization_id IN NUMBER)
14 return NUMBER ;
15
16
17 function get_Legal_Entity return NUMBER ;
18
19 procedure set_Legal_Entity(p_legal_Entity in NUMBER);
20
21 /*Fix bug 12805996: Commented out the following function due to DBI obsolescence
22 function get_Period_Target
23 (p_calendar IN VARCHAR2,
24 p_period_value IN VARCHAR2,
25 p_organization_id IN NUMBER,
26 p_indicator IN VARCHAR2)
27 return NUMBER ;
28 */
29
30 PRAGMA RESTRICT_REFERENCES (get_Legal_Entity, WNDS, WNPS);
31 /*Fix bug 12805996: Commented out the following function due to DBI obsolescence*/
32 --PRAGMA RESTRICT_REFERENCES (get_Period_Target, WNDS, WNPS);
33
34
35 END WIP_BIS_COMMON ;