1 PACKAGE per_ae_xdo_report AUTHID CURRENT_USER AS
2 /* $Header: peaexdor.pkh 120.2.12010000.1 2008/07/28 04:04:49 appldev ship $ */
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_visa_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_expires_in IN NUMBER DEFAULT NULL
20 ,p_units IN VARCHAR2 DEFAULT NULL
21 ,l_xfdf_blob OUT NOCOPY BLOB);
22
23 PROCEDURE get_passport_data
24 (p_request_id IN NUMBER
25 ,p_report_name IN VARCHAR2
26 ,p_date IN VARCHAR2 DEFAULT NULL
27 ,p_business_group_id IN NUMBER DEFAULT NULL
28 ,p_org_structure_id IN NUMBER DEFAULT NULL
29 ,p_org_structure_version_id IN NUMBER DEFAULT NULL
30 ,p_expires_in IN NUMBER DEFAULT NULL
31 ,p_units IN VARCHAR2 DEFAULT NULL
32 ,l_xfdf_blob OUT NOCOPY BLOB);
33
34 PROCEDURE get_contract_data
35 (p_request_id IN NUMBER
36 ,p_report_name IN VARCHAR2
37 ,p_date IN VARCHAR2 DEFAULT NULL
38 ,p_business_group_id IN NUMBER DEFAULT NULL
39 ,p_org_structure_id IN NUMBER DEFAULT NULL
40 ,p_org_structure_version_id IN NUMBER DEFAULT NULL
41 ,p_org_id IN NUMBER DEFAULT NULL
42 ,p_expires_in IN NUMBER
43 ,p_units IN VARCHAR2
44 ,l_xfdf_blob OUT NOCOPY BLOB);
45
46 PROCEDURE clob_to_blob
47 (p_clob CLOB
48 ,p_blob IN OUT NOCOPY BLOB);
49
50 PROCEDURE Writetoclob
51 (p_xfdf_blob OUT NOCOPY BLOB
52 ,p_tot_pg_count IN NUMBER);
53
54 PROCEDURE fetch_pdf_blob
55 (p_report IN VARCHAR2
56 ,P_date IN VARCHAR2
57 ,p_pdf_blob OUT NOCOPY BLOB);
58
59 FUNCTION get_lookup_meaning
60 (p_lookup_type VARCHAR2
61 ,p_lookup_code VARCHAR2) RETURN VARCHAR2;
62
63
64 END per_ae_xdo_report;