APPS.IEX_SEND_XML_PVT SQL Statements

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

Line: 48

      SELECT cust_account_id, customer_site_use_id
        FROM IEX_DELINQUENCIES
       WHERE delinquency_ID = in_del_ID;

Line: 53

      SELECT template_code,
             default_language,
             default_territory
        FROM XDO_TEMPLATES_VL
       WHERE template_id = in_TEMP_ID
         --AND Application_id = 695;

Line: 233

       WriteLog(l_msg || ' insert_row' );

Line: 236

       IEX_XML_PKG.insert_row (
          px_rowid                  => l_rowid
         ,px_xml_request_id         => l_request_id
         ,p_query_temp_id           => p_query_id
         ,p_status                  => 'XMLDATA'
         ,p_document                => l_doc
         ,p_xmldata                 => l_content_xml
         ,p_method                  => p_method
         ,p_destination             => p_dest
         ,p_object_type             => p_object_type
         ,p_object_id               => p_object_id
         ,p_resource_id             => p_resource_id
         ,p_view_by                 => p_level
         ,p_party_id                => l_party_id
         ,p_cust_account_id         => l_account_id
         ,p_cust_site_use_id        => l_site_id
         ,p_delinquency_id          => l_delinquency_id
         ,p_last_update_date        => sysdate
         ,p_last_updated_by         => l_user_id
         ,p_creation_date           => sysdate
         ,p_created_by              => l_user_id
         ,p_last_update_login       => l_user_id
         ,p_object_version_number   => l_user_id
       );

Line: 296

		select iso_language
		into l_iso_lang1
		from fnd_languages
		where language_code= upper(l_lang);

Line: 303

		select count(distinct territory)
		into l_no_terr
		from xdo_lobs
		where application_short_name='IEX' and upper(language)=l_iso_lang1;

Line: 314

			select distinct territory
			into l_templ_terr1
			from xdo_lobs
			where application_short_name='IEX' and upper(language)=l_iso_lang1;

Line: 362

			select language
			into l_loc_lang
			from hz_locations
			where location_id= to_number(l_bind_val);

Line: 370

				select iso_language
				into l_iso_lang
				from fnd_languages
				where language_code= upper(l_loc_lang);

Line: 377

				select count(distinct territory)
				into l_no_terr
				from xdo_lobs
				where application_short_name='IEX' and upper(language)=l_iso_lang;

Line: 388

					select distinct territory
					into l_templ_terr
					from xdo_lobs
					where application_short_name='IEX' and upper(language)=l_iso_lang;

Line: 460

       IEX_XML_PKG.update_row (
          p_xml_request_id          => l_request_id
         ,p_status                  => l_return_status
         --,p_document                => l_doc
       );

Line: 494

               IEX_XML_PKG.update_row (
                 p_xml_request_id          => l_request_id
                ,p_status                  => l_status
               );

Line: 510

               IEX_XML_PKG.update_row (
                 p_xml_request_id          => l_request_id
                ,p_status                  => l_status
               );

Line: 526

               IEX_XML_PKG.update_row (
                 p_xml_request_id          => l_request_id
                ,p_status                  => l_status
               );

Line: 552

      SELECT xmldata
        FROM IEX_XML_REQUEST_HISTORIES
       WHERE xml_request_id = in_request_id;

Line: 638

      SELECT UPPER(ADDITIONAL_QUERY), UPPER(STATEMENT)
        FROM IEX_XML_QUERIES
       WHERE query_id = in_query_id
         and trunc(sysdate) between trunc(nvl(start_date, sysdate)) and
             trunc(nvl(end_date, sysdate))
         and enabled_flag = 'Y';

Line: 935

     l_dataHdrQry := 'SELECT '||l_dataHeader||'  FROM DUAL';

Line: 1008

      SELECT NVL(PREFERENCE_VALUE, 'FFM')
        FROM IEX_APP_PREFERENCES_VL
       WHERE PREFERENCE_NAME= 'COLLECTIONS DELIVERY METHOD';