APPS.CZ_OM_ATP_CALLBACK SQL Statements

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

Line: 74

    g_atp_rec.Insert_Flag.extend(l_count);

Line: 202

      g_atp_rec.insert_flag(l_atp_rec_index) := p_mc_atp_rec.insert_flag(i);

Line: 254

  SELECT UPPER(pick_components_flag) INTO l_pto_flag
  FROM mtl_system_items_b
  WHERE inventory_item_id = p_top_item_id AND organization_id = p_organization_id;

Line: 265

      SELECT UPPER(pick_components_flag) INTO l_pto_flag
      FROM mtl_system_items_b
      WHERE inventory_item_id = g_atp_rec.inventory_item_id(i)
      AND organization_id = p_organization_id;

Line: 289

        l_itm_tbl.DELETE;

Line: 290

        l_qty_tbl.DELETE;

Line: 291

        l_uom_tbl.DELETE;

Line: 294

        SELECT component_item_id, extended_quantity, primary_uom_code
        BULK COLLECT INTO l_itm_tbl, l_qty_tbl, l_uom_tbl
        FROM bom_explosions
        WHERE explosion_type = EXPLODE_TYPE_INCLUDED
        AND plan_level > 0
        AND extended_quantity > 0
        AND TOP_BILL_SEQUENCE_ID =
            (SELECT bill_sequence_id
             FROM bom_bill_of_materials
             WHERE assembly_item_id = g_atp_rec.inventory_item_id(i)
             AND organization_id = p_organization_id
             AND ALTERNATE_BOM_DESIGNATOR IS NULL)
        AND EFFECTIVITY_DATE <= SYSDATE AND DISABLE_DATE > SYSDATE; -- AND check_atp = 1?

Line: 350

  g_atp_rec.insert_flag(p_counter) := null;

Line: 389

      SELECT atp_request_id, seq_no, ps_node_id, item_key, item_key_type,
             quantity, uom_code, config_item_id, parent_config_item_id,
             ato_config_item_id, component_sequence_id
      FROM cz_atp_requests
      WHERE configurator_session_key = p_config_session_key
      ORDER BY seq_no;

Line: 397

    CURSOR update_atp_requests IS
      SELECT * FROM cz_atp_requests WHERE configurator_session_key
             = p_config_session_key ORDER BY seq_no FOR UPDATE OF
             ship_to_date, msg_data;

Line: 407

    l_atp_update_row update_atp_requests%ROWTYPE;

Line: 475

    SELECT count(*) INTO l_atp_row_count FROM cz_atp_requests
    WHERE configurator_session_key = p_config_session_key;

Line: 632

          SELECT meaning INTO l_atp_rec.message(i)
          FROM mfg_lookups
          WHERE lookup_type = 'MTL_DEMAND_INTERFACE_ERRORS'
            AND lookup_code = g_atp_rec.error_code(i);

Line: 655

    FOR l_atp_update_row IN update_atp_requests LOOP
      -- no date should be displayed if error code is -99
      if (g_atp_rec.error_code(l_counter) = -99) then
        l_ship_date := null;

Line: 675

      UPDATE cz_atp_requests SET msg_data = l_atp_rec.message(l_counter),
                                 ship_to_date = l_ship_date
      WHERE CURRENT OF update_atp_requests;

Line: 688

      SELECT pick_components_flag INTO l_pto_model_flag
      FROM mtl_system_items
      WHERE inventory_item_id = g_atp_rec.inventory_item_id(1)
      AND organization_id = l_validation_org;

Line: 717

      UPDATE cz_atp_requests SET msg_data = 'Error in executing MSC_SATP_FUNC.extend_atp'
      WHERE configurator_session_key = p_config_session_key
      AND seq_no = 1;

Line: 727

       UPDATE cz_atp_requests SET msg_data = 'Error in executing oe_sys_parameters.value for ' ||
                                             'MASTER_ORGANIZATION_ID: Null value returned'
       WHERE configurator_session_key = p_config_session_key
       AND seq_no = 1;

Line: 738

      UPDATE cz_atp_requests SET msg_data =
        'Mandatory comp expl error: ' || l_mc_error
      WHERE configurator_session_key = p_config_session_key
        AND seq_no = 1;

Line: 746

      UPDATE cz_atp_requests SET msg_data = CZ_UTILS.GET_TEXT('CZ_ATP_NO_WAREHOUSE')
      WHERE configurator_session_key = p_config_session_key
        AND seq_no = 1;

Line: 755

      UPDATE cz_atp_requests SET msg_data = l_msg_data
      WHERE configurator_session_key = p_config_session_key
        AND seq_no = 1;

Line: 766

      UPDATE cz_atp_requests SET msg_data =
          'Unexpected error in cz_om_atp_callback returned from mrp_atp_pub: ' || l_msg_data
      WHERE configurator_session_key = p_config_session_key
        AND seq_no = 1;

Line: 777

      UPDATE cz_atp_requests SET msg_data = l_msg_data
      WHERE configurator_session_key = p_config_session_key
        AND seq_no = 1;