1 PACKAGE HR_PERSON_FLEX_LOGIC AUTHID CURRENT_USER AS
2 /* $Header: hrperlog.pkh 115.10 2003/07/07 18:21:05 asahay noship $ */
3
4 FF_Not_Compiled Exception;
5 FF_Not_Exist Exception;
6
7 FUNCTION GetABV
8 ( p_ABV_formula_id IN NUMBER
9 , p_assignment_id IN NUMBER
10 , p_effective_date IN DATE
11 , p_session_date IN DATE)
12 RETURN NUMBER ;
13
14 FUNCTION GetABV
15 ( p_ABV IN VARCHAR2
16 , p_assignment_id IN NUMBER
17 , p_session_date IN DATE default sysdate )
18 RETURN NUMBER ;
19
20 FUNCTION GetABV
21 ( p_ABV_formula_id IN NUMBER
22 , p_ABV IN VARCHAR2
23 , p_assignment_id IN NUMBER
24 , p_effective_date IN DATE
25 , p_session_date IN DATE )
26 RETURN NUMBER ;
27
28 Function GetAsgWorkerType
29 (p_AsgWorkerType_formula_id IN NUMBER
30 ,p_assignment_id IN NUMBER
31 ,p_effective_date IN DATE
32 ,p_session_date IN DATE
33 ) RETURN VARCHAR2 ;
34
35 FUNCTION GetTermTypeFormula
36 (p_business_group_id IN NUMBER)
37 RETURN NUMBER;
38
39 FUNCTION GetTermType
40 ( p_term_formula_id IN NUMBER
41 , p_leaving_reason IN VARCHAR2
42 , p_session_date IN DATE)
43 RETURN VARCHAR2 ;
44
45 FUNCTION GetJobCategory
46 ( p_job_id IN NUMBER
47 , p_job_category IN VARCHAR2)
48 RETURN VARCHAR2 ;
49
50 PROCEDURE GetMovementCategory(
51 p_organization_id IN NUMBER
52 ,p_assignment_id IN NUMBER
53 ,p_period_start_date IN DATE
54 ,p_period_end_date IN DATE
55 ,p_movement_type IN VARCHAR2
56 ,p_assignment_type IN VARCHAR2 default 'E'
57 ,p_movement_category OUT NOCOPY VARCHAR2
58 );
59
60 FUNCTION GetCurNH
61 ( p_organization_id IN NUMBER
62 , p_assignment_id IN VARCHAR2
63 , p_report_date IN DATE)
64 RETURN VARCHAR2 ;
65
66 FUNCTION GetCurNHNew
67 ( p_organization_id IN NUMBER
68 , p_assignment_id IN VARCHAR2
69 , p_assignment_type IN VARCHAR2
70 , p_cur_date_from IN DATE
71 , p_cur_date_to IN DATE)
72 RETURN VARCHAR2 ;
73
74
75 FUNCTION GetOrgAliasName
76 (P_ORGANIZATION_ID IN NUMBER,
77 P_REPORT_DATE IN DATE)
78 RETURN VARCHAR2 ;
79
80
81 PROCEDURE Raise_FF_Not_Exist
82 ( p_formula_id in Number );
83
84 PROCEDURE Raise_FF_Not_Compiled
85 ( p_formula_id in Number );
86
87 FUNCTION GetFormulaTypeID
88 (p_formula_type_name IN VARCHAR2)
89 RETURN NUMBER;
90
91 FUNCTION GetFormulaID
92 (p_business_group_id IN NUMBER
93 ,p_formula_name IN VARCHAR2
94 ,p_formula_type IN VARCHAR2 )
95 RETURN NUMBER;
96
97 FUNCTION HeadCountForCWK
98 RETURN VARCHAR2;
99
100 END HR_PERSON_FLEX_LOGIC;