PACKAGE: APPS.PAY_AE_SI_REPORTS

Source

1 PACKAGE pay_ae_SI_reports AUTHID CURRENT_USER AS
2 /* $Header: pyaesirp.pkh 120.1.12000000.1 2007/01/17 15:24:42 appldev noship $ */
3   PROCEDURE FORM1
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   PROCEDURE FORM2
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 
23   PROCEDURE FORM6
24     (p_request_id              NUMBER
25     ,p_report                  VARCHAR2
26     ,p_business_group_id       NUMBER
27     ,p_employer_id             NUMBER
28     ,p_effective_month         VARCHAR2
29     ,p_effective_year          VARCHAR2
30     ,l_xfdf_blob               OUT NOCOPY BLOB
31     );
32     --
33   PROCEDURE FORM7
34     (p_request_id              NUMBER
35     ,p_report                  VARCHAR2
36     ,p_business_group_id       NUMBER
37     ,p_employer_id             NUMBER
38     ,p_effective_month         VARCHAR2
39     ,p_effective_year          VARCHAR2
40     ,l_xfdf_blob               OUT NOCOPY BLOB
41     );
42     --
43   PROCEDURE MCP
44     (p_request_id              NUMBER
45     ,p_report                  VARCHAR2
46     ,p_business_group_id       NUMBER
47     ,p_employer_id             NUMBER
48     ,p_effective_month         VARCHAR2
49     ,p_effective_year          VARCHAR2
50     ,l_xfdf_blob               OUT NOCOPY BLOB
51     );
52     --
53   PROCEDURE MCF
54     (p_request_id              NUMBER
55     ,p_report                  VARCHAR2
56     ,p_business_group_id       NUMBER
57     ,p_employer_id             NUMBER
58     ,p_effective_month         VARCHAR2
59     ,p_effective_year          VARCHAR2
60     ,l_xfdf_blob               OUT NOCOPY BLOB
61     );
62   PROCEDURE clob_to_blob
63     (p_clob clob
64     ,p_blob IN OUT NOCOPY Blob);
65     --
66   PROCEDURE WritetoCLOB
67     (p_xfdf_blob OUT NOCOPY BLOB);
68     --
69   PROCEDURE fetch_pdf_blob
70     (p_report    IN  VARCHAR2
71     ,p_pdf_blob  OUT NOCOPY BLOB);
72     --
73   FUNCTION get_lookup_meaning
74     (p_lookup_type VARCHAR2
75     ,p_lookup_code VARCHAR2) RETURN VARCHAR2;
76 	--
77   TYPE XMLRec IS RECORD
78     (TagName VARCHAR2(240)
79     ,TagValue VARCHAR2(240));
80     --
81   TYPE tXMLTable IS TABLE OF XMLRec INDEX BY BINARY_INTEGER;
82   vXMLTable tXMLTable;
83   vCtr NUMBER;
84   --
85 END pay_ae_SI_reports;