PACKAGE: APPS.PAY_KW_MONTHLY_REPORTS

Source

1 PACKAGE pay_kw_monthly_reports AUTHID CURRENT_USER AS
2 /* $Header: pykwmonr.pkh 120.3.12020000.2 2012/10/03 10:46:52 bkeshary ship $ */
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     ,p_arrears2                NUMBER DEFAULT 0  /* changes in 166 - Aug 2012 */
12     ,p_arrears3                NUMBER DEFAULT 0
13     ,p_not_in_rep_167          NUMBER DEFAULT 0
14     ,p_add_supp_insu_1997      NUMBER DEFAULT 0
15     ,l_xfdf_blob               OUT NOCOPY BLOB
16     );
17 
18   PROCEDURE report167
19     (p_request_id              NUMBER
20     ,p_report                  VARCHAR2
21     ,p_business_group_id       NUMBER
22     ,p_employer_id             NUMBER
23     ,p_effective_month         VARCHAR2
24     ,p_effective_year          VARCHAR2
25     ,l_xfdf_blob               OUT NOCOPY BLOB
26     );
27     --,p_output_fname OUT NOCOPY VARCHAR2);
28 
29   PROCEDURE report167_2006
30     (p_request_id              NUMBER
31     ,p_report                  VARCHAR2
32     ,p_business_group_id       NUMBER
33     ,p_employer_id             NUMBER
34     ,p_effective_month         VARCHAR2
35     ,p_effective_year          VARCHAR2
36     ,l_xfdf_blob               OUT NOCOPY BLOB
37     );
38 
39   PROCEDURE report168
40     (p_request_id              NUMBER
41     ,p_report                  VARCHAR2
42     ,p_business_group_id       NUMBER
43     ,p_employer_id             NUMBER
44     ,p_effective_month         VARCHAR2
45     ,p_effective_year          VARCHAR2
46     ,l_xfdf_blob               OUT NOCOPY BLOB
47     );
48   PROCEDURE clob_to_blob
49     (p_clob clob
50     ,p_blob IN OUT NOCOPY Blob);
51   PROCEDURE WritetoCLOB
52     (p_xfdf_blob OUT NOCOPY BLOB);
53   PROCEDURE fetch_pdf_blob
54     (p_report    IN  VARCHAR2
55     ,p_effective_month     IN  VARCHAR2
56     ,p_effective_year      IN  VARCHAR2
57     ,p_pdf_blob  OUT NOCOPY BLOB);
58   TYPE XMLRec IS RECORD
59     (TagName VARCHAR2(240)
60     ,TagValue VARCHAR2(240));
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_monthly_reports;