1 PACKAGE pay_costing_summary_x_rep_pkg AS
2 /* $Header: pyprxcsr.pkh 120.0 2005/05/29 07:53:43 appldev noship $ */
3
4 /***************************************************************
5 ** Procedure: costing_summary **
6 ** **
7 ** Purpose : This procedure is the one that is called from**
8 ** the concurrent program.It's going to populate**
9 ** the report output in XML format into the **
10 ** global variable and then to the out variable.**
11 *************************************************************/
12
13 PROCEDURE costing_summary (p_xml OUT NOCOPY CLOB
14 ,p_business_group_id IN NUMBER
15 ,p_start_date IN VARCHAR2
16 ,p_dummy_start IN VARCHAR2
17 ,p_end_date IN VARCHAR2
18 ,p_costing IN VARCHAR2
19 ,p_dummy_costing IN VARCHAR2
20 ,p_payroll_id IN NUMBER
21 ,p_consolidation_set_id IN NUMBER
22 ,p_tax_unit_id IN NUMBER
23 ,p_cost_type IN VARCHAR2
24 ,p_sort_order1 IN VARCHAR2
25 ,p_sort_order2 IN VARCHAR2
26 ,p_template_name IN VARCHAR2
27 );
28
29 /**************************************************************
30 ** PL/SQL table of records to store Costing Segment Label and
31 ** Application Column used.
32 ***************************************************************/
33 TYPE costing_rec IS RECORD (segment_label VARCHAR2(100),
34 column_name VARCHAR2(100));
35 TYPE costing_tab IS TABLE OF costing_rec INDEX BY BINARY_INTEGER;
36
37 END pay_costing_summary_x_rep_pkg;