1 PACKAGE per_es_comp_cert_archive_pkg AUTHID CURRENT_USER as
2 /* $Header: peesccar.pkh 120.4 2006/06/15 11:37:30 grchandr noship $ */
3
4
5 TYPE XMLRec IS RECORD(
6 TagName VARCHAR2(240),
7 TagValue VARCHAR2(240));
8 TYPE tXMLTable IS TABLE OF XMLRec INDEX BY BINARY_INTEGER;
9 vXMLTable tXMLTable;
10 vCtr NUMBER;
11
12 FUNCTION get_parameters(p_payroll_action_id IN NUMBER,
13 p_token_name IN VARCHAR2) RETURN VARCHAR2;
14 --
15 PROCEDURE get_all_parameters(p_payroll_action_id IN NUMBER
16 ,p_business_group_id OUT NOCOPY NUMBER
17 ,p_start_date OUT NOCOPY DATE
18 ,p_end_date OUT NOCOPY DATE
19 ,p_legal_employer OUT NOCOPY NUMBER);
20 --
21 PROCEDURE range_code(p_actid IN NUMBER
22 ,sqlstr OUT NOCOPY VARCHAR2);
23
24 --
25 PROCEDURE action_creation_code (p_actid IN NUMBER
26 ,stperson IN NUMBER
27 ,endperson IN NUMBER
28 ,chunk IN NUMBER);
29 --
30 PROCEDURE archive_code (p_assactid in number,
31 p_effective_date in date);
32
33 --
34 PROCEDURE get_person_address(p_person_id IN NUMBER
35 ,p_assactid IN NUMBER
36 ,p_assignment_id IN NUMBER
37 ,p_termination_date IN DATE
38 ,p_effective_date IN DATE
39 );
40 --
41 PROCEDURE get_employer_address(p_organization_id IN NUMBER
42 ,p_actid IN NUMBER
43 ,p_effective_date IN DATE
44 );
45 --
46 PROCEDURE get_employee_data(p_assactid IN NUMBER
47 ,p_assignment_id IN OUT NOCOPY NUMBER
48 ,p_effective_date IN DATE
49 ,p_person_id IN OUT NOCOPY NUMBER
50 ,p_end_date IN OUT NOCOPY DATE
51 ,p_type IN OUT NOCOPY VARCHAR2
52 );
53 --
54 PROCEDURE get_element_entries(p_assactid IN NUMBER
55 ,p_assignment_id IN NUMBER
56 ,p_effective_date IN DATE
57 ,p_type IN VARCHAR2
58 );
59 --
60 PROCEDURE clob_to_blob (p_clob clob,
61 p_blob IN OUT NOCOPY Blob);
62 --PROCEDURE WritetoCLOB (p_xfdf_blob out nocopy blob);
63 PROCEDURE WritetoCLOB (p_xfdf_blob out nocopy blob
64 ,p_xfdf_string out nocopy clob);
65 --
66 PROCEDURE fetch_pdf_blob (p_pdf_blob OUT NOCOPY BLOB);
67 --
68 PROCEDURE populate_comp_cert
69 (p_request_id IN NUMBER
70 ,p_payroll_action_id NUMBER
71 ,p_legal_employer NUMBER
72 ,p_person_id NUMBER
73 ,p_xfdf_blob OUT NOCOPY BLOB);
74 --
75 PROCEDURE populate_plsql_table
76 (p_request_id IN NUMBER
77 ,p_payroll_action_id NUMBER
78 ,p_legal_employer NUMBER
79 ,p_person_id NUMBER);
80 --
81 END per_es_comp_cert_archive_pkg;