1 package BEN_EXT_XML_WRITE AUTHID CURRENT_USER as
2 /* $Header: benxxmlw.pkh 120.3.12000000.1 2007/01/19 19:34:59 appldev noship $ */
3 --------------------------------------------------------------------------------
4 /*
5 +==============================================================================+
6 | Copyright (c) 1997 Oracle Corporation |
7 | Redwood Shores, California, USA |
8 | All rights reserved. |
9 +==============================================================================+
10 Name:
11 Extract XML Write Process.
12 Purpose:
13 This process reads records from the ben_ext_rslt_dtl table and writes them
14 to a xml output file.
15 History:
16 Date Who Version What?
17 ---- --- ------- -----
18 18 Apr 2003 tjesumic 115.0 Created.
19 18 Apr 2003 tjesumic 115.0 NO COPY added.
20 13 May 2003 tjesumic 115.2 XML user defined tag enhanceenmt
21 25 Aug 2004 tjesumic 115.3 xdo integeration
22 08-Jun-2005 tjesumic 115.4 pennserver extract enhancment
23 05-Dec-2005 tjesumic 115.5 display on cm manager
24 09-Dec-2005 tjesumic 115.6 new parameter p_source added
25 */
26 -----------------------------------------------------------------------------------
27 --
28 type g_table is table of ben_ext_dfn.xml_tag_name%type
29 index by binary_integer;
30
31
32 Procedure MAIN
33 (p_output_name in varchar2,
34 p_drctry_name in varchar2,
35 p_ext_rslt_id in number,
36 p_output_type in varchar2,
37 p_xdo_template_id in number ,
38 p_cm_display_flag in varchar2 default null ,
39 p_rec_count in out NOCOPY number ,
40 p_source in varchar2 default 'BENXWRIT' ) ;
41
42
43
44 Procedure Load_tags
45 (p_tag_table in out nocopy BEN_EXT_XML_WRITE.g_table ,
46 p_tag in varchar2
47 ) ;
48
49
50
51 END; -- Package spec