DBA Data[Home] [Help]

PACKAGE: APPS.PAY_COSTING_SUMMARY_X_REP_PKG

Source


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;