PACKAGE: APPS.HR_PERSON_FLEX_LOGIC

Source

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;