1 PACKAGE pay_se_holiday_pay_debt AS
2 /* $Header: pysehpdr.pkh 120.0.12000000.1 2007/04/20 06:34:06 abhgangu noship $ */
3 /* ############################################################# */
4 -- For Archive
5 FUNCTION get_parameter (
6 p_parameter_string IN VARCHAR2
7 , p_token IN VARCHAR2
8 , p_segment_number IN NUMBER DEFAULT NULL
9 )
10 RETURN VARCHAR2;
11
12 PROCEDURE get_all_parameters (
13 p_payroll_action_id IN NUMBER -- In parameter
14 , p_business_group_id OUT NOCOPY NUMBER -- Core parameter
15 , p_effective_date OUT NOCOPY DATE -- Core parameter
16 , p_legal_employer_id OUT NOCOPY NUMBER -- User parameter
17 , p_request_for_all_or_not OUT NOCOPY VARCHAR2 -- User parameter
18 , p_start_date OUT NOCOPY DATE -- User parameter
19 , p_end_date OUT NOCOPY DATE
20 );
21
22 PROCEDURE range_code (
23 p_payroll_action_id IN NUMBER
24 , p_sql OUT NOCOPY VARCHAR2
25 );
26
27 PROCEDURE assignment_action_code (
28 p_payroll_action_id IN NUMBER
29 , p_start_person IN NUMBER
30 , p_end_person IN NUMBER
31 , p_chunk IN NUMBER
32 );
33
34 PROCEDURE initialization_code (p_payroll_action_id IN NUMBER);
35
36 FUNCTION get_defined_balance_id (p_user_name IN VARCHAR2)
37 RETURN NUMBER;
38
39 PROCEDURE archive_code (
40 p_assignment_action_id IN NUMBER
41 , p_effective_date IN DATE
42 );
43
44 /* ############################################################# */
45 -- For Report
46 -- Record for PL/sql Table which contains XMl tag and Value
47 TYPE xmlrec IS RECORD (
48 tagname VARCHAR2 (240)
49 , tagvalue VARCHAR2 (240)
50 );
51
52 TYPE hpdxml IS TABLE OF xmlrec
53 INDEX BY BINARY_INTEGER;
54
55 ghpd_data hpdxml;
56
57 -- Record for PL/sql Table which contains XMl tag and Value
58 -- Proc to Populate the Tag and value into Pl/sql Table
59 PROCEDURE get_xml_for_report (
60 p_business_group_id IN NUMBER
61 , p_payroll_action_id IN VARCHAR2
62 , p_template_name IN VARCHAR2
63 , p_xml OUT NOCOPY CLOB
64 );
65
66 -- Proc to Populate the Tag and value into Pl/sql Table
67 -- Proc to Convert the Pl/sql Table to Clob
68 PROCEDURE writetoclob (p_xfdf_clob OUT NOCOPY CLOB);
69
70 -- Proc to Convert the Pl/sql Table to Clob
71 /* ############################################################# */
72 FUNCTION get_defined_balance_value (
73 p_user_name IN VARCHAR2
74 , p_in_assignment_id IN NUMBER
75 , p_in_virtual_date IN DATE
76 , p_tax_unit_id IN NUMBER
77 , p_local_unit_id IN NUMBER
78 )
79 RETURN NUMBER;
80 END pay_se_holiday_pay_debt;