1 PACKAGE PAY_HK_AVG_PAY AS
2 /* $Header: pyhkavgpay.pkh 120.0 2007/12/14 09:03:57 vamittal noship $ */
3
4 /* Bug 6318006 This function finds the time period start date for dimension _ASG_12MTHS_PREV */
5 FUNCTION TIME_START
6 (
7 p_effective_date IN DATE
8 ,p_assignment_action_id IN NUMBER
9 ) RETURN DATE ;
10
11 /* Bug 6318006
12 This Function will fetch the specified date from element entry of absence element for dimension _ASG_12MTHS_PREV */
13
14 Function SPECIFIED_DATE_ABSENCE
15 ( p_date_earned IN DATE
16 ,p_assignment_id IN NUMBER
17 ) RETURN DATE;
18
19 /* Bug 6318006
20 This Function will fetch the specified date from element entry of Specified Date Element for dimension _ASG_12MTHS_PREV */
21
22 Function SPECIFIED_DATE_ELEMENT
23 ( p_date_earned IN DATE
24 ,p_assignment_id IN NUMBER
25 ) RETURN DATE;
26
27 /* Bug 6318006
28 This Formula Function will fetch the Number of days for dimension _ASG_12MTHS_PREV */
29
30 Function NO_OF_DAYS
31 ( p_assignment_action_id IN NUMBER
32 ) RETURN NUMBER;
33
34 END PAY_HK_AVG_PAY;