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