PACKAGE: APPS.PAY_AE_PAYROLL_REGISTER

Source

1 PACKAGE PAY_AE_PAYROLL_REGISTER AUTHID CURRENT_USER AS
2 /* $Header: pyaepyrg.pkh 120.0.12010000.1 2008/07/27 22:01:10 appldev ship $ */
3 ----------------------------------------------------------
4 TYPE XMLRec IS RECORD(
5 TagName VARCHAR2(240),
6 TagValue VARCHAR2(240));
7 TYPE tXMLTable IS TABLE OF XMLRec INDEX BY BINARY_INTEGER;
8 vXMLTable tXMLTable;
9 vXMLTable_summary tXMLTable;
10 vCtr NUMBER;
11 vCtr_summary NUMBER;
12 -----------------------------------------------------------
13 PROCEDURE GET_PAYROLL_REGISTER_DATA (    p_report IN varchar2,p_organization_id IN number,
14                                                                     p_org_structure_version_id IN number,
15                                                                     p_payroll_id IN number,
16                                                                         p_effective_char_date IN varchar2,
17                                                                                 p_sort_order1 IN varchar2,
18                                                                                 p_sort_order2 In varchar2,
19                                                                                 p_sort_order3 IN varchar2,
20                                        l_xfdf_blob OUT NOCOPY blob);
21 
22 Procedure fetch_pdf_blob
23         (p_report in varchar2,p_pdf_blob OUT NOCOPY blob);
24 -----------------------------------------------------------
25 Procedure  clob_to_blob(p_clob clob,
26                           p_blob IN OUT NOCOPY Blob);
27 PROCEDURE WritetoCLOB (p_report in varchar2,
28         p_xfdf_blob out nocopy blob);
29 --
30  FUNCTION get_lookup_meaning
31     (p_lookup_type VARCHAR2
32     ,p_lookup_code VARCHAR2) RETURN VARCHAR2;
33 --
34 END PAY_AE_PAYROLL_REGISTER ;