eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_IMPORT_XML_PVT dependencies on AMS_IMP_XML_ELEMENTS

Line 39: FROM ams_imp_xml_elements e3

35: l_children rc_type;
36: BEGIN
37: OPEN l_children FOR
38: SELECT e3.*
39: FROM ams_imp_xml_elements e3
40: START WITH e3.imp_xml_document_id = p_imp_doc_id
41: AND e3.order_initial = p_order_initial + 1
42: CONNECT BY e3.imp_xml_document_id = p_imp_doc_id
43: AND PRIOR order_final + 1 = order_initial;

Line 49: x_element_info OUT NOCOPY AMS_IMP_XML_ELEMENTS%ROWTYPE

45: END Get_Children_Cursor;
46:
47: PROCEDURE Get_Element_Info (
48: p_element_id IN NUMBER,
49: x_element_info OUT NOCOPY AMS_IMP_XML_ELEMENTS%ROWTYPE
50: )
51: IS
52: CURSOR c_get_element (p_imp_xml_element_id NUMBER) IS
53: SELECT *

Line 54: FROM ams_imp_xml_elements

50: )
51: IS
52: CURSOR c_get_element (p_imp_xml_element_id NUMBER) IS
53: SELECT *
54: FROM ams_imp_xml_elements
55: WHERE IMP_XML_ELEMENT_ID = p_imp_xml_element_id;
56: BEGIN
57: OPEN c_get_element (p_element_id);
58: FETCH c_get_element INTO x_element_info;

Line 160: FROM AMS_IMP_XML_ELEMENTS

156: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| L_API_NAME;
157:
158: CURSOR c_element_info (p_xml_element_id NUMBER)
159: IS SELECT ORDER_INITIAL, ORDER_FINAL
160: FROM AMS_IMP_XML_ELEMENTS
161: WHERE IMP_XML_ELEMENT_ID = p_xml_element_id;
162:
163: l_element_info c_element_info%ROWTYPE;
164: BEGIN

Line 203: -- "AMS_IMP_XML_ELEMENTS" table, given the

199: -- API Name Get_File_Type
200: -- Type Public
201: -- Pre-reqs None.
202: -- Function Retrieve the information for the root node in the
203: -- "AMS_IMP_XML_ELEMENTS" table, given the
204: -- "import_list_header_id".
205: -- Parameters
206: -- IN
207: -- p_import_list_header_id NUMBER Required

Line 208: -- OUT x_node_rec AMS_IMP_XML_ELEMENTS%ROWTYPE

204: -- "import_list_header_id".
205: -- Parameters
206: -- IN
207: -- p_import_list_header_id NUMBER Required
208: -- OUT x_node_rec AMS_IMP_XML_ELEMENTS%ROWTYPE
209: -- x_return_status VARCHAR2
210: --
211: -- Version Current version: 1.0
212: -- Previous version: 1.0

Line 261: -- "AMS_IMP_XML_ELEMENTS" table, given the

257: -- API Name Get_Root_Node
258: -- Type Public
259: -- Pre-reqs None.
260: -- Function Retrieve the information for the root node in the
261: -- "AMS_IMP_XML_ELEMENTS" table, given the
262: -- "import_list_header_id".
263: -- Parameters
264: -- IN
265: -- p_import_list_header_id NUMBER Required

Line 266: -- OUT x_node_rec AMS_IMP_XML_ELEMENTS%ROWTYPE

262: -- "import_list_header_id".
263: -- Parameters
264: -- IN
265: -- p_import_list_header_id NUMBER Required
266: -- OUT x_node_rec AMS_IMP_XML_ELEMENTS%ROWTYPE
267: -- x_return_status VARCHAR2
268: --
269: -- Version Current version: 1.0
270: -- Previous version: 1.0

Line 275: x_node_rec OUT NOCOPY AMS_IMP_XML_ELEMENTS%ROWTYPE,

271: -- Initial version: 1.0
272: -- End of comments
273: PROCEDURE Get_Root_Node (
274: p_import_list_header_id IN NUMBER,
275: x_node_rec OUT NOCOPY AMS_IMP_XML_ELEMENTS%ROWTYPE,
276: x_return_status OUT NOCOPY VARCHAR2,
277: x_msg_data OUT NOCOPY VARCHAR2
278: )
279: IS

Line 285: FROM AMS_IMP_XML_ELEMENTS

281: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| L_API_NAME;
282:
283: CURSOR c_root_node_rec (p_import_list_header_id NUMBER) IS
284: SELECT *
285: FROM AMS_IMP_XML_ELEMENTS
286: WHERE ORDER_INITIAL = G_ORDER_INITIAL_START_NUMBER
287: AND EXISTS (SELECT 1
288: FROM AMS_IMP_DOCUMENTS
289: WHERE AMS_IMP_DOCUMENTS.IMPORT_LIST_HEADER_ID = p_import_list_header_id

Line 290: AND AMS_IMP_DOCUMENTS.IMP_DOCUMENT_ID = AMS_IMP_XML_ELEMENTS.IMP_XML_DOCUMENT_ID);

286: WHERE ORDER_INITIAL = G_ORDER_INITIAL_START_NUMBER
287: AND EXISTS (SELECT 1
288: FROM AMS_IMP_DOCUMENTS
289: WHERE AMS_IMP_DOCUMENTS.IMPORT_LIST_HEADER_ID = p_import_list_header_id
290: AND AMS_IMP_DOCUMENTS.IMP_DOCUMENT_ID = AMS_IMP_XML_ELEMENTS.IMP_XML_DOCUMENT_ID);
291: BEGIN
292:
293: --
294: -- Initialize API return status to success.

Line 322: -- "AMS_IMP_XML_ELEMENTS" table, given the node id

318: -- API Name Get_First_Child_Node
319: -- Type Public
320: -- Pre-reqs None.
321: -- Function Retrieve the information for the first child node in the
322: -- "AMS_IMP_XML_ELEMENTS" table, given the node id
323: -- Parameters
324: -- IN
325: -- p_imp_xml_element_id NUMBER Required
326: -- OUT x_node_rec AMS_IMP_XML_ELEMENTS%ROWTYPE

Line 326: -- OUT x_node_rec AMS_IMP_XML_ELEMENTS%ROWTYPE

322: -- "AMS_IMP_XML_ELEMENTS" table, given the node id
323: -- Parameters
324: -- IN
325: -- p_imp_xml_element_id NUMBER Required
326: -- OUT x_node_rec AMS_IMP_XML_ELEMENTS%ROWTYPE
327: -- x_return_status VARCHAR2
328: --
329: -- Version Current version: 1.0
330: -- Previous version: 1.0

Line 335: x_node_rec OUT NOCOPY AMS_IMP_XML_ELEMENTS%ROWTYPE,

331: -- Initial version: 1.0
332: -- End of comments
333: PROCEDURE Get_First_Child_Node (
334: p_imp_xml_element_id IN NUMBER,
335: x_node_rec OUT NOCOPY AMS_IMP_XML_ELEMENTS%ROWTYPE,
336: x_return_status OUT NOCOPY VARCHAR2,
337: x_msg_data OUT NOCOPY VARCHAR2
338: )
339: IS

Line 347: FROM AMS_IMP_XML_ELEMENTS

343: CURSOR c_xml_element (p_xml_element_id NUMBER) IS
344: SELECT IMP_XML_ELEMENT_ID,
345: IMP_XML_DOCUMENT_ID,
346: ORDER_INITIAL
347: FROM AMS_IMP_XML_ELEMENTS
348: WHERE IMP_XML_ELEMENT_ID = p_xml_element_id;
349:
350: CURSOR c_xml_first_child_element (p_xml_doc_id NUMBER, p_order_initial NUMBER) IS
351: SELECT *

Line 352: FROM AMS_IMP_XML_ELEMENTS

348: WHERE IMP_XML_ELEMENT_ID = p_xml_element_id;
349:
350: CURSOR c_xml_first_child_element (p_xml_doc_id NUMBER, p_order_initial NUMBER) IS
351: SELECT *
352: FROM AMS_IMP_XML_ELEMENTS
353: WHERE IMP_XML_DOCUMENT_ID = p_xml_doc_id
354: AND ORDER_INITIAL = p_order_initial + 1;
355:
356: l_xml_element_rec c_xml_element%ROWTYPE;

Line 395: -- "AMS_IMP_XML_ELEMENTS" table, given the node id

391: -- API Name Get_Next_Sibling_Node
392: -- Type Public
393: -- Pre-reqs None.
394: -- Function Retrieve the information for the first child node in the
395: -- "AMS_IMP_XML_ELEMENTS" table, given the node id
396: -- Parameters
397: -- IN
398: -- p_imp_xml_element_id NUMBER Required
399: -- OUT x_node_rec AMS_IMP_XML_ELEMENTS%ROWTYPE

Line 399: -- OUT x_node_rec AMS_IMP_XML_ELEMENTS%ROWTYPE

395: -- "AMS_IMP_XML_ELEMENTS" table, given the node id
396: -- Parameters
397: -- IN
398: -- p_imp_xml_element_id NUMBER Required
399: -- OUT x_node_rec AMS_IMP_XML_ELEMENTS%ROWTYPE
400: -- x_return_status VARCHAR2
401: --
402: -- Version Current version: 1.0
403: -- Previous version: 1.0

Line 408: x_node_rec OUT NOCOPY AMS_IMP_XML_ELEMENTS%ROWTYPE,

404: -- Initial version: 1.0
405: -- End of comments
406: PROCEDURE Get_Next_Sibling_Node (
407: p_imp_xml_element_id IN NUMBER,
408: x_node_rec OUT NOCOPY AMS_IMP_XML_ELEMENTS%ROWTYPE,
409: x_return_status OUT NOCOPY VARCHAR2,
410: x_msg_data OUT NOCOPY VARCHAR2
411: )
412: IS

Line 420: FROM AMS_IMP_XML_ELEMENTS

416: CURSOR c_xml_element (p_xml_element_id NUMBER) IS
417: SELECT IMP_XML_ELEMENT_ID,
418: IMP_XML_DOCUMENT_ID,
419: ORDER_FINAL
420: FROM AMS_IMP_XML_ELEMENTS
421: WHERE IMP_XML_ELEMENT_ID = p_xml_element_id;
422:
423: CURSOR c_xml_next_sibling_element (p_xml_doc_id NUMBER,
424: p_order_final NUMBER) IS

Line 426: FROM AMS_IMP_XML_ELEMENTS

422:
423: CURSOR c_xml_next_sibling_element (p_xml_doc_id NUMBER,
424: p_order_final NUMBER) IS
425: SELECT *
426: FROM AMS_IMP_XML_ELEMENTS
427: WHERE IMP_XML_DOCUMENT_ID = p_xml_doc_id
428: AND ORDER_INITIAL = p_order_final + 1;
429:
430: l_xml_element_rec c_xml_element%ROWTYPE;

Line 468: -- "AMS_IMP_XML_ELEMENTS" table, given the node id

464: -- API Name Get_Parent_Node
465: -- Type Public
466: -- Pre-reqs None.
467: -- Function Retrieve the information for the parent node in the
468: -- "AMS_IMP_XML_ELEMENTS" table, given the node id
469: -- Parameters
470: -- IN
471: -- p_imp_xml_element_id NUMBER Required
472: -- OUT x_node_rec AMS_IMP_XML_ELEMENTS%ROWTYPE

Line 472: -- OUT x_node_rec AMS_IMP_XML_ELEMENTS%ROWTYPE

468: -- "AMS_IMP_XML_ELEMENTS" table, given the node id
469: -- Parameters
470: -- IN
471: -- p_imp_xml_element_id NUMBER Required
472: -- OUT x_node_rec AMS_IMP_XML_ELEMENTS%ROWTYPE
473: -- x_return_status VARCHAR2
474: --
475: -- Version Current version: 1.0
476: -- Previous version: 1.0

Line 481: x_node_rec OUT NOCOPY AMS_IMP_XML_ELEMENTS%ROWTYPE,

477: -- Initial version: 1.0
478: -- End of comments
479: PROCEDURE Get_Parent_Node (
480: p_imp_xml_element_id IN NUMBER,
481: x_node_rec OUT NOCOPY AMS_IMP_XML_ELEMENTS%ROWTYPE,
482: x_return_status OUT NOCOPY VARCHAR2,
483: x_msg_data OUT NOCOPY VARCHAR2
484: )
485: IS

Line 494: FROM AMS_IMP_XML_ELEMENTS

490: SELECT IMP_XML_ELEMENT_ID,
491: IMP_XML_DOCUMENT_ID,
492: ORDER_INITIAL,
493: ORDER_FINAL
494: FROM AMS_IMP_XML_ELEMENTS
495: WHERE IMP_XML_ELEMENT_ID = p_xml_element_id;
496:
497: CURSOR c_xml_parent_element (p_xml_doc_id NUMBER,
498: p_order_initial NUMBER,

Line 501: FROM AMS_IMP_XML_ELEMENTS

497: CURSOR c_xml_parent_element (p_xml_doc_id NUMBER,
498: p_order_initial NUMBER,
499: p_order_final NUMBER) IS
500: SELECT *
501: FROM AMS_IMP_XML_ELEMENTS
502: WHERE IMP_XML_DOCUMENT_ID = p_xml_doc_id
503: --AND ORDER_INITIAL < p_order_initial
504: --AND ORDER_FINAL > p_order_final
505: AND ORDER_INITIAL =

Line 507: FROM AMS_IMP_XML_ELEMENTS e2

503: --AND ORDER_INITIAL < p_order_initial
504: --AND ORDER_FINAL > p_order_final
505: AND ORDER_INITIAL =
506: (SELECT MAX(ORDER_INITIAL)
507: FROM AMS_IMP_XML_ELEMENTS e2
508: WHERE e2.IMP_XML_DOCUMENT_ID = p_xml_doc_id
509: AND e2.ORDER_INITIAL < p_order_initial
510: AND e2.ORDER_FINAL > p_order_final);
511: l_xml_element_rec c_xml_element%ROWTYPE;

Line 567: l_parent_node_rec AMS_IMP_XML_ELEMENTS%ROWTYPE;

563: )
564: IS
565: L_API_NAME CONSTANT VARCHAR2(30) := 'Get_Error_Info';
566: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| L_API_NAME;
567: l_parent_node_rec AMS_IMP_XML_ELEMENTS%ROWTYPE;
568:
569: CURSOR c_error_xml_element (p_xml_element_id NUMBER) IS
570: SELECT IMP_XML_ELEMENT_ID,
571: COLUMN_NAME,

Line 573: FROM AMS_IMP_XML_ELEMENTS

569: CURSOR c_error_xml_element (p_xml_element_id NUMBER) IS
570: SELECT IMP_XML_ELEMENT_ID,
571: COLUMN_NAME,
572: DATA
573: FROM AMS_IMP_XML_ELEMENTS
574: WHERE IMP_XML_ELEMENT_ID = p_xml_element_id;
575: l_error_info c_error_xml_element%ROWTYPE;
576: l_column_name AMS_IMP_XML_ELEMENTS.COLUMN_NAME%TYPE;
577: l_data AMS_IMP_XML_ELEMENTS.DATA%TYPE;

Line 576: l_column_name AMS_IMP_XML_ELEMENTS.COLUMN_NAME%TYPE;

572: DATA
573: FROM AMS_IMP_XML_ELEMENTS
574: WHERE IMP_XML_ELEMENT_ID = p_xml_element_id;
575: l_error_info c_error_xml_element%ROWTYPE;
576: l_column_name AMS_IMP_XML_ELEMENTS.COLUMN_NAME%TYPE;
577: l_data AMS_IMP_XML_ELEMENTS.DATA%TYPE;
578: l_element_id NUMBER;
579: BEGIN
580: --

Line 577: l_data AMS_IMP_XML_ELEMENTS.DATA%TYPE;

573: FROM AMS_IMP_XML_ELEMENTS
574: WHERE IMP_XML_ELEMENT_ID = p_xml_element_id;
575: l_error_info c_error_xml_element%ROWTYPE;
576: l_column_name AMS_IMP_XML_ELEMENTS.COLUMN_NAME%TYPE;
577: l_data AMS_IMP_XML_ELEMENTS.DATA%TYPE;
578: l_element_id NUMBER;
579: BEGIN
580: --
581: -- Initialize API return status to success.

Line 640: -- "AMS_IMP_XML_ELEMENTS" table, given the node id

636: -- API Name Get_Children_Nodes
637: -- Type Public
638: -- Pre-reqs None.
639: -- Function Retrieve the information for all child nodes in the
640: -- "AMS_IMP_XML_ELEMENTS" table, given the node id
641: -- Parameters
642: -- IN
643: -- p_imp_xml_element_id NUMBER Required
644: -- OUT x_node_rec AMS_IMP_XML_ELEMENTS%ROWTYPE

Line 644: -- OUT x_node_rec AMS_IMP_XML_ELEMENTS%ROWTYPE

640: -- "AMS_IMP_XML_ELEMENTS" table, given the node id
641: -- Parameters
642: -- IN
643: -- p_imp_xml_element_id NUMBER Required
644: -- OUT x_node_rec AMS_IMP_XML_ELEMENTS%ROWTYPE
645: -- x_return_status VARCHAR2
646: --
647: -- Version Current version: 1.0
648: -- Previous version: 1.0

Line 661: --l_child_node_rec AMS_IMP_XML_ELEMENTS%ROWTYPE;

657: IS
658: L_API_NAME CONSTANT VARCHAR2(30) := 'Get_Children_Nodes';
659: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| L_API_NAME;
660:
661: --l_child_node_rec AMS_IMP_XML_ELEMENTS%ROWTYPE;
662:
663: l_return_status VARCHAR2(1);
664: l_msg_data VARCHAR2(4000);
665: l_child_count NUMBER := 1;

Line 666: l_element_rec AMS_IMP_XML_ELEMENTS%ROWTYPE;

662:
663: l_return_status VARCHAR2(1);
664: l_msg_data VARCHAR2(4000);
665: l_child_count NUMBER := 1;
666: l_element_rec AMS_IMP_XML_ELEMENTS%ROWTYPE;
667:
668: rc_child_set rc_type;
669: l_child rc_child_set%ROWTYPE;
670: BEGIN

Line 718: -- "AMS_IMP_XML_ELEMENTS" table, given the node id

714: -- API Name Get_Children_Nodes
715: -- Type Public
716: -- Pre-reqs None.
717: -- Function Retrieve the information for all child nodes in the
718: -- "AMS_IMP_XML_ELEMENTS" table, given the node id
719: -- Parameters
720: -- IN
721: -- p_imp_xml_element_id NUMBER Required
722: -- OUT x_child_set xml_element_set_type

Line 742: l_element_rec AMS_IMP_XML_ELEMENTS%ROWTYPE;

738:
739: l_return_status VARCHAR2(1);
740: l_msg_data VARCHAR2(4000);
741: l_child_count NUMBER := 1;
742: l_element_rec AMS_IMP_XML_ELEMENTS%ROWTYPE;
743: rc_child_set rc_type;
744: l_child rc_child_set%ROWTYPE;
745: BEGIN
746:

Line 793: -- "AMS_IMP_XML_ELEMENTS" table, given the node id

789: -- API Name Get_Children_Nodes
790: -- Type Public
791: -- Pre-reqs None.
792: -- Function Retrieve the information for all child nodes in the
793: -- "AMS_IMP_XML_ELEMENTS" table, given the node id
794: -- Parameters
795: -- IN
796: -- p_imp_xml_element_id NUMBER Required
797: -- OUT x_child_set xml_element_set_type

Line 817: l_element_rec AMS_IMP_XML_ELEMENTS%ROWTYPE;

813:
814: l_return_status VARCHAR2(1);
815: l_msg_data VARCHAR2(4000);
816: l_child_count NUMBER := 1;
817: l_element_rec AMS_IMP_XML_ELEMENTS%ROWTYPE;
818:
819: BEGIN
820:
821: --

Line 1064: -- Function Takes an XML as a CLOB, parses and stores it into the "AMS_IMP_XML_ELEMENTS" table

1060: -- Start of comments
1061: -- API Name Store_XML_Elements
1062: -- Type Private
1063: -- Pre-reqs None.
1064: -- Function Takes an XML as a CLOB, parses and stores it into the "AMS_IMP_XML_ELEMENTS" table
1065: -- and "AMS_IMP_XML_ATTRIBUTES" table.
1066: -- Parameters
1067: -- IN
1068: -- p_xml_content CLOB Required

Line 1232: l_xml_element_rec AMS_IMP_XML_ELEMENTS%ROWTYPE;

1228: p_value IN OUT NOCOPY VARCHAR2,
1229: p_result_doc IN OUT NOCOPY xmldom.DOMDocument
1230: )
1231: IS
1232: l_xml_element_rec AMS_IMP_XML_ELEMENTS%ROWTYPE;
1233: l_col_name VARCHAR2(2000);
1234: l_cur_col_name VARCHAR2(2000);
1235: l_child_list xmldom.DOMNodeList;
1236: l_num_children NUMBER;

Line 1377: INSERT INTO AMS_IMP_XML_ELEMENTS (

1373: p_order_init => l_xml_element_rec.ORDER_INITIAL,
1374: p_xml_doc_id => l_xml_element_rec.IMP_XML_DOCUMENT_ID,
1375: p_commit => p_commit);
1376:
1377: INSERT INTO AMS_IMP_XML_ELEMENTS (
1378: IMP_XML_ELEMENT_ID,
1379: LAST_UPDATED_BY,
1380: OBJECT_VERSION_NUMBER,
1381: CREATED_BY,

Line 1394: AMS_IMP_XML_ELEMENTS_S.NEXTVAL,

1390: NUM_ATTR,
1391: LOAD_STATUS,
1392: DATA_TYPE)
1393: VALUES (
1394: AMS_IMP_XML_ELEMENTS_S.NEXTVAL,
1395: FND_GLOBAL.User_ID,
1396: 1.0,
1397: FND_GLOBAL.User_ID,
1398: FND_GLOBAL.Conc_Login_ID,