1 PACKAGE PAY_SE_SALARY_STRUCTURE_STATS AUTHID CURRENT_USER AS
2 /* $Header: pysessst.pkh 120.0.12000000.1 2007/07/17 14:29:53 rravi 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
11 PROCEDURE get_all_parameters (
12 p_payroll_action_id IN NUMBER -- In parameter
13 , p_business_group_id OUT NOCOPY NUMBER -- Core parameter
14 , p_effective_date OUT NOCOPY DATE -- Core parameter
15 , p_legal_employer_id OUT NOCOPY NUMBER -- User parameter
16 , p_LE_request OUT NOCOPY VARCHAR2 -- User parameter
17 , p_month OUT NOCOPY NUMBER -- User parameter
18 , p_report_year OUT NOCOPY NUMBER -- User parameter
19 );
20
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 -- Proc to Populate the Tag and value into Pl/sql Table
59 -- Proc to Convert the Pl/sql Table to Clob
60 PROCEDURE writetoclob (p_xfdf_clob OUT NOCOPY CLOB);
61
62 -- Proc to Convert the Pl/sql Table to Clob
63 /* ############################################################# */
64 FUNCTION get_defined_balance_value (
65 p_user_name IN VARCHAR2
66 , p_in_assignment_id IN NUMBER
67 , p_in_virtual_date IN DATE
68 )
69 RETURN NUMBER;
70
71 PROCEDURE POPULATE_DATA_DETAIL
72 (p_business_group_id IN NUMBER,
73 p_payroll_action_id IN VARCHAR2 ,
74 p_template_name IN VARCHAR2,
75 p_xml OUT NOCOPY CLOB);
76
77 TYPE xml_rec_type IS RECORD
78 (
79 TagName VARCHAR2(240),
80 TagValue VARCHAR2(240)
81 );
82 TYPE xml_tab_type
83 IS TABLE OF xml_rec_type
84 INDEX BY BINARY_INTEGER;
85 xml_tab xml_tab_type;
86
87 END PAY_SE_SALARY_STRUCTURE_STATS;
88