1 PACKAGE pay_se_income_statement AUTHID CURRENT_USER AS
2 /* $Header: pyseinsr.pkh 120.0.12000000.1 2007/04/20 06:54:30 abhgangu noship $ */
3 /* ############################################################# */
4 -- For Archive
5 TYPE balance_id IS TABLE OF VARCHAR2 (240)
6 INDEX BY VARCHAR2 (240);
7
8 -- INDEX BY BINARY_INTEGER;
9 TYPE field_record IS RECORD (
10 field_code balance_id
11 ,legal_employer_id NUMBER
12 );
13
14 TYPE each_field IS TABLE OF field_record
15 INDEX BY BINARY_INTEGER;
16
17 each_field_value each_field;
18
19 FUNCTION get_parameter (
20 p_parameter_string IN VARCHAR2
21 ,p_token IN VARCHAR2
22 ,p_segment_number IN NUMBER DEFAULT NULL
23 )
24 RETURN VARCHAR2;
25
26 PROCEDURE get_all_parameters (
27 p_payroll_action_id IN NUMBER -- In parameter
28 ,p_business_group_id OUT NOCOPY NUMBER -- Core parameter
29 ,p_effective_date OUT NOCOPY DATE -- Core parameter
30 ,p_income_statement_provider_id OUT NOCOPY NUMBER -- User parameter
31 ,p_request_for_all_or_not OUT NOCOPY VARCHAR2 -- User parameter
32 ,p_legal_employer_id OUT NOCOPY NUMBER -- User parameter
33 ,p_income_year OUT NOCOPY VARCHAR2 -- User parameter
34 ,p_person_for OUT NOCOPY VARCHAR2 -- User parameter
35 ,p_person_number OUT NOCOPY NUMBER -- User parameter
36 ,p_sort_order OUT NOCOPY VARCHAR2 -- User parameter
37 ,p_test_or_production OUT NOCOPY VARCHAR2 -- User parameter
38 );
39
40 PROCEDURE range_code (
41 p_payroll_action_id IN NUMBER
42 ,p_sql OUT NOCOPY VARCHAR2
43 );
44
45 PROCEDURE assignment_action_code (
46 p_payroll_action_id IN NUMBER
47 ,p_start_person IN NUMBER
48 ,p_end_person IN NUMBER
49 ,p_chunk IN NUMBER
50 );
51
52 PROCEDURE initialization_code (p_payroll_action_id IN NUMBER);
53
54 FUNCTION get_defined_balance_id (p_user_name IN VARCHAR2)
55 RETURN NUMBER;
56
57 PROCEDURE archive_code (
58 p_assignment_action_id IN NUMBER
59 ,p_effective_date IN DATE
60 );
61
62 /* ############################################################# */
63 -- For Report
64 -- Record for PL/sql Table which contains XMl tag and Value
65 TYPE xmlrec IS RECORD (
66 tagname VARCHAR2 (240)
67 ,tagvalue VARCHAR2 (240)
68 );
69
70 TYPE insxml IS TABLE OF xmlrec
71 INDEX BY BINARY_INTEGER;
72
73 gins_data insxml;
74
75 -- Record for PL/sql Table which contains XMl tag and Value
76 -- Proc to Populate the Tag and value into Pl/sql Table
77 PROCEDURE get_xml_for_report (
78 p_business_group_id IN NUMBER
79 ,p_payroll_action_id IN VARCHAR2
80 ,p_template_name IN VARCHAR2
81 ,p_xml OUT NOCOPY CLOB
82 );
83
84 -- Proc to Populate the Tag and value into Pl/sql Table
85 -- Proc to Convert the Pl/sql Table to Clob
86 PROCEDURE writetoclob (p_xfdf_clob OUT NOCOPY CLOB);
87
88 -- Proc to Convert the Pl/sql Table to Clob
89 /* ############################################################# */
90 FUNCTION get_defined_balance_value (
91 p_user_name IN VARCHAR2
92 ,p_in_assignment_id IN NUMBER
93 ,p_in_virtual_date IN DATE
94 ,p_tax_unit_id IN NUMBER
95 ,p_local_unit_id IN NUMBER
96 )
97 RETURN NUMBER;
98
99 PROCEDURE logger (p_display IN VARCHAR2, p_value IN VARCHAR2);
100
101 FUNCTION get_balance_value (
102 p_balance_type_id IN NUMBER
103 ,p_in_assignment_id IN NUMBER
104 ,p_in_virtual_date IN DATE
105 ,p_tax_unit_id IN NUMBER
106 ,p_local_unit_id IN NUMBER
107 )
108 RETURN NUMBER;
109 FUNCTION get_country (p_code IN VARCHAR2 )
110 return Varchar2;
111 END pay_se_income_statement;