APPS.AMS_IMPORT_XML_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 38

      SELECT e3.*
      FROM ams_imp_xml_elements e3
      START WITH e3.imp_xml_document_id = p_imp_doc_id
      AND e3.order_initial = p_order_initial + 1
      CONNECT BY e3.imp_xml_document_id = p_imp_doc_id
      AND PRIOR order_final + 1 = order_initial;

Line: 53

	SELECT *
	FROM ams_imp_xml_elements
	WHERE IMP_XML_ELEMENT_ID = p_imp_xml_element_id;

Line: 67

	--insert into ams_xml_test1 values (G_COUNT || p_msg);

Line: 159

	IS SELECT ORDER_INITIAL, ORDER_FINAL
	FROM AMS_IMP_XML_ELEMENTS
	WHERE IMP_XML_ELEMENT_ID = p_xml_element_id;

Line: 226

	SELECT FILE_TYPE
	FROM AMS_IMP_DOCUMENTS
	WHERE IMPORT_LIST_HEADER_ID = p_import_list_header_id;

Line: 284

		SELECT *
		FROM AMS_IMP_XML_ELEMENTS
		WHERE ORDER_INITIAL = G_ORDER_INITIAL_START_NUMBER
		AND EXISTS (SELECT 1
		FROM AMS_IMP_DOCUMENTS
		WHERE AMS_IMP_DOCUMENTS.IMPORT_LIST_HEADER_ID = p_import_list_header_id
		AND AMS_IMP_DOCUMENTS.IMP_DOCUMENT_ID = AMS_IMP_XML_ELEMENTS.IMP_XML_DOCUMENT_ID);

Line: 344

		SELECT IMP_XML_ELEMENT_ID,
		IMP_XML_DOCUMENT_ID,
		ORDER_INITIAL
		FROM AMS_IMP_XML_ELEMENTS
		WHERE IMP_XML_ELEMENT_ID = p_xml_element_id;

Line: 351

		SELECT *
		FROM AMS_IMP_XML_ELEMENTS
		WHERE IMP_XML_DOCUMENT_ID = p_xml_doc_id
		AND ORDER_INITIAL = p_order_initial + 1;

Line: 417

		SELECT IMP_XML_ELEMENT_ID,
		IMP_XML_DOCUMENT_ID,
		ORDER_FINAL
		FROM AMS_IMP_XML_ELEMENTS
		WHERE IMP_XML_ELEMENT_ID = p_xml_element_id;

Line: 425

		SELECT *
		FROM AMS_IMP_XML_ELEMENTS
		WHERE IMP_XML_DOCUMENT_ID = p_xml_doc_id
		AND ORDER_INITIAL = p_order_final + 1;

Line: 490

		SELECT IMP_XML_ELEMENT_ID,
		IMP_XML_DOCUMENT_ID,
		ORDER_INITIAL,
		ORDER_FINAL
		FROM AMS_IMP_XML_ELEMENTS
		WHERE IMP_XML_ELEMENT_ID = p_xml_element_id;

Line: 500

		SELECT *
		FROM AMS_IMP_XML_ELEMENTS
		WHERE IMP_XML_DOCUMENT_ID = p_xml_doc_id
		--AND ORDER_INITIAL < p_order_initial
		--AND ORDER_FINAL > p_order_final
		AND ORDER_INITIAL =
			(SELECT MAX(ORDER_INITIAL)
			 FROM AMS_IMP_XML_ELEMENTS e2
			 WHERE e2.IMP_XML_DOCUMENT_ID = p_xml_doc_id
			 AND e2.ORDER_INITIAL < p_order_initial
			 AND e2.ORDER_FINAL > p_order_final);

Line: 570

		SELECT IMP_XML_ELEMENT_ID,
		COLUMN_NAME,
		DATA
		FROM AMS_IMP_XML_ELEMENTS
		WHERE IMP_XML_ELEMENT_ID = p_xml_element_id;

Line: 893

		SELECT A.SOURCE_COLUMN_NAME
		FROM ams_list_src_fields A, ams_imp_list_headers_all b
		WHERE b.IMPORT_LIST_HEADER_ID = p_import_list_header_id
		AND b.LIST_SOURCE_TYPE_ID = A.LIST_SOURCE_TYPE_ID
		ORDER BY LIST_SOURCE_FIELD_ID;

Line: 900

		SELECT CONTENT_TEXT, IMP_DOCUMENT_ID
		FROM AMS_IMP_DOCUMENTS
		WHERE IMPORT_LIST_HEADER_ID = p_import_list_header_id;

Line: 958

			SELECT FILTER_CONTENT_TEXT INTO l_result_xml_content
			FROM AMS_IMP_DOCUMENTS
			WHERE IMPORT_LIST_HEADER_ID = p_import_list_header_id
			FOR UPDATE;

Line: 1100

		SELECT A.SOURCE_COLUMN_NAME, A.FIELD_COLUMN_NAME
		FROM ams_list_src_fields A, ams_imp_list_headers_all b
		WHERE b.IMPORT_LIST_HEADER_ID = p_import_list_header_id
		AND b.LIST_SOURCE_TYPE_ID = A.LIST_SOURCE_TYPE_ID
		ORDER BY LIST_SOURCE_FIELD_ID;

Line: 1107

		SELECT CONTENT_TEXT
		FROM AMS_IMP_DOCUMENTS
		WHERE IMPORT_LIST_HEADER_ID = p_import_list_header_id;

Line: 1187

		SELECT FILTER_CONTENT_TEXT INTO l_result_xml_content
		FROM AMS_IMP_DOCUMENTS
		WHERE IMPORT_LIST_HEADER_ID = p_imp_list_header_id
		FOR UPDATE;

Line: 1377

	INSERT INTO AMS_IMP_XML_ELEMENTS (
		IMP_XML_ELEMENT_ID,
		LAST_UPDATED_BY,
		OBJECT_VERSION_NUMBER,
		CREATED_BY,
		LAST_UPDATE_LOGIN,
		LAST_UPDATE_DATE,
		CREATION_DATE,
		IMP_XML_DOCUMENT_ID,
		ORDER_INITIAL,
		ORDER_FINAL,
		COLUMN_NAME,
		DATA,
		NUM_ATTR,
		LOAD_STATUS,
		DATA_TYPE)
	VALUES (
		AMS_IMP_XML_ELEMENTS_S.NEXTVAL,
		FND_GLOBAL.User_ID,
		1.0,
		FND_GLOBAL.User_ID,
		FND_GLOBAL.Conc_Login_ID,
		l_now,
		l_now,
		l_xml_element_rec.IMP_XML_DOCUMENT_ID,
		l_xml_element_rec.ORDER_INITIAL,
		l_xml_element_rec.ORDER_FINAL,
		l_xml_element_rec.COLUMN_NAME,
		l_xml_element_rec.DATA,
		l_xml_element_rec.NUM_ATTR,
		'ACTIVE',
		l_xml_element_rec.DATA_TYPE);

Line: 1452

			INSERT INTO AMS_IMP_XML_ATTRIBUTES (
			IMP_XML_ATTRIBUTE_ID,
			LAST_UPDATED_BY,
			OBJECT_VERSION_NUMBER,
			CREATED_BY,
			LAST_UPDATE_LOGIN,
			LAST_UPDATE_DATE,
			CREATION_DATE,
			--IMP_DOCUMENT_ID,
			IMP_XML_DOCUMENT_ID,
			ORDER_INITIAL,
			ATT_SEQ,
			ATT_NAME,
			ATT_VALUE)
			VALUES (
			AMS_IMP_XML_ATTRIBUTES_S.NEXTVAL,
			FND_GLOBAL.User_ID,
			1.0,
			FND_GLOBAL.User_ID,
			FND_GLOBAL.Conc_Login_ID,
			l_now,
			l_now,
			p_xml_doc_id,
			p_order_init,
			l_xml_attribute_rec.ATT_SEQ,
			l_xml_attribute_rec.ATT_NAME,
			l_xml_attribute_rec.ATT_VALUE);

Line: 1550

	SELECT IMP_DOCUMENT_ID
	FROM AMS_IMP_DOCUMENTS
	WHERE IMPORT_LIST_HEADER_ID = p_import_list_header_id;

Line: 1555

	IS SELECT user_status_id
	FROM ams_user_statuses_vl
	WHERE system_status_type = 'AMS_IMPORT_STATUS'
	AND system_status_code = 'STAGED'
	AND default_flag = 'Y';

Line: 1605

		UPDATE AMS_IMP_LIST_HEADERS_ALL
		SET STATUS_CODE = 'STAGED', USER_STATUS_ID = l_user_status_id
		WHERE IMPORT_LIST_HEADER_ID = p_import_list_header_id;

Line: 1672

	IS SELECT CONTENT_TEXT
	FROM AMS_IMP_DOCUMENTS
	WHERE IMPORT_LIST_HEADER_ID = p_import_list_header_id;