1 PACKAGE pay_se_work_time_certificate AS
2 /* $Header: pysewtcr.pkh 120.0.12010000.8 2008/08/06 08:20:34 ubhat ship $ */
3
4
5 -- For Archive
6 FUNCTION get_parameter (
7 p_parameter_string IN VARCHAR2
8 ,p_token IN VARCHAR2
9 ,p_segment_number IN NUMBER DEFAULT NULL
10 )
11 RETURN VARCHAR2;
12
13 PROCEDURE get_all_parameters (
14 p_payroll_action_id IN NUMBER -- In parameter
15 ,p_business_group_id OUT NOCOPY NUMBER -- Core parameter
16 ,p_effective_date OUT NOCOPY DATE -- Core parameter
17 ,p_person_id OUT NOCOPY NUMBER -- User parameter
18 ,p_assignment_id OUT NOCOPY VARCHAR2 -- User parameter
19 ,p_still_employed OUT NOCOPY VARCHAR2 -- User parameter
20 ,p_income_salary_year OUT NOCOPY VARCHAR2 -- 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 --Procedures added for the new version of the Report from 2008
47
48 -- For Report
49 -- Record Created to Update the Break Up of Digits.
50 TYPE tagdata IS RECORD
51 (
52 TagName VARCHAR2(240),
53 TagValue VARCHAR2(240)
54 );
55 TYPE ttagdata
56 IS TABLE OF tagdata
57 INDEX BY BINARY_INTEGER;
58 gplsqltable ttagdata;
59
60 --Procedure to break up the number into various digits
61 PROCEDURE get_digit_breakup(
62 p_number IN NUMBER,
63 p_digit1 OUT NOCOPY NUMBER,
64 p_digit2 OUT NOCOPY NUMBER,
65 p_digit3 OUT NOCOPY NUMBER,
66 p_digit4 OUT NOCOPY NUMBER,
67 p_digit5 OUT NOCOPY NUMBER,
68 p_digit6 OUT NOCOPY NUMBER,
69 p_digit7 OUT NOCOPY NUMBER,
70 p_digit8 OUT NOCOPY NUMBER,
71 p_digit9 OUT NOCOPY NUMBER,
72 p_digit10 OUT NOCOPY NUMBER
73 );
74
75
76 --###############################################################
77 -- For Report
78 -- Record for PLsql Table which contains XMl tag and Value
79 TYPE xmlrec IS RECORD (
80 tagname VARCHAR2 (240)
81 ,tagvalue VARCHAR2 (240)
82 );
83
84 TYPE wtcxml IS TABLE OF xmlrec
85 INDEX BY BINARY_INTEGER;
86
87 gwtc_data wtcxml;
88
89 -- Record for PLsql Table which contains XMl tag and Value
90 -- Proc to Populate the Tag and value into Plsql Table
91 PROCEDURE get_xml_for_report (
92 p_business_group_id IN NUMBER
93 ,p_payroll_action_id IN VARCHAR2
94 ,p_template_name IN VARCHAR2
95 ,p_xml OUT NOCOPY CLOB
96 );
97
98 -- Proc to Populate the Tag and value into Plsql Table
99 -- Proc to Convert the Plsql Table to Clob
100 PROCEDURE writetoclob (p_xfdf_clob OUT NOCOPY CLOB);
101
102 -- Proc to Convert the Plsql Table to Clob
103 -- #############################################################
104 FUNCTION get_defined_balance_value (
105 p_user_name IN VARCHAR2
106 ,p_in_assignment_id IN NUMBER
107 ,p_in_virtual_date IN DATE
108 ,p_tax_unit_id IN NUMBER
109 ,p_local_unit_id IN NUMBER
110 )
111 RETURN NUMBER;
112
113 PROCEDURE logger (p_display IN VARCHAR2, p_value IN VARCHAR2);
114 END pay_se_work_time_certificate;
115