APPS.IEC_SQL_LOGGER_PVT SQL Statements

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

Line: 15

      select IEO_LNA_RECORDS_S1.nextval into G_SEQ_NUM from dual;

Line: 44

  l_last_updated_by NUMBER;

Line: 46

  l_last_update_login NUMBER;

Line: 62

      l_last_updated_by := NVL(FND_GLOBAL.conc_login_id,-1);

Line: 64

      l_last_update_login := NVL(FND_GLOBAL.conc_login_id,-1);

Line: 68

       Select SOURCE_ID, LOG_LEVEL into l_source_id, l_log_level
         from IEO_LNA_SOURCES
        where facility_guid = P_FACILITY_GUID
          and facility_name_msg_name = P_FACILITY_NAME_MSG_NAME
          and facility_instance = P_FACILITY_INSTANCE
          and facility_instance_uid = P_FACILITY_INSTANCE_UID
          and ip_address = P_IP_ADDRESS
          and hostname = P_HOSTNAME
          and os_user_name = P_OS_USER_NAME;

Line: 83

          update ieo_lna_sources
             set log_level = P_LOG_LEVEL,
                 last_update_date = sysdate,
                 last_update_login = l_last_update_login
           where source_id = l_source_id;

Line: 99

            insert into IEO_LNA_SOURCES (
                   SOURCE_ID,
                   CREATED_BY,
                   CREATION_DATE,
                   LAST_UPDATED_BY,
                   LAST_UPDATE_DATE,
                   LAST_UPDATE_LOGIN,
                   FACILITY_GUID,
                   FACILITY_NAME_MSG_NAME,
                   FACILITY_RESOURCE_GUID,
                   FACILITY_INSTANCE,
                   FACILITY_INSTANCE_UID,
                   IP_ADDRESS,
                   HOSTNAME,
                   OS_USER_NAME,
                   LOG_LEVEL
                   )
                   VALUES (
                   IEO_LNA_SOURCES_S1.NEXTVAL,
                   l_created_by,
                   l_date1,
                   l_last_updated_by,
                   l_date2,
                   l_last_update_login,
                   P_FACILITY_GUID,
                   P_FACILITY_NAME_MSG_NAME,
                   P_APP_ID,
                   P_FACILITY_INSTANCE,
                   P_FACILITY_INSTANCE_UID,
                   P_IP_ADDRESS,
                   P_HOSTNAME,
                   P_OS_USER_NAME,
                   P_LOG_LEVEL
                   )
            RETURNING SOURCE_ID into l_source_id;

Line: 192

  l_last_updated_by NUMBER;

Line: 194

  l_last_update_login NUMBER;

Line: 204

    select 1 into l_log
         from ieo_lna_sources
        where log_level >= P_LOG_LEVEL
          and source_id = P_SOURCE_ID;

Line: 220

          l_last_updated_by := NVL(FND_GLOBAL.conc_login_id,-1);

Line: 222

          l_last_update_login := NVL(FND_GLOBAL.conc_login_id,-1);

Line: 224

          insert into ieo_lna_records ( record_id,
					created_by,
          				creation_date,
					last_updated_by,
					last_update_date,
					last_update_login,
          				source_id,
					timestamp,
					timestamp_milli,
					action_id,
					severity_id,
          				title_msg_name,
					title_resource_guid,
					xml_data  )
				values ( get_next_record_id,
					l_created_by,
					l_date1,
				  	l_last_updated_by,
					l_date2,
					l_last_update_login,
					P_SOURCE_ID,
           				P_TIMESTAMP,
					P_TIMESTAMP_MILLI,
					P_ACTION_ID,
					P_SEVERITY_ID,
					P_TITLE_MSG_NAME,
           				P_TITLE_MSG_APP_NAME,
					P_MESSAGE )
				RETURNING RECORD_ID into l_record_id;

Line: 289

  l_last_updated_by NUMBER;

Line: 291

  l_last_update_login NUMBER;

Line: 302

    select 1 into l_log
      from ieo_lna_records
     where record_id = P_RECORD_ID;

Line: 316

              l_last_updated_by := NVL(FND_GLOBAL.conc_login_id,-1);

Line: 318

              l_last_update_login := NVL(FND_GLOBAL.conc_login_id,-1);

Line: 321

               insert into ieo_lna_descriptions ( record_id,
						desc_pos,
						created_by,
						creation_date,
						last_updated_by,
						last_update_date,
						last_update_login,
                  				desc_msg_name,
						desc_resource_guid )
					values ( P_record_id,
						P_desc_pos,
						l_created_by,
                   				l_date1,
						l_last_updated_by,
						l_date2,
						l_last_update_login,
						P_desc_msg_name,
						P_desc_msg_app_name );

Line: 377

    select 1 into l_log
      from ieo_lna_records
     where record_id = P_RECORD_ID;

Line: 442

  l_last_updated_by NUMBER;

Line: 444

  l_last_update_login NUMBER;

Line: 455

    select 1 into l_log
      from ieo_lna_records
     where record_id = P_RECORD_ID;

Line: 469

          l_last_updated_by := NVL(FND_GLOBAL.conc_login_id,-1);

Line: 471

          l_last_update_login := NVL(FND_GLOBAL.conc_login_id,-1);

Line: 473

          insert into ieo_lna_parameters ( record_id,
					desc_pos,
					param_pos,
					created_by,
           				creation_date,
					last_updated_by,
					last_update_date,
					last_update_login,
           				pname_msg_name,
					pname_resource_guid,
					value_type,
					value )
				values ( P_record_id,
					P_desc_pos,
					p_param_pos,
           				l_created_by,
					l_date1,
					l_last_updated_by,
           				l_date2,
					l_last_update_login,
					P_param_msg_name,
					P_param_msg_app_name,
					P_value_type,
					P_value );

Line: 540

    select 1 into l_log
      from ieo_lna_records
     where record_id = P_RECORD_ID;