PACKAGE: APPS.PAY_KW_ANNUAL_REPORTS

Source

1 PACKAGE pay_kw_annual_reports AS
2 /* $Header: pykwyear.pkh 120.1.12000000.1 2007/01/17 22:35:03 appldev noship $ */
3   PROCEDURE report55
4     (p_request_id              NUMBER
5     ,p_report                  VARCHAR2
6     ,p_business_group_id       NUMBER
7     ,p_employer_id             NUMBER
8     ,p_effective_month         VARCHAR2
9     ,p_effective_year          VARCHAR2
10     ,l_xfdf_blob               OUT NOCOPY BLOB
11     );
12 
13     --------------------------------------------------------------------------
14 
15   PROCEDURE report56
16     (p_request_id              NUMBER
17     ,p_report                  VARCHAR2
18     ,p_business_group_id       NUMBER
19     ,p_employer_id             NUMBER
20     ,p_effective_month         VARCHAR2
21     ,p_effective_year          VARCHAR2
22     ,p_assignment_id	       NUMBER DEFAULT NULL
23     ,l_xfdf_blob               OUT NOCOPY BLOB
24     );
25 
26     --------------------------------------------------------------------------
27 
28   PROCEDURE report103
29     (p_request_id              NUMBER
30     ,p_report                  VARCHAR2
31     ,p_business_group_id       NUMBER
32     ,p_employer_id             NUMBER
33     ,p_effective_month         VARCHAR2
34     ,p_effective_year          VARCHAR2
35     ,p_employee_id	       NUMBER DEFAULT NULL
36     ,l_xfdf_blob               OUT NOCOPY BLOB
37     );
38 
39   PROCEDURE clob_to_blob
40     (p_clob clob
41     ,p_blob IN OUT NOCOPY Blob);
42 
43   PROCEDURE WritetoCLOB
44     (p_xfdf_blob OUT NOCOPY BLOB);
45 
46   PROCEDURE fetch_pdf_blob
47     (p_report    IN  VARCHAR2
48     ,p_pdf_blob  OUT NOCOPY BLOB);
49 
50     --
51   FUNCTION get_lookup_meaning
52     (p_lookup_type VARCHAR2
53     ,p_lookup_code VARCHAR2) RETURN VARCHAR2;
54 	--
55 
56 
57   TYPE XMLRec IS RECORD
58     (TagName VARCHAR2(240)
59     ,TagValue VARCHAR2(240));
60 
61   TYPE tXMLTable IS TABLE OF XMLRec INDEX BY BINARY_INTEGER;
62   vXMLTable tXMLTable;
63   vCtr NUMBER;
64 
65 PROCEDURE WritetoXML(
66          p_request_id in number,
67  p_report in varchar2,
68  p_output_fname out nocopy varchar2);
69 
70 PROCEDURE WriteXMLvalues(p_l_fp utl_file.file_type,p_tagname IN VARCHAR2, p_value IN VARCHAR2);
71 
72 
73 END pay_kw_annual_reports;