[Home] [Help]
PACKAGE: APPS.PAY_KW_PAYROLL_REGISTER
Source
1 PACKAGE PAY_KW_PAYROLL_REGISTER AUTHID CURRENT_USER AS
2 /* $Header: pykwpyrg.pkh 120.0.12010000.1 2008/07/27 23:07:51 appldev ship $ */
3
4
5 ----------------------------------------------------------
6 TYPE XMLRec IS RECORD(
7 TagName VARCHAR2(240),
8 TagValue VARCHAR2(240));
9 TYPE tXMLTable IS TABLE OF XMLRec INDEX BY BINARY_INTEGER;
10 vXMLTable tXMLTable;
11 vXMLTable_summary tXMLTable;
12 vCtr NUMBER;
13 vCtr_summary NUMBER;
14 -----------------------------------------------------------
15 /*PROCEDURE GET_PAYROLL_REGISTER_DATA ( p_organization_id IN number,
16 p_org_structure_version_id IN number,
17 p_payroll_id IN number,
18 p_effective_char_date IN varchar2,
19 p_sort_order1 IN varchar2,
20 p_sort_order2 In varchar2,
21 p_sort_order3 IN varchar2,
22 p_output_fname OUT NOCOPY VARCHAR2);*/
23 -----------------------------------------------------------
24 PROCEDURE GET_PAYROLL_REGISTER_DATA ( p_report IN varchar2,p_organization_id IN number,
25 p_org_structure_version_id IN number,
26 p_payroll_id IN number,
27 p_effective_char_date IN varchar2,
28 p_sort_order1 IN varchar2,
29 p_sort_order2 In varchar2,
30 p_sort_order3 IN varchar2,
31 l_xfdf_blob OUT NOCOPY blob);
32 ----------------------------------------------------------------
33 Procedure fetch_pdf_blob
34 (p_report in varchar2,p_pdf_blob OUT NOCOPY blob);
35 -----------------------------------------------------------
36 /*
37 PROCEDURE WritetoXML( p_output_fname out nocopy varchar2);
38 PROCEDURE WriteXMLvalues(p_l_fp utl_file.file_type,p_tagname IN VARCHAR2, p_value IN VARCHAR2);
39 */
40 ---------------------------------------------------------
41 Procedure clob_to_blob(p_clob clob,
42 p_blob IN OUT NOCOPY Blob);
43 PROCEDURE WritetoCLOB (p_report in varchar2,
44 p_xfdf_blob out nocopy blob);
45 --
46 FUNCTION get_lookup_meaning
47 (p_lookup_type VARCHAR2
48 ,p_lookup_code VARCHAR2) RETURN VARCHAR2;
49 --
50 END PAY_KW_PAYROLL_REGISTER ;