PACKAGE: APPS.PAY_NO_ABS_STATISTICS_REPORT

Source

1 PACKAGE PAY_NO_ABS_STATISTICS_REPORT AUTHID CURRENT_USER AS
2 /* $Header: pynoabsr.pkh 120.0.12000000.1 2007/05/22 05:52:44 rajesrin noship $ */
3         TYPE tagdata IS RECORD
4         (
5             TagName VARCHAR2(240),
6             TagValue VARCHAR2(240)
7         );
8         TYPE ttagdata
9         IS TABLE OF tagdata
10         INDEX BY BINARY_INTEGER;
11         gplsqltable ttagdata;
12 
13         TYPE AbsenceRec IS RECORD(initialized varchar2(1),
14 		              quatertag varchar2(30),
15 		              possible_working_days 	NUMBER,
16 		              sick_1_3_ocr_sc 		NUMBER,
17 		              sick_1_3_days_sc 		NUMBER,
18 		              sick_1_3_ocr_dc 		NUMBER,
19 		              sick_1_3_days_dc 		NUMBER,
20 		              sick_4_16_ocrs 		NUMBER,
21 		              sick_4_16_days 		NUMBER,
22 		              sick_more_16_ocrs 	NUMBER,
23 		              sick_more_16_days 	NUMBER,
24 		              sick_more_8w_ocrs 	NUMBER,
25 		              sick_more_8w_days 	NUMBER,
26 		              cms_abs_ocrs		NUMBER,
27 		              cms_abs_days		NUMBER,
28 		              parental_abs_ocrs		NUMBER,
29 		              parental_abs_days		NUMBER,
30 		              other_abs_ocrs		NUMBER,
31 		              other_abs_days		NUMBER,
32 		              other_abs_paid_ocrs	NUMBER,
33 		              other_abs_paid_days	NUMBER
34 		              );
35 
36 	TYPE abstab IS TABLE OF AbsenceRec INDEX BY BINARY_INTEGER;
37 
38 
39   function get_archive_payroll_action_id(p_payroll_action_id in number)
40   return number;
41        PROCEDURE get_data (
42              		p_business_group_id  IN VARCHAR2, --temp removal ..shoud be added for G
43           		p_payroll_action_id  IN VARCHAR2,
44       			p_template_name      IN VARCHAR2,
45       			p_xml                OUT NOCOPY CLOB
46 			);
47 
48 	PROCEDURE WritetoCLOB(p_xfdf_clob out nocopy CLOB);
49 
50 
51 END PAY_NO_ABS_STATISTICS_REPORT;