1 PACKAGE pay_us_online_w4_xml_pkg
2 /* $Header: pyw4xmlp.pkh 120.0.12010000.1 2008/07/28 00:01:22 appldev ship $ */
3 /*
4 ******************************************************************
5 * *
6 * Copyright (C) 2005 Oracle Corporation. *
7 * All rights reserved. *
8 * *
9 * This material has been provided pursuant to an agreement *
10 * containing restrictions on its use. The material AUTHID CURRENT_USER is also *
11 * protected by copyright law. No part of this material may *
12 * be copied or distributed, transmitted or transcribed, in *
13 * any form or by any means, electronic, mechanical, magnetic, *
14 * manual, or otherwise, or disclosed to third parties without *
15 * the express written permission of Oracle Corporation, *
16 * 500 Oracle Parkway, Redwood City, CA, 94065. *
17 * *
18 ******************************************************************
19
20 Name : pay_us_online_w4_xml_pkg
21
22 Description : This package contains the procedure generate_xml to
23 generate the XML extract for Online W4 PDF
24
25 Change List
26 -----------
27 Date Name Vers Bug No Description
28 ----------- ---------- ------ ------- -------------------------
29 31-MAY-2005 rsethupa 115.0 Created
30
31 *****************************************************************
32
33 ****************************************************************************
34 Procedure Name: generate_xml
35 Description: Returns the XML extract for Online W4 PDF
36 ***************************************************************************/
37 AS
38 PROCEDURE generate_xml (
39 p_person_id IN per_people_f.person_id%TYPE,
40 p_transaction_step_id IN hr_api_transaction_steps.transaction_step_id%TYPE,
41 p_temp_dir IN VARCHAR2,
42 p_appl_short_name IN VARCHAR2,
43 p_template_code IN VARCHAR2,
44 p_default_language IN VARCHAR2,
45 p_default_territory IN VARCHAR2,
46 p_xml_string OUT NOCOPY VARCHAR2
47 );
48
49 TYPE xml_data_rec IS RECORD (
50 xml_tag VARCHAR2 (100),
51 xml_data VARCHAR2 (300)
52 );
53
54 TYPE xml_data_table IS TABLE OF xml_data_rec
55 INDEX BY BINARY_INTEGER;
56
57 l_xml_data_table xml_data_table;
58 END pay_us_online_w4_xml_pkg;