[Home] [Help]
PACKAGE: APPS.PAY_KW_ANNUAL_REPORTS
Source
1 PACKAGE pay_kw_annual_reports AUTHID CURRENT_USER AS
2 /* $Header: pykwyear.pkh 120.1.12020000.2 2012/11/05 10:12:11 bkeshary ship $ */
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_effective_month varchar2,
49 p_effective_year varchar2,
50 p_pdf_blob OUT NOCOPY BLOB);
51
52 --
53 FUNCTION get_lookup_meaning
54 (p_lookup_type VARCHAR2
55 ,p_lookup_code VARCHAR2) RETURN VARCHAR2;
56 --
57
58
59 TYPE XMLRec IS RECORD
60 (TagName VARCHAR2(240)
61 ,TagValue VARCHAR2(240));
62
63 TYPE tXMLTable IS TABLE OF XMLRec INDEX BY BINARY_INTEGER;
64 vXMLTable tXMLTable;
65 vCtr NUMBER;
66
67 PROCEDURE WritetoXML(
68 p_request_id in number,
69 p_report in varchar2,
70 p_output_fname out nocopy varchar2);
71
72 PROCEDURE WriteXMLvalues(p_l_fp utl_file.file_type,p_tagname IN VARCHAR2, p_value IN VARCHAR2);
73
74
75 END pay_kw_annual_reports;