1 PACKAGE pay_costing_detail_rep_pkg AUTHID CURRENT_USER AS
2 /* $Header: pycstrep.pkh 120.0 2005/05/29 04:15:44 appldev noship $ */
3
4 PROCEDURE costing_extract
5 (errbuf out nocopy varchar2
6 ,retcode out nocopy number
7 ,p_business_group_id in number
8 ,p_start_date in varchar2
9 ,p_end_date in varchar2
10 ,p_selection_criteria in varchar2
11 ,p_is_ele_set in varchar2
12 ,p_element_set_id in number
13 ,p_is_ele_class in varchar2
14 ,p_element_classification_id in number
15 ,p_is_ele in varchar2
16 ,p_element_type_id in number
17 ,p_payroll_id in number
18 ,p_consolidation_set_id in number
19 ,p_tax_unit_id in number
20 ,p_organization_id in number
21 ,p_location_id in number
22 ,p_person_id in number
23 ,p_assignment_set_id in number
24 ,p_cost_type in varchar2
25 ,p_output_file_type in varchar2
26 );
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 TYPE tab_tax_unit_name is TABLE OF HR_ORGANIZATION_UNITS.NAME%TYPE index by BINARY_INTEGER;
38 g_tax_unit_name tab_tax_unit_name;
39
40 function get_costing_tax_unit_id(p_ACTION_TYPE pay_payroll_actions.action_type%TYPE,
41 p_TAX_UNIT_ID pay_assignment_actions.TAX_UNIT_ID%TYPE,
42 p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE,
43 p_element_type_id pay_element_types_f.element_type_id%TYPE
44 ) return number;
45 function get_costing_tax_unit_name(p_tax_unit_id HR_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE)
46 return VARCHAR2;
47
48 end pay_costing_detail_rep_pkg;