[Home] [Help]
PACKAGE: APPS.PAY_NL_LSS_FUNCTIONS
Source
1 Package pay_nl_lss_functions AUTHID CURRENT_USER as
2 /* $Header: pynllssf.pkh 120.1 2007/04/11 04:58:12 rlingama noship $ */
3
4
5 -- ----------------------------------------------------------------------------
6 -- |---------------------< Get_Day_of_Week >--------------------------|
7 -- ----------------------------------------------------------------------------
8 --
9 Function Get_Day_of_Week(p_date date)
10 RETURN NUMBER;
11
12 -- ----------------------------------------------------------------------------
13 -- |-------------------------< prorate_amount >-------------------------------|
14 -- ----------------------------------------------------------------------------
15 --
16 Function Get_Wage_Days(p_start_date date
17 ,p_end_date date)
18 RETURN NUMBER;
19
20 -- ----------------------------------------------------------------------------
21 -- |--------------------------< Get_Prorate_Amount >---------------------------|
22 -- ----------------------------------------------------------------------------
23 --
24 Function Get_Prorate_Amount(p_assignment_id IN NUMBER,
25 p_business_group IN NUMBER,
26 p_application_date IN DATE,
27 p_period_start_date IN DATE,
28 p_period_end_date IN DATE,
29 p_pay_periods_per_year IN NUMBER,
30 p_amount IN OUT NOCOPY NUMBER)
31 RETURN NUMBER ;
32
33 -- ----------------------------------------------------------------------------
34 -- |-----------------------< Get_Prev_Yr_Sal >-----------------------------|
35 -- ----------------------------------------------------------------------------
36 --
37
38 FUNCTION Get_Previous_Year_Sal (p_assignment_id IN NUMBER,
39 p_business_group IN NUMBER,
40 p_date_earned IN DATE,
41 p_previous_er_column_6 IN NUMBER,
42 p_prev_year_sal OUT NOCOPY NUMBER,
43 p_error_msg OUT NOCOPY VARCHAR2,
44 p_opt_num_in IN NUMBER DEFAULT 0,
45 p_opt_date_in IN DATE DEFAULT NULL)
46
47 RETURN NUMBER;
48
49 -- ----------------------------------------------------------------------------
50 -- |--------------------------< Get_Or_Life_Savings_Basis >-------------------|
51 -- ----------------------------------------------------------------------------
52 Function Get_Or_Life_Savings_Basis
53 (p_assignment_id IN NUMBER,
54 p_business_group IN NUMBER,
55 p_date_earned IN DATE,
56 p_override_basis OUT NOCOPY NUMBER,
57 p_error_message OUT NOCOPY VARCHAR)
58
59 RETURN NUMBER ;
60
61 -- ----------------------------------------------------------------------------
62 -- |--------------------------< Get_LCLD_Limit >-------------------|
63 -- ----------------------------------------------------------------------------
64
65 FUNCTION Get_LCLD_Limit ( p_date_earned IN DATE,
66 p_assignment_id IN NUMBER,
67 p_num_saved_yrs IN Number,
68 p_lcld_limit IN OUT NOCOPY NUMBER,
69 p_error_msg IN OUT NOCOPY VARCHAR2)
70 RETURN NUMBER;
71
72
73 END pay_nl_lss_functions;
74 --