1 PACKAGE pay_nl_ww_adjustments AS
2 /* $Header: pynlsicp.pkh 120.1 2006/09/22 13:33:32 niljain noship $ */
3
4 --------------------------------------------------------------
5 -- Global PL/SQL table to hold SI Providers information
6 --------------------------------------------------------------
7
8 TYPE r_si_provider IS RECORD
9 (asg_act_id NUMBER,
10 si_type VARCHAR2(10),
11 si_provider_id NUMBER,
12 processed_flag VARCHAR2(10));
13
14 TYPE t_si_provider IS TABLE OF r_si_provider INDEX BY BINARY_INTEGER;
15 t1 t_si_provider;
16
17 last_asg_action_id NUMBER; /*Version 115.1 change */
18 --------------------------------------------------------------
19 -- Function for getting contribution percentages. Returns
20 -- SI Provider for next execution of Adjustment formula
21 --------------------------------------------------------------
22
23 FUNCTION Get_Adjustment_details
24 (p_assignment_action_id IN NUMBER,
25 p_date_earned IN DATE,
26 p_source_text IN VARCHAR2,
27 p_source_text2 IN VARCHAR2,
28 p_age IN NUMBER,
29 p_ee_cont_perc IN OUT NOCOPY NUMBER,
30 p_er_cont_perc IN OUT NOCOPY NUMBER,
31 p_si_type_name OUT NOCOPY VARCHAR2)
32 RETURN VARCHAR2;
33
34 --------------------------------------------------------------
35 -- Procedure to Populate PL/SQL table
36 --------------------------------------------------------------
37
38 PROCEDURE populate_pl_sql_table
39 (p_assignment_action_id IN NUMBER,
40 p_date_earned IN DATE,
41 p_si_type IN VARCHAR2,
42 p_si_provider IN VARCHAR2) ;
43
44 --------------------------------------------------------------
45 --Function for getting Basis Calculation Rule
46 --------------------------------------------------------------
47 FUNCTION Get_Basis_calc_Rule
48 ( p_source_text IN VARCHAR2,
49 p_source_text2 IN VARCHAR2,
50 p_date_earned IN DATE)
51 RETURN NUMBER;
52
53 --------------------------------------------------------------
54 --Function for getting Whether EE cont. is Gross or Net
55 --------------------------------------------------------------
56 FUNCTION Get_EE_Cont_Gross_Net
57 (p_source_text IN VARCHAR2 ,
58 p_source_text2 IN VARCHAR2,
59 p_date_earned IN DATE)
60 RETURN VARCHAR2;
61
62 --------------------------------------------------------------
63 --Function for getting number of processed SI Providers
64 --------------------------------------------------------------
65 FUNCTION get_si_prov_count
66 (p_assignment_id IN NUMBER,
67 p_assignment_action_id IN NUMBER)
68 RETURN NUMBER;
69
70 END;