PACKAGE: APPS.PER_DIF_STMT_REPORT

Source

1 PACKAGE PER_DIF_STMT_REPORT AS
2 /* $Header: perfrdif.pkh 120.0 2006/04/11 23:12:19 nmuthusa noship $ */
3 --
4 -- Declare XML table
5 TYPE xml_rec IS RECORD(
6 tag_name VARCHAR2(1000),
7 tag_value VARCHAR2(1000));
8 
9 TYPE xml_table_type IS TABLE OF xml_rec INDEX BY BINARY_INTEGER;
10 xml_table xml_table_type;
11 --
12 -- Main procedure for building XML string
13 PROCEDURE dif_main_fill_table(p_business_group_id NUMBER,
14                               p_estab_id          NUMBER DEFAULT NULL,
15 			      p_accrual_plan_id   NUMBER ,
16 			      p_start_year        VARCHAR2,
17 			      p_start_month       NUMBER,
18 			      p_date_from         VARCHAR2,
19 			      p_end_year          VARCHAR2,
20 			      p_end_month         NUMBER,
21 			      p_date_to           VARCHAR2,
22 			      p_emp_id            NUMBER DEFAULT NULL,
23 			      p_sort_order        VARCHAR2,
24 			      p_template_name     VARCHAR2,
25 			      p_xml    OUT NOCOPY CLOB);
26 --
27 -- procedure for fetching employee, estab and accrual details
28 -- for each employee
29 PROCEDURE dif_emp_acc_details(p_business_group_id NUMBER,
30                               p_estab_id          NUMBER ,
31 		              p_accrual_plan_id   NUMBER,
32 	                      p_emp_id            NUMBER,
33 		              p_date_from         DATE,
34 		              p_date_to           DATE);
35 --
36 -- procedure for writing to clob
37 PROCEDURE write_to_clob(p_xfdf_clob out nocopy clob);
38 --
39 END;