DBA Data[Home] [Help]

PACKAGE: APPS.AMS_IMP_XML_ELEMENTS_PKG

Source


1 PACKAGE AMS_IMP_XML_ELEMENTS_PKG AUTHID CURRENT_USER AS
2 /* $Header: amslxels.pls 115.5 2002/11/12 23:34:27 jieli noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 --          AMS_IMP_XML_ELEMENTS_PKG
7 -- Purpose
8 --    Manage XML Elements.
9 --
10 -- History
11 --    05/13/2002 DMVINCEN  Created.
12 --
13 -- NOTE
14 --
15 -- End of Comments
16 -- ===============================================================
17 
18 PROCEDURE Insert_Row(
19           px_imp_xml_element_id   IN OUT NOCOPY NUMBER,
20           p_last_updated_by    NUMBER,
21           px_object_version_number   IN OUT NOCOPY NUMBER,
22           p_created_by    NUMBER,
23           p_last_update_login    NUMBER,
24           p_last_update_date    DATE,
25           p_creation_date    DATE,
26           p_imp_xml_document_id    NUMBER,
27           p_order_initial    NUMBER,
28           p_order_final    NUMBER,
29           p_column_name    VARCHAR2,
30           p_data    VARCHAR2,
31           p_num_attr    NUMBER,
32           p_data_type    VARCHAR2,
33           p_load_status    VARCHAR2,
34           p_error_text    VARCHAR2);
35 
36 PROCEDURE Update_Row(
37           p_imp_xml_element_id    NUMBER,
38           p_last_updated_by    NUMBER,
39           p_object_version_number    NUMBER,
40           -- p_created_by    NUMBER,
41           p_last_update_login    NUMBER,
42           p_last_update_date    DATE,
43           -- p_creation_date    DATE,
44           p_imp_xml_document_id    NUMBER,
45           p_order_initial    NUMBER,
46           p_order_final    NUMBER,
47           p_column_name    VARCHAR2,
48           p_data    VARCHAR2,
49           p_num_attr    NUMBER,
50           p_data_type    VARCHAR2,
51           p_load_status    VARCHAR2,
52           p_error_text    VARCHAR2);
53 
54 PROCEDURE Delete_Row(
55     p_IMP_XML_ELEMENT_ID  NUMBER);
56 PROCEDURE Lock_Row(
57           p_imp_xml_element_id    NUMBER,
58           p_last_updated_by    NUMBER,
59           p_object_version_number    NUMBER,
60           p_created_by    NUMBER,
61           p_last_update_login    NUMBER,
62           p_last_update_date    DATE,
63           p_creation_date    DATE,
64           p_imp_xml_document_id    NUMBER,
65           p_order_initial    NUMBER,
66           p_order_final    NUMBER,
67           p_column_name    VARCHAR2,
68           p_data    VARCHAR2,
69           p_num_attr    NUMBER,
70           p_data_type    VARCHAR2,
71           p_load_status    VARCHAR2,
72           p_error_text    VARCHAR2);
73 
74 END AMS_IMP_XML_ELEMENTS_PKG;