1 PACKAGE PAY_SE_EMPLOYMENT_STATISTICS AUTHID CURRENT_USER AS
2 /* $Header: pysestsr.pkh 120.0.12000000.1 2007/04/24 05:53:23 rsahai noship $ */
3 /* ############################################################# */
4 -- For Archive
5 FUNCTION GET_PARAMETER(p_parameter_string IN VARCHAR2
6 ,p_token IN VARCHAR2
7 ,p_segment_number IN NUMBER default NULL ) RETURN VARCHAR2;
8
9
10 PROCEDURE get_all_parameters (
11 p_payroll_action_id IN NUMBER -- In parameter
12 , p_business_group_id OUT NOCOPY NUMBER -- Core parameter
13 , p_effective_date OUT NOCOPY DATE -- Core parameter
14 , p_legal_employer_id OUT NOCOPY NUMBER -- User parameter
15 , p_LE_request OUT NOCOPY VARCHAR2 -- User parameter
16 , p_LU_request OUT NOCOPY VARCHAR2 -- User parameter
17 , p_LOCAL_UNIT_id OUT NOCOPY NUMBER -- User parameter
18 , p_ACCOUNT_date OUT NOCOPY DATE -- User parameter
19 , p_POSTING_date OUT NOCOPY DATE -- User parameter
20 , p_REPORTING_date OUT nocopy DATE -- user parameter
21 );
22
23 PROCEDURE range_code (
24 p_payroll_action_id IN NUMBER
25 , p_sql OUT NOCOPY VARCHAR2
26 );
27
28 PROCEDURE assignment_action_code (
29 p_payroll_action_id IN NUMBER
30 , p_start_person IN NUMBER
31 , p_end_person IN NUMBER
32 , p_chunk IN NUMBER
33 );
34
35 PROCEDURE initialization_code (p_payroll_action_id IN NUMBER);
36
37 FUNCTION get_defined_balance_id (p_user_name IN VARCHAR2)
38 RETURN NUMBER;
39
40 PROCEDURE archive_code (
41 p_assignment_action_id IN NUMBER
42 , p_effective_date IN DATE
43 );
44
45 /* ############################################################# */
46 -- For Report
47 -- Record for PL/sql Table which contains XMl tag and Value
48 TYPE xmlrec IS RECORD (
49 tagname VARCHAR2 (240)
50 , tagvalue VARCHAR2 (240)
51 );
52
53 TYPE hpdxml IS TABLE OF xmlrec
54 INDEX BY BINARY_INTEGER;
55
56 ghpd_data hpdxml;
57
58 -- Record for PL/sql Table which contains XMl tag and Value
59 -- Proc to Populate the Tag and value into Pl/sql Table
60 PROCEDURE get_xml_for_report (
61 p_business_group_id IN NUMBER
62 , p_payroll_action_id IN VARCHAR2
63 , p_template_name IN VARCHAR2
64 , p_xml OUT NOCOPY CLOB
65 );
66
67 -- Proc to Populate the Tag and value into Pl/sql Table
68 -- Proc to Convert the Pl/sql Table to Clob
69 PROCEDURE writetoclob (p_xfdf_clob OUT NOCOPY CLOB);
70
71 -- Proc to Convert the Pl/sql Table to Clob
72 /* ############################################################# */
73 FUNCTION get_defined_balance_value (
74 p_user_name IN VARCHAR2
75 , p_in_assignment_id IN NUMBER
76 , p_in_virtual_date IN DATE
77 )
78 RETURN NUMBER;
79
80 PROCEDURE POPULATE_DATA_DETAIL
81 (p_business_group_id IN NUMBER,
82 p_payroll_action_id IN VARCHAR2 ,
83 p_template_name IN VARCHAR2,
84 p_xml OUT NOCOPY CLOB);
85
86 TYPE xml_rec_type IS RECORD
87 (
88 TagName VARCHAR2(240),
89 TagValue VARCHAR2(240)
90 );
91 TYPE xml_tab_type
92 IS TABLE OF xml_rec_type
93 INDEX BY BINARY_INTEGER;
94 xml_tab xml_tab_type;
95
96 END PAY_SE_EMPLOYMENT_STATISTICS;
97