APPS.ICX_POR_EXTRACTOR SQL Statements

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

Line: 12

    'Update last run dates');

Line: 16

    UPDATE ICX_POR_LOADER_VALUES
    SET    vendor_last_run_date = gLastRunDate;

Line: 23

    UPDATE ICX_POR_LOADER_VALUES
    SET    categories_last_run_date =
           gLoaderValue.categories_last_run_date;

Line: 31

    UPDATE ICX_POR_LOADER_VALUES
    SET    template_headers_last_run_date =
           gLoaderValue.template_headers_last_run_date;

Line: 39

    UPDATE icx_por_loader_values
    SET    template_lines_last_run_date =
           gLoaderValue.template_lines_last_run_date;

Line: 47

    UPDATE icx_por_loader_values
    SET    contracts_last_run_date =
           gLoaderValue.contracts_last_run_date;

Line: 58

    UPDATE icx_por_loader_values
    SET    item_master_last_run_date =
           gLoaderValue.item_master_last_run_date,
           internal_item_last_run_date =
           gLoaderValue.internal_item_last_run_date;

Line: 106

    select icx_por_batch_jobs_s.nextval
    into   gRequestId
    from   dual;

Line: 137

  select nvl(load_catalog_groups, 'N'),
         nvl(load_categories, 'N'),
         nvl(load_template_headers, 'N'),
         'Y',
         nvl(load_item_master, 'N'),
         nvl(load_template_lines, 'N'),
         catalog_groups_last_run_date,
         categories_last_run_date,
         template_headers_last_run_date,
         contracts_last_run_date,
         item_master_last_run_date,
         template_lines_last_run_date,
         vendor_last_run_date,
         nvl(load_internal_item, 'N'),
         internal_item_last_run_date,
         nvl(cleanup_flag, 'N'),
         nvl(load_onetimeitems_in_all_langs, 'N')  -- Bug # 3991430
    into gLoaderValue.load_catalog_groups,
         gLoaderValue.load_categories,
         gLoaderValue.load_template_headers,
         gLoaderValue.load_contracts,
         gLoaderValue.load_item_master,
         gLoaderValue.load_template_lines,
         gLoaderValue.catalog_groups_last_run_date,
         gLoaderValue.categories_last_run_date,
         gLoaderValue.template_headers_last_run_date,
         gLoaderValue.contracts_last_run_date,
         gLoaderValue.item_master_last_run_date,
         gLoaderValue.template_lines_last_run_date,
         gLoaderValue.vendor_last_run_date,
         gLoaderValue.load_internal_item,
         gLoaderValue.internal_item_last_run_date,
         gLoaderValue.cleanup_flag,
	 gLoaderValue.load_onetimeitems_all_langs  -- Bug # 3991430
    from icx_por_loader_values
   where rownum = 1;

Line: 181

  SELECT language_code,
         nls_language
  INTO   gBaseLang,
         gNLSLanguage
  FROM   fnd_languages
  WHERE  installed_flag = 'B';

Line: 190

  select spid "System Process ID"
  into   gSpid
  from   v$process
  where  addr in (select paddr
                  from   v$session
                  where  audsid = userenv('sessionid'));

Line: 237

  SELECT COUNT(*)
    INTO gInstalledLanguageCount
    FROM fnd_languages
   WHERE installed_flag IN ('B', 'I');

Line: 247

    select nvl(f.freeze_flex_definition_flag, 'N')
    into   xFlexFrozenFlag
    from   fnd_id_flex_structures f,
           mtl_default_sets_view m
    where  f.application_id = 401
    and    f.id_flex_code = 'MCAT'
    and    f.id_flex_num = m.structure_id
    and    m.functional_area_id = 2;

Line: 260

      select message_text
      into   xErrMsg
      from   fnd_new_messages
      where  message_name = 'ICX_POR_RECOMPILE_CAT_FLEXFLDS'
      and    language_code = USERENV('LANG');

Line: 278

    select nvl(f.freeze_flex_definition_flag, 'N')
    into   xFlexFrozenFlag
    from   fnd_id_flex_structures f,
           mtl_default_sets_view m
    where  f.application_id = 401
    and    f.id_flex_code = 'MSTK'
    and    f.id_flex_num = 101
    and    rownum = 1;

Line: 291

      select message_text
      into   xErrMsg
      from   fnd_new_messages
      where  message_name = 'ICX_POR_RECOMPILE_ITM_FLEXFLDS'
      and    language_code = USERENV('LANG');

Line: 307

    update icx_cat_items_b it
    SET EXTRACTOR_UPDATED_FLAG = 'N'
    WHERE NOT EXISTS
      (SELECT 1 FROM icx_cat_item_prices itp
       WHERE PRICE_TYPE NOT in ( 'BULKLOAD' , 'CONTRACT')
       AND itp.rt_item_id = it.rt_item_id)
    AND EXTRACTOR_UPDATED_FLAG = 'Y'
    AND trunc(it.PROGRAM_UPDATE_DATE) = trunc(gLastRunDate);

Line: 385

  SELECT language_code,
         nls_language
  INTO   gBaseLang,
         gNLSLanguage
  FROM   fnd_languages
  WHERE  installed_flag = 'B';

Line: 394

  select spid "System Process ID"
  into   gSpid
  from   v$process
  where  addr in (select paddr
                  from   v$session
                  where  audsid = userenv('sessionid'));