DBA Data[Home] [Help]

APPS.AMS_IMPORT_XML_PVT dependencies on AMS_IMP_XML_ATTRIBUTES

Line 1065: -- and "AMS_IMP_XML_ATTRIBUTES" table.

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
1069: -- OUT x_return_status VARCHAR2

Line 1433: l_xml_attribute_rec AMS_IMP_XML_ATTRIBUTES%ROWTYPE;

1429: p_xml_doc_id IN NUMBER,
1430: p_commit IN VARCHAR2 := FND_API.G_FALSE
1431: ) RETURN NUMBER
1432: IS
1433: l_xml_attribute_rec AMS_IMP_XML_ATTRIBUTES%ROWTYPE;
1434: l_num_attr NUMBER := 0;
1435: l_att_seq NUMBER := 1;
1436: --l_element xmldom.DOMElement;
1437: l_attr_map xmldom.DOMNamedNodeMap;

Line 1452: INSERT INTO AMS_IMP_XML_ATTRIBUTES (

1448: l_xml_attribute_rec.ATT_NAME := xmldom.getNodeName (l_node);
1449: l_xml_attribute_rec.ATT_VALUE := xmldom.getNodeValue (l_node);
1450: l_xml_attribute_rec.ATT_SEQ := i + 1;
1451:
1452: INSERT INTO AMS_IMP_XML_ATTRIBUTES (
1453: IMP_XML_ATTRIBUTE_ID,
1454: LAST_UPDATED_BY,
1455: OBJECT_VERSION_NUMBER,
1456: CREATED_BY,

Line 1467: AMS_IMP_XML_ATTRIBUTES_S.NEXTVAL,

1463: ATT_SEQ,
1464: ATT_NAME,
1465: ATT_VALUE)
1466: VALUES (
1467: AMS_IMP_XML_ATTRIBUTES_S.NEXTVAL,
1468: FND_GLOBAL.User_ID,
1469: 1.0,
1470: FND_GLOBAL.User_ID,
1471: FND_GLOBAL.Conc_Login_ID,