PACKAGE: APPS.PAY_KW_MONTHLY_REPORTS

Source

1 PACKAGE pay_kw_monthly_reports AS
2 /* $Header: pykwmonr.pkh 120.1.12000000.1 2007/01/17 22:29:42 appldev noship $ */
3   PROCEDURE report166
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     ,p_arrears                 NUMBER DEFAULT 0
11     ,l_xfdf_blob               OUT NOCOPY BLOB
12     );
13   PROCEDURE report167
14     (p_request_id              NUMBER
15     ,p_report                  VARCHAR2
16     ,p_business_group_id       NUMBER
17     ,p_employer_id             NUMBER
18     ,p_effective_month         VARCHAR2
19     ,p_effective_year          VARCHAR2
20     ,l_xfdf_blob               OUT NOCOPY BLOB
21     );
22     --,p_output_fname OUT NOCOPY VARCHAR2);
23 
24   PROCEDURE report167_2006
25     (p_request_id              NUMBER
26     ,p_report                  VARCHAR2
27     ,p_business_group_id       NUMBER
28     ,p_employer_id             NUMBER
29     ,p_effective_month         VARCHAR2
30     ,p_effective_year          VARCHAR2
31     ,l_xfdf_blob               OUT NOCOPY BLOB
32     );
33 
34   PROCEDURE report168
35     (p_request_id              NUMBER
36     ,p_report                  VARCHAR2
37     ,p_business_group_id       NUMBER
38     ,p_employer_id             NUMBER
39     ,p_effective_month         VARCHAR2
40     ,p_effective_year          VARCHAR2
41     ,l_xfdf_blob               OUT NOCOPY BLOB
42     );
43   PROCEDURE clob_to_blob
44     (p_clob clob
45     ,p_blob IN OUT NOCOPY Blob);
46   PROCEDURE WritetoCLOB
47     (p_xfdf_blob OUT NOCOPY BLOB);
48   PROCEDURE fetch_pdf_blob
49     (p_report    IN  VARCHAR2
50     ,p_pdf_blob  OUT NOCOPY BLOB);
51   TYPE XMLRec IS RECORD
52     (TagName VARCHAR2(240)
53     ,TagValue VARCHAR2(240));
54   TYPE tXMLTable IS TABLE OF XMLRec INDEX BY BINARY_INTEGER;
55   vXMLTable tXMLTable;
56   vCtr NUMBER;
57 
58 PROCEDURE WritetoXML(
59          p_request_id in number,
60  p_report in varchar2,
61  p_output_fname out nocopy varchar2);
62 
63 PROCEDURE WriteXMLvalues(p_l_fp utl_file.file_type,p_tagname IN VARCHAR2, p_value IN VARCHAR2);
64 
65 
66 END pay_kw_monthly_reports;