67:
68: --===================================================================
69: TYPE xml_element_rec_type IS RECORD
70: (
71: imp_xml_element_id NUMBER := FND_API.G_MISS_NUM,
72: last_updated_by NUMBER := FND_API.G_MISS_NUM,
73: object_version_number NUMBER := FND_API.G_MISS_NUM,
74: created_by NUMBER := FND_API.G_MISS_NUM,
75: last_update_login NUMBER := FND_API.G_MISS_NUM,
68: --===================================================================
69: TYPE xml_element_rec_type IS RECORD
70: (
71: imp_xml_element_id NUMBER := FND_API.G_MISS_NUM,
72: last_updated_by NUMBER := FND_API.G_MISS_NUM,
73: object_version_number NUMBER := FND_API.G_MISS_NUM,
74: created_by NUMBER := FND_API.G_MISS_NUM,
75: last_update_login NUMBER := FND_API.G_MISS_NUM,
76: last_update_date DATE := FND_API.G_MISS_DATE,
69: TYPE xml_element_rec_type IS RECORD
70: (
71: imp_xml_element_id NUMBER := FND_API.G_MISS_NUM,
72: last_updated_by NUMBER := FND_API.G_MISS_NUM,
73: object_version_number NUMBER := FND_API.G_MISS_NUM,
74: created_by NUMBER := FND_API.G_MISS_NUM,
75: last_update_login NUMBER := FND_API.G_MISS_NUM,
76: last_update_date DATE := FND_API.G_MISS_DATE,
77: creation_date DATE := FND_API.G_MISS_DATE,
70: (
71: imp_xml_element_id NUMBER := FND_API.G_MISS_NUM,
72: last_updated_by NUMBER := FND_API.G_MISS_NUM,
73: object_version_number NUMBER := FND_API.G_MISS_NUM,
74: created_by NUMBER := FND_API.G_MISS_NUM,
75: last_update_login NUMBER := FND_API.G_MISS_NUM,
76: last_update_date DATE := FND_API.G_MISS_DATE,
77: creation_date DATE := FND_API.G_MISS_DATE,
78: imp_xml_document_id NUMBER := FND_API.G_MISS_NUM,
71: imp_xml_element_id NUMBER := FND_API.G_MISS_NUM,
72: last_updated_by NUMBER := FND_API.G_MISS_NUM,
73: object_version_number NUMBER := FND_API.G_MISS_NUM,
74: created_by NUMBER := FND_API.G_MISS_NUM,
75: last_update_login NUMBER := FND_API.G_MISS_NUM,
76: last_update_date DATE := FND_API.G_MISS_DATE,
77: creation_date DATE := FND_API.G_MISS_DATE,
78: imp_xml_document_id NUMBER := FND_API.G_MISS_NUM,
79: order_initial NUMBER := FND_API.G_MISS_NUM,
72: last_updated_by NUMBER := FND_API.G_MISS_NUM,
73: object_version_number NUMBER := FND_API.G_MISS_NUM,
74: created_by NUMBER := FND_API.G_MISS_NUM,
75: last_update_login NUMBER := FND_API.G_MISS_NUM,
76: last_update_date DATE := FND_API.G_MISS_DATE,
77: creation_date DATE := FND_API.G_MISS_DATE,
78: imp_xml_document_id NUMBER := FND_API.G_MISS_NUM,
79: order_initial NUMBER := FND_API.G_MISS_NUM,
80: order_final NUMBER := FND_API.G_MISS_NUM,
73: object_version_number NUMBER := FND_API.G_MISS_NUM,
74: created_by NUMBER := FND_API.G_MISS_NUM,
75: last_update_login NUMBER := FND_API.G_MISS_NUM,
76: last_update_date DATE := FND_API.G_MISS_DATE,
77: creation_date DATE := FND_API.G_MISS_DATE,
78: imp_xml_document_id NUMBER := FND_API.G_MISS_NUM,
79: order_initial NUMBER := FND_API.G_MISS_NUM,
80: order_final NUMBER := FND_API.G_MISS_NUM,
81: column_name VARCHAR2(2000) := FND_API.G_MISS_CHAR,
74: created_by NUMBER := FND_API.G_MISS_NUM,
75: last_update_login NUMBER := FND_API.G_MISS_NUM,
76: last_update_date DATE := FND_API.G_MISS_DATE,
77: creation_date DATE := FND_API.G_MISS_DATE,
78: imp_xml_document_id NUMBER := FND_API.G_MISS_NUM,
79: order_initial NUMBER := FND_API.G_MISS_NUM,
80: order_final NUMBER := FND_API.G_MISS_NUM,
81: column_name VARCHAR2(2000) := FND_API.G_MISS_CHAR,
82: data VARCHAR2(2000) := FND_API.G_MISS_CHAR,
75: last_update_login NUMBER := FND_API.G_MISS_NUM,
76: last_update_date DATE := FND_API.G_MISS_DATE,
77: creation_date DATE := FND_API.G_MISS_DATE,
78: imp_xml_document_id NUMBER := FND_API.G_MISS_NUM,
79: order_initial NUMBER := FND_API.G_MISS_NUM,
80: order_final NUMBER := FND_API.G_MISS_NUM,
81: column_name VARCHAR2(2000) := FND_API.G_MISS_CHAR,
82: data VARCHAR2(2000) := FND_API.G_MISS_CHAR,
83: num_attr NUMBER := FND_API.G_MISS_NUM,
76: last_update_date DATE := FND_API.G_MISS_DATE,
77: creation_date DATE := FND_API.G_MISS_DATE,
78: imp_xml_document_id NUMBER := FND_API.G_MISS_NUM,
79: order_initial NUMBER := FND_API.G_MISS_NUM,
80: order_final NUMBER := FND_API.G_MISS_NUM,
81: column_name VARCHAR2(2000) := FND_API.G_MISS_CHAR,
82: data VARCHAR2(2000) := FND_API.G_MISS_CHAR,
83: num_attr NUMBER := FND_API.G_MISS_NUM,
84: data_type VARCHAR2(1) := FND_API.G_MISS_CHAR,
77: creation_date DATE := FND_API.G_MISS_DATE,
78: imp_xml_document_id NUMBER := FND_API.G_MISS_NUM,
79: order_initial NUMBER := FND_API.G_MISS_NUM,
80: order_final NUMBER := FND_API.G_MISS_NUM,
81: column_name VARCHAR2(2000) := FND_API.G_MISS_CHAR,
82: data VARCHAR2(2000) := FND_API.G_MISS_CHAR,
83: num_attr NUMBER := FND_API.G_MISS_NUM,
84: data_type VARCHAR2(1) := FND_API.G_MISS_CHAR,
85: load_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: imp_xml_document_id NUMBER := FND_API.G_MISS_NUM,
79: order_initial NUMBER := FND_API.G_MISS_NUM,
80: order_final NUMBER := FND_API.G_MISS_NUM,
81: column_name VARCHAR2(2000) := FND_API.G_MISS_CHAR,
82: data VARCHAR2(2000) := FND_API.G_MISS_CHAR,
83: num_attr NUMBER := FND_API.G_MISS_NUM,
84: data_type VARCHAR2(1) := FND_API.G_MISS_CHAR,
85: load_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: error_text VARCHAR2(250) := FND_API.G_MISS_CHAR
79: order_initial NUMBER := FND_API.G_MISS_NUM,
80: order_final NUMBER := FND_API.G_MISS_NUM,
81: column_name VARCHAR2(2000) := FND_API.G_MISS_CHAR,
82: data VARCHAR2(2000) := FND_API.G_MISS_CHAR,
83: num_attr NUMBER := FND_API.G_MISS_NUM,
84: data_type VARCHAR2(1) := FND_API.G_MISS_CHAR,
85: load_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: error_text VARCHAR2(250) := FND_API.G_MISS_CHAR
87: );
80: order_final NUMBER := FND_API.G_MISS_NUM,
81: column_name VARCHAR2(2000) := FND_API.G_MISS_CHAR,
82: data VARCHAR2(2000) := FND_API.G_MISS_CHAR,
83: num_attr NUMBER := FND_API.G_MISS_NUM,
84: data_type VARCHAR2(1) := FND_API.G_MISS_CHAR,
85: load_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: error_text VARCHAR2(250) := FND_API.G_MISS_CHAR
87: );
88:
81: column_name VARCHAR2(2000) := FND_API.G_MISS_CHAR,
82: data VARCHAR2(2000) := FND_API.G_MISS_CHAR,
83: num_attr NUMBER := FND_API.G_MISS_NUM,
84: data_type VARCHAR2(1) := FND_API.G_MISS_CHAR,
85: load_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: error_text VARCHAR2(250) := FND_API.G_MISS_CHAR
87: );
88:
89: g_miss_xml_element_rec xml_element_rec_type;
82: data VARCHAR2(2000) := FND_API.G_MISS_CHAR,
83: num_attr NUMBER := FND_API.G_MISS_NUM,
84: data_type VARCHAR2(1) := FND_API.G_MISS_CHAR,
85: load_status VARCHAR2(30) := FND_API.G_MISS_CHAR,
86: error_text VARCHAR2(250) := FND_API.G_MISS_CHAR
87: );
88:
89: g_miss_xml_element_rec xml_element_rec_type;
90: TYPE xml_element_tbl_type IS TABLE OF xml_element_rec_type INDEX BY BINARY_INTEGER;
102: -- Parameters
103: --
104: -- IN
105: -- p_api_version_number IN NUMBER Required
106: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
107: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
108: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
109: -- p_xml_element_rec IN xml_element_rec_type Required
110: --
103: --
104: -- IN
105: -- p_api_version_number IN NUMBER Required
106: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
107: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
108: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
109: -- p_xml_element_rec IN xml_element_rec_type Required
110: --
111: -- OUT
104: -- IN
105: -- p_api_version_number IN NUMBER Required
106: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
107: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
108: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
109: -- p_xml_element_rec IN xml_element_rec_type Required
110: --
111: -- OUT
112: -- x_return_status OUT VARCHAR2
121: --
122:
123: PROCEDURE Create_Xml_Element(
124: p_api_version_number IN NUMBER,
125: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
126: p_commit IN VARCHAR2 := FND_API.G_FALSE,
127: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
128:
129: x_return_status OUT NOCOPY VARCHAR2,
122:
123: PROCEDURE Create_Xml_Element(
124: p_api_version_number IN NUMBER,
125: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
126: p_commit IN VARCHAR2 := FND_API.G_FALSE,
127: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
128:
129: x_return_status OUT NOCOPY VARCHAR2,
130: x_msg_count OUT NOCOPY NUMBER,
123: PROCEDURE Create_Xml_Element(
124: p_api_version_number IN NUMBER,
125: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
126: p_commit IN VARCHAR2 := FND_API.G_FALSE,
127: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
128:
129: x_return_status OUT NOCOPY VARCHAR2,
130: x_msg_count OUT NOCOPY NUMBER,
131: x_msg_data OUT NOCOPY VARCHAR2,
146: -- Parameters
147: --
148: -- IN
149: -- p_api_version_number IN NUMBER Required
150: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
151: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
152: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
153: -- p_xml_element_rec IN xml_element_rec_type Required
154: --
147: --
148: -- IN
149: -- p_api_version_number IN NUMBER Required
150: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
151: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
152: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
153: -- p_xml_element_rec IN xml_element_rec_type Required
154: --
155: -- OUT
148: -- IN
149: -- p_api_version_number IN NUMBER Required
150: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
151: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
152: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
153: -- p_xml_element_rec IN xml_element_rec_type Required
154: --
155: -- OUT
156: -- x_return_status OUT VARCHAR2
165: --
166:
167: PROCEDURE Update_Error_Xml_Element (
168: p_api_version_number IN NUMBER,
169: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
170: p_commit IN VARCHAR2 := FND_API.G_FALSE,
171: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
172: p_xml_element_rec IN xml_element_rec_type,
173: p_xml_element_ids IN num_data_set_type_w,
166:
167: PROCEDURE Update_Error_Xml_Element (
168: p_api_version_number IN NUMBER,
169: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
170: p_commit IN VARCHAR2 := FND_API.G_FALSE,
171: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
172: p_xml_element_rec IN xml_element_rec_type,
173: p_xml_element_ids IN num_data_set_type_w,
174: p_xml_elements_data IN varchar2_2000_set_type,
167: PROCEDURE Update_Error_Xml_Element (
168: p_api_version_number IN NUMBER,
169: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
170: p_commit IN VARCHAR2 := FND_API.G_FALSE,
171: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
172: p_xml_element_rec IN xml_element_rec_type,
173: p_xml_element_ids IN num_data_set_type_w,
174: p_xml_elements_data IN varchar2_2000_set_type,
175: p_xml_elements_col_name IN varchar2_2000_set_type,
193: -- Parameters
194: --
195: -- IN
196: -- p_api_version_number IN NUMBER Required
197: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
198: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
199: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
200: -- p_xml_element_rec IN xml_element_rec_type Required
201: --
194: --
195: -- IN
196: -- p_api_version_number IN NUMBER Required
197: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
198: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
199: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
200: -- p_xml_element_rec IN xml_element_rec_type Required
201: --
202: -- OUT
195: -- IN
196: -- p_api_version_number IN NUMBER Required
197: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
198: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
199: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
200: -- p_xml_element_rec IN xml_element_rec_type Required
201: --
202: -- OUT
203: -- x_return_status OUT VARCHAR2
212: --
213:
214: PROCEDURE Update_Xml_Element(
215: p_api_version_number IN NUMBER,
216: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
217: p_commit IN VARCHAR2 := FND_API.G_FALSE,
218: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
219:
220: x_return_status OUT NOCOPY VARCHAR2,
213:
214: PROCEDURE Update_Xml_Element(
215: p_api_version_number IN NUMBER,
216: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
217: p_commit IN VARCHAR2 := FND_API.G_FALSE,
218: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
219:
220: x_return_status OUT NOCOPY VARCHAR2,
221: x_msg_count OUT NOCOPY NUMBER,
214: PROCEDURE Update_Xml_Element(
215: p_api_version_number IN NUMBER,
216: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
217: p_commit IN VARCHAR2 := FND_API.G_FALSE,
218: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
219:
220: x_return_status OUT NOCOPY VARCHAR2,
221: x_msg_count OUT NOCOPY NUMBER,
222: x_msg_data OUT NOCOPY VARCHAR2,
237: -- Parameters
238: --
239: -- IN
240: -- p_api_version_number IN NUMBER Required
241: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
242: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
243: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
244: -- p_IMP_XML_ELEMENT_ID IN NUMBER
245: -- p_object_version_number IN NUMBER Optional Default = NULL
238: --
239: -- IN
240: -- p_api_version_number IN NUMBER Required
241: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
242: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
243: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
244: -- p_IMP_XML_ELEMENT_ID IN NUMBER
245: -- p_object_version_number IN NUMBER Optional Default = NULL
246: --
239: -- IN
240: -- p_api_version_number IN NUMBER Required
241: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
242: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
243: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
244: -- p_IMP_XML_ELEMENT_ID IN NUMBER
245: -- p_object_version_number IN NUMBER Optional Default = NULL
246: --
247: -- OUT
257: --
258:
259: PROCEDURE Delete_Xml_Element(
260: p_api_version_number IN NUMBER,
261: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
262: p_commit IN VARCHAR2 := FND_API.G_FALSE,
263: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
264: x_return_status OUT NOCOPY VARCHAR2,
265: x_msg_count OUT NOCOPY NUMBER,
258:
259: PROCEDURE Delete_Xml_Element(
260: p_api_version_number IN NUMBER,
261: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
262: p_commit IN VARCHAR2 := FND_API.G_FALSE,
263: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
264: x_return_status OUT NOCOPY VARCHAR2,
265: x_msg_count OUT NOCOPY NUMBER,
266: x_msg_data OUT NOCOPY VARCHAR2,
259: PROCEDURE Delete_Xml_Element(
260: p_api_version_number IN NUMBER,
261: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
262: p_commit IN VARCHAR2 := FND_API.G_FALSE,
263: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
264: x_return_status OUT NOCOPY VARCHAR2,
265: x_msg_count OUT NOCOPY NUMBER,
266: x_msg_data OUT NOCOPY VARCHAR2,
267: p_imp_xml_element_id IN NUMBER,
280: -- Parameters
281: --
282: -- IN
283: -- p_api_version_number IN NUMBER Required
284: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
285: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
286: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
287: -- p_xml_element_rec IN xml_element_rec_type Required
288: --
281: --
282: -- IN
283: -- p_api_version_number IN NUMBER Required
284: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
285: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
286: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
287: -- p_xml_element_rec IN xml_element_rec_type Required
288: --
289: -- OUT
282: -- IN
283: -- p_api_version_number IN NUMBER Required
284: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
285: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
286: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
287: -- p_xml_element_rec IN xml_element_rec_type Required
288: --
289: -- OUT
290: -- x_return_status OUT VARCHAR2
299: --
300:
301: PROCEDURE Lock_Xml_Element(
302: p_api_version_number IN NUMBER,
303: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
304:
305: x_return_status OUT NOCOPY VARCHAR2,
306: x_msg_count OUT NOCOPY NUMBER,
307: x_msg_data OUT NOCOPY VARCHAR2,
323: -- End of Comments
324:
325: PROCEDURE Validate_xml_element(
326: p_api_version_number IN NUMBER,
327: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
328: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
329: p_xml_element_rec IN xml_element_rec_type,
330: p_validation_mode IN VARCHAR2,
331: x_return_status OUT NOCOPY VARCHAR2,
324:
325: PROCEDURE Validate_xml_element(
326: p_api_version_number IN NUMBER,
327: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
328: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
329: p_xml_element_rec IN xml_element_rec_type,
330: p_validation_mode IN VARCHAR2,
331: x_return_status OUT NOCOPY VARCHAR2,
332: x_msg_count OUT NOCOPY NUMBER,
362: -- End of Comments
363:
364: PROCEDURE Validate_xml_element_rec(
365: p_api_version_number IN NUMBER,
366: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
367: x_return_status OUT NOCOPY VARCHAR2,
368: x_msg_count OUT NOCOPY NUMBER,
369: x_msg_data OUT NOCOPY VARCHAR2,
370: p_xml_element_rec IN xml_element_rec_type