APPS.ICX_CAT_SQE_PVT SQL Statements

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

Line: 67

    SELECT icx_cat_sqe_name_s.nextval
    INTO l_sqe_sequence
    FROM dual;

Line: 98

      INSERT INTO icx_cat_deleted_sqes (sqe_sequence, created_by, creation_date,
        last_updated_by, last_update_date, last_update_login)
      VALUES (x_sqe_sequence,  fnd_global.user_id, sysdate, fnd_global.user_id,
          sysdate, fnd_global.login_id);

Line: 104

        l_log_string := 'Inserted old sqe sequence into deleted sqes. Old sqe sequence: ' || x_sqe_sequence;

Line: 115

    purge_deleted_sqes;

Line: 591

      SELECT distinct rt_category_id
      BULK COLLECT INTO l_category_ids
      FROM icx_cat_categories_tl
      WHERE type = 2
      AND rt_category_id in (SELECT child_category_id
                             FROM icx_cat_browse_trees
                             START WITH parent_category_id = p_category_ids(i)
                             CONNECT BY NOCYCLE PRIOR child_category_id = parent_category_id
                             UNION ALL
                             SELECT p_category_ids(i)
                             FROM dual);

Line: 695

PROCEDURE purge_deleted_sqes
IS
  l_api_name CONSTANT VARCHAR2(30) := 'purge_deleted_sqes';

Line: 703

    l_log_string := 'Starting purge_deleted_sqes';

Line: 711

  SELECT sqe_sequence
  BULK COLLECT INTO l_sqe_sequences
  FROM icx_cat_deleted_sqes
  WHERE creation_date < sysdate - 1;

Line: 745

    DELETE FROM icx_cat_deleted_sqes
    WHERE sqe_sequence = l_sqe_sequences(i);

Line: 750

    l_log_string := 'End purge_deleted_sqes';

Line: 759

     'Exception at ICX_CAT_SQE_PVT.purge_deleted_sqes(' ||
     l_err_loc || '), ' || SQLERRM);

Line: 761

END purge_deleted_sqes;

Line: 804

  SELECT zones.zone_id, zonestl.name, supplier_attribute_action_flag, category_attribute_action_flag,
    items_without_supplier_flag, items_without_shop_catg_flag, sqe_sequence
  BULK COLLECT INTO l_content_zone_ids, l_content_zone_names, l_supplier_attr_action_flags,
    l_category_attr_action_flags, l_items_without_supplier_flags, l_items_without_shop_cat_flags, l_sqe_sequences
  FROM icx_cat_content_zones_b zones, icx_cat_content_zones_tl zonestl
  WHERE zones.type = 'LOCAL'
  AND zones.category_attribute_action_flag IN ('INCLUDE', 'EXCLUDE')
  AND zones.zone_id = zonestl.zone_id
  AND zonestl.language = USERENV('LANG');

Line: 819

    SELECT ip_category_id
    BULK COLLECT INTO l_category_ids
    FROM icx_cat_zone_secure_attributes
    WHERE zone_id = l_content_zone_ids(i)
    AND securing_attribute = 'CATEGORY';

Line: 827

    SELECT supplier_id, supplier_site_id
    BULK COLLECT INTO l_supplier_ids, l_supplier_site_ids
    FROM icx_cat_zone_secure_attributes
    WHERE zone_id = l_content_zone_ids(i)
    AND securing_attribute = 'SUPPLIER';

Line: 876

    UPDATE icx_cat_content_zones_b
    SET sqe_sequence = l_sqe_sequences(i)
    WHERE zone_id = l_content_zone_ids(i);

Line: 930

  ICX_CAT_SCHEMA_UPLOAD_PVT.update_job_status(l_request_id, 'RUNNING');

Line: 947

    ICX_CAT_SCHEMA_UPLOAD_PVT.update_job_status(l_request_id, 'ERROR');

Line: 953

    INSERT INTO icx_por_failed_line_messages
      (job_number, descriptor_key, message_name, token_list, line_number, request_id, program_id,
      program_application_id, program_login_id)
    VALUES (l_request_id, 'OTHER',  'ICX_CAT_CANNOT_UPDATE_CZS_ERR', l_token_list, 1, l_request_id,
      fnd_global.conc_program_id, fnd_global.prog_appl_id, fnd_global.conc_login_id);

Line: 961

    ICX_CAT_SCHEMA_UPLOAD_PVT.update_job_status(l_request_id, 'COMPLETED');

Line: 983

  ICX_CAT_SCHEMA_UPLOAD_PVT.update_job_status(l_request_id, 'ERROR');

Line: 985

  INSERT INTO icx_por_failed_line_messages
    (job_number, descriptor_key, message_name, token_list, line_number, request_id, program_id,
     program_application_id, program_login_id)
  VALUES (l_request_id, 'OTHER',  'ICX_CAT_HIER_UNEXPECTED_ERR', l_token_list, 1, l_request_id,
    fnd_global.conc_program_id, fnd_global.prog_appl_id, fnd_global.conc_login_id);

Line: 1031

    INSERT INTO icx_por_failed_line_messages
      (job_number, descriptor_key, message_name, token_list, line_number, request_id, program_id,
      program_application_id, program_login_id)
    VALUES (p_request_id, 'ICX_CAT_CONTENT_ZONES',  'ICX_CAT_CANNOT_UPDATE_ZONES', null, p_line_number, p_request_id,
      fnd_global.conc_program_id, fnd_global.prog_appl_id, fnd_global.conc_login_id);

Line: 1038

    INSERT INTO icx_por_failed_lines
      (job_number, line_number, action, row_type, descriptor_key, descriptor_value,
      request_id, program_id, program_application_id, program_login_id)
    VALUES (p_request_id, p_line_number, p_action, 'RELATIONSHIP', 'ICX_CAT_CONTENT_ZONES',
      l_errored_zone_name_list, p_request_id, fnd_global.conc_program_id,
      fnd_global.prog_appl_id, fnd_global.conc_login_id);

Line: 1097

  SELECT zones.zone_id, zonestl.name, supplier_attribute_action_flag, category_attribute_action_flag,
    items_without_supplier_flag, items_without_shop_catg_flag, sqe_sequence
  BULK COLLECT INTO l_content_zone_ids, l_content_zone_names, l_supplier_attr_action_flags,
    l_category_attr_action_flags, l_items_without_supplier_flags, l_items_without_shop_cat_flags, l_sqe_sequences
  FROM icx_cat_content_zones_b zones, icx_cat_content_zones_tl zonestl
  WHERE zones.type = 'LOCAL'
  AND zones.zone_id = zonestl.zone_id
  AND zonestl.language = USERENV('LANG');

Line: 1111

    SELECT ip_category_id
    BULK COLLECT INTO l_category_ids
    FROM icx_cat_zone_secure_attributes
    WHERE zone_id = l_content_zone_ids(i)
    AND securing_attribute = 'CATEGORY';

Line: 1119

    SELECT supplier_id, supplier_site_id
    BULK COLLECT INTO l_supplier_ids, l_supplier_site_ids
    FROM icx_cat_zone_secure_attributes
    WHERE zone_id = l_content_zone_ids(i)
    AND securing_attribute = 'SUPPLIER';

Line: 1167

    UPDATE icx_cat_content_zones_b
    SET sqe_sequence = l_sqe_sequences(i)
    WHERE zone_id = l_content_zone_ids(i);