1 PACKAGE PAY_SE_FORA AUTHID CURRENT_USER AS
2 /* $Header: pysefora.pkh 120.0.12010000.1 2008/07/27 23:37:14 appldev ship $ */
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_LU_request OUT NOCOPY VARCHAR2 -- User parameter
16 , p_LOCAL_UNIT_id OUT NOCOPY NUMBER -- User parameter
17 , p_YEAR OUT NOCOPY NUMBER -- User parameter
18 );
19
20 PROCEDURE range_code (
21 p_payroll_action_id IN NUMBER
22 , p_sql OUT NOCOPY VARCHAR2
23 );
24
25 PROCEDURE assignment_action_code (
26 p_payroll_action_id IN NUMBER
27 , p_start_person IN NUMBER
28 , p_end_person IN NUMBER
29 , p_chunk IN NUMBER
30 );
31
32 PROCEDURE initialization_code (p_payroll_action_id IN NUMBER);
33
34 FUNCTION get_defined_balance_id (p_user_name IN VARCHAR2)
35 RETURN NUMBER;
36
37 PROCEDURE archive_code (
38 p_assignment_action_id IN NUMBER
39 , p_effective_date IN DATE
40 );
41
42 /* ############################################################# */
43 -- For Report
44 -- Record for PL/sql Table which contains XMl tag and Value
45 TYPE xmlrec IS RECORD (
46 tagname VARCHAR2 (240)
47 , tagvalue VARCHAR2 (240)
48 );
49
50 TYPE hpdxml IS TABLE OF xmlrec
51 INDEX BY BINARY_INTEGER;
52
53 ghpd_data hpdxml;
54
55 -- Record for PL/sql Table which contains XMl tag and Value
56 -- Proc to Populate the Tag and value into Pl/sql Table
57 PROCEDURE get_xml_for_report (
58 p_business_group_id IN NUMBER
59 , p_payroll_action_id IN VARCHAR2
60 , p_template_name IN VARCHAR2
61 , p_xml OUT NOCOPY CLOB
62 );
63
64 -- Proc to Populate the Tag and value into Pl/sql Table
65 -- Proc to Convert the Pl/sql Table to Clob
66 PROCEDURE writetoclob (p_xfdf_clob OUT NOCOPY CLOB);
67
68 -- Proc to Convert the Pl/sql Table to Clob
69 /* ############################################################# */
70 FUNCTION get_defined_balance_value (
71 p_user_name IN VARCHAR2
72 , p_in_assignment_id IN NUMBER
73 , p_in_virtual_date IN DATE
74 )
75 RETURN NUMBER;
76
77 PROCEDURE POPULATE_DATA_DETAIL
78 (p_business_group_id IN NUMBER,
79 p_payroll_action_id IN VARCHAR2 ,
80 p_template_name IN VARCHAR2,
81 p_employee_category IN VARCHAR2,
82 p_xml OUT NOCOPY CLOB);
83
84 TYPE xml_rec_type IS RECORD
85 (
86 TagName VARCHAR2(240),
87 TagValue VARCHAR2(240)
88 );
89 TYPE xml_tab_type
90 IS TABLE OF xml_rec_type
91 INDEX BY BINARY_INTEGER;
92 xml_tab xml_tab_type;
93
94 END PAY_SE_FORA;
95