APPS.ICX_CAT_UTIL_PVT SQL Statements

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

Line: 22

    SELECT oracle_username
    INTO g_apps_schema_name
    FROM fnd_oracle_userid
    WHERE read_only_flag = 'U';

Line: 139

    SELECT key, index_num1, index_num2,
           index_char1, index_char2,
           char1, char2, char3
    FROM po_session_gt
    WHERE key = p_key;

Line: 171

    l_key_tbl.DELETE;

Line: 172

    l_index_num1_tbl.DELETE;

Line: 173

    l_index_num2_tbl.DELETE;

Line: 174

    l_index_char1_tbl.DELETE;

Line: 175

    l_index_char2_tbl.DELETE;

Line: 176

    l_char1_tbl.DELETE;

Line: 177

    l_char2_tbl.DELETE;

Line: 178

    l_char3_tbl.DELETE;

Line: 228

    SELECT inventory_item_id, organization_id, revision_id,
           category_id, category_set_id
    FROM mtl_item_bulkload_recs
    WHERE request_id = p_request_id;

Line: 256

    l_inventory_item_id_tbl.DELETE;

Line: 257

    l_organization_id_tbl.DELETE;

Line: 258

    l_revision_id_tbl.DELETE;

Line: 259

    l_category_id_tbl.DELETE;

Line: 260

    l_category_set_id_tbl.DELETE;

Line: 476

  SELECT to_number(external_source_key)
  INTO l_po_category_id
  FROM icx_por_category_order_map
  WHERE rt_category_id = p_category_id;

Line: 498

  SELECT icx_cat_items_ctx_requestid_s.nextval
  INTO   l_internal_request_id
  FROM   dual;

Line: 611

  SELECT language_code
  INTO   g_base_language
  FROM   fnd_languages
  WHERE  installed_flag='B';

Line: 636

  SELECT category_set_id,
         validate_flag,
         structure_id
  INTO   g_category_set_id,
         g_validate_flag,
         g_structure_id
  FROM   mtl_default_sets_view
  WHERE  functional_area_id = 2;

Line: 669

  SELECT application_column_name
  BULK COLLECT INTO l_appl_column_name_tbl
  FROM fnd_id_flex_segments
  WHERE application_id = 401
  AND id_flex_code   = 'MSTK'
  AND id_flex_num    = 101
  AND enabled_flag   = 'Y'
  ORDER BY segment_num;

Line: 679

  SELECT concatenated_segment_delimiter
  INTO   l_delimiter
  FROM   fnd_id_flex_structures
  WHERE  application_id = 401
  AND    id_flex_code   = 'MSTK'
  AND    id_flex_num    = 101
  AND    enabled_flag   = 'Y';

Line: 722

  SELECT NVL(MIN(job_number), 1)
  INTO   l_upgrade_job_number
  FROM   icx_cat_r12_upgrade_jobs;

Line: 834

    SELECT start_date_active, end_date_active, disable_date
    INTO l_start_date, l_end_date, l_disable_date
    FROM mtl_categories_kfv
    WHERE category_id = p_category_id;

Line: 884

  SELECT prh.inactive_date, prl.po_line_id
  INTO l_inactive_date, l_po_line_id
  FROM po_reqexpress_headers_all prh, po_reqexpress_lines_all prl
  WHERE prh.express_name = p_req_template_name
  AND prh.org_id = p_org_id
  AND prl.express_name = prh.express_name
  AND prl.org_id = prh.org_id
  AND prl.sequence_num = TO_NUMBER(p_req_template_line_num);

Line: 927

  SELECT 1
  INTO l_status
  FROM po_headers_all ph, po_lines_all pl
  WHERE pl.po_line_id = p_po_line_id
  AND ph.po_header_id = pl.po_header_id
  AND ph.approved_date IS NOT NULL
  AND ph.authorization_status NOT IN ('REJECTED', 'INCOMPLETE')
  AND NVL(ph.user_hold_flag, 'N') <> 'Y'
  AND NVL(ph.cancel_flag, 'N') <> 'Y'
  AND NVL(ph.frozen_flag, 'N') <> 'Y'
  AND NVL(ph.closed_code, 'OPEN') NOT IN ('CLOSED', 'FINALLY CLOSED')
  AND NVL(pl.closed_code, 'OPEN') NOT IN ('CLOSED', 'FINALLY CLOSED')
  AND NVL(pl.cancel_flag, 'N') <> 'Y'
  AND TRUNC(SYSDATE) BETWEEN NVL(TRUNC(ph.start_date), TRUNC( SYSDATE - 1))
      AND NVL(TRUNC(ph.end_date), TRUNC( SYSDATE + 1))
  AND TRUNC(SYSDATE) <= NVL(TRUNC(pl.expiration_date), TRUNC( SYSDATE+1));

Line: 970

  SELECT 1
  INTO l_status
  FROM po_headers_all ph, po_lines_all pl
  WHERE pl.po_line_id = p_po_line_id
  AND ph.po_header_id = pl.po_header_id
  AND ph.status_lookup_code = 'A'
  AND ph.quotation_class_code = 'CATALOG'
  AND TRUNC(SYSDATE) BETWEEN NVL(TRUNC(ph.start_date), TRUNC( SYSDATE - 1))
      AND NVL(TRUNC(ph.end_date), TRUNC( SYSDATE + 1))
  AND (NVL(ph.approval_required_flag, 'N') = 'N'
       OR
       (ph.approval_required_flag = 'Y' AND
        EXISTS (SELECT 'current approved effective price break'
                FROM po_line_locations_all pll, po_quotation_approvals_all pqa
                WHERE pl.po_line_id = pll.po_line_id
                AND SYSDATE BETWEEN NVL(pll.start_date, SYSDATE-1) AND
                                    NVL(pll.end_date, SYSDATE+1)
                AND pqa.line_location_id = pll.line_location_id
                AND pqa.approval_type IS NOT NULL
                AND SYSDATE BETWEEN NVL(pqa.start_date_active, SYSDATE-1)
                    AND NVL(pqa.end_date_active, SYSDATE+1))));