DBA Data[Home] [Help]

PACKAGE: APPS.PAY_HK_AVG_PAY

Source


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;