PACKAGE: APPS.PAY_NO_ARCHIVE_ABSENCE

Source

1 PACKAGE PAY_NO_ARCHIVE_ABSENCE AUTHID CURRENT_USER as
2 /* $Header: pynoabsa.pkh 120.0.12000000.1 2007/05/22 05:29:41 rajesrin noship $ */
3 	TYPE AbsenceRec IS RECORD(initialized varchar2(1),
4 	              quater varchar2(2),
5 	              sick_1_3_ocr_sc 		NUMBER,
6 	              sick_1_3_days_sc 		NUMBER,
7 	              sick_1_3_ocr_dc 		NUMBER,
8 	              sick_1_3_days_dc 		NUMBER,
9 	              sick_4_16_ocrs 		NUMBER,
10 	              sick_4_16_days 		NUMBER,
11 	              sick_more_16_ocrs 	NUMBER,
12 	              sick_more_16_days 	NUMBER,
13 	              sick_8_weeks_ocr  	NUMBER,
14 	              sick_8_weeks_days 	NUMBER,
15 	              cms_abs_ocrs		NUMBER,
16 	              cms_abs_days		NUMBER,
17 	              parental_abs_ocrs		NUMBER,
18 	              parental_abs_days		NUMBER,
19 	              other_abs_ocrs		NUMBER,
20 	              other_abs_days		NUMBER,
21 	              other_abs_paid_ocrs	NUMBER,
22 	              other_abs_paid_days	NUMBER
23 	              );
24 
25 	TYPE abstab IS TABLE OF AbsenceRec INDEX BY BINARY_INTEGER;
26 	absmale abstab;
27 	absfemale abstab;
28 
29 
30 	FUNCTION GET_PARAMETER
31 		(p_parameter_string	 IN VARCHAR2
32                 ,p_token				 IN VARCHAR2
33                 ,p_segment_number  IN NUMBER default NULL ) RETURN VARCHAR2;
34 	PROCEDURE GET_ALL_PARAMETERS
35 		(p_payroll_action_id	IN   	    NUMBER
36 		,p_business_group_id    OUT  NOCOPY NUMBER
37 		,p_legal_employer_id    OUT  NOCOPY NUMBER
38 		,p_start_date           OUT  NOCOPY DATE
39 		,p_end_date             OUT  NOCOPY DATE
40 		,p_archive		OUT NOCOPY VARCHAR2
41 		,p_effective_date       OUT  NOCOPY DATE
42 		);
43 	PROCEDURE RANGE_CODE
44 		(p_payroll_action_id	IN    NUMBER
45                 ,p_sql				OUT   NOCOPY VARCHAR2) ;
46 	PROCEDURE ASSIGNMENT_ACTION_CODE
47 		(p_payroll_action_id	IN NUMBER
48                 ,p_start_person           IN NUMBER
49                 ,p_end_person            IN NUMBER
50                 ,p_chunk			IN NUMBER);
51 	PROCEDURE INITIALIZATION_CODE
52 		(p_payroll_action_id	IN NUMBER);
53 	PROCEDURE ARCHIVE_CODE
54 		(p_assignment_action_id		IN NUMBER
55                 ,p_effective_date		IN DATE);
56 
57        PROCEDURE DEINITIALIZE_CODE(p_payroll_action_id IN NUMBER);
58 
59 END PAY_NO_ARCHIVE_ABSENCE;