PACKAGE: APPS.PAY_IE_P35

Source

1 PACKAGE PAY_IE_P35 AUTHID CURRENT_USER AS
2 /* $Header: pyiep35x.pkh 120.7 2008/08/22 11:23:41 rsahai ship $ */
3 
4 level_cnt NUMBER;
5 
6 function GET_DEFINED_BALANCE_ID (  p_dimension_name varchar2,
7                                    p_balance_name varchar2
8                                    )
9 return number;
10 
11 
12 FUNCTION  get_parameter(p_payroll_action_id IN  NUMBER,
13                          p_token_name        IN  VARCHAR2) RETURN VARCHAR2;
14 
15 FUNCTION get_initial_class (p_max_action_id in NUMBER,
16                             l_segment4  in number,
17                             p_ppsn_override IN VARCHAR2) RETURN VARCHAR2; --6633719
18 
19 FUNCTION get_second_class (p_assignment_id in NUMBER) RETURN VARCHAR2;
20 
21 FUNCTION get_p60_second_class (p_assignment_id in NUMBER) RETURN VARCHAR2;
22 
23 FUNCTION get_third_class (p_assignment_id in NUMBER) RETURN VARCHAR2;
24 
25 FUNCTION get_fourth_class (p_assignment_id in NUMBER) RETURN VARCHAR2;
26 
27 FUNCTION get_fifth_class (p_assignment_id in NUMBER) RETURN VARCHAR2;
28 
29 FUNCTION weeks_at_initial_class (p_assignment_id in NUMBER,
30 					   l_segment4  in number) RETURN NUMBER;
31 FUNCTION weeks_at_second_class (p_assignment_id in NUMBER,
32 					  l_segment4  in number) RETURN NUMBER;
33 FUNCTION weeks_at_third_class (p_assignment_id in NUMBER,
34 					 l_segment4  in number) RETURN NUMBER;
35 FUNCTION weeks_at_fourth_class (p_assignment_id in NUMBER,
36 					  l_segment4  in number) RETURN NUMBER;
37 FUNCTION weeks_at_fifth_class (p_assignment_id in NUMBER,
38 					  l_segment4  in number) RETURN NUMBER;
39 
40 FUNCTION get_prsi_weeks (l_class in varchar2,
41 				 l_segment4  in number) RETURN NUMBER;
42 
43 FUNCTION get_total_insurable_weeks (p_person_id in NUMBER
44 						,p_tax_unit_id in NUMBER
45 						,p_assignment_action_id IN NUMBER
46 						,p_Act_Context_id  number default NULL  --6633719
47 						,p_Act_Context_value varchar2 default NULL --6633719
48 						,p_dimension_name varchar2 default '_PER_PAYE_REF_YTD' --6633719
49 						,p_ppsn_override VARCHAR2 default NULL) RETURN NUMBER; --6633719
50 
51 -- Bug 2979713 - PRSI Context Balances (below 2 functions added)
52 
53 FUNCTION get_start_date RETURN DATE;
54 
55 FUNCTION get_end_date RETURN DATE;
56 
57 /*Added for bug fix 3815830*/
58 FUNCTION replace_xml_symbols(p_string IN VARCHAR2) RETURN VARCHAR2;
59 
60 PROCEDURE range_code(
61                 p_payroll_action_id     IN  NUMBER,
62                 sqlstr                OUT NOCOPY VARCHAR2);
63 --
64 PROCEDURE action_creation(
65                           pactid    IN NUMBER,
66                           stperson  IN NUMBER,
67                           endperson IN NUMBER,
68                           chunk     IN NUMBER);
69 
70 Procedure archive_code  (p_assactid       IN NUMBER
71 				,p_effective_date IN DATE);
72 
73 Procedure deinit_code (p_payroll_action_id IN NUMBER);
74 
75 /* Function to check the override ppsn */ --6633719
76 FUNCTION OVERRIDE_PPSN(asg_id NUMBER) RETURN VARCHAR2;
77 
78 END pay_ie_p35;