1 PACKAGE per_kw_xdo_report AS
2 /* $Header: pekwxdor.pkh 120.0 2005/05/31 11:12:51 appldev noship $ */
3
4 TYPE xmlrec IS RECORD
5 (tagName VARCHAR2(240)
6 ,tagValue VARCHAR2(240));
7 TYPE txmltable IS TABLE OF xmlRec INDEX BY BINARY_INTEGER;
8 gxmltable txmltable;
9 gCtr NUMBER;
10
11
12 PROCEDURE get_disability_data
13 (p_request_id IN NUMBER
14 ,p_report_name IN VARCHAR2
15 ,p_date IN VARCHAR2 DEFAULT NULL
16 ,p_business_group_id IN NUMBER DEFAULT NULL
17 ,p_org_structure_id IN NUMBER DEFAULT NULL
18 ,p_org_structure_version_id IN NUMBER DEFAULT NULL
19 ,p_legal_employer IN NUMBER DEFAULT NULL
20 ,p_disability_type IN VARCHAR2 DEFAULT NULL
21 ,p_disability_status IN VARCHAR2 DEFAULT NULL
22 ,l_xfdf_blob OUT NOCOPY BLOB);
23
24 PROCEDURE get_contract_data
25 (p_request_id IN NUMBER
26 ,p_report_name IN VARCHAR2
27 ,p_date IN VARCHAR2 DEFAULT NULL
28 ,p_business_group_id IN NUMBER DEFAULT NULL
29 ,p_org_structure_id IN NUMBER DEFAULT NULL
30 ,p_org_structure_version_id IN NUMBER DEFAULT NULL
31 ,p_legal_employer IN NUMBER DEFAULT NULL
32 ,p_duration IN NUMBER
33 ,p_units IN VARCHAR2
34 ,l_xfdf_blob OUT NOCOPY BLOB);
35
36 PROCEDURE clob_to_blob
37 (p_clob CLOB
38 ,p_blob IN OUT NOCOPY BLOB);
39
40 PROCEDURE Writetoclob
41 (p_xfdf_blob OUT NOCOPY BLOB
42 ,p_tot_pg_count IN NUMBER);
43
44 PROCEDURE fetch_pdf_blob
45 (p_report IN VARCHAR2
46 ,P_date IN VARCHAR2
47 ,p_pdf_blob OUT NOCOPY BLOB);
48
49 FUNCTION get_lookup_meaning
50 (p_lookup_type VARCHAR2
51 ,p_lookup_code VARCHAR2) RETURN VARCHAR2;
52
53
54 END per_kw_xdo_report;