1 PACKAGE ICX_CAT_R12_DATA_EXCEP_RPT_PVT AUTHID CURRENT_USER AS
2 /* $Header: ICXVDERS.pls 120.4 2006/03/03 03:10 mkohale noship $*/
3
4 /**
5 ** Table containing the translatable and non-translatable
6 ** interface tables key and stored column details.
7 ** This is used as columns list in the XML Query.
8 **/
9 TYPE descriptors_list_tbl IS TABLE OF
10 VARCHAR2(18000) INDEX BY BINARY_INTEGER;
11 g_descriptors_list descriptors_list_tbl;
12
13 TYPE territories_list_rec is RECORD(iso_language varchar2(2),
14 iso_territory varchar2(2),
15 nls_language varchar2(30),
16 nls_territory varchar2(30));
17
18 TYPE territories_list IS TABLE OF territories_list_rec
19 INDEX BY VARCHAR2(4);
20 g_territories territories_list;
21
22 /**
23 ** Record that contains the Name and Value pair of the
24 ** bind parameters used in the XML Query
25 **/
26 TYPE xml_bind_param_rec IS RECORD (name VARCHAR2(50),
27 value VARCHAR2(250));
28
29 -- Array of the Bind Parameters record
30 TYPE xml_bind_params IS VARRAY(5) OF xml_bind_param_rec;
31
32 /**
33 ** Procedure : populate_catalog_files
34 ** Synopsis : Populates the catalog file in XML Format for the errored
35 ** lines
36 **
37 ** Parameter:
38 **/
39 PROCEDURE populate_catalog_files(p_interface_header_id_tbl IN DBMS_SQL.NUMBER_TABLE,
40 p_vendor_id_tbl IN DBMS_SQL.NUMBER_TABLE,
41 p_vendor_site_id_tbl IN DBMS_SQL.NUMBER_TABLE,
42 p_org_id_tbl IN DBMS_SQL.NUMBER_TABLE,
43 p_currency_code_tbl IN DBMS_SQL.VARCHAR2_TABLE,
44 p_contract_num_tbl IN DBMS_SQL.NUMBER_TABLE,
45 p_language_tbl IN DBMS_SQL.VARCHAR2_TABLE);
46
47 /**
48 ** Procedure : process_data_exceptions_report
49 ** Synopsis : Populate the icx_cat_r12_upg_excep_files and icx_cat_r12_upg_error_msgs
50 ** tables with the errored lines during data migration.
51 **
52 ** Parameter:
53 ** IN p_interface_header_id--Interface_header_id of the Erroneous Line
54 */
55 PROCEDURE process_data_exceptions_report(p_batch_id IN po_headers_interface.batch_id%TYPE);
56
57 /*
58 ** Procedure : replace_clob
59 ** Synopsis : Replaces the substring of the CLOB with
60 ** given string
61 **
62 ** Parameter:
63 ** IN p_replace_str -- String to be replaced
64 ** p_replace_with -- String to replace with
65 ** IN OUT p_src_clob -- source object
66 **/
67 PROCEDURE replace_clob(p_replace_str IN VARCHAR2,
68 p_replace_with IN CLOB,
69 p_src_clob IN OUT NOCOPY CLOB,
70 p_replace_mutliple_occurances IN BOOLEAN default true);
71
72 /**
73 ** Procedure : get_xml
74 ** Synopsis : To create an XML
75 **
76 ** Parameter:
77 ** IN l_qryString -- Query String
78 ** p_bind_params -- Bind Parameters for the XML Query
79 ** p_row_tag -- Row Tag to set, default NULL
80 ** p_row_settag -- Row SetTag to set, default NULL
81 ** Retruns XML object.
82 **/
83 FUNCTION get_xml(p_qryString IN VARCHAR2,
84 p_bind_params IN xml_bind_params,
85 p_row_tag IN VARCHAR2 default NULL,
86 p_row_settag IN VARCHAR2 default NULL)
87 RETURN CLOB;
88
89 END ICX_CAT_R12_DATA_EXCEP_RPT_PVT;