[Home] [Help]
PACKAGE: APPS.PAY_AE_SI_REPORTS
Source
1 PACKAGE pay_ae_SI_reports 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;